Query Metrics
22
Database Queries
14
Different statements
21.32 ms
Query time
0
Invalid entities
38
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
7.42 ms (34.78%) |
1 |
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 ]
|
||||||||||||||||||||||||||||||||||
|
5.83 ms (27.36%) |
1 |
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 ]
|
||||||||||||||||||||||||||||||||||
|
1.29 ms (6.06%) |
3 |
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 ]
|
||||||||||||||||||||||||||||||||||
|
1.24 ms (5.83%) |
1 |
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:
[]
|
||||||||||||||||||||||||||||||||||
|
1.16 ms (5.42%) |
2 |
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"
]
|
||||||||||||||||||||||||||||||||||
|
0.91 ms (4.27%) |
2 |
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
]
|
||||||||||||||||||||||||||||||||||
|
0.86 ms (4.04%) |
3 |
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" ]
|
||||||||||||||||||||||||||||||||||
|
0.69 ms (3.26%) |
3 |
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
]
|
||||||||||||||||||||||||||||||||||
|
0.43 ms (2.04%) |
1 |
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"
]
|
||||||||||||||||||||||||||||||||||
|
0.36 ms (1.70%) |
1 |
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" ] |
||||||||||||||||||||||||||||||||||
|
0.35 ms (1.64%) |
1 |
SELECT * FROM eshop_settings LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
|
0.31 ms (1.45%) |
1 |
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"
]
|
||||||||||||||||||||||||||||||||||
|
0.26 ms (1.21%) |
1 |
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" ]
|
||||||||||||||||||||||||||||||||||
|
0.20 ms (0.93%) |
1 |
SELECT t0.id AS id_1, t0.storage_id AS storage_id_2 FROM sys_documentseries t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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. |