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

Response
200 OK
IP
216.73.216.23
Profiled on
Token
1f27b1

Commands

201 Queries
86.45 ms Query time
0 Failed Queries
# Time Connection Command
1 0.01 ms default MULTI 2
2 0.01 ms default SETEX 4GCzUd17WO: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;}}
3 0.78 ms default EXEC
4 0.68 ms default MGET 4GCzUd17WO:App__Entity__Constellation__ReadingTemplateWorld__CLASSMETADATA__
5 0.01 ms default MULTI 2
6 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Constellation_World_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
7 0.62 ms default EXEC
8 0.60 ms default MGET 4GCzUd17WO:App_Entity_Constellation_ReadingTemplateWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA
9 0.01 ms default MULTI 2
10 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Constellation_ReadingTemplateWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
11 0.56 ms default EXEC
12 0.58 ms default MGET 4GCzUd17WO:App__Entity__Constellation__ReadingTemplateWorld__CLASSMETADATA__
13 0.01 ms default MULTI 2
14 0.01 ms default SETEX 4GCzUd17WO: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;}
15 0.02 ms default SETEX 4GCzUd17WO: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;}
16 0.94 ms default EXEC
17 0.66 ms default MGET 4GCzUd17WO:App__Entity__Constellation__StudentWorld__CLASSMETADATA__
18 0.52 ms default MGET 4GCzUd17WO:App_Entity_Constellation_StudentWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA
19 0.01 ms default MULTI 2
20 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Constellation_StudentWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
21 0.69 ms default EXEC
22 0.56 ms default MGET 4GCzUd17WO:App__Entity__Constellation__StudentWorld__CLASSMETADATA__
23 0.01 ms default MULTI 2
24 0.01 ms default SETEX 4GCzUd17WO: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;}
25 0.88 ms default EXEC
26 0.71 ms default MGET 4GCzUd17WO:App__Entity__Constellation__SubWorld__CLASSMETADATA__
27 0.84 ms default MGET 4GCzUd17WO:App_Entity_Constellation_SubWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA
28 0.01 ms default MULTI 2
29 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Constellation_SubWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
30 0.84 ms default EXEC
31 0.71 ms default MGET 4GCzUd17WO:App__Entity__Constellation__SubWorld__CLASSMETADATA__
32 0.01 ms default MULTI 2
33 0.02 ms default SETEX 4GCzUd17WO: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;}
34 0.92 ms default EXEC
35 0.76 ms default MGET 4GCzUd17WO:App__Entity__Constellation__UserChallenge__CLASSMETADATA__
36 0.66 ms default MGET 4GCzUd17WO:App_Entity_Constellation_UserChallenge_$GEDMO_TRANSLATABLE_CLASSMETADATA
37 0.01 ms default MULTI 2
38 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Constellation_UserChallenge_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
39 0.73 ms default EXEC
40 0.63 ms default MGET 4GCzUd17WO:App__Entity__Constellation__UserChallenge__CLASSMETADATA__
41 0.01 ms default MULTI 2
42 0.02 ms default SETEX 4GCzUd17WO: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";}}}
43 0.88 ms default EXEC
44 0.67 ms default MGET 4GCzUd17WO:App__Entity__Constellation__Theme__CLASSMETADATA__
45 0.60 ms default MGET 4GCzUd17WO:App_Entity_Constellation_Theme_$GEDMO_TRANSLATABLE_CLASSMETADATA
46 0.01 ms default MULTI 2
47 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Constellation_Theme_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
48 0.59 ms default EXEC
49 0.70 ms default MGET 4GCzUd17WO:App__Entity__Constellation__Theme__CLASSMETADATA__
50 0.01 ms default MULTI 2
51 0.01 ms default SETEX 4GCzUd17WO:App__Entity__Constellation__Theme__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:1:{s:18:"theme_translations";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:18:"theme_translations";s:12:"sourceEntity";s:30:"App\Entity\Constellation\Theme";s:12:"targetEntity";s:47:"App\Entity\Constellation\ThemeRegionTranslation";s:5:"fetch";i:2;s:8:"mappedBy";s:5:"theme";}}s:11:"columnNames";a:6:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:13:"is_historical";s:13:"is_historical";s:22:"is_forDefaultChallenge";s:22:"is_forDefaultChallenge";s:12:"translations";s:12:"translations";s:9:"client_id";s:9:"client_id";}s:13:"fieldMappings";a:6:{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:68;}s:13:"is_historical";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:13:"is_historical";s:10:"columnName";s:13:"is_historical";s:8:"nullable";b:1;}s:22:"is_forDefaultChallenge";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:22:"is_forDefaultChallenge";s:10:"columnName";s:22:"is_forDefaultChallenge";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:9:"client_id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:9:"client_id";s:10:"columnName";s:9:"client_id";s:8:"nullable";b:1;}}s:10:"fieldNames";a:6:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:13:"is_historical";s:13:"is_historical";s:22:"is_forDefaultChallenge";s:22:"is_forDefaultChallenge";s:12:"translations";s:12:"translations";s:9:"client_id";s:9:"client_id";}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\Theme";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:3:{s:4:"name";s:5:"Theme";s:6:"quoted";b:1;s:17:"uniqueConstraints";a:1:{s:10:"search_idx";a:1:{s:7:"columns";a:1:{i:0;s:9:"client_id";}}}}s:14:"rootEntityName";s:30:"App\Entity\Constellation\Theme";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;}
52 0.99 ms default EXEC
53 0.60 ms default MGET XVNmqgbvR9:5575ed236b054ea2524b8a624056f86d
54 0.01 ms default MULTI 2
55 0.02 ms default SETEX XVNmqgbvR9: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:{}}
56 0.87 ms default EXEC
57 0.61 ms default MGET 4GCzUd17WO:App__Entity__Constellation__ThemeRegionTranslation__CLASSMETADATA__
58 0.60 ms default MGET 4GCzUd17WO:App_Entity_Constellation_ThemeRegionTranslation_$GEDMO_TRANSLATABLE_CLASSMETADATA
59 0.01 ms default MULTI 2
60 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Constellation_ThemeRegionTranslation_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
61 0.59 ms default EXEC
62 0.59 ms default MGET 4GCzUd17WO:App__Entity__Constellation__ThemeRegionTranslation__CLASSMETADATA__
63 0.01 ms default MULTI 2
64 0.01 ms default SETEX 4GCzUd17WO:App__Entity__Constellation__ThemeRegionTranslation__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:2:{s:11:"user_region";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:11:"user_region";s:12:"sourceEntity";s:47:"App\Entity\Constellation\ThemeRegionTranslation";s:12:"targetEntity";s:21:"App\Entity\UserRegion";s:5:"fetch";i:2;s:10:"inversedBy";s:18:"theme_translations";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:14:"user_region_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:"user_region_id";s:14:"user_region_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:14:"user_region_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:14:"user_region_id";}}s:5:"theme";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:5:"theme";s:12:"sourceEntity";s:47:"App\Entity\Constellation\ThemeRegionTranslation";s:12:"targetEntity";s:30:"App\Entity\Constellation\Theme";s:5:"fetch";i:2;s:10:"inversedBy";s:18:"theme_translations";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"theme_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:"theme_id";s:8:"theme_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"theme_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"theme_id";}}}s:11:"columnNames";a:2:{s:2:"id";s:2:"id";s:12:"translations";s:12:"translations";}s:13:"fieldMappings";a:2:{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:"translations";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"json";s:9:"fieldName";s:12:"translations";s:10:"columnName";s:12:"translations";s:6:"quoted";b:1;}}s:10:"fieldNames";a:2:{s:2:"id";s:2:"id";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:47:"App\Entity\Constellation\ThemeRegionTranslation";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:2:{s:4:"name";s:22:"ThemeRegionTranslation";s:6:"quoted";b:1;}s:14:"rootEntityName";s:47:"App\Entity\Constellation\ThemeRegionTranslation";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;}}
65 0.87 ms default EXEC
66 0.71 ms default MGET g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_2__translations
67 0.70 ms default MGET g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_2 g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_6
68 0.63 ms default MGET g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_3__translations
69 0.90 ms default MGET g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_3 g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_4
70 0.49 ms default MGET 4GCzUd17WO:App__Entity__Purchases__Package__CLASSMETADATA__
71 0.53 ms default MGET 4GCzUd17WO:App_Entity_Purchases_Package_$GEDMO_TRANSLATABLE_CLASSMETADATA
72 0.01 ms default MULTI 2
73 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Purchases_Package_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:3:{s:6:"fields";a:1:{i:0;s:4:"name";}s:6:"locale";s:6:"locale";s:14:"useObjectClass";s:28:"App\Entity\Purchases\Package";}
74 0.48 ms default EXEC
75 0.72 ms default MGET 4GCzUd17WO:App__Entity__Purchases__Package__CLASSMETADATA__
76 0.01 ms default MULTI 2
77 0.01 ms default SETEX 4GCzUd17WO:App__Entity__Purchases__Package__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:2:{s:21:"package_subscriptions";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:21:"package_subscriptions";s:12:"sourceEntity";s:28:"App\Entity\Purchases\Package";s:12:"targetEntity";s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:5:"fetch";i:2;s:8:"mappedBy";s:7:"package";}s:6:"prices";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":8:{s:9:"fieldName";s:6:"prices";s:12:"sourceEntity";s:28:"App\Entity\Purchases\Package";s:12:"targetEntity";s:26:"App\Entity\Purchases\Price";s:7:"cascade";a:2:{i:0;s:7:"persist";i:1;s:6:"remove";}s:5:"fetch";i:2;s:5:"cache";a:2:{s:5:"usage";i:2;s:6:"region";s:8:"nanomonx";}s:13:"orphanRemoval";b:1;s:8:"mappedBy";s:7:"package";}}s:11:"columnNames";a:5:{s:2:"id";s:2:"id";s:4:"type";s:4:"type";s:9:"zoho_name";s:9:"zoho_name";s:17:"stripe_product_id";s:17:"stripe_product_id";s:4:"name";s:4:"name";}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:"type";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"type";s:10:"columnName";s:4:"type";s:6:"unique";b:1;s:8:"enumType";s:32:"App\Entity\Purchases\PackageType";}s:9:"zoho_name";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:9:"zoho_name";s:10:"columnName";s:9:"zoho_name";s:8:"nullable";b:1;}s:17:"stripe_product_id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:17:"stripe_product_id";s:10:"columnName";s:17:"stripe_product_id";s:8:"nullable";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:8:"nullable";b:1;}}s:10:"fieldNames";a:5:{s:2:"id";s:2:"id";s:4:"type";s:4:"type";s:9:"zoho_name";s:9:"zoho_name";s:17:"stripe_product_id";s:17:"stripe_product_id";s:4:"name";s:4:"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:28:"App\Entity\Purchases\Package";s:9:"namespace";s:20:"App\Entity\Purchases";s:5:"table";a:1:{s:4:"name";s:7:"Package";}s:14:"rootEntityName";s:28:"App\Entity\Purchases\Package";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:32:"App\Repository\PackageRepository";s:13:"generatorType";i:4;s:5:"cache";a:2:{s:6:"region";s:8:"nanomonx";s:5:"usage";i:2;}}
78 0.61 ms default EXEC
79 0.67 ms default MGET 4GCzUd17WO:App__Entity__Purchases__GroupLicence__CLASSMETADATA__
80 0.50 ms default MGET 4GCzUd17WO:App_Entity_Purchases_GroupLicence_$GEDMO_TRANSLATABLE_CLASSMETADATA
81 0.01 ms default MULTI 2
82 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Purchases_GroupLicence_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
83 0.46 ms default EXEC
84 4.55 ms default MGET 4GCzUd17WO:App__Entity__Purchases__GroupLicence__CLASSMETADATA__
85 0.01 ms default MULTI 2
86 0.02 ms default SETEX 4GCzUd17WO:App__Entity__Purchases__GroupLicence__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:4:{s:5:"buyer";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:5:"buyer";s:12:"sourceEntity";s:33:"App\Entity\Purchases\GroupLicence";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:18:"purchased_licences";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"buyer_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:"buyer_id";s:8:"buyer_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"buyer_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"buyer_id";}}s:5:"owner";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:5:"owner";s:12:"sourceEntity";s:33:"App\Entity\Purchases\GroupLicence";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:14:"owned_licences";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"owner_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:"owner_id";s:8:"owner_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"owner_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"owner_id";}}s:12:"current_user";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:12:"current_user";s:12:"sourceEntity";s:33:"App\Entity\Purchases\GroupLicence";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:14:"group_licences";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:15:"current_user_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:15:"current_user_id";s:15:"current_user_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:15:"current_user_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:15:"current_user_id";}}s:4:"type";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:4:"type";s:12:"sourceEntity";s:33:"App\Entity\Purchases\GroupLicence";s:12:"targetEntity";s:32:"App\Entity\Purchases\LicenceType";s:5:"fetch";i:2;s:10:"inversedBy";s:14:"group_licences";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:7:"type_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:7:"type_id";s:7:"type_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:7:"type_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:7:"type_id";}}}s:11:"columnNames";a:4:{s:2:"id";s:2:"id";s:10:"created_at";s:10:"created_at";s:10:"expired_at";s:10:"expired_at";s:19:"free_trial_duration";s:19:"free_trial_duration";}s:13:"fieldMappings";a:4:{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:"created_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"created_at";s:10:"columnName";s:10:"created_at";}s:10:"expired_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"expired_at";s:10:"columnName";s:10:"expired_at";s:8:"nullable";b:1;}s:19:"free_trial_duration";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:19:"free_trial_duration";s:10:"columnName";s:19:"free_trial_duration";s:8:"nullable";b:1;}}s:10:"fieldNames";a:4:{s:2:"id";s:2:"id";s:10:"created_at";s:10:"created_at";s:10:"expired_at";s:10:"expired_at";s:19:"free_trial_duration";s:19:"free_trial_duration";}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\Purchases\GroupLicence";s:9:"namespace";s:20:"App\Entity\Purchases";s:5:"table";a:2:{s:4:"name";s:12:"GroupLicence";s:6:"quoted";b:1;}s:14:"rootEntityName";s:33:"App\Entity\Purchases\GroupLicence";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:37:"App\Repository\GroupLicenceRepository";s:13:"generatorType";i:4;}
87 0.60 ms default EXEC
88 0.44 ms default MGET 4GCzUd17WO:App__Entity__Purchases__Subscriptions__PackageSubscription__CLASSMETADATA__
89 12.68 ms default MGET 4GCzUd17WO:App_Entity_Purchases_Subscriptions_Subscription_$GEDMO_TRANSLATABLE_CLASSMETADATA
90 0.01 ms default MULTI 2
91 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Purchases_Subscriptions_Subscription_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
92 0.50 ms default EXEC
93 0.49 ms default MGET 4GCzUd17WO:App_Entity_Purchases_Subscriptions_PackageSubscription_$GEDMO_TRANSLATABLE_CLASSMETADATA
94 0.01 ms default MULTI 2
95 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Purchases_Subscriptions_PackageSubscription_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
96 0.47 ms default EXEC
97 0.44 ms default MGET 4GCzUd17WO:App__Entity__Purchases__Subscriptions__Subscription__CLASSMETADATA__ 4GCzUd17WO:App__Entity__Purchases__Subscriptions__PackageSubscription__CLASSMETADATA__
98 0.01 ms default MULTI 2
99 0.02 ms default SETEX 4GCzUd17WO:App__Entity__Purchases__Subscriptions__Subscription__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":21:{s:19:"associationMappings";a:3:{s:5:"owner";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:5:"owner";s:12:"sourceEntity";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:19:"owned_subscriptions";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"owner_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:"owner_id";s:8:"owner_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"owner_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"owner_id";}}s:12:"current_user";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:12:"current_user";s:12:"sourceEntity";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:13:"subscriptions";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:15:"current_user_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:15:"current_user_id";s:15:"current_user_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:15:"current_user_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:15:"current_user_id";}}s:10:"redeemCode";O:47:"Doctrine\ORM\Mapping\OneToOneInverseSideMapping":5:{s:9:"fieldName";s:10:"redeemCode";s:12:"sourceEntity";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:12:"targetEntity";s:39:"App\Entity\SubscriptionDealing\BaseCode";s:5:"fetch";i:2;s:8:"mappedBy";s:12:"subscription";}}s:11:"columnNames";a:3:{s:2:"id";s:2:"id";s:10:"created_at";s:10:"created_at";s:10:"updated_at";s:10:"updated_at";}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:10:"created_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"created_at";s:10:"columnName";s:10:"created_at";}s:10:"updated_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"updated_at";s:10:"columnName";s:10:"updated_at";s:8:"nullable";b:1;}}s:10:"fieldNames";a:3:{s:2:"id";s:2:"id";s:10:"created_at";s:10:"created_at";s:10:"updated_at";s:10:"updated_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:47:"App\Entity\Purchases\Subscriptions\Subscription";s:9:"namespace";s:34:"App\Entity\Purchases\Subscriptions";s:5:"table";a:1:{s:4:"name";s:17:"Subscription_Base";}s:14:"rootEntityName";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:37:"App\Repository\SubscriptionRepository";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:4:{s:6:"custom";s:53:"App\Entity\Purchases\Subscriptions\CustomSubscription";s:7:"package";s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:10:"free_trial";s:56:"App\Entity\Purchases\Subscriptions\FreeTrialSubscription";s:9:"recurring";s:56:"App\Entity\Purchases\Subscriptions\RecurringSubscription";}s:13:"parentClasses";a:0:{}s:10:"subClasses";a:4:{i:0;s:53:"App\Entity\Purchases\Subscriptions\CustomSubscription";i:1;s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";i:2;s:56:"App\Entity\Purchases\Subscriptions\FreeTrialSubscription";i:3;s:56:"App\Entity\Purchases\Subscriptions\RecurringSubscription";}s:13:"generatorType";i:4;s:18:"lifecycleCallbacks";a:1:{s:9:"preUpdate";a:1:{i:0;s:10:"setUpdated";}}}
100 0.02 ms default SETEX 4GCzUd17WO:App__Entity__Purchases__Subscriptions__PackageSubscription__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":21:{s:19:"associationMappings";a:6:{s:5:"owner";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":11:{s:9:"fieldName";s:5:"owner";s:12:"sourceEntity";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:9:"inherited";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"declared";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:10:"inversedBy";s:19:"owned_subscriptions";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"owner_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:"owner_id";s:8:"owner_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"owner_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"owner_id";}}s:12:"current_user";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":11:{s:9:"fieldName";s:12:"current_user";s:12:"sourceEntity";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:9:"inherited";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"declared";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:10:"inversedBy";s:13:"subscriptions";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:15:"current_user_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:15:"current_user_id";s:15:"current_user_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:15:"current_user_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:15:"current_user_id";}}s:10:"redeemCode";O:47:"Doctrine\ORM\Mapping\OneToOneInverseSideMapping":7:{s:9:"fieldName";s:10:"redeemCode";s:12:"sourceEntity";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:12:"targetEntity";s:39:"App\Entity\SubscriptionDealing\BaseCode";s:5:"fetch";i:2;s:9:"inherited";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"declared";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"mappedBy";s:12:"subscription";}s:7:"package";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":10:{s:9:"fieldName";s:7:"package";s:12:"sourceEntity";s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:12:"targetEntity";s:28:"App\Entity\Purchases\Package";s:5:"fetch";i:2;s:5:"cache";a:2:{s:5:"usage";i:2;s:6:"region";s:8:"nanomonx";}s:10:"inversedBy";s:21:"package_subscriptions";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:7:"type_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:7:"type_id";s:7:"type_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:7:"type_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:7:"type_id";}}s:5:"buyer";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:5:"buyer";s:12:"sourceEntity";s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:23:"purchased_subscriptions";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"buyer_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:"buyer_id";s:8:"buyer_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"buyer_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"buyer_id";}}s:7:"country";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:7:"country";s:12:"sourceEntity";s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:12:"targetEntity";s:18:"App\Entity\Country";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:10:"country_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:"country_id";s:10:"country_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:10:"country_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:10:"country_id";}}}s:11:"columnNames";a:3:{s:2:"id";s:2:"id";s:10:"created_at";s:10:"created_at";s:10:"updated_at";s:10:"updated_at";}s:13:"fieldMappings";a:3:{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:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"declared";s:47:"App\Entity\Purchases\Subscriptions\Subscription";}s:10:"created_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"created_at";s:10:"columnName";s:10:"created_at";s:9:"inherited";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"declared";s:47:"App\Entity\Purchases\Subscriptions\Subscription";}s:10:"updated_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"updated_at";s:10:"columnName";s:10:"updated_at";s:8:"nullable";b:1;s:9:"inherited";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"declared";s:47:"App\Entity\Purchases\Subscriptions\Subscription";}}s:10:"fieldNames";a:3:{s:2:"id";s:2:"id";s:10:"created_at";s:10:"created_at";s:10:"updated_at";s:10:"updated_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:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:9:"namespace";s:34:"App\Entity\Purchases\Subscriptions";s:5:"table";a:1:{s:4:"name";s:20:"Subscription_Package";}s:14:"rootEntityName";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:37:"App\Repository\SubscriptionRepository";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:7:"package";s:16:"discriminatorMap";a:4:{s:6:"custom";s:53:"App\Entity\Purchases\Subscriptions\CustomSubscription";s:7:"package";s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:10:"free_trial";s:56:"App\Entity\Purchases\Subscriptions\FreeTrialSubscription";s:9:"recurring";s:56:"App\Entity\Purchases\Subscriptions\RecurringSubscription";}s:13:"parentClasses";a:1:{i:0;s:47:"App\Entity\Purchases\Subscriptions\Subscription";}s:10:"subClasses";a:0:{}s:13:"generatorType";i:4;s:18:"lifecycleCallbacks";a:1:{s:9:"preUpdate";a:1:{i:0;s:10:"setUpdated";}}}
101 0.71 ms default EXEC
102 0.51 ms default MGET 4GCzUd17WO:App__Entity__WhiteListedDomain__CLASSMETADATA__
103 0.47 ms default MGET 4GCzUd17WO:App_Entity_WhiteListedDomain_$GEDMO_TRANSLATABLE_CLASSMETADATA
104 0.01 ms default MULTI 2
105 0.01 ms default SETEX 4GCzUd17WO:App_Entity_WhiteListedDomain_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
106 0.43 ms default EXEC
107 0.46 ms default MGET 4GCzUd17WO:App__Entity__WhiteListedDomain__CLASSMETADATA__
108 0.01 ms default MULTI 2
109 0.01 ms default SETEX 4GCzUd17WO:App__Entity__WhiteListedDomain__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:2:{s:7:"manager";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:7:"manager";s:12:"sourceEntity";s:28:"App\Entity\WhiteListedDomain";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:20:"white_listed_domains";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:0;}}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:10:"domainName";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:10:"domainName";s:12:"sourceEntity";s:28:"App\Entity\WhiteListedDomain";s:12:"targetEntity";s:21:"App\Entity\DomainName";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:9:"domain_id";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:9:"domain_id";s:9:"domain_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:9:"domain_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:9:"domain_id";}}}s:11:"columnNames";a:2:{s:2:"id";s:2:"id";s:10:"date_added";s:10:"date_added";}s:13:"fieldMappings";a:2:{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:"date_added";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"date_added";s:10:"columnName";s:10:"date_added";}}s:10:"fieldNames";a:2:{s:2:"id";s:2:"id";s:10:"date_added";s:10:"date_added";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:28:"App\Entity\WhiteListedDomain";s:9:"namespace";s:10:"App\Entity";s:5:"table";a:2:{s:4:"name";s:17:"WhiteListedDomain";s:6:"quoted";b:1;}s:14:"rootEntityName";s:28:"App\Entity\WhiteListedDomain";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;}}
110 0.57 ms default EXEC
111 0.43 ms default MGET 4GCzUd17WO:App__Entity__WhiteListedUser__CLASSMETADATA__
112 0.41 ms default MGET 4GCzUd17WO:App_Entity_WhiteListedUser_$GEDMO_TRANSLATABLE_CLASSMETADATA
113 0.01 ms default MULTI 2
114 0.01 ms default SETEX 4GCzUd17WO:App_Entity_WhiteListedUser_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
115 0.38 ms default EXEC
116 0.39 ms default MGET 4GCzUd17WO:App__Entity__WhiteListedUser__CLASSMETADATA__
117 0.01 ms default MULTI 2
118 0.01 ms default SETEX 4GCzUd17WO:App__Entity__WhiteListedUser__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:2:{s:7:"manager";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:7:"manager";s:12:"sourceEntity";s:26:"App\Entity\WhiteListedUser";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:18:"white_listed_users";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:0;}}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:"attached_user";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:13:"attached_user";s:12:"sourceEntity";s:26:"App\Entity\WhiteListedUser";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:16:"attached_user_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:"attached_user_id";s:16:"attached_user_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:16:"attached_user_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:16:"attached_user_id";}}}s:11:"columnNames";a:5:{s:2:"id";s:2:"id";s:8:"username";s:8:"username";s:10:"date_added";s:10:"date_added";s:13:"date_attached";s:13:"date_attached";s:6:"status";s:6:"status";}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:8:"username";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:8:"username";s:10:"columnName";s:8:"username";}s:10:"date_added";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"date_added";s:10:"columnName";s:10:"date_added";}s:13:"date_attached";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:13:"date_attached";s:10:"columnName";s:13:"date_attached";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:10:"fieldNames";a:5:{s:2:"id";s:2:"id";s:8:"username";s:8:"username";s:10:"date_added";s:10:"date_added";s:13:"date_attached";s:13:"date_attached";s:6:"status";s:6:"status";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:26:"App\Entity\WhiteListedUser";s:9:"namespace";s:10:"App\Entity";s:5:"table";a:2:{s:4:"name";s:15:"WhiteListedUser";s:6:"quoted";b:1;}s:14:"rootEntityName";s:26:"App\Entity\WhiteListedUser";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;}
119 0.47 ms default EXEC
120 0.39 ms default MGET 4GCzUd17WO:App__Entity__SchoolYear__CLASSMETADATA__
121 0.40 ms default MGET 4GCzUd17WO:App_Entity_SchoolYear_$GEDMO_TRANSLATABLE_CLASSMETADATA
122 0.01 ms default MULTI 2
123 0.01 ms default SETEX 4GCzUd17WO:App_Entity_SchoolYear_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
124 0.38 ms default EXEC
125 0.37 ms default MGET 4GCzUd17WO:App__Entity__SchoolYear__CLASSMETADATA__
126 0.01 ms default MULTI 2
127 0.02 ms default SETEX 4GCzUd17WO:App__Entity__SchoolYear__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:2:{s:13:"licence_types";O:48:"Doctrine\ORM\Mapping\ManyToManyOwningSideMapping":9:{s:9:"fieldName";s:13:"licence_types";s:12:"sourceEntity";s:21:"App\Entity\SchoolYear";s:12:"targetEntity";s:32:"App\Entity\Purchases\LicenceType";s:5:"fetch";i:2;s:10:"inversedBy";s:12:"school_years";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:14:"school_year_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:15:"licence_type_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:24:"schoolYears_licenceTypes";s:7:"options";a:0:{}}s:16:"joinTableColumns";a:2:{i:0;s:14:"school_year_id";i:1;s:15:"licence_type_id";}s:26:"relationToSourceKeyColumns";a:1:{s:14:"school_year_id";s:2:"id";}s:26:"relationToTargetKeyColumns";a:1:{s:15:"licence_type_id";s:2:"id";}}s:8:"managers";O:48:"Doctrine\ORM\Mapping\ManyToManyOwningSideMapping":9:{s:9:"fieldName";s:8:"managers";s:12:"sourceEntity";s:21:"App\Entity\SchoolYear";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:12:"school_years";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:14:"school_year_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:"manager_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:20:"schoolYears_managers";s:7:"options";a:0:{}}s:16:"joinTableColumns";a:2:{i:0;s:14:"school_year_id";i:1;s:10:"manager_id";}s:26:"relationToSourceKeyColumns";a:1:{s:14:"school_year_id";s:2:"id";}s:26:"relationToTargetKeyColumns";a:1:{s:10:"manager_id";s:2:"id";}}}s:11:"columnNames";a:6:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:9:"zoho_name";s:9:"zoho_name";s:21:"default_starting_date";s:21:"default_starting_date";s:19:"default_ending_date";s:19:"default_ending_date";s:12:"translations";s:12:"translations";}s:13:"fieldMappings";a:6:{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: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:21:"default_starting_date";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:21:"default_starting_date";s:10:"columnName";s:21:"default_starting_date";}s:19:"default_ending_date";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:19:"default_ending_date";s:10:"columnName";s:19:"default_ending_date";}s:12:"translations";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"json";s:9:"fieldName";s:12:"translations";s:10:"columnName";s:12:"translations";s:6:"quoted";b:1;}}s:10:"fieldNames";a:6:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:9:"zoho_name";s:9:"zoho_name";s:21:"default_starting_date";s:21:"default_starting_date";s:19:"default_ending_date";s:19:"default_ending_date";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:21:"App\Entity\SchoolYear";s:9:"namespace";s:10:"App\Entity";s:5:"table";a:2:{s:4:"name";s:10:"SchoolYear";s:6:"quoted";b:1;}s:14:"rootEntityName";s:21:"App\Entity\SchoolYear";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;}}
128 0.50 ms default EXEC
129 0.42 ms default MGET 4GCzUd17WO:App__Entity__UsageType__CLASSMETADATA__
130 1.08 ms default MGET 4GCzUd17WO:App_Entity_UsageType_$GEDMO_TRANSLATABLE_CLASSMETADATA
131 0.01 ms default MULTI 2
132 0.01 ms default SETEX 4GCzUd17WO:App_Entity_UsageType_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
133 0.39 ms default EXEC
134 0.38 ms default MGET 4GCzUd17WO:App__Entity__UsageType__CLASSMETADATA__
135 0.01 ms default MULTI 2
136 0.01 ms default SETEX 4GCzUd17WO:App__Entity__UsageType__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:2:{s:8:"managers";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:8:"managers";s:12:"sourceEntity";s:20:"App\Entity\UsageType";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:8:"mappedBy";s:10:"usage_type";}s:12:"manager_type";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:12:"manager_type";s:12:"sourceEntity";s:20:"App\Entity\UsageType";s:12:"targetEntity";s:22:"App\Entity\ManagerType";s:5:"fetch";i:2;s:10:"inversedBy";s:11:"usage_types";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:15:"manager_type_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:15:"manager_type_id";s:15:"manager_type_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:15:"manager_type_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:15:"manager_type_id";}}}s:11:"columnNames";a:4:{s:2:"id";s:2:"id";s:9:"zoho_name";s:9:"zoho_name";s:12:"translations";s:12:"translations";s:13:"display_order";s:13:"display_order";}s:13:"fieldMappings";a:4:{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: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:12:"translations";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"json";s:9:"fieldName";s:12:"translations";s:10:"columnName";s:12:"translations";s:6:"quoted";b:1;}s:13:"display_order";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"integer";s:9:"fieldName";s:13:"display_order";s:10:"columnName";s:13:"display_order";}}s:10:"fieldNames";a:4:{s:2:"id";s:2:"id";s:9:"zoho_name";s:9:"zoho_name";s:12:"translations";s:12:"translations";s:13:"display_order";s:13:"display_order";}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\UsageType";s:9:"namespace";s:10:"App\Entity";s:5:"table";a:2:{s:4:"name";s:9:"UsageType";s:6:"quoted";b:1;}s:14:"rootEntityName";s:20:"App\Entity\UsageType";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;}}
137 0.68 ms default EXEC
138 1.12 ms default MGET 4GCzUd17WO:App__Entity__UsernameChange__CLASSMETADATA__
139 0.89 ms default MGET 4GCzUd17WO:App_Entity_UsernameChange_$GEDMO_TRANSLATABLE_CLASSMETADATA
140 0.07 ms default MULTI 2
141 0.01 ms default SETEX 4GCzUd17WO:App_Entity_UsernameChange_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
142 0.40 ms default EXEC
143 0.45 ms default MGET 4GCzUd17WO:App__Entity__UsernameChange__CLASSMETADATA__
144 0.01 ms default MULTI 2
145 0.02 ms default SETEX 4GCzUd17WO:App__Entity__UsernameChange__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:1:{s:4:"user";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:4:"user";s:12:"sourceEntity";s:25:"App\Entity\UsernameChange";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:16:"username_changes";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:7:"user_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:7:"user_id";s:7:"user_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:7:"user_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:7:"user_id";}}}s:11:"columnNames";a:7:{s:2:"id";s:2:"id";s:17:"previous_username";s:17:"previous_username";s:12:"new_username";s:12:"new_username";s:8:"is_valid";s:8:"is_valid";s:4:"date";s:4:"date";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:17:"previous_username";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:17:"previous_username";s:10:"columnName";s:17:"previous_username";s:6:"length";i:100;}s:12:"new_username";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:12:"new_username";s:10:"columnName";s:12:"new_username";s:6:"length";i:100;}s:8:"is_valid";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:8:"is_valid";s:10:"columnName";s:8:"is_valid";s:7:"options";a:1:{s:7:"default";b:0;}}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: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:17:"previous_username";s:17:"previous_username";s:12:"new_username";s:12:"new_username";s:8:"is_valid";s:8:"is_valid";s:4:"date";s:4:"date";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:25:"App\Entity\UsernameChange";s:9:"namespace";s:10:"App\Entity";s:5:"table";a:2:{s:4:"name";s:14:"UsernameChange";s:6:"quoted";b:1;}s:14:"rootEntityName";s:25:"App\Entity\UsernameChange";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;}}
146 0.49 ms default EXEC
147 0.42 ms default MGET 4GCzUd17WO:App__Entity__Troubadour__Babillard__BabillardCollaboration__CLASSMETADATA__
148 0.43 ms default MGET 4GCzUd17WO:App_Entity_Troubadour_Babillard_BabillardCollaboration_$GEDMO_TRANSLATABLE_CLASSMETADATA
149 0.01 ms default MULTI 2
150 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Troubadour_Babillard_BabillardCollaboration_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
151 0.38 ms default EXEC
152 0.45 ms default MGET 4GCzUd17WO:App__Entity__Troubadour__Babillard__BabillardCollaboration__CLASSMETADATA__
153 0.01 ms default MULTI 2
154 0.01 ms default SETEX 4GCzUd17WO:App__Entity__Troubadour__Babillard__BabillardCollaboration__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:3:{s:9:"babillard";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:9:"babillard";s:12:"sourceEntity";s:54:"App\Entity\Troubadour\Babillard\BabillardCollaboration";s:12:"targetEntity";s:41:"App\Entity\Troubadour\Babillard\Babillard";s:5:"fetch";i:2;s:10:"inversedBy";s:14:"collaborations";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":2:{s:4:"name";s:12:"babillard_id";s:20:"referencedColumnName";s:2:"id";}}s:20:"joinColumnFieldNames";a:1:{s:12:"babillard_id";s:12:"babillard_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:12:"babillard_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:12:"babillard_id";}}s:7:"manager";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":10:{s:9:"fieldName";s:7:"manager";s:12:"sourceEntity";s:54:"App\Entity\Troubadour\Babillard\BabillardCollaboration";s:12:"targetEntity";s:18:"App\Entity\Manager";s:7:"cascade";a:1:{i:0;s:7:"persist";}s:5:"fetch";i:2;s:10:"inversedBy";s:23:"babillardCollaborations";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":2:{s:4:"name";s:10:"manager_id";s:20:"referencedColumnName";s:2:"id";}}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:14:"pendingAccount";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":10:{s:9:"fieldName";s:14:"pendingAccount";s:12:"sourceEntity";s:54:"App\Entity\Troubadour\Babillard\BabillardCollaboration";s:12:"targetEntity";s:25:"App\Entity\PendingAccount";s:7:"cascade";a:1:{i:0;s:7:"persist";}s:5:"fetch";i:2;s:10:"inversedBy";s:23:"babillardCollaborations";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":2:{s:4:"name";s:18:"pending_account_id";s:20:"referencedColumnName";s:2:"id";}}s:20:"joinColumnFieldNames";a:1:{s:18:"pending_account_id";s:18:"pending_account_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:18:"pending_account_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:18:"pending_account_id";}}}s:11:"columnNames";a:4:{s:2:"id";s:2:"id";s:6:"status";s:6:"status";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:13:"fieldMappings";a:4:{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":5:{s:4:"type";s:4:"enum";s:9:"fieldName";s:6:"status";s:10:"columnName";s:6:"status";s:8:"enumType";s:60:"App\Entity\Troubadour\Babillard\BabillardCollaborationStatus";s:7:"options";a:1:{s:6:"values";a:4:{i:0;s:7:"PENDING";i:1;s:8:"ACCEPTED";i:2;s:8:"REJECTED";i:3;s:9:"CANCELLED";}}}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:4:{s:2:"id";s:2:"id";s:6:"status";s:6:"status";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:54:"App\Entity\Troubadour\Babillard\BabillardCollaboration";s:9:"namespace";s:31:"App\Entity\Troubadour\Babillard";s:5:"table";a:2:{s:4:"name";s:28:"troub_BabillardCollaboration";s:6:"quoted";b:1;}s:14:"rootEntityName";s:54:"App\Entity\Troubadour\Babillard\BabillardCollaboration";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:58:"App\Repository\Troubadour\BabillardCollaborationRepository";s:13:"generatorType";i:4;}
155 0.50 ms default EXEC
156 0.43 ms default MGET 4GCzUd17WO:App__Entity__Zoho__ZohoState__CLASSMETADATA__
157 0.45 ms default MGET 4GCzUd17WO:App_Entity_Zoho_ZohoState_$GEDMO_TRANSLATABLE_CLASSMETADATA
158 0.01 ms default MULTI 2
159 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Zoho_ZohoState_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
160 0.41 ms default EXEC
161 0.45 ms default MGET 4GCzUd17WO:App__Entity__Zoho__ZohoState__CLASSMETADATA__
162 0.01 ms default MULTI 2
163 0.03 ms default SETEX 4GCzUd17WO:App__Entity__Zoho__ZohoState__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:2:{s:7:"manager";O:46:"Doctrine\ORM\Mapping\OneToOneOwningSideMapping":9:{s:9:"fieldName";s:7:"manager";s:12:"sourceEntity";s:25:"App\Entity\Zoho\ZohoState";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:9:"zohoState";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:7:"manager";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:7:"manager";s:7:"manager";}s:24:"sourceToTargetKeyColumns";a:1:{s:7:"manager";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:7:"manager";}}s:14:"pendingAccount";O:46:"Doctrine\ORM\Mapping\OneToOneOwningSideMapping":9:{s:9:"fieldName";s:14:"pendingAccount";s:12:"sourceEntity";s:25:"App\Entity\Zoho\ZohoState";s:12:"targetEntity";s:25:"App\Entity\PendingAccount";s:5:"fetch";i:2;s:10:"inversedBy";s:9:"zohoState";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:15:"pending_account";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:15:"pending_account";s:15:"pending_account";}s:24:"sourceToTargetKeyColumns";a:1:{s:15:"pending_account";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:15:"pending_account";}}}s:11:"columnNames";a:23:{s:2:"id";s:2:"id";s:12:"PLGUserState";s:13:"plguser_state";s:14:"PLGUsageStatus";s:15:"plgusage_status";s:18:"PLGUserStateFamily";s:20:"plguser_state_family";s:20:"PLGUsageStatusFamily";s:22:"plgusage_status_family";s:17:"PLGOnboardingStep";s:18:"plgonboarding_step";s:8:"jobTitle";s:9:"job_title";s:16:"organizationType";s:17:"organization_type";s:8:"province";s:8:"province";s:17:"landingPageOrigin";s:19:"landing_page_origin";s:15:"isDecisionMaker";s:17:"is_decision_maker";s:16:"isTroubadourUser";s:18:"is_troubadour_user";s:19:"subscriptionPending";s:20:"subscription_pending";s:17:"subscriptionsUsed";s:18:"subscriptions_used";s:20:"hasValidSubscription";s:22:"has_valid_subscription";s:10:"isFreemium";s:11:"is_freemium";s:12:"isSchoolUser";s:14:"is_school_user";s:12:"isFamilyUser";s:14:"is_family_user";s:7:"isDirty";s:8:"is_dirty";s:10:"created_at";s:10:"created_at";s:10:"updated_at";s:10:"updated_at";s:19:"usingActivationCode";s:21:"using_activation_code";s:26:"hasValidFamilySubscription";s:29:"has_valid_family_subscription";}s:13:"fieldMappings";a:23:{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:"PLGUserState";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:12:"PLGUserState";s:10:"columnName";s:13:"plguser_state";s:8:"nullable";b:1;s:8:"enumType";s:33:"App\Entity\Zoho\enum\PLGUserState";}s:14:"PLGUsageStatus";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:14:"PLGUsageStatus";s:10:"columnName";s:15:"plgusage_status";s:8:"nullable";b:1;s:8:"enumType";s:35:"App\Entity\Zoho\enum\PLGUsageStatus";}s:18:"PLGUserStateFamily";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:18:"PLGUserStateFamily";s:10:"columnName";s:20:"plguser_state_family";s:8:"nullable";b:1;s:8:"enumType";s:33:"App\Entity\Zoho\enum\PLGUserState";}s:20:"PLGUsageStatusFamily";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:20:"PLGUsageStatusFamily";s:10:"columnName";s:22:"plgusage_status_family";s:8:"nullable";b:1;s:8:"enumType";s:35:"App\Entity\Zoho\enum\PLGUsageStatus";}s:17:"PLGOnboardingStep";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:17:"PLGOnboardingStep";s:10:"columnName";s:18:"plgonboarding_step";s:8:"nullable";b:1;}s:8:"jobTitle";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:8:"jobTitle";s:10:"columnName";s:9:"job_title";s:8:"nullable";b:1;s:8:"enumType";s:29:"App\Entity\Zoho\enum\JobTitle";}s:16:"organizationType";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:16:"organizationType";s:10:"columnName";s:17:"organization_type";s:8:"nullable";b:1;s:8:"enumType";s:37:"App\Entity\Zoho\enum\OrganizationType";}s:8:"province";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:8:"province";s:10:"columnName";s:8:"province";s:8:"nullable";b:1;}s:17:"landingPageOrigin";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:17:"landingPageOrigin";s:10:"columnName";s:19:"landing_page_origin";s:8:"nullable";b:1;}s:15:"isDecisionMaker";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:15:"isDecisionMaker";s:10:"columnName";s:17:"is_decision_maker";s:8:"nullable";b:1;}s:16:"isTroubadourUser";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:16:"isTroubadourUser";s:10:"columnName";s:18:"is_troubadour_user";s:8:"nullable";b:1;}s:19:"subscriptionPending";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:19:"subscriptionPending";s:10:"columnName";s:20:"subscription_pending";s:8:"nullable";b:1;}s:17:"subscriptionsUsed";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"json";s:9:"fieldName";s:17:"subscriptionsUsed";s:10:"columnName";s:18:"subscriptions_used";s:8:"nullable";b:1;}s:20:"hasValidSubscription";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"hasValidSubscription";s:10:"columnName";s:22:"has_valid_subscription";s:8:"nullable";b:1;}s:10:"isFreemium";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:10:"isFreemium";s:10:"columnName";s:11:"is_freemium";s:8:"nullable";b:1;}s:12:"isSchoolUser";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:12:"isSchoolUser";s:10:"columnName";s:14:"is_school_user";s:7:"options";a:1:{s:7:"default";b:1;}}s:12:"isFamilyUser";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:12:"isFamilyUser";s:10:"columnName";s:14:"is_family_user";s:7:"options";a:1:{s:7:"default";b:0;}}s:7:"isDirty";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:7:"isDirty";s:10:"columnName";s:8:"is_dirty";}s:10:"created_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"created_at";s:10:"columnName";s:10:"created_at";}s:10:"updated_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"updated_at";s:10:"columnName";s:10:"updated_at";}s:19:"usingActivationCode";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:19:"usingActivationCode";s:10:"columnName";s:21:"using_activation_code";s:7:"options";a:1:{s:7:"default";b:0;}}s:26:"hasValidFamilySubscription";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:26:"hasValidFamilySubscription";s:10:"columnName";s:29:"has_valid_family_subscription";s:8:"nullable";b:1;}}s:10:"fieldNames";a:23:{s:2:"id";s:2:"id";s:13:"plguser_state";s:12:"PLGUserState";s:15:"plgusage_status";s:14:"PLGUsageStatus";s:20:"plguser_state_family";s:18:"PLGUserStateFamily";s:22:"plgusage_status_family";s:20:"PLGUsageStatusFamily";s:18:"plgonboarding_step";s:17:"PLGOnboardingStep";s:9:"job_title";s:8:"jobTitle";s:17:"organization_type";s:16:"organizationType";s:8:"province";s:8:"province";s:19:"landing_page_origin";s:17:"landingPageOrigin";s:17:"is_decision_maker";s:15:"isDecisionMaker";s:18:"is_troubadour_user";s:16:"isTroubadourUser";s:20:"subscription_pending";s:19:"subscriptionPending";s:18:"subscriptions_used";s:17:"subscriptionsUsed";s:22:"has_valid_subscription";s:20:"hasValidSubscription";s:11:"is_freemium";s:10:"isFreemium";s:14:"is_school_user";s:12:"isSchoolUser";s:14:"is_family_user";s:12:"isFamilyUser";s:8:"is_dirty";s:7:"isDirty";s:10:"created_at";s:10:"created_at";s:10:"updated_at";s:10:"updated_at";s:21:"using_activation_code";s:19:"usingActivationCode";s:29:"has_valid_family_subscription";s:26:"hasValidFamilySubscription";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:25:"App\Entity\Zoho\ZohoState";s:9:"namespace";s:15:"App\Entity\Zoho";s:5:"table";a:2:{s:4:"name";s:9:"ZohoState";s:17:"uniqueConstraints";a:1:{s:10:"search_idx";a:1:{s:7:"columns";a:1:{i:0;s:7:"manager";}}}}s:14:"rootEntityName";s:25:"App\Entity\Zoho\ZohoState";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;s:18:"lifecycleCallbacks";a:1:{s:9:"preUpdate";a:1:{i:0;s:10:"setUpdated";}}}
164 0.69 ms default EXEC
165 0.53 ms default MGET 4GCzUd17WO:App__Entity__EducationalInstitution__CLASSMETADATA__
166 0.51 ms default MGET 4GCzUd17WO:App_Entity_EducationalInstitution_$GEDMO_TRANSLATABLE_CLASSMETADATA
167 0.01 ms default MULTI 2
168 0.01 ms default SETEX 4GCzUd17WO:App_Entity_EducationalInstitution_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
169 0.41 ms default EXEC
170 0.50 ms default MGET 4GCzUd17WO:App__Entity__EducationalInstitution__CLASSMETADATA__
171 0.01 ms default MULTI 2
172 0.01 ms default SETEX 4GCzUd17WO:App__Entity__EducationalInstitution__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:3:{s:7:"country";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:7:"country";s:12:"sourceEntity";s:33:"App\Entity\EducationalInstitution";s:12:"targetEntity";s:18:"App\Entity\Country";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:10:"country_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:"country_id";s:10:"country_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:10:"country_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:10:"country_id";}}s:8:"managers";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:8:"managers";s:12:"sourceEntity";s:33:"App\Entity\EducationalInstitution";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:8:"mappedBy";s:22:"educationalInstitution";}s:9:"emissions";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:9:"emissions";s:12:"sourceEntity";s:33:"App\Entity\EducationalInstitution";s:12:"targetEntity";s:49:"App\Entity\SubscriptionDealing\RedeemCodeEmission";s:5:"fetch";i:2;s:8:"mappedBy";s:22:"educationalInstitution";}}s:11:"columnNames";a:7:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:4:"city";s:4:"city";s:8:"province";s:8:"province";s:8:"postcode";s:8:"postcode";s:7:"orgType";s:8:"org_type";s:16:"nanomonxApproved";s:17:"nanomonx_approved";}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: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:4:"city";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"city";s:10:"columnName";s:4:"city";s:8:"nullable";b:1;}s:8:"province";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:8:"province";s:10:"columnName";s:8:"province";s:8:"nullable";b:1;}s:8:"postcode";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:8:"postcode";s:10:"columnName";s:8:"postcode";}s:7:"orgType";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:7:"orgType";s:10:"columnName";s:8:"org_type";s:8:"nullable";b:1;s:8:"enumType";s:37:"App\Entity\Zoho\enum\OrganizationType";}s:16:"nanomonxApproved";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:16:"nanomonxApproved";s:10:"columnName";s:17:"nanomonx_approved";}}s:10:"fieldNames";a:7:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:4:"city";s:4:"city";s:8:"province";s:8:"province";s:8:"postcode";s:8:"postcode";s:8:"org_type";s:7:"orgType";s:17:"nanomonx_approved";s:16:"nanomonxApproved";}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\EducationalInstitution";s:9:"namespace";s:10:"App\Entity";s:5:"table";a:3:{s:4:"name";s:22:"EducationalInstitution";s:6:"quoted";b:1;s:17:"uniqueConstraints";a:1:{s:13:"school_unique";a:1:{s:6:"fields";a:3:{i:0;s:4:"name";i:1;s:8:"postcode";i:2;s:7:"country";}}}}s:14:"rootEntityName";s:33:"App\Entity\EducationalInstitution";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:47:"App\Repository\EducationalInstitutionRepository";s:13:"generatorType";i:4;s:5:"cache";a:2:{s:6:"region";s:8:"nanomonx";s:5:"usage";i:2;}}
173 0.60 ms default EXEC
174 0.52 ms default MGET 4GCzUd17WO:App__Entity__Constellation__TextEntry__CLASSMETADATA__
175 1.63 ms default MGET 4GCzUd17WO:App_Entity_Constellation_TextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA
176 0.03 ms default MULTI 2
177 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Constellation_TextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
178 1.04 ms default EXEC
179 2.41 ms default MGET 4GCzUd17WO:App__Entity__Constellation__TextEntry__CLASSMETADATA__
180 0.01 ms default MULTI 2
181 0.01 ms default SETEX 4GCzUd17WO: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;}
182 2.10 ms default EXEC
183 0.53 ms default MGET 4GCzUd17WO:App__Entity__Constellation__Environment__CLASSMETADATA__
184 0.50 ms default MGET 4GCzUd17WO:App_Entity_Constellation_Environment_$GEDMO_TRANSLATABLE_CLASSMETADATA
185 0.01 ms default MULTI 2
186 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Constellation_Environment_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
187 0.46 ms default EXEC
188 0.47 ms default MGET 4GCzUd17WO:App__Entity__Constellation__Environment__CLASSMETADATA__
189 0.01 ms default MULTI 2
190 0.01 ms default SETEX 4GCzUd17WO: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;}
191 0.60 ms default EXEC
192 0.46 ms default MGET 4GCzUd17WO:App__Entity__Constellation__UserChallengeStatus__CLASSMETADATA__
193 0.46 ms default MGET 4GCzUd17WO:App_Entity_Constellation_UserChallengeStatus_$GEDMO_TRANSLATABLE_CLASSMETADATA
194 0.01 ms default MULTI 2
195 0.01 ms default SETEX 4GCzUd17WO:App_Entity_Constellation_UserChallengeStatus_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
196 0.45 ms default EXEC
197 0.44 ms default MGET 4GCzUd17WO:App__Entity__Constellation__UserChallengeStatus__CLASSMETADATA__
198 0.01 ms default MULTI 2
199 0.02 ms default SETEX 4GCzUd17WO: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;}
200 0.59 ms default EXEC
201 0.55 ms default SETEX nanomonx_dev_c22fdb695a84780fa3037fe40346f946 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:7:"country";s:2:"US";s:18:"is_default_country";b:0;s:24:"_csrf/https-authenticate";s:43:"tePq82iyseW48eDRWZqHuqIsrAnzusjAneSysSWiimY";}_sf2_meta|a:3:{s:1:"u";i:1760593685;s:1:"c";i:1760593685;s:1:"l";i:604800;}