SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001660s ]
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-30-psi/bar%' OR `brand` LIKE '25-901-30-psi/bar%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017409s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860660 LIMIT 5 [ RunTime:0.005983s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860660 ORDER BY `minOrder` ASC [ RunTime:0.007412s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.019564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860660 ORDER BY `unit` DESC [ RunTime:0.002396s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860660 LIMIT 2 [ RunTime:0.007895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860660 ORDER BY `minOrder` ASC [ RunTime:0.028280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859958 LIMIT 5 [ RunTime:0.036121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859958 ORDER BY `minOrder` ASC [ RunTime:0.016943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859958 ORDER BY `unit` DESC [ RunTime:0.015099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859958 LIMIT 2 [ RunTime:0.021135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859958 ORDER BY `minOrder` ASC [ RunTime:0.064960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857972 LIMIT 5 [ RunTime:0.046281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857972 ORDER BY `minOrder` ASC [ RunTime:0.082544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857972 ORDER BY `unit` DESC [ RunTime:0.059913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857972 LIMIT 2 [ RunTime:0.069311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857972 ORDER BY `minOrder` ASC [ RunTime:0.017798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857350 LIMIT 5 [ RunTime:0.124803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857350 ORDER BY `minOrder` ASC [ RunTime:0.065758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857350 ORDER BY `unit` DESC [ RunTime:0.088143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857350 LIMIT 2 [ RunTime:0.033890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857350 ORDER BY `minOrder` ASC [ RunTime:0.015334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857314 LIMIT 5 [ RunTime:0.024654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857314 ORDER BY `minOrder` ASC [ RunTime:0.054667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857314 ORDER BY `unit` DESC [ RunTime:0.022352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857314 LIMIT 2 [ RunTime:0.063608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857314 ORDER BY `minOrder` ASC [ RunTime:0.015190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857167 LIMIT 5 [ RunTime:0.014509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857167 ORDER BY `minOrder` ASC [ RunTime:0.058851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857167 ORDER BY `unit` DESC [ RunTime:0.031210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857167 LIMIT 2 [ RunTime:0.042531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857167 ORDER BY `minOrder` ASC [ RunTime:0.009302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857146 LIMIT 5 [ RunTime:0.036700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857146 ORDER BY `minOrder` ASC [ RunTime:0.011692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857146 ORDER BY `unit` DESC [ RunTime:0.012878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857146 LIMIT 2 [ RunTime:0.026323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857146 ORDER BY `minOrder` ASC [ RunTime:0.013365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857115 LIMIT 5 [ RunTime:0.009576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857115 ORDER BY `minOrder` ASC [ RunTime:0.010102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857115 ORDER BY `unit` DESC [ RunTime:0.020535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857115 LIMIT 2 [ RunTime:0.022902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857115 ORDER BY `minOrder` ASC [ RunTime:0.000895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857061 LIMIT 5 [ RunTime:0.001632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857061 ORDER BY `minOrder` ASC [ RunTime:0.020018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857061 ORDER BY `unit` DESC [ RunTime:0.002757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857061 LIMIT 2 [ RunTime:0.001521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857061 ORDER BY `minOrder` ASC [ RunTime:0.001808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857044 LIMIT 5 [ RunTime:0.003137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857044 ORDER BY `minOrder` ASC [ RunTime:0.000839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857044 ORDER BY `unit` DESC [ RunTime:0.000484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857044 LIMIT 2 [ RunTime:0.001399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857044 ORDER BY `minOrder` ASC [ RunTime:0.000538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856862 LIMIT 5 [ RunTime:0.003174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856862 ORDER BY `minOrder` ASC [ RunTime:0.011288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856862 ORDER BY `unit` DESC [ RunTime:0.001013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856862 LIMIT 2 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856862 ORDER BY `minOrder` ASC [ RunTime:0.002520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856527 LIMIT 5 [ RunTime:0.007156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856527 ORDER BY `minOrder` ASC [ RunTime:0.002992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856527 ORDER BY `unit` DESC [ RunTime:0.001004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856527 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856527 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856526 LIMIT 5 [ RunTime:0.000537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856526 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856526 ORDER BY `unit` DESC [ RunTime:0.000490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856526 LIMIT 2 [ RunTime:0.000691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856526 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856439 LIMIT 5 [ RunTime:0.000717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856439 ORDER BY `minOrder` ASC [ RunTime:0.002499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856439 ORDER BY `unit` DESC [ RunTime:0.003490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856439 LIMIT 2 [ RunTime:0.005384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856439 ORDER BY `minOrder` ASC [ RunTime:0.002247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026058 LIMIT 5 [ RunTime:0.001054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026058 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17026058 ORDER BY `unit` DESC [ RunTime:0.000390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17026058 LIMIT 2 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026058 ORDER BY `minOrder` ASC [ RunTime:0.002523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025330 LIMIT 5 [ RunTime:0.007216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025330 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025330 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025330 LIMIT 2 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025330 ORDER BY `minOrder` ASC [ RunTime:0.006574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025201 LIMIT 5 [ RunTime:0.008293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025201 ORDER BY `minOrder` ASC [ RunTime:0.006122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025201 ORDER BY `unit` DESC [ RunTime:0.004919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025201 LIMIT 2 [ RunTime:0.007762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025201 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240375 LIMIT 5 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240375 ORDER BY `minOrder` ASC [ RunTime:0.001578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240375 ORDER BY `unit` DESC [ RunTime:0.000554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240375 LIMIT 2 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240375 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240252 LIMIT 5 [ RunTime:0.000812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240252 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240252 ORDER BY `unit` DESC [ RunTime:0.013615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240252 LIMIT 2 [ RunTime:0.006825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240252 ORDER BY `minOrder` ASC [ RunTime:0.005097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240244 LIMIT 5 [ RunTime:0.013376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240244 ORDER BY `minOrder` ASC [ RunTime:0.002743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240244 ORDER BY `unit` DESC [ RunTime:0.002210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240244 LIMIT 2 [ RunTime:0.003203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240244 ORDER BY `minOrder` ASC [ RunTime:0.003391s ]
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-30-psi/bar%' OR `brand` LIKE '25-901-30-psi/bar%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001188s ]
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-30-psi/bar%' OR `brand` LIKE '25-901-30-psi/bar%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085948 LIMIT 5 [ RunTime:0.002616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085948 ORDER BY `minOrder` ASC [ RunTime:0.004335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085948 ORDER BY `unit` DESC [ RunTime:0.000964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085948 LIMIT 2 [ RunTime:0.000431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085948 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='25-901-30-psi/bar-SG-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.004534s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-SG-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001273s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085948 AND `partno` = '25-901-30-psi/bar-SG-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857350 [ RunTime:0.003177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085882 LIMIT 5 [ RunTime:0.002601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085882 ORDER BY `minOrder` ASC [ RunTime:0.002860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085882 ORDER BY `unit` DESC [ RunTime:0.002319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085882 LIMIT 2 [ RunTime:0.001747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085882 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='25-901-30-psi/bar-SG-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-SG-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017055s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085882 AND `partno` = '25-901-30-psi/bar-SG-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857314 [ RunTime:0.011245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085503 LIMIT 5 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085503 ORDER BY `minOrder` ASC [ RunTime:0.000934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085503 ORDER BY `unit` DESC [ RunTime:0.005841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085503 LIMIT 2 [ RunTime:0.010671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085503 ORDER BY `minOrder` ASC [ RunTime:0.001380s ]
select * from pdf where partno='25-901-30-psi/bar-GY40-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-GY40-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001168s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085503 AND `partno` = '25-901-30-psi/bar-GY40-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857167 [ RunTime:0.008583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085439 LIMIT 5 [ RunTime:0.000840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085439 ORDER BY `minOrder` ASC [ RunTime:0.003741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085439 ORDER BY `unit` DESC [ RunTime:0.006938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085439 LIMIT 2 [ RunTime:0.000926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085439 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='25-901-30-psi/bar-GY40-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-GY40-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000856s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085439 AND `partno` = '25-901-30-psi/bar-GY40-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.017345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857146 [ RunTime:0.001896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085404 LIMIT 5 [ RunTime:0.014996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085404 ORDER BY `minOrder` ASC [ RunTime:0.010951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085404 ORDER BY `unit` DESC [ RunTime:0.020926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085404 LIMIT 2 [ RunTime:0.014250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085404 ORDER BY `minOrder` ASC [ RunTime:0.013778s ]
select * from pdf where partno='25-901-30-psi/bar-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.015421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000931s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085404 AND `partno` = '25-901-30-psi/bar-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.026806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240375 [ RunTime:0.008628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085381 LIMIT 5 [ RunTime:0.015170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085381 ORDER BY `minOrder` ASC [ RunTime:0.037327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085381 ORDER BY `unit` DESC [ RunTime:0.025046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085381 LIMIT 2 [ RunTime:0.041096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085381 ORDER BY `minOrder` ASC [ RunTime:0.042105s ]
select * from pdf where partno='25-901-30-psi/bar-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.024204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015439s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085381 AND `partno` = '25-901-30-psi/bar-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857044 [ RunTime:0.002507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083016 LIMIT 5 [ RunTime:0.004469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083016 ORDER BY `minOrder` ASC [ RunTime:0.030606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083016 ORDER BY `unit` DESC [ RunTime:0.024113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083016 LIMIT 2 [ RunTime:0.056146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083016 ORDER BY `minOrder` ASC [ RunTime:0.009308s ]
select * from pdf where partno='25-901-30-psi/bar-SG-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.007802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-SG-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019229s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083016 AND `partno` = '25-901-30-psi/bar-SG-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.023849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860660 [ RunTime:0.017016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64082923 LIMIT 5 [ RunTime:0.014208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082923 ORDER BY `minOrder` ASC [ RunTime:0.009528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64082923 ORDER BY `unit` DESC [ RunTime:0.032102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64082923 LIMIT 2 [ RunTime:0.018700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082923 ORDER BY `minOrder` ASC [ RunTime:0.018479s ]
select * from pdf where partno='25-901-30-psi/bar-SG' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.052502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-SG' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.029896s ]
SELECT `id` FROM `stock` WHERE `id` <> 64082923 AND `partno` = '25-901-30-psi/bar-SG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.027211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859958 [ RunTime:0.028361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64082404 LIMIT 5 [ RunTime:0.012773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082404 ORDER BY `minOrder` ASC [ RunTime:0.059531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64082404 ORDER BY `unit` DESC [ RunTime:0.024673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64082404 LIMIT 2 [ RunTime:0.020184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082404 ORDER BY `minOrder` ASC [ RunTime:0.009912s ]
select * from pdf where partno='25-901-30-psi/bar-GY40-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.025754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-GY40-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.028172s ]
SELECT `id` FROM `stock` WHERE `id` <> 64082404 AND `partno` = '25-901-30-psi/bar-GY40-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.016017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857115 [ RunTime:0.026151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64082298 LIMIT 5 [ RunTime:0.028329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082298 ORDER BY `minOrder` ASC [ RunTime:0.035534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64082298 ORDER BY `unit` DESC [ RunTime:0.025272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64082298 LIMIT 2 [ RunTime:0.016733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082298 ORDER BY `minOrder` ASC [ RunTime:0.027560s ]
select * from pdf where partno='25-901-30-psi/bar-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.014137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006800s ]
SELECT `id` FROM `stock` WHERE `id` <> 64082298 AND `partno` = '25-901-30-psi/bar-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857061 [ RunTime:0.018895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64082279 LIMIT 5 [ RunTime:0.019280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082279 ORDER BY `minOrder` ASC [ RunTime:0.037783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64082279 ORDER BY `unit` DESC [ RunTime:0.033118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64082279 LIMIT 2 [ RunTime:0.035528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082279 ORDER BY `minOrder` ASC [ RunTime:0.002100s ]
select * from pdf where partno='25-901-30-psi/bar-BT3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.027164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-BT3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014751s ]
SELECT `id` FROM `stock` WHERE `id` <> 64082279 AND `partno` = '25-901-30-psi/bar-BT3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.012409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856439 [ RunTime:0.013165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64082230 LIMIT 5 [ RunTime:0.019025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082230 ORDER BY `minOrder` ASC [ RunTime:0.012281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64082230 ORDER BY `unit` DESC [ RunTime:0.009939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64082230 LIMIT 2 [ RunTime:0.040404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082230 ORDER BY `minOrder` ASC [ RunTime:0.020562s ]
select * from pdf where partno='25-901-30-psi/bar-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.021968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003464s ]
SELECT `id` FROM `stock` WHERE `id` <> 64082230 AND `partno` = '25-901-30-psi/bar-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.029338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240252 [ RunTime:0.021021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64082200 LIMIT 5 [ RunTime:0.015751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082200 ORDER BY `minOrder` ASC [ RunTime:0.011208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64082200 ORDER BY `unit` DESC [ RunTime:0.018638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64082200 LIMIT 2 [ RunTime:0.021621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082200 ORDER BY `minOrder` ASC [ RunTime:0.010820s ]
select * from pdf where partno='25-901-30-psi/bar' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.009238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005443s ]
SELECT `id` FROM `stock` WHERE `id` <> 64082200 AND `partno` = '25-901-30-psi/bar' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.041441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240244 [ RunTime:0.013656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085057 LIMIT 5 [ RunTime:0.035973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085057 ORDER BY `minOrder` ASC [ RunTime:0.013005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085057 ORDER BY `unit` DESC [ RunTime:0.003467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085057 LIMIT 2 [ RunTime:0.013138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085057 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='25-901-30-psi/bar-DRY-RCP-O2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-DRY-RCP-O2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000304s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085057 AND `partno` = '25-901-30-psi/bar-DRY-RCP-O2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856862 [ RunTime:0.003303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084794 LIMIT 5 [ RunTime:0.025262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084794 ORDER BY `minOrder` ASC [ RunTime:0.035293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084794 ORDER BY `unit` DESC [ RunTime:0.043921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084794 LIMIT 2 [ RunTime:0.001172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084794 ORDER BY `minOrder` ASC [ RunTime:0.019029s ]
select * from pdf where partno='25-901-30-psi/bar-DRY-O2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.022786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-DRY-O2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008115s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084794 AND `partno` = '25-901-30-psi/bar-DRY-O2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.021181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025330 [ RunTime:0.010396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084565 LIMIT 5 [ RunTime:0.007171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084565 ORDER BY `minOrder` ASC [ RunTime:0.038461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084565 ORDER BY `unit` DESC [ RunTime:0.028445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084565 LIMIT 2 [ RunTime:0.040169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084565 ORDER BY `minOrder` ASC [ RunTime:0.015480s ]
select * from pdf where partno='25-901-30-psi/bar-DRY-RCP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.021398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-DRY-RCP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013898s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084565 AND `partno` = '25-901-30-psi/bar-DRY-RCP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.022445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025201 [ RunTime:0.026658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64082091 LIMIT 5 [ RunTime:0.062321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082091 ORDER BY `minOrder` ASC [ RunTime:0.034274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64082091 ORDER BY `unit` DESC [ RunTime:0.019973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64082091 LIMIT 2 [ RunTime:0.047638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64082091 ORDER BY `minOrder` ASC [ RunTime:0.011891s ]
select * from pdf where partno='25-901-30-psi/bar-DRY' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.025075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-DRY' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031703s ]
SELECT `id` FROM `stock` WHERE `id` <> 64082091 AND `partno` = '25-901-30-psi/bar-DRY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.053664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026058 [ RunTime:0.018834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57279092 LIMIT 5 [ RunTime:0.005241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57279092 ORDER BY `minOrder` ASC [ RunTime:0.029450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57279092 ORDER BY `unit` DESC [ RunTime:0.007194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57279092 LIMIT 2 [ RunTime:0.017602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57279092 ORDER BY `minOrder` ASC [ RunTime:0.010281s ]
select * from pdf where partno='25-901-30-psi/bar-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.051725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013706s ]
SELECT `id` FROM `stock` WHERE `id` <> 57279092 AND `partno` = '25-901-30-psi/bar-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.011855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857972 [ RunTime:0.040858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57276635 LIMIT 5 [ RunTime:0.003007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276635 ORDER BY `minOrder` ASC [ RunTime:0.004709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57276635 ORDER BY `unit` DESC [ RunTime:0.004827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57276635 LIMIT 2 [ RunTime:0.016510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276635 ORDER BY `minOrder` ASC [ RunTime:0.006147s ]
select * from pdf where partno='25-901-30-psi/bar-SP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.017727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-SP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013247s ]
SELECT `id` FROM `stock` WHERE `id` <> 57276635 AND `partno` = '25-901-30-psi/bar-SP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.038554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856527 [ RunTime:0.025490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57276632 LIMIT 5 [ RunTime:0.025291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276632 ORDER BY `minOrder` ASC [ RunTime:0.016513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57276632 ORDER BY `unit` DESC [ RunTime:0.030723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57276632 LIMIT 2 [ RunTime:0.042921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276632 ORDER BY `minOrder` ASC [ RunTime:0.015142s ]
select * from pdf where partno='25-901-30-psi/bar-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.006746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-30-psi/bar-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.037779s ]
SELECT `id` FROM `stock` WHERE `id` <> 57276632 AND `partno` = '25-901-30-psi/bar-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.042463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856526 [ RunTime:0.020171s ]
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-30-psi/bar%' OR `brand` LIKE '25-901-30-psi/bar%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021739s ]
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-30-psi/bar%' OR `brand` LIKE '25-901-30-psi/bar%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050114s ]
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-30-psi/bar%' OR `brand` LIKE '25-901-30-psi/bar%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010217s ]
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-30-psi/bar%' OR `brand` LIKE '25-901-30-psi/bar%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015926s ]
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-30-psi/bar%' OR `brand` LIKE '25-901-30-psi/bar%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016942s ]
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-30-psi/bar%' OR `brand` LIKE '25-901-30-psi/bar%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014547s ]
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-30-psi/bar%' OR `brand` LIKE '25-901-30-psi/bar%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004016s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25-901-30-psi/bar%' OR `brand` LIKE '25-901-30-psi/bar%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.023414s ]