SHOW FULL COLUMNS FROM `em_city` [ RunTime:0.018030s ]
SELECT `name` FROM `em_city` WHERE `en_name` = 'beijing' LIMIT 1 [ RunTime:0.001085s ]
SHOW FULL COLUMNS FROM `em_setting` [ RunTime:0.010314s ]
SELECT * FROM `em_setting` [ RunTime:0.006225s ]
SHOW FULL COLUMNS FROM `em_template` [ RunTime:0.039836s ]
SELECT * FROM `em_template` [ RunTime:0.000597s ]
SHOW FULL COLUMNS FROM `em_menu` [ RunTime:0.012346s ]
SELECT * FROM `em_menu` WHERE `del` = 0 AND `status` = 3 ORDER BY `listorder` ASC,`menu_id` ASC [ RunTime:0.002128s ]
SHOW FULL COLUMNS FROM `em_page` [ RunTime:0.012565s ]
SELECT `itemid`,`title` FROM `em_page` WHERE `del` = 0 AND `status` = 3 ORDER BY `listorder` ASC,`itemid` ASC [ RunTime:0.010137s ]
SHOW FULL COLUMNS FROM `em_category` [ RunTime:0.048428s ]
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.011784s ]
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.010618s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 3 AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.020941s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 4 AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.014099s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 5 AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.007895s ]
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.026138s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 14 AND `mid` = 2 ORDER BY `listorder` ASC,`cate_id` ASC [ RunTime:0.001920s ]
SHOW FULL COLUMNS FROM `em_ad` [ RunTime:0.008207s ]
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.006273s ]
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.004860s ]
SHOW FULL COLUMNS FROM `em_link` [ RunTime:0.024473s ]
SELECT `title`,`url` FROM `em_link` WHERE `del` = 0 AND `status` = 3 ORDER BY `is_level` DESC,`listorder` ASC,`itemid` DESC [ RunTime:0.008511s ]
SHOW FULL COLUMNS FROM `em_product` [ RunTime:0.022051s ]
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 3 [ RunTime:0.036474s ]
SELECT * FROM `em_city` WHERE `en_name` = 'beijing' LIMIT 1 [ RunTime:0.002464s ]
SELECT `aid`,`name`,`en_name` FROM `em_city` WHERE `pid` = 1 [ RunTime:0.004985s ]
SHOW FULL COLUMNS FROM `em_region` [ RunTime:0.011209s ]
SELECT `region_name`,`region_en_name` FROM `em_region` WHERE `del` = 0 ORDER BY `listorder` ASC,`region_id` DESC [ RunTime:0.002542s ]
SHOW FULL COLUMNS FROM `em_service` [ RunTime:0.008500s ]
SELECT * FROM `em_service` WHERE `del` = 0 AND `status` = 3 ORDER BY `listorder` ASC,`type_id` ASC,`itemid` DESC [ RunTime:0.004990s ]
SELECT `thumb`,`menu_name`,`menu_name_en` FROM `em_menu` WHERE `del` = 0 AND `menu_id` = 4 LIMIT 1 [ RunTime:0.004943s ]
SELECT `itemid`,`cate_id`,`title`,`tag`,`thumb`,`photo`,`keyword`,`intro`,`content`,`seo_title`,`seo_description`,`is_level`,`listorder`,`status`,`hits`,`linkurl`,`addtime`,`edittime`,`del`,`del_time` FROM `em_product` WHERE `del` = 0 AND `itemid` = 41 LIMIT 1 [ RunTime:0.017861s ]
UPDATE `em_product` SET `hits` = 32376 WHERE `del` = 0 AND `itemid` = 41 [ RunTime:0.008523s ]
SELECT `catename` FROM `em_category` WHERE `cate_id` = 3 LIMIT 1 [ RunTime:0.000668s ]
SELECT `itemid`,`title` FROM `em_product` WHERE `del` = 0 AND `status` = 3 AND `itemid` < 41 ORDER BY `edittime` DESC LIMIT 1 [ RunTime:0.001962s ]
SELECT `itemid`,`title` FROM `em_product` WHERE `del` = 0 AND `status` = 3 AND `itemid` > 41 ORDER BY `edittime` DESC LIMIT 1 [ RunTime:0.000840s ]
SELECT `cate_id`,`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` = 3 LIMIT 1 [ RunTime:0.002080s ]
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.023462s ]
SELECT `itemid`,`title`,`tag` FROM `em_product` WHERE `del` = 0 AND `status` = 3 AND `cate_id` = 1 ORDER BY `is_level` DESC,`listorder` ASC,`edittime` DESC [ RunTime:0.000942s ]
SELECT `itemid`,`title`,`tag` FROM `em_product` WHERE `del` = 0 AND `status` = 3 AND `cate_id` = 3 ORDER BY `is_level` DESC,`listorder` ASC,`edittime` DESC [ RunTime:0.003436s ]
SELECT `itemid`,`title`,`tag` FROM `em_product` WHERE `del` = 0 AND `status` = 3 AND `cate_id` = 4 ORDER BY `is_level` DESC,`listorder` ASC,`edittime` DESC [ RunTime:0.014089s ]
SELECT `itemid`,`title`,`tag` FROM `em_product` WHERE `del` = 0 AND `status` = 3 AND `cate_id` = 5 ORDER BY `is_level` DESC,`listorder` ASC,`edittime` DESC [ RunTime:0.022655s ]