Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Post`.`id`, `Post`.`name`, `Post`.`content`, `Post`.`content2`, `Post`.`file`, `Post`.`created`, `Post`.`online`, `Post`.`type`, `Post`.`slug`, `Post`.`meta`, `Post`.`keywords`, `Post`.`media_id`, `Post`.`rubrique_id`, `Post`.`numero`, `Post`.`active`, `Post`.`content3`, `Post`.`content4`, `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`slug`, `Rubrique`.`content`, `Rubrique`.`meta`, `Thumb`.`id`, `Thumb`.`ref`, `Thumb`.`ref_id`, `Thumb`.`file`, `Thumb`.`position`, `Thumb`.`name`, `Thumb`.`slider`, `Thumb`.`content`, `Thumb`.`titre`, `Thumb`.`active` 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`.`id` = 197 AND `Post`.`type` = 'page' LIMIT 1 | 1 | 1 | 1 | |
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` = (197) ORDER BY `Media`.`position` ASC | 2 | 2 | 0 | |
SELECT `Post`.`id`, `Post`.`name`, `Post`.`content`, `Post`.`content2`, `Post`.`file`, `Post`.`created`, `Post`.`online`, `Post`.`type`, `Post`.`slug`, `Post`.`meta`, `Post`.`keywords`, `Post`.`media_id`, `Post`.`rubrique_id`, `Post`.`numero`, `Post`.`active`, `Post`.`content3`, `Post`.`content4`, `Rubrique`.`id`, `Rubrique`.`name`, `Rubrique`.`slug`, `Rubrique`.`content`, `Rubrique`.`meta`, `Thumb`.`id`, `Thumb`.`ref`, `Thumb`.`ref_id`, `Thumb`.`file`, `Thumb`.`position`, `Thumb`.`name`, `Thumb`.`slider`, `Thumb`.`content`, `Thumb`.`titre`, `Thumb`.`active` 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`.`type` = 'page' AND `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 `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 `Media`.`ref_id` = 197 AND `Media`.`active` = 1 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 | |
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 | |