SHOW FULL COLUMNS FROM `em_city` [ RunTime:0.002117s ]
SELECT `name` FROM `em_city` WHERE `en_name` = 'jiayuguan' LIMIT 1 [ RunTime:0.014076s ]
SHOW FULL COLUMNS FROM `em_setting` [ RunTime:0.030037s ]
SELECT * FROM `em_setting` [ RunTime:0.000798s ]
SHOW FULL COLUMNS FROM `em_template` [ RunTime:0.014197s ]
SELECT * FROM `em_template` [ RunTime:0.000605s ]
SHOW FULL COLUMNS FROM `em_menu` [ RunTime:0.001338s ]
SELECT * FROM `em_menu` WHERE `del` = 0 AND `status` = 3 ORDER BY `listorder` ASC,`menu_id` ASC [ RunTime:0.000997s ]
SHOW FULL COLUMNS FROM `em_page` [ RunTime:0.001481s ]
SELECT `itemid`,`title` FROM `em_page` WHERE `del` = 0 AND `status` = 3 ORDER BY `listorder` ASC,`itemid` ASC [ RunTime:0.005682s ]
SHOW FULL COLUMNS FROM `em_category` [ RunTime:0.001981s ]
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.000779s ]
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.005594s ]
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.001284s ]
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.000803s ]
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.000870s ]
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.001606s ]
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.004096s ]
SHOW FULL COLUMNS FROM `em_ad` [ RunTime:0.015589s ]
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.004285s ]
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.000977s ]
SHOW FULL COLUMNS FROM `em_link` [ RunTime:0.002018s ]
SELECT `title`,`url` FROM `em_link` WHERE `del` = 0 AND `status` = 3 ORDER BY `is_level` DESC,`listorder` ASC,`itemid` DESC [ RunTime:0.000875s ]
SHOW FULL COLUMNS FROM `em_product` [ RunTime:0.004210s ]
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.044335s ]
SELECT * FROM `em_city` WHERE `en_name` = 'jiayuguan' LIMIT 1 [ RunTime:0.005550s ]
SELECT `aid`,`name`,`en_name` FROM `em_city` WHERE `pid` = 339 [ RunTime:0.003766s ]
SHOW FULL COLUMNS FROM `em_region` [ RunTime:0.009584s ]
SELECT `region_name`,`region_en_name` FROM `em_region` WHERE `del` = 0 ORDER BY `listorder` ASC,`region_id` DESC [ RunTime:0.026256s ]
SHOW FULL COLUMNS FROM `em_service` [ RunTime:0.025400s ]
SELECT * FROM `em_service` WHERE `del` = 0 AND `status` = 3 ORDER BY `listorder` ASC,`type_id` ASC,`itemid` DESC [ RunTime:0.001400s ]
SELECT `thumb`,`menu_name`,`menu_name_en` FROM `em_menu` WHERE `del` = 0 AND `menu_id` = 6 LIMIT 1 [ RunTime:0.002203s ]
SHOW FULL COLUMNS FROM `em_news` [ RunTime:0.024212s ]
SELECT COUNT(*) AS think_count FROM `em_news` WHERE `del` = 0 AND `status` = 3 LIMIT 1 [ RunTime:0.015741s ]
SELECT * FROM `em_news` WHERE `del` = 0 AND `status` = 3 ORDER BY `is_level` DESC,`listorder` ASC,`edittime` DESC LIMIT 0,20 [ RunTime:0.002840s ]
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` DESC [ RunTime:0.058525s ]
SELECT `cate_id`,`catename`,`en_catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 14 AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` DESC [ RunTime:0.022032s ]
136-3708-0871
