Symfony Profiler

Query Metrics

13 Database Queries

3 Different statements

2.84 ms Query time

0 Invalid entities

5 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

1.99 ms
(69.83%)

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?

Parameters:

[
  "text"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.class AS class_2,
  w0_.code AS code_3,
  w0_.template AS template_4,
  w0_.is_deleted AS is_deleted_5,
  w0_.created_at AS created_at_6,
  w0_.updated_at AS updated_at_7
FROM
  widget w0_
WHERE
  COALESCE(w0_.is_deleted, 0) = 0
  AND w0_.code = ?

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = 'text';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Graphlife\CMSBundle\Repository\BaseRepository->findOneBy (line 114)
7	Graphlife\CMSBundle\Extension\CmsExtension->getWidgetTemplate (line 559)
8	__TwigTemplate_3b753cf64fbe24dc475e52b956adff5f->doDisplay (line 223)
9	Twig\Template->yield (line 411)
10	__TwigTemplate_ba411e918b8c8248f9d69c4c4cf1eedb->block_body (line 197)
11	Twig\Template->yieldBlock (line 456)
12	__TwigTemplate_bb52c411f62135b8fb7e64ec90ee945d->block_main (line 711)
13	Twig\Template->yieldBlock (line 456)
14	__TwigTemplate_bb52c411f62135b8fb7e64ec90ee945d->doDisplay (line 385)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_ba411e918b8c8248f9d69c4c4cf1eedb->doDisplay (line 64)
17	Twig\Template->yield (line 411)
18	Twig\Template->display (line 366)
19	Twig\Template->render (line 381)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	Graphlife\CMSBundle\Controller\PageController->page (line 30)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.45 ms
(15.75%)

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.options AS options_3, f0_.price AS price_4, f0_.is_subscription_open AS is_subscription_open_5, f0_.payment_configuration AS payment_configuration_6, f0_.price_ht AS price_ht_7, f0_.is_in_top_bar AS is_in_top_bar_8, f0_.top_bar_message AS top_bar_message_9, f0_.is_deleted AS is_deleted_10, f0_.created_at AS created_at_11, f0_.updated_at AS updated_at_12, f0_.subscription_class_id AS subscription_class_id_13, f0_.product_type_id AS product_type_id_14 FROM formation f0_ WHERE COALESCE(f0_.is_deleted, 0) = 0 AND f0_.is_in_top_bar = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.description AS description_2,
  f0_.options AS options_3,
  f0_.price AS price_4,
  f0_.is_subscription_open AS is_subscription_open_5,
  f0_.payment_configuration AS payment_configuration_6,
  f0_.price_ht AS price_ht_7,
  f0_.is_in_top_bar AS is_in_top_bar_8,
  f0_.top_bar_message AS top_bar_message_9,
  f0_.is_deleted AS is_deleted_10,
  f0_.created_at AS created_at_11,
  f0_.updated_at AS updated_at_12,
  f0_.subscription_class_id AS subscription_class_id_13,
  f0_.product_type_id AS product_type_id_14
FROM
  formation f0_
WHERE
  COALESCE(f0_.is_deleted, 0) = 0
  AND f0_.is_in_top_bar = ?

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.options AS options_3, f0_.price AS price_4, f0_.is_subscription_open AS is_subscription_open_5, f0_.payment_configuration AS payment_configuration_6, f0_.price_ht AS price_ht_7, f0_.is_in_top_bar AS is_in_top_bar_8, f0_.top_bar_message AS top_bar_message_9, f0_.is_deleted AS is_deleted_10, f0_.created_at AS created_at_11, f0_.updated_at AS updated_at_12, f0_.subscription_class_id AS subscription_class_id_13, f0_.product_type_id AS product_type_id_14 FROM formation f0_ WHERE COALESCE(f0_.is_deleted, 0) = 0 AND f0_.is_in_top_bar = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Graphlife\CMSBundle\Repository\BaseRepository->findOneBy (line 114)
7	Graphlife\LMSBundle\Twig\Runtime\LmsTwigRuntime->{closure:Graphlife\LMSBundle\Twig\Runtime\LmsTwigRuntime::getInTopBarSubscription():43} (line 43)
8	Graphlife\LMSBundle\Twig\Runtime\LmsTwigRuntime->remember (line 244)
9	Graphlife\LMSBundle\Twig\Runtime\LmsTwigRuntime->getInTopBarSubscription (line 43)
10	__TwigTemplate_bb52c411f62135b8fb7e64ec90ee945d->block_main (line 533)
11	Twig\Template->yieldBlock (line 456)
12	__TwigTemplate_bb52c411f62135b8fb7e64ec90ee945d->doDisplay (line 385)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_ba411e918b8c8248f9d69c4c4cf1eedb->doDisplay (line 64)
15	Twig\Template->yield (line 411)
16	Twig\Template->display (line 366)
17	Twig\Template->render (line 381)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
23	Graphlife\CMSBundle\Controller\PageController->page (line 30)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.41 ms
(14.42%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.slug AS slug_3, p0_.image_bkg AS image_bkg_4, p0_.header_image AS header_image_5, p0_.subtitle AS subtitle_6, p0_.is_home AS is_home_7, p0_.header_type AS header_type_8, p0_.header_detail AS header_detail_9, p0_.keywords AS keywords_10, p0_.transparent_menu AS transparent_menu_11, p0_.content AS content_12, p0_.is_deleted AS is_deleted_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15 FROM page p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.code = ?

Parameters:

[
  "vision"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.code AS code_2,
  p0_.slug AS slug_3,
  p0_.image_bkg AS image_bkg_4,
  p0_.header_image AS header_image_5,
  p0_.subtitle AS subtitle_6,
  p0_.is_home AS is_home_7,
  p0_.header_type AS header_type_8,
  p0_.header_detail AS header_detail_9,
  p0_.keywords AS keywords_10,
  p0_.transparent_menu AS transparent_menu_11,
  p0_.content AS content_12,
  p0_.is_deleted AS is_deleted_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15
FROM
  page p0_
WHERE
  COALESCE(p0_.is_deleted, 0) = 0
  AND p0_.code = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.slug AS slug_3, p0_.image_bkg AS image_bkg_4, p0_.header_image AS header_image_5, p0_.subtitle AS subtitle_6, p0_.is_home AS is_home_7, p0_.header_type AS header_type_8, p0_.header_detail AS header_detail_9, p0_.keywords AS keywords_10, p0_.transparent_menu AS transparent_menu_11, p0_.content AS content_12, p0_.is_deleted AS is_deleted_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15 FROM page p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.code = 'vision';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	Graphlife\CMSBundle\Repository\BaseRepository->findOneBy (line 114)
7	Graphlife\CMSBundle\Controller\PageController->page (line 23)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	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

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects
Graphlife\CMSBundle\Entity\Widget	4
Graphlife\CMSBundle\Entity\Page	1

Entities Mapping

Class	Mapping errors
Graphlife\CMSBundle\Entity\Page	No errors.
Graphlife\LMSBundle\Entity\Document	No errors.
Graphlife\LMSBundle\Entity\Event	No errors.
Graphlife\LMSBundle\Entity\Formation	No errors.
Graphlife\LMSBundle\Entity\Lesson	No errors.
Graphlife\LMSBundle\Entity\LessonStatus	No errors.
Graphlife\LMSBundle\Entity\LiveSession	No errors.
Graphlife\LMSBundle\Entity\Question	No errors.
Graphlife\LMSBundle\Entity\QuestionFAQ	No errors.
Graphlife\LMSBundle\Entity\QuestionFAQCategory	No errors.
Graphlife\LMSBundle\Entity\StudentClass	No errors.
Graphlife\LMSBundle\Entity\Test	No errors.
Graphlife\LMSBundle\Entity\UserCourse	No errors.
Graphlife\LMSBundle\Entity\VideoProgress	No errors.
Graphlife\LMSBundle\Entity\VideoUploading	No errors.
Graphlife\CMSPaymentBundle\Entity\Currency	No errors.
Graphlife\CMSPaymentBundle\Entity\Product	No errors.
Graphlife\CMSPaymentBundle\Entity\Package	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentMethod	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentPlan	No errors.
Graphlife\CMSPaymentBundle\Entity\ProductImage	No errors.
Graphlife\CMSPaymentBundle\Entity\ProductTax	No errors.
Graphlife\CMSPaymentBundle\Entity\ProductType	No errors.
Graphlife\CMSPaymentBundle\Entity\Promotion	No errors.
Graphlife\CMSPaymentBundle\Entity\ShippmentStatus	No errors.
Graphlife\CMSPaymentBundle\Entity\Stock	No errors.
Graphlife\CMSPaymentBundle\Entity\Transporter	No errors.
Graphlife\CMSPaymentBundle\Entity\Category	No errors.
Graphlife\CMSPaymentBundle\Entity\CodePromo	No errors.
Graphlife\CMSPaymentBundle\Entity\Payment	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentStatus	No errors.
Graphlife\CMSPaymentBundle\Entity\ShippingMethod	No errors.
Graphlife\CMSPaymentBundle\Entity\Shippment	No errors.
Graphlife\CMSPaymentBundle\Entity\Transaction	No errors.
Graphlife\CMSBundle\Entity\Country	No errors.
Graphlife\CMSBundle\Entity\Email	No errors.
Graphlife\CMSBundle\Entity\NewsletterEmail	No errors.
Graphlife\CMSBundle\Entity\ParameterCategory	No errors.
Graphlife\CMSBundle\Entity\Widget	No errors.
Graphlife\CMSBundle\Entity\Banner	No errors.
Graphlife\CMSBundle\Entity\EntityTranslation	No errors.
Graphlife\CMSBundle\Entity\Language	No errors.
Graphlife\CMSBundle\Entity\Menu	No errors.
Graphlife\CMSBundle\Entity\Parameter	No errors.
Graphlife\CMSBundle\Entity\PolicyTerm	No errors.
Graphlife\CMSBundle\Entity\PostCategory	No errors.
Graphlife\CMSBundle\Entity\User	No errors.
Graphlife\CMSBundle\Entity\Notification	No errors.
Graphlife\CMSBundle\Entity\Post	No errors.
App\Entity\BankTransfer	No errors.
App\Entity\CommissionFormateur	No errors.
App\Entity\CompanyCourse	No errors.
App\Entity\DemandeFormateur	No errors.
App\Entity\UserCompany	No errors.
App\Entity\Company	No errors.
App\Entity\CompanyCourseAssignment	No errors.
App\Entity\ServiceCompany	No errors.
App\Entity\FeatureTour	No errors.
App\Entity\FeatureTourProgress	No errors.
App\Entity\FeatureTourStep	No errors.

Symfony Profiler

GET https://africafirst.graph-life.fr/page/vision

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping