Query Metrics
170
Database Queries
13
Different statements
50.21 ms
Query time
0
Invalid entities
118
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
22.52 ms (44.85%) |
1 |
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM cart t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
"cart_69d76bb01f10b6.96764988"
]
|
|
18.03 ms (35.90%) |
115 |
SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = ? AND e0_.locale = ? AND e0_.object_class = ?
Parameters:
[ "23" "el" "App\Entity\Menu" ] |
|
3.75 ms (7.47%) |
28 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
1
]
|
|
3.19 ms (6.35%) |
17 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
4
]
|
|
0.67 ms (1.33%) |
1 |
SELECT p0_.id AS id_0, p0_.migration_id AS migration_id_1, p0_.softone_id AS softone_id_2, p0_.name AS name_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.published AS published_9, p0_.sort_index AS sort_index_10 FROM product_category p0_ WHERE p0_.rgt < 932 AND p0_.lft > 1 AND p0_.tree_root = ? ORDER BY p0_.tree_root ASC, p0_.lft ASC
Parameters:
[
1
]
|
|
0.53 ms (1.05%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.title AS title_3, t0.slug AS slug_4, t0.summary AS summary_5, t0.description AS description_6, t0.video_url AS video_url_7, t0.published AS published_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.image_id AS image_id_11, t0.menu_id AS menu_id_12, t0.category_id AS category_id_13 FROM article t0 WHERE t0.category_id = ?
Parameters:
[
4
]
|
|
0.30 ms (0.60%) |
1 |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.wishlist AS wishlist_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.price_amount AS price_amount_6, t0.price_currency AS price_currency_7, t0.cart_id AS cart_id_8, t0.product_id AS product_id_9 FROM cart_item t0 WHERE t0.cart_id = ?
Parameters:
[
b"\x1F\x13?2ŽWfHµ¾áp\x1A\x15t›"
]
|
|
0.28 ms (0.55%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.lvl = ?
Parameters:
[
1
]
|
|
0.26 ms (0.53%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.lvl = ? AND t0.website = ? ORDER BY t0.id ASC LIMIT 1
Parameters:
[ 0 "blk.gr" ] |
|
0.22 ms (0.43%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"faq"
]
|
|
0.18 ms (0.36%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.published AS published_9, t0.sort_index AS sort_index_10, t0.tree_root AS tree_root_11, t0.menu_id AS menu_id_12, t0.parent_id AS parent_id_13 FROM article_category t0 WHERE t0.menu_id = ? LIMIT 1
Parameters:
[
23
]
|
|
0.15 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.lvl = ? AND t0.website = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[ 0 "blk.gr" ] |
|
0.14 ms (0.27%) |
1 |
SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.tree_root = ? LIMIT 1
Parameters:
[
true
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| blk | doctrine.dbal.blk_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\Product\Category | 84 |
| App\Entity\Menu | 28 |
| App\Entity\Article\Article | 3 |
| App\Entity\Article\ArticleCategory | 2 |
| App\Entity\Cart\Cart | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Menu | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| Gedmo\Translatable\Entity\Translation | No errors. |
| App\Entity\Article\ArticleCategory | No errors. |
| App\Entity\Article\Article | No errors. |
| App\Entity\Common\Files\AppFile | No errors. |
| App\Entity\Common\Files\ArticleImage | No errors. |
| App\Entity\Cart\Cart | No errors. |
| App\Entity\User\User | No errors. |
| App\Entity\User\WebUser | No errors. |
| App\Entity\Common\Price | No errors. |
| App\Entity\Cart\CartItem | No errors. |
| App\Entity\Product\Category | No errors. |
| App\Entity\Common\Files\CategoryBanner | No errors. |
| App\Entity\Product\Object\CommonProduct | No errors. |
| App\Entity\Product\WarehouseStock | No errors. |
| App\Entity\Product\Object\BaseProduct | No errors. |