GET https://demo.blk.gr/en/blog/shipping-and-delivery/shipping-amp-delivery

Query Metrics

167 Database Queries
13 Different statements
52.29 ms Query time
0 Invalid entities
115 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
26.06 ms
(49.84%)
112
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:
[
  "508"
  "en"
  "App\Entity\Article\Article"
]
12.01 ms
(22.96%)
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_69d759dd0dd2a6.29057702"
]
7.12 ms
(13.61%)
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.49 ms
(6.68%)
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
]
1.22 ms
(2.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.47 ms
(0.90%)
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.33 ms
(0.63%)
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.30 ms
(0.57%)
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>ˆ‘‚h̸~/ô@‰/\e"
]
0.27 ms
(0.52%)
1
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:
[
  66291
]
0.27 ms
(0.51%)
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.27 ms
(0.51%)
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.27 ms
(0.51%)
1
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 INNER JOIN article_images ON t0.id = article_images.image_id WHERE article_images.article_id = ? AND t0.discr IN ('article_image')
Parameters:
[
  508
]
0.22 ms
(0.42%)
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.slug = ? LIMIT 1
Parameters:
[
  "shipping-amp-delivery"
]

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 1
App\Entity\Common\Files\AppFile 1
App\Entity\Cart\Cart 1