GET https://www.ippp.ninapresotto.com/

Query Metrics

21 Database Queries
7 Different statements
2.43 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.52 ms
(62.43%)
14
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.slug AS slug_4, t0.is_featured AS is_featured_5, t0.image AS image_6, t0.image_size AS image_size_7, t0.duration AS duration_8, t0.updated_at AS updated_at_9, t0.programme AS programme_10, t0.internal_ref AS internal_ref_11, t0.nb_heures AS nb_heures_12, t0.featured_comment AS featured_comment_13, t0.dpc_num_action AS dpc_num_action_14, t0.is_virtual AS is_virtual_15, t0.target_audience AS target_audience_16, t0.prerequisite AS prerequisite_17, t0.objective AS objective_18, t0.method AS method_19, t0.show_order AS show_order_20, t0.text_class_format AS text_class_format_21, t0.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_22, t0.agremented_fifpl_virtual AS agremented_fifpl_virtual_23, t0.agremented_dpc_presentiel AS agremented_dpc_presentiel_24, t0.agremented_dpc_virtual AS agremented_dpc_virtual_25, t0.dpc_num_action_virtual AS dpc_num_action_virtual_26, t0.text_dpc_virtual AS text_dpc_virtual_27, t0.text_attest_dpc_virtual AS text_attest_dpc_virtual_28, t0.text_dpc_presentiel AS text_dpc_presentiel_29, t0.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_30, t0.nb_jours_id AS nb_jours_id_31 FROM formation t0 INNER JOIN formation_theme ON t0.id = formation_theme.formation_id WHERE formation_theme.theme_id = ?
Parameters:
[
  12
]
0.30 ms
(12.18%)
2
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.short_desc AS short_desc_2, t0_.slug AS slug_3, t0_.color AS color_4, t0_.updated_at AS updated_at_5, t0_.show_order AS show_order_6 FROM theme t0_ ORDER BY t0_.show_order ASC
Parameters:
[]
0.22 ms
(8.98%)
1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.short_desc AS short_desc_2, f0_.slug AS slug_3, f0_.is_featured AS is_featured_4, f0_.image AS image_5, f0_.image_size AS image_size_6, f0_.duration AS duration_7, f0_.updated_at AS updated_at_8, f0_.programme AS programme_9, f0_.internal_ref AS internal_ref_10, f0_.nb_heures AS nb_heures_11, f0_.featured_comment AS featured_comment_12, f0_.dpc_num_action AS dpc_num_action_13, f0_.is_virtual AS is_virtual_14, f0_.target_audience AS target_audience_15, f0_.prerequisite AS prerequisite_16, f0_.objective AS objective_17, f0_.method AS method_18, f0_.show_order AS show_order_19, f0_.text_class_format AS text_class_format_20, f0_.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_21, f0_.agremented_fifpl_virtual AS agremented_fifpl_virtual_22, f0_.agremented_dpc_presentiel AS agremented_dpc_presentiel_23, f0_.agremented_dpc_virtual AS agremented_dpc_virtual_24, f0_.dpc_num_action_virtual AS dpc_num_action_virtual_25, f0_.text_dpc_virtual AS text_dpc_virtual_26, f0_.text_attest_dpc_virtual AS text_attest_dpc_virtual_27, f0_.text_dpc_presentiel AS text_dpc_presentiel_28, f0_.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_29, f0_.nb_jours_id AS nb_jours_id_30 FROM formation f0_ WHERE f0_.is_featured LIKE ?
Parameters:
[
  "1"
]
0.13 ms
(5.31%)
1
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.short_desc AS short_desc_2, f0_.slug AS slug_3, f0_.is_featured AS is_featured_4, f0_.image AS image_5, f0_.image_size AS image_size_6, f0_.duration AS duration_7, f0_.updated_at AS updated_at_8, f0_.programme AS programme_9, f0_.internal_ref AS internal_ref_10, f0_.nb_heures AS nb_heures_11, f0_.featured_comment AS featured_comment_12, f0_.dpc_num_action AS dpc_num_action_13, f0_.is_virtual AS is_virtual_14, f0_.target_audience AS target_audience_15, f0_.prerequisite AS prerequisite_16, f0_.objective AS objective_17, f0_.method AS method_18, f0_.show_order AS show_order_19, f0_.text_class_format AS text_class_format_20, f0_.agremented_fifpl_presentiel AS agremented_fifpl_presentiel_21, f0_.agremented_fifpl_virtual AS agremented_fifpl_virtual_22, f0_.agremented_dpc_presentiel AS agremented_dpc_presentiel_23, f0_.agremented_dpc_virtual AS agremented_dpc_virtual_24, f0_.dpc_num_action_virtual AS dpc_num_action_virtual_25, f0_.text_dpc_virtual AS text_dpc_virtual_26, f0_.text_attest_dpc_virtual AS text_attest_dpc_virtual_27, f0_.text_dpc_presentiel AS text_dpc_presentiel_28, f0_.text_attest_dpc_presentiel AS text_attest_dpc_presentiel_29, f0_.nb_jours_id AS nb_jours_id_30 FROM formation f0_ ORDER BY f0_.id DESC LIMIT 3
Parameters:
[]
0.11 ms
(4.36%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.slug AS slug_3, p0_.created_at AS created_at_4, p0_.is_featured AS is_featured_5, p0_.excerpt AS excerpt_6, p0_.image_size AS image_size_7, p0_.image AS image_8 FROM post p0_ ORDER BY p0_.id DESC LIMIT 3
Parameters:
[]
0.09 ms
(3.75%)
1
SELECT o0_.intro AS intro_0 FROM `option` o0_ LIMIT 1
Parameters:
[]
0.07 ms
(3.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.slug AS slug_4, t0.color AS color_5, t0.updated_at AS updated_at_6, t0.show_order AS show_order_7 FROM theme 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\Theme No errors.
App\Entity\Formation No errors.
App\Entity\Duration No errors.
App\Entity\Session No errors.
App\Entity\UserFormation No errors.
App\Entity\FormationFunding No errors.
App\Entity\QuestionQuali No errors.
App\Entity\WaitingUserFormation No errors.
App\Entity\Option No errors.
App\Entity\Post No errors.