Symfony Profiler

Query Metrics

16 Database Queries

2 Different statements

6.95 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

#▲	Time	Info
1	1.48 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	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: [`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	0.26 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.20 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.19 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.20 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.27 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	0.18 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	1.62 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	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: [`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	0.26 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.31 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.28 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.28 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	0.36 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	0.32 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;

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/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DUmem%255CEducationBundle%255CController%255CEducationController%253A%253Aside…

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