Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

251.43 ms Query time

0 Invalid entities

64 Managed entities

Queries

Group similar statements

#▲

Time

Info

241.67 ms

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM `order` o0_ LEFT JOIN order_products o1_ ON o0_.id = o1_.orders_id LEFT JOIN order_product_options o2_ ON o1_.id = o2_.order_product_id LEFT JOIN `order_customer` o3_ ON o0_.customer_id = o3_.id LEFT JOIN order_delivery o4_ ON o0_.delivery_id = o4_.id LEFT JOIN fias f5_ ON o4_.city_id = f5_.fias_id LEFT JOIN users u6_ ON o0_.user_id = u6_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  `order` o0_
  LEFT JOIN order_products o1_ ON o0_.id = o1_.orders_id
  LEFT JOIN order_product_options o2_ ON o1_.id = o2_.order_product_id
  LEFT JOIN `order_customer` o3_ ON o0_.customer_id = o3_.id
  LEFT JOIN order_delivery o4_ ON o0_.delivery_id = o4_.id
  LEFT JOIN fias f5_ ON o4_.city_id = f5_.fias_id
  LEFT JOIN users u6_ ON o0_.user_id = u6_.id

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM `order` o0_ LEFT JOIN order_products o1_ ON o0_.id = o1_.orders_id LEFT JOIN order_product_options o2_ ON o1_.id = o2_.order_product_id LEFT JOIN `order_customer` o3_ ON o0_.customer_id = o3_.id LEFT JOIN order_delivery o4_ ON o0_.delivery_id = o4_.id LEFT JOIN fias f5_ ON o4_.city_id = f5_.fias_id LEFT JOIN users u6_ ON o0_.user_id = u6_.id;

#	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 64)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 87)
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\Controller\MainController->__invoke (line 125)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

4.69 ms

SELECT DISTINCT o0_.id AS id_0, o0_.date_added AS date_added_1 FROM `order` o0_ LEFT JOIN order_products o1_ ON o0_.id = o1_.orders_id LEFT JOIN order_product_options o2_ ON o1_.id = o2_.order_product_id LEFT JOIN `order_customer` o3_ ON o0_.customer_id = o3_.id LEFT JOIN order_delivery o4_ ON o0_.delivery_id = o4_.id LEFT JOIN fias f5_ ON o4_.city_id = f5_.fias_id LEFT JOIN users u6_ ON o0_.user_id = u6_.id ORDER BY o0_.date_added DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.date_added AS date_added_1
FROM
  `order` o0_
  LEFT JOIN order_products o1_ ON o0_.id = o1_.orders_id
  LEFT JOIN order_product_options o2_ ON o1_.id = o2_.order_product_id
  LEFT JOIN `order_customer` o3_ ON o0_.customer_id = o3_.id
  LEFT JOIN order_delivery o4_ ON o0_.delivery_id = o4_.id
  LEFT JOIN fias f5_ ON o4_.city_id = f5_.fias_id
  LEFT JOIN users u6_ ON o0_.user_id = u6_.id
ORDER BY
  o0_.date_added DESC
LIMIT
  10

SELECT DISTINCT o0_.id AS id_0, o0_.date_added AS date_added_1 FROM `order` o0_ LEFT JOIN order_products o1_ ON o0_.id = o1_.orders_id LEFT JOIN order_product_options o2_ ON o1_.id = o2_.order_product_id LEFT JOIN `order_customer` o3_ ON o0_.customer_id = o3_.id LEFT JOIN order_delivery o4_ ON o0_.delivery_id = o4_.id LEFT JOIN fias f5_ ON o4_.city_id = f5_.fias_id LEFT JOIN users u6_ ON o0_.user_id = u6_.id ORDER BY o0_.date_added DESC LIMIT 10;

#	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->getIterator (line 127)
7	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 69)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 83)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 94)
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\Controller\MainController->__invoke (line 125)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	require_once (line 5)

5.07 ms

SELECT o0_.id AS id_0, o0_.order_id AS order_id_1, o0_.date_added AS date_added_2, o0_.comment AS comment_3, o0_.status AS status_4, o0_.total AS total_5, o1_.id AS id_6, o1_.product_id AS product_id_7, o1_.product_name AS product_name_8, o1_.price AS price_9, o1_.quantity AS quantity_10, o1_.sale_price AS sale_price_11, o2_.id AS id_12, o2_.product_id AS product_id_13, o2_.option_name AS option_name_14, o2_.value AS value_15, o2_.price AS price_16, o3_.id AS id_17, o3_.name AS name_18, o3_.phone AS phone_19, o3_.email AS email_20, o3_.ip AS ip_21, o3_.user_agent AS user_agent_22, o3_.phone_normal AS phone_normal_23, o3_.comment AS comment_24, o4_.id AS id_25, o4_.type AS type_26, o4_.address AS address_27, o4_.city AS city_28, o4_.cost AS cost_29, o4_.pvz AS pvz_30, o4_.is_free AS is_free_31, o4_.is_custom_calculate AS is_custom_calculate_32, o4_.pricing_source AS pricing_source_33, o4_.pricing_trace AS pricing_trace_34, o4_.pvz_code AS pvz_code_35, o4_.delivery_date AS delivery_date_36, o4_.delivery_time AS delivery_time_37, f5_.fias_id AS fias_id_38, f5_.parent_id AS parent_id_39, f5_.postalcode AS postalcode_40, f5_.offname AS offname_41, f5_.shortname AS shortname_42, f5_.level AS level_43, u6_.id AS id_44, u6_.name AS name_45, u6_.first_name AS first_name_46, u6_.email AS email_47, u6_.phone AS phone_48, u6_.roles AS roles_49, u6_.password AS password_50, u6_.is_verified AS is_verified_51, u6_.failed_login_attempts AS failed_login_attempts_52, u6_.locked_until AS locked_until_53, u6_.last_login_at AS last_login_at_54, u6_.token_version AS token_version_55, o0_.customer_id AS customer_id_56, o0_.delivery_id AS delivery_id_57, o0_.user_id AS user_id_58, o1_.orders_id AS orders_id_59, o2_.order_product_id AS order_product_id_60, o4_.city_id AS city_id_61 FROM `order` o0_ LEFT JOIN order_products o1_ ON o0_.id = o1_.orders_id LEFT JOIN order_product_options o2_ ON o1_.id = o2_.order_product_id LEFT JOIN `order_customer` o3_ ON o0_.customer_id = o3_.id LEFT JOIN order_delivery o4_ ON o0_.delivery_id = o4_.id LEFT JOIN fias f5_ ON o4_.city_id = f5_.fias_id LEFT JOIN users u6_ ON o0_.user_id = u6_.id WHERE o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.date_added DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.order_id AS order_id_1,
  o0_.date_added AS date_added_2,
  o0_.comment AS comment_3,
  o0_.status AS status_4,
  o0_.total AS total_5,
  o1_.id AS id_6,
  o1_.product_id AS product_id_7,
  o1_.product_name AS product_name_8,
  o1_.price AS price_9,
  o1_.quantity AS quantity_10,
  o1_.sale_price AS sale_price_11,
  o2_.id AS id_12,
  o2_.product_id AS product_id_13,
  o2_.option_name AS option_name_14,
  o2_.value AS value_15,
  o2_.price AS price_16,
  o3_.id AS id_17,
  o3_.name AS name_18,
  o3_.phone AS phone_19,
  o3_.email AS email_20,
  o3_.ip AS ip_21,
  o3_.user_agent AS user_agent_22,
  o3_.phone_normal AS phone_normal_23,
  o3_.comment AS comment_24,
  o4_.id AS id_25,
  o4_.type AS type_26,
  o4_.address AS address_27,
  o4_.city AS city_28,
  o4_.cost AS cost_29,
  o4_.pvz AS pvz_30,
  o4_.is_free AS is_free_31,
  o4_.is_custom_calculate AS is_custom_calculate_32,
  o4_.pricing_source AS pricing_source_33,
  o4_.pricing_trace AS pricing_trace_34,
  o4_.pvz_code AS pvz_code_35,
  o4_.delivery_date AS delivery_date_36,
  o4_.delivery_time AS delivery_time_37,
  f5_.fias_id AS fias_id_38,
  f5_.parent_id AS parent_id_39,
  f5_.postalcode AS postalcode_40,
  f5_.offname AS offname_41,
  f5_.shortname AS shortname_42,
  f5_.level AS level_43,
  u6_.id AS id_44,
  u6_.name AS name_45,
  u6_.first_name AS first_name_46,
  u6_.email AS email_47,
  u6_.phone AS phone_48,
  u6_.roles AS roles_49,
  u6_.password AS password_50,
  u6_.is_verified AS is_verified_51,
  u6_.failed_login_attempts AS failed_login_attempts_52,
  u6_.locked_until AS locked_until_53,
  u6_.last_login_at AS last_login_at_54,
  u6_.token_version AS token_version_55,
  o0_.customer_id AS customer_id_56,
  o0_.delivery_id AS delivery_id_57,
  o0_.user_id AS user_id_58,
  o1_.orders_id AS orders_id_59,
  o2_.order_product_id AS order_product_id_60,
  o4_.city_id AS city_id_61
FROM
  `order` o0_
  LEFT JOIN order_products o1_ ON o0_.id = o1_.orders_id
  LEFT JOIN order_product_options o2_ ON o1_.id = o2_.order_product_id
  LEFT JOIN `order_customer` o3_ ON o0_.customer_id = o3_.id
  LEFT JOIN order_delivery o4_ ON o0_.delivery_id = o4_.id
  LEFT JOIN fias f5_ ON o4_.city_id = f5_.fias_id
  LEFT JOIN users u6_ ON o0_.user_id = u6_.id
WHERE
  o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  o0_.date_added DESC

SELECT o0_.id AS id_0, o0_.order_id AS order_id_1, o0_.date_added AS date_added_2, o0_.comment AS comment_3, o0_.status AS status_4, o0_.total AS total_5, o1_.id AS id_6, o1_.product_id AS product_id_7, o1_.product_name AS product_name_8, o1_.price AS price_9, o1_.quantity AS quantity_10, o1_.sale_price AS sale_price_11, o2_.id AS id_12, o2_.product_id AS product_id_13, o2_.option_name AS option_name_14, o2_.value AS value_15, o2_.price AS price_16, o3_.id AS id_17, o3_.name AS name_18, o3_.phone AS phone_19, o3_.email AS email_20, o3_.ip AS ip_21, o3_.user_agent AS user_agent_22, o3_.phone_normal AS phone_normal_23, o3_.comment AS comment_24, o4_.id AS id_25, o4_.type AS type_26, o4_.address AS address_27, o4_.city AS city_28, o4_.cost AS cost_29, o4_.pvz AS pvz_30, o4_.is_free AS is_free_31, o4_.is_custom_calculate AS is_custom_calculate_32, o4_.pricing_source AS pricing_source_33, o4_.pricing_trace AS pricing_trace_34, o4_.pvz_code AS pvz_code_35, o4_.delivery_date AS delivery_date_36, o4_.delivery_time AS delivery_time_37, f5_.fias_id AS fias_id_38, f5_.parent_id AS parent_id_39, f5_.postalcode AS postalcode_40, f5_.offname AS offname_41, f5_.shortname AS shortname_42, f5_.level AS level_43, u6_.id AS id_44, u6_.name AS name_45, u6_.first_name AS first_name_46, u6_.email AS email_47, u6_.phone AS phone_48, u6_.roles AS roles_49, u6_.password AS password_50, u6_.is_verified AS is_verified_51, u6_.failed_login_attempts AS failed_login_attempts_52, u6_.locked_until AS locked_until_53, u6_.last_login_at AS last_login_at_54, u6_.token_version AS token_version_55, o0_.customer_id AS customer_id_56, o0_.delivery_id AS delivery_id_57, o0_.user_id AS user_id_58, o1_.orders_id AS orders_id_59, o2_.order_product_id AS order_product_id_60, o4_.city_id AS city_id_61 FROM `order` o0_ LEFT JOIN order_products o1_ ON o0_.id = o1_.orders_id LEFT JOIN order_product_options o2_ ON o1_.id = o2_.order_product_id LEFT JOIN `order_customer` o3_ ON o0_.customer_id = o3_.id LEFT JOIN order_delivery o4_ ON o0_.delivery_id = o4_.id LEFT JOIN fias f5_ ON o4_.city_id = f5_.fias_id LEFT JOIN users u6_ ON o0_.user_id = u6_.id WHERE o0_.id IN (32, 31, 30, 29, 28, 27, 26, 25, 24, 23) ORDER BY o0_.date_added DESC;

#	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 145)
7	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 69)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 83)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 94)
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\Controller\MainController->__invoke (line 125)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 182)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	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\OrderProductOptions	18
App\Entity\OrderProducts	15
App\Entity\Order	10
App\Entity\OrderCustomer	10
App\Entity\OrderDelivery	10
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Order	No errors.
App\Entity\OrderProducts	No errors.
App\Entity\OrderProductOptions	No errors.
App\Entity\OrderCustomer	No errors.
App\Entity\OrderDelivery	No errors.
App\Entity\Fias	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://www.lustra-bronza.ru/api/orders?itemsPerPage=10&order%5BdateAdded%5D=desc

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping