SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001995s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001333s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003198s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.217' ) [ RunTime:0.000357s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002344s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000353s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000276s ]
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.001084s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002782s ]
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.143751s ]
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 1320,20 [ RunTime:0.013172s ]
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 ('10448118','10448117','10448116','10448115','10448114','10448113','10448112','10448111','10448110','10448109','10448108','10448107','10448106','10448105','10448104','10448103','10448102','10448101','10448100','10447016') ORDER BY FIELD(s.id, 10448118,10448117,10448116,10448115,10448114,10448113,10448112,10448111,10448110,10448109,10448108,10448107,10448106,10448105,10448104,10448103,10448102,10448101,10448100,10447016) [ RunTime:0.002949s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448118 LIMIT 4 [ RunTime:0.002466s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448118 ORDER BY `minOrder` ASC [ RunTime:0.013016s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448118 ORDER BY `unit` DESC [ RunTime:0.006514s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448118 LIMIT 2 [ RunTime:0.019705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448118 ORDER BY `minOrder` ASC [ RunTime:0.000883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448117 LIMIT 4 [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448117 ORDER BY `minOrder` ASC [ RunTime:0.002067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448117 ORDER BY `unit` DESC [ RunTime:0.009363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448117 LIMIT 2 [ RunTime:0.010904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448117 ORDER BY `minOrder` ASC [ RunTime:0.002078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448116 LIMIT 4 [ RunTime:0.002786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448116 ORDER BY `minOrder` ASC [ RunTime:0.000661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448116 ORDER BY `unit` DESC [ RunTime:0.005433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448116 LIMIT 2 [ RunTime:0.003349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448116 ORDER BY `minOrder` ASC [ RunTime:0.001887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448115 LIMIT 4 [ RunTime:0.004058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448115 ORDER BY `minOrder` ASC [ RunTime:0.006701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448115 ORDER BY `unit` DESC [ RunTime:0.021593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448115 LIMIT 2 [ RunTime:0.011701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448115 ORDER BY `minOrder` ASC [ RunTime:0.009169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448114 LIMIT 4 [ RunTime:0.004578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448114 ORDER BY `minOrder` ASC [ RunTime:0.000681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448114 ORDER BY `unit` DESC [ RunTime:0.006148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448114 LIMIT 2 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448114 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448113 LIMIT 4 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448113 ORDER BY `minOrder` ASC [ RunTime:0.005260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448113 ORDER BY `unit` DESC [ RunTime:0.000976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448113 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448113 ORDER BY `minOrder` ASC [ RunTime:0.004643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448112 LIMIT 4 [ RunTime:0.000749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448112 ORDER BY `minOrder` ASC [ RunTime:0.004986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448112 ORDER BY `unit` DESC [ RunTime:0.004411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448112 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448112 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448111 LIMIT 4 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448111 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448111 ORDER BY `unit` DESC [ RunTime:0.001731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448111 LIMIT 2 [ RunTime:0.001254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448111 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448110 LIMIT 4 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448110 ORDER BY `minOrder` ASC [ RunTime:0.001035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448110 ORDER BY `unit` DESC [ RunTime:0.000680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448110 LIMIT 2 [ RunTime:0.001643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448110 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448109 LIMIT 4 [ RunTime:0.001790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448109 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448109 ORDER BY `unit` DESC [ RunTime:0.000608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448109 LIMIT 2 [ RunTime:0.002554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448109 ORDER BY `minOrder` ASC [ RunTime:0.001298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448108 LIMIT 4 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448108 ORDER BY `minOrder` ASC [ RunTime:0.002330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448108 ORDER BY `unit` DESC [ RunTime:0.001596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448108 LIMIT 2 [ RunTime:0.000981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448108 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448107 LIMIT 4 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448107 ORDER BY `minOrder` ASC [ RunTime:0.001512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448107 ORDER BY `unit` DESC [ RunTime:0.001217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448107 LIMIT 2 [ RunTime:0.004238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448107 ORDER BY `minOrder` ASC [ RunTime:0.001559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448106 LIMIT 4 [ RunTime:0.001981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448106 ORDER BY `minOrder` ASC [ RunTime:0.002251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448106 ORDER BY `unit` DESC [ RunTime:0.000770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448106 LIMIT 2 [ RunTime:0.006539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448106 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448105 LIMIT 4 [ RunTime:0.000735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448105 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448105 ORDER BY `unit` DESC [ RunTime:0.000629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448105 LIMIT 2 [ RunTime:0.005364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448105 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448104 LIMIT 4 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448104 ORDER BY `minOrder` ASC [ RunTime:0.000640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448104 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448104 LIMIT 2 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448104 ORDER BY `minOrder` ASC [ RunTime:0.000851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448103 LIMIT 4 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448103 ORDER BY `minOrder` ASC [ RunTime:0.018277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448103 ORDER BY `unit` DESC [ RunTime:0.004356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448103 LIMIT 2 [ RunTime:0.003494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448103 ORDER BY `minOrder` ASC [ RunTime:0.002356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448102 LIMIT 4 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448102 ORDER BY `minOrder` ASC [ RunTime:0.000800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448102 ORDER BY `unit` DESC [ RunTime:0.003743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448102 LIMIT 2 [ RunTime:0.008402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448102 ORDER BY `minOrder` ASC [ RunTime:0.006922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448101 LIMIT 4 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448101 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448101 ORDER BY `unit` DESC [ RunTime:0.002631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448101 LIMIT 2 [ RunTime:0.002923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448101 ORDER BY `minOrder` ASC [ RunTime:0.002003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10448100 LIMIT 4 [ RunTime:0.002786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448100 ORDER BY `minOrder` ASC [ RunTime:0.001014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10448100 ORDER BY `unit` DESC [ RunTime:0.007534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10448100 LIMIT 2 [ RunTime:0.002951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10448100 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10447016 LIMIT 4 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447016 ORDER BY `minOrder` ASC [ RunTime:0.000645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10447016 ORDER BY `unit` DESC [ RunTime:0.008493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10447016 LIMIT 2 [ RunTime:0.004026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10447016 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
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:1.266347s ]