Symfony Profiler

Query Metrics

26 Database Queries

6 Different statements

23.38 ms Query time

1 Invalid entities

109 Managed entities

Queries

Group similar statements

default connection


SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.status AS status_3, a0_.moderation_comment AS moderation_comment_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.published_at AS published_at_7, a0_.archived_at AS archived_at_8, a0_.views AS views_9, a0_.author_id AS author_id_10, a0_.program_id AS program_id_11, a0_.category_id AS category_id_12, a0_.published_by_id AS published_by_id_13 FROM article a0_ WHERE a0_.status = ? ORDER BY a0_.published_at DESC LIMIT 12
SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0')
SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0')
SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0')
SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0')
SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0')
SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0')
SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0')
SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0')
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.visible AS visible_4 FROM article_category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.visible AS visible_4 FROM article_category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ?
SELECT p0_.id AS id_0, p0_.starts_on AS starts_on_1, p0_.ends_on AS ends_on_2, p0_.duration AS duration_3, p0_.duration_hours AS duration_hours_4, p0_.title AS title_5, p0_.description AS description_6, p0_.address AS address_7, p0_.latitude AS latitude_8, p0_.longitude AS longitude_9, p0_.featured_image AS featured_image_10, p0_.featured_image_thumb AS featured_image_thumb_11, p0_.rendezvous_time AS rendezvous_time_12, p0_.visible AS visible_13, p0_.canceled AS canceled_14, p0_.deleted AS deleted_15, p0_.payment_by_account AS payment_by_account_16, p0_.payment_by_other AS payment_by_other_17, p0_.payment_amount AS payment_amount_18, p0_.payment_other_amount AS payment_other_amount_19, p0_.advance_payment_amount AS advance_payment_amount_20, p0_.debit_on AS debit_on_21, p0_.registration_required AS registration_required_22, p0_.registration_start AS registration_start_23, p0_.registration_end AS registration_end_24, p0_.maximum_registrations AS maximum_registrations_25, p0_.registrations_cancellable AS registrations_cancellable_26, p0_.withdrawal_deadline AS withdrawal_deadline_27, p0_.accounting_code AS accounting_code_28, p0_.accounting_ana_code AS accounting_ana_code_29, p0_.total_cost AS total_cost_30, p0_.validated AS validated_31, p0_.legal_validated AS legal_validated_32, p0_.validated_at AS validated_at_33, p0_.legal_validated_at AS legal_validated_at_34, p0_.validation_email_sent AS validation_email_sent_35, p0_.validation_email_sent_at AS validation_email_sent_at_36, p0_.created_at AS created_at_37, p0_.updated_at AS updated_at_38, p0_.registration_by_organizer AS registration_by_organizer_39, p0_.elevation AS elevation_40, p0_.distance AS distance_41, p0_.training AS training_42, p0_.activity_id AS activity_id_43, p0_.section_id AS section_id_44, p0_.creator_id AS creator_id_45, p0_.supervisor_id AS supervisor_id_46, p0_.localisation_id AS localisation_id_47, p0_.canceled_by_id AS canceled_by_id_48, p0_.deleted_by_id AS deleted_by_id_49, p0_.validated_by_id AS validated_by_id_50, p0_.legal_validated_by_id AS legal_validated_by_id_51, p0_.level_id AS level_id_52 FROM program p0_ WHERE (p0_.visible = 1 AND p0_.deleted = 0 AND p0_.validated = 1 AND p0_.starts_on >= ?) AND p0_.training IN ('0') ORDER BY p0_.starts_on ASC LIMIT 8
SELECT p0_.id AS id_0, p0_.starts_on AS starts_on_1, p0_.ends_on AS ends_on_2, p0_.duration AS duration_3, p0_.duration_hours AS duration_hours_4, p0_.title AS title_5, p0_.description AS description_6, p0_.address AS address_7, p0_.latitude AS latitude_8, p0_.longitude AS longitude_9, p0_.featured_image AS featured_image_10, p0_.featured_image_thumb AS featured_image_thumb_11, p0_.rendezvous_time AS rendezvous_time_12, p0_.visible AS visible_13, p0_.canceled AS canceled_14, p0_.deleted AS deleted_15, p0_.payment_by_account AS payment_by_account_16, p0_.payment_by_other AS payment_by_other_17, p0_.payment_amount AS payment_amount_18, p0_.payment_other_amount AS payment_other_amount_19, p0_.advance_payment_amount AS advance_payment_amount_20, p0_.debit_on AS debit_on_21, p0_.registration_required AS registration_required_22, p0_.registration_start AS registration_start_23, p0_.registration_end AS registration_end_24, p0_.maximum_registrations AS maximum_registrations_25, p0_.registrations_cancellable AS registrations_cancellable_26, p0_.withdrawal_deadline AS withdrawal_deadline_27, p0_.accounting_code AS accounting_code_28, p0_.accounting_ana_code AS accounting_ana_code_29, p0_.total_cost AS total_cost_30, p0_.validated AS validated_31, p0_.legal_validated AS legal_validated_32, p0_.validated_at AS validated_at_33, p0_.legal_validated_at AS legal_validated_at_34, p0_.validation_email_sent AS validation_email_sent_35, p0_.validation_email_sent_at AS validation_email_sent_at_36, p0_.created_at AS created_at_37, p0_.updated_at AS updated_at_38, p0_.registration_by_organizer AS registration_by_organizer_39, p0_.elevation AS elevation_40, p0_.distance AS distance_41, p0_.training AS training_42, p0_.activity_id AS activity_id_43, p0_.section_id AS section_id_44, p0_.creator_id AS creator_id_45, p0_.supervisor_id AS supervisor_id_46, p0_.localisation_id AS localisation_id_47, p0_.canceled_by_id AS canceled_by_id_48, p0_.deleted_by_id AS deleted_by_id_49, p0_.validated_by_id AS validated_by_id_50, p0_.legal_validated_by_id AS legal_validated_by_id_51, p0_.level_id AS level_id_52 FROM program p0_ WHERE (p0_.visible = 1 AND p0_.deleted = 0 AND p0_.validated = 1 AND p0_.starts_on >= ?) AND p0_.training IN ('0') ORDER BY p0_.starts_on ASC LIMIT 8
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.activity_code AS activity_code_4, t0.person_in_charge AS person_in_charge_5, t0.color AS color_6, t0.visible AS visible_7, t0.validation_required AS validation_required_8 FROM caf2_section t0 WHERE t0.id = ?

#▲	Time	Info
1	1.85 ms	SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.status AS status_3, a0_.moderation_comment AS moderation_comment_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.published_at AS published_at_7, a0_.archived_at AS archived_at_8, a0_.views AS views_9, a0_.author_id AS author_id_10, a0_.program_id AS program_id_11, a0_.category_id AS category_id_12, a0_.published_by_id AS published_by_id_13 FROM article a0_ WHERE a0_.status = ? ORDER BY a0_.published_at DESC LIMIT 12 Parameters: [`"PUBLISHED"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.status AS status_3, a0_.moderation_comment AS moderation_comment_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.published_at AS published_at_7, a0_.archived_at AS archived_at_8, a0_.views AS views_9, a0_.author_id AS author_id_10, a0_.program_id AS program_id_11, a0_.category_id AS category_id_12, a0_.published_by_id AS published_by_id_13 FROM article a0_ WHERE a0_.status = ? ORDER BY a0_.published_at DESC LIMIT 12 SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.status AS status_3, a0_.moderation_comment AS moderation_comment_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.published_at AS published_at_7, a0_.archived_at AS archived_at_8, a0_.views AS views_9, a0_.author_id AS author_id_10, a0_.program_id AS program_id_11, a0_.category_id AS category_id_12, a0_.published_by_id AS published_by_id_13 FROM article a0_ WHERE a0_.status = 'PUBLISHED' ORDER BY a0_.published_at DESC LIMIT 12;
2	1.02 ms	SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') Parameters: [`16134`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = 16134 AND t0.training IN ('0');
3	0.66 ms	SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') Parameters: [`16156`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = 16156 AND t0.training IN ('0');
4	0.63 ms	SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') Parameters: [`16350`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = 16350 AND t0.training IN ('0');
5	0.41 ms	SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') Parameters: [`16135`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = 16135 AND t0.training IN ('0');
6	0.41 ms	SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') Parameters: [`16133`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = 16133 AND t0.training IN ('0');
7	0.38 ms	SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') Parameters: [`16147`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = 16147 AND t0.training IN ('0');
8	0.36 ms	SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') Parameters: [`16154`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = 16154 AND t0.training IN ('0');
9	0.37 ms	SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') Parameters: [`16138`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = ? AND t0.training IN ('0') SELECT t0.id AS id_1, t0.starts_on AS starts_on_2, t0.ends_on AS ends_on_3, t0.duration AS duration_4, t0.duration_hours AS duration_hours_5, t0.title AS title_6, t0.description AS description_7, t0.address AS address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.featured_image AS featured_image_11, t0.featured_image_thumb AS featured_image_thumb_12, t0.rendezvous_time AS rendezvous_time_13, t0.visible AS visible_14, t0.canceled AS canceled_15, t0.deleted AS deleted_16, t0.payment_by_account AS payment_by_account_17, t0.payment_by_other AS payment_by_other_18, t0.payment_amount AS payment_amount_19, t0.payment_other_amount AS payment_other_amount_20, t0.advance_payment_amount AS advance_payment_amount_21, t0.debit_on AS debit_on_22, t0.registration_required AS registration_required_23, t0.registration_start AS registration_start_24, t0.registration_end AS registration_end_25, t0.maximum_registrations AS maximum_registrations_26, t0.registrations_cancellable AS registrations_cancellable_27, t0.withdrawal_deadline AS withdrawal_deadline_28, t0.accounting_code AS accounting_code_29, t0.accounting_ana_code AS accounting_ana_code_30, t0.total_cost AS total_cost_31, t0.validated AS validated_32, t0.legal_validated AS legal_validated_33, t0.validated_at AS validated_at_34, t0.legal_validated_at AS legal_validated_at_35, t0.validation_email_sent AS validation_email_sent_36, t0.validation_email_sent_at AS validation_email_sent_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.registration_by_organizer AS registration_by_organizer_40, t0.activity_id AS activity_id_41, t0.section_id AS section_id_42, t0.creator_id AS creator_id_43, t0.supervisor_id AS supervisor_id_44, t0.localisation_id AS localisation_id_45, t0.canceled_by_id AS canceled_by_id_46, t0.deleted_by_id AS deleted_by_id_47, t0.validated_by_id AS validated_by_id_48, t0.legal_validated_by_id AS legal_validated_by_id_49, t0.training, t0.elevation AS elevation_50, t0.distance AS distance_51, t0.level_id AS level_id_52 FROM program t0 WHERE t0.id = 16138 AND t0.training IN ('0');
10	0.79 ms	SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? Parameters: [`26`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = 26;
11	0.61 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.visible AS visible_4 FROM article_category t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.visible AS visible_4 FROM article_category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.visible AS visible_4 FROM article_category t0 WHERE t0.id = 1;
12	0.21 ms	SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? Parameters: [`25`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = 25;
13	0.19 ms	SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? Parameters: [`24`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = 24;
14	0.16 ms	SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? Parameters: [`23`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = 23;
15	0.17 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.visible AS visible_4 FROM article_category t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.visible AS visible_4 FROM article_category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.visible AS visible_4 FROM article_category t0 WHERE t0.id = 2;
16	0.16 ms	SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = 22;
17	0.16 ms	SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? Parameters: [`20`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = 20;
18	0.20 ms	SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? Parameters: [`21`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = 21;
19	0.17 ms	SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = 18;
20	0.17 ms	SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = 17;
21	0.16 ms	SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = 16;
22	0.16 ms	SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? Parameters: [`15`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = 15;
23	0.18 ms	SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? Parameters: [`14`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = ? SELECT t0.id AS id_1, t0.filename AS filename_2, t0.article_id AS article_id_3 FROM article_image t0 WHERE t0.article_id = 14;
24	12.20 ms	SELECT p0_.id AS id_0, p0_.starts_on AS starts_on_1, p0_.ends_on AS ends_on_2, p0_.duration AS duration_3, p0_.duration_hours AS duration_hours_4, p0_.title AS title_5, p0_.description AS description_6, p0_.address AS address_7, p0_.latitude AS latitude_8, p0_.longitude AS longitude_9, p0_.featured_image AS featured_image_10, p0_.featured_image_thumb AS featured_image_thumb_11, p0_.rendezvous_time AS rendezvous_time_12, p0_.visible AS visible_13, p0_.canceled AS canceled_14, p0_.deleted AS deleted_15, p0_.payment_by_account AS payment_by_account_16, p0_.payment_by_other AS payment_by_other_17, p0_.payment_amount AS payment_amount_18, p0_.payment_other_amount AS payment_other_amount_19, p0_.advance_payment_amount AS advance_payment_amount_20, p0_.debit_on AS debit_on_21, p0_.registration_required AS registration_required_22, p0_.registration_start AS registration_start_23, p0_.registration_end AS registration_end_24, p0_.maximum_registrations AS maximum_registrations_25, p0_.registrations_cancellable AS registrations_cancellable_26, p0_.withdrawal_deadline AS withdrawal_deadline_27, p0_.accounting_code AS accounting_code_28, p0_.accounting_ana_code AS accounting_ana_code_29, p0_.total_cost AS total_cost_30, p0_.validated AS validated_31, p0_.legal_validated AS legal_validated_32, p0_.validated_at AS validated_at_33, p0_.legal_validated_at AS legal_validated_at_34, p0_.validation_email_sent AS validation_email_sent_35, p0_.validation_email_sent_at AS validation_email_sent_at_36, p0_.created_at AS created_at_37, p0_.updated_at AS updated_at_38, p0_.registration_by_organizer AS registration_by_organizer_39, p0_.elevation AS elevation_40, p0_.distance AS distance_41, p0_.training AS training_42, p0_.activity_id AS activity_id_43, p0_.section_id AS section_id_44, p0_.creator_id AS creator_id_45, p0_.supervisor_id AS supervisor_id_46, p0_.localisation_id AS localisation_id_47, p0_.canceled_by_id AS canceled_by_id_48, p0_.deleted_by_id AS deleted_by_id_49, p0_.validated_by_id AS validated_by_id_50, p0_.legal_validated_by_id AS legal_validated_by_id_51, p0_.level_id AS level_id_52 FROM program p0_ WHERE (p0_.visible = 1 AND p0_.deleted = 0 AND p0_.validated = 1 AND p0_.starts_on >= ?) AND p0_.training IN ('0') ORDER BY p0_.starts_on ASC LIMIT 8 Parameters: [`"2025-12-12 00:00:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.starts_on AS starts_on_1, p0_.ends_on AS ends_on_2, p0_.duration AS duration_3, p0_.duration_hours AS duration_hours_4, p0_.title AS title_5, p0_.description AS description_6, p0_.address AS address_7, p0_.latitude AS latitude_8, p0_.longitude AS longitude_9, p0_.featured_image AS featured_image_10, p0_.featured_image_thumb AS featured_image_thumb_11, p0_.rendezvous_time AS rendezvous_time_12, p0_.visible AS visible_13, p0_.canceled AS canceled_14, p0_.deleted AS deleted_15, p0_.payment_by_account AS payment_by_account_16, p0_.payment_by_other AS payment_by_other_17, p0_.payment_amount AS payment_amount_18, p0_.payment_other_amount AS payment_other_amount_19, p0_.advance_payment_amount AS advance_payment_amount_20, p0_.debit_on AS debit_on_21, p0_.registration_required AS registration_required_22, p0_.registration_start AS registration_start_23, p0_.registration_end AS registration_end_24, p0_.maximum_registrations AS maximum_registrations_25, p0_.registrations_cancellable AS registrations_cancellable_26, p0_.withdrawal_deadline AS withdrawal_deadline_27, p0_.accounting_code AS accounting_code_28, p0_.accounting_ana_code AS accounting_ana_code_29, p0_.total_cost AS total_cost_30, p0_.validated AS validated_31, p0_.legal_validated AS legal_validated_32, p0_.validated_at AS validated_at_33, p0_.legal_validated_at AS legal_validated_at_34, p0_.validation_email_sent AS validation_email_sent_35, p0_.validation_email_sent_at AS validation_email_sent_at_36, p0_.created_at AS created_at_37, p0_.updated_at AS updated_at_38, p0_.registration_by_organizer AS registration_by_organizer_39, p0_.elevation AS elevation_40, p0_.distance AS distance_41, p0_.training AS training_42, p0_.activity_id AS activity_id_43, p0_.section_id AS section_id_44, p0_.creator_id AS creator_id_45, p0_.supervisor_id AS supervisor_id_46, p0_.localisation_id AS localisation_id_47, p0_.canceled_by_id AS canceled_by_id_48, p0_.deleted_by_id AS deleted_by_id_49, p0_.validated_by_id AS validated_by_id_50, p0_.legal_validated_by_id AS legal_validated_by_id_51, p0_.level_id AS level_id_52 FROM program p0_ WHERE ( p0_.visible = 1 AND p0_.deleted = 0 AND p0_.validated = 1 AND p0_.starts_on >= ? ) AND p0_.training IN ('0') ORDER BY p0_.starts_on ASC LIMIT 8 SELECT p0_.id AS id_0, p0_.starts_on AS starts_on_1, p0_.ends_on AS ends_on_2, p0_.duration AS duration_3, p0_.duration_hours AS duration_hours_4, p0_.title AS title_5, p0_.description AS description_6, p0_.address AS address_7, p0_.latitude AS latitude_8, p0_.longitude AS longitude_9, p0_.featured_image AS featured_image_10, p0_.featured_image_thumb AS featured_image_thumb_11, p0_.rendezvous_time AS rendezvous_time_12, p0_.visible AS visible_13, p0_.canceled AS canceled_14, p0_.deleted AS deleted_15, p0_.payment_by_account AS payment_by_account_16, p0_.payment_by_other AS payment_by_other_17, p0_.payment_amount AS payment_amount_18, p0_.payment_other_amount AS payment_other_amount_19, p0_.advance_payment_amount AS advance_payment_amount_20, p0_.debit_on AS debit_on_21, p0_.registration_required AS registration_required_22, p0_.registration_start AS registration_start_23, p0_.registration_end AS registration_end_24, p0_.maximum_registrations AS maximum_registrations_25, p0_.registrations_cancellable AS registrations_cancellable_26, p0_.withdrawal_deadline AS withdrawal_deadline_27, p0_.accounting_code AS accounting_code_28, p0_.accounting_ana_code AS accounting_ana_code_29, p0_.total_cost AS total_cost_30, p0_.validated AS validated_31, p0_.legal_validated AS legal_validated_32, p0_.validated_at AS validated_at_33, p0_.legal_validated_at AS legal_validated_at_34, p0_.validation_email_sent AS validation_email_sent_35, p0_.validation_email_sent_at AS validation_email_sent_at_36, p0_.created_at AS created_at_37, p0_.updated_at AS updated_at_38, p0_.registration_by_organizer AS registration_by_organizer_39, p0_.elevation AS elevation_40, p0_.distance AS distance_41, p0_.training AS training_42, p0_.activity_id AS activity_id_43, p0_.section_id AS section_id_44, p0_.creator_id AS creator_id_45, p0_.supervisor_id AS supervisor_id_46, p0_.localisation_id AS localisation_id_47, p0_.canceled_by_id AS canceled_by_id_48, p0_.deleted_by_id AS deleted_by_id_49, p0_.validated_by_id AS validated_by_id_50, p0_.legal_validated_by_id AS legal_validated_by_id_51, p0_.level_id AS level_id_52 FROM program p0_ WHERE (p0_.visible = 1 AND p0_.deleted = 0 AND p0_.validated = 1 AND p0_.starts_on >= '2025-12-12 00:00:00') AND p0_.training IN ('0') ORDER BY p0_.starts_on ASC LIMIT 8;
25	1.10 ms	SELECT p0_.id AS id_0, p0_.starts_on AS starts_on_1, p0_.ends_on AS ends_on_2, p0_.duration AS duration_3, p0_.duration_hours AS duration_hours_4, p0_.title AS title_5, p0_.description AS description_6, p0_.address AS address_7, p0_.latitude AS latitude_8, p0_.longitude AS longitude_9, p0_.featured_image AS featured_image_10, p0_.featured_image_thumb AS featured_image_thumb_11, p0_.rendezvous_time AS rendezvous_time_12, p0_.visible AS visible_13, p0_.canceled AS canceled_14, p0_.deleted AS deleted_15, p0_.payment_by_account AS payment_by_account_16, p0_.payment_by_other AS payment_by_other_17, p0_.payment_amount AS payment_amount_18, p0_.payment_other_amount AS payment_other_amount_19, p0_.advance_payment_amount AS advance_payment_amount_20, p0_.debit_on AS debit_on_21, p0_.registration_required AS registration_required_22, p0_.registration_start AS registration_start_23, p0_.registration_end AS registration_end_24, p0_.maximum_registrations AS maximum_registrations_25, p0_.registrations_cancellable AS registrations_cancellable_26, p0_.withdrawal_deadline AS withdrawal_deadline_27, p0_.accounting_code AS accounting_code_28, p0_.accounting_ana_code AS accounting_ana_code_29, p0_.total_cost AS total_cost_30, p0_.validated AS validated_31, p0_.legal_validated AS legal_validated_32, p0_.validated_at AS validated_at_33, p0_.legal_validated_at AS legal_validated_at_34, p0_.validation_email_sent AS validation_email_sent_35, p0_.validation_email_sent_at AS validation_email_sent_at_36, p0_.created_at AS created_at_37, p0_.updated_at AS updated_at_38, p0_.registration_by_organizer AS registration_by_organizer_39, p0_.elevation AS elevation_40, p0_.distance AS distance_41, p0_.training AS training_42, p0_.activity_id AS activity_id_43, p0_.section_id AS section_id_44, p0_.creator_id AS creator_id_45, p0_.supervisor_id AS supervisor_id_46, p0_.localisation_id AS localisation_id_47, p0_.canceled_by_id AS canceled_by_id_48, p0_.deleted_by_id AS deleted_by_id_49, p0_.validated_by_id AS validated_by_id_50, p0_.legal_validated_by_id AS legal_validated_by_id_51, p0_.level_id AS level_id_52 FROM program p0_ WHERE (p0_.visible = 1 AND p0_.deleted = 0 AND p0_.validated = 1 AND p0_.starts_on >= ?) AND p0_.training IN ('0') ORDER BY p0_.starts_on ASC LIMIT 8 Parameters: [`"2025-12-12 00:00:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.starts_on AS starts_on_1, p0_.ends_on AS ends_on_2, p0_.duration AS duration_3, p0_.duration_hours AS duration_hours_4, p0_.title AS title_5, p0_.description AS description_6, p0_.address AS address_7, p0_.latitude AS latitude_8, p0_.longitude AS longitude_9, p0_.featured_image AS featured_image_10, p0_.featured_image_thumb AS featured_image_thumb_11, p0_.rendezvous_time AS rendezvous_time_12, p0_.visible AS visible_13, p0_.canceled AS canceled_14, p0_.deleted AS deleted_15, p0_.payment_by_account AS payment_by_account_16, p0_.payment_by_other AS payment_by_other_17, p0_.payment_amount AS payment_amount_18, p0_.payment_other_amount AS payment_other_amount_19, p0_.advance_payment_amount AS advance_payment_amount_20, p0_.debit_on AS debit_on_21, p0_.registration_required AS registration_required_22, p0_.registration_start AS registration_start_23, p0_.registration_end AS registration_end_24, p0_.maximum_registrations AS maximum_registrations_25, p0_.registrations_cancellable AS registrations_cancellable_26, p0_.withdrawal_deadline AS withdrawal_deadline_27, p0_.accounting_code AS accounting_code_28, p0_.accounting_ana_code AS accounting_ana_code_29, p0_.total_cost AS total_cost_30, p0_.validated AS validated_31, p0_.legal_validated AS legal_validated_32, p0_.validated_at AS validated_at_33, p0_.legal_validated_at AS legal_validated_at_34, p0_.validation_email_sent AS validation_email_sent_35, p0_.validation_email_sent_at AS validation_email_sent_at_36, p0_.created_at AS created_at_37, p0_.updated_at AS updated_at_38, p0_.registration_by_organizer AS registration_by_organizer_39, p0_.elevation AS elevation_40, p0_.distance AS distance_41, p0_.training AS training_42, p0_.activity_id AS activity_id_43, p0_.section_id AS section_id_44, p0_.creator_id AS creator_id_45, p0_.supervisor_id AS supervisor_id_46, p0_.localisation_id AS localisation_id_47, p0_.canceled_by_id AS canceled_by_id_48, p0_.deleted_by_id AS deleted_by_id_49, p0_.validated_by_id AS validated_by_id_50, p0_.legal_validated_by_id AS legal_validated_by_id_51, p0_.level_id AS level_id_52 FROM program p0_ WHERE ( p0_.visible = 1 AND p0_.deleted = 0 AND p0_.validated = 1 AND p0_.starts_on >= ? ) AND p0_.training IN ('0') ORDER BY p0_.starts_on ASC LIMIT 8 SELECT p0_.id AS id_0, p0_.starts_on AS starts_on_1, p0_.ends_on AS ends_on_2, p0_.duration AS duration_3, p0_.duration_hours AS duration_hours_4, p0_.title AS title_5, p0_.description AS description_6, p0_.address AS address_7, p0_.latitude AS latitude_8, p0_.longitude AS longitude_9, p0_.featured_image AS featured_image_10, p0_.featured_image_thumb AS featured_image_thumb_11, p0_.rendezvous_time AS rendezvous_time_12, p0_.visible AS visible_13, p0_.canceled AS canceled_14, p0_.deleted AS deleted_15, p0_.payment_by_account AS payment_by_account_16, p0_.payment_by_other AS payment_by_other_17, p0_.payment_amount AS payment_amount_18, p0_.payment_other_amount AS payment_other_amount_19, p0_.advance_payment_amount AS advance_payment_amount_20, p0_.debit_on AS debit_on_21, p0_.registration_required AS registration_required_22, p0_.registration_start AS registration_start_23, p0_.registration_end AS registration_end_24, p0_.maximum_registrations AS maximum_registrations_25, p0_.registrations_cancellable AS registrations_cancellable_26, p0_.withdrawal_deadline AS withdrawal_deadline_27, p0_.accounting_code AS accounting_code_28, p0_.accounting_ana_code AS accounting_ana_code_29, p0_.total_cost AS total_cost_30, p0_.validated AS validated_31, p0_.legal_validated AS legal_validated_32, p0_.validated_at AS validated_at_33, p0_.legal_validated_at AS legal_validated_at_34, p0_.validation_email_sent AS validation_email_sent_35, p0_.validation_email_sent_at AS validation_email_sent_at_36, p0_.created_at AS created_at_37, p0_.updated_at AS updated_at_38, p0_.registration_by_organizer AS registration_by_organizer_39, p0_.elevation AS elevation_40, p0_.distance AS distance_41, p0_.training AS training_42, p0_.activity_id AS activity_id_43, p0_.section_id AS section_id_44, p0_.creator_id AS creator_id_45, p0_.supervisor_id AS supervisor_id_46, p0_.localisation_id AS localisation_id_47, p0_.canceled_by_id AS canceled_by_id_48, p0_.deleted_by_id AS deleted_by_id_49, p0_.validated_by_id AS validated_by_id_50, p0_.legal_validated_by_id AS legal_validated_by_id_51, p0_.level_id AS level_id_52 FROM program p0_ WHERE (p0_.visible = 1 AND p0_.deleted = 0 AND p0_.validated = 1 AND p0_.starts_on >= '2025-12-12 00:00:00') AND p0_.training IN ('0') ORDER BY p0_.starts_on ASC LIMIT 8;
26	0.50 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.activity_code AS activity_code_4, t0.person_in_charge AS person_in_charge_5, t0.color AS color_6, t0.visible AS visible_7, t0.validation_required AS validation_required_8 FROM caf2_section t0 WHERE t0.id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.activity_code AS activity_code_4, t0.person_in_charge AS person_in_charge_5, t0.color AS color_6, t0.visible AS visible_7, t0.validation_required AS validation_required_8 FROM caf2_section t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.activity_code AS activity_code_4, t0.person_in_charge AS person_in_charge_5, t0.color AS color_6, t0.visible AS visible_7, t0.validation_required AS validation_required_8 FROM caf2_section t0 WHERE t0.id = 7;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
refuge	doctrine.dbal.refuge_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
refuge	doctrine.orm.refuge_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\ArticleImage	35
App\Entity\Article	12
App\Entity\BaseProgram	10
App\Entity\Supervisor	9
App\Entity\Member	8
App\Entity\AdminUser	8
App\Entity\ActivityLevel	8
App\Entity\Activity	6
App\Entity\Section	6
App\Entity\Localisation	5
App\Entity\ArticleCategory	2

refuge entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Article	No errors.
App\Entity\Member	No errors.
App\Entity\BaseProgram	No errors.
App\Entity\ArticleCategory	The field App\Entity\ArticleCategory#articles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Article#category does not contain the required 'inversedBy="articles"' attribute.
App\Entity\AdminUser	No errors.
App\Entity\Activity	No errors.
App\Entity\Section	No errors.
App\Entity\Supervisor	No errors.
App\Entity\Localisation	No errors.
App\Entity\Program	No errors.
App\Entity\ActivityLevel	No errors.
App\Entity\ProgramRegistration	No errors.
App\Entity\MonetaryAccountMovement	No errors.
App\Entity\Retex	No errors.
App\Entity\Equipment	No errors.
App\Entity\ArticleImage	No errors.
App\Entity\ArticleComment	No errors.

refuge entity manager

No loaded entities.

Symfony Profiler

GET https://staging.clubalpin01.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

refuge entity manager

Entities Mapping

default entity manager

refuge entity manager