Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.10 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.01 ms

SELECT t0.id AS id_1, t0.token AS token_2, t0.expires_at AS expires_at_3, t0.is_active AS is_active_4, t0.max_uses AS max_uses_5, t0.current_uses AS current_uses_6, t0.last_used_at AS last_used_at_7, t0.allowed_domain AS allowed_domain_8, t0.is_default AS is_default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.community_id AS community_id_12, t0.event_id AS event_id_13, t0.invited_by_id AS invited_by_id_14 FROM mve_invitations_invitation_token t0 WHERE t0.token = ? LIMIT 1

Parameters:

[
  "b3dd2819606ea4e37b31501e09a3b104ee5cd95a81f7df370d27b3c7ea665070"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.token AS token_2,
  t0.expires_at AS expires_at_3,
  t0.is_active AS is_active_4,
  t0.max_uses AS max_uses_5,
  t0.current_uses AS current_uses_6,
  t0.last_used_at AS last_used_at_7,
  t0.allowed_domain AS allowed_domain_8,
  t0.is_default AS is_default_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.community_id AS community_id_12,
  t0.event_id AS event_id_13,
  t0.invited_by_id AS invited_by_id_14
FROM
  mve_invitations_invitation_token t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.token AS token_2, t0.expires_at AS expires_at_3, t0.is_active AS is_active_4, t0.max_uses AS max_uses_5, t0.current_uses AS current_uses_6, t0.last_used_at AS last_used_at_7, t0.allowed_domain AS allowed_domain_8, t0.is_default AS is_default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.community_id AS community_id_12, t0.event_id AS event_id_13, t0.invited_by_id AS invited_by_id_14 FROM mve_invitations_invitation_token t0 WHERE t0.token = 'b3dd2819606ea4e37b31501e09a3b104ee5cd95a81f7df370d27b3c7ea665070' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 70)
5	App\Controller\Registration\RegistrationController->joinWithToken (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 86)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
10	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
11	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.55 ms

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.name AS name_3, t0.fr_name AS fr_name_4, t0.qr_path AS qr_path_5, t0.slug AS slug_6, t0.status AS status_7, t0.pricing_plan AS pricing_plan_8, t0.require_validation_before_payment AS require_validation_before_payment_9, t0.community_url AS community_url_10, t0.registration_background_url AS registration_background_url_11, t0.signin_brand_config AS signin_brand_config_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.organization_id AS organization_id_15, t0.speciality_id AS speciality_id_16 FROM mve_communities_community t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.name AS name_3,
  t0.fr_name AS fr_name_4,
  t0.qr_path AS qr_path_5,
  t0.slug AS slug_6,
  t0.status AS status_7,
  t0.pricing_plan AS pricing_plan_8,
  t0.require_validation_before_payment AS require_validation_before_payment_9,
  t0.community_url AS community_url_10,
  t0.registration_background_url AS registration_background_url_11,
  t0.signin_brand_config AS signin_brand_config_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.organization_id AS organization_id_15,
  t0.speciality_id AS speciality_id_16
FROM
  mve_communities_community t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.name AS name_3, t0.fr_name AS fr_name_4, t0.qr_path AS qr_path_5, t0.slug AS slug_6, t0.status AS status_7, t0.pricing_plan AS pricing_plan_8, t0.require_validation_before_payment AS require_validation_before_payment_9, t0.community_url AS community_url_10, t0.registration_background_url AS registration_background_url_11, t0.signin_brand_config AS signin_brand_config_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.organization_id AS organization_id_15, t0.speciality_id AS speciality_id_16 FROM mve_communities_community t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Communities\Community::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Communities\Community->__get (line 183)
8	App\Entity\Communities\Community->getOrganization (line 78)
9	App\Controller\Registration\RegistrationController->joinWithToken (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
15	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.55 ms

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.matricule_fiscal AS matricule_fiscal_3, t0.name AS name_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.phone AS phone_8, t0.email AS email_9, t0.web_site AS web_site_10, t0.creation_date AS creation_date_11, t0.description AS description_12, t0.logo_url AS logo_url_13, t0.fav_icon_url AS fav_icon_url_14, t0.status AS status_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.sector_id AS sector_id_18, t0.country_id AS country_id_19, t0.tax_id AS tax_id_20 FROM mve_organizations_organization t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.matricule_fiscal AS matricule_fiscal_3,
  t0.name AS name_4,
  t0.address AS address_5,
  t0.city AS city_6,
  t0.postal_code AS postal_code_7,
  t0.phone AS phone_8,
  t0.email AS email_9,
  t0.web_site AS web_site_10,
  t0.creation_date AS creation_date_11,
  t0.description AS description_12,
  t0.logo_url AS logo_url_13,
  t0.fav_icon_url AS fav_icon_url_14,
  t0.status AS status_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.sector_id AS sector_id_18,
  t0.country_id AS country_id_19,
  t0.tax_id AS tax_id_20
FROM
  mve_organizations_organization t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.matricule_fiscal AS matricule_fiscal_3, t0.name AS name_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.phone AS phone_8, t0.email AS email_9, t0.web_site AS web_site_10, t0.creation_date AS creation_date_11, t0.description AS description_12, t0.logo_url AS logo_url_13, t0.fav_icon_url AS fav_icon_url_14, t0.status AS status_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.sector_id AS sector_id_18, t0.country_id AS country_id_19, t0.tax_id AS tax_id_20 FROM mve_organizations_organization t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Organizations\Organization::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Organizations\Organization->__get (line 229)
8	App\Entity\Organizations\Organization->getEmail (line 78)
9	App\Controller\Registration\RegistrationController->joinWithToken (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 476)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
15	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 451)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 349)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 222)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 188)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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.

Entities Mapping

Class	Mapping errors
App\Entity\Invitations\InvitationToken	No errors.
App\Entity\Communities\Community	No errors.
App\Entity\Events\Event	No errors.
App\Entity\Users\User	No errors.
App\Entity\Organizations\Organization	No errors.
App\Entity\Users\Speciality	No errors.
App\Entity\Cost\Level	No errors.
App\Entity\Cost\CountryGroup	No errors.
App\Entity\Communities\Tag	No errors.
App\Entity\Communities\CommunityOwner	No errors.
App\Entity\Communities\CommunityUser	No errors.
App\Entity\Communities\CustomField	No errors.
App\Entity\Cost\CommunityCost	No errors.
App\Entity\Notifications\Notification	No errors.
App\Entity\Services\EventVenuesArea	No errors.
App\Entity\Services\EventVenues	No errors.
App\Entity\Users\Sector	No errors.
App\Entity\Misc\Country	No errors.
App\Entity\Payments\TaxRate	No errors.
App\Entity\Payments\Purchase	No errors.
App\Entity\Payments\PaymentOrgMethod	No errors.

Symfony Profiler

GET https://features.myvioo.events/registration/join/b3dd2819606ea4e37b31501e09a3b104ee5cd95a81f7df370d27b3c7ea665070

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping