[ DB ] CONNECT:[ UseTime:0.000894s ] mysql:host=39.106.214.242;port=3306;dbname=sp;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tryine_banner_list` [ RunTime:0.002273s ]
[ SQL ] SELECT * FROM `tryine_banner_list` WHERE ( delete_flag = 1 and bl_location=1 ) ORDER BY `created_at` DESC [ RunTime:0.000763s ]
[ SQL ] SHOW COLUMNS FROM `tryine_link` [ RunTime:0.001535s ]
[ SQL ] SELECT * FROM `tryine_link` WHERE `type` = 1 AND `status` = 1 [ RunTime:0.000624s ]
[ SQL ] SELECT * FROM `tryine_banner_list` WHERE `bl_location` = '1' AND `delete_flag` = 1 AND `bl_status` = 1 ORDER BY `bl_order` ASC [ RunTime:0.000597s ]
[ SQL ] SHOW COLUMNS FROM `tryine_case_list` [ RunTime:0.001669s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tryine_case_list` WHERE ( delete_flag=1 AND cl_type=1 ) LIMIT 1 [ RunTime:0.000552s ]
[ SQL ] SELECT * FROM `tryine_case_list` WHERE ( delete_flag=1 AND cl_type=1 ) ORDER BY `cl_id` DESC LIMIT 0,5 [ RunTime:0.000819s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tryine_link` WHERE ( status=1 AND type=2 ) LIMIT 1 [ RunTime:0.000564s ]
[ SQL ] SELECT * FROM `tryine_link` WHERE ( status=1 AND type=2 ) ORDER BY `list_order` ASC LIMIT 0,9 [ RunTime:0.000506s ]
[ SQL ] SHOW COLUMNS FROM `tryine_portal_post` [ RunTime:0.001547s ]
[ SQL ] SELECT `pp`.* 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<7 ) ORDER BY `pp`.`is_top` DESC,`pp`.`recommended` DESC,`pp`.`published_time` DESC LIMIT 4 [ RunTime:0.002767s ]
[ SQL ] SELECT `pp`.* 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=8 ) ORDER BY `pp`.`is_top` DESC,`pp`.`recommended` DESC,`pp`.`published_time` DESC LIMIT 2 [ RunTime:0.001589s ]
[ SQL ] SHOW COLUMNS FROM `tryine_company_info` [ RunTime:0.001484s ]
[ SQL ] SELECT * FROM `tryine_company_info` WHERE `ci_type` = 9 AND `delete_flag` = 1 [ RunTime:0.000660s ]
[ SQL ] SHOW COLUMNS FROM `tryine_theme_file` [ RunTime:0.001469s ]
[ SQL ] SELECT * FROM `tryine_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000534s ]
[ SQL ] SHOW COLUMNS FROM `tryine_theme` [ RunTime:0.001448s ]
[ 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.003705s ]
[ SQL ] SELECT `more` FROM `tryine_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ RunTime:0.000547s ]