GET https://psychofact.fr/ssh/article/14202

Query Metrics

7 Database Queries
7 Different statements
1.18 ms Query time
0 Invalid entities
19 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.18 ms
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
Parameters:
[
  "ssh"
]
2 0.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.resume AS resume_4, t0.conclusion AS conclusion_5, t0.pmid AS pmid_6, t0.url AS url_7, t0.doi AS doi_8, t0.publication_date AS publication_date_9, t0.authors AS authors_10, t0.journal AS journal_11, t0.volume AS volume_12, t0.issue AS issue_13, t0.pages AS pages_14, t0.hypotheses AS hypotheses_15, t0.population AS population_16, t0.variables AS variables_17, t0.protocol AS protocol_18, t0.measurement_tools AS measurement_tools_19, t0.statistical_analyses AS statistical_analyses_20, t0.statistical_results AS statistical_results_21, t0.conclusions AS conclusions_22, t0.limitations AS limitations_23, t0.personal_interest AS personal_interest_24, t0.other_comments AS other_comments_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27 FROM article t0 WHERE t0.id = ?
Parameters:
[
  "14202"
]
3 0.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.is_public AS is_public_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.project_id AS project_id_7, t0.author_id AS author_id_8 FROM note t0 WHERE t0.project_id = ? ORDER BY t0.title ASC
Parameters:
[
  3
]
4 0.10 ms
SELECT t0.id AS id_1, t0.rapport AS rapport_2, t0.article_id AS article_id_3, t0.note_id AS note_id_4 FROM article_note t0 WHERE t0.article_id = ?
Parameters:
[
  14202
]
5 0.23 ms
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
Parameters:
[
  3
]
6 0.13 ms
SELECT t0.id AS id_1, t0.is_read AS is_read_2, t0.is_favorite AS is_favorite_3, t0.in_progress AS in_progress_4, t0.linked_at AS linked_at_5, t0.unlinked_at AS unlinked_at_6, t0.article_id AS article_id_7, t0.project_id AS project_id_8, t0.in_progress_by_id AS in_progress_by_id_9 FROM article_project t0 WHERE t0.article_id = ?
Parameters:
[
  14202
]
7 0.13 ms
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 = ?
Parameters:
[
  14202
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Category 11
App\Entity\Note 3
App\Entity\User 2
App\Entity\Project 1
App\Entity\Article 1
App\Entity\ArticleProject 1

Entities Mapping

Class Mapping errors
App\Entity\Project No errors.
App\Entity\User No errors.
App\Entity\Article No errors.
App\Entity\Category No errors.
App\Entity\ArticleNote No errors.
App\Entity\ArticleProject No errors.
App\Entity\Note No errors.