SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001375s ]
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-900-200-psi/kPa%' OR `brand` LIKE '25-900-200-psi/kPa%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026458s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858487 LIMIT 5 [ RunTime:0.015637s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858487 ORDER BY `minOrder` ASC [ RunTime:0.010544s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858487 ORDER BY `unit` DESC [ RunTime:0.024503s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858487 LIMIT 2 [ RunTime:0.006589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858487 ORDER BY `minOrder` ASC [ RunTime:0.008423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857743 LIMIT 5 [ RunTime:0.013865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857743 ORDER BY `minOrder` ASC [ RunTime:0.001810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857743 ORDER BY `unit` DESC [ RunTime:0.024727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857743 LIMIT 2 [ RunTime:0.012654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857743 ORDER BY `minOrder` ASC [ RunTime:0.022057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857727 LIMIT 5 [ RunTime:0.034935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857727 ORDER BY `minOrder` ASC [ RunTime:0.023332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857727 ORDER BY `unit` DESC [ RunTime:0.002008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857727 LIMIT 2 [ RunTime:0.023033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857727 ORDER BY `minOrder` ASC [ RunTime:0.012295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857223 LIMIT 5 [ RunTime:0.018673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857223 ORDER BY `minOrder` ASC [ RunTime:0.030987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857223 ORDER BY `unit` DESC [ RunTime:0.012144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857223 LIMIT 2 [ RunTime:0.013069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857223 ORDER BY `minOrder` ASC [ RunTime:0.023439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857193 LIMIT 5 [ RunTime:0.009534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857193 ORDER BY `minOrder` ASC [ RunTime:0.012291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857193 ORDER BY `unit` DESC [ RunTime:0.009223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857193 LIMIT 2 [ RunTime:0.017110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857193 ORDER BY `minOrder` ASC [ RunTime:0.009852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857184 LIMIT 5 [ RunTime:0.022141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857184 ORDER BY `minOrder` ASC [ RunTime:0.006193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857184 ORDER BY `unit` DESC [ RunTime:0.006556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857184 LIMIT 2 [ RunTime:0.013124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857184 ORDER BY `minOrder` ASC [ RunTime:0.026072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857066 LIMIT 5 [ RunTime:0.030874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857066 ORDER BY `minOrder` ASC [ RunTime:0.007976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857066 ORDER BY `unit` DESC [ RunTime:0.004194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857066 LIMIT 2 [ RunTime:0.004124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857066 ORDER BY `minOrder` ASC [ RunTime:0.002451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240595 LIMIT 5 [ RunTime:0.004735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240595 ORDER BY `minOrder` ASC [ RunTime:0.009148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240595 ORDER BY `unit` DESC [ RunTime:0.004836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240595 LIMIT 2 [ RunTime:0.005775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240595 ORDER BY `minOrder` ASC [ RunTime:0.001194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240400 LIMIT 5 [ RunTime:0.002222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240400 ORDER BY `minOrder` ASC [ RunTime:0.001073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240400 ORDER BY `unit` DESC [ RunTime:0.006844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240400 LIMIT 2 [ RunTime:0.005319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240400 ORDER BY `minOrder` ASC [ RunTime:0.009262s ]
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-900-200-psi/kPa%' OR `brand` LIKE '25-900-200-psi/kPa%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004802s ]
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-900-200-psi/kPa%' OR `brand` LIKE '25-900-200-psi/kPa%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57277781 LIMIT 5 [ RunTime:0.001232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57277781 ORDER BY `minOrder` ASC [ RunTime:0.002192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57277781 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57277781 LIMIT 2 [ RunTime:0.000865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57277781 ORDER BY `minOrder` ASC [ RunTime:0.003331s ]
select * from pdf where partno='25-900-200-psi/kPa-GY40-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001594s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-900-200-psi/kPa-GY40-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000788s ]
SELECT `id` FROM `stock` WHERE `id` <> 57277781 AND `partno` = '25-900-200-psi/kPa-GY40-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857223 [ RunTime:0.003739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57277690 LIMIT 5 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57277690 ORDER BY `minOrder` ASC [ RunTime:0.006075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57277690 ORDER BY `unit` DESC [ RunTime:0.002187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57277690 LIMIT 2 [ RunTime:0.001847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57277690 ORDER BY `minOrder` ASC [ RunTime:0.000621s ]
select * from pdf where partno='25-900-200-psi/kPa-GY40-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-900-200-psi/kPa-GY40-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000407s ]
SELECT `id` FROM `stock` WHERE `id` <> 57277690 AND `partno` = '25-900-200-psi/kPa-GY40-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857193 [ RunTime:0.002313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57277660 LIMIT 5 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57277660 ORDER BY `minOrder` ASC [ RunTime:0.002777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57277660 ORDER BY `unit` DESC [ RunTime:0.000796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57277660 LIMIT 2 [ RunTime:0.003662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57277660 ORDER BY `minOrder` ASC [ RunTime:0.001765s ]
select * from pdf where partno='25-900-200-psi/kPa-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-900-200-psi/kPa-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000404s ]
SELECT `id` FROM `stock` WHERE `id` <> 57277660 AND `partno` = '25-900-200-psi/kPa-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857184 [ RunTime:0.001948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57277572 LIMIT 5 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57277572 ORDER BY `minOrder` ASC [ RunTime:0.001181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57277572 ORDER BY `unit` DESC [ RunTime:0.000297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57277572 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57277572 ORDER BY `minOrder` ASC [ RunTime:0.001680s ]
select * from pdf where partno='25-900-200-psi/kPa-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-900-200-psi/kPa-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000385s ]
SELECT `id` FROM `stock` WHERE `id` <> 57277572 AND `partno` = '25-900-200-psi/kPa-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240400 [ RunTime:0.001907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57274422 LIMIT 5 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57274422 ORDER BY `minOrder` ASC [ RunTime:0.001354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57274422 ORDER BY `unit` DESC [ RunTime:0.000295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57274422 LIMIT 2 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57274422 ORDER BY `minOrder` ASC [ RunTime:0.001682s ]
select * from pdf where partno='25-900-200-psi/kPa-GY40-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-900-200-psi/kPa-GY40-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000413s ]
SELECT `id` FROM `stock` WHERE `id` <> 57274422 AND `partno` = '25-900-200-psi/kPa-GY40-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858487 [ RunTime:0.002042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57274291 LIMIT 5 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57274291 ORDER BY `minOrder` ASC [ RunTime:0.001064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57274291 ORDER BY `unit` DESC [ RunTime:0.000304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57274291 LIMIT 2 [ RunTime:0.000523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57274291 ORDER BY `minOrder` ASC [ RunTime:0.001621s ]
select * from pdf where partno='25-900-200-psi/kPa-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-900-200-psi/kPa-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000382s ]
SELECT `id` FROM `stock` WHERE `id` <> 57274291 AND `partno` = '25-900-200-psi/kPa-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857743 [ RunTime:0.001887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57274277 LIMIT 5 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57274277 ORDER BY `minOrder` ASC [ RunTime:0.001003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57274277 ORDER BY `unit` DESC [ RunTime:0.000300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57274277 LIMIT 2 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57274277 ORDER BY `minOrder` ASC [ RunTime:0.001708s ]
select * from pdf where partno='25-900-200-psi/kPa-BT3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-900-200-psi/kPa-BT3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000378s ]
SELECT `id` FROM `stock` WHERE `id` <> 57274277 AND `partno` = '25-900-200-psi/kPa-BT3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240595 [ RunTime:0.002036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57274249 LIMIT 5 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57274249 ORDER BY `minOrder` ASC [ RunTime:0.001017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57274249 ORDER BY `unit` DESC [ RunTime:0.000289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57274249 LIMIT 2 [ RunTime:0.000525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57274249 ORDER BY `minOrder` ASC [ RunTime:0.001535s ]
select * from pdf where partno='25-900-200-psi/kPa-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-900-200-psi/kPa-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000405s ]
SELECT `id` FROM `stock` WHERE `id` <> 57274249 AND `partno` = '25-900-200-psi/kPa-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857727 [ RunTime:0.001876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57274121 LIMIT 5 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57274121 ORDER BY `minOrder` ASC [ RunTime:0.001058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57274121 ORDER BY `unit` DESC [ RunTime:0.000391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57274121 LIMIT 2 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57274121 ORDER BY `minOrder` ASC [ RunTime:0.001926s ]
select * from pdf where partno='25-900-200-psi/kPa' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-900-200-psi/kPa' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000399s ]
SELECT `id` FROM `stock` WHERE `id` <> 57274121 AND `partno` = '25-900-200-psi/kPa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857066 [ RunTime:0.002048s ]
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-900-200-psi/kPa%' OR `brand` LIKE '25-900-200-psi/kPa%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000911s ]
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-900-200-psi/kPa%' OR `brand` LIKE '25-900-200-psi/kPa%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000514s ]
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-900-200-psi/kPa%' OR `brand` LIKE '25-900-200-psi/kPa%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000501s ]
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-900-200-psi/kPa%' OR `brand` LIKE '25-900-200-psi/kPa%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000490s ]
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-900-200-psi/kPa%' OR `brand` LIKE '25-900-200-psi/kPa%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000490s ]
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-900-200-psi/kPa%' OR `brand` LIKE '25-900-200-psi/kPa%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000494s ]
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-900-200-psi/kPa%' OR `brand` LIKE '25-900-200-psi/kPa%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000575s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25-900-200-psi/kPa%' OR `brand` LIKE '25-900-200-psi/kPa%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000614s ]