The Rugs of Gene Shepherd

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

Joomla! Debug Console

Session

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

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.12 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.03 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	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.06 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'3734336631616638376665366231633734633038636231653037373536663436', 1, 1743471174, 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.02 ms
Update	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.56 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.39 ms After last query: 5.34 ms Query memory: 0.005 MB Memory before query: 4.774 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.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.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
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.04 ms
Updating status	0.01 ms
Reset for next command	0.02 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.51 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 4.785 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.01 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 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.02 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.06 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
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.16 ms After last query: 26.38 ms Query memory: 0.006 MB Memory before query: 7.615 MB

UPDATE `joslr_extensions`

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

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

Explain

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

Profile

Status	Duration
Starting	0.15 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.13 ms
Updating	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.45 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.03 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
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.84 ms After last query: 14.48 ms Query memory: 0.006 MB Memory before query: 9.254 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-04-01 01:32:54' OR c.publish_up IS NULL) 
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-01 01:32:54'  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.15 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.06 ms
Statistics	0.12 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_igallery/models/category.php:87
11	igalleryModelcategory->getCategory()	JROOT/components/com_igallery/views/category/view.html.php:75
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:86
6	require_once JROOT/components/com_igallery/igallery.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.74 ms After last query: 0.08 ms Query memory: 0.006 MB Memory before query: 9.263 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.07 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.08 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	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.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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_igallery/models/category.php:112
11	igalleryModelcategory->getProfile()	JROOT/components/com_igallery/views/category/view.html.php:92
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:86
6	require_once JROOT/components/com_igallery/igallery.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.04 ms After last query: 9.80 ms Query memory: 0.006 MB Memory before query: 9.452 MB

UPDATE joslr_igallery 
  SET hits = hits + 1 
  WHERE id = 4

Explain

EXPLAIN not possible on query: UPDATE joslr_igallery SET hits = hits + 1 WHERE id = 4

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 for update	0.08 ms
Updating	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.52 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.08 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_igallery/models/category.php:651
12	igalleryModelcategory->addCategoryHit()	JROOT/components/com_igallery/models/category.php:820
11	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:163
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:86
6	require_once JROOT/components/com_igallery/igallery.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.51 ms After last query: 0.08 ms Query memory: 0.008 MB Memory before query: 9.463 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.06 ms
checking permissions	0.02 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.11 ms
End of update loop	0.02 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.02 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_igallery/helpers/static.php:15
14	igStaticHelper::getCategories()	JROOT/components/com_igallery/models/category.php:966
13	igalleryModelcategory->getChildIds()	JROOT/components/com_igallery/models/category.php:697
12	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:858
11	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:163
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:86
6	require_once JROOT/components/com_igallery/igallery.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: 0.24 ms Query memory: 0.007 MB Memory before query: 9.512 MB Rows returned: 1

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.gallery_id,"5,6,7,4") 
  AND (i.tags LIKE '%Chevron Bench Cover Geometric%' OR i.description LIKE '%Chevron Bench Cover Geometric%' OR i.alt_text LIKE '%Chevron Bench Cover Geometric%' OR i.filename LIKE '%Chevron Bench Cover Geometric%') 
  AND i.published = 1 
  AND i.moderate = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-01 01:32:54'  OR i.publish_up IS NULL) 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-01 01:32:54' 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 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.19 ms
checking permissions	0.01 ms
Opening tables	0.08 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.18 ms
Preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.49 ms
Creating sort index	0.04 ms
Removing tmp table	0.11 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 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.08 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_igallery/models/category.php:755
12	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:858
11	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:163
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:86
6	require_once JROOT/components/com_igallery/igallery.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.28 ms After last query: 0.07 ms Query memory: 0.007 MB Memory before query: 9.510 MB Rows returned: 1

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.gallery_id,"5,6,7,4") 
  AND (i.tags LIKE '%Chevron Bench Cover Geometric%' OR i.description LIKE '%Chevron Bench Cover Geometric%' OR i.alt_text LIKE '%Chevron Bench Cover Geometric%' OR i.filename LIKE '%Chevron Bench Cover Geometric%') 
  AND i.published = 1 
  AND i.moderate = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-01 01:32:54'  OR i.publish_up IS NULL) 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-01 01:32:54' OR i.publish_down IS NULL) 
  AND i.access IN (1,1)

  GROUP BY i.id

  ORDER BY i.ordering 
  LIMIT 1000

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ALL	gallery_id,access,published,publish_up,publish_down,moderate	NO INDEX KEY COULD BE USED	NULL	NULL	58	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.16 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.12 ms
Preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.40 ms
Creating sort index	0.04 ms
Removing tmp table	0.07 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 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.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:765
12	igalleryModelcategory->getImagesList()	JROOT/components/com_igallery/models/category.php:858
11	igalleryModelcategory->getCategoryImagesList()	JROOT/components/com_igallery/views/category/view.html.php:163
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:86
6	require_once JROOT/components/com_igallery/igallery.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: 0.09 ms Query memory: 0.007 MB Memory before query: 9.515 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") 
  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.08 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.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 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.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_igallery/models/category.php:797
11	igalleryModelcategory->addComments()	JROOT/components/com_igallery/views/category/view.html.php:173
10	igalleryViewcategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_igallery/controller.php:48
8	IgalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_igallery/igallery.php:86
6	require_once JROOT/components/com_igallery/igallery.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.97 ms After last query: 9.16 ms Query memory: 0.007 MB Memory before query: 10.141 MB Rows returned: 6

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

  FROM joslr_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-04-01 01:32:54') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-01 01:32:54') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 168 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

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.09 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.20 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/irgc2019/index.php:95
7	require JROOT/templates/irgc2019/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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.51 ms After last query: 10.00 ms Query memory: 0.012 MB Memory before query: 10.871 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.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.00 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.01 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.]

13 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 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 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 m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM joslr_modules AS m 
  LEFT JOIN joslr_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN joslr_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_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'3734336631616638376665366231633734633038636231653037373536663436', 1, 1743471174, 0, '', 0

1 × UPDATE `joslr_extensions` 
  SET `params` = '{\"mediaversion\":\"5d89d8469e443817a36be6d9b23fdbc1\"}'

1 × UPDATE joslr_igallery 
  SET hits = hits + 1

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