Витрачений час на запит: 10.24 ms Після останнього запиту: 0.18 ms
SELECT i.*, c.alias AS categoryalias
FROM js937_k2_items AS i
LEFT JOIN js937_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-09-21 06:02:53')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-09-21 06:02:53')
AND i.access IN(1,1,5)
AND i.language IN('uk-UA', '*')
AND c.access IN(1,1,5)
AND c.language IN('uk-UA', '*')
AND c.published = 1
AND c.trash = 0
AND i.id IN(14040,14498,21661,22274,23382,23627,25688,27118,28764,31084,31192,33957,34195,34574,35082,36231,36501,36708,37073,37226,38050,38145,38583,39119,39160,39175,39992,40000,40289,40347,40350,40497,40614,40620,40625,40651,40710,40750,40808,40811,40887,40957,41053,41070,41108,41172,41240,41250,41345,41347,41511,41642,41723,41766,41781,41830,41831,41846,41923,41942,42000,42373,42405,42447,42514,42516,42518,42589,42593,42627,42632,42676,42698,42718,42724,42753,42816,42915,42936,43106,43136,43143,43151,43266,43272,43309,43312,43334,43340,43381,43506,43508,43511,43541,43569,43654,43657,43840,43842,43901,44015,44056,44091,44124,44165,44171,44215,44219,44255,44257,44349,44446,44548,44568,44573,44581,44628,44656,44675,44685,44687,44691,44757,44765,44827,44885,44902,44954,45043,45076,45116,45273,45326,45360,45369,45372,45420,45422,45471,45503,45585,45590,45622,45650,45666,45685,45687,45740,45779,45796,45865,45870,45899,45974,46040,46150,46338,46348,46429,46473,46671,46700,46703,46709,46749,46753,46864,46866,46879,46884,46914,46975,47009,47069,47155,47170,47229,47234,47251,47273,47316,47320,47327,47334,47336,47350,47358,47362,47364,47368,47387,47395,47401,47427,47430,47433,47435,47441,47446,47473,47557,47587,47654,47714,47718,47759,47760,47781,47786,47802,47804,47808,47810,47812,47824,47829,47833,47837,47842,47886,47902,47910,47912,47946,47947,47957,47962,47984,47987,47995,48010,48031,48045,48081,48092,48131,48148,48150,48151,48178,48204,48215,48237,48242,48320,48353,48379,48383,48447,48449,48457,48484,48497,48501,48514,48564,48585,48596,48627,48662,48687,48693,48695,48713,48779,48792,48815,48817,48847,48852,48873,48894,48953,49040,49044,49088,49139,49163,49166,49175,49182,49183,49185,49204,49269,49272,49284,49344,49413,49549,49555,49610,49637,49671,49673,49679,49721,49722,49747,49760,49776,49787,49788,49855,49949,49990,49999,50032,50053,50060,50097,50099,50128,50168,50228,50229,50298,50319,50393,50408,50457,50504,50506,50524,50568,50570,50618,50691,50760,50805,50821,50837,50890,50897,50959,50961,50997,51020,51039,51049,51090,51103,51104,51156,51227,51375,51466,51467,51471,51474,51482,51503,51548,51573,51579,51593,51604,51608,51613,51619,51620,51622,51626,51627,51629,51669,51681,51706,51710,51738,51767,51812,51885,51964,52208,52235,52246,52421,52802,53114,53231,53312,53519,53560,53617,54039,54092,54464,54809,54983,55010,55103,55154,55204,55719,56042,56082,56207,56210,56275,56354,56428,56484,56832,56958,57027,57155,57156,57261,57323,57350,57440,57448,57510,57557,57576,58194,58303,58355,58449,58473,58474,58555,58743,58799,58842,59067,59204,59279,59377,59446,59468,59619,59986,60047,60067,60178,60486,60563,60644,60702,60830,60834,61011,61148,61173,61279,61316,61336,61378,61450,61451,61457,61494,61509,61522,61540,61796,61830,62017,62153,62165,62229,62249,62258,62452,62658,62988,62996,63271,63326,63349,63419,63444,63523,63594,63595,63654,63696,63935,63999,64066,64685,64831,65012,65066,65854,65989,66141,66461,66512,66604,66611,66743,66783,67017,67099,67224,67470,67742,67782,67818,67850,67884,68000,68103,68595,68613,68966,68971,69099,69320,69347,69349,69542,69802,70092,70117,70146,70170,70192,70300,70386,70588,70715,70789,70805,71078,71174,71256,71258,71327,71360)
ORDER BY i.id DESC
LIMIT 5| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | range | PRIMARY,catid,language,idx_items_common,idx_items_common_backend | PRIMARY | 4 | NULL | 533 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash,language,idx_category | PRIMARY | 4 | finclub_j201803.i.catid | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.17 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Виклик | Номер файлу та рядка |
|---|
| 15 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:648 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:281 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:78 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:58 |
| 6 | require_once JROOT/components/com_k2/k2.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:191 |