GET https://ippp.ninapresotto.com/formation/l-art-du-mouvement-la-science-en-pelvi-perineologie

Query Metrics

24 Database Queries
10 Different statements
4.45 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.68 ms
(37.70%)
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.62 ms
(13.97%)
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.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 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "l-art-du-mouvement-la-science-en-pelvi-perineologie"
]
0.61 ms
(13.65%)
1
SELECT t0.id AS id_1, t0.begins_at AS begins_at_2, t0.ends_at AS ends_at_3, t0.is_virtual AS is_virtual_4, t0.connection_link AS connection_link_5, t0.internal_ref AS internal_ref_6, t0.start_hour AS start_hour_7, t0.end_hour AS end_hour_8, t0.min_seats AS min_seats_9, t0.max_seats AS max_seats_10, t0.is_canceled AS is_canceled_11, t0.is_actif AS is_actif_12, t0.dpc_num_session AS dpc_num_session_13, t0.comment AS comment_14, t0.dates_for_certif AS dates_for_certif_15, t0.quota_dpc AS quota_dpc_16, t0.email_min_reached_received_at AS email_min_reached_received_at_17, t0.formation_id AS formation_id_18, t0.location_id AS location_id_19 FROM session t0 WHERE t0.formation_id = ?
Parameters:
[
  84
]
0.45 ms
(10.01%)
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 INNER JOIN formation_theme ON t0.id = formation_theme.theme_id WHERE formation_theme.formation_id = ?
Parameters:
[
  84
]
0.33 ms
(7.42%)
1
SELECT t0.id AS id_1, t0.is_virtual AS is_virtual_2, t0.price AS price_3, t0.deposit AS deposit_4, t0.prise_en_charge_dpc AS prise_en_charge_dpc_5, t0.funding_id AS funding_id_6, t0.duration_id AS duration_id_7 FROM class_price t0 WHERE t0.funding_id IN (?) AND t0.duration_id = ?
Parameters:
[
  73
  12
]
0.29 ms
(6.50%)
2
SELECT t0.id AS id_1, t0.label AS label_2, t0.comment AS comment_3, t0.is_available AS is_available_4, t0.refund_dpc AS refund_dpc_5, t0.formation_id AS formation_id_6, t0.funding_id AS funding_id_7 FROM formation_funding t0 WHERE t0.formation_id = ?
Parameters:
[
  84
]
0.24 ms
(5.37%)
1
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.user_id AS user_id_3, t0.formation_id AS formation_id_4 FROM user_formation t0 WHERE t0.formation_id = ?
Parameters:
[
  84
]
0.09 ms
(2.09%)
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:
[]
0.09 ms
(2.04%)
1
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.06 ms
(1.24%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_desc AS short_desc_3, t0.description AS description_4, t0.slug AS slug_5, t0.color AS color_6, t0.is_coord_employer AS is_coord_employer_7, t0.ref AS ref_8, t0.is_active AS is_active_9 FROM funding t0 WHERE t0.id = ?
Parameters:
[
  73
]

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