SHOW FULL COLUMNS FROM `xycms_api_log` [ RunTime:0.000794s ]
SELECT COUNT(*) AS think_count FROM `xycms_api_log` WHERE `ip` = '216.73.216.123' AND `create_time` BETWEEN 1773296854 AND 1773296858 [ RunTime:0.002747s ]
SHOW FULL COLUMNS FROM `xycms_article_cate` [ RunTime:0.000649s ]
SELECT * FROM `xycms_article_cate` WHERE `alias` = 'gig' LIMIT 1 [ RunTime:0.000261s ]
SELECT `id` FROM `xycms_article_cate` WHERE `pid` = 37 [ RunTime:0.000172s ]
SHOW FULL COLUMNS FROM `xycms_article` [ RunTime:0.000586s ]
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` < 1773296857 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1773296857) OR (`article`.`start_time` < 1773296857 AND `article`.`end_time` > 1773296857) ) ) AND `article`.`delete_time` IS NULL [ RunTime:0.001679s ]
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` < 1773296857 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1773296857) OR (`article`.`start_time` < 1773296857 AND `article`.`end_time` > 1773296857) ) ) AND `article`.`delete_time` IS NULL ORDER BY `article`.`sort` ASC,`article`.`update_time` DESC,`article`.`id` DESC LIMIT 0,15 [ RunTime:0.001016s ]
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.002392s ]
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.000787s ]
UPDATE `xycms_article` SET `view` = `view` + 7 WHERE ( `id` = 7 ) AND `xycms_article`.`delete_time` IS NULL [ RunTime:0.008426s ]
桂公网安备45020402000121号
