SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002281s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000515s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002146s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.166' ) [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002256s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000285s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000238s ]
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.000448s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002103s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay IS NULL OR s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 1880,20 [ RunTime:0.107668s ]
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 IS NULL OR s.isDisplay = 1) ) AND `s`.`id` IN ('3680704','3636959','3592146','3592145','3579088','3575862','3575861','3572277','3535415','3535377','3535371','3535368','3535366','3528368','3527722','3520187','3294803','3294779','3288006','3285132') ORDER BY FIELD(s.id, 3680704,3636959,3592146,3592145,3579088,3575862,3575861,3572277,3535415,3535377,3535371,3535368,3535366,3528368,3527722,3520187,3294803,3294779,3288006,3285132) [ RunTime:0.006728s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3680704 LIMIT 4 [ RunTime:0.006026s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3680704 ORDER BY `minOrder` ASC [ RunTime:0.004887s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3680704 ORDER BY `unit` DESC [ RunTime:0.000743s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3680704 LIMIT 2 [ RunTime:0.002331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3680704 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3636959 LIMIT 4 [ RunTime:0.001220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3636959 ORDER BY `minOrder` ASC [ RunTime:0.000765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3636959 ORDER BY `unit` DESC [ RunTime:0.000788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3636959 LIMIT 2 [ RunTime:0.002833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3636959 ORDER BY `minOrder` ASC [ RunTime:0.003360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3592146 LIMIT 4 [ RunTime:0.001774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3592146 ORDER BY `minOrder` ASC [ RunTime:0.002866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3592146 ORDER BY `unit` DESC [ RunTime:0.001187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3592146 LIMIT 2 [ RunTime:0.000881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3592146 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3592145 LIMIT 4 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3592145 ORDER BY `minOrder` ASC [ RunTime:0.000926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3592145 ORDER BY `unit` DESC [ RunTime:0.000353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3592145 LIMIT 2 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3592145 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3579088 LIMIT 4 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3579088 ORDER BY `minOrder` ASC [ RunTime:0.008872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3579088 ORDER BY `unit` DESC [ RunTime:0.003683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3579088 LIMIT 2 [ RunTime:0.004394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3579088 ORDER BY `minOrder` ASC [ RunTime:0.002933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3575862 LIMIT 4 [ RunTime:0.005878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3575862 ORDER BY `minOrder` ASC [ RunTime:0.002071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3575862 ORDER BY `unit` DESC [ RunTime:0.000376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3575862 LIMIT 2 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3575862 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3575861 LIMIT 4 [ RunTime:0.002423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3575861 ORDER BY `minOrder` ASC [ RunTime:0.007731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3575861 ORDER BY `unit` DESC [ RunTime:0.002715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3575861 LIMIT 2 [ RunTime:0.001674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3575861 ORDER BY `minOrder` ASC [ RunTime:0.000791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3572277 LIMIT 4 [ RunTime:0.002831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3572277 ORDER BY `minOrder` ASC [ RunTime:0.001661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3572277 ORDER BY `unit` DESC [ RunTime:0.001767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3572277 LIMIT 2 [ RunTime:0.002711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3572277 ORDER BY `minOrder` ASC [ RunTime:0.001586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3535415 LIMIT 4 [ RunTime:0.001036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3535415 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3535415 ORDER BY `unit` DESC [ RunTime:0.002001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3535415 LIMIT 2 [ RunTime:0.000959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3535415 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3535377 LIMIT 4 [ RunTime:0.001061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3535377 ORDER BY `minOrder` ASC [ RunTime:0.000591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3535377 ORDER BY `unit` DESC [ RunTime:0.000867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3535377 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3535377 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3535371 LIMIT 4 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3535371 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3535371 ORDER BY `unit` DESC [ RunTime:0.003939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3535371 LIMIT 2 [ RunTime:0.003728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3535371 ORDER BY `minOrder` ASC [ RunTime:0.000897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3535368 LIMIT 4 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3535368 ORDER BY `minOrder` ASC [ RunTime:0.001403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3535368 ORDER BY `unit` DESC [ RunTime:0.000555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3535368 LIMIT 2 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3535368 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3535366 LIMIT 4 [ RunTime:0.001182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3535366 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3535366 ORDER BY `unit` DESC [ RunTime:0.002863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3535366 LIMIT 2 [ RunTime:0.005372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3535366 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3528368 LIMIT 4 [ RunTime:0.002230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3528368 ORDER BY `minOrder` ASC [ RunTime:0.001453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3528368 ORDER BY `unit` DESC [ RunTime:0.005685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3528368 LIMIT 2 [ RunTime:0.003842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3528368 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3527722 LIMIT 4 [ RunTime:0.000782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3527722 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3527722 ORDER BY `unit` DESC [ RunTime:0.000547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3527722 LIMIT 2 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3527722 ORDER BY `minOrder` ASC [ RunTime:0.000963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3520187 LIMIT 4 [ RunTime:0.005244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3520187 ORDER BY `minOrder` ASC [ RunTime:0.003463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3520187 ORDER BY `unit` DESC [ RunTime:0.000525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3520187 LIMIT 2 [ RunTime:0.000502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3520187 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3294803 LIMIT 4 [ RunTime:0.000893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3294803 ORDER BY `minOrder` ASC [ RunTime:0.004289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3294803 ORDER BY `unit` DESC [ RunTime:0.000703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3294803 LIMIT 2 [ RunTime:0.002786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3294803 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3294779 LIMIT 4 [ RunTime:0.000964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3294779 ORDER BY `minOrder` ASC [ RunTime:0.000569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3294779 ORDER BY `unit` DESC [ RunTime:0.000509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3294779 LIMIT 2 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3294779 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3288006 LIMIT 4 [ RunTime:0.001388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3288006 ORDER BY `minOrder` ASC [ RunTime:0.004162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3288006 ORDER BY `unit` DESC [ RunTime:0.009227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3288006 LIMIT 2 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3288006 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3285132 LIMIT 4 [ RunTime:0.000929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3285132 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3285132 ORDER BY `unit` DESC [ RunTime:0.001981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3285132 LIMIT 2 [ RunTime:0.004527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3285132 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000491s ]