Query Metrics
65
Database Queries
3
Different statements
48.20 ms
Query time
1
Invalid entities
Grouped Statements
| 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 |
|
| App\Entity\RoadbookActivite | No errors. |