Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

0.77 ms Query time

17 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.29 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:

[
  118
]

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

#	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.17 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:

[
  "3109"
]

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 = '3109';

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

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:

[
  64
]

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

#	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 126)
12	__TwigTemplate_059141f6867eb56001058bb9b21561d5->block_body (line 437)
13	Twig\Template->yieldBlock (line 233)
14	__TwigTemplate_97b0c6d7d112b2a13512e180a6656239->doDisplay (line 393)
15	Twig\Template->yield (line 55)
16	__TwigTemplate_059141f6867eb56001058bb9b21561d5->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 53)
25	App\Controller\Triage\TriageController->edit (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.13 ms

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 126)
12	__TwigTemplate_059141f6867eb56001058bb9b21561d5->block_body (line 437)
13	Twig\Template->yieldBlock (line 233)
14	__TwigTemplate_97b0c6d7d112b2a13512e180a6656239->doDisplay (line 393)
15	Twig\Template->yield (line 55)
16	__TwigTemplate_059141f6867eb56001058bb9b21561d5->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 53)
25	App\Controller\Triage\TriageController->edit (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)

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\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\BatchId	No errors.
App\Entity\MerchantSku	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\ProductAction	No errors.
App\Entity\CategoryAction	No errors.
App\Entity\SpecialMerchantSku	No errors.
App\Entity\SupplierProductConditionDiscount	No errors.
App\Entity\SupplierCategoryValue	No errors.
App\Entity\SpecialMsrp	No errors.
App\Entity\SpecialUpc	No errors.
App\Entity\SpecialName	No errors.
App\Entity\ReportPerformance	No errors.
App\Entity\ReportStockRotationEntry	No errors.
App\Entity\SupplierLang	No errors.
App\Entity\DataImport	No errors.
App\Entity\ProductConditionDiscount	No errors.
App\Entity\Information\ProductConditionLang	No errors.

Symfony Profiler

GET https://www.rsystproject.com/triage/edit/3109

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping