SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002619s ]
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=40-901-10000-psi%2FkPa-1%2F2&search=1' [ RunTime:0.001978s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002259s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000659s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002456s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.72' ) [ RunTime:0.000373s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002337s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002760s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002329s ]
SELECT * FROM `stock_search` WHERE `partno` = '40-901-10000-psi/kPa-1/2' LIMIT 1 [ RunTime:0.001101s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-08 09:13:24' WHERE `partno` = '40-901-10000-psi/kPa-1/2' [ RunTime:0.013064s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001410s ]
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-10000-psi/kPa-1/2%' OR `brand` LIKE '40-901-10000-psi/kPa-1/2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004206s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860842 LIMIT 5 [ RunTime:0.000719s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860842 ORDER BY `minOrder` ASC [ RunTime:0.017184s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860842 ORDER BY `unit` DESC [ RunTime:0.001609s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860842 LIMIT 2 [ RunTime:0.001168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860842 ORDER BY `minOrder` ASC [ RunTime:0.002355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860840 LIMIT 5 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860840 ORDER BY `minOrder` ASC [ RunTime:0.000856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860840 ORDER BY `unit` DESC [ RunTime:0.006591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860840 LIMIT 2 [ RunTime:0.001312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860840 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860622 LIMIT 5 [ RunTime:0.002727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860622 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860622 ORDER BY `unit` DESC [ RunTime:0.011797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860622 LIMIT 2 [ RunTime:0.001505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860622 ORDER BY `minOrder` ASC [ RunTime:0.001224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860620 LIMIT 5 [ RunTime:0.007260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860620 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860620 ORDER BY `unit` DESC [ RunTime:0.000383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860620 LIMIT 2 [ RunTime:0.001434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860620 ORDER BY `minOrder` ASC [ RunTime:0.000604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860533 LIMIT 5 [ RunTime:0.003206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860533 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860533 ORDER BY `unit` DESC [ RunTime:0.003990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860533 LIMIT 2 [ RunTime:0.007767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860533 ORDER BY `minOrder` ASC [ RunTime:0.006239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860511 LIMIT 5 [ RunTime:0.001068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860511 ORDER BY `minOrder` ASC [ RunTime:0.001102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860511 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860511 LIMIT 2 [ RunTime:0.001415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860511 ORDER BY `minOrder` ASC [ RunTime:0.002367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860093 LIMIT 5 [ RunTime:0.002151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860093 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860093 ORDER BY `unit` DESC [ RunTime:0.000382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860093 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860093 ORDER BY `minOrder` ASC [ RunTime:0.005609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860088 LIMIT 5 [ RunTime:0.004466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860088 ORDER BY `minOrder` ASC [ RunTime:0.002856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860088 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860088 LIMIT 2 [ RunTime:0.001360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860088 ORDER BY `minOrder` ASC [ RunTime:0.003366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860001 LIMIT 5 [ RunTime:0.001091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860001 ORDER BY `minOrder` ASC [ RunTime:0.001252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860001 ORDER BY `unit` DESC [ RunTime:0.000625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860001 LIMIT 2 [ RunTime:0.001189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860001 ORDER BY `minOrder` ASC [ RunTime:0.002889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859717 LIMIT 5 [ RunTime:0.001017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859717 ORDER BY `minOrder` ASC [ RunTime:0.001359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859717 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859717 LIMIT 2 [ RunTime:0.001219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859717 ORDER BY `minOrder` ASC [ RunTime:0.003240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859619 LIMIT 5 [ RunTime:0.004007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859619 ORDER BY `minOrder` ASC [ RunTime:0.004902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859619 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859619 LIMIT 2 [ RunTime:0.002462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859619 ORDER BY `minOrder` ASC [ RunTime:0.002864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859312 LIMIT 5 [ RunTime:0.001177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859312 ORDER BY `minOrder` ASC [ RunTime:0.002145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859312 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859312 LIMIT 2 [ RunTime:0.001338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859312 ORDER BY `minOrder` ASC [ RunTime:0.004124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859284 LIMIT 5 [ RunTime:0.001044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859284 ORDER BY `minOrder` ASC [ RunTime:0.001973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859284 ORDER BY `unit` DESC [ RunTime:0.000671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859284 LIMIT 2 [ RunTime:0.001505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859284 ORDER BY `minOrder` ASC [ RunTime:0.004630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859273 LIMIT 5 [ RunTime:0.003454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859273 ORDER BY `minOrder` ASC [ RunTime:0.002791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859273 ORDER BY `unit` DESC [ RunTime:0.001966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859273 LIMIT 2 [ RunTime:0.007324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859273 ORDER BY `minOrder` ASC [ RunTime:0.001487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859272 LIMIT 5 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859272 ORDER BY `minOrder` ASC [ RunTime:0.005691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859272 ORDER BY `unit` DESC [ RunTime:0.006455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859272 LIMIT 2 [ RunTime:0.009127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859272 ORDER BY `minOrder` ASC [ RunTime:0.007093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025864 LIMIT 5 [ RunTime:0.007827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025864 ORDER BY `minOrder` ASC [ RunTime:0.001976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025864 ORDER BY `unit` DESC [ RunTime:0.002588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025864 LIMIT 2 [ RunTime:0.002325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025864 ORDER BY `minOrder` ASC [ RunTime:0.002165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025837 LIMIT 5 [ RunTime:0.000960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025837 ORDER BY `minOrder` ASC [ RunTime:0.001280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025837 ORDER BY `unit` DESC [ RunTime:0.006709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025837 LIMIT 2 [ RunTime:0.007654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025837 ORDER BY `minOrder` ASC [ RunTime:0.014752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025806 LIMIT 5 [ RunTime:0.016479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025806 ORDER BY `minOrder` ASC [ RunTime:0.008062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025806 ORDER BY `unit` DESC [ RunTime:0.003751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025806 LIMIT 2 [ RunTime:0.006230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025806 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240862 LIMIT 5 [ RunTime:0.006611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240862 ORDER BY `minOrder` ASC [ RunTime:0.002465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240862 ORDER BY `unit` DESC [ RunTime:0.009719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240862 LIMIT 2 [ RunTime:0.011706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240862 ORDER BY `minOrder` ASC [ RunTime:0.019372s ]
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-10000-psi/kPa-1/2%' OR `brand` LIKE '40-901-10000-psi/kPa-1/2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015185s ]
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-10000-psi/kPa-1/2%' OR `brand` LIKE '40-901-10000-psi/kPa-1/2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37476353 LIMIT 5 [ RunTime:0.002866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476353 ORDER BY `minOrder` ASC [ RunTime:0.007808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37476353 ORDER BY `unit` DESC [ RunTime:0.004295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37476353 LIMIT 2 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476353 ORDER BY `minOrder` ASC [ RunTime:0.006950s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-SSRF-MIP-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002628s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-SSRF-MIP-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001346s ]
SELECT `id` FROM `stock` WHERE `id` <> 37476353 AND `partno` = '40-901-10000-psi/kPa-1/2-SSRF-MIP-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860842 [ RunTime:0.003403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37476349 LIMIT 5 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476349 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37476349 ORDER BY `unit` DESC [ RunTime:0.000545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37476349 LIMIT 2 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476349 ORDER BY `minOrder` ASC [ RunTime:0.002085s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-SSRF-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-SSRF-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001309s ]
SELECT `id` FROM `stock` WHERE `id` <> 37476349 AND `partno` = '40-901-10000-psi/kPa-1/2-SSRF-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860840 [ RunTime:0.003265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37476047 LIMIT 5 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476047 ORDER BY `minOrder` ASC [ RunTime:0.007806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37476047 ORDER BY `unit` DESC [ RunTime:0.002215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37476047 LIMIT 2 [ RunTime:0.005088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476047 ORDER BY `minOrder` ASC [ RunTime:0.001417s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000669s ]
SELECT `id` FROM `stock` WHERE `id` <> 37476047 AND `partno` = '40-901-10000-psi/kPa-1/2-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860533 [ RunTime:0.002055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37476014 LIMIT 5 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476014 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37476014 ORDER BY `unit` DESC [ RunTime:0.001426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37476014 LIMIT 2 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476014 ORDER BY `minOrder` ASC [ RunTime:0.000909s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000812s ]
SELECT `id` FROM `stock` WHERE `id` <> 37476014 AND `partno` = '40-901-10000-psi/kPa-1/2-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860511 [ RunTime:0.001568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475507 LIMIT 5 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475507 ORDER BY `minOrder` ASC [ RunTime:0.000807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475507 ORDER BY `unit` DESC [ RunTime:0.001439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475507 LIMIT 2 [ RunTime:0.002580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475507 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-SSRF-MIP-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-SSRF-MIP-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000736s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475507 AND `partno` = '40-901-10000-psi/kPa-1/2-SSRF-MIP-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860093 [ RunTime:0.002288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475498 LIMIT 5 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475498 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475498 ORDER BY `unit` DESC [ RunTime:0.001775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475498 LIMIT 2 [ RunTime:0.003916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475498 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-SSRF-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-SSRF-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001038s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475498 AND `partno` = '40-901-10000-psi/kPa-1/2-SSRF-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860088 [ RunTime:0.008421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475100 LIMIT 5 [ RunTime:0.005100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475100 ORDER BY `minOrder` ASC [ RunTime:0.000972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475100 ORDER BY `unit` DESC [ RunTime:0.002819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475100 LIMIT 2 [ RunTime:0.004481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475100 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-SSRF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-SSRF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001398s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475100 AND `partno` = '40-901-10000-psi/kPa-1/2-SSRF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859619 [ RunTime:0.000710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475072 LIMIT 5 [ RunTime:0.001258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475072 ORDER BY `minOrder` ASC [ RunTime:0.000695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475072 ORDER BY `unit` DESC [ RunTime:0.003052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475072 LIMIT 2 [ RunTime:0.005400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475072 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-SSRF' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-SSRF' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001591s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475072 AND `partno` = '40-901-10000-psi/kPa-1/2-SSRF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025837 [ RunTime:0.000693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089999 LIMIT 5 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089999 ORDER BY `minOrder` ASC [ RunTime:0.001147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089999 ORDER BY `unit` DESC [ RunTime:0.003217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089999 LIMIT 2 [ RunTime:0.006961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089999 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-MIP-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-MIP-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002216s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089999 AND `partno` = '40-901-10000-psi/kPa-1/2-MIP-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860622 [ RunTime:0.000675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089990 LIMIT 5 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089990 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089990 ORDER BY `unit` DESC [ RunTime:0.003127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089990 LIMIT 2 [ RunTime:0.007613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089990 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005985s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089990 AND `partno` = '40-901-10000-psi/kPa-1/2-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860620 [ RunTime:0.001707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089392 LIMIT 5 [ RunTime:0.004016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089392 ORDER BY `minOrder` ASC [ RunTime:0.002657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089392 ORDER BY `unit` DESC [ RunTime:0.000653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089392 LIMIT 2 [ RunTime:0.011281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089392 ORDER BY `minOrder` ASC [ RunTime:0.003071s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003105s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089392 AND `partno` = '40-901-10000-psi/kPa-1/2-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860001 [ RunTime:0.003353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089197 LIMIT 5 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089197 ORDER BY `minOrder` ASC [ RunTime:0.002544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089197 ORDER BY `unit` DESC [ RunTime:0.000625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089197 LIMIT 2 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089197 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-MIP-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-MIP-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003548s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089197 AND `partno` = '40-901-10000-psi/kPa-1/2-MIP-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859717 [ RunTime:0.000654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089188 LIMIT 5 [ RunTime:0.004043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089188 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089188 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089188 LIMIT 2 [ RunTime:0.001823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089188 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000742s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089188 AND `partno` = '40-901-10000-psi/kPa-1/2-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025864 [ RunTime:0.000662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088967 LIMIT 5 [ RunTime:0.004793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088967 ORDER BY `minOrder` ASC [ RunTime:0.000703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088967 ORDER BY `unit` DESC [ RunTime:0.000600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088967 LIMIT 2 [ RunTime:0.002534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088967 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-SL' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-SL' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000771s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088967 AND `partno` = '40-901-10000-psi/kPa-1/2-SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025806 [ RunTime:0.000661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088844 LIMIT 5 [ RunTime:0.006279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088844 ORDER BY `minOrder` ASC [ RunTime:0.000993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088844 ORDER BY `unit` DESC [ RunTime:0.000649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088844 LIMIT 2 [ RunTime:0.003131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088844 ORDER BY `minOrder` ASC [ RunTime:0.002281s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002135s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088844 AND `partno` = '40-901-10000-psi/kPa-1/2-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859312 [ RunTime:0.000673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088800 LIMIT 5 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088800 ORDER BY `minOrder` ASC [ RunTime:0.008343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088800 ORDER BY `unit` DESC [ RunTime:0.000635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088800 LIMIT 2 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088800 ORDER BY `minOrder` ASC [ RunTime:0.002645s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001587s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088800 AND `partno` = '40-901-10000-psi/kPa-1/2-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859284 [ RunTime:0.009761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088794 LIMIT 5 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088794 ORDER BY `minOrder` ASC [ RunTime:0.010208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088794 ORDER BY `unit` DESC [ RunTime:0.002517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088794 LIMIT 2 [ RunTime:0.005186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088794 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006044s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088794 AND `partno` = '40-901-10000-psi/kPa-1/2-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240862 [ RunTime:0.000687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088769 LIMIT 5 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088769 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088769 ORDER BY `unit` DESC [ RunTime:0.001261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088769 LIMIT 2 [ RunTime:0.008047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088769 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007514s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088769 AND `partno` = '40-901-10000-psi/kPa-1/2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859273 [ RunTime:0.000684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088767 LIMIT 5 [ RunTime:0.001123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088767 ORDER BY `minOrder` ASC [ RunTime:0.006234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088767 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088767 LIMIT 2 [ RunTime:0.004644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088767 ORDER BY `minOrder` ASC [ RunTime:0.010170s ]
select * from pdf where partno='40-901-10000-psi/kPa-1/2-DRY' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-10000-psi/kPa-1/2-DRY' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001567s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088767 AND `partno` = '40-901-10000-psi/kPa-1/2-DRY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859272 [ RunTime:0.000732s ]
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-10000-psi/kPa-1/2%' OR `brand` LIKE '40-901-10000-psi/kPa-1/2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005637s ]
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-10000-psi/kPa-1/2%' OR `brand` LIKE '40-901-10000-psi/kPa-1/2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008180s ]
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-10000-psi/kPa-1/2%' OR `brand` LIKE '40-901-10000-psi/kPa-1/2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008575s ]
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-10000-psi/kPa-1/2%' OR `brand` LIKE '40-901-10000-psi/kPa-1/2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002933s ]
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-10000-psi/kPa-1/2%' OR `brand` LIKE '40-901-10000-psi/kPa-1/2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004298s ]
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-10000-psi/kPa-1/2%' OR `brand` LIKE '40-901-10000-psi/kPa-1/2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002689s ]
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-10000-psi/kPa-1/2%' OR `brand` LIKE '40-901-10000-psi/kPa-1/2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002922s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40-901-10000-psi/kPa-1/2%' OR `brand` LIKE '40-901-10000-psi/kPa-1/2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001916s ]