2. SELECT `id`,`title`,`title_i18n`,`sign`,`tpl`,`baimg`,`type`,`link`,`target`,`banner`,`subtitle`,`subtitle_i18n`,`summary`,`summary_i18n`,`content`,`content_i18n`,`html_code`,`html_header`,`faq_goods`,`faq_goods_i18n`,`faq_other`,`faq_other_i18n`,`seo_longtail`,`seo_longtail_i18n`,`update_time`,`pid`,`is_parent`,`level`,`model_id`,`model_table`,`seo_title`,`seo_title_i18n`,`seo_kw`,`seo_kw_i18n`,`seo_desc`,`seo_desc_i18n`,`html_meta`,`ad_images`,`cate_images`,`bg_image` FROM `mvc_cate` WHERE `sign` IN ('raven-2','raven-2/') AND status=1 LIMIT 1
3. SELECT `sign` FROM `mvc_cate` WHERE `id` = 20 LIMIT 1
4. SELECT `id`,`title`,`title_i18n`,`sign`,`baimg`,`tpl`,`type`,`link`,`target`,`banner`,`subtitle`,`subtitle_i18n`,`update_time`,`pid`,`is_parent`,`level`,`model_id`,`model_table` FROM `mvc_cate` WHERE is_show=1 AND status=1 ORDER BY `sort` ASC,`id` ASC
5. SELECT *,`channel_i18n`,`server_i18n` FROM `mvc_classification` WHERE `channel` LIKE '%All Games/Raven 2%' AND `status` = 1 LIMIT 1
6. SELECT * FROM `mvc_allcoll` WHERE `channel` = 'Raven 2' LIMIT 1
7. SELECT COUNT(*) AS mvc_count FROM `mvc_goods` WHERE `channel` = 'Raven 2' AND status=1 LIMIT 1
8. SELECT *,`title_i18n`,`content_i18n`,`boostext_i18n` FROM `mvc_goods` WHERE `channel` = 'Raven 2' AND status=1 ORDER BY CASE WHEN (SELECT COUNT(*) FROM mvc_goods_tag WHERE id = mvc_goods.tag_id AND status = 1) > 0 THEN 0 ELSE 1 END ASC, (SELECT COALESCE(sort, 999999) FROM mvc_goods_tag WHERE id = mvc_goods.tag_id AND status = 1) ASC, tag_sort ASC, sort ASC, gid DESC, id ASC LIMIT 0,30
9. SELECT * FROM `mvc_language` WHERE `status` = 1 ORDER BY `is_default` DESC,`sort` ASC,`id` ASC
10. SELECT * FROM `mvc_config_group` WHERE `app` = 'index' AND `sign` = 'site' LIMIT 1
11. SELECT `field_value` FROM `mvc_config` WHERE `group_id` = 1 AND `field_name` = 'site_lang_show' AND `status` = 1 LIMIT 1
12. SELECT * FROM `mvc_config_group` WHERE `app` = 'index' AND `sign` = 'site' LIMIT 1
13. SELECT `field_value` FROM `mvc_config` WHERE `group_id` = 1 AND `field_name` = 'site_lang_show' AND `status` = 1 LIMIT 1
14. SELECT COUNT(*) AS mvc_count FROM `mvc_coshop` WHERE `channel` LIKE '%Raven 2%' AND status=1 LIMIT 1