I'm looking through my slow query log & stumbled upon a query built in admin_menu_tree_dynamic() which uses *:
SELECT ml.*, m.path AS path, m.load_functions AS load_functions, m.to_arg_functions AS to_arg_functions, m.access_callback AS access_callback, m.access_arguments AS access_arguments, m.page_callback AS page_callback, m.page_arguments AS page_arguments, m.delivery_callback AS delivery_callback, m.fit AS fit, m.number_parts AS number_parts, m.context AS context, m.tab_parent AS tab_parent, m.tab_root AS tab_root, m.title AS title, m.title_callback AS title_callback, m.title_arguments AS title_arguments, m.theme_callback AS theme_callback, m.theme_arguments AS theme_arguments, m.type AS type, m.description AS description, m.position AS position, m.include_file AS include_file FROM menu_links ml INNER JOIN menu_router m ON ml.router_path = m.path WHERE (( (p1 = :db_condition_placeholder_0) AND (p2 = :db_condition_placeholder_1) AND (p3 = :db_condition_placeholder_2) AND (p4 = :db_condition_placeholder_3) AND (p5 = :db_condition_placeholder_4) )OR( (p1 = :db_condition_placeholder_5) AND (p2 = :db_condition_placeholder_6) AND (p3 = :db_condition_placeholder_7) AND (p4 = :db_condition_placeholder_8) AND (p5 = :db_condition_placeholder_9) AND (p6 = :db_condition_placeholder_10) )OR( (p1 = :db_condition_placeholder_11) AND (p2 = :db_condition_placeholder_12) AND (p3 = :db_condition_placeholder_13) AND (p4 = :db_condition_placeholder_14) )OR( (p1 = :db_condition_placeholder_15) AND (p2 = :db_condition_placeholder_16) AND (p3 = :db_condition_placeholder_17) AND (p4 = :db_condition_placeholder_18) )OR( (p1 = :db_condition_placeholder_19) AND (p2 = :db_condition_placeholder_20) AND (p3 = :db_condition_placeholder_21) AND (p4 = :db_condition_placeholder_22) AND (p5 = :db_condition_placeholder_23) AND (p6 = :db_condition_placeholder_24) )OR( (p1 = :db_condition_placeholder_25) AND (p2 = :db_condition_placeholder_26) AND (p3 = :db_condition_placeholder_27) AND (p4 = :db_condition_placeholder_28) )OR( (p1 = :db_condition_placeholder_29) AND (p2 = :db_condition_placeholder_30) AND (p3 = :db_condition_placeholder_31) AND (p4 = :db_condition_placeholder_32) )OR( (p1 = :db_condition_placeholder_33) AND (p2 = :db_condition_placeholder_34) AND (p3 = :db_condition_placeholder_35) AND (p4 = :db_condition_placeholder_36) )OR( (p1 = :db_condition_placeholder_37) AND (p2 = :db_condition_placeholder_38) AND (p3 = :db_condition_placeholder_39) AND (p4 = :db_condition_placeholder_40) )OR( (p1 = :db_condition_placeholder_41) AND (p2 = :db_condition_placeholder_42) AND (p3 = :db_condition_placeholder_43) AND (p4 = :db_condition_placeholder_44) )OR( (p1 = :db_condition_placeholder_45) AND (p2 = :db_condition_placeholder_46) AND (p3 = :db_condition_placeholder_47) AND (p4 = :db_condition_placeholder_48) )OR( (p1 = :db_condition_placeholder_49) AND (p2 = :db_condition_placeholder_50) AND (p3 = :db_condition_placeholder_51) AND (p4 = :db_condition_placeholder_52) )OR( (p1 = :db_condition_placeholder_53) AND (p2 = :db_condition_placeholder_54) AND (p3 = :db_condition_placeholder_55) AND (p4 = :db_condition_placeholder_56) )OR( (p1 = :db_condition_placeholder_57) AND (p2 = :db_condition_placeholder_58) AND (p3 = :db_condition_placeholder_59) AND (p4 = :db_condition_placeholder_60) )OR( (p1 = :db_condition_placeholder_61) AND (p2 = :db_condition_placeholder_62) AND (p3 = :db_condition_placeholder_63) AND (p4 = :db_condition_placeholder_64) )OR( (p1 = :db_condition_placeholder_65) )OR( (p1 = :db_condition_placeholder_66) AND (p2 = :db_condition_placeholder_67) AND (p3 = :db_condition_placeholder_68) AND (p4 = :db_condition_placeholder_69) AND (p5 = :db_condition_placeholder_70) AND (p6 = :db_condition_placeholder_71) )OR( (p1 = :db_condition_placeholder_72) AND (p2 = :db_condition_placeholder_73) AND (p3 = :db_condition_placeholder_74) AND (p4 = :db_condition_placeholder_75) )OR( (p1 = :db_condition_placeholder_76) AND (p2 = :db_condition_placeholder_77) AND (p3 = :db_condition_placeholder_78) AND (p4 = :db_condition_placeholder_79) )OR( (p1 = :db_condition_placeholder_80) AND (p2 = :db_condition_placeholder_81) AND (p3 = :db_condition_placeholder_82) AND (p4 = :db_condition_placeholder_83) AND (p5 = :db_condition_placeholder_84) AND (p6 = :db_condition_placeholder_85) )OR( (p1 = :db_condition_placeholder_86) AND (p2 = :db_condition_placeholder_87) AND (p3 = :db_condition_placeholder_88) AND (p4 = :db_condition_placeholder_89) )) ORDER BY p1 ASC, p2 ASC, p3 ASC, p4 ASC, p5 ASC, p6 ASC, p7 ASC, p8 ASC, p9 ASC
I don't actually know if there are extra values being returned that aren't needed - which was suggested by https://tools.percona.com/query-advisor
But I have heard that there can be performance improvements by simply listing the rows you want returned explicitly.
I've not had to do mysql work in a while, so please close this if I'm wrong.
Comments
Comment #0.0
mgiffordadding link
Comment #1
truls1502I am sorry for no reply until now.
There are many issues regarding this module admin_menu which is a bit difficult for us to follow up since some of the issues might be already outdated, or is already fixed by the module or any other modules or itself core which means that the problem might no longer need to be fixed.
We can see that the issue has been created for a few years ago, I hope it is okay for you that I am postponing the issue, and give you around two weeks. If you still face the problem, could you tell us the step by step when until you get the error message or what is frustrated you, and a list of modules you are using related to admin_menu and a screenshot that might help us? So it makes us easier to reproduce your issue.
However, after two weeks with no feedback - we will close this issue. So in case, you noticed it after the issue is closed, do not hesitate to reopen it like and fill information which is mentioned above.
So before giving us a feedback, do you mind to test it again with our latest 7.x-3.x-dev?
Thank you for understanding! :)
Comment #2
truls1502This issue has been automatically marked as closed because it has not had recent activity after the last post.
However, if you or someone is still facing the same issue as described to the issue, could you please to re-open the issue by changing the status of the issue, and add an explanation with more details which can help us to reproduce your situation.
Again, thank you for your contributions! :)