Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title_part1 AS title_part1_2,
  t0.title_part2 AS title_part2_3,
  t0.position AS position_4,
  t0.active AS active_5,
  t0.page_id AS page_id_6,
  t0.category_id AS category_id_7
FROM
  page_section t0
WHERE
  t0.category_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title_part1 AS title_part1_2, t0.title_part2 AS title_part2_3, t0.position AS position_4, t0.active AS active_5, t0.page_id AS page_id_6, t0.category_id AS category_id_7 FROM page_section t0 WHERE t0.category_id = 18 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.pre_title AS pre_title_3,
  t0.title AS title_4,
  t0.text AS text_5,
  t0.image AS image_6,
  t0.config AS config_7,
  t0.embed_url AS embed_url_8,
  t0.item_count AS item_count_9,
  t0.position AS position_10,
  t0.updated_at AS updated_at_11,
  t0.section_id AS section_id_12,
  t0.related_category_id AS related_category_id_13
FROM
  page_block t0
WHERE
  t0.section_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.pre_title AS pre_title_3, t0.title AS title_4, t0.text AS text_5, t0.image AS image_6, t0.config AS config_7, t0.embed_url AS embed_url_8, t0.item_count AS item_count_9, t0.position AS position_10, t0.updated_at AS updated_at_11, t0.section_id AS section_id_12, t0.related_category_id AS related_category_id_13 FROM page_block t0 WHERE t0.section_id = 6 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.pre_title AS pre_title_4,
  t0.description AS description_5,
  t0.show_in_header AS show_in_header_6,
  t0.show_in_footer AS show_in_footer_7,
  t0.tenant_id AS tenant_id_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.parent_id = ?
  AND (
    (t0.tenant_id = '3')
  )
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.pre_title AS pre_title_4, t0.description AS description_5, t0.show_in_header AS show_in_header_6, t0.show_in_footer AS show_in_footer_7, t0.tenant_id AS tenant_id_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.parent_id = 16 AND ((t0.tenant_id = '3')) ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.name AS name_3,
  t0.logo AS logo_4,
  t0.dark_logo AS dark_logo_5,
  t0.primary_color AS primary_color_6,
  t0.secondary_color AS secondary_color_7,
  t0.contact_email AS contact_email_8,
  t0.youtube_link AS youtube_link_9,
  t0.instagram_link AS instagram_link_10,
  t0.facebook_link AS facebook_link_11,
  t0.whatsapp_link AS whatsapp_link_12,
  t0.linkedin_link AS linkedin_link_13,
  t0.about_text AS about_text_14,
  t0.about_full_text AS about_full_text_15,
  t0.about_image AS about_image_16,
  t0.address AS address_17,
  t0.phone AS phone_18,
  t0.maps_embed_url AS maps_embed_url_19,
  t0.required_approvals AS required_approvals_20,
  t0.theme AS theme_21,
  t0.updated_at AS updated_at_22
FROM
  tenant t0
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.name AS name_3, t0.logo AS logo_4, t0.dark_logo AS dark_logo_5, t0.primary_color AS primary_color_6, t0.secondary_color AS secondary_color_7, t0.contact_email AS contact_email_8, t0.youtube_link AS youtube_link_9, t0.instagram_link AS instagram_link_10, t0.facebook_link AS facebook_link_11, t0.whatsapp_link AS whatsapp_link_12, t0.linkedin_link AS linkedin_link_13, t0.about_text AS about_text_14, t0.about_full_text AS about_full_text_15, t0.about_image AS about_image_16, t0.address AS address_17, t0.phone AS phone_18, t0.maps_embed_url AS maps_embed_url_19, t0.required_approvals AS required_approvals_20, t0.theme AS theme_21, t0.updated_at AS updated_at_22 FROM tenant t0 WHERE t0.domain = 'renovandoconsciencias.nepebrasil.org' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.short_description AS short_description_3,
  a0_.content AS content_4,
  a0_.image AS image_5,
  a0_.image_alt AS image_alt_6,
  a0_.published_at AS published_at_7,
  a0_.seo_title AS seo_title_8,
  a0_.seo_description AS seo_description_9,
  a0_.canonical_url AS canonical_url_10,
  a0_.is_no_index AS is_no_index_11,
  a0_.status AS status_12,
  a0_.created_at AS created_at_13,
  a0_.updated_at AS updated_at_14,
  a0_.biblia_chapter AS biblia_chapter_15,
  a0_.biblia_verse_start AS biblia_verse_start_16,
  a0_.biblia_verse_end AS biblia_verse_end_17,
  a0_.tenant_id AS tenant_id_18,
  a0_.category_id AS category_id_19,
  a0_.author_id AS author_id_20,
  a0_.biblia_book_id AS biblia_book_id_21
FROM
  article a0_
WHERE
  (
    a0_.category_id = ?
    AND a0_.status = ?
  )
  AND (a0_.tenant_id = '3')
ORDER BY
  a0_.published_at DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.short_description AS short_description_3, a0_.content AS content_4, a0_.image AS image_5, a0_.image_alt AS image_alt_6, a0_.published_at AS published_at_7, a0_.seo_title AS seo_title_8, a0_.seo_description AS seo_description_9, a0_.canonical_url AS canonical_url_10, a0_.is_no_index AS is_no_index_11, a0_.status AS status_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.biblia_chapter AS biblia_chapter_15, a0_.biblia_verse_start AS biblia_verse_start_16, a0_.biblia_verse_end AS biblia_verse_end_17, a0_.tenant_id AS tenant_id_18, a0_.category_id AS category_id_19, a0_.author_id AS author_id_20, a0_.biblia_book_id AS biblia_book_id_21 FROM article a0_ WHERE (a0_.category_id = 2 AND a0_.status = 'published') AND (a0_.tenant_id = '3') ORDER BY a0_.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.pre_title AS pre_title_4,
  t0.description AS description_5,
  t0.show_in_header AS show_in_header_6,
  t0.show_in_footer AS show_in_footer_7,
  t0.tenant_id AS tenant_id_8,
  t0.parent_id AS parent_id_9
FROM
  category t0
WHERE
  t0.slug = ?
  AND (
    (t0.tenant_id = '3')
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.pre_title AS pre_title_4, t0.description AS description_5, t0.show_in_header AS show_in_header_6, t0.show_in_footer AS show_in_footer_7, t0.tenant_id AS tenant_id_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.slug = 'estudos' AND ((t0.tenant_id = '3')) LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.pre_title AS pre_title_3,
  c0_.description AS description_4,
  c0_.show_in_header AS show_in_header_5,
  c0_.show_in_footer AS show_in_footer_6,
  c0_.tenant_id AS tenant_id_7,
  c0_.parent_id AS parent_id_8
FROM
  category c0_
WHERE
  (
    c0_.parent_id IS NULL
    AND c0_.show_in_header = 1
  )
  AND (c0_.tenant_id = '3')
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.pre_title AS pre_title_3, c0_.description AS description_4, c0_.show_in_header AS show_in_header_5, c0_.show_in_footer AS show_in_footer_6, c0_.tenant_id AS tenant_id_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE (c0_.parent_id IS NULL AND c0_.show_in_header = 1) AND (c0_.tenant_id = '3') ORDER BY c0_.name ASC;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.slug AS slug_2,
  s0_.cover_image AS cover_image_3,
  s0_.cover_image_updated_at AS cover_image_updated_at_4,
  s0_.description AS description_5,
  s0_.materials_html AS materials_html_6,
  s0_.active AS active_7,
  s0_.created_at AS created_at_8,
  s0_.biblia_chapter AS biblia_chapter_9,
  s0_.biblia_verse_start AS biblia_verse_start_10,
  s0_.biblia_verse_end AS biblia_verse_end_11,
  s0_.tenant_id AS tenant_id_12,
  s0_.category_id AS category_id_13,
  s0_.author_id AS author_id_14,
  s0_.biblia_book_id AS biblia_book_id_15
FROM
  study s0_
WHERE
  (
    s0_.category_id = ?
    AND s0_.active = 1
  )
  AND (s0_.tenant_id = '3')
ORDER BY
  s0_.created_at DESC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.cover_image AS cover_image_3, s0_.cover_image_updated_at AS cover_image_updated_at_4, s0_.description AS description_5, s0_.materials_html AS materials_html_6, s0_.active AS active_7, s0_.created_at AS created_at_8, s0_.biblia_chapter AS biblia_chapter_9, s0_.biblia_verse_start AS biblia_verse_start_10, s0_.biblia_verse_end AS biblia_verse_end_11, s0_.tenant_id AS tenant_id_12, s0_.category_id AS category_id_13, s0_.author_id AS author_id_14, s0_.biblia_book_id AS biblia_book_id_15 FROM study s0_ WHERE (s0_.category_id = 2 AND s0_.active = 1) AND (s0_.tenant_id = '3') ORDER BY s0_.created_at DESC;

SELECT
  v0_.id AS id_0,
  v0_.title AS title_1,
  v0_.slug AS slug_2,
  v0_.youtube_id AS youtube_id_3,
  v0_.custom_thumbnail AS custom_thumbnail_4,
  v0_.custom_thumbnail_updated_at AS custom_thumbnail_updated_at_5,
  v0_.description AS description_6,
  v0_.materials_html AS materials_html_7,
  v0_.created_at AS created_at_8,
  v0_.biblia_chapter AS biblia_chapter_9,
  v0_.biblia_verse_start AS biblia_verse_start_10,
  v0_.biblia_verse_end AS biblia_verse_end_11,
  v0_.tenant_id AS tenant_id_12,
  v0_.category_id AS category_id_13,
  v0_.author_id AS author_id_14,
  v0_.biblia_book_id AS biblia_book_id_15
FROM
  video_support v0_
WHERE
  (v0_.category_id = ?)
  AND (v0_.tenant_id = '3')
ORDER BY
  v0_.created_at DESC

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.slug AS slug_2, v0_.youtube_id AS youtube_id_3, v0_.custom_thumbnail AS custom_thumbnail_4, v0_.custom_thumbnail_updated_at AS custom_thumbnail_updated_at_5, v0_.description AS description_6, v0_.materials_html AS materials_html_7, v0_.created_at AS created_at_8, v0_.biblia_chapter AS biblia_chapter_9, v0_.biblia_verse_start AS biblia_verse_start_10, v0_.biblia_verse_end AS biblia_verse_end_11, v0_.tenant_id AS tenant_id_12, v0_.category_id AS category_id_13, v0_.author_id AS author_id_14, v0_.biblia_book_id AS biblia_book_id_15 FROM video_support v0_ WHERE (v0_.category_id = 2) AND (v0_.tenant_id = '3') ORDER BY v0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.youtube_id AS youtube_id_4,
  t0.custom_thumbnail AS custom_thumbnail_5,
  t0.custom_thumbnail_updated_at AS custom_thumbnail_updated_at_6,
  t0.description AS description_7,
  t0.materials_html AS materials_html_8,
  t0.created_at AS created_at_9,
  t0.biblia_chapter AS biblia_chapter_10,
  t0.biblia_verse_start AS biblia_verse_start_11,
  t0.biblia_verse_end AS biblia_verse_end_12,
  t0.tenant_id AS tenant_id_13,
  t0.category_id AS category_id_14,
  t0.author_id AS author_id_15,
  t0.biblia_book_id AS biblia_book_id_16
FROM
  video_support t0
WHERE
  (
    (t0.tenant_id = '3')
  )
ORDER BY
  t0.created_at DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.youtube_id AS youtube_id_4, t0.custom_thumbnail AS custom_thumbnail_5, t0.custom_thumbnail_updated_at AS custom_thumbnail_updated_at_6, t0.description AS description_7, t0.materials_html AS materials_html_8, t0.created_at AS created_at_9, t0.biblia_chapter AS biblia_chapter_10, t0.biblia_verse_start AS biblia_verse_start_11, t0.biblia_verse_end AS biblia_verse_end_12, t0.tenant_id AS tenant_id_13, t0.category_id AS category_id_14, t0.author_id AS author_id_15, t0.biblia_book_id AS biblia_book_id_16 FROM video_support t0 WHERE ((t0.tenant_id = '3')) ORDER BY t0.created_at DESC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.show_in_header AS show_in_header_4,
  t0.show_in_footer AS show_in_footer_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.biblia_chapter AS biblia_chapter_8,
  t0.biblia_verse_start AS biblia_verse_start_9,
  t0.biblia_verse_end AS biblia_verse_end_10,
  t0.tenant_id AS tenant_id_11,
  t0.biblia_book_id AS biblia_book_id_12
FROM
  page t0
WHERE
  t0.show_in_footer = ?
  AND (
    (t0.tenant_id = '3')
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.show_in_header AS show_in_header_4, t0.show_in_footer AS show_in_footer_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.biblia_chapter AS biblia_chapter_8, t0.biblia_verse_start AS biblia_verse_start_9, t0.biblia_verse_end AS biblia_verse_end_10, t0.tenant_id AS tenant_id_11, t0.biblia_book_id AS biblia_book_id_12 FROM page t0 WHERE t0.show_in_footer = 1 AND ((t0.tenant_id = '3'));

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.cover_image AS cover_image_4,
  t0.cover_image_updated_at AS cover_image_updated_at_5,
  t0.description AS description_6,
  t0.materials_html AS materials_html_7,
  t0.active AS active_8,
  t0.created_at AS created_at_9,
  t0.biblia_chapter AS biblia_chapter_10,
  t0.biblia_verse_start AS biblia_verse_start_11,
  t0.biblia_verse_end AS biblia_verse_end_12,
  t0.tenant_id AS tenant_id_13,
  t0.category_id AS category_id_14,
  t0.author_id AS author_id_15,
  t0.biblia_book_id AS biblia_book_id_16
FROM
  study t0
WHERE
  t0.active = ?
  AND (
    (t0.tenant_id = '3')
  )
ORDER BY
  t0.created_at DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.cover_image AS cover_image_4, t0.cover_image_updated_at AS cover_image_updated_at_5, t0.description AS description_6, t0.materials_html AS materials_html_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.biblia_chapter AS biblia_chapter_10, t0.biblia_verse_start AS biblia_verse_start_11, t0.biblia_verse_end AS biblia_verse_end_12, t0.tenant_id AS tenant_id_13, t0.category_id AS category_id_14, t0.author_id AS author_id_15, t0.biblia_book_id AS biblia_book_id_16 FROM study t0 WHERE t0.active = 1 AND ((t0.tenant_id = '3')) ORDER BY t0.created_at DESC LIMIT 5;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.pre_title AS pre_title_3,
  c0_.description AS description_4,
  c0_.show_in_header AS show_in_header_5,
  c0_.show_in_footer AS show_in_footer_6,
  c0_.tenant_id AS tenant_id_7,
  c0_.parent_id AS parent_id_8
FROM
  category c0_
WHERE
  (
    c0_.parent_id IS NULL
    AND c0_.show_in_footer = 1
  )
  AND (c0_.tenant_id = '3')
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.pre_title AS pre_title_3, c0_.description AS description_4, c0_.show_in_header AS show_in_header_5, c0_.show_in_footer AS show_in_footer_6, c0_.tenant_id AS tenant_id_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE (c0_.parent_id IS NULL AND c0_.show_in_footer = 1) AND (c0_.tenant_id = '3') ORDER BY c0_.name ASC;

SELECT
  COUNT(*)
FROM
  study t0
WHERE
  t0.active = ?
  AND (
    (t0.tenant_id = '3')
  )

SELECT COUNT(*) FROM study t0 WHERE t0.active = 1 AND ((t0.tenant_id = '3'));