SHOW FULL COLUMNS FROM `qing_config` [ RunTime:0.002740s ]
SELECT `id`,`value` FROM `qing_config` [ RunTime:0.001392s ]
SHOW FULL COLUMNS FROM `qing_search` [ RunTime:0.004385s ]
SELECT * FROM `qing_search` ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001656s ]
SHOW FULL COLUMNS FROM `qing_category` [ RunTime:0.002370s ]
SELECT * FROM `qing_category` WHERE `isnav` = 1 AND `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.001459s ]
SHOW FULL COLUMNS FROM `qing_ad` [ RunTime:0.003556s ]
SELECT * FROM `qing_ad` WHERE `type_id` = 2 [ RunTime:0.002077s ]
SELECT * FROM `qing_ad` WHERE `type_id` = 1 ORDER BY `id` DESC,`listorder` ASC [ RunTime:0.001143s ]
SELECT * FROM `qing_ad` WHERE `type_id` = 6 ORDER BY `id` DESC,`listorder` ASC [ RunTime:0.001443s ]
SHOW FULL COLUMNS FROM `qing_goods` [ RunTime:0.002599s ]
SELECT g.*, COUNT(v.id) as video_count,`gs`.* FROM `qing_goods` `g` LEFT JOIN `qing_goods_video` `v` ON `g`.`goods_id`=`v`.`goods_id` LEFT JOIN `qing_goods_standard` `gs` ON `g`.`goods_id`=`gs`.`goods_id` WHERE `g`.`ishot` = '1' AND `g`.`goods_status` = '1' AND `gs`.`standard_id` = '5' GROUP BY `g`.`goods_id` ORDER BY `g`.`click` DESC,`g`.`listorder` ASC LIMIT 8 [ RunTime:0.004120s ]
SELECT * FROM `qing_goods` ORDER BY `goods_id` DESC LIMIT 4 [ RunTime:0.002255s ]
SELECT * FROM `qing_goods` ORDER BY `click` DESC LIMIT 10 [ RunTime:0.001685s ]
SHOW FULL COLUMNS FROM `qing_standard_value` [ RunTime:0.001654s ]
SELECT * FROM `qing_standard_value` WHERE `standard_id` = 5 LIMIT 15 [ RunTime:0.001708s ]
SELECT `id`,`parent_id`,`cate_name` FROM `qing_category` WHERE `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.002758s ]
SELECT `id`,`parent_id` FROM `qing_category` WHERE `status` = 1 [ RunTime:0.001202s ]
SELECT `id`,`cate_name`,`thumb` FROM `qing_category` WHERE `isindex` = 1 AND `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.001162s ]
SELECT
g.goods_id,
g.goods_name,
g.goods_thumb,
g.goods_short_name,
g.serial,
COUNT(v.id) as video_count
FROM `qing_goods` `g` LEFT JOIN `qing_goods_video` `v` ON `g`.`goods_id`=`v`.`goods_id` LEFT JOIN `qing_goods_standard` `gs` ON `g`.`goods_id`=gs.goods_id AND gs.standard_id = 5 WHERE `g`.`goods_cate_id` = '3' AND `g`.`goods_status` = '1' GROUP BY `g`.`goods_id` ORDER BY `g`.`listorder` ASC,`g`.`goods_id` DESC LIMIT 16 [ RunTime:0.003046s ]
SELECT `id`,`cate_name` FROM `qing_category` WHERE `parent_id` = 3 AND `status` = 1 [ RunTime:0.000930s ]
SHOW FULL COLUMNS FROM `qing_adtype` [ RunTime:0.002194s ]
SELECT * FROM `qing_adtype` WHERE `id` IN (2,3,4,5) ORDER BY `id` ASC [ RunTime:0.001673s ]
SELECT `title`,`id` FROM `qing_ad` WHERE `type_id` = 2 [ RunTime:0.000733s ]
SELECT `title`,`id` FROM `qing_ad` WHERE `type_id` = 3 [ RunTime:0.001638s ]
SELECT `title`,`id` FROM `qing_ad` WHERE `type_id` = 4 [ RunTime:0.001792s ]
SELECT `title`,`id` FROM `qing_ad` WHERE `type_id` = 5 [ RunTime:0.001005s ]
SELECT * FROM `qing_ad` WHERE `id` = 28 LIMIT 1 [ RunTime:0.002071s ]
SHOW FULL COLUMNS FROM `qing_news` [ RunTime:0.003730s ]
SELECT * FROM `qing_news` ORDER BY `id` DESC LIMIT 3 [ RunTime:0.001845s ]
SELECT `standard_value` FROM `qing_standard_value` WHERE `id` IN (76,77) [ RunTime:0.001711s ]
SELECT `standard_value` FROM `qing_standard_value` WHERE `id` IN (15,68,71) [ RunTime:0.000749s ]
SELECT `standard_value` FROM `qing_standard_value` WHERE `id` IN (14,54) [ RunTime:0.001982s ]
SELECT `standard_value` FROM `qing_standard_value` WHERE `id` IN (15,54,63,73) [ RunTime:0.002189s ]
SELECT `standard_value` FROM `qing_standard_value` WHERE `id` IN (14,53,64,66) [ RunTime:0.003408s ]
SELECT `standard_value` FROM `qing_standard_value` WHERE `id` IN (52,55,72,77) [ RunTime:0.005832s ]
SELECT `standard_value` FROM `qing_standard_value` WHERE `id` IN (64,67) [ RunTime:0.002695s ]
SELECT `standard_value` FROM `qing_standard_value` WHERE `id` IN (15,52,54,55,61,71) [ RunTime:0.002002s ]