SHOW FULL COLUMNS FROM `h_classification` [ RunTime:0.002590s ]
SELECT `id` FROM `h_classification` WHERE ( json_contains(parent_ids,CONCAT(99)) ) [ RunTime:0.001158s ]
SHOW FULL COLUMNS FROM `h_area` [ RunTime:0.002017s ]
SELECT `id` FROM `h_area` WHERE ( json_contains(parent_ids,CONCAT(89)) ) [ RunTime:0.000903s ]
SHOW FULL COLUMNS FROM `h_exhibition` [ RunTime:0.002300s ]
SELECT `id`,`name`,`thumbnail`,`start_time`,`end_time`,`visit_num` FROM `h_exhibition` WHERE ( `status` = 1 AND `del` = 1 AND `class_id` IN (100,101,102,103,104,105,106,107,108,109,110,99) AND `area_id` IN (90,116,145,89) AND `start_time` BETWEEN '2025-08-01' AND '2025-08-31' ) ORDER BY `sort` DESC LIMIT 0,20 [ RunTime:0.002866s ]
SELECT COUNT(*) AS think_count FROM `h_exhibition` WHERE ( `status` = 1 AND `del` = 1 AND `class_id` IN (100,101,102,103,104,105,106,107,108,109,110,99) AND `area_id` IN (90,116,145,89) AND `start_time` BETWEEN '2025-08-01' AND '2025-08-31' ) [ RunTime:0.002325s ]
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.001421s ]
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.001111s ]
SHOW FULL COLUMNS FROM `h_information` [ RunTime:0.002177s ]
SELECT `id`,`name`,`create_time` FROM `h_information` WHERE ( `type` = 1 AND `status` = 1 AND `del` = 1 AND `class_id` = 99 ) ORDER BY `recommended_slot`,`visit_num` DESC,`sort` DESC LIMIT 16 [ RunTime:0.002223s ]
SELECT `id`,`name`,`create_time` FROM `h_information` WHERE ( `type` = 2 AND `status` = 1 AND `del` = 1 AND `class_id` = 99 ) ORDER BY `recommended_slot`,`visit_num` DESC,`sort` DESC LIMIT 16 [ RunTime:0.002142s ]
SELECT `id`,`name`,`create_time` FROM `h_information` WHERE ( `type` = 3 AND `status` = 1 AND `del` = 1 AND `class_id` = 99 ) ORDER BY `recommended_slot`,`visit_num` DESC,`sort` DESC LIMIT 16 [ RunTime:0.002006s ]
SELECT `id`,`name`,`create_time` FROM `h_information` WHERE ( `type` = 4 AND `status` = 1 AND `del` = 1 AND `class_id` = 99 ) ORDER BY `recommended_slot`,`visit_num` DESC,`sort` DESC LIMIT 16 [ RunTime:0.002013s ]