SHOW FULL COLUMNS FROM `g3ys_config` [ RunTime:0.003467s ]
SELECT `value` FROM `g3ys_config` WHERE `name` = 'timezone' AND `subsite_id` = '37' LIMIT 1 [ RunTime:0.001597s ]
SHOW FULL COLUMNS FROM `g3ys_route` [ RunTime:0.003111s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001347s ]
SHOW FULL COLUMNS FROM `g3ys_theme` [ RunTime:0.006177s ]
SELECT `paginator` FROM `g3ys_theme` WHERE `module` = 'home' AND `name` = 'maju' AND `subsite_id` = '37' LIMIT 1 [ RunTime:0.003107s ]
SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.021877s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '37' LIMIT 1 [ RunTime:0.001804s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.015582s ]
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','37') AND 0 = 1 ) AND ( `d`.`title` LIKE '%种植业%' AND ( `a`.`content` LIKE '%种植业%' OR `d`.`keywords` LIKE '%种植业%' OR `d`.`description` LIKE '%种植业%' ) ) [ RunTime:0.004549s ]
SHOW FULL COLUMNS FROM `g3ys_subsite` [ RunTime:0.014525s ]
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.002036s ]
SHOW FULL COLUMNS FROM `g3ys_category` [ RunTime:0.012489s ]
SELECT COUNT(*) AS think_count FROM `g3ys_category` WHERE ( `status` = 1 ) AND ( `title` LIKE '%种植业%' AND ( `name` LIKE '%种植业%' OR `description` LIKE '%种植业%' ) ) [ RunTime:0.003509s ]
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.002152s ]
SELECT count(*),`category_id` FROM `g3ys_document` WHERE `category_id` = 990 AND `status` = '1' GROUP BY `category_id` [ RunTime:0.003929s ]
SHOW FULL COLUMNS FROM `g3ys_tags` [ RunTime:0.005267s ]
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','37') 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.003501s ]
SHOW FULL COLUMNS FROM `g3ys_record_search` [ RunTime:0.003670s ]
SHOW FULL COLUMNS FROM `g3ys_lang` [ RunTime:0.009204s ]
SELECT * FROM `g3ys_lang` WHERE `subsite_id` = 37 AND ( ( LOWER(name) = 'zh-tw' ) OR `subtag` = 'zh-tw' ) AND `status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.003306s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002910s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001739s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002265s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002773s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002842s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.005532s ]
SHOW FULL COLUMNS FROM `g3ys_total` [ RunTime:0.010261s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '5502' LIMIT 1 [ RunTime:0.003308s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001367s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001425s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '5501' LIMIT 1 [ RunTime:0.004388s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.003167s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000904s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '5500' LIMIT 1 [ RunTime:0.002141s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000903s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002830s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '5499' LIMIT 1 [ RunTime:0.004942s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.002761s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.004855s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '5498' LIMIT 1 [ RunTime:0.001461s ]
SELECT * FROM `g3ys_tags` WHERE `subsite_id` = 37 AND `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 15 [ RunTime:0.000802s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000984s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '37' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001000s ]