SHOW FULL COLUMNS FROM `g3ys_config` [ RunTime:0.015251s ]
SELECT `value` FROM `g3ys_config` WHERE `name` = 'timezone' AND `subsite_id` = '38' LIMIT 1 [ RunTime:0.014248s ]
SHOW FULL COLUMNS FROM `g3ys_route` [ RunTime:0.004417s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001068s ]
SHOW FULL COLUMNS FROM `g3ys_theme` [ RunTime:0.005438s ]
SELECT `paginator` FROM `g3ys_theme` WHERE `module` = 'home' AND `name` = 'slogan' AND `subsite_id` = '38' LIMIT 1 [ RunTime:0.001005s ]
SHOW FULL COLUMNS FROM `g3ys_lang` [ RunTime:0.008169s ]
SELECT * FROM `g3ys_lang` WHERE `subsite_id` = 38 AND ( ( LOWER(name) = 'zh-tw' ) OR `subtag` = 'zh-tw' ) AND `status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.006805s ]
SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.025100s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '38' LIMIT 1 [ RunTime:0.008071s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.020323s ]
SELECT COUNT(*) AS think_count FROM `g3ys_document` `d` LEFT JOIN `g3ys_document_article` `a` ON `d`.`id`=`a`.`document_id` LEFT JOIN `g3ys_document_article_lang` `al` ON `al`.`document_id`=d.id AND al.subsite_id = d.subsite_id AND al.lang = "zh-TW" 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','38') AND `d`.`category_id` IN ('1464','1463','1462','1461','1466','2082','2083') ) AND ( `d`.`title` LIKE '%新能源%' OR `d`.`keywords` LIKE '%新能源%' OR `d`.`description` LIKE '%新能源%' OR `a`.`content` LIKE '%新能源%' OR `al`.`title` LIKE '%新能源%' OR `al`.`keywords` LIKE '%新能源%' OR `al`.`description` LIKE '%新能源%' OR `al`.`content` LIKE '%新能源%' ) [ RunTime:0.028569s ]
SELECT `d`.`id`,`d`.`name`,`d`.`title`,`d`.`keywords`,`d`.`description`,`a`.`content`,`d`.`category_id`,`d`.`create_time`,`d`.`update_time`,`d`.`pic`,t.view_total as views,al.title as lang_title,al.keywords as lang_keywords,al.description as lang_description,al.content as lang_content FROM `g3ys_document` `d` LEFT JOIN `g3ys_document_article` `a` ON `d`.`id`=`a`.`document_id` LEFT JOIN `g3ys_document_article_lang` `al` ON `al`.`document_id`=d.id AND al.subsite_id = d.subsite_id AND al.lang = "zh-TW" 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','38') AND `d`.`category_id` IN ('1464','1463','1462','1461','1466','2082','2083') ) AND ( `d`.`title` LIKE '%新能源%' OR `d`.`keywords` LIKE '%新能源%' OR `d`.`description` LIKE '%新能源%' OR `a`.`content` LIKE '%新能源%' OR `al`.`title` LIKE '%新能源%' OR `al`.`keywords` LIKE '%新能源%' OR `al`.`description` LIKE '%新能源%' OR `al`.`content` LIKE '%新能源%' ) ORDER BY `d`.`create_time` DESC LIMIT 0,10 [ RunTime:0.043532s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.004224s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.005305s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002569s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002155s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.009740s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.004664s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.004719s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.004396s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.004115s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001088s ]
SHOW FULL COLUMNS FROM `g3ys_subsite` [ RunTime:0.017442s ]
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.004714s ]
SHOW FULL COLUMNS FROM `g3ys_category` [ RunTime:0.013780s ]
SELECT COUNT(*) AS think_count FROM `g3ys_category` WHERE ( `status` = 1 ) AND ( `title` LIKE '%新能源%' AND ( `name` LIKE '%新能源%' OR `description` LIKE '%新能源%' ) ) [ RunTime:0.002124s ]
SHOW FULL COLUMNS FROM `g3ys_tags` [ RunTime:0.008485s ]
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 = "zh-tw" WHERE ( `t`.`status` = '1' ) AND `t`.`subsite_id` IN ('0','38') 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.005314s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.003850s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.003709s ]
SHOW FULL COLUMNS FROM `g3ys_record_search` [ RunTime:0.006479s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.003773s ]
SHOW FULL COLUMNS FROM `g3ys_ad_location` [ RunTime:0.006920s ]
SELECT * FROM `g3ys_ad_location` WHERE `name` = 'ad-full' AND `subsite_id` = '38' AND `status` = 1 LIMIT 1 [ RunTime:0.004284s ]
SHOW FULL COLUMNS FROM `g3ys_ad` [ RunTime:0.008075s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '38' AND `ad_location_id` = '75' AND `status` = 1 AND `device` IN ('all','pc') AND ( `start_time` = 0 OR `start_time` <= 1787579582 ) AND ( `end_time` = 0 OR `end_time` >= 1787579582 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.002405s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002295s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002814s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.004053s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002828s ]
SELECT * FROM `g3ys_ad_location` WHERE `name` = 'ad-right' AND `subsite_id` = '38' AND `status` = 1 LIMIT 1 [ RunTime:0.002345s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '38' AND `ad_location_id` = '76' AND `status` = 1 AND `device` IN ('all','pc') AND ( `start_time` = 0 OR `start_time` <= 1787579582 ) AND ( `end_time` = 0 OR `end_time` >= 1787579582 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.002846s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.004163s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.003605s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.003414s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.003046s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001248s ]
SELECT * FROM `g3ys_tags` WHERE `subsite_id` = 38 AND `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 15 [ RunTime:0.010821s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.004549s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001566s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '38' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001353s ]
