|
| 0 | SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = '13ebb0f5c10a478796dba488da1e6a48') LIMIT 1; |
| 1 | SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'alupka') LIMIT 1; |
| 2 | SELECT `streets`.* FROM `streets` WHERE (`streets`.`url` = 'lenina-street') AND (`streets`.`city_id` = 9800) AND (`streets`.`active` = 1) LIMIT 1; |
| 3 | SELECT * FROM ws_menus WHERE LOWER(url) = "search"
AND parent_id IS NULL
AND (country_id = 0 OR country_id IS NULL)
AND (site_id = 16 OR site_id IS NULL)
ORDER BY country_id DESC, site_id DESC LIMIT 1; |
| 4 | SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "tfi4ova6osl5b3r6j0d5bo3nef" ORDER BY ctime DESC; |
| 5 | SELECT `ws_config`.* FROM `ws_config` WHERE (`ws_config`.`code` = 'reservation_percent') AND (`ws_config`.`site_id` IS NULL OR `ws_config`.`site_id` = '16') LIMIT 1; |
| 6 | SELECT estate_ad.score_info, estate_ad.name_en, estate_ad.description_en, estate_ad.id, estate_ad.adress_en, 2 as currency, ((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END) / 41.547) as price_usd, estate_ad.no_reservation, estate_ad.city_public_paused, estate_ad.lat, estate_ad.lng, estate_ad.city_id, estate_ad.country_id, estate_ad.rooms, estate_ad.images, estate_ad.type_id, estate_ad.qty_comments, estate_ad.comments_score, estate_ad.can_low_price, estate_ad.sleeping, estate_ad.city_hot_paused, estate_ad.city_hot_main_paused, estate_ad.end_hot_2, estate_ad.end_hot_main, estate_ad.end_public, estate_ad.end_hot, estate_ad.daily_fee_paid, estate_ad.recommend, estate_ad.reserv, estate_ad.partner_id, estate_ad.customer_id FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9800 AND estate_ad.partner_id IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870) AND estate_ad.street_id IN (51486) ORDER BY estate_ad.daily_fee_paid DESC, estate_ad.daily_fee_time ASC, estate_ad.response_rate + 0 ASC, estate_ad.id ASC LIMIT 0,26; |
| 7 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'smoking') LIMIT 1; |
| 8 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'children') LIMIT 1; |
| 9 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'animals') LIMIT 1; |
| 10 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'activity') LIMIT 1; |
| 11 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'documents') LIMIT 1; |
| 12 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'kamin') LIMIT 1; |
| 13 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'sauna') LIMIT 1; |
| 14 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'dvd') LIMIT 1; |
| 15 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'tv') LIMIT 1; |
| 16 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Wi-Fi') LIMIT 1; |
| 17 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'plita') LIMIT 1; |
| 18 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'jacoozee') LIMIT 1; |
| 19 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'dush') LIMIT 1; |
| 20 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'boiler') LIMIT 1; |
| 21 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'utyug') LIMIT 1; |
| 22 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'plasma') LIMIT 1; |
| 23 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'fridge') LIMIT 1; |
| 24 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'microwave') LIMIT 1; |
| 25 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'electro_chainik') LIMIT 1; |
| 26 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'posuda') LIMIT 1; |
| 27 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'vanna') LIMIT 1; |
| 28 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'stiral_machine') LIMIT 1; |
| 29 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'cofevarka') LIMIT 1; |
| 30 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'fen') LIMIT 1; |
| 31 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'home_teatr') LIMIT 1; |
| 32 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'condicioneriny') LIMIT 1; |
| 33 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'cable_tv') LIMIT 1; |
| 34 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'balkon') LIMIT 1; |
| 35 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'lodjiya') LIMIT 1; |
| 36 | DESC city_pre_search; |
| 37 | SELECT * FROM city_pre_search
WHERE (city_id = 9800 OR city_id IS NULL) AND site_id = 16 AND `public` = 1 AND (url != "streets" OR url IS NULL) AND district_id IS NULL AND districts = "" AND micro_district_id IS NULL AND metro_id IS NULL AND sight_id IS NULL AND county_id IS NULL AND rooms IS NULL AND type_id_24 = 0 AND type_id_25 = 0 AND type_id_27 = 0 AND type_id_30 = 0 AND `smoking` = 0 AND `children` = 0 AND `animals` = 0 AND `activity` = 0 AND `documents` = 0 AND `kamin` = 0 AND `sauna` = 0 AND `dvd` = 0 AND `tv` = 0 AND `wifi` = 0 AND `plita` = 0 AND `jacoozee` = 0 AND `dush` = 0 AND `boiler` = 0 AND `utyug` = 0 AND `plasma` = 0 AND `fridge` = 0 AND `microwave` = 0 AND `electro_chainik` = 0 AND `posuda` = 0 AND `vanna` = 0 AND `stiral_machine` = 0 AND `cofevarka` = 0 AND `fen` = 0 AND `home_teatr` = 0 AND `condicioner` = 0 AND `cable_tv` = 0 AND `balkon_lodjiya` = 0 AND `near_the_metro` = 0 AND `near_the_train` = 0 AND `on_weekend_selected` = 0 AND `ny_prices_selected` = 0 AND `on_may_holidays_selected` = 0 AND price_min = 0 AND min_price = 0 AND price_max = 0 AND max_price = 0 AND (ad_name = "" OR ad_name IS NULL) AND (ad_description = "" OR ad_description IS NULL) AND (sleeping_min = 0 OR sleeping_min IS NULL OR sleeping_min = "") AND (county = 0) AND (district = 0) AND (micro_district = 0) AND (metro = 0) AND (street = 1 OR street_id = 51486) AND (sight = 0) ORDER BY IF (city_id = 9800, 0, 1) ASC LIMIT 2; |
| 38 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Квартиры посуточно') LIMIT 1; |
| 39 | SELECT cities.*, ST_AsText(location) as location FROM cities WHERE city_id = 9800; |
| 40 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Укажите город') LIMIT 1; |
| 41 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Заезд') LIMIT 1; |
| 42 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Комнаты и гости') LIMIT 1; |
| 43 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Тип жилья') LIMIT 1; |
| 44 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Цена') LIMIT 1; |
| 45 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'от') LIMIT 1; |
| 46 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'до') LIMIT 1; |
| 47 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Расположение') LIMIT 1; |
| 48 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Другие фильтры') LIMIT 1; |
| 49 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Очистить') LIMIT 1; |
| 50 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Мгновенные') LIMIT 1; |
| 51 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Город') LIMIT 1; |
| 52 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'например') LIMIT 1; |
| 53 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Гости') LIMIT 1; |
| 54 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'По скорости ответа') LIMIT 1; |
| 55 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'по рейтингу') LIMIT 1; |
| 56 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'сначала с отзывами') LIMIT 1; |
| 57 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'сначала мгновенные') LIMIT 1; |
| 58 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'безопасное бронирование') LIMIT 1; |
| 59 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'сначала дешевле') LIMIT 1; |
| 60 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'сначала дороже') LIMIT 1; |
| 61 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'по скорости ответа') LIMIT 1; |
| 62 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Забронировать мгновенно') LIMIT 1; |
| 63 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'ad_type_id_30') LIMIT 1; |
| 64 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'комната') LIMIT 1; |
| 65 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'комнаты') LIMIT 1; |
| 66 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'комнат') LIMIT 1; |
| 67 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'ad_type_id_25') LIMIT 1; |
| 68 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'ad_type_id_24') LIMIT 1; |
| 69 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Показать еще') LIMIT 1; |
| 70 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'объект') LIMIT 1; |
| 71 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'объекта') LIMIT 1; |
| 72 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'объектов') LIMIT 1; |
| 73 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Искать в радиусе') LIMIT 1; |
| 74 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'км') LIMIT 1; |
| 75 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'предложение') LIMIT 1; |
| 76 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'предложения') LIMIT 1; |
| 77 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'предложений') LIMIT 1; |
| 78 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Списком') LIMIT 1; |
| 79 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'На карте') LIMIT 1; |
| 80 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Показать/скрыть меню') LIMIT 1; |
| 81 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Вход') LIMIT 1; |
| 82 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Весь сайт') LIMIT 1; |
| 83 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Сдать жилье') LIMIT 1; |
| 84 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Все права защищены') LIMIT 1; |
| 85 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Правила и условия') LIMIT 1; |
| 86 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Политика конфиденциальности') LIMIT 1; |
| 87 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Социальные сети') LIMIT 1; |
| 88 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Партнерская программа') LIMIT 1; |
Social networks