GET https://renovandoconsciencias.nepebrasil.org/

Query Metrics

18 Database Queries
16 Different statements
6.11 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.71 ms
(11.65%)
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 = ? LIMIT 1
Parameters:
[
  "renovandoconsciencias.nepebrasil.org"
]
0.68 ms
(11.14%)
3
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
]
0.56 ms
(9.18%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.cta_text AS cta_text_4, t0.cta_link AS cta_link_5, t0.background_image AS background_image_6, t0.active AS active_7, t0.position AS position_8, t0.updated_at AS updated_at_9, t0.tenant_id AS tenant_id_10 FROM hero_banner t0 WHERE t0.active = ? AND ((t0.tenant_id = '3')) ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  1
]
0.53 ms
(8.74%)
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_.status = ?) AND (a0_.tenant_id = '3') ORDER BY a0_.published_at DESC LIMIT 3
Parameters:
[
  "published"
]
0.49 ms
(8.07%)
1
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_.tenant_id = '3') ORDER BY v0_.created_at DESC LIMIT 1
Parameters:
[]
0.42 ms
(6.91%)
1
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_.tenant_id = '3') ORDER BY v0_.created_at DESC LIMIT 8 OFFSET 1
Parameters:
[]
0.36 ms
(5.88%)
1
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
]
0.34 ms
(5.63%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.icon AS icon_4, t0.position AS position_5, t0.tenant_id AS tenant_id_6 FROM research_line t0 WHERE ((t0.tenant_id = '3')) ORDER BY t0.position ASC
Parameters:
[]
0.34 ms
(5.63%)
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
Parameters:
[]
0.31 ms
(5.08%)
1
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_.active = 1) AND (s0_.tenant_id = '3') ORDER BY s0_.created_at DESC LIMIT 3
Parameters:
[]
0.26 ms
(4.19%)
1
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:
[]
0.24 ms
(3.95%)
1
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
]
0.24 ms
(3.90%)
1
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
]
0.23 ms
(3.75%)
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_footer = 1) AND (c0_.tenant_id = '3') ORDER BY c0_.name ASC
Parameters:
[]
0.20 ms
(3.22%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.name AS name_3, t0.email AS email_4, t0.work_group AS work_group_5, t0.roles AS roles_6, t0.password AS password_7, t0.tenant_id AS tenant_id_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.19 ms
(3.08%)
1
SELECT COUNT(*) FROM study t0 WHERE t0.active = ? AND ((t0.tenant_id = '3'))
Parameters:
[
  1
]

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\HeroBanner No errors.
App\Entity\Article No errors.
App\Entity\Category No errors.
App\Entity\User No errors.
App\Entity\BibliaBook No errors.
App\Entity\VideoSupport No errors.
App\Entity\VideoMaterial No errors.
App\Entity\ResearchLine No errors.
App\Entity\Page No errors.
App\Entity\PageSection No errors.
App\Entity\Study No errors.
App\Entity\StudyMaterial No errors.