SHOW FULL COLUMNS FROM `xnr_city_code` [ RunTime:0.000578s ]
SELECT *,city_name as list_name FROM `xnr_city_code` WHERE `CITY_CODE` = '310100' LIMIT 1 [ RunTime:0.000243s ]
SHOW FULL COLUMNS FROM `xnr_ski_shop` [ RunTime:0.000435s ]
SELECT COUNT(*) AS think_count FROM `xnr_ski_shop` WHERE `city_id` = 310100 AND ( `ski_shop_name` LIKE '%%' OR `ski_shop_short_name` LIKE '%%' ) [ RunTime:0.000334s ]
SELECT * FROM `xnr_ski_shop` WHERE `city_id` = 310100 AND ( `ski_shop_name` LIKE '%%' OR `ski_shop_short_name` LIKE '%%' ) ORDER BY `list_order` DESC LIMIT 0,18 [ RunTime:0.000439s ]
SHOW FULL COLUMNS FROM `xnr_theme_file` [ RunTime:0.000554s ]
SELECT * FROM `xnr_theme_file` WHERE `theme` = 'xuenarui' AND `file` = 'develop/ar' LIMIT 1 [ RunTime:0.000308s ]
SELECT `more`,`file`,`id` FROM `xnr_theme_file` WHERE `theme` = 'xuenarui' AND ( `is_public` = 1 OR `file` = 'skiarea/list-shop' ) ORDER BY `is_public` DESC [ RunTime:0.000543s ]
SHOW FULL COLUMNS FROM `xnr_nav` [ RunTime:0.000561s ]
SELECT `id` FROM `xnr_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.000171s ]
SHOW FULL COLUMNS FROM `xnr_nav_menu` [ RunTime:0.000430s ]
SELECT * FROM `xnr_nav_menu` WHERE `nav_id` = 3 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `xnr_link` [ RunTime:0.000661s ]
SELECT * FROM `xnr_link` WHERE `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000269s ]
