Query Metrics
52
Database Queries
10
Different statements
59.80 ms
Query time
0
Invalid entities
127
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
21.58 ms (36.09%) |
15 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.content AS content_4, t0.chapo AS chapo_5, t0.created_at AS created_at_6, t0.pdf AS pdf_7, t0.pinned AS pinned_8, t0.category_id AS category_id_9, t0.author_id AS author_id_10 FROM tuto t0 INNER JOIN tutos_keywords ON t0.id = tutos_keywords.tuto_id WHERE tutos_keywords.keywords_id = ?
Parameters:
[
23
]
|
|
15.14 ms (25.32%) |
15 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.content AS content_4, t0.chapo AS chapo_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.date AS date_8, t0.pdf AS pdf_9, t0.quality AS quality_10, t0.justice_court AS justice_court_11, t0.rg AS rg_12, t0.important AS important_13, t0.pinned AS pinned_14, t0.author_id AS author_id_15 FROM jurisprudence t0 INNER JOIN jp_keywords ON t0.id = jp_keywords.jurisprudence_id WHERE jp_keywords.keywords_id = ?
Parameters:
[
23
]
|
|
9.73 ms (16.27%) |
15 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.content AS content_4, t0.chapo AS chapo_5, t0.created_at AS created_at_6, t0.pdf AS pdf_7, t0.pinned AS pinned_8, t0.author_id AS author_id_9, t0.category_id AS category_id_10 FROM news t0 INNER JOIN news_keywords ON t0.id = news_keywords.news_id WHERE news_keywords.keywords_id = ?
Parameters:
[
23
]
|
|
7.08 ms (11.85%) |
1 |
SELECT t0_.id AS id_0, t0_.active AS active_1, t0_.title AS title_2, t0_.content AS content_3, t0_.chapo AS chapo_4, t0_.created_at AS created_at_5, t0_.pdf AS pdf_6, t0_.pinned AS pinned_7, t0_.category_id AS category_id_8, t0_.author_id AS author_id_9 FROM tuto t0_ WHERE t0_.active = ? AND t0_.title LIKE ? ORDER BY t0_.created_at DESC
Parameters:
[ 1 "%TA%" ] |
|
1.45 ms (2.43%) |
1 |
SELECT j0_.id AS id_0, j0_.active AS active_1, j0_.name AS name_2, j0_.content AS content_3, j0_.chapo AS chapo_4, j0_.created_at AS created_at_5, j0_.updated_at AS updated_at_6, j0_.date AS date_7, j0_.pdf AS pdf_8, j0_.quality AS quality_9, j0_.justice_court AS justice_court_10, j0_.rg AS rg_11, j0_.important AS important_12, j0_.pinned AS pinned_13, j0_.author_id AS author_id_14 FROM jurisprudence j0_ WHERE j0_.active = ? AND j0_.name LIKE ? ORDER BY j0_.created_at DESC
Parameters:
[ 1 "%TA%" ] |
|
1.07 ms (1.79%) |
1 |
SELECT j0_.id AS id_0, j0_.active AS active_1, j0_.name AS name_2, j0_.content AS content_3, j0_.chapo AS chapo_4, j0_.created_at AS created_at_5, j0_.updated_at AS updated_at_6, j0_.date AS date_7, j0_.pdf AS pdf_8, j0_.quality AS quality_9, j0_.justice_court AS justice_court_10, j0_.rg AS rg_11, j0_.important AS important_12, j0_.pinned AS pinned_13, j0_.author_id AS author_id_14 FROM jurisprudence j0_ WHERE j0_.active = ? AND j0_.rg LIKE ? ORDER BY j0_.created_at DESC
Parameters:
[ 1 "%TA%" ] |
|
1.02 ms (1.71%) |
1 |
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name AS name_3, t0.color AS color_4, t0.position AS position_5, t0.created_at AS created_at_6 FROM news_category t0 WHERE t0.enabled = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
|
0.97 ms (1.62%) |
1 |
SELECT n0_.id AS id_0, n0_.active AS active_1, n0_.title AS title_2, n0_.content AS content_3, n0_.chapo AS chapo_4, n0_.created_at AS created_at_5, n0_.pdf AS pdf_6, n0_.pinned AS pinned_7, n0_.author_id AS author_id_8, n0_.category_id AS category_id_9 FROM news n0_ WHERE n0_.active = ? AND n0_.title LIKE ? ORDER BY n0_.created_at DESC
Parameters:
[ 1 "%TA%" ] |
|
0.96 ms (1.61%) |
1 |
SELECT k0_.id AS id_0, k0_.keyword AS keyword_1, k0_.created_at AS created_at_2, k0_.similar AS similar_3 FROM keywords k0_ WHERE k0_.keyword LIKE ?
Parameters:
[
"%TA%"
]
|
|
0.78 ms (1.31%) |
1 |
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name AS name_3, t0.color AS color_4, t0.position AS position_5, t0.created_at AS created_at_6 FROM la_base_category t0 WHERE t0.enabled = ? ORDER BY t0.position ASC
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Jurisprudence | 84 |
| App\Entity\Keywords | 15 |
| App\Entity\Tuto | 10 |
| App\Entity\News | 5 |
| App\Entity\User | 5 |
| App\Entity\NewsCategory | 4 |
| App\Entity\LaBaseCategory | 4 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\NewsCategory | No errors. |
| App\Entity\LaBaseCategory | No errors. |
| App\Entity\Keywords | No errors. |
| App\Entity\News | No errors. |
| App\Entity\Tuto | No errors. |
| App\Entity\Jurisprudence | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Lexique | No errors. |
| App\Entity\JurisprudenceCategory | No errors. |