Query Metrics
197
Database Queries
16
Different statements
26.08 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.59 ms (21.43%) |
48 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.type AS type_4, t0.prefix AS prefix_5, t0.suffix AS suffix_6 FROM car_property t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"price-tax"
]
|
4.37 ms (16.74%) |
32 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.id_app_file AS id_app_file_4 FROM app_file_meta t0 WHERE t0.id_app_file = ?
Parameters:
[
4770
]
|
3.21 ms (12.32%) |
21 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.mime_type AS mime_type_4, t0.date_created AS date_created_5, t0.date_modified AS date_modified_6, t0.author AS author_7 FROM app_file t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1743
]
|
2.59 ms (9.93%) |
21 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.slug AS slug_4, t0.template AS template_5, t0.date_modified AS date_modified_6 FROM cms_page t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"service"
]
|
2.20 ms (8.44%) |
16 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.slug AS slug_4, t0.date_modified AS date_modified_5 FROM car_category t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"audi"
]
|
1.70 ms (6.51%) |
12 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.mime_type AS mime_type_4, t0.date_created AS date_created_5, t0.date_modified AS date_modified_6, t0.author AS author_7 FROM app_file t0 WHERE t0.id = ?
Parameters:
[
10344
]
|
1.02 ms (3.90%) |
8 |
SELECT t0.id AS id_1, t0.is_main AS is_main_2, t0.is_thumbnail AS is_thumbnail_3, t0.id_car AS id_car_4, t0.id_file AS id_file_5 FROM car_image t0 WHERE t0.id_car = ?
Parameters:
[
2580
]
|
1.01 ms (3.89%) |
8 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.slug AS slug_4, t0.date_modified AS date_modified_5 FROM car_category t0
Parameters:
[] |
0.93 ms (3.57%) |
8 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.id_car_property AS id_car_property_3, t0.id_car AS id_car_4 FROM car_car_property t0 WHERE t0.id_car = ?
Parameters:
[
2580
]
|
0.88 ms (3.37%) |
6 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.slug AS slug_4, t0.template AS template_5, t0.date_modified AS date_modified_6 FROM cms_page t0
Parameters:
[] |
0.86 ms (3.30%) |
8 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.id_car AS id_car_4 FROM car_meta t0 WHERE t0.id_car = ?
Parameters:
[
2580
]
|
0.53 ms (2.03%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.id_car_category AS id_car_category_4 FROM car_category_meta t0 WHERE t0.id_car_category = ?
Parameters:
[
1
]
|
0.48 ms (1.84%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.slug AS slug_4, t0.template AS template_5, t0.date_modified AS date_modified_6 FROM cms_page t0 WHERE t0.template = ? LIMIT 1
Parameters:
[
"homepage"
]
|
0.35 ms (1.33%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.id_cms_page AS id_cms_page_4 FROM cms_page_meta t0 WHERE t0.id_cms_page = ?
Parameters:
[
1
]
|
0.21 ms (0.81%) |
1 |
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.status AS status_3, c0_.date_created AS date_created_4, c0_.date_modified AS date_modified_5, c0_.is_visible AS is_visible_6, c0_.is_active AS is_active_7 FROM car c0_ WHERE c0_.is_visible = 1 AND c0_.status = ? ORDER BY c0_.date_modified DESC LIMIT 8
Parameters:
[
"published"
]
|
0.15 ms (0.59%) |
1 |
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.occupation AS occupation_3, t0.content AS content_4, t0.photo AS photo_5 FROM cms_client t0
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\CmsPage | No errors. |
App\Entity\CmsPageMeta | No errors. |
App\Entity\AppFile | No errors. |
App\Entity\User | No errors. |
App\Entity\AppFileMeta | No errors. |
App\Entity\CarCategory | No errors. |
App\Entity\CarCategoryMeta | No errors. |
App\Entity\Car | No errors. |
App\Entity\CarCarProperty | No errors. |
App\Entity\CarEquipment | No errors. |
App\Entity\CarCarCategory | No errors. |
App\Entity\CarImage | No errors. |
App\Entity\CarMeta | No errors. |
App\Entity\CarProperty | No errors. |
App\Entity\CmsClient | No errors. |