[1]
SELECT @@SESSION.sql_mode
(this query time : 0.000 s)
(total SQL time : 0.000 s)
(total time : 0.005 s)
(num rows : 1 )
[2]
SELECT param, value
FROM g_config
;
(this query time : 0.001 s)
(total SQL time : 0.001 s)
(total time : 0.006 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D8491cf9d4550864236ae18f06aac869dc13'
;
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.006 s)
(num rows : 1 )
[4]
SELECT * FROM g_plugins
WHERE state='active'
(this query time : 0.000 s)
(total SQL time : 0.002 s)
(total time : 0.007 s)
(num rows : 9 )
[5]
SELECT
image_id,
date_available,
NOW() AS dbnow
FROM g_lounge
JOIN g_images ON image_id = id
ORDER BY image_id ASC
LIMIT 1
;
(this query time : 0.003 s)
(total SQL time : 0.005 s)
(total time : 0.012 s)
(num rows : 0 )
[6]
SELECT id AS id
, username AS username
, password AS password
, mail_address AS email
FROM g_users
WHERE id = '2'
(this query time : 0.001 s)
(total SQL time : 0.005 s)
(total time : 0.012 s)
(num rows : 1 )
[7]
SELECT
ui.*,
uc.*,
t.name AS theme_name
FROM g_user_infos AS ui
LEFT JOIN g_user_cache AS uc ON ui.user_id = uc.user_id
LEFT JOIN g_themes AS t ON t.id = ui.theme
WHERE ui.user_id = 2
;
(this query time : 0.000 s)
(total SQL time : 0.006 s)
(total time : 0.013 s)
(num rows : 1 )
[8]
SELECT *
FROM g_user_infos
WHERE user_id = 2
;
(this query time : 0.000 s)
(total SQL time : 0.006 s)
(total time : 0.013 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (12,32)
(this query time : 0.001 s)
(total SQL time : 0.007 s)
(total time : 0.022 s)
(num rows : 2 )
[9]
SELECT id
FROM g_images i
INNER JOIN g_image_category ic ON id=ic.image_id
INNER JOIN g_image_tag it ON id=it.image_id
WHERE tag_id IN (12,32)
AND (category_id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212) AND level<=0)
GROUP BY id
HAVING COUNT(DISTINCT tag_id)=2
ORDER BY date_creation DESC, file ASC, id ASC
(this query time : 0.046 s)
(total SQL time : 0.052 s)
(total time : 0.068 s)
(num rows : 999 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 19315
;
(this query time : 0.001 s)
(total SQL time : 0.053 s)
(total time : 0.069 s)
(affected rows : 1 )
[11]
SELECT id,uppercats,commentable,visible,status,global_rank
FROM g_image_category
INNER JOIN g_categories ON category_id = id
WHERE image_id = 19315
AND (id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212))
;
(this query time : 0.000 s)
(total SQL time : 0.053 s)
(total time : 0.069 s)
(num rows : 1 )
[12]
SELECT *
FROM g_images
WHERE id IN (19315,19316,33560,19309,14858)
;
(this query time : 0.000 s)
(total SQL time : 0.054 s)
(total time : 0.070 s)
(num rows : 5 )
[13]
SELECT t.*, count(*) AS counter
FROM g_image_tag
INNER JOIN g_tags t ON tag_id = id
WHERE image_id IN (19315)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.001 s)
(total SQL time : 0.055 s)
(total time : 0.078 s)
(num rows : 9 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,586,660)
(this query time : 0.000 s)
(total SQL time : 0.055 s)
(total time : 0.078 s)
(num rows : 3 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 19315 AND validated = 'true'
;
(this query time : 0.004 s)
(total SQL time : 0.059 s)
(total time : 0.084 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (33560,33565,33448,33465,33251,33229,33232,33073,33077,33032,33035,33036,33037,33038,33040,33042,33039,33103,33104,33105,33109,33110,33108,33113,33111,33112,33013,32988,32984,32963,32959,32903,32906,32861,32853,32847,32809,32808,32807,32791,32789,32788,32742,32759,32760,32768,32769,32757,32770,32771,32772,32740,32739,32738,32737,32736,32735,32734,32730,32703,32685,32651,32453,32425,32424,32417,32170,32193,32166,32100,31959,31850,31733,31727,31726,31723,31639,31596,31576,31234,31398,31103,31346,30960,30957,30641,30598,30590,30589,30588,30587,30586,31016,30577,30568,30499,30470,29722,30212,30251,29837,29838,29840,29841,29842,29844,29846,29859,29861,29870,29877,29882,29889,29887,29779,29760,29774,29644,29650,29670,29673,29676,29674,29609,29610,29612,29615,29617,29616,29618,29641,29638,29541,29543,29551,29554,29581,29587,29597,29526,29513,29474,29476,29477,29487,29489,29497,29423,29424,29429,29430,29438,29437,29440,29442,29443,29444,29446,29450,29451,29449,29454,29456,29460,29462,29406,29410,29416,29420,29389,29391,29392,29393,29394,29395,29396,29397,29292,29301,29306,29308,29386,29309,29310,29312,29316,29320,29321,29330,29331,29332,29333,29334,29338,29348,29350,29356,29362,29371,29372,29376,29377,29378,29380,29290,29157,29160,29161,29165,29167,29169,29173,29181,29202,29203,29204,29206,29205,29207,29212,29214,29215,29216,29217,29221,29224,29233,29237,29252,29253,29155,29145,29140,29142,29092,29046,29047,29048,29051,29055,28991,28993,28994,29014,29036,28984,28983,28980,28978,28971,28965,28959,28944,28907,28902,28899,28890,28891,28885,28886,28880,28879,28878,28873,28868,28869,28805,28802,28794,28753,28754,28762,28727,28729,28731,28732,28733,28734,28738,28749,28712,28697,28696,28695,28691,28689,28687,28686,28684,28683,28678,28670,28655,28650,28648,28645,28644,28643,28638,28637,28624,28625,28617,28623,28616,28615,28614,28612,28611,28610,28609,28608,28603,28602,28599,28596,28595,28593,28594,28592,28590,28589,28583,28581,28579,28576,28572,28568,28566,28565,28564,28563,28559,28558,28556,28555,28554,28552,28551,28550,28549,28547,28546,28544,28543,28540,28538,28537,28536,28535,28532,28529,28527,28526,28525,28524,28523,28522,28520,28519,28518,28517,28508,28456,28455,28451,28389,28374,28360,28362,28354,28355,28350,28339,28342,28325,28322,28317,28321,28318,28319,28314,28313,28312,28261,28263,28258,28223,28217,28216,28210,28208,28195,28194,28131,28134,28139,28142,28149,28150,28151,28152,28153,28154,28156,28158,28159,28174,28123,28113,28109,28098,28187,28094,28093,28092,28091,28084,28022,28014,28013,28186,28012,27996,27937,27939,27940,27868,27852,27850,27818,27775,27769,27768,27894,27893,27760,27759,27758,27755,27752,27751,27750,27749,27748,27744,27742,27741,27740,27735,27730,27711,27710,27709,27708,27707,27706,27705,27645,27643,27642,27638,27560,27557,27540,27539,27520,27518,27517,27494,27484,27483,27479,27477,27475,27474,27473,27459,27451,27448,27445,27435,27434,27426,27423,27422,27421,27420,27419,27418,27416,27415,27414,27411,27412,27413,27351,26883,27339,27334,27329,27323,27322,27320,27317,27148,27307,27223,26975,26993,26999,27018,27099,27047,27058,27060,27065,27073,27077,27081,26889,26885,26884,26882,26881,27079,26880,26879,26878,27082,27083,26872,26809,26784,26782,26729,26728,26727,26726,26583,26340,26342,26666,26667,26670,26671,26672,26522,26521,26520,26518,26517,26516,26515,26496,26494,26491,26490,26484,26404,26260,26179,26170,25428,25427,25255,25240,25239,25205,25204,25203,25175,25139,24893,24878,24877,24871,24870,24843,24842,24841,24840,24829,24828,24818,24806,24805,24795,24687,24686,24685,24684,24675,24605,24586,24585,24584,24583,24582,24581,24580,24572,24571,24553,24480,24476,24466,24457,24455,24454,24447,24451,24450,24436,24434,24433,24428,24423,24422,24420,24418,24416,24412,24352,24351,24348,24347,24346,24342,24324,24323,24314,24312,24293,24284,24276,24275,24274,24273,24272,24187,24383,24130,24149,24148,24126,24125,24124,24120,24119,24121,24116,24117,24122,24123,24118,24110,24111,24061,23909,23831,23837,23838,23685,23681,23679,23678,23677,23673,23667,23664,23655,23663,23545,23532,23479,23469,23470,23454,23450,23451,23410,23382,23384,23404,23345,23344,23343,23346,23334,23282,23281,23283,23220,23216,23202,23166,22217,22218,22176,22172,22169,22093,22110,22112,22113,22114,22129,22131,22132,22133,22139,22143,22144,22079,22037,21988,21987,21986,21982,21977,21976,21950,21945,21940,21852,21851,21850,21808,21807,21806,21784,21372,21371,21300,21286,21051,20806,20788,20781,20713,20712,20711,20710,20709,20708,20707,20703,20700,20699,20686,20685,20650,20645,20643,20639,20615,20612,20610,20609,20613,20614,20603,20598,20513,20512,20511,20504,20590,20503,20496,20444,20443,20442,20441,20438,20437,20436,20156,20137,20136,20135,19988,19720,19745,19683,19682,19676,19674,19677,19678,19675,19673,19669,19672,19670,19668,19667,19671,19640,19508,19481,19477,19473,19392,19334,19333,19327,19316,19315,19309,19307,19305,19306,19207,19034,19018,19017,18763,18465,18419,18254,18236,18107,18099,18069,18016,18017,17743,17819,17859,17539,17542,17534,17517,17473,17381,17378,17299,17191,17192,17171,17161,17160,17157,15602,15640,16939,17008,17065,17078,17088,17098,17099,16898,16892,16633,16632,16629,16630,16628,16626,16595,16465,16448,16440,16439,16426,16425,16408,16407,16405,16340,16342,16339,16292,16341,16262,16180,16174,16013,16012,15994,15912,15909,15903,15878,15873,15872,15868,15867,15849,15702,15669,15662,15664,15660,15654,15652,15647,15646,15643,15642,15644,15415,15396,15455,15394,15382,15383,15380,15378,15377,15385,15351,15350,15345,15348,15344,15329,15315,15294,15291,15289,15148,15095,14040,13883,13864,13863,13821,13818,13807,13652,13612,13608,13637,13512,13511,13509,13436,13490,13497,13498,13388,13394,13322,13348,12653,12652,10754,10396,10397,10398,10399,9678,9479,9574,9575,9258,8863,8865,8867,8881,8882,8885,8884,8888,8889,8802,8801,8792,10260,14282,14250,14249,14246,14220,12372,12366,12373,5543,5529,5505,5259,4263,4257,4233,3977,3978,3923,3614,3907,7,2,15,14778,14863,14858)
ORDER BY FIELD(id, 33560,33565,33448,33465,33251,33229,33232,33073,33077,33032,33035,33036,33037,33038,33040,33042,33039,33103,33104,33105,33109,33110,33108,33113,33111,33112,33013,32988,32984,32963,32959,32903,32906,32861,32853,32847,32809,32808,32807,32791,32789,32788,32742,32759,32760,32768,32769,32757,32770,32771,32772,32740,32739,32738,32737,32736,32735,32734,32730,32703,32685,32651,32453,32425,32424,32417,32170,32193,32166,32100,31959,31850,31733,31727,31726,31723,31639,31596,31576,31234,31398,31103,31346,30960,30957,30641,30598,30590,30589,30588,30587,30586,31016,30577,30568,30499,30470,29722,30212,30251,29837,29838,29840,29841,29842,29844,29846,29859,29861,29870,29877,29882,29889,29887,29779,29760,29774,29644,29650,29670,29673,29676,29674,29609,29610,29612,29615,29617,29616,29618,29641,29638,29541,29543,29551,29554,29581,29587,29597,29526,29513,29474,29476,29477,29487,29489,29497,29423,29424,29429,29430,29438,29437,29440,29442,29443,29444,29446,29450,29451,29449,29454,29456,29460,29462,29406,29410,29416,29420,29389,29391,29392,29393,29394,29395,29396,29397,29292,29301,29306,29308,29386,29309,29310,29312,29316,29320,29321,29330,29331,29332,29333,29334,29338,29348,29350,29356,29362,29371,29372,29376,29377,29378,29380,29290,29157,29160,29161,29165,29167,29169,29173,29181,29202,29203,29204,29206,29205,29207,29212,29214,29215,29216,29217,29221,29224,29233,29237,29252,29253,29155,29145,29140,29142,29092,29046,29047,29048,29051,29055,28991,28993,28994,29014,29036,28984,28983,28980,28978,28971,28965,28959,28944,28907,28902,28899,28890,28891,28885,28886,28880,28879,28878,28873,28868,28869,28805,28802,28794,28753,28754,28762,28727,28729,28731,28732,28733,28734,28738,28749,28712,28697,28696,28695,28691,28689,28687,28686,28684,28683,28678,28670,28655,28650,28648,28645,28644,28643,28638,28637,28624,28625,28617,28623,28616,28615,28614,28612,28611,28610,28609,28608,28603,28602,28599,28596,28595,28593,28594,28592,28590,28589,28583,28581,28579,28576,28572,28568,28566,28565,28564,28563,28559,28558,28556,28555,28554,28552,28551,28550,28549,28547,28546,28544,28543,28540,28538,28537,28536,28535,28532,28529,28527,28526,28525,28524,28523,28522,28520,28519,28518,28517,28508,28456,28455,28451,28389,28374,28360,28362,28354,28355,28350,28339,28342,28325,28322,28317,28321,28318,28319,28314,28313,28312,28261,28263,28258,28223,28217,28216,28210,28208,28195,28194,28131,28134,28139,28142,28149,28150,28151,28152,28153,28154,28156,28158,28159,28174,28123,28113,28109,28098,28187,28094,28093,28092,28091,28084,28022,28014,28013,28186,28012,27996,27937,27939,27940,27868,27852,27850,27818,27775,27769,27768,27894,27893,27760,27759,27758,27755,27752,27751,27750,27749,27748,27744,27742,27741,27740,27735,27730,27711,27710,27709,27708,27707,27706,27705,27645,27643,27642,27638,27560,27557,27540,27539,27520,27518,27517,27494,27484,27483,27479,27477,27475,27474,27473,27459,27451,27448,27445,27435,27434,27426,27423,27422,27421,27420,27419,27418,27416,27415,27414,27411,27412,27413,27351,26883,27339,27334,27329,27323,27322,27320,27317,27148,27307,27223,26975,26993,26999,27018,27099,27047,27058,27060,27065,27073,27077,27081,26889,26885,26884,26882,26881,27079,26880,26879,26878,27082,27083,26872,26809,26784,26782,26729,26728,26727,26726,26583,26340,26342,26666,26667,26670,26671,26672,26522,26521,26520,26518,26517,26516,26515,26496,26494,26491,26490,26484,26404,26260,26179,26170,25428,25427,25255,25240,25239,25205,25204,25203,25175,25139,24893,24878,24877,24871,24870,24843,24842,24841,24840,24829,24828,24818,24806,24805,24795,24687,24686,24685,24684,24675,24605,24586,24585,24584,24583,24582,24581,24580,24572,24571,24553,24480,24476,24466,24457,24455,24454,24447,24451,24450,24436,24434,24433,24428,24423,24422,24420,24418,24416,24412,24352,24351,24348,24347,24346,24342,24324,24323,24314,24312,24293,24284,24276,24275,24274,24273,24272,24187,24383,24130,24149,24148,24126,24125,24124,24120,24119,24121,24116,24117,24122,24123,24118,24110,24111,24061,23909,23831,23837,23838,23685,23681,23679,23678,23677,23673,23667,23664,23655,23663,23545,23532,23479,23469,23470,23454,23450,23451,23410,23382,23384,23404,23345,23344,23343,23346,23334,23282,23281,23283,23220,23216,23202,23166,22217,22218,22176,22172,22169,22093,22110,22112,22113,22114,22129,22131,22132,22133,22139,22143,22144,22079,22037,21988,21987,21986,21982,21977,21976,21950,21945,21940,21852,21851,21850,21808,21807,21806,21784,21372,21371,21300,21286,21051,20806,20788,20781,20713,20712,20711,20710,20709,20708,20707,20703,20700,20699,20686,20685,20650,20645,20643,20639,20615,20612,20610,20609,20613,20614,20603,20598,20513,20512,20511,20504,20590,20503,20496,20444,20443,20442,20441,20438,20437,20436,20156,20137,20136,20135,19988,19720,19745,19683,19682,19676,19674,19677,19678,19675,19673,19669,19672,19670,19668,19667,19671,19640,19508,19481,19477,19473,19392,19334,19333,19327,19316,19315,19309,19307,19305,19306,19207,19034,19018,19017,18763,18465,18419,18254,18236,18107,18099,18069,18016,18017,17743,17819,17859,17539,17542,17534,17517,17473,17381,17378,17299,17191,17192,17171,17161,17160,17157,15602,15640,16939,17008,17065,17078,17088,17098,17099,16898,16892,16633,16632,16629,16630,16628,16626,16595,16465,16448,16440,16439,16426,16425,16408,16407,16405,16340,16342,16339,16292,16341,16262,16180,16174,16013,16012,15994,15912,15909,15903,15878,15873,15872,15868,15867,15849,15702,15669,15662,15664,15660,15654,15652,15647,15646,15643,15642,15644,15415,15396,15455,15394,15382,15383,15380,15378,15377,15385,15351,15350,15345,15348,15344,15329,15315,15294,15291,15289,15148,15095,14040,13883,13864,13863,13821,13818,13807,13652,13612,13608,13637,13512,13511,13509,13436,13490,13497,13498,13388,13394,13322,13348,12653,12652,10754,10396,10397,10398,10399,9678,9479,9574,9575,9258,8863,8865,8867,8881,8882,8885,8884,8888,8889,8802,8801,8792,10260,14282,14250,14249,14246,14220,12372,12366,12373,5543,5529,5505,5259,4263,4257,4233,3977,3978,3923,3614,3907,7,2,15,14778,14863,14858)
;
(this query time : 0.026 s)
(total SQL time : 0.085 s)
(total time : 0.112 s)
(num rows : 999 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.086 s)
(total time : 0.774 s)
(num rows : 1 )