SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002004s ]
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-911-15-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-15-psi/kg/cm2-SSRF%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022342s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860815 LIMIT 5 [ RunTime:0.025351s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.019396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860815 ORDER BY `minOrder` ASC [ RunTime:0.032305s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860815 ORDER BY `unit` DESC [ RunTime:0.021181s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860815 LIMIT 2 [ RunTime:0.026510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860815 ORDER BY `minOrder` ASC [ RunTime:0.007337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860809 LIMIT 5 [ RunTime:0.030609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860809 ORDER BY `minOrder` ASC [ RunTime:0.017117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860809 ORDER BY `unit` DESC [ RunTime:0.049654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860809 LIMIT 2 [ RunTime:0.041368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860809 ORDER BY `minOrder` ASC [ RunTime:0.017646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860440 LIMIT 5 [ RunTime:0.042866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860440 ORDER BY `minOrder` ASC [ RunTime:0.052201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860440 ORDER BY `unit` DESC [ RunTime:0.038228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860440 LIMIT 2 [ RunTime:0.057903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860440 ORDER BY `minOrder` ASC [ RunTime:0.013206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860058 LIMIT 5 [ RunTime:0.032945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860058 ORDER BY `minOrder` ASC [ RunTime:0.056941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860058 ORDER BY `unit` DESC [ RunTime:0.024680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860058 LIMIT 2 [ RunTime:0.042541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860058 ORDER BY `minOrder` ASC [ RunTime:0.008794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860056 LIMIT 5 [ RunTime:0.024463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860056 ORDER BY `minOrder` ASC [ RunTime:0.079686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860056 ORDER BY `unit` DESC [ RunTime:0.057418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860056 LIMIT 2 [ RunTime:0.095280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860056 ORDER BY `minOrder` ASC [ RunTime:0.006941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859556 LIMIT 5 [ RunTime:0.033964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859556 ORDER BY `minOrder` ASC [ RunTime:0.019738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859556 ORDER BY `unit` DESC [ RunTime:0.067145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859556 LIMIT 2 [ RunTime:0.020924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859556 ORDER BY `minOrder` ASC [ RunTime:0.006749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859554 LIMIT 5 [ RunTime:0.046200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859554 ORDER BY `minOrder` ASC [ RunTime:0.034842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859554 ORDER BY `unit` DESC [ RunTime:0.033115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859554 LIMIT 2 [ RunTime:0.007067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859554 ORDER BY `minOrder` ASC [ RunTime:0.006700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025968 LIMIT 5 [ RunTime:0.039371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025968 ORDER BY `minOrder` ASC [ RunTime:0.049541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025968 ORDER BY `unit` DESC [ RunTime:0.012042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025968 LIMIT 2 [ RunTime:0.009866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025968 ORDER BY `minOrder` ASC [ RunTime:0.006465s ]
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-911-15-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-15-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024118s ]
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-911-15-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-15-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37476313 LIMIT 5 [ RunTime:0.022098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476313 ORDER BY `minOrder` ASC [ RunTime:0.003537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37476313 ORDER BY `unit` DESC [ RunTime:0.016014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37476313 LIMIT 2 [ RunTime:0.018082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476313 ORDER BY `minOrder` ASC [ RunTime:0.006754s ]
select * from pdf where partno='40-911-15-psi/kg/cm2-SSRF-MIP-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.012991s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.013921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kg/cm2-SSRF-MIP-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007711s ]
SELECT `id` FROM `stock` WHERE `id` <> 37476313 AND `partno` = '40-911-15-psi/kg/cm2-SSRF-MIP-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.015841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860815 [ RunTime:0.006661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37476303 LIMIT 5 [ RunTime:0.016960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476303 ORDER BY `minOrder` ASC [ RunTime:0.020319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37476303 ORDER BY `unit` DESC [ RunTime:0.003115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37476303 LIMIT 2 [ RunTime:0.002618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37476303 ORDER BY `minOrder` ASC [ RunTime:0.008200s ]
select * from pdf where partno='40-911-15-psi/kg/cm2-SSRF-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.010134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kg/cm2-SSRF-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005594s ]
SELECT `id` FROM `stock` WHERE `id` <> 37476303 AND `partno` = '40-911-15-psi/kg/cm2-SSRF-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.006852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860809 [ RunTime:0.011241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475921 LIMIT 5 [ RunTime:0.002263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475921 ORDER BY `minOrder` ASC [ RunTime:0.008487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475921 ORDER BY `unit` DESC [ RunTime:0.002203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475921 LIMIT 2 [ RunTime:0.011893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475921 ORDER BY `minOrder` ASC [ RunTime:0.006101s ]
select * from pdf where partno='40-911-15-psi/kg/cm2-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kg/cm2-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000989s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475921 AND `partno` = '40-911-15-psi/kg/cm2-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025968 [ RunTime:0.000493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475888 LIMIT 5 [ RunTime:0.002953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475888 ORDER BY `minOrder` ASC [ RunTime:0.002097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475888 ORDER BY `unit` DESC [ RunTime:0.000610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475888 LIMIT 2 [ RunTime:0.020295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475888 ORDER BY `minOrder` ASC [ RunTime:0.003600s ]
select * from pdf where partno='40-911-15-psi/kg/cm2-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kg/cm2-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003566s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475888 AND `partno` = '40-911-15-psi/kg/cm2-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860440 [ RunTime:0.000512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475462 LIMIT 5 [ RunTime:0.003414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475462 ORDER BY `minOrder` ASC [ RunTime:0.000935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475462 ORDER BY `unit` DESC [ RunTime:0.006668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475462 LIMIT 2 [ RunTime:0.006826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475462 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='40-911-15-psi/kg/cm2-SSRF-MIP-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kg/cm2-SSRF-MIP-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000484s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475462 AND `partno` = '40-911-15-psi/kg/cm2-SSRF-MIP-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860058 [ RunTime:0.004838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475459 LIMIT 5 [ RunTime:0.002900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475459 ORDER BY `minOrder` ASC [ RunTime:0.001302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475459 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475459 LIMIT 2 [ RunTime:0.000437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475459 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
select * from pdf where partno='40-911-15-psi/kg/cm2-SSRF-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kg/cm2-SSRF-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000353s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475459 AND `partno` = '40-911-15-psi/kg/cm2-SSRF-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860056 [ RunTime:0.005981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475009 LIMIT 5 [ RunTime:0.007074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475009 ORDER BY `minOrder` ASC [ RunTime:0.002129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475009 ORDER BY `unit` DESC [ RunTime:0.001969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475009 LIMIT 2 [ RunTime:0.006283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475009 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
select * from pdf where partno='40-911-15-psi/kg/cm2-SSRF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.005392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kg/cm2-SSRF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001963s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475009 AND `partno` = '40-911-15-psi/kg/cm2-SSRF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.012146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859556 [ RunTime:0.006079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37474999 LIMIT 5 [ RunTime:0.001482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474999 ORDER BY `minOrder` ASC [ RunTime:0.003888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37474999 ORDER BY `unit` DESC [ RunTime:0.007994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37474999 LIMIT 2 [ RunTime:0.009567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37474999 ORDER BY `minOrder` ASC [ RunTime:0.003514s ]
select * from pdf where partno='40-911-15-psi/kg/cm2-SSRF' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kg/cm2-SSRF' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011012s ]
SELECT `id` FROM `stock` WHERE `id` <> 37474999 AND `partno` = '40-911-15-psi/kg/cm2-SSRF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.020938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859554 [ RunTime:0.004798s ]
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-911-15-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-15-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008443s ]
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-911-15-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-15-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013289s ]
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-911-15-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-15-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007418s ]
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-911-15-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-15-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010561s ]
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-911-15-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-15-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010101s ]
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-911-15-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-15-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002046s ]
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-911-15-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-15-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005248s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40-911-15-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-15-psi/kg/cm2-SSRF%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015962s ]