https://cirad.dev-djaka.fr/ressources-documentaires

Query Metrics

103 Database Queries
11 Different statements
33.32 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
15.90 ms
(47.72%)
44
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.timecode AS timecode_4, t0.duration AS duration_5, t0.article_id AS article_id_6, t7.id AS id_8, t7.slug AS slug_9, t7.position AS position_10, t7.meta_description AS meta_description_11, t7.status AS status_12, t7.created_at AS created_at_13, t7.updated_at AS updated_at_14, t7.video_poster_id AS video_poster_id_15, t7.category_id AS category_id_16, t7.video_id AS video_id_17 FROM video_marker t0 INNER JOIN article t7 ON t0.article_id = t7.id INNER JOIN video_markers__attachments ON t0.id = video_markers__attachments.video_marker_id WHERE video_markers__attachments.attachment_id = ?
Parameters:
[
  14
]
11.24 ms
(33.74%)
34
SELECT t0.id AS id_1, t0.title AS title_2, t0.src AS src_3, t0.description AS description_4, t0.mime AS mime_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM media t0 INNER JOIN video_markers__attachments ON t0.id = video_markers__attachments.attachment_id WHERE video_markers__attachments.video_marker_id = ?
Parameters:
[
  6
]
1.46 ms
(4.39%)
6
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.slug AS slug_3, c0_.parent_id AS parent_id_4 FROM category c0_ WHERE c0_.slug = ?
Parameters:
[
  "enjeux-fonciers"
]
1.14 ms
(3.43%)
5
SELECT t0.id AS id_1, t0.title AS title_2, t0.src AS src_3, t0.description AS description_4, t0.mime AS mime_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM media t0 WHERE t0.id IN (?)
Parameters:
[
  32
]
0.84 ms
(2.52%)
4
SELECT COUNT(*) FROM article t0 WHERE t0.category_id = ?
Parameters:
[
  1
]
0.58 ms
(1.74%)
2
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.position AS position_2, a0_.meta_description AS meta_description_3, a0_.status AS status_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.video_poster_id AS video_poster_id_7, a0_.category_id AS category_id_8, a0_.video_id AS video_id_9 FROM article a0_ WHERE a0_.status = 1 AND a0_.category_id = 2
Parameters:
[]
0.51 ms
(1.54%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM category t0
Parameters:
[]
0.51 ms
(1.54%)
2
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.position AS position_2, a0_.meta_description AS meta_description_3, a0_.status AS status_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.video_poster_id AS video_poster_id_7, a0_.category_id AS category_id_8, a0_.video_id AS video_id_9 FROM article a0_ WHERE a0_.status = 1 AND a0_.category_id = 1
Parameters:
[]
0.47 ms
(1.41%)
2
SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.position AS position_2, a0_.meta_description AS meta_description_3, a0_.status AS status_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.video_poster_id AS video_poster_id_7, a0_.category_id AS category_id_8, a0_.video_id AS video_id_9 FROM article a0_ WHERE a0_.status = 1 AND a0_.category_id = 4
Parameters:
[]
0.42 ms
(1.27%)
1
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.src AS src_2, m0_.description AS description_3, m0_.mime AS mime_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6 FROM media m0_ WHERE m0_.mime LIKE ?
Parameters:
[
  "%application/%"
]
0.23 ms
(0.70%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.src AS src_3, t0.description AS description_4, t0.mime AS mime_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM media t0 WHERE t0.id IN (?, ?)
Parameters:
[
  35
  48
]

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\Category No errors.
App\Entity\Article No errors.
App\Entity\Media
  • The field App\Entity\Media#markers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\VideoMarker#attachments does not contain the required 'inversedBy="markers"' attribute.
  • The field App\Entity\Media#articles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Article#video does not contain the required 'inversedBy="articles"' attribute.
App\Entity\VideoMarker No errors.
App\Entity\MediaMetaTag No errors.
App\Entity\Comment No errors.
App\Entity\Tag No errors.