[ DB ] CONNECT:[ UseTime:0.001257s ] mysql:host=mysql06.dbs.71e.com;port=3306;dbname=db_tengxincom_1;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `auto_mall_category` [ RunTime:0.001991s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `auto_mall_category` `a`,`auto_mall_item` `b` WHERE ( a.id=b.category_id ) LIMIT 1 [ RunTime:0.000415s ]
[ SQL ] SELECT `b`.`title`,`b`.`thumbnail`,`b`.`id`,a.id as uid,`b`.`subtitle`,`b`.`subtitlem` FROM `auto_mall_category` `a`,`auto_mall_item` `b` WHERE ( a.id=b.category_id ) ORDER BY `b`.`list_order` LIMIT 0,8 [ RunTime:0.000382s ]
[ SQL ] SHOW COLUMNS FROM `auto_portal_post` [ RunTime:0.001441s ]
[ SQL ] SELECT * FROM `auto_portal_post` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000572s ]
[ SQL ] SHOW COLUMNS FROM `auto_nav_menu` [ RunTime:0.001219s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `status` = 1 AND `nav_id` = 1 AND `parent_id` = 0 ORDER BY `list_order` DESC [ RunTime:0.000345s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 84 ORDER BY `list_order` DESC [ RunTime:0.000302s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 85 ORDER BY `list_order` DESC [ RunTime:0.000257s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 86 ORDER BY `list_order` DESC [ RunTime:0.000395s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 87 ORDER BY `list_order` DESC [ RunTime:0.000497s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 88 ORDER BY `list_order` DESC [ RunTime:0.000330s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 89 ORDER BY `list_order` DESC [ RunTime:0.000268s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 178 ORDER BY `list_order` DESC [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 189 ORDER BY `list_order` DESC [ RunTime:0.000288s ]
[ SQL ] SELECT * FROM `auto_nav_menu` WHERE `status` = 1 AND `nav_id` = 2 AND `parent_id` = 0 ORDER BY `list_order` DESC [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `delete_time` = 0 AND `parent_id` = 3 ORDER BY `list_order` [ RunTime:0.000358s ]
[ SQL ] SHOW COLUMNS FROM `auto_portal_tag` [ RunTime:0.001193s ]
[ SQL ] SELECT * FROM `auto_portal_tag` WHERE `status` = 1 [ RunTime:0.000294s ]
[ SQL ] SELECT `b`.`title`,`b`.`thumbnail`,`b`.`contentr`,`b`.`id`,a.id as uid,`b`.`subtitle`,`b`.`subtitlem`,`b`.`titlem`,`b`.`category_id` FROM `auto_mall_category` `a`,`auto_mall_item` `b` WHERE ( a.id=b.category_id ) AND `b`.`recommended` = 1 ORDER BY `b`.`list_order` [ RunTime:0.000369s ]
[ SQL ] SHOW COLUMNS FROM `auto_slide` [ RunTime:0.001196s ]
[ SQL ] SELECT * FROM `auto_slide` `a`,`auto_slide_item` `b` WHERE ( a.id=b.slide_id ) AND `a`.`name` = '底部二維碼' ORDER BY `list_order` LIMIT 1 [ RunTime:0.000409s ]
[ SQL ] SHOW COLUMNS FROM `auto_link` [ RunTime:0.001194s ]
[ SQL ] SELECT * FROM `auto_link` WHERE `status` = 1 ORDER BY `list_order` [ RunTime:0.000383s ]
[ SQL ] SELECT `name` FROM `auto_mall_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000241s ]
[ SQL ] SHOW COLUMNS FROM `auto_portal_category` [ RunTime:0.001227s ]
[ SQL ] SELECT * FROM `auto_portal_category` WHERE `name` = '產品展示' LIMIT 1 [ RunTime:0.000374s ]
[ 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.000480s ]
[ SQL ] SELECT * FROM `auto_link` WHERE `status` = 1 ORDER BY `list_order` [ RunTime:0.000323s ]
[ SQL ] SELECT * FROM `auto_slide` `a`,`auto_slide_item` `b` WHERE ( a.id=b.slide_id ) AND `a`.`name` = '產品展示' ORDER BY `list_order` LIMIT 1 [ RunTime:0.000393s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `delete_time` = 0 AND `parent_id` = 3 ORDER BY `list_order` [ RunTime:0.000376s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `delete_time` = 0 AND `parent_id` = 4 ORDER BY `list_order` [ RunTime:0.000344s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `delete_time` = 0 AND `parent_id` = 5 ORDER BY `list_order` [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `delete_time` = 0 AND `parent_id` = 6 ORDER BY `list_order` [ RunTime:0.000339s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `delete_time` = 0 AND `parent_id` = 7 ORDER BY `list_order` [ RunTime:0.000323s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `delete_time` = 0 AND `parent_id` = 8 ORDER BY `list_order` [ RunTime:0.000305s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `delete_time` = 0 AND `parent_id` = 9 ORDER BY `list_order` [ RunTime:0.000356s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `delete_time` = 0 AND `parent_id` = 10 ORDER BY `list_order` [ RunTime:0.000337s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000316s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `parent_id` = 7 LIMIT 1 [ RunTime:0.000483s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000342s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `delete_time` = 0 AND `id` = 7 LIMIT 1 [ RunTime:0.000353s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `delete_time` = 0 [ RunTime:0.000381s ]
[ SQL ] SHOW COLUMNS FROM `auto_mall_item` [ RunTime:0.001387s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 1 [ RunTime:0.000554s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 2 [ RunTime:0.000557s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 3 [ RunTime:0.000521s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 4 [ RunTime:0.000580s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 5 [ RunTime:0.000560s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 6 [ RunTime:0.000532s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 7 [ RunTime:0.000531s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 8 [ RunTime:0.000549s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 9 [ RunTime:0.000471s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 10 [ RunTime:0.000509s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 11 [ RunTime:0.000541s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 12 [ RunTime:0.000542s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 13 [ RunTime:0.000489s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 14 [ RunTime:0.000511s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 15 [ RunTime:0.000487s ]
[ SQL ] SELECT * FROM `auto_mall_item` WHERE `category_id` = 16 [ RunTime:0.000481s ]
[ 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` = 125 ORDER BY `b`.`list_order`,`c`.`create_time` DESC [ RunTime:0.000440s ]
[ SQL ] SELECT * FROM `auto_mall_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000305s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `auto_mall_category` `a`,`auto_mall_item` `b` WHERE `a`.`id` = '7' AND ( a.id=b.category_id ) LIMIT 1 [ RunTime:0.000311s ]
[ SQL ] SELECT `b`.`barcoder`,`b`.`title`,`b`.`thumbnail`,`b`.`contentr`,`b`.`id`,a.id as uid,`b`.`subtitle`,`b`.`subtitlem`,`b`.`titlem`,`b`.`category_id` FROM `auto_mall_category` `a`,`auto_mall_item` `b` WHERE `a`.`id` = '7' AND ( a.id=b.category_id ) ORDER BY `b`.`list_order` LIMIT 0,9 [ RunTime:0.000325s ]
[ SQL ] SHOW COLUMNS FROM `auto_theme_file` [ RunTime:0.001199s ]
[ SQL ] SELECT `more` FROM `auto_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/product' ) [ RunTime:0.000280s ]