Query Metrics
216
Database Queries
6
Different statements
37.39 ms
Query time
0
Invalid entities
111
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
18.40 ms (49.23%) |
104 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.enabled = ? AND t0.parent_category_id = ? ORDER BY t0.position ASC
Parameters:
[ 1 "409c9ecf-ff18-4b18-9cc1-b8acf8f30f48" ] |
|
15.58 ms (41.67%) |
104 |
SELECT t0.position AS position_1, t0.is_main AS is_main_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.category_id AS category_id_6, t0.media_id AS media_id_7 FROM products_categories_medias t0 WHERE t0.category_id = ?
Parameters:
[
"409c9ecf-ff18-4b18-9cc1-b8acf8f30f48"
]
|
|
1.55 ms (4.15%) |
1 |
SELECT l0_.name AS name_0, l0_.content AS content_1, l0_.enabled AS enabled_2, l0_.location AS location_3, l0_.created_at AS created_at_4, l0_.updated_at AS updated_at_5, l0_.id AS id_6, l0_.created_by_user AS created_by_user_7, l0_.updated_by_user AS updated_by_user_8 FROM legal_texts l0_ WHERE l0_.location = ? AND l0_.enabled = ? LIMIT 1
Parameters:
[ 3 1 ] |
|
1.25 ms (3.34%) |
5 |
SELECT t0.keyname AS keyname_1, t0.value AS value_2, t0.label AS label_3, t0.description AS description_4, t0.id AS id_5 FROM configuration t0 WHERE t0.keyname = ? LIMIT 1
Parameters:
[
"info_header_contact_1"
]
|
|
0.36 ms (0.95%) |
1 |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.position AS position_3, t0.enabled AS enabled_4, t0.number_id AS number_id_5, t0.is_virtual AS is_virtual_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.related_category_id AS related_category_id_10, t0.parent_category_id AS parent_category_id_11 FROM products_categories t0 WHERE t0.enabled = ? AND t0.parent_category_id IS NULL ORDER BY t0.position ASC
Parameters:
[
1
]
|
|
0.24 ms (0.65%) |
1 |
SELECT p0_.name AS name_0, p0_.url AS url_1, p0_.status AS status_2, p0_.date_start AS date_start_3, p0_.date_end AS date_end_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.id AS id_7 FROM promotions p0_ WHERE p0_.status = ? ORDER BY p0_.date_start ASC LIMIT 30
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Fotoboom\Product\Domain\Category | 104 |
| Fotoboom\Configuration\Domain\Configuration | 5 |
| Fotoboom\LegalText\Domain\LegalText | 1 |
| Fotoboom\User\Domain\User | 1 |