SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002526s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.103' , `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=10671&search=1' [ RunTime:0.003850s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001752s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000987s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001770s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.103' ) [ RunTime:0.001151s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001246s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000251s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002081s ]
SELECT * FROM `stock_search` WHERE `partno` = '10671' LIMIT 1 [ RunTime:0.009245s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 13:10:14' WHERE `partno` = '10671' [ RunTime:0.009898s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001367s ]
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 '10671%' OR `brand` LIKE '10671%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029196s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349136 LIMIT 5 [ RunTime:0.016658s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349136 ORDER BY `minOrder` ASC [ RunTime:0.016508s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349136 ORDER BY `unit` DESC [ RunTime:0.026042s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.019269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349136 LIMIT 2 [ RunTime:0.033244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349136 ORDER BY `minOrder` ASC [ RunTime:0.019337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047296 LIMIT 5 [ RunTime:0.040016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047296 ORDER BY `minOrder` ASC [ RunTime:0.017305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12047296 ORDER BY `unit` DESC [ RunTime:0.006865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12047296 LIMIT 2 [ RunTime:0.005216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047296 ORDER BY `minOrder` ASC [ RunTime:0.002858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797326 LIMIT 5 [ RunTime:0.023110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797326 ORDER BY `minOrder` ASC [ RunTime:0.001043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18797326 ORDER BY `unit` DESC [ RunTime:0.002390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18797326 LIMIT 2 [ RunTime:0.007116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797326 ORDER BY `minOrder` ASC [ RunTime:0.029546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792063 LIMIT 5 [ RunTime:0.023503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792063 ORDER BY `minOrder` ASC [ RunTime:0.052772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792063 ORDER BY `unit` DESC [ RunTime:0.023326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792063 LIMIT 2 [ RunTime:0.020384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792063 ORDER BY `minOrder` ASC [ RunTime:0.003260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982885 LIMIT 5 [ RunTime:0.020634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982885 ORDER BY `minOrder` ASC [ RunTime:0.024619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982885 ORDER BY `unit` DESC [ RunTime:0.048304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982885 LIMIT 2 [ RunTime:0.025522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982885 ORDER BY `minOrder` ASC [ RunTime:0.013410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982778 LIMIT 5 [ RunTime:0.014111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982778 ORDER BY `minOrder` ASC [ RunTime:0.019662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982778 ORDER BY `unit` DESC [ RunTime:0.018421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982778 LIMIT 2 [ RunTime:0.016506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982778 ORDER BY `minOrder` ASC [ RunTime:0.005028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982412 LIMIT 5 [ RunTime:0.020710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982412 ORDER BY `minOrder` ASC [ RunTime:0.015076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982412 ORDER BY `unit` DESC [ RunTime:0.005075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982412 LIMIT 2 [ RunTime:0.018377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982412 ORDER BY `minOrder` ASC [ RunTime:0.004287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981782 LIMIT 5 [ RunTime:0.001459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981782 ORDER BY `minOrder` ASC [ RunTime:0.007479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981782 ORDER BY `unit` DESC [ RunTime:0.019604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981782 LIMIT 2 [ RunTime:0.002530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981782 ORDER BY `minOrder` ASC [ RunTime:0.001875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981396 LIMIT 5 [ RunTime:0.004500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981396 ORDER BY `minOrder` ASC [ RunTime:0.016032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981396 ORDER BY `unit` DESC [ RunTime:0.007935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981396 LIMIT 2 [ RunTime:0.004931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981396 ORDER BY `minOrder` ASC [ RunTime:0.006065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981390 LIMIT 5 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981390 ORDER BY `minOrder` ASC [ RunTime:0.003071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981390 ORDER BY `unit` DESC [ RunTime:0.000442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981390 LIMIT 2 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981390 ORDER BY `minOrder` ASC [ RunTime:0.001227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980831 LIMIT 5 [ RunTime:0.002133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980831 ORDER BY `minOrder` ASC [ RunTime:0.000606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980831 ORDER BY `unit` DESC [ RunTime:0.003388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980831 LIMIT 2 [ RunTime:0.001231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980831 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980613 LIMIT 5 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980613 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980613 ORDER BY `unit` DESC [ RunTime:0.014625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980613 LIMIT 2 [ RunTime:0.003436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980613 ORDER BY `minOrder` ASC [ RunTime:0.013517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980584 LIMIT 5 [ RunTime:0.011718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980584 ORDER BY `minOrder` ASC [ RunTime:0.010896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980584 ORDER BY `unit` DESC [ RunTime:0.006653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980584 LIMIT 2 [ RunTime:0.000802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980584 ORDER BY `minOrder` ASC [ RunTime:0.010902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980312 LIMIT 5 [ RunTime:0.008679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980312 ORDER BY `minOrder` ASC [ RunTime:0.000906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980312 ORDER BY `unit` DESC [ RunTime:0.019785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980312 LIMIT 2 [ RunTime:0.018533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980312 ORDER BY `minOrder` ASC [ RunTime:0.010156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979197 LIMIT 5 [ RunTime:0.006388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979197 ORDER BY `minOrder` ASC [ RunTime:0.006045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979197 ORDER BY `unit` DESC [ RunTime:0.007454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979197 LIMIT 2 [ RunTime:0.010973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979197 ORDER BY `minOrder` ASC [ RunTime:0.013178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793330 LIMIT 5 [ RunTime:0.017793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793330 ORDER BY `minOrder` ASC [ RunTime:0.026325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18793330 ORDER BY `unit` DESC [ RunTime:0.053239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18793330 LIMIT 2 [ RunTime:0.003207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793330 ORDER BY `minOrder` ASC [ RunTime:0.004192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792970 LIMIT 5 [ RunTime:0.001727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792970 ORDER BY `minOrder` ASC [ RunTime:0.012422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792970 ORDER BY `unit` DESC [ RunTime:0.001607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792970 LIMIT 2 [ RunTime:0.006290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792970 ORDER BY `minOrder` ASC [ RunTime:0.003333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792969 LIMIT 5 [ RunTime:0.001037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792969 ORDER BY `minOrder` ASC [ RunTime:0.002824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792969 ORDER BY `unit` DESC [ RunTime:0.010080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792969 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792969 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792968 LIMIT 5 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792968 ORDER BY `minOrder` ASC [ RunTime:0.000684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792968 ORDER BY `unit` DESC [ RunTime:0.005142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792968 LIMIT 2 [ RunTime:0.008145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792968 ORDER BY `minOrder` ASC [ RunTime:0.007864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792827 LIMIT 5 [ RunTime:0.016975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792827 ORDER BY `minOrder` ASC [ RunTime:0.005302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792827 ORDER BY `unit` DESC [ RunTime:0.010763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792827 LIMIT 2 [ RunTime:0.014725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792827 ORDER BY `minOrder` ASC [ RunTime:0.006960s ]
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 '10671%' OR `brand` LIKE '10671%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003978s ]
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 '10671%' OR `brand` LIKE '10671%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63387073 LIMIT 5 [ RunTime:0.000963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63387073 ORDER BY `minOrder` ASC [ RunTime:0.001160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63387073 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63387073 LIMIT 2 [ RunTime:0.008219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63387073 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
select * from pdf where partno='10671A' and brandshort='Essentra Components' limit 1 [ RunTime:0.001938s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10671A' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.002310s ]
SELECT `id` FROM `stock` WHERE `id` <> 63387073 AND `partno` = '10671A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.004660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047296 [ RunTime:0.002985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64565654 LIMIT 5 [ RunTime:0.007918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565654 ORDER BY `minOrder` ASC [ RunTime:0.000996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64565654 ORDER BY `unit` DESC [ RunTime:0.005874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64565654 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64565654 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='10671CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.004400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10671CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.009693s ]
SELECT `id` FROM `stock` WHERE `id` <> 64565654 AND `partno` = '10671CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.004350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349136 [ RunTime:0.029721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59387656 LIMIT 5 [ RunTime:0.009982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59387656 ORDER BY `minOrder` ASC [ RunTime:0.015201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59387656 ORDER BY `unit` DESC [ RunTime:0.000630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59387656 LIMIT 2 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59387656 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
select * from pdf where partno='1067100000' and brandshort='Weidmüller' limit 1 [ RunTime:0.044674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067100000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.013102s ]
SELECT `id` FROM `stock` WHERE `id` <> 59387656 AND `partno` = '1067100000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64785169 LIMIT 5 [ RunTime:0.024162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785169 ORDER BY `minOrder` ASC [ RunTime:0.027346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64785169 ORDER BY `unit` DESC [ RunTime:0.025041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64785169 LIMIT 2 [ RunTime:0.013635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785169 ORDER BY `minOrder` ASC [ RunTime:0.004622s ]
select * from pdf where partno='1067109' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067109' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021419s ]
SELECT `id` FROM `stock` WHERE `id` <> 64785169 AND `partno` = '1067109' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792063 [ RunTime:0.014867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64798449 LIMIT 5 [ RunTime:0.011147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64798449 ORDER BY `minOrder` ASC [ RunTime:0.004014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64798449 ORDER BY `unit` DESC [ RunTime:0.009478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64798449 LIMIT 2 [ RunTime:0.012237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64798449 ORDER BY `minOrder` ASC [ RunTime:0.004639s ]
select * from pdf where partno='1067166' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067166' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020156s ]
SELECT `id` FROM `stock` WHERE `id` <> 64798449 AND `partno` = '1067166' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.027565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18769532 [ RunTime:0.038699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786428 LIMIT 5 [ RunTime:0.003770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786428 ORDER BY `minOrder` ASC [ RunTime:0.006870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786428 ORDER BY `unit` DESC [ RunTime:0.012702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786428 LIMIT 2 [ RunTime:0.012603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786428 ORDER BY `minOrder` ASC [ RunTime:0.010222s ]
select * from pdf where partno='1067178' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067178' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017380s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786428 AND `partno` = '1067178' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797326 [ RunTime:0.017477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64807663 LIMIT 5 [ RunTime:0.019006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807663 ORDER BY `minOrder` ASC [ RunTime:0.015893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64807663 ORDER BY `unit` DESC [ RunTime:0.012091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64807663 LIMIT 2 [ RunTime:0.018087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807663 ORDER BY `minOrder` ASC [ RunTime:0.004975s ]
select * from pdf where partno='1067190' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067190' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003281s ]
SELECT `id` FROM `stock` WHERE `id` <> 64807663 AND `partno` = '1067190' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775465 [ RunTime:0.020638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805873 LIMIT 5 [ RunTime:0.002462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805873 ORDER BY `minOrder` ASC [ RunTime:0.013368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805873 ORDER BY `unit` DESC [ RunTime:0.002901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805873 LIMIT 2 [ RunTime:0.001943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805873 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
select * from pdf where partno='1067112' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067112' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005878s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805873 AND `partno` = '1067112' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774175 [ RunTime:0.013913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805651 LIMIT 5 [ RunTime:0.003356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805651 ORDER BY `minOrder` ASC [ RunTime:0.006518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805651 ORDER BY `unit` DESC [ RunTime:0.002330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805651 LIMIT 2 [ RunTime:0.000804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805651 ORDER BY `minOrder` ASC [ RunTime:0.003248s ]
select * from pdf where partno='1067141' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067141' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001000s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805651 AND `partno` = '1067141' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773942 [ RunTime:0.009822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805466 LIMIT 5 [ RunTime:0.015772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805466 ORDER BY `minOrder` ASC [ RunTime:0.015966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805466 ORDER BY `unit` DESC [ RunTime:0.029731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805466 LIMIT 2 [ RunTime:0.007339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805466 ORDER BY `minOrder` ASC [ RunTime:0.005300s ]
select * from pdf where partno='1067117' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.051622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067117' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.066752s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805466 AND `partno` = '1067117' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773846 [ RunTime:0.014197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805426 LIMIT 5 [ RunTime:0.021837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805426 ORDER BY `minOrder` ASC [ RunTime:0.016360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805426 ORDER BY `unit` DESC [ RunTime:0.014747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805426 LIMIT 2 [ RunTime:0.003515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805426 ORDER BY `minOrder` ASC [ RunTime:0.007973s ]
select * from pdf where partno='1067147' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067147' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010604s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805426 AND `partno` = '1067147' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773815 [ RunTime:0.010403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805213 LIMIT 5 [ RunTime:0.002547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805213 ORDER BY `minOrder` ASC [ RunTime:0.011647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805213 ORDER BY `unit` DESC [ RunTime:0.006746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805213 LIMIT 2 [ RunTime:0.017922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805213 ORDER BY `minOrder` ASC [ RunTime:0.009775s ]
select * from pdf where partno='1067137' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067137' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017917s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805213 AND `partno` = '1067137' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.023473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773715 [ RunTime:0.023331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803623 LIMIT 5 [ RunTime:0.008969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803623 ORDER BY `minOrder` ASC [ RunTime:0.023503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803623 ORDER BY `unit` DESC [ RunTime:0.011613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803623 LIMIT 2 [ RunTime:0.006836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803623 ORDER BY `minOrder` ASC [ RunTime:0.016564s ]
select * from pdf where partno='1067138' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067138' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002713s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803623 AND `partno` = '1067138' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266238 [ RunTime:0.033450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803256 LIMIT 5 [ RunTime:0.005181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803256 ORDER BY `minOrder` ASC [ RunTime:0.025073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803256 ORDER BY `unit` DESC [ RunTime:0.020040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803256 LIMIT 2 [ RunTime:0.046828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803256 ORDER BY `minOrder` ASC [ RunTime:0.038574s ]
select * from pdf where partno='1067125' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067125' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010939s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803256 AND `partno` = '1067125' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774339 [ RunTime:0.015704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802760 LIMIT 5 [ RunTime:0.015353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802760 ORDER BY `minOrder` ASC [ RunTime:0.007060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802760 ORDER BY `unit` DESC [ RunTime:0.006017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802760 LIMIT 2 [ RunTime:0.003987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802760 ORDER BY `minOrder` ASC [ RunTime:0.000906s ]
select * from pdf where partno='1067128' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067128' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008278s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802760 AND `partno` = '1067128' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774436 [ RunTime:0.000932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802507 LIMIT 5 [ RunTime:0.001437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802507 ORDER BY `minOrder` ASC [ RunTime:0.000794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802507 ORDER BY `unit` DESC [ RunTime:0.005818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802507 LIMIT 2 [ RunTime:0.003470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802507 ORDER BY `minOrder` ASC [ RunTime:0.001434s ]
select * from pdf where partno='1067172' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067172' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002003s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802507 AND `partno` = '1067172' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980584 [ RunTime:0.001481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802122 LIMIT 5 [ RunTime:0.001958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802122 ORDER BY `minOrder` ASC [ RunTime:0.008953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802122 ORDER BY `unit` DESC [ RunTime:0.000709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802122 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802122 ORDER BY `minOrder` ASC [ RunTime:0.001308s ]
select * from pdf where partno='1067116' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067116' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000787s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802122 AND `partno` = '1067116' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980312 [ RunTime:0.006929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800654 LIMIT 5 [ RunTime:0.002522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800654 ORDER BY `minOrder` ASC [ RunTime:0.008028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800654 ORDER BY `unit` DESC [ RunTime:0.004940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800654 LIMIT 2 [ RunTime:0.010505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800654 ORDER BY `minOrder` ASC [ RunTime:0.007915s ]
select * from pdf where partno='1067107' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067107' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006427s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800654 AND `partno` = '1067107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770918 [ RunTime:0.017558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800535 LIMIT 5 [ RunTime:0.014877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800535 ORDER BY `minOrder` ASC [ RunTime:0.006162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800535 ORDER BY `unit` DESC [ RunTime:0.004761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800535 LIMIT 2 [ RunTime:0.008747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800535 ORDER BY `minOrder` ASC [ RunTime:0.009271s ]
select * from pdf where partno='1067106' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067106' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007002s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800535 AND `partno` = '1067106' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770831 [ RunTime:0.012277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800518 LIMIT 5 [ RunTime:0.004269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800518 ORDER BY `minOrder` ASC [ RunTime:0.011061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800518 ORDER BY `unit` DESC [ RunTime:0.011536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800518 LIMIT 2 [ RunTime:0.002388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800518 ORDER BY `minOrder` ASC [ RunTime:0.000686s ]
select * from pdf where partno='1067196' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1067196' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022833s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800518 AND `partno` = '1067196' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.024893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010218 [ RunTime:0.011409s ]
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 '10671%' OR `brand` LIKE '10671%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008917s ]
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 '10671%' OR `brand` LIKE '10671%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038538s ]
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 '10671%' OR `brand` LIKE '10671%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009210s ]
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 '10671%' OR `brand` LIKE '10671%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011510s ]
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 '10671%' OR `brand` LIKE '10671%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007543s ]
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 '10671%' OR `brand` LIKE '10671%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025251s ]
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 '10671%' OR `brand` LIKE '10671%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005814s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10671%' OR `brand` LIKE '10671%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010371s ]