Easy Blog

Important Sections

Uni5 Community Blog

There is only one Truth and a single path to Truth, only views are different.

Mission of Sakthi Foundation is to unify everyone by helping to understand that their views are only different levels of expressions of one single concept (Energy). This unification or unity in diversity is Peace or love or happiness, which is established only by embracing our view with others view and contemplate why the views differ.

Please discuss all topics in this blog with the above intention. We can discuss here Atheism, all Religions, Spirituality, Science in connection to body, mind, intelligence, Awareness and Consciousness.

To achieve this we are giving you a template where you can identify your views and others view. This will guaranteed Unity, peace, love and happiness. With this Universal template, all difference of opinion between religions, science will melt away like heat melting all different ice cubes to pure water.

Five templates that will unify all our thoughts.
Check if our view is based on the knowledge we got from our
1. physical senses
2. Our personal strong likes and dislikes'
3. A logical pattern
4. connection to our Self
5. That is universal to all at times.

We will find that every view of us is at one of the five levels. The higher level is that which stays for longer and universal. This view will bring peace and happiness in our lives.

Uni5 Happy Mind

Subcategories from this category:

Parenting

Exposing Children to Culture in Early Days

Wednesday, 28 September 2016

sakthi

Parenting

My early days and Navarathry...

When I was at the age of 2.5 I can see row of dolls being celebrities at the time of Navarathry in my Virudhunagar home.[1974]

I saw ladies, small girls coming daily to home and taking some thing from my mother and grandmother.

I used to sit very near to the lower step in Golu. I love dolls.

My father used to get dolls where ever he went.

My mother made her family to celebrate Golu at her 3 years it seems.[Now she is 73]

She says that she had wonderful dolls bought by her maternal uncles.

She says that she was inspired by many temple Navarathry festivals as she got opportunity to see them along with her uncle who was a temple executive.

***

After Golu [arrangement of dolls] I never allow my parents to dismantle the golu.

My grandmother understood my attachment to dolls and left for some days.

But I can see within a week slowly dolls will say bye and get into their cartons.

***

Wooden temple chariot from Madurai

Clay Skandha from local market

Shiva lingam with Nandhi from Thirunelveli

Wooden long bus from Kanyakumari

Wooden horse from grand father

Big baby doll from Madras

This was the earliest history about places through dolls I got from my parents.

Once when I went to Palladam [near Thirupur] my mother found her most favorite Buddha from a box in her mother’s home and I brought it to Virudhunagar.

During Navarathry days my mother also takes me to the local Mari amman temple and Veil ukandha amman temple where decorations inspired me. I can remember how the prakaram canal around the sanctums being filled with water and floated with lilies and lotuses. My mother used to do the same with a big plate. I used to put y BINAKA PASTE ANIMAL turtle and fishes inside that. My early science got initiated through Golu.

I can remember during Navarathry days there will be many celebrations lie fancy dress etc. Schools will give leave. Today most of the schools does not give leave.

My mother used to place her craft items, needle work and now she lost all these skills because of TV.

My father used to place few of his portraits near the golu.

Pink color sponge rose garland adorns the steps.

Evening we invite all neighbors and I admire the very huge paper Mache dolls in opposite Chidhambaram chittiyar thaatha [We call him like that] house. My dreams have those huge dolls daily. I can still remember the 5 feet bluish Krishna with a big cow.

When we left Virudhunagar thaatha presented a same Krishna in small size.

Today at the age of 44 I am still inspired with Navarathry, Golu, UNI5 center - village golu setting, purchase in various places in Madras, writing articles, talks etc

When I did my post-graduation in Madurai I kept Golu in our room in Madurai Kamarajar University with Dr.Pradheep’s big stout biochemistry books. Group of our friends do poojas, discourses daily. Pradheep makes sundal and payasam.

All these are just because of my parents, grandparents’ attitude towards accepting and promoting the culture and tradition of the nation. My parents have never forced me to do it. But they never said ''NO'' for my cultural activities. From birth till 3.5 years I was aware with absorbent mind and imbibed all these. As my mother continued this tradition since her early child hood days today many of our friends, families are taking up this culture.

Today I do not have any old doll but our house dolls are in others Golu.

This article will support the nature of early absorbent mind's nature which imbibes and constructs the units of knowledge and personality through strong tradition and culture of the place where a child lives.

With regards.,

Dr.Madeswaran.M

28.9.2016

4320 Hits

Facebook Twitter LinkedIn Pinterest

4320 Hits

cocoon to adult butterfly

Tuesday, 21 July 2015

Dr.Madeswaran

Uni5 Happy Mind Parenting Uni5 Self Awareness

Adult butterfly out of cocoon…When Arundhati invited me last week for her project show, I have decided that I am going to learn something through her work.When she said that her work is based on learning skills, learning equipment I got much excited.Today – 17.4.2015 I saw her evolution across the time.She is now prepared for serving children with learning difficulties and children below 6 years old who need more visual presentations and experiences.Her creative ideas in the area of language [Opposites in visual form], India’s physical wall hanger made me admire her imagination. The way she has made to trace the rivers just by passing the blue thread into small loops shows her Montessori backup of early ages.Parts of a flower – material was excellent and I feel in future Arundhati can do more such tools for children with special needs and learning challenges.Identifying each Indian state with various visual designs has been suggested with few additions by me and she has accepted.I asked, ‘’what is your main aim in designing these?’’She says, ‘’I has designed few learning models to children with learning difficulties. How I would have felt easy I have expressed. ‘’This is what a teacher must know today about children.I feel proud to be her teacher and through her today I am taking few great visual ideas to my rural Uni5 schools and I have requested her to make the models for all my schools.I wish her college tutors for giving her the space and freedom to choose the topic.I appreciate her mother and father for behind her creation.I am proud as a teacher to see her real evolution!With regards and blessings,Dr.M.MadeswaranMadras, 17.4.2015

4954 Hits

Facebook Twitter LinkedIn Pinterest

4954 Hits

Uni5 infancy center diary - July

Tuesday, 21 July 2015

Dr.Madeswaran

Uni5 Happy Mind Parenting Uni5 Self Awareness

21.7.2015

Coimbatore

Ms.Priya and Pranav visited for one hour and observed the center. They have given positive report about the staff team and happenings. Pranav gave a crisp presentation about mouth care and brushing teeth for 2 times based on his projects to very young children. Priya observed songs, story and continents as Uni5 presentation. She said that a real object can also be presented in BMIAC [Body mind intelligence awareness and conscious] levels. But for this the new staff team needs to be trained well and it also takes time. Just now they have started their work.

Pungeri

Children are able to follow all ground rules and assist each other. Devi Pooja was performed. More orderliness can be observed. No Uni5 concept. Why?

4938 Hits

Facebook Twitter LinkedIn Pinterest

4938 Hits

Uni5 approach of children in home and school - 2

Tuesday, 21 July 2015

Dr.Madeswaran

Parenting Uni5 Self Awareness

Sakthi Foundation

HOW TO HANDLE CHILDREN ? – Part 2

[Parent circle articles]

6151 Hits

Facebook Twitter LinkedIn Pinterest

6151 Hits

Uni5 Aproach for Assisting Children at home and school - 1

Tuesday, 21 July 2015

Dr.Madeswaran

Uni5 Happy Mind Parenting

Sakthi Foundation

How to assist my child?

[Various questions about child, parents, teachers of various age groups across the globe]

3850 Hits

Facebook Twitter LinkedIn Pinterest

3850 Hits

Uni5 Parenting Home

Monday, 20 July 2015

sakthi

Uni5 Happy Mind Parenting

The Uni5 suggestions helps parents to know about the five needs of a child. Catering to these needs at the proper time will ensure the development of a child with strong physical, emotional, intellectual, awareness and a socially responsible being.

Details in http://www.uni5.co/index.php/en/uni5-education-system-ues-2/five-needs-of-a-child.html

2737 Hits

Facebook Twitter LinkedIn Pinterest

2737 Hits

Uni5 Parenting - Five Needs of a Child

Sunday, 19 July 2015

sakthi

Uni5 Happy Mind Parenting

Details in http://www.uni5.co/index.php/en/uni5-education-system-ues-2/five-needs-of-a-child.html

Read the explantion Notes from Dr.Madeshwaran circulated to parents in different times below this photo.

Till the age of 6..... [be aware dear parents!]

2416 Hits

Facebook Twitter LinkedIn Pinterest

2416 Hits

Relationships

Sunday, 27 October 2013

sakthi

Uni5 Happy Mind

Relationships

Five Personalities

Maya

I am married to myself with me as our only kid

We can let our negatives out through our breathe!

Five stages of Happiness

Celebrating special days

Tragedy of life

3892 Hits

Facebook Twitter LinkedIn Pinterest

3892 Hits

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1686325087,
                "last": 1686325087,
                "now": 1686325087
            },
            "token": "zoh3OvXkbYaJXPAAN3grcVQJ0ORImtRz"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    },
    "__easyblog": {
        "site": {
            "messages": null
        }
    }
}

Profile Information

Time

Memory

Time: 6.83 ms / 6.83 ms Memory: 2.484 MB / 2.85 MB Application: afterLoad

Time: 75.86 ms / 82.69 ms Memory: 16.269 MB / 19.12 MB Application: afterInitialise

Time: 22.34 ms / 105.03 ms Memory: 1.790 MB / 20.91 MB Application: Before Access::preloadComponents (all components)

Time: 1.81 ms / 106.84 ms Memory: 0.075 MB / 20.99 MB Application: After Access::preloadComponents (all components)

Time: 0.06 ms / 106.90 ms Memory: -0.004 MB / 20.98 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Time: 0.55 ms / 107.45 ms Memory: 0.010 MB / 20.99 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Time: 12.09 ms / 119.54 ms Memory: 1.277 MB / 22.27 MB Application: afterRoute

Time: 0.70 ms / 120.24 ms Memory: 0.086 MB / 22.36 MB Application: beforeRenderComponent com_easyblog

Time: 4.32 ms / 124.56 ms Memory: 0.616 MB / 22.97 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.09 ms / 124.65 ms Memory: 0.008 MB / 22.98 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 878.44 ms / 1003.09 ms Memory: 19.015 MB / 42.00 MB Application: afterRenderComponent com_easyblog

Time: 1.23 ms / 1004.32 ms Memory: 0.010 MB / 42.01 MB Application: afterDispatch

Time: 1.61 ms / 1005.94 ms Memory: 0.059 MB / 42.07 MB Application: beforeRenderModule mod_banners (Shop)

Time: 3.89 ms / 1009.82 ms Memory: 0.043 MB / 42.11 MB Application: afterRenderModule mod_banners (Shop)

Time: 0.08 ms / 1009.90 ms Memory: -0.005 MB / 42.10 MB Application: beforeRenderModule mod_banners (Book Store)

Time: 1.64 ms / 1011.54 ms Memory: 0.027 MB / 42.13 MB Application: afterRenderModule mod_banners (Book Store)

Time: 0.09 ms / 1011.63 ms Memory: -0.003 MB / 42.13 MB Application: beforeRenderModule mod_banners (Contribute)

Time: 1.53 ms / 1013.15 ms Memory: 0.029 MB / 42.16 MB Application: afterRenderModule mod_banners (Contribute)

Time: 0.09 ms / 1013.24 ms Memory: -0.002 MB / 42.15 MB Application: beforeRenderModule mod_menu (Easy Blog)

Time: 3.02 ms / 1016.27 ms Memory: 0.049 MB / 42.20 MB Application: afterRenderModule mod_menu (Easy Blog)

Time: 0.04 ms / 1016.31 ms Memory: -0.005 MB / 42.20 MB Application: beforeRenderModule mod_menu (Important Sections)

Time: 1.69 ms / 1018.00 ms Memory: 0.683 MB / 42.88 MB Application: afterRenderModule mod_menu (Important Sections)

Time: 0.08 ms / 1018.08 ms Memory: -0.000 MB / 42.88 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 2.42 ms / 1020.50 ms Memory: -0.050 MB / 42.83 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.14 ms / 1020.64 ms Memory: -0.001 MB / 42.83 MB Application: beforeRenderModule mod_menu (Top)

Time: 6.48 ms / 1027.11 ms Memory: 0.313 MB / 43.14 MB Application: afterRenderModule mod_menu (Top)

Time: 634.03 ms / 1661.15 ms Memory: 4.942 MB / 48.09 MB Application: afterRender

Database queries total: 89.34 ms

Memory Usage

Database Queries

87 Queries Logged 89.34 ms

10 duplicate found!

7 duplicates: #29 #62 #65 #67 #70 #72 #75

3 duplicates: #77 #80 #83

Query Time: 0.36 ms Query memory: 0.023 MB Memory before query: 4.533 MB Rows returned: 0

SELECT `data`

  FROM `sakthi_session`

  WHERE `session_id` = X'3261303132363131343632313932373263623033363066666332623337653738'

Explain

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

Profile

Error
The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.18 ms After last query: 0.57 ms Query memory: 0.020 MB Memory before query: 4.849 MB Rows returned: 0

SELECT `session_id`

  FROM `sakthi_session`

  WHERE `session_id` = X'3261303132363131343632313932373263623033363066666332623337653738' 
  LIMIT 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.56 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 4.854 MB

INSERT INTO `sakthi_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3261303132363131343632313932373263623033363066666332623337653738', 1, 1686325087, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `sakthi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3261303132363131343632313932373263623033363066666332623337653738', 1, 1686325087, 0, '', 0)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.71 ms After last query: 1.11 ms Query memory: 0.042 MB Memory before query: 4.890 MB Rows returned: 60

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `sakthi_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_extensions	NULL	ref	extension	extension	82	const	71	1.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.21 ms After last query: 1.15 ms Query memory: 0.021 MB Memory before query: 5.245 MB Rows returned: 5

SELECT id, rules

  FROM `sakthi_viewlevels`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 5.257 MB Rows returned: 1

SELECT b.id

  FROM sakthi_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.14 ms After last query: 0.27 ms Query memory: 0.035 MB Memory before query: 5.279 MB Rows returned: 144

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM sakthi_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_extensions	NULL	ref	extension	extension	82	const	197	0.40	Using index condition; Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.62 ms Query memory: 0.020 MB Memory before query: 5.361 MB Rows returned: 1

SELECT *

  FROM sakthi_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	25.00	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Language/LanguageHelper.php:67
4	Joomla\CMS\Language\LanguageHelper::detectLanguage()	JROOT/libraries/src/Application/SiteApplication.php:653
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 9.37 ms Query memory: 0.021 MB Memory before query: 8.710 MB Rows returned: 6

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `sakthi_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_extensions	NULL	ref	extension	extension	82	const	6	1.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 13.62 ms After last query: 11.00 ms Query memory: 2.331 MB Memory before query: 10.951 MB Rows returned: 2115

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM sakthi_menu AS m

  LEFT JOIN sakthi_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	2729	10.00	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	sakthi_new.m.component_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.33 ms After last query: 49.03 ms Query memory: 0.028 MB Memory before query: 20.918 MB Rows returned: 59

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

  FROM `sakthi_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_autartimonial','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dbreplacer','com_easyblog','com_easyfolderlistingpro','com_fields','com_finder','com_fpss','com_installer','com_jce','com_jchoptimize','com_jdonation','com_joomlaupdate','com_k2','com_kunena','com_languages','com_login','com_mailto','com_maximenuck','com_media','com_menus','com_messages','com_mijosql','com_modules','com_newsfeeds','com_nicepaypaldownloads','com_nonumbermanager','com_phocadownload','com_phocagallery','com_phocaguestbook','com_plugins','com_postinstall','com_privacy','com_profiles','com_quicksell','com_redirect','com_search','com_searchreplace','com_tags','com_templates','com_users','com_virtualdomains','com_weblinks','com_wrapper')

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:191
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 4.48 ms Query memory: 0.024 MB Memory before query: 21.414 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `sakthi_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
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/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.28 ms Query memory: 0.006 MB Memory before query: 21.407 MB

UPDATE `sakthi_extensions`

  SET `params` = '{\"mediaversion\":\"0b14423f2bdefb919ce174ca1c31924d\"}'

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
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/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 4.11 ms Query memory: 0.026 MB Memory before query: 21.872 MB Rows returned: 20

SELECT id, home, template, s.params

  FROM sakthi_template_styles as s

  LEFT JOIN sakthi_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	24	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	sakthi_new.e.element	1	91.43	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:268
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:390
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/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 10.14 ms Query memory: 0.092 MB Memory before query: 23.117 MB Rows returned: 1

SELECT *

  FROM sakthi_easyblog_configs

  WHERE `name` = 'config'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_easyblog_configs	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	20.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:581
9	EB::config()	JROOT/administrator/components/com_easyblog/includes/utils.php:51
8	EasyBlog->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:2686
7	EB::ajax()	JROOT/components/com_easyblog/easyblog.php:23
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 4.95 ms Query memory: 0.006 MB Memory before query: 24.046 MB

DELETE 
  FROM `sakthi_easyblog_mailq` 
  WHERE `status`='1' 
  AND DATEDIFF(NOW(), `created`) >='7'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	sakthi_easyblog_mailq	NULL	range	easyblog_mailq_status,idx_mailq_statuscreated	easyblog_mailq_status	1	const	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_easyblog/includes/utils.php:198
11	EasyBlogDbJoomla->query()	JROOT/administrator/components/com_easyblog/models/mailer.php:39
10	EasyBlogModelMailer->cleanup()	JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:29
9	EasyBlogMailer->dispatch()	JROOT/components/com_easyblog/services/maintenance.php:18
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 24.054 MB Rows returned: 0

SELECT `id` 
  FROM `sakthi_easyblog_mailq` 
  WHERE `status`='0' 
  ORDER BY `id` ASC 
  LIMIT 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_easyblog_mailq	NULL	ref	easyblog_mailq_status,idx_mailq_statuscreated	easyblog_mailq_status	1	const	1	100.00	Using where; Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/mailer.php:67
10	EasyBlogModelMailer->getPendingEmails()	JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:32
9	EasyBlogMailer->dispatch()	JROOT/components/com_easyblog/services/maintenance.php:18
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.68 ms After last query: 5.59 ms Query memory: 0.023 MB Memory before query: 25.163 MB Rows returned: 0

SELECT * 
  FROM `sakthi_easyblog_post` 
  WHERE `publish_up`<='2023-06-09 15:38:07' 
  AND `published`='2' 
  AND `state`='0' 
  ORDER BY `id` 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_easyblog_post	NULL	ref	easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_blogger_list	1	const	1	5.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blogs.php:386
10	EasyBlogModelBlogs->getScheduledPosts()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:51
9	EasyBlogScheduler->publish()	JROOT/components/com_easyblog/services/maintenance.php:22
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 25.178 MB Rows returned: 0

SELECT id, created_by 
  FROM`sakthi_easyblog_post` 
  WHERE `publish_down` > `publish_up` 
  AND `publish_down` <= '2023-06-09 15:38:07' 
  AND `publish_down` != '0000-00-00 00:00:00' 
  AND `published` = '1' 
  AND `state` = '0'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_easyblog_post	NULL	range	easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1,idx_publishdown_posts	idx_publishdown_posts	11	NULL	2	3.30	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blogs.php:542
10	EasyBlogModelBlogs->getUnpublishScheduledPosts()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:26
9	EasyBlogScheduler->unpublish()	JROOT/components/com_easyblog/services/maintenance.php:25
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.26 ms Query memory: 0.022 MB Memory before query: 25.183 MB Rows returned: 0

SELECT * 
  FROM `sakthi_easyblog_uploader_tmp` 
  WHERE `created` <= DATE_SUB('2023-06-09 15:38:07' , INTERVAL 120 MINUTE)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_easyblog_uploader_tmp	NULL	range	idx_uploader_created	idx_uploader_created	5	NULL	1	100.00	Using index condition

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
10	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:165
9	EasyBlogScheduler->removeTmpFiles()	JROOT/components/com_easyblog/services/maintenance.php:28
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 25.190 MB Rows returned: 0

SELECT a.`id` 
  FROM `sakthi_easyblog_post` as a	
  inner join `sakthi_easyblog_revisions` as b 
  on a.`id` = b.`post_id` 
  where a.`published` = '9' 
  and a.`created` <= DATE_SUB('2023-06-09 15:38:07', INTERVAL 3 DAY)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	PRIMARY,easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_published	1	const	1	33.33	Using where
1	SIMPLE	b	NULL	ref	idx_postid,idx_ordering,idx_revision_state	idx_postid	8	sakthi_new.a.id	1	100.00	Using where; Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
10	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:207
9	EasyBlogScheduler->removeBlankPosts()	JROOT/components/com_easyblog/services/maintenance.php:31
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.05 ms Query memory: 0.006 MB Memory before query: 25.196 MB

DELETE a, b 
  FROM `sakthi_easyblog_post` as a	
  inner join `sakthi_easyblog_revisions` as b 
  on a.`id` = b.`post_id` 
  where a.`published` = '9' 
  and a.`created` <= DATE_SUB('2023-06-09 15:38:07', INTERVAL 3 DAY)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	a	NULL	ref	PRIMARY,easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_published	1	const	1	33.33	Using where
1	DELETE	b	NULL	ref	idx_postid,idx_ordering,idx_revision_state	idx_postid	8	sakthi_new.a.id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_easyblog/includes/utils.php:198
10	EasyBlogDbJoomla->query()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:220
9	EasyBlogScheduler->removeBlankPosts()	JROOT/components/com_easyblog/services/maintenance.php:31
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.40 ms After last query: 0.86 ms Query memory: 0.043 MB Memory before query: 25.628 MB Rows returned: 10

SELECT * 
  FROM `sakthi_menu` 
  WHERE `published`='1' 
  AND `link` LIKE 'index.php?option=com_easyblog%' 
  AND `client_id` = '0' 
  ORDER BY `id`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_menu	NULL	index	idx_client_id_parent_id_alias_language	PRIMARY	4	NULL	2729	1.11	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/menu.php:64
12	EasyBlogModelMenu->getAssociatedMenus()	JROOT/administrator/components/com_easyblog/includes/router.php:97
11	EBR::getMenus()	JROOT/administrator/components/com_easyblog/includes/router.php:453
10	EBR::_()	JROOT/administrator/components/com_easyblog/includes/router.php:955
9	EBR::getRoutedURL()	JROOT/components/com_easyblog/services/weblog.php:26
8	require_once JROOT/components/com_easyblog/services/weblog.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3925
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:27
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 0.86 ms Query memory: 0.031 MB Memory before query: 25.657 MB Rows returned: 46

SELECT * 
  FROM `sakthi_easyblog_acl` 
  WHERE `published`='1' 
  ORDER BY `id` ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_easyblog_acl	NULL	index	idx_acl_published,idx_acl_published_id	PRIMARY	8	NULL	46	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:322
11	EasyBlogAcl::getRules()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:36
10	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:219
9	EB::acl()	JROOT/components/com_easyblog/controllers/controller.php:22
8	EasyBlogController->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:313
7	Joomla\CMS\MVC\Controller\BaseController::getInstance()	JROOT/components/com_easyblog/easyblog.php:33
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.12 ms Query memory: 0.027 MB Memory before query: 25.693 MB Rows returned: 46

SELECT * 
  FROM `sakthi_easyblog_acl_group` 
  WHERE `content_id` IN (1) 
  AND `type`='
  group'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_easyblog_acl_group	NULL	ref	easyblog_post_acl_content_type	easyblog_post_acl_content_type	775	const,const	46	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:151
11	EasyBlogAcl::getEasyBlogAclGroups()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:98
10	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:219
9	EB::acl()	JROOT/components/com_easyblog/controllers/controller.php:22
8	EasyBlogController->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:313
7	Joomla\CMS\MVC\Controller\BaseController::getInstance()	JROOT/components/com_easyblog/easyblog.php:33
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 4.95 ms After last query: 3.39 ms Query memory: 0.025 MB Memory before query: 26.153 MB Rows returned: 1

SELECT `id` 
  FROM `sakthi_menu` 
  WHERE ( `link`='index.php?option=com_easyblog&view=categories&layout=listings&id=7' OR `link` LIKE 'index.php?option=com_easyblog&view=categories&layout=listings&id=7&
  limit%' OR `link`='index.php?option=com_easyblog&view=categories&layout=listings&id=7' ) 
  AND `published`='1'  
  AND (`language`='en-GB' OR `language`='' OR `language`='*') 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_menu	NULL	ALL	idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	2729	2.80	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
18	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/menu.php:342
17	EasyBlogModelMenu->getMenusByCategoryId()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4318
16	EB::getMenuParams()	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:155
15	EasyBlogThemes->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3832
14	EB::template()	JROOT/components/com_easyblog/views/views.php:48
13	EasyBlogView->__construct()	JROOT/components/com_easyblog/views/categories/view.html.php:31
12	EasyBlogViewCategories->__construct()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89
11	Joomla\CMS\MVC\Factory\LegacyFactory->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:590
10	Joomla\CMS\MVC\Controller\BaseController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:833
9	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/components/com_easyblog/controllers/controller.php:69
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 2.04 ms Query memory: 0.025 MB Memory before query: 26.171 MB Rows returned: 1

SELECT `params` 
  FROM `sakthi_menu` 
  WHERE `id`='4009'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
18	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/menu.php:106
17	EasyBlogModelMenu->getMenuParamsById()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:4345
16	EB::getMenuParams()	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:155
15	EasyBlogThemes->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3832
14	EB::template()	JROOT/components/com_easyblog/views/views.php:48
13	EasyBlogView->__construct()	JROOT/components/com_easyblog/views/categories/view.html.php:31
12	EasyBlogViewCategories->__construct()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89
11	Joomla\CMS\MVC\Factory\LegacyFactory->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:590
10	Joomla\CMS\MVC\Controller\BaseController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:833
9	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/components/com_easyblog/controllers/controller.php:69
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.56 ms Query memory: 0.022 MB Memory before query: 26.586 MB Rows returned: 1

SELECT *

  FROM sakthi_easyblog_category

  WHERE `id` = '7'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_easyblog/views/categories/view.html.php:129
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 3.94 ms Query memory: 0.023 MB Memory before query: 27.964 MB Rows returned: 1

Duplicate queries: #62 #65 #67 #70 #72 #75

SELECT COUNT(1) 
  FROM `sakthi_easyblog_category_acl` as a 
  LEFT JOIN `sakthi_easyblog_category` as b 
  ON a.`category_id` = b.`id` 
  WHERE b.`published` = '1' 
  AND a.`acl_id` = '2' 
  AND a.`type` = 'user' 
  AND a.`content_id` = ''

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type	easyblog_category_acl_id	8	const	1	100.00	Using index condition; Using where
1	SIMPLE	b	NULL	eq_ref	PRIMARY,easyblog_cat_published,idx_category_access	PRIMARY	8	sakthi_new.a.category_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
14	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/tables/categoryacl.php:79
13	EasyBlogTableCategoryAcl->getUserAssignedCategoryACL()	JROOT/administrator/components/com_easyblog/includes/category/category.php:238
12	EasyBlogCategory::genCatAccessSQL()	JROOT/administrator/components/com_easyblog/models/categories.php:707
11	EasyBlogModelCategories->getChildCategories()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:2498
10	EB::buildNestedCategories()	JROOT/components/com_easyblog/views/categories/view.html.php:163
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 27.971 MB Rows returned: 1

select a.`id`, a.`title`, a.`alias`, a.`private`, a.`parent_id`, a.`avatar`, a.`description` 
  from `sakthi_easyblog_category` as a 
  WHERE a.`lft` > '7' 
  AND a.`lft` < '10' 
  and a.`published` = '1' 
  AND (( (a.`private` = 0) OR (a.`private` = 1 
  AND '0' > 0) OR (a.`private` = 2 
  AND ( SELECT COUNT(1) 
  FROM `sakthi_easyblog_category_acl` as ca 
  WHERE ca.`category_id` = a.`id` 
  AND ca.`acl_id` = '1' 
  AND ( (ca.`content_id` IN ('1') 
  AND ca.`type` = '
  group') OR (ca.`content_id` = '0' 
  AND ca.`type` = 'user') ) ) > 0 ) )) 
  ORDER BY a.`lft` ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	range	easyblog_cat_published,easyblog_cat_lft,idx_category_access,idx_cat_lftrgt	easyblog_cat_lft	5	NULL	1	19.00	Using index condition; Using where
2	DEPENDENT SUBQUERY	ca	NULL	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type	easyblog_category_acl	8	sakthi_new.a.id	1	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/categories.php:747
11	EasyBlogModelCategories->getChildCategories()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:2498
10	EB::buildNestedCategories()	JROOT/components/com_easyblog/views/categories/view.html.php:163
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.22 ms After last query: 0.31 ms Query memory: 0.025 MB Memory before query: 27.988 MB Rows returned: 1

SELECT *

  FROM sakthi_easyblog_category

  WHERE `id` = '20'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
16	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:885
15	EasyBlogCache->fallback()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:860
14	EasyBlogCache->get()	JROOT/administrator/components/com_easyblog/includes/router.php:551
13	EBR::_()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3967
12	EB::_()	JROOT/administrator/components/com_easyblog/tables/category.php:1375
11	EasyBlogTableCategory->getPermalink()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:2550
10	EB::accessNestedCategories()	JROOT/components/com_easyblog/views/categories/view.html.php:189
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.09 ms After last query: 1.19 ms Query memory: 0.022 MB Memory before query: 28.673 MB Rows returned: 1

SELECT COUNT(1) AS `cnt` 
  FROM `sakthi_easyblog_post_category` AS `a` 
  INNER JOIN `sakthi_easyblog_post` AS `b` 
  ON a.`post_id` = b.`id` 
  AND b.`published`='1' 
  INNER JOIN `sakthi_easyblog_category` AS `c` 
  ON a.`category_id` = c.`id` 
  INNER JOIN `sakthi_users` AS `uu` 
  ON b.`created_by` = uu.`id` 
  AND b.`access` = '0' 
  WHERE (c.`id` IN (7) or c.`parent_id` IN (7)) 
  AND b.`state`='0' 
  AND ( b.`language`='en-GB' OR b.`language`='' OR b.`language`='*')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	index_merge	PRIMARY,easyblog_cat_parentid	PRIMARY,easyblog_cat_parentid	8,5	NULL	2	100.00	Using union(PRIMARY,easyblog_cat_parentid); Using where
1	SIMPLE	a	NULL	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_cat_post	4	sakthi_new.c.id	31	100.00	Using where; Using index
1	SIMPLE	b	NULL	eq_ref	PRIMARY,easyblog_post_published,easyblog_post_created_by,easyblog_post_blogger_list,easyblog_post_search,easyblog_frontpage1,easyblog_post_searchnew,idx_pre_soucetype_postcount,idx_post_sql1	PRIMARY	8	sakthi_new.a.post_id	1	5.00	Using index condition; Using where
1	SIMPLE	uu	NULL	eq_ref	PRIMARY	PRIMARY	4	sakthi_new.b.created_by	1	100.00	Using where; Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_easyblog/includes/utils.php:218
11	EasyBlogDbJoomla->loadResultArray()	JROOT/administrator/components/com_easyblog/models/category.php:666
10	EasyBlogModelCategory->getTotalPostCount()	JROOT/components/com_easyblog/views/categories/view.html.php:207
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 8.65 ms After last query: 0.65 ms Query memory: 0.023 MB Memory before query: 28.714 MB Rows returned: 1

SELECT COUNT(1)  
  FROM `sakthi_easyblog_post` AS a  
  LEFT JOIN `sakthi_easyblog_featured` as f 
  ON a.`id` = f.`content_id` 
  AND f.`type` = 'post'  
  INNER JOIN `sakthi_users` AS uu 
  ON a.`created_by` = uu.`id` 
  and uu.`block` = 0 
  WHERE a.`published`='1' 
  AND a.`state`='0'   
  AND ((a.`source_type` = 'easyblog.sitewide')  OR ( a.`source_type` = 'easyblog.team' 
  and 1 <= (select count(1) 
  from `sakthi_easyblog_team` as srcteam 
  where srcteam.`id` = a.`source_id` 
  and srcteam.`published` = 1 
  and ( (srcteam.`access` = 3)       OR (srcteam.`access` = 2 
  and (select count(1) 
  from `sakthi_easyblog_team_groups` as srcteamgrp 
  where srcteamgrp.`team_id` = srcteam.`id` 
  and srcteamgrp.`group_id` IN (1) ) > 0))))) 
  AND (1 <= (select count(1) 
  from `sakthi_easyblog_post_category` AS acp 
  INNER JOIN `sakthi_easyblog_category` as cat 
  on acp.`category_id` = cat.`id` 
  where acp.`post_id` = a.`id` 
  AND cat.`id` IN (7,20) 
  and ( 	( cat.`private` = 0 ) OR 	( (cat.`private` = 1) 
  and (0 > 0) ) OR 	( (cat.`private` = 2) 
  and ( (select count(1) 
  from `sakthi_easyblog_category_acl` as cacl 
  where cacl.`category_id` = cat.id 
  and cacl.`acl_id` = 1 
  and cacl.`content_id` in (1)) > 0 ) ) ) 
  and not exists (	select acp2.post_id 
  from `sakthi_easyblog_post_category` as acp2		
  inner join  `sakthi_easyblog_category` as cat2 
  on acp2.`category_id` = cat2.`id`	
  where acp2.`post_id` = acp.`post_id`	
  and ( 		( cat2.`private` = 1 
  and (0 = 0) ) OR 		( cat2.`private` = 2 
  and (select count(1) 
  from `sakthi_easyblog_category_acl` as cacl2 
  where cacl2.`category_id` = cat2.`id` 
  and cacl2.`acl_id` = 1 
  and cacl2.`content_id` IN (1)) = 0 )	) ) ))  
  AND a.`access` = '0' 
  AND (a.`language`='en-GB' OR a.`language`='*' OR a.`language`='')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	easyblog_post_published,easyblog_post_created_by,easyblog_post_blogger_list,easyblog_post_search,easyblog_frontpage1,easyblog_post_searchnew,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_searchnew	5	const,const	526	0.51	Using where
1	PRIMARY	f	NULL	ref	easyblog_featured_content_type,easyblog_content	easyblog_featured_content_type	775	sakthi_new.a.id,const	1	100.00	Using index
1	PRIMARY	uu	NULL	eq_ref	PRIMARY,idx_block	PRIMARY	4	sakthi_new.a.created_by	1	80.49	Using where
4	DEPENDENT SUBQUERY	cat	NULL	range	PRIMARY	PRIMARY	8	NULL	2	19.00	Using where
4	DEPENDENT SUBQUERY	acp	NULL	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_post_cat	8	sakthi_new.a.id,sakthi_new.cat.id	1	100.00	Using where; Using index
6	DEPENDENT SUBQUERY	acp2	NULL	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_post_cat	4	sakthi_new.acp.post_id	2	100.00	Using index
6	DEPENDENT SUBQUERY	cat2	NULL	eq_ref	PRIMARY	PRIMARY	8	sakthi_new.acp2.category_id	1	19.00	Using where
7	DEPENDENT SUBQUERY	cacl2	NULL	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type	easyblog_category_acl	8	sakthi_new.cat2.id	1	100.00	Using index condition; Using where
5	DEPENDENT SUBQUERY	cacl	NULL	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type	easyblog_category_acl	8	sakthi_new.cat.id	1	100.00	Using index condition; Using where
2	DEPENDENT SUBQUERY	srcteam	NULL	eq_ref	PRIMARY,idx_viewable_team,idx_published,idx_access	PRIMARY	4	sakthi_new.a.source_id	1	100.00	Using where
3	DEPENDENT SUBQUERY	srcteamgrp	NULL	ref	team_id,group_id,idx_team_group	team_id	4	sakthi_new.srcteam.id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/category.php:1334
10	EasyBlogModelCategory->getPosts()	JROOT/components/com_easyblog/views/categories/view.html.php:295
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 9.03 ms After last query: 0.81 ms Query memory: 0.405 MB Memory before query: 28.728 MB Rows returned: 8

SELECT a.*, ifnull(f.`id`, 0) as `featured`  
  FROM `sakthi_easyblog_post` AS a  
  LEFT JOIN `sakthi_easyblog_featured` as f 
  ON a.`id` = f.`content_id` 
  AND f.`type` = 'post'  
  INNER JOIN `sakthi_users` AS uu 
  ON a.`created_by` = uu.`id` 
  and uu.`block` = 0 
  WHERE a.`published`='1' 
  AND a.`state`='0'   
  AND ((a.`source_type` = 'easyblog.sitewide')  OR ( a.`source_type` = 'easyblog.team' 
  and 1 <= (select count(1) 
  from `sakthi_easyblog_team` as srcteam 
  where srcteam.`id` = a.`source_id` 
  and srcteam.`published` = 1 
  and ( (srcteam.`access` = 3)       OR (srcteam.`access` = 2 
  and (select count(1) 
  from `sakthi_easyblog_team_groups` as srcteamgrp 
  where srcteamgrp.`team_id` = srcteam.`id` 
  and srcteamgrp.`group_id` IN (1) ) > 0))))) 
  AND (1 <= (select count(1) 
  from `sakthi_easyblog_post_category` AS acp 
  INNER JOIN `sakthi_easyblog_category` as cat 
  on acp.`category_id` = cat.`id` 
  where acp.`post_id` = a.`id` 
  AND cat.`id` IN (7,20) 
  and ( 	( cat.`private` = 0 ) OR 	( (cat.`private` = 1) 
  and (0 > 0) ) OR 	( (cat.`private` = 2) 
  and ( (select count(1) 
  from `sakthi_easyblog_category_acl` as cacl 
  where cacl.`category_id` = cat.id 
  and cacl.`acl_id` = 1 
  and cacl.`content_id` in (1)) > 0 ) ) ) 
  and not exists (	select acp2.post_id 
  from `sakthi_easyblog_post_category` as acp2		
  inner join  `sakthi_easyblog_category` as cat2 
  on acp2.`category_id` = cat2.`id`	
  where acp2.`post_id` = acp.`post_id`	
  and ( 		( cat2.`private` = 1 
  and (0 = 0) ) OR 		( cat2.`private` = 2 
  and (select count(1) 
  from `sakthi_easyblog_category_acl` as cacl2 
  where cacl2.`category_id` = cat2.`id` 
  and cacl2.`acl_id` = 1 
  and cacl2.`content_id` IN (1)) = 0 )	) ) ))  
  AND a.`access` = '0' 
  AND (a.`language`='en-GB' OR a.`language`='*' OR a.`language`='') 
  ORDER BY a.`created` desc 
  LIMIT 0,20

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	easyblog_post_published,easyblog_post_created_by,easyblog_post_blogger_list,easyblog_post_search,easyblog_frontpage1,easyblog_post_searchnew,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_searchnew	5	const,const	526	0.51	Using where
1	PRIMARY	f	NULL	ref	easyblog_featured_content_type,easyblog_content	easyblog_featured_content_type	775	sakthi_new.a.id,const	1	100.00	Using index
1	PRIMARY	uu	NULL	eq_ref	PRIMARY,idx_block	PRIMARY	4	sakthi_new.a.created_by	1	80.49	Using where
4	DEPENDENT SUBQUERY	cat	NULL	range	PRIMARY	PRIMARY	8	NULL	2	19.00	Using where
4	DEPENDENT SUBQUERY	acp	NULL	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_post_cat	8	sakthi_new.a.id,sakthi_new.cat.id	1	100.00	Using where; Using index
6	DEPENDENT SUBQUERY	acp2	NULL	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_post_cat	4	sakthi_new.acp.post_id	2	100.00	Using index
6	DEPENDENT SUBQUERY	cat2	NULL	eq_ref	PRIMARY	PRIMARY	8	sakthi_new.acp2.category_id	1	19.00	Using where
7	DEPENDENT SUBQUERY	cacl2	NULL	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type	easyblog_category_acl	8	sakthi_new.cat2.id	1	100.00	Using index condition; Using where
5	DEPENDENT SUBQUERY	cacl	NULL	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type	easyblog_category_acl	8	sakthi_new.cat.id	1	100.00	Using index condition; Using where
2	DEPENDENT SUBQUERY	srcteam	NULL	eq_ref	PRIMARY,idx_viewable_team,idx_published,idx_access	PRIMARY	4	sakthi_new.a.source_id	1	100.00	Using where
3	DEPENDENT SUBQUERY	srcteamgrp	NULL	ref	team_id,group_id,idx_team_group	team_id	4	sakthi_new.srcteam.id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/category.php:1357
10	EasyBlogModelCategory->getPosts()	JROOT/components/com_easyblog/views/categories/view.html.php:295
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.47 ms Query memory: 0.022 MB Memory before query: 29.001 MB Rows returned: 1

SELECT COUNT(1) 
  FROM `sakthi_easyblog_category_acl` 
  WHERE `acl_id` = '1' 
  AND `status` = '1' 
  AND `category_id` = '7' 
  AND `content_id` IN ('1')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_easyblog_category_acl	NULL	ref	easyblog_category_acl,easyblog_category_acl_id,easyblog_content_type,easyblog_category_content_type	easyblog_category_acl	8	const	1	100.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/category.php:1729
10	EasyBlogModelCategory->allowAclCategory()	JROOT/components/com_easyblog/views/categories/view.html.php:301
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.52 ms After last query: 1.80 ms Query memory: 0.024 MB Memory before query: 29.068 MB Rows returned: 0

SELECT COUNT(1) as `voted`, `uid` 
  FROM `sakthi_easyblog_ratings` 
  WHERE `uid` IN (675,333,324,321,320,316,312,302) 
  AND `type`='entry' 
  AND `created_by`='0' 
  AND (`sessionid` = '2a01261146219272cb0360ffc2b37e78' OR `ip` = '35.172.111.47') 
  GROUP BY `uid` 
  ORDER BY NULL

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_easyblog_ratings	NULL	range	post_id,created_by,idx_uid_type,idx_uid_type_user,idx_uid_type_user_session,idx_uid_type_user_ipaddr	post_id	4	NULL	11	1.90	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/ratings.php:135
15	EasyBlogModelRatings->preloadUserPostRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:447
14	EasyBlogCache->cacheVoted()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:352
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954
10	EB::formatter()	JROOT/components/com_easyblog/views/categories/view.html.php:341
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 29.077 MB Rows returned: 2

SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` 
  FROM `sakthi_easyblog_ratings` AS a 
  WHERE a.`uid` IN(675,333,324,321,320,316,312,302) 
  AND `type`='entry' 
  GROUP BY `uid` 
  ORDER BY NULL

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	post_id,idx_uid_type,idx_uid_type_user,idx_uid_type_user_ipaddr	idx_uid_type	771	NULL	11	100.00	Using where; Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/ratings.php:176
15	EasyBlogModelRatings->preloadRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:578
14	EasyBlogCache->cacheRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:357
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954
10	EB::formatter()	JROOT/components/com_easyblog/views/categories/view.html.php:341
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 0.30 ms Query memory: 0.032 MB Memory before query: 29.091 MB Rows returned: 16

select a.*, b.`post_id`, b.`primary` 
  from `sakthi_easyblog_category` as a 
  inner join `sakthi_easyblog_post_category` as b 
  on a.`id` = b.`category_id` 
  where b.`post_id` IN (675,333,324,321,320,316,312,302) 
  order by a.`lft` asc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	range	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_postid	4	NULL	16	100.00	Using index condition; Using temporary; Using filesort
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	8	sakthi_new.b.category_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/category.php:1753
15	EasyBlogModelCategory->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:721
14	EasyBlogCache->cacheCategories()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:372
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954
10	EB::formatter()	JROOT/components/com_easyblog/views/categories/view.html.php:341
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.67 ms Query memory: 0.024 MB Memory before query: 29.183 MB Rows returned: 0

select a.*, b.`post_id` 
  from `sakthi_easyblog_tag` as a 
  inner join `sakthi_easyblog_post_tag` as b 
  on a.`id` = b.`tag_id` 
  where b.`post_id` IN (675,333,324,321,320,316,312,302)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	index	easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id	easyblog_post_tagpost_id	16	NULL	56	14.29	Using where; Using index
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	8	sakthi_new.b.tag_id	1	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/tags.php:924
15	EasyBlogModelTags->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:803
14	EasyBlogCache->cacheTags()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:377
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954
10	EB::formatter()	JROOT/components/com_easyblog/views/categories/view.html.php:341
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 0.33 ms Query memory: 0.397 MB Memory before query: 29.862 MB Rows returned: 8

select a.* 
  from `sakthi_easyblog_revisions` as a 
  where a.`id` IN ( 922,95,85,75,74,66,65,7)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	PRIMARY	PRIMARY	8	NULL	8	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/revisions.php:625
15	EasyBlogModelRevisions->preload()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:697
14	EasyBlogCache->cacheRevisions()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:382
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954
10	EB::formatter()	JROOT/components/com_easyblog/views/categories/view.html.php:341
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.74 ms Query memory: 0.027 MB Memory before query: 30.181 MB Rows returned: 2

select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`,  e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`, e.`ordering` 
  from `sakthi_users` as u 
  left join `sakthi_easyblog_users` as e 
  ON u.`id` = e.`id` 
  where u.`id` IN (42,490)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	8	sakthi_new.u.id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
19	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/users.php:298
18	EasyBlogModelUsers->getUsersMeta()	JROOT/administrator/components/com_easyblog/includes/user/user.php:171
17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784
14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954
10	EB::formatter()	JROOT/components/com_easyblog/views/categories/view.html.php:341
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 1.07 ms Query memory: 0.031 MB Memory before query: 30.213 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `sakthi_users`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
26	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
25	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
24	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
23	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
22	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
21	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
20	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
19	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
18	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:218
17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784
14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954
10	EB::formatter()	JROOT/components/com_easyblog/views/categories/view.html.php:341
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.13 ms Query memory: 0.027 MB Memory before query: 30.246 MB Rows returned: 1

SELECT *

  FROM `sakthi_users`

  WHERE `id` = 42

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
22	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
21	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
20	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
19	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
18	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:218
17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784
14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954
10	EB::formatter()	JROOT/components/com_easyblog/views/categories/view.html.php:341
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.94 ms Query memory: 0.027 MB Memory before query: 30.264 MB Rows returned: 11

SELECT `g`.`id`,`g`.`title`

  FROM `sakthi_usergroups` AS g

  INNER JOIN `sakthi_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 42

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	11	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	sakthi_new.m.group_id	1	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
23	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
22	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
21	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
20	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
19	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
18	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:218
17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784
14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954
10	EB::formatter()	JROOT/components/com_easyblog/views/categories/view.html.php:341
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.21 ms Query memory: 0.027 MB Memory before query: 30.278 MB Rows returned: 1

SELECT *

  FROM `sakthi_users`

  WHERE `id` = 490

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
22	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
21	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
20	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
19	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
18	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:218
17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784
14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954
10	EB::formatter()	JROOT/components/com_easyblog/views/categories/view.html.php:341
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.20 ms After last query: 0.35 ms Query memory: 0.027 MB Memory before query: 30.292 MB Rows returned: 5

SELECT `g`.`id`,`g`.`title`

  FROM `sakthi_usergroups` AS g

  INNER JOIN `sakthi_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 490

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	5	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	sakthi_new.m.group_id	1	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
23	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
22	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
21	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
20	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
19	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
18	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_easyblog/includes/user/user.php:218
17	EasyBlogUser::loadUsers()	JROOT/administrator/components/com_easyblog/includes/user/user.php:63
16	EasyBlogUser::factory()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1099
15	EB::user()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:784
14	EasyBlogCache->cacheAuthors()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:387
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954
10	EB::formatter()	JROOT/components/com_easyblog/views/categories/view.html.php:341
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.23 ms Query memory: 0.025 MB Memory before query: 30.304 MB Rows returned: 0

select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` 
  from `sakthi_easyblog_category_fields_groups` as a 
  inner join `sakthi_easyblog_post_category` as p 
  on `a`.`category_id` = `p`.`category_id`	
  inner join `sakthi_easyblog_fields_groups` as fg 
  on `a`.`group_id` = `fg`.`id`	
  inner join `sakthi_easyblog_fields` as f 
  on `fg`.`id` = `f`.`group_id`	
  left join `sakthi_easyblog_fields_values` as fv 
  on `fv`.`field_id` = `f`.`id` 
  and `fv`.`post_id` = `p`.`post_id` 
  LEFT JOIN `sakthi_easyblog_fields_groups_acl` AS acl 
  ON fg.`id` = acl.`group_id` 
  where p.post_id IN (675,333,324,321,320,316,312,302) 
  AND ( acl.`acl_id` IN(1) 
  AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	index	category_id,cat_id	category_id	8	NULL	1	100.00	Using index
1	SIMPLE	p	NULL	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_cat_post	4	sakthi_new.a.category_id	31	1.40	Using where; Using index
1	SIMPLE	fg	NULL	eq_ref	PRIMARY	PRIMARY	4	sakthi_new.a.group_id	1	100.00	NULL
1	SIMPLE	f	NULL	ref	group_id,idx_group_ordering	group_id	4	sakthi_new.a.group_id	1	100.00	NULL
1	SIMPLE	fv	NULL	ref	field_id,post_id	field_id	4	sakthi_new.f.id	1	100.00	Using where
1	SIMPLE	acl	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/fields.php:309
15	EasyBlogModelFields->preloadFields()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:484
14	EasyBlogCache->cacheFields()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:392
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954
10	EB::formatter()	JROOT/components/com_easyblog/views/categories/view.html.php:341
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.26 ms Query memory: 0.025 MB Memory before query: 30.983 MB Rows returned: 8

select * 
  from `sakthi_easyblog_meta` 
  where `content_id` in (675,333,324,321,320,316,312,302) 
  and `type` = 'post'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_easyblog_meta	NULL	range	idx_meta_content_type	idx_meta_content_type	66	NULL	8	100.00	Using index condition

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/metas.php:393
15	EasyBlogModelMetas->preloadPostMetas()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:413
14	EasyBlogCache->cacheMetas()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:397
13	EasyBlogCache->insert()	JROOT/administrator/components/com_easyblog/includes/formatter/types/list.php:29
12	EasyBlogFormatterList->execute()	JROOT/administrator/components/com_easyblog/includes/formatter/formatter.php:55
11	EasyBlogFormatter->execute()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3954
10	EB::formatter()	JROOT/components/com_easyblog/views/categories/view.html.php:341
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 3.69 ms Query memory: 0.022 MB Memory before query: 31.418 MB Rows returned: 0

SELECT `id` 
  FROM `sakthi_easyblog_subscriptions` 
  WHERE `uid` = '7' 
  AND `utype` = 'category' 
  AND `email` = ''

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_easyblog_subscriptions	NULL	ref	easyblog_subscriptions_types,easyblog_subscriptions_types_userid,easyblog_subscriptions_types_email,easyblog_subscriptions_email	easyblog_subscriptions_types	202	const,const	1	50.00	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easyblog/includes/utils.php:330
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/category.php:1618
10	EasyBlogModelCategory->isCategorySubscribedEmail()	JROOT/components/com_easyblog/views/categories/view.html.php:348
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.21 ms Query memory: 0.022 MB Memory before query: 31.429 MB Rows returned: 1

SELECT *

  FROM sakthi_easyblog_meta

  WHERE `content_id` = '7' 
  AND `type` = 'category'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sakthi_easyblog_meta	NULL	ref	idx_meta_content_type	idx_meta_content_type	66	const,const	1	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
11	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1958
10	EB::setMeta()	JROOT/components/com_easyblog/views/categories/view.html.php:373
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 7.29 ms After last query: 12.93 ms Query memory: 0.561 MB Memory before query: 32.834 MB Rows returned: 308

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM sakthi_modules AS m

  LEFT JOIN sakthi_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  LEFT JOIN sakthi_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ALL	element_clientid,element_folder_clientid	NO INDEX KEY COULD BE USED	NULL	NULL	439	1.00	Using where; Using temporary; Using filesort
1	SIMPLE	m	NULL	ref	published,newsfeeds,idx_language	newsfeeds	204	sakthi_new.e.element,const	3	2.00	Using index condition; Using where
1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	sakthi_new.m.id	1	100.00	NULL

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278
19	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
18	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:1796
13	EB::renderModule()	JROOT/components/com_easyblog/themes/wireframe/blogs/categories/item.php:28
12	include JROOT/components/com_easyblog/themes/wireframe/blogs/categories/item.php	JROOT/administrator/components/com_easyblog/includes/themes/themes.php:608
11	EasyBlogThemes->output()	JROOT/components/com_easyblog/views/views.php:187
10	EasyBlogView->display()	JROOT/components/com_easyblog/views/categories/view.html.php:406
9	EasyBlogViewCategories->listings()	JROOT/components/com_easyblog/controllers/controller.php:103
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:36
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 12.28 ms Query memory: 0.027 MB Memory before query: 34.230 MB Rows returned: 1

We are all cells in one Cosmic Body

Nav view search

Navigation

Search

Easy Blog

Important Sections

Uni5 Community Blog

Uni5 Happy Mind

Exposing Children to Culture in Early Days

cocoon to adult butterfly

Uni5 infancy center diary - July

Uni5 approach of children in home and school - 2

Uni5 Aproach for Assisting Children at home and school - 1

Uni5 Parenting Home

Uni5 Parenting - Five Needs of a Child

Relationships

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

87 Queries Logged 89.34 ms

10 duplicate found!