GET https://psychofact.fr/ssh/notes/4

Query Metrics

19 Database Queries
6 Different statements
4.54 ms Query time
0 Invalid entities
42 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.15 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.16 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.id = ?
Parameters:
[
  "4"
]
3 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
]
4 0.14 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.invite_token AS invite_token_6 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  7
]
5 0.35 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.note_id = ?
Parameters:
[
  4
]
6 0.16 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:
[
  13879
]
7 0.13 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:
[
  13426
]
8 0.13 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:
[
  13866
]
9 0.11 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:
[
  13867
]
10 2.17 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:
[
  13873
]
11 0.11 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:
[
  13405
]
12 0.09 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:
[
  13871
]
13 0.09 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:
[
  13424
]
14 0.09 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:
[
  13413
]
15 0.09 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:
[
  13384
]
16 0.09 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:
[
  13860
]
17 0.08 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:
[
  13425
]
18 0.08 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:
[
  13847
]
19 0.08 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:
[
  13957
]

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\ArticleNote 14
App\Entity\Article 14
App\Entity\Category 11
App\Entity\Project 1
App\Entity\Note 1
App\Entity\User 1

Entities Mapping

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