Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.21 ms Query time

0 Invalid entities

11 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.72 ms

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.username AS username_5, u0_.salt AS salt_6, u0_.google_id AS google_id_7, u0_.facebook_id AS facebook_id_8, u0_.old_id AS old_id_9, u0_.creation_date AS creation_date_10, u0_.last_login AS last_login_11, u0_.newsletter AS newsletter_12, u0_.state AS state_13, u0_.period_grace AS period_grace_14, u0_.deleted_at AS deleted_at_15, u0_.apple_id AS apple_id_16, u0_.longitude AS longitude_17, u0_.latitude AS latitude_18 FROM `user` u0_ WHERE u0_.username = ? OR u0_.email = ?

Parameters:

[
  "Webmaster"
  "Webmaster"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.is_verified AS is_verified_4,
  u0_.username AS username_5,
  u0_.salt AS salt_6,
  u0_.google_id AS google_id_7,
  u0_.facebook_id AS facebook_id_8,
  u0_.old_id AS old_id_9,
  u0_.creation_date AS creation_date_10,
  u0_.last_login AS last_login_11,
  u0_.newsletter AS newsletter_12,
  u0_.state AS state_13,
  u0_.period_grace AS period_grace_14,
  u0_.deleted_at AS deleted_at_15,
  u0_.apple_id AS apple_id_16,
  u0_.longitude AS longitude_17,
  u0_.latitude AS latitude_18
FROM
  `user` u0_
WHERE
  u0_.username = ?
  OR u0_.email = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.username AS username_5, u0_.salt AS salt_6, u0_.google_id AS google_id_7, u0_.facebook_id AS facebook_id_8, u0_.old_id AS old_id_9, u0_.creation_date AS creation_date_10, u0_.last_login AS last_login_11, u0_.newsletter AS newsletter_12, u0_.state AS state_13, u0_.period_grace AS period_grace_14, u0_.deleted_at AS deleted_at_15, u0_.apple_id AS apple_id_16, u0_.longitude AS longitude_17, u0_.latitude AS latitude_18 FROM `user` u0_ WHERE u0_.username = 'Webmaster' OR u0_.email = 'Webmaster';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 56)
7	App\Repository\UserRepository->loadUserByIdentifier (line 60)
8	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
9	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
10	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 91)
11	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
12	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
13	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
19	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
20	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
21	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
22	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
23	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
24	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
25	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
26	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.15 ms

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.sex AS sex_6, t0.index_r AS index_r_7, t0.index_v AS index_v_8, t0.year_of_birth AS year_of_birth_9, t0.newsletter AS newsletter_10, t0.colors AS colors_11, t0.border AS border_12, t0.text_colors AS text_colors_13, t0.nb_shoot AS nb_shoot_14, t0.distance AS distance_15, t0.nb_card AS nb_card_16, t0.nb_competition AS nb_competition_17, t0.used_in_mean_r AS used_in_mean_r_18, t0.avatar AS avatar_19, t0.stableford_setting AS stableford_setting_20, t0.last_for_mean_r AS last_for_mean_r_21, t0.share_public_enabled AS share_public_enabled_22, t0.share_public_slug AS share_public_slug_23, t0.test_sg AS test_sg_24, t0.user_id AS user_id_25 FROM player t0 WHERE t0.user_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.updated_at AS updated_at_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.sex AS sex_6,
  t0.index_r AS index_r_7,
  t0.index_v AS index_v_8,
  t0.year_of_birth AS year_of_birth_9,
  t0.newsletter AS newsletter_10,
  t0.colors AS colors_11,
  t0.border AS border_12,
  t0.text_colors AS text_colors_13,
  t0.nb_shoot AS nb_shoot_14,
  t0.distance AS distance_15,
  t0.nb_card AS nb_card_16,
  t0.nb_competition AS nb_competition_17,
  t0.used_in_mean_r AS used_in_mean_r_18,
  t0.avatar AS avatar_19,
  t0.stableford_setting AS stableford_setting_20,
  t0.last_for_mean_r AS last_for_mean_r_21,
  t0.share_public_enabled AS share_public_enabled_22,
  t0.share_public_slug AS share_public_slug_23,
  t0.test_sg AS test_sg_24,
  t0.user_id AS user_id_25
FROM
  player t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.sex AS sex_6, t0.index_r AS index_r_7, t0.index_v AS index_v_8, t0.year_of_birth AS year_of_birth_9, t0.newsletter AS newsletter_10, t0.colors AS colors_11, t0.border AS border_12, t0.text_colors AS text_colors_13, t0.nb_shoot AS nb_shoot_14, t0.distance AS distance_15, t0.nb_card AS nb_card_16, t0.nb_competition AS nb_competition_17, t0.used_in_mean_r AS used_in_mean_r_18, t0.avatar AS avatar_19, t0.stableford_setting AS stableford_setting_20, t0.last_for_mean_r AS last_for_mean_r_21, t0.share_public_enabled AS share_public_enabled_22, t0.share_public_slug AS share_public_slug_23, t0.test_sg AS test_sg_24, t0.user_id AS user_id_25 FROM player t0 WHERE t0.user_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 876)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3027)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 502)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 272)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1231)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
10	Doctrine\ORM\AbstractQuery->execute (line 959)
11	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 56)
12	App\Repository\UserRepository->loadUserByIdentifier (line 60)
13	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
14	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
15	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 91)
16	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
17	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
18	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (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 178)
23	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
24	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
25	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
26	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
27	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
28	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
29	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
30	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
31	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
32	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
34	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
35	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

0.16 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.line1 AS line1_3, t0.line2 AS line2_4, t0.line3 AS line3_5, t0.city AS city_6, t0.country AS country_7, t0.longitude AS longitude_8, t0.latitude AS latitude_9, t0.state AS state_10, t0.last_name AS last_name_11, t0.first_name AS first_name_12, t0.postal_code AS postal_code_13, t0.public_name AS public_name_14, t0.user_id AS user_id_15, t0.golf_id AS golf_id_16, t17.id AS id_18, t17.amount AS amount_19, t17.token AS token_20, t17.state AS state_21, t17.pro_id AS pro_id_22 FROM pro t0 LEFT JOIN budget t17 ON t17.pro_id = t0.id WHERE t0.user_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.line1 AS line1_3,
  t0.line2 AS line2_4,
  t0.line3 AS line3_5,
  t0.city AS city_6,
  t0.country AS country_7,
  t0.longitude AS longitude_8,
  t0.latitude AS latitude_9,
  t0.state AS state_10,
  t0.last_name AS last_name_11,
  t0.first_name AS first_name_12,
  t0.postal_code AS postal_code_13,
  t0.public_name AS public_name_14,
  t0.user_id AS user_id_15,
  t0.golf_id AS golf_id_16,
  t17.id AS id_18,
  t17.amount AS amount_19,
  t17.token AS token_20,
  t17.state AS state_21,
  t17.pro_id AS pro_id_22
FROM
  pro t0
  LEFT JOIN budget t17 ON t17.pro_id = t0.id
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.line1 AS line1_3, t0.line2 AS line2_4, t0.line3 AS line3_5, t0.city AS city_6, t0.country AS country_7, t0.longitude AS longitude_8, t0.latitude AS latitude_9, t0.state AS state_10, t0.last_name AS last_name_11, t0.first_name AS first_name_12, t0.postal_code AS postal_code_13, t0.public_name AS public_name_14, t0.user_id AS user_id_15, t0.golf_id AS golf_id_16, t17.id AS id_18, t17.amount AS amount_19, t17.token AS token_20, t17.state AS state_21, t17.pro_id AS pro_id_22 FROM pro t0 LEFT JOIN budget t17 ON t17.pro_id = t0.id WHERE t0.user_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 876)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3027)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 502)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 272)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1231)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
10	Doctrine\ORM\AbstractQuery->execute (line 959)
11	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 56)
12	App\Repository\UserRepository->loadUserByIdentifier (line 60)
13	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 208)
14	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
15	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 91)
16	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
17	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
18	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (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 178)
23	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
24	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
25	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
26	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
27	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
28	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
29	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
30	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
31	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
32	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
34	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
35	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

0.18 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug_web AS slug_web_2, c0_.old_slug_web AS old_slug_web_3, c0_.enabled AS enabled_4, c0_.holes_number AS holes_number_5, c0_.type AS type_6, c0_.code AS code_7, c0_.token AS token_8, c0_.creation_date AS creation_date_9, c0_.update_date AS update_date_10, c0_.ffg_slug AS ffg_slug_11, c0_.slug AS slug_12, c0_.golf_name AS golf_name_13, c0_.update_needed AS update_needed_14, t1_.id AS id_15, t1_.enabled AS enabled_16, t1_.name AS name_17, t1_.slope_m AS slope_m_18, t1_.slope_w AS slope_w_19, t1_.sss_m AS sss_m_20, t1_.sss_w AS sss_w_21, t1_.slope_mf AS slope_mf_22, t1_.slope_wf AS slope_wf_23, t1_.sss_mf AS sss_mf_24, t1_.sss_wf AS sss_wf_25, t1_.slope_mb AS slope_mb_26, t1_.slope_wb AS slope_wb_27, t1_.sss_mb AS sss_mb_28, t1_.sss_wb AS sss_wb_29, t1_.holes_number AS holes_number_30, t1_.distance AS distance_31, t1_.creation_date AS creation_date_32, t1_.update_date AS update_date_33, t1_.distances AS distances_34, t1_.pars AS pars_35, t1_.handicap_fbs AS handicap_fbs_36, t1_.handicap_fs AS handicap_fs_37, t1_.handicap_bs AS handicap_bs_38, t1_.distance_by_hole AS distance_by_hole_39, g2_.id AS id_40, g2_.name AS name_41, g2_.slug AS slug_42, g2_.enabled AS enabled_43, g2_.address AS address_44, g2_.city AS city_45, g2_.departement AS departement_46, g2_.country AS country_47, g2_.postal_code AS postal_code_48, g2_.phone AS phone_49, g2_.site AS site_50, g2_.longitude AS longitude_51, g2_.latitude AS latitude_52, g2_.email AS email_53, g2_.creation_date AS creation_date_54, g2_.update_date AS update_date_55, g2_.ffg_slug AS ffg_slug_56, g2_.old_ffg_code AS old_ffg_code_57, g2_.view AS view_58, c0_.golf_id AS golf_id_59, c0_.owner_id AS owner_id_60, t1_.course_id AS course_id_61 FROM course c0_ LEFT JOIN tee t1_ ON c0_.id = t1_.course_id AND (t1_.enabled = ?) LEFT JOIN golf g2_ ON c0_.golf_id = g2_.id WHERE c0_.id = ? AND c0_.enabled = 1 AND (c0_.type = ? OR (c0_.type = ? AND c0_.owner_id = ?)) AND c0_.enabled = ?

Parameters:

[
  1
  93
  "public"
  "private"
  3
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug_web AS slug_web_2,
  c0_.old_slug_web AS old_slug_web_3,
  c0_.enabled AS enabled_4,
  c0_.holes_number AS holes_number_5,
  c0_.type AS type_6,
  c0_.code AS code_7,
  c0_.token AS token_8,
  c0_.creation_date AS creation_date_9,
  c0_.update_date AS update_date_10,
  c0_.ffg_slug AS ffg_slug_11,
  c0_.slug AS slug_12,
  c0_.golf_name AS golf_name_13,
  c0_.update_needed AS update_needed_14,
  t1_.id AS id_15,
  t1_.enabled AS enabled_16,
  t1_.name AS name_17,
  t1_.slope_m AS slope_m_18,
  t1_.slope_w AS slope_w_19,
  t1_.sss_m AS sss_m_20,
  t1_.sss_w AS sss_w_21,
  t1_.slope_mf AS slope_mf_22,
  t1_.slope_wf AS slope_wf_23,
  t1_.sss_mf AS sss_mf_24,
  t1_.sss_wf AS sss_wf_25,
  t1_.slope_mb AS slope_mb_26,
  t1_.slope_wb AS slope_wb_27,
  t1_.sss_mb AS sss_mb_28,
  t1_.sss_wb AS sss_wb_29,
  t1_.holes_number AS holes_number_30,
  t1_.distance AS distance_31,
  t1_.creation_date AS creation_date_32,
  t1_.update_date AS update_date_33,
  t1_.distances AS distances_34,
  t1_.pars AS pars_35,
  t1_.handicap_fbs AS handicap_fbs_36,
  t1_.handicap_fs AS handicap_fs_37,
  t1_.handicap_bs AS handicap_bs_38,
  t1_.distance_by_hole AS distance_by_hole_39,
  g2_.id AS id_40,
  g2_.name AS name_41,
  g2_.slug AS slug_42,
  g2_.enabled AS enabled_43,
  g2_.address AS address_44,
  g2_.city AS city_45,
  g2_.departement AS departement_46,
  g2_.country AS country_47,
  g2_.postal_code AS postal_code_48,
  g2_.phone AS phone_49,
  g2_.site AS site_50,
  g2_.longitude AS longitude_51,
  g2_.latitude AS latitude_52,
  g2_.email AS email_53,
  g2_.creation_date AS creation_date_54,
  g2_.update_date AS update_date_55,
  g2_.ffg_slug AS ffg_slug_56,
  g2_.old_ffg_code AS old_ffg_code_57,
  g2_.view AS view_58,
  c0_.golf_id AS golf_id_59,
  c0_.owner_id AS owner_id_60,
  t1_.course_id AS course_id_61
FROM
  course c0_
  LEFT JOIN tee t1_ ON c0_.id = t1_.course_id
  AND (t1_.enabled = ?)
  LEFT JOIN golf g2_ ON c0_.golf_id = g2_.id
WHERE
  c0_.id = ?
  AND c0_.enabled = 1
  AND (
    c0_.type = ?
    OR (
      c0_.type = ?
      AND c0_.owner_id = ?
    )
  )
  AND c0_.enabled = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug_web AS slug_web_2, c0_.old_slug_web AS old_slug_web_3, c0_.enabled AS enabled_4, c0_.holes_number AS holes_number_5, c0_.type AS type_6, c0_.code AS code_7, c0_.token AS token_8, c0_.creation_date AS creation_date_9, c0_.update_date AS update_date_10, c0_.ffg_slug AS ffg_slug_11, c0_.slug AS slug_12, c0_.golf_name AS golf_name_13, c0_.update_needed AS update_needed_14, t1_.id AS id_15, t1_.enabled AS enabled_16, t1_.name AS name_17, t1_.slope_m AS slope_m_18, t1_.slope_w AS slope_w_19, t1_.sss_m AS sss_m_20, t1_.sss_w AS sss_w_21, t1_.slope_mf AS slope_mf_22, t1_.slope_wf AS slope_wf_23, t1_.sss_mf AS sss_mf_24, t1_.sss_wf AS sss_wf_25, t1_.slope_mb AS slope_mb_26, t1_.slope_wb AS slope_wb_27, t1_.sss_mb AS sss_mb_28, t1_.sss_wb AS sss_wb_29, t1_.holes_number AS holes_number_30, t1_.distance AS distance_31, t1_.creation_date AS creation_date_32, t1_.update_date AS update_date_33, t1_.distances AS distances_34, t1_.pars AS pars_35, t1_.handicap_fbs AS handicap_fbs_36, t1_.handicap_fs AS handicap_fs_37, t1_.handicap_bs AS handicap_bs_38, t1_.distance_by_hole AS distance_by_hole_39, g2_.id AS id_40, g2_.name AS name_41, g2_.slug AS slug_42, g2_.enabled AS enabled_43, g2_.address AS address_44, g2_.city AS city_45, g2_.departement AS departement_46, g2_.country AS country_47, g2_.postal_code AS postal_code_48, g2_.phone AS phone_49, g2_.site AS site_50, g2_.longitude AS longitude_51, g2_.latitude AS latitude_52, g2_.email AS email_53, g2_.creation_date AS creation_date_54, g2_.update_date AS update_date_55, g2_.ffg_slug AS ffg_slug_56, g2_.old_ffg_code AS old_ffg_code_57, g2_.view AS view_58, c0_.golf_id AS golf_id_59, c0_.owner_id AS owner_id_60, t1_.course_id AS course_id_61 FROM course c0_ LEFT JOIN tee t1_ ON c0_.id = t1_.course_id AND (t1_.enabled = 1) LEFT JOIN golf g2_ ON c0_.golf_id = g2_.id WHERE c0_.id = 93 AND c0_.enabled = 1 AND (c0_.type = 'public' OR (c0_.type = 'private' AND c0_.owner_id = 3)) AND c0_.enabled = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 87)
7	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 80)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 86)
10	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 104)
11	ApiPlatform\State\Provider\ParameterProvider->provide (line 50)
12	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 39)
14	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 95)
15	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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\Course\Tee	7
App\Entity\User	1
App\Entity\Player	1
App\Entity\Course\Course	1
App\Entity\Course\Golf	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Player	No errors.
App\Entity\Score\Card	No errors.
App\Entity\Course\Course	No errors.
App\Entity\Message\ThreadParticipant	No errors.
App\Entity\Subscription\Subscription	No errors.
App\Entity\Pro	No errors.
App\Entity\Course\Golf	No errors.
App\Entity\Pro\Budget	No errors.
App\Entity\Course\Tee	No errors.

Symfony Profiler

GET https://balles-dev.ovh/api/courses/93

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping