Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.94 ms Query time

16 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.27 ms

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:

[
  68
]

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 = 68;

#	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.34 ms

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.supplier_pallet_number AS supplier_pallet_number_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.po_id AS po_id_38, t0.category_id AS category_id_39, t0.cp_product_id AS cp_product_id_40, t0.product_condition_id AS product_condition_id_41, t0.merged_with_id AS merged_with_id_42, t0.preparation_lot_id AS preparation_lot_id_43, t0.previous_po_id AS previous_po_id_44, t0.related_front_product_id AS related_front_product_id_45 FROM lot t0 WHERE t0.id = ?

Parameters:

[
  "58697"
]

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.supplier_pallet_number AS supplier_pallet_number_35,
  t0.created_at AS created_at_36,
  t0.updated_at AS updated_at_37,
  t0.po_id AS po_id_38,
  t0.category_id AS category_id_39,
  t0.cp_product_id AS cp_product_id_40,
  t0.product_condition_id AS product_condition_id_41,
  t0.merged_with_id AS merged_with_id_42,
  t0.preparation_lot_id AS preparation_lot_id_43,
  t0.previous_po_id AS previous_po_id_44,
  t0.related_front_product_id AS related_front_product_id_45
FROM
  lot t0
WHERE
  t0.id = ?

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.supplier_pallet_number AS supplier_pallet_number_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.po_id AS po_id_38, t0.category_id AS category_id_39, t0.cp_product_id AS cp_product_id_40, t0.product_condition_id AS product_condition_id_41, t0.merged_with_id AS merged_with_id_42, t0.preparation_lot_id AS preparation_lot_id_43, t0.previous_po_id AS previous_po_id_44, t0.related_front_product_id AS related_front_product_id_45 FROM lot t0 WHERE t0.id = '58697';

#	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.20 ms

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.has_supplier_pallet_numbers AS has_supplier_pallet_numbers_88, t0.has_batch_ids AS has_batch_ids_89, t0.status_id AS status_id_90, t0.supplier_id AS supplier_id_91, t0.product_condition_id AS product_condition_id_92, t0.manifest_style_id AS manifest_style_id_93, t0.invoice_style_id AS invoice_style_id_94, t0.supplier_invoice_state_id AS supplier_invoice_state_id_95, t0.warehouse_id AS warehouse_id_96, t0.auto_triage_category_id AS auto_triage_category_id_97 FROM po t0 WHERE t0.id = ?

Parameters:

[
  3384
]

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.has_supplier_pallet_numbers AS has_supplier_pallet_numbers_88,
  t0.has_batch_ids AS has_batch_ids_89,
  t0.status_id AS status_id_90,
  t0.supplier_id AS supplier_id_91,
  t0.product_condition_id AS product_condition_id_92,
  t0.manifest_style_id AS manifest_style_id_93,
  t0.invoice_style_id AS invoice_style_id_94,
  t0.supplier_invoice_state_id AS supplier_invoice_state_id_95,
  t0.warehouse_id AS warehouse_id_96,
  t0.auto_triage_category_id AS auto_triage_category_id_97
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.has_supplier_pallet_numbers AS has_supplier_pallet_numbers_88, t0.has_batch_ids AS has_batch_ids_89, t0.status_id AS status_id_90, t0.supplier_id AS supplier_id_91, t0.product_condition_id AS product_condition_id_92, t0.manifest_style_id AS manifest_style_id_93, t0.invoice_style_id AS invoice_style_id_94, t0.supplier_invoice_state_id AS supplier_invoice_state_id_95, t0.warehouse_id AS warehouse_id_96, t0.auto_triage_category_id AS auto_triage_category_id_97 FROM po t0 WHERE t0.id = 3384;

#	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\Po::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Po->__get (line 482)
8	App\Entity\Po->getNumber (line 133)
9	App\Controller\PhotoBoothController->pictures (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)

1.13 ms

SELECT t0.id AS id_1, t0.position AS position_2, t0.lot_id AS lot_id_3, t0.uploaded_photo_id AS uploaded_photo_id_4 FROM lot_photo t0 WHERE t0.lot_id = ?

Parameters:

[
  58697
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.lot_id AS lot_id_3,
  t0.uploaded_photo_id AS uploaded_photo_id_4
FROM
  lot_photo t0
WHERE
  t0.lot_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.lot_id AS lot_id_3, t0.uploaded_photo_id AS uploaded_photo_id_4 FROM lot_photo t0 WHERE t0.lot_id = 58697;

#	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 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 1218)
9	Twig\Extension\CoreExtension::length (line 53)
10	__TwigTemplate_ef8762a14f86e2175c7cb8c2cd4c2b4c->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 135)
19	App\Controller\PhotoBoothController->pictures (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)

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. The mappings App\Entity\Product#internalSkus and App\Entity\InternalSku#product 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. The mappings App\Entity\ManifestItem#internalSkus and App\Entity\InternalSku#manifestItem 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\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\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\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\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\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\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\LotPhoto	No errors.
App\Entity\CombinedManifestLot	No errors.
App\Entity\Information\PoStatus	No errors.
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\PurchaseInvoice	No errors.
App\Entity\InvoiceCustomsData	No errors.
App\Entity\Newsletter	No errors.
App\Entity\LotItemOrigin	No errors.
App\Entity\BatchId	No errors.
App\Entity\ImportData	No errors.
App\Entity\UploadedPhoto	No errors.

Symfony Profiler

GET https://www.rsystproject.com/photobooth/pictures/58697

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping