https://www.otropik.com/o-circuit/mexique

Query Metrics

8 Database Queries
8 Different statements
5.46 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.32 ms
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.slug = ? LIMIT 1
Parameters:
[
  "mexique"
]
2 0.70 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.details AS details_3, t0.position AS position_4, t0.offer_id AS offer_id_5 FROM highlight t0 WHERE t0.offer_id = ?
Parameters:
[
  8
]
3 0.63 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.details AS details_3, t0.km_label AS km_label_4, t0.offer_id AS offer_id_5 FROM itinerary t0 WHERE t0.offer_id = ?
Parameters:
[
  8
]
4 0.57 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.img AS img_3, t0.position AS position_4, t0.offer_id AS offer_id_5 FROM itinerary_pic t0 WHERE t0.offer_id = ?
Parameters:
[
  8
]
5 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.offer_id AS offer_id_3 FROM hebergemnt_offer t0 WHERE t0.offer_id = ?
Parameters:
[
  8
]
6 0.51 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.departure_city AS departure_city_3, t0.arrival_city AS arrival_city_4, t0.airline AS airline_5, t0.flight_number AS flight_number_6, t0.departure_time AS departure_time_7, t0.arrival_time AS arrival_time_8, t0.notes AS notes_9, t0.position AS position_10, t0.offer_id AS offer_id_11 FROM flight t0 WHERE t0.offer_id = ?
Parameters:
[
  8
]
7 0.57 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.position AS position_4, t0.offer_id AS offer_id_5 FROM offer_info t0 WHERE t0.offer_id = ?
Parameters:
[
  8
]
8 0.59 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.position AS position_3, t0.type AS type_4, t0.offer_id AS offer_id_5 FROM included t0 WHERE t0.offer_id = ?
Parameters:
[
  8
]

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\Offer No errors.
App\Entity\Destination 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.