Contenido pago
Pescadilla caprese, ¡deliciosa!
Pescadilla caprese, ¡deliciosa!
No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `Season`.`id`, `Season`.`name` FROM `krakenco_masterchef`.`seasons` AS `Season` WHERE 1 = 1 | 2 | 2 | 1 | maybe slow |
| SELECT LOWER(TRIM(`Season`.`name`)) AS name, COUNT(*) AS count, `Season`.`id` FROM `krakenco_masterchef`.`seasons` AS `Season` WHERE 1 = 1 GROUP BY name | 2 | 2 | 1 | maybe slow |
| SELECT `Jury`.`id`, `Jury`.`season_id`, `Jury`.`name`, `Jury`.`short_description`, `Jury`.`description`, `Jury`.`main_image`, `Jury`.`main_image_dir`, `Jury`.`image`, `Jury`.`image_dir`, `Jury`.`elem_tag`, `Jury`.`created`, `Jury`.`modified`, (CONCAT("/files/jury/image/",`Jury`.`image_dir`, "/", `Jury`.`image`)) AS `Jury__image_path`, (CONCAT("/files/jury/main_image/",`Jury`.`main_image_dir`, "/", `Jury`.`main_image`)) AS `Jury__main_image_path` FROM `krakenco_masterchef`.`juries` AS `Jury` WHERE `Jury`.`season_id` IN (3, 4) | 4 | 4 | 1 | maybe slow |
| SELECT `Participant`.`id`, `Participant`.`season_id`, `Participant`.`name`, `Participant`.`description`, `Participant`.`eliminated`, `Participant`.`image`, `Participant`.`image_dir`, `Participant`.`elem_tag`, `Participant`.`published_comment_count`, `Participant`.`created`, `Participant`.`modified`, (CONCAT("/files/participant/image/",`Participant`.`image_dir`, "/", `Participant`.`image`)) AS `Participant__image_path` FROM `krakenco_masterchef`.`participants` AS `Participant` WHERE `Participant`.`season_id` IN (3, 4) | 36 | 36 | 3 | maybe slow |
| SELECT `Program`.`id`, `Program`.`name`, `Program`.`date`, `Program`.`video_id`, `Program`.`description`, `Program`.`season_id`, `Program`.`elem_tag`, `Program`.`published_comment_count`, `Program`.`active`, `Program`.`created`, `Program`.`modified` FROM `krakenco_masterchef`.`programs` AS `Program` WHERE `Program`.`season_id` IN (3, 4) | 18 | 18 | 4 | maybe slow |
| SELECT `Recipe`.`id`, `Recipe`.`name`, `Recipe`.`image`, `Recipe`.`image_dir`, `Recipe`.`video_id`, `Recipe`.`description`, `Recipe`.`ingredients`, `Recipe`.`preparation`, `Recipe`.`dificulty`, `Recipe`.`duration`, `Recipe`.`portions`, `Recipe`.`highlight`, `Recipe`.`program_id`, `Recipe`.`season_id`, `Recipe`.`date`, `Recipe`.`published_comment_count`, `Recipe`.`elem_tag`, `Recipe`.`vip`, `Recipe`.`active`, `Recipe`.`created`, `Recipe`.`modified`, (CONCAT("/files/recipe/image/",`Recipe`.`image_dir`, "/", `Recipe`.`image`)) AS `Recipe__image_path` FROM `krakenco_masterchef`.`recipes` AS `Recipe` WHERE `Recipe`.`season_id` IN (3, 4) | 59 | 59 | 4 | maybe slow |
| SELECT `Scene`.`id`, `Scene`.`title`, `Scene`.`date`, `Scene`.`description`, `Scene`.`video_id`, `Scene`.`program_id`, `Scene`.`season_id`, `Scene`.`elem_tag`, `Scene`.`published_comment_count`, `Scene`.`active`, `Scene`.`created`, `Scene`.`modified` FROM `krakenco_masterchef`.`scenes` AS `Scene` WHERE `Scene`.`season_id` IN (3, 4) | 267 | 267 | 12 | |
| SELECT `Bannerhome`.`id`, `Bannerhome`.`season_id`, `Bannerhome`.`title`, `Bannerhome`.`subt`, `Bannerhome`.`link`, `Bannerhome`.`orderelem`, `Bannerhome`.`active`, `Bannerhome`.`img`, `Bannerhome`.`img_dir`, `Bannerhome`.`created`, `Bannerhome`.`modified`, (CONCAT("/files/bannerhome/img/",`Bannerhome`.`img_dir`, "/", `Bannerhome`.`img`)) AS `Bannerhome__img_path` FROM `krakenco_masterchef`.`bannerhomes` AS `Bannerhome` WHERE `Bannerhome`.`season_id` IN (3, 4) | 20 | 20 | 1 | maybe slow |
| SELECT scat.name, scat.id FROM `scategories` scat right join scenes_scategories s_s on scat.id=s_s.scategory_id right join scenes sce on s_s.scene_id=sce.id where sce.season_id=3 GROUP by scat.name | 7 | 7 | 2 | maybe slow |
| SELECT `Season`.`id`, `Season`.`logo`, `Season`.`logo_dir`, `Season`.`anonymous_participants`, (CONCAT("/files/season/logo/",`Season`.`logo_dir`, "/", `Season`.`logo`)) AS `Season__logo_path` FROM `krakenco_masterchef`.`seasons` AS `Season` WHERE `Season`.`id` = 3 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `Scene`.`id`, `Scene`.`title`, `Scene`.`date`, `Scene`.`description`, `Scene`.`video_id`, `Scene`.`program_id`, `Scene`.`season_id`, `Scene`.`elem_tag`, `Scene`.`published_comment_count`, `Scene`.`active`, `Scene`.`created`, `Scene`.`modified`, `Program`.`id`, `Program`.`name`, `Program`.`date`, `Program`.`video_id`, `Program`.`description`, `Program`.`season_id`, `Program`.`elem_tag`, `Program`.`published_comment_count`, `Program`.`active`, `Program`.`created`, `Program`.`modified`, `Season`.`id`, `Season`.`name`, `Season`.`date`, `Season`.`description`, `Season`.`anonymous_participants`, `Season`.`image`, `Season`.`image_dir`, `Season`.`logo`, `Season`.`logo_dir`, `Season`.`jury_banner`, `Season`.`jury_banner_dir`, `Season`.`created`, `Season`.`modified`, (CONCAT("/files/season/image/",`Season`.`image_dir`, "/", `Season`.`image`)) AS `Season__image_path`, (CONCAT("/files/season/logo/",`Season`.`logo_dir`, "/", `Season`.`logo`)) AS `Season__logo_path`, (CONCAT("/files/season/jury_banner/",`Season`.`jury_banner_dir`, "/", `Season`.`jury_banner`)) AS `Season__jury_banner_path` FROM `krakenco_masterchef`.`scenes` AS `Scene` LEFT JOIN `krakenco_masterchef`.`programs` AS `Program` ON (`Scene`.`program_id` = `Program`.`id`) LEFT JOIN `krakenco_masterchef`.`seasons` AS `Season` ON (`Scene`.`season_id` = `Season`.`id`) WHERE `Scene`.`season_id` = 3 AND `Scene`.`active` = '1' | 258 | 258 | 26 | maybe slow |
| SELECT `Video`.`id`, `Video`.`season_id`, `Video`.`frameid`, `Video`.`thumb`, `Video`.`thumb_dir`, `Video`.`premium`, `Video`.`highlight`, `Video`.`map`, `Video`.`label`, `Video`.`date`, `Video`.`scene_cat`, `Video`.`fk`, `Video`.`active`, `Video`.`short_desc`, `Video`.`created`, `Video`.`modified`, (CONCAT("/files/video/thumb/",`Video`.`thumb_dir`, "/", `Video`.`thumb`)) AS `Video__thumb_path` FROM `krakenco_masterchef`.`videos` AS `Video` WHERE `Video`.`map` = 'Scene' AND `Video`.`fk` IN (16, 17, 18, 19, 21, 22, 23, 24, 25, 28, 29, 32, 33, 34, 35, 37, 38, 39, 40, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 283) | 258 | 258 | 3 | |
| SELECT `Comment`.`id`, `Comment`.`model`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`published`, `Comment`.`moderated`, `Comment`.`pending_moderation`, `Comment`.`censored`, `Comment`.`deleted`, `Comment`.`created`, `Comment`.`modified` FROM `krakenco_masterchef`.`comments` AS `Comment` WHERE `Comment`.`model` = 'Scene' AND `Comment`.`foreign_key` IN (16, 17, 18, 19, 21, 22, 23, 24, 25, 28, 29, 32, 33, 34, 35, 37, 38, 39, 40, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 283) | 267 | 267 | 3 | |
| SELECT `Scategory`.`id`, `Scategory`.`name`, `Scategory`.`code`, `Scategory`.`color`, `Scategory`.`pos`, `ScenesScategory`.`id`, `ScenesScategory`.`scene_id`, `ScenesScategory`.`scategory_id` FROM `krakenco_masterchef`.`scategories` AS `Scategory` JOIN `krakenco_masterchef`.`scenes_scategories` AS `ScenesScategory` ON (`ScenesScategory`.`scene_id` IN (16, 17, 18, 19, 21, 22, 23, 24, 25, 28, 29, 32, 33, 34, 35, 37, 38, 39, 40, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 283) AND `ScenesScategory`.`scategory_id` = `Scategory`.`id`) | 258 | 258 | 2 | |
| SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `krakenco_masterchef`.`tags` AS `Tag` JOIN `krakenco_masterchef`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (16, 17, 18, 19, 21, 22, 23, 24, 25, 28, 29, 32, 33, 34, 35, 37, 38, 39, 40, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 283) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Scene' | 2914 | 2914 | 23 | |
| SELECT `Recipe`.`id`, `Recipe`.`name`, `Recipe`.`image`, `Recipe`.`image_dir`, `Recipe`.`video_id`, `Recipe`.`description`, `Recipe`.`ingredients`, `Recipe`.`preparation`, `Recipe`.`dificulty`, `Recipe`.`duration`, `Recipe`.`portions`, `Recipe`.`highlight`, `Recipe`.`program_id`, `Recipe`.`season_id`, `Recipe`.`date`, `Recipe`.`published_comment_count`, `Recipe`.`elem_tag`, `Recipe`.`vip`, `Recipe`.`active`, `Recipe`.`created`, `Recipe`.`modified`, (CONCAT("/files/recipe/image/",`Recipe`.`image_dir`, "/", `Recipe`.`image`)) AS `Recipe__image_path`, `Program`.`id`, `Program`.`name`, `Program`.`date`, `Program`.`video_id`, `Program`.`description`, `Program`.`season_id`, `Program`.`elem_tag`, `Program`.`published_comment_count`, `Program`.`active`, `Program`.`created`, `Program`.`modified`, `Season`.`id`, `Season`.`name`, `Season`.`date`, `Season`.`description`, `Season`.`anonymous_participants`, `Season`.`image`, `Season`.`image_dir`, `Season`.`logo`, `Season`.`logo_dir`, `Season`.`jury_banner`, `Season`.`jury_banner_dir`, `Season`.`created`, `Season`.`modified`, (CONCAT("/files/season/image/",`Season`.`image_dir`, "/", `Season`.`image`)) AS `Season__image_path`, (CONCAT("/files/season/logo/",`Season`.`logo_dir`, "/", `Season`.`logo`)) AS `Season__logo_path`, (CONCAT("/files/season/jury_banner/",`Season`.`jury_banner_dir`, "/", `Season`.`jury_banner`)) AS `Season__jury_banner_path` FROM `krakenco_masterchef`.`recipes` AS `Recipe` LEFT JOIN `krakenco_masterchef`.`programs` AS `Program` ON (`Recipe`.`program_id` = `Program`.`id`) LEFT JOIN `krakenco_masterchef`.`seasons` AS `Season` ON (`Recipe`.`season_id` = `Season`.`id`) WHERE `Recipe`.`season_id` = 3 AND `Recipe`.`active` = '1' | 55 | 55 | 6 | maybe slow |
| SELECT `Video`.`id`, `Video`.`season_id`, `Video`.`frameid`, `Video`.`thumb`, `Video`.`thumb_dir`, `Video`.`premium`, `Video`.`highlight`, `Video`.`map`, `Video`.`label`, `Video`.`date`, `Video`.`scene_cat`, `Video`.`fk`, `Video`.`active`, `Video`.`short_desc`, `Video`.`created`, `Video`.`modified`, (CONCAT("/files/video/thumb/",`Video`.`thumb_dir`, "/", `Video`.`thumb`)) AS `Video__thumb_path` FROM `krakenco_masterchef`.`videos` AS `Video` WHERE `Video`.`map` = 'Recipe' AND `Video`.`fk` IN (2, 4, 5, 6, 7, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61) | 55 | 55 | 2 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`name`, `Image`.`attachment`, `Image`.`dir`, `Image`.`type`, `Image`.`size`, `Image`.`active`, `Image`.`tipo`, (CONCAT("/files/attachment/",dir,"/", attachment)) AS `Image__path` FROM `krakenco_masterchef`.`attachments` AS `Image` WHERE `Image`.`model` = 'Recipe' AND `Image`.`foreign_key` IN (2, 4, 5, 6, 7, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61) | 0 | 0 | 1 | maybe slow |
| SELECT `Comment`.`id`, `Comment`.`model`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`published`, `Comment`.`moderated`, `Comment`.`pending_moderation`, `Comment`.`censored`, `Comment`.`deleted`, `Comment`.`created`, `Comment`.`modified` FROM `krakenco_masterchef`.`comments` AS `Comment` WHERE `Comment`.`model` = 'Recipe' AND `Comment`.`foreign_key` IN (2, 4, 5, 6, 7, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61) | 44 | 44 | 2 | |
| SELECT `Rcategory`.`id`, `Rcategory`.`name`, `RecipesRcategory`.`id`, `RecipesRcategory`.`recipe_id`, `RecipesRcategory`.`rcategory_id` FROM `krakenco_masterchef`.`rcategories` AS `Rcategory` JOIN `krakenco_masterchef`.`recipes_rcategories` AS `RecipesRcategory` ON (`RecipesRcategory`.`recipe_id` IN (2, 4, 5, 6, 7, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61) AND `RecipesRcategory`.`rcategory_id` = `Rcategory`.`id`) | 5 | 5 | 1 | maybe slow |
| SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `krakenco_masterchef`.`tags` AS `Tag` JOIN `krakenco_masterchef`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (2, 4, 5, 6, 7, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Recipe' | 554 | 554 | 6 | |
| SELECT `Program`.`id`, `Program`.`name`, `Program`.`date`, `Program`.`video_id`, `Program`.`description`, `Program`.`season_id`, `Program`.`elem_tag`, `Program`.`published_comment_count`, `Program`.`active`, `Program`.`created`, `Program`.`modified`, `Season`.`id`, `Season`.`name`, `Season`.`date`, `Season`.`description`, `Season`.`anonymous_participants`, `Season`.`image`, `Season`.`image_dir`, `Season`.`logo`, `Season`.`logo_dir`, `Season`.`jury_banner`, `Season`.`jury_banner_dir`, `Season`.`created`, `Season`.`modified`, (CONCAT("/files/season/image/",`Season`.`image_dir`, "/", `Season`.`image`)) AS `Season__image_path`, (CONCAT("/files/season/logo/",`Season`.`logo_dir`, "/", `Season`.`logo`)) AS `Season__logo_path`, (CONCAT("/files/season/jury_banner/",`Season`.`jury_banner_dir`, "/", `Season`.`jury_banner`)) AS `Season__jury_banner_path` FROM `krakenco_masterchef`.`programs` AS `Program` LEFT JOIN `krakenco_masterchef`.`seasons` AS `Season` ON (`Program`.`season_id` = `Season`.`id`) WHERE `Program`.`season_id` = 3 AND `Program`.`active` = '1' | 18 | 18 | 2 | maybe slow |
| SELECT `Video`.`id`, `Video`.`season_id`, `Video`.`frameid`, `Video`.`thumb`, `Video`.`thumb_dir`, `Video`.`premium`, `Video`.`highlight`, `Video`.`map`, `Video`.`label`, `Video`.`date`, `Video`.`scene_cat`, `Video`.`fk`, `Video`.`active`, `Video`.`short_desc`, `Video`.`created`, `Video`.`modified`, (CONCAT("/files/video/thumb/",`Video`.`thumb_dir`, "/", `Video`.`thumb`)) AS `Video__thumb_path` FROM `krakenco_masterchef`.`videos` AS `Video` WHERE `Video`.`map` = 'Program' AND `Video`.`fk` IN (9, 11, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) | 18 | 18 | 1 | maybe slow |
| SELECT `Recipe`.`id`, `Recipe`.`name`, `Recipe`.`image`, `Recipe`.`image_dir`, `Recipe`.`video_id`, `Recipe`.`description`, `Recipe`.`ingredients`, `Recipe`.`preparation`, `Recipe`.`dificulty`, `Recipe`.`duration`, `Recipe`.`portions`, `Recipe`.`highlight`, `Recipe`.`program_id`, `Recipe`.`season_id`, `Recipe`.`date`, `Recipe`.`published_comment_count`, `Recipe`.`elem_tag`, `Recipe`.`vip`, `Recipe`.`active`, `Recipe`.`created`, `Recipe`.`modified`, (CONCAT("/files/recipe/image/",`Recipe`.`image_dir`, "/", `Recipe`.`image`)) AS `Recipe__image_path` FROM `krakenco_masterchef`.`recipes` AS `Recipe` WHERE `Recipe`.`program_id` IN (9, 11, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) | 59 | 59 | 2 | |
| SELECT `Scene`.`id`, `Scene`.`title`, `Scene`.`date`, `Scene`.`description`, `Scene`.`video_id`, `Scene`.`program_id`, `Scene`.`season_id`, `Scene`.`elem_tag`, `Scene`.`published_comment_count`, `Scene`.`active`, `Scene`.`created`, `Scene`.`modified` FROM `krakenco_masterchef`.`scenes` AS `Scene` WHERE `Scene`.`program_id` IN (9, 11, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) | 267 | 267 | 6 | |
| SELECT `Comment`.`id`, `Comment`.`model`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`published`, `Comment`.`moderated`, `Comment`.`pending_moderation`, `Comment`.`censored`, `Comment`.`deleted`, `Comment`.`created`, `Comment`.`modified` FROM `krakenco_masterchef`.`comments` AS `Comment` WHERE `Comment`.`model` = 'Program' AND `Comment`.`foreign_key` IN (9, 11, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) | 509 | 509 | 4 | |
| SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `krakenco_masterchef`.`tags` AS `Tag` JOIN `krakenco_masterchef`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (9, 11, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Program' | 121 | 121 | 2 | |
| SELECT `Video`.`id`, `Video`.`season_id`, `Video`.`frameid`, `Video`.`thumb`, `Video`.`thumb_dir`, `Video`.`premium`, `Video`.`highlight`, `Video`.`map`, `Video`.`label`, `Video`.`date`, `Video`.`scene_cat`, `Video`.`fk`, `Video`.`active`, `Video`.`short_desc`, `Video`.`created`, `Video`.`modified`, (CONCAT("/files/video/thumb/",`Video`.`thumb_dir`, "/", `Video`.`thumb`)) AS `Video__thumb_path`, `Program`.`id`, `Program`.`name`, `Program`.`date`, `Program`.`video_id`, `Program`.`description`, `Program`.`season_id`, `Program`.`elem_tag`, `Program`.`published_comment_count`, `Program`.`active`, `Program`.`created`, `Program`.`modified`, `Scene`.`id`, `Scene`.`title`, `Scene`.`date`, `Scene`.`description`, `Scene`.`video_id`, `Scene`.`program_id`, `Scene`.`season_id`, `Scene`.`elem_tag`, `Scene`.`published_comment_count`, `Scene`.`active`, `Scene`.`created`, `Scene`.`modified`, `Recipe`.`id`, `Recipe`.`name`, `Recipe`.`image`, `Recipe`.`image_dir`, `Recipe`.`video_id`, `Recipe`.`description`, `Recipe`.`ingredients`, `Recipe`.`preparation`, `Recipe`.`dificulty`, `Recipe`.`duration`, `Recipe`.`portions`, `Recipe`.`highlight`, `Recipe`.`program_id`, `Recipe`.`season_id`, `Recipe`.`date`, `Recipe`.`published_comment_count`, `Recipe`.`elem_tag`, `Recipe`.`vip`, `Recipe`.`active`, `Recipe`.`created`, `Recipe`.`modified`, (CONCAT("/files/recipe/image/",`Recipe`.`image_dir`, "/", `Recipe`.`image`)) AS `Recipe__image_path`, `Jury`.`id`, `Jury`.`season_id`, `Jury`.`name`, `Jury`.`short_description`, `Jury`.`description`, `Jury`.`main_image`, `Jury`.`main_image_dir`, `Jury`.`image`, `Jury`.`image_dir`, `Jury`.`elem_tag`, `Jury`.`created`, `Jury`.`modified`, (CONCAT("/files/jury/image/",`Jury`.`image_dir`, "/", `Jury`.`image`)) AS `Jury__image_path`, (CONCAT("/files/jury/main_image/",`Jury`.`main_image_dir`, "/", `Jury`.`main_image`)) AS `Jury__main_image_path` FROM `krakenco_masterchef`.`videos` AS `Video` LEFT JOIN `krakenco_masterchef`.`programs` AS `Program` ON (`Video`.`fk` = `Program`.`id` AND `Video`.`map` = 'Program') LEFT JOIN `krakenco_masterchef`.`scenes` AS `Scene` ON (`Video`.`fk` = `Scene`.`id` AND `Video`.`map` = 'Scene') LEFT JOIN `krakenco_masterchef`.`recipes` AS `Recipe` ON (`Video`.`fk` = `Recipe`.`id` AND `Video`.`map` = 'Recipe') LEFT JOIN `krakenco_masterchef`.`juries` AS `Jury` ON (`Video`.`fk` = `Jury`.`id` AND `Video`.`map` = 'Jury') WHERE ((((`Video`.`map` = 'Scene') AND (`Video`.`fk` IN (16, 17, 18, 19, 21, 22, 23, 24, 25, 28, 29, 32, 33, 34, 35, 37, 38, 39, 40, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 283)) AND (`Video`.`active` = '1'))) OR (((`Video`.`map` = 'Recipe') AND (`Video`.`fk` IN (2, 4, 5, 6, 7, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61)) AND (`Video`.`active` = '1'))) OR (((`Video`.`map` = 'Program') AND (`Video`.`fk` IN (9, 11, 13, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29)) AND (`Video`.`active` = '1')))) AND `Video`.`premium` = '1' AND `Video`.`active` = '1' ORDER BY `Video`.`id` desc LIMIT 21 | 1 | 1 | 3 | maybe slow |
| SELECT `Jury`.`id`, `Jury`.`name` FROM `krakenco_masterchef`.`juries` AS `Jury` WHERE `Jury`.`season_id` = 3 | 3 | 3 | 1 | maybe slow |
| SELECT LOWER(TRIM(`Jury`.`name`)) AS name, COUNT(*) AS count, `Jury`.`id` FROM `krakenco_masterchef`.`juries` AS `Jury` LEFT JOIN `krakenco_masterchef`.`seasons` AS `Season` ON (`Jury`.`season_id` = `Season`.`id`) WHERE `Jury`.`season_id` = 3 GROUP BY name | 3 | 3 | 1 | maybe slow |
| SELECT `Video`.`id`, `Video`.`season_id`, `Video`.`frameid`, `Video`.`thumb`, `Video`.`thumb_dir`, `Video`.`premium`, `Video`.`highlight`, `Video`.`map`, `Video`.`label`, `Video`.`date`, `Video`.`scene_cat`, `Video`.`fk`, `Video`.`active`, `Video`.`short_desc`, `Video`.`created`, `Video`.`modified`, (CONCAT("/files/video/thumb/",`Video`.`thumb_dir`, "/", `Video`.`thumb`)) AS `Video__thumb_path` FROM `krakenco_masterchef`.`videos` AS `Video` WHERE `Video`.`map` = 'Jury' AND `Video`.`fk` IN (3, 2, 1) | 3 | 3 | 1 | maybe slow |
| SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `krakenco_masterchef`.`tags` AS `Tag` JOIN `krakenco_masterchef`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (3, 2, 1) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Jury' | 2 | 2 | 1 | maybe slow |
| SELECT `Participant`.`id`, `Participant`.`name` FROM `krakenco_masterchef`.`participants` AS `Participant` WHERE `Participant`.`season_id` = 3 | 18 | 18 | 3 | maybe slow |
| SELECT LOWER(TRIM(`Participant`.`name`)) AS name, COUNT(*) AS count, `Participant`.`id` FROM `krakenco_masterchef`.`participants` AS `Participant` LEFT JOIN `krakenco_masterchef`.`seasons` AS `Season` ON (`Participant`.`season_id` = `Season`.`id`) WHERE `Participant`.`season_id` = 3 GROUP BY name | 18 | 18 | 1 | maybe slow |
| SELECT `Comment`.`id`, `Comment`.`model`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`published`, `Comment`.`moderated`, `Comment`.`pending_moderation`, `Comment`.`censored`, `Comment`.`deleted`, `Comment`.`created`, `Comment`.`modified` FROM `krakenco_masterchef`.`comments` AS `Comment` WHERE `Comment`.`model` = 'Participant' AND `Comment`.`foreign_key` IN (18, 4, 10, 12, 9, 7, 11, 14, 6, 17, 16, 13, 20, 15, 5, 8, 3, 19) | 452 | 452 | 4 | |
| SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `krakenco_masterchef`.`tags` AS `Tag` JOIN `krakenco_masterchef`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (18, 4, 10, 12, 9, 7, 11, 14, 6, 17, 16, 13, 20, 15, 5, 8, 3, 19) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Participant' | 0 | 0 | 1 | maybe slow |
| SELECT `Recipe`.`id`, `Recipe`.`name` FROM `krakenco_masterchef`.`recipes` AS `Recipe` WHERE `Recipe`.`season_id` = 3 AND `Recipe`.`active` = '1' | 55 | 55 | 1 | |
| SELECT LOWER(TRIM(`Recipe`.`name`)) AS name, COUNT(*) AS count, `Recipe`.`id` FROM `krakenco_masterchef`.`recipes` AS `Recipe` LEFT JOIN `krakenco_masterchef`.`programs` AS `Program` ON (`Recipe`.`program_id` = `Program`.`id`) LEFT JOIN `krakenco_masterchef`.`seasons` AS `Season` ON (`Recipe`.`season_id` = `Season`.`id`) WHERE `Recipe`.`season_id` = 3 AND `Recipe`.`active` = '1' GROUP BY name | 55 | 55 | 2 | |
| SELECT `Video`.`id`, `Video`.`season_id`, `Video`.`frameid`, `Video`.`thumb`, `Video`.`thumb_dir`, `Video`.`premium`, `Video`.`highlight`, `Video`.`map`, `Video`.`label`, `Video`.`date`, `Video`.`scene_cat`, `Video`.`fk`, `Video`.`active`, `Video`.`short_desc`, `Video`.`created`, `Video`.`modified`, (CONCAT("/files/video/thumb/",`Video`.`thumb_dir`, "/", `Video`.`thumb`)) AS `Video__thumb_path` FROM `krakenco_masterchef`.`videos` AS `Video` WHERE `Video`.`map` = 'Recipe' AND `Video`.`fk` IN (20, 57, 26, 27, 56, 14, 39, 30, 52, 12, 23, 40, 48, 51, 18, 5, 58, 13, 28, 42, 21, 7, 15, 2, 36, 46, 19, 37, 32, 33, 55, 11, 43, 6, 22, 17, 16, 4, 38, 53, 24, 59, 60, 44, 35, 61, 34, 45, 49, 47, 25, 31, 41, 54, 29) | 55 | 55 | 2 | |
| SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`name`, `Image`.`attachment`, `Image`.`dir`, `Image`.`type`, `Image`.`size`, `Image`.`active`, `Image`.`tipo`, (CONCAT("/files/attachment/",dir,"/", attachment)) AS `Image__path` FROM `krakenco_masterchef`.`attachments` AS `Image` WHERE `Image`.`model` = 'Recipe' AND `Image`.`foreign_key` IN (20, 57, 26, 27, 56, 14, 39, 30, 52, 12, 23, 40, 48, 51, 18, 5, 58, 13, 28, 42, 21, 7, 15, 2, 36, 46, 19, 37, 32, 33, 55, 11, 43, 6, 22, 17, 16, 4, 38, 53, 24, 59, 60, 44, 35, 61, 34, 45, 49, 47, 25, 31, 41, 54, 29) | 0 | 0 | 1 | maybe slow |
| SELECT `Comment`.`id`, `Comment`.`model`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`published`, `Comment`.`moderated`, `Comment`.`pending_moderation`, `Comment`.`censored`, `Comment`.`deleted`, `Comment`.`created`, `Comment`.`modified` FROM `krakenco_masterchef`.`comments` AS `Comment` WHERE `Comment`.`model` = 'Recipe' AND `Comment`.`foreign_key` IN (20, 57, 26, 27, 56, 14, 39, 30, 52, 12, 23, 40, 48, 51, 18, 5, 58, 13, 28, 42, 21, 7, 15, 2, 36, 46, 19, 37, 32, 33, 55, 11, 43, 6, 22, 17, 16, 4, 38, 53, 24, 59, 60, 44, 35, 61, 34, 45, 49, 47, 25, 31, 41, 54, 29) | 44 | 44 | 2 | |
| SELECT `Rcategory`.`id`, `Rcategory`.`name`, `RecipesRcategory`.`id`, `RecipesRcategory`.`recipe_id`, `RecipesRcategory`.`rcategory_id` FROM `krakenco_masterchef`.`rcategories` AS `Rcategory` JOIN `krakenco_masterchef`.`recipes_rcategories` AS `RecipesRcategory` ON (`RecipesRcategory`.`recipe_id` IN (20, 57, 26, 27, 56, 14, 39, 30, 52, 12, 23, 40, 48, 51, 18, 5, 58, 13, 28, 42, 21, 7, 15, 2, 36, 46, 19, 37, 32, 33, 55, 11, 43, 6, 22, 17, 16, 4, 38, 53, 24, 59, 60, 44, 35, 61, 34, 45, 49, 47, 25, 31, 41, 54, 29) AND `RecipesRcategory`.`rcategory_id` = `Rcategory`.`id`) | 5 | 5 | 1 | maybe slow |
| SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `krakenco_masterchef`.`tags` AS `Tag` JOIN `krakenco_masterchef`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (20, 57, 26, 27, 56, 14, 39, 30, 52, 12, 23, 40, 48, 51, 18, 5, 58, 13, 28, 42, 21, 7, 15, 2, 36, 46, 19, 37, 32, 33, 55, 11, 43, 6, 22, 17, 16, 4, 38, 53, 24, 59, 60, 44, 35, 61, 34, 45, 49, 47, 25, 31, 41, 54, 29) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Recipe' | 554 | 554 | 6 | |
| SELECT `Program`.`id`, `Program`.`name` FROM `krakenco_masterchef`.`programs` AS `Program` WHERE `Program`.`season_id` = 3 AND `Program`.`active` = '1' | 18 | 18 | 1 | maybe slow |
| SELECT LOWER(TRIM(`Program`.`name`)) AS name, COUNT(*) AS count, `Program`.`id` FROM `krakenco_masterchef`.`programs` AS `Program` LEFT JOIN `krakenco_masterchef`.`seasons` AS `Season` ON (`Program`.`season_id` = `Season`.`id`) WHERE `Program`.`season_id` = 3 AND `Program`.`active` = '1' GROUP BY name | 18 | 18 | 1 | maybe slow |
| SELECT `Video`.`id`, `Video`.`season_id`, `Video`.`frameid`, `Video`.`thumb`, `Video`.`thumb_dir`, `Video`.`premium`, `Video`.`highlight`, `Video`.`map`, `Video`.`label`, `Video`.`date`, `Video`.`scene_cat`, `Video`.`fk`, `Video`.`active`, `Video`.`short_desc`, `Video`.`created`, `Video`.`modified`, (CONCAT("/files/video/thumb/",`Video`.`thumb_dir`, "/", `Video`.`thumb`)) AS `Video__thumb_path` FROM `krakenco_masterchef`.`videos` AS `Video` WHERE `Video`.`map` = 'Program' AND `Video`.`fk` IN (11, 22, 23, 24, 25, 26, 27, 28, 29, 13, 15, 16, 17, 18, 19, 20, 21, 9) | 18 | 18 | 2 | maybe slow |
| SELECT `Recipe`.`id`, `Recipe`.`name`, `Recipe`.`image`, `Recipe`.`image_dir`, `Recipe`.`video_id`, `Recipe`.`description`, `Recipe`.`ingredients`, `Recipe`.`preparation`, `Recipe`.`dificulty`, `Recipe`.`duration`, `Recipe`.`portions`, `Recipe`.`highlight`, `Recipe`.`program_id`, `Recipe`.`season_id`, `Recipe`.`date`, `Recipe`.`published_comment_count`, `Recipe`.`elem_tag`, `Recipe`.`vip`, `Recipe`.`active`, `Recipe`.`created`, `Recipe`.`modified`, (CONCAT("/files/recipe/image/",`Recipe`.`image_dir`, "/", `Recipe`.`image`)) AS `Recipe__image_path` FROM `krakenco_masterchef`.`recipes` AS `Recipe` WHERE `Recipe`.`program_id` IN (11, 22, 23, 24, 25, 26, 27, 28, 29, 13, 15, 16, 17, 18, 19, 20, 21, 9) | 59 | 59 | 2 | |
| SELECT `Scene`.`id`, `Scene`.`title`, `Scene`.`date`, `Scene`.`description`, `Scene`.`video_id`, `Scene`.`program_id`, `Scene`.`season_id`, `Scene`.`elem_tag`, `Scene`.`published_comment_count`, `Scene`.`active`, `Scene`.`created`, `Scene`.`modified` FROM `krakenco_masterchef`.`scenes` AS `Scene` WHERE `Scene`.`program_id` IN (11, 22, 23, 24, 25, 26, 27, 28, 29, 13, 15, 16, 17, 18, 19, 20, 21, 9) | 267 | 267 | 8 | |
| SELECT `Comment`.`id`, `Comment`.`model`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`published`, `Comment`.`moderated`, `Comment`.`pending_moderation`, `Comment`.`censored`, `Comment`.`deleted`, `Comment`.`created`, `Comment`.`modified` FROM `krakenco_masterchef`.`comments` AS `Comment` WHERE `Comment`.`model` = 'Program' AND `Comment`.`foreign_key` IN (11, 22, 23, 24, 25, 26, 27, 28, 29, 13, 15, 16, 17, 18, 19, 20, 21, 9) | 509 | 509 | 4 | |
| SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `krakenco_masterchef`.`tags` AS `Tag` JOIN `krakenco_masterchef`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (11, 22, 23, 24, 25, 26, 27, 28, 29, 13, 15, 16, 17, 18, 19, 20, 21, 9) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Program' | 121 | 121 | 2 | |
| SELECT `Scategory`.`id`, `Scategory`.`name` FROM `krakenco_masterchef`.`scategories` AS `Scategory` WHERE 1 = 1 | 7 | 7 | 2 | maybe slow |
| SELECT LOWER(TRIM(`Scategory`.`name`)) AS name, COUNT(*) AS count FROM `krakenco_masterchef`.`scategories` AS `Scategory` WHERE 1 = 1 GROUP BY name | 7 | 7 | 1 | maybe slow |
| SELECT `Scene`.`id`, `Scene`.`title` FROM `krakenco_masterchef`.`scenes` AS `Scene` WHERE `Scene`.`season_id` = 3 AND `Scene`.`active` = '1' | 258 | 258 | 2 | |
| SELECT LOWER(TRIM(`Scene`.`title`)) AS title, COUNT(*) AS count, `Scene`.`id` FROM `krakenco_masterchef`.`scenes` AS `Scene` LEFT JOIN `krakenco_masterchef`.`programs` AS `Program` ON (`Scene`.`program_id` = `Program`.`id`) LEFT JOIN `krakenco_masterchef`.`seasons` AS `Season` ON (`Scene`.`season_id` = `Season`.`id`) WHERE `Scene`.`season_id` = 3 AND `Scene`.`active` = '1' GROUP BY title | 255 | 255 | 2 | |
| SELECT `Video`.`id`, `Video`.`season_id`, `Video`.`frameid`, `Video`.`thumb`, `Video`.`thumb_dir`, `Video`.`premium`, `Video`.`highlight`, `Video`.`map`, `Video`.`label`, `Video`.`date`, `Video`.`scene_cat`, `Video`.`fk`, `Video`.`active`, `Video`.`short_desc`, `Video`.`created`, `Video`.`modified`, (CONCAT("/files/video/thumb/",`Video`.`thumb_dir`, "/", `Video`.`thumb`)) AS `Video__thumb_path` FROM `krakenco_masterchef`.`videos` AS `Video` WHERE `Video`.`map` = 'Scene' AND `Video`.`fk` IN (164, 225, 223, 103, 219, 191, 87, 177, 192, 194, 180, 195, 206, 63, 181, 171, 166, 51, 265, 268, 90, 39, 22, 187, 124, 62, 58, 146, 215, 150, 198, 232, 156, 155, 81, 44, 251, 129, 126, 88, 123, 162, 121, 242, 179, 226, 216, 204, 173, 233, 160, 253, 221, 185, 137, 190, 231, 235, 217, 52, 54, 80, 222, 176, 255, 118, 95, 50, 153, 214, 119, 83, 45, 178, 170, 91, 248, 213, 64, 49, 168, 169, 158, 57, 77, 74, 122, 117, 48, 230, 149, 220, 97, 281, 243, 188, 47, 167, 196, 208, 224, 239, 112, 127, 142, 42, 120, 154, 110, 267, 277, 59, 278, 143, 135, 29, 202, 85, 116, 96, 108, 125, 114, 111, 86, 252, 144, 130, 46, 165, 159, 140, 102, 78, 69, 105, 25, 66, 84, 65, 272, 76, 211, 274, 60, 203, 266, 275, 273, 89, 147, 38, 79, 271, 209, 201, 186, 279, 263, 269, 98, 53, 136, 75, 101, 28, 61, 139, 70, 264, 37, 19, 240, 238, 161, 200, 68, 210, 207, 115, 100, 132, 17, 174, 280, 92, 189, 32, 145, 106, 93, 18, 24, 218, 245, 212, 33, 34, 151, 163, 94, 199, 184, 183, 107, 43, 35, 237, 73, 261, 246, 258, 141, 175, 247, 229, 40, 16, 249, 234, 259, 133, 276, 250, 67, 152, 148, 283, 128, 257, 236, 21, 254, 113, 56, 157, 72, 205, 256, 270, 138, 23, 227, 82, 134, 182, 131, 55, 241, 193, 104, 109, 262, 244, 71) | 255 | 255 | 3 | |
| SELECT `Comment`.`id`, `Comment`.`model`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`published`, `Comment`.`moderated`, `Comment`.`pending_moderation`, `Comment`.`censored`, `Comment`.`deleted`, `Comment`.`created`, `Comment`.`modified` FROM `krakenco_masterchef`.`comments` AS `Comment` WHERE `Comment`.`model` = 'Scene' AND `Comment`.`foreign_key` IN (164, 225, 223, 103, 219, 191, 87, 177, 192, 194, 180, 195, 206, 63, 181, 171, 166, 51, 265, 268, 90, 39, 22, 187, 124, 62, 58, 146, 215, 150, 198, 232, 156, 155, 81, 44, 251, 129, 126, 88, 123, 162, 121, 242, 179, 226, 216, 204, 173, 233, 160, 253, 221, 185, 137, 190, 231, 235, 217, 52, 54, 80, 222, 176, 255, 118, 95, 50, 153, 214, 119, 83, 45, 178, 170, 91, 248, 213, 64, 49, 168, 169, 158, 57, 77, 74, 122, 117, 48, 230, 149, 220, 97, 281, 243, 188, 47, 167, 196, 208, 224, 239, 112, 127, 142, 42, 120, 154, 110, 267, 277, 59, 278, 143, 135, 29, 202, 85, 116, 96, 108, 125, 114, 111, 86, 252, 144, 130, 46, 165, 159, 140, 102, 78, 69, 105, 25, 66, 84, 65, 272, 76, 211, 274, 60, 203, 266, 275, 273, 89, 147, 38, 79, 271, 209, 201, 186, 279, 263, 269, 98, 53, 136, 75, 101, 28, 61, 139, 70, 264, 37, 19, 240, 238, 161, 200, 68, 210, 207, 115, 100, 132, 17, 174, 280, 92, 189, 32, 145, 106, 93, 18, 24, 218, 245, 212, 33, 34, 151, 163, 94, 199, 184, 183, 107, 43, 35, 237, 73, 261, 246, 258, 141, 175, 247, 229, 40, 16, 249, 234, 259, 133, 276, 250, 67, 152, 148, 283, 128, 257, 236, 21, 254, 113, 56, 157, 72, 205, 256, 270, 138, 23, 227, 82, 134, 182, 131, 55, 241, 193, 104, 109, 262, 244, 71) | 265 | 265 | 3 | |
| SELECT `Scategory`.`id`, `Scategory`.`name`, `Scategory`.`code`, `Scategory`.`color`, `Scategory`.`pos`, `ScenesScategory`.`id`, `ScenesScategory`.`scene_id`, `ScenesScategory`.`scategory_id` FROM `krakenco_masterchef`.`scategories` AS `Scategory` JOIN `krakenco_masterchef`.`scenes_scategories` AS `ScenesScategory` ON (`ScenesScategory`.`scene_id` IN (164, 225, 223, 103, 219, 191, 87, 177, 192, 194, 180, 195, 206, 63, 181, 171, 166, 51, 265, 268, 90, 39, 22, 187, 124, 62, 58, 146, 215, 150, 198, 232, 156, 155, 81, 44, 251, 129, 126, 88, 123, 162, 121, 242, 179, 226, 216, 204, 173, 233, 160, 253, 221, 185, 137, 190, 231, 235, 217, 52, 54, 80, 222, 176, 255, 118, 95, 50, 153, 214, 119, 83, 45, 178, 170, 91, 248, 213, 64, 49, 168, 169, 158, 57, 77, 74, 122, 117, 48, 230, 149, 220, 97, 281, 243, 188, 47, 167, 196, 208, 224, 239, 112, 127, 142, 42, 120, 154, 110, 267, 277, 59, 278, 143, 135, 29, 202, 85, 116, 96, 108, 125, 114, 111, 86, 252, 144, 130, 46, 165, 159, 140, 102, 78, 69, 105, 25, 66, 84, 65, 272, 76, 211, 274, 60, 203, 266, 275, 273, 89, 147, 38, 79, 271, 209, 201, 186, 279, 263, 269, 98, 53, 136, 75, 101, 28, 61, 139, 70, 264, 37, 19, 240, 238, 161, 200, 68, 210, 207, 115, 100, 132, 17, 174, 280, 92, 189, 32, 145, 106, 93, 18, 24, 218, 245, 212, 33, 34, 151, 163, 94, 199, 184, 183, 107, 43, 35, 237, 73, 261, 246, 258, 141, 175, 247, 229, 40, 16, 249, 234, 259, 133, 276, 250, 67, 152, 148, 283, 128, 257, 236, 21, 254, 113, 56, 157, 72, 205, 256, 270, 138, 23, 227, 82, 134, 182, 131, 55, 241, 193, 104, 109, 262, 244, 71) AND `ScenesScategory`.`scategory_id` = `Scategory`.`id`) | 255 | 255 | 2 | |
| SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `krakenco_masterchef`.`tags` AS `Tag` JOIN `krakenco_masterchef`.`tagged` AS `Tagged` ON (`Tagged`.`foreign_key` IN (164, 225, 223, 103, 219, 191, 87, 177, 192, 194, 180, 195, 206, 63, 181, 171, 166, 51, 265, 268, 90, 39, 22, 187, 124, 62, 58, 146, 215, 150, 198, 232, 156, 155, 81, 44, 251, 129, 126, 88, 123, 162, 121, 242, 179, 226, 216, 204, 173, 233, 160, 253, 221, 185, 137, 190, 231, 235, 217, 52, 54, 80, 222, 176, 255, 118, 95, 50, 153, 214, 119, 83, 45, 178, 170, 91, 248, 213, 64, 49, 168, 169, 158, 57, 77, 74, 122, 117, 48, 230, 149, 220, 97, 281, 243, 188, 47, 167, 196, 208, 224, 239, 112, 127, 142, 42, 120, 154, 110, 267, 277, 59, 278, 143, 135, 29, 202, 85, 116, 96, 108, 125, 114, 111, 86, 252, 144, 130, 46, 165, 159, 140, 102, 78, 69, 105, 25, 66, 84, 65, 272, 76, 211, 274, 60, 203, 266, 275, 273, 89, 147, 38, 79, 271, 209, 201, 186, 279, 263, 269, 98, 53, 136, 75, 101, 28, 61, 139, 70, 264, 37, 19, 240, 238, 161, 200, 68, 210, 207, 115, 100, 132, 17, 174, 280, 92, 189, 32, 145, 106, 93, 18, 24, 218, 245, 212, 33, 34, 151, 163, 94, 199, 184, 183, 107, 43, 35, 237, 73, 261, 246, 258, 141, 175, 247, 229, 40, 16, 249, 234, 259, 133, 276, 250, 67, 152, 148, 283, 128, 257, 236, 21, 254, 113, 56, 157, 72, 205, 256, 270, 138, 23, 227, 82, 134, 182, 131, 55, 241, 193, 104, 109, 262, 244, 71) AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Scene' | 2869 | 2869 | 21 |
Peak Memory Use 59.75 MB
| Message | Memory use |
|---|---|
| Component initialization | 4.27 MB |
| Controller action start | 4.70 MB |
| Controller render start | 5.73 MB |
| View render complete | 6.77 MB |
Total Request Time: 1755 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 54.88 | |
| Event: Controller.initialize | 5.22 | |
| Event: Controller.startup | 0.53 | |
| Controller action | 499.74 | |
| Event: Controller.beforeRender | 300.00 | |
| » Processing toolbar data | 299.42 | |
| Rendering View | 580.38 | |
| » Event: View.beforeRender | 0.04 | |
| » Rendering APP/View/Vips/listado.ctp | 82.96 | |
| » » Rendering APP/View/Elements/front/scene_container.ctp | 82.26 | |
| » Event: View.afterRender | 0.03 | |
| » Event: View.beforeLayout | 0.03 | |
| » Rendering APP/View/Layouts/front.ctp | 496.31 | |
| » » Rendering APP/View/Elements/front/meta.ctp | 0.14 | |
| » » Rendering APP/View/Elements/front/css.ctp | 0.31 | |
| » » Rendering APP/View/Elements/front/banners.ctp | 0.07 | |
| » » Rendering APP/View/Elements/front/googleanalytics.ctp | 0.07 | |
| » » Rendering APP/View/Elements/front/cxense.ctp | 0.06 | |
| » » Rendering APP/View/Elements/front/header.ctp | 494.25 | |
| » » Rendering APP/View/Elements/front/footer.ctp | 0.17 | |
| » » Rendering APP/View/Elements/front/js.ctp | 0.22 | |
| Event: View.afterLayout | 0.00 |