Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.42 ms Query time

4 Invalid entities

18 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.20 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.avatar AS avatar_5, t0.updated_at AS updated_at_6, t0.subscription_started_at AS subscription_started_at_7, t0.subscription_ended_at AS subscription_ended_at_8, t0.type AS type_9, t0.customer_id AS customer_id_10, t0.sub_id AS sub_id_11, t0.subscription_active AS subscription_active_12, t0.subscription_type AS subscription_type_13, t0.created_at AS created_at_14, t0.enabled AS enabled_15, t0.address AS address_16, t0.complement_address AS complement_address_17, t0.zipcode AS zipcode_18, t0.city AS city_19, t0.country AS country_20, t0.first_name AS first_name_21, t0.last_name AS last_name_22, t0.phone AS phone_23, t0.email_validation_code AS email_validation_code_24, t0.email_validation_code_generated_at AS email_validation_code_generated_at_25, t0.reset_token AS reset_token_26, t0.reset_token_expires_at AS reset_token_expires_at_27, t0.credits AS credits_28, t29.id AS id_30, t29.name AS name_31, t29.phone AS phone_32, t29.bio AS bio_33, t29.specialty AS specialty_34, t29.rate AS rate_35, t29.price AS price_36, t29.price_int AS price_int_37, t29.latitude AS latitude_38, t29.longitude AS longitude_39, t29.location_updated_at AS location_updated_at_40, t29.facebook AS facebook_41, t29.instagram AS instagram_42, t29.whatsapp AS whatsapp_43, t29.tiktok AS tiktok_44, t29.user_id AS user_id_45, t46.id AS id_47, t46.phone AS phone_48, t46.name AS name_49, t46.description AS description_50, t46.opening_hours AS opening_hours_51, t46.closed_days AS closed_days_52, t46.latitude AS latitude_53, t46.longitude AS longitude_54, t46.budget AS budget_55, t46.instagram_url AS instagram_url_56, t46.facebook_url AS facebook_url_57, t46.website_url AS website_url_58, t46.rib_url AS rib_url_59, t46.user_id AS user_id_60, t61.id AS id_62, t61.preferred_location AS preferred_location_63, t61.typical_event_budget AS typical_event_budget_64, t61.user_id AS user_id_65 FROM user t0 LEFT JOIN artist t29 ON t29.user_id = t0.id LEFT JOIN establishment t46 ON t46.user_id = t0.id LEFT JOIN user_preferences t61 ON t61.user_id = t0.id WHERE t0.email = ? LIMIT 1

Parameters:

[
  "establishment0@artlink.local"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.avatar AS avatar_5,
  t0.updated_at AS updated_at_6,
  t0.subscription_started_at AS subscription_started_at_7,
  t0.subscription_ended_at AS subscription_ended_at_8,
  t0.type AS type_9,
  t0.customer_id AS customer_id_10,
  t0.sub_id AS sub_id_11,
  t0.subscription_active AS subscription_active_12,
  t0.subscription_type AS subscription_type_13,
  t0.created_at AS created_at_14,
  t0.enabled AS enabled_15,
  t0.address AS address_16,
  t0.complement_address AS complement_address_17,
  t0.zipcode AS zipcode_18,
  t0.city AS city_19,
  t0.country AS country_20,
  t0.first_name AS first_name_21,
  t0.last_name AS last_name_22,
  t0.phone AS phone_23,
  t0.email_validation_code AS email_validation_code_24,
  t0.email_validation_code_generated_at AS email_validation_code_generated_at_25,
  t0.reset_token AS reset_token_26,
  t0.reset_token_expires_at AS reset_token_expires_at_27,
  t0.credits AS credits_28,
  t29.id AS id_30,
  t29.name AS name_31,
  t29.phone AS phone_32,
  t29.bio AS bio_33,
  t29.specialty AS specialty_34,
  t29.rate AS rate_35,
  t29.price AS price_36,
  t29.price_int AS price_int_37,
  t29.latitude AS latitude_38,
  t29.longitude AS longitude_39,
  t29.location_updated_at AS location_updated_at_40,
  t29.facebook AS facebook_41,
  t29.instagram AS instagram_42,
  t29.whatsapp AS whatsapp_43,
  t29.tiktok AS tiktok_44,
  t29.user_id AS user_id_45,
  t46.id AS id_47,
  t46.phone AS phone_48,
  t46.name AS name_49,
  t46.description AS description_50,
  t46.opening_hours AS opening_hours_51,
  t46.closed_days AS closed_days_52,
  t46.latitude AS latitude_53,
  t46.longitude AS longitude_54,
  t46.budget AS budget_55,
  t46.instagram_url AS instagram_url_56,
  t46.facebook_url AS facebook_url_57,
  t46.website_url AS website_url_58,
  t46.rib_url AS rib_url_59,
  t46.user_id AS user_id_60,
  t61.id AS id_62,
  t61.preferred_location AS preferred_location_63,
  t61.typical_event_budget AS typical_event_budget_64,
  t61.user_id AS user_id_65
FROM
  user t0
  LEFT JOIN artist t29 ON t29.user_id = t0.id
  LEFT JOIN establishment t46 ON t46.user_id = t0.id
  LEFT JOIN user_preferences t61 ON t61.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.avatar AS avatar_5, t0.updated_at AS updated_at_6, t0.subscription_started_at AS subscription_started_at_7, t0.subscription_ended_at AS subscription_ended_at_8, t0.type AS type_9, t0.customer_id AS customer_id_10, t0.sub_id AS sub_id_11, t0.subscription_active AS subscription_active_12, t0.subscription_type AS subscription_type_13, t0.created_at AS created_at_14, t0.enabled AS enabled_15, t0.address AS address_16, t0.complement_address AS complement_address_17, t0.zipcode AS zipcode_18, t0.city AS city_19, t0.country AS country_20, t0.first_name AS first_name_21, t0.last_name AS last_name_22, t0.phone AS phone_23, t0.email_validation_code AS email_validation_code_24, t0.email_validation_code_generated_at AS email_validation_code_generated_at_25, t0.reset_token AS reset_token_26, t0.reset_token_expires_at AS reset_token_expires_at_27, t0.credits AS credits_28, t29.id AS id_30, t29.name AS name_31, t29.phone AS phone_32, t29.bio AS bio_33, t29.specialty AS specialty_34, t29.rate AS rate_35, t29.price AS price_36, t29.price_int AS price_int_37, t29.latitude AS latitude_38, t29.longitude AS longitude_39, t29.location_updated_at AS location_updated_at_40, t29.facebook AS facebook_41, t29.instagram AS instagram_42, t29.whatsapp AS whatsapp_43, t29.tiktok AS tiktok_44, t29.user_id AS user_id_45, t46.id AS id_47, t46.phone AS phone_48, t46.name AS name_49, t46.description AS description_50, t46.opening_hours AS opening_hours_51, t46.closed_days AS closed_days_52, t46.latitude AS latitude_53, t46.longitude AS longitude_54, t46.budget AS budget_55, t46.instagram_url AS instagram_url_56, t46.facebook_url AS facebook_url_57, t46.website_url AS website_url_58, t46.rib_url AS rib_url_59, t46.user_id AS user_id_60, t61.id AS id_62, t61.preferred_location AS preferred_location_63, t61.typical_event_budget AS typical_event_budget_64, t61.user_id AS user_id_65 FROM user t0 LEFT JOIN artist t29 ON t29.user_id = t0.id LEFT JOIN establishment t46 ON t46.user_id = t0.id LEFT JOIN user_preferences t61 ON t61.user_id = t0.id WHERE t0.email = 'establishment0@artlink.local' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
5	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 251)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 132)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 87)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 42)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 180)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
20	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 83)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 197)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.12 ms

SELECT t0.id AS id_1, t0.balance_due AS balance_due_2, t0.balance_paid AS balance_paid_3, t0.last_balance_calculation AS last_balance_calculation_4, t0.last_payment_date AS last_payment_date_5, t0.notes AS notes_6, t0.establishment_id AS establishment_id_7, t8.id AS id_9, t8.phone AS phone_10, t8.name AS name_11, t8.description AS description_12, t8.opening_hours AS opening_hours_13, t8.closed_days AS closed_days_14, t8.latitude AS latitude_15, t8.longitude AS longitude_16, t8.budget AS budget_17, t8.instagram_url AS instagram_url_18, t8.facebook_url AS facebook_url_19, t8.website_url AS website_url_20, t8.rib_url AS rib_url_21, t8.user_id AS user_id_22 FROM establishment_finance t0 INNER JOIN establishment t8 ON t0.establishment_id = t8.id WHERE t0.establishment_id = ?

Parameters:

[
  21
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.balance_due AS balance_due_2,
  t0.balance_paid AS balance_paid_3,
  t0.last_balance_calculation AS last_balance_calculation_4,
  t0.last_payment_date AS last_payment_date_5,
  t0.notes AS notes_6,
  t0.establishment_id AS establishment_id_7,
  t8.id AS id_9,
  t8.phone AS phone_10,
  t8.name AS name_11,
  t8.description AS description_12,
  t8.opening_hours AS opening_hours_13,
  t8.closed_days AS closed_days_14,
  t8.latitude AS latitude_15,
  t8.longitude AS longitude_16,
  t8.budget AS budget_17,
  t8.instagram_url AS instagram_url_18,
  t8.facebook_url AS facebook_url_19,
  t8.website_url AS website_url_20,
  t8.rib_url AS rib_url_21,
  t8.user_id AS user_id_22
FROM
  establishment_finance t0
  INNER JOIN establishment t8 ON t0.establishment_id = t8.id
WHERE
  t0.establishment_id = ?

SELECT t0.id AS id_1, t0.balance_due AS balance_due_2, t0.balance_paid AS balance_paid_3, t0.last_balance_calculation AS last_balance_calculation_4, t0.last_payment_date AS last_payment_date_5, t0.notes AS notes_6, t0.establishment_id AS establishment_id_7, t8.id AS id_9, t8.phone AS phone_10, t8.name AS name_11, t8.description AS description_12, t8.opening_hours AS opening_hours_13, t8.closed_days AS closed_days_14, t8.latitude AS latitude_15, t8.longitude AS longitude_16, t8.budget AS budget_17, t8.instagram_url AS instagram_url_18, t8.facebook_url AS facebook_url_19, t8.website_url AS website_url_20, t8.rib_url AS rib_url_21, t8.user_id AS user_id_22 FROM establishment_finance t0 INNER JOIN establishment t8 ON t0.establishment_id = t8.id WHERE t0.establishment_id = 21;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 442)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
9	Doctrine\ORM\EntityRepository->findOneBy (line 125)
10	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
11	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
12	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 251)
13	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 132)
14	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 87)
15	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
16	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 42)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
21	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 180)
22	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
23	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
24	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
25	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
26	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
27	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
28	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 83)
29	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
30	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
31	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
32	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
33	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 197)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 29)
39	require_once (line 5)

0.10 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_fr AS name_fr_3, t0.icon AS icon_4, t0.updated_at AS updated_at_5 FROM type_event_organised t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_fr AS name_fr_3,
  t0.icon AS icon_4,
  t0.updated_at AS updated_at_5
FROM
  type_event_organised t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_fr AS name_fr_3, t0.icon AS icon_4, t0.updated_at AS updated_at_5 FROM type_event_organised t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\API\Type\TypeProviderController->getEvents (line 37)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	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\TypeEventOrganised	15
App\Entity\User	1
App\Entity\Establishment	1
App\Entity\EstablishmentFinance	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Artist	No errors.
App\Entity\Establishment	No errors.
App\Entity\UserPreferences	No errors.
App\Entity\TicketReservation	No errors.
App\Entity\Notification	No errors.
App\Entity\Event	The field App\Entity\Event#collaborations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Collaboration#event does not contain the required 'inversedBy: "collaborations"' attribute.
App\Entity\Feedback	No errors.
App\Entity\EstablishmentPhoto	No errors.
App\Entity\Collaboration	No errors.
App\Entity\TypeEstablishment	The field App\Entity\TypeEstablishment#establishments is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Establishment#typeEstablishments does not contain the required 'mappedBy: "establishments"' attribute.
App\Entity\TypeEventOrganised	The field App\Entity\TypeEventOrganised#userPreferences is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserPreferences#preferredEventTypes does not contain the required 'inversedBy: "userPreferences"' attribute.
App\Entity\TypeEquipement	No errors.
App\Entity\TypeArtiste	No errors.
App\Entity\EstablishmentFinance	The field 'App\Entity\EstablishmentFinance#balanceDue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\EstablishmentFinance#balancePaid' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.

Symfony Profiler

GET https://preprod.artlink-up.com/api/types/events

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping