Време на заявката: 215.21 ms След последната заявка: 1.52 ms Памет за заявки: 0.079 MB Памет преди заявката: 3.539 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 18:13:54')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-02-05 18:13:54')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(93,97,172,215,494,664,682,801,868,912,1058,1153,1170,1172,1181,1183,1214,1267,1298,1394,1643,1647,1901,1966,2008,2260,2396,2403,2550,2553,2882,2894,2944,2959,2968,2975,2992,3001,3007,3008,3009,3040,3192,3204,3258,3351,3418,3471,3476,3517,3640,3645,4766,5243,5736,6418,6612,6664,6666,6728,6739,6740,6741,6746,6753,6754,6758,6764,6767,6770,6773,6776,6777,6780,6781,6788,6792,6795,6802,6803,6807,6819,6821,6824,6828,6831,6840,6841,6844,6849,6850,6855,6856,6857,6858,6859,6861,6862,6867,6868,6869,6870,6883,6892,6905,6906,6914,6915,6923,6926,6927,6929,6934,6939,6944,6949,6951,6955,6963,6966,6981,6987,6988,6991,6995,7000,7002,7006,7016,7026,7029,7031,7033,7037,7038,7039,7040,7043,7046,7054,7055,7059,7060,7061,7074,7079,7091,7096,7099,7100,7106,7107,7109,7110,7119,7120,7127,7131,7133,7136,7141,7145,7154,7156,7165,7170,7174,7182,7208,7210,7233,7234,7239,7242,7245,7250,7252,7257,7259,7280,7290,7302,7317,7328,7336,7337,7338,7374,7389,7408,7429,7464,7465,7473,7482,7489,7501,7510,7524,7539,7593,7619,7625,7642,7646,7657,7661,7683,7686,7692,7698,7714,7716,7726,7731,7732,7733,7765,7789,7799,7828,7843,7861,7862,7869,7877,7894,7902,7908,7909,7914,7918,7920,7923,7925,7937,7963,7968,7969,7978,7981,8045,8052,8056,8063,8065,8081,8099,8107,8149,8155,8196,8198,8221,8234,8245,8261,8270,8271,8281,8292,8297,8300,8314,8316,8326,8352,8357,8358,8369,8370,8373,8396,8398,8407,8413,8429,8441,8455,8458,8460,8465,8469,8477,8483,8489,8498,8499,8501,8504,8506,8513,8518,8519,8527,8530,8532,8541,8543,8546,8547,8550,8559,8567,8582,8606,8608,8615,8706,8707,8708,8735,8736,8739,8751,8760,8764,8774,8790,8812,8824,8841,8859,8875,8891,9019,9032,9036,9090,9093,9107,9123,9176,9208,9213,9215,9223,9237,9244,9263,9288,9295,9314,9318,9326,9327,9344,9347,9348,9359,9360,9369,9374,9376,9390,9391,9394,9396,9397,9404,9405,9406,9408,9409,9416,9418,9425,9434,9449,9453,9455,9468,9474,9477,9494,9498,9507,9508,9526,9529,9530,9553,9554,9562,9564,9567,9569,9578,9580,9586,9591,9593,9600,9601,9613,9614,9615,9616,9623,9628,9629,9632,9633,9634,9635,9642,9644,9646,9651,9653,9664,9665,9667,9668,9670,9673,9680,9682,9683,9684,9689,9696,9697,9698,9700,9705,9706,9710,9712,9714,9715,9716,9720,9721,9722,9723,9724,9728,9738,9740,9741,9742,9746,9747,9748,9751,9755,9758,9759,9762,9765,9767,9770,9771,9772,9773,9774,9816,9819,9827,9831,9832,9836,9840,9847,9855,9860,9862,9863,9865,9867,9875,9890,9891,9892,9901,9904,9911,9912,9916,9920,9924,9935,9940,9948,9956,9958,9961,9968,9974,9979,9985,9992,9997,10003,10014,10020,10025,10035,10037,10071,10075,10076,10085,10090,10100,10113,10114,10116,10133,10135,10137,10140,10141,10150,10155,10168,10171,10174,10180,10182,10184,10185,10188,10189,10191,10193,10201,10206,10212,10213,10223,10225,10229,10230,10243,10250,10257,10258,10268,10270,10277,10278,10281,10286,10290,10291,10296,10297,10304,10320,10332,10333,10334,10343,10360,10365,10369,10370,10376,10383,10388,10399,10400,10405,10406,10408,10409,10413,10415,10420,10427,10442,10443,10445,10449,10463,10467,10476,10477,10479,10480,10495,10501,10504,10519,10527,10528,10532,10533,10535,10536,10546,10549,10571,10572,10586,10587,10595,10597,10598,10599,10602,10603,10607,10612,10614,10615,10622,10623,10626,10633,10634,10636,10638,10644,10645,10646,10648,10649,10651,10653,10656,10660,10663,10670,10674,10678,10684,10690,10694,10701,10704,10710,10714,10723,10727,10728,10729,10731,10736,10740,10744,10747,10748,10750,10755,10756,10762,10764,10770,10771,10779,10782,10793,10794,10797,10803,10804,10805,10809,10814,10816,10825,10836,10837,10838,10839,10840,10842,10844,10848,10853,10854,10866,10867,10868,10873,10874,10875,10877,10884,10889,10890,10893,10894,10897,10898,10900,10907,10908,10909,10916,10919,10920,10927,10932,10934,10935,10943,10944,10952,10960,10974,10977,10988,10995,10996,11018,11022,11039,11042,11044,11054,11055,11056,11061,11062,11063,11066,11067,11073,11079,11082,11084,11086,11095,11108,11109,11111,11114,11121,11127,11129,11135,11136,11141,11143,11147,11149,11158,11180,11194,11206,11211,11217,11226,11229,11242,11245,11254,11255,11258,11259,11262,11264,11267,11268,11274,11280,11283,11290,11297,11298,11303,11332,11333,11345,11347,11351,11353,11356,11357,11363,11375,11380,11385,11386,11389,11392,11399,11400,11402,11403,11407,11408,11429,11431,11441,11444,11450,11506,11507,11508,11514,11522,11524,11525,11540,11544,11546,11550,11551,11552,11555,11556,11591,11592,11593,11603,11606,11612,11624,11634,11637,11640,11641,11644,11648,11649,11655,11699,11701,11704,11707,11711,11740,11749,11760,11764,11765,11766,11806,11841,11842,11843,11845,11848,11850,11852,11854,11919,11923,11929,11940,11985,12041,12042,12050,12075,12076,12077,12082,12088,12090,12091,12092,12094,12096,12097,12127,12158,12162,12168,12169,12170,12198,12208,12216,12221,12231,12233,12237,12244,12255,12266,12283,12287,12290,12311,12342,12349,12353,12354,12366,12367,12370,12374,12378,12416,12420,12421,12423,12450,12487,12496,12499,12506,12511,12515,12518,12527,12544,12545,12550,12552,12574,12580,12593,12596,12598,12602,12607,12609,12615,12620,12621,12624,12626,12628,12630,12636,12640,12647,12652,12674,12675,12684,12692,12700,12705,12706,12714,12715,12729,12741,12750,12770,12771,12812,12821,12840,12853,12861,12862,12864,12868,12877,12896,12898,12903,12923,12929,12939,12948,12961,12963,12972,12979,13011,13018,13028,13074,13099,13103,13106,13108,13112,13117,13127,13143,13145,13146,13149,13151,13166,13167,13170,13174,13182,13187,13204,13206,13227,13229,13231,13235,13243,13244,13246,13251,13264,13276,13306,13336,13339,13358,13376,13390,13406,13408,13414,13415,13419,13440,13443,13458,13463,13471,13473,13477,13490,13516,13526,13538,13540,13545,13551,13556,13558,13570,13579,13597,13644,13659,13700,13712,13717,13729,13761,13810,13833,13856,13859,13869,13899,13905,13907,13908,13920,13922,13923,13927,13932,13935,13939,13941,13953,13993,14008,14014,14018,14025,14027,14049,14053,14055,14057,14065,14072,14080,14081,14092,14112,14128,14129,14147,14156,14167,14182,14188,14201,14203,14209,14228,14236,14238,14250,14261,14270,14286,14293,14296,14302,14319,14330,14331,14332,14336,14339,14345,14385,14409,14421,14441,14449,14451,14480,14492,14500,14505,14520,14530,14537,14542,14549,14555,14561,14565,14577,14581,14598,14611,14635,14636,14653,14659,14669,14670,14673,14679,14697,14714,14722,14726,14742,14752,14755,14756,14767,14770,14776,14806,14808,14825,14833,14836,14837,14853,14859,14870,14907,14909,14910,14916,14921,14943,14969,15004,15012,15014,15039,15040,15042,15044,15064,15068,15084,15111,15113,15126,15130,15137,15159,15164,15192,15202,15232,15234,15241,15249,15256,15263,15270,15271,15274,15283,15288,15293,15316,15317,15318,15337,15345,15362,15375,15389,15423,15473,15485,15502,15506,15560,15571,15573,15579,15584,15605,15606,15612,15613,15638,15640,15682,15683,15684,15695,15717,15735,15739,15754,15763,15765,15767,15769,15788,15789,15797,15798,15800,15807,15809,15810,15813,15816,15833,15847,15848,15849,15851,15853,15859,15860,15861,15869,15874,15875,15876,15891,15892,15899,15901,15903,15906,15915,15918,15926,15963,15981,15992,15993,15995,16008,16017,16026,16038,16045,16048,16054,16055,16073,16074,16079,16099,16104,16112,16116,16120,16128,16131,16139,16140,16158,16162,16172,16179,16181,16185,16186,16189,16193,16195,16204,16205,16210,16212,16227,16234,16241,16246,16253,16266,16268,16272,16273,16278,16287,16292,16298,16315,16317,16321,16329,16333,16337,16345,16358,16365,16368,16375,16380,16384,16385,16398,16400,16403,16421,16429,16450,16459,16468,16469,16483,16484,16496,16509,16520,16534,16536,16547,16559,16588,16590,16597,16634,16649,16656,16660,16697,16715,16733,16741,16756,16764,16768,16771,16788,16815,16904,16917,16954,16960,16983,16998,17009,17011,17048,17052,17069,17088,17105,17114,17118,17134,17150,17164,17176,17178,17199,17202,17203,17205,17212,17222,17236,17244,17249,17253,17254,17299,17310,17312,17316,17317,17324,17327,17385,17414,17418,17496,17523,17538,17539,17541,17545,17546,17562,17563,17568,17578,17595,17597,17605,17609,17619,17630,17633,17635,17639,17640,17642,17668,17680,17682,17696,17704,17708,17711,17748,17750,17797,17798,17801,17821,17823,17866,17868,17884,17918,17928,17949,17987,17994,17995,17998,18007,18017,18022,18034,18040,18059,18064,18066,18069,18073,18082,18092,18101,18106,18116,18118,18119,18136,18137,18138,18139,18140,18143,18151,18155,18174,18175,18179,18180,18198,18203,18205,18211,18214,18216,18225,18230,18233,18240,18245,18247,18254,18256,18258,18272,18274,18288,18297,18303,18318,18333,18335,18340,18343,18352,18353,18363,18366,18367,18383,18390,18392,18393,18402,18403,18405,18411,18412,18413,18415,18417,18420,18423,18427,18434,18436,18438,18441,18443,18445,18454,18463,18474,18475,18476,18478,18480,18481,18490,18491,18495,18499,18502,18503,18504,18529,18535,18538,18552,18556,18559,18572,18574,18582,18588,18590,18591,18606,18607,18609,18621,18640,18654,18656,18661,18664,18665,18667,18669,18672,18675,18677,18683,18684,18694,18696,18697,18698,18705,18709,18713,18714,18717,18721,18725,18734,18735,18738,18739,18740,18743,18748,18750,18753,18755,18758,18760,18762,18777,18792,18793,18794,18811,18820,18822,18825,18826,18832,18833,18844,18845,18850,18851,18852,18859,18863,18868,18871,18872,18876,18878,18880,18886,18887,18890,18900,18915,18931,18934,18938,18939,18943,18944,18948,18956,18957,18967,18972,18976,18978,18988,18989,18994,18995,18996,19000,19001,19005,19009,19010,19034,19043,19052,19055,19060,19063,19068,19069,19070,19071,19072,19073,19077,19080,19081,19082,19084,19086,19088,19090,19091,19092,19104,19109,19118,19130,19132,19143,19153,19156,19158,19168,19169,19170,19175,19177,19180,19186,19187,19203,19216,19229,19230,19231,19247,19254,19259,19266,19267,19278,19285,19295,19309,19313,19323,19324,19328,19339,19340,19343,19347,19349,19350,19354,19362,19369,19374,19375,19383,19385,19390,19393,19394,19400,19402,19403,19410,19411,19418,19420,19421,19422,19424,19429,19430,19444,19456,19462,19467,19472,19473,19475,19479,19485,19486,19500,19518,19523,19526,19540,19544,19545,19571,19572,19573,19586,19588,19598,19599,19600,19619,19630,19631,19638,19639,19645,19647,19651,19652,19653,19655,19667,19668,19669,19670,19671,19677,19679,19682,19683,19684,19689,19690,19691,19698,19703,19704,19713,19716,19743,19750,19766,19772,19790,19801,19803,19809,19810,19811,19814,19815,19820,19821,19825,19833,19835,19840,19844,19846,19854,19869,19870,19875,19881,19884,19889,19890,19891,19894,19895,19901,19903,19904,19905,19906,19909,19911,19913,19914,19915,19917,19924,19928,19938,19939,19944,19949,19950,19953,19956,19968,19970,19973,19976,19997,20003,20012,20014,20020,20021,20024,20028,20034,20035,20045,20052,20053,20073,20085,20100,20107,20110,20114,20117,20118,20121,20123,20142,20151,20166,20168,20174,20176,20182,20187,20188,20192,20201,20204,20206,20208,20209,20211,20214,20218,20219,20220,20221,20230,20236,20238,20239,20243,20256,20260,20264,20276,20285,20286,20296,20298,20302,20304,20311,20313,20327,20337,20346,20352,20353,20364,20370,20383,20384,20386,20391,20395,20405,20407,20421,20422,20425,20426,20429,20431,20441,20444,20445,20459,20474,20485,20495,20496,20513,20518,20520,20522,20543,20549,20550,20556,20557,20560,20562,20565,20567,20569,20574,20580,20581,20583,20598,20604,20607,20611,20612,20615,20628,20631,20636,20640,20645,20646,20650,20661,20662,20663,20664,20670,20677,20712,20713,20720,20723,20729,20733,20734,20735,20738,20741,20755,20758,20771,20773,20781,20785,20787,20811,20812,20813,20814,20819,20821,20829,20832,20836,20839,20851,20855,20859,20868,20879,20884,20885,20886,20887,20895,20898,20899,20908,20909,20912,20914,20934,20936,20942,20951,20954,20958,20963,20986,20990,21000,21013,21023,21040,21060,21067,21068,21074,21078,21080,21081,21085,21086,21087,21118)
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 | 2022 | 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 | 2022 | |
3 | DERIVED | NULL | NULL | NULL | НЕ МОЖЕ ДА БЪДЕ ИЗПОЛЗВАН ИНДЕКС КЛЮЧ | NULL | NULL | NULL | No tables used |
Status | Duration |
---|
Starting | 0.68 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.30 ms |
Optimizing | 0.39 ms |
Statistics | 1.28 ms |
Preparing | 0.06 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.22 ms |
Removing tmp table | 0.01 ms |
Sending data | 170.85 ms |
Creating sort index | 9.19 ms |
Removing tmp table | 31.69 ms |
Creating sort index | 0.05 ms |
End of update loop | 0.02 ms |
Removing tmp table | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Removing tmp table | 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.11 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 |