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

Query Metrics

8 Database Queries
5 Different statements
2.50 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.87 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:
[
  "22"
]
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:
[
  22
]
3 0.27 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:
[
  22
]
4 0.23 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.comment_id = ?
Parameters:
[
  2
]
5 0.25 ms
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
]
6 0.19 ms
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:
[
  2
]
7 0.24 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.comment_id = ?
Parameters:
[
  6
]
8 0.17 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.comment_id = ?
Parameters:
[
  7
]

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.
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.