SHOW FULL COLUMNS FROM `bd_config` [ RunTime:0.000637s ]
SHOW FULL COLUMNS FROM `bd_cms_site` [ RunTime:0.000706s ]
SHOW FULL COLUMNS FROM `bd_cms_company` [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `bd_cms_label` [ RunTime:0.000447s ]
SELECT * FROM `bd_config` WHERE `name` = 'msgcodestatus' LIMIT 1 [ RunTime:0.000291s ]
SHOW FULL COLUMNS FROM `bd_cms_content_sort` [ RunTime:0.000539s ]
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` = '37' OR `a`.`filename` = '37' LIMIT 1 [ RunTime:0.000504s ]
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` = '12' OR `a`.`filename` = '12' LIMIT 1 [ RunTime:0.000439s ]
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` = '12' OR `a`.`filename` = '12' LIMIT 1 [ RunTime:0.000372s ]
SELECT * FROM `bd_config` WHERE `name` = 'msgcodestatus' LIMIT 1 [ RunTime:0.000255s ]
SHOW FULL COLUMNS FROM `bd_cms_content` [ RunTime:0.000743s ]
SELECT COUNT(*) AS think_count 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-10-22 07:00:26' AND ( ( `a`.`scode` = '37' OR `a`.`subscode` = '37' ) ) AND `a`.`acode` = 'cn' ) [ RunTime:0.001108s ]
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-10-22 07:00:26' AND ( ( `a`.`scode` = '37' OR `a`.`subscode` = '37' ) ) AND `a`.`acode` = 'cn' ) ORDER BY `a`.`sorting` ASC,`a`.`istop` DESC,`a`.`isrecommend` DESC,`a`.`isheadline` DESC,`a`.`date` DESC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.002259s ]
SELECT `a`.*,a.name AS parentname,`b`.`type`,`b`.`urlname` FROM `bd_cms_content_sort` `a` LEFT JOIN `bd_cms_model` `b` ON `a`.`mcode`=`b`.`mcode` WHERE `a`.`scode` = '2' ORDER BY `a`.`pcode`,`a`.`sorting`,`a`.`id` DESC [ RunTime:0.000747s ]
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-10-22 07:00:26' AND ( ( `a`.`scode` IN ('13','21','20','19','18','17','16') OR `a`.`subscode` = '13' ) ) AND `a`.`acode` = 'cn' ) ORDER BY `a`.`sorting` ASC,`a`.`istop` DESC,`a`.`isrecommend` DESC,`a`.`isheadline` DESC,`a`.`date` DESC,`a`.`id` DESC LIMIT 0,5 [ RunTime:0.003284s ]
扫一扫添加微信