Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.33 ms Query time

5 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.22 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.11 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)

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	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.
App\Entity\ArtistImage	No errors.
App\Entity\EventImage	No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\MessageReport	No errors.
App\Entity\Setting	No errors.
App\Entity\ErrorLog	No errors.
App\Entity\Report	No errors.
App\Entity\Address	No errors.
App\Entity\LandingPage\FAQ	No errors.
App\Entity\LandingPage\Blog	No errors.
App\Entity\LandingPage\LegalPage	No errors.
App\Entity\LandingPage\Logoreference	No errors.
App\Entity\LandingPage\Testimony	No errors.
App\Entity\Newsletter	No errors.
App\Entity\ContactInvitation	No errors.
App\Entity\CodePromo	The field 'App\Entity\CodePromo#value' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Conversation	No errors.
App\Entity\Frameo\FrameoProduct	No errors.
App\Entity\Frameo\FrameoOrder	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

POST https://preprod.artlink-up.com/api/stripe/init

Configuration Settings

Theme

Page Width