SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002429s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.002848s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003402s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002651s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.000414s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002232s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002302s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.001446s ]
UPDATE `stock_search` SET `count` = 1620 , `updatetime` = '2026-06-06 19:51:10' WHERE `partno` = '210' [ RunTime:0.001542s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000382s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.001125s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002493s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.433788s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.066041s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('12511571','19668156','32277582','32163080','11985897','32267840','11987439','15473454','32446506','32304220','32296094','33462771','12630513','19593483','19668538','35483961','35484103','32277470','32162968','19667794') ORDER BY FIELD(s.id, 12511571,19668156,32277582,32163080,11985897,32267840,11987439,15473454,32446506,32304220,32296094,33462771,12630513,19593483,19668538,35483961,35484103,32277470,32162968,19667794) [ RunTime:0.012452s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12511571 LIMIT 4 [ RunTime:0.011653s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12511571 ORDER BY `minOrder` ASC [ RunTime:0.005402s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12511571 ORDER BY `unit` DESC [ RunTime:0.011446s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12511571 LIMIT 2 [ RunTime:0.020882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12511571 ORDER BY `minOrder` ASC [ RunTime:0.011070s ]
select * from pdf where partno='2108074-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.024146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668156 LIMIT 4 [ RunTime:0.013437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668156 ORDER BY `minOrder` ASC [ RunTime:0.017297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668156 ORDER BY `unit` DESC [ RunTime:0.029285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668156 LIMIT 2 [ RunTime:0.020932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668156 ORDER BY `minOrder` ASC [ RunTime:0.023375s ]
select * from pdf where partno='2106136-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.019633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277582 LIMIT 4 [ RunTime:0.035169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277582 ORDER BY `minOrder` ASC [ RunTime:0.040399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277582 ORDER BY `unit` DESC [ RunTime:0.021718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277582 LIMIT 2 [ RunTime:0.014493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277582 ORDER BY `minOrder` ASC [ RunTime:0.040031s ]
select * from pdf where partno='2106091-3' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.015160s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106091-3' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.017213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163080 LIMIT 4 [ RunTime:0.016265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163080 ORDER BY `minOrder` ASC [ RunTime:0.008095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163080 ORDER BY `unit` DESC [ RunTime:0.014639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163080 LIMIT 2 [ RunTime:0.011508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163080 ORDER BY `minOrder` ASC [ RunTime:0.015701s ]
select * from pdf where partno='2106091-3' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.002181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106091-3' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.008885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11985897 LIMIT 4 [ RunTime:0.007320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985897 ORDER BY `minOrder` ASC [ RunTime:0.012096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11985897 ORDER BY `unit` DESC [ RunTime:0.001893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11985897 LIMIT 2 [ RunTime:0.008729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11985897 ORDER BY `minOrder` ASC [ RunTime:0.012935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267840 LIMIT 4 [ RunTime:0.009097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267840 ORDER BY `minOrder` ASC [ RunTime:0.012120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267840 ORDER BY `unit` DESC [ RunTime:0.004370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267840 LIMIT 2 [ RunTime:0.004851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267840 ORDER BY `minOrder` ASC [ RunTime:0.006576s ]
select * from pdf where partno='2103155-2' and brandshort='te connectivity' limit 1 [ RunTime:0.008965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103155-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.038143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987439 LIMIT 4 [ RunTime:0.009260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987439 ORDER BY `minOrder` ASC [ RunTime:0.005936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11987439 ORDER BY `unit` DESC [ RunTime:0.007292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11987439 LIMIT 2 [ RunTime:0.009295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11987439 ORDER BY `minOrder` ASC [ RunTime:0.002527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15473454 LIMIT 4 [ RunTime:0.009786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473454 ORDER BY `minOrder` ASC [ RunTime:0.002477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15473454 ORDER BY `unit` DESC [ RunTime:0.001968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15473454 LIMIT 2 [ RunTime:0.004687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473454 ORDER BY `minOrder` ASC [ RunTime:0.001167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32446506 LIMIT 4 [ RunTime:0.000938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32446506 ORDER BY `minOrder` ASC [ RunTime:0.004687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32446506 ORDER BY `unit` DESC [ RunTime:0.003983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32446506 LIMIT 2 [ RunTime:0.002692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32446506 ORDER BY `minOrder` ASC [ RunTime:0.004403s ]
select * from pdf where partno='210' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.009165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.009198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304220 LIMIT 4 [ RunTime:0.003073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304220 ORDER BY `minOrder` ASC [ RunTime:0.002416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304220 ORDER BY `unit` DESC [ RunTime:0.036262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304220 LIMIT 2 [ RunTime:0.054335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304220 ORDER BY `minOrder` ASC [ RunTime:0.034923s ]
select * from pdf where partno='2108517-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.022812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108517-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.024784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296094 LIMIT 4 [ RunTime:0.054277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296094 ORDER BY `minOrder` ASC [ RunTime:0.031499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296094 ORDER BY `unit` DESC [ RunTime:0.071329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296094 LIMIT 2 [ RunTime:0.038645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296094 ORDER BY `minOrder` ASC [ RunTime:0.022501s ]
select * from pdf where partno='2108517-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.025807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108517-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.046113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33462771 LIMIT 4 [ RunTime:0.021595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462771 ORDER BY `minOrder` ASC [ RunTime:0.019450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33462771 ORDER BY `unit` DESC [ RunTime:0.001729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33462771 LIMIT 2 [ RunTime:0.001192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33462771 ORDER BY `minOrder` ASC [ RunTime:0.017483s ]
select * from pdf where partno='2103155-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.012744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103155-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.023540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630513 LIMIT 4 [ RunTime:0.011344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630513 ORDER BY `minOrder` ASC [ RunTime:0.007742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12630513 ORDER BY `unit` DESC [ RunTime:0.003547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12630513 LIMIT 2 [ RunTime:0.008240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630513 ORDER BY `minOrder` ASC [ RunTime:0.001673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593483 LIMIT 4 [ RunTime:0.007333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593483 ORDER BY `minOrder` ASC [ RunTime:0.001409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593483 ORDER BY `unit` DESC [ RunTime:0.001333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593483 LIMIT 2 [ RunTime:0.001382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593483 ORDER BY `minOrder` ASC [ RunTime:0.001918s ]
select * from pdf where partno='2104-3-01-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.012645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19668538 LIMIT 4 [ RunTime:0.008047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668538 ORDER BY `minOrder` ASC [ RunTime:0.004606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19668538 ORDER BY `unit` DESC [ RunTime:0.002361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19668538 LIMIT 2 [ RunTime:0.007136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19668538 ORDER BY `minOrder` ASC [ RunTime:0.004472s ]
select * from pdf where partno='2106136-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35483961 LIMIT 4 [ RunTime:0.004413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35483961 ORDER BY `minOrder` ASC [ RunTime:0.002754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35483961 ORDER BY `unit` DESC [ RunTime:0.004323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35483961 LIMIT 2 [ RunTime:0.004437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35483961 ORDER BY `minOrder` ASC [ RunTime:0.003253s ]
select * from pdf where partno='2106136-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106136-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35484103 LIMIT 4 [ RunTime:0.007917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35484103 ORDER BY `minOrder` ASC [ RunTime:0.002196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35484103 ORDER BY `unit` DESC [ RunTime:0.005032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35484103 LIMIT 2 [ RunTime:0.004246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35484103 ORDER BY `minOrder` ASC [ RunTime:0.011158s ]
select * from pdf where partno='2106123-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.008699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106123-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.024157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277470 LIMIT 4 [ RunTime:0.004494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277470 ORDER BY `minOrder` ASC [ RunTime:0.003681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277470 ORDER BY `unit` DESC [ RunTime:0.007476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277470 LIMIT 2 [ RunTime:0.003962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277470 ORDER BY `minOrder` ASC [ RunTime:0.003542s ]
select * from pdf where partno='2106124-2' and brandshort='te connectivity' limit 1 [ RunTime:0.004829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106124-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.022993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32162968 LIMIT 4 [ RunTime:0.010411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32162968 ORDER BY `minOrder` ASC [ RunTime:0.005460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32162968 ORDER BY `unit` DESC [ RunTime:0.006631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32162968 LIMIT 2 [ RunTime:0.005848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32162968 ORDER BY `minOrder` ASC [ RunTime:0.007078s ]
select * from pdf where partno='2106124-2' and brandshort='te connectivity' limit 1 [ RunTime:0.002060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106124-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.003044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667794 LIMIT 4 [ RunTime:0.006238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667794 ORDER BY `minOrder` ASC [ RunTime:0.001294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667794 ORDER BY `unit` DESC [ RunTime:0.002337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667794 LIMIT 2 [ RunTime:0.002396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667794 ORDER BY `minOrder` ASC [ RunTime:0.000900s ]
select * from pdf where partno='2106124-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005542s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.075386s ]