Query Metrics
12
Database Queries
7
Different statements
47.44 ms
Query time
1
Invalid entities
5
Managed entities
Grouped Statements
central connection
| Time▼ | Count | Info |
|---|---|---|
|
11.32 ms (23.87%) |
3 |
"COMMIT"
Parameters:
[] |
|
11.12 ms (23.43%) |
1 |
UPDATE users SET last_login_at = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-09-28 08:38:58" "2026-09-28 08:38:58" 11 ] |
|
8.53 ms (17.98%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.level AS level_4, t0.db_name AS db_name_5, t0.vault_key_id AS vault_key_id_6, t0.default_locale AS default_locale_7, t0.available_locales AS available_locales_8, t0.plan AS plan_9, t0.max_families AS max_families_10, t0.monthly_sms_budget AS monthly_sms_budget_11, t0.payment_gateway AS payment_gateway_12, t0.logo_path AS logo_path_13, t0.community_photo_path AS community_photo_path_14, t0.slug AS slug_15, t0.primary_color AS primary_color_16, t0.president_name AS president_name_17, t0.subdomain_enabled AS subdomain_enabled_18, t0.custom_domain AS custom_domain_19, t0.street_number AS street_number_20, t0.address AS address_21, t0.city AS city_22, t0.zip AS zip_23, t0.country AS country_24, t0.timezone AS timezone_25, t0.latitude AS latitude_26, t0.longitude AS longitude_27, t0.reference_city AS reference_city_28, t0.phone AS phone_29, t0.email AS email_30, t0.website AS website_31, t0.siret AS siret_32, t0.stripe_customer_id AS stripe_customer_id_33, t0.stripe_subscription_id AS stripe_subscription_id_34, t0.is_active AS is_active_35, t0.has_cemetery_module AS has_cemetery_module_36, t0.has_wordpress_hosting AS has_wordpress_hosting_37, t0.consistoire_reverse_percent AS consistoire_reverse_percent_38, t0.consistoire_sharing_level AS consistoire_sharing_level_39, t0.fundraising_settings AS fundraising_settings_40, t0.pastoral_age_threshold AS pastoral_age_threshold_41, t0.created_at AS created_at_42, t0.trial_ends_at AS trial_ends_at_43, t0.parent_id AS parent_id_44 FROM organizations t0 WHERE t0.custom_domain = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "managmulhouse.avinconcept.fr" 1 ] |
|
6.94 ms (14.62%) |
2 |
INSERT INTO audit_logs (id, action, entity_type, entity_id, old_values, new_values, ip_address, user_agent, context, level, created_at, organization_id, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "01a0e6bc-f6f3-7505-a572-dcd7e5153fc5" "update" "User" "11" "{"lastLoginAt":"2026-09-23 23:30:13","updatedAt":"2026-09-23 23:30:13"}" "{"lastLoginAt":"2026-09-28 08:38:58","updatedAt":"2026-09-28 08:38:58"}" "154.120.142.38" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36" null "info" "2026-09-28 08:38:58" 7 11 ] |
|
4.95 ms (10.42%) |
1 |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.is_active AS is_active_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.organization_id AS organization_id_6 FROM user_organization_access t0 WHERE t0.user_id = ?
Parameters:
[
11
]
|
|
2.37 ms (4.99%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.preferred_locale AS preferred_locale_7, t0.totp_secret AS totp_secret_8, t0.totp_enabled AS totp_enabled_9, t0.email_auth_code AS email_auth_code_10, t0.last_login_at AS last_login_at_11, t0.last_login_ip AS last_login_ip_12, t0.last_login_country AS last_login_country_13, t0.is_active AS is_active_14, t0.must_change_password AS must_change_password_15, t0.password_reset_token AS password_reset_token_16, t0.password_reset_expires AS password_reset_expires_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.organization_id AS organization_id_20, t0.user_profile_id AS user_profile_id_21 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"sellam.bernard@gmail.com"
]
|
|
2.23 ms (4.69%) |
3 |
"START TRANSACTION"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| central | doctrine.dbal.central_connection |
| tenant | doctrine.dbal.tenant_connection |
Entity Managers
| Name | Service |
|---|---|
| central | doctrine.orm.central_entity_manager |
| tenant | doctrine.orm.tenant_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
central entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Central\AuditLog | 2 |
| App\Entity\Central\Organization | 1 |
| App\Entity\Central\User | 1 |
| App\Entity\Central\UserOrganizationAccess | 1 |
tenant entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
central entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Central\Organization |
|
| App\Entity\Central\User | No errors. |
| App\Entity\Central\SmsPack | No errors. |
| App\Entity\Central\WordpressToken | No errors. |
| App\Entity\Central\UserProfile | No errors. |
| App\Entity\Central\UserOrganizationAccess | No errors. |
| App\Entity\Central\AuditLog | No errors. |
tenant entity manager
No loaded entities.