GET https://crimino.psychofact.fr/notes

Query Metrics

11 Database Queries
4 Different statements
3.88 ms Query time
0 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 1.01 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.is_public AS is_public_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.name AS name_10, u1_.invite_token AS invite_token_11 FROM note n0_ LEFT JOIN `user` u1_ ON n0_.author_id = u1_.id WHERE n0_.is_public = 1 ORDER BY n0_.updated_at DESC) dctrn_result) dctrn_table
Parameters:
[]
2 0.62 ms
SELECT t0.config_key AS config_key_1, t0.config_value AS config_value_2 FROM config t0 WHERE t0.config_key = ?
Parameters:
[
  "color_primary"
]
3 0.21 ms
SELECT t0.config_key AS config_key_1, t0.config_value AS config_value_2 FROM config t0 WHERE t0.config_key = ?
Parameters:
[
  "color_header_start"
]
4 0.17 ms
SELECT t0.config_key AS config_key_1, t0.config_value AS config_value_2 FROM config t0 WHERE t0.config_key = ?
Parameters:
[
  "color_header_end"
]
5 0.24 ms
SELECT t0.config_key AS config_key_1, t0.config_value AS config_value_2 FROM config t0 WHERE t0.config_key = ?
Parameters:
[
  "site_name"
]
6 0.23 ms
SELECT t0.config_key AS config_key_1, t0.config_value AS config_value_2 FROM config t0 WHERE t0.config_key = ?
Parameters:
[
  "site_tagline"
]
7 0.24 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.invite_token AS invite_token_6 FROM `user` t0
Parameters:
[]
8 0.27 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.invite_token AS invite_token_6 FROM `user` t0
Parameters:
[]
9 0.23 ms
SELECT t0.config_key AS config_key_1, t0.config_value AS config_value_2 FROM config t0 WHERE t0.config_key = ?
Parameters:
[
  "site_description"
]
10 0.45 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7 FROM category t0
Parameters:
[]
11 0.21 ms
SELECT t0.config_key AS config_key_1, t0.config_value AS config_value_2 FROM config t0 WHERE t0.config_key = ?
Parameters:
[
  "site_name"
]

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\User 1

Entities Mapping

Class Mapping errors
App\Entity\Note No errors.
App\Entity\User No errors.
App\Entity\Config No errors.
App\Entity\Category No errors.