Symfony Profiler

Query Metrics

18 Database Queries

5 Different statements

2.73 ms Query time

0 Invalid entities

Queries


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 WHERE t0.slug = ? LIMIT 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 EXISTS (SELECT 1 FROM formation_theme f1_ WHERE f1_.formation_id = f0_.id AND f1_.theme_id IN (?))
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
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
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?

#▲	Time	Info
1	0.45 ms	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 WHERE t0.slug = ? LIMIT 1 Parameters: [`"algies-en-perineologie"`] View formatted query View runnable query Explain query 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 WHERE t0.slug = ? LIMIT 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 WHERE t0.slug = 'algies-en-perineologie' LIMIT 1;
2	0.61 ms	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 EXISTS (SELECT 1 FROM formation_theme f1_ WHERE f1_.formation_id = f0_.id AND f1_.theme_id IN (?)) Parameters: [`12`] View formatted query View runnable query Explain query 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 EXISTS ( SELECT 1 FROM formation_theme f1_ WHERE f1_.formation_id = f0_.id AND f1_.theme_id IN (?) ) 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 EXISTS (SELECT 1 FROM formation_theme f1_ WHERE f1_.formation_id = f0_.id AND f1_.theme_id IN (12));
3	0.18 ms	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: [] View formatted query View runnable query Explain query 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 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;
4	0.06 ms	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: [] View formatted query View runnable query Explain query 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 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;
5	0.10 ms	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`] View formatted query View runnable query Explain query 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 = ? 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 = 12;
6	0.08 ms	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: [`18`] View formatted query View runnable query Explain query 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 = ? 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 = 18;
7	0.17 ms	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: [`7`] View formatted query View runnable query Explain query 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 = ? 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 = 7;
8	0.07 ms	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: [`10`] View formatted query View runnable query Explain query 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 = ? 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 = 10;
9	0.15 ms	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: [`8`] View formatted query View runnable query Explain query 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 = ? 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 = 8;
10	0.09 ms	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: [`9`] View formatted query View runnable query Explain query 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 = ? 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 = 9;
11	0.08 ms	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: [`11`] View formatted query View runnable query Explain query 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 = ? 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 = 11;
12	0.14 ms	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: [`13`] View formatted query View runnable query Explain query 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 = ? 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 = 13;
13	0.15 ms	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: [`14`] View formatted query View runnable query Explain query 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 = ? 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 = 14;
14	0.14 ms	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: [`15`] View formatted query View runnable query Explain query 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 = ? 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 = 15;
15	0.08 ms	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: [`16`] View formatted query View runnable query Explain query 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 = ? 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 = 16;
16	0.06 ms	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: [`17`] View formatted query View runnable query Explain query 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 = ? 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 = 17;
17	0.06 ms	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: [`19`] View formatted query View runnable query Explain query 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 = ? 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 = 19;
18	0.06 ms	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: [`20`] View formatted query View runnable query Explain query 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 = ? 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 = 20;

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.

Symfony Profiler

GET https://www.ippp.ninapresotto.com/theme/algies-en-perineologie

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping