Query Metrics

8 Database Queries
8 Different statements
5.79 ms Query time
0 Invalid entities
12 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.02 ms
(17.60%)
1
SELECT t0.deleted_at AS deleted_at_1, t0.id AS id_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.email AS email_5, t0.gender AS gender_6, t0.birthdate AS birthdate_7, t0.enabled AS enabled_8, t0.username AS username_9, t0.password AS password_10, t0.picture AS picture_11, t0.role AS role_12, t0.additional_roles AS additional_roles_13, t0.address AS address_14, t0.code_postal AS code_postal_15, t0.city AS city_16, t0.phone AS phone_17, t0.stripe_customer AS stripe_customer_18, t0.is_department_group_admin AS is_department_group_admin_19, t0.oauth_provider AS oauth_provider_20, t0.oauth_provider_id AS oauth_provider_id_21, t0.rib AS rib_22, t0.balance AS balance_23, t0.is_partner AS is_partner_24, t0.uuid AS uuid_25, t0.updated_at AS updated_at_26, t0.created_at AS created_at_27, t0.fonction_id AS fonction_id_28, t0.entite_id AS entite_id_29, t30.id AS id_31, t30.name AS name_32, t30.solde AS solde_33, t30.number AS number_34, t30.number_fix AS number_fix_35, t30.facebook AS facebook_36, t30.instagram AS instagram_37, t30.linkedin AS linkedin_38, t30.tiktok AS tiktok_39, t30.youtube AS youtube_40, t30.twitter AS twitter_41, t30.description AS description_42, t30.entite_logo AS entite_logo_43, t30.newcomer_open_to_all AS newcomer_open_to_all_44, t30.newcomer_token AS newcomer_token_45, t30.updated_at AS updated_at_46, t30.created_at AS created_at_47, t30.organization_id AS organization_id_48, t30.address_id AS address_id_49, t0.organization_id AS organization_id_50 FROM `user` t0 LEFT JOIN entite t30 ON t0.entite_id = t30.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  22
]
0.95 ms
(16.41%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.subtitle AS subtitle_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.description AS description_6, t0.theme AS theme_7, t0.subtheme AS subtheme_8, t0.speaker AS speaker_9, t0.leader AS leader_10, t0.estimated_members AS estimated_members_11, t0.speaker_photo AS speaker_photo_12, t0.leader_photo AS leader_photo_13, t0.poster AS poster_14, t0.uuid AS uuid_15, t0.updated_at AS updated_at_16, t0.created_at AS created_at_17, t0.created_by_id AS created_by_id_18, t0.entity_id AS entity_id_19 FROM worship t0 WHERE t0.uuid = ? AND ((t0.entity_id = '4')) LIMIT 1
Parameters:
[
  b"\x01 \x1AMÊ xƤV\x1CÝM®$B"
]
0.89 ms
(15.33%)
1
SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.target_url AS target_url_2, s0_.label AS label_3, s0_.clicks AS clicks_4, s0_.expires_at AS expires_at_5, s0_.uuid AS uuid_6, s0_.updated_at AS updated_at_7, s0_.created_at AS created_at_8 FROM short_link s0_ WHERE s0_.target_url = ? AND (s0_.expires_at IS NULL OR s0_.expires_at > ?) ORDER BY s0_.id DESC LIMIT 1
Parameters:
[
  "https://demo.churchmanager.fr/inscription/SQOZ_myDUQrrd7e1yji79m84VyiYKqaj"
  "2026-08-19 15:55:10"
]
0.86 ms
(14.91%)
1
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.auto_confirm AS auto_confirm_3, t0.token AS token_4, t0.capacity_limited AS capacity_limited_5, t0.capacity AS capacity_6, t0.attendance_mode AS attendance_mode_7, t0.online_link AS online_link_8, t0.event_address AS event_address_9, t0.paid AS paid_10, t0.pricing_mode AS pricing_mode_11, t0.price_single AS price_single_12, t0.price_standard AS price_standard_13, t0.price_premium AS price_premium_14, t0.public_note AS public_note_15, t0.poster AS poster_16, t0.closes_at AS closes_at_17, t0.contact_name AS contact_name_18, t0.contact_email AS contact_email_19, t0.contact_phone AS contact_phone_20, t0.uuid AS uuid_21, t0.updated_at AS updated_at_22, t0.created_at AS created_at_23, t0.worship_id AS worship_id_24 FROM inscription_config t0 WHERE t0.worship_id = ? LIMIT 1
Parameters:
[
  106
]
0.65 ms
(11.27%)
1
SELECT t0.id AS id_1, t0.started_at AS started_at_2, t0.ended_at AS ended_at_3, t0.status AS status_4, t0.stripe_subscription AS stripe_subscription_5, t0.price_currency AS price_currency_6, t0.invoice_url AS invoice_url_7, t0.uuid AS uuid_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.organization_id AS organization_id_11, t0.packaging_id AS packaging_id_12, t0.user_id AS user_id_13 FROM subscription t0 WHERE t0.status = ? AND t0.organization_id = ? ORDER BY t0.ended_at DESC LIMIT 1
Parameters:
[
  "ACTIVE"
  4
]
0.54 ms
(9.28%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.uuid AS uuid_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5 FROM category_fonction t0 INNER JOIN user_admin_department ON t0.id = user_admin_department.category_fonction_id WHERE user_admin_department.user_id = ?
Parameters:
[
  22
]
0.48 ms
(8.30%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.postal_code AS postal_code_9, s0_.region AS region_10, s0_.country AS country_11, s0_.city_image AS city_image_12, s0_.created_at AS created_at_13, s0_.updated_at AS updated_at_14 FROM seo_city s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC
Parameters:
[
  1
]
0.40 ms
(6.88%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.meta_title AS meta_title_3, s0_.meta_description AS meta_description_4, s0_.h1 AS h1_5, s0_.content AS content_6, s0_.keywords AS keywords_7, s0_.is_active AS is_active_8, s0_.country_code AS country_code_9, s0_.continent AS continent_10, s0_.language AS language_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13 FROM seo_country s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 2
App\Entity\Fonction 1
App\Entity\Organization 1
App\Entity\Entite 1
App\Entity\Address 1
App\Entity\Worship 1
App\Entity\InscriptionConfig 1
App\Entity\ShortLink 1
App\Entity\Subscription 1
App\Entity\Packaging 1
App\Entity\CategoryFonction 1