Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

38.56 ms Query time

3 Invalid entities

32 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

21.37 ms
(55.41%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Handler\AuthenticationHandler->onAuthenticationSuccess (line 103)
4	Symfony\Component\Security\Http\Authentication\CustomAuthenticationSuccessHandler->onAuthenticationSuccess (line 42)
5	Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator->onAuthenticationSuccess (line 103)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 91)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 244)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
11	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
12	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
13	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 4)

4.03 ms
(10.44%)

UPDATE user SET last_auth_time = ?, updated_at = ? WHERE id = ?

Parameters:

[
  "2026-07-06 17:40:58"
  "2026-07-06 17:40:58"
  3229
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  user
SET
  last_auth_time = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE user SET last_auth_time = '2026-07-06 17:40:58', updated_at = '2026-07-06 17:40:58' WHERE id = 3229;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Handler\AuthenticationHandler->onAuthenticationSuccess (line 103)
7	Symfony\Component\Security\Http\Authentication\CustomAuthenticationSuccessHandler->onAuthenticationSuccess (line 42)
8	Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator->onAuthenticationSuccess (line 103)
9	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 91)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 244)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 4)

2.58 ms
(6.69%)

SELECT t0.id AS id_1, t0.s3key AS s3key_2, t0.name_file AS name_file_3, t0.url AS url_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM media t0 WHERE t0.id IN (?)

Parameters:

[
  109932
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.s3key AS s3key_2,
  t0.name_file AS name_file_3,
  t0.url AS url_4,
  t0.type AS type_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  media t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.s3key AS s3key_2, t0.name_file AS name_file_3, t0.url AS url_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM media t0 WHERE t0.id IN (109932);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2643)
3	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
4	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
5	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1026)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1819)
7	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
8	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
9	Doctrine\ORM\PersistentCollection->initialize (line 186)
10	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
11	Doctrine\ORM\PersistentCollection->count (line 391)
12	App\Handler\AuthenticationHandler->onAuthenticationSuccess (line 123)
13	Symfony\Component\Security\Http\Authentication\CustomAuthenticationSuccessHandler->onAuthenticationSuccess (line 42)
14	Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator->onAuthenticationSuccess (line 103)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 91)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 244)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
19	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
20	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
21	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
22	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
23	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
24	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
25	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	require_once (line 4)

2.56 ms
(6.64%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Handler\AuthenticationHandler->onAuthenticationSuccess (line 103)
4	Symfony\Component\Security\Http\Authentication\CustomAuthenticationSuccessHandler->onAuthenticationSuccess (line 42)
5	Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator->onAuthenticationSuccess (line 103)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 91)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 244)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
11	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
12	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
13	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 4)

2.47 ms
(6.41%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.subscription_rate AS subscription_rate_3, t0.enable_licensing AS enable_licensing_4, t0.enable_feature_licensing_ad AS enable_feature_licensing_ad_5, t0.enable_feature_licensing_message AS enable_feature_licensing_message_6, t0.enable_feature_licensing_custom_website AS enable_feature_licensing_custom_website_7, t0.xero_access_token AS xero_access_token_8, t0.xero_refresh_token AS xero_refresh_token_9, t0.deleted_at AS deleted_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM organisation t0 WHERE t0.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.subscription_rate AS subscription_rate_3,
  t0.enable_licensing AS enable_licensing_4,
  t0.enable_feature_licensing_ad AS enable_feature_licensing_ad_5,
  t0.enable_feature_licensing_message AS enable_feature_licensing_message_6,
  t0.enable_feature_licensing_custom_website AS enable_feature_licensing_custom_website_7,
  t0.xero_access_token AS xero_access_token_8,
  t0.xero_refresh_token AS xero_refresh_token_9,
  t0.deleted_at AS deleted_at_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  organisation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.subscription_rate AS subscription_rate_3, t0.enable_licensing AS enable_licensing_4, t0.enable_feature_licensing_ad AS enable_feature_licensing_ad_5, t0.enable_feature_licensing_message AS enable_feature_licensing_message_6, t0.enable_feature_licensing_custom_website AS enable_feature_licensing_custom_website_7, t0.xero_access_token AS xero_access_token_8, t0.xero_refresh_token AS xero_refresh_token_9, t0.deleted_at AS deleted_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM organisation t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Organisation\Organisation::getClinics (line 173)
5	App\Handler\AuthenticationHandler->onAuthenticationSuccess (line 123)
6	Symfony\Component\Security\Http\Authentication\CustomAuthenticationSuccessHandler->onAuthenticationSuccess (line 42)
7	Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator->onAuthenticationSuccess (line 103)
8	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 91)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 244)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
13	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
14	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
16	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 4)

2.10 ms
(5.45%)

SELECT l0_.id AS id_0, l0_.point_login AS point_login_1, l0_.created_at AS created_at_2, l0_.updated_at AS updated_at_3, l0_.user_id AS user_id_4 FROM login_log l0_ WHERE l0_.user_id = ? AND l0_.point_login = ? ORDER BY l0_.created_at DESC LIMIT 1

Parameters:

[
  3229
  "LOGIN_WEB"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.point_login AS point_login_1,
  l0_.created_at AS created_at_2,
  l0_.updated_at AS updated_at_3,
  l0_.user_id AS user_id_4
FROM
  login_log l0_
WHERE
  l0_.user_id = ?
  AND l0_.point_login = ?
ORDER BY
  l0_.created_at DESC
LIMIT
  1

SELECT l0_.id AS id_0, l0_.point_login AS point_login_1, l0_.created_at AS created_at_2, l0_.updated_at AS updated_at_3, l0_.user_id AS user_id_4 FROM login_log l0_ WHERE l0_.user_id = 3229 AND l0_.point_login = 'LOGIN_WEB' ORDER BY l0_.created_at DESC LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\Person\LoginLogRepository->findLastLoginByUser (line 27)
7	App\Handler\AuthenticationHandler->onAuthenticationSuccess (line 89)
8	Symfony\Component\Security\Http\Authentication\CustomAuthenticationSuccessHandler->onAuthenticationSuccess (line 42)
9	Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator->onAuthenticationSuccess (line 103)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 91)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 244)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 4)

1.52 ms
(3.95%)

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.full_name AS full_name_5, u0_.password AS password_6, u0_.booking_btn_name AS booking_btn_name_7, u0_.booking_btn_clr AS booking_btn_clr_8, u0_.booking_btn_bg_clr AS booking_btn_bg_clr_9, u0_.inner_color AS inner_color_10, u0_.outer_color AS outer_color_11, u0_.background_img AS background_img_12, u0_.profile_img AS profile_img_13, u0_.role AS role_14, u0_.enabled AS enabled_15, u0_.locked AS locked_16, u0_.visible AS visible_17, u0_.is_disengaged AS is_disengaged_18, u0_.otp AS otp_19, u0_.otp_sent_at AS otp_sent_at_20, u0_.last_otp_verified AS last_otp_verified_21, u0_.imap_setting AS imap_setting_22, u0_.country_code AS country_code_23, u0_.phone AS phone_24, u0_.practitioner_commission AS practitioner_commission_25, u0_.coordinator_commission AS coordinator_commission_26, u0_.course_commission AS course_commission_27, u0_.membership_commission AS membership_commission_28, u0_.product_commission AS product_commission_29, u0_.token AS token_30, u0_.access_all_calendars AS access_all_calendars_31, u0_.current_auth_token AS current_auth_token_32, u0_.last_auth_time AS last_auth_time_33, u0_.hash AS hash_34, u0_.fcm_token AS fcm_token_35, u0_.hx_change_token AS hx_change_token_36, u0_.login_from AS login_from_37, u0_.ever_login_in_v3 AS ever_login_in_v3_38, u0_.permissions AS permissions_39, u0_.clinic_id AS clinic_id_40, u0_.fp_promoter_id AS fp_promoter_id_41, u0_.referral_link AS referral_link_42, u0_.fp_tracking_id AS fp_tracking_id_43, u0_.receive_special_offer_email AS receive_special_offer_email_44, u0_.receive_special_offer_sms AS receive_special_offer_sms_45, u0_.deleted_at AS deleted_at_46, u0_.created_at AS created_at_47, u0_.updated_at AS updated_at_48, u0_.stripe_customer_id AS stripe_customer_id_49, u0_.stripe_customer_id AS stripe_customer_id_50, u0_.status AS status_51, u0_.birthday AS birthday_52, u0_.country_code_alt AS country_code_alt_53, u0_.secondary_phone AS secondary_phone_54, u0_.next_kin AS next_kin_55, u0_.next_kin_phone AS next_kin_phone_56, u0_.description AS description_57, u0_.glogau_scale AS glogau_scale_58, u0_.fitzpatrick_scale AS fitzpatrick_scale_59, u0_.gender AS gender_60, u0_.receive_special_offer_push AS receive_special_offer_push_61, u0_.receive_reminder_email AS receive_reminder_email_62, u0_.receive_reminder_sms AS receive_reminder_sms_63, u0_.receive_reminder_push AS receive_reminder_push_64, u0_.parent_user_id AS parent_user_id_65, u0_.account_type AS account_type_66, u0_.terms_accepted AS terms_accepted_67, u0_.terms_accepted_patient_mode AS terms_accepted_patient_mode_68, u0_.referral AS referral_69, u0_.export_in_progress AS export_in_progress_70, u0_.occupation AS occupation_71, u0_.number_nhs AS number_nhs_72, u0_.gp_name AS gp_name_73, u0_.contact_gp AS contact_gp_74, u0_.gp_address1 AS gp_address1_75, u0_.gp_address2 AS gp_address2_76, u0_.gp_town AS gp_town_77, u0_.gp_county AS gp_county_78, u0_.gp_post_code AS gp_post_code_79, u0_.gp_country AS gp_country_80, u0_.ref AS ref_81, u0_.chronoscan_code AS chronoscan_code_82, u0_.ethnicity AS ethnicity_83, u0_.height AS height_84, u0_.weight AS weight_85, u0_.passport AS passport_86, u0_.reference_number AS reference_number_87, u0_.photo_consent AS photo_consent_88, u0_.all_marketing AS all_marketing_89, u0_.in_clinic_marketing AS in_clinic_marketing_90, u0_.in_consultation AS in_consultation_91, u0_.interested_in AS interested_in_92, u0_.consultation_type AS consultation_type_93, u0_.google_click_id AS google_click_id_94, u0_.campaign_name AS campaign_name_95, u0_.campaign_source AS campaign_source_96, u0_.campaign_medium AS campaign_medium_97, u0_.campaign_term AS campaign_term_98, u0_.campaign_content AS campaign_content_99, u0_.marketing_source AS marketing_source_100, u0_.author AS author_101, u0_.address1 AS address1_102, u0_.address2 AS address2_103, u0_.town AS town_104, u0_.state AS state_105, u0_.country AS country_106, u0_.postcode AS postcode_107, u0_.qualification AS qualification_108, u0_.summary AS summary_109, u0_.deleted AS deleted_110, u0_.calendar_color AS calendar_color_111, u0_.calendar_order_number AS calendar_order_number_112, u0_.calendar_id AS calendar_id_113, u0_.position AS position_114, u0_.online_booking_availability AS online_booking_availability_115, u0_.title AS title_116, u0_.email_verify AS email_verify_117, u0_.hash_user_short_url AS hash_user_short_url_118, u0_.licence_number AS licence_number_119, u0_.stripe_customer_id AS stripe_customer_id_120, u0_.is_online AS is_online_121, u0_.last_call_time AS last_call_time_122, u0_.hide_report_menus AS hide_report_menus_123, u0_.type AS type_124, u0_.media_id AS media_id_125, u0_.device_id AS device_id_126, u0_.created_by_id AS created_by_id_127, u0_.organisation_id AS organisation_id_128, u0_.current_clinic_id AS current_clinic_id_129, u0_.parent_id AS parent_id_130, u0_.active_photo_id AS active_photo_id_131, u0_.bar_code_image_id AS bar_code_image_id_132, u0_.clinic_id AS clinic_id_133, u0_.prospect_id AS prospect_id_134, u0_.clinic_id AS clinic_id_135, u0_.i_calendar_id AS i_calendar_id_136 FROM user u0_ LEFT JOIN device d1_ ON u0_.device_id = d1_.id WHERE (d1_.token = ? AND d1_.expired_at > ? AND d1_.logout_by_reason_of_license <> 1) AND u0_.type IN ('admin', 'admin_support', 'super_clinic_admin', 'patient', 'clinic_user') LIMIT 1

Parameters:

[
  "demo"
  "2026-07-06 17:40:57"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.email AS email_2,
  u0_.first_name AS first_name_3,
  u0_.last_name AS last_name_4,
  u0_.full_name AS full_name_5,
  u0_.password AS password_6,
  u0_.booking_btn_name AS booking_btn_name_7,
  u0_.booking_btn_clr AS booking_btn_clr_8,
  u0_.booking_btn_bg_clr AS booking_btn_bg_clr_9,
  u0_.inner_color AS inner_color_10,
  u0_.outer_color AS outer_color_11,
  u0_.background_img AS background_img_12,
  u0_.profile_img AS profile_img_13,
  u0_.role AS role_14,
  u0_.enabled AS enabled_15,
  u0_.locked AS locked_16,
  u0_.visible AS visible_17,
  u0_.is_disengaged AS is_disengaged_18,
  u0_.otp AS otp_19,
  u0_.otp_sent_at AS otp_sent_at_20,
  u0_.last_otp_verified AS last_otp_verified_21,
  u0_.imap_setting AS imap_setting_22,
  u0_.country_code AS country_code_23,
  u0_.phone AS phone_24,
  u0_.practitioner_commission AS practitioner_commission_25,
  u0_.coordinator_commission AS coordinator_commission_26,
  u0_.course_commission AS course_commission_27,
  u0_.membership_commission AS membership_commission_28,
  u0_.product_commission AS product_commission_29,
  u0_.token AS token_30,
  u0_.access_all_calendars AS access_all_calendars_31,
  u0_.current_auth_token AS current_auth_token_32,
  u0_.last_auth_time AS last_auth_time_33,
  u0_.hash AS hash_34,
  u0_.fcm_token AS fcm_token_35,
  u0_.hx_change_token AS hx_change_token_36,
  u0_.login_from AS login_from_37,
  u0_.ever_login_in_v3 AS ever_login_in_v3_38,
  u0_.permissions AS permissions_39,
  u0_.clinic_id AS clinic_id_40,
  u0_.fp_promoter_id AS fp_promoter_id_41,
  u0_.referral_link AS referral_link_42,
  u0_.fp_tracking_id AS fp_tracking_id_43,
  u0_.receive_special_offer_email AS receive_special_offer_email_44,
  u0_.receive_special_offer_sms AS receive_special_offer_sms_45,
  u0_.deleted_at AS deleted_at_46,
  u0_.created_at AS created_at_47,
  u0_.updated_at AS updated_at_48,
  u0_.stripe_customer_id AS stripe_customer_id_49,
  u0_.stripe_customer_id AS stripe_customer_id_50,
  u0_.status AS status_51,
  u0_.birthday AS birthday_52,
  u0_.country_code_alt AS country_code_alt_53,
  u0_.secondary_phone AS secondary_phone_54,
  u0_.next_kin AS next_kin_55,
  u0_.next_kin_phone AS next_kin_phone_56,
  u0_.description AS description_57,
  u0_.glogau_scale AS glogau_scale_58,
  u0_.fitzpatrick_scale AS fitzpatrick_scale_59,
  u0_.gender AS gender_60,
  u0_.receive_special_offer_push AS receive_special_offer_push_61,
  u0_.receive_reminder_email AS receive_reminder_email_62,
  u0_.receive_reminder_sms AS receive_reminder_sms_63,
  u0_.receive_reminder_push AS receive_reminder_push_64,
  u0_.parent_user_id AS parent_user_id_65,
  u0_.account_type AS account_type_66,
  u0_.terms_accepted AS terms_accepted_67,
  u0_.terms_accepted_patient_mode AS terms_accepted_patient_mode_68,
  u0_.referral AS referral_69,
  u0_.export_in_progress AS export_in_progress_70,
  u0_.occupation AS occupation_71,
  u0_.number_nhs AS number_nhs_72,
  u0_.gp_name AS gp_name_73,
  u0_.contact_gp AS contact_gp_74,
  u0_.gp_address1 AS gp_address1_75,
  u0_.gp_address2 AS gp_address2_76,
  u0_.gp_town AS gp_town_77,
  u0_.gp_county AS gp_county_78,
  u0_.gp_post_code AS gp_post_code_79,
  u0_.gp_country AS gp_country_80,
  u0_.ref AS ref_81,
  u0_.chronoscan_code AS chronoscan_code_82,
  u0_.ethnicity AS ethnicity_83,
  u0_.height AS height_84,
  u0_.weight AS weight_85,
  u0_.passport AS passport_86,
  u0_.reference_number AS reference_number_87,
  u0_.photo_consent AS photo_consent_88,
  u0_.all_marketing AS all_marketing_89,
  u0_.in_clinic_marketing AS in_clinic_marketing_90,
  u0_.in_consultation AS in_consultation_91,
  u0_.interested_in AS interested_in_92,
  u0_.consultation_type AS consultation_type_93,
  u0_.google_click_id AS google_click_id_94,
  u0_.campaign_name AS campaign_name_95,
  u0_.campaign_source AS campaign_source_96,
  u0_.campaign_medium AS campaign_medium_97,
  u0_.campaign_term AS campaign_term_98,
  u0_.campaign_content AS campaign_content_99,
  u0_.marketing_source AS marketing_source_100,
  u0_.author AS author_101,
  u0_.address1 AS address1_102,
  u0_.address2 AS address2_103,
  u0_.town AS town_104,
  u0_.state AS state_105,
  u0_.country AS country_106,
  u0_.postcode AS postcode_107,
  u0_.qualification AS qualification_108,
  u0_.summary AS summary_109,
  u0_.deleted AS deleted_110,
  u0_.calendar_color AS calendar_color_111,
  u0_.calendar_order_number AS calendar_order_number_112,
  u0_.calendar_id AS calendar_id_113,
  u0_.position AS position_114,
  u0_.online_booking_availability AS online_booking_availability_115,
  u0_.title AS title_116,
  u0_.email_verify AS email_verify_117,
  u0_.hash_user_short_url AS hash_user_short_url_118,
  u0_.licence_number AS licence_number_119,
  u0_.stripe_customer_id AS stripe_customer_id_120,
  u0_.is_online AS is_online_121,
  u0_.last_call_time AS last_call_time_122,
  u0_.hide_report_menus AS hide_report_menus_123,
  u0_.type AS type_124,
  u0_.media_id AS media_id_125,
  u0_.device_id AS device_id_126,
  u0_.created_by_id AS created_by_id_127,
  u0_.organisation_id AS organisation_id_128,
  u0_.current_clinic_id AS current_clinic_id_129,
  u0_.parent_id AS parent_id_130,
  u0_.active_photo_id AS active_photo_id_131,
  u0_.bar_code_image_id AS bar_code_image_id_132,
  u0_.clinic_id AS clinic_id_133,
  u0_.prospect_id AS prospect_id_134,
  u0_.clinic_id AS clinic_id_135,
  u0_.i_calendar_id AS i_calendar_id_136
FROM
  user u0_
  LEFT JOIN device d1_ ON u0_.device_id = d1_.id
WHERE
  (
    d1_.token = ?
    AND d1_.expired_at > ?
    AND d1_.logout_by_reason_of_license <> 1
  )
  AND u0_.type IN (
    'admin', 'admin_support', 'super_clinic_admin',
    'patient', 'clinic_user'
  )
LIMIT
  1

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.full_name AS full_name_5, u0_.password AS password_6, u0_.booking_btn_name AS booking_btn_name_7, u0_.booking_btn_clr AS booking_btn_clr_8, u0_.booking_btn_bg_clr AS booking_btn_bg_clr_9, u0_.inner_color AS inner_color_10, u0_.outer_color AS outer_color_11, u0_.background_img AS background_img_12, u0_.profile_img AS profile_img_13, u0_.role AS role_14, u0_.enabled AS enabled_15, u0_.locked AS locked_16, u0_.visible AS visible_17, u0_.is_disengaged AS is_disengaged_18, u0_.otp AS otp_19, u0_.otp_sent_at AS otp_sent_at_20, u0_.last_otp_verified AS last_otp_verified_21, u0_.imap_setting AS imap_setting_22, u0_.country_code AS country_code_23, u0_.phone AS phone_24, u0_.practitioner_commission AS practitioner_commission_25, u0_.coordinator_commission AS coordinator_commission_26, u0_.course_commission AS course_commission_27, u0_.membership_commission AS membership_commission_28, u0_.product_commission AS product_commission_29, u0_.token AS token_30, u0_.access_all_calendars AS access_all_calendars_31, u0_.current_auth_token AS current_auth_token_32, u0_.last_auth_time AS last_auth_time_33, u0_.hash AS hash_34, u0_.fcm_token AS fcm_token_35, u0_.hx_change_token AS hx_change_token_36, u0_.login_from AS login_from_37, u0_.ever_login_in_v3 AS ever_login_in_v3_38, u0_.permissions AS permissions_39, u0_.clinic_id AS clinic_id_40, u0_.fp_promoter_id AS fp_promoter_id_41, u0_.referral_link AS referral_link_42, u0_.fp_tracking_id AS fp_tracking_id_43, u0_.receive_special_offer_email AS receive_special_offer_email_44, u0_.receive_special_offer_sms AS receive_special_offer_sms_45, u0_.deleted_at AS deleted_at_46, u0_.created_at AS created_at_47, u0_.updated_at AS updated_at_48, u0_.stripe_customer_id AS stripe_customer_id_49, u0_.stripe_customer_id AS stripe_customer_id_50, u0_.status AS status_51, u0_.birthday AS birthday_52, u0_.country_code_alt AS country_code_alt_53, u0_.secondary_phone AS secondary_phone_54, u0_.next_kin AS next_kin_55, u0_.next_kin_phone AS next_kin_phone_56, u0_.description AS description_57, u0_.glogau_scale AS glogau_scale_58, u0_.fitzpatrick_scale AS fitzpatrick_scale_59, u0_.gender AS gender_60, u0_.receive_special_offer_push AS receive_special_offer_push_61, u0_.receive_reminder_email AS receive_reminder_email_62, u0_.receive_reminder_sms AS receive_reminder_sms_63, u0_.receive_reminder_push AS receive_reminder_push_64, u0_.parent_user_id AS parent_user_id_65, u0_.account_type AS account_type_66, u0_.terms_accepted AS terms_accepted_67, u0_.terms_accepted_patient_mode AS terms_accepted_patient_mode_68, u0_.referral AS referral_69, u0_.export_in_progress AS export_in_progress_70, u0_.occupation AS occupation_71, u0_.number_nhs AS number_nhs_72, u0_.gp_name AS gp_name_73, u0_.contact_gp AS contact_gp_74, u0_.gp_address1 AS gp_address1_75, u0_.gp_address2 AS gp_address2_76, u0_.gp_town AS gp_town_77, u0_.gp_county AS gp_county_78, u0_.gp_post_code AS gp_post_code_79, u0_.gp_country AS gp_country_80, u0_.ref AS ref_81, u0_.chronoscan_code AS chronoscan_code_82, u0_.ethnicity AS ethnicity_83, u0_.height AS height_84, u0_.weight AS weight_85, u0_.passport AS passport_86, u0_.reference_number AS reference_number_87, u0_.photo_consent AS photo_consent_88, u0_.all_marketing AS all_marketing_89, u0_.in_clinic_marketing AS in_clinic_marketing_90, u0_.in_consultation AS in_consultation_91, u0_.interested_in AS interested_in_92, u0_.consultation_type AS consultation_type_93, u0_.google_click_id AS google_click_id_94, u0_.campaign_name AS campaign_name_95, u0_.campaign_source AS campaign_source_96, u0_.campaign_medium AS campaign_medium_97, u0_.campaign_term AS campaign_term_98, u0_.campaign_content AS campaign_content_99, u0_.marketing_source AS marketing_source_100, u0_.author AS author_101, u0_.address1 AS address1_102, u0_.address2 AS address2_103, u0_.town AS town_104, u0_.state AS state_105, u0_.country AS country_106, u0_.postcode AS postcode_107, u0_.qualification AS qualification_108, u0_.summary AS summary_109, u0_.deleted AS deleted_110, u0_.calendar_color AS calendar_color_111, u0_.calendar_order_number AS calendar_order_number_112, u0_.calendar_id AS calendar_id_113, u0_.position AS position_114, u0_.online_booking_availability AS online_booking_availability_115, u0_.title AS title_116, u0_.email_verify AS email_verify_117, u0_.hash_user_short_url AS hash_user_short_url_118, u0_.licence_number AS licence_number_119, u0_.stripe_customer_id AS stripe_customer_id_120, u0_.is_online AS is_online_121, u0_.last_call_time AS last_call_time_122, u0_.hide_report_menus AS hide_report_menus_123, u0_.type AS type_124, u0_.media_id AS media_id_125, u0_.device_id AS device_id_126, u0_.created_by_id AS created_by_id_127, u0_.organisation_id AS organisation_id_128, u0_.current_clinic_id AS current_clinic_id_129, u0_.parent_id AS parent_id_130, u0_.active_photo_id AS active_photo_id_131, u0_.bar_code_image_id AS bar_code_image_id_132, u0_.clinic_id AS clinic_id_133, u0_.prospect_id AS prospect_id_134, u0_.clinic_id AS clinic_id_135, u0_.i_calendar_id AS i_calendar_id_136 FROM user u0_ LEFT JOIN device d1_ ON u0_.device_id = d1_.id WHERE (d1_.token = 'demo' AND d1_.expired_at > '2026-07-06 17:40:57' AND d1_.logout_by_reason_of_license <> 1) AND u0_.type IN ('admin', 'admin_support', 'super_clinic_admin', 'patient', 'clinic_user') LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\Person\UserRepository->loadUserByUsername (line 68)
7	App\Repository\Person\UserRepository->loadUserByIdentifier (line 99)
8	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 64)
9	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
10	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
11	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
19	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
20	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
21	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
22	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
23	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
24	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 4)

1.06 ms
(2.74%)

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.full_name AS full_name_5, u0_.password AS password_6, u0_.booking_btn_name AS booking_btn_name_7, u0_.booking_btn_clr AS booking_btn_clr_8, u0_.booking_btn_bg_clr AS booking_btn_bg_clr_9, u0_.inner_color AS inner_color_10, u0_.outer_color AS outer_color_11, u0_.background_img AS background_img_12, u0_.profile_img AS profile_img_13, u0_.role AS role_14, u0_.enabled AS enabled_15, u0_.locked AS locked_16, u0_.visible AS visible_17, u0_.is_disengaged AS is_disengaged_18, u0_.otp AS otp_19, u0_.otp_sent_at AS otp_sent_at_20, u0_.last_otp_verified AS last_otp_verified_21, u0_.imap_setting AS imap_setting_22, u0_.country_code AS country_code_23, u0_.phone AS phone_24, u0_.practitioner_commission AS practitioner_commission_25, u0_.coordinator_commission AS coordinator_commission_26, u0_.course_commission AS course_commission_27, u0_.membership_commission AS membership_commission_28, u0_.product_commission AS product_commission_29, u0_.token AS token_30, u0_.access_all_calendars AS access_all_calendars_31, u0_.current_auth_token AS current_auth_token_32, u0_.last_auth_time AS last_auth_time_33, u0_.hash AS hash_34, u0_.fcm_token AS fcm_token_35, u0_.hx_change_token AS hx_change_token_36, u0_.login_from AS login_from_37, u0_.ever_login_in_v3 AS ever_login_in_v3_38, u0_.permissions AS permissions_39, u0_.clinic_id AS clinic_id_40, u0_.fp_promoter_id AS fp_promoter_id_41, u0_.referral_link AS referral_link_42, u0_.fp_tracking_id AS fp_tracking_id_43, u0_.receive_special_offer_email AS receive_special_offer_email_44, u0_.receive_special_offer_sms AS receive_special_offer_sms_45, u0_.deleted_at AS deleted_at_46, u0_.created_at AS created_at_47, u0_.updated_at AS updated_at_48, u0_.stripe_customer_id AS stripe_customer_id_49, u0_.stripe_customer_id AS stripe_customer_id_50, u0_.status AS status_51, u0_.birthday AS birthday_52, u0_.country_code_alt AS country_code_alt_53, u0_.secondary_phone AS secondary_phone_54, u0_.next_kin AS next_kin_55, u0_.next_kin_phone AS next_kin_phone_56, u0_.description AS description_57, u0_.glogau_scale AS glogau_scale_58, u0_.fitzpatrick_scale AS fitzpatrick_scale_59, u0_.gender AS gender_60, u0_.receive_special_offer_push AS receive_special_offer_push_61, u0_.receive_reminder_email AS receive_reminder_email_62, u0_.receive_reminder_sms AS receive_reminder_sms_63, u0_.receive_reminder_push AS receive_reminder_push_64, u0_.parent_user_id AS parent_user_id_65, u0_.account_type AS account_type_66, u0_.terms_accepted AS terms_accepted_67, u0_.terms_accepted_patient_mode AS terms_accepted_patient_mode_68, u0_.referral AS referral_69, u0_.export_in_progress AS export_in_progress_70, u0_.occupation AS occupation_71, u0_.number_nhs AS number_nhs_72, u0_.gp_name AS gp_name_73, u0_.contact_gp AS contact_gp_74, u0_.gp_address1 AS gp_address1_75, u0_.gp_address2 AS gp_address2_76, u0_.gp_town AS gp_town_77, u0_.gp_county AS gp_county_78, u0_.gp_post_code AS gp_post_code_79, u0_.gp_country AS gp_country_80, u0_.ref AS ref_81, u0_.chronoscan_code AS chronoscan_code_82, u0_.ethnicity AS ethnicity_83, u0_.height AS height_84, u0_.weight AS weight_85, u0_.passport AS passport_86, u0_.reference_number AS reference_number_87, u0_.photo_consent AS photo_consent_88, u0_.all_marketing AS all_marketing_89, u0_.in_clinic_marketing AS in_clinic_marketing_90, u0_.in_consultation AS in_consultation_91, u0_.interested_in AS interested_in_92, u0_.consultation_type AS consultation_type_93, u0_.google_click_id AS google_click_id_94, u0_.campaign_name AS campaign_name_95, u0_.campaign_source AS campaign_source_96, u0_.campaign_medium AS campaign_medium_97, u0_.campaign_term AS campaign_term_98, u0_.campaign_content AS campaign_content_99, u0_.marketing_source AS marketing_source_100, u0_.author AS author_101, u0_.address1 AS address1_102, u0_.address2 AS address2_103, u0_.town AS town_104, u0_.state AS state_105, u0_.country AS country_106, u0_.postcode AS postcode_107, u0_.qualification AS qualification_108, u0_.summary AS summary_109, u0_.deleted AS deleted_110, u0_.calendar_color AS calendar_color_111, u0_.calendar_order_number AS calendar_order_number_112, u0_.calendar_id AS calendar_id_113, u0_.position AS position_114, u0_.online_booking_availability AS online_booking_availability_115, u0_.title AS title_116, u0_.email_verify AS email_verify_117, u0_.hash_user_short_url AS hash_user_short_url_118, u0_.licence_number AS licence_number_119, u0_.stripe_customer_id AS stripe_customer_id_120, u0_.is_online AS is_online_121, u0_.last_call_time AS last_call_time_122, u0_.hide_report_menus AS hide_report_menus_123, u0_.type AS type_124, u0_.media_id AS media_id_125, u0_.device_id AS device_id_126, u0_.created_by_id AS created_by_id_127, u0_.organisation_id AS organisation_id_128, u0_.current_clinic_id AS current_clinic_id_129, u0_.parent_id AS parent_id_130, u0_.active_photo_id AS active_photo_id_131, u0_.bar_code_image_id AS bar_code_image_id_132, u0_.clinic_id AS clinic_id_133, u0_.prospect_id AS prospect_id_134, u0_.clinic_id AS clinic_id_135, u0_.i_calendar_id AS i_calendar_id_136 FROM user u0_ WHERE (u0_.username = ?) AND u0_.type IN ('admin', 'admin_support', 'super_clinic_admin', 'patient', 'clinic_user') LIMIT 1

Parameters:

[
  "demo"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.email AS email_2,
  u0_.first_name AS first_name_3,
  u0_.last_name AS last_name_4,
  u0_.full_name AS full_name_5,
  u0_.password AS password_6,
  u0_.booking_btn_name AS booking_btn_name_7,
  u0_.booking_btn_clr AS booking_btn_clr_8,
  u0_.booking_btn_bg_clr AS booking_btn_bg_clr_9,
  u0_.inner_color AS inner_color_10,
  u0_.outer_color AS outer_color_11,
  u0_.background_img AS background_img_12,
  u0_.profile_img AS profile_img_13,
  u0_.role AS role_14,
  u0_.enabled AS enabled_15,
  u0_.locked AS locked_16,
  u0_.visible AS visible_17,
  u0_.is_disengaged AS is_disengaged_18,
  u0_.otp AS otp_19,
  u0_.otp_sent_at AS otp_sent_at_20,
  u0_.last_otp_verified AS last_otp_verified_21,
  u0_.imap_setting AS imap_setting_22,
  u0_.country_code AS country_code_23,
  u0_.phone AS phone_24,
  u0_.practitioner_commission AS practitioner_commission_25,
  u0_.coordinator_commission AS coordinator_commission_26,
  u0_.course_commission AS course_commission_27,
  u0_.membership_commission AS membership_commission_28,
  u0_.product_commission AS product_commission_29,
  u0_.token AS token_30,
  u0_.access_all_calendars AS access_all_calendars_31,
  u0_.current_auth_token AS current_auth_token_32,
  u0_.last_auth_time AS last_auth_time_33,
  u0_.hash AS hash_34,
  u0_.fcm_token AS fcm_token_35,
  u0_.hx_change_token AS hx_change_token_36,
  u0_.login_from AS login_from_37,
  u0_.ever_login_in_v3 AS ever_login_in_v3_38,
  u0_.permissions AS permissions_39,
  u0_.clinic_id AS clinic_id_40,
  u0_.fp_promoter_id AS fp_promoter_id_41,
  u0_.referral_link AS referral_link_42,
  u0_.fp_tracking_id AS fp_tracking_id_43,
  u0_.receive_special_offer_email AS receive_special_offer_email_44,
  u0_.receive_special_offer_sms AS receive_special_offer_sms_45,
  u0_.deleted_at AS deleted_at_46,
  u0_.created_at AS created_at_47,
  u0_.updated_at AS updated_at_48,
  u0_.stripe_customer_id AS stripe_customer_id_49,
  u0_.stripe_customer_id AS stripe_customer_id_50,
  u0_.status AS status_51,
  u0_.birthday AS birthday_52,
  u0_.country_code_alt AS country_code_alt_53,
  u0_.secondary_phone AS secondary_phone_54,
  u0_.next_kin AS next_kin_55,
  u0_.next_kin_phone AS next_kin_phone_56,
  u0_.description AS description_57,
  u0_.glogau_scale AS glogau_scale_58,
  u0_.fitzpatrick_scale AS fitzpatrick_scale_59,
  u0_.gender AS gender_60,
  u0_.receive_special_offer_push AS receive_special_offer_push_61,
  u0_.receive_reminder_email AS receive_reminder_email_62,
  u0_.receive_reminder_sms AS receive_reminder_sms_63,
  u0_.receive_reminder_push AS receive_reminder_push_64,
  u0_.parent_user_id AS parent_user_id_65,
  u0_.account_type AS account_type_66,
  u0_.terms_accepted AS terms_accepted_67,
  u0_.terms_accepted_patient_mode AS terms_accepted_patient_mode_68,
  u0_.referral AS referral_69,
  u0_.export_in_progress AS export_in_progress_70,
  u0_.occupation AS occupation_71,
  u0_.number_nhs AS number_nhs_72,
  u0_.gp_name AS gp_name_73,
  u0_.contact_gp AS contact_gp_74,
  u0_.gp_address1 AS gp_address1_75,
  u0_.gp_address2 AS gp_address2_76,
  u0_.gp_town AS gp_town_77,
  u0_.gp_county AS gp_county_78,
  u0_.gp_post_code AS gp_post_code_79,
  u0_.gp_country AS gp_country_80,
  u0_.ref AS ref_81,
  u0_.chronoscan_code AS chronoscan_code_82,
  u0_.ethnicity AS ethnicity_83,
  u0_.height AS height_84,
  u0_.weight AS weight_85,
  u0_.passport AS passport_86,
  u0_.reference_number AS reference_number_87,
  u0_.photo_consent AS photo_consent_88,
  u0_.all_marketing AS all_marketing_89,
  u0_.in_clinic_marketing AS in_clinic_marketing_90,
  u0_.in_consultation AS in_consultation_91,
  u0_.interested_in AS interested_in_92,
  u0_.consultation_type AS consultation_type_93,
  u0_.google_click_id AS google_click_id_94,
  u0_.campaign_name AS campaign_name_95,
  u0_.campaign_source AS campaign_source_96,
  u0_.campaign_medium AS campaign_medium_97,
  u0_.campaign_term AS campaign_term_98,
  u0_.campaign_content AS campaign_content_99,
  u0_.marketing_source AS marketing_source_100,
  u0_.author AS author_101,
  u0_.address1 AS address1_102,
  u0_.address2 AS address2_103,
  u0_.town AS town_104,
  u0_.state AS state_105,
  u0_.country AS country_106,
  u0_.postcode AS postcode_107,
  u0_.qualification AS qualification_108,
  u0_.summary AS summary_109,
  u0_.deleted AS deleted_110,
  u0_.calendar_color AS calendar_color_111,
  u0_.calendar_order_number AS calendar_order_number_112,
  u0_.calendar_id AS calendar_id_113,
  u0_.position AS position_114,
  u0_.online_booking_availability AS online_booking_availability_115,
  u0_.title AS title_116,
  u0_.email_verify AS email_verify_117,
  u0_.hash_user_short_url AS hash_user_short_url_118,
  u0_.licence_number AS licence_number_119,
  u0_.stripe_customer_id AS stripe_customer_id_120,
  u0_.is_online AS is_online_121,
  u0_.last_call_time AS last_call_time_122,
  u0_.hide_report_menus AS hide_report_menus_123,
  u0_.type AS type_124,
  u0_.media_id AS media_id_125,
  u0_.device_id AS device_id_126,
  u0_.created_by_id AS created_by_id_127,
  u0_.organisation_id AS organisation_id_128,
  u0_.current_clinic_id AS current_clinic_id_129,
  u0_.parent_id AS parent_id_130,
  u0_.active_photo_id AS active_photo_id_131,
  u0_.bar_code_image_id AS bar_code_image_id_132,
  u0_.clinic_id AS clinic_id_133,
  u0_.prospect_id AS prospect_id_134,
  u0_.clinic_id AS clinic_id_135,
  u0_.i_calendar_id AS i_calendar_id_136
FROM
  user u0_
WHERE
  (u0_.username = ?)
  AND u0_.type IN (
    'admin', 'admin_support', 'super_clinic_admin',
    'patient', 'clinic_user'
  )
LIMIT
  1

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.full_name AS full_name_5, u0_.password AS password_6, u0_.booking_btn_name AS booking_btn_name_7, u0_.booking_btn_clr AS booking_btn_clr_8, u0_.booking_btn_bg_clr AS booking_btn_bg_clr_9, u0_.inner_color AS inner_color_10, u0_.outer_color AS outer_color_11, u0_.background_img AS background_img_12, u0_.profile_img AS profile_img_13, u0_.role AS role_14, u0_.enabled AS enabled_15, u0_.locked AS locked_16, u0_.visible AS visible_17, u0_.is_disengaged AS is_disengaged_18, u0_.otp AS otp_19, u0_.otp_sent_at AS otp_sent_at_20, u0_.last_otp_verified AS last_otp_verified_21, u0_.imap_setting AS imap_setting_22, u0_.country_code AS country_code_23, u0_.phone AS phone_24, u0_.practitioner_commission AS practitioner_commission_25, u0_.coordinator_commission AS coordinator_commission_26, u0_.course_commission AS course_commission_27, u0_.membership_commission AS membership_commission_28, u0_.product_commission AS product_commission_29, u0_.token AS token_30, u0_.access_all_calendars AS access_all_calendars_31, u0_.current_auth_token AS current_auth_token_32, u0_.last_auth_time AS last_auth_time_33, u0_.hash AS hash_34, u0_.fcm_token AS fcm_token_35, u0_.hx_change_token AS hx_change_token_36, u0_.login_from AS login_from_37, u0_.ever_login_in_v3 AS ever_login_in_v3_38, u0_.permissions AS permissions_39, u0_.clinic_id AS clinic_id_40, u0_.fp_promoter_id AS fp_promoter_id_41, u0_.referral_link AS referral_link_42, u0_.fp_tracking_id AS fp_tracking_id_43, u0_.receive_special_offer_email AS receive_special_offer_email_44, u0_.receive_special_offer_sms AS receive_special_offer_sms_45, u0_.deleted_at AS deleted_at_46, u0_.created_at AS created_at_47, u0_.updated_at AS updated_at_48, u0_.stripe_customer_id AS stripe_customer_id_49, u0_.stripe_customer_id AS stripe_customer_id_50, u0_.status AS status_51, u0_.birthday AS birthday_52, u0_.country_code_alt AS country_code_alt_53, u0_.secondary_phone AS secondary_phone_54, u0_.next_kin AS next_kin_55, u0_.next_kin_phone AS next_kin_phone_56, u0_.description AS description_57, u0_.glogau_scale AS glogau_scale_58, u0_.fitzpatrick_scale AS fitzpatrick_scale_59, u0_.gender AS gender_60, u0_.receive_special_offer_push AS receive_special_offer_push_61, u0_.receive_reminder_email AS receive_reminder_email_62, u0_.receive_reminder_sms AS receive_reminder_sms_63, u0_.receive_reminder_push AS receive_reminder_push_64, u0_.parent_user_id AS parent_user_id_65, u0_.account_type AS account_type_66, u0_.terms_accepted AS terms_accepted_67, u0_.terms_accepted_patient_mode AS terms_accepted_patient_mode_68, u0_.referral AS referral_69, u0_.export_in_progress AS export_in_progress_70, u0_.occupation AS occupation_71, u0_.number_nhs AS number_nhs_72, u0_.gp_name AS gp_name_73, u0_.contact_gp AS contact_gp_74, u0_.gp_address1 AS gp_address1_75, u0_.gp_address2 AS gp_address2_76, u0_.gp_town AS gp_town_77, u0_.gp_county AS gp_county_78, u0_.gp_post_code AS gp_post_code_79, u0_.gp_country AS gp_country_80, u0_.ref AS ref_81, u0_.chronoscan_code AS chronoscan_code_82, u0_.ethnicity AS ethnicity_83, u0_.height AS height_84, u0_.weight AS weight_85, u0_.passport AS passport_86, u0_.reference_number AS reference_number_87, u0_.photo_consent AS photo_consent_88, u0_.all_marketing AS all_marketing_89, u0_.in_clinic_marketing AS in_clinic_marketing_90, u0_.in_consultation AS in_consultation_91, u0_.interested_in AS interested_in_92, u0_.consultation_type AS consultation_type_93, u0_.google_click_id AS google_click_id_94, u0_.campaign_name AS campaign_name_95, u0_.campaign_source AS campaign_source_96, u0_.campaign_medium AS campaign_medium_97, u0_.campaign_term AS campaign_term_98, u0_.campaign_content AS campaign_content_99, u0_.marketing_source AS marketing_source_100, u0_.author AS author_101, u0_.address1 AS address1_102, u0_.address2 AS address2_103, u0_.town AS town_104, u0_.state AS state_105, u0_.country AS country_106, u0_.postcode AS postcode_107, u0_.qualification AS qualification_108, u0_.summary AS summary_109, u0_.deleted AS deleted_110, u0_.calendar_color AS calendar_color_111, u0_.calendar_order_number AS calendar_order_number_112, u0_.calendar_id AS calendar_id_113, u0_.position AS position_114, u0_.online_booking_availability AS online_booking_availability_115, u0_.title AS title_116, u0_.email_verify AS email_verify_117, u0_.hash_user_short_url AS hash_user_short_url_118, u0_.licence_number AS licence_number_119, u0_.stripe_customer_id AS stripe_customer_id_120, u0_.is_online AS is_online_121, u0_.last_call_time AS last_call_time_122, u0_.hide_report_menus AS hide_report_menus_123, u0_.type AS type_124, u0_.media_id AS media_id_125, u0_.device_id AS device_id_126, u0_.created_by_id AS created_by_id_127, u0_.organisation_id AS organisation_id_128, u0_.current_clinic_id AS current_clinic_id_129, u0_.parent_id AS parent_id_130, u0_.active_photo_id AS active_photo_id_131, u0_.bar_code_image_id AS bar_code_image_id_132, u0_.clinic_id AS clinic_id_133, u0_.prospect_id AS prospect_id_134, u0_.clinic_id AS clinic_id_135, u0_.i_calendar_id AS i_calendar_id_136 FROM user u0_ WHERE (u0_.username = 'demo') AND u0_.type IN ('admin', 'admin_support', 'super_clinic_admin', 'patient', 'clinic_user') LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\Person\UserRepository->loadUserByUsername (line 75)
7	App\Repository\Person\UserRepository->loadUserByIdentifier (line 99)
8	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 64)
9	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
10	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
11	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
19	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
20	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
21	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
22	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
23	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
24	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	require_once (line 4)

0.87 ms
(2.26%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_domain AS sub_domain_3, t0.organisation_id AS organisation_id_4, t0.smscredit AS smscredit_5, t0.ai_token_credit AS ai_token_credit_6, t0.last_daily_token_date AS last_daily_token_date_7, t0.ai_seconds_credit AS ai_seconds_credit_8, t0.daily_ai_token_credit AS daily_ai_token_credit_9, t0.booking_btn_name AS booking_btn_name_10, t0.booking_btn_clr AS booking_btn_clr_11, t0.booking_btn_bg_clr AS booking_btn_bg_clr_12, t0.inner_color AS inner_color_13, t0.outer_color AS outer_color_14, t0.background_img AS background_img_15, t0.profile_img AS profile_img_16, t0.meeting_price AS meeting_price_17, t0.meeting_price_type AS meeting_price_type_18, t0.show_in_public_profile AS show_in_public_profile_19, t0.patient_ref_prefix AS patient_ref_prefix_20, t0.email AS email_21, t0.verified_email AS verified_email_22, t0.web_site AS web_site_23, t0.phone AS phone_24, t0.contact_name AS contact_name_25, t0.description AS description_26, t0.widget_settings AS widget_settings_27, t0.sms_number AS sms_number_28, t0.sms_status AS sms_status_29, t0.timezone AS timezone_30, t0.reminder_header AS reminder_header_31, t0.reminder_footer AS reminder_footer_32, t0.reminder_recall_text AS reminder_recall_text_33, t0.google_token AS google_token_34, t0.google_id AS google_id_35, t0.topic_arn AS topic_arn_36, t0.pm_pin AS pm_pin_37, t0.auto_email_reply_address AS auto_email_reply_address_38, t0.pm_patient_message AS pm_patient_message_39, t0.pm_clinic_intro AS pm_clinic_intro_40, t0.auto_renew_subscription AS auto_renew_subscription_41, t0.subscription_expiry AS subscription_expiry_42, t0.email_reminder AS email_reminder_43, t0.email_new AS email_new_44, t0.sms_new AS sms_new_45, t0.sms_reminder AS sms_reminder_46, t0.when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_47, t0.calendar_start_day AS calendar_start_day_48, t0.calendar_end_day AS calendar_end_day_49, t0.appointment_default_time AS appointment_default_time_50, t0.appointment_slot_duration AS appointment_slot_duration_51, t0.appointment_default_view AS appointment_default_view_52, t0.private_mode_calendar AS private_mode_calendar_53, t0.clinic_representative AS clinic_representative_54, t0.data_protection_officer AS data_protection_officer_55, t0.company_registration_number AS company_registration_number_56, t0.email_to_withdraw AS email_to_withdraw_57, t0.period_stored_data AS period_stored_data_58, t0.survey_email_text AS survey_email_text_59, t0.post_apt_form_email_text AS post_apt_form_email_text_60, t0.export_in_progress AS export_in_progress_61, t0.vat_number AS vat_number_62, t0.enabled_vat AS enabled_vat_63, t0.patient_list_display_pair AS patient_list_display_pair_64, t0.stripe_refresh_token AS stripe_refresh_token_65, t0.stripe_publishable_key AS stripe_publishable_key_66, t0.stripe_account_id AS stripe_account_id_67, t0.shared_all_patients AS shared_all_patients_68, t0.currency AS currency_69, t0.patient_info_to_document_header AS patient_info_to_document_header_70, t0.t_and_c AS t_and_c_71, t0.declaration AS declaration_72, t0.treatment_plan_tand_c AS treatment_plan_tand_c_73, t0.traffic_light AS traffic_light_74, t0.booking_required_fields AS booking_required_fields_75, t0.double_booking AS double_booking_76, t0.required_confirmation AS required_confirmation_77, t0.fixed_discount_amount AS fixed_discount_amount_78, t0.required_questionnaires AS required_questionnaires_79, t0.patient_required_fields AS patient_required_fields_80, t0.prospect_required_fields AS prospect_required_fields_81, t0.enabled_postcode AS enabled_postcode_82, t0.enabled_chronoscan AS enabled_chronoscan_83, t0.postcode_api_key AS postcode_api_key_84, t0.enabled_prospect_web_form AS enabled_prospect_web_form_85, t0.payment_sense AS payment_sense_86, t0.xero_tenant_id AS xero_tenant_id_87, t0.reduce_stock AS reduce_stock_88, t0.patient_questionnaire AS patient_questionnaire_89, t0.xero_bank_account AS xero_bank_account_90, t0.is_new_clinic AS is_new_clinic_91, t0.marketing_expert AS marketing_expert_92, t0.clinic_survey_email_text AS clinic_survey_email_text_93, t0.trial_end_date AS trial_end_date_94, t0.shared_patient_date AS shared_patient_date_95, t0.feature_custom_website_amount AS feature_custom_website_amount_96, t0.feature_ad_amount AS feature_ad_amount_97, t0.feature_message_amount AS feature_message_amount_98, t0.feature_template_amount AS feature_template_amount_99, t0.is_template_user_only AS is_template_user_only_100, t0.new_user AS new_user_101, t0.template_subscription_end_date AS template_subscription_end_date_102, t0.onboarding_status AS onboarding_status_103, t0.address1 AS address1_104, t0.address2 AS address2_105, t0.town AS town_106, t0.state AS state_107, t0.country AS country_108, t0.postcode AS postcode_109, t0.created_at AS created_at_110, t0.updated_at AS updated_at_111, t0.logo_id AS logo_id_112, t113.id AS id_114, t113.s3key AS s3key_115, t113.name_file AS name_file_116, t113.url AS url_117, t113.type AS type_118, t113.created_at AS created_at_119, t113.updated_at AS updated_at_120, t0.background_id AS background_id_121, t122.id AS id_123, t122.s3key AS s3key_124, t122.name_file AS name_file_125, t122.url AS url_126, t122.type AS type_127, t122.created_at AS created_at_128, t122.updated_at AS updated_at_129, t130.id AS id_131, t130.creditor AS creditor_132, t130.mandate AS mandate_133, t130.customer AS customer_134, t130.customer_bank_account AS customer_bank_account_135, t130.created_at AS created_at_136, t130.updated_at AS updated_at_137, t130.clinic_id AS clinic_id_138, t139.id AS id_140, t139.sid AS sid_141, t139.token AS token_142, t139.number_from AS number_from_143, t139.clinic_id AS clinic_id_144, t0.organisation_id AS organisation_id_145, t146.id AS id_147, t146.enabled AS enabled_148, t146.time_required_for_booking AS time_required_for_booking_149, t146.time_required_for_cancellation AS time_required_for_cancellation_150, t146.take_payment_for_new_patients AS take_payment_for_new_patients_151, t146.take_payment_for_existing_patients AS take_payment_for_existing_patients_152, t146.type AS type_153, t146.hide_full_price AS hide_full_price_154, t146.terms AS terms_155, t146.clinic_id AS clinic_id_156, t157.id AS id_158, t157.server AS server_159, t157.file_location AS file_location_160, t157.username AS username_161, t157.password AS password_162, t157.email AS email_163, t157.clinic_id AS clinic_id_164, t165.id AS id_166, t165.theme AS theme_167, t165.max_embed_width AS max_embed_width_168, t165.primary_interface_colour AS primary_interface_colour_169, t165.secondary_interface_colour AS secondary_interface_colour_170, t165.primary_font_colour AS primary_font_colour_171, t165.secondary_font_colour AS secondary_font_colour_172, t165.background_colour AS background_colour_173, t165.widget_hash AS widget_hash_174, t165.created_at AS created_at_175, t165.updated_at AS updated_at_176, t165.clinic_id AS clinic_id_177, t165.custom_css_id AS custom_css_id_178, t179.id AS id_180, t179.confirmation_text AS confirmation_text_181, t179.treatment_info AS treatment_info_182, t179.clinic_id AS clinic_id_183, t184.id AS id_185, t184.api_key AS api_key_186, t184.list_id AS list_id_187, t184.sync AS sync_188, t184.sync_date AS sync_date_189, t184.pro AS pro_190, t184.created_at AS created_at_191, t184.updated_at AS updated_at_192, t184.clinic_id AS clinic_id_193, t0.promo_code_id AS promo_code_id_194, t0.price_tier_id AS price_tier_id_195, t0.xero_sync_job_id AS xero_sync_job_id_196 FROM clinics t0 LEFT JOIN media t113 ON t0.logo_id = t113.id LEFT JOIN media t122 ON t0.background_id = t122.id LEFT JOIN gocardless_customer t130 ON t130.clinic_id = t0.id LEFT JOIN twilio t139 ON t139.clinic_id = t0.id LEFT JOIN setting_online_booking t146 ON t146.clinic_id = t0.id LEFT JOIN setting_chronoscan t157 ON t157.clinic_id = t0.id LEFT JOIN widget_online_booking t165 ON t165.clinic_id = t0.id LEFT JOIN email_setting_online_booking t179 ON t179.clinic_id = t0.id LEFT JOIN mail_chimp_config t184 ON t184.clinic_id = t0.id WHERE t0.organisation_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.sub_domain AS sub_domain_3,
  t0.organisation_id AS organisation_id_4,
  t0.smscredit AS smscredit_5,
  t0.ai_token_credit AS ai_token_credit_6,
  t0.last_daily_token_date AS last_daily_token_date_7,
  t0.ai_seconds_credit AS ai_seconds_credit_8,
  t0.daily_ai_token_credit AS daily_ai_token_credit_9,
  t0.booking_btn_name AS booking_btn_name_10,
  t0.booking_btn_clr AS booking_btn_clr_11,
  t0.booking_btn_bg_clr AS booking_btn_bg_clr_12,
  t0.inner_color AS inner_color_13,
  t0.outer_color AS outer_color_14,
  t0.background_img AS background_img_15,
  t0.profile_img AS profile_img_16,
  t0.meeting_price AS meeting_price_17,
  t0.meeting_price_type AS meeting_price_type_18,
  t0.show_in_public_profile AS show_in_public_profile_19,
  t0.patient_ref_prefix AS patient_ref_prefix_20,
  t0.email AS email_21,
  t0.verified_email AS verified_email_22,
  t0.web_site AS web_site_23,
  t0.phone AS phone_24,
  t0.contact_name AS contact_name_25,
  t0.description AS description_26,
  t0.widget_settings AS widget_settings_27,
  t0.sms_number AS sms_number_28,
  t0.sms_status AS sms_status_29,
  t0.timezone AS timezone_30,
  t0.reminder_header AS reminder_header_31,
  t0.reminder_footer AS reminder_footer_32,
  t0.reminder_recall_text AS reminder_recall_text_33,
  t0.google_token AS google_token_34,
  t0.google_id AS google_id_35,
  t0.topic_arn AS topic_arn_36,
  t0.pm_pin AS pm_pin_37,
  t0.auto_email_reply_address AS auto_email_reply_address_38,
  t0.pm_patient_message AS pm_patient_message_39,
  t0.pm_clinic_intro AS pm_clinic_intro_40,
  t0.auto_renew_subscription AS auto_renew_subscription_41,
  t0.subscription_expiry AS subscription_expiry_42,
  t0.email_reminder AS email_reminder_43,
  t0.email_new AS email_new_44,
  t0.sms_new AS sms_new_45,
  t0.sms_reminder AS sms_reminder_46,
  t0.when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_47,
  t0.calendar_start_day AS calendar_start_day_48,
  t0.calendar_end_day AS calendar_end_day_49,
  t0.appointment_default_time AS appointment_default_time_50,
  t0.appointment_slot_duration AS appointment_slot_duration_51,
  t0.appointment_default_view AS appointment_default_view_52,
  t0.private_mode_calendar AS private_mode_calendar_53,
  t0.clinic_representative AS clinic_representative_54,
  t0.data_protection_officer AS data_protection_officer_55,
  t0.company_registration_number AS company_registration_number_56,
  t0.email_to_withdraw AS email_to_withdraw_57,
  t0.period_stored_data AS period_stored_data_58,
  t0.survey_email_text AS survey_email_text_59,
  t0.post_apt_form_email_text AS post_apt_form_email_text_60,
  t0.export_in_progress AS export_in_progress_61,
  t0.vat_number AS vat_number_62,
  t0.enabled_vat AS enabled_vat_63,
  t0.patient_list_display_pair AS patient_list_display_pair_64,
  t0.stripe_refresh_token AS stripe_refresh_token_65,
  t0.stripe_publishable_key AS stripe_publishable_key_66,
  t0.stripe_account_id AS stripe_account_id_67,
  t0.shared_all_patients AS shared_all_patients_68,
  t0.currency AS currency_69,
  t0.patient_info_to_document_header AS patient_info_to_document_header_70,
  t0.t_and_c AS t_and_c_71,
  t0.declaration AS declaration_72,
  t0.treatment_plan_tand_c AS treatment_plan_tand_c_73,
  t0.traffic_light AS traffic_light_74,
  t0.booking_required_fields AS booking_required_fields_75,
  t0.double_booking AS double_booking_76,
  t0.required_confirmation AS required_confirmation_77,
  t0.fixed_discount_amount AS fixed_discount_amount_78,
  t0.required_questionnaires AS required_questionnaires_79,
  t0.patient_required_fields AS patient_required_fields_80,
  t0.prospect_required_fields AS prospect_required_fields_81,
  t0.enabled_postcode AS enabled_postcode_82,
  t0.enabled_chronoscan AS enabled_chronoscan_83,
  t0.postcode_api_key AS postcode_api_key_84,
  t0.enabled_prospect_web_form AS enabled_prospect_web_form_85,
  t0.payment_sense AS payment_sense_86,
  t0.xero_tenant_id AS xero_tenant_id_87,
  t0.reduce_stock AS reduce_stock_88,
  t0.patient_questionnaire AS patient_questionnaire_89,
  t0.xero_bank_account AS xero_bank_account_90,
  t0.is_new_clinic AS is_new_clinic_91,
  t0.marketing_expert AS marketing_expert_92,
  t0.clinic_survey_email_text AS clinic_survey_email_text_93,
  t0.trial_end_date AS trial_end_date_94,
  t0.shared_patient_date AS shared_patient_date_95,
  t0.feature_custom_website_amount AS feature_custom_website_amount_96,
  t0.feature_ad_amount AS feature_ad_amount_97,
  t0.feature_message_amount AS feature_message_amount_98,
  t0.feature_template_amount AS feature_template_amount_99,
  t0.is_template_user_only AS is_template_user_only_100,
  t0.new_user AS new_user_101,
  t0.template_subscription_end_date AS template_subscription_end_date_102,
  t0.onboarding_status AS onboarding_status_103,
  t0.address1 AS address1_104,
  t0.address2 AS address2_105,
  t0.town AS town_106,
  t0.state AS state_107,
  t0.country AS country_108,
  t0.postcode AS postcode_109,
  t0.created_at AS created_at_110,
  t0.updated_at AS updated_at_111,
  t0.logo_id AS logo_id_112,
  t113.id AS id_114,
  t113.s3key AS s3key_115,
  t113.name_file AS name_file_116,
  t113.url AS url_117,
  t113.type AS type_118,
  t113.created_at AS created_at_119,
  t113.updated_at AS updated_at_120,
  t0.background_id AS background_id_121,
  t122.id AS id_123,
  t122.s3key AS s3key_124,
  t122.name_file AS name_file_125,
  t122.url AS url_126,
  t122.type AS type_127,
  t122.created_at AS created_at_128,
  t122.updated_at AS updated_at_129,
  t130.id AS id_131,
  t130.creditor AS creditor_132,
  t130.mandate AS mandate_133,
  t130.customer AS customer_134,
  t130.customer_bank_account AS customer_bank_account_135,
  t130.created_at AS created_at_136,
  t130.updated_at AS updated_at_137,
  t130.clinic_id AS clinic_id_138,
  t139.id AS id_140,
  t139.sid AS sid_141,
  t139.token AS token_142,
  t139.number_from AS number_from_143,
  t139.clinic_id AS clinic_id_144,
  t0.organisation_id AS organisation_id_145,
  t146.id AS id_147,
  t146.enabled AS enabled_148,
  t146.time_required_for_booking AS time_required_for_booking_149,
  t146.time_required_for_cancellation AS time_required_for_cancellation_150,
  t146.take_payment_for_new_patients AS take_payment_for_new_patients_151,
  t146.take_payment_for_existing_patients AS take_payment_for_existing_patients_152,
  t146.type AS type_153,
  t146.hide_full_price AS hide_full_price_154,
  t146.terms AS terms_155,
  t146.clinic_id AS clinic_id_156,
  t157.id AS id_158,
  t157.server AS server_159,
  t157.file_location AS file_location_160,
  t157.username AS username_161,
  t157.password AS password_162,
  t157.email AS email_163,
  t157.clinic_id AS clinic_id_164,
  t165.id AS id_166,
  t165.theme AS theme_167,
  t165.max_embed_width AS max_embed_width_168,
  t165.primary_interface_colour AS primary_interface_colour_169,
  t165.secondary_interface_colour AS secondary_interface_colour_170,
  t165.primary_font_colour AS primary_font_colour_171,
  t165.secondary_font_colour AS secondary_font_colour_172,
  t165.background_colour AS background_colour_173,
  t165.widget_hash AS widget_hash_174,
  t165.created_at AS created_at_175,
  t165.updated_at AS updated_at_176,
  t165.clinic_id AS clinic_id_177,
  t165.custom_css_id AS custom_css_id_178,
  t179.id AS id_180,
  t179.confirmation_text AS confirmation_text_181,
  t179.treatment_info AS treatment_info_182,
  t179.clinic_id AS clinic_id_183,
  t184.id AS id_185,
  t184.api_key AS api_key_186,
  t184.list_id AS list_id_187,
  t184.sync AS sync_188,
  t184.sync_date AS sync_date_189,
  t184.pro AS pro_190,
  t184.created_at AS created_at_191,
  t184.updated_at AS updated_at_192,
  t184.clinic_id AS clinic_id_193,
  t0.promo_code_id AS promo_code_id_194,
  t0.price_tier_id AS price_tier_id_195,
  t0.xero_sync_job_id AS xero_sync_job_id_196
FROM
  clinics t0
  LEFT JOIN media t113 ON t0.logo_id = t113.id
  LEFT JOIN media t122 ON t0.background_id = t122.id
  LEFT JOIN gocardless_customer t130 ON t130.clinic_id = t0.id
  LEFT JOIN twilio t139 ON t139.clinic_id = t0.id
  LEFT JOIN setting_online_booking t146 ON t146.clinic_id = t0.id
  LEFT JOIN setting_chronoscan t157 ON t157.clinic_id = t0.id
  LEFT JOIN widget_online_booking t165 ON t165.clinic_id = t0.id
  LEFT JOIN email_setting_online_booking t179 ON t179.clinic_id = t0.id
  LEFT JOIN mail_chimp_config t184 ON t184.clinic_id = t0.id
WHERE
  t0.organisation_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_domain AS sub_domain_3, t0.organisation_id AS organisation_id_4, t0.smscredit AS smscredit_5, t0.ai_token_credit AS ai_token_credit_6, t0.last_daily_token_date AS last_daily_token_date_7, t0.ai_seconds_credit AS ai_seconds_credit_8, t0.daily_ai_token_credit AS daily_ai_token_credit_9, t0.booking_btn_name AS booking_btn_name_10, t0.booking_btn_clr AS booking_btn_clr_11, t0.booking_btn_bg_clr AS booking_btn_bg_clr_12, t0.inner_color AS inner_color_13, t0.outer_color AS outer_color_14, t0.background_img AS background_img_15, t0.profile_img AS profile_img_16, t0.meeting_price AS meeting_price_17, t0.meeting_price_type AS meeting_price_type_18, t0.show_in_public_profile AS show_in_public_profile_19, t0.patient_ref_prefix AS patient_ref_prefix_20, t0.email AS email_21, t0.verified_email AS verified_email_22, t0.web_site AS web_site_23, t0.phone AS phone_24, t0.contact_name AS contact_name_25, t0.description AS description_26, t0.widget_settings AS widget_settings_27, t0.sms_number AS sms_number_28, t0.sms_status AS sms_status_29, t0.timezone AS timezone_30, t0.reminder_header AS reminder_header_31, t0.reminder_footer AS reminder_footer_32, t0.reminder_recall_text AS reminder_recall_text_33, t0.google_token AS google_token_34, t0.google_id AS google_id_35, t0.topic_arn AS topic_arn_36, t0.pm_pin AS pm_pin_37, t0.auto_email_reply_address AS auto_email_reply_address_38, t0.pm_patient_message AS pm_patient_message_39, t0.pm_clinic_intro AS pm_clinic_intro_40, t0.auto_renew_subscription AS auto_renew_subscription_41, t0.subscription_expiry AS subscription_expiry_42, t0.email_reminder AS email_reminder_43, t0.email_new AS email_new_44, t0.sms_new AS sms_new_45, t0.sms_reminder AS sms_reminder_46, t0.when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_47, t0.calendar_start_day AS calendar_start_day_48, t0.calendar_end_day AS calendar_end_day_49, t0.appointment_default_time AS appointment_default_time_50, t0.appointment_slot_duration AS appointment_slot_duration_51, t0.appointment_default_view AS appointment_default_view_52, t0.private_mode_calendar AS private_mode_calendar_53, t0.clinic_representative AS clinic_representative_54, t0.data_protection_officer AS data_protection_officer_55, t0.company_registration_number AS company_registration_number_56, t0.email_to_withdraw AS email_to_withdraw_57, t0.period_stored_data AS period_stored_data_58, t0.survey_email_text AS survey_email_text_59, t0.post_apt_form_email_text AS post_apt_form_email_text_60, t0.export_in_progress AS export_in_progress_61, t0.vat_number AS vat_number_62, t0.enabled_vat AS enabled_vat_63, t0.patient_list_display_pair AS patient_list_display_pair_64, t0.stripe_refresh_token AS stripe_refresh_token_65, t0.stripe_publishable_key AS stripe_publishable_key_66, t0.stripe_account_id AS stripe_account_id_67, t0.shared_all_patients AS shared_all_patients_68, t0.currency AS currency_69, t0.patient_info_to_document_header AS patient_info_to_document_header_70, t0.t_and_c AS t_and_c_71, t0.declaration AS declaration_72, t0.treatment_plan_tand_c AS treatment_plan_tand_c_73, t0.traffic_light AS traffic_light_74, t0.booking_required_fields AS booking_required_fields_75, t0.double_booking AS double_booking_76, t0.required_confirmation AS required_confirmation_77, t0.fixed_discount_amount AS fixed_discount_amount_78, t0.required_questionnaires AS required_questionnaires_79, t0.patient_required_fields AS patient_required_fields_80, t0.prospect_required_fields AS prospect_required_fields_81, t0.enabled_postcode AS enabled_postcode_82, t0.enabled_chronoscan AS enabled_chronoscan_83, t0.postcode_api_key AS postcode_api_key_84, t0.enabled_prospect_web_form AS enabled_prospect_web_form_85, t0.payment_sense AS payment_sense_86, t0.xero_tenant_id AS xero_tenant_id_87, t0.reduce_stock AS reduce_stock_88, t0.patient_questionnaire AS patient_questionnaire_89, t0.xero_bank_account AS xero_bank_account_90, t0.is_new_clinic AS is_new_clinic_91, t0.marketing_expert AS marketing_expert_92, t0.clinic_survey_email_text AS clinic_survey_email_text_93, t0.trial_end_date AS trial_end_date_94, t0.shared_patient_date AS shared_patient_date_95, t0.feature_custom_website_amount AS feature_custom_website_amount_96, t0.feature_ad_amount AS feature_ad_amount_97, t0.feature_message_amount AS feature_message_amount_98, t0.feature_template_amount AS feature_template_amount_99, t0.is_template_user_only AS is_template_user_only_100, t0.new_user AS new_user_101, t0.template_subscription_end_date AS template_subscription_end_date_102, t0.onboarding_status AS onboarding_status_103, t0.address1 AS address1_104, t0.address2 AS address2_105, t0.town AS town_106, t0.state AS state_107, t0.country AS country_108, t0.postcode AS postcode_109, t0.created_at AS created_at_110, t0.updated_at AS updated_at_111, t0.logo_id AS logo_id_112, t113.id AS id_114, t113.s3key AS s3key_115, t113.name_file AS name_file_116, t113.url AS url_117, t113.type AS type_118, t113.created_at AS created_at_119, t113.updated_at AS updated_at_120, t0.background_id AS background_id_121, t122.id AS id_123, t122.s3key AS s3key_124, t122.name_file AS name_file_125, t122.url AS url_126, t122.type AS type_127, t122.created_at AS created_at_128, t122.updated_at AS updated_at_129, t130.id AS id_131, t130.creditor AS creditor_132, t130.mandate AS mandate_133, t130.customer AS customer_134, t130.customer_bank_account AS customer_bank_account_135, t130.created_at AS created_at_136, t130.updated_at AS updated_at_137, t130.clinic_id AS clinic_id_138, t139.id AS id_140, t139.sid AS sid_141, t139.token AS token_142, t139.number_from AS number_from_143, t139.clinic_id AS clinic_id_144, t0.organisation_id AS organisation_id_145, t146.id AS id_147, t146.enabled AS enabled_148, t146.time_required_for_booking AS time_required_for_booking_149, t146.time_required_for_cancellation AS time_required_for_cancellation_150, t146.take_payment_for_new_patients AS take_payment_for_new_patients_151, t146.take_payment_for_existing_patients AS take_payment_for_existing_patients_152, t146.type AS type_153, t146.hide_full_price AS hide_full_price_154, t146.terms AS terms_155, t146.clinic_id AS clinic_id_156, t157.id AS id_158, t157.server AS server_159, t157.file_location AS file_location_160, t157.username AS username_161, t157.password AS password_162, t157.email AS email_163, t157.clinic_id AS clinic_id_164, t165.id AS id_166, t165.theme AS theme_167, t165.max_embed_width AS max_embed_width_168, t165.primary_interface_colour AS primary_interface_colour_169, t165.secondary_interface_colour AS secondary_interface_colour_170, t165.primary_font_colour AS primary_font_colour_171, t165.secondary_font_colour AS secondary_font_colour_172, t165.background_colour AS background_colour_173, t165.widget_hash AS widget_hash_174, t165.created_at AS created_at_175, t165.updated_at AS updated_at_176, t165.clinic_id AS clinic_id_177, t165.custom_css_id AS custom_css_id_178, t179.id AS id_180, t179.confirmation_text AS confirmation_text_181, t179.treatment_info AS treatment_info_182, t179.clinic_id AS clinic_id_183, t184.id AS id_185, t184.api_key AS api_key_186, t184.list_id AS list_id_187, t184.sync AS sync_188, t184.sync_date AS sync_date_189, t184.pro AS pro_190, t184.created_at AS created_at_191, t184.updated_at AS updated_at_192, t184.clinic_id AS clinic_id_193, t0.promo_code_id AS promo_code_id_194, t0.price_tier_id AS price_tier_id_195, t0.xero_sync_job_id AS xero_sync_job_id_196 FROM clinics t0 LEFT JOIN media t113 ON t0.logo_id = t113.id LEFT JOIN media t122 ON t0.background_id = t122.id LEFT JOIN gocardless_customer t130 ON t130.clinic_id = t0.id LEFT JOIN twilio t139 ON t139.clinic_id = t0.id LEFT JOIN setting_online_booking t146 ON t146.clinic_id = t0.id LEFT JOIN setting_chronoscan t157 ON t157.clinic_id = t0.id LEFT JOIN widget_online_booking t165 ON t165.clinic_id = t0.id LEFT JOIN email_setting_online_booking t179 ON t179.clinic_id = t0.id LEFT JOIN mail_chimp_config t184 ON t184.clinic_id = t0.id WHERE t0.organisation_id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	App\Handler\AuthenticationHandler->onAuthenticationSuccess (line 123)
9	Symfony\Component\Security\Http\Authentication\CustomAuthenticationSuccessHandler->onAuthenticationSuccess (line 42)
10	Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator->onAuthenticationSuccess (line 103)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 91)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 244)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
16	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
17	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
18	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 4)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
pgsql	doctrine.dbal.pgsql_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\Clinic\Clinic	10
App\Entity\Clinic\PriceTier\PriceTier	5
App\Entity\Media\Media	4
App\Entity\Clinic\GocardlessCustomer	2
App\Entity\Clinic\OnlineBooking\Settings	2
App\Entity\Clinic\OnlineBooking\Widget	2
App\Entity\Clinic\OnlineBooking\EmailSettings	2
App\Entity\Person\User	1
App\Entity\Organisation\Organisation	1
App\Entity\Person\LoginLog	1
App\Entity\Clinic\Twilio	1
App\Entity\Clinic\MailChimp\MailChimpConfig	1

Entities Mapping

Class	Mapping errors
App\Entity\Person\User	No errors.
App\Entity\Person\Device	No errors.
App\Entity\Person\Admin	No errors.
App\Entity\Person\AdminSupport	No errors.
App\Entity\Clinic\Person\ClinicUser	No errors.
App\Entity\Person\SuperClinicAdmin	No errors.
App\Entity\Person\Patient	No errors.
App\Entity\Media\Media	No errors.
App\Entity\Organisation\Organisation	No errors.
App\Entity\Clinic\Clinic	The mappings App\Entity\Clinic\Clinic#memberships and App\Entity\Clinic\Membership\Membership#clinic are inconsistent with each other.
App\Entity\Patient\Photo	No errors.
App\Entity\LeadCapture\LeadCapture	No errors.
App\Entity\ProspectsMessage	No errors.
App\Entity\Clinic\Appointment	No errors.
App\Entity\Event	No errors.
App\Entity\Patient\TreatmentPlan	The mappings App\Entity\Patient\TreatmentPlan#superClinicAdmin and App\Entity\Person\SuperClinicAdmin#treatmentPlans are inconsistent with each other.
App\Entity\Patient\BaseInvoice	No errors.
App\Entity\Clinic\Stock\TreatmentClinic	No errors.
App\Entity\Clinic\Person\DailySchedule	No errors.
App\Entity\Person\LoginLog	No errors.
App\Entity\Clinic\GocardlessCustomer	No errors.
App\Entity\Clinic\Twilio	No errors.
App\Entity\Clinic\OnlineBooking\Settings	No errors.
App\Entity\Clinic\Chronoscan\Settings	No errors.
App\Entity\Clinic\OnlineBooking\Widget	No errors.
App\Entity\Clinic\OnlineBooking\EmailSettings	No errors.
App\Entity\Clinic\MailChimp\MailChimpConfig	No errors.
App\Entity\Clinic\PriceTier\PromoCode	No errors.
App\Entity\Clinic\PriceTier\PriceTier	No errors.
Mcfedr\QueueManagerBundle\Entity\DoctrineDelayJob	No errors.
App\Entity\Template	No errors.
App\Entity\AppointmentLead	No errors.
App\Entity\ReminderTask	No errors.
App\Entity\Clinic\Equipment	No errors.
App\Entity\Clinic\Reminder	No errors.
App\Entity\Clinic\ReminderRecall	No errors.
App\Entity\Clinic\License	No errors.
App\Entity\Clinic\WebhookEvent	No errors.
App\Entity\Clinic\Room	No errors.
App\Entity\Clinic\Stock\TreatmentGroup	No errors.
App\Entity\Clinic\Stock\PriceList	No errors.
App\Entity\Clinic\Stock\Product	No errors.
App\Entity\Clinic\Marketing	No errors.
App\Entity\Clinic\FormFile	No errors.
App\Entity\SmsSetting	No errors.
App\Entity\Clinic\DocumentCategory	No errors.
App\Entity\Clinic\BlockerReason	No errors.
App\Entity\Clinic\DiscountReason	No errors.
App\Entity\Waiting\Item	No errors.
App\Entity\Clinic\Questionaire\Questionaire	No errors.
App\Entity\Clinic\Stock\GoodsReceived	No errors.
App\Entity\Clinic\Export\ExportData	No errors.
App\Entity\Clinic\ClinicVatRegistration	No errors.
App\Entity\Clinic\Outcome	No errors.
App\Entity\Clinic\PatientStatus\PatientStatus	No errors.
App\Entity\Clinic\LearnAboutSource	No errors.
App\Entity\Clinic\PriceTier\Addon	No errors.
App\Entity\Clinic\Location	No errors.
App\Entity\Clinic\Appointment\AppointmentCode	No errors.
App\Entity\LeadCapture\LeadCaptureStage	The association App\Entity\LeadCapture\LeadCaptureStage#leadCapture refers to the owning side field App\Entity\LeadCapture\LeadCaptureStage#stage which does not exist.
App\Entity\Clinic\Membership\Membership	No errors.
App\Entity\Clinic\Filter	No errors.

Symfony Profiler

POST https://consentz.tribital.com/admin/login_check

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping