Query Metrics

11 Database Queries
11 Different statements
7.38 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.66 ms
(22.47%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.content AS content_3, a0_.slug AS slug_4, a0_.createdAt AS createdAt_5, a0_.lastUpdate AS lastUpdate_6, a0_.date AS date_7, a0_.isEnabled AS isEnabled_8, a0_.isOnFrontPage AS isOnFrontPage_9, a0_.isVisible AS isVisible_10, a0_.isDeleted AS isDeleted_11, a0_.youtube AS youtube_12, a0_.flickr AS flickr_13, a0_.URL AS URL_14, a0_.soundcloud AS soundcloud_15, a0_.updatedBy AS updatedBy_16, a0_.banner_id AS banner_id_17, a0_.category_id AS category_id_18, a0_.type_id AS type_id_19, a0_.user_id AS user_id_20, a0_.album_id AS album_id_21, a0_.biblio_id AS biblio_id_22 FROM articles a0_ LEFT JOIN picture p1_ ON a0_.banner_id = p1_.id LEFT JOIN articles_categories a2_ ON a0_.category_id = a2_.id LEFT JOIN articles_types a3_ ON a0_.type_id = a3_.id LEFT JOIN albums a4_ ON a0_.album_id = a4_.id LEFT JOIN biblios b5_ ON a0_.biblio_id = b5_.id WHERE a0_.id <> 24 AND a0_.date <= '2026-03-09 15:48:59' AND a0_.isEnabled = 1 ORDER BY a0_.date DESC LIMIT 6
Parameters:
[]
1.39 ms
(18.88%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content AS content_4, t0.slug AS slug_5, t0.createdAt AS createdAt_6, t0.lastUpdate AS lastUpdate_7, t0.date AS date_8, t0.isEnabled AS isEnabled_9, t0.isOnFrontPage AS isOnFrontPage_10, t0.isVisible AS isVisible_11, t0.isDeleted AS isDeleted_12, t0.youtube AS youtube_13, t0.flickr AS flickr_14, t0.URL AS URL_15, t0.soundcloud AS soundcloud_16, t0.updatedBy AS updatedBy_17, t0.banner_id AS banner_id_18, t19.target AS target_20, t19.thumbnailDir AS thumbnailDir_21, t19.hasThumbnail AS hasThumbnail_22, t19.id AS id_23, t19.pages AS pages_24, t19.downloads AS downloads_25, t19.reading AS reading_26, t19.name AS name_27, t19.dir AS dir_28, t19.source AS source_29, t19.size AS size_30, t19.is_enabled AS is_enabled_31, t19.is_deleted AS is_deleted_32, t19.last_update AS last_update_33, t19.created_at AS created_at_34, t19.formatSize AS formatSize_35, t19.mimetype AS mimetype_36, t0.category_id AS category_id_37, t38.id AS id_39, t38.name AS name_40, t38.slug AS slug_41, t38.description AS description_42, t38.banner_id AS banner_id_43, t0.type_id AS type_id_44, t45.id AS id_46, t45.name AS name_47, t45.slug AS slug_48, t0.user_id AS user_id_49, t50.id AS id_51, t50.fName AS fName_52, t50.lName AS lName_53, t50.phone AS phone_54, t50.createdAt AS createdAt_55, t50.lastLogin AS lastLogin_56, t50.password AS password_57, t50.token AS token_58, t50.sex AS sex_59, t50.isEnabled AS isEnabled_60, t50.email AS email_61, t50.profile_id AS profile_id_62, t0.album_id AS album_id_63, t64.id AS id_65, t64.title AS title_66, t64.isEnabled AS isEnabled_67, t0.biblio_id AS biblio_id_68, t69.id AS id_70, t69.title AS title_71, t69.isEnabled AS isEnabled_72 FROM articles t0 LEFT JOIN picture t19 ON t0.banner_id = t19.id LEFT JOIN articles_categories t38 ON t0.category_id = t38.id LEFT JOIN articles_types t45 ON t0.type_id = t45.id LEFT JOIN users t50 ON t0.user_id = t50.id LEFT JOIN albums t64 ON t0.album_id = t64.id LEFT JOIN biblios t69 ON t0.biblio_id = t69.id WHERE t0.id = ?
Parameters:
[
  "24"
]
1.16 ms
(15.76%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content AS content_4, t0.isEnabled AS isEnabled_5, t0.createdAt AS createdAt_6, t0.lastUpdate AS lastUpdate_7, t0.btn_text AS btn_text_8, t0.btn_link AS btn_link_9, t0.color AS color_10, t0.tasks AS tasks_11, t0.resume AS resume_12, t0.missions AS missions_13, t0.benefits AS benefits_14, t0.slug AS slug_15, t0.banner_id AS banner_id_16, t0.icon_id AS icon_id_17, t0.category_id AS category_id_18, t19.id AS id_20, t19.label AS label_21, t19.description AS description_22, t19.slug AS slug_23 FROM services t0 LEFT JOIN services_categories t19 ON t0.category_id = t19.id WHERE t0.isEnabled = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.68 ms
(9.24%)
1
SELECT t0.target AS target_1, t0.thumbnailDir AS thumbnailDir_2, t0.hasThumbnail AS hasThumbnail_3, t0.id AS id_4, t0.pages AS pages_5, t0.downloads AS downloads_6, t0.reading AS reading_7, t0.name AS name_8, t0.dir AS dir_9, t0.source AS source_10, t0.size AS size_11, t0.is_enabled AS is_enabled_12, t0.is_deleted AS is_deleted_13, t0.last_update AS last_update_14, t0.created_at AS created_at_15, t0.formatSize AS formatSize_16, t0.mimetype AS mimetype_17 FROM picture t0 WHERE t0.id IN (?)
Parameters:
[
  [
    450
    449
    442
    441
    440
    439
  ]
]
0.41 ms
(5.51%)
1
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.position AS position_4, t0.content AS content_5, t0.slug AS slug_6 FROM members_categories t0 ORDER BY t0.id ASC
Parameters:
[]
0.39 ms
(5.23%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.isEnabled AS isEnabled_3 FROM biblios t0 WHERE t0.id IN (?)
Parameters:
[
  [
    13
    12
    11
    10
  ]
]
0.38 ms
(5.10%)
1
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.is_enabled AS is_enabled_4, t0.slug AS slug_5 FROM partners_categories t0 WHERE t0.is_enabled = ? ORDER BY t0.id ASC
Parameters:
[
  1
]
0.37 ms
(5.05%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.isEnabled AS isEnabled_3 FROM albums t0 WHERE t0.id IN (?)
Parameters:
[
  [
    68
    67
  ]
]
0.33 ms
(4.46%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.banner_id AS banner_id_5 FROM articles_categories t0 WHERE t0.id IN (?)
Parameters:
[
  [
    2
  ]
]
0.32 ms
(4.31%)
1
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4 FROM services_categories t0 ORDER BY t0.id ASC
Parameters:
[]
0.29 ms
(3.99%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.banner_id AS banner_id_5 FROM articles_categories t0 ORDER BY t0.id ASC
Parameters:
[]

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\Articles No errors.
App\Entity\Users No errors.
App\Entity\OSFile No errors.
App\Entity\Picture No errors.
App\Entity\ArticlesCategories No errors.
App\Entity\ArticlesTypes No errors.
App\Entity\Profiles No errors.
App\Entity\Albums No errors.
App\Entity\Biblios No errors.
App\Entity\Tags No errors.
App\Entity\File No errors.
App\Entity\PartnersCategories No errors.
App\Entity\ServicesCategories No errors.
App\Entity\Services No errors.
App\Entity\MembersCategories No errors.