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

Queries

Group similar statements

# Time Info
1 0.75 ms
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"
]
2 0.73 ms
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
]
3 0.52 ms
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
]
4 0.47 ms
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:
[
  10
]
5 0.50 ms
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:
[
  11
]
6 0.47 ms
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:
[
  2
]
7 0.46 ms
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:
[
  3
]
8 0.48 ms
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:
[
  6
]
9 0.47 ms
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:
[
  4
]
10 0.50 ms
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:
[
  7
]
11 0.49 ms
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:
[
  8
]
12 0.62 ms
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
]
13 0.58 ms
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:
[
  11
]
14 0.58 ms
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
]
15 0.55 ms
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:
[
  11
]
16 0.89 ms
SELECT s0_.name AS name_0, s0_.value AS value_1 FROM setting s0_
Parameters:
[]
17 0.63 ms
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:
[
  3
]
18 0.46 ms
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:
[
  4
]
19 0.46 ms
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:
[
  6
]
20 0.36 ms
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:
[
  7
]
21 0.35 ms
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:
[
  8
]

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