0

You have no items in your shopping cart.

(default) 13 queries took 20 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `articles`10105
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `article_comments`995
4SHOW FULL COLUMNS FROM `logs`10105
5SELECT COUNT(DISTINCT Article.id) AS `count` FROM `articles` AS `Article` LEFT JOIN article_comments AS `Comments` ON (`Comments`.`article_id` = `Article`.`id` AND `Comments`.`status` = 1) WHERE `Article`.`status` = 1 112
6SELECT `Article`.`id`, `Article`.`title`, `Article`.`content`, `Article`.`default_image`, `Article`.`created`, `Article`.`modified`, `Article`.`published`, `Article`.`owner_id`, `Article`.`publishing_at`, `Article`.`status` FROM `articles` AS `Article` LEFT JOIN article_comments AS `Comments` ON (`Comments`.`article_id` = `Article`.`id` AND `Comments`.`status` = 1) WHERE `Article`.`status` = 1 GROUP BY `Article`.`id` ORDER BY `Article`.`published` DESC LIMIT 4, 2221
7SELECT `Comment`.`id`, `Comment`.`article_id`, `Comment`.`user_id`, `Comment`.`username`, `Comment`.`email`, `Comment`.`ip`, `Comment`.`content`, `Comment`.`created`, `Comment`.`status` FROM `article_comments` AS `Comment` WHERE `Comment`.`status` = 1 AND `Comment`.`article_id` = (3) ORDER BY `Comment`.`created` DESC LIMIT 3001
8SELECT `Comment`.`id`, `Comment`.`article_id`, `Comment`.`user_id`, `Comment`.`username`, `Comment`.`email`, `Comment`.`ip`, `Comment`.`content`, `Comment`.`created`, `Comment`.`status` FROM `article_comments` AS `Comment` WHERE `Comment`.`status` = 1 AND `Comment`.`article_id` = (1) ORDER BY `Comment`.`created` DESC LIMIT 3000
9SELECT `Article`.`id`, `Article`.`title`, `Article`.`default_image`, `Article`.`published` FROM `articles` AS `Article` WHERE `Article`.`status` >= 0 ORDER BY rand() ASC LIMIT 3330
10SELECT `Comment`.`id`, `Comment`.`article_id`, `Comment`.`user_id`, `Comment`.`username`, `Comment`.`email`, `Comment`.`ip`, `Comment`.`content`, `Comment`.`created`, `Comment`.`status` FROM `article_comments` AS `Comment` WHERE `Comment`.`status` = 1 AND `Comment`.`article_id` = (1) ORDER BY `Comment`.`created` DESC LIMIT 3000
11SELECT `Comment`.`id`, `Comment`.`article_id`, `Comment`.`user_id`, `Comment`.`username`, `Comment`.`email`, `Comment`.`ip`, `Comment`.`content`, `Comment`.`created`, `Comment`.`status` FROM `article_comments` AS `Comment` WHERE `Comment`.`status` = 1 AND `Comment`.`article_id` = (7) ORDER BY `Comment`.`created` DESC LIMIT 3330
12SELECT `Comment`.`id`, `Comment`.`article_id`, `Comment`.`user_id`, `Comment`.`username`, `Comment`.`email`, `Comment`.`ip`, `Comment`.`content`, `Comment`.`created`, `Comment`.`status` FROM `article_comments` AS `Comment` WHERE `Comment`.`status` = 1 AND `Comment`.`article_id` = (3) ORDER BY `Comment`.`created` DESC LIMIT 3000
13SELECT Article.id, count(Comment.id) as comments FROM articles Article INNER JOIN article_comments Comment ON Article.id = Comment.article_id WHERE Article.id in (3,1) AND Comment.status = 1 GROUP BY Article.id001