Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.13 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.15 ms
(54.25%)

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.primary_color_dark AS primary_color_dark_8, t0.secondary_color_dark AS secondary_color_dark_9, t0.contact_email AS contact_email_10, t0.youtube_link AS youtube_link_11, t0.instagram_link AS instagram_link_12, t0.facebook_link AS facebook_link_13, t0.whatsapp_link AS whatsapp_link_14, t0.linkedin_link AS linkedin_link_15, t0.about_text AS about_text_16, t0.about_full_text AS about_full_text_17, t0.about_image AS about_image_18, t0.address AS address_19, t0.phone AS phone_20, t0.maps_embed_url AS maps_embed_url_21, t0.theme AS theme_22, t0.favicon AS favicon_23, t0.seo_title AS seo_title_24, t0.seo_description AS seo_description_25, t0.seo_keywords AS seo_keywords_26, t0.og_image AS og_image_27, t0.font_settings AS font_settings_28, t0.navigation_settings AS navigation_settings_29, t0.show_section_titles AS show_section_titles_30, t0.landing_page_mode AS landing_page_mode_31, t0.updated_at AS updated_at_32, t0.home_page_id AS home_page_id_33 FROM tenant t0 WHERE t0.domain = ? LIMIT 1

Parameters:

[
  "site.wab.com.br"
]

View formatted query View runnable query Explain query View query backtrace

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.primary_color_dark AS primary_color_dark_8,
  t0.secondary_color_dark AS secondary_color_dark_9,
  t0.contact_email AS contact_email_10,
  t0.youtube_link AS youtube_link_11,
  t0.instagram_link AS instagram_link_12,
  t0.facebook_link AS facebook_link_13,
  t0.whatsapp_link AS whatsapp_link_14,
  t0.linkedin_link AS linkedin_link_15,
  t0.about_text AS about_text_16,
  t0.about_full_text AS about_full_text_17,
  t0.about_image AS about_image_18,
  t0.address AS address_19,
  t0.phone AS phone_20,
  t0.maps_embed_url AS maps_embed_url_21,
  t0.theme AS theme_22,
  t0.favicon AS favicon_23,
  t0.seo_title AS seo_title_24,
  t0.seo_description AS seo_description_25,
  t0.seo_keywords AS seo_keywords_26,
  t0.og_image AS og_image_27,
  t0.font_settings AS font_settings_28,
  t0.navigation_settings AS navigation_settings_29,
  t0.show_section_titles AS show_section_titles_30,
  t0.landing_page_mode AS landing_page_mode_31,
  t0.updated_at AS updated_at_32,
  t0.home_page_id AS home_page_id_33
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.primary_color_dark AS primary_color_dark_8, t0.secondary_color_dark AS secondary_color_dark_9, t0.contact_email AS contact_email_10, t0.youtube_link AS youtube_link_11, t0.instagram_link AS instagram_link_12, t0.facebook_link AS facebook_link_13, t0.whatsapp_link AS whatsapp_link_14, t0.linkedin_link AS linkedin_link_15, t0.about_text AS about_text_16, t0.about_full_text AS about_full_text_17, t0.about_image AS about_image_18, t0.address AS address_19, t0.phone AS phone_20, t0.maps_embed_url AS maps_embed_url_21, t0.theme AS theme_22, t0.favicon AS favicon_23, t0.seo_title AS seo_title_24, t0.seo_description AS seo_description_25, t0.seo_keywords AS seo_keywords_26, t0.og_image AS og_image_27, t0.font_settings AS font_settings_28, t0.navigation_settings AS navigation_settings_29, t0.show_section_titles AS show_section_titles_30, t0.landing_page_mode AS landing_page_mode_31, t0.updated_at AS updated_at_32, t0.home_page_id AS home_page_id_33 FROM tenant t0 WHERE t0.domain = 'site.wab.com.br' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 21)
5	App\Repository\TenantRepository->findByDomain (line 48)
6	App\EventSubscriber\TenantSubscriber->onKernelRequest (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.97 ms
(45.75%)

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.cover_image AS cover_image_8, t0.position AS position_9, t0.show_title AS show_title_10, t0.updated_at AS updated_at_11, t0.tenant_id AS tenant_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.tenant_id = ? AND ((t0.tenant_id = '1'))

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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.cover_image AS cover_image_8,
  t0.position AS position_9,
  t0.show_title AS show_title_10,
  t0.updated_at AS updated_at_11,
  t0.tenant_id AS tenant_id_12,
  t0.category_id AS category_id_13
FROM
  page t0
WHERE
  t0.tenant_id = ?
  AND (
    (t0.tenant_id = '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.cover_image AS cover_image_8, t0.position AS position_9, t0.show_title AS show_title_10, t0.updated_at AS updated_at_11, t0.tenant_id AS tenant_id_12, t0.category_id AS category_id_13 FROM page t0 WHERE t0.tenant_id = 1 AND ((t0.tenant_id = '1'));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 38)
5	App\Controller\pub\SitemapController->sitemap (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

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\Page	No errors.
App\Entity\Category	No errors.
App\Entity\PageSection	No errors.

Symfony Profiler

GET https://site.wab.com.br/sitemap.xml

Configuration Settings

Theme