Tiempo de la consulta: 6.39 ms Después de la última consulta: 1.65 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.406 MB Filas devueltas: 5
SELECT i.*, c.alias AS categoryalias
FROM av04h_k2_items AS i
LEFT JOIN av04h_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 <= '2024-05-06 03:04:37')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 03:04:37')
AND i.access IN(1,1,2,3,5)
AND c.access IN(1,1,2,3,5)
AND c.published = 1
AND c.trash = 0
AND i.id IN(1,5,7,9,11,14,17,29,39,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,62,63,65,71,73,78,81,83,85,86,87,88,89,110,111,125,149,155,164,174,177,188,189,190,196,200,204,205,214,221,226,234,240,246,248,249,255,259,262,263,271,279,285,291,299,303,325,331,349,353,362,366,391,398,405,412,415,416,420,421,422,423,424,426,427,428,429,431,441,450,458,472,477,481,484,485,495,496,501,503,510,512,525,529,530,537,542,546,547,560,563,566,567,572,574,575,593,607,619,659,662,663,666,667,674,686,697,705,708,709,710,711,712,713,746,756,760,769,783,785,800,802,805,806,808,823,832,835,850,853,862,863,868,869,873,885,886,910,923,933,939,940,954,969,974,977,982,983,986,999,1004,1005,1011,1021,1055,1091,1095,1101,1102,1114,1119,1158,1182,1202,1205,1207,1216,1223,1226,1231,1247,1252,1253,1255,1265,1268,1271,1276,1277,1278,1279,1289,1308,1309,1319,1347,1353,1357,1363,1409,1410,1428,1432,1434,1441,1444,1485,1509,1538,1555,1557,1600,1606,1619,1629,1648,1664,1675,1693,1694,1698,1718,1724,1768,1771,1794,1795,1796,1808,1810,1843,1846,1854,1855,1862,1866,1867,1878,1899,1918,1920,1930,1960,1961,1975,1984,1994,1995,2001,2008,2013,2015,2035,2075,2088,2108,2137,2155,2157,2161,2208,2272,2293,2328,2402,2455,2527,2532,2551,2586,2597,2638,2643,2647,2733,2814,2824,2825,2837,2843,2851,2883,2888,2954,2960,3020,3027,3051,3055,3097,3100,3106,3107,3147,3169,3174,3207,3212,3325,3364,3368,3369,3387,3402,3408,3409,3412,3417,3454,3473,3474,3520,3548,3552,3554,3577,3590,3648,3650,3663,3682,3683,3689,3748,3853,3858,3872,3884,3898,3913,3919,3922,3940,3962,3980,3991,3993,4034,4050,4063,4068,4110,4116,4129,4153,4309,4310,4327,4409,4410,4436,4445,4453,4468,4471,4503,4529,4532,4558,4589,4616,4620,4622,4626,4666,4674,4692,4751,4752,4767,4813,4815,4822,4823,4831,4844,4846,4865,4902,4905,4933,4973,5001,5055,5060,5085,5134,5153,5160,5189,5220,5324,5370,5392,5396,5415,5461,5469,5476,5478,5515,5536,5538,5559,5647,5685,5780,5795,5798,5857,5894,5895,5913,5999,6120,6148,6178,6198,6311,6325,6391,6392,6420,6435,6442,6448,6476,6477,6482,6548,6598,6616,6639,6666,6671,6681,6752,6775,6776,6806,6809,6828,6836,6845,6855,6868,6876,6916,6941,6944,6958,6994,7017,7022,7030,7034,7048,7050,7056,7105,7109,7122,7124,7137,7138,7173,7195,7210,7212,7242,7243,7246,7258,7276,7287,7324,7407,7418,7450,7462,7478,7491,7516,7535,7592,7595,7648,7692,7716,7720,7730,7736,7751,7782,7811,7818,7819,7830,7838,7840,7841,7897,7924,7933,7965,7970,7993,8027,8046,8053,8070,8086,8090,8106,8116,8118,8192,8215,8250,8291,8295,8314,8351,8444,8445,8538,8565,8589,8592,8602,8610,8634,8638,8663,8707,8779,8801,8835,8856,8864,8887,8895,8942,9029,9087,9169,9206,9237,9253,9262,9277,9279,9282,9291,9364,9369,9401,9411,9428,9472,9473,9488,9531,9532,9572,9580,9650,9677,9678,9772,9836,9924,9930,10024,10035,10050,10077,10079,10197,10198,10266,10274,10290,10303,10326,10350,10475,10478,10486,10499,10518,10557,10563,10572,10630,10690,10731,10801,10806,10831,10840,11001,11059,11087,11182,11184,11273,11345,11447,11464,11472,11494,11542,11555,11692,11840,11880,12020,12216,12242,12324,12338,12363,12366,12398,12401,12408,12410,12460,12482,12490,12550,12620,12625,12637,12639,12650,12667,12670,12685,12686,12708,12745,12757,12795,12810,12875,12913,12920,12965,12973,12974,12977,12983,12996,13014,13016,13017,13034,13126,13152,13235,13246,13287,13294,13298,13348,13474,13475,13651,13671,13687,13707,13842,13896,13900,13971,13973,13975,13985,14011,14052,14069,14092,14105,14109,14139,14142,14205,14227,14229,14232,14252,14271,14273,14293,14362,14421,14456,14534,14536,14554,14557,14591,14596,14610,14646,14666,14701,14703,14714,14752,14774,14778,14860,14865,14895,14926,14969,14976,14979,14987,15004,15030,15032,15037,15038,15043,15063,15065,15087,15114,15144,15203,15235,15245,15247,15256,15261,15293,15297,15304,15382,15403,15414,15424,15439,15441,15445,15455,15460,15475,15476,15492,15520,15533,15542,15544,15562,15574,15575,15604,15640,15717,15728,15760,15766,15781,15796,15804,15807,15861,15875,15877,15892,15913,15915,15945,15972,15973,16014,16053,16054,16055,16062,16071,16115,16122,16125,16140,16161,16176,16187,16206,16224,16257,16277,16359,16410,16454,16470,16497,16526,16534,16543,16554,16558,16566,16587,16588,16607,16612,16635,16642,16652,16657,16691,16698,16737,16751,16791,16815,16830,16831,16833,16843,16908,16913,16929,16936,16950,16964,16976,16995,17000,17001,17043,17054,17055,17059,17114,17140,17149,17166,17189,17215,17280,17309,17333,17334,17335,17341,17347,17354,17358,17364,17372,17381,17388,17403,17417,17419,17432,17442,17463,17496,17500,17528,17592,17596,17597,17607,17617,17629,17630,17644,17646,17650,17659,17683,17689,17699,17702,17721,17729,17737,17753,17759,17766,17772,17784,17791,17798,17799,17806,17807,17818,17831,17857,17907,17936,17954,17961,17990,18001,18036,18071,18073,18158,18176,18217,18220,18260,18263,18300,18309,18316,18326,18337,18352,18357,18360,18361,18383,18384,18419,18427,18442,18444,18455,18480,18485,18498,18520,18527,18542,18543,18547,18555,18558,18565,18576,18577,18578,18581,18586,18591,18612,18643,18648,18657,18682,18689,18695,18716,18733,18739,18754,18757,18779,18802,18808,18809,18819,18832,18847,18848,18898,18901,18910,18957,18986,18991,18997,19015,19022,19038,19060,19063,19083,19086,19105,19120,19134,19171,19183,19185,19187,19207,19215,19217,19228,19247,19251,19258,19269,19270,19274,19280,19282,19283,19289,19294,19299,19302,19303,19304,19307,19313,19331,19339,19366,19377,19381,19383,19386,19389,19396,19400,19402,19413,19419,19421,19423,19427,19433,19437,19440,19442,19453,19458,19460,19470,19484,19494,19503,19504,19522,19524,19532,19533,19551,19552,19556,19566,19567,19573,19593,19604,19625,19650,19651,19661,19668,19695,19700,19720,19721,19730,19733,19763,19766,19772,19779,19800,19825,19830,19864,19867,19886,19923,19931,19932,19937,19955,19980,19987,19991,19999,20007,20029,20036,20042,20044,20050,20056,20057,20060,20062,20076,20083,20095,20099,20103,20146,20153,20162,20167,20177,20183,20188,20192,20193,20199,20213,20215,20216,20229,20236,20278,20279,20289,20293,20306,20308,20332,20352,20354,20362,20374,20391,20422,20427,20439,20440,20459,20464,20479,20508,20530,20537,20567,20574,20578,20579,20595,20600,20605,20616,20648,20649,20659,20662,20664,20691,20699,20700,20713,20724,20727,20733,20743,20753,20764,20765,20768,20769,20774,20776,20795,20799,20804,20813,20817,20826,20835,20843,20847,20851,20853,20858,20860,20871,20879,20883,20915,20920,20921,20944,20949,20950,20954,20999,21016,21017,21038,21105,21152,21159,21161,21168,21178,21184,21217,21236,21242,21252,21256,21279,21282,21283,21285,21288,21293,21300,21313,21338,21366,21368,21388,21402,21415,21452,21464,21465,21483,21485,21486,21502,21516,21518,21522,21524,21526,21529,21536,21569,21606,21618,21623,21650,21661,21662,21664,21690,21695,21704,21709,21719,21727,21760,21766,21775,21787,21800,21820,21824,21843,21849,21850,21906,21910,21912,21954,21955,21969,21988,22015,22018,22059,22062,22077,22089,22105,22117,22126,22145,22163,22164,22195,22225,22241,22244,22245,22246,22248,22268,22302,22324,22350,22366,22378,22382,22395,22406,22419,22421,22431,22446,22453,22500,22502,22512,22527,22530,22559,22567,22580,22603,22607,22620,22622,22626,22655,22658,22666,22674,22710,22727,22740,22742,22743,22744,22753,22765,22766,22780,22787,22793,22804,22805,22829,22833,22847,22854,22874,22875,22895,22897,22906,22921,22923,22924,22933,22934,22935,22942,22947,22963,22972,22976,23002,23006,23007,23017,23024,23034,23043,23050,23062,23080,23081,23082,23089,23103,23124,23126,23138,23151,23170,23179,23202,23214,23224,23246,23256,23260,23271,23300,23343,23354,23380,23396,23408,23417,23445,23466,23471,23477,23480,23490,23495,23512,23526,23528,23536,23565,23569,23599,23617,23651,23659,23665,23666,23677,23682,23693,23716,23719,23740,23759,23761,23763,23768,23782,23792,23806,23816,23827,23839,23857,23869,23874,23875,23900,23914,23922,23927,23930,23955,23962,23965,23966,23967,23998,24001,24016,24059,24067,24072,24076,24141,24153,24171,24174,24189,24208,24212,24219,24226,24249,24260,24264,24282,24299,24373,24393,24408,24415,24470,24472,24475,24484,24522,24526,24543,24571,24582,24585,24598,24608,24609,24614,24617,24618,24624,24659,24672,24682,24718,24754,24780,24790,24797,24803,24851,24853,24857,24888,24905,24924,24927,24937,24942,24943,24956,24960,24968,24973,24979,24989,24993,24995,25030,25035,25048,25062,25067,25090,25100,25104,25119,25126,25131,25138,25141,25143,25171,25199,25207,25245,25252,25260,25318,25323,25345,25351,25353,25360,25366,25406,25435,25436,25448,25456,25461,25486,25502,25534,25542,25554,25569,25584,25595,25598,25610,25615,25616,25624,25632,25646,25650,25660,25673,25721,25778,25818,25886,25901,25904,25955,26000,26014,26033,26103,26122,26147,26215,26221,26238,26245,26293,26317,26324,26338,26343,26360,26386,26389,26415,26424,26431,26454,26474,26479,26513,26554,26589,26605,26651,26654,26665,26677,26685,26713,26742,26772,26776,26779,26792,26801,26808,26820,26829,26845,26857,26881,26898,26905,26907,26910,26920,26939,26944,26954,26973,26996,27000,27008,27015,27020,27024,27026,27038,27055,27063,27076,27093,27103,27131,27133,27135,27149,27151,27157,27186,27248,27356,27366,27420,27438,27453,27477,27490,27520,27530,27545,27566,27572,27688,27720,27722,27738,27805,27822,27846,27863,27891,27904,27912,27991,27996,27997,28072,28080,28248,28316,28339,28383,28384,28402,28416,28440,28442,28452,28614,28615,28616,28657,28712,28728,28777,28845,28910,28918,28922,28944,28960,29023,29033,29054,29123,29136,29281,29307,29460,29466,29499,29584,29635,29834,29890,29909,29933,30111,30307,31114,31356,31671,31762,32097,32136,32841,33033,33259,33417,33430,33593,33651,33784,33932,33993,34008,34176,34300,34490,34573,34783,34848,35144,35330,35568,35713,35730,35741,35744,35755,35803,35921,35955,35989,36017,36041,36219,36235,36633,36958,37408,38800,38852,38916,38985,39178,39269,39318,39369,39398,39530,39598,39653,39858,39941,39998,40036,40050,40064,40213,40214,40492,40605,40706,41256,41311,41337,41430,42530,42752,42799,44396,44402,44602,44743,45008,45076)
ORDER BY i.id DESC
LIMIT 0, 5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | i | NULL | range | PRIMARY,item,catid | PRIMARY | 4 | NULL | 1790 | 1.00 | Using where |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | cms_domad_francisca.i.catid | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.75 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.34 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 2.68 ms |
preparing | 1.38 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.39 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 ms |
# | Comunicador | Archivo y número de línea |
---|
15 | JDatabaseDriverMysqli->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 |