Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

276.39 ms Query time

1 Invalid entities

9 Managed entities

Queries

Group similar statements

#▲

Time

Info

39.47 ms

SELECT DISTINCT s0_.id AS id_0, s0_.zero_reading_from_scale AS zero_reading_from_scale_1 FROM scale_calibrations s0_ ORDER BY s0_.zero_reading_from_scale ASC OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.zero_reading_from_scale AS zero_reading_from_scale_1
FROM
  scale_calibrations s0_
ORDER BY
  s0_.zero_reading_from_scale ASC
OFFSET
  0
ROWS
FETCH
  NEXT 20
ROWS
  ONLY

SELECT DISTINCT s0_.id AS id_0, s0_.zero_reading_from_scale AS zero_reading_from_scale_1 FROM scale_calibrations s0_ ORDER BY s0_.zero_reading_from_scale ASC OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 136)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

220.23 ms

SELECT s0_.id AS id_0, s0_.date AS date_1, s0_.scale_name AS scale_name_2, s0_.standard_weight_description AS standard_weight_description_3, s0_.declared_weight_kg AS declared_weight_kg_4, s0_.scale_zero_reading AS scale_zero_reading_5, s0_.zero_reading_from_scale AS zero_reading_from_scale_6, s0_.scale_weight_read AS scale_weight_read_7, s0_.weight_reading_from_scale AS weight_reading_from_scale_8, s0_.deviation_abs_kg AS deviation_abs_kg_9, s0_.deviation_pct AS deviation_pct_10, s0_.within_tolerance AS within_tolerance_11, s0_.comment AS comment_12, s0_.calibrated AS calibrated_13, s0_.scale_id AS scale_id_14, s0_.standard_weight_id AS standard_weight_id_15, s0_.last_bundle_weighed AS last_bundle_weighed_16 FROM scale_calibrations s0_ WHERE s0_.id IN (?, ?, ?) ORDER BY s0_.zero_reading_from_scale ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.date AS date_1,
  s0_.scale_name AS scale_name_2,
  s0_.standard_weight_description AS standard_weight_description_3,
  s0_.declared_weight_kg AS declared_weight_kg_4,
  s0_.scale_zero_reading AS scale_zero_reading_5,
  s0_.zero_reading_from_scale AS zero_reading_from_scale_6,
  s0_.scale_weight_read AS scale_weight_read_7,
  s0_.weight_reading_from_scale AS weight_reading_from_scale_8,
  s0_.deviation_abs_kg AS deviation_abs_kg_9,
  s0_.deviation_pct AS deviation_pct_10,
  s0_.within_tolerance AS within_tolerance_11,
  s0_.comment AS comment_12,
  s0_.calibrated AS calibrated_13,
  s0_.scale_id AS scale_id_14,
  s0_.standard_weight_id AS standard_weight_id_15,
  s0_.last_bundle_weighed AS last_bundle_weighed_16
FROM
  scale_calibrations s0_
WHERE
  s0_.id IN (?, ?, ?)
ORDER BY
  s0_.zero_reading_from_scale ASC

SELECT s0_.id AS id_0, s0_.date AS date_1, s0_.scale_name AS scale_name_2, s0_.standard_weight_description AS standard_weight_description_3, s0_.declared_weight_kg AS declared_weight_kg_4, s0_.scale_zero_reading AS scale_zero_reading_5, s0_.zero_reading_from_scale AS zero_reading_from_scale_6, s0_.scale_weight_read AS scale_weight_read_7, s0_.weight_reading_from_scale AS weight_reading_from_scale_8, s0_.deviation_abs_kg AS deviation_abs_kg_9, s0_.deviation_pct AS deviation_pct_10, s0_.within_tolerance AS within_tolerance_11, s0_.comment AS comment_12, s0_.calibrated AS calibrated_13, s0_.scale_id AS scale_id_14, s0_.standard_weight_id AS standard_weight_id_15, s0_.last_bundle_weighed AS last_bundle_weighed_16 FROM scale_calibrations s0_ WHERE s0_.id IN (3, 2, 1) ORDER BY s0_.zero_reading_from_scale ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 71)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 136)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

16.69 ms

SELECT count(*) AS sclr_0 FROM scale_calibrations s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  scale_calibrations s0_

SELECT count(*) AS sclr_0 FROM scale_calibrations s0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 725)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 72)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 136)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	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\Scale\ScaleCalibrations	3
App\Entity\Scale\ListStandardWeights	3
App\Entity\CopperBundles	2
App\Entity\Scale\ListScales	1

Entities Mapping

Class	Mapping errors
App\Entity\Scale\ScaleCalibrations	No errors.
App\Entity\Scale\ListScales	The field App\Entity\Scale\ListScales#calibrations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Scale\ScaleCalibrations#scale does not contain the required 'inversedBy: "calibrations"' attribute.
App\Entity\Scale\ListStandardWeights	No errors.
App\Entity\CopperBundles	No errors.

Symfony Profiler

GET http://92.112.194.177/admin/scale-calibrations?page=1&sort%5BzeroReadingFromScale%5D=ASC

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping