https://pre-checkin.www02.jobinlive.fr/sitemap.xml

Query Metrics

5 Database Queries
4 Different statements
1.07 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.32 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.22 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.25 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.15 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.14 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
  • The association App\Entity\Invitation#client refers to the inverse side field App\Entity\Client#invitations which does not exist.
App\Entity\Event No errors.
App\Entity\Client No errors.