[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.003 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D84994c5865d4976d8574ea7a73ebc1a7e53'
;
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.003 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.004 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.006 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.006 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.003 s)
(total time : 0.007 s)
(num rows : 1 )
[8]
SELECT *
FROM g_user_infos
WHERE user_id = 2
;
(this query time : 0.000 s)
(total SQL time : 0.003 s)
(total time : 0.007 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (19357)
(this query time : 0.000 s)
(total SQL time : 0.004 s)
(total time : 0.012 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 (19357)
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.005 s)
(total SQL time : 0.008 s)
(total time : 0.017 s)
(num rows : 308 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 30919
;
(this query time : 0.001 s)
(total SQL time : 0.009 s)
(total time : 0.018 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 = 30919
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.010 s)
(total time : 0.018 s)
(num rows : 1 )
[12]
SELECT *
FROM g_images
WHERE id IN (30919,28796,31448,33439,32965)
;
(this query time : 0.001 s)
(total SQL time : 0.010 s)
(total time : 0.019 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 (30919)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.001 s)
(total SQL time : 0.011 s)
(total time : 0.024 s)
(num rows : 24 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,871,874)
(this query time : 0.000 s)
(total SQL time : 0.011 s)
(total time : 0.025 s)
(num rows : 3 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 30919 AND validated = 'true'
;
(this query time : 0.000 s)
(total SQL time : 0.012 s)
(total time : 0.028 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (31448,31270,31588,31208,30928,31526,31631,29933,30976,29909,28691,31386,31103,31113,31590,30083,31231,31601,31598,31611,28402,30751,31640,31447,31116,30979,30918,26015,30920,29948,31117,31064,30788,31122,31596,31535,31132,31377,31302,29939,28554,29926,27746,31687,31558,28556,31215,30002,29917,31220,30772,31583,31473,30969,28558,31539,31072,31063,31615,30776,31123,31477,31251,31540,31404,30956,31055,28563,31431,29779,31517,31279,31449,31245,28543,28398,30949,30792,31053,31461,30067,31306,30793,30784,31074,31620,31260,31460,31508,31135,30747,31221,28559,31247,31125,30750,30620,31848,27740,31544,28551,31050,30770,30086,31282,31543,28487,31500,31445,31564,31554,31701,32714,31651,31502,31156,30964,28562,30044,28550,31455,30756,31696,31403,31149,29398,31066,31136,31695,30927,28564,31234,31145,28565,28547,27750,26014,28455,31773,30982,31124,31297,31555,31127,32152,31672,31442,31585,30111,31507,32154,31225,31075,27756,31418,30021,31133,31781,31548,30780,31303,27752,31793,31654,31587,31859,31488,27748,31211,30811,30775,27757,31071,31274,31275,31450,31861,29773,31232,28456,30993,32156,27747,31281,31768,27751,30975,31226,31389,31567,31407,30931,31219,31694,27755,31857,31150,31605,31217,31515,31392,28552,31352,32141,31294,32295,31412,30159,31106,31851,32149,30518,27744,30135,28871,31296,31786,32145,28557,31761,30104,31789,28566,32150,30497,31454,31307,28544,30175,31764,31482,27759,32924,32143,32325,30501,31841,31868,32443,32276,31432,28555,32310,27753,32290,28796,30919,33439,30574,32663,33406,31959,31801,31822,31900,33400,27760,32922,32303,32283,33331,32607,32581,32728,33335,33458,32241,33237,33444,33236,32309,33235,33401,32864,32923,33327,32535,32624,33344,33325,33619,33405,33133,32973,32916,33231,33329,32703,32721,33361,32619,33426,33387,33128,33342,33485,33240,33241,33388,33242,32563,32611,32545,32574,33519,33520,32529,32965)
ORDER BY FIELD(id, 31448,31270,31588,31208,30928,31526,31631,29933,30976,29909,28691,31386,31103,31113,31590,30083,31231,31601,31598,31611,28402,30751,31640,31447,31116,30979,30918,26015,30920,29948,31117,31064,30788,31122,31596,31535,31132,31377,31302,29939,28554,29926,27746,31687,31558,28556,31215,30002,29917,31220,30772,31583,31473,30969,28558,31539,31072,31063,31615,30776,31123,31477,31251,31540,31404,30956,31055,28563,31431,29779,31517,31279,31449,31245,28543,28398,30949,30792,31053,31461,30067,31306,30793,30784,31074,31620,31260,31460,31508,31135,30747,31221,28559,31247,31125,30750,30620,31848,27740,31544,28551,31050,30770,30086,31282,31543,28487,31500,31445,31564,31554,31701,32714,31651,31502,31156,30964,28562,30044,28550,31455,30756,31696,31403,31149,29398,31066,31136,31695,30927,28564,31234,31145,28565,28547,27750,26014,28455,31773,30982,31124,31297,31555,31127,32152,31672,31442,31585,30111,31507,32154,31225,31075,27756,31418,30021,31133,31781,31548,30780,31303,27752,31793,31654,31587,31859,31488,27748,31211,30811,30775,27757,31071,31274,31275,31450,31861,29773,31232,28456,30993,32156,27747,31281,31768,27751,30975,31226,31389,31567,31407,30931,31219,31694,27755,31857,31150,31605,31217,31515,31392,28552,31352,32141,31294,32295,31412,30159,31106,31851,32149,30518,27744,30135,28871,31296,31786,32145,28557,31761,30104,31789,28566,32150,30497,31454,31307,28544,30175,31764,31482,27759,32924,32143,32325,30501,31841,31868,32443,32276,31432,28555,32310,27753,32290,28796,30919,33439,30574,32663,33406,31959,31801,31822,31900,33400,27760,32922,32303,32283,33331,32607,32581,32728,33335,33458,32241,33237,33444,33236,32309,33235,33401,32864,32923,33327,32535,32624,33344,33325,33619,33405,33133,32973,32916,33231,33329,32703,32721,33361,32619,33426,33387,33128,33342,33485,33240,33241,33388,33242,32563,32611,32545,32574,33519,33520,32529,32965)
;
(this query time : 0.006 s)
(total SQL time : 0.017 s)
(total time : 0.035 s)
(num rows : 308 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.018 s)
(total time : 0.168 s)
(num rows : 1 )