SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002337s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=60788&search=1' [ RunTime:0.010508s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002588s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005564s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002828s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.007865s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002822s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000897s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002024s ]
SELECT * FROM `stock_search` WHERE `partno` = '60788' LIMIT 1 [ RunTime:0.011724s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-05 02:28:01' WHERE `partno` = '60788' [ RunTime:0.019939s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002231s ]
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 '60788%' OR `brand` LIKE '60788%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032971s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160841 LIMIT 5 [ RunTime:0.022477s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160841 ORDER BY `minOrder` ASC [ RunTime:0.014752s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12160841 ORDER BY `unit` DESC [ RunTime:0.035697s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12160841 LIMIT 2 [ RunTime:0.039291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160841 ORDER BY `minOrder` ASC [ RunTime:0.008138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18817344 LIMIT 5 [ RunTime:0.070021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18817344 ORDER BY `minOrder` ASC [ RunTime:0.100290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18817344 ORDER BY `unit` DESC [ RunTime:0.033731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18817344 LIMIT 2 [ RunTime:0.014203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18817344 ORDER BY `minOrder` ASC [ RunTime:0.010639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18815658 LIMIT 5 [ RunTime:0.051411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18815658 ORDER BY `minOrder` ASC [ RunTime:0.051707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18815658 ORDER BY `unit` DESC [ RunTime:0.064428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18815658 LIMIT 2 [ RunTime:0.051274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18815658 ORDER BY `minOrder` ASC [ RunTime:0.051093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18815439 LIMIT 5 [ RunTime:0.051423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18815439 ORDER BY `minOrder` ASC [ RunTime:0.050933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18815439 ORDER BY `unit` DESC [ RunTime:0.050868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18815439 LIMIT 2 [ RunTime:0.020905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18815439 ORDER BY `minOrder` ASC [ RunTime:0.020869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814877 LIMIT 5 [ RunTime:0.022117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814877 ORDER BY `minOrder` ASC [ RunTime:0.019382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18814877 ORDER BY `unit` DESC [ RunTime:0.040410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18814877 LIMIT 2 [ RunTime:0.097742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814877 ORDER BY `minOrder` ASC [ RunTime:0.019570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778364 LIMIT 5 [ RunTime:0.033596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778364 ORDER BY `minOrder` ASC [ RunTime:0.038529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18778364 ORDER BY `unit` DESC [ RunTime:0.015639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18778364 LIMIT 2 [ RunTime:0.036789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778364 ORDER BY `minOrder` ASC [ RunTime:0.013387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777383 LIMIT 5 [ RunTime:0.061174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777383 ORDER BY `minOrder` ASC [ RunTime:0.020787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777383 ORDER BY `unit` DESC [ RunTime:0.022661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777383 LIMIT 2 [ RunTime:0.018666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777383 ORDER BY `minOrder` ASC [ RunTime:0.050039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18776988 LIMIT 5 [ RunTime:0.017273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18776988 ORDER BY `minOrder` ASC [ RunTime:0.016535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18776988 ORDER BY `unit` DESC [ RunTime:0.007917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18776988 LIMIT 2 [ RunTime:0.018938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18776988 ORDER BY `minOrder` ASC [ RunTime:0.007442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17151326 LIMIT 5 [ RunTime:0.010095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17151326 ORDER BY `minOrder` ASC [ RunTime:0.010496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17151326 ORDER BY `unit` DESC [ RunTime:0.007037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17151326 LIMIT 2 [ RunTime:0.008651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17151326 ORDER BY `minOrder` ASC [ RunTime:0.015493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17017692 LIMIT 5 [ RunTime:0.009468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17017692 ORDER BY `minOrder` ASC [ RunTime:0.001697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17017692 ORDER BY `unit` DESC [ RunTime:0.007571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17017692 LIMIT 2 [ RunTime:0.017321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17017692 ORDER BY `minOrder` ASC [ RunTime:0.023639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17017691 LIMIT 5 [ RunTime:0.025214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17017691 ORDER BY `minOrder` ASC [ RunTime:0.008600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17017691 ORDER BY `unit` DESC [ RunTime:0.023976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17017691 LIMIT 2 [ RunTime:0.029569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17017691 ORDER BY `minOrder` ASC [ RunTime:0.032004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231426 LIMIT 5 [ RunTime:0.014376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231426 ORDER BY `minOrder` ASC [ RunTime:0.008564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15231426 ORDER BY `unit` DESC [ RunTime:0.034518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15231426 LIMIT 2 [ RunTime:0.047712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231426 ORDER BY `minOrder` ASC [ RunTime:0.015020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14182672 LIMIT 5 [ RunTime:0.019770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14182672 ORDER BY `minOrder` ASC [ RunTime:0.012165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14182672 ORDER BY `unit` DESC [ RunTime:0.022442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14182672 LIMIT 2 [ RunTime:0.017730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14182672 ORDER BY `minOrder` ASC [ RunTime:0.017358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13266264 LIMIT 5 [ RunTime:0.021670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13266264 ORDER BY `minOrder` ASC [ RunTime:0.026443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13266264 ORDER BY `unit` DESC [ RunTime:0.017195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13266264 LIMIT 2 [ RunTime:0.022059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13266264 ORDER BY `minOrder` ASC [ RunTime:0.030169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12024846 LIMIT 5 [ RunTime:0.037252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12024846 ORDER BY `minOrder` ASC [ RunTime:0.008579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12024846 ORDER BY `unit` DESC [ RunTime:0.034242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12024846 LIMIT 2 [ RunTime:0.053802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12024846 ORDER BY `minOrder` ASC [ RunTime:0.016455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12021185 LIMIT 5 [ RunTime:0.030647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12021185 ORDER BY `minOrder` ASC [ RunTime:0.009460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12021185 ORDER BY `unit` DESC [ RunTime:0.024540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12021185 LIMIT 2 [ RunTime:0.006939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12021185 ORDER BY `minOrder` ASC [ RunTime:0.004404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992313 LIMIT 5 [ RunTime:0.057018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11992313 ORDER BY `minOrder` ASC [ RunTime:0.006550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11992313 ORDER BY `unit` DESC [ RunTime:0.032155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11992313 LIMIT 2 [ RunTime:0.043595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11992313 ORDER BY `minOrder` ASC [ RunTime:0.010416s ]
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 '60788%' OR `brand` LIKE '60788%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004540s ]
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 '60788%' OR `brand` LIKE '60788%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58587239 LIMIT 5 [ RunTime:0.013825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58587239 ORDER BY `minOrder` ASC [ RunTime:0.019028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58587239 ORDER BY `unit` DESC [ RunTime:0.008674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58587239 LIMIT 2 [ RunTime:0.017549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58587239 ORDER BY `minOrder` ASC [ RunTime:0.005978s ]
select * from pdf where partno='60788' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.014686s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60788' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.017586s ]
SELECT `id` FROM `stock` WHERE `id` <> 58587239 AND `partno` = '60788' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.014856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160841 [ RunTime:0.017684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64638983 LIMIT 5 [ RunTime:0.021629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64638983 ORDER BY `minOrder` ASC [ RunTime:0.021299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64638983 ORDER BY `unit` DESC [ RunTime:0.009504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64638983 LIMIT 2 [ RunTime:0.013293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64638983 ORDER BY `minOrder` ASC [ RunTime:0.004809s ]
select * from pdf where partno='6078830' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6078830' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008913s ]
SELECT `id` FROM `stock` WHERE `id` <> 64638983 AND `partno` = '6078830' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778364 [ RunTime:0.003886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63267545 LIMIT 5 [ RunTime:0.010702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267545 ORDER BY `minOrder` ASC [ RunTime:0.003519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63267545 ORDER BY `unit` DESC [ RunTime:0.006931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63267545 LIMIT 2 [ RunTime:0.014882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267545 ORDER BY `minOrder` ASC [ RunTime:0.008499s ]
select * from pdf where partno='6078847' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6078847' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012148s ]
SELECT `id` FROM `stock` WHERE `id` <> 63267545 AND `partno` = '6078847' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13266264 [ RunTime:0.004041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63267224 LIMIT 5 [ RunTime:0.002126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267224 ORDER BY `minOrder` ASC [ RunTime:0.006159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63267224 ORDER BY `unit` DESC [ RunTime:0.001326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63267224 LIMIT 2 [ RunTime:0.007736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63267224 ORDER BY `minOrder` ASC [ RunTime:0.003460s ]
select * from pdf where partno='6078848' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6078848' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005218s ]
SELECT `id` FROM `stock` WHERE `id` <> 63267224 AND `partno` = '6078848' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11992313 [ RunTime:0.002877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57896522 LIMIT 5 [ RunTime:0.001757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57896522 ORDER BY `minOrder` ASC [ RunTime:0.003464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57896522 ORDER BY `unit` DESC [ RunTime:0.027881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57896522 LIMIT 2 [ RunTime:0.032151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57896522 ORDER BY `minOrder` ASC [ RunTime:0.049960s ]
select * from pdf where partno='6078855' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.019415s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6078855' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.067126s ]
SELECT `id` FROM `stock` WHERE `id` <> 57896522 AND `partno` = '6078855' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17017692 [ RunTime:0.061105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57896521 LIMIT 5 [ RunTime:0.059710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57896521 ORDER BY `minOrder` ASC [ RunTime:0.022464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57896521 ORDER BY `unit` DESC [ RunTime:0.031520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57896521 LIMIT 2 [ RunTime:0.030757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57896521 ORDER BY `minOrder` ASC [ RunTime:0.025513s ]
select * from pdf where partno='6078878' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025892s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6078878' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012399s ]
SELECT `id` FROM `stock` WHERE `id` <> 57896521 AND `partno` = '6078878' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17017691 [ RunTime:0.008283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57895307 LIMIT 5 [ RunTime:0.011490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57895307 ORDER BY `minOrder` ASC [ RunTime:0.001279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57895307 ORDER BY `unit` DESC [ RunTime:0.002780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57895307 LIMIT 2 [ RunTime:0.000949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57895307 ORDER BY `minOrder` ASC [ RunTime:0.003215s ]
select * from pdf where partno='6078874' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6078874' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005359s ]
SELECT `id` FROM `stock` WHERE `id` <> 57895307 AND `partno` = '6078874' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18817344 [ RunTime:0.002997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57893805 LIMIT 5 [ RunTime:0.001524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57893805 ORDER BY `minOrder` ASC [ RunTime:0.002717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57893805 ORDER BY `unit` DESC [ RunTime:0.001307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57893805 LIMIT 2 [ RunTime:0.003583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57893805 ORDER BY `minOrder` ASC [ RunTime:0.000980s ]
select * from pdf where partno='6078810' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6078810' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009786s ]
SELECT `id` FROM `stock` WHERE `id` <> 57893805 AND `partno` = '6078810' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14182672 [ RunTime:0.007162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57891871 LIMIT 5 [ RunTime:0.006317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57891871 ORDER BY `minOrder` ASC [ RunTime:0.003040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57891871 ORDER BY `unit` DESC [ RunTime:0.001364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57891871 LIMIT 2 [ RunTime:0.001555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57891871 ORDER BY `minOrder` ASC [ RunTime:0.000632s ]
select * from pdf where partno='6078836' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6078836' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007706s ]
SELECT `id` FROM `stock` WHERE `id` <> 57891871 AND `partno` = '6078836' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18815658 [ RunTime:0.001092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57891551 LIMIT 5 [ RunTime:0.002969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57891551 ORDER BY `minOrder` ASC [ RunTime:0.006523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57891551 ORDER BY `unit` DESC [ RunTime:0.001344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57891551 LIMIT 2 [ RunTime:0.001597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57891551 ORDER BY `minOrder` ASC [ RunTime:0.005556s ]
select * from pdf where partno='6078834' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001964s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6078834' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003808s ]
SELECT `id` FROM `stock` WHERE `id` <> 57891551 AND `partno` = '6078834' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18815439 [ RunTime:0.005943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57890552 LIMIT 5 [ RunTime:0.006733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57890552 ORDER BY `minOrder` ASC [ RunTime:0.005628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57890552 ORDER BY `unit` DESC [ RunTime:0.011727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57890552 LIMIT 2 [ RunTime:0.001531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57890552 ORDER BY `minOrder` ASC [ RunTime:0.004457s ]
select * from pdf where partno='6078837' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6078837' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009594s ]
SELECT `id` FROM `stock` WHERE `id` <> 57890552 AND `partno` = '6078837' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814877 [ RunTime:0.008523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57889777 LIMIT 5 [ RunTime:0.010119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57889777 ORDER BY `minOrder` ASC [ RunTime:0.008450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57889777 ORDER BY `unit` DESC [ RunTime:0.006020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57889777 LIMIT 2 [ RunTime:0.008517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57889777 ORDER BY `minOrder` ASC [ RunTime:0.003259s ]
select * from pdf where partno='6078817' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6078817' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014629s ]
SELECT `id` FROM `stock` WHERE `id` <> 57889777 AND `partno` = '6078817' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.020688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231426 [ RunTime:0.017797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57819653 LIMIT 5 [ RunTime:0.004056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57819653 ORDER BY `minOrder` ASC [ RunTime:0.006269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57819653 ORDER BY `unit` DESC [ RunTime:0.008400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57819653 LIMIT 2 [ RunTime:0.010494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57819653 ORDER BY `minOrder` ASC [ RunTime:0.006212s ]
select * from pdf where partno='6078871' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6078871' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005490s ]
SELECT `id` FROM `stock` WHERE `id` <> 57819653 AND `partno` = '6078871' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777383 [ RunTime:0.003438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57819013 LIMIT 5 [ RunTime:0.003296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57819013 ORDER BY `minOrder` ASC [ RunTime:0.006898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57819013 ORDER BY `unit` DESC [ RunTime:0.012763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57819013 LIMIT 2 [ RunTime:0.003227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57819013 ORDER BY `minOrder` ASC [ RunTime:0.003605s ]
select * from pdf where partno='6078889' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6078889' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008477s ]
SELECT `id` FROM `stock` WHERE `id` <> 57819013 AND `partno` = '6078889' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18776988 [ RunTime:0.002614s ]
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 '60788%' OR `brand` LIKE '60788%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002127s ]
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 '60788%' OR `brand` LIKE '60788%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003762s ]
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 '60788%' OR `brand` LIKE '60788%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003615s ]
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 '60788%' OR `brand` LIKE '60788%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006069s ]
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 '60788%' OR `brand` LIKE '60788%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001384s ]
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 '60788%' OR `brand` LIKE '60788%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005120s ]
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 '60788%' OR `brand` LIKE '60788%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003807s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60788%' OR `brand` LIKE '60788%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004305s ]