Symfony Profiler

Query Metrics

17 Database Queries

11 Different statements

106.15 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

21.93 ms
(20.66%)

SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.created_at AS created_at_2, c0_.qty AS qty_3, c0_.price AS price_4, c0_.description AS description_5, c0_.is_ready AS is_ready_6, c0_.preparation_at AS preparation_at_7, c0_.separate_at AS separate_at_8, c0_.product_id AS product_id_9, c0_.store_order_id AS store_order_id_10, c0_.order_line_id AS order_line_id_11, c0_.partial_line_track_id AS partial_line_track_id_12 FROM crossdocking c0_ WHERE c0_.is_ready = 0 AND c0_.preparation_at IS NOT NULL AND c0_.separate_at IS NULL AND c0_.order_line_id IS NOT NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.created AS created_1,
  c0_.created_at AS created_at_2,
  c0_.qty AS qty_3,
  c0_.price AS price_4,
  c0_.description AS description_5,
  c0_.is_ready AS is_ready_6,
  c0_.preparation_at AS preparation_at_7,
  c0_.separate_at AS separate_at_8,
  c0_.product_id AS product_id_9,
  c0_.store_order_id AS store_order_id_10,
  c0_.order_line_id AS order_line_id_11,
  c0_.partial_line_track_id AS partial_line_track_id_12
FROM
  crossdocking c0_
WHERE
  c0_.is_ready = 0
  AND c0_.preparation_at IS NOT NULL
  AND c0_.separate_at IS NULL
  AND c0_.order_line_id IS NOT NULL

SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.created_at AS created_at_2, c0_.qty AS qty_3, c0_.price AS price_4, c0_.description AS description_5, c0_.is_ready AS is_ready_6, c0_.preparation_at AS preparation_at_7, c0_.separate_at AS separate_at_8, c0_.product_id AS product_id_9, c0_.store_order_id AS store_order_id_10, c0_.order_line_id AS order_line_id_11, c0_.partial_line_track_id AS partial_line_track_id_12 FROM crossdocking c0_ WHERE c0_.is_ready = 0 AND c0_.preparation_at IS NOT NULL AND c0_.separate_at IS NULL AND c0_.order_line_id IS NOT NULL;

#	File/Call
1	Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query (line 1101)
2	Doctrine\DBAL\Connection->executeQuery (line 33)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 67)
8	App\Repository\CrossdockingRepository->getToPreparare (line 38)
9	App\Services\AlertGlobalService->getTotalCrossDockingToPrepare (line 1635)
10	twig_get_attribute (line 121)
11	__TwigTemplate_77d532543e6ba36e14749c062f06998c->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 45)
14	__TwigTemplate_63f879612eecd4877a36efb309878046->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 175)
17	__TwigTemplate_47695ff902191dc220be494ffd0c2744->block_body (line 171)
18	Twig\Template->displayBlock (line 85)
19	__TwigTemplate_47695ff902191dc220be494ffd0c2744->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 50)
22	__TwigTemplate_1dfdbff8f695e67350618730c6152ace->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 379)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 280)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
31	App\Controller\Fulfillment\ProductController->index (line 178)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

21.17 ms
(19.94%)

SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.created_at AS created_at_2, c0_.qty AS qty_3, c0_.price AS price_4, c0_.description AS description_5, c0_.is_ready AS is_ready_6, c0_.preparation_at AS preparation_at_7, c0_.separate_at AS separate_at_8, c0_.product_id AS product_id_9, c0_.store_order_id AS store_order_id_10, c0_.order_line_id AS order_line_id_11, c0_.partial_line_track_id AS partial_line_track_id_12 FROM crossdocking c0_ WHERE c0_.is_ready = 0 AND c0_.order_line_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.created AS created_1,
  c0_.created_at AS created_at_2,
  c0_.qty AS qty_3,
  c0_.price AS price_4,
  c0_.description AS description_5,
  c0_.is_ready AS is_ready_6,
  c0_.preparation_at AS preparation_at_7,
  c0_.separate_at AS separate_at_8,
  c0_.product_id AS product_id_9,
  c0_.store_order_id AS store_order_id_10,
  c0_.order_line_id AS order_line_id_11,
  c0_.partial_line_track_id AS partial_line_track_id_12
FROM
  crossdocking c0_
WHERE
  c0_.is_ready = 0
  AND c0_.order_line_id IS NULL

SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.created_at AS created_at_2, c0_.qty AS qty_3, c0_.price AS price_4, c0_.description AS description_5, c0_.is_ready AS is_ready_6, c0_.preparation_at AS preparation_at_7, c0_.separate_at AS separate_at_8, c0_.product_id AS product_id_9, c0_.store_order_id AS store_order_id_10, c0_.order_line_id AS order_line_id_11, c0_.partial_line_track_id AS partial_line_track_id_12 FROM crossdocking c0_ WHERE c0_.is_ready = 0 AND c0_.order_line_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query (line 1101)
2	Doctrine\DBAL\Connection->executeQuery (line 33)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 56)
8	App\Repository\CrossdockingRepository->getToStorage (line 33)
9	App\Services\AlertGlobalService->getTotalCrossDockingNotReadyToStorage (line 1635)
10	twig_get_attribute (line 108)
11	__TwigTemplate_77d532543e6ba36e14749c062f06998c->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 45)
14	__TwigTemplate_63f879612eecd4877a36efb309878046->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 175)
17	__TwigTemplate_47695ff902191dc220be494ffd0c2744->block_body (line 171)
18	Twig\Template->displayBlock (line 85)
19	__TwigTemplate_47695ff902191dc220be494ffd0c2744->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 50)
22	__TwigTemplate_1dfdbff8f695e67350618730c6152ace->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 379)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 280)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
31	App\Controller\Fulfillment\ProductController->index (line 178)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

20.17 ms
(19.00%)

SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.created_at AS created_at_2, c0_.qty AS qty_3, c0_.price AS price_4, c0_.description AS description_5, c0_.is_ready AS is_ready_6, c0_.preparation_at AS preparation_at_7, c0_.separate_at AS separate_at_8, c0_.product_id AS product_id_9, c0_.store_order_id AS store_order_id_10, c0_.order_line_id AS order_line_id_11, c0_.partial_line_track_id AS partial_line_track_id_12 FROM crossdocking c0_ WHERE c0_.order_line_id IS NOT NULL AND c0_.is_ready = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.created AS created_1,
  c0_.created_at AS created_at_2,
  c0_.qty AS qty_3,
  c0_.price AS price_4,
  c0_.description AS description_5,
  c0_.is_ready AS is_ready_6,
  c0_.preparation_at AS preparation_at_7,
  c0_.separate_at AS separate_at_8,
  c0_.product_id AS product_id_9,
  c0_.store_order_id AS store_order_id_10,
  c0_.order_line_id AS order_line_id_11,
  c0_.partial_line_track_id AS partial_line_track_id_12
FROM
  crossdocking c0_
WHERE
  c0_.order_line_id IS NOT NULL
  AND c0_.is_ready = 0

SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.created_at AS created_at_2, c0_.qty AS qty_3, c0_.price AS price_4, c0_.description AS description_5, c0_.is_ready AS is_ready_6, c0_.preparation_at AS preparation_at_7, c0_.separate_at AS separate_at_8, c0_.product_id AS product_id_9, c0_.store_order_id AS store_order_id_10, c0_.order_line_id AS order_line_id_11, c0_.partial_line_track_id AS partial_line_track_id_12 FROM crossdocking c0_ WHERE c0_.order_line_id IS NOT NULL AND c0_.is_ready = 0;

#	File/Call
1	Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query (line 1101)
2	Doctrine\DBAL\Connection->executeQuery (line 33)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 901)
7	Doctrine\ORM\AbstractQuery->getResult (line 76)
8	App\Repository\CrossdockingRepository->getNoReady (line 28)
9	App\Services\AlertGlobalService->getTotalCrossDockingNotReady (line 1635)
10	twig_get_attribute (line 95)
11	__TwigTemplate_77d532543e6ba36e14749c062f06998c->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 45)
14	__TwigTemplate_63f879612eecd4877a36efb309878046->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 175)
17	__TwigTemplate_47695ff902191dc220be494ffd0c2744->block_body (line 171)
18	Twig\Template->displayBlock (line 85)
19	__TwigTemplate_47695ff902191dc220be494ffd0c2744->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 50)
22	__TwigTemplate_1dfdbff8f695e67350618730c6152ace->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 379)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 280)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
31	App\Controller\Fulfillment\ProductController->index (line 178)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

19.10 ms
(18.00%)

SELECT o0_.id AS id_0, o0_.external_market_id AS external_market_id_1, o0_.external_ship_id AS external_ship_id_2, o0_.imported_at AS imported_at_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5, o0_.shipped_at AS shipped_at_6, o0_.error_on AS error_on_7, o0_.finished_at AS finished_at_8, o0_.canceled_at AS canceled_at_9, o0_.ship_from_name AS ship_from_name_10, o0_.ship_from_vat AS ship_from_vat_11, o0_.ship_from_phone AS ship_from_phone_12, o0_.ship_from_address AS ship_from_address_13, o0_.ship_from_zip_code AS ship_from_zip_code_14, o0_.ship_from_city AS ship_from_city_15, o0_.ship_from_country AS ship_from_country_16, o0_.ship_to_name AS ship_to_name_17, o0_.ship_to_vat AS ship_to_vat_18, o0_.ship_to_email AS ship_to_email_19, o0_.ship_to_phone AS ship_to_phone_20, o0_.ship_to_address AS ship_to_address_21, o0_.ship_to_zip_code AS ship_to_zip_code_22, o0_.ship_to_city AS ship_to_city_23, o0_.ship_to_country AS ship_to_country_24, o0_.volumes AS volumes_25, o0_.weight AS weight_26, o0_.refund AS refund_27, o0_.refund_value AS refund_value_28, o0_.back AS back_29, o0_.internal_reference AS internal_reference_30, o0_.obs AS obs_31, o0_.response_market AS response_market_32, o0_.total_price AS total_price_33, o0_.shipping_cost AS shipping_cost_34, o0_.deleted_at AS deleted_at_35, o0_.is_refund_received AS is_refund_received_36, o0_.shipping_description AS shipping_description_37, o0_.issuet_at AS issuet_at_38, o0_.completed_at AS completed_at_39, o0_.error_on_issue AS error_on_issue_40, o0_.is_gift AS is_gift_41, o0_.refund_received_at AS refund_received_at_42, o0_.external_ship_cost AS external_ship_cost_43, o0_.discount_value AS discount_value_44, o0_.store_id AS store_id_45, o0_.ship_provider_id AS ship_provider_id_46, o0_.market_store_id AS market_store_id_47, o0_.status_id AS status_id_48, o0_.store_ship_provider_id AS store_ship_provider_id_49, o0_.created_by_id AS created_by_id_50, o0_.ship_provider_status_id AS ship_provider_status_id_51 FROM `order` o0_ INNER JOIN order_line o1_ ON o0_.id = o1_.store_order_id INNER JOIN partial_line_track p2_ ON o1_.id = p2_.order_line_id WHERE o0_.status_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.external_market_id AS external_market_id_1,
  o0_.external_ship_id AS external_ship_id_2,
  o0_.imported_at AS imported_at_3,
  o0_.created_at AS created_at_4,
  o0_.updated_at AS updated_at_5,
  o0_.shipped_at AS shipped_at_6,
  o0_.error_on AS error_on_7,
  o0_.finished_at AS finished_at_8,
  o0_.canceled_at AS canceled_at_9,
  o0_.ship_from_name AS ship_from_name_10,
  o0_.ship_from_vat AS ship_from_vat_11,
  o0_.ship_from_phone AS ship_from_phone_12,
  o0_.ship_from_address AS ship_from_address_13,
  o0_.ship_from_zip_code AS ship_from_zip_code_14,
  o0_.ship_from_city AS ship_from_city_15,
  o0_.ship_from_country AS ship_from_country_16,
  o0_.ship_to_name AS ship_to_name_17,
  o0_.ship_to_vat AS ship_to_vat_18,
  o0_.ship_to_email AS ship_to_email_19,
  o0_.ship_to_phone AS ship_to_phone_20,
  o0_.ship_to_address AS ship_to_address_21,
  o0_.ship_to_zip_code AS ship_to_zip_code_22,
  o0_.ship_to_city AS ship_to_city_23,
  o0_.ship_to_country AS ship_to_country_24,
  o0_.volumes AS volumes_25,
  o0_.weight AS weight_26,
  o0_.refund AS refund_27,
  o0_.refund_value AS refund_value_28,
  o0_.back AS back_29,
  o0_.internal_reference AS internal_reference_30,
  o0_.obs AS obs_31,
  o0_.response_market AS response_market_32,
  o0_.total_price AS total_price_33,
  o0_.shipping_cost AS shipping_cost_34,
  o0_.deleted_at AS deleted_at_35,
  o0_.is_refund_received AS is_refund_received_36,
  o0_.shipping_description AS shipping_description_37,
  o0_.issuet_at AS issuet_at_38,
  o0_.completed_at AS completed_at_39,
  o0_.error_on_issue AS error_on_issue_40,
  o0_.is_gift AS is_gift_41,
  o0_.refund_received_at AS refund_received_at_42,
  o0_.external_ship_cost AS external_ship_cost_43,
  o0_.discount_value AS discount_value_44,
  o0_.store_id AS store_id_45,
  o0_.ship_provider_id AS ship_provider_id_46,
  o0_.market_store_id AS market_store_id_47,
  o0_.status_id AS status_id_48,
  o0_.store_ship_provider_id AS store_ship_provider_id_49,
  o0_.created_by_id AS created_by_id_50,
  o0_.ship_provider_status_id AS ship_provider_status_id_51
FROM
  `order` o0_
  INNER JOIN order_line o1_ ON o0_.id = o1_.store_order_id
  INNER JOIN partial_line_track p2_ ON o1_.id = p2_.order_line_id
WHERE
  o0_.status_id = ?

SELECT o0_.id AS id_0, o0_.external_market_id AS external_market_id_1, o0_.external_ship_id AS external_ship_id_2, o0_.imported_at AS imported_at_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5, o0_.shipped_at AS shipped_at_6, o0_.error_on AS error_on_7, o0_.finished_at AS finished_at_8, o0_.canceled_at AS canceled_at_9, o0_.ship_from_name AS ship_from_name_10, o0_.ship_from_vat AS ship_from_vat_11, o0_.ship_from_phone AS ship_from_phone_12, o0_.ship_from_address AS ship_from_address_13, o0_.ship_from_zip_code AS ship_from_zip_code_14, o0_.ship_from_city AS ship_from_city_15, o0_.ship_from_country AS ship_from_country_16, o0_.ship_to_name AS ship_to_name_17, o0_.ship_to_vat AS ship_to_vat_18, o0_.ship_to_email AS ship_to_email_19, o0_.ship_to_phone AS ship_to_phone_20, o0_.ship_to_address AS ship_to_address_21, o0_.ship_to_zip_code AS ship_to_zip_code_22, o0_.ship_to_city AS ship_to_city_23, o0_.ship_to_country AS ship_to_country_24, o0_.volumes AS volumes_25, o0_.weight AS weight_26, o0_.refund AS refund_27, o0_.refund_value AS refund_value_28, o0_.back AS back_29, o0_.internal_reference AS internal_reference_30, o0_.obs AS obs_31, o0_.response_market AS response_market_32, o0_.total_price AS total_price_33, o0_.shipping_cost AS shipping_cost_34, o0_.deleted_at AS deleted_at_35, o0_.is_refund_received AS is_refund_received_36, o0_.shipping_description AS shipping_description_37, o0_.issuet_at AS issuet_at_38, o0_.completed_at AS completed_at_39, o0_.error_on_issue AS error_on_issue_40, o0_.is_gift AS is_gift_41, o0_.refund_received_at AS refund_received_at_42, o0_.external_ship_cost AS external_ship_cost_43, o0_.discount_value AS discount_value_44, o0_.store_id AS store_id_45, o0_.ship_provider_id AS ship_provider_id_46, o0_.market_store_id AS market_store_id_47, o0_.status_id AS status_id_48, o0_.store_ship_provider_id AS store_ship_provider_id_49, o0_.created_by_id AS created_by_id_50, o0_.ship_provider_status_id AS ship_provider_status_id_51 FROM `order` o0_ INNER JOIN order_line o1_ ON o0_.id = o1_.store_order_id INNER JOIN partial_line_track p2_ ON o1_.id = p2_.order_line_id WHERE o0_.status_id = 3;

#	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 102)
7	App\Repository\OrderRepository->getOrdersAcceptedWithPartialTracks (line 50)
8	App\Services\AlertGlobalService->getTotalOrdersAcceptedPartial (line 1635)
9	twig_get_attribute (line 134)
10	__TwigTemplate_77d532543e6ba36e14749c062f06998c->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 45)
13	__TwigTemplate_63f879612eecd4877a36efb309878046->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 175)
16	__TwigTemplate_47695ff902191dc220be494ffd0c2744->block_body (line 171)
17	Twig\Template->displayBlock (line 85)
18	__TwigTemplate_47695ff902191dc220be494ffd0c2744->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 50)
21	__TwigTemplate_1dfdbff8f695e67350618730c6152ace->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 379)
24	Twig\Template->render (line 38)
25	Twig\TemplateWrapper->render (line 280)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
30	App\Controller\Fulfillment\ProductController->index (line 178)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

17.68 ms
(16.66%)

SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.issuet_at IS NOT NULL AND o0_.completed_at IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  `order` o0_
WHERE
  o0_.issuet_at IS NOT NULL
  AND o0_.completed_at IS NULL

SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.issuet_at IS NOT NULL AND o0_.completed_at IS NULL;

#	File/Call
1	Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query (line 1101)
2	Doctrine\DBAL\Connection->executeQuery (line 33)
3	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
4	Doctrine\ORM\Query->_doExecute (line 1212)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
6	Doctrine\ORM\AbstractQuery->execute (line 991)
7	Doctrine\ORM\AbstractQuery->getSingleResult (line 1020)
8	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 73)
9	App\Repository\OrderRepository->getTotalOrdersToComplete (line 62)
10	App\Services\AlertGlobalService->getTotalOrdersToComplete (line 1635)
11	twig_get_attribute (line 179)
12	__TwigTemplate_77d532543e6ba36e14749c062f06998c->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 45)
15	__TwigTemplate_63f879612eecd4877a36efb309878046->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 175)
18	__TwigTemplate_47695ff902191dc220be494ffd0c2744->block_body (line 171)
19	Twig\Template->displayBlock (line 85)
20	__TwigTemplate_47695ff902191dc220be494ffd0c2744->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 50)
23	__TwigTemplate_1dfdbff8f695e67350618730c6152ace->doDisplay (line 394)
24	Twig\Template->displayWithErrorHandling (line 367)
25	Twig\Template->display (line 379)
26	Twig\Template->render (line 38)
27	Twig\TemplateWrapper->render (line 280)
28	Twig\Environment->render (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
32	App\Controller\Fulfillment\ProductController->index (line 178)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

2.23 ms
(2.11%)

SELECT o0_.id AS id_0, o0_.external_market_id AS external_market_id_1, o0_.external_ship_id AS external_ship_id_2, o0_.imported_at AS imported_at_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5, o0_.shipped_at AS shipped_at_6, o0_.error_on AS error_on_7, o0_.finished_at AS finished_at_8, o0_.canceled_at AS canceled_at_9, o0_.ship_from_name AS ship_from_name_10, o0_.ship_from_vat AS ship_from_vat_11, o0_.ship_from_phone AS ship_from_phone_12, o0_.ship_from_address AS ship_from_address_13, o0_.ship_from_zip_code AS ship_from_zip_code_14, o0_.ship_from_city AS ship_from_city_15, o0_.ship_from_country AS ship_from_country_16, o0_.ship_to_name AS ship_to_name_17, o0_.ship_to_vat AS ship_to_vat_18, o0_.ship_to_email AS ship_to_email_19, o0_.ship_to_phone AS ship_to_phone_20, o0_.ship_to_address AS ship_to_address_21, o0_.ship_to_zip_code AS ship_to_zip_code_22, o0_.ship_to_city AS ship_to_city_23, o0_.ship_to_country AS ship_to_country_24, o0_.volumes AS volumes_25, o0_.weight AS weight_26, o0_.refund AS refund_27, o0_.refund_value AS refund_value_28, o0_.back AS back_29, o0_.internal_reference AS internal_reference_30, o0_.obs AS obs_31, o0_.response_market AS response_market_32, o0_.total_price AS total_price_33, o0_.shipping_cost AS shipping_cost_34, o0_.deleted_at AS deleted_at_35, o0_.is_refund_received AS is_refund_received_36, o0_.shipping_description AS shipping_description_37, o0_.issuet_at AS issuet_at_38, o0_.completed_at AS completed_at_39, o0_.error_on_issue AS error_on_issue_40, o0_.is_gift AS is_gift_41, o0_.refund_received_at AS refund_received_at_42, o0_.external_ship_cost AS external_ship_cost_43, o0_.discount_value AS discount_value_44, o0_.store_id AS store_id_45, o0_.ship_provider_id AS ship_provider_id_46, o0_.market_store_id AS market_store_id_47, o0_.status_id AS status_id_48, o0_.store_ship_provider_id AS store_ship_provider_id_49, o0_.created_by_id AS created_by_id_50, o0_.ship_provider_status_id AS ship_provider_status_id_51 FROM `order` o0_ INNER JOIN STATUS s1_ ON o0_.status_id = s1_.id WHERE s1_.type LIKE ?

Parameters:

[
  "INC"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.external_market_id AS external_market_id_1,
  o0_.external_ship_id AS external_ship_id_2,
  o0_.imported_at AS imported_at_3,
  o0_.created_at AS created_at_4,
  o0_.updated_at AS updated_at_5,
  o0_.shipped_at AS shipped_at_6,
  o0_.error_on AS error_on_7,
  o0_.finished_at AS finished_at_8,
  o0_.canceled_at AS canceled_at_9,
  o0_.ship_from_name AS ship_from_name_10,
  o0_.ship_from_vat AS ship_from_vat_11,
  o0_.ship_from_phone AS ship_from_phone_12,
  o0_.ship_from_address AS ship_from_address_13,
  o0_.ship_from_zip_code AS ship_from_zip_code_14,
  o0_.ship_from_city AS ship_from_city_15,
  o0_.ship_from_country AS ship_from_country_16,
  o0_.ship_to_name AS ship_to_name_17,
  o0_.ship_to_vat AS ship_to_vat_18,
  o0_.ship_to_email AS ship_to_email_19,
  o0_.ship_to_phone AS ship_to_phone_20,
  o0_.ship_to_address AS ship_to_address_21,
  o0_.ship_to_zip_code AS ship_to_zip_code_22,
  o0_.ship_to_city AS ship_to_city_23,
  o0_.ship_to_country AS ship_to_country_24,
  o0_.volumes AS volumes_25,
  o0_.weight AS weight_26,
  o0_.refund AS refund_27,
  o0_.refund_value AS refund_value_28,
  o0_.back AS back_29,
  o0_.internal_reference AS internal_reference_30,
  o0_.obs AS obs_31,
  o0_.response_market AS response_market_32,
  o0_.total_price AS total_price_33,
  o0_.shipping_cost AS shipping_cost_34,
  o0_.deleted_at AS deleted_at_35,
  o0_.is_refund_received AS is_refund_received_36,
  o0_.shipping_description AS shipping_description_37,
  o0_.issuet_at AS issuet_at_38,
  o0_.completed_at AS completed_at_39,
  o0_.error_on_issue AS error_on_issue_40,
  o0_.is_gift AS is_gift_41,
  o0_.refund_received_at AS refund_received_at_42,
  o0_.external_ship_cost AS external_ship_cost_43,
  o0_.discount_value AS discount_value_44,
  o0_.store_id AS store_id_45,
  o0_.ship_provider_id AS ship_provider_id_46,
  o0_.market_store_id AS market_store_id_47,
  o0_.status_id AS status_id_48,
  o0_.store_ship_provider_id AS store_ship_provider_id_49,
  o0_.created_by_id AS created_by_id_50,
  o0_.ship_provider_status_id AS ship_provider_status_id_51
FROM
  `order` o0_
  INNER JOIN STATUS s1_ ON o0_.status_id = s1_.id
WHERE
  s1_.type LIKE ?

SELECT o0_.id AS id_0, o0_.external_market_id AS external_market_id_1, o0_.external_ship_id AS external_ship_id_2, o0_.imported_at AS imported_at_3, o0_.created_at AS created_at_4, o0_.updated_at AS updated_at_5, o0_.shipped_at AS shipped_at_6, o0_.error_on AS error_on_7, o0_.finished_at AS finished_at_8, o0_.canceled_at AS canceled_at_9, o0_.ship_from_name AS ship_from_name_10, o0_.ship_from_vat AS ship_from_vat_11, o0_.ship_from_phone AS ship_from_phone_12, o0_.ship_from_address AS ship_from_address_13, o0_.ship_from_zip_code AS ship_from_zip_code_14, o0_.ship_from_city AS ship_from_city_15, o0_.ship_from_country AS ship_from_country_16, o0_.ship_to_name AS ship_to_name_17, o0_.ship_to_vat AS ship_to_vat_18, o0_.ship_to_email AS ship_to_email_19, o0_.ship_to_phone AS ship_to_phone_20, o0_.ship_to_address AS ship_to_address_21, o0_.ship_to_zip_code AS ship_to_zip_code_22, o0_.ship_to_city AS ship_to_city_23, o0_.ship_to_country AS ship_to_country_24, o0_.volumes AS volumes_25, o0_.weight AS weight_26, o0_.refund AS refund_27, o0_.refund_value AS refund_value_28, o0_.back AS back_29, o0_.internal_reference AS internal_reference_30, o0_.obs AS obs_31, o0_.response_market AS response_market_32, o0_.total_price AS total_price_33, o0_.shipping_cost AS shipping_cost_34, o0_.deleted_at AS deleted_at_35, o0_.is_refund_received AS is_refund_received_36, o0_.shipping_description AS shipping_description_37, o0_.issuet_at AS issuet_at_38, o0_.completed_at AS completed_at_39, o0_.error_on_issue AS error_on_issue_40, o0_.is_gift AS is_gift_41, o0_.refund_received_at AS refund_received_at_42, o0_.external_ship_cost AS external_ship_cost_43, o0_.discount_value AS discount_value_44, o0_.store_id AS store_id_45, o0_.ship_provider_id AS ship_provider_id_46, o0_.market_store_id AS market_store_id_47, o0_.status_id AS status_id_48, o0_.store_ship_provider_id AS store_ship_provider_id_49, o0_.created_by_id AS created_by_id_50, o0_.ship_provider_status_id AS ship_provider_status_id_51 FROM `order` o0_ INNER JOIN STATUS s1_ ON o0_.status_id = s1_.id WHERE s1_.type LIKE 'INC';

#	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 254)
7	App\Repository\OrderRepository->getOrderInc (line 68)
8	App\Services\AlertGlobalService->getOrderWithInc (line 1635)
9	twig_get_attribute (line 545)
10	__TwigTemplate_62a518ab6d72eb97dd9b71eb84b22abf->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 43)
13	__TwigTemplate_63f879612eecd4877a36efb309878046->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 175)
16	__TwigTemplate_47695ff902191dc220be494ffd0c2744->block_body (line 171)
17	Twig\Template->displayBlock (line 85)
18	__TwigTemplate_47695ff902191dc220be494ffd0c2744->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 50)
21	__TwigTemplate_1dfdbff8f695e67350618730c6152ace->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 379)
24	Twig\Template->render (line 38)
25	Twig\TemplateWrapper->render (line 280)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
30	App\Controller\Fulfillment\ProductController->index (line 178)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

1.06 ms
(1.00%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.90 ms
(0.85%)

SELECT t0.id AS id_1, t0.obs AS obs_2, t0.created_at AS created_at_3, t0.tracking_at AS tracking_at_4, t0.store_order_id AS store_order_id_5, t0.ship_provider_status_id AS ship_provider_status_id_6 FROM order_ship_provider_status t0 WHERE t0.store_order_id = ? ORDER BY t0.tracking_at DESC

Parameters:

[
  7247
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.obs AS obs_2,
  t0.created_at AS created_at_3,
  t0.tracking_at AS tracking_at_4,
  t0.store_order_id AS store_order_id_5,
  t0.ship_provider_status_id AS ship_provider_status_id_6
FROM
  order_ship_provider_status t0
WHERE
  t0.store_order_id = ?
ORDER BY
  t0.tracking_at DESC

SELECT t0.id AS id_1, t0.obs AS obs_2, t0.created_at AS created_at_3, t0.tracking_at AS tracking_at_4, t0.store_order_id AS store_order_id_5, t0.ship_provider_status_id AS ship_provider_status_id_6 FROM order_ship_provider_status t0 WHERE t0.store_order_id = 7247 ORDER BY t0.tracking_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3286)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 711)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 167)
7	Doctrine\Common\Collections\AbstractLazyCollection->first (line 943)
8	App\Entity\Order->getOrderShippingTrackingsDescTrackingsAt (line 1635)
9	twig_get_attribute (line 590)
10	__TwigTemplate_62a518ab6d72eb97dd9b71eb84b22abf->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 43)
13	__TwigTemplate_63f879612eecd4877a36efb309878046->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 175)
16	__TwigTemplate_47695ff902191dc220be494ffd0c2744->block_body (line 171)
17	Twig\Template->displayBlock (line 85)
18	__TwigTemplate_47695ff902191dc220be494ffd0c2744->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 50)
21	__TwigTemplate_1dfdbff8f695e67350618730c6152ace->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 379)
24	Twig\Template->render (line 38)
25	Twig\TemplateWrapper->render (line 280)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
30	App\Controller\Fulfillment\ProductController->index (line 178)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.88 ms
(0.83%)

SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.status_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  `order` o0_
WHERE
  o0_.status_id = ?

SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.status_id = 3;

#	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 991)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1020)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 63)
8	App\Repository\OrderRepository->getTotalOrdersByStatus (line 43)
9	App\Services\AlertGlobalService->getTotalOrdersAccepted (line 1635)
10	twig_get_attribute (line 65)
11	__TwigTemplate_77d532543e6ba36e14749c062f06998c->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 45)
14	__TwigTemplate_63f879612eecd4877a36efb309878046->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 175)
17	__TwigTemplate_47695ff902191dc220be494ffd0c2744->block_body (line 171)
18	Twig\Template->displayBlock (line 85)
19	__TwigTemplate_47695ff902191dc220be494ffd0c2744->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 50)
22	__TwigTemplate_1dfdbff8f695e67350618730c6152ace->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 379)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 280)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
31	App\Controller\Fulfillment\ProductController->index (line 178)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

0.62 ms
(0.58%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.logosmall AS logosmall_4, t0.icon AS icon_5, t0.favicon AS favicon_6, t0.is_cross_docking AS is_cross_docking_7 FROM settings t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.logo AS logo_3,
  t0.logosmall AS logosmall_4,
  t0.icon AS icon_5,
  t0.favicon AS favicon_6,
  t0.is_cross_docking AS is_cross_docking_7
FROM
  settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.logosmall AS logosmall_4, t0.icon AS icon_5, t0.favicon AS favicon_6, t0.is_cross_docking AS is_cross_docking_7 FROM settings t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 20)
6	App\Services\SettingService->setSettings (line 25)
7	App\Services\SettingService->getNamePrim (line 1635)
8	twig_get_attribute (line 58)
9	__TwigTemplate_47695ff902191dc220be494ffd0c2744->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 50)
12	__TwigTemplate_1dfdbff8f695e67350618730c6152ace->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 379)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 280)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
21	App\Controller\Fulfillment\ProductController->index (line 178)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.40 ms
(0.38%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_final AS is_final_3, t0.type AS type_4, t0.is_notification AS is_notification_5 FROM STATUS t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_final AS is_final_3,
  t0.type AS type_4,
  t0.is_notification AS is_notification_5
FROM
  STATUS t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_final AS is_final_3, t0.type AS type_4, t0.is_notification AS is_notification_5 FROM STATUS t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 43)
6	App\Services\AlertGlobalService->getTotalOrdersAccepted (line 1635)
7	twig_get_attribute (line 65)
8	__TwigTemplate_77d532543e6ba36e14749c062f06998c->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 45)
11	__TwigTemplate_63f879612eecd4877a36efb309878046->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 175)
14	__TwigTemplate_47695ff902191dc220be494ffd0c2744->block_body (line 171)
15	Twig\Template->displayBlock (line 85)
16	__TwigTemplate_47695ff902191dc220be494ffd0c2744->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 50)
19	__TwigTemplate_1dfdbff8f695e67350618730c6152ace->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 379)
22	Twig\Template->render (line 38)
23	Twig\TemplateWrapper->render (line 280)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
28	App\Controller\Fulfillment\ProductController->index (line 178)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	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\User	No errors.
App\Entity\OrderStatus	No errors.
App\Entity\Order	No errors.
App\Entity\UserPreparationOrder	No errors.
App\Entity\LogScanning	No errors.
App\Entity\OrderInvoiceDoc	No errors.
App\Entity\LogDelete	No errors.
App\Entity\Settings	No errors.
App\Entity\Status	No errors.
App\Entity\Store	No errors.
App\Entity\ShipProvider	No errors.
App\Entity\MarketStore	No errors.
App\Entity\StoreShipProvider	No errors.
App\Entity\ShipProviderStatus	No errors.
App\Entity\OrderLine	The field 'App\Entity\OrderLine#discount' has the property type 'int' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\OrderShipProviderStatus	No errors.
App\Entity\Crossdocking	No errors.
App\Entity\OrderRma	No errors.
App\Entity\LogProduct	No errors.
App\Entity\SupplierInvoice	No errors.
App\Entity\Product	No errors.
App\Entity\PartialLineTrack	No errors.

Symfony Profiler

GET https://tudoestaqui.pt/fulfillment/product/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping