https://my-audio-api.server-preprod.ovh/articles?limit=200

Query Metrics

127 Database Queries
4 Different statements
119.16 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
79.87 ms
(67.03%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.subtitle AS subtitle_2, a0_.creation_date AS creation_date_3, a0_.publication_date AS publication_date_4, a0_.source AS source_5, a0_.img_url AS img_url_6, a0_.texte AS texte_7, a0_.extrait AS extrait_8, a0_.is_pro AS is_pro_9, a0_.etat AS etat_10, a0_.slug AS slug_11, a0_.is_public AS is_public_12, a0_.external_link AS external_link_13, a0_.external_id AS external_id_14, a0_.id_admin_id AS id_admin_id_15, a0_.user_id AS user_id_16 FROM article a0_ WHERE a0_.is_pro IN (?) AND a0_.etat = ? ORDER BY a0_.publication_date DESC LIMIT 200
Parameters:
[
  [
    0
    2
  ]
  0
]
19.56 ms
(16.42%)
61
SELECT t0.id AS id_1, t0.id_article_id AS id_article_id_2, t0.id_categorie_id AS id_categorie_id_3 FROM article_categorie t0 WHERE t0.id_article_id = ?
Parameters:
[
  316
]
18.27 ms
(15.33%)
61
SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.birthdate AS birthdate_4, t0.mail AS mail_5, t0.password AS password_6, t0.pin AS pin_7, t0.id_profil_id AS id_profil_id_8 FROM administrateur t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  4
]
1.46 ms
(1.22%)
4
SELECT t0.id AS id_1, t0.title AS title_2 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
  8
]

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\Article No errors.
App\Entity\Administrateur No errors.
App\Entity\AccessControl\AccessUser No errors.
App\Entity\ArticleCategorie No errors.
App\Entity\ArticleTag No errors.
App\Entity\Categorie No errors.
App\Entity\PageCategorie No errors.
App\Entity\Profil No errors.
App\Entity\FAQ No errors.
App\Entity\Token No errors.
App\Entity\Page No errors.