SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001633s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=69191&search=1' [ RunTime:0.002058s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001150s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000513s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002627s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.000370s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002333s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000342s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003547s ]
SELECT * FROM `stock_search` WHERE `partno` = '69191' LIMIT 1 [ RunTime:0.001852s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 15:06:00' WHERE `partno` = '69191' [ RunTime:0.002620s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002068s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69191%' OR `brand` LIKE '69191%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013149s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210676 LIMIT 5 [ RunTime:0.003879s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210676 ORDER BY `minOrder` ASC [ RunTime:0.001477s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15210676 ORDER BY `unit` DESC [ RunTime:0.000444s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15210676 LIMIT 2 [ RunTime:0.003770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210676 ORDER BY `minOrder` ASC [ RunTime:0.005980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19854893 LIMIT 5 [ RunTime:0.010287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19854893 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19854893 ORDER BY `unit` DESC [ RunTime:0.006739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19854893 LIMIT 2 [ RunTime:0.005445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19854893 ORDER BY `minOrder` ASC [ RunTime:0.000685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19771846 LIMIT 5 [ RunTime:0.000878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19771846 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19771846 ORDER BY `unit` DESC [ RunTime:0.000326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19771846 LIMIT 2 [ RunTime:0.004276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19771846 ORDER BY `minOrder` ASC [ RunTime:0.001688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19771589 LIMIT 5 [ RunTime:0.010040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19771589 ORDER BY `minOrder` ASC [ RunTime:0.016169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19771589 ORDER BY `unit` DESC [ RunTime:0.008712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19771589 LIMIT 2 [ RunTime:0.009336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19771589 ORDER BY `minOrder` ASC [ RunTime:0.000574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19771251 LIMIT 5 [ RunTime:0.001204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19771251 ORDER BY `minOrder` ASC [ RunTime:0.007944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19771251 ORDER BY `unit` DESC [ RunTime:0.000586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19771251 LIMIT 2 [ RunTime:0.007715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19771251 ORDER BY `minOrder` ASC [ RunTime:0.012485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19771154 LIMIT 5 [ RunTime:0.002636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19771154 ORDER BY `minOrder` ASC [ RunTime:0.001269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19771154 ORDER BY `unit` DESC [ RunTime:0.000607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19771154 LIMIT 2 [ RunTime:0.000768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19771154 ORDER BY `minOrder` ASC [ RunTime:0.002397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19770427 LIMIT 5 [ RunTime:0.006293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19770427 ORDER BY `minOrder` ASC [ RunTime:0.005439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19770427 ORDER BY `unit` DESC [ RunTime:0.001603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19770427 LIMIT 2 [ RunTime:0.000671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19770427 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19770295 LIMIT 5 [ RunTime:0.013530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19770295 ORDER BY `minOrder` ASC [ RunTime:0.009065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19770295 ORDER BY `unit` DESC [ RunTime:0.003111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19770295 LIMIT 2 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19770295 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19770046 LIMIT 5 [ RunTime:0.002279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19770046 ORDER BY `minOrder` ASC [ RunTime:0.006070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19770046 ORDER BY `unit` DESC [ RunTime:0.001412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19770046 LIMIT 2 [ RunTime:0.006999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19770046 ORDER BY `minOrder` ASC [ RunTime:0.002333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19770014 LIMIT 5 [ RunTime:0.017908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19770014 ORDER BY `minOrder` ASC [ RunTime:0.004204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19770014 ORDER BY `unit` DESC [ RunTime:0.005219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19770014 LIMIT 2 [ RunTime:0.006610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19770014 ORDER BY `minOrder` ASC [ RunTime:0.002775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19769666 LIMIT 5 [ RunTime:0.004019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769666 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19769666 ORDER BY `unit` DESC [ RunTime:0.000373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19769666 LIMIT 2 [ RunTime:0.006026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769666 ORDER BY `minOrder` ASC [ RunTime:0.003724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19769624 LIMIT 5 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769624 ORDER BY `minOrder` ASC [ RunTime:0.008908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19769624 ORDER BY `unit` DESC [ RunTime:0.000686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19769624 LIMIT 2 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769624 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19769281 LIMIT 5 [ RunTime:0.001416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769281 ORDER BY `minOrder` ASC [ RunTime:0.006724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19769281 ORDER BY `unit` DESC [ RunTime:0.002898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19769281 LIMIT 2 [ RunTime:0.005928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769281 ORDER BY `minOrder` ASC [ RunTime:0.007229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19769008 LIMIT 5 [ RunTime:0.001228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769008 ORDER BY `minOrder` ASC [ RunTime:0.001909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19769008 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19769008 LIMIT 2 [ RunTime:0.015235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19769008 ORDER BY `minOrder` ASC [ RunTime:0.007588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19768733 LIMIT 5 [ RunTime:0.000957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19768733 ORDER BY `minOrder` ASC [ RunTime:0.005265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19768733 ORDER BY `unit` DESC [ RunTime:0.003610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19768733 LIMIT 2 [ RunTime:0.009544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19768733 ORDER BY `minOrder` ASC [ RunTime:0.004684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19768543 LIMIT 5 [ RunTime:0.004924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19768543 ORDER BY `minOrder` ASC [ RunTime:0.004374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19768543 ORDER BY `unit` DESC [ RunTime:0.016934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19768543 LIMIT 2 [ RunTime:0.004589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19768543 ORDER BY `minOrder` ASC [ RunTime:0.001010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19767507 LIMIT 5 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767507 ORDER BY `minOrder` ASC [ RunTime:0.000828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19767507 ORDER BY `unit` DESC [ RunTime:0.002190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19767507 LIMIT 2 [ RunTime:0.001424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767507 ORDER BY `minOrder` ASC [ RunTime:0.009202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19767497 LIMIT 5 [ RunTime:0.020542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767497 ORDER BY `minOrder` ASC [ RunTime:0.004441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19767497 ORDER BY `unit` DESC [ RunTime:0.010006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19767497 LIMIT 2 [ RunTime:0.004518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767497 ORDER BY `minOrder` ASC [ RunTime:0.006099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19767451 LIMIT 5 [ RunTime:0.032422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767451 ORDER BY `minOrder` ASC [ RunTime:0.001887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19767451 ORDER BY `unit` DESC [ RunTime:0.013350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19767451 LIMIT 2 [ RunTime:0.009978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767451 ORDER BY `minOrder` ASC [ RunTime:0.004940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19767255 LIMIT 5 [ RunTime:0.003882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767255 ORDER BY `minOrder` ASC [ RunTime:0.013692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19767255 ORDER BY `unit` DESC [ RunTime:0.013121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19767255 LIMIT 2 [ RunTime:0.011417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19767255 ORDER BY `minOrder` ASC [ RunTime:0.006282s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69191%' OR `brand` LIKE '69191%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018728s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69191%' OR `brand` LIKE '69191%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52684932 LIMIT 5 [ RunTime:0.018065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52684932 ORDER BY `minOrder` ASC [ RunTime:0.032944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52684932 ORDER BY `unit` DESC [ RunTime:0.049410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52684932 LIMIT 2 [ RunTime:0.012426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52684932 ORDER BY `minOrder` ASC [ RunTime:0.021632s ]
select * from pdf where partno='69191-106HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.018809s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-106HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.013004s ]
SELECT `id` FROM `stock` WHERE `id` <> 52684932 AND `partno` = '69191-106HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.009319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19854893 [ RunTime:0.045196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44009407 LIMIT 5 [ RunTime:0.013200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44009407 ORDER BY `minOrder` ASC [ RunTime:0.018033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44009407 ORDER BY `unit` DESC [ RunTime:0.032277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44009407 LIMIT 2 [ RunTime:0.020969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44009407 ORDER BY `minOrder` ASC [ RunTime:0.010401s ]
select * from pdf where partno='691919-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.014317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691919-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011758s ]
SELECT `id` FROM `stock` WHERE `id` <> 44009407 AND `partno` = '691919-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.013257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210676 [ RunTime:0.022628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52735397 LIMIT 5 [ RunTime:0.022543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52735397 ORDER BY `minOrder` ASC [ RunTime:0.030883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52735397 ORDER BY `unit` DESC [ RunTime:0.016204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52735397 LIMIT 2 [ RunTime:0.015924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52735397 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='69191-210HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-210HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.026504s ]
SELECT `id` FROM `stock` WHERE `id` <> 52735397 AND `partno` = '69191-210HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.008303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11550752 [ RunTime:0.014569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52732376 LIMIT 5 [ RunTime:0.021242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52732376 ORDER BY `minOrder` ASC [ RunTime:0.046393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52732376 ORDER BY `unit` DESC [ RunTime:0.011603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52732376 LIMIT 2 [ RunTime:0.002200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52732376 ORDER BY `minOrder` ASC [ RunTime:0.012193s ]
select * from pdf where partno='69191-410' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.027606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-410' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004786s ]
SELECT `id` FROM `stock` WHERE `id` <> 52732376 AND `partno` = '69191-410' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.015595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11550435 [ RunTime:0.012437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52728573 LIMIT 5 [ RunTime:0.024853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52728573 ORDER BY `minOrder` ASC [ RunTime:0.015159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52728573 ORDER BY `unit` DESC [ RunTime:0.015544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52728573 LIMIT 2 [ RunTime:0.007879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52728573 ORDER BY `minOrder` ASC [ RunTime:0.015198s ]
select * from pdf where partno='69191-408' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.013103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-408' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.007928s ]
SELECT `id` FROM `stock` WHERE `id` <> 52728573 AND `partno` = '69191-408' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.026823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11548974 [ RunTime:0.020269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52728063 LIMIT 5 [ RunTime:0.009506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52728063 ORDER BY `minOrder` ASC [ RunTime:0.034349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52728063 ORDER BY `unit` DESC [ RunTime:0.030550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52728063 LIMIT 2 [ RunTime:0.054067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52728063 ORDER BY `minOrder` ASC [ RunTime:0.003597s ]
select * from pdf where partno='69191-206HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.026010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-206HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.013907s ]
SELECT `id` FROM `stock` WHERE `id` <> 52728063 AND `partno` = '69191-206HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.036374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19771251 [ RunTime:0.009754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52727192 LIMIT 5 [ RunTime:0.026495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52727192 ORDER BY `minOrder` ASC [ RunTime:0.014147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52727192 ORDER BY `unit` DESC [ RunTime:0.008241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52727192 LIMIT 2 [ RunTime:0.018801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52727192 ORDER BY `minOrder` ASC [ RunTime:0.007135s ]
select * from pdf where partno='69191-105' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.007309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-105' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.046087s ]
SELECT `id` FROM `stock` WHERE `id` <> 52727192 AND `partno` = '69191-105' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.034126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19771589 [ RunTime:0.080196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52726589 LIMIT 5 [ RunTime:0.021062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52726589 ORDER BY `minOrder` ASC [ RunTime:0.027992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52726589 ORDER BY `unit` DESC [ RunTime:0.020508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52726589 LIMIT 2 [ RunTime:0.017558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52726589 ORDER BY `minOrder` ASC [ RunTime:0.009438s ]
select * from pdf where partno='69191-406HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.020947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-406HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.017980s ]
SELECT `id` FROM `stock` WHERE `id` <> 52726589 AND `partno` = '69191-406HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.031242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19770295 [ RunTime:0.015419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52726048 LIMIT 5 [ RunTime:0.031494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52726048 ORDER BY `minOrder` ASC [ RunTime:0.038591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52726048 ORDER BY `unit` DESC [ RunTime:0.024261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52726048 LIMIT 2 [ RunTime:0.019427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52726048 ORDER BY `minOrder` ASC [ RunTime:0.022456s ]
select * from pdf where partno='69191-205HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.025638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-205HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.020260s ]
SELECT `id` FROM `stock` WHERE `id` <> 52726048 AND `partno` = '69191-205HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.024655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15477520 [ RunTime:0.003219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52725492 LIMIT 5 [ RunTime:0.007012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52725492 ORDER BY `minOrder` ASC [ RunTime:0.008993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52725492 ORDER BY `unit` DESC [ RunTime:0.027812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52725492 LIMIT 2 [ RunTime:0.027794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52725492 ORDER BY `minOrder` ASC [ RunTime:0.014496s ]
select * from pdf where partno='69191-205' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.014304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-205' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.010938s ]
SELECT `id` FROM `stock` WHERE `id` <> 52725492 AND `partno` = '69191-205' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.005282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19770427 [ RunTime:0.000835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52725046 LIMIT 5 [ RunTime:0.016822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52725046 ORDER BY `minOrder` ASC [ RunTime:0.020676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52725046 ORDER BY `unit` DESC [ RunTime:0.020349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52725046 LIMIT 2 [ RunTime:0.007983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52725046 ORDER BY `minOrder` ASC [ RunTime:0.007689s ]
select * from pdf where partno='69191-104' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.004451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-104' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004630s ]
SELECT `id` FROM `stock` WHERE `id` <> 52725046 AND `partno` = '69191-104' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.022791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16194928 [ RunTime:0.040747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52722895 LIMIT 5 [ RunTime:0.028434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52722895 ORDER BY `minOrder` ASC [ RunTime:0.010289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52722895 ORDER BY `unit` DESC [ RunTime:0.022139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52722895 LIMIT 2 [ RunTime:0.016271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52722895 ORDER BY `minOrder` ASC [ RunTime:0.008326s ]
select * from pdf where partno='69191-410HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.027475s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-410HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.018362s ]
SELECT `id` FROM `stock` WHERE `id` <> 52722895 AND `partno` = '69191-410HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.018505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15477153 [ RunTime:0.010881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52721184 LIMIT 5 [ RunTime:0.007228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52721184 ORDER BY `minOrder` ASC [ RunTime:0.020419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52721184 ORDER BY `unit` DESC [ RunTime:0.019570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52721184 LIMIT 2 [ RunTime:0.022483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52721184 ORDER BY `minOrder` ASC [ RunTime:0.009824s ]
select * from pdf where partno='69191-405' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.021378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-405' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.026754s ]
SELECT `id` FROM `stock` WHERE `id` <> 52721184 AND `partno` = '69191-405' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.013058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19767497 [ RunTime:0.019756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52719663 LIMIT 5 [ RunTime:0.018923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52719663 ORDER BY `minOrder` ASC [ RunTime:0.034403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52719663 ORDER BY `unit` DESC [ RunTime:0.013988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52719663 LIMIT 2 [ RunTime:0.022197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52719663 ORDER BY `minOrder` ASC [ RunTime:0.014766s ]
select * from pdf where partno='69191-405HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.018258s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-405HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.016641s ]
SELECT `id` FROM `stock` WHERE `id` <> 52719663 AND `partno` = '69191-405HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.023941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192906 [ RunTime:0.014830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52719373 LIMIT 5 [ RunTime:0.019032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52719373 ORDER BY `minOrder` ASC [ RunTime:0.028836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52719373 ORDER BY `unit` DESC [ RunTime:0.012700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52719373 LIMIT 2 [ RunTime:0.013137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52719373 ORDER BY `minOrder` ASC [ RunTime:0.021313s ]
select * from pdf where partno='69191-403' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.017795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191-403' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.023896s ]
SELECT `id` FROM `stock` WHERE `id` <> 52719373 AND `partno` = '69191-403' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.034971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192882 [ RunTime:0.007916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51348831 LIMIT 5 [ RunTime:0.002431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51348831 ORDER BY `minOrder` ASC [ RunTime:0.023481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51348831 ORDER BY `unit` DESC [ RunTime:0.002778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51348831 LIMIT 2 [ RunTime:0.003387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51348831 ORDER BY `minOrder` ASC [ RunTime:0.009345s ]
select * from pdf where partno='69191' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.017619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69191' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.013672s ]
SELECT `id` FROM `stock` WHERE `id` <> 51348831 AND `partno` = '69191' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.019112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14718271 [ RunTime:0.014601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44017850 LIMIT 5 [ RunTime:0.014048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44017850 ORDER BY `minOrder` ASC [ RunTime:0.006290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44017850 ORDER BY `unit` DESC [ RunTime:0.025133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44017850 LIMIT 2 [ RunTime:0.024863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44017850 ORDER BY `minOrder` ASC [ RunTime:0.017637s ]
select * from pdf where partno='691919-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.016496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691919-2' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.008182s ]
SELECT `id` FROM `stock` WHERE `id` <> 44017850 AND `partno` = '691919-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.006880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18732525 [ RunTime:0.002641s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69191%' OR `brand` LIKE '69191%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021300s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69191%' OR `brand` LIKE '69191%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019639s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69191%' OR `brand` LIKE '69191%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029093s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69191%' OR `brand` LIKE '69191%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022379s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69191%' OR `brand` LIKE '69191%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013976s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69191%' OR `brand` LIKE '69191%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033155s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69191%' OR `brand` LIKE '69191%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009383s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69191%' OR `brand` LIKE '69191%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.017062s ]