Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

8.85 ms Query time

0 Invalid entities

11 Managed entities

Queries


SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.content AS content_4, t0.chapo AS chapo_5, t0.created_at AS created_at_6, t0.pdf AS pdf_7, t0.pinned AS pinned_8, t0.category_id AS category_id_9, t0.author_id AS author_id_10 FROM tuto t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.counter AS counter_4, t0.page_id AS page_id_5, t0.views AS views_6, t0.origins AS origins_7 FROM visitor_count t0 WHERE t0.category = ? AND t0.page_id = ? LIMIT 1
"START TRANSACTION"
UPDATE visitor_count SET views = ? WHERE id = ?
"COMMIT"
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.created_at AS created_at_3, t0.similar AS similar_4 FROM keywords t0 INNER JOIN tutos_keywords ON t0.id = tutos_keywords.keywords_id WHERE tutos_keywords.tuto_id = ? ORDER BY t0.keyword ASC
SELECT t0.id AS id_1, t0.active AS active_2, t0.word AS word_3, t0.definition AS definition_4, t0.created_at AS created_at_5 FROM lexique t0 INNER JOIN tutos_lexiques ON t0.id = tutos_lexiques.lexique_id WHERE tutos_lexiques.tuto_id = ? ORDER BY t0.word ASC

#▲	Time	Info
1	2.91 ms	SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.content AS content_4, t0.chapo AS chapo_5, t0.created_at AS created_at_6, t0.pdf AS pdf_7, t0.pinned AS pinned_8, t0.category_id AS category_id_9, t0.author_id AS author_id_10 FROM tuto t0 WHERE t0.id = ? Parameters: [`115`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.content AS content_4, t0.chapo AS chapo_5, t0.created_at AS created_at_6, t0.pdf AS pdf_7, t0.pinned AS pinned_8, t0.category_id AS category_id_9, t0.author_id AS author_id_10 FROM tuto t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.content AS content_4, t0.chapo AS chapo_5, t0.created_at AS created_at_6, t0.pdf AS pdf_7, t0.pinned AS pinned_8, t0.category_id AS category_id_9, t0.author_id AS author_id_10 FROM tuto t0 WHERE t0.id = 115;
2	1.07 ms	SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.counter AS counter_4, t0.page_id AS page_id_5, t0.views AS views_6, t0.origins AS origins_7 FROM visitor_count t0 WHERE t0.category = ? AND t0.page_id = ? LIMIT 1 Parameters: [`"App\Entity\Tuto" 115`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.counter AS counter_4, t0.page_id AS page_id_5, t0.views AS views_6, t0.origins AS origins_7 FROM visitor_count t0 WHERE t0.category = ? AND t0.page_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.counter AS counter_4, t0.page_id AS page_id_5, t0.views AS views_6, t0.origins AS origins_7 FROM visitor_count t0 WHERE t0.category = 'App\\Entity\\Tuto' AND t0.page_id = 115 LIMIT 1;
3	0.34 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
4	0.87 ms	UPDATE visitor_count SET views = ? WHERE id = ? Parameters: ["a:81:{s:10:"2025-09-12";i:6;s:10:"2025-09-13";i:1;s:10:"2025-09-14";i:1;s:10:"2025-09-23";i:1;s:10:"2025-10-14";i:1;s:10:"2025-10-23";i:1;s:10:"2025-10-28";i:1;s:10:"2025-10-31";i:1;s:10:"2025-11-01";i:1;s:10:"2025-11-05";i:1;s:10:"2025-11-20";i:1;s:10:"2025-11-29";i:1;s:10:"2025-12-01";i:1;s:10:"2025-12-15";i:1;s:10:"2025-12-17";i:2;s:10:"2025-12-18";i:1;s:10:"2025-12-21";i:1;s:10:"2025-12-31";i:1;s:10:"2026-01-04";i:1;s:10:"2026-01-29";i:1;s:10:"2026-02-01";i:1;s:10:"2026-02-03";i:1;s:10:"2026-02-04";i:3;s:10:"2026-02-05";i:1;s:10:"2026-02-06";i:1;s:10:"2026-02-12";i:2;s:10:"2026-02-15";i:2;s:10:"2026-02-16";i:1;s:10:"2026-02-17";i:1;s:10:"2026-02-20";i:2;s:10:"2026-02-22";i:1;s:10:"2026-02-23";i:1;s:10:"2026-02-25";i:3;s:10:"2026-02-26";i:1;s:10:"2026-02-28";i:1;s:10:"2026-03-01";i:1;s:10:"2026-03-02";i:1;s:10:"2026-03-03";i:1;s:10:"2026-03-05";i:1;s:10:"2026-03-06";i:1;s:10:"2026-03-07";i:1;s:10:"2026-03-08";i:2;s:10:"2026-03-10";i:1;s:10:"2026-03-11";i:2;s:10:"2026-03-14";i:2;s:10:"2026-03-15";i:1;s:10:"2026-03-16";i:1;s:10:"2026-03-17";i:1;s:10:"2026-03-18";i:1;s:10:"2026-03-19";i:3;s:10:"2026-03-21";i:2;s:10:"2026-03-23";i:1;s:10:"2026-03-24";i:1;s:10:"2026-03-25";i:1;s:10:"2026-03-26";i:2;s:10:"2026-04-01";i:1;s:10:"2026-04-03";i:1;s:10:"2026-04-05";i:1;s:10:"2026-04-06";i:1;s:10:"2026-04-08";i:2;s:10:"2026-04-09";i:1;s:10:"2026-04-10";i:1;s:10:"2026-04-11";i:1;s:10:"2026-04-13";i:1;s:10:"2026-04-15";i:3;s:10:"2026-04-17";i:1;s:10:"2026-04-18";i:1;s:10:"2026-04-19";i:1;s:10:"2026-04-20";i:2;s:10:"2026-04-22";i:1;s:10:"2026-04-23";i:2;s:10:"2026-04-24";i:1;s:10:"2026-04-25";i:1;s:10:"2026-04-26";i:2;s:10:"2026-04-27";i:1;s:10:"2026-04-29";i:1;s:10:"2026-05-02";i:2;s:10:"2026-05-04";i:1;s:10:"2026-05-05";i:2;s:10:"2026-05-07";i:1;s:10:"2026-05-08";i:2;}" 442] View formatted query View runnable query Explain query UPDATE visitor_count SET views = ? WHERE id = ? UPDATE visitor_count SET views = 'a:81:{s:10:\"2025-09-12\";i:6;s:10:\"2025-09-13\";i:1;s:10:\"2025-09-14\";i:1;s:10:\"2025-09-23\";i:1;s:10:\"2025-10-14\";i:1;s:10:\"2025-10-23\";i:1;s:10:\"2025-10-28\";i:1;s:10:\"2025-10-31\";i:1;s:10:\"2025-11-01\";i:1;s:10:\"2025-11-05\";i:1;s:10:\"2025-11-20\";i:1;s:10:\"2025-11-29\";i:1;s:10:\"2025-12-01\";i:1;s:10:\"2025-12-15\";i:1;s:10:\"2025-12-17\";i:2;s:10:\"2025-12-18\";i:1;s:10:\"2025-12-21\";i:1;s:10:\"2025-12-31\";i:1;s:10:\"2026-01-04\";i:1;s:10:\"2026-01-29\";i:1;s:10:\"2026-02-01\";i:1;s:10:\"2026-02-03\";i:1;s:10:\"2026-02-04\";i:3;s:10:\"2026-02-05\";i:1;s:10:\"2026-02-06\";i:1;s:10:\"2026-02-12\";i:2;s:10:\"2026-02-15\";i:2;s:10:\"2026-02-16\";i:1;s:10:\"2026-02-17\";i:1;s:10:\"2026-02-20\";i:2;s:10:\"2026-02-22\";i:1;s:10:\"2026-02-23\";i:1;s:10:\"2026-02-25\";i:3;s:10:\"2026-02-26\";i:1;s:10:\"2026-02-28\";i:1;s:10:\"2026-03-01\";i:1;s:10:\"2026-03-02\";i:1;s:10:\"2026-03-03\";i:1;s:10:\"2026-03-05\";i:1;s:10:\"2026-03-06\";i:1;s:10:\"2026-03-07\";i:1;s:10:\"2026-03-08\";i:2;s:10:\"2026-03-10\";i:1;s:10:\"2026-03-11\";i:2;s:10:\"2026-03-14\";i:2;s:10:\"2026-03-15\";i:1;s:10:\"2026-03-16\";i:1;s:10:\"2026-03-17\";i:1;s:10:\"2026-03-18\";i:1;s:10:\"2026-03-19\";i:3;s:10:\"2026-03-21\";i:2;s:10:\"2026-03-23\";i:1;s:10:\"2026-03-24\";i:1;s:10:\"2026-03-25\";i:1;s:10:\"2026-03-26\";i:2;s:10:\"2026-04-01\";i:1;s:10:\"2026-04-03\";i:1;s:10:\"2026-04-05\";i:1;s:10:\"2026-04-06\";i:1;s:10:\"2026-04-08\";i:2;s:10:\"2026-04-09\";i:1;s:10:\"2026-04-10\";i:1;s:10:\"2026-04-11\";i:1;s:10:\"2026-04-13\";i:1;s:10:\"2026-04-15\";i:3;s:10:\"2026-04-17\";i:1;s:10:\"2026-04-18\";i:1;s:10:\"2026-04-19\";i:1;s:10:\"2026-04-20\";i:2;s:10:\"2026-04-22\";i:1;s:10:\"2026-04-23\";i:2;s:10:\"2026-04-24\";i:1;s:10:\"2026-04-25\";i:1;s:10:\"2026-04-26\";i:2;s:10:\"2026-04-27\";i:1;s:10:\"2026-04-29\";i:1;s:10:\"2026-05-02\";i:2;s:10:\"2026-05-04\";i:1;s:10:\"2026-05-05\";i:2;s:10:\"2026-05-07\";i:1;s:10:\"2026-05-08\";i:2;}' WHERE id = 442;
5	0.29 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
6	1.61 ms	SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.created_at AS created_at_3, t0.similar AS similar_4 FROM keywords t0 INNER JOIN tutos_keywords ON t0.id = tutos_keywords.keywords_id WHERE tutos_keywords.tuto_id = ? ORDER BY t0.keyword ASC Parameters: [`115`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.created_at AS created_at_3, t0.similar AS similar_4 FROM keywords t0 INNER JOIN tutos_keywords ON t0.id = tutos_keywords.keywords_id WHERE tutos_keywords.tuto_id = ? ORDER BY t0.keyword ASC SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.created_at AS created_at_3, t0.similar AS similar_4 FROM keywords t0 INNER JOIN tutos_keywords ON t0.id = tutos_keywords.keywords_id WHERE tutos_keywords.tuto_id = 115 ORDER BY t0.keyword ASC;
7	1.75 ms	SELECT t0.id AS id_1, t0.active AS active_2, t0.word AS word_3, t0.definition AS definition_4, t0.created_at AS created_at_5 FROM lexique t0 INNER JOIN tutos_lexiques ON t0.id = tutos_lexiques.lexique_id WHERE tutos_lexiques.tuto_id = ? ORDER BY t0.word ASC Parameters: [`115`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.active AS active_2, t0.word AS word_3, t0.definition AS definition_4, t0.created_at AS created_at_5 FROM lexique t0 INNER JOIN tutos_lexiques ON t0.id = tutos_lexiques.lexique_id WHERE tutos_lexiques.tuto_id = ? ORDER BY t0.word ASC SELECT t0.id AS id_1, t0.active AS active_2, t0.word AS word_3, t0.definition AS definition_4, t0.created_at AS created_at_5 FROM lexique t0 INNER JOIN tutos_lexiques ON t0.id = tutos_lexiques.lexique_id WHERE tutos_lexiques.tuto_id = 115 ORDER BY t0.word ASC;

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\Lexique	5
App\Entity\Keywords	2
App\Entity\Tuto	1
App\Entity\LaBaseCategory	1
App\Entity\User	1
App\Entity\VisitorCount	1

Entities Mapping

Class	Mapping errors
App\Entity\Tuto	No errors.
App\Entity\LaBaseCategory	No errors.
App\Entity\User	No errors.
App\Entity\Keywords	No errors.
App\Entity\Lexique	No errors.
App\Entity\VisitorCount	No errors.
App\Entity\News	No errors.
App\Entity\Jurisprudence	No errors.

Symfony Profiler

GET https://cajo-test.squat.net/lire-tuto/115

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping