GET https://cms.efel.app/api/v1/van/volkswagen-id-buzz/fr

Query Metrics

15 Database Queries
10 Different statements
5.92 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.41 ms
(23.75%)
3
SELECT t0.id AS id_1, t0.number AS number_2, t0.street AS street_3, t0.zipcode AS zipcode_4, t0.city AS city_5, t0.country AS country_6, t0.id_m AS id_m_7, t0.region AS region_8, t9.id AS id_10, t9.nom AS nom_11, t9.id_locpro AS id_locpro_12, t9.description AS description_13, t9.visuel AS visuel_14, t9.telephone AS telephone_15, t9.horaires AS horaires_16, t9.type AS type_17, t9.description_en AS description_en_18, t9.description_nl AS description_nl_19, t9.description_de AS description_de_20, t9.nom_de AS nom_de_21, t9.nom_en AS nom_en_22, t9.nom_nl AS nom_nl_23, t9.active AS active_24, t9.email AS email_25, t9.longitude AS longitude_26, t9.latitude AS latitude_27, t9.blind_return AS blind_return_28, t9.swikly_company_id AS swikly_company_id_29, t9.swikly_key AS swikly_key_30, t9.swikly_api_key AS swikly_api_key_31, t9.swikly_api_secret AS swikly_api_secret_32, t9.slug AS slug_33, t9.title AS title_34, t9.metadesc AS metadesc_35, t9.h1 AS h1_36, t9.slug_en AS slug_en_37, t9.slug_de AS slug_de_38, t9.slug_nl AS slug_nl_39, t9.h1_en AS h1_en_40, t9.h1_de AS h1_de_41, t9.h1_nl AS h1_nl_42, t9.title_en AS title_en_43, t9.title_de AS title_de_44, t9.title_nl AS title_nl_45, t9.metadesc_en AS metadesc_en_46, t9.metadesc_de AS metadesc_de_47, t9.metadesc_nl AS metadesc_nl_48, t9.infosupp AS infosupp_49, t9.maplink AS maplink_50, t9.infosupp_en AS infosupp_en_51, t9.infosupp_de AS infosupp_de_52, t9.infosupp_nl AS infosupp_nl_53, t9.horaires_en AS horaires_en_54, t9.horaires_de AS horaires_de_55, t9.horaires_nl AS horaires_nl_56, t9.avisclient AS avisclient_57, t9.new AS new_58, t9.adresse_id AS adresse_id_59, t9.company_id AS company_id_60, t61.id AS id_62, t61.email AS email_63, t61.roles AS roles_64, t61.password AS password_65, t61.nom AS nom_66, t61.prenom AS prenom_67, t61.last_log_in AS last_log_in_68, t61.picture_profile AS picture_profile_69, t61.phone AS phone_70, t61.gender AS gender_71, t61.date_of_birth AS date_of_birth_72, t61.place_of_birth AS place_of_birth_73, t61.locpro_id AS locpro_id_74, t61.id_m AS id_m_75, t61.stripe_id AS stripe_id_76, t61.end_date AS end_date_77, t61.plan AS plan_78, t61.refresh_token AS refresh_token_79, t61.api_token AS api_token_80, t61.profilweb AS profilweb_81, t61.notif_email AS notif_email_82, t61.lng AS lng_83, t61.adresse_id AS adresse_id_84, t61.licence_id AS licence_id_85, t86.id AS id_87, t86.name AS name_88, t86.siren AS siren_89, t86.siret AS siret_90, t86.date_creation AS date_creation_91, t86.tva_intra AS tva_intra_92, t86.adresse_id AS adresse_id_93 FROM adresse t0 LEFT JOIN agence t9 ON t9.adresse_id = t0.id LEFT JOIN user t61 ON t61.adresse_id = t0.id LEFT JOIN company t86 ON t86.adresse_id = t0.id WHERE t0.id = ?
Parameters:
[
  8128
]
1.21 ms
(20.47%)
4
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:
[
  173
]
0.62 ms
(10.48%)
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_ WHERE c0_.nom = ? OR c0_.id_locpro = ? OR c0_.slug = ? OR c0_.slug_en = ? OR c0_.slug_de = ? OR c0_.slug_nl = ?
Parameters:
[
  "volkswagen-id-buzz"
  "volkswagen-id-buzz"
  "volkswagen-id-buzz"
  "volkswagen-id-buzz"
  "volkswagen-id-buzz"
  "volkswagen-id-buzz"
]
0.59 ms
(9.98%)
1
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:
[
  173
]
0.49 ms
(8.21%)
1
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.cpw_id = ?
Parameters:
[
  173
]
0.43 ms
(7.18%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.id_locpro AS id_locpro_3, t0.description AS description_4, t0.visuel AS visuel_5, t0.telephone AS telephone_6, t0.horaires AS horaires_7, t0.type AS type_8, t0.description_en AS description_en_9, t0.description_nl AS description_nl_10, t0.description_de AS description_de_11, t0.nom_de AS nom_de_12, t0.nom_en AS nom_en_13, t0.nom_nl AS nom_nl_14, t0.active AS active_15, t0.email AS email_16, t0.longitude AS longitude_17, t0.latitude AS latitude_18, t0.blind_return AS blind_return_19, t0.swikly_company_id AS swikly_company_id_20, t0.swikly_key AS swikly_key_21, t0.swikly_api_key AS swikly_api_key_22, t0.swikly_api_secret AS swikly_api_secret_23, t0.slug AS slug_24, t0.title AS title_25, t0.metadesc AS metadesc_26, t0.h1 AS h1_27, t0.slug_en AS slug_en_28, t0.slug_de AS slug_de_29, t0.slug_nl AS slug_nl_30, t0.h1_en AS h1_en_31, t0.h1_de AS h1_de_32, t0.h1_nl AS h1_nl_33, t0.title_en AS title_en_34, t0.title_de AS title_de_35, t0.title_nl AS title_nl_36, t0.metadesc_en AS metadesc_en_37, t0.metadesc_de AS metadesc_de_38, t0.metadesc_nl AS metadesc_nl_39, t0.infosupp AS infosupp_40, t0.maplink AS maplink_41, t0.infosupp_en AS infosupp_en_42, t0.infosupp_de AS infosupp_de_43, t0.infosupp_nl AS infosupp_nl_44, t0.horaires_en AS horaires_en_45, t0.horaires_de AS horaires_de_46, t0.horaires_nl AS horaires_nl_47, t0.avisclient AS avisclient_48, t0.new AS new_49, t0.adresse_id AS adresse_id_50, t0.company_id AS company_id_51 FROM agence t0 INNER JOIN campervan_agence ON t0.id = campervan_agence.agence_id WHERE campervan_agence.campervan_id = ?
Parameters:
[
  173
]
0.41 ms
(6.97%)
1
SELECT t0.id AS id_1, t0.visuel AS visuel_2, t0.description AS description_3, t0.nom AS nom_4, t0.engine AS engine_5, t0.performances AS performances_6, t0.dimensions AS dimensions_7, t0.layout AS layout_8, t0.equipment AS equipment_9, t0.description_en AS description_en_10, t0.description_de AS description_de_11, t0.description_nl AS description_nl_12, t0.engine_en AS engine_en_13, t0.engine_de AS engine_de_14, t0.engine_nl AS engine_nl_15, t0.performances_en AS performances_en_16, t0.performances_de AS performances_de_17, t0.performances_nl AS performances_nl_18, t0.dimensions_en AS dimensions_en_19, t0.dimensions_de AS dimensions_de_20, t0.dimensions_nl AS dimensions_nl_21, t0.layout_en AS layout_en_22, t0.layout_de AS layout_de_23, t0.layout_nl AS layout_nl_24, t0.equipment_en AS equipment_en_25, t0.equipment_de AS equipment_de_26, t0.equipment_nl AS equipment_nl_27 FROM van_caracteristique t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  7
]
0.36 ms
(6.15%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.modele AS modele_3, t0.description AS description_4, t0.options AS options_5, t0.visite_virtuelle AS visite_virtuelle_6, t0.visuel AS visuel_7, t0.lien_descriptif AS lien_descriptif_8, t0.id_locpro AS id_locpro_9, t0.description_en AS description_en_10, t0.description_de AS description_de_11, t0.description_nl AS description_nl_12, t0.price AS price_13, t0.motorisation AS motorisation_14, t0.couchage AS couchage_15, t0.places AS places_16, t0.douche_wc AS douche_wc_17, t0.dimensions AS dimensions_18, t0.slug AS slug_19, t0.plan_price AS plan_price_20, t0.title AS title_21, t0.metadesc AS metadesc_22, t0.h1 AS h1_23, t0.slug_en AS slug_en_24, t0.slug_de AS slug_de_25, t0.slug_nl AS slug_nl_26, t0.h1_en AS h1_en_27, t0.h1_de AS h1_de_28, t0.h1_nl AS h1_nl_29, t0.title_en AS title_en_30, t0.title_de AS title_de_31, t0.title_nl AS title_nl_32, t0.metadesc_en AS metadesc_en_33, t0.metadesc_de AS metadesc_de_34, t0.metadesc_nl AS metadesc_nl_35, t0.logo AS logo_36, t0.visible AS visible_37, t0.order_show AS order_show_38, t0.caracteristiques_id AS caracteristiques_id_39, t0.img_gallery_id AS img_gallery_id_40, t0.campervan_type_id AS campervan_type_id_41 FROM campervan t0 INNER JOIN campervan_campervan ON t0.id = campervan_campervan.campervan_source WHERE campervan_campervan.campervan_target = ?
Parameters:
[
  173
]
0.21 ms
(3.48%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.lng AS lng_3, t0.campervan_id AS campervan_id_4 FROM video_url t0 WHERE t0.campervan_id = ?
Parameters:
[
  173
]
0.20 ms
(3.34%)
1
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
]

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
  • 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.
App\Entity\Adresse No errors.
App\Entity\Company No errors.
App\Entity\User No errors.
App\Entity\Calendar No errors.
App\Entity\FurtherInfo No errors.
App\Entity\Licence No errors.