SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.005658s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=60493&search=1' [ RunTime:0.005747s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001403s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003679s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002262s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.011871s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001067s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.016015s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002107s ]
SELECT * FROM `stock_search` WHERE `partno` = '60493' LIMIT 1 [ RunTime:0.007098s ]
UPDATE `stock_search` SET `count` = 7 , `updatetime` = '2026-08-17 00:11:26' WHERE `partno` = '60493' [ RunTime:0.005638s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001788s ]
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 '60493%' OR `brand` LIKE '60493%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031194s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784362 LIMIT 5 [ RunTime:0.026327s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784362 ORDER BY `minOrder` ASC [ RunTime:0.075894s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.024596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784362 ORDER BY `unit` DESC [ RunTime:0.021033s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784362 LIMIT 2 [ RunTime:0.017457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784362 ORDER BY `minOrder` ASC [ RunTime:0.020194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19270386 LIMIT 5 [ RunTime:0.059004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19270386 ORDER BY `minOrder` ASC [ RunTime:0.057456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19270386 ORDER BY `unit` DESC [ RunTime:0.022058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19270386 LIMIT 2 [ RunTime:0.026733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19270386 ORDER BY `minOrder` ASC [ RunTime:0.027124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18820167 LIMIT 5 [ RunTime:0.017871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18820167 ORDER BY `minOrder` ASC [ RunTime:0.011157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18820167 ORDER BY `unit` DESC [ RunTime:0.032759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18820167 LIMIT 2 [ RunTime:0.027808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18820167 ORDER BY `minOrder` ASC [ RunTime:0.011245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18819300 LIMIT 5 [ RunTime:0.008713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18819300 ORDER BY `minOrder` ASC [ RunTime:0.016351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18819300 ORDER BY `unit` DESC [ RunTime:0.015847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18819300 LIMIT 2 [ RunTime:0.022230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18819300 ORDER BY `minOrder` ASC [ RunTime:0.016921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18816726 LIMIT 5 [ RunTime:0.029721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18816726 ORDER BY `minOrder` ASC [ RunTime:0.031846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18816726 ORDER BY `unit` DESC [ RunTime:0.019398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18816726 LIMIT 2 [ RunTime:0.016535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18816726 ORDER BY `minOrder` ASC [ RunTime:0.012839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18815425 LIMIT 5 [ RunTime:0.024578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18815425 ORDER BY `minOrder` ASC [ RunTime:0.004323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18815425 ORDER BY `unit` DESC [ RunTime:0.007308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18815425 LIMIT 2 [ RunTime:0.018484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18815425 ORDER BY `minOrder` ASC [ RunTime:0.006591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814371 LIMIT 5 [ RunTime:0.018026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814371 ORDER BY `minOrder` ASC [ RunTime:0.035635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18814371 ORDER BY `unit` DESC [ RunTime:0.062658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18814371 LIMIT 2 [ RunTime:0.012838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814371 ORDER BY `minOrder` ASC [ RunTime:0.008283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814358 LIMIT 5 [ RunTime:0.019597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814358 ORDER BY `minOrder` ASC [ RunTime:0.012175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18814358 ORDER BY `unit` DESC [ RunTime:0.026955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18814358 LIMIT 2 [ RunTime:0.004227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814358 ORDER BY `minOrder` ASC [ RunTime:0.004083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814352 LIMIT 5 [ RunTime:0.013365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814352 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18814352 ORDER BY `unit` DESC [ RunTime:0.000635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18814352 LIMIT 2 [ RunTime:0.009779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814352 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780468 LIMIT 5 [ RunTime:0.001069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780468 ORDER BY `minOrder` ASC [ RunTime:0.009246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780468 ORDER BY `unit` DESC [ RunTime:0.005011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780468 LIMIT 2 [ RunTime:0.002180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780468 ORDER BY `minOrder` ASC [ RunTime:0.008686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778342 LIMIT 5 [ RunTime:0.018025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778342 ORDER BY `minOrder` ASC [ RunTime:0.002766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18778342 ORDER BY `unit` DESC [ RunTime:0.009057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18778342 LIMIT 2 [ RunTime:0.017465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778342 ORDER BY `minOrder` ASC [ RunTime:0.002458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777522 LIMIT 5 [ RunTime:0.012598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777522 ORDER BY `minOrder` ASC [ RunTime:0.021997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777522 ORDER BY `unit` DESC [ RunTime:0.009955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777522 LIMIT 2 [ RunTime:0.001061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777522 ORDER BY `minOrder` ASC [ RunTime:0.003059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777217 LIMIT 5 [ RunTime:0.002204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777217 ORDER BY `minOrder` ASC [ RunTime:0.000905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777217 ORDER BY `unit` DESC [ RunTime:0.001725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777217 LIMIT 2 [ RunTime:0.018344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777217 ORDER BY `minOrder` ASC [ RunTime:0.001368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17017082 LIMIT 5 [ RunTime:0.010305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17017082 ORDER BY `minOrder` ASC [ RunTime:0.038001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17017082 ORDER BY `unit` DESC [ RunTime:0.003743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17017082 LIMIT 2 [ RunTime:0.009752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17017082 ORDER BY `minOrder` ASC [ RunTime:0.010195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16618534 LIMIT 5 [ RunTime:0.004212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16618534 ORDER BY `minOrder` ASC [ RunTime:0.000740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16618534 ORDER BY `unit` DESC [ RunTime:0.002810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16618534 LIMIT 2 [ RunTime:0.021829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16618534 ORDER BY `minOrder` ASC [ RunTime:0.008486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16618362 LIMIT 5 [ RunTime:0.004901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16618362 ORDER BY `minOrder` ASC [ RunTime:0.000967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16618362 ORDER BY `unit` DESC [ RunTime:0.009344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16618362 LIMIT 2 [ RunTime:0.011076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16618362 ORDER BY `minOrder` ASC [ RunTime:0.007659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16012054 LIMIT 5 [ RunTime:0.016693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012054 ORDER BY `minOrder` ASC [ RunTime:0.009770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16012054 ORDER BY `unit` DESC [ RunTime:0.015227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16012054 LIMIT 2 [ RunTime:0.026428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16012054 ORDER BY `minOrder` ASC [ RunTime:0.010493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15236002 LIMIT 5 [ RunTime:0.047450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15236002 ORDER BY `minOrder` ASC [ RunTime:0.006726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15236002 ORDER BY `unit` DESC [ RunTime:0.007059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15236002 LIMIT 2 [ RunTime:0.018294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15236002 ORDER BY `minOrder` ASC [ RunTime:0.008477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232301 LIMIT 5 [ RunTime:0.014219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232301 ORDER BY `minOrder` ASC [ RunTime:0.052973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15232301 ORDER BY `unit` DESC [ RunTime:0.013758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15232301 LIMIT 2 [ RunTime:0.012807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232301 ORDER BY `minOrder` ASC [ RunTime:0.008106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14182523 LIMIT 5 [ RunTime:0.009828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14182523 ORDER BY `minOrder` ASC [ RunTime:0.020134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14182523 ORDER BY `unit` DESC [ RunTime:0.008377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14182523 LIMIT 2 [ RunTime:0.013751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14182523 ORDER BY `minOrder` ASC [ RunTime:0.006042s ]
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 '60493%' OR `brand` LIKE '60493%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005695s ]
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 '60493%' OR `brand` LIKE '60493%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63349836 LIMIT 5 [ RunTime:0.030908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63349836 ORDER BY `minOrder` ASC [ RunTime:0.020748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63349836 ORDER BY `unit` DESC [ RunTime:0.032755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63349836 LIMIT 2 [ RunTime:0.059826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63349836 ORDER BY `minOrder` ASC [ RunTime:0.025395s ]
select * from pdf where partno='6049334' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016573s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049334' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015790s ]
SELECT `id` FROM `stock` WHERE `id` <> 63349836 AND `partno` = '6049334' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.026642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784362 [ RunTime:0.000929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64724456 LIMIT 5 [ RunTime:0.011270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64724456 ORDER BY `minOrder` ASC [ RunTime:0.012556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64724456 ORDER BY `unit` DESC [ RunTime:0.000749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64724456 LIMIT 2 [ RunTime:0.014969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64724456 ORDER BY `minOrder` ASC [ RunTime:0.015552s ]
select * from pdf where partno='6049321' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049321' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023039s ]
SELECT `id` FROM `stock` WHERE `id` <> 64724456 AND `partno` = '6049321' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.033184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18820167 [ RunTime:0.004627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64719396 LIMIT 5 [ RunTime:0.016296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719396 ORDER BY `minOrder` ASC [ RunTime:0.019065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64719396 ORDER BY `unit` DESC [ RunTime:0.022551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64719396 LIMIT 2 [ RunTime:0.028893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64719396 ORDER BY `minOrder` ASC [ RunTime:0.008609s ]
select * from pdf where partno='6049330' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049330' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024203s ]
SELECT `id` FROM `stock` WHERE `id` <> 64719396 AND `partno` = '6049330' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.026641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18819300 [ RunTime:0.033288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64716947 LIMIT 5 [ RunTime:0.049235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64716947 ORDER BY `minOrder` ASC [ RunTime:0.024845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64716947 ORDER BY `unit` DESC [ RunTime:0.015415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64716947 LIMIT 2 [ RunTime:0.012717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64716947 ORDER BY `minOrder` ASC [ RunTime:0.017480s ]
select * from pdf where partno='6049351' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049351' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.036036s ]
SELECT `id` FROM `stock` WHERE `id` <> 64716947 AND `partno` = '6049351' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16012054 [ RunTime:0.018727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64716771 LIMIT 5 [ RunTime:0.023067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64716771 ORDER BY `minOrder` ASC [ RunTime:0.028435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64716771 ORDER BY `unit` DESC [ RunTime:0.018091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64716771 LIMIT 2 [ RunTime:0.020377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64716771 ORDER BY `minOrder` ASC [ RunTime:0.021544s ]
select * from pdf where partno='6049315' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.029383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049315' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005853s ]
SELECT `id` FROM `stock` WHERE `id` <> 64716771 AND `partno` = '6049315' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232301 [ RunTime:0.016783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64712903 LIMIT 5 [ RunTime:0.008192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64712903 ORDER BY `minOrder` ASC [ RunTime:0.013875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64712903 ORDER BY `unit` DESC [ RunTime:0.003005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64712903 LIMIT 2 [ RunTime:0.009515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64712903 ORDER BY `minOrder` ASC [ RunTime:0.009696s ]
select * from pdf where partno='6049341' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049341' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017943s ]
SELECT `id` FROM `stock` WHERE `id` <> 64712903 AND `partno` = '6049341' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18816726 [ RunTime:0.004719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64710172 LIMIT 5 [ RunTime:0.014538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710172 ORDER BY `minOrder` ASC [ RunTime:0.005447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64710172 ORDER BY `unit` DESC [ RunTime:0.011956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64710172 LIMIT 2 [ RunTime:0.013321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710172 ORDER BY `minOrder` ASC [ RunTime:0.015337s ]
select * from pdf where partno='6049340' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049340' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020964s ]
SELECT `id` FROM `stock` WHERE `id` <> 64710172 AND `partno` = '6049340' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18815425 [ RunTime:0.005169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64709339 LIMIT 5 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64709339 ORDER BY `minOrder` ASC [ RunTime:0.006138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64709339 ORDER BY `unit` DESC [ RunTime:0.002482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64709339 LIMIT 2 [ RunTime:0.001579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64709339 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
select * from pdf where partno='6049316' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049316' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000807s ]
SELECT `id` FROM `stock` WHERE `id` <> 64709339 AND `partno` = '6049316' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14182523 [ RunTime:0.001322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64708502 LIMIT 5 [ RunTime:0.006829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64708502 ORDER BY `minOrder` ASC [ RunTime:0.008597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64708502 ORDER BY `unit` DESC [ RunTime:0.005977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64708502 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64708502 ORDER BY `minOrder` ASC [ RunTime:0.017540s ]
select * from pdf where partno='6049352' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008569s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049352' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000997s ]
SELECT `id` FROM `stock` WHERE `id` <> 64708502 AND `partno` = '6049352' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17017082 [ RunTime:0.005277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64708484 LIMIT 5 [ RunTime:0.011655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64708484 ORDER BY `minOrder` ASC [ RunTime:0.002600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64708484 ORDER BY `unit` DESC [ RunTime:0.003271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64708484 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64708484 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='6049387' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049387' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000881s ]
SELECT `id` FROM `stock` WHERE `id` <> 64708484 AND `partno` = '6049387' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814371 [ RunTime:0.000645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64708463 LIMIT 5 [ RunTime:0.003478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64708463 ORDER BY `minOrder` ASC [ RunTime:0.011120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64708463 ORDER BY `unit` DESC [ RunTime:0.000802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64708463 LIMIT 2 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64708463 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='6049386' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049386' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012648s ]
SELECT `id` FROM `stock` WHERE `id` <> 64708463 AND `partno` = '6049386' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814358 [ RunTime:0.002808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64708450 LIMIT 5 [ RunTime:0.003233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64708450 ORDER BY `minOrder` ASC [ RunTime:0.008022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64708450 ORDER BY `unit` DESC [ RunTime:0.013915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64708450 LIMIT 2 [ RunTime:0.015819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64708450 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
select * from pdf where partno='6049311' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049311' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006072s ]
SELECT `id` FROM `stock` WHERE `id` <> 64708450 AND `partno` = '6049311' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814352 [ RunTime:0.011753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64640097 LIMIT 5 [ RunTime:0.007746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64640097 ORDER BY `minOrder` ASC [ RunTime:0.005559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64640097 ORDER BY `unit` DESC [ RunTime:0.008526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64640097 LIMIT 2 [ RunTime:0.005043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64640097 ORDER BY `minOrder` ASC [ RunTime:0.002715s ]
select * from pdf where partno='6049361' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049361' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006463s ]
SELECT `id` FROM `stock` WHERE `id` <> 64640097 AND `partno` = '6049361' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777217 [ RunTime:0.000717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64638931 LIMIT 5 [ RunTime:0.001614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64638931 ORDER BY `minOrder` ASC [ RunTime:0.020960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64638931 ORDER BY `unit` DESC [ RunTime:0.022609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64638931 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64638931 ORDER BY `minOrder` ASC [ RunTime:0.019731s ]
select * from pdf where partno='6049356' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049356' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015361s ]
SELECT `id` FROM `stock` WHERE `id` <> 64638931 AND `partno` = '6049356' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778342 [ RunTime:0.019670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63345761 LIMIT 5 [ RunTime:0.001512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345761 ORDER BY `minOrder` ASC [ RunTime:0.002092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63345761 ORDER BY `unit` DESC [ RunTime:0.001856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63345761 LIMIT 2 [ RunTime:0.009885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345761 ORDER BY `minOrder` ASC [ RunTime:0.006909s ]
select * from pdf where partno='6049355' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049355' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008537s ]
SELECT `id` FROM `stock` WHERE `id` <> 63345761 AND `partno` = '6049355' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780468 [ RunTime:0.000803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63267149 LIMIT 5 [ RunTime:0.006066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267149 ORDER BY `minOrder` ASC [ RunTime:0.001500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63267149 ORDER BY `unit` DESC [ RunTime:0.000684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63267149 LIMIT 2 [ RunTime:0.007318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267149 ORDER BY `minOrder` ASC [ RunTime:0.005991s ]
select * from pdf where partno='6049385' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049385' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003148s ]
SELECT `id` FROM `stock` WHERE `id` <> 63267149 AND `partno` = '6049385' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13266068 [ RunTime:0.002341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63266891 LIMIT 5 [ RunTime:0.019947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266891 ORDER BY `minOrder` ASC [ RunTime:0.001131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63266891 ORDER BY `unit` DESC [ RunTime:0.008608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63266891 LIMIT 2 [ RunTime:0.002246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63266891 ORDER BY `minOrder` ASC [ RunTime:0.000821s ]
select * from pdf where partno='6049327' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049327' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007001s ]
SELECT `id` FROM `stock` WHERE `id` <> 63266891 AND `partno` = '6049327' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265991 [ RunTime:0.002969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62206790 LIMIT 5 [ RunTime:0.007731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62206790 ORDER BY `minOrder` ASC [ RunTime:0.020602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62206790 ORDER BY `unit` DESC [ RunTime:0.011451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62206790 LIMIT 2 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62206790 ORDER BY `minOrder` ASC [ RunTime:0.002019s ]
select * from pdf where partno='6049399' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049399' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009086s ]
SELECT `id` FROM `stock` WHERE `id` <> 62206790 AND `partno` = '6049399' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13805000 [ RunTime:0.002885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62206071 LIMIT 5 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62206071 ORDER BY `minOrder` ASC [ RunTime:0.009923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62206071 ORDER BY `unit` DESC [ RunTime:0.002764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62206071 LIMIT 2 [ RunTime:0.006282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62206071 ORDER BY `minOrder` ASC [ RunTime:0.002165s ]
select * from pdf where partno='6049329' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049329' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003518s ]
SELECT `id` FROM `stock` WHERE `id` <> 62206071 AND `partno` = '6049329' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16618534 [ RunTime:0.000610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62204609 LIMIT 5 [ RunTime:0.005830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62204609 ORDER BY `minOrder` ASC [ RunTime:0.008339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62204609 ORDER BY `unit` DESC [ RunTime:0.010032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62204609 LIMIT 2 [ RunTime:0.010673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62204609 ORDER BY `minOrder` ASC [ RunTime:0.011650s ]
select * from pdf where partno='6049328' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6049328' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012998s ]
SELECT `id` FROM `stock` WHERE `id` <> 62204609 AND `partno` = '6049328' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16618362 [ RunTime:0.008531s ]
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 '60493%' OR `brand` LIKE '60493%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002237s ]
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 '60493%' OR `brand` LIKE '60493%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008715s ]
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 '60493%' OR `brand` LIKE '60493%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012693s ]
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 '60493%' OR `brand` LIKE '60493%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006904s ]
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 '60493%' OR `brand` LIKE '60493%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010457s ]
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 '60493%' OR `brand` LIKE '60493%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024284s ]
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 '60493%' OR `brand` LIKE '60493%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019173s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60493%' OR `brand` LIKE '60493%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010361s ]