[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 = 'D8491cf9d4550864236ae18f06aac869dc13'
;
(this query time : 0.000 s)
(total SQL time : 0.001 s)
(total time : 0.003 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.000 s)
(total SQL time : 0.003 s)
(total time : 0.006 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 (1253)
(this query time : 0.000 s)
(total SQL time : 0.003 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 (1253)
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.014 s)
(total time : 0.021 s)
(num rows : 962 )
[10]
UPDATE
g_images
SET hit = hit+1, lastmodified = lastmodified
WHERE id = 27706
;
(this query time : 0.001 s)
(total SQL time : 0.014 s)
(total time : 0.022 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 = 27706
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.015 s)
(total time : 0.023 s)
(num rows : 1 )
[12]
SELECT *
FROM g_images
WHERE id IN (27706,27740,33699,27560,4218)
;
(this query time : 0.001 s)
(total SQL time : 0.015 s)
(total time : 0.023 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 (27706)
GROUP BY t.id
ORDER BY NULL
(this query time : 0.001 s)
(total SQL time : 0.016 s)
(total time : 0.027 s)
(num rows : 9 )
[14]
SELECT id, name, permalink
FROM g_categories
WHERE id IN (585,855,864)
(this query time : 0.000 s)
(total SQL time : 0.017 s)
(total time : 0.028 s)
(num rows : 3 )
[15]
SELECT
COUNT(*) AS nb_comments
FROM g_comments
WHERE image_id = 27706 AND validated = 'true'
;
(this query time : 0.002 s)
(total SQL time : 0.018 s)
(total time : 0.032 s)
(num rows : 1 )
[16]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (33699,33704,33701,33697,33696,33695,33589,33591,33596,33598,33595,33614,33615,33657,33663,33671,33586,33555,33556,33563,33565,33566,33570,33571,33525,33501,33536,33498,33494,33492,33486,33475,33474,33473,33471,33469,33470,33466,33385,33387,33388,33391,33405,33409,33432,33438,33445,33446,33455,33458,33460,33462,33330,33359,33358,33367,33369,33371,33249,33277,33291,33293,33294,33120,33124,33133,33137,33142,33154,33157,33160,33186,33203,33205,33208,33212,33225,33067,33077,33032,33037,33042,33054,33056,33090,33105,33109,33110,33111,33025,33013,33011,33005,33004,33001,32998,32988,32982,32980,32977,32976,32973,32962,32903,32904,32906,32917,32927,32939,32947,32875,32869,32866,32865,32861,32860,32859,32840,32839,32832,32826,32820,32816,32809,32808,32807,32804,32794,32793,32790,32789,32787,32786,32775,32756,32755,32754,32751,32750,32749,32748,32744,32743,32742,32741,32760,32762,32766,32771,32772,32740,32739,32737,32726,32723,32694,32688,32685,32677,32675,32674,32673,32672,32666,32657,32651,32625,32621,32611,32601,32600,32597,32587,32586,32583,32579,32573,32580,32571,32523,32522,32519,32514,32511,32503,32499,32496,32481,32465,32453,32451,32449,32429,32426,32425,32424,32420,32417,32382,32348,32354,32202,32207,32209,32215,32219,32250,32275,32185,32184,32183,32177,32195,32166,32165,32146,32133,32132,32100,31920,31928,31929,31933,31934,31937,31947,31970,31905,31901,31900,31897,31896,31895,31894,31893,31892,31891,31890,31889,31884,31883,31875,31873,31814,31843,31847,31863,31864,31865,31866,31867,31871,31791,31784,31783,31772,31771,31770,31759,31758,31757,31756,31752,31735,31731,31729,31718,31716,31706,31661,31662,31651,31647,31640,31639,31631,31623,31622,31620,31618,31615,31613,31605,31603,31576,31579,31573,31591,31571,31570,31569,31560,31553,31547,31455,31456,31462,31463,31470,31479,31480,31481,31487,31488,31499,31506,31513,31524,31536,31535,31441,31439,31433,31260,31261,31431,31274,31275,31276,31280,31296,31306,31309,31311,31211,31219,31222,31223,31225,31419,31417,31239,31240,31244,31245,31406,31248,31249,31402,31400,31251,31398,31396,31252,31253,31254,31165,31163,31162,31161,31394,31159,31150,31143,31390,31139,31137,31136,31132,31131,31128,31127,31125,31124,31122,31121,31384,31112,31111,31378,31106,31105,31104,31097,31087,31085,31084,31083,31356,31353,31352,31077,31070,31068,31058,31055,30993,30991,30981,30972,30971,30964,30952,30948,30943,30947,30926,30925,30924,30916,30917,30820,30819,30811,30797,30796,30795,30794,30786,30781,30780,30779,30776,30773,30756,30642,30641,30640,30637,30634,30635,30628,30622,30620,30619,30616,30615,30601,30599,30598,30590,30589,30588,30587,30586,30584,30582,30581,30580,30579,30578,30575,30573,30572,30567,30568,30538,30539,30531,30529,30523,30519,30517,30514,30512,30511,30510,30503,30502,30501,30500,30497,30495,30484,30459,30465,30473,30474,30475,30494,30489,30490,30414,30416,30430,30433,30434,30437,30438,30442,30444,30445,29745,29744,29743,29742,29729,29728,29727,29722,30097,30098,30099,30100,30101,30102,30104,30108,30133,30134,30135,30136,30137,30138,30139,30200,30201,30213,30212,30095,30086,30085,30077,30076,30072,30069,30058,30060,30253,30254,30028,30022,30021,30015,29999,30001,30006,30004,30010,30012,30011,29964,29955,29939,29935,29933,29930,29928,29923,29915,29912,29911,29909,29894,29893,29838,29840,29841,29842,29844,29845,29846,29847,29849,29850,29875,29889,29891,29833,29822,29823,29827,29829,29794,29795,29796,29788,29787,29783,29781,29780,29779,29776,29747,29749,29750,29751,29757,29760,29770,29774,29746,29682,29685,29688,29698,29699,29700,29706,29717,29644,29647,29651,29657,29658,29661,29662,29663,29664,29666,29669,29673,29675,29676,29674,29677,29608,29614,29615,29617,29628,29629,29635,29636,29641,29638,29540,29541,29542,29543,29544,29545,29546,29547,29548,29564,29565,29567,29570,29574,29594,29597,29598,29539,29519,29520,29521,29526,29527,29530,29504,29464,29467,29468,29470,29471,29472,29473,29474,29476,29477,29480,29481,29482,29483,29484,29485,29492,29496,29497,29499,29501,29463,29423,29424,29427,29438,29442,29443,29450,29451,29449,29454,29456,29404,29406,29407,29408,29409,29410,29416,29418,29292,29304,29329,29332,29333,29334,29338,29339,29348,29352,29353,29356,29358,29362,29369,29370,29371,29373,29376,29378,29380,29290,29157,29159,29160,29161,29165,29168,29169,29170,29174,29173,29181,29194,29199,29202,29203,29204,29206,29205,29212,29221,29225,29252,29155,29152,29150,29145,29141,29137,29126,29127,29041,29042,29043,29044,29046,29047,29051,29059,29060,29069,28991,28993,28994,28996,28997,29001,29004,29005,29006,29007,29008,29014,29021,29024,28983,28980,28974,28972,28971,28970,28965,28959,28944,28943,28902,28899,28891,28886,28880,28879,28876,28875,28873,28872,28767,28771,28779,28780,28781,28784,28785,28788,28789,28753,28754,28757,28762,28731,28732,28733,28735,28738,28740,28741,28743,28749,28750,28712,28698,28697,28696,28695,28694,28693,28691,28689,28686,28684,28683,28682,28672,28669,28658,28656,28650,28638,28637,28632,28617,28623,28616,28615,28614,28612,28611,28610,28609,28608,28603,28602,28599,28597,28595,28593,28594,28590,28589,28572,28571,28566,28552,28549,28547,28546,28540,28532,28527,28526,28525,28523,28522,28515,28486,28479,28459,28456,28455,28451,28450,28426,28411,28405,28402,28389,28387,28379,28339,28336,28342,28325,28322,28317,28321,28318,28319,28314,28313,28217,28216,28210,28143,28123,28122,28121,28113,28108,28098,28094,28093,28092,28091,27869,27867,27855,27775,27774,27758,27757,27755,27754,27752,27751,27750,27749,27746,27744,27742,27741,27740,27706,27560,27544,27366,27364,27271,26641,26116,25854,25842,25808,25807,25806,25723,25427,25402,24342,24272,24231,24130,24143,23681,23552,23492,23463,23469,23345,22143,22079,22037,21784,19759,19534,17078,16888,16626,16486,16484,16034,15912,15909,15872,9574,9568,8639,6571,6468,30910,4218)
ORDER BY FIELD(id, 33699,33704,33701,33697,33696,33695,33589,33591,33596,33598,33595,33614,33615,33657,33663,33671,33586,33555,33556,33563,33565,33566,33570,33571,33525,33501,33536,33498,33494,33492,33486,33475,33474,33473,33471,33469,33470,33466,33385,33387,33388,33391,33405,33409,33432,33438,33445,33446,33455,33458,33460,33462,33330,33359,33358,33367,33369,33371,33249,33277,33291,33293,33294,33120,33124,33133,33137,33142,33154,33157,33160,33186,33203,33205,33208,33212,33225,33067,33077,33032,33037,33042,33054,33056,33090,33105,33109,33110,33111,33025,33013,33011,33005,33004,33001,32998,32988,32982,32980,32977,32976,32973,32962,32903,32904,32906,32917,32927,32939,32947,32875,32869,32866,32865,32861,32860,32859,32840,32839,32832,32826,32820,32816,32809,32808,32807,32804,32794,32793,32790,32789,32787,32786,32775,32756,32755,32754,32751,32750,32749,32748,32744,32743,32742,32741,32760,32762,32766,32771,32772,32740,32739,32737,32726,32723,32694,32688,32685,32677,32675,32674,32673,32672,32666,32657,32651,32625,32621,32611,32601,32600,32597,32587,32586,32583,32579,32573,32580,32571,32523,32522,32519,32514,32511,32503,32499,32496,32481,32465,32453,32451,32449,32429,32426,32425,32424,32420,32417,32382,32348,32354,32202,32207,32209,32215,32219,32250,32275,32185,32184,32183,32177,32195,32166,32165,32146,32133,32132,32100,31920,31928,31929,31933,31934,31937,31947,31970,31905,31901,31900,31897,31896,31895,31894,31893,31892,31891,31890,31889,31884,31883,31875,31873,31814,31843,31847,31863,31864,31865,31866,31867,31871,31791,31784,31783,31772,31771,31770,31759,31758,31757,31756,31752,31735,31731,31729,31718,31716,31706,31661,31662,31651,31647,31640,31639,31631,31623,31622,31620,31618,31615,31613,31605,31603,31576,31579,31573,31591,31571,31570,31569,31560,31553,31547,31455,31456,31462,31463,31470,31479,31480,31481,31487,31488,31499,31506,31513,31524,31536,31535,31441,31439,31433,31260,31261,31431,31274,31275,31276,31280,31296,31306,31309,31311,31211,31219,31222,31223,31225,31419,31417,31239,31240,31244,31245,31406,31248,31249,31402,31400,31251,31398,31396,31252,31253,31254,31165,31163,31162,31161,31394,31159,31150,31143,31390,31139,31137,31136,31132,31131,31128,31127,31125,31124,31122,31121,31384,31112,31111,31378,31106,31105,31104,31097,31087,31085,31084,31083,31356,31353,31352,31077,31070,31068,31058,31055,30993,30991,30981,30972,30971,30964,30952,30948,30943,30947,30926,30925,30924,30916,30917,30820,30819,30811,30797,30796,30795,30794,30786,30781,30780,30779,30776,30773,30756,30642,30641,30640,30637,30634,30635,30628,30622,30620,30619,30616,30615,30601,30599,30598,30590,30589,30588,30587,30586,30584,30582,30581,30580,30579,30578,30575,30573,30572,30567,30568,30538,30539,30531,30529,30523,30519,30517,30514,30512,30511,30510,30503,30502,30501,30500,30497,30495,30484,30459,30465,30473,30474,30475,30494,30489,30490,30414,30416,30430,30433,30434,30437,30438,30442,30444,30445,29745,29744,29743,29742,29729,29728,29727,29722,30097,30098,30099,30100,30101,30102,30104,30108,30133,30134,30135,30136,30137,30138,30139,30200,30201,30213,30212,30095,30086,30085,30077,30076,30072,30069,30058,30060,30253,30254,30028,30022,30021,30015,29999,30001,30006,30004,30010,30012,30011,29964,29955,29939,29935,29933,29930,29928,29923,29915,29912,29911,29909,29894,29893,29838,29840,29841,29842,29844,29845,29846,29847,29849,29850,29875,29889,29891,29833,29822,29823,29827,29829,29794,29795,29796,29788,29787,29783,29781,29780,29779,29776,29747,29749,29750,29751,29757,29760,29770,29774,29746,29682,29685,29688,29698,29699,29700,29706,29717,29644,29647,29651,29657,29658,29661,29662,29663,29664,29666,29669,29673,29675,29676,29674,29677,29608,29614,29615,29617,29628,29629,29635,29636,29641,29638,29540,29541,29542,29543,29544,29545,29546,29547,29548,29564,29565,29567,29570,29574,29594,29597,29598,29539,29519,29520,29521,29526,29527,29530,29504,29464,29467,29468,29470,29471,29472,29473,29474,29476,29477,29480,29481,29482,29483,29484,29485,29492,29496,29497,29499,29501,29463,29423,29424,29427,29438,29442,29443,29450,29451,29449,29454,29456,29404,29406,29407,29408,29409,29410,29416,29418,29292,29304,29329,29332,29333,29334,29338,29339,29348,29352,29353,29356,29358,29362,29369,29370,29371,29373,29376,29378,29380,29290,29157,29159,29160,29161,29165,29168,29169,29170,29174,29173,29181,29194,29199,29202,29203,29204,29206,29205,29212,29221,29225,29252,29155,29152,29150,29145,29141,29137,29126,29127,29041,29042,29043,29044,29046,29047,29051,29059,29060,29069,28991,28993,28994,28996,28997,29001,29004,29005,29006,29007,29008,29014,29021,29024,28983,28980,28974,28972,28971,28970,28965,28959,28944,28943,28902,28899,28891,28886,28880,28879,28876,28875,28873,28872,28767,28771,28779,28780,28781,28784,28785,28788,28789,28753,28754,28757,28762,28731,28732,28733,28735,28738,28740,28741,28743,28749,28750,28712,28698,28697,28696,28695,28694,28693,28691,28689,28686,28684,28683,28682,28672,28669,28658,28656,28650,28638,28637,28632,28617,28623,28616,28615,28614,28612,28611,28610,28609,28608,28603,28602,28599,28597,28595,28593,28594,28590,28589,28572,28571,28566,28552,28549,28547,28546,28540,28532,28527,28526,28525,28523,28522,28515,28486,28479,28459,28456,28455,28451,28450,28426,28411,28405,28402,28389,28387,28379,28339,28336,28342,28325,28322,28317,28321,28318,28319,28314,28313,28217,28216,28210,28143,28123,28122,28121,28113,28108,28098,28094,28093,28092,28091,27869,27867,27855,27775,27774,27758,27757,27755,27754,27752,27751,27750,27749,27746,27744,27742,27741,27740,27706,27560,27544,27366,27364,27271,26641,26116,25854,25842,25808,25807,25806,25723,25427,25402,24342,24272,24231,24130,24143,23681,23552,23492,23463,23469,23345,22143,22079,22037,21784,19759,19534,17078,16888,16626,16486,16484,16034,15912,15909,15872,9574,9568,8639,6571,6468,30910,4218)
;
(this query time : 0.016 s)
(total SQL time : 0.034 s)
(total time : 0.049 s)
(num rows : 962 )
[17]
SELECT param, value
FROM g_config
WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.001 s)
(total SQL time : 0.035 s)
(total time : 0.446 s)
(num rows : 1 )