SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002336s ]
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=60378&search=1' [ RunTime:0.001876s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002234s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000583s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002731s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.72' ) [ RunTime:0.000898s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002269s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000348s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003224s ]
SELECT * FROM `stock_search` WHERE `partno` = '60378' LIMIT 1 [ RunTime:0.004148s ]
UPDATE `stock_search` SET `count` = 7 , `updatetime` = '2026-08-08 03:47:43' WHERE `partno` = '60378' [ RunTime:0.010815s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002346s ]
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 '60378%' OR `brand` LIKE '60378%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013874s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528722 LIMIT 5 [ RunTime:0.030077s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528722 ORDER BY `minOrder` ASC [ RunTime:0.004262s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528722 ORDER BY `unit` DESC [ RunTime:0.018055s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528722 LIMIT 2 [ RunTime:0.008832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528722 ORDER BY `minOrder` ASC [ RunTime:0.002884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528721 LIMIT 5 [ RunTime:0.006689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528721 ORDER BY `minOrder` ASC [ RunTime:0.007771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528721 ORDER BY `unit` DESC [ RunTime:0.002765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528721 LIMIT 2 [ RunTime:0.004038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528721 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528720 LIMIT 5 [ RunTime:0.000822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528720 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528720 ORDER BY `unit` DESC [ RunTime:0.010371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528720 LIMIT 2 [ RunTime:0.048342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528720 ORDER BY `minOrder` ASC [ RunTime:0.022601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17288062 LIMIT 5 [ RunTime:0.004874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17288062 ORDER BY `minOrder` ASC [ RunTime:0.032378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17288062 ORDER BY `unit` DESC [ RunTime:0.008364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17288062 LIMIT 2 [ RunTime:0.009839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17288062 ORDER BY `minOrder` ASC [ RunTime:0.018434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15431419 LIMIT 5 [ RunTime:0.022094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15431419 ORDER BY `minOrder` ASC [ RunTime:0.038593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15431419 ORDER BY `unit` DESC [ RunTime:0.012671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15431419 LIMIT 2 [ RunTime:0.025383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15431419 ORDER BY `minOrder` ASC [ RunTime:0.008454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528760 LIMIT 5 [ RunTime:0.012542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528760 ORDER BY `minOrder` ASC [ RunTime:0.017978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528760 ORDER BY `unit` DESC [ RunTime:0.044996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528760 LIMIT 2 [ RunTime:0.028056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528760 ORDER BY `minOrder` ASC [ RunTime:0.006561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528759 LIMIT 5 [ RunTime:0.029879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528759 ORDER BY `minOrder` ASC [ RunTime:0.029003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528759 ORDER BY `unit` DESC [ RunTime:0.032877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528759 LIMIT 2 [ RunTime:0.027958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528759 ORDER BY `minOrder` ASC [ RunTime:0.029952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528758 LIMIT 5 [ RunTime:0.116525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528758 ORDER BY `minOrder` ASC [ RunTime:0.017707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528758 ORDER BY `unit` DESC [ RunTime:0.027749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528758 LIMIT 2 [ RunTime:0.018302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528758 ORDER BY `minOrder` ASC [ RunTime:0.040733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528451 LIMIT 5 [ RunTime:0.036273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528451 ORDER BY `minOrder` ASC [ RunTime:0.022383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528451 ORDER BY `unit` DESC [ RunTime:0.052463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528451 LIMIT 2 [ RunTime:0.018580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528451 ORDER BY `minOrder` ASC [ RunTime:0.023277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528450 LIMIT 5 [ RunTime:0.054352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528450 ORDER BY `minOrder` ASC [ RunTime:0.024346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528450 ORDER BY `unit` DESC [ RunTime:0.026567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528450 LIMIT 2 [ RunTime:0.019610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528450 ORDER BY `minOrder` ASC [ RunTime:0.016435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528446 LIMIT 5 [ RunTime:0.035718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528446 ORDER BY `minOrder` ASC [ RunTime:0.018194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528446 ORDER BY `unit` DESC [ RunTime:0.025504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528446 LIMIT 2 [ RunTime:0.014809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528446 ORDER BY `minOrder` ASC [ RunTime:0.010906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528443 LIMIT 5 [ RunTime:0.018003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528443 ORDER BY `minOrder` ASC [ RunTime:0.006104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528443 ORDER BY `unit` DESC [ RunTime:0.020243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528443 LIMIT 2 [ RunTime:0.017096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528443 ORDER BY `minOrder` ASC [ RunTime:0.032000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528442 LIMIT 5 [ RunTime:0.028020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528442 ORDER BY `minOrder` ASC [ RunTime:0.015157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528442 ORDER BY `unit` DESC [ RunTime:0.009744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528442 LIMIT 2 [ RunTime:0.014515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528442 ORDER BY `minOrder` ASC [ RunTime:0.012596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528441 LIMIT 5 [ RunTime:0.022501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528441 ORDER BY `minOrder` ASC [ RunTime:0.032656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528441 ORDER BY `unit` DESC [ RunTime:0.051662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528441 LIMIT 2 [ RunTime:0.040169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528441 ORDER BY `minOrder` ASC [ RunTime:0.011628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528440 LIMIT 5 [ RunTime:0.020426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528440 ORDER BY `minOrder` ASC [ RunTime:0.034007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528440 ORDER BY `unit` DESC [ RunTime:0.035337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528440 LIMIT 2 [ RunTime:0.042712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528440 ORDER BY `minOrder` ASC [ RunTime:0.007463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528432 LIMIT 5 [ RunTime:0.008370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528432 ORDER BY `minOrder` ASC [ RunTime:0.027320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19528432 ORDER BY `unit` DESC [ RunTime:0.004463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19528432 LIMIT 2 [ RunTime:0.010913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19528432 ORDER BY `minOrder` ASC [ RunTime:0.003663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778765 LIMIT 5 [ RunTime:0.005692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778765 ORDER BY `minOrder` ASC [ RunTime:0.008012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18778765 ORDER BY `unit` DESC [ RunTime:0.012621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18778765 LIMIT 2 [ RunTime:0.010314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778765 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287970 LIMIT 5 [ RunTime:0.011585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287970 ORDER BY `minOrder` ASC [ RunTime:0.012692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17287970 ORDER BY `unit` DESC [ RunTime:0.007231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17287970 LIMIT 2 [ RunTime:0.002250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287970 ORDER BY `minOrder` ASC [ RunTime:0.006553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287969 LIMIT 5 [ RunTime:0.003304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287969 ORDER BY `minOrder` ASC [ RunTime:0.004457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17287969 ORDER BY `unit` DESC [ RunTime:0.018531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17287969 LIMIT 2 [ RunTime:0.027023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287969 ORDER BY `minOrder` ASC [ RunTime:0.016733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287965 LIMIT 5 [ RunTime:0.016330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287965 ORDER BY `minOrder` ASC [ RunTime:0.036450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17287965 ORDER BY `unit` DESC [ RunTime:0.040083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17287965 LIMIT 2 [ RunTime:0.034388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287965 ORDER BY `minOrder` ASC [ RunTime:0.028187s ]
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 '60378%' OR `brand` LIKE '60378%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023187s ]
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 '60378%' OR `brand` LIKE '60378%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63302303 LIMIT 5 [ RunTime:0.009205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302303 ORDER BY `minOrder` ASC [ RunTime:0.040653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63302303 ORDER BY `unit` DESC [ RunTime:0.032237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63302303 LIMIT 2 [ RunTime:0.031000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302303 ORDER BY `minOrder` ASC [ RunTime:0.007041s ]
select * from pdf where partno='6037836' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015936s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037836' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.026417s ]
SELECT `id` FROM `stock` WHERE `id` <> 63302303 AND `partno` = '6037836' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.058614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17288062 [ RunTime:0.038071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63302302 LIMIT 5 [ RunTime:0.034519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302302 ORDER BY `minOrder` ASC [ RunTime:0.045578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63302302 ORDER BY `unit` DESC [ RunTime:0.011160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63302302 LIMIT 2 [ RunTime:0.019733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302302 ORDER BY `minOrder` ASC [ RunTime:0.014922s ]
select * from pdf where partno='6037824' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037824' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012083s ]
SELECT `id` FROM `stock` WHERE `id` <> 63302302 AND `partno` = '6037824' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.026379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528721 [ RunTime:0.039092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63302301 LIMIT 5 [ RunTime:0.004148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302301 ORDER BY `minOrder` ASC [ RunTime:0.002614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63302301 ORDER BY `unit` DESC [ RunTime:0.044300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63302301 LIMIT 2 [ RunTime:0.001814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302301 ORDER BY `minOrder` ASC [ RunTime:0.009358s ]
select * from pdf where partno='6037819' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037819' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025318s ]
SELECT `id` FROM `stock` WHERE `id` <> 63302301 AND `partno` = '6037819' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.026471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528720 [ RunTime:0.026984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63302409 LIMIT 5 [ RunTime:0.017863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302409 ORDER BY `minOrder` ASC [ RunTime:0.007737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63302409 ORDER BY `unit` DESC [ RunTime:0.019583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63302409 LIMIT 2 [ RunTime:0.019120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302409 ORDER BY `minOrder` ASC [ RunTime:0.009876s ]
select * from pdf where partno='6037832' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037832' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014397s ]
SELECT `id` FROM `stock` WHERE `id` <> 63302409 AND `partno` = '6037832' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15431419 [ RunTime:0.011814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63302405 LIMIT 5 [ RunTime:0.008579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302405 ORDER BY `minOrder` ASC [ RunTime:0.002067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63302405 ORDER BY `unit` DESC [ RunTime:0.035635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63302405 LIMIT 2 [ RunTime:0.012922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302405 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
select * from pdf where partno='6037829' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037829' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011654s ]
SELECT `id` FROM `stock` WHERE `id` <> 63302405 AND `partno` = '6037829' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528760 [ RunTime:0.018056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63302404 LIMIT 5 [ RunTime:0.037878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302404 ORDER BY `minOrder` ASC [ RunTime:0.007547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63302404 ORDER BY `unit` DESC [ RunTime:0.006374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63302404 LIMIT 2 [ RunTime:0.005589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302404 ORDER BY `minOrder` ASC [ RunTime:0.003079s ]
select * from pdf where partno='6037825' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037825' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027897s ]
SELECT `id` FROM `stock` WHERE `id` <> 63302404 AND `partno` = '6037825' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.046062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528759 [ RunTime:0.024813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63302403 LIMIT 5 [ RunTime:0.017444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302403 ORDER BY `minOrder` ASC [ RunTime:0.011852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63302403 ORDER BY `unit` DESC [ RunTime:0.018317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63302403 LIMIT 2 [ RunTime:0.011636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63302403 ORDER BY `minOrder` ASC [ RunTime:0.006534s ]
select * from pdf where partno='6037820' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037820' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006919s ]
SELECT `id` FROM `stock` WHERE `id` <> 63302403 AND `partno` = '6037820' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528758 [ RunTime:0.010373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64511738 LIMIT 5 [ RunTime:0.006678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64511738 ORDER BY `minOrder` ASC [ RunTime:0.014738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64511738 ORDER BY `unit` DESC [ RunTime:0.040106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64511738 LIMIT 2 [ RunTime:0.005990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64511738 ORDER BY `minOrder` ASC [ RunTime:0.003946s ]
select * from pdf where partno='60378' and brandshort='Brady Corporation' limit 1 [ RunTime:0.005581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60378' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005766s ]
SELECT `id` FROM `stock` WHERE `id` <> 64511738 AND `partno` = '60378' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.013970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523048 [ RunTime:0.003095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63343333 LIMIT 5 [ RunTime:0.014439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63343333 ORDER BY `minOrder` ASC [ RunTime:0.011607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63343333 ORDER BY `unit` DESC [ RunTime:0.028364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63343333 LIMIT 2 [ RunTime:0.033269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63343333 ORDER BY `minOrder` ASC [ RunTime:0.008502s ]
select * from pdf where partno='6037823' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037823' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017681s ]
SELECT `id` FROM `stock` WHERE `id` <> 63343333 AND `partno` = '6037823' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778765 [ RunTime:0.028502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63303049 LIMIT 5 [ RunTime:0.031298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303049 ORDER BY `minOrder` ASC [ RunTime:0.010760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63303049 ORDER BY `unit` DESC [ RunTime:0.005054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63303049 LIMIT 2 [ RunTime:0.009591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303049 ORDER BY `minOrder` ASC [ RunTime:0.002006s ]
select * from pdf where partno='6037839' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037839' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012061s ]
SELECT `id` FROM `stock` WHERE `id` <> 63303049 AND `partno` = '6037839' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528451 [ RunTime:0.016336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63303048 LIMIT 5 [ RunTime:0.009862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303048 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63303048 ORDER BY `unit` DESC [ RunTime:0.001466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63303048 LIMIT 2 [ RunTime:0.007001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303048 ORDER BY `minOrder` ASC [ RunTime:0.000655s ]
select * from pdf where partno='6037838' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037838' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004755s ]
SELECT `id` FROM `stock` WHERE `id` <> 63303048 AND `partno` = '6037838' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528450 [ RunTime:0.001807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63303047 LIMIT 5 [ RunTime:0.018522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303047 ORDER BY `minOrder` ASC [ RunTime:0.026404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63303047 ORDER BY `unit` DESC [ RunTime:0.014511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63303047 LIMIT 2 [ RunTime:0.012529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303047 ORDER BY `minOrder` ASC [ RunTime:0.012137s ]
select * from pdf where partno='6037837' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037837' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006750s ]
SELECT `id` FROM `stock` WHERE `id` <> 63303047 AND `partno` = '6037837' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15431337 [ RunTime:0.029272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63303039 LIMIT 5 [ RunTime:0.018084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303039 ORDER BY `minOrder` ASC [ RunTime:0.012070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63303039 ORDER BY `unit` DESC [ RunTime:0.017917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63303039 LIMIT 2 [ RunTime:0.000791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303039 ORDER BY `minOrder` ASC [ RunTime:0.002689s ]
select * from pdf where partno='6037835' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037835' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014635s ]
SELECT `id` FROM `stock` WHERE `id` <> 63303039 AND `partno` = '6037835' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528446 [ RunTime:0.009154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63303038 LIMIT 5 [ RunTime:0.025384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303038 ORDER BY `minOrder` ASC [ RunTime:0.019971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63303038 ORDER BY `unit` DESC [ RunTime:0.011611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63303038 LIMIT 2 [ RunTime:0.012457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303038 ORDER BY `minOrder` ASC [ RunTime:0.013620s ]
select * from pdf where partno='6037834' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.019580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037834' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019317s ]
SELECT `id` FROM `stock` WHERE `id` <> 63303038 AND `partno` = '6037834' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.023971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287970 [ RunTime:0.020249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63303037 LIMIT 5 [ RunTime:0.013859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303037 ORDER BY `minOrder` ASC [ RunTime:0.012572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63303037 ORDER BY `unit` DESC [ RunTime:0.027782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63303037 LIMIT 2 [ RunTime:0.010772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303037 ORDER BY `minOrder` ASC [ RunTime:0.000822s ]
select * from pdf where partno='6037833' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037833' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.028973s ]
SELECT `id` FROM `stock` WHERE `id` <> 63303037 AND `partno` = '6037833' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.036991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287969 [ RunTime:0.019701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63303032 LIMIT 5 [ RunTime:0.049961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303032 ORDER BY `minOrder` ASC [ RunTime:0.019296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63303032 ORDER BY `unit` DESC [ RunTime:0.038504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63303032 LIMIT 2 [ RunTime:0.009128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303032 ORDER BY `minOrder` ASC [ RunTime:0.011609s ]
select * from pdf where partno='6037831' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.079152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037831' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.035743s ]
SELECT `id` FROM `stock` WHERE `id` <> 63303032 AND `partno` = '6037831' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.081689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528443 [ RunTime:0.045062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63303031 LIMIT 5 [ RunTime:0.052367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303031 ORDER BY `minOrder` ASC [ RunTime:0.074127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63303031 ORDER BY `unit` DESC [ RunTime:0.057117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63303031 LIMIT 2 [ RunTime:0.034176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303031 ORDER BY `minOrder` ASC [ RunTime:0.006414s ]
select * from pdf where partno='6037830' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.036771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037830' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.039841s ]
SELECT `id` FROM `stock` WHERE `id` <> 63303031 AND `partno` = '6037830' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528442 [ RunTime:0.091997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63303030 LIMIT 5 [ RunTime:0.011011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303030 ORDER BY `minOrder` ASC [ RunTime:0.052604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63303030 ORDER BY `unit` DESC [ RunTime:0.036952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63303030 LIMIT 2 [ RunTime:0.045090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303030 ORDER BY `minOrder` ASC [ RunTime:0.019675s ]
select * from pdf where partno='6037827' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037827' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031058s ]
SELECT `id` FROM `stock` WHERE `id` <> 63303030 AND `partno` = '6037827' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.052633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528441 [ RunTime:0.031083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63303029 LIMIT 5 [ RunTime:0.035890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303029 ORDER BY `minOrder` ASC [ RunTime:0.017788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63303029 ORDER BY `unit` DESC [ RunTime:0.012972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63303029 LIMIT 2 [ RunTime:0.019758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303029 ORDER BY `minOrder` ASC [ RunTime:0.008896s ]
select * from pdf where partno='6037826' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037826' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015697s ]
SELECT `id` FROM `stock` WHERE `id` <> 63303029 AND `partno` = '6037826' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528440 [ RunTime:0.021605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63303022 LIMIT 5 [ RunTime:0.027961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303022 ORDER BY `minOrder` ASC [ RunTime:0.012322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63303022 ORDER BY `unit` DESC [ RunTime:0.009899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63303022 LIMIT 2 [ RunTime:0.012831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63303022 ORDER BY `minOrder` ASC [ RunTime:0.009160s ]
select * from pdf where partno='6037822' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.050650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6037822' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031550s ]
SELECT `id` FROM `stock` WHERE `id` <> 63303022 AND `partno` = '6037822' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19528432 [ RunTime:0.014684s ]
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 '60378%' OR `brand` LIKE '60378%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002455s ]
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 '60378%' OR `brand` LIKE '60378%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019028s ]
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 '60378%' OR `brand` LIKE '60378%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025701s ]
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 '60378%' OR `brand` LIKE '60378%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017047s ]
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 '60378%' OR `brand` LIKE '60378%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022353s ]
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 '60378%' OR `brand` LIKE '60378%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010700s ]
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 '60378%' OR `brand` LIKE '60378%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018503s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60378%' OR `brand` LIKE '60378%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.029168s ]