GET https://renovandoconsciencias.nepebrasil.org/video/nepe-rc-a-carta-de-tiago

Query Metrics

13 Database Queries
11 Different statements
4.18 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.67 ms
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
Parameters:
[
  "renovandoconsciencias.nepebrasil.org"
]
2 0.46 ms
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.slug = ? AND ((t0.tenant_id = '3')) LIMIT 1
Parameters:
[
  "nepe-rc-a-carta-de-tiago"
]
3 0.39 ms
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_header = ? AND ((t0.tenant_id = '3'))
Parameters:
[
  1
]
4 0.60 ms
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
Parameters:
[]
5 0.27 ms
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'))
Parameters:
[
  1
]
6 0.26 ms
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
Parameters:
[]
7 0.25 ms
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
Parameters:
[]
8 0.23 ms
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
Parameters:
[
  1
]
9 0.20 ms
SELECT COUNT(*) FROM study t0 WHERE t0.active = ? AND ((t0.tenant_id = '3'))
Parameters:
[
  1
]
10 0.22 ms
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
Parameters:
[
  16
]
11 0.24 ms
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
Parameters:
[
  2
]
12 0.19 ms
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
Parameters:
[
  1
]
13 0.21 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.filename AS filename_3, t0.extension AS extension_4, t0.updated_at AS updated_at_5, t0.position AS position_6, t0.video_id AS video_id_7 FROM video_material t0 WHERE t0.video_id = ? ORDER BY t0.position ASC
Parameters:
[
  12
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Tenant No errors.
App\Entity\VideoSupport No errors.
App\Entity\Category No errors.
App\Entity\User No errors.
App\Entity\BibliaBook No errors.
App\Entity\VideoMaterial No errors.
App\Entity\Page No errors.
App\Entity\PageSection No errors.
App\Entity\Study No errors.
App\Entity\StudyMaterial No errors.