Query Metrics
96
Database Queries
6
Different statements
108.94 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.96 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:
[ "mitem-impressions" 1 ] |
2 | 0.58 ms |
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
Parameters:
[
7309
]
|
3 | 0.15 ms |
"START TRANSACTION"
Parameters:
[] |
4 | 0.33 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:
[ "6cbba583e7074b1b9c94e94e69c4b3d6" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:00" null ] |
5 | 0.21 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:00" "6cbba583e7074b1b9c94e94e69c4b3d6" "7309" ] |
6 | 6.41 ms |
"COMMIT"
Parameters:
[] |
7 | 0.49 ms |
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
Parameters:
[
6940
]
|
8 | 0.10 ms |
"START TRANSACTION"
Parameters:
[] |
9 | 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:
[ "718e804cb79c53867c7f379f09de1c41" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:00" null ] |
10 | 0.26 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:00" "718e804cb79c53867c7f379f09de1c41" "6940" ] |
11 | 3.96 ms |
"COMMIT"
Parameters:
[] |
12 | 0.21 ms |
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
Parameters:
[
6940
]
|
13 | 0.14 ms |
"START TRANSACTION"
Parameters:
[] |
14 | 0.27 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:
[ "9a66b77ebf9d2439e232562d269bb5a6" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:00" null ] |
15 | 0.36 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:00" "9a66b77ebf9d2439e232562d269bb5a6" "6940" ] |
16 | 3.47 ms |
"COMMIT"
Parameters:
[] |
17 | 0.47 ms |
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
Parameters:
[
6775
]
|
18 | 0.14 ms |
"START TRANSACTION"
Parameters:
[] |
19 | 0.27 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:
[ "e4bc577b310191f637937210a6697524" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:00" null ] |
20 | 0.19 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:00" "e4bc577b310191f637937210a6697524" "6775" ] |
21 | 3.98 ms |
"COMMIT"
Parameters:
[] |
22 | 0.46 ms |
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
Parameters:
[
7176
]
|
23 | 0.20 ms |
"START TRANSACTION"
Parameters:
[] |
24 | 0.76 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:
[ "ca446bd76f7b204d6806e736b0767fd4" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:00" null ] |
25 | 0.30 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:00" "ca446bd76f7b204d6806e736b0767fd4" "7176" ] |
26 | 1.43 ms |
"COMMIT"
Parameters:
[] |
27 | 2.42 ms |
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
Parameters:
[
7097
]
|
28 | 0.24 ms |
"START TRANSACTION"
Parameters:
[] |
29 | 0.31 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:
[ "d4fb642434c06580fbf0196cc15baf2f" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:00" null ] |
30 | 0.26 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:00" "d4fb642434c06580fbf0196cc15baf2f" "7097" ] |
31 | 0.96 ms |
"COMMIT"
Parameters:
[] |
32 | 0.45 ms |
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
Parameters:
[
7174
]
|
33 | 0.20 ms |
"START TRANSACTION"
Parameters:
[] |
34 | 0.32 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:
[ "a937a16ffe59c52971555e3bf1708497" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:00" null ] |
35 | 0.29 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:00" "a937a16ffe59c52971555e3bf1708497" "7174" ] |
36 | 3.81 ms |
"COMMIT"
Parameters:
[] |
37 | 0.44 ms |
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
Parameters:
[
7196
]
|
38 | 0.20 ms |
"START TRANSACTION"
Parameters:
[] |
39 | 0.27 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:
[ "3b0aa12e2f56f17678ec71b8181affc3" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:00" null ] |
40 | 0.22 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:00" "3b0aa12e2f56f17678ec71b8181affc3" "7196" ] |
41 | 2.53 ms |
"COMMIT"
Parameters:
[] |
42 | 0.49 ms |
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
Parameters:
[
7166
]
|
43 | 0.28 ms |
"START TRANSACTION"
Parameters:
[] |
44 | 1.38 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:
[ "e10a9095b95a92c1800562985c6e8309" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:01" null ] |
45 | 0.22 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:01" "e10a9095b95a92c1800562985c6e8309" "7166" ] |
46 | 2.98 ms |
"COMMIT"
Parameters:
[] |
47 | 0.45 ms |
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
Parameters:
[
6956
]
|
48 | 0.20 ms |
"START TRANSACTION"
Parameters:
[] |
49 | 0.30 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:
[ "1b5a8873eb7161625ddc0b299297d78a" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:01" null ] |
50 | 0.21 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:01" "1b5a8873eb7161625ddc0b299297d78a" "6956" ] |
51 | 9.90 ms |
"COMMIT"
Parameters:
[] |
52 | 0.49 ms |
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
Parameters:
[
7249
]
|
53 | 0.17 ms |
"START TRANSACTION"
Parameters:
[] |
54 | 0.31 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:
[ "2cb9e6966957a1bcf2c00ca1e154165c" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:01" null ] |
55 | 0.22 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:01" "2cb9e6966957a1bcf2c00ca1e154165c" "7249" ] |
56 | 4.38 ms |
"COMMIT"
Parameters:
[] |
57 | 0.46 ms |
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
Parameters:
[
7302
]
|
58 | 0.22 ms |
"START TRANSACTION"
Parameters:
[] |
59 | 0.34 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:
[ "8515890014fc249f502fd36437da8235" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:01" null ] |
60 | 0.20 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:01" "8515890014fc249f502fd36437da8235" "7302" ] |
61 | 2.64 ms |
"COMMIT"
Parameters:
[] |
62 | 0.44 ms |
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
Parameters:
[
6062
]
|
63 | 0.25 ms |
"START TRANSACTION"
Parameters:
[] |
64 | 0.31 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:
[ "2d702bb158458d6fc8a771ac2f4816fe" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:01" null ] |
65 | 0.20 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:01" "2d702bb158458d6fc8a771ac2f4816fe" "6062" ] |
66 | 1.86 ms |
"COMMIT"
Parameters:
[] |
67 | 1.27 ms |
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
Parameters:
[
7171
]
|
68 | 0.22 ms |
"START TRANSACTION"
Parameters:
[] |
69 | 0.84 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:
[ "828c566eb220b685f462dd2146360228" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:01" null ] |
70 | 0.20 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:01" "828c566eb220b685f462dd2146360228" "7171" ] |
71 | 9.85 ms |
"COMMIT"
Parameters:
[] |
72 | 0.48 ms |
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
Parameters:
[
5814
]
|
73 | 3.66 ms |
"START TRANSACTION"
Parameters:
[] |
74 | 0.35 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:
[ "8d640a32a7f686171d90f3473c7b8e55" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:01" null ] |
75 | 0.24 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:01" "8d640a32a7f686171d90f3473c7b8e55" "5814" ] |
76 | 4.33 ms |
"COMMIT"
Parameters:
[] |
77 | 0.46 ms |
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
Parameters:
[
7310
]
|
78 | 0.21 ms |
"START TRANSACTION"
Parameters:
[] |
79 | 0.35 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:
[ "8ffc8ca948f668a1ce361376f1a96cef" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:01" null ] |
80 | 0.21 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:01" "8ffc8ca948f668a1ce361376f1a96cef" "7310" ] |
81 | 1.19 ms |
"COMMIT"
Parameters:
[] |
82 | 0.42 ms |
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
Parameters:
[
7304
]
|
83 | 0.28 ms |
"START TRANSACTION"
Parameters:
[] |
84 | 0.31 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:
[ "ad8a0932fad161a46afb66ad44e697e7" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:01" null ] |
85 | 0.20 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:01" "ad8a0932fad161a46afb66ad44e697e7" "7304" ] |
86 | 2.88 ms |
"COMMIT"
Parameters:
[] |
87 | 0.43 ms |
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
Parameters:
[
7095
]
|
88 | 0.22 ms |
"START TRANSACTION"
Parameters:
[] |
89 | 0.42 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:
[ "89178a4d9403417bfc5b0205b7cec363" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:01" null ] |
90 | 0.22 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:01" "89178a4d9403417bfc5b0205b7cec363" "7095" ] |
91 | 8.79 ms |
"COMMIT"
Parameters:
[] |
92 | 0.45 ms |
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
Parameters:
[
7300
]
|
93 | 0.27 ms |
"START TRANSACTION"
Parameters:
[] |
94 | 0.31 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:
[ "d7037b0210f27827f585f5ae95460b56" "f89eeb1fcfb58133e7502a8a4bc6ce6aec999939b1c4b085bb3e7db038034982" "66.249.77.6" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.6533.99 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" "https://staging.rooferscoffeeshop.com/event/osha-10-hour-training-in-tucson" "/ajax/mitem-impressions" "app_rcs_content_mitemimpressionsajax" "[]" "/event/osha-10-hour-training-in-tucson" "event_master" "{"slug":"osha-10-hour-training-in-tucson"}" "{"ids":["7309","6940","6940","6775","7176","7097","7174","7196","7166","6956","7249","7302","6062","7171","5814","7310","7304","7095","7300"]}" "2024-08-30 16:29:01" null ] |
95 | 0.27 ms |
INSERT INTO ad_impression (site_id, requested_at, hash, media_group_item_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-08-30 16:29:01" "d7037b0210f27827f585f5ae95460b56" "7300" ] |
96 | 1.40 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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Content | No errors. |
App\Entity\Site | No errors. |
App\Entity\Media | No errors. |
App\Entity\User | No errors. |
App\Entity\Category | No errors. |
App\Entity\Customer | No errors. |
App\Entity\Form | No errors. |
App\Entity\MediaGroupItem | No errors. |
App\Entity\MediaGroup | No errors. |
App\Entity\Poll | No errors. |
App\Entity\Traffic | No errors. |
App\Entity\AdImpression | No errors. |
App\Entity\AdClick | No errors. |
App\Entity\AdAnalyticsDaily | No errors. |
App\Entity\PollOption | No errors. |
App\Entity\AdPin | No errors. |
App\Entity\AdPriority | No errors. |
App\Entity\TrafficData | No errors. |