Витрачений час на запит: 4.06 ms Після останнього запиту: 0.97 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 <= '2025-05-14 19:58:20')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-14 19:58:20')
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(183,256,893,1047,1677,1709,11724,11966,11999,12654,12724,12757,12848,13166,13167,13168,13193,13194,13231,13295,13307,13753,13871,14185,14197,14221,14222,14228,14229,15477,15687,16801,16850,16867,16892,17159,17200,17304,17318,17356,17372,17528,17628,17893,18028,18030,18080,18373,18637,18692,19223,19235,19532,19535,20038,20247,20327,20428,20511,20512,20565,20626,20628,21047,21265,21300,21657,22210,22211,22270,22867,22917,22978,23509,23511,24348,25057,25188,25212,25230,25236,25571,25572,25729,27169,27398,27399,27504,27664,27672,27761,27769,27933,27941,27968,28134,28417,33435,34214,34512,34602,34607,35032,35472,35507,35853,36145,36164,36187,36188,36508,36511,37225,39075,39127,39149,39352,39566,40285,40901,41614,43382,43383,43471,43476,45323,45361,45488,46097,46376,46657,46736,46745,47163,47224,47470,47678,47769,47832,47954,48067,48108,48404,48438,48445,48461,48473,48476,48477,48592,48621,48631,48649,48674,48715,48794,48823,48851,48884,48911,48960,49011,49136,49248,49250,49275,49290,49299,49314,49384,49391,49468,49496,49611,49615,49617,49719,49747,49779,49823,49825,49841,49843,49873,49876,49878,49945,50142,50193,50280,50315,50349,50401,50419,50451,50462,50465,50495,50507,50529,50538,50547,50584,50672,50771,50784,50860,50863,50868,50886,50911,50955,50967,50972,50973,50984,51050,51053,51089,51092,51140,51153,51166,51169,51200,51201,51213,51238,51288,51308,51397,51406,51450,51483,51485,51492,51539,51569,51595,51624,51635,51638,51640,51667,51670,51678,51749,51763,51788,51789,51791,51798,51802,51806,51808,51826,51854,51895,51929,51938,51960,51961,51981,52024,52070,52094,52099,52107,52112,52113,52114,52117,52120,52121,52125,52130,52144,52149,52155,52159,52170,52182,52184,52188,52189,52190,52192,52197,52207,52214,52218,52220,52229,52230,52236,52244,52256,52260,52276,52286,52290,52296,52299,52303,52307,52310,52316,52318,52330,52338,52342,52343,52346,52356,52365,52367,52368,52369,52379,52381,52385,52392,52394,52398,52405,52407,52414,52425,52427,52428,52429,52438,52445,52458,52460,52466,52467,52468,52476,52487,52488,52490,52492,52494,52495,52505,52506,52507,52511,52518,52523,52527,52535,52545,52546,52548,52561,52577,52589,52598,52600,52605,52609,52610,52613,52615,52619,52626,52631,52632,52633,52639,52646,52659,52666,52671,52675,52677,52687,52689,52690,52697,52699,52719,52728,52733,52738,52748,52750,52764,52765,52769,52777,52779,52781,52786,52790,52792,52800,52802,52812,52818,52832,52836,52839,52841,52854,52856,52876,52885,52888,52901,52904,52912,52921,52932,52935,52936,52951,52955,52962,52966,52967,52978,52989,52991,53005,53011,53014,53028,53029,53037,53040,53076,53093,53107,53118,53124,53128,53132,53147,53157,53161,53164,53174,53180,53181,53187,53189,53197,53207,53212,53216,53217,53218,53227,53239,53248,53250,53252,53253,53255,53257,53273,53274,53276,53282,53287,53293,53297,53301,53305,53312,53314,53319,53328,53330,53331,53337,53350,53368,53370,53375,53381,53400,53401,53402,53431,53438,53449,53464,53488,53507,53518,53531,53537,53541,53544,53570,53571,53572,53587,53592,53600,53614,53630,53642,53648,53654,53665,53673,53676,53698,53699,53720,53749,53751,53763,53771,53776,53791,53796,53826,53834,53843,53850,53851,53860,53867,53874,53893,53921,53956,53968,53973,53974,53989,53996,54000,54021,54059,54061,54091,54114,54126,54127,54132,54135,54196,54203,54214,54227,54232,54235,54241,54257,54285,54302,54351,54372,54383,54408,54409,54434,54442,54445,54453,54454,54455,54458,54468,54469,54470,54479,54480,54507,54520,54521,54523,54525,54527,54537,54543,54545,54551,54554,54570,54576,54577,54580,54613,54630,54631,54635,54641,54652,54655,54669,54671,54685,54691,54701,54710,54731,54746,54750,54752,54759,54762,54765,54769,54779,54788,54790,54792,54795,54813,54833,54844,54861,54873,54919,54920,54921,54923,54964,54979,54984,55000,55007,55031,55039,55040,55049,55054,55079,55086,55088,55111,55114,55136,55137,55142,55150,55162,55164,55168,55171,55186,55209,55211,55216,55222,55226,55228,55267,55276,55286,55289,55312,55323,55332,55333,55338,55340,55344,55353,55382,55385,55388,55397,55409,55418,55420,55424,55444,55463,55492,55498,55506,55507,55536,55537,55541,55545,55554,55560,55572,55595,55600,55614,55636,55647,55652,55653,55691,55700,55701,55714,55718,55725,55742,55761,55763,55774,55775,55776,55799,55801,55814,55815,55824,55830,55836,55839,55848,55868,55875,55883,55885,55892,55897,55913,55919,55921,55930,55931,55935,55937,55941,55942,55950,55967,55970,55973,55993,56001,56013,56021,56023,56028,56029,56051,56058,56059,56072,56078,56095,56107,56115,56122,56123,56127,56129,56143,56148,56157,56169,56171,56194,56196,56199,56202,56221,56223,56224,56238,56245,56264,56267,56268,56280,56282,56286,56298,56301,56302,56309,56316,56318,56320,56321,56323,56324,56329,56336,56340,56341,56345,56353,56357,56359,56364,56378,56379,56385,56389,56394,56399,56401,56405,56407,56410,56412,56413,56418,56419,56430,56440,56478,56491,56493,56496,56516,56521,56533,56534,56538,56575,56578,56581,56582,56586,56590,56596,56598,56599,56609,56614,56628,56650,56669,56674,56677,56678,56685,56696,56722,56730,56731,56741,56755,56768,56785,56798,56802,56821,56834,56843,56850,56858,56861,56881,56899,56900,56902,56925,56948,56950,56953,56959,56971,56972,56979,56996,56999,57006,57012,57063,57066,57073,57076,57077,57090,57091,57097,57101,57102,57108,57119,57122,57129,57134,57154,57163,57164,57169,57180,57188,57192,57196,57197,57199,57207,57213,57217,57220,57228,57238,57240,57272,57294,57296,57299,57339,57357,57378,57400,57402,57422,57426,57436,57460,57461,57463,57486,57497,57503,57508,57516,57525,57526,57527,57532,57545,57550,57559,57563,57597,57603,57606,57609,57611,57612,57619,57626,57635,57641,57643,57645,57654,57661,57662,57666,57676,57681,57682,57688,57693,57698,57703,57711,57730,57733,57735,57740,57743,57767,57774,57832,57837,57901,57909,57922,57934,57937,57940,57942,57944,57961,57964,57967,57972,57980,57983,58007,58049,58052,58063,58076,58083,58091,58097,58110,58112,58128,58132,58146,58149,58156,58166,58185,58196,58201,58222,58223,58230,58238,58245,58263,58264,58299,58310,58321,58332,58333,58334,58345,58347,58354,58357,58388,58396,58406,58412,58421,58426,58464,58470,58476,58501,58521,58529,58534,58538,58547,58556,58557,58560,58586,58588,58609,58619,58621,58630,58633,58650,58670,58685,58690,58715,58722,58739,58746,58762,58768,58769,58777,58791,58801,58802,58804,58808,58811,58812,58833,58838,58845,58848,58854,58864,58869,58886,58899,58925,58932,58939,58950,58976,58978,58985,58986,58991,59017,59025,59047,59051,59094,59099,59104,59107,59111,59142,59177,59181,59195,59218,59228,59238,59291,59306,59307,59313,59389,59391,59398,59403,59429,59435,59438,59442,59451,59479,59503,59553,59581,59588,59648,59651,59658,59665,59675,59680,59714,59724,59755,59763,59765,59839,59845,59858,59867,59870,59876,59884,59902,59941,59950,59955,59971,59984,59987,59990,59992,60000,60003,60021,60032,60038,60059,60066,60078,60099,60101,60109,60113,60146,60152,60215,60223,60238,60240,60241,60247,60269,60286,60296,60297,60331,60381,60391,60403,60411,60420,60432,60440,60468,60523,60527,60532,60547,60557,60564,60576,60594,60603,60629,60662,60663,60690,60702,60708,60710,60772,60841,60846,60856,60863,60882,60885,60887,60913,60916,60926,60934,60942,60970,60973,60987,61020,61035,61055,61056,61073,61090,61109,61116,61124,61132,61145,61148,61174,61176,61180,61184,61199,61224,61230,61231,61256,61257,61277,61295,61320,61325,61332,61339,61342,61360,61372,61381,61387,61397,61402,61405,61421,61427,61435,61436,61440,61446,61448,61449,61453,61456,61458,61463,61477,61486,61492,61495,61507,61510,61512,61527,61531,61535,61540,61578,61585,61586,61603,61604,61606,61610,61615,61634,61639,61648,61667,61682,61691,61717,61727,61730,61732,61751,61758,61765,61772,61778,61781,61823,61825,61861,61863,61864,61865,61875,61883,61884,61886,61895,61896,61898,61907,61945,61951,61955,61970,61971,61974,61979,61984,61985,61988,62024,62027,62049,62057,62058,62066,62072,62110,62111,62133,62137,62142,62149,62150,62152,62161,62183,62189,62216,62219,62220,62225,62231,62257,62261,62268,62276,62286,62298,62300,62315,62328,62332,62337,62345,62346,62354,62359,62363,62365,62370,62386,62391,62392,62400,62416,62420,62422,62424,62448,62470,62474,62477,62494,62514,62515,62516,62520,62529,62536,62543,62546,62563,62568,62576,62577,62596,62598,62605,62620,62623,62627,62628,62634,62638,62650,62659,62674,62675,62711,62721,62729,62790,62824,62825,62829,62832,62845,62846,62851,62854,62867,62870,62888,62911,62933,62948,62958,62964,62965,62968,62972,62973,62974,62981,63007,63015,63026,63034,63038,63100,63107,63125,63135,63152,63153,63161,63182,63185,63187,63196,63206,63207,63227,63231,63237,63255,63266,63285,63291,63297,63298,63307,63321,63334,63341,63344,63348,63351,63366,63368,63372,63375,63383,63389,63391,63393,63396,63414,63415,63420,63447,63481,63487,63488,63527,63536,63542,63558,63563,63564,63592,63600,63604,63613,63625,63642,63677,63684,63689,63694,63729,63741,63754,63791,63811,63822,63823,63841,63847,63865,63873,63876,63879,63885,63891,63893,63902,63904,63923,63941,63943,63945,63961,63970,63982,63983,64011,64033,64039,64070,64075,64077,64085,64115,64127,64136,64145,64149,64152,64157,64171,64173,64180,64184,64198,64219,64241,64266,64267,64287,64299,64313,64316,64335,64344,64351,64366,64391,64423,64430,64441,64442,64448,64450,64453,64467,64485,64487,64489,64497,64510,64511,64539,64554,64577,64595,64612,64617,64629,64638,64640,64646,64679,64682,64683,64688,64693,64704,64712,64718,64725,64735,64761,64799,64804,64806,64834,64846,64856,64907,64934,64958,64964,64970,64976,64988,65016,65023,65053,65054,65078,65090,65095,65104,65128,65130,65138,65146,65150,65158,65168,65169,65172,65188,65233,65237,65262,65268,65274,65276,65302,65335,65345,65352,65354,65359,65361,65370,65375,65381,65406,65410,65426,65427,65437,65448,65461,65464,65472,65475,65481,65482,65488,65495,65500,65535,65549,65563,65577,65589,65596,65615,65636,65653,65678,65684,65698,65740,65742,65764,65765,65807,65809,65831,65838,65850,65856,65859,65862,65866,65884,65910,65931,65933,65952,65960,65962,66007,66010,66016,66019,66073,66077,66080,66090,66098,66102,66106,66112,66131,66136,66140,66143,66155,66164,66187,66195,66203,66204,66209,66216,66261,66295,66374,66378,66383,66399,66426,66427,66434,66444,66445,66447,66451,66480,66498,66508,66528,66549,66553,66563,66588,66609,66631,66632,66646,66670,66678,66681,66682)
ORDER BY i.id DESC
LIMIT 5
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | <derived3> | ALL | distinct_key | ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ | NULL | NULL | 1717 | Використовуючи filesort |
1 | PRIMARY | i | eq_ref | PRIMARY,catid,language,idx_item | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
1 | PRIMARY | c | eq_ref | PRIMARY,category,published,access,trash,language,idx_category | PRIMARY | 4 | finclub_j201803.i.catid | 1 | Using where |
3 | DERIVED | NULL | NULL | NULL | ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ | NULL | NULL | NULL | No tables used |
Status | Duration |
---|
Starting | 0.03 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.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Sorting result | 0.00 ms |
Executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.20 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:668 |
13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:278 |
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:57 |
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:49 |