Home - MMBioS

Overview

The National Center for Multiscale Modeling of Biological Systems (MMBioS) develops tools to advance and facilitate cutting-edge research at the interface between high performance computing and the life sciences. Our overarching goal is the predictive multi-scale modeling of the spatiotemporal organization and evolution of neurosignaling systems and events. The advances made here will impact the research activities of a broad group of scientists, from molecular and structural biologists to cell and systems biologists. These advances will also facilitate the translation of basic tools to biomedical and clinical research by establishing and then disseminating a computational framework which integrates theory with experiment and models with methods originating from different disciplines.

We are building on the state-of-the-art technology and methods at the forefront of molecular and cellular modeling that have been developed at our partner sites. Rapid advances in experimental technologies which enable the study of events ranging from single molecule dynamics to tissue level organization also create multi-scale modeling challenges. We are addressing these emerging challenges, including high performance computing, data storage and networking needs.

Software & Servers

See all MMBioS software, servers and databases

MMBioS is a joint Center between the University of Pittsburgh, the Pittsburgh Supercomputing Center, Carnegie Mellon University, and the Salk Institute for Biological Studies.

Latest News

More News...

Upcoming Events

05 Sep 2019;
12:30PM - 02:30PM
MMBioS Monthly Meeting

View Full Calendar

Past Events

01 Aug 2019;
12:30PM - 02:30PM
MMBioS Monthly Meeting

View Full Calendar

Collaborate with MMBioS

Propose a Collaboration

Research Highlights

Monoamine transporters: structure, intrinsic dynamics and allosteric regulation

T&RD1 investigators Mary Cheng and Ivet Bahar published an invited review article in Nature Structural & Molecular Biology, addressing recent progress in the elucidation of the structural dynamics of MATs and their conformational landscape and transitions, as well as allosteric regulation mechanisms. (Read more)

Trimerization of dopamine transporter triggered by AIM-100 binding

The Bahar (TR&D1) and Sorkin (DBP3) labs explored the trimerization of dopamine transporter (DAT) triggered by a furopyrimidine, AIM-100, using a combination of computational and biochemical methods, and single-molecule live-cell imaging assays. (Read more)

Pre-post synaptic alignment through neuroligin-1 tunes synaptic transmission efficiency

TR&D2 investigators and collaborators describe organizing role of neuroligin-1 to align post-synaptic AMPA Receptors with pre-synaptic release sites into trans-synaptic “nano-columns” to enhance signaling.(Read more)

Inferring the Assembly Network of Influenza Virus

In an article in PLoS Computational Biology, MMBioS TR&D4 members Xiongto Ruan and Bob Murphy collaborated with Seema Lakdawala to address this question of the assembly network of the Influenza virus.(Read more)

PINK1 Interacts with VCP/p97 and Activates PKA to Promote NSFL1C/p47 Phosphorylation and Dendritic Arborization in Neurons

Our findings highlight an important mechanism by which proteins genetically implicated in Parkinson’s disease (PD; PINK1) and frontotemporal dementia (FTD; VCP) interact to support the health and maintenance of neuronal arbors.(Read more)

Improved methods for modeling cell shape

In a recent paper in Bioinformatics, Xiongtao Ruan and Bob Murphy of TR&D4 addressed the question of how best to model cell and nuclear shape.(Read more)

New tool to predict pathogenicity of missense variants based on structural dynamics: RHAPSODY

We demonstrated that the analysis of a protein’s intrinsic dynamics can be successfully used to improve the prediction of the effect of point mutations on a protein functionality. This method employs ANM/GNM tools (Read more)

New method for investigating chromatin structural dynamics.

By adapting the Gaussian Network Model (GNM) protein-modeling framework, we were able to model chromatin dynamics using Hi-C data, which led to the identification of novel cross-correlated distal domains (CCDDs) that were found to also be associated with increased gene co-expression. (Read more)

Structural elements coupling anion conductance and substrate transport identified

We identified an intermediate anion channeling state (iChS) during the global transition from the outward facing (OF) to inward facing state (IFS). Our prediction was tested and validated by experimental study conducted in the Amara lab (NIMH). Critical residues and interactions were analyzed by SCAM, electrophysiology and substrate uptake experiments (Read more)

Integrating MMBioS technologies for multiscale discovery

TR&D teams driven by individual DBPs are naturally joining forces, integrating their tools to respond to the needs of the DBP, and creating integrative frameworks for combining structural and kinetic data and computing technologies at multiple scales. (Read more)

Large scale visualization of rule-based models.

Signaling in living cells is mediated through a complex network of chemical interactions. Current predictive models of signal pathways have hundreds of reaction rules that specify chemical interactions, and a comprehensive model of a stem cell or cancer cell would be expected to have many more. Visualizations of rules and their interactions are needed to navigate, organize, communicate and analyze large signaling models. (Read more)

Integration of MCellR into MCell/CellBlender

Using spatial biochemical models of SynGAP/PSD95, MMBioS investigators were able to merge the MCellR code-base with the MCell code-base and validate its utility and correctness of this sophisticated technology now easily accessible through the MCell/CellBlender GUI. (Read more)

Causal relationships of spatial distributions of T cell signaling proteins

The idea is to identify a relationship in which a change in the concentration of one protein in one cell region consistently is associated with a change in the concentration of another protein in the same or a different region. We used the data from our Science Signaling paper reported last year to construct a model for T cells undergoing stimulation by both the T cell receptor and the costimulatory receptor. (Read more...)

T-Cell Receptor Signaling

BioNetGen modeling helps reveal immune system response decision

To attack or to let be is an important decision that our immune systems must make to protect our bodies from foreign invaders or protect bodily tissues from an immune attack. Using modeling and experiments, we have painted a sharper picture of how T cells make these critical decisions. (Read more)

distancecell

Tools for determining the spatial relationships between different cell components

An important task for understanding how cells are organized is determining which components have spatial patterns that are related to each other.Read more

4d rtd

Pipeline for creation of spatiotemporal maps

Using a combination of diffeomorphic methods and improved cell segmentation, we developed a CellOrganizer pipeline for use in DPB4 to construct models of the 4D distributions of actin and 8 of its regulators during the response of T cells to antigen presentation. Read more

Multi-scale Hybrid Methodology

The hybrid methodology, coMD, that we have recently developed [1] has been recently extended to construct the energy landscape near the functional states of LeuT (Fig 1) [2]. This is the first energy landscape constructed for this NSS family member. Read more

Insights into the cooperative dynamics of AMPAR

Comparative analysis of AMPAR and NMDAR dynamics reveals striking similarities, opening the way to designing new modulators of allosteric interactions. Read more

Improved Sampling of Cell-Scale Models using the WE Strategy

The WE strategy for orchestrating a large set of parallel simulations has now been extended to spatially resolved cell-scale systems. The WESTPA implementation of WE has been used to control MCell simulations, including models built using a BioNetGen-CellOrganizer pipeline for situating complex biochemistry within spatially realistic cell models. Read more

Mouse visual cortex
Anatomy and Function of an Excitatory Network in the Visual Cortex

MMBioS researcher Greg Hood’s collaboration with Wei-Chung Allen Lee of Harvard University and R. Clay Reid of the Allen Institute for Brain Science concerning the reconstruction of an excitatory nerve-cell network in the mouse brain cortex at a subcellular level using the AlignTK software has been published in Nature. Read more

Molecular Mechanism of Dopamine Transport by hDAT

Dopamine transporters (DATs) control neurotransmitter dopamine (DA) homeostasis by reuptake of excess DA, assisted by sodium and chloride ions. The recent resolution of DAT structure (dDAT) from Drosophila permits us for the first time to directly view the sequence of events involved in DA reuptake in human DAT (hDAT). Read more

figure good 170 Synaptic Facilitation Revealed

An investigation of several mechanisms of short-term facilitation at the frog neuromuscular junction concludes that the presence of a second class of calcium sensor proteins distinct from synaptotagmin can explain known properties of facilitation. Read more

langmead2 200 Sparse Graphical Models of Protein:Protein Interactions

DgSpi is a new method for learning and using graphical models that explicitly represent the amino acid basis for interaction specificity and extend earlier classification-oriented approaches to predict ΔG of binding. Read more

Picture1 180 Advancing Parallel Bio-simulations

A new non-Markovian analysis can eliminate bias in estimates of long-timescale behavior, such as the mean first-passage time for the dissociation of methane molecules in explicit solvent. Read more

View all Research Highlights

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1566281531,
                "last": 1566281531,
                "now": 1566281531
            },
            "token": "jY1D42E1xXXKobugMcxUiUkh9KiM4Plv"
        },
        "registry": {
            "jevents": {
                "moduleid121": {
                    "shownEventIds": [
                        [
                            "8"
                        ]
                    ],
                    "page": 0,
                    "firstEventDate": "2019-09-05 12:30:00",
                    "lastEventDate": "2019-09-05 12:30:00"
                },
                "moduleid129": {
                    "shownEventIds": [
                        [
                            "7"
                        ]
                    ],
                    "page": 0,
                    "firstEventDate": "2019-08-01 12:30:00",
                    "lastEventDate": "2019-08-01 12:30:00"
                }
            },
            "published_fv_ses": "0"
        },
        "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
        }
    }
}

Profile Information

Memory Usage

Database Queries

17 Queries Logged 96.51 ms

Query Time: 1.00 ms Query memory: 0.022 MB Memory before query: 0.873 MB Rows returned: 0

SELECT `data`

  FROM `mmb17_session`

  WHERE `session_id` = '4o9utbvfprss94mc951jj9uu8n'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mmb17_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1730
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:755
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:134
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:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.91 ms After last query: 0.88 ms Query memory: 0.020 MB Memory before query: 0.885 MB Rows returned: 0

SELECT `session_id`

  FROM `mmb17_session`

  WHERE `session_id` = '4o9utbvfprss94mc951jj9uu8n' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mmb17_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT\libraries\src\Session\MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT\libraries\src\Application\CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:134
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:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 6.09 ms After last query: 0.11 ms Query memory: 0.003 MB Memory before query: 0.889 MB

INSERT INTO `mmb17_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('4o9utbvfprss94mc951jj9uu8n', 1, '1566281531', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `mmb17_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('4o9utbvfprss94mc951jj9uu8n', 1, '1566281531', 0, '', 0)

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.10 ms
Waiting for query cache lock	0.01 ms
update	0.02 ms
end	0.01 ms
query end	5.09 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Session\MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT\libraries\src\Application\CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:134
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:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.94 ms After last query: 2.35 ms Query memory: 0.021 MB Memory before query: 1.014 MB Rows returned: 5

SELECT id, rules

  FROM `mmb17_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mmb17_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1496
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:321
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:606
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.15 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 1.023 MB Rows returned: 2

SELECT b.id

  FROM mmb17_usergroups AS a

  LEFT JOIN mmb17_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1540
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:321
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:606
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.44 ms After last query: 33.56 ms Query memory: 0.003 MB Memory before query: 2.154 MB

UPDATE `mmb17_extensions`

  SET `params` = '{\"mediaversion\":\"5fbde01d0c6aa691714d318405641c54\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	mmb17_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.07 ms
updating	0.10 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	4.21 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Helper\LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT\libraries\src\Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT\libraries\src\Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT\libraries\src\Application\WebApplication.php:1113
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT\libraries\src\Application\SiteApplication.php:133
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 60.21 ms After last query: 20.45 ms Query memory: 0.074 MB Memory before query: 2.402 MB Rows returned: 1

SELECT *

  FROM mmb17_content

  WHERE id = 165

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mmb17_content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.12 ms
Waiting for query cache lock	0.01 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1652
12	JDatabaseDriver->loadObject()	JROOT\modules\mod_textscroller\helpers\content.php:38
11	modTextScrollerContentHelper::get()	JROOT\modules\mod_textscroller\mod_textscroller.php:59
10	include JROOT\modules\mod_textscroller\mod_textscroller.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.75 ms After last query: 7.80 ms Query memory: 0.028 MB Memory before query: 2.610 MB Rows returned: 40

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `mmb17_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_ars','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_gantry5','com_installer','com_j2xml','com_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_profiles','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mmb17_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	381	10.76	Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.68 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Access\Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT\libraries\src\Access\Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT\libraries\src\Access\Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT\libraries\src\Access\Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT\libraries\src\User\User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT\components\com_jevents\libraries\helper.php:2368
14	JEVHelper::isAdminUser()	JROOT\components\com_jevents\libraries\helper.php:2450
13	JEVHelper::getAid()	JROOT\components\com_jevents\libraries\datamodel.php:40
12	JEventsDataModel->__construct()	JROOT\modules\mod_jevents_latest\tmpl\default\latest.php:85
11	DefaultModLatestView->__construct()	JROOT\modules\mod_jevents_latest\mod_jevents_latest.php:46
10	include JROOT\modules\mod_jevents_latest\mod_jevents_latest.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.74 ms After last query: 5.64 ms Query memory: 0.030 MB Memory before query: 2.698 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `mmb17_jev_users`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `mmb17_jev_users`

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.25 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.04 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:441
22	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\src\Table\Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT\administrator\components\com_jevents\tables\jevuser.php:69
19	TableUser->__construct()	JROOT\components\com_jevents\libraries\helper.php:2308
18	JEVHelper::getAuthorisedUser()	JROOT\components\com_jevents\libraries\helper.php:1201
17	JEVHelper::isEventCreator()	JROOT\components\com_jevents\libraries\filters\Published.php:50
16	jevPublishedFilter->__construct()	JROOT\components\com_jevents\libraries\filters.php:142
15	jevFilterProcessing->__construct()	JROOT\components\com_jevents\libraries\filters.php:200
14	jevFilterProcessing::getInstance()	JROOT\components\com_jevents\libraries\dbmodel.php:923
13	JEventsDBModel->listLatestIcalEvents()	JROOT\modules\mod_jevents_latest\tmpl\default\latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT\modules\mod_jevents_latest\tmpl\flat\latest.php:27
11	FlatModLatestView->displayLatestEvents()	JROOT\modules\mod_jevents_latest\mod_jevents_latest.php:48
10	include JROOT\modules\mod_jevents_latest\mod_jevents_latest.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.48 ms After last query: 2.20 ms Query memory: 0.030 MB Memory before query: 2.815 MB Rows returned: 2

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 `mmb17_categories` AS `c`

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	range	cat_idx,idx_access	cat_idx	207	NULL	4	100.00	Using index condition; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Categories\Categories.php:312
21	Joomla\CMS\Categories\Categories->_load()	JROOT\components\com_jevents\helpers\category.php:47
20	JEventsCategories->_load()	JROOT\libraries\src\Categories\Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT\components\com_jevents\libraries\dbmodel.php:77
18	JEventsDBModel->accessibleCategoryList()	JROOT\components\com_jevents\libraries\datamodel.php:886
17	JEventsDataModel->accessibleCategoryList()	JROOT\components\com_jevents\libraries\filters\Category.php:39
16	jevCategoryFilter->__construct()	JROOT\components\com_jevents\libraries\filters.php:142
15	jevFilterProcessing->__construct()	JROOT\components\com_jevents\libraries\filters.php:200
14	jevFilterProcessing::getInstance()	JROOT\components\com_jevents\libraries\dbmodel.php:923
13	JEventsDBModel->listLatestIcalEvents()	JROOT\modules\mod_jevents_latest\tmpl\default\latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT\modules\mod_jevents_latest\tmpl\flat\latest.php:27
11	FlatModLatestView->displayLatestEvents()	JROOT\modules\mod_jevents_latest\mod_jevents_latest.php:48
10	include JROOT\modules\mod_jevents_latest\mod_jevents_latest.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.14 ms After last query: 0.30 ms Query memory: 0.024 MB Memory before query: 2.833 MB Rows returned: 1

SELECT c.id

  FROM mmb17_categories AS c

  WHERE c.access   IN (1,1,5)
 
  AND c.published = 1
  
  AND c.language in ('en-GB','*')
 
  AND c.extension = 'com_jevents'
 

  ORDER BY c.lft asc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	2	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1540
19	JDatabaseDriver->loadColumn()	JROOT\components\com_jevents\libraries\dbmodel.php:186
18	JEventsDBModel->accessibleCategoryList()	JROOT\components\com_jevents\libraries\datamodel.php:886
17	JEventsDataModel->accessibleCategoryList()	JROOT\components\com_jevents\libraries\filters\Category.php:39
16	jevCategoryFilter->__construct()	JROOT\components\com_jevents\libraries\filters.php:142
15	jevFilterProcessing->__construct()	JROOT\components\com_jevents\libraries\filters.php:200
14	jevFilterProcessing::getInstance()	JROOT\components\com_jevents\libraries\dbmodel.php:923
13	JEventsDBModel->listLatestIcalEvents()	JROOT\modules\mod_jevents_latest\tmpl\default\latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT\modules\mod_jevents_latest\tmpl\flat\latest.php:27
11	FlatModLatestView->displayLatestEvents()	JROOT\modules\mod_jevents_latest\mod_jevents_latest.php:48
10	include JROOT\modules\mod_jevents_latest\mod_jevents_latest.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.65 ms After last query: 2.57 ms Query memory: 0.040 MB Memory before query: 2.868 MB Rows returned: 1

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM mmb17_jevents_repetition as rpt
 
  INNER JOIN mmb17_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN mmb17_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN mmb17_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN mmb17_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,49)
 
  AND rpt.endrepeat >= '2019-08-20 02:12:11' 
  AND rpt.startrepeat <= '2019-09-19 23:59:59'
 
  AND (rpt.startrepeat >= '2019-08-20 00:00:00' OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
						
  ORDER BY rpt.startrepeat ASC 
  LIMIT 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	NULL	ref	PRIMARY,stateidx	stateidx	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	ev	NULL	ref	PRIMARY,icsid,stateidx,evaccess	icsid	4	mmbios.icsf.ics_id	9	22.22	Using where
1	SIMPLE	rpt	NULL	ref	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid	4	mmbios.ev.ev_id	1	27.78	Using where
1	SIMPLE	det	NULL	eq_ref	PRIMARY,multiday	PRIMARY	4	mmbios.rpt.eventdetail_id	1	100.00	Using where
1	SIMPLE	rr	NULL	ref	eventid	eventid	4	mmbios.ev.ev_id	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.08 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.16 ms
preparing	0.04 ms
Creating tmp table	0.08 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.58 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT\components\com_jevents\libraries\dbmodel.php:2584
17	JEventsDBModel->_cachedlistIcalEvents()	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\Cache\Controller\CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT\components\com_jevents\libraries\dbmodel.php:1423
13	JEventsDBModel->listLatestIcalEvents()	JROOT\modules\mod_jevents_latest\tmpl\default\latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT\modules\mod_jevents_latest\tmpl\flat\latest.php:27
11	FlatModLatestView->displayLatestEvents()	JROOT\modules\mod_jevents_latest\mod_jevents_latest.php:48
10	include JROOT\modules\mod_jevents_latest\mod_jevents_latest.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.35 ms After last query: 5.70 ms Query memory: 0.038 MB Memory before query: 2.915 MB Rows returned: 0

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM mmb17_jevents_repetition as rpt
 
  INNER JOIN mmb17_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN mmb17_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN mmb17_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN mmb17_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,49)
 
  AND rpt.endrepeat >= '2019-08-20 00:00:00' 
  AND rpt.startrepeat <= '2019-08-20 02:12:11'
 
  AND (rpt.startrepeat >= '2019-08-20 00:00:00' OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
  ORDER BY rpt.startrepeat desc 
  LIMIT 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	NULL	ref	PRIMARY,stateidx	stateidx	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	ev	NULL	ref	PRIMARY,icsid,stateidx,evaccess	icsid	4	mmbios.icsf.ics_id	9	22.22	Using where
1	SIMPLE	rpt	NULL	ref	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid	4	mmbios.ev.ev_id	1	25.00	Using where
1	SIMPLE	det	NULL	eq_ref	PRIMARY,multiday	PRIMARY	4	mmbios.rpt.eventdetail_id	1	100.00	Using where
1	SIMPLE	rr	NULL	ref	eventid	eventid	4	mmbios.ev.ev_id	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.07 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.46 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT\components\com_jevents\libraries\dbmodel.php:2584
17	JEventsDBModel->_cachedlistIcalEvents()	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\Cache\Controller\CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT\components\com_jevents\libraries\dbmodel.php:1466
13	JEventsDBModel->listLatestIcalEvents()	JROOT\modules\mod_jevents_latest\tmpl\default\latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT\modules\mod_jevents_latest\tmpl\flat\latest.php:27
11	FlatModLatestView->displayLatestEvents()	JROOT\modules\mod_jevents_latest\mod_jevents_latest.php:48
10	include JROOT\modules\mod_jevents_latest\mod_jevents_latest.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.32 ms After last query: 2.75 ms Query memory: 0.038 MB Memory before query: 2.922 MB Rows returned: 0

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM mmb17_jevents_repetition as rpt
 
  INNER JOIN mmb17_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN mmb17_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN mmb17_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN mmb17_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,49)
 
  AND rpt.endrepeat >= '2019-08-20 00:00:00' 
  AND rpt.startrepeat <= '2019-08-20 02:12:11'
 
  AND (rpt.startrepeat <= '2019-08-20 00:00:00'OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
  ORDER BY rpt.startrepeat asc 
  LIMIT 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	NULL	ref	PRIMARY,stateidx	stateidx	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	ev	NULL	ref	PRIMARY,icsid,stateidx,evaccess	icsid	4	mmbios.icsf.ics_id	9	22.22	Using where
1	SIMPLE	rpt	NULL	ref	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid	4	mmbios.ev.ev_id	1	25.00	Using where
1	SIMPLE	det	NULL	eq_ref	PRIMARY,multiday	PRIMARY	4	mmbios.rpt.eventdetail_id	1	100.00	Using where
1	SIMPLE	rr	NULL	ref	eventid	eventid	4	mmbios.ev.ev_id	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.45 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT\components\com_jevents\libraries\dbmodel.php:2584
17	JEventsDBModel->_cachedlistIcalEvents()	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\Cache\Controller\CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT\components\com_jevents\libraries\dbmodel.php:1508
13	JEventsDBModel->listLatestIcalEvents()	JROOT\modules\mod_jevents_latest\tmpl\default\latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT\modules\mod_jevents_latest\tmpl\flat\latest.php:27
11	FlatModLatestView->displayLatestEvents()	JROOT\modules\mod_jevents_latest\mod_jevents_latest.php:48
10	include JROOT\modules\mod_jevents_latest\mod_jevents_latest.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.26 ms After last query: 6.25 ms Query memory: 0.028 MB Memory before query: 2.969 MB Rows returned: 1

SELECT c.* 
  FROM mmb17_categories as c 
  WHERE extension='com_jevents' 
  order by c.lft asc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	cat_idx	cat_idx	202	const	1	100.00	Using index condition; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT\components\com_jevents\libraries\commonfunctions.php:92
14	JEV_CommonFunctions::getCategoryData()	JROOT\components\com_jevents\libraries\commonfunctions.php:117
13	JEV_CommonFunctions::setColor()	JROOT\components\com_jevents\libraries\jeventcal.php:313
12	jEventCal->bgcolor()	JROOT\modules\mod_jevents_latest\tmpl\flat\latest.php:92
11	FlatModLatestView->displayLatestEvents()	JROOT\modules\mod_jevents_latest\mod_jevents_latest.php:48
10	include JROOT\modules\mod_jevents_latest\mod_jevents_latest.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.56 ms After last query: 5.87 ms Query memory: 0.040 MB Memory before query: 2.990 MB Rows returned: 1

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM mmb17_jevents_repetition as rpt
 
  INNER JOIN mmb17_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN mmb17_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN mmb17_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN mmb17_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,49)
 
  AND rpt.endrepeat >= '2019-07-21 00:00:00' 
  AND rpt.startrepeat <= '2019-08-20 02:12:11'
 
  AND (rpt.startrepeat >= '2019-07-21 00:00:00' OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
  ORDER BY rpt.startrepeat desc 
  LIMIT 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	NULL	ref	PRIMARY,stateidx	stateidx	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	ev	NULL	ref	PRIMARY,icsid,stateidx,evaccess	icsid	4	mmbios.icsf.ics_id	9	22.22	Using where
1	SIMPLE	rpt	NULL	ref	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid	4	mmbios.ev.ev_id	1	31.25	Using where
1	SIMPLE	det	NULL	eq_ref	PRIMARY,multiday	PRIMARY	4	mmbios.rpt.eventdetail_id	1	100.00	Using where
1	SIMPLE	rr	NULL	ref	eventid	eventid	4	mmbios.ev.ev_id	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.07 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.54 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT\components\com_jevents\libraries\dbmodel.php:2584
17	JEventsDBModel->_cachedlistIcalEvents()	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\Cache\Controller\CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT\components\com_jevents\libraries\dbmodel.php:1466
13	JEventsDBModel->listLatestIcalEvents()	JROOT\modules\mod_jevents_latest\tmpl\default\latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT\modules\mod_jevents_latest\tmpl\flat\latest.php:27
11	FlatModLatestView->displayLatestEvents()	JROOT\modules\mod_jevents_latest\mod_jevents_latest.php:48
10	include JROOT\modules\mod_jevents_latest\mod_jevents_latest.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.53 ms After last query: 5.51 ms Query memory: 0.040 MB Memory before query: 3.008 MB Rows returned: 1

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM mmb17_jevents_repetition as rpt
 
  INNER JOIN mmb17_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN mmb17_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN mmb17_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN mmb17_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,49)
 
  AND rpt.endrepeat >= '2019-07-21 00:00:00' 
  AND rpt.startrepeat <= '2019-08-20 02:12:11'
 
  AND (rpt.startrepeat <= '2019-07-21 00:00:00'OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
  ORDER BY rpt.startrepeat asc 
  LIMIT 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	NULL	ref	PRIMARY,stateidx	stateidx	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	ev	NULL	ref	PRIMARY,icsid,stateidx,evaccess	icsid	4	mmbios.icsf.ics_id	9	22.22	Using where
1	SIMPLE	rpt	NULL	ref	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid	4	mmbios.ev.ev_id	1	31.25	Using where
1	SIMPLE	det	NULL	eq_ref	PRIMARY,multiday	PRIMARY	4	mmbios.rpt.eventdetail_id	1	100.00	Using where
1	SIMPLE	rr	NULL	ref	eventid	eventid	4	mmbios.ev.ev_id	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.53 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT\components\com_jevents\libraries\dbmodel.php:2584
17	JEventsDBModel->_cachedlistIcalEvents()	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\Cache\Controller\CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT\components\com_jevents\libraries\dbmodel.php:1508
13	JEventsDBModel->listLatestIcalEvents()	JROOT\modules\mod_jevents_latest\tmpl\default\latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT\modules\mod_jevents_latest\tmpl\flat\latest.php:27
11	FlatModLatestView->displayLatestEvents()	JROOT\modules\mod_jevents_latest\mod_jevents_latest.php:48
10	include JROOT\modules\mod_jevents_latest\mod_jevents_latest.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

13 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

5 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created   , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn  
  FROM mmb17_jevents_repetition as rpt  
  INNER JOIN mmb17_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN mmb17_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN mmb17_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN mmb17_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

1 × SELECT `data`
 
  FROM `mmb17_session`

1 × SELECT `session_id`
 
  FROM `mmb17_session`

1 × SELECT id, rules
 
  FROM `mmb17_viewlevels

1 × SELECT b.id
 
  FROM mmb17_usergroups AS a
 
  LEFT JOIN mmb17_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

```
1 × SELECT *
 
  FROM mmb17_content
```

1 × SELECT `id`,`name`,`rules`,`parent_id`
 
  FROM `mmb17_assets`

1 × 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 `mmb17_categories` AS `c`

1 × SELECT c.id
 
  FROM mmb17_categories AS c

1 × SELECT c.* 
  FROM mmb17_categories as c

OTHER Tables:

1 × INSERT INTO `mmb17_session`
 (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
 ('4o9utbvfprss94mc951jj9uu8n', 1, '1566281531', 0, '', 0

1 × UPDATE `mmb17_extensions`
 
  SET `params` = '{\"mediaversion\":\"5fbde01d0c6aa691714d318405641c54\"}'

1 × SHOW FULL COLUMNS 
  FROM `mmb17_jev_users