Време на заявката: 91.27 ms След последната заявка: 0.66 ms Памет за заявки: 0.072 MB Памет преди заявката: 3.481 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-02-05 16:40:26')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-02-05 16:40:26')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(1804,6767,6844,6846,6850,6939,6944,6949,6966,6982,6995,7055,7074,7079,7100,7131,7136,7180,7181,7501,7510,7733,7789,7799,7889,8086,8202,8343,8413,8527,8546,8547,8567,8582,8964,8966,8991,9019,9029,9033,9036,9090,9170,9174,9176,9188,9191,9200,9202,9213,9237,9263,9288,9303,9314,9318,9327,9344,9347,9348,9360,9374,9376,9391,9394,9396,9397,9404,9406,9408,9411,9416,9419,9428,9434,9438,9439,9441,9449,9453,9456,9461,9477,9494,9526,9529,9530,9554,9567,9581,9590,9597,9600,9614,9615,9616,9623,9628,9629,9632,9633,9634,9635,9640,9644,9646,9647,9653,9664,9665,9667,9668,9670,9673,9676,9682,9683,9684,9689,9693,9696,9697,9698,9700,9705,9710,9712,9714,9715,9716,9719,9720,9721,9722,9723,9724,9725,9728,9738,9740,9741,9742,9745,9747,9751,9759,9762,9765,9767,9772,9774,9795,9808,9816,9819,9827,9833,9844,9847,9851,9855,9860,9862,9863,9865,9867,9868,9871,9890,9891,9904,9911,9912,9916,9917,9919,9921,9924,9935,9937,9943,9956,9958,9964,9971,9974,9979,9992,9997,10000,10003,10014,10018,10025,10030,10032,10035,10037,10039,10040,10045,10057,10058,10063,10068,10073,10075,10077,10084,10085,10090,10100,10111,10127,10135,10137,10155,10171,10174,10180,10185,10189,10191,10201,10206,10212,10215,10223,10225,10229,10250,10252,10257,10258,10268,10270,10277,10278,10281,10286,10288,10289,10290,10291,10320,10329,10332,10343,10349,10353,10365,10374,10385,10388,10391,10394,10395,10397,10398,10399,10400,10406,10409,10411,10413,10430,10445,10467,10477,10479,10481,10496,10499,10519,10528,10536,10538,10539,10549,10556,10581,10585,10599,10602,10603,10606,10614,10615,10622,10623,10628,10633,10634,10636,10638,10644,10645,10647,10648,10649,10651,10653,10654,10655,10656,10660,10662,10667,10670,10673,10674,10676,10678,10680,10686,10690,10694,10701,10704,10706,10709,10710,10715,10720,10736,10748,10758,10762,10768,10770,10781,10782,10794,10809,10812,10814,10825,10829,10842,10867,10877,10894,10901,10908,10916,10919,10920,10927,10943,10965,10972,10985,10988,10994,10996,11018,11038,11040,11050,11056,11059,11066,11067,11068,11084,11086,11099,11110,11114,11119,11120,11138,11141,11143,11228,11229,11230,11235,11246,11249,11250,11252,11253,11255,11259,11262,11264,11267,11270,11274,11298,11330,11382,11385,11386,11400,11408,11413,11512,11515,11517,11518,11521,11522,11525,11528,11532,11536,11540,11544,11546,11550,11556,11561,11581,11592,11593,11597,11598,11599,11601,11606,11649,11699,11706,11765,11841,11843,11848,11850,12040,12042,12050,12053,12056,12058,12067,12070,12075,12076,12077,12085,12089,12091,12097,12106,12113,12155,12158,12160,12162,12168,12216,12224,12230,12231,12237,12287,12288,12342,12343,12349,12351,12357,12358,12362,12416,12418,12420,12431,12493,12495,12496,12500,12517,12537,12541,12547,12561,12596,12600,12602,12608,12615,12620,12628,12630,12636,12646,12647,12674,12681,12684,12689,12691,12692,12695,12714,12741,12750,12760,12783,12827,12833,12844,12864,12881,12891,12923,12924,12940,12955,12963,12984,12988,13010,13011,13018,13028,13050,13057,13058,13069,13083,13084,13099,13143,13150,13166,13170,13204,13206,13229,13235,13306,13376,13406,13408,13414,13415,13419,13463,13526,13538,13551,13556,13562,13670,13712,13729,13747,13922,13927,13939,13941,13993,14008,14027,14057,14080,14105,14144,14209,14330,14385,14451,14520,14581,14640,14659,14755,14808,14907,14909,14919,14969,15005,15012,15039,15040,15042,15044,15064,15068,15113,15118,15159,15192,15207,15234,15274,15283,15297,15318,15369,15370,15376,15389,15395,15502,15506,15560,15571,15573,15638,15682,15683,15684,15698,15765,15767,15781,15797,15798,15800,15809,15849,15851,15853,15859,15860,15861,15869,15875,15876,15891,15892,15903,15906,15915,15918,15921,15926,15953,15963,15992,16055,16073,16074,16079,16106,16135,16145,16162,16171,16175,16182,16189,16193,16194,16201,16205,16209,16212,16217,16240,16273,16298,16303,16315,16317,16335,16345,16367,16368,16375,16384,16450,16488,16527,16544,16547,16590,16597,16651,16656,16756,16764,16768,16771,16788,16815,16904,16960,17105,17164,17203,17236,17249,17253,17254,17297,17299,17301,17385,17396,17414,17496,17539,17541,17545,17562,17563,17581,17594,17597,17621,17630,17640,17668,17682,17694,17704,17711,17750,17801,17823,17949,17950,17964,17994,17995,17998,18007,18017,18040,18049,18055,18056,18059,18066,18073,18082,18095,18101,18106,18124,18138,18139,18143,18174,18175,18180,18201,18205,18206,18211,18216,18222,18225,18230,18241,18271,18297,18327,18333,18334,18366,18367,18402,18415,18436,18437,18445,18454,18474,18475,18476,18478,18481,18491,18499,18503,18507,18511,18535,18538,18552,18556,18572,18574,18582,18588,18590,18591,18629,18644,18654,18656,18661,18664,18665,18667,18694,18697,18705,18709,18717,18723,18753,18756,18760,18762,18777,18779,18785,18786,18793,18820,18822,18826,18850,18852,18863,18868,18869,18871,18872,18880,18886,18902,18934,18943,18944,18948,18967,18972,18996,19006,19010,19031,19041,19043,19052,19063,19068,19069,19070,19071,19081,19082,19086,19088,19089,19090,19123,19130,19132,19143,19168,19169,19175,19177,19193,19203,19229,19230,19231,19259,19266,19267,19280,19283,19313,19339,19349,19350,19354,19362,19374,19375,19383,19400,19402,19410,19429,19431,19436,19444,19449,19456,19468,19472,19473,19474,19475,19477,19479,19485,19486,19498,19500,19523,19526,19545,19552,19571,19572,19573,19586,19588,19598,19599,19637,19639,19651,19652,19653,19655,19660,19667,19668,19669,19670,19671,19690,19691,19713,19720,19743,19750,19790,19825,19833,19834,19840,19844,19846,19875,19894,19905,19911,19930,19953,19956,19989,19997,20006,20021,20063,20082,20092,20093,20095,20100,20102,20117,20121,20123,20124,20125,20142,20166,20187,20189,20192,20209,20219,20236,20238,20256,20260,20264,20266,20268,20276,20296,20299,20302,20304,20327,20337,20348,20352,20353,20364,20395,20402,20425,20426,20437,20438,20441,20444,20445,20459,20468,20474,20484,20485,20502,20506,20508,20550,20551,20553,20560,20570,20574,20578,20582,20583,20598,20606,20607,20608,20612,20618,20627,20628,20631,20634,20636,20661,20665,20678,20693,20694,20729,20735,20769,20771,20809,20812,20813,20821,20857,20862,20883,20887,20892,20908,20909,20934,20936,20942,20949,20963,20965,20969,20971,20977,20981,20982,20983,20989,20991,20992,21008,21015,21016,21023,21032,21040,21048,21049,21056,21061,21067,21068,21077,21086,21087,21104,21105,21115,21118,21145)
ORDER BY i.id DESC
LIMIT 0, 3
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | <subquery2> | ALL | distinct_key | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | 1068 | Using temporary; Използване на файлове сортиране |
1 | PRIMARY | i | eq_ref | PRIMARY,item,catid | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
1 | PRIMARY | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | big5_archdb.i.catid | 1 | Using where |
2 | MATERIALIZED | <derived3> | ALL | NULL | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | 1068 | |
3 | DERIVED | NULL | NULL | NULL | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | NULL | No tables used |
Status | Duration |
---|
Starting | 0.38 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.17 ms |
Optimizing | 0.22 ms |
Statistics | 0.14 ms |
Preparing | 0.05 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.12 ms |
Removing tmp table | 0.01 ms |
Sending data | 69.87 ms |
Creating sort index | 4.01 ms |
Removing tmp table | 15.84 ms |
Creating sort index | 0.04 ms |
End of update loop | 0.01 ms |
Removing tmp table | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Removing tmp table | 0.02 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 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 |