Abfragezeit: 6.00 ms Nach letzter Abfrage: 7.37 ms Abfragespeichernutzung: 0.084 MB Speichernutzung vor Abfrage: 28.490 MB Zeilen zurückgegeben: 856
SELECT ct.content_item_id as article_id, t.title as tag
FROM k3h6v_contentitem_tag_map as ct
LEFT JOIN k3h6v_tags AS t
ON t.id = ct.tag_id
WHERE ct.content_item_id in (1578,1579,1574,1577,1576,1575,1571,1572,1570,1569,1568,1567,1573,1565,1566,1564,1562,1563,1560,1561,1558,1559,1556,1557,1554,1553,1552,1555,1551,1549,1548,1550,1545,1547,1544,1546,1543,1542,1541,1540,1539,1538,1535,1537,1536,1534,1533,1532,1531,1530,1529,1528,1527,1526,1525,1524,1522,1523,1521,1517,1518,1520,1519,1516,1515,1514,1513,1512,1511,1510,1508,1509,1507,1506,1505,1504,1503,1501,1500,1502,1499,1498,1497,1496,1495,1493,1494,1491,1492,1489,1490,1488,1487,1486,1484,1485,1483,1481,1482,1480,1479,1478,1477,1475,1476,1474,1473,1472,1471,1470,1469,1467,1468,1465,1466,1462,1464,1463,1461,1459,1460,1458,1457,1456,1455,1453,1454,1452,1451,1450,1449,1447,1448,1445,1446,1444,1442,1443,1440,1441,1436,1435,1434,1439,1438,1433,1437,1432,1431,1430,1429,1428,1427,1425,1426,1424,1423,1421,1422,1420,1418,1419,1417,1416,1415,1413,1414,1411,1412,1410,1408,1409,1407,1406,1405,1404,1403,1402,1400,1401,1399,1398,1397,1396,1395,1393,1394,1391,1392,1389,1390,1385,1388,1384,1383,1381,1382,1379,1380,1377,1378,1375,1376,1373,1374,1371,1372,1369,1370,1367,1368,1365,1366,1362,1364,1361,1360,1359,1358,1357,1356,1355,1354,1353,1352,1351,1350,1349,1348,1347,1346,1345,1344,1343,1342,1340,1341,1338,1339,1336,1335,1334,1337,1333,1332,1331,1330,1329,1327,1328,1326,1325,1324,1323,1322,1321,1320,1319,1318,1317,1315,1316,1314,1313,1312,1311,1310,1309,1306,1308,1307,1305,1304,1302,1303,1301,1300,1299,1297,1298,1296,1295,1294,1293,1290,1292,1291,1288,1289,1287,1286,1285,1284,1283,1282,1281,1280,1279,1278,1277,1276,1275,1274,1273,1272,1271,1270,1269,1267,1268,1265,1264,1263,1262,1261,1260,1258,1257,1259,1256,1255,1254,1253,1252,1251,1250,1248,1249,1247,1246,1244,1243,1242,1245,1240,1239,1238,1237,1236,1234,1235,1233,1232,1227,1231,1229,1228,1226,1225,1224,1222,1223,1221,1220,1218,1217,1216,1215,1214,1207,1206,1205,1213,1212,1204,1203,1202,1201,1211,1209,1208,1210,1200,1198,1199,1197,1196,1195,1194,1192,1191,1190,1189,1188,1187,1186,1185,1184,1183,1182,1181,1175,1180,1174,1178,1158,1173,1177,1172,1176,1171,1170,1169,1168,1167,1166,1165,1164,1163,1162,1161,1160,1159,1157,1156,1179,1155,1154,1153,1152,1150,1151,1149,1148,1138,1147,1146,1145,1144,1143,1142,1137,1136,1135,1134,1133,1131,1132,1130,1129,1128,1127,1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,1111,1110,1109,1108,1107,1106,1105,1104,1103,1102,1101,1100,1099,1098,1096,1097,1095,1094,1093,1092,1091,1090,1089,1087,1088,1086,1085,1084,1083,1082,1081,1080,1079,1078,1075,1074,1073,1072,1071,1070,1069,1067,1068,1066,1065,1064,1062,1061,1060,1059,1063,1058,1057,1056,1054,1053,1052,1051,1050,1049,1048,1047,1046,1045,1044,1043,1042,1041,1040,1039,1038,1037,1036,1035,1034,1033,1032,1031,1030,1029,1028,1027,1026,1025,1024,1023,1021,1020,1022,1019,1018,1017,1016,1015,1014,1013,1012,1011,1010,1009,1008,1007,1006,1005,1004,1000,998,997,999,996,995,994,993,992,991,990,989,984,982,981,980,979,978,977,976,975,974,973,972,970,969,967,966,962,965,964,963,958,957,956,953,955,951,950,948,947,946,657,945,943,942,940,936,935,927,916,913,912,652,910,641,884,882,870,863,862,861,858,660,857,644,643,852,642,848,847,635,839,838,834,634,833,648,662,832,831,822,663,811,637,809,808,807,806,805,804,803,802,801,653,800,799,797,798,629,794,792,789,631,632,651,787,786,785,782,781,780,779,775,774,773,772,770,764,763,762,761,760,759,758,756,646,755,647,754,753,748,747,742,741,645,740,736,735,658,726,725,724,723,722,661,721,654,630,719,716,633,710,706,705,659,698,656,692,655,681,638,679,676,673,649,666,650,614,608,607,605,598,584,586,585,583,582,581,578,565,564,559,553,552,550,549,547,546,536,545,533,523,521,520,517,516,515,514,503,501,500,496,437,478,477,466,435,429,433,382,383,402,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,403,404,405,406,407,408,409,410,411,412,413,414,415,416,418,419,384,378,371,370,372,368,366,354,341,321,309,298,297,294,279,293,280,287,286,284,276,283,278,275,263,256,258,257,253,249,244,243,240,242,238,236,235,234,233,232,230,231,229,228,227,226,225,222,221,211,219,213,214,215,210,209,216,208,199,207,200,201,198,203,189,205,204,190,206,197,191,192,196,194,172,173,187,185,174,175,184,183,177,178,179,163,180,171,165,170,166,169,164,168,162,167,161,160,155,159,156,137,136,135,154,152,151,129,131,149,148,125,147,126,145,142,127,141,138,139,123,122,124,118,121,117,116,110,109,108,107,97,96,94,92,91,88,87,86,84,85,83,82,81,80,78,79,77,76,75,74,73,64,67,72,66,65,59,40,39,38)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ct | NULL | index | NULL | uc_ItemnameTagid | 11 | NULL | 3730 | 50.00 | Using where; Using index |
1 | SIMPLE | t | NULL | eq_ref | PRIMARY | PRIMARY | 4 | usrdb_priesnbh_joomla.ct.tag_id | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.40 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.21 ms |
init | 0.11 ms |
System lock | 0.01 ms |
optimizing | 0.04 ms |
statistics | 0.05 ms |
preparing | 0.05 ms |
executing | 0.00 ms |
Sending data | 4.97 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 2.05 ms |
cleaning up | 0.02 ms |
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
20 | JDatabaseDriver->loadAssocList() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26 |
19 | RokSprocket_Provider_Joomla_TagMerge->populateTags() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159 |
18 | RokSprocket_Provider_Joomla->populateTags() | JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62 |
17 | RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:294 |
16 | RokSprocket::getItems() | JROOT/components/com_roksprocket/lib/RokSprocket.php:230 |
15 | RokSprocket::getItemsWithParams() | JROOT/components/com_roksprocket/lib/RokSprocket.php:55 |
14 | RokSprocket->getData() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52 |
13 | ModRokSprocket->_realGetData() | JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80 |
12 | RokSprocket_PlatformHelper_Joomla->getFromCache() | JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37 |
11 | ModRokSprocket->getData() | JROOT/modules/mod_roksprocket/mod_roksprocket.php:38 |
10 | include JROOT/modules/mod_roksprocket/mod_roksprocket.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |