Symfony Profiler

[
  "route" => "app_categories"
  "route_parameters" => [
    "_route" => "app_categories"
    "_controller" => "App\Controller\CategoriesController::index"
  ]
  "request_uri" => "http://www.newvirtualrealityporn.com/categories"
  "method" => "GET"
]

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "ucdwassb_nvrp"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "ucdwassb_nvrp8"
    "serverVersion" => "8.0.39-0ubuntu0.24.04.2"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.out_slug AS out_slug_3, c0_.active AS active_4, c0_.sort_order AS sort_order_5, c0_.featured AS featured_6, c0_.short_description AS short_description_7, c0_.description AS description_8 FROM category c0_ WHERE c0_.featured = 1 ORDER BY c0_.sort_order ASC"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.out_slug AS out_slug_3, c0_.active AS active_4, c0_.sort_order AS sort_order_5, c0_.featured AS featured_6, c0_.short_description AS short_description_7, c0_.description AS description_8, CASE WHEN SUBSTRING(c0_.name FROM 1 FOR 1) BETWEEN '0' AND '9' THEN '#' ELSE UPPER(SUBSTRING(c0_.name FROM 1 FOR 1)) END AS sclr_9 FROM category c0_ WHERE c0_.active = ? ORDER BY sclr_9 ASC, c0_.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1074
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 93
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 40
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 94
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 63
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 45
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 35
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 56
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 110
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 26
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 98
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 105
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 120
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 126
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 77
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 91
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 54
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 99
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 57
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 27
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 125
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?"
  "params" => [
    1 => 61
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1078
      +name: "INTEGER"
    }
  ]
]