SHOW FULL COLUMNS FROM `em_city` [ RunTime:0.014110s ]
SELECT `name` FROM `em_city` WHERE `en_name` = 'huaian' LIMIT 1 [ RunTime:0.004827s ]
SHOW FULL COLUMNS FROM `em_setting` [ RunTime:0.005492s ]
SELECT * FROM `em_setting` [ RunTime:0.005398s ]
SHOW FULL COLUMNS FROM `em_template` [ RunTime:0.033376s ]
SELECT * FROM `em_template` [ RunTime:0.031588s ]
SHOW FULL COLUMNS FROM `em_menu` [ RunTime:0.022568s ]
SELECT * FROM `em_menu` WHERE `del` = 0 AND `status` = 3 ORDER BY `listorder` ASC,`menu_id` ASC [ RunTime:0.001495s ]
SHOW FULL COLUMNS FROM `em_page` [ RunTime:0.008172s ]
SELECT `itemid`,`title` FROM `em_page` WHERE `del` = 0 AND `status` = 3 ORDER BY `listorder` ASC,`itemid` ASC [ RunTime:0.020864s ]
SHOW FULL COLUMNS FROM `em_category` [ RunTime:0.031691s ]
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.011136s ]
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.011298s ]
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.004833s ]
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.017636s ]
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.004698s ]
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.027673s ]
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.019103s ]
SHOW FULL COLUMNS FROM `em_ad` [ RunTime:0.007898s ]
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.011389s ]
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.003578s ]
SHOW FULL COLUMNS FROM `em_link` [ RunTime:0.004558s ]
SELECT `title`,`url` FROM `em_link` WHERE `del` = 0 AND `status` = 3 ORDER BY `is_level` DESC,`listorder` ASC,`itemid` DESC [ RunTime:0.012445s ]
SHOW FULL COLUMNS FROM `em_product` [ RunTime:0.079264s ]
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.000961s ]
SELECT * FROM `em_city` WHERE `en_name` = 'huaian' LIMIT 1 [ RunTime:0.009476s ]
SELECT `aid`,`name`,`en_name` FROM `em_city` WHERE `pid` = 118 [ RunTime:0.030270s ]
SHOW FULL COLUMNS FROM `em_service` [ RunTime:0.001898s ]
SELECT * FROM `em_service` WHERE `del` = 0 AND `status` = 3 ORDER BY `listorder` ASC,`type_id` ASC,`itemid` DESC [ RunTime:0.001358s ]
SELECT `thumb`,`menu_name`,`menu_name_en` FROM `em_menu` WHERE `del` = 0 AND `menu_id` = 4 LIMIT 1 [ RunTime:0.000986s ]
SELECT `cate_id`,`catename` FROM `em_category` WHERE `del` = 0 AND `en_catename` = 'strzTFM' LIMIT 1 [ RunTime:0.000847s ]
SELECT `cate_id`,`catename` FROM `em_category` WHERE `del` = 0 AND `status` = 3 AND `parent_id` = 4 AND `mid` = 1 ORDER BY `listorder` ASC,`cate_id` DESC [ RunTime:0.014508s ]
SELECT COUNT(*) AS think_count FROM `em_product` WHERE `del` = 0 AND `status` = 3 AND `cate_id` = 4 LIMIT 1 [ RunTime:0.001129s ]
SELECT * FROM `em_product` WHERE `del` = 0 AND `status` = 3 AND `cate_id` = 4 ORDER BY `is_level` DESC,`listorder` ASC,`edittime` DESC LIMIT 0,15 [ RunTime:0.052595s ]
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.045133s ]
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.001448s ]
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.011662s ]
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.041993s ]
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.048104s ]