[1]
SELECT @@SESSION.sql_mode
(this query time : 0.001 s)
(total SQL time : 0.001 s)
(total time : 0.003 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.005 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D84996fc53db53875380133e463bbd254222'
;
(this query time : 0.001 s)
(total SQL time : 0.002 s)
(total time : 0.005 s)
(num rows : 1 )
[4]
SELECT * FROM g_plugins
WHERE state='active'
(this query time : 0.001 s)
(total SQL time : 0.003 s)
(total time : 0.006 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.001 s)
(total SQL time : 0.003 s)
(total time : 0.010 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.004 s)
(total time : 0.010 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.001 s)
(total SQL time : 0.005 s)
(total time : 0.011 s)
(num rows : 1 )
[8]
SELECT *
FROM g_user_infos
WHERE user_id = 2
;
(this query time : 0.001 s)
(total SQL time : 0.005 s)
(total time : 0.012 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (917)
(this query time : 0.001 s)
(total SQL time : 0.006 s)
(total time : 0.018 s)
(num rows : 1 )
[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 (917)
AND (category_id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212) AND level<=0)
GROUP BY id
ORDER BY date_creation DESC, file ASC, id ASC
(this query time : 0.010 s)
(total SQL time : 0.015 s)
(total time : 0.028 s)
(num rows : 444 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 26762
;
(this query time : 0.001 s)
(total SQL time : 0.016 s)
(total time : 0.029 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 = 26762
AND (id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212))
;
(this query time : 0.001 s)
(total SQL time : 0.016 s)
(total time : 0.029 s)
(num rows : 1 )
[12]
SELECT *
FROM g_images
WHERE id IN (26762,26763,33616,26761,3974)
;
(this query time : 0.001 s)
(total SQL time : 0.017 s)
(total time : 0.030 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 (26762)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.001 s)
(total SQL time : 0.018 s)
(total time : 0.037 s)
(num rows : 10 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,855,859)
(this query time : 0.001 s)
(total SQL time : 0.019 s)
(total time : 0.038 s)
(num rows : 3 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 26762 AND validated = 'true'
;
(this query time : 0.001 s)
(total SQL time : 0.019 s)
(total time : 0.042 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (33616,33636,33639,33522,33384,33320,33246,33247,33248,33249,33056,33068,32910,32911,32895,32784,32783,32781,32779,32774,32658,32252,32264,32265,32266,32130,32129,32127,32126,31870,31645,31644,31643,31640,31639,31638,31555,31234,31239,31112,31058,30514,30249,30250,30253,29812,29813,29814,29817,29818,29670,29540,29541,29542,29557,29559,29490,29491,29396,29399,29401,29222,29223,28566,28565,28562,28559,28558,28556,28555,28554,28552,28551,28550,28544,28543,28437,28403,28402,28399,28398,28396,28393,28392,28071,28070,27807,27649,27330,27267,27266,26826,26766,26765,26763,26762,26761,26752,26658,26659,26520,26418,26179,26010,25797,25621,25620,25619,25618,25370,25410,25411,25412,25103,25102,24959,24887,24885,24829,24828,24004,24006,24009,24008,24010,24769,24717,24715,24714,24704,24705,24599,24236,24233,24232,24056,24060,24062,23619,23553,23497,23496,23495,23378,23377,22073,22053,21923,21842,21840,21640,21639,21637,21635,21619,21612,21611,21608,21605,21609,21607,21597,21325,21327,21110,21108,21107,21106,20943,20934,20932,20871,20865,20864,20863,20860,20856,20851,20666,20653,20616,20612,20610,20426,20425,20424,20423,20421,20420,20418,20372,20214,20142,20143,19972,19561,19424,19418,19328,19323,19322,19320,19310,19308,19311,18977,18973,18887,18880,18879,18867,18866,18864,18460,18459,18123,17730,17732,17734,17735,17520,17519,17517,17512,17507,17515,17510,17504,17502,17496,17497,17495,17492,17491,17490,17354,17353,15527,15532,15533,15557,15561,15565,15566,15571,15603,15605,15612,15613,15615,15616,15617,15618,15614,15619,15620,15623,15625,15629,17043,17130,16680,16677,16676,16674,16494,16487,15888,15887,15204,15115,15113,14464,14465,14382,14368,14367,14176,14113,14024,14025,14026,14027,14028,13979,13978,13918,13868,13867,13865,13827,13826,13825,13801,13800,13716,13714,13560,13573,13603,13438,13480,13482,13483,13200,13261,13263,13264,13265,13266,13267,13269,13268,13303,13344,13343,13345,12946,12941,12890,11690,12038,12040,11974,11977,11944,11905,11906,11867,11775,11782,11454,11455,11456,11457,11458,11459,11416,11509,11510,11492,11388,11389,11391,11405,11407,11406,11408,11409,11410,11413,11385,10730,10732,10662,10664,9602,9504,9029,8901,8903,8233,7781,6443,6444,6445,6449,6450,6453,6455,6456,6458,6477,6462,6463,6465,6474,6475,6476,6504,6526,6346,6342,6341,6302,6299,6298,6297,6296,6294,6287,6283,6253,6250,6249,6248,6244,6240,6238,6237,6236,6235,6234,6233,6232,6230,6226,14280,6709,12296,12295,7226,7208,7209,7218,7217,7196,7197,11181,11183,11189,11191,11190,11192,11027,11066,11067,11069,11071,11074,5607,5604,5603,5601,5592,5866,4187,4183,4000,3996,3994,3992,3978,3974)
ORDER BY FIELD(id, 33616,33636,33639,33522,33384,33320,33246,33247,33248,33249,33056,33068,32910,32911,32895,32784,32783,32781,32779,32774,32658,32252,32264,32265,32266,32130,32129,32127,32126,31870,31645,31644,31643,31640,31639,31638,31555,31234,31239,31112,31058,30514,30249,30250,30253,29812,29813,29814,29817,29818,29670,29540,29541,29542,29557,29559,29490,29491,29396,29399,29401,29222,29223,28566,28565,28562,28559,28558,28556,28555,28554,28552,28551,28550,28544,28543,28437,28403,28402,28399,28398,28396,28393,28392,28071,28070,27807,27649,27330,27267,27266,26826,26766,26765,26763,26762,26761,26752,26658,26659,26520,26418,26179,26010,25797,25621,25620,25619,25618,25370,25410,25411,25412,25103,25102,24959,24887,24885,24829,24828,24004,24006,24009,24008,24010,24769,24717,24715,24714,24704,24705,24599,24236,24233,24232,24056,24060,24062,23619,23553,23497,23496,23495,23378,23377,22073,22053,21923,21842,21840,21640,21639,21637,21635,21619,21612,21611,21608,21605,21609,21607,21597,21325,21327,21110,21108,21107,21106,20943,20934,20932,20871,20865,20864,20863,20860,20856,20851,20666,20653,20616,20612,20610,20426,20425,20424,20423,20421,20420,20418,20372,20214,20142,20143,19972,19561,19424,19418,19328,19323,19322,19320,19310,19308,19311,18977,18973,18887,18880,18879,18867,18866,18864,18460,18459,18123,17730,17732,17734,17735,17520,17519,17517,17512,17507,17515,17510,17504,17502,17496,17497,17495,17492,17491,17490,17354,17353,15527,15532,15533,15557,15561,15565,15566,15571,15603,15605,15612,15613,15615,15616,15617,15618,15614,15619,15620,15623,15625,15629,17043,17130,16680,16677,16676,16674,16494,16487,15888,15887,15204,15115,15113,14464,14465,14382,14368,14367,14176,14113,14024,14025,14026,14027,14028,13979,13978,13918,13868,13867,13865,13827,13826,13825,13801,13800,13716,13714,13560,13573,13603,13438,13480,13482,13483,13200,13261,13263,13264,13265,13266,13267,13269,13268,13303,13344,13343,13345,12946,12941,12890,11690,12038,12040,11974,11977,11944,11905,11906,11867,11775,11782,11454,11455,11456,11457,11458,11459,11416,11509,11510,11492,11388,11389,11391,11405,11407,11406,11408,11409,11410,11413,11385,10730,10732,10662,10664,9602,9504,9029,8901,8903,8233,7781,6443,6444,6445,6449,6450,6453,6455,6456,6458,6477,6462,6463,6465,6474,6475,6476,6504,6526,6346,6342,6341,6302,6299,6298,6297,6296,6294,6287,6283,6253,6250,6249,6248,6244,6240,6238,6237,6236,6235,6234,6233,6232,6230,6226,14280,6709,12296,12295,7226,7208,7209,7218,7217,7196,7197,11181,11183,11189,11191,11190,11192,11027,11066,11067,11069,11071,11074,5607,5604,5603,5601,5592,5866,4187,4183,4000,3996,3994,3992,3978,3974)
;
(this query time : 0.012 s)
(total SQL time : 0.032 s)
(total time : 0.057 s)
(num rows : 444 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.032 s)
(total time : 0.264 s)
(num rows : 1 )