https://ws.greendot.cz/

Query Metrics

2 Database Queries
2 Different statements
1.58 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.36 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14 FROM p_category p0_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p0_.id > 10 AND p0_.is_menu = 1 AND p1_.id IS NULL ORDER BY p0_.sequence ASC
Parameters:
[]
2 0.22 ms
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.id = ? LIMIT 1
Parameters:
[
  1
]

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\CategoryCategory No errors.
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\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\ContactMessage No errors.