Време на заявката: 2.94 ms След последната заявка: 0.49 ms Памет за заявки: 0.040 MB Памет преди заявката: 3.458 MB Върнати редове: 3
SELECT i.*, c.alias AS categoryalias
FROM dui0l_k2_items AS i
LEFT JOIN dui0l_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 <= '2023-04-01 04:18:49')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-04-01 04:18:49')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(200,371,498,567,568,569,570,607,640,800,830,1211,1565,1575,1679,1713,1964,2585,2672,2801,3164,3380,3554,3558,3773,3778,4744,5420,5421,5662,5663,5703,5959,6542,6704,6732,6777,6780,6788,6812,6845,6847,6883,6890,6892,6903,6907,6908,6912,6914,6923,6932,6942,6944,6962,6973,6990,6994,6995,6999,7031,7033,7040,7067,7076,7078,7091,7096,7109,7115,7124,7131,7133,7135,7156,7165,7166,7169,7184,7221,7223,7225,7236,7242,7248,7250,7257,7282,7283,7304,7313,7356,7375,7385,7389,7398,7399,7400,7455,7463,7482,7485,7503,7511,7537,7580,7600,7614,7615,7616,7618,7619,7623,7635,7648,7660,7672,7683,7688,7692,7695,7728,7733,7734,7759,7766,7774,7779,7783,7789,7791,7808,7810,7821,7834,7862,7883,7887,7897,7905,7912,7913,7937,7938,7947,7972,7989,8036,8067,8104,8118,8122,8133,8134,8138,8147,8150,8152,8166,8170,8186,8198,8217,8229,8233,8236,8237,8287,8291,8295,8315,8318,8333,8335,8350,8358,8368,8371,8374,8387,8447,8450,8457,8458,8459,8464,8476,8478,8488,8506,8513,8514,8518,8519,8527,8530,8532,8535,8537,8546,8547,8550,8554,8559,8570,8575,8631,8633,8638,8639,8645,8648,8677,8684,8696,8704,8705,8707,8708,8722,8752,8760,8790,8792,8797,8804,8810,8812,8814,8820,8822,8831,8848,8854,8860,8904,8935,8985,8994,9003,9069,9074,9225,9233,9261,9268,9273,9274,9276,9277,9281,9284,9286,9293,9296,9300,9301,9307,9308,9309,9310,9311,9313,9314,9316,9317,9319,9320,9321,9323,9325,9327,9328,9330,9331,9332,9334,9335,9336,9340,9341,9342,9344,9345,9349,9353,9359,9360,9362,9366,9367,9370,9372,9374,9376,9380,9388,9394,9396,9397,9399,9409,9411,9414,9419,9440,9442,9450,9453,9462,9479,9495,9497,9507,9508,9517,9519,9522,9530,9539,9598,9628,9648,9657,9664,9665,9684,9691,9698,9699,9700,9703,9704,9706,9709,9710,9712,9715,9719,9721,9738,9750,9754,9756,9757,9758,9760,9763,9764,9765,9767,9768,9778,9816,9821,9844,9920,9938,9968,10091,10214,10270,10372,10405,10410,10475,10498,10541,10551,10588,10631,10857,10869,10905,10917,10993,11000,11057,11060,11109,11257,11258,11259,11262,11267,11270,11272,11280,11303,11306,11324,11333,11345,11355,11357,11380,11530,11542,11580,11602,11603,11606,11612,11623,11629,11671,11673,11745,11780,12067,12215,12267,12294,12351,12358,12471,12487,12491,12548,12558,12566,12574,12734,12809,12828,12838,12849,12858,12875,12880,12898,12903,12973,12974,12999,13024,13060,13256,13258,13265,13294,13519,13553,13700,13717,13730,13782,13803,13860,13915,13929,14097,14115,14277,14316,14388,14541,14547,14584,14639,14695,14788,15002,15005,15024,15051,15062,15078,15084,15106,15110,15117,15124,15130,15144,15187,15200,15210,15214,15217,15219,15242,15309,15327,15337,15378,15476,15497,15530,15643,15659,15694,15715,15751,15752,15753,15758,15767,15781,15792,15798,15819,15822,15824,15836,15838,15873,15877,15879,15890,15891,15909,15930,15933,15936,15951,15954,15976,16011,16012,16013,16031,16168,16169,16170,16180,16245,16274,16279,16317,16353,16366,16417,16418,16480,16534,16616,16624,16665,16698,16703,16783,16907,17209,17211,17212,17213,17214,17215,17242,17314,17650,17688,17705,17784,17818,17854,17876,17882,17894,17901,17994,18014,18017,18120,18122,18128,18166,18384,18390,18406,18425,18427,18441,18443,18451,18468,18474,18516,18536,18546,18572,18621,18631,18649,18734,18789,18824,18833,18838,18942,18979,18994,19014,19029,19096,19098,19100,19119,19123,19130,19132,19139,19148,19156,19163,19169,19173,19189,19190,19191,19195,19196,19206,19207,19210,19213,19217,19222,19225,19226,19233,19235,19238,19239,19242,19243,19244,19251,19253,19254,19255,19258,19261,19262,19264,19266,19268,19269,19271,19274,19279,19298,19313,19314,19316,19318,19326,19334,19346,19348,19356,19363,19367,19370,19385,19408,19413,19418,19429,19432,19434,19438,19440,19442,19444,19446,19451,19459,19460,19461,19465,19470,19472,19475,19477,19480,19487,19489,19510,19528,19530,19543,19554,19558,19563,19567,19579,19580,19581,19584,19598,19600,19603,19620,19633,19635,19657,19658,19659,19670,19679,19684,19694,19705,19711,19734,19736,19739,19750,19764,19769,19783,19784,19787,19790,19793,19797,19809,19822,19833,19846,19858,19881,19893,19894,19898,19908,19920,19925,19935,19957,19958,19977,19992,20010,20024,20044,20046,20050,20052,20057,20062,20064,20066,20073,20075,20076,20084,20086,20115,20117,20148,20162,20163,20184,20186,20199,20200,20209,20215,20219,20220,20222,20223,20246,20253,20267,20293,20296,20317,20326,20338,20352,20353,20354,20370,20380,20383,20386,20389,20393,20409,20410,20463,20475,20487,20496,20501,20523,20545,20577,20587,20595,20598,20601,20602,20605,20609,20611,20640,20660,20667,20680,20684,20696,20704,20714,20737,20780,20783,20787,20792,20797,20800,20830,20832,20843,20866,20903,21045,21052,21059)
ORDER BY i.id DESC
LIMIT 0, 3
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | i | range | PRIMARY,item,catid | PRIMARY | 4 | NULL | 823 | Using where |
1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | big5_archdb.i.catid | 1 | Using where |
Status | Duration |
---|
Starting | 0.28 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.14 ms |
Optimizing | 0.09 ms |
Statistics | 0.88 ms |
Preparing | 1.19 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.12 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:686 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:290 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:19 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:78 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |