SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004038s ]
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 '221KD20-O%' OR `brand` LIKE '221KD20-O%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019553s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14837287 LIMIT 5 [ RunTime:0.027962s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837287 ORDER BY `minOrder` ASC [ RunTime:0.014655s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.015307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14837287 ORDER BY `unit` DESC [ RunTime:0.012623s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14837287 LIMIT 2 [ RunTime:0.004059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837287 ORDER BY `minOrder` ASC [ RunTime:0.028950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14837074 LIMIT 5 [ RunTime:0.026236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837074 ORDER BY `minOrder` ASC [ RunTime:0.038144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14837074 ORDER BY `unit` DESC [ RunTime:0.010550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14837074 LIMIT 2 [ RunTime:0.050030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837074 ORDER BY `minOrder` ASC [ RunTime:0.019112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14837073 LIMIT 5 [ RunTime:0.049135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837073 ORDER BY `minOrder` ASC [ RunTime:0.049683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14837073 ORDER BY `unit` DESC [ RunTime:0.051751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14837073 LIMIT 2 [ RunTime:0.036752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14837073 ORDER BY `minOrder` ASC [ RunTime:0.013293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13936276 LIMIT 5 [ RunTime:0.022784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13936276 ORDER BY `minOrder` ASC [ RunTime:0.040636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13936276 ORDER BY `unit` DESC [ RunTime:0.052461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13936276 LIMIT 2 [ RunTime:0.022497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13936276 ORDER BY `minOrder` ASC [ RunTime:0.028698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13936091 LIMIT 5 [ RunTime:0.043175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13936091 ORDER BY `minOrder` ASC [ RunTime:0.062390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13936091 ORDER BY `unit` DESC [ RunTime:0.056257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13936091 LIMIT 2 [ RunTime:0.051938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13936091 ORDER BY `minOrder` ASC [ RunTime:0.050977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13936089 LIMIT 5 [ RunTime:0.034242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13936089 ORDER BY `minOrder` ASC [ RunTime:0.080217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13936089 ORDER BY `unit` DESC [ RunTime:0.040228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13936089 LIMIT 2 [ RunTime:0.107645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13936089 ORDER BY `minOrder` ASC [ RunTime:0.052599s ]
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 '221KD20-O%' OR `brand` LIKE '221KD20-O%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.071652s ]
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 '221KD20-O%' OR `brand` LIKE '221KD20-O%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41834427 LIMIT 5 [ RunTime:0.028082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41834427 ORDER BY `minOrder` ASC [ RunTime:0.017903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41834427 ORDER BY `unit` DESC [ RunTime:0.069711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41834427 LIMIT 2 [ RunTime:0.066322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41834427 ORDER BY `minOrder` ASC [ RunTime:0.035596s ]
select * from pdf where partno='221KD20-OP7.5TR' and brandshort='YAGEO' limit 1 [ RunTime:0.065153s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KD20-OP7.5TR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.020532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41834426 LIMIT 5 [ RunTime:0.028572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41834426 ORDER BY `minOrder` ASC [ RunTime:0.026260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41834426 ORDER BY `unit` DESC [ RunTime:0.021552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41834426 LIMIT 2 [ RunTime:0.034596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41834426 ORDER BY `minOrder` ASC [ RunTime:0.024525s ]
select * from pdf where partno='221KD20-OP7.5TB' and brandshort='YAGEO' limit 1 [ RunTime:0.014186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KD20-OP7.5TB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.011611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41834400 LIMIT 5 [ RunTime:0.039576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41834400 ORDER BY `minOrder` ASC [ RunTime:0.045383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41834400 ORDER BY `unit` DESC [ RunTime:0.008101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41834400 LIMIT 2 [ RunTime:0.035644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41834400 ORDER BY `minOrder` ASC [ RunTime:0.003343s ]
select * from pdf where partno='221KD20-OTB' and brandshort='YAGEO' limit 1 [ RunTime:0.009188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KD20-OTB' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41834396 LIMIT 5 [ RunTime:0.016712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41834396 ORDER BY `minOrder` ASC [ RunTime:0.005954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41834396 ORDER BY `unit` DESC [ RunTime:0.009758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41834396 LIMIT 2 [ RunTime:0.007200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41834396 ORDER BY `minOrder` ASC [ RunTime:0.003611s ]
select * from pdf where partno='221KD20-OTR' and brandshort='YAGEO' limit 1 [ RunTime:0.021807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KD20-OTR' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.020091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41831505 LIMIT 5 [ RunTime:0.003682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41831505 ORDER BY `minOrder` ASC [ RunTime:0.010161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41831505 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41831505 LIMIT 2 [ RunTime:0.006813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41831505 ORDER BY `minOrder` ASC [ RunTime:0.000932s ]
select * from pdf where partno='221KD20-O' and brandshort='YAGEO' limit 1 [ RunTime:0.020796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KD20-O' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41831495 LIMIT 5 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41831495 ORDER BY `minOrder` ASC [ RunTime:0.002247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41831495 ORDER BY `unit` DESC [ RunTime:0.007013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41831495 LIMIT 2 [ RunTime:0.012940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41831495 ORDER BY `minOrder` ASC [ RunTime:0.002038s ]
select * from pdf where partno='221KD20-OP7.5' and brandshort='YAGEO' limit 1 [ RunTime:0.007351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '221KD20-OP7.5' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.020970s ]
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 '221KD20-O%' OR `brand` LIKE '221KD20-O%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011542s ]
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 '221KD20-O%' OR `brand` LIKE '221KD20-O%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015259s ]
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 '221KD20-O%' OR `brand` LIKE '221KD20-O%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016629s ]
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 '221KD20-O%' OR `brand` LIKE '221KD20-O%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004048s ]
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 '221KD20-O%' OR `brand` LIKE '221KD20-O%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011317s ]
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 '221KD20-O%' OR `brand` LIKE '221KD20-O%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015753s ]
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 '221KD20-O%' OR `brand` LIKE '221KD20-O%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011428s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '221KD20-O%' OR `brand` LIKE '221KD20-O%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014180s ]