FrenchDeutschEnglishSpanish

Travail in situ permanent
[Mai] 2016
Otemachi Financial City Grand Cube, Tokyo, Japon


(default) 27 queries took 87 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `db_artworks`1421428
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SHOW FULL COLUMNS FROM `db_artworks_langs`32323
4SHOW FULL COLUMNS FROM `db_images`24242
5SHOW FULL COLUMNS FROM `db_exhibits`65653
6SHOW FULL COLUMNS FROM `db_exhibits_langs`18182
7SHOW FULL COLUMNS FROM `db_bibliodetails_exhibits`662
8SHOW FULL COLUMNS FROM `db_biblios_details`771
9SHOW FULL COLUMNS FROM `db_biblios`17172
10SHOW FULL COLUMNS FROM `db_countries`661
11SHOW FULL COLUMNS FROM `db_biblios_temp`1891898
12SHOW FULL COLUMNS FROM `db_contacts`50503
13SHOW FULL COLUMNS FROM `db_bibliodetails_contacts`332
14SHOW FULL COLUMNS FROM `db_biblios_contacts`331
15SHOW FULL COLUMNS FROM `db_bibliodetails_artworks`661
16SHOW FULL COLUMNS FROM `db_bibliodetails_images`661
17SHOW FULL COLUMNS FROM `db_bibliodetails_designs`661
18SHOW FULL COLUMNS FROM `db_artworks_exhibits`331
19SHOW FULL COLUMNS FROM `db_designs_exhibits`331
20SHOW FULL COLUMNS FROM `db_images_langs`551
21SHOW FULL COLUMNS FROM `db_artworks_designs`331
22SHOW FULL COLUMNS FROM `db_langs`551
23SELECT `Lang`.`id`, `Lang`.`name`, `Lang`.`title`, `Lang`.`image`, `Lang`.`is_active` FROM `db_langs` AS `Lang` WHERE 1 = 1 440
24SELECT `Artwork`.`annee_debut` FROM `db_artworks` AS `Artwork` WHERE `Artwork`.`is_active`=1 AND `Artwork`.`annee_debut`<>'' AND `Artwork`.`typologie` LIKE('%permanent%') GROUP BY `Artwork`.`annee_debut` ORDER BY `Artwork`.`annee_debut` DESC 31314
25SELECT COUNT(*) AS `count` FROM `db_artworks` AS `Artwork` inner JOIN db_artworks_langs AS `ArtworkLang` ON (`ArtworkLang`.`artwork_id`=`Artwork`.`id` AND `ArtworkLang`.`lang` = 'fre') WHERE `ArtworkLang`.`lang` = 'fre' AND `Artwork`.`is_active` = 1 AND `Artwork`.`typologie` LIKE('%permanent%') AND `Artwork`.`annee_debut` like('%2016%') AND `Artwork`.`type` = 'artwork' 113
26SELECT `Artwork`.*, `ArtworkLang`.*, `Artwork`.`id` FROM `db_artworks` AS `Artwork` inner JOIN db_artworks_langs AS `ArtworkLang` ON (`ArtworkLang`.`artwork_id`=`Artwork`.`id` AND `ArtworkLang`.`lang` = 'fre') WHERE `ArtworkLang`.`lang` = 'fre' AND `Artwork`.`is_active` = 1 AND `Artwork`.`typologie` LIKE('%permanent%') AND `Artwork`.`annee_debut` like('%2016%') AND `Artwork`.`type` = 'artwork' ORDER BY `Artwork`.`id` ASC LIMIT 101132
27SELECT `Image`.`id`, `Image`.`biblio_id`, `Image`.`expo_document`, `Image`.`expo_id`, `Image`.`image`, `Image`.`ext`, `Image`.`artwork_id`, `Image`.`artwork_never_exhibited`, `Image`.`order_in_expos`, `Image`.`order_in_artworks`, `Image`.`order_in_biblios`, `Image`.`video_flag`, `Image`.`video_url`, `Image`.`video`, `Image`.`is_active_artwork`, `Image`.`is_active_expo`, `Image`.`is_active_biblio`, `Image`.`tmp_filename`, `Image`.`tmp_filepath`, `Image`.`pdf`, `Image`.`pdf_flag`, `Image`.`design_id`, `Image`.`order_in_designs`, `Image`.`is_active_design` FROM `db_images` AS `Image` WHERE `Image`.`artwork_id` = (2546) ORDER BY `Image`.`order_in_artworks` ASC 13131