GET https://cajo-test.squat.net/chercher?search=TA

Query Metrics

52 Database Queries
10 Different statements
59.80 ms Query time
0 Invalid entities
127 Managed entities

Grouped Statements

Show all queries

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.