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