Symfony Profiler

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

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  po p0_

SELECT COUNT(p0_.id) AS sclr_0 FROM po p0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.display_name AS display_name_3,
  t0.is_sortable AS is_sortable_4,
  t0.has_toggle AS has_toggle_5,
  t0.has_search AS has_search_6,
  t0.has_filter AS has_filter_7,
  t0.filter_entity AS filter_entity_8,
  t0.is_supervisor_role_required AS is_supervisor_role_required_9,
  t0.is_admin_role_required AS is_admin_role_required_10,
  t0.background_css_class AS background_css_class_11,
  t0.has_column_total AS has_column_total_12,
  t0.has_custom_column_total AS has_custom_column_total_13,
  t0.module AS module_14,
  t0.template AS template_15,
  t0.position AS position_16,
  t0.filter_field_type AS filter_field_type_17,
  t0.has_date_comparison AS has_date_comparison_18
FROM
  main_table_column t0
WHERE
  t0.module = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.is_sortable AS is_sortable_4, t0.has_toggle AS has_toggle_5, t0.has_search AS has_search_6, t0.has_filter AS has_filter_7, t0.filter_entity AS filter_entity_8, t0.is_supervisor_role_required AS is_supervisor_role_required_9, t0.is_admin_role_required AS is_admin_role_required_10, t0.background_css_class AS background_css_class_11, t0.has_column_total AS has_column_total_12, t0.has_custom_column_total AS has_custom_column_total_13, t0.module AS module_14, t0.template AS template_15, t0.position AS position_16, t0.filter_field_type AS filter_field_type_17, t0.has_date_comparison AS has_date_comparison_18 FROM main_table_column t0 WHERE t0.module = 'analysis_index' ORDER BY t0.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.position AS position_2
FROM
  po_status p0_

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.position AS position_2 FROM po_status p0_;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.has_actions AS has_actions_2,
  s0_.has_validation AS has_validation_3,
  s0_.has_high_value AS has_high_value_4,
  s0_.is_active AS is_active_5,
  s0_.has_scrapper AS has_scrapper_6,
  s0_.sources_upc AS sources_upc_7,
  s0_.sources_merchant_sku AS sources_merchant_sku_8,
  s0_.sources_category AS sources_category_9,
  s0_.sources_name AS sources_name_10,
  s0_.sources_msrp AS sources_msrp_11,
  s0_.sources_photo AS sources_photo_12,
  s0_.sources_action AS sources_action_13,
  s0_.is_required_upc AS is_required_upc_14,
  s0_.is_required_merchant_sku AS is_required_merchant_sku_15,
  s0_.is_required_category AS is_required_category_16,
  s0_.is_required_name AS is_required_name_17,
  s0_.is_required_msrp AS is_required_msrp_18,
  s0_.is_required_photo AS is_required_photo_19,
  s0_.is_required_action AS is_required_action_20,
  s0_.public_name AS public_name_21,
  s0_.is_deleted AS is_deleted_22,
  s0_.product_generic_link AS product_generic_link_23,
  s0_.billing_name AS billing_name_24,
  s0_.billing_address AS billing_address_25,
  s0_.tax_name1 AS tax_name1_26,
  s0_.tax_rate1 AS tax_rate1_27,
  s0_.tax_name2 AS tax_name2_28,
  s0_.tax_rate2 AS tax_rate2_29,
  s0_.tax_number1 AS tax_number1_30,
  s0_.tax_number2 AS tax_number2_31,
  s0_.tax_currency AS tax_currency_32,
  s0_.weight_per_pallet_feet AS weight_per_pallet_feet_33,
  s0_.has_continuous_po AS has_continuous_po_34,
  s0_.newsletter_default_subject AS newsletter_default_subject_35,
  s0_.newsletter_default_preview_text AS newsletter_default_preview_text_36,
  s0_.newsletter_default_header_line1 AS newsletter_default_header_line1_37,
  s0_.newsletter_default_header_line2 AS newsletter_default_header_line2_38,
  s0_.newsletter_default_footer_block_image AS newsletter_default_footer_block_image_39,
  s0_.newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_40,
  s0_.newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_41,
  s0_.scraper_class AS scraper_class_42,
  s0_.has_splited_scraper AS has_splited_scraper_43,
  s0_.has_synccentric_data AS has_synccentric_data_44,
  s0_.has_upcitemdb_data AS has_upcitemdb_data_45,
  s0_.apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_46,
  s0_.is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_47,
  s0_.shared_scrapper_supplier_id AS shared_scrapper_supplier_id_48,
  s0_.shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_49,
  s0_.user_group_id AS user_group_id_50
FROM
  supplier s0_
WHERE
  s0_.is_active = '1'
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.has_actions AS has_actions_2, s0_.has_validation AS has_validation_3, s0_.has_high_value AS has_high_value_4, s0_.is_active AS is_active_5, s0_.has_scrapper AS has_scrapper_6, s0_.sources_upc AS sources_upc_7, s0_.sources_merchant_sku AS sources_merchant_sku_8, s0_.sources_category AS sources_category_9, s0_.sources_name AS sources_name_10, s0_.sources_msrp AS sources_msrp_11, s0_.sources_photo AS sources_photo_12, s0_.sources_action AS sources_action_13, s0_.is_required_upc AS is_required_upc_14, s0_.is_required_merchant_sku AS is_required_merchant_sku_15, s0_.is_required_category AS is_required_category_16, s0_.is_required_name AS is_required_name_17, s0_.is_required_msrp AS is_required_msrp_18, s0_.is_required_photo AS is_required_photo_19, s0_.is_required_action AS is_required_action_20, s0_.public_name AS public_name_21, s0_.is_deleted AS is_deleted_22, s0_.product_generic_link AS product_generic_link_23, s0_.billing_name AS billing_name_24, s0_.billing_address AS billing_address_25, s0_.tax_name1 AS tax_name1_26, s0_.tax_rate1 AS tax_rate1_27, s0_.tax_name2 AS tax_name2_28, s0_.tax_rate2 AS tax_rate2_29, s0_.tax_number1 AS tax_number1_30, s0_.tax_number2 AS tax_number2_31, s0_.tax_currency AS tax_currency_32, s0_.weight_per_pallet_feet AS weight_per_pallet_feet_33, s0_.has_continuous_po AS has_continuous_po_34, s0_.newsletter_default_subject AS newsletter_default_subject_35, s0_.newsletter_default_preview_text AS newsletter_default_preview_text_36, s0_.newsletter_default_header_line1 AS newsletter_default_header_line1_37, s0_.newsletter_default_header_line2 AS newsletter_default_header_line2_38, s0_.newsletter_default_footer_block_image AS newsletter_default_footer_block_image_39, s0_.newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_40, s0_.newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_41, s0_.scraper_class AS scraper_class_42, s0_.has_splited_scraper AS has_splited_scraper_43, s0_.has_synccentric_data AS has_synccentric_data_44, s0_.has_upcitemdb_data AS has_upcitemdb_data_45, s0_.apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_46, s0_.is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_47, s0_.shared_scrapper_supplier_id AS shared_scrapper_supplier_id_48, s0_.shared_merchant_sku_supplier_id AS shared_merchant_sku_supplier_id_49, s0_.user_group_id AS user_group_id_50 FROM supplier s0_ WHERE s0_.is_active = '1' ORDER BY s0_.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.is_active AS is_active_2,
  p0_.position AS position_3,
  p0_.gtm_value AS gtm_value_4,
  p0_.facebook_value AS facebook_value_5
FROM
  `product_condition` p0_
WHERE
  p0_.is_active = 1
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_active AS is_active_2, p0_.position AS position_3, p0_.gtm_value AS gtm_value_4, p0_.facebook_value AS facebook_value_5 FROM `product_condition` p0_ WHERE p0_.is_active = 1 ORDER BY p0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.search_number AS search_number_2,
  t0.toggle_columns AS toggle_columns_3,
  t0.results_per_page AS results_per_page_4,
  t0.colomn_width_remember AS colomn_width_remember_5,
  t0.table_width_remember AS table_width_remember_6,
  t0.module AS module_7,
  t0.user_id AS user_id_8
FROM
  user_main_table_setting t0
WHERE
  t0.user_id = ?
  AND t0.module = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.search_number AS search_number_2, t0.toggle_columns AS toggle_columns_3, t0.results_per_page AS results_per_page_4, t0.colomn_width_remember AS colomn_width_remember_5, t0.table_width_remember AS table_width_remember_6, t0.module AS module_7, t0.user_id AS user_id_8 FROM user_main_table_setting t0 WHERE t0.user_id = 26 AND t0.module = 'analysis_index' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.number AS number_1,
          p0_.active AS active_2,
          p0_.nb_pallet AS nb_pallet_3,
          p0_.nb_unit AS nb_unit_4,
          p0_.eta AS eta_5,
          p0_.received_at AS received_at_6,
          p0_.manifest_import AS manifest_import_7,
          p0_.note AS note_8,
          p0_.cost_po AS cost_po_9,
          p0_.cost_transport AS cost_transport_10,
          p0_.cost_customs AS cost_customs_11,
          p0_.msrp_value AS msrp_value_12,
          p0_.finances_selling_estimated AS finances_selling_estimated_13,
          p0_.seal_number_provided AS seal_number_provided_14,
          p0_.seal_number_received AS seal_number_received_15,
          p0_.nb_unit_received AS nb_unit_received_16,
          p0_.nb_pallet_received AS nb_pallet_received_17,
          p0_.seal_number_na AS seal_number_na_18,
          p0_.note_reception AS note_reception_19,
          p0_.location AS location_20,
          p0_.progress_step_reception AS progress_step_reception_21,
          p0_.progress_step_scan_manifest AS progress_step_scan_manifest_22,
          p0_.progress_step_import_manifest AS progress_step_import_manifest_23,
          p0_.progress_step_analysis AS progress_step_analysis_24,
          p0_.progress_step_preparation AS progress_step_preparation_25,
          p0_.progress_step_triage AS progress_step_triage_26,
          p0_.progress_step_photobooth AS progress_step_photobooth_27,
          p0_.progress_step_listing AS progress_step_listing_28,
          p0_.progress_step_conciliation AS progress_step_conciliation_29,
          p0_.preparation_total_units AS preparation_total_units_30,
          p0_.preparation_total_extended AS preparation_total_extended_31,
          p0_.preparation_total_selling_extended AS preparation_total_selling_extended_32,
          p0_.preparation_total_cps AS preparation_total_cps_33,
          p0_.preparation_total_lots AS preparation_total_lots_34,
          p0_.import_product_quantity AS import_product_quantity_35,
          p0_.import_unit_quantity AS import_unit_quantity_36,
          p0_.is_truckload AS is_truckload_37,
          p0_.progress_step_truckload AS progress_step_truckload_38,
          p0_.is_autoanalysis_running AS is_autoanalysis_running_39,
          p0_.is_autoanalysis_done AS is_autoanalysis_done_40,
          p0_.bol_supplier AS bol_supplier_41,
          p0_.customs_description AS customs_description_42,
          p0_.customs_country_of_origin AS customs_country_of_origin_43,
          p0_.customs_hs_code AS customs_hs_code_44,
          p0_.cost_production AS cost_production_45,
          p0_.next_cp_number AS next_cp_number_46,
          p0_.is_auto_triage AS is_auto_triage_47,
          p0_.is_lot_import_allowed AS is_lot_import_allowed_48,
          p0_.has_premade_lots AS has_premade_lots_49,
          p0_.is_auto_triage_truckload AS is_auto_triage_truckload_50,
          p0_.auto_triage_category_name AS auto_triage_category_name_51,
          p0_.auto_triage_category_discount AS auto_triage_category_discount_52,
          p0_.archived_at AS archived_at_53,
          p0_.is_final AS is_final_54,
          p0_.final_total_manifest_items AS final_total_manifest_items_55,
          p0_.final_total_analyzed_items AS final_total_analyzed_items_56,
          p0_.final_total_different_items AS final_total_different_items_57,
          p0_.final_total_triage_items AS final_total_triage_items_58,
          p0_.final_import_unit_quantity AS final_import_unit_quantity_59,
          p0_.final_total_hours AS final_total_hours_60,
          p0_.final_total_scans_per_hour AS final_total_scans_per_hour_61,
          p0_.final_msrp AS final_msrp_62,
          p0_.final_estimated_sales_listing AS final_estimated_sales_listing_63,
          p0_.final_selling_po AS final_selling_po_64,
          p0_.final_cog_real AS final_cog_real_65,
          p0_.final_nb_lots AS final_nb_lots_66,
          p0_.is_new_mappings_required AS is_new_mappings_required_67,
          p0_.auto_analysis_start_at AS auto_analysis_start_at_68,
          p0_.auto_analysis_end_at AS auto_analysis_end_at_69,
          p0_.current_synccentric_campaign AS current_synccentric_campaign_70,
          p0_.analysis_queue_priority AS analysis_queue_priority_71,
          p0_.is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_72,
          p0_.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_73,
          p0_.synccentric_export_current_page AS synccentric_export_current_page_74,
          p0_.synccentric_export_last_page AS synccentric_export_last_page_75,
          p0_.is_synccentric_search_required AS is_synccentric_search_required_76,
          p0_.is_synccentric_import_running AS is_synccentric_import_running_77,
          p0_.is_synccentric_import_done AS is_synccentric_import_done_78,
          p0_.is_synccentric_search_running AS is_synccentric_search_running_79,
          p0_.is_synccentric_search_done AS is_synccentric_search_done_80,
          p0_.is_synccentric_export_running AS is_synccentric_export_running_81,
          p0_.is_synccentric_export_done AS is_synccentric_export_done_82,
          p0_.is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_83,
          p0_.is_synccentric_import_started AS is_synccentric_import_started_84,
          p0_.is_synccentric_export_started AS is_synccentric_export_started_85,
          p0_.is_autoanalysis_started AS is_autoanalysis_started_86,
          p0_.has_supplier_pallet_numbers AS has_supplier_pallet_numbers_87,
          p0_.has_batch_ids AS has_batch_ids_88,
          p1_.id AS id_89,
          p1_.name AS name_90,
          p1_.position AS position_91,
          s2_.id AS id_92,
          s2_.name AS name_93,
          s2_.has_actions AS has_actions_94,
          s2_.has_validation AS has_validation_95,
          s2_.has_high_value AS has_high_value_96,
          s2_.is_active AS is_active_97,
          s2_.has_scrapper AS has_scrapper_98,
          s2_.sources_upc AS sources_upc_99,
          s2_.sources_merchant_sku AS sources_merchant_sku_100,
          s2_.sources_category AS sources_category_101,
          s2_.sources_name AS sources_name_102,
          s2_.sources_msrp AS sources_msrp_103,
          s2_.sources_photo AS sources_photo_104,
          s2_.sources_action AS sources_action_105,
          s2_.is_required_upc AS is_required_upc_106,
          s2_.is_required_merchant_sku AS is_required_merchant_sku_107,
          s2_.is_required_category AS is_required_category_108,
          s2_.is_required_name AS is_required_name_109,
          s2_.is_required_msrp AS is_required_msrp_110,
          s2_.is_required_photo AS is_required_photo_111,
          s2_.is_required_action AS is_required_action_112,
          s2_.public_name AS public_name_113,
          s2_.is_deleted AS is_deleted_114,
          s2_.product_generic_link AS product_generic_link_115,
          s2_.billing_name AS billing_name_116,
          s2_.billing_address AS billing_address_117,
          s2_.tax_name1 AS tax_name1_118,
          s2_.tax_rate1 AS tax_rate1_119,
          s2_.tax_name2 AS tax_name2_120,
          s2_.tax_rate2 AS tax_rate2_121,
          s2_.tax_number1 AS tax_number1_122,
          s2_.tax_number2 AS tax_number2_123,
          s2_.tax_currency AS tax_currency_124,
          s2_.weight_per_pallet_feet AS weight_per_pallet_feet_125,
          s2_.has_continuous_po AS has_continuous_po_126,
          s2_.newsletter_default_subject AS newsletter_default_subject_127,
          s2_.newsletter_default_preview_text AS newsletter_default_preview_text_128,
          s2_.newsletter_default_header_line1 AS newsletter_default_header_line1_129,
          s2_.newsletter_default_header_line2 AS newsletter_default_header_line2_130,
          s2_.newsletter_default_footer_block_image AS newsletter_default_footer_block_image_131,
          s2_.newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_132,
          s2_.newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_133,
          s2_.scraper_class AS scraper_class_134,
          s2_.has_splited_scraper AS has_splited_scraper_135,
          s2_.has_synccentric_data AS has_synccentric_data_136,
          s2_.has_upcitemdb_data AS has_upcitemdb_data_137,
          s2_.apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_138,
          s2_.is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_139,
          p3_.id AS id_140,
          p3_.name AS name_141,
          p3_.is_active AS is_active_142,
          p3_.position AS position_143,
          p3_.gtm_value AS gtm_value_144,
          p3_.facebook_value AS facebook_value_145,
          w4_.id AS id_146,
          w4_.name AS name_147,
          w4_.number AS number_148,
          w4_.contact_main_name AS contact_main_name_149,
          w4_.contact_main_phone AS contact_main_phone_150,
          w4_.contact_main_extension AS contact_main_extension_151,
          w4_.contact_main_email AS contact_main_email_152,
          w4_.contact_director_name AS contact_director_name_153,
          w4_.contact_director_phone AS contact_director_phone_154,
          w4_.contact_director_extension AS contact_director_extension_155,
          w4_.contact_director_email AS contact_director_email_156,
          w4_.contact_supervisor_name AS contact_supervisor_name_157,
          w4_.contact_supervisor_phone AS contact_supervisor_phone_158,
          w4_.contact_supervisor_extension AS contact_supervisor_extension_159,
          w4_.contact_supervisor_email AS contact_supervisor_email_160,
          w4_.contact_shipping_name AS contact_shipping_name_161,
          w4_.contact_shipping_phone AS contact_shipping_phone_162,
          w4_.contact_shipping_extension AS contact_shipping_extension_163,
          w4_.contact_shipping_email AS contact_shipping_email_164,
          w4_.contact_billing_name AS contact_billing_name_165,
          w4_.contact_billing_phone AS contact_billing_phone_166,
          w4_.contact_billing_extension AS contact_billing_extension_167,
          w4_.contact_billing_email AS contact_billing_email_168,
          w4_.email AS email_169,
          w4_.is_active AS is_active_170,
          w4_.shipping_state AS shipping_state_171,
          w4_.shipping_country AS shipping_country_172,
          w4_.shipping_postcode AS shipping_postcode_173,
          w4_.is_deleted AS is_deleted_174,
          m5_.id AS id_175,
          m5_.name AS name_176,
          m5_.is_active AS is_active_177,
          s6_.id AS id_178,
          s6_.name AS name_179,
          l7_.id AS id_180,
          l7_.number AS number_181,
          l7_.package_units AS package_units_182,
          l7_.weight AS weight_183,
          l7_.user AS user_184,
          l7_.format AS format_185,
          l7_.photos AS photos_186,
          l7_.name AS name_187,
          l7_.extended AS extended_188,
          l7_.units AS units_189,
          l7_.discount AS discount_190,
          l7_.estimated_sales AS estimated_sales_191,
          l7_.is_initialized AS is_initialized_192,
          l7_.msrp_current AS msrp_current_193,
          l7_.is_closed AS is_closed_194,
          l7_.is_high_value AS is_high_value_195,
          l7_.is_cp AS is_cp_196,
          l7_.estimated_sales_min_target AS estimated_sales_min_target_197,
          l7_.estimated_sales_max_target AS estimated_sales_max_target_198,
          l7_.display_name AS display_name_199,
          l7_.quantity AS quantity_200,
          l7_.cp_quantity AS cp_quantity_201,
          l7_.is_truckload AS is_truckload_202,
          l7_.is_photos_compressed AS is_photos_compressed_203,
          l7_.is_destroy AS is_destroy_204,
          l7_.package_sizes AS package_sizes_205,
          l7_.is_listing_done AS is_listing_done_206,
          l7_.discount_triage AS discount_triage_207,
          l7_.volumetric_weight AS volumetric_weight_208,
          l7_.real_weight AS real_weight_209,
          l7_.previous_number AS previous_number_210,
          l7_.is_oversize AS is_oversize_211,
          l7_.cost AS cost_212,
          l7_.is_imported AS is_imported_213,
          l7_.supplier_pallet_number AS supplier_pallet_number_214,
          l7_.created_at AS created_at_215,
          l7_.updated_at AS updated_at_216,
          p8_.id AS id_217,
          p8_.type AS type_218,
          p8_.status AS status_219,
          p8_.number AS number_220,
          p9_.id AS id_221,
          p9_.type AS type_222,
          p9_.status AS status_223,
          p9_.number AS number_224,
          p10_.id AS id_225,
          p10_.type AS type_226,
          p10_.status AS status_227,
          p10_.number AS number_228
        FROM
          po p0_
          LEFT JOIN po_status p1_ ON p0_.status_id = p1_.id
          LEFT JOIN supplier s2_ ON p0_.supplier_id = s2_.id
          LEFT JOIN `product_condition` p3_ ON p0_.product_condition_id = p3_.id
          LEFT JOIN warehouse w4_ ON p0_.warehouse_id = w4_.id
          LEFT JOIN manifest_style m5_ ON p0_.manifest_style_id = m5_.id
          LEFT JOIN supplier_invoice_state s6_ ON p0_.supplier_invoice_state_id = s6_.id
          LEFT JOIN lot l7_ ON p0_.id = l7_.po_id
          LEFT JOIN purchase_invoice p8_ ON p0_.id = p8_.po_id
          AND (p8_.type = 1)
          LEFT JOIN purchase_invoice p9_ ON p0_.id = p9_.po_id
          AND (p9_.type = 2)
          LEFT JOIN purchase_invoice p10_ ON p0_.id = p10_.po_id
          AND (p10_.type = 3)
        WHERE
          p0_.status_id < '3'
          AND (
            p0_.progress_step_reception > 2
            OR p0_.manifest_style_id = '2'
          )
          AND p0_.progress_step_import_manifest > 4
          AND p0_.progress_step_scan_manifest > 4
          AND p0_.progress_step_analysis < 5
        ORDER BY
          p0_.number ASC,
          l7_.number ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.number AS number_1, p0_.active AS active_2, p0_.nb_pallet AS nb_pallet_3, p0_.nb_unit AS nb_unit_4, p0_.eta AS eta_5, p0_.received_at AS received_at_6, p0_.manifest_import AS manifest_import_7, p0_.note AS note_8, p0_.cost_po AS cost_po_9, p0_.cost_transport AS cost_transport_10, p0_.cost_customs AS cost_customs_11, p0_.msrp_value AS msrp_value_12, p0_.finances_selling_estimated AS finances_selling_estimated_13, p0_.seal_number_provided AS seal_number_provided_14, p0_.seal_number_received AS seal_number_received_15, p0_.nb_unit_received AS nb_unit_received_16, p0_.nb_pallet_received AS nb_pallet_received_17, p0_.seal_number_na AS seal_number_na_18, p0_.note_reception AS note_reception_19, p0_.location AS location_20, p0_.progress_step_reception AS progress_step_reception_21, p0_.progress_step_scan_manifest AS progress_step_scan_manifest_22, p0_.progress_step_import_manifest AS progress_step_import_manifest_23, p0_.progress_step_analysis AS progress_step_analysis_24, p0_.progress_step_preparation AS progress_step_preparation_25, p0_.progress_step_triage AS progress_step_triage_26, p0_.progress_step_photobooth AS progress_step_photobooth_27, p0_.progress_step_listing AS progress_step_listing_28, p0_.progress_step_conciliation AS progress_step_conciliation_29, p0_.preparation_total_units AS preparation_total_units_30, p0_.preparation_total_extended AS preparation_total_extended_31, p0_.preparation_total_selling_extended AS preparation_total_selling_extended_32, p0_.preparation_total_cps AS preparation_total_cps_33, p0_.preparation_total_lots AS preparation_total_lots_34, p0_.import_product_quantity AS import_product_quantity_35, p0_.import_unit_quantity AS import_unit_quantity_36, p0_.is_truckload AS is_truckload_37, p0_.progress_step_truckload AS progress_step_truckload_38, p0_.is_autoanalysis_running AS is_autoanalysis_running_39, p0_.is_autoanalysis_done AS is_autoanalysis_done_40, p0_.bol_supplier AS bol_supplier_41, p0_.customs_description AS customs_description_42, p0_.customs_country_of_origin AS customs_country_of_origin_43, p0_.customs_hs_code AS customs_hs_code_44, p0_.cost_production AS cost_production_45, p0_.next_cp_number AS next_cp_number_46, p0_.is_auto_triage AS is_auto_triage_47, p0_.is_lot_import_allowed AS is_lot_import_allowed_48, p0_.has_premade_lots AS has_premade_lots_49, p0_.is_auto_triage_truckload AS is_auto_triage_truckload_50, p0_.auto_triage_category_name AS auto_triage_category_name_51, p0_.auto_triage_category_discount AS auto_triage_category_discount_52, p0_.archived_at AS archived_at_53, p0_.is_final AS is_final_54, p0_.final_total_manifest_items AS final_total_manifest_items_55, p0_.final_total_analyzed_items AS final_total_analyzed_items_56, p0_.final_total_different_items AS final_total_different_items_57, p0_.final_total_triage_items AS final_total_triage_items_58, p0_.final_import_unit_quantity AS final_import_unit_quantity_59, p0_.final_total_hours AS final_total_hours_60, p0_.final_total_scans_per_hour AS final_total_scans_per_hour_61, p0_.final_msrp AS final_msrp_62, p0_.final_estimated_sales_listing AS final_estimated_sales_listing_63, p0_.final_selling_po AS final_selling_po_64, p0_.final_cog_real AS final_cog_real_65, p0_.final_nb_lots AS final_nb_lots_66, p0_.is_new_mappings_required AS is_new_mappings_required_67, p0_.auto_analysis_start_at AS auto_analysis_start_at_68, p0_.auto_analysis_end_at AS auto_analysis_end_at_69, p0_.current_synccentric_campaign AS current_synccentric_campaign_70, p0_.analysis_queue_priority AS analysis_queue_priority_71, p0_.is_prepare_autoanalysis_running AS is_prepare_autoanalysis_running_72, p0_.is_prepare_autoanalysis_done AS is_prepare_autoanalysis_done_73, p0_.synccentric_export_current_page AS synccentric_export_current_page_74, p0_.synccentric_export_last_page AS synccentric_export_last_page_75, p0_.is_synccentric_search_required AS is_synccentric_search_required_76, p0_.is_synccentric_import_running AS is_synccentric_import_running_77, p0_.is_synccentric_import_done AS is_synccentric_import_done_78, p0_.is_synccentric_search_running AS is_synccentric_search_running_79, p0_.is_synccentric_search_done AS is_synccentric_search_done_80, p0_.is_synccentric_export_running AS is_synccentric_export_running_81, p0_.is_synccentric_export_done AS is_synccentric_export_done_82, p0_.is_prepare_autoanalysis_started AS is_prepare_autoanalysis_started_83, p0_.is_synccentric_import_started AS is_synccentric_import_started_84, p0_.is_synccentric_export_started AS is_synccentric_export_started_85, p0_.is_autoanalysis_started AS is_autoanalysis_started_86, p0_.has_supplier_pallet_numbers AS has_supplier_pallet_numbers_87, p0_.has_batch_ids AS has_batch_ids_88, p1_.id AS id_89, p1_.name AS name_90, p1_.position AS position_91, s2_.id AS id_92, s2_.name AS name_93, s2_.has_actions AS has_actions_94, s2_.has_validation AS has_validation_95, s2_.has_high_value AS has_high_value_96, s2_.is_active AS is_active_97, s2_.has_scrapper AS has_scrapper_98, s2_.sources_upc AS sources_upc_99, s2_.sources_merchant_sku AS sources_merchant_sku_100, s2_.sources_category AS sources_category_101, s2_.sources_name AS sources_name_102, s2_.sources_msrp AS sources_msrp_103, s2_.sources_photo AS sources_photo_104, s2_.sources_action AS sources_action_105, s2_.is_required_upc AS is_required_upc_106, s2_.is_required_merchant_sku AS is_required_merchant_sku_107, s2_.is_required_category AS is_required_category_108, s2_.is_required_name AS is_required_name_109, s2_.is_required_msrp AS is_required_msrp_110, s2_.is_required_photo AS is_required_photo_111, s2_.is_required_action AS is_required_action_112, s2_.public_name AS public_name_113, s2_.is_deleted AS is_deleted_114, s2_.product_generic_link AS product_generic_link_115, s2_.billing_name AS billing_name_116, s2_.billing_address AS billing_address_117, s2_.tax_name1 AS tax_name1_118, s2_.tax_rate1 AS tax_rate1_119, s2_.tax_name2 AS tax_name2_120, s2_.tax_rate2 AS tax_rate2_121, s2_.tax_number1 AS tax_number1_122, s2_.tax_number2 AS tax_number2_123, s2_.tax_currency AS tax_currency_124, s2_.weight_per_pallet_feet AS weight_per_pallet_feet_125, s2_.has_continuous_po AS has_continuous_po_126, s2_.newsletter_default_subject AS newsletter_default_subject_127, s2_.newsletter_default_preview_text AS newsletter_default_preview_text_128, s2_.newsletter_default_header_line1 AS newsletter_default_header_line1_129, s2_.newsletter_default_header_line2 AS newsletter_default_header_line2_130, s2_.newsletter_default_footer_block_image AS newsletter_default_footer_block_image_131, s2_.newsletter_default_view_all_link_text AS newsletter_default_view_all_link_text_132, s2_.newsletter_default_view_all_link_background_color AS newsletter_default_view_all_link_background_color_133, s2_.scraper_class AS scraper_class_134, s2_.has_splited_scraper AS has_splited_scraper_135, s2_.has_synccentric_data AS has_synccentric_data_136, s2_.has_upcitemdb_data AS has_upcitemdb_data_137, s2_.apply_max_quantity_same_lot_item AS apply_max_quantity_same_lot_item_138, s2_.is_triage_autoanalysis_allowed AS is_triage_autoanalysis_allowed_139, p3_.id AS id_140, p3_.name AS name_141, p3_.is_active AS is_active_142, p3_.position AS position_143, p3_.gtm_value AS gtm_value_144, p3_.facebook_value AS facebook_value_145, w4_.id AS id_146, w4_.name AS name_147, w4_.number AS number_148, w4_.contact_main_name AS contact_main_name_149, w4_.contact_main_phone AS contact_main_phone_150, w4_.contact_main_extension AS contact_main_extension_151, w4_.contact_main_email AS contact_main_email_152, w4_.contact_director_name AS contact_director_name_153, w4_.contact_director_phone AS contact_director_phone_154, w4_.contact_director_extension AS contact_director_extension_155, w4_.contact_director_email AS contact_director_email_156, w4_.contact_supervisor_name AS contact_supervisor_name_157, w4_.contact_supervisor_phone AS contact_supervisor_phone_158, w4_.contact_supervisor_extension AS contact_supervisor_extension_159, w4_.contact_supervisor_email AS contact_supervisor_email_160, w4_.contact_shipping_name AS contact_shipping_name_161, w4_.contact_shipping_phone AS contact_shipping_phone_162, w4_.contact_shipping_extension AS contact_shipping_extension_163, w4_.contact_shipping_email AS contact_shipping_email_164, w4_.contact_billing_name AS contact_billing_name_165, w4_.contact_billing_phone AS contact_billing_phone_166, w4_.contact_billing_extension AS contact_billing_extension_167, w4_.contact_billing_email AS contact_billing_email_168, w4_.email AS email_169, w4_.is_active AS is_active_170, w4_.shipping_state AS shipping_state_171, w4_.shipping_country AS shipping_country_172, w4_.shipping_postcode AS shipping_postcode_173, w4_.is_deleted AS is_deleted_174, m5_.id AS id_175, m5_.name AS name_176, m5_.is_active AS is_active_177, s6_.id AS id_178, s6_.name AS name_179, l7_.id AS id_180, l7_.number AS number_181, l7_.package_units AS package_units_182, l7_.weight AS weight_183, l7_.user AS user_184, l7_.format AS format_185, l7_.photos AS photos_186, l7_.name AS name_187, l7_.extended AS extended_188, l7_.units AS units_189, l7_.discount AS discount_190, l7_.estimated_sales AS estimated_sales_191, l7_.is_initialized AS is_initialized_192, l7_.msrp_current AS msrp_current_193, l7_.is_closed AS is_closed_194, l7_.is_high_value AS is_high_value_195, l7_.is_cp AS is_cp_196, l7_.estimated_sales_min_target AS estimated_sales_min_target_197, l7_.estimated_sales_max_target AS estimated_sales_max_target_198, l7_.display_name AS display_name_199, l7_.quantity AS quantity_200, l7_.cp_quantity AS cp_quantity_201, l7_.is_truckload AS is_truckload_202, l7_.is_photos_compressed AS is_photos_compressed_203, l7_.is_destroy AS is_destroy_204, l7_.package_sizes AS package_sizes_205, l7_.is_listing_done AS is_listing_done_206, l7_.discount_triage AS discount_triage_207, l7_.volumetric_weight AS volumetric_weight_208, l7_.real_weight AS real_weight_209, l7_.previous_number AS previous_number_210, l7_.is_oversize AS is_oversize_211, l7_.cost AS cost_212, l7_.is_imported AS is_imported_213, l7_.supplier_pallet_number AS supplier_pallet_number_214, l7_.created_at AS created_at_215, l7_.updated_at AS updated_at_216, p8_.id AS id_217, p8_.type AS type_218, p8_.status AS status_219, p8_.number AS number_220, p9_.id AS id_221, p9_.type AS type_222, p9_.status AS status_223, p9_.number AS number_224, p10_.id AS id_225, p10_.type AS type_226, p10_.status AS status_227, p10_.number AS number_228 FROM po p0_ LEFT JOIN po_status p1_ ON p0_.status_id = p1_.id LEFT JOIN supplier s2_ ON p0_.supplier_id = s2_.id LEFT JOIN `product_condition` p3_ ON p0_.product_condition_id = p3_.id LEFT JOIN warehouse w4_ ON p0_.warehouse_id = w4_.id LEFT JOIN manifest_style m5_ ON p0_.manifest_style_id = m5_.id LEFT JOIN supplier_invoice_state s6_ ON p0_.supplier_invoice_state_id = s6_.id LEFT JOIN lot l7_ ON p0_.id = l7_.po_id LEFT JOIN purchase_invoice p8_ ON p0_.id = p8_.po_id AND (p8_.type = 1) LEFT JOIN purchase_invoice p9_ ON p0_.id = p9_.po_id AND (p9_.type = 2) LEFT JOIN purchase_invoice p10_ ON p0_.id = p10_.po_id AND (p10_.type = 3) WHERE p0_.status_id < '3' AND (p0_.progress_step_reception > 2 OR p0_.manifest_style_id = '2') AND p0_.progress_step_import_manifest > 4 AND p0_.progress_step_scan_manifest > 4 AND p0_.progress_step_analysis < 5 ORDER BY p0_.number ASC, l7_.number ASC) dctrn_result) dctrn_table;