https://prozili.greendot.cz/diskuse

Query Metrics

3 Database Queries
3 Different statements
1.77 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.31 ms
(73.82%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15 FROM p_category t0 WHERE t0.has_comments = ?
Parameters:
[
  1
]
0.25 ms
(14.16%)
1
SELECT t0.id AS id_1, t0.mail AS mail_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.surname AS surname_6, t0.title AS title_7, t0.street AS street_8, t0.city AS city_9, t0.zip AS zip_10, t0.phone AS phone_11, t0.country AS country_12, t0.company AS company_13, t0.ic AS ic_14, t0.dic AS dic_15, t0.ship_name AS ship_name_16, t0.ship_surname AS ship_surname_17, t0.ship_company AS ship_company_18, t0.ship_street AS ship_street_19, t0.ship_city AS ship_city_20, t0.ship_zip AS ship_zip_21, t0.ship_country AS ship_country_22, t0.orders AS orders_23 FROM client t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.21 ms
(12.02%)
1
SELECT t0.id AS id_1, t0.content AS content_2, t0.title AS title_3, t0.submitted AS submitted_4, t0.is_admin AS is_admin_5, t0.client_id AS client_id_6, t0.category_id AS category_id_7, t0.comment_id AS comment_id_8 FROM comment t0 WHERE t0.comment_id IS NULL ORDER BY t0.submitted DESC LIMIT 3
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.

Entities Mapping

Class Mapping errors
App\Entity\Web\Category No errors.
App\Entity\Web\Comment
  • The association App\Entity\Web\Comment#client refers to the inverse side field App\Entity\Client#comments which does not exist.
App\Entity\Web\Label No errors.
App\Entity\Web\CategoryFile
  • The mappings App\Entity\Web\CategoryFile#file and App\Entity\Web\File#categoryFiles are inconsistent with each other.
App\Entity\Web\CategoryCategory No errors.
App\Entity\Client No errors.
App\Entity\Web\File
  • The association App\Entity\Web\File#categoryFiles refers to the owning side field App\Entity\Web\CategoryFile#File which does not exist.