[1]
SELECT @@SESSION.sql_mode
(this query time : 0.001 s)
(total SQL time : 0.001 s)
(total time : 0.007 s)
(num rows : 1 )
[2]
SELECT param, value
FROM g_config
;
(this query time : 0.002 s)
(total SQL time : 0.004 s)
(total time : 0.011 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.013 s)
(num rows : 1 )
[4]
SELECT * FROM g_plugins
WHERE state='active'
(this query time : 0.001 s)
(total SQL time : 0.006 s)
(total time : 0.015 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.025 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.027 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.002 s)
(total SQL time : 0.011 s)
(total time : 0.029 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.031 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (1966)
(this query time : 0.002 s)
(total SQL time : 0.015 s)
(total time : 0.046 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 (1966)
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 name ASC,date_creation DESC, file ASC, id ASC
(this query time : 0.018 s)
(total SQL time : 0.032 s)
(total time : 0.065 s)
(num rows : 329 )
[10]
SELECT
id, name, permalink, nb_images, global_rank,
date_last, max_date_last, count_images, count_categories
FROM g_categories INNER JOIN g_user_cache_categories
ON id = cat_id and user_id = 2
WHERE
1 = 1
;
(this query time : 0.012 s)
(total SQL time : 0.044 s)
(total time : 0.078 s)
(num rows : 374 )
[11]
SELECT SUBDATE(CURRENT_DATE,INTERVAL 30 DAY)
(this query time : 0.001 s)
(total SQL time : 0.045 s)
(total time : 0.080 s)
(num rows : 1 )
[12]
SELECT
c.id,
c.uppercats,
count(*) AS counter
FROM g_image_category
INNER JOIN g_categories c ON category_id = id
WHERE image_id IN (16143,18705,33504,15506,29036,30431,29617,31110,29616,32973,30072,6994,21319,26281,24881,27379,27378,29615,31594,33446,33487,10959,32139,5428,26040,30578,11559,17250,32555,26401,32968,5879,10588,27383,32082,33186,12871,25958,17248,21394,26817,18105,32558,32557,33663,13450,17252,19422,33448,21823,7055,7054,12928,5426,27382,27461,27387,27386,16129,16142,8552,24882,33445,33185,12822,18760,33674,16121,31019,25712,17251,20206,32442,26400,7912,7261,25848,25459,27462,16119,21397,21822,12711,21396,20822,5877,32438,32136,30752,32554,25993,32897,8551,24033,25945,12592,30585,31020,26431,21393,19046,32556,19499,32532,14457,27200,26012,25995,5525,7994,33065,17249,30073,13941,18759,25263,25262,25261,31612,31377,26039,29444,18761,33147,29437,32553,30577,10958,27199,27385,16660,19579,16145,5878,5084,5081,5082,24341,7995,5718,5717,5716,5715,5880,5427,5425,25992,9308,9307,9310,11557,11563,11562,11569,9306,7000,7003,6999,5291,7001,16131,16130,16128,16127,16126,9894,12869,19237,12872,13324,17499,11558,21098,5429,5083,27384,6935,5062,17663,11854,17011,33044,8050,15510,31473,27389,25655,12710,21487,8550,24932,21386,15988,28710,21388,16125,19060,24931,7098,9305,11565,27202,32135,18701,27307,6998,25951,20887,25957,25999,17302,18503,10780,32439,32443,32440,14081,32441,29879,28734,31611,12819,16847,24343,23590,17016,6996,27381,24342,31109,16144,24729,29442,31022,32138,20188,16538,16537,16536,16535,16542,32531,6997,12873,27922,27923,27206,27201,27022,27023,25713,25714,25715,25716,24880,24345,24344,24132,24133,22093,22094,21745,20743,20538,20204,19739,19425,17018,17020,16841,26265,26266,26267,26269,20821,20820,25997,25953,25952,25950,25949,25948,25946,25947,21320,15509,30575,5424,18704,16140,11564,11566,18302,33069,15511,14456,11560,11561,11567,13956,13957,13954,14021,33063,12818,25996,12821,19238,32534,12708,19728,16139,32970,30576,30430,29922,30432,29443,33444,5524,33447,29439,29618,15508,27395,25847,12820,12870,33664)
AND (category_id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212))
GROUP BY c.id
ORDER BY counter DESC
LIMIT 20
(this query time : 0.088 s)
(total SQL time : 0.133 s)
(total time : 0.177 s)
(num rows : 20 )
[13]
SELECT
id,
name,
permalink,
id_uppercat,
uppercats,
global_rank
FROM g_categories
WHERE id IN (152,262,175,103,270,276,169,568,585,855,856,860,646,653,206,345,753,764,726,743,219,871,877,370,868,880,576,766,839,872,201,883)
;
(this query time : 0.001 s)
(total SQL time : 0.134 s)
(total time : 0.178 s)
(num rows : 32 )
[14]
SELECT *
FROM g_tags
(this query time : 0.023 s)
(total SQL time : 0.157 s)
(total time : 0.202 s)
(num rows : 17957 )
[15]
SELECT t.*, count(*) AS counter
FROM g_image_tag
INNER JOIN g_tags t ON tag_id = id
WHERE image_id IN (16143,18705,33504,15506,29036,30431,29617,31110,29616,32973,30072,6994,21319,26281,24881,27379,27378,29615,31594,33446,33487,10959,32139,5428,26040,30578,11559,17250,32555,26401,32968,5879,10588,27383,32082,33186,12871,25958,17248,21394,26817,18105,32558,32557,33663,13450,17252,19422,33448,21823,7055,7054,12928,5426,27382,27461,27387,27386,16129,16142,8552,24882,33445,33185,12822,18760,33674,16121,31019,25712,17251,20206,32442,26400,7912,7261,25848,25459,27462,16119,21397,21822,12711,21396,20822,5877,32438,32136,30752,32554,25993,32897,8551,24033,25945,12592,30585,31020,26431,21393,19046,32556,19499,32532,14457,27200,26012,25995,5525,7994,33065,17249,30073,13941,18759,25263,25262,25261,31612,31377,26039,29444,18761,33147,29437,32553,30577,10958,27199,27385,16660,19579,16145,5878,5084,5081,5082,24341,7995,5718,5717,5716,5715,5880,5427,5425,25992,9308,9307,9310,11557,11563,11562,11569,9306,7000,7003,6999,5291,7001,16131,16130,16128,16127,16126,9894,12869,19237,12872,13324,17499,11558,21098,5429,5083,27384,6935,5062,17663,11854,17011,33044,8050,15510,31473,27389,25655,12710,21487,8550,24932,21386,15988,28710,21388,16125,19060,24931,7098,9305,11565,27202,32135,18701,27307,6998,25951,20887,25957,25999,17302,18503,10780,32439,32443,32440,14081,32441,29879,28734,31611,12819,16847,24343,23590,17016,6996,27381,24342,31109,16144,24729,29442,31022,32138,20188,16538,16537,16536,16535,16542,32531,6997,12873,27922,27923,27206,27201,27022,27023,25713,25714,25715,25716,24880,24345,24344,24132,24133,22093,22094,21745,20743,20538,20204,19739,19425,17018,17020,16841,26265,26266,26267,26269,20821,20820,25997,25953,25952,25950,25949,25948,25946,25947,21320,15509,30575,5424,18704,16140,11564,11566,18302,33069,15511,14456,11560,11561,11567,13956,13957,13954,14021,33063,12818,25996,12821,19238,32534,12708,19728,16139,32970,30576,30430,29922,30432,29443,33444,5524,33447,29439,29618,15508,27395,25847,12820,12870,33664)
AND tag_id NOT IN (1966)
GROUP BY t.id
ORDER BY counter DESC
LIMIT 3
(this query time : 0.042 s)
(total SQL time : 0.199 s)
(total time : 0.333 s)
(num rows : 3 )
[16]
SELECT *
FROM g_images
WHERE id IN (26265,26266,26267,26269,20821,20820,25997,25953,25952,25950,25949,25948,25946,25947,21320,15509,30575,5424,18704,16140,11564,11566,18302,33069,15511,14456,11560,11561,11567,13956,13957,13954,14021,33063,12818,25996,12821,19238,32534,12708,19728,16139,32970,30576,30430)
;
(this query time : 0.001 s)
(total SQL time : 0.200 s)
(total time : 0.335 s)
(num rows : 45 )
[0.340 s, 16 queries] : end include/category_default.inc.php
[17]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (16143,18705,33504,15506,29036,30431,29617,31110,29616,32973,30072,6994,21319,26281,24881,27379,27378,29615,31594,33446,33487,10959,32139,5428,26040,30578,11559,17250,32555,26401,32968,5879,10588,27383,32082,33186,12871,25958,17248,21394,26817,18105,32558,32557,33663,13450,17252,19422,33448,21823,7055,7054,12928,5426,27382,27461,27387,27386,16129,16142,8552,24882,33445,33185,12822,18760,33674,16121,31019,25712,17251,20206,32442,26400,7912,7261,25848,25459,27462,16119,21397,21822,12711,21396,20822,5877,32438,32136,30752,32554,25993,32897,8551,24033,25945,12592,30585,31020,26431,21393,19046,32556,19499,32532,14457,27200,26012,25995,5525,7994,33065,17249,30073,13941,18759,25263,25262,25261,31612,31377,26039,29444,18761,33147,29437,32553,30577,10958,27199,27385,16660,19579,16145,5878,5084,5081,5082,24341,7995,5718,5717,5716,5715,5880,5427,5425,25992,9308,9307,9310,11557,11563,11562,11569,9306,7000,7003,6999,5291,7001,16131,16130,16128,16127,16126,9894,12869,19237,12872,13324,17499,11558,21098,5429,5083,27384,6935,5062,17663,11854,17011,33044,8050,15510,31473,27389,25655,12710,21487,8550,24932,21386,15988,28710,21388,16125,19060,24931,7098,9305,11565,27202,32135,18701,27307,6998,25951,20887,25957,25999,17302,18503,10780,32439,32443,32440,14081,32441,29879,28734,31611,12819,16847,24343,23590,17016,6996,27381,24342,31109,16144,24729,29442,31022,32138,20188,16538,16537,16536,16535,16542,32531,6997,12873,27922,27923,27206,27201,27022,27023,25713,25714,25715,25716,24880,24345,24344,24132,24133,22093,22094,21745,20743,20538,20204,19739,19425,17018,17020,16841,26265,26266,26267,26269,20821,20820,25997,25953,25952,25950,25949,25948,25946,25947,21320,15509,30575,5424,18704,16140,11564,11566,18302,33069,15511,14456,11560,11561,11567,13956,13957,13954,14021,33063,12818,25996,12821,19238,32534,12708,19728,16139,32970,30576,30430,29922,30432,29443,33444,5524,33447,29439,29618,15508,27395,25847,12820,12870,33664)
ORDER BY FIELD(id, 16143,18705,33504,15506,29036,30431,29617,31110,29616,32973,30072,6994,21319,26281,24881,27379,27378,29615,31594,33446,33487,10959,32139,5428,26040,30578,11559,17250,32555,26401,32968,5879,10588,27383,32082,33186,12871,25958,17248,21394,26817,18105,32558,32557,33663,13450,17252,19422,33448,21823,7055,7054,12928,5426,27382,27461,27387,27386,16129,16142,8552,24882,33445,33185,12822,18760,33674,16121,31019,25712,17251,20206,32442,26400,7912,7261,25848,25459,27462,16119,21397,21822,12711,21396,20822,5877,32438,32136,30752,32554,25993,32897,8551,24033,25945,12592,30585,31020,26431,21393,19046,32556,19499,32532,14457,27200,26012,25995,5525,7994,33065,17249,30073,13941,18759,25263,25262,25261,31612,31377,26039,29444,18761,33147,29437,32553,30577,10958,27199,27385,16660,19579,16145,5878,5084,5081,5082,24341,7995,5718,5717,5716,5715,5880,5427,5425,25992,9308,9307,9310,11557,11563,11562,11569,9306,7000,7003,6999,5291,7001,16131,16130,16128,16127,16126,9894,12869,19237,12872,13324,17499,11558,21098,5429,5083,27384,6935,5062,17663,11854,17011,33044,8050,15510,31473,27389,25655,12710,21487,8550,24932,21386,15988,28710,21388,16125,19060,24931,7098,9305,11565,27202,32135,18701,27307,6998,25951,20887,25957,25999,17302,18503,10780,32439,32443,32440,14081,32441,29879,28734,31611,12819,16847,24343,23590,17016,6996,27381,24342,31109,16144,24729,29442,31022,32138,20188,16538,16537,16536,16535,16542,32531,6997,12873,27922,27923,27206,27201,27022,27023,25713,25714,25715,25716,24880,24345,24344,24132,24133,22093,22094,21745,20743,20538,20204,19739,19425,17018,17020,16841,26265,26266,26267,26269,20821,20820,25997,25953,25952,25950,25949,25948,25946,25947,21320,15509,30575,5424,18704,16140,11564,11566,18302,33069,15511,14456,11560,11561,11567,13956,13957,13954,14021,33063,12818,25996,12821,19238,32534,12708,19728,16139,32970,30576,30430,29922,30432,29443,33444,5524,33447,29439,29618,15508,27395,25847,12820,12870,33664)
;
(this query time : 0.005 s)
(total SQL time : 0.205 s)
(total time : 0.345 s)
(num rows : 329 )
[18]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.205 s)
(total time : 0.443 s)
(num rows : 1 )