Symfony Profiler

[
  "route" => "app_blog_index"
  "route_parameters" => [
    "_route" => "app_blog_index"
    "_controller" => "App\Marketing\Content\Controller\BlogController::index"
  ]
  "request_uri" => "https://vendordesk-dev.marello.com/blog"
  "method" => "GET"
]

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "vdeskbackoffice_db"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "vdeskbackoffice_db"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.domain AS domain_4, t0.is_active AS is_active_5, t0.api_token AS api_token_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM organization t0 WHERE t0.domain = ? AND t0.is_active = ? LIMIT 1"
  "params" => [
    1 => "vendordesk-dev.marello.com"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2233
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2217
      +name: "BOOLEAN"
    }
  ]
]

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

[
  "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"
]

[
  "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"
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.status AS status_2, m0_.title AS title_3, m0_.tags AS tags_4, m0_.excerpt AS excerpt_5, m0_.body AS body_6, m0_.meta_title AS meta_title_7, m0_.meta_description AS meta_description_8, m0_.ai_provider AS ai_provider_9, m0_.failure_reason AS failure_reason_10, m0_.image_brief AS image_brief_11, m0_.image_url AS image_url_12, m0_.image_attribution AS image_attribution_13, m0_.image_candidates AS image_candidates_14, m0_.image_provider AS image_provider_15, m0_.slug AS slug_16, m0_.scheduled_for AS scheduled_for_17, m0_.published_at AS published_at_18, m0_.linkedin_post_urn AS linkedin_post_urn_19, m0_.linkedin_posted_at AS linkedin_posted_at_20, m0_.created_at AS created_at_21, m0_.updated_at AS updated_at_22, m0_.topic_id AS topic_id_23, m0_.organization_id AS organization_id_24, m0_.created_by_id AS created_by_id_25, m0_.updated_by_id AS updated_by_id_26 FROM marketing_content_piece m0_ WHERE m0_.status = ? AND m0_.type = ? AND m0_.slug IS NOT NULL ORDER BY m0_.published_at DESC LIMIT 13"
  "params" => [
    1 => "published"
    2 => "blog_post"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2233
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2233}
  ]
]

[
  "sql" => "SELECT COUNT(m0_.id) AS sclr_0 FROM marketing_content_piece m0_ WHERE m0_.status = ? AND m0_.type = ? AND m0_.slug IS NOT NULL"
  "params" => [
    1 => "published"
    2 => "blog_post"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2233
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2233}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.appearance AS appearance_3, c0_.is_system AS is_system_4, c0_.is_enabled AS is_enabled_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.organization_id AS organization_id_9 FROM cms_menu c0_ WHERE (c0_.code = ? AND c0_.deleted_at IS NULL AND c0_.is_enabled = true) AND (c0_.deleted_at IS NULL) LIMIT 1"
  "params" => [
    1 => "main"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2233
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.target_slug AS target_slug_2, c0_.target_uri AS target_uri_3, c0_.sort_order AS sort_order_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c1_.id AS id_7, c1_.locale AS locale_8, c1_.name AS name_9, c0_.menu_id AS menu_id_10, c0_.parent_id AS parent_id_11, c0_.organization_id AS organization_id_12, c1_.node_id AS node_id_13 FROM cms_menu_node c0_ LEFT JOIN cms_menu_node_translation c1_ ON c0_.id = c1_.node_id WHERE c0_.menu_id = ? ORDER BY c0_.sort_order ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2234
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.target_slug AS target_slug_3, t0.target_uri AS target_uri_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.menu_id AS menu_id_8, t0.parent_id AS parent_id_9, t0.organization_id AS organization_id_10 FROM cms_menu_node t0 WHERE t0.menu_id = ? ORDER BY t0.sort_order ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2234
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.appearance AS appearance_3, c0_.is_system AS is_system_4, c0_.is_enabled AS is_enabled_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.organization_id AS organization_id_9 FROM cms_menu c0_ WHERE (c0_.code = ? AND c0_.deleted_at IS NULL AND c0_.is_enabled = true) AND (c0_.deleted_at IS NULL) LIMIT 1"
  "params" => [
    1 => "nav-cta"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2233
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.target_slug AS target_slug_2, c0_.target_uri AS target_uri_3, c0_.sort_order AS sort_order_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c1_.id AS id_7, c1_.locale AS locale_8, c1_.name AS name_9, c0_.menu_id AS menu_id_10, c0_.parent_id AS parent_id_11, c0_.organization_id AS organization_id_12, c1_.node_id AS node_id_13 FROM cms_menu_node c0_ LEFT JOIN cms_menu_node_translation c1_ ON c0_.id = c1_.node_id WHERE c0_.menu_id = ? ORDER BY c0_.sort_order ASC"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2234
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.target_slug AS target_slug_3, t0.target_uri AS target_uri_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.menu_id AS menu_id_8, t0.parent_id AS parent_id_9, t0.organization_id AS organization_id_10 FROM cms_menu_node t0 WHERE t0.menu_id = ? ORDER BY t0.sort_order ASC"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2234
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.appearance AS appearance_3, c0_.is_system AS is_system_4, c0_.is_enabled AS is_enabled_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.organization_id AS organization_id_9 FROM cms_menu c0_ WHERE (c0_.code = ? AND c0_.deleted_at IS NULL AND c0_.is_enabled = true) AND (c0_.deleted_at IS NULL) LIMIT 1"
  "params" => [
    1 => "footer"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2233
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.target_slug AS target_slug_2, c0_.target_uri AS target_uri_3, c0_.sort_order AS sort_order_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c1_.id AS id_7, c1_.locale AS locale_8, c1_.name AS name_9, c0_.menu_id AS menu_id_10, c0_.parent_id AS parent_id_11, c0_.organization_id AS organization_id_12, c1_.node_id AS node_id_13 FROM cms_menu_node c0_ LEFT JOIN cms_menu_node_translation c1_ ON c0_.id = c1_.node_id WHERE c0_.menu_id = ? ORDER BY c0_.sort_order ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2234
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.target_slug AS target_slug_3, t0.target_uri AS target_uri_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.menu_id AS menu_id_8, t0.parent_id AS parent_id_9, t0.organization_id AS organization_id_10 FROM cms_menu_node t0 WHERE t0.menu_id = ? ORDER BY t0.sort_order ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2234
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.code AS code_2, c0_.appearance AS appearance_3, c0_.is_system AS is_system_4, c0_.is_enabled AS is_enabled_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.organization_id AS organization_id_9 FROM cms_menu c0_ WHERE (c0_.code = ? AND c0_.deleted_at IS NULL AND c0_.is_enabled = true) AND (c0_.deleted_at IS NULL) LIMIT 1"
  "params" => [
    1 => "legal"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2233
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.target_slug AS target_slug_2, c0_.target_uri AS target_uri_3, c0_.sort_order AS sort_order_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c1_.id AS id_7, c1_.locale AS locale_8, c1_.name AS name_9, c0_.menu_id AS menu_id_10, c0_.parent_id AS parent_id_11, c0_.organization_id AS organization_id_12, c1_.node_id AS node_id_13 FROM cms_menu_node c0_ LEFT JOIN cms_menu_node_translation c1_ ON c0_.id = c1_.node_id WHERE c0_.menu_id = ? ORDER BY c0_.sort_order ASC"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2234
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.target_slug AS target_slug_3, t0.target_uri AS target_uri_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.menu_id AS menu_id_8, t0.parent_id AS parent_id_9, t0.organization_id AS organization_id_10 FROM cms_menu_node t0 WHERE t0.menu_id = ? ORDER BY t0.sort_order ASC"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2234
      +name: "INTEGER"
    }
  ]
]