Query Metrics

11 Database Queries
4 Different statements
6.97 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.21 ms
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.photos AS photos_2, j0_.code_romes AS code_romes_3, j0_.family AS family_4, j0_.nature_du_travail AS nature_du_travail_5, j0_.tasks AS tasks_6, j0_.quality AS quality_7, j0_.skills AS skills_8, j0_.les_profils_qui_nous_plaisent AS les_profils_qui_nous_plaisent_9, j0_.univers_du_poste AS univers_du_poste_10, j0_.evolution AS evolution_11, j0_.category_id AS category_id_12 FROM job j0_ ORDER BY j0_.category_id ASC
Parameters:
[]
2 0.85 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "tressol_our_jobs_detail"
]
3 0.32 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]
4 0.40 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
5 0.30 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "tressol_our_jobs_detail"
]
6 0.19 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]
7 0.18 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
8 0.49 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
9 0.37 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
10 0.61 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "tressol_our_jobs_detail"
]
11 2.06 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.identifier AS identifier_4, t0.content AS content_5, t0.hektor_text_logged AS hektor_text_logged_6, t0.hektor_text_not_logged AS hektor_text_not_logged_7, t0.hektor_text_is_differnet AS hektor_text_is_differnet_8, t0.cms_page_id AS cms_page_id_9 FROM cms_bloc t0 WHERE t0.cms_page_id = ?
Parameters:
[
  36
]

Database Connections

Name Service
default doctrine.dbal.default_connection
internal doctrine.dbal.internal_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
internal doctrine.orm.internal_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Job No errors.
App\Entity\Offre No errors.
App\Entity\CmsPage No errors.
App\Entity\CmsBloc No errors.
App\Entity\DataCount No errors.

internal entity manager

No loaded entities.