Author: Sustainable Development Association- Meryem Tatlıkiraz
Introduction
People visit the 12th edition of Contemporary Istanbu (Photo by Elif Öztürk, Middle East Monitor)
Interpretation is a communication process that seeks to explain the connection of cultural heritage through relationships with objects, artifacts, landscapes, and sites. It is the presentation of information and the specific communication strategy used for people to translate this information from expert language into the visitor's everyday speech. Interpretation allows the museum to communicate the collection, connect with users and interact with a diverse audience. The best technique for Interpretation for museums is to write interpretation texts. Interpretive text is written or spoken expressions used to explain the meaning behind museums, collections, or objects.
Museum workers use collections to convey meaning, and Interpretation is one of the most effective ways to achieve this. It is about how to display the collection to the user. Museums and galleries use collections to tell stories and convey identifiable meanings. An interpretive text is a quick way to interpret museum collections, buildings, sights, and events. Well-planned, written, and placed text is a valuable and effective way to encourage visitors to become interested in collections and their meanings. By Interpretation, a museum can share the spectacle of the collection, connect with users and interact with a diverse audience.
What’s the activity?
Minsk Exhibition - Interpretation about the exhibition. Photo by Tatiana Matlina, Wikimedia Commons
The role of interpretive text is to show the object in its larger context while allowing the visitor to make his own decision. Consider an object in a museum without any explanatory text. Museum visitors will reflect on this object and its meaning, drawing on their past experiences, interests, and knowledge. There are some techniques to interpret the museum collection. The most significant way to write an interpretive text is by using labels. This is possibly the most easily accessible interpretive resource and is the backbone of Interpretation.
As a cultural mediator, your task is to create labels for an object in the museum you visit to hold visitors' attention and set up the ideal conditions for learning; we first need to attract their attention. The minimum number of objects you will write labels will be seven. By writing labels, you will obtain some qualifications and skills related to Interpretation. For example, you will get strong interpersonal skills, enthusiasm, flexibility, and the ability to work in a fast-paced, team-oriented environment, convey information concisely and articulately, and know the information about the art or local history. You will gain language proficiency.
Interpretation skills are concerned with grasping the information on paper and correctly understanding oral lectures and other pieces of information. Grammatical, syntactic, and contextual patterns are required to provide better interpretive skills. These skills have various components, such as redundancy and active and passive listening. When necessary, it is essential to apply the required features. To understand the text, the learner needs better empathy to connect with the presentation. They are in the best emotional state possible aids in better interpretation.
Therefore, listening, interpreting, and emotional skills also develop while analyzing.
What am I going to do?
There is information about what to do in the document section, review that document. In the resources section, there are some documents to help you interpret museum objects. First, you should learn the meaning of the cultural interpretation. There is an examples of writing labels for museum objects. You can watch the video or review the "Online Object Labels" document.
To label museum objects, you will follow the instructions below.;
- It would help if you were clear and concise.
- The labels are limited to 100 words.
- It would be best if you split your texts into short paragraphs.
- Labels should also have personality and rhythm, which will favor visitors' imagination and pique their interest.
- The texts should be enjoyable as well as informative.
- A label should make a direct reference to its object.
- Carefully select each word you use so that either a narrative is developed, the reader has learned something, or their interest is stimulated.
- Use text to place objects in their historical and cultural context.
What will I learn?
- ● Learners will demonstrate skills of observation and description of objects
- ● Learners will acquire the cultural and historical knowledge of the objects
- ● Active Listening
- ● Communication
- ● Analytical thinking
- ● Creativity
- ● The learners will gain experience by observing people
- ● The learners will be able to empathize with interpreters by understanding how difficult it is to interpret.
What will I take home?
With the interpretive text you write, you will allow the visitor to make their own decision while showing the object in its broader context. If you consider objects closely and from many different viewpoints, you might find that things can provoke different meanings in the person experiencing them.
After doing the activities in this quest, you will evaluate yourselves by asking the questions below.
Do you think you will achieve the aim of this quest? Is it useful for you?
Do you think this method is good for improving your interpretation skills?
What did you learn?
What kind of understanding or perception did you have due to your activities?
What kind of experiences have you had with the collections or the subject?
How did you perceive your interpretation?
What do you think went well?
Could you do better at what you do?
Have you wondered and researched what else is being interpreted in your local area?
Resources
Click each section below to see all resources available.
Resources
Click each section below to see all resources available.
Frontline Worker Toolkit
- ● Aim is to use interpretation techniques to reflect the reality and diversity of local cultural and heritage contexts through institutions such as museums.
- ● Helping to establish good neighborly relations with local people in terms of protection of the cultural materials.
- ● Enhances a place's image and strengthens bonds between local communities through quality interpretive programs and events.
- ● Helping the museums and other cultural areas to achieve their goals about audience and stakeholders.
- ● Arousing and increasing the interest of local communities in the natural or cultural heritage in which they live.
Top tips:
Tip 1. Try understanding the local culture
What is local culture?
What is local cultural elements?
How do you promote local culture?
How are local cultures sustained?
How can we preserve the set of behaviours, beliefs and customs of the local community?
Tip 2. Try interpreting the local culture
How does culture influence interpretation?
How does interpretation affect the culture?
Tip 3. Explore the stories behind the objects
Tip 4. Encourage your learners to view other people's work and provide feedback. Encourage them to discuss their tasks.
Tip 5. Get ideas about the objects from the experts in the museum and involve visitors in the active interpretation of the objects in the exhibition. Audiences' opinions are always very important.
Participation and Receptivity in the Art Museum
https://www.researchgate.net/publication/337295208_Participation_and_Receptivity_in_the_Art_Museum_-_A_Phenomenological_Exposition
Frontline worker/Educator Videos
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1785574517,
"last": 1785574517,
"now": 1785574522
},
"token": "M7Z6roAZeJgpLn1tVXwjPbCb4nC9pdgZ"
},
"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"
},
"1785574517": "<div class=\"osembed_wrapper ose-youtube \"><iframe width=\"200\" height=\"113\" src=\"https://www.youtube.com/embed/_tkLFCJUjYI?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=\"Asset Mapping: What is It?\"></iframe></div><input type='hidden' class='embed-id' id='embed-id' value='1785574517'></input>",
"link": " <hr id=\"system-readmore\" />\n\nRR_QCAT_33<br>\nAuthor: Sustainable Development Association- Meryem Tatl\u0131kiraz\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/f885/Adsz.png\" target=\"_blank\" rel=\"title[People visit the 12th edition of Contemporary Istanbu (Photo by Elif Öztürk, Middle East Monitor)]\"><img src=\"https://aceculture.eu/images/stories/com_form2content/p7/f885/Adsz.png\" alt=\"People visit the 12th edition of Contemporary Istanbu (Photo by Elif Öztürk, Middle East Monitor)\" title=\"People visit the 12th edition of Contemporary Istanbu (Photo by Elif Öztürk, Middle East Monitor)\"/></a>\n </span>\n <br><i>People visit the 12th edition of Contemporary Istanbu (Photo by Elif Öztürk, Middle East Monitor)</i>\n </center>\n <div class=\"f2c_intro\">\n <p><p>Interpretation is a communication process that seeks to explain the connection of cultural heritage through relationships with objects, artifacts, landscapes, and sites. It is the presentation of information and the specific communication strategy used for people to translate this information from expert language into the visitor's everyday speech. Interpretation allows the museum to communicate the collection, connect with users and interact with a diverse audience. The best technique for Interpretation for museums is to write interpretation texts. Interpretive text is written or spoken expressions used to explain the meaning behind museums, collections, or objects.</p>\r\n<p>Museum workers use collections to convey meaning, and Interpretation is one of the most effective ways to achieve this. It is about how to display the collection to the user. Museums and galleries use collections to tell stories and convey identifiable meanings. An interpretive text is a quick way to interpret museum collections, buildings, sights, and events. Well-planned, written, and placed text is a valuable and effective way to encourage visitors to become interested in collections and their meanings. By Interpretation, a museum can share the spectacle of the collection, connect with users and interact with a diverse audience.</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/f885/Quest_3_Photo_2.jpg\" target=\"_blank\" rel=\"title[Minsk Exhibition - Interpretation about the exhibition. Photo by Tatiana Matlina, Wikimedia Commons]\"><img src=\"https://aceculture.eu/images/stories/com_form2content/p7/f885/Quest_3_Photo_2.jpg\" alt=\"Minsk Exhibition - Interpretation about the exhibition. Photo by Tatiana Matlina, Wikimedia Commons\" title=\"Minsk Exhibition - Interpretation about the exhibition. Photo by Tatiana Matlina, Wikimedia Commons\"/></a>\n </span>\n <br><i>Minsk Exhibition - Interpretation about the exhibition. Photo by Tatiana Matlina, Wikimedia Commons</i>\n </center>\n <div class=\"f2c_intro\">\n <p><p>The role of interpretive text is to show the object in its larger context while allowing the visitor to make his own decision. Consider an object in a museum without any explanatory text. Museum visitors will reflect on this object and its meaning, drawing on their past experiences, interests, and knowledge. There are some techniques to interpret the museum collection. The most significant way to write an interpretive text is by using labels. This is possibly the most easily accessible interpretive resource and is the backbone of Interpretation.</p>\r\n<p>As a cultural mediator, your task is to create labels for an object in the museum you visit to hold visitors' attention and set up the ideal conditions for learning; we first need to attract their attention. The minimum number of objects you will write labels will be seven. By writing labels, you will obtain some qualifications and skills related to Interpretation. For example, you will get strong interpersonal skills, enthusiasm, flexibility, and the ability to work in a fast-paced, team-oriented environment, convey information concisely and articulately, and know the information about the art or local history. You will gain language proficiency.</p>\r\n<p>Interpretation skills are concerned with grasping the information on paper and correctly understanding oral lectures and other pieces of information. Grammatical, syntactic, and contextual patterns are required to provide better interpretive skills. These skills have various components, such as redundancy and active and passive listening. When necessary, it is essential to apply the required features. To understand the text, the learner needs better empathy to connect with the presentation. They are in the best emotional state possible aids in better interpretation.</p>\r\n<p>Therefore, listening, interpreting, and emotional skills also develop while analyzing.</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>There is information about what to do in the document section, review that document. In the resources section, there are some documents to help you interpret museum objects. First, you should learn the meaning of the cultural interpretation. There is an examples of writing labels for museum objects. You can watch the video or review the \"Online Object Labels\" document.</p>\r\n<p>To label museum objects, you will follow the instructions below.;</p>\r\n<ul>\r\n<li>It would help if you were clear and concise.</li>\r\n<li>The labels are limited to 100 words.</li>\r\n<li>It would be best if you split your texts into short paragraphs. </li>\r\n<li>Labels should also have personality and rhythm, which will favor visitors' imagination and pique their interest.</li>\r\n<li>The texts should be enjoyable as well as informative. </li>\r\n<li>A label should make a direct reference to its object. </li>\r\n<li>Carefully select each word you use so that either a narrative is developed, the reader has learned something, or their interest is stimulated. </li>\r\n<li>Use text to place objects in their historical and cultural context.</li>\r\n</ul></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\tLearners will demonstrate skills of observation and description of objects</li><li>\u25cf\tLearners will acquire the cultural and historical knowledge of the objects</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\tActive Listening</li><li>\u25cf\tCommunication</li><li>\u25cf\tAnalytical thinking</li><li>\u25cf\tCreativity</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\tThe learners will gain experience by observing people</li><li>\u25cf\tThe learners will be able to empathize with interpreters by understanding how difficult it is to interpret.</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>With the interpretive text you write, you will allow the visitor to make their own decision while showing the object in its broader context. If you consider objects closely and from many different viewpoints, you might find that things can provoke different meanings in the person experiencing them.</p>\r\n<p>After doing the activities in this quest, you will evaluate yourselves by asking the questions below.</p>\r\n<p>Do you think you will achieve the aim of this quest? Is it useful for you?</p>\r\n<p>Do you think this method is good for improving your interpretation skills?</p>\r\n<p>What did you learn?</p>\r\n<p>What kind of understanding or perception did you have due to your activities?</p>\r\n<p>What kind of experiences have you had with the collections or the subject?</p>\r\n<p>How did you perceive your interpretation?</p>\r\n<p>What do you think went well?</p>\r\n<p>Could you do better at what you do?</p>\r\n<p>Have you wondered and researched what else is being interpreted in your local area?</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://knepublishing.com/index.php/KnE-Social/article/view/6538/12038\" target=\"new\" style=\"color: #1155CC;\" >What is Cultural Interpretation</a></b><br>\n <a href=\"https://knepublishing.com/index.php/KnE-Social/article/view/6538/12038\" target=\"new\" style=\"font-size: smaller; display: block; line-height:1.5;\"><i>https://knepublishing.com/index.php/KnE-Social/article/view/6538/12038</i></a>\n </p>\n </div>\n <div class=\"f2c_links2\">\n <p><b><a href=\"https://www.metmuseum.org/style-guide/web-pages/online-object-labels\" target=\"new\" style=\"color: #1155CC;\">Online Object Labels</a></b><br>\n <a href=\"https://www.metmuseum.org/style-guide/web-pages/online-object-labels\" target=\"new\" style=\"font-size: smaller; display: block; line-height:1.5;\"><i>https://www.metmuseum.org/style-guide/web-pages/online-object-labels</i></a>\n </p>\n </div>\n <div class=\"f2c_links3\">\n <p><b><a href=\"https://www.vam.ac.uk/blog/creating-new-europe-1600-1800-galleries/labels-gallery-text\" target=\"new\" style=\"color: #1155CC\">Writing Labels & Gallery Text</a></b><br>\n <a href=\"https://www.vam.ac.uk/blog/creating-new-europe-1600-1800-galleries/labels-gallery-text\" target=\"new\" style=\"font-size: smaller; display: block; line-height:1.5;\"><i>https://www.vam.ac.uk/blog/creating-new-europe-1600-1800-galleries/labels-gallery-text</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=TnZbhcrLT5o\" target=\"new\"><img src=\"http://img.youtube.com/vi/https://www.youtube.com/watch?v=TnZbhcrLT5o/mqdefault.jpg\"></a>\n </div>\n <div class=\"youtubethumb\">\n <p>\n \n </p>\n <a href=\"http://www.youtube.com/embed/https://www.youtube.com/watch?v=xYz7N_uYjtc\" target=\"new\"><img src=\"http://img.youtube.com/vi/https://www.youtube.com/watch?v=xYz7N_uYjtc/mqdefault.jpg\"></a>\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 <div id=\"s7\" class=\"rl_sliders-print\"><h2 class=\"rl_sliders-title nn_sliders-title\"><a id=\"anchor-s7\" class=\"anchor\"></a><questslider>Documents </questslider></h2>\n <b><a href=\"https://aceculture.eu/media/com_form2content/documents/c7/a885/f227/Writing Interpretive Text for Museum Objects.pdf\" download style=\"color: #1155CC\">Task Description</a></b><br>\n <br>\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\tAim is to use interpretation techniques to reflect the reality and diversity of local cultural and heritage contexts through institutions such as museums.</li><li>\u25cf\tHelping to establish good neighborly relations with local people in terms of protection of the cultural materials.</li><li>\u25cf\tEnhances a place's image and strengthens bonds between local communities through quality interpretive programs and events.</li><li>\u25cf\tHelping the museums and other cultural areas to achieve their goals about audience and stakeholders.</li><li>\u25cf\tArousing and increasing the interest of local communities in the natural or cultural heritage in which they live.</li></ul></p>\n </div>\n\n\n<h2>Top tips:</h2>\n<p> <p><em> </em></p>\r\n<p><strong>Tip 1. </strong>Try understanding the local culture</p>\r\n<p>What is local culture?</p>\r\n<p>What is local cultural elements?</p>\r\n<p>How do you promote local culture?</p>\r\n<p>How are local cultures sustained?</p>\r\n<p>How can we preserve the set of behaviours, beliefs and customs of the local community?</p>\r\n<p><strong>Tip 2. </strong>Try interpreting the local culture</p>\r\n<p>How does culture influence interpretation?</p>\r\n<p>How does interpretation affect the culture?</p>\r\n<p><strong>Tip 3</strong>. Explore the stories behind the objects</p>\r\n<p><strong>Tip 4.</strong> Encourage your learners to view other people's work and provide feedback. Encourage them to discuss their tasks.</p>\r\n<p><strong>Tip 5. </strong>Get ideas about the objects from the experts in the museum and involve visitors in the active interpretation of the objects in the exhibition. Audiences' opinions are always very important.</p> </p>\n\n<p> </p>\n\n<p>\n <div class=\"f2c_links6\">\n <p><b><a href=\"https://www.researchgate.net/publication/337295208_Participation_and_Receptivity_in_the_Art_Museum_-_A_Phenomenological_Exposition\" target=\"new\" style=\"color: #1155CC\">Participation and Receptivity in the Art Museum</a></b><br>\n <a href=\"https://www.researchgate.net/publication/337295208_Participation_and_Receptivity_in_the_Art_Museum_-_A_Phenomenological_Exposition\" target=\"new\" style=\"display: block; line-height:1.5;\"><i>https://www.researchgate.net/publication/337295208_Participation_and_Receptivity_in_the_Art_Museum_-_A_Phenomenological_Exposition</i></a>\n </p>\n </div>\n </p>\n\n<p>\n<h3>Frontline worker/Educator Videos</h3>\n</p>\n<div class=\"gantry-width-block gantry-width-20\">\n <div class=\"gantry-width-spacer\">\n <div class=\"t_youtubethumb test\">\n <a href=\"http://www.youtube.com/embed/https://www.youtube.com/watch?v=mYsboK8dS5g\" target=\"new\"><img src=\"http://img.youtube.com/vi/https://www.youtube.com/watch?v=mYsboK8dS5g/mqdefault.jpg\"></a>\n \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>-->",
"1785574522": "<div class=\"osembed_wrapper ose-youtube \"><iframe width=\"420\" height=\"315\" src=\"//www.youtube.com/embed/https\" frameborder=\"0\" allowfullscreen></iframe></div><input type='hidden' class='embed-id' id='embed-id' value='1785574522'></input>"
}
}
Time
Memory
65 Queries Logged 29.87 ms
12 duplicate found!
- Query Time: 0.31 ms Query memory: 0.085 MB Memory before query: 9.356 MB Rows returned: 1
SELECT `data`
FROM `mbky7_session`
WHERE `session_id` = X'6137383264333738663630626537303538643364363666633532666238376362'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.00 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.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.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 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.41 ms After last query: 1.88 ms Query memory: 0.025 MB Memory before query: 9.804 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.04 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.02 ms Optimizing 0.02 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.01 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.01 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.19 ms Query memory: 0.021 MB Memory before query: 10.001 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.00 ms Sending data 0.02 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.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.26 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 10.015 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.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 Unlocking tables 0.00 ms Preparing 0.01 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.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.57 ms After last query: 0.35 ms Query memory: 0.051 MB Memory before query: 10.084 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.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 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.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.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.34 ms After last query: 5.62 ms Query memory: 0.022 MB Memory before query: 11.667 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.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.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.08 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.01 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.35 ms After last query: 2.44 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.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.01 ms Sending data 0.08 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.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/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.26 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 11.982 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.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.04 ms Preparing 0.01 ms Unlocking tables 0.01 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 closing tables 0.01 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/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.34 ms After last query: 1.08 ms Query memory: 0.023 MB Memory before query: 12.172 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.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.02 ms Statistics 0.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.06 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 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.18 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 12.184 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.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.00 ms Executing 0.01 ms End of update loop 0.00 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.01 ms Reset for next command 0.00 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.28 ms After last query: 7.89 ms Query memory: 0.023 MB Memory before query: 13.283 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.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.05 ms Preparing 0.02 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.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.00 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: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.28 ms After last query: 6.90 ms Query memory: 0.022 MB Memory before query: 14.377 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.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.03 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.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.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.28 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 14.384 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.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 Executing 0.01 ms Sending data 0.02 ms End of update loop 0.02 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.01 ms Updating status 0.01 ms Reset for next command 0.02 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.23 ms After last query: 1.68 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.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.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.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.01 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.31 ms After last query: 9.15 ms Query memory: 0.022 MB Memory before query: 16.116 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.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.03 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 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 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.63 ms After last query: 3.90 ms Query memory: 0.022 MB Memory before query: 16.500 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.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.39 ms Executing 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.01 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 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.16 ms After last query: 0.03 ms Query memory: 0.006 MB Memory before query: 16.508 MB
SET NAMES utf8mb4 COLLATE utf8mb4_general_ciEXPLAIN not possible on query: SET NAMES utf8mb4 COLLATE utf8mb4_general_ciStatus Duration Starting 0.04 ms Opening tables 0.01 ms After opening tables 0.01 ms Query end 0.01 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 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.22 ms After last query: 0.27 ms Query memory: 0.021 MB Memory before query: 16.541 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.01 ms System lock 0.01 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.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: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.546 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.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.01 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 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: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.24 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 16.552 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.00 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.01 ms Query end 0.00 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.01 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: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.20 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 16.563 MB Rows returned: 0
SELECT `source`,`keepurlparams`
FROM `mbky7_admintools_redirects`
WHERE ((`dest` = 'en/q/cat03/developing-interpreting-skills-of-the-learners-by-writing-interpretive-texts-for-exhibitions2') OR (`dest` = 'en/q/cat03/developing-interpreting-skills-of-the-learners-by-writing-interpretive-texts-for-exhibitions2?layout=default&print=1&tmpl=component') OR ('en/q/cat03/developing-interpreting-skills-of-the-learners-by-writing-interpretive-texts-for-exhibitions2?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.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.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.00 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.25 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 16.591 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.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.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.68 ms After last query: 4.32 ms Query memory: 0.026 MB Memory before query: 17.133 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.27 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.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.04 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.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.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 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.23 ms After last query: 0.36 ms Query memory: 0.021 MB Memory before query: 17.176 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.00 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.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.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: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.04 ms Query memory: 0.021 MB Memory before query: 17.183 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.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.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.25 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 17.187 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.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.02 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.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 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: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.20 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 17.193 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.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.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: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.28 ms After last query: 20.20 ms Query memory: 0.024 MB Memory before query: 18.913 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.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.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.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 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: 1.17 ms After last query: 3.59 ms Query memory: 0.259 MB Memory before query: 19.162 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.10 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.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.78 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.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.58 ms After last query: 11.24 ms Query memory: 0.031 MB Memory before query: 20.683 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.10 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.05 ms Optimizing 0.02 ms Statistics 0.09 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.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: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.32 ms After last query: 0.51 ms Query memory: 0.022 MB Memory before query: 20.827 MB Rows returned: 1
SELECT `id`
FROM `mbky7_content`
WHERE alias = 'developing-interpreting-skills-of-the-learners-by-writing-interpretive-texts-for-exhibitions2'
AND catid = '33'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.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.06 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.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: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.30 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 20.834 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.01 ms table lock 0.01 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.02 ms Removing tmp table 0.01 ms Creating sort index 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.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: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.28 ms After last query: 0.74 ms Query memory: 0.026 MB Memory before query: 20.901 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.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.05 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.02 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.65 ms After last query: 0.10 ms Query memory: 0.006 MB Memory before query: 20.895 MB
UPDATE `mbky7_extensions`
SET `params` = '{\"mediaversion\":\"09ad82c04921eeef1cfbf5f6055532f9\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `mbky7_extensions` SET `params` = '{\"mediaversion\":\"09ad82c04921eeef1cfbf5f6055532f9\"}' 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.06 ms End of update loop 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.37 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.51 ms After last query: 3.17 ms Query memory: 0.026 MB Memory before query: 21.299 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.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.07 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.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 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.29 ms After last query: 11.14 ms Query memory: 0.023 MB Memory before query: 22.983 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.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 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.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 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.69 ms After last query: 5.03 ms Query memory: 0.028 MB Memory before query: 23.744 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.04 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.01 ms Statistics 0.11 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.32 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 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.95 ms After last query: 0.10 ms Query memory: 0.087 MB Memory before query: 23.800 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.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.04 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.67 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 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.72 ms After last query: 1.32 ms Query memory: 0.031 MB Memory before query: 24.304 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.01 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.28 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.02 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.09 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.01 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.09 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 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: 0.57 ms After last query: 1.77 ms Query memory: 0.005 MB Memory before query: 24.522 MB
UPDATE mbky7_content
SET `hits` = (`hits` + 1)
WHERE `id` = '1358'EXPLAIN not possible on query: UPDATE mbky7_content SET `hits` = (`hits` + 1) WHERE `id` = '1358'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.07 ms End of update loop 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.29 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.01 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.48 ms After last query: 0.92 ms Query memory: 0.078 MB Memory before query: 24.644 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 = 1358
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 08:55:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-01 08:55:22')
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.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.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.00 ms closing tables 0.02 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: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.41 ms After last query: 1.27 ms Query memory: 0.028 MB Memory before query: 24.838 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 = 33
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.05 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.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.00 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.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 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.20 ms Query memory: 0.022 MB Memory before query: 24.863 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` = 1358
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.01 ms System lock 0.02 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.16 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.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 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/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.59 ms After last query: 13.00 ms Query memory: 0.029 MB Memory before query: 26.079 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.02 ms checking permissions 0.01 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.00 ms checking permissions 0.04 ms closing tables 0.01 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.02 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.03 ms Reset for next command 0.01 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.21 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 26.124 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.00 ms Unlocking tables 0.01 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.01 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.25 ms After last query: 2.07 ms Query memory: 0.024 MB Memory before query: 26.882 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.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 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.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.20 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 26.892 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.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.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.26 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 26.904 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.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.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.03 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.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.32 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 26.915 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.08 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.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.46 ms After last query: 137.21 ms Query memory: 0.024 MB Memory before query: 27.698 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.11 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.05 ms Optimizing 0.03 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.96 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 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.64 ms After last query: 3.36 ms Query memory: 0.026 MB Memory before query: 28.019 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 (33,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.15 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.06 ms Optimizing 0.04 ms Statistics 0.18 ms Preparing 0.05 ms Creating tmp table 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.56 ms Creating sort index 0.08 ms Removing tmp table 0.15 ms Creating sort index 0.03 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.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 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.36 ms After last query: 2.34 ms Query memory: 0.024 MB Memory before query: 28.325 MB Rows returned: 1
SELECT `field_id`,`value`
FROM `mbky7_fields_values`
WHERE `field_id` IN (1,2)
AND `item_id` = '1358'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.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.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.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.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/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.27 ms After last query: 6.28 ms Query memory: 0.024 MB Memory before query: 28.617 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.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.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.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.23 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 28.630 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.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 Executing 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.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.38 ms After last query: 84.57 ms Query memory: 0.023 MB Memory before query: 28.850 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.07 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.05 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.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: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.65 ms After last query: 7.52 ms Query memory: 0.021 MB Memory before query: 29.089 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.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.22 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.14 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.00 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.27 ms After last query: 0.41 ms Query memory: 0.024 MB Memory before query: 29.100 MB Rows returned: 1Duplicate queries: #58
SELECT `alias`
FROM `mbky7_content`
WHERE id = '1358'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.02 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.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.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 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.21 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 29.109 MB Rows returned: 1Duplicate queries: #57
SELECT `alias`
FROM `mbky7_content`
WHERE id = '1358'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.01 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 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.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.02 ms Reset for next command 0.00 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.51 ms After last query: 1.04 ms Query memory: 0.021 MB Memory before query: 29.141 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 = 1358
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 08:55:22')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2026-08-01 08:55:22')
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.13 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.08 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.00 ms Freeing items 0.01 ms Updating status 0.01 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: 0.98 ms After last query: 38.08 ms Query memory: 0.023 MB Memory before query: 33.120 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 08:55:22')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-01 08:55:22')
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.10 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.05 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.43 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 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.24 ms After last query: 1.71 ms Query memory: 0.021 MB Memory before query: 33.259 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.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.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.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.02 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.36 ms After last query: 15.58 ms Query memory: 0.021 MB Memory before query: 33.404 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.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 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 1.06 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.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 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/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.01 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 33.410 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.00 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.81 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: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.61 ms After last query: 0.03 ms Query memory: 0.170 MB Memory before query: 33.416 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.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.42 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.02 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: 1.13 ms After last query: 24.18 ms Query memory: 0.076 MB Memory before query: 34.992 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.05 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.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.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.01 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\":\"09ad82c04921eeef1cfbf5f6055532f9\"}'1 × SHOW FULL COLUMNS
FROM `mbky7_content1 × UPDATE mbky7_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `mbky7_users


