GET https://events-rvandael.studentlife.umich.edu/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CFeedbackController%253A%253An…

Response
200 OK
IP
172.69.17.53
Profiled on
Token
5faf62

Query Metrics

4 Database Queries
4 Different statements
17.02 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 8.44 ms 
SELECT e0_.event_id AS event_id_0, e0_.event_name AS event_name_1, e0_.subtitle AS subtitle_2, e0_.date_created AS date_created_3, e0_.creator_uniqname AS creator_uniqname_4, e0_.date_modified AS date_modified_5, e0_.last_uniqname AS last_uniqname_6, e0_.date_moderated AS date_moderated_7, e0_.moderator_uniqname AS moderator_uniqname_8, e0_.description AS description_9, e0_.website AS website_10, e0_.event_type_id AS event_type_id_11, e0_.academic_type AS academic_type_12, e0_.prominent AS prominent_13, e0_.status AS status_14, e0_.cancelled AS cancelled_15, e0_.archived AS archived_16, e0_.provider_id AS provider_id_17, e0_.provider_event_id AS provider_event_id_18, e0_.unpublished AS unpublished_19, e0_.cost AS cost_20, e0_.from_cl_import AS from_cl_import_21, e0_.cl_id AS cl_id_22, e0_.from_ics_feed_import AS from_ics_feed_import_23, e0_.ics_feed_id AS ics_feed_id_24, e0_.ics_feed_uid AS ics_feed_uid_25, e0_.occurrence_count AS occurrence_count_26, e0_.first_occurrence_id AS first_occurrence_id_27, e0_.total_views AS total_views_28, e0_.views_from_search AS views_from_search_29, e0_.views_from_external_website AS views_from_external_website_30, e0_.from_json_feed_import AS from_json_feed_import_31, e0_.json_feed_provider_last_updated AS json_feed_provider_last_updated_32, e0_.sessions_rsvp_id AS sessions_rsvp_id_33, e0_.sessions_rsvp_show_link AS sessions_rsvp_show_link_34, e0_.revision AS revision_35, e0_.tessitura_performance_id AS tessitura_performance_id_36, e0_.tessitura_updated_date AS tessitura_updated_date_37, e0_.session_track_id AS session_track_id_38, e0_.session_updated_date AS session_updated_date_39, e0_.expired AS expired_40, e1_.event_type_id AS event_type_id_41, e1_.event_type_name AS event_type_name_42, e1_.active AS active_43, e2_.group_id AS group_id_44, e2_.event_id AS event_id_45, e2_.admin_level AS admin_level_46, e2_.admin_status AS admin_status_47, e2_.can_edit AS can_edit_48, g3_.group_id AS group_id_49, g3_.group_name AS group_name_50, g3_.shortname AS shortname_51, g3_.description AS description_52, g3_.website AS website_53, g3_.date_created AS date_created_54, g3_.date_modified AS date_modified_55, g3_.creator_uniqname AS creator_uniqname_56, g3_.last_uniqname AS last_uniqname_57, g3_.public AS public_58, g3_.status AS status_59, g3_.custom_theme AS custom_theme_60, g3_.provider_group_id AS provider_group_id_61, g3_.provider_id AS provider_id_62, g3_.contact_opt_out AS contact_opt_out_63, g3_.contact_email_override AS contact_email_override_64, g3_.cic_purged AS cic_purged_65, g3_.contact_sponsor_emails AS contact_sponsor_emails_66, e4_.event_feature_id AS event_feature_id_67, e4_.region AS region_68, e4_.date_start AS date_start_69, e4_.date_end AS date_end_70, e4_.date_created AS date_created_71, e4_.creator_uniqname AS creator_uniqname_72, o5_.occurrence_id AS occurrence_id_73, o5_.event_id AS event_id_74, o5_.occurrence_name AS occurrence_name_75, o5_.date_start AS date_start_76, o5_.date_end AS date_end_77, o5_.no_start_time AS no_start_time_78, o5_.no_end_time AS no_end_time_79, o5_.notes AS notes_80, o5_.location AS location_81, o5_.campus_id AS campus_id_82, o5_.building_id AS building_id_83, o5_.room AS room_84, o5_.recurrence_id AS recurrence_id_85, o5_.livestream_type AS livestream_type_86, o5_.livestream_id AS livestream_id_87, o5_.livestream_require_login AS livestream_require_login_88, o5_.livestream_password AS livestream_password_89, o5_.livestream_custom_link AS livestream_custom_link_90, o5_.session_session_id AS session_session_id_91, o5_.session_event_id AS session_event_id_92, a6_.attachment_id AS attachment_id_93, a6_.foreign_id AS foreign_id_94, a6_.original_name AS original_name_95, a6_.signoff AS signoff_96, a6_.attachment_extension AS attachment_extension_97, a6_.attachment_description AS attachment_description_98, a6_.attachment_path AS attachment_path_99, a6_.is_cropped AS is_cropped_100, a6_.crop_x AS crop_x_101, a6_.crop_y AS crop_y_102, a6_.crop_w AS crop_w_103, a6_.crop_h AS crop_h_104, a6_.from_photo_library AS from_photo_library_105, a6_.dim_x AS dim_x_106, a6_.dim_y AS dim_y_107, a6_.unsplash_credit_author AS unsplash_credit_author_108, a6_.unsplash_credit_link AS unsplash_credit_link_109, a6_.revision AS revision_110, a6_.remote_timestamp AS remote_timestamp_111, e7_.event_link_id AS event_link_id_112, e7_.link_type AS link_type_113, e7_.link_url AS link_url_114, e7_.link_title AS link_title_115, e7_.event_id AS event_id_116, e7_.from_group_link AS from_group_link_117, e0_.cl_id AS cl_id_118, e0_.event_type_id AS event_type_id_119, e0_.ics_feed_id AS ics_feed_id_120, e2_.event_id AS event_id_121, e2_.group_id AS group_id_122, e4_.event_id AS event_id_123, o5_.building_id AS building_id_124, o5_.event_id AS event_id_125, o5_.recurrence_id AS recurrence_id_126, a6_.relation AS relation_127, a6_.foreign_id AS foreign_id_128, e7_.event_id AS event_id_129, e7_.from_group_link AS from_group_link_130 FROM event e0_ INNER JOIN event_type e1_ ON e0_.event_type_id = e1_.event_type_id INNER JOIN events_groups e2_ ON e0_.event_id = e2_.event_id INNER JOIN `group` g3_ ON e2_.group_id = g3_.group_id INNER JOIN event_feature e4_ ON e0_.event_id = e4_.event_id INNER JOIN occurrence o5_ ON e0_.event_id = o5_.event_id LEFT JOIN attachment a6_ ON e0_.event_id = a6_.foreign_id AND a6_.relation IN ('event') LEFT JOIN event_link e7_ ON e0_.event_id = e7_.event_id WHERE (e4_.date_start <= ? AND e4_.date_end >= ?) AND e4_.region = ? AND o5_.date_start >= ? AND e0_.archived = 0 AND e0_.cancelled = 0 AND e0_.unpublished = 0 AND (e0_.prominent = 1 OR e0_.prominent IS NULL) AND (e0_.status = 'active' OR e0_.status = 'approved') ORDER BY o5_.date_start ASC
Parameters: 
[
  "2026-06-12 23:39:12"
  "2026-06-12 23:39:12"
  "homepage"
  "2026-06-12 23:39:12"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 5.79 ms 
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 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
Parameters: 
[
  "2026-06-12 00:00:00"
  "2026-06-12 23:59:59"
  "2026-06-12 00:00:00"
  "2026-06-12 23:59:59"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.94 ms 
SELECT COUNT(e.event_id) AS number, DATE_FORMAT(o.date_start,'%Y-%m-%d') as `date`
            FROM occurrence o
            JOIN event e ON e.event_id=o.event_id
            
            WHERE ((o.date_start>=? AND o.date_start<=?)
                  OR (o.date_start>=? AND o.date_start<=?))
            
             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') 
            GROUP BY `date`
            ORDER BY o.date_start ASC
Parameters: 
[
  "2026-06-12 00:00:00"
  "2026-07-12 00:00:00"
  "2026-06-12 00:00:00"
  "2026-07-12 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 1.85 ms 
SELECT COUNT(e.event_id) AS number, et.event_type_id AS event_type_id, et.event_type_name AS event_type_name
            FROM occurrence o
            JOIN event e ON e.event_id=o.event_id
            JOIN event_type 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  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') 
            GROUP BY event_type_id
            ORDER BY  et.event_type_name ASC
Parameters: 
[
  "2026-06-12 00:00:00"
  "2027-06-12 00:00:00"
  "2026-06-12 00:00:00"
  "2027-06-12 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace

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

Entities Mapping

Class Mapping errors
App\Entity\Event No errors.
App\Entity\EventType No errors.
App\Entity\EventsGroups No errors.
App\Entity\Group No errors.
App\Entity\EventFeature No errors.
App\Entity\Occurrence No errors.
App\Entity\Attachment No errors.
App\Entity\AttachmentEvent No errors.
App\Entity\EventLink No errors.
App\Entity\CLEvent No errors.
App\Entity\ICSFeed No errors.
App\Entity\BRD No errors.
App\Entity\Recurrence No errors.
App\Entity\GroupLink No errors.
App\Entity\Tag No errors.
App\Entity\AttachmentGroup No errors.
App\Entity\EventFeedback No errors.
App\Entity\GroupsUsers No errors.
App\Entity\ImportFeed No errors.
App\Entity\User No errors.
App\Entity\Feedback No errors.