Symfony Profiler

[
  "route" => "home"
  "route_parameters" => [
    "_route" => "home"
    "_controller" => "App\Controller\WebsiteController::home"
  ]
  "request_uri" => "https://www.school.quicksellsbd.com/public/"
  "method" => "GET"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "charset" => "utf8mb4"
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "birdbook_symfonySchoolInt"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "birdbook_symfony_school_int"
    "serverVersion" => "8.0.43"
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.logo AS logo_3, c0_.expiry_date AS expiry_date_4, c0_.status AS status_5, c0_.subdomain AS subdomain_6, c0_.name_bn AS name_bn_7, c0_.contact_mobile AS contact_mobile_8, c0_.contact_phone AS contact_phone_9, c0_.contact_email AS contact_email_10, c0_.module AS module_11, c0_.go_code AS go_code_12, c0_.sms_end_point AS sms_end_point_13, c0_.sms_api_key AS sms_api_key_14, c0_.sms_sender_id AS sms_sender_id_15, c0_.api_vendor AS api_vendor_16 FROM companies c0_ WHERE c0_.status = 1 AND c0_.module IN (?, ?) ORDER BY c0_.id ASC LIMIT 1"
  "params" => [
    1 => "education"
    2 => "school"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#567
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#567}
  ]
]

[
  "sql" => "SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = ? AND w0_.status = ? AND w0_.type = ? ORDER BY w0_.id DESC LIMIT 8"
  "params" => [
    1 => 1
    2 => 1
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#537
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#537}
    3 => Doctrine\DBAL\ParameterType {#537}
  ]
]

[
  "sql" => "SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = ? AND w0_.status = ? AND w0_.type = ? ORDER BY w0_.id DESC LIMIT 1"
  "params" => [
    1 => 1
    2 => 1
    3 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#537
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#537}
    3 => Doctrine\DBAL\ParameterType {#537}
  ]
]

[
  "sql" => "SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = ? AND w0_.status = ? AND w0_.type IN (?, ?, ?, ?, ?, ?) ORDER BY w0_.type ASC, w0_.id ASC"
  "params" => [
    1 => 1
    2 => 1
    3 => 2
    4 => 3
    5 => 4
    6 => 5
    7 => 6
    8 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#537
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#537}
    3 => Doctrine\DBAL\ParameterType {#537}
    4 => Doctrine\DBAL\ParameterType {#537}
    5 => Doctrine\DBAL\ParameterType {#537}
    6 => Doctrine\DBAL\ParameterType {#537}
    7 => Doctrine\DBAL\ParameterType {#537}
    8 => Doctrine\DBAL\ParameterType {#537}
  ]
]

[
  "sql" => "SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = ? AND w0_.status = ? AND w0_.type = ? ORDER BY w0_.id DESC LIMIT 6"
  "params" => [
    1 => 1
    2 => 1
    3 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#537
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#537}
    3 => Doctrine\DBAL\ParameterType {#537}
  ]
]

[
  "sql" => "SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = ? AND w0_.status = ? AND w0_.type = ? ORDER BY w0_.id DESC LIMIT 6"
  "params" => [
    1 => 1
    2 => 1
    3 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#537
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#537}
    3 => Doctrine\DBAL\ParameterType {#537}
  ]
]

[
  "sql" => "SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = ? AND w0_.status = ? AND w0_.type = ? ORDER BY w0_.id DESC LIMIT 8"
  "params" => [
    1 => 1
    2 => 1
    3 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#537
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#537}
    3 => Doctrine\DBAL\ParameterType {#537}
  ]
]

[
  "sql" => "SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = ? AND w0_.status = ? AND w0_.type = ? ORDER BY w0_.id DESC LIMIT 12"
  "params" => [
    1 => 1
    2 => 1
    3 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#537
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#537}
    3 => Doctrine\DBAL\ParameterType {#537}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.code AS code_3, c0_.alias AS alias_4, c0_.status AS status_5, c0_.created_by AS created_by_6, c0_.created_time AS created_time_7, c0_.updated_by AS updated_by_8, c0_.updated_time AS updated_time_9, c0_.company_id AS company_id_10 FROM campus c0_ WHERE c0_.status <> ? AND c0_.company_id = ? ORDER BY c0_.name ASC"
  "params" => [
    1 => 99
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#537
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#537}
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.teacher_id AS teacher_id_1, t0_.name AS name_2, t0_.phone AS phone_3, t0_.email AS email_4, t0_.gender AS gender_5, t0_.date_of_birth AS date_of_birth_6, t0_.joining_date AS joining_date_7, t0_.qualification AS qualification_8, t0_.designation AS designation_9, t0_.address AS address_10, t0_.photo AS photo_11, t0_.specialization AS specialization_12, t0_.salary AS salary_13, t0_.status AS status_14, t0_.created_by AS created_by_15, t0_.created_time AS created_time_16, t0_.updated_by AS updated_by_17, t0_.updated_time AS updated_time_18, t0_.company_id AS company_id_19, t0_.user_id AS user_id_20 FROM teacher t0_ WHERE t0_.company_id = ? AND t0_.status = 1 ORDER BY t0_.name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#537
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(s0_.id) AS sclr_0 FROM student_info s0_ WHERE s0_.status <> ? AND s0_.company_id = ?"
  "params" => [
    1 => 99
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#537
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#537}
  ]
]