GET https://webtest.targetmedia.cz/kosik

Query Metrics

4 Database Queries
4 Different statements
3.44 ms Query time
0 Invalid entities
21 Managed entities

Queries

Group similar statements

# Time Info
1 1.38 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.58 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"
]
3 0.42 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"
]
4 1.06 ms
SELECT t0.id AS id_1, t0.hidden AS hidden_2, t0.hidden_by AS hidden_by_3, t0.eshop_packagetype_id AS eshop_packagetype_id_4, t0.packagetype_id AS packagetype_id_5 FROM eshop_packagetype_links t0 WHERE t0.hidden = ?
Parameters:
[
  "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 5

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\Basket No errors.
App\Entity\EshopPackageTypeLink No errors.
App\Entity\EshopPackageType No errors.
App\Entity\Packagetype No errors.