Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

6.79 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

5.20 ms
(76.49%)

SELECT o0_.id AS id_0, o0_.date AS date_1, o0_.amount AS amount_2, o0_.comment AS comment_3, o0_.is_saved AS is_saved_4, o0_.is_archived AS is_archived_5, o0_.order_number AS order_number_6, o0_.delivery_date AS delivery_date_7, o0_.admin_comment AS admin_comment_8, o0_.shipping_costs AS shipping_costs_9, o0_.customer_admin AS customer_admin_10, o0_.delivery_address AS delivery_address_11, o0_.is_delivery AS is_delivery_12, o0_.is_bank_transfer AS is_bank_transfer_13, o0_.amount_hvat AS amount_hvat_14, o0_.payment_id AS payment_id_15, o0_.payment_status AS payment_status_16, o1_.id AS id_17, o1_.quantity AS quantity_18, o1_.amount AS amount_19, o1_.article_array AS article_array_20, o1_.weight AS weight_21, o1_.total_weight AS total_weight_22, o1_.right_price_unit AS right_price_unit_23, o1_.right_price_unit_hvat AS right_price_unit_hvat_24, o1_.comment AS comment_25, u2_.id AS id_26, u2_.email AS email_27, u2_.roles AS roles_28, u2_.password AS password_29, u2_.lastname AS lastname_30, u2_.firstname AS firstname_31, u2_.is_active AS is_active_32, u2_.lang AS lang_33, u2_.is_new AS is_new_34, u2_.customer_id AS customer_id_35, u2_.delivery_address_id AS delivery_address_id_36, u2_.customer_name AS customer_name_37, u2_.password_request AS password_request_38, u2_.is_shipping_cost AS is_shipping_cost_39, u2_.min_order AS min_order_40, u2_.shipping_costs AS shipping_costs_41, u2_.global_discount AS global_discount_42, u2_.is_web AS is_web_43, u2_.vat AS vat_44, u2_.phone AS phone_45, u2_.street AS street_46, u2_.postal_code AS postal_code_47, u2_.city AS city_48, u2_.country AS country_49, u2_.saved AS saved_50, u2_.payment_type AS payment_type_51, u2_.agree_terms_date AS agree_terms_date_52, u2_.admin_customer AS admin_customer_53, o0_.user_id AS user_id_54, o1_.command_id AS command_id_55 FROM `order` o0_ LEFT JOIN order_movement o1_ ON o0_.id = o1_.command_id LEFT JOIN user u2_ ON o0_.user_id = u2_.id WHERE o0_.is_archived = ? AND o0_.is_saved = ? ORDER BY o0_.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.date AS date_1,
  o0_.amount AS amount_2,
  o0_.comment AS comment_3,
  o0_.is_saved AS is_saved_4,
  o0_.is_archived AS is_archived_5,
  o0_.order_number AS order_number_6,
  o0_.delivery_date AS delivery_date_7,
  o0_.admin_comment AS admin_comment_8,
  o0_.shipping_costs AS shipping_costs_9,
  o0_.customer_admin AS customer_admin_10,
  o0_.delivery_address AS delivery_address_11,
  o0_.is_delivery AS is_delivery_12,
  o0_.is_bank_transfer AS is_bank_transfer_13,
  o0_.amount_hvat AS amount_hvat_14,
  o0_.payment_id AS payment_id_15,
  o0_.payment_status AS payment_status_16,
  o1_.id AS id_17,
  o1_.quantity AS quantity_18,
  o1_.amount AS amount_19,
  o1_.article_array AS article_array_20,
  o1_.weight AS weight_21,
  o1_.total_weight AS total_weight_22,
  o1_.right_price_unit AS right_price_unit_23,
  o1_.right_price_unit_hvat AS right_price_unit_hvat_24,
  o1_.comment AS comment_25,
  u2_.id AS id_26,
  u2_.email AS email_27,
  u2_.roles AS roles_28,
  u2_.password AS password_29,
  u2_.lastname AS lastname_30,
  u2_.firstname AS firstname_31,
  u2_.is_active AS is_active_32,
  u2_.lang AS lang_33,
  u2_.is_new AS is_new_34,
  u2_.customer_id AS customer_id_35,
  u2_.delivery_address_id AS delivery_address_id_36,
  u2_.customer_name AS customer_name_37,
  u2_.password_request AS password_request_38,
  u2_.is_shipping_cost AS is_shipping_cost_39,
  u2_.min_order AS min_order_40,
  u2_.shipping_costs AS shipping_costs_41,
  u2_.global_discount AS global_discount_42,
  u2_.is_web AS is_web_43,
  u2_.vat AS vat_44,
  u2_.phone AS phone_45,
  u2_.street AS street_46,
  u2_.postal_code AS postal_code_47,
  u2_.city AS city_48,
  u2_.country AS country_49,
  u2_.saved AS saved_50,
  u2_.payment_type AS payment_type_51,
  u2_.agree_terms_date AS agree_terms_date_52,
  u2_.admin_customer AS admin_customer_53,
  o0_.user_id AS user_id_54,
  o1_.command_id AS command_id_55
FROM
  `order` o0_
  LEFT JOIN order_movement o1_ ON o0_.id = o1_.command_id
  LEFT JOIN user u2_ ON o0_.user_id = u2_.id
WHERE
  o0_.is_archived = ?
  AND o0_.is_saved = ?
ORDER BY
  o0_.id ASC

SELECT o0_.id AS id_0, o0_.date AS date_1, o0_.amount AS amount_2, o0_.comment AS comment_3, o0_.is_saved AS is_saved_4, o0_.is_archived AS is_archived_5, o0_.order_number AS order_number_6, o0_.delivery_date AS delivery_date_7, o0_.admin_comment AS admin_comment_8, o0_.shipping_costs AS shipping_costs_9, o0_.customer_admin AS customer_admin_10, o0_.delivery_address AS delivery_address_11, o0_.is_delivery AS is_delivery_12, o0_.is_bank_transfer AS is_bank_transfer_13, o0_.amount_hvat AS amount_hvat_14, o0_.payment_id AS payment_id_15, o0_.payment_status AS payment_status_16, o1_.id AS id_17, o1_.quantity AS quantity_18, o1_.amount AS amount_19, o1_.article_array AS article_array_20, o1_.weight AS weight_21, o1_.total_weight AS total_weight_22, o1_.right_price_unit AS right_price_unit_23, o1_.right_price_unit_hvat AS right_price_unit_hvat_24, o1_.comment AS comment_25, u2_.id AS id_26, u2_.email AS email_27, u2_.roles AS roles_28, u2_.password AS password_29, u2_.lastname AS lastname_30, u2_.firstname AS firstname_31, u2_.is_active AS is_active_32, u2_.lang AS lang_33, u2_.is_new AS is_new_34, u2_.customer_id AS customer_id_35, u2_.delivery_address_id AS delivery_address_id_36, u2_.customer_name AS customer_name_37, u2_.password_request AS password_request_38, u2_.is_shipping_cost AS is_shipping_cost_39, u2_.min_order AS min_order_40, u2_.shipping_costs AS shipping_costs_41, u2_.global_discount AS global_discount_42, u2_.is_web AS is_web_43, u2_.vat AS vat_44, u2_.phone AS phone_45, u2_.street AS street_46, u2_.postal_code AS postal_code_47, u2_.city AS city_48, u2_.country AS country_49, u2_.saved AS saved_50, u2_.payment_type AS payment_type_51, u2_.agree_terms_date AS agree_terms_date_52, u2_.admin_customer AS admin_customer_53, o0_.user_id AS user_id_54, o1_.command_id AS command_id_55 FROM `order` o0_ LEFT JOIN order_movement o1_ ON o0_.id = o1_.command_id LEFT JOIN user u2_ ON o0_.user_id = u2_.id WHERE o0_.is_archived = 1 AND o0_.is_saved = 0 ORDER BY o0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 81)
7	ApiPlatform\Doctrine\Orm\State\CollectionProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 79)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
10	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
11	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 39)
12	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
13	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
15	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
16	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 86)
17	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 103)
18	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
19	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
20	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 20)

1.60 ms
(23.51%)

SELECT t0.id AS id_1, t0.webshop_type AS webshop_type_2, t0.is_kpi AS is_kpi_3, t0.url_kpi AS url_kpi_4, t0.name_kpi AS name_kpi_5, t0.user_count AS user_count_6 FROM admin_parameters t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.webshop_type AS webshop_type_2,
  t0.is_kpi AS is_kpi_3,
  t0.url_kpi AS url_kpi_4,
  t0.name_kpi AS name_kpi_5,
  t0.user_count AS user_count_6
FROM
  admin_parameters t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.webshop_type AS webshop_type_2, t0.is_kpi AS is_kpi_3, t0.url_kpi AS url_kpi_4, t0.name_kpi AS name_kpi_5, t0.user_count AS user_count_6 FROM admin_parameters t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 27)
6	App\Security\Voter\DeliveryAddressVoter->__construct (line 43)
7	ContainerRxFg0j1\getDeliveryAddressVoterService::do (line 707)
8	ContainerRxFg0j1\App_KernelDevDebugContainer->load (line 2010)
9	ContainerRxFg0j1\App_KernelDevDebugContainer::ContainerRxFg0j1\{closure} (line 131)
10	Symfony\Bundle\SecurityBundle\DataCollector\SecurityDataCollector->collect (line 158)
11	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 102)
12	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
17	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 20)

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\Order	No errors.
App\Entity\User	No errors.
App\Entity\OrderMovement	No errors.
App\Entity\AdminParameters	No errors.

Symfony Profiler

GET https://test.bivteam.shop/adminApi/orders?isArchived=1&isSaved=0

Configuration Settings

Theme