SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002223s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=8662&search=1' [ RunTime:0.002912s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002764s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000883s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002421s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000328s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001239s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004879s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001317s ]
SELECT * FROM `stock_search` WHERE `partno` = '8662' LIMIT 1 [ RunTime:0.001204s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-24 15:15:37' WHERE `partno` = '8662' [ RunTime:0.010475s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.006065s ]
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 '8662%' OR `brand` LIKE '8662%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009246s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18934065 LIMIT 5 [ RunTime:0.009245s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18934065 ORDER BY `minOrder` ASC [ RunTime:0.009765s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18934065 ORDER BY `unit` DESC [ RunTime:0.000746s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18934065 LIMIT 2 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18934065 ORDER BY `minOrder` ASC [ RunTime:0.000212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264994 LIMIT 5 [ RunTime:0.002318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264994 ORDER BY `minOrder` ASC [ RunTime:0.002625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264994 ORDER BY `unit` DESC [ RunTime:0.000301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264994 LIMIT 2 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264994 ORDER BY `minOrder` ASC [ RunTime:0.002189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427107 LIMIT 5 [ RunTime:0.001282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427107 ORDER BY `minOrder` ASC [ RunTime:0.001133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16427107 ORDER BY `unit` DESC [ RunTime:0.006271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16427107 LIMIT 2 [ RunTime:0.008907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427107 ORDER BY `minOrder` ASC [ RunTime:0.015101s ]
select * from pdf where partno='8662 00050' and brandshort='Belden Inc.' limit 1 [ RunTime:0.007045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16427133 LIMIT 5 [ RunTime:0.007109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427133 ORDER BY `minOrder` ASC [ RunTime:0.007318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16427133 ORDER BY `unit` DESC [ RunTime:0.000561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16427133 LIMIT 2 [ RunTime:0.006522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16427133 ORDER BY `minOrder` ASC [ RunTime:0.002349s ]
select * from pdf where partno='8662 000250' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265400 LIMIT 5 [ RunTime:0.020698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265400 ORDER BY `minOrder` ASC [ RunTime:0.011700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19265400 ORDER BY `unit` DESC [ RunTime:0.003223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19265400 LIMIT 2 [ RunTime:0.012319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265400 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264511 LIMIT 5 [ RunTime:0.005128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264511 ORDER BY `minOrder` ASC [ RunTime:0.022947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264511 ORDER BY `unit` DESC [ RunTime:0.023404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264511 LIMIT 2 [ RunTime:0.017992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264511 ORDER BY `minOrder` ASC [ RunTime:0.004596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15359547 LIMIT 5 [ RunTime:0.015334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15359547 ORDER BY `minOrder` ASC [ RunTime:0.007518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15359547 ORDER BY `unit` DESC [ RunTime:0.001405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15359547 LIMIT 2 [ RunTime:0.001338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15359547 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264837 LIMIT 5 [ RunTime:0.007197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264837 ORDER BY `minOrder` ASC [ RunTime:0.000745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264837 ORDER BY `unit` DESC [ RunTime:0.007635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264837 LIMIT 2 [ RunTime:0.008258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264837 ORDER BY `minOrder` ASC [ RunTime:0.004644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264832 LIMIT 5 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264832 ORDER BY `minOrder` ASC [ RunTime:0.003847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264832 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264832 LIMIT 2 [ RunTime:0.007627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264832 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264823 LIMIT 5 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264823 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264823 ORDER BY `unit` DESC [ RunTime:0.018344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264823 LIMIT 2 [ RunTime:0.002248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264823 ORDER BY `minOrder` ASC [ RunTime:0.006532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264783 LIMIT 5 [ RunTime:0.009541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264783 ORDER BY `minOrder` ASC [ RunTime:0.000755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264783 ORDER BY `unit` DESC [ RunTime:0.002029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264783 LIMIT 2 [ RunTime:0.000890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264783 ORDER BY `minOrder` ASC [ RunTime:0.002970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264658 LIMIT 5 [ RunTime:0.008004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264658 ORDER BY `minOrder` ASC [ RunTime:0.011449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264658 ORDER BY `unit` DESC [ RunTime:0.015595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264658 LIMIT 2 [ RunTime:0.002568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264658 ORDER BY `minOrder` ASC [ RunTime:0.014556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264619 LIMIT 5 [ RunTime:0.017767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264619 ORDER BY `minOrder` ASC [ RunTime:0.035244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264619 ORDER BY `unit` DESC [ RunTime:0.022974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264619 LIMIT 2 [ RunTime:0.009220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264619 ORDER BY `minOrder` ASC [ RunTime:0.002284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264607 LIMIT 5 [ RunTime:0.009605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264607 ORDER BY `minOrder` ASC [ RunTime:0.011990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264607 ORDER BY `unit` DESC [ RunTime:0.018371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264607 LIMIT 2 [ RunTime:0.043391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264607 ORDER BY `minOrder` ASC [ RunTime:0.016010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264517 LIMIT 5 [ RunTime:0.008166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264517 ORDER BY `minOrder` ASC [ RunTime:0.012028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264517 ORDER BY `unit` DESC [ RunTime:0.015295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264517 LIMIT 2 [ RunTime:0.003929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264517 ORDER BY `minOrder` ASC [ RunTime:0.010104s ]
select * from pdf where partno='86625213' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.007268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264423 LIMIT 5 [ RunTime:0.008565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264423 ORDER BY `minOrder` ASC [ RunTime:0.019629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264423 ORDER BY `unit` DESC [ RunTime:0.010182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264423 LIMIT 2 [ RunTime:0.026996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264423 ORDER BY `minOrder` ASC [ RunTime:0.012941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264383 LIMIT 5 [ RunTime:0.016570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264383 ORDER BY `minOrder` ASC [ RunTime:0.007669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264383 ORDER BY `unit` DESC [ RunTime:0.029629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264383 LIMIT 2 [ RunTime:0.020437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264383 ORDER BY `minOrder` ASC [ RunTime:0.012429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264382 LIMIT 5 [ RunTime:0.016596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264382 ORDER BY `minOrder` ASC [ RunTime:0.008909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264382 ORDER BY `unit` DESC [ RunTime:0.013785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264382 LIMIT 2 [ RunTime:0.002825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264382 ORDER BY `minOrder` ASC [ RunTime:0.001759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264279 LIMIT 5 [ RunTime:0.010376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264279 ORDER BY `minOrder` ASC [ RunTime:0.010595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264279 ORDER BY `unit` DESC [ RunTime:0.010619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264279 LIMIT 2 [ RunTime:0.000860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264279 ORDER BY `minOrder` ASC [ RunTime:0.004068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264278 LIMIT 5 [ RunTime:0.012895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264278 ORDER BY `minOrder` ASC [ RunTime:0.017495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264278 ORDER BY `unit` DESC [ RunTime:0.021521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264278 LIMIT 2 [ RunTime:0.010577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264278 ORDER BY `minOrder` ASC [ RunTime:0.018779s ]
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 '8662%' OR `brand` LIKE '8662%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015991s ]
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 '8662%' OR `brand` LIKE '8662%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58137848 LIMIT 5 [ RunTime:0.011526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58137848 ORDER BY `minOrder` ASC [ RunTime:0.014388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58137848 ORDER BY `unit` DESC [ RunTime:0.006160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58137848 LIMIT 2 [ RunTime:0.006702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58137848 ORDER BY `minOrder` ASC [ RunTime:0.004750s ]
select * from pdf where partno='8662' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.003812s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8662' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.001252s ]
SELECT `id` FROM `stock` WHERE `id` <> 58137848 AND `partno` = '8662' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18934065 [ RunTime:0.009112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56253977 LIMIT 5 [ RunTime:0.001611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56253977 ORDER BY `minOrder` ASC [ RunTime:0.003167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56253977 ORDER BY `unit` DESC [ RunTime:0.001373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56253977 LIMIT 2 [ RunTime:0.000753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56253977 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='866259-000' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '866259-000' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.006510s ]
SELECT `id` FROM `stock` WHERE `id` <> 56253977 AND `partno` = '866259-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.008247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64245657 LIMIT 5 [ RunTime:0.001919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64245657 ORDER BY `minOrder` ASC [ RunTime:0.002059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64245657 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64245657 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64245657 ORDER BY `minOrder` ASC [ RunTime:0.000669s ]
select * from pdf where partno='86621494' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.003197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86621494' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.003535s ]
SELECT `id` FROM `stock` WHERE `id` <> 64245657 AND `partno` = '86621494' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.002305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264994 [ RunTime:0.008160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50439050 LIMIT 5 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50439050 ORDER BY `minOrder` ASC [ RunTime:0.001124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50439050 ORDER BY `unit` DESC [ RunTime:0.004713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50439050 LIMIT 2 [ RunTime:0.002912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50439050 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='86625211' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.003005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86625211' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.000814s ]
SELECT `id` FROM `stock` WHERE `id` <> 50439050 AND `partno` = '86625211' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.003524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264511 [ RunTime:0.004713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37636397 LIMIT 5 [ RunTime:0.002402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37636397 ORDER BY `minOrder` ASC [ RunTime:0.001387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37636397 ORDER BY `unit` DESC [ RunTime:0.002656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37636397 LIMIT 2 [ RunTime:0.011529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37636397 ORDER BY `minOrder` ASC [ RunTime:0.001180s ]
select * from pdf where partno='86625211' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.000517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86625211' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.000403s ]
SELECT `id` FROM `stock` WHERE `id` <> 37636397 AND `partno` = '86625211' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.002686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264511 [ RunTime:0.007865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64580078 LIMIT 5 [ RunTime:0.026591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64580078 ORDER BY `minOrder` ASC [ RunTime:0.026083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64580078 ORDER BY `unit` DESC [ RunTime:0.004917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64580078 LIMIT 2 [ RunTime:0.009903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64580078 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
select * from pdf where partno='86621262' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.008779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86621262' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.009824s ]
SELECT `id` FROM `stock` WHERE `id` <> 64580078 AND `partno` = '86621262' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.008936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18866534 [ RunTime:0.006026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520847 LIMIT 5 [ RunTime:0.000565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520847 ORDER BY `minOrder` ASC [ RunTime:0.001318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520847 ORDER BY `unit` DESC [ RunTime:0.008103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520847 LIMIT 2 [ RunTime:0.001593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520847 ORDER BY `minOrder` ASC [ RunTime:0.001940s ]
select * from pdf where partno='86625' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86625' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.012864s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520847 AND `partno` = '86625' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344857 [ RunTime:0.001249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520846 LIMIT 5 [ RunTime:0.001806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520846 ORDER BY `minOrder` ASC [ RunTime:0.007201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520846 ORDER BY `unit` DESC [ RunTime:0.005540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520846 LIMIT 2 [ RunTime:0.005105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520846 ORDER BY `minOrder` ASC [ RunTime:0.003075s ]
select * from pdf where partno='86627' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86627' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000686s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520846 AND `partno` = '86627' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.007386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457948 [ RunTime:0.007140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520845 LIMIT 5 [ RunTime:0.005807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520845 ORDER BY `minOrder` ASC [ RunTime:0.001370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520845 ORDER BY `unit` DESC [ RunTime:0.000504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520845 LIMIT 2 [ RunTime:0.001555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520845 ORDER BY `minOrder` ASC [ RunTime:0.003015s ]
select * from pdf where partno='86623' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86623' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008169s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520845 AND `partno` = '86623' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344856 [ RunTime:0.001483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520843 LIMIT 5 [ RunTime:0.011966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520843 ORDER BY `minOrder` ASC [ RunTime:0.005561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520843 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520843 LIMIT 2 [ RunTime:0.007961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520843 ORDER BY `minOrder` ASC [ RunTime:0.002896s ]
select * from pdf where partno='86628' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86628' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.011973s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520843 AND `partno` = '86628' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457946 [ RunTime:0.002172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520842 LIMIT 5 [ RunTime:0.001540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520842 ORDER BY `minOrder` ASC [ RunTime:0.028363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520842 ORDER BY `unit` DESC [ RunTime:0.036535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520842 LIMIT 2 [ RunTime:0.006048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520842 ORDER BY `minOrder` ASC [ RunTime:0.005696s ]
select * from pdf where partno='86624' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86624' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003917s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520842 AND `partno` = '86624' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.037424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344855 [ RunTime:0.036419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520841 LIMIT 5 [ RunTime:0.005980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520841 ORDER BY `minOrder` ASC [ RunTime:0.036575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520841 ORDER BY `unit` DESC [ RunTime:0.018515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520841 LIMIT 2 [ RunTime:0.016761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520841 ORDER BY `minOrder` ASC [ RunTime:0.012075s ]
select * from pdf where partno='86629' and brandshort='Brady Corporation' limit 1 [ RunTime:0.010996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86629' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010133s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520841 AND `partno` = '86629' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344854 [ RunTime:0.009100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520840 LIMIT 5 [ RunTime:0.038082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520840 ORDER BY `minOrder` ASC [ RunTime:0.044573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520840 ORDER BY `unit` DESC [ RunTime:0.005400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520840 LIMIT 2 [ RunTime:0.013538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520840 ORDER BY `minOrder` ASC [ RunTime:0.003909s ]
select * from pdf where partno='86621' and brandshort='Brady Corporation' limit 1 [ RunTime:0.016531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86621' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.018705s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520840 AND `partno` = '86621' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.028075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344853 [ RunTime:0.015039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64520832 LIMIT 5 [ RunTime:0.036065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520832 ORDER BY `minOrder` ASC [ RunTime:0.021577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64520832 ORDER BY `unit` DESC [ RunTime:0.016119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64520832 LIMIT 2 [ RunTime:0.014915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64520832 ORDER BY `minOrder` ASC [ RunTime:0.018764s ]
select * from pdf where partno='86620' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86620' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001948s ]
SELECT `id` FROM `stock` WHERE `id` <> 64520832 AND `partno` = '86620' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.019364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14344851 [ RunTime:0.002144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64507199 LIMIT 5 [ RunTime:0.005787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64507199 ORDER BY `minOrder` ASC [ RunTime:0.001070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64507199 ORDER BY `unit` DESC [ RunTime:0.005429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64507199 LIMIT 2 [ RunTime:0.003928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64507199 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='8662413035' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8662413035' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.001162s ]
SELECT `id` FROM `stock` WHERE `id` <> 64507199 AND `partno` = '8662413035' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.001424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14354743 [ RunTime:0.003334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64250228 LIMIT 5 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250228 ORDER BY `minOrder` ASC [ RunTime:0.007434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64250228 ORDER BY `unit` DESC [ RunTime:0.004360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64250228 LIMIT 2 [ RunTime:0.005516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250228 ORDER BY `minOrder` ASC [ RunTime:0.007251s ]
select * from pdf where partno='86624130' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.001718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86624130' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.005811s ]
SELECT `id` FROM `stock` WHERE `id` <> 64250228 AND `partno` = '86624130' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.014739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16145376 [ RunTime:0.010621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64250208 LIMIT 5 [ RunTime:0.023014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250208 ORDER BY `minOrder` ASC [ RunTime:0.010053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64250208 ORDER BY `unit` DESC [ RunTime:0.007323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64250208 LIMIT 2 [ RunTime:0.021662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250208 ORDER BY `minOrder` ASC [ RunTime:0.024318s ]
select * from pdf where partno='86624160' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.031033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86624160' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.003018s ]
SELECT `id` FROM `stock` WHERE `id` <> 64250208 AND `partno` = '86624160' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.002906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17140403 [ RunTime:0.004862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64250190 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250190 ORDER BY `minOrder` ASC [ RunTime:0.000885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64250190 ORDER BY `unit` DESC [ RunTime:0.028124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64250190 LIMIT 2 [ RunTime:0.022064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64250190 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
select * from pdf where partno='86622072' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.003775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86622072' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.005007s ]
SELECT `id` FROM `stock` WHERE `id` <> 64250190 AND `partno` = '86622072' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.003432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17139846 [ RunTime:0.010211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64248486 LIMIT 5 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64248486 ORDER BY `minOrder` ASC [ RunTime:0.008632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64248486 ORDER BY `unit` DESC [ RunTime:0.011554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64248486 LIMIT 2 [ RunTime:0.017057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64248486 ORDER BY `minOrder` ASC [ RunTime:0.014230s ]
select * from pdf where partno='86622075' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.020554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86622075' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.001340s ]
SELECT `id` FROM `stock` WHERE `id` <> 64248486 AND `partno` = '86622075' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.001121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17140398 [ RunTime:0.019979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64248481 LIMIT 5 [ RunTime:0.011388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64248481 ORDER BY `minOrder` ASC [ RunTime:0.000826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64248481 ORDER BY `unit` DESC [ RunTime:0.000563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64248481 LIMIT 2 [ RunTime:0.003777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64248481 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
select * from pdf where partno='86625202' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.005370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86625202' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.020794s ]
SELECT `id` FROM `stock` WHERE `id` <> 64248481 AND `partno` = '86625202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.043791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264837 [ RunTime:0.022198s ]
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 '8662%' OR `brand` LIKE '8662%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026239s ]
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 '8662%' OR `brand` LIKE '8662%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005092s ]
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 '8662%' OR `brand` LIKE '8662%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022941s ]
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 '8662%' OR `brand` LIKE '8662%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027248s ]
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 '8662%' OR `brand` LIKE '8662%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036448s ]
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 '8662%' OR `brand` LIKE '8662%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040313s ]
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 '8662%' OR `brand` LIKE '8662%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046446s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '8662%' OR `brand` LIKE '8662%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.037757s ]