Symfony Profiler

[
  "route" => "app_category"
  "route_parameters" => [
    "_route" => "app_category"
    "page" => 1
    "_controller" => "App\Controller\CategoriesController::category"
    "slug" => "hard"
  ]
  "request_uri" => "https://newvirtualrealityporn.com/tags/hard"
  "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 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.sort_order AS sort_order_6, t0.featured AS featured_7, t0.short_description AS short_description_8, t0.description AS description_9 FROM category t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "hard"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#763
      +name: "STRING"
    }
  ]
]

[
  "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 => 71
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.slug AS slug_2, v0_.out_slug AS out_slug_3, v0_.active AS active_4, v0_.release_date AS release_date_5, v0_.duration AS duration_6, v0_.fps AS fps_7, v0_.angle AS angle_8, v0_.resolution AS resolution_9, v0_.sound AS sound_10, v0_.description AS description_11 FROM video v0_ INNER JOIN video_category v2_ ON v0_.id = v2_.video_id INNER JOIN category c1_ ON c1_.id = v2_.category_id WHERE v0_.active = ? AND c1_.id = ? ORDER BY v0_.release_date DESC, v0_.id DESC) dctrn_result) dctrn_table"
  "params" => [
    1 => 1
    2 => 71
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#765}
  ]
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, release_date_5 FROM (SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.slug AS slug_2, v0_.out_slug AS out_slug_3, v0_.active AS active_4, v0_.release_date AS release_date_5, v0_.duration AS duration_6, v0_.fps AS fps_7, v0_.angle AS angle_8, v0_.resolution AS resolution_9, v0_.sound AS sound_10, v0_.description AS description_11, c1_.id AS id_12, c1_.name AS name_13, c1_.slug AS slug_14, c1_.out_slug AS out_slug_15, c1_.active AS active_16, c1_.sort_order AS sort_order_17, c1_.featured AS featured_18, c1_.short_description AS short_description_19, c1_.description AS description_20 FROM video v0_ INNER JOIN video_category v2_ ON v0_.id = v2_.video_id INNER JOIN category c1_ ON c1_.id = v2_.category_id WHERE v0_.active = ? AND c1_.id = ?) dctrn_result_inner ORDER BY release_date_5 DESC, id_0 DESC) dctrn_result LIMIT 24"
  "params" => [
    1 => 1
    2 => 71
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#765}
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.slug AS slug_2, v0_.out_slug AS out_slug_3, v0_.active AS active_4, v0_.release_date AS release_date_5, v0_.duration AS duration_6, v0_.fps AS fps_7, v0_.angle AS angle_8, v0_.resolution AS resolution_9, v0_.sound AS sound_10, v0_.description AS description_11, v0_.studio_id AS studio_id_12 FROM video v0_ INNER JOIN video_category v2_ ON v0_.id = v2_.video_id INNER JOIN category c1_ ON c1_.id = v2_.category_id WHERE v0_.active = ? AND c1_.id = ? AND v0_.id IN (?, ?, ?) ORDER BY v0_.release_date DESC, v0_.id DESC"
  "params" => [
    1 => 1
    2 => 71
    3 => 5
    4 => 4
    5 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#765}
    3 => Doctrine\DBAL\ParameterType {#765}
    4 => Doctrine\DBAL\ParameterType {#765}
    5 => Doctrine\DBAL\ParameterType {#765}
  ]
]

[
  "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.sort_order AS sort_order_6, t0.description AS description_7, t0.cos_address AS cos_address_8, t0.country AS country_9, t0.founded AS founded_10 FROM studio t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +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.sort_order AS sort_order_6, t0.date_of_birth AS date_of_birth_7, t0.nationality AS nationality_8, t0.gender AS gender_9, t0.ethnicity AS ethnicity_10, t0.hair_color AS hair_color_11, t0.eye_color AS eye_color_12, t0.height AS height_13, t0.weight AS weight_14, t0.measurements_hip AS measurements_hip_15, t0.measurements_waist AS measurements_waist_16, t0.measurements_bust AS measurements_bust_17, t0.shoe_size AS shoe_size_18, t0.description AS description_19, t0.views AS views_20 FROM model t0 INNER JOIN video_model ON t0.id = video_model.model_id WHERE video_model.video_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +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.sort_order AS sort_order_6, t0.featured AS featured_7, t0.short_description AS short_description_8, t0.description AS description_9 FROM category t0 INNER JOIN video_category ON t0.id = video_category.category_id WHERE video_category.video_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +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.sort_order AS sort_order_6, t0.description AS description_7, t0.cos_address AS cos_address_8, t0.country AS country_9, t0.founded AS founded_10 FROM studio t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +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.sort_order AS sort_order_6, t0.date_of_birth AS date_of_birth_7, t0.nationality AS nationality_8, t0.gender AS gender_9, t0.ethnicity AS ethnicity_10, t0.hair_color AS hair_color_11, t0.eye_color AS eye_color_12, t0.height AS height_13, t0.weight AS weight_14, t0.measurements_hip AS measurements_hip_15, t0.measurements_waist AS measurements_waist_16, t0.measurements_bust AS measurements_bust_17, t0.shoe_size AS shoe_size_18, t0.description AS description_19, t0.views AS views_20 FROM model t0 INNER JOIN video_model ON t0.id = video_model.model_id WHERE video_model.video_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +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.sort_order AS sort_order_6, t0.featured AS featured_7, t0.short_description AS short_description_8, t0.description AS description_9 FROM category t0 INNER JOIN video_category ON t0.id = video_category.category_id WHERE video_category.video_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +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.sort_order AS sort_order_6, t0.description AS description_7, t0.cos_address AS cos_address_8, t0.country AS country_9, t0.founded AS founded_10 FROM studio t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +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.sort_order AS sort_order_6, t0.date_of_birth AS date_of_birth_7, t0.nationality AS nationality_8, t0.gender AS gender_9, t0.ethnicity AS ethnicity_10, t0.hair_color AS hair_color_11, t0.eye_color AS eye_color_12, t0.height AS height_13, t0.weight AS weight_14, t0.measurements_hip AS measurements_hip_15, t0.measurements_waist AS measurements_waist_16, t0.measurements_bust AS measurements_bust_17, t0.shoe_size AS shoe_size_18, t0.description AS description_19, t0.views AS views_20 FROM model t0 INNER JOIN video_model ON t0.id = video_model.model_id WHERE video_model.video_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +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.sort_order AS sort_order_6, t0.featured AS featured_7, t0.short_description AS short_description_8, t0.description AS description_9 FROM category t0 INNER JOIN video_category ON t0.id = video_category.category_id WHERE video_category.video_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#765
      +name: "INTEGER"
    }
  ]
]