Symfony Profiler

[
  "route" => "app_catalog"
  "route_parameters" => [
    "_route" => "app_catalog"
    "_controller" => "App\Controller\CatalogController::index"
    "typeSlug" => "device"
  ]
  "request_uri" => "https://loanhub.fhw.crowbyte.org/catalog/device?category=7"
  "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"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "loanhub"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "loanhub"
    "serverVersion" => "10.11.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6, t0.shibboleth_id AS shibboleth_id_7, t0.enabled AS enabled_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.last_login_at AS last_login_at_11 FROM app_user t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "admin@fhw.local"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.access_role AS access_role_6 FROM article_type t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "device"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1011
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.parent_id AS parent_id_4, c0_.article_type_id AS article_type_id_5 FROM category c0_ WHERE c0_.parent_id IS NULL AND c0_.article_type_id = ? ORDER BY c0_.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.inventory_number AS inventory_number_2, a0_.image AS image_3, a0_.description AS description_4, a0_.notes AS notes_5, a0_.status AS status_6, a0_.restrict_to_role AS restrict_to_role_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.article_type_id AS article_type_id_10, a0_.category_id AS category_id_11, a0_.created_by_id AS created_by_id_12 FROM article a0_ INNER JOIN article_type a1_ ON a0_.article_type_id = a1_.id WHERE a1_.slug = ? AND a0_.status <> ? AND a0_.category_id = ? ORDER BY a0_.name ASC"
  "params" => [
    1 => "device"
    2 => "decommissioned"
    3 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1011
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1011}
    3 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.access_role AS access_role_6 FROM article_type t0 ORDER BY t0.name ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.parent_id AS parent_id_5, t0.article_type_id AS article_type_id_6 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.parent_id AS parent_id_5, t0.article_type_id AS article_type_id_6 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.parent_id AS parent_id_5, t0.article_type_id AS article_type_id_6 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.parent_id AS parent_id_5, t0.article_type_id AS article_type_id_6 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.parent_id AS parent_id_5, t0.article_type_id AS article_type_id_6 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.parent_id AS parent_id_5, t0.article_type_id AS article_type_id_6 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 124
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 125
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 126
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 127
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 128
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 129
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 130
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 131
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 132
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 133
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 134
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 135
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 136
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 137
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 138
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 139
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 140
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 141
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 58
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.due_date AS due_date_3, t0.actual_return_date AS actual_return_date_4, t0.status AS status_5, t0.notes AS notes_6, t0.extension_requested AS extension_requested_7, t0.extension_requested_until AS extension_requested_until_8, t0.extension_note AS extension_note_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.article_id AS article_id_12, t0.user_id AS user_id_13, t0.handed_out_by_id AS handed_out_by_id_14, t0.returned_to_id AS returned_to_id_15, t0.created_by_id AS created_by_id_16 FROM loan t0 WHERE t0.article_id = ? ORDER BY t0.start_date DESC"
  "params" => [
    1 => 57
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#819
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]