SHOW FULL COLUMNS FROM `xycms_api_log` [ RunTime:0.000889s ]
SELECT COUNT(*) AS think_count FROM `xycms_api_log` WHERE `ip` = '216.73.217.33' AND `create_time` BETWEEN 1789094232 AND 1789094236 [ RunTime:0.001499s ]
SHOW FULL COLUMNS FROM `xycms_article_cate` [ RunTime:0.000735s ]
SELECT * FROM `xycms_article_cate` WHERE `alias` = 'gig' LIMIT 1 [ RunTime:0.000275s ]
SELECT `id` FROM `xycms_article_cate` WHERE `pid` = 37 [ RunTime:0.000199s ]
SHOW FULL COLUMNS FROM `xycms_article` [ RunTime:0.000646s ]
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` < 1789094235 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1789094235) OR (`article`.`start_time` < 1789094235 AND `article`.`end_time` > 1789094235) ) ) AND `article`.`delete_time` IS NULL [ RunTime:0.001538s ]
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` < 1789094235 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1789094235) OR (`article`.`start_time` < 1789094235 AND `article`.`end_time` > 1789094235) ) ) AND `article`.`delete_time` IS NULL ORDER BY `article`.`sort` ASC,`article`.`update_time` DESC,`article`.`id` DESC LIMIT 0,15 [ RunTime:0.000816s ]
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.004766s ]
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.002096s ]
UPDATE `xycms_article` SET `view` = `view` + 6 WHERE ( `id` = 7 ) AND `xycms_article`.`delete_time` IS NULL [ RunTime:0.004585s ]
桂公网安备45020402000121号
