SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002038s ]
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-901-3000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-3000-psi/kg/cm2-1/2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029974s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.012411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860766 LIMIT 5 [ RunTime:0.018123s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860766 ORDER BY `minOrder` ASC [ RunTime:0.012091s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860766 ORDER BY `unit` DESC [ RunTime:0.034654s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860766 LIMIT 2 [ RunTime:0.015814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860766 ORDER BY `minOrder` ASC [ RunTime:0.015628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860297 LIMIT 5 [ RunTime:0.071524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860297 ORDER BY `minOrder` ASC [ RunTime:0.035376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860297 ORDER BY `unit` DESC [ RunTime:0.039929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860297 LIMIT 2 [ RunTime:0.056285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860297 ORDER BY `minOrder` ASC [ RunTime:0.018260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859898 LIMIT 5 [ RunTime:0.028838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859898 ORDER BY `minOrder` ASC [ RunTime:0.059275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859898 ORDER BY `unit` DESC [ RunTime:0.078532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859898 LIMIT 2 [ RunTime:0.049652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859898 ORDER BY `minOrder` ASC [ RunTime:0.021649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859783 LIMIT 5 [ RunTime:0.063276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859783 ORDER BY `minOrder` ASC [ RunTime:0.019160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859783 ORDER BY `unit` DESC [ RunTime:0.014049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859783 LIMIT 2 [ RunTime:0.018748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859783 ORDER BY `minOrder` ASC [ RunTime:0.025455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859667 LIMIT 5 [ RunTime:0.058760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859667 ORDER BY `minOrder` ASC [ RunTime:0.042490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859667 ORDER BY `unit` DESC [ RunTime:0.005706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859667 LIMIT 2 [ RunTime:0.034967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859667 ORDER BY `minOrder` ASC [ RunTime:0.008817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859649 LIMIT 5 [ RunTime:0.025967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859649 ORDER BY `minOrder` ASC [ RunTime:0.048177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859649 ORDER BY `unit` DESC [ RunTime:0.033606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859649 LIMIT 2 [ RunTime:0.048644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859649 ORDER BY `minOrder` ASC [ RunTime:0.016945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859523 LIMIT 5 [ RunTime:0.058053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859523 ORDER BY `minOrder` ASC [ RunTime:0.024161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859523 ORDER BY `unit` DESC [ RunTime:0.034721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859523 LIMIT 2 [ RunTime:0.031352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859523 ORDER BY `minOrder` ASC [ RunTime:0.016961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859134 LIMIT 5 [ RunTime:0.029738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859134 ORDER BY `minOrder` ASC [ RunTime:0.009501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859134 ORDER BY `unit` DESC [ RunTime:0.001285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859134 LIMIT 2 [ RunTime:0.002307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859134 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859028 LIMIT 5 [ RunTime:0.011311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859028 ORDER BY `minOrder` ASC [ RunTime:0.024310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859028 ORDER BY `unit` DESC [ RunTime:0.008540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859028 LIMIT 2 [ RunTime:0.000899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859028 ORDER BY `minOrder` ASC [ RunTime:0.010223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859003 LIMIT 5 [ RunTime:0.013526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859003 ORDER BY `minOrder` ASC [ RunTime:0.010343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859003 ORDER BY `unit` DESC [ RunTime:0.002814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859003 LIMIT 2 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859003 ORDER BY `minOrder` ASC [ RunTime:0.002902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858928 LIMIT 5 [ RunTime:0.000793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858928 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858928 ORDER BY `unit` DESC [ RunTime:0.012346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858928 LIMIT 2 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858928 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026022 LIMIT 5 [ RunTime:0.002746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026022 ORDER BY `minOrder` ASC [ RunTime:0.001778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17026022 ORDER BY `unit` DESC [ RunTime:0.006288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17026022 LIMIT 2 [ RunTime:0.005543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026022 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025944 LIMIT 5 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025944 ORDER BY `minOrder` ASC [ RunTime:0.006503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025944 ORDER BY `unit` DESC [ RunTime:0.003584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025944 LIMIT 2 [ RunTime:0.005642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025944 ORDER BY `minOrder` ASC [ RunTime:0.003865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025906 LIMIT 5 [ RunTime:0.006668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025906 ORDER BY `minOrder` ASC [ RunTime:0.031697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025906 ORDER BY `unit` DESC [ RunTime:0.033239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025906 LIMIT 2 [ RunTime:0.020080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025906 ORDER BY `minOrder` ASC [ RunTime:0.029828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025815 LIMIT 5 [ RunTime:0.007413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025815 ORDER BY `minOrder` ASC [ RunTime:0.020078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025815 ORDER BY `unit` DESC [ RunTime:0.006349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025815 LIMIT 2 [ RunTime:0.007410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025815 ORDER BY `minOrder` ASC [ RunTime:0.022394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025703 LIMIT 5 [ RunTime:0.004522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025703 ORDER BY `minOrder` ASC [ RunTime:0.004264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025703 ORDER BY `unit` DESC [ RunTime:0.002438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025703 LIMIT 2 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025703 ORDER BY `minOrder` ASC [ RunTime:0.002714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15241031 LIMIT 5 [ RunTime:0.018424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15241031 ORDER BY `minOrder` ASC [ RunTime:0.011584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15241031 ORDER BY `unit` DESC [ RunTime:0.014817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15241031 LIMIT 2 [ RunTime:0.043845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15241031 ORDER BY `minOrder` ASC [ RunTime:0.011104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240986 LIMIT 5 [ RunTime:0.015533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240986 ORDER BY `minOrder` ASC [ RunTime:0.008777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240986 ORDER BY `unit` DESC [ RunTime:0.008272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240986 LIMIT 2 [ RunTime:0.005207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240986 ORDER BY `minOrder` ASC [ RunTime:0.012152s ]
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-901-3000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-3000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019114s ]
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-901-3000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-3000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034780s ]
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-901-3000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-3000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029045s ]
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-901-3000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-3000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047245s ]
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-901-3000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-3000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047407s ]
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-901-3000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-3000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029452s ]
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-901-3000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-3000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021185s ]
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-901-3000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-3000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034171s ]
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-901-3000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-3000-psi/kg/cm2-1/2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.088364s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40-901-3000-psi/kg/cm2-1/2%' OR `brand` LIKE '40-901-3000-psi/kg/cm2-1/2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010336s ]