[1] SELECT @@SESSION.sql_mode (this query time : 0.001 s) (total SQL time : 0.001 s) (total time : 0.004 s) (num rows : 1 )
[2] SELECT param, value FROM g_config ; (this query time : 0.002 s) (total SQL time : 0.002 s) (total time : 0.006 s) (num rows : 126 )
[3] SELECT data FROM g_sessions WHERE id = 'D849a97bafcf03221468eadc0fc982cf6f0f' ; (this query time : 0.001 s) (total SQL time : 0.003 s) (total time : 0.007 s) (num rows : 1 )
[4] SELECT * FROM g_plugins WHERE state='active' (this query time : 0.001 s) (total SQL time : 0.004 s) (total time : 0.008 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.005 s)
(total time : 0.012 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.015 s) (num rows : 1 )
[0.022 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=44
ORDER BY date_creation DESC, date_creation DESC, file ASC, id ASC
(this query time : 0.025 s)
(total SQL time : 0.032 s)
(total time : 0.047 s)
(num rows : 495 )
[0.047 s, 9 queries] : end initialize_calendar
[10] UPDATE g_images SET hit = hit+1, lastmodified = lastmodified WHERE id = 17469 ; (this query time : 0.001 s) (total SQL time : 0.033 s) (total time : 0.048 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 = 17469
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.034 s)
(total time : 0.050 s)
(num rows : 3 )
[12] SELECT * FROM g_images WHERE id IN (17469,17472,33475,17465,7614) ; (this query time : 0.001 s) (total SQL time : 0.035 s) (total time : 0.051 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 (17469)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.001 s)
(total SQL time : 0.036 s)
(total time : 0.060 s)
(num rows : 8 )
[14] SELECT id, name, permalink FROM g_categories WHERE id IN (585,646,656,152,169,576,100,101,256,327) (this query time : 0.001 s) (total SQL time : 0.037 s) (total time : 0.061 s) (num rows : 10 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 17469 AND validated = 'true'
;
(this query time : 0.001 s)
(total SQL time : 0.038 s)
(total time : 0.065 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (33475,33474,33473,33681,33472,33471,33469,33585,33468,33470,33467,33466,33374,33375,33376,33377,33378,33379,33380,33381,33382,33383,33384,33385,33386,33387,33388,33389,33390,33391,33392,33393,33394,33395,33396,33397,33398,30367,29657,29658,29660,29659,29661,29662,29663,29664,29665,29666,29667,29668,29669,29670,29671,29672,29673,29675,29643,29676,29674,29677,29678,30368,29260,30369,29606,29607,29608,29609,29610,29611,29613,29614,29612,29615,29617,29616,29618,29619,29620,29261,29262,29621,29622,29623,29624,29625,29626,29627,29628,29629,29630,29631,29632,29635,29633,29634,29636,29639,29637,29642,29605,29640,29263,30370,29264,29641,29638,29265,30371,29266,30372,30373,29267,29540,29541,29542,29543,29544,29545,29546,29547,29548,29549,29550,29551,29552,29553,29554,29555,29556,29557,29558,29559,25278,25277,25276,25275,25274,25273,25272,25271,25270,25269,25268,25267,25266,25265,25264,25263,25262,25261,25260,25259,25258,25257,25256,25255,25254,25253,25252,25251,25250,25246,25249,25248,25247,25245,25324,25244,25243,25242,25241,25240,25239,25238,25237,25236,25235,25323,25234,25233,25232,25231,25230,25229,25228,25227,25226,25225,25224,25223,25222,25221,25220,25219,25218,25217,25216,25215,25214,25212,25213,25211,25210,25209,25208,25206,25207,25322,20994,20993,20992,20991,20990,20989,20988,20987,20986,20985,20984,20983,20982,20981,20980,20979,20978,20977,20976,20975,20974,20973,20972,20971,20970,20969,20968,20967,20966,20965,20964,20963,20962,20960,20958,20961,20959,20957,20956,20955,20954,20953,20952,20951,20950,20949,20948,20947,17520,17519,17518,17517,17363,17516,17513,17511,17514,17512,17508,17507,17515,17510,17504,17505,17509,17506,17501,17503,17499,17502,17496,17500,17498,17497,17495,17492,17491,17490,17494,17493,17489,17488,17487,17486,17482,17481,17484,17480,17485,17479,17478,17483,17476,17477,17475,17473,17474,17470,17467,17468,17471,17472,17469,17465,17466,14124,14123,14125,14122,14121,14120,14119,14117,14116,14118,14115,14114,14113,14112,14111,14109,14110,14107,14108,14106,14105,13992,13993,13994,13995,13996,13997,13998,14000,13999,14001,14002,11546,11545,11547,11548,11549,11550,11551,11553,11552,11554,11555,11556,11558,11557,11559,11560,11561,11563,11562,11564,11565,11566,11567,11569,11570,11568,11571,11573,11572,11544,11543,11524,11525,11538,11526,11539,11527,11528,11529,11530,11531,11532,11542,11533,11535,11534,11536,11541,11537,11540,11520,11522,11521,11420,11421,11422,11424,11423,11513,11514,11425,11426,11427,11428,11429,11430,11432,11498,11431,11433,11435,11515,11436,11437,11434,11439,11438,11440,11441,11442,11443,11444,11445,6828,6830,6829,6832,6831,6611,6610,6612,6614,6613,6616,6615,6607,6609,6608,10462,10463,10464,10465,10466,10932,10933,10934,10936,10935,10937,10938,10940,10939,10942,10943,10944,10945,10946,10947,10948,10949,10950,10951,10952,10931,10930,10953,10954,10929,10955,30873,4773,30870,30869,30867,30868,5326,30677,7665,7618,7619,7620,7621,4808,7610,7611,7612,3558,7613,7614)
ORDER BY FIELD(id, 33475,33474,33473,33681,33472,33471,33469,33585,33468,33470,33467,33466,33374,33375,33376,33377,33378,33379,33380,33381,33382,33383,33384,33385,33386,33387,33388,33389,33390,33391,33392,33393,33394,33395,33396,33397,33398,30367,29657,29658,29660,29659,29661,29662,29663,29664,29665,29666,29667,29668,29669,29670,29671,29672,29673,29675,29643,29676,29674,29677,29678,30368,29260,30369,29606,29607,29608,29609,29610,29611,29613,29614,29612,29615,29617,29616,29618,29619,29620,29261,29262,29621,29622,29623,29624,29625,29626,29627,29628,29629,29630,29631,29632,29635,29633,29634,29636,29639,29637,29642,29605,29640,29263,30370,29264,29641,29638,29265,30371,29266,30372,30373,29267,29540,29541,29542,29543,29544,29545,29546,29547,29548,29549,29550,29551,29552,29553,29554,29555,29556,29557,29558,29559,25278,25277,25276,25275,25274,25273,25272,25271,25270,25269,25268,25267,25266,25265,25264,25263,25262,25261,25260,25259,25258,25257,25256,25255,25254,25253,25252,25251,25250,25246,25249,25248,25247,25245,25324,25244,25243,25242,25241,25240,25239,25238,25237,25236,25235,25323,25234,25233,25232,25231,25230,25229,25228,25227,25226,25225,25224,25223,25222,25221,25220,25219,25218,25217,25216,25215,25214,25212,25213,25211,25210,25209,25208,25206,25207,25322,20994,20993,20992,20991,20990,20989,20988,20987,20986,20985,20984,20983,20982,20981,20980,20979,20978,20977,20976,20975,20974,20973,20972,20971,20970,20969,20968,20967,20966,20965,20964,20963,20962,20960,20958,20961,20959,20957,20956,20955,20954,20953,20952,20951,20950,20949,20948,20947,17520,17519,17518,17517,17363,17516,17513,17511,17514,17512,17508,17507,17515,17510,17504,17505,17509,17506,17501,17503,17499,17502,17496,17500,17498,17497,17495,17492,17491,17490,17494,17493,17489,17488,17487,17486,17482,17481,17484,17480,17485,17479,17478,17483,17476,17477,17475,17473,17474,17470,17467,17468,17471,17472,17469,17465,17466,14124,14123,14125,14122,14121,14120,14119,14117,14116,14118,14115,14114,14113,14112,14111,14109,14110,14107,14108,14106,14105,13992,13993,13994,13995,13996,13997,13998,14000,13999,14001,14002,11546,11545,11547,11548,11549,11550,11551,11553,11552,11554,11555,11556,11558,11557,11559,11560,11561,11563,11562,11564,11565,11566,11567,11569,11570,11568,11571,11573,11572,11544,11543,11524,11525,11538,11526,11539,11527,11528,11529,11530,11531,11532,11542,11533,11535,11534,11536,11541,11537,11540,11520,11522,11521,11420,11421,11422,11424,11423,11513,11514,11425,11426,11427,11428,11429,11430,11432,11498,11431,11433,11435,11515,11436,11437,11434,11439,11438,11440,11441,11442,11443,11444,11445,6828,6830,6829,6832,6831,6611,6610,6612,6614,6613,6616,6615,6607,6609,6608,10462,10463,10464,10465,10466,10932,10933,10934,10936,10935,10937,10938,10940,10939,10942,10943,10944,10945,10946,10947,10948,10949,10950,10951,10952,10931,10930,10953,10954,10929,10955,30873,4773,30870,30869,30867,30868,5326,30677,7665,7618,7619,7620,7621,4808,7610,7611,7612,3558,7613,7614)
;
(this query time : 0.014 s)
(total SQL time : 0.052 s)
(total time : 0.082 s)
(num rows : 495 )
[17] SELECT param, value FROM g_config WHERE param = "send_piwigo_infos_last_notice" ; (this query time : 0.001 s) (total SQL time : 0.053 s) (total time : 0.297 s) (num rows : 1 )