[1]
SELECT @@SESSION.sql_mode
(this query time : 0.001 s)
(total SQL time : 0.001 s)
(total time : 0.007 s)
(num rows : 1 )
[2]
SELECT param, value
FROM g_config
;
(this query time : 0.002 s)
(total SQL time : 0.004 s)
(total time : 0.011 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D84994c5865d4976d8574ea7a73ebc1a7e53'
;
(this query time : 0.001 s)
(total SQL time : 0.005 s)
(total time : 0.013 s)
(num rows : 1 )
[4]
DELETE
FROM g_sessions
WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(expiration) > 3600
;
(this query time : 0.057 s)
(total SQL time : 0.062 s)
(total time : 0.070 s)
(affected rows : 190 )
[5]
SELECT * FROM g_plugins
WHERE state='active'
(this query time : 0.001 s)
(total SQL time : 0.063 s)
(total time : 0.071 s)
(num rows : 9 )
[6]
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.064 s)
(total time : 0.077 s)
(num rows : 0 )
[7]
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.065 s)
(total time : 0.078 s)
(num rows : 1 )
[8]
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.067 s)
(total time : 0.079 s)
(num rows : 1 )
[9]
SELECT *
FROM g_user_infos
WHERE user_id = 2
;
(this query time : 0.001 s)
(total SQL time : 0.068 s)
(total time : 0.081 s)
(num rows : 1 )
[10]
SELECT *
FROM g_tags
WHERE id IN (1496)
(this query time : 0.001 s)
(total SQL time : 0.069 s)
(total time : 0.090 s)
(num rows : 1 )
[10]
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 (1496)
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 hit DESC,date_creation DESC, file ASC, id ASC
(this query time : 0.017 s)
(total SQL time : 0.085 s)
(total time : 0.107 s)
(num rows : 483 )
[11]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 16963
;
(this query time : 0.001 s)
(total SQL time : 0.086 s)
(total time : 0.108 s)
(affected rows : 1 )
[12]
SELECT id,uppercats,commentable,visible,status,global_rank
FROM g_image_category
INNER JOIN g_categories ON category_id = id
WHERE image_id = 16963
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.087 s)
(total time : 0.109 s)
(num rows : 4 )
[13]
SELECT *
FROM g_images
WHERE id IN (16963,17406,7142,25816,32827)
;
(this query time : 0.001 s)
(total SQL time : 0.088 s)
(total time : 0.111 s)
(num rows : 5 )
[14]
SELECT t.*, count(*) AS counter
FROM g_image_tag
INNER JOIN g_tags t ON tag_id = id
WHERE image_id IN (16963)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.002 s)
(total SQL time : 0.091 s)
(total time : 0.124 s)
(num rows : 10 )
[15]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,646,655,152,169,568,262,159,100,101,256,257)
(this query time : 0.002 s)
(total SQL time : 0.093 s)
(total time : 0.126 s)
(num rows : 12 )
[16]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 16963 AND validated = 'true'
;
(this query time : 0.002 s)
(total SQL time : 0.094 s)
(total time : 0.136 s)
(num rows : 1 )
[17]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (7142,7137,7141,9541,7139,7140,7138,14536,7468,4782,4765,11892,10943,10994,8007,12915,12854,4783,12657,4786,11576,10995,12658,11894,12686,11891,11680,10685,11895,4784,11893,4785,18157,15229,4787,10597,12776,17671,4544,17489,15412,12795,4994,4752,4807,11011,17493,8730,7172,11575,4819,4810,15231,5366,5765,4969,4820,8991,9253,12777,15899,12778,5163,5343,12323,4825,4972,9254,5807,5571,12532,5056,6612,12322,6018,8254,9967,12738,5564,8286,4788,4818,4968,4806,12321,7321,4821,8567,11574,12331,6116,5544,4789,12797,5917,7018,11660,7274,8813,4816,12835,7986,12332,11889,8285,8890,10695,10945,4815,4822,5918,5546,18234,11873,7345,9463,11012,4973,5925,4823,7343,12792,5720,13320,12330,12790,11331,23406,4824,5035,4817,12521,10466,10748,20915,5719,11771,11677,10747,13251,7787,14248,5921,4813,7346,14097,11874,19564,12328,11450,12329,11671,12098,12798,7318,7021,4801,7708,18232,4811,13319,13609,6946,4792,7044,4814,16206,12327,5919,4797,4812,5920,7301,12326,10746,8773,4802,4793,13893,12954,23666,12097,15151,12522,11837,4805,12096,12324,4795,5545,11587,4827,8136,4803,4796,9410,13712,10942,4798,6618,4804,7267,18218,15812,8886,4800,13645,14296,13755,14563,6875,15411,4794,18102,7340,4763,12525,21440,14564,15054,18274,13680,6945,9913,23398,29590,4808,18281,23665,18280,17357,18279,21709,26070,15809,7423,4809,29462,18282,8775,17861,15228,16621,15445,15872,10463,6844,17005,18277,12267,4799,5368,15079,25739,15203,25819,16098,14164,18283,17003,4791,9988,17564,12796,18276,17406,16963,25816,7421,17757,17384,11679,21385,7419,10868,7014,29834,20828,14287,25818,21071,20163,20812,18036,25815,10867,19635,21050,20157,30457,23278,16066,28752,30778,18388,16037,20162,15904,16477,29835,16062,16071,16073,16853,30011,29528,16072,20593,20454,29460,17692,15160,20908,18752,18035,28594,19190,23283,28957,21118,25817,16065,17290,21991,15874,29632,29591,16594,30190,19727,30150,30773,20159,29857,26003,28716,29527,20448,16962,18489,30595,30495,21342,20496,25966,20497,21809,28717,21505,19531,21712,30890,31375,20830,18662,23413,31097,19603,29304,25760,21573,20138,20032,25814,20117,21307,31426,24912,29422,18601,29824,20784,28715,23821,21990,18429,29455,28520,25813,26748,22006,27711,30008,20598,29461,23570,21259,24243,29458,26002,20649,24150,22125,23571,19242,20643,26747,25586,25811,25372,29456,25345,28412,30978,21985,29305,28714,29457,24244,25962,32401,29991,26785,25918,28751,29017,28592,27372,24700,31470,30508,24294,18753,32337,27371,25893,27308,32400,30257,26476,28654,28413,26163,27373,21702,29512,25173,27710,28163,27370,27768,26707,28490,28209,27209,32196,26954,27700,26706,26820,27367,28262,27368,32507,26591,28045,32518,33597,33472,32510,33406,32683,33299,33108,33300,32741,32841,33407,33302,33101,33316,33314,33303,33304,33508,33301,33100,33099,33074,33103,33102,33683,32827)
ORDER BY FIELD(id, 7142,7137,7141,9541,7139,7140,7138,14536,7468,4782,4765,11892,10943,10994,8007,12915,12854,4783,12657,4786,11576,10995,12658,11894,12686,11891,11680,10685,11895,4784,11893,4785,18157,15229,4787,10597,12776,17671,4544,17489,15412,12795,4994,4752,4807,11011,17493,8730,7172,11575,4819,4810,15231,5366,5765,4969,4820,8991,9253,12777,15899,12778,5163,5343,12323,4825,4972,9254,5807,5571,12532,5056,6612,12322,6018,8254,9967,12738,5564,8286,4788,4818,4968,4806,12321,7321,4821,8567,11574,12331,6116,5544,4789,12797,5917,7018,11660,7274,8813,4816,12835,7986,12332,11889,8285,8890,10695,10945,4815,4822,5918,5546,18234,11873,7345,9463,11012,4973,5925,4823,7343,12792,5720,13320,12330,12790,11331,23406,4824,5035,4817,12521,10466,10748,20915,5719,11771,11677,10747,13251,7787,14248,5921,4813,7346,14097,11874,19564,12328,11450,12329,11671,12098,12798,7318,7021,4801,7708,18232,4811,13319,13609,6946,4792,7044,4814,16206,12327,5919,4797,4812,5920,7301,12326,10746,8773,4802,4793,13893,12954,23666,12097,15151,12522,11837,4805,12096,12324,4795,5545,11587,4827,8136,4803,4796,9410,13712,10942,4798,6618,4804,7267,18218,15812,8886,4800,13645,14296,13755,14563,6875,15411,4794,18102,7340,4763,12525,21440,14564,15054,18274,13680,6945,9913,23398,29590,4808,18281,23665,18280,17357,18279,21709,26070,15809,7423,4809,29462,18282,8775,17861,15228,16621,15445,15872,10463,6844,17005,18277,12267,4799,5368,15079,25739,15203,25819,16098,14164,18283,17003,4791,9988,17564,12796,18276,17406,16963,25816,7421,17757,17384,11679,21385,7419,10868,7014,29834,20828,14287,25818,21071,20163,20812,18036,25815,10867,19635,21050,20157,30457,23278,16066,28752,30778,18388,16037,20162,15904,16477,29835,16062,16071,16073,16853,30011,29528,16072,20593,20454,29460,17692,15160,20908,18752,18035,28594,19190,23283,28957,21118,25817,16065,17290,21991,15874,29632,29591,16594,30190,19727,30150,30773,20159,29857,26003,28716,29527,20448,16962,18489,30595,30495,21342,20496,25966,20497,21809,28717,21505,19531,21712,30890,31375,20830,18662,23413,31097,19603,29304,25760,21573,20138,20032,25814,20117,21307,31426,24912,29422,18601,29824,20784,28715,23821,21990,18429,29455,28520,25813,26748,22006,27711,30008,20598,29461,23570,21259,24243,29458,26002,20649,24150,22125,23571,19242,20643,26747,25586,25811,25372,29456,25345,28412,30978,21985,29305,28714,29457,24244,25962,32401,29991,26785,25918,28751,29017,28592,27372,24700,31470,30508,24294,18753,32337,27371,25893,27308,32400,30257,26476,28654,28413,26163,27373,21702,29512,25173,27710,28163,27370,27768,26707,28490,28209,27209,32196,26954,27700,26706,26820,27367,28262,27368,32507,26591,28045,32518,33597,33472,32510,33406,32683,33299,33108,33300,32741,32841,33407,33302,33101,33316,33314,33303,33304,33508,33301,33100,33099,33074,33103,33102,33683,32827)
;
(this query time : 0.030 s)
(total SQL time : 0.124 s)
(total time : 0.172 s)
(num rows : 483 )
[18]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.125 s)
(total time : 0.427 s)
(num rows : 1 )