GET https://troubadour.constellation.cool/demo/construction

Commands

13 Queries
57.55 ms Query time
0 Failed Queries
# Time Connection Command
1 41.89 ms default CONNECT tls://constellation-web-develop-cache-3ighqi.serverless.cac1.cache.amazonaws.com 6379 5 <null> 5 5
2 2.00 ms default AUTH constellation-web-develop-user S2`H4!JqKNVn9|.;LT|=
3 1.67 ms default MGET ZRryLdu-gC:DateTime__CLASSMETADATA__
4 1.36 ms default MGET ZRryLdu-gC:DateTime__CLASSMETADATA__
5 1.45 ms default MGET QSr8iX8b3p:3617861b8dc0bece3bc401bdd65eaa2d
6 0.01 ms default MULTI 2
7 0.02 ms default SETEX QSr8iX8b3p:3617861b8dc0bece3bc401bdd65eaa2d 86400 O:31:"Doctrine\ORM\Query\ParserResult":4:{s:44:"Doctrine\ORM\Query\ParserResultsqlExecutor";N;s:45:"Doctrine\ORM\Query\ParserResultsqlFinalizer";O:48:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizer":1:{s:53:"Doctrine\ORM\Query\Exec\SingleSelectSqlFinalizersql";s:1247:"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_.isValidEmail AS isValidEmail_13, u0_.firstName AS firstName_14, u0_.lastName AS lastName_15, u0_.schoolName AS schoolName_16, u0_.schoolBoardName AS schoolBoardName_17, u0_.isFromAnotherCountry AS isFromAnotherCountry_18, u0_.isNanomonx AS isNanomonx_19, u0_.newsletter AS newsletter_20, u0_.free_trial_used AS free_trial_used_21, u0_.stripe_customer_id AS stripe_customer_id_22, u0_.is_evaluated_as_freemium AS is_evaluated_as_freemium_23, u0_.type AS type_24, u0_.country_id AS country_id_25, u0_.onBoarding_status AS onBoarding_status_26, u0_.educatonal_pathway_id AS educatonal_pathway_id_27, u0_.usage_type_id AS usage_type_id_28, u0_.user_region_id AS user_region_id_29, u0_.educational_institution AS educational_institution_30, u0_.language_id AS language_id_31 FROM `User` u0_ WHERE (u0_.username = ?) AND u0_.type IN ('ROLE_MANAGER')";}s:49:"Doctrine\ORM\Query\ParserResultresultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":23:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:1:{s:6:"entity";s:18:"App\Entity\Manager";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:24:{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:"isValidEmail_13";s:12:"isValidEmail";s:12:"firstName_14";s:9:"firstName";s:11:"lastName_15";s:8:"lastName";s:13:"schoolName_16";s:10:"schoolName";s:18:"schoolBoardName_17";s:15:"schoolBoardName";s:23:"isFromAnotherCountry_18";s:20:"isFromAnotherCountry";s:13:"isNanomonx_19";s:10:"isNanomonx";s:13:"newsletter_20";s:10:"newsletter";s:18:"free_trial_used_21";s:15:"free_trial_used";s:21:"stripe_customer_id_22";s:16:"stripeCustomerID";s:27:"is_evaluated_as_freemium_23";s:21:"isEvaluatedAsFreemium";}s:19:"columnAliasMappings";a:1:{s:18:"App\Entity\Manager";a:1:{s:6:"entity";a:24:{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:12:"isValidEmail";s:15:"isValidEmail_13";s:9:"firstName";s:12:"firstName_14";s:8:"lastName";s:11:"lastName_15";s:10:"schoolName";s:13:"schoolName_16";s:15:"schoolBoardName";s:18:"schoolBoardName_17";s:20:"isFromAnotherCountry";s:23:"isFromAnotherCountry_18";s:10:"isNanomonx";s:13:"isNanomonx_19";s:10:"newsletter";s:13:"newsletter_20";s:15:"free_trial_used";s:18:"free_trial_used_21";s:16:"stripeCustomerID";s:21:"stripe_customer_id_22";s:21:"isEvaluatedAsFreemium";s:27:"is_evaluated_as_freemium_23";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:1:{s:23:"anonymization_status_12";s:30:"App\Entity\AnonymizationStatus";}s:12:"typeMappings";a:8:{s:7:"type_24";s:6:"string";s:13:"country_id_25";s:7:"integer";s:20:"onBoarding_status_26";s:7:"integer";s:24:"educatonal_pathway_id_27";s:7:"integer";s:16:"usage_type_id_28";s:7:"integer";s:17:"user_region_id_29";s:7:"integer";s:26:"educational_institution_30";s:7:"integer";s:14:"language_id_31";s:7:"integer";}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:8:{s:7:"type_24";s:4:"type";s:13:"country_id_25";s:10:"country_id";s:20:"onBoarding_status_26";s:17:"onBoarding_status";s:24:"educatonal_pathway_id_27";s:21:"educatonal_pathway_id";s:16:"usage_type_id_28";s:13:"usage_type_id";s:17:"user_region_id_29";s:14:"user_region_id";s:26:"educational_institution_30";s:23:"educational_institution";s:14:"language_id_31";s:11:"language_id";}s:14:"columnOwnerMap";a:32:{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:"isValidEmail_13";s:6:"entity";s:12:"firstName_14";s:6:"entity";s:11:"lastName_15";s:6:"entity";s:13:"schoolName_16";s:6:"entity";s:18:"schoolBoardName_17";s:6:"entity";s:23:"isFromAnotherCountry_18";s:6:"entity";s:13:"isNanomonx_19";s:6:"entity";s:13:"newsletter_20";s:6:"entity";s:18:"free_trial_used_21";s:6:"entity";s:21:"stripe_customer_id_22";s:6:"entity";s:27:"is_evaluated_as_freemium_23";s:6:"entity";s:7:"type_24";s:6:"entity";s:13:"country_id_25";s:6:"entity";s:20:"onBoarding_status_26";s:6:"entity";s:24:"educatonal_pathway_id_27";s:6:"entity";s:16:"usage_type_id_28";s:6:"entity";s:17:"user_region_id_29";s:6:"entity";s:26:"educational_institution_30";s:6:"entity";s:14:"language_id_31";s:6:"entity";}s:20:"discriminatorColumns";a:1:{s:6:"entity";s:7:"type_24";}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:24:{s:4:"id_0";s:18:"App\Entity\Manager";s:13:"displayName_1";s:18:"App\Entity\Manager";s:10:"username_2";s:18:"App\Entity\Manager";s:10:"password_3";s:18:"App\Entity\Manager";s:6:"salt_4";s:18:"App\Entity\Manager";s:12:"created_at_5";s:18:"App\Entity\Manager";s:13:"last_active_6";s:18:"App\Entity\Manager";s:6:"data_7";s:18:"App\Entity\Manager";s:11:"google_id_8";s:18:"App\Entity\Manager";s:11:"character_9";s:18:"App\Entity\Manager";s:10:"version_10";s:18:"App\Entity\Manager";s:16:"anonymized_at_11";s:18:"App\Entity\Manager";s:23:"anonymization_status_12";s:18:"App\Entity\Manager";s:15:"isValidEmail_13";s:18:"App\Entity\Manager";s:12:"firstName_14";s:18:"App\Entity\Manager";s:11:"lastName_15";s:18:"App\Entity\Manager";s:13:"schoolName_16";s:18:"App\Entity\Manager";s:18:"schoolBoardName_17";s:18:"App\Entity\Manager";s:23:"isFromAnotherCountry_18";s:18:"App\Entity\Manager";s:13:"isNanomonx_19";s:18:"App\Entity\Manager";s:13:"newsletter_20";s:18:"App\Entity\Manager";s:18:"free_trial_used_21";s:18:"App\Entity\Manager";s:21:"stripe_customer_id_22";s:18:"App\Entity\Manager";s:27:"is_evaluated_as_freemium_23";s:18:"App\Entity\Manager";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:9:"newObject";a:0:{}s:24:"nestedNewObjectArguments";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}s:14:"nestedEntities";a:0:{}}s:50:"Doctrine\ORM\Query\ParserResultparameterMappings";a:1:{s:8:"username";a:1:{i:0;i:0;}}}
8 1.56 ms default EXEC
9 1.46 ms default MGET sb45PD+FPM:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_2__translations
10 1.38 ms default MGET sb45PD+FPM:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_2 sb45PD+FPM:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_6
11 1.32 ms default MGET sb45PD+FPM:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_3__translations
12 2.03 ms default MGET sb45PD+FPM:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_3 sb45PD+FPM:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_4
13 1.41 ms default SETEX nanomonx_dev_5a1081032eab528658000dfb10fb1ed3 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: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";}s:24:"_csrf/https-authenticate";s:43:"L8Rt0phFDrKQvW8xuhutjCSTf79krJ2q3qY8yUgmpKQ";}_sf2_meta|a:3:{s:1:"u";i:1753640754;s:1:"c";i:1753640754;s:1:"l";i:604800;}