SHOW FULL COLUMNS FROM `em_city` [ RunTime:0.001350s ]
SELECT `name` FROM `em_city` WHERE `en_name` = 'xuancheng' LIMIT 1 [ RunTime:0.000554s ]
SHOW FULL COLUMNS FROM `em_setting` [ RunTime:0.000990s ]
SELECT * FROM `em_setting` WHERE `site` = 'cn' [ RunTime:0.000599s ]
SHOW FULL COLUMNS FROM `em_template` [ RunTime:0.022107s ]
SELECT * FROM `em_template` WHERE `site` = 'cn' [ RunTime:0.002444s ]
SHOW FULL COLUMNS FROM `em_menu` [ RunTime:0.005906s ]
SELECT `name` FROM `em_city` WHERE `en_name` = 'xuancheng' LIMIT 1 [ RunTime:0.001401s ]
SELECT * FROM `em_menu` WHERE `del` = 0 AND `status` = 3 AND `site` = 'cn' ORDER BY `listorder` ASC,`menu_id` ASC [ RunTime:0.001633s ]
SHOW FULL COLUMNS FROM `em_category` [ RunTime:0.007783s ]
SELECT `name` FROM `em_city` WHERE `en_name` = 'xuancheng' LIMIT 1 [ RunTime:0.002223s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 0 AND `site` = 'cn' AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000550s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 1 AND `site` = 'cn' AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.002106s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 2 AND `site` = 'cn' AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000906s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 3 AND `site` = 'cn' AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.013019s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 4 AND `site` = 'cn' AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.002540s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 5 AND `site` = 'cn' AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000437s ]
SELECT `name` FROM `em_city` WHERE `en_name` = 'xuancheng' LIMIT 1 [ RunTime:0.002016s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 0 AND `site` = 'cn' AND `mid` = 3 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.001532s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 15 AND `site` = 'cn' AND `mid` = 3 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000931s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 25 AND `site` = 'cn' AND `mid` = 3 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.001335s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 24 AND `site` = 'cn' AND `mid` = 3 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.004225s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 23 AND `site` = 'cn' AND `mid` = 3 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.001619s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 26 AND `site` = 'cn' AND `mid` = 3 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000884s ]
SELECT `name` FROM `em_city` WHERE `en_name` = 'xuancheng' LIMIT 1 [ RunTime:0.001908s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 0 AND `site` = 'cn' AND `mid` = 2 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.001576s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 13 AND `site` = 'cn' AND `mid` = 2 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.013777s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 14 AND `site` = 'cn' AND `mid` = 2 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.002135s ]
SHOW FULL COLUMNS FROM `em_ad` [ RunTime:0.005099s ]
SELECT `title`,`thumb`,`url` FROM `em_ad` WHERE `del` = 0 AND `status` = 3 AND `site` = 'cn' AND `cate_id` = 1 ORDER BY `listorder` ASC,`itemid` ASC [ RunTime:0.002027s ]
SELECT `title`,`thumb`,`url` FROM `em_ad` WHERE `del` = 0 AND `status` = 3 AND `site` = 'cn' AND `cate_id` = 2 ORDER BY `listorder` ASC,`itemid` ASC [ RunTime:0.002568s ]
SHOW FULL COLUMNS FROM `em_link` [ RunTime:0.003339s ]
SELECT `title`,`url` FROM `em_link` WHERE `del` = 0 AND `status` = 3 AND `site` = 'cn' ORDER BY `is_level` DESC,`listorder` ASC,`itemid` DESC [ RunTime:0.003700s ]
SELECT * FROM `em_city` WHERE `en_name` = 'xuancheng' LIMIT 1 [ RunTime:0.000659s ]
SELECT `aid`,`name`,`en_name` FROM `em_city` WHERE `pid` = 12 [ RunTime:0.002624s ]
SHOW FULL COLUMNS FROM `em_service` [ RunTime:0.008921s ]
SELECT * FROM `em_service` WHERE `del` = 0 AND `status` = 3 AND `site` = 'cn' ORDER BY `listorder` ASC,`type_id` ASC,`itemid` DESC [ RunTime:0.001682s ]
SHOW FULL COLUMNS FROM `em_product` [ RunTime:0.008080s ]
SELECT `itemid`,`title` FROM `em_product` WHERE `del` = 0 AND `status` = 3 AND `site` = 'cn' ORDER BY `is_level` DESC,`listorder` ASC,`itemid` DESC LIMIT 8 [ RunTime:0.002083s ]
SHOW FULL COLUMNS FROM `em_work` [ RunTime:0.003756s ]
SELECT `itemid`,`thumb`,`cate_id`,`title`,`edittime` FROM `em_work` WHERE `del` = 0 AND `status` = 3 AND `site` = 'cn' ORDER BY `is_level` DESC,`listorder` ASC,`itemid` DESC LIMIT 3 [ RunTime:0.014416s ]
SELECT `en_catename` FROM `em_category` WHERE `cate_id` = 15 AND `site` = 'cn' LIMIT 1 [ RunTime:0.002227s ]
SELECT `en_catename` FROM `em_category` WHERE `cate_id` = 15 AND `site` = 'cn' LIMIT 1 [ RunTime:0.005204s ]
SELECT `en_catename` FROM `em_category` WHERE `cate_id` = 24 AND `site` = 'cn' LIMIT 1 [ RunTime:0.002196s ]
SELECT `thumb`,`menu_name`,`menu_name_en` FROM `em_menu` WHERE `del` = 0 AND `menu_id` = 3 AND `site` = 'cn' LIMIT 1 [ RunTime:0.000453s ]
SELECT `itemid`,`site`,`cate_id`,`title`,`thumb`,`photo`,`keyword`,`intro`,`content`,`seo_title`,`seo_description`,`is_level`,`listorder`,`status`,`hits`,`addtime`,`edittime`,`del`,`del_time` FROM `em_product` WHERE `del` = 0 AND `itemid` = 50 AND `site` = 'cn' LIMIT 1 [ RunTime:0.008638s ]
UPDATE `em_product` SET `hits` = 99 WHERE `del` = 0 AND `itemid` = 50 AND `site` = 'cn' [ RunTime:0.005283s ]
SELECT `catename` FROM `em_category` WHERE `cate_id` = 5 AND `site` = 'cn' LIMIT 1 [ RunTime:0.001517s ]
SELECT `itemid`,`title` FROM `em_product` WHERE `del` = 0 AND `status` = 3 AND `site` = 'cn' AND `itemid` < 50 ORDER BY `edittime` DESC LIMIT 1 [ RunTime:0.001100s ]
SELECT `itemid`,`title` FROM `em_product` WHERE `del` = 0 AND `status` = 3 AND `site` = 'cn' AND `itemid` > 50 ORDER BY `edittime` DESC LIMIT 1 [ RunTime:0.000780s ]
SELECT `cate_id`,`site`,`parent_id`,`mid`,`catename`,`en_catename`,`keyword`,`icon`,`url`,`seo_title`,`seo_description`,`status`,`listorder`,`addtime`,`edittime`,`del`,`del_time` FROM `em_category` WHERE `del` = 0 AND `cate_id` = 5 AND `site` = 'cn' LIMIT 1 [ RunTime:0.004522s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `site` = 'cn' AND `parent_id` = 0 AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` DESC [ RunTime:0.001631s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 1 AND `site` = 'cn' AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` DESC [ RunTime:0.012262s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 2 AND `site` = 'cn' AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` DESC [ RunTime:0.000487s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 3 AND `site` = 'cn' AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` DESC [ RunTime:0.000405s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 4 AND `site` = 'cn' AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` DESC [ RunTime:0.000409s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 5 AND `site` = 'cn' AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` DESC [ RunTime:0.000429s ]