Commands
171
Queries
84.05 ms
Query time
0
Failed Queries
| # | Time | Connection | Command |
|---|---|---|---|
| 1 | 41.57 ms | default | CONNECT tls://constellation-web-develop-cache-3ighqi.serverless.cac1.cache.amazonaws.com 6379 5 <null> 5 5 |
| 2 | 0.87 ms | default | AUTH constellation-web-develop-user Noc<Ho-{B0la6K#2?vFA |
| 3 | 0.63 ms | default | MGET r7-+-idU+0:DateTime__CLASSMETADATA__ |
| 4 | 0.39 ms | default | MGET r7-+-idU+0:DateTime__CLASSMETADATA__ |
| 5 | 0.60 ms | default | MGET 0ZTl2zDSYZ:005e0d2e976e8f8389b4f75c18e14359 |
| 6 | 0.01 ms | default | MULTI 2 |
| 7 | 0.02 ms | default | SETEX 0ZTl2zDSYZ:005e0d2e976e8f8389b4f75c18e14359 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: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\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\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\ParserResult parameterMappings";a:1:{s:3:"tag";a:1:{i:0;i:0;}}} |
| 8 | 0.53 ms | default | EXEC |
| 9 | 0.54 ms | default | MGET r7-+-idU+0:App_Entity_Country_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 10 | 0.72 ms | default | MGET r7-+-idU+0:App__Entity__Purchases__Package__CLASSMETADATA__ |
| 11 | 0.56 ms | default | MGET r7-+-idU+0:App_Entity_Purchases_Package_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 12 | 0.01 ms | default | MULTI 2 |
| 13 | 0.01 ms | default | SETEX r7-+-idU+0: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";} |
| 14 | 0.52 ms | default | EXEC |
| 15 | 0.41 ms | default | MGET r7-+-idU+0:App__Entity__Purchases__Package__CLASSMETADATA__ |
| 16 | 0.01 ms | default | MULTI 2 |
| 17 | 0.01 ms | default | SETEX r7-+-idU+0: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;}} |
| 18 | 0.51 ms | default | EXEC |
| 19 | 0.40 ms | default | MGET 0ZTl2zDSYZ:3587fbd182bf16b29935b9ecf700410b |
| 20 | 0.01 ms | default | MULTI 2 |
| 21 | 0.01 ms | default | SETEX 0ZTl2zDSYZ:3587fbd182bf16b29935b9ecf700410b 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: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\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: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\ParserResult parameterMappings";a:1:{s:4:"type";a:1:{i:0;i:0;}}} |
| 22 | 0.52 ms | default | EXEC |
| 23 | 0.39 ms | default | MGET r7-+-idU+0:App__Entity__Purchases__Subscriptions__PackageSubscription__CLASSMETADATA__ |
| 24 | 0.44 ms | default | MGET r7-+-idU+0:App_Entity_Purchases_Subscriptions_Subscription_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 25 | 0.01 ms | default | MULTI 2 |
| 26 | 0.01 ms | default | SETEX r7-+-idU+0:App_Entity_Purchases_Subscriptions_Subscription_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 27 | 0.36 ms | default | EXEC |
| 28 | 0.38 ms | default | MGET r7-+-idU+0:App_Entity_Purchases_Subscriptions_PackageSubscription_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 29 | 0.01 ms | default | MULTI 2 |
| 30 | 0.01 ms | default | SETEX r7-+-idU+0:App_Entity_Purchases_Subscriptions_PackageSubscription_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 31 | 0.35 ms | default | EXEC |
| 32 | 0.35 ms | default | MGET r7-+-idU+0:App__Entity__Purchases__Subscriptions__Subscription__CLASSMETADATA__ r7-+-idU+0:App__Entity__Purchases__Subscriptions__PackageSubscription__CLASSMETADATA__ |
| 33 | 0.01 ms | default | MULTI 2 |
| 34 | 0.01 ms | default | SETEX r7-+-idU+0:App__Entity__Purchases__Subscriptions__Subscription__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":21:{s:19:"associationMappings";a:3:{s:5:"owner";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:5:"owner";s:12:"sourceEntity";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:19:"owned_subscriptions";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"owner_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:"owner_id";s:8:"owner_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"owner_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"owner_id";}}s:12:"current_user";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:12:"current_user";s:12:"sourceEntity";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:13:"subscriptions";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:15:"current_user_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:"current_user_id";s:15:"current_user_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:15:"current_user_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:15:"current_user_id";}}s:10:"redeemCode";O:47:"Doctrine\ORM\Mapping\OneToOneInverseSideMapping":5:{s:9:"fieldName";s:10:"redeemCode";s:12:"sourceEntity";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:12:"targetEntity";s:39:"App\Entity\SubscriptionDealing\BaseCode";s:5:"fetch";i:2;s:8:"mappedBy";s:12:"subscription";}}s:11:"columnNames";a:3:{s:2:"id";s:2:"id";s:10:"created_at";s:10:"created_at";s:10:"updated_at";s:10:"updated_at";}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:10:"created_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"created_at";s:10:"columnName";s:10:"created_at";}s:10:"updated_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"updated_at";s:10:"columnName";s:10:"updated_at";s:8:"nullable";b:1;}}s:10:"fieldNames";a:3:{s:2:"id";s:2:"id";s:10:"created_at";s:10:"created_at";s:10:"updated_at";s:10:"updated_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:47:"App\Entity\Purchases\Subscriptions\Subscription";s:9:"namespace";s:34:"App\Entity\Purchases\Subscriptions";s:5:"table";a:1:{s:4:"name";s:17:"Subscription_Base";}s:14:"rootEntityName";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:37:"App\Repository\SubscriptionRepository";s:15:"inheritanceType";i:2;s:19:"discriminatorColumn";O:47:"Doctrine\ORM\Mapping\DiscriminatorColumnMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:5:"discr";s:4:"name";s:5:"discr";s:6:"length";i:255;s:7:"options";a:0:{}}s:18:"discriminatorValue";N;s:16:"discriminatorMap";a:4:{s:6:"custom";s:53:"App\Entity\Purchases\Subscriptions\CustomSubscription";s:7:"package";s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:10:"free_trial";s:56:"App\Entity\Purchases\Subscriptions\FreeTrialSubscription";s:9:"recurring";s:56:"App\Entity\Purchases\Subscriptions\RecurringSubscription";}s:13:"parentClasses";a:0:{}s:10:"subClasses";a:4:{i:0;s:53:"App\Entity\Purchases\Subscriptions\CustomSubscription";i:1;s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";i:2;s:56:"App\Entity\Purchases\Subscriptions\FreeTrialSubscription";i:3;s:56:"App\Entity\Purchases\Subscriptions\RecurringSubscription";}s:13:"generatorType";i:4;s:18:"lifecycleCallbacks";a:1:{s:9:"preUpdate";a:1:{i:0;s:10:"setUpdated";}}} |
| 35 | 0.02 ms | default | SETEX r7-+-idU+0:App__Entity__Purchases__Subscriptions__PackageSubscription__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":21:{s:19:"associationMappings";a:6:{s:5:"owner";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":11:{s:9:"fieldName";s:5:"owner";s:12:"sourceEntity";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:9:"inherited";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"declared";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:10:"inversedBy";s:19:"owned_subscriptions";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"owner_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:"owner_id";s:8:"owner_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"owner_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"owner_id";}}s:12:"current_user";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":11:{s:9:"fieldName";s:12:"current_user";s:12:"sourceEntity";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:9:"inherited";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"declared";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:10:"inversedBy";s:13:"subscriptions";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:15:"current_user_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:"current_user_id";s:15:"current_user_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:15:"current_user_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:15:"current_user_id";}}s:10:"redeemCode";O:47:"Doctrine\ORM\Mapping\OneToOneInverseSideMapping":7:{s:9:"fieldName";s:10:"redeemCode";s:12:"sourceEntity";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:12:"targetEntity";s:39:"App\Entity\SubscriptionDealing\BaseCode";s:5:"fetch";i:2;s:9:"inherited";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"declared";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"mappedBy";s:12:"subscription";}s:7:"package";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":10:{s:9:"fieldName";s:7:"package";s:12:"sourceEntity";s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:12:"targetEntity";s:28:"App\Entity\Purchases\Package";s:5:"fetch";i:2;s:5:"cache";a:2:{s:5:"usage";i:2;s:6:"region";s:8:"nanomonx";}s:10:"inversedBy";s:21:"package_subscriptions";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:7:"type_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:7:"type_id";s:7:"type_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:7:"type_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:7:"type_id";}}s:5:"buyer";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:5:"buyer";s:12:"sourceEntity";s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:23:"purchased_subscriptions";s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:8:"buyer_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:"buyer_id";s:8:"buyer_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:8:"buyer_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:8:"buyer_id";}}s:7:"country";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":9:{s:9:"fieldName";s:7:"country";s:12:"sourceEntity";s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:12:"targetEntity";s:18:"App\Entity\Country";s:5:"fetch";i:2;s:5:"cache";a:2:{s:5:"usage";i:2;s:6:"region";s:8:"nanomonx";}s:11:"joinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:10:"country_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:10:"country_id";s:10:"country_id";}s:24:"sourceToTargetKeyColumns";a:1:{s:10:"country_id";s:2:"id";}s:24:"targetToSourceKeyColumns";a:1:{s:2:"id";s:10:"country_id";}}}s:11:"columnNames";a:3:{s:2:"id";s:2:"id";s:10:"created_at";s:10:"created_at";s:10:"updated_at";s:10:"updated_at";}s:13:"fieldMappings";a:3:{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:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"declared";s:47:"App\Entity\Purchases\Subscriptions\Subscription";}s:10:"created_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":5:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"created_at";s:10:"columnName";s:10:"created_at";s:9:"inherited";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"declared";s:47:"App\Entity\Purchases\Subscriptions\Subscription";}s:10:"updated_at";O:33:"Doctrine\ORM\Mapping\FieldMapping":6:{s:4:"type";s:8:"datetime";s:9:"fieldName";s:10:"updated_at";s:10:"columnName";s:10:"updated_at";s:8:"nullable";b:1;s:9:"inherited";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:8:"declared";s:47:"App\Entity\Purchases\Subscriptions\Subscription";}}s:10:"fieldNames";a:3:{s:2:"id";s:2:"id";s:10:"created_at";s:10:"created_at";s:10:"updated_at";s:10:"updated_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:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:9:"namespace";s:34:"App\Entity\Purchases\Subscriptions";s:5:"table";a:1:{s:4:"name";s:20:"Subscription_Package";}s:14:"rootEntityName";s:47:"App\Entity\Purchases\Subscriptions\Subscription";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:37:"App\Repository\SubscriptionRepository";s:15:"inheritanceType";i:2;s:19:"discriminatorColumn";O:47:"Doctrine\ORM\Mapping\DiscriminatorColumnMapping":5:{s:4:"type";s:6:"string";s:9:"fieldName";s:5:"discr";s:4:"name";s:5:"discr";s:6:"length";i:255;s:7:"options";a:0:{}}s:18:"discriminatorValue";s:7:"package";s:16:"discriminatorMap";a:4:{s:6:"custom";s:53:"App\Entity\Purchases\Subscriptions\CustomSubscription";s:7:"package";s:54:"App\Entity\Purchases\Subscriptions\PackageSubscription";s:10:"free_trial";s:56:"App\Entity\Purchases\Subscriptions\FreeTrialSubscription";s:9:"recurring";s:56:"App\Entity\Purchases\Subscriptions\RecurringSubscription";}s:13:"parentClasses";a:1:{i:0;s:47:"App\Entity\Purchases\Subscriptions\Subscription";}s:10:"subClasses";a:0:{}s:13:"generatorType";i:4;s:18:"lifecycleCallbacks";a:1:{s:9:"preUpdate";a:1:{i:0;s:10:"setUpdated";}}} |
| 36 | 0.65 ms | default | EXEC |
| 37 | 0.46 ms | default | MGET r7-+-idU+0:Gedmo__Translatable__Entity__Translation__CLASSMETADATA__ |
| 38 | 0.41 ms | default | MGET r7-+-idU+0:Gedmo_Translatable_Entity_Translation_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 39 | 0.01 ms | default | MULTI 2 |
| 40 | 0.01 ms | default | SETEX r7-+-idU+0:Gedmo_Translatable_Entity_Translation_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 41 | 0.37 ms | default | EXEC |
| 42 | 0.35 ms | default | MGET r7-+-idU+0:Gedmo__Translatable__Entity__MappedSuperclass__AbstractTranslation__CLASSMETADATA__ r7-+-idU+0:Gedmo__Translatable__Entity__Translation__CLASSMETADATA__ |
| 43 | 0.02 ms | default | MULTI 2 |
| 44 | 0.01 ms | default | SETEX r7-+-idU+0: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;} |
| 45 | 0.01 ms | default | SETEX r7-+-idU+0: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:3:{s:4:"name";s:16:"ext_translations";s:17:"uniqueConstraints";a:1:{s:17:"lookup_unique_idx";a:1:{s:7:"columns";a:4:{i:0;s:11:"foreign_key";i:1;s:6:"locale";i:2;s:12:"object_class";i:3;s:5:"field";}}}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;} |
| 46 | 0.60 ms | default | EXEC |
| 47 | 0.42 ms | default | MGET 0ZTl2zDSYZ:696e8874bd13b3e5d153c78848f95b2f |
| 48 | 0.01 ms | default | MULTI 2 |
| 49 | 0.01 ms | default | SETEX 0ZTl2zDSYZ:696e8874bd13b3e5d153c78848f95b2f 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: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\ParserResult resultSetMapping";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\ParserResult parameterMappings";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;}}} |
| 50 | 0.56 ms | default | EXEC |
| 51 | 0.63 ms | default | MGET r7-+-idU+0:App__Entity__PageContentManager__SideMenuOption__CLASSMETADATA__ |
| 52 | 0.43 ms | default | MGET r7-+-idU+0:App_Entity_PageContentManager_SideMenuOption_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 53 | 0.01 ms | default | MULTI 2 |
| 54 | 0.01 ms | default | SETEX r7-+-idU+0:App_Entity_PageContentManager_SideMenuOption_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 55 | 0.37 ms | default | EXEC |
| 56 | 0.36 ms | default | MGET r7-+-idU+0:App__Entity__PageContentManager__SideMenuOption__CLASSMETADATA__ |
| 57 | 0.00 ms | default | MULTI 2 |
| 58 | 0.01 ms | default | SETEX r7-+-idU+0:App__Entity__PageContentManager__SideMenuOption__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:0:{}s:11:"columnNames";a:8:{s:2:"id";s:2:"id";s:11:"environment";s:11:"environment";s:5:"label";s:5:"label";s:3:"url";s:3:"url";s:4:"icon";s:4:"icon";s:4:"flow";s:4:"flow";s:8:"position";s:8:"position";s:11:"isPublished";s:12:"is_published";}s:13:"fieldMappings";a:8:{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:11:"environment";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:11:"environment";s:10:"columnName";s:11:"environment";s:8:"enumType";s:26:"App\Entity\EnvironmentType";}s:5:"label";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"json";s:9:"fieldName";s:5:"label";s:10:"columnName";s:5:"label";}s:3:"url";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"json";s:9:"fieldName";s:3:"url";s:10:"columnName";s:3:"url";}s:4:"icon";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"text";s:9:"fieldName";s:4:"icon";s:10:"columnName";s:4:"icon";}s:4:"flow";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:4:"flow";s:10:"columnName";s:4:"flow";s:8:"nullable";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:11:"isPublished";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:11:"isPublished";s:10:"columnName";s:12:"is_published";}}s:10:"fieldNames";a:8:{s:2:"id";s:2:"id";s:11:"environment";s:11:"environment";s:5:"label";s:5:"label";s:3:"url";s:3:"url";s:4:"icon";s:4:"icon";s:4:"flow";s:4:"flow";s:8:"position";s:8:"position";s:12:"is_published";s:11:"isPublished";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:44:"App\Entity\PageContentManager\SideMenuOption";s:9:"namespace";s:29:"App\Entity\PageContentManager";s:5:"table";a:2:{s:4:"name";s:14:"SideMenuOption";s:6:"quoted";b:1;}s:14:"rootEntityName";s:44:"App\Entity\PageContentManager\SideMenuOption";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:58:"App\Repository\PageContentManager\SideMenuOptionRepository";s:13:"generatorType";i:4;s:5:"cache";a:2:{s:6:"region";s:8:"nanomonx";s:5:"usage";i:2;}} |
| 59 | 0.50 ms | default | EXEC |
| 60 | 0.35 ms | default | MGET 0ZTl2zDSYZ:d47a389721d4984ab0edd9dfd976a960 |
| 61 | 0.01 ms | default | MULTI 2 |
| 62 | 0.01 ms | default | SETEX 0ZTl2zDSYZ:d47a389721d4984ab0edd9dfd976a960 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:277:"SELECT s0_.id AS id_0, s0_.environment AS environment_1, s0_.label AS label_2, s0_.url AS url_3, s0_.icon AS icon_4, s0_.flow AS flow_5, s0_.position AS position_6, s0_.is_published AS is_published_7 FROM `SideMenuOption` s0_ WHERE s0_.environment = ? ORDER BY s0_.position ASC";}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:44:"App\Entity\PageContentManager\SideMenuOption";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:8:{s:4:"id_0";s:2:"id";s:13:"environment_1";s:11:"environment";s:7:"label_2";s:5:"label";s:5:"url_3";s:3:"url";s:6:"icon_4";s:4:"icon";s:6:"flow_5";s:4:"flow";s:10:"position_6";s:8:"position";s:14:"is_published_7";s:11:"isPublished";}s:19:"columnAliasMappings";a:1:{s:44:"App\Entity\PageContentManager\SideMenuOption";a:1:{s:6:"entity";a:8:{s:2:"id";s:4:"id_0";s:11:"environment";s:13:"environment_1";s:5:"label";s:7:"label_2";s:3:"url";s:5:"url_3";s:4:"icon";s:6:"icon_4";s:4:"flow";s:6:"flow_5";s:8:"position";s:10:"position_6";s:11:"isPublished";s:14:"is_published_7";}}}s:14:"scalarMappings";a:0:{}s:12:"enumMappings";a:1:{s:13:"environment_1";s:26:"App\Entity\EnvironmentType";}s:12:"typeMappings";a:0:{}s:14:"entityMappings";a:1:{s:6:"entity";N;}s:12:"metaMappings";a:0:{}s:14:"columnOwnerMap";a:8:{s:4:"id_0";s:6:"entity";s:13:"environment_1";s:6:"entity";s:7:"label_2";s:6:"entity";s:5:"url_3";s:6:"entity";s:6:"icon_4";s:6:"entity";s:6:"flow_5";s:6:"entity";s:10:"position_6";s:6:"entity";s:14:"is_published_7";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:8:{s:4:"id_0";s:44:"App\Entity\PageContentManager\SideMenuOption";s:13:"environment_1";s:44:"App\Entity\PageContentManager\SideMenuOption";s:7:"label_2";s:44:"App\Entity\PageContentManager\SideMenuOption";s:5:"url_3";s:44:"App\Entity\PageContentManager\SideMenuOption";s:6:"icon_4";s:44:"App\Entity\PageContentManager\SideMenuOption";s:6:"flow_5";s:44:"App\Entity\PageContentManager\SideMenuOption";s:10:"position_6";s:44:"App\Entity\PageContentManager\SideMenuOption";s:14:"is_published_7";s:44:"App\Entity\PageContentManager\SideMenuOption";}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:11:"environment";a:1:{i:0;i:0;}}} |
| 63 | 0.64 ms | default | EXEC |
| 64 | 0.43 ms | default | MGET r7-+-idU+0:App__Entity__PageContentManager__TutorialPanel__CLASSMETADATA__ |
| 65 | 0.46 ms | default | MGET r7-+-idU+0:App_Entity_PageContentManager_TutorialPanel_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 66 | 0.01 ms | default | MULTI 2 |
| 67 | 0.01 ms | default | SETEX r7-+-idU+0:App_Entity_PageContentManager_TutorialPanel_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 68 | 0.36 ms | default | EXEC |
| 69 | 0.35 ms | default | MGET r7-+-idU+0:App__Entity__PageContentManager__TutorialPanel__CLASSMETADATA__ |
| 70 | 0.01 ms | default | MULTI 2 |
| 71 | 0.01 ms | default | SETEX r7-+-idU+0:App__Entity__PageContentManager__TutorialPanel__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:1:{s:12:"displayed_to";O:48:"Doctrine\ORM\Mapping\ManyToManyOwningSideMapping":9:{s:9:"fieldName";s:12:"displayed_to";s:12:"sourceEntity";s:43:"App\Entity\PageContentManager\TutorialPanel";s:12:"targetEntity";s:18:"App\Entity\Manager";s:5:"fetch";i:2;s:10:"inversedBy";s:15:"tutorial_panels";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:17:"tutorial_panel_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:0;}}s:18:"inverseJoinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:10:"manager_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:0;}}s:4:"name";s:22:"tutorialPanels_manager";s:7:"options";a:0:{}}s:16:"joinTableColumns";a:2:{i:0;s:17:"tutorial_panel_id";i:1;s:10:"manager_id";}s:26:"relationToSourceKeyColumns";a:1:{s:17:"tutorial_panel_id";s:2:"id";}s:26:"relationToTargetKeyColumns";a:1:{s:10:"manager_id";s:2:"id";}}}s:11:"columnNames";a:6:{s:2:"id";s:2:"id";s:5:"title";s:5:"title";s:3:"url";s:3:"url";s:5:"route";s:5:"route";s:9:"is_active";s:9:"is_active";s:21:"display_on_first_time";s:21:"display_on_first_time";}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:5:"title";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:5:"title";s:10:"columnName";s:5:"title";s:8:"nullable";b:1;}s:3:"url";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:3:"url";s:10:"columnName";s:3:"url";}s:5:"route";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:5:"route";s:10:"columnName";s:5:"route";}s:9:"is_active";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:9:"is_active";s:10:"columnName";s:9:"is_active";}s:21:"display_on_first_time";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:21:"display_on_first_time";s:10:"columnName";s:21:"display_on_first_time";}}s:10:"fieldNames";a:6:{s:2:"id";s:2:"id";s:5:"title";s:5:"title";s:3:"url";s:3:"url";s:5:"route";s:5:"route";s:9:"is_active";s:9:"is_active";s:21:"display_on_first_time";s:21:"display_on_first_time";}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\PageContentManager\TutorialPanel";s:9:"namespace";s:29:"App\Entity\PageContentManager";s:5:"table";a:2:{s:4:"name";s:13:"TutorialPanel";s:6:"quoted";b:1;}s:14:"rootEntityName";s:43:"App\Entity\PageContentManager\TutorialPanel";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;}} |
| 72 | 0.50 ms | default | EXEC |
| 73 | 0.34 ms | default | MGET 0ZTl2zDSYZ:10f4d8a87968370c5038bab62d39e3a3 |
| 74 | 0.01 ms | default | MULTI 2 |
| 75 | 0.01 ms | default | SETEX 0ZTl2zDSYZ:10f4d8a87968370c5038bab62d39e3a3 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:234:"SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.url AS url_2, t0_.route AS route_3, t0_.is_active AS is_active_4, t0_.display_on_first_time AS display_on_first_time_5 FROM `TutorialPanel` t0_ WHERE t0_.route = ? AND t0_.is_active = ?";}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:43:"App\Entity\PageContentManager\TutorialPanel";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:6:{s:4:"id_0";s:2:"id";s:7:"title_1";s:5:"title";s:5:"url_2";s:3:"url";s:7:"route_3";s:5:"route";s:11:"is_active_4";s:9:"is_active";s:23:"display_on_first_time_5";s:21:"display_on_first_time";}s:19:"columnAliasMappings";a:1:{s:43:"App\Entity\PageContentManager\TutorialPanel";a:1:{s:6:"entity";a:6:{s:2:"id";s:4:"id_0";s:5:"title";s:7:"title_1";s:3:"url";s:5:"url_2";s:5:"route";s:7:"route_3";s:9:"is_active";s:11:"is_active_4";s:21:"display_on_first_time";s:23:"display_on_first_time_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:7:"title_1";s:6:"entity";s:5:"url_2";s:6:"entity";s:7:"route_3";s:6:"entity";s:11:"is_active_4";s:6:"entity";s:23:"display_on_first_time_5";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:6:{s:4:"id_0";s:43:"App\Entity\PageContentManager\TutorialPanel";s:7:"title_1";s:43:"App\Entity\PageContentManager\TutorialPanel";s:5:"url_2";s:43:"App\Entity\PageContentManager\TutorialPanel";s:7:"route_3";s:43:"App\Entity\PageContentManager\TutorialPanel";s:11:"is_active_4";s:43:"App\Entity\PageContentManager\TutorialPanel";s:23:"display_on_first_time_5";s:43:"App\Entity\PageContentManager\TutorialPanel";}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:5:"route";a:1:{i:0;i:0;}s:9:"is_active";a:1:{i:0;i:1;}}} |
| 76 | 0.38 ms | default | EXEC |
| 77 | 0.37 ms | default | MGET r7-+-idU+0:App__Entity__PageContentManager__InformationPanel__CLASSMETADATA__ |
| 78 | 0.37 ms | default | MGET r7-+-idU+0:App_Entity_PageContentManager_InformationPanel_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 79 | 0.01 ms | default | MULTI 2 |
| 80 | 0.01 ms | default | SETEX r7-+-idU+0:App_Entity_PageContentManager_InformationPanel_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 81 | 0.36 ms | default | EXEC |
| 82 | 0.32 ms | default | MGET r7-+-idU+0:App__Entity__PageContentManager__InformationPanel__CLASSMETADATA__ |
| 83 | 0.01 ms | default | MULTI 2 |
| 84 | 0.01 ms | default | SETEX r7-+-idU+0:App__Entity__PageContentManager__InformationPanel__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:0:{}s:11:"columnNames";a:8:{s:2:"id";s:2:"id";s:5:"title";s:5:"title";s:4:"text";s:4:"text";s:5:"image";s:5:"image";s:10:"icon_class";s:10:"icon_class";s:5:"route";s:5:"route";s:9:"is_active";s:9:"is_active";s:12:"translations";s:12:"translations";}s:13:"fieldMappings";a:8:{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:5:"title";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:5:"title";s:10:"columnName";s:5:"title";s:8:"nullable";b:1;}s:4:"text";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:4:"text";s:9:"fieldName";s:4:"text";s:10:"columnName";s:4:"text";}s:5:"image";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:4:"text";s:9:"fieldName";s:5:"image";s:10:"columnName";s:5:"image";s:8:"nullable";b:1;}s:10:"icon_class";O:33:"Doctrine\ORM\Mapping\FieldMapping":4:{s:4:"type";s:6:"string";s:9:"fieldName";s:10:"icon_class";s:10:"columnName";s:10:"icon_class";s:8:"nullable";b:1;}s:5:"route";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:6:"string";s:9:"fieldName";s:5:"route";s:10:"columnName";s:5:"route";}s:9:"is_active";O:33:"Doctrine\ORM\Mapping\FieldMapping":3:{s:4:"type";s:7:"boolean";s:9:"fieldName";s:9:"is_active";s:10:"columnName";s:9:"is_active";}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:10:"fieldNames";a:8:{s:2:"id";s:2:"id";s:5:"title";s:5:"title";s:4:"text";s:4:"text";s:5:"image";s:5:"image";s:10:"icon_class";s:10:"icon_class";s:5:"route";s:5:"route";s:9:"is_active";s:9:"is_active";s:12:"translations";s:12:"translations";}s:15:"embeddedClasses";a:0:{}s:10:"identifier";a:1:{i:0;s:2:"id";}s:21:"isIdentifierComposite";b:0;s:4:"name";s:46:"App\Entity\PageContentManager\InformationPanel";s:9:"namespace";s:29:"App\Entity\PageContentManager";s:5:"table";a:2:{s:4:"name";s:16:"InformationPanel";s:6:"quoted";b:1;}s:14:"rootEntityName";s:46:"App\Entity\PageContentManager\InformationPanel";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;}} |
| 85 | 0.48 ms | default | EXEC |
| 86 | 0.48 ms | default | MGET 0ZTl2zDSYZ:c6ccb871b1351ecb18e16dc8a3ed0b7d |
| 87 | 0.01 ms | default | MULTI 2 |
| 88 | 0.01 ms | default | SETEX 0ZTl2zDSYZ:c6ccb871b1351ecb18e16dc8a3ed0b7d 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:275:"SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.text AS text_2, i0_.image AS image_3, i0_.icon_class AS icon_class_4, i0_.route AS route_5, i0_.is_active AS is_active_6, i0_.translations AS translations_7 FROM `InformationPanel` i0_ WHERE i0_.route = ? AND i0_.is_active = ?";}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:46:"App\Entity\PageContentManager\InformationPanel";}s:11:"relationMap";a:0:{}s:14:"parentAliasMap";a:0:{}s:13:"fieldMappings";a:8:{s:4:"id_0";s:2:"id";s:7:"title_1";s:5:"title";s:6:"text_2";s:4:"text";s:7:"image_3";s:5:"image";s:12:"icon_class_4";s:10:"icon_class";s:7:"route_5";s:5:"route";s:11:"is_active_6";s:9:"is_active";s:14:"translations_7";s:12:"translations";}s:19:"columnAliasMappings";a:1:{s:46:"App\Entity\PageContentManager\InformationPanel";a:1:{s:6:"entity";a:8:{s:2:"id";s:4:"id_0";s:5:"title";s:7:"title_1";s:4:"text";s:6:"text_2";s:5:"image";s:7:"image_3";s:10:"icon_class";s:12:"icon_class_4";s:5:"route";s:7:"route_5";s:9:"is_active";s:11:"is_active_6";s:12:"translations";s:14:"translations_7";}}}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:8:{s:4:"id_0";s:6:"entity";s:7:"title_1";s:6:"entity";s:6:"text_2";s:6:"entity";s:7:"image_3";s:6:"entity";s:12:"icon_class_4";s:6:"entity";s:7:"route_5";s:6:"entity";s:11:"is_active_6";s:6:"entity";s:14:"translations_7";s:6:"entity";}s:20:"discriminatorColumns";a:0:{}s:10:"indexByMap";a:0:{}s:16:"declaringClasses";a:8:{s:4:"id_0";s:46:"App\Entity\PageContentManager\InformationPanel";s:7:"title_1";s:46:"App\Entity\PageContentManager\InformationPanel";s:6:"text_2";s:46:"App\Entity\PageContentManager\InformationPanel";s:7:"image_3";s:46:"App\Entity\PageContentManager\InformationPanel";s:12:"icon_class_4";s:46:"App\Entity\PageContentManager\InformationPanel";s:7:"route_5";s:46:"App\Entity\PageContentManager\InformationPanel";s:11:"is_active_6";s:46:"App\Entity\PageContentManager\InformationPanel";s:14:"translations_7";s:46:"App\Entity\PageContentManager\InformationPanel";}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:5:"route";a:1:{i:0;i:0;}s:9:"is_active";a:1:{i:0;i:1;}}} |
| 89 | 0.53 ms | default | EXEC |
| 90 | 0.37 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.package_5__prices |
| 91 | 0.43 ms | default | MGET r7-+-idU+0:App_Entity_Purchases_Price_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 92 | 0.34 ms | default | EXISTS 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_100 |
| 93 | 0.33 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_100 |
| 94 | 0.01 ms | default | MULTI 2 |
| 95 | 0.01 ms | default | SETEX 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_100 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Purchases\Price";s:4:"data";a:10:{s:2:"id";i:100;s:15:"stripe_price_id";s:30:"price_1Qj9fKHSrFHiNSLKF3ta7wVL";s:5:"price";i:6000;s:5:"seats";i:0;s:14:"isDefaultPrice";b:0;s:8:"interval";E:37:"App\Entity\Purchases\Interval:ONETIME";s:10:"package_id";i:5;s:10:"country_id";i:1;s:7:"package";O:40:"Doctrine\ORM\Cache\AssociationCacheEntry":2:{s:5:"class";s:28:"App\Entity\Purchases\Package";s:10:"identifier";a:1:{s:2:"id";i:5;}}s:7:"country";O:40:"Doctrine\ORM\Cache\AssociationCacheEntry":2:{s:5:"class";s:18:"App\Entity\Country";s:10:"identifier";a:1:{s:2:"id";i:1;}}}} |
| 96 | 0.36 ms | default | EXEC |
| 97 | 0.32 ms | default | EXISTS 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_101 |
| 98 | 0.32 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_101 |
| 99 | 0.00 ms | default | MULTI 2 |
| 100 | 0.01 ms | default | SETEX 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_101 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Purchases\Price";s:4:"data";a:10:{s:2:"id";i:101;s:15:"stripe_price_id";s:30:"price_1Rb69XHSrFHiNSLKrDSpqy0V";s:5:"price";i:6000;s:5:"seats";i:0;s:14:"isDefaultPrice";b:0;s:8:"interval";E:37:"App\Entity\Purchases\Interval:ONETIME";s:10:"package_id";i:5;s:10:"country_id";i:2;s:7:"package";O:40:"Doctrine\ORM\Cache\AssociationCacheEntry":2:{s:5:"class";s:28:"App\Entity\Purchases\Package";s:10:"identifier";a:1:{s:2:"id";i:5;}}s:7:"country";O:40:"Doctrine\ORM\Cache\AssociationCacheEntry":2:{s:5:"class";s:18:"App\Entity\Country";s:10:"identifier";a:1:{s:2:"id";i:2;}}}} |
| 101 | 0.34 ms | default | EXEC |
| 102 | 0.33 ms | default | EXISTS 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_102 |
| 103 | 0.34 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_102 |
| 104 | 0.00 ms | default | MULTI 2 |
| 105 | 0.01 ms | default | SETEX 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_102 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Purchases\Price";s:4:"data";a:10:{s:2:"id";i:102;s:15:"stripe_price_id";s:30:"price_1Qj9fKHSrFHiNSLK0Kmlx0Hc";s:5:"price";i:6000;s:5:"seats";i:0;s:14:"isDefaultPrice";b:1;s:8:"interval";E:37:"App\Entity\Purchases\Interval:ONETIME";s:10:"package_id";i:5;s:10:"country_id";N;s:7:"package";O:40:"Doctrine\ORM\Cache\AssociationCacheEntry":2:{s:5:"class";s:28:"App\Entity\Purchases\Package";s:10:"identifier";a:1:{s:2:"id";i:5;}}s:7:"country";N;}} |
| 106 | 0.36 ms | default | EXEC |
| 107 | 0.33 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.package_5__prices |
| 108 | 0.00 ms | default | MULTI 2 |
| 109 | 0.01 ms | default | SETEX 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.package_5__prices 7200 O:39:"Doctrine\ORM\Cache\CollectionCacheEntry":1:{s:11:"identifiers";a:3:{i:0;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:30:"app.entity.purchases.price_100";s:10:"identifier";a:1:{s:2:"id";i:100;}s:11:"entityClass";s:26:"App\Entity\Purchases\Price";}i:1;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:30:"app.entity.purchases.price_101";s:10:"identifier";a:1:{s:2:"id";i:101;}s:11:"entityClass";s:26:"App\Entity\Purchases\Price";}i:2;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:30:"app.entity.purchases.price_102";s:10:"identifier";a:1:{s:2:"id";i:102;}s:11:"entityClass";s:26:"App\Entity\Purchases\Price";}}} |
| 110 | 0.37 ms | default | EXEC |
| 111 | 0.43 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.package_4__prices |
| 112 | 0.36 ms | default | EXISTS 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_97 |
| 113 | 0.36 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_97 |
| 114 | 0.01 ms | default | MULTI 2 |
| 115 | 0.01 ms | default | SETEX 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_97 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Purchases\Price";s:4:"data";a:10:{s:2:"id";i:97;s:15:"stripe_price_id";s:30:"price_1PH8LIHSrFHiNSLKbGpEZ7fQ";s:5:"price";i:800;s:5:"seats";i:0;s:14:"isDefaultPrice";b:1;s:8:"interval";E:37:"App\Entity\Purchases\Interval:ONETIME";s:10:"package_id";i:4;s:10:"country_id";N;s:7:"package";O:40:"Doctrine\ORM\Cache\AssociationCacheEntry":2:{s:5:"class";s:28:"App\Entity\Purchases\Package";s:10:"identifier";a:1:{s:2:"id";i:4;}}s:7:"country";N;}} |
| 116 | 0.36 ms | default | EXEC |
| 117 | 0.32 ms | default | EXISTS 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_98 |
| 118 | 0.32 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_98 |
| 119 | 0.01 ms | default | MULTI 2 |
| 120 | 0.01 ms | default | SETEX 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_98 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Purchases\Price";s:4:"data";a:10:{s:2:"id";i:98;s:15:"stripe_price_id";s:30:"price_1QP7CPHSrFHiNSLKk0VRwSHx";s:5:"price";i:800;s:5:"seats";i:0;s:14:"isDefaultPrice";b:0;s:8:"interval";E:37:"App\Entity\Purchases\Interval:MONTHLY";s:10:"package_id";i:4;s:10:"country_id";i:1;s:7:"package";O:40:"Doctrine\ORM\Cache\AssociationCacheEntry":2:{s:5:"class";s:28:"App\Entity\Purchases\Package";s:10:"identifier";a:1:{s:2:"id";i:4;}}s:7:"country";O:40:"Doctrine\ORM\Cache\AssociationCacheEntry":2:{s:5:"class";s:18:"App\Entity\Country";s:10:"identifier";a:1:{s:2:"id";i:1;}}}} |
| 121 | 0.37 ms | default | EXEC |
| 122 | 0.31 ms | default | EXISTS 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_99 |
| 123 | 0.35 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_99 |
| 124 | 0.00 ms | default | MULTI 2 |
| 125 | 0.01 ms | default | SETEX 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.price_99 7200 O:35:"Doctrine\ORM\Cache\EntityCacheEntry":2:{s:5:"class";s:26:"App\Entity\Purchases\Price";s:4:"data";a:10:{s:2:"id";i:99;s:15:"stripe_price_id";s:30:"price_1QP7CbHSrFHiNSLKUSf4pIrs";s:5:"price";i:800;s:5:"seats";i:0;s:14:"isDefaultPrice";b:0;s:8:"interval";E:37:"App\Entity\Purchases\Interval:MONTHLY";s:10:"package_id";i:4;s:10:"country_id";i:2;s:7:"package";O:40:"Doctrine\ORM\Cache\AssociationCacheEntry":2:{s:5:"class";s:28:"App\Entity\Purchases\Package";s:10:"identifier";a:1:{s:2:"id";i:4;}}s:7:"country";O:40:"Doctrine\ORM\Cache\AssociationCacheEntry":2:{s:5:"class";s:18:"App\Entity\Country";s:10:"identifier";a:1:{s:2:"id";i:2;}}}} |
| 126 | 0.35 ms | default | EXEC |
| 127 | 0.50 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.package_4__prices |
| 128 | 0.01 ms | default | MULTI 2 |
| 129 | 0.01 ms | default | SETEX 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.purchases.package_4__prices 7200 O:39:"Doctrine\ORM\Cache\CollectionCacheEntry":1:{s:11:"identifiers";a:3:{i:0;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:29:"app.entity.purchases.price_97";s:10:"identifier";a:1:{s:2:"id";i:97;}s:11:"entityClass";s:26:"App\Entity\Purchases\Price";}i:1;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:29:"app.entity.purchases.price_98";s:10:"identifier";a:1:{s:2:"id";i:98;}s:11:"entityClass";s:26:"App\Entity\Purchases\Price";}i:2;O:33:"Doctrine\ORM\Cache\EntityCacheKey":3:{s:4:"hash";s:29:"app.entity.purchases.price_99";s:10:"identifier";a:1:{s:2:"id";i:99;}s:11:"entityClass";s:26:"App\Entity\Purchases\Price";}}} |
| 130 | 0.35 ms | default | EXEC |
| 131 | 0.44 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_2__translations |
| 132 | 0.47 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_2 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_6 |
| 133 | 0.37 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpage_3__translations |
| 134 | 1.09 ms | default | MGET 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_3 6vFdE7gobs:DC2_REGION_nanomonx_app.entity.pagecontentmanager.informationpagetranslation_4 |
| 135 | 0.44 ms | default | MGET r7-+-idU+0:App__Entity__Catalog__GradeLevel__CLASSMETADATA__ |
| 136 | 0.38 ms | default | MGET r7-+-idU+0:App_Entity_Catalog_GradeLevel_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 137 | 0.01 ms | default | MULTI 2 |
| 138 | 0.01 ms | default | SETEX r7-+-idU+0:App_Entity_Catalog_GradeLevel_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 139 | 0.34 ms | default | EXEC |
| 140 | 0.37 ms | default | MGET r7-+-idU+0:App__Entity__Catalog__GradeLevel__CLASSMETADATA__ |
| 141 | 0.01 ms | default | MULTI 2 |
| 142 | 0.01 ms | default | SETEX r7-+-idU+0: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;}} |
| 143 | 0.51 ms | default | EXEC |
| 144 | 0.38 ms | default | MGET r7-+-idU+0:App__Entity__Constellation__ChallengeTemplateAssociation__CLASSMETADATA__ |
| 145 | 0.34 ms | default | MGET r7-+-idU+0:App_Entity_Constellation_ChallengeTemplateAssociation_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 146 | 0.01 ms | default | MULTI 2 |
| 147 | 0.01 ms | default | SETEX r7-+-idU+0:App_Entity_Constellation_ChallengeTemplateAssociation_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 148 | 0.33 ms | default | EXEC |
| 149 | 0.37 ms | default | MGET r7-+-idU+0:App__Entity__Constellation__ChallengeTemplateAssociation__CLASSMETADATA__ |
| 150 | 0.01 ms | default | MULTI 2 |
| 151 | 0.01 ms | default | SETEX r7-+-idU+0: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:0;}}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:0;}}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;} |
| 152 | 0.51 ms | default | EXEC |
| 153 | 0.39 ms | default | MGET r7-+-idU+0:App__Entity__Troubadour__ChallengeTemplateAssociation__CLASSMETADATA__ |
| 154 | 0.36 ms | default | MGET r7-+-idU+0:App_Entity_Troubadour_ChallengeTemplateAssociation_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 155 | 0.01 ms | default | MULTI 2 |
| 156 | 0.01 ms | default | SETEX r7-+-idU+0:App_Entity_Troubadour_ChallengeTemplateAssociation_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 157 | 0.37 ms | default | EXEC |
| 158 | 0.33 ms | default | MGET r7-+-idU+0:App__Entity__Troubadour__ChallengeTemplateAssociation__CLASSMETADATA__ |
| 159 | 0.01 ms | default | MULTI 2 |
| 160 | 0.01 ms | default | SETEX r7-+-idU+0:App__Entity__Troubadour__ChallengeTemplateAssociation__CLASSMETADATA__ 86400 O:34:"Doctrine\ORM\Mapping\ClassMetadata":15:{s:19:"associationMappings";a:3:{s:18:"challenge_template";O:48:"Doctrine\ORM\Mapping\ManyToOneAssociationMapping":10:{s:9:"fieldName";s:18:"challenge_template";s:12:"sourceEntity";s:50:"App\Entity\Troubadour\ChallengeTemplateAssociation";s:12:"targetEntity";s:43:"App\Entity\Troubadour\BaseChallengeTemplate";s:5:"fetch";i:2;s:5:"cache";a:2:{s:5:"usage";i:2;s:6:"region";s:8:"nanomonx";}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":10:{s:9:"fieldName";s:19:"educational_pathway";s:12:"sourceEntity";s:50:"App\Entity\Troubadour\ChallengeTemplateAssociation";s:12:"targetEntity";s:31:"App\Entity\Catalog\ScholarLevel";s:5:"fetch";i:2;s:5:"cache";a:2:{s:5:"usage";i:2;s:6:"region";s:8:"nanomonx";}s:10:"inversedBy";s:23:"troubadour_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:50:"App\Entity\Troubadour\ChallengeTemplateAssociation";s:12:"targetEntity";s:34:"App\Entity\Catalog\DifficultyLevel";s:5:"fetch";i:2;s:10:"inversedBy";s:23:"troubadour_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:0;}}s:18:"inverseJoinColumns";a:1:{i:0;O:38:"Doctrine\ORM\Mapping\JoinColumnMapping":5:{s:4:"name";s:25:"troubadour_association_id";s:20:"referencedColumnName";s:2:"id";s:10:"deferrable";b:0;s:6:"unique";b:0;s:8:"nullable";b:0;}}s:4:"name";s:50:"troub_challengeTemplateAssociation_difficultyLevel";s:7:"options";a:0:{}}s:16:"joinTableColumns";a:2:{i:0;s:19:"difficulty_level_id";i:1;s:25:"troubadour_association_id";}s:26:"relationToSourceKeyColumns";a:1:{s:19:"difficulty_level_id";s:2:"id";}s:26:"relationToTargetKeyColumns";a:1:{s:25:"troubadour_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:50:"App\Entity\Troubadour\ChallengeTemplateAssociation";s:9:"namespace";s:21:"App\Entity\Troubadour";s:5:"table";a:2:{s:4:"name";s:34:"troub_ChallengeTemplateAssociation";s:6:"quoted";b:1;}s:14:"rootEntityName";s:50:"App\Entity\Troubadour\ChallengeTemplateAssociation";s:11:"idGenerator";O:33:"Doctrine\ORM\Id\IdentityGenerator":0:{}s:25:"customRepositoryClassName";s:64:"App\Repository\Troubadour\ChallengeTemplateAssociationRepository";s:13:"generatorType";i:4;s:5:"cache";a:2:{s:6:"region";s:8:"nanomonx";s:5:"usage";i:2;}} |
| 161 | 0.45 ms | default | EXEC |
| 162 | 0.39 ms | default | MGET r7-+-idU+0:App__Entity__SubscriptionDealing__BaseCode__CLASSMETADATA__ |
| 163 | 0.45 ms | default | MGET r7-+-idU+0:App_Entity_SubscriptionDealing_BaseCode_$GEDMO_TRANSLATABLE_CLASSMETADATA |
| 164 | 0.01 ms | default | MULTI 2 |
| 165 | 0.01 ms | default | SETEX r7-+-idU+0:App_Entity_SubscriptionDealing_BaseCode_$GEDMO_TRANSLATABLE_CLASSMETADATA 86400 a:0:{} |
| 166 | 0.36 ms | default | EXEC |
| 167 | 0.34 ms | default | MGET r7-+-idU+0:App__Entity__SubscriptionDealing__BaseCode__CLASSMETADATA__ |
| 168 | 0.01 ms | default | MULTI 2 |
| 169 | 0.01 ms | default | SETEX r7-+-idU+0: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";}}} |
| 170 | 0.48 ms | default | EXEC |
| 171 | 0.40 ms | default | SETEX nanomonx_dev_28868c8fcffd9ade334e738578380074 86400 _sf2_attributes|a:5:{s:4:"lang";s:5:"fr-CA";s:31:"_csrf/https-purchase_email_form";s:43:"x0ZJmjmx71I6ZjNsS_2ZKfsKBPLo62RqV3OcS_QZTIA";s:7:"country";s:2:"US";s:18:"is_default_country";b:0;s:24:"_csrf/https-authenticate";s:43:"HnJqrJQjW0QDRAcjLIYoH7zPFR-eNZWKZvlCmF1Cn5U";}_sf2_meta|a:3:{s:1:"u";i:1772864953;s:1:"c";i:1772864953;s:1:"l";i:604800;} |