Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

22.36 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.19 ms
(36.62%)

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.site_email AS site_email_3, t0.address AS address_4, t0.city AS city_5, t0.state AS state_6, t0.country AS country_7, t0.telephone AS telephone_8, t0.facebook_id AS facebook_id_9, t0.twitter_id AS twitter_id_10, t0.website_theme AS website_theme_11, t0.company_logo AS company_logo_12, t0.invoice_logo AS invoice_logo_13, t0.short_date AS short_date_14, t0.time_format AS time_format_15, t0.long_date AS long_date_16, t0.def_time_zone AS def_time_zone_17, t0.def_locale AS def_locale_18, t0.week_starts_on AS week_starts_on_19, t0.invoice_header AS invoice_header_20, t0.invoice_footer AS invoice_footer_21, t0.site_offline AS site_offline_22, t0.items_per_page AS items_per_page_23, t0.invoice_page_format AS invoice_page_format_24, t0.default_currency AS default_currency_25, t0.show_slider AS show_slider_26, t0.show_news AS show_news_27, t0.site_meta_keywords AS site_meta_keywords_28, t0.site_description AS site_description_29, t0.news_length AS news_length_30, t0.telephone_alt AS telephone_alt_31, t0.email_alt AS email_alt_32, t0.instagram_id AS instagram_id_33 FROM configuration t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.site_email AS site_email_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.state AS state_6,
  t0.country AS country_7,
  t0.telephone AS telephone_8,
  t0.facebook_id AS facebook_id_9,
  t0.twitter_id AS twitter_id_10,
  t0.website_theme AS website_theme_11,
  t0.company_logo AS company_logo_12,
  t0.invoice_logo AS invoice_logo_13,
  t0.short_date AS short_date_14,
  t0.time_format AS time_format_15,
  t0.long_date AS long_date_16,
  t0.def_time_zone AS def_time_zone_17,
  t0.def_locale AS def_locale_18,
  t0.week_starts_on AS week_starts_on_19,
  t0.invoice_header AS invoice_header_20,
  t0.invoice_footer AS invoice_footer_21,
  t0.site_offline AS site_offline_22,
  t0.items_per_page AS items_per_page_23,
  t0.invoice_page_format AS invoice_page_format_24,
  t0.default_currency AS default_currency_25,
  t0.show_slider AS show_slider_26,
  t0.show_news AS show_news_27,
  t0.site_meta_keywords AS site_meta_keywords_28,
  t0.site_description AS site_description_29,
  t0.news_length AS news_length_30,
  t0.telephone_alt AS telephone_alt_31,
  t0.email_alt AS email_alt_32,
  t0.instagram_id AS instagram_id_33
FROM
  configuration t0

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.site_email AS site_email_3, t0.address AS address_4, t0.city AS city_5, t0.state AS state_6, t0.country AS country_7, t0.telephone AS telephone_8, t0.facebook_id AS facebook_id_9, t0.twitter_id AS twitter_id_10, t0.website_theme AS website_theme_11, t0.company_logo AS company_logo_12, t0.invoice_logo AS invoice_logo_13, t0.short_date AS short_date_14, t0.time_format AS time_format_15, t0.long_date AS long_date_16, t0.def_time_zone AS def_time_zone_17, t0.def_locale AS def_locale_18, t0.week_starts_on AS week_starts_on_19, t0.invoice_header AS invoice_header_20, t0.invoice_footer AS invoice_footer_21, t0.site_offline AS site_offline_22, t0.items_per_page AS items_per_page_23, t0.invoice_page_format AS invoice_page_format_24, t0.default_currency AS default_currency_25, t0.show_slider AS show_slider_26, t0.show_news AS show_news_27, t0.site_meta_keywords AS site_meta_keywords_28, t0.site_description AS site_description_29, t0.news_length AS news_length_30, t0.telephone_alt AS telephone_alt_31, t0.email_alt AS email_alt_32, t0.instagram_id AS instagram_id_33 FROM configuration t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 25)
5	App\Twig\GlobalVars->getGlobalVars (line 80)
6	__TwigTemplate_f63b2634198f08f4c6dbdd3b353925d4->doDisplay (line 360)
7	Twig\Template->yield (line 53)
8	__TwigTemplate_e340a2efced31a3e4644b1935d4e6de6->doDisplay (line 360)
9	Twig\Template->yield (line 335)
10	Twig\Template->render (line 38)
11	Twig\TemplateWrapper->render (line 307)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 17)
16	App\Controller\HomeController->interactivePractice (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

8.09 ms
(36.17%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.has_children AS has_children_4, t0.position AS position_5 FROM navigation t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.link AS link_3,
  t0.has_children AS has_children_4,
  t0.position AS position_5
FROM
  navigation t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.has_children AS has_children_4, t0.position AS position_5 FROM navigation t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 26)
5	App\Twig\GlobalVars->getGlobalVars (line 80)
6	__TwigTemplate_f63b2634198f08f4c6dbdd3b353925d4->doDisplay (line 360)
7	Twig\Template->yield (line 53)
8	__TwigTemplate_e340a2efced31a3e4644b1935d4e6de6->doDisplay (line 360)
9	Twig\Template->yield (line 335)
10	Twig\Template->render (line 38)
11	Twig\TemplateWrapper->render (line 307)
12	Twig\Environment->render (line 448)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 17)
16	App\Controller\HomeController->interactivePractice (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

6.08 ms
(27.21%)

SELECT COUNT(*) FROM music_piece t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  music_piece t0

SELECT COUNT(*) FROM music_piece t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 881)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->count (line 255)
3	Doctrine\ORM\EntityRepository->count (line 15)
4	App\Controller\HomeController->interactivePractice (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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\MusicPiece	No errors.
App\Entity\Configuration	No errors.
App\Entity\Navigation	No errors.

Symfony Profiler

GET https://practito.com.babyblossom.co.ke/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping