[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 = 'D8491cf9d4550864236ae18f06aac869dc13'
;
(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.002 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.003 s)
(total SQL time : 0.005 s)
(total time : 0.009 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.005 s)
(total time : 0.010 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.006 s)
(total time : 0.010 s)
(num rows : 1 )
[8]
SELECT *
FROM g_user_infos
WHERE user_id = 2
;
(this query time : 0.000 s)
(total SQL time : 0.006 s)
(total time : 0.011 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (648)
(this query time : 0.000 s)
(total SQL time : 0.007 s)
(total time : 0.019 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 (648)
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.019 s)
(total SQL time : 0.025 s)
(total time : 0.038 s)
(num rows : 915 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 30491
;
(this query time : 0.001 s)
(total SQL time : 0.026 s)
(total time : 0.039 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 = 30491
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.026 s)
(total time : 0.039 s)
(num rows : 2 )
[12]
SELECT *
FROM g_images
WHERE id IN (30491,30471,33386,30489,7647)
;
(this query time : 0.001 s)
(total SQL time : 0.027 s)
(total time : 0.040 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 (30491)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.006 s)
(total SQL time : 0.033 s)
(total time : 0.049 s)
(num rows : 29 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,871,872,152,262,170)
(this query time : 0.001 s)
(total SQL time : 0.033 s)
(total time : 0.050 s)
(num rows : 6 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 30491 AND validated = 'true'
;
(this query time : 0.001 s)
(total SQL time : 0.034 s)
(total time : 0.053 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (33386,33387,33393,33396,33397,33398,33410,33423,33428,33432,33433,33434,33435,33439,33454,33457,33458,33337,33339,33340,33341,33342,33343,33344,33303,33304,33234,33218,33231,33068,33024,33021,32993,32920,32921,32922,32924,32937,32947,32948,32955,32889,32876,32869,32863,32858,32857,32852,32850,32849,32847,32823,32819,32818,32781,32773,32746,32574,32554,32532,32531,32525,32520,32516,32514,33678,33677,32513,32507,32506,32503,32501,32502,32496,32481,32446,32445,32439,32430,32429,32428,32423,32413,32412,32409,32408,32399,32395,32393,32391,32389,32385,32344,32351,32353,32356,32357,32358,32363,32369,32375,32379,32202,32204,32207,32221,32225,32228,32229,32231,32235,32236,32237,32239,32240,32245,32246,32247,32256,32262,32269,32272,32276,32289,32291,32298,32303,32304,32305,32307,32310,32320,32323,32326,32329,32330,32335,32334,32192,32199,32198,32190,32189,32197,32184,32176,32175,32148,32150,32151,32152,32154,32156,32157,32159,32143,32141,32142,32137,32136,32135,32134,32114,32113,32110,32108,32109,32111,32107,32105,32103,32104,32101,32100,31925,31936,31909,31908,31885,31879,31795,31808,31796,31799,31811,31813,31814,31815,31818,31832,31803,31840,31841,31842,31848,31849,31850,31857,31859,31864,31868,31872,31792,31791,31779,31778,31776,31775,31772,31771,31764,31763,31762,31757,31750,31747,31745,31742,31739,31734,31732,31727,31726,31724,31721,31720,31718,31713,31661,31662,31667,31668,31671,31675,31676,31679,31682,31685,31699,31701,31704,31658,31656,31654,31652,31651,31647,31646,31643,31640,31632,31626,31622,31621,31613,31609,31605,31603,31595,31601,31587,31591,31566,31565,31564,31562,31560,31555,31554,31548,31547,31544,31541,31455,31456,31461,31462,31473,31476,31477,31478,31482,31486,31492,31495,31512,31533,31439,31438,31437,31260,31431,31278,31280,31281,31293,31299,31301,31305,31309,31424,31422,31220,31222,31223,31421,31225,31418,31228,31230,31233,31234,31240,31244,31404,31403,31248,31394,31156,31114,31110,31108,31372,31361,31360,31079,31353,31067,31060,31058,31050,31047,30988,30986,31009,31007,30972,30970,30969,30967,30965,30960,30955,30949,30948,30931,30923,30920,30827,30790,30783,30779,30773,30748,30641,30636,30619,30611,30596,30595,31017,30538,30511,30509,30497,30471,30491,30489,30421,30458,30427,30429,30432,30433,30436,30447,30448,30452,30453,30454,30455,30412,29731,30097,30102,30104,30105,30106,30108,30109,30113,30114,30121,30128,30134,30140,30141,30146,30156,30157,30159,30161,30164,30165,30163,30175,30177,30178,30179,30186,30188,30192,30197,30213,30210,30318,30092,30089,30087,30086,30085,30083,30077,30074,30068,30067,30036,30037,30038,30039,30040,30041,30056,30057,30059,30061,30032,30253,30029,30028,30025,30023,30021,30020,30019,30018,30015,30017,29998,29999,30001,30006,30010,29963,29957,29953,29948,29947,29946,29944,29939,29936,29930,29928,29925,29922,29917,29913,29912,29911,29908,29907,29901,29899,29896,29836,29838,29839,29843,29850,29854,29855,29856,29862,29870,29873,29874,29876,29877,29878,29891,29887,29812,29818,29820,29816,29819,29821,29825,29832,29797,29801,29804,29809,29803,29783,29777,29748,29750,29751,29752,29754,29755,29756,29761,29758,29765,29766,29767,29769,29771,29772,29773,29681,29686,29689,29687,29696,29695,29697,29699,29701,29703,29704,29705,29709,29710,29719,29718,29714,29679,29647,29654,29655,29656,29660,29663,29667,29668,29673,29676,29674,29677,29611,29613,29617,29623,29625,29626,29631,29636,29639,29540,29542,29543,29549,29550,29551,29552,29553,29554,29555,29556,29558,29559,29561,29564,29569,29571,29574,29577,29578,29579,29580,29581,29582,29584,29585,29586,29591,29596,29602,29514,29516,29517,29524,29533,29536,29535,29538,29511,29509,29506,29508,29466,29468,29470,29472,29473,29479,29480,29483,29487,29488,29491,29492,29502,29425,29426,29430,29436,29440,29452,29422,29459,29389,29391,29392,29393,29397,29298,29297,29300,29306,29308,29386,29310,29311,29312,29316,29319,29330,29331,29343,29347,29359,29364,29365,29376,29377,29378,29290,29165,29166,29167,29174,29183,29185,29200,29203,29204,29205,29213,29217,29223,29243,29250,29252,29154,29152,29150,29148,29146,29145,29139,29138,29137,29099,29109,29118,29122,29125,29127,29129,29047,29051,29063,29065,29067,29068,29076,29078,29081,29085,29090,29087,28991,28992,29006,29018,29028,29034,29038,29037,28986,28983,28973,28955,28953,28952,28943,28905,28902,28901,28900,28899,28890,28892,28887,28886,28884,28883,28880,28878,28875,28873,28867,28868,28869,28815,28919,28915,28910,28911,28913,28802,28799,28798,28797,28764,28765,28766,28767,28768,28769,28770,28771,28772,28773,28775,28777,28778,28780,28781,28783,28784,28785,28786,28787,28788,28789,28790,28833,28832,28831,28830,28752,28753,28754,28756,28757,28759,28760,28761,28762,28763,28727,28729,28731,28732,28733,28734,28735,28736,28737,28738,28740,28741,28742,28743,28744,28745,28746,28749,28750,28692,28725,28723,28721,28717,28716,28715,28713,28712,28711,28698,28697,28696,28695,28693,28691,28690,28689,28687,28686,28684,28683,28682,28678,28676,28666,28665,28662,28660,28659,28657,28656,28645,28638,28637,28629,28625,28618,28617,28623,28616,28615,28614,28612,28611,28610,28609,28608,28603,28602,28598,28573,28570,28538,28537,28536,28535,28530,28523,28521,28520,28518,28501,28500,28499,28487,28461,28457,28456,28455,28454,28453,28452,28451,28450,28443,28431,28429,28411,28395,28390,28361,28181,27769,27768,27523,27349,26897,26745,26314,26313,24152,23805,23345,23305,22079,17811,17590,17246,17229,17134,15938,6533,6040,30904,12195,30898,11261,30712,30713,30897,30702,10999,30890,5163,4712,30863,3715,7632,7647)
ORDER BY FIELD(id, 33386,33387,33393,33396,33397,33398,33410,33423,33428,33432,33433,33434,33435,33439,33454,33457,33458,33337,33339,33340,33341,33342,33343,33344,33303,33304,33234,33218,33231,33068,33024,33021,32993,32920,32921,32922,32924,32937,32947,32948,32955,32889,32876,32869,32863,32858,32857,32852,32850,32849,32847,32823,32819,32818,32781,32773,32746,32574,32554,32532,32531,32525,32520,32516,32514,33678,33677,32513,32507,32506,32503,32501,32502,32496,32481,32446,32445,32439,32430,32429,32428,32423,32413,32412,32409,32408,32399,32395,32393,32391,32389,32385,32344,32351,32353,32356,32357,32358,32363,32369,32375,32379,32202,32204,32207,32221,32225,32228,32229,32231,32235,32236,32237,32239,32240,32245,32246,32247,32256,32262,32269,32272,32276,32289,32291,32298,32303,32304,32305,32307,32310,32320,32323,32326,32329,32330,32335,32334,32192,32199,32198,32190,32189,32197,32184,32176,32175,32148,32150,32151,32152,32154,32156,32157,32159,32143,32141,32142,32137,32136,32135,32134,32114,32113,32110,32108,32109,32111,32107,32105,32103,32104,32101,32100,31925,31936,31909,31908,31885,31879,31795,31808,31796,31799,31811,31813,31814,31815,31818,31832,31803,31840,31841,31842,31848,31849,31850,31857,31859,31864,31868,31872,31792,31791,31779,31778,31776,31775,31772,31771,31764,31763,31762,31757,31750,31747,31745,31742,31739,31734,31732,31727,31726,31724,31721,31720,31718,31713,31661,31662,31667,31668,31671,31675,31676,31679,31682,31685,31699,31701,31704,31658,31656,31654,31652,31651,31647,31646,31643,31640,31632,31626,31622,31621,31613,31609,31605,31603,31595,31601,31587,31591,31566,31565,31564,31562,31560,31555,31554,31548,31547,31544,31541,31455,31456,31461,31462,31473,31476,31477,31478,31482,31486,31492,31495,31512,31533,31439,31438,31437,31260,31431,31278,31280,31281,31293,31299,31301,31305,31309,31424,31422,31220,31222,31223,31421,31225,31418,31228,31230,31233,31234,31240,31244,31404,31403,31248,31394,31156,31114,31110,31108,31372,31361,31360,31079,31353,31067,31060,31058,31050,31047,30988,30986,31009,31007,30972,30970,30969,30967,30965,30960,30955,30949,30948,30931,30923,30920,30827,30790,30783,30779,30773,30748,30641,30636,30619,30611,30596,30595,31017,30538,30511,30509,30497,30471,30491,30489,30421,30458,30427,30429,30432,30433,30436,30447,30448,30452,30453,30454,30455,30412,29731,30097,30102,30104,30105,30106,30108,30109,30113,30114,30121,30128,30134,30140,30141,30146,30156,30157,30159,30161,30164,30165,30163,30175,30177,30178,30179,30186,30188,30192,30197,30213,30210,30318,30092,30089,30087,30086,30085,30083,30077,30074,30068,30067,30036,30037,30038,30039,30040,30041,30056,30057,30059,30061,30032,30253,30029,30028,30025,30023,30021,30020,30019,30018,30015,30017,29998,29999,30001,30006,30010,29963,29957,29953,29948,29947,29946,29944,29939,29936,29930,29928,29925,29922,29917,29913,29912,29911,29908,29907,29901,29899,29896,29836,29838,29839,29843,29850,29854,29855,29856,29862,29870,29873,29874,29876,29877,29878,29891,29887,29812,29818,29820,29816,29819,29821,29825,29832,29797,29801,29804,29809,29803,29783,29777,29748,29750,29751,29752,29754,29755,29756,29761,29758,29765,29766,29767,29769,29771,29772,29773,29681,29686,29689,29687,29696,29695,29697,29699,29701,29703,29704,29705,29709,29710,29719,29718,29714,29679,29647,29654,29655,29656,29660,29663,29667,29668,29673,29676,29674,29677,29611,29613,29617,29623,29625,29626,29631,29636,29639,29540,29542,29543,29549,29550,29551,29552,29553,29554,29555,29556,29558,29559,29561,29564,29569,29571,29574,29577,29578,29579,29580,29581,29582,29584,29585,29586,29591,29596,29602,29514,29516,29517,29524,29533,29536,29535,29538,29511,29509,29506,29508,29466,29468,29470,29472,29473,29479,29480,29483,29487,29488,29491,29492,29502,29425,29426,29430,29436,29440,29452,29422,29459,29389,29391,29392,29393,29397,29298,29297,29300,29306,29308,29386,29310,29311,29312,29316,29319,29330,29331,29343,29347,29359,29364,29365,29376,29377,29378,29290,29165,29166,29167,29174,29183,29185,29200,29203,29204,29205,29213,29217,29223,29243,29250,29252,29154,29152,29150,29148,29146,29145,29139,29138,29137,29099,29109,29118,29122,29125,29127,29129,29047,29051,29063,29065,29067,29068,29076,29078,29081,29085,29090,29087,28991,28992,29006,29018,29028,29034,29038,29037,28986,28983,28973,28955,28953,28952,28943,28905,28902,28901,28900,28899,28890,28892,28887,28886,28884,28883,28880,28878,28875,28873,28867,28868,28869,28815,28919,28915,28910,28911,28913,28802,28799,28798,28797,28764,28765,28766,28767,28768,28769,28770,28771,28772,28773,28775,28777,28778,28780,28781,28783,28784,28785,28786,28787,28788,28789,28790,28833,28832,28831,28830,28752,28753,28754,28756,28757,28759,28760,28761,28762,28763,28727,28729,28731,28732,28733,28734,28735,28736,28737,28738,28740,28741,28742,28743,28744,28745,28746,28749,28750,28692,28725,28723,28721,28717,28716,28715,28713,28712,28711,28698,28697,28696,28695,28693,28691,28690,28689,28687,28686,28684,28683,28682,28678,28676,28666,28665,28662,28660,28659,28657,28656,28645,28638,28637,28629,28625,28618,28617,28623,28616,28615,28614,28612,28611,28610,28609,28608,28603,28602,28598,28573,28570,28538,28537,28536,28535,28530,28523,28521,28520,28518,28501,28500,28499,28487,28461,28457,28456,28455,28454,28453,28452,28451,28450,28443,28431,28429,28411,28395,28390,28361,28181,27769,27768,27523,27349,26897,26745,26314,26313,24152,23805,23345,23305,22079,17811,17590,17246,17229,17134,15938,6533,6040,30904,12195,30898,11261,30712,30713,30897,30702,10999,30890,5163,4712,30863,3715,7632,7647)
;
(this query time : 0.026 s)
(total SQL time : 0.059 s)
(total time : 0.084 s)
(num rows : 915 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.060 s)
(total time : 0.609 s)
(num rows : 1 )