Tiempo de la consulta: 6.22 ms Después de la última consulta: 1.15 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.213 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-07 16:31:06')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 16:31:06')
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(4,9,21,32,45,46,54,62,65,71,197,260,263,279,287,394,415,563,643,659,764,770,1296,1335,1348,1503,1538,1563,1571,1644,1648,1714,1718,1804,2084,2258,2261,2305,2482,2726,2776,2909,3109,3196,3198,3223,3266,3319,3341,3384,3503,3522,3543,3575,3577,3672,3685,3706,3760,3767,3776,3782,3833,3912,3913,3960,3997,4007,4030,4034,4052,4078,4090,4100,4101,4110,4114,4120,4129,4131,4148,4150,4168,4204,4236,4239,4257,4284,4315,4323,4325,4327,4339,4346,4347,4417,4423,4456,4473,4493,4499,4548,4575,4612,4613,4614,4615,4617,4643,4760,4778,4780,4789,4859,4894,4915,4940,4982,5115,5152,5187,5199,5210,5211,5229,5259,5274,5304,5350,5386,5387,5407,5422,5433,5442,5461,5530,5536,5652,5814,5816,5842,5851,5854,5855,5857,5909,5973,5979,5996,6017,6062,6100,6128,6159,6164,6247,6274,6337,6360,6361,6362,6372,6419,6427,6440,6465,6468,6470,6486,6492,6567,6616,6619,6647,6649,6715,6720,6744,6776,6865,6881,7031,7077,7111,7142,7143,7165,7166,7187,7215,7216,7217,7218,7231,7232,7234,7243,7246,7249,7250,7258,7285,7289,7311,7319,7328,7330,7331,7333,7334,7344,7346,7359,7367,7368,7370,7371,7374,7377,7379,7380,7391,7396,7406,7407,7408,7410,7413,7414,7415,7416,7417,7422,7430,7431,7435,7436,7444,7447,7450,7451,7455,7456,7457,7458,7463,7464,7465,7486,7489,7509,7539,7545,7546,7552,7553,7555,7561,7565,7570,7577,7583,7586,7603,7605,7614,7615,7618,7625,7651,7659,7678,7682,7683,7691,7715,7720,7724,7735,7736,7737,7744,7746,7749,7752,7757,7768,7771,7784,7787,7799,7818,7825,7827,7830,7833,7834,7835,7848,7851,7863,7871,7891,7894,7895,7900,7901,7903,7919,7925,7935,7942,7955,7957,7961,7962,7973,7979,7982,8004,8010,8014,8020,8022,8023,8024,8036,8041,8049,8055,8065,8067,8072,8123,8152,8160,8163,8171,8177,8207,8219,8227,8234,8259,8263,8264,8265,8311,8318,8370,8378,8379,8400,8421,8422,8455,8469,8507,8509,8519,8520,8523,8550,8563,8576,8611,8623,8625,8644,8660,8698,8700,8727,8736,8750,8753,8756,8785,8789,8799,8813,8826,8857,8862,8864,8867,8919,8925,8934,8949,8954,8971,8980,9005,9020,9039,9050,9059,9063,9080,9120,9128,9138,9159,9165,9212,9214,9218,9249,9253,9303,9310,9311,9328,9344,9347,9350,9365,9384,9390,9435,9445,9448,9457,9467,9477,9503,9549,9555,9568,9578,9585,9594,9600,9610,9616,9658,9676,9690,9702,9738,9774,9827,9829,9838,9878,9892,9893,9904,9907,9908,9922,9956,9959,9996,10004,10060,10108,10116,10117,10149,10154,10170,10186,10187,10190,10196,10197,10199,10205,10208,10243,10265,10266,10268,10269,10277,10278,10294,10313,10342,10349,10387,10400,10401,10414,10435,10448,10498,10512,10513,10522,10567,10617,10642,10754,10756,10846,10903,10983,10993,11023,11031,11041,11065,11071,11073,11091,11108,11121,11148,11149,11167,11250,11286,11335,11338,11344,11387,11392,11404,11445,11458,11488,11503,11545,11607,11687,11749,11757,11796,11864,11875,11886,11921,11974,11978,11983,12013,12174,12193,12226,12249,12285,12355,12435,12488,12527,12553,12609,12617,12631,12632,12638,12649,12651,12689,12690,12695,12743,12812,12823,12844,12856,12884,12944,12952,12978,12997,13089,13090,13146,13154,13166,13207,13209,13325,13327,13375,13376,13385,13504,13506,13667,13685,13702,13731,13738,13740,13760,13789,13808,13844,13879,13886,13909,13910,13946,13948,13949,13961,13990,13996,14052,14123,14128,14141,14236,14250,14260,14297,14330,14346,14351,14366,14396,14421,14431,14505,14512,14513,14515,14532,14572,14596,14598,14601,14616,14662,14680,14713,14730,14739,14740,14770,14820,14824,14825,14828,14849,14865,14939,14946,14947,14962,14973,14974,14999,15006,15015,15030,15039,15041,15046,15069,15081,15103,15148,15160,15178,15193,15240,15247,15260,15268,15293,15318,15326,15347,15388,15423,15432,15447,15457,15465,15482,15487,15501,15533,15551,15560,15570,15594,15611,15617,15628,15636,15637,15640,15673,15689,15699,15721,15723,15738,15767,15768,15775,15776,15783,15793,15797,15799,15808,15835,15855,15866,15872,15874,15879,15889,15902,15912,15913,15916,15932,15958,16036,16038,16039,16042,16055,16059,16071,16082,16084,16097,16100,16103,16119,16127,16129,16156,16172,16181,16193,16217,16240,16248,16256,16292,16310,16314,16315,16368,16375,16378,16403,16410,16427,16440,16509,16520,16552,16577,16584,16651,16705,16729,16746,16759,16771,16828,16872,16875,16890,16907,16954,16960,16988,16991,16993,17024,17025,17053,17074,17080,17102,17109,17112,17115,17120,17124,17145,17148,17152,17160,17200,17216,17233,17260,17291,17297,17298,17335,17344,17375,17418,17468,17475,17476,17545,17548,17550,17574,17583,17590,17601,17607,17627,17633,17650,17668,17693,17755,17818,17824,17844,17855,17859,17883,17893,17926,17941,17956,17966,17999,18054,18061,18062,18122,18150,18157,18180,18190,18220,18233,18255,18271,18274,18292,18314,18330,18344,18353,18362,18442,18460,18482,18510,18529,18539,18544,18558,18564,18576,18586,18608,18609,18694,18709,18712,18715,18718,18730,18735,18800,18846,18862,18878,18905,18916,18922,18923,18931,18954,18975,18980,19028,19034,19042,19101,19105,19124,19128,19135,19143,19155,19218,19240,19243,19247,19313,19350,19366,19426,19472,19484,19530,19542,19550,19561,19604,19625,19637,19651,19652,19713,19719,19732,19733,19772,19781,19784,19787,19839,19852,19872,19945,19967,20018,20030,20066,20127,20191,20250,20260,20264,20289,20301,20327,20348,20363,20376,20385,20393,20429,20444,20461,20504,20592,20602,20649,20676,20678,20741,20779,20797,20805,20813,20828,20850,20885,20906,20915,20959,20960,21000,21057,21062,21063,21107,21108,21143,21161,21190,21209,21228,21249,21259,21292,21300,21323,21325,21369,21381,21397,21434,21435,21458,21464,21475,21489,21522,21552,21554,21578,21590,21602,21624,21627,21641,21710,21740,21744,21764,21776,21777,21843,21855,21858,21883,21894,21944,21952,21976,21982,22010,22040,22063,22116,22160,22176,22214,22237,22262,22289,22290,22298,22313,22348,22407,22459,22461,22602,22617,22642,22647,22668,22672,22693,22703,22715,22733,22739,22763,22803,22819,22837,22883,22886,22889,22890,22904,22914,22957,22959,23033,23065,23067,23068,23107,23123,23131,23185,23195,23201,23214,23229,23237,23241,23260,23280,23308,23313,23320,23325,23326,23328,23335,23339,23364,23408,23582,23678,23679,23725,23729,23762,23849,23858,23885,23890,23949,24062,24068,24075,24102,24104,24127,24152,24191,24211,24223,24273,24274,24327,24346,24366,24371,24392,24411,24503,24526,24592,24595,24644,24727,24733,24736,24738,24785,24816,24834,24837,24844,24899,24915,24964,25072,25098,25107,25125,25133,25178,25225,25253,25294,25352,25377,25380,25538,25555,25644,25645,25648,25679,25714,25730,25785,25850,25851,25941,25993,26000,26178,26183,26256,26273,26284,26359,26386,26409,26493,26501,26504,26521,26524,26563,26579,26604,26609,26646,26648,26748,26820,26845,26901,26926,26958,26960,26968,26972,27002,27011,27025,27056,27126,27150,27155,27170,27246,27273,27321,27347,27418,27431,27492,27496,27512,27521,27545,27593,27604,27605,27644,27686,27704,27721,27738,27749,27789,27842,27917,27931,27936,28005,28033,28045,28082,28225,28312,28360,28411,28441,28468,28500,28639,28653,28658,28747,28846,28989,29008,29009,29124,29152,29153,29172,29174,29197,29319,29356,29417,29443,29444,29476,29642,29781,29905,29922,29923,29935,30194,30988,31798,31853,32768,32842,33416,35617,35639,35640,35643,35689,35744,35752,35883,35885,36075,36208,36581,36584,37759,38362,38807,38831,38854,38866,38912,39224,39240,39481,39600,39603,39681,39857,39966,40025,40038,40083,40097,40170,40200,40708,40759,40785,40806,40809,40907,40937,40984,41059,41148,41171,41255,41301,41325,41375,42932)
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 | 1301 | 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.29 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 2.59 ms |
preparing | 1.16 ms |
Sorting result | 0.06 ms |
executing | 0.01 ms |
Sending data | 0.45 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |