GET https://staging.clubalpin01.fr/activites/ski-de-montagne

Query Metrics

14 Database Queries
5 Different statements
7.43 ms Query time
0 Invalid entities
44 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 1.74 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"
  "SR"
]
2 0.68 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:
[
  "SR"
]
3 0.52 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:
[
  "SR"
]
4 0.42 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:
[
  "SR"
]
5 0.75 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:
[
  41
]
6 0.83 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:
[
  175
]
7 0.44 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:
[
  43
]
8 0.38 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:
[
  45
]
9 0.28 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:
[
  49
]
10 0.28 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
]
11 0.27 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:
[
  23
]
12 0.31 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:
[
  54
]
13 0.26 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:
[
  56
]
14 0.28 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:
[
  57
]

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\ActivityLevel 13
App\Entity\Supervisor 10
App\Entity\Member 10
App\Entity\AdminUser 10
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.