Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT COUNT(*) AS `count` FROM `frismar_clf407`.`articles` AS `Article` WHERE `Article`.`id` = 3 | 1 | 1 | 1 | |
SELECT `Article`.`id`, `Article`.`name`, `Article`.`lil_desc`, `Article`.`description`, `Article`.`url`, `Article`.`user_id`, `Article`.`category_id`, `Article`.`published`, `Article`.`vues`, `Article`.`modified`, `Article`.`created`, `User`.`id`, `User`.`username`, `User`.`usermail`, `User`.`password`, `User`.`last_login`, `User`.`modified`, `User`.`created`, `User`.`group_id`, `Category`.`id`, `Category`.`name`, `Category`.`created`, `Category`.`modified` FROM `frismar_clf407`.`articles` AS `Article` LEFT JOIN `frismar_clf407`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) LEFT JOIN `frismar_clf407`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`id` = 3 LIMIT 1 | 1 | 1 | 5 | maybe slow |
SELECT `Comment`.`id`, `Comment`.`article_id`, `Comment`.`author`, `Comment`.`author_mail`, `Comment`.`author_url`, `Comment`.`author_ip`, `Comment`.`content`, `Comment`.`approved`, `Comment`.`parent`, `Comment`.`user_id`, `Comment`.`created`, `Comment`.`modified` FROM `frismar_clf407`.`comments` AS `Comment` WHERE `Comment`.`article_id` = (3) | 0 | 0 | 2 | maybe slow |
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`created`, `Tag`.`modified`, `ArticlesTag`.`id`, `ArticlesTag`.`article_id`, `ArticlesTag`.`tag_id`, `ArticlesTag`.`created`, `ArticlesTag`.`modified` FROM `frismar_clf407`.`tags` AS `Tag` JOIN `frismar_clf407`.`articles_tag` AS `ArticlesTag` ON (`ArticlesTag`.`article_id` = 3 AND `ArticlesTag`.`tag_id` = `Tag`.`id`) | 0 | 0 | 1 | maybe slow |
BEGIN | 0 | 0 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `frismar_clf407`.`articles` AS `Article` WHERE `Article`.`id` = 3 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `frismar_clf407`.`articles` AS `Article` WHERE `Article`.`id` = 3 | 1 | 1 | 0 | |
UPDATE `frismar_clf407`.`articles` SET `id` = 3, `vues` = 5, `modified` = '2016-01-30 04:59:05' WHERE `frismar_clf407`.`articles`.`id` = '3' | 1 | 1 | 1 | |
COMMIT | 1 | 1 | 1 | |
SELECT `Article`.`id`, `Article`.`name`, `Article`.`lil_desc`, `Article`.`description`, `Article`.`url`, `Article`.`user_id`, `Article`.`category_id`, `Article`.`published`, `Article`.`vues`, `Article`.`modified`, `Article`.`created`, `User`.`id`, `User`.`username`, `User`.`usermail`, `User`.`password`, `User`.`last_login`, `User`.`modified`, `User`.`created`, `User`.`group_id`, `Category`.`id`, `Category`.`name`, `Category`.`created`, `Category`.`modified` FROM `frismar_clf407`.`articles` AS `Article` LEFT JOIN `frismar_clf407`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) LEFT JOIN `frismar_clf407`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`id` = 3 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Comment`.`id`, `Comment`.`article_id`, `Comment`.`author`, `Comment`.`author_mail`, `Comment`.`author_url`, `Comment`.`author_ip`, `Comment`.`content`, `Comment`.`approved`, `Comment`.`parent`, `Comment`.`user_id`, `Comment`.`created`, `Comment`.`modified` FROM `frismar_clf407`.`comments` AS `Comment` WHERE `Comment`.`article_id` = (3) | 0 | 0 | 1 | maybe slow |
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`created`, `Tag`.`modified`, `ArticlesTag`.`id`, `ArticlesTag`.`article_id`, `ArticlesTag`.`tag_id`, `ArticlesTag`.`created`, `ArticlesTag`.`modified` FROM `frismar_clf407`.`tags` AS `Tag` JOIN `frismar_clf407`.`articles_tag` AS `ArticlesTag` ON (`ArticlesTag`.`article_id` = 3 AND `ArticlesTag`.`tag_id` = `Tag`.`id`) | 0 | 0 | 1 | maybe slow |
SELECT `Category`.`id`, `Category`.`name` FROM `frismar_clf407`.`categories` AS `Category` WHERE 1 = 1 | 3 | 3 | 0 | |
SELECT COUNT(*) AS `count` FROM `frismar_clf407`.`articles` AS `Article` LEFT JOIN `frismar_clf407`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) LEFT JOIN `frismar_clf407`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`category_id` = 1 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `frismar_clf407`.`articles` AS `Article` LEFT JOIN `frismar_clf407`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) LEFT JOIN `frismar_clf407`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`category_id` = 2 | 1 | 1 | 1 | |
SELECT COUNT(*) AS `count` FROM `frismar_clf407`.`articles` AS `Article` LEFT JOIN `frismar_clf407`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) LEFT JOIN `frismar_clf407`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`category_id` = 3 | 1 | 1 | 1 | |
SELECT `Article`.`id`, `Article`.`name`, `Article`.`lil_desc`, `Article`.`description`, `Article`.`url`, `Article`.`user_id`, `Article`.`category_id`, `Article`.`published`, `Article`.`vues`, `Article`.`modified`, `Article`.`created`, `User`.`id`, `User`.`username`, `User`.`usermail`, `User`.`password`, `User`.`last_login`, `User`.`modified`, `User`.`created`, `User`.`group_id`, `Category`.`id`, `Category`.`name`, `Category`.`created`, `Category`.`modified` FROM `frismar_clf407`.`articles` AS `Article` LEFT JOIN `frismar_clf407`.`users` AS `User` ON (`Article`.`user_id` = `User`.`id`) LEFT JOIN `frismar_clf407`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE 1 = 1 ORDER BY `Article`.`vues` desc LIMIT 5 | 5 | 5 | 2 | maybe slow |
SELECT `Comment`.`id`, `Comment`.`article_id`, `Comment`.`author`, `Comment`.`author_mail`, `Comment`.`author_url`, `Comment`.`author_ip`, `Comment`.`content`, `Comment`.`approved`, `Comment`.`parent`, `Comment`.`user_id`, `Comment`.`created`, `Comment`.`modified` FROM `frismar_clf407`.`comments` AS `Comment` WHERE `Comment`.`article_id` IN (5, 3, 4, 1, 2) | 0 | 0 | 0 | |
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`created`, `Tag`.`modified`, `ArticlesTag`.`id`, `ArticlesTag`.`article_id`, `ArticlesTag`.`tag_id`, `ArticlesTag`.`created`, `ArticlesTag`.`modified` FROM `frismar_clf407`.`tags` AS `Tag` JOIN `frismar_clf407`.`articles_tag` AS `ArticlesTag` ON (`ArticlesTag`.`article_id` IN (5, 3, 4, 1, 2) AND `ArticlesTag`.`tag_id` = `Tag`.`id`) | 0 | 0 | 0 | |