[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.001 s)
(total SQL time : 0.001 s)
(total time : 0.003 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D8497ec09a2a5c5e26df3f968172458ceef9'
;
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.004 s)
(num rows : 1 )
[4]
SELECT * FROM g_plugins
WHERE state='active'
(this query time : 0.000 s)
(total SQL time : 0.002 s)
(total time : 0.004 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.000 s)
(total SQL time : 0.002 s)
(total time : 0.007 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.000 s)
(total SQL time : 0.003 s)
(total time : 0.007 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.001 s)
(total SQL time : 0.003 s)
(total time : 0.008 s)
(num rows : 1 )
[8]
SELECT *
FROM g_user_infos
WHERE user_id = 2
;
(this query time : 0.000 s)
(total SQL time : 0.004 s)
(total time : 0.008 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (43,735)
(this query time : 0.001 s)
(total SQL time : 0.004 s)
(total time : 0.013 s)
(num rows : 2 )
[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 (43,735)
AND (category_id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212) AND level<=0)
GROUP BY id
HAVING COUNT(DISTINCT tag_id)=2
ORDER BY name ASC,date_creation DESC, file ASC, id ASC
(this query time : 0.028 s)
(total SQL time : 0.032 s)
(total time : 0.041 s)
(num rows : 542 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 31837
;
(this query time : 0.001 s)
(total SQL time : 0.032 s)
(total time : 0.042 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 = 31837
AND (id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212))
;
(this query time : 0.001 s)
(total SQL time : 0.033 s)
(total time : 0.042 s)
(num rows : 2 )
[12]
SELECT *
FROM g_images
WHERE id IN (31837,31785,31488,31292,32592)
;
(this query time : 0.001 s)
(total SQL time : 0.033 s)
(total time : 0.043 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 (31837)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.001 s)
(total SQL time : 0.034 s)
(total time : 0.048 s)
(num rows : 33 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,871,876,100,215)
(this query time : 0.000 s)
(total SQL time : 0.035 s)
(total time : 0.049 s)
(num rows : 5 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 31837 AND validated = 'true'
;
(this query time : 0.001 s)
(total SQL time : 0.035 s)
(total time : 0.051 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (31488,33192,29391,33286,30542,31373,31522,31425,29864,31466,31813,31430,30530,29568,29639,28968,29665,29868,31504,30067,30467,30822,29105,31264,30092,30037,30211,30040,32152,28721,31533,30019,29634,28680,31110,29616,30023,33332,29931,29767,29733,29298,29938,29928,30950,31710,30203,28999,33356,31273,30823,29825,29832,29296,30113,30017,31761,29714,30792,31461,31419,33331,31910,31529,33092,30927,33428,33401,29766,29773,30038,33454,29837,30979,31080,32217,32180,31868,30066,29532,31101,32431,29048,29312,31247,32277,31564,31840,31158,30899,32380,31924,31543,33453,32128,31907,31401,33496,31925,30584,31295,29582,31021,30753,30981,33430,33266,29919,30493,30913,31042,31537,33346,31413,31945,30980,31116,32151,33141,30462,31153,31052,29622,28678,31843,30970,31154,32378,31774,30469,29057,30781,29796,30612,33355,29820,31440,31812,31798,31887,31502,29656,33507,32898,30804,33512,31286,31304,30944,30106,31065,31432,33495,33427,33273,29183,30916,29944,31964,33700,29858,32699,31135,29220,31546,29192,28711,31657,31729,31719,30020,29164,33272,31400,29154,31053,32701,30425,33205,30086,30951,30461,32311,31785,31837,31292,31554,29883,33347,29163,31545,31308,31278,30790,29010,32690,33334,29723,29805,28723,31058,29187,28884,32715,28531,28441,30789,29411,30069,30126,29569,31458,30812,30918,29658,28953,30930,31298,31713,32341,29851,29909,30074,30593,31066,30795,30809,32585,31145,30949,31144,30196,31307,31057,31302,31442,32546,31359,33216,33317,32271,29906,31371,28530,31751,32283,31848,33134,31584,31063,30207,33426,33158,30806,31583,30472,30041,30039,31159,30920,30473,30583,31382,30195,32149,32852,32318,32235,32214,31055,32279,28796,31877,31221,32928,29503,30826,33279,30808,31782,31444,32218,31227,31370,30484,28998,30767,31279,29125,33321,31443,31288,30816,30800,29506,31445,31582,31301,29336,31486,30769,29596,31712,6574,27789,32960,32578,29475,32977,31926,31505,30967,29840,31886,31429,31303,31262,31282,31231,31388,30036,30519,31517,31463,32434,31404,32312,29753,31450,33353,28747,28316,30197,32155,32153,31512,31946,32853,32638,30815,31056,30958,31599,29590,29528,30045,31050,28675,31767,29106,30192,28661,29317,31490,31941,30082,29108,30788,30982,30926,32284,5039,29950,30250,31459,30475,29901,30191,32273,31534,32717,30013,33132,30625,31223,32280,32697,33270,30588,31500,30058,29637,31270,31113,32263,29816,31075,32310,29852,11109,31078,31858,28715,28712,29000,31773,31272,31541,31544,29495,31155,32278,31787,33211,29091,30988,31146,30208,32381,32593,28792,29964,30770,30042,29905,29040,31386,31627,32319,32872,29885,31467,31585,32450,29505,33271,31220,32338,31433,31431,30969,29768,29871,28360,31374,30490,31950,32353,29808,29056,30925,28895,30966,30518,29147,32243,28528,29191,31503,30569,31156,5790,31136,32132,30803,30987,31271,30810,31538,31105,29299,29382,31114,31287,30965,30758,30611,31082,31389,29003,29536,29534,31022,33517,31126,31521,32461,31825,31819,31656,33609,31064,32268,29535,31421,32270,30173,29941,31775,29956,32220,31844,31115,29922,30032,30581,30633,29613,29886,30594,29398,31619,31701,29136,31704,32871,29162,29132,29538,30994,30802,33338,29599,29910,33499,29682,29200,30532,28662,31709,31799,28618,31836,30827,33349,29948,29135,29153,29123,31610,30783,30976,31218,29802,30977,32494,30778,29531,32281,33569,31501,32592)
ORDER BY FIELD(id, 31488,33192,29391,33286,30542,31373,31522,31425,29864,31466,31813,31430,30530,29568,29639,28968,29665,29868,31504,30067,30467,30822,29105,31264,30092,30037,30211,30040,32152,28721,31533,30019,29634,28680,31110,29616,30023,33332,29931,29767,29733,29298,29938,29928,30950,31710,30203,28999,33356,31273,30823,29825,29832,29296,30113,30017,31761,29714,30792,31461,31419,33331,31910,31529,33092,30927,33428,33401,29766,29773,30038,33454,29837,30979,31080,32217,32180,31868,30066,29532,31101,32431,29048,29312,31247,32277,31564,31840,31158,30899,32380,31924,31543,33453,32128,31907,31401,33496,31925,30584,31295,29582,31021,30753,30981,33430,33266,29919,30493,30913,31042,31537,33346,31413,31945,30980,31116,32151,33141,30462,31153,31052,29622,28678,31843,30970,31154,32378,31774,30469,29057,30781,29796,30612,33355,29820,31440,31812,31798,31887,31502,29656,33507,32898,30804,33512,31286,31304,30944,30106,31065,31432,33495,33427,33273,29183,30916,29944,31964,33700,29858,32699,31135,29220,31546,29192,28711,31657,31729,31719,30020,29164,33272,31400,29154,31053,32701,30425,33205,30086,30951,30461,32311,31785,31837,31292,31554,29883,33347,29163,31545,31308,31278,30790,29010,32690,33334,29723,29805,28723,31058,29187,28884,32715,28531,28441,30789,29411,30069,30126,29569,31458,30812,30918,29658,28953,30930,31298,31713,32341,29851,29909,30074,30593,31066,30795,30809,32585,31145,30949,31144,30196,31307,31057,31302,31442,32546,31359,33216,33317,32271,29906,31371,28530,31751,32283,31848,33134,31584,31063,30207,33426,33158,30806,31583,30472,30041,30039,31159,30920,30473,30583,31382,30195,32149,32852,32318,32235,32214,31055,32279,28796,31877,31221,32928,29503,30826,33279,30808,31782,31444,32218,31227,31370,30484,28998,30767,31279,29125,33321,31443,31288,30816,30800,29506,31445,31582,31301,29336,31486,30769,29596,31712,6574,27789,32960,32578,29475,32977,31926,31505,30967,29840,31886,31429,31303,31262,31282,31231,31388,30036,30519,31517,31463,32434,31404,32312,29753,31450,33353,28747,28316,30197,32155,32153,31512,31946,32853,32638,30815,31056,30958,31599,29590,29528,30045,31050,28675,31767,29106,30192,28661,29317,31490,31941,30082,29108,30788,30982,30926,32284,5039,29950,30250,31459,30475,29901,30191,32273,31534,32717,30013,33132,30625,31223,32280,32697,33270,30588,31500,30058,29637,31270,31113,32263,29816,31075,32310,29852,11109,31078,31858,28715,28712,29000,31773,31272,31541,31544,29495,31155,32278,31787,33211,29091,30988,31146,30208,32381,32593,28792,29964,30770,30042,29905,29040,31386,31627,32319,32872,29885,31467,31585,32450,29505,33271,31220,32338,31433,31431,30969,29768,29871,28360,31374,30490,31950,32353,29808,29056,30925,28895,30966,30518,29147,32243,28528,29191,31503,30569,31156,5790,31136,32132,30803,30987,31271,30810,31538,31105,29299,29382,31114,31287,30965,30758,30611,31082,31389,29003,29536,29534,31022,33517,31126,31521,32461,31825,31819,31656,33609,31064,32268,29535,31421,32270,30173,29941,31775,29956,32220,31844,31115,29922,30032,30581,30633,29613,29886,30594,29398,31619,31701,29136,31704,32871,29162,29132,29538,30994,30802,33338,29599,29910,33499,29682,29200,30532,28662,31709,31799,28618,31836,30827,33349,29948,29135,29153,29123,31610,30783,30976,31218,29802,30977,32494,30778,29531,32281,33569,31501,32592)
;
(this query time : 0.010 s)
(total SQL time : 0.045 s)
(total time : 0.063 s)
(num rows : 542 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.046 s)
(total time : 0.285 s)
(num rows : 1 )