Symfony Profiler

[
  "route" => "app_product_index_ajax"
  "route_parameters" => [
    "_route" => "app_product_index_ajax"
    "_controller" => "App\Controller\ProductController::ajaxList"
  ]
  "request_uri" => "https://zeltoadmin.juodaskodas.lt/product/ajax/list"
  "method" => "POST"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\SwitchUserToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "dev_zelto"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "dev_zelto"
    "serverVersion" => "8.0.46"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM admin t0 WHERE t0.email = ? LIMIT 1"
  "params" => [
    1 => "dominykas409@gmail.com"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.company_name AS company_name_5, t0.company_code AS company_code_6, t0.individual_activity_certificate_number AS individual_activity_certificate_number_7, t0.city AS city_8, t0.address AS address_9, t0.zip AS zip_10, t0.iban AS iban_11, t0.comment AS comment_12, t0.phone AS phone_13, t0.contact_name AS contact_name_14, t0.contact_email AS contact_email_15, t0.contact_phone AS contact_phone_16, t0.fee_percent AS fee_percent_17, t0.shop_title AS shop_title_18, t0.vat_code AS vat_code_19, t0.oss_registered AS oss_registered_20, t0.office_address AS office_address_21, t0.customer_phone AS customer_phone_22, t0.customer_email AS customer_email_23, t0.bank_name AS bank_name_24, t0.swift AS swift_25, t0.invoice_email AS invoice_email_26, t0.return_country AS return_country_27, t0.return_city AS return_city_28, t0.return_address AS return_address_29, t0.return_post_code AS return_post_code_30, t0.return_phone AS return_phone_31, t0.return_email AS return_email_32, t0.pickup_workdays AS pickup_workdays_33, t0.pickup_hours_from AS pickup_hours_from_34, t0.pickup_hours_to AS pickup_hours_to_35, t0.delivery_hours AS delivery_hours_36, t0.delivery_apply_all AS delivery_apply_all_37, t0.delivery_methods AS delivery_methods_38, t0.ai_pricing_strategy AS ai_pricing_strategy_39, t0.auto_price_reduction_enabled AS auto_price_reduction_enabled_40, t0.auto_price_reduction_days AS auto_price_reduction_days_41, t0.auto_price_reduction_percent AS auto_price_reduction_percent_42, t0.notify_product_sold AS notify_product_sold_43, t0.notify_new_message AS notify_new_message_44, t0.notify_ai_price_change AS notify_ai_price_change_45, t0.notify_return_request AS notify_return_request_46, t0.notify_weekly_report AS notify_weekly_report_47, t0.notify_low_inventory AS notify_low_inventory_48, t0.holiday_mode AS holiday_mode_49 FROM seller t0 WHERE t0.email = ? LIMIT 1"
  "params" => [
    1 => "dominykas409@gmail.com"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "provider" => "App\Security\CombinedUserProvider"
  "username" => "dominykas409@gmail.com"
  "impersonator_username" => "apolskis.linas@gmail.com"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.product_id_external AS product_id_external_2, p0_.ean AS ean_3, p0_.original_price AS original_price_4, p0_.sale_price AS sale_price_5, p0_.ai_score AS ai_score_6, p0_.status AS status_7, p0_.market_since AS market_since_8, p0_.image_path AS image_path_9, p0_.condition_key AS condition_key_10, p0_.package_size_key AS package_size_key_11, p0_.warranty_months AS warranty_months_12, p0_.additional_statuses AS additional_statuses_13, p0_.specification_values AS specification_values_14, p0_.quality_note AS quality_note_15, p0_.catalog_description AS catalog_description_16, p0_.defect_note AS defect_note_17, p0_.ai_input_fingerprint AS ai_input_fingerprint_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, c1_.id AS id_21, c1_.name AS name_22, c1_.slug AS slug_23, c1_.active AS active_24, s2_.id AS id_25, s2_.email AS email_26, s2_.roles AS roles_27, s2_.password AS password_28, s2_.company_name AS company_name_29, s2_.company_code AS company_code_30, s2_.individual_activity_certificate_number AS individual_activity_certificate_number_31, s2_.city AS city_32, s2_.address AS address_33, s2_.zip AS zip_34, s2_.iban AS iban_35, s2_.comment AS comment_36, s2_.phone AS phone_37, s2_.contact_name AS contact_name_38, s2_.contact_email AS contact_email_39, s2_.contact_phone AS contact_phone_40, s2_.fee_percent AS fee_percent_41, s2_.shop_title AS shop_title_42, s2_.vat_code AS vat_code_43, s2_.oss_registered AS oss_registered_44, s2_.office_address AS office_address_45, s2_.customer_phone AS customer_phone_46, s2_.customer_email AS customer_email_47, s2_.bank_name AS bank_name_48, s2_.swift AS swift_49, s2_.invoice_email AS invoice_email_50, s2_.return_country AS return_country_51, s2_.return_city AS return_city_52, s2_.return_address AS return_address_53, s2_.return_post_code AS return_post_code_54, s2_.return_phone AS return_phone_55, s2_.return_email AS return_email_56, s2_.pickup_workdays AS pickup_workdays_57, s2_.pickup_hours_from AS pickup_hours_from_58, s2_.pickup_hours_to AS pickup_hours_to_59, s2_.delivery_hours AS delivery_hours_60, s2_.delivery_apply_all AS delivery_apply_all_61, s2_.delivery_methods AS delivery_methods_62, s2_.ai_pricing_strategy AS ai_pricing_strategy_63, s2_.auto_price_reduction_enabled AS auto_price_reduction_enabled_64, s2_.auto_price_reduction_days AS auto_price_reduction_days_65, s2_.auto_price_reduction_percent AS auto_price_reduction_percent_66, s2_.notify_product_sold AS notify_product_sold_67, s2_.notify_new_message AS notify_new_message_68, s2_.notify_ai_price_change AS notify_ai_price_change_69, s2_.notify_return_request AS notify_return_request_70, s2_.notify_weekly_report AS notify_weekly_report_71, s2_.notify_low_inventory AS notify_low_inventory_72, s2_.holiday_mode AS holiday_mode_73, p0_.category_id AS category_id_74, p0_.seller_id AS seller_id_75, p0_.linked_product_id AS linked_product_id_76, c1_.parent_category_id AS parent_category_id_77 FROM product_draft p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id LEFT JOIN seller s2_ ON p0_.seller_id = s2_.id WHERE p0_.seller_id = ? ORDER BY p0_.updated_at DESC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.product_id_external AS product_id_external_2, p0_.ean AS ean_3, p0_.original_price AS original_price_4, p0_.sale_price AS sale_price_5, p0_.ai_score AS ai_score_6, p0_.status AS status_7, p0_.market_since AS market_since_8, p0_.auto_price_reduction_count AS auto_price_reduction_count_9, p0_.image_path AS image_path_10, p0_.condition_key AS condition_key_11, p0_.package_size_key AS package_size_key_12, p0_.warranty_months AS warranty_months_13, p0_.additional_statuses AS additional_statuses_14, p0_.specification_values AS specification_values_15, p0_.quality_note AS quality_note_16, p0_.catalog_description AS catalog_description_17, p0_.ai_description_fingerprint AS ai_description_fingerprint_18, p0_.defect_note AS defect_note_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, p0_.sold_at AS sold_at_22, c1_.id AS id_23, c1_.name AS name_24, c1_.slug AS slug_25, c1_.active AS active_26, s2_.id AS id_27, s2_.email AS email_28, s2_.roles AS roles_29, s2_.password AS password_30, s2_.company_name AS company_name_31, s2_.company_code AS company_code_32, s2_.individual_activity_certificate_number AS individual_activity_certificate_number_33, s2_.city AS city_34, s2_.address AS address_35, s2_.zip AS zip_36, s2_.iban AS iban_37, s2_.comment AS comment_38, s2_.phone AS phone_39, s2_.contact_name AS contact_name_40, s2_.contact_email AS contact_email_41, s2_.contact_phone AS contact_phone_42, s2_.fee_percent AS fee_percent_43, s2_.shop_title AS shop_title_44, s2_.vat_code AS vat_code_45, s2_.oss_registered AS oss_registered_46, s2_.office_address AS office_address_47, s2_.customer_phone AS customer_phone_48, s2_.customer_email AS customer_email_49, s2_.bank_name AS bank_name_50, s2_.swift AS swift_51, s2_.invoice_email AS invoice_email_52, s2_.return_country AS return_country_53, s2_.return_city AS return_city_54, s2_.return_address AS return_address_55, s2_.return_post_code AS return_post_code_56, s2_.return_phone AS return_phone_57, s2_.return_email AS return_email_58, s2_.pickup_workdays AS pickup_workdays_59, s2_.pickup_hours_from AS pickup_hours_from_60, s2_.pickup_hours_to AS pickup_hours_to_61, s2_.delivery_hours AS delivery_hours_62, s2_.delivery_apply_all AS delivery_apply_all_63, s2_.delivery_methods AS delivery_methods_64, s2_.ai_pricing_strategy AS ai_pricing_strategy_65, s2_.auto_price_reduction_enabled AS auto_price_reduction_enabled_66, s2_.auto_price_reduction_days AS auto_price_reduction_days_67, s2_.auto_price_reduction_percent AS auto_price_reduction_percent_68, s2_.notify_product_sold AS notify_product_sold_69, s2_.notify_new_message AS notify_new_message_70, s2_.notify_ai_price_change AS notify_ai_price_change_71, s2_.notify_return_request AS notify_return_request_72, s2_.notify_weekly_report AS notify_weekly_report_73, s2_.notify_low_inventory AS notify_low_inventory_74, s2_.holiday_mode AS holiday_mode_75, p0_.category_id AS category_id_76, p0_.seller_id AS seller_id_77, c1_.parent_category_id AS parent_category_id_78 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id LEFT JOIN seller s2_ ON p0_.seller_id = s2_.id WHERE p0_.seller_id = ? ORDER BY p0_.updated_at DESC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#756
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]