Symfony Profiler

http://bea.sharksgames.com/index.php/

Method: GET
HTTP Status: 200
IP: 3.133.109.121
Profiled on: Thu, 14 Nov 2024 22:59:05 +0100
Token: b0c8a0

Last 10 Latest Search

Settings

Query Metrics

4 Database Queries

1 Different statements

9.30 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	3.81 ms	SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.link AS link_2, m0_.ordermenu AS ordermenu_3, m0_.logged AS logged_4, m0_.image AS image_5, p1_.id AS id_6, p1_.name AS name_7, s2_.id AS id_8, s2_.name AS name_9, s2_.position AS position_10, m0_.section_id AS section_id_11, m0_.pagina_id AS pagina_id_12, m0_.translate_id AS translate_id_13 FROM menu m0_ INNER JOIN pagina p1_ ON m0_.pagina_id = p1_.id INNER JOIN section s2_ ON m0_.section_id = s2_.id WHERE p1_.name = ? AND s2_.name = ? Parameters: [`"home" "principal"`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.link AS link_2, m0_.ordermenu AS ordermenu_3, m0_.logged AS logged_4, m0_.image AS image_5, p1_.id AS id_6, p1_.name AS name_7, s2_.id AS id_8, s2_.name AS name_9, s2_.position AS position_10, m0_.section_id AS section_id_11, m0_.pagina_id AS pagina_id_12, m0_.translate_id AS translate_id_13 FROM menu m0_ INNER JOIN pagina p1_ ON m0_.pagina_id = p1_.id INNER JOIN section s2_ ON m0_.section_id = s2_.id WHERE p1_.name = ? AND s2_.name = ? SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.link AS link_2, m0_.ordermenu AS ordermenu_3, m0_.logged AS logged_4, m0_.image AS image_5, p1_.id AS id_6, p1_.name AS name_7, s2_.id AS id_8, s2_.name AS name_9, s2_.position AS position_10, m0_.section_id AS section_id_11, m0_.pagina_id AS pagina_id_12, m0_.translate_id AS translate_id_13 FROM menu m0_ INNER JOIN pagina p1_ ON m0_.pagina_id = p1_.id INNER JOIN section s2_ ON m0_.section_id = s2_.id WHERE p1_.name = 'home' AND s2_.name = 'principal';
2	1.80 ms	SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.link AS link_2, m0_.ordermenu AS ordermenu_3, m0_.logged AS logged_4, m0_.image AS image_5, p1_.id AS id_6, p1_.name AS name_7, s2_.id AS id_8, s2_.name AS name_9, s2_.position AS position_10, m0_.section_id AS section_id_11, m0_.pagina_id AS pagina_id_12, m0_.translate_id AS translate_id_13 FROM menu m0_ INNER JOIN pagina p1_ ON m0_.pagina_id = p1_.id INNER JOIN section s2_ ON m0_.section_id = s2_.id WHERE p1_.name = ? AND s2_.name = ? Parameters: [`"home" "secundaria"`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.link AS link_2, m0_.ordermenu AS ordermenu_3, m0_.logged AS logged_4, m0_.image AS image_5, p1_.id AS id_6, p1_.name AS name_7, s2_.id AS id_8, s2_.name AS name_9, s2_.position AS position_10, m0_.section_id AS section_id_11, m0_.pagina_id AS pagina_id_12, m0_.translate_id AS translate_id_13 FROM menu m0_ INNER JOIN pagina p1_ ON m0_.pagina_id = p1_.id INNER JOIN section s2_ ON m0_.section_id = s2_.id WHERE p1_.name = ? AND s2_.name = ? SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.link AS link_2, m0_.ordermenu AS ordermenu_3, m0_.logged AS logged_4, m0_.image AS image_5, p1_.id AS id_6, p1_.name AS name_7, s2_.id AS id_8, s2_.name AS name_9, s2_.position AS position_10, m0_.section_id AS section_id_11, m0_.pagina_id AS pagina_id_12, m0_.translate_id AS translate_id_13 FROM menu m0_ INNER JOIN pagina p1_ ON m0_.pagina_id = p1_.id INNER JOIN section s2_ ON m0_.section_id = s2_.id WHERE p1_.name = 'home' AND s2_.name = 'secundaria';
3	1.74 ms	SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.link AS link_2, m0_.ordermenu AS ordermenu_3, m0_.logged AS logged_4, m0_.image AS image_5, p1_.id AS id_6, p1_.name AS name_7, s2_.id AS id_8, s2_.name AS name_9, s2_.position AS position_10, m0_.section_id AS section_id_11, m0_.pagina_id AS pagina_id_12, m0_.translate_id AS translate_id_13 FROM menu m0_ INNER JOIN pagina p1_ ON m0_.pagina_id = p1_.id INNER JOIN section s2_ ON m0_.section_id = s2_.id WHERE p1_.name = ? AND s2_.name = ? Parameters: [`"home" "top"`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.link AS link_2, m0_.ordermenu AS ordermenu_3, m0_.logged AS logged_4, m0_.image AS image_5, p1_.id AS id_6, p1_.name AS name_7, s2_.id AS id_8, s2_.name AS name_9, s2_.position AS position_10, m0_.section_id AS section_id_11, m0_.pagina_id AS pagina_id_12, m0_.translate_id AS translate_id_13 FROM menu m0_ INNER JOIN pagina p1_ ON m0_.pagina_id = p1_.id INNER JOIN section s2_ ON m0_.section_id = s2_.id WHERE p1_.name = ? AND s2_.name = ? SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.link AS link_2, m0_.ordermenu AS ordermenu_3, m0_.logged AS logged_4, m0_.image AS image_5, p1_.id AS id_6, p1_.name AS name_7, s2_.id AS id_8, s2_.name AS name_9, s2_.position AS position_10, m0_.section_id AS section_id_11, m0_.pagina_id AS pagina_id_12, m0_.translate_id AS translate_id_13 FROM menu m0_ INNER JOIN pagina p1_ ON m0_.pagina_id = p1_.id INNER JOIN section s2_ ON m0_.section_id = s2_.id WHERE p1_.name = 'home' AND s2_.name = 'top';
4	1.95 ms	SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.link AS link_2, m0_.ordermenu AS ordermenu_3, m0_.logged AS logged_4, m0_.image AS image_5, p1_.id AS id_6, p1_.name AS name_7, s2_.id AS id_8, s2_.name AS name_9, s2_.position AS position_10, m0_.section_id AS section_id_11, m0_.pagina_id AS pagina_id_12, m0_.translate_id AS translate_id_13 FROM menu m0_ INNER JOIN pagina p1_ ON m0_.pagina_id = p1_.id INNER JOIN section s2_ ON m0_.section_id = s2_.id WHERE p1_.name = ? AND s2_.name = ? Parameters: [`"home" "submenu"`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.link AS link_2, m0_.ordermenu AS ordermenu_3, m0_.logged AS logged_4, m0_.image AS image_5, p1_.id AS id_6, p1_.name AS name_7, s2_.id AS id_8, s2_.name AS name_9, s2_.position AS position_10, m0_.section_id AS section_id_11, m0_.pagina_id AS pagina_id_12, m0_.translate_id AS translate_id_13 FROM menu m0_ INNER JOIN pagina p1_ ON m0_.pagina_id = p1_.id INNER JOIN section s2_ ON m0_.section_id = s2_.id WHERE p1_.name = ? AND s2_.name = ? SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.link AS link_2, m0_.ordermenu AS ordermenu_3, m0_.logged AS logged_4, m0_.image AS image_5, p1_.id AS id_6, p1_.name AS name_7, s2_.id AS id_8, s2_.name AS name_9, s2_.position AS position_10, m0_.section_id AS section_id_11, m0_.pagina_id AS pagina_id_12, m0_.translate_id AS translate_id_13 FROM menu m0_ INNER JOIN pagina p1_ ON m0_.pagina_id = p1_.id INNER JOIN section s2_ ON m0_.section_id = s2_.id WHERE p1_.name = 'home' AND s2_.name = 'submenu';

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.

Entities Mapping

Class	Mapping errors
App\Entity\Menu	The mappings App\Entity\Menu#pagina_id and App\Entity\Pagina#menu are inconsistent with each other.
App\Entity\Pagina	No errors.
App\Entity\Section	No errors.
App\Entity\Translate	No errors.
App\Entity\AcnhItems	No errors.
App\Entity\AuxItem	No errors.
App\Entity\TodosItems	No errors.