SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002570s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=10743&search=1' [ RunTime:0.007117s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003305s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.016911s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003175s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.008909s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002283s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.014649s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002413s ]
SELECT * FROM `stock_search` WHERE `partno` = '10743' LIMIT 1 [ RunTime:0.013113s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-19 21:25:43' WHERE `partno` = '10743' [ RunTime:0.067639s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002869s ]
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 '10743%' OR `brand` LIKE '10743%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.102819s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.023082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348968 LIMIT 5 [ RunTime:0.053412s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348968 ORDER BY `minOrder` ASC [ RunTime:0.074132s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.032392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348968 ORDER BY `unit` DESC [ RunTime:0.065816s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.020926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348968 LIMIT 2 [ RunTime:0.085416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348968 ORDER BY `minOrder` ASC [ RunTime:0.028957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797343 LIMIT 5 [ RunTime:0.019463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797343 ORDER BY `minOrder` ASC [ RunTime:0.036280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18797343 ORDER BY `unit` DESC [ RunTime:0.030038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18797343 LIMIT 2 [ RunTime:0.016954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797343 ORDER BY `minOrder` ASC [ RunTime:0.016764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797342 LIMIT 5 [ RunTime:0.013958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797342 ORDER BY `minOrder` ASC [ RunTime:0.005576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18797342 ORDER BY `unit` DESC [ RunTime:0.020757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18797342 LIMIT 2 [ RunTime:0.017557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797342 ORDER BY `minOrder` ASC [ RunTime:0.056806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797341 LIMIT 5 [ RunTime:0.004776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797341 ORDER BY `minOrder` ASC [ RunTime:0.031733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18797341 ORDER BY `unit` DESC [ RunTime:0.022504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18797341 LIMIT 2 [ RunTime:0.013984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797341 ORDER BY `minOrder` ASC [ RunTime:0.019753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797340 LIMIT 5 [ RunTime:0.006835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797340 ORDER BY `minOrder` ASC [ RunTime:0.034844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18797340 ORDER BY `unit` DESC [ RunTime:0.011669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18797340 LIMIT 2 [ RunTime:0.010783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797340 ORDER BY `minOrder` ASC [ RunTime:0.000742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17014314 LIMIT 5 [ RunTime:0.015893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17014314 ORDER BY `minOrder` ASC [ RunTime:0.006354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17014314 ORDER BY `unit` DESC [ RunTime:0.011021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17014314 LIMIT 2 [ RunTime:0.008842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17014314 ORDER BY `minOrder` ASC [ RunTime:0.014023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792070 LIMIT 5 [ RunTime:0.015675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792070 ORDER BY `minOrder` ASC [ RunTime:0.003533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18792070 ORDER BY `unit` DESC [ RunTime:0.009455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18792070 LIMIT 2 [ RunTime:0.009325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18792070 ORDER BY `minOrder` ASC [ RunTime:0.003070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19634279 LIMIT 5 [ RunTime:0.013671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634279 ORDER BY `minOrder` ASC [ RunTime:0.015663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19634279 ORDER BY `unit` DESC [ RunTime:0.006352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19634279 LIMIT 2 [ RunTime:0.000775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19634279 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19604368 LIMIT 5 [ RunTime:0.001144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19604368 ORDER BY `minOrder` ASC [ RunTime:0.006326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19604368 ORDER BY `unit` DESC [ RunTime:0.000604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19604368 LIMIT 2 [ RunTime:0.011629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19604368 ORDER BY `minOrder` ASC [ RunTime:0.007695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19513056 LIMIT 5 [ RunTime:0.014829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19513056 ORDER BY `minOrder` ASC [ RunTime:0.007140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19513056 ORDER BY `unit` DESC [ RunTime:0.009546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19513056 LIMIT 2 [ RunTime:0.014807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19513056 ORDER BY `minOrder` ASC [ RunTime:0.003526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979950 LIMIT 5 [ RunTime:0.018357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979950 ORDER BY `minOrder` ASC [ RunTime:0.006468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979950 ORDER BY `unit` DESC [ RunTime:0.002601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979950 LIMIT 2 [ RunTime:0.015710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979950 ORDER BY `minOrder` ASC [ RunTime:0.007654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979677 LIMIT 5 [ RunTime:0.017619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979677 ORDER BY `minOrder` ASC [ RunTime:0.017878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979677 ORDER BY `unit` DESC [ RunTime:0.004961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979677 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979677 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979451 LIMIT 5 [ RunTime:0.003391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979451 ORDER BY `minOrder` ASC [ RunTime:0.004556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979451 ORDER BY `unit` DESC [ RunTime:0.000876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979451 LIMIT 2 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979451 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979326 LIMIT 5 [ RunTime:0.001146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979326 ORDER BY `minOrder` ASC [ RunTime:0.000745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979326 ORDER BY `unit` DESC [ RunTime:0.000696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979326 LIMIT 2 [ RunTime:0.014642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979326 ORDER BY `minOrder` ASC [ RunTime:0.004437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18794657 LIMIT 5 [ RunTime:0.007440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18794657 ORDER BY `minOrder` ASC [ RunTime:0.009732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18794657 ORDER BY `unit` DESC [ RunTime:0.000987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18794657 LIMIT 2 [ RunTime:0.007800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18794657 ORDER BY `minOrder` ASC [ RunTime:0.006687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18794002 LIMIT 5 [ RunTime:0.007694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18794002 ORDER BY `minOrder` ASC [ RunTime:0.006499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18794002 ORDER BY `unit` DESC [ RunTime:0.007404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18794002 LIMIT 2 [ RunTime:0.003114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18794002 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18794001 LIMIT 5 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18794001 ORDER BY `minOrder` ASC [ RunTime:0.002054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18794001 ORDER BY `unit` DESC [ RunTime:0.000574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18794001 LIMIT 2 [ RunTime:0.020500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18794001 ORDER BY `minOrder` ASC [ RunTime:0.000844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18794000 LIMIT 5 [ RunTime:0.021381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18794000 ORDER BY `minOrder` ASC [ RunTime:0.011889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18794000 ORDER BY `unit` DESC [ RunTime:0.007209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18794000 LIMIT 2 [ RunTime:0.025069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18794000 ORDER BY `minOrder` ASC [ RunTime:0.011542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793999 LIMIT 5 [ RunTime:0.022642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793999 ORDER BY `minOrder` ASC [ RunTime:0.030338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18793999 ORDER BY `unit` DESC [ RunTime:0.015863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18793999 LIMIT 2 [ RunTime:0.032264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793999 ORDER BY `minOrder` ASC [ RunTime:0.006144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793998 LIMIT 5 [ RunTime:0.006687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793998 ORDER BY `minOrder` ASC [ RunTime:0.009910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18793998 ORDER BY `unit` DESC [ RunTime:0.025609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18793998 LIMIT 2 [ RunTime:0.035051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793998 ORDER BY `minOrder` ASC [ RunTime:0.008951s ]
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 '10743%' OR `brand` LIKE '10743%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51068415 LIMIT 5 [ RunTime:0.021125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068415 ORDER BY `minOrder` ASC [ RunTime:0.027711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51068415 ORDER BY `unit` DESC [ RunTime:0.033928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51068415 LIMIT 2 [ RunTime:0.026490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51068415 ORDER BY `minOrder` ASC [ RunTime:0.004499s ]
select * from pdf where partno='10743' and brandshort='carclo technical plastics' limit 1 [ RunTime:0.021954s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10743' OR `brand` LIKE 'carclo technical plastics%' ) ) LIMIT 1 [ RunTime:0.010302s ]
SELECT `id` FROM `stock` WHERE `id` <> 51068415 AND `partno` = '10743' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%carclo technical plastics%' ) [ RunTime:0.011300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15251170 [ RunTime:0.022437s ]
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 '10743%' OR `brand` LIKE '10743%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64559274 LIMIT 5 [ RunTime:0.013544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559274 ORDER BY `minOrder` ASC [ RunTime:0.010763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64559274 ORDER BY `unit` DESC [ RunTime:0.014310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64559274 LIMIT 2 [ RunTime:0.016602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559274 ORDER BY `minOrder` ASC [ RunTime:0.002624s ]
select * from pdf where partno='10743CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.013447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10743CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000806s ]
SELECT `id` FROM `stock` WHERE `id` <> 64559274 AND `partno` = '10743CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.017696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348968 [ RunTime:0.018182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64785192 LIMIT 5 [ RunTime:0.014056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785192 ORDER BY `minOrder` ASC [ RunTime:0.010531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64785192 ORDER BY `unit` DESC [ RunTime:0.013265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64785192 LIMIT 2 [ RunTime:0.019459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785192 ORDER BY `minOrder` ASC [ RunTime:0.013879s ]
select * from pdf where partno='1074366' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074366' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004154s ]
SELECT `id` FROM `stock` WHERE `id` <> 64785192 AND `partno` = '1074366' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797341 [ RunTime:0.000783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64785191 LIMIT 5 [ RunTime:0.000723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785191 ORDER BY `minOrder` ASC [ RunTime:0.000885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64785191 ORDER BY `unit` DESC [ RunTime:0.002540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64785191 LIMIT 2 [ RunTime:0.005714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785191 ORDER BY `minOrder` ASC [ RunTime:0.006862s ]
select * from pdf where partno='1074360' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074360' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003992s ]
SELECT `id` FROM `stock` WHERE `id` <> 64785191 AND `partno` = '1074360' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797340 [ RunTime:0.001150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64785190 LIMIT 5 [ RunTime:0.000693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785190 ORDER BY `minOrder` ASC [ RunTime:0.002443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64785190 ORDER BY `unit` DESC [ RunTime:0.008034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64785190 LIMIT 2 [ RunTime:0.008667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785190 ORDER BY `minOrder` ASC [ RunTime:0.003631s ]
select * from pdf where partno='1074359' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074359' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000862s ]
SELECT `id` FROM `stock` WHERE `id` <> 64785190 AND `partno` = '1074359' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18792070 [ RunTime:0.003832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786469 LIMIT 5 [ RunTime:0.007056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786469 ORDER BY `minOrder` ASC [ RunTime:0.003385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786469 ORDER BY `unit` DESC [ RunTime:0.004486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786469 LIMIT 2 [ RunTime:0.003630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786469 ORDER BY `minOrder` ASC [ RunTime:0.000591s ]
select * from pdf where partno='1074350' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074350' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005314s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786469 AND `partno` = '1074350' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17013773 [ RunTime:0.009686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786460 LIMIT 5 [ RunTime:0.007624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786460 ORDER BY `minOrder` ASC [ RunTime:0.008342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786460 ORDER BY `unit` DESC [ RunTime:0.018084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786460 LIMIT 2 [ RunTime:0.006774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786460 ORDER BY `minOrder` ASC [ RunTime:0.011379s ]
select * from pdf where partno='1074376' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074376' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004104s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786460 AND `partno` = '1074376' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17014314 [ RunTime:0.018370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64786459 LIMIT 5 [ RunTime:0.013560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786459 ORDER BY `minOrder` ASC [ RunTime:0.001066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64786459 ORDER BY `unit` DESC [ RunTime:0.004037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64786459 LIMIT 2 [ RunTime:0.010772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64786459 ORDER BY `minOrder` ASC [ RunTime:0.000951s ]
select * from pdf where partno='1074370' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074370' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001046s ]
SELECT `id` FROM `stock` WHERE `id` <> 64786459 AND `partno` = '1074370' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797343 [ RunTime:0.000658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64805764 LIMIT 5 [ RunTime:0.002292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805764 ORDER BY `minOrder` ASC [ RunTime:0.010368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64805764 ORDER BY `unit` DESC [ RunTime:0.005003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64805764 LIMIT 2 [ RunTime:0.004884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64805764 ORDER BY `minOrder` ASC [ RunTime:0.001373s ]
select * from pdf where partno='1074307' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074307' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015225s ]
SELECT `id` FROM `stock` WHERE `id` <> 64805764 AND `partno` = '1074307' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223698 [ RunTime:0.012085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803280 LIMIT 5 [ RunTime:0.014391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803280 ORDER BY `minOrder` ASC [ RunTime:0.002082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803280 ORDER BY `unit` DESC [ RunTime:0.000710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803280 LIMIT 2 [ RunTime:0.001260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803280 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
select * from pdf where partno='1074331' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074331' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009786s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803280 AND `partno` = '1074331' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223422 [ RunTime:0.007940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64802264 LIMIT 5 [ RunTime:0.005872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802264 ORDER BY `minOrder` ASC [ RunTime:0.008804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64802264 ORDER BY `unit` DESC [ RunTime:0.002884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64802264 LIMIT 2 [ RunTime:0.013464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64802264 ORDER BY `minOrder` ASC [ RunTime:0.003762s ]
select * from pdf where partno='1074355' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074355' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.033882s ]
SELECT `id` FROM `stock` WHERE `id` <> 64802264 AND `partno` = '1074355' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.025812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772030 [ RunTime:0.019311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64789990 LIMIT 5 [ RunTime:0.012705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789990 ORDER BY `minOrder` ASC [ RunTime:0.022382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64789990 ORDER BY `unit` DESC [ RunTime:0.030963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64789990 LIMIT 2 [ RunTime:0.026833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789990 ORDER BY `minOrder` ASC [ RunTime:0.006839s ]
select * from pdf where partno='1074353' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.066716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074353' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009944s ]
SELECT `id` FROM `stock` WHERE `id` <> 64789990 AND `partno` = '1074353' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17013775 [ RunTime:0.015109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64789989 LIMIT 5 [ RunTime:0.021657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789989 ORDER BY `minOrder` ASC [ RunTime:0.023205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64789989 ORDER BY `unit` DESC [ RunTime:0.026622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64789989 LIMIT 2 [ RunTime:0.048413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789989 ORDER BY `minOrder` ASC [ RunTime:0.022293s ]
select * from pdf where partno='1074352' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074352' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.049376s ]
SELECT `id` FROM `stock` WHERE `id` <> 64789989 AND `partno` = '1074352' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17013774 [ RunTime:0.027758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64789988 LIMIT 5 [ RunTime:0.012072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789988 ORDER BY `minOrder` ASC [ RunTime:0.009877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64789988 ORDER BY `unit` DESC [ RunTime:0.011370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64789988 LIMIT 2 [ RunTime:0.013873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789988 ORDER BY `minOrder` ASC [ RunTime:0.004829s ]
select * from pdf where partno='1074349' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074349' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.028069s ]
SELECT `id` FROM `stock` WHERE `id` <> 64789988 AND `partno` = '1074349' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18794657 [ RunTime:0.013031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64789025 LIMIT 5 [ RunTime:0.022405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789025 ORDER BY `minOrder` ASC [ RunTime:0.012513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64789025 ORDER BY `unit` DESC [ RunTime:0.026437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64789025 LIMIT 2 [ RunTime:0.033555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789025 ORDER BY `minOrder` ASC [ RunTime:0.004729s ]
select * from pdf where partno='1074379' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074379' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007879s ]
SELECT `id` FROM `stock` WHERE `id` <> 64789025 AND `partno` = '1074379' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18794002 [ RunTime:0.008977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64789024 LIMIT 5 [ RunTime:0.004756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789024 ORDER BY `minOrder` ASC [ RunTime:0.004906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64789024 ORDER BY `unit` DESC [ RunTime:0.001849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64789024 LIMIT 2 [ RunTime:0.013994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789024 ORDER BY `minOrder` ASC [ RunTime:0.001074s ]
select * from pdf where partno='1074378' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074378' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009860s ]
SELECT `id` FROM `stock` WHERE `id` <> 64789024 AND `partno` = '1074378' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18794001 [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64789023 LIMIT 5 [ RunTime:0.006664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789023 ORDER BY `minOrder` ASC [ RunTime:0.007968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64789023 ORDER BY `unit` DESC [ RunTime:0.009581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64789023 LIMIT 2 [ RunTime:0.013377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789023 ORDER BY `minOrder` ASC [ RunTime:0.010921s ]
select * from pdf where partno='1074377' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074377' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022434s ]
SELECT `id` FROM `stock` WHERE `id` <> 64789023 AND `partno` = '1074377' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.030936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18794000 [ RunTime:0.009397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64789022 LIMIT 5 [ RunTime:0.022800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789022 ORDER BY `minOrder` ASC [ RunTime:0.011389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64789022 ORDER BY `unit` DESC [ RunTime:0.017998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64789022 LIMIT 2 [ RunTime:0.005871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789022 ORDER BY `minOrder` ASC [ RunTime:0.005590s ]
select * from pdf where partno='1074372' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074372' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009221s ]
SELECT `id` FROM `stock` WHERE `id` <> 64789022 AND `partno` = '1074372' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793999 [ RunTime:0.000881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64789021 LIMIT 5 [ RunTime:0.000795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789021 ORDER BY `minOrder` ASC [ RunTime:0.000841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64789021 ORDER BY `unit` DESC [ RunTime:0.001430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64789021 LIMIT 2 [ RunTime:0.000733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64789021 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
select * from pdf where partno='1074371' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074371' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004211s ]
SELECT `id` FROM `stock` WHERE `id` <> 64789021 AND `partno` = '1074371' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793998 [ RunTime:0.001914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64788731 LIMIT 5 [ RunTime:0.011419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788731 ORDER BY `minOrder` ASC [ RunTime:0.009450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64788731 ORDER BY `unit` DESC [ RunTime:0.000923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64788731 LIMIT 2 [ RunTime:0.001561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788731 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
select * from pdf where partno='1074367' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074367' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009055s ]
SELECT `id` FROM `stock` WHERE `id` <> 64788731 AND `partno` = '1074367' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793802 [ RunTime:0.004151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64788730 LIMIT 5 [ RunTime:0.004460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788730 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64788730 ORDER BY `unit` DESC [ RunTime:0.005394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64788730 LIMIT 2 [ RunTime:0.012252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64788730 ORDER BY `minOrder` ASC [ RunTime:0.005461s ]
select * from pdf where partno='1074362' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1074362' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004026s ]
SELECT `id` FROM `stock` WHERE `id` <> 64788730 AND `partno` = '1074362' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793801 [ RunTime:0.004142s ]
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 '10743%' OR `brand` LIKE '10743%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004693s ]
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 '10743%' OR `brand` LIKE '10743%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016611s ]
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 '10743%' OR `brand` LIKE '10743%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018016s ]
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 '10743%' OR `brand` LIKE '10743%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017248s ]
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 '10743%' OR `brand` LIKE '10743%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020030s ]
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 '10743%' OR `brand` LIKE '10743%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046938s ]
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 '10743%' OR `brand` LIKE '10743%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002741s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10743%' OR `brand` LIKE '10743%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010275s ]