Accueil - Apprendre le shiMaore, shiMwali, shiNdzuani, et shiNgazidja · ORELC

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent6e4859d7847d57ab0d629515a939ec27
  time1774553536
  countdown10
- platform(false)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerHomes
- actionindex
- named(empty)
- pass(empty)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
- options(array)
  defaultRoute(true)
- defaults(array)
  actionindex
  plugin(null)
- template/:controller
====

Sql Logs

default

Total Time: 476 ms
Total Queries: 180 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT COUNT(*) AS tot_rating FROM users WHERE rating IS NOT null	1	1	5	maybe slow
SELECT SUM(rating) AS sum_rating FROM users WHERE rating IS NOT null	1	1	6	maybe slow
SELECT COUNT(*) AS tot_rating FROM users WHERE rating IS NOT null	1	1	5	maybe slow
SELECT COUNT(*) AS `count` FROM `noniseshorelc`.`users` AS `User` WHERE ((`User`.`active_newsletter_notification` = '1') AND (`User`.`password` IS NOT null) AND (`User`.`email` NOT LIKE '%_NOTE') AND (`User`.`role` NOT LIKE '%social_user') AND (`User`.`active` = '1'))	1	1	7	maybe slow
SELECT count(*) as count FROM `users` AS User WHERE DATE(connected) = CURDATE() AND active = true	1	1	6	maybe slow
SELECT COUNT(DISTINCT(player_id)) AS count FROM high_scores	1	1	18	maybe slow
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name` FROM `noniseshorelc`.`users` AS `User` WHERE ((`User`.`created` >= '2026-03-26') AND (`User`.`active` = '1')) ORDER BY `User`.`created` DESC	6	6	13	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` IN (19590, 19591, 19592, 19593, 19594, 19595)	0	0	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` IN (19590, 19591, 19592, 19593, 19594, 19595) AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	0	0	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` IN (19590, 19591, 19592, 19593, 19594, 19595) AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` IN (19590, 19591, 19592, 19593, 19594, 19595) AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	0	0	0
SELECT word, `date_updated`, `date_created` FROM `shikomori_words` as ShikomoriWord WHERE active = true ORDER BY `date_updated` DESC, `date_created` DESC LIMIT 1;	1	1	3	maybe slow
SELECT COUNT(*) AS `count` FROM `noniseshorelc`.`shikomori_words` AS `ShikomoriWord` LEFT JOIN `noniseshorelc`.`shikomori_verbs` AS `ShikomoriVerb` ON (`ShikomoriVerb`.`shikomori_id` = `ShikomoriWord`.`id`) WHERE ((`ShikomoriWord`.`date_created` > '2026-03-23') OR (`ShikomoriWord`.`date_updated` > '2026-03-23'))	1	1	2	maybe slow
SELECT COUNT(*) AS `count` FROM `noniseshorelc`.`shikomori_verbs` AS `ShikomoriVerb` WHERE ((`ShikomoriVerb`.`date_created` > '2026-03-23') OR (`ShikomoriVerb`.`date_updated` > '2026-03-23'))	1	1	1
SELECT count(*) AS count FROM `french_lessons` WHERE (type = 'grammaire' OR type = 'vocabulaire' OR type = 'base') AND active = true AND (date_created > '2026-03-05' OR date_updated > '2026-03-05')	1	1	1
SELECT count(*) AS count FROM `french_lessons` WHERE type = 'Ressource' AND authorization NOT LIKE 'admin' AND `rank` NOT LIKE 'H%' AND `rank` NOT LIKE 'I%' AND active = true AND (date_created > '2026-03-05' OR date_updated > '2026-03-05')	1	1	0
SELECT DISTINCT `FrenchLesson`.`chapter`, `FrenchLesson`.`id`, `FrenchLesson`.`type`, `FrenchLesson`.`title`, `FrenchLesson`.`author_name`, `FrenchLesson`.`date_created`, `FrenchLesson`.`date_updated`, `FrenchLesson`.`date_published`, `FrenchLesson`.`chapter`, `FrenchLesson`.`description`, `FrenchLesson`.`closed`, `FrenchLesson`.`rank`, `FrenchLesson`.`active`, `FrenchLesson`.`licensed`, `FrenchLesson`.`thumbnail`, `FrenchLesson`.`purchase_link`, `FrenchLesson`.`publishing_house`, `FrenchLesson`.`verified`, `FrenchLesson`.`creator_id`, `FrenchLesson`.`editor_id`, `FrenchLesson`.`authorization` FROM `noniseshorelc`.`french_lessons` AS `FrenchLesson` LEFT JOIN `noniseshorelc`.`users` AS `User` ON (`FrenchLesson`.`editor_id` = `User`.`id`) WHERE `FrenchLesson`.`type` LIKE 'ressource' AND `FrenchLesson`.`type` NOT LIKE 'validation' AND `FrenchLesson`.`rank` NOT LIKE '%000%' AND `FrenchLesson`.`authorization` LIKE 'Public' AND `FrenchLesson`.`active` = '1' ORDER BY `date_published` DESC, `date_updated` DESC, `date_created` DESC, `id` DESC LIMIT 12	12	12	1	maybe slow
SELECT count(*) AS count FROM `shikomori_words` AS ShikomoriWord INNER JOIN users AS User ON ShikomoriWord.creator_id = User.id WHERE is_standard = false AND is_shimaore = true AND is_shingazidja = false AND is_shindzuani = false AND is_shimwali = false ORDER BY `ShikomoriWord`.`date_updated` DESC	1	1	3	maybe slow
SELECT count(*) AS count FROM `shikomori_words` AS ShikomoriWord INNER JOIN users AS User ON ShikomoriWord.creator_id = User.id WHERE is_standard = false AND is_shimaore = false AND is_shingazidja = false AND is_shindzuani = false AND is_shimwali = true ORDER BY `ShikomoriWord`.`date_updated` DESC	1	1	3	maybe slow
SELECT count(*) AS count FROM `shikomori_words` AS ShikomoriWord INNER JOIN users AS User ON ShikomoriWord.creator_id = User.id WHERE is_standard = false AND is_shimaore = false AND is_shingazidja = false AND is_shindzuani = true AND is_shimwali = false ORDER BY `ShikomoriWord`.`date_updated` DESC	1	1	3	maybe slow
SELECT count(*) AS count FROM `shikomori_words` AS ShikomoriWord INNER JOIN users AS User ON ShikomoriWord.creator_id = User.id WHERE is_standard = false AND is_shimaore = false AND is_shingazidja = true AND is_shindzuani = false AND is_shimwali = false ORDER BY `ShikomoriWord`.`date_updated` DESC	1	1	3	maybe slow
SELECT count(*) AS count FROM `shikomori_words` AS ShikomoriWord INNER JOIN users AS User ON ShikomoriWord.creator_id = User.id WHERE is_standard = false AND ( ( is_shimwali = true AND is_shingazidja = true AND is_shindzuani = false AND is_shimaore = false) OR (is_shimwali = false AND is_shingazidja = true AND is_shindzuani = true AND is_shimaore = false) OR (is_shimwali = false AND is_shingazidja = false AND is_shindzuani = true AND is_shimaore = true) OR (is_shimwali = true AND is_shingazidja = false AND is_shindzuani = true AND is_shimaore = false) OR (is_shimwali = true AND is_shingazidja = false AND is_shindzuani = false AND is_shimaore = true) OR (is_shimwali = false AND is_shingazidja = true AND is_shindzuani = false AND is_shimaore = true) ) ORDER BY `ShikomoriWord`.`date_updated` DESC	1	1	4	maybe slow
SELECT count(*) AS count FROM `shikomori_words` AS ShikomoriWord INNER JOIN users AS User ON ShikomoriWord.creator_id = User.id WHERE is_standard = false AND ( (is_shimwali = true AND is_shingazidja = true AND is_shindzuani = true AND is_shimaore = false) OR (is_shimwali = false AND is_shingazidja = true AND is_shindzuani = true AND is_shimaore = true) OR (is_shimwali = true AND is_shingazidja = false AND is_shindzuani = true AND is_shimaore = true) OR (is_shimwali = true AND is_shingazidja = true AND is_shindzuani = false AND is_shimaore = true) ) ORDER BY `ShikomoriWord`.`date_updated` DESC	1	1	3	maybe slow
SELECT count(*) AS count FROM `shikomori_words` AS ShikomoriWord INNER JOIN users AS User ON ShikomoriWord.editor_id = User.id WHERE is_standard = true OR (is_standard = false AND is_shimwali = true AND is_shingazidja = true AND is_shindzuani = true AND is_shimaore = true) ORDER BY `ShikomoriWord`.`date_updated` DESC	1	1	3	maybe slow
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`email` = '36' LIMIT 1	0	0	1	maybe slow
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	13	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	14	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	1	maybe slow
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`email` = '876' LIMIT 1	0	0	1	maybe slow
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 876 LIMIT 1	1	1	0
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (876)	0	0	16	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (876)	1	1	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 876 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	0	0	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 876 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 876 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 876 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (876)	0	0	14	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (876)	1	1	1
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 876 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	0	0	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 876 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	1	maybe slow
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 876 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`email` = '36' LIMIT 1	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	14	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	16	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`email` = '36' LIMIT 1	0	0	1	maybe slow
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	14	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	1	maybe slow
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	16	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`email` = '36' LIMIT 1	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	13	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	14	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`email` = '36' LIMIT 1	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	12	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	13	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`email` = '2205' LIMIT 1	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 2205 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (2205)	0	0	13	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (2205)	1	1	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 2205 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	0	0	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 2205 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 2205 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 2205 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (2205)	0	0	13	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (2205)	1	1	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 2205 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	0	0	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 2205 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 2205 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`email` = '2205' LIMIT 1	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 2205 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (2205)	0	0	13	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (2205)	1	1	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 2205 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	0	0	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 2205 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 2205 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 2205 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (2205)	0	0	13	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (2205)	1	1	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 2205 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	0	0	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 2205 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 2205 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`email` = '36' LIMIT 1	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	13	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	13	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`email` = '36' LIMIT 1	0	0	1	maybe slow
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	13	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	13	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`email` = '1616' LIMIT 1	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 1616 LIMIT 1	1	1	0
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (1616)	0	0	17	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (1616)	5	5	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 1616 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	0	0	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 1616 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 1616 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 1616 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (1616)	0	0	21	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (1616)	5	5	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 1616 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	0	0	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 1616 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 1616 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	0	0	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`email` = '36' LIMIT 1	0	0	1	maybe slow
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	23	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0
SELECT `User`.`id`, `User`.`email`, `User`.`security_email`, `User`.`payment_email`, `User`.`payment_id`, `User`.`biography`, `User`.`curriculum_vitae`, `User`.`thumbnail`, `User`.`sex`, `User`.`first_name`, `User`.`last_name`, `User`.`display_name`, `User`.`date_of_birth`, `User`.`address`, `User`.`phone`, `User`.`phone2`, `User`.`city`, `User`.`country`, `User`.`dialect`, `User`.`learning_dialect`, `User`.`shikomori_level`, `User`.`website`, `User`.`visio_url`, `User`.`password`, `User`.`password_question`, `User`.`password_response`, `User`.`digest_a1`, `User`.`rating`, `User`.`count_dictionary_contribution`, `User`.`count_ressource_contribution`, `User`.`count_of_words_to_revise`, `User`.`time_to_revise`, `User`.`revision_duration`, `User`.`license_registration_in_process`, `User`.`subscribe`, `User`.`certified`, `User`.`has_teacher`, `User`.`has_license_game`, `User`.`available`, `User`.`share_exercice`, `User`.`dictionary_signatory`, `User`.`requested_contribution`, `User`.`session_number`, `User`.`session_id`, `User`.`school_id`, `User`.`referral_code`, `User`.`referred`, `User`.`api_key`, `User`.`client_name`, `User`.`created`, `User`.`modified`, `User`.`connected`, `User`.`online`, `User`.`timezone`, `User`.`role`, `User`.`free_week_for_teacher`, `User`.`active_newsletter_notification`, `User`.`active_comment_notification`, `User`.`active`, `User`.`temp_user_data`, `User`.`access_token`, `User`.`access_token2`, `User`.`access_token3`, `User`.`access_token4`, `User`.`firebase_device_token_dictionary`, `User`.`firebase_device_token_luha`, `User`.`certificate_level`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", UPPER(LEFT(`User`.`last_name`, 1)), ".")) AS `User__short_name`, (IF( `User`.`last_name` != "" AND `User`.`last_name` IS NOT NULL, CONCAT( `User`.`first_name`, " ", IF(LOCATE(" ", `User`.`last_name`) = 0, CONCAT(UPPER(LEFT(`User`.`last_name`, 1)), "."), CONCAT( UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", 1), 1)), ". ", UPPER(LEFT(SUBSTRING_INDEX(`User`.`last_name`, " ", -1), 1)), "." ) ) ), `User`.`first_name` )) AS `User__short_full_name`, `SocialProfile`.`id`, `SocialProfile`.`user_id`, `SocialProfile`.`social_network_name`, `SocialProfile`.`social_network_id`, `SocialProfile`.`email`, `SocialProfile`.`display_name`, `SocialProfile`.`first_name`, `SocialProfile`.`last_name`, `SocialProfile`.`link`, `SocialProfile`.`picture`, `SocialProfile`.`created`, `SocialProfile`.`modified`, `SocialProfile`.`status` FROM `noniseshorelc`.`users` AS `User` LEFT JOIN `noniseshorelc`.`social_profiles` AS `SocialProfile` ON (`SocialProfile`.`user_id` = `User`.`id`) WHERE `User`.`id` = 36 LIMIT 1	1	1	1
SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (36)	0	0	21	maybe slow
SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Certificate`.`id`, `Certificate`.`name`, `Certificate`.`level`, `Certificate`.`max_note`, `Certificate`.`description`, `CertificateUser`.`certificate_id`, `CertificateUser`.`user_id`, `CertificateUser`.`mention`, `CertificateUser`.`note`, `CertificateUser`.`points`, `CertificateUser`.`date` FROM `noniseshorelc`.`certificates` AS `Certificate` JOIN `noniseshorelc`.`certificate_users` AS `CertificateUser` ON (`CertificateUser`.`user_id` = 36 AND `CertificateUser`.`certificate_id` = `Certificate`.`id`)	2	2	0
SELECT `Group`.`id`, `Group`.`referent_id`, `Group`.`name`, `Group`.`referent`, `Group`.`session_name`, `Group`.`tag`, `Group`.`type`, `Group`.`description`, `Group`.`level`, `Group`.`max_conference`, `Group`.`color`, `Group`.`active`, `Group`.`date_created`, `Group`.`date_updated`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`)) AS `Group__label`, (CONCAT(`Group`.`referent`, " - ", `Group`.`name`, " ", `Group`.`session_name`)) AS `Group__session_label`, `UserGroup`.`id`, `UserGroup`.`user_id`, `UserGroup`.`group_id` FROM `noniseshorelc`.`groups` AS `Group` JOIN `noniseshorelc`.`user_group` AS `UserGroup` ON (`UserGroup`.`user_id` = 36 AND `UserGroup`.`group_id` = `Group`.`id`)	0	0	0
SELECT `Conference`.`id`, `Conference`.`teacher_id`, `Conference`.`group_id`, `Conference`.`subject`, `Conference`.`level`, `Conference`.`description`, `Conference`.`titled`, `Conference`.`path_files`, `Conference`.`start_date`, `Conference`.`end_date`, `Conference`.`max_subscriber`, `Conference`.`is_group`, `Conference`.`is_free`, `Conference`.`is_stage`, `Conference`.`active`, `Conference`.`date_created`, `Conference`.`date_updated`, `Conference`.`execution_date`, `SubscribeConference`.`id`, `SubscribeConference`.`conference_id`, `SubscribeConference`.`user_id`, `SubscribeConference`.`signed`, `SubscribeConference`.`is_present`, `SubscribeConference`.`is_free`, `SubscribeConference`.`in_hour_pack`, `SubscribeConference`.`date_created` FROM `noniseshorelc`.`conferences` AS `Conference` JOIN `noniseshorelc`.`subscribe_conferences` AS `SubscribeConference` ON (`SubscribeConference`.`user_id` = 36 AND `SubscribeConference`.`conference_id` = `Conference`.`id`)	13	13	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 29.80 MB

Message	Memory use
Component initialization	18.75 MB
Controller action start	18.98 MB
Controller render start	21.54 MB
Component initialization #2	22.61 MB
Controller action start #2	22.64 MB
Component initialization #3	22.80 MB
Controller action start #3	22.83 MB
Component initialization #4	22.91 MB
Controller action start #4	22.94 MB
Component initialization #5	23.02 MB
Controller action start #5	23.05 MB
Component initialization #6	23.13 MB
Controller action start #6	23.15 MB
Component initialization #7	23.24 MB
Controller action start #7	23.26 MB
Component initialization #8	23.34 MB
Controller action start #8	23.37 MB
Component initialization #9	23.46 MB
Controller action start #9	23.49 MB
Component initialization #10	23.57 MB
Controller action start #10	23.59 MB
Component initialization #11	23.67 MB
Controller action start #11	23.70 MB
Component initialization #12	23.80 MB
Controller action start #12	23.82 MB
Component initialization #13	23.91 MB
Controller action start #13	23.93 MB
Component initialization #14	24.00 MB
Controller action start #14	24.02 MB
Component initialization #15	24.09 MB
Controller action start #15	24.12 MB
Component initialization #16	24.20 MB
Controller action start #16	24.24 MB
Component initialization #17	24.31 MB
Controller action start #17	24.33 MB
Component initialization #18	24.40 MB
Controller action start #18	24.43 MB
Component initialization #19	24.51 MB
Controller action start #19	24.54 MB
Component initialization #20	24.62 MB
Controller action start #20	24.64 MB
Component initialization #21	24.73 MB
Controller action start #21	24.76 MB
Component initialization #22	24.84 MB
Controller action start #22	24.87 MB
Component initialization #23	24.95 MB
Controller action start #23	24.98 MB
Component initialization #24	25.06 MB
Controller action start #24	25.09 MB
Component initialization #25	25.17 MB
Controller action start #25	25.20 MB
Component initialization #26	25.27 MB
Controller action start #26	25.30 MB
Component initialization #27	25.38 MB
Controller action start #27	25.41 MB
View render complete	25.57 MB

Timers

Total Request Time: 779 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	106.43
Event: Controller.initialize	0.16
Event: Controller.startup	3.03
Controller action	161.66
Event: Controller.beforeRender	9.44
» Processing toolbar data	9.39
Rendering View	464.10
» Event: View.beforeRender	0.01
» Rendering APP/View/Homes/index.ctp	461.16
» » Event: Controller.initialize #2	0.05
» » Event: Controller.startup #2	0.08
Controller action #2	0.00
» » » Event: Controller.shutdown	0.01
» » » Event: Controller.initialize #3	0.04
» » » Event: Controller.startup #3	0.09
Controller action #3	0.00
» » » » Event: Controller.shutdown #2	0.01
» » » » Event: Controller.initialize #4	0.04
» » » » Event: Controller.startup #4	0.08
Controller action #4	0.00
» » » » » Event: Controller.shutdown #3	0.01
» » » » » Event: Controller.initialize #5	0.04
» » » » » Event: Controller.startup #5	0.09
Controller action #5	0.00
» » » » » » Event: Controller.shutdown #4	0.02
» » » » » » Event: Controller.initialize #6	0.04
» » » » » » Event: Controller.startup #6	0.09
Controller action #6	0.00
» » » » » » » Event: Controller.shutdown #5	0.02
» » » » » » » Event: Controller.initialize #7	0.06
» » » » » » » Event: Controller.startup #7	0.12
Controller action #7	0.00
» » » » » » » » Event: Controller.shutdown #6	0.02
» » » » » » » » Event: Controller.initialize #8	0.07
» » » » » » » » Event: Controller.startup #8	0.13
Controller action #8	0.00
» » » » » » » » » Event: Controller.shutdown #7	0.02
» » » » » » » » » Event: Controller.initialize #9	0.06
» » » » » » » » » Event: Controller.startup #9	0.13
Controller action #9	0.00
» » » » » » » » » » Event: Controller.shutdown #8	0.02
» » » » » » » » » » Event: Controller.initialize #10	0.05
» » » » » » » » » » Event: Controller.startup #10	0.13
Controller action #10	0.00
» » » » » » » » » » » Event: Controller.shutdown #9	0.02
» » » » » » » » » » » Event: Controller.initialize #11	0.06
» » » » » » » » » » » Event: Controller.startup #11	0.13
Controller action #11	0.00
» » » » » » » » » » » » Event: Controller.shutdown #10	0.02
» » » » » » » » » » » » Event: Controller.initialize #12	0.05
» » » » » » » » » » » » Event: Controller.startup #12	0.11
Controller action #12	0.00
» » » » » » » » » » » » » Event: Controller.shutdown #11	0.02
» » » » » » » » » » » » » Event: Controller.initialize #13	0.07
» » » » » » » » » » » » » Event: Controller.startup #13	0.14
Controller action #13	0.00
» » » » » » » » » » » » » » Event: Controller.shutdown #12	0.01
» » » » » » » » » » » » » » Event: Controller.initialize #14	0.05
» » » » » » » » » » » » » » Event: Controller.startup #14	0.11
Controller action #14	0.00
» » » » » » » » » » » » » » » Event: Controller.shutdown #13	0.01
» » » » » » » » » » » » » » » Event: Controller.initialize #15	0.04
» » » » » » » » » » » » » » » Event: Controller.startup #15	0.08
Controller action #15	0.00
» » » » » » » » » » » » » » » » Event: Controller.shutdown #14	0.02
» » » » » » » » » » » » » » » » Event: Controller.initialize #16	0.06
» » » » » » » » » » » » » » » » Event: Controller.startup #16	0.14
Controller action #16	0.00
» » » » » » » » » » » » » » » » » Event: Controller.shutdown #15	0.02
» » » » » » » » » » » » » » » » » Event: Controller.initialize #17	0.05
» » » » » » » » » » » » » » » » » Event: Controller.startup #17	0.10
Controller action #17	0.00
» » » » » » » » » » » » » » » » » » Event: Controller.shutdown #16	0.01
» » » » » » » » » » » » » » » » » » Event: Controller.initialize #18	0.05
» » » » » » » » » » » » » » » » » » Event: Controller.startup #18	0.12
Controller action #18	0.00
» » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #17	0.01
» » » » » » » » » » » » » » » » » » » Event: Controller.initialize #19	0.04
» » » » » » » » » » » » » » » » » » » Event: Controller.startup #19	0.09
Controller action #19	0.00
» » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #18	0.01
» » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #20	0.04
» » » » » » » » » » » » » » » » » » » » Event: Controller.startup #20	0.10
Controller action #20	0.00
» » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #19	0.02
» » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #21	0.06
» » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #21	0.11
Controller action #21	0.00
» » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #20	0.02
» » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #22	0.06
» » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #22	0.12
Controller action #22	0.00
» » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #21	0.02
» » » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #23	0.06
» » » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #23	0.16
Controller action #23	0.00
» » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #22	0.01
» » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #24	0.05
» » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #24	0.09
Controller action #24	0.00
» » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #23	0.01
» » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #25	0.04
» » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #25	0.10
Controller action #25	0.00
» » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #24	0.02
» » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #26	0.04
» » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #26	0.10
Controller action #26	0.00
» » » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #25	0.02
» » » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #27	0.05
» » » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #27	0.11
Controller action #27	0.00
» » » » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #26	0.02
» » » » » » » » » » » » » » » » » » » » » » » » » » » Event: View.afterRender	0.01
» » » » » » » » » » » » » » » » » » » » » » » » » » » Event: View.beforeLayout	0.01
» » » » » » » » » » » » » » » » » » » » » » » » » » » Rendering APP/View/Layouts/default_home.ctp	2.19
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- lastDateShikomoriWord2026-02-28 21:30:24
- countModifiedRessourcesToday0
- countModifiedLessonsToday0
- countModifiedWordsVerbsToday0
- countModifiedWordsKmToday0
- countShiKomori4Words1160
- countShiKomori3Words491
- countShiKomori2Words1209
- countShiNgazidjaWords2979
- countShiNdzuaniWords699
- countShiMwaliWords228
- countShiMaoreWords917
- countWords7683
- lastResources(array)
  0(array)
  0(array)
  FrenchLesson(array)
  chapterOffre Spéciale
  id303
  typeressource
  titleL'offre spéciale Petit Kamusi
  author_nameORELC
  date_created2022-06-05 04:30:34
  date_updated2022-06-05 04:49:17
  date_published2022-06-05 04:37:47
  description<div><strong>L'offre spéciale Petit Kamusi pour apprendre à parler shiKomori !</strong></div> <div> </div> <div>Jusqu'au 4 juillet, pour tout Petit Kamusi acheté, profitez d'une remise de 50% sur les cours en ligne en Acces PLUS.</div> <div> </div> <div>Accès PLUS, c'est l'offre pour accéder à tous nos outils et ressources sur la langue comorienne :</div> <div>- Apprendre à Parler</div> <div>- Grammaire et Orthographe</div> <div>- Clavier ORELC</div> <div>-> <a href="../../../../FrenchLessons/viewLesson/302" target="_blank" rel="noopener noreferrer">Testez </a> gratuitement</div> <div> </div>
  closed(false)
  rank100
  active(true)
  licensed(false)
  thumbnail/36/Offre Spéciale Petit Kamusi.png
  purchase_linkhttps://komlink.co/produit/le-petit-kamusi/
  publishing_houseORELC
  verified(false)
  creator_id36
  editor_id36
  authorizationPublic
  1(array)
  FrenchLesson(array)
  chapterOuvrages
  id301
  typeressource
  titleLe Petit Kamusi
  author_nameMohamed AHMED CHAMANGA
  date_created2022-03-04 10:52:49
  date_updated2022-07-15 14:45:23
  date_published2022-03-04 10:56:39
  description<p><span style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; outline: 0px; text-size-adjust: 100%; vertical-align: baseline; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-weight: bold; color: #666666; font-family: 'Open Sans', Arial, sans-serif;"><span style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; outline: 0px; text-size-adjust: 100%; vertical-align: baseline; background: transparent;">Le Petit Kamusi</span><em style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; outline: 0px; text-size-adjust: 100%; vertical-align: baseline; background: transparent;">. </em></span></p> <p><span style="color: #445980; font-family: 'Qualy light', sans-serif; text-align: center;">L</span><span style="color: #445980; font-family: 'Qualy light', sans-serif; text-align: center;">e tout premier </span><span style="box-sizing: border-box; font-weight: bolder; color: #445980; font-family: 'Qualy light', sans-serif; text-align: center;">dictionnaire illustré</span><span style="color: #445980; font-family: 'Qualy light', sans-serif; text-align: center;"> comprenant 4 langues - le comorien, le français, l’arabe et l’anglais.</span></p>
  closed(false)
  rank
  active(true)
  licensed(false)
  thumbnailhttps://i0.wp.com/komlink.co/wp-content/uploads/2022/02/081-5x8x0.50-Nature-Things-Front-Back-Book-Mockup-COVERVAULT-scaled-1.png?w=1808&ssl=1
  purchase_linkhttps://komlink.co/produit/le-petit-kamusi/
  publishing_houseKomEDIT
  verified(false)
  creator_id876
  editor_id36
  authorizationPublic
  2(array)
  FrenchLesson(array)
  chapterMagazines
  id297
  typeressource
  titleMpira
  author_name4 Étoiles Éditions
  date_created2022-01-14 14:58:04
  date_updated2022-01-19 23:16:12
  date_published2022-01-14 15:37:37
  description<p><span style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; outline: 0px; text-size-adjust: 100%; vertical-align: baseline; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-weight: bold; color: #666666; font-family: 'Open Sans', Arial, sans-serif;">MPIRA, <em style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; outline: 0px; text-size-adjust: 100%; vertical-align: baseline; background: transparent;">première revue de sport des Comores. </em></span><span style="color: #666666; font-family: 'Open Sans', Arial, sans-serif;">Ce premier numéro revient sur la qualification historique de l’équipe nationale de football des Comores, les Cœlacanthes, à la CAN 2022, mais aussi sur d’autres thématiques sur le sport dans l’archipel. </span></p>
  closed(false)
  rank100
  active(true)
  licensed(false)
  thumbnail/36/mpira 1.png
  purchase_linkhttps://www.editions4etoiles.com/produit/mpira-n1/
  publishing_house4 étoiles éditions
  verified(false)
  creator_id36
  editor_id36
  authorizationPublic
  3(array)
  FrenchLesson(array)
  chapterJeux
  id298
  typeressource
  titleJeu de memory-Les animaux en shiKomori
  author_name4 Étoiles Éditions
  date_created2022-01-14 15:15:20
  date_updated2022-01-19 23:15:31
  date_published2022-01-14 15:37:04
  description<p><span style="color: #666666; font-family: 'Open Sans', Arial, sans-serif;">Petits et grands apprennent les noms des animaux en shiKomori tout en s’amusant avec ce jeu de memory spécial animaux (Zinyama)</span></p>
  closed(false)
  rank100
  active(true)
  licensed(false)
  thumbnail/36/Jeu de mémory.png
  purchase_linkhttps://www.editions4etoiles.com/produit/jeu-de-memory-les-animaux-en-shikomori/
  publishing_house4 étoiles éditions
  verified(false)
  creator_id36
  editor_id36
  authorizationPublic
  4(array)
  FrenchLesson(array)
  chapterMagazines
  id300
  typeressource
  titleWakati N° 3-Les Comoriens, d’où viennent-ils?
  author_name4 Étoiles Éditions
  date_created2022-01-14 15:34:31
  date_updated2022-01-19 23:13:14
  date_published2022-01-14 15:35:12
  description<p><span style="color: #666666; font-family: 'Open Sans', Arial, sans-serif;">Ce troisième numéro aborde la question de l’origine du peuplement des îles Comores. Pour ce faire, nous avons interrogé des scientifiques mais avons aussi donné la parole à ceux qui traitent cette questions de manière traditionnelle en se basant sur la tradition orale, les mythes et les légendes.</span></p>
  closed(false)
  rank100
  active(true)
  licensed(false)
  thumbnail/36/wakati 3.png
  purchase_linkhttps://www.editions4etoiles.com/produit/wakati-n-3-les-comoriens-dou-viennent-ils-peuplement-comores-arabes-africains-asiatiques-esclavage-origines-archeologie-magazines-4-etoiles/
  publishing_house4 étoiles éditions
  verified(false)
  creator_id36
  editor_id36
  authorizationPublic
  5(array)
  FrenchLesson(array)
  chapterMagazines
  id299
  typeressource
  titleWakati N° 2-La femme comorienne
  author_name4 Étoiles Éditions
  date_created2022-01-14 15:26:52
  date_updated2022-01-19 23:14:25
  date_published2022-01-14 15:28:00
  description<p><span style="color: #666666; font-family: 'Open Sans', Arial, sans-serif;">Ce deuxième numéro de la revue WAKATI évoque la question de la femme au sein de la société comorienne. Il retrace l’évolution de son statut traditionnel et les changements introduits par les progrès sociaux et économiques.</span></p>
  closed(false)
  rank100
  active(true)
  licensed(false)
  thumbnail/36/wakati 2.png
  purchase_linkhttps://www.editions4etoiles.com/produit/wakati-n-2-femme-comorienne-traditions-comoriennes-comores-magazine-editions4etoiles/
  publishing_house4 étoiles éditions
  verified(false)
  creator_id36
  editor_id36
  authorizationPublic
  6(array)
  FrenchLesson(array)
  chapterPoésie
  id291
  typeressource
  titleTaɓiri
  author_nameZamZam ELHAD
  date_created2021-12-12 10:45:04
  date_updated2021-12-12 10:47:03
  date_published2021-12-12 10:47:03
  description(null)
  closed(false)
  rankH102
  active(true)
  licensed(false)
  thumbnail
  purchase_link
  publishing_house
  verified(false)
  creator_id2205
  editor_id2205
  authorizationPublic
  7(array)
  FrenchLesson(array)
  chapterPoésie
  id284
  typeressource
  titleƁariza
  author_nameZamZam ELHAD
  date_created2021-11-30 00:56:35
  date_updated2021-12-01 03:26:37
  date_published2021-11-30 01:08:39
  description
  closed(false)
  rank
  active(true)
  licensed(false)
  thumbnail
  purchase_link
  publishing_house
  verified(false)
  creator_id2205
  editor_id36
  authorizationPublic
  8(array)
  FrenchLesson(array)
  chapterÉvénement
  id277
  typeressource
  titleEp. 3 - Shikomori Shangu
  author_name@chinoirs_
  date_created2021-07-20 03:10:50
  date_updated2021-07-20 03:23:07
  date_published2021-07-20 03:12:53
  description<p><span style="color: #262626; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif;">Sambusa ou Samusa ? Hatchu ou Hatru ?</span><br style="color: #262626; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif;" /><span style="color: #262626; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif;">Épisode 3 du Shikomori Shangu avec </span><a class="notranslate" style="margin: 0px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; vertical-align: baseline; text-decoration-line: none;" tabindex="0" href="https://www.instagram.com/chinoirs_/">@chinoirs_</a><span style="color: #262626; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif;"> , Elle s'est prêtée au jeu pour tester son niveau de langue.</span></p>
  closed(false)
  rank
  active(true)
  licensed(false)
  thumbnail/36/shikomorishangu_titre_carre.png
  purchase_link
  publishing_houseORELC
  verified(false)
  creator_id36
  editor_id36
  authorizationPublic
  9(array)
  FrenchLesson(array)
  chapterPoésie
  id53
  typeressource
  titleÂɗa Na Mila
  author_nameKirikoustra
  date_created2017-04-26 14:36:39
  date_updated2021-01-29 19:56:08
  date_published2021-01-29 19:56:08
  description<p>Poème sur le âda, le grand mariage en Grande Comore, un mariage traditionnel qui divise les générations.</p>
  closed(false)
  rankD132
  active(true)
  licensed(false)
  thumbnail/36/41+UbNMZiwL._SX322_BO1,204,203,200_.jpg
  purchase_link
  publishing_houseORELC
  verified(false)
  creator_id36
  editor_id36
  authorizationPublic
  10(array)
  FrenchLesson(array)
  chapterPoésie
  id250
  typeressource
  titleÂɗa
  author_nameImrane
  date_created2021-01-26 02:12:42
  date_updated2021-01-26 22:13:28
  date_published2021-01-26 22:13:28
  description<p> </p> <p class="MsoNormal" style="margin-bottom: 0cm; line-height: normal; mso-pagination: widow-orphan; mso-hyphenate: auto; mso-vertical-align-alt: auto;"><span lang="ES" style="font-size: 12.0pt; font-family: 'inherit',serif; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 0pt; mso-ansi-language: ES; mso-fareast-language: FR;"><span style="font-family: Cambria, serif; font-size: 12pt;">Ɗ</span>oleo lah'eâɗa</span></p>
  closed(false)
  rankD130
  active(true)
  licensed(false)
  thumbnailhttps://masiwa-comores.com/wp-content/uploads/2019/07/arg.jpg
  purchase_link
  publishing_houseAutre
  verified(false)
  creator_id1616
  editor_id1616
  authorizationPublic
  11(array)
  FrenchLesson(array)
  chapterPoésie
  id231
  typeressource
  titleHamu
  author_nameImrane
  date_created2020-12-27 02:52:58
  date_updated2021-03-16 10:48:22
  date_published2021-01-26 17:37:45
  description
  closed(false)
  rankD115
  active(true)
  licensed(false)
  thumbnailhttps://cdn.pixabay.com/photo/2018/01/17/05/24/sunset-3087474_960_720.jpg
  purchase_link
  publishing_houseAutre
  verified(false)
  creator_id36
  editor_id1616
  authorizationPublic
- newUsers(array)
  0(array)
  User(array)
  id19590
  emailrayan200500@outlook.fr
  security_email(null)
  payment_email(null)
  payment_id(null)
  biography(null)
  curriculum_vitae(null)
  thumbnail(null)
  sex(null)
  first_nameRayan
  last_nameMohamed
  display_name(null)
  date_of_birth(null)
  address(null)
  phone(null)
  phone2(null)
  city(null)
  country(null)
  dialectzdj
  learning_dialectkm
  shikomori_levelDébutant
  website(null)
  visio_url(null)
  password17ec80fd0d152a155a10a9649a4f9227e9e4afe9
  password_questionVotre mot de passe commence par...
  password_responseRaya****
  digest_a1b45a8d1fdaa918782c6c8f0ade91050fc94b5391b04c2dc90df313a3f09d10c5
  rating4
  count_dictionary_contribution0
  count_ressource_contribution0
  count_of_words_to_revise10
  time_to_revise08:00:00
  revision_duration30
  license_registration_in_process(null)
  subscribe(null)
  certified(false)
  has_teacher(false)
  has_license_game(false)
  available(true)
  share_exercice(true)
  dictionary_signatory(false)
  requested_contribution(false)
  session_number0
  session_id(null)
  school_id0
  referral_code(null)
  referred(false)
  api_key(null)
  client_nameLuha
  created2026-03-26 00:00:00
  modified2026-03-26 01:58:35
  connected2026-03-26 00:45:57
  online2026-03-26 01:58:35
  timezoneEurope/Paris
  roleuser
  free_week_for_teacher0
  active_newsletter_notification(true)
  active_comment_notification(true)
  active(true)
  temp_user_data(null)
  access_tokenc42d821fe392277c683fd83ea8be8a20
  access_token2(null)
  access_token3(null)
  access_token4(null)
  firebase_device_token_dictionary(null)
  firebase_device_token_luhafAOQPck2o0yBsT717PbWwU:APA91bG4-Zmd7U88nKA9Dmfiv6cUJL1p3GmUZxjVB7rTp5TU4Brp8e_x-IKiN65hxzuZV_KGPHG0y9LFfEb499HMlf43XrDYoEwEyfUIazGSlyGz4nFfvbs
  certificate_level0
  full_nameRayan Mohamed
  short_nameRayan M.
  short_full_nameRayan M.
  License(empty)
  Certificate(empty)
  Group(empty)
  Conference(empty)
  1(array)
  User(array)
  id19591
  emailalimzembaba54@gmail.com
  security_email(null)
  payment_email(null)
  payment_id(null)
  biography(null)
  curriculum_vitae(null)
  thumbnail(null)
  sex(null)
  first_name_kito
  last_nameEl
  display_name(null)
  date_of_birth(null)
  address(null)
  phone(null)
  phone2(null)
  city(null)
  country(null)
  dialectzdj
  learning_dialectkm
  shikomori_levelDébutant
  website(null)
  visio_url(null)
  password9236b487961f7abe3824f0de3471f9a8166101e8
  password_questionVotre mot de passe commence par...
  password_responseAmin****
  digest_a123a3950aadee69c10fe7bce1d4c9312ebbe26a786b2c44deb4e37a484648fcd8
  rating4
  count_dictionary_contribution0
  count_ressource_contribution0
  count_of_words_to_revise10
  time_to_revise08:00:00
  revision_duration30
  license_registration_in_process(null)
  subscribe(null)
  certified(false)
  has_teacher(false)
  has_license_game(false)
  available(true)
  share_exercice(true)
  dictionary_signatory(false)
  requested_contribution(false)
  session_number0
  session_id(null)
  school_id0
  referral_code(null)
  referred(false)
  api_key(null)
  client_nameDO
  created2026-03-26 00:00:00
  modified2026-03-26 02:27:18
  connected2026-03-26 01:18:53
  online2026-03-26 02:27:18
  timezoneEurope/Paris
  roleuser
  free_week_for_teacher0
  active_newsletter_notification(true)
  active_comment_notification(true)
  active(true)
  temp_user_data(null)
  access_token(null)
  access_token2692f1f12151539153be75a026eb35ac3
  access_token3(null)
  access_token4(null)
  firebase_device_token_dictionarye2l_De7I9EMFoCqoIRn6JT:APA91bEtKShKmAxY4RAdQGULZGRmKZhzG5CLReVQc7803pAXJztB5OCdcrmBKmgxdzJcvGLsGghb3JKqU2xFxqT1OqmIODuCsgNNlXTh2bPeklf1DIo81lk
  firebase_device_token_luha(null)
  certificate_level0
  full_name_kito El
  short_name_kito E.
  short_full_name_kito E.
  License(empty)
  Certificate(empty)
  Group(empty)
  Conference(empty)
  2(array)
  User(array)
  id19592
  emaildelauneilena16@gmail.com
  security_email(null)
  payment_email(null)
  payment_id(null)
  biography(null)
  curriculum_vitae(null)
  thumbnail(null)
  sex(null)
  first_nameIlena
  last_nameAboudou
  display_name(null)
  date_of_birth(null)
  address(null)
  phone(null)
  phone2(null)
  city(null)
  country(null)
  dialectfr
  learning_dialectzdj
  shikomori_levelDébutant
  website(null)
  visio_url(null)
  password11dfee6e005eec3d3f5cdb4a84362bb0927ec17e
  password_questionVotre mot de passe commence par...
  password_responseFloria****
  digest_a107319c1281c6fb8ceddd188daa9bb500933011b1ac7b04f2209e8aa7d5a79401
  rating4
  count_dictionary_contribution0
  count_ressource_contribution0
  count_of_words_to_revise10
  time_to_revise08:00:00
  revision_duration30
  license_registration_in_process(null)
  subscribe(null)
  certified(false)
  has_teacher(false)
  has_license_game(false)
  available(true)
  share_exercice(true)
  dictionary_signatory(false)
  requested_contribution(false)
  session_number0
  session_id(null)
  school_id5
  referral_code(null)
  referred(false)
  api_key(null)
  client_nameLuha
  created2026-03-26 00:00:00
  modified2026-03-26 03:13:55
  connected2026-03-26 01:38:55
  online2026-03-26 03:13:55
  timezoneEurope/Paris
  roleuser
  free_week_for_teacher0
  active_newsletter_notification(true)
  active_comment_notification(true)
  active(true)
  temp_user_data(null)
  access_token51a1ce8d49ff6b70e48b2d6d58ad9ad3
  access_token2(null)
  access_token3(null)
  access_token4(null)
  firebase_device_token_dictionary(null)
  firebase_device_token_luhac6oxNnaN-kwFqAuVzvoJiZ:APA91bGU-e7ghYExM53_T0XNQRye7aey7h9mDWKQswhvpT19UGIfFsz-URuSg_Qe_SgZVSEk7cUDqMDh8fnfJOZm00pOYZHpFMmJIMxzSZcpG2FwbDwNDyg
  certificate_level0
  full_nameIlena Aboudou
  short_nameIlena A.
  short_full_nameIlena A.
  License(empty)
  Certificate(empty)
  Group(empty)
  Conference(empty)
  3(array)
  User(array)
  id19593
  emailmourdani15@gmail.com
  security_email(null)
  payment_email(null)
  payment_id(null)
  biography(null)
  curriculum_vitae(null)
  thumbnail(null)
  sex(null)
  first_nameMOIRDANI
  last_nameBACARI
  display_name(null)
  date_of_birth(null)
  address(null)
  phone(null)
  phone2(null)
  city(null)
  country(null)
  dialectzdj
  learning_dialectkm
  shikomori_levelIntermédiaire
  website(null)
  visio_url(null)
  password0064451c3db31514002bbfbe9db6ed3a871998a0
  password_questionVotre mot de passe commence par...
  password_responseColo****
  digest_a1cd349921f9962a33888730818fb3b7ae00db89fa875312715536f254e78a0b85
  rating4
  count_dictionary_contribution0
  count_ressource_contribution0
  count_of_words_to_revise10
  time_to_revise08:00:00
  revision_duration30
  license_registration_in_process(null)
  subscribe(null)
  certified(false)
  has_teacher(false)
  has_license_game(false)
  available(true)
  share_exercice(true)
  dictionary_signatory(false)
  requested_contribution(false)
  session_number0
  session_id(null)
  school_id0
  referral_code(null)
  referred(false)
  api_key(null)
  client_nameLuha
  created2026-03-26 00:00:00
  modified2026-03-26 09:25:20
  connected2026-03-26 09:25:20
  online2026-03-26 09:25:20
  timezoneEurope/Paris
  roleuser
  free_week_for_teacher0
  active_newsletter_notification(true)
  active_comment_notification(true)
  active(true)
  temp_user_data(null)
  access_token6b620b06b63181ea13e50b7a08527deb
  access_token2(null)
  access_token3(null)
  access_token4(null)
  firebase_device_token_dictionary(null)
  firebase_device_token_luha(null)
  certificate_level0
  full_nameMOIRDANI BACARI
  short_nameMOIRDANI B.
  short_full_nameMOIRDANI B.
  License(empty)
  Certificate(empty)
  Group(empty)
  Conference(empty)
  4(array)
  User(array)
  id19594
  emailallmickail24@gmail.com
  security_email(null)
  payment_email(null)
  payment_id(null)
  biography(null)
  curriculum_vitae(null)
  thumbnail(null)
  sex(null)
  first_nameMickaïl
  last_nameImani
  display_name(null)
  date_of_birth(null)
  address(null)
  phone(null)
  phone2(null)
  city(null)
  country(null)
  dialectfr
  learning_dialectzdj
  shikomori_levelDébutant
  website(null)
  visio_url(null)
  passworda9006262072560403d4e8007e55422f0da317ce6
  password_questionVotre mot de passe commence par...
  password_responsekydfow-ret****
  digest_a12efd6edae98f85e74d11157caa72b0735ebe5c3e4a7bd5cb98fc5d158f3fb3fc
  rating4
  count_dictionary_contribution0
  count_ressource_contribution0
  count_of_words_to_revise10
  time_to_revise08:00:00
  revision_duration30
  license_registration_in_process(null)
  subscribe(null)
  certified(false)
  has_teacher(false)
  has_license_game(false)
  available(true)
  share_exercice(true)
  dictionary_signatory(false)
  requested_contribution(false)
  session_number1
  session_id6976a07c4d00f5c98354a2d96a6a9cb1
  school_id0
  referral_code(null)
  referred(false)
  api_key(null)
  client_name(null)
  created2026-03-26 00:00:00
  modified2026-03-26 16:57:02
  connected2026-03-26 15:54:44
  online2026-03-26 16:57:02
  timezoneEurope/Paris
  roleuser
  free_week_for_teacher0
  active_newsletter_notification(true)
  active_comment_notification(true)
  active(true)
  temp_user_data(null)
  access_token(null)
  access_token2(null)
  access_token3(null)
  access_token4(null)
  firebase_device_token_dictionary(null)
  firebase_device_token_luha(null)
  certificate_level0
  full_nameMickaïl Imani
  short_nameMickaïl I.
  short_full_nameMickaïl I.
  License(empty)
  Certificate(empty)
  Group(empty)
  Conference(empty)
  5(array)
  User(array)
  id19595
  emailkawaiicoco888@gmail.com
  security_email(null)
  payment_email(null)
  payment_id(null)
  biography(null)
  curriculum_vitae(null)
  thumbnail(null)
  sex(null)
  first_nameAd
  last_nameMah
  display_name(null)
  date_of_birth(null)
  address(null)
  phone(null)
  phone2(null)
  city(null)
  country(null)
  dialectfr
  learning_dialectkm
  shikomori_levelDébutant
  website(null)
  visio_url(null)
  passworda7923f78137eaedcdc4a858b366b71a1d5ffd00c
  password_questionVotre mot de passe commence par...
  password_responseComor****
  digest_a16ce5a798c346d1eff44c74f293882f310914710302bc6df96ec3de8a7ae47bfa
  rating4
  count_dictionary_contribution0
  count_ressource_contribution0
  count_of_words_to_revise10
  time_to_revise08:00:00
  revision_duration30
  license_registration_in_process(null)
  subscribe(null)
  certified(false)
  has_teacher(false)
  has_license_game(false)
  available(true)
  share_exercice(true)
  dictionary_signatory(false)
  requested_contribution(false)
  session_number0
  session_id(null)
  school_id0
  referral_code(null)
  referred(false)
  api_key(null)
  client_nameLuha
  created2026-03-26 00:00:00
  modified2026-03-26 18:49:36
  connected2026-03-26 17:49:16
  online2026-03-26 18:49:36
  timezoneEurope/Paris
  roleuser
  free_week_for_teacher0
  active_newsletter_notification(true)
  active_comment_notification(true)
  active(true)
  temp_user_data(null)
  access_token48b52199a7b30cadce849b87fc0c39d7
  access_token2(null)
  access_token3(null)
  access_token4(null)
  firebase_device_token_dictionary(null)
  firebase_device_token_luhaeCoZyhuPR1W5tFTAKBxt6v:APA91bGyjWVnlnja5Z3asp6GP67oiikcH71unS300b0F3xYNRXRm1OH53ZyPdCucXdkB3BJc1wZ2vCdk0488zimX-alM9caDEesi2JoHB7mlgw3fqT6rP_o
  certificate_level0
  full_nameAd Mah
  short_nameAd M.
  short_full_nameAd M.
  License(empty)
  Certificate(empty)
  Group(empty)
  Conference(empty)
- totVoters6801
- countActiveStudents1848
- countConnected21
- countSubscribers8179
- average4.0026466696074
- fullDateLeo yahoa mwezi 26 wa Marsi 2026<span style="color:gray;"></span>
- welcomeMessage<b>Bienvenue</b> sur ORELC.
- helloMessage
- userProfile
- displayName
- clientApps(array)
  0ORELC
  1Luha
  2DO
- learningDialectshimaore
- haveDictionaryLicense(false)
- haveAccessPLUS(false)
- haveGrammarLicense(false)
- haveSpeakingLicense(false)
- isAdministrator(false)
- teacherMode(false)
- isTeacher(false)
- expendedHeader(null)
- isiPAD(false)
- isDesktop(true)
- inIOSExam(true)
- platform(false)
- clientName(false)
- isORELCApp(null)
- $request->data(empty)
- $this->validationErrors(array)
  User(empty)
  License(empty)
  Certificate(empty)
  CertificateUser(empty)
  Group(empty)
  UserGroup(empty)
  Conference(empty)
  SubscribeConference(empty)
  ShikomoriWord(empty)
  ShikomoriVerb(empty)
  ShikomoriDefinition(empty)
  FrenchWord(empty)
  ShikomoriFrWord(empty)
  EnglishWord(empty)
  ShikomoriEnWord(empty)
  ArabicWord(empty)
  ShikomoriArWord(empty)
  ShikomoriPlural(empty)
  ShikomoriPlWord(empty)
  FrenchLesson(empty)
- Loaded Helpers(array)
  0Html
  1Form
  2Number
  3SimpleGraph
  4DebugTimer
  5Toolbar
  6Session
  7HtmlToolbar
====

Environment

App Constants

Constant	Value
CONFIG	/home/nonisesh/www/orelc/academy/app/Config/
CLIENT_ID	AaF_UTLlIzxkImNkRknPfpQpAdB-vyvgJ68o2gh1fQ1CHEkocsmn_hnMJ2PC1S-4JG7dUTIwdK-gdlCd
SECRET_ID	EHrRtdvkr5rZHTqP8kq3Ml42SkZnwGmfMjYHpn0gvgMQ9qbjPiJWAHcrmc4A3bMjgxwN-pwS_eSBlrcb
PAYPAL_URL	https://www.paypal.com/v1/oauth2/token
K_BLANK_IMAGE	_blank.png
PDF_PAGE_FORMAT	A4
PDF_PAGE_ORIENTATION	P
PDF_CREATOR	TCPDF
PDF_AUTHOR	TCPDF
PDF_HEADER_TITLE	TCPDF Example
PDF_HEADER_STRING	by Nicola Asuni - Tecnick.com www.tcpdf.org
PDF_UNIT	mm
PDF_MARGIN_HEADER	5
PDF_MARGIN_FOOTER	10
PDF_MARGIN_TOP	27
PDF_MARGIN_BOTTOM	25
PDF_MARGIN_LEFT	15
PDF_MARGIN_RIGHT	15
PDF_FONT_NAME_MAIN	helvetica
PDF_FONT_SIZE_MAIN	10
PDF_FONT_NAME_DATA	helvetica
PDF_FONT_SIZE_DATA	8
PDF_FONT_MONOSPACED	courier
PDF_IMAGE_SCALE_RATIO	1.25
HEAD_MAGNIFICATION	1.1
K_CELL_HEIGHT_RATIO	1.25
K_TITLE_MAGNIFICATION	1.3
K_SMALL_RATIO	0.66666666666667
K_THAI_TOPCHARS	1
K_TCPDF_CALLS_IN_HTML
K_TCPDF_THROW_EXCEPTION_ERROR
K_TIMEZONE	UTC
K_PATH_MAIN	/home/nonisesh/www/orelc/academy/app/Vendor/tcpdf/
K_PATH_FONTS	/home/nonisesh/www/orelc/academy/app/Vendor/tcpdf/fonts/
K_PATH_URL	https://orelc.ac/academy/app/Vendor/tcpdf/
K_PATH_IMAGES	/home/nonisesh/www/orelc/academy/app/Vendor/tcpdf/examples/images/
PDF_HEADER_LOGO	tcpdf_logo.jpg
PDF_HEADER_LOGO_WIDTH	30
K_PATH_CACHE	/tmp/

CakePHP Constants

Constant	Value
APP	/home/nonisesh/www/orelc/academy/app/
APP_DIR	app
APPLIBS	/home/nonisesh/www/orelc/academy/app/Lib/
CACHE	/home/nonisesh/www/orelc/academy/app/tmp/cache/
CAKE	/home/nonisesh/www/orelc/academy/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/nonisesh/www/orelc/academy/lib
CORE_PATH	/home/nonisesh/www/orelc/academy/lib/
CAKE_VERSION	2.10.16
CSS	/home/nonisesh/www/orelc/academy/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://orelc.ac
IMAGES	/home/nonisesh/www/orelc/academy/app/webroot/img/
IMAGES_URL	img/
JS	/home/nonisesh/www/orelc/academy/app/webroot/js/
JS_URL	js/
LOGS	/home/nonisesh/www/orelc/academy/app/tmp/logs/
ROOT	/home/nonisesh/www/orelc/academy
TESTS	/home/nonisesh/www/orelc/academy/app/Test/
TMP	/home/nonisesh/www/orelc/academy/app/tmp/
VENDORS	/home/nonisesh/www/orelc/academy/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/nonisesh/www/orelc/academy/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	7.4.33
Path	/usr/local/bin:/usr/bin:/bin
Redirect Status	200
Unique Id	acV7sJA0O5joTs0GO@phXwAAfHY
Geoip Country Code	US
Geoip Country Name	United States
Geoip Region	CA
Geoip City	Santa Paula
Geoip Dma Code	803
Geoip Area Code	805
Geoip Latitude	34.355598
Geoip Longitude	-119.070099
Script Url	/academy/Homes
Script Uri	https://orelc.ac:443/academy/Homes
Https	on
Http Authorization
Cfg Cluster	cluster102
Environment	production
App Engine Version	7.4
App Engine	phpcgi
Http Host	orelc.ac
Http X Predictor	1
Http X Forwarded For	216.73.216.31
Http X Forwarded Proto	https
Http X Ovhrequest Id	d747c0fde1515231e66d5fba681088c9
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept Encoding	gzip, br, zstd, deflate
Http Referer	https://orelc.ac/
Http Remote Ip	216.73.216.31
Server Signature
Server Software	Apache
Server Name	orelc.ac
Server Addr	10.102.20.4
Server Port	443
Remote Addr	216.73.216.31
Document Root	/home/nonisesh/www/orelc/
Server Admin	postmaster@orelc.ac
Script Filename	/home/nonisesh/www/orelc/academy/app/webroot/index.php
Remote Port	12664
Redirect Url	/academy/app/webroot/Homes
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/academy/Homes
Script Name	/academy/app/webroot/index.php
Home	/homez.485/nonisesh
Pwd	/homez.485/nonisesh/www/orelc/academy/app/webroot
Uid	nonisesh
Php Self	/academy/app/webroot/index.php
Request Time Float	1774549936.6781
Request Time	1774549936
Argc	1

====

Include
+
Included Files

Include Paths
- 0/home/nonisesh/www/orelc/academy/lib
- 2/usr/local/php7.4/lib/php
- 3-> /home/nonisesh/www/orelc/academy/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/FlashComponent.php
  2CORE/Controller/Component/AuthComponent.php
  3CORE/Controller/Component/Auth/DigestAuthenticate.php
  4CORE/Controller/Component/Auth/BasicAuthenticate.php
  5CORE/Controller/Component/Auth/BaseAuthenticate.php
  6CORE/Controller/Component/Auth/FormAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/HybridauthComponent.php
  1APP/Controller/Component/ExportComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/constants.php
  3APP/Config/routes.php
  4APP/Vendor/tcpdf/config/tcpdf_config.php
  5APP/Config/database.php
  Controller(array)
  0APP/Controller/HomesController.php
  1APP/Controller/UsersController.php
  2APP/Controller/ShikomoriWordsController.php
  3APP/Controller/FrenchWordsController.php
  4APP/Controller/ShikomoriFrWordsController.php
  5APP/Controller/AppController.php
  6APP/Controller/EnglishWordsController.php
  7APP/Controller/ShikomoriEnWordsController.php
  8APP/Controller/ArabicWordsController.php
  9APP/Controller/ShikomoriArWordsController.php
  10APP/Controller/TimeInnaccPresentController.php
  11APP/Controller/ShikomoriVerbsController.php
  12APP/Controller/ConjugationsController.php
  13APP/Controller/ShikomoriPluralsController.php
  14APP/Controller/ShikomoriPlWordsController.php
  15APP/Controller/ShikomoriDefinitionsController.php
  16APP/Controller/CommentsController.php
  17APP/Controller/ExercicesController.php
  18APP/Controller/HighScoresController.php
  19APP/Controller/SchoolsController.php
  20APP/Controller/FrenchLessonsController.php
  21APP/Controller/LicensesController.php
  22APP/Controller/SwadriiProductsController.php
  23APP/Controller/MemorizedWordsController.php
  24APP/Controller/LabelsController.php
  25APP/Controller/LabelKmWordsController.php
  26APP/Controller/LabelProgressController.php
  27APP/Controller/SpelledWordsController.php
  28APP/Controller/ExercicesPrefixesController.php
  29APP/Controller/ExercicesPrePrefixesController.php
  30APP/Controller/ExercicesIntroductionController.php
  31APP/Controller/ExercicesPronounsController.php
  32APP/Controller/ExercicesPossessivesController.php
  33APP/Controller/ExercicesAdjectivesController.php
  34APP/Controller/ExercicesConnectivesController.php
  35APP/Controller/CommentUsersController.php
  36APP/Controller/NotificationsController.php
  37APP/Controller/ConferencesController.php
  38APP/Controller/SubscribeConferencesController.php
  39APP/Controller/TeacherRatingsController.php
  40APP/Controller/FirebaseLuhaClientController.php
  41APP/Controller/ShikomoriNamesController.php
  42APP/Controller/TokensController.php
  43APP/Controller/DictionaryController.php
  44APP/Controller/ParametersController.php
  45APP/Controller/VersionsController.php
  46APP/Controller/SwadriiInvoicesController.php
  47APP/Controller/SocialProfilesController.php
  48APP/Controller/FirebaseDictionaryClientController.php
  Model(array)
  0APP/Model/User.php
  1APP/Model/AppModel.php
  2APP/Model/License.php
  3APP/Model/Certificate.php
  4APP/Model/CertificateUser.php
  5APP/Model/Group.php
  6APP/Model/Conference.php
  7APP/Model/ShikomoriWord.php
  8APP/Model/ShikomoriVerb.php
  9APP/Model/ShikomoriDefinition.php
  10APP/Model/FrenchWord.php
  11APP/Model/EnglishWord.php
  12APP/Model/ArabicWord.php
  13APP/Model/ShikomoriPlural.php
  14APP/Model/FrenchLesson.php
  Other(array)
  0APP/webroot/index.php
  1APP/Vendor/tcpdf/tcpdf.php
  2APP/Vendor/tcpdf/tcpdf_autoconfig.php
  3APP/Vendor/tcpdf/include/tcpdf_font_data.php
  4APP/Vendor/tcpdf/include/tcpdf_fonts.php
  5APP/Vendor/tcpdf/include/tcpdf_colors.php
  6APP/Vendor/tcpdf/include/tcpdf_images.php
  7APP/Vendor/tcpdf/include/tcpdf_static.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
====

ORELC la référence de langue comorienne

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 476 ms Total Queries: 180 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 476 ms
Total Queries: 180 queries