Query Metrics
58
Database Queries
4
Different statements
21.26 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
12.42 ms (58.41%) |
26 |
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 INNER JOIN campervan_img_gallery ON t0.id = campervan_img_gallery.img_gallery_id WHERE campervan_img_gallery.campervan_id = ?
Parameters:
[
178
]
|
|
7.23 ms (34.00%) |
26 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.picto AS picto_3, t0.value AS value_4, t0.order_list AS order_list_5, t0.svgcode AS svgcode_6, t0.name_en AS name_en_7, t0.name_de AS name_de_8, t0.name_nl AS name_nl_9, t0.value_en AS value_en_10, t0.value_de AS value_de_11, t0.value_nl AS value_nl_12 FROM specs t0 INNER JOIN specs_campervan ON t0.id = specs_campervan.specs_id WHERE specs_campervan.campervan_id = ?
Parameters:
[
178
]
|
|
0.96 ms (4.54%) |
5 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM campervan_type t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.65 ms (3.05%) |
1 |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.modele AS modele_2, c0_.description AS description_3, c0_.options AS options_4, c0_.visite_virtuelle AS visite_virtuelle_5, c0_.visuel AS visuel_6, c0_.lien_descriptif AS lien_descriptif_7, c0_.id_locpro AS id_locpro_8, c0_.description_en AS description_en_9, c0_.description_de AS description_de_10, c0_.description_nl AS description_nl_11, c0_.price AS price_12, c0_.motorisation AS motorisation_13, c0_.couchage AS couchage_14, c0_.places AS places_15, c0_.douche_wc AS douche_wc_16, c0_.dimensions AS dimensions_17, c0_.slug AS slug_18, c0_.plan_price AS plan_price_19, c0_.title AS title_20, c0_.metadesc AS metadesc_21, c0_.h1 AS h1_22, c0_.slug_en AS slug_en_23, c0_.slug_de AS slug_de_24, c0_.slug_nl AS slug_nl_25, c0_.h1_en AS h1_en_26, c0_.h1_de AS h1_de_27, c0_.h1_nl AS h1_nl_28, c0_.title_en AS title_en_29, c0_.title_de AS title_de_30, c0_.title_nl AS title_nl_31, c0_.metadesc_en AS metadesc_en_32, c0_.metadesc_de AS metadesc_de_33, c0_.metadesc_nl AS metadesc_nl_34, c0_.logo AS logo_35, c0_.visible AS visible_36, c0_.order_show AS order_show_37, c0_.caracteristiques_id AS caracteristiques_id_38, c0_.img_gallery_id AS img_gallery_id_39, c0_.campervan_type_id AS campervan_type_id_40 FROM campervan c0_ ORDER BY c0_.order_show ASC, c0_.nom ASC
Parameters:
[] |
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\Campervan | No errors. |
| App\Entity\VanCaracteristique | No errors. |
| App\Entity\ImgGallery | No errors. |
| App\Entity\CampervanType | No errors. |
| App\Entity\Agence | No errors. |
| App\Entity\Vehicule | No errors. |
| App\Entity\Booking | No errors. |
| App\Entity\VideoURL | No errors. |
| App\Entity\Tarification | No errors. |
| App\Entity\Specs | No errors. |
| App\Entity\OptionsVan | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Roadtrip | No errors. |
| App\Entity\Eventbs |
|
| App\Entity\RoadbookActivite | No errors. |