Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

14.24 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.87 ms
(90.40%)

SELECT COUNT(d0_.id) AS sclr_0 FROM dealer d0_ WHERE d0_.is_active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  dealer d0_
WHERE
  d0_.is_active = ?

SELECT COUNT(d0_.id) AS sclr_0 FROM dealer d0_ WHERE d0_.is_active = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 49)
8	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 68)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 103)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 51)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 92)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
14	Symfony\Component\Serializer\Serializer->normalize (line 129)
15	Symfony\Component\Serializer\Serializer->serialize (line 43)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
18	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 116)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 5)

1.37 ms
(9.60%)

SELECT d0_.id AS id_0, d0_.dealer_id AS dealer_id_1, d0_.dealer_name AS dealer_name_2, d0_.dealer_md AS dealer_md_3, d0_.marketing_manager_name AS marketing_manager_name_4, d0_.marketing_manager_email AS marketing_manager_email_5, d0_.customer_care AS customer_care_6, d0_.dealer_contact_no AS dealer_contact_no_7, d0_.province AS province_8, d0_.address AS address_9, d0_.dealer_ref AS dealer_ref_10, d0_.dealer_floor_used AS dealer_floor_used_11, d0_.dealer_floor_new AS dealer_floor_new_12, d0_.facebook_code AS facebook_code_13, d0_.dp_name AS dp_name_14, d0_.dp_contact_no AS dp_contact_no_15, d0_.dp_email AS dp_email_16, d0_.parts_manager_name AS parts_manager_name_17, d0_.parts_manager_phone AS parts_manager_phone_18, d0_.parts_manager_email AS parts_manager_email_19, d0_.book_service AS book_service_20, d0_.latitude AS latitude_21, d0_.longitude AS longitude_22, d0_.location AS location_23, d0_.country AS country_24, d0_.postal_code AS postal_code_25, d0_.country_code AS country_code_26, d0_.slug AS slug_27, d0_.is_active AS is_active_28, d0_.new_sales_contact AS new_sales_contact_29, d0_.used_sales_contact AS used_sales_contact_30, d0_.service_contact AS service_contact_31, d0_.fi_contact AS fi_contact_32, d0_.created AS created_33, d0_.updated AS updated_34 FROM dealer d0_ WHERE d0_.is_active = ? ORDER BY d0_.id ASC LIMIT 30

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.dealer_id AS dealer_id_1,
  d0_.dealer_name AS dealer_name_2,
  d0_.dealer_md AS dealer_md_3,
  d0_.marketing_manager_name AS marketing_manager_name_4,
  d0_.marketing_manager_email AS marketing_manager_email_5,
  d0_.customer_care AS customer_care_6,
  d0_.dealer_contact_no AS dealer_contact_no_7,
  d0_.province AS province_8,
  d0_.address AS address_9,
  d0_.dealer_ref AS dealer_ref_10,
  d0_.dealer_floor_used AS dealer_floor_used_11,
  d0_.dealer_floor_new AS dealer_floor_new_12,
  d0_.facebook_code AS facebook_code_13,
  d0_.dp_name AS dp_name_14,
  d0_.dp_contact_no AS dp_contact_no_15,
  d0_.dp_email AS dp_email_16,
  d0_.parts_manager_name AS parts_manager_name_17,
  d0_.parts_manager_phone AS parts_manager_phone_18,
  d0_.parts_manager_email AS parts_manager_email_19,
  d0_.book_service AS book_service_20,
  d0_.latitude AS latitude_21,
  d0_.longitude AS longitude_22,
  d0_.location AS location_23,
  d0_.country AS country_24,
  d0_.postal_code AS postal_code_25,
  d0_.country_code AS country_code_26,
  d0_.slug AS slug_27,
  d0_.is_active AS is_active_28,
  d0_.new_sales_contact AS new_sales_contact_29,
  d0_.used_sales_contact AS used_sales_contact_30,
  d0_.service_contact AS service_contact_31,
  d0_.fi_contact AS fi_contact_32,
  d0_.created AS created_33,
  d0_.updated AS updated_34
FROM
  dealer d0_
WHERE
  d0_.is_active = ?
ORDER BY
  d0_.id ASC
LIMIT
  30

SELECT d0_.id AS id_0, d0_.dealer_id AS dealer_id_1, d0_.dealer_name AS dealer_name_2, d0_.dealer_md AS dealer_md_3, d0_.marketing_manager_name AS marketing_manager_name_4, d0_.marketing_manager_email AS marketing_manager_email_5, d0_.customer_care AS customer_care_6, d0_.dealer_contact_no AS dealer_contact_no_7, d0_.province AS province_8, d0_.address AS address_9, d0_.dealer_ref AS dealer_ref_10, d0_.dealer_floor_used AS dealer_floor_used_11, d0_.dealer_floor_new AS dealer_floor_new_12, d0_.facebook_code AS facebook_code_13, d0_.dp_name AS dp_name_14, d0_.dp_contact_no AS dp_contact_no_15, d0_.dp_email AS dp_email_16, d0_.parts_manager_name AS parts_manager_name_17, d0_.parts_manager_phone AS parts_manager_phone_18, d0_.parts_manager_email AS parts_manager_email_19, d0_.book_service AS book_service_20, d0_.latitude AS latitude_21, d0_.longitude AS longitude_22, d0_.location AS location_23, d0_.country AS country_24, d0_.postal_code AS postal_code_25, d0_.country_code AS country_code_26, d0_.slug AS slug_27, d0_.is_active AS is_active_28, d0_.new_sales_contact AS new_sales_contact_29, d0_.used_sales_contact AS used_sales_contact_30, d0_.service_contact AS service_contact_31, d0_.fi_contact AS fi_contact_32, d0_.created AS created_33, d0_.updated AS updated_34 FROM dealer d0_ WHERE d0_.is_active = 1 ORDER BY d0_.id ASC LIMIT 30;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
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 177)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 87)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 110)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 51)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 92)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 49)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
14	Symfony\Component\Serializer\Serializer->normalize (line 129)
15	Symfony\Component\Serializer\Serializer->serialize (line 43)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
18	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 116)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	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\Dealer	The mappings App\Entity\Dealer#administer and App\Entity\Admin#dealer are inconsistent with each other.
App\Entity\Vehicle	No errors.
App\Entity\ServiceSpecial	No errors.
App\Entity\SpecialDeals	No errors.
App\Entity\GoogleSheet	No errors.
App\Entity\Admin	The association App\Entity\Admin#dealer refers to the inverse side field App\Entity\Dealer#owner which does not exist.

Symfony Profiler

GET https://motusmg-qa.nerdw.com/api/dealers

Configuration Settings

Theme