SHOW FULL COLUMNS FROM `bd_cms_area` [ RunTime:0.000538s ]
SHOW FULL COLUMNS FROM `bd_config` [ RunTime:0.000680s ]
SHOW FULL COLUMNS FROM `bd_cms_site` [ RunTime:0.000590s ]
SHOW FULL COLUMNS FROM `bd_cms_company` [ RunTime:0.000456s ]
SHOW FULL COLUMNS FROM `bd_cms_label` [ RunTime:0.000441s ]
SELECT * FROM `bd_config` WHERE `name` = 'msgcodestatus' LIMIT 1 [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `bd_cms_content_sort` [ RunTime:0.000552s ]
SELECT `a`.*,a.name AS parentname,`b`.`type`,`b`.`urlname`,`d`.`gcode` FROM `bd_cms_content_sort` `a` LEFT JOIN `bd_cms_model` `b` ON `a`.`mcode`=`b`.`mcode` LEFT JOIN `bd_user_level` `d` ON `a`.`gid`=`d`.`id` WHERE `a`.`scode` = 'case' OR `a`.`filename` = 'case' LIMIT 1 [ RunTime:0.000429s ]
SELECT `a`.`id`,`a`.`pcode`,`a`.`scode`,`a`.`name`,`a`.`filename`,`a`.`outlink`,`b`.`type`,`b`.`urlname` FROM `bd_cms_content_sort` `a` LEFT JOIN `bd_cms_model` `b` ON `a`.`mcode`=`b`.`mcode` WHERE ( a.acode='cn' ) ORDER BY `a`.`pcode`,`a`.`sorting`,`a`.`id` DESC [ RunTime:0.000451s ]
SHOW FULL COLUMNS FROM `bd_cms_content` [ RunTime:0.000675s ]
SELECT count(*),`scode` FROM `bd_cms_content` WHERE ( `acode` = 'cn' AND `status` = '1' AND `date` < '2025-08-01 10:06:03' ) GROUP BY `scode` [ RunTime:0.000436s ]
SELECT count(*),`subscode` FROM `bd_cms_content` WHERE ( `acode` = 'cn' AND `status` = '1' AND `date` < '2025-08-01 10:06:03' ) AND `subscode` <> '' AND `subscode` IS NOT NULL GROUP BY `subscode` [ RunTime:0.000379s ]
SELECT `a`.*,a.name AS parentname,`b`.`type`,`b`.`urlname`,`d`.`gcode` FROM `bd_cms_content_sort` `a` LEFT JOIN `bd_cms_model` `b` ON `a`.`mcode`=`b`.`mcode` LEFT JOIN `bd_user_level` `d` ON `a`.`gid`=`d`.`id` WHERE `a`.`scode` = '8' OR `a`.`filename` = '8' LIMIT 1 [ RunTime:0.000456s ]
SELECT `a`.*,b.name as sortname,b.filename as sortfilename,c.name as subsortname,c.filename as subfilename,`d`.`type`,d.name as modelname,`d`.`urlname`,`e`.*,`f`.`gcode` FROM `bd_cms_content` `a` LEFT JOIN `bd_cms_content_sort` `b` ON `a`.`scode`=`b`.`scode` LEFT JOIN `bd_cms_content_sort` `c` ON `a`.`subscode`=`c`.`scode` LEFT JOIN `bd_cms_model` `d` ON `b`.`mcode`=`d`.`mcode` LEFT JOIN `bd_cms_content_ext` `e` ON `a`.`id`=`e`.`contentid` LEFT JOIN `bd_user_level` `f` ON `a`.`gid`=`f`.`id` WHERE ( ( `a`.`scode` = '8' OR `b`.`filename` = '8' ) AND ( `a`.`id` = '89' OR `a`.`filename` = '89' ) ) AND `a`.`status` = '1' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001060s ]
SHOW FULL COLUMNS FROM `bd_cms_tags` [ RunTime:0.001040s ]
SELECT `name`,`link` FROM `bd_cms_tags` WHERE `acode` = 'cn' ORDER BY length(name) desc [ RunTime:0.000338s ]
SELECT `a`.`id`,`a`.`title`,`a`.`filename`,`a`.`ico`,`a`.`scode`,b.filename as sortfilename,`c`.`type`,`c`.`urlname` FROM `bd_cms_content` `a` LEFT JOIN `bd_cms_content_sort` `b` ON `a`.`scode`=`b`.`scode` LEFT JOIN `bd_cms_model` `c` ON `b`.`mcode`=`c`.`mcode` WHERE ( `a`.`scode` = '8' AND `a`.`acode` = 'cn' AND `a`.`status` = '1' AND `a`.`date` < '2025-08-01 10:06:03' AND `a`.`id` > '89' ) ORDER BY `a`.`id` ASC LIMIT 1 [ RunTime:0.000759s ]
SELECT `a`.`id`,`a`.`title`,`a`.`filename`,`a`.`ico`,`a`.`scode`,b.filename as sortfilename,`c`.`type`,`c`.`urlname` FROM `bd_cms_content` `a` LEFT JOIN `bd_cms_content_sort` `b` ON `a`.`scode`=`b`.`scode` LEFT JOIN `bd_cms_model` `c` ON `b`.`mcode`=`c`.`mcode` WHERE ( `a`.`scode` = '8' AND `a`.`acode` = 'cn' AND `a`.`status` = '1' AND `a`.`date` < '2025-08-01 10:06:03' AND `a`.`id` < '89' ) ORDER BY `a`.`id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT * FROM `bd_config` WHERE `name` = 'msgcodestatus' LIMIT 1 [ RunTime:0.000321s ]
SELECT `a`.*,b.name as sortname,b.filename as sortfilename,c.name as subsortname,c.filename as subfilename,`d`.`type`,d.name as modelname,`d`.`urlname`,`e`.*,`f`.`gcode` FROM `bd_cms_content` `a` LEFT JOIN `bd_cms_content_sort` `b` ON `a`.`scode`=`b`.`scode` LEFT JOIN `bd_cms_content_sort` `c` ON `a`.`subscode`=`c`.`scode` LEFT JOIN `bd_cms_model` `d` ON `b`.`mcode`=`d`.`mcode` LEFT JOIN `bd_user_level` `f` ON `a`.`gid`=`f`.`id` LEFT JOIN `bd_cms_content_ext` `e` ON `a`.`id`=`e`.`contentid` WHERE ( `a`.`status` = '1' AND `d`.`type` = '2' AND `a`.`date` < '2025-08-01 10:06:03' AND ( ( `a`.`scode` IN ('5','25','26','23','22','21','20','19','18','17','16','15') OR `a`.`subscode` = '5' ) ) AND `a`.`acode` = 'cn' ) ORDER BY `a`.`istop` DESC,`a`.`isrecommend` DESC,`a`.`isheadline` DESC,`a`.`sorting` ASC,`a`.`date` DESC,`a`.`id` DESC LIMIT 0,8 [ RunTime:0.004892s ]
