Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

12.87 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.99 ms
(77.59%)

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM exact_sales_orders e0_ INNER JOIN exact_accounts e1_ ON e0_.deliver_to_id = e1_.id INNER JOIN exact_accounts e2_ ON e0_.invoice_to_id = e2_.id LEFT JOIN exact_contacts e3_ ON e0_.deliver_to_contact_id = e3_.id LEFT JOIN exact_contacts e4_ ON e0_.invoice_to_contact_id = e4_.id WHERE e0_.order_number = ?

Parameters:

[
  "4473"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  exact_sales_orders e0_
  INNER JOIN exact_accounts e1_ ON e0_.deliver_to_id = e1_.id
  INNER JOIN exact_accounts e2_ ON e0_.invoice_to_id = e2_.id
  LEFT JOIN exact_contacts e3_ ON e0_.deliver_to_contact_id = e3_.id
  LEFT JOIN exact_contacts e4_ ON e0_.invoice_to_contact_id = e4_.id
WHERE
  e0_.order_number = ?

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM exact_sales_orders e0_ INNER JOIN exact_accounts e1_ ON e0_.deliver_to_id = e1_.id INNER JOIN exact_accounts e2_ ON e0_.invoice_to_id = e2_.id LEFT JOIN exact_contacts e3_ ON e0_.deliver_to_contact_id = e3_.id LEFT JOIN exact_contacts e4_ ON e0_.invoice_to_contact_id = e4_.id WHERE e0_.order_number = '4473';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 49)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 66)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 90)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
17	ApiPlatform\State\Processor\WriteProcessor->process (line 54)
18	ApiPlatform\Symfony\Validator\State\ValidateProcessor->process (line 40)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
22	Symfony\Component\HttpKernel\Kernel->handle (line 143)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
24	require_once (line 32)
25	require_once (line 5)

2.88 ms
(22.41%)

SELECT e0_.id AS id_0, e0_.exact_id AS exact_id_1, e0_.order_id AS order_id_2, e0_.created AS created_3, e0_.timestamp AS timestamp_4, e0_.order_number AS order_number_5, e0_.delivery_date AS delivery_date_6, e0_.description AS description_7, e0_.remarks AS remarks_8, e0_.client_ref AS client_ref_9, e1_.id AS id_10, e1_.exact_id AS exact_id_11, e1_.code AS code_12, e1_.created AS created_13, e1_.email AS email_14, e1_.name AS name_15, e1_.timestamp AS timestamp_16, e1_.address_line1 AS address_line1_17, e1_.address_line2 AS address_line2_18, e1_.address_line3 AS address_line3_19, e1_.blocked AS blocked_20, e1_.auto_import AS auto_import_21, e1_.city AS city_22, e1_.country AS country_23, e1_.country_name AS country_name_24, e1_.phone AS phone_25, e1_.postcode AS postcode_26, e1_.remarks AS remarks_27, e1_.status AS status_28, e1_.website AS website_29, e2_.id AS id_30, e2_.exact_id AS exact_id_31, e2_.code AS code_32, e2_.created AS created_33, e2_.email AS email_34, e2_.name AS name_35, e2_.timestamp AS timestamp_36, e2_.address_line1 AS address_line1_37, e2_.address_line2 AS address_line2_38, e2_.address_line3 AS address_line3_39, e2_.blocked AS blocked_40, e2_.auto_import AS auto_import_41, e2_.city AS city_42, e2_.country AS country_43, e2_.country_name AS country_name_44, e2_.phone AS phone_45, e2_.postcode AS postcode_46, e2_.remarks AS remarks_47, e2_.status AS status_48, e2_.website AS website_49, e3_.id AS id_50, e3_.exact_id AS exact_id_51, e3_.code AS code_52, e3_.created AS created_53, e3_.email AS email_54, e3_.timestamp AS timestamp_55, e3_.firstname AS firstname_56, e3_.lastname AS lastname_57, e3_.middlename AS middlename_58, e3_.phone AS phone_59, e3_.mobile AS mobile_60, e3_.auto_import AS auto_import_61, e4_.id AS id_62, e4_.exact_id AS exact_id_63, e4_.code AS code_64, e4_.created AS created_65, e4_.email AS email_66, e4_.timestamp AS timestamp_67, e4_.firstname AS firstname_68, e4_.lastname AS lastname_69, e4_.middlename AS middlename_70, e4_.phone AS phone_71, e4_.mobile AS mobile_72, e4_.auto_import AS auto_import_73, e0_.deliver_to_id AS deliver_to_id_74, e0_.invoice_to_id AS invoice_to_id_75, e0_.deliver_to_contact_id AS deliver_to_contact_id_76, e0_.invoice_to_contact_id AS invoice_to_contact_id_77, e3_.account_id AS account_id_78, e4_.account_id AS account_id_79 FROM exact_sales_orders e0_ INNER JOIN exact_accounts e1_ ON e0_.deliver_to_id = e1_.id INNER JOIN exact_accounts e2_ ON e0_.invoice_to_id = e2_.id LEFT JOIN exact_contacts e3_ ON e0_.deliver_to_contact_id = e3_.id LEFT JOIN exact_contacts e4_ ON e0_.invoice_to_contact_id = e4_.id WHERE e0_.order_number = ? ORDER BY e0_.id ASC LIMIT 30

Parameters:

[
  "4473"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.exact_id AS exact_id_1,
  e0_.order_id AS order_id_2,
  e0_.created AS created_3,
  e0_.timestamp AS timestamp_4,
  e0_.order_number AS order_number_5,
  e0_.delivery_date AS delivery_date_6,
  e0_.description AS description_7,
  e0_.remarks AS remarks_8,
  e0_.client_ref AS client_ref_9,
  e1_.id AS id_10,
  e1_.exact_id AS exact_id_11,
  e1_.code AS code_12,
  e1_.created AS created_13,
  e1_.email AS email_14,
  e1_.name AS name_15,
  e1_.timestamp AS timestamp_16,
  e1_.address_line1 AS address_line1_17,
  e1_.address_line2 AS address_line2_18,
  e1_.address_line3 AS address_line3_19,
  e1_.blocked AS blocked_20,
  e1_.auto_import AS auto_import_21,
  e1_.city AS city_22,
  e1_.country AS country_23,
  e1_.country_name AS country_name_24,
  e1_.phone AS phone_25,
  e1_.postcode AS postcode_26,
  e1_.remarks AS remarks_27,
  e1_.status AS status_28,
  e1_.website AS website_29,
  e2_.id AS id_30,
  e2_.exact_id AS exact_id_31,
  e2_.code AS code_32,
  e2_.created AS created_33,
  e2_.email AS email_34,
  e2_.name AS name_35,
  e2_.timestamp AS timestamp_36,
  e2_.address_line1 AS address_line1_37,
  e2_.address_line2 AS address_line2_38,
  e2_.address_line3 AS address_line3_39,
  e2_.blocked AS blocked_40,
  e2_.auto_import AS auto_import_41,
  e2_.city AS city_42,
  e2_.country AS country_43,
  e2_.country_name AS country_name_44,
  e2_.phone AS phone_45,
  e2_.postcode AS postcode_46,
  e2_.remarks AS remarks_47,
  e2_.status AS status_48,
  e2_.website AS website_49,
  e3_.id AS id_50,
  e3_.exact_id AS exact_id_51,
  e3_.code AS code_52,
  e3_.created AS created_53,
  e3_.email AS email_54,
  e3_.timestamp AS timestamp_55,
  e3_.firstname AS firstname_56,
  e3_.lastname AS lastname_57,
  e3_.middlename AS middlename_58,
  e3_.phone AS phone_59,
  e3_.mobile AS mobile_60,
  e3_.auto_import AS auto_import_61,
  e4_.id AS id_62,
  e4_.exact_id AS exact_id_63,
  e4_.code AS code_64,
  e4_.created AS created_65,
  e4_.email AS email_66,
  e4_.timestamp AS timestamp_67,
  e4_.firstname AS firstname_68,
  e4_.lastname AS lastname_69,
  e4_.middlename AS middlename_70,
  e4_.phone AS phone_71,
  e4_.mobile AS mobile_72,
  e4_.auto_import AS auto_import_73,
  e0_.deliver_to_id AS deliver_to_id_74,
  e0_.invoice_to_id AS invoice_to_id_75,
  e0_.deliver_to_contact_id AS deliver_to_contact_id_76,
  e0_.invoice_to_contact_id AS invoice_to_contact_id_77,
  e3_.account_id AS account_id_78,
  e4_.account_id AS account_id_79
FROM
  exact_sales_orders e0_
  INNER JOIN exact_accounts e1_ ON e0_.deliver_to_id = e1_.id
  INNER JOIN exact_accounts e2_ ON e0_.invoice_to_id = e2_.id
  LEFT JOIN exact_contacts e3_ ON e0_.deliver_to_contact_id = e3_.id
  LEFT JOIN exact_contacts e4_ ON e0_.invoice_to_contact_id = e4_.id
WHERE
  e0_.order_number = ?
ORDER BY
  e0_.id ASC
LIMIT
  30

SELECT e0_.id AS id_0, e0_.exact_id AS exact_id_1, e0_.order_id AS order_id_2, e0_.created AS created_3, e0_.timestamp AS timestamp_4, e0_.order_number AS order_number_5, e0_.delivery_date AS delivery_date_6, e0_.description AS description_7, e0_.remarks AS remarks_8, e0_.client_ref AS client_ref_9, e1_.id AS id_10, e1_.exact_id AS exact_id_11, e1_.code AS code_12, e1_.created AS created_13, e1_.email AS email_14, e1_.name AS name_15, e1_.timestamp AS timestamp_16, e1_.address_line1 AS address_line1_17, e1_.address_line2 AS address_line2_18, e1_.address_line3 AS address_line3_19, e1_.blocked AS blocked_20, e1_.auto_import AS auto_import_21, e1_.city AS city_22, e1_.country AS country_23, e1_.country_name AS country_name_24, e1_.phone AS phone_25, e1_.postcode AS postcode_26, e1_.remarks AS remarks_27, e1_.status AS status_28, e1_.website AS website_29, e2_.id AS id_30, e2_.exact_id AS exact_id_31, e2_.code AS code_32, e2_.created AS created_33, e2_.email AS email_34, e2_.name AS name_35, e2_.timestamp AS timestamp_36, e2_.address_line1 AS address_line1_37, e2_.address_line2 AS address_line2_38, e2_.address_line3 AS address_line3_39, e2_.blocked AS blocked_40, e2_.auto_import AS auto_import_41, e2_.city AS city_42, e2_.country AS country_43, e2_.country_name AS country_name_44, e2_.phone AS phone_45, e2_.postcode AS postcode_46, e2_.remarks AS remarks_47, e2_.status AS status_48, e2_.website AS website_49, e3_.id AS id_50, e3_.exact_id AS exact_id_51, e3_.code AS code_52, e3_.created AS created_53, e3_.email AS email_54, e3_.timestamp AS timestamp_55, e3_.firstname AS firstname_56, e3_.lastname AS lastname_57, e3_.middlename AS middlename_58, e3_.phone AS phone_59, e3_.mobile AS mobile_60, e3_.auto_import AS auto_import_61, e4_.id AS id_62, e4_.exact_id AS exact_id_63, e4_.code AS code_64, e4_.created AS created_65, e4_.email AS email_66, e4_.timestamp AS timestamp_67, e4_.firstname AS firstname_68, e4_.lastname AS lastname_69, e4_.middlename AS middlename_70, e4_.phone AS phone_71, e4_.mobile AS mobile_72, e4_.auto_import AS auto_import_73, e0_.deliver_to_id AS deliver_to_id_74, e0_.invoice_to_id AS invoice_to_id_75, e0_.deliver_to_contact_id AS deliver_to_contact_id_76, e0_.invoice_to_contact_id AS invoice_to_contact_id_77, e3_.account_id AS account_id_78, e4_.account_id AS account_id_79 FROM exact_sales_orders e0_ INNER JOIN exact_accounts e1_ ON e0_.deliver_to_id = e1_.id INNER JOIN exact_accounts e2_ ON e0_.invoice_to_id = e2_.id LEFT JOIN exact_contacts e3_ ON e0_.deliver_to_contact_id = e3_.id LEFT JOIN exact_contacts e4_ ON e0_.invoice_to_contact_id = e4_.id WHERE e0_.order_number = '4473' ORDER BY e0_.id ASC LIMIT 30;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 151)
7	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 69)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 86)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	ApiPlatform\State\Processor\SerializeProcessor->process (line 85)
17	ApiPlatform\State\Processor\WriteProcessor->process (line 54)
18	ApiPlatform\Symfony\Validator\State\ValidateProcessor->process (line 40)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 125)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
22	Symfony\Component\HttpKernel\Kernel->handle (line 143)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
24	require_once (line 32)
25	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\Exact\SalesOrders	1
App\Entity\Exact\Accounts	1
App\Entity\Exact\Contacts	1

Entities Mapping

Class	Mapping errors
App\Entity\Exact\SalesOrders	No errors.
App\Entity\Exact\Accounts	No errors.
App\Entity\Exact\Contacts	No errors.

GET https://internal.ventilatiebaas.nl/api/sales_orders?orderNumber=4473&page=1

Configuration Settings

Theme

Page Width