Commands
66
Queries
37.40 ms
Query time
0
Failed Queries
| # | Time | Connection | Command |
|---|---|---|---|
| 1 | 15.37 ms | default | CONNECT tls://constellation-web-develop-cache-3ighqi.serverless.cac1.cache.amazonaws.com 6379 5 <null> 5 5 |
| 2 | 1.53 ms | default | AUTH constellation-web-develop-user r~Lt_i14yB?*-GM(5{<] |
| 3 | 0.73 ms | default | MGET yhO9eoy0BA:DateTime__CLASSMETADATA__ |
| 4 | 0.71 ms | default | MGET yhO9eoy0BA:DateTime__CLASSMETADATA__ |
| 5 | 0.50 ms | default | MGET 6KPuJdXCbj:1dcb288a51f02eee7c717ad329c71b6d |
| 6 | 0.01 ms | default | MULTI 2 |
| 7 | 0.02 ms | default | SETEX 6KPuJdXCbj:1dcb288a51f02eee7c717ad329c71b6d 86400 O:31:"Doctrine\ORM\Query\ParserResult":4:{s:44:" Doctrine\ORM\Query\ParserResult sqlExecutor";N;s:45:" Doctrine\ORM\Query\ParserResult sqlFinalizer";O:48:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer":1:{s:53:" Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer sql";s:98:"SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.`translations` AS translations_2 FROM `Subject` s0_";}s:49:" Doctrine\ORM\Query\ParserResult resultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":23:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:1:{s:6:"entity";s:26:"App\Entity\Catalog\Subject";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:3:{s:4:"id_0";s:2:"id";s:6:"name_1";s:4:"name";s:14:"translations_2";s:12:"translations";}s:19:"columnAliasMappings";a:1:{s:26:"App\Entity\Catalog\Subject";a:1:{s:6:"entity";a:3:{s:2:"id";s:4:"id_0";s:4:"name";s:6:"name_1";s:12:"translations";s:14:"translations_2";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:3:{s:4:"id_0";s:6:"entity";s:6:"name_1";s:6:"entity";s:14:"translations_2";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:3:{s:4:"id_0";s:26:"App\Entity\Catalog\Subject";s:6:"name_1";s:26:"App\Entity\Catalog\Subject";s:14:"translations_2";s:26:"App\Entity\Catalog\Subject";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:9:"newObject";a:0:{}s:24:"nestedNewObjectArguments";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}s:14:"nestedEntities";a:0:{}}s:50:" Doctrine\ORM\Query\ParserResult parameterMappings";a:0:{}} |
| 8 | 0.46 ms | default | EXEC |
| 9 | 0.50 ms | default | MGET 6KPuJdXCbj:5a0ba52cde2a50f0e6d9964857ccac30 |
| 10 | 0.01 ms | default | MULTI 2 |
| 11 | 0.01 ms | default | SETEX 6KPuJdXCbj:5a0ba52cde2a50f0e6d9964857ccac30 86400 O:31:"Doctrine\ORM\Query\ParserResult":4:{s:44:" Doctrine\ORM\Query\ParserResult sqlExecutor";N;s:45:" Doctrine\ORM\Query\ParserResult sqlFinalizer";O:48:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer":1:{s:53:" Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer sql";s:208:"SELECT c0_.id AS id_0, c0_.challenge_template_id AS challenge_template_id_1, c0_.educational_pathway_id AS educational_pathway_id_2 FROM `ChallengeTemplateAssociation` c0_ WHERE c0_.educational_pathway_id = ?";}s:49:" Doctrine\ORM\Query\ParserResult resultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":23:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:1:{s:6:"entity";s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:1:{s:4:"id_0";s:2:"id";}s:19:"columnAliasMappings";a:1:{s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";a:1:{s:6:"entity";a:1:{s:2:"id";s:4:"id_0";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:2:{s:23:"challenge_template_id_1";s:7:"integer";s:24:"educational_pathway_id_2";s:7:"integer";}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:2:{s:23:"challenge_template_id_1";s:21:"challenge_template_id";s:24:"educational_pathway_id_2";s:22:"educational_pathway_id";}s:14:"columnOwnerMap";a:3:{s:4:"id_0";s:6:"entity";s:23:"challenge_template_id_1";s:6:"entity";s:24:"educational_pathway_id_2";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:1:{s:4:"id_0";s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:9:"newObject";a:0:{}s:24:"nestedNewObjectArguments";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}s:14:"nestedEntities";a:0:{}}s:50:" Doctrine\ORM\Query\ParserResult parameterMappings";a:1:{s:19:"educational_pathway";a:1:{i:0;i:0;}}} |
| 12 | 0.48 ms | default | EXEC |
| 13 | 0.63 ms | default | MGET yhO9eoy0BA:App__Entity__Constellation__ReadingTemplateWorld__CLASSMETADATA__ |
| 14 | 0.51 ms | default | MGET yhO9eoy0BA:App_Entity_Constellation_World_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 15 | 0.01 ms | default | MULTI 2 |
| 16 | 0.01 ms | default | SETEX yhO9eoy0BA:App_Entity_Constellation_World_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 17 | 0.42 ms | default | EXEC |
| 18 | 0.52 ms | default | MGET yhO9eoy0BA:App_Entity_Constellation_ReadingTemplateWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 19 | 0.01 ms | default | MULTI 2 |
| 20 | 0.01 ms | default | SETEX yhO9eoy0BA:App_Entity_Constellation_ReadingTemplateWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 21 | 0.42 ms | default | EXEC |
| 22 | 0.51 ms | default | MGET yhO9eoy0BA:App__Entity__Constellation__World__CLASSMETADATA__ yhO9eoy0BA:App__Entity__Constellation__ReadingTemplateWorld__CLASSMETADATA__ |
| 23 | 0.01 ms | default | MULTI 2 |
| 24 | 0.01 ms | default | SETEX yhO9eoy0BA: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;} |
| 25 | 0.02 ms | default | SETEX yhO9eoy0BA: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;} |
| 26 | 0.77 ms | default | EXEC |
| 27 | 0.61 ms | default | MGET yhO9eoy0BA:App__Entity__Constellation__StudentWorld__CLASSMETADATA__ |
| 28 | 0.55 ms | default | MGET yhO9eoy0BA:App__Entity__Constellation__SubWorld__CLASSMETADATA__ |
| 29 | 0.43 ms | default | MGET yhO9eoy0BA:App_Entity_Constellation_SubWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 30 | 0.01 ms | default | MULTI 2 |
| 31 | 0.01 ms | default | SETEX yhO9eoy0BA:App_Entity_Constellation_SubWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 32 | 0.42 ms | default | EXEC |
| 33 | 0.40 ms | default | MGET yhO9eoy0BA:App__Entity__Constellation__SubWorld__CLASSMETADATA__ |
| 34 | 0.01 ms | default | MULTI 2 |
| 35 | 0.02 ms | default | SETEX yhO9eoy0BA: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;} |
| 36 | 0.63 ms | default | EXEC |
| 37 | 0.61 ms | default | MGET yhO9eoy0BA:App__Entity__Constellation__UserChallenge__CLASSMETADATA__ |
| 38 | 0.72 ms | default | MGET yhO9eoy0BA:App_Entity_Constellation_StudentWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 39 | 0.52 ms | default | MGET 6KPuJdXCbj:5575ed236b054ea2524b8a624056f86d |
| 40 | 0.01 ms | default | MULTI 2 |
| 41 | 0.02 ms | default | SETEX 6KPuJdXCbj:5575ed236b054ea2524b8a624056f86d 86400 O:31:"Doctrine\ORM\Query\ParserResult":4:{s:44:" Doctrine\ORM\Query\ParserResult sqlExecutor";N;s:45:" Doctrine\ORM\Query\ParserResult sqlFinalizer";O:48:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer":1:{s:53:" Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer sql";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\ParserResult resultSetMapping";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\ParserResult parameterMappings";a:0:{}} |
| 42 | 0.45 ms | default | EXEC |
| 43 | 0.45 ms | default | MGET veOOXU8S0-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_2__translations |
| 44 | 0.52 ms | default | MGET veOOXU8S0-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_2 veOOXU8S0-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_6 |
| 45 | 0.41 ms | default | MGET veOOXU8S0-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_3__translations |
| 46 | 0.89 ms | default | MGET veOOXU8S0-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_3 veOOXU8S0-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_4 |
| 47 | 0.60 ms | default | MGET yhO9eoy0BA:App__Entity__Constellation__TextEntry__CLASSMETADATA__ |
| 48 | 0.40 ms | default | MGET yhO9eoy0BA:App_Entity_Constellation_TextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 49 | 0.01 ms | default | MULTI 2 |
| 50 | 0.01 ms | default | SETEX yhO9eoy0BA:App_Entity_Constellation_TextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 51 | 0.40 ms | default | EXEC |
| 52 | 0.50 ms | default | MGET yhO9eoy0BA:App__Entity__Constellation__TextEntry__CLASSMETADATA__ |
| 53 | 0.01 ms | default | MULTI 2 |
| 54 | 0.01 ms | default | SETEX yhO9eoy0BA: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;} |
| 55 | 0.52 ms | default | EXEC |
| 56 | 0.38 ms | default | MGET yhO9eoy0BA:App__Entity__Constellation__Environment__CLASSMETADATA__ |
| 57 | 0.41 ms | default | MGET yhO9eoy0BA:App_Entity_Constellation_Environment_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 58 | 0.01 ms | default | MULTI 2 |
| 59 | 0.01 ms | default | SETEX yhO9eoy0BA:App_Entity_Constellation_Environment_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 60 | 0.39 ms | default | EXEC |
| 61 | 0.40 ms | default | MGET yhO9eoy0BA:App__Entity__Constellation__Environment__CLASSMETADATA__ |
| 62 | 0.00 ms | default | MULTI 2 |
| 63 | 0.01 ms | default | SETEX yhO9eoy0BA: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;} |
| 64 | 0.56 ms | default | EXEC |
| 65 | 0.50 ms | default | MGET yhO9eoy0BA:App__Entity__Constellation__UserChallengeStatus__CLASSMETADATA__ |
| 66 | 0.42 ms | default | EXPIRE nanomonx_dev_44ed66dfeb1b004d37929086cdf13077 86400 <null> |