SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001841s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.163' , `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=10630&search=1' [ RunTime:0.007618s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001824s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001729s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003153s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.163' ) [ RunTime:0.000615s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001792s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000508s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002316s ]
SELECT * FROM `stock_search` WHERE `partno` = '10630' LIMIT 1 [ RunTime:0.000706s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-10-03 15:50:56' WHERE `partno` = '10630' [ RunTime:0.003003s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002513s ]
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 '10630%' OR `brand` LIKE '10630%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005054s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.000933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349525 LIMIT 5 [ RunTime:0.000542s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349525 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349525 ORDER BY `unit` DESC [ RunTime:0.000258s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349525 LIMIT 2 [ RunTime:0.000291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349525 ORDER BY `minOrder` ASC [ RunTime:0.000254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13109050 LIMIT 5 [ RunTime:0.000933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13109050 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13109050 ORDER BY `unit` DESC [ RunTime:0.000281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13109050 LIMIT 2 [ RunTime:0.000279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13109050 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650417 LIMIT 5 [ RunTime:0.001702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650417 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650417 ORDER BY `unit` DESC [ RunTime:0.000229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650417 LIMIT 2 [ RunTime:0.000226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650417 ORDER BY `minOrder` ASC [ RunTime:0.000236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19013122 LIMIT 5 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19013122 ORDER BY `minOrder` ASC [ RunTime:0.000241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19013122 ORDER BY `unit` DESC [ RunTime:0.000229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19013122 LIMIT 2 [ RunTime:0.000220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19013122 ORDER BY `minOrder` ASC [ RunTime:0.000233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19013121 LIMIT 5 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19013121 ORDER BY `minOrder` ASC [ RunTime:0.000241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19013121 ORDER BY `unit` DESC [ RunTime:0.000225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19013121 LIMIT 2 [ RunTime:0.000215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19013121 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19013117 LIMIT 5 [ RunTime:0.000235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19013117 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19013117 ORDER BY `unit` DESC [ RunTime:0.000227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19013117 LIMIT 2 [ RunTime:0.000218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19013117 ORDER BY `minOrder` ASC [ RunTime:0.000242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19013112 LIMIT 5 [ RunTime:0.000242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19013112 ORDER BY `minOrder` ASC [ RunTime:0.000240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19013112 ORDER BY `unit` DESC [ RunTime:0.000225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19013112 LIMIT 2 [ RunTime:0.000226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19013112 ORDER BY `minOrder` ASC [ RunTime:0.000239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19004389 LIMIT 5 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19004389 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19004389 ORDER BY `unit` DESC [ RunTime:0.000229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19004389 LIMIT 2 [ RunTime:0.000236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19004389 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001770 LIMIT 5 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001770 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001770 ORDER BY `unit` DESC [ RunTime:0.000237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001770 LIMIT 2 [ RunTime:0.000220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001770 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001760 LIMIT 5 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001760 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001760 ORDER BY `unit` DESC [ RunTime:0.000233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001760 LIMIT 2 [ RunTime:0.000228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001760 ORDER BY `minOrder` ASC [ RunTime:0.000242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980487 LIMIT 5 [ RunTime:0.000839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980487 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980487 ORDER BY `unit` DESC [ RunTime:0.000227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980487 LIMIT 2 [ RunTime:0.000226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980487 ORDER BY `minOrder` ASC [ RunTime:0.000238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979931 LIMIT 5 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979931 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979931 ORDER BY `unit` DESC [ RunTime:0.000240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979931 LIMIT 2 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979931 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979929 LIMIT 5 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979929 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979929 ORDER BY `unit` DESC [ RunTime:0.000415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979929 LIMIT 2 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979929 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974326 LIMIT 5 [ RunTime:0.002068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974326 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18974326 ORDER BY `unit` DESC [ RunTime:0.000475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18974326 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974326 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781842 LIMIT 5 [ RunTime:0.000975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781842 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781842 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781842 LIMIT 2 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781842 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781841 LIMIT 5 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781841 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781841 ORDER BY `unit` DESC [ RunTime:0.000393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781841 LIMIT 2 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781841 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18781740 LIMIT 5 [ RunTime:0.000896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781740 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18781740 ORDER BY `unit` DESC [ RunTime:0.000403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18781740 LIMIT 2 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18781740 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778994 LIMIT 5 [ RunTime:0.000945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778994 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18778994 ORDER BY `unit` DESC [ RunTime:0.000449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18778994 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778994 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772808 LIMIT 5 [ RunTime:0.003116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772808 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772808 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772808 LIMIT 2 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772808 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17309973 LIMIT 5 [ RunTime:0.001423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17309973 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17309973 ORDER BY `unit` DESC [ RunTime:0.000464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17309973 LIMIT 2 [ RunTime:0.000432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17309973 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
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 '10630%' OR `brand` LIKE '10630%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001113s ]
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 '10630%' OR `brand` LIKE '10630%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71319568 LIMIT 5 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71319568 ORDER BY `minOrder` ASC [ RunTime:0.000747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71319568 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71319568 LIMIT 2 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71319568 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='10630CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000750s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10630CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000690s ]
SELECT `id` FROM `stock` WHERE `id` <> 71319568 AND `partno` = '10630CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349525 [ RunTime:0.000545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70117006 LIMIT 5 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70117006 ORDER BY `minOrder` ASC [ RunTime:0.000949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70117006 ORDER BY `unit` DESC [ RunTime:0.000556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70117006 LIMIT 2 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70117006 ORDER BY `minOrder` ASC [ RunTime:0.000591s ]
select * from pdf where partno='1063008' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063008' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000569s ]
SELECT `id` FROM `stock` WHERE `id` <> 70117006 AND `partno` = '1063008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67210787 LIMIT 5 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67210787 ORDER BY `minOrder` ASC [ RunTime:0.005070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67210787 ORDER BY `unit` DESC [ RunTime:0.000479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67210787 LIMIT 2 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67210787 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='106308NP' and brandshort='LAPP' limit 1 [ RunTime:0.000692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106308NP' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.000554s ]
SELECT `id` FROM `stock` WHERE `id` <> 67210787 AND `partno` = '106308NP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.000592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13109050 [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71567523 LIMIT 5 [ RunTime:0.000447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71567523 ORDER BY `minOrder` ASC [ RunTime:0.000770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71567523 ORDER BY `unit` DESC [ RunTime:0.000480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71567523 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71567523 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='1063082' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063082' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000547s ]
SELECT `id` FROM `stock` WHERE `id` <> 71567523 AND `partno` = '1063082' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224043 [ RunTime:0.000715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71564364 LIMIT 5 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71564364 ORDER BY `minOrder` ASC [ RunTime:0.002353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71564364 ORDER BY `unit` DESC [ RunTime:0.000481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71564364 LIMIT 2 [ RunTime:0.000457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71564364 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
select * from pdf where partno='1063091' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063091' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000772s ]
SELECT `id` FROM `stock` WHERE `id` <> 71564364 AND `partno` = '1063091' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980487 [ RunTime:0.000502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71562936 LIMIT 5 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71562936 ORDER BY `minOrder` ASC [ RunTime:0.000727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71562936 ORDER BY `unit` DESC [ RunTime:0.000398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71562936 LIMIT 2 [ RunTime:0.000376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71562936 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='1063075' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063075' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000543s ]
SELECT `id` FROM `stock` WHERE `id` <> 71562936 AND `partno` = '1063075' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979931 [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71562921 LIMIT 5 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71562921 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71562921 ORDER BY `unit` DESC [ RunTime:0.000408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71562921 LIMIT 2 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71562921 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
select * from pdf where partno='1063093' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063093' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000546s ]
SELECT `id` FROM `stock` WHERE `id` <> 71562921 AND `partno` = '1063093' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979929 [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71562362 LIMIT 5 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71562362 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71562362 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71562362 LIMIT 2 [ RunTime:0.000410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71562362 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
select * from pdf where partno='1063076' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063076' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000549s ]
SELECT `id` FROM `stock` WHERE `id` <> 71562362 AND `partno` = '1063076' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772808 [ RunTime:0.000457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71561074 LIMIT 5 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71561074 ORDER BY `minOrder` ASC [ RunTime:0.000711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71561074 ORDER BY `unit` DESC [ RunTime:0.000399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71561074 LIMIT 2 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71561074 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='1063092' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063092' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000528s ]
SELECT `id` FROM `stock` WHERE `id` <> 71561074 AND `partno` = '1063092' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223239 [ RunTime:0.000680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71297997 LIMIT 5 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297997 ORDER BY `minOrder` ASC [ RunTime:0.000861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71297997 ORDER BY `unit` DESC [ RunTime:0.000411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71297997 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297997 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='106305' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106305' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000552s ]
SELECT `id` FROM `stock` WHERE `id` <> 71297997 AND `partno` = '106305' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14421880 [ RunTime:0.000635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71297996 LIMIT 5 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297996 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71297996 ORDER BY `unit` DESC [ RunTime:0.000848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71297996 LIMIT 2 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297996 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
select * from pdf where partno='106302' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106302' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000713s ]
SELECT `id` FROM `stock` WHERE `id` <> 71297996 AND `partno` = '106302' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14421879 [ RunTime:0.000457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71297994 LIMIT 5 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297994 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71297994 ORDER BY `unit` DESC [ RunTime:0.000394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71297994 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297994 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='106303' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106303' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000678s ]
SELECT `id` FROM `stock` WHERE `id` <> 71297994 AND `partno` = '106303' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13551852 [ RunTime:0.000859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71297993 LIMIT 5 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297993 ORDER BY `minOrder` ASC [ RunTime:0.000678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71297993 ORDER BY `unit` DESC [ RunTime:0.000658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71297993 LIMIT 2 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297993 ORDER BY `minOrder` ASC [ RunTime:0.000650s ]
select * from pdf where partno='106307' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000893s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106307' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000828s ]
SELECT `id` FROM `stock` WHERE `id` <> 71297993 AND `partno` = '106307' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13551851 [ RunTime:0.000551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71297991 LIMIT 5 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297991 ORDER BY `minOrder` ASC [ RunTime:0.000671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71297991 ORDER BY `unit` DESC [ RunTime:0.000627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71297991 LIMIT 2 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297991 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
select * from pdf where partno='106306' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106306' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000837s ]
SELECT `id` FROM `stock` WHERE `id` <> 71297991 AND `partno` = '106306' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13551849 [ RunTime:0.000526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71297984 LIMIT 5 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297984 ORDER BY `minOrder` ASC [ RunTime:0.000583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71297984 ORDER BY `unit` DESC [ RunTime:0.000542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71297984 LIMIT 2 [ RunTime:0.000473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297984 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
select * from pdf where partno='106304' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106304' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000731s ]
SELECT `id` FROM `stock` WHERE `id` <> 71297984 AND `partno` = '106304' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13551846 [ RunTime:0.000521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71297934 LIMIT 5 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297934 ORDER BY `minOrder` ASC [ RunTime:0.000588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71297934 ORDER BY `unit` DESC [ RunTime:0.000520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71297934 LIMIT 2 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297934 ORDER BY `minOrder` ASC [ RunTime:0.000589s ]
select * from pdf where partno='106300' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106300' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000682s ]
SELECT `id` FROM `stock` WHERE `id` <> 71297934 AND `partno` = '106300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14421853 [ RunTime:0.002864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70271137 LIMIT 5 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70271137 ORDER BY `minOrder` ASC [ RunTime:0.000938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70271137 ORDER BY `unit` DESC [ RunTime:0.000501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70271137 LIMIT 2 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70271137 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='10630224' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.000584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10630224' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.000604s ]
SELECT `id` FROM `stock` WHERE `id` <> 70271137 AND `partno` = '10630224' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.000701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19013122 [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70271136 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70271136 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70271136 ORDER BY `unit` DESC [ RunTime:0.000464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70271136 LIMIT 2 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70271136 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='10630222' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.000951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10630222' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.000665s ]
SELECT `id` FROM `stock` WHERE `id` <> 70271136 AND `partno` = '10630222' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.000779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19013117 [ RunTime:0.000543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70271129 LIMIT 5 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70271129 ORDER BY `minOrder` ASC [ RunTime:0.000541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70271129 ORDER BY `unit` DESC [ RunTime:0.000507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70271129 LIMIT 2 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70271129 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
select * from pdf where partno='10630223' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.000720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10630223' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.000660s ]
SELECT `id` FROM `stock` WHERE `id` <> 70271129 AND `partno` = '10630223' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.000724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19013121 [ RunTime:0.000498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70270967 LIMIT 5 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70270967 ORDER BY `minOrder` ASC [ RunTime:0.003557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70270967 ORDER BY `unit` DESC [ RunTime:0.000416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70270967 LIMIT 2 [ RunTime:0.000386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70270967 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
select * from pdf where partno='10630213' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.000706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10630213' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.000627s ]
SELECT `id` FROM `stock` WHERE `id` <> 70270967 AND `partno` = '10630213' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.000690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19013112 [ RunTime:0.000526s ]
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 '10630%' OR `brand` LIKE '10630%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001141s ]
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 '10630%' OR `brand` LIKE '10630%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001035s ]
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 '10630%' OR `brand` LIKE '10630%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001013s ]
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 '10630%' OR `brand` LIKE '10630%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000980s ]
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 '10630%' OR `brand` LIKE '10630%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000987s ]
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 '10630%' OR `brand` LIKE '10630%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000971s ]
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 '10630%' OR `brand` LIKE '10630%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001040s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10630%' OR `brand` LIKE '10630%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001350s ]