Redirect 302 redirect from GET @troubadour_site_teacher_challenges_create (943637)

GET https://troubadour.constellation.cool/catalogue

Commands

97 Queries
85.50 ms Query time
0 Failed Queries
# Time Connection Command
1 21.45 ms default CONNECT tls://constellation-web-develop-cache-3ighqi.serverless.cac1.cache.amazonaws.com 6379 5 <null> 5 5
2 2.06 ms default AUTH constellation-web-develop-user +-bwN-l1Mx1z=s1F:zKv
3 1.41 ms default MGET GAHWHqWN1n:DateTime__CLASSMETADATA__
4 1.07 ms default MGET GAHWHqWN1n:DateTime__CLASSMETADATA__
5 1.19 ms default MGET sWeyX1FGHd:cbaa7a8eed685cd45f9c1cc8b47b8fda
6 0.01 ms default MULTI 2
7 0.01 ms default SETEX sWeyX1FGHd:cbaa7a8eed685cd45f9c1cc8b47b8fda 86400 O:31:"Doctrine\ORM\Query\ParserResult":4:{s:44:"Doctrine\ORM\Query\ParserResultsqlExecutor";N;s:45:"Doctrine\ORM\Query\ParserResultsqlFinalizer";O:48:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer":1:{s:53:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizersql";s:125:"SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.`translations` AS translations_2 FROM `StudiedLanguage` s0_ WHERE s0_.name = ?";}s:49:"Doctrine\ORM\Query\ParserResultresultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":23:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:1:{s:6:"entity";s:34:"App\Entity\Catalog\StudiedLanguage";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:3:{s:4:"id_0";s:2:"id";s:6:"name_1";s:4:"name";s:14:"translations_2";s:12:"translations";}s:19:"columnAliasMappings";a:1:{s:34:"App\Entity\Catalog\StudiedLanguage";a:1:{s:6:"entity";a:3:{s:2:"id";s:4:"id_0";s:4:"name";s:6:"name_1";s:12:"translations";s:14:"translations_2";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:3:{s:4:"id_0";s:6:"entity";s:6:"name_1";s:6:"entity";s:14:"translations_2";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:3:{s:4:"id_0";s:34:"App\Entity\Catalog\StudiedLanguage";s:6:"name_1";s:34:"App\Entity\Catalog\StudiedLanguage";s:14:"translations_2";s:34:"App\Entity\Catalog\StudiedLanguage";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:9:"newObject";a:0:{}s:24:"nestedNewObjectArguments";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}s:14:"nestedEntities";a:0:{}}s:50:"Doctrine\ORM\Query\ParserResultparameterMappings";a:1:{s:4:"name";a:1:{i:0;i:0;}}}
8 1.23 ms default EXEC
9 1.06 ms default MGET sWeyX1FGHd:1d9264d3e711daff7a5246d602543f3f
10 0.01 ms default MULTI 2
11 0.02 ms default SETEX sWeyX1FGHd:1d9264d3e711daff7a5246d602543f3f 86400 O:31:"Doctrine\ORM\Query\ParserResult":4:{s:44:"Doctrine\ORM\Query\ParserResultsqlExecutor";N;s:45:"Doctrine\ORM\Query\ParserResultsqlFinalizer";O:48:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer":1:{s:53:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizersql";s:120:"SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.color AS color_2, c0_.`translations` AS translations_3 FROM `Concept` c0_";}s:49:"Doctrine\ORM\Query\ParserResultresultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":23:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:1:{s:6:"entity";s:26:"App\Entity\Catalog\Concept";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:4:{s:4:"id_0";s:2:"id";s:6:"name_1";s:4:"name";s:7:"color_2";s:5:"color";s:14:"translations_3";s:12:"translations";}s:19:"columnAliasMappings";a:1:{s:26:"App\Entity\Catalog\Concept";a:1:{s:6:"entity";a:4:{s:2:"id";s:4:"id_0";s:4:"name";s:6:"name_1";s:5:"color";s:7:"color_2";s:12:"translations";s:14:"translations_3";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:4:{s:4:"id_0";s:6:"entity";s:6:"name_1";s:6:"entity";s:7:"color_2";s:6:"entity";s:14:"translations_3";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:4:{s:4:"id_0";s:26:"App\Entity\Catalog\Concept";s:6:"name_1";s:26:"App\Entity\Catalog\Concept";s:7:"color_2";s:26:"App\Entity\Catalog\Concept";s:14:"translations_3";s:26:"App\Entity\Catalog\Concept";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:9:"newObject";a:0:{}s:24:"nestedNewObjectArguments";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}s:14:"nestedEntities";a:0:{}}s:50:"Doctrine\ORM\Query\ParserResultparameterMappings";a:0:{}}
12 1.09 ms default EXEC
13 1.02 ms default MGET sWeyX1FGHd:4ba4421c4e8205b51948aebfedd4b31c
14 0.01 ms default MULTI 2
15 0.01 ms default SETEX sWeyX1FGHd:4ba4421c4e8205b51948aebfedd4b31c 86400 O:31:"Doctrine\ORM\Query\ParserResult":4:{s:44:"Doctrine\ORM\Query\ParserResultsqlExecutor";N;s:45:"Doctrine\ORM\Query\ParserResultsqlFinalizer";O:48:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer":1:{s:53:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizersql";s:106:"SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.`translations` AS translations_2 FROM `StudiedLanguage` s0_";}s:49:"Doctrine\ORM\Query\ParserResultresultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":23:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:1:{s:6:"entity";s:34:"App\Entity\Catalog\StudiedLanguage";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:3:{s:4:"id_0";s:2:"id";s:6:"name_1";s:4:"name";s:14:"translations_2";s:12:"translations";}s:19:"columnAliasMappings";a:1:{s:34:"App\Entity\Catalog\StudiedLanguage";a:1:{s:6:"entity";a:3:{s:2:"id";s:4:"id_0";s:4:"name";s:6:"name_1";s:12:"translations";s:14:"translations_2";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:3:{s:4:"id_0";s:6:"entity";s:6:"name_1";s:6:"entity";s:14:"translations_2";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:3:{s:4:"id_0";s:34:"App\Entity\Catalog\StudiedLanguage";s:6:"name_1";s:34:"App\Entity\Catalog\StudiedLanguage";s:14:"translations_2";s:34:"App\Entity\Catalog\StudiedLanguage";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:9:"newObject";a:0:{}s:24:"nestedNewObjectArguments";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}s:14:"nestedEntities";a:0:{}}s:50:"Doctrine\ORM\Query\ParserResultparameterMappings";a:0:{}}
16 1.11 ms default EXEC
17 1.07 ms default MGET sWeyX1FGHd:b87f0150d6a5c041ec88294b9d1e3573
18 0.01 ms default MULTI 2
19 0.03 ms default SETEX sWeyX1FGHd:b87f0150d6a5c041ec88294b9d1e3573 86400 O:31:"Doctrine\ORM\Query\ParserResult":4:{s:44:"Doctrine\ORM\Query\ParserResultsqlExecutor";N;s:45:"Doctrine\ORM\Query\ParserResultsqlFinalizer";O:48:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer":1:{s:53:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizersql";s:1915:"SELECT t0_.id AS id_0, t1_.id AS id_1, t1_.name AS name_2, t1_.description AS description_3, t1_.is_reading_challenge AS is_reading_challenge_4, t1_.educational_intent AS educational_intent_5, t1_.student_instructions AS student_instructions_6, t1_.expected_duration AS expected_duration_7, t1_.note_for_teacher AS note_for_teacher_8, t1_.images AS images_9, t1_.disabled AS disabled_10, t1_.is_highlighted AS is_highlighted_11, t1_.historical AS historical_12, t1_.starting_blocks AS starting_blocks_13, t1_.conclusion AS conclusion_14, t1_.is_marked_as_deleted AS is_marked_as_deleted_15, t1_.deleted_at AS deleted_at_16, d2_.id AS id_17, d2_.display_name AS display_name_18, d2_.zoho_name AS zoho_name_19, e3_.id AS id_20, e3_.display_name AS display_name_21, e3_.`translations` AS translations_22, g4_.id AS id_23, g4_.name AS name_24, g4_.display_order AS display_order_25, g4_.translations AS translations_26, g4_.description AS description_27, t0_.challenge_template_id AS challenge_template_id_28, t0_.educational_pathway_id AS educational_pathway_id_29, t1_.language_id AS language_id_30, t1_.studied_language_id AS studied_language_id_31, t1_.story_template_id AS story_template_id_32, g4_.educational_pathway_id AS educational_pathway_id_33 FROM `troub_ChallengeTemplateAssociation` t0_ INNER JOIN `troub_ChallengeTemplate` t1_ ON t0_.challenge_template_id = t1_.id INNER JOIN troub_challengeTemplateAssociation_difficultyLevel t5_ ON t0_.id = t5_.difficulty_level_id INNER JOIN `DifficultyLevel` d2_ ON d2_.id = t5_.troubadour_association_id INNER JOIN `EducationalPathway` e3_ ON t0_.educational_pathway_id = e3_.id INNER JOIN `GradeLevel` g4_ ON e3_.id = g4_.educational_pathway_id INNER JOIN gradeLevel_difficultyLevel g7_ ON g4_.id = g7_.grade_level_id INNER JOIN `DifficultyLevel` d6_ ON d6_.id = g7_.difficulty_level_id WHERE t0_.educational_pathway_id = ? AND t1_.disabled = 0 AND d6_.id = d2_.id";}s:49:"Doctrine\ORM\Query\ParserResultresultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":23:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:5:{s:3:"cta";s:50:"App\Entity\Troubadour\ChallengeTemplateAssociation";s:2:"ct";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:2:"dl";s:34:"App\Entity\Catalog\DifficultyLevel";s:2:"sl";s:31:"App\Entity\Catalog\ScholarLevel";s:2:"gl";s:29:"App\Entity\Catalog\GradeLevel";}s:11:"relationMap";a:4:{s:2:"ct";s:18:"challenge_template";s:2:"dl";s:17:"difficulty_levels";s:2:"sl";s:19:"educational_pathway";s:2:"gl";s:12:"grade_levels";}s:14:"parentAliasMap";a:4:{s:2:"ct";s:3:"cta";s:2:"dl";s:3:"cta";s:2:"sl";s:3:"cta";s:2:"gl";s:2:"sl";}s:13:"fieldMappings";a:28:{s:4:"id_0";s:2:"id";s:4:"id_1";s:2:"id";s:6:"name_2";s:4:"name";s:13:"description_3";s:11:"description";s:22:"is_reading_challenge_4";s:20:"is_reading_challenge";s:20:"educational_intent_5";s:18:"educational_intent";s:22:"student_instructions_6";s:20:"student_instructions";s:19:"expected_duration_7";s:17:"expected_duration";s:18:"note_for_teacher_8";s:16:"note_for_teacher";s:8:"images_9";s:6:"images";s:11:"disabled_10";s:8:"disabled";s:17:"is_highlighted_11";s:14:"is_highlighted";s:13:"historical_12";s:10:"historical";s:18:"starting_blocks_13";s:14:"startingBlocks";s:13:"conclusion_14";s:10:"conclusion";s:23:"is_marked_as_deleted_15";s:20:"is_marked_as_deleted";s:13:"deleted_at_16";s:10:"deleted_at";s:5:"id_17";s:2:"id";s:15:"display_name_18";s:12:"display_name";s:12:"zoho_name_19";s:9:"zoho_name";s:5:"id_20";s:2:"id";s:15:"display_name_21";s:12:"display_name";s:15:"translations_22";s:12:"translations";s:5:"id_23";s:2:"id";s:7:"name_24";s:4:"name";s:16:"display_order_25";s:13:"display_order";s:15:"translations_26";s:12:"translations";s:14:"description_27";s:11:"description";}s:19:"columnAliasMappings";a:5:{s:50:"App\Entity\Troubadour\ChallengeTemplateAssociation";a:1:{s:3:"cta";a:1:{s:2:"id";s:4:"id_0";}}s:39:"App\Entity\Troubadour\ChallengeTemplate";a:1:{s:2:"ct";a:16:{s:2:"id";s:4:"id_1";s:4:"name";s:6:"name_2";s:11:"description";s:13:"description_3";s:20:"is_reading_challenge";s:22:"is_reading_challenge_4";s:18:"educational_intent";s:20:"educational_intent_5";s:20:"student_instructions";s:22:"student_instructions_6";s:17:"expected_duration";s:19:"expected_duration_7";s:16:"note_for_teacher";s:18:"note_for_teacher_8";s:6:"images";s:8:"images_9";s:8:"disabled";s:11:"disabled_10";s:14:"is_highlighted";s:17:"is_highlighted_11";s:10:"historical";s:13:"historical_12";s:14:"startingBlocks";s:18:"starting_blocks_13";s:10:"conclusion";s:13:"conclusion_14";s:20:"is_marked_as_deleted";s:23:"is_marked_as_deleted_15";s:10:"deleted_at";s:13:"deleted_at_16";}}s:34:"App\Entity\Catalog\DifficultyLevel";a:1:{s:2:"dl";a:3:{s:2:"id";s:5:"id_17";s:12:"display_name";s:15:"display_name_18";s:9:"zoho_name";s:12:"zoho_name_19";}}s:31:"App\Entity\Catalog\ScholarLevel";a:1:{s:2:"sl";a:3:{s:2:"id";s:5:"id_20";s:12:"display_name";s:15:"display_name_21";s:12:"translations";s:15:"translations_22";}}s:29:"App\Entity\Catalog\GradeLevel";a:1:{s:2:"gl";a:5:{s:2:"id";s:5:"id_23";s:4:"name";s:7:"name_24";s:13:"display_order";s:16:"display_order_25";s:12:"translations";s:15:"translations_26";s:11:"description";s:14:"description_27";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:6:{s:24:"challenge_template_id_28";s:7:"integer";s:25:"educational_pathway_id_29";s:7:"integer";s:14:"language_id_30";s:7:"integer";s:22:"studied_language_id_31";s:7:"integer";s:20:"story_template_id_32";s:7:"integer";s:25:"educational_pathway_id_33";s:7:"integer";}s:14:"entityMappings";a:1:{s:3:"cta";N;}s:12:"metaMappings";a:6:{s:24:"challenge_template_id_28";s:21:"challenge_template_id";s:25:"educational_pathway_id_29";s:22:"educational_pathway_id";s:14:"language_id_30";s:11:"language_id";s:22:"studied_language_id_31";s:19:"studied_language_id";s:20:"story_template_id_32";s:17:"story_template_id";s:25:"educational_pathway_id_33";s:22:"educational_pathway_id";}s:14:"columnOwnerMap";a:34:{s:4:"id_0";s:3:"cta";s:4:"id_1";s:2:"ct";s:6:"name_2";s:2:"ct";s:13:"description_3";s:2:"ct";s:22:"is_reading_challenge_4";s:2:"ct";s:20:"educational_intent_5";s:2:"ct";s:22:"student_instructions_6";s:2:"ct";s:19:"expected_duration_7";s:2:"ct";s:18:"note_for_teacher_8";s:2:"ct";s:8:"images_9";s:2:"ct";s:11:"disabled_10";s:2:"ct";s:17:"is_highlighted_11";s:2:"ct";s:13:"historical_12";s:2:"ct";s:18:"starting_blocks_13";s:2:"ct";s:13:"conclusion_14";s:2:"ct";s:23:"is_marked_as_deleted_15";s:2:"ct";s:13:"deleted_at_16";s:2:"ct";s:5:"id_17";s:2:"dl";s:15:"display_name_18";s:2:"dl";s:12:"zoho_name_19";s:2:"dl";s:5:"id_20";s:2:"sl";s:15:"display_name_21";s:2:"sl";s:15:"translations_22";s:2:"sl";s:5:"id_23";s:2:"gl";s:7:"name_24";s:2:"gl";s:16:"display_order_25";s:2:"gl";s:15:"translations_26";s:2:"gl";s:14:"description_27";s:2:"gl";s:24:"challenge_template_id_28";s:3:"cta";s:25:"educational_pathway_id_29";s:3:"cta";s:14:"language_id_30";s:2:"ct";s:22:"studied_language_id_31";s:2:"ct";s:20:"story_template_id_32";s:2:"ct";s:25:"educational_pathway_id_33";s:2:"gl";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:28:{s:4:"id_0";s:50:"App\Entity\Troubadour\ChallengeTemplateAssociation";s:4:"id_1";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:6:"name_2";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:13:"description_3";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:22:"is_reading_challenge_4";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:20:"educational_intent_5";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:22:"student_instructions_6";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:19:"expected_duration_7";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:18:"note_for_teacher_8";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:8:"images_9";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:11:"disabled_10";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:17:"is_highlighted_11";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:13:"historical_12";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:18:"starting_blocks_13";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:13:"conclusion_14";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:23:"is_marked_as_deleted_15";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:13:"deleted_at_16";s:39:"App\Entity\Troubadour\ChallengeTemplate";s:5:"id_17";s:34:"App\Entity\Catalog\DifficultyLevel";s:15:"display_name_18";s:34:"App\Entity\Catalog\DifficultyLevel";s:12:"zoho_name_19";s:34:"App\Entity\Catalog\DifficultyLevel";s:5:"id_20";s:31:"App\Entity\Catalog\ScholarLevel";s:15:"display_name_21";s:31:"App\Entity\Catalog\ScholarLevel";s:15:"translations_22";s:31:"App\Entity\Catalog\ScholarLevel";s:5:"id_23";s:29:"App\Entity\Catalog\GradeLevel";s:7:"name_24";s:29:"App\Entity\Catalog\GradeLevel";s:16:"display_order_25";s:29:"App\Entity\Catalog\GradeLevel";s:15:"translations_26";s:29:"App\Entity\Catalog\GradeLevel";s:14:"description_27";s:29:"App\Entity\Catalog\GradeLevel";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:9:"newObject";a:0:{}s:24:"nestedNewObjectArguments";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}s:14:"nestedEntities";a:0:{}}s:50:"Doctrine\ORM\Query\ParserResultparameterMappings";a:1:{s:12:"scholarLevel";a:1:{i:0;i:0;}}}
20 1.39 ms default EXEC
21 1.07 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_1__concepts
22 1.00 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_1
23 1.02 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_1
24 0.01 ms default MULTI 2
25 0.01 ms default SETEX bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_1 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Catalog\Concept";s:4:"data";a:4:{s:2:"id";i:1;s:4:"name";s:11:"Orthographe";s:5:"color";s:7:"#FFAC48";s:12:"translations";a:2:{s:5:"en-CA";s:9:"Spelling ";s:5:"fr-CA";s:11:"Orthographe";}}}
26 0.99 ms default EXEC
27 0.97 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_8
28 0.99 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_8
29 0.01 ms default MULTI 2
30 0.01 ms default SETEX bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_8 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Catalog\Concept";s:4:"data";a:4:{s:2:"id";i:8;s:4:"name";s:10:"Incitatif ";s:5:"color";s:7:"#E0648C";s:12:"translations";a:2:{s:5:"en-CA";s:9:"Incentive";s:5:"fr-CA";s:9:"Incitatif";}}}
31 1.07 ms default EXEC
32 0.98 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_15
33 0.94 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_15
34 0.01 ms default MULTI 2
35 0.01 ms default SETEX bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_15 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Catalog\Concept";s:4:"data";a:4:{s:2:"id";i:15;s:4:"name";s:24:"Fait vécu / expérience";s:5:"color";s:7:"#8654D2";s:12:"translations";a:2:{s:5:"en-CA";s:27:"Real-life fact / experience";s:5:"fr-CA";s:24:"Fait vécu / expérience";}}}
36 0.97 ms default EXEC
37 1.01 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_1__concepts
38 0.01 ms default MULTI 2
39 0.01 ms default SETEX bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_1__concepts 7200 O:39:"Doctrine\ORM\Cache\CollectionCacheEntry":1:{s:11:"identifiers";a:3:{i:0;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:28:"app.entity.catalog.concept_1";s:10:"identifier";a:1:{s:2:"id";i:1;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}i:1;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:28:"app.entity.catalog.concept_8";s:10:"identifier";a:1:{s:2:"id";i:8;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}i:2;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:29:"app.entity.catalog.concept_15";s:10:"identifier";a:1:{s:2:"id";i:15;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}}}
40 1.05 ms default EXEC
41 0.98 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_2__concepts
42 1.01 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_1
43 1.01 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_5
44 0.98 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_5
45 0.01 ms default MULTI 2
46 0.01 ms default SETEX bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_5 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Catalog\Concept";s:4:"data";a:4:{s:2:"id";i:5;s:4:"name";s:11:"Conjugaison";s:5:"color";s:7:"#E08C27";s:12:"translations";a:2:{s:5:"en-CA";s:11:"Conjugation";s:5:"fr-CA";s:11:"Conjugaison";}}}
47 0.96 ms default EXEC
48 0.94 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_13
49 1.04 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_13
50 0.01 ms default MULTI 2
51 0.01 ms default SETEX bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_13 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Catalog\Concept";s:4:"data";a:4:{s:2:"id";i:13;s:4:"name";s:27:"Fantaisie / Science-fiction";s:5:"color";s:7:"#A884DE";s:12:"translations";a:2:{s:5:"en-CA";s:25:"Fantasy / Science fiction";s:5:"fr-CA";s:27:"Fantaisie / Science-fiction";}}}
52 0.96 ms default EXEC
53 0.93 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_2__concepts
54 0.01 ms default MULTI 2
55 0.01 ms default SETEX bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_2__concepts 7200 O:39:"Doctrine\ORM\Cache\CollectionCacheEntry":1:{s:11:"identifiers";a:3:{i:0;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:28:"app.entity.catalog.concept_1";s:10:"identifier";a:1:{s:2:"id";i:1;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}i:1;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:28:"app.entity.catalog.concept_5";s:10:"identifier";a:1:{s:2:"id";i:5;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}i:2;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:29:"app.entity.catalog.concept_13";s:10:"identifier";a:1:{s:2:"id";i:13;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}}}
56 1.66 ms default EXEC
57 0.96 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_3__concepts
58 1.02 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_1
59 0.99 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_2
60 1.09 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_2
61 0.01 ms default MULTI 2
62 0.01 ms default SETEX bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_2 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Catalog\Concept";s:4:"data";a:4:{s:2:"id";i:2;s:4:"name";s:20:"Grammaire & accords ";s:5:"color";s:7:"#FF9F2C";s:12:"translations";a:2:{s:5:"en-CA";s:20:"Grammar & agreements";s:5:"fr-CA";s:20:"Grammaire & accords ";}}}
63 1.06 ms default EXEC
64 1.05 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_3
65 1.08 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_3
66 0.01 ms default MULTI 2
67 0.01 ms default SETEX bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_3 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Catalog\Concept";s:4:"data";a:4:{s:2:"id";i:3;s:4:"name";s:11:"Vocabulaire";s:5:"color";s:7:"#FF9719";s:12:"translations";a:2:{s:5:"en-CA";s:10:"Vocabulary";s:5:"fr-CA";s:11:"Vocabulaire";}}}
68 1.01 ms default EXEC
69 0.99 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_3__concepts
70 0.01 ms default MULTI 2
71 0.01 ms default SETEX bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_3__concepts 7200 O:39:"Doctrine\ORM\Cache\CollectionCacheEntry":1:{s:11:"identifiers";a:3:{i:0;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:28:"app.entity.catalog.concept_1";s:10:"identifier";a:1:{s:2:"id";i:1;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}i:1;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:28:"app.entity.catalog.concept_2";s:10:"identifier";a:1:{s:2:"id";i:2;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}i:2;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:28:"app.entity.catalog.concept_3";s:10:"identifier";a:1:{s:2:"id";i:3;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}}}
72 1.01 ms default EXEC
73 0.98 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_5__concepts
74 1.00 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_5
75 1.02 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_6
76 0.98 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_6
77 0.01 ms default MULTI 2
78 0.01 ms default SETEX bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_6 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Catalog\Concept";s:4:"data";a:4:{s:2:"id";i:6;s:4:"name";s:9:"Narratif ";s:5:"color";s:7:"#EE85A7";s:12:"translations";a:2:{s:5:"en-CA";s:9:"Narrative";s:5:"fr-CA";s:9:"Narratif ";}}}
79 1.02 ms default EXEC
80 0.97 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_13
81 0.92 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_5__concepts
82 0.01 ms default MULTI 2
83 0.01 ms default SETEX bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_5__concepts 7200 O:39:"Doctrine\ORM\Cache\CollectionCacheEntry":1:{s:11:"identifiers";a:3:{i:0;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:28:"app.entity.catalog.concept_5";s:10:"identifier";a:1:{s:2:"id";i:5;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}i:1;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:28:"app.entity.catalog.concept_6";s:10:"identifier";a:1:{s:2:"id";i:6;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}i:2;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:29:"app.entity.catalog.concept_13";s:10:"identifier";a:1:{s:2:"id";i:13;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}}}
84 0.98 ms default EXEC
85 0.99 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_6__concepts
86 1.02 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_2
87 0.97 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_13
88 1.06 ms default EXISTS bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.catalog.concept_15
89 1.02 ms default MGET bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_6__concepts
90 0.01 ms default MULTI 2
91 0.01 ms default SETEX bPZ5Mtl-ax:DC2_REGION_nanomonx_app.entity.troubadour.challengetemplate_6__concepts 7200 O:39:"Doctrine\ORM\Cache\CollectionCacheEntry":1:{s:11:"identifiers";a:3:{i:0;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:28:"app.entity.catalog.concept_2";s:10:"identifier";a:1:{s:2:"id";i:2;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}i:1;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:29:"app.entity.catalog.concept_13";s:10:"identifier";a:1:{s:2:"id";i:13;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}i:2;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:29:"app.entity.catalog.concept_15";s:10:"identifier";a:1:{s:2:"id";i:15;}s:11:"entityClass";s:26:"App\Entity\Catalog\Concept";}}}
92 1.04 ms default EXEC
93 1.02 ms default MGET sWeyX1FGHd:0b620438155f0858724ebc0ffc386074
94 0.01 ms default MULTI 2
95 0.01 ms default SETEX sWeyX1FGHd:0b620438155f0858724ebc0ffc386074 86400 O:31:"Doctrine\ORM\Query\ParserResult":4:{s:44:"Doctrine\ORM\Query\ParserResultsqlExecutor";N;s:45:"Doctrine\ORM\Query\ParserResultsqlFinalizer";O:48:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer":1:{s:53:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizersql";s:190:"SELECT t0_.id AS id_0, t1_.id AS id_1 FROM `troub_Thematique` t0_ INNER JOIN thematique_category t2_ ON t0_.id = t2_.thematique_id INNER JOIN `troub_Category` t1_ ON t1_.id = t2_.category_id";}s:49:"Doctrine\ORM\Query\ParserResultresultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":23:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:0:{}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:0:{}s:19:"columnAliasMappings";a:0:{}s:14:"scalarMappings";a:2:{s:4:"id_0";s:12:"thematiqueId";s:4:"id_1";s:10:"categoryId";}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:2:{s:4:"id_0";s:7:"integer";s:4:"id_1";s:7:"integer";}s:14:"entityMappings";a:0:{}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:0:{}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:0:{}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:9:"newObject";a:0:{}s:24:"nestedNewObjectArguments";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}s:14:"nestedEntities";a:0:{}}s:50:"Doctrine\ORM\Query\ParserResultparameterMappings";a:0:{}}
96 1.09 ms default EXEC
97 1.12 ms default SETEX nanomonx_dev_4ce7cbb8cf7a1806f4d0f3f7b0b3017b 86400 _sf2_attributes|a:13:{s:20:"DeviceDetector_setup";b:1;s:20:"DeviceDetector_isBot";b:1;s:24:"DeviceDetector_hasClient";b:0;s:24:"DeviceDetector_isDesktop";b:0;s:23:"DeviceDetector_isTablet";b:0;s:23:"DeviceDetector_isMobile";b:0;s:17:"DeviceDetector_os";N;s:26:"DeviceDetector_client_name";N;s:29:"DeviceDetector_client_version";N;s:4:"lang";s:5:"fr-CA";s:7:"country";s:2:"US";s:18:"is_default_country";b:0;s:24:"_csrf/https-authenticate";s:43:"WWXAgwHTn-LhJBy4JQMyyDUQ76vzopljfwrzVOphO2I";}_sf2_meta|a:3:{s:1:"u";i:1757960847;s:1:"c";i:1757960847;s:1:"l";i:604800;}