Symfony Profiler

[
  "route" => "frontend_home"
  "route_parameters" => [
    "_route" => "frontend_home"
    "_controller" => "App\Controller\FrontendController::home"
  ]
  "request_uri" => "https://sub4.test2md.b--w.pl/"
  "method" => "GET"
]

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

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

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "c2test2"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "c2db2test"
    "serverVersion" => "10.3.28-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.is_default AS is_default_3, l0_.created_at AS created_at_4 FROM language l0_ WHERE l0_.is_default = 1 ORDER BY l0_.id ASC LIMIT 1"
]

[
  "sql" => "SELECT DISTINCT s0_.subdomain AS subdomain_0 FROM site s0_ WHERE s0_.is_active = ? AND s0_.subdomain IS NOT NULL AND s0_.subdomain <> ?"
  "params" => [
    1 => 1
    2 => ""
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1131
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1044
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.subdomain AS subdomain_2, s0_.is_active AS is_active_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5 FROM site s0_ WHERE (s0_.subdomain IS NULL OR s0_.subdomain = ?) AND s0_.is_active = ? ORDER BY s0_.id ASC LIMIT 1"
  "params" => [
    1 => ""
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1044
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1131
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.meta_title AS meta_title_3, p0_.meta_description AS meta_description_4, p0_.meta_keywords AS meta_keywords_5, p0_.og_title AS og_title_6, p0_.og_description AS og_description_7, p0_.og_image AS og_image_8, p0_.is_published AS is_published_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.page_id AS page_id_12, p0_.language_id AS language_id_13 FROM page_translation p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id WHERE p0_.language_id = ? AND p0_.is_published = 1 AND p1_.is_homepage = 1 AND p1_.deleted_at IS NULL AND p1_.site_id = ? ORDER BY p0_.id ASC LIMIT 1"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1129
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1129}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.template AS template_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.meta_keywords AS meta_keywords_7, t0.og_title AS og_title_8, t0.og_description AS og_description_9, t0.og_image AS og_image_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.is_homepage AS is_homepage_14, t0.asset_set_id AS asset_set_id_15, t0.site_id AS site_id_16 FROM page t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1129
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.blog_prefix AS blog_prefix_1, a0_.custom_head_code AS custom_head_code_2, a0_.custom_footer_code AS custom_footer_code_3 FROM app_configuration a0_ LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.styles AS styles_3, t0.associated_template AS associated_template_4, t0.site_id AS site_id_5 FROM asset_set t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1129
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.is_default AS is_default_3, l0_.created_at AS created_at_4 FROM language l0_ WHERE l0_.code = ? ORDER BY l0_.id ASC LIMIT 1"
  "params" => [
    1 => "pl"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1044
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.is_default AS is_default_3, l0_.created_at AS created_at_4 FROM language l0_ WHERE l0_.is_default = 1 ORDER BY l0_.id ASC LIMIT 1"
]

[
  "sql" => "SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.handle AS handle_2, n0_.site_id AS site_id_3, n0_.language_id AS language_id_4 FROM navigation_menu n0_ INNER JOIN language l1_ ON n0_.language_id = l1_.id WHERE n0_.handle = ? AND l1_.code = ? AND n0_.site_id = ? ORDER BY n0_.id ASC LIMIT 1"
  "params" => [
    1 => "main-menu"
    2 => "pl"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1044
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1044}
    3 => Doctrine\DBAL\ParameterType {#1129
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.handle AS handle_2, n0_.site_id AS site_id_3, n0_.language_id AS language_id_4 FROM navigation_menu n0_ INNER JOIN language l1_ ON n0_.language_id = l1_.id WHERE n0_.handle = ? AND l1_.code = ? AND n0_.site_id IS NULL ORDER BY n0_.id ASC LIMIT 1"
  "params" => [
    1 => "main-menu"
    2 => "pl"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1044
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1044}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.target AS target_4, t0.position AS position_5, t0.menu_id AS menu_id_6, t0.parent_id AS parent_id_7 FROM navigation_item t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1129
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.target AS target_4, t0.position AS position_5, t0.menu_id AS menu_id_6, t0.parent_id AS parent_id_7 FROM navigation_item t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1129
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.target AS target_4, t0.position AS position_5, t0.menu_id AS menu_id_6, t0.parent_id AS parent_id_7 FROM navigation_item t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1129
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.is_default AS is_default_3, l0_.created_at AS created_at_4 FROM language l0_ WHERE l0_.code = ? ORDER BY l0_.id ASC LIMIT 1"
  "params" => [
    1 => "pl"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1044
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.is_default AS is_default_3, l0_.created_at AS created_at_4 FROM language l0_ ORDER BY l0_.is_default DESC, l0_.name ASC"
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.is_default AS is_default_3, l0_.created_at AS created_at_4 FROM language l0_ WHERE l0_.code = ? ORDER BY l0_.id ASC LIMIT 1"
  "params" => [
    1 => "pl"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1044
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.og_title AS og_title_7, t0.og_description AS og_description_8, t0.og_image AS og_image_9, t0.is_published AS is_published_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.page_id AS page_id_13, t0.language_id AS language_id_14 FROM page_translation t0 WHERE t0.page_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1129
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.is_default AS is_default_3, l0_.created_at AS created_at_4 FROM language l0_ WHERE l0_.is_default = 1 ORDER BY l0_.id ASC LIMIT 1"
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.is_default AS is_default_3, l0_.created_at AS created_at_4 FROM language l0_ WHERE l0_.code = ? ORDER BY l0_.id ASC LIMIT 1"
  "params" => [
    1 => "en"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1044
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.is_default AS is_default_3, l0_.created_at AS created_at_4 FROM language l0_ WHERE l0_.is_default = 1 ORDER BY l0_.id ASC LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.content AS content_2, t0.position AS position_3, t0.visible AS visible_4, t0.page_translation_id AS page_translation_id_5, t0.blog_post_translation_id AS blog_post_translation_id_6, t0.definition_id AS definition_id_7 FROM block_instance t0 WHERE t0.page_translation_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1129
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.handle AS handle_3, t0.fields AS fields_4 FROM block_definition t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1129
      +name: "INTEGER"
    }
  ]
]