Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.85 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.67 ms
(43.54%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.created_by AS created_by_4, t0.created_date AS created_date_5, t0.modified_by AS modified_by_6, t0.modified_date AS modified_date_7 FROM page_buy t0 WHERE t0.id = ?

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.text AS text_3,
  t0.created_by AS created_by_4,
  t0.created_date AS created_date_5,
  t0.modified_by AS modified_by_6,
  t0.modified_date AS modified_date_7
FROM
  page_buy t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.created_by AS created_by_4, t0.created_date AS created_date_5, t0.modified_by AS modified_by_6, t0.modified_date AS modified_date_7 FROM page_buy t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	App\Controller\InfoController->bid_buy (line 57)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.86 ms
(22.44%)

SELECT l0_.id AS id_0 FROM languages l0_ WHERE l0_.code = ?

Parameters:

[
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0
FROM
  languages l0_
WHERE
  l0_.code = ?

SELECT l0_.id AS id_0 FROM languages l0_ WHERE l0_.code = 'en';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleColumnResult (line 930)
6	App\Service\BaseControllerService->getLanguageId (line 148)
7	App\Controller\InfoController->init (line 38)
8	App\Controller\InfoController->bid_buy (line 55)
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)

0.78 ms
(20.31%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.type AS type_2, t0_.src AS src_3, t0_.model_name AS model_name_4, t0_.model_id AS model_id_5, t0_.value AS value_6, t0_.state AS state_7, t0_.trace AS trace_8, t0_.created_by AS created_by_9, t0_.created_date AS created_date_10, t0_.modified_by AS modified_by_11, t0_.modified_date AS modified_date_12, t0_.language_id AS language_id_13 FROM translations t0_ WHERE t0_.model_name = ? AND t0_.model_id = ? AND t0_.state = ? AND t0_.language_id = ?

Parameters:

[
  "PageBuy"
  1
  "translated"
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.type AS type_2,
  t0_.src AS src_3,
  t0_.model_name AS model_name_4,
  t0_.model_id AS model_id_5,
  t0_.value AS value_6,
  t0_.state AS state_7,
  t0_.trace AS trace_8,
  t0_.created_by AS created_by_9,
  t0_.created_date AS created_date_10,
  t0_.modified_by AS modified_by_11,
  t0_.modified_date AS modified_date_12,
  t0_.language_id AS language_id_13
FROM
  translations t0_
WHERE
  t0_.model_name = ?
  AND t0_.model_id = ?
  AND t0_.state = ?
  AND t0_.language_id = ?

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.type AS type_2, t0_.src AS src_3, t0_.model_name AS model_name_4, t0_.model_id AS model_id_5, t0_.value AS value_6, t0_.state AS state_7, t0_.trace AS trace_8, t0_.created_by AS created_by_9, t0_.created_date AS created_date_10, t0_.modified_by AS modified_by_11, t0_.modified_date AS modified_date_12, t0_.language_id AS language_id_13 FROM translations t0_ WHERE t0_.model_name = 'PageBuy' AND t0_.model_id = 1 AND t0_.state = 'translated' AND t0_.language_id = 2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Controller\InfoController->App\Controller\{closure} (line 155)
7	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
8	Symfony\Component\Cache\LockRegistry->compute (line 111)
9	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
13	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
14	App\Controller\InfoController->getCustomPageTranslations (line 141)
15	App\Controller\InfoController->bid_buy (line 64)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.53 ms
(13.71%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.iso_code AS iso_code_4, t0.active AS active_5, t0.created_by AS created_by_6, t0.created_date AS created_date_7, t0.modified_by AS modified_by_8, t0.modified_date AS modified_date_9 FROM languages t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.iso_code AS iso_code_4,
  t0.active AS active_5,
  t0.created_by AS created_by_6,
  t0.created_date AS created_date_7,
  t0.modified_by AS modified_by_8,
  t0.modified_date AS modified_date_9
FROM
  languages t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.iso_code AS iso_code_4, t0.active AS active_5, t0.created_by AS created_by_6, t0.created_date AS created_date_7, t0.modified_by AS modified_by_8, t0.modified_date AS modified_date_9 FROM languages t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	App\Controller\InfoController->App\Controller\{closure} (line 153)
6	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
7	Symfony\Component\Cache\LockRegistry->compute (line 111)
8	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
12	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
13	App\Controller\InfoController->getCustomPageTranslations (line 141)
14	App\Controller\InfoController->bid_buy (line 64)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\PageBuy	1
App\Entity\Languages	1
App\Entity\Translations	1

Entities Mapping

Class	Mapping errors
App\Entity\Languages	No errors.
App\Entity\PageBuy	No errors.
App\Entity\Contacts	No errors.
App\Entity\Translations	No errors.
App\Entity\Users	No errors.
App\Entity\Profiles	No errors.

Symfony Profiler

GET https://www.test.cr-art-auctions.be/public/index.php/en/info/bid-buy

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping