Query Metrics

24 Database Queries
9 Different statements
358.33 ms Query time
0 Invalid entities
72 Managed entities

Queries

Group similar statements

#▲ Time Info
1 43.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.catconfiguration_id AS catconfiguration_id_4 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "default currency"
]
2 36.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.prefix AS prefix_4, t0.suffix AS suffix_5, t0.enabled AS enabled_6, t0.created AS created_7, t0.updated AS updated_8, t0.user_add AS user_add_9, t0.user_update AS user_update_10 FROM currencies t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "USD"
]
3 13.41 ms
SELECT count(c0_.id) AS sclr_0 FROM cars c0_
Parameters:
[]
4 6.37 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.number_vehicles AS number_vehicles_2, c0_.free_distance AS free_distance_3, c0_.min_rental AS min_rental_4, c0_.number_place AS number_place_5, c0_.nbr_doors AS nbr_doors_6, c0_.luggage AS luggage_7, c0_.body AS body_8, c0_.created AS created_9, c0_.updated AS updated_10, c0_.user_add AS user_add_11, c0_.user_update AS user_update_12, c0_.category_id AS category_id_13, c0_.manufacter_id AS manufacter_id_14 FROM cars c0_ ORDER BY c0_.id DESC LIMIT 8
Parameters:
[]
5 136.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created AS created_4, t0.updated AS updated_5, t0.user_add AS user_add_6, t0.user_update AS user_update_7 FROM categories t0
Parameters:
[]
6 14.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.largitude AS largitude_5, t0.address AS address_6, t0.zipcode AS zipcode_7, t0.city AS city_8, t0.state AS state_9, t0.country AS country_10, t0.is_default AS is_default_11, t0.phone AS phone_12, t0.email AS email_13, t0.work_schedule AS work_schedule_14, t0.created AS created_15, t0.updated AS updated_16, t0.user_add AS user_add_17, t0.user_update AS user_update_18 FROM locations t0
Parameters:
[]
7 15.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.origin AS origin_3, t0.description AS description_4, t0.created AS created_5, t0.updated AS updated_6, t0.user_add AS user_add_7, t0.user_update AS user_update_8 FROM manufacters t0
Parameters:
[]
8 3.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.catconfiguration_id AS catconfiguration_id_4 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "frontend_theme"
]
9 0.83 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.catconfiguration_id AS catconfiguration_id_4 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "frontend_theme"
]
10 10.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.prefix AS prefix_4, t0.suffix AS suffix_5, t0.enabled AS enabled_6, t0.created AS created_7, t0.updated AS updated_8, t0.user_add AS user_add_9, t0.user_update AS user_update_10 FROM currencies t0 WHERE t0.enabled = ?
Parameters:
[
  1
]
11 9.91 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.size AS size_4, t0.extension AS extension_5, t0.created AS created_6, t0.updated AS updated_7, t0.user_add AS user_add_8, t0.user_update AS user_update_9, t0.defaults AS defaults_10, t0.car_id AS car_id_11 FROM files t0 WHERE t0.car_id = ?
Parameters:
[
  13
]
12 2.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.size AS size_4, t0.extension AS extension_5, t0.created AS created_6, t0.updated AS updated_7, t0.user_add AS user_add_8, t0.user_update AS user_update_9, t0.defaults AS defaults_10, t0.car_id AS car_id_11 FROM files t0 WHERE t0.car_id = ?
Parameters:
[
  12
]
13 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.size AS size_4, t0.extension AS extension_5, t0.created AS created_6, t0.updated AS updated_7, t0.user_add AS user_add_8, t0.user_update AS user_update_9, t0.defaults AS defaults_10, t0.car_id AS car_id_11 FROM files t0 WHERE t0.car_id = ?
Parameters:
[
  10
]
14 11.63 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.size AS size_4, t0.extension AS extension_5, t0.created AS created_6, t0.updated AS updated_7, t0.user_add AS user_add_8, t0.user_update AS user_update_9, t0.defaults AS defaults_10, t0.car_id AS car_id_11 FROM files t0 WHERE t0.car_id = ?
Parameters:
[
  9
]
15 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.size AS size_4, t0.extension AS extension_5, t0.created AS created_6, t0.updated AS updated_7, t0.user_add AS user_add_8, t0.user_update AS user_update_9, t0.defaults AS defaults_10, t0.car_id AS car_id_11 FROM files t0 WHERE t0.car_id = ?
Parameters:
[
  8
]
16 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.size AS size_4, t0.extension AS extension_5, t0.created AS created_6, t0.updated AS updated_7, t0.user_add AS user_add_8, t0.user_update AS user_update_9, t0.defaults AS defaults_10, t0.car_id AS car_id_11 FROM files t0 WHERE t0.car_id = ?
Parameters:
[
  7
]
17 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.size AS size_4, t0.extension AS extension_5, t0.created AS created_6, t0.updated AS updated_7, t0.user_add AS user_add_8, t0.user_update AS user_update_9, t0.defaults AS defaults_10, t0.car_id AS car_id_11 FROM files t0 WHERE t0.car_id = ?
Parameters:
[
  1
]
18 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.catconfiguration_id AS catconfiguration_id_4 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Facebook"
]
19 8.84 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.catconfiguration_id AS catconfiguration_id_4 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TwitterX"
]
20 8.65 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.catconfiguration_id AS catconfiguration_id_4 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Instagram"
]
21 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.catconfiguration_id AS catconfiguration_id_4 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "LinkedIn"
]
22 2.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.catconfiguration_id AS catconfiguration_id_4 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "YouTube"
]
23 19.91 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.catconfiguration_id AS catconfiguration_id_4 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "TikTok"
]
24 10.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.catconfiguration_id AS catconfiguration_id_4 FROM configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Snapchat"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Manufacters 36
App\Entity\Files 16
App\Entity\Categories 8
App\Entity\Cars 7
App\Entity\Currencies 2
App\Entity\Locations 1
App\Entity\Configuration 1
App\Entity\Catconfiguration 1