Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.46 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.67 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.street_address AS street_address_4, a0_.address_line2 AS address_line2_5, a0_.city AS city_6, a0_.state AS state_7, a0_.postal_code AS postal_code_8, a0_.country_code AS country_code_9, a0_.latitude AS latitude_10, a0_.longitude AS longitude_11, a0_.created_at AS created_at_12, a1_.id AS id_13, a1_.image_name AS image_name_14, a2_.id AS id_15, a2_.label AS label_16, a2_.phone_number AS phone_number_17, a2_.comment AS comment_18, a2_.position AS position_19, a0_.owner_id AS owner_id_20, a1_.dismantling_id AS dismantling_id_21, a2_.dismantling_id AS dismantling_id_22 FROM auto_dismantlings a0_ LEFT JOIN auto_dismantling_photos a1_ ON a0_.id = a1_.dismantling_id LEFT JOIN auto_dismantling_phones a2_ ON a0_.id = a2_.dismantling_id WHERE a0_.id = ? ORDER BY a2_.position ASC, a2_.id ASC

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.description AS description_3,
  a0_.street_address AS street_address_4,
  a0_.address_line2 AS address_line2_5,
  a0_.city AS city_6,
  a0_.state AS state_7,
  a0_.postal_code AS postal_code_8,
  a0_.country_code AS country_code_9,
  a0_.latitude AS latitude_10,
  a0_.longitude AS longitude_11,
  a0_.created_at AS created_at_12,
  a1_.id AS id_13,
  a1_.image_name AS image_name_14,
  a2_.id AS id_15,
  a2_.label AS label_16,
  a2_.phone_number AS phone_number_17,
  a2_.comment AS comment_18,
  a2_.position AS position_19,
  a0_.owner_id AS owner_id_20,
  a1_.dismantling_id AS dismantling_id_21,
  a2_.dismantling_id AS dismantling_id_22
FROM
  auto_dismantlings a0_
  LEFT JOIN auto_dismantling_photos a1_ ON a0_.id = a1_.dismantling_id
  LEFT JOIN auto_dismantling_phones a2_ ON a0_.id = a2_.dismantling_id
WHERE
  a0_.id = ?
ORDER BY
  a2_.position ASC,
  a2_.id ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.street_address AS street_address_4, a0_.address_line2 AS address_line2_5, a0_.city AS city_6, a0_.state AS state_7, a0_.postal_code AS postal_code_8, a0_.country_code AS country_code_9, a0_.latitude AS latitude_10, a0_.longitude AS longitude_11, a0_.created_at AS created_at_12, a1_.id AS id_13, a1_.image_name AS image_name_14, a2_.id AS id_15, a2_.label AS label_16, a2_.phone_number AS phone_number_17, a2_.comment AS comment_18, a2_.position AS position_19, a0_.owner_id AS owner_id_20, a1_.dismantling_id AS dismantling_id_21, a2_.dismantling_id AS dismantling_id_22 FROM auto_dismantlings a0_ LEFT JOIN auto_dismantling_photos a1_ ON a0_.id = a1_.dismantling_id LEFT JOIN auto_dismantling_phones a2_ ON a0_.id = a2_.dismantling_id WHERE a0_.id = 7 ORDER BY a2_.position ASC, a2_.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 737)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 28)
7	App\Repository\AutoDismantlingRepository->findOneForPublic (line 57)
8	App\Controller\Catalog\AutoDismantlingPublicController->show (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.46 ms

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

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT d0_.id AS id_0 FROM dismantled_vehicles d0_ WHERE d0_.auto_dismantling_id = 7 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 74)
7	App\Repository\DismantledVehicleRepository->findByAutoDismantlingPaginated (line 70)
8	App\Controller\Catalog\AutoDismantlingPublicController->show (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.98 ms

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:

[
  19
]

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 (19) 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 76)
8	App\Repository\DismantledVehicleRepository->findByAutoDismantlingPaginated (line 70)
9	App\Controller\Catalog\AutoDismantlingPublicController->show (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.35 ms

SELECT COUNT(d0_.id) AS sclr_0 FROM dismantled_vehicles d0_ WHERE d0_.auto_dismantling_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  dismantled_vehicles d0_
WHERE
  d0_.auto_dismantling_id = ?

SELECT COUNT(d0_.id) AS sclr_0 FROM dismantled_vehicles d0_ WHERE d0_.auto_dismantling_id = 7;

#	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 86)
8	App\Repository\DismantledVehicleRepository->countByAutoDismantling (line 71)
9	App\Controller\Catalog\AutoDismantlingPublicController->show (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)

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\AutoDismantling	No errors.
App\Entity\AutoDismantlingPhoto	No errors.
App\Entity\AutoDismantlingPhone	No errors.
App\Entity\Users	No errors.
App\Entity\DismantledVehicle	No errors.
App\Entity\DismantledVehiclePhoto	No errors.
App\Entity\Make	No errors.
App\Entity\Model	No errors.
App\Entity\VehicleRange	No errors.
App\Entity\DismantledVehiclePhone	No errors.

Symfony Profiler

GET http://88.99.167.175/en/auto-dismantlings/7-milliron-auto-parts

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping