[ DB ] CONNECT:[ UseTime:0.000500s ] mysql:host=127.0.0.1;port=3306;dbname=ai;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tryine_banner_list` [ RunTime:0.002188s ]
[ SQL ] SELECT * FROM `tryine_banner_list` WHERE ( delete_flag = 1 and bl_location=5 ) ORDER BY `created_at` DESC LIMIT 1 [ RunTime:0.000457s ]
[ SQL ] SHOW COLUMNS FROM `tryine_link` [ RunTime:0.000834s ]
[ SQL ] SELECT * FROM `tryine_link` WHERE `type` = 1 AND `status` = 1 [ RunTime:0.000494s ]
[ SQL ] SHOW COLUMNS FROM `tryine_portal_category` [ RunTime:0.000915s ]
[ SQL ] SELECT * FROM `tryine_portal_category` WHERE ( type=1 AND delete_time=0 AND parent_id=0 and status=1 and (id<7 or id in(610,611) ) ) LIMIT 10 [ RunTime:0.000561s ]
[ SQL ] SELECT `id`,`name`,`description` FROM `tryine_portal_category` WHERE `id` = 11 LIMIT 1 [ RunTime:0.000292s ]
[ SQL ] SHOW COLUMNS FROM `tryine_portal_post` [ RunTime:0.000973s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `tryine_portal_post` `pp` LEFT JOIN `tryine_portal_category_post` `pcp` ON `pp`.`id`=`pcp`.`post_id` LEFT JOIN `tryine_portal_category` `pc` ON `pcp`.`category_id`=`pc`.`id` WHERE ( pp.delete_time=0 and post_type=1 and post_status=1 AND pcp.category_id=11 ) GROUP BY `pp`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000509s ]
[ SQL ] SELECT `pp`.*,name as className FROM `tryine_portal_post` `pp` LEFT JOIN `tryine_portal_category_post` `pcp` ON `pp`.`id`=`pcp`.`post_id` LEFT JOIN `tryine_portal_category` `pc` ON `pcp`.`category_id`=`pc`.`id` WHERE ( pp.delete_time=0 and post_type=1 and post_status=1 AND pcp.category_id=11 ) GROUP BY `pp`.`id` ORDER BY `pp`.`is_top` DESC,`pp`.`published_time` DESC LIMIT 0,10 [ RunTime:0.000863s ]
[ SQL ] SELECT `pp`.*,name as className FROM `tryine_portal_post` `pp` LEFT JOIN `tryine_portal_category_post` `pcp` ON `pp`.`id`=`pcp`.`post_id` LEFT JOIN `tryine_portal_category` `pc` ON `pcp`.`category_id`=`pc`.`id` WHERE ( pp.delete_time=0 and post_type=1 and post_status=1 and pc.id=12 ) ORDER BY `pp`.`is_top` DESC,`pp`.`published_time` DESC LIMIT 1 [ RunTime:0.000898s ]
[ SQL ] SELECT `pp`.*,name as className FROM `tryine_portal_post` `pp` LEFT JOIN `tryine_portal_category_post` `pcp` ON `pp`.`id`=`pcp`.`post_id` LEFT JOIN `tryine_portal_category` `pc` ON `pcp`.`category_id`=`pc`.`id` WHERE ( pp.delete_time=0 and post_type=1 and post_status=1 and recommended =1 and pc.id<7 ) GROUP BY `pp`.`id` ORDER BY `pp`.`is_top` DESC,`pp`.`published_time` DESC LIMIT 3 [ RunTime:0.004350s ]
[ SQL ] SELECT * FROM `tryine_banner_list` WHERE `bl_location` = '7' AND `delete_flag` = 1 AND `bl_status` = 1 ORDER BY `bl_order` ASC [ RunTime:0.000381s ]
[ SQL ] SHOW COLUMNS FROM `tryine_theme_file` [ RunTime:0.001293s ]
[ SQL ] SELECT * FROM `tryine_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000389s ]
[ SQL ] SHOW COLUMNS FROM `tryine_theme` [ RunTime:0.001131s ]
[ SQL ] UPDATE `tryine_theme` SET `name`='simpleboot3',`version`='1.0.2',`demo_url`='http://demo.thinkcmf.com',`author`='ThinkCMF',`lang`='zh-cn',`author_url`='http://www.thinkcmf.com',`keywords`='ThinkCMF模板',`description`='ThinkCMF默认模板' WHERE `theme` = 'simpleboot3' [ RunTime:0.004586s ]
[ SQL ] SELECT `more` FROM `tryine_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/news' ) [ RunTime:0.000335s ]
