Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

1.58 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.51 ms
(32.28%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.logo_name AS logo_name_3, t0.logo_footer_name AS logo_footer_name_4, t0.tel AS tel_5, t0.email AS email_6, t0.adresse1 AS adresse1_7, t0.adresse2 AS adresse2_8, t0.twitter AS twitter_9, t0.facebook AS facebook_10, t0.pinterest AS pinterest_11, t0.instagram AS instagram_12, t0.slogan AS slogan_13, t0.updated_at AS updated_at_14, t0.bg_header_name AS bg_header_name_15, t0.bg_footer_name AS bg_footer_name_16, t0.theme AS theme_17, t0.latitude AS latitude_18, t0.longitude AS longitude_19 FROM parameter t0 WHERE t0.nom = ? LIMIT 1

Parameters:

[
  "header-footer"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.logo_name AS logo_name_3,
  t0.logo_footer_name AS logo_footer_name_4,
  t0.tel AS tel_5,
  t0.email AS email_6,
  t0.adresse1 AS adresse1_7,
  t0.adresse2 AS adresse2_8,
  t0.twitter AS twitter_9,
  t0.facebook AS facebook_10,
  t0.pinterest AS pinterest_11,
  t0.instagram AS instagram_12,
  t0.slogan AS slogan_13,
  t0.updated_at AS updated_at_14,
  t0.bg_header_name AS bg_header_name_15,
  t0.bg_footer_name AS bg_footer_name_16,
  t0.theme AS theme_17,
  t0.latitude AS latitude_18,
  t0.longitude AS longitude_19
FROM
  parameter t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.logo_name AS logo_name_3, t0.logo_footer_name AS logo_footer_name_4, t0.tel AS tel_5, t0.email AS email_6, t0.adresse1 AS adresse1_7, t0.adresse2 AS adresse2_8, t0.twitter AS twitter_9, t0.facebook AS facebook_10, t0.pinterest AS pinterest_11, t0.instagram AS instagram_12, t0.slogan AS slogan_13, t0.updated_at AS updated_at_14, t0.bg_header_name AS bg_header_name_15, t0.bg_footer_name AS bg_footer_name_16, t0.theme AS theme_17, t0.latitude AS latitude_18, t0.longitude AS longitude_19 FROM parameter t0 WHERE t0.nom = 'header-footer' 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 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 66)
5	App\Controller\HomeController->index (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)

0.32 ms
(20.54%)

SELECT t0.id AS id_1, t0.sub_title AS sub_title_2, t0.title AS title_3, t0.slug AS slug_4, t0.image_file_name AS image_file_name_5, t0.content AS content_6, t0.summary AS summary_7, t0.image2_file_name AS image2_file_name_8, t0.image_bg_file_name AS image_bg_file_name_9, t0.updated_at AS updated_at_10 FROM main_slider t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sub_title AS sub_title_2,
  t0.title AS title_3,
  t0.slug AS slug_4,
  t0.image_file_name AS image_file_name_5,
  t0.content AS content_6,
  t0.summary AS summary_7,
  t0.image2_file_name AS image2_file_name_8,
  t0.image_bg_file_name AS image_bg_file_name_9,
  t0.updated_at AS updated_at_10
FROM
  main_slider t0

SELECT t0.id AS id_1, t0.sub_title AS sub_title_2, t0.title AS title_3, t0.slug AS slug_4, t0.image_file_name AS image_file_name_5, t0.content AS content_6, t0.summary AS summary_7, t0.image2_file_name AS image2_file_name_8, t0.image_bg_file_name AS image_bg_file_name_9, t0.updated_at AS updated_at_10 FROM main_slider t0;

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

0.31 ms
(19.73%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.icon AS icon_4, t0.link AS link_5 FROM feature t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.icon AS icon_4,
  t0.link AS link_5
FROM
  feature t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.icon AS icon_4, t0.link AS link_5 FROM feature t0;

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

0.23 ms
(14.51%)

SELECT t0.id AS id_1, t0.tagline AS tagline_2, t0.title AS title_3, t0.text1 AS text1_4, t0.point1 AS point1_5, t0.point2 AS point2_6, t0.text2 AS text2_7, t0.image_file_name AS image_file_name_8, t0.image2_file_name AS image2_file_name_9, t0.nb_project AS nb_project_10, t0.project_text AS project_text_11 FROM company t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.tagline AS tagline_2,
  t0.title AS title_3,
  t0.text1 AS text1_4,
  t0.point1 AS point1_5,
  t0.point2 AS point2_6,
  t0.text2 AS text2_7,
  t0.image_file_name AS image_file_name_8,
  t0.image2_file_name AS image2_file_name_9,
  t0.nb_project AS nb_project_10,
  t0.project_text AS project_text_11
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.tagline AS tagline_2, t0.title AS title_3, t0.text1 AS text1_4, t0.point1 AS point1_5, t0.point2 AS point2_6, t0.text2 AS text2_7, t0.image_file_name AS image_file_name_8, t0.image2_file_name AS image2_file_name_9, t0.nb_project AS nb_project_10, t0.project_text AS project_text_11 FROM company t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 64)
7	App\Controller\HomeController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.20 ms
(12.94%)

SELECT t0.id AS id_1, t0.curved_item AS curved_item_2, t0.video_link AS video_link_3, t0.tagline AS tagline_4, t0.section_title AS section_title_5, t0.text1 AS text1_6, t0.text2 AS text2_7, t0.feature_icon1 AS feature_icon1_8, t0.feature_text1 AS feature_text1_9, t0.feature_icon2 AS feature_icon2_10, t0.feature_text2 AS feature_text2_11, t0.image_file_name AS image_file_name_12, t0.image_small_file_name AS image_small_file_name_13, t0.updated_at AS updated_at_14 FROM quality_work t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.curved_item AS curved_item_2,
  t0.video_link AS video_link_3,
  t0.tagline AS tagline_4,
  t0.section_title AS section_title_5,
  t0.text1 AS text1_6,
  t0.text2 AS text2_7,
  t0.feature_icon1 AS feature_icon1_8,
  t0.feature_text1 AS feature_text1_9,
  t0.feature_icon2 AS feature_icon2_10,
  t0.feature_text2 AS feature_text2_11,
  t0.image_file_name AS image_file_name_12,
  t0.image_small_file_name AS image_small_file_name_13,
  t0.updated_at AS updated_at_14
FROM
  quality_work t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.curved_item AS curved_item_2, t0.video_link AS video_link_3, t0.tagline AS tagline_4, t0.section_title AS section_title_5, t0.text1 AS text1_6, t0.text2 AS text2_7, t0.feature_icon1 AS feature_icon1_8, t0.feature_text1 AS feature_text1_9, t0.feature_icon2 AS feature_icon2_10, t0.feature_text2 AS feature_text2_11, t0.image_file_name AS image_file_name_12, t0.image_small_file_name AS image_small_file_name_13, t0.updated_at AS updated_at_14 FROM quality_work t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 65)
7	App\Controller\HomeController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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\Feature	No errors.
App\Entity\MainSlider	No errors.
App\Entity\Company	No errors.
App\Entity\QualityWork	No errors.
App\Entity\ChallengeProgress	No errors.
App\Entity\Parameter	No errors.

Symfony Profiler

GET https://site.karisma-studio.com/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CHomeController%253A%253Aheader

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping