SHOW FULL COLUMNS FROM `qing_config` [ RunTime:0.002008s ]
SELECT `id`,`value` FROM `qing_config` [ RunTime:0.000676s ]
SHOW FULL COLUMNS FROM `qing_search` [ RunTime:0.001818s ]
SELECT * FROM `qing_search` ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000647s ]
SHOW FULL COLUMNS FROM `qing_cart` [ RunTime:0.001906s ]
SELECT COUNT(*) AS think_count FROM `qing_cart` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000493s ]
SHOW FULL COLUMNS FROM `qing_category` [ RunTime:0.001800s ]
SELECT * FROM `qing_category` WHERE `isnav` = 1 AND `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.000759s ]
SHOW FULL COLUMNS FROM `qing_ad` [ RunTime:0.001854s ]
SELECT * FROM `qing_ad` WHERE `type_id` = 2 [ RunTime:0.001151s ]
SELECT * FROM `qing_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000684s ]
SELECT `id`,`parent_id` FROM `qing_category` [ RunTime:0.000763s ]
SHOW FULL COLUMNS FROM `qing_standard` [ RunTime:0.002289s ]
SELECT `name`,`id` FROM `qing_standard` WHERE `type_id` = 2 [ RunTime:0.001101s ]
SHOW FULL COLUMNS FROM `qing_standard_value` [ RunTime:0.002909s ]
SELECT `id`,`standard_value` FROM `qing_standard_value` WHERE `standard_id` = 3 [ RunTime:0.000895s ]
SHOW FULL COLUMNS FROM `qing_goods_standard` [ RunTime:0.001166s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('7', `sku`) LIMIT 1 [ RunTime:0.000480s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('8', `sku`) LIMIT 1 [ RunTime:0.000477s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('9', `sku`) LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`standard_value` FROM `qing_standard_value` WHERE `standard_id` = 5 [ RunTime:0.000419s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('14', `sku`) LIMIT 1 [ RunTime:0.000355s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('15', `sku`) LIMIT 1 [ RunTime:0.000406s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('52', `sku`) LIMIT 1 [ RunTime:0.000342s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('53', `sku`) LIMIT 1 [ RunTime:0.000533s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('54', `sku`) LIMIT 1 [ RunTime:0.000505s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('55', `sku`) LIMIT 1 [ RunTime:0.000392s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('56', `sku`) LIMIT 1 [ RunTime:0.000415s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('61', `sku`) LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('62', `sku`) LIMIT 1 [ RunTime:0.000404s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('63', `sku`) LIMIT 1 [ RunTime:0.000371s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('64', `sku`) LIMIT 1 [ RunTime:0.000384s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('65', `sku`) LIMIT 1 [ RunTime:0.000372s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('66', `sku`) LIMIT 1 [ RunTime:0.000397s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('67', `sku`) LIMIT 1 [ RunTime:0.000366s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('68', `sku`) LIMIT 1 [ RunTime:0.000381s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('69', `sku`) LIMIT 1 [ RunTime:0.000363s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('70', `sku`) LIMIT 1 [ RunTime:0.000423s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('71', `sku`) LIMIT 1 [ RunTime:0.000383s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('72', `sku`) LIMIT 1 [ RunTime:0.000404s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('73', `sku`) LIMIT 1 [ RunTime:0.001101s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('74', `sku`) LIMIT 1 [ RunTime:0.000620s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('75', `sku`) LIMIT 1 [ RunTime:0.000463s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('76', `sku`) LIMIT 1 [ RunTime:0.000538s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('77', `sku`) LIMIT 1 [ RunTime:0.000417s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('78', `sku`) LIMIT 1 [ RunTime:0.000353s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('79', `sku`) LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('86', `sku`) LIMIT 1 [ RunTime:0.000349s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('87', `sku`) LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`standard_value` FROM `qing_standard_value` WHERE `standard_id` = 22 [ RunTime:0.000383s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('80', `sku`) LIMIT 1 [ RunTime:0.000409s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('81', `sku`) LIMIT 1 [ RunTime:0.000496s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('82', `sku`) LIMIT 1 [ RunTime:0.000443s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('83', `sku`) LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`standard_value` FROM `qing_standard_value` WHERE `standard_id` = 23 [ RunTime:0.000420s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('84', `sku`) LIMIT 1 [ RunTime:0.000404s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('85', `sku`) LIMIT 1 [ RunTime:0.000491s ]
SHOW FULL COLUMNS FROM `qing_goods` [ RunTime:0.001177s ]
SELECT COUNT(*) AS think_count FROM `qing_goods` `g` LEFT JOIN (SELECT goods_id,COUNT(id) AS collect_num FROM qing_collect GROUP BY goods_id) c ON `g`.`goods_id`=`c`.`goods_id` WHERE `goods_cate_id` = 3 AND `goods_status` = 1 LIMIT 1 [ RunTime:0.001301s ]
SELECT * FROM `qing_goods` `g` LEFT JOIN (SELECT goods_id,COUNT(id) AS collect_num FROM qing_collect GROUP BY goods_id) c ON `g`.`goods_id`=`c`.`goods_id` WHERE `goods_cate_id` = 3 AND `goods_status` = 1 ORDER BY `g`.`click` DESC LIMIT 0,27 [ RunTime:0.001920s ]
SELECT * FROM `qing_goods` `g` LEFT JOIN (SELECT goods_id,COUNT(id) AS collect_num FROM qing_collect GROUP BY goods_id) c ON `g`.`goods_id`=`c`.`goods_id` WHERE `goods_cate_id` = 3 AND `goods_status` = 1 ORDER BY `g`.`click` DESC,`g`.`goods_score` DESC LIMIT 10 [ RunTime:0.001947s ]
SELECT * FROM `qing_goods` `g` LEFT JOIN (SELECT goods_id,COUNT(id) AS collect_num FROM qing_collect GROUP BY goods_id) c ON `g`.`goods_id`=`c`.`goods_id` WHERE `goods_cate_id` = 3 AND `goods_status` = 1 ORDER BY `c`.`collect_num` DESC,`g`.`click` DESC LIMIT 10 [ RunTime:0.001833s ]
SELECT * FROM `qing_goods` `g` LEFT JOIN (SELECT goods_id,COUNT(id) AS collect_num FROM qing_collect GROUP BY goods_id) c ON `g`.`goods_id`=`c`.`goods_id` WHERE `goods_cate_id` = 3 AND `goods_status` = 1 ORDER BY `g`.`time` DESC,`g`.`click` DESC LIMIT 10 [ RunTime:0.001865s ]
SELECT * FROM `qing_goods` `g` LEFT JOIN (SELECT goods_id,COUNT(id) AS collect_num FROM qing_collect GROUP BY goods_id) c ON `g`.`goods_id`=`c`.`goods_id` WHERE `goods_cate_id` = 3 AND `goods_status` = 1 ORDER BY `g`.`click` DESC LIMIT 10 [ RunTime:0.001870s ]
SELECT * FROM `qing_goods` `g` LEFT JOIN (SELECT goods_id,COUNT(id) AS collect_num FROM qing_collect GROUP BY goods_id) c ON `g`.`goods_id`=`c`.`goods_id` INNER JOIN `qing_goods_standard` `gs` ON `g`.`goods_id`=`gs`.`goods_id` INNER JOIN `qing_standard_value` `sv` ON FIND_IN_SET(sv.id, gs.sku) WHERE `goods_cate_id` = 3 AND `goods_status` = 1 AND `sv`.`standard_value` = '穿越' ORDER BY `g`.`click` DESC LIMIT 10 [ RunTime:0.002208s ]
SELECT * FROM `qing_goods` `g` LEFT JOIN (SELECT goods_id,COUNT(id) AS collect_num FROM qing_collect GROUP BY goods_id) c ON `g`.`goods_id`=`c`.`goods_id` INNER JOIN `qing_goods_standard` `gs` ON `g`.`goods_id`=`gs`.`goods_id` INNER JOIN `qing_standard_value` `sv` ON FIND_IN_SET(sv.id, gs.sku) WHERE `goods_cate_id` = 3 AND `goods_status` = 1 AND `sv`.`standard_value` = '恋爱' ORDER BY `c`.`collect_num` DESC LIMIT 10 [ RunTime:0.002127s ]
SELECT * FROM `qing_goods` `g` LEFT JOIN (SELECT goods_id,COUNT(id) AS collect_num FROM qing_collect GROUP BY goods_id) c ON `g`.`goods_id`=`c`.`goods_id` INNER JOIN `qing_goods_standard` `gs` ON `g`.`goods_id`=`gs`.`goods_id` INNER JOIN `qing_standard_value` `sv` ON FIND_IN_SET(sv.id, gs.sku) WHERE `goods_cate_id` = 3 AND `goods_status` = 1 AND `sv`.`standard_value` = '搞笑' ORDER BY `g`.`click` DESC LIMIT 10 [ RunTime:0.001575s ]
SELECT * FROM `qing_goods` `g` LEFT JOIN (SELECT goods_id,COUNT(id) AS collect_num FROM qing_collect GROUP BY goods_id) c ON `g`.`goods_id`=`c`.`goods_id` INNER JOIN `qing_goods_standard` `gs` ON `g`.`goods_id`=`gs`.`goods_id` INNER JOIN `qing_standard_value` `sv` ON FIND_IN_SET(sv.id, gs.sku) WHERE `goods_cate_id` = 3 AND `goods_status` = 1 AND `sv`.`standard_value` = '热血战斗' ORDER BY `g`.`click` DESC LIMIT 10 [ RunTime:0.001500s ]
SELECT * FROM `qing_goods` `g` LEFT JOIN (SELECT goods_id,COUNT(id) AS collect_num FROM qing_collect GROUP BY goods_id) c ON `g`.`goods_id`=`c`.`goods_id` INNER JOIN `qing_goods_standard` `gs` ON `g`.`goods_id`=`gs`.`goods_id` INNER JOIN `qing_standard_value` `sv` ON FIND_IN_SET(sv.id, gs.sku) WHERE `goods_cate_id` = 3 AND `goods_status` = 1 AND `sv`.`standard_value` = '仙侠修真' ORDER BY `g`.`click` DESC LIMIT 10 [ RunTime:0.001618s ]
SELECT * FROM `qing_goods` `g` LEFT JOIN (SELECT goods_id,COUNT(id) AS collect_num FROM qing_collect GROUP BY goods_id) c ON `g`.`goods_id`=`c`.`goods_id` INNER JOIN `qing_goods_standard` `gs` ON `g`.`goods_id`=`gs`.`goods_id` INNER JOIN `qing_standard_value` `sv` ON FIND_IN_SET(sv.id, gs.sku) WHERE `goods_cate_id` = 3 AND `goods_status` = 1 AND `sv`.`standard_value` = '系统流' ORDER BY `g`.`click` DESC LIMIT 10 [ RunTime:0.001500s ]
SELECT * FROM `qing_ad` WHERE `type_id` = 9 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000653s ]
SELECT * FROM `qing_goods` `g` WHERE `goods_cate_id` = 3 AND `goods_status` = 1 AND `g`.`ishot` = '1' ORDER BY `g`.`listorder` ASC LIMIT 9 [ RunTime:0.000629s ]
SELECT * FROM `qing_goods` `g` WHERE `goods_cate_id` = 3 AND `goods_status` = 1 ORDER BY `g`.`time` DESC LIMIT 3 [ RunTime:0.000613s ]
