| Query | Error | Affected | Num. rows | Took (ms) | Actions |
|---|
| SHOW FULL COLUMNS FROM `jobs` | | 9 | 9 | 1 | maybe slow |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 0 | |
| SHOW FULL COLUMNS FROM `countries` | | 3 | 3 | 0 | |
| SHOW FULL COLUMNS FROM `weather_forecasts` | | 15 | 15 | 0 | |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 0 | |
| SHOW FULL COLUMNS FROM `hotels` | | 34 | 34 | 0 | |
| SHOW FULL COLUMNS FROM `cities` | | 6 | 6 | 0 | |
| SHOW FULL COLUMNS FROM `states` | | 3 | 3 | 0 | |
| SHOW FULL COLUMNS FROM `home_hotels` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `hotel_images` | | 6 | 6 | 0 | |
| SHOW FULL COLUMNS FROM `rooms` | | 15 | 15 | 0 | |
| SHOW FULL COLUMNS FROM `rooms_rates` | | 8 | 8 | 0 | |
| SHOW FULL COLUMNS FROM `rates_periods` | | 6 | 6 | 0 | |
| SHOW FULL COLUMNS FROM `rates_period_i18n` | | 6 | 6 | 0 | |
| SHOW FULL COLUMNS FROM `unavailabilities` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `envies` | | 3 | 3 | 0 | |
| SHOW FULL COLUMNS FROM `envie_i18n` | | 6 | 6 | 0 | |
| SHOW FULL COLUMNS FROM `envies_hotels` | | 2 | 2 | 0 | |
| SHOW FULL COLUMNS FROM `comments` | | 19 | 19 | 0 | |
| SHOW FULL COLUMNS FROM `users` | | 16 | 16 | 0 | |
| SHOW FULL COLUMNS FROM `addresses` | | 12 | 12 | 0 | |
| SHOW FULL COLUMNS FROM `janrain_profiles` | | 9 | 9 | 0 | |
| SHOW FULL COLUMNS FROM `admins` | | 15 | 15 | 0 | |
| SHOW FULL COLUMNS FROM `favorites` | | 8 | 8 | 0 | |
| SHOW FULL COLUMNS FROM `hotel_i18n` | | 6 | 6 | 0 | |
| SHOW FULL COLUMNS FROM `news` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `i18n` | | 6 | 6 | 0 | |
| SHOW FULL COLUMNS FROM `configs` | | 3 | 3 | 0 | |
| SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci'; | | 1 | 1 | 0 | |
| SELECT `Config`.*, `I18n__val`.`content`, `Config`.`id` FROM `configs` AS `Config` INNER JOIN `i18n` AS `I18n__val` ON (`Config`.`id` = `I18n__val`.`foreign_key` AND `I18n__val`.`model` = 'Config' AND `I18n__val`.`field` = 'val' AND `I18n__val`.`locale` = 'eng') WHERE 1 = 1 | | 1 | 1 | 0 | |
| SELECT `Vals`.`id`, `Vals`.`locale`, `Vals`.`model`, `Vals`.`foreign_key`, `Vals`.`field`, `Vals`.`content` FROM `i18n` AS `Vals` WHERE `model` = 'Config' AND `field` = 'val' AND `Vals`.`foreign_key` = (1) | | 2 | 2 | 0 | |
| SELECT `Config`.*, `I18n__val`.`content`, `Config`.`id` FROM `configs` AS `Config` INNER JOIN `i18n` AS `I18n__val` ON (`Config`.`id` = `I18n__val`.`foreign_key` AND `I18n__val`.`model` = 'Config' AND `I18n__val`.`field` = 'val' AND `I18n__val`.`locale` = 'eng') WHERE `key` = 'suggestion_libelle' LIMIT 1 | | 0 | 0 | 0 | |
| SELECT `Job`.*, `Country`.*, `I18n__name`.`content`, `I18n__category`.`content`, `I18n__location`.`content`, `I18n__description`.`content`, `I18n__availability`.`content`, `Job`.`id` FROM `jobs` AS `Job` INNER JOIN `i18n` AS `I18n__name` ON (`Job`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Job' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__category` ON (`Job`.`id` = `I18n__category`.`foreign_key` AND `I18n__category`.`model` = 'Job' AND `I18n__category`.`field` = 'category' AND `I18n__category`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__location` ON (`Job`.`id` = `I18n__location`.`foreign_key` AND `I18n__location`.`model` = 'Job' AND `I18n__location`.`field` = 'location' AND `I18n__location`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__description` ON (`Job`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Job' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__availability` ON (`Job`.`id` = `I18n__availability`.`foreign_key` AND `I18n__availability`.`model` = 'Job' AND `I18n__availability`.`field` = 'availability' AND `I18n__availability`.`locale` = 'eng') LEFT JOIN `countries` AS `Country` ON (`Job`.`country_id` = `Country`.`id`) WHERE 1 = 1 | | 1 | 1 | 2 | maybe slow |
| SELECT `Country`.`id`, `Country`.`name` FROM `countries` AS `Country` WHERE 1 = 1 ORDER BY `Country`.`name` ASC | | 256 | 256 | 0 | |
| SHOW FULL COLUMNS FROM `themes` | | 4 | 4 | 0 | |
| SHOW FULL COLUMNS FROM `theme_i18n` | | 6 | 6 | 0 | |
| SELECT `Theme`.*, `I18n__name`.`content`, `Theme`.`id` FROM `themes` AS `Theme` INNER JOIN `theme_i18n` AS `I18n__name` ON (`Theme`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Theme' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC | | 10 | 10 | 0 | |
| SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `theme_i18n` AS `Names` WHERE `model` = 'Theme' AND `field` = 'name' AND `Names`.`foreign_key` IN (6, 10, 7, 12, 11, 13, 5, 8, 4, 9) | | 20 | 20 | 0 | |
| SELECT `Theme`.`id`, `Theme`.`uri` FROM `themes` AS `Theme` WHERE 1 = 1 | | 10 | 10 | 0 | |
| SELECT `Envie`.*, `I18n__name`.`content`, `Envie`.`id` FROM `envies` AS `Envie` INNER JOIN `envie_i18n` AS `I18n__name` ON (`Envie`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Envie' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC | | 29 | 29 | 0 | |
| SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `envie_i18n` AS `Names` WHERE `model` = 'Envie' AND `field` = 'name' AND `Names`.`foreign_key` IN (19, 5, 6, 24, 8, 25, 4, 10, 12, 7, 9, 22, 30, 14, 26, 21, 3, 1, 13, 27, 18, 11, 28, 29, 16, 15, 23, 2, 17) | | 58 | 58 | 0 | |
| SELECT `Hotel`.`id`, `Country`.*, `Country`.`id` FROM `hotels` AS `Hotel` LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) WHERE 1 = 1 GROUP BY `Hotel`.`country_id` ORDER BY `Country`.`name` ASC | | 120 | 120 | 0 | |
| SHOW FULL COLUMNS FROM `promises` | | 3 | 3 | 0 | |
| SELECT `Promise`.*, `I18n__title`.`content`, `I18n__content`.`content`, `Promise`.`id` FROM `promises` AS `Promise` INNER JOIN `i18n` AS `I18n__title` ON (`Promise`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Promise' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') INNER JOIN `i18n` AS `I18n__content` ON (`Promise`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Promise' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'eng') WHERE 1 = 1 LIMIT 4 | | 4 | 4 | 0 | |
| SELECT `Titles`.`id`, `Titles`.`locale`, `Titles`.`model`, `Titles`.`foreign_key`, `Titles`.`field`, `Titles`.`content` FROM `i18n` AS `Titles` WHERE `model` = 'Promise' AND `field` = 'title' AND `Titles`.`foreign_key` IN (1, 2, 3, 4) | | 8 | 8 | 0 | |
| SELECT `Contents`.`id`, `Contents`.`locale`, `Contents`.`model`, `Contents`.`foreign_key`, `Contents`.`field`, `Contents`.`content` FROM `i18n` AS `Contents` WHERE `model` = 'Promise' AND `field` = 'content' AND `Contents`.`foreign_key` IN (1, 2, 3, 4) | | 8 | 8 | 0 | |
- RCP : Hiscox n° HA PRC0055186 - CNIL 1517931.
