[1]
SELECT @@SESSION.sql_mode
(this query time : 0.001 s)
(total SQL time : 0.001 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.002 s)
(total time : 0.005 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D84994c5865d4976d8574ea7a73ebc1a7e53'
;
(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.001 s)
(total SQL time : 0.003 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.001 s)
(total SQL time : 0.004 s)
(total time : 0.013 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.013 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.014 s)
(num rows : 1 )
[8]
SELECT *
FROM g_user_infos
WHERE user_id = 2
;
(this query time : 0.001 s)
(total SQL time : 0.007 s)
(total time : 0.016 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (20448)
(this query time : 0.001 s)
(total SQL time : 0.007 s)
(total time : 0.023 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 (20448)
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 hit DESC,date_creation DESC, file ASC, id ASC
(this query time : 0.010 s)
(total SQL time : 0.017 s)
(total time : 0.033 s)
(num rows : 377 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 29706
;
(this query time : 0.001 s)
(total SQL time : 0.018 s)
(total time : 0.034 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 = 29706
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.019 s)
(total time : 0.035 s)
(num rows : 2 )
[12]
SELECT *
FROM g_images
WHERE id IN (29706,29483,29914,29389,33428)
;
(this query time : 0.001 s)
(total SQL time : 0.020 s)
(total time : 0.037 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 (29706)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.002 s)
(total SQL time : 0.021 s)
(total time : 0.047 s)
(num rows : 31 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,855,868,152,262,183)
(this query time : 0.001 s)
(total SQL time : 0.022 s)
(total time : 0.048 s)
(num rows : 6 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 29706 AND validated = 'true'
;
(this query time : 0.001 s)
(total SQL time : 0.023 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 (29914,28537,30080,28749,28691,28764,31679,28768,31242,29901,30144,30773,30431,30156,28736,31244,30595,28765,29667,28712,29832,28717,31007,30113,31086,29939,30142,29397,29304,31121,30005,31675,28880,31009,30163,29422,29992,28520,28684,29954,31477,30901,29963,30025,31472,30009,31512,29311,30591,29936,30087,28734,29953,28762,28524,28868,30097,29902,29878,29488,28698,28725,28899,29217,30166,28742,29652,30185,28910,30165,29559,30578,30147,28771,30449,30779,29756,28799,29087,31223,28804,30186,31403,31422,30860,28728,29440,29611,28802,30453,30085,30412,28754,31234,28797,30863,29999,28785,28738,29730,28915,30158,28788,29848,30192,29375,28902,29290,30450,28790,31656,30498,31642,31418,30180,30138,31424,28781,29165,28732,31548,29809,28747,29479,28451,28815,30046,30511,28766,28737,30034,30452,31248,29492,31163,28867,30010,31732,30178,30188,30060,29365,31274,28450,29761,30422,31232,29200,29386,28456,29423,28729,30109,29584,31603,30006,32135,28457,29723,28731,29578,31299,28878,29363,28683,28682,29418,29558,29125,29452,31365,30194,31771,28870,29947,30103,29957,30106,29483,29706,29389,29912,30509,28875,29383,30172,29487,31618,29122,28429,31478,28666,29004,29502,32136,31353,30141,30748,28890,30159,28869,30413,28763,30161,30157,32151,31372,29877,28767,28523,32134,29473,29564,32389,30201,31436,28431,30134,28774,30503,29065,29700,32160,30102,30104,29663,30998,29392,30162,30497,30991,31739,29137,28757,29896,31509,28517,29930,28686,29291,29300,29183,32405,29946,29838,28778,31747,29850,29895,31580,29705,31757,31437,30081,31816,29381,29167,29603,29063,29959,29294,30596,30108,28744,29037,29899,28783,29204,32161,29803,29138,30146,29821,32413,32276,29042,30114,32269,30414,31228,28990,32113,29359,31143,29067,28411,28748,28759,31276,32199,29387,30524,29499,29794,29524,28760,28779,29685,28775,31811,29636,28983,31752,29174,31668,28992,32531,29201,29069,29839,29586,28776,32109,29152,31871,32245,29515,32082,29008,30721,28951,31081,32184,29504,32496,31011,29329,31864,29323,31235,31754,29595,32108,32429,32197,29369,32494,32225,32231,32852,32508,32107,32235,32104,32247,32289,30471,32804,32100,32148,32202,32513,32291,29144,29141,32192,31885,32504,33690,32503,32867,32329,33689,32385,32955,32920,32506,33423,32921,32858,32948,32857,33684,32537,32849,32876,33428)
ORDER BY FIELD(id, 29914,28537,30080,28749,28691,28764,31679,28768,31242,29901,30144,30773,30431,30156,28736,31244,30595,28765,29667,28712,29832,28717,31007,30113,31086,29939,30142,29397,29304,31121,30005,31675,28880,31009,30163,29422,29992,28520,28684,29954,31477,30901,29963,30025,31472,30009,31512,29311,30591,29936,30087,28734,29953,28762,28524,28868,30097,29902,29878,29488,28698,28725,28899,29217,30166,28742,29652,30185,28910,30165,29559,30578,30147,28771,30449,30779,29756,28799,29087,31223,28804,30186,31403,31422,30860,28728,29440,29611,28802,30453,30085,30412,28754,31234,28797,30863,29999,28785,28738,29730,28915,30158,28788,29848,30192,29375,28902,29290,30450,28790,31656,30498,31642,31418,30180,30138,31424,28781,29165,28732,31548,29809,28747,29479,28451,28815,30046,30511,28766,28737,30034,30452,31248,29492,31163,28867,30010,31732,30178,30188,30060,29365,31274,28450,29761,30422,31232,29200,29386,28456,29423,28729,30109,29584,31603,30006,32135,28457,29723,28731,29578,31299,28878,29363,28683,28682,29418,29558,29125,29452,31365,30194,31771,28870,29947,30103,29957,30106,29483,29706,29389,29912,30509,28875,29383,30172,29487,31618,29122,28429,31478,28666,29004,29502,32136,31353,30141,30748,28890,30159,28869,30413,28763,30161,30157,32151,31372,29877,28767,28523,32134,29473,29564,32389,30201,31436,28431,30134,28774,30503,29065,29700,32160,30102,30104,29663,30998,29392,30162,30497,30991,31739,29137,28757,29896,31509,28517,29930,28686,29291,29300,29183,32405,29946,29838,28778,31747,29850,29895,31580,29705,31757,31437,30081,31816,29381,29167,29603,29063,29959,29294,30596,30108,28744,29037,29899,28783,29204,32161,29803,29138,30146,29821,32413,32276,29042,30114,32269,30414,31228,28990,32113,29359,31143,29067,28411,28748,28759,31276,32199,29387,30524,29499,29794,29524,28760,28779,29685,28775,31811,29636,28983,31752,29174,31668,28992,32531,29201,29069,29839,29586,28776,32109,29152,31871,32245,29515,32082,29008,30721,28951,31081,32184,29504,32496,31011,29329,31864,29323,31235,31754,29595,32108,32429,32197,29369,32494,32225,32231,32852,32508,32107,32235,32104,32247,32289,30471,32804,32100,32148,32202,32513,32291,29144,29141,32192,31885,32504,33690,32503,32867,32329,33689,32385,32955,32920,32506,33423,32921,32858,32948,32857,33684,32537,32849,32876,33428)
;
(this query time : 0.013 s)
(total SQL time : 0.036 s)
(total time : 0.069 s)
(num rows : 377 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.036 s)
(total time : 0.248 s)
(num rows : 1 )