Exclude Categories


















  • Sort order
  • slideshow
  • display all photos in all sub-albums
  • return to normal view mode
  • Add all photos of this album to a collection

Home / Models / Mastasia 4

View: Monthly list

Post date / 2016 / February

29
Live Curated BBW Cams
[1] 
SELECT @@SESSION.sql_mode
(this query time : 0.000 s)
(total SQL time  : 0.000 s)
(total time      : 0.001 s)
(num rows        : 1 )
[2] 

SELECT param, value
 FROM p_config
 
;
(this query time : 0.000 s)
(total SQL time  : 0.000 s)
(total time      : 0.001 s)
(num rows        : 161 )
[3] 

SELECT data
  FROM p_sessions
  WHERE id = '0391jb3ia131g3e3rk7hmndlj400m2'
;
(this query time : 0.000 s)
(total SQL time  : 0.000 s)
(total time      : 0.001 s)
(num rows        : 0 )
[4] 

SELECT * FROM p_plugins
  WHERE state='active'
(this query time : 0.000 s)
(total SQL time  : 0.000 s)
(total time      : 0.001 s)
(num rows        : 17 )
[5] 
SELECT state FROM p_plugins WHERE id = 'PWG_Stuffs';
(this query time : 0.000 s)
(total SQL time  : 0.000 s)
(total time      : 0.001 s)
(num rows        : 1 )
[6] 
SELECT state FROM p_plugins WHERE id = 'community';
(this query time : 0.000 s)
(total SQL time  : 0.000 s)
(total time      : 0.001 s)
(num rows        : 1 )
[7] 

SELECT
    image_id,
    date_available,
    NOW() AS dbnow
  FROM p_lounge
    JOIN p_images ON image_id = id
  ORDER BY image_id ASC
  LIMIT 1
;
(this query time : 0.000 s)
(total SQL time  : 0.000 s)
(total time      : 0.001 s)
(num rows        : 0 )
[8] 

SELECT id AS id
     , username AS username
     , password AS password
     , mail_address AS email
  FROM p_users
  WHERE id = '2'
(this query time : 0.000 s)
(total SQL time  : 0.000 s)
(total time      : 0.002 s)
(num rows        : 1 )
[9] 

SELECT
    ui.*,
    uc.*,
    t.name AS theme_name
  FROM p_user_infos AS ui
    LEFT JOIN p_user_cache AS uc ON ui.user_id = uc.user_id
    LEFT JOIN p_themes AS t ON t.id = ui.theme
  WHERE ui.user_id = 2
;
(this query time : 0.000 s)
(total SQL time  : 0.000 s)
(total time      : 0.002 s)
(num rows        : 1 )
[10] 

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

SELECT *
  FROM p_categories
  WHERE id = 1209
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)
(total time      : 0.002 s)
(num rows        : 1 )
[12] 

  SELECT id, name, permalink
    FROM p_categories
    WHERE id IN (14,1209)
  ;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)
(total time      : 0.002 s)
(num rows        : 2 )
[11] 

SELECT DISTINCT(id)
  FROM p_categories
  WHERE uppercats REGEXP '(^|,)1209(,|$)'
;
(this query time : 0.002 s)
(total SQL time  : 0.002 s)
(total time      : 0.004 s)
(num rows        : 1 )

[0.004 s, 11 queries] : start initialize_calendar

[12] 

SELECT DISTINCT(YEAR(date_available)) as period,
  COUNT(DISTINCT id) as nb_images FROM p_images
INNER JOIN p_image_category ON id = image_id
WHERE category_id IN (1209)
    AND (level<=0) AND date_available IS NOT NULL
  GROUP BY period;
(this query time : 0.000 s)
(total SQL time  : 0.003 s)
(total time      : 0.004 s)
(num rows        : 1 )
[13] 

SELECT DISTINCT(MONTH(date_available)) as period,
  COUNT(DISTINCT id) as nb_images FROM p_images
INNER JOIN p_image_category ON id = image_id
WHERE category_id IN (1209)
    AND (level<=0) AND date_available BETWEEN '2016-01-01' AND '2016-12-31 23:59:59'
  GROUP BY period;
(this query time : 0.002 s)
(total SQL time  : 0.004 s)
(total time      : 0.006 s)
(num rows        : 1 )
[14] 

SELECT DISTINCT(DAYOFMONTH(date_available)) as period,
  COUNT(DISTINCT id) as nb_images FROM p_images
INNER JOIN p_image_category ON id = image_id
WHERE category_id IN (1209)
    AND (level<=0) AND date_available BETWEEN '2016-02-01' AND '2016-02-29 23:59:59'
  GROUP BY period;
(this query time : 0.000 s)
(total SQL time  : 0.004 s)
(total time      : 0.006 s)
(num rows        : 1 )
[15] 
SELECT CONCAT_WS('-',YEAR(date_available),MONTH(date_available)) AS period FROM p_images
INNER JOIN p_image_category ON id = image_id
WHERE category_id IN (1209)
    AND (level<=0)
AND date_available IS NOT NULL
GROUP BY period
(this query time : 0.000 s)
(total SQL time  : 0.004 s)
(total time      : 0.006 s)
(num rows        : 1 )
[16] 
SELECT DISTINCT id  FROM p_images
INNER JOIN p_image_category ON id = image_id
WHERE category_id IN (1209)
    AND (level<=0)
   AND date_available BETWEEN '2016-02-01' AND '2016-02-29 23:59:59'
  ORDER BY date_available ASC, date_available DESC
(this query time : 0.000 s)
(total SQL time  : 0.005 s)
(total time      : 0.006 s)
(num rows        : 4 )

[0.006 s, 16 queries] : end initialize_calendar

[17] 
SELECT group_id FROM p_user_group WHERE user_id = 2;
(this query time : 0.000 s)
(total SQL time  : 0.005 s)
(total time      : 0.007 s)
(num rows        : 0 )
[18] 

SELECT DISTINCT id, name, path, datas, `groups`, show_title, id_line, width
FROM p_stuffs
LEFT JOIN p_user_group
  ON user_id = 2
WHERE (users IS NULL OR users LIKE "%guest%")
  AND (`groups` IS NULL OR `groups` REGEXP CONCAT("(^|,)",group_id,"(,|$)"))
  AND level <= 0
  AND on_cats = "true"
ORDER BY pos ASC
;
(this query time : 0.000 s)
(total SQL time  : 0.005 s)
(total time      : 0.007 s)
(num rows        : 1 )
[19] 
SELECT DISTINCT id, title, permalink
FROM p_additionalpages
LEFT JOIN p_user_group
  ON user_id = 2
WHERE (lang IS NULL OR lang = "en_US")
  AND (users IS NULL OR users LIKE "%guest%")
  AND (`groups` IS NULL OR `groups` REGEXP CONCAT("(^|,)",group_id,"(,|$)"))
  AND level <= 0
  AND pos >= 0
ORDER BY pos ASC
;
(this query time : 0.000 s)
(total SQL time  : 0.005 s)
(total time      : 0.007 s)
(num rows        : 4 )
[20] 

SELECT *
  FROM p_images
  WHERE id IN (69137,69138,69139,69140)
;
(this query time : 0.000 s)
(total SQL time  : 0.005 s)
(total time      : 0.620 s)
(num rows        : 4 )
[21] 

SELECT image_id, COUNT(*) AS nb_comments
  FROM p_comments
  WHERE validated = 'true'
    AND image_id IN (69137,69138,69139,69140)
  GROUP BY image_id
;
(this query time : 0.000 s)
(total SQL time  : 0.005 s)
(total time      : 0.620 s)
(num rows        : 2 )
[22] 

SELECT SUBDATE(CURRENT_DATE,INTERVAL 7 DAY)
(this query time : 0.000 s)
(total SQL time  : 0.005 s)
(total time      : 0.620 s)
(num rows        : 1 )

[0.830 s, 22 queries] : end include/category_default.inc.php

[23] 

UPDATE p_user_infos
  SET last_visit = NOW(),
      lastmodified = lastmodified
  WHERE user_id = 2

(this query time : 0.000 s)
(total SQL time  : 0.006 s)
(total time      : 1.461 s)
(affected rows   : 1 )