A long mysql-slow.log

# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 10.239178  Lock_time: 0.000072 Rows_sent: 0  Rows_examined: 124108
SET timestamp=1391125534;
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.310365  Lock_time: 0.000073 Rows_sent: 0  Rows_examined: 124108
SET timestamp=1391125534;
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: 140131  0:45:43
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 18.542793  Lock_time: 0.000099 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125543;
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.761835  Lock_time: 0.000108 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125543;
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: 140131  0:45:45
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 20.068993  Lock_time: 0.003261 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125545;
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: 140131  0:45:46
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.539741  Lock_time: 0.000090 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125546;
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.042279  Lock_time: 0.000127 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125546;
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: 140131  0:45:47
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 21.675343  Lock_time: 0.000105 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125547;
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.113090  Lock_time: 0.000113 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125547;
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: 140131  0:45:48
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.039748  Lock_time: 0.000095 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125548;
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.056697  Lock_time: 0.000119 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125548;
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: 140131  0:45:49
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.924102  Lock_time: 0.000067 Rows_sent: 0  Rows_examined: 0
SET timestamp=1391125549;
INSERT INTO piwigo_images
  (file,name,date_available,path,filesize,width,height,md5sum,added_by,rotation,level)
  VALUES('what-www.lesiteweb.net-21.jpg','what-www.lesiteweb.net-21','2014-01-31 00:45:24','./upload/2014/01/31/20140131004524-ce44ea0e.jpg','446','1063','1500','ce44ea0ec843da10afe90e6d85ef35dc','1','0','0');
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 23.750881  Lock_time: 0.000093 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125549;
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: 140131  0:45:51
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 24.735669  Lock_time: 0.000086 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125551;
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.111034  Lock_time: 0.000097 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125551;
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: 140131  0:45:52
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.421081  Lock_time: 0.000094 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125552;
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: 140131  0:45:55
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 28.606223  Lock_time: 0.000105 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125555;
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: 140131  0:45:56
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 28.470486  Lock_time: 0.000089 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125556;
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: 140131  0:45:58
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 29.533972  Lock_time: 0.000089 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125558;
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.349243  Lock_time: 0.000091 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125558;
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.731639  Lock_time: 0.000088 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125558;
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.040677  Lock_time: 0.000095 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125558;
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: 140131  0:45:59
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 29.251829  Lock_time: 0.000118 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125559;
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.365368  Lock_time: 0.000090 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125559;
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.521248  Lock_time: 0.000099 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125559;
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.283175  Lock_time: 0.000097 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125559;
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: 140131  0:46:00
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 29.526385  Lock_time: 0.000122 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125560;
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.292745  Lock_time: 0.000103 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125560;
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.608166  Lock_time: 0.000086 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125560;
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: 140131  0:46:01
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.524258  Lock_time: 0.000123 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125561;
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.855901  Lock_time: 0.000098 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125561;
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.320050  Lock_time: 0.000106 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125561;
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.422072  Lock_time: 0.000085 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125561;
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.510838  Lock_time: 0.000111 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125561;
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: 140131  0:46:02
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.277202  Lock_time: 0.000117 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125562;
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.845326  Lock_time: 0.000120 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125562;
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.499843  Lock_time: 0.000082 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125562;
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.436185  Lock_time: 0.000077 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125562;
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.075464  Lock_time: 0.000084 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125562;
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.191417  Lock_time: 0.000071 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125562;
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.343709  Lock_time: 0.000080 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125562;
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.830652  Lock_time: 0.000103 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125562;
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.693829  Lock_time: 0.000094 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125562;
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.162936  Lock_time: 0.000093 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125562;
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.286610  Lock_time: 0.000103 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125562;
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: 140131  0:46:03
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.252322  Lock_time: 0.000082 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125563;
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.839812  Lock_time: 0.000096 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125563;
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.359572  Lock_time: 0.000092 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125563;
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.998995  Lock_time: 0.000059 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125563;
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.952563  Lock_time: 0.000067 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125563;
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.352406  Lock_time: 0.000149 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125563;
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.188127  Lock_time: 0.000096 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125563;
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.576428  Lock_time: 0.000080 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125563;
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.841625  Lock_time: 0.000075 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125563;
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: 140131  0:46:04
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.003043  Lock_time: 0.000092 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.562765  Lock_time: 0.000142 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.900625  Lock_time: 0.000144 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.787153  Lock_time: 0.000140 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.449030  Lock_time: 0.000207 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.093857  Lock_time: 0.000134 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.450005  Lock_time: 0.000126 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.971920  Lock_time: 0.000211 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.302500  Lock_time: 0.000156 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.597717  Lock_time: 0.000127 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.845241  Lock_time: 0.000128 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.897514  Lock_time: 0.000150 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.520564  Lock_time: 0.000177 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.717641  Lock_time: 0.000175 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.538647  Lock_time: 0.015942 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.498175  Lock_time: 0.000133 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.720716  Lock_time: 0.135633 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.579292  Lock_time: 0.000202 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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.369607  Lock_time: 0.000169 Rows_sent: 954  Rows_examined: 126970
SET timestamp=1391125564;
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: 140131  0:46:36
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 25.264121  Lock_time: 1.209306 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125596;
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: 140131  0:46:39
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 26.699553  Lock_time: 0.061509 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125599;
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.355768  Lock_time: 1.397375 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125599;
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: 140131  0:46:40
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 27.835570  Lock_time: 0.253806 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125600;
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.236892  Lock_time: 0.473774 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125600;
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: 140131  0:46:41
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 29.839923  Lock_time: 1.675001 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125601;
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.610033  Lock_time: 1.966305 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125601;
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.482252  Lock_time: 0.562739 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125601;
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: 140131  0:46:42
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 29.652104  Lock_time: 0.000092 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125602;
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: 140131  0:46:43
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.945201  Lock_time: 0.716672 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125603;
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.279328  Lock_time: 0.000041 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125603;
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: 140131  0:46:44
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.555914  Lock_time: 0.000049 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125604;
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: 140131  0:46:45
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 31.684929  Lock_time: 0.000057 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125605;
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: 34.910187  Lock_time: 2.159383 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125605;
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.322438  Lock_time: 0.000052 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125605;
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: 140131  0:46:46
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 33.312000  Lock_time: 0.011168 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125606;
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.424707  Lock_time: 0.000070 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125606;
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.498471  Lock_time: 0.053617 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125606;
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.633134  Lock_time: 0.000063 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125606;
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.656001  Lock_time: 0.000117 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125606;
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.722113  Lock_time: 0.000063 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125606;
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: 34.134028  Lock_time: 0.077133 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125606;
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: 140131  0:46:47
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.865457  Lock_time: 0.000048 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125607;
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.258772  Lock_time: 0.000073 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125607;
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.924467  Lock_time: 0.000064 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125607;
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: 140131  0:46:48
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 35.163388  Lock_time: 0.042558 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125608;
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.800682  Lock_time: 0.003124 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125608;
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.882053  Lock_time: 0.000074 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125608;
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: 140131  0:46:49
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 36.114173  Lock_time: 0.017736 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125609;
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.960887  Lock_time: 0.000072 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125609;
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: 140131  0:46:50
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 36.027267  Lock_time: 0.000062 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125610;
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: 36.373837  Lock_time: 0.000072 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125610;
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: 140131  0:46:51
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 36.059420  Lock_time: 0.000079 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125611;
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: 140131  0:46:52
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 37.250862  Lock_time: 0.000058 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125612;
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: 140131  0:46:53
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 37.891030  Lock_time: 0.000072 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125613;
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: 140131  0:46:54
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 37.664361  Lock_time: 0.000045 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125614;
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.955342  Lock_time: 0.000070 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125614;
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: 140131  0:46:55
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 39.068653  Lock_time: 0.000065 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125615;
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.784974  Lock_time: 0.000055 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125615;
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.614245  Lock_time: 0.000068 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125615;
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: 140131  0:46:56
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 37.951571  Lock_time: 0.000095 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125616;
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: 140131  0:46:57
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 39.259990  Lock_time: 0.000047 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125617;
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.751800  Lock_time: 0.000068 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125617;
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.595558  Lock_time: 0.000058 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125617;
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: 140131  0:46:58
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 40.440036  Lock_time: 0.000071 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125618;
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: 140131  0:47:00
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 39.554969  Lock_time: 0.000058 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125620;
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: 41.129477  Lock_time: 0.000067 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125620;
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.311865  Lock_time: 0.000062 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125620;
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: 140131  0:47:01
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 40.534280  Lock_time: 0.000058 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125621;
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: 41.526514  Lock_time: 0.000068 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125621;
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: 140131  0:47:03
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 41.247432  Lock_time: 0.000066 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125623;
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: 140131  0:47:04
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 40.061249  Lock_time: 0.000071 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125624;
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.515108  Lock_time: 0.000066 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125624;
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.447544  Lock_time: 0.000057 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125624;
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.289192  Lock_time: 0.000057 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125624;
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.225999  Lock_time: 0.000048 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125624;
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: 140131  0:47:05
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 41.842666  Lock_time: 0.000061 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125625;
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.614133  Lock_time: 0.000055 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125625;
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: 43.134134  Lock_time: 0.000070 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125625;
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: 140131  0:47:06
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 41.363185  Lock_time: 0.000069 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125626;
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.281606  Lock_time: 0.000043 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125626;
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: 41.214466  Lock_time: 0.000057 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125626;
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: 140131  0:47:07
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 41.791762  Lock_time: 0.000061 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125627;
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.035470  Lock_time: 0.000055 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125627;
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.645301  Lock_time: 0.000052 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125627;
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.629982  Lock_time: 0.000063 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125627;
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.451843  Lock_time: 0.000067 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125627;
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: 140131  0:47:08
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 38.783322  Lock_time: 0.000066 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125628;
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: 38.616679  Lock_time: 0.000055 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125628;
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: 38.804495  Lock_time: 0.000107 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125628;
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.272913  Lock_time: 0.000073 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125628;
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.305397  Lock_time: 0.000104 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125628;
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: 38.078305  Lock_time: 0.000148 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125628;
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: 140131  0:47:09
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 37.993313  Lock_time: 0.000147 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125629;
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.967822  Lock_time: 0.000105 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125629;
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.684032  Lock_time: 0.000126 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125629;
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: 38.267886  Lock_time: 0.000123 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125629;
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: 36.397921  Lock_time: 0.000141 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125629;
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: 36.422448  Lock_time: 0.000246 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125629;
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: 140131  0:47:10
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 36.542604  Lock_time: 0.000154 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125630;
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: 38.655692  Lock_time: 0.016146 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125630;
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: 35.979880  Lock_time: 0.000150 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125630;
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.197223  Lock_time: 0.002248 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125630;
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.724782  Lock_time: 0.000135 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125630;
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: 140131  0:47:11
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 30.526453  Lock_time: 0.000161 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125631;
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.685766  Lock_time: 0.000148 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125631;
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.880421  Lock_time: 0.000193 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125631;
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: 35.542911  Lock_time: 0.000142 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125631;
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: 34.577201  Lock_time: 0.000165 Rows_sent: 0  Rows_examined: 124114
SET timestamp=1391125631;
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: 140131  0:47:12
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 35.188545  Lock_time: 0.000106 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125632;
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.946286  Lock_time: 0.000119 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125632;
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.995535  Lock_time: 0.000092 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125632;
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: 55.995979  Lock_time: 0.000055 Rows_sent: 0  Rows_examined: 0
SET timestamp=1391125632;
INSERT INTO piwigo_images
  (file,name,date_available,path,filesize,width,height,md5sum,added_by,rotation,level)
  VALUES('what-www.lesiteweb.net-24.jpg','what-www.lesiteweb.net-24','2014-01-31 00:46:14','./upload/2014/01/31/20140131004614-4726de0a.jpg','351','1063','1500','4726de0adca382b9d04c975dd84d5ce4','1','0','0');
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 32.729680  Lock_time: 0.000125 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125632;
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.960845  Lock_time: 0.000114 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125632;
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.512756  Lock_time: 0.000107 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125632;
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.286973  Lock_time: 0.000106 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125632;
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.770975  Lock_time: 0.000132 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125632;
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.488213  Lock_time: 0.000112 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125632;
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.972516  Lock_time: 0.000100 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125632;
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.404046  Lock_time: 0.003961 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125632;
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: 140131  0:47:13
# User@Host: lesiteweb[lesiteweb] @ localhost []
# Query_time: 28.066575  Lock_time: 0.000068 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125633;
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.167235  Lock_time: 0.000118 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125633;
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.351702  Lock_time: 0.000160 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125633;
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.905704  Lock_time: 0.000183 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125633;
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.381491  Lock_time: 0.000090 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125633;
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.914024  Lock_time: 0.000263 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125633;
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.822946  Lock_time: 0.000076 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125633;
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.932495  Lock_time: 0.000109 Rows_sent: 954  Rows_examined: 126976
SET timestamp=1391125633;
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;