Query Metrics
5
Database Queries
4
Different statements
2.63 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.67 ms |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.background AS background_2, e0_.preselectionDate AS preselectionDate_3, e0_.ceremonyDate AS ceremonyDate_4, e0_.voteSponsorStartAt AS voteSponsorStartAt_5, e0_.voteSponsorEndAt AS voteSponsorEndAt_6, e0_.voteFavoriteStartAt AS voteFavoriteStartAt_7, e0_.voteFavoriteEndAt AS voteFavoriteEndAt_8, e0_.voteBpiStartAt AS voteBpiStartAt_9, e0_.voteBpiEndAt AS voteBpiEndAt_10, e0_.invitationPreselectionStartAt AS invitationPreselectionStartAt_11, e0_.invitationPreselectionEndAt AS invitationPreselectionEndAt_12, e0_.invitationCeremonyStartAt AS invitationCeremonyStartAt_13, e0_.invitationCeremonyEndAt AS invitationCeremonyEndAt_14, e0_.status AS status_15, e0_.invitationPreselectionDescription AS invitationPreselectionDescription_16, e0_.invitationCeremonyDescription AS invitationCeremonyDescription_17 FROM events e0_ WHERE e0_.name LIKE ?
Parameters:
[
"%2026%"
]
|
| 2 | 0.55 ms |
SELECT i0_.id AS id_0, i0_.client_id AS client_id_1, i0_.event_id AS event_id_2, i0_.firstName AS firstName_3, i0_.lastName AS lastName_4, i0_.job AS job_5, i0_.company AS company_6, i0_.email AS email_7, i0_.forPreselection AS forPreselection_8, i0_.forCeremony AS forCeremony_9, i0_.user_type_id AS user_type_id_10, i0_.hasBeenThere AS hasBeenThere_11, i0_.status AS status_12, i0_.createdAt AS createdAt_13, i0_.comment AS comment_14, i0_.client_id AS client_id_15 FROM invitations i0_ WHERE i0_.event_id IN (?) AND i0_.forPreselection = 1 AND i0_.forCeremony = 0 ORDER BY i0_.id DESC
Parameters:
[
4
]
|
| 3 | 0.49 ms |
SELECT i0_.id AS id_0, i0_.client_id AS client_id_1, i0_.event_id AS event_id_2, i0_.firstName AS firstName_3, i0_.lastName AS lastName_4, i0_.job AS job_5, i0_.company AS company_6, i0_.email AS email_7, i0_.forPreselection AS forPreselection_8, i0_.forCeremony AS forCeremony_9, i0_.user_type_id AS user_type_id_10, i0_.hasBeenThere AS hasBeenThere_11, i0_.status AS status_12, i0_.createdAt AS createdAt_13, i0_.comment AS comment_14, i0_.client_id AS client_id_15 FROM invitations i0_ WHERE i0_.event_id IN (?) AND i0_.forPreselection = 1 AND i0_.forCeremony = 0 ORDER BY i0_.id DESC
Parameters:
[
4
]
|
| 4 | 0.71 ms |
SELECT i0_.id AS id_0, i0_.client_id AS client_id_1, i0_.event_id AS event_id_2, i0_.firstName AS firstName_3, i0_.lastName AS lastName_4, i0_.job AS job_5, i0_.company AS company_6, i0_.email AS email_7, i0_.forPreselection AS forPreselection_8, i0_.forCeremony AS forCeremony_9, i0_.user_type_id AS user_type_id_10, i0_.hasBeenThere AS hasBeenThere_11, i0_.status AS status_12, i0_.createdAt AS createdAt_13, i0_.comment AS comment_14, i0_.client_id AS client_id_15 FROM invitations i0_ WHERE i0_.event_id IN (?) AND i0_.forPreselection = 1 AND i0_.forCeremony = 0 AND i0_.hasBeenThere = 1 ORDER BY i0_.id DESC
Parameters:
[
4
]
|
| 5 | 0.21 ms |
SELECT i0_.id AS id_0, i0_.client_id AS client_id_1, i0_.event_id AS event_id_2, i0_.firstName AS firstName_3, i0_.lastName AS lastName_4, i0_.job AS job_5, i0_.company AS company_6, i0_.email AS email_7, i0_.forPreselection AS forPreselection_8, i0_.forCeremony AS forCeremony_9, i0_.user_type_id AS user_type_id_10, i0_.hasBeenThere AS hasBeenThere_11, i0_.status AS status_12, i0_.createdAt AS createdAt_13, i0_.comment AS comment_14, i0_.client_id AS client_id_15 FROM invitations i0_ WHERE i0_.event_id IN (?) AND i0_.forPreselection = 1 AND i0_.forCeremony = 0 AND i0_.status = 0 ORDER BY i0_.id DESC
Parameters:
[
4
]
|
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\Invitation |
|
| App\Entity\Event | No errors. |
| App\Entity\Client | No errors. |