Symfony Profiler

Query Metrics

25 Database Queries

19 Different statements

12.88 ms Query time

3 Invalid entities

333 Managed entities

Queries


SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') WHERE p2_.status = ? AND p2_.event_hidden = ? AND p2_.finish_at - p2_.start_at <= MAKETIME(?,?,0) ORDER BY p2_.occure_at ASC
SELECT w0_.id AS id_0, w0_.day AS day_1, w0_.half_day AS half_day_2 FROM week_item w0_
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.region_code AS region_code_2, a0_.region_name AS region_name_3, a0_.departements AS departements_4, a0_.available AS available_5 FROM academy a0_ WHERE a0_.available = ? AND a0_.id IN (?) ORDER BY a0_.name ASC
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.activity_area_more AS activity_area_more_3, c0_.head_office_address AS head_office_address_4, c0_.head_office_zipcode AS head_office_zipcode_5, c0_.head_office_city AS head_office_city_6, c0_.head_office_country AS head_office_country_7, c0_.nb_employees AS nb_employees_8, c0_.logo AS logo_9, c0_.website_url AS website_url_10, c0_.perimeter AS perimeter_11, c0_.skills AS skills_12, c0_.partner AS partner_13, c0_.partner_itdlc AS partner_itdlc_14, c0_.partner_pee AS partner_pee_15, c0_.partner_foundation AS partner_foundation_16, c0_.slug AS slug_17, c0_.max_published_pee AS max_published_pee_18, c0_.count_pee_subscription_came AS count_pee_subscription_came_19, c0_.count_speaker AS count_speaker_20, c0_.count_itdlc_archived AS count_itdlc_archived_21, c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22, c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23, c0_.count_company_location AS count_company_location_24, c0_.company_idv1 AS company_idv1_25, c0_.other_activity_area AS other_activity_area_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.idv1 AS idv1_29, c0_.comment AS comment_30, c0_.activity_area_id AS activity_area_id_31, c0_.academy_id AS academy_id_32, c0_.corporation_id AS corporation_id_33, c0_.created_by AS created_by_34, c0_.updated_by AS updated_by_35 FROM company c0_ INNER JOIN company_location c1_ ON c0_.id = c1_.company_id INNER JOIN pee p2_ ON c1_.id = p2_.company_location_id WHERE c0_.status = ? AND p2_.status = ? AND p2_.event_hidden = 0 AND p2_.id IS NOT NULL AND c0_.id IN (?) GROUP BY c0_.id ORDER BY c0_.name ASC
SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') INNER JOIN company c5_ ON c1_.company_id = c5_.id WHERE p2_.status = ? AND p2_.event_hidden = ? AND c5_.id = ? ORDER BY p2_.occure_at ASC
SELECT t0.id AS id_1, t0.label AS label_2 FROM activity_area t0 WHERE t0.id = ?
SELECT a0_.id AS id_0, a0_.label AS label_1 FROM activity_area a0_
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.region_code AS region_code_2, a0_.region_name AS region_name_3, a0_.departements AS departements_4, a0_.available AS available_5 FROM academy a0_ WHERE a0_.available = ? ORDER BY a0_.name ASC
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.activity_area_more AS activity_area_more_3, c0_.head_office_address AS head_office_address_4, c0_.head_office_zipcode AS head_office_zipcode_5, c0_.head_office_city AS head_office_city_6, c0_.head_office_country AS head_office_country_7, c0_.nb_employees AS nb_employees_8, c0_.logo AS logo_9, c0_.website_url AS website_url_10, c0_.perimeter AS perimeter_11, c0_.skills AS skills_12, c0_.partner AS partner_13, c0_.partner_itdlc AS partner_itdlc_14, c0_.partner_pee AS partner_pee_15, c0_.partner_foundation AS partner_foundation_16, c0_.slug AS slug_17, c0_.max_published_pee AS max_published_pee_18, c0_.count_pee_subscription_came AS count_pee_subscription_came_19, c0_.count_speaker AS count_speaker_20, c0_.count_itdlc_archived AS count_itdlc_archived_21, c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22, c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23, c0_.count_company_location AS count_company_location_24, c0_.company_idv1 AS company_idv1_25, c0_.other_activity_area AS other_activity_area_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.idv1 AS idv1_29, c0_.comment AS comment_30, c0_.activity_area_id AS activity_area_id_31, c0_.academy_id AS academy_id_32, c0_.corporation_id AS corporation_id_33, c0_.created_by AS created_by_34, c0_.updated_by AS updated_by_35 FROM company c0_ INNER JOIN company_location c1_ ON c0_.id = c1_.company_id INNER JOIN pee p2_ ON c1_.id = p2_.company_location_id WHERE c0_.status = ? AND p2_.status = ? AND p2_.event_hidden = 0 AND p2_.id IS NOT NULL GROUP BY c0_.id ORDER BY c0_.name ASC
SELECT DISTINCT id_2 FROM (SELECT DISTINCT id_2, occure_at_4 FROM (SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, c4_.id AS id_94, c4_.name AS name_95, c4_.status AS status_96, c4_.activity_area_more AS activity_area_more_97, c4_.head_office_address AS head_office_address_98, c4_.head_office_zipcode AS head_office_zipcode_99, c4_.head_office_city AS head_office_city_100, c4_.head_office_country AS head_office_country_101, c4_.nb_employees AS nb_employees_102, c4_.logo AS logo_103, c4_.website_url AS website_url_104, c4_.perimeter AS perimeter_105, c4_.skills AS skills_106, c4_.partner AS partner_107, c4_.partner_itdlc AS partner_itdlc_108, c4_.partner_pee AS partner_pee_109, c4_.partner_foundation AS partner_foundation_110, c4_.slug AS slug_111, c4_.max_published_pee AS max_published_pee_112, c4_.count_pee_subscription_came AS count_pee_subscription_came_113, c4_.count_speaker AS count_speaker_114, c4_.count_itdlc_archived AS count_itdlc_archived_115, c4_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_116, c4_.count_itdlc_archived_children AS count_itdlc_archived_children_117, c4_.count_company_location AS count_company_location_118, c4_.company_idv1 AS company_idv1_119, c4_.other_activity_area AS other_activity_area_120, c4_.created_at AS created_at_121, c4_.updated_at AS updated_at_122, c4_.idv1 AS idv1_123, c4_.comment AS comment_124, r3_.type AS type_125 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c5_ ON c1_.id = c5_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c5_.image_id AND r3_.type IN ('image') INNER JOIN company c4_ ON c1_.company_id = c4_.id WHERE p2_.status = ? AND p2_.event_hidden = ? AND c4_.id = ?) dctrn_result_inner ORDER BY occure_at_4 ASC) dctrn_result LIMIT 10
SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') INNER JOIN company c5_ ON c1_.company_id = c5_.id WHERE p2_.status = ? AND p2_.event_hidden = ? AND c5_.id = ? AND p2_.id IN (?, ?, ?) ORDER BY p2_.occure_at ASC
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'cgenial_sandbox' */ ORDER BY k.ORDINAL_POSITION
SELECT       c.COLUMN_NAME        AS field,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'cgenial_sandbox'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
SELECT DATABASE()
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
SELECT * FROM migration_versions
SELECT DATABASE()
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_2 FROM (SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, r3_.type AS type_94 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') INNER JOIN company c5_ ON c1_.company_id = c5_.id WHERE p2_.status = ? AND p2_.event_hidden = ? AND c5_.id = ? ORDER BY p2_.occure_at ASC) dctrn_result) dctrn_table

#▲	Time	Info
1	3.04 ms	SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') WHERE p2_.status = ? AND p2_.event_hidden = ? AND p2_.finish_at - p2_.start_at <= MAKETIME(?,?,0) ORDER BY p2_.occure_at ASC Parameters: [`"published" 0 9.0 0`] View formatted query View runnable query Explain query SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') WHERE p2_.status = ? AND p2_.event_hidden = ? AND p2_.finish_at - p2_.start_at <= MAKETIME(?, ?, 0) ORDER BY p2_.occure_at ASC SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') WHERE p2_.status = 'published' AND p2_.event_hidden = 0 AND p2_.finish_at - p2_.start_at <= MAKETIME(9,0,0) ORDER BY p2_.occure_at ASC;
2	0.11 ms	SELECT w0_.id AS id_0, w0_.day AS day_1, w0_.half_day AS half_day_2 FROM week_item w0_ Parameters: [] View formatted query View runnable query Explain query SELECT w0_.id AS id_0, w0_.day AS day_1, w0_.half_day AS half_day_2 FROM week_item w0_ SELECT w0_.id AS id_0, w0_.day AS day_1, w0_.half_day AS half_day_2 FROM week_item w0_;
3	0.36 ms	SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.region_code AS region_code_2, a0_.region_name AS region_name_3, a0_.departements AS departements_4, a0_.available AS available_5 FROM academy a0_ WHERE a0_.available = ? AND a0_.id IN (?) ORDER BY a0_.name ASC Parameters: [`1 ""`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.region_code AS region_code_2, a0_.region_name AS region_name_3, a0_.departements AS departements_4, a0_.available AS available_5 FROM academy a0_ WHERE a0_.available = ? AND a0_.id IN (?) ORDER BY a0_.name ASC SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.region_code AS region_code_2, a0_.region_name AS region_name_3, a0_.departements AS departements_4, a0_.available AS available_5 FROM academy a0_ WHERE a0_.available = 1 AND a0_.id IN ('') ORDER BY a0_.name ASC;
4	0.63 ms	SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.activity_area_more AS activity_area_more_3, c0_.head_office_address AS head_office_address_4, c0_.head_office_zipcode AS head_office_zipcode_5, c0_.head_office_city AS head_office_city_6, c0_.head_office_country AS head_office_country_7, c0_.nb_employees AS nb_employees_8, c0_.logo AS logo_9, c0_.website_url AS website_url_10, c0_.perimeter AS perimeter_11, c0_.skills AS skills_12, c0_.partner AS partner_13, c0_.partner_itdlc AS partner_itdlc_14, c0_.partner_pee AS partner_pee_15, c0_.partner_foundation AS partner_foundation_16, c0_.slug AS slug_17, c0_.max_published_pee AS max_published_pee_18, c0_.count_pee_subscription_came AS count_pee_subscription_came_19, c0_.count_speaker AS count_speaker_20, c0_.count_itdlc_archived AS count_itdlc_archived_21, c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22, c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23, c0_.count_company_location AS count_company_location_24, c0_.company_idv1 AS company_idv1_25, c0_.other_activity_area AS other_activity_area_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.idv1 AS idv1_29, c0_.comment AS comment_30, c0_.activity_area_id AS activity_area_id_31, c0_.academy_id AS academy_id_32, c0_.corporation_id AS corporation_id_33, c0_.created_by AS created_by_34, c0_.updated_by AS updated_by_35 FROM company c0_ INNER JOIN company_location c1_ ON c0_.id = c1_.company_id INNER JOIN pee p2_ ON c1_.id = p2_.company_location_id WHERE c0_.status = ? AND p2_.status = ? AND p2_.event_hidden = 0 AND p2_.id IS NOT NULL AND c0_.id IN (?) GROUP BY c0_.id ORDER BY c0_.name ASC Parameters: [`"published" "published" "26"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.activity_area_more AS activity_area_more_3, c0_.head_office_address AS head_office_address_4, c0_.head_office_zipcode AS head_office_zipcode_5, c0_.head_office_city AS head_office_city_6, c0_.head_office_country AS head_office_country_7, c0_.nb_employees AS nb_employees_8, c0_.logo AS logo_9, c0_.website_url AS website_url_10, c0_.perimeter AS perimeter_11, c0_.skills AS skills_12, c0_.partner AS partner_13, c0_.partner_itdlc AS partner_itdlc_14, c0_.partner_pee AS partner_pee_15, c0_.partner_foundation AS partner_foundation_16, c0_.slug AS slug_17, c0_.max_published_pee AS max_published_pee_18, c0_.count_pee_subscription_came AS count_pee_subscription_came_19, c0_.count_speaker AS count_speaker_20, c0_.count_itdlc_archived AS count_itdlc_archived_21, c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22, c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23, c0_.count_company_location AS count_company_location_24, c0_.company_idv1 AS company_idv1_25, c0_.other_activity_area AS other_activity_area_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.idv1 AS idv1_29, c0_.comment AS comment_30, c0_.activity_area_id AS activity_area_id_31, c0_.academy_id AS academy_id_32, c0_.corporation_id AS corporation_id_33, c0_.created_by AS created_by_34, c0_.updated_by AS updated_by_35 FROM company c0_ INNER JOIN company_location c1_ ON c0_.id = c1_.company_id INNER JOIN pee p2_ ON c1_.id = p2_.company_location_id WHERE c0_.status = ? AND p2_.status = ? AND p2_.event_hidden = 0 AND p2_.id IS NOT NULL AND c0_.id IN (?) GROUP BY c0_.id ORDER BY c0_.name ASC SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.activity_area_more AS activity_area_more_3, c0_.head_office_address AS head_office_address_4, c0_.head_office_zipcode AS head_office_zipcode_5, c0_.head_office_city AS head_office_city_6, c0_.head_office_country AS head_office_country_7, c0_.nb_employees AS nb_employees_8, c0_.logo AS logo_9, c0_.website_url AS website_url_10, c0_.perimeter AS perimeter_11, c0_.skills AS skills_12, c0_.partner AS partner_13, c0_.partner_itdlc AS partner_itdlc_14, c0_.partner_pee AS partner_pee_15, c0_.partner_foundation AS partner_foundation_16, c0_.slug AS slug_17, c0_.max_published_pee AS max_published_pee_18, c0_.count_pee_subscription_came AS count_pee_subscription_came_19, c0_.count_speaker AS count_speaker_20, c0_.count_itdlc_archived AS count_itdlc_archived_21, c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22, c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23, c0_.count_company_location AS count_company_location_24, c0_.company_idv1 AS company_idv1_25, c0_.other_activity_area AS other_activity_area_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.idv1 AS idv1_29, c0_.comment AS comment_30, c0_.activity_area_id AS activity_area_id_31, c0_.academy_id AS academy_id_32, c0_.corporation_id AS corporation_id_33, c0_.created_by AS created_by_34, c0_.updated_by AS updated_by_35 FROM company c0_ INNER JOIN company_location c1_ ON c0_.id = c1_.company_id INNER JOIN pee p2_ ON c1_.id = p2_.company_location_id WHERE c0_.status = 'published' AND p2_.status = 'published' AND p2_.event_hidden = 0 AND p2_.id IS NOT NULL AND c0_.id IN ('26') GROUP BY c0_.id ORDER BY c0_.name ASC;
5	1.33 ms	SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') INNER JOIN company c5_ ON c1_.company_id = c5_.id WHERE p2_.status = ? AND p2_.event_hidden = ? AND c5_.id = ? ORDER BY p2_.occure_at ASC Parameters: [`"published" 0 26`] View formatted query View runnable query Explain query SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') INNER JOIN company c5_ ON c1_.company_id = c5_.id WHERE p2_.status = ? AND p2_.event_hidden = ? AND c5_.id = ? ORDER BY p2_.occure_at ASC SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') INNER JOIN company c5_ ON c1_.company_id = c5_.id WHERE p2_.status = 'published' AND p2_.event_hidden = 0 AND c5_.id = 26 ORDER BY p2_.occure_at ASC;
6	0.11 ms	SELECT t0.id AS id_1, t0.label AS label_2 FROM activity_area t0 WHERE t0.id = ? Parameters: [`35`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2 FROM activity_area t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2 FROM activity_area t0 WHERE t0.id = 35;
7	0.07 ms	SELECT a0_.id AS id_0, a0_.label AS label_1 FROM activity_area a0_ Parameters: [] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.label AS label_1 FROM activity_area a0_ SELECT a0_.id AS id_0, a0_.label AS label_1 FROM activity_area a0_;
8	0.07 ms	SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.region_code AS region_code_2, a0_.region_name AS region_name_3, a0_.departements AS departements_4, a0_.available AS available_5 FROM academy a0_ WHERE a0_.available = ? ORDER BY a0_.name ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.region_code AS region_code_2, a0_.region_name AS region_name_3, a0_.departements AS departements_4, a0_.available AS available_5 FROM academy a0_ WHERE a0_.available = ? ORDER BY a0_.name ASC SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.region_code AS region_code_2, a0_.region_name AS region_name_3, a0_.departements AS departements_4, a0_.available AS available_5 FROM academy a0_ WHERE a0_.available = 1 ORDER BY a0_.name ASC;
9	0.10 ms	SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.activity_area_more AS activity_area_more_3, c0_.head_office_address AS head_office_address_4, c0_.head_office_zipcode AS head_office_zipcode_5, c0_.head_office_city AS head_office_city_6, c0_.head_office_country AS head_office_country_7, c0_.nb_employees AS nb_employees_8, c0_.logo AS logo_9, c0_.website_url AS website_url_10, c0_.perimeter AS perimeter_11, c0_.skills AS skills_12, c0_.partner AS partner_13, c0_.partner_itdlc AS partner_itdlc_14, c0_.partner_pee AS partner_pee_15, c0_.partner_foundation AS partner_foundation_16, c0_.slug AS slug_17, c0_.max_published_pee AS max_published_pee_18, c0_.count_pee_subscription_came AS count_pee_subscription_came_19, c0_.count_speaker AS count_speaker_20, c0_.count_itdlc_archived AS count_itdlc_archived_21, c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22, c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23, c0_.count_company_location AS count_company_location_24, c0_.company_idv1 AS company_idv1_25, c0_.other_activity_area AS other_activity_area_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.idv1 AS idv1_29, c0_.comment AS comment_30, c0_.activity_area_id AS activity_area_id_31, c0_.academy_id AS academy_id_32, c0_.corporation_id AS corporation_id_33, c0_.created_by AS created_by_34, c0_.updated_by AS updated_by_35 FROM company c0_ INNER JOIN company_location c1_ ON c0_.id = c1_.company_id INNER JOIN pee p2_ ON c1_.id = p2_.company_location_id WHERE c0_.status = ? AND p2_.status = ? AND p2_.event_hidden = 0 AND p2_.id IS NOT NULL GROUP BY c0_.id ORDER BY c0_.name ASC Parameters: [`"published" "published"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.activity_area_more AS activity_area_more_3, c0_.head_office_address AS head_office_address_4, c0_.head_office_zipcode AS head_office_zipcode_5, c0_.head_office_city AS head_office_city_6, c0_.head_office_country AS head_office_country_7, c0_.nb_employees AS nb_employees_8, c0_.logo AS logo_9, c0_.website_url AS website_url_10, c0_.perimeter AS perimeter_11, c0_.skills AS skills_12, c0_.partner AS partner_13, c0_.partner_itdlc AS partner_itdlc_14, c0_.partner_pee AS partner_pee_15, c0_.partner_foundation AS partner_foundation_16, c0_.slug AS slug_17, c0_.max_published_pee AS max_published_pee_18, c0_.count_pee_subscription_came AS count_pee_subscription_came_19, c0_.count_speaker AS count_speaker_20, c0_.count_itdlc_archived AS count_itdlc_archived_21, c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22, c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23, c0_.count_company_location AS count_company_location_24, c0_.company_idv1 AS company_idv1_25, c0_.other_activity_area AS other_activity_area_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.idv1 AS idv1_29, c0_.comment AS comment_30, c0_.activity_area_id AS activity_area_id_31, c0_.academy_id AS academy_id_32, c0_.corporation_id AS corporation_id_33, c0_.created_by AS created_by_34, c0_.updated_by AS updated_by_35 FROM company c0_ INNER JOIN company_location c1_ ON c0_.id = c1_.company_id INNER JOIN pee p2_ ON c1_.id = p2_.company_location_id WHERE c0_.status = ? AND p2_.status = ? AND p2_.event_hidden = 0 AND p2_.id IS NOT NULL GROUP BY c0_.id ORDER BY c0_.name ASC SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.activity_area_more AS activity_area_more_3, c0_.head_office_address AS head_office_address_4, c0_.head_office_zipcode AS head_office_zipcode_5, c0_.head_office_city AS head_office_city_6, c0_.head_office_country AS head_office_country_7, c0_.nb_employees AS nb_employees_8, c0_.logo AS logo_9, c0_.website_url AS website_url_10, c0_.perimeter AS perimeter_11, c0_.skills AS skills_12, c0_.partner AS partner_13, c0_.partner_itdlc AS partner_itdlc_14, c0_.partner_pee AS partner_pee_15, c0_.partner_foundation AS partner_foundation_16, c0_.slug AS slug_17, c0_.max_published_pee AS max_published_pee_18, c0_.count_pee_subscription_came AS count_pee_subscription_came_19, c0_.count_speaker AS count_speaker_20, c0_.count_itdlc_archived AS count_itdlc_archived_21, c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22, c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23, c0_.count_company_location AS count_company_location_24, c0_.company_idv1 AS company_idv1_25, c0_.other_activity_area AS other_activity_area_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.idv1 AS idv1_29, c0_.comment AS comment_30, c0_.activity_area_id AS activity_area_id_31, c0_.academy_id AS academy_id_32, c0_.corporation_id AS corporation_id_33, c0_.created_by AS created_by_34, c0_.updated_by AS updated_by_35 FROM company c0_ INNER JOIN company_location c1_ ON c0_.id = c1_.company_id INNER JOIN pee p2_ ON c1_.id = p2_.company_location_id WHERE c0_.status = 'published' AND p2_.status = 'published' AND p2_.event_hidden = 0 AND p2_.id IS NOT NULL GROUP BY c0_.id ORDER BY c0_.name ASC;
10	0.81 ms	SELECT DISTINCT id_2 FROM (SELECT DISTINCT id_2, occure_at_4 FROM (SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, c4_.id AS id_94, c4_.name AS name_95, c4_.status AS status_96, c4_.activity_area_more AS activity_area_more_97, c4_.head_office_address AS head_office_address_98, c4_.head_office_zipcode AS head_office_zipcode_99, c4_.head_office_city AS head_office_city_100, c4_.head_office_country AS head_office_country_101, c4_.nb_employees AS nb_employees_102, c4_.logo AS logo_103, c4_.website_url AS website_url_104, c4_.perimeter AS perimeter_105, c4_.skills AS skills_106, c4_.partner AS partner_107, c4_.partner_itdlc AS partner_itdlc_108, c4_.partner_pee AS partner_pee_109, c4_.partner_foundation AS partner_foundation_110, c4_.slug AS slug_111, c4_.max_published_pee AS max_published_pee_112, c4_.count_pee_subscription_came AS count_pee_subscription_came_113, c4_.count_speaker AS count_speaker_114, c4_.count_itdlc_archived AS count_itdlc_archived_115, c4_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_116, c4_.count_itdlc_archived_children AS count_itdlc_archived_children_117, c4_.count_company_location AS count_company_location_118, c4_.company_idv1 AS company_idv1_119, c4_.other_activity_area AS other_activity_area_120, c4_.created_at AS created_at_121, c4_.updated_at AS updated_at_122, c4_.idv1 AS idv1_123, c4_.comment AS comment_124, r3_.type AS type_125 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c5_ ON c1_.id = c5_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c5_.image_id AND r3_.type IN ('image') INNER JOIN company c4_ ON c1_.company_id = c4_.id WHERE p2_.status = ? AND p2_.event_hidden = ? AND c4_.id = ?) dctrn_result_inner ORDER BY occure_at_4 ASC) dctrn_result LIMIT 10 Parameters: [`"published" 0 26`] View formatted query View runnable query Explain query SELECT DISTINCT id_2 FROM ( SELECT DISTINCT id_2, occure_at_4 FROM ( SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, c4_.id AS id_94, c4_.name AS name_95, c4_.status AS status_96, c4_.activity_area_more AS activity_area_more_97, c4_.head_office_address AS head_office_address_98, c4_.head_office_zipcode AS head_office_zipcode_99, c4_.head_office_city AS head_office_city_100, c4_.head_office_country AS head_office_country_101, c4_.nb_employees AS nb_employees_102, c4_.logo AS logo_103, c4_.website_url AS website_url_104, c4_.perimeter AS perimeter_105, c4_.skills AS skills_106, c4_.partner AS partner_107, c4_.partner_itdlc AS partner_itdlc_108, c4_.partner_pee AS partner_pee_109, c4_.partner_foundation AS partner_foundation_110, c4_.slug AS slug_111, c4_.max_published_pee AS max_published_pee_112, c4_.count_pee_subscription_came AS count_pee_subscription_came_113, c4_.count_speaker AS count_speaker_114, c4_.count_itdlc_archived AS count_itdlc_archived_115, c4_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_116, c4_.count_itdlc_archived_children AS count_itdlc_archived_children_117, c4_.count_company_location AS count_company_location_118, c4_.company_idv1 AS company_idv1_119, c4_.other_activity_area AS other_activity_area_120, c4_.created_at AS created_at_121, c4_.updated_at AS updated_at_122, c4_.idv1 AS idv1_123, c4_.comment AS comment_124, r3_.type AS type_125 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c5_ ON c1_.id = c5_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c5_.image_id AND r3_.type IN ('image') INNER JOIN company c4_ ON c1_.company_id = c4_.id WHERE p2_.status = ? AND p2_.event_hidden = ? AND c4_.id = ? ) dctrn_result_inner ORDER BY occure_at_4 ASC ) dctrn_result LIMIT 10 SELECT DISTINCT id_2 FROM (SELECT DISTINCT id_2, occure_at_4 FROM (SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, c4_.id AS id_94, c4_.name AS name_95, c4_.status AS status_96, c4_.activity_area_more AS activity_area_more_97, c4_.head_office_address AS head_office_address_98, c4_.head_office_zipcode AS head_office_zipcode_99, c4_.head_office_city AS head_office_city_100, c4_.head_office_country AS head_office_country_101, c4_.nb_employees AS nb_employees_102, c4_.logo AS logo_103, c4_.website_url AS website_url_104, c4_.perimeter AS perimeter_105, c4_.skills AS skills_106, c4_.partner AS partner_107, c4_.partner_itdlc AS partner_itdlc_108, c4_.partner_pee AS partner_pee_109, c4_.partner_foundation AS partner_foundation_110, c4_.slug AS slug_111, c4_.max_published_pee AS max_published_pee_112, c4_.count_pee_subscription_came AS count_pee_subscription_came_113, c4_.count_speaker AS count_speaker_114, c4_.count_itdlc_archived AS count_itdlc_archived_115, c4_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_116, c4_.count_itdlc_archived_children AS count_itdlc_archived_children_117, c4_.count_company_location AS count_company_location_118, c4_.company_idv1 AS company_idv1_119, c4_.other_activity_area AS other_activity_area_120, c4_.created_at AS created_at_121, c4_.updated_at AS updated_at_122, c4_.idv1 AS idv1_123, c4_.comment AS comment_124, r3_.type AS type_125 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c5_ ON c1_.id = c5_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c5_.image_id AND r3_.type IN ('image') INNER JOIN company c4_ ON c1_.company_id = c4_.id WHERE p2_.status = 'published' AND p2_.event_hidden = 0 AND c4_.id = 26) dctrn_result_inner ORDER BY occure_at_4 ASC) dctrn_result LIMIT 10;
11	0.71 ms	SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') INNER JOIN company c5_ ON c1_.company_id = c5_.id WHERE p2_.status = ? AND p2_.event_hidden = ? AND c5_.id = ? AND p2_.id IN (?, ?, ?) ORDER BY p2_.occure_at ASC Parameters: [`"published" 0 26 2012 2054 1968`] View formatted query View runnable query Explain query SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') INNER JOIN company c5_ ON c1_.company_id = c5_.id WHERE p2_.status = ? AND p2_.event_hidden = ? AND c5_.id = ? AND p2_.id IN (?, ?, ?) ORDER BY p2_.occure_at ASC SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') INNER JOIN company c5_ ON c1_.company_id = c5_.id WHERE p2_.status = 'published' AND p2_.event_hidden = 0 AND c5_.id = 26 AND p2_.id IN (2012, 2054, 1968) ORDER BY p2_.occure_at ASC;
12	0.14 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
13	0.71 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"cgenial_sandbox"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'cgenial_sandbox' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
14	0.07 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
15	0.41 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"cgenial_sandbox"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'cgenial_sandbox' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
16	0.08 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
17	1.19 ms	SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"cgenial_sandbox" "migration_versions"`] View formatted query View runnable query Explain query SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'cgenial_sandbox' AND t.TABLE_NAME = 'migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
18	0.07 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
19	0.68 ms	SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'cgenial_sandbox' / ORDER BY k.ORDINAL_POSITION Parameters: [`"cgenial_sandbox" "migration_versions"`] View formatted query View runnable query Explain query SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'cgenial_sandbox' / ORDER BY k.ORDINAL_POSITION SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = 'cgenial_sandbox' AND k.TABLE_NAME = 'migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'cgenial_sandbox' / ORDER BY k.ORDINAL_POSITION;
20	0.98 ms	SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'cgenial_sandbox' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION Parameters: [`"cgenial_sandbox" "cgenial_sandbox" "migration_versions"`] View formatted query View runnable query Explain query SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'cgenial_sandbox' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'cgenial_sandbox' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'cgenial_sandbox' AND t.TABLE_SCHEMA = 'cgenial_sandbox' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'migration_versions' ORDER BY ORDINAL_POSITION;
21	0.08 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
22	0.16 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX Parameters: [`"cgenial_sandbox" "migration_versions"`] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'cgenial_sandbox' AND TABLE_NAME = 'migration_versions' ORDER BY SEQ_IN_INDEX;
23	0.11 ms	SELECT * FROM migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM migration_versions SELECT * FROM migration_versions;
24	0.10 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
25	0.75 ms	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_2 FROM (SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, r3_.type AS type_94 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') INNER JOIN company c5_ ON c1_.company_id = c5_.id WHERE p2_.status = ? AND p2_.event_hidden = ? AND c5_.id = ? ORDER BY p2_.occure_at ASC) dctrn_result) dctrn_table Parameters: [`"published" 0 26`] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_2 FROM ( SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, r3_.type AS type_94 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') INNER JOIN company c5_ ON c1_.company_id = c5_.id WHERE p2_.status = ? AND p2_.event_hidden = ? AND c5_.id = ? ORDER BY p2_.occure_at ASC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_2 FROM (SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, r3_.type AS type_94 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') INNER JOIN company c5_ ON c1_.company_id = c5_.id WHERE p2_.status = 'published' AND p2_.event_hidden = 0 AND c5_.id = 26 ORDER BY p2_.occure_at ASC) dctrn_result) dctrn_table;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\ResourceFile	81
App\Entity\User	50
App\Entity\ActivityArea	46
App\Entity\Academy	33
App\Entity\Pee	28
App\Entity\CompanyLocation	27
App\Entity\Address	27
App\Entity\Company	23
App\Entity\WeekItem	14
App\Entity\SuperOrganisation	4

Entities Mapping

Class	Mapping errors
App\Entity\Pee	No errors.
App\Entity\CompanyLocation	No errors.
App\Entity\Address	No errors.
App\Entity\Image	No errors.
App\Entity\ActivityArea	No errors.
App\Entity\PeeSubscription	No errors.
App\Entity\ProcessLog	No errors.
App\Entity\Feedback	No errors.
App\Entity\BrandLabel	No errors.
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\Manager	No errors.
App\Entity\Speaker	No errors.
App\Entity\Organisation	No errors.
App\Entity\Stage	No errors.
App\Entity\Academy	No errors.
App\Entity\Itdlc	No errors.
App\Entity\WeekItem	The field App\Entity\WeekItem#teachers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Teacher#disciplines does not contain the required 'inversedBy="teachers"' attribute.
App\Entity\Teacher	No errors.
App\Entity\Corporation	No errors.
App\Entity\ResourceFile	No errors.
App\Entity\EventSession	No errors.
App\Entity\AdminRole	No errors.
App\Entity\ManagerOrganisation	No errors.
App\Entity\UserPreference	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\UserLog	No errors.
App\Entity\EducationLevel	No errors.
App\Entity\ClassLevel	The field App\Entity\ClassLevel#teachers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Teacher#classLevels does not contain the required 'inversedBy="teachers"' attribute.
App\Entity\SpeechType	No errors.
App\Entity\OrganisationType	No errors.
App\Entity\StageSubscription	No errors.
App\Entity\TeacherSchool	No errors.
App\Entity\ItdlcOptionDate	No errors.
App\Entity\Discipline	The field App\Entity\Discipline#teachers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Teacher#disciplines does not contain the required 'inversedBy="teachers"' attribute.
App\Entity\TeacherJob	No errors.
App\Entity\EventSessionSubscription	No errors.
App\Entity\SuperOrganisation	No errors.
App\Entity\Info	No errors.
App\Entity\Import	No errors.
App\Entity\School	No errors.
App\Entity\Zipcode	No errors.
App\Entity\EventSpeaker	No errors.
App\Entity\EventTheme	No errors.
App\Entity\EventType	No errors.
App\Entity\StagePeriod	No errors.
App\Entity\SchoolType	No errors.
App\Entity\Notification	No errors.
App\Entity\EventSessionSpeaker	No errors.
App\Entity\NotificationTemplate	No errors.
App\Entity\SendinBlueNotificationTracking	No errors.
App\Entity\ZipcodeGeolocation	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://sandbox.cgenial-connect.fr/profentreprise/recherche?search_pee%5Bcompany%5D=26&search_pee%5BmaxDistance%5D=100

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping