[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.003 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]
SELECT * FROM g_plugins
WHERE state='active'
(this query time : 0.001 s)
(total SQL time : 0.007 s)
(total time : 0.015 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.002 s)
(total SQL time : 0.008 s)
(total time : 0.024 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.009 s)
(total time : 0.025 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.012 s)
(total time : 0.027 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.030 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (20074)
(this query time : 0.001 s)
(total SQL time : 0.015 s)
(total time : 0.046 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 (20074)
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.032 s)
(total SQL time : 0.046 s)
(total time : 0.078 s)
(num rows : 638 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 30001
;
(this query time : 0.002 s)
(total SQL time : 0.048 s)
(total time : 0.081 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 = 30001
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.050 s)
(total time : 0.083 s)
(num rows : 1 )
[12]
SELECT *
FROM g_images
WHERE id IN (30001,29146,28625,28608,32818)
;
(this query time : 0.002 s)
(total SQL time : 0.052 s)
(total time : 0.086 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 (30001)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.003 s)
(total SQL time : 0.056 s)
(total time : 0.106 s)
(num rows : 37 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,855,870)
(this query time : 0.004 s)
(total SQL time : 0.060 s)
(total time : 0.112 s)
(num rows : 3 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 30001 AND validated = 'true'
;
(this query time : 0.002 s)
(total SQL time : 0.062 s)
(total time : 0.122 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (28625,29914,30783,29099,28769,28711,29312,28886,29765,28752,31386,29718,30083,28768,30960,30092,31601,29617,29591,29310,31632,31640,29998,31476,28645,28678,29901,30790,30156,28716,28736,30920,29948,28735,31565,31562,30253,29667,28712,30967,31462,29832,28717,28770,30988,30113,31613,29939,31560,29436,31676,28713,29397,29917,29767,31220,29304,31121,30005,31675,28772,28880,30020,29995,29656,30017,31293,29654,30089,31473,30163,28733,30970,30969,30140,28715,29992,29687,29699,28684,31646,29343,29097,31477,29944,31404,31704,30948,28669,30878,31431,29956,28692,29963,29653,30025,30057,29613,31512,29555,30949,31461,30067,29655,29319,31643,29553,29426,30087,31260,30019,29347,31460,31566,31249,29508,29731,28787,31079,29953,30965,28762,28868,30097,29250,29551,28873,30056,29488,28698,31848,28725,28899,29217,30489,31544,29925,28742,31486,31438,29652,29922,31050,30086,30039,29714,30179,30165,29559,30036,28487,28721,31230,28771,29906,30449,28892,30038,29552,28952,31564,31554,31701,30779,29756,28883,31850,28753,31156,31067,31470,31455,31223,31131,30186,29771,29626,31403,28784,29550,29750,29769,29440,29611,30061,29689,30453,30454,31533,30085,30412,28754,31626,30619,28777,31234,30955,28797,30863,31685,29999,31658,28455,28785,31591,28738,31647,29730,30496,28788,31555,30192,29375,28919,32152,28902,30491,29585,30450,32154,31225,30028,29625,28798,28790,30040,31656,28723,30498,31642,31418,30021,30032,30138,28884,30429,30041,29330,28773,29843,28747,29479,30827,30930,31654,29146,30001,28608,30511,32344,29862,29772,30198,29569,29535,29511,29492,31163,28867,31006,30010,31732,30178,30444,30188,30060,31274,29761,31060,30422,29660,29773,31682,29506,29200,29386,28456,32156,30030,30109,29674,31603,30006,30195,29751,31281,29723,28731,30074,29578,31726,29820,31299,29783,30986,28878,29391,29509,28683,28682,30931,29549,30029,29418,29558,28741,30105,29125,29452,31300,30153,30194,29947,28689,28694,29957,30106,29818,29483,29430,31280,29912,30509,31605,28900,28875,31652,29331,30448,29887,31618,30197,28666,29004,29502,30917,31353,29748,31813,29459,29870,30141,30748,29758,28890,28869,29166,29668,30018,29690,30157,32151,31818,29877,28767,29542,31792,29571,29473,29825,29647,29908,29581,31421,30201,31436,28431,29580,29145,28774,29819,30503,31360,29574,29700,28745,32507,29777,29663,29538,31536,28664,29704,30023,29873,29676,31278,30991,30611,29137,31909,29006,29896,30177,29468,29154,31384,29556,29930,30015,28686,29602,31764,29252,31482,29300,29183,32143,29946,29838,29941,30436,28778,31240,29895,32423,32412,31580,29705,31757,29381,32105,29063,29959,31699,30596,29185,28744,28453,31832,29911,31868,29899,28783,29298,29090,30687,31840,29804,29593,29854,29867,29874,28443,32863,29150,29018,29821,29297,32251,31803,32276,31779,31061,29042,28901,28746,30114,31070,30210,31778,29190,28990,29517,32113,29139,32439,32409,29797,29067,29227,29681,29812,28411,28748,32430,32199,29577,29752,29794,28657,29524,31734,28760,28779,31720,29907,29029,29816,29639,31759,31811,31742,32520,29636,29709,32298,31933,28983,28756,29081,29623,31752,29174,29066,29491,29856,28992,29719,32157,29251,29069,29839,28776,31298,32103,32109,29754,29118,31871,29076,31713,28690,29515,29755,28786,29008,28951,29836,32869,32111,29589,29703,29466,32200,32184,32369,29504,32496,29855,32514,32114,29254,30110,29323,31772,29629,31745,28955,29596,28953,31754,32375,31718,32207,29595,32246,32429,32379,32197,27882,32494,31814,32229,32852,32508,32228,32240,32104,32445,29518,32434,32247,32289,30471,32176,29891,33398,31849,32100,32148,32304,32335,32823,29516,32502,32262,27754,29514,32291,29144,32101,29831,32236,32850,28831,29695,32192,32159,32947,32357,32501,33677,33393,33337,32503,32175,33454,32190,33433,32221,32385,33344,32955,33482,33343,32920,32506,33341,33396,33457,33234,33387,33380,32505,33340,33386,33072,33432,33339,32537,32819,32876,33428,33397,33420,33410,32818)
ORDER BY FIELD(id, 28625,29914,30783,29099,28769,28711,29312,28886,29765,28752,31386,29718,30083,28768,30960,30092,31601,29617,29591,29310,31632,31640,29998,31476,28645,28678,29901,30790,30156,28716,28736,30920,29948,28735,31565,31562,30253,29667,28712,30967,31462,29832,28717,28770,30988,30113,31613,29939,31560,29436,31676,28713,29397,29917,29767,31220,29304,31121,30005,31675,28772,28880,30020,29995,29656,30017,31293,29654,30089,31473,30163,28733,30970,30969,30140,28715,29992,29687,29699,28684,31646,29343,29097,31477,29944,31404,31704,30948,28669,30878,31431,29956,28692,29963,29653,30025,30057,29613,31512,29555,30949,31461,30067,29655,29319,31643,29553,29426,30087,31260,30019,29347,31460,31566,31249,29508,29731,28787,31079,29953,30965,28762,28868,30097,29250,29551,28873,30056,29488,28698,31848,28725,28899,29217,30489,31544,29925,28742,31486,31438,29652,29922,31050,30086,30039,29714,30179,30165,29559,30036,28487,28721,31230,28771,29906,30449,28892,30038,29552,28952,31564,31554,31701,30779,29756,28883,31850,28753,31156,31067,31470,31455,31223,31131,30186,29771,29626,31403,28784,29550,29750,29769,29440,29611,30061,29689,30453,30454,31533,30085,30412,28754,31626,30619,28777,31234,30955,28797,30863,31685,29999,31658,28455,28785,31591,28738,31647,29730,30496,28788,31555,30192,29375,28919,32152,28902,30491,29585,30450,32154,31225,30028,29625,28798,28790,30040,31656,28723,30498,31642,31418,30021,30032,30138,28884,30429,30041,29330,28773,29843,28747,29479,30827,30930,31654,29146,30001,28608,30511,32344,29862,29772,30198,29569,29535,29511,29492,31163,28867,31006,30010,31732,30178,30444,30188,30060,31274,29761,31060,30422,29660,29773,31682,29506,29200,29386,28456,32156,30030,30109,29674,31603,30006,30195,29751,31281,29723,28731,30074,29578,31726,29820,31299,29783,30986,28878,29391,29509,28683,28682,30931,29549,30029,29418,29558,28741,30105,29125,29452,31300,30153,30194,29947,28689,28694,29957,30106,29818,29483,29430,31280,29912,30509,31605,28900,28875,31652,29331,30448,29887,31618,30197,28666,29004,29502,30917,31353,29748,31813,29459,29870,30141,30748,29758,28890,28869,29166,29668,30018,29690,30157,32151,31818,29877,28767,29542,31792,29571,29473,29825,29647,29908,29581,31421,30201,31436,28431,29580,29145,28774,29819,30503,31360,29574,29700,28745,32507,29777,29663,29538,31536,28664,29704,30023,29873,29676,31278,30991,30611,29137,31909,29006,29896,30177,29468,29154,31384,29556,29930,30015,28686,29602,31764,29252,31482,29300,29183,32143,29946,29838,29941,30436,28778,31240,29895,32423,32412,31580,29705,31757,29381,32105,29063,29959,31699,30596,29185,28744,28453,31832,29911,31868,29899,28783,29298,29090,30687,31840,29804,29593,29854,29867,29874,28443,32863,29150,29018,29821,29297,32251,31803,32276,31779,31061,29042,28901,28746,30114,31070,30210,31778,29190,28990,29517,32113,29139,32439,32409,29797,29067,29227,29681,29812,28411,28748,32430,32199,29577,29752,29794,28657,29524,31734,28760,28779,31720,29907,29029,29816,29639,31759,31811,31742,32520,29636,29709,32298,31933,28983,28756,29081,29623,31752,29174,29066,29491,29856,28992,29719,32157,29251,29069,29839,28776,31298,32103,32109,29754,29118,31871,29076,31713,28690,29515,29755,28786,29008,28951,29836,32869,32111,29589,29703,29466,32200,32184,32369,29504,32496,29855,32514,32114,29254,30110,29323,31772,29629,31745,28955,29596,28953,31754,32375,31718,32207,29595,32246,32429,32379,32197,27882,32494,31814,32229,32852,32508,32228,32240,32104,32445,29518,32434,32247,32289,30471,32176,29891,33398,31849,32100,32148,32304,32335,32823,29516,32502,32262,27754,29514,32291,29144,32101,29831,32236,32850,28831,29695,32192,32159,32947,32357,32501,33677,33393,33337,32503,32175,33454,32190,33433,32221,32385,33344,32955,33482,33343,32920,32506,33341,33396,33457,33234,33387,33380,32505,33340,33386,33072,33432,33339,32537,32819,32876,33428,33397,33420,33410,32818)
;
(this query time : 0.038 s)
(total SQL time : 0.099 s)
(total time : 0.165 s)
(num rows : 638 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.000 s)
(total SQL time : 0.100 s)
(total time : 0.512 s)
(num rows : 1 )