[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 piwigo_config
;
(this query time : 0.000 s)
(total SQL time : 0.000 s)
(total time : 0.001 s)
(num rows : 94 )
[3]
SELECT data
FROM piwigo_sessions
WHERE id = '12E0tb6oe3md54hecrfrb2v0euitp7'
;
(this query time : 0.000 s)
(total SQL time : 0.000 s)
(total time : 0.001 s)
(num rows : 0 )
[4]
SELECT * FROM piwigo_plugins
WHERE state='active'
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.001 s)
(num rows : 2 )
[5]
SELECT
image_id,
date_available,
NOW() AS dbnow
FROM piwigo_lounge
JOIN piwigo_images ON image_id = id
ORDER BY image_id ASC
LIMIT 1
;
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.002 s)
(num rows : 0 )
[6]
SELECT id AS id
, username AS username
, password AS password
, mail_address AS email
FROM piwigo_users
WHERE id = '2'
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.002 s)
(num rows : 1 )
[7]
SELECT
ui.*,
uc.*,
t.name AS theme_name
FROM piwigo_user_infos AS ui
LEFT JOIN piwigo_user_cache AS uc ON ui.user_id = uc.user_id
LEFT JOIN piwigo_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.002 s)
(num rows : 1 )
[8]
SELECT *
FROM piwigo_user_infos
WHERE user_id = 2
;
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.002 s)
(num rows : 1 )
[9]
SELECT id, name, uppercats, global_rank
FROM piwigo_categories
;
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.004 s)
(num rows : 1 )
[10]
SELECT id, name, permalink
FROM piwigo_categories
;
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.004 s)
(num rows : 1 )
[11]
SELECT SQL_CALC_FOUND_ROWS com.id AS comment_id,
com.image_id,
ic.category_id,
com.author,
com.author_id,
u.mail_address AS user_email,
com.email,
com.date,
com.website_url,
com.content,
com.validated
FROM piwigo_image_category AS ic
INNER JOIN piwigo_comments AS com
ON ic.image_id = com.image_id
LEFT JOIN piwigo_users As u
ON u.id = com.author_id
WHERE 1=1
AND validated='true'
AND 1 = 1
GROUP BY comment_id
ORDER BY date DESC
LIMIT 10 OFFSET 0
;
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.004 s)
(num rows : 0 )
[12]
SELECT FOUND_ROWS()
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.004 s)
(num rows : 1 )
[13]
SELECT
id, name, permalink, nb_images, global_rank,
date_last, max_date_last, count_images, count_categories
FROM piwigo_categories INNER JOIN piwigo_user_cache_categories
ON id = cat_id and user_id = 2
WHERE
(id_uppercat is NULL)
;
(this query time : 0.000 s)
(total SQL time : 0.002 s)
(total time : 0.004 s)
(num rows : 1 )
[14]
SELECT SUBDATE(CURRENT_DATE,INTERVAL 7 DAY)
(this query time : 0.000 s)
(total SQL time : 0.002 s)
(total time : 0.004 s)
(num rows : 1 )
[15]
SELECT *
FROM piwigo_tags
WHERE id IN (1,2,3,4)
(this query time : 0.000 s)
(total SQL time : 0.002 s)
(total time : 0.005 s)
(num rows : 4 )
[16]
SELECT param, value
FROM piwigo_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.000 s)
(total SQL time : 0.002 s)
(total time : 0.007 s)
(num rows : 1 )