Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1.20 ms
(30.85%)
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
]
1.05 ms
(26.87%)
1
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.start_time AS start_time_3, t0.end_date AS end_date_4, t0.end_time AS end_time_5, t0.name AS name_6, t0.description AS description_7, t0.details AS details_8, t0.created_at AS created_at_9, t0.is_enabled AS is_enabled_10, t0.date AS date_11, t0.slug AS slug_12, t0.place AS place_13, t0.created_by_id AS created_by_id_14, t0.album_id AS album_id_15, t16.id AS id_17, t16.title AS title_18, t16.isEnabled AS isEnabled_19, t0.biblio_id AS biblio_id_20, t21.id AS id_22, t21.title AS title_23, t21.isEnabled AS isEnabled_24, t0.banner_id AS banner_id_25, t26.target AS target_27, t26.thumbnailDir AS thumbnailDir_28, t26.hasThumbnail AS hasThumbnail_29, t26.id AS id_30, t26.pages AS pages_31, t26.downloads AS downloads_32, t26.reading AS reading_33, t26.name AS name_34, t26.dir AS dir_35, t26.source AS source_36, t26.size AS size_37, t26.is_enabled AS is_enabled_38, t26.is_deleted AS is_deleted_39, t26.last_update AS last_update_40, t26.created_at AS created_at_41, t26.formatSize AS formatSize_42, t26.mimetype AS mimetype_43 FROM events t0 LEFT JOIN albums t16 ON t0.album_id = t16.id LEFT JOIN biblios t21 ON t0.biblio_id = t21.id LEFT JOIN picture t26 ON t0.banner_id = t26.id WHERE t0.id = ?
Parameters:
[
  "42"
]
0.58 ms
(14.91%)
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.38 ms
(9.68%)
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:
[]
0.36 ms
(9.24%)
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.33 ms
(8.45%)
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:
[]

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\Events No errors.
App\Entity\Users No errors.
App\Entity\Albums No errors.
App\Entity\Biblios No errors.
App\Entity\OSFile No errors.
App\Entity\Picture No errors.
App\Entity\Tags 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.