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

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent6e4859d7847d57ab0d629515a939ec27
  time1780508529
  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: 531 ms
Total Queries: 230 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	1
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_modern`, `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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	1
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_modern`, `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_modern`, `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	15	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (876)	1	1	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`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	1	maybe slow
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 876 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	21	21	1
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_modern`, `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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (876)	1	1	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`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 `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 876 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	21	21	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_modern`, `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_modern`, `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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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` = 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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	1
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_modern`, `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	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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` = 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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	1
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_modern`, `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_modern`, `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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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` = 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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	1
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_modern`, `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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	1
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_modern`, `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_modern`, `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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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` = 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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	1
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_modern`, `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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	1
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_modern`, `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_modern`, `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	15	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	1
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_modern`, `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	15	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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` = 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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	1
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_modern`, `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	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_modern`, `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	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (2205)	1	1	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (2205)	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` = 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 `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 2205 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	6	6	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_modern`, `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	18	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (2205)	1	1	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (2205)	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` = 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 `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 2205 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	6	6	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_modern`, `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_modern`, `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	15	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (2205)	1	1	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (2205)	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` = 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 `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 2205 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	6	6	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_modern`, `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	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (2205)	1	1	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (2205)	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` = 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 `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 2205 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	6	6	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_modern`, `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_modern`, `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	15	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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` = 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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	2
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_modern`, `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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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` = 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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	2
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_modern`, `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_modern`, `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	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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` = 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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	1
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_modern`, `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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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`)	1	1	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`)	16	16	1	maybe slow
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	1
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_modern`, `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	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_modern`, `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	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (1616)	5	5	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (1616)	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` = 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 `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 1616 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	68	68	1
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_modern`, `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	15	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (1616)	5	5	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (1616)	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` = 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 `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 1616 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	68	68	1
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_modern`, `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_modern`, `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	18	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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` = 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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	2
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_modern`, `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	19	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`, `License`.`payment_provider`, `License`.`external_subscription_id`, `License`.`external_customer_id`, `License`.`external_plan_id` FROM `noniseshorelc`.`licenses` AS `License` WHERE `License`.`user_id` = (36)	8	8	0
SELECT `Comment`.`id`, `Comment`.`message`, `Comment`.`description`, `Comment`.`date_created`, `Comment`.`date_updated`, `Comment`.`user_id`, `Comment`.`shikomori_id`, `Comment`.`resource_id`, `Comment`.`exercice_id`, `Comment`.`name_id`, `Comment`.`teacher_id`, `Comment`.`type`, `Comment`.`object_id` FROM `noniseshorelc`.`comments` AS `Comment` WHERE `Comment`.`user_id` = (36)	92	92	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`)	1	1	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`)	16	16	0
SELECT `RelatedComment`.`id`, `RelatedComment`.`message`, `RelatedComment`.`description`, `RelatedComment`.`date_created`, `RelatedComment`.`date_updated`, `RelatedComment`.`user_id`, `RelatedComment`.`shikomori_id`, `RelatedComment`.`resource_id`, `RelatedComment`.`exercice_id`, `RelatedComment`.`name_id`, `RelatedComment`.`teacher_id`, `RelatedComment`.`type`, `RelatedComment`.`object_id`, `CommentUser`.`id`, `CommentUser`.`comment_id`, `CommentUser`.`user_id`, `CommentUser`.`date_readed` FROM `noniseshorelc`.`comments` AS `RelatedComment` JOIN `noniseshorelc`.`comment_users` AS `CommentUser` ON (`CommentUser`.`user_id` = 36 AND `CommentUser`.`comment_id` = `RelatedComment`.`id`)	291	291	2

Query Explain:

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

====

Timer

Memory

Peak Memory Use 29.31 MB

Message	Memory use
Component initialization	18.82 MB
Controller action start	19.05 MB
Controller render start	21.60 MB
Component initialization #2	22.68 MB
Controller action start #2	22.71 MB
Component initialization #3	22.87 MB
Controller action start #3	22.90 MB
Component initialization #4	22.98 MB
Controller action start #4	23.01 MB
Component initialization #5	23.09 MB
Controller action start #5	23.12 MB
Component initialization #6	23.20 MB
Controller action start #6	23.23 MB
Component initialization #7	23.32 MB
Controller action start #7	23.35 MB
Component initialization #8	23.43 MB
Controller action start #8	23.46 MB
Component initialization #9	23.55 MB
Controller action start #9	23.57 MB
Component initialization #10	23.66 MB
Controller action start #10	23.68 MB
Component initialization #11	23.77 MB
Controller action start #11	23.80 MB
Component initialization #12	23.89 MB
Controller action start #12	23.92 MB
Component initialization #13	24.01 MB
Controller action start #13	24.04 MB
Component initialization #14	24.11 MB
Controller action start #14	24.13 MB
Component initialization #15	24.20 MB
Controller action start #15	24.23 MB
Component initialization #16	24.32 MB
Controller action start #16	24.35 MB
Component initialization #17	24.42 MB
Controller action start #17	24.44 MB
Component initialization #18	24.51 MB
Controller action start #18	24.54 MB
Component initialization #19	24.63 MB
Controller action start #19	24.66 MB
Component initialization #20	24.74 MB
Controller action start #20	24.77 MB
Component initialization #21	24.85 MB
Controller action start #21	24.89 MB
Component initialization #22	24.97 MB
Controller action start #22	25.00 MB
Component initialization #23	25.08 MB
Controller action start #23	25.11 MB
Component initialization #24	25.19 MB
Controller action start #24	25.22 MB
Component initialization #25	25.30 MB
Controller action start #25	25.33 MB
Component initialization #26	25.40 MB
Controller action start #26	25.43 MB
Component initialization #27	25.51 MB
Controller action start #27	25.53 MB
View render complete	25.69 MB

Timers

Total Request Time: 1115 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	252.04
Event: Controller.initialize	0.14
Event: Controller.startup	18.46
Controller action	229.56
Event: Controller.beforeRender	5.19
» Processing toolbar data	5.16
Rendering View	591.98
» Event: View.beforeRender	0.02
» Rendering APP/View/Homes/index.ctp	557.18
» » 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.06
» » » Event: Controller.startup #3	0.11
Controller action #3	0.00
» » » » Event: Controller.shutdown #2	0.01
» » » » Event: Controller.initialize #4	0.04
» » » » Event: Controller.startup #4	0.09
Controller action #4	0.00
» » » » » Event: Controller.shutdown #3	0.01
» » » » » Event: Controller.initialize #5	0.05
» » » » » Event: Controller.startup #5	0.09
Controller action #5	0.00
» » » » » » Event: Controller.shutdown #4	0.01
» » » » » » Event: Controller.initialize #6	0.05
» » » » » » Event: Controller.startup #6	0.08
Controller action #6	0.00
» » » » » » » Event: Controller.shutdown #5	0.01
» » » » » » » Event: Controller.initialize #7	0.04
» » » » » » » Event: Controller.startup #7	0.09
Controller action #7	0.00
» » » » » » » » Event: Controller.shutdown #6	0.01
» » » » » » » » Event: Controller.initialize #8	0.04
» » » » » » » » Event: Controller.startup #8	0.09
Controller action #8	0.00
» » » » » » » » » Event: Controller.shutdown #7	0.01
» » » » » » » » » Event: Controller.initialize #9	0.04
» » » » » » » » » Event: Controller.startup #9	0.10
Controller action #9	0.00
» » » » » » » » » » Event: Controller.shutdown #8	0.01
» » » » » » » » » » Event: Controller.initialize #10	0.04
» » » » » » » » » » Event: Controller.startup #10	0.09
Controller action #10	0.00
» » » » » » » » » » » Event: Controller.shutdown #9	0.01
» » » » » » » » » » » Event: Controller.initialize #11	0.05
» » » » » » » » » » » Event: Controller.startup #11	0.08
Controller action #11	0.00
» » » » » » » » » » » » Event: Controller.shutdown #10	0.01
» » » » » » » » » » » » Event: Controller.initialize #12	0.04
» » » » » » » » » » » » Event: Controller.startup #12	0.09
Controller action #12	0.00
» » » » » » » » » » » » » Event: Controller.shutdown #11	0.01
» » » » » » » » » » » » » Event: Controller.initialize #13	0.06
» » » » » » » » » » » » » Event: Controller.startup #13	0.10
Controller action #13	0.00
» » » » » » » » » » » » » » Event: Controller.shutdown #12	0.01
» » » » » » » » » » » » » » Event: Controller.initialize #14	0.06
» » » » » » » » » » » » » » Event: Controller.startup #14	0.09
Controller action #14	0.00
» » » » » » » » » » » » » » » Event: Controller.shutdown #13	0.01
» » » » » » » » » » » » » » » Event: Controller.initialize #15	0.04
» » » » » » » » » » » » » » » Event: Controller.startup #15	0.10
Controller action #15	0.00
» » » » » » » » » » » » » » » » Event: Controller.shutdown #14	0.02
» » » » » » » » » » » » » » » » Event: Controller.initialize #16	0.05
» » » » » » » » » » » » » » » » Event: Controller.startup #16	0.12
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.09
Controller action #18	0.00
» » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #17	0.01
» » » » » » » » » » » » » » » » » » » Event: Controller.initialize #19	0.06
» » » » » » » » » » » » » » » » » » » Event: Controller.startup #19	0.11
Controller action #19	0.00
» » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #18	0.01
» » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #20	0.06
» » » » » » » » » » » » » » » » » » » » Event: Controller.startup #20	0.12
Controller action #20	0.00
» » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #19	0.01
» » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #21	0.04
» » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #21	0.10
Controller action #21	0.00
» » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #20	0.01
» » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #22	0.05
» » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #22	0.11
Controller action #22	0.00
» » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #21	0.01
» » » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #23	0.05
» » » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #23	0.09
Controller action #23	0.00
» » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #22	0.01
» » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #24	0.04
» » » » » » » » » » » » » » » » » » » » » » » » 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.09
Controller action #25	0.00
» » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #24	0.01
» » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #26	0.04
» » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #26	0.08
Controller action #26	0.00
» » » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #25	0.01
» » » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.initialize #27	0.04
» » » » » » » » » » » » » » » » » » » » » » » » » » » Event: Controller.startup #27	0.08
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	6.38
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- lastDateShikomoriWord2026-06-02 17:34:20
- countModifiedRessourcesToday0
- countModifiedLessonsToday0
- countModifiedWordsVerbsToday1
- countModifiedWordsKmToday2
- countShiKomori4Words1163
- countShiKomori3Words491
- countShiKomori2Words1210
- countShiNgazidjaWords2987
- countShiNdzuaniWords700
- countShiMwaliWords228
- countShiMaoreWords917
- countWords7696
- 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)
  id20072
  emailcontact.ibana@gmail.com
  security_email(null)
  payment_email(null)
  payment_id(null)
  biography(null)
  curriculum_vitae(null)
  thumbnail(null)
  sex(null)
  first_nameSoihiba
  last_nameSoulaimana
  display_name(null)
  date_of_birth(null)
  address(null)
  phone(null)
  phone2(null)
  city(null)
  country(null)
  dialectfr
  learning_dialectzdj
  shikomori_levelAvancé
  website(null)
  visio_url(null)
  password32107229666a260da797d34ccbabcbc459689ea2
  password_modern(null)
  password_questionVotre mot de passe commence par...
  password_responseYaya&****
  digest_a15d826f271536d066f3e62a3abef0e31ec7d6a6059ea6b656998fa8979b2c3ce0
  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-06-03 00:00:00
  modified2026-06-03 01:04:52
  connected2026-06-02 22:45:53
  online2026-06-03 01:04:52
  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_token24220094b05166ebb9066bbd041e8d387
  access_token3(null)
  access_token4(null)
  firebase_device_token_dictionaryek9mTxkHqk8kuvRGpywKX9:APA91bHz22-QukYsPKNexhcn2j3lS52-33RbiIFkcCwTl6SDL0hQRx3FAH1xl8GqHUCPjfZ12MRUa53PDP9qfUggdiXXQzNyj-R7eJleArxtLMq_Y72_jMM
  firebase_device_token_luha(null)
  certificate_level0
  full_nameSoihiba Soulaimana
  short_nameSoihiba S.
  short_full_nameSoihiba S.
  License(empty)
  Comment(empty)
  Certificate(empty)
  Group(empty)
  Conference(empty)
  RelatedComment(empty)
  1(array)
  User(array)
  id20073
  emailmanogw2@gmail.com
  security_email(null)
  payment_email(null)
  payment_id(null)
  biography(null)
  curriculum_vitae(null)
  thumbnail(null)
  sex(null)
  first_nameIssler
  last_nameMano
  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)
  password5a5b3a666caa394dbdd4617873eb62c039f1aa32
  password_modern(null)
  password_questionVotre mot de passe commence par...
  password_responseA3*8****
  digest_a188d14be2028b082a14a4599cffad2b63b9c8fc50657ce5db0d9134ade8722145
  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_idec2f86b7bee2e29c089d1bddd25db390
  school_id0
  referral_code(null)
  referred(false)
  api_key(null)
  client_name(null)
  created2026-06-03 00:00:00
  modified2026-06-03 13:32:31
  connected2026-06-03 11:31:47
  online2026-06-03 13:32:31
  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_nameIssler Mano
  short_nameIssler M.
  short_full_nameIssler M.
  License(empty)
  Comment(empty)
  Certificate(empty)
  Group(empty)
  Conference(empty)
  RelatedComment(empty)
  2(array)
  User(array)
  id20075
  emailsirmatthsas@gmail.com
  security_email(null)
  payment_email(null)
  payment_id(null)
  biography(null)
  curriculum_vitae(null)
  thumbnail(null)
  sex(null)
  first_namematth
  last_namelenoir
  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)
  passwordd13793feaf192763225e1323a9ebbe25f3780050
  password_modern(null)
  password_questionVotre mot de passe commence par...
  password_responseFata****
  digest_a1ce98b0f793c4cb429ea3db2eb22ca069a86d35f83e11d747e4ae3ea6964c61a9
  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_id3998ca202aceda1b9eea03a0cdff879a
  school_id0
  referral_code(null)
  referred(false)
  api_key(null)
  client_name(null)
  created2026-06-03 00:00:00
  modified2026-06-03 14:13:07
  connected2026-06-03 11:40:51
  online2026-06-03 14:13:07
  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_namematth lenoir
  short_namematth L.
  short_full_namematth L.
  License(empty)
  Comment(empty)
  Certificate(empty)
  Group(empty)
  Conference(empty)
  RelatedComment(empty)
- totVoters7183
- countActiveStudents1921
- countConnected21
- countSubscribers8556
- average4.0030627871363
- fullDateLeo mfumotsano mwezi 3 wa Jwî 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)
  Comment(empty)
  Certificate(empty)
  CertificateUser(empty)
  Group(empty)
  UserGroup(empty)
  Conference(empty)
  SubscribeConference(empty)
  RelatedComment(empty)
  CommentUser(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	aiBZYS69ETbeKeU5Znq--gAARjw
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.183
Http X Forwarded Proto	https
Http X Ovhrequest Id	f3675594ce014a7a53d607ea896d55e0
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.183
Server Signature
Server Software	Apache
Server Name	orelc.ac
Server Addr	10.102.20.4
Server Port	443
Remote Addr	216.73.216.183
Document Root	/home/nonisesh/www/orelc/
Server Admin	postmaster@orelc.ac
Script Filename	/home/nonisesh/www/orelc/academy/app/webroot/index.php
Remote Port	40076
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	1780504929.6251
Request Time	1780504929
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/Comment.php
  4APP/Model/Certificate.php
  5APP/Model/CertificateUser.php
  6APP/Model/Group.php
  7APP/Model/Conference.php
  8APP/Model/ShikomoriWord.php
  9APP/Model/ShikomoriVerb.php
  10APP/Model/ShikomoriDefinition.php
  11APP/Model/FrenchWord.php
  12APP/Model/EnglishWord.php
  13APP/Model/ArabicWord.php
  14APP/Model/ShikomoriPlural.php
  15APP/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: 531 ms Total Queries: 230 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 531 ms
Total Queries: 230 queries