GET https://cms.efel.app/api/v1/roadtrips/fr

Query Metrics

65 Database Queries
3 Different statements
48.20 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
30.15 ms
(62.55%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.titre AS titre_4, t0.content AS content_5, t0.file AS file_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.duree AS duree_9, t0.country AS country_10, t0.region AS region_11, t0.title_en AS title_en_12, t0.title_de AS title_de_13, t0.title_nl AS title_nl_14, t0.content_en AS content_en_15, t0.content_de AS content_de_16, t0.content_nl AS content_nl_17, t0.slug AS slug_18, t0.slug_en AS slug_en_19, t0.slug_de AS slug_de_20, t0.slug_nl AS slug_nl_21, t0.h1 AS h1_22, t0.h1_en AS h1_en_23, t0.h1_de AS h1_de_24, t0.h1_nl AS h1_nl_25, t0.metadesc AS metadesc_26, t0.metadesc_en AS metadesc_en_27, t0.metadesc_de AS metadesc_de_28, t0.metadesc_nl AS metadesc_nl_29 FROM roadtrip t0
Parameters:
[]
11.22 ms
(23.28%)
32
SELECT t0.id AS id_1, t0.img_file AS img_file_2, t3.id AS id_4, t3.nom AS nom_5, t3.modele AS modele_6, t3.description AS description_7, t3.options AS options_8, t3.visite_virtuelle AS visite_virtuelle_9, t3.visuel AS visuel_10, t3.lien_descriptif AS lien_descriptif_11, t3.id_locpro AS id_locpro_12, t3.description_en AS description_en_13, t3.description_de AS description_de_14, t3.description_nl AS description_nl_15, t3.price AS price_16, t3.motorisation AS motorisation_17, t3.couchage AS couchage_18, t3.places AS places_19, t3.douche_wc AS douche_wc_20, t3.dimensions AS dimensions_21, t3.slug AS slug_22, t3.plan_price AS plan_price_23, t3.title AS title_24, t3.metadesc AS metadesc_25, t3.h1 AS h1_26, t3.slug_en AS slug_en_27, t3.slug_de AS slug_de_28, t3.slug_nl AS slug_nl_29, t3.h1_en AS h1_en_30, t3.h1_de AS h1_de_31, t3.h1_nl AS h1_nl_32, t3.title_en AS title_en_33, t3.title_de AS title_de_34, t3.title_nl AS title_nl_35, t3.metadesc_en AS metadesc_en_36, t3.metadesc_de AS metadesc_de_37, t3.metadesc_nl AS metadesc_nl_38, t3.logo AS logo_39, t3.visible AS visible_40, t3.order_show AS order_show_41, t3.caracteristiques_id AS caracteristiques_id_42, t3.img_gallery_id AS img_gallery_id_43, t3.campervan_type_id AS campervan_type_id_44, t45.id AS id_46, t45.nom AS nom_47, t45.description AS description_48, t45.visuel AS visuel_49, t45.prix AS prix_50, t45.active AS active_51, t45.stock AS stock_52, t45.nom_en AS nom_en_53, t45.nom_de AS nom_de_54, t45.nom_nl AS nom_nl_55, t45.description_en AS description_en_56, t45.description_de AS description_de_57, t45.description_nl AS description_nl_58, t45.stripe_id AS stripe_id_59, t45.slug AS slug_60, t45.slug_en AS slug_en_61, t45.slug_de AS slug_de_62, t45.slug_nl AS slug_nl_63, t45.h1 AS h1_64, t45.h1_en AS h1_en_65, t45.h1_de AS h1_de_66, t45.h1_nl AS h1_nl_67, t45.title AS title_68, t45.title_en AS title_en_69, t45.title_de AS title_de_70, t45.title_nl AS title_nl_71, t45.metadesc AS metadesc_72, t45.metadesc_en AS metadesc_en_73, t45.metadesc_de AS metadesc_de_74, t45.metadesc_nl AS metadesc_nl_75, t45.pictures_id AS pictures_id_76, t0.cpw_id AS cpw_id_77, t0.roadtrip_id AS roadtrip_id_78, t0.eventbs_id AS eventbs_id_79 FROM img_gallery t0 LEFT JOIN campervan t3 ON t3.img_gallery_id = t0.id LEFT JOIN product t45 ON t45.pictures_id = t0.id WHERE t0.roadtrip_id = ?
Parameters:
[
  88
]
6.83 ms
(14.16%)
32
SELECT t0.id AS id_1, t0.title AS title_2 FROM roadtriptag t0 INNER JOIN roadtrip_roadtriptag ON t0.id = roadtrip_roadtriptag.roadtriptag_id WHERE roadtrip_roadtriptag.roadtrip_id = ?
Parameters:
[
  88
]

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\Roadtrip No errors.
App\Entity\ImgGallery No errors.
App\Entity\Roadtriptag No errors.
App\Entity\Campervan No errors.
App\Entity\VanCaracteristique No errors.
App\Entity\CampervanType No errors.
App\Entity\Product No errors.
App\Entity\Eventbs
  • The association App\Entity\Eventbs#eventbstags refers to the inverse side field App\Entity\Eventbstag#eventbs which does not exist.
App\Entity\RoadbookActivite No errors.