SHOW FULL COLUMNS FROM `xycms_api_log` [ RunTime:0.000757s ]
SELECT COUNT(*) AS think_count FROM `xycms_api_log` WHERE `ip` = '216.73.216.11' AND `create_time` BETWEEN 1768148730 AND 1768148734 [ RunTime:0.002950s ]
SHOW FULL COLUMNS FROM `xycms_article_cate` [ RunTime:0.000564s ]
SELECT * FROM `xycms_article_cate` WHERE `alias` = 'gig' LIMIT 1 [ RunTime:0.000438s ]
SELECT `id` FROM `xycms_article_cate` WHERE `pid` = 37 [ RunTime:0.000599s ]
SHOW FULL COLUMNS FROM `xycms_article` [ RunTime:0.000532s ]
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` < 1768148733 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1768148733) OR (`article`.`start_time` < 1768148733 AND `article`.`end_time` > 1768148733) ) ) AND `article`.`delete_time` IS NULL [ RunTime:0.002342s ]
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` < 1768148733 AND `article`.`end_time` IS NULL) OR (`article`.`start_time` IS NULL AND `article`.`end_time` > 1768148733) OR (`article`.`start_time` < 1768148733 AND `article`.`end_time` > 1768148733) ) ) AND `article`.`delete_time` IS NULL ORDER BY `article`.`sort` ASC,`article`.`update_time` DESC,`article`.`id` DESC LIMIT 0,15 [ RunTime:0.000990s ]
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.018751s ]
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.000938s ]
UPDATE `xycms_article` SET `view` = `view` + 6 WHERE ( `id` = 7 ) AND `xycms_article`.`delete_time` IS NULL [ RunTime:0.018659s ]
桂公网安备45020402000121号
