SHOW FULL COLUMNS FROM `qing_config` [ RunTime:0.003977s ]
SELECT `id`,`value` FROM `qing_config` [ RunTime:0.000949s ]
SHOW FULL COLUMNS FROM `qing_search` [ RunTime:0.003664s ]
SELECT * FROM `qing_search` ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001029s ]
SHOW FULL COLUMNS FROM `qing_cart` [ RunTime:0.003605s ]
SELECT COUNT(*) AS think_count FROM `qing_cart` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000669s ]
SHOW FULL COLUMNS FROM `qing_category` [ RunTime:0.003775s ]
SELECT * FROM `qing_category` WHERE `isnav` = 1 AND `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.001351s ]
SHOW FULL COLUMNS FROM `qing_ad` [ RunTime:0.003644s ]
SELECT * FROM `qing_ad` WHERE `type_id` = 2 [ RunTime:0.001793s ]
SELECT * FROM `qing_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.002202s ]
SELECT `id`,`parent_id` FROM `qing_category` [ RunTime:0.000827s ]
SHOW FULL COLUMNS FROM `qing_standard` [ RunTime:0.003300s ]
SELECT `name`,`id` FROM `qing_standard` WHERE `type_id` = 2 [ RunTime:0.000888s ]
SHOW FULL COLUMNS FROM `qing_standard_value` [ RunTime:0.003659s ]
SELECT `id`,`standard_value` FROM `qing_standard_value` WHERE `standard_id` = 3 [ RunTime:0.001320s ]
SHOW FULL COLUMNS FROM `qing_goods_standard` [ RunTime:0.006624s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('7', `sku`) LIMIT 1 [ RunTime:0.002642s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('8', `sku`) LIMIT 1 [ RunTime:0.001728s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('9', `sku`) LIMIT 1 [ RunTime:0.001620s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('90', `sku`) LIMIT 1 [ RunTime:0.001530s ]
SELECT `id`,`standard_value` FROM `qing_standard_value` WHERE `standard_id` = 5 [ RunTime:0.001570s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('14', `sku`) LIMIT 1 [ RunTime:0.001481s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('15', `sku`) LIMIT 1 [ RunTime:0.001356s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('52', `sku`) LIMIT 1 [ RunTime:0.001426s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('53', `sku`) LIMIT 1 [ RunTime:0.001223s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('54', `sku`) LIMIT 1 [ RunTime:0.001419s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('55', `sku`) LIMIT 1 [ RunTime:0.001489s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('56', `sku`) LIMIT 1 [ RunTime:0.001420s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('61', `sku`) LIMIT 1 [ RunTime:0.001112s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('62', `sku`) LIMIT 1 [ RunTime:0.000976s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('63', `sku`) LIMIT 1 [ RunTime:0.000891s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('64', `sku`) LIMIT 1 [ RunTime:0.000976s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('65', `sku`) LIMIT 1 [ RunTime:0.001478s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('66', `sku`) LIMIT 1 [ RunTime:0.000907s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('67', `sku`) LIMIT 1 [ RunTime:0.000866s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('68', `sku`) LIMIT 1 [ RunTime:0.000821s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('69', `sku`) LIMIT 1 [ RunTime:0.001185s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('70', `sku`) LIMIT 1 [ RunTime:0.001231s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('71', `sku`) LIMIT 1 [ RunTime:0.002002s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('72', `sku`) LIMIT 1 [ RunTime:0.001109s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('73', `sku`) LIMIT 1 [ RunTime:0.003272s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('74', `sku`) LIMIT 1 [ RunTime:0.000897s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('75', `sku`) LIMIT 1 [ RunTime:0.000597s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('76', `sku`) LIMIT 1 [ RunTime:0.000496s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('77', `sku`) LIMIT 1 [ RunTime:0.000413s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('78', `sku`) LIMIT 1 [ RunTime:0.000481s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('79', `sku`) LIMIT 1 [ RunTime:0.000519s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('86', `sku`) LIMIT 1 [ RunTime:0.000477s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('87', `sku`) LIMIT 1 [ RunTime:0.000496s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('88', `sku`) LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`standard_value` FROM `qing_standard_value` WHERE `standard_id` = 22 [ RunTime:0.000463s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('80', `sku`) LIMIT 1 [ RunTime:0.000517s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('81', `sku`) LIMIT 1 [ RunTime:0.000459s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('82', `sku`) LIMIT 1 [ RunTime:0.000530s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('83', `sku`) LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`standard_value` FROM `qing_standard_value` WHERE `standard_id` = 23 [ RunTime:0.000447s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('84', `sku`) LIMIT 1 [ RunTime:0.000966s ]
SELECT * FROM `qing_goods_standard` WHERE FIND_IN_SET('85', `sku`) LIMIT 1 [ RunTime:0.000499s ]
SHOW FULL COLUMNS FROM `qing_goods` [ RunTime:0.001556s ]
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.002052s ]
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.002004s ]
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.002194s ]
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.002036s ]
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.002383s ]
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.002043s ]
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.002412s ]
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.002244s ]
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.002264s ]
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.002110s ]
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.002011s ]
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.001751s ]
SELECT * FROM `qing_ad` WHERE `type_id` = 9 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000656s ]
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.000710s ]
SELECT * FROM `qing_goods` `g` WHERE `goods_cate_id` = 3 AND `goods_status` = 1 ORDER BY `g`.`time` DESC LIMIT 3 [ RunTime:0.000589s ]
