Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.27 ms Query time

0 Invalid entities

9 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.29 ms
(39.50%)

SELECT t0.id AS id_1, t0.started_at AS started_at_2, t0.ended_at AS ended_at_3, t0.status AS status_4, t0.stripe_subscription AS stripe_subscription_5, t0.price_currency AS price_currency_6, t0.invoice_url AS invoice_url_7, t0.uuid AS uuid_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.organization_id AS organization_id_11, t0.packaging_id AS packaging_id_12, t0.user_id AS user_id_13 FROM subscription t0 WHERE t0.status = ? AND t0.organization_id = ? ORDER BY t0.ended_at DESC LIMIT 1

Parameters:

[
  "ACTIVE"
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.started_at AS started_at_2,
  t0.ended_at AS ended_at_3,
  t0.status AS status_4,
  t0.stripe_subscription AS stripe_subscription_5,
  t0.price_currency AS price_currency_6,
  t0.invoice_url AS invoice_url_7,
  t0.uuid AS uuid_8,
  t0.updated_at AS updated_at_9,
  t0.created_at AS created_at_10,
  t0.organization_id AS organization_id_11,
  t0.packaging_id AS packaging_id_12,
  t0.user_id AS user_id_13
FROM
  subscription t0
WHERE
  t0.status = ?
  AND t0.organization_id = ?
ORDER BY
  t0.ended_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.started_at AS started_at_2, t0.ended_at AS ended_at_3, t0.status AS status_4, t0.stripe_subscription AS stripe_subscription_5, t0.price_currency AS price_currency_6, t0.invoice_url AS invoice_url_7, t0.uuid AS uuid_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.organization_id AS organization_id_11, t0.packaging_id AS packaging_id_12, t0.user_id AS user_id_13 FROM subscription t0 WHERE t0.status = 'ACTIVE' AND t0.organization_id = 4 ORDER BY t0.ended_at DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 89)
5	App\Manager\SubscriptionManager->isUserSubscriptionValid (line 99)
6	App\Security\AppAuthenticator->onAuthenticationSuccess (line 91)
7	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 233)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 219)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
12	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
15	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
16	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

1.21 ms
(36.90%)

SELECT t0.deleted_at AS deleted_at_1, t0.id AS id_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.email AS email_5, t0.gender AS gender_6, t0.birthdate AS birthdate_7, t0.enabled AS enabled_8, t0.username AS username_9, t0.password AS password_10, t0.picture AS picture_11, t0.role AS role_12, t0.additional_roles AS additional_roles_13, t0.address AS address_14, t0.code_postal AS code_postal_15, t0.city AS city_16, t0.phone AS phone_17, t0.stripe_customer AS stripe_customer_18, t0.is_department_group_admin AS is_department_group_admin_19, t0.oauth_provider AS oauth_provider_20, t0.oauth_provider_id AS oauth_provider_id_21, t0.rib AS rib_22, t0.balance AS balance_23, t0.is_partner AS is_partner_24, t0.uuid AS uuid_25, t0.updated_at AS updated_at_26, t0.created_at AS created_at_27, t0.fonction_id AS fonction_id_28, t0.entite_id AS entite_id_29, t30.id AS id_31, t30.name AS name_32, t30.solde AS solde_33, t30.number AS number_34, t30.number_fix AS number_fix_35, t30.facebook AS facebook_36, t30.instagram AS instagram_37, t30.linkedin AS linkedin_38, t30.tiktok AS tiktok_39, t30.youtube AS youtube_40, t30.twitter AS twitter_41, t30.description AS description_42, t30.entite_logo AS entite_logo_43, t30.newcomer_open_to_all AS newcomer_open_to_all_44, t30.newcomer_token AS newcomer_token_45, t30.updated_at AS updated_at_46, t30.created_at AS created_at_47, t30.organization_id AS organization_id_48, t30.address_id AS address_id_49, t0.organization_id AS organization_id_50 FROM `user` t0 LEFT JOIN entite t30 ON t0.entite_id = t30.id WHERE t0.email = ? AND ((t0.deleted_at IS NULL)) LIMIT 1

Parameters:

[
  "mayoko.arnold@gmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.id AS id_2,
  t0.last_name AS last_name_3,
  t0.first_name AS first_name_4,
  t0.email AS email_5,
  t0.gender AS gender_6,
  t0.birthdate AS birthdate_7,
  t0.enabled AS enabled_8,
  t0.username AS username_9,
  t0.password AS password_10,
  t0.picture AS picture_11,
  t0.role AS role_12,
  t0.additional_roles AS additional_roles_13,
  t0.address AS address_14,
  t0.code_postal AS code_postal_15,
  t0.city AS city_16,
  t0.phone AS phone_17,
  t0.stripe_customer AS stripe_customer_18,
  t0.is_department_group_admin AS is_department_group_admin_19,
  t0.oauth_provider AS oauth_provider_20,
  t0.oauth_provider_id AS oauth_provider_id_21,
  t0.rib AS rib_22,
  t0.balance AS balance_23,
  t0.is_partner AS is_partner_24,
  t0.uuid AS uuid_25,
  t0.updated_at AS updated_at_26,
  t0.created_at AS created_at_27,
  t0.fonction_id AS fonction_id_28,
  t0.entite_id AS entite_id_29,
  t30.id AS id_31,
  t30.name AS name_32,
  t30.solde AS solde_33,
  t30.number AS number_34,
  t30.number_fix AS number_fix_35,
  t30.facebook AS facebook_36,
  t30.instagram AS instagram_37,
  t30.linkedin AS linkedin_38,
  t30.tiktok AS tiktok_39,
  t30.youtube AS youtube_40,
  t30.twitter AS twitter_41,
  t30.description AS description_42,
  t30.entite_logo AS entite_logo_43,
  t30.newcomer_open_to_all AS newcomer_open_to_all_44,
  t30.newcomer_token AS newcomer_token_45,
  t30.updated_at AS updated_at_46,
  t30.created_at AS created_at_47,
  t30.organization_id AS organization_id_48,
  t30.address_id AS address_id_49,
  t0.organization_id AS organization_id_50
FROM
  `user` t0
  LEFT JOIN entite t30 ON t0.entite_id = t30.id
WHERE
  t0.email = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.deleted_at AS deleted_at_1, t0.id AS id_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.email AS email_5, t0.gender AS gender_6, t0.birthdate AS birthdate_7, t0.enabled AS enabled_8, t0.username AS username_9, t0.password AS password_10, t0.picture AS picture_11, t0.role AS role_12, t0.additional_roles AS additional_roles_13, t0.address AS address_14, t0.code_postal AS code_postal_15, t0.city AS city_16, t0.phone AS phone_17, t0.stripe_customer AS stripe_customer_18, t0.is_department_group_admin AS is_department_group_admin_19, t0.oauth_provider AS oauth_provider_20, t0.oauth_provider_id AS oauth_provider_id_21, t0.rib AS rib_22, t0.balance AS balance_23, t0.is_partner AS is_partner_24, t0.uuid AS uuid_25, t0.updated_at AS updated_at_26, t0.created_at AS created_at_27, t0.fonction_id AS fonction_id_28, t0.entite_id AS entite_id_29, t30.id AS id_31, t30.name AS name_32, t30.solde AS solde_33, t30.number AS number_34, t30.number_fix AS number_fix_35, t30.facebook AS facebook_36, t30.instagram AS instagram_37, t30.linkedin AS linkedin_38, t30.tiktok AS tiktok_39, t30.youtube AS youtube_40, t30.twitter AS twitter_41, t30.description AS description_42, t30.entite_logo AS entite_logo_43, t30.newcomer_open_to_all AS newcomer_open_to_all_44, t30.newcomer_token AS newcomer_token_45, t30.updated_at AS updated_at_46, t30.created_at AS created_at_47, t30.organization_id AS organization_id_48, t30.address_id AS address_id_49, t0.organization_id AS organization_id_50 FROM `user` t0 LEFT JOIN entite t30 ON t0.entite_id = t30.id WHERE t0.email = 'mayoko.arnold@gmail.com' AND ((t0.deleted_at IS NULL)) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 91)
6	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
7	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
8	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
19	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
20	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.77 ms
(23.60%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = ? LIMIT 1

Parameters:

[
  "manager"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.complete_address AS complete_address_4,
  t0.number AS number_5,
  t0.description AS description_6,
  t0.siret AS siret_7,
  t0.siren AS siren_8,
  t0.day_limit_subscription AS day_limit_subscription_9,
  t0.trial_period_days_time AS trial_period_days_time_10,
  t0.trial_period_days_status AS trial_period_days_status_11,
  t0.type AS type_12,
  t0.website AS website_13,
  t0.capital_social AS capital_social_14,
  t0.updated_at AS updated_at_15,
  t0.created_at AS created_at_16
FROM
  manager t0
WHERE
  t0.type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.complete_address AS complete_address_4, t0.number AS number_5, t0.description AS description_6, t0.siret AS siret_7, t0.siren AS siren_8, t0.day_limit_subscription AS day_limit_subscription_9, t0.trial_period_days_time AS trial_period_days_time_10, t0.trial_period_days_status AS trial_period_days_status_11, t0.type AS type_12, t0.website AS website_13, t0.capital_social AS capital_social_14, t0.updated_at AS updated_at_15, t0.created_at AS created_at_16 FROM manager t0 WHERE t0.type = 'manager' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 163)
5	App\Manager\ManagerManager->getFirstManagerByType (line 96)
6	App\Security\AppAuthenticator->onAuthenticationSuccess (line 91)
7	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 233)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 219)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
12	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
15	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
16	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	2
App\Entity\Fonction	1
App\Entity\Organization	1
App\Entity\Entite	1
App\Entity\Address	1
App\Entity\Manager	1
App\Entity\Subscription	1
App\Entity\Packaging	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Fonction	No errors.
App\Entity\Entite	No errors.
App\Entity\Organization	No errors.
App\Entity\Address	No errors.
App\Entity\LinkRegister	No errors.
App\Entity\GroupMemberList	No errors.
App\Entity\LinkRegisterGroup	No errors.
App\Entity\Budget	No errors.
App\Entity\Expense	No errors.
App\Entity\NewMember	No errors.
App\Entity\Worship	No errors.
App\Entity\Invite	No errors.
App\Entity\Meeting	No errors.
App\Entity\Availability	No errors.
App\Entity\Payment	No errors.
App\Entity\Subscription	No errors.
App\Entity\PaymentCard	No errors.
App\Entity\EmailOperator	No errors.
App\Entity\Contribution	No errors.
App\Entity\ContributionTransaction	No errors.
App\Entity\CategoryFonction	No errors.
App\Entity\GroupMessage	No errors.
App\Entity\PromoCode	No errors.
App\Entity\UserPromoCode	No errors.
App\Entity\PartnerEarning	No errors.
App\Entity\PartnerWithdrawal	No errors.
App\Entity\Planning	No errors.
App\Entity\GroupMember	No errors.
App\Entity\EntiteDuplicationQuota	No errors.
App\Entity\Donation	No errors.
App\Entity\PlanningTag	No errors.
App\Entity\Manager	No errors.
App\Entity\SocialMedia	No errors.
App\Entity\Packaging	No errors.

Symfony Profiler

POST https://demo.churchmanager.fr/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping