[1]
SELECT @@SESSION.sql_mode
(this query time : 0.001 s)
(total SQL time : 0.001 s)
(total time : 0.007 s)
(num rows : 1 )
[2]
SELECT param, value
FROM g_config
;
(this query time : 0.002 s)
(total SQL time : 0.004 s)
(total time : 0.011 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D8495675e0270552f9ebe9d4210a181d9d47'
;
(this query time : 0.002 s)
(total SQL time : 0.005 s)
(total time : 0.013 s)
(num rows : 1 )
[4]
SELECT * FROM g_plugins
WHERE state='active'
(this query time : 0.001 s)
(total SQL time : 0.007 s)
(total time : 0.015 s)
(num rows : 9 )
[5]
SELECT
image_id,
date_available,
NOW() AS dbnow
FROM g_lounge
JOIN g_images ON image_id = id
ORDER BY image_id ASC
LIMIT 1
;
(this query time : 0.002 s)
(total SQL time : 0.008 s)
(total time : 0.024 s)
(num rows : 0 )
[6]
SELECT id AS id
, username AS username
, password AS password
, mail_address AS email
FROM g_users
WHERE id = '2'
(this query time : 0.002 s)
(total SQL time : 0.010 s)
(total time : 0.025 s)
(num rows : 1 )
[7]
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.002 s)
(total SQL time : 0.012 s)
(total time : 0.028 s)
(num rows : 1 )
[8]
SELECT *
FROM g_user_infos
WHERE user_id = 2
;
(this query time : 0.002 s)
(total SQL time : 0.014 s)
(total time : 0.030 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (3366)
(this query time : 0.002 s)
(total SQL time : 0.015 s)
(total time : 0.045 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 (3366)
AND (category_id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212) AND level<=0)
GROUP BY id
ORDER BY date_creation DESC, file ASC, id ASC
(this query time : 0.020 s)
(total SQL time : 0.034 s)
(total time : 0.065 s)
(num rows : 368 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 12213
;
(this query time : 0.002 s)
(total SQL time : 0.036 s)
(total time : 0.068 s)
(affected rows : 1 )
[11]
SELECT id,uppercats,commentable,visible,status,global_rank
FROM g_image_category
INNER JOIN g_categories ON category_id = id
WHERE image_id = 12213
AND (id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212))
;
(this query time : 0.002 s)
(total SQL time : 0.038 s)
(total time : 0.070 s)
(num rows : 3 )
[12]
SELECT *
FROM g_images
WHERE id IN (12213,12214,33658,12212,5006)
;
(this query time : 0.002 s)
(total SQL time : 0.040 s)
(total time : 0.072 s)
(num rows : 5 )
[13]
SELECT t.*, count(*) AS counter
FROM g_image_tag
INNER JOIN g_tags t ON tag_id = id
WHERE image_id IN (12213)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.002 s)
(total SQL time : 0.042 s)
(total time : 0.089 s)
(num rows : 7 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (122,863,107,366,100,215)
(this query time : 0.002 s)
(total SQL time : 0.043 s)
(total time : 0.091 s)
(num rows : 6 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 12213 AND validated = 'true'
;
(this query time : 0.001 s)
(total SQL time : 0.045 s)
(total time : 0.100 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (33658,33659,33492,33491,33262,33259,33263,32998,32932,32935,32879,32210,32224,32225,32226,32227,32228,32229,32230,32166,32110,32108,32109,31836,31837,31838,31839,31840,31841,31842,31843,31844,31845,31710,31708,31559,31515,31528,31529,31438,31437,31301,31419,30925,30924,30805,30804,30807,30803,30802,30801,30800,30527,30525,30524,30526,30523,30201,29748,29655,29656,29484,29485,29486,29487,29251,29253,29254,28904,28903,28748,28229,28228,28227,28225,28226,28224,28230,28222,28107,27660,27658,27657,27496,27495,27494,26989,26990,26991,26900,26899,26861,26834,26833,26832,26574,26578,26579,26580,26581,26583,26582,26584,26291,26292,26293,26294,26122,26121,26120,26119,26055,26054,26053,26052,26050,25898,25897,25896,25899,25894,25648,25649,25650,25652,25651,25653,25446,25445,25178,25082,24787,24628,24623,24622,24621,24620,24619,24415,24411,24333,24332,24241,24240,24204,24039,23734,23729,23690,23682,23683,23684,23552,23551,23362,23361,23360,23247,23206,23205,23204,23203,21779,21778,21776,21777,21775,21773,21774,21772,21693,21692,21691,21690,21689,21687,21686,21685,21684,21683,21682,21662,21527,21345,20873,20747,20711,20709,20574,20573,20179,20168,20166,20099,19962,19968,19965,19964,19960,19959,19955,19953,19958,19612,19611,19610,19447,19449,19442,19440,19441,19443,19444,19373,19394,19374,19357,19259,19162,19118,19115,19114,18827,18824,18826,18751,18749,18746,18510,18700,18699,18698,18697,18695,18635,18634,18633,18629,18628,18451,18237,17974,17965,17958,17537,17158,16978,16977,16979,16982,16983,16981,16984,16985,16986,16987,16989,16863,16866,16703,16702,16701,16591,16596,16335,15415,11761,10809,10810,10428,9687,9688,9686,9689,9690,9691,9648,9650,9649,9652,9038,9039,9040,9004,8708,8709,8721,8722,8631,8632,8353,8354,8343,8344,8345,8346,8348,8073,8074,6062,6100,6101,6102,6103,6023,6010,12229,30903,12228,30732,12227,12226,12225,12224,12223,12222,12221,12220,12219,12218,12217,12216,12215,12214,12213,12212,12211,12210,12209,12208,12207,12206,12204,12205,12203,12202,12200,12201,7798,7811,7425,10915,10916,10917,10918,10919,10920,10922,5128,5126,5127,4958,4955,4956,4953,4954,5261,5321,5319,5318,5316,5309,5308,5307,5305,5306,5304,5006)
ORDER BY FIELD(id, 33658,33659,33492,33491,33262,33259,33263,32998,32932,32935,32879,32210,32224,32225,32226,32227,32228,32229,32230,32166,32110,32108,32109,31836,31837,31838,31839,31840,31841,31842,31843,31844,31845,31710,31708,31559,31515,31528,31529,31438,31437,31301,31419,30925,30924,30805,30804,30807,30803,30802,30801,30800,30527,30525,30524,30526,30523,30201,29748,29655,29656,29484,29485,29486,29487,29251,29253,29254,28904,28903,28748,28229,28228,28227,28225,28226,28224,28230,28222,28107,27660,27658,27657,27496,27495,27494,26989,26990,26991,26900,26899,26861,26834,26833,26832,26574,26578,26579,26580,26581,26583,26582,26584,26291,26292,26293,26294,26122,26121,26120,26119,26055,26054,26053,26052,26050,25898,25897,25896,25899,25894,25648,25649,25650,25652,25651,25653,25446,25445,25178,25082,24787,24628,24623,24622,24621,24620,24619,24415,24411,24333,24332,24241,24240,24204,24039,23734,23729,23690,23682,23683,23684,23552,23551,23362,23361,23360,23247,23206,23205,23204,23203,21779,21778,21776,21777,21775,21773,21774,21772,21693,21692,21691,21690,21689,21687,21686,21685,21684,21683,21682,21662,21527,21345,20873,20747,20711,20709,20574,20573,20179,20168,20166,20099,19962,19968,19965,19964,19960,19959,19955,19953,19958,19612,19611,19610,19447,19449,19442,19440,19441,19443,19444,19373,19394,19374,19357,19259,19162,19118,19115,19114,18827,18824,18826,18751,18749,18746,18510,18700,18699,18698,18697,18695,18635,18634,18633,18629,18628,18451,18237,17974,17965,17958,17537,17158,16978,16977,16979,16982,16983,16981,16984,16985,16986,16987,16989,16863,16866,16703,16702,16701,16591,16596,16335,15415,11761,10809,10810,10428,9687,9688,9686,9689,9690,9691,9648,9650,9649,9652,9038,9039,9040,9004,8708,8709,8721,8722,8631,8632,8353,8354,8343,8344,8345,8346,8348,8073,8074,6062,6100,6101,6102,6103,6023,6010,12229,30903,12228,30732,12227,12226,12225,12224,12223,12222,12221,12220,12219,12218,12217,12216,12215,12214,12213,12212,12211,12210,12209,12208,12207,12206,12204,12205,12203,12202,12200,12201,7798,7811,7425,10915,10916,10917,10918,10919,10920,10922,5128,5126,5127,4958,4955,4956,4953,4954,5261,5321,5319,5318,5316,5309,5308,5307,5305,5306,5304,5006)
;
(this query time : 0.023 s)
(total SQL time : 0.068 s)
(total time : 0.129 s)
(num rows : 368 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.069 s)
(total time : 0.326 s)
(num rows : 1 )