GET https://dev.elpokladny.cz/registrace

Query Metrics

258 Database Queries
7 Different statements
101.54 ms Query time
0 Invalid entities
115 Managed entities

Grouped Statements

Show all queries

Time Count Info
23.29 ms
(22.94%)
59
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN marketplace_includes ON t0.code = marketplace_includes.included_by WHERE marketplace_includes.code = ?
Parameters:
[
  10147
]
22.42 ms
(22.08%)
59
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN marketplace_excludes ON t0.code = marketplace_excludes.excluded_by WHERE marketplace_excludes.code = ?
Parameters:
[
  10147
]
21.97 ms
(21.64%)
59
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN marketplace_includes ON t0.code = marketplace_includes.code WHERE marketplace_includes.included_by = ?
Parameters:
[
  10147
]
21.93 ms
(21.60%)
59
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN marketplace_excludes ON t0.code = marketplace_excludes.code WHERE marketplace_excludes.excluded_by = ?
Parameters:
[
  10147
]
9.56 ms
(9.41%)
20
SELECT t0.code AS code_1, t0.sort_order AS sort_order_2, t0.hid AS hid_3, t0.choosable AS choosable_4, t0.name AS name_5, t0.description AS description_6, t0.text AS text_7, t0.price_excl_vat AS price_excl_vat_8, t0.price_incl_vat AS price_incl_vat_9, t0.price_description AS price_description_10, t0.created AS created_11, t0.changed AS changed_12, t0.ip AS ip_13 FROM marketplace t0 INNER JOIN company_variants_marketplace ON t0.code = company_variants_marketplace.marketplace WHERE company_variants_marketplace.variant = ?
Parameters:
[
  11
]
1.87 ms
(1.84%)
1
SELECT m0_.code AS code_0, m0_.sort_order AS sort_order_1, m0_.hid AS hid_2, m0_.name AS name_3, m0_.description AS description_4, m0_.text AS text_5, m0_.created AS created_6, m0_.changed AS changed_7, m0_.ip AS ip_8, m1_.code AS code_9, m1_.sort_order AS sort_order_10, m1_.hid AS hid_11, m1_.choosable AS choosable_12, m1_.name AS name_13, m1_.description AS description_14, m1_.text AS text_15, m1_.price_excl_vat AS price_excl_vat_16, m1_.price_incl_vat AS price_incl_vat_17, m1_.price_description AS price_description_18, m1_.created AS created_19, m1_.changed AS changed_20, m1_.ip AS ip_21 FROM marketplace_category m0_ LEFT JOIN marketplaces_categories m2_ ON m0_.code = m2_.category_code LEFT JOIN marketplace m1_ ON m1_.code = m2_.marketplace_code ORDER BY m0_.sort_order ASC, m1_.sort_order ASC
Parameters:
[]
0.50 ms
(0.50%)
1
SELECT t0.code AS code_1, t0.name AS name_2, t0.created AS created_3, t0.changed AS changed_4, t0.ip AS ip_5 FROM company_variants t0 ORDER BY t0.code ASC
Parameters:
[]

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\Marketplace 87
App\Entity\CompanyVariant 20
App\Entity\MarketplaceCategory 8

Entities Mapping

Class Mapping errors
App\Entity\MarketplaceCategory No errors.
App\Entity\Marketplace No errors.
App\Entity\CompanyVariant No errors.
App\Entity\User No errors.
App\Entity\MarketplaceCompany No errors.
App\Entity\Company No errors.