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

Query Metrics

20 Database Queries
6 Different statements
18.11 ms Query time
0 Invalid entities
112 Managed entities

Queries

Group similar statements

# Time Info
1 0.93 ms
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
]
2 0.74 ms
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
]
3 0.97 ms
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%"
]
4 1.96 ms
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%"
]
5 0.93 ms
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%"
]
6 0.74 ms
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
]
7 1.58 ms
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:
[
  43
]
8 0.85 ms
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:
[
  79
]
9 0.72 ms
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:
[
  82
]
10 0.84 ms
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:
[
  105
]
11 0.65 ms
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:
[
  113
]
12 0.67 ms
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:
[
  122
]
13 0.86 ms
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:
[
  154
]
14 0.68 ms
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:
[
  159
]
15 0.74 ms
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:
[
  181
]
16 0.96 ms
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:
[
  182
]
17 0.88 ms
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:
[
  183
]
18 0.93 ms
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:
[
  184
]
19 0.74 ms
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:
[
  186
]
20 0.75 ms
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:
[
  191
]

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\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\JurisprudenceCategory No errors.
App\Entity\Lexique No errors.