1.24 ms (18.00%)
|
2 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.description AS description_2, d1_.id AS id_3, d1_.name AS name_4, d1_.description AS description_5, u2_.id AS id_6, u2_.name AS name_7, u2_.description AS description_8, d0_.parent_id AS parent_id_9, d1_.parent_id AS parent_id_10 FROM document_category d0_ LEFT JOIN document_category d1_ ON d0_.id = d1_.parent_id LEFT JOIN document_category_access_groups d3_ ON d0_.id = d3_.document_category_id LEFT JOIN user_group u2_ ON u2_.id = d3_.user_group_id WHERE d0_.parent_id IS NULL ORDER BY d0_.name ASC, d1_.name ASC
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.description AS description_2, d1_.id AS id_3, d1_.name AS name_4, d1_.description AS description_5, u2_.id AS id_6, u2_.name AS name_7, u2_.description AS description_8, d0_.parent_id AS parent_id_9, d1_.parent_id AS parent_id_10 FROM document_category d0_ LEFT JOIN document_category d1_ ON d0_.id = d1_.parent_id LEFT JOIN document_category_access_groups d3_ ON d0_.id = d3_.document_category_id LEFT JOIN user_group u2_ ON u2_.id = d3_.user_group_id WHERE d0_.parent_id IS NULL ORDER BY d0_.name ASC, d1_.name ASC;
|
1.21 ms (17.57%)
|
4 |
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.route AS route_2, m0_.url AS url_3, m0_.position AS position_4, m0_.enabled AS enabled_5, m0_.page_id AS page_id_6, m0_.parent_id AS parent_id_7 FROM menu_item m0_ WHERE m0_.parent_id = ? AND m0_.enabled = ? ORDER BY m0_.position ASC
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.route AS route_2, m0_.url AS url_3, m0_.position AS position_4, m0_.enabled AS enabled_5, m0_.page_id AS page_id_6, m0_.parent_id AS parent_id_7 FROM menu_item m0_ WHERE m0_.parent_id = 3 AND m0_.enabled = 1 ORDER BY m0_.position ASC;
|
0.50 ms (7.24%)
|
1 |
SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.description AS description_2, d0_.file AS file_3, d0_.is_public AS is_public_4, d0_.created_at AS created_at_5, d0_.updated_at AS updated_at_6, d0_.notification_sent AS notification_sent_7, d1_.id AS id_8, d1_.name AS name_9, d1_.description AS description_10, d2_.id AS id_11, d2_.name AS name_12, d2_.description AS description_13, u3_.id AS id_14, u3_.name AS name_15, u3_.description AS description_16, u4_.id AS id_17, u4_.name AS name_18, u4_.description AS description_19, d0_.category_id AS category_id_20, d1_.parent_id AS parent_id_21, d2_.parent_id AS parent_id_22 FROM document d0_ LEFT JOIN document_category d1_ ON d0_.category_id = d1_.id LEFT JOIN document_category d2_ ON d1_.parent_id = d2_.id LEFT JOIN document_category_access_groups d5_ ON d1_.id = d5_.document_category_id LEFT JOIN user_group u3_ ON u3_.id = d5_.user_group_id LEFT JOIN document_category_access_groups d6_ ON d2_.id = d6_.document_category_id LEFT JOIN user_group u4_ ON u4_.id = d6_.user_group_id WHERE d0_.is_public = ? ORDER BY d0_.created_at DESC
SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.description AS description_2, d0_.file AS file_3, d0_.is_public AS is_public_4, d0_.created_at AS created_at_5, d0_.updated_at AS updated_at_6, d0_.notification_sent AS notification_sent_7, d1_.id AS id_8, d1_.name AS name_9, d1_.description AS description_10, d2_.id AS id_11, d2_.name AS name_12, d2_.description AS description_13, u3_.id AS id_14, u3_.name AS name_15, u3_.description AS description_16, u4_.id AS id_17, u4_.name AS name_18, u4_.description AS description_19, d0_.category_id AS category_id_20, d1_.parent_id AS parent_id_21, d2_.parent_id AS parent_id_22 FROM document d0_ LEFT JOIN document_category d1_ ON d0_.category_id = d1_.id LEFT JOIN document_category d2_ ON d1_.parent_id = d2_.id LEFT JOIN document_category_access_groups d5_ ON d1_.id = d5_.document_category_id LEFT JOIN user_group u3_ ON u3_.id = d5_.user_group_id LEFT JOIN document_category_access_groups d6_ ON d2_.id = d6_.document_category_id LEFT JOIN user_group u4_ ON u4_.id = d6_.user_group_id WHERE d0_.is_public = 1 ORDER BY d0_.created_at DESC;
|
0.40 ms (5.81%)
|
1 |
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.route AS route_2, m0_.url AS url_3, m0_.position AS position_4, m0_.enabled AS enabled_5, m0_.page_id AS page_id_6, m0_.parent_id AS parent_id_7 FROM menu_item m0_ WHERE m0_.parent_id IS NULL AND m0_.enabled = ? ORDER BY m0_.position ASC
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.route AS route_2, m0_.url AS url_3, m0_.position AS position_4, m0_.enabled AS enabled_5, m0_.page_id AS page_id_6, m0_.parent_id AS parent_id_7 FROM menu_item m0_ WHERE m0_.parent_id IS NULL AND m0_.enabled = 1 ORDER BY m0_.position ASC;
|