Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.number_of_seats AS number_of_seats_1,
  e0_.name AS name_2,
  e0_.label AS label_3,
  e1_.status AS status_4,
  e0_.time_of_maintenance AS time_of_maintenance_5,
  e0_.planned_realization_date AS planned_realization_date_6,
  s2_.name AS name_7,
  s2_.place AS place_8,
  s2_.address AS address_9,
  e0_.education_description AS education_description_10,
  i3_.name AS name_11,
  u4_.first_name AS first_name_12,
  u4_.last_name AS last_name_13,
  sum(
    CASE WHEN e1_.status = ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_14,
  sum(CASE WHEN u5_.id = ? THEN
    1
  ELSE
    0
  END) AS sclr_15,
  sum(CASE WHEN u6_.id = ? THEN
    1
  ELSE
    0
  END) AS sclr_16,
  e0_.id AS id_17,
  e0_.date_created AS date_created_18,
  e0_.date_changed AS date_changed_19,
  e0_.active AS active_20,
  e0_.name AS name_21,
  e0_.label AS label_22,
  e0_.status AS status_23,
  e0_.number_of_seats AS number_of_seats_24,
  e0_.duration AS duration_25,
  e0_.education_area AS education_area_26,
  e0_.target_group AS target_group_27,
  e0_.event_location AS event_location_28,
  e0_.education_description AS education_description_29,
  e0_.outcomes AS outcomes_30,
  e0_.keywords AS keywords_31,
  e0_.image AS image_32,
  e0_.time_of_maintenance AS time_of_maintenance_33,
  e0_.implementation_requirements AS implementation_requirements_34,
  e0_.document AS document_35,
  e0_.original_name AS original_name_36,
  e0_.planned_realization_date AS planned_realization_date_37,
  e0_.full_document_path AS full_document_path_38,
  e0_.educator_certificate_document_name AS educator_certificate_document_name_39,
  e0_.educator_certificate_document_path AS educator_certificate_document_path_40,
  e0_.educator_census_lists_name AS educator_census_lists_name_41,
  e0_.educator_census_list_path AS educator_census_list_path_42,
  e0_.educator_document AS educator_document_43,
  e0_.census_list AS census_list_44,
  e0_.remark AS remark_45,
  e0_.educator_mzo_point_name AS educator_mzo_point_name_46,
  e0_.educator_mzo_point_value AS educator_mzo_point_value_47,
  e0_.mzo_point_name AS mzo_point_name_48,
  e0_.mzo_point_value AS mzo_point_value_49,
  e7_.id AS id_50,
  e7_.date_created AS date_created_51,
  e7_.date_changed AS date_changed_52,
  e7_.active AS active_53,
  e7_.ordinal_number_on_education AS ordinal_number_on_education_54,
  u6_.id AS id_55,
  u6_.email AS email_56,
  u6_.bank AS bank_57,
  u6_.iban AS iban_58,
  u6_.roles AS roles_59,
  u6_.password AS password_60,
  u6_.first_name AS first_name_61,
  u6_.last_name AS last_name_62,
  u6_.registration_token AS registration_token_63,
  u6_.password_reset_token AS password_reset_token_64,
  u6_.image AS image_65,
  u6_.oib AS oib_66,
  u6_.gender AS gender_67,
  u6_.date_of_birth AS date_of_birth_68,
  u6_.phone AS phone_69,
  u6_.address AS address_70,
  u6_.place AS place_71,
  u6_.menu_visibility AS menu_visibility_72,
  u6_.active AS active_73,
  e0_.user_created AS user_created_74,
  e0_.user_changed AS user_changed_75,
  e0_.institution AS institution_76,
  e0_.education_manager AS education_manager_77,
  e0_.school_year AS school_year_78,
  e0_.school_list AS school_list_79,
  e0_.form_of_education AS form_of_education_80,
  e0_.method_of_implementation AS method_of_implementation_81,
  e7_.user_created AS user_created_82,
  e7_.user_changed AS user_changed_83,
  e7_.education AS education_84,
  e7_.education_manager AS education_manager_85,
  u6_.professional_qualification AS professional_qualification_86
FROM
  education e0_
  INNER JOIN institution i3_ ON e0_.institution = i3_.id
  INNER JOIN user u4_ ON e0_.education_manager = u4_.id
  LEFT JOIN education_participant e1_ ON e0_.id = e1_.education
  LEFT JOIN user u5_ ON e1_.participant = u5_.id
  LEFT JOIN education_educator e7_ ON e0_.id = e7_.education
  LEFT JOIN user u6_ ON e7_.education_manager = u6_.id
  INNER JOIN school_list s2_ ON e0_.school_list = s2_.id
  INNER JOIN method_of_implementation m8_ ON e0_.method_of_implementation = m8_.id
WHERE
  e0_.active = ?
  AND e0_.status = ?
  AND (
    CONCAT(u4_.first_name, u4_.last_name) LIKE ?
    OR e0_.name LIKE ?
    OR CONCAT(u6_.first_name, u6_.last_name) LIKE ?
    OR e0_.keywords LIKE ?
    OR s2_.address LIKE ?
    OR s2_.place LIKE ?
  )
GROUP BY
  e0_.id,
  u6_.id
ORDER BY
  e0_.planned_realization_date ASC

SELECT e0_.id AS id_0, e0_.number_of_seats AS number_of_seats_1, e0_.name AS name_2, e0_.label AS label_3, e1_.status AS status_4, e0_.time_of_maintenance AS time_of_maintenance_5, e0_.planned_realization_date AS planned_realization_date_6, s2_.name AS name_7, s2_.place AS place_8, s2_.address AS address_9, e0_.education_description AS education_description_10, i3_.name AS name_11, u4_.first_name AS first_name_12, u4_.last_name AS last_name_13, sum(CASE WHEN e1_.status = 'APPROVED' THEN 1 ELSE 0 END) AS sclr_14, sum(CASE WHEN u5_.id = '0' THEN 1 ELSE 0 END) AS sclr_15, sum(CASE WHEN u6_.id = '0' THEN 1 ELSE 0 END) AS sclr_16, e0_.id AS id_17, e0_.date_created AS date_created_18, e0_.date_changed AS date_changed_19, e0_.active AS active_20, e0_.name AS name_21, e0_.label AS label_22, e0_.status AS status_23, e0_.number_of_seats AS number_of_seats_24, e0_.duration AS duration_25, e0_.education_area AS education_area_26, e0_.target_group AS target_group_27, e0_.event_location AS event_location_28, e0_.education_description AS education_description_29, e0_.outcomes AS outcomes_30, e0_.keywords AS keywords_31, e0_.image AS image_32, e0_.time_of_maintenance AS time_of_maintenance_33, e0_.implementation_requirements AS implementation_requirements_34, e0_.document AS document_35, e0_.original_name AS original_name_36, e0_.planned_realization_date AS planned_realization_date_37, e0_.full_document_path AS full_document_path_38, e0_.educator_certificate_document_name AS educator_certificate_document_name_39, e0_.educator_certificate_document_path AS educator_certificate_document_path_40, e0_.educator_census_lists_name AS educator_census_lists_name_41, e0_.educator_census_list_path AS educator_census_list_path_42, e0_.educator_document AS educator_document_43, e0_.census_list AS census_list_44, e0_.remark AS remark_45, e0_.educator_mzo_point_name AS educator_mzo_point_name_46, e0_.educator_mzo_point_value AS educator_mzo_point_value_47, e0_.mzo_point_name AS mzo_point_name_48, e0_.mzo_point_value AS mzo_point_value_49, e7_.id AS id_50, e7_.date_created AS date_created_51, e7_.date_changed AS date_changed_52, e7_.active AS active_53, e7_.ordinal_number_on_education AS ordinal_number_on_education_54, u6_.id AS id_55, u6_.email AS email_56, u6_.bank AS bank_57, u6_.iban AS iban_58, u6_.roles AS roles_59, u6_.password AS password_60, u6_.first_name AS first_name_61, u6_.last_name AS last_name_62, u6_.registration_token AS registration_token_63, u6_.password_reset_token AS password_reset_token_64, u6_.image AS image_65, u6_.oib AS oib_66, u6_.gender AS gender_67, u6_.date_of_birth AS date_of_birth_68, u6_.phone AS phone_69, u6_.address AS address_70, u6_.place AS place_71, u6_.menu_visibility AS menu_visibility_72, u6_.active AS active_73, e0_.user_created AS user_created_74, e0_.user_changed AS user_changed_75, e0_.institution AS institution_76, e0_.education_manager AS education_manager_77, e0_.school_year AS school_year_78, e0_.school_list AS school_list_79, e0_.form_of_education AS form_of_education_80, e0_.method_of_implementation AS method_of_implementation_81, e7_.user_created AS user_created_82, e7_.user_changed AS user_changed_83, e7_.education AS education_84, e7_.education_manager AS education_manager_85, u6_.professional_qualification AS professional_qualification_86 FROM education e0_ INNER JOIN institution i3_ ON e0_.institution = i3_.id INNER JOIN user u4_ ON e0_.education_manager = u4_.id LEFT JOIN education_participant e1_ ON e0_.id = e1_.education LEFT JOIN user u5_ ON e1_.participant = u5_.id LEFT JOIN education_educator e7_ ON e0_.id = e7_.education LEFT JOIN user u6_ ON e7_.education_manager = u6_.id INNER JOIN school_list s2_ ON e0_.school_list = s2_.id INNER JOIN method_of_implementation m8_ ON e0_.method_of_implementation = m8_.id WHERE e0_.active = 1 AND e0_.status = 'APPLICATIONS' AND (CONCAT(u4_.first_name, u4_.last_name) LIKE '%%' OR e0_.name LIKE '%%' OR CONCAT(u6_.first_name, u6_.last_name) LIKE '%%' OR e0_.keywords LIKE '%%' OR s2_.address LIKE '%%' OR s2_.place LIKE '%%') GROUP BY e0_.id, u6_.id ORDER BY e0_.planned_realization_date ASC;