GET https://www.constellation.cool/acheter/organisation

Commands

40 Queries
43.68 ms Query time
0 Failed Queries
# Time Connection Command
1 15.29 ms default CONNECT tls://constellation-web-develop-cache-3ighqi.serverless.cac1.cache.amazonaws.com 6379 5 <null> 5 5
2 15.31 ms default AUTH constellation-web-develop-user =N,m.3}{s4^o~itMWGp{
3 0.73 ms default MGET JmctMd--99:DateTime__CLASSMETADATA__
4 0.51 ms default MGET JmctMd--99:DateTime__CLASSMETADATA__
5 0.66 ms default MGET IhHtSSNxIS:005e0d2e976e8f8389b4f75c18e14359
6 0.01 ms default MULTI 2
7 0.01 ms default SETEX IhHtSSNxIS:005e0d2e976e8f8389b4f75c18e14359 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:284:"SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.tag AS tag_2, c0_.currency AS currency_3, c0_.currency_symbol AS currency_symbol_4, c0_.is_default AS is_default_5, c0_.`translations` AS translations_6, c0_.school_calendar_id AS school_calendar_id_7 FROM `Country` c0_ WHERE c0_.tag = ?";}s:49:"Doctrine\ORM\Query\ParserResultresultSetMapping";O:35:"Doctrine\ORM\Query\ResultSetMapping":23:{s:7:"isMixed";b:0;s:8:"isSelect";b:1;s:8:"aliasMap";a:1:{s:6:"entity";s:18:"App\Entity\Country";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:7:{s:4:"id_0";s:2:"id";s:6:"name_1";s:4:"name";s:5:"tag_2";s:3:"tag";s:10:"currency_3";s:8:"currency";s:17:"currency_symbol_4";s:15:"currency_symbol";s:12:"is_default_5";s:10:"is_default";s:14:"translations_6";s:12:"translations";}s:19:"columnAliasMappings";a:1:{s:18:"App\Entity\Country";a:1:{s:6:"entity";a:7:{s:2:"id";s:4:"id_0";s:4:"name";s:6:"name_1";s:3:"tag";s:5:"tag_2";s:8:"currency";s:10:"currency_3";s:15:"currency_symbol";s:17:"currency_symbol_4";s:10:"is_default";s:12:"is_default_5";s:12:"translations";s:14:"translations_6";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:1:{s:20:"school_calendar_id_7";s:7:"integer";}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:1:{s:20:"school_calendar_id_7";s:18:"school_calendar_id";}s:14:"columnOwnerMap";a:8:{s:4:"id_0";s:6:"entity";s:6:"name_1";s:6:"entity";s:5:"tag_2";s:6:"entity";s:10:"currency_3";s:6:"entity";s:17:"currency_symbol_4";s:6:"entity";s:12:"is_default_5";s:6:"entity";s:14:"translations_6";s:6:"entity";s:20:"school_calendar_id_7";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:7:{s:4:"id_0";s:18:"App\Entity\Country";s:6:"name_1";s:18:"App\Entity\Country";s:5:"tag_2";s:18:"App\Entity\Country";s:10:"currency_3";s:18:"App\Entity\Country";s:17:"currency_symbol_4";s:18:"App\Entity\Country";s:12:"is_default_5";s:18:"App\Entity\Country";s:14:"translations_6";s:18:"App\Entity\Country";}s:18:"isIdentifierColumn";a:0:{}s:17:"newObjectMappings";a:0:{}s:9:"newObject";a:0:{}s:24:"nestedNewObjectArguments";a:0:{}s:24:"metadataParameterMapping";a:0:{}s:23:"discriminatorParameters";a:0:{}s:14:"nestedEntities";a:0:{}}s:50:"Doctrine\ORM\Query\ParserResultparameterMappings";a:1:{s:3:"tag";a:1:{i:0;i:0;}}}
8 0.66 ms default EXEC
9 0.62 ms default MGET cM5-QN4b5D:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_2__translations
10 0.58 ms default MGET cM5-QN4b5D:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_2 cM5-QN4b5D:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_6
11 0.42 ms default MGET cM5-QN4b5D:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_3__translations
12 1.08 ms default MGET cM5-QN4b5D:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_3 cM5-QN4b5D:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_4
13 0.61 ms default MGET JmctMd--99:App__Entity__Catalog__GradeLevel__CLASSMETADATA__
14 0.46 ms default MGET JmctMd--99:App_Entity_Catalog_GradeLevel_$GEDMO_TRANSLATABLE_CLASSMETADATA
15 0.01 ms default MULTI 2
16 0.01 ms default SETEX JmctMd--99:App_Entity_Catalog_GradeLevel_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
17 0.44 ms default EXEC
18 0.37 ms default MGET JmctMd--99:App__Entity__Catalog__GradeLevel__CLASSMETADATA__
19 0.01 ms default MULTI 2
20 0.02 ms default SETEX JmctMd--99:App__Entity__Catalog__GradeLevel__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:2:{s:17:"difficulty_levels";O:49:"Doctrine\ORM\Mapping\ManyToManyInverseSideMapping":5:{s:9:"fieldName";s:17:"difficulty_levels";s:12:"sourceEntity";s:29:"App\Entity\Catalog\GradeLevel";s:12:"targetEntity";s:34:"App\Entity\Catalog\DifficultyLevel";s:5:"fetch";i:2;s:8:"mappedBy";s:12:"grade_levels";}s:19:"educational_pathway";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:19:"educational_pathway";s:12:"sourceEntity";s:29:"App\Entity\Catalog\GradeLevel";s:12:"targetEntity";s:31:"App\Entity\Catalog\ScholarLevel";s:5:"fetch";i:2;s:10:"inversedBy";s:12:"grade_levels";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:22:"educational_pathway_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:22:"educational_pathway_id";s:22:"educational_pathway_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:22:"educational_pathway_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:22:"educational_pathway_id";}}}s:11:"columnNames";a:5:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:13:"display_order";s:13:"display_order";s:12:"translations";s:12:"translations";s:11:"description";s:11:"description";}s:13:"fieldMappings";a:5:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:4:"name";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"name";s:10:"columnName";s:4:"name";}s:13:"display_order";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"integer";s:9:"fieldName";s:13:"display_order";s:10:"columnName";s:13:"display_order";}s:12:"translations";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"json";s:9:"fieldName";s:12:"translations";s:10:"columnName";s:12:"translations";}s:11:"description";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"json";s:9:"fieldName";s:11:"description";s:10:"columnName";s:11:"description";s:8:"nullable";b:1;}}s:10:"fieldNames";a:5:{s:2:"id";s:2:"id";s:4:"name";s:4:"name";s:13:"display_order";s:13:"display_order";s:12:"translations";s:12:"translations";s:11:"description";s:11:"description";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:29:"App\Entity\Catalog\GradeLevel";s:9:"namespace";s:18:"App\Entity\Catalog";s:5:"table";a:2:{s:4:"name";s:10:"GradeLevel";s:6:"quoted";b:1;}s:14:"rootEntityName";s:29:"App\Entity\Catalog\GradeLevel";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;}}
21 0.57 ms default EXEC
22 0.40 ms default MGET JmctMd--99:App__Entity__Constellation__ChallengeTemplateAssociation__CLASSMETADATA__
23 0.39 ms default MGET JmctMd--99:App_Entity_Constellation_ChallengeTemplateAssociation_$GEDMO_TRANSLATABLE_CLASSMETADATA
24 0.01 ms default MULTI 2
25 0.01 ms default SETEX JmctMd--99:App_Entity_Constellation_ChallengeTemplateAssociation_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
26 0.41 ms default EXEC
27 0.41 ms default MGET JmctMd--99:App__Entity__Constellation__ChallengeTemplateAssociation__CLASSMETADATA__
28 0.01 ms default MULTI 2
29 0.01 ms default SETEX JmctMd--99:App__Entity__Constellation__ChallengeTemplateAssociation__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:3:{s:18:"challenge_template";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:18:"challenge_template";s:12:"sourceEntity";s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";s:12:"targetEntity";s:42:"App\Entity\Constellation\ChallengeTemplate";s:5:"fetch";i:2;s:10:"inversedBy";s:12:"associations";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:21:"challenge_template_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:21:"challenge_template_id";s:21:"challenge_template_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:21:"challenge_template_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:21:"challenge_template_id";}}s:19:"educational_pathway";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:19:"educational_pathway";s:12:"sourceEntity";s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";s:12:"targetEntity";s:31:"App\Entity\Catalog\ScholarLevel";s:5:"fetch";i:2;s:10:"inversedBy";s:26:"constellation_associations";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:22:"educational_pathway_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:22:"educational_pathway_id";s:22:"educational_pathway_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:22:"educational_pathway_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:22:"educational_pathway_id";}}s:17:"difficulty_levels";O:48:"Doctrine\ORM\Mapping\ManyToManyOwningSideMapping":9:{s:9:"fieldName";s:17:"difficulty_levels";s:12:"sourceEntity";s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";s:12:"targetEntity";s:34:"App\Entity\Catalog\DifficultyLevel";s:5:"fetch";i:2;s:10:"inversedBy";s:26:"constellation_associations";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:"association_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:44:"challengeTemplateAssociation_difficultyLevel";s:7:"options";a:0:{}}s:16:"joinTableColumns";a:2:{i:0;s:19:"difficulty_level_id";i:1;s:14:"association_id";}s:26:"relationToSourceKeyColumns";a:1:{s:19:"difficulty_level_id";s:2:"id";}s:26:"relationToTargetKeyColumns";a:1:{s:14:"association_id";s:2:"id";}}}s:11:"columnNames";a:1:{s:2:"id";s:2:"id";}s:13:"fieldMappings";a: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:10:"fieldNames";a:1:{s:2:"id";s:2:"id";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";s:9:"namespace";s:24:"App\Entity\Constellation";s:5:"table";a:2:{s:4:"name";s:28:"ChallengeTemplateAssociation";s:6:"quoted";b:1;}s:14:"rootEntityName";s:53:"App\Entity\Constellation\ChallengeTemplateAssociation";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:33:"App\Repository\NanomonxRepository";s:13:"generatorType";i:4;}
30 0.55 ms default EXEC
31 0.42 ms default MGET JmctMd--99:App__Entity__Purchases__Package__CLASSMETADATA__
32 0.42 ms default MGET JmctMd--99:App_Entity_Purchases_Package_$GEDMO_TRANSLATABLE_CLASSMETADATA
33 0.01 ms default MULTI 2
34 0.01 ms default SETEX JmctMd--99:App_Entity_Purchases_Package_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:3:{s:6:"fields";a:1:{i:0;s:4:"name";}s:6:"locale";s:6:"locale";s:14:"useObjectClass";s:28:"App\Entity\Purchases\Package";}
35 0.53 ms default EXEC
36 0.52 ms default MGET JmctMd--99:App__Entity__Purchases__Package__CLASSMETADATA__
37 0.01 ms default MULTI 2
38 0.01 ms default SETEX JmctMd--99:App__Entity__Purchases__Package__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:2:{s:21:"package_subscriptions";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":5:{s:9:"fieldName";s:21:"package_subscriptions";s:12:"sourceEntity";s:28:"App\Entity\Purchases\Package";s:12:"targetEntity";s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:5:"fetch";i:2;s:8:"mappedBy";s:7:"package";}s:6:"prices";O:48:"Doctrine\ORM\Mapping\OneToManyAssociationMapping":8:{s:9:"fieldName";s:6:"prices";s:12:"sourceEntity";s:28:"App\Entity\Purchases\Package";s:12:"targetEntity";s:26:"App\Entity\Purchases\Price";s:7:"cascade";a:2:{i:0;s:7:"persist";i:1;s:6:"remove";}s:5:"fetch";i:2;s:5:"cache";a:2:{s:5:"usage";i:2;s:6:"region";s:8:"nanomonx";}s:13:"orphanRemoval";b:1;s:8:"mappedBy";s:7:"package";}}s:11:"columnNames";a:5:{s:2:"id";s:2:"id";s:4:"type";s:4:"type";s:9:"zoho_name";s:9:"zoho_name";s:17:"stripe_product_id";s:17:"stripe_product_id";s:4:"name";s:4:"name";}s:13:"fieldMappings";a:5:{s:2:"id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"integer";s:9:"fieldName";s:2:"id";s:10:"columnName";s:2:"id";s:2:"id";b:1;}s:4:"type";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"type";s:10:"columnName";s:4:"type";s:6:"unique";b:1;s:8:"enumType";s:32:"App\Entity\Purchases\PackageType";}s:9:"zoho_name";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:9:"zoho_name";s:10:"columnName";s:9:"zoho_name";s:8:"nullable";b:1;}s:17:"stripe_product_id";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:17:"stripe_product_id";s:10:"columnName";s:17:"stripe_product_id";s:8:"nullable";b:1;}s:4:"name";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"name";s:10:"columnName";s:4:"name";s:8:"nullable";b:1;}}s:10:"fieldNames";a:5:{s:2:"id";s:2:"id";s:4:"type";s:4:"type";s:9:"zoho_name";s:9:"zoho_name";s:17:"stripe_product_id";s:17:"stripe_product_id";s:4:"name";s:4:"name";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:28:"App\Entity\Purchases\Package";s:9:"namespace";s:20:"App\Entity\Purchases";s:5:"table";a:1:{s:4:"name";s:7:"Package";}s:14:"rootEntityName";s:28:"App\Entity\Purchases\Package";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:32:"App\Repository\PackageRepository";s:13:"generatorType";i:4;s:5:"cache";a:2:{s:6:"region";s:8:"nanomonx";s:5:"usage";i:2;}}
39 0.70 ms default EXEC
40 0.52 ms default SETEX nanomonx_dev_6a12f88e6ee13d7c9f44530295f4e179 86400 _sf2_attributes|a:5:{s:4:"lang";s:5:"fr-CA";s:7:"country";s:2:"US";s:18:"is_default_country";b:0;s:22:"_csrf/https-quote_form";s:43:"ymtRq3MRqte7Xz-kuUU9t6HX79NCMF0aKvUsuQ0zZEY";s:24:"_csrf/https-authenticate";s:43:"6gkgNEGdnRWyhg_LzqelJJKjwSZES-PCMqiU6caI__Q";}_sf2_meta|a:3:{s:1:"u";i:1762461865;s:1:"c";i:1762461865;s:1:"l";i:604800;}