Query | Affected | Num. rows | Took (ms) | Actions |
---|
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`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`content`, `Category`.`post_count`, `Category`.`meta`, `Category`.`keywords`, `Category`.`media_id`, `Category`.`online` FROM `castayv2`.`works` AS `Work` LEFT JOIN `castayv2`.`categories` AS `Category` ON (`Work`.`category_id` = `Category`.`id`) WHERE `Work`.`id` = 171 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 = "Work" AND `Media`.`ref_id` = (171) ORDER BY `Media`.`position` ASC | 4 | 4 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`content`, `Category`.`post_count`, `Category`.`meta`, `Category`.`keywords`, `Category`.`media_id`, `Category`.`online` FROM `castayv2`.`categories` AS `Category` WHERE `Category`.`id` = 8 LIMIT 1 | 1 | 1 | 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` = (8) | 5 | 5 | 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`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`content`, `Category`.`post_count`, `Category`.`meta`, `Category`.`keywords`, `Category`.`media_id`, `Category`.`online`, `Thumb`.`id`, `Thumb`.`ref`, `Thumb`.`ref_id`, `Thumb`.`file`, `Thumb`.`position`, `Thumb`.`name`, `Thumb`.`slider`, `Thumb`.`content`, `Thumb`.`titre`, `Thumb`.`active` FROM `castayv2`.`works` AS `Work` LEFT JOIN `castayv2`.`categories` AS `Category` ON (`Work`.`category_id` = `Category`.`id`) LEFT JOIN `castayv2`.`medias` AS `Thumb` ON (`Work`.`media_id` = `Thumb`.`id`) WHERE 1 = 1 ORDER BY `Work`.`id` desc | 15 | 15 | 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 = "Work" AND `Media`.`ref_id` IN (183, 182, 181, 180, 179, 178, 177, 176, 175, 174, 173, 172, 171, 170, 168) ORDER BY `Media`.`position` ASC | 30 | 30 | 1 | |
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`, `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`content`, `Category`.`post_count`, `Category`.`meta`, `Category`.`keywords`, `Category`.`media_id`, `Category`.`online`, `Thumb`.`id`, `Thumb`.`ref`, `Thumb`.`ref_id`, `Thumb`.`file`, `Thumb`.`position`, `Thumb`.`name`, `Thumb`.`slider`, `Thumb`.`content`, `Thumb`.`titre`, `Thumb`.`active` FROM `castayv2`.`works` AS `Work` LEFT JOIN `castayv2`.`categories` AS `Category` ON (`Work`.`category_id` = `Category`.`id`) LEFT JOIN `castayv2`.`medias` AS `Thumb` ON (`Work`.`media_id` = `Thumb`.`id`) WHERE `Work`.`category_id` = 8 AND `Work`.`online` = '1' | 5 | 5 | 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 = "Work" AND `Media`.`ref_id` IN (168, 170, 171, 172, 178) ORDER BY `Media`.`position` ASC | 14 | 14 | 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` = 171 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 | |