Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\ArticleController::index"
    "project" => "scientia"
  ]
  "request_uri" => "https://psychofact.fr/scientia?category=novlangue_controle_cognitif&page=0"
  "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" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "1i4tgg.myd.infomaniak.com"
    "port" => 3306
    "user" => "1i4tgg_claudia"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "1i4tgg_SCIENTIA_credolab"
    "serverVersion" => "mariadb-10.6.20"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.tagline AS tagline_4, t0.description AS description_5, t0.color_primary AS color_primary_6, t0.color_header_start AS color_header_start_7, t0.color_header_end AS color_header_end_8, t0.logo AS logo_9, t0.position AS position_10, t0.is_active AS is_active_11 FROM project t0 WHERE t0.slug = ? LIMIT 1"
  "params" => [
    1 => "scientia"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#648
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.label ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 WHERE t0.slug = ? AND t0.project_id = ? LIMIT 1"
  "params" => [
    1 => "novlangue_controle_cognitif"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#648
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.resume AS resume_3, a0_.conclusion AS conclusion_4, a0_.pmid AS pmid_5, a0_.url AS url_6, a0_.doi AS doi_7, a0_.publication_date AS publication_date_8, a0_.authors AS authors_9, a0_.journal AS journal_10, a0_.volume AS volume_11, a0_.issue AS issue_12, a0_.pages AS pages_13, a0_.hypotheses AS hypotheses_14, a0_.population AS population_15, a0_.variables AS variables_16, a0_.protocol AS protocol_17, a0_.measurement_tools AS measurement_tools_18, a0_.statistical_analyses AS statistical_analyses_19, a0_.statistical_results AS statistical_results_20, a0_.conclusions AS conclusions_21, a0_.limitations AS limitations_22, a0_.personal_interest AS personal_interest_23, a0_.other_comments AS other_comments_24, a0_.created_at AS created_at_25, a0_.updated_at AS updated_at_26, a1_.id AS id_27, a1_.is_read AS is_read_28, a1_.is_favorite AS is_favorite_29, a1_.in_progress AS in_progress_30, a1_.linked_at AS linked_at_31, a1_.unlinked_at AS unlinked_at_32 FROM article a0_ INNER JOIN article_project a1_ ON a0_.id = a1_.article_id AND (a1_.project_id = ?) INNER JOIN article_category a3_ ON a0_.id = a3_.article_id INNER JOIN category c2_ ON c2_.id = a3_.category_id WHERE a1_.unlinked_at IS NULL AND c2_.id = ? ORDER BY a0_.publication_date DESC) dctrn_result) dctrn_table"
  "params" => [
    1 => 1
    2 => 31
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#743}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 WHERE t0.project_id = ? ORDER BY t0.position ASC, t0.label ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, publication_date_8 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.resume AS resume_3, a0_.conclusion AS conclusion_4, a0_.pmid AS pmid_5, a0_.url AS url_6, a0_.doi AS doi_7, a0_.publication_date AS publication_date_8, a0_.authors AS authors_9, a0_.journal AS journal_10, a0_.volume AS volume_11, a0_.issue AS issue_12, a0_.pages AS pages_13, a0_.hypotheses AS hypotheses_14, a0_.population AS population_15, a0_.variables AS variables_16, a0_.protocol AS protocol_17, a0_.measurement_tools AS measurement_tools_18, a0_.statistical_analyses AS statistical_analyses_19, a0_.statistical_results AS statistical_results_20, a0_.conclusions AS conclusions_21, a0_.limitations AS limitations_22, a0_.personal_interest AS personal_interest_23, a0_.other_comments AS other_comments_24, a0_.created_at AS created_at_25, a0_.updated_at AS updated_at_26, a1_.id AS id_27, a1_.is_read AS is_read_28, a1_.is_favorite AS is_favorite_29, a1_.in_progress AS in_progress_30, a1_.linked_at AS linked_at_31, a1_.unlinked_at AS unlinked_at_32, c2_.id AS id_33, c2_.slug AS slug_34, c2_.label AS label_35, c2_.focus AS focus_36, c2_.keywords AS keywords_37, c2_.position AS position_38, c2_.last_imported_at AS last_imported_at_39 FROM article a0_ INNER JOIN article_project a1_ ON a0_.id = a1_.article_id AND (a1_.project_id = ?) INNER JOIN article_category a3_ ON a0_.id = a3_.article_id INNER JOIN category c2_ ON c2_.id = a3_.category_id WHERE a1_.unlinked_at IS NULL AND c2_.id = ?) dctrn_result_inner ORDER BY publication_date_8 DESC) dctrn_result LIMIT 12"
  "params" => [
    1 => 1
    2 => 31
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#743}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.resume AS resume_3, a0_.conclusion AS conclusion_4, a0_.pmid AS pmid_5, a0_.url AS url_6, a0_.doi AS doi_7, a0_.publication_date AS publication_date_8, a0_.authors AS authors_9, a0_.journal AS journal_10, a0_.volume AS volume_11, a0_.issue AS issue_12, a0_.pages AS pages_13, a0_.hypotheses AS hypotheses_14, a0_.population AS population_15, a0_.variables AS variables_16, a0_.protocol AS protocol_17, a0_.measurement_tools AS measurement_tools_18, a0_.statistical_analyses AS statistical_analyses_19, a0_.statistical_results AS statistical_results_20, a0_.conclusions AS conclusions_21, a0_.limitations AS limitations_22, a0_.personal_interest AS personal_interest_23, a0_.other_comments AS other_comments_24, a0_.created_at AS created_at_25, a0_.updated_at AS updated_at_26, a1_.id AS id_27, a1_.is_read AS is_read_28, a1_.is_favorite AS is_favorite_29, a1_.in_progress AS in_progress_30, a1_.linked_at AS linked_at_31, a1_.unlinked_at AS unlinked_at_32, a1_.article_id AS article_id_33, a1_.project_id AS project_id_34, a1_.in_progress_by_id AS in_progress_by_id_35 FROM article a0_ INNER JOIN article_project a1_ ON a0_.id = a1_.article_id AND (a1_.project_id = ?) INNER JOIN article_category a3_ ON a0_.id = a3_.article_id INNER JOIN category c2_ ON c2_.id = a3_.category_id WHERE a1_.unlinked_at IS NULL AND c2_.id = ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.publication_date DESC"
  "params" => [
    1 => 1
    2 => 31
    3 => 9912
    4 => 9913
    5 => 9915
    6 => 9914
    7 => 9917
    8 => 599
    9 => 9916
    10 => 9918
    11 => 9919
    12 => 9920
    13 => 9921
    14 => 9922
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#743}
    3 => Doctrine\DBAL\ParameterType {#743}
    4 => Doctrine\DBAL\ParameterType {#743}
    5 => Doctrine\DBAL\ParameterType {#743}
    6 => Doctrine\DBAL\ParameterType {#743}
    7 => Doctrine\DBAL\ParameterType {#743}
    8 => Doctrine\DBAL\ParameterType {#743}
    9 => Doctrine\DBAL\ParameterType {#743}
    10 => Doctrine\DBAL\ParameterType {#743}
    11 => Doctrine\DBAL\ParameterType {#743}
    12 => Doctrine\DBAL\ParameterType {#743}
    13 => Doctrine\DBAL\ParameterType {#743}
    14 => Doctrine\DBAL\ParameterType {#743}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?"
  "params" => [
    1 => 9912
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?"
  "params" => [
    1 => 9913
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?"
  "params" => [
    1 => 9915
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?"
  "params" => [
    1 => 9914
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?"
  "params" => [
    1 => 9917
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?"
  "params" => [
    1 => 599
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?"
  "params" => [
    1 => 9916
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?"
  "params" => [
    1 => 9918
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?"
  "params" => [
    1 => 9919
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?"
  "params" => [
    1 => 9920
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?"
  "params" => [
    1 => 9921
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.focus AS focus_4, t0.keywords AS keywords_5, t0.position AS position_6, t0.last_imported_at AS last_imported_at_7, t0.project_id AS project_id_8 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?"
  "params" => [
    1 => 9922
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#743
      +name: "INTEGER"
    }
  ]
]