Symfony Profiler

[
  "route" => "app_public_business"
  "route_parameters" => [
    "_route" => "app_public_business"
    "_controller" => "App\Controller\Public\BusinessController::index"
  ]
  "request_uri" => "https://www.menu221.pmd-groupe.com/annuaire"
  "method" => "GET"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.email_principal AS email_principal_3, t0.email_contact AS email_contact_4, t0.telephone AS telephone_5, t0.whatsapp AS whatsapp_6, t0.adresse AS adresse_7, t0.facebook AS facebook_8, t0.instagram AS instagram_9, t0.twitter AS twitter_10, t0.is_maintenance_mode AS is_maintenance_mode_11, t0.maintenance_message AS maintenance_message_12, t0.logo AS logo_13, t0.description AS description_14 FROM global_setting t0 LIMIT 1"
]

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

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

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

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

[
  "sql" => "SELECT b0_.id AS id_0, b0_.nom_activite AS nom_activite_1, b0_.description AS description_2, b0_.adresse AS adresse_3, b0_.telephone AS telephone_4, b0_.logo AS logo_5, b0_.slug AS slug_6, b0_.is_visible AS is_visible_7, b0_.nombre_visit AS nombre_visit_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.code AS code_11, b0_.ville AS ville_12, b0_.localisation AS localisation_13, b0_.subscription_status AS subscription_status_14, b0_.grace_period_started_at AS grace_period_started_at_15, b0_.business_creer_par_id AS business_creer_par_id_16, b0_.settings_id AS settings_id_17, b0_.qr_code_id AS qr_code_id_18, b0_.type_business_id AS type_business_id_19 FROM business b0_ LEFT JOIN type_business t1_ ON b0_.type_business_id = t1_.id WHERE b0_.is_visible = ? ORDER BY b0_.created_at DESC LIMIT 6"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.commission_rate AS commission_rate_2, t0.partner_since AS partner_since_3, t0.is_active AS is_active_4, t0.contact_email AS contact_email_5, t0.contact_phone AS contact_phone_6, t0.contract_file AS contract_file_7, t0.contract_details AS contract_details_8, t0.business_id AS business_id_9 FROM business_partner t0 WHERE t0.business_id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1112
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.commission_rate AS commission_rate_2, t0.partner_since AS partner_since_3, t0.is_active AS is_active_4, t0.contact_email AS contact_email_5, t0.contact_phone AS contact_phone_6, t0.contract_file AS contract_file_7, t0.contract_details AS contract_details_8, t0.business_id AS business_id_9 FROM business_partner t0 WHERE t0.business_id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1112
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.commission_rate AS commission_rate_2, t0.partner_since AS partner_since_3, t0.is_active AS is_active_4, t0.contact_email AS contact_email_5, t0.contact_phone AS contact_phone_6, t0.contract_file AS contract_file_7, t0.contract_details AS contract_details_8, t0.business_id AS business_id_9 FROM business_partner t0 WHERE t0.business_id = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1112
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.commission_rate AS commission_rate_2, t0.partner_since AS partner_since_3, t0.is_active AS is_active_4, t0.contact_email AS contact_email_5, t0.contact_phone AS contact_phone_6, t0.contract_file AS contract_file_7, t0.contract_details AS contract_details_8, t0.business_id AS business_id_9 FROM business_partner t0 WHERE t0.business_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1112
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.commission_rate AS commission_rate_2, t0.partner_since AS partner_since_3, t0.is_active AS is_active_4, t0.contact_email AS contact_email_5, t0.contact_phone AS contact_phone_6, t0.contract_file AS contract_file_7, t0.contract_details AS contract_details_8, t0.business_id AS business_id_9 FROM business_partner t0 WHERE t0.business_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1112
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.commission_rate AS commission_rate_2, t0.partner_since AS partner_since_3, t0.is_active AS is_active_4, t0.contact_email AS contact_email_5, t0.contact_phone AS contact_phone_6, t0.contract_file AS contract_file_7, t0.contract_details AS contract_details_8, t0.business_id AS business_id_9 FROM business_partner t0 WHERE t0.business_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1112
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.is_actif AS is_actif_5, t0.creer_by_admin_id AS creer_by_admin_id_6, t0.delete_by_admin_id AS delete_by_admin_id_7 FROM type_business t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1112
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.is_actif AS is_actif_5, t0.creer_by_admin_id AS creer_by_admin_id_6, t0.delete_by_admin_id AS delete_by_admin_id_7 FROM type_business t0 WHERE t0.id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1112
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.is_actif AS is_actif_5, t0.creer_by_admin_id AS creer_by_admin_id_6, t0.delete_by_admin_id AS delete_by_admin_id_7 FROM type_business t0 WHERE t0.is_actif = ? ORDER BY t0.nom ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1103
      +name: "BOOLEAN"
    }
  ]
]