[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 = 'D8497ec09a2a5c5e26df3f968172458ceef9' ; (this query time : 0.000 s) (total SQL time : 0.001 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.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.000 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 )
[0.011 s, 8 queries] : start initialize_calendar
[9]
SELECT DISTINCT id FROM g_images
INNER JOIN g_image_category ON id = image_id
WHERE (category_id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212) AND level<=0)
AND WEEK(date_creation, 5)+1=1
ORDER BY date_creation DESC, date_creation DESC, file ASC, id ASC
(this query time : 0.011 s)
(total SQL time : 0.014 s)
(total time : 0.022 s)
(num rows : 238 )
[0.022 s, 9 queries] : end initialize_calendar
[10] UPDATE g_images SET hit = hit+1, lastmodified = lastmodified WHERE id = 17439 ; (this query time : 0.000 s) (total SQL time : 0.015 s) (total time : 0.023 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 = 17439
AND (id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212))
;
(this query time : 0.000 s)
(total SQL time : 0.015 s)
(total time : 0.024 s)
(num rows : 2 )
[12] SELECT * FROM g_images WHERE id IN (17439,17440,33705,17436,4825) ; (this query time : 0.000 s) (total SQL time : 0.016 s) (total time : 0.024 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 (17439)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.000 s)
(total SQL time : 0.016 s)
(total time : 0.028 s)
(num rows : 8 )
[14] SELECT id, name, permalink FROM g_categories WHERE id IN (585,586,587,152,169,577) (this query time : 0.000 s) (total SQL time : 0.017 s) (total time : 0.029 s) (num rows : 6 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 17439 AND validated = 'true'
;
(this query time : 0.000 s)
(total SQL time : 0.017 s)
(total time : 0.031 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (33705,33703,33702,33700,33699,33704,33701,33698,33697,33696,33695,33694,33693,33692,33691,33690,33689,33688,33687,33684,33686,33683,33685,33682,30440,30441,30442,30443,30444,30445,30446,31013,31014,30405,30447,30448,30449,30450,30452,30451,30453,30454,30455,30457,30412,30456,30406,30407,29745,29744,29743,29742,30409,30408,29741,29740,29739,29738,29737,29736,29735,29734,29733,29732,29731,29730,29729,29728,29727,29725,29726,29724,29723,30410,29721,29722,29720,30411,30398,21333,21332,21331,21330,21329,21326,21325,21327,21328,17440,17439,17436,17438,17437,17435,17432,17431,17434,17430,17433,17429,17426,17427,17425,17422,17423,17421,17428,17424,17420,17419,17418,17417,17412,17414,17413,17409,17411,17410,17415,17416,14510,14508,14509,14507,14506,14505,14504,14503,14502,14501,14500,14499,14498,14497,14496,14494,14495,14492,14493,14490,14491,14489,14488,14487,14486,14485,14484,14483,14482,14481,14479,14480,12581,12578,12577,12576,12575,12574,12573,12571,12572,12569,12570,12519,12518,12517,12516,12515,12514,12513,12512,12511,12510,12509,12508,12507,12505,12506,12504,12503,12502,12500,12596,12632,12631,12629,12630,7710,7709,7711,7712,7713,7714,7715,7716,7717,7718,7708,7608,7602,7601,7598,7600,7599,7595,7597,7596,4758,4759,4756,4757,4754,4755,4752,4753,4751,4105,4006,4007,4008,4009,4010,4011,4012,4013,4014,4015,4016,4017,4019,4018,4021,4020,4022,4023,4024,4557,4825)
ORDER BY FIELD(id, 33705,33703,33702,33700,33699,33704,33701,33698,33697,33696,33695,33694,33693,33692,33691,33690,33689,33688,33687,33684,33686,33683,33685,33682,30440,30441,30442,30443,30444,30445,30446,31013,31014,30405,30447,30448,30449,30450,30452,30451,30453,30454,30455,30457,30412,30456,30406,30407,29745,29744,29743,29742,30409,30408,29741,29740,29739,29738,29737,29736,29735,29734,29733,29732,29731,29730,29729,29728,29727,29725,29726,29724,29723,30410,29721,29722,29720,30411,30398,21333,21332,21331,21330,21329,21326,21325,21327,21328,17440,17439,17436,17438,17437,17435,17432,17431,17434,17430,17433,17429,17426,17427,17425,17422,17423,17421,17428,17424,17420,17419,17418,17417,17412,17414,17413,17409,17411,17410,17415,17416,14510,14508,14509,14507,14506,14505,14504,14503,14502,14501,14500,14499,14498,14497,14496,14494,14495,14492,14493,14490,14491,14489,14488,14487,14486,14485,14484,14483,14482,14481,14479,14480,12581,12578,12577,12576,12575,12574,12573,12571,12572,12569,12570,12519,12518,12517,12516,12515,12514,12513,12512,12511,12510,12509,12508,12507,12505,12506,12504,12503,12502,12500,12596,12632,12631,12629,12630,7710,7709,7711,7712,7713,7714,7715,7716,7717,7718,7708,7608,7602,7601,7598,7600,7599,7595,7597,7596,4758,4759,4756,4757,4754,4755,4752,4753,4751,4105,4006,4007,4008,4009,4010,4011,4012,4013,4014,4015,4016,4017,4019,4018,4021,4020,4022,4023,4024,4557,4825)
;
(this query time : 0.004 s)
(total SQL time : 0.020 s)
(total time : 0.036 s)
(num rows : 238 )
[17] SELECT param, value FROM g_config WHERE param = "send_piwigo_infos_last_notice" ; (this query time : 0.001 s) (total SQL time : 0.021 s) (total time : 0.130 s) (num rows : 1 )