Symfony Profiler

Query Metrics

23 Database Queries

4 Different statements

300.51 ms Query time

1 Invalid entities

Queries

umem connection


SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id IS NULL AND p0_.public = 1 ORDER BY p0_.date_posted DESC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC
SELECT t0.emp_index AS emp_index_1, t0.emp_lastname AS emp_lastname_2, t0.emp_firstname AS emp_firstname_3, t0.emp_middlename AS emp_middlename_4, t0.emp_gender AS emp_gender_5, t0.emp_start_date AS emp_start_date_6, t0.emp_suffix AS emp_suffix_7, t0.emp_timestamp_initial AS emp_timestamp_initial_8, t0.emp_timestamp_update AS emp_timestamp_update_9, t0.emp_ftpt AS emp_ftpt_10, t0.emp_show_profile AS emp_show_profile_11, t0.emp_disable AS emp_disable_12, t0.emp_grad_residency AS emp_grad_residency_13, t0.emp_profile_update_flag AS emp_profile_update_flag_14, t0.emp_chief AS emp_chief_15, t0.emp_program_director AS emp_program_director_16, t0.emp_network_provider AS emp_network_provider_17, t0.emp_pending_forms AS emp_pending_forms_18, t0.emp_emerg_name AS emp_emerg_name_19, t0.emp_emerg_phone AS emp_emerg_phone_20, t0.emp_emerg_relationship AS emp_emerg_relationship_21, t0.emp_birthdate AS emp_birthdate_22, t0.emp_birthplace AS emp_birthplace_23, t0.emp_ssn AS emp_ssn_24, t0.emp_race AS emp_race_25, t0.emp_citizenship_index AS emp_citizenship_index_26, t0.emp_ethnicity AS emp_ethnicity_27, t0.emp_email_primary_index AS emp_email_primary_index_28, t0.emp_spouse_name AS emp_spouse_name_29, t0.faculty_auto_exempt AS faculty_auto_exempt_30, t0.bamboo_id AS bamboo_id_31, t0.npi AS npi_32, t0.umms_ad_username AS umms_ad_username_33, t34.user_index AS user_index_35, t34.emp_index AS emp_index_36, t34.username AS username_37, t34.ad_guid AS ad_guid_38, t34.password_hash AS password_hash_39, t34.reset_token AS reset_token_40, t34.reset_timestamp AS reset_timestamp_41, t34.reset_count AS reset_count_42, t34.account_update AS account_update_43, t34.activation_token AS activation_token_44, t34.activation_timestamp AS activation_timestamp_45, t34.activation_count AS activation_count_46, t34.invitation_token AS invitation_token_47, t34.invitation_timestamp AS invitation_timestamp_48, t34.invitation_count AS invitation_count_49, t34.timestamp AS timestamp_50, t34.roles AS roles_51, t34.emp_index AS emp_index_52, t0.emp_email_primary_index AS emp_email_primary_index_53, t0.emp_citizenship_index AS emp_citizenship_index_54, t0.emp_gender AS emp_gender_55 FROM employee t0 LEFT JOIN users t34 ON t34.emp_index = t0.emp_index WHERE t0.emp_index = ?
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ?
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ?
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ?
SELECT t0.emp_index AS emp_index_1, t0.emp_lastname AS emp_lastname_2, t0.emp_firstname AS emp_firstname_3, t0.emp_middlename AS emp_middlename_4, t0.emp_gender AS emp_gender_5, t0.emp_start_date AS emp_start_date_6, t0.emp_suffix AS emp_suffix_7, t0.emp_timestamp_initial AS emp_timestamp_initial_8, t0.emp_timestamp_update AS emp_timestamp_update_9, t0.emp_ftpt AS emp_ftpt_10, t0.emp_show_profile AS emp_show_profile_11, t0.emp_disable AS emp_disable_12, t0.emp_grad_residency AS emp_grad_residency_13, t0.emp_profile_update_flag AS emp_profile_update_flag_14, t0.emp_chief AS emp_chief_15, t0.emp_program_director AS emp_program_director_16, t0.emp_network_provider AS emp_network_provider_17, t0.emp_pending_forms AS emp_pending_forms_18, t0.emp_emerg_name AS emp_emerg_name_19, t0.emp_emerg_phone AS emp_emerg_phone_20, t0.emp_emerg_relationship AS emp_emerg_relationship_21, t0.emp_birthdate AS emp_birthdate_22, t0.emp_birthplace AS emp_birthplace_23, t0.emp_ssn AS emp_ssn_24, t0.emp_race AS emp_race_25, t0.emp_citizenship_index AS emp_citizenship_index_26, t0.emp_ethnicity AS emp_ethnicity_27, t0.emp_email_primary_index AS emp_email_primary_index_28, t0.emp_spouse_name AS emp_spouse_name_29, t0.faculty_auto_exempt AS faculty_auto_exempt_30, t0.bamboo_id AS bamboo_id_31, t0.npi AS npi_32, t0.umms_ad_username AS umms_ad_username_33, t34.user_index AS user_index_35, t34.emp_index AS emp_index_36, t34.username AS username_37, t34.ad_guid AS ad_guid_38, t34.password_hash AS password_hash_39, t34.reset_token AS reset_token_40, t34.reset_timestamp AS reset_timestamp_41, t34.reset_count AS reset_count_42, t34.account_update AS account_update_43, t34.activation_token AS activation_token_44, t34.activation_timestamp AS activation_timestamp_45, t34.activation_count AS activation_count_46, t34.invitation_token AS invitation_token_47, t34.invitation_timestamp AS invitation_timestamp_48, t34.invitation_count AS invitation_count_49, t34.timestamp AS timestamp_50, t34.roles AS roles_51, t34.emp_index AS emp_index_52, t0.emp_email_primary_index AS emp_email_primary_index_53, t0.emp_citizenship_index AS emp_citizenship_index_54, t0.emp_gender AS emp_gender_55 FROM employee t0 LEFT JOIN users t34 ON t34.emp_index = t0.emp_index WHERE t0.emp_index = ?
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ?
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ?

#▲	Time	Info
1	282.49 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id IS NULL AND p0_.public = 1 ORDER BY p0_.date_posted DESC Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id IS NULL AND p0_.public = 1 ORDER BY p0_.date_posted DESC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id IS NULL AND p0_.public = 1 ORDER BY p0_.date_posted DESC;
2	2.64 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`189`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 189 ORDER BY p0_.sort_order ASC;
3	1.67 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`188`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 188 ORDER BY p0_.sort_order ASC;
4	0.44 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`187`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 187 ORDER BY p0_.sort_order ASC;
5	0.30 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`186`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 186 ORDER BY p0_.sort_order ASC;
6	0.29 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`185`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 185 ORDER BY p0_.sort_order ASC;
7	0.49 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`183`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 183 ORDER BY p0_.sort_order ASC;
8	1.15 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`182`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 182 ORDER BY p0_.sort_order ASC;
9	0.93 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`181`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 181 ORDER BY p0_.sort_order ASC;
10	1.04 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`180`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 180 ORDER BY p0_.sort_order ASC;
11	1.61 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`179`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 179 ORDER BY p0_.sort_order ASC;
12	0.43 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`175`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 175 ORDER BY p0_.sort_order ASC;
13	0.87 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`173`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 173 ORDER BY p0_.sort_order ASC;
14	0.77 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`172`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 172 ORDER BY p0_.sort_order ASC;
15	1.23 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`171`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 171 ORDER BY p0_.sort_order ASC;
16	1.69 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC Parameters: [`151`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = ? ORDER BY p0_.sort_order ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.date_posted AS date_posted_3, p0_.cited_references AS cited_references_4, p0_.type AS type_5, p0_.attachment_url AS attachment_url_6, p0_.publish AS publish_7, p0_.public AS public_8, p0_.created AS created_9, p0_.created_by AS created_by_10, p0_.updated AS updated_11, p0_.updated_by AS updated_by_12, p0_.sort_order AS sort_order_13, p0_.author AS author_14, p0_.parent_id AS parent_id_15 FROM podcast p0_ LEFT JOIN podcast_tag p2_ ON p0_.id = p2_.podcast_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.publish = 1 AND p0_.parent_id = 151 ORDER BY p0_.sort_order ASC;
17	0.54 ms	SELECT t0.emp_index AS emp_index_1, t0.emp_lastname AS emp_lastname_2, t0.emp_firstname AS emp_firstname_3, t0.emp_middlename AS emp_middlename_4, t0.emp_gender AS emp_gender_5, t0.emp_start_date AS emp_start_date_6, t0.emp_suffix AS emp_suffix_7, t0.emp_timestamp_initial AS emp_timestamp_initial_8, t0.emp_timestamp_update AS emp_timestamp_update_9, t0.emp_ftpt AS emp_ftpt_10, t0.emp_show_profile AS emp_show_profile_11, t0.emp_disable AS emp_disable_12, t0.emp_grad_residency AS emp_grad_residency_13, t0.emp_profile_update_flag AS emp_profile_update_flag_14, t0.emp_chief AS emp_chief_15, t0.emp_program_director AS emp_program_director_16, t0.emp_network_provider AS emp_network_provider_17, t0.emp_pending_forms AS emp_pending_forms_18, t0.emp_emerg_name AS emp_emerg_name_19, t0.emp_emerg_phone AS emp_emerg_phone_20, t0.emp_emerg_relationship AS emp_emerg_relationship_21, t0.emp_birthdate AS emp_birthdate_22, t0.emp_birthplace AS emp_birthplace_23, t0.emp_ssn AS emp_ssn_24, t0.emp_race AS emp_race_25, t0.emp_citizenship_index AS emp_citizenship_index_26, t0.emp_ethnicity AS emp_ethnicity_27, t0.emp_email_primary_index AS emp_email_primary_index_28, t0.emp_spouse_name AS emp_spouse_name_29, t0.faculty_auto_exempt AS faculty_auto_exempt_30, t0.bamboo_id AS bamboo_id_31, t0.npi AS npi_32, t0.umms_ad_username AS umms_ad_username_33, t34.user_index AS user_index_35, t34.emp_index AS emp_index_36, t34.username AS username_37, t34.ad_guid AS ad_guid_38, t34.password_hash AS password_hash_39, t34.reset_token AS reset_token_40, t34.reset_timestamp AS reset_timestamp_41, t34.reset_count AS reset_count_42, t34.account_update AS account_update_43, t34.activation_token AS activation_token_44, t34.activation_timestamp AS activation_timestamp_45, t34.activation_count AS activation_count_46, t34.invitation_token AS invitation_token_47, t34.invitation_timestamp AS invitation_timestamp_48, t34.invitation_count AS invitation_count_49, t34.timestamp AS timestamp_50, t34.roles AS roles_51, t34.emp_index AS emp_index_52, t0.emp_email_primary_index AS emp_email_primary_index_53, t0.emp_citizenship_index AS emp_citizenship_index_54, t0.emp_gender AS emp_gender_55 FROM employee t0 LEFT JOIN users t34 ON t34.emp_index = t0.emp_index WHERE t0.emp_index = ? Parameters: [`875`] View formatted query View runnable query Explain query SELECT t0.emp_index AS emp_index_1, t0.emp_lastname AS emp_lastname_2, t0.emp_firstname AS emp_firstname_3, t0.emp_middlename AS emp_middlename_4, t0.emp_gender AS emp_gender_5, t0.emp_start_date AS emp_start_date_6, t0.emp_suffix AS emp_suffix_7, t0.emp_timestamp_initial AS emp_timestamp_initial_8, t0.emp_timestamp_update AS emp_timestamp_update_9, t0.emp_ftpt AS emp_ftpt_10, t0.emp_show_profile AS emp_show_profile_11, t0.emp_disable AS emp_disable_12, t0.emp_grad_residency AS emp_grad_residency_13, t0.emp_profile_update_flag AS emp_profile_update_flag_14, t0.emp_chief AS emp_chief_15, t0.emp_program_director AS emp_program_director_16, t0.emp_network_provider AS emp_network_provider_17, t0.emp_pending_forms AS emp_pending_forms_18, t0.emp_emerg_name AS emp_emerg_name_19, t0.emp_emerg_phone AS emp_emerg_phone_20, t0.emp_emerg_relationship AS emp_emerg_relationship_21, t0.emp_birthdate AS emp_birthdate_22, t0.emp_birthplace AS emp_birthplace_23, t0.emp_ssn AS emp_ssn_24, t0.emp_race AS emp_race_25, t0.emp_citizenship_index AS emp_citizenship_index_26, t0.emp_ethnicity AS emp_ethnicity_27, t0.emp_email_primary_index AS emp_email_primary_index_28, t0.emp_spouse_name AS emp_spouse_name_29, t0.faculty_auto_exempt AS faculty_auto_exempt_30, t0.bamboo_id AS bamboo_id_31, t0.npi AS npi_32, t0.umms_ad_username AS umms_ad_username_33, t34.user_index AS user_index_35, t34.emp_index AS emp_index_36, t34.username AS username_37, t34.ad_guid AS ad_guid_38, t34.password_hash AS password_hash_39, t34.reset_token AS reset_token_40, t34.reset_timestamp AS reset_timestamp_41, t34.reset_count AS reset_count_42, t34.account_update AS account_update_43, t34.activation_token AS activation_token_44, t34.activation_timestamp AS activation_timestamp_45, t34.activation_count AS activation_count_46, t34.invitation_token AS invitation_token_47, t34.invitation_timestamp AS invitation_timestamp_48, t34.invitation_count AS invitation_count_49, t34.timestamp AS timestamp_50, t34.roles AS roles_51, t34.emp_index AS emp_index_52, t0.emp_email_primary_index AS emp_email_primary_index_53, t0.emp_citizenship_index AS emp_citizenship_index_54, t0.emp_gender AS emp_gender_55 FROM employee t0 LEFT JOIN users t34 ON t34.emp_index = t0.emp_index WHERE t0.emp_index = ? SELECT t0.emp_index AS emp_index_1, t0.emp_lastname AS emp_lastname_2, t0.emp_firstname AS emp_firstname_3, t0.emp_middlename AS emp_middlename_4, t0.emp_gender AS emp_gender_5, t0.emp_start_date AS emp_start_date_6, t0.emp_suffix AS emp_suffix_7, t0.emp_timestamp_initial AS emp_timestamp_initial_8, t0.emp_timestamp_update AS emp_timestamp_update_9, t0.emp_ftpt AS emp_ftpt_10, t0.emp_show_profile AS emp_show_profile_11, t0.emp_disable AS emp_disable_12, t0.emp_grad_residency AS emp_grad_residency_13, t0.emp_profile_update_flag AS emp_profile_update_flag_14, t0.emp_chief AS emp_chief_15, t0.emp_program_director AS emp_program_director_16, t0.emp_network_provider AS emp_network_provider_17, t0.emp_pending_forms AS emp_pending_forms_18, t0.emp_emerg_name AS emp_emerg_name_19, t0.emp_emerg_phone AS emp_emerg_phone_20, t0.emp_emerg_relationship AS emp_emerg_relationship_21, t0.emp_birthdate AS emp_birthdate_22, t0.emp_birthplace AS emp_birthplace_23, t0.emp_ssn AS emp_ssn_24, t0.emp_race AS emp_race_25, t0.emp_citizenship_index AS emp_citizenship_index_26, t0.emp_ethnicity AS emp_ethnicity_27, t0.emp_email_primary_index AS emp_email_primary_index_28, t0.emp_spouse_name AS emp_spouse_name_29, t0.faculty_auto_exempt AS faculty_auto_exempt_30, t0.bamboo_id AS bamboo_id_31, t0.npi AS npi_32, t0.umms_ad_username AS umms_ad_username_33, t34.user_index AS user_index_35, t34.emp_index AS emp_index_36, t34.username AS username_37, t34.ad_guid AS ad_guid_38, t34.password_hash AS password_hash_39, t34.reset_token AS reset_token_40, t34.reset_timestamp AS reset_timestamp_41, t34.reset_count AS reset_count_42, t34.account_update AS account_update_43, t34.activation_token AS activation_token_44, t34.activation_timestamp AS activation_timestamp_45, t34.activation_count AS activation_count_46, t34.invitation_token AS invitation_token_47, t34.invitation_timestamp AS invitation_timestamp_48, t34.invitation_count AS invitation_count_49, t34.timestamp AS timestamp_50, t34.roles AS roles_51, t34.emp_index AS emp_index_52, t0.emp_email_primary_index AS emp_email_primary_index_53, t0.emp_citizenship_index AS emp_citizenship_index_54, t0.emp_gender AS emp_gender_55 FROM employee t0 LEFT JOIN users t34 ON t34.emp_index = t0.emp_index WHERE t0.emp_index = 875;
18	0.43 ms	SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ? Parameters: [`189`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ? SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = 189;
19	0.31 ms	SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ? Parameters: [`188`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ? SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = 188;
20	0.26 ms	SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ? Parameters: [`187`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ? SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = 187;
21	0.39 ms	SELECT t0.emp_index AS emp_index_1, t0.emp_lastname AS emp_lastname_2, t0.emp_firstname AS emp_firstname_3, t0.emp_middlename AS emp_middlename_4, t0.emp_gender AS emp_gender_5, t0.emp_start_date AS emp_start_date_6, t0.emp_suffix AS emp_suffix_7, t0.emp_timestamp_initial AS emp_timestamp_initial_8, t0.emp_timestamp_update AS emp_timestamp_update_9, t0.emp_ftpt AS emp_ftpt_10, t0.emp_show_profile AS emp_show_profile_11, t0.emp_disable AS emp_disable_12, t0.emp_grad_residency AS emp_grad_residency_13, t0.emp_profile_update_flag AS emp_profile_update_flag_14, t0.emp_chief AS emp_chief_15, t0.emp_program_director AS emp_program_director_16, t0.emp_network_provider AS emp_network_provider_17, t0.emp_pending_forms AS emp_pending_forms_18, t0.emp_emerg_name AS emp_emerg_name_19, t0.emp_emerg_phone AS emp_emerg_phone_20, t0.emp_emerg_relationship AS emp_emerg_relationship_21, t0.emp_birthdate AS emp_birthdate_22, t0.emp_birthplace AS emp_birthplace_23, t0.emp_ssn AS emp_ssn_24, t0.emp_race AS emp_race_25, t0.emp_citizenship_index AS emp_citizenship_index_26, t0.emp_ethnicity AS emp_ethnicity_27, t0.emp_email_primary_index AS emp_email_primary_index_28, t0.emp_spouse_name AS emp_spouse_name_29, t0.faculty_auto_exempt AS faculty_auto_exempt_30, t0.bamboo_id AS bamboo_id_31, t0.npi AS npi_32, t0.umms_ad_username AS umms_ad_username_33, t34.user_index AS user_index_35, t34.emp_index AS emp_index_36, t34.username AS username_37, t34.ad_guid AS ad_guid_38, t34.password_hash AS password_hash_39, t34.reset_token AS reset_token_40, t34.reset_timestamp AS reset_timestamp_41, t34.reset_count AS reset_count_42, t34.account_update AS account_update_43, t34.activation_token AS activation_token_44, t34.activation_timestamp AS activation_timestamp_45, t34.activation_count AS activation_count_46, t34.invitation_token AS invitation_token_47, t34.invitation_timestamp AS invitation_timestamp_48, t34.invitation_count AS invitation_count_49, t34.timestamp AS timestamp_50, t34.roles AS roles_51, t34.emp_index AS emp_index_52, t0.emp_email_primary_index AS emp_email_primary_index_53, t0.emp_citizenship_index AS emp_citizenship_index_54, t0.emp_gender AS emp_gender_55 FROM employee t0 LEFT JOIN users t34 ON t34.emp_index = t0.emp_index WHERE t0.emp_index = ? Parameters: [`104`] View formatted query View runnable query Explain query SELECT t0.emp_index AS emp_index_1, t0.emp_lastname AS emp_lastname_2, t0.emp_firstname AS emp_firstname_3, t0.emp_middlename AS emp_middlename_4, t0.emp_gender AS emp_gender_5, t0.emp_start_date AS emp_start_date_6, t0.emp_suffix AS emp_suffix_7, t0.emp_timestamp_initial AS emp_timestamp_initial_8, t0.emp_timestamp_update AS emp_timestamp_update_9, t0.emp_ftpt AS emp_ftpt_10, t0.emp_show_profile AS emp_show_profile_11, t0.emp_disable AS emp_disable_12, t0.emp_grad_residency AS emp_grad_residency_13, t0.emp_profile_update_flag AS emp_profile_update_flag_14, t0.emp_chief AS emp_chief_15, t0.emp_program_director AS emp_program_director_16, t0.emp_network_provider AS emp_network_provider_17, t0.emp_pending_forms AS emp_pending_forms_18, t0.emp_emerg_name AS emp_emerg_name_19, t0.emp_emerg_phone AS emp_emerg_phone_20, t0.emp_emerg_relationship AS emp_emerg_relationship_21, t0.emp_birthdate AS emp_birthdate_22, t0.emp_birthplace AS emp_birthplace_23, t0.emp_ssn AS emp_ssn_24, t0.emp_race AS emp_race_25, t0.emp_citizenship_index AS emp_citizenship_index_26, t0.emp_ethnicity AS emp_ethnicity_27, t0.emp_email_primary_index AS emp_email_primary_index_28, t0.emp_spouse_name AS emp_spouse_name_29, t0.faculty_auto_exempt AS faculty_auto_exempt_30, t0.bamboo_id AS bamboo_id_31, t0.npi AS npi_32, t0.umms_ad_username AS umms_ad_username_33, t34.user_index AS user_index_35, t34.emp_index AS emp_index_36, t34.username AS username_37, t34.ad_guid AS ad_guid_38, t34.password_hash AS password_hash_39, t34.reset_token AS reset_token_40, t34.reset_timestamp AS reset_timestamp_41, t34.reset_count AS reset_count_42, t34.account_update AS account_update_43, t34.activation_token AS activation_token_44, t34.activation_timestamp AS activation_timestamp_45, t34.activation_count AS activation_count_46, t34.invitation_token AS invitation_token_47, t34.invitation_timestamp AS invitation_timestamp_48, t34.invitation_count AS invitation_count_49, t34.timestamp AS timestamp_50, t34.roles AS roles_51, t34.emp_index AS emp_index_52, t0.emp_email_primary_index AS emp_email_primary_index_53, t0.emp_citizenship_index AS emp_citizenship_index_54, t0.emp_gender AS emp_gender_55 FROM employee t0 LEFT JOIN users t34 ON t34.emp_index = t0.emp_index WHERE t0.emp_index = ? SELECT t0.emp_index AS emp_index_1, t0.emp_lastname AS emp_lastname_2, t0.emp_firstname AS emp_firstname_3, t0.emp_middlename AS emp_middlename_4, t0.emp_gender AS emp_gender_5, t0.emp_start_date AS emp_start_date_6, t0.emp_suffix AS emp_suffix_7, t0.emp_timestamp_initial AS emp_timestamp_initial_8, t0.emp_timestamp_update AS emp_timestamp_update_9, t0.emp_ftpt AS emp_ftpt_10, t0.emp_show_profile AS emp_show_profile_11, t0.emp_disable AS emp_disable_12, t0.emp_grad_residency AS emp_grad_residency_13, t0.emp_profile_update_flag AS emp_profile_update_flag_14, t0.emp_chief AS emp_chief_15, t0.emp_program_director AS emp_program_director_16, t0.emp_network_provider AS emp_network_provider_17, t0.emp_pending_forms AS emp_pending_forms_18, t0.emp_emerg_name AS emp_emerg_name_19, t0.emp_emerg_phone AS emp_emerg_phone_20, t0.emp_emerg_relationship AS emp_emerg_relationship_21, t0.emp_birthdate AS emp_birthdate_22, t0.emp_birthplace AS emp_birthplace_23, t0.emp_ssn AS emp_ssn_24, t0.emp_race AS emp_race_25, t0.emp_citizenship_index AS emp_citizenship_index_26, t0.emp_ethnicity AS emp_ethnicity_27, t0.emp_email_primary_index AS emp_email_primary_index_28, t0.emp_spouse_name AS emp_spouse_name_29, t0.faculty_auto_exempt AS faculty_auto_exempt_30, t0.bamboo_id AS bamboo_id_31, t0.npi AS npi_32, t0.umms_ad_username AS umms_ad_username_33, t34.user_index AS user_index_35, t34.emp_index AS emp_index_36, t34.username AS username_37, t34.ad_guid AS ad_guid_38, t34.password_hash AS password_hash_39, t34.reset_token AS reset_token_40, t34.reset_timestamp AS reset_timestamp_41, t34.reset_count AS reset_count_42, t34.account_update AS account_update_43, t34.activation_token AS activation_token_44, t34.activation_timestamp AS activation_timestamp_45, t34.activation_count AS activation_count_46, t34.invitation_token AS invitation_token_47, t34.invitation_timestamp AS invitation_timestamp_48, t34.invitation_count AS invitation_count_49, t34.timestamp AS timestamp_50, t34.roles AS roles_51, t34.emp_index AS emp_index_52, t0.emp_email_primary_index AS emp_email_primary_index_53, t0.emp_citizenship_index AS emp_citizenship_index_54, t0.emp_gender AS emp_gender_55 FROM employee t0 LEFT JOIN users t34 ON t34.emp_index = t0.emp_index WHERE t0.emp_index = 104;
22	0.27 ms	SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ? Parameters: [`186`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ? SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = 186;
23	0.27 ms	SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ? Parameters: [`185`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = ? SELECT t0.id AS id_1, t0.tag AS tag_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.updated AS updated_5, t0.updated_by AS updated_by_6 FROM tag t0 INNER JOIN podcast_tag ON t0.id = podcast_tag.tag_id WHERE podcast_tag.podcast_id = 185;

Database Connections

Name	Service
umem	doctrine.dbal.umem_connection
mailman	doctrine.dbal.mailman_connection
moodle	doctrine.dbal.moodle_connection
fabric	doctrine.dbal.fabric_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
fabric	doctrine.orm.fabric_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
Umem\EducationBundle\Entity\Podcast	No errors.
Umem\EducationBundle\Entity\Tag	No errors.
Umem\EmployeeBundle\Entity\Employee	No errors.
Umem\UserBundle\Entity\Users	No errors.
Umem\EmployeeBundle\Entity\Email	No errors.
Umem\EmployeeBundle\Entity\Address	No errors.
Umem\EmployeeBundle\Entity\Phone	No errors.
Umem\EmployeeBundle\Entity\Citizenship	No errors.
Umem\EmployeeBundle\Entity\Gender	No errors.
Umem\EmployeeBundle\Entity\EmpStatus	No errors.
Umem\EmployeeBundle\Entity\EmpSites	No errors.
Umem\EmployeeBundle\Entity\EmpTitle	No errors.
Umem\EmployeeBundle\Entity\EmpProfAssoc	No errors.
Umem\EmployeeBundle\Entity\EmpBoardCert	No errors.
Umem\EmployeeBundle\Entity\EmpPhoto	No errors.
Umem\EmployeeBundle\Entity\Education	No errors.
Umem\EmployeeBundle\Entity\Pref	No errors.
Umem\AppBundle\Entity\Perm	No errors.
Umem\EmployeeBundle\Entity\Bio	No errors.
Umem\UserBundle\Entity\Track	No errors.
Umem\PearlBundle\Entity\Pearl	No errors.
Umem\MedStudentBundle\Entity\Evaluation	No errors.
Umem\EmployeeBundle\Entity\FundingProfile	No errors.
Umem\AppBundle\Entity\ContactsAppAuth	No errors.
Umem\AppBundle\Entity\MeetingDate	No errors.
Umem\AppBundle\Entity\MeetingAttendance	No errors.
Umem\AppBundle\Entity\PermSet	No errors.
Umem\EmployeeBundle\Entity\Site	No errors.
Umem\EmployeeBundle\Entity\AddressType	No errors.
Umem\EmployeeBundle\Entity\PhoneType	No errors.
Umem\EmployeeBundle\Entity\PhoneVendor	No errors.
Umem\EmployeeBundle\Entity\Status	No errors.
Umem\EmployeeBundle\Entity\TitleType	No errors.
Umem\EmployeeBundle\Entity\TitleSubtype	No errors.
Umem\EmployeeBundle\Entity\ProfFellowAssoc	No errors.
Umem\EmployeeBundle\Entity\BoardCertification	No errors.
Umem\EmployeeBundle\Entity\BoardCertStatus	No errors.
Umem\EmployeeBundle\Entity\EduType	No errors.
Umem\EmployeeBundle\Entity\EduSubtype	No errors.
Umem\EmployeeBundle\Entity\Degree	No errors.
Umem\EmployeeBundle\Entity\SiteNetworkMap	No errors.
Umem\EmployeeBundle\Entity\MailingListCriteria	No errors.
Umem\EmployeeBundle\Entity\ContactMe	No errors.
Umem\ContentBundle\Entity\RotationFile	No errors.
Umem\ContentBundle\Entity\PhoneList	No errors.
Umem\ContentBundle\Entity\RotationInfo	No errors.
Umem\ContentBundle\Entity\PhoneCategory	No errors.
Umem\ContentBundle\Entity\DynamicContent	No errors.
Umem\ContentBundle\Entity\Faq	No errors.
Umem\ContentBundle\Entity\BlogPost	No errors.
Umem\ContentBundle\Entity\RotationContact	No errors.
Umem\EventBundle\Entity\EvaluationQuestion	No errors.
Umem\EventBundle\Entity\Event	No errors.
Umem\EventBundle\Entity\OffsiteLecture	No errors.
Umem\EventBundle\Entity\EventLocation	No errors.
Umem\EventBundle\Entity\EvaluationTemplate	No errors.
Umem\EventBundle\Entity\Speaker	No errors.
Umem\EventBundle\Entity\EmployeeIdCard	No errors.
Umem\EventBundle\Entity\EvaluationArchive	No errors.
Umem\EventBundle\Entity\LectureCategory	No errors.
Umem\EventBundle\Entity\LectureAttendance	No errors.
Umem\EventBundle\Entity\EvaluationResponse	No errors.
Umem\EventBundle\Entity\Conference	No errors.
Umem\EventBundle\Entity\Evaluation	No errors.
Umem\EventBundle\Entity\Lecture	No errors.
Umem\EventBundle\Entity\ExtraCredit	No errors.
Vich\UploaderBundle\Entity\File	No errors.
Umem\EventBundle\Entity\EventFile	No errors.
Umem\FileCollectionBundle\Entity\Category	No errors.
Umem\FileCollectionBundle\Entity\File	No errors.
Umem\FileCollectionBundle\Entity\FileCollection	No errors.
Umem\PearlBundle\Entity\PearlCategory	No errors.
Umem\PearlBundle\Entity\PearlFile	No errors.
Umem\PearlBundle\Entity\PushToken	No errors.
Umem\PearlBundle\Entity\Ads	No errors.
Umem\UtilitiesBundle\Entity\State	No errors.
Umem\UtilitiesBundle\Entity\Country	No errors.
Umem\ResearchBundle\Entity\Investigator	No errors.
Umem\ResearchBundle\Entity\ResearchStudy	No errors.
Umem\ResearchBundle\Entity\PrincipalInvestigator	No errors.
Umem\ResearchBundle\Entity\ResearchStatus	No errors.
Umem\MedStudentBundle\Entity\Shift	No errors.
Umem\MedStudentBundle\Entity\EvaluationType	No errors.
Umem\TimesheetBundle\Entity\ClinicalSchedule	No errors.
Umem\TimesheetBundle\Entity\TrackerEvent	No errors.
Umem\SurveyBundle\Entity\Response	No errors.
Umem\SurveyBundle\Entity\Question	No errors.

fabric entity manager

Class	Mapping errors
Umem\FabricBundle\FabricEntity\StaffingModelLevel	No errors.
Umem\FabricBundle\FabricEntity\StaffingModel	The field Umem\FabricBundle\FabricEntity\StaffingModel#levels is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Umem\FabricBundle\FabricEntity\StaffingModelLevel#model does not contain the required 'inversedBy="levels"' attribute.
Umem\FabricBundle\FabricEntity\StaffingModelWeight	No errors.

Symfony Profiler

GET https://stg.umem.org/educational/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

umem connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

fabric entity manager