Symfony Profiler

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET NAMES 'utf8mb4'"
    ]
    "serverVersion" => "8.0"
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "emiliadev"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT dbname FROM saas_instance WHERE hostname = ? LIMIT 1"
  "params" => [
    1 => "ma.gymplusoptimal.com"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#359
      +name: "STRING"
    }
  ]
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET NAMES 'utf8mb4'"
    ]
    "serverVersion" => "8.0"
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "gym_prod_topline"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "USE `gym_prod_ma`"
]

[
  "route" => "login"
  "route_parameters" => [
    "_route" => "login"
    "_controller" => "App\Controller\SecurityController::loginAction"
  ]
  "request_uri" => "https://ma.gymplusoptimal.com/login"
  "method" => "GET"
]

[
  "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 t0.id AS id_1, t0.name_system AS name_system_2, t0.slug AS slug_3, t0.user_contact AS user_contact_4, t0.phone_contact AS phone_contact_5, t0.email_error AS email_error_6, t0.number_client AS number_client_7, t0.number_user AS number_user_8, t0.number_agreements AS number_agreements_9, t0.is_active AS is_active_10, t0.skin AS skin_11, t0.fixed AS fixed_12, t0.sidebar_collapse AS sidebar_collapse_13, t0.terms_conditions AS terms_conditions_14, t0.text_politica AS text_politica_15, t0.questionnaire AS questionnaire_16, t0.questionnaire_software AS questionnaire_software_17, t0.image_login AS image_login_18, t0.image_internal AS image_internal_19, t0.image_horary AS image_horary_20, t0.software_updates AS software_updates_21, t0.horary AS horary_22, t0.number_machine AS number_machine_23, t0.number_class AS number_class_24, t0.is_auto_identifier AS is_auto_identifier_25, t0.is_send_email AS is_send_email_26, t0.send_whatsapp AS send_whatsapp_27, t0.api_whatsapp AS api_whatsapp_28, t0.api_instance_whatsapp AS api_instance_whatsapp_29, t0.template_email_slot AS template_email_slot_30, t0.is_development AS is_development_31, t0.is_request_evaluation AS is_request_evaluation_32, t0.request_evaluation_slot AS request_evaluation_slot_33, t0.nutritional_list_slot AS nutritional_list_slot_34, t0.is_health AS is_health_35, t0.is_evaluation_tools AS is_evaluation_tools_36, t0.is_trainer_prototypes AS is_trainer_prototypes_37, t0.trainer_prototypes_slot AS trainer_prototypes_slot_38, t0.is_virtual_trainer AS is_virtual_trainer_39, t0.is_token AS is_token_40, t0.is_reserve AS is_reserve_41, t0.reserve_slot AS reserve_slot_42, t0.covid_reserve_slot AS covid_reserve_slot_43, t0.is_report_client AS is_report_client_44, t0.is_report_payment AS is_report_payment_45, t0.is_payment AS is_payment_46, t0.is_payment_product AS is_payment_product_47, t0.payment_product_slot AS payment_product_slot_48, t0.is_message_ago AS is_message_ago_49, t0.is_blocking AS is_blocking_50, t0.is_report_training AS is_report_training_51, t0.spotify AS spotify_52, t0.is_discount AS is_discount_53, t0.discount_slot AS discount_slot_54, t0.plan_slot AS plan_slot_55, t0.mercado_pago AS mercado_pago_56, t0.mercado_pago_link AS mercado_pago_link_57, t0.payment_day AS payment_day_58, t0.price AS price_59, t0.price_iva AS price_iva_60, t0.parammeters AS parammeters_61, t0.token AS token_62, t0.is_instance AS is_instance_63, t0.latitude AS latitude_64, t0.longitude AS longitude_65, t0.distance AS distance_66, t0.dni_facto AS dni_facto_67, t0.email_facto AS email_facto_68, t0.day_facto AS day_facto_69, t0.day AS day_70, t0.message_debt AS message_debt_71, t0.registration_client AS registration_client_72, t0.covid_reserved_client AS covid_reserved_client_73, t0.is_massive AS is_massive_74, t0.is_app AS is_app_75, t0.onesignal AS onesignal_76, t0.facebook AS facebook_77, t0.instagram AS instagram_78, t0.twitter AS twitter_79, t0.whatsapp AS whatsapp_80, t0.website AS website_81, t0.api_key_flow AS api_key_flow_82, t0.secret_key_flow AS secret_key_flow_83, t0.api_url_flow AS api_url_flow_84, t0.api_key_flow_facto AS api_key_flow_facto_85, t0.secret_key_flow_facto AS secret_key_flow_facto_86, t0.api_url_flow_facto AS api_url_flow_facto_87, t0.is_admin_setting AS is_admin_setting_88, t0.code_register AS code_register_89, t0.due_date_day AS due_date_day_90, t0.slug_evolution AS slug_evolution_91, t0.suscription AS suscription_92, t0.plan AS plan_93 FROM settings t0 WHERE t0.is_active = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#918
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "gym_prod_ma"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#359
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT DATABASE()"
]