POST https://staging.rooferscoffeeshop.com/ajax/content-impressions

Query Metrics

12 Database Queries
7 Different statements
4.63 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.51 ms
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 = ?
Parameters:
[
  "2355"
]
2 0.29 ms
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 = ?
Parameters:
[
  "content-impressions"
  1
]
3 0.29 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.featured_image AS featured_image_3, t0.media_url AS media_url_4, t0.type AS type_5, t0.template AS template_6, t0.title AS title_7, t0.slug AS slug_8, t0.searchable AS searchable_9, t0.exclude_from_list AS exclude_from_list_10, t0.permission AS permission_11, t0.status AS status_12, t0.members_only AS members_only_13, t0.include_author_byline AS include_author_byline_14, t0.include_author_bio AS include_author_bio_15, t0.include_customer_call_to_action AS include_customer_call_to_action_16, t0.include_customer_bio AS include_customer_bio_17, t0.total_impressions AS total_impressions_18, t0.total_clicks AS total_clicks_19, t0.published_at AS published_at_20, t0.modified_at AS modified_at_21, t0.created_at AS created_at_22, t0.content_intro AS content_intro_23, t0.content_full AS content_full_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.content_builder AS content_builder_27, t0.show_title AS show_title_28, t0.old_id AS old_id_29, t0.featured AS featured_30, t0.announcement AS announcement_31, t0.announcement_sites AS announcement_sites_32, t0.expires_at AS expires_at_33, t0.hootsuite_content AS hootsuite_content_34, t0.hootsuite_facebook_content AS hootsuite_facebook_content_35, t0.hootsuite_twitter_content AS hootsuite_twitter_content_36, t0.hootsuite_linkedin_content AS hootsuite_linkedin_content_37, t0.hootsuite_to_publish AS hootsuite_to_publish_38, t0.hootsuite_use_post_media AS hootsuite_use_post_media_39, t0.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_40, t0.hootsuite_published_at AS hootsuite_published_at_41, t0.prnt_id AS prnt_id_42, t0.media_id AS media_id_43, t0.dummy_media_id AS dummy_media_id_44, t0.video_media_id AS video_media_id_45, t0.author_id AS author_id_46, t0.category_id AS category_id_47, t0.primary_customer_id AS primary_customer_id_48, t49.id AS id_50, t49.version AS version_51, t49.title AS title_52, t49.description AS description_53, t49.call_to_action AS call_to_action_54, t49.bio AS bio_55, t49.modified_at AS modified_at_56, t49.created_at AS created_at_57, t49.status AS status_58, t49.email AS email_59, t49.external_request_more AS external_request_more_60, t49.website AS website_61, t49.facebook AS facebook_62, t49.twitter AS twitter_63, t49.linkedin AS linkedin_64, t49.instagram AS instagram_65, t49.tiktok AS tiktok_66, t49.youtube AS youtube_67, t49.hash_tag AS hash_tag_68, t49.location AS location_69, t49.state AS state_70, t49.keywords AS keywords_71, t49.customer_level AS customer_level_72, t49.customer_type AS customer_type_73, t49.type_work AS type_work_74, t49.show_photos AS show_photos_75, t49.prnt_id AS prnt_id_76, t49.literature_id AS literature_id_77, t49.photo_gallery_id AS photo_gallery_id_78, t49.video_gallery_id AS video_gallery_id_79, t49.logo_id AS logo_id_80, t49.media_id AS media_id_81, t49.dummy_media_id AS dummy_media_id_82, t49.blog_id AS blog_id_83, t49.branch_locator_id AS branch_locator_id_84, t49.external_events_id AS external_events_id_85, t49.newsletters_id AS newsletters_id_86, t49.partners_reps_id AS partners_reps_id_87, t49.rep_lines_id AS rep_lines_id_88, t49.directory_content_id AS directory_content_id_89, t0.form_id AS form_id_90, t0.popout_ad_id AS popout_ad_id_91, t0.hootsuite_media_id AS hootsuite_media_id_92 FROM content t0 LEFT JOIN customer t49 ON t49.directory_content_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "117218"
]
4 0.29 ms
SELECT t0.id AS id_1, t0.version AS version_2, t0.featured_image AS featured_image_3, t0.media_url AS media_url_4, t0.type AS type_5, t0.template AS template_6, t0.title AS title_7, t0.slug AS slug_8, t0.searchable AS searchable_9, t0.exclude_from_list AS exclude_from_list_10, t0.permission AS permission_11, t0.status AS status_12, t0.members_only AS members_only_13, t0.include_author_byline AS include_author_byline_14, t0.include_author_bio AS include_author_bio_15, t0.include_customer_call_to_action AS include_customer_call_to_action_16, t0.include_customer_bio AS include_customer_bio_17, t0.total_impressions AS total_impressions_18, t0.total_clicks AS total_clicks_19, t0.published_at AS published_at_20, t0.modified_at AS modified_at_21, t0.created_at AS created_at_22, t0.content_intro AS content_intro_23, t0.content_full AS content_full_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.content_builder AS content_builder_27, t0.show_title AS show_title_28, t0.old_id AS old_id_29, t0.featured AS featured_30, t0.announcement AS announcement_31, t0.announcement_sites AS announcement_sites_32, t0.expires_at AS expires_at_33, t0.hootsuite_content AS hootsuite_content_34, t0.hootsuite_facebook_content AS hootsuite_facebook_content_35, t0.hootsuite_twitter_content AS hootsuite_twitter_content_36, t0.hootsuite_linkedin_content AS hootsuite_linkedin_content_37, t0.hootsuite_to_publish AS hootsuite_to_publish_38, t0.hootsuite_use_post_media AS hootsuite_use_post_media_39, t0.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_40, t0.hootsuite_published_at AS hootsuite_published_at_41, t0.prnt_id AS prnt_id_42, t0.media_id AS media_id_43, t0.dummy_media_id AS dummy_media_id_44, t0.video_media_id AS video_media_id_45, t0.author_id AS author_id_46, t0.category_id AS category_id_47, t0.primary_customer_id AS primary_customer_id_48, t49.id AS id_50, t49.version AS version_51, t49.title AS title_52, t49.description AS description_53, t49.call_to_action AS call_to_action_54, t49.bio AS bio_55, t49.modified_at AS modified_at_56, t49.created_at AS created_at_57, t49.status AS status_58, t49.email AS email_59, t49.external_request_more AS external_request_more_60, t49.website AS website_61, t49.facebook AS facebook_62, t49.twitter AS twitter_63, t49.linkedin AS linkedin_64, t49.instagram AS instagram_65, t49.tiktok AS tiktok_66, t49.youtube AS youtube_67, t49.hash_tag AS hash_tag_68, t49.location AS location_69, t49.state AS state_70, t49.keywords AS keywords_71, t49.customer_level AS customer_level_72, t49.customer_type AS customer_type_73, t49.type_work AS type_work_74, t49.show_photos AS show_photos_75, t49.prnt_id AS prnt_id_76, t49.literature_id AS literature_id_77, t49.photo_gallery_id AS photo_gallery_id_78, t49.video_gallery_id AS video_gallery_id_79, t49.logo_id AS logo_id_80, t49.media_id AS media_id_81, t49.dummy_media_id AS dummy_media_id_82, t49.blog_id AS blog_id_83, t49.branch_locator_id AS branch_locator_id_84, t49.external_events_id AS external_events_id_85, t49.newsletters_id AS newsletters_id_86, t49.partners_reps_id AS partners_reps_id_87, t49.rep_lines_id AS rep_lines_id_88, t49.directory_content_id AS directory_content_id_89, t0.form_id AS form_id_90, t0.popout_ad_id AS popout_ad_id_91, t0.hootsuite_media_id AS hootsuite_media_id_92 FROM content t0 LEFT JOIN customer t49 ON t49.directory_content_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "117091"
]
5 0.16 ms
"START TRANSACTION"
Parameters:
[]
6 0.36 ms
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "ddc7fc4f7f4007a51bd65dae3f561276"
  "df4dee7fd288182c7835a72077626b96a33a22221337ee4708766ee0e41e3453"
  "4.15.214.190"
  "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36"
  "https://staging.rooferscoffeeshop.com/en-espanol"
  "/ajax/content-impressions"
  "app_rcs_content_contentimpressionsajax"
  "[]"
  "/en-espanol"
  "app_rcs_content_spanishmainpage"
  "[]"
  "[]"
  "2024-09-16 10:54:36"
  "2355"
]
7 0.29 ms
INSERT INTO content_impression (site_id, requested_at, hash, content_id) VALUES (?, ?, ?, ?)
Parameters:
[
  1
  "2024-09-16 10:54:36"
  "ddc7fc4f7f4007a51bd65dae3f561276"
  "117218"
]
8 0.98 ms
"COMMIT"
Parameters:
[]
9 0.15 ms
"START TRANSACTION"
Parameters:
[]
10 0.29 ms
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "81fcf6f788664e9c0bbbd6ce1d98585d"
  "df4dee7fd288182c7835a72077626b96a33a22221337ee4708766ee0e41e3453"
  "4.15.214.190"
  "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36"
  "https://staging.rooferscoffeeshop.com/en-espanol"
  "/ajax/content-impressions"
  "app_rcs_content_contentimpressionsajax"
  "[]"
  "/en-espanol"
  "app_rcs_content_spanishmainpage"
  "[]"
  "[]"
  "2024-09-16 10:54:36"
  "2355"
]
11 0.27 ms
INSERT INTO content_impression (site_id, requested_at, hash, content_id) VALUES (?, ?, ?, ?)
Parameters:
[
  1
  "2024-09-16 10:54:36"
  "81fcf6f788664e9c0bbbd6ce1d98585d"
  "117091"
]
12 0.75 ms
"COMMIT"
Parameters:
[]

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.