SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001624s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000436s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001375s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.35' ) [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000987s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000236s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000250s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000159s ]
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.000275s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001037s ]
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 2080,20 [ RunTime:0.101310s ]
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 ('2857022','2857021','2857020','2857019','2857018','2857017','2857016','2857015','2857014','2857013','2857012','2857011','2857010','2857009','2857008','2857007','2857006','2857005','2857004','2857003') ORDER BY FIELD(s.id, 2857022,2857021,2857020,2857019,2857018,2857017,2857016,2857015,2857014,2857013,2857012,2857011,2857010,2857009,2857008,2857007,2857006,2857005,2857004,2857003) [ RunTime:0.007541s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857022 LIMIT 4 [ RunTime:0.000765s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857022 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857022 ORDER BY `unit` DESC [ RunTime:0.000415s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857022 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857022 ORDER BY `minOrder` ASC [ RunTime:0.001162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857021 LIMIT 4 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857021 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857021 ORDER BY `unit` DESC [ RunTime:0.000449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857021 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857021 ORDER BY `minOrder` ASC [ RunTime:0.001573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857020 LIMIT 4 [ RunTime:0.001278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857020 ORDER BY `minOrder` ASC [ RunTime:0.003609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857020 ORDER BY `unit` DESC [ RunTime:0.003567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857020 LIMIT 2 [ RunTime:0.007478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857020 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857019 LIMIT 4 [ RunTime:0.002016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857019 ORDER BY `minOrder` ASC [ RunTime:0.001650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857019 ORDER BY `unit` DESC [ RunTime:0.003537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857019 LIMIT 2 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857019 ORDER BY `minOrder` ASC [ RunTime:0.002339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857018 LIMIT 4 [ RunTime:0.000461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857018 ORDER BY `minOrder` ASC [ RunTime:0.001834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857018 ORDER BY `unit` DESC [ RunTime:0.000423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857018 LIMIT 2 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857018 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857017 LIMIT 4 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857017 ORDER BY `minOrder` ASC [ RunTime:0.001963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857017 ORDER BY `unit` DESC [ RunTime:0.004051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857017 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857017 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857016 LIMIT 4 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857016 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857016 ORDER BY `unit` DESC [ RunTime:0.002236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857016 LIMIT 2 [ RunTime:0.007856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857016 ORDER BY `minOrder` ASC [ RunTime:0.001122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857015 LIMIT 4 [ RunTime:0.006576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857015 ORDER BY `minOrder` ASC [ RunTime:0.001806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857015 ORDER BY `unit` DESC [ RunTime:0.000802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857015 LIMIT 2 [ RunTime:0.000863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857015 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857014 LIMIT 4 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857014 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857014 ORDER BY `unit` DESC [ RunTime:0.001279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857014 LIMIT 2 [ RunTime:0.002018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857014 ORDER BY `minOrder` ASC [ RunTime:0.000595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857013 LIMIT 4 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857013 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857013 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857013 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857013 ORDER BY `minOrder` ASC [ RunTime:0.003711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857012 LIMIT 4 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857012 ORDER BY `minOrder` ASC [ RunTime:0.000722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857012 ORDER BY `unit` DESC [ RunTime:0.002805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857012 LIMIT 2 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857012 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857011 LIMIT 4 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857011 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857011 ORDER BY `unit` DESC [ RunTime:0.006076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857011 LIMIT 2 [ RunTime:0.004583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857011 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857010 LIMIT 4 [ RunTime:0.001965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857010 ORDER BY `minOrder` ASC [ RunTime:0.001645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857010 ORDER BY `unit` DESC [ RunTime:0.001407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857010 LIMIT 2 [ RunTime:0.001237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857010 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857009 LIMIT 4 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857009 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857009 ORDER BY `unit` DESC [ RunTime:0.000317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857009 LIMIT 2 [ RunTime:0.001740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857009 ORDER BY `minOrder` ASC [ RunTime:0.001632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857008 LIMIT 4 [ RunTime:0.001590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857008 ORDER BY `minOrder` ASC [ RunTime:0.001995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857008 ORDER BY `unit` DESC [ RunTime:0.001586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857008 LIMIT 2 [ RunTime:0.003401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857008 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857007 LIMIT 4 [ RunTime:0.002452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857007 ORDER BY `minOrder` ASC [ RunTime:0.002038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857007 ORDER BY `unit` DESC [ RunTime:0.002255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857007 LIMIT 2 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857007 ORDER BY `minOrder` ASC [ RunTime:0.002524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857006 LIMIT 4 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857006 ORDER BY `minOrder` ASC [ RunTime:0.004874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857006 ORDER BY `unit` DESC [ RunTime:0.000346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857006 LIMIT 2 [ RunTime:0.003586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857006 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857005 LIMIT 4 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857005 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857005 ORDER BY `unit` DESC [ RunTime:0.001894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857005 LIMIT 2 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857005 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857004 LIMIT 4 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857004 ORDER BY `minOrder` ASC [ RunTime:0.004081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857004 ORDER BY `unit` DESC [ RunTime:0.000378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857004 LIMIT 2 [ RunTime:0.004206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857004 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2857003 LIMIT 4 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857003 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2857003 ORDER BY `unit` DESC [ RunTime:0.001394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2857003 LIMIT 2 [ RunTime:0.001556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2857003 ORDER BY `minOrder` ASC [ RunTime:0.000249s ]
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.032228s ]