| 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 | 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 | 4 | maybe slow |
| 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 | 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 | 23 | maybe slow |
| SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles`, `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 | 1 | maybe slow |
| 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` = '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 | 22 | 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 | 1 | |
| 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`.`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 | 21 | maybe slow |
| SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles`, `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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 1 | maybe slow |
| 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 | 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 | 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 | 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` = '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 | 0 | |
| SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (2205) | 0 | 0 | 12 | maybe slow |
| SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles`, `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 | 0 | |
| SELECT `HighScore`.`id`, `HighScore`.`version`, `HighScore`.`exercice_id`, `HighScore`.`player_id`, `HighScore`.`game`, `HighScore`.`description`, `HighScore`.`score`, `HighScore`.`count_words_shimaore`, `HighScore`.`count_words_shimwali`, `HighScore`.`count_words_shindzuani`, `HighScore`.`count_words_shingazidja`, `HighScore`.`count_orthography_shimaore`, `HighScore`.`count_orthography_shimwali`, `HighScore`.`count_orthography_shindzuani`, `HighScore`.`count_orthography_shingazidja`, `HighScore`.`content_html`, `HighScore`.`create_date`, `HighScore`.`last_date`, `HighScore`.`time`, `HighScore`.`max_time`, `HighScore`.`mention`, `HighScore`.`max_score`, `HighScore`.`rank` FROM `noniseshorelc`.`high_scores` AS `HighScore` WHERE `HighScore`.`player_id` = (2205) | 0 | 0 | 13 | maybe slow |
| SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles`, `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` = '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 | 22 | 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`.`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 | 21 | maybe slow |
| SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles`, `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 | 1 | maybe slow |
| 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 | 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 | 1 | maybe slow |
| 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 | 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 | 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 | 12 | maybe slow |
| SELECT `License`.`id`, `License`.`product_id`, `License`.`user_id`, `License`.`payer_email`, `License`.`subscription_id`, `License`.`affiliate_id`, `License`.`authorized_conference`, `License`.`free_hour_allowed`, `License`.`paid_hour`, `License`.`status`, `License`.`reason`, `License`.`description`, `License`.`beneficiaries`, `License`.`referral_code`, `License`.`created`, `License`.`modified`, `License`.`expired`, `License`.`active`, `License`.`regularized_unpayment`, `License`.`start_time`, `License`.`full_name`, `License`.`last_payment`, `License`.`cycles_completed`, `License`.`total_cycles`, `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 | 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 | 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` = '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 | 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` = (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 | 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` = 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 | 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` = (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 | 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 | 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`.`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 | 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 | |