[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.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.008 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.009 s) (num rows : 1 )
[9] SELECT * FROM g_tags WHERE id IN (18026) (this query time : 0.001 s) (total SQL time : 0.004 s) (total time : 0.014 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 (18026)
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.006 s)
(total SQL time : 0.009 s)
(total time : 0.020 s)
(num rows : 353 )
[0.020 s, 9 queries] : start initialize_calendar
[10] SELECT DISTINCT(WEEKDAY(date_creation)) as period, COUNT(DISTINCT id) as nb_images FROM g_images WHERE id IN (33673,33573,33580,33156,33160,33184,33049,32984,32861,32859,32775,32751,32772,32739,32737,32736,32730,32572,32489,32476,32431,32420,32418,32276,32176,32169,31938,31850,31737,31736,31735,31734,31731,31730,31729,31728,31717,31716,31715,31706,31661,31667,31679,31687,31690,31691,31698,31703,31651,31650,31645,31643,31640,31639,31638,31637,31635,31629,31628,31626,31625,31620,31603,31593,31596,31597,31599,31600,31576,31577,31581,31585,31590,31589,31591,31572,31571,31563,31561,31281,31282,31302,31425,31309,31420,31234,31400,31251,31398,31396,31252,31159,31110,31109,31377,31376,31375,31373,31105,31104,31371,31102,31369,31097,31357,31082,31046,31041,30994,30983,30975,31022,30970,30968,30966,30965,30964,30961,30952,30950,30948,30943,30929,30928,30927,30926,30924,30921,30920,30918,30916,30914,30913,30827,30823,30822,30812,30810,30808,30806,30803,30796,30795,30794,30793,30790,30778,30770,30749,30633,30628,30626,30622,30620,30616,30612,30611,30606,30604,30602,30600,30598,30597,30596,30593,30592,30590,30587,30586,30582,30581,30580,30579,30576,30575,30573,30572,30567,30570,30569,30568,30538,30515,30510,30497,30496,30484,30470,30473,30492,30490,30416,30422,30423,30425,30427,30429,30432,30433,30434,30436,30437,30439,30444,30445,29733,29723,30099,30100,30113,30138,30192,30193,30200,30203,30204,30206,30207,30208,30213,30211,30094,30092,30091,30090,30089,30088,30086,30085,30084,30083,30082,30077,30076,30072,30070,30069,30067,30066,30063,30064,30062,30036,30044,30045,30058,30059,30246,30247,30248,30253,30031,30025,30021,30020,30017,30013,30016,29998,29999,30001,30002,30003,30007,29929,29928,29927,29931,29926,29925,29923,29914,29913,29912,29906,29899,29897,29894,29841,29849,29851,29854,29864,29865,29872,29882,29886,29833,29813,29815,29832,29797,29789,29780,29779,29709,29710,29664,29610,29541,29546,29574,29519,29529,29506,29480,29483,29489,29491,29499,29439,29450,29454,29458,29407,29408,29414,29387,29330,29332,29334,29339,29193,29215,29243,29252,29155,29152,28990,28981,28980,28974,28973,28944,28595,28593,28594,28590,28339,28314,28312,27775,27759,27758,27751,27749,27744,27742,27741,27740,22143,14251,11109) AND date_creation BETWEEN '2017-01-01' AND '2017-12-31 23:59:59' AND WEEK(date_creation, 5)+1=52 GROUP BY period; (this query time : 0.002 s) (total SQL time : 0.012 s) (total time : 0.023 s) (num rows : 1 )
[11]
SELECT CONCAT_WS('-',YEAR(date_creation),WEEK(date_creation, 5)+1) AS period FROM g_images
WHERE id IN (33673,33573,33580,33156,33160,33184,33049,32984,32861,32859,32775,32751,32772,32739,32737,32736,32730,32572,32489,32476,32431,32420,32418,32276,32176,32169,31938,31850,31737,31736,31735,31734,31731,31730,31729,31728,31717,31716,31715,31706,31661,31667,31679,31687,31690,31691,31698,31703,31651,31650,31645,31643,31640,31639,31638,31637,31635,31629,31628,31626,31625,31620,31603,31593,31596,31597,31599,31600,31576,31577,31581,31585,31590,31589,31591,31572,31571,31563,31561,31281,31282,31302,31425,31309,31420,31234,31400,31251,31398,31396,31252,31159,31110,31109,31377,31376,31375,31373,31105,31104,31371,31102,31369,31097,31357,31082,31046,31041,30994,30983,30975,31022,30970,30968,30966,30965,30964,30961,30952,30950,30948,30943,30929,30928,30927,30926,30924,30921,30920,30918,30916,30914,30913,30827,30823,30822,30812,30810,30808,30806,30803,30796,30795,30794,30793,30790,30778,30770,30749,30633,30628,30626,30622,30620,30616,30612,30611,30606,30604,30602,30600,30598,30597,30596,30593,30592,30590,30587,30586,30582,30581,30580,30579,30576,30575,30573,30572,30567,30570,30569,30568,30538,30515,30510,30497,30496,30484,30470,30473,30492,30490,30416,30422,30423,30425,30427,30429,30432,30433,30434,30436,30437,30439,30444,30445,29733,29723,30099,30100,30113,30138,30192,30193,30200,30203,30204,30206,30207,30208,30213,30211,30094,30092,30091,30090,30089,30088,30086,30085,30084,30083,30082,30077,30076,30072,30070,30069,30067,30066,30063,30064,30062,30036,30044,30045,30058,30059,30246,30247,30248,30253,30031,30025,30021,30020,30017,30013,30016,29998,29999,30001,30002,30003,30007,29929,29928,29927,29931,29926,29925,29923,29914,29913,29912,29906,29899,29897,29894,29841,29849,29851,29854,29864,29865,29872,29882,29886,29833,29813,29815,29832,29797,29789,29780,29779,29709,29710,29664,29610,29541,29546,29574,29519,29529,29506,29480,29483,29489,29491,29499,29439,29450,29454,29458,29407,29408,29414,29387,29330,29332,29334,29339,29193,29215,29243,29252,29155,29152,28990,28981,28980,28974,28973,28944,28595,28593,28594,28590,28339,28314,28312,27775,27759,27758,27751,27749,27744,27742,27741,27740,22143,14251,11109)
AND date_creation IS NOT NULL
GROUP BY period
(this query time : 0.004 s)
(total SQL time : 0.016 s)
(total time : 0.027 s)
(num rows : 54 )
[12] SELECT DISTINCT id FROM g_images WHERE id IN (33673,33573,33580,33156,33160,33184,33049,32984,32861,32859,32775,32751,32772,32739,32737,32736,32730,32572,32489,32476,32431,32420,32418,32276,32176,32169,31938,31850,31737,31736,31735,31734,31731,31730,31729,31728,31717,31716,31715,31706,31661,31667,31679,31687,31690,31691,31698,31703,31651,31650,31645,31643,31640,31639,31638,31637,31635,31629,31628,31626,31625,31620,31603,31593,31596,31597,31599,31600,31576,31577,31581,31585,31590,31589,31591,31572,31571,31563,31561,31281,31282,31302,31425,31309,31420,31234,31400,31251,31398,31396,31252,31159,31110,31109,31377,31376,31375,31373,31105,31104,31371,31102,31369,31097,31357,31082,31046,31041,30994,30983,30975,31022,30970,30968,30966,30965,30964,30961,30952,30950,30948,30943,30929,30928,30927,30926,30924,30921,30920,30918,30916,30914,30913,30827,30823,30822,30812,30810,30808,30806,30803,30796,30795,30794,30793,30790,30778,30770,30749,30633,30628,30626,30622,30620,30616,30612,30611,30606,30604,30602,30600,30598,30597,30596,30593,30592,30590,30587,30586,30582,30581,30580,30579,30576,30575,30573,30572,30567,30570,30569,30568,30538,30515,30510,30497,30496,30484,30470,30473,30492,30490,30416,30422,30423,30425,30427,30429,30432,30433,30434,30436,30437,30439,30444,30445,29733,29723,30099,30100,30113,30138,30192,30193,30200,30203,30204,30206,30207,30208,30213,30211,30094,30092,30091,30090,30089,30088,30086,30085,30084,30083,30082,30077,30076,30072,30070,30069,30067,30066,30063,30064,30062,30036,30044,30045,30058,30059,30246,30247,30248,30253,30031,30025,30021,30020,30017,30013,30016,29998,29999,30001,30002,30003,30007,29929,29928,29927,29931,29926,29925,29923,29914,29913,29912,29906,29899,29897,29894,29841,29849,29851,29854,29864,29865,29872,29882,29886,29833,29813,29815,29832,29797,29789,29780,29779,29709,29710,29664,29610,29541,29546,29574,29519,29529,29506,29480,29483,29489,29491,29499,29439,29450,29454,29458,29407,29408,29414,29387,29330,29332,29334,29339,29193,29215,29243,29252,29155,29152,28990,28981,28980,28974,28973,28944,28595,28593,28594,28590,28339,28314,28312,27775,27759,27758,27751,27749,27744,27742,27741,27740,22143,14251,11109) AND date_creation BETWEEN '2017-01-01' AND '2017-12-31 23:59:59' AND WEEK(date_creation, 5)+1=52 ORDER BY date_creation ASC, date_creation DESC, file ASC, id ASC (this query time : 0.002 s) (total SQL time : 0.017 s) (total time : 0.029 s) (num rows : 1 )
[0.029 s, 12 queries] : end initialize_calendar
[13] SELECT id, name, permalink, nb_images, global_rank, date_last, max_date_last, count_images, count_categories FROM g_categories INNER JOIN g_user_cache_categories ON id = cat_id and user_id = 2 WHERE 1 = 1 ; (this query time : 0.003 s) (total SQL time : 0.020 s) (total time : 0.032 s) (num rows : 374 )
[14] SELECT SUBDATE(CURRENT_DATE,INTERVAL 30 DAY) (this query time : 0.000 s) (total SQL time : 0.021 s) (total time : 0.032 s) (num rows : 1 )
[15]
SELECT
c.id,
c.uppercats,
count(*) AS counter
FROM g_image_category
INNER JOIN g_categories c ON category_id = id
WHERE image_id IN (11109)
AND (category_id NOT IN (878,294,266,321,272,273,822,823,824,825,826,182,212))
GROUP BY c.id
ORDER BY counter DESC
LIMIT 20
(this query time : 0.001 s)
(total SQL time : 0.021 s)
(total time : 0.035 s)
(num rows : 2 )
[16]
SELECT
id,
name,
permalink,
id_uppercat,
uppercats,
global_rank
FROM g_categories
WHERE id IN (122,131,103,259,341)
;
(this query time : 0.004 s)
(total SQL time : 0.025 s)
(total time : 0.039 s)
(num rows : 5 )
[17] SELECT * FROM g_tags (this query time : 0.009 s) (total SQL time : 0.034 s) (total time : 0.049 s) (num rows : 17957 )
[18]
SELECT t.*, count(*) AS counter
FROM g_image_tag
INNER JOIN g_tags t ON tag_id = id
WHERE image_id IN (11109)
AND tag_id NOT IN (18026)
GROUP BY t.id
ORDER BY counter DESC
LIMIT 3
(this query time : 0.001 s)
(total SQL time : 0.035 s)
(total time : 0.113 s)
(num rows : 3 )
[19] SELECT * FROM g_images WHERE id IN (11109) ; (this query time : 0.000 s) (total SQL time : 0.036 s) (total time : 0.114 s) (num rows : 1 )
[0.115 s, 19 queries] : end include/category_default.inc.php
[20]
SELECT
id,
file,
representative_ext,
name,
comment,
width,
height,
date_creation,
path,
rotation
FROM g_images
WHERE id IN (11109)
ORDER BY FIELD(id, 11109)
;
(this query time : 0.000 s)
(total SQL time : 0.036 s)
(total time : 0.116 s)
(num rows : 1 )
[21] SELECT param, value FROM g_config WHERE param = "send_piwigo_infos_last_notice" ; (this query time : 0.000 s) (total SQL time : 0.036 s) (total time : 0.119 s) (num rows : 1 )