Query Metrics
8
Database Queries
5
Different statements
2.53 ms
Query time
3
Invalid entities
Queries
#▲ | 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.27 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.25 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.23 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.20 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.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:
[
6
]
|
8 | 0.21 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 |
|
App\Entity\Web\CategoryCategory | No errors. |
App\Entity\Web\Comment |
|
App\Entity\Client | No errors. |
App\Entity\Web\File |
|