[1]
SELECT @@SESSION.sql_mode
(this query time : 0.001 s)
(total SQL time : 0.001 s)
(total time : 0.009 s)
(num rows : 1 )
[2]
SELECT param, value
FROM g_config
;
(this query time : 0.002 s)
(total SQL time : 0.003 s)
(total time : 0.013 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D8497ec09a2a5c5e26df3f968172458ceef9'
;
(this query time : 0.001 s)
(total SQL time : 0.005 s)
(total time : 0.015 s)
(num rows : 1 )
[4]
SELECT * FROM g_plugins
WHERE state='active'
(this query time : 0.002 s)
(total SQL time : 0.006 s)
(total time : 0.017 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.030 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.032 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.003 s)
(total SQL time : 0.012 s)
(total time : 0.034 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.037 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (1611)
(this query time : 0.001 s)
(total SQL time : 0.015 s)
(total time : 0.057 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 (1611)
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.033 s)
(total SQL time : 0.046 s)
(total time : 0.091 s)
(num rows : 387 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 33339
;
(this query time : 0.001 s)
(total SQL time : 0.048 s)
(total time : 0.093 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 = 33339
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.049 s)
(total time : 0.094 s)
(num rows : 1 )
[12]
SELECT *
FROM g_images
WHERE id IN (33339,33337,33482,33340,4712)
;
(this query time : 0.002 s)
(total SQL time : 0.051 s)
(total time : 0.096 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 (33339)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.003 s)
(total SQL time : 0.054 s)
(total time : 0.110 s)
(num rows : 23 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,871,884)
(this query time : 0.001 s)
(total SQL time : 0.055 s)
(total time : 0.112 s)
(num rows : 3 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 33339 AND validated = 'true'
;
(this query time : 0.001 s)
(total SQL time : 0.056 s)
(total time : 0.118 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,33387,33393,33396,33397,33398,33410,33433,33439,33443,33454,33457,33458,33337,33339,33340,33341,33343,33344,33234,32993,32920,32939,32954,32955,32857,32849,32847,32846,32698,32554,32537,32520,32516,32513,32512,32506,32505,32504,32496,32429,32428,32391,32363,32375,32376,32336,32202,32204,32207,32221,32225,32229,32237,32239,32240,32276,32291,32298,32303,32305,32307,32310,32323,32326,32330,32335,32200,32190,32184,32150,32151,32152,32154,32156,32157,32159,32143,32141,32136,32135,32134,32109,32111,32107,32103,32104,32100,31925,31936,31885,31808,31796,31814,31815,31816,31803,31841,31849,31864,31804,31792,31775,31757,31750,31732,31714,31661,31667,31676,31691,31658,31632,31631,31626,31622,31615,31566,31562,31554,31547,31541,31455,31461,31492,31509,31516,31439,31431,31280,31309,31422,31222,31223,31421,31417,31228,31415,31232,31233,31409,31405,31403,31143,31386,31365,31095,31091,31361,31086,31058,31005,30963,30922,30783,30636,30595,30421,30422,30458,30452,30412,30121,30128,30142,30144,30147,30155,30157,30158,30164,30166,30194,30081,30080,30079,30074,30072,30071,30068,30034,30047,30028,29995,30001,30005,30009,29963,29954,29953,29951,29937,29922,29917,29913,29906,29896,29895,29836,29843,29854,29856,29862,29870,29873,29874,29876,29878,29891,29812,29818,29819,29821,29832,29797,29801,29803,29783,29777,29748,29750,29751,29752,29754,29755,29756,29759,29766,29767,29769,29771,29772,29773,29686,29689,29687,29690,29696,29697,29699,29703,29706,29710,29718,29714,29679,29653,29654,29655,29656,29660,29663,29668,29676,29674,29611,29613,29617,29623,29631,29639,29540,29542,29543,29549,29550,29551,29552,29553,29554,29556,29559,29561,29569,29574,29577,29578,29579,29580,29581,29582,29583,29585,29589,29591,29593,29602,29518,29524,29533,29535,29511,29506,29491,29425,29426,29430,29422,29389,29392,29397,29387,29294,29311,29316,29343,29347,29363,29368,29378,29383,29183,29200,29201,29213,29243,29250,29251,29145,29139,29138,29122,29047,29053,29071,29085,29090,29087,28992,29011,28986,28955,28952,28907,28905,28886,28880,28867,28870,28804,28919,28911,28799,28768,28774,28777,28786,28757,28759,28736,28745,28715,28697,28696,28695,28694,28693,28691,28690,28687,28683,28639,28617,28623,28616,28615,28614,28612,28611,28610,28609,28608,28603,28570,28540,28525,28524,28487,28479,28456,28455,28451,6300,14251,30718,30890,4712)
ORDER BY FIELD(id, 33482,33387,33393,33396,33397,33398,33410,33433,33439,33443,33454,33457,33458,33337,33339,33340,33341,33343,33344,33234,32993,32920,32939,32954,32955,32857,32849,32847,32846,32698,32554,32537,32520,32516,32513,32512,32506,32505,32504,32496,32429,32428,32391,32363,32375,32376,32336,32202,32204,32207,32221,32225,32229,32237,32239,32240,32276,32291,32298,32303,32305,32307,32310,32323,32326,32330,32335,32200,32190,32184,32150,32151,32152,32154,32156,32157,32159,32143,32141,32136,32135,32134,32109,32111,32107,32103,32104,32100,31925,31936,31885,31808,31796,31814,31815,31816,31803,31841,31849,31864,31804,31792,31775,31757,31750,31732,31714,31661,31667,31676,31691,31658,31632,31631,31626,31622,31615,31566,31562,31554,31547,31541,31455,31461,31492,31509,31516,31439,31431,31280,31309,31422,31222,31223,31421,31417,31228,31415,31232,31233,31409,31405,31403,31143,31386,31365,31095,31091,31361,31086,31058,31005,30963,30922,30783,30636,30595,30421,30422,30458,30452,30412,30121,30128,30142,30144,30147,30155,30157,30158,30164,30166,30194,30081,30080,30079,30074,30072,30071,30068,30034,30047,30028,29995,30001,30005,30009,29963,29954,29953,29951,29937,29922,29917,29913,29906,29896,29895,29836,29843,29854,29856,29862,29870,29873,29874,29876,29878,29891,29812,29818,29819,29821,29832,29797,29801,29803,29783,29777,29748,29750,29751,29752,29754,29755,29756,29759,29766,29767,29769,29771,29772,29773,29686,29689,29687,29690,29696,29697,29699,29703,29706,29710,29718,29714,29679,29653,29654,29655,29656,29660,29663,29668,29676,29674,29611,29613,29617,29623,29631,29639,29540,29542,29543,29549,29550,29551,29552,29553,29554,29556,29559,29561,29569,29574,29577,29578,29579,29580,29581,29582,29583,29585,29589,29591,29593,29602,29518,29524,29533,29535,29511,29506,29491,29425,29426,29430,29422,29389,29392,29397,29387,29294,29311,29316,29343,29347,29363,29368,29378,29383,29183,29200,29201,29213,29243,29250,29251,29145,29139,29138,29122,29047,29053,29071,29085,29090,29087,28992,29011,28986,28955,28952,28907,28905,28886,28880,28867,28870,28804,28919,28911,28799,28768,28774,28777,28786,28757,28759,28736,28745,28715,28697,28696,28695,28694,28693,28691,28690,28687,28683,28639,28617,28623,28616,28615,28614,28612,28611,28610,28609,28608,28603,28570,28540,28525,28524,28487,28479,28456,28455,28451,6300,14251,30718,30890,4712)
;
(this query time : 0.021 s)
(total SQL time : 0.077 s)
(total time : 0.142 s)
(num rows : 387 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.077 s)
(total time : 0.310 s)
(num rows : 1 )