Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

2.92 ms Query time

0 Invalid entities

113 Managed entities

Grouped Statements

Show all queries

Time▼	Count	Info
2.13 ms (72.93%)	2	SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0 SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0;
0.79 ms (27.07%)	1	SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.title AS title_4, t0.visible AS visible_5, t0.show_on_homepage_calendar AS show_on_homepage_calendar_6, t0.venue AS venue_7, t0.total_places AS total_places_8, t0.max_waiting_list_places AS max_waiting_list_places_9, t0.start_date AS start_date_10, t0.event_time AS event_time_11, t0.end_date AS end_date_12, t0.external_event AS external_event_13, t0.cpd_event AS cpd_event_14, t0.cpd_hours AS cpd_hours_15, t0.free_event AS free_event_16, t0.`lead` AS lead_17, t0.noticeboard AS noticeboard_18, t0.event_description AS event_description_19, t0.send_registration_notice_to AS send_registration_notice_to_20, t0.price1_name AS price1_name_21, t0.price1_amount AS price1_amount_22, t0.price1_for_member_only AS price1_for_member_only_23, t0.price1_visible AS price1_visible_24, t0.price2_name AS price2_name_25, t0.price2_amount AS price2_amount_26, t0.price2_for_member_only AS price2_for_member_only_27, t0.price2_visible AS price2_visible_28, t0.price3_name AS price3_name_29, t0.price3_amount AS price3_amount_30, t0.price3_for_member_only AS price3_for_member_only_31, t0.price3_visible AS price3_visible_32, t0.price4_name AS price4_name_33, t0.price4_amount AS price4_amount_34, t0.price4_for_member_only AS price4_for_member_only_35, t0.price4_visible AS price4_visible_36, t0.price5_name AS price5_name_37, t0.price5_amount AS price5_amount_38, t0.price5_for_member_only AS price5_for_member_only_39, t0.price5_visible AS price5_visible_40, t0.price6_name AS price6_name_41, t0.price6_amount AS price6_amount_42, t0.price6_for_member_only AS price6_for_member_only_43, t0.price6_visible AS price6_visible_44, t0.price7_name AS price7_name_45, t0.price7_amount AS price7_amount_46, t0.price7_for_member_only AS price7_for_member_only_47, t0.price7_visible AS price7_visible_48, t0.price8_name AS price8_name_49, t0.price8_amount AS price8_amount_50, t0.price8_for_member_only AS price8_for_member_only_51, t0.price8_visible AS price8_visible_52, t0.price9_name AS price9_name_53, t0.price9_amount AS price9_amount_54, t0.price9_for_member_only AS price9_for_member_only_55, t0.price9_visible AS price9_visible_56, t0.price10_name AS price10_name_57, t0.price10_amount AS price10_amount_58, t0.price10_for_member_only AS price10_for_member_only_59, t0.price10_visible AS price10_visible_60, t0.image_name AS image_name_61, t0.salesforce_id AS salesforce_id_62 FROM event t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL)) Parameters: [`"3"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.title AS title_4, t0.visible AS visible_5, t0.show_on_homepage_calendar AS show_on_homepage_calendar_6, t0.venue AS venue_7, t0.total_places AS total_places_8, t0.max_waiting_list_places AS max_waiting_list_places_9, t0.start_date AS start_date_10, t0.event_time AS event_time_11, t0.end_date AS end_date_12, t0.external_event AS external_event_13, t0.cpd_event AS cpd_event_14, t0.cpd_hours AS cpd_hours_15, t0.free_event AS free_event_16, t0.`lead` AS lead_17, t0.noticeboard AS noticeboard_18, t0.event_description AS event_description_19, t0.send_registration_notice_to AS send_registration_notice_to_20, t0.price1_name AS price1_name_21, t0.price1_amount AS price1_amount_22, t0.price1_for_member_only AS price1_for_member_only_23, t0.price1_visible AS price1_visible_24, t0.price2_name AS price2_name_25, t0.price2_amount AS price2_amount_26, t0.price2_for_member_only AS price2_for_member_only_27, t0.price2_visible AS price2_visible_28, t0.price3_name AS price3_name_29, t0.price3_amount AS price3_amount_30, t0.price3_for_member_only AS price3_for_member_only_31, t0.price3_visible AS price3_visible_32, t0.price4_name AS price4_name_33, t0.price4_amount AS price4_amount_34, t0.price4_for_member_only AS price4_for_member_only_35, t0.price4_visible AS price4_visible_36, t0.price5_name AS price5_name_37, t0.price5_amount AS price5_amount_38, t0.price5_for_member_only AS price5_for_member_only_39, t0.price5_visible AS price5_visible_40, t0.price6_name AS price6_name_41, t0.price6_amount AS price6_amount_42, t0.price6_for_member_only AS price6_for_member_only_43, t0.price6_visible AS price6_visible_44, t0.price7_name AS price7_name_45, t0.price7_amount AS price7_amount_46, t0.price7_for_member_only AS price7_for_member_only_47, t0.price7_visible AS price7_visible_48, t0.price8_name AS price8_name_49, t0.price8_amount AS price8_amount_50, t0.price8_for_member_only AS price8_for_member_only_51, t0.price8_visible AS price8_visible_52, t0.price9_name AS price9_name_53, t0.price9_amount AS price9_amount_54, t0.price9_for_member_only AS price9_for_member_only_55, t0.price9_visible AS price9_visible_56, t0.price10_name AS price10_name_57, t0.price10_amount AS price10_amount_58, t0.price10_for_member_only AS price10_for_member_only_59, t0.price10_visible AS price10_visible_60, t0.image_name AS image_name_61, t0.salesforce_id AS salesforce_id_62 FROM event t0 WHERE t0.id = ? AND ( (t0.deletedAt IS NULL) ) SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.title AS title_4, t0.visible AS visible_5, t0.show_on_homepage_calendar AS show_on_homepage_calendar_6, t0.venue AS venue_7, t0.total_places AS total_places_8, t0.max_waiting_list_places AS max_waiting_list_places_9, t0.start_date AS start_date_10, t0.event_time AS event_time_11, t0.end_date AS end_date_12, t0.external_event AS external_event_13, t0.cpd_event AS cpd_event_14, t0.cpd_hours AS cpd_hours_15, t0.free_event AS free_event_16, t0.`lead` AS lead_17, t0.noticeboard AS noticeboard_18, t0.event_description AS event_description_19, t0.send_registration_notice_to AS send_registration_notice_to_20, t0.price1_name AS price1_name_21, t0.price1_amount AS price1_amount_22, t0.price1_for_member_only AS price1_for_member_only_23, t0.price1_visible AS price1_visible_24, t0.price2_name AS price2_name_25, t0.price2_amount AS price2_amount_26, t0.price2_for_member_only AS price2_for_member_only_27, t0.price2_visible AS price2_visible_28, t0.price3_name AS price3_name_29, t0.price3_amount AS price3_amount_30, t0.price3_for_member_only AS price3_for_member_only_31, t0.price3_visible AS price3_visible_32, t0.price4_name AS price4_name_33, t0.price4_amount AS price4_amount_34, t0.price4_for_member_only AS price4_for_member_only_35, t0.price4_visible AS price4_visible_36, t0.price5_name AS price5_name_37, t0.price5_amount AS price5_amount_38, t0.price5_for_member_only AS price5_for_member_only_39, t0.price5_visible AS price5_visible_40, t0.price6_name AS price6_name_41, t0.price6_amount AS price6_amount_42, t0.price6_for_member_only AS price6_for_member_only_43, t0.price6_visible AS price6_visible_44, t0.price7_name AS price7_name_45, t0.price7_amount AS price7_amount_46, t0.price7_for_member_only AS price7_for_member_only_47, t0.price7_visible AS price7_visible_48, t0.price8_name AS price8_name_49, t0.price8_amount AS price8_amount_50, t0.price8_for_member_only AS price8_for_member_only_51, t0.price8_visible AS price8_visible_52, t0.price9_name AS price9_name_53, t0.price9_amount AS price9_amount_54, t0.price9_for_member_only AS price9_for_member_only_55, t0.price9_visible AS price9_visible_56, t0.price10_name AS price10_name_57, t0.price10_amount AS price10_amount_58, t0.price10_for_member_only AS price10_for_member_only_59, t0.price10_visible AS price10_visible_60, t0.image_name AS image_name_61, t0.salesforce_id AS salesforce_id_62 FROM event t0 WHERE t0.id = '3' AND ((t0.deletedAt IS NULL));

Time▼

Count

Info

2.13 ms
(72.93%)

SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.settings_key AS settings_key_2,
  t0.settings_val AS settings_val_3
FROM
  setting t0

SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0;

0.79 ms
(27.07%)

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.title AS title_4, t0.visible AS visible_5, t0.show_on_homepage_calendar AS show_on_homepage_calendar_6, t0.venue AS venue_7, t0.total_places AS total_places_8, t0.max_waiting_list_places AS max_waiting_list_places_9, t0.start_date AS start_date_10, t0.event_time AS event_time_11, t0.end_date AS end_date_12, t0.external_event AS external_event_13, t0.cpd_event AS cpd_event_14, t0.cpd_hours AS cpd_hours_15, t0.free_event AS free_event_16, t0.`lead` AS lead_17, t0.noticeboard AS noticeboard_18, t0.event_description AS event_description_19, t0.send_registration_notice_to AS send_registration_notice_to_20, t0.price1_name AS price1_name_21, t0.price1_amount AS price1_amount_22, t0.price1_for_member_only AS price1_for_member_only_23, t0.price1_visible AS price1_visible_24, t0.price2_name AS price2_name_25, t0.price2_amount AS price2_amount_26, t0.price2_for_member_only AS price2_for_member_only_27, t0.price2_visible AS price2_visible_28, t0.price3_name AS price3_name_29, t0.price3_amount AS price3_amount_30, t0.price3_for_member_only AS price3_for_member_only_31, t0.price3_visible AS price3_visible_32, t0.price4_name AS price4_name_33, t0.price4_amount AS price4_amount_34, t0.price4_for_member_only AS price4_for_member_only_35, t0.price4_visible AS price4_visible_36, t0.price5_name AS price5_name_37, t0.price5_amount AS price5_amount_38, t0.price5_for_member_only AS price5_for_member_only_39, t0.price5_visible AS price5_visible_40, t0.price6_name AS price6_name_41, t0.price6_amount AS price6_amount_42, t0.price6_for_member_only AS price6_for_member_only_43, t0.price6_visible AS price6_visible_44, t0.price7_name AS price7_name_45, t0.price7_amount AS price7_amount_46, t0.price7_for_member_only AS price7_for_member_only_47, t0.price7_visible AS price7_visible_48, t0.price8_name AS price8_name_49, t0.price8_amount AS price8_amount_50, t0.price8_for_member_only AS price8_for_member_only_51, t0.price8_visible AS price8_visible_52, t0.price9_name AS price9_name_53, t0.price9_amount AS price9_amount_54, t0.price9_for_member_only AS price9_for_member_only_55, t0.price9_visible AS price9_visible_56, t0.price10_name AS price10_name_57, t0.price10_amount AS price10_amount_58, t0.price10_for_member_only AS price10_for_member_only_59, t0.price10_visible AS price10_visible_60, t0.image_name AS image_name_61, t0.salesforce_id AS salesforce_id_62 FROM event t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))

Parameters:

[
  "3"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.deletedAt AS deletedAt_3,
  t0.title AS title_4,
  t0.visible AS visible_5,
  t0.show_on_homepage_calendar AS show_on_homepage_calendar_6,
  t0.venue AS venue_7,
  t0.total_places AS total_places_8,
  t0.max_waiting_list_places AS max_waiting_list_places_9,
  t0.start_date AS start_date_10,
  t0.event_time AS event_time_11,
  t0.end_date AS end_date_12,
  t0.external_event AS external_event_13,
  t0.cpd_event AS cpd_event_14,
  t0.cpd_hours AS cpd_hours_15,
  t0.free_event AS free_event_16,
  t0.`lead` AS lead_17,
  t0.noticeboard AS noticeboard_18,
  t0.event_description AS event_description_19,
  t0.send_registration_notice_to AS send_registration_notice_to_20,
  t0.price1_name AS price1_name_21,
  t0.price1_amount AS price1_amount_22,
  t0.price1_for_member_only AS price1_for_member_only_23,
  t0.price1_visible AS price1_visible_24,
  t0.price2_name AS price2_name_25,
  t0.price2_amount AS price2_amount_26,
  t0.price2_for_member_only AS price2_for_member_only_27,
  t0.price2_visible AS price2_visible_28,
  t0.price3_name AS price3_name_29,
  t0.price3_amount AS price3_amount_30,
  t0.price3_for_member_only AS price3_for_member_only_31,
  t0.price3_visible AS price3_visible_32,
  t0.price4_name AS price4_name_33,
  t0.price4_amount AS price4_amount_34,
  t0.price4_for_member_only AS price4_for_member_only_35,
  t0.price4_visible AS price4_visible_36,
  t0.price5_name AS price5_name_37,
  t0.price5_amount AS price5_amount_38,
  t0.price5_for_member_only AS price5_for_member_only_39,
  t0.price5_visible AS price5_visible_40,
  t0.price6_name AS price6_name_41,
  t0.price6_amount AS price6_amount_42,
  t0.price6_for_member_only AS price6_for_member_only_43,
  t0.price6_visible AS price6_visible_44,
  t0.price7_name AS price7_name_45,
  t0.price7_amount AS price7_amount_46,
  t0.price7_for_member_only AS price7_for_member_only_47,
  t0.price7_visible AS price7_visible_48,
  t0.price8_name AS price8_name_49,
  t0.price8_amount AS price8_amount_50,
  t0.price8_for_member_only AS price8_for_member_only_51,
  t0.price8_visible AS price8_visible_52,
  t0.price9_name AS price9_name_53,
  t0.price9_amount AS price9_amount_54,
  t0.price9_for_member_only AS price9_for_member_only_55,
  t0.price9_visible AS price9_visible_56,
  t0.price10_name AS price10_name_57,
  t0.price10_amount AS price10_amount_58,
  t0.price10_for_member_only AS price10_for_member_only_59,
  t0.price10_visible AS price10_visible_60,
  t0.image_name AS image_name_61,
  t0.salesforce_id AS salesforce_id_62
FROM
  event t0
WHERE
  t0.id = ?
  AND (
    (t0.deletedAt IS NULL)
  )

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.title AS title_4, t0.visible AS visible_5, t0.show_on_homepage_calendar AS show_on_homepage_calendar_6, t0.venue AS venue_7, t0.total_places AS total_places_8, t0.max_waiting_list_places AS max_waiting_list_places_9, t0.start_date AS start_date_10, t0.event_time AS event_time_11, t0.end_date AS end_date_12, t0.external_event AS external_event_13, t0.cpd_event AS cpd_event_14, t0.cpd_hours AS cpd_hours_15, t0.free_event AS free_event_16, t0.`lead` AS lead_17, t0.noticeboard AS noticeboard_18, t0.event_description AS event_description_19, t0.send_registration_notice_to AS send_registration_notice_to_20, t0.price1_name AS price1_name_21, t0.price1_amount AS price1_amount_22, t0.price1_for_member_only AS price1_for_member_only_23, t0.price1_visible AS price1_visible_24, t0.price2_name AS price2_name_25, t0.price2_amount AS price2_amount_26, t0.price2_for_member_only AS price2_for_member_only_27, t0.price2_visible AS price2_visible_28, t0.price3_name AS price3_name_29, t0.price3_amount AS price3_amount_30, t0.price3_for_member_only AS price3_for_member_only_31, t0.price3_visible AS price3_visible_32, t0.price4_name AS price4_name_33, t0.price4_amount AS price4_amount_34, t0.price4_for_member_only AS price4_for_member_only_35, t0.price4_visible AS price4_visible_36, t0.price5_name AS price5_name_37, t0.price5_amount AS price5_amount_38, t0.price5_for_member_only AS price5_for_member_only_39, t0.price5_visible AS price5_visible_40, t0.price6_name AS price6_name_41, t0.price6_amount AS price6_amount_42, t0.price6_for_member_only AS price6_for_member_only_43, t0.price6_visible AS price6_visible_44, t0.price7_name AS price7_name_45, t0.price7_amount AS price7_amount_46, t0.price7_for_member_only AS price7_for_member_only_47, t0.price7_visible AS price7_visible_48, t0.price8_name AS price8_name_49, t0.price8_amount AS price8_amount_50, t0.price8_for_member_only AS price8_for_member_only_51, t0.price8_visible AS price8_visible_52, t0.price9_name AS price9_name_53, t0.price9_amount AS price9_amount_54, t0.price9_for_member_only AS price9_for_member_only_55, t0.price9_visible AS price9_visible_56, t0.price10_name AS price10_name_57, t0.price10_amount AS price10_amount_58, t0.price10_for_member_only AS price10_for_member_only_59, t0.price10_visible AS price10_visible_60, t0.image_name AS image_name_61, t0.salesforce_id AS salesforce_id_62 FROM event t0 WHERE t0.id = '3' AND ((t0.deletedAt IS NULL));

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
App\Entity\Setting	113

Entities Mapping

Class	Mapping errors
App\Entity\Event	No errors.
App\Entity\Setting	No errors.

Symfony Profiler

GET https://iacp.ie/events/3/%5C

Configuration Settings

Theme

Page Width