GET https://dev-companions-gencard-v2.pcronline.com/api/companions/profile/bf5fd304226341d0f97ed0f7f630ecd6

Query Metrics

5 Database Queries
5 Different statements
4.44 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.45 ms
SELECT t0.remote_id AS remote_id_1, t0.companion_id AS companion_id_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.email AS email_5, t0.created_date AS created_date_6, t0.send_mail AS send_mail_7, t0.country AS country_8, t0.profession AS profession_9, t10.id AS id_11, t10.idt_client AS idt_client_12, t10.id_member AS id_member_13, t10.loading_time AS loading_time_14, t10.points AS points_15, t10.birthdate AS birthdate_16, t10.firstname AS firstname_17, t10.lastname AS lastname_18, t10.remote_id AS remote_id_19, t20.id AS id_21, t20.full_response AS full_response_22, t20.created_date AS created_date_23, t20.edit_date AS edit_date_24, t20.processing_bcu AS processing_bcu_25, t20.remote_id AS remote_id_26, t27.id AS id_28, t27.date_first_reminder AS date_first_reminder_29, t27.date_second_reminder AS date_second_reminder_30, t27.date_third_reminder AS date_third_reminder_31, t27.remote_id AS remote_id_32, t33.id AS id_34, t33.halfway_push AS halfway_push_35, t33.remote_id AS remote_id_36 FROM member t0 LEFT JOIN member_points t10 ON t10.remote_id = t0.remote_id LEFT JOIN member_bcu t20 ON t20.remote_id = t0.remote_id LEFT JOIN member_reminder_mail t27 ON t27.remote_id = t0.remote_id LEFT JOIN member_flags t33 ON t33.remote_id = t0.remote_id WHERE t0.remote_id = ? LIMIT 1
Parameters:
[
  "bf5fd304226341d0f97ed0f7f630ecd6"
]
2 0.52 ms
SELECT t0.id AS id_1, t0.idt_client AS idt_client_2, t0.id_member AS id_member_3, t0.lastname AS lastname_4, t0.firstname AS firstname_5, t0.birthdate AS birthdate_6, t0.operation_name AS operation_name_7, t0.year AS year_8, t0.type_action AS type_action_9, t0.label_action AS label_action_10, t0.points AS points_11, t0.loading_date AS loading_date_12, t0.label_title AS label_title_13, t0.label_sub_title AS label_sub_title_14, t0.attribution_date AS attribution_date_15, t0.details AS details_16, t0.is_consumed AS is_consumed_17, t0.reference_bcu AS reference_bcu_18, t0.remote_id AS remote_id_19 FROM member_points_details t0 WHERE t0.remote_id = ?
Parameters:
[
  "bf5fd304226341d0f97ed0f7f630ecd6"
]
3 0.76 ms
SELECT t0.id AS id_1, t0.type_action AS type_action_2, t0.processing_bcu AS processing_bcu_3, t0.points AS points_4, t0.action_date AS action_date_5, t0.expiration_date AS expiration_date_6, t0.type_event AS type_event_7, t0.is_consumed AS is_consumed_8, t0.remote_id AS remote_id_9 FROM member_points_tmp t0 WHERE t0.remote_id = ?
Parameters:
[
  "bf5fd304226341d0f97ed0f7f630ecd6"
]
4 0.88 ms
SELECT m0_.id AS id_0, m0_.type_action AS type_action_1, m0_.processing_bcu AS processing_bcu_2, m0_.points AS points_3, m0_.action_date AS action_date_4, m0_.expiration_date AS expiration_date_5, m0_.type_event AS type_event_6, m0_.is_consumed AS is_consumed_7, m0_.remote_id AS remote_id_8 FROM member_points_tmp m0_ WHERE m0_.type_event = ? AND m0_.remote_id = ? ORDER BY m0_.id DESC LIMIT 1
Parameters:
[
  "REFRESH_DETAILS"
  "bf5fd304226341d0f97ed0f7f630ecd6"
]
5 0.82 ms
SELECT t0.id AS id_1, t0.date_edit_formstack AS date_edit_formstack_2, t0.remote_id AS remote_id_3 FROM member_update_formstack t0 WHERE t0.remote_id = ? ORDER BY t0.date_edit_formstack DESC
Parameters:
[
  "bf5fd304226341d0f97ed0f7f630ecd6"
]

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.