SELECT * FROM blog_options WHERE (`name` = 'theme:joe_auth_code' )
SELECT * FROM blog_options WHERE (`name` = 'theme:joe_auth_hash' )
SHOW TABLES LIKE 'blog_extras'
SELECT blog_contents.* FROM blog_contents WHERE (blog_contents.`status` = 'publish' OR blog_contents.`status` = 'hidden' ) AND (blog_contents.`created` < '1777146349' ) AND (blog_contents.`type` = 'post' ) AND (blog_contents.`slug` = '97' ) LIMIT 1
SELECT * FROM blog_metas INNER JOIN blog_relationships ON blog_relationships.`mid` = blog_metas.`mid` WHERE (blog_relationships.`cid` = '97' ) AND (blog_metas.`type` = 'tag' )
SELECT * FROM blog_fields WHERE (`cid` = '97' )
SELECT * FROM blog_metas WHERE (`type` = 'category' )
SELECT blog_metas.`mid` FROM blog_metas INNER JOIN blog_relationships ON blog_relationships.`mid` = blog_metas.`mid` WHERE (blog_relationships.`cid` = '97' ) AND (blog_metas.`type` = 'category' )
SELECT * FROM blog_users WHERE (`uid` = '1' )
SELECT * FROM blog_contents WHERE (blog_contents.`type` = 'post' ) AND (blog_contents.`cid` <> '97' ) AND (blog_contents.`authorId` = '1' ) AND (blog_contents.`status` = 'publish' ) ORDER BY blog_contents.`created` DESC LIMIT 5
SELECT * FROM blog_fields WHERE (`cid` = '359' )
SELECT * FROM blog_fields WHERE (`cid` = '358' )
SELECT * FROM blog_fields WHERE (`cid` = '357' )
SELECT * FROM blog_fields WHERE (`cid` = '356' )
SELECT * FROM blog_fields WHERE (`cid` = '353' )
SELECT DISTINCT blog_contents.`cid` , blog_contents.`title` , blog_contents.`slug` , blog_contents.`created` , blog_contents.`authorId` , blog_contents.`modified` , blog_contents.`type` , blog_contents.`status` , blog_contents.`text` , blog_contents.`commentsNum` , blog_contents.`order` , blog_contents.`template` , blog_contents.`password` , blog_contents.`allowComment` , blog_contents.`allowPing` , blog_contents.`allowFeed` FROM blog_contents INNER JOIN blog_relationships ON blog_contents.`cid` = blog_relationships.`cid` WHERE (blog_relationships.`mid` IN (87) ) AND (blog_contents.`cid` <> '97' ) AND (blog_contents.`status` = 'publish' ) AND (blog_contents.`password` IS NULL ) AND (blog_contents.`created` < '1777146349' ) AND (blog_contents.`type` = 'post' ) ORDER BY blog_contents.`created` DESC LIMIT 5
SELECT * FROM blog_fields WHERE (`cid` = '400' )
SELECT * FROM blog_fields WHERE (`cid` = '338' )
SELECT * FROM blog_fields WHERE (`cid` = '347' )
SELECT * FROM blog_fields WHERE (`cid` = '337' )
SELECT * FROM blog_fields WHERE (`cid` = '333' )
SELECT * FROM blog_comments WHERE (`cid` = '97' ) AND (`status` = 'approved' OR (`coid` = '0' AND `status` <> 'approved') ) ORDER BY blog_comments.`coid` ASC
SHOW FULL COLUMNS FROM `blog_extras` [ RunTime:0.000435s ]
SELECT * FROM `blog_extras` WHERE `table` = 'users' AND `parent` IS NULL LIMIT 1 [ RunTime:0.000200s ]
SELECT * FROM `blog_extras` WHERE `table` = 'users' AND `name` = 'avatar' [ RunTime:0.002481s ]
SHOW FULL COLUMNS FROM `blog_contents` [ RunTime:0.002599s ]
SELECT COUNT(*) AS think_count FROM `blog_contents` WHERE `authorId` = 1 AND `type` = 'post' AND `status` = 'publish' [ RunTime:0.000524s ]
SHOW FULL COLUMNS FROM `blog_comments` [ RunTime:0.000436s ]
SELECT COUNT(*) AS think_count FROM `blog_comments` WHERE `authorId` = 1 AND `status` = 'approved' AND `type` = 'comment' [ RunTime:0.001366s ]
SELECT SUM(`agree`) AS think_sum FROM `blog_contents` WHERE `authorId` = 1 AND `type` = 'post' AND `status` = 'publish' [ RunTime:0.000542s ]
SELECT SUM(`views`) AS think_sum FROM `blog_contents` WHERE `authorId` = 1 AND `type` = 'post' AND `status` = 'publish' [ RunTime:0.000604s ]
SELECT * FROM `blog_contents` WHERE `created` < 1670767380 AND `status` = 'publish' AND `type` = 'post' ORDER BY `created` DESC LIMIT 1 [ RunTime:0.005309s ]
SELECT * FROM `blog_contents` WHERE `created` > 1670767380 AND `status` = 'publish' AND `type` = 'post' ORDER BY `created` ASC LIMIT 1 [ RunTime:0.001185s ]
SELECT `views` FROM `blog_contents` WHERE `cid` = 400 LIMIT 1 [ RunTime:0.000278s ]
SELECT `views` FROM `blog_contents` WHERE `cid` = 338 LIMIT 1 [ RunTime:0.000386s ]
SELECT `views` FROM `blog_contents` WHERE `cid` = 347 LIMIT 1 [ RunTime:0.001494s ]
SELECT `views` FROM `blog_contents` WHERE `cid` = 337 LIMIT 1 [ RunTime:0.000754s ]
SELECT `views` FROM `blog_contents` WHERE `cid` = 333 LIMIT 1 [ RunTime:0.000238s ]
SELECT * FROM `blog_contents` WHERE `cid` = 97 LIMIT 1 [ RunTime:0.001993s ]
-
最新
-
最热
只看作者