Symfony Profiler

SELECT
  ift.id AS ifid,
  ift.interest_name AS ifname,
  COUNT(*) AS num
FROM
  trophy_count AS tc
  LEFT JOIN job AS j ON tc.item_id = j.id
  LEFT JOIN school_class_client AS scc ON tc.school_class_client_id = scc.id
  LEFT JOIN school_class AS sc ON scc.school_class_id = sc.id
  LEFT JOIN job_interest_field_mapping AS jifm ON jifm.job_id = j.id
  LEFT JOIN interest_field AS ift ON jifm.interest_field_id = ift.id
WHERE
  sc.school_id = :sid
  AND tc.trophy_item_type_id = 4
  AND jifm.interest_field_id IS NOT NULL
GROUP BY
  ift.id
ORDER BY
  num DESC

SELECT ift.id AS ifid, ift.interest_name AS ifname, COUNT(*) AS num FROM trophy_count AS tc LEFT JOIN job AS j ON tc.item_id=j.id LEFT JOIN school_class_client AS scc ON tc.school_class_client_id=scc.id LEFT JOIN school_class AS sc ON scc.school_class_id=sc.id LEFT JOIN job_interest_field_mapping AS jifm ON jifm.job_id=j.id LEFT JOIN interest_field AS ift ON jifm.interest_field_id=ift.id WHERE sc.school_id=465 AND tc.trophy_item_type_id=4 AND jifm.interest_field_id IS NOT NULL GROUP BY ift.id ORDER BY num DESC;

SELECT
  t0.identifier AS identifier_1,
  t0.expiry AS expiry_2,
  t0.user_identifier AS user_identifier_3,
  t0.scopes AS scopes_4,
  t0.revoked AS revoked_5,
  t0.client AS client_6
FROM
  oauth2_access_token t0
WHERE
  t0.identifier = ?

SELECT t0.identifier AS identifier_1, t0.expiry AS expiry_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.revoked AS revoked_5, t0.client AS client_6 FROM oauth2_access_token t0 WHERE t0.identifier = 'fb111dfc33c1d7371256846d2d65dc5fe7591870750194194abe0c68ea0f40d069723732e3bfe74c';

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.training_information AS training_information_5,
  t0.certificate_information AS certificate_information_6,
  t0.url AS url_7,
  t0.click_count AS click_count_8,
  t0.is_visible AS is_visible_9,
  t0.school_id AS school_id_10,
  t0.communication_id AS communication_id_11,
  t0.gallery_id AS gallery_id_12,
  t13.id AS id_14,
  t13.context AS context_15,
  t13.name AS name_16,
  t13.default_format AS default_format_17,
  t13.enabled AS enabled_18,
  t13.updated_at AS updated_at_19,
  t13.created_at AS created_at_20,
  t13.owner_id AS owner_id_21,
  t13.media_gallery_category_id AS media_gallery_category_id_22,
  t0.video_gallery_id AS video_gallery_id_23,
  t24.id AS id_25,
  t24.context AS context_26,
  t24.name AS name_27,
  t24.default_format AS default_format_28,
  t24.enabled AS enabled_29,
  t24.updated_at AS updated_at_30,
  t24.created_at AS created_at_31,
  t24.owner_id AS owner_id_32,
  t24.media_gallery_category_id AS media_gallery_category_id_33,
  t0.document_gallery_id AS document_gallery_id_34,
  t35.id AS id_36,
  t35.context AS context_37,
  t35.name AS name_38,
  t35.default_format AS default_format_39,
  t35.enabled AS enabled_40,
  t35.updated_at AS updated_at_41,
  t35.created_at AS created_at_42,
  t35.owner_id AS owner_id_43,
  t35.media_gallery_category_id AS media_gallery_category_id_44,
  t0.contact_gallery_id AS contact_gallery_id_45,
  t46.id AS id_47,
  t46.is_visible AS is_visible_48,
  t0.profile_picture_id AS profile_picture_id_49,
  t50.id AS id_51,
  t50.name AS name_52,
  t50.copyright AS copyright_53,
  t50.provider_name AS provider_name_54,
  t50.provider_reference AS provider_reference_55,
  t50.provider_metadata AS provider_metadata_56,
  t50.content_type AS content_type_57,
  t50.context AS context_58,
  t50.updated_at AS updated_at_59,
  t50.created_at AS created_at_60,
  t50.owner_id AS owner_id_61,
  t50.document_type AS document_type_62,
  t0.header_picture_id AS header_picture_id_63,
  t64.id AS id_65,
  t64.name AS name_66,
  t64.copyright AS copyright_67,
  t64.provider_name AS provider_name_68,
  t64.provider_reference AS provider_reference_69,
  t64.provider_metadata AS provider_metadata_70,
  t64.content_type AS content_type_71,
  t64.context AS context_72,
  t64.updated_at AS updated_at_73,
  t64.created_at AS created_at_74,
  t64.owner_id AS owner_id_75,
  t64.document_type AS document_type_76,
  t0.profile_link_id AS profile_link_id_77
FROM
  school_profile t0
  LEFT JOIN media__gallery t13 ON t0.gallery_id = t13.id
  LEFT JOIN media__gallery t24 ON t0.video_gallery_id = t24.id
  LEFT JOIN media__gallery t35 ON t0.document_gallery_id = t35.id
  LEFT JOIN contact_gallery t46 ON t0.contact_gallery_id = t46.id
  LEFT JOIN media__media t50 ON t0.profile_picture_id = t50.id
  LEFT JOIN media__media t64 ON t0.header_picture_id = t64.id
WHERE
  t0.school_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.description AS description_4, t0.training_information AS training_information_5, t0.certificate_information AS certificate_information_6, t0.url AS url_7, t0.click_count AS click_count_8, t0.is_visible AS is_visible_9, t0.school_id AS school_id_10, t0.communication_id AS communication_id_11, t0.gallery_id AS gallery_id_12, t13.id AS id_14, t13.context AS context_15, t13.name AS name_16, t13.default_format AS default_format_17, t13.enabled AS enabled_18, t13.updated_at AS updated_at_19, t13.created_at AS created_at_20, t13.owner_id AS owner_id_21, t13.media_gallery_category_id AS media_gallery_category_id_22, t0.video_gallery_id AS video_gallery_id_23, t24.id AS id_25, t24.context AS context_26, t24.name AS name_27, t24.default_format AS default_format_28, t24.enabled AS enabled_29, t24.updated_at AS updated_at_30, t24.created_at AS created_at_31, t24.owner_id AS owner_id_32, t24.media_gallery_category_id AS media_gallery_category_id_33, t0.document_gallery_id AS document_gallery_id_34, t35.id AS id_36, t35.context AS context_37, t35.name AS name_38, t35.default_format AS default_format_39, t35.enabled AS enabled_40, t35.updated_at AS updated_at_41, t35.created_at AS created_at_42, t35.owner_id AS owner_id_43, t35.media_gallery_category_id AS media_gallery_category_id_44, t0.contact_gallery_id AS contact_gallery_id_45, t46.id AS id_47, t46.is_visible AS is_visible_48, t0.profile_picture_id AS profile_picture_id_49, t50.id AS id_51, t50.name AS name_52, t50.copyright AS copyright_53, t50.provider_name AS provider_name_54, t50.provider_reference AS provider_reference_55, t50.provider_metadata AS provider_metadata_56, t50.content_type AS content_type_57, t50.context AS context_58, t50.updated_at AS updated_at_59, t50.created_at AS created_at_60, t50.owner_id AS owner_id_61, t50.document_type AS document_type_62, t0.header_picture_id AS header_picture_id_63, t64.id AS id_65, t64.name AS name_66, t64.copyright AS copyright_67, t64.provider_name AS provider_name_68, t64.provider_reference AS provider_reference_69, t64.provider_metadata AS provider_metadata_70, t64.content_type AS content_type_71, t64.context AS context_72, t64.updated_at AS updated_at_73, t64.created_at AS created_at_74, t64.owner_id AS owner_id_75, t64.document_type AS document_type_76, t0.profile_link_id AS profile_link_id_77 FROM school_profile t0 LEFT JOIN media__gallery t13 ON t0.gallery_id = t13.id LEFT JOIN media__gallery t24 ON t0.video_gallery_id = t24.id LEFT JOIN media__gallery t35 ON t0.document_gallery_id = t35.id LEFT JOIN contact_gallery t46 ON t0.contact_gallery_id = t46.id LEFT JOIN media__media t50 ON t0.profile_picture_id = t50.id LEFT JOIN media__media t64 ON t0.header_picture_id = t64.id WHERE t0.school_id = 465;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.username AS username_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7,
  t0.last_login AS last_login_8,
  t9.id AS id_10,
  t9.created_at AS created_at_11,
  t9.user_id AS user_id_12,
  t9.media_id AS media_id_13,
  t14.id AS id_15,
  t14.created_at AS created_at_16,
  t14.changed_at AS changed_at_17,
  t14.user_id AS user_id_18,
  t14.selected_user_role_id AS selected_user_role_id_19,
  t20.id AS id_21,
  t20.changed_at AS changed_at_22,
  t20.user_id AS user_id_23,
  t20.person_id AS person_id_24,
  t20.address_id AS address_id_25,
  t20.communication_id AS communication_id_26
FROM
  user t0
  LEFT JOIN user_avatar t9 ON t9.user_id = t0.id
  LEFT JOIN user_setting t14 ON t14.user_id = t0.id
  LEFT JOIN user_data t20 ON t20.user_id = t0.id
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.username AS username_3, t0.password AS password_4, t0.email AS email_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.last_login AS last_login_8, t9.id AS id_10, t9.created_at AS created_at_11, t9.user_id AS user_id_12, t9.media_id AS media_id_13, t14.id AS id_15, t14.created_at AS created_at_16, t14.changed_at AS changed_at_17, t14.user_id AS user_id_18, t14.selected_user_role_id AS selected_user_role_id_19, t20.id AS id_21, t20.changed_at AS changed_at_22, t20.user_id AS user_id_23, t20.person_id AS person_id_24, t20.address_id AS address_id_25, t20.communication_id AS communication_id_26 FROM user t0 LEFT JOIN user_avatar t9 ON t9.user_id = t0.id LEFT JOIN user_setting t14 ON t14.user_id = t0.id LEFT JOIN user_data t20 ON t20.user_id = t0.id WHERE t0.uuid = '4d0b06f4-a271-11ef-a2cf-fa163eb4db24' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.school_number AS school_number_2,
  s0_.url AS url_3,
  s0_.is_active AS is_active_4,
  s0_.created_at AS created_at_5,
  s0_.communication_id AS communication_id_6,
  s0_.address_id AS address_id_7
FROM
  school s0_
  INNER JOIN school_teacher_mapping s1_
WHERE
  s1_.school_id = s0_.id
  AND s1_.user_id = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.school_number AS school_number_2, s0_.url AS url_3, s0_.is_active AS is_active_4, s0_.created_at AS created_at_5, s0_.communication_id AS communication_id_6, s0_.address_id AS address_id_7 FROM school s0_ INNER JOIN school_teacher_mapping s1_ WHERE s1_.school_id = s0_.id AND s1_.user_id = 4772;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  user_role t0
  INNER JOIN user_role_mapping ON t0.id = user_role_mapping.user_role_id
WHERE
  user_role_mapping.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM user_role t0 INNER JOIN user_role_mapping ON t0.id = user_role_mapping.user_role_id WHERE user_role_mapping.user_id = 4772;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.sex AS sex_4,
  t0.birthday AS birthday_5
FROM
  person t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.sex AS sex_4, t0.birthday AS birthday_5 FROM person t0 WHERE t0.id IN (6116);

SELECT
  t0.id AS id_1,
  t0.interest_name AS interest_name_2,
  t0.sub_heading AS sub_heading_3
FROM
  interest_field t0

SELECT t0.id AS id_1, t0.interest_name AS interest_name_2, t0.sub_heading AS sub_heading_3 FROM interest_field t0;