kewl's gallery

This is not so traditional. I had originally planned to bike to Little Switzerland, but not only it was hectic at work, also the weather had been chaotic. This was the only evening it wasn't raining and windy, and I didn't wear adequate clothes to step into the tracks (covered with a layer of mud and another layer of water on top). The color could have been a candidate for week 3 challenge, but I have something else in mind ;)
[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 = '36C64shpt4cahuopapetq1omqjvs87'
;
(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_categories
  WHERE id = 129
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)
(total time      : 0.006 s)
(num rows        : 1 )
[10] 

  SELECT id, name, permalink
    FROM g_categories
    WHERE id IN (126,127,129)
  ;
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.007 s)
(num rows        : 3 )
[9] 

SELECT DISTINCT(image_id)
  FROM g_image_category
    INNER JOIN g_images ON id = image_id
  WHERE
    category_id = 129
AND (category_id NOT IN (188,201,198,200,182,212) AND level<=0)
  ORDER BY date_creation DESC, file ASC, id ASC
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)
(total time      : 0.007 s)
(num rows        : 3 )
[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.002 s)
(total time      : 0.007 s)
(num rows        : 102 )
[11] 

SELECT SUBDATE(CURRENT_DATE,INTERVAL 30 DAY)
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.008 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 (4029,4025,4027)
  GROUP BY t.id
  ORDER BY counter DESC
  LIMIT 12
(this query time : 0.001 s)
(total SQL time  : 0.002 s)
(total time      : 0.011 s)
(num rows        : 12 )
[13] 

SELECT *
  FROM g_images
  WHERE id IN (4029,4025,4027)
;
(this query time : 0.000 s)
(total SQL time  : 0.003 s)
(total time      : 0.013 s)
(num rows        : 3 )

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

[14] 

SELECT id FROM g_images
WHERE latitude IS NOT NULL
  AND id IN (4029,4025,4027)
ORDER BY NULL
LIMIT 0,1
(this query time : 0.000 s)
(total SQL time  : 0.003 s)
(total time      : 0.015 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',
    'categories',
    129,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
  )
;
(this query time : 0.000 s)
(total SQL time  : 0.003 s)
(total time      : 0.016 s)
(affected rows   : 1 )