https://dm23-dev.theraconseil.net/pdf/show/10

Query Metrics

5 Database Queries
3 Different statements
2.69 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.71 ms
SELECT t0.option_key AS option_key_1, t0.option_value AS option_value_2 FROM `option` t0 WHERE t0.option_key = ?
Parameters:
[
  "event_name"
]
2 0.12 ms
SELECT t0.option_key AS option_key_1, t0.option_value AS option_value_2 FROM `option` t0 WHERE t0.option_key = ?
Parameters:
[
  "event_email"
]
3 0.38 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.description AS description_5, p0_.meta_title AS meta_title_6, p0_.meta_description AS meta_description_7, p0_.indexation AS indexation_8, p0_.slug AS slug_9, p0_.in_menu AS in_menu_10, p0_.profile AS profile_11, p0_.linked_to_route AS linked_to_route_12, p0_.menu_title AS menu_title_13, p0_.display_order AS display_order_14, p0_.language_id AS language_id_15, p0_.parent_id AS parent_id_16, p0_.author_id AS author_id_17 FROM page p0_ INNER JOIN language l1_ ON p0_.language_id = l1_.id WHERE p0_.slug = ? AND l1_.status = ?
Parameters:
[
  "10"
  1
]
4 0.36 ms
SELECT t0.id AS id_3, t0.stand_shared_with_company AS stand_shared_with_company_4, t0.status AS status_5, t0.rgpd_consent AS rgpd_consent_6, t0.last_step AS last_step_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.cancelled_at AS cancelled_at_10, t0.atout_france_checked AS atout_france_checked_11, t0.status_thera_checked AS status_thera_checked_12, t0.fl_sent_validataion_mail AS fl_sent_validataion_mail_13, t0.status_changed_at AS status_changed_at_14, t0.subscribed_at AS subscribed_at_15, t0.manager_id AS manager_id_16, t0.company_id AS company_id_17, t0.type FROM `registration` t0 LEFT JOIN `exhibitor_registration` t1 ON t0.id = t1.id LEFT JOIN `visitor_registration` t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
  "10"
]
5 0.12 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.description AS description_5, p0_.meta_title AS meta_title_6, p0_.meta_description AS meta_description_7, p0_.indexation AS indexation_8, p0_.slug AS slug_9, p0_.in_menu AS in_menu_10, p0_.profile AS profile_11, p0_.linked_to_route AS linked_to_route_12, p0_.menu_title AS menu_title_13, p0_.display_order AS display_order_14, p0_.language_id AS language_id_15, p0_.parent_id AS parent_id_16, p0_.author_id AS author_id_17 FROM page p0_ INNER JOIN language l1_ ON p0_.language_id = l1_.id WHERE p0_.slug = ? AND l1_.status = ?
Parameters:
[
  "10"
  1
]

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\Domain\Order\Order No errors.
App\Domain\Application\Entity\Option No errors.
App\Domain\Mailing\Mailing No errors.
App\Domain\Auth\ViewUserAvailableMeeting No errors.
App\Domain\Mailing\MailingAttachment No errors.
App\Domain\PaiementTransaction\PaiementTransaction No errors.
App\Domain\Page\Page No errors.
App\Domain\Language\Language No errors.
App\Domain\Auth\User
  • The association App\Domain\Auth\User#myFavorites refers to the inverse side field App\Domain\Auth\User#extraGuests which does not exist.
  • The mappings App\Domain\Auth\User#favoriteOf and App\Domain\Auth\User#myFavorites are inconsistent with each other.
App\Domain\Auth\Entity\LoginAttempt No errors.
App\Domain\Registration\Registration No errors.
App\Domain\Exhibitor\Registration\Registration No errors.
App\Domain\Visitor\Registration\Registration No errors.
App\Domain\Company\Company No errors.
App\Domain\Chat\Conversation No errors.