Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.title AS title_3, 
  t0.description AS description_4, 
  t0.content AS content_5, 
  t0.brief AS brief_6, 
  t0.header_type AS header_type_7, 
  t0.is_active AS is_active_8, 
  t0.is_on_homepage AS is_on_homepage_9, 
  t0.date AS date_10, 
  t0.image_name AS image_name_11, 
  t0.uri AS uri_12, 
  t0.image_alt AS image_alt_13, 
  t0.locale AS locale_14 
FROM 
  article t0 
WHERE 
  t0.locale = ? 
  AND t0.is_active = ? 
ORDER BY 
  t0.date DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.description AS description_4, t0.content AS content_5, t0.brief AS brief_6, t0.header_type AS header_type_7, t0.is_active AS is_active_8, t0.is_on_homepage AS is_on_homepage_9, t0.date AS date_10, t0.image_name AS image_name_11, t0.uri AS uri_12, t0.image_alt AS image_alt_13, t0.locale AS locale_14 FROM article t0 WHERE t0.locale = 'he' AND t0.is_active = 1 ORDER BY t0.date DESC;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.description AS description_3, 
  t0.page AS page_4 
FROM 
  seo t0 
WHERE 
  t0.page = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.page AS page_4 FROM seo t0 WHERE t0.page = 'magazine' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.report_email AS report_email_2, 
  t0.contact_from_email AS contact_from_email_3, 
  t0.contact_email AS contact_email_4, 
  t0.send_message_users_number AS send_message_users_number_5, 
  t0.send_message_users_number_without_photo AS send_message_users_number_without_photo_6, 
  t0.users_per_page AS users_per_page_7, 
  t0.is_charge AS is_charge_8, 
  t0.message_popularity_days_number AS message_popularity_days_number_9, 
  t0.user_considered_as_online_after_last_activity_minutes_number AS user_considered_as_online_after_last_activity_minutes_number_10, 
  t0.delete_messages_after_days_number AS delete_messages_after_days_number_11, 
  t0.user_considered_as_new_after_days_number AS user_considered_as_new_after_days_number_12, 
  t0.sms_username AS sms_username_13, 
  t0.sms_password AS sms_password_14, 
  t0.sms_sufix AS sms_sufix_15, 
  t0.offline_push_title AS offline_push_title_16, 
  t0.offline_push_text AS offline_push_text_17, 
  t0.offline_push_every AS offline_push_every_18, 
  t0.offline_push_after AS offline_push_after_19, 
  t0.offline_push_only_interdate AS offline_push_only_interdate_20 
FROM 
  settings t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.report_email AS report_email_2, t0.contact_from_email AS contact_from_email_3, t0.contact_email AS contact_email_4, t0.send_message_users_number AS send_message_users_number_5, t0.send_message_users_number_without_photo AS send_message_users_number_without_photo_6, t0.users_per_page AS users_per_page_7, t0.is_charge AS is_charge_8, t0.message_popularity_days_number AS message_popularity_days_number_9, t0.user_considered_as_online_after_last_activity_minutes_number AS user_considered_as_online_after_last_activity_minutes_number_10, t0.delete_messages_after_days_number AS delete_messages_after_days_number_11, t0.user_considered_as_new_after_days_number AS user_considered_as_new_after_days_number_12, t0.sms_username AS sms_username_13, t0.sms_password AS sms_password_14, t0.sms_sufix AS sms_sufix_15, t0.offline_push_title AS offline_push_title_16, t0.offline_push_text AS offline_push_text_17, t0.offline_push_every AS offline_push_every_18, t0.offline_push_after AS offline_push_after_19, t0.offline_push_only_interdate AS offline_push_only_interdate_20 FROM settings t0 WHERE t0.id = 1;

SELECT 
  u0_.id AS id_0, 
  u0_.phone AS phone_1, 
  u0_.username AS username_2, 
  u0_.password AS password_3, 
  u0_.email AS email_4, 
  u0_.birthday AS birthday_5, 
  u0_.is_sent_email AS is_sent_email_6, 
  u0_.RelationshipTypeDetails AS RelationshipTypeDetails_7, 
  u0_.sexOrientationDetails AS sexOrientationDetails_8, 
  u0_.about AS about_9, 
  u0_.looking AS looking_10, 
  u0_.LookingForDetails AS LookingForDetails_11, 
  u0_.age_from AS age_from_12, 
  u0_.age_to AS age_to_13, 
  u0_.height AS height_14, 
  u0_.views AS views_15, 
  u0_.points AS points_16, 
  u0_.freeze_reason AS freeze_reason_17, 
  u0_.ban_reason AS ban_reason_18, 
  u0_.admin_comments AS admin_comments_19, 
  u0_.ip AS ip_20, 
  u0_.code AS code_21, 
  u0_.is_active AS is_active_22, 
  u0_.is_activated AS is_activated_23, 
  u0_.is_non_locked AS is_non_locked_24, 
  u0_.isUpdatedZodiac AS isUpdatedZodiac_25, 
  u0_.is_frozen AS is_frozen_26, 
  u0_.is_flagged AS is_flagged_27, 
  u0_.is_on_homepage AS is_on_homepage_28, 
  u0_.last_activity_at AS last_activity_at_29, 
  u0_.last_real_activity_at AS last_real_activity_at_30, 
  u0_.last_login_at AS last_login_at_31, 
  u0_.sign_up_date AS sign_up_date_32, 
  u0_.start_subscription AS start_subscription_33, 
  u0_.end_subscription AS end_subscription_34, 
  u0_.code_date AS code_date_35, 
  u0_.verify_count AS verify_count_36, 
  u0_.code_count AS code_count_37, 
  u0_.longitude AS longitude_38, 
  u0_.latitude AS latitude_39, 
  u0_.is_sent_push AS is_sent_push_40, 
  u0_.facebook_id AS facebook_id_41, 
  u0_.is_vip AS is_vip_42, 
  u0_.role_id AS role_id_43, 
  u0_.gender_id AS gender_id_44, 
  u0_.region_id AS region_id_45, 
  u0_.city_id AS city_id_46, 
  u0_.children_id AS children_id_47, 
  u0_.religion_id AS religion_id_48, 
  u0_.nutrition_id AS nutrition_id_49, 
  u0_.relationship_status_id AS relationship_status_id_50, 
  u0_.relationship_type_id AS relationship_type_id_51, 
  u0_.sex_orientation_id AS sex_orientation_id_52, 
  u0_.smoking_id AS smoking_id_53, 
  u0_.body_id AS body_id_54, 
  u0_.origin_id AS origin_id_55, 
  u0_.zodiac_id AS zodiac_id_56, 
  u0_.login_from_id AS login_from_id_57 
FROM 
  user u0_ 
  LEFT JOIN file f1_ ON u0_.id = f1_.user_id 
  AND f1_.type IN ('1') 
  AND (f1_.is_valid = 1) 
ORDER BY 
  f1_.is_valid DESC, 
  u0_.sign_up_date DESC 
LIMIT 
  42

SELECT u0_.id AS id_0, u0_.phone AS phone_1, u0_.username AS username_2, u0_.password AS password_3, u0_.email AS email_4, u0_.birthday AS birthday_5, u0_.is_sent_email AS is_sent_email_6, u0_.RelationshipTypeDetails AS RelationshipTypeDetails_7, u0_.sexOrientationDetails AS sexOrientationDetails_8, u0_.about AS about_9, u0_.looking AS looking_10, u0_.LookingForDetails AS LookingForDetails_11, u0_.age_from AS age_from_12, u0_.age_to AS age_to_13, u0_.height AS height_14, u0_.views AS views_15, u0_.points AS points_16, u0_.freeze_reason AS freeze_reason_17, u0_.ban_reason AS ban_reason_18, u0_.admin_comments AS admin_comments_19, u0_.ip AS ip_20, u0_.code AS code_21, u0_.is_active AS is_active_22, u0_.is_activated AS is_activated_23, u0_.is_non_locked AS is_non_locked_24, u0_.isUpdatedZodiac AS isUpdatedZodiac_25, u0_.is_frozen AS is_frozen_26, u0_.is_flagged AS is_flagged_27, u0_.is_on_homepage AS is_on_homepage_28, u0_.last_activity_at AS last_activity_at_29, u0_.last_real_activity_at AS last_real_activity_at_30, u0_.last_login_at AS last_login_at_31, u0_.sign_up_date AS sign_up_date_32, u0_.start_subscription AS start_subscription_33, u0_.end_subscription AS end_subscription_34, u0_.code_date AS code_date_35, u0_.verify_count AS verify_count_36, u0_.code_count AS code_count_37, u0_.longitude AS longitude_38, u0_.latitude AS latitude_39, u0_.is_sent_push AS is_sent_push_40, u0_.facebook_id AS facebook_id_41, u0_.is_vip AS is_vip_42, u0_.role_id AS role_id_43, u0_.gender_id AS gender_id_44, u0_.region_id AS region_id_45, u0_.city_id AS city_id_46, u0_.children_id AS children_id_47, u0_.religion_id AS religion_id_48, u0_.nutrition_id AS nutrition_id_49, u0_.relationship_status_id AS relationship_status_id_50, u0_.relationship_type_id AS relationship_type_id_51, u0_.sex_orientation_id AS sex_orientation_id_52, u0_.smoking_id AS smoking_id_53, u0_.body_id AS body_id_54, u0_.origin_id AS origin_id_55, u0_.zodiac_id AS zodiac_id_56, u0_.login_from_id AS login_from_id_57 FROM user u0_ LEFT JOIN file f1_ ON u0_.id = f1_.user_id AND f1_.type IN ('1') AND (f1_.is_valid = 1) ORDER BY f1_.is_valid DESC, u0_.sign_up_date DESC LIMIT 42;

SELECT 
  COUNT(*) AS dctrn_count 
FROM 
  (
    SELECT 
      DISTINCT id_0 
    FROM 
      (
        SELECT 
          u0_.id AS id_0, 
          u0_.phone AS phone_1, 
          u0_.username AS username_2, 
          u0_.password AS password_3, 
          u0_.email AS email_4, 
          u0_.birthday AS birthday_5, 
          u0_.is_sent_email AS is_sent_email_6, 
          u0_.RelationshipTypeDetails AS RelationshipTypeDetails_7, 
          u0_.sexOrientationDetails AS sexOrientationDetails_8, 
          u0_.about AS about_9, 
          u0_.looking AS looking_10, 
          u0_.LookingForDetails AS LookingForDetails_11, 
          u0_.age_from AS age_from_12, 
          u0_.age_to AS age_to_13, 
          u0_.height AS height_14, 
          u0_.views AS views_15, 
          u0_.points AS points_16, 
          u0_.freeze_reason AS freeze_reason_17, 
          u0_.ban_reason AS ban_reason_18, 
          u0_.admin_comments AS admin_comments_19, 
          u0_.ip AS ip_20, 
          u0_.code AS code_21, 
          u0_.is_active AS is_active_22, 
          u0_.is_activated AS is_activated_23, 
          u0_.is_non_locked AS is_non_locked_24, 
          u0_.isUpdatedZodiac AS isUpdatedZodiac_25, 
          u0_.is_frozen AS is_frozen_26, 
          u0_.is_flagged AS is_flagged_27, 
          u0_.is_on_homepage AS is_on_homepage_28, 
          u0_.last_activity_at AS last_activity_at_29, 
          u0_.last_real_activity_at AS last_real_activity_at_30, 
          u0_.last_login_at AS last_login_at_31, 
          u0_.sign_up_date AS sign_up_date_32, 
          u0_.start_subscription AS start_subscription_33, 
          u0_.end_subscription AS end_subscription_34, 
          u0_.code_date AS code_date_35, 
          u0_.verify_count AS verify_count_36, 
          u0_.code_count AS code_count_37, 
          u0_.longitude AS longitude_38, 
          u0_.latitude AS latitude_39, 
          u0_.is_sent_push AS is_sent_push_40, 
          u0_.facebook_id AS facebook_id_41, 
          u0_.is_vip AS is_vip_42 
        FROM 
          user u0_ 
          LEFT JOIN file f1_ ON u0_.id = f1_.user_id 
          AND f1_.type IN ('1') 
          AND (f1_.is_valid = 1) 
        ORDER BY 
          f1_.is_valid DESC, 
          u0_.sign_up_date DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT u0_.id AS id_0, u0_.phone AS phone_1, u0_.username AS username_2, u0_.password AS password_3, u0_.email AS email_4, u0_.birthday AS birthday_5, u0_.is_sent_email AS is_sent_email_6, u0_.RelationshipTypeDetails AS RelationshipTypeDetails_7, u0_.sexOrientationDetails AS sexOrientationDetails_8, u0_.about AS about_9, u0_.looking AS looking_10, u0_.LookingForDetails AS LookingForDetails_11, u0_.age_from AS age_from_12, u0_.age_to AS age_to_13, u0_.height AS height_14, u0_.views AS views_15, u0_.points AS points_16, u0_.freeze_reason AS freeze_reason_17, u0_.ban_reason AS ban_reason_18, u0_.admin_comments AS admin_comments_19, u0_.ip AS ip_20, u0_.code AS code_21, u0_.is_active AS is_active_22, u0_.is_activated AS is_activated_23, u0_.is_non_locked AS is_non_locked_24, u0_.isUpdatedZodiac AS isUpdatedZodiac_25, u0_.is_frozen AS is_frozen_26, u0_.is_flagged AS is_flagged_27, u0_.is_on_homepage AS is_on_homepage_28, u0_.last_activity_at AS last_activity_at_29, u0_.last_real_activity_at AS last_real_activity_at_30, u0_.last_login_at AS last_login_at_31, u0_.sign_up_date AS sign_up_date_32, u0_.start_subscription AS start_subscription_33, u0_.end_subscription AS end_subscription_34, u0_.code_date AS code_date_35, u0_.verify_count AS verify_count_36, u0_.code_count AS code_count_37, u0_.longitude AS longitude_38, u0_.latitude AS latitude_39, u0_.is_sent_push AS is_sent_push_40, u0_.facebook_id AS facebook_id_41, u0_.is_vip AS is_vip_42 FROM user u0_ LEFT JOIN file f1_ ON u0_.id = f1_.user_id AND f1_.type IN ('1') AND (f1_.is_valid = 1) ORDER BY f1_.is_valid DESC, u0_.sign_up_date DESC) dctrn_result) dctrn_table;

SELECT 
  DISTINCT id_0 
FROM 
  (
    SELECT 
      DISTINCT id_0, 
      is_valid_43, 
      sign_up_date_32 
    FROM 
      (
        SELECT 
          u0_.id AS id_0, 
          u0_.phone AS phone_1, 
          u0_.username AS username_2, 
          u0_.password AS password_3, 
          u0_.email AS email_4, 
          u0_.birthday AS birthday_5, 
          u0_.is_sent_email AS is_sent_email_6, 
          u0_.RelationshipTypeDetails AS RelationshipTypeDetails_7, 
          u0_.sexOrientationDetails AS sexOrientationDetails_8, 
          u0_.about AS about_9, 
          u0_.looking AS looking_10, 
          u0_.LookingForDetails AS LookingForDetails_11, 
          u0_.age_from AS age_from_12, 
          u0_.age_to AS age_to_13, 
          u0_.height AS height_14, 
          u0_.views AS views_15, 
          u0_.points AS points_16, 
          u0_.freeze_reason AS freeze_reason_17, 
          u0_.ban_reason AS ban_reason_18, 
          u0_.admin_comments AS admin_comments_19, 
          u0_.ip AS ip_20, 
          u0_.code AS code_21, 
          u0_.is_active AS is_active_22, 
          u0_.is_activated AS is_activated_23, 
          u0_.is_non_locked AS is_non_locked_24, 
          u0_.isUpdatedZodiac AS isUpdatedZodiac_25, 
          u0_.is_frozen AS is_frozen_26, 
          u0_.is_flagged AS is_flagged_27, 
          u0_.is_on_homepage AS is_on_homepage_28, 
          u0_.last_activity_at AS last_activity_at_29, 
          u0_.last_real_activity_at AS last_real_activity_at_30, 
          u0_.last_login_at AS last_login_at_31, 
          u0_.sign_up_date AS sign_up_date_32, 
          u0_.start_subscription AS start_subscription_33, 
          u0_.end_subscription AS end_subscription_34, 
          u0_.code_date AS code_date_35, 
          u0_.verify_count AS verify_count_36, 
          u0_.code_count AS code_count_37, 
          u0_.longitude AS longitude_38, 
          u0_.latitude AS latitude_39, 
          u0_.is_sent_push AS is_sent_push_40, 
          u0_.facebook_id AS facebook_id_41, 
          u0_.is_vip AS is_vip_42, 
          f1_.is_valid AS is_valid_43, 
          f1_.type AS type_44 
        FROM 
          user u0_ 
          LEFT JOIN file f1_ ON u0_.id = f1_.user_id 
          AND f1_.type IN ('1') 
          AND (f1_.is_valid = 1)
      ) dctrn_result_inner 
    ORDER BY 
      is_valid_43 DESC, 
      sign_up_date_32 DESC
  ) dctrn_result 
LIMIT 
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, is_valid_43, sign_up_date_32 FROM (SELECT u0_.id AS id_0, u0_.phone AS phone_1, u0_.username AS username_2, u0_.password AS password_3, u0_.email AS email_4, u0_.birthday AS birthday_5, u0_.is_sent_email AS is_sent_email_6, u0_.RelationshipTypeDetails AS RelationshipTypeDetails_7, u0_.sexOrientationDetails AS sexOrientationDetails_8, u0_.about AS about_9, u0_.looking AS looking_10, u0_.LookingForDetails AS LookingForDetails_11, u0_.age_from AS age_from_12, u0_.age_to AS age_to_13, u0_.height AS height_14, u0_.views AS views_15, u0_.points AS points_16, u0_.freeze_reason AS freeze_reason_17, u0_.ban_reason AS ban_reason_18, u0_.admin_comments AS admin_comments_19, u0_.ip AS ip_20, u0_.code AS code_21, u0_.is_active AS is_active_22, u0_.is_activated AS is_activated_23, u0_.is_non_locked AS is_non_locked_24, u0_.isUpdatedZodiac AS isUpdatedZodiac_25, u0_.is_frozen AS is_frozen_26, u0_.is_flagged AS is_flagged_27, u0_.is_on_homepage AS is_on_homepage_28, u0_.last_activity_at AS last_activity_at_29, u0_.last_real_activity_at AS last_real_activity_at_30, u0_.last_login_at AS last_login_at_31, u0_.sign_up_date AS sign_up_date_32, u0_.start_subscription AS start_subscription_33, u0_.end_subscription AS end_subscription_34, u0_.code_date AS code_date_35, u0_.verify_count AS verify_count_36, u0_.code_count AS code_count_37, u0_.longitude AS longitude_38, u0_.latitude AS latitude_39, u0_.is_sent_push AS is_sent_push_40, u0_.facebook_id AS facebook_id_41, u0_.is_vip AS is_vip_42, f1_.is_valid AS is_valid_43, f1_.type AS type_44 FROM user u0_ LEFT JOIN file f1_ ON u0_.id = f1_.user_id AND f1_.type IN ('1') AND (f1_.is_valid = 1)) dctrn_result_inner ORDER BY is_valid_43 DESC, sign_up_date_32 DESC) dctrn_result LIMIT 20;

SELECT 
  u0_.id AS id_0, 
  u0_.phone AS phone_1, 
  u0_.username AS username_2, 
  u0_.password AS password_3, 
  u0_.email AS email_4, 
  u0_.birthday AS birthday_5, 
  u0_.is_sent_email AS is_sent_email_6, 
  u0_.RelationshipTypeDetails AS RelationshipTypeDetails_7, 
  u0_.sexOrientationDetails AS sexOrientationDetails_8, 
  u0_.about AS about_9, 
  u0_.looking AS looking_10, 
  u0_.LookingForDetails AS LookingForDetails_11, 
  u0_.age_from AS age_from_12, 
  u0_.age_to AS age_to_13, 
  u0_.height AS height_14, 
  u0_.views AS views_15, 
  u0_.points AS points_16, 
  u0_.freeze_reason AS freeze_reason_17, 
  u0_.ban_reason AS ban_reason_18, 
  u0_.admin_comments AS admin_comments_19, 
  u0_.ip AS ip_20, 
  u0_.code AS code_21, 
  u0_.is_active AS is_active_22, 
  u0_.is_activated AS is_activated_23, 
  u0_.is_non_locked AS is_non_locked_24, 
  u0_.isUpdatedZodiac AS isUpdatedZodiac_25, 
  u0_.is_frozen AS is_frozen_26, 
  u0_.is_flagged AS is_flagged_27, 
  u0_.is_on_homepage AS is_on_homepage_28, 
  u0_.last_activity_at AS last_activity_at_29, 
  u0_.last_real_activity_at AS last_real_activity_at_30, 
  u0_.last_login_at AS last_login_at_31, 
  u0_.sign_up_date AS sign_up_date_32, 
  u0_.start_subscription AS start_subscription_33, 
  u0_.end_subscription AS end_subscription_34, 
  u0_.code_date AS code_date_35, 
  u0_.verify_count AS verify_count_36, 
  u0_.code_count AS code_count_37, 
  u0_.longitude AS longitude_38, 
  u0_.latitude AS latitude_39, 
  u0_.is_sent_push AS is_sent_push_40, 
  u0_.facebook_id AS facebook_id_41, 
  u0_.is_vip AS is_vip_42, 
  u0_.role_id AS role_id_43, 
  u0_.gender_id AS gender_id_44, 
  u0_.region_id AS region_id_45, 
  u0_.city_id AS city_id_46, 
  u0_.children_id AS children_id_47, 
  u0_.religion_id AS religion_id_48, 
  u0_.nutrition_id AS nutrition_id_49, 
  u0_.relationship_status_id AS relationship_status_id_50, 
  u0_.relationship_type_id AS relationship_type_id_51, 
  u0_.sex_orientation_id AS sex_orientation_id_52, 
  u0_.smoking_id AS smoking_id_53, 
  u0_.body_id AS body_id_54, 
  u0_.origin_id AS origin_id_55, 
  u0_.zodiac_id AS zodiac_id_56, 
  u0_.login_from_id AS login_from_id_57 
FROM 
  user u0_ 
  LEFT JOIN file f1_ ON u0_.id = f1_.user_id 
  AND f1_.type IN ('1') 
  AND (f1_.is_valid = 1) 
WHERE 
  u0_.id IN (?) 
ORDER BY 
  f1_.is_valid DESC, 
  u0_.sign_up_date DESC

SELECT u0_.id AS id_0, u0_.phone AS phone_1, u0_.username AS username_2, u0_.password AS password_3, u0_.email AS email_4, u0_.birthday AS birthday_5, u0_.is_sent_email AS is_sent_email_6, u0_.RelationshipTypeDetails AS RelationshipTypeDetails_7, u0_.sexOrientationDetails AS sexOrientationDetails_8, u0_.about AS about_9, u0_.looking AS looking_10, u0_.LookingForDetails AS LookingForDetails_11, u0_.age_from AS age_from_12, u0_.age_to AS age_to_13, u0_.height AS height_14, u0_.views AS views_15, u0_.points AS points_16, u0_.freeze_reason AS freeze_reason_17, u0_.ban_reason AS ban_reason_18, u0_.admin_comments AS admin_comments_19, u0_.ip AS ip_20, u0_.code AS code_21, u0_.is_active AS is_active_22, u0_.is_activated AS is_activated_23, u0_.is_non_locked AS is_non_locked_24, u0_.isUpdatedZodiac AS isUpdatedZodiac_25, u0_.is_frozen AS is_frozen_26, u0_.is_flagged AS is_flagged_27, u0_.is_on_homepage AS is_on_homepage_28, u0_.last_activity_at AS last_activity_at_29, u0_.last_real_activity_at AS last_real_activity_at_30, u0_.last_login_at AS last_login_at_31, u0_.sign_up_date AS sign_up_date_32, u0_.start_subscription AS start_subscription_33, u0_.end_subscription AS end_subscription_34, u0_.code_date AS code_date_35, u0_.verify_count AS verify_count_36, u0_.code_count AS code_count_37, u0_.longitude AS longitude_38, u0_.latitude AS latitude_39, u0_.is_sent_push AS is_sent_push_40, u0_.facebook_id AS facebook_id_41, u0_.is_vip AS is_vip_42, u0_.role_id AS role_id_43, u0_.gender_id AS gender_id_44, u0_.region_id AS region_id_45, u0_.city_id AS city_id_46, u0_.children_id AS children_id_47, u0_.religion_id AS religion_id_48, u0_.nutrition_id AS nutrition_id_49, u0_.relationship_status_id AS relationship_status_id_50, u0_.relationship_type_id AS relationship_type_id_51, u0_.sex_orientation_id AS sex_orientation_id_52, u0_.smoking_id AS smoking_id_53, u0_.body_id AS body_id_54, u0_.origin_id AS origin_id_55, u0_.zodiac_id AS zodiac_id_56, u0_.login_from_id AS login_from_id_57 FROM user u0_ LEFT JOIN file f1_ ON u0_.id = f1_.user_id AND f1_.type IN ('1') AND (f1_.is_valid = 1) WHERE u0_.id IN (26529, 26527, 26520, 26514, 26510, 26509, 26508, 26507, 26498, 26497, 26496, 26495, 26494, 26489, 26480, 26479, 26477, 26475, 26473, 26468) ORDER BY f1_.is_valid DESC, u0_.sign_up_date DESC;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2 
FROM 
  region t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM region t0 WHERE t0.id = 10;

SELECT 
  t0.id AS id_1, 
  t0.ext AS ext_2, 
  t0.is_valid AS is_valid_3, 
  t0.is_private AS is_private_4, 
  t0.updated AS updated_5, 
  t0.is_main AS is_main_6, 
  t0.user_id AS user_id_7, 
  t0.type 
FROM 
  file t0 
WHERE 
  t0.user_id = ? 
  AND t0.type IN ('1')

SELECT t0.id AS id_1, t0.ext AS ext_2, t0.is_valid AS is_valid_3, t0.is_private AS is_private_4, t0.updated AS updated_5, t0.is_main AS is_main_6, t0.user_id AS user_id_7, t0.type FROM file t0 WHERE t0.user_id = 26529 AND t0.type IN ('1');

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2 
FROM 
  region t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM region t0 WHERE t0.id = 1;

SELECT 
  t0.id AS id_1, 
  t0.ext AS ext_2, 
  t0.is_valid AS is_valid_3, 
  t0.is_private AS is_private_4, 
  t0.updated AS updated_5, 
  t0.is_main AS is_main_6, 
  t0.user_id AS user_id_7, 
  t0.type 
FROM 
  file t0 
WHERE 
  t0.user_id = ? 
  AND t0.type IN ('1')

SELECT t0.id AS id_1, t0.ext AS ext_2, t0.is_valid AS is_valid_3, t0.is_private AS is_private_4, t0.updated AS updated_5, t0.is_main AS is_main_6, t0.user_id AS user_id_7, t0.type FROM file t0 WHERE t0.user_id = 26527 AND t0.type IN ('1');

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2 
FROM 
  region t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM region t0 WHERE t0.id = 2;

SELECT 
  t0.id AS id_1, 
  t0.ext AS ext_2, 
  t0.is_valid AS is_valid_3, 
  t0.is_private AS is_private_4, 
  t0.updated AS updated_5, 
  t0.is_main AS is_main_6, 
  t0.user_id AS user_id_7, 
  t0.type 
FROM 
  file t0 
WHERE 
  t0.user_id = ? 
  AND t0.type IN ('1')

SELECT t0.id AS id_1, t0.ext AS ext_2, t0.is_valid AS is_valid_3, t0.is_private AS is_private_4, t0.updated AS updated_5, t0.is_main AS is_main_6, t0.user_id AS user_id_7, t0.type FROM file t0 WHERE t0.user_id = 26520 AND t0.type IN ('1');

SELECT 
  t0.id AS id_1, 
  t0.ext AS ext_2, 
  t0.is_valid AS is_valid_3, 
  t0.is_private AS is_private_4, 
  t0.updated AS updated_5, 
  t0.is_main AS is_main_6, 
  t0.user_id AS user_id_7, 
  t0.type 
FROM 
  file t0 
WHERE 
  t0.user_id = ? 
  AND t0.type IN ('1')

SELECT t0.id AS id_1, t0.ext AS ext_2, t0.is_valid AS is_valid_3, t0.is_private AS is_private_4, t0.updated AS updated_5, t0.is_main AS is_main_6, t0.user_id AS user_id_7, t0.type FROM file t0 WHERE t0.user_id = 26514 AND t0.type IN ('1');

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2 
FROM 
  region t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM region t0 WHERE t0.id = 8;

SELECT 
  t0.id AS id_1, 
  t0.ext AS ext_2, 
  t0.is_valid AS is_valid_3, 
  t0.is_private AS is_private_4, 
  t0.updated AS updated_5, 
  t0.is_main AS is_main_6, 
  t0.user_id AS user_id_7, 
  t0.type 
FROM 
  file t0 
WHERE 
  t0.user_id = ? 
  AND t0.type IN ('1')

SELECT t0.id AS id_1, t0.ext AS ext_2, t0.is_valid AS is_valid_3, t0.is_private AS is_private_4, t0.updated AS updated_5, t0.is_main AS is_main_6, t0.user_id AS user_id_7, t0.type FROM file t0 WHERE t0.user_id = 26510 AND t0.type IN ('1');

SELECT 
  t0.id AS id_1, 
  t0.ext AS ext_2, 
  t0.is_valid AS is_valid_3, 
  t0.is_private AS is_private_4, 
  t0.updated AS updated_5, 
  t0.is_main AS is_main_6, 
  t0.user_id AS user_id_7, 
  t0.type 
FROM 
  file t0 
WHERE 
  t0.user_id = ? 
  AND t0.type IN ('1')

SELECT t0.id AS id_1, t0.ext AS ext_2, t0.is_valid AS is_valid_3, t0.is_private AS is_private_4, t0.updated AS updated_5, t0.is_main AS is_main_6, t0.user_id AS user_id_7, t0.type FROM file t0 WHERE t0.user_id = 26509 AND t0.type IN ('1');

SELECT 
  t0.id AS id_1, 
  t0.ext AS ext_2, 
  t0.is_valid AS is_valid_3, 
  t0.is_private AS is_private_4, 
  t0.updated AS updated_5, 
  t0.is_main AS is_main_6, 
  t0.user_id AS user_id_7, 
  t0.type 
FROM 
  file t0 
WHERE 
  t0.user_id = ? 
  AND t0.type IN ('1')

SELECT t0.id AS id_1, t0.ext AS ext_2, t0.is_valid AS is_valid_3, t0.is_private AS is_private_4, t0.updated AS updated_5, t0.is_main AS is_main_6, t0.user_id AS user_id_7, t0.type FROM file t0 WHERE t0.user_id = 26508 AND t0.type IN ('1');

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2 
FROM 
  region t0 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM region t0 WHERE t0.id = 11;

SELECT 
  t0.id AS id_1, 
  t0.ext AS ext_2, 
  t0.is_valid AS is_valid_3, 
  t0.is_private AS is_private_4, 
  t0.updated AS updated_5, 
  t0.is_main AS is_main_6, 
  t0.user_id AS user_id_7, 
  t0.type 
FROM 
  file t0 
WHERE 
  t0.user_id = ? 
  AND t0.type IN ('1')

SELECT t0.id AS id_1, t0.ext AS ext_2, t0.is_valid AS is_valid_3, t0.is_private AS is_private_4, t0.updated AS updated_5, t0.is_main AS is_main_6, t0.user_id AS user_id_7, t0.type FROM file t0 WHERE t0.user_id = 26507 AND t0.type IN ('1');

SELECT 
  t0.id AS id_1, 
  t0.ext AS ext_2, 
  t0.is_valid AS is_valid_3, 
  t0.is_private AS is_private_4, 
  t0.updated AS updated_5, 
  t0.is_main AS is_main_6, 
  t0.user_id AS user_id_7, 
  t0.type 
FROM 
  file t0 
WHERE 
  t0.user_id = ? 
  AND t0.type IN ('1')

SELECT t0.id AS id_1, t0.ext AS ext_2, t0.is_valid AS is_valid_3, t0.is_private AS is_private_4, t0.updated AS updated_5, t0.is_main AS is_main_6, t0.user_id AS user_id_7, t0.type FROM file t0 WHERE t0.user_id = 26498 AND t0.type IN ('1');

SELECT 
  t0.id AS id_1, 
  t0.ext AS ext_2, 
  t0.is_valid AS is_valid_3, 
  t0.is_private AS is_private_4, 
  t0.updated AS updated_5, 
  t0.is_main AS is_main_6, 
  t0.user_id AS user_id_7, 
  t0.type 
FROM 
  file t0 
WHERE 
  t0.user_id = ? 
  AND t0.type IN ('1')

SELECT t0.id AS id_1, t0.ext AS ext_2, t0.is_valid AS is_valid_3, t0.is_private AS is_private_4, t0.updated AS updated_5, t0.is_main AS is_main_6, t0.user_id AS user_id_7, t0.type FROM file t0 WHERE t0.user_id = 26497 AND t0.type IN ('1');

SELECT 
  t0.id AS id_1, 
  t0.ext AS ext_2, 
  t0.is_valid AS is_valid_3, 
  t0.is_private AS is_private_4, 
  t0.updated AS updated_5, 
  t0.is_main AS is_main_6, 
  t0.user_id AS user_id_7, 
  t0.type 
FROM 
  file t0 
WHERE 
  t0.user_id = ? 
  AND t0.type IN ('1')

SELECT t0.id AS id_1, t0.ext AS ext_2, t0.is_valid AS is_valid_3, t0.is_private AS is_private_4, t0.updated AS updated_5, t0.is_main AS is_main_6, t0.user_id AS user_id_7, t0.type FROM file t0 WHERE t0.user_id = 26496 AND t0.type IN ('1');

SELECT 
  t0.id AS id_1, 
  t0.ext AS ext_2, 
  t0.is_valid AS is_valid_3, 
  t0.is_private AS is_private_4, 
  t0.updated AS updated_5, 
  t0.is_main AS is_main_6, 
  t0.user_id AS user_id_7, 
  t0.type 
FROM 
  file t0 
WHERE 
  t0.user_id = ? 
  AND t0.type IN ('1')

SELECT t0.id AS id_1, t0.ext AS ext_2, t0.is_valid AS is_valid_3, t0.is_private AS is_private_4, t0.updated AS updated_5, t0.is_main AS is_main_6, t0.user_id AS user_id_7, t0.type FROM file t0 WHERE t0.user_id = 26495 AND t0.type IN ('1');