SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001447s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.148' , `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=60544&search=1' [ RunTime:0.004047s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001299s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001146s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002450s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.148' ) [ RunTime:0.000506s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001196s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001343s ]
SELECT * FROM `stock_search` WHERE `partno` = '60544' LIMIT 1 [ RunTime:0.001129s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-10-16 18:04:00' WHERE `partno` = '60544' [ RunTime:0.002632s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001356s ]
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 '60544%' OR `brand` LIKE '60544%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009286s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19270466 LIMIT 5 [ RunTime:0.003887s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19270466 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19270466 ORDER BY `unit` DESC [ RunTime:0.000491s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19270466 LIMIT 2 [ RunTime:0.000452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19270466 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18840075 LIMIT 5 [ RunTime:0.001933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18840075 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18840075 ORDER BY `unit` DESC [ RunTime:0.000359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18840075 LIMIT 2 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18840075 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18822204 LIMIT 5 [ RunTime:0.002132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822204 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18822204 ORDER BY `unit` DESC [ RunTime:0.000340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18822204 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822204 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18819629 LIMIT 5 [ RunTime:0.000691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18819629 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18819629 ORDER BY `unit` DESC [ RunTime:0.000321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18819629 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18819629 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18817510 LIMIT 5 [ RunTime:0.002419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18817510 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18817510 ORDER BY `unit` DESC [ RunTime:0.000369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18817510 LIMIT 2 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18817510 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18816940 LIMIT 5 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18816940 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18816940 ORDER BY `unit` DESC [ RunTime:0.000350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18816940 LIMIT 2 [ RunTime:0.000903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18816940 ORDER BY `minOrder` ASC [ RunTime:0.000647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18815543 LIMIT 5 [ RunTime:0.000919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18815543 ORDER BY `minOrder` ASC [ RunTime:0.000703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18815543 ORDER BY `unit` DESC [ RunTime:0.000594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18815543 LIMIT 2 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18815543 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814975 LIMIT 5 [ RunTime:0.001268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814975 ORDER BY `minOrder` ASC [ RunTime:0.000627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18814975 ORDER BY `unit` DESC [ RunTime:0.000660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18814975 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814975 ORDER BY `minOrder` ASC [ RunTime:0.000591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814377 LIMIT 5 [ RunTime:0.001441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814377 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18814377 ORDER BY `unit` DESC [ RunTime:0.000675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18814377 LIMIT 2 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814377 ORDER BY `minOrder` ASC [ RunTime:0.000661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777526 LIMIT 5 [ RunTime:0.001890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777526 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777526 ORDER BY `unit` DESC [ RunTime:0.000575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777526 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777526 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777265 LIMIT 5 [ RunTime:0.002581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777265 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777265 ORDER BY `unit` DESC [ RunTime:0.000579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777265 LIMIT 2 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777265 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18776777 LIMIT 5 [ RunTime:0.001013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18776777 ORDER BY `minOrder` ASC [ RunTime:0.000631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18776777 ORDER BY `unit` DESC [ RunTime:0.000573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18776777 LIMIT 2 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18776777 ORDER BY `minOrder` ASC [ RunTime:0.000595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17507696 LIMIT 5 [ RunTime:0.000804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17507696 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17507696 ORDER BY `unit` DESC [ RunTime:0.000409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17507696 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17507696 ORDER BY `minOrder` ASC [ RunTime:0.000810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17142118 LIMIT 5 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17142118 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17142118 ORDER BY `unit` DESC [ RunTime:0.000757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17142118 LIMIT 2 [ RunTime:0.000754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17142118 ORDER BY `minOrder` ASC [ RunTime:0.000714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17018244 LIMIT 5 [ RunTime:0.001074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17018244 ORDER BY `minOrder` ASC [ RunTime:0.000727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17018244 ORDER BY `unit` DESC [ RunTime:0.000622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17018244 LIMIT 2 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17018244 ORDER BY `minOrder` ASC [ RunTime:0.000722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17018103 LIMIT 5 [ RunTime:0.001038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17018103 ORDER BY `minOrder` ASC [ RunTime:0.000727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17018103 ORDER BY `unit` DESC [ RunTime:0.000676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17018103 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17018103 ORDER BY `minOrder` ASC [ RunTime:0.000687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232545 LIMIT 5 [ RunTime:0.001029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232545 ORDER BY `minOrder` ASC [ RunTime:0.000770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15232545 ORDER BY `unit` DESC [ RunTime:0.000632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15232545 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232545 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232345 LIMIT 5 [ RunTime:0.001031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232345 ORDER BY `minOrder` ASC [ RunTime:0.000786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15232345 ORDER BY `unit` DESC [ RunTime:0.000723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15232345 LIMIT 2 [ RunTime:0.000797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232345 ORDER BY `minOrder` ASC [ RunTime:0.000812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224488 LIMIT 5 [ RunTime:0.001096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224488 ORDER BY `minOrder` ASC [ RunTime:0.000769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15224488 ORDER BY `unit` DESC [ RunTime:0.000692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15224488 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224488 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224435 LIMIT 5 [ RunTime:0.002581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224435 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15224435 ORDER BY `unit` DESC [ RunTime:0.000495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15224435 LIMIT 2 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224435 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
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 '60544%' OR `brand` LIKE '60544%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001403s ]
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 '60544%' OR `brand` LIKE '60544%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69759740 LIMIT 5 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69759740 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69759740 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69759740 LIMIT 2 [ RunTime:0.000257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69759740 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='6054492' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002183s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054492' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000737s ]
SELECT `id` FROM `stock` WHERE `id` <> 69759740 AND `partno` = '6054492' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14669039 [ RunTime:0.001586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71482773 LIMIT 5 [ RunTime:0.000522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71482773 ORDER BY `minOrder` ASC [ RunTime:0.000980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71482773 ORDER BY `unit` DESC [ RunTime:0.000552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71482773 LIMIT 2 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71482773 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
select * from pdf where partno='6054448' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054448' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000655s ]
SELECT `id` FROM `stock` WHERE `id` <> 71482773 AND `partno` = '6054448' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17018244 [ RunTime:0.000539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71480465 LIMIT 5 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71480465 ORDER BY `minOrder` ASC [ RunTime:0.001012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71480465 ORDER BY `unit` DESC [ RunTime:0.000513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71480465 LIMIT 2 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71480465 ORDER BY `minOrder` ASC [ RunTime:0.000561s ]
select * from pdf where partno='6054459' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054459' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000636s ]
SELECT `id` FROM `stock` WHERE `id` <> 71480465 AND `partno` = '6054459' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232545 [ RunTime:0.000532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71479687 LIMIT 5 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71479687 ORDER BY `minOrder` ASC [ RunTime:0.000990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71479687 ORDER BY `unit` DESC [ RunTime:0.000508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71479687 LIMIT 2 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71479687 ORDER BY `minOrder` ASC [ RunTime:0.000585s ]
select * from pdf where partno='6054477' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054477' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000972s ]
SELECT `id` FROM `stock` WHERE `id` <> 71479687 AND `partno` = '6054477' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18819629 [ RunTime:0.000558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71479376 LIMIT 5 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71479376 ORDER BY `minOrder` ASC [ RunTime:0.001758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71479376 ORDER BY `unit` DESC [ RunTime:0.000507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71479376 LIMIT 2 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71479376 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='6054485' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054485' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000795s ]
SELECT `id` FROM `stock` WHERE `id` <> 71479376 AND `partno` = '6054485' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17018103 [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71476544 LIMIT 5 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71476544 ORDER BY `minOrder` ASC [ RunTime:0.001140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71476544 ORDER BY `unit` DESC [ RunTime:0.000482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71476544 LIMIT 2 [ RunTime:0.000470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71476544 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
select * from pdf where partno='6054431' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054431' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000625s ]
SELECT `id` FROM `stock` WHERE `id` <> 71476544 AND `partno` = '6054431' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232345 [ RunTime:0.000420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71474083 LIMIT 5 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71474083 ORDER BY `minOrder` ASC [ RunTime:0.004426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71474083 ORDER BY `unit` DESC [ RunTime:0.000657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71474083 LIMIT 2 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71474083 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
select * from pdf where partno='6054468' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054468' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000848s ]
SELECT `id` FROM `stock` WHERE `id` <> 71474083 AND `partno` = '6054468' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18817510 [ RunTime:0.000695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71472228 LIMIT 5 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71472228 ORDER BY `minOrder` ASC [ RunTime:0.001161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71472228 ORDER BY `unit` DESC [ RunTime:0.000655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71472228 LIMIT 2 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71472228 ORDER BY `minOrder` ASC [ RunTime:0.000681s ]
select * from pdf where partno='6054420' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054420' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000812s ]
SELECT `id` FROM `stock` WHERE `id` <> 71472228 AND `partno` = '6054420' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18816940 [ RunTime:0.000700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71469216 LIMIT 5 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71469216 ORDER BY `minOrder` ASC [ RunTime:0.001238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71469216 ORDER BY `unit` DESC [ RunTime:0.000716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71469216 LIMIT 2 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71469216 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
select * from pdf where partno='6054443' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054443' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000916s ]
SELECT `id` FROM `stock` WHERE `id` <> 71469216 AND `partno` = '6054443' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18815543 [ RunTime:0.000650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71468525 LIMIT 5 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71468525 ORDER BY `minOrder` ASC [ RunTime:0.003645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71468525 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71468525 LIMIT 2 [ RunTime:0.000461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71468525 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
select * from pdf where partno='6054458' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054458' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000559s ]
SELECT `id` FROM `stock` WHERE `id` <> 71468525 AND `partno` = '6054458' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814975 [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71467290 LIMIT 5 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71467290 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71467290 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71467290 LIMIT 2 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71467290 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
select * from pdf where partno='6054473' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054473' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000632s ]
SELECT `id` FROM `stock` WHERE `id` <> 71467290 AND `partno` = '6054473' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814377 [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71399804 LIMIT 5 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71399804 ORDER BY `minOrder` ASC [ RunTime:0.005960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71399804 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71399804 LIMIT 2 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71399804 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='6054410' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054410' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000595s ]
SELECT `id` FROM `stock` WHERE `id` <> 71399804 AND `partno` = '6054410' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777265 [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71398738 LIMIT 5 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71398738 ORDER BY `minOrder` ASC [ RunTime:0.002241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71398738 ORDER BY `unit` DESC [ RunTime:0.000422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71398738 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71398738 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='6054441' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054441' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000538s ]
SELECT `id` FROM `stock` WHERE `id` <> 71398738 AND `partno` = '6054441' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18776777 [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70894834 LIMIT 5 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70894834 ORDER BY `minOrder` ASC [ RunTime:0.010770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70894834 ORDER BY `unit` DESC [ RunTime:0.000485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70894834 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70894834 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
select * from pdf where partno='6054498' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054498' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000465s ]
SELECT `id` FROM `stock` WHERE `id` <> 70894834 AND `partno` = '6054498' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18840075 [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70048971 LIMIT 5 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70048971 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70048971 ORDER BY `unit` DESC [ RunTime:0.000329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70048971 LIMIT 2 [ RunTime:0.000288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70048971 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='6054472' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054472' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000394s ]
SELECT `id` FROM `stock` WHERE `id` <> 70048971 AND `partno` = '6054472' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13266100 [ RunTime:0.000594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70003351 LIMIT 5 [ RunTime:0.000313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70003351 ORDER BY `minOrder` ASC [ RunTime:0.007131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70003351 ORDER BY `unit` DESC [ RunTime:0.000393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70003351 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70003351 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
select * from pdf where partno='6054490' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054490' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000889s ]
SELECT `id` FROM `stock` WHERE `id` <> 70003351 AND `partno` = '6054490' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11236492 [ RunTime:0.001280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70002647 LIMIT 5 [ RunTime:0.000523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70002647 ORDER BY `minOrder` ASC [ RunTime:0.004336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70002647 ORDER BY `unit` DESC [ RunTime:0.000547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70002647 LIMIT 2 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70002647 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
select * from pdf where partno='6054491' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054491' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000651s ]
SELECT `id` FROM `stock` WHERE `id` <> 70002647 AND `partno` = '6054491' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12241125 [ RunTime:0.000851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69763229 LIMIT 5 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69763229 ORDER BY `minOrder` ASC [ RunTime:0.000994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69763229 ORDER BY `unit` DESC [ RunTime:0.000504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69763229 LIMIT 2 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69763229 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
select * from pdf where partno='6054493' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054493' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000666s ]
SELECT `id` FROM `stock` WHERE `id` <> 69763229 AND `partno` = '6054493' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14668984 [ RunTime:0.000719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69012230 LIMIT 5 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69012230 ORDER BY `minOrder` ASC [ RunTime:0.001223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69012230 ORDER BY `unit` DESC [ RunTime:0.000494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69012230 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69012230 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
select * from pdf where partno='6054435' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054435' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000654s ]
SELECT `id` FROM `stock` WHERE `id` <> 69012230 AND `partno` = '6054435' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14695073 [ RunTime:0.002961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69010876 LIMIT 5 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69010876 ORDER BY `minOrder` ASC [ RunTime:0.000954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69010876 ORDER BY `unit` DESC [ RunTime:0.000500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69010876 LIMIT 2 [ RunTime:0.000509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69010876 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
select * from pdf where partno='6054436' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6054436' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000629s ]
SELECT `id` FROM `stock` WHERE `id` <> 69010876 AND `partno` = '6054436' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13805537 [ RunTime:0.003991s ]
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 '60544%' OR `brand` LIKE '60544%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001188s ]
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 '60544%' OR `brand` LIKE '60544%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001097s ]
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 '60544%' OR `brand` LIKE '60544%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001080s ]
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 '60544%' OR `brand` LIKE '60544%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001054s ]
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 '60544%' OR `brand` LIKE '60544%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001057s ]
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 '60544%' OR `brand` LIKE '60544%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001067s ]
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 '60544%' OR `brand` LIKE '60544%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001117s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60544%' OR `brand` LIKE '60544%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001458s ]