kewl's gallery

[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.000 s)
(total time      : 0.002 s)
(num rows        : 92 )
[3] 

SELECT data
  FROM g_sessions
  WHERE id = '365155d73p6v2okq3lrq9osuqql6i6'
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)
(total time      : 0.003 s)
(num rows        : 0 )
[4] 

SELECT * FROM g_plugins
  WHERE state='active'
(this query time : 0.000 s)
(total SQL time  : 0.001 s)
(total time      : 0.003 s)
(num rows        : 15 )
[5] 

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.001 s)
(total time      : 0.005 s)
(num rows        : 1 )
[6] 

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.001 s)
(total time      : 0.005 s)
(num rows        : 1 )
[7] 

SELECT id, name
  FROM g_languages
  ORDER BY name ASC
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)
(total time      : 0.005 s)
(num rows        : 69 )
[8] 

SELECT *
  FROM g_user_infos
  WHERE user_id = 2
;
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.006 s)
(num rows        : 1 )
[9] 

SELECT *
  FROM g_tags
  WHERE id IN (8)
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.007 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 (8)
  AND (category_id NOT IN (188,201,198,200,182,212) AND level<=0)
  GROUP BY id
ORDER BY date_creation DESC, file ASC, id ASC
(this query time : 0.005 s)
(total SQL time  : 0.006 s)
(total time      : 0.012 s)
(num rows        : 948 )
[10] 

SELECT 
  id, name, permalink, nb_images, global_rank,
  date_last, max_date_last, count_images, count_categories
FROM g_categories INNER JOIN g_user_cache_categories
  ON id = cat_id and user_id = 2
WHERE 
  1 = 1
;
(this query time : 0.000 s)
(total SQL time  : 0.007 s)
(total time      : 0.013 s)
(num rows        : 102 )
[11] 

SELECT SUBDATE(CURRENT_DATE,INTERVAL 30 DAY)
(this query time : 0.000 s)
(total SQL time  : 0.007 s)
(total time      : 0.013 s)
(num rows        : 1 )
[12] 

SELECT t.*, count(*) AS counter
  FROM g_image_tag
    INNER JOIN g_tags t ON tag_id = id
  WHERE image_id IN (6062,6172,6116,6103,6102,6101,6100,5942,5943,5944,5945,5946,5947,5948,5949,5950,5951,5952,5953,5954,5955,5956,5957,5958,5959,5960,5961,5962,5963,5964,5965,5966,5967,5968,5969,5970,5971,5972,5973,5974,5975,5976,5977,5978,5979,5980,5981,5982,6023,6009,5941,5934,5925,5926,5927,5940,5938,5939,5918,5919,5920,5921,5916,5841,5842,5843,5844,5845,5846,5749,5750,5751,5753,5754,5719,5720,5729,5730,5731,5732,5733,5734,5783,5784,5808,5809,5816,5379,5390,5396,5393,5414,5441,5442,5474,5473,5471,5472,5566,5563,5561,5562,5559,5560,5558,5324,5325,5549,5546,5545,5544,5543,5541,5262,5277,5278,5080,5078,5136,5137,5132,5133,5128,5126,5127,5121,5120,5138,4938,4936,4935,4933,4934,4932,4930,4940,4958,4955,4956,4953,4954,4977,4975,4974,4973,4972,4971,4970,4968,4969,5046,4981,4982,5143,5144,5162,5163,5181,5179,5184,5216,5217,4927,4928,4925,4926,4923,4924,4922,4921,4919,4920,4918,4917,4916,4915,4914,4913,4912,4911,4910,4909,4908,4907,4906,4905,4904,4903,4902,4901,4900,4899,4898,4897,5237,5248,5261,5259,5321,5319,5318,5316,5309,5308,5307,5305,5304,4870,5227,5228,5338,4834,4835,4849,4850,4851,4852,4853,4854,4855,4856,4857,4858,4859,4860,5366,5364,5365,5908,4830,4828,4829,4831,4783,4782,4804,4805,4802,4803,4801,4800,4799,4798,4797,4796,4794,4795,4792,4793,4774,4781,4749,4738,4739,4750,4737,4741,4769,4768,4767,4765,4766,4760,4764,4762,4761,4758,4759,4756,4757,4754,4755,4752,4751,4813,4814,4811,4812,4806,4823,4818,4817,4816,4807,4579,4585,4583,4582,4581,4580,4599,4600,4597,4598,4595,4596,4593,4594,4591,4592,4589,4590,4587,4588,4586,4602,4604,4773,4578,4577,4616,4617,4614,4615,4613,4622,4623,4612,4610,4611,4609,4608,4606,4620,4621,4607,4605,4618,4619,4576,5006,4572,4570,4571,4569,4992,4993,4991,4994,4822,4544,4824,4929,4809,4810,4528,4529,4530,4489,4490,4488,4487,4486,4485,4484,4483,4482,4481,4479,4480,4477,4478,4475,4476,4474,4473,4472,4471,4470,4469,4468,4467,4465,4466,4400,4401,4398,4399,4396,4397,4445,4423,4422,4421,4420,4419,4418,4417,4416,4415,4414,4413,4412,4444,4411,4410,4409,4408,4407,4406,4405,4404,4403,4402,4456,4457,4454,4455,4452,4453,4451,4450,4449,4448,4447,4446,4463,4464,4461,4462,4460,4459,4493,4441,4442,4439,4440,4458,4438,4436,4435,4434,4433,4432,4431,4429,4430,4427,4428,4426,4424,4425,4308,4307,4306,4305,4304,4303,4302,4301,4300,4299,4298,4289,4526,4524,4354,4286,4355,4292,4295,4296,4297,4287,4288,4260,4279,4285,4259,4258,4257,4254,4255,4247,4246,4180,4135,4136,4138,4137,4140,4139,4121,4126,4122,4117,4123,4125,4124,4118,4119,4113,4114,4112,4111,4110,4099,4098,4108,4109,4107,4034,4035,4033,4030,4032,4106,4031,4821,4036,4041,4042,4045,4051,4039,4040,4038,4029,4025,4022,4023,4020,4021,4018,4019,4017,4016,4015,4014,4013,4012,4011,4010,4009,4008,4007,4024,4006,4557,3922,3921,3919,3920,3917,3918,3916,3915,3914,3913,3912,3911,3833,3834,3831,3832,3830,3829,3828,3827,3825,3826,3824,3823,3821,3822,3819,3820,3817,3818,3815,3816,3814,3813,3811,3812,3809,3810,3807,3808,3806,3805,3804,3803,3802,3801,3800,3799,3798,3797,3796,3795,3794,3793,3792,3791,3789,3790,3788,3787,3786,3785,3784,3783,3782,3781,3780,3779,3778,3777,3776,3775,3774,3772,3771,3770,3769,3768,3767,3766,3765,3764,3763,3762,3761,3760,3835,3679,3680,3677,3678,3676,3675,3674,3673,3672,3671,3670,3669,3668,3666,3667,3664,3665,3663,3662,3661,3660,3659,3658,3657,3656,3655,3654,3653,3652,3651,3650,3649,3648,3647,3646,3645,3644,3643,3642,3641,3640,3639,3638,3637,3636,3635,3634,3633,3632,3631,3630,3629,3628,3627,3626,3625,3624,3623,3729,3730,3728,3727,3726,3725,3724,3721,3723,3722,3720,3718,3719,3556,4115,3501,3500,3499,3498,3497,3496,3494,3495,3492,3493,3491,3490,3489,3488,3487,3486,3485,3484,3482,3483,3481,3480,3478,3479,3476,3477,3475,3474,3473,3472,3471,3470,3469,3468,3467,3466,3465,3464,3463,3462,3461,3460,3459,3458,3543,3502,3503,3504,3505,3506,3507,3508,3509,3510,3511,3512,3513,3514,3515,3516,3517,3518,3519,3520,3521,3522,3523,3524,3525,3526,3527,3528,3529,3530,3531,3532,3533,3534,3535,3536,3537,3310,3311,3312,3313,3314,3315,3316,3317,3318,3319,3320,3321,3322,3323,3324,3325,3326,3327,3328,3329,3330,3331,3332,3333,3334,3335,3336,3337,3338,3339,3340,3341,3343,3342,3344,3346,3345,3347,3348,3545,4771,5337,3544,4827,27,2,3,4,5,6,7,8,9,10,11,12,13,3555,15,16,17,18,19,20,21,3302,3303,3304,3306,3305,3301,3300,3547,3548,3550,3551,3553,3552,3549,3554,3432,3433,3434,4808,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3418,3419,3420,3421,3422,3423,3424,3425,3426,3427,3365,3366,3367,3368,3369,3370,3371,3372,3373,3374,3375,3376,3377,3378,3379,3380,3381,3382,3383,3384,3385,3386,3387,3388,3389,3391,3390,3392,3393,3394,3395,3396,3397,3398,3399,3400,3401,3402,3403,3404,3405,3406,3407,3362,3363,3364,3361,4825,3354,3355,3356,3357,3358,3359,3360,3353,3351,3352,3349,3350,4826,4778,4290,4896)
    AND tag_id NOT IN (8)
  GROUP BY t.id
  ORDER BY counter DESC
  LIMIT 20
(this query time : 0.046 s)
(total SQL time  : 0.052 s)
(total time      : 0.061 s)
(num rows        : 20 )
[13] 

SELECT *
  FROM g_images
  WHERE id IN (6062,6172,6116,6103,6102,6101,6100,5942,5943,5944,5945,5946,5947,5948,5949,5950,5951,5952,5953,5954,5955,5956,5957,5958,5959,5960,5961,5962,5963,5964,5965,5966,5967,5968,5969,5970,5971,5972,5973,5974,5975,5976,5977,5978,5979,5980,5981,5982,6023,6009,5941,5934,5925,5926,5927,5940,5938,5939,5918,5919,5920,5921,5916,5841,5842,5843,5844,5845,5846,5749,5750,5751,5753,5754,5719,5720,5729,5730,5731,5732,5733,5734,5783,5784,5808,5809,5816,5379,5390,5396,5393,5414,5441,5442,5474,5473,5471,5472,5566,5563,5561,5562,5559,5560,5558,5324,5325,5549,5546,5545,5544,5543,5541,5262,5277,5278,5080,5078,5136,5137,5132,5133,5128,5126,5127,5121,5120,5138,4938,4936,4935,4933,4934,4932,4930,4940,4958,4955,4956,4953,4954,4977,4975,4974,4973,4972,4971,4970,4968,4969,5046,4981,4982,5143,5144,5162,5163,5181,5179,5184,5216,5217,4927,4928,4925,4926,4923,4924,4922,4921,4919,4920,4918,4917,4916,4915,4914,4913,4912,4911,4910,4909,4908,4907,4906,4905,4904,4903,4902,4901,4900,4899,4898,4897,5237,5248,5261,5259,5321,5319,5318,5316,5309,5308,5307,5305,5304,4870,5227,5228,5338,4834,4835,4849,4850,4851,4852,4853,4854,4855,4856,4857,4858,4859,4860,5366,5364,5365,5908,4830,4828,4829,4831,4783,4782,4804,4805,4802,4803,4801,4800,4799,4798,4797,4796,4794,4795,4792,4793,4774,4781,4749,4738,4739,4750,4737,4741,4769,4768,4767,4765,4766,4760,4764,4762,4761,4758,4759,4756,4757,4754,4755,4752,4751,4813,4814,4811,4812,4806,4823,4818,4817,4816,4807,4579,4585,4583,4582,4581,4580,4599,4600,4597,4598,4595,4596,4593,4594,4591,4592,4589,4590,4587,4588,4586,4602,4604,4773,4578,4577,4616,4617,4614,4615,4613,4622,4623,4612,4610,4611,4609,4608,4606,4620,4621,4607,4605,4618,4619,4576,5006,4572,4570,4571,4569,4992,4993,4991,4994,4822,4544,4824,4929,4809,4810,4528,4529,4530,4489,4490,4488,4487,4486,4485,4484,4483,4482,4481,4479,4480,4477,4478,4475,4476,4474,4473,4472,4471,4470,4469,4468,4467,4465,4466,4400,4401,4398,4399,4396,4397,4445,4423,4422,4421,4420,4419,4418,4417,4416,4415,4414,4413,4412,4444,4411,4410,4409,4408,4407,4406)
;
(this query time : 0.003 s)
(total SQL time  : 0.056 s)
(total time      : 0.067 s)
(num rows        : 400 )

[0.100 s, 13 queries] : end include/category_default.inc.php

[14] 

SELECT id FROM g_images
WHERE latitude IS NOT NULL
  AND id IN (6062,6172,6116,6103,6102,6101,6100,5942,5943,5944,5945,5946,5947,5948,5949,5950,5951,5952,5953,5954,5955,5956,5957,5958,5959,5960,5961,5962,5963,5964,5965,5966,5967,5968,5969,5970,5971,5972,5973,5974,5975,5976,5977,5978,5979,5980,5981,5982,6023,6009,5941,5934,5925,5926,5927,5940,5938,5939,5918,5919,5920,5921,5916,5841,5842,5843,5844,5845,5846,5749,5750,5751,5753,5754,5719,5720,5729,5730,5731,5732,5733,5734,5783,5784,5808,5809,5816,5379,5390,5396,5393,5414,5441,5442,5474,5473,5471,5472,5566,5563,5561,5562,5559,5560,5558,5324,5325,5549,5546,5545,5544,5543,5541,5262,5277,5278,5080,5078,5136,5137,5132,5133,5128,5126,5127,5121,5120,5138,4938,4936,4935,4933,4934,4932,4930,4940,4958,4955,4956,4953,4954,4977,4975,4974,4973,4972,4971,4970,4968,4969,5046,4981,4982,5143,5144,5162,5163,5181,5179,5184,5216,5217,4927,4928,4925,4926,4923,4924,4922,4921,4919,4920,4918,4917,4916,4915,4914,4913,4912,4911,4910,4909,4908,4907,4906,4905,4904,4903,4902,4901,4900,4899,4898,4897,5237,5248,5261,5259,5321,5319,5318,5316,5309,5308,5307,5305,5304,4870,5227,5228,5338,4834,4835,4849,4850,4851,4852,4853,4854,4855,4856,4857,4858,4859,4860,5366,5364,5365,5908,4830,4828,4829,4831,4783,4782,4804,4805,4802,4803,4801,4800,4799,4798,4797,4796,4794,4795,4792,4793,4774,4781,4749,4738,4739,4750,4737,4741,4769,4768,4767,4765,4766,4760,4764,4762,4761,4758,4759,4756,4757,4754,4755,4752,4751,4813,4814,4811,4812,4806,4823,4818,4817,4816,4807,4579,4585,4583,4582,4581,4580,4599,4600,4597,4598,4595,4596,4593,4594,4591,4592,4589,4590,4587,4588,4586,4602,4604,4773,4578,4577,4616,4617,4614,4615,4613,4622,4623,4612,4610,4611,4609,4608,4606,4620,4621,4607,4605,4618,4619,4576,5006,4572,4570,4571,4569,4992,4993,4991,4994,4822,4544,4824,4929,4809,4810,4528,4529,4530,4489,4490,4488,4487,4486,4485,4484,4483,4482,4481,4479,4480,4477,4478,4475,4476,4474,4473,4472,4471,4470,4469,4468,4467,4465,4466,4400,4401,4398,4399,4396,4397,4445,4423,4422,4421,4420,4419,4418,4417,4416,4415,4414,4413,4412,4444,4411,4410,4409,4408,4407,4406,4405,4404,4403,4402,4456,4457,4454,4455,4452,4453,4451,4450,4449,4448,4447,4446,4463,4464,4461,4462,4460,4459,4493,4441,4442,4439,4440,4458,4438,4436,4435,4434,4433,4432,4431,4429,4430,4427,4428,4426,4424,4425,4308,4307,4306,4305,4304,4303,4302,4301,4300,4299,4298,4289,4526,4524,4354,4286,4355,4292,4295,4296,4297,4287,4288,4260,4279,4285,4259,4258,4257,4254,4255,4247,4246,4180,4135,4136,4138,4137,4140,4139,4121,4126,4122,4117,4123,4125,4124,4118,4119,4113,4114,4112,4111,4110,4099,4098,4108,4109,4107,4034,4035,4033,4030,4032,4106,4031,4821,4036,4041,4042,4045,4051,4039,4040,4038,4029,4025,4022,4023,4020,4021,4018,4019,4017,4016,4015,4014,4013,4012,4011,4010,4009,4008,4007,4024,4006,4557,3922,3921,3919,3920,3917,3918,3916,3915,3914,3913,3912,3911,3833,3834,3831,3832,3830,3829,3828,3827,3825,3826,3824,3823,3821,3822,3819,3820,3817,3818,3815,3816,3814,3813,3811,3812,3809,3810,3807,3808,3806,3805,3804,3803,3802,3801,3800,3799,3798,3797,3796,3795,3794,3793,3792,3791,3789,3790,3788,3787,3786,3785,3784,3783,3782,3781,3780,3779,3778,3777,3776,3775,3774,3772,3771,3770,3769,3768,3767,3766,3765,3764,3763,3762,3761,3760,3835,3679,3680,3677,3678,3676,3675,3674,3673,3672,3671,3670,3669,3668,3666,3667,3664,3665,3663,3662,3661,3660,3659,3658,3657,3656,3655,3654,3653,3652,3651,3650,3649,3648,3647,3646,3645,3644,3643,3642,3641,3640,3639,3638,3637,3636,3635,3634,3633,3632,3631,3630,3629,3628,3627,3626,3625,3624,3623,3729,3730,3728,3727,3726,3725,3724,3721,3723,3722,3720,3718,3719,3556,4115,3501,3500,3499,3498,3497,3496,3494,3495,3492,3493,3491,3490,3489,3488,3487,3486,3485,3484,3482,3483,3481,3480,3478,3479,3476,3477,3475,3474,3473,3472,3471,3470,3469,3468,3467,3466,3465,3464,3463,3462,3461,3460,3459,3458,3543,3502,3503,3504,3505,3506,3507,3508,3509,3510,3511,3512,3513,3514,3515,3516,3517,3518,3519,3520,3521,3522,3523,3524,3525,3526,3527,3528,3529,3530,3531,3532,3533,3534,3535,3536,3537,3310,3311,3312,3313,3314,3315,3316,3317,3318,3319,3320,3321,3322,3323,3324,3325,3326,3327,3328,3329,3330,3331,3332,3333,3334,3335,3336,3337,3338,3339,3340,3341,3343,3342,3344,3346,3345,3347,3348,3545,4771,5337,3544,4827,27,2,3,4,5,6,7,8,9,10,11,12,13,3555,15,16,17,18,19,20,21,3302,3303,3304,3306,3305,3301,3300,3547,3548,3550,3551,3553,3552,3549,3554,3432,3433,3434,4808,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3418,3419,3420,3421,3422,3423,3424,3425,3426,3427,3365,3366,3367,3368,3369,3370,3371,3372,3373,3374,3375,3376,3377,3378,3379,3380,3381,3382,3383,3384,3385,3386,3387,3388,3389,3391,3390,3392,3393,3394,3395,3396,3397,3398,3399,3400,3401,3402,3403,3404,3405,3406,3407,3362,3363,3364,3361,4825,3354,3355,3356,3357,3358,3359,3360,3353,3351,3352,3349,3350,4826,4778,4290,4896)
ORDER BY NULL
LIMIT 0,1
(this query time : 0.002 s)
(total SQL time  : 0.058 s)
(total time      : 0.102 s)
(num rows        : 1 )
[15] 

INSERT INTO g_history
  (
    date,
    time,
    user_id,
    IP,
    section,
    category_id,
    image_id,
    image_type,
    format_id,
    auth_key_id,
    tag_ids
  )
  VALUES
  (
    CURRENT_DATE,
    CURRENT_TIME,
    2,
    '54.81.150.27',
    'tags',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    '8'
  )
;
(this query time : 0.000 s)
(total SQL time  : 0.058 s)
(total time      : 0.106 s)
(affected rows   : 1 )