SHOW FULL COLUMNS FROM `platform_config` [ RunTime:0.001408s ]
SELECT * FROM `platform_config` WHERE ( `type` <> 'hidden' ) AND `platform_config`.`delete_time` IS NULL [ RunTime:0.000745s ]
SHOW FULL COLUMNS FROM `base_nav_list` [ RunTime:0.001698s ]
SELECT *,'' as sec_nav FROM `base_nav_list` WHERE `base_nav_list`.`delete_time` IS NULL ORDER BY `sort_num` ASC [ RunTime:0.000634s ]
SHOW FULL COLUMNS FROM `platform_single_page` [ RunTime:0.001247s ]
SELECT * FROM `platform_single_page` WHERE ( ( id in (2,1) ) ) AND `platform_single_page`.`delete_time` IS NULL [ RunTime:0.000608s ]
SHOW FULL COLUMNS FROM `platform_product_category` [ RunTime:0.001292s ]
SELECT * FROM `platform_product_category` WHERE `platform_product_category`.`delete_time` IS NULL ORDER BY `sort_num` ASC [ RunTime:0.000665s ]
SHOW FULL COLUMNS FROM `platform_case_category` [ RunTime:0.001289s ]
SELECT * FROM `platform_case_category` WHERE `platform_case_category`.`delete_time` IS NULL ORDER BY `sort_num` ASC [ RunTime:0.000962s ]
SHOW FULL COLUMNS FROM `base_slide` [ RunTime:0.001424s ]
SELECT * FROM `base_slide` WHERE `base_slide`.`delete_time` IS NULL ORDER BY `sort_num` ASC [ RunTime:0.000595s ]
SHOW FULL COLUMNS FROM `platform_link_url` [ RunTime:0.001418s ]
SELECT * FROM `platform_link_url` WHERE `platform_link_url`.`delete_time` IS NULL ORDER BY `sort_num` ASC [ RunTime:0.000522s ]
SELECT * FROM `base_nav_list` WHERE ( `id` = '4' ) AND `base_nav_list`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000565s ]
SHOW FULL COLUMNS FROM `platform_case` [ RunTime:0.001297s ]
SELECT * FROM `platform_case` WHERE ( `id` = '42' ) AND `platform_case`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.005781s ]
select * from `platform_case` where id = (select id from `platform_case` where id < 42 AND delete_time is null order by sort_num desc limit 1) [ RunTime:0.004574s ]
select * from `platform_case` where id = (select id from `platform_case` where id > 42 AND delete_time is null order by sort_num asc limit 1) [ RunTime:0.004698s ]
