GET https://demo.blk.gr/el/wishlist

Response
200 OK
IP
216.73.216.136
Profiled on
Token
d1b3d5

Query Metrics

160 Database Queries
8 Different statements
39.69 ms Query time
0 Invalid entities
113 Managed entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
21.15 ms
(53.30%) 		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"
]
View formatted query    View runnable query    Explain query
12.16 ms
(30.64%) 		110 
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: 
[
  "1"
  "el"
  "App\Entity\Menu"
]
View formatted query    View runnable query    Explain query
3.34 ms
(8.42%) 		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
]
View formatted query    View runnable query    Explain query
2.04 ms
(5.13%) 		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
]
View formatted query    View runnable query    Explain query
0.44 ms
(1.12%) 		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"
]
View formatted query    View runnable query    Explain query
0.25 ms
(0.63%) 		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
]
View formatted query    View runnable query    Explain query
0.18 ms
(0.45%) 		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›"
]
View formatted query    View runnable query    Explain query
0.12 ms
(0.31%) 		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"
]
View formatted query    View runnable query    Explain query

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\Cart\Cart 1

Entities Mapping

Class Mapping 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\Menu No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
App\Entity\Product\Category No errors.
App\Entity\Common\Files\AppFile 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.