Symfony Profiler

[
  "route" => "admin_category_index"
  "route_parameters" => [
    "_route" => "admin_category_index"
    "_locale" => "en"
    "_controller" => "App\Controller\Admin\CategoryCrudController::index"
    "routeCreatedByEasyAdmin" => true
    "dashboardControllerFqcn" => "App\Controller\Admin\DashboardController"
    "crudControllerFqcn" => "App\Controller\Admin\CategoryCrudController"
    "crudAction" => "index"
  ]
  "request_uri" => "https://admin.webuni.com/en/admin/category?page=1&sort%5Bposts%5D=ASC"
  "method" => "GET"
]

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

[
  "params" => [
    "driver" => "pdo_sqlite"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => null
    "user" => "root"
    "password" => null
    "driverOptions" => []
    "defaultTableOptions" => []
    "path" => "/var/www/html/admin.webuni.com/var/data.db"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT DISTINCT c0_.id AS id_0, (SELECT COUNT(p1_.id) AS sclr_2 FROM post p1_ WHERE p1_.category_id = c0_.id) AS sclr_1, c0_.id AS id_3, c0_.position AS position_4 FROM category c0_ LEFT JOIN post p2_ ON c0_.id = p2_.category_id ORDER BY sclr_1 ASC, c0_.id ASC, c0_.position ASC LIMIT 20"
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.color AS color_4, c0_.icon AS icon_5, c0_.position AS position_6, c0_.created_at AS created_at_7, (SELECT COUNT(p1_.id) AS sclr_9 FROM post p1_ WHERE p1_.category_id = c0_.id) AS sclr_8 FROM category c0_ LEFT JOIN post p2_ ON c0_.id = p2_.category_id WHERE c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY sclr_8 ASC, c0_.id ASC, c0_.position ASC"
  "params" => [
    1 => 1
    2 => 2
    3 => 6
    4 => 7
    5 => 3
    6 => 8
    7 => 5
    8 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1342
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1342}
    3 => Doctrine\DBAL\ParameterType {#1342}
    4 => Doctrine\DBAL\ParameterType {#1342}
    5 => Doctrine\DBAL\ParameterType {#1342}
    6 => Doctrine\DBAL\ParameterType {#1342}
    7 => Doctrine\DBAL\ParameterType {#1342}
    8 => Doctrine\DBAL\ParameterType {#1342}
  ]
]

[
  "sql" => "SELECT count(DISTINCT c0_.id) AS sclr_0 FROM category c0_ LEFT JOIN post p1_ ON c0_.id = p1_.category_id"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.status AS status_7, t0.featured_image AS featured_image_8, t0.scheduled_at AS scheduled_at_9, t0.view_count AS view_count_10, t0.is_featured AS is_featured_11, t0.series_position AS series_position_12, t0.author_id AS author_id_13, t0.category_id AS category_id_14, t0.series_id AS series_id_15 FROM post t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1342
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.status AS status_7, t0.featured_image AS featured_image_8, t0.scheduled_at AS scheduled_at_9, t0.view_count AS view_count_10, t0.is_featured AS is_featured_11, t0.series_position AS series_position_12, t0.author_id AS author_id_13, t0.category_id AS category_id_14, t0.series_id AS series_id_15 FROM post t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1342
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.status AS status_7, t0.featured_image AS featured_image_8, t0.scheduled_at AS scheduled_at_9, t0.view_count AS view_count_10, t0.is_featured AS is_featured_11, t0.series_position AS series_position_12, t0.author_id AS author_id_13, t0.category_id AS category_id_14, t0.series_id AS series_id_15 FROM post t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1342
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.status AS status_7, t0.featured_image AS featured_image_8, t0.scheduled_at AS scheduled_at_9, t0.view_count AS view_count_10, t0.is_featured AS is_featured_11, t0.series_position AS series_position_12, t0.author_id AS author_id_13, t0.category_id AS category_id_14, t0.series_id AS series_id_15 FROM post t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1342
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.status AS status_7, t0.featured_image AS featured_image_8, t0.scheduled_at AS scheduled_at_9, t0.view_count AS view_count_10, t0.is_featured AS is_featured_11, t0.series_position AS series_position_12, t0.author_id AS author_id_13, t0.category_id AS category_id_14, t0.series_id AS series_id_15 FROM post t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1342
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.status AS status_7, t0.featured_image AS featured_image_8, t0.scheduled_at AS scheduled_at_9, t0.view_count AS view_count_10, t0.is_featured AS is_featured_11, t0.series_position AS series_position_12, t0.author_id AS author_id_13, t0.category_id AS category_id_14, t0.series_id AS series_id_15 FROM post t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1342
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.status AS status_7, t0.featured_image AS featured_image_8, t0.scheduled_at AS scheduled_at_9, t0.view_count AS view_count_10, t0.is_featured AS is_featured_11, t0.series_position AS series_position_12, t0.author_id AS author_id_13, t0.category_id AS category_id_14, t0.series_id AS series_id_15 FROM post t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1342
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.status AS status_7, t0.featured_image AS featured_image_8, t0.scheduled_at AS scheduled_at_9, t0.view_count AS view_count_10, t0.is_featured AS is_featured_11, t0.series_position AS series_position_12, t0.author_id AS author_id_13, t0.category_id AS category_id_14, t0.series_id AS series_id_15 FROM post t0 WHERE t0.category_id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1342
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM post t0 WHERE t0.status = ?"
  "params" => [
    1 => "draft"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#3650
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM comment t0 WHERE t0.status = ?"
  "params" => [
    1 => "pending"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#3650
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM subscriber t0 WHERE t0.is_confirmed = ?"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#3737
      +name: "BOOLEAN"
    }
  ]
]