Home / User comments

Filter
Display

First | | 1 ... 7 8 9 10 11 | | Last 
[1] 
SELECT @@SESSION.sql_mode
(this query time : 0.000 s)
(total SQL time  : 0.000 s)
(total time      : 0.005 s)
(num rows        : 1 )
[2] 

SELECT param, value
 FROM piwigo_config
 
;
(this query time : 0.001 s)
(total SQL time  : 0.001 s)
(total time      : 0.006 s)
(num rows        : 106 )
[3] 

SELECT data
  FROM piwigo_sessions
  WHERE id = 'D84991383fe467260b13b9e7e5226568372d'
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)
(total time      : 0.006 s)
(num rows        : 0 )
[4] 

SELECT * FROM piwigo_plugins
  WHERE state='active'
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.007 s)
(num rows        : 2 )
[5] 

SELECT
    image_id,
    date_available,
    NOW() AS dbnow
  FROM piwigo_lounge
    JOIN piwigo_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.008 s)
(num rows        : 0 )
[6] 

SELECT id AS id
     , username AS username
     , password AS password
     , mail_address AS email
  FROM piwigo_users
  WHERE id = '2'
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.008 s)
(num rows        : 1 )
[7] 

SELECT
    ui.*,
    uc.*,
    t.name AS theme_name
  FROM piwigo_user_infos AS ui
    LEFT JOIN piwigo_user_cache AS uc ON ui.user_id = uc.user_id
    LEFT JOIN piwigo_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.009 s)
(num rows        : 1 )
[8] 

SELECT *
  FROM piwigo_user_infos
  WHERE user_id = 2
;
(this query time : 0.000 s)
(total SQL time  : 0.003 s)
(total time      : 0.009 s)
(num rows        : 1 )
[9] 

SELECT id, name, uppercats, global_rank
  FROM piwigo_categories
WHERE (id NOT IN (99,100,101,102,103,104,107,108,115,28,29,63))
;
(this query time : 0.001 s)
(total SQL time  : 0.004 s)
(total time      : 0.013 s)
(num rows        : 103 )
[10] 

SELECT id, name, permalink
  FROM piwigo_categories
;
(this query time : 0.001 s)
(total SQL time  : 0.005 s)
(total time      : 0.013 s)
(num rows        : 115 )
[11] 

SELECT SQL_CALC_FOUND_ROWS com.id AS comment_id,
       com.image_id,
       ic.category_id,
       com.author,
       com.author_id,
       u.mail_address AS user_email,
       com.email,
       com.date,
       com.website_url,
       com.content,
       com.validated
  FROM piwigo_image_category AS ic
    INNER JOIN piwigo_comments AS com
    ON ic.image_id = com.image_id
    LEFT JOIN piwigo_users As u
    ON u.id = com.author_id
  WHERE 1=1
    AND validated='true'
    AND  (category_id NOT IN (99,100,101,102,103,104,107,108,115,28,29,63) AND ic.image_id NOT IN (19,34,50,54,55,56,57,58,59,62,64,69,70,71,72,74,79,80,81,86,89,90,91,97,98,99,105,106,109,110,113,119,120,123,124,131,132,133,134,163,169,176,177,178,179,193,194,198,211,212,213,214,215,216,217,220,221,222,224,285,286,289,296,297,340,341,342,351,352,354,355,357,358,363,365,366,379,390,391,393,398,399,419,424,425,428,430,438,454,457,458,463,480,486,487,490,501,504,505,506,507,511,512,513,523,554,555,581,635,636,640,641,656,657,661,662,663,674,679,680,681,690,691,692,715,723,724,728,729,746,747,764,765,778,781,782,786,787,788,789,790,794,797,810,811,812,813,821,822,828,832,833,834,888,889,890,891,892,894,896,897,914,933,934,935,942,943,945,946,957,962,976,981,1005,1009,1028,1029,1034,1227,1228,1229,1230,1241,1242,1251,1252,1253,1254,1255,1272,1275,1276,1278,1282,1286,1291,1292,1303,1309,1325,1328,1329,1392,1393,1416,1417,1419,1420,1421,1422,1424,1425,1426,1427,1438,1439,1440,1441,1442,1481,1502,1503,1520,1530,1531,1533,1551,1554,1555,1557,1558,1562,1579,1580,1581,1584,1586,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1602,1603,1604,1608,1609,1610,1622,1624,1632,1637,1646,1647,1648,1649,1650,1651,1653,1654,1656,1657,1666,1669,1681,1682,1686,1687,1689,1690,1695,1696,1697,1699,1700,1701,1702,1704,1707,1708,1709,1713,1718,1734,1735,1737,1738,1739,1740,1741,1742,1747,1751,1753,1754,1755,1756,1770,1772,1773,1776,1777,1778,1784,1785,1786,1795,1796,1797,1802,1804,1805,1806,1807,1809,1810,1811,1814,1815,1825,1826,1829,1830,1831,1832,1833,1835,1836,1837,1841,1848,1854,1855,1868,1869,1870,1876,1880,1881,1884,1887,1894,1895,1896,1897,1899,1900,1906,1907,1909,1911,1912,1913,1916,1917,1921,1922,1924,1928,1929,1930,1931,1933,1950,1956,1957,1960,1975,1981,1982,1983,1984,1985,1990,1996,1997,1998,1999,2000,2002,2003,2006,2007,2015,2016,2017,2024,2025,2026,2033,2034,2035,2050,2054,2055,2057,2058,2059,2061,2062,2063,2067,2068,2070,2071,2072,2073,2075,2076,2083,2084,2085,2088,2090,2091,2092,2093,2094,2095,2096,2097,2098,2099,2101,2102,2104,2105,2106,2107,2108,2120,2121,2122,2123,2124,2125,2127,2132,2133,2134,2138,2139,2140,2141,2144,2148,2154,2156,2167,2168,2170,2171,2173,2174,2184,2186,2187,2190,2191,2192,2196,2197,2198,2199,2206,2207,2208,2210,2211,2212,2213,2216,2217,2218,2223,2224,2225,2226,2229,2230,2231,2232,2234,2235,2240,2245,2254,2255,2256,2257,2258,2259,2261,2262,2266,2267,2269,2270,2276,2277,2278,2281,2283,2284,2288,2289,2293,2294,2295,2296,2302,2308,2316,2317,2318,2320,2321,2322,2323,2329,2332,2333,2336,2337,2339,2344,2345,2349,2356,2358,2362,2363,2364,2366,2367,2368,2370,2371,2372,2373,2374,2377,2384,2399,2400,2401,2402,2513,2530,2549,2550,2551,2559,2567,2570,2752,2753,2757,2765,2771,2780,2814,2815,2822,2825,2828,2829,2831,2832,2843,2853,2855,2856,2859,2860,2861,2862,2867,2869,2870,2877,2879,2932,2935,2936,2945,2946,2947,2948,2949,2950,2951,2952,2953,2955,2957,2958,2959,2960,2961,2962,2965,2967,2970,2972,2985,2986,2987,2988,2994,3001,3002,3061,3062,3066,3068,3073,3074,3076,3078,3079,3080,3089,3090,3091,3095,3097,3113,3114,3117,3118,3137,3138,3139,3155,3156,3157,3158,3164,3165,3175,3196,3201,3203,3204,3208,3224,3226,3227,3228,3232,3252,3341,3342,3343,3405,3410,3445,3460,3466,3467,3468,3470,3471,3472,3520,3521,3572,3573,3580,3581,3582,3583,3584,3586,3587,3588,3594,3612,3624,3625,3634,3635,3642,3659,3662,3663,3664,3677,3678,3688,3689,3690,3691,3692,3693,3694,3695,3696,3697,3698,3699,3700,3723,3725,3726,3728,3729,3742,3746,3748,3749,3752,3753,3756,3770,3771,3775,3776,3777,3785,3786,3788,3789,3791,3797,3827,3828,3835,3839,3840,3841,3842,3843,3844,3845,3846,3847,3848,3849,3850,3851,3852,3853,3854,3855,3856,3857,3858,3859,3860,3876,3896,3897,3899,3901,3953,3954,3956,3967,3968,3970,3971,3972,3977,3979,3981,3985,3986,3987,3988,3989,4006,4007,4010,4011,4012,4013,4014,4015,4016,4017,4018,4019,4020,4021,4022,4023,4024,4025,4026,4027,4031,4032,4039,4041,4043,4044,4045,4081,4082,4083,4140,4141,4144,4145,4146,4147,4151,4162,4163,4164,4169,4172,4173,4174,4175,4176,4177,4178,4179,4180,4181,4182,4183,4184,4186,4187,4188,4189,4190,4196,4197,4198,4199,4200,4259,4264,4265,4273,4274,4275,4276,4277,4280,4283,4284,4288,4289,4292,4295,4296,4314,4315,4318,4321,4323,4324,4325,4326,4327,4328,4329,4330,4333,4337,4341,4344,4345,4346,4353,4357,4358,4360,4361,4362,4363,4364,4365,4366,4367,4368,4369,4370,4371,4372,4373,4374,4375,4376,4377,4380,4381,4382,4383,4384,4385,4386,4387,4388,4389,4390,4391,4392,4393,4394,4397,4398,4399,4400,4401,4402,4408,4410,4412,4413,4422,4425,4426,4429,4430,4433,4434,4435,4436,4456,4474,4475,4491,4494,4505,4506,4593,4623,4639,4640,4642,4646,4647,4650,4651,4653,4664,4665,4669,4673,4685,4686,4689,4690,4694,4695,4700,4706,4707,4713,4714,4718,4719,4720,4721,4722,4723,4724,4734,4736,4742,4748,4752,4759,4760,4762,4763,4766,4782,4796,4808,4809,4810,4814,4825,4827,4830,4831,4832,4833,4837,4848,4849,4850,4851,4852,4856,4857,4859,4860,4861,4863,4867,4868,4869,4886,4887,4901,4904,4906,4907,4911,4912,4917,4918,4921,4926,4927,4931,4933,4944,4949,4950,4951,4952,4953,4965,4966,4969,4970,4971,4984,4998,5000,5001,5002,5012,5013,5018,5019,5027,5028,5029,5035,5040,5045,5046,5049,5050,5051,5053,5056,5058,5080,5106,5107,5123,5142,5153,5175,5176,5186,5187,5188,5215,5216,5217,5218,5224,5225,5226,5232,5233,5234,5238,5245,5246,5247,5248,5253,5282,5283,5284,5318,5319,5320,5330,5340,5342,5344,5345,5348,5349,5355,5356,5357,5358,5359,5360,5362,5363,5364,5365,5366,5370,5372,5378,5380,5381,5382,5413,5414,5415,5419,5424,5425,5439,5444,5446,5447,5449,5450,5452,5453,5454,5455,5456,5457,5461,5462,5467,5469,5470,5471,5472,5477,5488,5491,5508,5528,5531,5532,5561,5571,5573,5580,5581,5583,5584,5595,5597,5598,5602,5605,5606,5607,5608,5609,5615,5616,5619,5622,5624,5630,5631,5641,5678,5679,5680,5692,5728,5731,5732,5733,5767,5768,5803,5804,5805,5806,5807,5808,5813,5825,5829,5832,5833,5838,5841,5843,5848,5849,5855,5857,5859,5862,5863,5865,5877,5888,5889,5890,5891,5892,5899,5900,5905,5909,5917,5918,5919,5921,5926,5927,5928,5963,5966,5977,5978,5979,5984,5985,5986,6006,6007,6009,6010,6011,6012,6013,6014,6015,6016,6023,6024,6025,6026,6027,6028,6037,6039,6042,6050,6051,6053,6056,6083,6086,6087,6089,6092,6106,6108,6117,6131,6133,6136,6137,6138,6139,6148,6149,6153,6155,6164,6169,6170,6177,6179,6181,6182,6185,6188,6189,6191,6193,6194,6195,6199,6204,6205,6206,6207,6208,6211,6212,6227,6230,6238,6240,6253,6258,6259,6264,6266,6271,6279,6280,6282,6285,6297,6308,6324,6335,6339,6352,6369,6376,6380,6393,6396,6432,6439,6443,6455,6457,6459,6463,6464,6466,6469,6474,6475,6476,6478,6483,6486,6488,6500,6504,6512,6523,6524,6526,6530,6534,6537,6540,6556,6557,6558,6575,6581,6583,6595,6597,6602,6606,6614,6618,6622,6638,6639,6651,6658,6662,6689,6697,6700,6720,6724,6726,6727,6728,6740,6743,6744,6746,6758,6765,6766,6773,6776,6779,6781,6784,6785,6787,6792,6796,6803,6804,6805,6807,6808,6819,6823,6834,6839,6840,6842,6843,6844,6845,6846,6849,6850,6859,6862,6865,6866,6881,6882,6883,6910,6911,6912,6915,6917,6919,6921,6925,6930,6934,6943,6944,6946,6948,6950,6952,6963,6965,6968,6971,6975,6983,7005,7011,7015,7016,7018,7019,7021,7022,7024,7026,7029,7032,7045,7049,7055,7058,7062,7064,7065,7068,7071,7075,7077,7078,7079,7081,7082,7099,7100,7102,7103,7105,7106,7109,7111,7113,7114,7117,7125,7128,7131,7134,7135,7136,7139,7142,7145,7148,7150,7151,7156,7158,7161,7177,7203,7207,7212,7213,7214,7218,7220,7222,7236,7252,7258,7270,7291,7301,7306,7307,7309,7312,7315,7317,7322,7324,7327,7332,7340,7349,7355,7356,7363,7370,7392,7395,7397,7399,7401,7403,7404,7406,7411,7416,7419,7421,7430,7433,7434,7437,7438,7442,7474,7476,7479,7481,7483,7489,7500,7503,7504,7511,7515,7519,7527,7529,7536,7564,7592,7607,7609,7621,7646,7649,7650,7653,7654,7656,7665,7667,7669,7671,7672,7677,7683,7686,7700,7704,7707,7723,7725,7734,7736,7738,7740,7744,7745,7747,7750,7752,7756,7758,7760,7762,7764,7766,7768,7774,7779,7784,7802,7813,7850,7851,7874,7875,7897,7902,7904,7911,7912,7956,7977,7983,7984,7985,7990,7995,8018,8032,8033,8034,8035,8037,8048,8049,8061,8063,8064,8089,8090,8091,8096,8097,8098,8104,8123,8124,8125,8129,8130,8166,8194,8248,8259,8260,8261,8262,8263,8264,8300,8301,8302,8304,8305,8306,8307,8309,8310,8311,8314,8315,8316,8317,8318,8323,8324,8328,8333,8334))
  GROUP BY comment_id
  ORDER BY date DESC
  LIMIT 10 OFFSET 80
;
(this query time : 0.003 s)
(total SQL time  : 0.008 s)
(total time      : 0.017 s)
(num rows        : 10 )
[12] 
SELECT FOUND_ROWS()
(this query time : 0.000 s)
(total SQL time  : 0.008 s)
(total time      : 0.017 s)
(num rows        : 1 )
[13] 

SELECT *
  FROM piwigo_images
  WHERE id IN (207,207,206,205,199,189,156,140,115,102)
;
(this query time : 0.000 s)
(total SQL time  : 0.008 s)
(total time      : 0.018 s)
(num rows        : 9 )
[14] 
SELECT id, name, permalink, uppercats
  FROM piwigo_categories
  WHERE id IN (4,4,4,4,4,4,4,3,3,3)
(this query time : 0.000 s)
(total SQL time  : 0.009 s)
(total time      : 0.018 s)
(num rows        : 2 )
[15] 

SELECT 
  id, name, permalink, nb_images, global_rank,
  date_last, max_date_last, count_images, count_categories
FROM piwigo_categories INNER JOIN piwigo_user_cache_categories
  ON id = cat_id and user_id = 2
WHERE 
(id_uppercat is NULL)
;
(this query time : 0.001 s)
(total SQL time  : 0.009 s)
(total time      : 0.020 s)
(num rows        : 48 )
[16] 

SELECT SUBDATE(CURRENT_DATE,INTERVAL 7 DAY)
(this query time : 0.000 s)
(total SQL time  : 0.010 s)
(total time      : 0.020 s)
(num rows        : 1 )
[17] 

SELECT param, value
 FROM piwigo_config
 WHERE param = "send_piwigo_infos_last_notice"
;
(this query time : 0.000 s)
(total SQL time  : 0.010 s)
(total time      : 0.024 s)
(num rows        : 1 )