Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

10.26 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

7.72 ms

SELECT o0_.id AS id_0, o0_.date AS date_1, o0_.amount AS amount_2, o0_.comment AS comment_3, o0_.is_validated AS is_validated_4, o0_.is_saved AS is_saved_5, o0_.is_archived AS is_archived_6, o0_.order_number AS order_number_7, o0_.delivery_date AS delivery_date_8, o0_.admin_comment AS admin_comment_9, o0_.shipping_costs AS shipping_costs_10, o0_.customer_admin AS customer_admin_11, o0_.delivery_address AS delivery_address_12, o0_.is_delivery AS is_delivery_13, o0_.is_bank_transfer AS is_bank_transfer_14, o0_.amount_hvat AS amount_hvat_15, o0_.payment_id AS payment_id_16, o0_.payment_status AS payment_status_17, o1_.id AS id_18, o1_.quantity AS quantity_19, o1_.amount AS amount_20, o1_.article_array AS article_array_21, o1_.weight AS weight_22, o1_.total_weight AS total_weight_23, o1_.right_price_unit AS right_price_unit_24, o1_.right_price_unit_hvat AS right_price_unit_hvat_25, o1_.comment AS comment_26, u2_.id AS id_27, u2_.email AS email_28, u2_.roles AS roles_29, u2_.password AS password_30, u2_.lastname AS lastname_31, u2_.firstname AS firstname_32, u2_.is_active AS is_active_33, u2_.lang AS lang_34, u2_.is_new AS is_new_35, u2_.customer_id AS customer_id_36, u2_.delivery_address_id AS delivery_address_id_37, u2_.customer_name AS customer_name_38, u2_.password_request AS password_request_39, u2_.is_shipping_cost AS is_shipping_cost_40, u2_.min_order AS min_order_41, u2_.shipping_costs AS shipping_costs_42, u2_.global_discount AS global_discount_43, u2_.is_web AS is_web_44, u2_.vat AS vat_45, u2_.phone AS phone_46, u2_.street AS street_47, u2_.postal_code AS postal_code_48, u2_.city AS city_49, u2_.country AS country_50, u2_.saved AS saved_51, u2_.payment_type AS payment_type_52, u2_.agree_terms_date AS agree_terms_date_53, u2_.admin_customer AS admin_customer_54, o0_.user_id AS user_id_55, o1_.command_id AS command_id_56 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_validated AS is_validated_4,
  o0_.is_saved AS is_saved_5,
  o0_.is_archived AS is_archived_6,
  o0_.order_number AS order_number_7,
  o0_.delivery_date AS delivery_date_8,
  o0_.admin_comment AS admin_comment_9,
  o0_.shipping_costs AS shipping_costs_10,
  o0_.customer_admin AS customer_admin_11,
  o0_.delivery_address AS delivery_address_12,
  o0_.is_delivery AS is_delivery_13,
  o0_.is_bank_transfer AS is_bank_transfer_14,
  o0_.amount_hvat AS amount_hvat_15,
  o0_.payment_id AS payment_id_16,
  o0_.payment_status AS payment_status_17,
  o1_.id AS id_18,
  o1_.quantity AS quantity_19,
  o1_.amount AS amount_20,
  o1_.article_array AS article_array_21,
  o1_.weight AS weight_22,
  o1_.total_weight AS total_weight_23,
  o1_.right_price_unit AS right_price_unit_24,
  o1_.right_price_unit_hvat AS right_price_unit_hvat_25,
  o1_.comment AS comment_26,
  u2_.id AS id_27,
  u2_.email AS email_28,
  u2_.roles AS roles_29,
  u2_.password AS password_30,
  u2_.lastname AS lastname_31,
  u2_.firstname AS firstname_32,
  u2_.is_active AS is_active_33,
  u2_.lang AS lang_34,
  u2_.is_new AS is_new_35,
  u2_.customer_id AS customer_id_36,
  u2_.delivery_address_id AS delivery_address_id_37,
  u2_.customer_name AS customer_name_38,
  u2_.password_request AS password_request_39,
  u2_.is_shipping_cost AS is_shipping_cost_40,
  u2_.min_order AS min_order_41,
  u2_.shipping_costs AS shipping_costs_42,
  u2_.global_discount AS global_discount_43,
  u2_.is_web AS is_web_44,
  u2_.vat AS vat_45,
  u2_.phone AS phone_46,
  u2_.street AS street_47,
  u2_.postal_code AS postal_code_48,
  u2_.city AS city_49,
  u2_.country AS country_50,
  u2_.saved AS saved_51,
  u2_.payment_type AS payment_type_52,
  u2_.agree_terms_date AS agree_terms_date_53,
  u2_.admin_customer AS admin_customer_54,
  o0_.user_id AS user_id_55,
  o1_.command_id AS command_id_56
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_validated AS is_validated_4, o0_.is_saved AS is_saved_5, o0_.is_archived AS is_archived_6, o0_.order_number AS order_number_7, o0_.delivery_date AS delivery_date_8, o0_.admin_comment AS admin_comment_9, o0_.shipping_costs AS shipping_costs_10, o0_.customer_admin AS customer_admin_11, o0_.delivery_address AS delivery_address_12, o0_.is_delivery AS is_delivery_13, o0_.is_bank_transfer AS is_bank_transfer_14, o0_.amount_hvat AS amount_hvat_15, o0_.payment_id AS payment_id_16, o0_.payment_status AS payment_status_17, o1_.id AS id_18, o1_.quantity AS quantity_19, o1_.amount AS amount_20, o1_.article_array AS article_array_21, o1_.weight AS weight_22, o1_.total_weight AS total_weight_23, o1_.right_price_unit AS right_price_unit_24, o1_.right_price_unit_hvat AS right_price_unit_hvat_25, o1_.comment AS comment_26, u2_.id AS id_27, u2_.email AS email_28, u2_.roles AS roles_29, u2_.password AS password_30, u2_.lastname AS lastname_31, u2_.firstname AS firstname_32, u2_.is_active AS is_active_33, u2_.lang AS lang_34, u2_.is_new AS is_new_35, u2_.customer_id AS customer_id_36, u2_.delivery_address_id AS delivery_address_id_37, u2_.customer_name AS customer_name_38, u2_.password_request AS password_request_39, u2_.is_shipping_cost AS is_shipping_cost_40, u2_.min_order AS min_order_41, u2_.shipping_costs AS shipping_costs_42, u2_.global_discount AS global_discount_43, u2_.is_web AS is_web_44, u2_.vat AS vat_45, u2_.phone AS phone_46, u2_.street AS street_47, u2_.postal_code AS postal_code_48, u2_.city AS city_49, u2_.country AS country_50, u2_.saved AS saved_51, u2_.payment_type AS payment_type_52, u2_.agree_terms_date AS agree_terms_date_53, u2_.admin_customer AS admin_customer_54, o0_.user_id AS user_id_55, o1_.command_id AS command_id_56 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)

2.54 ms

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