Symfony Profiler

[
  "route" => "app_order_products"
  "route_parameters" => [
    "_route" => "app_order_products"
    "_controller" => "App\Plugin\CovetoBundle\Controller\OrderController::searchProducts"
  ]
  "request_uri" => "https://preprod.covetonet.com/order/products?baseFilter=all&customerId=16000&excludeRedList=true&favoritesOnly=false&isColisage=false&isSpeAli=false&page=1&q=&sort=relevance"
  "method" => "GET"
]

[
  "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\UsernamePasswordToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "app_covetonet_9j3o2"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "preprod"
    "serverVersion" => "10.5.18-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.login AS login_2, t0.email AS email_3, t0.password AS password_4, t0.roles AS roles_5, t0.api_token AS api_token_6, t0.created_at AS created_at_7 FROM auth_user t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#729
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "16000"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.external_code AS external_code_2, t0.name AS name_3, t0.delivery_code AS delivery_code_4, t0.email AS email_5, t0.phone AS phone_6, t0.state AS state_7, t0.postal_code AS postal_code_8, t0.address AS address_9, t0.adrline1 AS adrline1_10, t0.adrline2 AS adrline2_11, t0.adrline3 AS adrline3_12, t0.city AS city_13, t0.is_spe_ali AS is_spe_ali_14, t0.depot_id AS depot_id_15, t0.is_packaging_prohibited AS is_packaging_prohibited_16, t0.updated_at AS updated_at_17 FROM customer_coveto t0 INNER JOIN auth_user_customer_coveto ON t0.id = auth_user_customer_coveto.customer_coveto_id WHERE auth_user_customer_coveto.auth_user_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#729
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT u0_.product_id AS product_id_0 FROM user_product_preference u0_ WHERE u0_.user_id = ? AND u0_.is_favorite = 1"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#729
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT p0_.product_id AS sclr_0, p0_.quantity AS quantity_1, p0_.price AS price_2, p0_.promo_price AS promo_price_3, p0_.promo_start_at AS promo_start_at_4, p0_.promo_end_at AS promo_end_at_5 FROM product_price p0_ WHERE p0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.quantity ASC"
  "params" => [
    1 => 1
    2 => 3
    3 => 40
    4 => 82
    5 => 116
    6 => 1650
    7 => 6276
    8 => 7809
    9 => 8157
    10 => 11521
    11 => 12848
    12 => 2
    13 => 4
    14 => 5
    15 => 6
    16 => 7
    17 => 8
    18 => 9
    19 => 10
    20 => 12
    21 => 14
    22 => 16
    23 => 17
    24 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#729
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#729}
    3 => Doctrine\DBAL\ParameterType {#729}
    4 => Doctrine\DBAL\ParameterType {#729}
    5 => Doctrine\DBAL\ParameterType {#729}
    6 => Doctrine\DBAL\ParameterType {#729}
    7 => Doctrine\DBAL\ParameterType {#729}
    8 => Doctrine\DBAL\ParameterType {#729}
    9 => Doctrine\DBAL\ParameterType {#729}
    10 => Doctrine\DBAL\ParameterType {#729}
    11 => Doctrine\DBAL\ParameterType {#729}
    12 => Doctrine\DBAL\ParameterType {#729}
    13 => Doctrine\DBAL\ParameterType {#729}
    14 => Doctrine\DBAL\ParameterType {#729}
    15 => Doctrine\DBAL\ParameterType {#729}
    16 => Doctrine\DBAL\ParameterType {#729}
    17 => Doctrine\DBAL\ParameterType {#729}
    18 => Doctrine\DBAL\ParameterType {#729}
    19 => Doctrine\DBAL\ParameterType {#729}
    20 => Doctrine\DBAL\ParameterType {#729}
    21 => Doctrine\DBAL\ParameterType {#729}
    22 => Doctrine\DBAL\ParameterType {#729}
    23 => Doctrine\DBAL\ParameterType {#729}
    24 => Doctrine\DBAL\ParameterType {#729}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.deleted_at AS deleted_at_2 FROM product p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1
    2 => 3
    3 => 40
    4 => 82
    5 => 116
    6 => 1650
    7 => 6276
    8 => 7809
    9 => 8157
    10 => 11521
    11 => 12848
    12 => 2
    13 => 4
    14 => 5
    15 => 6
    16 => 7
    17 => 8
    18 => 9
    19 => 10
    20 => 12
    21 => 14
    22 => 16
    23 => 17
    24 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#729
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#729}
    3 => Doctrine\DBAL\ParameterType {#729}
    4 => Doctrine\DBAL\ParameterType {#729}
    5 => Doctrine\DBAL\ParameterType {#729}
    6 => Doctrine\DBAL\ParameterType {#729}
    7 => Doctrine\DBAL\ParameterType {#729}
    8 => Doctrine\DBAL\ParameterType {#729}
    9 => Doctrine\DBAL\ParameterType {#729}
    10 => Doctrine\DBAL\ParameterType {#729}
    11 => Doctrine\DBAL\ParameterType {#729}
    12 => Doctrine\DBAL\ParameterType {#729}
    13 => Doctrine\DBAL\ParameterType {#729}
    14 => Doctrine\DBAL\ParameterType {#729}
    15 => Doctrine\DBAL\ParameterType {#729}
    16 => Doctrine\DBAL\ParameterType {#729}
    17 => Doctrine\DBAL\ParameterType {#729}
    18 => Doctrine\DBAL\ParameterType {#729}
    19 => Doctrine\DBAL\ParameterType {#729}
    20 => Doctrine\DBAL\ParameterType {#729}
    21 => Doctrine\DBAL\ParameterType {#729}
    22 => Doctrine\DBAL\ParameterType {#729}
    23 => Doctrine\DBAL\ParameterType {#729}
    24 => Doctrine\DBAL\ParameterType {#729}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.depot_id AS depot_id_1, p0_.is_visible AS is_visible_2, p0_.stock_status AS stock_status_3, p0_.product_status AS product_status_4, p0_.identity_status AS identity_status_5, p0_.available_quantity AS available_quantity_6, p0_.future_quantity AS future_quantity_7, p0_.rupture_origin AS rupture_origin_8, p0_.expiry_date AS expiry_date_9, p0_.lot_number AS lot_number_10, p0_.updated_at AS updated_at_11, p0_.product_id AS product_id_12 FROM product_stock p0_ WHERE p0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.depot_id = ?"
  "params" => [
    1 => 1
    2 => 3
    3 => 40
    4 => 82
    5 => 116
    6 => 1650
    7 => 6276
    8 => 7809
    9 => 8157
    10 => 11521
    11 => 12848
    12 => 2
    13 => 4
    14 => 5
    15 => 6
    16 => 7
    17 => 8
    18 => 9
    19 => 10
    20 => 12
    21 => 14
    22 => 16
    23 => 17
    24 => 18
    25 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#729
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#729}
    3 => Doctrine\DBAL\ParameterType {#729}
    4 => Doctrine\DBAL\ParameterType {#729}
    5 => Doctrine\DBAL\ParameterType {#729}
    6 => Doctrine\DBAL\ParameterType {#729}
    7 => Doctrine\DBAL\ParameterType {#729}
    8 => Doctrine\DBAL\ParameterType {#729}
    9 => Doctrine\DBAL\ParameterType {#729}
    10 => Doctrine\DBAL\ParameterType {#729}
    11 => Doctrine\DBAL\ParameterType {#729}
    12 => Doctrine\DBAL\ParameterType {#729}
    13 => Doctrine\DBAL\ParameterType {#729}
    14 => Doctrine\DBAL\ParameterType {#729}
    15 => Doctrine\DBAL\ParameterType {#729}
    16 => Doctrine\DBAL\ParameterType {#729}
    17 => Doctrine\DBAL\ParameterType {#729}
    18 => Doctrine\DBAL\ParameterType {#729}
    19 => Doctrine\DBAL\ParameterType {#729}
    20 => Doctrine\DBAL\ParameterType {#729}
    21 => Doctrine\DBAL\ParameterType {#729}
    22 => Doctrine\DBAL\ParameterType {#729}
    23 => Doctrine\DBAL\ParameterType {#729}
    24 => Doctrine\DBAL\ParameterType {#729}
    25 => Doctrine\DBAL\ParameterType {#729}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.gtin AS gtin_2, p0_.ean AS ean_3, p0_.cip AS cip_4, p0_.external_code AS external_code_5, p0_.weight AS weight_6, p0_.amm_number AS amm_number_7, p0_.legal_thermo AS legal_thermo_8, p0_.legal_bio AS legal_bio_9, p0_.legal_eco AS legal_eco_10, p0_.legal_danger AS legal_danger_11, p0_.legal_atb AS legal_atb_12, p0_.is_spe_ali AS is_spe_ali_13, p0_.is_colisage AS is_colisage_14, p0_.vat_rate AS vat_rate_15, p0_.deleted_at AS deleted_at_16, p0_.replacement_external_code AS replacement_external_code_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.target_species AS target_species_20, p1_.id AS id_21, p1_.designation_commerciale AS designation_commerciale_22, p1_.conditionnement AS conditionnement_23, p1_.image_url AS image_url_24, p1_.date_commercialisation AS date_commercialisation_25, p1_.nature AS nature_26, p1_.composition AS composition_27, p1_.indications AS indications_28, p1_.mode_administration AS mode_administration_29, p1_.indications_utilisation AS indications_utilisation_30, p1_.objectifs AS objectifs_31, p1_.description_commerciale AS description_commerciale_32, p1_.contre_indications AS contre_indications_33, p1_.especes AS especes_34, p0_.laboratory_code AS laboratory_code_35, p0_.product_family_id AS product_family_id_36, p0_.therapeutic_class_id AS therapeutic_class_id_37, p1_.product_id AS product_id_38 FROM product p0_ LEFT JOIN product_mediatheque p1_ ON p0_.id = p1_.product_id WHERE p0_.external_code IN (?, ?)"
  "params" => [
    1 => "808661"
    2 => "809379"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1091
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1091}
  ]
]

[
  "sql" => "SELECT p0_.product_id AS sclr_0, p0_.id AS id_1, p1_.id AS id_2, p0_.linked_external_code AS linked_external_code_3, p1_.name AS name_4, p2_.designation_commerciale AS designation_commerciale_5, p2_.image_url AS image_url_6, p0_.master_quantity AS master_quantity_7, p0_.linked_quantity AS linked_quantity_8, p0_.is_free AS is_free_9, p0_.start_at AS start_at_10, p0_.end_at AS end_at_11 FROM product_linked p0_ INNER JOIN product p1_ ON p0_.linked_product_id = p1_.id LEFT JOIN product_mediatheque p2_ ON p1_.id = p2_.product_id WHERE p0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND (p0_.start_at IS NULL OR p0_.start_at <= ?) AND (p0_.end_at IS NULL OR p0_.end_at >= ?) ORDER BY p0_.is_free DESC, p0_.master_quantity ASC"
  "params" => [
    1 => 1
    2 => 3
    3 => 40
    4 => 82
    5 => 116
    6 => 1650
    7 => 6276
    8 => 7809
    9 => 8157
    10 => 11521
    11 => 12848
    12 => 2
    13 => 4
    14 => 5
    15 => 6
    16 => 7
    17 => 8
    18 => 9
    19 => 10
    20 => 12
    21 => 14
    22 => 16
    23 => 17
    24 => 18
    25 => "2026-10-05"
    26 => "2026-10-05"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#729
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#729}
    3 => Doctrine\DBAL\ParameterType {#729}
    4 => Doctrine\DBAL\ParameterType {#729}
    5 => Doctrine\DBAL\ParameterType {#729}
    6 => Doctrine\DBAL\ParameterType {#729}
    7 => Doctrine\DBAL\ParameterType {#729}
    8 => Doctrine\DBAL\ParameterType {#729}
    9 => Doctrine\DBAL\ParameterType {#729}
    10 => Doctrine\DBAL\ParameterType {#729}
    11 => Doctrine\DBAL\ParameterType {#729}
    12 => Doctrine\DBAL\ParameterType {#729}
    13 => Doctrine\DBAL\ParameterType {#729}
    14 => Doctrine\DBAL\ParameterType {#729}
    15 => Doctrine\DBAL\ParameterType {#729}
    16 => Doctrine\DBAL\ParameterType {#729}
    17 => Doctrine\DBAL\ParameterType {#729}
    18 => Doctrine\DBAL\ParameterType {#729}
    19 => Doctrine\DBAL\ParameterType {#729}
    20 => Doctrine\DBAL\ParameterType {#729}
    21 => Doctrine\DBAL\ParameterType {#729}
    22 => Doctrine\DBAL\ParameterType {#729}
    23 => Doctrine\DBAL\ParameterType {#729}
    24 => Doctrine\DBAL\ParameterType {#729}
    25 => Doctrine\DBAL\ParameterType {#1091
      +name: "STRING"
    }
    26 => Doctrine\DBAL\ParameterType {#1091}
  ]
]

[
  "sql" => "SELECT u0_.product_id AS product_id_0, u0_.is_favorite AS is_favorite_1, u0_.is_red_list AS is_red_list_2 FROM user_product_preference u0_ WHERE u0_.user_id = ? AND u0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 5
    2 => 1
    3 => 3
    4 => 40
    5 => 82
    6 => 116
    7 => 1650
    8 => 6276
    9 => 7809
    10 => 8157
    11 => 11521
    12 => 12848
    13 => 2
    14 => 4
    15 => 5
    16 => 6
    17 => 7
    18 => 8
    19 => 9
    20 => 10
    21 => 12
    22 => 14
    23 => 16
    24 => 17
    25 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#729
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#729}
    3 => Doctrine\DBAL\ParameterType {#729}
    4 => Doctrine\DBAL\ParameterType {#729}
    5 => Doctrine\DBAL\ParameterType {#729}
    6 => Doctrine\DBAL\ParameterType {#729}
    7 => Doctrine\DBAL\ParameterType {#729}
    8 => Doctrine\DBAL\ParameterType {#729}
    9 => Doctrine\DBAL\ParameterType {#729}
    10 => Doctrine\DBAL\ParameterType {#729}
    11 => Doctrine\DBAL\ParameterType {#729}
    12 => Doctrine\DBAL\ParameterType {#729}
    13 => Doctrine\DBAL\ParameterType {#729}
    14 => Doctrine\DBAL\ParameterType {#729}
    15 => Doctrine\DBAL\ParameterType {#729}
    16 => Doctrine\DBAL\ParameterType {#729}
    17 => Doctrine\DBAL\ParameterType {#729}
    18 => Doctrine\DBAL\ParameterType {#729}
    19 => Doctrine\DBAL\ParameterType {#729}
    20 => Doctrine\DBAL\ParameterType {#729}
    21 => Doctrine\DBAL\ParameterType {#729}
    22 => Doctrine\DBAL\ParameterType {#729}
    23 => Doctrine\DBAL\ParameterType {#729}
    24 => Doctrine\DBAL\ParameterType {#729}
    25 => Doctrine\DBAL\ParameterType {#729}
  ]
]

[
  "key" => "_security_main"
]