Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

9 Database Queries

7 Different statements

27.45 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.17 ms

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.status AS status_3, p0_.address AS address_4, p0_.completion_date AS completion_date_5, p0_.furniture AS furniture_6, p0_.budget_global AS budget_global_7, p0_.unit_size AS unit_size_8, p0_.unit_number AS unit_number_9, p0_.zip_code AS zip_code_10, p0_.city AS city_11, p0_.urban AS urban_12, p0_.service AS service_13, p0_.works AS works_14, p0_.purpose AS purpose_15, p0_.senior AS senior_16, p0_.virtual_tour_before AS virtual_tour_before_17, p0_.virtual_tour_after AS virtual_tour_after_18, p0_.total_size AS total_size_19, p0_.key_number AS key_number_20, p0_.size_per_resident AS size_per_resident_21, p0_.type AS type_22, p0_.citizen_id AS citizen_id_23, p0_.configuration AS configuration_24, p0_.sort AS sort_25, p0_.furnish AS furnish_26, p0_.amo AS amo_27, p0_.sourcing AS sourcing_28, p0_.act AS act_29 FROM product p0_ WHERE p0_.act = '1' ORDER BY p0_.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.status AS status_3,
  p0_.address AS address_4,
  p0_.completion_date AS completion_date_5,
  p0_.furniture AS furniture_6,
  p0_.budget_global AS budget_global_7,
  p0_.unit_size AS unit_size_8,
  p0_.unit_number AS unit_number_9,
  p0_.zip_code AS zip_code_10,
  p0_.city AS city_11,
  p0_.urban AS urban_12,
  p0_.service AS service_13,
  p0_.works AS works_14,
  p0_.purpose AS purpose_15,
  p0_.senior AS senior_16,
  p0_.virtual_tour_before AS virtual_tour_before_17,
  p0_.virtual_tour_after AS virtual_tour_after_18,
  p0_.total_size AS total_size_19,
  p0_.key_number AS key_number_20,
  p0_.size_per_resident AS size_per_resident_21,
  p0_.type AS type_22,
  p0_.citizen_id AS citizen_id_23,
  p0_.configuration AS configuration_24,
  p0_.sort AS sort_25,
  p0_.furnish AS furnish_26,
  p0_.amo AS amo_27,
  p0_.sourcing AS sourcing_28,
  p0_.act AS act_29
FROM
  product p0_
WHERE
  p0_.act = '1'
ORDER BY
  p0_.sort ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.status AS status_3, p0_.address AS address_4, p0_.completion_date AS completion_date_5, p0_.furniture AS furniture_6, p0_.budget_global AS budget_global_7, p0_.unit_size AS unit_size_8, p0_.unit_number AS unit_number_9, p0_.zip_code AS zip_code_10, p0_.city AS city_11, p0_.urban AS urban_12, p0_.service AS service_13, p0_.works AS works_14, p0_.purpose AS purpose_15, p0_.senior AS senior_16, p0_.virtual_tour_before AS virtual_tour_before_17, p0_.virtual_tour_after AS virtual_tour_after_18, p0_.total_size AS total_size_19, p0_.key_number AS key_number_20, p0_.size_per_resident AS size_per_resident_21, p0_.type AS type_22, p0_.citizen_id AS citizen_id_23, p0_.configuration AS configuration_24, p0_.sort AS sort_25, p0_.furnish AS furnish_26, p0_.amo AS amo_27, p0_.sourcing AS sourcing_28, p0_.act AS act_29 FROM product p0_ WHERE p0_.act = '1' ORDER BY p0_.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 33)
7	App\Repository\ProductRepository->findAllSorted (line 152)
8	App\Controller\Pages->portfolio (line 181)
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.49 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.folder AS folder_3, t0.to_table AS to_table_4 FROM gallery t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.folder AS folder_3,
  t0.to_table AS to_table_4
FROM
  gallery t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.folder AS folder_3, t0.to_table AS to_table_4 FROM gallery t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
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 54)
7	App\Xtra\XtraProductImages->product_gallery_list_images (line 163)
8	App\Controller\Pages->portfolio (line 181)
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)

1.81 ms

SELECT p0_.id AS id_0, p0_.sort AS sort_1, p0_.product_id AS product_id_2, p0_.image_id AS image_id_3, p0_.gallery_id AS gallery_id_4, p0_.status AS status_5, p0_.product_id AS product_id_6, p0_.image_id AS image_id_7 FROM product_gallery p0_ WHERE p0_.gallery_id = ? ORDER BY p0_.sort ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.sort AS sort_1,
  p0_.product_id AS product_id_2,
  p0_.image_id AS image_id_3,
  p0_.gallery_id AS gallery_id_4,
  p0_.status AS status_5,
  p0_.product_id AS product_id_6,
  p0_.image_id AS image_id_7
FROM
  product_gallery p0_
WHERE
  p0_.gallery_id = ?
ORDER BY
  p0_.sort ASC

SELECT p0_.id AS id_0, p0_.sort AS sort_1, p0_.product_id AS product_id_2, p0_.image_id AS image_id_3, p0_.gallery_id AS gallery_id_4, p0_.status AS status_5, p0_.product_id AS product_id_6, p0_.image_id AS image_id_7 FROM product_gallery p0_ WHERE p0_.gallery_id = 1 ORDER BY p0_.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 47)
7	App\Repository\ProductGalleryRepository->findByGallery (line 57)
8	App\Xtra\XtraProductImages->product_gallery_list_images (line 163)
9	App\Controller\Pages->portfolio (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

5.49 ms

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.gallery_id AS gallery_id_2 FROM gallery_image g0_ WHERE g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.gallery_id AS gallery_id_2
FROM
  gallery_image g0_
WHERE
  g0_.id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.gallery_id AS gallery_id_2 FROM gallery_image g0_ WHERE g0_.id IN (44, 51, 89, 100, 108, 116, 128, 136, 147, 181, 196, 208, 222, 230, 257, 266, 269, 276, 281, 286, 293, 301, 306, 312, 322, 330, 336, 342, 350, 357, 365, 374, 380, 389, 399, 406, 417, 422, 432, 439, 446, 454, 466, 477, 489, 496, 505, 511, 531, 541, 555, 572, 584, 593, 606, 618, 630, 639, 651, 666, 682, 695, 711, 729, 736, 782, 797, 822, 839, 854, 882, 896, 910, 926, 967, 980, 46, 54, 91, 101, 109, 118, 125, 138, 146, 182, 197, 211, 223, 235, 261, 265, 271, 277, 282, 289, 294, 302, 305, 313, 320, 329, 334, 344, 353, 361, 363, 373, 382, 390, 396, 409, 415, 420, 429, 440, 445, 455, 468, 478, 490, 497, 507, 514, 533, 542, 557, 571, 585, 595, 607, 615, 626, 640, 653, 667, 678, 696, 712, 730, 740, 787, 795, 825, 840, 852, 881, 898, 913, 927, 966, 978, 53, 84, 102, 110, 117, 126, 134, 150, 186, 199, 210, 224, 231, 258, 264, 273, 275, 283, 291, 292, 300, 307, 314, 321, 332, 333, 343, 354, 356, 364, 372, 381, 387, 397, 407, 414, 421, 430, 437, 448, 451, 476, 480, 491, 498, 510, 513, 535, 543, 558, 568, 586, 594, 605, 614, 628, 638, 654, 668, 677, 697, 710, 733, 737, 783, 796, 823, 843, 850, 880, 897, 912, 928, 964, 977, 56, 86, 103, 111, 119, 127, 135, 149, 183, 200, 209, 225, 234, 259, 267, 274, 279, 284, 287, 296, 303, 310, 315, 319, 331, 335, 345, 352, 358, 362, 376, 384, 388, 398, 410, 418, 423, 428, 438, 444, 452, 475, 481, 492, 504, 506, 512, 534, 544, 559, 570, 588, 596, 608, 616, 627, 641, 652, 665, 681, 698, 713, 731, 739, 785, 798, 824, 841, 853, 883, 899, 911, 929, 965, 973, 55, 90, 104, 112, 120, 129, 137, 148, 187, 203, 213, 226, 232, 260, 262, 272, 278, 285, 288, 297, 304, 308, 316, 323, 338, 346, 355, 359, 366, 375, 385, 392, 403, 411, 416, 424, 433, 441, 447, 453, 467, 482, 493, 499, 508, 515, 532, 545, 556, 574, 587, 598, 609, 617, 629, 642, 655, 669, 683, 699, 714, 732, 786, 827, 842, 851, 885, 900, 930, 968, 976, 52, 78, 105, 113, 121, 132, 140, 151, 188, 202, 212, 227, 233, 263, 280, 290, 298, 309, 317, 325, 339, 347, 351, 360, 367, 386, 391, 400, 412, 419, 425, 431, 442, 457, 469, 479, 495, 500, 509, 516, 536, 546, 561, 573, 590, 597, 610, 619, 632, 643, 656, 670, 684, 700, 715, 728, 788, 826, 844, 859, 886, 901, 931, 981, 66, 79, 114, 122, 130, 139, 152, 189, 201, 214, 228, 237, 268, 299, 318, 324, 340, 348, 368, 383, 394, 401, 427, 434, 443, 456, 470, 483, 494, 501, 518, 537, 548, 560, 576, 589, 599, 611, 620, 633, 644, 657, 671, 685, 716, 734, 789, 828, 845, 858, 887, 902, 932, 974, 77, 88, 115, 124, 131, 141, 154, 215, 236, 327, 341, 369, 393, 402, 426, 435, 458, 471, 484, 502, 517, 538, 547, 563, 575, 592, 600, 612, 621, 634, 645, 658, 672, 686, 702, 717, 735, 790, 829, 846, 857, 888, 933, 975, 76, 80, 123, 133, 155, 217, 239, 326, 370, 395, 404, 436, 459, 472, 485, 503, 519, 539, 550, 562, 578, 591, 601, 613, 622, 635, 646, 659, 673, 687, 703, 718, 791, 830, 847, 855, 889, 934, 979, 75, 93, 153, 216, 238, 460, 473, 486, 520, 540, 549, 564, 577, 602, 623, 636, 647, 660, 674, 688, 704, 719, 792, 831, 848, 856, 890, 935, 982, 74, 81, 157, 240, 461, 474, 487, 521, 552, 565, 579, 603, 624, 637, 648, 661, 675, 689, 705, 720, 793, 833, 849, 860, 891, 936, 983, 73, 82, 158, 241, 462, 488, 522, 551, 566, 580, 604, 625, 649, 662, 676, 690, 706, 721, 832, 861, 892, 938, 984, 72, 85, 156, 243, 463, 523, 554, 567, 691, 708, 722, 835, 862, 937, 985, 71, 87, 159, 242, 524, 553, 692, 707, 723, 834, 863, 986, 70, 83, 161, 245, 530, 724, 837, 864, 987, 69, 92, 160, 244, 529, 725, 836, 865, 988, 68, 94, 164, 246, 866, 989, 67, 163, 247, 867, 990, 65, 165, 248, 868, 991, 64, 167, 249, 869, 992, 63, 168, 251, 870, 993, 62, 166, 250, 871, 994, 61, 171, 253, 872, 995, 169, 252, 873, 996, 170, 255, 874, 997, 172, 254, 875, 174, 876, 173, 877, 175, 878, 177, 879, 176, 179, 178, 180, 95, 96, 97, 98, 99, 142, 143, 144, 204, 205, 408, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 761, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 815, 816, 817, 818, 819, 820, 821, 904, 905, 906, 907, 908, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 939, 940, 941, 942, 943, 944, 945, 946, 947, 950, 951, 952, 953, 954, 955, 956, 957, 958, 959, 960, 961, 962, 969, 970, 971, 972, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1016, 1112, 1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1122, 1123, 1124, 1125, 1131, 1132, 1133, 1134, 1135);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 32)
7	App\Repository\GalleryImageRepository->findByImageIds (line 65)
8	App\Xtra\XtraProductImages->product_gallery_list_images (line 163)
9	App\Controller\Pages->portfolio (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.75 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.folder AS folder_3, t0.to_table AS to_table_4 FROM gallery 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.folder AS folder_3,
  t0.to_table AS to_table_4
FROM
  gallery t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.folder AS folder_3, t0.to_table AS to_table_4 FROM gallery t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
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 54)
7	App\Xtra\XtraProductImages->product_gallery_list_images (line 164)
8	App\Controller\Pages->portfolio (line 181)
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)

1.64 ms

SELECT p0_.id AS id_0, p0_.sort AS sort_1, p0_.product_id AS product_id_2, p0_.image_id AS image_id_3, p0_.gallery_id AS gallery_id_4, p0_.status AS status_5, p0_.product_id AS product_id_6, p0_.image_id AS image_id_7 FROM product_gallery p0_ WHERE p0_.gallery_id = ? ORDER BY p0_.sort ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.sort AS sort_1,
  p0_.product_id AS product_id_2,
  p0_.image_id AS image_id_3,
  p0_.gallery_id AS gallery_id_4,
  p0_.status AS status_5,
  p0_.product_id AS product_id_6,
  p0_.image_id AS image_id_7
FROM
  product_gallery p0_
WHERE
  p0_.gallery_id = ?
ORDER BY
  p0_.sort ASC

SELECT p0_.id AS id_0, p0_.sort AS sort_1, p0_.product_id AS product_id_2, p0_.image_id AS image_id_3, p0_.gallery_id AS gallery_id_4, p0_.status AS status_5, p0_.product_id AS product_id_6, p0_.image_id AS image_id_7 FROM product_gallery p0_ WHERE p0_.gallery_id = 2 ORDER BY p0_.sort ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 47)
7	App\Repository\ProductGalleryRepository->findByGallery (line 57)
8	App\Xtra\XtraProductImages->product_gallery_list_images (line 164)
9	App\Controller\Pages->portfolio (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.53 ms

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.gallery_id AS gallery_id_2 FROM gallery_image g0_ WHERE g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.name AS name_1,
  g0_.gallery_id AS gallery_id_2
FROM
  gallery_image g0_
WHERE
  g0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.gallery_id AS gallery_id_2 FROM gallery_image g0_ WHERE g0_.id IN (58, 59, 60, 57, 583, 998, 893, 727, 693, 526, 465, 450, 107, 107, 107, 895, 106, 726, 694, 106, 449, 999, 464, 106, 527, 581, 894, 582, 528, 1015, 1017, 963, 949, 948, 1018, 1126, 925, 1127, 1128, 903, 903, 1129, 1130, 709, 206, 218, 256, 311, 349, 371, 377, 405, 413, 838, 162, 650, 663, 664, 207, 762, 794);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 32)
7	App\Repository\GalleryImageRepository->findByImageIds (line 65)
8	App\Xtra\XtraProductImages->product_gallery_list_images (line 164)
9	App\Controller\Pages->portfolio (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

8.48 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.parent_id AS parent_id_2, c0_.span AS span_3 FROM category c0_ WHERE c0_.parent_id <> 0 ORDER BY c0_.parent_id 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_.parent_id AS parent_id_2,
  c0_.span AS span_3
FROM
  category c0_
WHERE
  c0_.parent_id <> 0
ORDER BY
  c0_.parent_id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.parent_id AS parent_id_2, c0_.span AS span_3 FROM category c0_ WHERE c0_.parent_id <> 0 ORDER BY c0_.parent_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 51)
7	App\Repository\CategoryRepository->findAllCategories (line 179)
8	App\Controller\Pages->portfolio (line 181)
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)

5.10 ms

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.category_id AS category_id_3, t0.category_id AS category_id_4 FROM product_category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.category_id AS category_id_3,
  t0.category_id AS category_id_4
FROM
  product_category t0

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.category_id AS category_id_3, t0.category_id AS category_id_4 FROM product_category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
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 19)
6	App\Xtra\XtraProductCategories->product_get_categories (line 24)
7	App\Xtra\XtraProduct->product_get_classes (line 186)
8	App\Controller\Pages->portfolio (line 181)
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\Product	The association App\Entity\Product#categories refers to the owning side field App\Entity\ProductCategory#product which does not exist.
App\Entity\ProductGallery	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\Gallery	No errors.
App\Entity\GalleryImage	No errors.
App\Entity\Category	No errors.

Symfony Profiler

GET https://dev.citizens-reim.fr/portfolio

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping