SHOW FULL COLUMNS FROM `g3ys_config` [ RunTime:0.002548s ]
SELECT `value` FROM `g3ys_config` WHERE `name` = 'timezone' AND `subsite_id` = '26' LIMIT 1 [ RunTime:0.000630s ]
SHOW FULL COLUMNS FROM `g3ys_route` [ RunTime:0.002516s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '26' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000846s ]
SHOW FULL COLUMNS FROM `g3ys_theme` [ RunTime:0.003002s ]
SELECT `paginator` FROM `g3ys_theme` WHERE `module` = 'home' AND `name` = 'scientex' AND `subsite_id` = '26' LIMIT 1 [ RunTime:0.000667s ]
SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.003779s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '26' LIMIT 1 [ RunTime:0.000987s ]
SHOW FULL COLUMNS FROM `g3ys_lang` [ RunTime:0.002999s ]
SELECT * FROM `g3ys_lang` WHERE `subsite_id` = 26 AND ( ( LOWER(name) = 'zh-tw' ) OR `subtag` = 'zh-tw' ) AND `status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001150s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.004270s ]
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','26') AND 0 = 1 ) AND ( `d`.`title` LIKE '%贵州茅台%' AND ( `a`.`content` LIKE '%贵州茅台%' OR `d`.`keywords` LIKE '%贵州茅台%' OR `d`.`description` LIKE '%贵州茅台%' ) ) [ RunTime:0.000661s ]
SHOW FULL COLUMNS FROM `g3ys_subsite` [ RunTime:0.003055s ]
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.000974s ]
SHOW FULL COLUMNS FROM `g3ys_category` [ RunTime:0.003073s ]
SELECT COUNT(*) AS think_count FROM `g3ys_category` WHERE ( `status` = 1 ) AND ( `title` LIKE '%贵州茅台%' AND ( `name` LIKE '%贵州茅台%' OR `description` LIKE '%贵州茅台%' ) ) [ RunTime:0.001261s ]
SHOW FULL COLUMNS FROM `g3ys_tags` [ RunTime:0.001981s ]
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','26') 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.001102s ]
SHOW FULL COLUMNS FROM `g3ys_record_search` [ RunTime:0.002001s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '26' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001145s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '26' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000896s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '26' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000738s ]
SELECT * FROM `g3ys_tags` WHERE `subsite_id` = 1 AND `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 15 [ RunTime:0.000916s ]
SELECT * FROM `g3ys_lang` WHERE `subsite_id` = 1 AND ( ( LOWER(name) = 'zh-tw' ) OR `subtag` = 'zh-tw' ) AND `status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.002193s ]
SHOW FULL COLUMNS FROM `g3ys_tags_lang` [ RunTime:0.003071s ]
SELECT * FROM `g3ys_tags_lang` WHERE `tags_id` IN (21,20,19,18,17,16,15,14,13,12,11,10,9,8,7) AND `subsite_id` = 1 AND `lang` = 'zh-tw' [ RunTime:0.000949s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '26' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000792s ]
SHOW TABLES LIKE 'g3ys_category_lang' [ RunTime:0.002683s ]
SHOW FULL COLUMNS FROM `g3ys_category_lang` [ RunTime:0.002081s ]
SELECT * FROM `g3ys_category_lang` WHERE `subsite_id` = '26' AND `category_id` = '2052' AND `lang` = 'zh-TW' LIMIT 1 [ RunTime:0.000736s ]
SELECT * FROM `g3ys_category_lang` WHERE `subsite_id` = '26' AND `category_id` = '2053' AND `lang` = 'zh-TW' LIMIT 1 [ RunTime:0.000598s ]
SELECT * FROM `g3ys_category_lang` WHERE `subsite_id` = '26' AND `category_id` = '2054' AND `lang` = 'zh-TW' LIMIT 1 [ RunTime:0.000606s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '26' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000731s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '26' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000875s ]
