Време на заявката: 2.91 ms След последната заявка: 0.44 ms Памет за заявки: 0.056 MB Памет преди заявката: 3.448 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:24:10')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-02-05 18:24:10')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(316,321,325,1218,1499,1551,1762,3365,3502,6082,6217,7153,7275,7280,7297,7581,7627,7653,7669,8121,8258,8447,8465,8542,8582,8615,8839,8889,8988,9056,9208,9209,9402,9638,9668,9762,10120,10162,10172,10334,10506,10535,10536,10545,10547,10550,10552,10633,10730,10731,10769,10788,10811,10826,10921,10951,10953,11000,11021,11025,11082,11124,11199,11703,11760,11842,12090,12168,12197,12233,12334,12365,12547,12586,12675,12700,12747,12763,12770,12775,12811,12853,12864,12865,12971,12985,13027,13065,13082,13182,13191,13205,13206,13227,13251,13331,13336,13356,13364,13368,13390,13433,13435,13436,13446,13516,13529,13537,13540,13544,13554,13583,13597,13646,13743,13807,13833,13842,13862,14030,14036,14037,14038,14040,14049,14055,14060,14065,14069,14077,14081,14095,14100,14104,14112,14114,14123,14125,14129,14160,14164,14168,14200,14201,14234,14247,14261,14275,14293,14296,14301,14319,14321,14331,14332,14339,14345,14358,14371,14372,14374,14380,14397,14410,14423,14424,14434,14435,14452,14457,14469,14473,14476,14480,14529,14542,14560,14561,14568,14576,14585,14608,14632,14636,14653,14654,14669,14672,14673,14675,14679,14680,14685,14687,14691,14696,14697,14699,14704,14705,14723,14732,14734,14738,14779,14804,14810,14823,14841,14881,14911,14913,14915,14923,14928,14946,14960,14961,14962,14983,14995,14997,15003,15011,15015,15039,15052,15056,15066,15069,15096,15114,15126,15128,15158,15160,15162,15165,15205,15232,15258,15292,15297,15305,15316,15343,15376,15378,15434,15441,15454,15457,15463,15473,15502,15569,15589,15644,15695,15713,15735,15768,15784,15789,15790,15792,15899,15937,15972,15977,15979,15981,15983,15986,15988,15990,15991,16002,16016,16017,16018,16021,16025,16027,16038,16046,16052,16053,16054,16063,16067,16078,16080,16082,16084,16090,16105,16108,16120,16125,16128,16136,16150,16160,16161,16173,16181,16189,16206,16208,16216,16241,16246,16253,16259,16262,16263,16268,16287,16303,16337,16340,16341,16348,16364,16404,16428,16444,16459,16469,16486,16494,16500,16503,16521,16530,16536,16542,16563,16590,16630,16635,16650,16675,16716,16741,16754,16773,16814,16827,16857,16860,16885,16898,16924,16947,16963,16982,17001,17036,17069,17073,17116,17150,17153,17176,17178,17199,17229,17244,17257,17276,17310,17317,17327,17329,17396,17407,17435,17446,17448,17477,17516,17523,17525,17581,17583,17605,17639,17642,17644,17660,17696,17721,17732,17797,17825,17868,17914,17922,17941,17944,17973,17974,17987,17988,18022,18025,18059,18063,18076,18140,18214,18216,18226,18272,18274,18314,18352,18378,18417,18421,18439,18471,18490,18512,18559,18634,18636,18738,18748,18753,18755,18764,18794,18800,18813,18815,18827,18851,18860,18872,18874,18890,18914,18916,18932,18945,18976,18994,19000,19042,19050,19055,19059,19060,19073,19080,19092,19123,19124,19130,19152,19164,19166,19167,19180,19183,19194,19201,19206,19216,19218,19221,19225,19236,19239,19246,19248,19252,19255,19261,19316,19328,19349,19399,19416,19420,19426,19428,19447,19454,19519,19543,19544,19570,19592,19602,19604,19633,19635,19639,19658,19665,19688,19716,19734,19768,19801,19815,19833,19835,19836,19837,19838,19839,19840,19841,19846,19854,19869,19872,19879,19881,19883,19884,19886,19890,19891,19895,19903,19906,19908,19909,19913,19914,19917,19919,19939,19942,19951,19953,19967,19972,19973,19976,20003,20007,20009,20012,20016,20022,20034,20044,20045,20053,20056,20062,20068,20073,20079,20092,20121,20124,20125,20127,20128,20139,20144,20146,20148,20160,20163,20166,20176,20182,20185,20188,20201,20203,20204,20211,20212,20214,20218,20230,20232,20239,20243,20254,20260,20269,20282,20286,20297,20317,20325,20331,20335,20380,20384,20385,20399,20400,20407,20425,20428,20429,20443,20455,20468,20469,20518,20520,20547,20548,20551,20560,20576,20604,20637,20638,20645,20651,20672,20677,20680,20684,20688,20708,20727,20732,20757,20761,20763,20770,20785,20790,20859,20863,20866,20870,20884,20886,20892,20895,20908,20961,21034,21041,21081,21086,21247)
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 | 653 | 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.13 ms |
Optimizing | 0.09 ms |
Statistics | 0.89 ms |
Preparing | 0.98 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.32 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.01 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 |