Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Blog`.`id`, `Blog`.`name`, `Blog`.`content`, `Blog`.`content2`, `Blog`.`file`, `Blog`.`created`, `Blog`.`online`, `Blog`.`type`, `Blog`.`slug`, `Blog`.`theme_id`, `Blog`.`meta`, `Blog`.`accueil`, `Blog`.`media_id`, `Blog`.`selected`, `Blog`.`keywords`, `Theme`.`id`, `Theme`.`name`, `Theme`.`slug`, `Theme`.`blog_count`, `Theme`.`meta`, `Theme`.`keywords`, `Thumb`.`id`, `Thumb`.`ref`, `Thumb`.`ref_id`, `Thumb`.`file`, `Thumb`.`position`, `Thumb`.`name`, `Thumb`.`slider`, `Thumb`.`content`, `Thumb`.`titre`, `Thumb`.`active` FROM `castayv2`.`blogs` AS `Blog` LEFT JOIN `castayv2`.`themes` AS `Theme` ON (`Blog`.`theme_id` = `Theme`.`id`) LEFT JOIN `castayv2`.`medias` AS `Thumb` ON (`Blog`.`media_id` = `Thumb`.`id`) WHERE `Blog`.`type` = 'blog' ORDER BY `Blog`.`name` desc LIMIT 6 | 4 | 4 | 1 | maybe slow |
SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position`, `Media`.`name`, `Media`.`slider`, `Media`.`content`, `Media`.`titre`, `Media`.`active` FROM `castayv2`.`medias` AS `Media` WHERE ref = "Blog" AND `Media`.`ref_id` IN (71, 63, 62, 69) ORDER BY `Media`.`position` ASC | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `castayv2`.`blogs` AS `Blog` LEFT JOIN `castayv2`.`themes` AS `Theme` ON (`Blog`.`theme_id` = `Theme`.`id`) LEFT JOIN `castayv2`.`medias` AS `Thumb` ON (`Blog`.`media_id` = `Thumb`.`id`) WHERE `Blog`.`type` = 'blog' | 1 | 1 | 0 | |
SELECT `Theme`.`id`, `Theme`.`name`, `Theme`.`slug`, `Theme`.`blog_count`, `Theme`.`meta`, `Theme`.`keywords` FROM `castayv2`.`themes` AS `Theme` WHERE 1 = 1 | 5 | 5 | 0 | |
SELECT `Blog`.`id`, `Blog`.`name`, `Blog`.`content`, `Blog`.`content2`, `Blog`.`file`, `Blog`.`created`, `Blog`.`online`, `Blog`.`type`, `Blog`.`slug`, `Blog`.`theme_id`, `Blog`.`meta`, `Blog`.`accueil`, `Blog`.`media_id`, `Blog`.`selected`, `Blog`.`keywords` FROM `castayv2`.`blogs` AS `Blog` WHERE `Blog`.`theme_id` IN (7, 8, 9, 10, 11) | 4 | 4 | 0 | |
SELECT `Post`.`id`, `Post`.`slug`, `Post`.`name` FROM `castayv2`.`posts` AS `Post` LEFT JOIN `castayv2`.`rubriques` AS `Rubrique` ON (`Post`.`rubrique_id` = `Rubrique`.`id`) LEFT JOIN `castayv2`.`medias` AS `Thumb` ON (`Post`.`media_id` = `Thumb`.`id`) WHERE `Post`.`online` = '1' | 3 | 3 | 1 | maybe slow |
SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position`, `Media`.`name`, `Media`.`slider`, `Media`.`content`, `Media`.`titre`, `Media`.`active` FROM `castayv2`.`medias` AS `Media` WHERE ref = "Post" AND `Media`.`ref_id` IN (195, 196, 197) ORDER BY `Media`.`position` ASC | 8 | 8 | 0 | |
SELECT `Category`.`id`, `Category`.`slug`, `Category`.`name` FROM `castayv2`.`categories` AS `Category` WHERE `Category`.`online` = 1 | 4 | 4 | 0 | |
SELECT `Work`.`id`, `Work`.`name`, `Work`.`content`, `Work`.`content2`, `Work`.`created`, `Work`.`online`, `Work`.`type`, `Work`.`slug`, `Work`.`category_id`, `Work`.`meta`, `Work`.`media_id`, `Work`.`date`, `Work`.`accueil`, `Work`.`keywords`, `Work`.`position` FROM `castayv2`.`works` AS `Work` WHERE `Work`.`category_id` IN (8, 9, 10, 11) | 15 | 15 | 0 | |
SELECT `Blog`.`id`, `Blog`.`slug`, `Blog`.`name` FROM `castayv2`.`blogs` AS `Blog` LEFT JOIN `castayv2`.`themes` AS `Theme` ON (`Blog`.`theme_id` = `Theme`.`id`) LEFT JOIN `castayv2`.`medias` AS `Thumb` ON (`Blog`.`media_id` = `Thumb`.`id`) WHERE `type` = 'blog' AND `online` = '1' | 3 | 3 | 0 | |
SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position`, `Media`.`name`, `Media`.`slider`, `Media`.`content`, `Media`.`titre`, `Media`.`active` FROM `castayv2`.`medias` AS `Media` WHERE ref = "Blog" AND `Media`.`ref_id` IN (62, 69, 71) ORDER BY `Media`.`position` ASC | 0 | 0 | 0 | |
SELECT `Blog`.`id`, `Blog`.`slug`, `Blog`.`name` FROM `castayv2`.`blogs` AS `Blog` LEFT JOIN `castayv2`.`themes` AS `Theme` ON (`Blog`.`theme_id` = `Theme`.`id`) LEFT JOIN `castayv2`.`medias` AS `Thumb` ON (`Blog`.`media_id` = `Thumb`.`id`) WHERE `type` = 'blog' AND `online` = '1' | 3 | 3 | 0 | |
SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position`, `Media`.`name`, `Media`.`slider`, `Media`.`content`, `Media`.`titre`, `Media`.`active` FROM `castayv2`.`medias` AS `Media` WHERE ref = "Blog" AND `Media`.`ref_id` IN (62, 69, 71) ORDER BY `Media`.`position` ASC | 0 | 0 | 0 | |
SELECT `Post`.`id`, `Post`.`slug`, `Post`.`name` FROM `castayv2`.`posts` AS `Post` LEFT JOIN `castayv2`.`rubriques` AS `Rubrique` ON (`Post`.`rubrique_id` = `Rubrique`.`id`) LEFT JOIN `castayv2`.`medias` AS `Thumb` ON (`Post`.`media_id` = `Thumb`.`id`) WHERE `Post`.`online` = '1' | 3 | 3 | 1 | maybe slow |
SELECT `Media`.`id`, `Media`.`ref`, `Media`.`ref_id`, `Media`.`file`, `Media`.`position`, `Media`.`name`, `Media`.`slider`, `Media`.`content`, `Media`.`titre`, `Media`.`active` FROM `castayv2`.`medias` AS `Media` WHERE ref = "Post" AND `Media`.`ref_id` IN (195, 196, 197) ORDER BY `Media`.`position` ASC | 8 | 8 | 0 | |