SHOW FULL COLUMNS FROM `h_classification` [ RunTime:0.009843s ]
SELECT `id` FROM `h_classification` WHERE ( json_contains(parent_ids,CONCAT(139)) ) [ RunTime:0.007736s ]
SHOW FULL COLUMNS FROM `h_area` [ RunTime:0.005636s ]
SELECT `id` FROM `h_area` WHERE ( json_contains(parent_ids,CONCAT(78)) ) [ RunTime:0.009787s ]
SHOW FULL COLUMNS FROM `h_exhibition` [ RunTime:0.013950s ]
SELECT `id`,`name`,`thumbnail`,`start_time`,`end_time`,`visit_num` FROM `h_exhibition` WHERE ( `status` = 1 AND `del` = 1 AND `class_id` IN (140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,139) AND `area_id` IN (79,80,99,108,131,132,133,134,135,146,149,151,152,153,154,160,164,173,78) ) ORDER BY `sort` DESC LIMIT 20,20 [ RunTime:0.021396s ]
SELECT COUNT(*) AS think_count FROM `h_exhibition` WHERE ( `status` = 1 AND `del` = 1 AND `class_id` IN (140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,139) AND `area_id` IN (79,80,99,108,131,132,133,134,135,146,149,151,152,153,154,160,164,173,78) ) [ RunTime:0.017132s ]
SELECT `id`,`name`,`icon`,`level`,`parent_id`,`parent_ids`,`status`,`del`,`del_time`,`update_time`,`create_time` FROM `h_classification` WHERE ( `status` = 1 AND `del` = 1 AND `level` < 3 ) ORDER BY `level` ASC [ RunTime:0.013424s ]
SELECT `id`,`name`,`level`,`parent_id`,`parent_ids`,`status`,`hot`,`del`,`del_time`,`update_time`,`create_time` FROM `h_area` WHERE ( `status` = 1 AND `del` = 1 ) ORDER BY `level` ASC [ RunTime:0.012639s ]
SHOW FULL COLUMNS FROM `h_information` [ RunTime:0.020334s ]
SELECT `id`,`name`,`create_time` FROM `h_information` WHERE ( `type` = 1 AND `status` = 1 AND `del` = 1 AND `class_id` = 139 ) ORDER BY `recommended_slot`,`visit_num` DESC,`sort` DESC LIMIT 16 [ RunTime:0.011997s ]
SELECT `id`,`name`,`create_time` FROM `h_information` WHERE ( `type` = 2 AND `status` = 1 AND `del` = 1 AND `class_id` = 139 ) ORDER BY `recommended_slot`,`visit_num` DESC,`sort` DESC LIMIT 16 [ RunTime:0.017680s ]
SELECT `id`,`name`,`create_time` FROM `h_information` WHERE ( `type` = 3 AND `status` = 1 AND `del` = 1 AND `class_id` = 139 ) ORDER BY `recommended_slot`,`visit_num` DESC,`sort` DESC LIMIT 16 [ RunTime:0.012115s ]
SELECT `id`,`name`,`create_time` FROM `h_information` WHERE ( `type` = 4 AND `status` = 1 AND `del` = 1 AND `class_id` = 139 ) ORDER BY `recommended_slot`,`visit_num` DESC,`sort` DESC LIMIT 16 [ RunTime:0.015037s ]
0 
市场分析
更多 
