SHOW FULL COLUMNS FROM `g3ys_config` [ RunTime:0.002591s ]
SELECT `value` FROM `g3ys_config` WHERE `name` = 'timezone' AND `subsite_id` = '34' LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`type`,`name`,`value`,`is_lang` FROM `g3ys_config` WHERE `subsite_id` = '34' [ RunTime:0.001970s ]
SHOW FULL COLUMNS FROM `g3ys_lang` [ RunTime:0.003987s ]
SELECT * FROM `g3ys_lang` WHERE `subsite_id` = 34 AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001408s ]
SHOW FULL COLUMNS FROM `g3ys_config_lang` [ RunTime:0.002202s ]
SELECT `value`,`config_id` FROM `g3ys_config_lang` WHERE `config_id` IN (2976,2977,2978,2979,2980,2981,2988,2992) AND `lang` = 'en' [ RunTime:0.000775s ]
SHOW FULL COLUMNS FROM `g3ys_route` [ RunTime:0.002561s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '34' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000889s ]
SHOW FULL COLUMNS FROM `g3ys_theme` [ RunTime:0.004893s ]
SELECT `paginator` FROM `g3ys_theme` WHERE `module` = 'home' AND `name` = 'thaireit' AND `subsite_id` = '34' LIMIT 1 [ RunTime:0.000955s ]
SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.008247s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '34' LIMIT 1 [ RunTime:0.001342s ]
SELECT * FROM `g3ys_lang` WHERE `subsite_id` = 34 AND ( ( LOWER(name) = 'en' ) OR `subtag` = 'en' ) AND `status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001971s ]
SHOW FULL COLUMNS FROM `g3ys_category` [ RunTime:0.009898s ]
SELECT * FROM `g3ys_category` WHERE `subsite_id` = '34' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.009695s ]
SHOW FULL COLUMNS FROM `g3ys_category_lang` [ RunTime:0.004942s ]
SELECT * FROM `g3ys_category_lang` WHERE `subsite_id` = '34' AND `lang` = 'en' [ RunTime:0.004690s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.010378s ]
SELECT COUNT(*) AS think_count FROM `g3ys_document` `d` LEFT JOIN `g3ys_document_article` `a` ON `d`.`id`=`a`.`document_id` LEFT JOIN `g3ys_total` `t` ON `d`.`id`=`t`.`target_id` WHERE ( `d`.`status` = '1' AND `d`.`document_type` = '0' AND `d`.`subsite_id` IN ('0','34') AND 0 = 1 ) AND ( `d`.`title` LIKE '%恒生指数%' AND ( `a`.`content` LIKE '%恒生指数%' OR `d`.`keywords` LIKE '%恒生指数%' OR `d`.`description` LIKE '%恒生指数%' ) ) [ RunTime:0.003722s ]
SHOW FULL COLUMNS FROM `g3ys_subsite` [ RunTime:0.006821s ]
SELECT COUNT(*) AS think_count FROM `g3ys_subsite` WHERE ( `status` = 1 ) AND ( ( `title` LIKE '%恒生指数%' OR `name` LIKE '%恒生指数%' OR `company_name` LIKE '%恒生指数%' OR `username` LIKE '%恒生指数%' OR `phone` LIKE '%恒生指数%' OR `email` LIKE '%恒生指数%' ) ) [ RunTime:0.002869s ]
SELECT COUNT(*) AS think_count FROM `g3ys_category` WHERE ( `status` = 1 ) AND ( `title` LIKE '%恒生指数%' AND ( `name` LIKE '%恒生指数%' OR `description` LIKE '%恒生指数%' ) ) [ RunTime:0.003828s ]
SELECT `id`,`title`,`name`,`description`,`pic`,`model` FROM `g3ys_category` WHERE ( `status` = 1 ) AND ( `title` LIKE '%恒生指数%' AND ( `name` LIKE '%恒生指数%' OR `description` LIKE '%恒生指数%' ) ) ORDER BY `sort` ASC LIMIT 0,3 [ RunTime:0.010918s ]
SELECT count(*),`category_id` FROM `g3ys_document` WHERE `category_id` IN (884,938,1306) AND `status` = '1' GROUP BY `category_id` [ RunTime:0.001053s ]
SHOW FULL COLUMNS FROM `g3ys_tags` [ RunTime:0.005648s ]
SELECT COUNT(*) AS think_count FROM `g3ys_tags` `t` LEFT JOIN `g3ys_tags_lang` `tl` ON `tl`.`tags_id`=t.id AND tl.subsite_id = t.subsite_id AND tl.lang = "en" WHERE ( `t`.`status` = '1' ) AND `t`.`subsite_id` IN ('0','34') AND ( ( `t`.`title` LIKE '%恒生指数%' OR `t`.`name` LIKE '%恒生指数%' OR `t`.`description` LIKE '%恒生指数%' ) OR ( `tl`.`title` LIKE '%恒生指数%' OR `tl`.`keyword` LIKE '%恒生指数%' OR `tl`.`description` LIKE '%恒生指数%' ) ) [ RunTime:0.001543s ]
SHOW FULL COLUMNS FROM `g3ys_record_search` [ RunTime:0.006644s ]
SHOW FULL COLUMNS FROM `g3ys_seo_config` [ RunTime:0.008460s ]
SELECT `id`,`name`,`value`,`is_lang`,`subsite_id` FROM `g3ys_seo_config` WHERE `subsite_id` = 34 [ RunTime:0.002884s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '34' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001703s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '34' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002720s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '34' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001064s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '34' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.003028s ]
SELECT * FROM `g3ys_tags` WHERE `subsite_id` = 8 AND `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 15 [ RunTime:0.003210s ]
SELECT `id`,`type`,`name`,`value`,`is_lang` FROM `g3ys_config` WHERE `subsite_id` = '8' [ RunTime:0.007274s ]
SELECT `value`,`config_id` FROM `g3ys_config_lang` WHERE `config_id` IN (1933,1934,1935,1936,1945,1951) AND `lang` = 'zh-cn' [ RunTime:0.003720s ]
SELECT * FROM `g3ys_lang` WHERE `subsite_id` = 8 AND ( ( LOWER(name) = 'en' ) OR `subtag` = 'en' ) AND `status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001855s ]
SHOW FULL COLUMNS FROM `g3ys_tags_lang` [ RunTime:0.006839s ]
SELECT * FROM `g3ys_tags_lang` WHERE `tags_id` IN (1779,1772,1799,1781,1802,1805,1775,1813,1817,1815,1809,1801,1774,1796,1787) AND `subsite_id` = 8 AND `lang` = 'en-US' [ RunTime:0.001121s ]
SHOW TABLES LIKE 'g3ys_category_lang' [ RunTime:0.005394s ]
SELECT * FROM `g3ys_category_lang` WHERE `subsite_id` = '34' AND `category_id` = '2072' AND `lang` = 'en' LIMIT 1 [ RunTime:0.000987s ]
SELECT * FROM `g3ys_category_lang` WHERE `subsite_id` = '34' AND `category_id` = '2073' AND `lang` = 'en' LIMIT 1 [ RunTime:0.000861s ]
SELECT * FROM `g3ys_category_lang` WHERE `subsite_id` = '34' AND `category_id` = '2074' AND `lang` = 'en' LIMIT 1 [ RunTime:0.000831s ]
