[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.000 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.000 s)
(total SQL time : 0.002 s)
(total time : 0.006 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.010 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=26
ORDER BY hit DESC,date_creation DESC, file ASC, id ASC
(this query time : 0.011 s)
(total SQL time : 0.014 s)
(total time : 0.021 s)
(num rows : 737 )
[0.021 s, 9 queries] : end initialize_calendar
[10] UPDATE g_images SET hit = hit+1, lastmodified = lastmodified WHERE id = 12413 ; (this query time : 0.001 s) (total SQL time : 0.015 s) (total time : 0.022 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 = 12413
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.022 s)
(num rows : 2 )
[12] SELECT * FROM g_images WHERE id IN (12413,6712,5216,12410,32642) ; (this query time : 0.000 s) (total SQL time : 0.016 s) (total time : 0.023 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 (12413)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.001 s)
(total SQL time : 0.016 s)
(total time : 0.027 s)
(num rows : 8 )
[14] SELECT id, name, permalink FROM g_categories WHERE id IN (152,169,208,367,368) (this query time : 0.001 s) (total SQL time : 0.017 s) (total time : 0.027 s) (num rows : 5 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 12413 AND validated = 'true'
;
(this query time : 0.001 s)
(total SQL time : 0.017 s)
(total time : 0.030 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (5216,5217,9067,13425,9070,23815,9073,9069,9068,9072,9071,9229,6707,5194,5208,9089,5195,5193,9045,9088,15899,9091,9246,5196,9092,5214,9237,23814,9083,9243,9236,9090,9084,9087,9233,9096,9081,5197,5198,9082,4473,5222,9066,5205,5215,9049,5223,9086,9095,9101,9085,9231,9080,9238,5219,9226,9235,9112,9244,9100,9098,9239,9035,5224,9240,13455,9097,9104,9234,9106,9059,9109,9050,23816,9099,9058,9079,9046,5189,9242,5220,4468,4488,13450,9102,9241,6708,4472,9105,9103,9107,9245,9230,9228,9108,4495,9093,9111,9114,9232,9061,9227,9094,9113,5225,9110,5182,4457,5221,13435,6728,5187,4486,15895,4485,4462,13446,4489,4477,4492,4471,9048,13432,5202,9074,4467,4490,4466,9075,4401,9047,13428,13451,4484,4475,13437,4487,5210,9044,9040,23842,5190,9076,4482,4469,4481,4480,4499,9057,19662,15889,4476,4498,4479,4478,4483,4474,9056,5226,4470,6709,4460,4465,13439,4451,4496,13427,5218,4494,4400,15900,13423,5213,13419,5191,9036,4397,13420,5199,13444,5206,13436,13441,9065,13440,5212,5186,4396,6737,9043,6736,4399,23877,4398,4402,5192,4436,5184,13434,15877,4450,13426,6741,9053,9055,6739,9039,4452,9062,4497,4464,4446,4408,6734,9077,4403,4405,9042,4407,6738,4410,4404,13417,4459,4449,4409,13418,4413,23843,4428,15891,12449,4406,4461,4426,4411,13421,4504,5207,4425,9078,13454,13424,13422,19635,4463,4421,4412,13433,9038,4453,4414,4415,4416,13416,4418,4424,4448,9063,5185,4419,4445,15893,4422,4455,4432,4454,4429,15904,4447,4423,4430,13429,4417,4439,5188,4444,4442,4456,4420,4435,15890,4493,4434,4433,4440,4501,4438,4458,6710,15892,4427,12393,15878,4431,6740,13431,9051,5201,4441,13430,9064,9060,6711,13415,12492,13442,6732,6743,13438,15874,12487,15885,4503,6715,12395,9037,5183,12435,12480,12499,9052,12474,13458,19656,12472,9041,12491,12497,12436,12464,12403,12392,13449,12437,12462,9054,19648,12394,6712,12413,12410,12438,12496,12414,12387,12486,13413,12465,12452,12476,12400,12475,12405,6746,19654,12401,12484,12421,6713,12411,12426,6745,6733,12453,15894,12451,12382,12463,12432,12470,12427,12425,12495,13457,6716,12429,12478,12397,12415,6721,12399,12385,12483,12494,12489,13443,12490,12388,12406,13445,12458,12416,12428,12457,6735,6730,12468,13448,12396,6719,6744,12447,6720,12391,12469,12384,6723,12477,12460,12448,12461,12479,6729,13447,6718,6714,12402,12381,12383,13452,12485,12455,13414,12417,12409,12473,19644,13456,12488,12419,12408,6731,12386,12398,12431,12459,12481,12450,12467,12404,12471,23821,12424,12420,19619,13459,12407,12422,12430,12466,12423,6717,6724,19646,12433,12440,12434,12446,6722,12418,12482,19647,12445,13453,6726,19649,6725,6727,19650,12389,19661,12439,19652,19641,19643,12442,23872,19642,12443,23813,19657,15884,12456,12412,19693,6742,19651,12390,12493,19645,12454,23836,19658,19683,12441,23868,15873,12444,13506,30891,19659,6747,19655,13505,15880,23901,19691,15898,15875,23880,23818,15897,15896,19688,19613,15879,4491,23820,23819,19673,15887,23891,15882,23892,19689,4443,23817,23890,23837,15881,27782,19672,19679,23870,23894,19680,15901,19681,27758,15876,19685,15888,19687,15883,19684,23866,27768,19686,23895,19745,19669,19676,23838,27783,19682,23884,19674,15886,19667,23828,23839,27775,23822,19615,19623,23844,19670,23898,23812,23873,19610,23899,19701,19618,27759,19660,19665,23896,19632,27781,23864,19625,23897,23875,23841,19620,19611,19627,19622,19629,27780,19628,19626,23867,19624,19630,19631,23878,19697,23893,19616,23900,19617,19612,19636,23840,23874,27889,19671,19702,19694,19677,23902,23869,19696,19639,19614,19699,19700,23871,23865,27778,19690,19633,27886,23831,27890,19668,23887,19675,27792,19621,19678,23881,23829,19692,19638,23832,23830,27774,19637,23889,23886,19695,27887,27777,23885,19640,19698,23882,32644,27766,19664,27776,32008,23834,32005,32011,23827,32010,27791,23835,23876,32012,32009,19663,32006,23825,23883,32007,23824,27787,19666,23833,27760,23888,27779,23826,23879,27770,19653,27580,19634,23823,27579,27894,27577,27582,27578,32651,27891,27581,27885,27893,27790,27785,32645,27895,27892,27772,27762,27773,27888,27789,27784,32658,27763,32641,27788,27765,27761,27767,27786,27764,27769,27771,32639,32650,32656,32652,32649,32640,32636,32648,32635,32655,32638,32657,32647,32653,32654,32646,32634,32637,32643,32642)
ORDER BY FIELD(id, 5216,5217,9067,13425,9070,23815,9073,9069,9068,9072,9071,9229,6707,5194,5208,9089,5195,5193,9045,9088,15899,9091,9246,5196,9092,5214,9237,23814,9083,9243,9236,9090,9084,9087,9233,9096,9081,5197,5198,9082,4473,5222,9066,5205,5215,9049,5223,9086,9095,9101,9085,9231,9080,9238,5219,9226,9235,9112,9244,9100,9098,9239,9035,5224,9240,13455,9097,9104,9234,9106,9059,9109,9050,23816,9099,9058,9079,9046,5189,9242,5220,4468,4488,13450,9102,9241,6708,4472,9105,9103,9107,9245,9230,9228,9108,4495,9093,9111,9114,9232,9061,9227,9094,9113,5225,9110,5182,4457,5221,13435,6728,5187,4486,15895,4485,4462,13446,4489,4477,4492,4471,9048,13432,5202,9074,4467,4490,4466,9075,4401,9047,13428,13451,4484,4475,13437,4487,5210,9044,9040,23842,5190,9076,4482,4469,4481,4480,4499,9057,19662,15889,4476,4498,4479,4478,4483,4474,9056,5226,4470,6709,4460,4465,13439,4451,4496,13427,5218,4494,4400,15900,13423,5213,13419,5191,9036,4397,13420,5199,13444,5206,13436,13441,9065,13440,5212,5186,4396,6737,9043,6736,4399,23877,4398,4402,5192,4436,5184,13434,15877,4450,13426,6741,9053,9055,6739,9039,4452,9062,4497,4464,4446,4408,6734,9077,4403,4405,9042,4407,6738,4410,4404,13417,4459,4449,4409,13418,4413,23843,4428,15891,12449,4406,4461,4426,4411,13421,4504,5207,4425,9078,13454,13424,13422,19635,4463,4421,4412,13433,9038,4453,4414,4415,4416,13416,4418,4424,4448,9063,5185,4419,4445,15893,4422,4455,4432,4454,4429,15904,4447,4423,4430,13429,4417,4439,5188,4444,4442,4456,4420,4435,15890,4493,4434,4433,4440,4501,4438,4458,6710,15892,4427,12393,15878,4431,6740,13431,9051,5201,4441,13430,9064,9060,6711,13415,12492,13442,6732,6743,13438,15874,12487,15885,4503,6715,12395,9037,5183,12435,12480,12499,9052,12474,13458,19656,12472,9041,12491,12497,12436,12464,12403,12392,13449,12437,12462,9054,19648,12394,6712,12413,12410,12438,12496,12414,12387,12486,13413,12465,12452,12476,12400,12475,12405,6746,19654,12401,12484,12421,6713,12411,12426,6745,6733,12453,15894,12451,12382,12463,12432,12470,12427,12425,12495,13457,6716,12429,12478,12397,12415,6721,12399,12385,12483,12494,12489,13443,12490,12388,12406,13445,12458,12416,12428,12457,6735,6730,12468,13448,12396,6719,6744,12447,6720,12391,12469,12384,6723,12477,12460,12448,12461,12479,6729,13447,6718,6714,12402,12381,12383,13452,12485,12455,13414,12417,12409,12473,19644,13456,12488,12419,12408,6731,12386,12398,12431,12459,12481,12450,12467,12404,12471,23821,12424,12420,19619,13459,12407,12422,12430,12466,12423,6717,6724,19646,12433,12440,12434,12446,6722,12418,12482,19647,12445,13453,6726,19649,6725,6727,19650,12389,19661,12439,19652,19641,19643,12442,23872,19642,12443,23813,19657,15884,12456,12412,19693,6742,19651,12390,12493,19645,12454,23836,19658,19683,12441,23868,15873,12444,13506,30891,19659,6747,19655,13505,15880,23901,19691,15898,15875,23880,23818,15897,15896,19688,19613,15879,4491,23820,23819,19673,15887,23891,15882,23892,19689,4443,23817,23890,23837,15881,27782,19672,19679,23870,23894,19680,15901,19681,27758,15876,19685,15888,19687,15883,19684,23866,27768,19686,23895,19745,19669,19676,23838,27783,19682,23884,19674,15886,19667,23828,23839,27775,23822,19615,19623,23844,19670,23898,23812,23873,19610,23899,19701,19618,27759,19660,19665,23896,19632,27781,23864,19625,23897,23875,23841,19620,19611,19627,19622,19629,27780,19628,19626,23867,19624,19630,19631,23878,19697,23893,19616,23900,19617,19612,19636,23840,23874,27889,19671,19702,19694,19677,23902,23869,19696,19639,19614,19699,19700,23871,23865,27778,19690,19633,27886,23831,27890,19668,23887,19675,27792,19621,19678,23881,23829,19692,19638,23832,23830,27774,19637,23889,23886,19695,27887,27777,23885,19640,19698,23882,32644,27766,19664,27776,32008,23834,32005,32011,23827,32010,27791,23835,23876,32012,32009,19663,32006,23825,23883,32007,23824,27787,19666,23833,27760,23888,27779,23826,23879,27770,19653,27580,19634,23823,27579,27894,27577,27582,27578,32651,27891,27581,27885,27893,27790,27785,32645,27895,27892,27772,27762,27773,27888,27789,27784,32658,27763,32641,27788,27765,27761,27767,27786,27764,27769,27771,32639,32650,32656,32652,32649,32640,32636,32648,32635,32655,32638,32657,32647,32653,32654,32646,32634,32637,32643,32642)
;
(this query time : 0.010 s)
(total SQL time : 0.027 s)
(total time : 0.041 s)
(num rows : 737 )
[17] SELECT param, value FROM g_config WHERE param = "send_piwigo_infos_last_notice" ; (this query time : 0.001 s) (total SQL time : 0.028 s) (total time : 0.310 s) (num rows : 1 )