[1] SELECT @@SESSION.sql_mode (this query time : 0.000 s) (total SQL time : 0.000 s) (total time : 0.005 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.006 s) (num rows : 126 )
[3] SELECT data FROM g_sessions WHERE id = 'D8491cf9d4550864236ae18f06aac869dc13' ; (this query time : 0.000 s) (total SQL time : 0.002 s) (total time : 0.007 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.007 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.010 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.010 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.011 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.011 s) (num rows : 1 )
[0.014 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 date_creation BETWEEN '2016-01-01' AND '2016-12-31 23:59:59'
ORDER BY date_creation DESC, date_creation DESC, file ASC, id ASC
(this query time : 0.009 s)
(total SQL time : 0.013 s)
(total time : 0.023 s)
(num rows : 797 )
[0.023 s, 9 queries] : end initialize_calendar
[10] UPDATE g_images SET hit = hit+1, lastmodified = lastmodified WHERE id = 4259 ; (this query time : 0.001 s) (total SQL time : 0.013 s) (total time : 0.024 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 = 4259
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.014 s)
(total time : 0.025 s)
(num rows : 3 )
[12] SELECT * FROM g_images WHERE id IN (4259,30852,4733,4258,4557) ; (this query time : 0.001 s) (total SQL time : 0.014 s) (total time : 0.025 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 (4259)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.001 s)
(total SQL time : 0.015 s)
(total time : 0.030 s)
(num rows : 16 )
[14] SELECT id, name, permalink FROM g_categories WHERE id IN (140,100,101,194) (this query time : 0.000 s) (total SQL time : 0.016 s) (total time : 0.031 s) (num rows : 4 )
[15]
SELECT COUNT(rate) AS count
, ROUND(AVG(rate),2) AS average
FROM g_rate
WHERE element_id = 4259
;
(this query time : 0.001 s)
(total SQL time : 0.016 s)
(total time : 0.033 s)
(num rows : 1 )
[16]
SELECT rate
FROM g_rate
WHERE element_id = 4259
AND user_id = 2 AND anonymous_id = '216.73.217'
(this query time : 0.000 s)
(total SQL time : 0.017 s)
(total time : 0.034 s)
(num rows : 0 )
[17]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 4259 AND validated = 'true'
;
(this query time : 0.000 s)
(total SQL time : 0.017 s)
(total time : 0.034 s)
(num rows : 1 )
[18]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (4733,4734,4732,30877,4812,4811,4814,4813,4806,30690,30876,30875,4807,4816,4817,4818,4823,30874,4581,4582,4583,4585,4579,4580,7663,30681,30680,30679,30676,4599,4600,4597,4598,4595,4596,4593,4594,4591,4592,4589,4590,4587,4588,4586,4602,4601,7664,4603,4604,30873,4773,30870,30869,30867,30868,5326,30677,7665,30872,4675,4676,4673,4674,4671,4672,4669,4670,4667,4668,4665,4666,4663,4664,4661,4662,4659,4660,4657,4658,4656,4655,4653,4654,4651,4652,4650,4649,4647,4648,4645,4646,4643,4644,4641,4642,4639,4640,4637,4638,4635,4636,4633,4634,4631,4632,4629,4630,4628,4627,4625,4626,4624,4730,4729,4727,4728,4725,4726,4723,4724,4721,4722,4719,4720,4717,4718,4715,4716,4713,4714,4711,4712,4709,4710,4707,4708,4705,4706,4704,4703,4702,4701,4700,4699,4697,4698,4695,4696,4693,4694,4691,4692,4689,4690,4687,4688,4685,4686,4684,4683,4682,4681,4680,4678,4679,4677,30678,30866,30871,4820,30865,30864,4578,30673,30672,4577,4575,5030,5027,5028,5025,5026,4574,4613,4616,4617,4614,4615,4622,4623,4612,4610,4611,4609,4608,4606,4620,4621,4607,4605,4618,4619,4576,30863,5033,5032,5031,30675,5013,5014,5011,5012,5009,5010,5015,5016,5019,4770,5018,4772,5023,5024,5021,5022,5008,5004,5006,4572,4570,4571,5005,4569,4996,4997,4998,30674,5002,4999,5000,5007,5003,5001,4989,4992,4993,4991,4990,4994,4995,4565,4566,4564,4563,4562,4560,4561,30669,30667,30665,4573,4548,4547,4822,4544,4546,4545,4824,7667,4539,4538,4537,4536,4535,4534,4542,4543,4541,4540,4929,4531,4533,4532,4810,4809,4528,4529,4530,4500,4501,4503,4504,4469,4484,4485,4487,4490,4489,4488,4486,4483,4482,4481,4479,4480,4477,4478,4475,4476,4474,4473,4472,4471,4470,4468,4467,4465,4466,4443,4460,4464,4446,4449,4450,4451,4452,4402,4403,4404,4405,4406,4407,4408,4409,4410,4411,4412,4413,4414,4415,4416,4417,4418,4419,4420,4421,4422,4423,4400,4401,4398,4399,4396,4397,4445,4444,4456,4457,4454,4455,4453,4448,4447,4463,4461,4462,4459,4497,4427,4498,4430,4499,4429,4496,4495,4494,4431,4493,4433,4492,4434,4435,4436,4438,4458,4440,4491,4439,4441,4442,4432,4428,4426,4424,4425,30862,4505,4507,4506,4508,4509,4512,4514,4521,4523,4371,4374,4362,4363,4365,4367,4368,4328,4333,4334,4336,4337,4338,4339,4342,4310,4311,4312,4314,4326,4327,4325,4324,4323,4322,4321,4320,4319,4318,4317,4316,4315,4313,4353,4352,4351,4350,4349,4348,4347,4346,4345,4344,4343,4341,4340,4335,4332,4331,4330,4329,4366,4364,4361,4360,4359,4358,4357,4356,4377,4376,4375,4373,4372,4370,4369,4522,4520,4519,4518,4516,4517,4515,4513,4510,4511,4308,4307,7666,4527,4300,4306,4305,4304,4303,4302,4301,4299,4309,4298,4289,4526,4524,4354,4286,4355,4292,4295,4296,4297,4293,4819,4287,4288,30666,4265,4272,4271,4270,4269,4268,4267,4266,4264,4263,4262,4261,4260,4273,7669,4278,4277,4276,4275,4274,4280,4279,30861,4281,4284,4285,4282,4283,30860,30859,30858,30857,30856,30855,30854,30850,30668,4558,4554,4552,4551,4553,30852,4259,4258,4550,4257,4254,4255,4253,4256,4549,4252,4237,4236,4240,4239,4238,30670,4241,4243,4233,4232,4231,4242,4223,4222,4245,4244,4234,4221,4220,4219,4218,4217,4216,4205,4204,4215,4214,4203,4213,4212,4211,4210,4209,4208,4207,4206,4200,4201,4202,4192,4193,4194,4199,4197,4196,4184,4195,4191,4189,4185,4186,4187,4183,4188,4190,4247,4246,4180,4250,4230,4248,4249,30660,4229,4224,30851,4179,4178,4177,4176,4175,4174,4173,4235,4172,4171,30661,30664,4165,4164,4163,4162,4161,4160,4159,4158,4157,4156,30849,4145,4169,4168,4228,4167,4225,4152,4151,4150,4149,4148,4147,4146,4127,4128,4170,4144,4143,4182,4142,4141,4155,4154,4153,4227,4133,4134,4132,4131,4130,4129,30848,30847,30846,30843,30845,30844,4135,4136,30663,4138,4137,4140,4139,4121,4126,4226,4117,4122,4123,4125,7668,7616,4116,4118,4119,4110,4113,4114,4112,4111,30662,30853,30705,4107,4109,4108,30656,4099,30657,30658,30654,30655,30653,4098,30651,30652,30650,30649,4093,4097,4101,4120,4100,4102,4096,4094,4095,4103,4104,4555,4034,4035,4033,4030,4032,4106,4031,4821,4556,4036,30648,4041,4043,4042,4045,4044,4052,30644,30643,4047,30647,30646,30645,4049,4048,4051,4050,4038,4040,4039,7617,4029,4025,4027,4105,4006,4007,4008,4009,4010,4011,4012,4013,4014,4015,4016,4017,4019,4018,4021,4020,4022,4023,4024,4557)
ORDER BY FIELD(id, 4733,4734,4732,30877,4812,4811,4814,4813,4806,30690,30876,30875,4807,4816,4817,4818,4823,30874,4581,4582,4583,4585,4579,4580,7663,30681,30680,30679,30676,4599,4600,4597,4598,4595,4596,4593,4594,4591,4592,4589,4590,4587,4588,4586,4602,4601,7664,4603,4604,30873,4773,30870,30869,30867,30868,5326,30677,7665,30872,4675,4676,4673,4674,4671,4672,4669,4670,4667,4668,4665,4666,4663,4664,4661,4662,4659,4660,4657,4658,4656,4655,4653,4654,4651,4652,4650,4649,4647,4648,4645,4646,4643,4644,4641,4642,4639,4640,4637,4638,4635,4636,4633,4634,4631,4632,4629,4630,4628,4627,4625,4626,4624,4730,4729,4727,4728,4725,4726,4723,4724,4721,4722,4719,4720,4717,4718,4715,4716,4713,4714,4711,4712,4709,4710,4707,4708,4705,4706,4704,4703,4702,4701,4700,4699,4697,4698,4695,4696,4693,4694,4691,4692,4689,4690,4687,4688,4685,4686,4684,4683,4682,4681,4680,4678,4679,4677,30678,30866,30871,4820,30865,30864,4578,30673,30672,4577,4575,5030,5027,5028,5025,5026,4574,4613,4616,4617,4614,4615,4622,4623,4612,4610,4611,4609,4608,4606,4620,4621,4607,4605,4618,4619,4576,30863,5033,5032,5031,30675,5013,5014,5011,5012,5009,5010,5015,5016,5019,4770,5018,4772,5023,5024,5021,5022,5008,5004,5006,4572,4570,4571,5005,4569,4996,4997,4998,30674,5002,4999,5000,5007,5003,5001,4989,4992,4993,4991,4990,4994,4995,4565,4566,4564,4563,4562,4560,4561,30669,30667,30665,4573,4548,4547,4822,4544,4546,4545,4824,7667,4539,4538,4537,4536,4535,4534,4542,4543,4541,4540,4929,4531,4533,4532,4810,4809,4528,4529,4530,4500,4501,4503,4504,4469,4484,4485,4487,4490,4489,4488,4486,4483,4482,4481,4479,4480,4477,4478,4475,4476,4474,4473,4472,4471,4470,4468,4467,4465,4466,4443,4460,4464,4446,4449,4450,4451,4452,4402,4403,4404,4405,4406,4407,4408,4409,4410,4411,4412,4413,4414,4415,4416,4417,4418,4419,4420,4421,4422,4423,4400,4401,4398,4399,4396,4397,4445,4444,4456,4457,4454,4455,4453,4448,4447,4463,4461,4462,4459,4497,4427,4498,4430,4499,4429,4496,4495,4494,4431,4493,4433,4492,4434,4435,4436,4438,4458,4440,4491,4439,4441,4442,4432,4428,4426,4424,4425,30862,4505,4507,4506,4508,4509,4512,4514,4521,4523,4371,4374,4362,4363,4365,4367,4368,4328,4333,4334,4336,4337,4338,4339,4342,4310,4311,4312,4314,4326,4327,4325,4324,4323,4322,4321,4320,4319,4318,4317,4316,4315,4313,4353,4352,4351,4350,4349,4348,4347,4346,4345,4344,4343,4341,4340,4335,4332,4331,4330,4329,4366,4364,4361,4360,4359,4358,4357,4356,4377,4376,4375,4373,4372,4370,4369,4522,4520,4519,4518,4516,4517,4515,4513,4510,4511,4308,4307,7666,4527,4300,4306,4305,4304,4303,4302,4301,4299,4309,4298,4289,4526,4524,4354,4286,4355,4292,4295,4296,4297,4293,4819,4287,4288,30666,4265,4272,4271,4270,4269,4268,4267,4266,4264,4263,4262,4261,4260,4273,7669,4278,4277,4276,4275,4274,4280,4279,30861,4281,4284,4285,4282,4283,30860,30859,30858,30857,30856,30855,30854,30850,30668,4558,4554,4552,4551,4553,30852,4259,4258,4550,4257,4254,4255,4253,4256,4549,4252,4237,4236,4240,4239,4238,30670,4241,4243,4233,4232,4231,4242,4223,4222,4245,4244,4234,4221,4220,4219,4218,4217,4216,4205,4204,4215,4214,4203,4213,4212,4211,4210,4209,4208,4207,4206,4200,4201,4202,4192,4193,4194,4199,4197,4196,4184,4195,4191,4189,4185,4186,4187,4183,4188,4190,4247,4246,4180,4250,4230,4248,4249,30660,4229,4224,30851,4179,4178,4177,4176,4175,4174,4173,4235,4172,4171,30661,30664,4165,4164,4163,4162,4161,4160,4159,4158,4157,4156,30849,4145,4169,4168,4228,4167,4225,4152,4151,4150,4149,4148,4147,4146,4127,4128,4170,4144,4143,4182,4142,4141,4155,4154,4153,4227,4133,4134,4132,4131,4130,4129,30848,30847,30846,30843,30845,30844,4135,4136,30663,4138,4137,4140,4139,4121,4126,4226,4117,4122,4123,4125,7668,7616,4116,4118,4119,4110,4113,4114,4112,4111,30662,30853,30705,4107,4109,4108,30656,4099,30657,30658,30654,30655,30653,4098,30651,30652,30650,30649,4093,4097,4101,4120,4100,4102,4096,4094,4095,4103,4104,4555,4034,4035,4033,4030,4032,4106,4031,4821,4556,4036,30648,4041,4043,4042,4045,4044,4052,30644,30643,4047,30647,30646,30645,4049,4048,4051,4050,4038,4040,4039,7617,4029,4025,4027,4105,4006,4007,4008,4009,4010,4011,4012,4013,4014,4015,4016,4017,4019,4018,4021,4020,4022,4023,4024,4557)
;
(this query time : 0.015 s)
(total SQL time : 0.032 s)
(total time : 0.051 s)
(num rows : 797 )
[19] SELECT param, value FROM g_config WHERE param = "send_piwigo_infos_last_notice" ; (this query time : 0.001 s) (total SQL time : 0.033 s) (total time : 0.360 s) (num rows : 1 )