[1]
SELECT @@SESSION.sql_mode
(this query time : 0.001 s)
(total SQL time : 0.001 s)
(total time : 0.005 s)
(num rows : 1 )
[2]
SELECT param, value
FROM g_config
;
(this query time : 0.005 s)
(total SQL time : 0.005 s)
(total time : 0.010 s)
(num rows : 126 )
[3]
SELECT data
FROM g_sessions
WHERE id = 'D84994c5865d4976d8574ea7a73ebc1a7e53'
;
(this query time : 0.001 s)
(total SQL time : 0.006 s)
(total time : 0.024 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.025 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.001 s)
(total SQL time : 0.008 s)
(total time : 0.029 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.001 s)
(total SQL time : 0.009 s)
(total time : 0.030 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.009 s)
(total time : 0.031 s)
(num rows : 1 )
[8]
SELECT *
FROM g_user_infos
WHERE user_id = 2
;
(this query time : 0.001 s)
(total SQL time : 0.010 s)
(total time : 0.032 s)
(num rows : 1 )
[9]
SELECT *
FROM g_tags
WHERE id IN (17995)
(this query time : 0.001 s)
(total SQL time : 0.011 s)
(total time : 0.039 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 (17995)
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.011 s)
(total SQL time : 0.021 s)
(total time : 0.049 s)
(num rows : 418 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 29917
;
(this query time : 0.001 s)
(total SQL time : 0.022 s)
(total time : 0.051 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 = 29917
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.023 s)
(total time : 0.052 s)
(num rows : 1 )
[12]
SELECT *
FROM g_images
WHERE id IN (29917,29919,33279,29912,22079)
;
(this query time : 0.001 s)
(total SQL time : 0.024 s)
(total time : 0.053 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 (29917)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.002 s)
(total SQL time : 0.026 s)
(total time : 0.063 s)
(num rows : 46 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,855,869)
(this query time : 0.001 s)
(total SQL time : 0.026 s)
(total time : 0.064 s)
(num rows : 3 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 29917 AND validated = 'true'
;
(this query time : 0.001 s)
(total SQL time : 0.027 s)
(total time : 0.068 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (33279,32467,32454,32409,32395,32383,32354,32218,32222,32253,32263,32322,32324,32152,32154,32141,31931,31938,31942,31948,31954,31957,31964,31966,31967,31968,31971,31970,31907,31902,31900,31879,31874,31795,31822,31840,31841,31844,31848,31854,31858,31860,31861,31869,31792,31790,31789,31786,31783,31781,31778,31774,31765,31763,31762,31757,31756,31735,31732,31728,31727,31724,31722,31719,31712,31667,31671,31676,31679,31680,31683,31699,31704,31705,31658,31656,31655,31654,31646,31633,31629,31628,31620,31615,31614,31612,31611,31604,31596,31597,31598,31599,31600,31601,31592,31576,31582,31583,31584,31590,31588,31569,31564,31562,31561,31560,31555,31546,31545,31542,31539,31540,31541,31451,31452,31454,31455,31456,31471,31478,31482,31488,31489,31495,31497,31500,31502,31514,31517,31523,31527,31532,31534,31445,31537,31444,31441,31263,31265,31431,31272,31271,31273,31294,31299,31302,31305,31208,31218,31220,31221,31419,31417,31413,31231,31244,31247,31402,31400,31162,31159,31158,31392,31154,31146,31145,31141,31139,31389,31135,31132,31128,31119,31382,31376,31373,31101,31082,31355,31072,31060,31041,30986,30981,30977,30974,30973,30966,30960,30953,30929,30811,30806,30794,30793,30790,30783,30780,30778,30756,30750,30625,30616,30607,30597,30588,30577,30574,30569,30533,30532,30512,30511,30509,30510,30501,30496,30462,30464,30470,30492,30418,30425,30431,30432,30438,30440,30453,30454,30412,30097,30104,30114,30138,30140,30173,30187,30188,30192,30203,30208,30209,30096,30092,30091,30084,30083,30074,30070,30037,30045,30055,30056,30246,30248,30249,30029,30015,30017,29963,29960,29939,29935,29933,29919,29917,29912,29904,29896,29872,29875,29890,29885,29820,29816,29832,29756,29767,29680,29682,29668,29614,29623,29636,29591,29536,29505,29508,29467,29470,29481,29503,29424,29427,29429,29436,29437,29440,29443,29445,29446,29448,29455,29461,29460,29413,29414,29420,29403,29388,29390,29393,29394,29396,29298,29297,29312,29320,29321,29156,29166,29168,29169,29173,29196,29202,29204,29213,29131,29040,28991,28996,28997,29000,29007,29012,29014,28984,28957,28956,28901,28892,28886,28883,28797,28768,28769,28770,28790,28752,28736,28750,28723,28721,28717,28716,28713,28711,28697,28696,28690,28688,28682,28680,28678,28677,28662,28661,28660,28656,28648,28645,28644,28643,28641,28634,28624,28625,28618,28605,28593,28594,28580,28563,28562,28557,28539,28538,28537,28536,28535,28529,28528,28525,28524,28523,28487,28482,28476,28460,28455,28454,28453,28443,28441,28420,28416,28398,28389,28360,28359,28358,28361,28340,28322,28321,28316,22079)
ORDER BY FIELD(id, 33279,32467,32454,32409,32395,32383,32354,32218,32222,32253,32263,32322,32324,32152,32154,32141,31931,31938,31942,31948,31954,31957,31964,31966,31967,31968,31971,31970,31907,31902,31900,31879,31874,31795,31822,31840,31841,31844,31848,31854,31858,31860,31861,31869,31792,31790,31789,31786,31783,31781,31778,31774,31765,31763,31762,31757,31756,31735,31732,31728,31727,31724,31722,31719,31712,31667,31671,31676,31679,31680,31683,31699,31704,31705,31658,31656,31655,31654,31646,31633,31629,31628,31620,31615,31614,31612,31611,31604,31596,31597,31598,31599,31600,31601,31592,31576,31582,31583,31584,31590,31588,31569,31564,31562,31561,31560,31555,31546,31545,31542,31539,31540,31541,31451,31452,31454,31455,31456,31471,31478,31482,31488,31489,31495,31497,31500,31502,31514,31517,31523,31527,31532,31534,31445,31537,31444,31441,31263,31265,31431,31272,31271,31273,31294,31299,31302,31305,31208,31218,31220,31221,31419,31417,31413,31231,31244,31247,31402,31400,31162,31159,31158,31392,31154,31146,31145,31141,31139,31389,31135,31132,31128,31119,31382,31376,31373,31101,31082,31355,31072,31060,31041,30986,30981,30977,30974,30973,30966,30960,30953,30929,30811,30806,30794,30793,30790,30783,30780,30778,30756,30750,30625,30616,30607,30597,30588,30577,30574,30569,30533,30532,30512,30511,30509,30510,30501,30496,30462,30464,30470,30492,30418,30425,30431,30432,30438,30440,30453,30454,30412,30097,30104,30114,30138,30140,30173,30187,30188,30192,30203,30208,30209,30096,30092,30091,30084,30083,30074,30070,30037,30045,30055,30056,30246,30248,30249,30029,30015,30017,29963,29960,29939,29935,29933,29919,29917,29912,29904,29896,29872,29875,29890,29885,29820,29816,29832,29756,29767,29680,29682,29668,29614,29623,29636,29591,29536,29505,29508,29467,29470,29481,29503,29424,29427,29429,29436,29437,29440,29443,29445,29446,29448,29455,29461,29460,29413,29414,29420,29403,29388,29390,29393,29394,29396,29298,29297,29312,29320,29321,29156,29166,29168,29169,29173,29196,29202,29204,29213,29131,29040,28991,28996,28997,29000,29007,29012,29014,28984,28957,28956,28901,28892,28886,28883,28797,28768,28769,28770,28790,28752,28736,28750,28723,28721,28717,28716,28713,28711,28697,28696,28690,28688,28682,28680,28678,28677,28662,28661,28660,28656,28648,28645,28644,28643,28641,28634,28624,28625,28618,28605,28593,28594,28580,28563,28562,28557,28539,28538,28537,28536,28535,28529,28528,28525,28524,28523,28487,28482,28476,28460,28455,28454,28453,28443,28441,28420,28416,28398,28389,28360,28359,28358,28361,28340,28322,28321,28316,22079)
;
(this query time : 0.012 s)
(total SQL time : 0.039 s)
(total time : 0.084 s)
(num rows : 418 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.000 s)
(total SQL time : 0.039 s)
(total time : 0.268 s)
(num rows : 1 )