GET https://webtest.targetmedia.cz/detail/svetle/casparus-10

Query Metrics

22 Database Queries
14 Different statements
21.32 ms Query time
0 Invalid entities
38 Managed entities

Queries

Group similar statements

# Time Info
1 1.24 ms
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.last_update AS last_update_3, t0.ip AS ip_4, t0.firms_id AS firms_id_5 FROM eshop_logins t0 WHERE t0.session_id IS NULL LIMIT 1
Parameters:
[]
2 0.64 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.posindex AS posindex_2, e0_.web_link AS web_link_3, e0_.hidden AS hidden_4, e0_.hidden_by AS hidden_by_5, e0_.parent_id AS parent_id_6, e0_.description AS description_7, e0_.show_on_caption AS show_on_caption_8, e1_.id AS id_9, e1_.name AS name_10, e1_.posindex AS posindex_11, e1_.web_link AS web_link_12, e1_.hidden AS hidden_13, e1_.hidden_by AS hidden_by_14, e1_.parent_id AS parent_id_15, e1_.description AS description_16, e1_.show_on_caption AS show_on_caption_17, e0_.parent_id AS parent_id_18, e1_.parent_id AS parent_id_19 FROM eshop_categories e0_ INNER JOIN eshop_categories e1_ ON e0_.parent_id = e1_.id WHERE e0_.web_link = ?
Parameters:
[
  "svetle"
]
3 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.web_link AS web_link_3, t0.hidden AS hidden_4, t0.description AS description_5, t0.available AS available_6, t0.product_show AS product_show_7, t0.sale AS sale_8, t0.sale_percentual AS sale_percentual_9, t0.topselling AS topselling_10, t0.new AS new_11, t0.recommended AS recommended_12, t0.eshop_category_id AS eshop_category_id_13, t0.slozeni AS slozeni_14, t0.leg_oznaceni AS leg_oznaceni_15, t0.slady AS slady_16, t0.chmele AS chmele_17, t0.kvasnice AS kvasnice_18, t0.epm AS epm_19, t0.ibu AS ibu_20, t0.alkohol AS alkohol_21, t0.pivni_styl AS pivni_styl_22, t0.pivni_styl_weblink AS pivni_styl_weblink_23, t0.eshop_category_id AS eshop_category_id_24 FROM eshop_products t0 WHERE t0.eshop_category_id = ?
Parameters:
[
  11
]
4 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.web_link AS web_link_3, t0.hidden AS hidden_4, t0.description AS description_5, t0.available AS available_6, t0.product_show AS product_show_7, t0.sale AS sale_8, t0.sale_percentual AS sale_percentual_9, t0.topselling AS topselling_10, t0.new AS new_11, t0.recommended AS recommended_12, t0.eshop_category_id AS eshop_category_id_13, t0.slozeni AS slozeni_14, t0.leg_oznaceni AS leg_oznaceni_15, t0.slady AS slady_16, t0.chmele AS chmele_17, t0.kvasnice AS kvasnice_18, t0.epm AS epm_19, t0.ibu AS ibu_20, t0.alkohol AS alkohol_21, t0.pivni_styl AS pivni_styl_22, t0.pivni_styl_weblink AS pivni_styl_weblink_23, t0.eshop_category_id AS eshop_category_id_24 FROM eshop_products t0 WHERE t0.eshop_category_id = ?
Parameters:
[
  18
]
5 0.36 ms
SELECT 
                p.*
            FROM eshop_products p
                INNER JOIN eshop_products2 p2s ON p.id = p2s.parent_id
            WHERE p.hidden = ?
              AND p.product_show = ?
              AND p2s.hidden = ?
              AND p2s.web_link = ?
Parameters:
[
  "1000-01-01 00:00:00"
  "Y"
  "1000-01-01 00:00:00"
  "casparus-10"
]
6 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.posindex AS posindex_3, t0.web_link AS web_link_4, t0.hidden AS hidden_5, t0.hidden_by AS hidden_by_6, t0.parent_id AS parent_id_7, t0.description AS description_8, t0.show_on_caption AS show_on_caption_9, t10.id AS id_11, t10.name AS name_12, t10.web_link AS web_link_13, t10.hidden AS hidden_14, t10.description AS description_15, t10.available AS available_16, t10.product_show AS product_show_17, t10.sale AS sale_18, t10.sale_percentual AS sale_percentual_19, t10.topselling AS topselling_20, t10.new AS new_21, t10.recommended AS recommended_22, t10.eshop_category_id AS eshop_category_id_23, t10.slozeni AS slozeni_24, t10.leg_oznaceni AS leg_oznaceni_25, t10.slady AS slady_26, t10.chmele AS chmele_27, t10.kvasnice AS kvasnice_28, t10.epm AS epm_29, t10.ibu AS ibu_30, t10.alkohol AS alkohol_31, t10.pivni_styl AS pivni_styl_32, t10.pivni_styl_weblink AS pivni_styl_weblink_33, t10.eshop_category_id AS eshop_category_id_34, t0.parent_id AS parent_id_35 FROM eshop_categories t0 LEFT JOIN eshop_products t10 ON t10.eshop_category_id = t0.id WHERE t0.hidden = ? ORDER BY t0.posindex ASC
Parameters:
[
  "1000-01-01 00:00:00"
]
7 0.51 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.posindex AS posindex_2, e0_.web_link AS web_link_3, e0_.hidden AS hidden_4, e0_.hidden_by AS hidden_by_5, e0_.parent_id AS parent_id_6, e0_.description AS description_7, e0_.show_on_caption AS show_on_caption_8, e1_.id AS id_9, e1_.name AS name_10, e1_.posindex AS posindex_11, e1_.web_link AS web_link_12, e1_.hidden AS hidden_13, e1_.hidden_by AS hidden_by_14, e1_.parent_id AS parent_id_15, e1_.description AS description_16, e1_.show_on_caption AS show_on_caption_17, e0_.parent_id AS parent_id_18, e1_.parent_id AS parent_id_19 FROM eshop_categories e0_ INNER JOIN eshop_categories e1_ ON e0_.parent_id = e1_.id WHERE e0_.web_link = ?
Parameters:
[
  "svetle"
]
8 0.31 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.posindex AS posindex_2, e0_.web_link AS web_link_3, e0_.hidden AS hidden_4, e0_.hidden_by AS hidden_by_5, e0_.parent_id AS parent_id_6, e0_.description AS description_7, e0_.show_on_caption AS show_on_caption_8, e0_.id AS id_9, e0_.name AS name_10, e0_.posindex AS posindex_11, e0_.web_link AS web_link_12, e0_.hidden AS hidden_13, e0_.hidden_by AS hidden_by_14, e0_.parent_id AS parent_id_15, e0_.description AS description_16, e0_.show_on_caption AS show_on_caption_17, e0_.parent_id AS parent_id_18 FROM eshop_categories e0_ INNER JOIN eshop_categories e1_ ON e0_.id = e1_.parent_id WHERE e0_.web_link = ?
Parameters:
[
  "svetle"
]
9 0.35 ms
SELECT * FROM eshop_settings LIMIT 1
Parameters:
[]
10 7.42 ms
SELECT t0.minimal_product_price_with_vat AS minimal_product_price_with_vat_1, t0.minimal_product_price_without_vat AS minimal_product_price_without_vat_2, t0.product2_id AS product2_id_3, t0.product_id AS product_id_4, t0.product_name AS product_name_5, t0.product_web_link AS product_web_link_6, t0.product_description AS product_description_7, t0.product_available AS product_available_8, t0.product_show AS product_show_9, t0.product_sale AS product_sale_10, t0.product_sale_percentual AS product_sale_percentual_11, t0.product_topselling AS product_topselling_12, t0.product_new AS product_new_13, t0.product_recommended AS product_recommended_14, t0.product_eshop_category_id AS product_eshop_category_id_15, t0.product_pricelist_id AS product_pricelist_id_16, t0.beertype_name AS beertype_name_17, t0.packagetype_id AS packagetype_id_18, t0.packagetype_name AS packagetype_name_19, t0.product_pricelist_name AS product_pricelist_name_20, t0.product_pricelist_withvat AS product_pricelist_withvat_21, t0.beerkegprice AS beerkegprice_22, t0.product_has_cover_image AS product_has_cover_image_23, t0.product_cover_image_filename AS product_cover_image_filename_24, t0.product_cover_image_generatedfilename AS product_cover_image_generatedfilename_25, t0.product_eshop_category_name AS product_eshop_category_name_26, t0.product_eshop_category_web_link AS product_eshop_category_web_link_27, t0.product_eshop_main_category_name AS product_eshop_main_category_name_28, t0.product_eshop_main_category_web_link AS product_eshop_main_category_web_link_29, t0.price_amount AS price_amount_30, t0.price_amount_without_vat AS price_amount_without_vat_31, t0.product_epm AS product_epm_32, t0.product_ibu AS product_ibu_33, t0.product_alkohol AS product_alkohol_34, t0.product_chmele AS product_chmele_35, t0.product_kvasnice AS product_kvasnice_36, t0.product_slozeni AS product_slozeni_37, t0.product_slady AS product_slady_38, t0.product_leg_oznaceni AS product_leg_oznaceni_39, t0.storecard_id AS storecard_id_40, t0.packagetype_capacity AS packagetype_capacity_41, t0.beertype_epm AS beertype_epm_42, t0.product2_available AS product2_available_43, t0.storecard_name AS storecard_name_44 FROM w_eshop_products t0 WHERE t0.product_web_link = ? AND t0.product_pricelist_id = ? LIMIT 1
Parameters:
[
  "casparus-10"
  43
]
11 5.83 ms
SELECT t0.product2_id AS product2_id_1, t0.product_id AS product_id_2, t0.product_name AS product_name_3, t0.product_web_link AS product_web_link_4, t0.product_description AS product_description_5, t0.product_available AS product_available_6, t0.product_show AS product_show_7, t0.product_sale AS product_sale_8, t0.product_sale_percentual AS product_sale_percentual_9, t0.product_topselling AS product_topselling_10, t0.product_new AS product_new_11, t0.product_recommended AS product_recommended_12, t0.product_eshop_category_id AS product_eshop_category_id_13, t0.product_pricelist_id AS product_pricelist_id_14, t0.beertype_name AS beertype_name_15, t0.packagetype_id AS packagetype_id_16, t0.packagetype_name AS packagetype_name_17, t0.product_pricelist_name AS product_pricelist_name_18, t0.product_pricelist_withvat AS product_pricelist_withvat_19, t0.beerkegprice AS beerkegprice_20, t0.product_has_cover_image AS product_has_cover_image_21, t0.product_cover_image_filename AS product_cover_image_filename_22, t0.product_cover_image_generatedfilename AS product_cover_image_generatedfilename_23, t0.product_eshop_category_name AS product_eshop_category_name_24, t0.product_eshop_category_web_link AS product_eshop_category_web_link_25, t0.product_eshop_main_category_name AS product_eshop_main_category_name_26, t0.product_eshop_main_category_web_link AS product_eshop_main_category_web_link_27, t0.price_amount AS price_amount_28, t0.price_amount_without_vat AS price_amount_without_vat_29, t0.product_epm AS product_epm_30, t0.product_ibu AS product_ibu_31, t0.product_alkohol AS product_alkohol_32, t0.product_chmele AS product_chmele_33, t0.product_kvasnice AS product_kvasnice_34, t0.product_slozeni AS product_slozeni_35, t0.product_slady AS product_slady_36, t0.product_leg_oznaceni AS product_leg_oznaceni_37, t0.storecard_id AS storecard_id_38, t0.packagetype_capacity AS packagetype_capacity_39, t0.beertype_epm AS beertype_epm_40, t0.product2_available AS product2_available_41, t0.storecard_name AS storecard_name_42 FROM w_eshop_product_detail t0 WHERE t0.product_web_link = ? AND t0.product_pricelist_id = ?
Parameters:
[
  "casparus-10"
  43
]
12 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.generated_name AS generated_name_3, t0.table_name AS table_name_4, t0.table_id AS table_id_5, t0.posindex AS posindex_6, t0.hidden AS hidden_7, t0.table_id AS table_id_8, t0.table_id AS table_id_9 FROM sys_media t0 WHERE ((t0.table_name = ? AND t0.hidden = ?) AND t0.table_id = ?) ORDER BY t0.posindex ASC
Parameters:
[
  "eshop_products2"
  "1000-01-01 00:00:00"
  "19"
]
13 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.generated_name AS generated_name_3, t0.table_name AS table_name_4, t0.table_id AS table_id_5, t0.posindex AS posindex_6, t0.hidden AS hidden_7, t0.table_id AS table_id_8, t0.table_id AS table_id_9 FROM sys_media t0 WHERE ((t0.table_name = ? AND t0.hidden = ?) AND t0.table_id = ?) ORDER BY t0.posindex ASC
Parameters:
[
  "eshop_products2"
  "1000-01-01 00:00:00"
  "20"
]
14 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.generated_name AS generated_name_3, t0.table_name AS table_name_4, t0.table_id AS table_id_5, t0.posindex AS posindex_6, t0.hidden AS hidden_7, t0.table_id AS table_id_8, t0.table_id AS table_id_9 FROM sys_media t0 WHERE ((t0.table_name = ? AND t0.hidden = ?) AND t0.table_id = ?) ORDER BY t0.posindex ASC
Parameters:
[
  "eshop_products2"
  "1000-01-01 00:00:00"
  "21"
]
15 0.20 ms
SELECT t0.id AS id_1, t0.storage_id AS storage_id_2 FROM sys_documentseries t0 WHERE t0.id = ?
Parameters:
[
  3
]
16 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.beertype_id AS beertype_id_3, t0.packagetype_id AS packagetype_id_4, t0.packagetype_id AS packagetype_id_5, t0.beertype_id AS beertype_id_6, t0.vat_id AS vat_id_7 FROM sys_storecards t0 WHERE t0.id = ?
Parameters:
[
  571
]
17 0.73 ms
SELECT SUM(s0_.actual_qty) AS sclr_0 FROM sys_storagestocks s0_ WHERE s0_.storecard_id = ? AND s0_.storage_id = ? AND s0_.capacity = ? AND s0_.epm = ? GROUP BY s0_.storecard_id
Parameters:
[
  571
  2
  0.5
  10.0
]
18 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.beertype_id AS beertype_id_3, t0.packagetype_id AS packagetype_id_4, t0.packagetype_id AS packagetype_id_5, t0.beertype_id AS beertype_id_6, t0.vat_id AS vat_id_7 FROM sys_storecards t0 WHERE t0.id = ?
Parameters:
[
  569
]
19 0.29 ms
SELECT SUM(s0_.actual_qty) AS sclr_0 FROM sys_storagestocks s0_ WHERE s0_.storecard_id = ? AND s0_.storage_id = ? AND s0_.capacity = ? AND s0_.epm = ? GROUP BY s0_.storecard_id
Parameters:
[
  569
  2
  1.0
  10.0
]
20 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.beertype_id AS beertype_id_3, t0.packagetype_id AS packagetype_id_4, t0.packagetype_id AS packagetype_id_5, t0.beertype_id AS beertype_id_6, t0.vat_id AS vat_id_7 FROM sys_storecards t0 WHERE t0.id = ?
Parameters:
[
  560
]
21 0.27 ms
SELECT SUM(s0_.actual_qty) AS sclr_0 FROM sys_storagestocks s0_ WHERE s0_.storecard_id = ? AND s0_.storage_id = ? AND s0_.capacity = ? AND s0_.epm = ? GROUP BY s0_.storecard_id
Parameters:
[
  560
  2
  0.33
  10.0
]
22 0.26 ms
SELECT e0_.id AS id_0, e0_.session_id AS session_id_1, e0_.qty AS qty_2, e0_.eshop_product2_id AS eshop_product2_id_3 FROM eshop_basket e0_ INNER JOIN eshop_products2 e1_ ON e0_.eshop_product2_id = e1_.id WHERE e0_.session_id = ? AND e1_.hidden = ?
Parameters:
[
  null
  "1000-01-01 00:00:00"
]

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\Category 16
App\Entity\Product 7
App\Entity\ProductDetailView 3
App\Entity\Storecard 3
App\Entity\Packagetype 3
App\Entity\ProductView 1
App\Entity\Media 1
App\Entity\Product2 1
App\Entity\DocumentSeries 1
App\Entity\Beertype 1
App\Entity\Vat 1

Entities Mapping

Class Mapping errors
App\Entity\EshopLogin No errors.
App\Entity\Firm No errors.
App\Entity\Category No errors.
App\Entity\Product No errors.
App\Entity\Product2 No errors.
App\Entity\Image No errors.
App\Entity\ProductView No errors.
App\Entity\ProductDetailView No errors.
App\Entity\Media No errors.
App\Entity\DocumentSeries No errors.
App\Entity\Storecard No errors.
App\Entity\Packagetype No errors.
App\Entity\Beertype No errors.
App\Entity\Vat No errors.
App\Entity\Price No errors.
App\Entity\Storagestock No errors.
App\Entity\Basket No errors.