SHOW FULL COLUMNS FROM `xycms_api_log` [ RunTime:0.001803s ]
SELECT COUNT(*) AS think_count FROM `xycms_api_log` WHERE `ip` = '216.73.216.44' AND `create_time` BETWEEN 1783824895 AND 1783824899 [ RunTime:0.000697s ]
SHOW FULL COLUMNS FROM `xycms_article_cate` [ RunTime:0.000606s ]
SELECT * FROM `xycms_article_cate` WHERE `alias` = 'gig' LIMIT 1 [ RunTime:0.000227s ]
SELECT `id` FROM `xycms_article_cate` WHERE `pid` = 37 [ RunTime:0.000198s ]
SHOW FULL COLUMNS FROM `xycms_article` [ RunTime:0.000590s ]
SELECT COUNT(*) AS think_count FROM `xycms_article` `article` INNER JOIN `xycms_article_cate` `ac` ON `ac`.`id`=`article`.`cid` WHERE ( `cid` IN (38,39,40,41) AND `article`.`status` = 1 AND ( 1 = 1 ) AND ( (`article`.`start_time` IS NULL AND `article`.`end_time` IS NULL) OR (`article`.`start_time` < 1783824898 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1783824898) OR (`article`.`start_time` < 1783824898 AND `article`.`end_time` > 1783824898) ) ) AND `article`.`delete_time` IS NULL [ RunTime:0.000518s ]
SELECT ac.title as acTitle,`article`.`id`,`article`.`title`,`article`.`view`,`article`.`thumb`,`article`.`source`,`article`.`start_time`,`article`.`create_time`,`article`.`desc`,`article`.`status_alias`,`article`.`force_alert`,`article`.`cla` FROM `xycms_article` `article` INNER JOIN `xycms_article_cate` `ac` ON `ac`.`id`=`article`.`cid` WHERE ( `cid` IN (38,39,40,41) AND `article`.`status` = 1 AND ( 1 = 1 ) AND ( (`article`.`start_time` IS NULL AND `article`.`end_time` IS NULL) OR (`article`.`start_time` < 1783824898 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1783824898) OR (`article`.`start_time` < 1783824898 AND `article`.`end_time` > 1783824898) ) ) AND `article`.`delete_time` IS NULL ORDER BY `article`.`sort` ASC,`article`.`update_time` DESC,`article`.`id` DESC LIMIT 0,15 [ RunTime:0.000480s ]
SELECT `id`,`title` FROM `xycms_article` WHERE ( `cid` = 38 AND `status` = 1 AND `id` < 7 ) AND `xycms_article`.`delete_time` IS NULL ORDER BY `id` DESC LIMIT 1 [ RunTime:0.016321s ]
SELECT `id`,`title` FROM `xycms_article` WHERE ( `cid` = 38 AND `status` = 1 AND `id` > 7 ) AND `xycms_article`.`delete_time` IS NULL ORDER BY `id` ASC LIMIT 1 [ RunTime:0.008139s ]
UPDATE `xycms_article` SET `view` = `view` + 1 WHERE ( `id` = 7 ) AND `xycms_article`.`delete_time` IS NULL [ RunTime:0.021238s ]
桂公网安备45020402000121号
