https://reservation-besancon.1055.fr/suggested_offer Return to referer URL

Query Metrics

4 Database Queries
2 Different statements
1.54 ms Query time
2 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 0.36 ms
SELECT t0.id AS id_1, t0.cart_condition AS cart_condition_2, t0.message AS message_3, t0.title AS title_4, t0.text_button AS text_button_5, t0.lien_externe AS lien_externe_6, t0.formule_test_id AS formule_test_id_7, t8.id AS id_9, t8.designation AS designation_10, t8.code AS code_11, t8.url_formule AS url_formule_12, t8.temps_limite_resa AS temps_limite_resa_13, t8.nbre_mini AS nbre_mini_14, t8.nbre_maxi AS nbre_maxi_15, t8.presence_avant AS presence_avant_16, t8.is_creneau_activity AS is_creneau_activity_17, t8.heure_ouverture_creneau AS heure_ouverture_creneau_18, t8.heure_fermeture_creneau AS heure_fermeture_creneau_19, t8.temps_creneau AS temps_creneau_20, t8.priority AS priority_21, t8.actif AS actif_22, t8.description AS description_23, t8.image AS image_24, t8.updated_at AS updated_at_25, t0.forfait_cible_id AS forfait_cible_id_26, t27.id AS id_28, t27.designation AS designation_29, t27.information AS information_30, t27.is_pass_kids AS is_pass_kids_31, t27.is_pass_famille AS is_pass_famille_32, t27.pass_color AS pass_color_33, t27.nbre_activites AS nbre_activites_34, t27.priority AS priority_35, t27.is_active AS is_active_36, t27.url_forfait AS url_forfait_37, t27.min_participants AS min_participants_38, t27.is_new AS is_new_39, t27.is_shortly AS is_shortly_40, t27.formule_id AS formule_id_41 FROM suggested_offer t0 LEFT JOIN formule t8 ON t0.formule_test_id = t8.id LEFT JOIN forfait t27 ON t0.forfait_cible_id = t27.id
Parameters:
[]
2 0.73 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.information AS information_3, t0.is_pass_kids AS is_pass_kids_4, t0.is_pass_famille AS is_pass_famille_5, t0.pass_color AS pass_color_6, t0.nbre_activites AS nbre_activites_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.url_forfait AS url_forfait_10, t0.min_participants AS min_participants_11, t0.is_new AS is_new_12, t0.is_shortly AS is_shortly_13, t0.formule_id AS formule_id_14 FROM forfait t0 INNER JOIN suggested_offer_forfait ON t0.id = suggested_offer_forfait.forfait_id WHERE suggested_offer_forfait.suggested_offer_id = ?
Parameters:
[
  16
]
3 0.25 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.information AS information_3, t0.is_pass_kids AS is_pass_kids_4, t0.is_pass_famille AS is_pass_famille_5, t0.pass_color AS pass_color_6, t0.nbre_activites AS nbre_activites_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.url_forfait AS url_forfait_10, t0.min_participants AS min_participants_11, t0.is_new AS is_new_12, t0.is_shortly AS is_shortly_13, t0.formule_id AS formule_id_14 FROM forfait t0 INNER JOIN suggested_offer_forfait ON t0.id = suggested_offer_forfait.forfait_id WHERE suggested_offer_forfait.suggested_offer_id = ?
Parameters:
[
  17
]
4 0.20 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.information AS information_3, t0.is_pass_kids AS is_pass_kids_4, t0.is_pass_famille AS is_pass_famille_5, t0.pass_color AS pass_color_6, t0.nbre_activites AS nbre_activites_7, t0.priority AS priority_8, t0.is_active AS is_active_9, t0.url_forfait AS url_forfait_10, t0.min_participants AS min_participants_11, t0.is_new AS is_new_12, t0.is_shortly AS is_shortly_13, t0.formule_id AS formule_id_14 FROM forfait t0 INNER JOIN suggested_offer_forfait ON t0.id = suggested_offer_forfait.forfait_id WHERE suggested_offer_forfait.suggested_offer_id = ?
Parameters:
[
  18
]

customer connection

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection
customer doctrine.dbal.customer_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
customer doctrine.orm.customer_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Main\SuggestedOffer No errors.
App\Entity\Main\Formule No errors.
App\Entity\Main\Forfait
  • The field App\Entity\Main\Forfait#activityOptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Main\ActivityOptions#forfait does not contain the required 'inversedBy="activityOptions"' attribute.
App\Entity\Main\Activity
  • The association App\Entity\Main\Activity#options refers to the owning side field App\Entity\Main\ActivityOptions#activity which does not exist.
App\Entity\Main\Price No errors.
App\Entity\Main\ActivityOptions No errors.
App\Entity\Main\Promos No errors.
App\Entity\Main\PromosOptions No errors.
App\Entity\Main\CartoBon No errors.

customer entity manager

No loaded entities.