| 1 |
1.20 ms |
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.route AS route_2, m0_.url AS url_3, m0_.icon AS icon_4, m0_.enabled AS enabled_5, m0_.position AS position_6, m0_.blank AS blank_7, m0_.parent_id AS parent_id_8 FROM menu m0_ LEFT JOIN menu_role m2_ ON m0_.id = m2_.menu_id LEFT JOIN role r1_ ON r1_.code = m2_.role_code WHERE m0_.parent_id IS NULL AND m0_.enabled = 1 AND r1_.code IN (?) ORDER BY m0_.position ASC
Parameters: [
"ROLE_VISITEUR"
]
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.route AS route_2, m0_.url AS url_3, m0_.icon AS icon_4, m0_.enabled AS enabled_5, m0_.position AS position_6, m0_.blank AS blank_7, m0_.parent_id AS parent_id_8 FROM menu m0_ LEFT JOIN menu_role m2_ ON m0_.id = m2_.menu_id LEFT JOIN role r1_ ON r1_.code = m2_.role_code WHERE m0_.parent_id IS NULL AND m0_.enabled = 1 AND r1_.code IN ('ROLE_VISITEUR') ORDER BY m0_.position ASC;
|
| 2 |
0.37 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = 9;
|
| 3 |
0.27 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = 15;
|
| 4 |
0.24 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = 10;
|
| 5 |
0.21 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = 11;
|
| 6 |
0.22 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = 12;
|