https://dm23-dev.theraconseil.net/visitors-usefull-information

Query Metrics

13 Database Queries
6 Different statements
3.18 ms Query time
7 Invalid entities

Queries

Group similar statements

# Time Info
1 1.72 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.13 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.39 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:
[
  "visitors-usefull-information"
  1
]
4 0.15 ms
SELECT t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.address1 AS address1_10, t0.address2 AS address2_11, t0.zipcode AS zipcode_12, t0.city AS city_13, t0.phone AS phone_14, t0.mobile AS mobile_15, t0.other_position AS other_position_16, t0.activation_token AS activation_token_17, t0.reset_token AS reset_token_18, t0.auto_identification_token AS auto_identification_token_19, t0.terms_approved AS terms_approved_20, t0.terms_approval_date AS terms_approval_date_21, t0.password_creation AS password_creation_22, t0.active AS active_23, t0.avatar_name AS avatar_name_24, t0.updated_at AS updated_at_25, t0.created_at AS created_at_26, t0.last_login_ip AS last_login_ip_27, t0.last_login_at AS last_login_at_28, t0.banned_at AS banned_at_29, t0.last_search_at AS last_search_at_30, t0.theme AS theme_31, t0.vegan_menu AS vegan_menu_32, t0.evening22 AS evening22_33, t0.evening23 AS evening23_34, t0.evening24 AS evening24_35, t0.accept_meeting AS accept_meeting_36, t0.country_id AS country_id_37, t0.phone_prefix_id AS phone_prefix_id_38, t0.mobile_prefix_id AS mobile_prefix_id_39, t0.position_id AS position_id_40, t0.locale_id AS locale_id_41, t0.company_id AS company_id_42, t0.title_id AS title_id_43, t0.registration_id AS registration_id_44, t0.type, t3.birth_date AS birth_date_45 FROM `user` t0 LEFT JOIN `organiser_user` t1 ON t0.id = t1.id LEFT JOIN `exhibitor_user` t2 ON t0.id = t2.id LEFT JOIN `visitor_user` t3 ON t0.id = t3.id WHERE t0.id = ?
Parameters:
[
  1
]
5 0.10 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:
[
  0
]
6 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso AS iso_3, t0.status AS status_4, t0.direction AS direction_5 FROM language t0 WHERE t0.id = ?
Parameters:
[
  37
]
7 0.15 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 l1_.iso = ? AND l1_.status = ? ORDER BY p0_.display_order ASC
Parameters:
[
  "en"
  1
]
8 0.09 ms
SELECT t0.option_key AS option_key_1, t0.option_value AS option_value_2 FROM `option` t0 WHERE t0.option_key = ?
Parameters:
[
  "meeting_requests"
]
9 0.05 ms
SELECT t0.option_key AS option_key_1, t0.option_value AS option_value_2 FROM `option` t0 WHERE t0.option_key = ?
Parameters:
[
  "meeting_acceptance"
]
10 0.08 ms
SELECT t0.option_key AS option_key_1, t0.option_value AS option_value_2 FROM `option` t0 WHERE t0.option_key = ?
Parameters:
[
  "badge_download"
]
11 0.08 ms
SELECT t0.option_key AS option_key_1, t0.option_value AS option_value_2 FROM `option` t0 WHERE t0.option_key = ?
Parameters:
[
  "meeting_activated"
]
12 0.08 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_start_date"
]
13 0.08 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_end_date"
]

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\Organiser\Organiser
  • The association App\Domain\Organiser\Organiser#myFavorites refers to the inverse side field App\Domain\Auth\User#extraGuests which does not exist.
  • The mappings App\Domain\Organiser\Organiser#favoriteOf and App\Domain\Auth\User#myFavorites are inconsistent with each other.
App\Domain\Exhibitor\Exhibitor
  • The association App\Domain\Exhibitor\Exhibitor#myFavorites refers to the inverse side field App\Domain\Auth\User#extraGuests which does not exist.
  • The mappings App\Domain\Exhibitor\Exhibitor#favoriteOf and App\Domain\Auth\User#myFavorites are inconsistent with each other.
App\Domain\Visitor\Visitor
  • The association App\Domain\Visitor\Visitor#myFavorites refers to the inverse side field App\Domain\Auth\User#extraGuests which does not exist.
  • The mappings App\Domain\Visitor\Visitor#favoriteOf and App\Domain\Auth\User#myFavorites are inconsistent with each other.
App\Domain\Country\Country No errors.
App\Domain\PhonePrefix\PhonePrefix No errors.
App\Domain\Position\Position No errors.
App\Domain\Company\Company No errors.
App\Domain\Title\Title No errors.
App\Domain\Registration\Registration No errors.
App\Domain\Meeting\Search No errors.
App\Domain\Exhibitor\Registration\Registration No errors.
App\Domain\Visitor\Registration\Registration No errors.
App\Domain\Meeting\Meeting No errors.
App\Domain\Chat\Participant No errors.
App\Domain\Chat\Message No errors.
App\Domain\Invoice\Invoice No errors.
App\Domain\Auth\UserLog No errors.
App\Domain\Chat\Conversation No errors.
App\Domain\OrderDetail\OrderDetail No errors.
App\Domain\Mailing\DynamicPdfFile No errors.
App\Domain\Exhibitor\Company\Company No errors.
App\Domain\Product\ProductCountry No errors.
App\Domain\CompanyProfil\CompanyProfil
  • The association App\Domain\CompanyProfil\CompanyProfil#pages refers to the owning side field App\Domain\Page\Page#profile which is not defined as association, but as field.
  • The association App\Domain\CompanyProfil\CompanyProfil#pages refers to the owning side field App\Domain\Page\Page#profile which does not exist.
App\Domain\Massif\Massif
  • The field App\Domain\Massif\Massif#companies is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\Company\Company#massif does not contain the required 'inversedBy="companies"' attribute.
App\Domain\Massif\Section
  • The field App\Domain\Massif\Section#companies is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Domain\Company\Company#sectionMassif does not contain the required 'inversedBy="companies"' attribute.
App\Domain\Massif\Station No errors.
App\Domain\StatusChange\StatusChange No errors.
App\Domain\Meeting\Schedule No errors.