Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.placed_at AS placed_at_2,
  t0.placed_until AS placed_until_3,
  t0.profile_id AS profile_id_4,
  t0.entity_type
FROM
  placement_hidings t0
WHERE
  t0.profile_id = ?
  AND t0.entity_type IN ('profile')

SELECT t0.id AS id_1, t0.placed_at AS placed_at_2, t0.placed_until AS placed_until_3, t0.profile_id AS profile_id_4, t0.entity_type FROM placement_hidings t0 WHERE t0.profile_id = 1 AND t0.entity_type IN ('profile');

SELECT
  t0.type AS type_1,
  t0.position_group AS position_group_2,
  t0.position AS position_3,
  t0.placed_at AS placed_at_4,
  t0.placed_until AS placed_until_5,
  t0.plan_managed AS plan_managed_6,
  t0.profile_id AS profile_id_7,
  t0.placement_price_id AS placement_price_id_8
FROM
  profile_adboard_placements t0
WHERE
  t0.profile_id = ?

SELECT t0.type AS type_1, t0.position_group AS position_group_2, t0.position AS position_3, t0.placed_at AS placed_at_4, t0.placed_until AS placed_until_5, t0.plan_managed AS plan_managed_6, t0.profile_id AS profile_id_7, t0.placement_price_id AS placement_price_id_8 FROM profile_adboard_placements t0 WHERE t0.profile_id = 1;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.preview_path AS preview_path_3,
  t0.is_main AS is_main_4,
  t0.is_confirmed AS is_confirmed_5,
  t0.profile_id AS profile_id_6,
  t0.confirmed_by AS confirmed_by_7,
  t0.type
FROM
  profile_media_files t0
WHERE
  t0.profile_id = ?
  AND t0.type IN ('adm_apr_ph')

SELECT t0.id AS id_1, t0.path AS path_2, t0.preview_path AS preview_path_3, t0.is_main AS is_main_4, t0.is_confirmed AS is_confirmed_5, t0.profile_id AS profile_id_6, t0.confirmed_by AS confirmed_by_7, t0.type FROM profile_media_files t0 WHERE t0.profile_id = 1 AND t0.type IN ('adm_apr_ph');

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.preview_path AS preview_path_3,
  t0.is_main AS is_main_4,
  t0.is_confirmed AS is_confirmed_5,
  t0.profile_id AS profile_id_6,
  t0.confirmed_by AS confirmed_by_7,
  t0.type
FROM
  profile_media_files t0
WHERE
  t0.profile_id = ?
  AND t0.type IN ('avatar')

SELECT t0.id AS id_1, t0.path AS path_2, t0.preview_path AS preview_path_3, t0.is_main AS is_main_4, t0.is_confirmed AS is_confirmed_5, t0.profile_id AS profile_id_6, t0.confirmed_by AS confirmed_by_7, t0.type FROM profile_media_files t0 WHERE t0.profile_id = 1 AND t0.type IN ('avatar');

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nick_name AS nick_name_3,
  t0.notes AS notes_4,
  t0.country_code AS country_code_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.confirmation_code AS confirmation_code_8,
  t0.smsc_code AS smsc_code_9,
  t0.enabled AS enabled_10,
  t0.trusted AS trusted_11,
  t0.credits AS credits_12,
  t0.currency_code AS currency_code_13,
  t0.full_registered AS full_registered_14,
  t0.post_registration_step AS post_registration_step_15,
  t0.created AS created_16,
  t0.updated AS updated_17,
  t0.balance_low_notified_at AS balance_low_notified_at_18,
  t0.ban AS ban_19,
  t0.city_id AS city_id_20,
  t22.id AS id_21,
  t22.path AS path_23,
  t22.user_id AS user_id_24,
  t25.account_id AS account_id_26,
  t0.type
FROM
  user t0
  LEFT JOIN user_media_files t22 ON t22.user_id = t0.id
  LEFT JOIN account_offer_bar_hidden t25 ON t25.account_id = t0.id
WHERE
  t0.id = ?
  AND t0.type IN ('advertiser', 'customer')

SELECT t0.id AS id_1, t0.email AS email_2, t0.nick_name AS nick_name_3, t0.notes AS notes_4, t0.country_code AS country_code_5, t0.roles AS roles_6, t0.password AS password_7, t0.confirmation_code AS confirmation_code_8, t0.smsc_code AS smsc_code_9, t0.enabled AS enabled_10, t0.trusted AS trusted_11, t0.credits AS credits_12, t0.currency_code AS currency_code_13, t0.full_registered AS full_registered_14, t0.post_registration_step AS post_registration_step_15, t0.created AS created_16, t0.updated AS updated_17, t0.balance_low_notified_at AS balance_low_notified_at_18, t0.ban AS ban_19, t0.city_id AS city_id_20, t22.id AS id_21, t22.path AS path_23, t22.user_id AS user_id_24, t25.account_id AS account_id_26, t0.type FROM user t0 LEFT JOIN user_media_files t22 ON t22.user_id = t0.id LEFT JOIN account_offer_bar_hidden t25 ON t25.account_id = t0.id WHERE t0.id = 1 AND t0.type IN ('advertiser', 'customer');

SELECT
  p0_.id AS id_0,
  p0_.is_dummy AS is_dummy_1,
  p0_.uri_identity AS uri_identity_2,
  p0_.name AS name_3,
  p0_.description AS description_4,
  p0_.client_types AS client_types_5,
  p0_.phone_number AS phone_number_6,
  p0_.is_masseur AS is_masseur_7,
  p0_.extra_charge AS extra_charge_8,
  p0_.prepayment AS prepayment_9,
  p0_.prepayment_amount AS prepayment_amount_10,
  p0_.prepayment_comment AS prepayment_comment_11,
  p0_.is_approved AS is_approved_12,
  p0_.moderation_status AS moderation_status_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15,
  p0_.inactivated_at AS inactivated_at_16,
  p0_.seo AS seo_17,
  p0_.delete_mode AS delete_mode_18,
  p0_.deleted_at AS deleted_at_19,
  p0_.person_gender AS person_gender_20,
  p0_.person_age AS person_age_21,
  p0_.person_height AS person_height_22,
  p0_.person_weight AS person_weight_23,
  p0_.person_breast_size AS person_breast_size_24,
  p0_.person_breast_type AS person_breast_type_25,
  p0_.person_cloth_size AS person_cloth_size_26,
  p0_.person_shoes_size AS person_shoes_size_27,
  p0_.person_body_type AS person_body_type_28,
  p0_.person_hair_color AS person_hair_color_29,
  p0_.person_private_haircut AS person_private_haircut_30,
  p0_.person_nationality AS person_nationality_31,
  p0_.person_appearance AS person_appearance_32,
  p0_.person_has_tattoo AS person_has_tattoo_33,
  p0_.person_has_piercing AS person_has_piercing_34,
  p0_.messengers_telegram AS messengers_telegram_35,
  p0_.messengers_whatsapp AS messengers_whatsapp_36,
  p0_.messengers_telegram_username AS messengers_telegram_username_37,
  p0_.call_time_from AS call_time_from_38,
  p0_.call_time_to AS call_time_to_39,
  p0_.call_answering_to AS call_answering_to_40,
  p0_.client_min_age AS client_min_age_41,
  p0_.client_max_age AS client_max_age_42,
  p0_.apartments_one_hour_price AS apartments_one_hour_price_43,
  p0_.apartments_two_hours_price AS apartments_two_hours_price_44,
  p0_.apartments_night_price AS apartments_night_price_45,
  p0_.take_out_one_hour_price AS take_out_one_hour_price_46,
  p0_.take_out_two_hours_price AS take_out_two_hours_price_47,
  p0_.take_out_night_price AS take_out_night_price_48,
  p0_.take_out_locations AS take_out_locations_49,
  p0_.express_provided AS express_provided_50,
  p0_.express_price AS express_price_51,
  p0_.car_provided AS car_provided_52,
  p0_.map_latitude AS map_latitude_53,
  p0_.map_longitude AS map_longitude_54,
  p0_.user_id AS user_id_55,
  p0_.city_id AS city_id_56,
  p0_.primary_station_id AS primary_station_id_57,
  p0_.saloon_id AS saloon_id_58
FROM
  profiles p0_
WHERE
  (
    p0_.id IN (?, ?, ?)
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  FIELD(p0_.id, ?, ?, ?) ASC

SELECT p0_.id AS id_0, p0_.is_dummy AS is_dummy_1, p0_.uri_identity AS uri_identity_2, p0_.name AS name_3, p0_.description AS description_4, p0_.client_types AS client_types_5, p0_.phone_number AS phone_number_6, p0_.is_masseur AS is_masseur_7, p0_.extra_charge AS extra_charge_8, p0_.prepayment AS prepayment_9, p0_.prepayment_amount AS prepayment_amount_10, p0_.prepayment_comment AS prepayment_comment_11, p0_.is_approved AS is_approved_12, p0_.moderation_status AS moderation_status_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.inactivated_at AS inactivated_at_16, p0_.seo AS seo_17, p0_.delete_mode AS delete_mode_18, p0_.deleted_at AS deleted_at_19, p0_.person_gender AS person_gender_20, p0_.person_age AS person_age_21, p0_.person_height AS person_height_22, p0_.person_weight AS person_weight_23, p0_.person_breast_size AS person_breast_size_24, p0_.person_breast_type AS person_breast_type_25, p0_.person_cloth_size AS person_cloth_size_26, p0_.person_shoes_size AS person_shoes_size_27, p0_.person_body_type AS person_body_type_28, p0_.person_hair_color AS person_hair_color_29, p0_.person_private_haircut AS person_private_haircut_30, p0_.person_nationality AS person_nationality_31, p0_.person_appearance AS person_appearance_32, p0_.person_has_tattoo AS person_has_tattoo_33, p0_.person_has_piercing AS person_has_piercing_34, p0_.messengers_telegram AS messengers_telegram_35, p0_.messengers_whatsapp AS messengers_whatsapp_36, p0_.messengers_telegram_username AS messengers_telegram_username_37, p0_.call_time_from AS call_time_from_38, p0_.call_time_to AS call_time_to_39, p0_.call_answering_to AS call_answering_to_40, p0_.client_min_age AS client_min_age_41, p0_.client_max_age AS client_max_age_42, p0_.apartments_one_hour_price AS apartments_one_hour_price_43, p0_.apartments_two_hours_price AS apartments_two_hours_price_44, p0_.apartments_night_price AS apartments_night_price_45, p0_.take_out_one_hour_price AS take_out_one_hour_price_46, p0_.take_out_two_hours_price AS take_out_two_hours_price_47, p0_.take_out_night_price AS take_out_night_price_48, p0_.take_out_locations AS take_out_locations_49, p0_.express_provided AS express_provided_50, p0_.express_price AS express_price_51, p0_.car_provided AS car_provided_52, p0_.map_latitude AS map_latitude_53, p0_.map_longitude AS map_longitude_54, p0_.user_id AS user_id_55, p0_.city_id AS city_id_56, p0_.primary_station_id AS primary_station_id_57, p0_.saloon_id AS saloon_id_58 FROM profiles p0_ WHERE (p0_.id IN (1, 2, 3)) AND (p0_.deleted_at IS NULL) ORDER BY FIELD(p0_.id, 1, 2, 3) ASC;

SELECT
  p0_.id AS id_0,
  p0_.uri AS uri_1,
  p0_.top_html AS top_html_2,
  p0_.bottom_html AS bottom_html_3,
  p0_.meta_title AS meta_title_4,
  p0_.meta_description AS meta_description_5,
  p0_.meta_keywords AS meta_keywords_6,
  p0_.page_heading AS page_heading_7,
  p0_.last_modified AS last_modified_8,
  p0_.city_id AS city_id_9
FROM
  page_seo_texts p0_
WHERE
  p0_.uri = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.uri AS uri_1, p0_.top_html AS top_html_2, p0_.bottom_html AS bottom_html_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.page_heading AS page_heading_7, p0_.last_modified AS last_modified_8, p0_.city_id AS city_id_9 FROM page_seo_texts p0_ WHERE p0_.uri = '/profile_ctr/increase-shows/' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.price_amount AS price_amount_2,
  t0.currency AS currency_3,
  t0.duration AS duration_4,
  t0.enabled AS enabled_5,
  t0.city_price_category AS city_price_category_6,
  t0.dynamic_price_matrix AS dynamic_price_matrix_7,
  t0.city_id AS city_id_8,
  t0.placement_type
FROM
  paid_service_prices t0
WHERE
  t0.id = ?
  AND t0.placement_type IN (
    'standard_saloon', 'vip_saloon',
    'ultra_vip_saloon', 'standard_masseur',
    'vip_masseur', 'ultra_vip_masseur',
    'standard_profile', 'vip_profile',
    'ultra_vip_profile', 'top_profile',
    'placement_hiding'
  )

SELECT t0.id AS id_1, t0.price_amount AS price_amount_2, t0.currency AS currency_3, t0.duration AS duration_4, t0.enabled AS enabled_5, t0.city_price_category AS city_price_category_6, t0.dynamic_price_matrix AS dynamic_price_matrix_7, t0.city_id AS city_id_8, t0.placement_type FROM paid_service_prices t0 WHERE t0.id = 23 AND t0.placement_type IN ('standard_saloon', 'vip_saloon', 'ultra_vip_saloon', 'standard_masseur', 'vip_masseur', 'ultra_vip_masseur', 'standard_profile', 'vip_profile', 'ultra_vip_profile', 'top_profile', 'placement_hiding');