Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.92 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.02 ms
(34.90%)

SELECT DISTINCT d0_.id AS id_0, d0_.description AS description_1, d0_.year AS year_2, d0_.engine_volume AS engine_volume_3, d0_.drivetrain AS drivetrain_4, d0_.fuel_type AS fuel_type_5, d0_.transmission_type AS transmission_type_6, d0_.vin AS vin_7, d0_.stock_number AS stock_number_8, d0_.slug AS slug_9, d0_.address AS address_10, d0_.created_at AS created_at_11, d1_.id AS id_12, d1_.image_name AS image_name_13, d1_.sort_order AS sort_order_14, m2_.id AS id_15, m2_.name AS name_16, m2_.slug AS slug_17, m2_.ext_source AS ext_source_18, m2_.ext_id AS ext_id_19, m3_.id AS id_20, m3_.name AS name_21, m3_.slug AS slug_22, m3_.ext_id AS ext_id_23, v4_.id AS id_24, v4_.year_from AS year_from_25, v4_.year_to AS year_to_26, v4_.generation_name AS generation_name_27, a5_.id AS id_28, a5_.name AS name_29, a5_.slug AS slug_30, a5_.description AS description_31, a5_.street_address AS street_address_32, a5_.address_line2 AS address_line2_33, a5_.city AS city_34, a5_.state AS state_35, a5_.postal_code AS postal_code_36, a5_.country_code AS country_code_37, a5_.latitude AS latitude_38, a5_.longitude AS longitude_39, a5_.created_at AS created_at_40, a6_.id AS id_41, a6_.label AS label_42, a6_.phone_number AS phone_number_43, a6_.comment AS comment_44, a6_.position AS position_45, d7_.id AS id_46, d7_.label AS label_47, d7_.phone_number AS phone_number_48, d7_.comment AS comment_49, d7_.position AS position_50, d0_.owner_id AS owner_id_51, d0_.make_id AS make_id_52, d0_.model_id AS model_id_53, d0_.vehicle_range_id AS vehicle_range_id_54, d0_.auto_dismantling_id AS auto_dismantling_id_55, d1_.vehicle_id AS vehicle_id_56, m3_.make_id AS make_id_57, v4_.model_id AS model_id_58, a5_.owner_id AS owner_id_59, a6_.dismantling_id AS dismantling_id_60, d7_.vehicle_id AS vehicle_id_61 FROM dismantled_vehicles d0_ LEFT JOIN dismantled_vehicle_photos d1_ ON d0_.id = d1_.vehicle_id LEFT JOIN makes m2_ ON d0_.make_id = m2_.id LEFT JOIN models m3_ ON d0_.model_id = m3_.id LEFT JOIN vehicle_ranges v4_ ON d0_.vehicle_range_id = v4_.id LEFT JOIN auto_dismantlings a5_ ON d0_.auto_dismantling_id = a5_.id LEFT JOIN auto_dismantling_phones a6_ ON a5_.id = a6_.dismantling_id LEFT JOIN dismantled_vehicle_phones d7_ ON d0_.id = d7_.vehicle_id WHERE d0_.id IN (?, ?) ORDER BY a6_.position ASC, a6_.id ASC, d7_.position ASC, d7_.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.description AS description_1,
  d0_.year AS year_2,
  d0_.engine_volume AS engine_volume_3,
  d0_.drivetrain AS drivetrain_4,
  d0_.fuel_type AS fuel_type_5,
  d0_.transmission_type AS transmission_type_6,
  d0_.vin AS vin_7,
  d0_.stock_number AS stock_number_8,
  d0_.slug AS slug_9,
  d0_.address AS address_10,
  d0_.created_at AS created_at_11,
  d1_.id AS id_12,
  d1_.image_name AS image_name_13,
  d1_.sort_order AS sort_order_14,
  m2_.id AS id_15,
  m2_.name AS name_16,
  m2_.slug AS slug_17,
  m2_.ext_source AS ext_source_18,
  m2_.ext_id AS ext_id_19,
  m3_.id AS id_20,
  m3_.name AS name_21,
  m3_.slug AS slug_22,
  m3_.ext_id AS ext_id_23,
  v4_.id AS id_24,
  v4_.year_from AS year_from_25,
  v4_.year_to AS year_to_26,
  v4_.generation_name AS generation_name_27,
  a5_.id AS id_28,
  a5_.name AS name_29,
  a5_.slug AS slug_30,
  a5_.description AS description_31,
  a5_.street_address AS street_address_32,
  a5_.address_line2 AS address_line2_33,
  a5_.city AS city_34,
  a5_.state AS state_35,
  a5_.postal_code AS postal_code_36,
  a5_.country_code AS country_code_37,
  a5_.latitude AS latitude_38,
  a5_.longitude AS longitude_39,
  a5_.created_at AS created_at_40,
  a6_.id AS id_41,
  a6_.label AS label_42,
  a6_.phone_number AS phone_number_43,
  a6_.comment AS comment_44,
  a6_.position AS position_45,
  d7_.id AS id_46,
  d7_.label AS label_47,
  d7_.phone_number AS phone_number_48,
  d7_.comment AS comment_49,
  d7_.position AS position_50,
  d0_.owner_id AS owner_id_51,
  d0_.make_id AS make_id_52,
  d0_.model_id AS model_id_53,
  d0_.vehicle_range_id AS vehicle_range_id_54,
  d0_.auto_dismantling_id AS auto_dismantling_id_55,
  d1_.vehicle_id AS vehicle_id_56,
  m3_.make_id AS make_id_57,
  v4_.model_id AS model_id_58,
  a5_.owner_id AS owner_id_59,
  a6_.dismantling_id AS dismantling_id_60,
  d7_.vehicle_id AS vehicle_id_61
FROM
  dismantled_vehicles d0_
  LEFT JOIN dismantled_vehicle_photos d1_ ON d0_.id = d1_.vehicle_id
  LEFT JOIN makes m2_ ON d0_.make_id = m2_.id
  LEFT JOIN models m3_ ON d0_.model_id = m3_.id
  LEFT JOIN vehicle_ranges v4_ ON d0_.vehicle_range_id = v4_.id
  LEFT JOIN auto_dismantlings a5_ ON d0_.auto_dismantling_id = a5_.id
  LEFT JOIN auto_dismantling_phones a6_ ON a5_.id = a6_.dismantling_id
  LEFT JOIN dismantled_vehicle_phones d7_ ON d0_.id = d7_.vehicle_id
WHERE
  d0_.id IN (?, ?)
ORDER BY
  a6_.position ASC,
  a6_.id ASC,
  d7_.position ASC,
  d7_.id ASC

SELECT DISTINCT d0_.id AS id_0, d0_.description AS description_1, d0_.year AS year_2, d0_.engine_volume AS engine_volume_3, d0_.drivetrain AS drivetrain_4, d0_.fuel_type AS fuel_type_5, d0_.transmission_type AS transmission_type_6, d0_.vin AS vin_7, d0_.stock_number AS stock_number_8, d0_.slug AS slug_9, d0_.address AS address_10, d0_.created_at AS created_at_11, d1_.id AS id_12, d1_.image_name AS image_name_13, d1_.sort_order AS sort_order_14, m2_.id AS id_15, m2_.name AS name_16, m2_.slug AS slug_17, m2_.ext_source AS ext_source_18, m2_.ext_id AS ext_id_19, m3_.id AS id_20, m3_.name AS name_21, m3_.slug AS slug_22, m3_.ext_id AS ext_id_23, v4_.id AS id_24, v4_.year_from AS year_from_25, v4_.year_to AS year_to_26, v4_.generation_name AS generation_name_27, a5_.id AS id_28, a5_.name AS name_29, a5_.slug AS slug_30, a5_.description AS description_31, a5_.street_address AS street_address_32, a5_.address_line2 AS address_line2_33, a5_.city AS city_34, a5_.state AS state_35, a5_.postal_code AS postal_code_36, a5_.country_code AS country_code_37, a5_.latitude AS latitude_38, a5_.longitude AS longitude_39, a5_.created_at AS created_at_40, a6_.id AS id_41, a6_.label AS label_42, a6_.phone_number AS phone_number_43, a6_.comment AS comment_44, a6_.position AS position_45, d7_.id AS id_46, d7_.label AS label_47, d7_.phone_number AS phone_number_48, d7_.comment AS comment_49, d7_.position AS position_50, d0_.owner_id AS owner_id_51, d0_.make_id AS make_id_52, d0_.model_id AS model_id_53, d0_.vehicle_range_id AS vehicle_range_id_54, d0_.auto_dismantling_id AS auto_dismantling_id_55, d1_.vehicle_id AS vehicle_id_56, m3_.make_id AS make_id_57, v4_.model_id AS model_id_58, a5_.owner_id AS owner_id_59, a6_.dismantling_id AS dismantling_id_60, d7_.vehicle_id AS vehicle_id_61 FROM dismantled_vehicles d0_ LEFT JOIN dismantled_vehicle_photos d1_ ON d0_.id = d1_.vehicle_id LEFT JOIN makes m2_ ON d0_.make_id = m2_.id LEFT JOIN models m3_ ON d0_.model_id = m3_.id LEFT JOIN vehicle_ranges v4_ ON d0_.vehicle_range_id = v4_.id LEFT JOIN auto_dismantlings a5_ ON d0_.auto_dismantling_id = a5_.id LEFT JOIN auto_dismantling_phones a6_ ON a5_.id = a6_.dismantling_id LEFT JOIN dismantled_vehicle_phones d7_ ON d0_.id = d7_.vehicle_id WHERE d0_.id IN (10, 8) ORDER BY a6_.position ASC, a6_.id ASC, d7_.position ASC, d7_.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 930)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 886)
5	Doctrine\ORM\AbstractQuery->execute (line 688)
6	Doctrine\ORM\AbstractQuery->getResult (line 344)
7	App\Repository\DismantledVehicleRepository->findForPublicByIds (line 266)
8	App\Repository\DismantledVehicleRepository->findLatestByMakeForPublic (line 46)
9	App\Controller\Catalog\DismantledVehicleCatalogController->make (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.59 ms
(20.33%)

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2, m0_.ext_id AS ext_id_3, COUNT(d1_.id) AS sclr_4, m0_.make_id AS make_id_5 FROM models m0_ LEFT JOIN dismantled_vehicles d1_ ON (d1_.model_id = m0_.id) WHERE m0_.make_id = ? GROUP BY m0_.id HAVING COUNT(d1_.id) > 0 ORDER BY m0_.name ASC

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.slug AS slug_2,
  m0_.ext_id AS ext_id_3,
  COUNT(d1_.id) AS sclr_4,
  m0_.make_id AS make_id_5
FROM
  models m0_
  LEFT JOIN dismantled_vehicles d1_ ON (d1_.model_id = m0_.id)
WHERE
  m0_.make_id = ?
GROUP BY
  m0_.id
HAVING
  COUNT(d1_.id) > 0
ORDER BY
  m0_.name ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2, m0_.ext_id AS ext_id_3, COUNT(d1_.id) AS sclr_4, m0_.make_id AS make_id_5 FROM models m0_ LEFT JOIN dismantled_vehicles d1_ ON (d1_.model_id = m0_.id) WHERE m0_.make_id = 48 GROUP BY m0_.id HAVING COUNT(d1_.id) > 0 ORDER BY m0_.name 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 930)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 886)
5	Doctrine\ORM\AbstractQuery->execute (line 688)
6	Doctrine\ORM\AbstractQuery->getResult (line 37)
7	App\Repository\ModelRepository->findByMakeWithDismantledVehiclesCount (line 51)
8	App\Controller\Catalog\DismantledVehicleCatalogController->make (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.51 ms
(17.39%)

SELECT COUNT(d0_.id) AS sclr_0 FROM dismantled_vehicles d0_ LEFT JOIN makes m1_ ON d0_.make_id = m1_.id WHERE m1_.id = ?

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  dismantled_vehicles d0_
  LEFT JOIN makes m1_ ON d0_.make_id = m1_.id
WHERE
  m1_.id = ?

SELECT COUNT(d0_.id) AS sclr_0 FROM dismantled_vehicles d0_ LEFT JOIN makes m1_ ON d0_.make_id = m1_.id WHERE m1_.id = 48;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 930)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 886)
5	Doctrine\ORM\AbstractQuery->execute (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 801)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 121)
8	App\Repository\DismantledVehicleRepository->countByMakeForPublic (line 47)
9	App\Controller\Catalog\DismantledVehicleCatalogController->make (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.42 ms
(14.30%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ext_source AS ext_source_4, t0.ext_id AS ext_id_5 FROM makes t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "bmw"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.ext_source AS ext_source_4,
  t0.ext_id AS ext_id_5
FROM
  makes t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ext_source AS ext_source_4, t0.ext_id AS ext_id_5 FROM makes t0 WHERE t0.slug = 'bmw' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 41)
5	App\Controller\Catalog\DismantledVehicleCatalogController->make (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.38 ms
(13.08%)

SELECT d0_.id AS id_0 FROM dismantled_vehicles d0_ WHERE d0_.make_id = ? ORDER BY d0_.created_at DESC LIMIT 8

Parameters:

[
  48
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0
FROM
  dismantled_vehicles d0_
WHERE
  d0_.make_id = ?
ORDER BY
  d0_.created_at DESC
LIMIT
  8

SELECT d0_.id AS id_0 FROM dismantled_vehicles d0_ WHERE d0_.make_id = 48 ORDER BY d0_.created_at DESC LIMIT 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 930)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 886)
5	Doctrine\ORM\AbstractQuery->execute (line 712)
6	Doctrine\ORM\AbstractQuery->getSingleColumnResult (line 264)
7	App\Repository\DismantledVehicleRepository->findLatestByMakeForPublic (line 46)
8	App\Controller\Catalog\DismantledVehicleCatalogController->make (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\Make	No errors.
App\Entity\Model	No errors.
App\Entity\DismantledVehicle	No errors.
App\Entity\DismantledVehiclePhoto	No errors.
App\Entity\VehicleRange	No errors.
App\Entity\AutoDismantling	No errors.
App\Entity\AutoDismantlingPhone	No errors.
App\Entity\DismantledVehiclePhone	No errors.
App\Entity\Users	No errors.

Symfony Profiler

GET http://88.99.167.175/en/dismantled-cars/bmw

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping