GET https://event-api.bbtpt.fr/api/eventActor/getStandPlanning/22

Query Metrics

15 Database Queries
9 Different statements
3.41 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.23 ms
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.token AS token_3 FROM external_application t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "1234"
]
2 0.19 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.roles AS roles_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.email AS email_6, t0.device_token AS device_token_7, t0.last_connexion AS last_connexion_8, t0.creation_date AS creation_date_9, t0.mobile_phone AS mobile_phone_10, t0.accepted_cgu_at AS accepted_cgu_at_11, t0.onboarding_dismissed AS onboarding_dismissed_12, t0.onboarding_completed_steps AS onboarding_completed_steps_13, t0.current_location_id AS current_location_id_14, t0.avatar_id AS avatar_id_15, t0.accepted_cgu_id AS accepted_cgu_id_16 FROM `user` t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
  "65V9LvFIxqTv07k1gym5C9mtUXE3"
]
3 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible_for_public AS is_visible_for_public_3, t0.can_credit_badge AS can_credit_badge_4, t0.can_debit_badge AS can_debit_badge_5, t0.can_debit_article AS can_debit_article_6, t0.can_add_option_to_badge AS can_add_option_to_badge_7, t0.max_capacity AS max_capacity_8, t0.current_participants_number AS current_participants_number_9, t0.is_coat_room AS is_coat_room_10, t0.coat_room_price AS coat_room_price_11, t0.can_scan_tickets AS can_scan_tickets_12, t0.can_scan_material AS can_scan_material_13, t0.event_id AS event_id_14, t15.id AS id_16, t15.enabled AS enabled_17, t15.public_queue_token AS public_queue_token_18, t15.consent_required AS consent_required_19, t15.event_id AS event_id_20, t15.stand_id AS stand_id_21, t22.id AS id_23, t22.name AS name_24, t22.stand_id AS stand_id_25, t22.parent_id AS parent_id_26 FROM stand t0 LEFT JOIN stand_queue_config t15 ON t15.stand_id = t0.id LEFT JOIN stock_location t22 ON t22.stand_id = t0.id WHERE t0.id = ?
Parameters:
[
  22
]
4 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.is_visible_for_public AS is_visible_for_public_5, t0.needed_affectations AS needed_affectations_6, t0.stand_id AS stand_id_7, t0.job_sheet_id AS job_sheet_id_8, t0.affectation_category_id AS affectation_category_id_9 FROM activity t0 WHERE t0.stand_id = ? ORDER BY t0.start_date ASC
Parameters:
[
  22
]
5 0.23 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.event_id AS event_id_3, t0.activity_id AS activity_id_4, t0.stand_id AS stand_id_5 FROM image t0 WHERE t0.activity_id = ?
Parameters:
[
  21
]
6 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.stand_id AS stand_id_5, t0.person_id AS person_id_6, t0.team_id AS team_id_7, t0.activity_id AS activity_id_8 FROM affectation t0 WHERE t0.activity_id = ?
Parameters:
[
  21
]
7 0.46 ms
SELECT t0.id AS id_1, t0.permissions AS permissions_2, t0.person_id AS person_id_3, t0.person_type_id AS person_type_id_4, t0.event_id AS event_id_5, t6.id AS id_7, t6.hotel AS hotel_8, t6.transport AS transport_9, t6.notes AS notes_10, t6.event_person_id AS event_person_id_11, t0.team_id AS team_id_12 FROM event_person t0 LEFT JOIN logistics_information t6 ON t6.event_person_id = t0.id WHERE t0.id = ?
Parameters:
[
  11
]
8 0.20 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.is_active AS is_active_4, t0.adress_id AS adress_id_5, t0.contact_details_id AS contact_details_id_6, t0.default_person_type_id AS default_person_type_id_7, t0.user_id AS user_id_8, t0.organisation_id AS organisation_id_9, t0.avatar_id AS avatar_id_10, t11.id AS id_12, t11.date AS date_13, t11.person_id AS person_id_14 FROM person t0 LEFT JOIN account_creation_invitation t11 ON t11.person_id = t0.id WHERE t0.id = ?
Parameters:
[
  8
]
9 0.16 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.event_id AS event_id_3, t0.activity_id AS activity_id_4, t0.stand_id AS stand_id_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  58
]
10 0.14 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.event_id AS event_id_3, t0.activity_id AS activity_id_4, t0.stand_id AS stand_id_5 FROM image t0 WHERE t0.activity_id = ?
Parameters:
[
  24
]
11 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.stand_id AS stand_id_5, t0.person_id AS person_id_6, t0.team_id AS team_id_7, t0.activity_id AS activity_id_8 FROM affectation t0 WHERE t0.activity_id = ?
Parameters:
[
  24
]
12 0.11 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.event_id AS event_id_3, t0.activity_id AS activity_id_4, t0.stand_id AS stand_id_5 FROM image t0 WHERE t0.activity_id = ?
Parameters:
[
  23
]
13 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.stand_id AS stand_id_5, t0.person_id AS person_id_6, t0.team_id AS team_id_7, t0.activity_id AS activity_id_8 FROM affectation t0 WHERE t0.activity_id = ?
Parameters:
[
  23
]
14 0.20 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.event_id AS event_id_3, t0.activity_id AS activity_id_4, t0.stand_id AS stand_id_5 FROM image t0 WHERE t0.activity_id = ?
Parameters:
[
  20
]
15 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.stand_id AS stand_id_5, t0.person_id AS person_id_6, t0.team_id AS team_id_7, t0.activity_id AS activity_id_8 FROM affectation t0 WHERE t0.activity_id = ?
Parameters:
[
  20
]

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.

Entities Mapping