Symfony Profiler

"COMMIT"

"COMMIT";

INSERT INTO traffic_data (
  hash, user_token, user_ip, user_ua,
  user_refer, user_this_path, user_this_route,
  user_this_route_params, user_last_path,
  user_last_route, user_last_route_params,
  user_request_data, requested_at,
  user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO traffic_data (hash, user_token, user_ip, user_ua, user_refer, user_this_path, user_this_route, user_this_route_params, user_last_path, user_last_route, user_last_route_params, user_request_data, requested_at, user_id) VALUES ('822d62d7496d06bd7dc7d7d0c8a19951', '28adc73b368253b16dd0500ee509e05826624b6887384a9b7f7c415ceddd2db9', '4.15.214.190', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 'https://staging.rooferscoffeeshop.com/', '/ajax/mitem-impressions', 'app_rcs_content_mitemimpressionsajax', '[]', '/ajax/content-impressions', 'app_rcs_content_contentimpressionsajax', '[]', '{\"ids\":[\"7309\",\"6940\",\"6940\",\"6775\",\"7092\",\"7176\",\"7097\",\"7174\",\"7196\",\"7166\",\"6956\",\"7296\",\"6126\",\"6845\",\"6969\",\"6902\",\"7250\",\"7300\"]}', '2024-08-02 14:36:33', '2355');

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.title AS title_3,
  t0.display_title AS display_title_4,
  t0.description AS description_5,
  t0.sort AS sort_6,
  t0.modified_at AS modified_at_7,
  t0.created_at AS created_at_8,
  t0.published_at AS published_at_9,
  t0.expires_at AS expires_at_10,
  t0.status AS status_11,
  t0.total_impressions AS total_impressions_12,
  t0.total_clicks AS total_clicks_13,
  t0.attributes AS attributes_14,
  t0.external_url AS external_url_15,
  t0.youtube_url AS youtube_url_16,
  t0.french_url AS french_url_17,
  t0.spanish_url AS spanish_url_18,
  t0.countdown AS countdown_19,
  t0.question_slider AS question_slider_20,
  t0.site_default AS site_default_21,
  t0.pinned_uuid AS pinned_uuid_22,
  t0.media_id AS media_id_23,
  t0.secondary_media_id AS secondary_media_id_24,
  t0.french_media_id AS french_media_id_25,
  t0.spanish_media_id AS spanish_media_id_26,
  t0.media_group_id AS media_group_id_27,
  t0.gallery_id AS gallery_id_28,
  t29.id AS id_30,
  t29.version AS version_31,
  t29.title AS title_32,
  t29.description AS description_33,
  t29.published_at AS published_at_34,
  t29.modified_at AS modified_at_35,
  t29.created_at AS created_at_36,
  t29.response_close_date AS response_close_date_37,
  t29.expires_at AS expires_at_38,
  t29.status AS status_39,
  t29.info_url AS info_url_40,
  t29.total_impressions AS total_impressions_41,
  t29.requires_login AS requires_login_42,
  t29.type AS type_43,
  t29.media_id AS media_id_44,
  t29.ad_id AS ad_id_45,
  t0.pop_out_poll_id AS pop_out_poll_id_46
FROM
  media_group_item t0
  LEFT JOIN poll t29 ON t29.ad_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.display_title AS display_title_4, t0.description AS description_5, t0.sort AS sort_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.published_at AS published_at_9, t0.expires_at AS expires_at_10, t0.status AS status_11, t0.total_impressions AS total_impressions_12, t0.total_clicks AS total_clicks_13, t0.attributes AS attributes_14, t0.external_url AS external_url_15, t0.youtube_url AS youtube_url_16, t0.french_url AS french_url_17, t0.spanish_url AS spanish_url_18, t0.countdown AS countdown_19, t0.question_slider AS question_slider_20, t0.site_default AS site_default_21, t0.pinned_uuid AS pinned_uuid_22, t0.media_id AS media_id_23, t0.secondary_media_id AS secondary_media_id_24, t0.french_media_id AS french_media_id_25, t0.spanish_media_id AS spanish_media_id_26, t0.media_group_id AS media_group_id_27, t0.gallery_id AS gallery_id_28, t29.id AS id_30, t29.version AS version_31, t29.title AS title_32, t29.description AS description_33, t29.published_at AS published_at_34, t29.modified_at AS modified_at_35, t29.created_at AS created_at_36, t29.response_close_date AS response_close_date_37, t29.expires_at AS expires_at_38, t29.status AS status_39, t29.info_url AS info_url_40, t29.total_impressions AS total_impressions_41, t29.requires_login AS requires_login_42, t29.type AS type_43, t29.media_id AS media_id_44, t29.ad_id AS ad_id_45, t0.pop_out_poll_id AS pop_out_poll_id_46 FROM media_group_item t0 LEFT JOIN poll t29 ON t29.ad_id = t0.id WHERE t0.id = 7309 LIMIT 1;

INSERT INTO ad_impression (
  site_id, requested_at, hash, media_group_item_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (1, '2024-08-02 14:36:33', '822d62d7496d06bd7dc7d7d0c8a19951', '7309');

"START TRANSACTION"

"START TRANSACTION";

SELECT
  c0_.id AS id_0,
  c0_.version AS version_1,
  c0_.featured_image AS featured_image_2,
  c0_.media_url AS media_url_3,
  c0_.type AS type_4,
  c0_.template AS template_5,
  c0_.title AS title_6,
  c0_.slug AS slug_7,
  c0_.searchable AS searchable_8,
  c0_.exclude_from_list AS exclude_from_list_9,
  c0_.permission AS permission_10,
  c0_.status AS status_11,
  c0_.members_only AS members_only_12,
  c0_.include_author_byline AS include_author_byline_13,
  c0_.include_author_bio AS include_author_bio_14,
  c0_.include_customer_call_to_action AS include_customer_call_to_action_15,
  c0_.include_customer_bio AS include_customer_bio_16,
  c0_.total_impressions AS total_impressions_17,
  c0_.total_clicks AS total_clicks_18,
  c0_.published_at AS published_at_19,
  c0_.modified_at AS modified_at_20,
  c0_.created_at AS created_at_21,
  c0_.content_intro AS content_intro_22,
  c0_.content_full AS content_full_23,
  c0_.meta_description AS meta_description_24,
  c0_.meta_keywords AS meta_keywords_25,
  c0_.content_builder AS content_builder_26,
  c0_.show_title AS show_title_27,
  c0_.old_id AS old_id_28,
  c0_.featured AS featured_29,
  c0_.announcement AS announcement_30,
  c0_.announcement_sites AS announcement_sites_31,
  c0_.expires_at AS expires_at_32,
  c0_.hootsuite_content AS hootsuite_content_33,
  c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34,
  c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35,
  c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36,
  c0_.hootsuite_to_publish AS hootsuite_to_publish_37,
  c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38,
  c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39,
  c0_.hootsuite_published_at AS hootsuite_published_at_40,
  c0_.prnt_id AS prnt_id_41,
  c0_.media_id AS media_id_42,
  c0_.dummy_media_id AS dummy_media_id_43,
  c0_.video_media_id AS video_media_id_44,
  c0_.author_id AS author_id_45,
  c0_.category_id AS category_id_46,
  c0_.primary_customer_id AS primary_customer_id_47,
  c0_.form_id AS form_id_48,
  c0_.popout_ad_id AS popout_ad_id_49,
  c0_.hootsuite_media_id AS hootsuite_media_id_50
FROM
  content c0_
  INNER JOIN content_site c2_ ON c0_.id = c2_.content_id
  INNER JOIN site s1_ ON s1_.id = c2_.site_id
WHERE
  c0_.slug = ?
  AND s1_.id = ?

SELECT c0_.id AS id_0, c0_.version AS version_1, c0_.featured_image AS featured_image_2, c0_.media_url AS media_url_3, c0_.type AS type_4, c0_.template AS template_5, c0_.title AS title_6, c0_.slug AS slug_7, c0_.searchable AS searchable_8, c0_.exclude_from_list AS exclude_from_list_9, c0_.permission AS permission_10, c0_.status AS status_11, c0_.members_only AS members_only_12, c0_.include_author_byline AS include_author_byline_13, c0_.include_author_bio AS include_author_bio_14, c0_.include_customer_call_to_action AS include_customer_call_to_action_15, c0_.include_customer_bio AS include_customer_bio_16, c0_.total_impressions AS total_impressions_17, c0_.total_clicks AS total_clicks_18, c0_.published_at AS published_at_19, c0_.modified_at AS modified_at_20, c0_.created_at AS created_at_21, c0_.content_intro AS content_intro_22, c0_.content_full AS content_full_23, c0_.meta_description AS meta_description_24, c0_.meta_keywords AS meta_keywords_25, c0_.content_builder AS content_builder_26, c0_.show_title AS show_title_27, c0_.old_id AS old_id_28, c0_.featured AS featured_29, c0_.announcement AS announcement_30, c0_.announcement_sites AS announcement_sites_31, c0_.expires_at AS expires_at_32, c0_.hootsuite_content AS hootsuite_content_33, c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34, c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35, c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36, c0_.hootsuite_to_publish AS hootsuite_to_publish_37, c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38, c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39, c0_.hootsuite_published_at AS hootsuite_published_at_40, c0_.prnt_id AS prnt_id_41, c0_.media_id AS media_id_42, c0_.dummy_media_id AS dummy_media_id_43, c0_.video_media_id AS video_media_id_44, c0_.author_id AS author_id_45, c0_.category_id AS category_id_46, c0_.primary_customer_id AS primary_customer_id_47, c0_.form_id AS form_id_48, c0_.popout_ad_id AS popout_ad_id_49, c0_.hootsuite_media_id AS hootsuite_media_id_50 FROM content c0_ INNER JOIN content_site c2_ ON c0_.id = c2_.content_id INNER JOIN site s1_ ON s1_.id = c2_.site_id WHERE c0_.slug = 'mitem-impressions' AND s1_.id = 1;

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.title AS title_3,
  t0.display_title AS display_title_4,
  t0.description AS description_5,
  t0.sort AS sort_6,
  t0.modified_at AS modified_at_7,
  t0.created_at AS created_at_8,
  t0.published_at AS published_at_9,
  t0.expires_at AS expires_at_10,
  t0.status AS status_11,
  t0.total_impressions AS total_impressions_12,
  t0.total_clicks AS total_clicks_13,
  t0.attributes AS attributes_14,
  t0.external_url AS external_url_15,
  t0.youtube_url AS youtube_url_16,
  t0.french_url AS french_url_17,
  t0.spanish_url AS spanish_url_18,
  t0.countdown AS countdown_19,
  t0.question_slider AS question_slider_20,
  t0.site_default AS site_default_21,
  t0.pinned_uuid AS pinned_uuid_22,
  t0.media_id AS media_id_23,
  t0.secondary_media_id AS secondary_media_id_24,
  t0.french_media_id AS french_media_id_25,
  t0.spanish_media_id AS spanish_media_id_26,
  t0.media_group_id AS media_group_id_27,
  t0.gallery_id AS gallery_id_28,
  t29.id AS id_30,
  t29.version AS version_31,
  t29.title AS title_32,
  t29.description AS description_33,
  t29.published_at AS published_at_34,
  t29.modified_at AS modified_at_35,
  t29.created_at AS created_at_36,
  t29.response_close_date AS response_close_date_37,
  t29.expires_at AS expires_at_38,
  t29.status AS status_39,
  t29.info_url AS info_url_40,
  t29.total_impressions AS total_impressions_41,
  t29.requires_login AS requires_login_42,
  t29.type AS type_43,
  t29.media_id AS media_id_44,
  t29.ad_id AS ad_id_45,
  t0.pop_out_poll_id AS pop_out_poll_id_46
FROM
  media_group_item t0
  LEFT JOIN poll t29 ON t29.ad_id = t0.id
WHERE
  t0.pop_out_poll_id = ?

SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.display_title AS display_title_4, t0.description AS description_5, t0.sort AS sort_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.published_at AS published_at_9, t0.expires_at AS expires_at_10, t0.status AS status_11, t0.total_impressions AS total_impressions_12, t0.total_clicks AS total_clicks_13, t0.attributes AS attributes_14, t0.external_url AS external_url_15, t0.youtube_url AS youtube_url_16, t0.french_url AS french_url_17, t0.spanish_url AS spanish_url_18, t0.countdown AS countdown_19, t0.question_slider AS question_slider_20, t0.site_default AS site_default_21, t0.pinned_uuid AS pinned_uuid_22, t0.media_id AS media_id_23, t0.secondary_media_id AS secondary_media_id_24, t0.french_media_id AS french_media_id_25, t0.spanish_media_id AS spanish_media_id_26, t0.media_group_id AS media_group_id_27, t0.gallery_id AS gallery_id_28, t29.id AS id_30, t29.version AS version_31, t29.title AS title_32, t29.description AS description_33, t29.published_at AS published_at_34, t29.modified_at AS modified_at_35, t29.created_at AS created_at_36, t29.response_close_date AS response_close_date_37, t29.expires_at AS expires_at_38, t29.status AS status_39, t29.info_url AS info_url_40, t29.total_impressions AS total_impressions_41, t29.requires_login AS requires_login_42, t29.type AS type_43, t29.media_id AS media_id_44, t29.ad_id AS ad_id_45, t0.pop_out_poll_id AS pop_out_poll_id_46 FROM media_group_item t0 LEFT JOIN poll t29 ON t29.ad_id = t0.id WHERE t0.pop_out_poll_id = '16';

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.image AS image_3,
  t0.username AS username_4,
  t0.password AS password_5,
  t0.email AS email_6,
  t0.firstname AS firstname_7,
  t0.lastname AS lastname_8,
  t0.displayname AS displayname_9,
  t0.role AS role_10,
  t0.type AS type_11,
  t0.status AS status_12,
  t0.member AS member_13,
  t0.member_expires AS member_expires_14,
  t0.created_at AS created_at_15,
  t0.modified_at AS modified_at_16,
  t0.activation_token AS activation_token_17,
  t0.activation_expires AS activation_expires_18,
  t0.reset_pw_token AS reset_pw_token_19,
  t0.reset_pw_expires AS reset_pw_expires_20,
  t0.mfa_token AS mfa_token_21,
  t0.mfa_code AS mfa_code_22,
  t0.mfa_token_expires AS mfa_token_expires_23,
  t0.site_signed_up_on AS site_signed_up_on_24,
  t0.author_bio AS author_bio_25,
  t0.media_id AS media_id_26,
  t0.contact_id AS contact_id_27,
  t28.id AS id_29,
  t28.poll_option_id AS poll_option_id_30,
  t28.user_id AS user_id_31
FROM
  user t0
  LEFT JOIN poll_response t28 ON t28.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.version AS version_2, t0.image AS image_3, t0.username AS username_4, t0.password AS password_5, t0.email AS email_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.displayname AS displayname_9, t0.role AS role_10, t0.type AS type_11, t0.status AS status_12, t0.member AS member_13, t0.member_expires AS member_expires_14, t0.created_at AS created_at_15, t0.modified_at AS modified_at_16, t0.activation_token AS activation_token_17, t0.activation_expires AS activation_expires_18, t0.reset_pw_token AS reset_pw_token_19, t0.reset_pw_expires AS reset_pw_expires_20, t0.mfa_token AS mfa_token_21, t0.mfa_code AS mfa_code_22, t0.mfa_token_expires AS mfa_token_expires_23, t0.site_signed_up_on AS site_signed_up_on_24, t0.author_bio AS author_bio_25, t0.media_id AS media_id_26, t0.contact_id AS contact_id_27, t28.id AS id_29, t28.poll_option_id AS poll_option_id_30, t28.user_id AS user_id_31 FROM user t0 LEFT JOIN poll_response t28 ON t28.user_id = t0.id WHERE t0.id = '2355';

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.type AS type_3,
  t0.status AS status_4,
  t0.poll_id AS poll_id_5,
  t6.id AS id_7,
  t6.poll_option_id AS poll_option_id_8,
  t6.user_id AS user_id_9,
  t0.media_group_item_id AS media_group_item_id_10
FROM
  poll_option t0
  LEFT JOIN poll_response t6 ON t6.poll_option_id = t0.id
WHERE
  t0.poll_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.type AS type_3, t0.status AS status_4, t0.poll_id AS poll_id_5, t6.id AS id_7, t6.poll_option_id AS poll_option_id_8, t6.user_id AS user_id_9, t0.media_group_item_id AS media_group_item_id_10 FROM poll_option t0 LEFT JOIN poll_response t6 ON t6.poll_option_id = t0.id WHERE t0.poll_id = '16';