Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

27.52 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

23.11 ms
(83.97%)

SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.file_size AS file_size_2, a0_.file_name AS file_name_3, a0_.file_name_encoded AS file_name_encoded_4, a0_.file_path AS file_path_5, a0_.model_name AS model_name_6, a0_.model_id AS model_id_7, a0_.type AS type_8, a0_.data AS data_9, a0_.sequence AS sequence_10, a0_.created_by AS created_by_11, a0_.created_date AS created_date_12, a0_.modified_by AS modified_by_13, a0_.modified_date AS modified_date_14 FROM attachments a0_ WHERE a0_.description = ?

Parameters:

[
  "103_11.9"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.description AS description_1,
  a0_.file_size AS file_size_2,
  a0_.file_name AS file_name_3,
  a0_.file_name_encoded AS file_name_encoded_4,
  a0_.file_path AS file_path_5,
  a0_.model_name AS model_name_6,
  a0_.model_id AS model_id_7,
  a0_.type AS type_8,
  a0_.data AS data_9,
  a0_.sequence AS sequence_10,
  a0_.created_by AS created_by_11,
  a0_.created_date AS created_date_12,
  a0_.modified_by AS modified_by_13,
  a0_.modified_date AS modified_date_14
FROM
  attachments a0_
WHERE
  a0_.description = ?

SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.file_size AS file_size_2, a0_.file_name AS file_name_3, a0_.file_name_encoded AS file_name_encoded_4, a0_.file_path AS file_path_5, a0_.model_name AS model_name_6, a0_.model_id AS model_id_7, a0_.type AS type_8, a0_.data AS data_9, a0_.sequence AS sequence_10, a0_.created_by AS created_by_11, a0_.created_date AS created_date_12, a0_.modified_by AS modified_by_13, a0_.modified_date AS modified_date_14 FROM attachments a0_ WHERE a0_.description = '103_11.9';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 293)
7	App\Service\BaseControllerService->App\Service\{closure} (line 48)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 104)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 111)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 294)
15	App\Service\BaseControllerService->getLotPrimaryPhotoArray (line 65)
16	App\Controller\ProductDetailController->index (line 182)
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)

1.06 ms
(3.85%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.src AS src_4, t0.model_name AS model_name_5, t0.model_id AS model_id_6, t0.value AS value_7, t0.state AS state_8, t0.trace AS trace_9, t0.created_by AS created_by_10, t0.created_date AS created_date_11, t0.modified_by AS modified_by_12, t0.modified_date AS modified_date_13, t0.language_id AS language_id_14 FROM translations t0 WHERE t0.language_id = ? AND t0.model_name = ? AND t0.model_id = ? AND t0.state = ?

Parameters:

[
  2
  "Catalogue"
  310
  "translated"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.src AS src_4,
  t0.model_name AS model_name_5,
  t0.model_id AS model_id_6,
  t0.value AS value_7,
  t0.state AS state_8,
  t0.trace AS trace_9,
  t0.created_by AS created_by_10,
  t0.created_date AS created_date_11,
  t0.modified_by AS modified_by_12,
  t0.modified_date AS modified_date_13,
  t0.language_id AS language_id_14
FROM
  translations t0
WHERE
  t0.language_id = ?
  AND t0.model_name = ?
  AND t0.model_id = ?
  AND t0.state = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.src AS src_4, t0.model_name AS model_name_5, t0.model_id AS model_id_6, t0.value AS value_7, t0.state AS state_8, t0.trace AS trace_9, t0.created_by AS created_by_10, t0.created_date AS created_date_11, t0.modified_by AS modified_by_12, t0.modified_date AS modified_date_13, t0.language_id AS language_id_14 FROM translations t0 WHERE t0.language_id = 2 AND t0.model_name = 'Catalogue' AND t0.model_id = 310 AND t0.state = 'translated';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 220)
4	App\Service\BaseControllerService->App\Service\{closure} (line 48)
5	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
6	Symfony\Component\Cache\LockRegistry::compute (line 104)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 111)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
11	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 229)
12	App\Service\BaseControllerService->getLotTranslation (line 64)
13	App\Controller\ProductDetailController->index (line 182)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.91 ms
(3.30%)

SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.file_size AS file_size_2, a0_.file_name AS file_name_3, a0_.file_name_encoded AS file_name_encoded_4, a0_.file_path AS file_path_5, a0_.model_name AS model_name_6, a0_.model_id AS model_id_7, a0_.type AS type_8, a0_.data AS data_9, a0_.sequence AS sequence_10, a0_.created_by AS created_by_11, a0_.created_date AS created_date_12, a0_.modified_by AS modified_by_13, a0_.modified_date AS modified_date_14 FROM attachments a0_ WHERE a0_.model_name = ? AND a0_.model_id = ? ORDER BY a0_.sequence ASC

Parameters:

[
  "Catalogue"
  310
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.description AS description_1,
  a0_.file_size AS file_size_2,
  a0_.file_name AS file_name_3,
  a0_.file_name_encoded AS file_name_encoded_4,
  a0_.file_path AS file_path_5,
  a0_.model_name AS model_name_6,
  a0_.model_id AS model_id_7,
  a0_.type AS type_8,
  a0_.data AS data_9,
  a0_.sequence AS sequence_10,
  a0_.created_by AS created_by_11,
  a0_.created_date AS created_date_12,
  a0_.modified_by AS modified_by_13,
  a0_.modified_date AS modified_date_14
FROM
  attachments a0_
WHERE
  a0_.model_name = ?
  AND a0_.model_id = ?
ORDER BY
  a0_.sequence ASC

SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.file_size AS file_size_2, a0_.file_name AS file_name_3, a0_.file_name_encoded AS file_name_encoded_4, a0_.file_path AS file_path_5, a0_.model_name AS model_name_6, a0_.model_id AS model_id_7, a0_.type AS type_8, a0_.data AS data_9, a0_.sequence AS sequence_10, a0_.created_by AS created_by_11, a0_.created_date AS created_date_12, a0_.modified_by AS modified_by_13, a0_.modified_date AS modified_date_14 FROM attachments a0_ WHERE a0_.model_name = 'Catalogue' AND a0_.model_id = 310 ORDER BY a0_.sequence ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 176)
7	App\Service\BaseControllerService->App\Service\{closure} (line 48)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
9	Symfony\Component\Cache\LockRegistry::compute (line 104)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 111)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 204)
15	App\Service\BaseControllerService->getLotPhotos (line 63)
16	App\Controller\ProductDetailController->index (line 182)
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)

0.79 ms
(2.88%)

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\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 925)
6	Doctrine\ORM\AbstractQuery->getSingleColumnResult (line 148)
7	App\Service\BaseControllerService->getLanguageId (line 53)
8	App\Controller\ProductDetailController->index (line 182)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.70 ms
(2.54%)

SELECT t0.id AS id_1, t0.lot_no AS lot_no_2, t0.price_start AS price_start_3, t0.price_end AS price_end_4, t0.description AS description_5, t0.dimensions AS dimensions_6, t0.image AS image_7, t0.index_id AS index_id_8, t0.debawin_id AS debawin_id_9, t0.debawin_consignation_no AS debawin_consignation_no_10, t0.debawin_consignation_name AS debawin_consignation_name_11, t0.min_auction_price AS min_auction_price_12, t0.title AS title_13, t0.condition_report AS condition_report_14, t0.start_bid AS start_bid_15, t0.created_by AS created_by_16, t0.created_date AS created_date_17, t0.modified_by AS modified_by_18, t0.modified_date AS modified_date_19, t0.auction_id AS auction_id_20, t0.category_id AS category_id_21 FROM catalogue t0 WHERE t0.id = ?

Parameters:

[
  "310"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lot_no AS lot_no_2,
  t0.price_start AS price_start_3,
  t0.price_end AS price_end_4,
  t0.description AS description_5,
  t0.dimensions AS dimensions_6,
  t0.image AS image_7,
  t0.index_id AS index_id_8,
  t0.debawin_id AS debawin_id_9,
  t0.debawin_consignation_no AS debawin_consignation_no_10,
  t0.debawin_consignation_name AS debawin_consignation_name_11,
  t0.min_auction_price AS min_auction_price_12,
  t0.title AS title_13,
  t0.condition_report AS condition_report_14,
  t0.start_bid AS start_bid_15,
  t0.created_by AS created_by_16,
  t0.created_date AS created_date_17,
  t0.modified_by AS modified_by_18,
  t0.modified_date AS modified_date_19,
  t0.auction_id AS auction_id_20,
  t0.category_id AS category_id_21
FROM
  catalogue t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lot_no AS lot_no_2, t0.price_start AS price_start_3, t0.price_end AS price_end_4, t0.description AS description_5, t0.dimensions AS dimensions_6, t0.image AS image_7, t0.index_id AS index_id_8, t0.debawin_id AS debawin_id_9, t0.debawin_consignation_no AS debawin_consignation_no_10, t0.debawin_consignation_name AS debawin_consignation_name_11, t0.min_auction_price AS min_auction_price_12, t0.title AS title_13, t0.condition_report AS condition_report_14, t0.start_bid AS start_bid_15, t0.created_by AS created_by_16, t0.created_date AS created_date_17, t0.modified_by AS modified_by_18, t0.modified_date AS modified_date_19, t0.auction_id AS auction_id_20, t0.category_id AS category_id_21 FROM catalogue t0 WHERE t0.id = '310';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 290)
6	App\Controller\ProductDetailController->getLot (line 55)
7	App\Controller\ProductDetailController->index (line 182)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.50 ms
(1.83%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.number AS number_2, a0_.index_id AS index_id_3, a0_.active AS active_4, a0_.visible AS visible_5, a0_.created_by AS created_by_6, a0_.created_date AS created_date_7, a0_.modified_by AS modified_by_8, a0_.modified_date AS modified_date_9 FROM auctions a0_ WHERE a0_.active = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.number AS number_2,
  a0_.index_id AS index_id_3,
  a0_.active AS active_4,
  a0_.visible AS visible_5,
  a0_.created_by AS created_by_6,
  a0_.created_date AS created_date_7,
  a0_.modified_by AS modified_by_8,
  a0_.modified_date AS modified_date_9
FROM
  auctions a0_
WHERE
  a0_.active = ?
LIMIT
  1

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.number AS number_2, a0_.index_id AS index_id_3, a0_.active AS active_4, a0_.visible AS visible_5, a0_.created_by AS created_by_6, a0_.created_date AS created_date_7, a0_.modified_by AS modified_by_8, a0_.modified_date AS modified_date_9 FROM auctions a0_ WHERE a0_.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 51)
7	App\Repository\AuctionsRepository->findActive (line 71)
8	App\Controller\ProductDetailController->index (line 182)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.45 ms
(1.64%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.bids_start AS bids_start_3, t0.bids_end AS bids_end_4, t0.lot_no_start AS lot_no_start_5, t0.lot_no_end AS lot_no_end_6, t0.type AS type_7, t0.created_by AS created_by_8, t0.created_date AS created_date_9, t0.modified_by AS modified_by_10, t0.modified_date AS modified_date_11, t0.auction_id AS auction_id_12 FROM auction_days t0 WHERE t0.auction_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.bids_start AS bids_start_3,
  t0.bids_end AS bids_end_4,
  t0.lot_no_start AS lot_no_start_5,
  t0.lot_no_end AS lot_no_end_6,
  t0.type AS type_7,
  t0.created_by AS created_by_8,
  t0.created_date AS created_date_9,
  t0.modified_by AS modified_by_10,
  t0.modified_date AS modified_date_11,
  t0.auction_id AS auction_id_12
FROM
  auction_days t0
WHERE
  t0.auction_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.bids_start AS bids_start_3, t0.bids_end AS bids_end_4, t0.lot_no_start AS lot_no_start_5, t0.lot_no_end AS lot_no_end_6, t0.type AS type_7, t0.created_by AS created_by_8, t0.created_date AS created_date_9, t0.modified_by AS modified_by_10, t0.modified_date AS modified_date_11, t0.auction_id AS auction_id_12 FROM auction_days t0 WHERE t0.auction_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3166)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 323)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 74)
8	App\Controller\ProductDetailController->index (line 182)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Languages	No errors.
App\Entity\Catalogue	No errors.
App\Entity\Auctions	No errors.
App\Entity\Categories	No errors.
App\Entity\ProfileBids	No errors.
App\Entity\ProfileFavorites	No errors.
App\Entity\AuctionWins	No errors.
App\Entity\SliderImages	No errors.
App\Entity\Results	No errors.
App\Entity\Attachments	No errors.
App\Entity\Translations	No errors.
App\Entity\AuctionBidNumbers	No errors.
App\Entity\AuctionDays	No errors.

Symfony Profiler

GET https://test.cr-art-auctions.be/en/catalog/detail/310

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping