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

Query Metrics

27 Database Queries
9 Different statements
11.54 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.88 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.40 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.48 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.user_id = ? LIMIT 1
Parameters:
[
  12
]
4 0.46 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
]
5 0.61 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.creation_date AS creation_date_3, t0.closure_date AS closure_date_4, t0.description AS description_5, t0.is_test_data AS is_test_data_6, t0.creator_id AS creator_id_7, t0.stand_id AS stand_id_8, t0.activity_id AS activity_id_9, t0.type_id AS type_id_10, t0.resolver_id AS resolver_id_11 FROM alert t0 WHERE (t0.status = ? AND t0.stand_id = ?) ORDER BY t0.creation_date ASC
Parameters:
[
  "Open"
  22
]
6 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 3.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.parent_type_id = ?
Parameters:
[
  1
]
8 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.parent_type_id = ?
Parameters:
[
  2
]
9 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.parent_type_id = ?
Parameters:
[
  5
]
10 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.parent_type_id = ?
Parameters:
[
  6
]
11 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.parent_type_id = ?
Parameters:
[
  8
]
12 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.parent_type_id = ?
Parameters:
[
  9
]
13 0.22 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
]
14 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.id = ?
Parameters:
[
  17
]
15 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.parent_type_id = ?
Parameters:
[
  17
]
16 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.id = ?
Parameters:
[
  15
]
17 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.parent_type_id = ?
Parameters:
[
  15
]
18 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.id = ?
Parameters:
[
  18
]
19 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.parent_type_id = ?
Parameters:
[
  18
]
20 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.id = ?
Parameters:
[
  13
]
21 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.parent_type_id = ?
Parameters:
[
  13
]
22 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.id = ?
Parameters:
[
  12
]
23 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.parent_type_id = ?
Parameters:
[
  12
]
24 0.28 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.id = ?
Parameters:
[
  10
]
25 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.id = ?
Parameters:
[
  63
]
26 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.id = ?
Parameters:
[
  69
]
27 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.parent_type_id AS parent_type_id_4, t0.responsible_id AS responsible_id_5 FROM alert_type t0 WHERE t0.parent_type_id = ?
Parameters:
[
  69
]

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

Class Mapping errors
App\Entity\ExternalApplication No errors.
App\Entity\User No errors.
App\Entity\Stand No errors.
App\Entity\Image No errors.
App\Entity\CGUVersion No errors.
App\Entity\Organisation No errors.
App\Entity\Event No errors.
App\Entity\Notification No errors.
App\Entity\VirtualCreditCard No errors.
App\Entity\Person No errors.
App\Entity\PostalAdress No errors.
App\Entity\ContactDetails No errors.
App\Entity\PersonType No errors.
App\Entity\AccountCreationInvitation No errors.
App\Entity\StandQueueConfig No errors.
App\Entity\ArticleAndStock\StockLocation No errors.
App\Entity\ActivityAndAffectation\Activity No errors.
App\Entity\ActivityAndAffectation\Affectation No errors.
App\Entity\Alert\Alert No errors.
App\Entity\VirtualCardTransaction No errors.
App\Entity\NeededMaterial No errors.
App\Entity\StandAccessControl
  • The association App\Entity\StandAccessControl#event refers to the inverse side field App\Entity\Event#standAccessControls which does not exist.
App\Entity\Alert\AlertType No errors.
App\Entity\EventPerson No errors.