Symfony Profiler

[
  "route" => "app_seller_show"
  "route_parameters" => [
    "_route" => "app_seller_show"
    "_controller" => "App\Core\Controller\SellerController::show"
    "_locale" => "fr"
    "slug" => "carre-rive-gauche-17146"
  ]
  "request_uri" => "https://www.nxt.antiquites-en-france.com/fr/marchands/carre-rive-gauche-17146"
  "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 {#769
      +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"
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.status AS status_2, s0_.stripe_account_id AS stripe_account_id_3, s0_.stripe_customer_id AS stripe_customer_id_4, s0_.stripe_kyc_complete AS stripe_kyc_complete_5, s0_.paypal_email AS paypal_email_6, s0_.paypal_merchant_id AS paypal_merchant_id_7, s0_.paypal_account_status AS paypal_account_status_8, s0_.paypal_permissions_granted AS paypal_permissions_granted_9, s0_.created_at AS created_at_10, s0_.activated_at AS activated_at_11, s0_.suspended_at AS suspended_at_12, s0_.commercial_status AS commercial_status_13, s0_.subscribed_since AS subscribed_since_14, s0_.subscription_ends_at AS subscription_ends_at_15, s0_.crm_priority AS crm_priority_16, s0_.next_reminder_at AS next_reminder_at_17, s0_.next_reminder_note AS next_reminder_note_18, s0_.prospect_source AS prospect_source_19, s0_.prospect_collected_at AS prospect_collected_at_20, s0_.crm_flag_for_human AS crm_flag_for_human_21, u1_.id AS id_22, u1_.email AS email_23, u1_.roles AS roles_24, u1_.password AS password_25, u1_.locale AS locale_26, u1_.email_verified_at AS email_verified_at_27, u1_.email_verification_token AS email_verification_token_28, u1_.email_verification_token_expires_at AS email_verification_token_expires_at_29, u1_.password_reset_token AS password_reset_token_30, u1_.password_reset_token_expires_at AS password_reset_token_expires_at_31, u1_.created_at AS created_at_32, u1_.last_login_at AS last_login_at_33, u1_.active AS active_34, u1_.email_bounced AS email_bounced_35, u1_.email_bounce_count AS email_bounce_count_36, u1_.email_bounce_type AS email_bounce_type_37, u1_.email_bounce_last_at AS email_bounce_last_at_38, u1_.email_bounce_reason AS email_bounce_reason_39, u1_.api_token_hash AS api_token_hash_40, u1_.stripe_customer_id AS stripe_customer_id_41, s0_.user_id AS user_id_42 FROM seller s0_ LEFT JOIN user u1_ ON s0_.user_id = u1_.id WHERE s0_.slug = ?"
  "params" => [
    1 => "carre-rive-gauche-17146"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#769
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.description AS description_3, t0.siret AS siret_4, t0.vat_number AS vat_number_5, t0.phone AS phone_6, t0.website AS website_7, t0.logo_path AS logo_path_8, t0.banner_path AS banner_path_9, t0.opening_hours AS opening_hours_10, t0.filter_tag_category_keys AS filter_tag_category_keys_11, t0.updated_at AS updated_at_12, t0.seller_id AS seller_id_13 FROM seller_profile t0 WHERE t0.seller_id = ?"
  "params" => [
    1 => 17146
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +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 => 17146
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.newsletter_opt_in AS newsletter_opt_in_5, t0.alert_preferences AS alert_preferences_6, t0.updated_at AS updated_at_7, t0.user_id AS user_id_8 FROM user_profile t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 17146
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.status IN (?, ?) AND p0_.display = 1"
  "params" => [
    1 => 17146
    2 => "active"
    3 => "sold"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#769
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#769}
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.seller_id = ? AND p0_.status IN (?, ?) AND p0_.display = 1 ORDER BY CASE WHEN p0_.status = ? THEN 1 ELSE 0 END ASC, p0_.created_at DESC LIMIT 24"
  "params" => [
    1 => 17146
    2 => "active"
    3 => "sold"
    4 => "sold"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#769
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#769}
    4 => Doctrine\DBAL\ParameterType {#769}
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, COUNT(DISTINCT p1_.id) AS sclr_1 FROM product p1_ INNER JOIN product_tag p2_ ON p1_.id = p2_.product_id INNER JOIN tag t0_ ON t0_.id = p2_.tag_id WHERE p1_.seller_id = ? AND p1_.status IN (?, ?) AND p1_.display = 1 GROUP BY t0_.id"
  "params" => [
    1 => 17146
    2 => "active"
    3 => "sold"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#769
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#769}
  ]
]

[
  "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 => "maps.google_api_key"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#769
      +name: "STRING"
    }
  ]
]

[
  "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 => "recaptcha.site_key"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#769
      +name: "STRING"
    }
  ]
]

[
  "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 => "recaptcha.secret_key"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#769
      +name: "STRING"
    }
  ]
]

[
  "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 => "recaptcha.site_key"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#769
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.description_translated AS description_translated_3, t0.auto_translated AS auto_translated_4, t0.translated_at AS translated_at_5, t0.seller_profile_id AS seller_profile_id_6 FROM seller_profile_translation t0 WHERE t0.seller_profile_id = ?"
  "params" => [
    1 => 341
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +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 => 29245
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.insee_code AS insee_code_2, t0.name AS name_3, t0.region_id AS region_id_4 FROM geo_department t0 WHERE t0.id = ?"
  "params" => [
    1 => 76
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.insee_code AS insee_code_2, t0.name AS name_3, t0.country_id AS country_id_4 FROM geo_region t0 WHERE t0.id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +name: "INTEGER"
    }
  ]
]