Symfony Profiler

[
  "route" => "app_find_out"
  "route_parameters" => [
    "_route" => "app_find_out"
    "_controller" => "App\UI\FindOut\Controller\ShowFindOutController"
    "_locale" => "ca"
  ]
  "request_uri" => "https://clinical-talent.isdeveloping.com/ca/descobreix"
  "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 c0_.id AS id_0, c0_.page_key AS page_key_1, c0_.is_active AS is_active_2, c1_.id AS id_3, c1_.position AS position_4, c1_.is_active AS is_active_5, c1_.texts AS texts_6, c1_.image_key AS image_key_7, c1_.video_url AS video_url_8, c1_.video_thumb_key AS video_thumb_key_9, c1_.layout AS layout_10, c1_.variant AS variant_11, c1_.source AS source_12, c1_.interval_seconds AS interval_seconds_13, c1_.image_position AS image_position_14, c1_.cta_link_destination AS cta_link_destination_15, c1_.cta_link_route_name AS cta_link_route_name_16, c1_.cta_link_external_url AS cta_link_external_url_17, c1_.cta_link_fragment AS cta_link_fragment_18, c1_.type AS type_19, c1_.page_content_id AS page_content_id_20 FROM content_page_contents c0_ LEFT JOIN content_blocks c1_ ON c0_.id = c1_.page_content_id AND c1_.type IN ('hero', 'text', 'image_strip', 'cards', 'banner', 'carousel', 'logo_row', 'newsletter', 'questionnaires', 'contact_banner', 'instructors_grid', 'static_programs') WHERE c0_.page_key = ? AND c0_.is_active = 1 ORDER BY c1_.position ASC"
  "params" => [
    1 => "find_out"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.area AS area_2, c0_.image_key AS image_key_3, c0_.estimated_minutes AS estimated_minutes_4, c0_.duration_minutes_min AS duration_minutes_min_5, c0_.duration_minutes_max AS duration_minutes_max_6, c0_.require_all_answers AS require_all_answers_7, c0_.is_active AS is_active_8, c0_.position AS position_9, c0_.texts AS texts_10, c1_.id AS id_11, c1_.position AS position_12, c1_.texts AS texts_13, c2_.id AS id_14, c2_.position AS position_15, c2_.texts AS texts_16, c3_.id AS id_17, c3_.position AS position_18, c3_.texts AS texts_19, c3_.is_active AS is_active_20, c4_.id AS id_21, c4_.position AS position_22, c4_.score_min AS score_min_23, c4_.score_max AS score_max_24, c4_.texts AS texts_25, c0_.professional_profile_id AS professional_profile_id_26, c0_.recommended_specialty_id AS recommended_specialty_id_27, c1_.questionnaire_id AS questionnaire_id_28, c2_.questionnaire_id AS questionnaire_id_29, c3_.section_id AS section_id_30, c3_.block_id AS block_id_31, c3_.competence_id AS competence_id_32, c4_.questionnaire_id AS questionnaire_id_33 FROM content_questionnaires c0_ LEFT JOIN content_questionnaire_competences c1_ ON c0_.id = c1_.questionnaire_id LEFT JOIN content_questionnaire_sections c2_ ON c0_.id = c2_.questionnaire_id LEFT JOIN content_questionnaire_questions c3_ ON c2_.id = c3_.section_id LEFT JOIN content_questionnaire_result_profiles c4_ ON c0_.id = c4_.questionnaire_id WHERE c0_.is_active = 1 ORDER BY c0_.position ASC, c1_.position ASC, c2_.position ASC, c3_.position ASC, c4_.position ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"\x01 úHƒÀ~^¹¤ |ù\x13¼\x0F"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"\x01 úHƒÁp\x10žbé:>·\x14Ã"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"\x01 úHƒå{““jZ‘\x03\x18""
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"\x01 úHƒå};“jZ“­¾O"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"\x01 úH„\x05så¥\x04†Š¡k_$"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"\x01 úH„\x05u-¥\x04†Š¤ï†E"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"\x01 úH„%rÌ—Ä!wFÄnæ"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"""
      \x01 úH„%sì—Ä!wK@\n
      \x03
      """
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"\x01 úH„J}¬¢öÓ\x03Däî"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"\x01 úH„J~è¢öÓ\x03Ižå›"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"\x01 úH„jqaˆLÛ¤P;ÒW"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.is_active AS is_active_4, t0.section_id AS section_id_5, t0.block_id AS block_id_6, t0.competence_id AS competence_id_7 FROM content_questionnaire_questions t0 WHERE t0.block_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"\x01 úH„jr…ˆLÛ¤Q¯…N"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.texts AS texts_3, t0.questionnaire_id AS questionnaire_id_4 FROM content_questionnaire_blocks t0 WHERE t0.questionnaire_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => b"\x01 úH„¥|„Š5Ó7æ\x18\x02x"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#661
      +name: "STRING"
    }
  ]
]

[
  "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 {#661
      +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 {#661
      +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 {#661
      +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 {#661
      +name: "STRING"
    }
  ]
]