Query Metrics
79
Database Queries
14
Different statements
87.20 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.95 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:
[ "7" 1 ] |
2 | 0.60 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_ WHERE c0_.slug = ? AND c0_.type = ? AND (c0_.status = 1 OR c0_.status = -5) LIMIT 1
Parameters:
[ "roofing-alliance" 4 ] |
3 | 0.60 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.call_to_action AS call_to_action_5, t0.bio AS bio_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.email AS email_10, t0.external_request_more AS external_request_more_11, t0.website AS website_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.linkedin AS linkedin_15, t0.instagram AS instagram_16, t0.tiktok AS tiktok_17, t0.youtube AS youtube_18, t0.hash_tag AS hash_tag_19, t0.location AS location_20, t0.state AS state_21, t0.keywords AS keywords_22, t0.customer_level AS customer_level_23, t0.customer_type AS customer_type_24, t0.type_work AS type_work_25, t0.prnt_id AS prnt_id_26, t0.literature_id AS literature_id_27, t0.photo_gallery_id AS photo_gallery_id_28, t0.video_gallery_id AS video_gallery_id_29, t0.logo_id AS logo_id_30, t0.media_id AS media_id_31, t0.dummy_media_id AS dummy_media_id_32, t0.blog_id AS blog_id_33, t0.branch_locator_id AS branch_locator_id_34, t0.external_events_id AS external_events_id_35, t0.newsletters_id AS newsletters_id_36, t0.partners_reps_id AS partners_reps_id_37, t0.rep_lines_id AS rep_lines_id_38, t0.directory_content_id AS directory_content_id_39 FROM customer t0 WHERE t0.directory_content_id = ?
Parameters:
[
"92580"
]
|
4 | 7.66 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 customer_content c2_ ON c0_.id = c2_.content_id INNER JOIN customer c1_ ON c1_.id = c2_.customer_id AND (c1_.id = '42') INNER JOIN content_category c4_ ON c0_.id = c4_.content_id INNER JOIN category c3_ ON c3_.id = c4_.category_id LEFT JOIN category c5_ ON c3_.prnt_id = c5_.id LEFT JOIN category c6_ ON c5_.prnt_id = c6_.id LEFT JOIN category c7_ ON c6_.prnt_id = c7_.id LEFT JOIN category c8_ ON c0_.category_id = c8_.id AND ((c8_.slug <> 'buy-online' AND c8_.slug <> 'partner-videos') OR c8_.id IS NULL) WHERE (c0_.type = 2 AND c0_.status = 1) AND ((c3_.slug = 'newsroom' OR c5_.slug = 'newsroom' OR c6_.slug = 'newsroom' OR c7_.slug = 'newsroom' OR c3_.slug IN ('rcs-influencers', 'mcs-influencers', 'ccs-influencers') OR c5_.slug IN ('rcs-influencers', 'mcs-influencers', 'ccs-influencers'))) ORDER BY c0_.published_at DESC LIMIT 10 OFFSET 60
Parameters:
[] |
5 | 0.48 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.call_to_action AS call_to_action_5, t0.bio AS bio_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.email AS email_10, t0.external_request_more AS external_request_more_11, t0.website AS website_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.linkedin AS linkedin_15, t0.instagram AS instagram_16, t0.tiktok AS tiktok_17, t0.youtube AS youtube_18, t0.hash_tag AS hash_tag_19, t0.location AS location_20, t0.state AS state_21, t0.keywords AS keywords_22, t0.customer_level AS customer_level_23, t0.customer_type AS customer_type_24, t0.type_work AS type_work_25, t0.prnt_id AS prnt_id_26, t0.literature_id AS literature_id_27, t0.photo_gallery_id AS photo_gallery_id_28, t0.video_gallery_id AS video_gallery_id_29, t0.logo_id AS logo_id_30, t0.media_id AS media_id_31, t0.dummy_media_id AS dummy_media_id_32, t0.blog_id AS blog_id_33, t0.branch_locator_id AS branch_locator_id_34, t0.external_events_id AS external_events_id_35, t0.newsletters_id AS newsletters_id_36, t0.partners_reps_id AS partners_reps_id_37, t0.rep_lines_id AS rep_lines_id_38, t0.directory_content_id AS directory_content_id_39 FROM customer t0 WHERE t0.directory_content_id = ?
Parameters:
[
"112592"
]
|
6 | 0.43 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.call_to_action AS call_to_action_5, t0.bio AS bio_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.email AS email_10, t0.external_request_more AS external_request_more_11, t0.website AS website_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.linkedin AS linkedin_15, t0.instagram AS instagram_16, t0.tiktok AS tiktok_17, t0.youtube AS youtube_18, t0.hash_tag AS hash_tag_19, t0.location AS location_20, t0.state AS state_21, t0.keywords AS keywords_22, t0.customer_level AS customer_level_23, t0.customer_type AS customer_type_24, t0.type_work AS type_work_25, t0.prnt_id AS prnt_id_26, t0.literature_id AS literature_id_27, t0.photo_gallery_id AS photo_gallery_id_28, t0.video_gallery_id AS video_gallery_id_29, t0.logo_id AS logo_id_30, t0.media_id AS media_id_31, t0.dummy_media_id AS dummy_media_id_32, t0.blog_id AS blog_id_33, t0.branch_locator_id AS branch_locator_id_34, t0.external_events_id AS external_events_id_35, t0.newsletters_id AS newsletters_id_36, t0.partners_reps_id AS partners_reps_id_37, t0.rep_lines_id AS rep_lines_id_38, t0.directory_content_id AS directory_content_id_39 FROM customer t0 WHERE t0.directory_content_id = ?
Parameters:
[
"112517"
]
|
7 | 0.42 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.call_to_action AS call_to_action_5, t0.bio AS bio_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.email AS email_10, t0.external_request_more AS external_request_more_11, t0.website AS website_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.linkedin AS linkedin_15, t0.instagram AS instagram_16, t0.tiktok AS tiktok_17, t0.youtube AS youtube_18, t0.hash_tag AS hash_tag_19, t0.location AS location_20, t0.state AS state_21, t0.keywords AS keywords_22, t0.customer_level AS customer_level_23, t0.customer_type AS customer_type_24, t0.type_work AS type_work_25, t0.prnt_id AS prnt_id_26, t0.literature_id AS literature_id_27, t0.photo_gallery_id AS photo_gallery_id_28, t0.video_gallery_id AS video_gallery_id_29, t0.logo_id AS logo_id_30, t0.media_id AS media_id_31, t0.dummy_media_id AS dummy_media_id_32, t0.blog_id AS blog_id_33, t0.branch_locator_id AS branch_locator_id_34, t0.external_events_id AS external_events_id_35, t0.newsletters_id AS newsletters_id_36, t0.partners_reps_id AS partners_reps_id_37, t0.rep_lines_id AS rep_lines_id_38, t0.directory_content_id AS directory_content_id_39 FROM customer t0 WHERE t0.directory_content_id = ?
Parameters:
[
"111919"
]
|
8 | 0.40 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.call_to_action AS call_to_action_5, t0.bio AS bio_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.email AS email_10, t0.external_request_more AS external_request_more_11, t0.website AS website_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.linkedin AS linkedin_15, t0.instagram AS instagram_16, t0.tiktok AS tiktok_17, t0.youtube AS youtube_18, t0.hash_tag AS hash_tag_19, t0.location AS location_20, t0.state AS state_21, t0.keywords AS keywords_22, t0.customer_level AS customer_level_23, t0.customer_type AS customer_type_24, t0.type_work AS type_work_25, t0.prnt_id AS prnt_id_26, t0.literature_id AS literature_id_27, t0.photo_gallery_id AS photo_gallery_id_28, t0.video_gallery_id AS video_gallery_id_29, t0.logo_id AS logo_id_30, t0.media_id AS media_id_31, t0.dummy_media_id AS dummy_media_id_32, t0.blog_id AS blog_id_33, t0.branch_locator_id AS branch_locator_id_34, t0.external_events_id AS external_events_id_35, t0.newsletters_id AS newsletters_id_36, t0.partners_reps_id AS partners_reps_id_37, t0.rep_lines_id AS rep_lines_id_38, t0.directory_content_id AS directory_content_id_39 FROM customer t0 WHERE t0.directory_content_id = ?
Parameters:
[
"111869"
]
|
9 | 0.46 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.call_to_action AS call_to_action_5, t0.bio AS bio_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.email AS email_10, t0.external_request_more AS external_request_more_11, t0.website AS website_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.linkedin AS linkedin_15, t0.instagram AS instagram_16, t0.tiktok AS tiktok_17, t0.youtube AS youtube_18, t0.hash_tag AS hash_tag_19, t0.location AS location_20, t0.state AS state_21, t0.keywords AS keywords_22, t0.customer_level AS customer_level_23, t0.customer_type AS customer_type_24, t0.type_work AS type_work_25, t0.prnt_id AS prnt_id_26, t0.literature_id AS literature_id_27, t0.photo_gallery_id AS photo_gallery_id_28, t0.video_gallery_id AS video_gallery_id_29, t0.logo_id AS logo_id_30, t0.media_id AS media_id_31, t0.dummy_media_id AS dummy_media_id_32, t0.blog_id AS blog_id_33, t0.branch_locator_id AS branch_locator_id_34, t0.external_events_id AS external_events_id_35, t0.newsletters_id AS newsletters_id_36, t0.partners_reps_id AS partners_reps_id_37, t0.rep_lines_id AS rep_lines_id_38, t0.directory_content_id AS directory_content_id_39 FROM customer t0 WHERE t0.directory_content_id = ?
Parameters:
[
"111787"
]
|
10 | 0.42 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.call_to_action AS call_to_action_5, t0.bio AS bio_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.email AS email_10, t0.external_request_more AS external_request_more_11, t0.website AS website_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.linkedin AS linkedin_15, t0.instagram AS instagram_16, t0.tiktok AS tiktok_17, t0.youtube AS youtube_18, t0.hash_tag AS hash_tag_19, t0.location AS location_20, t0.state AS state_21, t0.keywords AS keywords_22, t0.customer_level AS customer_level_23, t0.customer_type AS customer_type_24, t0.type_work AS type_work_25, t0.prnt_id AS prnt_id_26, t0.literature_id AS literature_id_27, t0.photo_gallery_id AS photo_gallery_id_28, t0.video_gallery_id AS video_gallery_id_29, t0.logo_id AS logo_id_30, t0.media_id AS media_id_31, t0.dummy_media_id AS dummy_media_id_32, t0.blog_id AS blog_id_33, t0.branch_locator_id AS branch_locator_id_34, t0.external_events_id AS external_events_id_35, t0.newsletters_id AS newsletters_id_36, t0.partners_reps_id AS partners_reps_id_37, t0.rep_lines_id AS rep_lines_id_38, t0.directory_content_id AS directory_content_id_39 FROM customer t0 WHERE t0.directory_content_id = ?
Parameters:
[
"111538"
]
|
11 | 0.41 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.call_to_action AS call_to_action_5, t0.bio AS bio_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.email AS email_10, t0.external_request_more AS external_request_more_11, t0.website AS website_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.linkedin AS linkedin_15, t0.instagram AS instagram_16, t0.tiktok AS tiktok_17, t0.youtube AS youtube_18, t0.hash_tag AS hash_tag_19, t0.location AS location_20, t0.state AS state_21, t0.keywords AS keywords_22, t0.customer_level AS customer_level_23, t0.customer_type AS customer_type_24, t0.type_work AS type_work_25, t0.prnt_id AS prnt_id_26, t0.literature_id AS literature_id_27, t0.photo_gallery_id AS photo_gallery_id_28, t0.video_gallery_id AS video_gallery_id_29, t0.logo_id AS logo_id_30, t0.media_id AS media_id_31, t0.dummy_media_id AS dummy_media_id_32, t0.blog_id AS blog_id_33, t0.branch_locator_id AS branch_locator_id_34, t0.external_events_id AS external_events_id_35, t0.newsletters_id AS newsletters_id_36, t0.partners_reps_id AS partners_reps_id_37, t0.rep_lines_id AS rep_lines_id_38, t0.directory_content_id AS directory_content_id_39 FROM customer t0 WHERE t0.directory_content_id = ?
Parameters:
[
"111429"
]
|
12 | 0.43 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.call_to_action AS call_to_action_5, t0.bio AS bio_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.email AS email_10, t0.external_request_more AS external_request_more_11, t0.website AS website_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.linkedin AS linkedin_15, t0.instagram AS instagram_16, t0.tiktok AS tiktok_17, t0.youtube AS youtube_18, t0.hash_tag AS hash_tag_19, t0.location AS location_20, t0.state AS state_21, t0.keywords AS keywords_22, t0.customer_level AS customer_level_23, t0.customer_type AS customer_type_24, t0.type_work AS type_work_25, t0.prnt_id AS prnt_id_26, t0.literature_id AS literature_id_27, t0.photo_gallery_id AS photo_gallery_id_28, t0.video_gallery_id AS video_gallery_id_29, t0.logo_id AS logo_id_30, t0.media_id AS media_id_31, t0.dummy_media_id AS dummy_media_id_32, t0.blog_id AS blog_id_33, t0.branch_locator_id AS branch_locator_id_34, t0.external_events_id AS external_events_id_35, t0.newsletters_id AS newsletters_id_36, t0.partners_reps_id AS partners_reps_id_37, t0.rep_lines_id AS rep_lines_id_38, t0.directory_content_id AS directory_content_id_39 FROM customer t0 WHERE t0.directory_content_id = ?
Parameters:
[
"111402"
]
|
13 | 0.42 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.call_to_action AS call_to_action_5, t0.bio AS bio_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.email AS email_10, t0.external_request_more AS external_request_more_11, t0.website AS website_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.linkedin AS linkedin_15, t0.instagram AS instagram_16, t0.tiktok AS tiktok_17, t0.youtube AS youtube_18, t0.hash_tag AS hash_tag_19, t0.location AS location_20, t0.state AS state_21, t0.keywords AS keywords_22, t0.customer_level AS customer_level_23, t0.customer_type AS customer_type_24, t0.type_work AS type_work_25, t0.prnt_id AS prnt_id_26, t0.literature_id AS literature_id_27, t0.photo_gallery_id AS photo_gallery_id_28, t0.video_gallery_id AS video_gallery_id_29, t0.logo_id AS logo_id_30, t0.media_id AS media_id_31, t0.dummy_media_id AS dummy_media_id_32, t0.blog_id AS blog_id_33, t0.branch_locator_id AS branch_locator_id_34, t0.external_events_id AS external_events_id_35, t0.newsletters_id AS newsletters_id_36, t0.partners_reps_id AS partners_reps_id_37, t0.rep_lines_id AS rep_lines_id_38, t0.directory_content_id AS directory_content_id_39 FROM customer t0 WHERE t0.directory_content_id = ?
Parameters:
[
"111307"
]
|
14 | 0.43 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.call_to_action AS call_to_action_5, t0.bio AS bio_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.email AS email_10, t0.external_request_more AS external_request_more_11, t0.website AS website_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.linkedin AS linkedin_15, t0.instagram AS instagram_16, t0.tiktok AS tiktok_17, t0.youtube AS youtube_18, t0.hash_tag AS hash_tag_19, t0.location AS location_20, t0.state AS state_21, t0.keywords AS keywords_22, t0.customer_level AS customer_level_23, t0.customer_type AS customer_type_24, t0.type_work AS type_work_25, t0.prnt_id AS prnt_id_26, t0.literature_id AS literature_id_27, t0.photo_gallery_id AS photo_gallery_id_28, t0.video_gallery_id AS video_gallery_id_29, t0.logo_id AS logo_id_30, t0.media_id AS media_id_31, t0.dummy_media_id AS dummy_media_id_32, t0.blog_id AS blog_id_33, t0.branch_locator_id AS branch_locator_id_34, t0.external_events_id AS external_events_id_35, t0.newsletters_id AS newsletters_id_36, t0.partners_reps_id AS partners_reps_id_37, t0.rep_lines_id AS rep_lines_id_38, t0.directory_content_id AS directory_content_id_39 FROM customer t0 WHERE t0.directory_content_id = ?
Parameters:
[
"111274"
]
|
15 | 2.47 ms |
SELECT count(c0_.id) AS sclr_0 FROM content c0_ INNER JOIN customer_content c2_ ON c0_.id = c2_.content_id INNER JOIN customer c1_ ON c1_.id = c2_.customer_id AND (c1_.id = '42') LEFT JOIN category c3_ ON c0_.category_id = c3_.id AND ((c3_.slug <> 'buy-online' AND c3_.slug <> 'partner-videos') OR c3_.id IS NULL) INNER JOIN content_category c5_ ON c0_.id = c5_.content_id INNER JOIN category c4_ ON c4_.id = c5_.category_id LEFT JOIN category c6_ ON c4_.prnt_id = c6_.id LEFT JOIN category c7_ ON c6_.prnt_id = c7_.id LEFT JOIN category c8_ ON c7_.prnt_id = c8_.id WHERE (c0_.type = 2 AND c0_.status = 1) AND ((c4_.slug = 'newsroom' OR c6_.slug = 'newsroom' OR c7_.slug = 'newsroom' OR c8_.slug = 'newsroom'))
Parameters:
[] |
16 | 0.17 ms |
"START TRANSACTION"
Parameters:
[] |
17 | 4.93 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:
[ "30e54ca3c5ed986225a946ca6c7ecf30" "11710bfa026a26305eb03471f38f4fcd14539eece8e44185228a47d850442eff" "18.225.234.89" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "" "/directory/roofing-alliance/posts/7" "directory_posts_master" "{"slug":"roofing-alliance","page":"7"}" "" "" "" "[]" "2024-07-16 09:41:49" null ] |
18 | 3.22 ms |
INSERT INTO content_impression (site_id, requested_at, hash, content_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-07-16 09:41:49" "30e54ca3c5ed986225a946ca6c7ecf30" "112592" ] |
19 | 5.52 ms |
"COMMIT"
Parameters:
[] |
20 | 0.16 ms |
"START TRANSACTION"
Parameters:
[] |
21 | 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:
[ "918948a5427ae836f36243efcac0859f" "11710bfa026a26305eb03471f38f4fcd14539eece8e44185228a47d850442eff" "18.225.234.89" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "" "/directory/roofing-alliance/posts/7" "directory_posts_master" "{"slug":"roofing-alliance","page":"7"}" "" "" "" "[]" "2024-07-16 09:41:49" null ] |
22 | 0.53 ms |
INSERT INTO content_impression (site_id, requested_at, hash, content_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-07-16 09:41:49" "918948a5427ae836f36243efcac0859f" "112517" ] |
23 | 1.05 ms |
"COMMIT"
Parameters:
[] |
24 | 0.15 ms |
"START TRANSACTION"
Parameters:
[] |
25 | 0.54 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:
[ "1989d171b43c508d0fabc32b201a3147" "11710bfa026a26305eb03471f38f4fcd14539eece8e44185228a47d850442eff" "18.225.234.89" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "" "/directory/roofing-alliance/posts/7" "directory_posts_master" "{"slug":"roofing-alliance","page":"7"}" "" "" "" "[]" "2024-07-16 09:41:49" null ] |
26 | 0.40 ms |
INSERT INTO content_impression (site_id, requested_at, hash, content_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-07-16 09:41:49" "1989d171b43c508d0fabc32b201a3147" "111919" ] |
27 | 4.60 ms |
"COMMIT"
Parameters:
[] |
28 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
29 | 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:
[ "49395d77ad96264c35bea1dd4f506d05" "11710bfa026a26305eb03471f38f4fcd14539eece8e44185228a47d850442eff" "18.225.234.89" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "" "/directory/roofing-alliance/posts/7" "directory_posts_master" "{"slug":"roofing-alliance","page":"7"}" "" "" "" "[]" "2024-07-16 09:41:49" null ] |
30 | 2.15 ms |
INSERT INTO content_impression (site_id, requested_at, hash, content_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-07-16 09:41:49" "49395d77ad96264c35bea1dd4f506d05" "111869" ] |
31 | 6.74 ms |
"COMMIT"
Parameters:
[] |
32 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
33 | 4.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:
[ "3c26f510bfc0f17c4e3f35ce43356d55" "11710bfa026a26305eb03471f38f4fcd14539eece8e44185228a47d850442eff" "18.225.234.89" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "" "/directory/roofing-alliance/posts/7" "directory_posts_master" "{"slug":"roofing-alliance","page":"7"}" "" "" "" "[]" "2024-07-16 09:41:49" null ] |
34 | 0.26 ms |
INSERT INTO content_impression (site_id, requested_at, hash, content_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-07-16 09:41:49" "3c26f510bfc0f17c4e3f35ce43356d55" "111787" ] |
35 | 9.45 ms |
"COMMIT"
Parameters:
[] |
36 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
37 | 0.53 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:
[ "4f69d8095c5224a235a6b552faa8d139" "11710bfa026a26305eb03471f38f4fcd14539eece8e44185228a47d850442eff" "18.225.234.89" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "" "/directory/roofing-alliance/posts/7" "directory_posts_master" "{"slug":"roofing-alliance","page":"7"}" "" "" "" "[]" "2024-07-16 09:41:49" null ] |
38 | 0.36 ms |
INSERT INTO content_impression (site_id, requested_at, hash, content_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-07-16 09:41:49" "4f69d8095c5224a235a6b552faa8d139" "111538" ] |
39 | 0.97 ms |
"COMMIT"
Parameters:
[] |
40 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
41 | 1.06 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:
[ "73272e26b432d52d6a4bea006d009450" "11710bfa026a26305eb03471f38f4fcd14539eece8e44185228a47d850442eff" "18.225.234.89" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "" "/directory/roofing-alliance/posts/7" "directory_posts_master" "{"slug":"roofing-alliance","page":"7"}" "" "" "" "[]" "2024-07-16 09:41:49" null ] |
42 | 0.22 ms |
INSERT INTO content_impression (site_id, requested_at, hash, content_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-07-16 09:41:49" "73272e26b432d52d6a4bea006d009450" "111429" ] |
43 | 3.32 ms |
"COMMIT"
Parameters:
[] |
44 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
45 | 0.43 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:
[ "e62367b7d4d45a42d709404873955a86" "11710bfa026a26305eb03471f38f4fcd14539eece8e44185228a47d850442eff" "18.225.234.89" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "" "/directory/roofing-alliance/posts/7" "directory_posts_master" "{"slug":"roofing-alliance","page":"7"}" "" "" "" "[]" "2024-07-16 09:41:49" null ] |
46 | 0.94 ms |
INSERT INTO content_impression (site_id, requested_at, hash, content_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-07-16 09:41:49" "e62367b7d4d45a42d709404873955a86" "111402" ] |
47 | 0.69 ms |
"COMMIT"
Parameters:
[] |
48 | 0.12 ms |
"START TRANSACTION"
Parameters:
[] |
49 | 0.54 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:
[ "247f670b233e786380cce88f02211d15" "11710bfa026a26305eb03471f38f4fcd14539eece8e44185228a47d850442eff" "18.225.234.89" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "" "/directory/roofing-alliance/posts/7" "directory_posts_master" "{"slug":"roofing-alliance","page":"7"}" "" "" "" "[]" "2024-07-16 09:41:49" null ] |
50 | 1.11 ms |
INSERT INTO content_impression (site_id, requested_at, hash, content_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-07-16 09:41:49" "247f670b233e786380cce88f02211d15" "111307" ] |
51 | 1.95 ms |
"COMMIT"
Parameters:
[] |
52 | 0.15 ms |
"START TRANSACTION"
Parameters:
[] |
53 | 0.54 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:
[ "257dda269f90b8498dcb63984bfedc70" "11710bfa026a26305eb03471f38f4fcd14539eece8e44185228a47d850442eff" "18.225.234.89" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "" "/directory/roofing-alliance/posts/7" "directory_posts_master" "{"slug":"roofing-alliance","page":"7"}" "" "" "" "[]" "2024-07-16 09:41:49" null ] |
54 | 0.78 ms |
INSERT INTO content_impression (site_id, requested_at, hash, content_id) VALUES (?, ?, ?, ?)
Parameters:
[ 1 "2024-07-16 09:41:49" "257dda269f90b8498dcb63984bfedc70" "111274" ] |
55 | 1.97 ms |
"COMMIT"
Parameters:
[] |
56 | 0.34 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.status AS status_6, t0.attributes AS attributes_7, t0.sort_type AS sort_type_8, t0.display_limit AS display_limit_9, t0.position AS position_10, t0.type AS type_11, t12.id AS id_13, t12.version AS version_14, t12.title AS title_15, t12.description AS description_16, t12.call_to_action AS call_to_action_17, t12.bio AS bio_18, t12.modified_at AS modified_at_19, t12.created_at AS created_at_20, t12.status AS status_21, t12.email AS email_22, t12.external_request_more AS external_request_more_23, t12.website AS website_24, t12.facebook AS facebook_25, t12.twitter AS twitter_26, t12.linkedin AS linkedin_27, t12.instagram AS instagram_28, t12.tiktok AS tiktok_29, t12.youtube AS youtube_30, t12.hash_tag AS hash_tag_31, t12.location AS location_32, t12.state AS state_33, t12.keywords AS keywords_34, t12.customer_level AS customer_level_35, t12.customer_type AS customer_type_36, t12.type_work AS type_work_37, t12.prnt_id AS prnt_id_38, t12.literature_id AS literature_id_39, t12.photo_gallery_id AS photo_gallery_id_40, t12.video_gallery_id AS video_gallery_id_41, t12.logo_id AS logo_id_42, t12.media_id AS media_id_43, t12.dummy_media_id AS dummy_media_id_44, t12.blog_id AS blog_id_45, t12.branch_locator_id AS branch_locator_id_46, t12.external_events_id AS external_events_id_47, t12.newsletters_id AS newsletters_id_48, t12.partners_reps_id AS partners_reps_id_49, t12.rep_lines_id AS rep_lines_id_50, t12.directory_content_id AS directory_content_id_51, t52.id AS id_53, t52.version AS version_54, t52.title AS title_55, t52.description AS description_56, t52.call_to_action AS call_to_action_57, t52.bio AS bio_58, t52.modified_at AS modified_at_59, t52.created_at AS created_at_60, t52.status AS status_61, t52.email AS email_62, t52.external_request_more AS external_request_more_63, t52.website AS website_64, t52.facebook AS facebook_65, t52.twitter AS twitter_66, t52.linkedin AS linkedin_67, t52.instagram AS instagram_68, t52.tiktok AS tiktok_69, t52.youtube AS youtube_70, t52.hash_tag AS hash_tag_71, t52.location AS location_72, t52.state AS state_73, t52.keywords AS keywords_74, t52.customer_level AS customer_level_75, t52.customer_type AS customer_type_76, t52.type_work AS type_work_77, t52.prnt_id AS prnt_id_78, t52.literature_id AS literature_id_79, t52.photo_gallery_id AS photo_gallery_id_80, t52.video_gallery_id AS video_gallery_id_81, t52.logo_id AS logo_id_82, t52.media_id AS media_id_83, t52.dummy_media_id AS dummy_media_id_84, t52.blog_id AS blog_id_85, t52.branch_locator_id AS branch_locator_id_86, t52.external_events_id AS external_events_id_87, t52.newsletters_id AS newsletters_id_88, t52.partners_reps_id AS partners_reps_id_89, t52.rep_lines_id AS rep_lines_id_90, t52.directory_content_id AS directory_content_id_91, t92.id AS id_93, t92.version AS version_94, t92.title AS title_95, t92.description AS description_96, t92.call_to_action AS call_to_action_97, t92.bio AS bio_98, t92.modified_at AS modified_at_99, t92.created_at AS created_at_100, t92.status AS status_101, t92.email AS email_102, t92.external_request_more AS external_request_more_103, t92.website AS website_104, t92.facebook AS facebook_105, t92.twitter AS twitter_106, t92.linkedin AS linkedin_107, t92.instagram AS instagram_108, t92.tiktok AS tiktok_109, t92.youtube AS youtube_110, t92.hash_tag AS hash_tag_111, t92.location AS location_112, t92.state AS state_113, t92.keywords AS keywords_114, t92.customer_level AS customer_level_115, t92.customer_type AS customer_type_116, t92.type_work AS type_work_117, t92.prnt_id AS prnt_id_118, t92.literature_id AS literature_id_119, t92.photo_gallery_id AS photo_gallery_id_120, t92.video_gallery_id AS video_gallery_id_121, t92.logo_id AS logo_id_122, t92.media_id AS media_id_123, t92.dummy_media_id AS dummy_media_id_124, t92.blog_id AS blog_id_125, t92.branch_locator_id AS branch_locator_id_126, t92.external_events_id AS external_events_id_127, t92.newsletters_id AS newsletters_id_128, t92.partners_reps_id AS partners_reps_id_129, t92.rep_lines_id AS rep_lines_id_130, t92.directory_content_id AS directory_content_id_131 FROM media_group t0 LEFT JOIN customer t12 ON t12.literature_id = t0.id LEFT JOIN customer t52 ON t52.photo_gallery_id = t0.id LEFT JOIN customer t92 ON t92.video_gallery_id = t0.id WHERE t0.type = ?
Parameters:
[
3
]
|
57 | 0.73 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.status = ? AND t0.media_group_id = ?) ORDER BY t0.published_at ASC
Parameters:
[ "1" "888" ] |
58 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3 FROM site t0 INNER JOIN ad_site ON t0.id = ad_site.site_id WHERE ad_site.media_group_item_id = ?
Parameters:
[
"7176"
]
|
59 | 0.62 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.status = ? AND t0.media_group_id = ?) ORDER BY t0.published_at ASC
Parameters:
[ "1" "889" ] |
60 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3 FROM site t0 INNER JOIN ad_site ON t0.id = ad_site.site_id WHERE ad_site.media_group_item_id = ?
Parameters:
[
"7097"
]
|
61 | 0.60 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.status = ? AND t0.media_group_id = ?) ORDER BY t0.published_at ASC
Parameters:
[ "1" "890" ] |
62 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3 FROM site t0 INNER JOIN ad_site ON t0.id = ad_site.site_id WHERE ad_site.media_group_item_id = ?
Parameters:
[
"7174"
]
|
63 | 0.60 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.status = ? AND t0.media_group_id = ?) ORDER BY t0.published_at ASC
Parameters:
[ "1" "891" ] |
64 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3 FROM site t0 INNER JOIN ad_site ON t0.id = ad_site.site_id WHERE ad_site.media_group_item_id = ?
Parameters:
[
"7196"
]
|
65 | 0.61 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.status = ? AND t0.media_group_id = ?) ORDER BY t0.published_at ASC
Parameters:
[ "1" "892" ] |
66 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3 FROM site t0 INNER JOIN ad_site ON t0.id = ad_site.site_id WHERE ad_site.media_group_item_id = ?
Parameters:
[
"7166"
]
|
67 | 0.61 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.status = ? AND t0.media_group_id = ?) ORDER BY t0.published_at ASC
Parameters:
[ "1" "893" ] |
68 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3 FROM site t0 INNER JOIN ad_site ON t0.id = ad_site.site_id WHERE ad_site.media_group_item_id = ?
Parameters:
[
"6956"
]
|
69 | 0.30 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.status AS status_6, t0.attributes AS attributes_7, t0.sort_type AS sort_type_8, t0.display_limit AS display_limit_9, t0.position AS position_10, t0.type AS type_11, t12.id AS id_13, t12.version AS version_14, t12.title AS title_15, t12.description AS description_16, t12.call_to_action AS call_to_action_17, t12.bio AS bio_18, t12.modified_at AS modified_at_19, t12.created_at AS created_at_20, t12.status AS status_21, t12.email AS email_22, t12.external_request_more AS external_request_more_23, t12.website AS website_24, t12.facebook AS facebook_25, t12.twitter AS twitter_26, t12.linkedin AS linkedin_27, t12.instagram AS instagram_28, t12.tiktok AS tiktok_29, t12.youtube AS youtube_30, t12.hash_tag AS hash_tag_31, t12.location AS location_32, t12.state AS state_33, t12.keywords AS keywords_34, t12.customer_level AS customer_level_35, t12.customer_type AS customer_type_36, t12.type_work AS type_work_37, t12.prnt_id AS prnt_id_38, t12.literature_id AS literature_id_39, t12.photo_gallery_id AS photo_gallery_id_40, t12.video_gallery_id AS video_gallery_id_41, t12.logo_id AS logo_id_42, t12.media_id AS media_id_43, t12.dummy_media_id AS dummy_media_id_44, t12.blog_id AS blog_id_45, t12.branch_locator_id AS branch_locator_id_46, t12.external_events_id AS external_events_id_47, t12.newsletters_id AS newsletters_id_48, t12.partners_reps_id AS partners_reps_id_49, t12.rep_lines_id AS rep_lines_id_50, t12.directory_content_id AS directory_content_id_51, t52.id AS id_53, t52.version AS version_54, t52.title AS title_55, t52.description AS description_56, t52.call_to_action AS call_to_action_57, t52.bio AS bio_58, t52.modified_at AS modified_at_59, t52.created_at AS created_at_60, t52.status AS status_61, t52.email AS email_62, t52.external_request_more AS external_request_more_63, t52.website AS website_64, t52.facebook AS facebook_65, t52.twitter AS twitter_66, t52.linkedin AS linkedin_67, t52.instagram AS instagram_68, t52.tiktok AS tiktok_69, t52.youtube AS youtube_70, t52.hash_tag AS hash_tag_71, t52.location AS location_72, t52.state AS state_73, t52.keywords AS keywords_74, t52.customer_level AS customer_level_75, t52.customer_type AS customer_type_76, t52.type_work AS type_work_77, t52.prnt_id AS prnt_id_78, t52.literature_id AS literature_id_79, t52.photo_gallery_id AS photo_gallery_id_80, t52.video_gallery_id AS video_gallery_id_81, t52.logo_id AS logo_id_82, t52.media_id AS media_id_83, t52.dummy_media_id AS dummy_media_id_84, t52.blog_id AS blog_id_85, t52.branch_locator_id AS branch_locator_id_86, t52.external_events_id AS external_events_id_87, t52.newsletters_id AS newsletters_id_88, t52.partners_reps_id AS partners_reps_id_89, t52.rep_lines_id AS rep_lines_id_90, t52.directory_content_id AS directory_content_id_91, t92.id AS id_93, t92.version AS version_94, t92.title AS title_95, t92.description AS description_96, t92.call_to_action AS call_to_action_97, t92.bio AS bio_98, t92.modified_at AS modified_at_99, t92.created_at AS created_at_100, t92.status AS status_101, t92.email AS email_102, t92.external_request_more AS external_request_more_103, t92.website AS website_104, t92.facebook AS facebook_105, t92.twitter AS twitter_106, t92.linkedin AS linkedin_107, t92.instagram AS instagram_108, t92.tiktok AS tiktok_109, t92.youtube AS youtube_110, t92.hash_tag AS hash_tag_111, t92.location AS location_112, t92.state AS state_113, t92.keywords AS keywords_114, t92.customer_level AS customer_level_115, t92.customer_type AS customer_type_116, t92.type_work AS type_work_117, t92.prnt_id AS prnt_id_118, t92.literature_id AS literature_id_119, t92.photo_gallery_id AS photo_gallery_id_120, t92.video_gallery_id AS video_gallery_id_121, t92.logo_id AS logo_id_122, t92.media_id AS media_id_123, t92.dummy_media_id AS dummy_media_id_124, t92.blog_id AS blog_id_125, t92.branch_locator_id AS branch_locator_id_126, t92.external_events_id AS external_events_id_127, t92.newsletters_id AS newsletters_id_128, t92.partners_reps_id AS partners_reps_id_129, t92.rep_lines_id AS rep_lines_id_130, t92.directory_content_id AS directory_content_id_131 FROM media_group t0 LEFT JOIN customer t12 ON t12.literature_id = t0.id LEFT JOIN customer t52 ON t52.photo_gallery_id = t0.id LEFT JOIN customer t92 ON t92.video_gallery_id = t0.id WHERE t0.position = ? LIMIT 1
Parameters:
[
"header-countdown"
]
|
70 | 0.62 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.status = ? AND t0.media_group_id = ?) ORDER BY t0.published_at ASC
Parameters:
[ "1" "1102" ] |
71 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3 FROM site t0 INNER JOIN ad_site ON t0.id = ad_site.site_id WHERE ad_site.media_group_item_id = ?
Parameters:
[
"7275"
]
|
72 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3 FROM site t0 INNER JOIN ad_site ON t0.id = ad_site.site_id WHERE ad_site.media_group_item_id = ?
Parameters:
[
"7309"
]
|
73 | 0.29 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.status AS status_6, t0.attributes AS attributes_7, t0.sort_type AS sort_type_8, t0.display_limit AS display_limit_9, t0.position AS position_10, t0.type AS type_11, t12.id AS id_13, t12.version AS version_14, t12.title AS title_15, t12.description AS description_16, t12.call_to_action AS call_to_action_17, t12.bio AS bio_18, t12.modified_at AS modified_at_19, t12.created_at AS created_at_20, t12.status AS status_21, t12.email AS email_22, t12.external_request_more AS external_request_more_23, t12.website AS website_24, t12.facebook AS facebook_25, t12.twitter AS twitter_26, t12.linkedin AS linkedin_27, t12.instagram AS instagram_28, t12.tiktok AS tiktok_29, t12.youtube AS youtube_30, t12.hash_tag AS hash_tag_31, t12.location AS location_32, t12.state AS state_33, t12.keywords AS keywords_34, t12.customer_level AS customer_level_35, t12.customer_type AS customer_type_36, t12.type_work AS type_work_37, t12.prnt_id AS prnt_id_38, t12.literature_id AS literature_id_39, t12.photo_gallery_id AS photo_gallery_id_40, t12.video_gallery_id AS video_gallery_id_41, t12.logo_id AS logo_id_42, t12.media_id AS media_id_43, t12.dummy_media_id AS dummy_media_id_44, t12.blog_id AS blog_id_45, t12.branch_locator_id AS branch_locator_id_46, t12.external_events_id AS external_events_id_47, t12.newsletters_id AS newsletters_id_48, t12.partners_reps_id AS partners_reps_id_49, t12.rep_lines_id AS rep_lines_id_50, t12.directory_content_id AS directory_content_id_51, t52.id AS id_53, t52.version AS version_54, t52.title AS title_55, t52.description AS description_56, t52.call_to_action AS call_to_action_57, t52.bio AS bio_58, t52.modified_at AS modified_at_59, t52.created_at AS created_at_60, t52.status AS status_61, t52.email AS email_62, t52.external_request_more AS external_request_more_63, t52.website AS website_64, t52.facebook AS facebook_65, t52.twitter AS twitter_66, t52.linkedin AS linkedin_67, t52.instagram AS instagram_68, t52.tiktok AS tiktok_69, t52.youtube AS youtube_70, t52.hash_tag AS hash_tag_71, t52.location AS location_72, t52.state AS state_73, t52.keywords AS keywords_74, t52.customer_level AS customer_level_75, t52.customer_type AS customer_type_76, t52.type_work AS type_work_77, t52.prnt_id AS prnt_id_78, t52.literature_id AS literature_id_79, t52.photo_gallery_id AS photo_gallery_id_80, t52.video_gallery_id AS video_gallery_id_81, t52.logo_id AS logo_id_82, t52.media_id AS media_id_83, t52.dummy_media_id AS dummy_media_id_84, t52.blog_id AS blog_id_85, t52.branch_locator_id AS branch_locator_id_86, t52.external_events_id AS external_events_id_87, t52.newsletters_id AS newsletters_id_88, t52.partners_reps_id AS partners_reps_id_89, t52.rep_lines_id AS rep_lines_id_90, t52.directory_content_id AS directory_content_id_91, t92.id AS id_93, t92.version AS version_94, t92.title AS title_95, t92.description AS description_96, t92.call_to_action AS call_to_action_97, t92.bio AS bio_98, t92.modified_at AS modified_at_99, t92.created_at AS created_at_100, t92.status AS status_101, t92.email AS email_102, t92.external_request_more AS external_request_more_103, t92.website AS website_104, t92.facebook AS facebook_105, t92.twitter AS twitter_106, t92.linkedin AS linkedin_107, t92.instagram AS instagram_108, t92.tiktok AS tiktok_109, t92.youtube AS youtube_110, t92.hash_tag AS hash_tag_111, t92.location AS location_112, t92.state AS state_113, t92.keywords AS keywords_114, t92.customer_level AS customer_level_115, t92.customer_type AS customer_type_116, t92.type_work AS type_work_117, t92.prnt_id AS prnt_id_118, t92.literature_id AS literature_id_119, t92.photo_gallery_id AS photo_gallery_id_120, t92.video_gallery_id AS video_gallery_id_121, t92.logo_id AS logo_id_122, t92.media_id AS media_id_123, t92.dummy_media_id AS dummy_media_id_124, t92.blog_id AS blog_id_125, t92.branch_locator_id AS branch_locator_id_126, t92.external_events_id AS external_events_id_127, t92.newsletters_id AS newsletters_id_128, t92.partners_reps_id AS partners_reps_id_129, t92.rep_lines_id AS rep_lines_id_130, t92.directory_content_id AS directory_content_id_131 FROM media_group t0 LEFT JOIN customer t12 ON t12.literature_id = t0.id LEFT JOIN customer t52 ON t52.photo_gallery_id = t0.id LEFT JOIN customer t92 ON t92.video_gallery_id = t0.id WHERE t0.position = ? LIMIT 1
Parameters:
[
"header-bottom"
]
|
74 | 0.59 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.status = ? AND t0.media_group_id = ?) ORDER BY t0.published_at ASC
Parameters:
[ "1" "1103" ] |
75 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3 FROM site t0 INNER JOIN ad_site ON t0.id = ad_site.site_id WHERE ad_site.media_group_item_id = ?
Parameters:
[
"6940"
]
|
76 | 0.28 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.status AS status_6, t0.attributes AS attributes_7, t0.sort_type AS sort_type_8, t0.display_limit AS display_limit_9, t0.position AS position_10, t0.type AS type_11, t12.id AS id_13, t12.version AS version_14, t12.title AS title_15, t12.description AS description_16, t12.call_to_action AS call_to_action_17, t12.bio AS bio_18, t12.modified_at AS modified_at_19, t12.created_at AS created_at_20, t12.status AS status_21, t12.email AS email_22, t12.external_request_more AS external_request_more_23, t12.website AS website_24, t12.facebook AS facebook_25, t12.twitter AS twitter_26, t12.linkedin AS linkedin_27, t12.instagram AS instagram_28, t12.tiktok AS tiktok_29, t12.youtube AS youtube_30, t12.hash_tag AS hash_tag_31, t12.location AS location_32, t12.state AS state_33, t12.keywords AS keywords_34, t12.customer_level AS customer_level_35, t12.customer_type AS customer_type_36, t12.type_work AS type_work_37, t12.prnt_id AS prnt_id_38, t12.literature_id AS literature_id_39, t12.photo_gallery_id AS photo_gallery_id_40, t12.video_gallery_id AS video_gallery_id_41, t12.logo_id AS logo_id_42, t12.media_id AS media_id_43, t12.dummy_media_id AS dummy_media_id_44, t12.blog_id AS blog_id_45, t12.branch_locator_id AS branch_locator_id_46, t12.external_events_id AS external_events_id_47, t12.newsletters_id AS newsletters_id_48, t12.partners_reps_id AS partners_reps_id_49, t12.rep_lines_id AS rep_lines_id_50, t12.directory_content_id AS directory_content_id_51, t52.id AS id_53, t52.version AS version_54, t52.title AS title_55, t52.description AS description_56, t52.call_to_action AS call_to_action_57, t52.bio AS bio_58, t52.modified_at AS modified_at_59, t52.created_at AS created_at_60, t52.status AS status_61, t52.email AS email_62, t52.external_request_more AS external_request_more_63, t52.website AS website_64, t52.facebook AS facebook_65, t52.twitter AS twitter_66, t52.linkedin AS linkedin_67, t52.instagram AS instagram_68, t52.tiktok AS tiktok_69, t52.youtube AS youtube_70, t52.hash_tag AS hash_tag_71, t52.location AS location_72, t52.state AS state_73, t52.keywords AS keywords_74, t52.customer_level AS customer_level_75, t52.customer_type AS customer_type_76, t52.type_work AS type_work_77, t52.prnt_id AS prnt_id_78, t52.literature_id AS literature_id_79, t52.photo_gallery_id AS photo_gallery_id_80, t52.video_gallery_id AS video_gallery_id_81, t52.logo_id AS logo_id_82, t52.media_id AS media_id_83, t52.dummy_media_id AS dummy_media_id_84, t52.blog_id AS blog_id_85, t52.branch_locator_id AS branch_locator_id_86, t52.external_events_id AS external_events_id_87, t52.newsletters_id AS newsletters_id_88, t52.partners_reps_id AS partners_reps_id_89, t52.rep_lines_id AS rep_lines_id_90, t52.directory_content_id AS directory_content_id_91, t92.id AS id_93, t92.version AS version_94, t92.title AS title_95, t92.description AS description_96, t92.call_to_action AS call_to_action_97, t92.bio AS bio_98, t92.modified_at AS modified_at_99, t92.created_at AS created_at_100, t92.status AS status_101, t92.email AS email_102, t92.external_request_more AS external_request_more_103, t92.website AS website_104, t92.facebook AS facebook_105, t92.twitter AS twitter_106, t92.linkedin AS linkedin_107, t92.instagram AS instagram_108, t92.tiktok AS tiktok_109, t92.youtube AS youtube_110, t92.hash_tag AS hash_tag_111, t92.location AS location_112, t92.state AS state_113, t92.keywords AS keywords_114, t92.customer_level AS customer_level_115, t92.customer_type AS customer_type_116, t92.type_work AS type_work_117, t92.prnt_id AS prnt_id_118, t92.literature_id AS literature_id_119, t92.photo_gallery_id AS photo_gallery_id_120, t92.video_gallery_id AS video_gallery_id_121, t92.logo_id AS logo_id_122, t92.media_id AS media_id_123, t92.dummy_media_id AS dummy_media_id_124, t92.blog_id AS blog_id_125, t92.branch_locator_id AS branch_locator_id_126, t92.external_events_id AS external_events_id_127, t92.newsletters_id AS newsletters_id_128, t92.partners_reps_id AS partners_reps_id_129, t92.rep_lines_id AS rep_lines_id_130, t92.directory_content_id AS directory_content_id_131 FROM media_group t0 LEFT JOIN customer t12 ON t12.literature_id = t0.id LEFT JOIN customer t52 ON t52.photo_gallery_id = t0.id LEFT JOIN customer t92 ON t92.video_gallery_id = t0.id WHERE t0.position = ? LIMIT 1
Parameters:
[
"header-bottom-bottom"
]
|
77 | 0.55 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.status = ? AND t0.media_group_id = ?) ORDER BY t0.published_at ASC
Parameters:
[ "1" "1419" ] |
78 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3 FROM site t0 INNER JOIN ad_site ON t0.id = ad_site.site_id WHERE ad_site.media_group_item_id = ?
Parameters:
[
"6775"
]
|
79 | 0.21 ms |
SELECT * FROM mega_menu where mega_menu.site_code = :sitecode and mega_menu.status = 1
Parameters:
[ "sitecode" => 1 ] |
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.