[ DB ] CONNECT:[ UseTime:1.046875s ] mysql:host=localhost;port=3306;dbname=a0629181349;charset=utf8
[ SQL ] SHOW COLUMNS FROM `mgtx_plugin` [ RunTime:0.000000s ]
[ SQL ] SELECT `config` FROM `mgtx_plugin` WHERE `name` = 'SwitchThemeDemo' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `mgtx_product_open_type` [ RunTime:0.000000s ]
[ SQL ] SELECT `name`,`type_id` FROM `mgtx_product_open_type` [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `mgtx_portal_post` [ RunTime:0.015625s ]
[ SQL ] SELECT * FROM `mgtx_portal_post` WHERE `post_type` = 2 AND ( `published_time` < 1545035000 AND `published_time` > 0 ) AND `post_status` = 1 AND `delete_time` = 0 AND `id` = 43 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `mgtx_theme_file` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/about' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/about',`name`='1.关于我们页',`more`='{\"vars\":[],\"widgets\":[]}',`config_more`='{\"vars\":[],\"widgets\":[]}',`description`='关于我们页模板文件',`is_public`=0,`list_order`=1 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/about' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/active_list' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/active_list',`name`='2.活动列表页',`more`='{\"vars\":[],\"widgets\":[]}',`config_more`='{\"vars\":[],\"widgets\":[]}',`description`='优惠活动列表页模板文件',`is_public`=0,`list_order`=2 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/active_list' [ RunTime:0.015625s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/contact' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/contact',`name`='3.联系我们页',`more`='{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"{:url(\'portal\\/index\\/index\')}\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]}},\"widgets\":[]}',`config_more`='{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"{:url(\'portal\\/index\\/index\')}\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]}},\"widgets\":[]}',`description`='联系我们页模板文件',`is_public`=0,`list_order`=3 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/contact' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/domain_index' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/domain_index',`name`='7.域名注册页',`more`='{\"vars\":[],\"widgets\":[]}',`config_more`='{\"vars\":[],\"widgets\":[]}',`description`='域名注册页模板文件',`is_public`=0,`list_order`=7 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/domain_index' [ RunTime:0.015625s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/help_home' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/help_home',`name`='8.帮助中心首页',`more`='{\"vars\":[],\"widgets\":[]}',`config_more`='{\"vars\":[],\"widgets\":[]}',`description`='帮助中心首页模板文件',`is_public`=0,`list_order`=8 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/help_home' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/join' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/join',`name`='10.代理加盟页',`more`='{\"vars\":[],\"widgets\":[]}',`config_more`='{\"vars\":[],\"widgets\":[]}',`description`='代理加盟页模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/join' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/link_list' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/link_list',`name`='4.友情链接页',`more`='{\"vars\":[],\"widgets\":[]}',`config_more`='{\"vars\":[],\"widgets\":[]}',`description`='友情链接页模板文件',`is_public`=0,`list_order`=4 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/link_list' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/news_home' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/news_home',`name`='9.新闻中心首页',`more`='{\"vars\":[],\"widgets\":[]}',`config_more`='{\"vars\":[],\"widgets\":[]}',`description`='新闻中心首页模板文件',`is_public`=0,`list_order`=9 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/news_home' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/page' LIMIT 1 [ RunTime:0.015625s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/page',`name`='单页面',`more`='{\"vars\":[],\"widgets\":[]}',`config_more`='{\"vars\":[],\"widgets\":[]}',`description`='单页面模板文件',`is_public`=0,`list_order`=1 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/page' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/payment' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/payment',`name`='5.付款方式页',`more`='{\"vars\":[],\"widgets\":[]}',`config_more`='{\"vars\":[],\"widgets\":[]}',`description`='付款方式页模板文件',`is_public`=0,`list_order`=5 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/payment' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/post_active' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Article/index',`file`='portal/page/post_active',`name`='优惠活动文章',`more`='{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',`config_more`='{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',`description`='优惠活动文章模板文件',`is_public`=0,`list_order`=2 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/post_active' [ RunTime:0.015625s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/post_default' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Article/index',`file`='portal/page/post_default',`name`=' 默认文章',`more`='{\"vars\":[]}',`config_more`='{\"vars\":[]}',`description`='新闻中心文章页模板文件',`is_public`=0,`list_order`=1 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/post_default' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/post_help' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Article/index',`file`='portal/page/post_help',`name`='帮助中心文章',`more`='{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',`config_more`='{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',`description`='帮助中心详情页模板文件',`is_public`=0,`list_order`=3 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/post_help' [ RunTime:0.015625s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/post_news' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Article/index',`file`='portal/page/post_news',`name`='新闻中心文章',`more`='{\"vars\":[]}',`config_more`='{\"vars\":[]}',`description`='新闻中心文章页模板文件',`is_public`=0,`list_order`=4 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/post_news' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/product' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/product',`name`='6.产品列表页',`more`='{\"vars\":[],\"widgets\":[]}',`config_more`='{\"vars\":[],\"widgets\":[]}',`description`='产品列表页模板文件',`is_public`=0,`list_order`=6 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/product' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/promoter' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/promoter',`name`='12.推广员页面',`more`='{\"vars\":[],\"widgets\":[]}',`config_more`='{\"vars\":[],\"widgets\":[]}',`description`='推广员页面模板文件',`is_public`=0,`list_order`=1 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/promoter' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/purchase' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/purchase',`name`='13.企业采购页面',`more`='{\"vars\":[],\"widgets\":[]}',`config_more`='{\"vars\":[],\"widgets\":[]}',`description`='推广员页面模板文件',`is_public`=0,`list_order`=1 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/purchase' [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND `file` = 'portal/page/service' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme_file` SET `theme`='mgtx',`action`='portal/Page/index',`file`='portal/page/service',`name`='11.服务标准页面',`more`='{\"vars\":[],\"widgets\":[]}',`config_more`='{\"vars\":[],\"widgets\":[]}',`description`='服务标准页面模板文件',`is_public`=0,`list_order`=11 WHERE `theme` = 'mgtx' AND `file` = 'portal/page/service' [ RunTime:0.015625s ]
[ SQL ] SELECT * FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `mgtx_theme` [ RunTime:0.000000s ]
[ SQL ] UPDATE `mgtx_theme` SET `name`='mgtx',`version`='1.0.2',`demo_url`='http://demo.thinkcmf.com',`author`='MGTX',`lang`='zh-cn',`author_url`='http://www.thinkcmf.com',`keywords`='名冠天下官网模板',`description`='名冠天下官网模板' WHERE `theme` = 'mgtx' [ RunTime:0.015625s ]
[ SQL ] SELECT `more` FROM `mgtx_theme_file` WHERE `theme` = 'mgtx' AND ( `is_public` = 1 OR `file` = 'portal/page/news_home' ) [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `mgtx_portal_category` [ RunTime:0.015625s ]
[ SQL ] SELECT * FROM `mgtx_portal_category` WHERE `parent_id` = 1 AND `status` = 1 ORDER BY `list_order` [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `mgtx_portal_category_post` [ RunTime:0.000000s ]
[ SQL ] SELECT `t2`.`id`,`t2`.`post_title`,`t2`.`published_time`,`t2`.`post_excerpt` FROM mgtx_portal_category_post t1 LEFT JOIN `mgtx_portal_post` `t2` ON `t1`.`post_id`=`t2`.`id` WHERE `delete_time` = 0 AND `t1`.`category_id` = 24 ORDER BY `t2`.`is_top` DESC LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM mgtx_portal_category_post t1 LEFT JOIN `mgtx_portal_post` `t2` ON `t1`.`post_id`=`t2`.`id` LEFT JOIN `mgtx_portal_category` `t3` ON `t1`.`category_id`=`t3`.`id` LEFT JOIN `mgtx_portal_tag_post` `t4` ON `t2`.`id`=`t4`.`post_id` LEFT JOIN `mgtx_portal_tag` `t5` ON `t4`.`tag_id`=`t5`.`id` WHERE `t1`.`category_id` = 24 AND `t2`.`delete_time` = 0 GROUP BY `t2`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `t3`.`id`,`t3`.`name`,`t2`.`id`,`t2`.`post_title`,`t2`.`more`,`t2`.`published_time`,`t2`.`post_excerpt`,t5.name tag_name,t5.id tag_id FROM mgtx_portal_category_post t1 LEFT JOIN `mgtx_portal_post` `t2` ON `t1`.`post_id`=`t2`.`id` LEFT JOIN `mgtx_portal_category` `t3` ON `t1`.`category_id`=`t3`.`id` LEFT JOIN `mgtx_portal_tag_post` `t4` ON `t2`.`id`=`t4`.`post_id` LEFT JOIN `mgtx_portal_tag` `t5` ON `t4`.`tag_id`=`t5`.`id` WHERE `t1`.`category_id` = 24 AND `t2`.`delete_time` = 0 GROUP BY `t2`.`id` ORDER BY `t1`.`id` DESC LIMIT 0,12 [ RunTime:0.000000s ]
[ SQL ] SELECT `t2`.`id`,`t2`.`post_title`,`t2`.`more`,`t2`.`post_content` FROM mgtx_portal_category_post t1 LEFT JOIN `mgtx_portal_post` `t2` ON `t1`.`post_id`=`t2`.`id` WHERE `t1`.`category_id` = 22 AND `t2`.`delete_time` = 0 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `mgtx_nav_menu` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_nav_menu` WHERE `nav_id` = 4 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `t2`.`id`,`t2`.`post_title` FROM `mgtx_portal_category_post` `t1` INNER JOIN `mgtx_portal_post` `t2` ON `t1`.`post_id`=`t2`.`id` WHERE `t2`.`published_time` <> 0 AND `t2`.`delete_time` = 0 AND `t1`.`category_id` = 22 ORDER BY `is_top` DESC,`list_order` ASC LIMIT 10 [ RunTime:0.000000s ]
[ SQL ] SELECT `t2`.`id`,`t2`.`post_title` FROM `mgtx_portal_category_post` `t1` INNER JOIN `mgtx_portal_post` `t2` ON `t1`.`post_id`=`t2`.`id` WHERE `t2`.`published_time` <> 0 AND `t2`.`delete_time` = 0 AND `t1`.`category_id` = 22 ORDER BY `is_top` DESC,`list_order` ASC LIMIT 10 [ RunTime:0.000000s ]
[ SQL ] SELECT `t2`.`id`,`t2`.`post_title` FROM `mgtx_portal_category_post` `t1` INNER JOIN `mgtx_portal_post` `t2` ON `t1`.`post_id`=`t2`.`id` WHERE `t2`.`published_time` <> 0 AND `t2`.`delete_time` = 0 AND `t1`.`category_id` = 22 ORDER BY `is_top` DESC,`list_order` ASC LIMIT 10 [ RunTime:0.000000s ]
[ SQL ] SELECT `t2`.`id`,`t2`.`post_title` FROM `mgtx_portal_category_post` `t1` INNER JOIN `mgtx_portal_post` `t2` ON `t1`.`post_id`=`t2`.`id` WHERE `t2`.`published_time` <> 0 AND `t2`.`delete_time` = 0 AND `t1`.`category_id` = 22 ORDER BY `is_top` DESC,`list_order` ASC LIMIT 10 [ RunTime:0.000000s ]
[ SQL ] SELECT `t2`.`id`,`t2`.`post_title` FROM `mgtx_portal_category_post` `t1` INNER JOIN `mgtx_portal_post` `t2` ON `t1`.`post_id`=`t2`.`id` WHERE `t2`.`published_time` <> 0 AND `t2`.`delete_time` = 0 AND `t1`.`category_id` = 22 ORDER BY `is_top` DESC,`list_order` ASC LIMIT 10 [ RunTime:0.000000s ]
[ SQL ] SELECT `t2`.`id`,`t2`.`post_title` FROM `mgtx_portal_category_post` `t1` INNER JOIN `mgtx_portal_post` `t2` ON `t1`.`post_id`=`t2`.`id` WHERE `t2`.`published_time` <> 0 AND `t2`.`delete_time` = 0 AND `t1`.`category_id` = 22 ORDER BY `is_top` DESC,`list_order` ASC LIMIT 10 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `mgtx_commodity_typeupgrade` [ RunTime:0.000000s ]
[ SQL ] SELECT `id`,`name`,`number`,`dh_photo`,`dh_photo_tow` FROM `mgtx_commodity_typeupgrade` WHERE ( `parent_id` = 0 AND `delete_time` = 0 ) AND `enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `id`,`number`,`name` FROM `mgtx_commodity_typeupgrade` WHERE `delete_time` = 0 AND `parent_id` = 77 AND `enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `id`,`number`,`name` FROM `mgtx_commodity_typeupgrade` WHERE `delete_time` = 0 AND `parent_id` = 22 AND `enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `id`,`number`,`name` FROM `mgtx_commodity_typeupgrade` WHERE `delete_time` = 0 AND `parent_id` = 20 AND `enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `id`,`number`,`name` FROM `mgtx_commodity_typeupgrade` WHERE `delete_time` = 0 AND `parent_id` = 31 AND `enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `id`,`number`,`name` FROM `mgtx_commodity_typeupgrade` WHERE `delete_time` = 0 AND `parent_id` = 73 AND `enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `id`,`number`,`name` FROM `mgtx_commodity_typeupgrade` WHERE `delete_time` = 0 AND `parent_id` = 34 AND `enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `id`,`number`,`name` FROM `mgtx_commodity_typeupgrade` WHERE `delete_time` = 0 AND `parent_id` = 137 AND `enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `id`,`number`,`name` FROM `mgtx_commodity_typeupgrade` WHERE `delete_time` = 0 AND `parent_id` = 30 AND `enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `id`,`number`,`name` FROM `mgtx_commodity_typeupgrade` WHERE `delete_time` = 0 AND `parent_id` = 134 AND `enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `id`,`number`,`name` FROM `mgtx_commodity_typeupgrade` WHERE `delete_time` = 0 AND `parent_id` = 75 AND `enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000000s ]
[ SQL ] SELECT `t2`.`id`,`t2`.`post_title` FROM `mgtx_portal_category_post` `t1` INNER JOIN `mgtx_portal_post` `t2` ON `t1`.`post_id`=`t2`.`id` WHERE `t2`.`published_time` <> 0 AND `t2`.`delete_time` = 0 AND `t1`.`category_id` = 22 ORDER BY `is_top` DESC,`list_order` ASC LIMIT 10 [ RunTime:0.000000s ]
[ SQL ] SELECT `t2`.`id`,`t2`.`post_title` FROM `mgtx_portal_category_post` `t1` INNER JOIN `mgtx_portal_post` `t2` ON `t1`.`post_id`=`t2`.`id` WHERE `t2`.`published_time` <> 0 AND `t2`.`delete_time` = 0 AND `t1`.`category_id` = 22 ORDER BY `is_top` DESC,`list_order` ASC LIMIT 10 [ RunTime:0.000000s ]
[ SQL ] SELECT `t1`.`id`,t2.id id2,t3.id id3 FROM mgtx_portal_category t1 LEFT JOIN `mgtx_portal_category` `t2` ON `t2`.`parent_id`=`t1`.`id` LEFT JOIN `mgtx_portal_category` `t3` ON `t3`.`parent_id`=`t2`.`id` WHERE `t1`.`parent_id` = 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `t2`.`id`,`t2`.`post_title`,`t2`.`published_time` FROM mgtx_portal_category_post t1 LEFT JOIN `mgtx_portal_post` `t2` ON `t1`.`post_id`=`t2`.`id` WHERE `delete_time` = 0 AND `t1`.`category_id` IN (1,23,24) GROUP BY `t2`.`id` ORDER BY `t2`.`post_hits` DESC LIMIT 5 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `mgtx_portal_tag_post` [ RunTime:0.000000s ]
[ SQL ] SELECT `name`,`id` FROM ( SELECT count(id) count,`tag_id` FROM `mgtx_portal_tag_post` GROUP BY `tag_id` ORDER BY `count` DESC LIMIT 20 ) t1 LEFT JOIN `mgtx_portal_tag` `t2` ON `t1`.`tag_id`=`t2`.`id` WHERE `t2`.`status` = 1 AND `t1`.`count` > 0 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `mgtx_adver_adverlist` [ RunTime:0.015625s ]
[ SQL ] SELECT `photos`,`adverUrl`,`id` FROM `mgtx_adver_adverlist` WHERE `enable` = 1 AND `delete_time` = 0 AND `position` = 9 ORDER BY `id` DESC [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `mgtx_nav_menu` WHERE `nav_id` = 2 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000000s ]
微信扫码联系客服
