SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002312s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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-5000-psi%2Fkg%2Fcm2&search=1' [ RunTime:0.002024s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002219s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000625s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001791s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.001007s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002021s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002299s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001541s ]
SELECT * FROM `stock_search` WHERE `partno` = '40-901-5000-psi/kg/cm2' LIMIT 1 [ RunTime:0.006936s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 18:24:59' WHERE `partno` = '40-901-5000-psi/kg/cm2' [ RunTime:0.003694s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001601s ]
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-5000-psi/kg/cm2%' OR `brand` LIKE '40-901-5000-psi/kg/cm2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006155s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860363 LIMIT 5 [ RunTime:0.004521s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860363 ORDER BY `minOrder` ASC [ RunTime:0.000885s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860363 ORDER BY `unit` DESC [ RunTime:0.000786s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860363 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860363 ORDER BY `minOrder` ASC [ RunTime:0.005031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860362 LIMIT 5 [ RunTime:0.010603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860362 ORDER BY `minOrder` ASC [ RunTime:0.024247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860362 ORDER BY `unit` DESC [ RunTime:0.005879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860362 LIMIT 2 [ RunTime:0.000749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860362 ORDER BY `minOrder` ASC [ RunTime:0.001107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860317 LIMIT 5 [ RunTime:0.009587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860317 ORDER BY `minOrder` ASC [ RunTime:0.013770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860317 ORDER BY `unit` DESC [ RunTime:0.018792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860317 LIMIT 2 [ RunTime:0.010767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860317 ORDER BY `minOrder` ASC [ RunTime:0.016340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860316 LIMIT 5 [ RunTime:0.013547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860316 ORDER BY `minOrder` ASC [ RunTime:0.003158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860316 ORDER BY `unit` DESC [ RunTime:0.002145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860316 LIMIT 2 [ RunTime:0.000722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860316 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859824 LIMIT 5 [ RunTime:0.010115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859824 ORDER BY `minOrder` ASC [ RunTime:0.013418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859824 ORDER BY `unit` DESC [ RunTime:0.012577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859824 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859824 ORDER BY `minOrder` ASC [ RunTime:0.002252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859823 LIMIT 5 [ RunTime:0.011995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859823 ORDER BY `minOrder` ASC [ RunTime:0.017726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859823 ORDER BY `unit` DESC [ RunTime:0.003765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859823 LIMIT 2 [ RunTime:0.005118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859823 ORDER BY `minOrder` ASC [ RunTime:0.006631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859795 LIMIT 5 [ RunTime:0.017158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859795 ORDER BY `minOrder` ASC [ RunTime:0.010100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859795 ORDER BY `unit` DESC [ RunTime:0.018496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859795 LIMIT 2 [ RunTime:0.005227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859795 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859509 LIMIT 5 [ RunTime:0.001052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859509 ORDER BY `minOrder` ASC [ RunTime:0.000793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859509 ORDER BY `unit` DESC [ RunTime:0.002910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859509 LIMIT 2 [ RunTime:0.007816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859509 ORDER BY `minOrder` ASC [ RunTime:0.007465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859508 LIMIT 5 [ RunTime:0.006790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859508 ORDER BY `minOrder` ASC [ RunTime:0.012448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859508 ORDER BY `unit` DESC [ RunTime:0.021014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859508 LIMIT 2 [ RunTime:0.008211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859508 ORDER BY `minOrder` ASC [ RunTime:0.013743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859146 LIMIT 5 [ RunTime:0.009427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859146 ORDER BY `minOrder` ASC [ RunTime:0.013012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859146 ORDER BY `unit` DESC [ RunTime:0.006566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859146 LIMIT 2 [ RunTime:0.005510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859146 ORDER BY `minOrder` ASC [ RunTime:0.003449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859145 LIMIT 5 [ RunTime:0.015887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859145 ORDER BY `minOrder` ASC [ RunTime:0.031972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859145 ORDER BY `unit` DESC [ RunTime:0.010912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859145 LIMIT 2 [ RunTime:0.009604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859145 ORDER BY `minOrder` ASC [ RunTime:0.002513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859046 LIMIT 5 [ RunTime:0.000936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859046 ORDER BY `minOrder` ASC [ RunTime:0.017162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859046 ORDER BY `unit` DESC [ RunTime:0.029290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859046 LIMIT 2 [ RunTime:0.019184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859046 ORDER BY `minOrder` ASC [ RunTime:0.004261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859022 LIMIT 5 [ RunTime:0.055597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859022 ORDER BY `minOrder` ASC [ RunTime:0.024510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859022 ORDER BY `unit` DESC [ RunTime:0.011512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859022 LIMIT 2 [ RunTime:0.012882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859022 ORDER BY `minOrder` ASC [ RunTime:0.006014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859021 LIMIT 5 [ RunTime:0.016811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859021 ORDER BY `minOrder` ASC [ RunTime:0.011271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859021 ORDER BY `unit` DESC [ RunTime:0.043597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859021 LIMIT 2 [ RunTime:0.051770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859021 ORDER BY `minOrder` ASC [ RunTime:0.015783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858963 LIMIT 5 [ RunTime:0.035622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858963 ORDER BY `minOrder` ASC [ RunTime:0.051031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858963 ORDER BY `unit` DESC [ RunTime:0.040093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858963 LIMIT 2 [ RunTime:0.078811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858963 ORDER BY `minOrder` ASC [ RunTime:0.031713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858962 LIMIT 5 [ RunTime:0.054654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858962 ORDER BY `minOrder` ASC [ RunTime:0.056305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858962 ORDER BY `unit` DESC [ RunTime:0.030585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858962 LIMIT 2 [ RunTime:0.012123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858962 ORDER BY `minOrder` ASC [ RunTime:0.004458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025902 LIMIT 5 [ RunTime:0.034939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025902 ORDER BY `minOrder` ASC [ RunTime:0.036029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025902 ORDER BY `unit` DESC [ RunTime:0.029412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025902 LIMIT 2 [ RunTime:0.004975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025902 ORDER BY `minOrder` ASC [ RunTime:0.005801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025824 LIMIT 5 [ RunTime:0.009867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025824 ORDER BY `minOrder` ASC [ RunTime:0.012709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025824 ORDER BY `unit` DESC [ RunTime:0.014639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025824 LIMIT 2 [ RunTime:0.024443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025824 ORDER BY `minOrder` ASC [ RunTime:0.000912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025712 LIMIT 5 [ RunTime:0.016527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025712 ORDER BY `minOrder` ASC [ RunTime:0.024928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025712 ORDER BY `unit` DESC [ RunTime:0.023991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025712 LIMIT 2 [ RunTime:0.042595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025712 ORDER BY `minOrder` ASC [ RunTime:0.013229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025711 LIMIT 5 [ RunTime:0.024431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025711 ORDER BY `minOrder` ASC [ RunTime:0.004752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025711 ORDER BY `unit` DESC [ RunTime:0.016486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025711 LIMIT 2 [ RunTime:0.010155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025711 ORDER BY `minOrder` ASC [ RunTime:0.012667s ]
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-5000-psi/kg/cm2%' OR `brand` LIKE '40-901-5000-psi/kg/cm2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026071s ]
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-5000-psi/kg/cm2%' OR `brand` LIKE '40-901-5000-psi/kg/cm2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089332 LIMIT 5 [ RunTime:0.011527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089332 ORDER BY `minOrder` ASC [ RunTime:0.030029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089332 ORDER BY `unit` DESC [ RunTime:0.017381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089332 LIMIT 2 [ RunTime:0.050471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089332 ORDER BY `minOrder` ASC [ RunTime:0.012873s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.033362s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017123s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089332 AND `partno` = '40-901-5000-psi/kg/cm2-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.015093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859824 [ RunTime:0.014094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089331 LIMIT 5 [ RunTime:0.018809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089331 ORDER BY `minOrder` ASC [ RunTime:0.004716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089331 ORDER BY `unit` DESC [ RunTime:0.012674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089331 LIMIT 2 [ RunTime:0.001195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089331 ORDER BY `minOrder` ASC [ RunTime:0.006657s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-1/2-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-1/2-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005864s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089331 AND `partno` = '40-901-5000-psi/kg/cm2-1/2-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.014798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859823 [ RunTime:0.002650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089303 LIMIT 5 [ RunTime:0.009478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089303 ORDER BY `minOrder` ASC [ RunTime:0.013475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089303 ORDER BY `unit` DESC [ RunTime:0.003313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089303 LIMIT 2 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089303 ORDER BY `minOrder` ASC [ RunTime:0.001480s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-1/2-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-1/2-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002077s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089303 AND `partno` = '40-901-5000-psi/kg/cm2-1/2-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025902 [ RunTime:0.018801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089302 LIMIT 5 [ RunTime:0.013863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089302 ORDER BY `minOrder` ASC [ RunTime:0.005887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089302 ORDER BY `unit` DESC [ RunTime:0.003070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089302 LIMIT 2 [ RunTime:0.012015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089302 ORDER BY `minOrder` ASC [ RunTime:0.011212s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.017163s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006724s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089302 AND `partno` = '40-901-5000-psi/kg/cm2-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.010995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859795 [ RunTime:0.007873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088655 LIMIT 5 [ RunTime:0.003855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088655 ORDER BY `minOrder` ASC [ RunTime:0.011453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088655 ORDER BY `unit` DESC [ RunTime:0.003918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088655 LIMIT 2 [ RunTime:0.001632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088655 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.009068s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003239s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088655 AND `partno` = '40-901-5000-psi/kg/cm2-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859146 [ RunTime:0.013059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088654 LIMIT 5 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088654 ORDER BY `minOrder` ASC [ RunTime:0.010748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088654 ORDER BY `unit` DESC [ RunTime:0.003136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088654 LIMIT 2 [ RunTime:0.001399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088654 ORDER BY `minOrder` ASC [ RunTime:0.003329s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-1/2-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.017326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-1/2-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006967s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088654 AND `partno` = '40-901-5000-psi/kg/cm2-1/2-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.013312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859145 [ RunTime:0.005244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088566 LIMIT 5 [ RunTime:0.007949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088566 ORDER BY `minOrder` ASC [ RunTime:0.017363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088566 ORDER BY `unit` DESC [ RunTime:0.003005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088566 LIMIT 2 [ RunTime:0.004029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088566 ORDER BY `minOrder` ASC [ RunTime:0.013445s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-1/2-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.014355s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-1/2-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002112s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088566 AND `partno` = '40-901-5000-psi/kg/cm2-1/2-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.005451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859046 [ RunTime:0.014222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088565 LIMIT 5 [ RunTime:0.014945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088565 ORDER BY `minOrder` ASC [ RunTime:0.014289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088565 ORDER BY `unit` DESC [ RunTime:0.001909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088565 LIMIT 2 [ RunTime:0.008875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088565 ORDER BY `minOrder` ASC [ RunTime:0.007625s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009200s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088565 AND `partno` = '40-901-5000-psi/kg/cm2-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.008405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14187361 [ RunTime:0.029112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088545 LIMIT 5 [ RunTime:0.013514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088545 ORDER BY `minOrder` ASC [ RunTime:0.029073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088545 ORDER BY `unit` DESC [ RunTime:0.028143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088545 LIMIT 2 [ RunTime:0.014030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088545 ORDER BY `minOrder` ASC [ RunTime:0.005984s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-1/2-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.019329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-1/2-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016064s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088545 AND `partno` = '40-901-5000-psi/kg/cm2-1/2-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.016048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859022 [ RunTime:0.003279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088544 LIMIT 5 [ RunTime:0.024188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088544 ORDER BY `minOrder` ASC [ RunTime:0.019280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088544 ORDER BY `unit` DESC [ RunTime:0.134785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088544 LIMIT 2 [ RunTime:0.101373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088544 ORDER BY `minOrder` ASC [ RunTime:0.015240s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.022287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020759s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088544 AND `partno` = '40-901-5000-psi/kg/cm2-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.013696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859021 [ RunTime:0.076367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088428 LIMIT 5 [ RunTime:0.067328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088428 ORDER BY `minOrder` ASC [ RunTime:0.018397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088428 ORDER BY `unit` DESC [ RunTime:0.021295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088428 LIMIT 2 [ RunTime:0.011768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088428 ORDER BY `minOrder` ASC [ RunTime:0.008760s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-1/2-DRY' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.027127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-1/2-DRY' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.035575s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088428 AND `partno` = '40-901-5000-psi/kg/cm2-1/2-DRY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.049747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858963 [ RunTime:0.072695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088427 LIMIT 5 [ RunTime:0.027054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088427 ORDER BY `minOrder` ASC [ RunTime:0.037760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088427 ORDER BY `unit` DESC [ RunTime:0.092685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088427 LIMIT 2 [ RunTime:0.039923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088427 ORDER BY `minOrder` ASC [ RunTime:0.025058s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-1/2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.010281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-1/2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.049615s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088427 AND `partno` = '40-901-5000-psi/kg/cm2-1/2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.049787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025712 [ RunTime:0.059458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088426 LIMIT 5 [ RunTime:0.018714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088426 ORDER BY `minOrder` ASC [ RunTime:0.049939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088426 ORDER BY `unit` DESC [ RunTime:0.060052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088426 LIMIT 2 [ RunTime:0.016703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088426 ORDER BY `minOrder` ASC [ RunTime:0.009149s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.049213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.043925s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088426 AND `partno` = '40-901-5000-psi/kg/cm2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.086529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858962 [ RunTime:0.044076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088425 LIMIT 5 [ RunTime:0.086425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088425 ORDER BY `minOrder` ASC [ RunTime:0.036911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088425 ORDER BY `unit` DESC [ RunTime:0.047626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088425 LIMIT 2 [ RunTime:0.039196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088425 ORDER BY `minOrder` ASC [ RunTime:0.057212s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-DRY' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.018801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-DRY' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.066875s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088425 AND `partno` = '40-901-5000-psi/kg/cm2-DRY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.034377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025711 [ RunTime:0.066109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475831 LIMIT 5 [ RunTime:0.015359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475831 ORDER BY `minOrder` ASC [ RunTime:0.026968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475831 ORDER BY `unit` DESC [ RunTime:0.004547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475831 LIMIT 2 [ RunTime:0.029043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475831 ORDER BY `minOrder` ASC [ RunTime:0.050505s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.035607s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475831 AND `partno` = '40-901-5000-psi/kg/cm2-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.020976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860363 [ RunTime:0.018139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475830 LIMIT 5 [ RunTime:0.012831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475830 ORDER BY `minOrder` ASC [ RunTime:0.026920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475830 ORDER BY `unit` DESC [ RunTime:0.010588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475830 LIMIT 2 [ RunTime:0.030122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475830 ORDER BY `minOrder` ASC [ RunTime:0.003784s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-1/2-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.010829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-1/2-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016392s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475830 AND `partno` = '40-901-5000-psi/kg/cm2-1/2-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860362 [ RunTime:0.005423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475787 LIMIT 5 [ RunTime:0.001672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475787 ORDER BY `minOrder` ASC [ RunTime:0.011592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475787 ORDER BY `unit` DESC [ RunTime:0.011963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475787 LIMIT 2 [ RunTime:0.003594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475787 ORDER BY `minOrder` ASC [ RunTime:0.009054s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004349s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475787 AND `partno` = '40-901-5000-psi/kg/cm2-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.011900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860317 [ RunTime:0.015990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475786 LIMIT 5 [ RunTime:0.001811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475786 ORDER BY `minOrder` ASC [ RunTime:0.000826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475786 ORDER BY `unit` DESC [ RunTime:0.008312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475786 LIMIT 2 [ RunTime:0.003681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475786 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-1/2-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-1/2-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015147s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475786 AND `partno` = '40-901-5000-psi/kg/cm2-1/2-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.020871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860316 [ RunTime:0.048317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37474985 LIMIT 5 [ RunTime:0.033572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474985 ORDER BY `minOrder` ASC [ RunTime:0.005879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37474985 ORDER BY `unit` DESC [ RunTime:0.005269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37474985 LIMIT 2 [ RunTime:0.003916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474985 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-SSRF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-SSRF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003755s ]
SELECT `id` FROM `stock` WHERE `id` <> 37474985 AND `partno` = '40-901-5000-psi/kg/cm2-SSRF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.010784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025824 [ RunTime:0.040554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37474984 LIMIT 5 [ RunTime:0.008155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474984 ORDER BY `minOrder` ASC [ RunTime:0.003836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37474984 ORDER BY `unit` DESC [ RunTime:0.000504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37474984 LIMIT 2 [ RunTime:0.007992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474984 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='40-901-5000-psi/kg/cm2-1/2-SSRF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-901-5000-psi/kg/cm2-1/2-SSRF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010128s ]
SELECT `id` FROM `stock` WHERE `id` <> 37474984 AND `partno` = '40-901-5000-psi/kg/cm2-1/2-SSRF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.022129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240877 [ RunTime:0.002069s ]
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-5000-psi/kg/cm2%' OR `brand` LIKE '40-901-5000-psi/kg/cm2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004877s ]
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-5000-psi/kg/cm2%' OR `brand` LIKE '40-901-5000-psi/kg/cm2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011673s ]
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-5000-psi/kg/cm2%' OR `brand` LIKE '40-901-5000-psi/kg/cm2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013325s ]
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-5000-psi/kg/cm2%' OR `brand` LIKE '40-901-5000-psi/kg/cm2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004148s ]
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-5000-psi/kg/cm2%' OR `brand` LIKE '40-901-5000-psi/kg/cm2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000645s ]
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-5000-psi/kg/cm2%' OR `brand` LIKE '40-901-5000-psi/kg/cm2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005905s ]
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-5000-psi/kg/cm2%' OR `brand` LIKE '40-901-5000-psi/kg/cm2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006198s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40-901-5000-psi/kg/cm2%' OR `brand` LIKE '40-901-5000-psi/kg/cm2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005585s ]