Author: Sustainable Development Association
Introduction
Credits to Simone Martinetto. The title of the photo: Orienteering activity
Cultural orienteering is a fun and innovative way to explore and appreciate the local culture. The event is suitable for all age groups and is open to everyone. To participate in the orienteering activity, you can walk, run, ride a bike from one checkpoint to another, and do any activity you want. The aim of the orienteering work is for the players to determine the most appropriate route by means of the map and compass and to find the previously placed targets in the field the fastest way with this route.
Orienteering activities can be done quickly in all weather conditions, indoors and outdoors, they are not dependent on physical strength and age restrictions, and therefore everyone can promptly do them. The activities carried out during the goal-oriented orienteering activities are full of discovery and fun. In traditional orienteering, participants learn how to move around the unknown territory, often in a woodland or rural setting, using only a compass and map. The aim is to reach a series of checkpoints in the shortest time possible.
What’s the activity?
Cedits to SolStock. The tittle of the photo: Group of senior men looking at map for orienteering
Orienteering is suitable for everyone, individuals, families, young and old, serious fitness enthusiasts, and those who just want to add a little more fun to their evening walks by stretching their legs. Orienteering events have a range of courses of varying abilities in one place; It allows a more experienced orienteer to run a longer course with control signs placed in more difficult places and conversely a shorter course with easier controls for beginners, families, or children. Orienteering is also for all age groups. Orienteering exercises the body and mind at the same time! Navigating the map requires concentration, visualization and observation skills as you move between checkpoints. Orienteering develops independence and independent thinking. By participating in the orienteering, you can enjoy the view of the historical city in a healthy and fun way. You can choose to explore one or both enhanced routes. The purpose of this quest is to get everyone to participate in orienteering activity. Although orienteering is for all ages, older people participate less in this activity. Therefore, your task is to make sure that two elderly person from your family (like your grandparents or grandparents) or your circle participate in the orienteering activity you will organize.
What am I going to do?
As cultural mediator, your first task for this quest is to find at least two elderly person to participate in orienteering activity. You will create at least 2 groups. These groups will be formed by considering gender equality and involving an elderly person (can be more than 1). You can determine the number of people in this group yourself. The people who will take part in the groups can be your family, friends, even someone you don't know.
Each group will prepare a simple digital map using Google maps. On this map, you will mark the cultural architecture and cultural heritage of the province you are in. Afterwards, the prepared maps will be exchanged between the groups. (For example, the second group will receive the map prepared by the first group, the first group will receive the map prepared by the second group. The groups must compete with different maps because they know the places on their own maps.)
People in this group will participate in the orienteering using the map created by the other groups. Participants will aim to reach the finish line as soon as possible by finding the direction with the help of the map and compass (not compulsory), reaching the control points indicated on the map. You can find useful information in the resources section.
What will I learn?
- ● Culltural knowledge
- ● Culltural knowledge
- ● Map reading
- ● Compass reading
- ● Geographical Knowledge
- ● Leadership Skills
- ● Teamwork
- ● Social skills
- ● Endurance
- ● Confidence
What will I take home?
After orienteering the participants will build self-confidence.The map reading skills will improve. The better the activity is prepared and the more accessible, experiential, and fun you make the walks, the better the results will be for the participants to have a good time. You will get to know cultural places better, enabling people to have the same experience as you. Your physical, individual, and social skills will improve. Local cultural places, historic places, and cultural heritages will be learned better with the maps created for the activity. You can ask yourself the following questions to evaluate yourself.
What did you feel during the walk?
What are the general impressions you developed during the walk?
What surprised you the most?
Did you find out places causing you insecurity? And why?
What are the problems you detected?
What are the needs you detected?
Do you think this activity was beneficial for older people? Did their participation add value?
Resources
Click each section below to see all resources available.
Resources
Click each section below to see all resources available.
Websites (URLs)
Map-making, step by step
https://www.esri.com/arcgis-blog/products/mapping/mapping/map-making-step-by-step/
Senior orienteering athletes as a model of healthy aging
https://www.researchgate.net/publication/279988786_Senior_orienteering_athletes_as_a_model_of_healthy_aging_A_mixed-method_approach
Frontline Worker Toolkit
- ● Define the sport of Orienteering
- ● Identify the parts of and symbols on an orienteering map
- ● Contribute to the physical and mental development of the elderly by including them in the activity
- ● Make cultural activities more accessible
Top tips:
Accessibility doesn't happen overnight, but simple ideas will open doors for significant change. Our efforts to be accessible must be sustainable and done in small steps. Building this foundation allows cultural sites in our city to be easily discovered by everyone.
We recommend you ,front-line workers, some tips for organizing more accessible cultural activities.
Tip 1: To make your space more accessible, train your staff on disability discrimination and inclusion.
Tip 2: Consider using neutral and friendly colors for people who may be color blind.
Tip 3: Select and create an accessible location. The location of the cultural activity should be accessible to all. If the action is difficult to access, fewer people will participate. It would help if you considered physical, intellectual, cultural, and financial accessibilities.
Tip 4: Talk to people in the community about their accessibility needs.
Tip 5: To involve everyone in an activity, you should also consider the elderly. You should create an age-appropriate design. You must consider senior people's vision, hearing, physical, and cognitive capabilities.
Tip 6: Change the dialogue from disability to accessibility.
Tip 7: Build communities that embrace social inclusion so everyone can participate in everything a community has to offer
Tip 8: Create environments where everyone can bring their whole self to involve in activity
Tip 9: Be creative in giving opportunities to youth to change the culture
Tip 10: Never stop making activities accessible all the time. Keep coming up with new ideas and innovations.When you get feedback from people with disabilities, use it.
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1785578278,
"last": 1785578278,
"now": 1785578282
},
"token": "uYDYXTDADENUKNXeocuSCVoi2INz2Kft"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"plg_system_languagefilter": {
"language": "en-GB"
},
"1785578279": "<div class=\"osembed_wrapper ose-youtube \"><iframe width=\"200\" height=\"113\" src=\"https://www.youtube.com/embed/JZ5Obj6ctsE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen title=\"Participatory Art: Inspirations for advocacy and activism\"></iframe></div><input type='hidden' class='embed-id' id='embed-id' value='1785578279'></input>",
"link": " <hr id=\"system-readmore\" />\n\nRR_QCAT_35<br>\nAuthor: Sustainable Development Association\n\n<div class=\"wrapper\">\n<div class=\"gantry-row questborder1\">\n <div class=\"gantry-width-container\">\n <div class=\"gantry-width-66 mainbox\">\n <div class=\"gantry-width-spacer\">\n <!-------------------------------Slider 1----------------------------->\n <div id=\"my-alias\" class=\"rl_sliders-print active\"><h2 class=\"rl_sliders-title nn_sliders-title\"><a id=\"anchor-my-alias\" class=\"anchor\"></a><questslider>Introduction</questslider></h2>\n <center>\n <span class=\"quest_intro_image\">\n <a class=\"jcepopup\" style=\"height: auto;\" href=\"https://aceculture.eu/images/stories/com_form2content/p7/f890/Quest2_intro.JPG\" target=\"_blank\" rel=\"title[ Credits to Simone Martinetto. The title of the photo: Orienteering activity]\"><img src=\"https://aceculture.eu/images/stories/com_form2content/p7/f890/Quest2_intro.JPG\" alt=\" Credits to Simone Martinetto. The title of the photo: Orienteering activity\" title=\" Credits to Simone Martinetto. The title of the photo: Orienteering activity\"/></a>\n </span>\n <br><i> Credits to Simone Martinetto. The title of the photo: Orienteering activity</i>\n </center>\n <div class=\"f2c_intro\">\n <p><p>Cultural orienteering is a fun and innovative way to explore and appreciate the local culture. The event is suitable for all age groups and is open to everyone. To participate in the orienteering activity, you can walk, run, ride a bike from one checkpoint to another, and do any activity you want. The aim of the orienteering work is for the players to determine the most appropriate route by means of the map and compass and to find the previously placed targets in the field the fastest way with this route.</p>\r\n<p>Orienteering activities can be done quickly in all weather conditions, indoors and outdoors, they are not dependent on physical strength and age restrictions, and therefore everyone can promptly do them. The activities carried out during the goal-oriented orienteering activities are full of discovery and fun. In traditional orienteering, participants learn how to move around the unknown territory, often in a woodland or rural setting, using only a compass and map. The aim is to reach a series of checkpoints in the shortest time possible. </p></p>\n </div>\n <!----------------------------Slider 2----------------------------->\n <div id=\"s5\" class=\"rl_sliders-print\"><h2 class=\"rl_sliders-title nn_sliders-title\"><a id=\"anchor-s5\" class=\"anchor\"></a><questslider>What\u2019s the activity?</questslider></h2>\n \n <center>\n <span class=\"quest_intro_image\">\n <a class=\"jcepopup\" style=\"height: auto;\" href=\"https://aceculture.eu/images/stories/com_form2content/p7/f890/Quest_2_photo_2_rsz.jpg\" target=\"_blank\" rel=\"title[Cedits to SolStock. The tittle of the photo: Group of senior men looking at map for orienteering]\"><img src=\"https://aceculture.eu/images/stories/com_form2content/p7/f890/Quest_2_photo_2_rsz.jpg\" alt=\"Cedits to SolStock. The tittle of the photo: Group of senior men looking at map for orienteering\" title=\"Cedits to SolStock. The tittle of the photo: Group of senior men looking at map for orienteering\"/></a>\n </span>\n <br><i>Cedits to SolStock. The tittle of the photo: Group of senior men looking at map for orienteering</i>\n </center>\n <div class=\"f2c_intro\">\n <p><p>Orienteering is suitable for everyone, individuals, families, young and old, serious fitness enthusiasts, and those who just want to add a little more fun to their evening walks by stretching their legs. Orienteering events have a range of courses of varying abilities in one place; It allows a more experienced orienteer to run a longer course with control signs placed in more difficult places and conversely a shorter course with easier controls for beginners, families, or children. Orienteering is also for all age groups. Orienteering exercises the body and mind at the same time! Navigating the map requires concentration, visualization and observation skills as you move between checkpoints. Orienteering develops independence and independent thinking. By participating in the orienteering, you can enjoy the view of the historical city in a healthy and fun way. You can choose to explore one or both enhanced routes. The purpose of this quest is to get everyone to participate in orienteering activity. Although orienteering is for all ages, older people participate less in this activity. Therefore, your task is to make sure that two elderly person from your family (like your grandparents or grandparents) or your circle participate in the orienteering activity you will organize.</p></p>\n </div>\n\n <!-------------------------------Slider 3----------------------------->\n <div id=\"s2\" class=\"rl_sliders-print\"><h2 class=\"rl_sliders-title nn_sliders-title\"><a id=\"anchor-s2\" class=\"anchor\"></a><questslider>What am I going to do?</questslider></h2>\n \n <div class=\"f2c_slider_sa3\">\n </p>\n <p><p>As cultural mediator, your first task for this quest is to find at least two elderly person to participate in orienteering activity. You will create at least 2 groups. These groups will be formed by considering gender equality and involving an elderly person (can be more than 1). You can determine the number of people in this group yourself. The people who will take part in the groups can be your family, friends, even someone you don't know.</p>\r\n<p>Each group will prepare a simple digital map using Google maps. On this map, you will mark the cultural architecture and cultural heritage of the province you are in. Afterwards, the prepared maps will be exchanged between the groups. (For example, the second group will receive the map prepared by the first group, the first group will receive the map prepared by the second group. The groups must compete with different maps because they know the places on their own maps.)</p>\r\n<p>People in this group will participate in the orienteering using the map created by the other groups. Participants will aim to reach the finish line as soon as possible by finding the direction with the help of the map and compass (not compulsory), reaching the control points indicated on the map. You can find useful information in the resources section.</p></p>\n </div>\n <!--<p>asdfas</p>-->\n <!-------------------------------Slider 4----------------------------->\n <div id=\"s3\" class=\"rl_sliders-print\"><h2 class=\"rl_sliders-title nn_sliders-title\"><a id=\"anchor-s3\" class=\"anchor\"></a><questslider>What will I learn?</questslider></h2>\n\n\n<!-- New dropdown lists-->\n<div class=\"gantry-row\">\n <div class=\"gantry-width-container\">\n <div class=\"gantry-width-33\">\n <div class=\"gantry-width-spacer\">\n <p style=\"font-size: larger; margin-bottom: 0px;\">\n <strong>\n \n <questslider>Knowledge Acquired:</questslider>\n \n </strong>\n </p>\n <div class=\"f2c_list01\">\n <p><ul><li>\u25cf\tCulltural knowledge</li><li>\u25cf\tCulltural knowledge</li><li>\u25cf\tMap reading</li><li>\u25cf\tCompass reading</li><li>\u25cf\tGeographical Knowledge</li></ul></p>\n </div>\n </div>\n </div>\n <div class=\"gantry-width-33\">\n <div class=\"gantry-width-spacer\">\n <p style=\"font-size: larger; margin-bottom: 0px;\">\n <strong>\n \n <questslider>Skills Acquired:</questslider>\n \n </strong>\n </p>\n <div class=\"f2c_list02\">\n <p><ul><li>\u25cf\tLeadership Skills</li><li>\u25cf\tTeamwork</li><li>\u25cf\tSocial skills</li></ul></p>\n </div>\n </div>\n </div>\n <div class=\"gantry-width-33\">\n <div class=\"gantry-width-spacer\">\n <p style=\"font-size: larger; margin-bottom: 0px;\">\n <strong>\n \n <questslider>Attitude Acquired:</questslider>\n \n </strong>\n </p>\n <div class=\"f2c_list03\">\n <p><ul><li>\u25cf\tEndurance</li><li>\u25cf\tConfidence</li></ul></p>\n </div>\n </div>\n </div>\n </div>\n</div>\n<!-- End New dropdown lists-->\n\n\n <div class=\"quest-design-text\">\n <p></p>\n </div>\n <div class=\"clear\"> </div>\n <!----------------------------Slider 5----------------------------->\n <div id=\"s4\" class=\"rl_sliders-print\"><h2 class=\"rl_sliders-title nn_sliders-title\"><a id=\"anchor-s4\" class=\"anchor\"></a><questslider>What will I take home?</questslider></h2>\n <div class=\"conclusion\">\n <p><p>After orienteering the participants will build self-confidence.The map reading skills will improve. The better the activity is prepared and the more accessible, experiential, and fun you make the walks, the better the results will be for the participants to have a good time. You will get to know cultural places better, enabling people to have the same experience as you. Your physical, individual, and social skills will improve. Local cultural places, historic places, and cultural heritages will be learned better with the maps created for the activity. You can ask yourself the following questions to evaluate yourself.</p>\r\n<p>What did you feel during the walk?</p>\r\n<p>What are the general impressions you developed during the walk?</p>\r\n<p>What surprised you the most?</p>\r\n<p>Did you find out places causing you insecurity? And why?</p>\r\n<p>What are the problems you detected?</p>\r\n<p>What are the needs you detected?</p>\r\n<p>Do you think this activity was beneficial for older people? Did their participation add value?</p></p>\n </div>\n </div>\n <!--LOs-->\n </div>\n <!----------------------------Resources------------------------------>\n <!----------------------------Resources------------------------------>\n <!----------------------------Resources------------------------------>\n <div class=\"gantry-width-33 resourcesbox\">\n <div class=\"gantry-width-spacer resourcesbox\">\n <h4>\n <center><h3>Resources</h3><p style=\"font-size: smaller\">Click each section below to see all resources available.</p></center>\n </h4>\n <div class=\"gantry-width-spacer\">\n <div id=\"s6\" class=\"rl_sliders-print active\"><h2 class=\"rl_sliders-title nn_sliders-title\"><a id=\"anchor-s6\" class=\"anchor\"></a><questslider>Websites (URLs)</questslider></h2>\n <!----------------------------Slider B1------------------------------>\n <div class=\"f2c_links\">\n <p><b><a href=\"https://www.esri.com/arcgis-blog/products/mapping/mapping/map-making-step-by-step/\" target=\"new\" style=\"color: #1155CC;\" >Map-making, step by step</a></b><br>\n <a href=\"https://www.esri.com/arcgis-blog/products/mapping/mapping/map-making-step-by-step/\" target=\"new\" style=\"font-size: smaller; display: block; line-height:1.5;\"><i>https://www.esri.com/arcgis-blog/products/mapping/mapping/map-making-step-by-step/</i></a>\n </p>\n </div>\n <div class=\"f2c_links2\">\n <p><b><a href=\"https://www.britishorienteering.org.uk/newcomers_guide\" target=\"new\" style=\"color: #1155CC;\">What is orienteering</a></b><br>\n <a href=\"https://www.britishorienteering.org.uk/newcomers_guide\" target=\"new\" style=\"font-size: smaller; display: block; line-height:1.5;\"><i>https://www.britishorienteering.org.uk/newcomers_guide</i></a>\n </p>\n </div>\n <div class=\"f2c_links3\">\n <p><b><a href=\"https://www.researchgate.net/publication/279988786_Senior_orienteering_athletes_as_a_model_of_healthy_aging_A_mixed-method_approach\" target=\"new\" style=\"color: #1155CC\">Senior orienteering athletes as a model of healthy aging</a></b><br>\n <a href=\"https://www.researchgate.net/publication/279988786_Senior_orienteering_athletes_as_a_model_of_healthy_aging_A_mixed-method_approach\" target=\"new\" style=\"font-size: smaller; display: block; line-height:1.5;\"><i>https://www.researchgate.net/publication/279988786_Senior_orienteering_athletes_as_a_model_of_healthy_aging_A_mixed-method_approach</i></a>\n </p>\n </div>\n <div class=\"f2c_links4\">\n <p><b><a href=\"https://www.corkcity.ie/en/things-to-do/parks-outdoors/orienteering/shandon-orienteering-project/\" target=\"new\" style=\"color: #1155CC\">Shandon Orienteering Project</a></b><br>\n <a href=\"https://www.corkcity.ie/en/things-to-do/parks-outdoors/orienteering/shandon-orienteering-project/\" target=\"new\" style=\"font-size: smaller; display: block; line-height:1.5;\"><i>https://www.corkcity.ie/en/things-to-do/parks-outdoors/orienteering/shandon-orienteering-project/</i></a>\n </p>\n </div>\n <!----------------------------Slider B2------------------------------>\n\n <div id=\"s8\" class=\"rl_sliders-print\"><h2 class=\"rl_sliders-title nn_sliders-title\"><a id=\"anchor-s8\" class=\"anchor\"></a><questslider>Videos</questslider></h2>\n <div class=\"youtubethumb\">\n <p>\n \n </p>\n <a href=\"http://www.youtube.com/embed/https://www.youtube.com/watch?v=y4yfyUwkUxw\" target=\"new\"><img src=\"http://img.youtube.com/vi/https://www.youtube.com/watch?v=y4yfyUwkUxw/mqdefault.jpg\"></a>\n </div>\n <div class=\"youtubethumb\">\n </div>\n <div class=\"youtubethumb\">\n </div>\n <div class=\"youtubethumb\">\n </div>\n <div class=\"youtubethumb\">\n </div>\n \n <!----------------------------Slider B3------------------------------>\n\n \n \n \n </div>\n </div>\n </div>\n </div>\n</div>\n<div class=\"clear\"> </div>\n\n\n<br>\n\n<div class=\"questborder2\">\n\n<div id=\"s10\" class=\"rl_sliders-print\"><h2 class=\"rl_sliders-title nn_sliders-title\"><a id=\"anchor-s10\" class=\"anchor\"></a><questslider>Frontline Worker Toolkit</questslider></h2>\n\n<!--\n\n<div class=\"f2c_links10\">\n</div>\n<div class=\"badgesbottom\">\n </p>\n</div>\n-->\n\n\n <p style=\"font-size: larger; margin-bottom: 0px;\">\n <strong>\n \n <questslider>Aims and Objectives:</questslider>\n \n </strong>\n </p>\n <div class=\"f2c_list01\">\n <p><ul><li>\u25cf\tDefine the sport of Orienteering </li><li>\u25cf\tIdentify the parts of and symbols on an orienteering map</li><li>\u25cf\tContribute to the physical and mental development of the elderly by including them in the activity</li><li>\u25cf\tMake cultural activities more accessible </li></ul></p>\n </div>\n\n\n<h2>Top tips:</h2>\n<p> <p>Accessibility doesn't happen overnight, but simple ideas will open doors for significant change. Our efforts to be accessible must be sustainable and done in small steps. Building this foundation allows cultural sites in our city to be easily discovered by everyone.</p>\r\n<p>We recommend you ,front-line workers, some tips for organizing more accessible cultural activities.</p>\r\n<p><strong><em>Tip 1:</em></strong> To make your space more accessible, train your staff on disability discrimination and inclusion.</p>\r\n<p><strong><em>Tip 2: </em></strong>Consider using neutral and friendly colors for people who may be color blind.</p>\r\n<p><strong><em>Tip 3:</em></strong> Select and create an accessible location. The location of the cultural activity should be accessible to all. If the action is difficult to access, fewer people will participate. It would help if you considered physical, intellectual, cultural, and financial accessibilities.</p>\r\n<p><strong><em>Tip 4:</em></strong> Talk to people in the community about their accessibility needs.</p>\r\n<p><strong><em>Tip 5:</em></strong> To involve everyone in an activity, you should also consider the elderly. You should create an age-appropriate design. You must consider senior people's vision, hearing, physical, and cognitive capabilities. </p>\r\n<p><strong><em>Tip 6:</em></strong> Change the dialogue from disability to accessibility.</p>\r\n<p><strong><em>Tip 7:</em></strong> Build communities that embrace social inclusion so everyone can participate in everything a community has to offer</p>\r\n<p><strong><em>Tip 8:</em></strong> Create environments where everyone can bring their whole self to involve in activity</p>\r\n<p><strong><em>Tip 9:</em></strong> Be creative in giving opportunities to youth to change the culture</p>\r\n<p><strong><em>Tip 10:</em></strong> Never stop making activities accessible all the time. Keep coming up with new ideas and innovations.When you get feedback from people with disabilities, use it.</p> </p>\n\n<p> </p>\n\n<p>\n <div class=\"f2c_links6\">\n <p><b><a href=\"https://www.britishorienteering.org.uk/teaching\" target=\"new\" style=\"color: #1155CC\">Teaching Orienteering Training Courses</a></b><br>\n <a href=\"https://www.britishorienteering.org.uk/teaching\" target=\"new\" style=\"display: block; line-height:1.5;\"><i>https://www.britishorienteering.org.uk/teaching</i></a>\n </p>\n </div>\n <div class=\"f2c_links7\">\n <p><b><a href=\"https://www.youtube.com/watch?v=26Zc5AVkFis&t=16s\" target=\"new\" style=\"color: #1155CC\">Start Orienteering || A Newcomer's Guide</a></b><br>\n <a href=\"https://www.youtube.com/watch?v=26Zc5AVkFis&t=16s\" target=\"new\" style=\"display: block; line-height:1.5;\"><i>https://www.youtube.com/watch?v=26Zc5AVkFis&t=16s</i></a>\n </p>\n </div>\n </p>\n\n<div class=\"gantry-width-block gantry-width-20\">\n <div class=\"gantry-width-spacer\">\n <div class=\"t_youtubethumb test\">\n </div>\n </div>\n</div>\n<div class=\"gantry-width-block gantry-width-20\">\n <div class=\"gantry-width-spacer\">\n <div class=\"t_youtubethumb\">\n </div>\n </div>\n</div>\n<div class=\"gantry-width-block gantry-width-20\">\n <div class=\"gantry-width-spacer\">\n <div class=\"t_youtubethumb\">\n </div>\n </div>\n</div>\n<div class=\"gantry-width-block gantry-width-20\">\n <div class=\"gantry-width-spacer\">\n <div class=\"t_youtubethumb\">\n </div>\n </div>\n</div>\n<div class=\"gantry-width-block gantry-width-20\">\n <div class=\"gantry-width-spacer\">\n <div class=\"t_youtubethumb\">\n </div>\n </div>\n</div>\n<div class=\"clear\"> </div>\n<br>\n<div class=\"teacher_docs\">\n </div>\n<div class=\"teacher_docs\">\n </div>\n<div class=\"teacher_docs\">\n </div>\n<div class=\"teacher_docs\">\n </div>\n<div class=\"teacher_docs\">\n </div>\n\n\n\n\n\n</div>\n\n<!--<h3>Other Quests</h3>-->",
"1785578283": "<div class=\"osembed_wrapper ose-youtube \"><iframe width=\"200\" height=\"113\" src=\"https://www.youtube.com/embed/26Zc5AVkFis?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen title=\"Start Orienteering || A Newcomer's Guide || Presented by Graham Gristwood\"></iframe></div><input type='hidden' class='embed-id' id='embed-id' value='1785578283'></input>"
}
}
Time
Memory
65 Queries Logged 29.51 ms
12 duplicate found!
- Query Time: 0.50 ms Query memory: 0.085 MB Memory before query: 9.355 MB Rows returned: 1
SELECT `data`
FROM `mbky7_session`
WHERE `session_id` = X'6262386535343334386233613561646635356135633237363138613437373637'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.13 ms End of update loop 0.02 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:854 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:414 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.38 ms After last query: 1.84 ms Query memory: 0.025 MB Memory before query: 9.803 MB Rows returned: 47
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `mbky7_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_extensions ref extension extension 82 const 48 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.22 ms After last query: 1.12 ms Query memory: 0.021 MB Memory before query: 10.000 MB Rows returned: 10
SELECT id, rules
FROM `mbky7_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 10 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 10.014 MB Rows returned: 2
SELECT b.id
FROM mbky7_usergroups AS a
LEFT JOIN mbky7_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.54 ms After last query: 0.36 ms Query memory: 0.051 MB Memory before query: 10.083 MB Rows returned: 135
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM mbky7_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 353 Using where; Using filesort Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.30 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 5.55 ms Query memory: 0.022 MB Memory before query: 11.666 MB Rows returned: 0Duplicate queries: #7
SELECT `manifest_cache`
FROM `mbky7_extensions`
WHERE `type` = 'component'
AND `name` = 'com_admintools'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_extensions ref extension extension 82 const 48 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/fof30/Container/Container.php:787 12 FOF30\Container\Container->getDefaultMediaVersion() JROOT/libraries/fof30/Container/Container.php:675 11 FOF30\Container\Container->__construct() JROOT/libraries/fof30/Container/Container.php:159 10 FOF30\Container\Container::makeInstance() JROOT/libraries/fof30/Container/Container.php:140 9 FOF30\Container\Container::getInstance() JROOT/plugins/system/admintools/admintools/main.php:813 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.40 ms After last query: 2.51 ms Query memory: 0.022 MB Memory before query: 11.966 MB Rows returned: 0Duplicate queries: #6
SELECT `manifest_cache`
FROM `mbky7_extensions`
WHERE `type` = 'component'
AND `name` = 'com_admintools'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_extensions ref extension extension 82 const 48 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/fof30/Container/Container.php:787 12 FOF30\Container\Container->getDefaultMediaVersion() JROOT/libraries/fof30/Container/Container.php:675 11 FOF30\Container\Container->__construct() JROOT/libraries/fof30/Container/Container.php:290 10 FOF30\Container\Container::makeInstance() JROOT/libraries/fof30/Container/Container.php:140 9 FOF30\Container\Container::getInstance() JROOT/plugins/system/admintools/admintools/main.php:813 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.32 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 11.981 MB Rows returned: 1
SELECT `value`
FROM `mbky7_admintools_storage`
WHERE `key` = 'cparams'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_admintools_storage const PRIMARY PRIMARY 402 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_admintools/Helper/Storage.php:123 12 Akeeba\AdminTools\Admin\Helper\Storage->load() JROOT/administrator/components/com_admintools/Helper/Storage.php:53 11 Akeeba\AdminTools\Admin\Helper\Storage->__construct() JROOT/administrator/components/com_admintools/Helper/Storage.php:41 10 Akeeba\AdminTools\Admin\Helper\Storage::getInstance() JROOT/plugins/system/admintools/admintools/main.php:278 9 plgSystemAdmintools->loadComponentParameters() JROOT/plugins/system/admintools/admintools/main.php:831 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.38 ms After last query: 1.60 ms Query memory: 0.023 MB Memory before query: 12.171 MB Rows returned: 5
SELECT *
FROM mbky7_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 9 Using where; Using filesort Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 11 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/plugins/system/admintools/admintools/main.php:520 10 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:460 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:843 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.24 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 12.183 MB Rows returned: 0
SELECT *
FROM `mbky7_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 11 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/admintools/main.php:549 10 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:460 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:843 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.35 ms After last query: 11.58 ms Query memory: 0.023 MB Memory before query: 13.282 MB Rows returned: 1
SELECT `extension_id`,`name`,`enabled`,`params`
FROM mbky7_extensions
WHERE `type` = 'plugin'
AND `element` = 'osembed'
AND `folder` = 'content'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 Using index condition; Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170 14 Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:140 13 Alledia\Framework\Joomla\Extension\Generic->__construct() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:62 12 Alledia\Framework\Joomla\Extension\Licensed->__construct() JROOT/libraries/allediaframework/Framework/Factory.php:63 11 Alledia\Framework\Factory::getExtension() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Helper.php:171 10 Alledia\Framework\Joomla\Extension\Helper::getExtensionForElement() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Helper.php:132 9 Alledia\Framework\Joomla\Extension\Helper::loadLibrary() JROOT/plugins/content/osembed/include.php:48 8 include_once JROOT/plugins/content/osembed/include.php JROOT/plugins/system/osembedpreview/osembedpreview.php:31 7 require_once JROOT/plugins/system/osembedpreview/osembedpreview.php JROOT/libraries/src/Plugin/PluginHelper.php:251 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.35 ms After last query: 10.42 ms Query memory: 0.022 MB Memory before query: 14.376 MB Rows returned: 1Duplicate queries: #13
SELECT template
FROM mbky7_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 17 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.29 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 14.383 MB Rows returned: 1Duplicate queries: #12
SELECT template
FROM mbky7_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 17 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 13 RokCommon_PlatformInfo_Joomla->getDefaultTemplate() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 12 RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 11 RokCommon_PlatformInfo_Joomla->setPlatformParameters() JROOT/libraries/rokcommon/RokCommon/Service.php:71 10 RokCommon_Service::getContainer() JROOT/libraries/rokcommon/include.php:38 9 require_once JROOT/libraries/rokcommon/include.php JROOT/plugins/system/rokcommon/rokcommon.php:95 8 plgSystemRokCommon->loadCommonLib() JROOT/plugins/system/rokcommon/rokcommon.php:53 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.29 ms After last query: 2.58 ms Query memory: 0.021 MB Memory before query: 14.616 MB Rows returned: 2
SELECT extension, file, type
FROM mbky7_rokcommon_configs
ORDER BY priorityid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_rokcommon_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using filesort Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rokcommon/rokcommon.php:131 8 plgSystemRokCommon->processRegisteredConfigs() JROOT/plugins/system/rokcommon/rokcommon.php:75 7 plgSystemRokCommon->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 9.59 ms Query memory: 0.022 MB Memory before query: 16.115 MB Rows returned: 18
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `mbky7_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_extensions ref extension extension 82 const 18 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:695 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.55 ms After last query: 3.94 ms Query memory: 0.022 MB Memory before query: 16.499 MB Rows returned: 1
SHOW VARIABLES LIKE "collation_database"
EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"Status Duration Starting 0.02 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.35 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/libraries/joomla/database/driver/mysqli.php:345 11 JDatabaseDriverMysqli->getCollation() JROOT/plugins/system/admintools/feature/utf8mb4.php:28 10 AtsystemFeatureUtf8mb4->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:710 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.10 ms After last query: 0.02 ms Query memory: 0.006 MB Memory before query: 16.507 MB
SET NAMES utf8mb4 COLLATE utf8mb4_general_ciEXPLAIN not possible on query: SET NAMES utf8mb4 COLLATE utf8mb4_general_ciStatus Duration Starting 0.02 ms Opening tables 0.00 ms After opening tables 0.01 ms Query end 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/plugins/system/admintools/feature/utf8mb4.php:39 10 AtsystemFeatureUtf8mb4->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:710 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.19 ms After last query: 0.32 ms Query memory: 0.021 MB Memory before query: 16.540 MB Rows returned: 0
SELECT *
FROM `mbky7_admintools_ipautoban`
WHERE `ip` = '216.73.217.9'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/plugins/system/admintools/feature/autoipfiltering.php:74 11 AtsystemFeatureAutoipfiltering->isIPBlocked() JROOT/plugins/system/admintools/feature/autoipfiltering.php:23 10 AtsystemFeatureAutoipfiltering->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:710 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.17 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 16.545 MB Rows returned: 2
SELECT `ip`
FROM `mbky7_admintools_ipblock`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_admintools_ipblock ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Status Duration Starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.00 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.01 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 12 JDatabaseDriver->loadColumn() JROOT/plugins/system/admintools/feature/ipblacklist.php:139 11 AtsystemFeatureIpblacklist->isIPBlocked() JROOT/plugins/system/admintools/feature/ipblacklist.php:33 10 AtsystemFeatureIpblacklist->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:710 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.20 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 16.551 MB Rows returned: 1
SELECT *
FROM `mbky7_admintools_storage`
WHERE `key` LIKE 'timestamp_%'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_admintools_storage range PRIMARY PRIMARY 402 NULL 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.01 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 13 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/feature/abstract.php:269 12 AtsystemFeatureAbstract->loadTimestamps() JROOT/plugins/system/admintools/feature/abstract.php:349 11 AtsystemFeatureAbstract->getTimestamp() JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:113 10 AtsystemFeatureDisableobsoleteadmins->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:710 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.19 ms After last query: 0.30 ms Query memory: 0.021 MB Memory before query: 16.561 MB Rows returned: 0
SELECT `source`,`keepurlparams`
FROM `mbky7_admintools_redirects`
WHERE ((`dest` = 'en/q/cat05/accessible-cultural-orienteering-for-elderly2') OR (`dest` = 'en/q/cat05/accessible-cultural-orienteering-for-elderly2?layout=default&print=1&tmpl=component') OR ('en/q/cat05/accessible-cultural-orienteering-for-elderly2?layout=default&print=1&tmpl=component' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 11 JDatabaseDriver->loadRow() JROOT/plugins/system/admintools/feature/urlredir.php:89 10 AtsystemFeatureUrlredir->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:710 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.23 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 16.590 MB Rows returned: 1
SELECT `extension_id`,`name`,`enabled`,`params`
FROM mbky7_extensions
WHERE `type` = 'plugin'
AND `element` = 'osembedpreview'
AND `folder` = 'system'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 Using index condition; Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.01 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170 14 Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:140 13 Alledia\Framework\Joomla\Extension\Generic->__construct() JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:62 12 Alledia\Framework\Joomla\Extension\Licensed->__construct() JROOT/libraries/allediaframework/Framework/Factory.php:63 11 Alledia\Framework\Factory::getExtension() JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:85 10 Alledia\Framework\Joomla\Extension\AbstractPlugin->loadExtension() JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:56 9 Alledia\Framework\Joomla\Extension\AbstractPlugin->init() JROOT/plugins/system/osembedpreview/osembedpreview.php:58 8 PlgSystemOSEmbedPreview->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.69 ms After last query: 4.35 ms Query memory: 0.026 MB Memory before query: 17.132 MB Rows returned: 18
SHOW FULL COLUMNS
FROM `mbky7_extensions`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `mbky7_extensions`Status Duration Starting 0.02 ms checking permissions 0.01 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.26 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.06 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.10 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 11 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Extension.php:32 10 Joomla\CMS\Table\Extension->__construct() JROOT/libraries/src/Table/Table.php:320 9 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/roksprocket/roksprocket.php:45 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.35 ms Query memory: 0.021 MB Memory before query: 17.175 MB Rows returned: 1
SELECT `extension_id`
FROM `mbky7_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:47 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.21 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 17.182 MB Rows returned: 1Duplicate queries: #27
SELECT *
FROM mbky7_extensions
WHERE `extension_id` = '10237'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:54 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.21 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 17.186 MB Rows returned: 1
SELECT `extension_id`
FROM `mbky7_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using where; Using index Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 9 Joomla\CMS\Table\Extension->find() JROOT/plugins/system/roksprocket/roksprocket.php:70 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.22 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 17.192 MB Rows returned: 1Duplicate queries: #25
SELECT *
FROM mbky7_extensions
WHERE `extension_id` = '10237'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_extensions const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.02 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:739 9 Joomla\CMS\Table\Table->load() JROOT/plugins/system/roksprocket/roksprocket.php:76 8 plgSystemRokSprocket->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.23 ms After last query: 14.48 ms Query memory: 0.024 MB Memory before query: 18.912 MB Rows returned: 42
SELECT *
FROM mbky7_rsform_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_rsform_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 42 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/config.php:50 11 RSFormProConfig->load() JROOT/administrator/components/com_rsform/helpers/config.php:17 10 RSFormProConfig->__construct() JROOT/administrator/components/com_rsform/helpers/config.php:102 9 RSFormProConfig::getInstance() JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:26 8 plgSystemRsformdeletesubmissions->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.98 ms After last query: 2.43 ms Query memory: 0.259 MB Memory before query: 19.161 MB Rows returned: 190
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM mbky7_menu AS m
LEFT JOIN mbky7_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 279 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 fidgetg1_ac.m.component_id 1 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.70 ms End of update loop 0.02 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:445 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:561 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:696 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.51 ms After last query: 7.88 ms Query memory: 0.031 MB Memory before query: 20.682 MB Rows returned: 11
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `mbky7_categories` AS `s`
INNER JOIN `mbky7_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 30
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 46 Using where; Using filesort Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.08 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 14 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 13 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:165 12 ContentRouter->getCategoryId() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Component/Router/Rules/StandardRules.php:93 10 Joomla\CMS\Component\Router\Rules\StandardRules->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1170 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.56 ms After last query: 0.37 ms Query memory: 0.022 MB Memory before query: 20.825 MB Rows returned: 1
SELECT `id`
FROM `mbky7_content`
WHERE alias = 'accessible-cultural-orienteering-for-elderly2'
AND catid = '35'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_content ref idx_catid,idx_alias idx_alias 766 const 1 Using where Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.33 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:225 12 ContentRouter->getArticleId() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/Component/Router/Rules/StandardRules.php:140 10 Joomla\CMS\Component\Router\Rules\StandardRules->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1170 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 20.833 MB Rows returned: 1
SELECT *
FROM `mbky7_admintools_wafblacklists`
WHERE `verb` IN('','GET')
AND `option` IN('','com_content')
AND `view` IN('','article')
AND `task` IN('','article.')
AND `enabled` = '1'
GROUP BY `query`
ORDER BY `query` ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_admintools_wafblacklists ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where; Using temporary; Using filesort Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Creating tmp table 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.01 ms Removing tmp table 0.01 ms Creating sort index 0.00 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/admintools/feature/wafblacklist.php:87 10 AtsystemFeatureWafblacklist->onAfterRoute() JROOT/plugins/system/admintools/admintools/main.php:710 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:145 8 plgSystemAdmintools->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.23 ms After last query: 0.53 ms Query memory: 0.026 MB Memory before query: 20.900 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `mbky7_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:84 8 plgSystemSL_ScrollToTop->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.49 ms After last query: 0.07 ms Query memory: 0.006 MB Memory before query: 20.893 MB
UPDATE `mbky7_extensions`
SET `params` = '{\"mediaversion\":\"16f0d5212bd3bde07614565dcd876905\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `mbky7_extensions` SET `params` = '{\"mediaversion\":\"16f0d5212bd3bde07614565dcd876905\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms checking permissions 0.00 ms After opening tables 0.00 ms init for update 0.00 ms init 0.01 ms Updating main table 0.01 ms init 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.00 ms init for update 0.03 ms Updating 0.05 ms End of update loop 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.25 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:84 8 plgSystemSL_ScrollToTop->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.32 ms After last query: 1.98 ms Query memory: 0.026 MB Memory before query: 21.298 MB Rows returned: 15
SELECT id, home, template, s.params
FROM mbky7_template_styles as s
LEFT JOIN mbky7_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 82 const 6 Using index condition; Using where 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_template 202 fidgetg1_ac.e.element 2 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 19 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 18 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 17 Joomla\CMS\HTML\HTMLHelper::script() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/behavior.php:63 13 JHtmlBehavior::framework() JROOT/libraries/cms/html/behavior.php:60 12 JHtmlBehavior::framework() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 10 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 9 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:130 8 plgSystemSL_ScrollToTop->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 9.70 ms Query memory: 0.023 MB Memory before query: 22.982 MB Rows returned: 2
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM mbky7_template_styles AS s
WHERE s.client_id = 0
AND s.template = 'rt_akuatik'
ORDER BY s.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_template 202 const 2 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69 14 Gantry\Joomla\StyleHelper::loadStyles() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Assignments.php:63 13 Gantry\Framework\Assignments->loadAssignments() JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:301 12 Gantry\Component\Assignments\AbstractAssignments->init() JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:99 11 Gantry\Component\Assignments\AbstractAssignments->scores() JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:86 10 Gantry\Component\Assignments\AbstractAssignments->select() JROOT/plugins/system/gantry5/gantry5.php:315 9 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:108 8 plgSystemGantry5->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1218 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.65 ms After last query: 6.57 ms Query memory: 0.028 MB Memory before query: 23.742 MB Rows returned: 47
SELECT `id`,`name`,`rules`,`parent_id`
FROM `mbky7_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_enablemenu','com_ffexplorer','com_fields','com_finder','com_form2content','com_gantry5','com_html5flippingbook','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_regularlabsmanager','com_rereplacer','com_roksprocket','com_rsform','com_rssearch','com_search','com_tags','com_templates','com_users','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_assets range idx_asset_name idx_asset_name 202 NULL 48 Using index condition Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.24 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.77 ms After last query: 0.14 ms Query memory: 0.087 MB Memory before query: 23.798 MB Rows returned: 522
SELECT `id`,`name`,`rules`,`parent_id`
FROM `mbky7_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 1353 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.02 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.46 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.61 ms After last query: 1.56 ms Query memory: 0.031 MB Memory before query: 24.303 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `mbky7_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `mbky7_content`Status Duration Starting 0.02 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.22 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.06 ms closing tables 0.01 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.08 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:320 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.10 ms After last query: 2.41 ms Query memory: 0.005 MB Memory before query: 24.521 MB
UPDATE mbky7_content
SET `hits` = (`hits` + 1)
WHERE `id` = '1363'EXPLAIN not possible on query: UPDATE mbky7_content SET `hits` = (`hits` + 1) WHERE `id` = '1363'Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms checking permissions 0.00 ms After opening tables 0.00 ms init for update 0.00 ms init 0.01 ms Updating main table 0.01 ms init 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.00 ms init for update 0.02 ms Updating 0.70 ms End of update loop 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.18 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1256 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 1.19 ms Query memory: 0.070 MB Memory before query: 24.643 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM mbky7_content AS a
INNER JOIN mbky7_categories AS c
on c.id = a.catid
LEFT JOIN mbky7_users AS u
on u.id = a.created_by
LEFT JOIN mbky7_categories as parent
ON parent.id = c.parent_id
LEFT JOIN mbky7_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 1363
AND c.published > 0
AND a.language in ('en-GB','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-08-01 09:58:02')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-01 09:58:02')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid,idx_language PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 1 Unique row not found Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.48 ms After last query: 1.62 ms Query memory: 0.028 MB Memory before query: 24.837 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `mbky7_categories` AS `s`
INNER JOIN `mbky7_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 35
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 46 Using where; Using filesort Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 22 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 21 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 18 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 17 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 16 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 15 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.47 ms After last query: 0.29 ms Query memory: 0.022 MB Memory before query: 24.861 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `mbky7_contentitem_tag_map` AS m
INNER JOIN `mbky7_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 1363
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t ALL PRIMARY,tag_idx,idx_access NO INDEX KEY COULD BE USED NULL NULL 124 Using where 1 SIMPLE m ref idx_tag_type idx_tag_type 4 fidgetg1_ac.t.id 5 Using index condition; Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.17 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.63 ms After last query: 17.24 ms Query memory: 0.029 MB Memory before query: 26.078 MB Rows returned: 16
SHOW FULL COLUMNS
FROM `mbky7_users`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `mbky7_users`Status Duration Starting 0.04 ms checking permissions 0.01 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.23 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.05 ms closing tables 0.01 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.08 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 21 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:253 20 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:172 19 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 18 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:320 17 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 16 Joomla\CMS\User\User::getTable() JROOT/plugins/system/sourcerer/src/Security.php:60 15 RegularLabs\Plugin\System\Sourcerer\Security::set() JROOT/plugins/system/sourcerer/sourcerer.php:93 14 PlgSystemSourcerer->handleOnContentPrepare() JROOT/libraries/regularlabs/src/SystemPlugin.php:225 13 RegularLabs\Library\SystemPlugin->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.22 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 26.122 MB Rows returned: 1Duplicate queries: #47
SELECT *
FROM `mbky7_users`
WHERE `id` = 929id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_users const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 16 Joomla\CMS\Table\User->load() JROOT/plugins/system/sourcerer/src/Security.php:62 15 RegularLabs\Plugin\System\Sourcerer\Security::set() JROOT/plugins/system/sourcerer/sourcerer.php:93 14 PlgSystemSourcerer->handleOnContentPrepare() JROOT/libraries/regularlabs/src/SystemPlugin.php:225 13 RegularLabs\Library\SystemPlugin->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.24 ms After last query: 1.48 ms Query memory: 0.024 MB Memory before query: 26.881 MB Rows returned: 3Duplicate queries: #48
SELECT `g`.`id`,`g`.`title`
FROM `mbky7_usergroups` AS g
INNER JOIN `mbky7_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 929id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY PRIMARY 4 const 3 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 fidgetg1_ac.m.group_id 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 17 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 16 Joomla\CMS\Table\User->load() JROOT/plugins/system/sourcerer/src/Security.php:62 15 RegularLabs\Plugin\System\Sourcerer\Security::set() JROOT/plugins/system/sourcerer/sourcerer.php:93 14 PlgSystemSourcerer->handleOnContentPrepare() JROOT/libraries/regularlabs/src/SystemPlugin.php:225 13 RegularLabs\Library\SystemPlugin->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.19 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 26.890 MB Rows returned: 1Duplicate queries: #45
SELECT *
FROM `mbky7_users`
WHERE `id` = 929id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_users const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 21 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 20 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 19 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 18 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 17 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 16 Joomla\CMS\Factory::getUser() JROOT/plugins/system/sourcerer/src/Security.php:64 15 RegularLabs\Plugin\System\Sourcerer\Security::set() JROOT/plugins/system/sourcerer/sourcerer.php:93 14 PlgSystemSourcerer->handleOnContentPrepare() JROOT/libraries/regularlabs/src/SystemPlugin.php:225 13 RegularLabs\Library\SystemPlugin->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.21 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 26.903 MB Rows returned: 3Duplicate queries: #46
SELECT `g`.`id`,`g`.`title`
FROM `mbky7_usergroups` AS g
INNER JOIN `mbky7_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 929id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY PRIMARY 4 const 3 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 fidgetg1_ac.m.group_id 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 21 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 20 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 19 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 18 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 17 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 16 Joomla\CMS\Factory::getUser() JROOT/plugins/system/sourcerer/src/Security.php:64 15 RegularLabs\Plugin\System\Sourcerer\Security::set() JROOT/plugins/system/sourcerer/sourcerer.php:93 14 PlgSystemSourcerer->handleOnContentPrepare() JROOT/libraries/regularlabs/src/SystemPlugin.php:225 13 RegularLabs\Library\SystemPlugin->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.24 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 26.913 MB Rows returned: 14
SELECT b.id
FROM mbky7_user_usergroup_map AS map
LEFT JOIN mbky7_usergroups AS a
ON a.id = map.group_id
LEFT JOIN mbky7_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 929id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE map ref PRIMARY PRIMARY 4 const 3 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 fidgetg1_ac.map.group_id 1 1 SIMPLE b ALL idx_usergroup_nested_set_lookup NO INDEX KEY COULD BE USED NULL NULL 13 Range checked for each record (index map: 0x10) Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 18 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 17 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/User/User.php:480 16 Joomla\CMS\User\User->getAuthorisedGroups() JROOT/plugins/system/sourcerer/src/Security.php:67 15 RegularLabs\Plugin\System\Sourcerer\Security::set() JROOT/plugins/system/sourcerer/sourcerer.php:93 14 PlgSystemSourcerer->handleOnContentPrepare() JROOT/libraries/regularlabs/src/SystemPlugin.php:225 13 RegularLabs\Library\SystemPlugin->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.59 ms After last query: 51.15 ms Query memory: 0.024 MB Memory before query: 27.679 MB Rows returned: 0
SELECT r.*
FROM mbky7_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'articles' OR r.params LIKE '%\"use_xml\":\"1\"%')
ORDER BY r.ordering, r.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE r ALL NULL NO INDEX KEY COULD BE USED NULL NULL 47 Using where; Using filesort Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 1.26 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rereplacer/src/Items.php:67 15 RegularLabs\Plugin\System\ReReplacer\Items::getItemList() JROOT/plugins/system/rereplacer/rereplacer.php:102 14 PlgSystemReReplacer->handleOnContentPrepare() JROOT/libraries/regularlabs/src/SystemPlugin.php:225 13 RegularLabs\Library\SystemPlugin->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.35 ms After last query: 2.77 ms Query memory: 0.026 MB Memory before query: 28.000 MB Rows returned: 2
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM mbky7_fields AS a
LEFT JOIN `mbky7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN mbky7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN mbky7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN mbky7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN mbky7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `mbky7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (35,0,30))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','en-GB')
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context,idx_language idx_state 1 const 2 Using where; Using temporary; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 fidgetg1_ac.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 fidgetg1_ac.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 fidgetg1_ac.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 fidgetg1_ac.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 fidgetg1_ac.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 fidgetg1_ac.a.id 1 Using where; Distinct Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.04 ms Creating tmp table 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.55 ms Creating sort index 0.06 ms Removing tmp table 0.10 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:189 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.31 ms After last query: 1.74 ms Query memory: 0.024 MB Memory before query: 28.305 MB Rows returned: 1
SELECT `field_id`,`value`
FROM `mbky7_fields_values`
WHERE `field_id` IN (1,2)
AND `item_id` = '1363'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_fields_values ref idx_field_id,idx_item_id idx_item_id 766 const 1 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_fields/models/field.php:680 15 FieldsModelField->getFieldValues() JROOT/administrator/components/com_fields/helpers/fields.php:158 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.31 ms After last query: 5.38 ms Query memory: 0.024 MB Memory before query: 28.597 MB Rows returned: 10
SELECT menu_id
FROM mbky7_enablemenu_menus
WHERE `state` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_enablemenu_menus ALL NULL NO INDEX KEY COULD BE USED NULL NULL 13 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/plugins/content/osembed/library/Free/Embed.php:83 15 Alledia\OSEmbed\Free\Embed::parseContent() JROOT/plugins/content/osembed/library/Pro/Embed.php:60 14 Alledia\OSEmbed\Pro\Embed::parseContent() JROOT/plugins/content/osembed/osembed.php:141 13 PlgContentOSEmbed->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 28.611 MB Rows returned: 0
SELECT alias
FROM mbky7_content
WHERE `id` = 'hr'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/plugins/content/osembed/library/Free/Embed.php:121 15 Alledia\OSEmbed\Free\Embed::parseContent() JROOT/plugins/content/osembed/library/Pro/Embed.php:60 14 Alledia\OSEmbed\Pro\Embed::parseContent() JROOT/plugins/content/osembed/osembed.php:141 13 PlgContentOSEmbed->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.44 ms After last query: 71.55 ms Query memory: 0.023 MB Memory before query: 28.831 MB Rows returned: 1
SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `mbky7_contact_details` AS `contact`
WHERE contact.published = 1
AND contact.user_id = 929
AND (contact.language in ('en-GB','*') OR contact.language IS NULL)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE contact ref idx_state,idx_language idx_state 1 const 1 Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/plugins/content/contact/contact.php:125 14 PlgContentContact->getContactData() JROOT/plugins/content/contact/contact.php:66 13 PlgContentContact->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.48 ms After last query: 9.85 ms Query memory: 0.021 MB Memory before query: 29.069 MB Rows returned: 6
SELECT language,id
FROM `mbky7_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_menu ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 279 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.17 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.27 ms Query memory: 0.024 MB Memory before query: 29.081 MB Rows returned: 1Duplicate queries: #58
SELECT `alias`
FROM `mbky7_content`
WHERE id = '1363'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 17 ContentRouter->getArticleSegment() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/languagefilter/languagefilter.php:763 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.24 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 29.089 MB Rows returned: 1Duplicate queries: #57
SELECT `alias`
FROM `mbky7_content`
WHERE id = '1363'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_content const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 19 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125 18 ContentRouter->getArticleSegment() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 16 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/StandardRules.php:246 15 Joomla\CMS\Component\Router\Rules\StandardRules->build() JROOT/libraries/src/Component/Router/RouterView.php:244 14 Joomla\CMS\Component\Router\RouterView->build() JROOT/libraries/src/Router/SiteRouter.php:532 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/languagefilter/languagefilter.php:763 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.48 ms After last query: 0.65 ms Query memory: 0.021 MB Memory before query: 29.121 MB Rows returned: 0
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `mbky7_content` AS `c`
INNER JOIN `mbky7_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `mbky7_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `mbky7_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `mbky7_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 1363
AND c2.access IN (1,1,5)
AND c2.language != 'en-GB'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2026-08-01 09:58:02')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2026-08-01 09:58:02')
AND c2.state = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.07 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.04 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/components/com_content/helpers/association.php:76 8 ContentHelperAssociation::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:783 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.10 ms After last query: 43.96 ms Query memory: 0.023 MB Memory before query: 33.101 MB Rows returned: 7
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mbky7_modules AS m
LEFT JOIN mbky7_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mbky7_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-08-01 09:58:02')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-01 09:58:02')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 787 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds,idx_language NO INDEX KEY COULD BE USED NULL NULL 211 Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 fidgetg1_ac.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 fidgetg1_ac.m.id 4 Using where Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.07 ms Statistics 0.08 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.53 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 10 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 9 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 8 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1140 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.29 ms After last query: 1.92 ms Query memory: 0.021 MB Memory before query: 33.240 MB Rows returned: 1
SELECT `value`
FROM `mbky7_admintools_storage`
WHERE `key` = 'criticalfiles'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE mbky7_admintools_storage const PRIMARY PRIMARY 402 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/admintools/feature/criticalfiles.php:206 10 AtsystemFeatureCriticalfiles->load() JROOT/plugins/system/admintools/feature/criticalfiles.php:31 9 AtsystemFeatureCriticalfiles->onAfterRender() JROOT/plugins/system/admintools/admintools/main.php:710 8 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:171 7 plgSystemAdmintools->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.12 ms After last query: 16.47 ms Query memory: 0.021 MB Memory before query: 33.384 MB Rows returned: 0
SELECT r.*
FROM mbky7_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'component' OR r.params LIKE '%\"use_xml\":\"1\"%')
ORDER BY r.ordering, r.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE r ALL NULL NO INDEX KEY COULD BE USED NULL NULL 47 Using where; Using filesort Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.86 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rereplacer/src/Items.php:67 11 RegularLabs\Plugin\System\ReReplacer\Items::getItemList() JROOT/plugins/system/rereplacer/src/Replace.php:166 10 RegularLabs\Plugin\System\ReReplacer\Replace::replaceInArea() JROOT/plugins/system/rereplacer/src/Replace.php:66 9 RegularLabs\Plugin\System\ReReplacer\Replace::replaceInAreas() JROOT/plugins/system/rereplacer/rereplacer.php:148 8 PlgSystemReReplacer->changeFinalHtmlOutput() JROOT/libraries/regularlabs/src/SystemPlugin.php:146 7 RegularLabs\Library\SystemPlugin->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.16 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 33.390 MB Rows returned: 0
SELECT r.*
FROM mbky7_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'head' OR r.params LIKE '%\"use_xml\":\"1\"%')
ORDER BY r.ordering, r.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE r ALL NULL NO INDEX KEY COULD BE USED NULL NULL 47 Using where; Using filesort Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.95 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rereplacer/src/Items.php:67 11 RegularLabs\Plugin\System\ReReplacer\Items::getItemList() JROOT/plugins/system/rereplacer/src/Replace.php:166 10 RegularLabs\Plugin\System\ReReplacer\Replace::replaceInArea() JROOT/plugins/system/rereplacer/src/Replace.php:67 9 RegularLabs\Plugin\System\ReReplacer\Replace::replaceInAreas() JROOT/plugins/system/rereplacer/rereplacer.php:148 8 PlgSystemReReplacer->changeFinalHtmlOutput() JROOT/libraries/regularlabs/src/SystemPlugin.php:146 7 RegularLabs\Library\SystemPlugin->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.64 ms After last query: 0.03 ms Query memory: 0.170 MB Memory before query: 33.396 MB Rows returned: 27
SELECT r.*
FROM mbky7_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'body' OR r.params LIKE '%\"use_xml\":\"1\"%')
ORDER BY r.ordering, r.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE r ALL NULL NO INDEX KEY COULD BE USED NULL NULL 47 Using where; Using filesort Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.01 ms Creating sort index 0.41 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rereplacer/src/Items.php:67 11 RegularLabs\Plugin\System\ReReplacer\Items::getItemList() JROOT/plugins/system/rereplacer/src/Replace.php:166 10 RegularLabs\Plugin\System\ReReplacer\Replace::replaceInArea() JROOT/plugins/system/rereplacer/src/Replace.php:68 9 RegularLabs\Plugin\System\ReReplacer\Replace::replaceInAreas() JROOT/plugins/system/rereplacer/rereplacer.php:148 8 PlgSystemReReplacer->changeFinalHtmlOutput() JROOT/libraries/regularlabs/src/SystemPlugin.php:146 7 RegularLabs\Library\SystemPlugin->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.94 ms After last query: 25.90 ms Query memory: 0.076 MB Memory before query: 34.973 MB Rows returned: 10
SELECT r.*
FROM mbky7_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'everywhere' OR r.params LIKE '%\"use_xml\":\"1\"%')
ORDER BY r.ordering, r.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE r ALL NULL NO INDEX KEY COULD BE USED NULL NULL 47 Using where; Using filesort Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.01 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.69 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rereplacer/src/Items.php:67 11 RegularLabs\Plugin\System\ReReplacer\Items::getItemList() JROOT/plugins/system/rereplacer/src/Replace.php:154 10 RegularLabs\Plugin\System\ReReplacer\Replace::replaceEverywhere() JROOT/plugins/system/rereplacer/src/Replace.php:70 9 RegularLabs\Plugin\System\ReReplacer\Replace::replaceInAreas() JROOT/plugins/system/rereplacer/rereplacer.php:148 8 PlgSystemReReplacer->changeFinalHtmlOutput() JROOT/libraries/regularlabs/src/SystemPlugin.php:146 7 RegularLabs\Library\SystemPlugin->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1146 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
49 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
5 × SELECT r.*
FROM mbky7_rereplacer AS r2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `mbky7_categories` AS `s`
INNER JOIN `mbky7_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)2 × SELECT template
FROM mbky7_template_styles as s2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `mbky7_extensions`2 × SELECT *
FROM `mbky7_users`2 × SELECT *
FROM mbky7_extensions2 × SELECT `extension_id`
FROM `mbky7_extensions`2 × SELECT `g`.`id`,`g`.`title`
FROM `mbky7_usergroups` AS g
INNER JOIN `mbky7_user_usergroup_map` AS m
ON m.group_id = g.id2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `mbky7_assets`2 × SELECT `extension_id`,`name`,`enabled`,`params`
FROM mbky7_extensions2 × SELECT `value`
FROM `mbky7_admintools_storage`2 × SELECT `manifest_cache`
FROM `mbky7_extensions`2 × SELECT `alias`
FROM `mbky7_content`1 × SELECT alias
FROM mbky7_content1 × SELECT menu_id
FROM mbky7_enablemenu_menus1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM mbky7_template_styles AS s1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM mbky7_fields AS a
LEFT JOIN `mbky7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN mbky7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN mbky7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN mbky7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN mbky7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `mbky7_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `mbky7_contact_details` AS `contact`1 × SELECT b.id
FROM mbky7_user_usergroup_map AS map
LEFT JOIN mbky7_usergroups AS a
ON a.id = map.group_id
LEFT JOIN mbky7_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT language,id
FROM `mbky7_menu`1 × SELECT `m`.`tag_id`,`t`.*
FROM `mbky7_contentitem_tag_map` AS m
INNER JOIN `mbky7_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `mbky7_content` AS `c`
INNER JOIN `mbky7_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `mbky7_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `mbky7_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `mbky7_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM mbky7_content AS a
INNER JOIN mbky7_categories AS c
on c.id = a.catid
LEFT JOIN mbky7_users AS u
on u.id = a.created_by
LEFT JOIN mbky7_categories as parent
ON parent.id = c.parent_id
LEFT JOIN mbky7_content_rating AS v
ON a.id = v.content_id1 × SELECT `field_id`,`value`
FROM `mbky7_fields_values`1 × SELECT `data`
FROM `mbky7_session`1 × SELECT id, home, template, s.params
FROM mbky7_template_styles as s
LEFT JOIN mbky7_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `mbky7_extensions`1 × SELECT id, rules
FROM `mbky7_viewlevels1 × SELECT b.id
FROM mbky7_usergroups AS a
LEFT JOIN mbky7_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM mbky7_extensions1 × SELECT *
FROM mbky7_languages1 × SELECT *
FROM `mbky7_admintools_wafexceptions`1 × SELECT extension, file, type
FROM mbky7_rokcommon_configs1 × SELECT *
FROM `mbky7_admintools_ipautoban`1 × SELECT *
FROM `mbky7_admintools_wafblacklists`1 × SELECT `ip`
FROM `mbky7_admintools_ipblock1 × SELECT *
FROM `mbky7_admintools_storage`1 × SELECT `source`,`keepurlparams`
FROM `mbky7_admintools_redirects`1 × SELECT *
FROM mbky7_rsform_confi1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM mbky7_menu AS m
LEFT JOIN mbky7_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `id`
FROM `mbky7_content`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mbky7_modules AS m
LEFT JOIN mbky7_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mbky7_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
OTHER Tables:
1 × SHOW VARIABLES LIKE "collation_database
1 ×
SET NAMES utf8mb4 COLLATE utf8mb4_general_c1 × SHOW FULL COLUMNS
FROM `mbky7_extensions1 × UPDATE `mbky7_extensions`
SET `params` = '{\"mediaversion\":\"16f0d5212bd3bde07614565dcd876905\"}'1 × SHOW FULL COLUMNS
FROM `mbky7_content1 × UPDATE mbky7_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `mbky7_users
