GET https://cms.efel.app/api/v1/agences/orderbycountries/fr

Query Metrics

109 Database Queries
4 Different statements
30.76 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
14.52 ms
(47.22%)
36
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
]
7.90 ms
(25.68%)
36
SELECT t0.id AS id_1, t0.days_of_week AS days_of_week_2, t0.day_morning_begin AS day_morning_begin_3, t0.day_morning_end AS day_morning_end_4, t0.day_afternoon_begin AS day_afternoon_begin_5, t0.day_afternoon_end AS day_afternoon_end_6, t0.closed_period_begin AS closed_period_begin_7, t0.closed_period_end AS closed_period_end_8 FROM calendar t0 INNER JOIN agence_calendar ON t0.id = agence_calendar.calendar_id WHERE agence_calendar.agence_id = ?
Parameters:
[
  47
]
7.21 ms
(23.44%)
36
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:
[
  47
]
1.13 ms
(3.66%)
1
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_.active = 0
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\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
  • The association App\Entity\Eventbs#eventbstags refers to the inverse side field App\Entity\Eventbstag#eventbs which does not exist.
App\Entity\Licence No errors.
App\Entity\Assurance No errors.