SHOW FULL COLUMNS FROM `g3ys_config` [ RunTime:0.009493s ]
SELECT `value` FROM `g3ys_config` WHERE `name` = 'timezone' AND `subsite_id` = '41' LIMIT 1 [ RunTime:0.003569s ]
SHOW FULL COLUMNS FROM `g3ys_route` [ RunTime:0.008296s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002410s ]
SHOW FULL COLUMNS FROM `g3ys_theme` [ RunTime:0.003572s ]
SELECT `paginator` FROM `g3ys_theme` WHERE `module` = 'home' AND `name` = 'setsm' AND `subsite_id` = '41' LIMIT 1 [ RunTime:0.001323s ]
SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.005466s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '41' LIMIT 1 [ RunTime:0.001130s ]
SHOW FULL COLUMNS FROM `g3ys_lang` [ RunTime:0.005116s ]
SELECT * FROM `g3ys_lang` WHERE `subsite_id` = 41 AND ( ( LOWER(name) = 'en' ) OR `subtag` = 'en' ) AND `status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.002378s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.006666s ]
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','41') AND 0 = 1 ) AND ( `d`.`title` LIKE '%ETF%' AND ( `a`.`content` LIKE '%ETF%' OR `d`.`keywords` LIKE '%ETF%' OR `d`.`description` LIKE '%ETF%' ) ) [ RunTime:0.001016s ]
SHOW FULL COLUMNS FROM `g3ys_subsite` [ RunTime:0.004411s ]
SELECT COUNT(*) AS think_count FROM `g3ys_subsite` WHERE ( `status` = 1 ) AND ( ( `title` LIKE '%ETF%' OR `name` LIKE '%ETF%' OR `company_name` LIKE '%ETF%' OR `username` LIKE '%ETF%' OR `phone` LIKE '%ETF%' OR `email` LIKE '%ETF%' ) ) [ RunTime:0.001072s ]
SELECT `id`,`title`,`name`,`company_name`,`phone`,`email`,`icon`,`country`,`province`,`city`,`update_time` FROM `g3ys_subsite` WHERE ( `status` = 1 ) AND ( ( `title` LIKE '%ETF%' OR `name` LIKE '%ETF%' OR `company_name` LIKE '%ETF%' OR `username` LIKE '%ETF%' OR `phone` LIKE '%ETF%' OR `email` LIKE '%ETF%' ) ) ORDER BY `sort` DESC,`id` DESC LIMIT 0,5 [ RunTime:0.001011s ]
SHOW FULL COLUMNS FROM `g3ys_subsite_lang` [ RunTime:0.002737s ]
SELECT * FROM `g3ys_subsite_lang` WHERE `subsite_id` IN (44,36,35) AND `lang` = 'en' [ RunTime:0.002456s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001127s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001098s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001153s ]
SHOW FULL COLUMNS FROM `g3ys_category` [ RunTime:0.005073s ]
SELECT COUNT(*) AS think_count FROM `g3ys_category` WHERE ( `status` = 1 ) AND ( `title` LIKE '%ETF%' AND ( `name` LIKE '%ETF%' OR `description` LIKE '%ETF%' ) ) [ RunTime:0.001973s ]
SELECT `id`,`title`,`name`,`description`,`pic`,`model` FROM `g3ys_category` WHERE ( `status` = 1 ) AND ( `title` LIKE '%ETF%' AND ( `name` LIKE '%ETF%' OR `description` LIKE '%ETF%' ) ) ORDER BY `sort` ASC LIMIT 0,3 [ RunTime:0.001939s ]
SELECT count(*),`category_id` FROM `g3ys_document` WHERE `category_id` IN (1017,1007,1018) AND `status` = '1' GROUP BY `category_id` [ RunTime:0.000976s ]
SHOW FULL COLUMNS FROM `g3ys_tags` [ RunTime:0.005718s ]
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','41') AND ( ( `t`.`title` LIKE '%ETF%' OR `t`.`name` LIKE '%ETF%' OR `t`.`description` LIKE '%ETF%' ) OR ( `tl`.`title` LIKE '%ETF%' OR `tl`.`keyword` LIKE '%ETF%' OR `tl`.`description` LIKE '%ETF%' ) ) [ RunTime:0.003004s ]
SELECT `t`.`id`,`t`.`title`,`t`.`name`,`t`.`description`,`t`.`color`,`t`.`num`,`t`.`model_id`,tl.title as lang_title,tl.description as lang_description 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','41') AND ( ( `t`.`title` LIKE '%ETF%' OR `t`.`name` LIKE '%ETF%' OR `t`.`description` LIKE '%ETF%' ) OR ( `tl`.`title` LIKE '%ETF%' OR `tl`.`keyword` LIKE '%ETF%' OR `tl`.`description` LIKE '%ETF%' ) ) ORDER BY `num` DESC LIMIT 0,3 [ RunTime:0.002078s ]
SHOW FULL COLUMNS FROM `g3ys_record_search` [ RunTime:0.005081s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001278s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001457s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001166s ]
SELECT * FROM `g3ys_tags` WHERE `subsite_id` = 41 AND `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.000920s ]
SHOW FULL COLUMNS FROM `g3ys_tags_lang` [ RunTime:0.003030s ]
SELECT * FROM `g3ys_tags_lang` WHERE `tags_id` IN (2533,2536,2531,2535,2534,2539,2532,2537) AND `subsite_id` = 41 AND `lang` = 'en' [ RunTime:0.001497s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001317s ]
SELECT * FROM `g3ys_tags` WHERE `subsite_id` = 41 AND `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 8 [ RunTime:0.001304s ]
SELECT * FROM `g3ys_tags_lang` WHERE `tags_id` IN (2533,2536,2531,2535,2534,2539,2532,2537) AND `subsite_id` = 41 AND `lang` = 'en' [ RunTime:0.002548s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001300s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001187s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001144s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001307s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001499s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001029s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001134s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000902s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001029s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001067s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001060s ]
SELECT * FROM `g3ys_tags` WHERE `subsite_id` = 41 AND `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 15 [ RunTime:0.001151s ]
SELECT * FROM `g3ys_tags_lang` WHERE `tags_id` IN (2533,2536,2531,2535,2534,2539,2532,2537,2530,2538) AND `subsite_id` = 41 AND `lang` = 'en' [ RunTime:0.000892s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002572s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001366s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000976s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001793s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001792s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '41' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000867s ]
