Query Metrics

10 Database Queries
10 Different statements
3.95 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.64 ms
SELECT count(r0_.id) AS sclr_0 FROM resources r0_ LEFT JOIN resources_categories r1_ ON r0_.category_id = r1_.id WHERE r0_.isEnabled = 1 ORDER BY r0_.date DESC
Parameters:
[]
2 0.42 ms
SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.description AS description_2, r0_.isEnabled AS isEnabled_3, r0_.createdAt AS createdAt_4, r0_.date AS date_5, r0_.is_important AS is_important_6, r0_.document_id AS document_id_7, r0_.cover_id AS cover_id_8, r0_.category_id AS category_id_9, r0_.createdBy AS createdBy_10, r0_.updatedBy AS updatedBy_11 FROM resources r0_ LEFT JOIN resources_categories r1_ ON r0_.category_id = r1_.id WHERE r0_.isEnabled = 1 ORDER BY r0_.date DESC LIMIT 50
Parameters:
[]
3 0.57 ms
SELECT t0.id AS id_1, t0.target AS target_2, t0.pages AS pages_3, t0.downloads AS downloads_4, t0.reading AS reading_5, t0.name AS name_6, t0.dir AS dir_7, t0.source AS source_8, t0.size AS size_9, t0.is_enabled AS is_enabled_10, t0.is_deleted AS is_deleted_11, t0.last_update AS last_update_12, t0.created_at AS created_at_13, t0.formatSize AS formatSize_14, t0.mimetype AS mimetype_15 FROM file t0 WHERE t0.id IN (?)
Parameters:
[
  [
    23
    6
    7
    3
  ]
]
4 0.36 ms
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:
[
  [
    448
    4
  ]
]
5 0.29 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4 FROM resources_categories t0 WHERE t0.id IN (?)
Parameters:
[
  [
    1
  ]
]
6 0.28 ms
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
]
7 0.26 ms
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:
[]
8 0.25 ms
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:
[]
9 0.25 ms
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:
[]
10 0.62 ms
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
]

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\ResourcesCategories No errors.
App\Entity\Resources No errors.
App\Entity\OSFile No errors.
App\Entity\File No errors.
App\Entity\Picture No errors.
App\Entity\Users No errors.
App\Entity\PartnersCategories No errors.
App\Entity\ArticlesCategories No errors.
App\Entity\Articles No errors.
App\Entity\ServicesCategories No errors.
App\Entity\Services No errors.
App\Entity\MembersCategories No errors.