Symfony Profiler

[
  "route" => "app_product_show"
  "route_parameters" => [
    "_route" => "app_product_show"
    "_controller" => "App\Core\Controller\ProductController::show"
    "_locale" => "ru"
    "slug" => "051125-177033"
  ]
  "request_uri" => "http://www.nxt.antiquites-en-france.com/ru/objet/051125-177033"
  "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 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, s4_.id AS id_63, s4_.street AS street_64, s4_.zip AS zip_65, s4_.country_code AS country_code_66, s4_.lat AS lat_67, s4_.lng AS lng_68, s4_.street_view_heading AS street_view_heading_69, s4_.street_view_pitch AS street_view_pitch_70, s4_.street_view_zoom AS street_view_zoom_71, t5_.id AS id_72, t5_.slug AS slug_73, t5_.created_at AS created_at_74, t6_.id AS id_75, t6_.key_name AS key_name_76, t6_.position AS position_77, t6_.filterable AS filterable_78, t6_.icon AS icon_79, p0_.seller_id AS seller_id_80, p1_.product_id AS product_id_81, s2_.user_id AS user_id_82, s3_.seller_id AS seller_id_83, s4_.seller_id AS seller_id_84, s4_.geo_city_id AS geo_city_id_85, t5_.tag_category_id AS tag_category_id_86, t5_.parent_id AS parent_id_87 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 LEFT JOIN seller_address s4_ ON s2_.id = s4_.seller_id LEFT JOIN product_tag p7_ ON p0_.id = p7_.product_id LEFT JOIN tag t5_ ON t5_.id = p7_.tag_id LEFT JOIN tag_category t6_ ON t5_.tag_category_id = t6_.id WHERE p0_.slug = ?"
  "params" => [
    1 => "051125-177033"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#769
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, COUNT(DISTINCT t1_.id) AS sclr_1 FROM product p0_ LEFT JOIN product_tag p2_ ON p0_.id = p2_.product_id LEFT JOIN tag t1_ ON t1_.id = p2_.tag_id AND (t1_.id IN (?, ?, ?, ?)) WHERE p0_.seller_id = ? AND p0_.id <> ? AND p0_.status = ? AND p0_.display = 1 GROUP BY p0_.id ORDER BY sclr_1 DESC, CASE WHEN p0_.is_week_featured = 1 THEN 1 ELSE 0 END DESC, p0_.published_at DESC LIMIT 4"
  "params" => [
    1 => 143
    2 => 178
    3 => 281
    4 => 291
    5 => 6240
    6 => 177033
    7 => "active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#796}
    3 => Doctrine\DBAL\ParameterType {#796}
    4 => Doctrine\DBAL\ParameterType {#796}
    5 => Doctrine\DBAL\ParameterType {#796}
    6 => Doctrine\DBAL\ParameterType {#796}
    7 => Doctrine\DBAL\ParameterType {#769
      +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, p0_.seller_id AS seller_id_29, p1_.product_id AS product_id_30 FROM product p0_ LEFT JOIN product_image p1_ ON p0_.id = p1_.product_id WHERE p0_.id IN (?, ?, ?, ?)"
  "params" => [
    1 => 174856
    2 => 170570
    3 => 166419
    4 => 138175
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#796}
    3 => Doctrine\DBAL\ParameterType {#796}
    4 => Doctrine\DBAL\ParameterType {#796}
  ]
]

[
  "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.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 => 177033
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.mode AS mode_2, t0.price AS price_3, t0.currency AS currency_4, t0.estimated_delay AS estimated_delay_5, t0.carrier_info AS carrier_info_6, t0.product_id AS product_id_7, t0.shipping_zone_id AS shipping_zone_id_8 FROM product_shipping_rule t0 WHERE t0.product_id = ?"
  "params" => [
    1 => 177033
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +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 => 174856
  ]
  "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 => 16259
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +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 => 170570
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +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 => 166419
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +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 => 138175
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#796
      +name: "INTEGER"
    }
  ]
]