Query Metrics

9 Database Queries
9 Different statements
19.87 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 6.27 ms
SELECT f0_.id AS id_0, f0_.label AS label_1, f0_.is_enabled AS is_enabled_2, f0_.details AS details_3, f0_.target AS target_4, f0_.duration AS duration_5, f0_.cost AS cost_6, f0_.main_objective AS main_objective_7, f0_.specifics_objectives AS specifics_objectives_8, f0_.formation_id AS formation_id_9, f0_.domain_id AS domain_id_10 FROM formations_thematics f0_
Parameters:
[]
2 2.91 ms
SELECT r0_.id AS id_0, r0_.label AS label_1 FROM registrations_professions r0_
Parameters:
[]
3 2.72 ms
SELECT r0_.id AS id_0, r0_.label AS label_1 FROM registrations_companies_types r0_
Parameters:
[]
4 1.08 ms
SELECT f0_.id AS id_0, f0_.label AS label_1, f0_.description AS description_2, f0_.details AS details_3, f0_.slug AS slug_4, f0_.is_enabled AS is_enabled_5, f0_.created_at AS created_at_6, f0_.has_registration AS has_registration_7, f0_.banner_id AS banner_id_8, f0_.album_id AS album_id_9, f0_.user_id AS user_id_10 FROM formations f0_ WHERE f0_.has_registration = 1 AND f0_.is_enabled = 1
Parameters:
[]
5 1.72 ms
SELECT f0_.id AS id_0, f0_.label AS label_1, f0_.description AS description_2, f0_.starting_date AS starting_date_3, f0_.end_date AS end_date_4, f0_.is_enabled AS is_enabled_5, f0_.formation_id AS formation_id_6 FROM formations_sessions f0_ WHERE f0_.is_enabled = 1 AND f0_.starting_date > CURRENT_DATE
Parameters:
[]
6 2.32 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.details AS details_4, t0.slug AS slug_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.has_registration AS has_registration_8, t0.banner_id AS banner_id_9, t0.album_id AS album_id_10, t0.user_id AS user_id_11 FROM formations t0 WHERE t0.is_enabled = ?
Parameters:
[
  1
]
7 0.90 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.slug AS slug_4, t0.is_enabled AS is_enabled_5 FROM StructuresCategories t0 WHERE t0.is_enabled = ?
Parameters:
[
  1
]
8 1.07 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
Parameters:
[]
9 0.86 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
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\Registrations No errors.
App\Entity\RegistrationsProfessions No errors.
App\Entity\RegistrationsCompaniesTypes No errors.
App\Entity\Formations No errors.
App\Entity\OSFile No errors.
App\Entity\Picture No errors.
App\Entity\Albums No errors.
App\Entity\Users No errors.
App\Entity\FormationsSessions No errors.
App\Entity\FormationsThematics No errors.
App\Entity\Domains No errors.
App\Entity\StructuresCategories No errors.
App\Entity\ArticlesCategories No errors.
App\Entity\Articles No errors.
App\Entity\ResourcesCategories No errors.
App\Entity\Resources No errors.