GET https://constellation.constellation.cool/catalog

Commands

155 Queries
202.80 ms Query time
0 Failed Queries
# Time Connection Command
1 39.87 ms default CONNECT tls://constellation-web-develop-cache-3ighqi.serverless.cac1.cache.amazonaws.com 6379 5 <null> 5 5
2 1.52 ms default AUTH constellation-web-develop-user tN0%^CW%EsOLb106I13^
3 1.69 ms default MGET jjfFtuUw8i:DateTime__CLASSMETADATA__
4 1.50 ms default MGET jjfFtuUw8i:DateTime__CLASSMETADATA__
5 1.55 ms default MGET p0r1f7a4dN:6d73efb0ad7da86b9b40aaa710a9e05d
6 0.01 ms default MULTI 2
7 0.02 ms default SETEX p0r1f7a4dN:6d73efb0ad7da86b9b40aaa710a9e05d 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:227:"SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.displayName AS displayName_2, l0_.tag AS tag_3, l0_.isActive AS isActive_4, l0_.noun_sample AS noun_sample_5, l0_.adjective_sample AS adjective_sample_6 FROM `Language` l0_";}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:19:"App\Entity\Language";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:7:{s:4:"id_0";s:2:"id";s:10:"language_1";s:8:"language";s:13:"displayName_2";s:11:"displayName";s:5:"tag_3";s:3:"tag";s:10:"isActive_4";s:8:"isActive";s:13:"noun_sample_5";s:11:"noun_sample";s:18:"adjective_sample_6";s:16:"adjective_sample";}s:19:"columnAliasMappings";a:1:{s:19:"App\Entity\Language";a:1:{s:6:"entity";a:7:{s:2:"id";s:4:"id_0";s:8:"language";s:10:"language_1";s:11:"displayName";s:13:"displayName_2";s:3:"tag";s:5:"tag_3";s:8:"isActive";s:10:"isActive_4";s:11:"noun_sample";s:13:"noun_sample_5";s:16:"adjective_sample";s:18:"adjective_sample_6";}}}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:7:{s:4:"id_0";s:6:"entity";s:10:"language_1";s:6:"entity";s:13:"displayName_2";s:6:"entity";s:5:"tag_3";s:6:"entity";s:10:"isActive_4";s:6:"entity";s:13:"noun_sample_5";s:6:"entity";s:18:"adjective_sample_6";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:7:{s:4:"id_0";s:19:"App\Entity\Language";s:10:"language_1";s:19:"App\Entity\Language";s:13:"displayName_2";s:19:"App\Entity\Language";s:5:"tag_3";s:19:"App\Entity\Language";s:10:"isActive_4";s:19:"App\Entity\Language";s:13:"noun_sample_5";s:19:"App\Entity\Language";s:18:"adjective_sample_6";s:19:"App\Entity\Language";}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:{}}
8 1.50 ms default EXEC
9 1.49 ms default MGET p0r1f7a4dN:e0b2bec98b3a80cc99397fc4e333a559
10 0.01 ms default MULTI 2
11 0.01 ms default SETEX p0r1f7a4dN:e0b2bec98b3a80cc99397fc4e333a559 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:245:"SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.displayName AS displayName_2, l0_.tag AS tag_3, l0_.isActive AS isActive_4, l0_.noun_sample AS noun_sample_5, l0_.adjective_sample AS adjective_sample_6 FROM `Language` l0_ WHERE l0_.tag = ?";}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:19:"App\Entity\Language";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:7:{s:4:"id_0";s:2:"id";s:10:"language_1";s:8:"language";s:13:"displayName_2";s:11:"displayName";s:5:"tag_3";s:3:"tag";s:10:"isActive_4";s:8:"isActive";s:13:"noun_sample_5";s:11:"noun_sample";s:18:"adjective_sample_6";s:16:"adjective_sample";}s:19:"columnAliasMappings";a:1:{s:19:"App\Entity\Language";a:1:{s:6:"entity";a:7:{s:2:"id";s:4:"id_0";s:8:"language";s:10:"language_1";s:11:"displayName";s:13:"displayName_2";s:3:"tag";s:5:"tag_3";s:8:"isActive";s:10:"isActive_4";s:11:"noun_sample";s:13:"noun_sample_5";s:16:"adjective_sample";s:18:"adjective_sample_6";}}}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:7:{s:4:"id_0";s:6:"entity";s:10:"language_1";s:6:"entity";s:13:"displayName_2";s:6:"entity";s:5:"tag_3";s:6:"entity";s:10:"isActive_4";s:6:"entity";s:13:"noun_sample_5";s:6:"entity";s:18:"adjective_sample_6";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:7:{s:4:"id_0";s:19:"App\Entity\Language";s:10:"language_1";s:19:"App\Entity\Language";s:13:"displayName_2";s:19:"App\Entity\Language";s:5:"tag_3";s:19:"App\Entity\Language";s:10:"isActive_4";s:19:"App\Entity\Language";s:13:"noun_sample_5";s:19:"App\Entity\Language";s:18:"adjective_sample_6";s:19:"App\Entity\Language";}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:3:"tag";a:1:{i:0;i:0;}}}
12 1.49 ms default EXEC
13 1.56 ms default MGET p0r1f7a4dN:1dcb288a51f02eee7c717ad329c71b6d
14 0.01 ms default MULTI 2
15 0.01 ms default SETEX p0r1f7a4dN:1dcb288a51f02eee7c717ad329c71b6d 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:98:"SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.`translations` AS translations_2 FROM `Subject` 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:26:"App\Entity\Catalog\Subject";}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:26:"App\Entity\Catalog\Subject";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:26:"App\Entity\Catalog\Subject";s:6:"name_1";s:26:"App\Entity\Catalog\Subject";s:14:"translations_2";s:26:"App\Entity\Catalog\Subject";}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.48 ms default EXEC
17 1.55 ms default MGET p0r1f7a4dN:3b0dd4cd6c043b8375b9a45d1e75b086
18 0.01 ms default MULTI 2
19 0.01 ms default SETEX p0r1f7a4dN:3b0dd4cd6c043b8375b9a45d1e75b086 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:278:"SELECT e0_.id AS id_0, e0_.display_name AS display_name_1, e0_.`translations` AS translations_2 FROM `EducationalPathway` e0_ INNER JOIN countries_educationalPathways c2_ ON e0_.id = c2_.educational_pathway_id INNER JOIN `Country` c1_ ON c1_.id = c2_.country_id WHERE c1_.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:1:{s:2:"SL";s:31:"App\Entity\Catalog\ScholarLevel";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:3:{s:4:"id_0";s:2:"id";s:14:"display_name_1";s:12:"display_name";s:14:"translations_2";s:12:"translations";}s:19:"columnAliasMappings";a:1:{s:31:"App\Entity\Catalog\ScholarLevel";a:1:{s:2:"SL";a:3:{s:2:"id";s:4:"id_0";s:12:"display_name";s:14:"display_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:2:"SL";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:3:{s:4:"id_0";s:2:"SL";s:14:"display_name_1";s:2:"SL";s:14:"translations_2";s:2:"SL";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:3:{s:4:"id_0";s:31:"App\Entity\Catalog\ScholarLevel";s:14:"display_name_1";s:31:"App\Entity\Catalog\ScholarLevel";s:14:"translations_2";s:31:"App\Entity\Catalog\ScholarLevel";}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:10:"country_id";a:1:{i:0;i:0;}}}
20 1.47 ms default EXEC
21 1.54 ms default MGET p0r1f7a4dN:5a0ba52cde2a50f0e6d9964857ccac30
22 1.44 ms default MGET jjfFtuUw8i:App__Entity__Constellation__ChallengeTemplate__CLASSMETADATA__
23 1.45 ms default MGET jjfFtuUw8i:App_Entity_Constellation_ChallengeTemplate_$GEDMO_TRANSLATABLE_CLASSMETADATA
24 0.01 ms default MULTI 2
25 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Constellation_ChallengeTemplate_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
26 1.43 ms default EXEC
27 1.49 ms default MGET jjfFtuUw8i:App__Entity__Constellation__ChallengeTemplate__CLASSMETADATA__
28 0.01 ms default MULTI 2
29 0.02 ms default SETEX jjfFtuUw8i:App__Entity__Constellation__ChallengeTemplate__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:5:{s:12:"associations";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:12:"associations";s:12:"sourceEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:12:"targetEntity";s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";s:5:"fetch";i:2;s:8:"mappedBy";s:18:"challenge_template";}s:8:"language";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:8:"language";s:12:"sourceEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:12:"targetEntity";s:19:"App\Entity\Language";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:11:"language_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:11:"language_id";s:11:"language_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:11:"language_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:11:"language_id";}}s:8:"subjects";O:48:"Doctrine\ORM\Mapping\ManyToManyOwningSideMapping":8:{s:9:"fieldName";s:8:"subjects";s:12:"sourceEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:12:"targetEntity";s:26:"App\Entity\Catalog\Subject";s:5:"fetch";i:2;s:9:"joinTable";O:37:"Doctrine\ORM\Mapping\JoinTableMapping":4:{s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:11:"template_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:18:"inverseJoinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:10:"subject_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:4:"name";s:27:"challengeTemplates_subjects";s:7:"options";a:0:{}}s:16:"joinTableColumns";a:2:{i:0;s:11:"template_id";i:1;s:10:"subject_id";}s:26:"relationToSourceKeyColumns";a:1:{s:11:"template_id";s:2:"id";}s:26:"relationToTargetKeyColumns";a:1:{s:10:"subject_id";s:2:"id";}}s:13:"content_world";O:46:"Doctrine\ORM\Mapping\OneToOneOwningSideMapping":8:{s:9:"fieldName";s:13:"content_world";s:12:"sourceEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:12:"targetEntity";s:45:"App\Entity\Constellation\ReadingTemplateWorld";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:13:"content_world";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:1;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:13:"content_world";s:13:"content_world";}s:24:"sourceToTargetKeyColumns";a:1:{s:13:"content_world";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:13:"content_world";}}s:14:"original_world";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:14:"original_world";s:12:"sourceEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:12:"targetEntity";s:30:"App\Entity\Constellation\World";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:17:"original_world_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:17:"original_world_id";s:17:"original_world_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:17:"original_world_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:17:"original_world_id";}}}s:11:"columnNames";a:17:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:11:"description";s:11:"description";s:19:"teacher_description";s:19:"teacher_description";s:18:"educational_intent";s:18:"educational_intent";s:21:"additional_activities";s:21:"additional_activities";s:17:"expected_duration";s:17:"expected_duration";s:20:"is_reading_challenge";s:20:"is_reading_challenge";s:23:"printable_questionnaire";s:23:"printable_questionnaire";s:10:"answer_key";s:10:"answer_key";s:6:"images";s:6:"images";s:5:"rules";s:5:"rules";s:8:"disabled";s:8:"disabled";s:11:"island_type";s:11:"island_type";s:14:"is_highlighted";s:14:"is_highlighted";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:13:"fieldMappings";a:17:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:4:"name";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"name";s:10:"columnName";s:4:"name";s:6:"length";i:90;}s:11:"description";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"text";s:9:"fieldName";s:11:"description";s:10:"columnName";s:11:"description";}s:19:"teacher_description";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:19:"teacher_description";s:10:"columnName";s:19:"teacher_description";s:8:"nullable";b:1;}s:18:"educational_intent";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:18:"educational_intent";s:10:"columnName";s:18:"educational_intent";s:8:"nullable";b:1;}s:21:"additional_activities";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:21:"additional_activities";s:10:"columnName";s:21:"additional_activities";s:8:"nullable";b:1;}s:17:"expected_duration";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:17:"expected_duration";s:10:"columnName";s:17:"expected_duration";s:8:"nullable";b:1;}s:20:"is_reading_challenge";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"is_reading_challenge";s:10:"columnName";s:20:"is_reading_challenge";s:7:"options";a:1:{s:7:"default";b:0;}}s:23:"printable_questionnaire";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:23:"printable_questionnaire";s:10:"columnName";s:23:"printable_questionnaire";s:8:"nullable";b:1;}s:10:"answer_key";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:10:"answer_key";s:10:"columnName";s:10:"answer_key";s:8:"nullable";b:1;}s:6:"images";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:12:"simple_array";s:9:"fieldName";s:6:"images";s:10:"columnName";s:6:"images";s:8:"nullable";b:1;}s:5:"rules";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"json";s:9:"fieldName";s:5:"rules";s:10:"columnName";s:5:"rules";}s:8:"disabled";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:8:"disabled";s:10:"columnName";s:8:"disabled";s:7:"options";a:1:{s:7:"default";b:0;}}s:11:"island_type";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:11:"island_type";s:10:"columnName";s:11:"island_type";s:8:"nullable";b:1;}s:14:"is_highlighted";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:14:"is_highlighted";s:10:"columnName";s:14:"is_highlighted";s:7:"options";a:1:{s:7:"default";b:0;}}s:20:"is_marked_as_deleted";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"is_marked_as_deleted";s:10:"columnName";s:20:"is_marked_as_deleted";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"deleted_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"deleted_at";s:10:"columnName";s:10:"deleted_at";s:8:"nullable";b:1;}}s:10:"fieldNames";a:17:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:11:"description";s:11:"description";s:19:"teacher_description";s:19:"teacher_description";s:18:"educational_intent";s:18:"educational_intent";s:21:"additional_activities";s:21:"additional_activities";s:17:"expected_duration";s:17:"expected_duration";s:20:"is_reading_challenge";s:20:"is_reading_challenge";s:23:"printable_questionnaire";s:23:"printable_questionnaire";s:10:"answer_key";s:10:"answer_key";s:6:"images";s:6:"images";s:5:"rules";s:5:"rules";s:8:"disabled";s:8:"disabled";s:11:"island_type";s:11:"island_type";s:14:"is_highlighted";s:14:"is_highlighted";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:42:"App\Entity\Constellation\ChallengeTemplate";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:2:{s:4:"name";s:17:"ChallengeTemplate";s:6:"quoted";b:1;}s:14:"rootEntityName";s:42:"App\Entity\Constellation\ChallengeTemplate";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;}
30 1.68 ms default EXEC
31 0.01 ms default MULTI 2
32 0.01 ms default SETEX p0r1f7a4dN:5a0ba52cde2a50f0e6d9964857ccac30 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:208:"SELECT c0_.id AS id_0, c0_.challenge_template_id AS challenge_template_id_1, c0_.educational_pathway_id AS educational_pathway_id_2 FROM `ChallengeTemplateAssociation` c0_ WHERE c0_.educational_pathway_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:1:{s:6:"entity";s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:1:{s:4:"id_0";s:2:"id";}s:19:"columnAliasMappings";a:1:{s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";a:1:{s:6:"entity";a:1:{s:2:"id";s:4:"id_0";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:2:{s:23:"challenge_template_id_1";s:7:"integer";s:24:"educational_pathway_id_2";s:7:"integer";}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:2:{s:23:"challenge_template_id_1";s:21:"challenge_template_id";s:24:"educational_pathway_id_2";s:22:"educational_pathway_id";}s:14:"columnOwnerMap";a:3:{s:4:"id_0";s:6:"entity";s:23:"challenge_template_id_1";s:6:"entity";s:24:"educational_pathway_id_2";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:1:{s:4:"id_0";s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";}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:19:"educational_pathway";a:1:{i:0;i:0;}}}
33 1.48 ms default EXEC
34 1.50 ms default MGET jjfFtuUw8i:App__Entity__Catalog__DifficultyLevel__CLASSMETADATA__
35 1.44 ms default MGET jjfFtuUw8i:App_Entity_Catalog_DifficultyLevel_$GEDMO_TRANSLATABLE_CLASSMETADATA
36 0.01 ms default MULTI 2
37 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Catalog_DifficultyLevel_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
38 1.53 ms default EXEC
39 1.42 ms default MGET jjfFtuUw8i:App__Entity__Catalog__DifficultyLevel__CLASSMETADATA__
40 0.01 ms default MULTI 2
41 0.01 ms default SETEX jjfFtuUw8i:App__Entity__Catalog__DifficultyLevel__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:3:{s:12:"grade_levels";O:48:"Doctrine\ORM\Mapping\ManyToManyOwningSideMapping":9:{s:9:"fieldName";s:12:"grade_levels";s:12:"sourceEntity";s:34:"App\Entity\Catalog\DifficultyLevel";s:12:"targetEntity";s:29:"App\Entity\Catalog\GradeLevel";s:5:"fetch";i:2;s:10:"inversedBy";s:17:"difficulty_levels";s:9:"joinTable";O:37:"Doctrine\ORM\Mapping\JoinTableMapping":4:{s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:19:"difficulty_level_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:18:"inverseJoinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:14:"grade_level_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:4:"name";s:26:"gradeLevel_difficultyLevel";s:7:"options";a:0:{}}s:16:"joinTableColumns";a:2:{i:0;s:19:"difficulty_level_id";i:1;s:14:"grade_level_id";}s:26:"relationToSourceKeyColumns";a:1:{s:19:"difficulty_level_id";s:2:"id";}s:26:"relationToTargetKeyColumns";a:1:{s:14:"grade_level_id";s:2:"id";}}s:26:"constellation_associations";O:49:"Doctrine\ORM\Mapping\ManyToManyInverseSideMapping":5:{s:9:"fieldName";s:26:"constellation_associations";s:12:"sourceEntity";s:34:"App\Entity\Catalog\DifficultyLevel";s:12:"targetEntity";s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";s:5:"fetch";i:2;s:8:"mappedBy";s:17:"difficulty_levels";}s:23:"troubadour_associations";O:49:"Doctrine\ORM\Mapping\ManyToManyInverseSideMapping":5:{s:9:"fieldName";s:23:"troubadour_associations";s:12:"sourceEntity";s:34:"App\Entity\Catalog\DifficultyLevel";s:12:"targetEntity";s:50:"App\Entity\Troubadour\ChallengeTemplateAssociation";s:5:"fetch";i:2;s:8:"mappedBy";s:17:"difficulty_levels";}}s:11:"columnNames";a:3:{s:2:"id";s:2:"id";s:12:"display_name";s:12:"display_name";s:9:"zoho_name";s:9:"zoho_name";}s:13:"fieldMappings";a:3:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:12:"display_name";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:12:"display_name";s:10:"columnName";s:12:"display_name";}s:9:"zoho_name";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:9:"zoho_name";s:10:"columnName";s:9:"zoho_name";}}s:10:"fieldNames";a:3:{s:2:"id";s:2:"id";s:12:"display_name";s:12:"display_name";s:9:"zoho_name";s:9:"zoho_name";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:34:"App\Entity\Catalog\DifficultyLevel";s:9:"namespace";s:18:"App\Entity\Catalog";s:5:"table";a:2:{s:4:"name";s:15:"DifficultyLevel";s:6:"quoted";b:1;}s:14:"rootEntityName";s:34:"App\Entity\Catalog\DifficultyLevel";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;s:5:"cache";a:2:{s:6:"region";s:8:"nanomonx";s:5:"usage";i:2;}}
42 1.48 ms default EXEC
43 1.85 ms default MGET jjfFtuUw8i:App__Entity__Constellation__ReadingTemplateWorld__CLASSMETADATA__
44 2.33 ms default MGET jjfFtuUw8i:App_Entity_Constellation_World_$GEDMO_TRANSLATABLE_CLASSMETADATA
45 0.01 ms default MULTI 2
46 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Constellation_World_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
47 1.41 ms default EXEC
48 1.51 ms default MGET jjfFtuUw8i:App_Entity_Constellation_ReadingTemplateWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA
49 0.01 ms default MULTI 2
50 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Constellation_ReadingTemplateWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
51 1.49 ms default EXEC
52 1.43 ms default MGET jjfFtuUw8i:App__Entity__Constellation__World__CLASSMETADATA__ jjfFtuUw8i:App__Entity__Constellation__ReadingTemplateWorld__CLASSMETADATA__
53 0.01 ms default MULTI 2
54 0.01 ms default SETEX jjfFtuUw8i:App__Entity__Constellation__World__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":20:{s:19:"associationMappings";a:1:{s:9:"subWorlds";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:9:"subWorlds";s:12:"sourceEntity";s:30:"App\Entity\Constellation\World";s:12:"targetEntity";s:33:"App\Entity\Constellation\SubWorld";s:5:"fetch";i:2;s:8:"mappedBy";s:5:"world";}}s:11:"columnNames";a:5:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:7:"version";s:7:"version";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:13:"fieldMappings";a:5:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:4:"name";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"name";s:10:"columnName";s:4:"name";s:6:"length";i:90;}s:7:"version";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:7:"decimal";s:9:"fieldName";s:7:"version";s:10:"columnName";s:7:"version";s:8:"nullable";b:1;s:9:"precision";i:10;s:5:"scale";i:8;}s:20:"is_marked_as_deleted";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"is_marked_as_deleted";s:10:"columnName";s:20:"is_marked_as_deleted";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"deleted_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"deleted_at";s:10:"columnName";s:10:"deleted_at";s:8:"nullable";b:1;}}s:10:"fieldNames";a:5:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:7:"version";s:7:"version";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:30:"App\Entity\Constellation\World";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:2:{s:4:"name";s:5:"World";s:6:"quoted";b:1;}s:14:"rootEntityName";s:30:"App\Entity\Constellation\World";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:15:"inheritanceType";i:2;s:19:"discriminatorColumn";O:47:"Doctrine\ORM\Mapping\DiscriminatorColumnMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:5:"discr";s:4:"name";s:5:"discr";s:6:"length";i:255;s:7:"options";a:0:{}}s:18:"discriminatorValue";N;s:16:"discriminatorMap";a:3:{s:13:"student_world";s:37:"App\Entity\Constellation\StudentWorld";s:13:"teacher_world";s:37:"App\Entity\Constellation\TeacherWorld";s:22:"reading_template_world";s:45:"App\Entity\Constellation\ReadingTemplateWorld";}s:13:"parentClasses";a:0:{}s:10:"subClasses";a:3:{i:0;s:37:"App\Entity\Constellation\StudentWorld";i:1;s:37:"App\Entity\Constellation\TeacherWorld";i:2;s:45:"App\Entity\Constellation\ReadingTemplateWorld";}s:13:"generatorType";i:4;}
55 0.01 ms default SETEX jjfFtuUw8i:App__Entity__Constellation__ReadingTemplateWorld__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":20:{s:19:"associationMappings";a:3:{s:9:"subWorlds";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":7:{s:9:"fieldName";s:9:"subWorlds";s:12:"sourceEntity";s:30:"App\Entity\Constellation\World";s:12:"targetEntity";s:33:"App\Entity\Constellation\SubWorld";s:5:"fetch";i:2;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";s:8:"mappedBy";s:5:"world";}s:7:"creator";O:46:"Doctrine\ORM\Mapping\OneToOneOwningSideMapping":8:{s:9:"fieldName";s:7:"creator";s:12:"sourceEntity";s:45:"App\Entity\Constellation\ReadingTemplateWorld";s:12:"targetEntity";s:22:"App\Entity\SupportUser";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:10:"creator_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:1;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:10:"creator_id";s:10:"creator_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:10:"creator_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:10:"creator_id";}}s:8:"template";O:46:"Doctrine\ORM\Mapping\OneToOneOwningSideMapping":8:{s:9:"fieldName";s:8:"template";s:12:"sourceEntity";s:45:"App\Entity\Constellation\ReadingTemplateWorld";s:12:"targetEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:11:"template_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:1;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:11:"template_id";s:11:"template_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:11:"template_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:11:"template_id";}}}s:11:"columnNames";a:7:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:7:"version";s:7:"version";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";s:11:"description";s:11:"description";s:11:"island_type";s:11:"island_type";}s:13:"fieldMappings";a:7:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";}s:4:"name";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"name";s:10:"columnName";s:4:"name";s:6:"length";i:90;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";}s:7:"version";O:33:"Doctrine\ORM\Mapping\FieldMapping":8:{s:4:"type";s:7:"decimal";s:9:"fieldName";s:7:"version";s:10:"columnName";s:7:"version";s:8:"nullable";b:1;s:9:"precision";i:10;s:5:"scale";i:8;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";}s:20:"is_marked_as_deleted";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"is_marked_as_deleted";s:10:"columnName";s:20:"is_marked_as_deleted";s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"deleted_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"deleted_at";s:10:"columnName";s:10:"deleted_at";s:8:"nullable";b:1;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";}s:11:"description";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:11:"description";s:10:"columnName";s:11:"description";s:8:"nullable";b:1;}s:11:"island_type";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:11:"island_type";s:10:"columnName";s:11:"island_type";s:8:"nullable";b:1;}}s:10:"fieldNames";a:7:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:7:"version";s:7:"version";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";s:11:"description";s:11:"description";s:11:"island_type";s:11:"island_type";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:45:"App\Entity\Constellation\ReadingTemplateWorld";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:2:{s:4:"name";s:20:"ReadingTemplateWorld";s:6:"quoted";b:1;}s:14:"rootEntityName";s:30:"App\Entity\Constellation\World";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:15:"inheritanceType";i:2;s:19:"discriminatorColumn";O:47:"Doctrine\ORM\Mapping\DiscriminatorColumnMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:5:"discr";s:4:"name";s:5:"discr";s:6:"length";i:255;s:7:"options";a:0:{}}s:18:"discriminatorValue";s:22:"reading_template_world";s:16:"discriminatorMap";a:3:{s:13:"student_world";s:37:"App\Entity\Constellation\StudentWorld";s:13:"teacher_world";s:37:"App\Entity\Constellation\TeacherWorld";s:22:"reading_template_world";s:45:"App\Entity\Constellation\ReadingTemplateWorld";}s:13:"parentClasses";a:1:{i:0;s:30:"App\Entity\Constellation\World";}s:10:"subClasses";a:0:{}s:13:"generatorType";i:4;}
56 1.75 ms default EXEC
57 6.89 ms default MGET jjfFtuUw8i:App__Entity__Constellation__StudentWorld__CLASSMETADATA__
58 1.53 ms default MGET jjfFtuUw8i:App_Entity_Constellation_StudentWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA
59 0.01 ms default MULTI 2
60 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Constellation_StudentWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
61 2.49 ms default EXEC
62 10.84 ms default MGET jjfFtuUw8i:App__Entity__Constellation__StudentWorld__CLASSMETADATA__
63 0.01 ms default MULTI 2
64 0.02 ms default SETEX jjfFtuUw8i:App__Entity__Constellation__StudentWorld__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":20:{s:19:"associationMappings";a:3:{s:9:"subWorlds";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":7:{s:9:"fieldName";s:9:"subWorlds";s:12:"sourceEntity";s:30:"App\Entity\Constellation\World";s:12:"targetEntity";s:33:"App\Entity\Constellation\SubWorld";s:5:"fetch";i:2;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";s:8:"mappedBy";s:5:"world";}s:7:"student";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:7:"student";s:12:"sourceEntity";s:37:"App\Entity\Constellation\StudentWorld";s:12:"targetEntity";s:18:"App\Entity\Student";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:10:"student_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:10:"student_id";s:10:"student_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:10:"student_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:10:"student_id";}}s:13:"userChallenge";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:13:"userChallenge";s:12:"sourceEntity";s:37:"App\Entity\Constellation\StudentWorld";s:12:"targetEntity";s:38:"App\Entity\Constellation\UserChallenge";s:5:"fetch";i:2;s:8:"mappedBy";s:5:"world";}}s:11:"columnNames";a:5:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:7:"version";s:7:"version";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:13:"fieldMappings";a:5:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";}s:4:"name";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"name";s:10:"columnName";s:4:"name";s:6:"length";i:90;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";}s:7:"version";O:33:"Doctrine\ORM\Mapping\FieldMapping":8:{s:4:"type";s:7:"decimal";s:9:"fieldName";s:7:"version";s:10:"columnName";s:7:"version";s:8:"nullable";b:1;s:9:"precision";i:10;s:5:"scale";i:8;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";}s:20:"is_marked_as_deleted";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"is_marked_as_deleted";s:10:"columnName";s:20:"is_marked_as_deleted";s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"deleted_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"deleted_at";s:10:"columnName";s:10:"deleted_at";s:8:"nullable";b:1;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";}}s:10:"fieldNames";a:5:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:7:"version";s:7:"version";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:37:"App\Entity\Constellation\StudentWorld";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:2:{s:4:"name";s:12:"StudentWorld";s:6:"quoted";b:1;}s:14:"rootEntityName";s:30:"App\Entity\Constellation\World";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:51:"App\Repository\Constellation\StudentWorldRepository";s:15:"inheritanceType";i:2;s:19:"discriminatorColumn";O:47:"Doctrine\ORM\Mapping\DiscriminatorColumnMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:5:"discr";s:4:"name";s:5:"discr";s:6:"length";i:255;s:7:"options";a:0:{}}s:18:"discriminatorValue";s:13:"student_world";s:16:"discriminatorMap";a:3:{s:13:"student_world";s:37:"App\Entity\Constellation\StudentWorld";s:13:"teacher_world";s:37:"App\Entity\Constellation\TeacherWorld";s:22:"reading_template_world";s:45:"App\Entity\Constellation\ReadingTemplateWorld";}s:13:"parentClasses";a:1:{i:0;s:30:"App\Entity\Constellation\World";}s:10:"subClasses";a:0:{}s:13:"generatorType";i:4;}
65 1.57 ms default EXEC
66 1.56 ms default MGET jjfFtuUw8i:App__Entity__Constellation__TeacherWorld__CLASSMETADATA__
67 1.56 ms default MGET jjfFtuUw8i:App_Entity_Constellation_TeacherWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA
68 0.01 ms default MULTI 2
69 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Constellation_TeacherWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
70 1.51 ms default EXEC
71 1.57 ms default MGET jjfFtuUw8i:App__Entity__Constellation__TeacherWorld__CLASSMETADATA__
72 0.01 ms default MULTI 2
73 0.02 ms default SETEX jjfFtuUw8i:App__Entity__Constellation__TeacherWorld__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":20:{s:19:"associationMappings";a:4:{s:9:"subWorlds";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":7:{s:9:"fieldName";s:9:"subWorlds";s:12:"sourceEntity";s:30:"App\Entity\Constellation\World";s:12:"targetEntity";s:33:"App\Entity\Constellation\SubWorld";s:5:"fetch";i:2;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";s:8:"mappedBy";s:5:"world";}s:7:"manager";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:7:"manager";s:12:"sourceEntity";s:37:"App\Entity\Constellation\TeacherWorld";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:10:"manager_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:10:"manager_id";s:10:"manager_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:10:"manager_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:10:"manager_id";}}s:9:"classroom";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:9:"classroom";s:12:"sourceEntity";s:37:"App\Entity\Constellation\TeacherWorld";s:12:"targetEntity";s:20:"App\Entity\Classroom";s:5:"fetch";i:2;s:10:"inversedBy";s:14:"teacher_worlds";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:12:"classroom_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:12:"classroom_id";s:12:"classroom_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:12:"classroom_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:12:"classroom_id";}}s:8:"template";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:8:"template";s:12:"sourceEntity";s:37:"App\Entity\Constellation\TeacherWorld";s:12:"targetEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:11:"template_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:11:"template_id";s:11:"template_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:11:"template_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:11:"template_id";}}}s:11:"columnNames";a:9:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:7:"version";s:7:"version";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";s:6:"public";s:6:"public";s:11:"description";s:11:"description";s:11:"island_type";s:11:"island_type";s:10:"created_at";s:10:"created_at";}s:13:"fieldMappings";a:9:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";}s:4:"name";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"name";s:10:"columnName";s:4:"name";s:6:"length";i:90;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";}s:7:"version";O:33:"Doctrine\ORM\Mapping\FieldMapping":8:{s:4:"type";s:7:"decimal";s:9:"fieldName";s:7:"version";s:10:"columnName";s:7:"version";s:8:"nullable";b:1;s:9:"precision";i:10;s:5:"scale";i:8;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";}s:20:"is_marked_as_deleted";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"is_marked_as_deleted";s:10:"columnName";s:20:"is_marked_as_deleted";s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"deleted_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"deleted_at";s:10:"columnName";s:10:"deleted_at";s:8:"nullable";b:1;s:9:"inherited";s:30:"App\Entity\Constellation\World";s:8:"declared";s:30:"App\Entity\Constellation\World";}s:6:"public";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:6:"public";s:10:"columnName";s:6:"public";}s:11:"description";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:11:"description";s:10:"columnName";s:11:"description";s:8:"nullable";b:1;}s:11:"island_type";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:11:"island_type";s:10:"columnName";s:11:"island_type";s:8:"nullable";b:1;}s:10:"created_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"created_at";s:10:"columnName";s:10:"created_at";s:8:"nullable";b:1;}}s:10:"fieldNames";a:9:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:7:"version";s:7:"version";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";s:6:"public";s:6:"public";s:11:"description";s:11:"description";s:11:"island_type";s:11:"island_type";s:10:"created_at";s:10:"created_at";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:37:"App\Entity\Constellation\TeacherWorld";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:2:{s:4:"name";s:12:"TeacherWorld";s:6:"quoted";b:1;}s:14:"rootEntityName";s:30:"App\Entity\Constellation\World";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:51:"App\Repository\Constellation\TeacherWorldRepository";s:15:"inheritanceType";i:2;s:19:"discriminatorColumn";O:47:"Doctrine\ORM\Mapping\DiscriminatorColumnMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:5:"discr";s:4:"name";s:5:"discr";s:6:"length";i:255;s:7:"options";a:0:{}}s:18:"discriminatorValue";s:13:"teacher_world";s:16:"discriminatorMap";a:3:{s:13:"student_world";s:37:"App\Entity\Constellation\StudentWorld";s:13:"teacher_world";s:37:"App\Entity\Constellation\TeacherWorld";s:22:"reading_template_world";s:45:"App\Entity\Constellation\ReadingTemplateWorld";}s:13:"parentClasses";a:1:{i:0;s:30:"App\Entity\Constellation\World";}s:10:"subClasses";a:0:{}s:13:"generatorType";i:4;}
74 2.92 ms default EXEC
75 1.49 ms default MGET jjfFtuUw8i:App__Entity__Classroom__CLASSMETADATA__
76 1.45 ms default MGET jjfFtuUw8i:App_Entity_Classroom_$GEDMO_TRANSLATABLE_CLASSMETADATA
77 0.01 ms default MULTI 2
78 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Classroom_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
79 1.53 ms default EXEC
80 1.58 ms default MGET jjfFtuUw8i:App__Entity__Classroom__CLASSMETADATA__
81 0.01 ms default MULTI 2
82 0.02 ms default SETEX jjfFtuUw8i:App__Entity__Classroom__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:8:{s:8:"Language";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:8:"Language";s:12:"sourceEntity";s:20:"App\Entity\Classroom";s:12:"targetEntity";s:19:"App\Entity\Language";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:11:"language_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:11:"language_id";s:11:"language_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:11:"language_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:11:"language_id";}}s:7:"manager";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:7:"manager";s:12:"sourceEntity";s:20:"App\Entity\Classroom";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:3;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:10:"manager_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:10:"manager_id";s:10:"manager_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:10:"manager_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:10:"manager_id";}}s:13:"students_list";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":6:{s:9:"fieldName";s:13:"students_list";s:12:"sourceEntity";s:20:"App\Entity\Classroom";s:12:"targetEntity";s:28:"App\Entity\ClassRegistration";s:7:"cascade";a:1:{i:0;s:7:"persist";}s:5:"fetch";i:2;s:8:"mappedBy";s:9:"classroom";}s:11:"grade_level";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:11:"grade_level";s:12:"sourceEntity";s:20:"App\Entity\Classroom";s:12:"targetEntity";s:29:"App\Entity\Catalog\GradeLevel";s:5:"fetch";i:2;s:5:"cache";a:2:{s:5:"usage";i:2;s:6:"region";s:8:"nanomonx";}s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:14:"grade_level_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:14:"grade_level_id";s:14:"grade_level_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:14:"grade_level_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:14:"grade_level_id";}}s:15:"troubChallenges";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:15:"troubChallenges";s:12:"sourceEntity";s:20:"App\Entity\Classroom";s:12:"targetEntity";s:31:"App\Entity\Troubadour\Challenge";s:5:"fetch";i:2;s:8:"mappedBy";s:9:"classroom";}s:23:"learningPathAssignments";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:23:"learningPathAssignments";s:12:"sourceEntity";s:20:"App\Entity\Classroom";s:12:"targetEntity";s:57:"App\Entity\Troubadour\LearningPath\LearningPathAssignment";s:5:"fetch";i:2;s:8:"mappedBy";s:9:"classroom";}s:15:"constChallenges";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:15:"constChallenges";s:12:"sourceEntity";s:20:"App\Entity\Classroom";s:12:"targetEntity";s:34:"App\Entity\Constellation\Challenge";s:5:"fetch";i:2;s:8:"mappedBy";s:9:"classroom";}s:14:"teacher_worlds";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:14:"teacher_worlds";s:12:"sourceEntity";s:20:"App\Entity\Classroom";s:12:"targetEntity";s:37:"App\Entity\Constellation\TeacherWorld";s:5:"fetch";i:2;s:8:"mappedBy";s:9:"classroom";}}s:11:"columnNames";a:10:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:5:"rules";s:5:"rules";s:11:"access_code";s:11:"access_code";s:19:"allow_public_access";s:19:"allow_public_access";s:19:"skipUntilSchoolYear";s:22:"skip_until_school_year";s:14:"googleCourseId";s:16:"google_course_id";s:10:"created_at";s:10:"created_at";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:13:"fieldMappings";a:10:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:4:"name";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"name";s:10:"columnName";s:4:"name";s:6:"length";i:90;}s:5:"rules";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"json";s:9:"fieldName";s:5:"rules";s:10:"columnName";s:5:"rules";}s:11:"access_code";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:6:"string";s:9:"fieldName";s:11:"access_code";s:10:"columnName";s:11:"access_code";s:8:"nullable";b:1;s:6:"unique";b:1;s:6:"length";i:90;}s:19:"allow_public_access";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:19:"allow_public_access";s:10:"columnName";s:19:"allow_public_access";}s:19:"skipUntilSchoolYear";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:19:"skipUntilSchoolYear";s:10:"columnName";s:22:"skip_until_school_year";s:8:"nullable";b:1;}s:14:"googleCourseId";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:6:"string";s:9:"fieldName";s:14:"googleCourseId";s:10:"columnName";s:16:"google_course_id";s:8:"nullable";b:1;s:6:"unique";b:1;s:6:"length";i:90;}s:10:"created_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"created_at";s:10:"columnName";s:10:"created_at";s:8:"nullable";b:1;}s:20:"is_marked_as_deleted";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"is_marked_as_deleted";s:10:"columnName";s:20:"is_marked_as_deleted";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"deleted_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"deleted_at";s:10:"columnName";s:10:"deleted_at";s:8:"nullable";b:1;}}s:10:"fieldNames";a:10:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:5:"rules";s:5:"rules";s:11:"access_code";s:11:"access_code";s:19:"allow_public_access";s:19:"allow_public_access";s:22:"skip_until_school_year";s:19:"skipUntilSchoolYear";s:16:"google_course_id";s:14:"googleCourseId";s:10:"created_at";s:10:"created_at";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:20:"App\Entity\Classroom";s:9:"namespace";s:10:"App\Entity";s:5:"table";a:2:{s:4:"name";s:9:"Classroom";s:6:"quoted";b:1;}s:14:"rootEntityName";s:20:"App\Entity\Classroom";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:34:"App\Repository\ClassroomRepository";s:13:"generatorType";i:4;}
83 1.65 ms default EXEC
84 1.49 ms default MGET jjfFtuUw8i:App__Entity__Constellation__SubWorld__CLASSMETADATA__
85 1.46 ms default MGET jjfFtuUw8i:App_Entity_Constellation_SubWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA
86 0.01 ms default MULTI 2
87 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Constellation_SubWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
88 1.44 ms default EXEC
89 1.47 ms default MGET jjfFtuUw8i:App__Entity__Constellation__SubWorld__CLASSMETADATA__
90 0.01 ms default MULTI 2
91 0.02 ms default SETEX jjfFtuUw8i:App__Entity__Constellation__SubWorld__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:4:{s:5:"world";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:5:"world";s:12:"sourceEntity";s:33:"App\Entity\Constellation\SubWorld";s:12:"targetEntity";s:30:"App\Entity\Constellation\World";s:5:"fetch";i:2;s:10:"inversedBy";s:9:"subWorlds";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"world_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:8:"world_id";s:8:"world_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"world_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"world_id";}}s:11:"textEntries";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:11:"textEntries";s:12:"sourceEntity";s:33:"App\Entity\Constellation\SubWorld";s:12:"targetEntity";s:34:"App\Entity\Constellation\TextEntry";s:5:"fetch";i:2;s:8:"mappedBy";s:8:"subWorld";}s:18:"connectedSubWorlds";O:48:"Doctrine\ORM\Mapping\ManyToManyOwningSideMapping":8:{s:9:"fieldName";s:18:"connectedSubWorlds";s:12:"sourceEntity";s:33:"App\Entity\Constellation\SubWorld";s:12:"targetEntity";s:33:"App\Entity\Constellation\SubWorld";s:5:"fetch";i:2;s:9:"joinTable";O:37:"Doctrine\ORM\Mapping\JoinTableMapping":4:{s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:9:"subWorldA";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:18:"inverseJoinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:9:"subWorldB";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:4:"name";s:19:"SubWorldConnections";s:7:"options";a:0:{}}s:16:"joinTableColumns";a:2:{i:0;s:9:"subWorldA";i:1;s:9:"subWorldB";}s:26:"relationToSourceKeyColumns";a:1:{s:9:"subWorldA";s:2:"id";}s:26:"relationToTargetKeyColumns";a:1:{s:9:"subWorldB";s:2:"id";}}s:11:"environment";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:11:"environment";s:12:"sourceEntity";s:33:"App\Entity\Constellation\SubWorld";s:12:"targetEntity";s:36:"App\Entity\Constellation\Environment";s:5:"fetch";i:2;s:10:"inversedBy";s:9:"subworlds";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:14:"environment_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:14:"environment_id";s:14:"environment_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:14:"environment_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:14:"environment_id";}}}s:11:"columnNames";a:9:{s:2:"id";s:2:"id";s:7:"content";s:7:"content";s:4:"name";s:4:"name";s:11:"wordCounter";s:11:"wordCounter";s:10:"lightStyle";s:10:"lightStyle";s:9:"isInitial";s:9:"isInitial";s:15:"buildPointValue";s:15:"buildPointValue";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:13:"fieldMappings";a:9:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:7:"content";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:4:"json";s:9:"fieldName";s:7:"content";s:10:"columnName";s:7:"content";s:8:"nullable";b:1;s:6:"quoted";b:1;}s:4:"name";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"name";s:10:"columnName";s:4:"name";}s:11:"wordCounter";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"integer";s:9:"fieldName";s:11:"wordCounter";s:10:"columnName";s:11:"wordCounter";}s:10:"lightStyle";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"integer";s:9:"fieldName";s:10:"lightStyle";s:10:"columnName";s:10:"lightStyle";}s:9:"isInitial";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:9:"isInitial";s:10:"columnName";s:9:"isInitial";}s:15:"buildPointValue";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"integer";s:9:"fieldName";s:15:"buildPointValue";s:10:"columnName";s:15:"buildPointValue";}s:20:"is_marked_as_deleted";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"is_marked_as_deleted";s:10:"columnName";s:20:"is_marked_as_deleted";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"deleted_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"deleted_at";s:10:"columnName";s:10:"deleted_at";s:8:"nullable";b:1;}}s:10:"fieldNames";a:9:{s:2:"id";s:2:"id";s:7:"content";s:7:"content";s:4:"name";s:4:"name";s:11:"wordCounter";s:11:"wordCounter";s:10:"lightStyle";s:10:"lightStyle";s:9:"isInitial";s:9:"isInitial";s:15:"buildPointValue";s:15:"buildPointValue";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:33:"App\Entity\Constellation\SubWorld";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:2:{s:4:"name";s:8:"SubWorld";s:6:"quoted";b:1;}s:14:"rootEntityName";s:33:"App\Entity\Constellation\SubWorld";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;}
92 1.54 ms default EXEC
93 1.46 ms default MGET jjfFtuUw8i:App__Entity__Constellation__UserChallenge__CLASSMETADATA__
94 1.44 ms default MGET jjfFtuUw8i:App_Entity_Constellation_UserChallenge_$GEDMO_TRANSLATABLE_CLASSMETADATA
95 0.01 ms default MULTI 2
96 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Constellation_UserChallenge_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
97 1.40 ms default EXEC
98 1.44 ms default MGET jjfFtuUw8i:App__Entity__Constellation__UserChallenge__CLASSMETADATA__
99 0.01 ms default MULTI 2
100 0.03 ms default SETEX jjfFtuUw8i:App__Entity__Constellation__UserChallenge__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:4:{s:13:"statusHistory";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":8:{s:9:"fieldName";s:13:"statusHistory";s:12:"sourceEntity";s:38:"App\Entity\Constellation\UserChallenge";s:12:"targetEntity";s:44:"App\Entity\Constellation\UserChallengeStatus";s:7:"cascade";a:2:{i:0;s:7:"persist";i:1;s:6:"remove";}s:5:"fetch";i:2;s:13:"orphanRemoval";b:1;s:8:"mappedBy";s:13:"userChallenge";s:7:"orderBy";a:2:{s:4:"date";s:3:"ASC";s:2:"id";s:3:"ASC";}}s:7:"student";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:7:"student";s:12:"sourceEntity";s:38:"App\Entity\Constellation\UserChallenge";s:12:"targetEntity";s:18:"App\Entity\Student";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:10:"student_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:10:"student_id";s:10:"student_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:10:"student_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:10:"student_id";}}s:9:"challenge";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:9:"challenge";s:12:"sourceEntity";s:38:"App\Entity\Constellation\UserChallenge";s:12:"targetEntity";s:34:"App\Entity\Constellation\Challenge";s:5:"fetch";i:2;s:10:"inversedBy";s:14:"userChallenges";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:12:"challenge_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:12:"challenge_id";s:12:"challenge_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:12:"challenge_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:12:"challenge_id";}}s:5:"world";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:5:"world";s:12:"sourceEntity";s:38:"App\Entity\Constellation\UserChallenge";s:12:"targetEntity";s:37:"App\Entity\Constellation\StudentWorld";s:5:"fetch";i:2;s:10:"inversedBy";s:13:"userChallenge";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"world_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:8:"world_id";s:8:"world_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"world_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"world_id";}}}s:11:"columnNames";a:13:{s:2:"id";s:2:"id";s:6:"status";s:6:"status";s:8:"comments";s:8:"comments";s:4:"data";s:4:"data";s:17:"validation_errors";s:17:"validation_errors";s:25:"has_student_viewed_latest";s:25:"has_student_viewed_latest";s:10:"is_gallery";s:10:"is_gallery";s:18:"is_student_gallery";s:18:"is_student_gallery";s:10:"created_at";s:10:"created_at";s:10:"updated_at";s:10:"updated_at";s:12:"completed_at";s:12:"completed_at";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:13:"fieldMappings";a:13:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:6:"status";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:6:"status";s:10:"columnName";s:6:"status";s:8:"nullable";b:1;}s:8:"comments";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"json";s:9:"fieldName";s:8:"comments";s:10:"columnName";s:8:"comments";}s:4:"data";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"json";s:9:"fieldName";s:4:"data";s:10:"columnName";s:4:"data";}s:17:"validation_errors";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"json";s:9:"fieldName";s:17:"validation_errors";s:10:"columnName";s:17:"validation_errors";s:8:"nullable";b:1;}s:25:"has_student_viewed_latest";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:25:"has_student_viewed_latest";s:10:"columnName";s:25:"has_student_viewed_latest";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"is_gallery";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:10:"is_gallery";s:10:"columnName";s:10:"is_gallery";s:7:"options";a:1:{s:7:"default";b:0;}}s:18:"is_student_gallery";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:18:"is_student_gallery";s:10:"columnName";s:18:"is_student_gallery";s:7:"options";a:1:{s:7:"default";b:1;}}s:10:"created_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:10:"created_at";s:10:"columnName";s:10:"created_at";s:8:"nullable";b:1;}s:10:"updated_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:10:"updated_at";s:10:"columnName";s:10:"updated_at";s:8:"nullable";b:1;}s:12:"completed_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:12:"completed_at";s:10:"columnName";s:12:"completed_at";s:8:"nullable";b:1;}s:20:"is_marked_as_deleted";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"is_marked_as_deleted";s:10:"columnName";s:20:"is_marked_as_deleted";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"deleted_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"deleted_at";s:10:"columnName";s:10:"deleted_at";s:8:"nullable";b:1;}}s:10:"fieldNames";a:13:{s:2:"id";s:2:"id";s:6:"status";s:6:"status";s:8:"comments";s:8:"comments";s:4:"data";s:4:"data";s:17:"validation_errors";s:17:"validation_errors";s:25:"has_student_viewed_latest";s:25:"has_student_viewed_latest";s:10:"is_gallery";s:10:"is_gallery";s:18:"is_student_gallery";s:18:"is_student_gallery";s:10:"created_at";s:10:"created_at";s:10:"updated_at";s:10:"updated_at";s:12:"completed_at";s:12:"completed_at";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:38:"App\Entity\Constellation\UserChallenge";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:2:{s:4:"name";s:13:"UserChallenge";s:6:"quoted";b:1;}s:14:"rootEntityName";s:38:"App\Entity\Constellation\UserChallenge";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:52:"App\Repository\Constellation\UserChallengeRepository";s:13:"generatorType";i:4;s:18:"lifecycleCallbacks";a:2:{s:10:"prePersist";a:1:{i:0;s:12:"setCreatedAt";}s:9:"preUpdate";a:1:{i:0;s:12:"setUpdatedAt";}}}
101 1.61 ms default EXEC
102 1.48 ms default MGET p0r1f7a4dN:5575ed236b054ea2524b8a624056f86d
103 0.01 ms default MULTI 2
104 0.02 ms default SETEX p0r1f7a4dN:5575ed236b054ea2524b8a624056f86d 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:220:"SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.is_historical AS is_historical_2, t0_.is_forDefaultChallenge AS is_forDefaultChallenge_3, t0_.`translations` AS translations_4, t0_.client_id AS client_id_5 FROM `Theme` t0_";}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:30:"App\Entity\Constellation\Theme";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:6:{s:4:"id_0";s:2:"id";s:6:"name_1";s:4:"name";s:15:"is_historical_2";s:13:"is_historical";s:24:"is_forDefaultChallenge_3";s:22:"is_forDefaultChallenge";s:14:"translations_4";s:12:"translations";s:11:"client_id_5";s:9:"client_id";}s:19:"columnAliasMappings";a:1:{s:30:"App\Entity\Constellation\Theme";a:1:{s:6:"entity";a:6:{s:2:"id";s:4:"id_0";s:4:"name";s:6:"name_1";s:13:"is_historical";s:15:"is_historical_2";s:22:"is_forDefaultChallenge";s:24:"is_forDefaultChallenge_3";s:12:"translations";s:14:"translations_4";s:9:"client_id";s:11:"client_id_5";}}}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:6:{s:4:"id_0";s:6:"entity";s:6:"name_1";s:6:"entity";s:15:"is_historical_2";s:6:"entity";s:24:"is_forDefaultChallenge_3";s:6:"entity";s:14:"translations_4";s:6:"entity";s:11:"client_id_5";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:6:{s:4:"id_0";s:30:"App\Entity\Constellation\Theme";s:6:"name_1";s:30:"App\Entity\Constellation\Theme";s:15:"is_historical_2";s:30:"App\Entity\Constellation\Theme";s:24:"is_forDefaultChallenge_3";s:30:"App\Entity\Constellation\Theme";s:14:"translations_4";s:30:"App\Entity\Constellation\Theme";s:11:"client_id_5";s:30:"App\Entity\Constellation\Theme";}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:{}}
105 1.47 ms default EXEC
106 1.58 ms default MGET b2HGyrdj70:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_2__translations
107 1.57 ms default MGET b2HGyrdj70:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_2 b2HGyrdj70:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_6
108 1.47 ms default MGET b2HGyrdj70:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_3__translations
109 1.78 ms default MGET b2HGyrdj70:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_3 b2HGyrdj70:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_4
110 1.46 ms default MGET jjfFtuUw8i:App__Entity__Troubadour__LearningPath__LearningPathAssignment__CLASSMETADATA__
111 1.60 ms default MGET jjfFtuUw8i:App_Entity_Troubadour_LearningPath_LearningPathAssignment_$GEDMO_TRANSLATABLE_CLASSMETADATA
112 0.02 ms default MULTI 2
113 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Troubadour_LearningPath_LearningPathAssignment_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
114 1.45 ms default EXEC
115 1.43 ms default MGET jjfFtuUw8i:App__Entity__Troubadour__LearningPath__LearningPathAssignment__CLASSMETADATA__
116 0.01 ms default MULTI 2
117 0.01 ms default SETEX jjfFtuUw8i:App__Entity__Troubadour__LearningPath__LearningPathAssignment__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:2:{s:9:"classroom";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:9:"classroom";s:12:"sourceEntity";s:57:"App\Entity\Troubadour\LearningPath\LearningPathAssignment";s:12:"targetEntity";s:20:"App\Entity\Classroom";s:5:"fetch";i:2;s:10:"inversedBy";s:23:"learningPathAssignments";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:12:"classroom_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:12:"classroom_id";s:12:"classroom_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:12:"classroom_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:12:"classroom_id";}}s:12:"learningPath";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:12:"learningPath";s:12:"sourceEntity";s:57:"App\Entity\Troubadour\LearningPath\LearningPathAssignment";s:12:"targetEntity";s:47:"App\Entity\Troubadour\LearningPath\LearningPath";s:5:"fetch";i:2;s:10:"inversedBy";s:11:"assignments";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:16:"learning_path_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:16:"learning_path_id";s:16:"learning_path_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:16:"learning_path_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:16:"learning_path_id";}}}s:11:"columnNames";a:3:{s:2:"id";s:2:"id";s:12:"isOneAtATime";s:15:"is_one_at_atime";s:8:"isActive";s:9:"is_active";}s:13:"fieldMappings";a:3:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:12:"isOneAtATime";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:12:"isOneAtATime";s:10:"columnName";s:15:"is_one_at_atime";s:7:"options";a:1:{s:7:"default";b:0;}}s:8:"isActive";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:8:"isActive";s:10:"columnName";s:9:"is_active";s:7:"options";a:1:{s:7:"default";b:1;}}}s:10:"fieldNames";a:3:{s:2:"id";s:2:"id";s:15:"is_one_at_atime";s:12:"isOneAtATime";s:9:"is_active";s:8:"isActive";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:57:"App\Entity\Troubadour\LearningPath\LearningPathAssignment";s:9:"namespace";s:34:"App\Entity\Troubadour\LearningPath";s:5:"table";a:2:{s:4:"name";s:28:"troub_LearningPathAssignment";s:6:"quoted";b:1;}s:14:"rootEntityName";s:57:"App\Entity\Troubadour\LearningPath\LearningPathAssignment";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:71:"App\Repository\Troubadour\LearningPath\LearningPathAssignmentRepository";s:13:"generatorType";i:4;}
118 1.55 ms default EXEC
119 1.45 ms default MGET jjfFtuUw8i:App__Entity__Constellation__Challenge__CLASSMETADATA__
120 1.48 ms default MGET jjfFtuUw8i:App_Entity_Constellation_Challenge_$GEDMO_TRANSLATABLE_CLASSMETADATA
121 0.01 ms default MULTI 2
122 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Constellation_Challenge_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
123 1.57 ms default EXEC
124 1.52 ms default MGET jjfFtuUw8i:App__Entity__Constellation__Challenge__CLASSMETADATA__
125 0.01 ms default MULTI 2
126 0.02 ms default SETEX jjfFtuUw8i:App__Entity__Constellation__Challenge__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:4:{s:14:"userChallenges";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:14:"userChallenges";s:12:"sourceEntity";s:34:"App\Entity\Constellation\Challenge";s:12:"targetEntity";s:38:"App\Entity\Constellation\UserChallenge";s:5:"fetch";i:2;s:8:"mappedBy";s:9:"challenge";}s:9:"classroom";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:9:"classroom";s:12:"sourceEntity";s:34:"App\Entity\Constellation\Challenge";s:12:"targetEntity";s:20:"App\Entity\Classroom";s:5:"fetch";i:2;s:10:"inversedBy";s:15:"constChallenges";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:12:"classroom_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:12:"classroom_id";s:12:"classroom_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:12:"classroom_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:12:"classroom_id";}}s:13:"students_list";O:48:"Doctrine\ORM\Mapping\ManyToManyOwningSideMapping":8:{s:9:"fieldName";s:13:"students_list";s:12:"sourceEntity";s:34:"App\Entity\Constellation\Challenge";s:12:"targetEntity";s:18:"App\Entity\Student";s:5:"fetch";i:2;s:9:"joinTable";O:37:"Doctrine\ORM\Mapping\JoinTableMapping":4:{s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:12:"challenge_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:18:"inverseJoinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:10:"student_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:4:"name";s:17:"student_challenge";s:7:"options";a:0:{}}s:16:"joinTableColumns";a:2:{i:0;s:12:"challenge_id";i:1;s:10:"student_id";}s:26:"relationToSourceKeyColumns";a:1:{s:12:"challenge_id";s:2:"id";}s:26:"relationToTargetKeyColumns";a:1:{s:10:"student_id";s:2:"id";}}s:15:"source_template";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:15:"source_template";s:12:"sourceEntity";s:34:"App\Entity\Constellation\Challenge";s:12:"targetEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:21:"challenge_template_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:21:"challenge_template_id";s:21:"challenge_template_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:21:"challenge_template_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:21:"challenge_template_id";}}}s:11:"columnNames";a:12:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:11:"description";s:11:"description";s:18:"educational_intent";s:18:"educational_intent";s:21:"additional_activities";s:21:"additional_activities";s:17:"expected_duration";s:17:"expected_duration";s:6:"status";s:6:"status";s:5:"rules";s:5:"rules";s:14:"is_highlighted";s:14:"is_highlighted";s:10:"created_at";s:10:"created_at";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:13:"fieldMappings";a:12:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:4:"name";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"name";s:10:"columnName";s:4:"name";s:6:"length";i:90;}s:11:"description";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"text";s:9:"fieldName";s:11:"description";s:10:"columnName";s:11:"description";}s:18:"educational_intent";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:18:"educational_intent";s:10:"columnName";s:18:"educational_intent";s:8:"nullable";b:1;}s:21:"additional_activities";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:21:"additional_activities";s:10:"columnName";s:21:"additional_activities";s:8:"nullable";b:1;}s:17:"expected_duration";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:17:"expected_duration";s:10:"columnName";s:17:"expected_duration";s:8:"nullable";b:1;}s:6:"status";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:6:"status";s:10:"columnName";s:6:"status";}s:5:"rules";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"json";s:9:"fieldName";s:5:"rules";s:10:"columnName";s:5:"rules";}s:14:"is_highlighted";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:14:"is_highlighted";s:10:"columnName";s:14:"is_highlighted";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"created_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"created_at";s:10:"columnName";s:10:"created_at";s:8:"nullable";b:1;}s:20:"is_marked_as_deleted";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"is_marked_as_deleted";s:10:"columnName";s:20:"is_marked_as_deleted";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"deleted_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"deleted_at";s:10:"columnName";s:10:"deleted_at";s:8:"nullable";b:1;}}s:10:"fieldNames";a:12:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:11:"description";s:11:"description";s:18:"educational_intent";s:18:"educational_intent";s:21:"additional_activities";s:21:"additional_activities";s:17:"expected_duration";s:17:"expected_duration";s:6:"status";s:6:"status";s:5:"rules";s:5:"rules";s:14:"is_highlighted";s:14:"is_highlighted";s:10:"created_at";s:10:"created_at";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:34:"App\Entity\Constellation\Challenge";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:2:{s:4:"name";s:9:"Challenge";s:6:"quoted";b:1;}s:14:"rootEntityName";s:34:"App\Entity\Constellation\Challenge";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:48:"App\Repository\Constellation\ChallengeRepository";s:13:"generatorType";i:4;}
127 1.55 ms default EXEC
128 1.44 ms default MGET jjfFtuUw8i:App__Entity__Constellation__TextEntry__CLASSMETADATA__
129 1.43 ms default MGET jjfFtuUw8i:App_Entity_Constellation_TextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA
130 0.01 ms default MULTI 2
131 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Constellation_TextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
132 1.44 ms default EXEC
133 1.48 ms default MGET jjfFtuUw8i:App__Entity__Constellation__TextEntry__CLASSMETADATA__
134 0.01 ms default MULTI 2
135 0.01 ms default SETEX jjfFtuUw8i:App__Entity__Constellation__TextEntry__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:2:{s:8:"subWorld";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:8:"subWorld";s:12:"sourceEntity";s:34:"App\Entity\Constellation\TextEntry";s:12:"targetEntity";s:33:"App\Entity\Constellation\SubWorld";s:5:"fetch";i:2;s:10:"inversedBy";s:11:"textEntries";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:10:"subWorldId";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:0;}}s:20:"joinColumnFieldNames";a:1:{s:10:"subWorldId";s:10:"subWorldId";}s:24:"sourceToTargetKeyColumns";a:1:{s:10:"subWorldId";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:10:"subWorldId";}}s:9:"revisions";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:9:"revisions";s:12:"sourceEntity";s:34:"App\Entity\Constellation\TextEntry";s:12:"targetEntity";s:33:"App\Entity\Constellation\Revision";s:5:"fetch";i:2;s:8:"mappedBy";s:9:"textEntry";}}s:11:"columnNames";a:7:{s:2:"id";s:2:"id";s:10:"instanceId";s:10:"instanceId";s:8:"prefabId";s:8:"prefabId";s:14:"isIntroduction";s:14:"isIntroduction";s:12:"isConclusion";s:12:"isConclusion";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:13:"fieldMappings";a:7:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:10:"instanceId";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:10:"instanceId";s:10:"columnName";s:10:"instanceId";s:6:"length";i:68;}s:8:"prefabId";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"integer";s:9:"fieldName";s:8:"prefabId";s:10:"columnName";s:8:"prefabId";}s:14:"isIntroduction";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:14:"isIntroduction";s:10:"columnName";s:14:"isIntroduction";}s:12:"isConclusion";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:12:"isConclusion";s:10:"columnName";s:12:"isConclusion";}s:20:"is_marked_as_deleted";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"is_marked_as_deleted";s:10:"columnName";s:20:"is_marked_as_deleted";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"deleted_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"deleted_at";s:10:"columnName";s:10:"deleted_at";s:8:"nullable";b:1;}}s:10:"fieldNames";a:7:{s:2:"id";s:2:"id";s:10:"instanceId";s:10:"instanceId";s:8:"prefabId";s:8:"prefabId";s:14:"isIntroduction";s:14:"isIntroduction";s:12:"isConclusion";s:12:"isConclusion";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:34:"App\Entity\Constellation\TextEntry";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:2:{s:4:"name";s:9:"TextEntry";s:6:"quoted";b:1;}s:14:"rootEntityName";s:34:"App\Entity\Constellation\TextEntry";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;}
136 1.47 ms default EXEC
137 1.40 ms default MGET jjfFtuUw8i:App__Entity__Constellation__Environment__CLASSMETADATA__
138 1.41 ms default MGET jjfFtuUw8i:App_Entity_Constellation_Environment_$GEDMO_TRANSLATABLE_CLASSMETADATA
139 0.01 ms default MULTI 2
140 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Constellation_Environment_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
141 1.43 ms default EXEC
142 1.43 ms default MGET jjfFtuUw8i:App__Entity__Constellation__Environment__CLASSMETADATA__
143 0.01 ms default MULTI 2
144 0.01 ms default SETEX jjfFtuUw8i:App__Entity__Constellation__Environment__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:2:{s:9:"subworlds";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:9:"subworlds";s:12:"sourceEntity";s:36:"App\Entity\Constellation\Environment";s:12:"targetEntity";s:33:"App\Entity\Constellation\SubWorld";s:5:"fetch";i:2;s:8:"mappedBy";s:11:"environment";}s:13:"subworld_size";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:13:"subworld_size";s:12:"sourceEntity";s:36:"App\Entity\Constellation\Environment";s:12:"targetEntity";s:37:"App\Entity\Constellation\SubworldSize";s:5:"fetch";i:2;s:10:"inversedBy";s:12:"environments";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:16:"subworld_size_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:16:"subworld_size_id";s:16:"subworld_size_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:16:"subworld_size_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:16:"subworld_size_id";}}}s:11:"columnNames";a:5:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:10:"prefab_key";s:10:"prefab_key";s:5:"image";s:5:"image";s:12:"translations";s:12:"translations";}s:13:"fieldMappings";a:5:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:4:"name";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"name";s:10:"columnName";s:4:"name";}s:10:"prefab_key";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:10:"prefab_key";s:10:"columnName";s:10:"prefab_key";}s:5:"image";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:5:"image";s:10:"columnName";s:5:"image";s:8:"nullable";b:1;}s:12:"translations";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:4:"json";s:9:"fieldName";s:12:"translations";s:10:"columnName";s:12:"translations";s:8:"nullable";b:1;s:6:"quoted";b:1;}}s:10:"fieldNames";a:5:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:10:"prefab_key";s:10:"prefab_key";s:5:"image";s:5:"image";s:12:"translations";s:12:"translations";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:36:"App\Entity\Constellation\Environment";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:3:{s:4:"name";s:11:"Environment";s:6:"quoted";b:1;s:17:"uniqueConstraints";a:1:{s:10:"search_idx";a:1:{s:7:"columns";a:1:{i:0;s:10:"prefab_key";}}}}s:14:"rootEntityName";s:36:"App\Entity\Constellation\Environment";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;}
145 1.56 ms default EXEC
146 1.45 ms default MGET jjfFtuUw8i:App__Entity__Constellation__UserChallengeStatus__CLASSMETADATA__
147 14.67 ms default MGET jjfFtuUw8i:App_Entity_Constellation_UserChallengeStatus_$GEDMO_TRANSLATABLE_CLASSMETADATA
148 0.01 ms default MULTI 2
149 0.01 ms default SETEX jjfFtuUw8i:App_Entity_Constellation_UserChallengeStatus_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
150 1.53 ms default EXEC
151 1.44 ms default MGET jjfFtuUw8i:App__Entity__Constellation__UserChallengeStatus__CLASSMETADATA__
152 0.01 ms default MULTI 2
153 0.02 ms default SETEX jjfFtuUw8i:App__Entity__Constellation__UserChallengeStatus__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:1:{s:13:"userChallenge";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:13:"userChallenge";s:12:"sourceEntity";s:44:"App\Entity\Constellation\UserChallengeStatus";s:12:"targetEntity";s:38:"App\Entity\Constellation\UserChallenge";s:5:"fetch";i:2;s:10:"inversedBy";s:13:"statusHistory";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:16:"userChallenge_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:16:"userChallenge_id";s:16:"userChallenge_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:16:"userChallenge_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:16:"userChallenge_id";}}}s:11:"columnNames";a:3:{s:2:"id";s:2:"id";s:6:"status";s:6:"status";s:4:"date";s:4:"date";}s:13:"fieldMappings";a:3:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:6:"status";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:6:"status";s:10:"columnName";s:6:"status";}s:4:"date";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:4:"date";s:10:"columnName";s:4:"date";}}s:10:"fieldNames";a:3:{s:2:"id";s:2:"id";s:6:"status";s:6:"status";s:4:"date";s:4:"date";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:44:"App\Entity\Constellation\UserChallengeStatus";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:2:{s:4:"name";s:19:"UserChallengeStatus";s:6:"quoted";b:1;}s:14:"rootEntityName";s:44:"App\Entity\Constellation\UserChallengeStatus";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;}
154 1.47 ms default EXEC
155 1.47 ms default SETEX nanomonx_dev_f5fed644e6ab12aed74c9be0fd49ea6b 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:"en-CA";s:24:"_csrf/https-authenticate";s:43:"Nir93XCpzj4Vz3pfplHaNzaEka2V5iZmt-gehcTBE7c";s:7:"country";s:2:"US";s:18:"is_default_country";b:0;}_sf2_meta|a:3:{s:1:"u";i:1768954833;s:1:"c";i:1768954832;s:1:"l";i:604800;}