SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004671s ]
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-60-psi/kPa-SSRF%' OR `brand` LIKE '40-911-60-psi/kPa-SSRF%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041761s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.010026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857564 LIMIT 5 [ RunTime:0.057156s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.033915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857564 ORDER BY `minOrder` ASC [ RunTime:0.047026s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857564 ORDER BY `unit` DESC [ RunTime:0.060513s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857564 LIMIT 2 [ RunTime:0.043525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857564 ORDER BY `minOrder` ASC [ RunTime:0.050888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856745 LIMIT 5 [ RunTime:0.028013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856745 ORDER BY `minOrder` ASC [ RunTime:0.037776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856745 ORDER BY `unit` DESC [ RunTime:0.055039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856745 LIMIT 2 [ RunTime:0.059221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856745 ORDER BY `minOrder` ASC [ RunTime:0.036117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856726 LIMIT 5 [ RunTime:0.054411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856726 ORDER BY `minOrder` ASC [ RunTime:0.033853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18856726 ORDER BY `unit` DESC [ RunTime:0.042220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18856726 LIMIT 2 [ RunTime:0.035769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18856726 ORDER BY `minOrder` ASC [ RunTime:0.032760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240504 LIMIT 5 [ RunTime:0.023098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240504 ORDER BY `minOrder` ASC [ RunTime:0.048384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240504 ORDER BY `unit` DESC [ RunTime:0.060758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240504 LIMIT 2 [ RunTime:0.029115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240504 ORDER BY `minOrder` ASC [ RunTime:0.035980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858147 LIMIT 5 [ RunTime:0.022285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858147 ORDER BY `minOrder` ASC [ RunTime:0.021023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858147 ORDER BY `unit` DESC [ RunTime:0.032683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858147 LIMIT 2 [ RunTime:0.080976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858147 ORDER BY `minOrder` ASC [ RunTime:0.032722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858132 LIMIT 5 [ RunTime:0.029383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858132 ORDER BY `minOrder` ASC [ RunTime:0.049606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858132 ORDER BY `unit` DESC [ RunTime:0.055770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858132 LIMIT 2 [ RunTime:0.085057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858132 ORDER BY `minOrder` ASC [ RunTime:0.032193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857022 LIMIT 5 [ RunTime:0.031716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857022 ORDER BY `minOrder` ASC [ RunTime:0.073414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857022 ORDER BY `unit` DESC [ RunTime:0.028361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857022 LIMIT 2 [ RunTime:0.056934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857022 ORDER BY `minOrder` ASC [ RunTime:0.015715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857012 LIMIT 5 [ RunTime:0.053203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857012 ORDER BY `minOrder` ASC [ RunTime:0.039262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18857012 ORDER BY `unit` DESC [ RunTime:0.036880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18857012 LIMIT 2 [ RunTime:0.037298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18857012 ORDER BY `minOrder` ASC [ RunTime:0.057053s ]
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-60-psi/kPa-SSRF%' OR `brand` LIKE '40-911-60-psi/kPa-SSRF%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034402s ]
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-60-psi/kPa-SSRF%' OR `brand` LIKE '40-911-60-psi/kPa-SSRF%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37473037 LIMIT 5 [ RunTime:0.037597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37473037 ORDER BY `minOrder` ASC [ RunTime:0.029314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37473037 ORDER BY `unit` DESC [ RunTime:0.014933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37473037 LIMIT 2 [ RunTime:0.009349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37473037 ORDER BY `minOrder` ASC [ RunTime:0.018249s ]
select * from pdf where partno='40-911-60-psi/kPa-SSRF-MIP-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.031674s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001584s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-60-psi/kPa-SSRF-MIP-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.032352s ]
SELECT `id` FROM `stock` WHERE `id` <> 37473037 AND `partno` = '40-911-60-psi/kPa-SSRF-MIP-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.021551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858147 [ RunTime:0.055775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37472996 LIMIT 5 [ RunTime:0.014723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472996 ORDER BY `minOrder` ASC [ RunTime:0.008414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37472996 ORDER BY `unit` DESC [ RunTime:0.018212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37472996 LIMIT 2 [ RunTime:0.004091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472996 ORDER BY `minOrder` ASC [ RunTime:0.025228s ]
select * from pdf where partno='40-911-60-psi/kPa-SSRF-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.026781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-60-psi/kPa-SSRF-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016576s ]
SELECT `id` FROM `stock` WHERE `id` <> 37472996 AND `partno` = '40-911-60-psi/kPa-SSRF-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858132 [ RunTime:0.001249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37472120 LIMIT 5 [ RunTime:0.000936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472120 ORDER BY `minOrder` ASC [ RunTime:0.009278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37472120 ORDER BY `unit` DESC [ RunTime:0.020630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37472120 LIMIT 2 [ RunTime:0.003205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472120 ORDER BY `minOrder` ASC [ RunTime:0.004165s ]
select * from pdf where partno='40-911-60-psi/kPa-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.016616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-60-psi/kPa-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.032814s ]
SELECT `id` FROM `stock` WHERE `id` <> 37472120 AND `partno` = '40-911-60-psi/kPa-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.006018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857564 [ RunTime:0.018661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37472002 LIMIT 5 [ RunTime:0.029275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472002 ORDER BY `minOrder` ASC [ RunTime:0.027577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37472002 ORDER BY `unit` DESC [ RunTime:0.032317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37472002 LIMIT 2 [ RunTime:0.021086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37472002 ORDER BY `minOrder` ASC [ RunTime:0.021525s ]
select * from pdf where partno='40-911-60-psi/kPa-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.016996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-60-psi/kPa-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031062s ]
SELECT `id` FROM `stock` WHERE `id` <> 37472002 AND `partno` = '40-911-60-psi/kPa-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.040907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240504 [ RunTime:0.029039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37471020 LIMIT 5 [ RunTime:0.009174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471020 ORDER BY `minOrder` ASC [ RunTime:0.024138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37471020 ORDER BY `unit` DESC [ RunTime:0.013147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37471020 LIMIT 2 [ RunTime:0.013971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37471020 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
select * from pdf where partno='40-911-60-psi/kPa-SSRF-MIP-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.027775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-60-psi/kPa-SSRF-MIP-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018012s ]
SELECT `id` FROM `stock` WHERE `id` <> 37471020 AND `partno` = '40-911-60-psi/kPa-SSRF-MIP-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.016088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857022 [ RunTime:0.010767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470981 LIMIT 5 [ RunTime:0.082319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470981 ORDER BY `minOrder` ASC [ RunTime:0.045251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470981 ORDER BY `unit` DESC [ RunTime:0.065337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470981 LIMIT 2 [ RunTime:0.052565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470981 ORDER BY `minOrder` ASC [ RunTime:0.042450s ]
select * from pdf where partno='40-911-60-psi/kPa-SSRF-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.068699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-60-psi/kPa-SSRF-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.033912s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470981 AND `partno` = '40-911-60-psi/kPa-SSRF-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.137563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18857012 [ RunTime:0.037156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470373 LIMIT 5 [ RunTime:0.063549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470373 ORDER BY `minOrder` ASC [ RunTime:0.139760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470373 ORDER BY `unit` DESC [ RunTime:0.028626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470373 LIMIT 2 [ RunTime:0.102757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470373 ORDER BY `minOrder` ASC [ RunTime:0.236256s ]
select * from pdf where partno='40-911-60-psi/kPa-SSRF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.051119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-60-psi/kPa-SSRF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.097148s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470373 AND `partno` = '40-911-60-psi/kPa-SSRF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.032308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856745 [ RunTime:0.122740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37470322 LIMIT 5 [ RunTime:0.158412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470322 ORDER BY `minOrder` ASC [ RunTime:0.037281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37470322 ORDER BY `unit` DESC [ RunTime:0.054398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37470322 LIMIT 2 [ RunTime:0.112592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37470322 ORDER BY `minOrder` ASC [ RunTime:0.093530s ]
select * from pdf where partno='40-911-60-psi/kPa-SSRF' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.100098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-60-psi/kPa-SSRF' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.039486s ]
SELECT `id` FROM `stock` WHERE `id` <> 37470322 AND `partno` = '40-911-60-psi/kPa-SSRF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.140506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18856726 [ RunTime:0.089084s ]
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-60-psi/kPa-SSRF%' OR `brand` LIKE '40-911-60-psi/kPa-SSRF%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.139284s ]
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-60-psi/kPa-SSRF%' OR `brand` LIKE '40-911-60-psi/kPa-SSRF%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.165708s ]
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-60-psi/kPa-SSRF%' OR `brand` LIKE '40-911-60-psi/kPa-SSRF%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054554s ]
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-60-psi/kPa-SSRF%' OR `brand` LIKE '40-911-60-psi/kPa-SSRF%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.118223s ]
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-60-psi/kPa-SSRF%' OR `brand` LIKE '40-911-60-psi/kPa-SSRF%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.072933s ]
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-60-psi/kPa-SSRF%' OR `brand` LIKE '40-911-60-psi/kPa-SSRF%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065666s ]
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-60-psi/kPa-SSRF%' OR `brand` LIKE '40-911-60-psi/kPa-SSRF%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.111123s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40-911-60-psi/kPa-SSRF%' OR `brand` LIKE '40-911-60-psi/kPa-SSRF%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.052057s ]