Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.date_created AS date_created_1,
  e0_.date_changed AS date_changed_2,
  e0_.active AS active_3,
  e0_.name AS name_4,
  e0_.label AS label_5,
  e0_.status AS status_6,
  e0_.number_of_seats AS number_of_seats_7,
  e0_.duration AS duration_8,
  e0_.education_area AS education_area_9,
  e0_.target_group AS target_group_10,
  e0_.event_location AS event_location_11,
  e0_.education_description AS education_description_12,
  e0_.outcomes AS outcomes_13,
  e0_.keywords AS keywords_14,
  e0_.image AS image_15,
  e0_.time_of_maintenance AS time_of_maintenance_16,
  e0_.implementation_requirements AS implementation_requirements_17,
  e0_.document AS document_18,
  e0_.original_name AS original_name_19,
  e0_.planned_realization_date AS planned_realization_date_20,
  e0_.full_document_path AS full_document_path_21,
  e0_.educator_certificate_document_name AS educator_certificate_document_name_22,
  e0_.educator_certificate_document_path AS educator_certificate_document_path_23,
  e0_.educator_census_lists_name AS educator_census_lists_name_24,
  e0_.educator_census_list_path AS educator_census_list_path_25,
  e0_.educator_document AS educator_document_26,
  e0_.census_list AS census_list_27,
  e0_.remark AS remark_28,
  e0_.educator_mzo_point_name AS educator_mzo_point_name_29,
  e0_.educator_mzo_point_value AS educator_mzo_point_value_30,
  e0_.mzo_point_name AS mzo_point_name_31,
  e0_.mzo_point_value AS mzo_point_value_32,
  e0_.user_created AS user_created_33,
  e0_.user_changed AS user_changed_34,
  e0_.institution AS institution_35,
  e0_.education_manager AS education_manager_36,
  e0_.school_year AS school_year_37,
  e0_.school_list AS school_list_38,
  e0_.form_of_education AS form_of_education_39,
  e0_.method_of_implementation AS method_of_implementation_40
FROM
  education e0_
WHERE
  e0_.name LIKE ?
  AND e0_.active = ?

SELECT e0_.id AS id_0, e0_.date_created AS date_created_1, e0_.date_changed AS date_changed_2, e0_.active AS active_3, e0_.name AS name_4, e0_.label AS label_5, e0_.status AS status_6, e0_.number_of_seats AS number_of_seats_7, e0_.duration AS duration_8, e0_.education_area AS education_area_9, e0_.target_group AS target_group_10, e0_.event_location AS event_location_11, e0_.education_description AS education_description_12, e0_.outcomes AS outcomes_13, e0_.keywords AS keywords_14, e0_.image AS image_15, e0_.time_of_maintenance AS time_of_maintenance_16, e0_.implementation_requirements AS implementation_requirements_17, e0_.document AS document_18, e0_.original_name AS original_name_19, e0_.planned_realization_date AS planned_realization_date_20, e0_.full_document_path AS full_document_path_21, e0_.educator_certificate_document_name AS educator_certificate_document_name_22, e0_.educator_certificate_document_path AS educator_certificate_document_path_23, e0_.educator_census_lists_name AS educator_census_lists_name_24, e0_.educator_census_list_path AS educator_census_list_path_25, e0_.educator_document AS educator_document_26, e0_.census_list AS census_list_27, e0_.remark AS remark_28, e0_.educator_mzo_point_name AS educator_mzo_point_name_29, e0_.educator_mzo_point_value AS educator_mzo_point_value_30, e0_.mzo_point_name AS mzo_point_name_31, e0_.mzo_point_value AS mzo_point_value_32, e0_.user_created AS user_created_33, e0_.user_changed AS user_changed_34, e0_.institution AS institution_35, e0_.education_manager AS education_manager_36, e0_.school_year AS school_year_37, e0_.school_list AS school_list_38, e0_.form_of_education AS form_of_education_39, e0_.method_of_implementation AS method_of_implementation_40 FROM education e0_ WHERE e0_.name LIKE '%Od%kompetencija%do%ishoda%oblikovanje%izvedbenog%kurikula%u%modularnoj%nastavi%' AND e0_.active = 1;

SELECT
  e0_.id AS id_0,
  e0_.date_created AS date_created_1,
  e0_.date_changed AS date_changed_2,
  e0_.active AS active_3,
  e0_.name AS name_4,
  e0_.label AS label_5,
  e0_.status AS status_6,
  e0_.number_of_seats AS number_of_seats_7,
  e0_.duration AS duration_8,
  e0_.education_area AS education_area_9,
  e0_.target_group AS target_group_10,
  e0_.event_location AS event_location_11,
  e0_.education_description AS education_description_12,
  e0_.outcomes AS outcomes_13,
  e0_.keywords AS keywords_14,
  e0_.image AS image_15,
  e0_.time_of_maintenance AS time_of_maintenance_16,
  e0_.implementation_requirements AS implementation_requirements_17,
  e0_.document AS document_18,
  e0_.original_name AS original_name_19,
  e0_.planned_realization_date AS planned_realization_date_20,
  e0_.full_document_path AS full_document_path_21,
  e0_.educator_certificate_document_name AS educator_certificate_document_name_22,
  e0_.educator_certificate_document_path AS educator_certificate_document_path_23,
  e0_.educator_census_lists_name AS educator_census_lists_name_24,
  e0_.educator_census_list_path AS educator_census_list_path_25,
  e0_.educator_document AS educator_document_26,
  e0_.census_list AS census_list_27,
  e0_.remark AS remark_28,
  e0_.educator_mzo_point_name AS educator_mzo_point_name_29,
  e0_.educator_mzo_point_value AS educator_mzo_point_value_30,
  e0_.mzo_point_name AS mzo_point_name_31,
  e0_.mzo_point_value AS mzo_point_value_32,
  e0_.user_created AS user_created_33,
  e0_.user_changed AS user_changed_34,
  e0_.institution AS institution_35,
  e0_.education_manager AS education_manager_36,
  e0_.school_year AS school_year_37,
  e0_.school_list AS school_list_38,
  e0_.form_of_education AS form_of_education_39,
  e0_.method_of_implementation AS method_of_implementation_40
FROM
  education e0_
WHERE
  e0_.name LIKE ?
  AND e0_.institution = ?
  AND e0_.label = ?
  AND e0_.active = ?

SELECT e0_.id AS id_0, e0_.date_created AS date_created_1, e0_.date_changed AS date_changed_2, e0_.active AS active_3, e0_.name AS name_4, e0_.label AS label_5, e0_.status AS status_6, e0_.number_of_seats AS number_of_seats_7, e0_.duration AS duration_8, e0_.education_area AS education_area_9, e0_.target_group AS target_group_10, e0_.event_location AS event_location_11, e0_.education_description AS education_description_12, e0_.outcomes AS outcomes_13, e0_.keywords AS keywords_14, e0_.image AS image_15, e0_.time_of_maintenance AS time_of_maintenance_16, e0_.implementation_requirements AS implementation_requirements_17, e0_.document AS document_18, e0_.original_name AS original_name_19, e0_.planned_realization_date AS planned_realization_date_20, e0_.full_document_path AS full_document_path_21, e0_.educator_certificate_document_name AS educator_certificate_document_name_22, e0_.educator_certificate_document_path AS educator_certificate_document_path_23, e0_.educator_census_lists_name AS educator_census_lists_name_24, e0_.educator_census_list_path AS educator_census_list_path_25, e0_.educator_document AS educator_document_26, e0_.census_list AS census_list_27, e0_.remark AS remark_28, e0_.educator_mzo_point_name AS educator_mzo_point_name_29, e0_.educator_mzo_point_value AS educator_mzo_point_value_30, e0_.mzo_point_name AS mzo_point_name_31, e0_.mzo_point_value AS mzo_point_value_32, e0_.user_created AS user_created_33, e0_.user_changed AS user_changed_34, e0_.institution AS institution_35, e0_.education_manager AS education_manager_36, e0_.school_year AS school_year_37, e0_.school_list AS school_list_38, e0_.form_of_education AS form_of_education_39, e0_.method_of_implementation AS method_of_implementation_40 FROM education e0_ WHERE e0_.name LIKE '%Od%kompetencija%do%ishoda%oblikovanje%izvedbenog%kurikula%u%modularnoj%nastavi%' AND e0_.institution = 1 AND e0_.label = 'Modularna' AND e0_.active = 1;

SELECT
  p0_.name AS name_0,
  p0_.description AS description_1,
  s1_.name AS name_2,
  s1_.value AS value_3
FROM
  education e2_
  INNER JOIN education_point e3_ ON e2_.id = e3_.education
  INNER JOIN point p0_ ON e3_.point = p0_.id
  INNER JOIN education_subtable_point e4_ ON e3_.id = e4_.education_point
  INNER JOIN subtable_point s1_ ON e4_.subtable_point = s1_.id
WHERE
  e2_.active = ?
  AND e2_.id = ?

SELECT p0_.name AS name_0, p0_.description AS description_1, s1_.name AS name_2, s1_.value AS value_3 FROM education e2_ INNER JOIN education_point e3_ ON e2_.id = e3_.education INNER JOIN point p0_ ON e3_.point = p0_.id INNER JOIN education_subtable_point e4_ ON e3_.id = e4_.education_point INNER JOIN subtable_point s1_ ON e4_.subtable_point = s1_.id WHERE e2_.active = 1 AND e2_.id = 332;

SELECT
  i0_.id AS id_0,
  i0_.date_created AS date_created_1,
  i0_.date_changed AS date_changed_2,
  i0_.active AS active_3,
  i0_.name AS name_4,
  i0_.label AS label_5,
  i0_.color AS color_6,
  i0_.oib AS oib_7,
  i0_.address AS address_8,
  i0_.place AS place_9,
  i0_.country AS country_10,
  i0_.contact_phone AS contact_phone_11,
  i0_.contact_email AS contact_email_12,
  i0_.web_page AS web_page_13,
  i0_.additional_data AS additional_data_14,
  i0_.is_pdv AS is_pdv_15,
  i0_.user_created AS user_created_16,
  i0_.user_changed AS user_changed_17,
  i0_.legal_entity AS legal_entity_18
FROM
  institution i0_
WHERE
  i0_.name LIKE ?
  AND i0_.active = ?

SELECT i0_.id AS id_0, i0_.date_created AS date_created_1, i0_.date_changed AS date_changed_2, i0_.active AS active_3, i0_.name AS name_4, i0_.label AS label_5, i0_.color AS color_6, i0_.oib AS oib_7, i0_.address AS address_8, i0_.place AS place_9, i0_.country AS country_10, i0_.contact_phone AS contact_phone_11, i0_.contact_email AS contact_email_12, i0_.web_page AS web_page_13, i0_.additional_data AS additional_data_14, i0_.is_pdv AS is_pdv_15, i0_.user_created AS user_created_16, i0_.user_changed AS user_changed_17, i0_.legal_entity AS legal_entity_18 FROM institution i0_ WHERE i0_.name LIKE '%Centar%izvrsnosti%Splitsko%dalmatinske%zupanije%' AND i0_.active = 1;

SELECT
  t0.id AS id_1,
  t0.date_created AS date_created_2,
  t0.date_changed AS date_changed_3,
  t0.active AS active_4,
  t0.status AS status_5,
  t0.ordinal_number_on_education AS ordinal_number_on_education_6,
  t0.full_certificate_path AS full_certificate_path_7,
  t0.user_created AS user_created_8,
  t0.user_changed AS user_changed_9,
  t0.education AS education_10,
  t0.rating AS rating_11,
  t0.participant AS participant_12,
  t13.id AS id_14,
  t13.email AS email_15,
  t13.bank AS bank_16,
  t13.iban AS iban_17,
  t13.roles AS roles_18,
  t13.password AS password_19,
  t13.first_name AS first_name_20,
  t13.last_name AS last_name_21,
  t13.registration_token AS registration_token_22,
  t13.password_reset_token AS password_reset_token_23,
  t13.image AS image_24,
  t13.oib AS oib_25,
  t13.gender AS gender_26,
  t13.date_of_birth AS date_of_birth_27,
  t13.phone AS phone_28,
  t13.address AS address_29,
  t13.place AS place_30,
  t13.menu_visibility AS menu_visibility_31,
  t13.active AS active_32,
  t13.professional_qualification AS professional_qualification_33
FROM
  education_participant t0
  LEFT JOIN user t13 ON t0.participant = t13.id
WHERE
  t0.education = ?

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.status AS status_5, t0.ordinal_number_on_education AS ordinal_number_on_education_6, t0.full_certificate_path AS full_certificate_path_7, t0.user_created AS user_created_8, t0.user_changed AS user_changed_9, t0.education AS education_10, t0.rating AS rating_11, t0.participant AS participant_12, t13.id AS id_14, t13.email AS email_15, t13.bank AS bank_16, t13.iban AS iban_17, t13.roles AS roles_18, t13.password AS password_19, t13.first_name AS first_name_20, t13.last_name AS last_name_21, t13.registration_token AS registration_token_22, t13.password_reset_token AS password_reset_token_23, t13.image AS image_24, t13.oib AS oib_25, t13.gender AS gender_26, t13.date_of_birth AS date_of_birth_27, t13.phone AS phone_28, t13.address AS address_29, t13.place AS place_30, t13.menu_visibility AS menu_visibility_31, t13.active AS active_32, t13.professional_qualification AS professional_qualification_33 FROM education_participant t0 LEFT JOIN user t13 ON t0.participant = t13.id WHERE t0.education = 332;

SELECT
  e0_.id AS id_0,
  e0_.status AS status_1,
  i1_.name AS name_2,
  u2_.first_name AS first_name_3,
  u2_.last_name AS last_name_4
FROM
  education e3_
  INNER JOIN education_participant e0_ ON e3_.id = e0_.education
  INNER JOIN user u2_ ON e0_.participant = u2_.id
  LEFT JOIN institution_rating i1_ ON e0_.rating = i1_.id
WHERE
  e3_.active = ?
  AND e3_.id = ?

SELECT e0_.id AS id_0, e0_.status AS status_1, i1_.name AS name_2, u2_.first_name AS first_name_3, u2_.last_name AS last_name_4 FROM education e3_ INNER JOIN education_participant e0_ ON e3_.id = e0_.education INNER JOIN user u2_ ON e0_.participant = u2_.id LEFT JOIN institution_rating i1_ ON e0_.rating = i1_.id WHERE e3_.active = 1 AND e3_.id = 332;

SELECT
  u0_.first_name AS first_name_0,
  u0_.last_name AS last_name_1
FROM
  education e1_
  INNER JOIN education_educator e2_ ON e1_.id = e2_.education
  INNER JOIN user u0_ ON e2_.education_manager = u0_.id
WHERE
  e1_.active = ?
  AND e1_.id = ?

SELECT u0_.first_name AS first_name_0, u0_.last_name AS last_name_1 FROM education e1_ INNER JOIN education_educator e2_ ON e1_.id = e2_.education INNER JOIN user u0_ ON e2_.education_manager = u0_.id WHERE e1_.active = 1 AND e1_.id = 332;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.bank AS bank_3,
  t0.iban AS iban_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.registration_token AS registration_token_9,
  t0.password_reset_token AS password_reset_token_10,
  t0.image AS image_11,
  t0.oib AS oib_12,
  t0.gender AS gender_13,
  t0.date_of_birth AS date_of_birth_14,
  t0.phone AS phone_15,
  t0.address AS address_16,
  t0.place AS place_17,
  t0.menu_visibility AS menu_visibility_18,
  t0.active AS active_19,
  t0.professional_qualification AS professional_qualification_20
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.bank AS bank_3, t0.iban AS iban_4, t0.roles AS roles_5, t0.password AS password_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.registration_token AS registration_token_9, t0.password_reset_token AS password_reset_token_10, t0.image AS image_11, t0.oib AS oib_12, t0.gender AS gender_13, t0.date_of_birth AS date_of_birth_14, t0.phone AS phone_15, t0.address AS address_16, t0.place AS place_17, t0.menu_visibility AS menu_visibility_18, t0.active AS active_19, t0.professional_qualification AS professional_qualification_20 FROM user t0 WHERE t0.id = 41;

SELECT
  COUNT(*)
FROM
  education_educator t0
WHERE
  t0.education = ?

SELECT COUNT(*) FROM education_educator t0 WHERE t0.education = 332;

SELECT
  COUNT(*)
FROM
  education_point t0
WHERE
  t0.education = ?

SELECT COUNT(*) FROM education_point t0 WHERE t0.education = 332;

SELECT
  t0.id AS id_1,
  t0.date_created AS date_created_2,
  t0.date_changed AS date_changed_3,
  t0.active AS active_4,
  t0.name AS name_5,
  t0.category AS category_6,
  t0.place AS place_7,
  t0.address AS address_8,
  t0.zip_code AS zip_code_9,
  t0.slug AS slug_10,
  t0.user_created AS user_created_11,
  t0.user_changed AS user_changed_12
FROM
  school_list t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.name AS name_5, t0.category AS category_6, t0.place AS place_7, t0.address AS address_8, t0.zip_code AS zip_code_9, t0.slug AS slug_10, t0.user_created AS user_created_11, t0.user_changed AS user_changed_12 FROM school_list t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.date_created AS date_created_2,
  t0.date_changed AS date_changed_3,
  t0.active AS active_4,
  t0.name AS name_5,
  t0.start_date AS start_date_6,
  t0.end_date AS end_date_7,
  t0.user_created AS user_created_8,
  t0.user_changed AS user_changed_9,
  t0.institution AS institution_10
FROM
  school_year t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.name AS name_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.user_created AS user_created_8, t0.user_changed AS user_changed_9, t0.institution AS institution_10 FROM school_year t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.date_created AS date_created_2,
  t0.date_changed AS date_changed_3,
  t0.active AS active_4,
  t0.name AS name_5,
  t0.user_created AS user_created_6,
  t0.user_changed AS user_changed_7,
  t0.institution AS institution_8
FROM
  method_of_implementation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.name AS name_5, t0.user_created AS user_created_6, t0.user_changed AS user_changed_7, t0.institution AS institution_8 FROM method_of_implementation t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.date_created AS date_created_2,
  t0.date_changed AS date_changed_3,
  t0.active AS active_4,
  t0.name AS name_5,
  t0.user_created AS user_created_6,
  t0.user_changed AS user_changed_7,
  t0.institution AS institution_8
FROM
  form_of_education t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.name AS name_5, t0.user_created AS user_created_6, t0.user_changed AS user_changed_7, t0.institution AS institution_8 FROM form_of_education t0 WHERE t0.id = 1;