SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003156s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=TEM-110-02-07.0-H-D&search=1' [ RunTime:0.013716s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002370s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008185s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002010s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001254s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.014081s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002595s ]
SELECT * FROM `stock_search` WHERE `partno` = 'TEM-110-02-07.0-H-D' LIMIT 1 [ RunTime:0.043663s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-09 20:28:44' WHERE `partno` = 'TEM-110-02-07.0-H-D' [ RunTime:0.021286s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002416s ]
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 'TEM-110-02-07.0-H-D%' OR `brand` LIKE 'TEM-110-02-07.0-H-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027526s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852029 LIMIT 5 [ RunTime:0.023961s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852029 ORDER BY `minOrder` ASC [ RunTime:0.006473s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.019035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19852029 ORDER BY `unit` DESC [ RunTime:0.019495s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19852029 LIMIT 2 [ RunTime:0.017903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852029 ORDER BY `minOrder` ASC [ RunTime:0.008587s ]
select * from pdf where partno='TEM-110-02-07.0-H-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.076393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19812747 LIMIT 5 [ RunTime:0.125022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812747 ORDER BY `minOrder` ASC [ RunTime:0.088281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19812747 ORDER BY `unit` DESC [ RunTime:0.012623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19812747 LIMIT 2 [ RunTime:0.022930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812747 ORDER BY `minOrder` ASC [ RunTime:0.025874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19757085 LIMIT 5 [ RunTime:0.047963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19757085 ORDER BY `minOrder` ASC [ RunTime:0.141433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19757085 ORDER BY `unit` DESC [ RunTime:0.043153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19757085 LIMIT 2 [ RunTime:0.029155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19757085 ORDER BY `minOrder` ASC [ RunTime:0.060720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740683 LIMIT 5 [ RunTime:0.054287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740683 ORDER BY `minOrder` ASC [ RunTime:0.031989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12740683 ORDER BY `unit` DESC [ RunTime:0.046607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12740683 LIMIT 2 [ RunTime:0.028828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740683 ORDER BY `minOrder` ASC [ RunTime:0.027210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740640 LIMIT 5 [ RunTime:0.028612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740640 ORDER BY `minOrder` ASC [ RunTime:0.038882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12740640 ORDER BY `unit` DESC [ RunTime:0.046971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12740640 LIMIT 2 [ RunTime:0.018847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740640 ORDER BY `minOrder` ASC [ RunTime:0.040795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12738066 LIMIT 5 [ RunTime:0.030445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738066 ORDER BY `minOrder` ASC [ RunTime:0.010068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12738066 ORDER BY `unit` DESC [ RunTime:0.023208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12738066 LIMIT 2 [ RunTime:0.047165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738066 ORDER BY `minOrder` ASC [ RunTime:0.000608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11572184 LIMIT 5 [ RunTime:0.042275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11572184 ORDER BY `minOrder` ASC [ RunTime:0.058687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11572184 ORDER BY `unit` DESC [ RunTime:0.025028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11572184 LIMIT 2 [ RunTime:0.011627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11572184 ORDER BY `minOrder` ASC [ RunTime:0.006038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11571917 LIMIT 5 [ RunTime:0.041796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11571917 ORDER BY `minOrder` ASC [ RunTime:0.033483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11571917 ORDER BY `unit` DESC [ RunTime:0.039072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11571917 LIMIT 2 [ RunTime:0.017232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11571917 ORDER BY `minOrder` ASC [ RunTime:0.007399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11570712 LIMIT 5 [ RunTime:0.029413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11570712 ORDER BY `minOrder` ASC [ RunTime:0.012004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11570712 ORDER BY `unit` DESC [ RunTime:0.014647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11570712 LIMIT 2 [ RunTime:0.021484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11570712 ORDER BY `minOrder` ASC [ RunTime:0.008009s ]
select * from pdf where partno='TEM-110-02-07.0-H-D-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.057382s ]
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 'TEM-110-02-07.0-H-D%' OR `brand` LIKE 'TEM-110-02-07.0-H-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027802s ]
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 'TEM-110-02-07.0-H-D%' OR `brand` LIKE 'TEM-110-02-07.0-H-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59541414 LIMIT 5 [ RunTime:0.012280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59541414 ORDER BY `minOrder` ASC [ RunTime:0.021383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59541414 ORDER BY `unit` DESC [ RunTime:0.011143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59541414 LIMIT 2 [ RunTime:0.020103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59541414 ORDER BY `minOrder` ASC [ RunTime:0.010872s ]
select * from pdf where partno='TEM-110-02-07.0-H-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019264s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-110-02-07.0-H-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.056461s ]
SELECT `id` FROM `stock` WHERE `id` <> 59541414 AND `partno` = 'TEM-110-02-07.0-H-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.057959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852029 [ RunTime:0.022809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59710589 LIMIT 5 [ RunTime:0.042078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710589 ORDER BY `minOrder` ASC [ RunTime:0.021460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59710589 ORDER BY `unit` DESC [ RunTime:0.031660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59710589 LIMIT 2 [ RunTime:0.074690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710589 ORDER BY `minOrder` ASC [ RunTime:0.060760s ]
select * from pdf where partno='TEM-110-02-07.0-H-D-WT-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.040556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-110-02-07.0-H-D-WT-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.043268s ]
SELECT `id` FROM `stock` WHERE `id` <> 59710589 AND `partno` = 'TEM-110-02-07.0-H-D-WT-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.061383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59709983 LIMIT 5 [ RunTime:0.022486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709983 ORDER BY `minOrder` ASC [ RunTime:0.035725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59709983 ORDER BY `unit` DESC [ RunTime:0.025888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59709983 LIMIT 2 [ RunTime:0.023381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709983 ORDER BY `minOrder` ASC [ RunTime:0.034688s ]
select * from pdf where partno='TEM-110-02-07.0-H-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-110-02-07.0-H-D-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.027157s ]
SELECT `id` FROM `stock` WHERE `id` <> 59709983 AND `partno` = 'TEM-110-02-07.0-H-D-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11572184 [ RunTime:0.009547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59709728 LIMIT 5 [ RunTime:0.042561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709728 ORDER BY `minOrder` ASC [ RunTime:0.059740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59709728 ORDER BY `unit` DESC [ RunTime:0.032761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59709728 LIMIT 2 [ RunTime:0.023253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709728 ORDER BY `minOrder` ASC [ RunTime:0.012060s ]
select * from pdf where partno='TEM-110-02-07.0-H-D-WT-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.048616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-110-02-07.0-H-D-WT-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.033952s ]
SELECT `id` FROM `stock` WHERE `id` <> 59709728 AND `partno` = 'TEM-110-02-07.0-H-D-WT-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.054359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59709620 LIMIT 5 [ RunTime:0.084512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709620 ORDER BY `minOrder` ASC [ RunTime:0.040338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59709620 ORDER BY `unit` DESC [ RunTime:0.027601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59709620 LIMIT 2 [ RunTime:0.027271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709620 ORDER BY `minOrder` ASC [ RunTime:0.019225s ]
select * from pdf where partno='TEM-110-02-07.0-H-D-LC-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.041028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-110-02-07.0-H-D-LC-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.080874s ]
SELECT `id` FROM `stock` WHERE `id` <> 59709620 AND `partno` = 'TEM-110-02-07.0-H-D-LC-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.042475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11571917 [ RunTime:0.018174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59709135 LIMIT 5 [ RunTime:0.000818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709135 ORDER BY `minOrder` ASC [ RunTime:0.048245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59709135 ORDER BY `unit` DESC [ RunTime:0.052272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59709135 LIMIT 2 [ RunTime:0.035436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709135 ORDER BY `minOrder` ASC [ RunTime:0.009996s ]
select * from pdf where partno='TEM-110-02-07.0-H-D-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-110-02-07.0-H-D-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.045013s ]
SELECT `id` FROM `stock` WHERE `id` <> 59709135 AND `partno` = 'TEM-110-02-07.0-H-D-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.047970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740683 [ RunTime:0.017058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59709130 LIMIT 5 [ RunTime:0.018279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709130 ORDER BY `minOrder` ASC [ RunTime:0.029412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59709130 ORDER BY `unit` DESC [ RunTime:0.104010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59709130 LIMIT 2 [ RunTime:0.057167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709130 ORDER BY `minOrder` ASC [ RunTime:0.047553s ]
select * from pdf where partno='TEM-110-02-07.0-H-D-WT-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-110-02-07.0-H-D-WT-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.049558s ]
SELECT `id` FROM `stock` WHERE `id` <> 59709130 AND `partno` = 'TEM-110-02-07.0-H-D-WT-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740640 [ RunTime:0.134326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59708290 LIMIT 5 [ RunTime:0.097955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708290 ORDER BY `minOrder` ASC [ RunTime:0.078704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59708290 ORDER BY `unit` DESC [ RunTime:0.058418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59708290 LIMIT 2 [ RunTime:0.038689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59708290 ORDER BY `minOrder` ASC [ RunTime:0.007449s ]
select * from pdf where partno='TEM-110-02-07.0-H-D-WT' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.037336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-110-02-07.0-H-D-WT' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.039063s ]
SELECT `id` FROM `stock` WHERE `id` <> 59708290 AND `partno` = 'TEM-110-02-07.0-H-D-WT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.029423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19757085 [ RunTime:0.088619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59707354 LIMIT 5 [ RunTime:0.118508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707354 ORDER BY `minOrder` ASC [ RunTime:0.104810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59707354 ORDER BY `unit` DESC [ RunTime:0.074349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59707354 LIMIT 2 [ RunTime:0.049225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707354 ORDER BY `minOrder` ASC [ RunTime:0.085724s ]
select * from pdf where partno='TEM-110-02-07.0-H-D-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.054050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-110-02-07.0-H-D-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.059933s ]
SELECT `id` FROM `stock` WHERE `id` <> 59707354 AND `partno` = 'TEM-110-02-07.0-H-D-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.046874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12738066 [ RunTime:0.073856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59707200 LIMIT 5 [ RunTime:0.076904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707200 ORDER BY `minOrder` ASC [ RunTime:0.093939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59707200 ORDER BY `unit` DESC [ RunTime:0.017491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59707200 LIMIT 2 [ RunTime:0.054992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59707200 ORDER BY `minOrder` ASC [ RunTime:0.001719s ]
select * from pdf where partno='TEM-110-02-07.0-H-D-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-110-02-07.0-H-D-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015346s ]
SELECT `id` FROM `stock` WHERE `id` <> 59707200 AND `partno` = 'TEM-110-02-07.0-H-D-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.044211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11570712 [ RunTime:0.028311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59705661 LIMIT 5 [ RunTime:0.063386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705661 ORDER BY `minOrder` ASC [ RunTime:0.049388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59705661 ORDER BY `unit` DESC [ RunTime:0.030036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59705661 LIMIT 2 [ RunTime:0.043828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705661 ORDER BY `minOrder` ASC [ RunTime:0.042305s ]
select * from pdf where partno='TEM-110-02-07.0-H-D-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-110-02-07.0-H-D-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032711s ]
SELECT `id` FROM `stock` WHERE `id` <> 59705661 AND `partno` = 'TEM-110-02-07.0-H-D-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.080967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19812747 [ RunTime:0.038989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59704653 LIMIT 5 [ RunTime:0.070424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59704653 ORDER BY `minOrder` ASC [ RunTime:0.038281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59704653 ORDER BY `unit` DESC [ RunTime:0.029487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59704653 LIMIT 2 [ RunTime:0.100735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59704653 ORDER BY `minOrder` ASC [ RunTime:0.022820s ]
select * from pdf where partno='TEM-110-02-07.0-H-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.029955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TEM-110-02-07.0-H-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.034686s ]
SELECT `id` FROM `stock` WHERE `id` <> 59704653 AND `partno` = 'TEM-110-02-07.0-H-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.082785s ]
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 'TEM-110-02-07.0-H-D%' OR `brand` LIKE 'TEM-110-02-07.0-H-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076178s ]
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 'TEM-110-02-07.0-H-D%' OR `brand` LIKE 'TEM-110-02-07.0-H-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.079815s ]
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 'TEM-110-02-07.0-H-D%' OR `brand` LIKE 'TEM-110-02-07.0-H-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017284s ]
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 'TEM-110-02-07.0-H-D%' OR `brand` LIKE 'TEM-110-02-07.0-H-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029956s ]
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 'TEM-110-02-07.0-H-D%' OR `brand` LIKE 'TEM-110-02-07.0-H-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018339s ]
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 'TEM-110-02-07.0-H-D%' OR `brand` LIKE 'TEM-110-02-07.0-H-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035379s ]
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 'TEM-110-02-07.0-H-D%' OR `brand` LIKE 'TEM-110-02-07.0-H-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036474s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TEM-110-02-07.0-H-D%' OR `brand` LIKE 'TEM-110-02-07.0-H-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.053694s ]