Query Metrics
109
Database Queries
4
Different statements
30.78 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
14.63 ms (47.54%) |
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.89 ms (25.62%) |
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.14 ms (23.20%) |
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.12 ms (3.64%) |
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 |
|
| App\Entity\Licence | No errors. |
| App\Entity\Assurance | No errors. |