SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001172s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.215' , `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=40-901-30-vac%2FkPa&search=1' [ RunTime:0.005734s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001437s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002344s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003006s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.215' ) [ RunTime:0.019844s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001511s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005607s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001522s ]
SELECT * FROM `stock_search` WHERE `partno` = '40-901-30-vac/kPa' LIMIT 1 [ RunTime:0.004251s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-12 22:09:01' WHERE `partno` = '40-901-30-vac/kPa' [ RunTime:0.001714s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001561s ]
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 '40-901-30-vac/kPa%' OR `brand` LIKE '40-901-30-vac/kPa%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017919s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860775 LIMIT 5 [ RunTime:0.009510s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860775 ORDER BY `minOrder` ASC [ RunTime:0.008068s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860775 ORDER BY `unit` DESC [ RunTime:0.000551s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860775 LIMIT 2 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860775 ORDER BY `minOrder` ASC [ RunTime:0.003196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860759 LIMIT 5 [ RunTime:0.000813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860759 ORDER BY `minOrder` ASC [ RunTime:0.001931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860759 ORDER BY `unit` DESC [ RunTime:0.003536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860759 LIMIT 2 [ RunTime:0.000318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860759 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860333 LIMIT 5 [ RunTime:0.002921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860333 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860333 ORDER BY `unit` DESC [ RunTime:0.000327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860333 LIMIT 2 [ RunTime:0.006726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860333 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860276 LIMIT 5 [ RunTime:0.005264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860276 ORDER BY `minOrder` ASC [ RunTime:0.002061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860276 ORDER BY `unit` DESC [ RunTime:0.000423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860276 LIMIT 2 [ RunTime:0.003093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860276 ORDER BY `minOrder` ASC [ RunTime:0.002382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859998 LIMIT 5 [ RunTime:0.002758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859998 ORDER BY `minOrder` ASC [ RunTime:0.001531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859998 ORDER BY `unit` DESC [ RunTime:0.002545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859998 LIMIT 2 [ RunTime:0.010074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859998 ORDER BY `minOrder` ASC [ RunTime:0.013523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859773 LIMIT 5 [ RunTime:0.007515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859773 ORDER BY `minOrder` ASC [ RunTime:0.017311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859773 ORDER BY `unit` DESC [ RunTime:0.000687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859773 LIMIT 2 [ RunTime:0.002085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859773 ORDER BY `minOrder` ASC [ RunTime:0.002163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859705 LIMIT 5 [ RunTime:0.008434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859705 ORDER BY `minOrder` ASC [ RunTime:0.002753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859705 ORDER BY `unit` DESC [ RunTime:0.001022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859705 LIMIT 2 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859705 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859664 LIMIT 5 [ RunTime:0.005308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859664 ORDER BY `minOrder` ASC [ RunTime:0.012110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859664 ORDER BY `unit` DESC [ RunTime:0.009908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859664 LIMIT 2 [ RunTime:0.030784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859664 ORDER BY `minOrder` ASC [ RunTime:0.012395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859640 LIMIT 5 [ RunTime:0.003073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859640 ORDER BY `minOrder` ASC [ RunTime:0.006580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859640 ORDER BY `unit` DESC [ RunTime:0.008346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859640 LIMIT 2 [ RunTime:0.002559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859640 ORDER BY `minOrder` ASC [ RunTime:0.002359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859577 LIMIT 5 [ RunTime:0.009208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859577 ORDER BY `minOrder` ASC [ RunTime:0.003554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859577 ORDER BY `unit` DESC [ RunTime:0.008886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859577 LIMIT 2 [ RunTime:0.003640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859577 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859512 LIMIT 5 [ RunTime:0.001176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859512 ORDER BY `minOrder` ASC [ RunTime:0.000975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859512 ORDER BY `unit` DESC [ RunTime:0.003590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859512 LIMIT 2 [ RunTime:0.008991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859512 ORDER BY `minOrder` ASC [ RunTime:0.005199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859482 LIMIT 5 [ RunTime:0.000851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859482 ORDER BY `minOrder` ASC [ RunTime:0.007551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859482 ORDER BY `unit` DESC [ RunTime:0.005717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859482 LIMIT 2 [ RunTime:0.005848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859482 ORDER BY `minOrder` ASC [ RunTime:0.002000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858975 LIMIT 5 [ RunTime:0.001222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858975 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858975 ORDER BY `unit` DESC [ RunTime:0.000297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858975 LIMIT 2 [ RunTime:0.000274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858975 ORDER BY `minOrder` ASC [ RunTime:0.000807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858903 LIMIT 5 [ RunTime:0.003169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858903 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858903 ORDER BY `unit` DESC [ RunTime:0.007983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858903 LIMIT 2 [ RunTime:0.010071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858903 ORDER BY `minOrder` ASC [ RunTime:0.007830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858898 LIMIT 5 [ RunTime:0.001040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858898 ORDER BY `minOrder` ASC [ RunTime:0.004128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858898 ORDER BY `unit` DESC [ RunTime:0.000503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858898 LIMIT 2 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858898 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026027 LIMIT 5 [ RunTime:0.000845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026027 ORDER BY `minOrder` ASC [ RunTime:0.004082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17026027 ORDER BY `unit` DESC [ RunTime:0.008835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17026027 LIMIT 2 [ RunTime:0.000386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026027 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026016 LIMIT 5 [ RunTime:0.003492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026016 ORDER BY `minOrder` ASC [ RunTime:0.002497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17026016 ORDER BY `unit` DESC [ RunTime:0.000460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17026016 LIMIT 2 [ RunTime:0.000418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026016 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025927 LIMIT 5 [ RunTime:0.001084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025927 ORDER BY `minOrder` ASC [ RunTime:0.002362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025927 ORDER BY `unit` DESC [ RunTime:0.008800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025927 LIMIT 2 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025927 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025904 LIMIT 5 [ RunTime:0.003764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025904 ORDER BY `minOrder` ASC [ RunTime:0.005646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025904 ORDER BY `unit` DESC [ RunTime:0.001474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025904 LIMIT 2 [ RunTime:0.000860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025904 ORDER BY `minOrder` ASC [ RunTime:0.001510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025892 LIMIT 5 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025892 ORDER BY `minOrder` ASC [ RunTime:0.000626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025892 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025892 LIMIT 2 [ RunTime:0.003908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025892 ORDER BY `minOrder` ASC [ RunTime:0.000978s ]
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 '40-901-30-vac/kPa%' OR `brand` LIKE '40-901-30-vac/kPa%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001245s ]
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 '40-901-30-vac/kPa%' OR `brand` LIKE '40-901-30-vac/kPa%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37476294 LIMIT 5 [ RunTime:0.002111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476294 ORDER BY `minOrder` ASC [ RunTime:0.000844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37476294 ORDER BY `unit` DESC [ RunTime:0.000928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37476294 LIMIT 2 [ RunTime:0.005803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476294 ORDER BY `minOrder` ASC [ RunTime:0.005286s ]
select * from pdf where partno='40-901-30-vac/kPa-SSRF-MIP-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.004015s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-SSRF-MIP-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004759s ]
SELECT `id` FROM `stock` WHERE `id` <> 37476294 AND `partno` = '40-901-30-vac/kPa-SSRF-MIP-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.007023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860775 [ RunTime:0.000567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37476282 LIMIT 5 [ RunTime:0.000944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476282 ORDER BY `minOrder` ASC [ RunTime:0.009621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37476282 ORDER BY `unit` DESC [ RunTime:0.000979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37476282 LIMIT 2 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476282 ORDER BY `minOrder` ASC [ RunTime:0.001397s ]
select * from pdf where partno='40-901-30-vac/kPa-SSRF-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.016417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-SSRF-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001240s ]
SELECT `id` FROM `stock` WHERE `id` <> 37476282 AND `partno` = '40-901-30-vac/kPa-SSRF-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860759 [ RunTime:0.003180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475797 LIMIT 5 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475797 ORDER BY `minOrder` ASC [ RunTime:0.002352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475797 ORDER BY `unit` DESC [ RunTime:0.004662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475797 LIMIT 2 [ RunTime:0.003872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475797 ORDER BY `minOrder` ASC [ RunTime:0.001173s ]
select * from pdf where partno='40-901-30-vac/kPa-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000622s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475797 AND `partno` = '40-901-30-vac/kPa-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860333 [ RunTime:0.000504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475762 LIMIT 5 [ RunTime:0.000581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475762 ORDER BY `minOrder` ASC [ RunTime:0.003705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475762 ORDER BY `unit` DESC [ RunTime:0.000521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475762 LIMIT 2 [ RunTime:0.002388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475762 ORDER BY `minOrder` ASC [ RunTime:0.004492s ]
select * from pdf where partno='40-901-30-vac/kPa-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001079s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475762 AND `partno` = '40-901-30-vac/kPa-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860276 [ RunTime:0.004499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475437 LIMIT 5 [ RunTime:0.002051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475437 ORDER BY `minOrder` ASC [ RunTime:0.010442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475437 ORDER BY `unit` DESC [ RunTime:0.002065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475437 LIMIT 2 [ RunTime:0.004269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475437 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
select * from pdf where partno='40-901-30-vac/kPa-SSRF-MIP-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-SSRF-MIP-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001447s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475437 AND `partno` = '40-901-30-vac/kPa-SSRF-MIP-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.012054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859998 [ RunTime:0.002113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475415 LIMIT 5 [ RunTime:0.008697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475415 ORDER BY `minOrder` ASC [ RunTime:0.013839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475415 ORDER BY `unit` DESC [ RunTime:0.003508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475415 LIMIT 2 [ RunTime:0.002267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475415 ORDER BY `minOrder` ASC [ RunTime:0.010396s ]
select * from pdf where partno='40-901-30-vac/kPa-SSRF-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.009185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-SSRF-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006603s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475415 AND `partno` = '40-901-30-vac/kPa-SSRF-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025927 [ RunTime:0.003879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37474972 LIMIT 5 [ RunTime:0.007058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474972 ORDER BY `minOrder` ASC [ RunTime:0.012700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37474972 ORDER BY `unit` DESC [ RunTime:0.009102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37474972 LIMIT 2 [ RunTime:0.013883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474972 ORDER BY `minOrder` ASC [ RunTime:0.004833s ]
select * from pdf where partno='40-901-30-vac/kPa-SSRF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.011540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-SSRF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004278s ]
SELECT `id` FROM `stock` WHERE `id` <> 37474972 AND `partno` = '40-901-30-vac/kPa-SSRF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.017086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859512 [ RunTime:0.015499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37474953 LIMIT 5 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474953 ORDER BY `minOrder` ASC [ RunTime:0.003627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37474953 ORDER BY `unit` DESC [ RunTime:0.008891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37474953 LIMIT 2 [ RunTime:0.022390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474953 ORDER BY `minOrder` ASC [ RunTime:0.000749s ]
select * from pdf where partno='40-901-30-vac/kPa-SSRF' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-SSRF' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009806s ]
SELECT `id` FROM `stock` WHERE `id` <> 37474953 AND `partno` = '40-901-30-vac/kPa-SSRF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.010352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859482 [ RunTime:0.025947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089913 LIMIT 5 [ RunTime:0.005100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089913 ORDER BY `minOrder` ASC [ RunTime:0.011480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089913 ORDER BY `unit` DESC [ RunTime:0.022180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089913 LIMIT 2 [ RunTime:0.001091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089913 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
select * from pdf where partno='40-901-30-vac/kPa-MIP-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-MIP-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007377s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089913 AND `partno` = '40-901-30-vac/kPa-MIP-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026027 [ RunTime:0.001551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089883 LIMIT 5 [ RunTime:0.000554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089883 ORDER BY `minOrder` ASC [ RunTime:0.002788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089883 ORDER BY `unit` DESC [ RunTime:0.003477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089883 LIMIT 2 [ RunTime:0.000988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089883 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='40-901-30-vac/kPa-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010042s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089883 AND `partno` = '40-901-30-vac/kPa-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026016 [ RunTime:0.000559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089308 LIMIT 5 [ RunTime:0.006411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089308 ORDER BY `minOrder` ASC [ RunTime:0.005922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089308 ORDER BY `unit` DESC [ RunTime:0.008397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089308 LIMIT 2 [ RunTime:0.010181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089308 ORDER BY `minOrder` ASC [ RunTime:0.007877s ]
select * from pdf where partno='40-901-30-vac/kPa-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.006934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002029s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089308 AND `partno` = '40-901-30-vac/kPa-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025904 [ RunTime:0.002937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089278 LIMIT 5 [ RunTime:0.008143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089278 ORDER BY `minOrder` ASC [ RunTime:0.001088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089278 ORDER BY `unit` DESC [ RunTime:0.001590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089278 LIMIT 2 [ RunTime:0.004128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089278 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
select * from pdf where partno='40-901-30-vac/kPa-DRY-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-DRY-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005392s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089278 AND `partno` = '40-901-30-vac/kPa-DRY-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.011099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859773 [ RunTime:0.014527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089276 LIMIT 5 [ RunTime:0.010143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089276 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089276 ORDER BY `unit` DESC [ RunTime:0.000528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089276 LIMIT 2 [ RunTime:0.005559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089276 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
select * from pdf where partno='40-901-30-vac/kPa-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004414s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089276 AND `partno` = '40-901-30-vac/kPa-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.005845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025892 [ RunTime:0.032097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089175 LIMIT 5 [ RunTime:0.035386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089175 ORDER BY `minOrder` ASC [ RunTime:0.023014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089175 ORDER BY `unit` DESC [ RunTime:0.008143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089175 LIMIT 2 [ RunTime:0.007295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089175 ORDER BY `minOrder` ASC [ RunTime:0.012685s ]
select * from pdf where partno='40-901-30-vac/kPa-SG-DRY-O2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.009753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-SG-DRY-O2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020124s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089175 AND `partno` = '40-901-30-vac/kPa-SG-DRY-O2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.022040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859705 [ RunTime:0.015888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089131 LIMIT 5 [ RunTime:0.013511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089131 ORDER BY `minOrder` ASC [ RunTime:0.029277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089131 ORDER BY `unit` DESC [ RunTime:0.007481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089131 LIMIT 2 [ RunTime:0.014640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089131 ORDER BY `minOrder` ASC [ RunTime:0.003949s ]
select * from pdf where partno='40-901-30-vac/kPa-MIP-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-MIP-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010085s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089131 AND `partno` = '40-901-30-vac/kPa-MIP-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859664 [ RunTime:0.004018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089114 LIMIT 5 [ RunTime:0.012267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089114 ORDER BY `minOrder` ASC [ RunTime:0.000953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089114 ORDER BY `unit` DESC [ RunTime:0.001958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089114 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089114 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
select * from pdf where partno='40-901-30-vac/kPa-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000882s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089114 AND `partno` = '40-901-30-vac/kPa-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859640 [ RunTime:0.004802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089045 LIMIT 5 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089045 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089045 ORDER BY `unit` DESC [ RunTime:0.001013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089045 LIMIT 2 [ RunTime:0.001689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089045 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
select * from pdf where partno='40-901-30-vac/kPa-DRY-O2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.005773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-DRY-O2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000873s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089045 AND `partno` = '40-901-30-vac/kPa-DRY-O2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859577 [ RunTime:0.000579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088603 LIMIT 5 [ RunTime:0.006094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088603 ORDER BY `minOrder` ASC [ RunTime:0.004157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088603 ORDER BY `unit` DESC [ RunTime:0.006000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088603 LIMIT 2 [ RunTime:0.002226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088603 ORDER BY `minOrder` ASC [ RunTime:0.001281s ]
select * from pdf where partno='40-901-30-vac/kPa-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000751s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088603 AND `partno` = '40-901-30-vac/kPa-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240807 [ RunTime:0.004518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088453 LIMIT 5 [ RunTime:0.001610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088453 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088453 ORDER BY `unit` DESC [ RunTime:0.001204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088453 LIMIT 2 [ RunTime:0.000525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088453 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='40-901-30-vac/kPa-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.004018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001800s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088453 AND `partno` = '40-901-30-vac/kPa-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.006728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025717 [ RunTime:0.001076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088445 LIMIT 5 [ RunTime:0.002926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088445 ORDER BY `minOrder` ASC [ RunTime:0.004696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088445 ORDER BY `unit` DESC [ RunTime:0.002549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088445 LIMIT 2 [ RunTime:0.002265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088445 ORDER BY `minOrder` ASC [ RunTime:0.007165s ]
select * from pdf where partno='40-901-30-vac/kPa-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-30-vac/kPa-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004293s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088445 AND `partno` = '40-901-30-vac/kPa-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.006761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858975 [ RunTime:0.002124s ]
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 '40-901-30-vac/kPa%' OR `brand` LIKE '40-901-30-vac/kPa%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001682s ]
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 '40-901-30-vac/kPa%' OR `brand` LIKE '40-901-30-vac/kPa%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003612s ]
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 '40-901-30-vac/kPa%' OR `brand` LIKE '40-901-30-vac/kPa%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001142s ]
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 '40-901-30-vac/kPa%' OR `brand` LIKE '40-901-30-vac/kPa%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001202s ]
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 '40-901-30-vac/kPa%' OR `brand` LIKE '40-901-30-vac/kPa%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002023s ]
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 '40-901-30-vac/kPa%' OR `brand` LIKE '40-901-30-vac/kPa%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001152s ]
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 '40-901-30-vac/kPa%' OR `brand` LIKE '40-901-30-vac/kPa%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005642s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40-901-30-vac/kPa%' OR `brand` LIKE '40-901-30-vac/kPa%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002275s ]