SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002296s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000501s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002353s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002406s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000430s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000308s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000263s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000450s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002645s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:1.400073s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 940,20 [ RunTime:0.025644s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('10448142','10448141','10448140','10448139','10448138','10448137','10448136','10448135','10448134','10448133','10448132','10448131','10448130','10448129','10448128','10448127','10448126','10448125','10448124','10448123') ORDER BY FIELD(s.id, 10448142,10448141,10448140,10448139,10448138,10448137,10448136,10448135,10448134,10448133,10448132,10448131,10448130,10448129,10448128,10448127,10448126,10448125,10448124,10448123) [ RunTime:0.016177s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448142 LIMIT 4 [ RunTime:0.009550s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448142 ORDER BY `minOrder` ASC [ RunTime:0.003457s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448142 ORDER BY `unit` DESC [ RunTime:0.004447s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448142 LIMIT 2 [ RunTime:0.001622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448142 ORDER BY `minOrder` ASC [ RunTime:0.012261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448141 LIMIT 4 [ RunTime:0.012538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448141 ORDER BY `minOrder` ASC [ RunTime:0.004487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448141 ORDER BY `unit` DESC [ RunTime:0.004479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448141 LIMIT 2 [ RunTime:0.015130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448141 ORDER BY `minOrder` ASC [ RunTime:0.006115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448140 LIMIT 4 [ RunTime:0.003791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448140 ORDER BY `minOrder` ASC [ RunTime:0.014746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448140 ORDER BY `unit` DESC [ RunTime:0.012925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448140 LIMIT 2 [ RunTime:0.002558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448140 ORDER BY `minOrder` ASC [ RunTime:0.011330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448139 LIMIT 4 [ RunTime:0.008238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448139 ORDER BY `minOrder` ASC [ RunTime:0.013838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448139 ORDER BY `unit` DESC [ RunTime:0.012545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448139 LIMIT 2 [ RunTime:0.031902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448139 ORDER BY `minOrder` ASC [ RunTime:0.012471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448138 LIMIT 4 [ RunTime:0.009126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448138 ORDER BY `minOrder` ASC [ RunTime:0.006144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448138 ORDER BY `unit` DESC [ RunTime:0.006628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448138 LIMIT 2 [ RunTime:0.003780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448138 ORDER BY `minOrder` ASC [ RunTime:0.006192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448137 LIMIT 4 [ RunTime:0.003263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448137 ORDER BY `minOrder` ASC [ RunTime:0.005747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448137 ORDER BY `unit` DESC [ RunTime:0.011110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448137 LIMIT 2 [ RunTime:0.011205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448137 ORDER BY `minOrder` ASC [ RunTime:0.004315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448136 LIMIT 4 [ RunTime:0.010980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448136 ORDER BY `minOrder` ASC [ RunTime:0.031573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448136 ORDER BY `unit` DESC [ RunTime:0.015848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448136 LIMIT 2 [ RunTime:0.007463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448136 ORDER BY `minOrder` ASC [ RunTime:0.003497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448135 LIMIT 4 [ RunTime:0.007949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448135 ORDER BY `minOrder` ASC [ RunTime:0.005350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448135 ORDER BY `unit` DESC [ RunTime:0.009822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448135 LIMIT 2 [ RunTime:0.026216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448135 ORDER BY `minOrder` ASC [ RunTime:0.017153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448134 LIMIT 4 [ RunTime:0.008795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448134 ORDER BY `minOrder` ASC [ RunTime:0.010056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448134 ORDER BY `unit` DESC [ RunTime:0.003740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448134 LIMIT 2 [ RunTime:0.007748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448134 ORDER BY `minOrder` ASC [ RunTime:0.013433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448133 LIMIT 4 [ RunTime:0.007920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448133 ORDER BY `minOrder` ASC [ RunTime:0.014161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448133 ORDER BY `unit` DESC [ RunTime:0.006152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448133 LIMIT 2 [ RunTime:0.023362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448133 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448132 LIMIT 4 [ RunTime:0.007101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448132 ORDER BY `minOrder` ASC [ RunTime:0.007801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448132 ORDER BY `unit` DESC [ RunTime:0.005450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448132 LIMIT 2 [ RunTime:0.017696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448132 ORDER BY `minOrder` ASC [ RunTime:0.002304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448131 LIMIT 4 [ RunTime:0.007229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448131 ORDER BY `minOrder` ASC [ RunTime:0.007965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448131 ORDER BY `unit` DESC [ RunTime:0.005604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448131 LIMIT 2 [ RunTime:0.004432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448131 ORDER BY `minOrder` ASC [ RunTime:0.002348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448130 LIMIT 4 [ RunTime:0.007550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448130 ORDER BY `minOrder` ASC [ RunTime:0.013272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448130 ORDER BY `unit` DESC [ RunTime:0.009214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448130 LIMIT 2 [ RunTime:0.015888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448130 ORDER BY `minOrder` ASC [ RunTime:0.002715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448129 LIMIT 4 [ RunTime:0.006160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448129 ORDER BY `minOrder` ASC [ RunTime:0.016790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448129 ORDER BY `unit` DESC [ RunTime:0.011440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448129 LIMIT 2 [ RunTime:0.015051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448129 ORDER BY `minOrder` ASC [ RunTime:0.000605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448128 LIMIT 4 [ RunTime:0.002638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448128 ORDER BY `minOrder` ASC [ RunTime:0.006152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448128 ORDER BY `unit` DESC [ RunTime:0.002803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448128 LIMIT 2 [ RunTime:0.003793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448128 ORDER BY `minOrder` ASC [ RunTime:0.001718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448127 LIMIT 4 [ RunTime:0.004339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448127 ORDER BY `minOrder` ASC [ RunTime:0.008689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448127 ORDER BY `unit` DESC [ RunTime:0.008878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448127 LIMIT 2 [ RunTime:0.006510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448127 ORDER BY `minOrder` ASC [ RunTime:0.002235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448126 LIMIT 4 [ RunTime:0.007299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448126 ORDER BY `minOrder` ASC [ RunTime:0.006016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448126 ORDER BY `unit` DESC [ RunTime:0.006272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448126 LIMIT 2 [ RunTime:0.012829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448126 ORDER BY `minOrder` ASC [ RunTime:0.002239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448125 LIMIT 4 [ RunTime:0.002332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448125 ORDER BY `minOrder` ASC [ RunTime:0.006208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448125 ORDER BY `unit` DESC [ RunTime:0.004359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448125 LIMIT 2 [ RunTime:0.001239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448125 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448124 LIMIT 4 [ RunTime:0.001740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448124 ORDER BY `minOrder` ASC [ RunTime:0.001911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448124 ORDER BY `unit` DESC [ RunTime:0.000703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448124 LIMIT 2 [ RunTime:0.002081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448124 ORDER BY `minOrder` ASC [ RunTime:0.004812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448123 LIMIT 4 [ RunTime:0.002170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448123 ORDER BY `minOrder` ASC [ RunTime:0.008272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448123 ORDER BY `unit` DESC [ RunTime:0.001434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448123 LIMIT 2 [ RunTime:0.006229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448123 ORDER BY `minOrder` ASC [ RunTime:0.004074s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.950049s ]