SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001092s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000509s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001729s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001210s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000250s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000193s ]
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.000461s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001815s ]
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:0.619967s ]
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 860,20 [ RunTime:0.005044s ]
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 ('10450291','10450290','10450289','10450288','10450287','10450286','10450285','10450284','10450282','10450281','10449219','10449218','10449217','10449216','10449215','10449214','10449213','10449212','10449211','10449210') ORDER BY FIELD(s.id, 10450291,10450290,10450289,10450288,10450287,10450286,10450285,10450284,10450282,10450281,10449219,10449218,10449217,10449216,10449215,10449214,10449213,10449212,10449211,10449210) [ RunTime:0.002089s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450291 LIMIT 4 [ RunTime:0.003312s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450291 ORDER BY `minOrder` ASC [ RunTime:0.003648s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450291 ORDER BY `unit` DESC [ RunTime:0.002372s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450291 LIMIT 2 [ RunTime:0.004396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450291 ORDER BY `minOrder` ASC [ RunTime:0.001770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450290 LIMIT 4 [ RunTime:0.002242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450290 ORDER BY `minOrder` ASC [ RunTime:0.002581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450290 ORDER BY `unit` DESC [ RunTime:0.000369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450290 LIMIT 2 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450290 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450289 LIMIT 4 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450289 ORDER BY `minOrder` ASC [ RunTime:0.001332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450289 ORDER BY `unit` DESC [ RunTime:0.003930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450289 LIMIT 2 [ RunTime:0.002387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450289 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450288 LIMIT 4 [ RunTime:0.002192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450288 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450288 ORDER BY `unit` DESC [ RunTime:0.000350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450288 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450288 ORDER BY `minOrder` ASC [ RunTime:0.001349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450287 LIMIT 4 [ RunTime:0.000554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450287 ORDER BY `minOrder` ASC [ RunTime:0.006720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450287 ORDER BY `unit` DESC [ RunTime:0.000718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450287 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450287 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450286 LIMIT 4 [ RunTime:0.000347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450286 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450286 ORDER BY `unit` DESC [ RunTime:0.000867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450286 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450286 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450285 LIMIT 4 [ RunTime:0.002959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450285 ORDER BY `minOrder` ASC [ RunTime:0.002774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450285 ORDER BY `unit` DESC [ RunTime:0.000546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450285 LIMIT 2 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450285 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450284 LIMIT 4 [ RunTime:0.000359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450284 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450284 ORDER BY `unit` DESC [ RunTime:0.005242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450284 LIMIT 2 [ RunTime:0.000545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450284 ORDER BY `minOrder` ASC [ RunTime:0.000254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450282 LIMIT 4 [ RunTime:0.000404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450282 ORDER BY `minOrder` ASC [ RunTime:0.002758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450282 ORDER BY `unit` DESC [ RunTime:0.000352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450282 LIMIT 2 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450282 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450281 LIMIT 4 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450281 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450281 ORDER BY `unit` DESC [ RunTime:0.001041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450281 LIMIT 2 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450281 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10449219 LIMIT 4 [ RunTime:0.000845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449219 ORDER BY `minOrder` ASC [ RunTime:0.002452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10449219 ORDER BY `unit` DESC [ RunTime:0.000521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10449219 LIMIT 2 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449219 ORDER BY `minOrder` ASC [ RunTime:0.000249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10449218 LIMIT 4 [ RunTime:0.000339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449218 ORDER BY `minOrder` ASC [ RunTime:0.000897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10449218 ORDER BY `unit` DESC [ RunTime:0.001040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10449218 LIMIT 2 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449218 ORDER BY `minOrder` ASC [ RunTime:0.000247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10449217 LIMIT 4 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449217 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10449217 ORDER BY `unit` DESC [ RunTime:0.000333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10449217 LIMIT 2 [ RunTime:0.002531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449217 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10449216 LIMIT 4 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449216 ORDER BY `minOrder` ASC [ RunTime:0.006775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10449216 ORDER BY `unit` DESC [ RunTime:0.000521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10449216 LIMIT 2 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449216 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10449215 LIMIT 4 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449215 ORDER BY `minOrder` ASC [ RunTime:0.000951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10449215 ORDER BY `unit` DESC [ RunTime:0.006506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10449215 LIMIT 2 [ RunTime:0.003256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449215 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10449214 LIMIT 4 [ RunTime:0.001895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449214 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10449214 ORDER BY `unit` DESC [ RunTime:0.002730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10449214 LIMIT 2 [ RunTime:0.003155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449214 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10449213 LIMIT 4 [ RunTime:0.007032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449213 ORDER BY `minOrder` ASC [ RunTime:0.000703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10449213 ORDER BY `unit` DESC [ RunTime:0.004492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10449213 LIMIT 2 [ RunTime:0.002934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449213 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10449212 LIMIT 4 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449212 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10449212 ORDER BY `unit` DESC [ RunTime:0.000341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10449212 LIMIT 2 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449212 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10449211 LIMIT 4 [ RunTime:0.001022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449211 ORDER BY `minOrder` ASC [ RunTime:0.002613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10449211 ORDER BY `unit` DESC [ RunTime:0.003049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10449211 LIMIT 2 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449211 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10449210 LIMIT 4 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449210 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10449210 ORDER BY `unit` DESC [ RunTime:0.001553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10449210 LIMIT 2 [ RunTime:0.001200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10449210 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
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.756383s ]