https://www.otropik.com/o-escapade/destination/jamaique

Query Metrics

10 Database Queries
5 Different statements
9.98 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.73 ms
(37.34%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.star AS star_4, t0.capacity AS capacity_5, t0.description AS description_6, t0.img AS img_7, t0.banner AS banner_8, t0.adress AS adress_9, t0.city AS city_10, t0.website AS website_11, t0.type_id AS type_id_12, t0.country_id AS country_id_13 FROM hebergement t0 WHERE t0.id = ?
Parameters:
[
  18
]
2.08 ms
(20.88%)
1
SELECT t0.id AS id_1, t0.blurb AS blurb_2, t0.price_from AS price_from_3, t0.board_type AS board_type_4, t0.board_note AS board_note_5, t0.offer_id AS offer_id_6, t0.hebergement_id AS hebergement_id_7 FROM offer_hebergement t0 WHERE t0.offer_id = ?
Parameters:
[
  4
]
1.55 ms
(15.51%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.duration_label AS duration_label_3, t0.departures_text AS departures_text_4, t0.transport_text AS transport_text_5, t0.description AS description_6, t0.price_from AS price_from_7, t0.position AS position_8, t0.offer_id AS offer_id_9 FROM formule t0 WHERE t0.offer_id = ?
Parameters:
[
  4
]
1.40 ms
(14.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.img AS img_5 FROM destination t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "jamaique"
]
1.22 ms
(12.27%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.subtitle AS subtitle_4, t0.description AS description_5, t0.img AS img_6, t0.duration_text AS duration_text_7, t0.date_text AS date_text_8, t0.price_from AS price_from_9, t0.is_publish AS is_publish_10, t0.included_text AS included_text_11, t0.summary_duration AS summary_duration_12, t0.summary_flights AS summary_flights_13, t0.summary_pace_meals AS summary_pace_meals_14, t0.summary_from AS summary_from_15, t0.price_note AS price_note_16, t0.brochure AS brochure_17, t0.our_offer AS our_offer_18, t0.file AS file_19, t0.destination_id AS destination_id_20, t0.type_id AS type_id_21, t0.continent_id AS continent_id_22 FROM offer t0 WHERE t0.destination_id = ? LIMIT 1
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\Destination No errors.
App\Entity\Hebergement No errors.
App\Entity\Offer No errors.
App\Entity\TypeVoyage No errors.
App\Entity\Continent No errors.
App\Entity\OfferHebergement No errors.
App\Entity\Formule No errors.
App\Entity\Included No errors.
App\Entity\Itinerary
  • The association App\Entity\Itinerary#itineraryPics refers to the owning side field App\Entity\ItineraryPic#itinerary which does not exist.
App\Entity\Highlight No errors.
App\Entity\HebergemntOffer No errors.
App\Entity\Flight No errors.
App\Entity\OfferInfo No errors.
App\Entity\OurOffer No errors.
App\Entity\ItineraryPic No errors.
App\Entity\TypeHebergement No errors.