Symfony Profiler

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;

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;

SELECT
  e0_.id AS id_0,
  e0_.updated_at AS updated_at_1,
  e0_.deletedAt AS deletedAt_2,
  e0_.title AS title_3,
  e0_.visible AS visible_4,
  e0_.show_on_homepage_calendar AS show_on_homepage_calendar_5,
  e0_.venue AS venue_6,
  e0_.total_places AS total_places_7,
  e0_.max_waiting_list_places AS max_waiting_list_places_8,
  e0_.start_date AS start_date_9,
  e0_.event_time AS event_time_10,
  e0_.end_date AS end_date_11,
  e0_.external_event AS external_event_12,
  e0_.cpd_event AS cpd_event_13,
  e0_.cpd_hours AS cpd_hours_14,
  e0_.free_event AS free_event_15,
  e0_.`lead` AS lead_16,
  e0_.noticeboard AS noticeboard_17,
  e0_.event_description AS event_description_18,
  e0_.send_registration_notice_to AS send_registration_notice_to_19,
  e0_.price1_name AS price1_name_20,
  e0_.price1_amount AS price1_amount_21,
  e0_.price1_for_member_only AS price1_for_member_only_22,
  e0_.price1_visible AS price1_visible_23,
  e0_.price2_name AS price2_name_24,
  e0_.price2_amount AS price2_amount_25,
  e0_.price2_for_member_only AS price2_for_member_only_26,
  e0_.price2_visible AS price2_visible_27,
  e0_.price3_name AS price3_name_28,
  e0_.price3_amount AS price3_amount_29,
  e0_.price3_for_member_only AS price3_for_member_only_30,
  e0_.price3_visible AS price3_visible_31,
  e0_.price4_name AS price4_name_32,
  e0_.price4_amount AS price4_amount_33,
  e0_.price4_for_member_only AS price4_for_member_only_34,
  e0_.price4_visible AS price4_visible_35,
  e0_.price5_name AS price5_name_36,
  e0_.price5_amount AS price5_amount_37,
  e0_.price5_for_member_only AS price5_for_member_only_38,
  e0_.price5_visible AS price5_visible_39,
  e0_.price6_name AS price6_name_40,
  e0_.price6_amount AS price6_amount_41,
  e0_.price6_for_member_only AS price6_for_member_only_42,
  e0_.price6_visible AS price6_visible_43,
  e0_.price7_name AS price7_name_44,
  e0_.price7_amount AS price7_amount_45,
  e0_.price7_for_member_only AS price7_for_member_only_46,
  e0_.price7_visible AS price7_visible_47,
  e0_.price8_name AS price8_name_48,
  e0_.price8_amount AS price8_amount_49,
  e0_.price8_for_member_only AS price8_for_member_only_50,
  e0_.price8_visible AS price8_visible_51,
  e0_.price9_name AS price9_name_52,
  e0_.price9_amount AS price9_amount_53,
  e0_.price9_for_member_only AS price9_for_member_only_54,
  e0_.price9_visible AS price9_visible_55,
  e0_.price10_name AS price10_name_56,
  e0_.price10_amount AS price10_amount_57,
  e0_.price10_for_member_only AS price10_for_member_only_58,
  e0_.price10_visible AS price10_visible_59,
  e0_.image_name AS image_name_60,
  e0_.salesforce_id AS salesforce_id_61
FROM
  event e0_
WHERE
  (
    e0_.start_date > ?
    AND e0_.visible = ?
    AND e0_.external_event = ?
  )
  AND (e0_.deletedAt IS NULL)
ORDER BY
  e0_.start_date ASC
LIMIT
  3

SELECT e0_.id AS id_0, e0_.updated_at AS updated_at_1, e0_.deletedAt AS deletedAt_2, e0_.title AS title_3, e0_.visible AS visible_4, e0_.show_on_homepage_calendar AS show_on_homepage_calendar_5, e0_.venue AS venue_6, e0_.total_places AS total_places_7, e0_.max_waiting_list_places AS max_waiting_list_places_8, e0_.start_date AS start_date_9, e0_.event_time AS event_time_10, e0_.end_date AS end_date_11, e0_.external_event AS external_event_12, e0_.cpd_event AS cpd_event_13, e0_.cpd_hours AS cpd_hours_14, e0_.free_event AS free_event_15, e0_.`lead` AS lead_16, e0_.noticeboard AS noticeboard_17, e0_.event_description AS event_description_18, e0_.send_registration_notice_to AS send_registration_notice_to_19, e0_.price1_name AS price1_name_20, e0_.price1_amount AS price1_amount_21, e0_.price1_for_member_only AS price1_for_member_only_22, e0_.price1_visible AS price1_visible_23, e0_.price2_name AS price2_name_24, e0_.price2_amount AS price2_amount_25, e0_.price2_for_member_only AS price2_for_member_only_26, e0_.price2_visible AS price2_visible_27, e0_.price3_name AS price3_name_28, e0_.price3_amount AS price3_amount_29, e0_.price3_for_member_only AS price3_for_member_only_30, e0_.price3_visible AS price3_visible_31, e0_.price4_name AS price4_name_32, e0_.price4_amount AS price4_amount_33, e0_.price4_for_member_only AS price4_for_member_only_34, e0_.price4_visible AS price4_visible_35, e0_.price5_name AS price5_name_36, e0_.price5_amount AS price5_amount_37, e0_.price5_for_member_only AS price5_for_member_only_38, e0_.price5_visible AS price5_visible_39, e0_.price6_name AS price6_name_40, e0_.price6_amount AS price6_amount_41, e0_.price6_for_member_only AS price6_for_member_only_42, e0_.price6_visible AS price6_visible_43, e0_.price7_name AS price7_name_44, e0_.price7_amount AS price7_amount_45, e0_.price7_for_member_only AS price7_for_member_only_46, e0_.price7_visible AS price7_visible_47, e0_.price8_name AS price8_name_48, e0_.price8_amount AS price8_amount_49, e0_.price8_for_member_only AS price8_for_member_only_50, e0_.price8_visible AS price8_visible_51, e0_.price9_name AS price9_name_52, e0_.price9_amount AS price9_amount_53, e0_.price9_for_member_only AS price9_for_member_only_54, e0_.price9_visible AS price9_visible_55, e0_.price10_name AS price10_name_56, e0_.price10_amount AS price10_amount_57, e0_.price10_for_member_only AS price10_for_member_only_58, e0_.price10_visible AS price10_visible_59, e0_.image_name AS image_name_60, e0_.salesforce_id AS salesforce_id_61 FROM event e0_ WHERE (e0_.start_date > '2025-09-06 07:14:30' AND e0_.visible = 1 AND e0_.external_event = 0) AND (e0_.deletedAt IS NULL) ORDER BY e0_.start_date ASC LIMIT 3;

SELECT
  p0_.id AS id_0,
  p0_.updated_at AS updated_at_1,
  p0_.name AS name_2,
  p0_.`lead` AS lead_3,
  p0_.content AS content_4,
  p0_.right_column AS right_column_5,
  p0_.gallery_content AS gallery_content_6,
  p0_.type_key AS type_key_7,
  p0_.visible AS visible_8,
  p0_.priority_news AS priority_news_9,
  p0_.full_width AS full_width_10,
  p0_.hide_right_column AS hide_right_column_11,
  p0_.hide_submenu AS hide_submenu_12,
  p0_.show_subpage_panels AS show_subpage_panels_13,
  p0_.show_subpage_links AS show_subpage_links_14,
  p0_.show_subpage_news AS show_subpage_news_15,
  p0_.use_parent_header AS use_parent_header_16,
  p0_.list_order AS list_order_17,
  p0_.seo_title AS seo_title_18,
  p0_.custom_tabs AS custom_tabs_19,
  p0_.seo_keywords AS seo_keywords_20,
  p0_.seo_description AS seo_description_21,
  p0_.seo_url AS seo_url_22,
  p0_.parent_id AS parent_id_23,
  p0_.image_name AS image_name_24,
  p0_.image_alt AS image_alt_25,
  p0_.image2_name AS image2_name_26,
  p0_.image2_alt AS image2_alt_27,
  p0_.image3_name AS image3_name_28,
  p0_.image3_alt AS image3_alt_29,
  p0_.heading AS heading_30,
  p0_.external_link AS external_link_31,
  p0_.page_date AS page_date_32,
  p0_.parent_id AS parent_id_33
FROM
  page p0_
WHERE
  p0_.type_key = ?
  AND p0_.visible = ?
ORDER BY
  p0_.page_date DESC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.updated_at AS updated_at_1, p0_.name AS name_2, p0_.`lead` AS lead_3, p0_.content AS content_4, p0_.right_column AS right_column_5, p0_.gallery_content AS gallery_content_6, p0_.type_key AS type_key_7, p0_.visible AS visible_8, p0_.priority_news AS priority_news_9, p0_.full_width AS full_width_10, p0_.hide_right_column AS hide_right_column_11, p0_.hide_submenu AS hide_submenu_12, p0_.show_subpage_panels AS show_subpage_panels_13, p0_.show_subpage_links AS show_subpage_links_14, p0_.show_subpage_news AS show_subpage_news_15, p0_.use_parent_header AS use_parent_header_16, p0_.list_order AS list_order_17, p0_.seo_title AS seo_title_18, p0_.custom_tabs AS custom_tabs_19, p0_.seo_keywords AS seo_keywords_20, p0_.seo_description AS seo_description_21, p0_.seo_url AS seo_url_22, p0_.parent_id AS parent_id_23, p0_.image_name AS image_name_24, p0_.image_alt AS image_alt_25, p0_.image2_name AS image2_name_26, p0_.image2_alt AS image2_alt_27, p0_.image3_name AS image3_name_28, p0_.image3_alt AS image3_alt_29, p0_.heading AS heading_30, p0_.external_link AS external_link_31, p0_.page_date AS page_date_32, p0_.parent_id AS parent_id_33 FROM page p0_ WHERE p0_.type_key = 'news' AND p0_.visible = 1 ORDER BY p0_.page_date DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.deletedAt AS deletedAt_3,
  t0.name AS name_4,
  t0.field0 AS field0_5,
  t0.field1 AS field1_6,
  t0.field2 AS field2_7,
  t0.field3 AS field3_8,
  t0.field4 AS field4_9,
  t0.field5 AS field5_10,
  t0.field6 AS field6_11,
  t0.field7 AS field7_12,
  t0.field8 AS field8_13,
  t0.field9 AS field9_14,
  t0.field10 AS field10_15,
  t0.field11 AS field11_16,
  t0.file1_name AS file1_name_17,
  t0.file2_name AS file2_name_18,
  t0.type_key AS type_key_19,
  t0.visible AS visible_20,
  t0.list_order AS list_order_21
FROM
  dictionary t0
WHERE
  t0.visible = ?
  AND t0.type_key = ?
  AND (
    (t0.deletedAt IS NULL)
  )
ORDER BY
  t0.list_order ASC

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = 1 AND t0.type_key = 'therapist_location' AND ((t0.deletedAt IS NULL)) ORDER BY t0.list_order ASC;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.deletedAt AS deletedAt_3,
  t0.name AS name_4,
  t0.field0 AS field0_5,
  t0.field1 AS field1_6,
  t0.field2 AS field2_7,
  t0.field3 AS field3_8,
  t0.field4 AS field4_9,
  t0.field5 AS field5_10,
  t0.field6 AS field6_11,
  t0.field7 AS field7_12,
  t0.field8 AS field8_13,
  t0.field9 AS field9_14,
  t0.field10 AS field10_15,
  t0.field11 AS field11_16,
  t0.file1_name AS file1_name_17,
  t0.file2_name AS file2_name_18,
  t0.type_key AS type_key_19,
  t0.visible AS visible_20,
  t0.list_order AS list_order_21
FROM
  dictionary t0
WHERE
  t0.visible = ?
  AND t0.type_key = ?
  AND (
    (t0.deletedAt IS NULL)
  )
ORDER BY
  t0.list_order ASC

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = 1 AND t0.type_key = 'therapist_category' AND ((t0.deletedAt IS NULL)) ORDER BY t0.list_order ASC;

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;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.deletedAt AS deletedAt_3,
  t0.name AS name_4,
  t0.field0 AS field0_5,
  t0.field1 AS field1_6,
  t0.field2 AS field2_7,
  t0.field3 AS field3_8,
  t0.field4 AS field4_9,
  t0.field5 AS field5_10,
  t0.field6 AS field6_11,
  t0.field7 AS field7_12,
  t0.field8 AS field8_13,
  t0.field9 AS field9_14,
  t0.field10 AS field10_15,
  t0.field11 AS field11_16,
  t0.file1_name AS file1_name_17,
  t0.file2_name AS file2_name_18,
  t0.type_key AS type_key_19,
  t0.visible AS visible_20,
  t0.list_order AS list_order_21
FROM
  dictionary t0
WHERE
  t0.visible = ?
  AND (
    (t0.deletedAt IS NULL)
  )
ORDER BY
  t0.list_order ASC

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = 1 AND ((t0.deletedAt IS NULL)) ORDER BY t0.list_order ASC;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.deletedAt AS deletedAt_3,
  t0.name AS name_4,
  t0.field0 AS field0_5,
  t0.field1 AS field1_6,
  t0.field2 AS field2_7,
  t0.field3 AS field3_8,
  t0.field4 AS field4_9,
  t0.field5 AS field5_10,
  t0.field6 AS field6_11,
  t0.field7 AS field7_12,
  t0.field8 AS field8_13,
  t0.field9 AS field9_14,
  t0.field10 AS field10_15,
  t0.field11 AS field11_16,
  t0.file1_name AS file1_name_17,
  t0.file2_name AS file2_name_18,
  t0.type_key AS type_key_19,
  t0.visible AS visible_20,
  t0.list_order AS list_order_21
FROM
  dictionary t0
WHERE
  t0.visible = ?
  AND t0.type_key = ?
  AND (
    (t0.deletedAt IS NULL)
  )
ORDER BY
  t0.field2 DESC

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 WHERE t0.visible = 1 AND t0.type_key = 'events' AND ((t0.deletedAt IS NULL)) ORDER BY t0.field2 DESC;

SELECT
  t0.id AS id_1,
  t0.updated_at AS updated_at_2,
  t0.name AS name_3,
  t0.`lead` AS lead_4,
  t0.content AS content_5,
  t0.right_column AS right_column_6,
  t0.gallery_content AS gallery_content_7,
  t0.type_key AS type_key_8,
  t0.visible AS visible_9,
  t0.priority_news AS priority_news_10,
  t0.full_width AS full_width_11,
  t0.hide_right_column AS hide_right_column_12,
  t0.hide_submenu AS hide_submenu_13,
  t0.show_subpage_panels AS show_subpage_panels_14,
  t0.show_subpage_links AS show_subpage_links_15,
  t0.show_subpage_news AS show_subpage_news_16,
  t0.use_parent_header AS use_parent_header_17,
  t0.list_order AS list_order_18,
  t0.seo_title AS seo_title_19,
  t0.custom_tabs AS custom_tabs_20,
  t0.seo_keywords AS seo_keywords_21,
  t0.seo_description AS seo_description_22,
  t0.seo_url AS seo_url_23,
  t0.parent_id AS parent_id_24,
  t0.image_name AS image_name_25,
  t0.image_alt AS image_alt_26,
  t0.image2_name AS image2_name_27,
  t0.image2_alt AS image2_alt_28,
  t0.image3_name AS image3_name_29,
  t0.image3_alt AS image3_alt_30,
  t0.heading AS heading_31,
  t0.external_link AS external_link_32,
  t0.page_date AS page_date_33,
  t0.parent_id AS parent_id_34
FROM
  page t0
WHERE
  t0.visible = ?
ORDER BY
  t0.list_order ASC

SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.name AS name_3, t0.`lead` AS lead_4, t0.content AS content_5, t0.right_column AS right_column_6, t0.gallery_content AS gallery_content_7, t0.type_key AS type_key_8, t0.visible AS visible_9, t0.priority_news AS priority_news_10, t0.full_width AS full_width_11, t0.hide_right_column AS hide_right_column_12, t0.hide_submenu AS hide_submenu_13, t0.show_subpage_panels AS show_subpage_panels_14, t0.show_subpage_links AS show_subpage_links_15, t0.show_subpage_news AS show_subpage_news_16, t0.use_parent_header AS use_parent_header_17, t0.list_order AS list_order_18, t0.seo_title AS seo_title_19, t0.custom_tabs AS custom_tabs_20, t0.seo_keywords AS seo_keywords_21, t0.seo_description AS seo_description_22, t0.seo_url AS seo_url_23, t0.parent_id AS parent_id_24, t0.image_name AS image_name_25, t0.image_alt AS image_alt_26, t0.image2_name AS image2_name_27, t0.image2_alt AS image2_alt_28, t0.image3_name AS image3_name_29, t0.image3_alt AS image3_alt_30, t0.heading AS heading_31, t0.external_link AS external_link_32, t0.page_date AS page_date_33, t0.parent_id AS parent_id_34 FROM page t0 WHERE t0.visible = 1 ORDER BY t0.list_order ASC;

SELECT
  p0_.id AS id_0,
  p0_.updated_at AS updated_at_1,
  p0_.name AS name_2,
  p0_.`lead` AS lead_3,
  p0_.content AS content_4,
  p0_.right_column AS right_column_5,
  p0_.gallery_content AS gallery_content_6,
  p0_.type_key AS type_key_7,
  p0_.visible AS visible_8,
  p0_.priority_news AS priority_news_9,
  p0_.full_width AS full_width_10,
  p0_.hide_right_column AS hide_right_column_11,
  p0_.hide_submenu AS hide_submenu_12,
  p0_.show_subpage_panels AS show_subpage_panels_13,
  p0_.show_subpage_links AS show_subpage_links_14,
  p0_.show_subpage_news AS show_subpage_news_15,
  p0_.use_parent_header AS use_parent_header_16,
  p0_.list_order AS list_order_17,
  p0_.seo_title AS seo_title_18,
  p0_.custom_tabs AS custom_tabs_19,
  p0_.seo_keywords AS seo_keywords_20,
  p0_.seo_description AS seo_description_21,
  p0_.seo_url AS seo_url_22,
  p0_.parent_id AS parent_id_23,
  p0_.image_name AS image_name_24,
  p0_.image_alt AS image_alt_25,
  p0_.image2_name AS image2_name_26,
  p0_.image2_alt AS image2_alt_27,
  p0_.image3_name AS image3_name_28,
  p0_.image3_alt AS image3_alt_29,
  p0_.heading AS heading_30,
  p0_.external_link AS external_link_31,
  p0_.page_date AS page_date_32,
  p0_.parent_id AS parent_id_33
FROM
  page p0_
WHERE
  p0_.type_key = ?
  AND p0_.visible = ?
  AND p0_.page_date <= ?
ORDER BY
  p0_.priority_news DESC,
  p0_.page_date DESC,
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.updated_at AS updated_at_1, p0_.name AS name_2, p0_.`lead` AS lead_3, p0_.content AS content_4, p0_.right_column AS right_column_5, p0_.gallery_content AS gallery_content_6, p0_.type_key AS type_key_7, p0_.visible AS visible_8, p0_.priority_news AS priority_news_9, p0_.full_width AS full_width_10, p0_.hide_right_column AS hide_right_column_11, p0_.hide_submenu AS hide_submenu_12, p0_.show_subpage_panels AS show_subpage_panels_13, p0_.show_subpage_links AS show_subpage_links_14, p0_.show_subpage_news AS show_subpage_news_15, p0_.use_parent_header AS use_parent_header_16, p0_.list_order AS list_order_17, p0_.seo_title AS seo_title_18, p0_.custom_tabs AS custom_tabs_19, p0_.seo_keywords AS seo_keywords_20, p0_.seo_description AS seo_description_21, p0_.seo_url AS seo_url_22, p0_.parent_id AS parent_id_23, p0_.image_name AS image_name_24, p0_.image_alt AS image_alt_25, p0_.image2_name AS image2_name_26, p0_.image2_alt AS image2_alt_27, p0_.image3_name AS image3_name_28, p0_.image3_alt AS image3_alt_29, p0_.heading AS heading_30, p0_.external_link AS external_link_31, p0_.page_date AS page_date_32, p0_.parent_id AS parent_id_33 FROM page p0_ WHERE p0_.type_key = 'news' AND p0_.visible = 1 AND p0_.page_date <= '2025-09-06 07:14:30' ORDER BY p0_.priority_news DESC, p0_.page_date DESC, p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.file_name AS file_name_3,
  t0.file_original_name AS file_original_name_4,
  t0.file_mime AS file_mime_5,
  t0.file_size AS file_size_6,
  t0.fee AS fee_7,
  t0.confirm_message AS confirm_message_8,
  t0.file2_name AS file2_name_9,
  t0.file2_original_name AS file2_original_name_10,
  t0.file2_mime AS file2_mime_11,
  t0.file2_size AS file2_size_12,
  t0.file3_name AS file3_name_13,
  t0.file3_original_name AS file3_original_name_14,
  t0.file3_mime AS file3_mime_15,
  t0.file3_size AS file3_size_16,
  t0.file4_name AS file4_name_17,
  t0.file4_original_name AS file4_original_name_18,
  t0.file4_mime AS file4_mime_19,
  t0.file4_size AS file4_size_20,
  t0.addfields AS addfields_21,
  t0.email_copy AS email_copy_22,
  t0.membership_no AS membership_no_23,
  t0.garda_required AS garda_required_24,
  t0.processing_fee_label AS processing_fee_label_25,
  t0.under_button_label AS under_button_label_26,
  t0.stage2_email_topic AS stage2_email_topic_27,
  t0.stage2_email_content AS stage2_email_content_28,
  t0.sf_garda_vetting AS sf_garda_vetting_29,
  t0.sf_application AS sf_application_30,
  t0.stage2_enabled AS stage2_enabled_31,
  t0.merged_form AS merged_form_32,
  t0.fee2 AS fee2_33,
  t0.stage2_email AS stage2_email_34,
  t0.updated_at AS updated_at_35
FROM
  membership_form t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.file_name AS file_name_3, t0.file_original_name AS file_original_name_4, t0.file_mime AS file_mime_5, t0.file_size AS file_size_6, t0.fee AS fee_7, t0.confirm_message AS confirm_message_8, t0.file2_name AS file2_name_9, t0.file2_original_name AS file2_original_name_10, t0.file2_mime AS file2_mime_11, t0.file2_size AS file2_size_12, t0.file3_name AS file3_name_13, t0.file3_original_name AS file3_original_name_14, t0.file3_mime AS file3_mime_15, t0.file3_size AS file3_size_16, t0.file4_name AS file4_name_17, t0.file4_original_name AS file4_original_name_18, t0.file4_mime AS file4_mime_19, t0.file4_size AS file4_size_20, t0.addfields AS addfields_21, t0.email_copy AS email_copy_22, t0.membership_no AS membership_no_23, t0.garda_required AS garda_required_24, t0.processing_fee_label AS processing_fee_label_25, t0.under_button_label AS under_button_label_26, t0.stage2_email_topic AS stage2_email_topic_27, t0.stage2_email_content AS stage2_email_content_28, t0.sf_garda_vetting AS sf_garda_vetting_29, t0.sf_application AS sf_application_30, t0.stage2_enabled AS stage2_enabled_31, t0.merged_form AS merged_form_32, t0.fee2 AS fee2_33, t0.stage2_email AS stage2_email_34, t0.updated_at AS updated_at_35 FROM membership_form t0;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'iacpclrwww'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'iacpclrwww'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'iacpclrwww' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  DISTINCT k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'iacpclrwww' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = 'iacpclrwww' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'iacpclrwww' */ ORDER BY k.ORDINAL_POSITION;

SELECT
  c.COLUMN_NAME AS field,
  c.COLUMN_TYPE AS type,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = 'iacpclrwww' AND t.TABLE_SCHEMA = 'iacpclrwww' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
ORDER BY
  SEQ_IN_INDEX

SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'iacpclrwww' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  DATABASE()

SELECT DATABASE();