SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002585s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.72' , `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=60340&search=1' [ RunTime:0.002910s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002350s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000593s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002561s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.72' ) [ RunTime:0.002858s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002828s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000427s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003907s ]
SELECT * FROM `stock_search` WHERE `partno` = '60340' LIMIT 1 [ RunTime:0.001292s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-08 03:47:43' WHERE `partno` = '60340' [ RunTime:0.003272s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.007939s ]
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 '60340%' OR `brand` LIKE '60340%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023277s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526983 LIMIT 5 [ RunTime:0.015352s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526983 ORDER BY `minOrder` ASC [ RunTime:0.001504s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526983 ORDER BY `unit` DESC [ RunTime:0.010259s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526983 LIMIT 2 [ RunTime:0.003450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526983 ORDER BY `minOrder` ASC [ RunTime:0.008055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526382 LIMIT 5 [ RunTime:0.003396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526382 ORDER BY `minOrder` ASC [ RunTime:0.002314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526382 ORDER BY `unit` DESC [ RunTime:0.004320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526382 LIMIT 2 [ RunTime:0.004451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526382 ORDER BY `minOrder` ASC [ RunTime:0.002730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526381 LIMIT 5 [ RunTime:0.002540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526381 ORDER BY `minOrder` ASC [ RunTime:0.004350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526381 ORDER BY `unit` DESC [ RunTime:0.000506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526381 LIMIT 2 [ RunTime:0.000432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526381 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18646015 LIMIT 5 [ RunTime:0.012648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18646015 ORDER BY `minOrder` ASC [ RunTime:0.001912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18646015 ORDER BY `unit` DESC [ RunTime:0.020204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18646015 LIMIT 2 [ RunTime:0.047208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18646015 ORDER BY `minOrder` ASC [ RunTime:0.004375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287257 LIMIT 5 [ RunTime:0.042598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287257 ORDER BY `minOrder` ASC [ RunTime:0.014714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17287257 ORDER BY `unit` DESC [ RunTime:0.012961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17287257 LIMIT 2 [ RunTime:0.034003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287257 ORDER BY `minOrder` ASC [ RunTime:0.022977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287245 LIMIT 5 [ RunTime:0.015585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287245 ORDER BY `minOrder` ASC [ RunTime:0.035120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17287245 ORDER BY `unit` DESC [ RunTime:0.020565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17287245 LIMIT 2 [ RunTime:0.021208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287245 ORDER BY `minOrder` ASC [ RunTime:0.021172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287244 LIMIT 5 [ RunTime:0.011525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287244 ORDER BY `minOrder` ASC [ RunTime:0.016570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17287244 ORDER BY `unit` DESC [ RunTime:0.010948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17287244 LIMIT 2 [ RunTime:0.019385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287244 ORDER BY `minOrder` ASC [ RunTime:0.038728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430647 LIMIT 5 [ RunTime:0.015286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430647 ORDER BY `minOrder` ASC [ RunTime:0.022040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430647 ORDER BY `unit` DESC [ RunTime:0.048318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430647 LIMIT 2 [ RunTime:0.121698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430647 ORDER BY `minOrder` ASC [ RunTime:0.018259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430646 LIMIT 5 [ RunTime:0.012229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430646 ORDER BY `minOrder` ASC [ RunTime:0.029007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430646 ORDER BY `unit` DESC [ RunTime:0.024644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430646 LIMIT 2 [ RunTime:0.034527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430646 ORDER BY `minOrder` ASC [ RunTime:0.021727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13289629 LIMIT 5 [ RunTime:0.040978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289629 ORDER BY `minOrder` ASC [ RunTime:0.062857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13289629 ORDER BY `unit` DESC [ RunTime:0.029959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13289629 LIMIT 2 [ RunTime:0.023364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13289629 ORDER BY `minOrder` ASC [ RunTime:0.031946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286632 LIMIT 5 [ RunTime:0.016290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286632 ORDER BY `minOrder` ASC [ RunTime:0.018260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13286632 ORDER BY `unit` DESC [ RunTime:0.031769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13286632 LIMIT 2 [ RunTime:0.019312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286632 ORDER BY `minOrder` ASC [ RunTime:0.031765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286629 LIMIT 5 [ RunTime:0.023827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286629 ORDER BY `minOrder` ASC [ RunTime:0.020743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13286629 ORDER BY `unit` DESC [ RunTime:0.013568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13286629 LIMIT 2 [ RunTime:0.022445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286629 ORDER BY `minOrder` ASC [ RunTime:0.012910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286400 LIMIT 5 [ RunTime:0.012858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286400 ORDER BY `minOrder` ASC [ RunTime:0.033198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13286400 ORDER BY `unit` DESC [ RunTime:0.026393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13286400 LIMIT 2 [ RunTime:0.021280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286400 ORDER BY `minOrder` ASC [ RunTime:0.008968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286293 LIMIT 5 [ RunTime:0.011618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286293 ORDER BY `minOrder` ASC [ RunTime:0.018998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13286293 ORDER BY `unit` DESC [ RunTime:0.018539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13286293 LIMIT 2 [ RunTime:0.026321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13286293 ORDER BY `minOrder` ASC [ RunTime:0.015368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13285991 LIMIT 5 [ RunTime:0.036286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13285991 ORDER BY `minOrder` ASC [ RunTime:0.038668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13285991 ORDER BY `unit` DESC [ RunTime:0.049983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13285991 LIMIT 2 [ RunTime:0.033545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13285991 ORDER BY `minOrder` ASC [ RunTime:0.003470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12180806 LIMIT 5 [ RunTime:0.023284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12180806 ORDER BY `minOrder` ASC [ RunTime:0.023642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12180806 ORDER BY `unit` DESC [ RunTime:0.021915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12180806 LIMIT 2 [ RunTime:0.018885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12180806 ORDER BY `minOrder` ASC [ RunTime:0.004231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12017655 LIMIT 5 [ RunTime:0.020485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12017655 ORDER BY `minOrder` ASC [ RunTime:0.009080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12017655 ORDER BY `unit` DESC [ RunTime:0.007244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12017655 LIMIT 2 [ RunTime:0.002876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12017655 ORDER BY `minOrder` ASC [ RunTime:0.003144s ]
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 '60340%' OR `brand` LIKE '60340%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003197s ]
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 '60340%' OR `brand` LIKE '60340%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64612845 LIMIT 5 [ RunTime:0.010338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64612845 ORDER BY `minOrder` ASC [ RunTime:0.009075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64612845 ORDER BY `unit` DESC [ RunTime:0.017040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64612845 LIMIT 2 [ RunTime:0.010144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64612845 ORDER BY `minOrder` ASC [ RunTime:0.007143s ]
select * from pdf where partno='6034024' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003708s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034024' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.028400s ]
SELECT `id` FROM `stock` WHERE `id` <> 64612845 AND `partno` = '6034024' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526983 [ RunTime:0.028697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64615361 LIMIT 5 [ RunTime:0.005080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615361 ORDER BY `minOrder` ASC [ RunTime:0.030516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64615361 ORDER BY `unit` DESC [ RunTime:0.051446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64615361 LIMIT 2 [ RunTime:0.012604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615361 ORDER BY `minOrder` ASC [ RunTime:0.018540s ]
select * from pdf where partno='6034029' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.037236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034029' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005277s ]
SELECT `id` FROM `stock` WHERE `id` <> 64615361 AND `partno` = '6034029' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526382 [ RunTime:0.030285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64615360 LIMIT 5 [ RunTime:0.035383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615360 ORDER BY `minOrder` ASC [ RunTime:0.041721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64615360 ORDER BY `unit` DESC [ RunTime:0.029442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64615360 LIMIT 2 [ RunTime:0.008114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615360 ORDER BY `minOrder` ASC [ RunTime:0.013084s ]
select * from pdf where partno='6034028' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.024364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034028' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015374s ]
SELECT `id` FROM `stock` WHERE `id` <> 64615360 AND `partno` = '6034028' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.041862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526381 [ RunTime:0.033710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64615359 LIMIT 5 [ RunTime:0.030276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615359 ORDER BY `minOrder` ASC [ RunTime:0.051225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64615359 ORDER BY `unit` DESC [ RunTime:0.017903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64615359 LIMIT 2 [ RunTime:0.016394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615359 ORDER BY `minOrder` ASC [ RunTime:0.009862s ]
select * from pdf where partno='6034025' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034025' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017040s ]
SELECT `id` FROM `stock` WHERE `id` <> 64615359 AND `partno` = '6034025' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.028138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287257 [ RunTime:0.033026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64615235 LIMIT 5 [ RunTime:0.010968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615235 ORDER BY `minOrder` ASC [ RunTime:0.003709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64615235 ORDER BY `unit` DESC [ RunTime:0.002418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64615235 LIMIT 2 [ RunTime:0.037297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615235 ORDER BY `minOrder` ASC [ RunTime:0.008645s ]
select * from pdf where partno='6034031' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034031' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018044s ]
SELECT `id` FROM `stock` WHERE `id` <> 64615235 AND `partno` = '6034031' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.032885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430647 [ RunTime:0.033977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64615234 LIMIT 5 [ RunTime:0.029752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615234 ORDER BY `minOrder` ASC [ RunTime:0.007592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64615234 ORDER BY `unit` DESC [ RunTime:0.007024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64615234 LIMIT 2 [ RunTime:0.014966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615234 ORDER BY `minOrder` ASC [ RunTime:0.017138s ]
select * from pdf where partno='6034030' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034030' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022927s ]
SELECT `id` FROM `stock` WHERE `id` <> 64615234 AND `partno` = '6034030' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430646 [ RunTime:0.007936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64615233 LIMIT 5 [ RunTime:0.012084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615233 ORDER BY `minOrder` ASC [ RunTime:0.002289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64615233 ORDER BY `unit` DESC [ RunTime:0.025342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64615233 LIMIT 2 [ RunTime:0.023175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615233 ORDER BY `minOrder` ASC [ RunTime:0.005224s ]
select * from pdf where partno='6034027' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034027' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011766s ]
SELECT `id` FROM `stock` WHERE `id` <> 64615233 AND `partno` = '6034027' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287245 [ RunTime:0.031129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64615232 LIMIT 5 [ RunTime:0.006875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615232 ORDER BY `minOrder` ASC [ RunTime:0.011747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64615232 ORDER BY `unit` DESC [ RunTime:0.005478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64615232 LIMIT 2 [ RunTime:0.002217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64615232 ORDER BY `minOrder` ASC [ RunTime:0.004559s ]
select * from pdf where partno='6034026' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.019811s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034026' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.033630s ]
SELECT `id` FROM `stock` WHERE `id` <> 64615232 AND `partno` = '6034026' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.041463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287244 [ RunTime:0.019845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43901293 LIMIT 5 [ RunTime:0.008743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43901293 ORDER BY `minOrder` ASC [ RunTime:0.016058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43901293 ORDER BY `unit` DESC [ RunTime:0.017758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43901293 LIMIT 2 [ RunTime:0.009929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43901293 ORDER BY `minOrder` ASC [ RunTime:0.002615s ]
select * from pdf where partno='603402F00000G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.010604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '603402F00000G' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.019202s ]
SELECT `id` FROM `stock` WHERE `id` <> 43901293 AND `partno` = '603402F00000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.013486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18646015 [ RunTime:0.014611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32573069 LIMIT 5 [ RunTime:0.021964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32573069 ORDER BY `minOrder` ASC [ RunTime:0.027588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32573069 ORDER BY `unit` DESC [ RunTime:0.007362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32573069 LIMIT 2 [ RunTime:0.003823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32573069 ORDER BY `minOrder` ASC [ RunTime:0.003418s ]
select * from pdf where partno='6034034' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034034' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003486s ]
SELECT `id` FROM `stock` WHERE `id` <> 32573069 AND `partno` = '6034034' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13289629 [ RunTime:0.029540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32421085 LIMIT 5 [ RunTime:0.052624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421085 ORDER BY `minOrder` ASC [ RunTime:0.003443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32421085 ORDER BY `unit` DESC [ RunTime:0.025695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32421085 LIMIT 2 [ RunTime:0.006096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421085 ORDER BY `minOrder` ASC [ RunTime:0.029550s ]
select * from pdf where partno='6034003' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034003' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013195s ]
SELECT `id` FROM `stock` WHERE `id` <> 32421085 AND `partno` = '6034003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286632 [ RunTime:0.007495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32421084 LIMIT 5 [ RunTime:0.027851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421084 ORDER BY `minOrder` ASC [ RunTime:0.006692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32421084 ORDER BY `unit` DESC [ RunTime:0.009891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32421084 LIMIT 2 [ RunTime:0.010420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421084 ORDER BY `minOrder` ASC [ RunTime:0.006160s ]
select * from pdf where partno='6034004' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034004' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001035s ]
SELECT `id` FROM `stock` WHERE `id` <> 32421084 AND `partno` = '6034004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32421077 LIMIT 5 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421077 ORDER BY `minOrder` ASC [ RunTime:0.007391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32421077 ORDER BY `unit` DESC [ RunTime:0.002529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32421077 LIMIT 2 [ RunTime:0.002520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421077 ORDER BY `minOrder` ASC [ RunTime:0.003528s ]
select * from pdf where partno='6034015' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034015' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019249s ]
SELECT `id` FROM `stock` WHERE `id` <> 32421077 AND `partno` = '6034015' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.026772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286629 [ RunTime:0.009209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32421062 LIMIT 5 [ RunTime:0.010889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421062 ORDER BY `minOrder` ASC [ RunTime:0.005416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32421062 ORDER BY `unit` DESC [ RunTime:0.000803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32421062 LIMIT 2 [ RunTime:0.007009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421062 ORDER BY `minOrder` ASC [ RunTime:0.007780s ]
select * from pdf where partno='6034006' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.033090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034006' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019417s ]
SELECT `id` FROM `stock` WHERE `id` <> 32421062 AND `partno` = '6034006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12017655 [ RunTime:0.006585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32405732 LIMIT 5 [ RunTime:0.017921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32405732 ORDER BY `minOrder` ASC [ RunTime:0.003072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32405732 ORDER BY `unit` DESC [ RunTime:0.003339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32405732 LIMIT 2 [ RunTime:0.001915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32405732 ORDER BY `minOrder` ASC [ RunTime:0.010369s ]
select * from pdf where partno='6034062' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034062' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025291s ]
SELECT `id` FROM `stock` WHERE `id` <> 32405732 AND `partno` = '6034062' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.027533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286400 [ RunTime:0.012081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32401317 LIMIT 5 [ RunTime:0.008551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32401317 ORDER BY `minOrder` ASC [ RunTime:0.026600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32401317 ORDER BY `unit` DESC [ RunTime:0.024764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32401317 LIMIT 2 [ RunTime:0.023960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32401317 ORDER BY `minOrder` ASC [ RunTime:0.019085s ]
select * from pdf where partno='6034016' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034016' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015564s ]
SELECT `id` FROM `stock` WHERE `id` <> 32401317 AND `partno` = '6034016' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32400897 LIMIT 5 [ RunTime:0.018711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32400897 ORDER BY `minOrder` ASC [ RunTime:0.023746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32400897 ORDER BY `unit` DESC [ RunTime:0.014963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32400897 LIMIT 2 [ RunTime:0.021448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32400897 ORDER BY `minOrder` ASC [ RunTime:0.010850s ]
select * from pdf where partno='6034005' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034005' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027493s ]
SELECT `id` FROM `stock` WHERE `id` <> 32400897 AND `partno` = '6034005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.025507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13286293 [ RunTime:0.051478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32389421 LIMIT 5 [ RunTime:0.021950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32389421 ORDER BY `minOrder` ASC [ RunTime:0.038670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32389421 ORDER BY `unit` DESC [ RunTime:0.030997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32389421 LIMIT 2 [ RunTime:0.032056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32389421 ORDER BY `minOrder` ASC [ RunTime:0.015848s ]
select * from pdf where partno='6034001' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.040831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034001' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.037306s ]
SELECT `id` FROM `stock` WHERE `id` <> 32389421 AND `partno` = '6034001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.050731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13285991 [ RunTime:0.073932s ]
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 '60340%' OR `brand` LIKE '60340%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048062s ]
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 '60340%' OR `brand` LIKE '60340%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068746s ]
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 '60340%' OR `brand` LIKE '60340%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026681s ]
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 '60340%' OR `brand` LIKE '60340%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029099s ]
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 '60340%' OR `brand` LIKE '60340%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032344s ]
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 '60340%' OR `brand` LIKE '60340%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021691s ]
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 '60340%' OR `brand` LIKE '60340%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041605s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60340%' OR `brand` LIKE '60340%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.087157s ]