[1]
SELECT @@SESSION.sql_mode
(this query time : 0.000 s)
(total SQL time : 0.000 s)
(total time : 0.002 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.003 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D8495675e0270552f9ebe9d4210a181d9d47'
;
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.004 s)
(num rows : 1 )
[4]
SELECT * FROM g_plugins
WHERE state='active'
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.004 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.000 s)
(total SQL time : 0.002 s)
(total time : 0.006 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.000 s)
(total SQL time : 0.002 s)
(total time : 0.006 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.003 s)
(total time : 0.007 s)
(num rows : 1 )
[8]
SELECT *
FROM g_user_infos
WHERE user_id = 2
;
(this query time : 0.000 s)
(total SQL time : 0.003 s)
(total time : 0.007 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (1962)
(this query time : 0.000 s)
(total SQL time : 0.003 s)
(total time : 0.011 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 (1962)
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.007 s)
(total SQL time : 0.010 s)
(total time : 0.018 s)
(num rows : 578 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 21482
;
(this query time : 0.000 s)
(total SQL time : 0.010 s)
(total time : 0.019 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 = 21482
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.011 s)
(total time : 0.019 s)
(num rows : 2 )
[12]
SELECT *
FROM g_images
WHERE id IN (21482,21487,33542,21481,14955)
;
(this query time : 0.000 s)
(total SQL time : 0.011 s)
(total time : 0.019 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 (21482)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.000 s)
(total SQL time : 0.012 s)
(total time : 0.023 s)
(num rows : 13 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,766,767,103,270,223)
(this query time : 0.000 s)
(total SQL time : 0.012 s)
(total time : 0.024 s)
(num rows : 6 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 21482 AND validated = 'true'
;
(this query time : 0.000 s)
(total SQL time : 0.012 s)
(total time : 0.026 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (33542,33543,33489,33488,33487,33374,33375,33376,33377,33378,33379,33380,33381,33382,33400,33195,33193,33207,33220,33229,33085,33091,33098,33008,32897,32932,32869,32712,32714,32668,32663,32600,32562,32561,32560,32445,32346,32210,32146,32158,32145,32143,32141,32139,32138,31916,31918,31922,31957,31969,31594,31539,31540,31541,31446,31447,31448,31449,31474,31476,31477,31526,31133,31374,31373,31077,31074,31075,30953,30751,30094,30093,30091,30070,30069,30246,30003,29921,29920,29918,29917,29916,29914,29913,29859,29861,29862,29863,29864,29865,29867,29869,29870,29873,29874,29872,29790,29766,29665,29667,29670,29672,29607,29481,29437,29439,29440,29441,29442,29443,29444,29452,29393,29394,29316,29320,29321,29347,29348,29120,29130,29131,29050,29053,29054,29055,29019,29020,29021,28974,28734,28710,28650,28648,28629,28626,28624,28625,28538,28537,28536,28535,28465,28464,28007,28009,28005,28006,28004,28003,27935,27681,27662,27461,27433,27382,27380,27291,27227,27226,27224,27199,26918,26919,26922,26924,26925,26930,26966,26968,26996,27025,27028,26906,26902,26900,26899,26717,26716,26635,26636,26639,26433,26390,26392,26398,26401,26200,26156,26143,26141,26060,26059,25988,25987,25984,25981,25901,25849,25848,25847,25842,25841,25839,25631,25634,25633,25636,25638,25655,25706,25707,25563,25497,25494,25489,25487,25475,25448,25444,25443,25441,25327,25328,25354,25355,25416,25417,25418,25420,25424,25425,25306,25065,25072,24932,24861,24723,24722,24720,24635,24632,24609,24608,24607,24606,24604,24603,24577,24358,24356,24340,24339,24337,24335,24197,24195,24193,24070,23894,23877,23810,23645,23597,23593,23592,23524,23521,23522,23487,23361,23360,23319,23310,22204,22088,21822,21657,21630,21629,21520,21487,21482,21481,21392,21391,21390,21386,21388,21332,21301,21130,21098,20923,20925,20922,20919,20918,20917,20920,20902,20897,20896,20884,20882,20740,20738,20736,20687,20683,20470,20459,20214,20196,20195,20193,20187,20099,20093,19758,19766,19763,19760,19757,19755,19656,19620,19619,19575,19577,19562,19435,19437,19434,19438,19436,19431,19375,19367,19366,19364,19362,19360,19313,19243,19245,19234,19062,19060,18503,18565,18563,18485,18484,18404,18327,18305,18273,18272,18271,18270,18269,18267,18155,18154,18097,18094,18000,18005,18004,18006,18007,18008,18009,18010,18023,18024,18026,18025,18031,17998,17721,17726,17772,17821,17841,17849,17698,17658,17660,17655,17585,17586,17583,17581,17594,17576,17462,17461,17459,17460,17452,17447,17444,17443,17441,17398,17369,17365,17313,17312,17309,17311,17304,17308,15637,17007,16909,16908,16907,16912,16900,16842,17147,17148,17144,17145,17139,17140,17143,17138,17141,17136,17142,17135,17137,16671,16666,16665,16662,16659,16656,16617,16611,16609,16610,16571,16566,16483,16482,16404,16361,16354,16352,16351,16350,16349,16347,16346,16348,16345,16344,16326,16328,16329,16331,16332,16336,16334,16325,16239,16230,16229,16231,16224,16225,16223,16221,16212,16201,16198,16197,16196,16199,16018,16183,16174,16173,16178,16015,16011,16009,16005,16003,16002,16001,16000,16006,15997,15993,15988,15905,15910,15833,15836,15778,15743,15751,15744,15715,15128,14504,14423,14407,14343,14203,14183,14187,14081,13939,13850,13799,13413,13423,13450,13468,13379,13185,13186,13248,13326,13330,13342,13175,13177,13179,13180,12830,12819,12668,12669,12670,12671,12672,12673,12675,12702,12708,12710,11855,10780,10588,9465,9286,9023,8745,8744,8636,8550,8552,8554,8553,8556,7994,7998,8000,18332,14262,9941,5517,5519,5521,5528,5527,5532,5534,5060,14955)
ORDER BY FIELD(id, 33542,33543,33489,33488,33487,33374,33375,33376,33377,33378,33379,33380,33381,33382,33400,33195,33193,33207,33220,33229,33085,33091,33098,33008,32897,32932,32869,32712,32714,32668,32663,32600,32562,32561,32560,32445,32346,32210,32146,32158,32145,32143,32141,32139,32138,31916,31918,31922,31957,31969,31594,31539,31540,31541,31446,31447,31448,31449,31474,31476,31477,31526,31133,31374,31373,31077,31074,31075,30953,30751,30094,30093,30091,30070,30069,30246,30003,29921,29920,29918,29917,29916,29914,29913,29859,29861,29862,29863,29864,29865,29867,29869,29870,29873,29874,29872,29790,29766,29665,29667,29670,29672,29607,29481,29437,29439,29440,29441,29442,29443,29444,29452,29393,29394,29316,29320,29321,29347,29348,29120,29130,29131,29050,29053,29054,29055,29019,29020,29021,28974,28734,28710,28650,28648,28629,28626,28624,28625,28538,28537,28536,28535,28465,28464,28007,28009,28005,28006,28004,28003,27935,27681,27662,27461,27433,27382,27380,27291,27227,27226,27224,27199,26918,26919,26922,26924,26925,26930,26966,26968,26996,27025,27028,26906,26902,26900,26899,26717,26716,26635,26636,26639,26433,26390,26392,26398,26401,26200,26156,26143,26141,26060,26059,25988,25987,25984,25981,25901,25849,25848,25847,25842,25841,25839,25631,25634,25633,25636,25638,25655,25706,25707,25563,25497,25494,25489,25487,25475,25448,25444,25443,25441,25327,25328,25354,25355,25416,25417,25418,25420,25424,25425,25306,25065,25072,24932,24861,24723,24722,24720,24635,24632,24609,24608,24607,24606,24604,24603,24577,24358,24356,24340,24339,24337,24335,24197,24195,24193,24070,23894,23877,23810,23645,23597,23593,23592,23524,23521,23522,23487,23361,23360,23319,23310,22204,22088,21822,21657,21630,21629,21520,21487,21482,21481,21392,21391,21390,21386,21388,21332,21301,21130,21098,20923,20925,20922,20919,20918,20917,20920,20902,20897,20896,20884,20882,20740,20738,20736,20687,20683,20470,20459,20214,20196,20195,20193,20187,20099,20093,19758,19766,19763,19760,19757,19755,19656,19620,19619,19575,19577,19562,19435,19437,19434,19438,19436,19431,19375,19367,19366,19364,19362,19360,19313,19243,19245,19234,19062,19060,18503,18565,18563,18485,18484,18404,18327,18305,18273,18272,18271,18270,18269,18267,18155,18154,18097,18094,18000,18005,18004,18006,18007,18008,18009,18010,18023,18024,18026,18025,18031,17998,17721,17726,17772,17821,17841,17849,17698,17658,17660,17655,17585,17586,17583,17581,17594,17576,17462,17461,17459,17460,17452,17447,17444,17443,17441,17398,17369,17365,17313,17312,17309,17311,17304,17308,15637,17007,16909,16908,16907,16912,16900,16842,17147,17148,17144,17145,17139,17140,17143,17138,17141,17136,17142,17135,17137,16671,16666,16665,16662,16659,16656,16617,16611,16609,16610,16571,16566,16483,16482,16404,16361,16354,16352,16351,16350,16349,16347,16346,16348,16345,16344,16326,16328,16329,16331,16332,16336,16334,16325,16239,16230,16229,16231,16224,16225,16223,16221,16212,16201,16198,16197,16196,16199,16018,16183,16174,16173,16178,16015,16011,16009,16005,16003,16002,16001,16000,16006,15997,15993,15988,15905,15910,15833,15836,15778,15743,15751,15744,15715,15128,14504,14423,14407,14343,14203,14183,14187,14081,13939,13850,13799,13413,13423,13450,13468,13379,13185,13186,13248,13326,13330,13342,13175,13177,13179,13180,12830,12819,12668,12669,12670,12671,12672,12673,12675,12702,12708,12710,11855,10780,10588,9465,9286,9023,8745,8744,8636,8550,8552,8554,8553,8556,7994,7998,8000,18332,14262,9941,5517,5519,5521,5528,5527,5532,5534,5060,14955)
;
(this query time : 0.008 s)
(total SQL time : 0.021 s)
(total time : 0.035 s)
(num rows : 578 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.021 s)
(total time : 0.263 s)
(num rows : 1 )