Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_locale" => "fr"
    "_controller" => "App\Core\Controller\HomeController::index"
  ]
  "request_uri" => "https://www.nxt.antiquites-en-france.com/"
  "method" => "GET"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "nj151-001.eu.clouddb.ovh.net"
    "port" => 35316
    "user" => "aefnxt"
    "password" => "<redacted>"
    "driverOptions" => [
      1000 => true
    ]
    "defaultTableOptions" => []
    "dbname" => "aefnxt"
    "serverVersion" => "8.0"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.updated_at AS updated_at_4 FROM marketplace_setting t0 WHERE t0.setting_key = ? LIMIT 1"
  "params" => [
    1 => "public.locale_definitions"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#773
      +name: "STRING"
    }
  ]
]

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

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

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

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

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

[
  "key" => "home_counters"
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.status = ? AND p0_.display = 1"
  "params" => [
    1 => "active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#773
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(s0_.id) AS sclr_0 FROM seller s0_ WHERE s0_.status = ?"
  "params" => [
    1 => "active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#773
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT s0_.geo_city_id) AS sclr_0 FROM seller s1_ LEFT JOIN seller_address s0_ ON s1_.id = s0_.seller_id WHERE s1_.status = ? AND s0_.geo_city_id IS NOT NULL"
  "params" => [
    1 => "active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#773
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.status = ? AND p0_.display = 1 ORDER BY p0_.published_at DESC LIMIT 12"
  "params" => [
    1 => "active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#773
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.status AS status_2, p0_.display AS display_3, p0_.price AS price_4, p0_.currency AS currency_5, p0_.condition AS condition_6, p0_.stock_qty AS stock_qty_7, p0_.weight_kg AS weight_kg_8, p0_.length_cm AS length_cm_9, p0_.width_cm AS width_cm_10, p0_.height_cm AS height_cm_11, p0_.depth_cm AS depth_cm_12, p0_.diameter_cm AS diameter_cm_13, p0_.is_week_featured AS is_week_featured_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p0_.published_at AS published_at_17, p0_.sold_at AS sold_at_18, p1_.id AS id_19, p1_.file_path AS file_path_20, p1_.thumb_path AS thumb_path_21, p1_.detail_path AS detail_path_22, p1_.alt_text AS alt_text_23, p1_.position AS position_24, p1_.is_primary AS is_primary_25, p1_.width AS width_26, p1_.height AS height_27, p1_.created_at AS created_at_28, s2_.id AS id_29, s2_.slug AS slug_30, s2_.status AS status_31, s2_.stripe_account_id AS stripe_account_id_32, s2_.stripe_customer_id AS stripe_customer_id_33, s2_.stripe_kyc_complete AS stripe_kyc_complete_34, s2_.paypal_email AS paypal_email_35, s2_.paypal_merchant_id AS paypal_merchant_id_36, s2_.paypal_account_status AS paypal_account_status_37, s2_.paypal_permissions_granted AS paypal_permissions_granted_38, s2_.created_at AS created_at_39, s2_.activated_at AS activated_at_40, s2_.suspended_at AS suspended_at_41, s2_.commercial_status AS commercial_status_42, s2_.subscribed_since AS subscribed_since_43, s2_.subscription_ends_at AS subscription_ends_at_44, s2_.crm_priority AS crm_priority_45, s2_.next_reminder_at AS next_reminder_at_46, s2_.next_reminder_note AS next_reminder_note_47, s2_.prospect_source AS prospect_source_48, s2_.prospect_collected_at AS prospect_collected_at_49, s2_.crm_flag_for_human AS crm_flag_for_human_50, s3_.id AS id_51, s3_.business_name AS business_name_52, s3_.description AS description_53, s3_.siret AS siret_54, s3_.vat_number AS vat_number_55, s3_.phone AS phone_56, s3_.website AS website_57, s3_.logo_path AS logo_path_58, s3_.banner_path AS banner_path_59, s3_.opening_hours AS opening_hours_60, s3_.filter_tag_category_keys AS filter_tag_category_keys_61, s3_.updated_at AS updated_at_62, p0_.seller_id AS seller_id_63, p1_.product_id AS product_id_64, s2_.user_id AS user_id_65, s3_.seller_id AS seller_id_66 FROM product p0_ LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id LEFT JOIN seller s2_ ON p0_.seller_id = s2_.id LEFT JOIN seller_profile s3_ ON s2_.id = s3_.seller_id WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 177783
    2 => 177782
    3 => 177781
    4 => 177780
    5 => 177779
    6 => 177778
    7 => 177777
    8 => 177776
    9 => 177775
    10 => 177774
    11 => 177773
    12 => 177772
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#800}
    3 => Doctrine\DBAL\ParameterType {#800}
    4 => Doctrine\DBAL\ParameterType {#800}
    5 => Doctrine\DBAL\ParameterType {#800}
    6 => Doctrine\DBAL\ParameterType {#800}
    7 => Doctrine\DBAL\ParameterType {#800}
    8 => Doctrine\DBAL\ParameterType {#800}
    9 => Doctrine\DBAL\ParameterType {#800}
    10 => Doctrine\DBAL\ParameterType {#800}
    11 => Doctrine\DBAL\ParameterType {#800}
    12 => Doctrine\DBAL\ParameterType {#800}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.street AS street_2, t0.zip AS zip_3, t0.country_code AS country_code_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.street_view_heading AS street_view_heading_7, t0.street_view_pitch AS street_view_pitch_8, t0.street_view_zoom AS street_view_zoom_9, t0.seller_id AS seller_id_10, t0.geo_city_id AS geo_city_id_11 FROM seller_address t0 WHERE t0.seller_id = ?"
  "params" => [
    1 => 19295
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.street AS street_2, t0.zip AS zip_3, t0.country_code AS country_code_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.street_view_heading AS street_view_heading_7, t0.street_view_pitch AS street_view_pitch_8, t0.street_view_zoom AS street_view_zoom_9, t0.seller_id AS seller_id_10, t0.geo_city_id AS geo_city_id_11 FROM seller_address t0 WHERE t0.seller_id = ?"
  "params" => [
    1 => 19106
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.street AS street_2, t0.zip AS zip_3, t0.country_code AS country_code_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.street_view_heading AS street_view_heading_7, t0.street_view_pitch AS street_view_pitch_8, t0.street_view_zoom AS street_view_zoom_9, t0.seller_id AS seller_id_10, t0.geo_city_id AS geo_city_id_11 FROM seller_address t0 WHERE t0.seller_id = ?"
  "params" => [
    1 => 19007
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.key_name AS key_name_1, t0_.position AS position_2, t0_.filterable AS filterable_3, t0_.icon AS icon_4, t1_.id AS id_5, t1_.locale AS locale_6, t1_.label AS label_7, t2_.id AS id_8, t2_.slug AS slug_9, t2_.created_at AS created_at_10, t3_.id AS id_11, t3_.locale AS locale_12, t3_.label AS label_13, t3_.auto_translated AS auto_translated_14, t4_.id AS id_15, t4_.slug AS slug_16, t4_.created_at AS created_at_17, t5_.id AS id_18, t5_.locale AS locale_19, t5_.label AS label_20, t5_.auto_translated AS auto_translated_21, t1_.tag_category_id AS tag_category_id_22, t2_.tag_category_id AS tag_category_id_23, t2_.parent_id AS parent_id_24, t3_.tag_id AS tag_id_25, t4_.tag_category_id AS tag_category_id_26, t4_.parent_id AS parent_id_27, t5_.tag_id AS tag_id_28 FROM tag_category t0_ LEFT JOIN tag_category_translation t1_ ON t0_.id = t1_.tag_category_id LEFT JOIN tag t2_ ON t0_.id = t2_.tag_category_id LEFT JOIN tag_translation t3_ ON t2_.id = t3_.tag_id LEFT JOIN tag t4_ ON t2_.id = t4_.parent_id LEFT JOIN tag_translation t5_ ON t4_.id = t5_.tag_id WHERE t0_.filterable = 1 ORDER BY t0_.position ASC, t2_.slug ASC"
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.week_start AS week_start_1, f0_.status AS status_2, f0_.source AS source_3, f0_.stripe_checkout_session_id AS stripe_checkout_session_id_4, f0_.amount_paid AS amount_paid_5, f0_.admin_notes AS admin_notes_6, f0_.created_at AS created_at_7, f0_.cancelled_at AS cancelled_at_8, f0_.seller_id AS seller_id_9, f0_.cancelled_by_id AS cancelled_by_id_10 FROM featured_seller_week f0_ WHERE f0_.week_start >= ? AND f0_.week_start <= ? AND f0_.status IN (?, ?) LIMIT 1"
  "params" => [
    1 => "2026-04-20"
    2 => "2026-04-26"
    3 => "active"
    4 => "booked"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#773
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#773}
    3 => Doctrine\DBAL\ParameterType {#773}
    4 => Doctrine\DBAL\ParameterType {#773}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 177783
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.insee_code AS insee_code_2, t0.name AS name_3, t0.zip_codes AS zip_codes_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.department_id AS department_id_7 FROM geo_city t0 WHERE t0.id = ?"
  "params" => [
    1 => 44
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 177782
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 177781
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 177780
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 177779
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 177778
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 177777
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 177776
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 177775
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.insee_code AS insee_code_2, t0.name AS name_3, t0.zip_codes AS zip_codes_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.department_id AS department_id_7 FROM geo_city t0 WHERE t0.id = ?"
  "params" => [
    1 => 34569
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 177774
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 177773
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.insee_code AS insee_code_2, t0.name AS name_3, t0.zip_codes AS zip_codes_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.department_id AS department_id_7 FROM geo_city t0 WHERE t0.id = ?"
  "params" => [
    1 => 27203
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.description AS description_4, t0.auto_translated AS auto_translated_5, t0.translated_at AS translated_at_6, t0.product_id AS product_id_7 FROM product_translation t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 177772
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#800
      +name: "INTEGER"
    }
  ]
]