Symfony Profiler

[
  "route" => "app_training_workshop_list"
  "route_parameters" => [
    "_route" => "app_training_workshop_list"
    "_controller" => "App\UI\Training\Controller\WorkshopListController"
    "_locale" => "es"
  ]
  "request_uri" => "https://clinical-talent.isdeveloping.com/es/formaciones?especialidad=docencia"
  "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"
]

[
  "params" => [
    "driver" => "pdo_sqlite"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => null
    "user" => "root"
    "password" => null
    "driverOptions" => []
    "defaultTableOptions" => []
    "path" => "/var/www/vhosts/isdeveloping.com/clinical-talent.isdeveloping.com/var/app.db"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.color AS color_2 FROM training_specialties t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.specialty_id AS specialty_id_4 FROM training_specialty_translations t0 WHERE t0.specialty_id = ?"
  "params" => [
    1 => b"\x01 úHƒ\rzTŠ²tRå3Õ"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.specialty_id AS specialty_id_4 FROM training_specialty_translations t0 WHERE t0.specialty_id = ?"
  "params" => [
    1 => b"\x01 úHƒ\x11xÄ“\r\x1AJðº6ß"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.specialty_id AS specialty_id_4 FROM training_specialty_translations t0 WHERE t0.specialty_id = ?"
  "params" => [
    1 => b"\x01 úHƒ\x15q\x08§OßÕ¿s†É"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.specialty_id AS specialty_id_4 FROM training_specialty_translations t0 WHERE t0.specialty_id = ?"
  "params" => [
    1 => b"\x01 úHƒ\x18}ig{¬=\x1A­*"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.specialty_id AS specialty_id_4 FROM training_specialty_translations t0 WHERE t0.specialty_id = ?"
  "params" => [
    1 => b"\x01 úHƒ\x1Dz\x1CŽ°¸\x19–\x1CnÍ"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.specialty_id AS specialty_id_4 FROM training_specialty_translations t0 WHERE t0.specialty_id = ?"
  "params" => [
    1 => b"\x01 úHƒ"}^-‹P|Ñ\x0E~"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.specialty_id AS specialty_id_4 FROM training_specialty_translations t0 WHERE t0.specialty_id = ?"
  "params" => [
    1 => b"\x01 úHƒ%}\x00 QÕ.±\x02au"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.modality AS modality_2, t0_.image_key AS image_key_3, t0_.price_cents AS price_cents_4, t0_.currency AS currency_5, t0_.registration_email AS registration_email_6, t0_.registration_mode AS registration_mode_7, t0_.registration_url AS registration_url_8, t0_.video_url AS video_url_9, t0_.published_at AS published_at_10, t0_.created_at AS created_at_11, t0_.updated_at AS updated_at_12, t1_.id AS id_13, t1_.locale AS locale_14, t1_.title AS title_15, t1_.slug AS slug_16, t1_.subtitle AS subtitle_17, t1_.summary AS summary_18, t1_.description AS description_19, t1_.content_items AS content_items_20, t1_.learning_outcomes AS learning_outcomes_21, t1_.schedule AS schedule_22, t1_.registration_instructions AS registration_instructions_23, t2_.id AS id_24, t2_.name AS name_25, t2_.logo_key AS logo_key_26, t2_.city AS city_27, t2_.address AS address_28, t2_.maps_url AS maps_url_29, t2_.photo_key AS photo_key_30, t3_.id AS id_31, t3_.color AS color_32, t4_.id AS id_33, t4_.color AS color_34, t0_.predominant_specialty_id AS predominant_specialty_id_35, t0_.institution_id AS institution_id_36, t1_.workshop_id AS workshop_id_37 FROM training_workshops t0_ LEFT JOIN training_workshop_translations t1_ ON t0_.id = t1_.workshop_id LEFT JOIN training_institutions t2_ ON t0_.institution_id = t2_.id LEFT JOIN training_workshop_specialties t5_ ON t0_.id = t5_.workshop_id LEFT JOIN training_specialties t3_ ON t3_.id = t5_.specialty_id LEFT JOIN training_specialties t4_ ON t0_.predominant_specialty_id = t4_.id WHERE t0_.status = ? AND t3_.id = ? ORDER BY t0_.published_at DESC"
  "params" => [
    1 => "published"
    2 => b"\x01 úHƒ%}\x00 QÕ.±\x02au"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#961}
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.color AS color_1, t1_.id AS id_2, t1_.locale AS locale_3, t1_.name AS name_4, t1_.specialty_id AS specialty_id_5 FROM training_specialties t0_ LEFT JOIN training_specialty_translations t1_ ON t0_.id = t1_.specialty_id"
]

[
  "sql" => "SELECT DISTINCT t0_.city AS city_0 FROM training_workshops t1_ INNER JOIN training_institutions t0_ ON t1_.institution_id = t0_.id WHERE t1_.status = ? AND t0_.city IS NOT NULL AND t0_.city <> '' ORDER BY city_0 ASC"
  "params" => [
    1 => "published"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image_key AS image_key_2, t0.icon_key AS icon_key_3, t0.texts AS texts_4 FROM training_formations_page_settings t0 LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.texts AS texts_2, t0.contact_email AS contact_email_3, t0.contact_phone AS contact_phone_4 FROM content_footer_settings t0 LIMIT 1"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.texts AS texts_1, c0_.position AS position_2, c1_.id AS id_3, c1_.texts AS texts_4, c1_.position AS position_5, c1_.destination AS destination_6, c1_.route_name AS route_name_7, c1_.external_url AS external_url_8, c1_.fragment AS fragment_9, c0_.footer_id AS footer_id_10, c1_.column_id AS column_id_11 FROM content_footer_columns c0_ LEFT JOIN content_footer_links c1_ ON c0_.id = c1_.column_id ORDER BY c0_.position ASC, c1_.position ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.icon_key AS icon_key_2, t0.url AS url_3, t0.label AS label_4, t0.position AS position_5, t0.footer_id AS footer_id_6 FROM content_footer_social_links t0 WHERE t0.footer_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"\x01 úH…–wà¶\x01Ç\x07?£hè"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.document_key AS document_key_1, c0_.is_active AS is_active_2, c0_.texts AS texts_3 FROM content_legal_documents c0_ WHERE c0_.document_key = ? AND c0_.is_active = 1"
  "params" => [
    1 => "legal_notice"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.document_key AS document_key_1, c0_.is_active AS is_active_2, c0_.texts AS texts_3 FROM content_legal_documents c0_ WHERE c0_.document_key = ? AND c0_.is_active = 1"
  "params" => [
    1 => "privacy_policy"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.document_key AS document_key_1, c0_.is_active AS is_active_2, c0_.texts AS texts_3 FROM content_legal_documents c0_ WHERE c0_.document_key = ? AND c0_.is_active = 1"
  "params" => [
    1 => "cookies_policy"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#961
      +name: "STRING"
    }
  ]
]