Query Metrics
29
Database Queries
11
Different statements
4.20 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.57 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 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"yoga-au-feminin"
]
|
| 2 | 0.54 ms |
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:
[
67
]
|
| 3 | 0.27 ms |
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:
[
67
]
|
| 4 | 0.11 ms |
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:
[ 11 28 41 57 73 12 ] |
| 5 | 0.05 ms |
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:
[
28
]
|
| 6 | 0.04 ms |
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:
[
57
]
|
| 7 | 0.05 ms |
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:
[
11
]
|
| 8 | 0.05 ms |
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:
[
41
]
|
| 9 | 0.04 ms |
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
]
|
| 10 | 0.12 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:
[] |
| 11 | 0.08 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:
[] |
| 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:
[
12
]
|
| 13 | 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:
[
18
]
|
| 14 | 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:
[
7
]
|
| 15 | 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
]
|
| 16 | 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:
[
8
]
|
| 17 | 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
]
|
| 18 | 0.12 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
]
|
| 19 | 0.11 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
]
|
| 20 | 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:
[
14
]
|
| 21 | 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
]
|
| 22 | 0.16 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
]
|
| 23 | 0.13 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
]
|
| 24 | 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
]
|
| 25 | 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
]
|
| 26 | 0.25 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 INNER JOIN formation_theme ON t0.id = formation_theme.theme_id WHERE formation_theme.formation_id = ?
Parameters:
[
67
]
|
| 27 | 0.12 ms |
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:
[
67
]
|
| 28 | 0.24 ms |
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:
[
67
]
|
| 29 | 0.17 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.is_active AS is_active_6, t0.reset_token AS reset_token_7, t0.expires_at AS expires_at_8, t0.email_verification_token AS email_verification_token_9, t0.created_at AS created_at_10, t11.id AS id_12, t11.first_name AS first_name_13, t11.last_name AS last_name_14, t11.bio AS bio_15, t11.primary_address AS primary_address_16, t11.secondary_address AS secondary_address_17, t11.post_code AS post_code_18, t11.city AS city_19, t11.country AS country_20, t11.sex AS sex_21, t11.occupation AS occupation_22, t11.student AS student_23, t11.rpps AS rpps_24, t11.status AS status_25, t11.tel_mobile AS tel_mobile_26, t11.tel_landing AS tel_landing_27, t11.objective AS objective_28, t11.is_born_at AS is_born_at_29, t11.image AS image_30, t11.other_occupation AS other_occupation_31, t11.siret AS siret_32, t11.teacher_num AS teacher_num_33, t11.num_ordre AS num_ordre_34, t11.rc_pro AS rc_pro_35, t11.slug AS slug_36, t11.email_backup AS email_backup_37, t11.comment AS comment_38, t11.user_id AS user_id_39 FROM user t0 LEFT JOIN user_profile t11 ON t11.user_id = t0.id WHERE t0.id = ?
Parameters:
[
110
]
|
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\Formation | No errors. |
| App\Entity\Duration | No errors. |
| App\Entity\Session | No errors. |
| App\Entity\Theme | No errors. |
| App\Entity\UserFormation | No errors. |
| App\Entity\FormationFunding | No errors. |
| App\Entity\QuestionQuali | No errors. |
| App\Entity\WaitingUserFormation | No errors. |
| App\Entity\Location | No errors. |
| App\Entity\UserSession | No errors. |
| App\Entity\FormationDocs | No errors. |
| App\Entity\Funding | No errors. |
| App\Entity\ClassPrice | No errors. |
| App\Entity\User | No errors. |
| App\Entity\UserProfile | No errors. |