[1]
SELECT @@SESSION.sql_mode
(this query time : 0.000 s)
(total SQL time : 0.000 s)
(total time : 0.003 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.005 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D8491cf9d4550864236ae18f06aac869dc13'
;
(this query time : 0.001 s)
(total SQL time : 0.002 s)
(total time : 0.006 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.006 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.003 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.003 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.004 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.004 s)
(total time : 0.011 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (708)
(this query time : 0.000 s)
(total SQL time : 0.005 s)
(total time : 0.016 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 (708)
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.011 s)
(total SQL time : 0.015 s)
(total time : 0.027 s)
(num rows : 668 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 14897
;
(this query time : 0.001 s)
(total SQL time : 0.016 s)
(total time : 0.027 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 = 14897
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.016 s)
(total time : 0.028 s)
(num rows : 1 )
[12]
SELECT *
FROM g_images
WHERE id IN (14897,14900,33600,14884,14884)
;
(this query time : 0.001 s)
(total SQL time : 0.017 s)
(total time : 0.029 s)
(num rows : 4 )
[13]
SELECT t.*, count(*) AS counter
FROM g_image_tag
INNER JOIN g_tags t ON tag_id = id
WHERE image_id IN (14897)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.001 s)
(total SQL time : 0.017 s)
(total time : 0.032 s)
(num rows : 9 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (213,518)
(this query time : 0.000 s)
(total SQL time : 0.018 s)
(total time : 0.033 s)
(num rows : 2 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 14897 AND validated = 'true'
;
(this query time : 0.000 s)
(total SQL time : 0.018 s)
(total time : 0.035 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (33600,33664,33580,33516,33485,33481,33396,33402,33425,33337,33235,33241,33266,33267,33269,33270,33287,33179,33207,33065,33069,32999,32996,32995,32994,32966,32916,32893,32873,32863,32850,32715,32703,32600,32598,32563,32536,32509,32438,32416,32410,32403,32400,32306,32147,32149,32146,32110,32105,32103,31914,31959,31969,31767,31764,31662,31610,31599,31583,31467,31476,31506,31261,31273,31413,31123,31102,31077,30986,30980,30970,30955,30945,30923,30914,30770,30577,30447,30454,30124,30126,30175,30066,30065,30041,30044,30045,30057,30250,30023,29961,29834,29857,29862,29863,29864,29865,29867,29869,29870,29819,29800,29802,29804,29771,29772,29773,29682,29708,29718,29655,29668,29618,29624,29627,29551,29552,29577,29578,29579,29588,29511,29509,29469,29486,29452,29459,29388,29306,29311,29344,29349,29384,29184,29154,29093,29094,29095,29096,29097,29098,29099,29100,29101,29102,29103,29104,29105,29106,29107,29108,29110,29111,29112,29113,29114,29115,29116,29118,29117,29119,29050,28996,28997,29001,29002,29003,29021,28975,28964,28955,28898,28896,28895,28892,28879,28796,28764,28777,28790,28721,28713,28682,28680,28678,28677,28675,28634,28633,28453,28440,28439,28415,28360,28211,28179,28180,28014,27967,27923,27941,27816,27789,27755,27748,27682,27680,27679,27634,27509,27508,27464,27001,27002,27003,26745,26715,26714,26713,26712,26711,26710,26530,26506,26504,26452,26450,26449,26445,26444,26443,26442,26441,26397,26286,26287,26133,25972,25647,25674,25627,25626,25583,25582,25580,25537,25535,25536,25473,25329,25340,25345,25358,25362,25375,25376,25391,25403,25404,25405,25406,25407,25419,25298,25297,25296,25295,25294,25195,25194,25193,25192,25191,25190,25189,25150,25146,25141,25057,25058,25059,25060,24979,24951,24924,24920,24919,24918,24916,24915,24914,24913,24897,24887,24757,24755,24691,24667,24666,24665,24663,24662,24661,24660,24657,24570,24568,24567,24494,24493,24491,24485,24460,24459,24458,24345,24227,24219,24166,24133,24104,24080,24078,23941,23939,23942,23914,23865,23759,23758,23757,23755,23751,23750,23749,23747,23746,23563,23546,23539,23532,23528,23531,23526,23500,23488,23482,23417,23424,23419,23391,23327,23326,23325,23324,23323,23321,23315,23314,23312,23311,23309,23306,23286,23288,23285,23287,23243,23237,23236,23233,23232,23231,23230,23229,23228,23227,23226,23225,23224,23223,23222,23238,22094,22085,22084,22087,22083,22086,22081,22036,21901,21877,21873,21872,21871,21870,21869,21868,21867,21834,21833,21832,21831,21827,21751,21753,21698,21668,21623,21595,21589,21558,21557,21556,21555,21553,21552,21549,21341,21282,21253,21251,21244,21241,21095,21094,21067,21043,21042,21041,20994,20879,20838,20797,20796,20508,20507,20505,20572,20568,20567,20529,20131,20128,19915,19914,19864,19854,19852,19853,19855,19757,19755,19752,19694,19665,19597,19595,19591,19594,19586,19588,19585,19540,19536,19538,19535,19457,19456,19127,19126,19122,19119,19102,19084,19082,19066,19065,19039,18823,18821,18820,18816,18818,18815,18819,18813,18814,18812,18808,18810,18809,18807,18805,18802,18804,18803,18796,18799,18798,18797,18806,18723,18710,18529,18550,18705,18693,18691,18690,18651,18638,18631,18627,18626,18624,18615,18614,18613,18612,18611,18608,18470,18256,18251,18250,18242,18241,18246,18165,18071,18070,17946,17940,17938,17786,17824,17619,17579,17531,17532,17339,17338,17341,17333,17284,17283,17280,17279,17278,17276,17275,17273,17271,17269,17268,17267,17266,17265,17259,17037,17118,17119,17120,17121,17123,16926,16646,16500,16506,16507,16501,16508,16397,16396,16395,16394,16387,15963,15945,15944,15949,15947,15930,15929,15906,15781,15784,15775,15779,15773,15772,15771,15770,15766,15479,15483,15477,15475,15470,15340,15338,15331,15310,15307,15306,15029,15028,15025,15026,15024,15022,15021,15017,15018,15016,15015,15014,15011,15012,15007,15009,15006,15010,15008,14978,14544,14469,14419,14405,14403,14404,14400,14398,14397,14396,13016,10047,10357,9895,11104,30897,5867,5715,3836,3837,3840,14792,14790,14789,14787,14786,14870,14863,14847,14749,14691,14814,14704,14903,14902,14904,14901,14899,14900,14897,14884)
ORDER BY FIELD(id, 33600,33664,33580,33516,33485,33481,33396,33402,33425,33337,33235,33241,33266,33267,33269,33270,33287,33179,33207,33065,33069,32999,32996,32995,32994,32966,32916,32893,32873,32863,32850,32715,32703,32600,32598,32563,32536,32509,32438,32416,32410,32403,32400,32306,32147,32149,32146,32110,32105,32103,31914,31959,31969,31767,31764,31662,31610,31599,31583,31467,31476,31506,31261,31273,31413,31123,31102,31077,30986,30980,30970,30955,30945,30923,30914,30770,30577,30447,30454,30124,30126,30175,30066,30065,30041,30044,30045,30057,30250,30023,29961,29834,29857,29862,29863,29864,29865,29867,29869,29870,29819,29800,29802,29804,29771,29772,29773,29682,29708,29718,29655,29668,29618,29624,29627,29551,29552,29577,29578,29579,29588,29511,29509,29469,29486,29452,29459,29388,29306,29311,29344,29349,29384,29184,29154,29093,29094,29095,29096,29097,29098,29099,29100,29101,29102,29103,29104,29105,29106,29107,29108,29110,29111,29112,29113,29114,29115,29116,29118,29117,29119,29050,28996,28997,29001,29002,29003,29021,28975,28964,28955,28898,28896,28895,28892,28879,28796,28764,28777,28790,28721,28713,28682,28680,28678,28677,28675,28634,28633,28453,28440,28439,28415,28360,28211,28179,28180,28014,27967,27923,27941,27816,27789,27755,27748,27682,27680,27679,27634,27509,27508,27464,27001,27002,27003,26745,26715,26714,26713,26712,26711,26710,26530,26506,26504,26452,26450,26449,26445,26444,26443,26442,26441,26397,26286,26287,26133,25972,25647,25674,25627,25626,25583,25582,25580,25537,25535,25536,25473,25329,25340,25345,25358,25362,25375,25376,25391,25403,25404,25405,25406,25407,25419,25298,25297,25296,25295,25294,25195,25194,25193,25192,25191,25190,25189,25150,25146,25141,25057,25058,25059,25060,24979,24951,24924,24920,24919,24918,24916,24915,24914,24913,24897,24887,24757,24755,24691,24667,24666,24665,24663,24662,24661,24660,24657,24570,24568,24567,24494,24493,24491,24485,24460,24459,24458,24345,24227,24219,24166,24133,24104,24080,24078,23941,23939,23942,23914,23865,23759,23758,23757,23755,23751,23750,23749,23747,23746,23563,23546,23539,23532,23528,23531,23526,23500,23488,23482,23417,23424,23419,23391,23327,23326,23325,23324,23323,23321,23315,23314,23312,23311,23309,23306,23286,23288,23285,23287,23243,23237,23236,23233,23232,23231,23230,23229,23228,23227,23226,23225,23224,23223,23222,23238,22094,22085,22084,22087,22083,22086,22081,22036,21901,21877,21873,21872,21871,21870,21869,21868,21867,21834,21833,21832,21831,21827,21751,21753,21698,21668,21623,21595,21589,21558,21557,21556,21555,21553,21552,21549,21341,21282,21253,21251,21244,21241,21095,21094,21067,21043,21042,21041,20994,20879,20838,20797,20796,20508,20507,20505,20572,20568,20567,20529,20131,20128,19915,19914,19864,19854,19852,19853,19855,19757,19755,19752,19694,19665,19597,19595,19591,19594,19586,19588,19585,19540,19536,19538,19535,19457,19456,19127,19126,19122,19119,19102,19084,19082,19066,19065,19039,18823,18821,18820,18816,18818,18815,18819,18813,18814,18812,18808,18810,18809,18807,18805,18802,18804,18803,18796,18799,18798,18797,18806,18723,18710,18529,18550,18705,18693,18691,18690,18651,18638,18631,18627,18626,18624,18615,18614,18613,18612,18611,18608,18470,18256,18251,18250,18242,18241,18246,18165,18071,18070,17946,17940,17938,17786,17824,17619,17579,17531,17532,17339,17338,17341,17333,17284,17283,17280,17279,17278,17276,17275,17273,17271,17269,17268,17267,17266,17265,17259,17037,17118,17119,17120,17121,17123,16926,16646,16500,16506,16507,16501,16508,16397,16396,16395,16394,16387,15963,15945,15944,15949,15947,15930,15929,15906,15781,15784,15775,15779,15773,15772,15771,15770,15766,15479,15483,15477,15475,15470,15340,15338,15331,15310,15307,15306,15029,15028,15025,15026,15024,15022,15021,15017,15018,15016,15015,15014,15011,15012,15007,15009,15006,15010,15008,14978,14544,14469,14419,14405,14403,14404,14400,14398,14397,14396,13016,10047,10357,9895,11104,30897,5867,5715,3836,3837,3840,14792,14790,14789,14787,14786,14870,14863,14847,14749,14691,14814,14704,14903,14902,14904,14901,14899,14900,14897,14884)
;
(this query time : 0.017 s)
(total SQL time : 0.036 s)
(total time : 0.054 s)
(num rows : 668 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.004 s)
(total SQL time : 0.040 s)
(total time : 0.459 s)
(num rows : 1 )