[1]
SELECT @@SESSION.sql_mode
(this query time : 0.000 s)
(total SQL time : 0.000 s)
(total time : 0.005 s)
(num rows : 1 )
[2]
SELECT param, value
FROM g_config
;
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.006 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D84996354d66fac0410817e8cd3724e1b64a'
;
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.007 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.007 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.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.000 s)
(total SQL time : 0.002 s)
(total time : 0.009 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.004 s)
(total SQL time : 0.006 s)
(total time : 0.014 s)
(num rows : 1 )
[8]
SELECT *
FROM g_user_infos
WHERE user_id = 2
;
(this query time : 0.000 s)
(total SQL time : 0.007 s)
(total time : 0.014 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (2454)
(this query time : 0.001 s)
(total SQL time : 0.007 s)
(total time : 0.022 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 (2454)
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.009 s)
(total SQL time : 0.016 s)
(total time : 0.031 s)
(num rows : 413 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 32130
;
(this query time : 0.000 s)
(total SQL time : 0.016 s)
(total time : 0.032 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 = 32130
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.017 s)
(total time : 0.032 s)
(num rows : 2 )
[12]
SELECT *
FROM g_images
WHERE id IN (32130,32131,33702,32127,14751)
;
(this query time : 0.000 s)
(total SQL time : 0.017 s)
(total time : 0.033 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 (32130)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.001 s)
(total SQL time : 0.018 s)
(total time : 0.039 s)
(num rows : 18 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,871,877,152,267,216)
(this query time : 0.000 s)
(total SQL time : 0.018 s)
(total time : 0.040 s)
(num rows : 6 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 32130 AND validated = 'true'
;
(this query time : 0.000 s)
(total SQL time : 0.019 s)
(total time : 0.043 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (33702,33619,33620,33622,33639,33663,33664,33541,33543,33544,33555,33558,33560,33561,33563,33571,33504,33518,33520,33522,33537,33481,33475,33374,33378,33381,33382,33384,33395,33400,33406,33425,33444,33445,33446,33447,33453,33464,33324,33325,33326,33328,33329,33332,33334,33335,33337,33339,33361,33371,33236,33241,33242,33243,33247,33257,33125,33126,33127,33128,33130,33131,33133,33141,33142,33175,33190,33195,33197,33199,33201,33207,33060,33065,33036,33068,33091,33098,32972,32973,32970,32966,32901,32910,32912,32913,32916,32923,32924,32869,32819,32781,32774,32721,32714,32704,32680,32675,32670,32663,32658,32655,32640,32622,32621,32620,32611,32601,32600,32579,32574,32563,32556,32529,32527,32446,32444,32443,32237,32246,32253,32265,32266,32277,32295,32307,32308,32317,32325,32195,32149,32150,32154,32157,32145,32143,32141,32131,32130,32127,31923,31936,31948,31949,31954,31956,31957,31963,31966,31967,31912,31970,31909,31908,31901,31900,31897,31876,31794,31822,31801,31823,31828,31857,31861,31768,31726,31676,31689,31646,31613,31596,31598,31602,31592,31575,31576,31577,31587,31589,31451,31462,31483,31507,31517,31534,31275,31208,31225,31226,31151,31150,31136,31133,31132,31127,31125,31123,31122,31119,31117,31114,31110,31109,31377,31079,31352,31351,31076,31074,31075,31071,31065,31063,30964,30961,30957,30956,30821,30811,30802,30751,30747,30609,30596,30514,30150,30151,30155,30066,30052,30025,30021,30020,30002,29929,29926,29916,29859,29873,29813,29777,29765,29766,29773,29647,29657,29658,29660,29659,29664,29669,29670,29607,29612,29615,29617,29626,29632,29541,29550,29566,29570,29574,29575,29581,29529,29533,29496,29499,29425,29426,29429,29430,29432,29439,29442,29396,29310,29316,29332,29348,29357,29372,29377,29095,29128,29047,29048,29055,28996,29001,29012,29036,29038,28983,28981,28972,28780,28792,28793,28794,28731,28732,28735,28738,28741,28707,28704,28701,28691,28689,28559,28558,28556,28554,28551,28550,28547,28544,28543,28538,28529,28504,28496,28491,28487,28476,28447,28402,28398,28396,28167,28168,27801,27800,27799,27795,27794,27757,27755,27752,27747,26512,26450,26448,26447,26446,26435,26433,26253,26264,26092,26028,25754,25536,25262,24659,24592,23815,23543,22181,22089,22088,21782,21120,21079,19744,19737,19736,19734,19731,19729,19740,19726,18996,18994,18993,18562,18640,17721,17772,17319,15563,15564,17015,17018,17020,16671,16666,16571,16566,16456,16018,16173,16015,15993,15913,15307,15115,13868,13239,12828,12668,12712,8464,5528,5527,5530,5531,5534,5533,14751)
ORDER BY FIELD(id, 33702,33619,33620,33622,33639,33663,33664,33541,33543,33544,33555,33558,33560,33561,33563,33571,33504,33518,33520,33522,33537,33481,33475,33374,33378,33381,33382,33384,33395,33400,33406,33425,33444,33445,33446,33447,33453,33464,33324,33325,33326,33328,33329,33332,33334,33335,33337,33339,33361,33371,33236,33241,33242,33243,33247,33257,33125,33126,33127,33128,33130,33131,33133,33141,33142,33175,33190,33195,33197,33199,33201,33207,33060,33065,33036,33068,33091,33098,32972,32973,32970,32966,32901,32910,32912,32913,32916,32923,32924,32869,32819,32781,32774,32721,32714,32704,32680,32675,32670,32663,32658,32655,32640,32622,32621,32620,32611,32601,32600,32579,32574,32563,32556,32529,32527,32446,32444,32443,32237,32246,32253,32265,32266,32277,32295,32307,32308,32317,32325,32195,32149,32150,32154,32157,32145,32143,32141,32131,32130,32127,31923,31936,31948,31949,31954,31956,31957,31963,31966,31967,31912,31970,31909,31908,31901,31900,31897,31876,31794,31822,31801,31823,31828,31857,31861,31768,31726,31676,31689,31646,31613,31596,31598,31602,31592,31575,31576,31577,31587,31589,31451,31462,31483,31507,31517,31534,31275,31208,31225,31226,31151,31150,31136,31133,31132,31127,31125,31123,31122,31119,31117,31114,31110,31109,31377,31079,31352,31351,31076,31074,31075,31071,31065,31063,30964,30961,30957,30956,30821,30811,30802,30751,30747,30609,30596,30514,30150,30151,30155,30066,30052,30025,30021,30020,30002,29929,29926,29916,29859,29873,29813,29777,29765,29766,29773,29647,29657,29658,29660,29659,29664,29669,29670,29607,29612,29615,29617,29626,29632,29541,29550,29566,29570,29574,29575,29581,29529,29533,29496,29499,29425,29426,29429,29430,29432,29439,29442,29396,29310,29316,29332,29348,29357,29372,29377,29095,29128,29047,29048,29055,28996,29001,29012,29036,29038,28983,28981,28972,28780,28792,28793,28794,28731,28732,28735,28738,28741,28707,28704,28701,28691,28689,28559,28558,28556,28554,28551,28550,28547,28544,28543,28538,28529,28504,28496,28491,28487,28476,28447,28402,28398,28396,28167,28168,27801,27800,27799,27795,27794,27757,27755,27752,27747,26512,26450,26448,26447,26446,26435,26433,26253,26264,26092,26028,25754,25536,25262,24659,24592,23815,23543,22181,22089,22088,21782,21120,21079,19744,19737,19736,19734,19731,19729,19740,19726,18996,18994,18993,18562,18640,17721,17772,17319,15563,15564,17015,17018,17020,16671,16666,16571,16566,16456,16018,16173,16015,15993,15913,15307,15115,13868,13239,12828,12668,12712,8464,5528,5527,5530,5531,5534,5533,14751)
;
(this query time : 0.010 s)
(total SQL time : 0.028 s)
(total time : 0.055 s)
(num rows : 413 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.029 s)
(total time : 0.230 s)
(num rows : 1 )