[1]
SELECT @@SESSION.sql_mode
(this query time : 0.000 s)
(total SQL time : 0.000 s)
(total time : 0.002 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.004 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D84994c5865d4976d8574ea7a73ebc1a7e53'
;
(this query time : 0.000 s)
(total SQL time : 0.002 s)
(total time : 0.004 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.005 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.008 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.008 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.009 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.009 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (1472,1536)
(this query time : 0.001 s)
(total SQL time : 0.005 s)
(total time : 0.014 s)
(num rows : 2 )
[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 (1472,1536)
AND (category_id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212) AND level<=0)
GROUP BY id
HAVING COUNT(DISTINCT tag_id)=2
ORDER BY hit DESC,date_creation DESC, file ASC, id ASC
(this query time : 0.032 s)
(total SQL time : 0.036 s)
(total time : 0.047 s)
(num rows : 326 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 33015
;
(this query time : 0.001 s)
(total SQL time : 0.037 s)
(total time : 0.047 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 = 33015
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.038 s)
(total time : 0.048 s)
(num rows : 2 )
[12]
SELECT *
FROM g_images
WHERE id IN (33015,33281,6040,32895,33007)
;
(this query time : 0.001 s)
(total SQL time : 0.038 s)
(total time : 0.049 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 (33015)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.001 s)
(total SQL time : 0.039 s)
(total time : 0.055 s)
(num rows : 18 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,871,883,140)
(this query time : 0.001 s)
(total SQL time : 0.040 s)
(total time : 0.055 s)
(num rows : 4 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 33015 AND validated = 'true'
;
(this query time : 0.001 s)
(total SQL time : 0.040 s)
(total time : 0.059 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (6040,29914,31229,31475,31600,30627,30820,30576,31679,31590,30597,31601,30577,31059,31678,31126,30979,31244,31570,31122,31398,31277,30916,30988,31613,31396,31687,30795,29917,31047,29927,31675,30914,31571,30017,30247,30584,30089,30969,31629,31569,31063,31646,31615,30910,31477,31622,31597,31404,30956,30575,31686,30251,30821,31245,30806,31735,30250,31306,31620,30626,31508,31621,31673,31756,30809,30004,30606,30620,30425,31400,31671,30983,30946,30185,31677,31689,30962,31680,31683,29928,30474,31716,30609,31561,29409,30974,31151,29935,31820,31589,31234,32382,30640,30968,30953,30982,31602,31647,28093,29547,31555,31402,31250,30494,29916,31783,31507,29625,31697,27756,30021,31563,30180,30947,31781,30467,30016,30539,31578,31674,31793,30637,31587,31506,30800,31261,31441,32344,29492,30929,27757,29373,31275,30422,31967,31433,31682,29200,30993,31703,31603,30458,29582,30195,29920,31112,31281,31575,31768,30958,29467,31407,31586,30602,31694,29378,30583,31254,31669,31605,31043,29539,31659,30174,31499,31412,31106,29338,31698,31045,30424,31792,31897,32453,29564,31406,31786,29038,31044,31268,32457,31700,30418,31278,29924,31617,31702,30634,31945,31667,31419,31040,30436,31385,31580,31239,30200,30596,30635,31970,30423,30475,32276,31778,28981,29012,31889,30641,30249,31937,29546,31606,31892,33362,30676,32290,30642,31894,31883,31893,29427,31891,33439,33406,32184,32449,31947,29594,32461,27738,31905,32517,32454,31916,31416,31949,31901,31946,33579,32456,31957,32993,28985,33469,31962,33474,31896,31961,33440,31895,33446,33042,32581,32726,32782,33098,32744,32504,31884,33201,33334,32755,32749,32670,33382,33228,33328,32861,33069,33563,33506,33227,33405,32860,33561,33363,32562,33586,33543,33123,33011,33475,33361,33368,32747,33374,33281,33015,32895,33056,33473,33392,33481,33380,33566,33340,32680,33429,33544,33541,33555,32754,32775,33537,33064,33536,32781,33246,33090,33225,33428,33289,32816,33014,33416,33194,33220,33141,32753,33131,33607,32756,33219,32843,33007)
ORDER BY FIELD(id, 6040,29914,31229,31475,31600,30627,30820,30576,31679,31590,30597,31601,30577,31059,31678,31126,30979,31244,31570,31122,31398,31277,30916,30988,31613,31396,31687,30795,29917,31047,29927,31675,30914,31571,30017,30247,30584,30089,30969,31629,31569,31063,31646,31615,30910,31477,31622,31597,31404,30956,30575,31686,30251,30821,31245,30806,31735,30250,31306,31620,30626,31508,31621,31673,31756,30809,30004,30606,30620,30425,31400,31671,30983,30946,30185,31677,31689,30962,31680,31683,29928,30474,31716,30609,31561,29409,30974,31151,29935,31820,31589,31234,32382,30640,30968,30953,30982,31602,31647,28093,29547,31555,31402,31250,30494,29916,31783,31507,29625,31697,27756,30021,31563,30180,30947,31781,30467,30016,30539,31578,31674,31793,30637,31587,31506,30800,31261,31441,32344,29492,30929,27757,29373,31275,30422,31967,31433,31682,29200,30993,31703,31603,30458,29582,30195,29920,31112,31281,31575,31768,30958,29467,31407,31586,30602,31694,29378,30583,31254,31669,31605,31043,29539,31659,30174,31499,31412,31106,29338,31698,31045,30424,31792,31897,32453,29564,31406,31786,29038,31044,31268,32457,31700,30418,31278,29924,31617,31702,30634,31945,31667,31419,31040,30436,31385,31580,31239,30200,30596,30635,31970,30423,30475,32276,31778,28981,29012,31889,30641,30249,31937,29546,31606,31892,33362,30676,32290,30642,31894,31883,31893,29427,31891,33439,33406,32184,32449,31947,29594,32461,27738,31905,32517,32454,31916,31416,31949,31901,31946,33579,32456,31957,32993,28985,33469,31962,33474,31896,31961,33440,31895,33446,33042,32581,32726,32782,33098,32744,32504,31884,33201,33334,32755,32749,32670,33382,33228,33328,32861,33069,33563,33506,33227,33405,32860,33561,33363,32562,33586,33543,33123,33011,33475,33361,33368,32747,33374,33281,33015,32895,33056,33473,33392,33481,33380,33566,33340,32680,33429,33544,33541,33555,32754,32775,33537,33064,33536,32781,33246,33090,33225,33428,33289,32816,33014,33416,33194,33220,33141,32753,33131,33607,32756,33219,32843,33007)
;
(this query time : 0.006 s)
(total SQL time : 0.047 s)
(total time : 0.067 s)
(num rows : 326 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.047 s)
(total time : 0.210 s)
(num rows : 1 )