SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002599s ]
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 'NKN5WSJR-73-0R3%' OR `brand` LIKE 'NKN5WSJR-73-0R3%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007837s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18390607 LIMIT 5 [ RunTime:0.005897s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18390607 ORDER BY `minOrder` ASC [ RunTime:0.007782s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18390607 ORDER BY `unit` DESC [ RunTime:0.006531s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18390607 LIMIT 2 [ RunTime:0.011144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18390607 ORDER BY `minOrder` ASC [ RunTime:0.001408s ]
select * from pdf where partno='NKN5WSJR-73-0R39' and brandshort='YAGEO' limit 1 [ RunTime:0.007412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18390606 LIMIT 5 [ RunTime:0.010819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18390606 ORDER BY `minOrder` ASC [ RunTime:0.013872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18390606 ORDER BY `unit` DESC [ RunTime:0.010565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18390606 LIMIT 2 [ RunTime:0.014901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18390606 ORDER BY `minOrder` ASC [ RunTime:0.013156s ]
select * from pdf where partno='NKN5WSJR-73-0R33' and brandshort='YAGEO' limit 1 [ RunTime:0.021314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15899485 LIMIT 5 [ RunTime:0.046148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15899485 ORDER BY `minOrder` ASC [ RunTime:0.033672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15899485 ORDER BY `unit` DESC [ RunTime:0.019500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15899485 LIMIT 2 [ RunTime:0.018091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15899485 ORDER BY `minOrder` ASC [ RunTime:0.011559s ]
select * from pdf where partno='NKN5WSJR-73-0R3' and brandshort='YAGEO' limit 1 [ RunTime:0.028982s ]
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 'NKN5WSJR-73-0R3%' OR `brand` LIKE 'NKN5WSJR-73-0R3%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015670s ]
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 'NKN5WSJR-73-0R3%' OR `brand` LIKE 'NKN5WSJR-73-0R3%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.078227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38854198 LIMIT 5 [ RunTime:0.077782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38854198 ORDER BY `minOrder` ASC [ RunTime:0.071075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38854198 ORDER BY `unit` DESC [ RunTime:0.055719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38854198 LIMIT 2 [ RunTime:0.011306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38854198 ORDER BY `minOrder` ASC [ RunTime:0.004187s ]
select * from pdf where partno='NKN5WSJR-73-0R39' and brandshort='YAGEO' limit 1 [ RunTime:0.003873s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NKN5WSJR-73-0R39' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.025478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38854197 LIMIT 5 [ RunTime:0.036536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38854197 ORDER BY `minOrder` ASC [ RunTime:0.021931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38854197 ORDER BY `unit` DESC [ RunTime:0.048824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38854197 LIMIT 2 [ RunTime:0.013418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38854197 ORDER BY `minOrder` ASC [ RunTime:0.008305s ]
select * from pdf where partno='NKN5WSJR-73-0R33' and brandshort='YAGEO' limit 1 [ RunTime:0.006992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NKN5WSJR-73-0R33' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.025632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38854196 LIMIT 5 [ RunTime:0.008696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38854196 ORDER BY `minOrder` ASC [ RunTime:0.003369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38854196 ORDER BY `unit` DESC [ RunTime:0.005086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38854196 LIMIT 2 [ RunTime:0.007473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38854196 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='NKN5WSJR-73-0R3' and brandshort='YAGEO' limit 1 [ RunTime:0.003255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NKN5WSJR-73-0R3' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.017085s ]
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 'NKN5WSJR-73-0R3%' OR `brand` LIKE 'NKN5WSJR-73-0R3%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006908s ]
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 'NKN5WSJR-73-0R3%' OR `brand` LIKE 'NKN5WSJR-73-0R3%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011624s ]
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 'NKN5WSJR-73-0R3%' OR `brand` LIKE 'NKN5WSJR-73-0R3%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034106s ]
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 'NKN5WSJR-73-0R3%' OR `brand` LIKE 'NKN5WSJR-73-0R3%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014076s ]
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 'NKN5WSJR-73-0R3%' OR `brand` LIKE 'NKN5WSJR-73-0R3%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010608s ]
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 'NKN5WSJR-73-0R3%' OR `brand` LIKE 'NKN5WSJR-73-0R3%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002992s ]
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 'NKN5WSJR-73-0R3%' OR `brand` LIKE 'NKN5WSJR-73-0R3%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009845s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'NKN5WSJR-73-0R3%' OR `brand` LIKE 'NKN5WSJR-73-0R3%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001866s ]