Query Metrics
19
Database Queries
9
Different statements
7.31 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.85 ms |
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.id_locpro AS id_locpro_2, a0_.description AS description_3, a0_.visuel AS visuel_4, a0_.telephone AS telephone_5, a0_.horaires AS horaires_6, a0_.type AS type_7, a0_.description_en AS description_en_8, a0_.description_nl AS description_nl_9, a0_.description_de AS description_de_10, a0_.nom_de AS nom_de_11, a0_.nom_en AS nom_en_12, a0_.nom_nl AS nom_nl_13, a0_.active AS active_14, a0_.email AS email_15, a0_.longitude AS longitude_16, a0_.latitude AS latitude_17, a0_.blind_return AS blind_return_18, a0_.swikly_company_id AS swikly_company_id_19, a0_.swikly_key AS swikly_key_20, a0_.swikly_api_key AS swikly_api_key_21, a0_.swikly_api_secret AS swikly_api_secret_22, a0_.slug AS slug_23, a0_.title AS title_24, a0_.metadesc AS metadesc_25, a0_.h1 AS h1_26, a0_.slug_en AS slug_en_27, a0_.slug_de AS slug_de_28, a0_.slug_nl AS slug_nl_29, a0_.h1_en AS h1_en_30, a0_.h1_de AS h1_de_31, a0_.h1_nl AS h1_nl_32, a0_.title_en AS title_en_33, a0_.title_de AS title_de_34, a0_.title_nl AS title_nl_35, a0_.metadesc_en AS metadesc_en_36, a0_.metadesc_de AS metadesc_de_37, a0_.metadesc_nl AS metadesc_nl_38, a0_.infosupp AS infosupp_39, a0_.maplink AS maplink_40, a0_.infosupp_en AS infosupp_en_41, a0_.infosupp_de AS infosupp_de_42, a0_.infosupp_nl AS infosupp_nl_43, a0_.horaires_en AS horaires_en_44, a0_.horaires_de AS horaires_de_45, a0_.horaires_nl AS horaires_nl_46, a0_.avisclient AS avisclient_47, a0_.new AS new_48, a0_.adresse_id AS adresse_id_49, a0_.company_id AS company_id_50 FROM agence a0_ WHERE (a0_.nom = ? AND a0_.active = 0) OR a0_.id_locpro = ? OR a0_.slug = ? OR a0_.slug_en = ? OR a0_.slug_de = ? OR a0_.slug_nl = ?
Parameters:
[ "location-van-bastia" "location-van-bastia" "location-van-bastia" "location-van-bastia" "location-van-bastia" "location-van-bastia" ] |
| 2 | 0.49 ms |
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_agence ON t0.id = campervan_agence.campervan_id WHERE campervan_agence.agence_id = ?
Parameters:
[
95
]
|
| 3 | 0.22 ms |
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
]
|
| 4 | 0.28 ms |
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:
[
176
]
|
| 5 | 0.90 ms |
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:
[
176
]
|
| 6 | 0.29 ms |
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:
[
176
]
|
| 7 | 0.30 ms |
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:
[
179
]
|
| 8 | 0.53 ms |
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:
[
179
]
|
| 9 | 0.19 ms |
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:
[
179
]
|
| 10 | 0.26 ms |
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:
[
183
]
|
| 11 | 0.45 ms |
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:
[
183
]
|
| 12 | 0.19 ms |
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:
[
183
]
|
| 13 | 0.16 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM campervan_type t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 14 | 0.23 ms |
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:
[
186
]
|
| 15 | 0.59 ms |
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:
[
186
]
|
| 16 | 0.21 ms |
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:
[
186
]
|
| 17 | 0.23 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.content AS content_3, t0.content_en AS content_en_4, t0.content_de AS content_de_5, t0.content_nl AS content_nl_6, t0.agencies_id AS agencies_id_7, t0.assurance_id AS assurance_id_8 FROM further_info t0 WHERE t0.agencies_id = ?
Parameters:
[
95
]
|
| 18 | 0.53 ms |
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:
[
8124
]
|
| 19 | 0.43 ms |
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 agence_agence ON t0.id = agence_agence.agence_target WHERE agence_agence.agence_source = ?
Parameters:
[
95
]
|
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\Agence | No errors. |
| App\Entity\Adresse | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Campervan | No errors. |
| App\Entity\Booking | No errors. |
| App\Entity\Vehicule | No errors. |
| App\Entity\Calendar | No errors. |
| App\Entity\OptionsVan | No errors. |
| App\Entity\Tarification | No errors. |
| App\Entity\FurtherInfo | No errors. |
| App\Entity\Eventbs |
|
| App\Entity\VanCaracteristique | No errors. |
| App\Entity\ImgGallery | No errors. |
| App\Entity\CampervanType | No errors. |
| App\Entity\VideoURL | No errors. |
| App\Entity\Specs | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Roadtrip | No errors. |
| App\Entity\RoadbookActivite | No errors. |
| App\Entity\Assurance | No errors. |
| App\Entity\Licence | No errors. |