GET https://art.psychofact.fr/?category=art_scrupulosity&page=15

Query Metrics

13 Database Queries
7 Different statements
3.95 ms Query time
0 Invalid entities
9 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.20 ms
(30.36%)
6
SELECT t0.config_key AS config_key_1, t0.config_value AS config_value_2 FROM config t0 WHERE t0.config_key = ?
Parameters:
[
  "color_primary"
]
0.82 ms
(20.71%)
1
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_.is_read AS is_read_25, a0_.is_favorite AS is_favorite_26, a0_.in_progress AS in_progress_27, a0_.created_at AS created_at_28, a0_.updated_at AS updated_at_29, c1_.id AS id_30, c1_.slug AS slug_31, c1_.label AS label_32, c1_.focus AS focus_33, c1_.keywords AS keywords_34, c1_.position AS position_35, c1_.last_imported_at AS last_imported_at_36 FROM article a0_ INNER JOIN article_category a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.id = ?) dctrn_result_inner ORDER BY publication_date_8 DESC) dctrn_result LIMIT 12 OFFSET 168
Parameters:
[
  1
]
0.81 ms
(20.43%)
1
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_.is_read AS is_read_25, a0_.is_favorite AS is_favorite_26, a0_.in_progress AS in_progress_27, a0_.created_at AS created_at_28, a0_.updated_at AS updated_at_29 FROM article a0_ INNER JOIN article_category a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE c1_.id = ? ORDER BY a0_.publication_date DESC) dctrn_result) dctrn_table
Parameters:
[
  1
]
0.36 ms
(9.09%)
2
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
Parameters:
[]
0.30 ms
(7.70%)
1
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 FROM category t0 ORDER BY t0.position ASC, t0.label ASC
Parameters:
[]
0.28 ms
(7.04%)
1
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 FROM category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "art_scrupulosity"
]
0.18 ms
(4.66%)
1
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 FROM category t0
Parameters:
[]

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\Config 6
App\Entity\Category 2
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\Category No errors.
App\Entity\Article No errors.
App\Entity\Config No errors.
App\Entity\User No errors.