GET https://dev.petso.halisz.pl/cennik

Query Metrics

21 Database Queries
6 Different statements
11.32 ms Query time
0 Invalid entities
32 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.36 ms
(38.52%)
9
SELECT t0.id AS id_1, t0.default_selected AS default_selected_2, t0.views AS views_3, t0.social_boost AS social_boost_4, t0.socialboost_price AS socialboost_price_5, t0.is_recommended AS is_recommended_6, t0.product_id AS product_id_7 FROM product_package_options t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
2.30 ms
(20.33%)
5
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_package_id AS product_package_id_3, t0.product_option_id AS product_option_id_4, t0.product_combination_id AS product_combination_id_5 FROM product_package_attribute t0 WHERE t0.product_package_id = ?
Parameters:
[
  10
]
2.29 ms
(20.20%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.value AS value_4, t0.enabled AS enabled_5, t0.product_id AS product_id_6 FROM product_combination t0 WHERE t0.product_id = ? ORDER BY t0.value ASC
Parameters:
[
  10
]
0.89 ms
(7.86%)
1
SELECT s0_.name AS name_0, s0_.value AS value_1 FROM setting s0_
Parameters:
[]
0.75 ms
(6.64%)
1
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.content AS content_3, s0_.active AS active_4, s0_.is_system_page AS is_system_page_5, s0_.template AS template_6, s0_.title AS title_7, s0_.meta_title AS meta_title_8, s0_.meta_keywords AS meta_keywords_9, s0_.meta_description AS meta_description_10, s0_.image_id AS image_id_11 FROM static_page s0_ WHERE s0_.active = 1 AND s0_.is_system_page = ? AND s0_.slug = ?
Parameters:
[
  1
  "cennik"
]
0.73 ms
(6.46%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.sku AS sku_3, p0_.type AS type_4, p0_.position AS position_5, p0_.enabled AS enabled_6 FROM product p0_ WHERE p0_.enabled = ? ORDER BY p0_.position ASC
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
App\Entity\ProductCombination 13
App\Entity\Product 9
App\Entity\ProductPackageAttribute 6
App\Entity\ProductPackageOptions 3
App\Entity\StaticPage 1

Entities Mapping