SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002271s ]
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 'TX2SS-4.5V-TH%' OR `brand` LIKE 'TX2SS-4.5V-TH%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027045s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17155550 LIMIT 5 [ RunTime:0.025593s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17155550 ORDER BY `minOrder` ASC [ RunTime:0.008490s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17155550 ORDER BY `unit` DESC [ RunTime:0.008385s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17155550 LIMIT 2 [ RunTime:0.005697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17155550 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15376019 LIMIT 5 [ RunTime:0.010330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15376019 ORDER BY `minOrder` ASC [ RunTime:0.011351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15376019 ORDER BY `unit` DESC [ RunTime:0.026244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15376019 LIMIT 2 [ RunTime:0.017751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15376019 ORDER BY `minOrder` ASC [ RunTime:0.020593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15375839 LIMIT 5 [ RunTime:0.041182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15375839 ORDER BY `minOrder` ASC [ RunTime:0.032075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15375839 ORDER BY `unit` DESC [ RunTime:0.016253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15375839 LIMIT 2 [ RunTime:0.007520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15375839 ORDER BY `minOrder` ASC [ RunTime:0.005623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15375796 LIMIT 5 [ RunTime:0.005512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15375796 ORDER BY `minOrder` ASC [ RunTime:0.014990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15375796 ORDER BY `unit` DESC [ RunTime:0.000540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15375796 LIMIT 2 [ RunTime:0.021076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15375796 ORDER BY `minOrder` ASC [ RunTime:0.005173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15375795 LIMIT 5 [ RunTime:0.007400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15375795 ORDER BY `minOrder` ASC [ RunTime:0.008957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15375795 ORDER BY `unit` DESC [ RunTime:0.000392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15375795 LIMIT 2 [ RunTime:0.002799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15375795 ORDER BY `minOrder` ASC [ RunTime:0.003624s ]
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 'TX2SS-4.5V-TH%' OR `brand` LIKE 'TX2SS-4.5V-TH%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013575s ]
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 'TX2SS-4.5V-TH%' OR `brand` LIKE 'TX2SS-4.5V-TH%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58336553 LIMIT 5 [ RunTime:0.026859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58336553 ORDER BY `minOrder` ASC [ RunTime:0.015946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58336553 ORDER BY `unit` DESC [ RunTime:0.010578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58336553 LIMIT 2 [ RunTime:0.041480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58336553 ORDER BY `minOrder` ASC [ RunTime:0.004938s ]
select * from pdf where partno='TX2SS-4.5V-TH' and brandshort='Panasonic Electric Works' limit 1 [ RunTime:0.009943s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TX2SS-4.5V-TH' OR `brand` LIKE 'Panasonic Electric Works%' ) ) LIMIT 1 [ RunTime:0.033524s ]
SELECT `id` FROM `stock` WHERE `id` <> 58336553 AND `partno` = 'TX2SS-4.5V-TH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic electric works%' ) [ RunTime:0.022341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15376019 [ RunTime:0.034161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58336128 LIMIT 5 [ RunTime:0.020677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58336128 ORDER BY `minOrder` ASC [ RunTime:0.031192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58336128 ORDER BY `unit` DESC [ RunTime:0.029759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58336128 LIMIT 2 [ RunTime:0.010623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58336128 ORDER BY `minOrder` ASC [ RunTime:0.012126s ]
select * from pdf where partno='TX2SS-4.5V-TH-Y' and brandshort='Panasonic Electric Works' limit 1 [ RunTime:0.045816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TX2SS-4.5V-TH-Y' OR `brand` LIKE 'Panasonic Electric Works%' ) ) LIMIT 1 [ RunTime:0.004327s ]
SELECT `id` FROM `stock` WHERE `id` <> 58336128 AND `partno` = 'TX2SS-4.5V-TH-Y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic electric works%' ) [ RunTime:0.007790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15375839 [ RunTime:0.001994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58336125 LIMIT 5 [ RunTime:0.003376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58336125 ORDER BY `minOrder` ASC [ RunTime:0.017584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58336125 ORDER BY `unit` DESC [ RunTime:0.014101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58336125 LIMIT 2 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58336125 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='TX2SS-4.5V-TH-W' and brandshort='Panasonic Electric Works' limit 1 [ RunTime:0.011582s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TX2SS-4.5V-TH-W' OR `brand` LIKE 'Panasonic Electric Works%' ) ) LIMIT 1 [ RunTime:0.006569s ]
SELECT `id` FROM `stock` WHERE `id` <> 58336125 AND `partno` = 'TX2SS-4.5V-TH-W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic electric works%' ) [ RunTime:0.010989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17155550 [ RunTime:0.004895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58336086 LIMIT 5 [ RunTime:0.002038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58336086 ORDER BY `minOrder` ASC [ RunTime:0.011309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58336086 ORDER BY `unit` DESC [ RunTime:0.000925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58336086 LIMIT 2 [ RunTime:0.010196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58336086 ORDER BY `minOrder` ASC [ RunTime:0.007643s ]
select * from pdf where partno='TX2SS-4.5V-TH-Z' and brandshort='Panasonic Electric Works' limit 1 [ RunTime:0.014981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TX2SS-4.5V-TH-Z' OR `brand` LIKE 'Panasonic Electric Works%' ) ) LIMIT 1 [ RunTime:0.003928s ]
SELECT `id` FROM `stock` WHERE `id` <> 58336086 AND `partno` = 'TX2SS-4.5V-TH-Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic electric works%' ) [ RunTime:0.027175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15375796 [ RunTime:0.014551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58336085 LIMIT 5 [ RunTime:0.011196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58336085 ORDER BY `minOrder` ASC [ RunTime:0.001656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58336085 ORDER BY `unit` DESC [ RunTime:0.000963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58336085 LIMIT 2 [ RunTime:0.007284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58336085 ORDER BY `minOrder` ASC [ RunTime:0.009512s ]
select * from pdf where partno='TX2SS-4.5V-TH-X' and brandshort='Panasonic Electric Works' limit 1 [ RunTime:0.007885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TX2SS-4.5V-TH-X' OR `brand` LIKE 'Panasonic Electric Works%' ) ) LIMIT 1 [ RunTime:0.009333s ]
SELECT `id` FROM `stock` WHERE `id` <> 58336085 AND `partno` = 'TX2SS-4.5V-TH-X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panasonic electric works%' ) [ RunTime:0.010970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15375795 [ RunTime:0.000498s ]
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 'TX2SS-4.5V-TH%' OR `brand` LIKE 'TX2SS-4.5V-TH%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001444s ]
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 'TX2SS-4.5V-TH%' OR `brand` LIKE 'TX2SS-4.5V-TH%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010766s ]
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 'TX2SS-4.5V-TH%' OR `brand` LIKE 'TX2SS-4.5V-TH%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023619s ]
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 'TX2SS-4.5V-TH%' OR `brand` LIKE 'TX2SS-4.5V-TH%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021668s ]
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 'TX2SS-4.5V-TH%' OR `brand` LIKE 'TX2SS-4.5V-TH%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006527s ]
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 'TX2SS-4.5V-TH%' OR `brand` LIKE 'TX2SS-4.5V-TH%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021316s ]
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 'TX2SS-4.5V-TH%' OR `brand` LIKE 'TX2SS-4.5V-TH%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006624s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TX2SS-4.5V-TH%' OR `brand` LIKE 'TX2SS-4.5V-TH%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022197s ]