Query Metrics
37
Database Queries
9
Different statements
30.27 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
15.62 ms (51.60%) |
1 |
SELECT DISTINCT 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_ LEFT JOIN customer_content c2_ ON c0_.id = c2_.content_id LEFT JOIN customer c1_ ON c1_.id = c2_.customer_id INNER JOIN content_site c4_ ON c0_.id = c4_.content_id INNER JOIN site s3_ ON s3_.id = c4_.site_id WHERE c0_.type = 2 AND c0_.status = 1 AND s3_.id = 1 AND c0_.members_only = 0 AND c1_.id IN (84) AND c0_.exclude_from_list = 0 AND (c0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY c0_.published_at DESC LIMIT 10
Parameters:
[ "19" "20" "24" "25" "48" "63" "151" "155" "212" "237" "405" "470" "502" "503" "506" "509" "516" "517" "1289" "1291" "1292" "1297" "1301" ] |
3.76 ms (12.42%) |
11 |
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.show_photos AS show_photos_26, t0.prnt_id AS prnt_id_27, t0.literature_id AS literature_id_28, t0.photo_gallery_id AS photo_gallery_id_29, t0.video_gallery_id AS video_gallery_id_30, t0.logo_id AS logo_id_31, t0.media_id AS media_id_32, t0.dummy_media_id AS dummy_media_id_33, t0.blog_id AS blog_id_34, t0.branch_locator_id AS branch_locator_id_35, t0.external_events_id AS external_events_id_36, t0.newsletters_id AS newsletters_id_37, t0.partners_reps_id AS partners_reps_id_38, t0.rep_lines_id AS rep_lines_id_39, t0.directory_content_id AS directory_content_id_40 FROM customer t0 WHERE t0.directory_content_id = ?
Parameters:
[
"92477"
]
|
3.21 ms (10.60%) |
1 |
SELECT DISTINCT c0_.id AS id_0, c0_.version AS version_1, c0_.title AS title_2, c0_.description AS description_3, c0_.slug AS slug_4, c0_.type AS type_5, c0_.modified_at AS modified_at_6, c0_.created_at AS created_at_7, c0_.sort AS sort_8, c0_.status AS status_9, c0_.taxonomy AS taxonomy_10, c0_.prnt_id AS prnt_id_11, c0_.media_id AS media_id_12 FROM category c0_ LEFT JOIN category c1_ ON c0_.prnt_id = c1_.id LEFT JOIN category c2_ ON c1_.prnt_id = c2_.id WHERE c0_.slug IN (?) OR c1_.slug IN (?) OR c2_.slug IN (?)
Parameters:
[ "newsroom" "newsroom" "newsroom" ] |
2.61 ms (8.63%) |
10 |
SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.alt_tag AS alt_tag_5, t0.extension AS extension_6, t0.name AS name_7, t0.type AS type_8, t0.status AS status_9, t0.modified_at AS modified_at_10, t0.created_at AS created_at_11, t0.old_id AS old_id_12 FROM media t0 WHERE t0.id = ?
Parameters:
[
"39249"
]
|
2.58 ms (8.53%) |
10 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_title AS meta_title_3 FROM site t0 INNER JOIN content_site ON t0.id = content_site.site_id WHERE content_site.content_id = ?
Parameters:
[
"116805"
]
|
1.35 ms (4.45%) |
1 |
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM content c0_ LEFT JOIN customer_content c2_ ON c0_.id = c2_.content_id LEFT JOIN customer c1_ ON c1_.id = c2_.customer_id INNER JOIN content_site c4_ ON c0_.id = c4_.content_id INNER JOIN site s3_ ON s3_.id = c4_.site_id WHERE c0_.type = 2 AND c0_.status = 1 AND s3_.id = 1 AND c0_.members_only = 0 AND c1_.id IN (84) AND c0_.exclude_from_list = 0 AND (c0_.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY c0_.published_at DESC
Parameters:
[ "19" "20" "24" "25" "48" "63" "151" "155" "212" "237" "405" "470" "502" "503" "506" "509" "516" "517" "1289" "1291" "1292" "1297" "1301" ] |
0.49 ms (1.62%) |
1 |
SELECT c0_.id AS id_0, c0_.version AS version_1, c0_.title AS title_2, c0_.description AS description_3, c0_.slug AS slug_4, c0_.type AS type_5, c0_.modified_at AS modified_at_6, c0_.created_at AS created_at_7, c0_.sort AS sort_8, c0_.status AS status_9, c0_.taxonomy AS taxonomy_10, c0_.prnt_id AS prnt_id_11, c0_.media_id AS media_id_12 FROM category c0_ WHERE c0_.slug = ? LIMIT 1
Parameters:
[
"newsroom"
]
|
0.40 ms (1.32%) |
1 |
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:
[ "equipter-llc" 1 ] |
0.25 ms (0.84%) |
1 |
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:
[ "equipter-llc" 4 ] |
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.