GET https://dev.beescom.fr/smbva/public/thematique/alimentation-en-eau-potable

Query Metrics

6 Database Queries
6 Different statements
32.80 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 8.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.teasing AS teasing_4, t0.filename AS filename_5, t0.profile_filename AS profile_filename_6, t0.slug AS slug_7, t0.position AS position_8, t0.alt_cover_image AS alt_cover_image_9, t0.legend_cover_image AS legend_cover_image_10 FROM thematic t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "alimentation-en-eau-potable"
]
2 13.26 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.teasing AS teasing_2, s0_.description AS description_3, s0_.context AS context_4, s0_.filename AS filename_5, s0_.objective AS objective_6, s0_.public AS public_7, s0_.holder AS holder_8, s0_.partner AS partner_9, s0_.indicator AS indicator_10, s0_.cost AS cost_11, s0_.animation AS animation_12, s0_.sector AS sector_13, s0_.sage AS sage_14, s0_.priority AS priority_15, s0_.slug AS slug_16, s0_.position AS position_17, s0_.alt_image AS alt_image_18, s0_.legend_image AS legend_image_19 FROM smbvaaction s0_ LEFT JOIN smbvaaction_thematic s2_ ON s0_.id = s2_.smbvaaction_id LEFT JOIN thematic t1_ ON t1_.id = s2_.thematic_id WHERE t1_.id = ? AND s0_.priority = ? LIMIT 1
Parameters:
[
  2
  1
]
3 1.07 ms
SELECT t0_.name AS name_0, t0_.profile_filename AS profile_filename_1, t0_.slug AS slug_2 FROM thematic t0_ ORDER BY t0_.position ASC
Parameters:
[]
4 3.54 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.thematic_id AS thematic_id_5 FROM picture_thematique t0 WHERE t0.thematic_id = ?
Parameters:
[
  2
]
5 4.86 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM tags t0 INNER JOIN smbvaaction_tags ON t0.id = smbvaaction_tags.tags_id WHERE smbvaaction_tags.smbvaaction_id = ?
Parameters:
[
  5
]
6 1.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.teasing AS teasing_3, t0.description AS description_4, t0.context AS context_5, t0.filename AS filename_6, t0.objective AS objective_7, t0.public AS public_8, t0.holder AS holder_9, t0.partner AS partner_10, t0.indicator AS indicator_11, t0.cost AS cost_12, t0.animation AS animation_13, t0.sector AS sector_14, t0.sage AS sage_15, t0.priority AS priority_16, t0.slug AS slug_17, t0.position AS position_18, t0.alt_image AS alt_image_19, t0.legend_image AS legend_image_20 FROM smbvaaction t0 INNER JOIN smbvaaction_thematic ON t0.id = smbvaaction_thematic.smbvaaction_id WHERE smbvaaction_thematic.thematic_id = ?
Parameters:
[
  2
]

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\Thematic No errors.
App\Entity\PictureThematique No errors.
App\Entity\SMBVAAction No errors.
App\Entity\ActionStep No errors.
App\Entity\Tags No errors.