Home

MASTER TEACHERS
With small class sizes

Average Exp. - 23 years

Recent teacher development through:

National Science Teachers Association

Alternative Education Resource Organization

Wright State University

National Outdoor Leadership School

Travel in China, India, Alaska, and Ireland

Find Out More...

EXPERIENCES MATTER!
Children engineer their own learning!

Learning for life:

Field trips, walks in the Glen and camping

Music, theater and live performances

School chickens and garden

Unicycles, swimming and skiing

Cooking and healthy snacks

Construction and experiments

Find Out More...

CULTURE OF KINDNESS
Empathy, caring and mutual trust

Learning together

Student mentors and swim partners

Collaborative work

Community outreach and helping others

Multi-aged classrooms

Sharing resources

Finding solutions to problems

Find Out More...

SCIENCE AND TECHNOLOGY
Students as scientists and inventors

Exploration leads to creation

Simple machines

Deconstruction

Biology, chemistry and geology

Programming, lasers and robotics

Movie making
Find Out More...
CREATIVITY AND ART
Avenues for self-expression and learning

Express yourself

Arts and music

Pottery kiln

Fall plays and spring musical

Artists in residence

Find Out More...

INCLUSION AND DIVERSITY
Empowering Community

Shared leadership

Students, parents and families

Teachers and staff

School manager

Unique governance

Alumni

Our wider community

CHILDREN LEARN FROM PLAY
Science supports it

The benefits of play

Motivated learning

Real life problem solving

Social skills development

Reasonable risk taking

Learning from failure

Find Out More...

OUTCOMES
"To infinity and beyond" - Buzz Lightyear

Blazing their own trails

Academic honors

Colleges and careers

Our graduates' published works

Find Out More...

Tab 1
Tab 2

Growing Up is a Journey

When parents bring a child into their family, it is a monumental event--one filled with hope, aspirations and maybe even some trepidation. How do you teach your child to live a joyful life? How do you prepare them to overcome the challenges that life brings? How do children create their own identities and develop critical social skills? This is where the Antioch School excels.

Children at Antioch School are met where they are. They walk their own learning path, as fast and as far as it may go, yet there are always encouraging friends and teachers nearby. Each person is trusted as a learner and valued as an important voice in the community, where we discover new roads together. We invite you to come with us on this journey of discovery.

Unicycles in Parades

Details: Written by Joel Smith

This past spring, graduate Anna Williamson decided to honor Bill Mullins during his tenure at Antioch School. She and Liz Griffin put together a wonderful video collage about the many wonderful and innovative things Bill Mullins did during his tenure as teacher at Antioch School.

Quite a few Antioch School children and graduates came to honor Bill, but many of the Older Group children were not at Bill’s celebration to see it. I thought they would love the history and to see the many things that have stayed the same at Antioch School over the span of 50 years, encompassing Bill’s career. They did indeed love it and had quite a few questions about some of the things we have done in the past, especially participating in parades.

“What? You mean they got to ride unicycles in parades?”

“Absolutely, often several parades a year.”

“Why don’t we do that now?”

“Well, because we stopped having enough children who wanted to participate. It seemed like soccer and other weekend activities interfered too much. It was sad when we stopped participating in parades.”

Educational Grit

Details: Written by Joel Smith

In the last few years I have seen several articles and interviews about the importance of grit in determining a child’s success later in life. Grit is in fashion at the moment as the missing ingredient for our country’s educational woes. If we only can find a way to bottle it and force feed it to every child, then America will be at the top of the world’s educational rankings and we can all rest easy.

The most recent interview I came across was on WBUR’s On Point radio show heard across the country on NPR radio stations as well as online at www.wbur.org/onpoint. The interview was with Angela Duckworth, professor of psychology at the University of Pennsylvania and author of Grit: The Power and Passion of Perseverance.

One of the things I enjoyed about this interview was that grit, while important, wasn’t portrayed as a perfect quality and that it does have a down side. For example, when grit crosses over into stubbornness, success goes down. You still need qualities like creativity, open-mindedness, vision, social skills, intelligence, etc. to be successful. A very interesting interview that you can listen to here.

A Day at the Antioch School

Details: Written by Joel Smith

A Day At The Antioch School from Carter Griffin on Vimeo.

Carter Griffin, 2014 Antioch School graduate, made this terrific short film giving the viewer a glimpse into a day at the Antioch School. Carter shot, directed and edited the film. Cheers to Carter for a job well done!

The Antioch School Movie

Details: Written by Matt Cline

The Antioch School from Cline Cinematography on Vimeo.

Matt Cline, from Cline Cinematography, put together this wonderful movie about The Antioch School. The movie was first shown at the 2014 Silent Auction. A big thanks goes out to Matt for his hard work at creating this movie as well as many of the photographs used on this site.

2018 Auction Gala

Details: Written by Joel Smith

2018 Auction Gala Show

Comedian Mo Amer To Headline Antioch School Fundraiser

***The AuctionGala has sold out!*** The Antioch School’s 2018 Auction Gala will feature a hilarious performance with internationally-celebrated comedian Mo Amer on Saturday, March 3, 6pm, at the Foundry Theatre at Antioch College 920 Corry St., Yellow Springs.

MO AMER’S comedy is exactly what the world needs right now! A pioneer of Arab-American standup, Mo has already cemented his stature as an original voice in comedy. Mo’s standup makes controversial news headlines personal.

The gala will include both silent and live auctions, gourmet hors d’oeuvres from Current Cuisine, open wine bar, and dessert. Live auction items in the past have included a one-week stay at St. Croix, US Virgin Islands; a “Day in the Life” documentary featuring the winner’s family, created by an Emmy Award-winning Yellow Springs-based filmmaker; and a private wine tasting with the area’s leading sommelier. The silent auction features over a hundred items, such as B&B overnight getaways, fine dining at area restaurants, tickets to theatrical and cultural events, fine art and jewelry from local artisans, and health and wellness sessions.

The Antioch School is the oldest democratic school in the country and an essential Yellow Springs institution. The Gala is the school’s largest fundraiser, with proceeds supporting the scholarship fund. Tickets are $50 and can be purchased by using the Paypal link at the end of this story or by calling the Antioch School at 937-767-7642.

Upcoming Events

Thu Sep 20 @12:30PM - 03:00PM
Swim and gym

Sun Sep 23 @12:00PM - 03:00PM
Anything On Wheels

Mon Sep 24 @ 8:30AM - 11:30AM
Forest Kindergarten

Thu Sep 27 @12:30PM - 03:00PM
Swim and gym

Mon Oct 01 @ 8:30AM - 11:30AM
Forest Kindergarten

Fri Oct 05 @12:00AM
Grandfriend's Day

Mon Oct 08 @ 8:30AM - 11:30AM
Forest Kindergarten

View Full Calendar

In The Spotlight

Enrolling At The Antioch School

Giving

Alumni

Active Learners Blog

Educational Insights Blog

Announcements

2018-2019 School Calendar Released

Quick Contact

If you have questions, would like more information or to schedule a school visit, please use the form below or call 9 3 7 . 7 6 7 . 7 6 4 2. Our address is 1160 Corry Street, P.O.Box 242, Yellow Springs, Ohio 45387.

Erin Ruddell
The Antioch School 1987-1994

Ben Green
The Antioch School 2000-2008

Ben is an honors student, studying biology at The Ohio State University.

Login

Register

You need to enable user registration from User Manager/Options in the backend of Joomla before this module will activate.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1537436630,
                "last": 1537436630,
                "now": 1537436630
            },
            "token": "jJB5RxBxV3IGBuo3cDqIm6x8MpcYjjxX"
        },
        "registry": {
            "jevents": {
                "moduleid258": {
                    "shownEventIds": [
                        [
                            "483",
                            "467",
                            "470",
                            "484",
                            "471",
                            "485",
                            "472"
                        ]
                    ],
                    "page": 0,
                    "firstEventDate": "2018-09-20 12:30:00",
                    "lastEventDate": "2018-10-08 08: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

Time

Memory

Time: 3.14 ms / 3.14 ms Memory: 0.059 MB / 0.39 MB Application: afterLoad

Time: 18.72 ms / 21.86 ms Memory: 1.004 MB / 1.39 MB Application: afterInitialise

Time: 8.65 ms / 30.50 ms Memory: 0.877 MB / 2.27 MB Application: afterRoute

Time: 0.18 ms / 30.68 ms Memory: 0.015 MB / 2.29 MB Application: beforeRenderComponent com_content

Time: 3.57 ms / 34.25 ms Memory: 0.158 MB / 2.44 MB Application: Before JAccess::preloadComponents (all components)

Time: 0.28 ms / 34.52 ms Memory: 0.069 MB / 2.51 MB Application: After JAccess::preloadComponents (all components)

Time: 0.03 ms / 34.55 ms Memory: 0.000 MB / 2.51 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Time: 0.24 ms / 34.78 ms Memory: 0.009 MB / 2.52 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Time: 20.93 ms / 55.71 ms Memory: 0.421 MB / 2.94 MB Application: afterRenderComponent com_content

Time: 0.66 ms / 56.38 ms Memory: 0.072 MB / 3.01 MB Application: afterDispatch

Time: 26.90 ms / 83.28 ms Memory: 0.604 MB / 3.62 MB Application: beforeRenderModule mod_s5_box (S5 Box)

Time: 0.37 ms / 83.65 ms Memory: 0.025 MB / 3.64 MB Application: beforeRenderModule mod_login (Login)

Time: 2.71 ms / 86.36 ms Memory: 0.087 MB / 3.73 MB Application: afterRenderModule mod_login (Login)

Time: 0.03 ms / 86.39 ms Memory: 0.000 MB / 3.73 MB Application: beforeRenderModule mod_s5_register (Register)

Time: 4.95 ms / 91.34 ms Memory: 0.101 MB / 3.83 MB Application: afterRenderModule mod_s5_register (Register)

Time: 0.27 ms / 91.61 ms Memory: 0.000 MB / 3.81 MB Application: afterRenderModule mod_s5_box (S5 Box)

Time: 0.64 ms / 92.25 ms Memory: 0.008 MB / 3.82 MB Application: beforeRenderModule mod_s5_quick_contact (Quick Contact)

Time: 1.89 ms / 94.14 ms Memory: 0.022 MB / 3.84 MB Application: afterRenderModule mod_s5_quick_contact (Quick Contact)

Time: 0.36 ms / 94.50 ms Memory: 0.028 MB / 3.87 MB Application: beforeRenderModule mod_jevents_latest (Upcoming Events)

Time: 4.55 ms / 99.05 ms Memory: 0.103 MB / 3.97 MB Application: Before JAccess::getAssetRules (id:129 name:com_jevents)

Time: 0.05 ms / 99.10 ms Memory: 0.007 MB / 3.98 MB Application: After JAccess::getAssetRules (id:129 name:com_jevents)

Time: 20.05 ms / 119.15 ms Memory: 0.561 MB / 4.54 MB Application: afterRenderModule mod_jevents_latest (Upcoming Events)

Time: 0.88 ms / 120.03 ms Memory: 0.000 MB / 4.42 MB Application: beforeRenderModule mod_s5_tabshow (S5 Tab Show)

Time: 0.71 ms / 120.75 ms Memory: 0.024 MB / 4.45 MB Application: beforeRenderModule mod_custom (Tab 1)

Time: 0.84 ms / 121.59 ms Memory: 0.023 MB / 4.47 MB Application: afterRenderModule mod_custom (Tab 1)

Time: 0.02 ms / 121.61 ms Memory: 0.000 MB / 4.47 MB Application: beforeRenderModule mod_custom (Tab 2)

Time: 0.23 ms / 121.85 ms Memory: 0.003 MB / 4.47 MB Application: afterRenderModule mod_custom (Tab 2)

Time: 0.27 ms / 122.12 ms Memory: 0.000 MB / 4.46 MB Application: afterRenderModule mod_s5_tabshow (S5 Tab Show)

Time: 0.06 ms / 122.18 ms Memory: 0.011 MB / 4.47 MB Application: beforeRenderModule mod_s5_image_and_content_fader (FRONT PAGE SLIDER S5 Image and Content Fader v3 class=hide_mobile)

Time: 1.54 ms / 123.73 ms Memory: 0.020 MB / 4.49 MB Application: afterRenderModule mod_s5_image_and_content_fader (FRONT PAGE SLIDER S5 Image and Content Fader v3 class=hide_mobile)

Time: 77.19 ms / 200.92 ms Memory: 0.726 MB / 5.22 MB Application: afterRender

Database queries total: 16.47 ms

Memory Usage

Database Queries

35 Queries Logged 16.47 ms

2 duplicate found!

2 duplicates: #19 #20

Query Time: 0.16 ms Query memory: 0.010 MB Memory before query: 0.706 MB Rows returned: 0

SELECT `data`

  FROM `ypscx_session`

  WHERE `session_id` = 'cd627349098b923674659a6b4d5aa25d'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
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:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.17 ms After last query: 0.48 ms Query memory: 0.005 MB Memory before query: 0.724 MB Rows returned: 0

SELECT `session_id`

  FROM `ypscx_session`

  WHERE `session_id` = 'cd627349098b923674659a6b4d5aa25d' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.17 ms After last query: 0.06 ms Query memory: 0.005 MB Memory before query: 0.731 MB

INSERT INTO `ypscx_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('cd627349098b923674659a6b4d5aa25d', 1, '1537436630', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `ypscx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('cd627349098b923674659a6b4d5aa25d', 1, '1537436630', 0, '', 0)

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.04 ms After last query: 2.15 ms Query memory: 0.007 MB Memory before query: 0.891 MB Rows returned: 3

SELECT id, rules

  FROM `ypscx_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.04 ms After last query: 0.06 ms Query memory: 0.007 MB Memory before query: 0.905 MB Rows returned: 1

SELECT b.id

  FROM ypscx_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 4.03 ms Query memory: 0.006 MB Memory before query: 1.220 MB Rows returned: 1

SELECT `enabled`

  FROM `ypscx_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:79
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:252
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 9.37 ms Query memory: 0.009 MB Memory before query: 2.108 MB

UPDATE `ypscx_extensions`

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.06 ms
updating	0.08 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.12 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:460
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.08 ms After last query: 6.71 ms Query memory: 0.014 MB Memory before query: 2.449 MB Rows returned: 39

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

  FROM `ypscx_assets`

  WHERE `name` IN ('root.1','com_acymailing','com_admin','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_easyappointment','com_fields','com_finder','com_installer','com_jevents','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sigpro','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_assets	range	idx_asset_name	idx_asset_name	202	NULL	40	100.00	Using index condition

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
20	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
19	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
18	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
17	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
16	JUser->authorise()	JROOT/components/com_content/models/articles.php:113
15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
14	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:434
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 4.13 ms After last query: 0.88 ms Query memory: 0.012 MB Memory before query: 2.544 MB Rows returned: 5

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM ypscx_content AS a

  LEFT JOIN ypscx_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ypscx_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ypscx_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN ypscx_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN ypscx_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-09-20 09:43:50') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-09-20 09:43:50')

  ORDER BY c.lft,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 6

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	1	const	9	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.created_by	1	100.00	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.modified_by	1	100.00	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	wikipeds_antioch.a.catid	1	100.00	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.c.parent_id	1	100.00	Using where
1	SIMPLE	v	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.18 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.46 ms
init	0.08 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.11 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.36 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	1.27 ms
Creating sort index	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.03 ms
end	0.00 ms
removing tmp table	0.27 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
13	ContentModelFeatured->getItems()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 1.13 ms Query memory: 0.011 MB Memory before query: 2.697 MB Rows returned: 1

SELECT COUNT(*)

  FROM ypscx_content AS a

  LEFT JOIN ypscx_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ypscx_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ypscx_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN ypscx_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN ypscx_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-09-20 09:43:50') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-09-20 09:43:50')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	1	const	9	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	wikipeds_antioch.a.catid	1	100.00	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.c.parent_id	1	100.00	Using where; Using index
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.id	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
15	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
14	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
13	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:56
11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.07 ms After last query: 2.81 ms Query memory: 0.014 MB Memory before query: 2.751 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 ypscx_categories as c

  LEFT JOIN ypscx_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=31

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	51	33.33	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
19	JCategories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/legacy/model/list.php:132
17	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.06 ms After last query: 0.12 ms Query memory: 0.013 MB Memory before query: 2.773 MB Rows returned: 0

SELECT 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

  FROM ypscx_fields AS a

  LEFT JOIN `ypscx_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN ypscx_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN ypscx_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN ypscx_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN ypscx_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `ypscx_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 (31,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	wikipeds_antioch.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.id	1	100.00	Using where; Using index

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
18	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
17	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.04 ms After last query: 2.82 ms Query memory: 0.011 MB Memory before query: 2.873 MB Rows returned: 1

SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid

  FROM `ypscx_contact_details` AS `contact`

  WHERE contact.published = 1 
  AND contact.user_id = 615

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	contact	ref	idx_state	idx_state	1	const	2	100.00	Using where

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
16	JDatabaseDriver->loadObject()	JROOT/plugins/content/contact/contact.php:108
15	PlgContentContact->getContactId()	JROOT/plugins/content/contact/contact.php:60
14	PlgContentContact->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.08 ms After last query: 0.25 ms Query memory: 0.014 MB Memory before query: 2.894 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 ypscx_categories as c

  LEFT JOIN ypscx_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=49

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	51	33.33	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
19	JCategories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/legacy/model/list.php:132
17	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.06 ms After last query: 0.13 ms Query memory: 0.013 MB Memory before query: 2.909 MB Rows returned: 0

SELECT 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

  FROM ypscx_fields AS a

  LEFT JOIN `ypscx_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN ypscx_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN ypscx_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN ypscx_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN ypscx_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `ypscx_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 (49,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	wikipeds_antioch.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.id	1	100.00	Using where; Using index

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
18	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
17	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 10.54 ms Query memory: 0.008 MB Memory before query: 3.044 MB Rows returned: 1

SELECT * 
  FROM ypscx_template_styles 
  WHERE template = 'oasis';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_template_styles	ref	idx_template	idx_template	202	const	1	100.00	Using index condition

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
10	JDatabaseDriver->loadAssocList()	JROOT/templates/oasis/vertex/parameters.php:19
9	getTemplateName()	JROOT/templates/oasis/vertex/parameters.php:167
8	require_once JROOT/templates/oasis/vertex/parameters.php	JROOT/templates/oasis/index.php:21
7	require JROOT/templates/oasis/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.05 ms After last query: 0.06 ms Query memory: 0.008 MB Memory before query: 3.055 MB Rows returned: 1

SELECT * 
  FROM ypscx_menu 
  WHERE template_style_id IN (13) 
  AND alias = 'home'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_menu	ref	idx_alias	idx_alias	402	const	1	100.00	Using where

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
10	JDatabaseDriver->loadAssocList()	JROOT/templates/oasis/vertex/parameters.php:40
9	getTemplateName()	JROOT/templates/oasis/vertex/parameters.php:167
8	require_once JROOT/templates/oasis/vertex/parameters.php	JROOT/templates/oasis/index.php:21
7	require JROOT/templates/oasis/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.67 ms After last query: 6.28 ms Query memory: 0.010 MB Memory before query: 3.171 MB Rows returned: 30

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM ypscx_modules AS m

  LEFT JOIN ypscx_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN ypscx_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 <= '2018-09-20 09:43:50') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-09-20 09:43:50') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	107	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	wikipeds_antioch.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	wikipeds_antioch.m.id	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
13	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
12	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
9	JDocumentHtml->countModules()	JROOT/templates/oasis/vertex/module_calcs.php:15
8	require_once JROOT/templates/oasis/vertex/module_calcs.php	JROOT/templates/oasis/index.php:23
7	require JROOT/templates/oasis/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.07 ms After last query: 2.32 ms Query memory: 0.009 MB Memory before query: 3.208 MB Rows returned: 0

Duplicate queries: #20

SELECT menutype  
  FROM  ypscx_menu 
  WHERE language = 'en-GB' 
  AND home = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_menu	ref	idx_language	idx_language	28	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php:139
10	include JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php:85
9	require JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php	JROOT/templates/oasis/vertex/includes/vertex_includes_top.php:12
8	require_once JROOT/templates/oasis/vertex/includes/vertex_includes_top.php	JROOT/templates/oasis/index.php:593
7	require JROOT/templates/oasis/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.07 ms After last query: 8.24 ms Query memory: 0.007 MB Memory before query: 3.587 MB Rows returned: 0

Duplicate queries: #19

SELECT menutype  
  FROM  ypscx_menu 
  WHERE language = 'en-GB' 
  AND home = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ypscx_menu	ref	idx_language	idx_language	28	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
9	JDatabaseDriver->loadResult()	JROOT/templates/oasis/vertex/s5flex_menu/default.php:45
8	include JROOT/templates/oasis/vertex/s5flex_menu/default.php	JROOT/templates/oasis/index.php:612
7	require JROOT/templates/oasis/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.66 ms After last query: 25.36 ms Query memory: 0.016 MB Memory before query: 4.018 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `ypscx_jev_users`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.02 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.02 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.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.33 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
23	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
22	JTable->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:69
21	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:2205
20	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1098
19	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:50
18	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
17	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
16	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:908
15	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
14	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:27
13	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
12	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:601
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.08 ms After last query: 1.07 ms Query memory: 0.016 MB Memory before query: 4.081 MB Rows returned: 13

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 ypscx_categories as c

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL	cat_idx,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	51	25.49	Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
23	JCategories->_load()	JROOT/components/com_jevents/helpers/category.php:47
22	JEventsCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
21	JCategories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:90
20	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
19	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
18	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
17	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
16	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:908
15	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
14	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:27
13	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
12	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:601
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.07 ms After last query: 0.26 ms Query memory: 0.014 MB Memory before query: 4.160 MB Rows returned: 7

SELECT c.id

  FROM ypscx_categories AS c

  WHERE c.access   IN (1,1)
 
  AND c.published = 1
  
  AND c.language in ('en-GB','*')
 
  AND c.extension = 'com_jevents'
 
  AND ((c.lft>=3 
  AND c.rgt<=4 ) OR (c.lft>=5 
  AND c.rgt<=6 ) OR (c.lft>=9 
  AND c.rgt<=10 ) OR (c.lft>=13 
  AND c.rgt<=14 ) OR (c.lft>=17 
  AND c.rgt<=18 ) OR (c.lft>=21 
  AND c.rgt<=22 ) OR (c.lft>=25 
  AND c.rgt<=26 ))

  ORDER BY c.lft asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ref	cat_idx,idx_access,idx_left_right,idx_language	cat_idx	203	const,const	12	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
21	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:172
20	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
19	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
18	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
17	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
16	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:908
15	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
14	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:27
13	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
12	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:601
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.46 ms After last query: 0.66 ms Query memory: 0.013 MB Memory before query: 4.199 MB Rows returned: 7

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids
 , 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 ypscx_jevents_repetition as rpt
 
  INNER JOIN ypscx_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN ypscx_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN ypscx_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN ypscx_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid 
 
  LEFT JOIN 
 ypscx_jevents_catmap as catmap 
  ON catmap.evid = rpt.eventid 
 
  LEFT JOIN 
 ypscx_categories AS catmapcat 
  ON catmap.catid = catmapcat.id
 
  WHERE 1 
 
  AND rpt.endrepeat >= '2018-09-20 05:43:50' 
  AND rpt.startrepeat <= '2018-11-19 23:59:59'
 
  AND (rpt.startrepeat >= '2018-09-20 05:43:50' OR  det.multiday=1) 
  AND ev.state=1 
  AND  catmap.catid IN(-1,27,37,28,29,38,39,40)
 
  AND ev.access  IN (1,1)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
						
  ORDER BY rpt.startrepeat ASC 
  LIMIT 7

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	8	NULL	42	100.00	Using index condition; Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	wikipeds_antioch.rpt.eventid	1	100.00	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	wikipeds_antioch.rpt.eventid	1	100.00	NULL
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	wikipeds_antioch.rpt.eventdetail_id	1	100.00	Using where
1	SIMPLE	catmap	ref	key_event_category,key_evid	key_event_category	4	wikipeds_antioch.rpt.eventid	1	100.00	Using where; Using index
1	SIMPLE	catmapcat	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.catmap.catid	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2569
17	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
16	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1408
15	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
14	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:27
13	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
12	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:601
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.96 ms After last query: 1.85 ms Query memory: 0.013 MB Memory before query: 4.404 MB Rows returned: 0

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids
 , 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 ypscx_jevents_repetition as rpt
 
  INNER JOIN ypscx_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN ypscx_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN ypscx_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN ypscx_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid 
 
  LEFT JOIN 
 ypscx_jevents_catmap as catmap 
  ON catmap.evid = rpt.eventid 
 
  LEFT JOIN 
 ypscx_categories AS catmapcat 
  ON catmap.catid = catmapcat.id
 
  WHERE 1 
 
  AND rpt.endrepeat >= '2018-09-20 05:43:50' 
  AND rpt.startrepeat <= '2018-09-20 05:43:50'
 
  AND (rpt.startrepeat >= '2018-09-20 05:43:50' OR  det.multiday=1) 
  AND ev.state=1 
  AND  catmap.catid IN(-1,27,37,28,29,38,39,40)
 
  AND ev.access  IN (1,1)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
  ORDER BY rpt.startrepeat desc 
  LIMIT 7

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	8	NULL	42	100.00	Using index condition; Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	wikipeds_antioch.rpt.eventid	1	100.00	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	wikipeds_antioch.rpt.eventid	1	100.00	NULL
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	wikipeds_antioch.rpt.eventdetail_id	1	100.00	Using where
1	SIMPLE	catmap	ref	key_event_category,key_evid	key_event_category	4	wikipeds_antioch.rpt.eventid	1	100.00	Using where; Using index
1	SIMPLE	catmapcat	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.catmap.catid	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2569
17	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
16	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1451
15	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
14	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:27
13	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
12	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:601
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->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: 0.11 ms Query memory: 0.013 MB Memory before query: 4.418 MB Rows returned: 0

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids
 , 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 ypscx_jevents_repetition as rpt
 
  INNER JOIN ypscx_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN ypscx_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN ypscx_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN ypscx_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid 
 
  LEFT JOIN 
 ypscx_jevents_catmap as catmap 
  ON catmap.evid = rpt.eventid 
 
  LEFT JOIN 
 ypscx_categories AS catmapcat 
  ON catmap.catid = catmapcat.id
 
  WHERE 1 
 
  AND rpt.endrepeat >= '2018-09-20 05:43:50' 
  AND rpt.startrepeat <= '2018-09-20 05:43:50'
 
  AND (rpt.startrepeat <= '2018-09-20 05:43:50'OR  det.multiday=1) 
  AND ev.state=1 
  AND  catmap.catid IN(-1,27,37,28,29,38,39,40)
 
  AND ev.access  IN (1,1)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
  ORDER BY rpt.startrepeat asc 
  LIMIT 7

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	8	NULL	42	100.00	Using index condition; Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	wikipeds_antioch.rpt.eventid	1	100.00	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	wikipeds_antioch.rpt.eventid	1	100.00	NULL
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	wikipeds_antioch.rpt.eventdetail_id	1	100.00	Using where
1	SIMPLE	catmap	ref	key_event_category,key_evid	key_event_category	4	wikipeds_antioch.rpt.eventid	1	100.00	Using where; Using index
1	SIMPLE	catmapcat	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.catmap.catid	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2569
17	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
16	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1493
15	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
14	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:27
13	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
12	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:601
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.07 ms After last query: 2.26 ms Query memory: 0.012 MB Memory before query: 4.489 MB Rows returned: 12

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

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/commonfunctions.php:92
16	JEV_CommonFunctions::getCategoryData()	JROOT/components/com_jevents/libraries/commonfunctions.php:117
15	JEV_CommonFunctions::setColor()	JROOT/components/com_jevents/libraries/jeventcal.php:313
14	jEventCal->bgcolor()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:92
13	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
12	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/cms/module/helper.php:198
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:601
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.09 ms After last query: 5.02 ms Query memory: 0.017 MB Memory before query: 4.470 MB Rows returned: 0

SELECT 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

  FROM ypscx_fields AS a

  LEFT JOIN `ypscx_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN ypscx_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN ypscx_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN ypscx_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN ypscx_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `ypscx_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'mod_custom.content' 
  AND (fc.category_id IS NULL OR fc.category_id IN (49,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	wikipeds_antioch.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.id	1	100.00	Using where; Using index

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
23	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
22	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
21	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
19	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
16	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
15	JHtml::call()	JROOT/libraries/cms/html/html.php:105
14	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
13	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
12	JModuleHelper::renderModule()	JROOT/templates/oasis/html/mod_s5_tabshow/default.php:247
11	require JROOT/templates/oasis/html/mod_s5_tabshow/default.php	JROOT/modules/mod_s5_tabshow/mod_s5_tabshow.php:40
10	include JROOT/modules/mod_s5_tabshow/mod_s5_tabshow.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 75.80 ms Query memory: 0.009 MB Memory before query: 5.018 MB Rows returned: 160

SELECT * 
  FROM ypscx_acymailing_config

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
11	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
10	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1371
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:21
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:145
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.08 ms After last query: 0.80 ms Query memory: 0.011 MB Memory before query: 5.134 MB Rows returned: 1

SELECT `alias`

  FROM `ypscx_content`

  WHERE id = '114'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
15	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.06 ms After last query: 0.14 ms Query memory: 0.012 MB Memory before query: 5.148 MB Rows returned: 0

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 ypscx_categories as c

  LEFT JOIN ypscx_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=114

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
16	JCategories->get()	JROOT/components/com_content/router.php:72
15	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:121
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.08 ms After last query: 0.26 ms Query memory: 0.011 MB Memory before query: 5.268 MB Rows returned: 1

SELECT `alias`

  FROM `ypscx_content`

  WHERE id = '113'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
15	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.06 ms After last query: 0.12 ms Query memory: 0.013 MB Memory before query: 5.288 MB Rows returned: 0

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 ypscx_categories as c

  LEFT JOIN ypscx_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=113

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
16	JCategories->get()	JROOT/components/com_content/router.php:72
15	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:121
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.05 ms After last query: 0.23 ms Query memory: 0.011 MB Memory before query: 5.300 MB Rows returned: 1

SELECT `alias`

  FROM `ypscx_content`

  WHERE id = '115'

Explain

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

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
15	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.07 ms After last query: 0.11 ms Query memory: 0.012 MB Memory before query: 5.314 MB Rows returned: 0

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 ypscx_categories as c

  LEFT JOIN ypscx_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=115

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
16	JCategories->get()	JROOT/components/com_content/router.php:72
15	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:121
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

5 × 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 ypscx_categories as c 
  LEFT JOIN ypscx_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

3 × SELECT `alias` 
  FROM `ypscx_content`

3 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , GROUP_CONCAT(DISTINCT catmap.catid SEPARATOR ',') as catids  , 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 ypscx_jevents_repetition as rpt  
  INNER JOIN ypscx_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN ypscx_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN ypscx_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN ypscx_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid   
  LEFT JOIN   ypscx_jevents_catmap as catmap 
  ON catmap.evid = rpt.eventid   
  LEFT JOIN   ypscx_categories AS catmapcat 
  ON catmap.catid = catmapcat.id

3 × SELECT 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 
  FROM ypscx_fields AS a 
  LEFT JOIN `ypscx_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ypscx_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ypscx_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ypscx_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ypscx_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `ypscx_fields_categories` AS fc 
  ON fc.field_id = a.id

2 × SELECT menutype  
  FROM  ypscx_menu

```
1 × SELECT * 
  FROM ypscx_menu
```

1 × SELECT * 
  FROM ypscx_acymailing_confi

1 × SELECT c.* 
  FROM ypscx_categories as c

1 × SELECT c.id 
  FROM ypscx_categories AS c

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 ypscx_categories as c

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM ypscx_modules AS m 
  LEFT JOIN ypscx_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN ypscx_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `data` 
  FROM `ypscx_session`

1 × SELECT * 
  FROM ypscx_template_styles

1 × SELECT `session_id` 
  FROM `ypscx_session`

1 × SELECT COUNT(*) 
  FROM ypscx_content AS a 
  LEFT JOIN ypscx_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ypscx_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ypscx_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ypscx_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ypscx_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,         COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM ypscx_content AS a 
  LEFT JOIN ypscx_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ypscx_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ypscx_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ypscx_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ypscx_content_rating AS v 
  ON a.id = v.content_id

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

1 × SELECT `enabled` 
  FROM `ypscx_extensions`

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

1 × SELECT id, rules 
  FROM `ypscx_viewlevels

1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid 
  FROM `ypscx_contact_details` AS `contact`

OTHER Tables:

1 × INSERT INTO `ypscx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('cd627349098b923674659a6b4d5aa25d', 1, '1537436630', 0, '', 0

1 × UPDATE `ypscx_extensions` 
  SET `params` = '{\"mediaversion\":\"5f6ece3c017713854bdaa5f86102614e\"}'

1 × SHOW FULL COLUMNS 
  FROM `ypscx_jev_users

"The mind is not a vessel to be filled, but a fire to be kindled."

Over 90 years of no grades, tests, or homework

Learn the secret of the unicycle!

MASTER TEACHERS

Average Exp. - 23 years

EXPERIENCES MATTER!

Learning for life:

CULTURE OF KINDNESS

Learning together

SCIENCE AND TECHNOLOGY

Exploration leads to creation

CREATIVITY AND ART

Express yourself

INCLUSION AND DIVERSITY

Shared leadership

CHILDREN LEARN FROM PLAY

The benefits of play

OUTCOMES

Blazing their own trails

Growing Up is a Journey

Upcoming Events

In The Spotlight

Announcements

Quick Contact

Erin RuddellThe Antioch School 1987-1994

Ben GreenThe Antioch School 2000-2008

Login

Register

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

35 Queries Logged 16.47 ms

2 duplicate found!

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Erin Ruddell
The Antioch School 1987-1994

Ben Green
The Antioch School 2000-2008