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 = '36C69qj1p4ago7l5juj9hpn6h9ul02'
;
(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.004 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.004 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.001 s)
(total time      : 0.005 s)
(num rows        : 1 )
[9] 

SELECT *
  FROM g_tags
  WHERE id IN (391)
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.006 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 (391)
  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.002 s)
(total SQL time  : 0.004 s)
(total time      : 0.008 s)
(num rows        : 380 )
[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.004 s)
(total time      : 0.009 s)
(num rows        : 102 )
[11] 

SELECT SUBDATE(CURRENT_DATE,INTERVAL 30 DAY)
(this query time : 0.000 s)
(total SQL time  : 0.004 s)
(total time      : 0.009 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 (6059,6058,6032,6040,6038,6033,6048,6049,6050,6052,6220,6212,6210,6208,6203,6202,6200,6196,6195,6193,6188,6186,6183,6181,6176,6168,6165,6161,6162,6154,6147,6135,6136,6126,6123,6169,6119,6118,6020,6010,5990,5994,5996,5988,5983,5941,5935,5936,5928,5925,5926,5927,5922,5923,5918,5847,5848,5854,5839,5832,5740,5741,5742,5745,5752,5755,5720,5727,5729,5734,5735,5758,5762,5764,5768,5787,5796,5798,5799,5800,5803,5804,5807,5811,5813,5810,5816,5379,5380,5387,5385,5383,5390,5391,5396,5397,5394,5395,5405,5402,5409,5416,5413,5414,5424,5436,5440,5474,5473,5471,5469,5454,5466,5465,5470,5696,5694,5691,5690,5646,5647,5664,5665,5565,5561,5569,5559,5555,5554,5557,5547,5523,5519,5486,5292,5300,5286,5287,5285,5284,5282,5278,5275,5276,5271,5270,5142,5139,5140,5136,5137,5134,5129,5126,5124,5079,5122,5117,5115,5110,5090,5091,5086,4979,5479,5480,5478,4937,4938,4936,4935,4933,4934,4932,4931,4930,4941,4939,4940,4947,4974,4970,4968,4966,4965,4964,4962,4960,4961,5047,5048,5045,5044,4984,5143,5151,5152,5150,5148,5146,5153,5158,5154,5162,5167,5164,5178,5180,5181,5179,5191,5192,5190,5193,5194,5214,5213,5210,5208,5206,5199,5223,5224,5222,5219,5230,5231,5229,5235,5245,5246,5251,5323,5319,5312,5304,4870,5227,5228,5354,5353,5344,5342,5355,5331,5356,5363,5360,5370,5366,5364,5375,5372,5374,5376,5377,5900,5912,5895,4832,4830,5710,5716,5718,4829,4831,4786,4793,4775,4749,4747,4748,4745,4744,4815,4738,4735,5330,4755,4823,4817,4816,4581,4580,4597,4598,4595,4596,4589,4587,4586,4602,4601,4604,4773,5326,4577,5008,4992,4990,4994,4548,4547,4544,4546,4545,4538,4537,4534,4542,4543,4532,4528,4529,4530,4467,4466,4498,4496,4307,4306,4305,4304,4354,4287,4288,4272,4271,4268,4266,4280,4279,4285,4552,4551,4550,4254,4255,4253,4256,4549,4252,4239,4223,4222,4245,4244,4217,4216,4205,4204,4215,4211,4208,4183,4190,4247,4246,4250,4248,4249,4094,4029,4025,4027,3997,3872,3871,3869,3818,3802,3794,3777,3770,3763,3759,3707,3543,3300,4833)
    AND tag_id NOT IN (391)
  GROUP BY t.id
  ORDER BY counter DESC
  LIMIT 20
(this query time : 0.016 s)
(total SQL time  : 0.020 s)
(total time      : 0.027 s)
(num rows        : 20 )
[13] 

SELECT *
  FROM g_images
  WHERE id IN (6059,6058,6032,6040,6038,6033,6048,6049,6050,6052,6220,6212,6210,6208,6203,6202,6200,6196,6195,6193,6188,6186,6183,6181,6176,6168,6165,6161,6162,6154,6147,6135,6136,6126,6123,6169,6119,6118,6020,6010,5990,5994,5996,5988,5983,5941,5935,5936,5928,5925,5926,5927,5922,5923,5918,5847,5848,5854,5839,5832,5740,5741,5742,5745,5752,5755,5720,5727,5729,5734,5735,5758,5762,5764,5768,5787,5796,5798,5799,5800,5803,5804,5807,5811,5813,5810,5816,5379,5380,5387,5385,5383,5390,5391,5396,5397,5394,5395,5405,5402,5409,5416,5413,5414,5424,5436,5440,5474,5473,5471,5469,5454,5466,5465,5470,5696,5694,5691,5690,5646,5647,5664,5665,5565,5561,5569,5559,5555,5554,5557,5547,5523,5519,5486,5292,5300,5286,5287,5285,5284,5282,5278,5275,5276,5271,5270,5142,5139,5140,5136,5137,5134,5129,5126,5124,5079,5122,5117,5115,5110,5090,5091,5086,4979,5479,5480,5478,4937,4938,4936,4935,4933,4934,4932,4931,4930,4941,4939,4940,4947,4974,4970,4968,4966,4965,4964,4962,4960,4961,5047,5048,5045,5044,4984,5143,5151,5152,5150,5148,5146,5153,5158,5154,5162,5167,5164,5178,5180,5181,5179,5191,5192,5190,5193,5194,5214,5213,5210,5208,5206,5199,5223,5224,5222,5219,5230,5231,5229,5235,5245,5246,5251,5323,5319,5312,5304,4870,5227,5228,5354,5353,5344,5342,5355,5331,5356,5363,5360,5370,5366,5364,5375,5372,5374,5376,5377,5900,5912,5895,4832,4830,5710,5716,5718,4829,4831,4786,4793,4775,4749,4747,4748,4745,4744,4815,4738,4735,5330,4755,4823,4817,4816,4581,4580,4597,4598,4595,4596,4589,4587,4586,4602,4601,4604,4773,5326,4577,5008,4992,4990,4994,4548,4547,4544,4546,4545,4538,4537,4534,4542,4543,4532,4528,4529,4530,4467,4466,4498,4496,4307,4306,4305,4304,4354,4287,4288,4272,4271,4268,4266,4280,4279,4285,4552,4551,4550,4254,4255,4253,4256,4549,4252,4239,4223,4222,4245,4244,4217,4216,4205,4204,4215,4211,4208,4183,4190,4247,4246,4250,4248,4249,4094,4029,4025,4027,3997,3872,3871,3869,3818,3802,3794,3777,3770,3763,3759,3707,3543,3300,4833)
;
(this query time : 0.003 s)
(total SQL time  : 0.022 s)
(total time      : 0.032 s)
(num rows        : 380 )

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

[14] 

SELECT id FROM g_images
WHERE latitude IS NOT NULL
  AND id IN (6059,6058,6032,6040,6038,6033,6048,6049,6050,6052,6220,6212,6210,6208,6203,6202,6200,6196,6195,6193,6188,6186,6183,6181,6176,6168,6165,6161,6162,6154,6147,6135,6136,6126,6123,6169,6119,6118,6020,6010,5990,5994,5996,5988,5983,5941,5935,5936,5928,5925,5926,5927,5922,5923,5918,5847,5848,5854,5839,5832,5740,5741,5742,5745,5752,5755,5720,5727,5729,5734,5735,5758,5762,5764,5768,5787,5796,5798,5799,5800,5803,5804,5807,5811,5813,5810,5816,5379,5380,5387,5385,5383,5390,5391,5396,5397,5394,5395,5405,5402,5409,5416,5413,5414,5424,5436,5440,5474,5473,5471,5469,5454,5466,5465,5470,5696,5694,5691,5690,5646,5647,5664,5665,5565,5561,5569,5559,5555,5554,5557,5547,5523,5519,5486,5292,5300,5286,5287,5285,5284,5282,5278,5275,5276,5271,5270,5142,5139,5140,5136,5137,5134,5129,5126,5124,5079,5122,5117,5115,5110,5090,5091,5086,4979,5479,5480,5478,4937,4938,4936,4935,4933,4934,4932,4931,4930,4941,4939,4940,4947,4974,4970,4968,4966,4965,4964,4962,4960,4961,5047,5048,5045,5044,4984,5143,5151,5152,5150,5148,5146,5153,5158,5154,5162,5167,5164,5178,5180,5181,5179,5191,5192,5190,5193,5194,5214,5213,5210,5208,5206,5199,5223,5224,5222,5219,5230,5231,5229,5235,5245,5246,5251,5323,5319,5312,5304,4870,5227,5228,5354,5353,5344,5342,5355,5331,5356,5363,5360,5370,5366,5364,5375,5372,5374,5376,5377,5900,5912,5895,4832,4830,5710,5716,5718,4829,4831,4786,4793,4775,4749,4747,4748,4745,4744,4815,4738,4735,5330,4755,4823,4817,4816,4581,4580,4597,4598,4595,4596,4589,4587,4586,4602,4601,4604,4773,5326,4577,5008,4992,4990,4994,4548,4547,4544,4546,4545,4538,4537,4534,4542,4543,4532,4528,4529,4530,4467,4466,4498,4496,4307,4306,4305,4304,4354,4287,4288,4272,4271,4268,4266,4280,4279,4285,4552,4551,4550,4254,4255,4253,4256,4549,4252,4239,4223,4222,4245,4244,4217,4216,4205,4204,4215,4211,4208,4183,4190,4247,4246,4250,4248,4249,4094,4029,4025,4027,3997,3872,3871,3869,3818,3802,3794,3777,3770,3763,3759,3707,3543,3300,4833)
ORDER BY NULL
LIMIT 0,1
(this query time : 0.001 s)
(total SQL time  : 0.023 s)
(total time      : 0.066 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.198.103.13',
    'tags',
    NULL,
    NULL,
    NULL,
    NULL,
    NULL,
    '391'
  )
;
(this query time : 0.000 s)
(total SQL time  : 0.024 s)
(total time      : 0.070 s)
(affected rows   : 1 )