[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 = 'D84903a2b31863b31db80609fd719da3d411'
;
(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.002 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 (870)
(this query time : 0.000 s)
(total SQL time : 0.003 s)
(total time : 0.010 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 (870)
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 date_creation DESC, file ASC, id ASC
(this query time : 0.008 s)
(total SQL time : 0.011 s)
(total time : 0.018 s)
(num rows : 569 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 11082
;
(this query time : 0.001 s)
(total SQL time : 0.011 s)
(total time : 0.019 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 = 11082
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.012 s)
(total time : 0.020 s)
(num rows : 2 )
[12]
SELECT *
FROM g_images
WHERE id IN (11082,11081,31657,11083,4053)
;
(this query time : 0.001 s)
(total SQL time : 0.012 s)
(total time : 0.020 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 (11082)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.001 s)
(total SQL time : 0.013 s)
(total time : 0.024 s)
(num rows : 13 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (103,259,341,102)
(this query time : 0.000 s)
(total SQL time : 0.013 s)
(total time : 0.025 s)
(num rows : 4 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 11082 AND validated = 'true'
;
(this query time : 0.000 s)
(total SQL time : 0.014 s)
(total time : 0.027 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (31657,31656,31655,31654,31653,31652,7407,7408,7410,7409,7406,9925,30717,9926,30715,9927,9928,9929,9930,9931,9932,9919,9920,9921,9922,9924,9923,7400,7401,7403,7402,7405,7404,7394,7396,7397,7395,7399,7398,9198,9199,9200,9201,9202,9203,9207,9206,9208,9209,9211,9210,9212,9213,9214,9215,9216,9217,9218,9219,9221,9220,9223,9222,9224,9225,9204,9205,9133,9134,9136,9138,9139,9140,9142,9141,9144,9143,9145,9146,9147,9148,9149,9150,9151,9152,9153,9154,9155,9156,9157,9158,9159,9160,9161,9162,9163,9164,9165,9167,9166,9168,9169,9170,9171,9172,9173,9174,9175,9176,9177,9178,9179,9180,9181,9182,9183,9185,9184,9186,9187,9188,9189,9190,9191,9192,9193,9194,9195,9196,9197,7185,7186,7187,7189,7188,7191,7190,7192,7193,7194,7195,7196,7197,7198,7199,7201,7200,11208,11210,11209,11211,11212,11213,11214,11216,11182,11181,11183,11184,11185,11186,11187,11188,11189,11191,11190,11192,11193,11215,11218,11217,11194,11195,11196,11197,11198,11199,11180,11144,11145,11147,11146,11148,11149,11150,11151,11152,11153,11142,11091,11093,11094,11098,11099,11100,11101,11102,11103,11105,11104,11106,11107,11109,11108,11111,30897,11110,30702,11112,11113,11114,11115,11116,11117,11119,11118,11120,11121,11123,11122,11124,11125,11127,11126,11128,11129,11130,11131,11037,11036,11039,11038,11040,11041,11042,11043,11044,11045,11046,11048,11049,11050,11051,11052,11053,11054,11055,11056,11057,11059,11058,11061,11062,11063,11064,11065,11066,11067,11069,11070,11071,11072,11073,11075,11074,11078,11079,11080,11081,11082,11083,11084,11085,11086,11087,11088,11090,11089,5613,5612,5611,5610,5609,5608,5607,5606,5605,5604,5603,5602,5601,5600,5599,5598,5597,5596,5595,5594,5593,5592,5591,5590,5589,5588,5587,5586,5585,5584,5583,5582,5581,5580,5616,5615,5579,5578,5577,5576,5575,5574,5573,5572,10593,10594,10595,10596,30694,5423,5421,5422,5419,5420,5417,5418,5415,5141,5142,5139,5140,5875,5874,5873,5872,5871,5870,5869,5868,5867,5866,5865,5864,5863,5862,5861,5860,5859,4734,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,4237,4236,4239,4238,4241,4243,4233,4232,4231,4242,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,4096,4094,4095,4103,4104,3997,3999,4001,4002,4004,4003,4000,3998,3995,3996,3993,3994,3991,3992,3980,3979,3982,3981,3984,3983,3986,3987,3988,3990,3989,3985,3977,3978,3976,3974,3975,3973,3924,3926,3927,3928,3929,3930,3931,3932,3933,3934,3935,3937,3936,3939,3938,3941,3940,3943,3942,3945,3944,3946,3947,3948,3950,3951,3955,3923,3972,3971,3970,3969,3968,3967,3966,3965,3964,3963,3962,3961,3960,3959,3958,3957,3956,3954,3953,3952,3949,3925,4037,4082,4081,4080,4079,4077,4076,4075,4073,4072,4070,4068,4065,4063,4062,4061,4060,4058,4056,4053)
ORDER BY FIELD(id, 31657,31656,31655,31654,31653,31652,7407,7408,7410,7409,7406,9925,30717,9926,30715,9927,9928,9929,9930,9931,9932,9919,9920,9921,9922,9924,9923,7400,7401,7403,7402,7405,7404,7394,7396,7397,7395,7399,7398,9198,9199,9200,9201,9202,9203,9207,9206,9208,9209,9211,9210,9212,9213,9214,9215,9216,9217,9218,9219,9221,9220,9223,9222,9224,9225,9204,9205,9133,9134,9136,9138,9139,9140,9142,9141,9144,9143,9145,9146,9147,9148,9149,9150,9151,9152,9153,9154,9155,9156,9157,9158,9159,9160,9161,9162,9163,9164,9165,9167,9166,9168,9169,9170,9171,9172,9173,9174,9175,9176,9177,9178,9179,9180,9181,9182,9183,9185,9184,9186,9187,9188,9189,9190,9191,9192,9193,9194,9195,9196,9197,7185,7186,7187,7189,7188,7191,7190,7192,7193,7194,7195,7196,7197,7198,7199,7201,7200,11208,11210,11209,11211,11212,11213,11214,11216,11182,11181,11183,11184,11185,11186,11187,11188,11189,11191,11190,11192,11193,11215,11218,11217,11194,11195,11196,11197,11198,11199,11180,11144,11145,11147,11146,11148,11149,11150,11151,11152,11153,11142,11091,11093,11094,11098,11099,11100,11101,11102,11103,11105,11104,11106,11107,11109,11108,11111,30897,11110,30702,11112,11113,11114,11115,11116,11117,11119,11118,11120,11121,11123,11122,11124,11125,11127,11126,11128,11129,11130,11131,11037,11036,11039,11038,11040,11041,11042,11043,11044,11045,11046,11048,11049,11050,11051,11052,11053,11054,11055,11056,11057,11059,11058,11061,11062,11063,11064,11065,11066,11067,11069,11070,11071,11072,11073,11075,11074,11078,11079,11080,11081,11082,11083,11084,11085,11086,11087,11088,11090,11089,5613,5612,5611,5610,5609,5608,5607,5606,5605,5604,5603,5602,5601,5600,5599,5598,5597,5596,5595,5594,5593,5592,5591,5590,5589,5588,5587,5586,5585,5584,5583,5582,5581,5580,5616,5615,5579,5578,5577,5576,5575,5574,5573,5572,10593,10594,10595,10596,30694,5423,5421,5422,5419,5420,5417,5418,5415,5141,5142,5139,5140,5875,5874,5873,5872,5871,5870,5869,5868,5867,5866,5865,5864,5863,5862,5861,5860,5859,4734,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,4237,4236,4239,4238,4241,4243,4233,4232,4231,4242,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,4096,4094,4095,4103,4104,3997,3999,4001,4002,4004,4003,4000,3998,3995,3996,3993,3994,3991,3992,3980,3979,3982,3981,3984,3983,3986,3987,3988,3990,3989,3985,3977,3978,3976,3974,3975,3973,3924,3926,3927,3928,3929,3930,3931,3932,3933,3934,3935,3937,3936,3939,3938,3941,3940,3943,3942,3945,3944,3946,3947,3948,3950,3951,3955,3923,3972,3971,3970,3969,3968,3967,3966,3965,3964,3963,3962,3961,3960,3959,3958,3957,3956,3954,3953,3952,3949,3925,4037,4082,4081,4080,4079,4077,4076,4075,4073,4072,4070,4068,4065,4063,4062,4061,4060,4058,4056,4053)
;
(this query time : 0.010 s)
(total SQL time : 0.023 s)
(total time : 0.038 s)
(num rows : 569 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.024 s)
(total time : 0.255 s)
(num rows : 1 )