Symfony Profiler

SELECT
  o.occurrence_id AS occurrence_id,
  t.tag AS tag_id,
  t.tag AS tag_name,
  et.event_type_id AS event_type_id,
  et.event_type_name AS event_type_name,
  g.group_id AS group_id,
  g.group_name AS group_name,
  b.building_id AS building_id,
  b.building_name AS building_name
FROM
  occurrence o
  STRAIGHT_JOIN event e ON e.event_id = o.event_id
  LEFT JOIN brd AS b ON b.building_id = o.building_id
  LEFT JOIN tag AS t ON t.event_id = e.event_id
  LEFT JOIN events_groups AS eg ON e.event_id = eg.event_id
  LEFT JOIN `group` AS g ON eg.group_id = g.group_id
  LEFT JOIN event_feature AS f ON e.event_id = f.event_id
  JOIN event_type AS et ON e.event_type_id = et.event_type_id
WHERE
  (
    (
      o.date_start >= ?
      AND o.date_start <= ?
    )
    OR (
      o.date_start >= ?
      AND o.date_start <= ?
    )
  )
  AND eg.admin_status != 'denied'
  AND (
    b.building_id > 1
    AND b.lat != ""
    AND b.lng != ""
  )
  AND e.archived = 0
  AND e.cancelled = 0
  AND e.unpublished = 0
  AND (
    e.prominent = 1
    OR e.prominent IS NULL
  )
  AND (
    e.status = 'active'
    OR e.status = 'approved'
  )

SELECT o.occurrence_id AS occurrence_id,
                    t.tag AS tag_id, t.tag AS tag_name,
                    et.event_type_id AS event_type_id, et.event_type_name AS event_type_name,
                    g.group_id AS group_id, g.group_name AS group_name,
                    b.building_id AS building_id, b.building_name AS building_name
            FROM occurrence o
            STRAIGHT_JOIN event e ON e.event_id=o.event_id
            LEFT JOIN brd AS b ON b.building_id=o.building_id
            LEFT JOIN tag AS t ON t.event_id=e.event_id
            LEFT JOIN events_groups AS eg ON e.event_id=eg.event_id
            LEFT JOIN `group` AS g ON eg.group_id=g.group_id
            LEFT JOIN event_feature AS f ON e.event_id=f.event_id
            JOIN event_type AS et ON e.event_type_id=et.event_type_id
            WHERE ((o.date_start>='2026-06-13 00:00:00' AND o.date_start<='2026-06-27 23:59:59')
                  OR (o.date_start>='2026-06-13 00:00:00' AND o.date_start<='2026-06-27 23:59:59'))
            AND eg.admin_status!='denied'
             AND (b.building_id>1 AND b.lat!="" AND b.lng!="")
             AND  e.archived=0 AND e.cancelled=0 AND e.unpublished=0 AND (e.prominent=1 OR e.prominent IS NULL) AND (e.status='active' OR e.status='approved') 
            
            ;

SELECT
  o0_.occurrence_id AS occurrence_id_0,
  o0_.event_id AS event_id_1,
  o0_.occurrence_name AS occurrence_name_2,
  o0_.date_start AS date_start_3,
  o0_.date_end AS date_end_4,
  o0_.no_start_time AS no_start_time_5,
  o0_.no_end_time AS no_end_time_6,
  o0_.notes AS notes_7,
  o0_.location AS location_8,
  o0_.campus_id AS campus_id_9,
  o0_.building_id AS building_id_10,
  o0_.room AS room_11,
  o0_.recurrence_id AS recurrence_id_12,
  o0_.livestream_type AS livestream_type_13,
  o0_.livestream_id AS livestream_id_14,
  o0_.livestream_require_login AS livestream_require_login_15,
  o0_.livestream_password AS livestream_password_16,
  o0_.livestream_custom_link AS livestream_custom_link_17,
  o0_.session_session_id AS session_session_id_18,
  o0_.session_event_id AS session_event_id_19,
  e1_.event_id AS event_id_20,
  e1_.event_name AS event_name_21,
  e1_.subtitle AS subtitle_22,
  e1_.date_created AS date_created_23,
  e1_.creator_uniqname AS creator_uniqname_24,
  e1_.date_modified AS date_modified_25,
  e1_.last_uniqname AS last_uniqname_26,
  e1_.date_moderated AS date_moderated_27,
  e1_.moderator_uniqname AS moderator_uniqname_28,
  e1_.description AS description_29,
  e1_.website AS website_30,
  e1_.event_type_id AS event_type_id_31,
  e1_.academic_type AS academic_type_32,
  e1_.prominent AS prominent_33,
  e1_.status AS status_34,
  e1_.cancelled AS cancelled_35,
  e1_.archived AS archived_36,
  e1_.provider_id AS provider_id_37,
  e1_.provider_event_id AS provider_event_id_38,
  e1_.unpublished AS unpublished_39,
  e1_.cost AS cost_40,
  e1_.from_cl_import AS from_cl_import_41,
  e1_.cl_id AS cl_id_42,
  e1_.from_ics_feed_import AS from_ics_feed_import_43,
  e1_.ics_feed_id AS ics_feed_id_44,
  e1_.ics_feed_uid AS ics_feed_uid_45,
  e1_.occurrence_count AS occurrence_count_46,
  e1_.first_occurrence_id AS first_occurrence_id_47,
  e1_.total_views AS total_views_48,
  e1_.views_from_search AS views_from_search_49,
  e1_.views_from_external_website AS views_from_external_website_50,
  e1_.from_json_feed_import AS from_json_feed_import_51,
  e1_.json_feed_provider_last_updated AS json_feed_provider_last_updated_52,
  e1_.sessions_rsvp_id AS sessions_rsvp_id_53,
  e1_.sessions_rsvp_show_link AS sessions_rsvp_show_link_54,
  e1_.revision AS revision_55,
  e1_.tessitura_performance_id AS tessitura_performance_id_56,
  e1_.tessitura_updated_date AS tessitura_updated_date_57,
  e1_.session_track_id AS session_track_id_58,
  e1_.session_updated_date AS session_updated_date_59,
  e1_.expired AS expired_60,
  e2_.event_type_id AS event_type_id_61,
  e2_.event_type_name AS event_type_name_62,
  e2_.active AS active_63,
  t3_.tag AS tag_64,
  t3_.requested AS requested_65,
  t3_.request_pending AS request_pending_66,
  t3_.requested_by_uniqname AS requested_by_uniqname_67,
  t3_.requested_date AS requested_date_68,
  t3_.requested_notification_sent AS requested_notification_sent_69,
  a4_.attachment_id AS attachment_id_70,
  a4_.foreign_id AS foreign_id_71,
  a4_.original_name AS original_name_72,
  a4_.signoff AS signoff_73,
  a4_.attachment_extension AS attachment_extension_74,
  a4_.attachment_description AS attachment_description_75,
  a4_.attachment_path AS attachment_path_76,
  a4_.is_cropped AS is_cropped_77,
  a4_.crop_x AS crop_x_78,
  a4_.crop_y AS crop_y_79,
  a4_.crop_w AS crop_w_80,
  a4_.crop_h AS crop_h_81,
  a4_.from_photo_library AS from_photo_library_82,
  a4_.dim_x AS dim_x_83,
  a4_.dim_y AS dim_y_84,
  a4_.unsplash_credit_author AS unsplash_credit_author_85,
  a4_.unsplash_credit_link AS unsplash_credit_link_86,
  a4_.revision AS revision_87,
  a4_.remote_timestamp AS remote_timestamp_88,
  b5_.building_id AS building_id_89,
  b5_.campus_id AS campus_id_90,
  b5_.building_name AS building_name_91,
  b5_.official_id AS official_id_92,
  b5_.address AS address_93,
  b5_.city AS city_94,
  b5_.state AS state_95,
  b5_.zip AS zip_96,
  b5_.acronym AS acronym_97,
  b5_.visible AS visible_98,
  b5_.lat AS lat_99,
  b5_.lng AS lng_100,
  b5_.campus_maps_name AS campus_maps_name_101,
  b5_.campus_maps_image AS campus_maps_image_102,
  b5_.campus_maps_slug AS campus_maps_slug_103,
  e6_.event_feature_id AS event_feature_id_104,
  e6_.region AS region_105,
  e6_.date_start AS date_start_106,
  e6_.date_end AS date_end_107,
  e6_.date_created AS date_created_108,
  e6_.creator_uniqname AS creator_uniqname_109,
  e7_.event_link_id AS event_link_id_110,
  e7_.link_type AS link_type_111,
  e7_.link_url AS link_url_112,
  e7_.link_title AS link_title_113,
  e7_.event_id AS event_id_114,
  e7_.from_group_link AS from_group_link_115,
  e8_.group_id AS group_id_116,
  e8_.event_id AS event_id_117,
  e8_.admin_level AS admin_level_118,
  e8_.admin_status AS admin_status_119,
  e8_.can_edit AS can_edit_120,
  g9_.group_id AS group_id_121,
  g9_.group_name AS group_name_122,
  g9_.shortname AS shortname_123,
  g9_.description AS description_124,
  g9_.website AS website_125,
  g9_.date_created AS date_created_126,
  g9_.date_modified AS date_modified_127,
  g9_.creator_uniqname AS creator_uniqname_128,
  g9_.last_uniqname AS last_uniqname_129,
  g9_.public AS public_130,
  g9_.status AS status_131,
  g9_.custom_theme AS custom_theme_132,
  g9_.provider_group_id AS provider_group_id_133,
  g9_.provider_id AS provider_id_134,
  g9_.contact_opt_out AS contact_opt_out_135,
  g9_.contact_email_override AS contact_email_override_136,
  g9_.cic_purged AS cic_purged_137,
  g9_.contact_sponsor_emails AS contact_sponsor_emails_138,
  a10_.attachment_id AS attachment_id_139,
  a10_.foreign_id AS foreign_id_140,
  a10_.original_name AS original_name_141,
  a10_.signoff AS signoff_142,
  a10_.attachment_extension AS attachment_extension_143,
  a10_.attachment_description AS attachment_description_144,
  a10_.attachment_path AS attachment_path_145,
  a10_.is_cropped AS is_cropped_146,
  a10_.crop_x AS crop_x_147,
  a10_.crop_y AS crop_y_148,
  a10_.crop_w AS crop_w_149,
  a10_.crop_h AS crop_h_150,
  a10_.from_photo_library AS from_photo_library_151,
  a10_.dim_x AS dim_x_152,
  a10_.dim_y AS dim_y_153,
  a10_.unsplash_credit_author AS unsplash_credit_author_154,
  a10_.unsplash_credit_link AS unsplash_credit_link_155,
  a10_.revision AS revision_156,
  a10_.remote_timestamp AS remote_timestamp_157,
  o0_.building_id AS building_id_158,
  o0_.event_id AS event_id_159,
  o0_.recurrence_id AS recurrence_id_160,
  e1_.cl_id AS cl_id_161,
  e1_.event_type_id AS event_type_id_162,
  e1_.ics_feed_id AS ics_feed_id_163,
  t3_.event_id AS event_id_164,
  a4_.relation AS relation_165,
  a4_.foreign_id AS foreign_id_166,
  e6_.event_id AS event_id_167,
  e7_.event_id AS event_id_168,
  e7_.from_group_link AS from_group_link_169,
  e8_.event_id AS event_id_170,
  e8_.group_id AS group_id_171,
  a10_.relation AS relation_172,
  a10_.foreign_id AS foreign_id_173
FROM
  occurrence o0_
  STRAIGHT_JOIN event e1_ ON o0_.event_id = e1_.event_id
  STRAIGHT_JOIN event_type e2_ ON e1_.event_type_id = e2_.event_type_id
  LEFT JOIN tag t3_ ON e1_.event_id = t3_.event_id
  LEFT JOIN attachment a4_ ON e1_.event_id = a4_.foreign_id
  AND a4_.relation IN ('event')
  LEFT JOIN brd b5_ ON o0_.building_id = b5_.building_id
  LEFT JOIN event_feature e6_ ON e1_.event_id = e6_.event_id
  LEFT JOIN event_link e7_ ON e1_.event_id = e7_.event_id
  LEFT JOIN events_groups e8_ ON e1_.event_id = e8_.event_id
  LEFT JOIN `group` g9_ ON e8_.group_id = g9_.group_id
  LEFT JOIN attachment a10_ ON g9_.group_id = a10_.foreign_id
  AND a10_.relation IN ('group')
WHERE
  (
    (
      o0_.date_start >= ?
      AND o0_.date_start <= ?
    )
    OR (
      o0_.date_end >= ?
      AND o0_.date_end <= ?
    )
  )
  AND e8_.admin_status <> 'denied'
  AND (
    b5_.building_id > 1
    AND b5_.lat <> ''
    AND b5_.lng <> ''
  )
  AND e1_.archived = 0
  AND e1_.cancelled = 0
  AND e1_.unpublished = 0
  AND (
    e1_.prominent = 1
    OR e1_.prominent IS NULL
  )
  AND (
    e1_.status = 'active'
    OR e1_.status = 'approved'
  )
ORDER BY
  o0_.date_start ASC,
  e1_.event_name ASC

SELECT o0_.occurrence_id AS occurrence_id_0, o0_.event_id AS event_id_1, o0_.occurrence_name AS occurrence_name_2, o0_.date_start AS date_start_3, o0_.date_end AS date_end_4, o0_.no_start_time AS no_start_time_5, o0_.no_end_time AS no_end_time_6, o0_.notes AS notes_7, o0_.location AS location_8, o0_.campus_id AS campus_id_9, o0_.building_id AS building_id_10, o0_.room AS room_11, o0_.recurrence_id AS recurrence_id_12, o0_.livestream_type AS livestream_type_13, o0_.livestream_id AS livestream_id_14, o0_.livestream_require_login AS livestream_require_login_15, o0_.livestream_password AS livestream_password_16, o0_.livestream_custom_link AS livestream_custom_link_17, o0_.session_session_id AS session_session_id_18, o0_.session_event_id AS session_event_id_19, e1_.event_id AS event_id_20, e1_.event_name AS event_name_21, e1_.subtitle AS subtitle_22, e1_.date_created AS date_created_23, e1_.creator_uniqname AS creator_uniqname_24, e1_.date_modified AS date_modified_25, e1_.last_uniqname AS last_uniqname_26, e1_.date_moderated AS date_moderated_27, e1_.moderator_uniqname AS moderator_uniqname_28, e1_.description AS description_29, e1_.website AS website_30, e1_.event_type_id AS event_type_id_31, e1_.academic_type AS academic_type_32, e1_.prominent AS prominent_33, e1_.status AS status_34, e1_.cancelled AS cancelled_35, e1_.archived AS archived_36, e1_.provider_id AS provider_id_37, e1_.provider_event_id AS provider_event_id_38, e1_.unpublished AS unpublished_39, e1_.cost AS cost_40, e1_.from_cl_import AS from_cl_import_41, e1_.cl_id AS cl_id_42, e1_.from_ics_feed_import AS from_ics_feed_import_43, e1_.ics_feed_id AS ics_feed_id_44, e1_.ics_feed_uid AS ics_feed_uid_45, e1_.occurrence_count AS occurrence_count_46, e1_.first_occurrence_id AS first_occurrence_id_47, e1_.total_views AS total_views_48, e1_.views_from_search AS views_from_search_49, e1_.views_from_external_website AS views_from_external_website_50, e1_.from_json_feed_import AS from_json_feed_import_51, e1_.json_feed_provider_last_updated AS json_feed_provider_last_updated_52, e1_.sessions_rsvp_id AS sessions_rsvp_id_53, e1_.sessions_rsvp_show_link AS sessions_rsvp_show_link_54, e1_.revision AS revision_55, e1_.tessitura_performance_id AS tessitura_performance_id_56, e1_.tessitura_updated_date AS tessitura_updated_date_57, e1_.session_track_id AS session_track_id_58, e1_.session_updated_date AS session_updated_date_59, e1_.expired AS expired_60, e2_.event_type_id AS event_type_id_61, e2_.event_type_name AS event_type_name_62, e2_.active AS active_63, t3_.tag AS tag_64, t3_.requested AS requested_65, t3_.request_pending AS request_pending_66, t3_.requested_by_uniqname AS requested_by_uniqname_67, t3_.requested_date AS requested_date_68, t3_.requested_notification_sent AS requested_notification_sent_69, a4_.attachment_id AS attachment_id_70, a4_.foreign_id AS foreign_id_71, a4_.original_name AS original_name_72, a4_.signoff AS signoff_73, a4_.attachment_extension AS attachment_extension_74, a4_.attachment_description AS attachment_description_75, a4_.attachment_path AS attachment_path_76, a4_.is_cropped AS is_cropped_77, a4_.crop_x AS crop_x_78, a4_.crop_y AS crop_y_79, a4_.crop_w AS crop_w_80, a4_.crop_h AS crop_h_81, a4_.from_photo_library AS from_photo_library_82, a4_.dim_x AS dim_x_83, a4_.dim_y AS dim_y_84, a4_.unsplash_credit_author AS unsplash_credit_author_85, a4_.unsplash_credit_link AS unsplash_credit_link_86, a4_.revision AS revision_87, a4_.remote_timestamp AS remote_timestamp_88, b5_.building_id AS building_id_89, b5_.campus_id AS campus_id_90, b5_.building_name AS building_name_91, b5_.official_id AS official_id_92, b5_.address AS address_93, b5_.city AS city_94, b5_.state AS state_95, b5_.zip AS zip_96, b5_.acronym AS acronym_97, b5_.visible AS visible_98, b5_.lat AS lat_99, b5_.lng AS lng_100, b5_.campus_maps_name AS campus_maps_name_101, b5_.campus_maps_image AS campus_maps_image_102, b5_.campus_maps_slug AS campus_maps_slug_103, e6_.event_feature_id AS event_feature_id_104, e6_.region AS region_105, e6_.date_start AS date_start_106, e6_.date_end AS date_end_107, e6_.date_created AS date_created_108, e6_.creator_uniqname AS creator_uniqname_109, e7_.event_link_id AS event_link_id_110, e7_.link_type AS link_type_111, e7_.link_url AS link_url_112, e7_.link_title AS link_title_113, e7_.event_id AS event_id_114, e7_.from_group_link AS from_group_link_115, e8_.group_id AS group_id_116, e8_.event_id AS event_id_117, e8_.admin_level AS admin_level_118, e8_.admin_status AS admin_status_119, e8_.can_edit AS can_edit_120, g9_.group_id AS group_id_121, g9_.group_name AS group_name_122, g9_.shortname AS shortname_123, g9_.description AS description_124, g9_.website AS website_125, g9_.date_created AS date_created_126, g9_.date_modified AS date_modified_127, g9_.creator_uniqname AS creator_uniqname_128, g9_.last_uniqname AS last_uniqname_129, g9_.public AS public_130, g9_.status AS status_131, g9_.custom_theme AS custom_theme_132, g9_.provider_group_id AS provider_group_id_133, g9_.provider_id AS provider_id_134, g9_.contact_opt_out AS contact_opt_out_135, g9_.contact_email_override AS contact_email_override_136, g9_.cic_purged AS cic_purged_137, g9_.contact_sponsor_emails AS contact_sponsor_emails_138, a10_.attachment_id AS attachment_id_139, a10_.foreign_id AS foreign_id_140, a10_.original_name AS original_name_141, a10_.signoff AS signoff_142, a10_.attachment_extension AS attachment_extension_143, a10_.attachment_description AS attachment_description_144, a10_.attachment_path AS attachment_path_145, a10_.is_cropped AS is_cropped_146, a10_.crop_x AS crop_x_147, a10_.crop_y AS crop_y_148, a10_.crop_w AS crop_w_149, a10_.crop_h AS crop_h_150, a10_.from_photo_library AS from_photo_library_151, a10_.dim_x AS dim_x_152, a10_.dim_y AS dim_y_153, a10_.unsplash_credit_author AS unsplash_credit_author_154, a10_.unsplash_credit_link AS unsplash_credit_link_155, a10_.revision AS revision_156, a10_.remote_timestamp AS remote_timestamp_157, o0_.building_id AS building_id_158, o0_.event_id AS event_id_159, o0_.recurrence_id AS recurrence_id_160, e1_.cl_id AS cl_id_161, e1_.event_type_id AS event_type_id_162, e1_.ics_feed_id AS ics_feed_id_163, t3_.event_id AS event_id_164, a4_.relation AS relation_165, a4_.foreign_id AS foreign_id_166, e6_.event_id AS event_id_167, e7_.event_id AS event_id_168, e7_.from_group_link AS from_group_link_169, e8_.event_id AS event_id_170, e8_.group_id AS group_id_171, a10_.relation AS relation_172, a10_.foreign_id AS foreign_id_173 FROM occurrence o0_ STRAIGHT_JOIN event e1_ ON o0_.event_id = e1_.event_id STRAIGHT_JOIN event_type e2_ ON e1_.event_type_id = e2_.event_type_id LEFT JOIN tag t3_ ON e1_.event_id = t3_.event_id LEFT JOIN attachment a4_ ON e1_.event_id = a4_.foreign_id AND a4_.relation IN ('event') LEFT JOIN brd b5_ ON o0_.building_id = b5_.building_id LEFT JOIN event_feature e6_ ON e1_.event_id = e6_.event_id LEFT JOIN event_link e7_ ON e1_.event_id = e7_.event_id LEFT JOIN events_groups e8_ ON e1_.event_id = e8_.event_id LEFT JOIN `group` g9_ ON e8_.group_id = g9_.group_id LEFT JOIN attachment a10_ ON g9_.group_id = a10_.foreign_id AND a10_.relation IN ('group') WHERE ((o0_.date_start >= '2026-06-13 00:00:00' AND o0_.date_start <= '2026-06-27 23:59:59') OR (o0_.date_end >= '2026-06-13 00:00:00' AND o0_.date_end <= '2026-06-27 23:59:59')) AND e8_.admin_status <> 'denied' AND (b5_.building_id > 1 AND b5_.lat <> '' AND b5_.lng <> '') AND e1_.archived = 0 AND e1_.cancelled = 0 AND e1_.unpublished = 0 AND (e1_.prominent = 1 OR e1_.prominent IS NULL) AND (e1_.status = 'active' OR e1_.status = 'approved') ORDER BY o0_.date_start ASC, e1_.event_name ASC;