Symfony Profiler

Query Metrics

69 Database Queries

34 Different statements

168.49 ms Query time

25 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

143.09 ms
(84.93%)

SELECT t0.id AS id_1, t0.nb_scans AS nb_scans_2, t0.module AS module_3, t0.is_closed AS is_closed_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.nb_scans_per_minute AS nb_scans_per_minute_7, t0.nb_minutes AS nb_minutes_8, t0.user_id AS user_id_9, t0.po_id AS po_id_10, t0.scan_category_group_id AS scan_category_group_id_11, t0.user_group_id AS user_group_id_12 FROM scan_session t0 WHERE t0.is_closed = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nb_scans AS nb_scans_2,
  t0.module AS module_3,
  t0.is_closed AS is_closed_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.nb_scans_per_minute AS nb_scans_per_minute_7,
  t0.nb_minutes AS nb_minutes_8,
  t0.user_id AS user_id_9,
  t0.po_id AS po_id_10,
  t0.scan_category_group_id AS scan_category_group_id_11,
  t0.user_group_id AS user_group_id_12
FROM
  scan_session t0
WHERE
  t0.is_closed = ?

SELECT t0.id AS id_1, t0.nb_scans AS nb_scans_2, t0.module AS module_3, t0.is_closed AS is_closed_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.nb_scans_per_minute AS nb_scans_per_minute_7, t0.nb_minutes AS nb_minutes_8, t0.user_id AS user_id_9, t0.po_id AS po_id_10, t0.scan_category_group_id AS scan_category_group_id_11, t0.user_group_id AS user_group_id_12 FROM scan_session t0 WHERE t0.is_closed = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 89)
4	App\Services\ScanSessionService->manageClosing (line 129)
5	App\Services\ScanSessionService->getIndividualProductionPoData (line 85)
6	App\Services\ProductionIndividualPerformanceService->getData (line 254)
7	App\Controller\Triage\TriageScanController->individualPerformance (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 72)
15	__TwigTemplate_c76325c7257040165eeef9722c8d5ef1->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 99)
24	App\Controller\Triage\TriageScanController->_scan (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

6.45 ms
(3.83%)

SELECT s0_.id AS id_0, s0_.nb_scans AS nb_scans_1, s0_.module AS module_2, s0_.is_closed AS is_closed_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.nb_scans_per_minute AS nb_scans_per_minute_6, s0_.nb_minutes AS nb_minutes_7, s0_.user_id AS user_id_8, s0_.po_id AS po_id_9, s0_.scan_category_group_id AS scan_category_group_id_10, s0_.user_group_id AS user_group_id_11 FROM scan_session s0_ INNER JOIN po p1_ ON s0_.po_id = p1_.id WHERE s0_.nb_scans > 25 AND p1_.supplier_id = ? AND s0_.scan_category_group_id = ? AND s0_.user_id = ? AND s0_.created_at >= ? AND s0_.created_at <= ? ORDER BY s0_.id DESC

Parameters:

[
  28
  8
  96
  "2024-12-23 00:00:00"
  "2024-12-23 14:22:33"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.nb_scans AS nb_scans_1,
  s0_.module AS module_2,
  s0_.is_closed AS is_closed_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.nb_scans_per_minute AS nb_scans_per_minute_6,
  s0_.nb_minutes AS nb_minutes_7,
  s0_.user_id AS user_id_8,
  s0_.po_id AS po_id_9,
  s0_.scan_category_group_id AS scan_category_group_id_10,
  s0_.user_group_id AS user_group_id_11
FROM
  scan_session s0_
  INNER JOIN po p1_ ON s0_.po_id = p1_.id
WHERE
  s0_.nb_scans > 25
  AND p1_.supplier_id = ?
  AND s0_.scan_category_group_id = ?
  AND s0_.user_id = ?
  AND s0_.created_at >= ?
  AND s0_.created_at <= ?
ORDER BY
  s0_.id DESC

SELECT s0_.id AS id_0, s0_.nb_scans AS nb_scans_1, s0_.module AS module_2, s0_.is_closed AS is_closed_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.nb_scans_per_minute AS nb_scans_per_minute_6, s0_.nb_minutes AS nb_minutes_7, s0_.user_id AS user_id_8, s0_.po_id AS po_id_9, s0_.scan_category_group_id AS scan_category_group_id_10, s0_.user_group_id AS user_group_id_11 FROM scan_session s0_ INNER JOIN po p1_ ON s0_.po_id = p1_.id WHERE s0_.nb_scans > 25 AND p1_.supplier_id = 28 AND s0_.scan_category_group_id = 8 AND s0_.user_id = 96 AND s0_.created_at >= '2024-12-23 00:00:00' AND s0_.created_at <= '2024-12-23 14:22:33' ORDER BY s0_.id DESC;

#	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 137)
7	App\Repository\ScanSessionRepository->findIndividualData (line 131)
8	App\Services\ScanSessionService->getIndividualProductionPoData (line 85)
9	App\Services\ProductionIndividualPerformanceService->getData (line 254)
10	App\Controller\Triage\TriageScanController->individualPerformance (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 72)
18	__TwigTemplate_c76325c7257040165eeef9722c8d5ef1->doDisplay (line 393)
19	Twig\Template->yield (line 349)
20	Twig\Template->display (line 364)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 99)
27	App\Controller\Triage\TriageScanController->_scan (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

2.68 ms
(1.59%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 476)
3	Doctrine\ORM\UnitOfWork->commit (line 414)
4	Doctrine\ORM\EntityManager->flush (line 82)
5	App\Services\Lot\LotItemFactory->addOrCreate (line 352)
6	App\Services\Triage\TriageScanService->confirm (line 60)
7	App\Controller\Triage\TriageScanController->_scan (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

2.55 ms
(1.51%)

UPDATE lot_item_origin SET quantity = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  lot_item_origin
SET
  quantity = ?
WHERE
  id = ?

UPDATE lot_item_origin SET quantity = 2 WHERE id = 5077735;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1277)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 82)
7	App\Services\Lot\LotItemFactory->addOrCreate (line 352)
8	App\Services\Triage\TriageScanService->confirm (line 60)
9	App\Controller\Triage\TriageScanController->_scan (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

2.40 ms
(1.42%)

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = ?

Parameters:

[
  4061992
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.lot_item_id AS lot_item_id_3,
  t0.po_id AS po_id_4
FROM
  lot_item_origin t0
WHERE
  t0.lot_item_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.lot_item_id AS lot_item_id_3, t0.po_id AS po_id_4 FROM lot_item_origin t0 WHERE t0.lot_item_id = 4061992;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 237)
7	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 123)
8	App\Entity\LotItem->updateQuantity (line 46)
9	App\Services\Lot\LotItemFactory->addOrCreate (line 352)
10	App\Services\Triage\TriageScanService->confirm (line 60)
11	App\Controller\Triage\TriageScanController->_scan (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

2.14 ms
(1.27%)

SELECT t0.id AS id_1, t0.number AS number_2, t0.package_units AS package_units_3, t0.weight AS weight_4, t0.user AS user_5, t0.format AS format_6, t0.photos AS photos_7, t0.name AS name_8, t0.extended AS extended_9, t0.units AS units_10, t0.discount AS discount_11, t0.estimated_sales AS estimated_sales_12, t0.is_initialized AS is_initialized_13, t0.msrp_current AS msrp_current_14, t0.is_closed AS is_closed_15, t0.is_high_value AS is_high_value_16, t0.is_cp AS is_cp_17, t0.estimated_sales_min_target AS estimated_sales_min_target_18, t0.estimated_sales_max_target AS estimated_sales_max_target_19, t0.display_name AS display_name_20, t0.quantity AS quantity_21, t0.cp_quantity AS cp_quantity_22, t0.is_truckload AS is_truckload_23, t0.is_photos_compressed AS is_photos_compressed_24, t0.is_destroy AS is_destroy_25, t0.package_sizes AS package_sizes_26, t0.is_listing_done AS is_listing_done_27, t0.discount_triage AS discount_triage_28, t0.volumetric_weight AS volumetric_weight_29, t0.real_weight AS real_weight_30, t0.previous_number AS previous_number_31, t0.is_oversize AS is_oversize_32, t0.cost AS cost_33, t0.is_imported AS is_imported_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.po_id AS po_id_37, t0.category_id AS category_id_38, t0.cp_product_id AS cp_product_id_39, t0.product_condition_id AS product_condition_id_40, t0.merged_with_id AS merged_with_id_41, t0.preparation_lot_id AS preparation_lot_id_42, t0.previous_po_id AS previous_po_id_43, t0.related_front_product_id AS related_front_product_id_44 FROM lot t0 WHERE t0.number = ? AND t0.is_closed = ? AND t0.po_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.package_units AS package_units_3,
  t0.weight AS weight_4,
  t0.user AS user_5,
  t0.format AS format_6,
  t0.photos AS photos_7,
  t0.name AS name_8,
  t0.extended AS extended_9,
  t0.units AS units_10,
  t0.discount AS discount_11,
  t0.estimated_sales AS estimated_sales_12,
  t0.is_initialized AS is_initialized_13,
  t0.msrp_current AS msrp_current_14,
  t0.is_closed AS is_closed_15,
  t0.is_high_value AS is_high_value_16,
  t0.is_cp AS is_cp_17,
  t0.estimated_sales_min_target AS estimated_sales_min_target_18,
  t0.estimated_sales_max_target AS estimated_sales_max_target_19,
  t0.display_name AS display_name_20,
  t0.quantity AS quantity_21,
  t0.cp_quantity AS cp_quantity_22,
  t0.is_truckload AS is_truckload_23,
  t0.is_photos_compressed AS is_photos_compressed_24,
  t0.is_destroy AS is_destroy_25,
  t0.package_sizes AS package_sizes_26,
  t0.is_listing_done AS is_listing_done_27,
  t0.discount_triage AS discount_triage_28,
  t0.volumetric_weight AS volumetric_weight_29,
  t0.real_weight AS real_weight_30,
  t0.previous_number AS previous_number_31,
  t0.is_oversize AS is_oversize_32,
  t0.cost AS cost_33,
  t0.is_imported AS is_imported_34,
  t0.created_at AS created_at_35,
  t0.updated_at AS updated_at_36,
  t0.po_id AS po_id_37,
  t0.category_id AS category_id_38,
  t0.cp_product_id AS cp_product_id_39,
  t0.product_condition_id AS product_condition_id_40,
  t0.merged_with_id AS merged_with_id_41,
  t0.preparation_lot_id AS preparation_lot_id_42,
  t0.previous_po_id AS previous_po_id_43,
  t0.related_front_product_id AS related_front_product_id_44
FROM
  lot t0
WHERE
  t0.number = ?
  AND t0.is_closed = ?
  AND t0.po_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.number AS number_2, t0.package_units AS package_units_3, t0.weight AS weight_4, t0.user AS user_5, t0.format AS format_6, t0.photos AS photos_7, t0.name AS name_8, t0.extended AS extended_9, t0.units AS units_10, t0.discount AS discount_11, t0.estimated_sales AS estimated_sales_12, t0.is_initialized AS is_initialized_13, t0.msrp_current AS msrp_current_14, t0.is_closed AS is_closed_15, t0.is_high_value AS is_high_value_16, t0.is_cp AS is_cp_17, t0.estimated_sales_min_target AS estimated_sales_min_target_18, t0.estimated_sales_max_target AS estimated_sales_max_target_19, t0.display_name AS display_name_20, t0.quantity AS quantity_21, t0.cp_quantity AS cp_quantity_22, t0.is_truckload AS is_truckload_23, t0.is_photos_compressed AS is_photos_compressed_24, t0.is_destroy AS is_destroy_25, t0.package_sizes AS package_sizes_26, t0.is_listing_done AS is_listing_done_27, t0.discount_triage AS discount_triage_28, t0.volumetric_weight AS volumetric_weight_29, t0.real_weight AS real_weight_30, t0.previous_number AS previous_number_31, t0.is_oversize AS is_oversize_32, t0.cost AS cost_33, t0.is_imported AS is_imported_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.po_id AS po_id_37, t0.category_id AS category_id_38, t0.cp_product_id AS cp_product_id_39, t0.product_condition_id AS product_condition_id_40, t0.merged_with_id AS merged_with_id_41, t0.preparation_lot_id AS preparation_lot_id_42, t0.previous_po_id AS previous_po_id_43, t0.related_front_product_id AS related_front_product_id_44 FROM lot t0 WHERE t0.number = '836351' AND t0.is_closed = 0 AND t0.po_id = 2634 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 331)
4	App\Services\Triage\TriageScanService->confirm (line 60)
5	App\Controller\Triage\TriageScanController->_scan (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.34 ms
(0.79%)

SELECT t0.id AS id_1, t0.session_number AS session_number_2, t0.code AS code_3, t0.scan_type AS scan_type_4, t0.is_confirmed AS is_confirmed_5, t0.is_generic AS is_generic_6, t0.is_validation AS is_validation_7, t0.is_category_validation AS is_category_validation_8, t0.is_action AS is_action_9, t0.is_question AS is_question_10, t0.has_error AS has_error_11, t0.is_deleted AS is_deleted_12, t0.confirm_request AS confirm_request_13, t0.is_error AS is_error_14, t0.result_template AS result_template_15, t0.msrp AS msrp_16, t0.has_cp AS has_cp_17, t0.cp_name AS cp_name_18, t0.cp_number AS cp_number_19, t0.cp_quantity AS cp_quantity_20, t0.is_confirmed_lot AS is_confirmed_lot_21, t0.is_confirmed_cp AS is_confirmed_cp_22, t0.is_rejected AS is_rejected_23, t0.cp_package AS cp_package_24, t0.show_oversize_button AS show_oversize_button_25, t0.user_id AS user_id_26, t0.po_id AS po_id_27, t0.manifest_item_id AS manifest_item_id_28, t0.lot_id AS lot_id_29, t0.action_id AS action_id_30, t0.triage_question_id AS triage_question_id_31, t0.lot_item_id AS lot_item_id_32, t0.scan_category_group_id AS scan_category_group_id_33, t0.oversize_lot_id AS oversize_lot_id_34 FROM triage_scan t0 WHERE t0.po_id = ? AND t0.session_number = ? AND t0.user_id = ? ORDER BY t0.id DESC LIMIT 5

Parameters:

[
  2634
  "ts6769b86860280"
  96
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.session_number AS session_number_2,
  t0.code AS code_3,
  t0.scan_type AS scan_type_4,
  t0.is_confirmed AS is_confirmed_5,
  t0.is_generic AS is_generic_6,
  t0.is_validation AS is_validation_7,
  t0.is_category_validation AS is_category_validation_8,
  t0.is_action AS is_action_9,
  t0.is_question AS is_question_10,
  t0.has_error AS has_error_11,
  t0.is_deleted AS is_deleted_12,
  t0.confirm_request AS confirm_request_13,
  t0.is_error AS is_error_14,
  t0.result_template AS result_template_15,
  t0.msrp AS msrp_16,
  t0.has_cp AS has_cp_17,
  t0.cp_name AS cp_name_18,
  t0.cp_number AS cp_number_19,
  t0.cp_quantity AS cp_quantity_20,
  t0.is_confirmed_lot AS is_confirmed_lot_21,
  t0.is_confirmed_cp AS is_confirmed_cp_22,
  t0.is_rejected AS is_rejected_23,
  t0.cp_package AS cp_package_24,
  t0.show_oversize_button AS show_oversize_button_25,
  t0.user_id AS user_id_26,
  t0.po_id AS po_id_27,
  t0.manifest_item_id AS manifest_item_id_28,
  t0.lot_id AS lot_id_29,
  t0.action_id AS action_id_30,
  t0.triage_question_id AS triage_question_id_31,
  t0.lot_item_id AS lot_item_id_32,
  t0.scan_category_group_id AS scan_category_group_id_33,
  t0.oversize_lot_id AS oversize_lot_id_34
FROM
  triage_scan t0
WHERE
  t0.po_id = ?
  AND t0.session_number = ?
  AND t0.user_id = ?
ORDER BY
  t0.id DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.session_number AS session_number_2, t0.code AS code_3, t0.scan_type AS scan_type_4, t0.is_confirmed AS is_confirmed_5, t0.is_generic AS is_generic_6, t0.is_validation AS is_validation_7, t0.is_category_validation AS is_category_validation_8, t0.is_action AS is_action_9, t0.is_question AS is_question_10, t0.has_error AS has_error_11, t0.is_deleted AS is_deleted_12, t0.confirm_request AS confirm_request_13, t0.is_error AS is_error_14, t0.result_template AS result_template_15, t0.msrp AS msrp_16, t0.has_cp AS has_cp_17, t0.cp_name AS cp_name_18, t0.cp_number AS cp_number_19, t0.cp_quantity AS cp_quantity_20, t0.is_confirmed_lot AS is_confirmed_lot_21, t0.is_confirmed_cp AS is_confirmed_cp_22, t0.is_rejected AS is_rejected_23, t0.cp_package AS cp_package_24, t0.show_oversize_button AS show_oversize_button_25, t0.user_id AS user_id_26, t0.po_id AS po_id_27, t0.manifest_item_id AS manifest_item_id_28, t0.lot_id AS lot_id_29, t0.action_id AS action_id_30, t0.triage_question_id AS triage_question_id_31, t0.lot_item_id AS lot_item_id_32, t0.scan_category_group_id AS scan_category_group_id_33, t0.oversize_lot_id AS oversize_lot_id_34 FROM triage_scan t0 WHERE t0.po_id = 2634 AND t0.session_number = 'ts6769b86860280' AND t0.user_id = 96 ORDER BY t0.id DESC LIMIT 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 83)
4	App\Controller\Triage\TriageScanController->_scan (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.85 ms
(0.51%)

UPDATE triage_user SET active = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  triage_user
SET
  active = ?
WHERE
  id = ?

UPDATE triage_user SET active = 0 WHERE id = 15987;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1277)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 82)
7	App\Services\Lot\LotItemFactory->addOrCreate (line 352)
8	App\Services\Triage\TriageScanService->confirm (line 60)
9	App\Controller\Triage\TriageScanController->_scan (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.81 ms
(0.48%)

UPDATE user SET current_scan_average = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  user
SET
  current_scan_average = ?
WHERE
  id = ?

UPDATE user SET current_scan_average = 188.52 WHERE id = 96;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1277)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 91)
7	App\Services\ProductionIndividualPerformanceService->getData (line 254)
8	App\Controller\Triage\TriageScanController->individualPerformance (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 72)
16	__TwigTemplate_c76325c7257040165eeef9722c8d5ef1->doDisplay (line 393)
17	Twig\Template->yield (line 349)
18	Twig\Template->display (line 364)
19	Twig\Template->render (line 35)
20	Twig\TemplateWrapper->render (line 306)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 99)
25	App\Controller\Triage\TriageScanController->_scan (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.64 ms
(0.38%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.quantity AS quantity_3, t0.method AS method_4, t0.msrp AS msrp_5, t0.name AS name_6, t0.category AS category_7, t0.merchant_sku AS merchant_sku_8, t0.is_analyzed AS is_analyzed_9, t0.analyzed_at AS analyzed_at_10, t0.is_auto_analyzed AS is_auto_analyzed_11, t0.converted AS converted_12, t0.is_generic AS is_generic_13, t0.position AS position_14, t0.is_cp AS is_cp_15, t0.is_high_value AS is_high_value_16, t0.is_prepared AS is_prepared_17, t0.preparation_cp_quantity AS preparation_cp_quantity_18, t0.preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19, t0.preparation_cp_total_units AS preparation_cp_total_units_20, t0.preparation_cp_extended AS preparation_cp_extended_21, t0.preparation_cp_discount AS preparation_cp_discount_22, t0.cp_name AS cp_name_23, t0.cp_display_name AS cp_display_name_24, t0.preparation_cp_selling_extended AS preparation_cp_selling_extended_25, t0.preparation_lot_units AS preparation_lot_units_26, t0.preparation_lot_discount AS preparation_lot_discount_27, t0.preparation_lot_extended AS preparation_lot_extended_28, t0.preparation_lot_selling_extended AS preparation_lot_selling_extended_29, t0.is_upcitemdb_error AS is_upcitemdb_error_30, t0.is_already_in_database AS is_already_in_database_31, t0.photo AS photo_32, t0.quantity_imported AS quantity_imported_33, t0.quantity_scanned AS quantity_scanned_34, t0.quantity_triage AS quantity_triage_35, t0.is_flag_preparation_done AS is_flag_preparation_done_36, t0.premade_lot_number AS premade_lot_number_37, t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38, t0.is_synccentric_search_required AS is_synccentric_search_required_39, t0.is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40, t0.is_sent_to_synccentric AS is_sent_to_synccentric_41, t0.is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42, t0.is_validation AS is_validation_43, t0.is_skipped_for_analysis AS is_skipped_for_analysis_44, t0.created_at AS created_at_45, t0.updated_at AS updated_at_46, t0.po_id AS po_id_47, t0.product_id AS product_id_48, t0.scanned_by_id AS scanned_by_id_49, t0.imported_by_id AS imported_by_id_50, t0.analyzed_by_id AS analyzed_by_id_51, t0.supplier_id AS supplier_id_52, t0.original_preparation_lot_id AS original_preparation_lot_id_53, t0.restock_category_id AS restock_category_id_54, t0.preparation_lot_id AS preparation_lot_id_55, t0.triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0.id = ?

Parameters:

[
  4807002
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.quantity AS quantity_3,
  t0.method AS method_4,
  t0.msrp AS msrp_5,
  t0.name AS name_6,
  t0.category AS category_7,
  t0.merchant_sku AS merchant_sku_8,
  t0.is_analyzed AS is_analyzed_9,
  t0.analyzed_at AS analyzed_at_10,
  t0.is_auto_analyzed AS is_auto_analyzed_11,
  t0.converted AS converted_12,
  t0.is_generic AS is_generic_13,
  t0.position AS position_14,
  t0.is_cp AS is_cp_15,
  t0.is_high_value AS is_high_value_16,
  t0.is_prepared AS is_prepared_17,
  t0.preparation_cp_quantity AS preparation_cp_quantity_18,
  t0.preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19,
  t0.preparation_cp_total_units AS preparation_cp_total_units_20,
  t0.preparation_cp_extended AS preparation_cp_extended_21,
  t0.preparation_cp_discount AS preparation_cp_discount_22,
  t0.cp_name AS cp_name_23,
  t0.cp_display_name AS cp_display_name_24,
  t0.preparation_cp_selling_extended AS preparation_cp_selling_extended_25,
  t0.preparation_lot_units AS preparation_lot_units_26,
  t0.preparation_lot_discount AS preparation_lot_discount_27,
  t0.preparation_lot_extended AS preparation_lot_extended_28,
  t0.preparation_lot_selling_extended AS preparation_lot_selling_extended_29,
  t0.is_upcitemdb_error AS is_upcitemdb_error_30,
  t0.is_already_in_database AS is_already_in_database_31,
  t0.photo AS photo_32,
  t0.quantity_imported AS quantity_imported_33,
  t0.quantity_scanned AS quantity_scanned_34,
  t0.quantity_triage AS quantity_triage_35,
  t0.is_flag_preparation_done AS is_flag_preparation_done_36,
  t0.premade_lot_number AS premade_lot_number_37,
  t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38,
  t0.is_synccentric_search_required AS is_synccentric_search_required_39,
  t0.is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40,
  t0.is_sent_to_synccentric AS is_sent_to_synccentric_41,
  t0.is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42,
  t0.is_validation AS is_validation_43,
  t0.is_skipped_for_analysis AS is_skipped_for_analysis_44,
  t0.created_at AS created_at_45,
  t0.updated_at AS updated_at_46,
  t0.po_id AS po_id_47,
  t0.product_id AS product_id_48,
  t0.scanned_by_id AS scanned_by_id_49,
  t0.imported_by_id AS imported_by_id_50,
  t0.analyzed_by_id AS analyzed_by_id_51,
  t0.supplier_id AS supplier_id_52,
  t0.original_preparation_lot_id AS original_preparation_lot_id_53,
  t0.restock_category_id AS restock_category_id_54,
  t0.preparation_lot_id AS preparation_lot_id_55,
  t0.triage_category_id AS triage_category_id_56
FROM
  manifest_item t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.quantity AS quantity_3, t0.method AS method_4, t0.msrp AS msrp_5, t0.name AS name_6, t0.category AS category_7, t0.merchant_sku AS merchant_sku_8, t0.is_analyzed AS is_analyzed_9, t0.analyzed_at AS analyzed_at_10, t0.is_auto_analyzed AS is_auto_analyzed_11, t0.converted AS converted_12, t0.is_generic AS is_generic_13, t0.position AS position_14, t0.is_cp AS is_cp_15, t0.is_high_value AS is_high_value_16, t0.is_prepared AS is_prepared_17, t0.preparation_cp_quantity AS preparation_cp_quantity_18, t0.preparation_units_per_cp_lot AS preparation_units_per_cp_lot_19, t0.preparation_cp_total_units AS preparation_cp_total_units_20, t0.preparation_cp_extended AS preparation_cp_extended_21, t0.preparation_cp_discount AS preparation_cp_discount_22, t0.cp_name AS cp_name_23, t0.cp_display_name AS cp_display_name_24, t0.preparation_cp_selling_extended AS preparation_cp_selling_extended_25, t0.preparation_lot_units AS preparation_lot_units_26, t0.preparation_lot_discount AS preparation_lot_discount_27, t0.preparation_lot_extended AS preparation_lot_extended_28, t0.preparation_lot_selling_extended AS preparation_lot_selling_extended_29, t0.is_upcitemdb_error AS is_upcitemdb_error_30, t0.is_already_in_database AS is_already_in_database_31, t0.photo AS photo_32, t0.quantity_imported AS quantity_imported_33, t0.quantity_scanned AS quantity_scanned_34, t0.quantity_triage AS quantity_triage_35, t0.is_flag_preparation_done AS is_flag_preparation_done_36, t0.premade_lot_number AS premade_lot_number_37, t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_38, t0.is_synccentric_search_required AS is_synccentric_search_required_39, t0.is_sent_to_prepare_autoanalysis AS is_sent_to_prepare_autoanalysis_40, t0.is_sent_to_synccentric AS is_sent_to_synccentric_41, t0.is_sent_to_autoanalysis AS is_sent_to_autoanalysis_42, t0.is_validation AS is_validation_43, t0.is_skipped_for_analysis AS is_skipped_for_analysis_44, t0.created_at AS created_at_45, t0.updated_at AS updated_at_46, t0.po_id AS po_id_47, t0.product_id AS product_id_48, t0.scanned_by_id AS scanned_by_id_49, t0.imported_by_id AS imported_by_id_50, t0.analyzed_by_id AS analyzed_by_id_51, t0.supplier_id AS supplier_id_52, t0.original_preparation_lot_id AS original_preparation_lot_id_53, t0.restock_category_id AS restock_category_id_54, t0.preparation_lot_id AS preparation_lot_id_55, t0.triage_category_id AS triage_category_id_56 FROM manifest_item t0 WHERE t0.id = 4807002;

#	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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\ManifestItem::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\ManifestItem->__get (line 313)
8	App\Entity\ManifestItem->getProduct (line 325)
9	App\Services\Triage\TriageScanService->confirm (line 60)
10	App\Controller\Triage\TriageScanController->_scan (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.47 ms
(0.28%)

SELECT t0.id AS id_1, t0.nb_scans AS nb_scans_2, t0.module AS module_3, t0.is_closed AS is_closed_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.nb_scans_per_minute AS nb_scans_per_minute_7, t0.nb_minutes AS nb_minutes_8, t0.user_id AS user_id_9, t0.po_id AS po_id_10, t0.scan_category_group_id AS scan_category_group_id_11, t0.user_group_id AS user_group_id_12 FROM scan_session t0 WHERE t0.user_id = ? AND t0.is_closed = ? ORDER BY t0.id DESC LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nb_scans AS nb_scans_2,
  t0.module AS module_3,
  t0.is_closed AS is_closed_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.nb_scans_per_minute AS nb_scans_per_minute_7,
  t0.nb_minutes AS nb_minutes_8,
  t0.user_id AS user_id_9,
  t0.po_id AS po_id_10,
  t0.scan_category_group_id AS scan_category_group_id_11,
  t0.user_group_id AS user_group_id_12
FROM
  scan_session t0
WHERE
  t0.user_id = ?
  AND t0.is_closed = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.nb_scans AS nb_scans_2, t0.module AS module_3, t0.is_closed AS is_closed_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.nb_scans_per_minute AS nb_scans_per_minute_7, t0.nb_minutes AS nb_minutes_8, t0.user_id AS user_id_9, t0.po_id AS po_id_10, t0.scan_category_group_id AS scan_category_group_id_11, t0.user_group_id AS user_group_id_12 FROM scan_session t0 WHERE t0.user_id = 96 AND t0.is_closed = 0 ORDER BY t0.id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 29)
4	App\Services\ScanSessionService->scan (line 495)
5	App\Services\Triage\TriageScanService->updateScanSessionAndSave (line 370)
6	App\Services\Triage\TriageScanService->confirm (line 60)
7	App\Controller\Triage\TriageScanController->_scan (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.46 ms
(0.27%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.is_active AS is_active_3, t0.roles AS roles_4, t0.email AS email_5, t0.password AS password_6, t0.default_language AS default_language_7, t0.scan_sound AS scan_sound_8, t0.is_deleted AS is_deleted_9, t0.firstname AS firstname_10, t0.lastname AS lastname_11, t0.main_role AS main_role_12, t0.is_allowed_continuous_po AS is_allowed_continuous_po_13, t0.current_average90 AS current_average90_14, t0.current_group_average90 AS current_group_average90_15, t0.average90_at AS average90_at_16, t0.current_scan_average AS current_scan_average_17, t0.default_module_id AS default_module_id_18, t0.warehouse_id AS warehouse_id_19, t0.user_group_id AS user_group_id_20, t0.scan_category_group_id AS scan_category_group_id_21 FROM user t0 WHERE t0.id = ?

Parameters:

[
  96
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.is_active AS is_active_3,
  t0.roles AS roles_4,
  t0.email AS email_5,
  t0.password AS password_6,
  t0.default_language AS default_language_7,
  t0.scan_sound AS scan_sound_8,
  t0.is_deleted AS is_deleted_9,
  t0.firstname AS firstname_10,
  t0.lastname AS lastname_11,
  t0.main_role AS main_role_12,
  t0.is_allowed_continuous_po AS is_allowed_continuous_po_13,
  t0.current_average90 AS current_average90_14,
  t0.current_group_average90 AS current_group_average90_15,
  t0.average90_at AS average90_at_16,
  t0.current_scan_average AS current_scan_average_17,
  t0.default_module_id AS default_module_id_18,
  t0.warehouse_id AS warehouse_id_19,
  t0.user_group_id AS user_group_id_20,
  t0.scan_category_group_id AS scan_category_group_id_21
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.is_active AS is_active_3, t0.roles AS roles_4, t0.email AS email_5, t0.password AS password_6, t0.default_language AS default_language_7, t0.scan_sound AS scan_sound_8, t0.is_deleted AS is_deleted_9, t0.firstname AS firstname_10, t0.lastname AS lastname_11, t0.main_role AS main_role_12, t0.is_allowed_continuous_po AS is_allowed_continuous_po_13, t0.current_average90 AS current_average90_14, t0.current_group_average90 AS current_group_average90_15, t0.average90_at AS average90_at_16, t0.current_scan_average AS current_scan_average_17, t0.default_module_id AS default_module_id_18, t0.warehouse_id AS warehouse_id_19, t0.user_group_id AS user_group_id_20, t0.scan_category_group_id AS scan_category_group_id_21 FROM user t0 WHERE t0.id = 96;

#	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 530)
4	Doctrine\ORM\EntityManager->find (line 196)
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 80)
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 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.45 ms
(0.27%)

UPDATE triage_scan SET confirm_request = ?, is_confirmed_lot = ?, lot_item_id = ?, scan_category_group_id = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  triage_scan
SET
  confirm_request = ?,
  is_confirmed_lot = ?,
  lot_item_id = ?,
  scan_category_group_id = ?
WHERE
  id = ?

UPDATE triage_scan SET confirm_request = NULL, is_confirmed_lot = 1, lot_item_id = 4061992, scan_category_group_id = 8 WHERE id = 5049860;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1277)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 79)
7	App\Services\ScanSessionService->updateCurrentSession (line 49)
8	App\Services\ScanSessionService->scan (line 495)
9	App\Services\Triage\TriageScanService->updateScanSessionAndSave (line 370)
10	App\Services\Triage\TriageScanService->confirm (line 60)
11	App\Controller\Triage\TriageScanController->_scan (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.42 ms
(0.25%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 426)
2	Doctrine\ORM\UnitOfWork->commit (line 414)
3	Doctrine\ORM\EntityManager->flush (line 82)
4	App\Services\Lot\LotItemFactory->addOrCreate (line 352)
5	App\Services\Triage\TriageScanService->confirm (line 60)
6	App\Controller\Triage\TriageScanController->_scan (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.35 ms
(0.21%)

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.nb_pallet AS nb_pallet_4, t0.nb_unit AS nb_unit_5, t0.eta AS eta_6, t0.received_at AS received_at_7, t0.manifest_import AS manifest_import_8, t0.note AS note_9, t0.cost_po AS cost_po_10, t0.cost_transport AS cost_transport_11, t0.cost_customs AS cost_customs_12, t0.msrp_value AS msrp_value_13, t0.finances_selling_estimated AS finances_selling_estimated_14, t0.seal_number_provided AS seal_number_provided_15, t0.seal_number_received AS seal_number_received_16, t0.nb_unit_received AS nb_unit_received_17, t0.nb_pallet_received AS nb_pallet_received_18, t0.seal_number_na AS seal_number_na_19, t0.note_reception AS note_reception_20, t0.location AS location_21, t0.progress_step_reception AS progress_step_reception_22, t0.progress_step_scan_manifest AS progress_step_scan_manifest_23, t0.progress_step_import_manifest AS progress_step_import_manifest_24, t0.progress_step_analysis AS progress_step_analysis_25, t0.progress_step_preparation AS progress_step_preparation_26, t0.progress_step_triage AS progress_step_triage_27, t0.progress_step_photobooth AS progress_step_photobooth_28, t0.progress_step_listing AS progress_step_listing_29, t0.progress_step_conciliation AS progress_step_conciliation_30, t0.preparation_total_units AS preparation_total_units_31, t0.preparation_total_extended AS preparation_total_extended_32, t0.preparation_total_selling_extended AS preparation_total_selling_extended_33, t0.preparation_total_cps AS preparation_total_cps_34, t0.preparation_total_lots AS preparation_total_lots_35, t0.import_product_quantity AS import_product_quantity_36, t0.import_unit_quantity AS import_unit_quantity_37, t0.is_truckload AS is_truckload_38, t0.progress_step_truckload AS progress_step_truckload_39, t0.is_autoanalysis_running AS is_autoanalysis_running_40, t0.is_autoanalysis_done AS is_autoanalysis_done_41, t0.bol_supplier AS bol_supplier_42, t0.customs_description AS customs_description_43, t0.customs_country_of_origin AS customs_country_of_origin_44, t0.customs_hs_code AS customs_hs_code_45, t0.cost_production AS cost_production_46, t0.next_cp_number AS next_cp_number_47, t0.is_auto_triage AS is_auto_triage_48, t0.is_lot_import_allowed AS is_lot_import_allowed_49, t0.has_premade_lots AS has_premade_lots_50, t0.is_auto_triage_truckload AS is_auto_triage_truckload_51, t0.auto_triage_category_name AS auto_triage_category_name_52, t0.auto_triage_category_discount AS auto_triage_category_discount_53, t0.archived_at AS archived_at_54, t0.is_final AS is_final_55, t0.final_total_manifest_items AS final_total_manifest_items_56, t0.final_total_analyzed_items AS final_total_analyzed_items_57, t0.final_total_different_items AS final_total_different_items_58, t0.final_total_triage_items AS final_total_triage_items_59, t0.final_import_unit_quantity AS final_import_unit_quantity_60, t0.final_total_hours AS final_total_hours_61, t0.final_total_scans_per_hour AS final_total_scans_per_hour_62, t0.final_msrp AS final_msrp_63, t0.final_estimated_sales_listing AS final_estimated_sales_listing_64, t0.final_selling_po AS final_selling_po_65, t0.final_cog_real AS final_cog_real_66, t0.final_nb_lots AS final_nb_lots_67, t0.is_new_mappings_required AS is_new_mappings_required_68, t0.auto_analysis_start_at AS auto_analysis_start_at_69, t0.auto_analysis_end_at AS auto_analysis_end_at_70, t0.current_synccentric_campaign AS current_synccentric_campaign_71, t0.analysis_queue_priority AS analysis_queue_priority_72, t0.is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_73, t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_74, t0.synccentric_export_current_page AS synccentric_export_current_page_75, t0.synccentric_export_last_page AS synccentric_export_last_page_76, t0.is_synccentric_search_required AS is_synccentric_search_required_77, t0.is_synccentric_import_running AS is_synccentric_import_running_78, t0.is_synccentric_import_done AS is_synccentric_import_done_79, t0.is_synccentric_search_running AS is_synccentric_search_running_80, t0.is_synccentric_search_done AS is_synccentric_search_done_81, t0.is_synccentric_export_running AS is_synccentric_export_running_82, t0.is_synccentric_export_done AS is_synccentric_export_done_83, t0.is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_84, t0.is_synccentric_import_started AS is_synccentric_import_started_85, t0.is_synccentric_export_started AS is_synccentric_export_started_86, t0.is_autoanalysis_started AS is_autoanalysis_started_87, t0.status_id AS status_id_88, t0.supplier_id AS supplier_id_89, t0.product_condition_id AS product_condition_id_90, t0.manifest_style_id AS manifest_style_id_91, t0.invoice_style_id AS invoice_style_id_92, t0.supplier_invoice_state_id AS supplier_invoice_state_id_93, t0.warehouse_id AS warehouse_id_94, t0.auto_triage_category_id AS auto_triage_category_id_95 FROM po t0 WHERE t0.id = ?

Parameters:

[
  "2634"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.active AS active_3,
  t0.nb_pallet AS nb_pallet_4,
  t0.nb_unit AS nb_unit_5,
  t0.eta AS eta_6,
  t0.received_at AS received_at_7,
  t0.manifest_import AS manifest_import_8,
  t0.note AS note_9,
  t0.cost_po AS cost_po_10,
  t0.cost_transport AS cost_transport_11,
  t0.cost_customs AS cost_customs_12,
  t0.msrp_value AS msrp_value_13,
  t0.finances_selling_estimated AS finances_selling_estimated_14,
  t0.seal_number_provided AS seal_number_provided_15,
  t0.seal_number_received AS seal_number_received_16,
  t0.nb_unit_received AS nb_unit_received_17,
  t0.nb_pallet_received AS nb_pallet_received_18,
  t0.seal_number_na AS seal_number_na_19,
  t0.note_reception AS note_reception_20,
  t0.location AS location_21,
  t0.progress_step_reception AS progress_step_reception_22,
  t0.progress_step_scan_manifest AS progress_step_scan_manifest_23,
  t0.progress_step_import_manifest AS progress_step_import_manifest_24,
  t0.progress_step_analysis AS progress_step_analysis_25,
  t0.progress_step_preparation AS progress_step_preparation_26,
  t0.progress_step_triage AS progress_step_triage_27,
  t0.progress_step_photobooth AS progress_step_photobooth_28,
  t0.progress_step_listing AS progress_step_listing_29,
  t0.progress_step_conciliation AS progress_step_conciliation_30,
  t0.preparation_total_units AS preparation_total_units_31,
  t0.preparation_total_extended AS preparation_total_extended_32,
  t0.preparation_total_selling_extended AS preparation_total_selling_extended_33,
  t0.preparation_total_cps AS preparation_total_cps_34,
  t0.preparation_total_lots AS preparation_total_lots_35,
  t0.import_product_quantity AS import_product_quantity_36,
  t0.import_unit_quantity AS import_unit_quantity_37,
  t0.is_truckload AS is_truckload_38,
  t0.progress_step_truckload AS progress_step_truckload_39,
  t0.is_autoanalysis_running AS is_autoanalysis_running_40,
  t0.is_autoanalysis_done AS is_autoanalysis_done_41,
  t0.bol_supplier AS bol_supplier_42,
  t0.customs_description AS customs_description_43,
  t0.customs_country_of_origin AS customs_country_of_origin_44,
  t0.customs_hs_code AS customs_hs_code_45,
  t0.cost_production AS cost_production_46,
  t0.next_cp_number AS next_cp_number_47,
  t0.is_auto_triage AS is_auto_triage_48,
  t0.is_lot_import_allowed AS is_lot_import_allowed_49,
  t0.has_premade_lots AS has_premade_lots_50,
  t0.is_auto_triage_truckload AS is_auto_triage_truckload_51,
  t0.auto_triage_category_name AS auto_triage_category_name_52,
  t0.auto_triage_category_discount AS auto_triage_category_discount_53,
  t0.archived_at AS archived_at_54,
  t0.is_final AS is_final_55,
  t0.final_total_manifest_items AS final_total_manifest_items_56,
  t0.final_total_analyzed_items AS final_total_analyzed_items_57,
  t0.final_total_different_items AS final_total_different_items_58,
  t0.final_total_triage_items AS final_total_triage_items_59,
  t0.final_import_unit_quantity AS final_import_unit_quantity_60,
  t0.final_total_hours AS final_total_hours_61,
  t0.final_total_scans_per_hour AS final_total_scans_per_hour_62,
  t0.final_msrp AS final_msrp_63,
  t0.final_estimated_sales_listing AS final_estimated_sales_listing_64,
  t0.final_selling_po AS final_selling_po_65,
  t0.final_cog_real AS final_cog_real_66,
  t0.final_nb_lots AS final_nb_lots_67,
  t0.is_new_mappings_required AS is_new_mappings_required_68,
  t0.auto_analysis_start_at AS auto_analysis_start_at_69,
  t0.auto_analysis_end_at AS auto_analysis_end_at_70,
  t0.current_synccentric_campaign AS current_synccentric_campaign_71,
  t0.analysis_queue_priority AS analysis_queue_priority_72,
  t0.is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_73,
  t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_74,
  t0.synccentric_export_current_page AS synccentric_export_current_page_75,
  t0.synccentric_export_last_page AS synccentric_export_last_page_76,
  t0.is_synccentric_search_required AS is_synccentric_search_required_77,
  t0.is_synccentric_import_running AS is_synccentric_import_running_78,
  t0.is_synccentric_import_done AS is_synccentric_import_done_79,
  t0.is_synccentric_search_running AS is_synccentric_search_running_80,
  t0.is_synccentric_search_done AS is_synccentric_search_done_81,
  t0.is_synccentric_export_running AS is_synccentric_export_running_82,
  t0.is_synccentric_export_done AS is_synccentric_export_done_83,
  t0.is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_84,
  t0.is_synccentric_import_started AS is_synccentric_import_started_85,
  t0.is_synccentric_export_started AS is_synccentric_export_started_86,
  t0.is_autoanalysis_started AS is_autoanalysis_started_87,
  t0.status_id AS status_id_88,
  t0.supplier_id AS supplier_id_89,
  t0.product_condition_id AS product_condition_id_90,
  t0.manifest_style_id AS manifest_style_id_91,
  t0.invoice_style_id AS invoice_style_id_92,
  t0.supplier_invoice_state_id AS supplier_invoice_state_id_93,
  t0.warehouse_id AS warehouse_id_94,
  t0.auto_triage_category_id AS auto_triage_category_id_95
FROM
  po t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.active AS active_3, t0.nb_pallet AS nb_pallet_4, t0.nb_unit AS nb_unit_5, t0.eta AS eta_6, t0.received_at AS received_at_7, t0.manifest_import AS manifest_import_8, t0.note AS note_9, t0.cost_po AS cost_po_10, t0.cost_transport AS cost_transport_11, t0.cost_customs AS cost_customs_12, t0.msrp_value AS msrp_value_13, t0.finances_selling_estimated AS finances_selling_estimated_14, t0.seal_number_provided AS seal_number_provided_15, t0.seal_number_received AS seal_number_received_16, t0.nb_unit_received AS nb_unit_received_17, t0.nb_pallet_received AS nb_pallet_received_18, t0.seal_number_na AS seal_number_na_19, t0.note_reception AS note_reception_20, t0.location AS location_21, t0.progress_step_reception AS progress_step_reception_22, t0.progress_step_scan_manifest AS progress_step_scan_manifest_23, t0.progress_step_import_manifest AS progress_step_import_manifest_24, t0.progress_step_analysis AS progress_step_analysis_25, t0.progress_step_preparation AS progress_step_preparation_26, t0.progress_step_triage AS progress_step_triage_27, t0.progress_step_photobooth AS progress_step_photobooth_28, t0.progress_step_listing AS progress_step_listing_29, t0.progress_step_conciliation AS progress_step_conciliation_30, t0.preparation_total_units AS preparation_total_units_31, t0.preparation_total_extended AS preparation_total_extended_32, t0.preparation_total_selling_extended AS preparation_total_selling_extended_33, t0.preparation_total_cps AS preparation_total_cps_34, t0.preparation_total_lots AS preparation_total_lots_35, t0.import_product_quantity AS import_product_quantity_36, t0.import_unit_quantity AS import_unit_quantity_37, t0.is_truckload AS is_truckload_38, t0.progress_step_truckload AS progress_step_truckload_39, t0.is_autoanalysis_running AS is_autoanalysis_running_40, t0.is_autoanalysis_done AS is_autoanalysis_done_41, t0.bol_supplier AS bol_supplier_42, t0.customs_description AS customs_description_43, t0.customs_country_of_origin AS customs_country_of_origin_44, t0.customs_hs_code AS customs_hs_code_45, t0.cost_production AS cost_production_46, t0.next_cp_number AS next_cp_number_47, t0.is_auto_triage AS is_auto_triage_48, t0.is_lot_import_allowed AS is_lot_import_allowed_49, t0.has_premade_lots AS has_premade_lots_50, t0.is_auto_triage_truckload AS is_auto_triage_truckload_51, t0.auto_triage_category_name AS auto_triage_category_name_52, t0.auto_triage_category_discount AS auto_triage_category_discount_53, t0.archived_at AS archived_at_54, t0.is_final AS is_final_55, t0.final_total_manifest_items AS final_total_manifest_items_56, t0.final_total_analyzed_items AS final_total_analyzed_items_57, t0.final_total_different_items AS final_total_different_items_58, t0.final_total_triage_items AS final_total_triage_items_59, t0.final_import_unit_quantity AS final_import_unit_quantity_60, t0.final_total_hours AS final_total_hours_61, t0.final_total_scans_per_hour AS final_total_scans_per_hour_62, t0.final_msrp AS final_msrp_63, t0.final_estimated_sales_listing AS final_estimated_sales_listing_64, t0.final_selling_po AS final_selling_po_65, t0.final_cog_real AS final_cog_real_66, t0.final_nb_lots AS final_nb_lots_67, t0.is_new_mappings_required AS is_new_mappings_required_68, t0.auto_analysis_start_at AS auto_analysis_start_at_69, t0.auto_analysis_end_at AS auto_analysis_end_at_70, t0.current_synccentric_campaign AS current_synccentric_campaign_71, t0.analysis_queue_priority AS analysis_queue_priority_72, t0.is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_73, t0.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_74, t0.synccentric_export_current_page AS synccentric_export_current_page_75, t0.synccentric_export_last_page AS synccentric_export_last_page_76, t0.is_synccentric_search_required AS is_synccentric_search_required_77, t0.is_synccentric_import_running AS is_synccentric_import_running_78, t0.is_synccentric_import_done AS is_synccentric_import_done_79, t0.is_synccentric_search_running AS is_synccentric_search_running_80, t0.is_synccentric_search_done AS is_synccentric_search_done_81, t0.is_synccentric_export_running AS is_synccentric_export_running_82, t0.is_synccentric_export_done AS is_synccentric_export_done_83, t0.is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_84, t0.is_synccentric_import_started AS is_synccentric_import_started_85, t0.is_synccentric_export_started AS is_synccentric_export_started_86, t0.is_autoanalysis_started AS is_autoanalysis_started_87, t0.status_id AS status_id_88, t0.supplier_id AS supplier_id_89, t0.product_condition_id AS product_condition_id_90, t0.manifest_style_id AS manifest_style_id_91, t0.invoice_style_id AS invoice_style_id_92, t0.supplier_invoice_state_id AS supplier_invoice_state_id_93, t0.warehouse_id AS warehouse_id_94, t0.auto_triage_category_id AS auto_triage_category_id_95 FROM po t0 WHERE t0.id = '2634';

#	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 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 119)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.31 ms
(0.18%)

UPDATE triage_scan SET is_confirmed = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  triage_scan
SET
  is_confirmed = ?
WHERE
  id = ?

UPDATE triage_scan SET is_confirmed = 1 WHERE id = 5049860;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1277)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 82)
7	App\Services\Lot\LotItemFactory->addOrCreate (line 352)
8	App\Services\Triage\TriageScanService->confirm (line 60)
9	App\Controller\Triage\TriageScanController->_scan (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.30 ms
(0.18%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.msrp AS msrp_3, t0.quantity AS quantity_4, t0.extended AS extended_5, t0.is_truckload AS is_truckload_6, t0.is_converted AS is_converted_7, t0.lot_id AS lot_id_8, t0.product_id AS product_id_9, t0.po_id AS po_id_10, t0.manifest_item_id AS manifest_item_id_11, t0.original_lot_id AS original_lot_id_12, t0.duplicate_of_id AS duplicate_of_id_13 FROM lot_item t0 WHERE t0.lot_id = ? ORDER BY t0.extended DESC

Parameters:

[
  49506
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.msrp AS msrp_3,
  t0.quantity AS quantity_4,
  t0.extended AS extended_5,
  t0.is_truckload AS is_truckload_6,
  t0.is_converted AS is_converted_7,
  t0.lot_id AS lot_id_8,
  t0.product_id AS product_id_9,
  t0.po_id AS po_id_10,
  t0.manifest_item_id AS manifest_item_id_11,
  t0.original_lot_id AS original_lot_id_12,
  t0.duplicate_of_id AS duplicate_of_id_13
FROM
  lot_item t0
WHERE
  t0.lot_id = ?
ORDER BY
  t0.extended DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.msrp AS msrp_3, t0.quantity AS quantity_4, t0.extended AS extended_5, t0.is_truckload AS is_truckload_6, t0.is_converted AS is_converted_7, t0.lot_id AS lot_id_8, t0.product_id AS product_id_9, t0.po_id AS po_id_10, t0.manifest_item_id AS manifest_item_id_11, t0.original_lot_id AS original_lot_id_12, t0.duplicate_of_id AS duplicate_of_id_13 FROM lot_item t0 WHERE t0.lot_id = 49506 ORDER BY t0.extended DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 237)
7	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 43)
8	App\Services\Lot\LotItemFactory->addOrCreate (line 352)
9	App\Services\Triage\TriageScanService->confirm (line 60)
10	App\Controller\Triage\TriageScanController->_scan (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.27 ms
(0.16%)

UPDATE scan_session SET nb_scans = ?, updated_at = ?, nb_scans_per_minute = ? WHERE id = ?

Parameters:

[
  95
  "2024-12-23 14:22:33"
  4.13
  315522
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  scan_session
SET
  nb_scans = ?,
  updated_at = ?,
  nb_scans_per_minute = ?
WHERE
  id = ?

UPDATE scan_session SET nb_scans = 95, updated_at = '2024-12-23 14:22:33', nb_scans_per_minute = 4.13 WHERE id = 315522;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1277)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 79)
7	App\Services\ScanSessionService->updateCurrentSession (line 49)
8	App\Services\ScanSessionService->scan (line 495)
9	App\Services\Triage\TriageScanService->updateScanSessionAndSave (line 370)
10	App\Services\Triage\TriageScanService->confirm (line 60)
11	App\Controller\Triage\TriageScanController->_scan (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.27 ms
(0.16%)

UPDATE supplier SET has_actions = ?, has_validation = ?, has_high_value = ?, is_active = ?, is_deleted = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  supplier
SET
  has_actions = ?,
  has_validation = ?,
  has_high_value = ?,
  is_active = ?,
  is_deleted = ?
WHERE
  id = ?

UPDATE supplier SET has_actions = 0, has_validation = 1, has_high_value = 0, is_active = 1, is_deleted = 0 WHERE id = 28;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1277)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 100)
7	App\Services\ScanSessionService->manageClosing (line 129)
8	App\Services\ScanSessionService->getIndividualProductionPoData (line 85)
9	App\Services\ProductionIndividualPerformanceService->getData (line 254)
10	App\Controller\Triage\TriageScanController->individualPerformance (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 72)
18	__TwigTemplate_c76325c7257040165eeef9722c8d5ef1->doDisplay (line 393)
19	Twig\Template->yield (line 349)
20	Twig\Template->display (line 364)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 99)
27	App\Controller\Triage\TriageScanController->_scan (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.25 ms
(0.15%)

SELECT t0.id AS id_1, t0.session_number AS session_number_2, t0.code AS code_3, t0.scan_type AS scan_type_4, t0.is_confirmed AS is_confirmed_5, t0.is_generic AS is_generic_6, t0.is_validation AS is_validation_7, t0.is_category_validation AS is_category_validation_8, t0.is_action AS is_action_9, t0.is_question AS is_question_10, t0.has_error AS has_error_11, t0.is_deleted AS is_deleted_12, t0.confirm_request AS confirm_request_13, t0.is_error AS is_error_14, t0.result_template AS result_template_15, t0.msrp AS msrp_16, t0.has_cp AS has_cp_17, t0.cp_name AS cp_name_18, t0.cp_number AS cp_number_19, t0.cp_quantity AS cp_quantity_20, t0.is_confirmed_lot AS is_confirmed_lot_21, t0.is_confirmed_cp AS is_confirmed_cp_22, t0.is_rejected AS is_rejected_23, t0.cp_package AS cp_package_24, t0.show_oversize_button AS show_oversize_button_25, t0.user_id AS user_id_26, t0.po_id AS po_id_27, t0.manifest_item_id AS manifest_item_id_28, t0.lot_id AS lot_id_29, t0.action_id AS action_id_30, t0.triage_question_id AS triage_question_id_31, t0.lot_item_id AS lot_item_id_32, t0.scan_category_group_id AS scan_category_group_id_33, t0.oversize_lot_id AS oversize_lot_id_34 FROM triage_scan t0 WHERE t0.id = ?

Parameters:

[
  "5049860"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.session_number AS session_number_2,
  t0.code AS code_3,
  t0.scan_type AS scan_type_4,
  t0.is_confirmed AS is_confirmed_5,
  t0.is_generic AS is_generic_6,
  t0.is_validation AS is_validation_7,
  t0.is_category_validation AS is_category_validation_8,
  t0.is_action AS is_action_9,
  t0.is_question AS is_question_10,
  t0.has_error AS has_error_11,
  t0.is_deleted AS is_deleted_12,
  t0.confirm_request AS confirm_request_13,
  t0.is_error AS is_error_14,
  t0.result_template AS result_template_15,
  t0.msrp AS msrp_16,
  t0.has_cp AS has_cp_17,
  t0.cp_name AS cp_name_18,
  t0.cp_number AS cp_number_19,
  t0.cp_quantity AS cp_quantity_20,
  t0.is_confirmed_lot AS is_confirmed_lot_21,
  t0.is_confirmed_cp AS is_confirmed_cp_22,
  t0.is_rejected AS is_rejected_23,
  t0.cp_package AS cp_package_24,
  t0.show_oversize_button AS show_oversize_button_25,
  t0.user_id AS user_id_26,
  t0.po_id AS po_id_27,
  t0.manifest_item_id AS manifest_item_id_28,
  t0.lot_id AS lot_id_29,
  t0.action_id AS action_id_30,
  t0.triage_question_id AS triage_question_id_31,
  t0.lot_item_id AS lot_item_id_32,
  t0.scan_category_group_id AS scan_category_group_id_33,
  t0.oversize_lot_id AS oversize_lot_id_34
FROM
  triage_scan t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.session_number AS session_number_2, t0.code AS code_3, t0.scan_type AS scan_type_4, t0.is_confirmed AS is_confirmed_5, t0.is_generic AS is_generic_6, t0.is_validation AS is_validation_7, t0.is_category_validation AS is_category_validation_8, t0.is_action AS is_action_9, t0.is_question AS is_question_10, t0.has_error AS has_error_11, t0.is_deleted AS is_deleted_12, t0.confirm_request AS confirm_request_13, t0.is_error AS is_error_14, t0.result_template AS result_template_15, t0.msrp AS msrp_16, t0.has_cp AS has_cp_17, t0.cp_name AS cp_name_18, t0.cp_number AS cp_number_19, t0.cp_quantity AS cp_quantity_20, t0.is_confirmed_lot AS is_confirmed_lot_21, t0.is_confirmed_cp AS is_confirmed_cp_22, t0.is_rejected AS is_rejected_23, t0.cp_package AS cp_package_24, t0.show_oversize_button AS show_oversize_button_25, t0.user_id AS user_id_26, t0.po_id AS po_id_27, t0.manifest_item_id AS manifest_item_id_28, t0.lot_id AS lot_id_29, t0.action_id AS action_id_30, t0.triage_question_id AS triage_question_id_31, t0.lot_item_id AS lot_item_id_32, t0.scan_category_group_id AS scan_category_group_id_33, t0.oversize_lot_id AS oversize_lot_id_34 FROM triage_scan t0 WHERE t0.id = '5049860';

#	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 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 284)
6	App\Services\Triage\TriageScanService->confirm (line 60)
7	App\Controller\Triage\TriageScanController->_scan (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.20 ms
(0.12%)

UPDATE lot_item SET quantity = ?, extended = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  lot_item
SET
  quantity = ?,
  extended = ?
WHERE
  id = ?

UPDATE lot_item SET quantity = 3, extended = 104.91 WHERE id = 4061992;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1277)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 82)
7	App\Services\Lot\LotItemFactory->addOrCreate (line 352)
8	App\Services\Triage\TriageScanService->confirm (line 60)
9	App\Controller\Triage\TriageScanController->_scan (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.17 ms
(0.10%)

UPDATE `product_condition` SET is_active = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product_condition`
SET
  is_active = ?
WHERE
  id = ?

UPDATE `product_condition` SET is_active = 1 WHERE id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1277)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 100)
7	App\Services\ScanSessionService->manageClosing (line 129)
8	App\Services\ScanSessionService->getIndividualProductionPoData (line 85)
9	App\Services\ProductionIndividualPerformanceService->getData (line 254)
10	App\Controller\Triage\TriageScanController->individualPerformance (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 72)
18	__TwigTemplate_c76325c7257040165eeef9722c8d5ef1->doDisplay (line 393)
19	Twig\Template->yield (line 349)
20	Twig\Template->display (line 364)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 99)
27	App\Controller\Triage\TriageScanController->_scan (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.16 ms
(0.10%)

UPDATE category SET is_updated = ?, is_active = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  category
SET
  is_updated = ?,
  is_active = ?
WHERE
  id = ?

UPDATE category SET is_updated = 1, is_active = 1 WHERE id = 65;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1277)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 79)
7	App\Services\ScanSessionService->updateCurrentSession (line 49)
8	App\Services\ScanSessionService->scan (line 495)
9	App\Services\Triage\TriageScanService->updateScanSessionAndSave (line 370)
10	App\Services\Triage\TriageScanService->confirm (line 60)
11	App\Controller\Triage\TriageScanController->_scan (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.16 ms
(0.10%)

UPDATE lot SET units = ?, estimated_sales = ?, msrp_current = ?, is_high_value = ?, is_cp = ?, updated_at = ? WHERE id = ?

Parameters:

[
  69
  265.6
  1327.99
  0
  0
  "2024-12-23 14:22:33"
  49506
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  lot
SET
  units = ?,
  estimated_sales = ?,
  msrp_current = ?,
  is_high_value = ?,
  is_cp = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE lot SET units = 69, estimated_sales = 265.6, msrp_current = 1327.99, is_high_value = 0, is_cp = 0, updated_at = '2024-12-23 14:22:33' WHERE id = 49506;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1277)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 82)
7	App\Services\Lot\LotItemFactory->addOrCreate (line 352)
8	App\Services\Triage\TriageScanService->confirm (line 60)
9	App\Controller\Triage\TriageScanController->_scan (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.16 ms
(0.09%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.msrp AS msrp_4, t0.analyzed_at AS analyzed_at_5, t0.photo AS photo_6, t0.cp_quantity AS cp_quantity_7, t0.cp_number AS cp_number_8, t0.cp_name AS cp_name_9, t0.cp_discount AS cp_discount_10, t0.has_expiration_date AS has_expiration_date_11, t0.cp_format AS cp_format_12, t0.cp_packaged_units AS cp_packaged_units_13, t0.cp_photos AS cp_photos_14, t0.cp_weight AS cp_weight_15, t0.cp_package AS cp_package_16, t0.old_cp_number AS old_cp_number_17, t0.is_flag_preparation_done AS is_flag_preparation_done_18, t0.has_marketing_photo_request AS has_marketing_photo_request_19, t0.is_oversize AS is_oversize_20, t0.old_name AS old_name_21, t0.is_updated AS is_updated_22, t0.scraper_class AS scraper_class_23, t0.scraper_id AS scraper_id_24, t0.is_upc_checked AS is_upc_checked_25, t0.is_upc_valid AS is_upc_valid_26, t0.is_ean_checked AS is_ean_checked_27, t0.is_ean_valid AS is_ean_valid_28, t0.is_validation AS is_validation_29, t0.is_category_validation AS is_category_validation_30, t0.previous_category_id AS previous_category_id_31, t0.last_category_change_at AS last_category_change_at_32, t0.restock_category_id AS restock_category_id_33, t0.analyzed_by_id AS analyzed_by_id_34, t0.upcitemdb_id AS upcitemdb_id_35, t0.synccentric_id AS synccentric_id_36 FROM product t0 WHERE t0.id = ?

Parameters:

[
  1070735
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.msrp AS msrp_4,
  t0.analyzed_at AS analyzed_at_5,
  t0.photo AS photo_6,
  t0.cp_quantity AS cp_quantity_7,
  t0.cp_number AS cp_number_8,
  t0.cp_name AS cp_name_9,
  t0.cp_discount AS cp_discount_10,
  t0.has_expiration_date AS has_expiration_date_11,
  t0.cp_format AS cp_format_12,
  t0.cp_packaged_units AS cp_packaged_units_13,
  t0.cp_photos AS cp_photos_14,
  t0.cp_weight AS cp_weight_15,
  t0.cp_package AS cp_package_16,
  t0.old_cp_number AS old_cp_number_17,
  t0.is_flag_preparation_done AS is_flag_preparation_done_18,
  t0.has_marketing_photo_request AS has_marketing_photo_request_19,
  t0.is_oversize AS is_oversize_20,
  t0.old_name AS old_name_21,
  t0.is_updated AS is_updated_22,
  t0.scraper_class AS scraper_class_23,
  t0.scraper_id AS scraper_id_24,
  t0.is_upc_checked AS is_upc_checked_25,
  t0.is_upc_valid AS is_upc_valid_26,
  t0.is_ean_checked AS is_ean_checked_27,
  t0.is_ean_valid AS is_ean_valid_28,
  t0.is_validation AS is_validation_29,
  t0.is_category_validation AS is_category_validation_30,
  t0.previous_category_id AS previous_category_id_31,
  t0.last_category_change_at AS last_category_change_at_32,
  t0.restock_category_id AS restock_category_id_33,
  t0.analyzed_by_id AS analyzed_by_id_34,
  t0.upcitemdb_id AS upcitemdb_id_35,
  t0.synccentric_id AS synccentric_id_36
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.msrp AS msrp_4, t0.analyzed_at AS analyzed_at_5, t0.photo AS photo_6, t0.cp_quantity AS cp_quantity_7, t0.cp_number AS cp_number_8, t0.cp_name AS cp_name_9, t0.cp_discount AS cp_discount_10, t0.has_expiration_date AS has_expiration_date_11, t0.cp_format AS cp_format_12, t0.cp_packaged_units AS cp_packaged_units_13, t0.cp_photos AS cp_photos_14, t0.cp_weight AS cp_weight_15, t0.cp_package AS cp_package_16, t0.old_cp_number AS old_cp_number_17, t0.is_flag_preparation_done AS is_flag_preparation_done_18, t0.has_marketing_photo_request AS has_marketing_photo_request_19, t0.is_oversize AS is_oversize_20, t0.old_name AS old_name_21, t0.is_updated AS is_updated_22, t0.scraper_class AS scraper_class_23, t0.scraper_id AS scraper_id_24, t0.is_upc_checked AS is_upc_checked_25, t0.is_upc_valid AS is_upc_valid_26, t0.is_ean_checked AS is_ean_checked_27, t0.is_ean_valid AS is_ean_valid_28, t0.is_validation AS is_validation_29, t0.is_category_validation AS is_category_validation_30, t0.previous_category_id AS previous_category_id_31, t0.last_category_change_at AS last_category_change_at_32, t0.restock_category_id AS restock_category_id_33, t0.analyzed_by_id AS analyzed_by_id_34, t0.upcitemdb_id AS upcitemdb_id_35, t0.synccentric_id AS synccentric_id_36 FROM product t0 WHERE t0.id = 1070735;

#	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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Product::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Product->__get (line 287)
8	App\Entity\Product->getName (line 1802)
9	Twig\Extension\CoreExtension::getAttribute (line 129)
10	__TwigTemplate_02c5fc6dae0a22bab417f3ac41f4e97a->doDisplay (line 393)
11	Twig\Template->yield (line 238)
12	__TwigTemplate_c76325c7257040165eeef9722c8d5ef1->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 99)
21	App\Controller\Triage\TriageScanController->_scan (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.15 ms
(0.09%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.contact_main_name AS contact_main_name_4, t0.contact_main_phone AS contact_main_phone_5, t0.contact_main_extension AS contact_main_extension_6, t0.contact_main_email AS contact_main_email_7, t0.contact_director_name AS contact_director_name_8, t0.contact_director_phone AS contact_director_phone_9, t0.contact_director_extension AS contact_director_extension_10, t0.contact_director_email AS contact_director_email_11, t0.contact_supervisor_name AS contact_supervisor_name_12, t0.contact_supervisor_phone AS contact_supervisor_phone_13, t0.contact_supervisor_extension AS contact_supervisor_extension_14, t0.contact_supervisor_email AS contact_supervisor_email_15, t0.contact_shipping_name AS contact_shipping_name_16, t0.contact_shipping_phone AS contact_shipping_phone_17, t0.contact_shipping_extension AS contact_shipping_extension_18, t0.contact_shipping_email AS contact_shipping_email_19, t0.contact_billing_name AS contact_billing_name_20, t0.contact_billing_phone AS contact_billing_phone_21, t0.contact_billing_extension AS contact_billing_extension_22, t0.contact_billing_email AS contact_billing_email_23, t0.email AS email_24, t0.is_active AS is_active_25, t0.shipping_state AS shipping_state_26, t0.shipping_country AS shipping_country_27, t0.shipping_postcode AS shipping_postcode_28, t0.is_deleted AS is_deleted_29 FROM warehouse 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.number AS number_3,
  t0.contact_main_name AS contact_main_name_4,
  t0.contact_main_phone AS contact_main_phone_5,
  t0.contact_main_extension AS contact_main_extension_6,
  t0.contact_main_email AS contact_main_email_7,
  t0.contact_director_name AS contact_director_name_8,
  t0.contact_director_phone AS contact_director_phone_9,
  t0.contact_director_extension AS contact_director_extension_10,
  t0.contact_director_email AS contact_director_email_11,
  t0.contact_supervisor_name AS contact_supervisor_name_12,
  t0.contact_supervisor_phone AS contact_supervisor_phone_13,
  t0.contact_supervisor_extension AS contact_supervisor_extension_14,
  t0.contact_supervisor_email AS contact_supervisor_email_15,
  t0.contact_shipping_name AS contact_shipping_name_16,
  t0.contact_shipping_phone AS contact_shipping_phone_17,
  t0.contact_shipping_extension AS contact_shipping_extension_18,
  t0.contact_shipping_email AS contact_shipping_email_19,
  t0.contact_billing_name AS contact_billing_name_20,
  t0.contact_billing_phone AS contact_billing_phone_21,
  t0.contact_billing_extension AS contact_billing_extension_22,
  t0.contact_billing_email AS contact_billing_email_23,
  t0.email AS email_24,
  t0.is_active AS is_active_25,
  t0.shipping_state AS shipping_state_26,
  t0.shipping_country AS shipping_country_27,
  t0.shipping_postcode AS shipping_postcode_28,
  t0.is_deleted AS is_deleted_29
FROM
  warehouse t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.contact_main_name AS contact_main_name_4, t0.contact_main_phone AS contact_main_phone_5, t0.contact_main_extension AS contact_main_extension_6, t0.contact_main_email AS contact_main_email_7, t0.contact_director_name AS contact_director_name_8, t0.contact_director_phone AS contact_director_phone_9, t0.contact_director_extension AS contact_director_extension_10, t0.contact_director_email AS contact_director_email_11, t0.contact_supervisor_name AS contact_supervisor_name_12, t0.contact_supervisor_phone AS contact_supervisor_phone_13, t0.contact_supervisor_extension AS contact_supervisor_extension_14, t0.contact_supervisor_email AS contact_supervisor_email_15, t0.contact_shipping_name AS contact_shipping_name_16, t0.contact_shipping_phone AS contact_shipping_phone_17, t0.contact_shipping_extension AS contact_shipping_extension_18, t0.contact_shipping_email AS contact_shipping_email_19, t0.contact_billing_name AS contact_billing_name_20, t0.contact_billing_phone AS contact_billing_phone_21, t0.contact_billing_extension AS contact_billing_extension_22, t0.contact_billing_email AS contact_billing_email_23, t0.email AS email_24, t0.is_active AS is_active_25, t0.shipping_state AS shipping_state_26, t0.shipping_country AS shipping_country_27, t0.shipping_postcode AS shipping_postcode_28, t0.is_deleted AS is_deleted_29 FROM warehouse 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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Warehouse::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Warehouse->__get (line 266)
8	App\Entity\Warehouse->getNumber (line 444)
9	App\Entity\Lot->getFrontProductSku (line 343)
10	App\Services\Triage\TriageScanService->confirm (line 60)
11	App\Controller\Triage\TriageScanController->_scan (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.14 ms
(0.08%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_main AS is_main_3, t0.generic_value AS generic_value_4, t0.high_value_threshold AS high_value_threshold_5, t0.is_updated AS is_updated_6, t0.is_active AS is_active_7, t0.can_have_cp AS can_have_cp_8, t0.slug AS slug_9, t0.is_public AS is_public_10, t0.generic_high_value AS generic_high_value_11, t0.newsletter_default_footer_image AS newsletter_default_footer_image_12, t0.newsletter_default_footer_image_price_drop AS newsletter_default_footer_image_price_drop_13, t0.has_oversize AS has_oversize_14, t0.google_id AS google_id_15, t0.max_quantity_same_lot_item AS max_quantity_same_lot_item_16, t0.parent_id AS parent_id_17, t0.scan_category_group_id AS scan_category_group_id_18 FROM category t0 WHERE t0.id = ?

Parameters:

[
  65
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_main AS is_main_3,
  t0.generic_value AS generic_value_4,
  t0.high_value_threshold AS high_value_threshold_5,
  t0.is_updated AS is_updated_6,
  t0.is_active AS is_active_7,
  t0.can_have_cp AS can_have_cp_8,
  t0.slug AS slug_9,
  t0.is_public AS is_public_10,
  t0.generic_high_value AS generic_high_value_11,
  t0.newsletter_default_footer_image AS newsletter_default_footer_image_12,
  t0.newsletter_default_footer_image_price_drop AS newsletter_default_footer_image_price_drop_13,
  t0.has_oversize AS has_oversize_14,
  t0.google_id AS google_id_15,
  t0.max_quantity_same_lot_item AS max_quantity_same_lot_item_16,
  t0.parent_id AS parent_id_17,
  t0.scan_category_group_id AS scan_category_group_id_18
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_main AS is_main_3, t0.generic_value AS generic_value_4, t0.high_value_threshold AS high_value_threshold_5, t0.is_updated AS is_updated_6, t0.is_active AS is_active_7, t0.can_have_cp AS can_have_cp_8, t0.slug AS slug_9, t0.is_public AS is_public_10, t0.generic_high_value AS generic_high_value_11, t0.newsletter_default_footer_image AS newsletter_default_footer_image_12, t0.newsletter_default_footer_image_price_drop AS newsletter_default_footer_image_price_drop_13, t0.has_oversize AS has_oversize_14, t0.google_id AS google_id_15, t0.max_quantity_same_lot_item AS max_quantity_same_lot_item_16, t0.parent_id AS parent_id_17, t0.scan_category_group_id AS scan_category_group_id_18 FROM category t0 WHERE t0.id = 65;

#	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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Category::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Category->__get (line 637)
8	App\Entity\Category->getScanCategoryGroup (line 127)
9	App\Entity\TriageScan->extractScanCategoryGroup (line 492)
10	App\Services\Triage\TriageScanService->updateScanSessionAndSave (line 370)
11	App\Services\Triage\TriageScanService->confirm (line 60)
12	App\Controller\Triage\TriageScanController->_scan (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.14 ms
(0.08%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.has_actions AS has_actions_3, t0.has_validation AS has_validation_4, t0.has_high_value AS has_high_value_5, t0.is_active AS is_active_6, t0.has_scrapper AS has_scrapper_7, t0.sources_upc AS sources_upc_8, t0.sources_merchant_sku AS sources_merchant_sku_9, t0.sources_category AS sources_category_10, t0.sources_name AS sources_name_11, t0.sources_msrp AS sources_msrp_12, t0.sources_photo AS sources_photo_13, t0.sources_action AS sources_action_14, t0.is_required_upc AS is_required_upc_15, t0.is_required_merchant_sku AS is_required_merchant_sku_16, t0.is_required_category AS is_required_category_17, t0.is_required_name AS is_required_name_18, t0.is_required_msrp AS is_required_msrp_19, t0.is_required_photo AS is_required_photo_20, t0.is_required_action AS is_required_action_21, t0.public_name AS public_name_22, t0.is_deleted AS is_deleted_23, t0.product_generic_link AS product_generic_link_24, t0.billing_name AS billing_name_25, t0.billing_address AS billing_address_26, t0.tax_name1 AS tax_name1_27, t0.tax_rate1 AS tax_rate1_28, t0.tax_name2 AS tax_name2_29, t0.tax_rate2 AS tax_rate2_30, t0.tax_number1 AS tax_number1_31, t0.tax_number2 AS tax_number2_32, t0.tax_currency AS tax_currency_33, t0.weight_per_pallet_feet AS weight_per_pallet_feet_34, t0.has_continuous_po AS has_continuous_po_35, t0.newsletter_default_subject AS newsletter_default_subject_36, t0.newsletter_default_preview_text AS newsletter_default_preview_text_37, t0.newsletter_default_header_line1 AS newsletter_default_header_line1_38, t0.newsletter_default_header_line2 AS newsletter_default_header_line2_39, t0.newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40, t0.newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41, t0.newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42, t0.scraper_class AS scraper_class_43, t0.has_splited_scraper AS has_splited_scraper_44, t0.has_synccentric_data AS has_synccentric_data_45, t0.has_upcitemdb_data AS has_upcitemdb_data_46, t0.apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47, t0.is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48, t0.shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49, t0.shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50, t0.user_group_id AS user_group_id_51 FROM supplier t0 WHERE t0.id = ?

Parameters:

[
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.has_actions AS has_actions_3,
  t0.has_validation AS has_validation_4,
  t0.has_high_value AS has_high_value_5,
  t0.is_active AS is_active_6,
  t0.has_scrapper AS has_scrapper_7,
  t0.sources_upc AS sources_upc_8,
  t0.sources_merchant_sku AS sources_merchant_sku_9,
  t0.sources_category AS sources_category_10,
  t0.sources_name AS sources_name_11,
  t0.sources_msrp AS sources_msrp_12,
  t0.sources_photo AS sources_photo_13,
  t0.sources_action AS sources_action_14,
  t0.is_required_upc AS is_required_upc_15,
  t0.is_required_merchant_sku AS is_required_merchant_sku_16,
  t0.is_required_category AS is_required_category_17,
  t0.is_required_name AS is_required_name_18,
  t0.is_required_msrp AS is_required_msrp_19,
  t0.is_required_photo AS is_required_photo_20,
  t0.is_required_action AS is_required_action_21,
  t0.public_name AS public_name_22,
  t0.is_deleted AS is_deleted_23,
  t0.product_generic_link AS product_generic_link_24,
  t0.billing_name AS billing_name_25,
  t0.billing_address AS billing_address_26,
  t0.tax_name1 AS tax_name1_27,
  t0.tax_rate1 AS tax_rate1_28,
  t0.tax_name2 AS tax_name2_29,
  t0.tax_rate2 AS tax_rate2_30,
  t0.tax_number1 AS tax_number1_31,
  t0.tax_number2 AS tax_number2_32,
  t0.tax_currency AS tax_currency_33,
  t0.weight_per_pallet_feet AS weight_per_pallet_feet_34,
  t0.has_continuous_po AS has_continuous_po_35,
  t0.newsletter_default_subject AS newsletter_default_subject_36,
  t0.newsletter_default_preview_text AS newsletter_default_preview_text_37,
  t0.newsletter_default_header_line1 AS newsletter_default_header_line1_38,
  t0.newsletter_default_header_line2 AS newsletter_default_header_line2_39,
  t0.newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40,
  t0.newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41,
  t0.newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42,
  t0.scraper_class AS scraper_class_43,
  t0.has_splited_scraper AS has_splited_scraper_44,
  t0.has_synccentric_data AS has_synccentric_data_45,
  t0.has_upcitemdb_data AS has_upcitemdb_data_46,
  t0.apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47,
  t0.is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48,
  t0.shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49,
  t0.shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50,
  t0.user_group_id AS user_group_id_51
FROM
  supplier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.has_actions AS has_actions_3, t0.has_validation AS has_validation_4, t0.has_high_value AS has_high_value_5, t0.is_active AS is_active_6, t0.has_scrapper AS has_scrapper_7, t0.sources_upc AS sources_upc_8, t0.sources_merchant_sku AS sources_merchant_sku_9, t0.sources_category AS sources_category_10, t0.sources_name AS sources_name_11, t0.sources_msrp AS sources_msrp_12, t0.sources_photo AS sources_photo_13, t0.sources_action AS sources_action_14, t0.is_required_upc AS is_required_upc_15, t0.is_required_merchant_sku AS is_required_merchant_sku_16, t0.is_required_category AS is_required_category_17, t0.is_required_name AS is_required_name_18, t0.is_required_msrp AS is_required_msrp_19, t0.is_required_photo AS is_required_photo_20, t0.is_required_action AS is_required_action_21, t0.public_name AS public_name_22, t0.is_deleted AS is_deleted_23, t0.product_generic_link AS product_generic_link_24, t0.billing_name AS billing_name_25, t0.billing_address AS billing_address_26, t0.tax_name1 AS tax_name1_27, t0.tax_rate1 AS tax_rate1_28, t0.tax_name2 AS tax_name2_29, t0.tax_rate2 AS tax_rate2_30, t0.tax_number1 AS tax_number1_31, t0.tax_number2 AS tax_number2_32, t0.tax_currency AS tax_currency_33, t0.weight_per_pallet_feet AS weight_per_pallet_feet_34, t0.has_continuous_po AS has_continuous_po_35, t0.newsletter_default_subject AS newsletter_default_subject_36, t0.newsletter_default_preview_text AS newsletter_default_preview_text_37, t0.newsletter_default_header_line1 AS newsletter_default_header_line1_38, t0.newsletter_default_header_line2 AS newsletter_default_header_line2_39, t0.newsletter_default_footer_block_image AS newsletter_default_footer_block_image_40, t0.newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_41, t0.newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_42, t0.scraper_class AS scraper_class_43, t0.has_splited_scraper AS has_splited_scraper_44, t0.has_synccentric_data AS has_synccentric_data_45, t0.has_upcitemdb_data AS has_upcitemdb_data_46, t0.apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_47, t0.is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_48, t0.shared_scrapper_supplier_id AS shared_scrapper_supplier_id_49, t0.shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_50, t0.user_group_id AS user_group_id_51 FROM supplier t0 WHERE t0.id = 28;

#	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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Supplier::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Supplier->__get (line 315)
8	App\Entity\Supplier->getName (line 1802)
9	Twig\Extension\CoreExtension::getAttribute (line 58)
10	__TwigTemplate_c76325c7257040165eeef9722c8d5ef1->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 99)
19	App\Controller\Triage\TriageScanController->_scan (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.13 ms
(0.08%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.exchange_rate AS exchange_rate_3, t0.position AS position_4, t0.is_msrp_source AS is_msrp_source_5, t0.is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0.is_msrp_source = ? ORDER BY t0.position ASC

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.exchange_rate AS exchange_rate_3,
  t0.position AS position_4,
  t0.is_msrp_source AS is_msrp_source_5,
  t0.is_name_source AS is_name_source_6
FROM
  upcitemdb_source t0
WHERE
  t0.is_msrp_source = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.exchange_rate AS exchange_rate_3, t0.position AS position_4, t0.is_msrp_source AS is_msrp_source_5, t0.is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0.is_msrp_source = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 17)
4	App\Services\Analysis\Upcitemdb\UpcitemdbService->__construct (line 30)
5	Container84GFprE\getUpcitemdbServiceService::do (line 714)
6	Container84GFprE\App_KernelDevDebugContainer->load (line 29)
7	Container84GFprE\getUpcitemdbDataFactoryService::do (line 714)
8	Container84GFprE\App_KernelDevDebugContainer->load (line 49)
9	Container84GFprE\getProductFactoryService::do (line 714)
10	Container84GFprE\App_KernelDevDebugContainer->load (line 33)
11	Container84GFprE\getManifestItemFactoryService::do (line 714)
12	Container84GFprE\App_KernelDevDebugContainer->load (line 52)
13	Container84GFprE\getTriageScanServiceService::do (line 714)
14	Container84GFprE\App_KernelDevDebugContainer->load (line 404)
15	Symfony\Component\DependencyInjection\Container->getService (line 40)
16	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 84)
17	Symfony\Component\HttpKernel\Controller\ArgumentResolver\ServiceValueResolver->resolve (line 60)
18	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
19	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
20	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.13 ms
(0.08%)

UPDATE manifest_style SET is_active = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  manifest_style
SET
  is_active = ?
WHERE
  id = ?

UPDATE manifest_style SET is_active = 1 WHERE id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1277)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 82)
7	App\Services\Lot\LotItemFactory->addOrCreate (line 352)
8	App\Services\Triage\TriageScanService->confirm (line 60)
9	App\Controller\Triage\TriageScanController->_scan (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.12 ms
(0.07%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.position AS position_4, t0.gtm_value AS gtm_value_5, t0.facebook_value AS facebook_value_6 FROM `product_condition` t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.position AS position_4,
  t0.gtm_value AS gtm_value_5,
  t0.facebook_value AS facebook_value_6
FROM
  `product_condition` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.position AS position_4, t0.gtm_value AS gtm_value_5, t0.facebook_value AS facebook_value_6 FROM `product_condition` 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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Information\ProductCondition::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Information\ProductCondition->__get (line 109)
8	App\Entity\Information\ProductCondition->getName (line 1802)
9	Twig\Extension\CoreExtension::getAttribute (line 62)
10	__TwigTemplate_c76325c7257040165eeef9722c8d5ef1->doDisplay (line 393)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 99)
19	App\Controller\Triage\TriageScanController->_scan (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.12 ms
(0.07%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.exchange_rate AS exchange_rate_3, t0.position AS position_4, t0.is_msrp_source AS is_msrp_source_5, t0.is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0.is_name_source = ? ORDER BY t0.position ASC

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.exchange_rate AS exchange_rate_3,
  t0.position AS position_4,
  t0.is_msrp_source AS is_msrp_source_5,
  t0.is_name_source AS is_name_source_6
FROM
  upcitemdb_source t0
WHERE
  t0.is_name_source = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.exchange_rate AS exchange_rate_3, t0.position AS position_4, t0.is_msrp_source AS is_msrp_source_5, t0.is_name_source AS is_name_source_6 FROM upcitemdb_source t0 WHERE t0.is_name_source = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 22)
4	App\Services\Analysis\Upcitemdb\UpcitemdbService->__construct (line 30)
5	Container84GFprE\getUpcitemdbServiceService::do (line 714)
6	Container84GFprE\App_KernelDevDebugContainer->load (line 29)
7	Container84GFprE\getUpcitemdbDataFactoryService::do (line 714)
8	Container84GFprE\App_KernelDevDebugContainer->load (line 49)
9	Container84GFprE\getProductFactoryService::do (line 714)
10	Container84GFprE\App_KernelDevDebugContainer->load (line 33)
11	Container84GFprE\getManifestItemFactoryService::do (line 714)
12	Container84GFprE\App_KernelDevDebugContainer->load (line 52)
13	Container84GFprE\getTriageScanServiceService::do (line 714)
14	Container84GFprE\App_KernelDevDebugContainer->load (line 404)
15	Symfony\Component\DependencyInjection\Container->getService (line 40)
16	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 84)
17	Symfony\Component\HttpKernel\Controller\ArgumentResolver\ServiceValueResolver->resolve (line 60)
18	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
19	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
20	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.11 ms
(0.07%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM manifest_style t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3
FROM
  manifest_style t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3 FROM manifest_style t0 WHERE t0.id = 4;

#	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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Information\ManifestStyle::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Information\ManifestStyle->__get (line 45)
8	App\Entity\Information\ManifestStyle->getName (line 46)
9	App\Controller\Triage\TriageScanController->_scan (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.09 ms
(0.06%)

SELECT t0.id AS id_1, t0.active AS active_2, t0.last_scan_at AS last_scan_at_3, t0.po_id AS po_id_4, t0.user_id AS user_id_5 FROM triage_user t0 WHERE t0.po_id = ?

Parameters:

[
  2634
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.last_scan_at AS last_scan_at_3,
  t0.po_id AS po_id_4,
  t0.user_id AS user_id_5
FROM
  triage_user t0
WHERE
  t0.po_id = ?

SELECT t0.id AS id_1, t0.active AS active_2, t0.last_scan_at AS last_scan_at_3, t0.po_id AS po_id_4, t0.user_id AS user_id_5 FROM triage_user t0 WHERE t0.po_id = 2634;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 39)
8	App\Security\Voter\TriageScanVoter->voteOnAttribute (line 48)
9	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 38)
10	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 70)
11	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 37)
12	Symfony\Component\Security\Core\Authorization\Strategy\AffirmativeStrategy->decide (line 60)
13	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 60)
14	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 48)
15	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 205)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->isGranted (line 28)
17	App\Controller\Triage\TriageScanController->_scan (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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	The mappings App\Entity\User#assignedScanManifests and App\Entity\ScanManifestUser#user are inconsistent with each other. The association App\Entity\User#analysedProducts refers to the owning side field App\Entity\Product#analysedBy which does not exist. The association App\Entity\User#analyzedManifestItems refers to the owning side field App\Entity\ManifestItem#analysedBy which does not exist. The association App\Entity\User#warehouse refers to the inverse side field App\Entity\Warehouse#userss which does not exist. The mappings App\Entity\User#userMainTableSettings and App\Entity\UserMainTableSetting#user are inconsistent with each other.
App\Entity\Module	No errors.
App\Entity\Warehouse	The mappings App\Entity\Warehouse#users and App\Entity\User#warehouse are inconsistent with each other.
App\Entity\UserGroup	No errors.
App\Entity\ScanCategoryGroup	The association App\Entity\ScanCategoryGroup#reportPerformanceEntryGroups refers to the owning side field App\Entity\ReportPerformanceEntryGroup#ScanCategoryGroup which does not exist.
App\Entity\ScanManifestUser	The association App\Entity\ScanManifestUser#user refers to the inverse side field App\Entity\User#scanManifestUsers which does not exist.
App\Entity\Product	The mappings App\Entity\Product#analyzedBy and App\Entity\User#analysedProducts are inconsistent with each other.
App\Entity\ManifestItem	The association App\Entity\ManifestItem#po refers to the inverse side field App\Entity\Po#ManifestItems which does not exist. The mappings App\Entity\ManifestItem#analyzedBy and App\Entity\User#analyzedManifestItems are inconsistent with each other.
App\Entity\TriageUser	The field 'App\Entity\TriageUser#active' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\TriageScan	No errors.
App\Entity\ProductUpdateLog	No errors.
App\Entity\ScanSession	No errors.
App\Entity\UserMainTableSetting	The association App\Entity\UserMainTableSetting#user refers to the inverse side field App\Entity\User#userDashboardSettings which does not exist.
App\Entity\Supplier	The field 'App\Entity\Supplier#hasActions' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Supplier#hasValidation' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Supplier#hasHighValue' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Supplier#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Supplier#isDeleted' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\ReportScanGroup	No errors.
App\Entity\Front\OrderHistory	No errors.
App\Entity\StockUpdate	No errors.
App\Entity\Front\FrontProduct	No errors.
App\Entity\StockLocationUpdate	No errors.
App\Entity\UpcitemdbSource	No errors.
App\Entity\Po	The mappings App\Entity\Po#lots and App\Entity\Lot#po are inconsistent with each other. The mappings App\Entity\Po#manifestItems and App\Entity\ManifestItem#po are inconsistent with each other.
App\Entity\Information\PoStatus	No errors.
App\Entity\Information\ProductCondition	The field 'App\Entity\Information\ProductCondition#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Information\ManifestStyle	The field 'App\Entity\Information\ManifestStyle#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Information\InvoiceStyle	No errors.
App\Entity\Information\SupplierInvoiceState	No errors.
App\Entity\Category	The field 'App\Entity\Category#isUpdated' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Category#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The association App\Entity\Category#mappingCategories refers to the owning side field App\Entity\MappingCategory#mainCategory which does not exist. The mappings App\Entity\Category#lots and App\Entity\Lot#category are inconsistent with each other.
App\Entity\Lot	The field 'App\Entity\Lot#isHighValue' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Lot#isCp' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The association App\Entity\Lot#po refers to the inverse side field App\Entity\Po#numbers which does not exist. The association App\Entity\Lot#category refers to the inverse side field App\Entity\Category#isHighValue which does not exist. The field App\Entity\Lot#triageScans is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TriageScan#lot does not contain the required 'inversedBy="triageScans"' attribute.
App\Entity\ItemForAnalysis	No errors.
App\Entity\PreparationLot	The field 'App\Entity\PreparationLot#isEmpty' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\PreparationLot#isAction' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\PurchaseInvoice	No errors.
App\Entity\LotItem	No errors.
App\Entity\TruckloadLot	The field 'App\Entity\TruckloadLot#isCp' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\InvoiceCustomsData	No errors.
App\Entity\Newsletter	No errors.
App\Entity\LotItemOrigin	No errors.
App\Entity\Information\Action	The field 'App\Entity\Information\Action#isAvailableAnalysisChoice' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\TriageQuestion	No errors.
App\Entity\UniqueId	No errors.
App\Entity\LotPhoto	No errors.
App\Entity\CombinedManifestLot	No errors.
App\Entity\Front\WarehouseShippingMode	No errors.
App\Entity\Front\CartShippingMode	No errors.
App\Entity\Front\Order	The mappings App\Entity\Front\Order#billingAddress and App\Entity\Front\Address#orders are inconsistent with each other.
App\Entity\Location	No errors.
App\Entity\ProductConditionDiscount	No errors.
App\Entity\MappingCategory	The field 'App\Entity\MappingCategory#isUnmapped' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\CategoryAction	No errors.
App\Entity\SupplierProductConditionDiscount	No errors.
App\Entity\SupplierCategoryValue	No errors.
App\Entity\CategoryLang	No errors.
App\Entity\ReportStockRotationEntry	No errors.
App\Entity\Front\OrderCategoryDiscount	No errors.
App\Entity\MerchantSku	No errors.
App\Entity\ProductAction	No errors.
App\Entity\SpecialMerchantSku	No errors.
App\Entity\SpecialMsrp	No errors.
App\Entity\SpecialUpc	No errors.
App\Entity\SpecialName	No errors.
App\Entity\ReportPerformance	No errors.
App\Entity\SupplierLang	No errors.
App\Entity\DataImport	No errors.
App\Entity\Information\ProductConditionLang	No errors.
App\Entity\ReportPerformanceEntryGroup	The mappings App\Entity\ReportPerformanceEntryGroup#scanCategoryGroup and App\Entity\ScanCategoryGroup#reportPerformanceEntryGroups are inconsistent with each other.
App\Entity\Analysis\UpcItemDb	No errors.
App\Entity\ProductCpPhoto	No errors.
App\Entity\MarketingPhoto	No errors.
App\Entity\Analysis\Synccentric	No errors.
App\Entity\Front\OrderStatus	The field 'App\Entity\Front\OrderStatus#invoice' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Front\OrderStatus#sendEmail' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Front\OrderStatus#isLogable' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Front\OrderStatus#isDeleted' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Front\CartProduct	No errors.
App\Entity\Front\FrontProductImage	No errors.
App\Entity\Front\OrderFrontProduct	No errors.
App\Entity\Front\WhishListItem	No errors.
App\Entity\TruckloadFrontProduct	No errors.
App\Entity\Truckload	No errors.
App\Entity\Front\FrontProductListingProgress	No errors.
App\Entity\StockLocation	No errors.
App\Entity\TruckloadIncludedFrontProduct	No errors.
App\Entity\Front\Customer	The association App\Entity\Front\Customer#orderHistories refers to the owning side field App\Entity\Front\OrderHistory#customer which does not exist.
App\Entity\InvoiceCustomsDataDetail	No errors.
App\Entity\UploadedPhoto	No errors.
App\Entity\CombinedManifest	No errors.
App\Entity\Front\ShippingMode	The association App\Entity\Front\ShippingMode#taxRuleGroup refers to the inverse side field App\Entity\Front\TaxRuleGroup#shippingModes which does not exist.
App\Entity\Front\Cart	No errors.
App\Entity\Language	No errors.
App\Entity\Front\Address	The field App\Entity\Front\Address#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Front\Order#shippingAddress does not contain the required 'inversedBy="orders"' attribute.
App\Entity\Front\Country	No errors.
App\Entity\Front\State	No errors.
App\Entity\Front\OrderShippingTax	No errors.
App\Entity\Front\OrderPaymentIntent	No errors.
App\Entity\Front\OrderPayment	No errors.
App\Entity\Front\OrderDiscount	No errors.
App\Entity\Front\OrderDiscountTax	No errors.
App\Entity\Front\TaxRuleGroup	The field 'App\Entity\Front\TaxRuleGroup#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Front\TaxRuleGroup#isDeleted' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Front\OrderFrontProductTax	No errors.
App\Entity\Front\OrderRefund	No errors.
App\Entity\ReportStockRotation	No errors.

Symfony Profiler

GET https://www.rsystproject.com/triage/edit/2634/scan?actionName=confirm&actionValue=836351&ajax=1&triageScanId=5049860

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping