Время запроса: 2.03 ms После последнего запроса: 2.41 ms Память запроса: 0.023 MB. Память перед запросом: 7.501 MB Возвращено строк: 1
SELECT jg.id, jg.catid, jg.imgthumbname, jg.imgfilename, jg.owner, jg.imgauthor,
jg.imgdate, jg.imgtitle, jg.imgtext, jg.hits, jg.downloads, jg.imgvotes,
ROUND(LEAST(IF(imgvotes > 0, jg.imgvotesum/jg.imgvotes, 0.0), 5), 2) AS rating,
jgc.name AS cattitle, jgc.catpath AS catpath
FROM e5wyt_joomgallery AS jg
LEFT JOIN e5wyt_joomgallery_catg AS jgc
ON jgc.cid = jg.catid
WHERE jgc.published = 1
AND jg.approved = 1
AND jg.published = 1
AND jg.catid IN (668,709,708,702,693,692,690,682,674,669,664,716,707,701,700,699,691,685,681,680,678,675,673,672,671,670,667,665,499,655,653,652,651,647,644,643,637,636,635,633,630,629,620,619,614,608,607,606,605,603,600,599,597,592,587,586,584,577,571,566,564,563,561,558,557,556,555,554,553,552,549,548,547,542,541,537,535,534,533,532,531,530,529,527,526,524,523,515,513,508,507,505,503,502,501,500,364,495,492,491,490,487,484,483,482,481,480,479,478,476,475,474,473,469,468,467,466,464,462,461,459,458,457,455,447,438,437,436,435,434,433,432,430,427,426,425,423,420,417,416,403,398,397,396,395,394,393,392,391,390,389,388,387,386,385,380,379,377,376,375,374,365,289,366,363,362,361,360,357,356,354,353,351,350,345,342,340,339,336,335,327,322,321,319,318,317,316,315,314,313,312,311,309,306,305,303,300,298,297,296,295,294,293,292,290,222,288,286,285,284,283,282,278,277,276,275,274,273,272,269,268,267,266,265,264,263,262,260,259,258,257,256,255,254,253,252,251,250,249,248,245,242,241,239,234,233,232,231,230,229,228,227,226,225,224,223,166,220,215,212,210,209,206,204,202,197,196,195,194,193,192,190,189,188,187,186,185,183,182,181,180,179,178,176,175,174,170,169,168,167,142,649,617,613,612,494,346,333,332,165,164,143,86,9,48,28,31,61,57,55,51,49,66,163,158,157,144,140,139,136,132,130,129,128,127,126,124,123,121,120,112,111,107,104,101,100,98,91,82,81,79,69,68,67,63,706,705,704,703,638,632,631,596,595,594,574,540,539,538,525,520,518,512,511,510,472,470,445,444,443,442,441,440,439,429,428,422,421,418,415,414,413,412,411,410,409,408,407,406,402,401,400,399,359,358,349,348,328,325,324,323,291,208,200,199,198,177,173,146,138,116,115,106,103,92,26,84,64,45,713,712,683,660,654,648,641,640,639,618,616,615,602,601,562,550,514,504,431,405,404,373,370,369,368,367,347,343,304,302,280,244,236,207,205,201,171,162,161,160,155,149,148,131,125,122,114,113,97,96,90,80,76,75,62,53,46,41,717,676,642,471,383,355,352,344,326,279,237,214,191,184,147,118,110,109,108,50,42,40,32,650,610,604,424,378,337,172,141,137,117,37,36,35,34,33,29,627,720,624,623,213,85,30,626,718,488,271,625,719,489,270,27,528,493,371,243,159,156,151,150,119,87,77,14,698,696,686,677,659,658,657,656,645,621,591,573,570,522,454,221,219,56,25,24,23,22,21,20,19,18,17,16,15,13,697,695,694,689,661,622,576,572,565,560,546,545,519,509,506,498,449,448,446,341,301,154,153,152,145,134,133,102,83,65,60,59,54,44,43,89,11,715,714,711,688,687,666,663,662,646,628,611,598,593,590,589,588,585,583,582,580,579,578,575,569,568,567,559,544,543,536,521,496,485,477,465,463,460,456,453,452,451,450,419,384,381,334,331,330,320,310,308,307,299,287,281,247,246,211,203,105,99,95,94,78,58,52,47,39,38,12,2,710,684,634,609,581,551,517,516,497,486,382,372,329,261,238,135,74,73,72,71,70,88,8,7,6,5,3,4)
AND jg.access IN (1,1,5)
AND jgc.access IN (1,1,5)
AND jg.id = 952
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jg | const | PRIMARY,idx_catid | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | jgc | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
Starting | 0.47 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.30 ms |
Optimizing | 0.11 ms |
Statistics | 0.12 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.02 ms |
Commit | 0.01 ms |
Query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Query end | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.02 ms |
Updating status | 4.00 ms |
Reset for next command | 0.05 ms |
# | Вызывающий объект | Файл и номер строки |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/components/com_joomgallery/interface.php:1029 |
14 | JoomInterface->getPicture() | JROOT/plugins/content/joomplu/joomplu.php:130 |
13 | plgContentJoomPlu->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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 |