/usr/libexec/mysqld, Version: 5.5.39 (MySQL Community Server (GPL) by Remi). started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
# Time: 140903 18:18:26
# User@Host: piwigo_user[piwigo_user] @ localhost []
# Query_time: 5.535561  Lock_time: 0.000653 Rows_sent: 147352  Rows_examined: 589408
use piwigo;
SET timestamp=1409764706;
SELECT DISTINCT(image_id)
  FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    1=1

# Time: 140903 18:24:32
# User@Host: piwigo_user[piwigo_user] @ localhost []
# Query_time: 63.627989  Lock_time: 0.667506 Rows_sent: 147352  Rows_examined: 589408
SET timestamp=1409765072;
SELECT DISTINCT(image_id)
  FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    1=1

  ORDER BY file ASC, date_creation DESC;
# Time: 140903 18:24:36
# User@Host: piwigo_user[piwigo_user] @ localhost []
# Query_time: 67.439250  Lock_time: 0.256758 Rows_sent: 147352  Rows_examined: 589408
SET timestamp=1409765076;
SELECT DISTINCT(image_id)
  FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    1=1

  ORDER BY file ASC, date_creation DESC;
# Time: 140903 18:24:42
# User@Host: piwigo_user[piwigo_user] @ localhost []
# Query_time: 73.724821  Lock_time: 0.072095 Rows_sent: 147352  Rows_examined: 589408
SET timestamp=1409765082;
SELECT DISTINCT(image_id)
  FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    1=1

  ORDER BY file ASC, date_creation DESC;
# User@Host: piwigo_user[piwigo_user] @ localhost []
# Query_time: 76.847180  Lock_time: 1.195185 Rows_sent: 147352  Rows_examined: 589408
SET timestamp=1409765084;
SELECT DISTINCT(image_id)
  FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    1=1

  ORDER BY file ASC, date_creation DESC;
# Time: 140903 18:24:48
# User@Host: piwigo_user[piwigo_user] @ localhost []
# Query_time: 79.574701  Lock_time: 0.650917 Rows_sent: 147352  Rows_examined: 589408
SET timestamp=1409765088;
SELECT DISTINCT(image_id)
  FROM piwigo_image_category
    INNER JOIN piwigo_images ON id = image_id
  WHERE
    1=1

  ORDER BY file ASC, date_creation DESC;