SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002035s ]
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=25-901-2000-psi%2Fkg%2Fcm2&search=1' [ RunTime:0.006736s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002085s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004744s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001507s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.215' ) [ RunTime:0.000835s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001978s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001177s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002472s ]
SELECT * FROM `stock_search` WHERE `partno` = '25-901-2000-psi/kg/cm2' LIMIT 1 [ RunTime:0.003078s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-12 22:06:04' WHERE `partno` = '25-901-2000-psi/kg/cm2' [ RunTime:0.011224s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001468s ]
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 '25-901-2000-psi/kg/cm2%' OR `brand` LIKE '25-901-2000-psi/kg/cm2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021720s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18861429 LIMIT 5 [ RunTime:0.011803s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18861429 ORDER BY `minOrder` ASC [ RunTime:0.011824s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18861429 ORDER BY `unit` DESC [ RunTime:0.028731s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18861429 LIMIT 2 [ RunTime:0.033970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18861429 ORDER BY `minOrder` ASC [ RunTime:0.002881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858543 LIMIT 5 [ RunTime:0.024702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858543 ORDER BY `minOrder` ASC [ RunTime:0.005309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858543 ORDER BY `unit` DESC [ RunTime:0.031312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858543 LIMIT 2 [ RunTime:0.018322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858543 ORDER BY `minOrder` ASC [ RunTime:0.019005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858491 LIMIT 5 [ RunTime:0.029379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858491 ORDER BY `minOrder` ASC [ RunTime:0.035100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858491 ORDER BY `unit` DESC [ RunTime:0.092315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858491 LIMIT 2 [ RunTime:0.030225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858491 ORDER BY `minOrder` ASC [ RunTime:0.008355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857428 LIMIT 5 [ RunTime:0.036723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857428 ORDER BY `minOrder` ASC [ RunTime:0.049750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857428 ORDER BY `unit` DESC [ RunTime:0.071034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857428 LIMIT 2 [ RunTime:0.034878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857428 ORDER BY `minOrder` ASC [ RunTime:0.053203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857187 LIMIT 5 [ RunTime:0.028847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857187 ORDER BY `minOrder` ASC [ RunTime:0.030685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857187 ORDER BY `unit` DESC [ RunTime:0.091188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857187 LIMIT 2 [ RunTime:0.044614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857187 ORDER BY `minOrder` ASC [ RunTime:0.028709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856898 LIMIT 5 [ RunTime:0.035663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856898 ORDER BY `minOrder` ASC [ RunTime:0.035280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856898 ORDER BY `unit` DESC [ RunTime:0.040856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856898 LIMIT 2 [ RunTime:0.022293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856898 ORDER BY `minOrder` ASC [ RunTime:0.035677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856504 LIMIT 5 [ RunTime:0.013377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856504 ORDER BY `minOrder` ASC [ RunTime:0.013483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856504 ORDER BY `unit` DESC [ RunTime:0.005799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856504 LIMIT 2 [ RunTime:0.019421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856504 ORDER BY `minOrder` ASC [ RunTime:0.037167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18855793 LIMIT 5 [ RunTime:0.017889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18855793 ORDER BY `minOrder` ASC [ RunTime:0.013051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18855793 ORDER BY `unit` DESC [ RunTime:0.021786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18855793 LIMIT 2 [ RunTime:0.010889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18855793 ORDER BY `minOrder` ASC [ RunTime:0.050646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025632 LIMIT 5 [ RunTime:0.021514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025632 ORDER BY `minOrder` ASC [ RunTime:0.033633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025632 ORDER BY `unit` DESC [ RunTime:0.013639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025632 LIMIT 2 [ RunTime:0.026591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025632 ORDER BY `minOrder` ASC [ RunTime:0.026652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025503 LIMIT 5 [ RunTime:0.041274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025503 ORDER BY `minOrder` ASC [ RunTime:0.010256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025503 ORDER BY `unit` DESC [ RunTime:0.031029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025503 LIMIT 2 [ RunTime:0.018830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025503 ORDER BY `minOrder` ASC [ RunTime:0.002093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025474 LIMIT 5 [ RunTime:0.020426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025474 ORDER BY `minOrder` ASC [ RunTime:0.018910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025474 ORDER BY `unit` DESC [ RunTime:0.010271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025474 LIMIT 2 [ RunTime:0.010177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025474 ORDER BY `minOrder` ASC [ RunTime:0.007906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025388 LIMIT 5 [ RunTime:0.012931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025388 ORDER BY `minOrder` ASC [ RunTime:0.016296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025388 ORDER BY `unit` DESC [ RunTime:0.006697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025388 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025388 ORDER BY `minOrder` ASC [ RunTime:0.002223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025087 LIMIT 5 [ RunTime:0.004301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025087 ORDER BY `minOrder` ASC [ RunTime:0.002299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025087 ORDER BY `unit` DESC [ RunTime:0.010105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025087 LIMIT 2 [ RunTime:0.007474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025087 ORDER BY `minOrder` ASC [ RunTime:0.004021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240599 LIMIT 5 [ RunTime:0.001652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240599 ORDER BY `minOrder` ASC [ RunTime:0.000665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240599 ORDER BY `unit` DESC [ RunTime:0.003719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240599 LIMIT 2 [ RunTime:0.003538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240599 ORDER BY `minOrder` ASC [ RunTime:0.003094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240451 LIMIT 5 [ RunTime:0.005532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240451 ORDER BY `minOrder` ASC [ RunTime:0.008090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240451 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240451 LIMIT 2 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240451 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240444 LIMIT 5 [ RunTime:0.013277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240444 ORDER BY `minOrder` ASC [ RunTime:0.004059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240444 ORDER BY `unit` DESC [ RunTime:0.005614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240444 LIMIT 2 [ RunTime:0.002248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240444 ORDER BY `minOrder` ASC [ RunTime:0.002520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858004 LIMIT 5 [ RunTime:0.000865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858004 ORDER BY `minOrder` ASC [ RunTime:0.003243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858004 ORDER BY `unit` DESC [ RunTime:0.000691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858004 LIMIT 2 [ RunTime:0.003709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858004 ORDER BY `minOrder` ASC [ RunTime:0.004718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856603 LIMIT 5 [ RunTime:0.003659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856603 ORDER BY `minOrder` ASC [ RunTime:0.006424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856603 ORDER BY `unit` DESC [ RunTime:0.000617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856603 LIMIT 2 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856603 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856602 LIMIT 5 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856602 ORDER BY `minOrder` ASC [ RunTime:0.003366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856602 ORDER BY `unit` DESC [ RunTime:0.005564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856602 LIMIT 2 [ RunTime:0.008304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856602 ORDER BY `minOrder` ASC [ RunTime:0.002981s ]
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 '25-901-2000-psi/kg/cm2%' OR `brand` LIKE '25-901-2000-psi/kg/cm2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001909s ]
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 '25-901-2000-psi/kg/cm2%' OR `brand` LIKE '25-901-2000-psi/kg/cm2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086184 LIMIT 5 [ RunTime:0.002007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086184 ORDER BY `minOrder` ASC [ RunTime:0.009258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086184 ORDER BY `unit` DESC [ RunTime:0.000489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086184 LIMIT 2 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086184 ORDER BY `minOrder` ASC [ RunTime:0.000685s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-SG-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.008136s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-SG-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001018s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086184 AND `partno` = '25-901-2000-psi/kg/cm2-SG-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025474 [ RunTime:0.007935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086087 LIMIT 5 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086087 ORDER BY `minOrder` ASC [ RunTime:0.002354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086087 ORDER BY `unit` DESC [ RunTime:0.001160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086087 LIMIT 2 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086087 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-SG-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-SG-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007742s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086087 AND `partno` = '25-901-2000-psi/kg/cm2-SG-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857428 [ RunTime:0.004346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085727 LIMIT 5 [ RunTime:0.002223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085727 ORDER BY `minOrder` ASC [ RunTime:0.002481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085727 ORDER BY `unit` DESC [ RunTime:0.003420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085727 LIMIT 2 [ RunTime:0.002908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085727 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-GY40-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-GY40-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002949s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085727 AND `partno` = '25-901-2000-psi/kg/cm2-GY40-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025388 [ RunTime:0.006103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085669 LIMIT 5 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085669 ORDER BY `minOrder` ASC [ RunTime:0.001751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085669 ORDER BY `unit` DESC [ RunTime:0.006195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085669 LIMIT 2 [ RunTime:0.004353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085669 ORDER BY `minOrder` ASC [ RunTime:0.002696s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-GY40-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-GY40-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002283s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085669 AND `partno` = '25-901-2000-psi/kg/cm2-GY40-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240451 [ RunTime:0.000569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085629 LIMIT 5 [ RunTime:0.002299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085629 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085629 ORDER BY `unit` DESC [ RunTime:0.000592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085629 LIMIT 2 [ RunTime:0.002023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085629 ORDER BY `minOrder` ASC [ RunTime:0.005216s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003653s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085629 AND `partno` = '25-901-2000-psi/kg/cm2-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240444 [ RunTime:0.003485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085552 LIMIT 5 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085552 ORDER BY `minOrder` ASC [ RunTime:0.000718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085552 ORDER BY `unit` DESC [ RunTime:0.000503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085552 LIMIT 2 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085552 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000781s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085552 AND `partno` = '25-901-2000-psi/kg/cm2-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857187 [ RunTime:0.008616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085144 LIMIT 5 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085144 ORDER BY `minOrder` ASC [ RunTime:0.000898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085144 ORDER BY `unit` DESC [ RunTime:0.003041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085144 LIMIT 2 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085144 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-DRY-RCP-O2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-DRY-RCP-O2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001045s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085144 AND `partno` = '25-901-2000-psi/kg/cm2-DRY-RCP-O2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856898 [ RunTime:0.008258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084670 LIMIT 5 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084670 ORDER BY `minOrder` ASC [ RunTime:0.002353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084670 ORDER BY `unit` DESC [ RunTime:0.000518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084670 LIMIT 2 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084670 ORDER BY `minOrder` ASC [ RunTime:0.000783s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-DRY-RCP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-DRY-RCP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001458s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084670 AND `partno` = '25-901-2000-psi/kg/cm2-DRY-RCP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856504 [ RunTime:0.006532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083431 LIMIT 5 [ RunTime:0.003998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083431 ORDER BY `minOrder` ASC [ RunTime:0.004809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083431 ORDER BY `unit` DESC [ RunTime:0.000903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083431 LIMIT 2 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083431 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-DRY' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-DRY' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000697s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083431 AND `partno` = '25-901-2000-psi/kg/cm2-DRY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18855793 [ RunTime:0.002560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083313 LIMIT 5 [ RunTime:0.000869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083313 ORDER BY `minOrder` ASC [ RunTime:0.000802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083313 ORDER BY `unit` DESC [ RunTime:0.000504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083313 LIMIT 2 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083313 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-SG-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-SG-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003151s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083313 AND `partno` = '25-901-2000-psi/kg/cm2-SG-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025087 [ RunTime:0.007087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083182 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083182 ORDER BY `minOrder` ASC [ RunTime:0.000851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083182 ORDER BY `unit` DESC [ RunTime:0.008938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083182 LIMIT 2 [ RunTime:0.004965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083182 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-SG' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.007940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-SG' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007449s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083182 AND `partno` = '25-901-2000-psi/kg/cm2-SG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.009265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18861429 [ RunTime:0.002769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64082710 LIMIT 5 [ RunTime:0.005689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082710 ORDER BY `minOrder` ASC [ RunTime:0.002175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64082710 ORDER BY `unit` DESC [ RunTime:0.001689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64082710 LIMIT 2 [ RunTime:0.005380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082710 ORDER BY `minOrder` ASC [ RunTime:0.000815s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-GY40-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-GY40-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002160s ]
SELECT `id` FROM `stock` WHERE `id` <> 64082710 AND `partno` = '25-901-2000-psi/kg/cm2-GY40-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858543 [ RunTime:0.001879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64082617 LIMIT 5 [ RunTime:0.000715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082617 ORDER BY `minOrder` ASC [ RunTime:0.000875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64082617 ORDER BY `unit` DESC [ RunTime:0.000599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64082617 LIMIT 2 [ RunTime:0.002198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082617 ORDER BY `minOrder` ASC [ RunTime:0.005852s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001845s ]
SELECT `id` FROM `stock` WHERE `id` <> 64082617 AND `partno` = '25-901-2000-psi/kg/cm2-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858491 [ RunTime:0.000684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64082584 LIMIT 5 [ RunTime:0.002400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082584 ORDER BY `minOrder` ASC [ RunTime:0.012686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64082584 ORDER BY `unit` DESC [ RunTime:0.002145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64082584 LIMIT 2 [ RunTime:0.001072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082584 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-BT3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-BT3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000800s ]
SELECT `id` FROM `stock` WHERE `id` <> 64082584 AND `partno` = '25-901-2000-psi/kg/cm2-BT3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025632 [ RunTime:0.002108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64082547 LIMIT 5 [ RunTime:0.002715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082547 ORDER BY `minOrder` ASC [ RunTime:0.004964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64082547 ORDER BY `unit` DESC [ RunTime:0.005819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64082547 LIMIT 2 [ RunTime:0.007357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082547 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.016088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001221s ]
SELECT `id` FROM `stock` WHERE `id` <> 64082547 AND `partno` = '25-901-2000-psi/kg/cm2-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240599 [ RunTime:0.001971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64082455 LIMIT 5 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082455 ORDER BY `minOrder` ASC [ RunTime:0.001977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64082455 ORDER BY `unit` DESC [ RunTime:0.002458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64082455 LIMIT 2 [ RunTime:0.002139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082455 ORDER BY `minOrder` ASC [ RunTime:0.000748s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.004483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002740s ]
SELECT `id` FROM `stock` WHERE `id` <> 64082455 AND `partno` = '25-901-2000-psi/kg/cm2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.011829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025503 [ RunTime:0.006210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57279149 LIMIT 5 [ RunTime:0.001939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57279149 ORDER BY `minOrder` ASC [ RunTime:0.005221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57279149 ORDER BY `unit` DESC [ RunTime:0.001434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57279149 LIMIT 2 [ RunTime:0.004122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57279149 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.007567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002036s ]
SELECT `id` FROM `stock` WHERE `id` <> 57279149 AND `partno` = '25-901-2000-psi/kg/cm2-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858004 [ RunTime:0.001416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57276763 LIMIT 5 [ RunTime:0.001671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276763 ORDER BY `minOrder` ASC [ RunTime:0.003885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57276763 ORDER BY `unit` DESC [ RunTime:0.000627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57276763 LIMIT 2 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276763 ORDER BY `minOrder` ASC [ RunTime:0.002382s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-SP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.008507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-SP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001772s ]
SELECT `id` FROM `stock` WHERE `id` <> 57276763 AND `partno` = '25-901-2000-psi/kg/cm2-SP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856603 [ RunTime:0.000801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57276762 LIMIT 5 [ RunTime:0.013243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276762 ORDER BY `minOrder` ASC [ RunTime:0.010562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57276762 ORDER BY `unit` DESC [ RunTime:0.007683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57276762 LIMIT 2 [ RunTime:0.001246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276762 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='25-901-2000-psi/kg/cm2-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2000-psi/kg/cm2-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001866s ]
SELECT `id` FROM `stock` WHERE `id` <> 57276762 AND `partno` = '25-901-2000-psi/kg/cm2-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856602 [ RunTime:0.000700s ]
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 '25-901-2000-psi/kg/cm2%' OR `brand` LIKE '25-901-2000-psi/kg/cm2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001292s ]
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 '25-901-2000-psi/kg/cm2%' OR `brand` LIKE '25-901-2000-psi/kg/cm2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ 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 '25-901-2000-psi/kg/cm2%' OR `brand` LIKE '25-901-2000-psi/kg/cm2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001624s ]
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 '25-901-2000-psi/kg/cm2%' OR `brand` LIKE '25-901-2000-psi/kg/cm2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012546s ]
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 '25-901-2000-psi/kg/cm2%' OR `brand` LIKE '25-901-2000-psi/kg/cm2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008129s ]
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 '25-901-2000-psi/kg/cm2%' OR `brand` LIKE '25-901-2000-psi/kg/cm2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011298s ]
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 '25-901-2000-psi/kg/cm2%' OR `brand` LIKE '25-901-2000-psi/kg/cm2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002862s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25-901-2000-psi/kg/cm2%' OR `brand` LIKE '25-901-2000-psi/kg/cm2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009413s ]