SHOW FULL COLUMNS FROM `em_city` [ RunTime:0.002735s ]
SELECT `name` FROM `em_city` WHERE `en_name` = 'beijing' LIMIT 1 [ RunTime:0.000620s ]
SHOW FULL COLUMNS FROM `em_setting` [ RunTime:0.001619s ]
SELECT * FROM `em_setting` [ RunTime:0.000623s ]
SHOW FULL COLUMNS FROM `em_template` [ RunTime:0.001608s ]
SELECT * FROM `em_template` [ RunTime:0.000497s ]
SHOW FULL COLUMNS FROM `em_menu` [ RunTime:0.001517s ]
SELECT * FROM `em_menu` WHERE `del` = 0 ORDER BY `listorder` ASC,`menu_id` ASC [ RunTime:0.000696s ]
SHOW FULL COLUMNS FROM `em_page` [ RunTime:0.002442s ]
SELECT `itemid`,`title` FROM `em_page` WHERE `del` = 0 AND `status` = 3 ORDER BY `listorder` ASC,`itemid` ASC [ RunTime:0.000580s ]
SHOW FULL COLUMNS FROM `em_category` [ RunTime:0.001588s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 0 AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000662s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 1 AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000480s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 15 AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000444s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 16 AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000441s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 17 AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000638s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 0 AND `mid` = 4 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000422s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 23 AND `mid` = 4 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000484s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 24 AND `mid` = 4 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000527s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 0 AND `mid` = 3 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000509s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 21 AND `mid` = 3 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000396s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 22 AND `mid` = 3 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000421s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 0 AND `mid` = 2 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000458s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 18 AND `mid` = 2 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000545s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 20 AND `mid` = 2 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000474s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 19 AND `mid` = 2 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.000514s ]
SHOW FULL COLUMNS FROM `em_ad` [ RunTime:0.001629s ]
SELECT `title`,`thumb`,`url` FROM `em_ad` WHERE `del` = 0 AND `status` = 3 AND `cate_id` = 1 ORDER BY `listorder` ASC,`itemid` ASC [ RunTime:0.000558s ]
SELECT `title`,`thumb`,`url` FROM `em_ad` WHERE `del` = 0 AND `status` = 3 AND `cate_id` = 2 ORDER BY `listorder` ASC,`itemid` ASC [ RunTime:0.000434s ]
SHOW FULL COLUMNS FROM `em_link` [ RunTime:0.001613s ]
SELECT `title`,`url` FROM `em_link` WHERE `del` = 0 AND `status` = 3 ORDER BY `is_level` DESC,`listorder` ASC,`itemid` DESC [ RunTime:0.000383s ]
SELECT * FROM `em_city` WHERE `en_name` = 'beijing' LIMIT 1 [ RunTime:0.000659s ]
SELECT `aid`,`name`,`en_name` FROM `em_city` WHERE `pid` = 1 [ RunTime:0.000532s ]
SHOW FULL COLUMNS FROM `em_region` [ RunTime:0.001838s ]
SELECT `region_name`,`region_en_name` FROM `em_region` WHERE `del` = 0 ORDER BY `listorder` ASC,`region_id` DESC [ RunTime:0.001434s ]
SHOW FULL COLUMNS FROM `em_service` [ RunTime:0.001614s ]
SELECT * FROM `em_service` WHERE `del` = 0 AND `status` = 3 ORDER BY `listorder` ASC,`type_id` ASC,`itemid` DESC [ RunTime:0.000596s ]
SHOW FULL COLUMNS FROM `em_product` [ RunTime:0.001684s ]
SELECT `itemid`,`title`,`thumb` FROM `em_product` WHERE `del` = 0 AND `status` = 3 AND `thumb` <> '' ORDER BY `is_level` DESC,`listorder` ASC,`itemid` DESC LIMIT 8 [ RunTime:0.001836s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 0 AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` DESC [ RunTime:0.000664s ]
SHOW FULL COLUMNS FROM `em_album` [ RunTime:0.001588s ]
SELECT `itemid`,`title`,`thumb` FROM `em_album` WHERE `del` = 0 AND `status` = 3 AND `cate_id` = 23 AND `thumb` <> '' ORDER BY `is_level` DESC,`listorder` ASC,`itemid` DESC LIMIT 8 [ RunTime:0.000562s ]
SHOW FULL COLUMNS FROM `em_news` [ RunTime:0.001538s ]
SELECT `itemid`,`title`,`intro`,`thumb`,`edittime` FROM `em_news` WHERE `del` = 0 AND `status` = 3 AND `thumb` <> '' ORDER BY `is_level` DESC,`listorder` ASC,`itemid` DESC LIMIT 4 [ RunTime:0.001051s ]