GET https://site.gestloca.com/cars/en/

Query Metrics

27 Database Queries
6 Different statements
82.71 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 3.96 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.fuel AS fuel_3, t0.gear_type AS gear_type_4, t0.model AS model_5, t0.capacity AS capacity_6, t0.is_active AS is_active_7, t0.photo AS photo_8, t0.price AS price_9, t0.description AS description_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.car_type_id AS car_type_id_13, t0.car_brand_id AS car_brand_id_14 FROM car t0 WHERE t0.is_active = ? ORDER BY t0.id DESC
Parameters:
[
  1
]
2 2.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
3 0.90 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
4 1.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
5 1.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
6 6.02 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.photo AS photo_4, t0.is_header_menu AS is_header_menu_5, t0.is_footer_menu AS is_footer_menu_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM page t0 WHERE t0.is_header_menu = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
7 1.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
8 3.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
9 3.97 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
10 2.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
11 4.51 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.photo AS photo_3, t0.icon AS icon_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM car_type t0
Parameters:
[]
12 3.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM car_brand t0 WHERE t0.id = ?
Parameters:
[
  4
]
13 1.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
14 2.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM car_brand t0 WHERE t0.id = ?
Parameters:
[
  3
]
15 4.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
16 4.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM car_brand t0 WHERE t0.id = ?
Parameters:
[
  5
]
17 4.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
18 5.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM car_brand t0 WHERE t0.id = ?
Parameters:
[
  6
]
19 3.97 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
20 3.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
21 2.80 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
22 3.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM car_brand t0 WHERE t0.id = ?
Parameters:
[
  2
]
23 1.94 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
24 3.99 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM car_brand t0 WHERE t0.id = ?
Parameters:
[
  1
]
25 4.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
26 1.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.meta_desc AS meta_desc_6, t0.phone AS phone_7, t0.facebook_page AS facebook_page_8, t0.x_profile AS x_profile_9, t0.youtube AS youtube_10, t0.whatsapp AS whatsapp_11, t0.insta_profile AS insta_profile_12, t0.currency AS currency_13, t0.notify_email AS notify_email_14, t0.js_code AS js_code_15, t0.css_code AS css_code_16, t0.map_frame AS map_frame_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM setting t0 LIMIT 1
Parameters:
[]
27 1.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.photo AS photo_4, t0.is_header_menu AS is_header_menu_5, t0.is_footer_menu AS is_footer_menu_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM page t0 WHERE t0.is_footer_menu = ? ORDER BY t0.id ASC
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\Car No errors.
App\Entity\CarType No errors.
App\Entity\CarBrand No errors.
App\Entity\Reservation
  • The mappings App\Entity\Reservation#arrivalLocation and App\Entity\Location#reservations are inconsistent with each other.
App\Entity\Setting No errors.
App\Entity\Page No errors.