Query Metrics
7
Database Queries
5
Different statements
7.02 ms
Query time
0
Invalid entities
12
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.28 ms |
SELECT p0_.id AS id_0, p0_.starts_on AS starts_on_1, p0_.ends_on AS ends_on_2, p0_.duration AS duration_3, p0_.duration_hours AS duration_hours_4, p0_.title AS title_5, p0_.description AS description_6, p0_.address AS address_7, p0_.latitude AS latitude_8, p0_.longitude AS longitude_9, p0_.featured_image AS featured_image_10, p0_.featured_image_thumb AS featured_image_thumb_11, p0_.rendezvous_time AS rendezvous_time_12, p0_.visible AS visible_13, p0_.canceled AS canceled_14, p0_.deleted AS deleted_15, p0_.payment_by_account AS payment_by_account_16, p0_.payment_by_other AS payment_by_other_17, p0_.payment_amount AS payment_amount_18, p0_.payment_other_amount AS payment_other_amount_19, p0_.advance_payment_amount AS advance_payment_amount_20, p0_.debit_on AS debit_on_21, p0_.registration_required AS registration_required_22, p0_.registration_start AS registration_start_23, p0_.registration_end AS registration_end_24, p0_.maximum_registrations AS maximum_registrations_25, p0_.registrations_cancellable AS registrations_cancellable_26, p0_.withdrawal_deadline AS withdrawal_deadline_27, p0_.accounting_code AS accounting_code_28, p0_.accounting_ana_code AS accounting_ana_code_29, p0_.total_cost AS total_cost_30, p0_.validated AS validated_31, p0_.legal_validated AS legal_validated_32, p0_.validated_at AS validated_at_33, p0_.legal_validated_at AS legal_validated_at_34, p0_.validation_email_sent AS validation_email_sent_35, p0_.validation_email_sent_at AS validation_email_sent_at_36, p0_.created_at AS created_at_37, p0_.updated_at AS updated_at_38, p0_.registration_by_organizer AS registration_by_organizer_39, p0_.elevation AS elevation_40, p0_.distance AS distance_41, p0_.training AS training_42, p0_.activity_id AS activity_id_43, p0_.section_id AS section_id_44, p0_.creator_id AS creator_id_45, p0_.supervisor_id AS supervisor_id_46, p0_.localisation_id AS localisation_id_47, p0_.canceled_by_id AS canceled_by_id_48, p0_.deleted_by_id AS deleted_by_id_49, p0_.validated_by_id AS validated_by_id_50, p0_.legal_validated_by_id AS legal_validated_by_id_51, p0_.level_id AS level_id_52 FROM program p0_ INNER JOIN caf2_section c1_ ON p0_.section_id = c1_.id WHERE (p0_.visible = 1 AND p0_.deleted = 0 AND p0_.validated = 1 AND p0_.starts_on >= ? AND UPPER(c1_.activity_code) IN (?)) AND p0_.training IN ('0') ORDER BY p0_.starts_on ASC LIMIT 3
Parameters:
[ "2025-12-12 00:00:00" "SF" ] |
| 2 | 0.92 ms |
SELECT s0_.id AS id_0, s0_.responsable AS responsable_1, s0_.actif AS actif_2, s0_.created_at AS created_at_3, s0_.code_stage AS code_stage_4, s0_.code_james AS code_james_5, s0_.stage AS stage_6, s0_.obtention AS obtention_7, s0_.recyclage AS recyclage_8, s0_.prochain AS prochain_9, s0_.statut AS statut_10, s0_.member_id AS member_id_11, s0_.activity_id AS activity_id_12 FROM supervisor s0_ INNER JOIN caf2_member c1_ ON s0_.member_id = c1_.id INNER JOIN activity a2_ ON s0_.activity_id = a2_.id WHERE s0_.actif = 1 AND a2_.visible = 1 AND UPPER(a2_.code) IN (?) AND s0_.responsable = 0 ORDER BY c1_.last_name ASC, c1_.first_name ASC
Parameters:
[
"SF"
]
|
| 3 | 0.62 ms |
SELECT s0_.id AS id_0, s0_.responsable AS responsable_1, s0_.actif AS actif_2, s0_.created_at AS created_at_3, s0_.code_stage AS code_stage_4, s0_.code_james AS code_james_5, s0_.stage AS stage_6, s0_.obtention AS obtention_7, s0_.recyclage AS recyclage_8, s0_.prochain AS prochain_9, s0_.statut AS statut_10, s0_.member_id AS member_id_11, s0_.activity_id AS activity_id_12 FROM supervisor s0_ INNER JOIN caf2_member c1_ ON s0_.member_id = c1_.id INNER JOIN activity a2_ ON s0_.activity_id = a2_.id WHERE s0_.actif = 1 AND s0_.responsable = 1 AND a2_.visible = 1 AND UPPER(a2_.code) IN (?) ORDER BY c1_.last_name ASC, c1_.first_name ASC
Parameters:
[
"SF"
]
|
| 4 | 0.40 ms |
SELECT a0_.id AS id_0, a0_.short_name AS short_name_1, a0_.name AS name_2, a0_.description AS description_3, a0_.activity_id AS activity_id_4 FROM activity_level a0_ INNER JOIN activity a1_ ON a0_.activity_id = a1_.id WHERE a1_.code = ? AND a1_.visible = 1 ORDER BY a0_.id ASC
Parameters:
[
"SF"
]
|
| 5 | 0.64 ms |
SELECT t0.license AS license_1, t0.license_key AS license_key_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.member_since AS member_since_5, t0.birthday AS birthday_6, t0.ffcam_membership_since AS ffcam_membership_since_7, t0.ffcam_last_sync_on AS ffcam_last_sync_on_8, t0.renewed_membership AS renewed_membership_9, t0.closed_account AS closed_account_10, t0.email AS email_11, t0.invalid_email AS invalid_email_12, t0.mobile_phone_number AS mobile_phone_number_13, t0.home_phone_number AS home_phone_number_14, t0.emergency_phone_number AS emergency_phone_number_15, t0.has_cm AS has_cm_16, t0.terms_agreed_at AS terms_agreed_at_17, t0.newsletter_subscribed_at AS newsletter_subscribed_at_18, t0.comment AS comment_19, t0.newsletter_subscriptions AS newsletter_subscriptions_20, t0.negative_balance_email_counter AS negative_balance_email_counter_21, t0.id AS id_22, t0.username AS username_23, t0.password AS password_24, t0.active AS active_25, t0.locked AS locked_26, t0.failed_login AS failed_login_27, t0.expires_at AS expires_at_28, t0.credentials_expire_at AS credentials_expire_at_29, t0.roles AS roles_30, t0.last_login AS last_login_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.token AS token_34, t35.first_name AS first_name_36, t35.last_name AS last_name_37, t35.email AS email_38, t35.phone_number AS phone_number_39, t35.email_receipt AS email_receipt_40, t35.rights AS rights_41, t35.id AS id_42, t35.username AS username_43, t35.password AS password_44, t35.active AS active_45, t35.locked AS locked_46, t35.failed_login AS failed_login_47, t35.expires_at AS expires_at_48, t35.credentials_expire_at AS credentials_expire_at_49, t35.roles AS roles_50, t35.last_login AS last_login_51, t35.created_at AS created_at_52, t35.updated_at AS updated_at_53, t35.token AS token_54, t35.member_id AS member_id_55 FROM caf2_member t0 LEFT JOIN caf2_admin_user t35 ON t35.member_id = t0.id WHERE t0.id = ?
Parameters:
[
50
]
|
| 6 | 0.61 ms |
SELECT t0.license AS license_1, t0.license_key AS license_key_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.member_since AS member_since_5, t0.birthday AS birthday_6, t0.ffcam_membership_since AS ffcam_membership_since_7, t0.ffcam_last_sync_on AS ffcam_last_sync_on_8, t0.renewed_membership AS renewed_membership_9, t0.closed_account AS closed_account_10, t0.email AS email_11, t0.invalid_email AS invalid_email_12, t0.mobile_phone_number AS mobile_phone_number_13, t0.home_phone_number AS home_phone_number_14, t0.emergency_phone_number AS emergency_phone_number_15, t0.has_cm AS has_cm_16, t0.terms_agreed_at AS terms_agreed_at_17, t0.newsletter_subscribed_at AS newsletter_subscribed_at_18, t0.comment AS comment_19, t0.newsletter_subscriptions AS newsletter_subscriptions_20, t0.negative_balance_email_counter AS negative_balance_email_counter_21, t0.id AS id_22, t0.username AS username_23, t0.password AS password_24, t0.active AS active_25, t0.locked AS locked_26, t0.failed_login AS failed_login_27, t0.expires_at AS expires_at_28, t0.credentials_expire_at AS credentials_expire_at_29, t0.roles AS roles_30, t0.last_login AS last_login_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.token AS token_34, t35.first_name AS first_name_36, t35.last_name AS last_name_37, t35.email AS email_38, t35.phone_number AS phone_number_39, t35.email_receipt AS email_receipt_40, t35.rights AS rights_41, t35.id AS id_42, t35.username AS username_43, t35.password AS password_44, t35.active AS active_45, t35.locked AS locked_46, t35.failed_login AS failed_login_47, t35.expires_at AS expires_at_48, t35.credentials_expire_at AS credentials_expire_at_49, t35.roles AS roles_50, t35.last_login AS last_login_51, t35.created_at AS created_at_52, t35.updated_at AS updated_at_53, t35.token AS token_54, t35.member_id AS member_id_55 FROM caf2_member t0 LEFT JOIN caf2_admin_user t35 ON t35.member_id = t0.id WHERE t0.id = ?
Parameters:
[
199
]
|
| 7 | 0.56 ms |
SELECT t0.license AS license_1, t0.license_key AS license_key_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.member_since AS member_since_5, t0.birthday AS birthday_6, t0.ffcam_membership_since AS ffcam_membership_since_7, t0.ffcam_last_sync_on AS ffcam_last_sync_on_8, t0.renewed_membership AS renewed_membership_9, t0.closed_account AS closed_account_10, t0.email AS email_11, t0.invalid_email AS invalid_email_12, t0.mobile_phone_number AS mobile_phone_number_13, t0.home_phone_number AS home_phone_number_14, t0.emergency_phone_number AS emergency_phone_number_15, t0.has_cm AS has_cm_16, t0.terms_agreed_at AS terms_agreed_at_17, t0.newsletter_subscribed_at AS newsletter_subscribed_at_18, t0.comment AS comment_19, t0.newsletter_subscriptions AS newsletter_subscriptions_20, t0.negative_balance_email_counter AS negative_balance_email_counter_21, t0.id AS id_22, t0.username AS username_23, t0.password AS password_24, t0.active AS active_25, t0.locked AS locked_26, t0.failed_login AS failed_login_27, t0.expires_at AS expires_at_28, t0.credentials_expire_at AS credentials_expire_at_29, t0.roles AS roles_30, t0.last_login AS last_login_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.token AS token_34, t35.first_name AS first_name_36, t35.last_name AS last_name_37, t35.email AS email_38, t35.phone_number AS phone_number_39, t35.email_receipt AS email_receipt_40, t35.rights AS rights_41, t35.id AS id_42, t35.username AS username_43, t35.password AS password_44, t35.active AS active_45, t35.locked AS locked_46, t35.failed_login AS failed_login_47, t35.expires_at AS expires_at_48, t35.credentials_expire_at AS credentials_expire_at_49, t35.roles AS roles_50, t35.last_login AS last_login_51, t35.created_at AS created_at_52, t35.updated_at AS updated_at_53, t35.token AS token_54, t35.member_id AS member_id_55 FROM caf2_member t0 LEFT JOIN caf2_admin_user t35 ON t35.member_id = t0.id WHERE t0.id = ?
Parameters:
[
64
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| refuge | doctrine.dbal.refuge_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| refuge | doctrine.orm.refuge_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Supervisor | 3 |
| App\Entity\Member | 3 |
| App\Entity\ActivityLevel | 3 |
| App\Entity\AdminUser | 2 |
| App\Entity\Activity | 1 |
refuge entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Supervisor | No errors. |
| App\Entity\BaseProgram | No errors. |
| App\Entity\Section | No errors. |
| App\Entity\Program | No errors. |
| App\Entity\Activity | No errors. |
| App\Entity\AdminUser | No errors. |
| App\Entity\Localisation | No errors. |
| App\Entity\ActivityLevel | No errors. |
| App\Entity\Member | No errors. |
| App\Entity\MonetaryAccountMovement | No errors. |
| App\Entity\ProgramRegistration | No errors. |
| App\Entity\MonetaryAccountTransaction | No errors. |
| App\Entity\PhotoAlbum | No errors. |
| App\Entity\MemberDVATraining | No errors. |
| App\Entity\MailerEmail | No errors. |
refuge entity manager
No loaded entities.