Витрачений час на запит: 0.47 ms Після останнього запиту: 1.64 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 8.426 MB Повернуто рядків: 0
SELECT ct.content_item_id as article_id, t.title as tag
FROM bibl_contentitem_tag_map as ct
LEFT JOIN bibl_tags AS t
ON t.id = ct.tag_id
WHERE ct.content_item_id in (1620,1619,1618,1617,1616,1615,1614,1613,1612,1611,1610,1609,1608,1606,1605,1604,1602,1601,1600,1599,1597,1596,1595,1594,1593,1591,1589,1588,1587,1586,1585,1584,1583,1582,1581,1579,1577,1576,1573,1571,1570,1569,1568,1567,1566,1564,1563,1562,1561,1560,1559,1558,1538,1530,1528,1527,1526,1525,1524,1522,1521,1520,1518,1517,1516,1514,1513,1512,1511,1510,1509,1508,1507,1506,1503,1502,1501,1500,1499,1498,1497,1496,1495,1494,1493,1490,1489,1488,1487,1485,1484,1482,1481,1480,1479,1478,1477,1475,1473,1472,1471,1470,1469,1467,1466,1465,1463,1462,1437,1435,1434,1430,1429,1427,1423,1421,1418,1416,1415,1413,1411,1409,1407,1405,1402,1393,1391,1389,1387,1385,1383,1381,1380,1378,1376,1373,1371,1370,1368,1365,1364,1363,1348,1347,1346,1345,1343,1341,1340,1339,1338,1337,1335,1334,1310,1308,1307,1305,1304,1302,1301,1299,1297,1296,1294,1293,1292,1291,1288,1287,1286,1265,1264,1263,1261,1260,1259,1258,1256,1255,1254,1253,1252,1251,1250,1249,1248,1247,1246,1244,1243,1242,1240,1239,1238,1237,1236,1235,1234,1233,1232,1230,1229,1228,1220,1218,1217,1216,1215,1214,1213,1206,1205,1202,1200,1199,1197,1196,1195,1193,1192,1191,1188,1186,1185,1184,1182,1181,1175,1173,1171,1170,1167,1165,1163,1162,1158,1155,1154,1153,1150,1148,1147,1143,1142,1141,1140,1136,1135,1134,1133,1132,1130,1119,1118,1117,1115,1114,1113,1112,1111,1110,1109,1108,1107,1103,1102,1101,1096,1094,1093,1092,1091,1089,1083,1082,1080,1078,1077,1075,1073,1071,1070,1069,1062,1061,1060,1059,1058,1056,1055,1054,1051,1050,1048,1047,1046,1044,1038,1037,1034,1033,1032,1031,1029,1028,1027,1024,1022,1021,1020,1019,1017,1015,1011,1007,1003,1001,1000,999,996,993,991,990,989,985,983,981,980,977,976,975,974,972,971,968,967,965,963,962,956,953,952,948,947,946,945,940,938,937,936,935,933,931,930,928,927,925,919,918,917,915,914,913,912,911,910,909,907,906,905,901,900,898,897,896,895,894,892,889,888,887,885,884,882,881,880,878,877,876,874,871,870,869,866,811,795,794,793,792,791,790,789,788,786,784,782,780,779,778,777,776,775,773,772,770,769,767,766,765,764,761,760,759,758,756,754,753,752,750,748,746,745,744,742,741,739,738,737,736,735,734,732,729,726,725,724,723,721,720,719,718,716,701,639,638,637,636,549,532,517,516,515,514,513,508,507,506,505,504,503,502,501,500,499,498,497,496,495,494,493,492,491,490,489,488,487,486,485,484,483,482,481,480,479,478,477,476,475,474,473,472,471,470,469,468,467,466,465,464,463,462,461,460,459,458,457,456,455,454,453,452,451,450,449,448,447,446,445,443,442,441,440,439,438,436,435,434,433,432,431,430,428,427,426,425,424,422,421,420,419,418,413,412,411,410,409,408,407,402,401,400,399,398,394,387,366,365,364,363,362,361,352,351,350,348,347,346,345,344,342,341,340,339,338,337,336,335,333,332,331,330,329,328,327,326,325,324,323,322,320,319,318,317,316,313,312,311,310,309,308,305,304,302,301,275,271,270,231,230,229,228,227,226,225,224,223,222,221,220,219,218,217,216,215,214,213,212,211,210,209,208,207,206,205,204,203,202,201,200,199,198,197,196,195,194,193,192,191,190,189,188,187,186,185,184,183,182,181,180,179,178,177,176,175,174,173,172,171,170,169,168,166,165,164,163,162,161,160,159,158,157,156,155,154,152,150,149,148,147,146,145,144,143,142,141,140,139,138,137,136,134,133,131,129,128,127,126,125,124,123,121,119,118,116,114,113,108,107,99,112,98,97,96,95,93,94,92,90,89,88,76,75,72,74,77,73,91,64,70,69,59,57,56,55,54,58,53,52,51,50,49,48,47,46,45,44,4)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | ct | index | NULL | idx_core_content_id | 4 | NULL | 1 | Using where; Using index |
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | bibl_biblioDB.ct.tag_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| table lock | 0.00 ms |
| init | 0.09 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.02 ms |
| Preparing | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| closing tables | 0.00 ms |
| Query end | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Виклик | Номер файлу та рядка |
|---|
| 29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 28 | JDatabaseDriver->loadAssocList() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26 |
| 27 | RokSprocket_Provider_Joomla_TagMerge->populateTags() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159 |
| 26 | RokSprocket_Provider_Joomla->populateTags() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62 |
| 25 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
| 24 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
| 23 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
| 22 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
| 21 | ModRokSprocket->_realGetData() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
| 20 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
| 19 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
| 18 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 17 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/components/com_sppagebuilder/addons/module/site.php:51 |
| 16 | SppagebuilderAddonModule->render() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:469 |
| 15 | AddonParser::getAddonHtmlView() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:315 |
| 14 | AddonParser::viewAddons() | JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95 |
| 13 | include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/components/com_sppagebuilder/views/page/view.html.php:47 |
| 10 | SppagebuilderViewPage->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sppagebuilder/controller.php:81 |
| 8 | SppagebuilderController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sppagebuilder/sppagebuilder.php:24 |
| 6 | require_once JROOT/components/com_sppagebuilder/sppagebuilder.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 |