SHOW FULL COLUMNS FROM `h_classification` [ RunTime:0.002000s ]
SELECT `id` FROM `h_classification` WHERE ( json_contains(parent_ids,CONCAT(44)) ) [ RunTime:0.000856s ]
SHOW FULL COLUMNS FROM `h_area` [ RunTime:0.001525s ]
SELECT `id` FROM `h_area` WHERE ( json_contains(parent_ids,CONCAT(81)) ) [ RunTime:0.000723s ]
SHOW FULL COLUMNS FROM `h_exhibition` [ RunTime:0.001683s ]
SELECT `id`,`name`,`thumbnail`,`start_time`,`end_time`,`visit_num` FROM `h_exhibition` WHERE ( `status` = 1 AND `del` = 1 AND `class_id` IN (68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,44) AND `area_id` IN (82,83,84,85,88,110,112,115,118,119,120,121,122,123,124,125,126,127,128,129,130,147,148,156,157,159,162,163,165,166,167,168,169,170,171,172,81) ) ORDER BY `sort` DESC LIMIT 60,20 [ RunTime:0.002099s ]
SELECT COUNT(*) AS think_count FROM `h_exhibition` WHERE ( `status` = 1 AND `del` = 1 AND `class_id` IN (68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,44) AND `area_id` IN (82,83,84,85,88,110,112,115,118,119,120,121,122,123,124,125,126,127,128,129,130,147,148,156,157,159,162,163,165,166,167,168,169,170,171,172,81) ) [ RunTime:0.001826s ]
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.000985s ]
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.000784s ]
SHOW FULL COLUMNS FROM `h_information` [ RunTime:0.001627s ]
SELECT `id`,`name`,`create_time` FROM `h_information` WHERE ( `type` = 1 AND `status` = 1 AND `del` = 1 AND `class_id` = 44 ) ORDER BY `recommended_slot`,`visit_num` DESC,`sort` DESC LIMIT 16 [ RunTime:0.001431s ]
SELECT `id`,`name`,`create_time` FROM `h_information` WHERE ( `type` = 2 AND `status` = 1 AND `del` = 1 AND `class_id` = 44 ) ORDER BY `recommended_slot`,`visit_num` DESC,`sort` DESC LIMIT 16 [ RunTime:0.001360s ]
SELECT `id`,`name`,`create_time` FROM `h_information` WHERE ( `type` = 3 AND `status` = 1 AND `del` = 1 AND `class_id` = 44 ) ORDER BY `recommended_slot`,`visit_num` DESC,`sort` DESC LIMIT 16 [ RunTime:0.001310s ]
SELECT `id`,`name`,`create_time` FROM `h_information` WHERE ( `type` = 4 AND `status` = 1 AND `del` = 1 AND `class_id` = 44 ) ORDER BY `recommended_slot`,`visit_num` DESC,`sort` DESC LIMIT 16 [ RunTime:0.001315s ]