https://ws.greendot.cz/diskuse/detail-36

Query Metrics

3 Database Queries
3 Different statements
1.34 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.81 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 = ?
Parameters:
[
  "36"
]
2 0.28 ms
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.category_id = ? AND t0.comment_id IS NULL ORDER BY t0.submitted DESC
Parameters:
[
  36
]
3 0.25 ms
SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.title AS title_2, c0_.submitted AS submitted_3, c0_.is_admin AS is_admin_4, c0_.client_id AS client_id_5, c0_.category_id AS category_id_6, c0_.comment_id AS comment_id_7 FROM comment c0_ WHERE c0_.category_id = ? AND c0_.comment_id IS NOT NULL ORDER BY c0_.submitted ASC
Parameters:
[
  36
]

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