SHOW FULL COLUMNS FROM `t_dictionary` [ RunTime:0.001488s ]
SELECT * FROM `t_dictionary` WHERE `is_del` = 0 AND `tag_id` = 0 ORDER BY `sortby` ASC,`id` ASC [ RunTime:0.000632s ]
SELECT * FROM `t_dictionary` WHERE `is_del` = 0 AND `tag_id` = 1 ORDER BY `root_id` ASC,`depth` ASC,`is_enable` DESC,`sortby` ASC,`id` ASC [ RunTime:0.000572s ]
SHOW FULL COLUMNS FROM `t_config` [ RunTime:0.001408s ]
SELECT * FROM `t_config` WHERE `is_del` = 0 AND `is_enable` = 1 AND `city_id` IN (0,1) ORDER BY `sortby` DESC,`id` ASC [ RunTime:0.001263s ]
SELECT * FROM `t_dictionary` WHERE `is_del` = 0 AND `tag_id` = 4 ORDER BY `root_id` ASC,`depth` ASC,`is_enable` DESC,`sortby` ASC,`id` ASC [ RunTime:0.000838s ]
SHOW FULL COLUMNS FROM `t_contents` [ RunTime:0.001747s ]
SELECT `id`,`ct_id`,`content` FROM `t_contents` WHERE `is_del` = 0 AND ( `model_id` = 90 AND `aid` = 6 ) ORDER BY `ct_id` ASC,`id` ASC LIMIT 20 [ RunTime:0.000505s ]
SHOW FULL COLUMNS FROM `t_search_index` [ RunTime:0.001996s ]
SELECT COUNT(*) AS think_count FROM `t_search_index` WHERE `model_id` = 20 AND `is_del` = 0 AND ( `city_id` = 1 ) AND ( MATCH (tag_index) AGAINST ('+c20id' IN BOOLEAN MODE) ) [ RunTime:0.000541s ]
SELECT `id`,`is_enable`,`model_id`,`target_id`,`tag_index`,`view_quantity`,`litpic`,`keywords`,`description`,`sortby`,`follow_quantity`,`like_quantity`,`update_at`,`search_key`,`title`,`cn_title` FROM `t_search_index` WHERE `model_id` = 20 AND `is_del` = 0 AND ( `city_id` = 1 ) AND ( MATCH (tag_index) AGAINST ('+c20id' IN BOOLEAN MODE) ) ORDER BY `is_enable` DESC,`sortby` DESC,`update_at` DESC LIMIT 0,10 [ RunTime:0.000612s ]
SHOW FULL COLUMNS FROM `t_shops` [ RunTime:0.001625s ]
SELECT `id`,`is_enable`,`tag_index`,`alias`,`sortby`,`shop_name`,`short_name`,`cn_shop_name`,`cn_short_name`,`sub_title`,`keywords`,`description`,`address`,`cn_address`,`phone`,`litpic`,`lat`,`lng`,`update_at` FROM `t_shops` WHERE `id` IN (11,10,3,1,5,4,2) ORDER BY FIELD(id, 11,10,3,1,5,4,2) LIMIT 10 [ RunTime:0.000671s ]
SHOW FULL COLUMNS FROM `t_dictionary_industry` [ RunTime:0.001802s ]
SELECT * FROM `t_dictionary_industry` WHERE `is_del` = 0 ORDER BY `root_id` ASC,`depth` ASC,`is_enable` DESC,`sortby` ASC,`id` ASC [ RunTime:0.000749s ]
SHOW FULL COLUMNS FROM `t_area` [ RunTime:0.001512s ]
SELECT * FROM `t_area` WHERE `is_del` = 0 AND `is_enable` = 1 AND `parent_area_id` = 0 ORDER BY `sortby` ASC,`id` ASC [ RunTime:0.000542s ]
SHOW FULL COLUMNS FROM `t_tags` [ RunTime:0.001633s ]
SELECT `tag_name`,`is_default` FROM `t_tags` WHERE ( `is_publish` = 1 ) ORDER BY `is_default` DESC,`search_quantity` DESC LIMIT 10 [ RunTime:0.000437s ]
SELECT `id`,`tag_name`,`search_quantity`,`use_quantity` FROM `t_tags` WHERE ( `is_publish` = 1 ) ORDER BY `search_quantity` DESC,`id` DESC LIMIT 10 [ RunTime:0.000726s ]