SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002270s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.008049s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002358s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000685s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002422s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000378s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002088s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000343s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002178s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.001066s ]
UPDATE `stock_search` SET `count` = 4191 , `updatetime` = '2026-06-08 16:56:30' WHERE `partno` = '210' [ RunTime:0.009528s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000991s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000288s ]
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.000461s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002479s ]
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.102286s ]
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 1460,20 [ RunTime:0.055987s ]
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 ('32277860','32265142','32229136','32163358','12060281','11900187','11125476','34279720','33431731','10895553','10848335','36760543','34399582','34379497','33884459','32270391','19763193','14272838','12041768','10838465') ORDER BY FIELD(s.id, 32277860,32265142,32229136,32163358,12060281,11900187,11125476,34279720,33431731,10895553,10848335,36760543,34399582,34379497,33884459,32270391,19763193,14272838,12041768,10838465) [ RunTime:0.011518s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277860 LIMIT 4 [ RunTime:0.011727s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277860 ORDER BY `minOrder` ASC [ RunTime:0.012145s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277860 ORDER BY `unit` DESC [ RunTime:0.001356s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277860 LIMIT 2 [ RunTime:0.007373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277860 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
select * from pdf where partno='2106489-4' and brandshort='te connectivity' limit 1 [ RunTime:0.022427s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106489-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.028777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32265142 LIMIT 4 [ RunTime:0.014728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32265142 ORDER BY `minOrder` ASC [ RunTime:0.004205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32265142 ORDER BY `unit` DESC [ RunTime:0.006080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32265142 LIMIT 2 [ RunTime:0.005173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32265142 ORDER BY `minOrder` ASC [ RunTime:0.005690s ]
select * from pdf where partno='2102866-2' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.023074s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102866-2' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.001172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32229136 LIMIT 4 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32229136 ORDER BY `minOrder` ASC [ RunTime:0.005261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32229136 ORDER BY `unit` DESC [ RunTime:0.000487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32229136 LIMIT 2 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32229136 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
select * from pdf where partno='2102866-2' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.011188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102866-2' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.006505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163358 LIMIT 4 [ RunTime:0.011486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163358 ORDER BY `minOrder` ASC [ RunTime:0.024229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163358 ORDER BY `unit` DESC [ RunTime:0.009264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163358 LIMIT 2 [ RunTime:0.000764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163358 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
select * from pdf where partno='2106489-4' and brandshort='te connectivity' limit 1 [ RunTime:0.003269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106489-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.000843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12060281 LIMIT 4 [ RunTime:0.004288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12060281 ORDER BY `minOrder` ASC [ RunTime:0.007139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12060281 ORDER BY `unit` DESC [ RunTime:0.003604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12060281 LIMIT 2 [ RunTime:0.002600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12060281 ORDER BY `minOrder` ASC [ RunTime:0.013630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11900187 LIMIT 4 [ RunTime:0.014154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11900187 ORDER BY `minOrder` ASC [ RunTime:0.006075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11900187 ORDER BY `unit` DESC [ RunTime:0.045051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11900187 LIMIT 2 [ RunTime:0.039898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11900187 ORDER BY `minOrder` ASC [ RunTime:0.008076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11125476 LIMIT 4 [ RunTime:0.017406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11125476 ORDER BY `minOrder` ASC [ RunTime:0.015629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11125476 ORDER BY `unit` DESC [ RunTime:0.016166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11125476 LIMIT 2 [ RunTime:0.024112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11125476 ORDER BY `minOrder` ASC [ RunTime:0.011865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34279720 LIMIT 4 [ RunTime:0.001352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34279720 ORDER BY `minOrder` ASC [ RunTime:0.058878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34279720 ORDER BY `unit` DESC [ RunTime:0.033008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34279720 LIMIT 2 [ RunTime:0.045910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34279720 ORDER BY `minOrder` ASC [ RunTime:0.009744s ]
select * from pdf where partno='2102870-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.050267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102870-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.009546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33431731 LIMIT 4 [ RunTime:0.007920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33431731 ORDER BY `minOrder` ASC [ RunTime:0.047233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33431731 ORDER BY `unit` DESC [ RunTime:0.036756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33431731 LIMIT 2 [ RunTime:0.008019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33431731 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
select * from pdf where partno='21011009983' and brandshort='HARTING' limit 1 [ RunTime:0.022479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21011009983' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.008248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10895553 LIMIT 4 [ RunTime:0.006246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10895553 ORDER BY `minOrder` ASC [ RunTime:0.006005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10895553 ORDER BY `unit` DESC [ RunTime:0.014340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10895553 LIMIT 2 [ RunTime:0.003795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10895553 ORDER BY `minOrder` ASC [ RunTime:0.010681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10848335 LIMIT 4 [ RunTime:0.013257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10848335 ORDER BY `minOrder` ASC [ RunTime:0.009612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10848335 ORDER BY `unit` DESC [ RunTime:0.010894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10848335 LIMIT 2 [ RunTime:0.023404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10848335 ORDER BY `minOrder` ASC [ RunTime:0.022609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760543 LIMIT 4 [ RunTime:0.035636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760543 ORDER BY `minOrder` ASC [ RunTime:0.026490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760543 ORDER BY `unit` DESC [ RunTime:0.051378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760543 LIMIT 2 [ RunTime:0.065442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760543 ORDER BY `minOrder` ASC [ RunTime:0.022565s ]
select * from pdf where partno='210-112' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.008624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-112' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.042529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34399582 LIMIT 4 [ RunTime:0.024207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399582 ORDER BY `minOrder` ASC [ RunTime:0.017208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34399582 ORDER BY `unit` DESC [ RunTime:0.019067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34399582 LIMIT 2 [ RunTime:0.022585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34399582 ORDER BY `minOrder` ASC [ RunTime:0.017277s ]
select * from pdf where partno='21033814806' and brandshort='HARTING' limit 1 [ RunTime:0.078923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21033814806' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.028517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34379497 LIMIT 4 [ RunTime:0.010330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34379497 ORDER BY `minOrder` ASC [ RunTime:0.025914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34379497 ORDER BY `unit` DESC [ RunTime:0.008133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34379497 LIMIT 2 [ RunTime:0.037311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34379497 ORDER BY `minOrder` ASC [ RunTime:0.016658s ]
select * from pdf where partno='2102353-6' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.032609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102353-6' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.031327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33884459 LIMIT 4 [ RunTime:0.054696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884459 ORDER BY `minOrder` ASC [ RunTime:0.050788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33884459 ORDER BY `unit` DESC [ RunTime:0.015269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33884459 LIMIT 2 [ RunTime:0.048394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33884459 ORDER BY `minOrder` ASC [ RunTime:0.008884s ]
select * from pdf where partno='2102574-1' and brandshort='WEC' limit 1 [ RunTime:0.035129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102574-1' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.013143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270391 LIMIT 4 [ RunTime:0.060212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270391 ORDER BY `minOrder` ASC [ RunTime:0.031851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270391 ORDER BY `unit` DESC [ RunTime:0.008579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270391 LIMIT 2 [ RunTime:0.029023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270391 ORDER BY `minOrder` ASC [ RunTime:0.007369s ]
select * from pdf where partno='2102081-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.014167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102081-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.020628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19763193 LIMIT 4 [ RunTime:0.075396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19763193 ORDER BY `minOrder` ASC [ RunTime:0.042221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19763193 ORDER BY `unit` DESC [ RunTime:0.034775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19763193 LIMIT 2 [ RunTime:0.015719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19763193 ORDER BY `minOrder` ASC [ RunTime:0.013779s ]
select * from pdf where partno='2102060-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.049058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14272838 LIMIT 4 [ RunTime:0.028846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14272838 ORDER BY `minOrder` ASC [ RunTime:0.012519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14272838 ORDER BY `unit` DESC [ RunTime:0.026552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14272838 LIMIT 2 [ RunTime:0.017084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14272838 ORDER BY `minOrder` ASC [ RunTime:0.005385s ]
select * from pdf where partno='21033814420' and brandshort='HARTING' limit 1 [ RunTime:0.001985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041768 LIMIT 4 [ RunTime:0.023281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041768 ORDER BY `minOrder` ASC [ RunTime:0.012767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12041768 ORDER BY `unit` DESC [ RunTime:0.018232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12041768 LIMIT 2 [ RunTime:0.008261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041768 ORDER BY `minOrder` ASC [ RunTime:0.029389s ]
select * from pdf where partno='2107-440-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.032296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10838465 LIMIT 4 [ RunTime:0.014083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10838465 ORDER BY `minOrder` ASC [ RunTime:0.065896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10838465 ORDER BY `unit` DESC [ RunTime:0.049338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10838465 LIMIT 2 [ RunTime:0.072244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10838465 ORDER BY `minOrder` ASC [ RunTime:0.033584s ]
select * from pdf where partno='21033814413' and brandshort='HARTING' limit 1 [ RunTime:0.058601s ]
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.038259s ]