mysql slow-slow

# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 46.002059  Lock_time: 0.000073 Rows_sent: 0  Rows_examined: 0
SET timestamp=1392161475;
INSERT INTO piwigo_images
  (file,name,date_available,path,filesize,width,height,md5sum,added_by,rotation,level)
  VALUES('jardins-119.jpg','jardins-119','2014-02-12 00:30:27','./upload/2014/02/12/20140212003027-51fc847d.jpg','459','1039','1500','51fc847db89bb88612613f706eb192a3','1','0','0');
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 15.357038  Lock_time: 0.000089 Rows_sent: 982  Rows_examined: 131778
SET timestamp=1392161475;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 16.493482  Lock_time: 0.000096 Rows_sent: 982  Rows_examined: 131778
SET timestamp=1392161475;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 15.002069  Lock_time: 0.000090 Rows_sent: 982  Rows_examined: 131778
SET timestamp=1392161475;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 15.414250  Lock_time: 0.000108 Rows_sent: 982  Rows_examined: 131778
SET timestamp=1392161475;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  0:31:21
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 17.954668  Lock_time: 0.000094 Rows_sent: 64395  Rows_examined: 257622
SET timestamp=1392161481;
SELECT DISTINCT(image_id)
  FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    1=1
AND (category_id NOT IN (40,41,42,43,97,143,310,680,965) AND level<=0)
  ORDER BY file ASC;
# Time: 140212  0:31:29
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 11.855349  Lock_time: 0.000069 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161489;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 11.931069  Lock_time: 0.000040 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161489;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.204346  Lock_time: 0.000056 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161489;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:31:30
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.291953  Lock_time: 0.000046 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.503407  Lock_time: 0.000090 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.538194  Lock_time: 0.000076 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.630767  Lock_time: 0.000069 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.439484  Lock_time: 0.000074 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.598313  Lock_time: 0.000052 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.673369  Lock_time: 0.000060 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.652391  Lock_time: 0.000072 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.541597  Lock_time: 0.000058 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.919723  Lock_time: 0.000054 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.431734  Lock_time: 0.000065 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 13.042923  Lock_time: 0.000052 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.749820  Lock_time: 0.000050 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.817102  Lock_time: 0.000059 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.350702  Lock_time: 0.000083 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 13.317802  Lock_time: 0.000057 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 13.082175  Lock_time: 0.000063 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 13.029139  Lock_time: 0.000056 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.880706  Lock_time: 0.000097 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.757409  Lock_time: 0.000072 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.755299  Lock_time: 0.000059 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161490;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:31:31
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.919239  Lock_time: 0.000063 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161491;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 11.467594  Lock_time: 0.000073 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161491;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 10.450674  Lock_time: 0.000080 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161491;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 10.813355  Lock_time: 0.000071 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161491;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:31:57
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 33.707981  Lock_time: 7.005563 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161517;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:31:58
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.679379  Lock_time: 5.597901 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161518;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:31:59
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.322288  Lock_time: 2.322910 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161519;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.506595  Lock_time: 2.463850 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161519;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 37.336290  Lock_time: 9.112203 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161519;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.870932  Lock_time: 0.000051 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161519;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:00
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.839422  Lock_time: 2.062334 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161520;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 29.420998  Lock_time: 0.031431 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161520;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  0:32:01
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.554630  Lock_time: 0.697783 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161521;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.952630  Lock_time: 0.646536 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161521;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  0:32:02
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.725617  Lock_time: 0.000060 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.881610  Lock_time: 0.075509 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.174118  Lock_time: 0.357383 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.756601  Lock_time: 0.808055 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 29.651578  Lock_time: 0.000064 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161522;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.377704  Lock_time: 0.282399 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.497107  Lock_time: 0.382798 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.986195  Lock_time: 0.870802 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.562621  Lock_time: 0.320158 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.925651  Lock_time: 0.602825 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.801022  Lock_time: 0.344954 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.198163  Lock_time: 0.590655 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.530625  Lock_time: 0.911294 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.870125  Lock_time: 0.210714 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.506656  Lock_time: 0.829202 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161522;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 29.322040  Lock_time: 0.000096 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161522;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:03
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.578171  Lock_time: 0.709325 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161523;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.333246  Lock_time: 0.459450 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161523;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.189831  Lock_time: 0.302400 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161523;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.217047  Lock_time: 0.303896 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161523;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.234759  Lock_time: 0.310468 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161523;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 33.180273  Lock_time: 1.044761 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161523;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.965378  Lock_time: 0.768829 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161523;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 33.188034  Lock_time: 0.971812 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161523;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.922110  Lock_time: 0.685562 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161523;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.238323  Lock_time: 0.000056 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161523;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.895246  Lock_time: 0.614725 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161523;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.641989  Lock_time: 0.343510 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161523;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.479902  Lock_time: 0.084484 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161523;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.834940  Lock_time: 0.367270 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161523;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  0:32:04
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 33.343004  Lock_time: 0.410471 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161524;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 33.991281  Lock_time: 0.980625 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161524;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.633350  Lock_time: 0.000050 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161524;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.329079  Lock_time: 0.000052 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161524;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:06
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 29.349966  Lock_time: 0.000061 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161526;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 28.898078  Lock_time: 0.000072 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161526;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:07
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 28.811582  Lock_time: 0.000069 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161527;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 29.430492  Lock_time: 0.000074 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161527;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.982697  Lock_time: 0.000062 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161527;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 29.186858  Lock_time: 0.000079 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161527;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:08
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 28.858997  Lock_time: 0.000073 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161528;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:09
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.308933  Lock_time: 0.000055 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161529;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 28.294604  Lock_time: 0.000071 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161529;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.434901  Lock_time: 0.000066 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161529;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:10
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.774389  Lock_time: 0.000055 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161530;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.095531  Lock_time: 0.000110 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161530;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.996125  Lock_time: 0.000077 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161530;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 24.043592  Lock_time: 0.000053 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161530;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:11
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 22.662479  Lock_time: 0.000055 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161531;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.722372  Lock_time: 0.000075 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161531;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.181268  Lock_time: 0.000081 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161531;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.153257  Lock_time: 0.000047 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161531;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 22.113349  Lock_time: 0.000062 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161531;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:12
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.068840  Lock_time: 0.000072 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161532;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 18.041064  Lock_time: 0.000052 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161532;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 18.796262  Lock_time: 0.000056 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161532;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:13
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 19.525357  Lock_time: 0.000059 Rows_sent: 21  Rows_examined: 128857
SET timestamp=1392161533;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 50.146808  Lock_time: 7.986583 Rows_sent: 0  Rows_examined: 0
SET timestamp=1392161533;
INSERT INTO piwigo_images
  (file,name,date_available,path,filesize,width,height,md5sum,added_by,rotation,level)
  VALUES('jardins-121.jpg','jardins-121','2014-02-12 00:31:20','./upload/2014/02/12/20140212003120-4627b95e.jpg','496','1041','1500','4627b95eba3045889e72fe22f218f57e','1','0','0');
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 14.137986  Lock_time: 0.000124 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161533;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 15.570506  Lock_time: 0.000111 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161533;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 13.900210  Lock_time: 0.000109 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161533;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 14.675544  Lock_time: 0.000078 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161533;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 14.503443  Lock_time: 0.000110 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161533;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  0:32:14
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 14.411316  Lock_time: 0.000106 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161534;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 16.042854  Lock_time: 0.000107 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161534;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 15.550622  Lock_time: 0.000107 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161534;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 14.770534  Lock_time: 0.000103 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161534;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 14.372290  Lock_time: 0.000098 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161534;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 11.259073  Lock_time: 0.000084 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161534;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 11.894673  Lock_time: 0.000110 Rows_sent: 982  Rows_examined: 131782
SET timestamp=1392161534;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  0:32:45
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 10.139167  Lock_time: 0.000039 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161565;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:46
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 10.580916  Lock_time: 0.000052 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161566;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:47
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.613131  Lock_time: 1.091430 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161567;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 13.057577  Lock_time: 1.133069 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161567;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 11.960526  Lock_time: 0.020624 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161567;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.279574  Lock_time: 0.204690 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161567;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 13.109605  Lock_time: 0.984166 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161567;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 13.048398  Lock_time: 0.841909 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161567;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.290291  Lock_time: 0.083450 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161567;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 13.420808  Lock_time: 1.195337 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161567;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  0:32:48
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.310353  Lock_time: 0.014068 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161568;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.551811  Lock_time: 0.132998 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161568;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.855392  Lock_time: 0.337118 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161568;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 13.416429  Lock_time: 0.870827 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161568;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.810532  Lock_time: 0.113086 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161568;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 13.880118  Lock_time: 0.956083 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161568;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 14.195297  Lock_time: 1.215395 Rows_sent: 982  Rows_examined: 131796
SET timestamp=1392161568;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.154893  Lock_time: 0.000066 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161568;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:50
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.663335  Lock_time: 0.000062 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161570;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.905629  Lock_time: 0.000057 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161570;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.491143  Lock_time: 0.000082 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161570;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:51
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 11.964366  Lock_time: 0.000087 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161571;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:52
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.564820  Lock_time: 0.000067 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161572;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.147931  Lock_time: 0.000080 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161572;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.326307  Lock_time: 0.000087 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161572;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:53
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.021549  Lock_time: 0.000067 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161573;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 10.726889  Lock_time: 0.000060 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161573;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 11.299046  Lock_time: 0.000094 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161573;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 11.253777  Lock_time: 0.000083 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161573;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  0:32:54
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 10.204723  Lock_time: 0.000058 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161574;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 10.121468  Lock_time: 0.000044 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161574;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 14.713252  Lock_time: 0.000052 Rows_sent: 0  Rows_examined: 0
SET timestamp=1392161574;
INSERT INTO piwigo_images
  (file,name,date_available,path,filesize,width,height,md5sum,added_by,rotation,level)
  VALUES('jardins-128.jpg','jardins-128','2014-02-12 00:32:39','./upload/2014/02/12/20140212003239-2971adac.jpg','487','1045','1500','2971adacca385acf4e76b49097e8f7db','1','0','0');
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 10.181275  Lock_time: 0.000071 Rows_sent: 21  Rows_examined: 128871
SET timestamp=1392161574;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:13
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 19.574663  Lock_time: 0.696205 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169813;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:14
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.178128  Lock_time: 0.306967 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169814;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.090237  Lock_time: 0.805618 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169814;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:15
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.805387  Lock_time: 0.183810 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169815;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 22.729707  Lock_time: 1.724633 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169815;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.321247  Lock_time: 0.275000 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169815;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.591580  Lock_time: 0.399481 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169815;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 15.620371  Lock_time: 0.000090 Rows_sent: 7  Rows_examined: 178575
use hrules;
SET timestamp=1392169815;
SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts  LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users'  ORDER BY  ratings_average desc, ratings_users desc LIMIT 49, 7;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.605142  Lock_time: 0.232987 Rows_sent: 21  Rows_examined: 129073
use piwigal;
SET timestamp=1392169815;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:16
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 22.961555  Lock_time: 0.542990 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169816;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:17
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.394195  Lock_time: 0.403106 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169817;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.208653  Lock_time: 0.000047 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169817;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.108066  Lock_time: 0.000078 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169817;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:18
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.162073  Lock_time: 0.697442 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169818;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:50:19
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 24.730775  Lock_time: 0.013332 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169819;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.799133  Lock_time: 0.000067 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169819;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.063671  Lock_time: 0.543072 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169819;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:50:20
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.860118  Lock_time: 0.000086 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169820;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.862472  Lock_time: 0.003999 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169820;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.019298  Lock_time: 0.000062 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169820;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.136514  Lock_time: 0.000077 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169820;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 24.850209  Lock_time: 0.000078 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169820;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.220793  Lock_time: 0.000083 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169820;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:21
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.616032  Lock_time: 0.010870 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169821;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 24.644814  Lock_time: 0.000051 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169821;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:22
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.037054  Lock_time: 0.000049 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169822;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.638678  Lock_time: 0.000058 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169822;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:23
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.531368  Lock_time: 0.000074 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169823;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:24
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.843509  Lock_time: 0.000066 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169824;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.866734  Lock_time: 0.000063 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169824;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:25
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.000758  Lock_time: 0.000063 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169825;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.894952  Lock_time: 0.000077 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169825;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:26
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.971543  Lock_time: 0.000050 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169826;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:27
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.163860  Lock_time: 0.000060 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169827;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.471821  Lock_time: 0.000070 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169827;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.655095  Lock_time: 0.000071 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169827;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.962486  Lock_time: 0.000059 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169827;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.966252  Lock_time: 0.000060 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169827;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:28
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.936644  Lock_time: 0.000059 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169828;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.273107  Lock_time: 0.000082 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169828;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 28.291967  Lock_time: 0.000076 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169828;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:29
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 28.939764  Lock_time: 0.000053 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169829;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.267063  Lock_time: 0.000043 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169829;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.175207  Lock_time: 0.000070 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169829;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 28.566981  Lock_time: 0.000043 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169829;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:30
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.668199  Lock_time: 0.000060 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169830;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.953005  Lock_time: 0.000093 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169830;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 24.167812  Lock_time: 0.008014 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169830;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:31
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.296396  Lock_time: 0.000058 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169831;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.355743  Lock_time: 0.000073 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169831;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.965549  Lock_time: 0.000072 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169831;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:32
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 22.512264  Lock_time: 0.000089 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169832;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.632924  Lock_time: 0.000076 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169832;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 22.939884  Lock_time: 0.000090 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169832;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:33
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.393014  Lock_time: 0.000081 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169833;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.780737  Lock_time: 0.000080 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169833;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.978960  Lock_time: 0.000072 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169833;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 18.435888  Lock_time: 0.000100 Rows_sent: 21  Rows_examined: 129073
SET timestamp=1392169833;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 17.875847  Lock_time: 0.000133 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169833;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 19.039829  Lock_time: 0.000095 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169833;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 19.590882  Lock_time: 0.000112 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169833;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.595369  Lock_time: 0.000073 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169833;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:50:34
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 18.574480  Lock_time: 0.000088 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169834;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 19.038509  Lock_time: 0.000089 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169834;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 18.486494  Lock_time: 0.000102 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169834;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 17.804423  Lock_time: 0.000105 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169834;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 38.956175  Lock_time: 0.000058 Rows_sent: 0  Rows_examined: 0
SET timestamp=1392169834;
INSERT INTO piwigo_images
  (file,name,date_available,path,filesize,width,height,md5sum,added_by,rotation,level)
  VALUES('jardins-055.jpg','jardins-055','2014-02-12 02:49:55','./upload/2014/02/12/20140212024955-e7c2b430.jpg','351','1112','1600','e7c2b43086f431529a6dc501ff9bc622','1','0','0');
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 18.715898  Lock_time: 0.000113 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169834;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 16.417333  Lock_time: 0.000129 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169834;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 16.762201  Lock_time: 0.000087 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169834;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 17.496248  Lock_time: 0.000094 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169834;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 16.547889  Lock_time: 0.000094 Rows_sent: 983  Rows_examined: 132001
SET timestamp=1392169834;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:50:47
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 11.291637  Lock_time: 0.000076 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169847;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:48
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 11.981234  Lock_time: 0.000062 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169848;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:49
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 12.681716  Lock_time: 0.000039 Rows_sent: 0  Rows_examined: 129056
SET timestamp=1392169849;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>8;
# Time: 140212  2:50:50
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 13.733917  Lock_time: 0.000073 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169850;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 13.804263  Lock_time: 0.000071 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169850;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 14.036422  Lock_time: 0.000076 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169850;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 14.109282  Lock_time: 0.000054 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169850;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:51
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 14.317800  Lock_time: 0.000071 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169851;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 14.156062  Lock_time: 0.000079 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169851;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 14.855541  Lock_time: 0.000073 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169851;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 15.061747  Lock_time: 0.000101 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169851;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:52
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 15.324308  Lock_time: 0.000079 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169852;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 15.652580  Lock_time: 0.000083 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169852;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:54
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 16.970206  Lock_time: 0.000054 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169854;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:56
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 18.563461  Lock_time: 0.000061 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169856;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:57
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 19.305811  Lock_time: 0.000067 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169857;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:50:59
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.065943  Lock_time: 0.000054 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169859;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:02
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.150973  Lock_time: 0.000078 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169862;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:03
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.989835  Lock_time: 0.000105 Rows_sent: 0  Rows_examined: 129056
SET timestamp=1392169863;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>8;
# Time: 140212  2:51:04
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.206338  Lock_time: 0.000070 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169864;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:05
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.766282  Lock_time: 0.000059 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169865;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:08
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 28.325947  Lock_time: 0.000097 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169868;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:11
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.938322  Lock_time: 0.000066 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169871;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.625981  Lock_time: 0.000052 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169871;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.620867  Lock_time: 0.000083 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169871;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:12
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.017703  Lock_time: 0.000067 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169872;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.073336  Lock_time: 0.000078 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169872;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.839276  Lock_time: 0.000080 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169872;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:14
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.570989  Lock_time: 0.000071 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169874;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.927337  Lock_time: 0.000076 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169874;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 33.602402  Lock_time: 0.000069 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169874;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:16
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 33.713088  Lock_time: 0.000077 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169876;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:17
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.809729  Lock_time: 0.000136 Rows_sent: 7  Rows_examined: 178568
use hrules;
SET timestamp=1392169877;
SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts  LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users'  ORDER BY  ratings_average desc, ratings_users desc LIMIT 42, 7;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 34.408328  Lock_time: 0.000074 Rows_sent: 21  Rows_examined: 129077
use piwigal;
SET timestamp=1392169877;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:18
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 34.552812  Lock_time: 0.000064 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169878;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:19
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 36.028794  Lock_time: 0.000094 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169879;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:22
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 38.048158  Lock_time: 0.000081 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169882;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:23
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 39.666836  Lock_time: 0.000073 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169883;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:25
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 39.775897  Lock_time: 0.000077 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169885;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:27
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 39.411602  Lock_time: 0.000080 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169887;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 40.953251  Lock_time: 0.000074 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169887;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 39.905612  Lock_time: 0.000071 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169887;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 40.556043  Lock_time: 0.000075 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169887;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 40.258228  Lock_time: 0.000070 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169887;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:29
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 41.835780  Lock_time: 0.000055 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169889;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:30
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 43.675886  Lock_time: 0.000077 Rows_sent: 21  Rows_examined: 129077
SET timestamp=1392169890;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 140212  2:51:35
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 46.160071  Lock_time: 0.000089 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169895;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:36
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 46.211963  Lock_time: 0.000088 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169896;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 46.992086  Lock_time: 0.000101 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169896;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:37
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 46.776842  Lock_time: 0.000119 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169897;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=8
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 48.735872  Lock_time: 0.000130 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169897;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:38
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 47.687281  Lock_time: 0.000110 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169898;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 48.213223  Lock_time: 0.000109 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169898;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:39
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 48.411265  Lock_time: 0.000079 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169899;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 48.880359  Lock_time: 0.000076 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169899;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.520044  Lock_time: 0.000078 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169899;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:40
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.234839  Lock_time: 0.000094 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169900;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.688960  Lock_time: 0.000096 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169900;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.060049  Lock_time: 0.000110 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169900;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 50.120078  Lock_time: 0.000117 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169900;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 48.777151  Lock_time: 0.000088 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169900;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 50.871275  Lock_time: 0.000080 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169900;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:41
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.453980  Lock_time: 0.000098 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169901;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 48.702002  Lock_time: 0.014532 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169901;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 50.359122  Lock_time: 0.000114 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169901;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.481441  Lock_time: 0.000097 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169901;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.287740  Lock_time: 0.000088 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169901;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.879756  Lock_time: 0.000087 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169901;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.578389  Lock_time: 0.000089 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169901;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:42
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 47.780748  Lock_time: 0.000195 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169902;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 43.124656  Lock_time: 17.691608 Rows_sent: 7  Rows_examined: 178568
use hrules;
SET timestamp=1392169902;
SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts  LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users'  ORDER BY  ratings_average desc, ratings_users desc LIMIT 42, 7;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.987692  Lock_time: 0.000119 Rows_sent: 983  Rows_examined: 132005
use piwigal;
SET timestamp=1392169902;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 47.490448  Lock_time: 0.021753 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169902;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.724180  Lock_time: 0.000123 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169902;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 50.559357  Lock_time: 0.026249 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169902;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:43
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.782475  Lock_time: 0.000092 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169903;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.158517  Lock_time: 0.000222 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169903;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.108525  Lock_time: 0.000236 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169903;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:44
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 48.122979  Lock_time: 0.000169 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169904;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.423189  Lock_time: 0.000135 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169904;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.702055  Lock_time: 0.007681 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169904;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 50.214091  Lock_time: 0.000160 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169904;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:45
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.268845  Lock_time: 0.014162 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169905;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:46
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 48.050697  Lock_time: 0.004150 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169906;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.652576  Lock_time: 0.001820 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169906;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.053565  Lock_time: 0.000182 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169906;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 48.975439  Lock_time: 0.004577 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169906;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 48.211381  Lock_time: 0.000347 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169906;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 48.955097  Lock_time: 0.000155 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169906;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:47
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 46.388978  Lock_time: 0.006122 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169907;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 47.232915  Lock_time: 0.000179 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169907;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 47.323751  Lock_time: 0.000277 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169907;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 46.745572  Lock_time: 0.047738 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169907;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 47.853567  Lock_time: 0.009898 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169907;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 45.472174  Lock_time: 0.000257 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169907;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:48
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 46.924980  Lock_time: 0.000231 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169908;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 48.144147  Lock_time: 0.000647 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169908;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 47.291490  Lock_time: 0.000257 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169908;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.161835  Lock_time: 0.000194 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169908;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 46.064190  Lock_time: 0.000154 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169908;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 45.618940  Lock_time: 0.000257 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169908;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:49
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 45.902005  Lock_time: 0.000166 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169909;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=8
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 44.058500  Lock_time: 0.000201 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169909;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 49.200940  Lock_time: 0.000251 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169909;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 46.649293  Lock_time: 0.000186 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169909;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:50
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 44.122548  Lock_time: 0.000247 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169910;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 45.540567  Lock_time: 0.000163 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169910;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 46.282864  Lock_time: 0.000238 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169910;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:51
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 42.335302  Lock_time: 0.000185 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169911;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 39.259188  Lock_time: 0.000163 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169911;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 40.042758  Lock_time: 0.000166 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169911;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 39.988972  Lock_time: 0.000179 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169911;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:52
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 37.830403  Lock_time: 0.000155 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169912;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 40.283500  Lock_time: 0.000166 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169912;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 39.487866  Lock_time: 0.000144 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169912;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 40.085055  Lock_time: 0.000170 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169912;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 37.900078  Lock_time: 0.000153 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169912;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 38.602358  Lock_time: 0.000145 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169912;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 34.747293  Lock_time: 0.000168 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169912;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:53
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 34.971578  Lock_time: 0.005424 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169913;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 36.119665  Lock_time: 0.000188 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169913;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 33.225639  Lock_time: 0.000226 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169913;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 34.629969  Lock_time: 0.000241 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169913;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 35.479757  Lock_time: 0.000163 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169913;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 33.160794  Lock_time: 0.000195 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169913;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 34.137684  Lock_time: 0.000195 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169913;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.640927  Lock_time: 0.000214 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169913;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 33.240119  Lock_time: 0.000228 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169913;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.317672  Lock_time: 0.000213 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169913;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 28.195217  Lock_time: 0.000207 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169913;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:51:54
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.669370  Lock_time: 0.000216 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169914;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.027024  Lock_time: 0.000132 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169914;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.651769  Lock_time: 0.000191 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169914;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.030490  Lock_time: 0.000116 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169914;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.795836  Lock_time: 0.000200 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169914;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.821977  Lock_time: 0.000193 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169914;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 24.207013  Lock_time: 0.000192 Rows_sent: 983  Rows_examined: 132005
SET timestamp=1392169914;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:52:49
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 19.449131  Lock_time: 6.757255 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169969;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 22.542765  Lock_time: 9.829521 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169969;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.822192  Lock_time: 11.015872 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169969;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.499228  Lock_time: 8.643514 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169969;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.813930  Lock_time: 7.865853 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169969;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.978846  Lock_time: 9.025280 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169969;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  2:52:50
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.601931  Lock_time: 7.539428 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.817255  Lock_time: 7.749863 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.179828  Lock_time: 8.110478 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.663311  Lock_time: 8.588418 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.733778  Lock_time: 8.642930 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 22.490170  Lock_time: 9.338976 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.594480  Lock_time: 7.442980 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.221680  Lock_time: 7.067367 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.805308  Lock_time: 7.618226 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.463411  Lock_time: 7.267281 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.343288  Lock_time: 8.137650 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.452822  Lock_time: 8.228714 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.793592  Lock_time: 10.564601 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.729614  Lock_time: 7.506263 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 22.303827  Lock_time: 9.054326 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.696541  Lock_time: 8.444795 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.462069  Lock_time: 14.211918 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 19.638067  Lock_time: 6.354876 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.724670  Lock_time: 7.440837 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.265057  Lock_time: 7.977069 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 19.869842  Lock_time: 6.577224 Rows_sent: 982  Rows_examined: 131994
SET timestamp=1392169970;
SELECT c.id AS cat_id, id_uppercat,
  MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
  LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
  LEFT JOIN piwigo_images AS i
    ON ic.image_id = i.id
      AND i.level<=0
  GROUP BY c.id;
# Time: 140212  5:00:47
# User@Host: root[root] @ localhost []
# Query_time: 33.825194  Lock_time: 0.000015 Rows_sent: 220970  Rows_examined: 220970
use gallery_dump;
SET timestamp=1392177647;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `galleries`;
# Time: 140212  5:01:59
# User@Host: root[root] @ localhost []
# Query_time: 11.796082  Lock_time: 0.000018 Rows_sent: 369818  Rows_examined: 369818
use gallery_dump_forum;
SET timestamp=1392177719;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `phpbb3_posts`;