GET https://demo.blk.gr/en/blog/news

Query Metrics

316 Database Queries
13 Different statements
66.31 ms Query time
0 Invalid entities
390 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
42.62 ms
(64.27%)
250
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:
[
  "2"
  "en"
  "App\Entity\Article\ArticleCategory"
]
11.74 ms
(17.71%)
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_69d7597a127a66.85392026"
]
3.23 ms
(4.88%)
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
]
2.63 ms
(3.96%)
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
]
2.23 ms
(3.36%)
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 = ? ORDER BY t0.created_at DESC
Parameters:
[
  2
]
1.83 ms
(2.77%)
12
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.discr FROM app_file t0 WHERE t0.id = ? AND t0.discr IN ('article_image')
Parameters:
[
  65622
]
0.67 ms
(1.01%)
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.33 ms
(0.51%)
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.slug = ? LIMIT 1
Parameters:
[
  "news"
]
0.28 ms
(0.42%)
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.22 ms
(0.33%)
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.21 ms
(0.32%)
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>„á³aˆ ¡Ç³\tJ??"
]
0.18 ms
(0.28%)
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
]
0.13 ms
(0.20%)
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"
]

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\Article\Article 138
App\Entity\Common\Files\AppFile 137
App\Entity\Product\Category 84
App\Entity\Menu 28
App\Entity\Article\ArticleCategory 2
App\Entity\Cart\Cart 1