Tiempo de la consulta: 6.62 ms Después de la última consulta: 1.81 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.383 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-04 12:23:20')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 12:23:20')
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(9,10,45,46,47,49,54,62,65,71,84,93,105,106,108,203,205,207,208,211,219,227,229,230,231,234,236,237,284,353,368,415,523,544,605,607,643,659,691,694,714,723,764,794,803,868,1031,1104,1110,1164,1217,1284,1291,1296,1324,1335,1338,1345,1398,1409,1410,1413,1428,1455,1459,1486,1490,1504,1506,1563,1571,1600,1601,1606,1619,1648,1665,1694,1724,1794,1795,1796,1808,1810,1815,1830,1843,1862,1930,1943,1956,1975,2061,2066,2084,2197,2252,2500,2613,2864,2909,2964,3032,3196,3266,3296,3312,3327,3330,3385,3390,3442,3448,3490,3515,3572,3637,3685,3705,3760,3767,3776,3815,3822,3823,3833,3848,3858,3913,3916,3960,4015,4031,4034,4039,4055,4060,4063,4077,4087,4092,4101,4107,4110,4129,4144,4148,4150,4153,4163,4165,4175,4177,4203,4204,4207,4276,4284,4323,4327,4389,4395,4414,4423,4428,4436,4437,4456,4457,4496,4511,4548,4549,4550,4559,4561,4569,4575,4602,4623,4660,4760,4773,4859,4877,4881,4912,4940,4949,4983,5024,5032,5050,5060,5100,5123,5137,5161,5203,5213,5218,5240,5249,5259,5267,5270,5289,5301,5306,5329,5338,5350,5368,5385,5387,5419,5421,5422,5428,5432,5454,5462,5567,5594,5633,5647,5649,5704,5725,5762,5788,5894,5909,5912,5927,5931,5979,6041,6043,6074,6081,6100,6116,6128,6177,6192,6194,6291,6341,6350,6360,6362,6363,6374,6386,6400,6428,6435,6440,6456,6471,6473,6494,6495,6497,6499,6502,6515,6520,6521,6534,6564,6576,6578,6598,6601,6603,6636,6649,6655,6656,6657,6659,6662,6695,6720,6724,6725,6734,6737,6756,6759,6764,6789,6790,6805,6812,6838,6840,6843,6865,6869,6870,6871,6873,6875,6876,6879,6881,6903,6904,6914,6925,6927,6928,6940,6956,6957,6968,6986,6990,6992,6994,7009,7011,7016,7020,7045,7059,7077,7079,7100,7102,7110,7111,7216,7241,7248,7250,7258,7311,7313,7314,7331,7364,7385,7386,7389,7393,7394,7397,7412,7432,7443,7444,7449,7453,7474,7478,7484,7488,7494,7516,7523,7529,7542,7547,7548,7571,7578,7586,7591,7605,7614,7616,7618,7623,7626,7651,7654,7669,7675,7677,7683,7689,7711,7722,7724,7725,7726,7728,7732,7737,7752,7771,7773,7774,7776,7784,7787,7794,7797,7808,7817,7832,7841,7877,7878,7885,7903,7925,7935,7942,7948,8004,8008,8026,8036,8055,8062,8071,8103,8106,8116,8117,8135,8141,8152,8157,8160,8163,8176,8198,8199,8200,8220,8227,8234,8265,8272,8298,8323,8330,8331,8334,8345,8358,8363,8364,8369,8370,8378,8380,8387,8399,8409,8410,8421,8424,8452,8455,8489,8506,8507,8510,8550,8559,8598,8599,8608,8611,8619,8639,8641,8644,8649,8655,8658,8660,8665,8667,8671,8700,8702,8703,8738,8750,8753,8755,8758,8761,8765,8770,8794,8799,8803,8804,8813,8823,8826,8828,8829,8856,8864,8869,8871,8873,8925,8926,8930,8953,8954,8973,8977,8980,8982,8998,9019,9020,9041,9058,9063,9065,9068,9101,9102,9120,9127,9128,9147,9167,9192,9202,9231,9234,9260,9300,9302,9325,9327,9328,9350,9354,9355,9390,9400,9406,9420,9453,9476,9477,9489,9514,9542,9556,9558,9561,9562,9565,9569,9578,9592,9594,9600,9602,9610,9640,9677,9678,9697,9714,9724,9730,9732,9738,9762,9783,9793,9794,9810,9829,9838,9843,9878,9886,9893,9896,9904,9908,9910,9911,9919,9922,9924,9941,9951,9956,9961,10004,10017,10042,10082,10083,10118,10124,10148,10149,10172,10184,10190,10192,10207,10208,10209,10221,10264,10265,10269,10291,10297,10313,10322,10332,10352,10393,10395,10398,10414,10436,10448,10450,10451,10464,10473,10475,10480,10485,10513,10543,10613,10614,10617,10629,10631,10642,10645,10646,10650,10660,10663,10681,10692,10710,10722,10739,10754,10756,10941,10969,10993,10998,11023,11031,11041,11065,11073,11089,11098,11106,11121,11151,11163,11184,11209,11226,11229,11235,11250,11258,11275,11286,11289,11295,11338,11387,11416,11436,11458,11488,11505,11545,11687,11728,11746,11772,11796,11867,11875,11904,11907,11921,11934,12002,12046,12214,12249,12268,12288,12298,12343,12405,12412,12468,12553,12632,12638,12651,12652,12689,12690,12708,12743,12756,12841,12857,12886,13090,13094,13113,13135,13146,13166,13187,13194,13205,13209,13224,13290,13349,13353,13365,13376,13385,13430,13455,13483,13505,13506,13521,13528,13530,13552,13582,13588,13702,13731,13738,13760,13777,13789,13794,13884,13946,13961,13996,14047,14095,14097,14108,14110,14118,14141,14146,14189,14191,14195,14196,14211,14213,14224,14234,14240,14244,14260,14261,14276,14280,14283,14293,14306,14318,14351,14353,14355,14367,14383,14396,14440,14445,14448,14458,14460,14484,14494,14512,14513,14515,14524,14528,14532,14533,14601,14607,14616,14622,14645,14662,14681,14693,14701,14726,14730,14739,14745,14748,14750,14765,14773,14792,14820,14824,14825,14827,14842,14848,14866,14870,14871,14899,14913,14939,14943,14944,14949,14950,14999,15006,15039,15041,15048,15049,15069,15081,15098,15116,15126,15137,15148,15151,15158,15160,15165,15166,15178,15193,15230,15247,15251,15260,15268,15270,15302,15319,15324,15326,15328,15333,15335,15338,15347,15364,15387,15388,15390,15406,15423,15428,15431,15432,15438,15453,15457,15458,15465,15482,15487,15496,15500,15503,15513,15521,15533,15542,15551,15560,15570,15578,15611,15617,15618,15624,15628,15631,15636,15637,15640,15647,15649,15655,15678,15693,15705,15720,15723,15738,15743,15746,15761,15767,15770,15776,15777,15780,15783,15784,15800,15801,15808,15813,15817,15822,15823,15840,15866,15878,15896,15909,15912,15913,15938,15945,15954,15964,15993,16002,16007,16008,16016,16027,16028,16039,16042,16048,16056,16059,16074,16082,16084,16097,16114,16127,16129,16137,16141,16156,16164,16181,16192,16223,16231,16233,16248,16254,16256,16275,16288,16292,16301,16314,16315,16351,16354,16358,16367,16372,16373,16375,16378,16389,16393,16396,16403,16405,16414,16461,16471,16475,16498,16515,16552,16563,16566,16577,16653,16656,16657,16666,16683,16692,16759,16768,16770,16822,16828,16845,16850,16886,16890,16900,16924,16958,16962,16967,16991,17008,17036,17053,17056,17074,17085,17096,17102,17115,17144,17145,17152,17160,17190,17214,17216,17227,17228,17233,17243,17275,17277,17298,17299,17342,17344,17396,17410,17437,17447,17468,17499,17511,17549,17573,17583,17588,17597,17602,17628,17633,17634,17648,17650,17652,17668,17707,17709,17710,17716,17718,17738,17756,17771,17774,17778,17809,17810,17817,17844,17855,17859,17869,17880,17888,17893,17923,17926,17939,17946,17966,17984,18053,18054,18062,18063,18073,18122,18157,18161,18174,18180,18233,18235,18246,18248,18254,18255,18258,18270,18274,18281,18292,18314,18329,18344,18356,18361,18362,18404,18451,18460,18505,18512,18518,18530,18537,18539,18541,18544,18550,18556,18564,18595,18603,18608,18610,18619,18632,18646,18655,18678,18694,18709,18727,18742,18753,18757,18775,18786,18800,18832,18846,18852,18861,18862,18872,18878,18894,18904,18916,18922,18931,18940,18941,18948,18954,18966,18972,18975,18976,18980,18985,18987,19003,19007,19028,19034,19042,19051,19056,19061,19062,19076,19100,19105,19124,19128,19135,19155,19173,19177,19190,19218,19240,19247,19250,19313,19318,19322,19353,19358,19366,19382,19392,19438,19479,19490,19503,19519,19530,19550,19551,19561,19566,19569,19575,19582,19584,19591,19592,19604,19637,19641,19645,19646,19652,19674,19709,19713,19732,19787,19792,19795,19833,19835,19852,19867,19872,19906,19943,19945,19974,20000,20018,20020,20026,20030,20053,20072,20127,20131,20250,20260,20264,20279,20281,20286,20293,20325,20327,20338,20348,20350,20360,20376,20393,20397,20399,20400,20408,20429,20441,20444,20445,20461,20464,20472,20473,20489,20504,20509,20527,20529,20534,20541,20568,20579,20602,20606,20633,20641,20648,20649,20658,20678,20707,20716,20729,20730,20731,20741,20753,20770,20771,20776,20779,20787,20796,20797,20813,20828,20850,20866,20906,20915,20928,20944,20959,20974,21000,21008,21012,21049,21057,21062,21063,21107,21108,21118,21127,21138,21143,21149,21161,21172,21190,21209,21225,21249,21254,21262,21264,21296,21312,21313,21322,21323,21325,21343,21347,21351,21369,21381,21397,21413,21425,21429,21434,21435,21436,21451,21458,21464,21472,21489,21540,21543,21552,21554,21566,21578,21585,21590,21610,21627,21641,21700,21703,21710,21732,21734,21738,21740,21744,21750,21764,21768,21776,21777,21855,21858,21861,21871,21883,21886,21894,21898,21944,21969,21972,21973,21976,21982,21999,22002,22010,22026,22040,22051,22063,22101,22124,22160,22176,22209,22214,22237,22243,22247,22270,22276,22281,22288,22296,22298,22305,22313,22326,22332,22339,22348,22365,22407,22432,22439,22455,22459,22461,22477,22509,22530,22531,22558,22564,22608,22617,22640,22646,22647,22663,22684,22690,22725,22726,22733,22739,22763,22784,22819,22837,22854,22871,22889,22890,22898,22904,22915,22946,22949,22957,22973,22988,22989,23033,23034,23049,23062,23065,23067,23079,23100,23131,23150,23182,23185,23195,23201,23203,23209,23222,23234,23237,23241,23259,23260,23265,23280,23299,23313,23320,23325,23326,23328,23335,23339,23354,23396,23399,23408,23459,23492,23512,23517,23523,23532,23559,23572,23582,23591,23596,23602,23606,23607,23626,23654,23670,23678,23679,23685,23759,23767,23868,23890,23898,23938,23942,23968,23986,23989,24008,24020,24061,24075,24084,24101,24102,24104,24124,24146,24152,24191,24196,24202,24205,24238,24259,24273,24274,24288,24313,24316,24327,24348,24352,24357,24366,24371,24390,24392,24429,24449,24469,24480,24483,24503,24525,24526,24548,24566,24592,24618,24642,24644,24668,24679,24727,24733,24745,24748,24775,24782,24794,24806,24816,24837,24844,24867,24879,24899,24924,24926,24964,24986,24994,25020,25046,25072,25098,25107,25115,25125,25133,25134,25139,25144,25178,25193,25194,25204,25224,25225,25253,25255,25263,25269,25293,25344,25377,25380,25405,25412,25418,25444,25447,25451,25478,25516,25531,25537,25538,25554,25556,25558,25561,25563,25590,25596,25644,25645,25684,25714,25730,25748,25780,25785,25787,25792,25815,25817,25850,25888,25961,25993,25994,26178,26183,26221,26234,26249,26256,26260,26273,26284,26303,26321,26344,26346,26347,26349,26352,26356,26366,26414,26444,26453,26493,26501,26504,26519,26521,26563,26569,26623,26648,26658,26685,26710,26756,26808,26811,26815,26827,26861,26901,26926,26964,26972,26986,27002,27011,27059,27086,27102,27128,27139,27143,27150,27151,27170,27171,27246,27258,27273,27307,27321,27367,27396,27404,27405,27406,27410,27418,27423,27431,27466,27496,27510,27521,27545,27567,27593,27601,27644,27655,27656,27663,27683,27686,27692,27695,27701,27704,27721,27737,27758,27771,27842,27887,27903,27917,27931,27936,27999,28005,28033,28045,28067,28082,28225,28280,28301,28310,28312,28334,28339,28411,28447,28463,28529,28530,28533,28639,28653,28658,28718,28738,28759,28973,28984,28989,28992,29004,29005,29008,29009,29014,29021,29034,29037,29152,29153,29174,29197,29319,29328,29349,29356,29417,29443,29444,29475,29476,29489,29501,29535,29694,29710,29716,29781,29810,29873,29905,29906,29922,29923,29935,29938,30284,30388,31510,31532,31908,32182,32768,32842,33099,34239,34335,35617,35643,35689,35691,35722,35740,35744,35883,35885,36052,36055,38807,38831,38854,38866,38902,39225,39263,39451,39481,39603,39615,39681,39857,40025,40038,40083,40097,40168,40170,40198,40200,40583,40708,40759,40785,40809,40852,40907,40937,40984,41059,41255,41270,41301,41325,41375)
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 | 1900 | 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.84 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.36 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 2.81 ms |
preparing | 1.47 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.03 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 |