[1]
SELECT @@SESSION.sql_mode
(this query time : 0.001 s)
(total SQL time : 0.001 s)
(total time : 0.006 s)
(num rows : 1 )
[2]
SELECT param, value
FROM g_config
;
(this query time : 0.002 s)
(total SQL time : 0.003 s)
(total time : 0.009 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D84996fc53db53875380133e463bbd254222'
;
(this query time : 0.001 s)
(total SQL time : 0.004 s)
(total time : 0.011 s)
(num rows : 1 )
[4]
SELECT * FROM g_plugins
WHERE state='active'
(this query time : 0.001 s)
(total SQL time : 0.006 s)
(total time : 0.013 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.007 s)
(total time : 0.020 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.002 s)
(total SQL time : 0.009 s)
(total time : 0.022 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.002 s)
(total SQL time : 0.011 s)
(total time : 0.024 s)
(num rows : 1 )
[8]
SELECT *
FROM g_user_infos
WHERE user_id = 2
;
(this query time : 0.002 s)
(total SQL time : 0.013 s)
(total time : 0.027 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (2633)
(this query time : 0.002 s)
(total SQL time : 0.014 s)
(total time : 0.042 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 (2633)
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.014 s)
(total SQL time : 0.027 s)
(total time : 0.056 s)
(num rows : 245 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 31740
;
(this query time : 0.002 s)
(total SQL time : 0.028 s)
(total time : 0.058 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 = 31740
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.030 s)
(total time : 0.060 s)
(num rows : 1 )
[12]
SELECT *
FROM g_images
WHERE id IN (31740,31749,33583,31741,5568)
;
(this query time : 0.002 s)
(total SQL time : 0.032 s)
(total time : 0.062 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 (31740)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.003 s)
(total SQL time : 0.035 s)
(total time : 0.082 s)
(num rows : 25 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,871,876)
(this query time : 0.002 s)
(total SQL time : 0.037 s)
(total time : 0.084 s)
(num rows : 3 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 31740 AND validated = 'true'
;
(this query time : 0.001 s)
(total SQL time : 0.038 s)
(total time : 0.092 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (33583,33584,33508,33531,33532,33533,33534,33535,33538,33282,33283,33310,33311,33312,33122,33223,33026,33021,33020,33019,33018,33000,32974,32937,32857,32845,32846,32844,32802,32713,32708,32682,32635,32599,32568,32532,32531,32520,32508,32035,32469,32391,32059,32136,32135,31815,31749,31740,31741,31688,31692,31632,31624,31572,31460,31471,31521,31258,31244,31362,31020,31019,30766,30636,30417,30432,30158,30164,30205,29898,29848,29850,29811,29649,29560,29422,29389,29360,29122,29021,28978,28867,28708,28652,28606,28588,28908,28372,28352,28257,28225,28090,27969,27713,27648,27233,27059,26781,26545,26208,26237,26239,26238,26172,25799,25445,24959,23982,24771,24617,24498,24473,24464,24319,24318,24316,24288,24279,24266,24115,23301,23297,22210,22203,22123,22048,21725,21703,21659,21271,21031,21030,21014,20763,20638,20644,20627,20589,20472,19272,19152,18760,15552,15553,15587,15626,15630,17059,16847,16576,16503,15969,15811,14554,14553,14550,14541,14542,14539,14540,14143,13696,13693,13484,13496,13363,13218,13142,13050,13020,12964,12742,12744,12088,11921,11812,11736,11493,11494,10801,10804,10672,10168,10569,10445,10447,10448,10449,10450,10457,10412,9676,9654,9591,9268,8546,8549,10375,8531,8532,8533,8534,8535,8536,8537,8538,8539,8540,8401,10189,8182,8101,8057,7941,7917,7035,7087,7144,6384,14243,6104,6106,12232,9839,9960,9965,7810,9988,7788,11170,11171,11173,11174,11176,11177,11180,5806,5805,5804,5803,5802,5801,5808,10593,5568)
ORDER BY FIELD(id, 33583,33584,33508,33531,33532,33533,33534,33535,33538,33282,33283,33310,33311,33312,33122,33223,33026,33021,33020,33019,33018,33000,32974,32937,32857,32845,32846,32844,32802,32713,32708,32682,32635,32599,32568,32532,32531,32520,32508,32035,32469,32391,32059,32136,32135,31815,31749,31740,31741,31688,31692,31632,31624,31572,31460,31471,31521,31258,31244,31362,31020,31019,30766,30636,30417,30432,30158,30164,30205,29898,29848,29850,29811,29649,29560,29422,29389,29360,29122,29021,28978,28867,28708,28652,28606,28588,28908,28372,28352,28257,28225,28090,27969,27713,27648,27233,27059,26781,26545,26208,26237,26239,26238,26172,25799,25445,24959,23982,24771,24617,24498,24473,24464,24319,24318,24316,24288,24279,24266,24115,23301,23297,22210,22203,22123,22048,21725,21703,21659,21271,21031,21030,21014,20763,20638,20644,20627,20589,20472,19272,19152,18760,15552,15553,15587,15626,15630,17059,16847,16576,16503,15969,15811,14554,14553,14550,14541,14542,14539,14540,14143,13696,13693,13484,13496,13363,13218,13142,13050,13020,12964,12742,12744,12088,11921,11812,11736,11493,11494,10801,10804,10672,10168,10569,10445,10447,10448,10449,10450,10457,10412,9676,9654,9591,9268,8546,8549,10375,8531,8532,8533,8534,8535,8536,8537,8538,8539,8540,8401,10189,8182,8101,8057,7941,7917,7035,7087,7144,6384,14243,6104,6106,12232,9839,9960,9965,7810,9988,7788,11170,11171,11173,11174,11176,11177,11180,5806,5805,5804,5803,5802,5801,5808,10593,5568)
;
(this query time : 0.016 s)
(total SQL time : 0.054 s)
(total time : 0.113 s)
(num rows : 245 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.055 s)
(total time : 0.259 s)
(num rows : 1 )