Home - Gene Shepherd's Internet Rug Camp

If you are having trouble logging in, use your email address on file with this site as the username. If you forgot your password, please use the password reset link. If you're still having trouble, contact Marsha@Geneshepherd.com
♥ ~BTWG

Some of Gene's Rugs

Gene Shepherd's Instagram Feed

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1743264751,
                "last": 1743264751,
                "now": 1743264751
            },
            "token": "hEROkLIN4oIdTsMdwscKPxCV7MKAvXDp"
        },
        "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
        }
    }
}

Profile Information

Time

Memory

Time: 21.70 ms / 21.70 ms Memory: 2.018 MB / 2.40 MB Application: afterLoad

Time: 60.70 ms / 82.40 ms Memory: 4.292 MB / 6.70 MB Application: afterInitialise

Time: 19.18 ms / 101.58 ms Memory: 1.153 MB / 7.85 MB Application: afterRoute

Time: 1.75 ms / 103.33 ms Memory: 0.031 MB / 7.88 MB Application: beforeRenderComponent com_content

Time: 6.94 ms / 110.28 ms Memory: 0.659 MB / 8.54 MB Application: Before Access::preloadComponents (all components)

Time: 1.28 ms / 111.55 ms Memory: 0.067 MB / 8.61 MB Application: After Access::preloadComponents (all components)

Time: 0.04 ms / 111.59 ms Memory: -0.003 MB / 8.60 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.49 ms / 112.08 ms Memory: 0.026 MB / 8.63 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 14.50 ms / 126.59 ms Memory: 0.900 MB / 9.53 MB Application: afterRenderComponent com_content

Time: 1.27 ms / 127.86 ms Memory: 0.098 MB / 9.63 MB Application: afterDispatch

Time: 3.31 ms / 131.17 ms Memory: 0.224 MB / 9.85 MB Application: beforeRenderModule mod_menu (Bottom Menu)

Time: 3.24 ms / 134.41 ms Memory: 0.103 MB / 9.95 MB Application: afterRenderModule mod_menu (Bottom Menu)

Time: 0.64 ms / 135.05 ms Memory: 0.000 MB / 9.95 MB Application: beforeRenderModule mod_custom (Single Frontpage Image)

Time: 0.36 ms / 135.40 ms Memory: 0.021 MB / 9.98 MB Application: afterRenderModule mod_custom (Single Frontpage Image)

Time: 0.22 ms / 135.62 ms Memory: -0.021 MB / 9.95 MB Application: beforeRenderModule mod_igallery (Some of Gene's Rugs)

Time: 30.31 ms / 165.93 ms Memory: 1.398 MB / 11.35 MB Application: afterRenderModule mod_igallery (Some of Gene's Rugs)

Time: 0.06 ms / 165.99 ms Memory: 0.031 MB / 11.38 MB Application: beforeRenderModule mod_jux_social_instagram_feed (Gene Shepherd's Instagram Feed)

Time: 2.66 ms / 168.65 ms Memory: 0.187 MB / 11.57 MB Application: afterRenderModule mod_jux_social_instagram_feed (Gene Shepherd's Instagram Feed)

Time: 0.49 ms / 169.14 ms Memory: -0.020 MB / 11.55 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 8.51 ms / 177.66 ms Memory: 0.612 MB / 12.16 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.52 ms / 178.18 ms Memory: -0.003 MB / 12.16 MB Application: beforeRenderModule mod_custom (Admin Messages)

Time: 0.22 ms / 178.40 ms Memory: 0.003 MB / 12.16 MB Application: afterRenderModule mod_custom (Admin Messages)

Time: 0.24 ms / 178.64 ms Memory: -0.019 MB / 12.14 MB Application: beforeRenderModule mod_login (Login )

Time: 2.18 ms / 180.81 ms Memory: 0.108 MB / 12.25 MB Application: afterRenderModule mod_login (Login )

Time: 0.08 ms / 180.89 ms Memory: 0.006 MB / 12.26 MB Application: beforeRenderModule mod_socialmedialinksgenius (Social Media)

Time: 1.01 ms / 181.90 ms Memory: 0.652 MB / 12.91 MB Application: afterRenderModule mod_socialmedialinksgenius (Social Media)

Time: 247.74 ms / 429.64 ms Memory: 0.253 MB / 13.16 MB Application: afterRender

Database queries total: 15.42 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	joslr_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Status	Duration
Starting	0.20 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.05 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

#	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

EXPLAIN not possible on query: INSERT INTO `joslr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6463646662663039613932366139623232386634653564653562653431303134', 1, 1743264751, 0, '', 0)

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.01 ms
Update	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.49 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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.53 ms After last query: 7.69 ms Query memory: 0.005 MB Memory before query: 4.771 MB Rows returned: 3

SELECT id, rules

  FROM `joslr_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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.45 ms After last query: 0.13 ms Query memory: 0.005 MB Memory before query: 4.782 MB Rows returned: 1

SELECT b.id

  FROM joslr_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

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: 2.29 ms After last query: 42.26 ms Query memory: 0.006 MB Memory before query: 7.550 MB

UPDATE `joslr_extensions`

  SET `params` = '{\"mediaversion\":\"97bd152d2604bbf59e83c69a8e85f3e4\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `joslr_extensions` SET `params` = '{\"mediaversion\":\"97bd152d2604bbf59e83c69a8e85f3e4\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.07 ms
Updating	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.77 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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/jcomments/jcomments.php:111
8	plgSystemJComments->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.58 ms After last query: 4.33 ms Query memory: 0.003 MB Memory before query: 7.864 MB Rows returned: 1

SELECT *

  FROM joslr_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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.05 ms After last query: 7.87 ms Query memory: 0.010 MB Memory before query: 8.543 MB Rows returned: 43

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

  FROM `joslr_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_ecwid','com_fields','com_finder','com_fst','com_igallery','com_installer','com_jcomments','com_jlsitemap','com_joomlaupdate','com_jotcache','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_vertexupdate','com_wordpress','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	joslr_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	140	Using where

Profile

Status	Duration
Starting	0.21 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.16 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.23 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:45
14	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.65 ms After last query: 1.57 ms Query memory: 0.009 MB Memory before query: 8.685 MB Rows returned: 0

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

  FROM joslr_content AS a

  INNER JOIN joslr_content_frontpage AS fp 
  ON fp.content_id = a.id

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

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

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

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

  WHERE c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-03-29 16:12:31') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-03-29 16:12:31')

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fp	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY,idx_state,idx_catid	PRIMARY	4	intern63_joom250.fp.content_id	1	Using index condition; Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	intern63_joom250.a.catid	1	Using index condition; Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	intern63_joom250.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	intern63_joom250.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	intern63_joom250.c.parent_id	1	Using where

Profile

Status	Duration
Starting	0.27 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.09 ms
Optimizing	0.05 ms
Statistics	0.09 ms
Preparing	0.05 ms
Creating tmp table	0.13 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.39 ms
Creating sort index	0.04 ms
Removing tmp table	0.10 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
13	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 1.26 ms Query memory: 0.009 MB Memory before query: 8.781 MB Rows returned: 1

SELECT COUNT(*)

  FROM joslr_content AS a

  INNER JOIN joslr_content_frontpage AS fp 
  ON fp.content_id = a.id

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

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

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

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

  WHERE c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-03-29 16:12:31') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-03-29 16:12:31')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fp	index	PRIMARY	PRIMARY	4	NULL	1	Using index
1	SIMPLE	a	eq_ref	PRIMARY,idx_state,idx_catid	PRIMARY	4	intern63_joom250.fp.content_id	1	Using index condition; Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	intern63_joom250.a.catid	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.05 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 28.72 ms Query memory: 0.008 MB Memory before query: 10.983 MB Rows returned: 1

SELECT c.*,u.name AS displayname, u.username

  FROM joslr_igallery AS c

  LEFT JOIN `joslr_users` AS u 
  ON c.user = u.id

  WHERE c.id = 4 
  AND c.published = 1 
  AND c.moderate = 1 
  AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-03-29 16:12:31' OR c.publish_up IS NULL) 
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-03-29 16:12:31'  OR c.publish_down IS NULL)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,published,publish_up,publish_down,moderate	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_igallery/models/category.php:87
15	igalleryModelcategory->getCategory()	JROOT/components/com_igallery/views/category/view.html.php:75
14	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
12	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/modules/mod_igallery/mod_igallery.php:150
10	include JROOT/modules/mod_igallery/mod_igallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 0.07 ms Query memory: 0.008 MB Memory before query: 10.994 MB Rows returned: 1

SELECT * 
  FROM joslr_igallery_profiles 
  WHERE published = 1 
  AND id = 3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	joslr_igallery_profiles	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_igallery/models/category.php:112
15	igalleryModelcategory->getProfile()	JROOT/components/com_igallery/views/category/view.html.php:92
14	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
12	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/modules/mod_igallery/mod_igallery.php:150
10	include JROOT/modules/mod_igallery/mod_igallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 9.66 ms Query memory: 0.009 MB Memory before query: 11.186 MB Rows returned: 7

SELECT * 
  FROM joslr_igallery 
  ORDER BY parent, ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	joslr_igallery	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using filesort

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_igallery/helpers/static.php:15
17	igStaticHelper::getCategories()	JROOT/components/com_igallery/models/category.php:966
16	igalleryModelcategory->getChildIds()	JROOT/components/com_igallery/models/category.php:875
15	igalleryModelcategory->getRandomList()	JROOT/components/com_igallery/views/category/view.html.php:159
14	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
12	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/modules/mod_igallery/mod_igallery.php:150
10	include JROOT/modules/mod_igallery/mod_igallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 0.15 ms Query memory: 0.008 MB Memory before query: 11.219 MB Rows returned: 23

SELECT id

  FROM joslr_igallery_img as i

  WHERE FIND_IN_SET(i.gallery_id,"5,6,7,4") 
  AND i.published = 1 
  AND i.moderate = 1 
  AND i.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ALL	access,published,moderate	NO INDEX KEY COULD BE USED	NULL	NULL	58	Using where

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.13 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_igallery/models/category.php:912
15	igalleryModelcategory->getRandomList()	JROOT/components/com_igallery/views/category/view.html.php:159
14	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
12	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/modules/mod_igallery/mod_igallery.php:150
10	include JROOT/modules/mod_igallery/mod_igallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.78 ms After last query: 0.25 ms Query memory: 0.009 MB Memory before query: 11.260 MB Rows returned: 4

SELECT i.*,c.name, c.folder,p.thumb_pagination_amount, p.thumb_pagination, p.image_ordering,u.name AS displayname, u.username,ROUND( SUM(r.rating)/COUNT(r.rating), 1) AS rating_average, COUNT(r.rating) as rating_count

  FROM joslr_igallery_img AS i

  INNER JOIN `joslr_igallery` AS c 
  ON c.id = i.gallery_id

  INNER JOIN `joslr_igallery_profiles` AS p 
  ON p.id = c.profile

  LEFT JOIN `joslr_users` AS u 
  ON i.user = u.id

  LEFT JOIN `joslr_igallery_ratings` AS r 
  ON i.id = r.image_id 
  AND r.published = 1

  WHERE FIND_IN_SET(i.id,"51,52,54,56") 
  AND FIND_IN_SET(i.gallery_id,"5,6,7,4") 
  AND i.published = 1 
  AND i.moderate = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-03-29 16:12:31'  OR i.publish_up IS NULL) 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-03-29 16:12:31' OR i.publish_down IS NULL) 
  AND i.access IN (1,1)

  GROUP BY i.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using temporary; Using filesort
1	SIMPLE	c	ALL	PRIMARY,profile	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	i	ref	gallery_id,access,published,publish_up,publish_down,moderate	gallery_id	4	intern63_joom250.c.id	4	Using index condition; Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	intern63_joom250.i.user	1
1	SIMPLE	r	ref	image_id,published	image_id	4	intern63_joom250.i.id	1	Using where

Profile

Status	Duration
Starting	0.25 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.17 ms
Preparing	0.05 ms
Creating tmp table	0.12 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.56 ms
Creating sort index	0.07 ms
Removing tmp table	0.10 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_igallery/models/category.php:755
16	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:929
15	igalleryModelcategory->getRandomList()	JROOT/components/com_igallery/views/category/view.html.php:159
14	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
12	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/modules/mod_igallery/mod_igallery.php:150
10	include JROOT/modules/mod_igallery/mod_igallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.34 ms After last query: 0.07 ms Query memory: 0.009 MB Memory before query: 11.260 MB Rows returned: 4

SELECT i.*,c.name, c.folder,p.thumb_pagination_amount, p.thumb_pagination, p.image_ordering,u.name AS displayname, u.username,ROUND( SUM(r.rating)/COUNT(r.rating), 1) AS rating_average, COUNT(r.rating) as rating_count

  FROM joslr_igallery_img AS i

  INNER JOIN `joslr_igallery` AS c 
  ON c.id = i.gallery_id

  INNER JOIN `joslr_igallery_profiles` AS p 
  ON p.id = c.profile

  LEFT JOIN `joslr_users` AS u 
  ON i.user = u.id

  LEFT JOIN `joslr_igallery_ratings` AS r 
  ON i.id = r.image_id 
  AND r.published = 1

  WHERE FIND_IN_SET(i.id,"51,52,54,56") 
  AND FIND_IN_SET(i.gallery_id,"5,6,7,4") 
  AND i.published = 1 
  AND i.moderate = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-03-29 16:12:31'  OR i.publish_up IS NULL) 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-03-29 16:12:31' OR i.publish_down IS NULL) 
  AND i.access IN (1,1)

  GROUP BY i.id

  ORDER BY RAND() 
  LIMIT 4

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	range	gallery_id,access,published,publish_up,publish_down,moderate	published	4	NULL	56	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,profile	PRIMARY	4	intern63_joom250.i.gallery_id	1
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	intern63_joom250.i.user	1
1	SIMPLE	r	ref	image_id,published	image_id	4	intern63_joom250.i.id	1	Using where
1	SIMPLE	p	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.07 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.42 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Removing tmp table	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:765
16	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:929
15	igalleryModelcategory->getRandomList()	JROOT/components/com_igallery/views/category/view.html.php:159
14	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
12	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/modules/mod_igallery/mod_igallery.php:150
10	include JROOT/modules/mod_igallery/mod_igallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.10 ms Query memory: 0.009 MB Memory before query: 11.269 MB Rows returned: 0

SELECT co.*,u.name AS comments_displayname, u.username AS comments_username

  FROM joslr_igallery_comments AS co

  LEFT JOIN `joslr_users` AS u 
  ON co.user = u.id

  WHERE FIND_IN_SET(co.image_id,"56,52,51,54") 
  AND co.published =  1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	co	ALL	published	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	intern63_joom250.co.user	1

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:797
15	igalleryModelcategory->addComments()	JROOT/components/com_igallery/views/category/view.html.php:173
14	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
13	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
12	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/modules/mod_igallery/mod_igallery.php:150
10	include JROOT/modules/mod_igallery/mod_igallery.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 13.01 ms Query memory: 0.013 MB Memory before query: 12.146 MB Rows returned: 122

SELECT `config_key`,`config_value`

  FROM joslr_osmembership_configs

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	joslr_osmembership_configs	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	122

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmembership/libraries/mpf/config/config.php:41
24	MPFConfig->__construct()	JROOT/components/com_osmembership/helper/helper.php:61
23	OSMembershipHelper::getConfig()	JROOT/administrator/components/com_osmembership/loader.php:90
22	require_once JROOT/administrator/components/com_osmembership/loader.php	JROOT/components/com_osmembership/router.php:15
21	require_once JROOT/components/com_osmembership/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
20	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:675
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
14	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
13	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

16 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT i.*,c.name, c.folder,p.thumb_pagination_amount, p.thumb_pagination, p.image_ordering,u.name AS displayname, u.username,ROUND( SUM(r.rating)/COUNT(r.rating), 1) AS rating_average, COUNT(r.rating) as rating_count 
  FROM joslr_igallery_img AS i 
  INNER JOIN `joslr_igallery` AS c 
  ON c.id = i.gallery_id 
  INNER JOIN `joslr_igallery_profiles` AS p 
  ON p.id = c.profile 
  LEFT JOIN `joslr_users` AS u 
  ON i.user = u.id 
  LEFT JOIN `joslr_igallery_ratings` AS r 
  ON i.id = r.image_id 
  AND r.published = 1

1 × SELECT `session_id` 
  FROM `joslr_session`

1 × SELECT id, rules 
  FROM `joslr_viewlevels

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

```
1 × SELECT * 
  FROM joslr_languages
```

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

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

1 × SELECT COUNT(*) 
  FROM joslr_content AS a 
  INNER JOIN joslr_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN joslr_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN joslr_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN joslr_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN joslr_categories as parent 
  ON parent.id = c.parent_id

1 × SELECT c.*,u.name AS displayname, u.username 
  FROM joslr_igallery AS c 
  LEFT JOIN `joslr_users` AS u 
  ON c.user = u.id

1 × SELECT * 
  FROM joslr_igallery_profiles

```
1 × SELECT * 
  FROM joslr_igallery
```

1 × SELECT id 
  FROM joslr_igallery_img as i

1 × SELECT co.*,u.name AS comments_displayname, u.username AS comments_username 
  FROM joslr_igallery_comments AS co 
  LEFT JOIN `joslr_users` AS u 
  ON co.user = u.id

1 × SELECT `config_key`,`config_value` 
  FROM joslr_osmembership_config

OTHER Tables:

1 × INSERT INTO `joslr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6463646662663039613932366139623232386634653564653562653431303134', 1, 1743264751, 0, '', 0

1 × UPDATE `joslr_extensions` 
  SET `params` = '{\"mediaversion\":\"97bd152d2604bbf59e83c69a8e85f3e4\"}'

If you are having trouble logging in, use your email address on file with this site as the username. If you forgot your password, please use the password reset link. If you're still having trouble, contact Marsha@Geneshepherd.com
♥ ~BTWG

Some of Gene's Rugs

Gene Shepherd's Instagram Feed

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

17 Queries Logged 15.42 ms

16 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

If you are having trouble logging in, use your email address on file with this site as the username. If you forgot your password, please use the password reset link. If you're still having trouble, contact Marsha@Geneshepherd.com ♥ ~BTWG

Some of Gene's Rugs

Gene Shepherd's Instagram Feed

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

17 Queries Logged 15.42 ms

16 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

If you are having trouble logging in, use your email address on file with this site as the username. If you forgot your password, please use the password reset link. If you're still having trouble, contact Marsha@Geneshepherd.com
♥ ~BTWG