Symfony Profiler

[
  "route" => "home_page"
  "route_parameters" => [
    "_route" => "home_page"
    "_controller" => "App\Controller\Main\HomeController::homePage"
  ]
  "request_uri" => "https://www.main.postmark.co.za/"
  "method" => "GET"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "postmark_postmark_v2"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "10.11.16"
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "postmark_postmark"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT p0_.created_at AS created_at_0, p0_.updated_at AS updated_at_1, p0_.image AS image_2, p0_.image_directory AS image_directory_3, p0_.id AS id_4, p0_.name AS name_5, p0_.status AS status_6, p0_.quantity AS quantity_7, p0_.price AS price_8, p0_.short_description AS short_description_9, p0_.detailed_description AS detailed_description_10, p0_.specifications AS specifications_11, p0_.category_id AS category_id_12 FROM products p0_ LEFT JOIN product_categories p1_ ON p0_.category_id = p1_.id ORDER BY p0_.name ASC LIMIT 8"
]

[
  "sql" => "SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.image_directory AS image_directory_4, t0.id AS id_5, t0.customer_name AS customer_name_6, t0.customer_email AS customer_email_7, t0.message AS message_8, t0.is_disabled AS is_disabled_9, t0.customer_id AS customer_id_10 FROM testimonials t0 WHERE t0.is_disabled = ?"
  "params" => [
    1 => 0
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1169
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t1.created_at AS created_at_2, t1.updated_at AS updated_at_3, t1.id AS id_4, t1.roles AS roles_5, t1.password AS password_6, t1.first_name AS first_name_7, t1.last_name AS last_name_8, t1.email AS email_9, t1.last_login AS last_login_10, t1.phone AS phone_11, t1.active AS active_12, t0.is_verified AS is_verified_13, t0.confirmation_token AS confirmation_token_14, t0.token_expires_at AS token_expires_at_15, t1.user_type FROM customers t0 INNER JOIN users t1 ON t0.id = t1.id WHERE t1.id = ?"
  "params" => [
    1 => b"\x01ž\x1AÓÊ¿yc¶÷¾™\x07^r\x11"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1166
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.image_directory AS image_directory_4, t0.id AS id_5, t0.customer_name AS customer_name_6, t0.customer_email AS customer_email_7, t0.message AS message_8, t0.is_disabled AS is_disabled_9, t0.customer_id AS customer_id_10 FROM testimonials t0 WHERE t0.customer_id = ?"
  "params" => [
    1 => b"\x01ž\x1AÓÊ¿yc¶÷¾™\x07^r\x11"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1166
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.customer_id AS customer_id_4 FROM carts t0 WHERE t0.customer_id = ?"
  "params" => [
    1 => b"\x01ž\x1AÓÊ¿yc¶÷¾™\x07^r\x11"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1166
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t1.created_at AS created_at_2, t1.updated_at AS updated_at_3, t1.id AS id_4, t1.roles AS roles_5, t1.password AS password_6, t1.first_name AS first_name_7, t1.last_name AS last_name_8, t1.email AS email_9, t1.last_login AS last_login_10, t1.phone AS phone_11, t1.active AS active_12, t0.is_verified AS is_verified_13, t0.confirmation_token AS confirmation_token_14, t0.token_expires_at AS token_expires_at_15, t1.user_type FROM customers t0 INNER JOIN users t1 ON t0.id = t1.id WHERE t1.id = ?"
  "params" => [
    1 => b"\x01ž\x1AÓÌÐp+˜Á6ø\x1Ax@»"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1166
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.image_directory AS image_directory_4, t0.id AS id_5, t0.customer_name AS customer_name_6, t0.customer_email AS customer_email_7, t0.message AS message_8, t0.is_disabled AS is_disabled_9, t0.customer_id AS customer_id_10 FROM testimonials t0 WHERE t0.customer_id = ?"
  "params" => [
    1 => b"\x01ž\x1AÓÌÐp+˜Á6ø\x1Ax@»"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1166
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.customer_id AS customer_id_4 FROM carts t0 WHERE t0.customer_id = ?"
  "params" => [
    1 => b"\x01ž\x1AÓÌÐp+˜Á6ø\x1Ax@»"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1166
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t1.created_at AS created_at_2, t1.updated_at AS updated_at_3, t1.id AS id_4, t1.roles AS roles_5, t1.password AS password_6, t1.first_name AS first_name_7, t1.last_name AS last_name_8, t1.email AS email_9, t1.last_login AS last_login_10, t1.phone AS phone_11, t1.active AS active_12, t0.is_verified AS is_verified_13, t0.confirmation_token AS confirmation_token_14, t0.token_expires_at AS token_expires_at_15, t1.user_type FROM customers t0 INNER JOIN users t1 ON t0.id = t1.id WHERE t1.id = ?"
  "params" => [
    1 => b"\x01ž\x1AÓÎØxJš‘\eÚå!1å"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1166
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.image_directory AS image_directory_4, t0.id AS id_5, t0.customer_name AS customer_name_6, t0.customer_email AS customer_email_7, t0.message AS message_8, t0.is_disabled AS is_disabled_9, t0.customer_id AS customer_id_10 FROM testimonials t0 WHERE t0.customer_id = ?"
  "params" => [
    1 => b"\x01ž\x1AÓÎØxJš‘\eÚå!1å"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1166
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.customer_id AS customer_id_4 FROM carts t0 WHERE t0.customer_id = ?"
  "params" => [
    1 => b"\x01ž\x1AÓÎØxJš‘\eÚå!1å"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1166
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t1.created_at AS created_at_2, t1.updated_at AS updated_at_3, t1.id AS id_4, t1.roles AS roles_5, t1.password AS password_6, t1.first_name AS first_name_7, t1.last_name AS last_name_8, t1.email AS email_9, t1.last_login AS last_login_10, t1.phone AS phone_11, t1.active AS active_12, t0.is_verified AS is_verified_13, t0.confirmation_token AS confirmation_token_14, t0.token_expires_at AS token_expires_at_15, t1.user_type FROM customers t0 INNER JOIN users t1 ON t0.id = t1.id WHERE t1.id = ?"
  "params" => [
    1 => b"\x01ž\x1AÓÐárE¸*¼÷–GÓq"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1166
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.image_directory AS image_directory_4, t0.id AS id_5, t0.customer_name AS customer_name_6, t0.customer_email AS customer_email_7, t0.message AS message_8, t0.is_disabled AS is_disabled_9, t0.customer_id AS customer_id_10 FROM testimonials t0 WHERE t0.customer_id = ?"
  "params" => [
    1 => b"\x01ž\x1AÓÐárE¸*¼÷–GÓq"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1166
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.customer_id AS customer_id_4 FROM carts t0 WHERE t0.customer_id = ?"
  "params" => [
    1 => b"\x01ž\x1AÓÐárE¸*¼÷–GÓq"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1166
      +name: "STRING"
    }
  ]
]