Abfragezeit: 293.33 ms Nach letzter Abfrage: 1.12 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.588 MB Zeilen zurückgegeben: 1
SELECT p.id AS id, p.catid, p.imgthumbname, p.imgfilename, p.imgtitle,p.imgtext,p.imgdate as imgdate,c.cid AS ccid, c.catpath AS catpath
FROM j25_joomgallery AS p
LEFT JOIN j25_joomgallery_catg AS c
ON c.cid = p.catid
WHERE c.published = 1
AND c.access IN (1,1,2,3)
AND p.published = 1
AND p.approved = 1
AND p.access IN (1,1,2,3)
AND p.catid IN (169,170,168,171,167,254,220,175,174,173,172,670,831,839,638,706,705,838,701,708,707,837,734,737,736,735,836,755,757,756,835,775,779,778,777,776,834,798,801,800,799,833,806,811,810,809,808,807,832,844,843,842,841,840,56,502,506,505,504,503,501,500,499,46,851,852,859,858,857,856,855,854,853,805,797,770,747,746,732,738,733,676,709,717,721,720,719,718,712,716,715,714,713,711,710,692,696,699,698,697,695,694,693,685,691,690,689,688,687,686,681,684,683,682,678,680,679,677,586,641,645,649,648,647,646,644,654,653,652,651,650,643,642,617,622,621,620,619,618,595,600,599,598,597,596,590,594,593,592,591,587,589,588,465,537,548,547,545,546,544,543,542,541,540,539,538,507,509,508,494,498,497,496,495,489,493,492,491,490,466,320,415,426,425,424,423,422,421,420,419,418,417,416,405,414,413,412,411,410,409,408,407,406,402,404,403,373,380,379,378,377,376,375,374,357,369,368,367,366,365,364,363,362,361,360,359,358,353,356,355,354,326,329,328,327,321,325,324,323,322,188,294,303,302,301,300,299,298,297,296,295,270,274,273,272,271,256,257,267,266,265,264,263,262,261,260,259,258,255,238,241,240,239,189,192,191,190,49,121,125,124,123,122,113,120,119,118,117,116,115,114,106,112,111,110,109,108,107,48,105,100,104,103,102,101,95,99,98,97,96,47,94,93,42,864,869,865,868,867,866,862,863,845,850,849,846,848,847,815,821,820,816,819,818,817,795,814,813,812,804,803,802,796,784,794,793,791,786,788,787,785,759,780,769,768,761,760,740,758,754,753,745,744,741,743,742,722,739,731,725,724,723,671,700,672,675,674,673,573,581,585,584,583,582,574,578,577,576,575,454,564,567,566,565,525,536,535,534,533,532,531,530,529,528,527,526,455,459,460,458,457,456,311,370,372,371,312,316,315,314,313,180,269,243,253,252,251,250,249,248,247,246,245,244,226,237,236,235,234,233,232,231,230,229,228,227,223,225,224,217,219,218,181,185,184,183,182,45,154,166,165,164,163,162,161,160,159,158,157,156,155,150,153,152,151,146,149,148,147,142,145,144,143,137,141,140,139,138,44,136,43,135,134,4,55,133,132,131,54,130,129,53,128,127,126,3,789,790,762,763,767,766,765,764,748,749,752,751,750,726,727,730,729,728,601,655,659,669,668,667,666,665,664,658,663,662,661,660,657,656,623,626,625,637,636,635,634,633,632,631,624,630,629,628,627,602,605,610,609,608,607,606,604,603,616,615,614,613,612,611,467,549,558,557,563,562,561,560,559,550,556,555,554,553,552,551,510,518,512,524,523,522,521,520,519,511,517,516,515,514,513,468,471,470,482,481,480,479,478,477,469,476,475,474,473,472,330,432,443,433,434,435,436,437,438,442,446,445,444,440,441,439,381,384,401,400,399,398,397,396,395,383,394,392,391,390,382,389,388,387,386,385,331,351,344,350,349,348,347,346,345,338,343,342,341,340,339,332,337,336,335,334,333,193,275,292,278,293,291,290,289,288,277,287,286,285,284,283,276,282,281,280,279,194,203,197,215,212,214,213,211,210,209,196,208,207,206,205,204,195,202,200,199,198,52,88,92,91,90,89,66,69,87,86,85,84,83,82,68,81,80,79,78,77,67,76,75,74,73,72,71,70,51,62,65,64,63,59,61,60,50,58,57,2,570,580,579,572,571,450,569,568,486,488,487,483,485,484,461,464,463,462,453,452,451,307,448,447,352,319,318,317,310,309,308,176,306,305,304,242,216,187,186,179,178,177,7,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,6,26,25,24,23,22,21,20,19,18,17,16,5,11,15,10,9,8)
AND c.hidden = 0
AND c.in_hidden = 0
AND p.hidden = 0
ORDER BY rand()
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | c | NULL | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 831 | 0.12 | Using where; Using temporary; filesort wurde genutzt |
1 | SIMPLE | p | NULL | ref | idx_catid | idx_catid | 4 | usr_web312_1.c.cid | 134 | 0.04 | Using where |
Status | Duration |
---|
starting | 0.27 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.12 ms |
System lock | 0.01 ms |
optimizing | 0.04 ms |
statistics | 0.93 ms |
preparing | 0.06 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.00 ms |
Sending data | 273.65 ms |
Creating sort index | 17.34 ms |
end | 0.06 ms |
query end | 0.01 ms |
removing tmp table | 0.53 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.09 ms |
cleaning up | 0.01 ms |
# | Aufrufer | Datei und Zeilennummer |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_joomimg/helper.php:560 |
12 | modJoomImagesHelper->getDBImages() | JROOT/modules/mod_joomimg/helper.php:51 |
11 | modJoomImagesHelper->fillObject() | JROOT/modules/mod_joomimg/mod_joomimg.php:50 |
10 | include JROOT/modules/mod_joomimg/mod_joomimg.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:511 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
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:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |