Commands
180
Queries
79.97 ms
Query time
0
Failed Queries
| # | Time | Connection | Command |
|---|---|---|---|
| 1 | 17.15 ms | default | CONNECT tls://constellation-web-develop-cache-3ighqi.serverless.cac1.cache.amazonaws.com 6379 5 <null> 5 5 |
| 2 | 1.96 ms | default | AUTH constellation-web-develop-user S3}Ib>ro^jV*kQEP8n5K |
| 3 | 0.85 ms | default | MGET rhStxpxK6E:DateTime__CLASSMETADATA__ |
| 4 | 0.48 ms | default | MGET rhStxpxK6E:DateTime__CLASSMETADATA__ |
| 5 | 0.45 ms | default | MGET RBURgP-bhS:c1433c801c58d46a91096ecfab5439bb |
| 6 | 0.01 ms | default | MULTI 2 |
| 7 | 0.02 ms | default | SETEX RBURgP-bhS:c1433c801c58d46a91096ecfab5439bb 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:645:"SELECT u0_.id AS id_0, u0_.displayName AS displayName_1, u0_.username AS username_2, u0_.password AS password_3, u0_.salt AS salt_4, u0_.created_at AS created_at_5, u0_.last_active AS last_active_6, u0_.data AS data_7, u0_.google_id AS google_id_8, u0_.`character` AS character_9, u0_.version AS version_10, u0_.anonymized_at AS anonymized_at_11, u0_.anonymization_status AS anonymization_status_12, u0_.linked_email AS linked_email_13, u0_.type AS type_14, u0_.country_id AS country_id_15, u0_.onBoarding_status AS onBoarding_status_16, u0_.language_id AS language_id_17 FROM `User` u0_ WHERE (u0_.username = ?) AND u0_.type IN ('ROLE_STUDENT')";}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:18:"App\Entity\Student";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:14:{s:4:"id_0";s:2:"id";s:13:"displayName_1";s:11:"displayName";s:10:"username_2";s:8:"username";s:10:"password_3";s:8:"password";s:6:"salt_4";s:4:"salt";s:12:"created_at_5";s:10:"created_at";s:13:"last_active_6";s:11:"last_active";s:6:"data_7";s:4:"data";s:11:"google_id_8";s:8:"googleId";s:11:"character_9";s:9:"character";s:10:"version_10";s:7:"version";s:16:"anonymized_at_11";s:13:"anonymized_at";s:23:"anonymization_status_12";s:20:"anonymization_status";s:15:"linked_email_13";s:11:"linkedEmail";}s:19:"columnAliasMappings";a:1:{s:18:"App\Entity\Student";a:1:{s:6:"entity";a:14:{s:2:"id";s:4:"id_0";s:11:"displayName";s:13:"displayName_1";s:8:"username";s:10:"username_2";s:8:"password";s:10:"password_3";s:4:"salt";s:6:"salt_4";s:10:"created_at";s:12:"created_at_5";s:11:"last_active";s:13:"last_active_6";s:4:"data";s:6:"data_7";s:8:"googleId";s:11:"google_id_8";s:9:"character";s:11:"character_9";s:7:"version";s:10:"version_10";s:13:"anonymized_at";s:16:"anonymized_at_11";s:20:"anonymization_status";s:23:"anonymization_status_12";s:11:"linkedEmail";s:15:"linked_email_13";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:1:{s:23:"anonymization_status_12";s:30:"App\Entity\AnonymizationStatus";}s:12:"typeMappings";a:4:{s:7:"type_14";s:6:"string";s:13:"country_id_15";s:7:"integer";s:20:"onBoarding_status_16";s:7:"integer";s:14:"language_id_17";s:7:"integer";}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:4:{s:7:"type_14";s:4:"type";s:13:"country_id_15";s:10:"country_id";s:20:"onBoarding_status_16";s:17:"onBoarding_status";s:14:"language_id_17";s:11:"language_id";}s:14:"columnOwnerMap";a:18:{s:4:"id_0";s:6:"entity";s:13:"displayName_1";s:6:"entity";s:10:"username_2";s:6:"entity";s:10:"password_3";s:6:"entity";s:6:"salt_4";s:6:"entity";s:12:"created_at_5";s:6:"entity";s:13:"last_active_6";s:6:"entity";s:6:"data_7";s:6:"entity";s:11:"google_id_8";s:6:"entity";s:11:"character_9";s:6:"entity";s:10:"version_10";s:6:"entity";s:16:"anonymized_at_11";s:6:"entity";s:23:"anonymization_status_12";s:6:"entity";s:15:"linked_email_13";s:6:"entity";s:7:"type_14";s:6:"entity";s:13:"country_id_15";s:6:"entity";s:20:"onBoarding_status_16";s:6:"entity";s:14:"language_id_17";s:6:"entity";}s:20:"discriminatorColumns";a:1:{s:6:"entity";s:7:"type_14";}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:14:{s:4:"id_0";s:18:"App\Entity\Student";s:13:"displayName_1";s:18:"App\Entity\Student";s:10:"username_2";s:18:"App\Entity\Student";s:10:"password_3";s:18:"App\Entity\Student";s:6:"salt_4";s:18:"App\Entity\Student";s:12:"created_at_5";s:18:"App\Entity\Student";s:13:"last_active_6";s:18:"App\Entity\Student";s:6:"data_7";s:18:"App\Entity\Student";s:11:"google_id_8";s:18:"App\Entity\Student";s:11:"character_9";s:18:"App\Entity\Student";s:10:"version_10";s:18:"App\Entity\Student";s:16:"anonymized_at_11";s:18:"App\Entity\Student";s:23:"anonymization_status_12";s:18:"App\Entity\Student";s:15:"linked_email_13";s:18:"App\Entity\Student";}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:8:"username";a:1:{i:0;i:0;}}} |
| 8 | 0.91 ms | default | EXEC |
| 9 | 0.60 ms | default | MGET rhStxpxK6E:App_Entity_Student_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 10 | 0.58 ms | default | MGET rhStxpxK6E:App_Entity_ClassRegistration_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 11 | 4.15 ms | default | MGET rhStxpxK6E:App_Entity_Classroom_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 12 | 0.40 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Challenge_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 13 | 0.41 ms | default | MGET RBURgP-bhS:fb5823ce2d3e913eb0b0adec725a4c0f |
| 14 | 0.01 ms | default | MULTI 2 |
| 15 | 0.02 ms | default | SETEX RBURgP-bhS:fb5823ce2d3e913eb0b0adec725a4c0f 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:1136:"SELECT t0_.id AS id_0, t0_.comments AS comments_1, t0_.thumbnail AS thumbnail_2, t0_.is_highlighted AS is_highlighted_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5, t0_.completed_at AS completed_at_6, t0_.construction_status AS construction_status_7, t0_.correction_status AS correction_status_8, t0_.is_shared AS is_shared_9, t0_.is_in_portfolio AS is_in_portfolio_10, t0_.last_portfolio_update AS last_portfolio_update_11, t0_.recently_unassigned AS recently_unassigned_12, t0_.last_unassigned_update AS last_unassigned_update_13, t0_.marked_as_done AS marked_as_done_14, t0_.marked_as_in_correction AS marked_as_in_correction_15, t0_.is_favorite AS is_favorite_16, t0_.last_favorite_update AS last_favorite_update_17, t0_.is_in_trash AS is_in_trash_18, t0_.last_trash_update AS last_trash_update_19, t0_.is_marked_as_deleted AS is_marked_as_deleted_20, t0_.deleted_at AS deleted_at_21, t0_.student_id AS student_id_22, t0_.family_member_id AS family_member_id_23, t0_.challenge_id AS challenge_id_24 FROM `troub_UserChallenge` t0_ WHERE t0_.student_id = ? AND t0_.challenge_id = ? AND t0_.is_marked_as_deleted = 0";}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:45:"App\Entity\Troubadour\Creations\UserChallenge";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:22:{s:4:"id_0";s:2:"id";s:10:"comments_1";s:8:"comments";s:11:"thumbnail_2";s:9:"thumbnail";s:16:"is_highlighted_3";s:14:"is_highlighted";s:12:"created_at_4";s:10:"created_at";s:12:"updated_at_5";s:10:"updated_at";s:14:"completed_at_6";s:12:"completed_at";s:21:"construction_status_7";s:19:"construction_status";s:19:"correction_status_8";s:17:"correction_status";s:11:"is_shared_9";s:8:"isShared";s:18:"is_in_portfolio_10";s:13:"isInPortfolio";s:24:"last_portfolio_update_11";s:19:"lastPortfolioUpdate";s:22:"recently_unassigned_12";s:18:"recentlyUnassigned";s:25:"last_unassigned_update_13";s:20:"lastUnassignedUpdate";s:17:"marked_as_done_14";s:12:"markedAsDone";s:26:"marked_as_in_correction_15";s:20:"markedAsInCorrection";s:14:"is_favorite_16";s:10:"isFavorite";s:23:"last_favorite_update_17";s:18:"lastFavoriteUpdate";s:14:"is_in_trash_18";s:9:"isInTrash";s:20:"last_trash_update_19";s:15:"lastTrashUpdate";s:23:"is_marked_as_deleted_20";s:20:"is_marked_as_deleted";s:13:"deleted_at_21";s:10:"deleted_at";}s:19:"columnAliasMappings";a:1:{s:45:"App\Entity\Troubadour\Creations\UserChallenge";a:1:{s:6:"entity";a:22:{s:2:"id";s:4:"id_0";s:8:"comments";s:10:"comments_1";s:9:"thumbnail";s:11:"thumbnail_2";s:14:"is_highlighted";s:16:"is_highlighted_3";s:10:"created_at";s:12:"created_at_4";s:10:"updated_at";s:12:"updated_at_5";s:12:"completed_at";s:14:"completed_at_6";s:19:"construction_status";s:21:"construction_status_7";s:17:"correction_status";s:19:"correction_status_8";s:8:"isShared";s:11:"is_shared_9";s:13:"isInPortfolio";s:18:"is_in_portfolio_10";s:19:"lastPortfolioUpdate";s:24:"last_portfolio_update_11";s:18:"recentlyUnassigned";s:22:"recently_unassigned_12";s:20:"lastUnassignedUpdate";s:25:"last_unassigned_update_13";s:12:"markedAsDone";s:17:"marked_as_done_14";s:20:"markedAsInCorrection";s:26:"marked_as_in_correction_15";s:10:"isFavorite";s:14:"is_favorite_16";s:18:"lastFavoriteUpdate";s:23:"last_favorite_update_17";s:9:"isInTrash";s:14:"is_in_trash_18";s:15:"lastTrashUpdate";s:20:"last_trash_update_19";s:20:"is_marked_as_deleted";s:23:"is_marked_as_deleted_20";s:10:"deleted_at";s:13:"deleted_at_21";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:3:{s:13:"student_id_22";s:7:"integer";s:19:"family_member_id_23";s:7:"integer";s:15:"challenge_id_24";s:7:"integer";}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:3:{s:13:"student_id_22";s:10:"student_id";s:19:"family_member_id_23";s:16:"family_member_id";s:15:"challenge_id_24";s:12:"challenge_id";}s:14:"columnOwnerMap";a:25:{s:4:"id_0";s:6:"entity";s:10:"comments_1";s:6:"entity";s:11:"thumbnail_2";s:6:"entity";s:16:"is_highlighted_3";s:6:"entity";s:12:"created_at_4";s:6:"entity";s:12:"updated_at_5";s:6:"entity";s:14:"completed_at_6";s:6:"entity";s:21:"construction_status_7";s:6:"entity";s:19:"correction_status_8";s:6:"entity";s:11:"is_shared_9";s:6:"entity";s:18:"is_in_portfolio_10";s:6:"entity";s:24:"last_portfolio_update_11";s:6:"entity";s:22:"recently_unassigned_12";s:6:"entity";s:25:"last_unassigned_update_13";s:6:"entity";s:17:"marked_as_done_14";s:6:"entity";s:26:"marked_as_in_correction_15";s:6:"entity";s:14:"is_favorite_16";s:6:"entity";s:23:"last_favorite_update_17";s:6:"entity";s:14:"is_in_trash_18";s:6:"entity";s:20:"last_trash_update_19";s:6:"entity";s:23:"is_marked_as_deleted_20";s:6:"entity";s:13:"deleted_at_21";s:6:"entity";s:13:"student_id_22";s:6:"entity";s:19:"family_member_id_23";s:6:"entity";s:15:"challenge_id_24";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:22:{s:4:"id_0";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:10:"comments_1";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:11:"thumbnail_2";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:16:"is_highlighted_3";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:12:"created_at_4";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:12:"updated_at_5";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:14:"completed_at_6";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:21:"construction_status_7";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:19:"correction_status_8";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:11:"is_shared_9";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:18:"is_in_portfolio_10";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:24:"last_portfolio_update_11";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:22:"recently_unassigned_12";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:25:"last_unassigned_update_13";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:17:"marked_as_done_14";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:26:"marked_as_in_correction_15";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:14:"is_favorite_16";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:23:"last_favorite_update_17";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:14:"is_in_trash_18";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:20:"last_trash_update_19";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:23:"is_marked_as_deleted_20";s:45:"App\Entity\Troubadour\Creations\UserChallenge";s:13:"deleted_at_21";s:45:"App\Entity\Troubadour\Creations\UserChallenge";}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:2:{s:7:"student";a:1:{i:0;i:0;}s:9:"challenge";a:1:{i:0;i:1;}}} |
| 16 | 0.54 ms | default | EXEC |
| 17 | 0.66 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Creations_UserChallenge_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 18 | 0.34 ms | default | MGET rhStxpxK6E:App_Entity_Family_FamilyMember_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 19 | 0.54 ms | default | MGET rhStxpxK6E:App__Entity__Purchases__Subscriptions__CustomSubscription__CLASSMETADATA__ |
| 20 | 0.47 ms | default | MGET rhStxpxK6E:App__Entity__Purchases__Subscriptions__FreeTrialSubscription__CLASSMETADATA__ |
| 21 | 0.51 ms | default | MGET rhStxpxK6E:App__Entity__Purchases__Subscriptions__RecurringSubscription__CLASSMETADATA__ |
| 22 | 0.64 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Assets_Category_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 23 | 0.41 ms | default | MGET RBURgP-bhS:3db5ec27592d5dd17d63516437a9eb81 |
| 24 | 0.01 ms | default | MULTI 2 |
| 25 | 0.02 ms | default | SETEX RBURgP-bhS:3db5ec27592d5dd17d63516437a9eb81 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:396:"SELECT t0_.id AS id_0, t0_.sprite AS sprite_1, t0_.icon AS icon_2, t0_.is_default AS is_default_3, t0_.version AS version_4, t0_.is_marked_as_deleted AS is_marked_as_deleted_5, t0_.deleted_at AS deleted_at_6 FROM `troub_Floor` t0_ LEFT JOIN category_floor c2_ ON t0_.id = c2_.floor_id LEFT JOIN `troub_Category` t1_ ON t1_.id = c2_.category_id WHERE t1_.id IN (?) AND t0_.is_marked_as_deleted = 0";}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:35:"App\Entity\Troubadour\Scenery\Floor";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:7:{s:4:"id_0";s:2:"id";s:8:"sprite_1";s:6:"sprite";s:6:"icon_2";s:4:"icon";s:12:"is_default_3";s:10:"is_default";s:9:"version_4";s:7:"version";s:22:"is_marked_as_deleted_5";s:20:"is_marked_as_deleted";s:12:"deleted_at_6";s:10:"deleted_at";}s:19:"columnAliasMappings";a:1:{s:35:"App\Entity\Troubadour\Scenery\Floor";a:1:{s:6:"entity";a:7:{s:2:"id";s:4:"id_0";s:6:"sprite";s:8:"sprite_1";s:4:"icon";s:6:"icon_2";s:10:"is_default";s:12:"is_default_3";s:7:"version";s:9:"version_4";s:20:"is_marked_as_deleted";s:22:"is_marked_as_deleted_5";s:10:"deleted_at";s:12:"deleted_at_6";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:7:{s:4:"id_0";s:6:"entity";s:8:"sprite_1";s:6:"entity";s:6:"icon_2";s:6:"entity";s:12:"is_default_3";s:6:"entity";s:9:"version_4";s:6:"entity";s:22:"is_marked_as_deleted_5";s:6:"entity";s:12:"deleted_at_6";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:7:{s:4:"id_0";s:35:"App\Entity\Troubadour\Scenery\Floor";s:8:"sprite_1";s:35:"App\Entity\Troubadour\Scenery\Floor";s:6:"icon_2";s:35:"App\Entity\Troubadour\Scenery\Floor";s:12:"is_default_3";s:35:"App\Entity\Troubadour\Scenery\Floor";s:9:"version_4";s:35:"App\Entity\Troubadour\Scenery\Floor";s:22:"is_marked_as_deleted_5";s:35:"App\Entity\Troubadour\Scenery\Floor";s:12:"deleted_at_6";s:35:"App\Entity\Troubadour\Scenery\Floor";}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:10:"categories";a:1:{i:0;i:0;}}} |
| 26 | 0.51 ms | default | EXEC |
| 27 | 0.58 ms | default | MGET RBURgP-bhS:28850cf8cb0b0748c3ec91e84dcbe8ed |
| 28 | 0.01 ms | default | MULTI 2 |
| 29 | 0.01 ms | default | SETEX RBURgP-bhS:28850cf8cb0b0748c3ec91e84dcbe8ed 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:411:"SELECT t0_.id AS id_0, t0_.sprite AS sprite_1, t0_.icon AS icon_2, t0_.is_default AS is_default_3, t0_.version AS version_4, t0_.is_marked_as_deleted AS is_marked_as_deleted_5, t0_.deleted_at AS deleted_at_6 FROM `troub_Foreground` t0_ LEFT JOIN category_foreground c2_ ON t0_.id = c2_.foreground_id LEFT JOIN `troub_Category` t1_ ON t1_.id = c2_.category_id WHERE t1_.id IN (?) AND t0_.is_marked_as_deleted = 0";}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:40:"App\Entity\Troubadour\Scenery\Foreground";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:7:{s:4:"id_0";s:2:"id";s:8:"sprite_1";s:6:"sprite";s:6:"icon_2";s:4:"icon";s:12:"is_default_3";s:10:"is_default";s:9:"version_4";s:7:"version";s:22:"is_marked_as_deleted_5";s:20:"is_marked_as_deleted";s:12:"deleted_at_6";s:10:"deleted_at";}s:19:"columnAliasMappings";a:1:{s:40:"App\Entity\Troubadour\Scenery\Foreground";a:1:{s:6:"entity";a:7:{s:2:"id";s:4:"id_0";s:6:"sprite";s:8:"sprite_1";s:4:"icon";s:6:"icon_2";s:10:"is_default";s:12:"is_default_3";s:7:"version";s:9:"version_4";s:20:"is_marked_as_deleted";s:22:"is_marked_as_deleted_5";s:10:"deleted_at";s:12:"deleted_at_6";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:7:{s:4:"id_0";s:6:"entity";s:8:"sprite_1";s:6:"entity";s:6:"icon_2";s:6:"entity";s:12:"is_default_3";s:6:"entity";s:9:"version_4";s:6:"entity";s:22:"is_marked_as_deleted_5";s:6:"entity";s:12:"deleted_at_6";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:7:{s:4:"id_0";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:8:"sprite_1";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:6:"icon_2";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:12:"is_default_3";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:9:"version_4";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:22:"is_marked_as_deleted_5";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:12:"deleted_at_6";s:40:"App\Entity\Troubadour\Scenery\Foreground";}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:10:"categories";a:1:{i:0;i:0;}}} |
| 30 | 0.52 ms | default | EXEC |
| 31 | 0.64 ms | default | MGET RBURgP-bhS:0cc023fa4b1ea1c6cadd9faf18836a79 |
| 32 | 0.01 ms | default | MULTI 2 |
| 33 | 0.02 ms | default | SETEX RBURgP-bhS:0cc023fa4b1ea1c6cadd9faf18836a79 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:411:"SELECT t0_.id AS id_0, t0_.sprite AS sprite_1, t0_.icon AS icon_2, t0_.is_default AS is_default_3, t0_.version AS version_4, t0_.is_marked_as_deleted AS is_marked_as_deleted_5, t0_.deleted_at AS deleted_at_6 FROM `troub_Background` t0_ LEFT JOIN category_background c2_ ON t0_.id = c2_.background_id LEFT JOIN `troub_Category` t1_ ON t1_.id = c2_.category_id WHERE t1_.id IN (?) AND t0_.is_marked_as_deleted = 0";}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:40:"App\Entity\Troubadour\Scenery\Background";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:7:{s:4:"id_0";s:2:"id";s:8:"sprite_1";s:6:"sprite";s:6:"icon_2";s:4:"icon";s:12:"is_default_3";s:10:"is_default";s:9:"version_4";s:7:"version";s:22:"is_marked_as_deleted_5";s:20:"is_marked_as_deleted";s:12:"deleted_at_6";s:10:"deleted_at";}s:19:"columnAliasMappings";a:1:{s:40:"App\Entity\Troubadour\Scenery\Background";a:1:{s:6:"entity";a:7:{s:2:"id";s:4:"id_0";s:6:"sprite";s:8:"sprite_1";s:4:"icon";s:6:"icon_2";s:10:"is_default";s:12:"is_default_3";s:7:"version";s:9:"version_4";s:20:"is_marked_as_deleted";s:22:"is_marked_as_deleted_5";s:10:"deleted_at";s:12:"deleted_at_6";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:7:{s:4:"id_0";s:6:"entity";s:8:"sprite_1";s:6:"entity";s:6:"icon_2";s:6:"entity";s:12:"is_default_3";s:6:"entity";s:9:"version_4";s:6:"entity";s:22:"is_marked_as_deleted_5";s:6:"entity";s:12:"deleted_at_6";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:7:{s:4:"id_0";s:40:"App\Entity\Troubadour\Scenery\Background";s:8:"sprite_1";s:40:"App\Entity\Troubadour\Scenery\Background";s:6:"icon_2";s:40:"App\Entity\Troubadour\Scenery\Background";s:12:"is_default_3";s:40:"App\Entity\Troubadour\Scenery\Background";s:9:"version_4";s:40:"App\Entity\Troubadour\Scenery\Background";s:22:"is_marked_as_deleted_5";s:40:"App\Entity\Troubadour\Scenery\Background";s:12:"deleted_at_6";s:40:"App\Entity\Troubadour\Scenery\Background";}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:10:"categories";a:1:{i:0;i:0;}}} |
| 34 | 0.53 ms | default | EXEC |
| 35 | 0.61 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Scenery__BackColor__CLASSMETADATA__ |
| 36 | 0.55 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Scenery_BackColor_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 37 | 0.01 ms | default | MULTI 2 |
| 38 | 0.01 ms | default | SETEX rhStxpxK6E:App_Entity_Troubadour_Scenery_BackColor_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 39 | 0.41 ms | default | EXEC |
| 40 | 0.39 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Scenery__BackColor__CLASSMETADATA__ |
| 41 | 0.01 ms | default | MULTI 2 |
| 42 | 0.01 ms | default | SETEX rhStxpxK6E:App__Entity__Troubadour__Scenery__BackColor__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:0:{}s:11:"columnNames";a:6:{s:2:"id";s:2:"id";s:10:"main_color";s:10:"main_color";s:15:"secondary_color";s:15:"secondary_color";s:10:"is_default";s:10:"is_default";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}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:10:"main_color";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:10:"main_color";s:10:"columnName";s:10:"main_color";}s:15:"secondary_color";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:15:"secondary_color";s:10:"columnName";s:15:"secondary_color";}s:10:"is_default";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:10:"is_default";s:10:"columnName";s:10:"is_default";}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:6:{s:2:"id";s:2:"id";s:10:"main_color";s:10:"main_color";s:15:"secondary_color";s:15:"secondary_color";s:10:"is_default";s:10:"is_default";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:39:"App\Entity\Troubadour\Scenery\BackColor";s:9:"namespace";s:29:"App\Entity\Troubadour\Scenery";s:5:"table";a:2:{s:4:"name";s:15:"troub_BackColor";s:6:"quoted";b:1;}s:14:"rootEntityName";s:39:"App\Entity\Troubadour\Scenery\BackColor";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;}} |
| 43 | 0.47 ms | default | EXEC |
| 44 | 0.35 ms | default | MGET RBURgP-bhS:95a93db104f865ad532d1715f79c0437 |
| 45 | 0.00 ms | default | MULTI 2 |
| 46 | 0.01 ms | default | SETEX RBURgP-bhS:95a93db104f865ad532d1715f79c0437 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:273:"SELECT t0_.id AS id_0, t0_.main_color AS main_color_1, t0_.secondary_color AS secondary_color_2, t0_.is_default AS is_default_3, t0_.is_marked_as_deleted AS is_marked_as_deleted_4, t0_.deleted_at AS deleted_at_5 FROM `troub_BackColor` t0_ WHERE t0_.is_marked_as_deleted = 0";}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:39:"App\Entity\Troubadour\Scenery\BackColor";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:6:{s:4:"id_0";s:2:"id";s:12:"main_color_1";s:10:"main_color";s:17:"secondary_color_2";s:15:"secondary_color";s:12:"is_default_3";s:10:"is_default";s:22:"is_marked_as_deleted_4";s:20:"is_marked_as_deleted";s:12:"deleted_at_5";s:10:"deleted_at";}s:19:"columnAliasMappings";a:1:{s:39:"App\Entity\Troubadour\Scenery\BackColor";a:1:{s:6:"entity";a:6:{s:2:"id";s:4:"id_0";s:10:"main_color";s:12:"main_color_1";s:15:"secondary_color";s:17:"secondary_color_2";s:10:"is_default";s:12:"is_default_3";s:20:"is_marked_as_deleted";s:22:"is_marked_as_deleted_4";s:10:"deleted_at";s:12:"deleted_at_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:12:"main_color_1";s:6:"entity";s:17:"secondary_color_2";s:6:"entity";s:12:"is_default_3";s:6:"entity";s:22:"is_marked_as_deleted_4";s:6:"entity";s:12:"deleted_at_5";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:6:{s:4:"id_0";s:39:"App\Entity\Troubadour\Scenery\BackColor";s:12:"main_color_1";s:39:"App\Entity\Troubadour\Scenery\BackColor";s:17:"secondary_color_2";s:39:"App\Entity\Troubadour\Scenery\BackColor";s:12:"is_default_3";s:39:"App\Entity\Troubadour\Scenery\BackColor";s:22:"is_marked_as_deleted_4";s:39:"App\Entity\Troubadour\Scenery\BackColor";s:12:"deleted_at_5";s:39:"App\Entity\Troubadour\Scenery\BackColor";}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:{}} |
| 47 | 0.41 ms | default | EXEC |
| 48 | 0.49 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__World__CLASSMETADATA__ |
| 49 | 0.50 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Creations_World_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 50 | 0.01 ms | default | MULTI 2 |
| 51 | 0.01 ms | default | SETEX rhStxpxK6E:App_Entity_Troubadour_Creations_World_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 52 | 0.41 ms | default | EXEC |
| 53 | 0.35 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__WorkBlockChild__CLASSMETADATA__ rhStxpxK6E:App__Entity__Troubadour__Creations__World__CLASSMETADATA__ |
| 54 | 0.01 ms | default | MULTI 2 |
| 55 | 0.01 ms | default | SETEX rhStxpxK6E:App__Entity__Troubadour__Creations__WorkBlockChild__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:0:{}s:11:"columnNames";a:4:{s:2:"id";s:2:"id";s:8:"position";s:8:"position";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:8:"position";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"integer";s:9:"fieldName";s:8:"position";s:10:"columnName";s:8:"position";}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:8:"position";s:8:"position";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:46:"App\Entity\Troubadour\Creations\WorkBlockChild";s:9:"namespace";s:31:"App\Entity\Troubadour\Creations";s:5:"table";a:1:{s:4:"name";s:16:"work_block_child";}s:14:"rootEntityName";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:13:"generatorType";i:4;s:18:"isMappedSuperclass";b:1;} |
| 56 | 0.01 ms | default | SETEX rhStxpxK6E:App__Entity__Troubadour__Creations__World__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:6:{s:10:"work_block";O:46:"Doctrine\ORM\Mapping\OneToOneOwningSideMapping":9:{s:9:"fieldName";s:10:"work_block";s:12:"sourceEntity";s:37:"App\Entity\Troubadour\Creations\World";s:12:"targetEntity";s:41:"App\Entity\Troubadour\Creations\WorkBlock";s:5:"fetch";i:2;s:10:"inversedBy";s:5:"world";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":3:{s:4:"name";s:13:"work_block_id";s:20:"referencedColumnName";s:2:"id";s:6:"unique";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:13:"work_block_id";s:13:"work_block_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:13:"work_block_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:13:"work_block_id";}}s:13:"world_objects";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:13:"world_objects";s:12:"sourceEntity";s:37:"App\Entity\Troubadour\Creations\World";s:12:"targetEntity";s:43:"App\Entity\Troubadour\Creations\WorldObject";s:5:"fetch";i:2;s:8:"mappedBy";s:5:"world";}s:10:"background";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:10:"background";s:12:"sourceEntity";s:37:"App\Entity\Troubadour\Creations\World";s:12:"targetEntity";s:40:"App\Entity\Troubadour\Scenery\Background";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:13:"background_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:13:"background_id";s:13:"background_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:13:"background_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:13:"background_id";}}s:5:"floor";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:5:"floor";s:12:"sourceEntity";s:37:"App\Entity\Troubadour\Creations\World";s:12:"targetEntity";s:35:"App\Entity\Troubadour\Scenery\Floor";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"floor_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:"floor_id";s:8:"floor_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"floor_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"floor_id";}}s:10:"foreground";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:10:"foreground";s:12:"sourceEntity";s:37:"App\Entity\Troubadour\Creations\World";s:12:"targetEntity";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:13:"foreground_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:13:"foreground_id";s:13:"foreground_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:13:"foreground_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:13:"foreground_id";}}s:10:"back_color";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:10:"back_color";s:12:"sourceEntity";s:37:"App\Entity\Troubadour\Creations\World";s:12:"targetEntity";s:39:"App\Entity\Troubadour\Scenery\BackColor";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:13:"back_color_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:13:"back_color_id";s:13:"back_color_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:13:"back_color_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:13:"back_color_id";}}}s:11:"columnNames";a:4:{s:2:"id";s:2:"id";s:8:"position";s:8:"position";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":5:{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:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}s:8:"position";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:8:"position";s:10:"columnName";s:8:"position";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}s:20:"is_marked_as_deleted";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{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:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"deleted_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{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:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}}s:10:"fieldNames";a:4:{s:2:"id";s:2:"id";s:8:"position";s:8:"position";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\Troubadour\Creations\World";s:9:"namespace";s:31:"App\Entity\Troubadour\Creations";s:5:"table";a:2:{s:4:"name";s:11:"troub_World";s:6:"quoted";b:1;}s:14:"rootEntityName";s:37:"App\Entity\Troubadour\Creations\World";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;} |
| 57 | 0.54 ms | default | EXEC |
| 58 | 0.49 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__TextEntry__CLASSMETADATA__ |
| 59 | 0.46 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Creations_TextEntries_TextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 60 | 0.01 ms | default | MULTI 2 |
| 61 | 0.01 ms | default | SETEX rhStxpxK6E:App_Entity_Troubadour_Creations_TextEntries_TextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 62 | 0.39 ms | default | EXEC |
| 63 | 0.45 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__TextEntry__CLASSMETADATA__ |
| 64 | 0.01 ms | default | MULTI 2 |
| 65 | 0.01 ms | default | SETEX rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__TextEntry__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":20:{s:19:"associationMappings";a:2:{s:9:"revisions";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":7:{s:9:"fieldName";s:9:"revisions";s:12:"sourceEntity";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:12:"targetEntity";s:52:"App\Entity\Troubadour\Creations\TextEntries\Revision";s:7:"cascade";a:2:{i:0;s:7:"persist";i:1;s:6:"remove";}s:5:"fetch";i:2;s:8:"mappedBy";s:9:"textEntry";s:7:"orderBy";a:1:{s:4:"date";s:3:"ASC";}}s:10:"work_block";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:10:"work_block";s:12:"sourceEntity";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:12:"targetEntity";s:41:"App\Entity\Troubadour\Creations\WorkBlock";s:5:"fetch";i:2;s:10:"inversedBy";s:12:"text_entries";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:13:"work_block_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:13:"work_block_id";s:13:"work_block_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:13:"work_block_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:13:"work_block_id";}}}s:11:"columnNames";a:5:{s:2:"id";s:2:"id";s:8:"position";s:8:"position";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";s:6:"status";s:6:"status";}s:13:"fieldMappings";a:5:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{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:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}s:8:"position";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:8:"position";s:10:"columnName";s:8:"position";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}s:20:"is_marked_as_deleted";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{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:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"deleted_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{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:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}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:10:"fieldNames";a:5:{s:2:"id";s:2:"id";s:8:"position";s:8:"position";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";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:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:9:"namespace";s:43:"App\Entity\Troubadour\Creations\TextEntries";s:5:"table";a:2:{s:4:"name";s:15:"troub_TextEntry";s:6:"quoted";b:1;}s:14:"rootEntityName";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:15:"inheritanceType";i:3;s:19:"discriminatorColumn";O:47:"Doctrine\ORM\Mapping\DiscriminatorColumnMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"type";s:4:"name";s:4:"type";s:6:"length";i:255;s:7:"options";a:0:{}}s:18:"discriminatorValue";N;s:16:"discriminatorMap";a:3:{s:14:"TYPE_NARRATION";s:62:"App\Entity\Troubadour\Creations\TextEntries\NarrationTextEntry";s:10:"TYPE_ASSET";s:58:"App\Entity\Troubadour\Creations\TextEntries\AssetTextEntry";s:10:"TYPE_TITLE";s:58:"App\Entity\Troubadour\Creations\TextEntries\TitleTextEntry";}s:13:"parentClasses";a:0:{}s:10:"subClasses";a:3:{i:0;s:62:"App\Entity\Troubadour\Creations\TextEntries\NarrationTextEntry";i:1;s:58:"App\Entity\Troubadour\Creations\TextEntries\AssetTextEntry";i:2;s:58:"App\Entity\Troubadour\Creations\TextEntries\TitleTextEntry";}s:13:"generatorType";i:4;} |
| 66 | 0.48 ms | default | EXEC |
| 67 | 0.38 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__WorldObject__CLASSMETADATA__ |
| 68 | 0.41 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Creations_WorldObject_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 69 | 0.01 ms | default | MULTI 2 |
| 70 | 0.01 ms | default | SETEX rhStxpxK6E:App_Entity_Troubadour_Creations_WorldObject_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 71 | 0.41 ms | default | EXEC |
| 72 | 0.36 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__WorldObject__CLASSMETADATA__ |
| 73 | 0.01 ms | default | MULTI 2 |
| 74 | 0.01 ms | default | SETEX rhStxpxK6E:App__Entity__Troubadour__Creations__WorldObject__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:3:{s:5:"world";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:5:"world";s:12:"sourceEntity";s:43:"App\Entity\Troubadour\Creations\WorldObject";s:12:"targetEntity";s:37:"App\Entity\Troubadour\Creations\World";s:5:"fetch";i:2;s:10:"inversedBy";s:13:"world_objects";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:5:"asset";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:5:"asset";s:12:"sourceEntity";s:43:"App\Entity\Troubadour\Creations\WorldObject";s:12:"targetEntity";s:34:"App\Entity\Troubadour\Assets\Asset";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"asset_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:"asset_id";s:8:"asset_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"asset_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"asset_id";}}s:12:"text_entries";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:12:"text_entries";s:12:"sourceEntity";s:43:"App\Entity\Troubadour\Creations\WorldObject";s:12:"targetEntity";s:58:"App\Entity\Troubadour\Creations\TextEntries\AssetTextEntry";s:5:"fetch";i:2;s:8:"mappedBy";s:12:"world_object";}}s:11:"columnNames";a:7:{s:2:"id";s:2:"id";s:4:"posX";s:5:"pos_x";s:4:"posY";s:5:"pos_y";s:5:"flipX";s:6:"flip_x";s:13:"backDisplayed";s:14:"back_displayed";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:4:"posX";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:4:"posX";s:10:"columnName";s:5:"pos_x";s:8:"nullable";b:1;}s:4:"posY";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:4:"posY";s:10:"columnName";s:5:"pos_y";s:8:"nullable";b:1;}s:5:"flipX";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:5:"flipX";s:10:"columnName";s:6:"flip_x";}s:13:"backDisplayed";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:13:"backDisplayed";s:10:"columnName";s:14:"back_displayed";}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:5:"pos_x";s:4:"posX";s:5:"pos_y";s:4:"posY";s:6:"flip_x";s:5:"flipX";s:14:"back_displayed";s:13:"backDisplayed";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:43:"App\Entity\Troubadour\Creations\WorldObject";s:9:"namespace";s:31:"App\Entity\Troubadour\Creations";s:5:"table";a:2:{s:4:"name";s:17:"troub_WorldObject";s:6:"quoted";b:1;}s:14:"rootEntityName";s:43:"App\Entity\Troubadour\Creations\WorldObject";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;} |
| 75 | 0.46 ms | default | EXEC |
| 76 | 0.51 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Creations_WorkBlock_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 77 | 0.43 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__NarrationTextEntry__CLASSMETADATA__ |
| 78 | 0.39 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Creations_TextEntries_NarrationTextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 79 | 0.01 ms | default | MULTI 2 |
| 80 | 0.01 ms | default | SETEX rhStxpxK6E:App_Entity_Troubadour_Creations_TextEntries_NarrationTextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 81 | 0.38 ms | default | EXEC |
| 82 | 0.36 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__NarrationTextEntry__CLASSMETADATA__ |
| 83 | 0.01 ms | default | MULTI 2 |
| 84 | 0.03 ms | default | SETEX rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__NarrationTextEntry__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":20:{s:19:"associationMappings";a:2:{s:9:"revisions";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":9:{s:9:"fieldName";s:9:"revisions";s:12:"sourceEntity";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:12:"targetEntity";s:52:"App\Entity\Troubadour\Creations\TextEntries\Revision";s:7:"cascade";a:2:{i:0;s:7:"persist";i:1;s:6:"remove";}s:5:"fetch";i:2;s:9:"inherited";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"mappedBy";s:9:"textEntry";s:7:"orderBy";a:1:{s:4:"date";s:3:"ASC";}}s:10:"work_block";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":11:{s:9:"fieldName";s:10:"work_block";s:12:"sourceEntity";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:12:"targetEntity";s:41:"App\Entity\Troubadour\Creations\WorkBlock";s:5:"fetch";i:2;s:9:"inherited";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:10:"inversedBy";s:12:"text_entries";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:13:"work_block_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:13:"work_block_id";s:13:"work_block_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:13:"work_block_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:13:"work_block_id";}}}s:11:"columnNames";a:5:{s:2:"id";s:2:"id";s:8:"position";s:8:"position";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";s:6:"status";s:6:"status";}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:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}s:8:"position";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:7:"integer";s:9:"fieldName";s:8:"position";s:10:"columnName";s:8:"position";s:9:"inherited";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}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:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";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:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}s:6:"status";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:6:"string";s:9:"fieldName";s:6:"status";s:10:"columnName";s:6:"status";s:8:"nullable";b:1;s:9:"inherited";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";}}s:10:"fieldNames";a:5:{s:2:"id";s:2:"id";s:8:"position";s:8:"position";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";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:62:"App\Entity\Troubadour\Creations\TextEntries\NarrationTextEntry";s:9:"namespace";s:43:"App\Entity\Troubadour\Creations\TextEntries";s:5:"table";a:2:{s:4:"name";s:15:"troub_TextEntry";s:6:"quoted";b:1;}s:14:"rootEntityName";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:15:"inheritanceType";i:3;s:19:"discriminatorColumn";O:47:"Doctrine\ORM\Mapping\DiscriminatorColumnMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"type";s:4:"name";s:4:"type";s:6:"length";i:255;s:7:"options";a:0:{}}s:18:"discriminatorValue";s:14:"TYPE_NARRATION";s:16:"discriminatorMap";a:3:{s:14:"TYPE_NARRATION";s:62:"App\Entity\Troubadour\Creations\TextEntries\NarrationTextEntry";s:10:"TYPE_ASSET";s:58:"App\Entity\Troubadour\Creations\TextEntries\AssetTextEntry";s:10:"TYPE_TITLE";s:58:"App\Entity\Troubadour\Creations\TextEntries\TitleTextEntry";}s:13:"parentClasses";a:1:{i:0;s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";}s:10:"subClasses";a:0:{}s:13:"generatorType";i:4;} |
| 85 | 0.48 ms | default | EXEC |
| 86 | 0.37 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__AssetTextEntry__CLASSMETADATA__ |
| 87 | 0.37 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Creations_TextEntries_AssetTextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 88 | 0.00 ms | default | MULTI 2 |
| 89 | 0.01 ms | default | SETEX rhStxpxK6E:App_Entity_Troubadour_Creations_TextEntries_AssetTextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 90 | 0.37 ms | default | EXEC |
| 91 | 0.37 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__AssetTextEntry__CLASSMETADATA__ |
| 92 | 0.01 ms | default | MULTI 2 |
| 93 | 0.02 ms | default | SETEX rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__AssetTextEntry__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":20:{s:19:"associationMappings";a:3:{s:9:"revisions";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":9:{s:9:"fieldName";s:9:"revisions";s:12:"sourceEntity";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:12:"targetEntity";s:52:"App\Entity\Troubadour\Creations\TextEntries\Revision";s:7:"cascade";a:2:{i:0;s:7:"persist";i:1;s:6:"remove";}s:5:"fetch";i:2;s:9:"inherited";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"mappedBy";s:9:"textEntry";s:7:"orderBy";a:1:{s:4:"date";s:3:"ASC";}}s:10:"work_block";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":11:{s:9:"fieldName";s:10:"work_block";s:12:"sourceEntity";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:12:"targetEntity";s:41:"App\Entity\Troubadour\Creations\WorkBlock";s:5:"fetch";i:2;s:9:"inherited";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:10:"inversedBy";s:12:"text_entries";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:13:"work_block_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:13:"work_block_id";s:13:"work_block_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:13:"work_block_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:13:"work_block_id";}}s:12:"world_object";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:12:"world_object";s:12:"sourceEntity";s:58:"App\Entity\Troubadour\Creations\TextEntries\AssetTextEntry";s:12:"targetEntity";s:43:"App\Entity\Troubadour\Creations\WorldObject";s:5:"fetch";i:2;s:10:"inversedBy";s:12:"text_entries";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:15:"world_object_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:"world_object_id";s:15:"world_object_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:15:"world_object_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:15:"world_object_id";}}}s:11:"columnNames";a:5:{s:2:"id";s:2:"id";s:8:"position";s:8:"position";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";s:6:"status";s:6:"status";}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:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}s:8:"position";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:7:"integer";s:9:"fieldName";s:8:"position";s:10:"columnName";s:8:"position";s:9:"inherited";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}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:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";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:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}s:6:"status";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:6:"string";s:9:"fieldName";s:6:"status";s:10:"columnName";s:6:"status";s:8:"nullable";b:1;s:9:"inherited";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";}}s:10:"fieldNames";a:5:{s:2:"id";s:2:"id";s:8:"position";s:8:"position";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";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:58:"App\Entity\Troubadour\Creations\TextEntries\AssetTextEntry";s:9:"namespace";s:43:"App\Entity\Troubadour\Creations\TextEntries";s:5:"table";a:2:{s:4:"name";s:15:"troub_TextEntry";s:6:"quoted";b:1;}s:14:"rootEntityName";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:15:"inheritanceType";i:3;s:19:"discriminatorColumn";O:47:"Doctrine\ORM\Mapping\DiscriminatorColumnMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"type";s:4:"name";s:4:"type";s:6:"length";i:255;s:7:"options";a:0:{}}s:18:"discriminatorValue";s:10:"TYPE_ASSET";s:16:"discriminatorMap";a:3:{s:14:"TYPE_NARRATION";s:62:"App\Entity\Troubadour\Creations\TextEntries\NarrationTextEntry";s:10:"TYPE_ASSET";s:58:"App\Entity\Troubadour\Creations\TextEntries\AssetTextEntry";s:10:"TYPE_TITLE";s:58:"App\Entity\Troubadour\Creations\TextEntries\TitleTextEntry";}s:13:"parentClasses";a:1:{i:0;s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";}s:10:"subClasses";a:0:{}s:13:"generatorType";i:4;} |
| 94 | 0.48 ms | default | EXEC |
| 95 | 0.36 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__TitleTextEntry__CLASSMETADATA__ |
| 96 | 0.35 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Creations_TextEntries_TitleTextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 97 | 0.00 ms | default | MULTI 2 |
| 98 | 0.01 ms | default | SETEX rhStxpxK6E:App_Entity_Troubadour_Creations_TextEntries_TitleTextEntry_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 99 | 0.40 ms | default | EXEC |
| 100 | 0.35 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__TitleTextEntry__CLASSMETADATA__ |
| 101 | 0.00 ms | default | MULTI 2 |
| 102 | 0.01 ms | default | SETEX rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__TitleTextEntry__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":20:{s:19:"associationMappings";a:2:{s:9:"revisions";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":9:{s:9:"fieldName";s:9:"revisions";s:12:"sourceEntity";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:12:"targetEntity";s:52:"App\Entity\Troubadour\Creations\TextEntries\Revision";s:7:"cascade";a:2:{i:0;s:7:"persist";i:1;s:6:"remove";}s:5:"fetch";i:2;s:9:"inherited";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"mappedBy";s:9:"textEntry";s:7:"orderBy";a:1:{s:4:"date";s:3:"ASC";}}s:10:"work_block";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":11:{s:9:"fieldName";s:10:"work_block";s:12:"sourceEntity";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:12:"targetEntity";s:41:"App\Entity\Troubadour\Creations\WorkBlock";s:5:"fetch";i:2;s:9:"inherited";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:10:"inversedBy";s:12:"text_entries";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:13:"work_block_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:13:"work_block_id";s:13:"work_block_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:13:"work_block_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:13:"work_block_id";}}}s:11:"columnNames";a:5:{s:2:"id";s:2:"id";s:8:"position";s:8:"position";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";s:6:"status";s:6:"status";}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:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}s:8:"position";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:7:"integer";s:9:"fieldName";s:8:"position";s:10:"columnName";s:8:"position";s:9:"inherited";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}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:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";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:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:46:"App\Entity\Troubadour\Creations\WorkBlockChild";}s:6:"status";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:6:"string";s:9:"fieldName";s:6:"status";s:10:"columnName";s:6:"status";s:8:"nullable";b:1;s:9:"inherited";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:8:"declared";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";}}s:10:"fieldNames";a:5:{s:2:"id";s:2:"id";s:8:"position";s:8:"position";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";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:58:"App\Entity\Troubadour\Creations\TextEntries\TitleTextEntry";s:9:"namespace";s:43:"App\Entity\Troubadour\Creations\TextEntries";s:5:"table";a:2:{s:4:"name";s:15:"troub_TextEntry";s:6:"quoted";b:1;}s:14:"rootEntityName";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:15:"inheritanceType";i:3;s:19:"discriminatorColumn";O:47:"Doctrine\ORM\Mapping\DiscriminatorColumnMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"type";s:4:"name";s:4:"type";s:6:"length";i:255;s:7:"options";a:0:{}}s:18:"discriminatorValue";s:10:"TYPE_TITLE";s:16:"discriminatorMap";a:3:{s:14:"TYPE_NARRATION";s:62:"App\Entity\Troubadour\Creations\TextEntries\NarrationTextEntry";s:10:"TYPE_ASSET";s:58:"App\Entity\Troubadour\Creations\TextEntries\AssetTextEntry";s:10:"TYPE_TITLE";s:58:"App\Entity\Troubadour\Creations\TextEntries\TitleTextEntry";}s:13:"parentClasses";a:1:{i:0;s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";}s:10:"subClasses";a:0:{}s:13:"generatorType";i:4;} |
| 103 | 0.44 ms | default | EXEC |
| 104 | 0.46 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__Revision__CLASSMETADATA__ |
| 105 | 0.38 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Creations_TextEntries_Revision_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 106 | 0.01 ms | default | MULTI 2 |
| 107 | 0.01 ms | default | SETEX rhStxpxK6E:App_Entity_Troubadour_Creations_TextEntries_Revision_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 108 | 0.38 ms | default | EXEC |
| 109 | 0.42 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__Revision__CLASSMETADATA__ |
| 110 | 0.01 ms | default | MULTI 2 |
| 111 | 0.01 ms | default | SETEX rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__Revision__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:3:{s:9:"textEntry";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":10:{s:9:"fieldName";s:9:"textEntry";s:12:"sourceEntity";s:52:"App\Entity\Troubadour\Creations\TextEntries\Revision";s:12:"targetEntity";s:53:"App\Entity\Troubadour\Creations\TextEntries\TextEntry";s:7:"cascade";a:1:{i:0;s:7:"persist";}s:5:"fetch";i:2;s:10:"inversedBy";s:9:"revisions";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:11:"textEntryId";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:11:"textEntryId";s:11:"textEntryId";}s:24:"sourceToTargetKeyColumns";a:1:{s:11:"textEntryId";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:11:"textEntryId";}}s:4:"user";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:4:"user";s:12:"sourceEntity";s:52:"App\Entity\Troubadour\Creations\TextEntries\Revision";s:12:"targetEntity";s:19:"App\Entity\BaseUser";s:7:"cascade";a:1:{i:0;s:7:"persist";}s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:6:"userID";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:6:"userID";s:6:"userID";}s:24:"sourceToTargetKeyColumns";a:1:{s:6:"userID";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:6:"userID";}}s:7:"history";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":8:{s:9:"fieldName";s:7:"history";s:12:"sourceEntity";s:52:"App\Entity\Troubadour\Creations\TextEntries\Revision";s:12:"targetEntity";s:59:"App\Entity\Troubadour\Creations\TextEntries\RevisionHistory";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:8:"revision";s:7:"orderBy";a:1:{s:4:"date";s:3:"ASC";}}}s:11:"columnNames";a:6:{s:2:"id";s:2:"id";s:4:"text";s:4:"text";s:14:"teacherComment";s:14:"teacherComment";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: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:"text";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:4:"text";s:10:"columnName";s:4:"text";s:8:"nullable";b:1;}s:14:"teacherComment";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:14:"teacherComment";s:10:"columnName";s:14:"teacherComment";s:8:"nullable";b:1;}s:4:"date";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"integer";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:6:{s:2:"id";s:2:"id";s:4:"text";s:4:"text";s:14:"teacherComment";s:14:"teacherComment";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:52:"App\Entity\Troubadour\Creations\TextEntries\Revision";s:9:"namespace";s:43:"App\Entity\Troubadour\Creations\TextEntries";s:5:"table";a:2:{s:4:"name";s:14:"troub_Revision";s:6:"quoted";b:1;}s:14:"rootEntityName";s:52:"App\Entity\Troubadour\Creations\TextEntries\Revision";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;} |
| 112 | 0.45 ms | default | EXEC |
| 113 | 0.52 ms | default | MGET RBURgP-bhS:f2c18250800efefbaadbd5aee51958de |
| 114 | 0.01 ms | default | MULTI 2 |
| 115 | 0.02 ms | default | SETEX RBURgP-bhS:f2c18250800efefbaadbd5aee51958de 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:288:"SELECT t0_.id AS id_0, t0_.sprite AS sprite_1, t0_.icon AS icon_2, t0_.is_default AS is_default_3, t0_.version AS version_4, t0_.is_marked_as_deleted AS is_marked_as_deleted_5, t0_.deleted_at AS deleted_at_6 FROM `troub_Floor` t0_ WHERE t0_.is_default = ? AND t0_.is_marked_as_deleted = 0";}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:35:"App\Entity\Troubadour\Scenery\Floor";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:7:{s:4:"id_0";s:2:"id";s:8:"sprite_1";s:6:"sprite";s:6:"icon_2";s:4:"icon";s:12:"is_default_3";s:10:"is_default";s:9:"version_4";s:7:"version";s:22:"is_marked_as_deleted_5";s:20:"is_marked_as_deleted";s:12:"deleted_at_6";s:10:"deleted_at";}s:19:"columnAliasMappings";a:1:{s:35:"App\Entity\Troubadour\Scenery\Floor";a:1:{s:6:"entity";a:7:{s:2:"id";s:4:"id_0";s:6:"sprite";s:8:"sprite_1";s:4:"icon";s:6:"icon_2";s:10:"is_default";s:12:"is_default_3";s:7:"version";s:9:"version_4";s:20:"is_marked_as_deleted";s:22:"is_marked_as_deleted_5";s:10:"deleted_at";s:12:"deleted_at_6";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:7:{s:4:"id_0";s:6:"entity";s:8:"sprite_1";s:6:"entity";s:6:"icon_2";s:6:"entity";s:12:"is_default_3";s:6:"entity";s:9:"version_4";s:6:"entity";s:22:"is_marked_as_deleted_5";s:6:"entity";s:12:"deleted_at_6";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:7:{s:4:"id_0";s:35:"App\Entity\Troubadour\Scenery\Floor";s:8:"sprite_1";s:35:"App\Entity\Troubadour\Scenery\Floor";s:6:"icon_2";s:35:"App\Entity\Troubadour\Scenery\Floor";s:12:"is_default_3";s:35:"App\Entity\Troubadour\Scenery\Floor";s:9:"version_4";s:35:"App\Entity\Troubadour\Scenery\Floor";s:22:"is_marked_as_deleted_5";s:35:"App\Entity\Troubadour\Scenery\Floor";s:12:"deleted_at_6";s:35:"App\Entity\Troubadour\Scenery\Floor";}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:10:"is_default";a:1:{i:0;i:0;}}} |
| 116 | 0.46 ms | default | EXEC |
| 117 | 0.41 ms | default | MGET RBURgP-bhS:fc6eb3be681ecfd58daa8c9079f8b93e |
| 118 | 0.01 ms | default | MULTI 2 |
| 119 | 0.01 ms | default | SETEX RBURgP-bhS:fc6eb3be681ecfd58daa8c9079f8b93e 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:293:"SELECT t0_.id AS id_0, t0_.sprite AS sprite_1, t0_.icon AS icon_2, t0_.is_default AS is_default_3, t0_.version AS version_4, t0_.is_marked_as_deleted AS is_marked_as_deleted_5, t0_.deleted_at AS deleted_at_6 FROM `troub_Foreground` t0_ WHERE t0_.is_default = ? AND t0_.is_marked_as_deleted = 0";}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:40:"App\Entity\Troubadour\Scenery\Foreground";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:7:{s:4:"id_0";s:2:"id";s:8:"sprite_1";s:6:"sprite";s:6:"icon_2";s:4:"icon";s:12:"is_default_3";s:10:"is_default";s:9:"version_4";s:7:"version";s:22:"is_marked_as_deleted_5";s:20:"is_marked_as_deleted";s:12:"deleted_at_6";s:10:"deleted_at";}s:19:"columnAliasMappings";a:1:{s:40:"App\Entity\Troubadour\Scenery\Foreground";a:1:{s:6:"entity";a:7:{s:2:"id";s:4:"id_0";s:6:"sprite";s:8:"sprite_1";s:4:"icon";s:6:"icon_2";s:10:"is_default";s:12:"is_default_3";s:7:"version";s:9:"version_4";s:20:"is_marked_as_deleted";s:22:"is_marked_as_deleted_5";s:10:"deleted_at";s:12:"deleted_at_6";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:7:{s:4:"id_0";s:6:"entity";s:8:"sprite_1";s:6:"entity";s:6:"icon_2";s:6:"entity";s:12:"is_default_3";s:6:"entity";s:9:"version_4";s:6:"entity";s:22:"is_marked_as_deleted_5";s:6:"entity";s:12:"deleted_at_6";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:7:{s:4:"id_0";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:8:"sprite_1";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:6:"icon_2";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:12:"is_default_3";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:9:"version_4";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:22:"is_marked_as_deleted_5";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:12:"deleted_at_6";s:40:"App\Entity\Troubadour\Scenery\Foreground";}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:10:"is_default";a:1:{i:0;i:0;}}} |
| 120 | 0.45 ms | default | EXEC |
| 121 | 0.40 ms | default | MGET RBURgP-bhS:96fa99c52a2b9673d0a6a4f1b313c2fe |
| 122 | 0.01 ms | default | MULTI 2 |
| 123 | 0.01 ms | default | SETEX RBURgP-bhS:96fa99c52a2b9673d0a6a4f1b313c2fe 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:293:"SELECT t0_.id AS id_0, t0_.sprite AS sprite_1, t0_.icon AS icon_2, t0_.is_default AS is_default_3, t0_.version AS version_4, t0_.is_marked_as_deleted AS is_marked_as_deleted_5, t0_.deleted_at AS deleted_at_6 FROM `troub_Background` t0_ WHERE t0_.is_default = ? AND t0_.is_marked_as_deleted = 0";}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:40:"App\Entity\Troubadour\Scenery\Background";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:7:{s:4:"id_0";s:2:"id";s:8:"sprite_1";s:6:"sprite";s:6:"icon_2";s:4:"icon";s:12:"is_default_3";s:10:"is_default";s:9:"version_4";s:7:"version";s:22:"is_marked_as_deleted_5";s:20:"is_marked_as_deleted";s:12:"deleted_at_6";s:10:"deleted_at";}s:19:"columnAliasMappings";a:1:{s:40:"App\Entity\Troubadour\Scenery\Background";a:1:{s:6:"entity";a:7:{s:2:"id";s:4:"id_0";s:6:"sprite";s:8:"sprite_1";s:4:"icon";s:6:"icon_2";s:10:"is_default";s:12:"is_default_3";s:7:"version";s:9:"version_4";s:20:"is_marked_as_deleted";s:22:"is_marked_as_deleted_5";s:10:"deleted_at";s:12:"deleted_at_6";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:7:{s:4:"id_0";s:6:"entity";s:8:"sprite_1";s:6:"entity";s:6:"icon_2";s:6:"entity";s:12:"is_default_3";s:6:"entity";s:9:"version_4";s:6:"entity";s:22:"is_marked_as_deleted_5";s:6:"entity";s:12:"deleted_at_6";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:7:{s:4:"id_0";s:40:"App\Entity\Troubadour\Scenery\Background";s:8:"sprite_1";s:40:"App\Entity\Troubadour\Scenery\Background";s:6:"icon_2";s:40:"App\Entity\Troubadour\Scenery\Background";s:12:"is_default_3";s:40:"App\Entity\Troubadour\Scenery\Background";s:9:"version_4";s:40:"App\Entity\Troubadour\Scenery\Background";s:22:"is_marked_as_deleted_5";s:40:"App\Entity\Troubadour\Scenery\Background";s:12:"deleted_at_6";s:40:"App\Entity\Troubadour\Scenery\Background";}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:10:"is_default";a:1:{i:0;i:0;}}} |
| 124 | 0.46 ms | default | EXEC |
| 125 | 0.37 ms | default | MGET RBURgP-bhS:b74599ab527afad0a8c8fdc632234c9b |
| 126 | 0.01 ms | default | MULTI 2 |
| 127 | 0.01 ms | default | SETEX RBURgP-bhS:b74599ab527afad0a8c8fdc632234c9b 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:296:"SELECT t0_.id AS id_0, t0_.main_color AS main_color_1, t0_.secondary_color AS secondary_color_2, t0_.is_default AS is_default_3, t0_.is_marked_as_deleted AS is_marked_as_deleted_4, t0_.deleted_at AS deleted_at_5 FROM `troub_BackColor` t0_ WHERE t0_.is_default = ? AND t0_.is_marked_as_deleted = 0";}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:39:"App\Entity\Troubadour\Scenery\BackColor";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:6:{s:4:"id_0";s:2:"id";s:12:"main_color_1";s:10:"main_color";s:17:"secondary_color_2";s:15:"secondary_color";s:12:"is_default_3";s:10:"is_default";s:22:"is_marked_as_deleted_4";s:20:"is_marked_as_deleted";s:12:"deleted_at_5";s:10:"deleted_at";}s:19:"columnAliasMappings";a:1:{s:39:"App\Entity\Troubadour\Scenery\BackColor";a:1:{s:6:"entity";a:6:{s:2:"id";s:4:"id_0";s:10:"main_color";s:12:"main_color_1";s:15:"secondary_color";s:17:"secondary_color_2";s:10:"is_default";s:12:"is_default_3";s:20:"is_marked_as_deleted";s:22:"is_marked_as_deleted_4";s:10:"deleted_at";s:12:"deleted_at_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:12:"main_color_1";s:6:"entity";s:17:"secondary_color_2";s:6:"entity";s:12:"is_default_3";s:6:"entity";s:22:"is_marked_as_deleted_4";s:6:"entity";s:12:"deleted_at_5";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:6:{s:4:"id_0";s:39:"App\Entity\Troubadour\Scenery\BackColor";s:12:"main_color_1";s:39:"App\Entity\Troubadour\Scenery\BackColor";s:17:"secondary_color_2";s:39:"App\Entity\Troubadour\Scenery\BackColor";s:12:"is_default_3";s:39:"App\Entity\Troubadour\Scenery\BackColor";s:22:"is_marked_as_deleted_4";s:39:"App\Entity\Troubadour\Scenery\BackColor";s:12:"deleted_at_5";s:39:"App\Entity\Troubadour\Scenery\BackColor";}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:10:"is_default";a:1:{i:0;i:0;}}} |
| 128 | 0.42 ms | default | EXEC |
| 129 | 0.48 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Creations_UserChallengeStatus_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 130 | 0.48 ms | default | MGET wVc7zBNi7q:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_2__translations |
| 131 | 0.42 ms | default | MGET wVc7zBNi7q:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_2 wVc7zBNi7q:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_6 |
| 132 | 0.39 ms | default | MGET wVc7zBNi7q:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_3__translations |
| 133 | 0.67 ms | default | MGET wVc7zBNi7q:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_3 wVc7zBNi7q:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_4 |
| 134 | 0.54 ms | default | MGET rhStxpxK6E:App__Entity__Catalog__DifficultyLevel__CLASSMETADATA__ |
| 135 | 0.39 ms | default | MGET rhStxpxK6E:App_Entity_Catalog_DifficultyLevel_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 136 | 0.01 ms | default | MULTI 2 |
| 137 | 0.01 ms | default | SETEX rhStxpxK6E:App_Entity_Catalog_DifficultyLevel_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 138 | 0.40 ms | default | EXEC |
| 139 | 0.34 ms | default | MGET rhStxpxK6E:App__Entity__Catalog__DifficultyLevel__CLASSMETADATA__ |
| 140 | 0.00 ms | default | MULTI 2 |
| 141 | 0.01 ms | default | SETEX rhStxpxK6E: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;}} |
| 142 | 0.44 ms | default | EXEC |
| 143 | 0.41 ms | default | MGET rhStxpxK6E:App__Entity__Constellation__UserChallenge__CLASSMETADATA__ |
| 144 | 0.38 ms | default | MGET rhStxpxK6E:App__Entity__Constellation__ChallengeTemplate__CLASSMETADATA__ |
| 145 | 0.41 ms | default | MGET rhStxpxK6E:App_Entity_Constellation_ChallengeTemplate_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 146 | 0.01 ms | default | MULTI 2 |
| 147 | 0.01 ms | default | SETEX rhStxpxK6E:App_Entity_Constellation_ChallengeTemplate_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 148 | 0.52 ms | default | EXEC |
| 149 | 0.36 ms | default | MGET rhStxpxK6E:App__Entity__Constellation__ChallengeTemplate__CLASSMETADATA__ |
| 150 | 0.01 ms | default | MULTI 2 |
| 151 | 0.02 ms | default | SETEX rhStxpxK6E:App__Entity__Constellation__ChallengeTemplate__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:5:{s:12:"associations";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:12:"associations";s:12:"sourceEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:12:"targetEntity";s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";s:5:"fetch";i:2;s:8:"mappedBy";s:18:"challenge_template";}s:8:"language";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:8:"language";s:12:"sourceEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:12:"targetEntity";s:19:"App\Entity\Language";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:11:"language_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:11:"language_id";s:11:"language_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:11:"language_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:11:"language_id";}}s:8:"subjects";O:48:"Doctrine\ORM\Mapping\ManyToManyOwningSideMapping":8:{s:9:"fieldName";s:8:"subjects";s:12:"sourceEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:12:"targetEntity";s:26:"App\Entity\Catalog\Subject";s:5:"fetch";i:2;s:9:"joinTable";O:37:"Doctrine\ORM\Mapping\JoinTableMapping":4:{s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:11:"template_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:18:"inverseJoinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:10:"subject_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:4:"name";s:27:"challengeTemplates_subjects";s:7:"options";a:0:{}}s:16:"joinTableColumns";a:2:{i:0;s:11:"template_id";i:1;s:10:"subject_id";}s:26:"relationToSourceKeyColumns";a:1:{s:11:"template_id";s:2:"id";}s:26:"relationToTargetKeyColumns";a:1:{s:10:"subject_id";s:2:"id";}}s:13:"content_world";O:46:"Doctrine\ORM\Mapping\OneToOneOwningSideMapping":8:{s:9:"fieldName";s:13:"content_world";s:12:"sourceEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:12:"targetEntity";s:45:"App\Entity\Constellation\ReadingTemplateWorld";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:13:"content_world";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:1;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:13:"content_world";s:13:"content_world";}s:24:"sourceToTargetKeyColumns";a:1:{s:13:"content_world";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:13:"content_world";}}s:14:"original_world";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:14:"original_world";s:12:"sourceEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:12:"targetEntity";s:30:"App\Entity\Constellation\World";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:17:"original_world_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:17:"original_world_id";s:17:"original_world_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:17:"original_world_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:17:"original_world_id";}}}s:11:"columnNames";a:17:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:11:"description";s:11:"description";s:19:"teacher_description";s:19:"teacher_description";s:18:"educational_intent";s:18:"educational_intent";s:21:"additional_activities";s:21:"additional_activities";s:17:"expected_duration";s:17:"expected_duration";s:20:"is_reading_challenge";s:20:"is_reading_challenge";s:23:"printable_questionnaire";s:23:"printable_questionnaire";s:10:"answer_key";s:10:"answer_key";s:6:"images";s:6:"images";s:5:"rules";s:5:"rules";s:8:"disabled";s:8:"disabled";s:11:"island_type";s:11:"island_type";s:14:"is_highlighted";s:14:"is_highlighted";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:13:"fieldMappings";a:17:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:4:"name";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"name";s:10:"columnName";s:4:"name";s:6:"length";i:90;}s:11:"description";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"text";s:9:"fieldName";s:11:"description";s:10:"columnName";s:11:"description";}s:19:"teacher_description";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:19:"teacher_description";s:10:"columnName";s:19:"teacher_description";s:8:"nullable";b:1;}s:18:"educational_intent";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:18:"educational_intent";s:10:"columnName";s:18:"educational_intent";s:8:"nullable";b:1;}s:21:"additional_activities";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:21:"additional_activities";s:10:"columnName";s:21:"additional_activities";s:8:"nullable";b:1;}s:17:"expected_duration";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:17:"expected_duration";s:10:"columnName";s:17:"expected_duration";s:8:"nullable";b:1;}s:20:"is_reading_challenge";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"is_reading_challenge";s:10:"columnName";s:20:"is_reading_challenge";s:7:"options";a:1:{s:7:"default";b:0;}}s:23:"printable_questionnaire";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:23:"printable_questionnaire";s:10:"columnName";s:23:"printable_questionnaire";s:8:"nullable";b:1;}s:10:"answer_key";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:10:"answer_key";s:10:"columnName";s:10:"answer_key";s:8:"nullable";b:1;}s:6:"images";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:12:"simple_array";s:9:"fieldName";s:6:"images";s:10:"columnName";s:6:"images";s:8:"nullable";b:1;}s:5:"rules";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"json";s:9:"fieldName";s:5:"rules";s:10:"columnName";s:5:"rules";}s:8:"disabled";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:8:"disabled";s:10:"columnName";s:8:"disabled";s:7:"options";a:1:{s:7:"default";b:0;}}s:11:"island_type";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:11:"island_type";s:10:"columnName";s:11:"island_type";s:8:"nullable";b:1;}s:14:"is_highlighted";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:14:"is_highlighted";s:10:"columnName";s:14:"is_highlighted";s:7:"options";a:1:{s:7:"default";b:0;}}s:20:"is_marked_as_deleted";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:20:"is_marked_as_deleted";s:10:"columnName";s:20:"is_marked_as_deleted";s:7:"options";a:1:{s:7:"default";b:0;}}s:10:"deleted_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"deleted_at";s:10:"columnName";s:10:"deleted_at";s:8:"nullable";b:1;}}s:10:"fieldNames";a:17:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:11:"description";s:11:"description";s:19:"teacher_description";s:19:"teacher_description";s:18:"educational_intent";s:18:"educational_intent";s:21:"additional_activities";s:21:"additional_activities";s:17:"expected_duration";s:17:"expected_duration";s:20:"is_reading_challenge";s:20:"is_reading_challenge";s:23:"printable_questionnaire";s:23:"printable_questionnaire";s:10:"answer_key";s:10:"answer_key";s:6:"images";s:6:"images";s:5:"rules";s:5:"rules";s:8:"disabled";s:8:"disabled";s:11:"island_type";s:11:"island_type";s:14:"is_highlighted";s:14:"is_highlighted";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:42:"App\Entity\Constellation\ChallengeTemplate";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:2:{s:4:"name";s:17:"ChallengeTemplate";s:6:"quoted";b:1;}s:14:"rootEntityName";s:42:"App\Entity\Constellation\ChallengeTemplate";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;} |
| 152 | 0.53 ms | default | EXEC |
| 153 | 0.48 ms | default | MGET rhStxpxK6E:App__Entity__Constellation__SubWorld__CLASSMETADATA__ |
| 154 | 0.37 ms | default | MGET rhStxpxK6E:App_Entity_Constellation_SubWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 155 | 0.01 ms | default | MULTI 2 |
| 156 | 0.01 ms | default | SETEX rhStxpxK6E:App_Entity_Constellation_SubWorld_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 157 | 0.36 ms | default | EXEC |
| 158 | 0.37 ms | default | MGET rhStxpxK6E:App__Entity__Constellation__SubWorld__CLASSMETADATA__ |
| 159 | 0.00 ms | default | MULTI 2 |
| 160 | 0.02 ms | default | SETEX rhStxpxK6E: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;} |
| 161 | 0.46 ms | default | EXEC |
| 162 | 0.42 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__StoryLocation__CLASSMETADATA__ |
| 163 | 0.38 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Creations_StoryLocation_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 164 | 0.01 ms | default | MULTI 2 |
| 165 | 0.01 ms | default | SETEX rhStxpxK6E:App_Entity_Troubadour_Creations_StoryLocation_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 166 | 0.45 ms | default | EXEC |
| 167 | 6.63 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__StoryLocation__CLASSMETADATA__ |
| 168 | 0.01 ms | default | MULTI 2 |
| 169 | 0.02 ms | default | SETEX rhStxpxK6E:App__Entity__Troubadour__Creations__StoryLocation__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:6:{s:7:"objects";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":6:{s:9:"fieldName";s:7:"objects";s:12:"sourceEntity";s:45:"App\Entity\Troubadour\Creations\StoryLocation";s:12:"targetEntity";s:51:"App\Entity\Troubadour\Creations\StoryLocationObject";s:7:"cascade";a:1:{i:0;s:7:"persist";}s:5:"fetch";i:2;s:8:"mappedBy";s:13:"storyLocation";}s:10:"background";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:10:"background";s:12:"sourceEntity";s:45:"App\Entity\Troubadour\Creations\StoryLocation";s:12:"targetEntity";s:40:"App\Entity\Troubadour\Scenery\Background";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:13:"background_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:13:"background_id";s:13:"background_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:13:"background_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:13:"background_id";}}s:5:"floor";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:5:"floor";s:12:"sourceEntity";s:45:"App\Entity\Troubadour\Creations\StoryLocation";s:12:"targetEntity";s:35:"App\Entity\Troubadour\Scenery\Floor";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"floor_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:"floor_id";s:8:"floor_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"floor_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"floor_id";}}s:10:"foreground";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:10:"foreground";s:12:"sourceEntity";s:45:"App\Entity\Troubadour\Creations\StoryLocation";s:12:"targetEntity";s:40:"App\Entity\Troubadour\Scenery\Foreground";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:13:"foreground_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:13:"foreground_id";s:13:"foreground_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:13:"foreground_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:13:"foreground_id";}}s:9:"backColor";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:9:"backColor";s:12:"sourceEntity";s:45:"App\Entity\Troubadour\Creations\StoryLocation";s:12:"targetEntity";s:39:"App\Entity\Troubadour\Scenery\BackColor";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:13:"back_color_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:13:"back_color_id";s:13:"back_color_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:13:"back_color_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:13:"back_color_id";}}s:13:"originalWorld";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":8:{s:9:"fieldName";s:13:"originalWorld";s:12:"sourceEntity";s:45:"App\Entity\Troubadour\Creations\StoryLocation";s:12:"targetEntity";s:37:"App\Entity\Troubadour\Creations\World";s:5:"fetch";i:2;s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:14:"original_world";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:"original_world";s:14:"original_world";}s:24:"sourceToTargetKeyColumns";a:1:{s:14:"original_world";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:14:"original_world";}}}s:11:"columnNames";a:6:{s:9:"createdAt";s:10:"created_at";s:2:"id";s:2:"id";s:8:"imageURL";s:9:"image_url";s:4:"name";s:4:"name";s:20:"is_marked_as_deleted";s:20:"is_marked_as_deleted";s:10:"deleted_at";s:10:"deleted_at";}s:13:"fieldMappings";a:6:{s:9:"createdAt";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:9:"createdAt";s:10:"columnName";s:10:"created_at";s:8:"nullable";b:1;}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:"imageURL";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:8:"imageURL";s:10:"columnName";s:9:"image_url";}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: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:6:{s:10:"created_at";s:9:"createdAt";s:2:"id";s:2:"id";s:9:"image_url";s:8:"imageURL";s:4:"name";s:4:"name";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:45:"App\Entity\Troubadour\Creations\StoryLocation";s:9:"namespace";s:31:"App\Entity\Troubadour\Creations";s:5:"table";a:2:{s:4:"name";s:19:"troub_StoryLocation";s:6:"quoted";b:1;}s:14:"rootEntityName";s:45:"App\Entity\Troubadour\Creations\StoryLocation";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;} |
| 170 | 2.74 ms | default | EXEC |
| 171 | 0.61 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__RevisionHistory__CLASSMETADATA__ |
| 172 | 0.51 ms | default | MGET rhStxpxK6E:App_Entity_Troubadour_Creations_TextEntries_RevisionHistory_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 173 | 0.01 ms | default | MULTI 2 |
| 174 | 0.01 ms | default | SETEX rhStxpxK6E:App_Entity_Troubadour_Creations_TextEntries_RevisionHistory_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 175 | 0.44 ms | default | EXEC |
| 176 | 0.41 ms | default | MGET rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__RevisionHistory__CLASSMETADATA__ |
| 177 | 0.01 ms | default | MULTI 2 |
| 178 | 0.01 ms | default | SETEX rhStxpxK6E:App__Entity__Troubadour__Creations__TextEntries__RevisionHistory__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:1:{s:8:"revision";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":10:{s:9:"fieldName";s:8:"revision";s:12:"sourceEntity";s:59:"App\Entity\Troubadour\Creations\TextEntries\RevisionHistory";s:12:"targetEntity";s:52:"App\Entity\Troubadour\Creations\TextEntries\Revision";s:7:"cascade";a:1:{i:0;s:7:"persist";}s:5:"fetch";i:2;s:10:"inversedBy";s:7:"history";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:10:"revisionId";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:"revisionId";s:10:"revisionId";}s:24:"sourceToTargetKeyColumns";a:1:{s:10:"revisionId";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:10:"revisionId";}}}s:11:"columnNames";a:5:{s:2:"id";s:2:"id";s:4:"text";s:4:"text";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: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:"text";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:4:"text";s:10:"columnName";s:4:"text";s:8:"nullable";b:1;}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:5:{s:2:"id";s:2:"id";s:4:"text";s:4:"text";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:59:"App\Entity\Troubadour\Creations\TextEntries\RevisionHistory";s:9:"namespace";s:43:"App\Entity\Troubadour\Creations\TextEntries";s:5:"table";a:2:{s:4:"name";s:21:"troub_RevisionHistory";s:6:"quoted";b:1;}s:14:"rootEntityName";s:59:"App\Entity\Troubadour\Creations\TextEntries\RevisionHistory";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;} |
| 179 | 0.42 ms | default | EXEC |
| 180 | 0.47 ms | default | SETEX nanomonx_dev_73bf9052519923d166fe2752b9e21c0e 86400 _sf2_attributes|a:18:{s:20:"DeviceDetector_setup";b:1;s:20:"DeviceDetector_isBot";b:1;s:24:"DeviceDetector_hasClient";b:0;s:24:"DeviceDetector_isDesktop";b:0;s:23:"DeviceDetector_isTablet";b:0;s:23:"DeviceDetector_isMobile";b:0;s:17:"DeviceDetector_os";N;s:26:"DeviceDetector_client_name";N;s:29:"DeviceDetector_client_version";N;s:4:"lang";s:5:"en-CA";s:24:"_csrf/https-authenticate";s:43:"yp5xEyrWJpFQk-u_FKcXmQXUo7t2ckr_xEgv16L-Kcs";s:19:"demo_textEntryCount";i:0;s:19:"demo_revisionsCount";i:0;s:21:"demo_worldObjectCount";i:0;s:16:"demo_textEntries";a:3:{i:2902;a:4:{s:2:"id";i:2902;s:8:"position";i:0;s:9:"revisions";a:0:{}s:6:"status";N;}i:2903;a:4:{s:2:"id";i:2903;s:8:"position";i:1;s:9:"revisions";a:0:{}s:6:"status";N;}i:2904;a:4:{s:2:"id";i:2904;s:8:"position";i:0;s:9:"revisions";a:0:{}s:6:"status";N;}}s:11:"demo_worlds";a:0:{}s:18:"demo_world_objects";a:0:{}s:12:"demo_student";a:4:{s:2:"id";i:1910;s:11:"displayName";s:23:"Demo_Student_User_en-CA";s:4:"type";s:12:"ROLE_STUDENT";s:8:"username";s:23:"Demo_Student_User_en-CA";}}_sf2_meta|a:3:{s:1:"u";i:1762082852;s:1:"c";i:1762082852;s:1:"l";i:604800;} |