Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.04 ms Query time

0 Invalid entities

251 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

0.69 ms
(66.12%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.is_enabled AS is_enabled_3, c0_.is_deleted AS is_deleted_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM country c0_ ORDER BY c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.code AS code_2,
  c0_.is_enabled AS is_enabled_3,
  c0_.is_deleted AS is_deleted_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6
FROM
  country c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.is_enabled AS is_enabled_3, c0_.is_deleted AS is_deleted_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM country c0_ ORDER BY c0_.name ASC;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	Graphlife\CMSBundle\Controller\SecurityController->register (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.35 ms
(33.88%)

SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?

Parameters:

[
  "enableRegistration"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.parameter_key AS parameter_key_1,
  p0_.parameter_value AS parameter_value_2,
  p0_.parameter_label AS parameter_label_3,
  p0_.parameter_type AS parameter_type_4,
  p0_.parameter_category AS parameter_category_5,
  p0_.in_session AS in_session_6,
  p0_.parameter_category_enabled AS parameter_category_enabled_7,
  p0_.is_deleted AS is_deleted_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10
FROM
  parameter p0_
WHERE
  COALESCE(p0_.is_deleted, 0) = 0
  AND p0_.parameter_key = ?

SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'enableRegistration';

#	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\Repository\ParameterRepository->findOneBy (line 59)
8	Graphlife\CMSBundle\Controller\SecurityController->register (line 145)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	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\Country	250
Graphlife\CMSBundle\Entity\Parameter	1

Entities Mapping

Class	Mapping 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\Page	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/register

Configuration Settings

Theme

Page Width