[ DB ] CONNECT:[ UseTime:0.000881s ] mysql:host=mysql06.dbs.71e.com;port=3306;dbname=db_cmactech_1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `auto_nav_menu` [ RunTime:0.001883s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 0 ORDER BY `list_order` [ RunTime:0.000465s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 35 ORDER BY `list_order` [ RunTime:0.000377s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 45 ORDER BY `list_order` [ RunTime:0.000365s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 42 ORDER BY `list_order` [ RunTime:0.000291s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 39 ORDER BY `list_order` [ RunTime:0.000308s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 36 ORDER BY `list_order` [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `status` = 1 AND `nav_id` = 2 AND `parent_id` = 0 ORDER BY `list_order` [ RunTime:0.000322s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 2 AND `parent_id` = 25 ORDER BY `list_order` [ RunTime:0.000314s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 2 AND `parent_id` = 29 ORDER BY `list_order` [ RunTime:0.000302s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 2 AND `parent_id` = 32 ORDER BY `list_order` [ RunTime:0.000290s ]
[ SQL ] SHOW COLUMNS FROM `auto_slide` [ RunTime:0.001213s ]
[ SQL ] SELECT * FROM `auto_slide` `a`,`auto_slide_item` `b` WHERE ( a.id=b.slide_id ) AND `a`.`name` = '底部二维码' LIMIT 1 [ RunTime:0.000388s ]
[ SQL ] SHOW COLUMNS FROM `auto_portal_category` [ RunTime:0.001196s ]
[ SQL ] SELECT * FROM `auto_portal_category` WHERE `name` = '案列' LIMIT 1 [ RunTime:0.000388s ]
[ SQL ] SHOW COLUMNS FROM `auto_link` [ RunTime:0.001169s ]
[ SQL ] SELECT * FROM `auto_link` WHERE `status` = 1 ORDER BY `list_order` [ RunTime:0.000365s ]
[ SQL ] SELECT * FROM `auto_portal_category` `a`,`auto_portal_category_post` `b`,`auto_portal_post` `c` WHERE ( a.id=b.category_id ) AND ( b.post_id=c.id ) AND `a`.`id` = 1 LIMIT 1 [ RunTime:0.000558s ]
[ SQL ] SHOW COLUMNS FROM `auto_mall_category` [ RunTime:0.001220s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `auto_mall_category` `a`,`auto_mall_item` `b` WHERE ( a.id=b.category_id ) AND `b`.`recommended` = 1 LIMIT 1 [ RunTime:0.000367s ]
[ SQL ] SELECT `b`.`id`,`b`.`thumbnail`,`b`.`title`,`b`.`titlem`,`a`.`namem`,`a`.`name` FROM `auto_mall_category` `a`,`auto_mall_item` `b` WHERE ( a.id=b.category_id ) AND `b`.`recommended` = 1 ORDER BY `b`.`list_order` LIMIT 0,2 [ RunTime:0.000375s ]
[ SQL ] SELECT * FROM `auto_portal_category` WHERE `delete_time` = 0 AND `id` = 74 ORDER BY `list_order` [ RunTime:0.000340s ]
[ SQL ] SELECT * FROM `auto_slide` `a`,`auto_slide_item` `b` WHERE ( a.id=b.slide_id ) AND `a`.`name` = '案列' LIMIT 1 [ RunTime:0.000304s ]
[ SQL ] SELECT * FROM `auto_portal_category` `a`,`auto_portal_category_post` `b`,`auto_portal_post` `c` WHERE ( a.id=b.category_id ) AND ( b.post_id=c.id ) AND `c`.`recommended` = 1 AND `c`.`delete_time` = 0 AND `a`.`parent_id` = 71 ORDER BY `c`.`create_time` DESC [ RunTime:0.001841s ]
[ SQL ] SELECT * FROM `auto_portal_category` `a`,`auto_portal_category_post` `b`,`auto_portal_post` `c` WHERE ( a.id=b.category_id ) AND ( b.post_id=c.id ) AND `c`.`id` = '84' LIMIT 1 [ RunTime:0.000489s ]
[ SQL ] SELECT * FROM `auto_portal_category` `a`,`auto_portal_category_post` `b`,`auto_portal_post` `c` WHERE ( a.id=b.category_id ) AND ( b.post_id=c.id ) AND ( c.id != 84 ) AND `a`.`id` = 74 AND ( c.id >= 84 ) AND ( c.delete_time = 0 ) ORDER BY `c`.`id` ASC,`c`.`id` DESC LIMIT 1 [ RunTime:0.001069s ]
[ SQL ] SELECT * FROM `auto_portal_category` `a`,`auto_portal_category_post` `b`,`auto_portal_post` `c` WHERE ( a.id=b.category_id ) AND ( b.post_id=c.id ) AND ( c.id != 84 ) AND `a`.`id` = 74 AND ( c.id <= 84 ) AND ( c.delete_time = 0 ) ORDER BY `c`.`id` DESC,`c`.`id` ASC LIMIT 1 [ RunTime:0.001198s ]
[ SQL ] SHOW COLUMNS FROM `auto_theme_file` [ RunTime:0.001257s ]
[ SQL ] SELECT `more` FROM `auto_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'caseshow/index' ) [ RunTime:0.000300s ]