Где купить

1. JBZoo App licence is no valid! Please, register the copy or contact to support
   

   Call stack
   #	Function	Location
   1	JError::raise()	JROOT/libraries/legacy/error/error.php:299
   2	JError::raiseWarning()
   3	call_user_func_array()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
   4	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/error.php:27
   5	ErrorHelper->__call()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbnotify.php:29
   6	ErrorHelper->raiseWarning()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbnotify.php:29
   7	JBNotifyHelper->warning()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
   8	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
   9	require_once()	JROOT/libraries/src/Component/ComponentHelper.php:402
   10	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   11	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   12	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   13	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   14	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1779121257,
                "last": 1779121257,
                "now": 1779121257
            },
            "token": "mM8zU87aKYQXiYIOv5jKdI1DYQ9aIAmf"
        },
        "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
        },
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-name": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-fixedheader": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-headerstyle": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-color": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-pageimg-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-pageimg-property-repeat": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-pageimg-property-attachment": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-pageimg-property-size": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-pageimg-property-position": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-pageimg-parallax-speed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-text": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-heading": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-link": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-link-hover": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-page-shadow": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-logo-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-logo-custom-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-font-family": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-font-size-is": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-font-class": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rttop-color": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rttop-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rttop-topimg-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rttop-topimg-property-repeat": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rttop-topimg-property-attachment": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rttop-topimg-property-size": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rttop-topimg-property-position": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rttop-topimg-parallax-speed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rttop-text": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rttop-heading": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rttop-link": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rttop-link-hover": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rttop-shadow": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtheader-color": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtheader-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtheader-headerimg-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtheader-headerimg-property-repeat": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtheader-headerimg-property-attachment": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtheader-headerimg-property-size": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtheader-headerimg-property-position": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtheader-headerimg-parallax-speed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtheader-text": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtheader-heading": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtheader-link": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtheader-link-hover": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtheader-shadow": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-fixed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-color": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-showcaseimg-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-showcaseimg-property-repeat": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-showcaseimg-property-attachment": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-showcaseimg-property-size": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-showcaseimg-property-position": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-showcaseimg-parallax-speed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-text": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-heading": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-link": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-link-hover": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtshowcase-shadow": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfeature-color": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfeature-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfeature-featureimg-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfeature-featureimg-property-repeat": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfeature-featureimg-property-attachment": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfeature-featureimg-property-size": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfeature-featureimg-property-position": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfeature-featureimg-parallax-speed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfeature-text": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfeature-heading": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfeature-link": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfeature-link-hover": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfeature-shadow": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtutility-color": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtutility-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtutility-utilityimg-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtutility-utilityimg-property-repeat": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtutility-utilityimg-property-attachment": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtutility-utilityimg-property-size": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtutility-utilityimg-property-position": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtutility-utilityimg-parallax-speed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtutility-text": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtutility-heading": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtutility-link": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtutility-link-hover": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtutility-shadow": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbreadcrumbs-color": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbreadcrumbs-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbreadcrumbs-breadcrumbsimg-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbreadcrumbs-breadcrumbsimg-property-repeat": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbreadcrumbs-breadcrumbsimg-property-attachment": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbreadcrumbs-breadcrumbsimg-property-size": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbreadcrumbs-breadcrumbsimg-property-position": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbreadcrumbs-breadcrumbsimg-parallax-speed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbreadcrumbs-text": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbreadcrumbs-heading": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbreadcrumbs-link": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbreadcrumbs-link-hover": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbreadcrumbs-shadow": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmaintop-color": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmaintop-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmaintop-maintopimg-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmaintop-maintopimg-property-repeat": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmaintop-maintopimg-property-attachment": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmaintop-maintopimg-property-size": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmaintop-maintopimg-property-position": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmaintop-maintopimg-parallax-speed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmaintop-text": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmaintop-heading": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmaintop-link": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmaintop-link-hover": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmaintop-shadow": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmainbottom-color": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmainbottom-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmainbottom-mainbottomimg-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmainbottom-mainbottomimg-property-repeat": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmainbottom-mainbottomimg-property-attachment": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmainbottom-mainbottomimg-property-size": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmainbottom-mainbottomimg-property-position": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmainbottom-mainbottomimg-parallax-speed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmainbottom-text": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmainbottom-heading": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmainbottom-link": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmainbottom-link-hover": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtmainbottom-shadow": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtextension-color": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtextension-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtextension-extensionimg-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtextension-extensionimg-property-repeat": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtextension-extensionimg-property-attachment": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtextension-extensionimg-property-size": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtextension-extensionimg-property-position": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtextension-extensionimg-parallax-speed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtextension-text": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtextension-heading": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtextension-link": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtextension-link-hover": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtextension-shadow": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbottom-color": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbottom-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbottom-bottomimg-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbottom-bottomimg-property-repeat": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbottom-bottomimg-property-attachment": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbottom-bottomimg-property-size": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbottom-bottomimg-property-position": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbottom-bottomimg-parallax-speed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbottom-text": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbottom-heading": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbottom-link": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbottom-link-hover": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtbottom-shadow": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfooter-color": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfooter-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfooter-footerimg-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfooter-footerimg-property-repeat": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfooter-footerimg-property-attachment": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfooter-footerimg-property-size": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfooter-footerimg-property-position": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfooter-footerimg-parallax-speed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfooter-text": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfooter-heading": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfooter-link": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfooter-link-hover": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtfooter-shadow": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtcopyright-color": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtcopyright-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtcopyright-copyrightimg-image": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtcopyright-copyrightimg-property-repeat": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtcopyright-copyrightimg-property-attachment": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtcopyright-copyrightimg-property-size": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtcopyright-copyrightimg-property-position": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtcopyright-copyrightimg-parallax-speed": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtcopyright-text": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtcopyright-heading": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtcopyright-link": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtcopyright-link-hover": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-rtcopyright-shadow": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-menu-type": null,
        "plussone-9b3a0c7b3d9ed8678c2695ba9c61dae1-layout-mode": null
    }
}

Время

Память

49 SQL-запросов зафиксировано 44.56 ms

1. Время запроса: 0.19 ms Память запроса: 0.021 MB Память до запроса: 1.646 MB Выбрано строк: 0

   SELECT `data`
   
     FROM `xt1k5_session`
   
     WHERE `session_id` = X'6233396263396538303366633437653833303563663936666139653666396239'

   План SQL-запросов (Explain)

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

   Профилирование SQL-запросов

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

   Стек вызовов

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

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

2. Время запроса: 0.10 ms После последнего запроса: 0.77 ms Память запроса: 0.013 MB Память до запроса: 1.702 MB Выбрано строк: 0

   SELECT `session_id`
   
     FROM `xt1k5_session`
   
     WHERE `session_id` = X'6233396263396538303366633437653833303563663936666139653666396239' 
     LIMIT 1

   План SQL-запросов (Explain)

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

   Профилирование SQL-запросов

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   executing	0.00 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.00 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

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

3. Время запроса: 0.19 ms После последнего запроса: 0.16 ms Память запроса: 0.010 MB Память до запроса: 1.719 MB

   INSERT INTO `xt1k5_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6233396263396538303366633437653833303563663936666139653666396239', 1, 1779121257, 0, '', 0)

   План SQL-запросов (Explain)

   EXPLAIN не доступен для запроса: INSERT INTO `xt1k5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6233396263396538303366633437653833303563663936666139653666396239', 1, 1779121257, 0, '', 0)

   Профилирование SQL-запросов

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   update	0.07 ms
   end	0.00 ms
   query end	0.03 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	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

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

4. Время запроса: 0.43 ms После последнего запроса: 1.04 ms Память запроса: 0.023 MB Память до запроса: 1.793 MB Выбрано строк: 45

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `xt1k5_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   План SQL-запросов (Explain)

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

   Профилирование SQL-запросов

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.19 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Стек вызовов

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

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

5. Время запроса: 0.14 ms После последнего запроса: 1.11 ms Память запроса: 0.015 MB Память до запроса: 1.899 MB Выбрано строк: 5

   SELECT id, rules
   
     FROM `xt1k5_viewlevels`

   План SQL-запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	xt1k5_viewlevels	NULL	ALL	NULL	Индекс не используется	NULL	NULL	5	100.00	NULL

   Профилирование SQL-запросов

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

   Стек вызовов

   #	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

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

6. Время запроса: 0.18 ms После последнего запроса: 0.16 ms Память запроса: 0.015 MB Память до запроса: 1.924 MB Выбрано строк: 2

   SELECT b.id
   
     FROM xt1k5_usergroups AS a
   
     LEFT JOIN xt1k5_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   План SQL-запросов (Explain)

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

   Профилирование SQL-запросов

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

   Стек вызовов

   #	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

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

7. Время запроса: 1.88 ms После последнего запроса: 0.35 ms Память запроса: 0.020 MB Память до запроса: 1.963 MB Выбрано строк: 112

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM xt1k5_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   План SQL-запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	xt1k5_extensions	NULL	ref	extension	extension	82	const	131	0.60	Using index condition; Using where; Используется filesort

   Профилирование SQL-запросов

   Status	Duration
   starting	0.06 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.06 ms
   preparing	0.03 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	1.50 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   cleaning up	0.00 ms

   Стек вызовов

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

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

8. Время запроса: 0.29 ms После последнего запроса: 7.87 ms Память запроса: 0.013 MB Память до запроса: 2.560 MB Выбрано строк: 1

   SELECT `enabled`
   
     FROM `xt1k5_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   План SQL-запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	xt1k5_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:71
   7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

9. Время запроса: 0.59 ms После последнего запроса: 20.27 ms Память запроса: 0.026 MB Память до запроса: 3.033 MB Выбрано строк: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `xt1k5_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   План SQL-запросов (Explain)

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

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Caller	File and line number
   20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
   17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/calculoid/calculoid.php:36
   9	plgSystemCalculoid->onAfterInitialise()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

10. Время запроса: 0.26 ms После последнего запроса: 0.30 ms Память запроса: 0.018 MB Память до запроса: 3.041 MB

    UPDATE `xt1k5_extensions`
    
      SET `params` = '{\"mediaversion\":\"a64ad306aa4c429caf375d6ffe505453\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    План SQL-запросов (Explain)

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

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/calculoid/calculoid.php:36
    9	plgSystemCalculoid->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

11. Время запроса: 0.23 ms После последнего запроса: 24.56 ms Память запроса: 0.021 MB Память до запроса: 5.635 MB

    CREATE TABLE IF NOT EXISTS `xt1k5_zoo_jbzoo_config` (`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
     `
      group` VARCHAR(50) NULL DEFAULT NULL,
     `key` VARCHAR(50) NULL DEFAULT NULL,
     `value` TEXT NULL,
     `type` VARCHAR(10) NULL DEFAULT 'string',
     PRIMARY KEY (`id`),
     UNIQUE INDEX `group_key` (`
      group`, `key`),
     INDEX `
      group` (`
      group`),
     INDEX `key` (`key`)) COLLATE='utf8_general_ci' ENGINE=MyISAM;

    План SQL-запросов (Explain)

    EXPLAIN не доступен для запроса: CREATE TABLE IF NOT EXISTS `xt1k5_zoo_jbzoo_config` (`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `group` VARCHAR(50) NULL DEFAULT NULL, `key` VARCHAR(50) NULL DEFAULT NULL, `value` TEXT NULL, `type` VARCHAR(10) NULL DEFAULT 'string', PRIMARY KEY (`id`), UNIQUE INDEX `group_key` (`group`, `key`), INDEX `group` (`group`), INDEX `key` (`key`)) COLLATE='utf8_general_ci' ENGINE=MyISAM;

    Профилирование SQL-запросов

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    After create	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    17	DatabaseHelper->query()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:278
    16	JBTablesHelper->createTable()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:176
    15	JBTablesHelper->checkConfig()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:54
    14	JBModelConfig->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:41
    13	JBModelConfig::model()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:52
    12	JBZooSystemPlugin->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:40
    11	JBZooSystemPlugin::getInstance()	JROOT/plugins/system/jbzoo/jbzoo.php:86
    10	plgSystemJBZoo->_initFramework()	JROOT/plugins/system/jbzoo/jbzoo.php:115
    9	plgSystemJBZoo->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

12. Время запроса: 0.25 ms После последнего запроса: 0.24 ms Память запроса: 0.026 MB Память до запроса: 5.662 MB Выбрано строк: 45

    SELECT CONCAT_WS(".", `
      group`, `key`) as group_key, 
    	`value`, 
    	`type`
    
      FROM xt1k5_zoo_jbzoo_config
    
      LIMIT 1000

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	xt1k5_zoo_jbzoo_config	NULL	ALL	NULL	Индекс не используется	NULL	NULL	45	100.00	NULL

    Профилирование SQL-запросов

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.09 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:154
    17	JBModel->_query()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:106
    16	JBModel->fetchAll()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:187
    15	JBModelConfig->_init()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:55
    14	JBModelConfig->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:41
    13	JBModelConfig::model()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:52
    12	JBZooSystemPlugin->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:40
    11	JBZooSystemPlugin::getInstance()	JROOT/plugins/system/jbzoo/jbzoo.php:86
    10	plgSystemJBZoo->_initFramework()	JROOT/plugins/system/jbzoo/jbzoo.php:115
    9	plgSystemJBZoo->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

13. Время запроса: 0.96 ms После последнего запроса: 4.52 ms Память запроса: 0.032 MB Память до запроса: 6.071 MB Выбрано строк: 22

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM xt1k5_menu AS m
    
      LEFT JOIN xt1k5_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	116	3.33	Using index condition; Using where; Используется filesort
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	vozorn_profteplo.m.component_id	1	100.00	Using where

    Профилирование SQL-запросов

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.62 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

14. Время запроса: 0.38 ms После последнего запроса: 5.96 ms Память запроса: 0.025 MB Память до запроса: 6.452 MB Выбрано строк: 1
    Повторяющиеся запросы: #42  #43

    SELECT id, home, template, s.params
    
      FROM xt1k5_template_styles as s
    
      LEFT JOIN xt1k5_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1	100.00	NULL
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	vozorn_profteplo.s.template,const	1	4.63	Using index condition; Using where

    Профилирование SQL-запросов

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.09 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/plazart/includes/core/plazart.php:226
    10	Plazart::detect()	JROOT/plugins/system/plazart/plazart.php:44
    9	plgSystemPlazart->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

15. Время запроса: 0.58 ms После последнего запроса: 8.57 ms Память запроса: 0.014 MB Память до запроса: 6.709 MB Выбрано строк: 1

    SELECT *
    
      FROM xt1k5_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	xt1k5_languages	NULL	ALL	NULL	Индекс не используется	NULL	NULL	1	100.00	Using where; Используется filesort

    Профилирование SQL-запросов

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

    Стек вызовов

    #	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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

16. Время запроса: 0.25 ms После последнего запроса: 3.25 ms Память запроса: 0.020 MB Память до запроса: 6.855 MB Выбрано строк: 1

    SELECT * 
      FROM xt1k5_zoo_application 
      WHERE id = 2

    План SQL-запросов (Explain)

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

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    12	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:397
    11	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
    10	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:141
    9	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
    8	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/zoo.php:83
    7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

17. Время запроса: 2.28 ms После последнего запроса: 17040.27 ms Память запроса: 0.029 MB Память до запроса: 8.439 MB Выбрано строк: 44

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `xt1k5_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_contactus','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry','com_installer','com_jce','com_joomlaupdate','com_jsecure','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_offlajn_installer','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_tags','com_templates','com_uniterevolution2','com_users','com_weblinks','com_wrapper','com_zoo')

    План SQL-запросов (Explain)

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

    Профилирование SQL-запросов

    Status	Duration
    starting	0.30 ms
    checking permissions	0.01 ms
    Opening tables	0.14 ms
    init	0.10 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.34 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	1.09 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
    13	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
    12	UserAppHelper->get()	JROOT/components/com_zoo/controllers/default.php:214
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

18. Время запроса: 0.10 ms После последнего запроса: 0.79 ms Память запроса: 0.020 MB Память до запроса: 8.546 MB

    
      SET SESSION group_concat_max_len = 1048576

    План SQL-запросов (Explain)

    EXPLAIN не доступен для запроса: SET SESSION group_concat_max_len = 1048576

    Профилирование SQL-запросов

    Status	Duration
    starting	0.03 ms
    Opening tables	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    15	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/category.php:193
    14	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:432
    13	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:456
    12	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:214
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

19. Время запроса: 3.39 ms После последнего запроса: 0.22 ms Память запроса: 0.027 MB Память до запроса: 8.572 MB Выбрано строк: 1

    SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
      FROM xt1k5_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
      LEFT JOIN xt1k5_zoo_category_item as ci 
      ON ci.category_id = c.id 
      LEFT JOIN xt1k5_zoo_item AS i USE INDEX (MULTI_INDEX2) 
      ON ci.item_id = i.id 
      AND i.access IN (1,5) 
      AND i.state = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-05-18 16:20:57') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-18 16:20:57') 
      WHERE c.application_id = 2 
      AND c.published = 1 
      GROUP BY c.id

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ref	PRIMARY,ALIAS_INDEX,PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	APPLICATIONID_ID_INDEX	5	const,const	1	100.00	Using index condition
    1	SIMPLE	ci	NULL	ref	PRIMARY,CATEGORYID_INDEX	CATEGORYID_INDEX	4	vozorn_profteplo.c.id	101	100.00	Using index
    1	SIMPLE	i	NULL	ref	MULTI_INDEX2	MULTI_INDEX2	4	vozorn_profteplo.ci.item_id	1	100.00	Using where; Using index

    Профилирование SQL-запросов

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.56 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.08 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	2.19 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.06 ms
    closing tables	0.06 ms
    freeing items	0.05 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    18	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:423
    17	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
    16	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
    15	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:219
    14	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:432
    13	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:456
    12	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:214
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

20. Время запроса: 12.42 ms После последнего запроса: 5.97 ms Память запроса: 0.028 MB Память до запроса: 8.900 MB Выбрано строк: 20

    SELECT a.* 
      FROM xt1k5_zoo_item AS a 
      LEFT JOIN xt1k5_zoo_category_item AS b 
      ON a.id = b.item_id 
      LEFT JOIN xt1k5_zoo_search_index AS s 
      ON a.id = s.item_id 
      AND s.element_id IN ('_jbzoo_0_field__none', '_jbzoo_0_mode_s', '_jbzoo_0_order_asc') 
      WHERE a.application_id = 2 
      AND a.access IN (1,5) 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-18 16:20:57') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-18 16:20:57') 
      AND b.category_id  = 9 
      GROUP BY a.id 
      ORDER BY a.priority DESC, s.value 
      LIMIT 240,20

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	range	PRIMARY,ALIAS_INDEX,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,CREATED_BY_INDEX,NAME_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX,SEARCH_FULLTEXT	STATE_INDEX	1	NULL	308	24.51	Using index condition; Using where; Using temporary; Используется filesort
    1	SIMPLE	b	NULL	eq_ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	8	const,vozorn_profteplo.a.id	1	100.00	Using index
    1	SIMPLE	s	NULL	ref	PRIMARY	PRIMARY	4	vozorn_profteplo.a.id	6	100.00	Using where

    Профилирование SQL-запросов

    Status	Duration
    starting	0.14 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.44 ms
    init	0.10 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.31 ms
    preparing	0.08 ms
    Creating tmp table	0.06 ms
    Sorting for group	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	9.07 ms
    Creating sort index	1.73 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.22 ms
    query end	0.03 ms
    closing tables	0.04 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    14	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:423
    13	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:475
    12	ItemTable->getByCategory()	JROOT/components/com_zoo/controllers/default.php:234
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

21. Время запроса: 1.00 ms После последнего запроса: 9.40 ms Память запроса: 0.041 MB Память до запроса: 10.073 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1000 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1000 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

22. Время запроса: 0.55 ms После последнего запроса: 25.07 ms Память запроса: 0.041 MB Память до запроса: 10.538 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1001 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1001 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

23. Время запроса: 0.75 ms После последнего запроса: 10.03 ms Память запроса: 0.041 MB Память до запроса: 10.892 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1002 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1002 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

24. Время запроса: 0.93 ms После последнего запроса: 10.30 ms Память запроса: 0.041 MB Память до запроса: 11.246 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1003 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1003 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

    Status	Duration
    starting	0.10 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.09 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.15 ms
    executing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.12 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

25. Время запроса: 0.84 ms После последнего запроса: 24.82 ms Память запроса: 0.041 MB Память до запроса: 11.600 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1004 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1004 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

26. Время запроса: 0.63 ms После последнего запроса: 10.25 ms Память запроса: 0.041 MB Память до запроса: 11.954 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1005 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1005 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.09 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    optimizing	0.00 ms
    statistics	0.00 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sending data	0.10 ms
    executing	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.00 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

27. Время запроса: 0.44 ms После последнего запроса: 10.72 ms Память запроса: 0.041 MB Память до запроса: 12.308 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1006 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1006 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

28. Время запроса: 0.52 ms После последнего запроса: 17.41 ms Память запроса: 0.041 MB Память до запроса: 12.677 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1007 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1007 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

29. Время запроса: 0.44 ms После последнего запроса: 10.76 ms Память запроса: 0.041 MB Память до запроса: 13.031 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1008 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1008 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

30. Время запроса: 0.70 ms После последнего запроса: 24.01 ms Память запроса: 0.041 MB Память до запроса: 13.385 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1009 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1009 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.10 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sending data	0.18 ms
    executing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

31. Время запроса: 0.63 ms После последнего запроса: 10.70 ms Память запроса: 0.041 MB Память до запроса: 13.739 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1010 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1010 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

32. Время запроса: 1.03 ms После последнего запроса: 12.52 ms Память запроса: 0.041 MB Память до запроса: 14.093 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1011 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1011 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

    Status	Duration
    starting	0.13 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.10 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.21 ms
    executing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.02 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.05 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

33. Время запроса: 0.48 ms После последнего запроса: 27.84 ms Память запроса: 0.041 MB Память до запроса: 14.448 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1012 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1012 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    optimizing	0.00 ms
    statistics	0.00 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sending data	0.11 ms
    executing	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

34. Время запроса: 0.48 ms После последнего запроса: 10.93 ms Память запроса: 0.041 MB Память до запроса: 14.803 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1013 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1013 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    optimizing	0.00 ms
    statistics	0.00 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sending data	0.13 ms
    executing	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

35. Время запроса: 0.43 ms После последнего запроса: 12.52 ms Память запроса: 0.041 MB Память до запроса: 15.157 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1014 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1014 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

36. Время запроса: 0.81 ms После последнего запроса: 24.80 ms Память запроса: 0.041 MB Память до запроса: 15.511 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1015 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1015 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

37. Время запроса: 0.43 ms После последнего запроса: 18.27 ms Память запроса: 0.041 MB Память до запроса: 15.865 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1016 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1016 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

38. Время запроса: 0.91 ms После последнего запроса: 28.97 ms Память запроса: 0.041 MB Память до запроса: 16.219 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1017 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1017 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

39. Время запроса: 0.50 ms После последнего запроса: 10.83 ms Память запроса: 0.041 MB Память до запроса: 16.573 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1018 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1018 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    optimizing	0.00 ms
    statistics	0.00 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sending data	0.12 ms
    executing	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

40. Время запроса: 0.41 ms После последнего запроса: 11.84 ms Память запроса: 0.041 MB Память до запроса: 16.927 MB Выбрано строк: 1

    SELECT b.id 
      FROM xt1k5_zoo_category_item AS a JOIN xt1k5_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1019 
      AND b.published = 1 UNION SELECT 0 
      FROM xt1k5_zoo_category_item AS a 
      WHERE a.item_id=1019 
      AND a.category_id = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	Using index
    1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	vozorn_profteplo.a.category_id	1	100.00	Using where
    2	UNION	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table
    NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	Using temporary

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
    27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    26	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    25	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php:20
    21	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/item/gde-kupit/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    19	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:327
    18	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:257
    17	JBLayoutHelper->columns()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php:23
    16	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/renderer/items/_default.php	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:158
    15	JBLayoutHelper->render()	JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php:49
    14	include JROOT/media/zoo/applications/jbuniversal/templates/catalog/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    11	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
    9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
    8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
    7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
    6	require_once JROOT/components/com_zoo/zoo.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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

41. Время запроса: 0.49 ms После последнего запроса: 35.01 ms Память запроса: 0.020 MB Память до запроса: 17.429 MB Выбрано строк: 16

    SELECT *
    
      FROM xt1k5_rsform_config

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	xt1k5_rsform_config	NULL	ALL	NULL	Индекс не используется	NULL	NULL	16	100.00	NULL

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
    13	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
    12	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
    11	RSFormProConfig::getInstance()	JROOT/administrator/components/com_rsform/helpers/rsform.php:343
    10	RSFormProHelper::readConfig()	JROOT/plugins/system/rsfpregistration/rsfpregistration.php:43
    9	plgSystemRSFPRegistration->canRun()	JROOT/plugins/system/rsfpregistration/rsfpregistration.php:638
    8	plgSystemRSFPRegistration->onAfterDispatch()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

42. Время запроса: 0.47 ms После последнего запроса: 31.61 ms Память запроса: 0.024 MB Память до запроса: 19.850 MB Выбрано строк: 1
    Повторяющиеся запросы: #14  #43

    SELECT id, home, template, s.params
    
      FROM xt1k5_template_styles as s
    
      LEFT JOIN xt1k5_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1	100.00	NULL
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	vozorn_profteplo.s.template,const	1	4.63	Using index condition; Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
    15	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:65
    14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
    13	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
    12	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
    11	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
    10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
    9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/wt_plussone_jom/lib/gantry/gantry.php:21
    8	require_once JROOT/templates/wt_plussone_jom/lib/gantry/gantry.php	JROOT/templates/wt_plussone_jom/index.php:12
    7	require JROOT/templates/wt_plussone_jom/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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

43. Время запроса: 0.33 ms После последнего запроса: 1.75 ms Память запроса: 0.025 MB Память до запроса: 19.938 MB Выбрано строк: 1
    Повторяющиеся запросы: #14  #42

    SELECT id, home, template, s.params
    
      FROM xt1k5_template_styles as s
    
      LEFT JOIN xt1k5_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1	100.00	NULL
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	vozorn_profteplo.s.template,const	1	4.63	Using index condition; Using where

    Профилирование SQL-запросов

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
    16	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
    15	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
    14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
    13	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
    12	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
    11	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
    10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
    9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/wt_plussone_jom/lib/gantry/gantry.php:21
    8	require_once JROOT/templates/wt_plussone_jom/lib/gantry/gantry.php	JROOT/templates/wt_plussone_jom/index.php:12
    7	require JROOT/templates/wt_plussone_jom/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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

44. Время запроса: 0.42 ms После последнего запроса: 19.60 ms Память запроса: 0.025 MB Память до запроса: 20.429 MB Выбрано строк: 0
    Повторяющиеся запросы: #46

    SELECT a.params
    
      FROM xt1k5_advancedmodules AS a
    
      WHERE a.moduleid = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table

    Профилирование SQL-запросов

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.24 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:340
    17	plgSystemAdvancedModuleHelper->getAdvancedParams()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:152
    16	plgSystemAdvancedModuleHelper->onPrepareModuleList()	Same as call in the line below.
    15	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
    14	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    13	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
    12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
    9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
    8	Gantry->countModules()	JROOT/templates/wt_plussone_jom/index.php:79
    7	require JROOT/templates/wt_plussone_jom/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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

45. Время запроса: 3.33 ms После последнего запроса: 7.10 ms Память запроса: 0.062 MB Память до запроса: 20.461 MB Выбрано строк: 40

    SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
    
      FROM xt1k5_modules AS m
    
      LEFT JOIN xt1k5_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      LEFT JOIN xt1k5_advancedmodules as am 
      ON am.moduleid = m.id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND m.client_id = 0 
      AND m.access IN (1,1,5)
    
      ORDER BY m.ordering, m.id

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	published,newsfeeds	published	5	NULL	43	10.00	Using index condition; Using where; Используется filesort
    1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	vozorn_profteplo.m.id	1	100.00	Using where
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	vozorn_profteplo.m.module,const	1	10.00	Using index condition; Using where

    Профилирование SQL-запросов

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.45 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	2.24 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.06 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/modulehelper.php:455
    11	JModuleHelper::load()	JROOT/plugins/system/advancedmodules/modulehelper.php:102
    10	JModuleHelper::getModules()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:60
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/wt_plussone_jom/index.php:100
    7	require JROOT/templates/wt_plussone_jom/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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

46. Время запроса: 0.29 ms После последнего запроса: 1.99 ms Память запроса: 0.023 MB Память до запроса: 20.834 MB Выбрано строк: 0
    Повторяющиеся запросы: #44

    SELECT a.params
    
      FROM xt1k5_advancedmodules AS a
    
      WHERE a.moduleid = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table

    Профилирование SQL-запросов

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    17	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:340
    16	plgSystemAdvancedModuleHelper->getAdvancedParams()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:152
    15	plgSystemAdvancedModuleHelper->onPrepareModuleList()	Same as call in the line below.
    14	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/advancedmodules/modulehelper.php:508
    11	JModuleHelper::load()	JROOT/plugins/system/advancedmodules/modulehelper.php:102
    10	JModuleHelper::getModules()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:60
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/wt_plussone_jom/index.php:100
    7	require JROOT/templates/wt_plussone_jom/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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

47. Время запроса: 0.31 ms После последнего запроса: 6.20 ms Память запроса: 0.025 MB Память до запроса: 20.801 MB Выбрано строк: 1

    SELECT ts.template
    
      FROM xt1k5_template_styles AS ts
    
      INNER JOIN xt1k5_menu AS m 
      ON ts.id=m.template_style_id
    
      WHERE m.id = 331 
      AND m.template_style_id != 0

    План SQL-запросов (Explain)

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

    Профилирование SQL-запросов

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:98
    16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:71
    15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:22
    14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
    13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/wt_plussone_jom/features/dropdownmenu.php:56
    10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:65
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/wt_plussone_jom/index.php:100
    7	require JROOT/templates/wt_plussone_jom/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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

48. Время запроса: 0.71 ms После последнего запроса: 26.41 ms Память запроса: 0.030 MB Память до запроса: 21.124 MB Выбрано строк: 8

    SHOW FULL COLUMNS 
      FROM `xt1k5_template_styles`

    План SQL-запросов (Explain)

    EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `xt1k5_template_styles`

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    17	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:328
    16	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
    15	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
    14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    13	plgSystemGantry->onBeforeCompileHead()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

49. Время запроса: 0.21 ms После последнего запроса: 1.07 ms Память запроса: 0.024 MB Память до запроса: 21.181 MB Выбрано строк: 1

    SELECT *
    
      FROM xt1k5_template_styles
    
      WHERE `id` = '46'

    План SQL-запросов (Explain)

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

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    15	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
    14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    13	plgSystemGantry->onBeforeCompileHead()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---