Query Metrics
197
Database Queries
16
Different statements
23.69 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.59 ms (23.60%) |
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"
]
|
3.80 ms (16.02%) |
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
]
|
2.84 ms (11.98%) |
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.16 ms (9.14%) |
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"
]
|
1.82 ms (7.69%) |
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.52 ms (6.41%) |
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:
[
10700
]
|
0.97 ms (4.10%) |
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:
[
2729
]
|
0.92 ms (3.88%) |
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:
[
2729
]
|
0.91 ms (3.84%) |
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.89 ms (3.77%) |
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:
[
2729
]
|
0.76 ms (3.23%) |
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.41 ms (1.73%) |
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.36 ms (1.54%) |
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.35 ms (1.49%) |
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.24 ms (1.03%) |
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.13 ms (0.56%) |
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. |