[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.002 s)
(total time : 0.005 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D8495675e0270552f9ebe9d4210a181d9d47'
;
(this query time : 0.001 s)
(total SQL time : 0.002 s)
(total time : 0.006 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.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.001 s)
(total SQL time : 0.004 s)
(total time : 0.011 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.011 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.012 s)
(num rows : 1 )
[8]
SELECT *
FROM g_user_infos
WHERE user_id = 2
;
(this query time : 0.001 s)
(total SQL time : 0.006 s)
(total time : 0.013 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (1505)
(this query time : 0.001 s)
(total SQL time : 0.007 s)
(total time : 0.020 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 (1505)
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.015 s)
(total SQL time : 0.021 s)
(total time : 0.035 s)
(num rows : 330 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 27462
;
(this query time : 0.002 s)
(total SQL time : 0.023 s)
(total time : 0.038 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 = 27462
AND (id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212))
;
(this query time : 0.002 s)
(total SQL time : 0.025 s)
(total time : 0.040 s)
(num rows : 3 )
[12]
SELECT *
FROM g_images
WHERE id IN (27462,27923,33663,27461,4550)
;
(this query time : 0.002 s)
(total SQL time : 0.027 s)
(total time : 0.042 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 (27462)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.003 s)
(total SQL time : 0.030 s)
(total time : 0.061 s)
(num rows : 11 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,855,860,152,262,175,103,270,276)
(this query time : 0.002 s)
(total SQL time : 0.032 s)
(total time : 0.064 s)
(num rows : 9 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 27462 AND validated = 'true'
;
(this query time : 0.001 s)
(total SQL time : 0.033 s)
(total time : 0.072 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (33663,33664,33674,33504,33487,33444,33445,33446,33447,33448,33147,33185,33186,33063,33065,33069,33044,32973,32970,32968,32897,32558,32557,32556,32555,32554,32553,32532,32531,32534,32443,32442,32441,32440,32439,32438,32139,32138,32136,32135,32082,31612,31611,31594,31473,31110,31109,31377,31022,31020,31019,30752,30585,30578,30577,30576,30575,30430,30431,30432,30073,30072,29922,29879,29615,29617,29616,29618,29437,29439,29442,29443,29444,29036,28734,28710,27922,27923,27462,27461,27395,27389,27387,27386,27385,27384,27383,27382,27381,27379,27378,27307,27206,27202,27201,27200,27199,27022,27023,26817,26431,26400,26401,26265,26266,26267,26269,26281,26040,26039,25999,25997,25996,26012,25995,25993,25992,25958,25957,25953,25952,25951,25950,25949,25948,25947,25946,25945,25848,25847,25655,25712,25713,25714,25715,25716,25459,25263,25262,25261,24932,24931,24882,24881,24880,24729,24345,24344,24343,24342,24341,24132,24133,24033,23590,22093,22094,21823,21822,21745,21487,21396,21397,21394,21393,21386,21388,21320,21319,21098,20887,20822,20821,20820,20743,20538,20206,20204,20188,19728,19739,19579,19499,19425,19422,19237,19238,19060,19046,18761,18760,18759,18503,18705,18704,18701,18302,18105,17663,17499,17302,17251,17250,17252,17248,17249,17016,17011,17018,17020,16847,16841,16660,16538,16537,16536,16535,16542,16145,16144,16142,16143,16140,16139,16131,16130,16128,16127,16126,16125,16121,16129,16119,15988,15511,15510,15509,15508,15506,14457,14456,14021,14081,13956,13957,13954,13941,13450,13324,12870,12869,12871,12873,12872,12928,12822,12818,12820,12821,12819,12708,12710,12711,12592,11854,11558,11557,11559,11560,11561,11563,11562,11564,11565,11566,11567,11569,10780,10588,9306,9305,9308,9307,9310,8550,8552,8551,8050,7994,7995,7912,7098,7055,7054,6994,6997,6996,6998,6999,7000,7001,7003,6935,9894,7261,10958,10959,5424,5429,5428,5427,5426,5425,5524,5525,5291,5083,5084,5081,5082,5062,5880,5879,5878,5877,5718,5717,5716,5715,4550)
ORDER BY FIELD(id, 33663,33664,33674,33504,33487,33444,33445,33446,33447,33448,33147,33185,33186,33063,33065,33069,33044,32973,32970,32968,32897,32558,32557,32556,32555,32554,32553,32532,32531,32534,32443,32442,32441,32440,32439,32438,32139,32138,32136,32135,32082,31612,31611,31594,31473,31110,31109,31377,31022,31020,31019,30752,30585,30578,30577,30576,30575,30430,30431,30432,30073,30072,29922,29879,29615,29617,29616,29618,29437,29439,29442,29443,29444,29036,28734,28710,27922,27923,27462,27461,27395,27389,27387,27386,27385,27384,27383,27382,27381,27379,27378,27307,27206,27202,27201,27200,27199,27022,27023,26817,26431,26400,26401,26265,26266,26267,26269,26281,26040,26039,25999,25997,25996,26012,25995,25993,25992,25958,25957,25953,25952,25951,25950,25949,25948,25947,25946,25945,25848,25847,25655,25712,25713,25714,25715,25716,25459,25263,25262,25261,24932,24931,24882,24881,24880,24729,24345,24344,24343,24342,24341,24132,24133,24033,23590,22093,22094,21823,21822,21745,21487,21396,21397,21394,21393,21386,21388,21320,21319,21098,20887,20822,20821,20820,20743,20538,20206,20204,20188,19728,19739,19579,19499,19425,19422,19237,19238,19060,19046,18761,18760,18759,18503,18705,18704,18701,18302,18105,17663,17499,17302,17251,17250,17252,17248,17249,17016,17011,17018,17020,16847,16841,16660,16538,16537,16536,16535,16542,16145,16144,16142,16143,16140,16139,16131,16130,16128,16127,16126,16125,16121,16129,16119,15988,15511,15510,15509,15508,15506,14457,14456,14021,14081,13956,13957,13954,13941,13450,13324,12870,12869,12871,12873,12872,12928,12822,12818,12820,12821,12819,12708,12710,12711,12592,11854,11558,11557,11559,11560,11561,11563,11562,11564,11565,11566,11567,11569,10780,10588,9306,9305,9308,9307,9310,8550,8552,8551,8050,7994,7995,7912,7098,7055,7054,6994,6997,6996,6998,6999,7000,7001,7003,6935,9894,7261,10958,10959,5424,5429,5428,5427,5426,5425,5524,5525,5291,5083,5084,5081,5082,5062,5880,5879,5878,5877,5718,5717,5716,5715,4550)
;
(this query time : 0.020 s)
(total SQL time : 0.053 s)
(total time : 0.097 s)
(num rows : 330 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.000 s)
(total SQL time : 0.053 s)
(total time : 0.283 s)
(num rows : 1 )