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