| 1 | SHOW FULL COLUMNS FROM `profiles` | | 92 | 92 | 3 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 1 |
| 3 | SHOW FULL COLUMNS FROM `users` | | 14 | 14 | 1 |
| 4 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | | 1 | 1 | 0 |
| 5 | SHOW FULL COLUMNS FROM `countries` | | 18 | 18 | 1 |
| 6 | SHOW FULL COLUMNS FROM `regions` | | 7 | 7 | 1 |
| 7 | SHOW FULL COLUMNS FROM `profile_languages` | | 5 | 5 | 1 |
| 8 | SHOW FULL COLUMNS FROM `languages` | | 2 | 2 | 1 |
| 9 | SHOW FULL COLUMNS FROM `profile_pets` | | 4 | 4 | 1 |
| 10 | SHOW FULL COLUMNS FROM `pets` | | 2 | 2 | 1 |
| 11 | SHOW FULL COLUMNS FROM `profile_photos` | | 13 | 13 | 1 |
| 12 | SHOW FULL COLUMNS FROM `profile_visitors` | | 4 | 4 | 1 |
| 13 | SHOW FULL COLUMNS FROM `favorites` | | 3 | 3 | 1 |
| 14 | SHOW FULL COLUMNS FROM `hiddens` | | 3 | 3 | 1 |
| 15 | SHOW FULL COLUMNS FROM `profile_notes` | | 4 | 4 | 1 |
| 16 | SHOW FULL COLUMNS FROM `profile_interests` | | 3 | 3 | 1 |
| 17 | SHOW FULL COLUMNS FROM `interests` | | 2 | 2 | 1 |
| 18 | SHOW FULL COLUMNS FROM `user_settings` | | 5 | 5 | 1 |
| 19 | SELECT `Profile`.`id`, `Profile`.`user_id`, `Profile`.`title`, `Profile`.`description`, `Profile`.`gender`, `Profile`.`height`, `Profile`.`profession`, `Profile`.`income`, `Profile`.`life_style`, `Profile`.`body_type`, `Profile`.`smoking`, `Profile`.`drinking`, `Profile`.`drugs`, `Profile`.`have_children`, `Profile`.`num_children`, `Profile`.`want_children`, `Profile`.`hair_color`, `Profile`.`eye_color`, `Profile`.`eye_shade`, `Profile`.`first_name`, `Profile`.`last_name`, `Profile`.`display_real_name`, `Profile`.`birthday`, `Profile`.`allow_find_by_real_name`, `Profile`.`orientation`, `Profile`.`relationship_status`, `Profile`.`display_rel_status`, `Profile`.`reason_for_joining`, `Profile`.`ethnicity`, `Profile`.`city`, `Profile`.`region_id`, `Profile`.`zip`, `Profile`.`country_id`, `Profile`.`diet`, `Profile`.`religion`, `Profile`.`religiousness`, `Profile`.`thoughts_on_astrology`, `Profile`.`have_car`, `Profile`.`education_status`, `Profile`.`job_title`, `Profile`.`education_level`, `Profile`.`intent`, `Profile`.`date_smoker`, `Profile`.`date_that_has_kids`, `Profile`.`longest_relationship`, `Profile`.`birth_parents_married`, `Profile`.`child_number`, `Profile`.`sisters_num`, `Profile`.`brothers_num`, `Profile`.`about_me`, `Profile`.`fun_or_interesting`, `Profile`.`doing_with_my_life`, `Profile`.`good_at`, `Profile`.`first_things`, `Profile`.`favorite_things`, `Profile`.`5_things`, `Profile`.`thinking_about`, `Profile`.`first_date_idea`, `Profile`.`friday_night`, `Profile`.`private_thing`, `Profile`.`message_me_if`, `Profile`.`search_radius`, `Profile`.`search_center_lat`, `Profile`.`search_center_lng`, `Profile`.`search_point1_lng`, `Profile`.`search_point1_lat`, `Profile`.`search_point2_lng`, `Profile`.`search_point2_lat`, `Profile`.`search_point3_lng`, `Profile`.`search_point3_lat`, `Profile`.`search_point4_lng`, `Profile`.`search_point4_lat`, `Profile`.`search_point5_lng`, `Profile`.`search_point5_lat`, `Profile`.`search_point6_lng`, `Profile`.`search_point6_lat`, `Profile`.`search_point7_lng`, `Profile`.`search_point7_lat`, `Profile`.`search_point8_lng`, `Profile`.`search_point8_lat`, `Profile`.`search_point9_lng`, `Profile`.`search_point9_lat`, `Profile`.`search_point10_lng`, `Profile`.`search_point10_lat`, `Profile`.`search_point0_lat`, `Profile`.`search_point0_lng`, `Profile`.`seeking`, `Profile`.`i_of_my_siblings`, `Profile`.`political_views`, `Profile`.`live_with`, `Profile`.`exercise`, `Profile`.`flagged`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`activation_key`, `User`.`active`, `User`.`updated`, `User`.`created`, `User`.`total_logins`, `User`.`last_online`, `User`.`login_key`, `User`.`activation_time`, `User`.`disabled`, `User`.`profile_filled`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`Code`, `Region`.`ADM1Code`, `Region`.`added_by_google`, `Region`.`deleted_by_google` FROM `profiles` AS `Profile` LEFT JOIN `users` AS `User` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `regions` AS `Region` ON (`Profile`.`region_id` = `Region`.`id`) WHERE `User`.`username` = 'kunal2' AND `User`.`active` = 1 LIMIT 1 | | 1 | 1 | 1 |
| 20 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`activation_key`, `User`.`active`, `User`.`updated`, `User`.`created`, `User`.`total_logins`, `User`.`last_online`, `User`.`login_key`, `User`.`activation_time`, `User`.`disabled`, `User`.`profile_filled` FROM `users` AS `User` WHERE `User`.`id` = 16 | | 1 | 1 | 0 |
| 21 | SELECT `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`Code`, `Region`.`ADM1Code`, `Region`.`added_by_google`, `Region`.`deleted_by_google` FROM `regions` AS `Region` WHERE `Region`.`id` = 126 | | 1 | 1 | 0 |
| 22 | SELECT `ProfileLanguage`.`id`, `ProfileLanguage`.`profile_id`, `ProfileLanguage`.`language_id`, `ProfileLanguage`.`level`, `ProfileLanguage`.`skill` FROM `profile_languages` AS `ProfileLanguage` WHERE `ProfileLanguage`.`profile_id` = (16) | | 0 | 0 | 0 |
| 23 | SELECT `ProfilePet`.`id`, `ProfilePet`.`likes`, `ProfilePet`.`profile_id`, `ProfilePet`.`pet_id` FROM `profile_pets` AS `ProfilePet` WHERE `ProfilePet`.`profile_id` = (16) | | 0 | 0 | 0 |
| 24 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (16) ORDER BY `num` ASC | | 0 | 0 | 0 |
| 25 | SELECT `Interest`.`name`, `Interest`.`id` FROM `profile_interests` AS `ProfileInterest` LEFT JOIN `interests` AS `Interest` ON (`ProfileInterest`.`interest_id` = `Interest`.`id`) WHERE `profile_id` = 16 | | 0 | 0 | 0 |
| 26 | SELECT `User`.`username`, `Profile`.`id`, `User`.`id` FROM `profiles` AS `Profile` LEFT JOIN `users` AS `User` ON (`Profile`.`user_id` = `User`.`id`) WHERE NOT (`Profile`.`id` = (16)) AND `User`.`active` = 1 AND `Profile`.`flagged` = 0 ORDER BY rand() ASC LIMIT 10 | | 9 | 9 | 1 |
| 27 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (17) ORDER BY `num` ASC LIMIT 1 | | 0 | 0 | 0 |
| 28 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (13) ORDER BY `num` ASC LIMIT 1 | | 0 | 0 | 0 |
| 29 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (19) ORDER BY `num` ASC LIMIT 1 | | 0 | 0 | 0 |
| 30 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (4) ORDER BY `num` ASC LIMIT 1 | | 1 | 1 | 0 |
| 31 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (21) ORDER BY `num` ASC LIMIT 1 | | 0 | 0 | 0 |
| 32 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (10) ORDER BY `num` ASC LIMIT 1 | | 1 | 1 | 0 |
| 33 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (7) ORDER BY `num` ASC LIMIT 1 | | 0 | 0 | 0 |
| 34 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (12) ORDER BY `num` ASC LIMIT 1 | | 0 | 0 | 0 |
| 35 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (15) ORDER BY `num` ASC LIMIT 1 | | 0 | 0 | 0 |
| 36 | SELECT `User`.`username`, `Profile`.`id`, `User`.`id` FROM `profiles` AS `Profile` LEFT JOIN `users` AS `User` ON (`Profile`.`user_id` = `User`.`id`) WHERE `Profile`.`id` IN (16, 14, 15, 6, 7) | | 5 | 5 | 0 |
| 37 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (6) ORDER BY `num` ASC LIMIT 1 | | 0 | 0 | 0 |
| 38 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (7) ORDER BY `num` ASC LIMIT 1 | | 0 | 0 | 0 |
| 39 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (14) ORDER BY `num` ASC LIMIT 1 | | 1 | 1 | 0 |
| 40 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (15) ORDER BY `num` ASC LIMIT 1 | | 0 | 0 | 0 |
| 41 | SELECT `ProfilePhoto`.`id`, `ProfilePhoto`.`num`, `ProfilePhoto`.`profile_id`, `ProfilePhoto`.`original_filename`, `ProfilePhoto`.`rnd_filename_part`, `ProfilePhoto`.`status`, `ProfilePhoto`.`thumbnail_x1`, `ProfilePhoto`.`thumbnail_y1`, `ProfilePhoto`.`thumbnail_x2`, `ProfilePhoto`.`thumbnail_y2`, `ProfilePhoto`.`hidden`, `ProfilePhoto`.`caption`, `ProfilePhoto`.`created` FROM `profile_photos` AS `ProfilePhoto` WHERE `status` = 0 AND `hidden` = 0 AND `ProfilePhoto`.`profile_id` = (16) ORDER BY `num` ASC LIMIT 1 | | 0 | 0 | 0 |