SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002474s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002316s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002404s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.217' ) [ RunTime:0.000309s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001176s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000237s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000244s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000181s ]
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.000335s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001523s ]
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.000322s ]
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 1260,20 [ RunTime:0.013395s ]
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 ('10450324','10450323','10450322','10450321','10450320','10450319','10450318','10450317','10450316','10450269','10450268','10450267','10450266','10450265','10450264','10450263','10450262','10450261','10450260','10450259') ORDER BY FIELD(s.id, 10450324,10450323,10450322,10450321,10450320,10450319,10450318,10450317,10450316,10450269,10450268,10450267,10450266,10450265,10450264,10450263,10450262,10450261,10450260,10450259) [ RunTime:0.001898s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450324 LIMIT 4 [ RunTime:0.003123s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450324 ORDER BY `minOrder` ASC [ RunTime:0.002154s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450324 ORDER BY `unit` DESC [ RunTime:0.001250s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450324 LIMIT 2 [ RunTime:0.004109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450324 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450323 LIMIT 4 [ RunTime:0.005216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450323 ORDER BY `minOrder` ASC [ RunTime:0.002113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450323 ORDER BY `unit` DESC [ RunTime:0.004625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450323 LIMIT 2 [ RunTime:0.009696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450323 ORDER BY `minOrder` ASC [ RunTime:0.006954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450322 LIMIT 4 [ RunTime:0.002607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450322 ORDER BY `minOrder` ASC [ RunTime:0.008848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450322 ORDER BY `unit` DESC [ RunTime:0.005897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450322 LIMIT 2 [ RunTime:0.007326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450322 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450321 LIMIT 4 [ RunTime:0.001682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450321 ORDER BY `minOrder` ASC [ RunTime:0.005730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450321 ORDER BY `unit` DESC [ RunTime:0.000464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450321 LIMIT 2 [ RunTime:0.003283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450321 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450320 LIMIT 4 [ RunTime:0.003655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450320 ORDER BY `minOrder` ASC [ RunTime:0.001785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450320 ORDER BY `unit` DESC [ RunTime:0.001239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450320 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450320 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450319 LIMIT 4 [ RunTime:0.006029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450319 ORDER BY `minOrder` ASC [ RunTime:0.000669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450319 ORDER BY `unit` DESC [ RunTime:0.001101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450319 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450319 ORDER BY `minOrder` ASC [ RunTime:0.001394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450318 LIMIT 4 [ RunTime:0.002557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450318 ORDER BY `minOrder` ASC [ RunTime:0.000701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450318 ORDER BY `unit` DESC [ RunTime:0.016685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450318 LIMIT 2 [ RunTime:0.003491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450318 ORDER BY `minOrder` ASC [ RunTime:0.002863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450317 LIMIT 4 [ RunTime:0.007470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450317 ORDER BY `minOrder` ASC [ RunTime:0.002283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450317 ORDER BY `unit` DESC [ RunTime:0.002054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450317 LIMIT 2 [ RunTime:0.006220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450317 ORDER BY `minOrder` ASC [ RunTime:0.000917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450316 LIMIT 4 [ RunTime:0.015840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450316 ORDER BY `minOrder` ASC [ RunTime:0.002476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450316 ORDER BY `unit` DESC [ RunTime:0.002125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450316 LIMIT 2 [ RunTime:0.008860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450316 ORDER BY `minOrder` ASC [ RunTime:0.004151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450269 LIMIT 4 [ RunTime:0.005095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450269 ORDER BY `minOrder` ASC [ RunTime:0.003339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450269 ORDER BY `unit` DESC [ RunTime:0.007430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450269 LIMIT 2 [ RunTime:0.001598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450269 ORDER BY `minOrder` ASC [ RunTime:0.004165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450268 LIMIT 4 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450268 ORDER BY `minOrder` ASC [ RunTime:0.006074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450268 ORDER BY `unit` DESC [ RunTime:0.000919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450268 LIMIT 2 [ RunTime:0.004481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450268 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450267 LIMIT 4 [ RunTime:0.002741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450267 ORDER BY `minOrder` ASC [ RunTime:0.001199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450267 ORDER BY `unit` DESC [ RunTime:0.000711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450267 LIMIT 2 [ RunTime:0.000885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450267 ORDER BY `minOrder` ASC [ RunTime:0.003712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450266 LIMIT 4 [ RunTime:0.001150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450266 ORDER BY `minOrder` ASC [ RunTime:0.009214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450266 ORDER BY `unit` DESC [ RunTime:0.003506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450266 LIMIT 2 [ RunTime:0.003408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450266 ORDER BY `minOrder` ASC [ RunTime:0.002454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450265 LIMIT 4 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450265 ORDER BY `minOrder` ASC [ RunTime:0.001919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450265 ORDER BY `unit` DESC [ RunTime:0.004195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450265 LIMIT 2 [ RunTime:0.001845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450265 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450264 LIMIT 4 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450264 ORDER BY `minOrder` ASC [ RunTime:0.002046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450264 ORDER BY `unit` DESC [ RunTime:0.014058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450264 LIMIT 2 [ RunTime:0.002268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450264 ORDER BY `minOrder` ASC [ RunTime:0.005089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450263 LIMIT 4 [ RunTime:0.011694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450263 ORDER BY `minOrder` ASC [ RunTime:0.011107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450263 ORDER BY `unit` DESC [ RunTime:0.010007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450263 LIMIT 2 [ RunTime:0.007165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450263 ORDER BY `minOrder` ASC [ RunTime:0.002032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450262 LIMIT 4 [ RunTime:0.001576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450262 ORDER BY `minOrder` ASC [ RunTime:0.000786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450262 ORDER BY `unit` DESC [ RunTime:0.000864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450262 LIMIT 2 [ RunTime:0.013918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450262 ORDER BY `minOrder` ASC [ RunTime:0.001469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450261 LIMIT 4 [ RunTime:0.002218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450261 ORDER BY `minOrder` ASC [ RunTime:0.002798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450261 ORDER BY `unit` DESC [ RunTime:0.002726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450261 LIMIT 2 [ RunTime:0.013093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450261 ORDER BY `minOrder` ASC [ RunTime:0.001814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450260 LIMIT 4 [ RunTime:0.003052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450260 ORDER BY `minOrder` ASC [ RunTime:0.001147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450260 ORDER BY `unit` DESC [ RunTime:0.002594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450260 LIMIT 2 [ RunTime:0.008858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450260 ORDER BY `minOrder` ASC [ RunTime:0.007245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10450259 LIMIT 4 [ RunTime:0.001157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450259 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10450259 ORDER BY `unit` DESC [ RunTime:0.001247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10450259 LIMIT 2 [ RunTime:0.000934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10450259 ORDER BY `minOrder` ASC [ RunTime:0.003015s ]
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.298080s ]