GET https://constellation.constellation.cool/buy

Commands

42 Queries
29.58 ms Query time
0 Failed Queries
# Time Connection Command
1 15.96 ms default CONNECT tls://constellation-web-develop-cache-3ighqi.serverless.cac1.cache.amazonaws.com 6379 5 <null> 5 5
2 1.48 ms default AUTH constellation-web-develop-user 6a~4dj-P+G5vhC9pC!$#
3 0.73 ms default MGET 4GCzUd17WO:DateTime__CLASSMETADATA__
4 0.43 ms default MGET 4GCzUd17WO:DateTime__CLASSMETADATA__
5 0.51 ms default MGET XVNmqgbvR9:3587fbd182bf16b29935b9ecf700410b
6 0.01 ms default MULTI 2
7 0.01 ms default SETEX XVNmqgbvR9:3587fbd182bf16b29935b9ecf700410b 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:173:"SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.zoho_name AS zoho_name_2, p0_.stripe_product_id AS stripe_product_id_3, p0_.name AS name_4 FROM Package p0_ WHERE p0_.type = ?";}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:28:"App\Entity\Purchases\Package";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:5:{s:4:"id_0";s:2:"id";s:6:"type_1";s:4:"type";s:11:"zoho_name_2";s:9:"zoho_name";s:19:"stripe_product_id_3";s:17:"stripe_product_id";s:6:"name_4";s:4:"name";}s:19:"columnAliasMappings";a:1:{s:28:"App\Entity\Purchases\Package";a:1:{s:6:"entity";a:5:{s:2:"id";s:4:"id_0";s:4:"type";s:6:"type_1";s:9:"zoho_name";s:11:"zoho_name_2";s:17:"stripe_product_id";s:19:"stripe_product_id_3";s:4:"name";s:6:"name_4";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:1:{s:6:"type_1";s:32:"App\Entity\Purchases\PackageType";}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:5:{s:4:"id_0";s:6:"entity";s:6:"type_1";s:6:"entity";s:11:"zoho_name_2";s:6:"entity";s:19:"stripe_product_id_3";s:6:"entity";s:6:"name_4";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:5:{s:4:"id_0";s:28:"App\Entity\Purchases\Package";s:6:"type_1";s:28:"App\Entity\Purchases\Package";s:11:"zoho_name_2";s:28:"App\Entity\Purchases\Package";s:19:"stripe_product_id_3";s:28:"App\Entity\Purchases\Package";s:6:"name_4";s:28:"App\Entity\Purchases\Package";}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:4:"type";a:1:{i:0;i:0;}}}
8 0.50 ms default EXEC
9 0.46 ms default MGET 4GCzUd17WO:Gedmo__Translatable__Entity__Translation__CLASSMETADATA__
10 0.44 ms default MGET 4GCzUd17WO:Gedmo_Translatable_Entity_Translation_$GEDMO_TRANSLATABLE_CLASSMETADATA
11 0.01 ms default MULTI 2
12 0.01 ms default SETEX 4GCzUd17WO:Gedmo_Translatable_Entity_Translation_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
13 0.38 ms default EXEC
14 0.37 ms default MGET 4GCzUd17WO:Gedmo__Translatable__Entity__MappedSuperclass__AbstractTranslation__CLASSMETADATA__ 4GCzUd17WO:Gedmo__Translatable__Entity__Translation__CLASSMETADATA__
15 0.01 ms default MULTI 2
16 0.01 ms default SETEX 4GCzUd17WO:Gedmo__Translatable__Entity__MappedSuperclass__AbstractTranslation__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:0:{}s:11:"columnNames";a:6:{s:2:"id";s:2:"id";s:6:"locale";s:6:"locale";s:11:"objectClass";s:12:"object_class";s:5:"field";s:5:"field";s:10:"foreignKey";s:11:"foreign_key";s:7:"content";s:7:"content";}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:6:"locale";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:6:"locale";s:10:"columnName";s:6:"locale";s:6:"length";i:8;}s:11:"objectClass";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:11:"objectClass";s:10:"columnName";s:12:"object_class";s:6:"length";i:191;}s:5:"field";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:5:"field";s:10:"columnName";s:5:"field";s:6:"length";i:32;}s:10:"foreignKey";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:10:"foreignKey";s:10:"columnName";s:11:"foreign_key";s:6:"length";i:64;}s:7:"content";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:7:"content";s:10:"columnName";s:7:"content";s:8:"nullable";b:1;}}s:10:"fieldNames";a:6:{s:2:"id";s:2:"id";s:6:"locale";s:6:"locale";s:12:"object_class";s:11:"objectClass";s:5:"field";s:5:"field";s:11:"foreign_key";s:10:"foreignKey";s:7:"content";s:7:"content";}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:"Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation";s:9:"namespace";s:42:"Gedmo\Translatable\Entity\MappedSuperclass";s:5:"table";a:1:{s:4:"name";s:20:"abstract_translation";}s:14:"rootEntityName";s:62:"Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:13:"generatorType";i:4;s:18:"isMappedSuperclass";b:1;}
17 0.01 ms default SETEX 4GCzUd17WO:Gedmo__Translatable__Entity__Translation__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":14:{s:19:"associationMappings";a:0:{}s:11:"columnNames";a:6:{s:2:"id";s:2:"id";s:6:"locale";s:6:"locale";s:11:"objectClass";s:12:"object_class";s:5:"field";s:5:"field";s:10:"foreignKey";s:11:"foreign_key";s:7:"content";s:7:"content";}s:13:"fieldMappings";a:6:{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:62:"Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation";}s:6:"locale";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:6:"locale";s:10:"columnName";s:6:"locale";s:6:"length";i:8;s:8:"declared";s:62:"Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation";}s:11:"objectClass";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:11:"objectClass";s:10:"columnName";s:12:"object_class";s:6:"length";i:191;s:8:"declared";s:62:"Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation";}s:5:"field";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:5:"field";s:10:"columnName";s:5:"field";s:6:"length";i:32;s:8:"declared";s:62:"Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation";}s:10:"foreignKey";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:10:"foreignKey";s:10:"columnName";s:11:"foreign_key";s:6:"length";i:64;s:8:"declared";s:62:"Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation";}s:7:"content";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:4:"text";s:9:"fieldName";s:7:"content";s:10:"columnName";s:7:"content";s:8:"nullable";b:1;s:8:"declared";s:62:"Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation";}}s:10:"fieldNames";a:6:{s:2:"id";s:2:"id";s:6:"locale";s:6:"locale";s:12:"object_class";s:11:"objectClass";s:5:"field";s:5:"field";s:11:"foreign_key";s:10:"foreignKey";s:7:"content";s:7:"content";}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:"Gedmo\Translatable\Entity\Translation";s:9:"namespace";s:25:"Gedmo\Translatable\Entity";s:5:"table";a:4:{s:4:"name";s:16:"ext_translations";s:7:"indexes";a:2:{s:23:"translations_lookup_idx";a:1:{s:7:"columns";a:3:{i:0;s:6:"locale";i:1;s:12:"object_class";i:2;s:11:"foreign_key";}}s:31:"general_translations_lookup_idx";a:1:{s:7:"columns";a:2:{i:0;s:12:"object_class";i:1;s:11:"foreign_key";}}}s:17:"uniqueConstraints";a:1:{s:17:"lookup_unique_idx";a:1:{s:7:"columns";a:4:{i:0;s:6:"locale";i:1;s:12:"object_class";i:2;s:5:"field";i:3;s:11:"foreign_key";}}}s:7:"options";a:1:{s:10:"row_format";s:7:"DYNAMIC";}}s:14:"rootEntityName";s:37:"Gedmo\Translatable\Entity\Translation";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:58:"Gedmo\Translatable\Entity\Repository\TranslationRepository";s:13:"generatorType";i:4;}
18 0.67 ms default EXEC
19 0.39 ms default MGET XVNmqgbvR9:696e8874bd13b3e5d153c78848f95b2f
20 0.01 ms default MULTI 2
21 0.01 ms default SETEX XVNmqgbvR9:696e8874bd13b3e5d153c78848f95b2f 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:149:"SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?";}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:0:{}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:0:{}s:19:"columnAliasMappings";a:0:{}s:14:"scalarMappings";a:2:{s:9:"content_0";s:7:"content";s:7:"field_1";s:5:"field";}s:12:"enumMappings";a:0:{}s:12:"typeMappings";a:2:{s:9:"content_0";s:4:"text";s:7:"field_1";s:6:"string";}s:14:"entityMappings";a:0:{}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:0:{}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:0:{}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:3:{s:8:"objectId";a:1:{i:0;i:0;}s:6:"locale";a:1:{i:0;i:1;}s:11:"objectClass";a:1:{i:0;i:2;}}}
22 0.44 ms default EXEC
23 0.52 ms default MGET g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.schoolcalendar_1
24 0.44 ms default MGET 4GCzUd17WO:App_Entity_SchoolCalendar_$GEDMO_TRANSLATABLE_CLASSMETADATA
25 0.38 ms default MGET g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.schoolcalendar_1
26 0.01 ms default MULTI 2
27 0.01 ms default SETEX g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.schoolcalendar_1 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:25:"App\Entity\SchoolCalendar";s:4:"data";a:4:{s:2:"id";i:1;s:4:"name";s:26:"North American School year";s:15:"schoolYearStart";O:8:"DateTime":3:{s:4:"date";s:26:"2000-09-01 15:02:28.000000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}s:15:"purchaseOpenDay";O:8:"DateTime":3:{s:4:"date";s:26:"2000-04-01 15:02:28.000000";s:13:"timezone_type";i:3;s:8:"timezone";s:3:"UTC";}}}
28 0.38 ms default EXEC
29 0.50 ms default MGET g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_2__translations
30 0.51 ms default MGET g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_2 g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_6
31 0.43 ms default MGET g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_3__translations
32 0.90 ms default MGET g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_3 g4p1MjfIh-:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_4
33 0.48 ms default MGET 4GCzUd17WO:App__Entity__SubscriptionDealing__BaseCode__CLASSMETADATA__
34 0.45 ms default MGET 4GCzUd17WO:App_Entity_SubscriptionDealing_BaseCode_$GEDMO_TRANSLATABLE_CLASSMETADATA
35 0.01 ms default MULTI 2
36 0.01 ms default SETEX 4GCzUd17WO:App_Entity_SubscriptionDealing_BaseCode_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{}
37 0.42 ms default EXEC
38 0.38 ms default MGET 4GCzUd17WO:App__Entity__SubscriptionDealing__BaseCode__CLASSMETADATA__
39 0.01 ms default MULTI 2
40 0.01 ms default SETEX 4GCzUd17WO:App__Entity__SubscriptionDealing__BaseCode__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":21:{s:19:"associationMappings";a:1:{s:12:"subscription";O:46:"Doctrine\ORM\Mapping\OneToOneOwningSideMapping":9:{s:9:"fieldName";s:12:"subscription";s:12:"sourceEntity";s:39:"App\Entity\SubscriptionDealing\BaseCode";s:12:"targetEntity";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:5:"fetch";i:2;s:10:"inversedBy";s:10:"redeemCode";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:15:"subscription_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:1;s:8:"nullable";b:1;}}s:20:"joinColumnFieldNames";a:1:{s:15:"subscription_id";s:15:"subscription_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:15:"subscription_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:15:"subscription_id";}}}s:11:"columnNames";a:6:{s:2:"id";s:2:"id";s:4:"code";s:4:"code";s:7:"isValid";s:8:"is_valid";s:9:"createdAt";s:10:"created_at";s:9:"updatedAt";s:10:"updated_at";s:10:"redeemedAt";s:11:"redeemed_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:"code";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"code";s:10:"columnName";s:4:"code";s:8:"nullable";b:1;}s:7:"isValid";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:7:"isValid";s:10:"columnName";s:8:"is_valid";s:7:"options";a:1:{s:7:"default";b:1;}}s:9:"createdAt";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:9:"createdAt";s:10:"columnName";s:10:"created_at";}s:9:"updatedAt";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:9:"updatedAt";s:10:"columnName";s:10:"updated_at";}s:10:"redeemedAt";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"redeemedAt";s:10:"columnName";s:11:"redeemed_at";s:8:"nullable";b:1;}}s:10:"fieldNames";a:6:{s:2:"id";s:2:"id";s:4:"code";s:4:"code";s:8:"is_valid";s:7:"isValid";s:10:"created_at";s:9:"createdAt";s:10:"updated_at";s:9:"updatedAt";s:11:"redeemed_at";s:10:"redeemedAt";}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\SubscriptionDealing\BaseCode";s:9:"namespace";s:30:"App\Entity\SubscriptionDealing";s:5:"table";a:2:{s:4:"name";s:4:"Code";s:6:"quoted";b:1;}s:14:"rootEntityName";s:39:"App\Entity\SubscriptionDealing\BaseCode";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:29:"App\Repository\CodeRepository";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:2:{s:6:"redeem";s:41:"App\Entity\SubscriptionDealing\RedeemCode";s:4:"gift";s:39:"App\Entity\SubscriptionDealing\GiftCode";}s:13:"parentClasses";a:0:{}s:10:"subClasses";a:2:{i:0;s:41:"App\Entity\SubscriptionDealing\RedeemCode";i:1;s:39:"App\Entity\SubscriptionDealing\GiftCode";}s:13:"generatorType";i:4;s:18:"lifecycleCallbacks";a:2:{s:11:"postPersist";a:1:{i:0;s:11:"postPersist";}s:9:"preUpdate";a:1:{i:0;s:15:"updateTimestamp";}}}
41 0.47 ms default EXEC
42 0.44 ms default SETEX nanomonx_dev_2e28bdf229aeaa4e82e23892b61704f0 86400 _sf2_attributes|a:13:{s:20:"DeviceDetector_setup";b:1;s:20:"DeviceDetector_isBot";b:1;s:24:"DeviceDetector_hasClient";b:0;s:24:"DeviceDetector_isDesktop";b:0;s:23:"DeviceDetector_isTablet";b:0;s:23:"DeviceDetector_isMobile";b:0;s:17:"DeviceDetector_os";N;s:26:"DeviceDetector_client_name";N;s:29:"DeviceDetector_client_version";N;s:4:"lang";s:5:"en-CA";s:24:"_csrf/https-authenticate";s:43:"vB22mLBZqsxUHDhiKxXqi_LaWysIxytFj5Fi4rqzczU";s:7:"country";s:2:"US";s:18:"is_default_country";b:0;}_sf2_meta|a:3:{s:1:"u";i:1760593808;s:1:"c";i:1760593807;s:1:"l";i:604800;}