SHOW FULL COLUMNS FROM `zdy_model` [ RunTime:0.000545s ]
SELECT `url`,`route`,`func` FROM `zdy_model` [ RunTime:0.000225s ]
SHOW FULL COLUMNS FROM `zdy_article` [ RunTime:0.000455s ]
SELECT `id`,`url` FROM `zdy_article` [ RunTime:0.002398s ]
SHOW FULL COLUMNS FROM `zdy_config` [ RunTime:0.000422s ]
SELECT `value`,`name` FROM `zdy_config` [ RunTime:0.000214s ]
SHOW FULL COLUMNS FROM `zdy_nav` [ RunTime:0.000409s ]
SELECT n.id,n.name,n.en_name,n.pid,n.mid,m.url,m.nid,count(a.id) as count FROM `zdy_nav` `n` LEFT JOIN `zdy_model` `m` ON `n`.`mid`=`m`.`id` LEFT JOIN `zdy_article` `a` ON `n`.`id`=a.nid and a.hide=0 WHERE `n`.`nav` = '1' GROUP BY `n`.`id` ORDER BY `n`.`sort` [ RunTime:0.008734s ]
SELECT `url` FROM `zdy_model` WHERE `model` = 'article' LIMIT 1 [ RunTime:0.000267s ]
SELECT `value` FROM `zdy_config` WHERE `name` = 'mapkey' LIMIT 1 [ RunTime:0.000209s ]
UPDATE `zdy_article` SET `hide` = 0 WHERE `hide` = 1 AND `time` > 1759833411 AND `time` < 1759919811 [ RunTime:0.008095s ]
SELECT * FROM `zdy_model` WHERE `model` = 'news' LIMIT 1 [ RunTime:0.000271s ]
SELECT * FROM `zdy_nav` WHERE `mid` = 5 AND `pid` = 0 LIMIT 1 [ RunTime:0.000289s ]
SELECT * FROM `zdy_nav` WHERE `id` = 42 LIMIT 1 [ RunTime:0.000241s ]
SELECT n.id,n.name,m.url,m.nid,count(a.id) as count FROM `zdy_nav` `n` LEFT JOIN `zdy_model` `m` ON `n`.`mid`=`m`.`id` LEFT JOIN `zdy_article` `a` ON `n`.`id`=`a`.`nid` LEFT JOIN `zdy_arttag` `t` ON `a`.`id`=`t`.`aid` WHERE `n`.`pid` = '5' AND `n`.`hide` = '0' AND `a`.`hide` = '0' GROUP BY `n`.`id` ORDER BY `n`.`sort` [ RunTime:0.003616s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `zdy_article` `a` LEFT JOIN `zdy_author` `z` ON `a`.`author`=`z`.`id` LEFT JOIN `zdy_classart` `c` ON `a`.`id`=`c`.`aid` LEFT JOIN `zdy_arttag` `t` ON `a`.`id`=`t`.`aid` WHERE `time` < 1759919811 AND `hide` = 0 AND `nid` = 42 GROUP BY `a`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.008959s ]
SELECT `a`.`id`,`a`.`title`,`a`.`img`,`a`.`url`,`a`.`time`,`a`.`click`,`z`.`name`,z.img as icon FROM `zdy_article` `a` LEFT JOIN `zdy_author` `z` ON `a`.`author`=`z`.`id` LEFT JOIN `zdy_classart` `c` ON `a`.`id`=`c`.`aid` LEFT JOIN `zdy_arttag` `t` ON `a`.`id`=`t`.`aid` WHERE `time` < 1759919811 AND `hide` = 0 AND `nid` = 42 GROUP BY `a`.`id` ORDER BY `time` DESC LIMIT 0,20 [ RunTime:0.016730s ]
SELECT `url` FROM `zdy_model` WHERE `model` = 'article' LIMIT 1 [ RunTime:0.000243s ]
SHOW FULL COLUMNS FROM `zdy_class` [ RunTime:0.000424s ]
SELECT c.id,c.name,c.pid,count(a.id) as count FROM `zdy_class` `c` LEFT JOIN `zdy_classart` `ca` ON `c`.`id`=`ca`.`cid` LEFT JOIN `zdy_article` `a` ON `ca`.`aid`=a.id and a.hide=0 and a.nid in (42) LEFT JOIN `zdy_arttag` `t` ON `a`.`id`=`t`.`aid` WHERE `c`.`hide` = '0' GROUP BY `c`.`id` [ RunTime:0.008334s ]
SELECT `value`,`name` FROM `zdy_config` WHERE `name` IN ('seotit','seodesc') [ RunTime:0.000241s ]
SHOW FULL COLUMNS FROM `zdy_ads` [ RunTime:0.000405s ]
SELECT * FROM `zdy_ads` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000238s ]
SELECT `n`.`id`,`n`.`name`,`n`.`pid`,`m`.`url`,`m`.`nid` FROM `zdy_nav` `n` INNER JOIN `zdy_model` `m` ON `n`.`mid`=`m`.`id` WHERE `n`.`hide` = '0' ORDER BY `n`.`sort` [ RunTime:0.000366s ]
