select * from indexation_list where id = "4" limit 1 INSERT INTO `indexation_control` (`type`, `server`, `action`, `status`, `start_time`, `ad_object`, `ad_check`, `last_action_ad`, `list_id`) VALUES ("0", "index-ad", "0", "1", "1500582825", "0", "0", "1500582825", "4") SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "12" update proxy_list set use_time = "1500582826", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582826' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "159032389" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("159032389", "https://gelendzhik.cian.ru/rent/flat/159032389/", "cian.ru", "1500582826", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "14" update proxy_list set use_time = "1500582826", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "14" UPDATE indexed_ad SET `status`='3' WHERE id ='9113' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9113' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 INSERT INTO users (phone, status, salt) VALUES ("78612123551", "0", "wsets9dxpq") INSERT INTO sms_queuing (phone, time_add) VALUES ("78612123551", "1500582826") SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 INSERT INTO phone (phone, status, time, user) VALUES (78612123551, 0, 1500582826, 6078) SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Котовского" and coordinates = "38.065383 44.551853" LIMIT 1 select id from number where city = "59" and `api-name` = "улица Котовского, 11" and coordinates = "38.065859 44.551249" LIMIT 1 select id from street where `api-name` = "улица Котовского, 11" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "547", "0", "улица Котовского, 11", "улица Котовского, 11", "ulitca-kotovskogo-11", "38.065859 44.551249") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.065859','44.551249','0','0','0','547','6164','улица Котовского, 11','[]','59','1','4','1500','1','1','5','5','30','20','10','2','2','Код объекта: 6730. Квартира общей площадью 35 кв.м. на пятом этаже пятиэтажного дома. В комнате два раскладных дивана, тумба с телевизором, сплит система, балкон застекленный. На кухне кухонный гарнитур, вся техника имеется. До моря 5 минут ходьбы, рядом Полевой рынок, магазины, остановка рядом.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8208", "3f7e086d3638b31fa1b3e85f03f41702", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582827", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulitca-kotovskogo" where `id` = "8208" limit 1 UPDATE object SET status='1', ad_code = '3f7e086d3638b31fa1b3e85f03f41702' WHERE id='8208' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8208' WHERE id='9113' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582827' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582827' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358789" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158358789", "https://gelendzhik.cian.ru/rent/flat/158358789/", "cian.ru", "1500582827", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "15" update proxy_list set use_time = "1500582827", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "15" UPDATE indexed_ad SET `status`='3' WHERE id ='9114' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9114' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Ходенко" and coordinates = "38.091829 44.572295" LIMIT 1 select id from street where `api-name` = "улица Ходенко" and `city` = "59" limit 1 INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "улица Ходенко", "улица Ходенко","ulitca-khodenko","38.091829 44.572295") select id from number where city = "59" and `api-name` = "улица Ходенко, 32" and coordinates = "38.088155 44.575487" LIMIT 1 select id from street where `api-name` = "улица Ходенко, 32" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3004", "0", "улица Ходенко, 32", "улица Ходенко, 32", "ulitca-khodenko-32", "38.088155 44.575487") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.088155','44.575487','0','0','0','3004','6165','улица Ходенко, 32','[]','59','1','4','1500','1','2','2','2','54','25','10','2','2','Код объекта: 8166. Сдается в частном доме, на втором этаже, двухкомнатная квартира, отдельно кухня , сан.узел. Общ.пл 54 кв.м.. Все необходимое для проживания есть. На первом этаже проживают хозяева. Во дворе есть мангал, дворик. Парковка рядом с домом.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8209", "062decfe99e22173ce9d38de119b95df", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582828", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulitca-khodenko" where `id` = "8209" limit 1 UPDATE object SET status='1', ad_code = '062decfe99e22173ce9d38de119b95df' WHERE id='8209' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8209' WHERE id='9114' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582828' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582828' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472368" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157472368", "https://gelendzhik.cian.ru/rent/flat/157472368/", "cian.ru", "1500582828", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "11" update proxy_list set use_time = "1500582828", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE indexed_ad SET `status`='3' WHERE id ='9115' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9115' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Южная улица" and coordinates = "38.055815 44.550556" LIMIT 1 select id from street where `api-name` = "Южная улица" and `city` = "59" limit 1 INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "Южная улица", "Южная улица","iuzhnaya-ulitca","38.055815 44.550556") select id from number where city = "59" and `api-name` = "Южная улица, 2" and coordinates = "38.054989 44.549528" LIMIT 1 select id from street where `api-name` = "Южная улица, 2" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3005", "0", "Южная улица, 2", "Южная улица, 2", "iuzhnaya-ulitca-2", "38.054989 44.549528") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`passenger_elevator`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.054989','44.549528','0','0','0','3005','6166','Южная улица, 2','["микрорайон Толстый Мыс"]','59','1','4','2000','1','1','7','10','40','18','15','2','2','1','Код объекта: 7562. Однокомнатная квартира общей площадью 40 кв.м., находится на седьмом этаже, дести этажного нового дома. В комнате два раскладных дивана (четыре спальных места), телевизор, шкаф. На кухне кухонный гарнитур, газовая плита, обеденный стол, стулья. Все есть для комфортного проживания и отдыха. Застекленная лоджия, откуда открывается прекрасный вид на открытое море.ЦенаИюнь - 2000Июль - 2500Август - 3000','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8210", "054d6bc4443ec12781633a8d99ad7c0e", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582828", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-iuzhnaya-ulitca" where `id` = "8210" limit 1 UPDATE object SET status='1', ad_code = '054d6bc4443ec12781633a8d99ad7c0e' WHERE id='8210' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8210' WHERE id='9115' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582829' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582829' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157505717" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157505717", "https://gelendzhik.cian.ru/rent/flat/157505717/", "cian.ru", "1500582829", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "13" update proxy_list set use_time = "1500582829", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE indexed_ad SET `status`='3' WHERE id ='9116' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9116' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from dependent where city = "59" and `api-name` = "микрорайон Парус" and coordinates = "38.078282 44.547414" LIMIT 1 select id from number where city = "59" and `api-name` = "микрорайон Парус, 20" and coordinates = "38.077743 44.547164" LIMIT 1 select id from street where `api-name` = "микрорайон Парус, 20" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "0", "61", "микрорайон Парус, 20", "микрорайон Парус, 20", "mikrorajon-parus-20", "38.077743 44.547164") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.078282','44.547414','0','0','61','0','6167','микрорайон Парус, 20','["микрорайон Парус"]','59','1','4','2000','1','1','3','9','24','2','2','Код объекта: 8937. Небольшая однокомнатная квартира ( 3 спальных места). Есть вся необходимая мебель и быт.техника.Спутниковое ТВ (Триколор), сплит-система,теплые полы, Wi-Fi.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8211", "e09728134fd087aaf21893bb10d9232a", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582829", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-mikrorajon-parus" where `id` = "8211" limit 1 UPDATE object SET status='1', ad_code = 'e09728134fd087aaf21893bb10d9232a' WHERE id='8211' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8211' WHERE id='9116' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582829' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582829' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472404" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157472404", "https://gelendzhik.cian.ru/rent/flat/157472404/", "cian.ru", "1500582829", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "14" update proxy_list set use_time = "1500582830", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "14" UPDATE indexed_ad SET `status`='3' WHERE id ='9117' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9117' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Розы Люксембург" and coordinates = "38.088029 44.565546" LIMIT 1 select id from street where `api-name` = "улица Розы Люксембург" and `city` = "59" limit 1 INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "улица Розы Люксембург", "улица Розы Люксембург","ulitca-rozy-liuksemburg","38.088029 44.565546") select id from number where city = "59" and `api-name` = "улица Розы Люксембург, 30" and coordinates = "38.086116 44.566144" LIMIT 1 select id from street where `api-name` = "улица Розы Люксембург, 30" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3006", "0", "улица Розы Люксембург, 30", "улица Розы Люксембург, 30", "ulitca-rozy-liuksemburg-30", "38.086116 44.566144") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.086179','44.566002','0','0','0','3006','6168','улица Розы Люксембург, 30','[]','59','1','4','2000','1','1','3','5','45','2','2','Код объекта: 2393. 1-ком. квартиру, площадью 45 кв. м., на третьем этаже 5-ти этажного монолитного дома, желательно без животных. В квартире сделан евро ремонт, большая кухня: встроенный кухонный гарнитур, АО. Встроенная бытовая техника. Квартира полностью меблирована. В шаговой доступности продуктовый магазин, школа. Цены - 2000 р, июль - 2500 р., август - 3000 р.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8212", "9dc4fa052649a4813c0f5b94790bcbdf", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582830", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "14" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulitca-rozy-liuksemburg" where `id` = "8212" limit 1 UPDATE object SET status='1', ad_code = '9dc4fa052649a4813c0f5b94790bcbdf' WHERE id='8212' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8212' WHERE id='9117' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582830' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582830' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472420" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157472420", "https://gelendzhik.cian.ru/rent/flat/157472420/", "cian.ru", "1500582830", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "15" update proxy_list set use_time = "1500582831", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "15" UPDATE indexed_ad SET `status`='3' WHERE id ='9118' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9118' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Красная улица" and coordinates = "38.077662 44.574215" LIMIT 1 select id from street where `api-name` = "Красная улица" and `city` = "59" limit 1 INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "Красная улица", "Красная улица","krasnaya-ulitca","38.077662 44.574215") select id from number where city = "59" and `api-name` = "Красная улица, 29" and coordinates = "38.077007 44.574735" LIMIT 1 select id from street where `api-name` = "Красная улица, 29" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3007", "0", "Красная улица, 29", "Красная улица, 29", "krasnaya-ulitca-29", "38.077007 44.574735") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.077007','44.574735','0','0','0','3007','6169','Красная улица, 29','[]','59','1','4','2000','1','2','1','4','50','35','9','2','2','Код объекта: 7552. Просторная двухкомнатная квартира по ул Красной. Квартира на первом этаже пятиэтажного дома. Площадь 50 кв.м. Все необходимое для проживания есть (кровать двухспальная, диван раскладной, телевизор, холодильник, все новое). Хорошая детская площадка во дворе, рядом дельфинарий, дом культуры. https://gelendzhik./rent/flat//','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8213", "24bf0801e31e6b750f83e0c5bde55a92", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582831", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "15" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-krasnaya-ulitca" where `id` = "8213" limit 1 UPDATE object SET status='1', ad_code = '24bf0801e31e6b750f83e0c5bde55a92' WHERE id='8213' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8213' WHERE id='9118' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582831' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582831' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472322" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157472322", "https://gelendzhik.cian.ru/rent/flat/157472322/", "cian.ru", "1500582831", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "11" update proxy_list set use_time = "1500582831", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE indexed_ad SET `status`='3' WHERE id ='9119' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9119' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Красногвардейская улица" and coordinates = "38.067476 44.55299" LIMIT 1 select id from number where city = "59" and `api-name` = "Красногвардейская улица, 71" and coordinates = "38.063757 44.552714" LIMIT 1 select id from street where `api-name` = "Красногвардейская улица, 71" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "2863", "0", "Красногвардейская улица, 71", "Красногвардейская улица, 71", "krasnogvardejskaya-ulitca-71", "38.063757 44.552714") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`rent_rate_q`,`payment_rate_q`,`passenger_elevator`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.063757','44.552714','0','0','0','2863','6170','Красногвардейская улица, 71','[]','59','1','4','1800','1','1','8','8','49','2','2','1','Код объекта: 13323. АРЕНДА ПОСУТОЧНО1-комнатная квартира. Улица Крымская в Геленджике. Район - Толстый мыс. В квартире все новое. Полная комплектация. Есть все начиная от постельного белья, и, заканчивая столовыми приборами. В квартире есть Интернет. Цены:Май - 1800Июнь - 2500Июль - 3300Август - 3700Сентябрь - 2500В квартире 5 спальных мест. Осуществляется бронирование на майские праздники и летний период','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8214", "7d5243a96ee3ef7c89c41f1bcd21a9ab", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582832", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-krasnogvardejskaya-ulitca" where `id` = "8214" limit 1 UPDATE object SET status='1', ad_code = '7d5243a96ee3ef7c89c41f1bcd21a9ab' WHERE id='8214' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8214' WHERE id='9119' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582832' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582832' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157427666" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157427666", "https://gelendzhik.cian.ru/rent/flat/157427666/", "cian.ru", "1500582832", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "12" update proxy_list set use_time = "1500582832", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE indexed_ad SET `status`='3' WHERE id ='9120' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9120' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from dependent where city = "59" and `api-name` = "микрорайон Парус" and coordinates = "38.078282 44.547414" LIMIT 1 select id from number where city = "59" and `api-name` = "микрорайон Парус, 20" and coordinates = "38.077743 44.547164" LIMIT 1 INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`rent_rate_q`,`payment_rate_q`,`passenger_elevator`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.078282','44.547414','0','0','61','0','6167','микрорайон Парус, 20','["микрорайон Парус"]','59','1','4','2000','1','3','7','9','65','2','2','1','Код объекта: 5120. Сдается в аренду отличная мебелированная трех комнатная квартира в мкр.Парус. В квартире есть все необходимое для проживания. С/У раздельный, комнаты изолированные. Квартира 2х сторонняя. Уточнить все вопросы можете по телефону указанному в объявлении.Цена:Июнь-2000 р.Июль-2500 р.Август-3000 р.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8215", "cd4dc409d6041da580a555a9a095d8ce", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582832", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-mikrorajon-parus" where `id` = "8215" limit 1 UPDATE object SET status='1', ad_code = 'cd4dc409d6041da580a555a9a095d8ce' WHERE id='8215' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8215' WHERE id='9120' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582833' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582833' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358277" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158358277", "https://gelendzhik.cian.ru/rent/flat/158358277/", "cian.ru", "1500582833", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "13" update proxy_list set use_time = "1500582833", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE indexed_ad SET `status`='3' WHERE id ='9121' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9121' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Восточный переулок" and coordinates = "38.089987 44.556227" LIMIT 1 select id from street where `api-name` = "Восточный переулок" and `city` = "59" limit 1 INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "Восточный переулок", "Восточный переулок","vostochnyj-pereulok","38.089987 44.556227") select id from number where city = "59" and `api-name` = "Восточный переулок, 38В" and coordinates = "38.09279 44.559252" LIMIT 1 select id from street where `api-name` = "Восточный переулок, 38В" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3008", "0", "Восточный переулок, 38В", "Восточный переулок, 38В", "vostochnyj-pereulok-38v", "38.09279 44.559252") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.09279','44.559252','0','0','0','3008','6171','Восточный переулок, 38В','["5-й микрорайон"]','59','1','4','2200','1','1','3','6','48','36','6','2','2','Код объекта: 2191. Сдается комфортабельная однокомнатная квартира посуточно на лето2017 года. Расположена на третьем этаже 6-ти этажного здания. Имеется 4 спальных места, 2 сплит-системы, 2 телевизора, стиральная машина, утюг, посуда. Есть балкон. благоустроенная придомовая территория, детская площадка. Дом расположен неподалеку от набережной. Размещение от 5 суток, предоплата 10%. Стоимость в мае от 1500р./сутки, в июне от 2000р./сутки, в июле от 2500р./сутки, в августе от 3000р./сутки, в сентябре от 2000р./сутки.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8216", "4e2310f6f963a220dce561c505916afc", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582833", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-vostochnyj-pereulok" where `id` = "8216" limit 1 UPDATE object SET status='1', ad_code = '4e2310f6f963a220dce561c505916afc' WHERE id='8216' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8216' WHERE id='9121' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582833' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582833' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358473" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158358473", "https://gelendzhik.cian.ru/rent/flat/158358473/", "cian.ru", "1500582833", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "14" update proxy_list set use_time = "1500582833", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "14" UPDATE indexed_ad SET `status`='3' WHERE id ='9122' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9122' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Южная улица" and coordinates = "38.055815 44.550556" LIMIT 1 select id from number where city = "59" and `api-name` = "Южная улица, 9" and coordinates = "38.055016 44.550151" LIMIT 1 select id from street where `api-name` = "Южная улица, 9" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3005", "0", "Южная улица, 9", "Южная улица, 9", "iuzhnaya-ulitca-9", "38.055016 44.550151") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.055016','44.550151','0','0','0','3005','6172','Южная улица, 9','["микрорайон Толстый Мыс"]','59','1','4','2500','1','1','1','4','50','27','15','2','2','Код объекта: 594. Сдаётся посуточно новая комфортная 1-к квартира, расположенная на 1-м этаже, 4-х этажного малоквартирного дома элитной постройки. Общей площадью 50 кв.м., спальня 27 кв.м., кухня -15 кв.м. Квартира находится на Толстом мысу, в районе отеля Кемпински. До моря 100 метров. Квартира полностью меблирована: встроенная кухня, кондиционер, холодильник, стиральная машинка автомат, спутниковое ТВ, постельные и кухонные принадлежности, (в комнате двухспальная кровать, на кухне- двухспальный диван. . Вода холодная, горячая постоянно. Большая парковка на закрытой придомовой территории. Мангал. Беседка, детская игровая площадка. Красивые клумбы.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8217", "31ab2e3690e9389cfbb445370220574f", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582834", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-iuzhnaya-ulitca" where `id` = "8217" limit 1 UPDATE object SET status='1', ad_code = '31ab2e3690e9389cfbb445370220574f' WHERE id='8217' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8217' WHERE id='9122' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582834' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582834' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472409" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157472409", "https://gelendzhik.cian.ru/rent/flat/157472409/", "cian.ru", "1500582834", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "15" update proxy_list set use_time = "1500582834", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "15" UPDATE indexed_ad SET `status`='3' WHERE id ='9123' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9123' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Полевая улица" and coordinates = "38.068428 44.550883" LIMIT 1 select id from number where city = "59" and `api-name` = "Полевая улица, 24" and coordinates = "38.066739 44.551371" LIMIT 1 select id from street where `api-name` = "Полевая улица, 24" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "648", "0", "Полевая улица, 24", "Полевая улица, 24", "polevaya-ulitca-24", "38.066739 44.551371") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.066739','44.551371','0','0','0','648','6173','Полевая улица, 24','[]','59','1','4','2500','1','1','4','5','32','20','6.5','2','2','Код объекта: 242. Сдается однокомнатная квартира на четвертом этаже пятиэтажного жилого дома. Общая площадь 32 кв.м. Коммуникации центральные. Балкон застеклен. Установлена сплит - система. Квартира укомплектована мебелью и бытовой техникой. Вся инфраструктура в шаговой доступности. До моря 5 минут прогулочным шагом.Цены:июнь-2500 р.июль-3500 р.август-3500 р.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8218", "0201d1bc64e976637f94e2d234222226", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582834", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-polevaya-ulitca" where `id` = "8218" limit 1 UPDATE object SET status='1', ad_code = '0201d1bc64e976637f94e2d234222226' WHERE id='8218' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8218' WHERE id='9123' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582835' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582835' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158360044" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158360044", "https://gelendzhik.cian.ru/rent/flat/158360044/", "cian.ru", "1500582835", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "11" update proxy_list set use_time = "1500582835", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE indexed_ad SET `status`='3' WHERE id ='9124' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9124' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Грибоедова" and coordinates = "38.074662 44.550787" LIMIT 1 select id from number where city = "59" and `api-name` = "улица Грибоедова, 48" and coordinates = "38.073602 44.550408" LIMIT 1 select id from street where `api-name` = "улица Грибоедова, 48" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "2764", "0", "улица Грибоедова, 48", "улица Грибоедова, 48", "ulitca-griboedova-48", "38.073602 44.550408") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.073602','44.550408','0','0','0','2764','6174','улица Грибоедова, 48','[]','59','1','4','2500','1','2','4','5','50.7','30','8','2','2','Код объекта: 11624. Двухкомнтаная квартира 50квадратных метров на 4 этаже 5 этажного тёплого кирпичного дома. Ремонт хороший,мебель в отличном состоянии, сантехника, сплит система, стиральная машинка.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8219", "7f51d4190d32a9c9502fe1cc656d4f4e", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582835", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulitca-griboedova" where `id` = "8219" limit 1 UPDATE object SET status='1', ad_code = '7f51d4190d32a9c9502fe1cc656d4f4e' WHERE id='8219' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8219' WHERE id='9124' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582835' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582835' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472376" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157472376", "https://gelendzhik.cian.ru/rent/flat/157472376/", "cian.ru", "1500582835", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "12" update proxy_list set use_time = "1500582835", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE indexed_ad SET `status`='3' WHERE id ='9125' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9125' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Красногвардейская улица" and coordinates = "38.067476 44.55299" LIMIT 1 select id from number where city = "59" and `api-name` = "Красногвардейская улица, 71" and coordinates = "38.063757 44.552714" LIMIT 1 INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`passenger_elevator`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.063757','44.552714','0','0','0','2863','6170','Красногвардейская улица, 71','[]','59','1','4','2500','1','1','6','8','46.4','20','16','2','2','1','Код объекта: 13519. Сдается комфортная 2-комнатная квартира на Толстом мысе в Геленджике. До моря - 10 минут. В шаговой доступности набережная, зоны отдыха, набережная. Квартира полностью укомплектована. Есть вся мебель, техника. Хороший ремонт. Идеальный вариант для семейного отдыха. Цены:май- 2500июнь-3500июль-4200август - 4500','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8220", "98c78cfd2cd0ece8f31b18856497cb8f", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582836", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-krasnogvardejskaya-ulitca" where `id` = "8220" limit 1 UPDATE object SET status='1', ad_code = '98c78cfd2cd0ece8f31b18856497cb8f' WHERE id='8220' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8220' WHERE id='9125' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582836' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582836' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472411" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157472411", "https://gelendzhik.cian.ru/rent/flat/157472411/", "cian.ru", "1500582836", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "14" update proxy_list set use_time = "1500582836", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "14" UPDATE indexed_ad SET `status`='3' WHERE id ='9126' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9126' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Крымская улица" and coordinates = "38.06205 44.550858" LIMIT 1 select id from number where city = "59" and `api-name` = "Крымская улица, 9" and coordinates = "38.062921 44.551699" LIMIT 1 select id from street where `api-name` = "Крымская улица, 9" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "612", "0", "Крымская улица, 9", "Крымская улица, 9", "krymskaya-ulitca-9", "38.062921 44.551699") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.062921','44.551699','0','0','0','612','6175','Крымская улица, 9','[]','59','1','4','3000','1','1','1','10','40','18','9','2','2','Код объекта: 7217. В новом доме, в престижном районе Геленджика, сдается новая квартира общей площадью 40 кв.м. В квартире все имеется для комфортного отдыха.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8221", "2bc7f2b65c0e2080fdcadf649f766aeb", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582836", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-krymskaya-ulitca" where `id` = "8221" limit 1 UPDATE object SET status='1', ad_code = '2bc7f2b65c0e2080fdcadf649f766aeb' WHERE id='8221' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8221' WHERE id='9126' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582837' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582837' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359005" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158359005", "https://gelendzhik.cian.ru/rent/flat/158359005/", "cian.ru", "1500582837", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "13" update proxy_list set use_time = "1500582837", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE indexed_ad SET `status`='3' WHERE id ='9127' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9127' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Полевая улица" and coordinates = "38.068428 44.550883" LIMIT 1 select id from number where city = "59" and `api-name` = "Полевая улица, 29" and coordinates = "38.070099 44.551018" LIMIT 1 select id from street where `api-name` = "Полевая улица, 29" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "648", "0", "Полевая улица, 29", "Полевая улица, 29", "polevaya-ulitca-29", "38.070099 44.551018") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.070099','44.551018','0','0','0','648','6176','Полевая улица, 29','[]','59','1','4','3000','1','1','3','5','40','20','10','2','2','Код объекта: 7202. Просторная , уютная квартира на третьем этаже, пяти этажного жилого дома с видом на море. Все имеется для отдыха. Море в 5 минутах ходьбы.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8222", "3ceb32e0964b2a2f41b25017e5dc0410", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582837", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-polevaya-ulitca" where `id` = "8222" limit 1 UPDATE object SET status='1', ad_code = '3ceb32e0964b2a2f41b25017e5dc0410' WHERE id='8222' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8222' WHERE id='9127' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582837' WHERE id = '57' LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 UPDATE indexation_control SET count_cycles = count_cycles + 1 WHERE id = '57' LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "15" update proxy_list set use_time = "1500582868", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "15" UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "159032389" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358789" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472368" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157505717" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472404" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472420" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472322" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157427666" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358277" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358473" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472409" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158360044" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472376" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472411" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359005" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582868' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358619" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158358619", "https://gelendzhik.cian.ru/rent/flat/158358619/", "cian.ru", "1500582868", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "12" update proxy_list set use_time = "1500582869", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE indexed_ad SET `status`='3' WHERE id ='9128' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9128' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Малоземельская улица" and coordinates = "38.018347 44.568963" LIMIT 1 select id from number where city = "59" and `api-name` = "Малоземельская улица, 2" and coordinates = "38.019577 44.568776" LIMIT 1 select id from street where `api-name` = "Малоземельская улица, 2" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "2723", "0", "Малоземельская улица, 2", "Малоземельская улица, 2", "malozemelskaya-ulitca-2", "38.019577 44.568776") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.019577','44.568776','0','0','0','2723','6177','Малоземельская улица, 2','[]','59','1','4','3000','1','3','1','4','96','54','12','2','2','Код объекта: 1749. Квартира в новом доме, удобный подъезд, есть парковочные места. Расположена на 1 этаже 4-х этажного здания. Автономное отопление и водоснабжение, мебель, бытовая техника. Совмещенный санузел - душ. Просторные комнаты, большой общий балкон. Экологически чистый район - Тонкий мыс.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8223", "2cf180e4207a491733d8f9dd5cf7cc46", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582869", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-malozemelskaya-ulitca" where `id` = "8223" limit 1 UPDATE object SET status='1', ad_code = '2cf180e4207a491733d8f9dd5cf7cc46' WHERE id='8223' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8223' WHERE id='9128' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582869' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582869' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157976836" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157976836", "https://gelendzhik.cian.ru/rent/flat/157976836/", "cian.ru", "1500582869", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "11" update proxy_list set use_time = "1500582870", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE indexed_ad SET `status`='3' WHERE id ='9129' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9129' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from dependent where city = "59" and `api-name` = "микрорайон Парус" and coordinates = "38.078282 44.547414" LIMIT 1 select id from number where city = "59" and `api-name` = "микрорайон Парус, 24" and coordinates = "38.076108 44.548975" LIMIT 1 select id from street where `api-name` = "микрорайон Парус, 24" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "0", "61", "микрорайон Парус, 24", "микрорайон Парус, 24", "mikrorajon-parus-24", "38.076108 44.548975") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.076108','44.548975','0','0','61','0','6178','микрорайон Парус, 24','["микрорайон Парус"]','59','1','4','3000','1','3','2','5','60','2','2','Код объекта: 1153. В квартире сделан хороший ремонт. 2 изолированые комнаты и кухня-гостиная. Все оборудованно мебелью и техникой. Есть весь необходимый набор кухонной посуды. Имеется комплект полотенец и постельного белья. Есть спутниковое телевидение и Интернет. Ванная комната и туалет совмещены. Есть накопитель воды. Идет бронирование на летний период. Цены: с 1 по 15 июня - 3000 р, с 15 по 30 июня - 3800 р., июль - 4500 р., август - 5500 р. Бронирование от 5 суток','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8224", "730b88d682d5bf48020d2ec329b0ee4f", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582870", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-mikrorajon-parus" where `id` = "8224" limit 1 UPDATE object SET status='1', ad_code = '730b88d682d5bf48020d2ec329b0ee4f' WHERE id='8224' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8224' WHERE id='9129' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582870' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582870' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472370" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157472370", "https://gelendzhik.cian.ru/rent/flat/157472370/", "cian.ru", "1500582870", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "14" update proxy_list set use_time = "1500582870", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "14" UPDATE indexed_ad SET `status`='3' WHERE id ='9130' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9130' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Ульяновская улица" and coordinates = "38.069048 44.552072" LIMIT 1 select id from number where city = "59" and `api-name` = "Ульяновская улица, 23" and coordinates = "38.068239 44.551866" LIMIT 1 INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`passenger_elevator`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.068239','44.551866','0','0','0','1123','1800','Ульяновская улица, 23','[]','59','1','4','3000','1','3','9','9','70','50','11','2','2','1','Код объекта: 8869. Идеальный вариант для летнего отдыха. Хорошая квартира в одном из лучших спальных районов Геленджика. До моря - 7 минут. Рядом набережная, зоны отдыха, рынок, аптека, супермаркеты. В квартире сделан ремонт, все комнаты просторные, изолированные. Сан.узел раздельный. В квартире есть все необходмое для комфортного проживания. С водой в районе проблем нет. Идет активное бронирование на летний период! https://gelendzhik./rent/flat//','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8225", "db342a95428bef042303548f4bcd063f", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582871", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulyanovskaya-ulitca" where `id` = "8225" limit 1 UPDATE object SET status='1', ad_code = 'db342a95428bef042303548f4bcd063f' WHERE id='8225' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8225' WHERE id='9130' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582871' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582871' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359054" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158359054", "https://gelendzhik.cian.ru/rent/flat/158359054/", "cian.ru", "1500582871", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "13" update proxy_list set use_time = "1500582871", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE indexed_ad SET `status`='3' WHERE id ='9131' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9131' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Генерала Раевского" and coordinates = "38.086628 44.57706" LIMIT 1 select id from street where `api-name` = "улица Генерала Раевского" and `city` = "59" limit 1 INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "улица Генерала Раевского", "улица Генерала Раевского","ulitca-generala-raevskogo","38.086628 44.57706") select id from number where city = "59" and `api-name` = "улица Генерала Раевского, 6" and coordinates = "38.088236 44.576142" LIMIT 1 select id from street where `api-name` = "улица Генерала Раевского, 6" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3009", "0", "улица Генерала Раевского, 6", "улица Генерала Раевского, 6", "ulitca-generala-raevskogo-6", "38.088236 44.576142") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.088236','44.576142','0','0','0','3009','6179','улица Генерала Раевского, 6','[]','59','1','4','3000','1','1','2','2','43','20','10','2','2','Код объекта: 2278. Сдается однокомнатная квартира общей площадью 43 кв.м. В тихом, спокойном районе. До моря - 15 минут. В квартире есть вся необходимая мебель, техника. Бесперебойные коммуникации. Квартира сдается на 3-х и 4-х человек. В стоимость включены коммунальные услуги.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8226", "c36bf4342cb2fe1725abac1b9d8111e3", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582871", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulitca-generala-raevskogo" where `id` = "8226" limit 1 UPDATE object SET status='1', ad_code = 'c36bf4342cb2fe1725abac1b9d8111e3' WHERE id='8226' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8226' WHERE id='9131' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582871' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582871' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358397" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158358397", "https://gelendzhik.cian.ru/rent/flat/158358397/", "cian.ru", "1500582871", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "15" update proxy_list set use_time = "1500582872", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "15" UPDATE indexed_ad SET `status`='3' WHERE id ='9132' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9132' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Гринченко" and coordinates = "38.070368 44.551821" LIMIT 1 select id from number where city = "59" and `api-name` = "улица Гринченко, 30" and coordinates = "38.070242 44.550106" LIMIT 1 select id from street where `api-name` = "улица Гринченко, 30" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "2914", "0", "улица Гринченко, 30", "улица Гринченко, 30", "ulitca-grinchenko-30", "38.070242 44.550106") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.070242','44.550106','0','0','0','2914','6180','улица Гринченко, 30','[]','59','1','4','3000','1','2','5','5','70','44','8','2','2','Код объекта: 6761. Общая площадь - 70 кв.м., кухня - 8,0 кв.м., лоджия - 4.5 кв.м., на 5 этаже 6 этажного панельного жилого дома. В квартире есть вся бытовая техника и удобства, для комфортного проживания, благоустроенный район, ( рядом аптека авицена, рынок на полевой, остановка) .Семейной паре без детей и животных.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8227", "2ecbc75a358ce5dd2326e1d3f37fbf60", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582872", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "15" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulitca-grinchenko-2913" where `id` = "8227" limit 1 UPDATE object SET status='1', ad_code = '2ecbc75a358ce5dd2326e1d3f37fbf60' WHERE id='8227' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8227' WHERE id='9132' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582872' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582872' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358160" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158358160", "https://gelendzhik.cian.ru/rent/flat/158358160/", "cian.ru", "1500582872", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "12" update proxy_list set use_time = "1500582872", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE indexed_ad SET `status`='3' WHERE id ='9133' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9133' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Орджоникидзе" and coordinates = "38.087068 44.54841" LIMIT 1 select id from street where `api-name` = "улица Орджоникидзе" and `city` = "59" limit 1 INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "улица Орджоникидзе", "улица Орджоникидзе","ulitca-ordzhonikidze","38.087068 44.54841") select id from number where city = "59" and `api-name` = "улица Орджоникидзе, 22" and coordinates = "38.092341 44.54868" LIMIT 1 select id from street where `api-name` = "улица Орджоникидзе, 22" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3010", "0", "улица Орджоникидзе, 22", "улица Орджоникидзе, 22", "ulitca-ordzhonikidze-22", "38.092341 44.54868") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.092341','44.54868','0','0','0','3010','6181','улица Орджоникидзе, 22','["микрорайон Магилат"]','59','1','4','3500','1','2','3','4','64','35','10','2','2','Код объекта: 6726. Квартира находится в новом доме, третий этаж, 1000 метров от моря, недалеко Гипермаркет Магнит. 4-6 спальных мест, полностью благоустроенная и меблированная; кухонный гарнитур, газовая плита, холодильник, стиральная машина, кондиционеры, микроволновая печь, телевизор, утюг. Автономное отопление. Закрытая парковка. https://gelendzhik./rent/flat//','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8228", "b42637ae7f25c42337605ed3d36d434e", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582873", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulitca-ordzhonikidze" where `id` = "8228" limit 1 UPDATE object SET status='1', ad_code = 'b42637ae7f25c42337605ed3d36d434e' WHERE id='8228' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8228' WHERE id='9133' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582873' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582873' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157491515" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157491515", "https://gelendzhik.cian.ru/rent/flat/157491515/", "cian.ru", "1500582873", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "14" update proxy_list set use_time = "1500582873", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "14" UPDATE indexed_ad SET `status`='3' WHERE id ='9134' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9134' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Маячная улица" and coordinates = "38.07415 44.576585" LIMIT 1 select id from number where city = "59" and `api-name` = "Маячная улица, 1" and coordinates = "38.070862 44.574613" LIMIT 1 select id from street where `api-name` = "Маячная улица, 1" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "2549", "0", "Маячная улица, 1", "Маячная улица, 1", "mayachnaya-ulitca-1", "38.070862 44.574613") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.070862','44.574613','0','0','0','2549','6182','Маячная улица, 1','[]','59','1','4','3500','1','1','4','5','42','2','2','Код объекта: 13847. 1-комнатная квартира ПОСУТОЧНО Квартира полностью оборудована для комфортного проживания, оснащена всей необходимой техникой. Рассчитана на семью из 3 человек, в наличии два двухспальных дивана. Квартира расположена в тихом проулке, при этом близко к набережной моря. СДАЕТСЯ СЕМЬЯМ БЕЗ ЖИВОТНЫХ.Цена:июнь - 2500 р.июль, август - 4000 р.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8229", "71e1d1f7beb50c55e1af23b933a724ef", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582873", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-mayachnaya-ulitca" where `id` = "8229" limit 1 UPDATE object SET status='1', ad_code = '71e1d1f7beb50c55e1af23b933a724ef' WHERE id='8229' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8229' WHERE id='9134' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582873' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582873' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359036" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158359036", "https://gelendzhik.cian.ru/rent/flat/158359036/", "cian.ru", "1500582873", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "11" update proxy_list set use_time = "1500582874", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE indexed_ad SET `status`='3' WHERE id ='9135' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9135' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Новороссийская улица" and coordinates = "38.08864 44.560325" LIMIT 1 select id from street where `api-name` = "Новороссийская улица" and `city` = "59" limit 1 select MAX(id) from street INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "Новороссийская улица", "Новороссийская улица","novorossijskaya-ulitca-3010","38.08864 44.560325") select id from number where city = "59" and `api-name` = "Новороссийская улица, 67" and coordinates = "38.08378 44.556253" LIMIT 1 select id from street where `api-name` = "Новороссийская улица, 67" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3011", "0", "Новороссийская улица, 67", "Новороссийская улица, 67", "novorossijskaya-ulitca-67", "38.08378 44.556253") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.08378','44.556253','0','0','0','3011','6183','Новороссийская улица, 67','[]','59','1','4','3500','1','1','3','3','50.5','35','15','2','2','Код объекта: 5004. Сдается шикарная 2-ух комнатная квартира 50 кв.м. от 5-ти суток. В квартире выполнен евроремонт, укомплектованна качественной мебелью и импортной сантехникой. Есть встроенный кухонный гарнитур включая: печь, вытяжку и посудомоечную машину, холодильник, микроволновую печь,стиральную машина.В прихожей встроенный шкаф.Ухоженный, благоустроееный двор.Парковка.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8230", "fdd5f486795f270dd1d19ac336e7a451", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582874", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-novorossijskaya-ulitca-3010" where `id` = "8230" limit 1 UPDATE object SET status='1', ad_code = 'fdd5f486795f270dd1d19ac336e7a451' WHERE id='8230' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8230' WHERE id='9135' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582874' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582874' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358771" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158358771", "https://gelendzhik.cian.ru/rent/flat/158358771/", "cian.ru", "1500582874", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "13" update proxy_list set use_time = "1500582874", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE indexed_ad SET `status`='3' WHERE id ='9136' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9136' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Ульяновская улица" and coordinates = "38.069048 44.552072" LIMIT 1 select id from number where city = "59" and `api-name` = "Ульяновская улица, 19" and coordinates = "38.068994 44.551821" LIMIT 1 select id from street where `api-name` = "Ульяновская улица, 19" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "1123", "0", "Ульяновская улица, 19", "Ульяновская улица, 19", "ulyanovskaya-ulitca-19", "38.068994 44.551821") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.068994','44.551821','0','0','0','1123','6184','Ульяновская улица, 19','[]','59','1','4','3500','1','2','2','9','68','35','13','2','2','Код объекта: 497. На берегу моря, сдаётся 2-ух комнатная квартира по ул. Ульяновская, расположенная на 2 этаже, 9-ти этажного кирпичного дома. Общей площадью 68 кв.м., кухня- 13 кв.м., (кухня совмещена с лоджией), застеклённый балкон. В квартире есть: Два двухместных дивана и один одноместный диван, холодильник, телевизор, стиральная машинка, сплит-системы, СВЧ-печь, пылесос, кухонный гарнитур, Wi-Fi. Очень чистый подъезд, домофон. Возможность проживания до 5-ти человек. Во дворе парковка.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8231", "fddc132df6b47e071a8d21bbd5d3839b", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582875", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulyanovskaya-ulitca" where `id` = "8231" limit 1 UPDATE object SET status='1', ad_code = 'fddc132df6b47e071a8d21bbd5d3839b' WHERE id='8231' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8231' WHERE id='9136' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582875' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582875' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157427667" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157427667", "https://gelendzhik.cian.ru/rent/flat/157427667/", "cian.ru", "1500582875", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "15" update proxy_list set use_time = "1500582875", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "15" UPDATE indexed_ad SET `status`='3' WHERE id ='9137' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9137' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Курзальная улица" and coordinates = "38.077312 44.551314" LIMIT 1 INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`passenger_elevator`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.077294','44.55132','0','0','0','2841','0','Курзальная улица','[]','59','1','4','4000','1','2','10','10','65','40','10','2','2','1','Код объекта: 7910. В квартире все имеется для комфортного проживания и отдыха. Семь спальных мест. До моря 5 минут ходьбы. Рядом набережная с кафе, детскими атракционами. Возле дома охраняемая парковка. Детская площадка.Цена в июне - 4000, в июле, августе - 4500 р.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8232", "5a681019e9b52d5541ab1f05396a5863", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582875", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-kurzalnaya-ulitca" where `id` = "8232" limit 1 UPDATE object SET status='1', ad_code = '5a681019e9b52d5541ab1f05396a5863' WHERE id='8232' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8232' WHERE id='9137' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582875' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582875' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359034" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158359034", "https://gelendzhik.cian.ru/rent/flat/158359034/", "cian.ru", "1500582875", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "12" update proxy_list set use_time = "1500582876", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE indexed_ad SET `status`='3' WHERE id ='9138' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9138' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Новороссийская улица" and coordinates = "38.08864 44.560325" LIMIT 1 select id from number where city = "59" and `api-name` = "Новороссийская улица, 67" and coordinates = "38.08378 44.556253" LIMIT 1 INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.08378','44.556253','0','0','0','3011','6183','Новороссийская улица, 67','[]','59','1','4','4000','1','1','3','3','33.5','25','10','2','2','Код объекта: 4991. Сдается шикарная 1к-квартира-студия, 33,5 кв.метров в центре!В квартире шикарный евроремонт, есть все необходимое для комфортного проживания: встроенная кухня с барной стойкой и импортной техникой. В квартире имеется: холодильник, новая стиральная машина, кондиционер, плазма тв, кровать, большой шкаф для одежды, обувница, подключен WI-FI.Квартира находится в частном секторе в центре г.Геленджика.Хороший благоустроенный двор. Хороший подьезд с парковкой.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8233", "d085e502015bbd7c93848ba002f0abe6", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582876", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-novorossijskaya-ulitca-3010" where `id` = "8233" limit 1 UPDATE object SET status='1', ad_code = 'd085e502015bbd7c93848ba002f0abe6' WHERE id='8233' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8233' WHERE id='9138' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582876' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582876' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359985" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158359985", "https://gelendzhik.cian.ru/rent/flat/158359985/", "cian.ru", "1500582876", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "14" update proxy_list set use_time = "1500582876", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "14" UPDATE indexed_ad SET `status`='3' WHERE id ='9139' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9139' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Гринченко" and coordinates = "38.070368 44.551821" LIMIT 1 select id from number where city = "59" and `api-name` = "улица Гринченко, 36" and coordinates = "38.070566 44.549277" LIMIT 1 select id from street where `api-name` = "улица Гринченко, 36" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "2914", "0", "улица Гринченко, 36", "улица Гринченко, 36", "ulitca-grinchenko-36", "38.070566 44.549277") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.070566','44.549277','0','0','0','2914','6185','улица Гринченко, 36','[]','59','1','4','4000','1','2','1','5','52','35','12','2','2','Код объекта: 1899. Двухкомнатная квартира + веранда 18 кв.м. и участок 0,5 сотки (огорожен принадлежит только этой квартире с зоной барбекю), два входа в квартиру. В зале угловой диван -2-х спальный, спальня: 2-х спальная кровать, веранда: диван-2-х спальный (6 взрослых спальных мест). 8 спальных мест. Всё новое ( мебель,сантехника, холодильник.стиральная машина, кондиционер, посуда, постельное бельё ). Отличный ремонт. Интернет, ж\к телевизор и триколор.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8234", "a2a3655466b01af4f9c8bfa8d1c51c52", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582877", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulitca-grinchenko-2913" where `id` = "8234" limit 1 UPDATE object SET status='1', ad_code = 'a2a3655466b01af4f9c8bfa8d1c51c52' WHERE id='8234' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8234' WHERE id='9139' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582877' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582877' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472335" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157472335", "https://gelendzhik.cian.ru/rent/flat/157472335/", "cian.ru", "1500582877", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "13" update proxy_list set use_time = "1500582877", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE indexed_ad SET `status`='3' WHERE id ='9140' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9140' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Шмидта" and coordinates = "38.078291 44.573393" LIMIT 1 select id from number where city = "59" and `api-name` = "улица Шмидта, 8" and coordinates = "38.079576 44.573669" LIMIT 1 select id from street where `api-name` = "улица Шмидта, 8" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "2647", "0", "улица Шмидта, 8", "улица Шмидта, 8", "ulitca-shmidta-8", "38.079576 44.573669") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`passenger_elevator`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.079576','44.573669','0','0','0','2647','6186','улица Шмидта, 8','[]','59','1','4','4000','1','2','10','17','80','45','15','2','2','1','Код объекта: 13327. Сдается комфортная 2-комнатная квартира в Геленджике. Отличный вид на море. Хороший ремонт. Есть все необходимое для комфортного отдыха. Имеется бойлер на 80 литров, благодаря чему не будет проблем с водой. В квартире теплый пол, кабельное телевидение. Осуществляется бронирование на летний период','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8235", "69f35b29aea475665c2191edc6776386", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582877", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulitca-shmidta" where `id` = "8235" limit 1 UPDATE object SET status='1', ad_code = '69f35b29aea475665c2191edc6776386' WHERE id='8235' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8235' WHERE id='9140' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582877' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582877' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158360218" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158360218", "https://gelendzhik.cian.ru/rent/flat/158360218/", "cian.ru", "1500582877", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "11" update proxy_list set use_time = "1500582878", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE indexed_ad SET `status`='3' WHERE id ='9141' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9141' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Приморская улица" and coordinates = "38.071635 44.554429" LIMIT 1 select id from street where `api-name` = "Приморская улица" and `city` = "59" limit 1 INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "Приморская улица", "Приморская улица","primorskaya-ulitca","38.071635 44.554429") select id from number where city = "59" and `api-name` = "Приморская улица, 30" and coordinates = "38.069084 44.554172" LIMIT 1 select id from street where `api-name` = "Приморская улица, 30" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3012", "0", "Приморская улица, 30", "Приморская улица, 30", "primorskaya-ulitca-30", "38.069084 44.554172") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`rent_rate_q`,`payment_rate_q`,`passenger_elevator`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.069084','44.554172','0','0','0','3012','6187','Приморская улица, 30','[]','59','1','4','4500','1','1','9','11','49','2','2','1','Код объекта: 13195. СДАЁТСЯ 1-КОМ. КВАРТИРА Улица Приморская.1-я береговая линия.Площадь - 47 кв.м. Квартира новая. Отличный ремонт. Полная комплектация.6 спальных мест. Цены:Июнь-4000Июль-5000Август-6000Сентябрь-4000','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8236", "95d5b3c7050c27c8ca0dac3c741eff4a", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582878", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-primorskaya-ulitca" where `id` = "8236" limit 1 UPDATE object SET status='1', ad_code = '95d5b3c7050c27c8ca0dac3c741eff4a' WHERE id='8236' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8236' WHERE id='9141' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582878' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582878' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358991" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158358991", "https://gelendzhik.cian.ru/rent/flat/158358991/", "cian.ru", "1500582878", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "15" update proxy_list set use_time = "1500582879", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "15" UPDATE indexed_ad SET `status`='3' WHERE id ='9142' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9142' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Мичурина" and coordinates = "38.090688 44.555322" LIMIT 1 select id from street where `api-name` = "улица Мичурина" and `city` = "59" limit 1 INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "улица Мичурина", "улица Мичурина","ulitca-michurina","38.090688 44.555322") select id from number where city = "59" and `api-name` = "улица Мичурина, 5" and coordinates = "38.089592 44.554467" LIMIT 1 select id from street where `api-name` = "улица Мичурина, 5" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3013", "0", "улица Мичурина, 5", "улица Мичурина, 5", "ulitca-michurina-5", "38.089592 44.554467") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.089592','44.554467','0','0','0','3013','6188','улица Мичурина, 5','[]','59','1','4','5000','1','2','1','2','60','35','13','2','2','Код объекта: 1396. Общей площадью 60 кв.м., кухня 13 кв.м. Имеется все необходимое для комфортного проживания, телевизор, кровать, холодильник, стиральная машина. Дорогой евроремонт, автономное отопление, холодная/горячая вода постоянно, парковка автомобиля на частной территории. Семье без животных или со взрослыми детьми.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8237", "a21951388b58ec43986919bcf293e598", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582879", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "15" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulitca-michurina" where `id` = "8237" limit 1 UPDATE object SET status='1', ad_code = 'a21951388b58ec43986919bcf293e598' WHERE id='8237' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8237' WHERE id='9142' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582879' WHERE id = '57' LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 UPDATE indexation_control SET count_cycles = count_cycles + 1 WHERE id = '57' LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "14" update proxy_list set use_time = "1500582910", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "14" UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "159032389" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358789" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472368" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157505717" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472404" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472420" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472322" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157427666" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358277" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358473" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472409" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158360044" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472376" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472411" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359005" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358619" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472370" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157976836" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359054" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358397" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358160" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157491515" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359036" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358771" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157427667" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359034" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359985" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157472335" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158360218" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358991" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582910' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359978" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158359978", "https://gelendzhik.cian.ru/rent/flat/158359978/", "cian.ru", "1500582910", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "12" update proxy_list set use_time = "1500582911", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE indexed_ad SET `status`='3' WHERE id ='9143' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9143' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Нахимова" and coordinates = "38.089242 44.553947" LIMIT 1 select id from street where `api-name` = "улица Нахимова" and `city` = "59" limit 1 INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "улица Нахимова", "улица Нахимова","ulitca-nakhimova","38.089242 44.553947") select id from number where city = "59" and `api-name` = "улица Нахимова, 23" and coordinates = "38.090104 44.553832" LIMIT 1 select id from street where `api-name` = "улица Нахимова, 23" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3014", "0", "улица Нахимова, 23", "улица Нахимова, 23", "ulitca-nakhimova-23", "38.090104 44.553832") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.090104','44.553832','0','0','0','3014','6189','улица Нахимова, 23','[]','59','1','4','5000','1','3','2','2','70','38','14','2','2','Код объекта: 2199. В районе гипермаркета Магнит сдается просторная трехкомнатная квартирадобное расположение - на втором этаже малоквартирного двухэтажного дома. Квартира просторная - общая площадь 70 кв. м. Оригинальный яркий позитивный ремонт, есть вся необходимая мебель хорошего качества. Укомплектована бытовой техникой - есть встроенная варочная панель, духовой шкаф, холодильник, телевизор.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8238", "6f3459c63bd2e369bbeede44b2fbd6b7", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582911", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulitca-nakhimova" where `id` = "8238" limit 1 UPDATE object SET status='1', ad_code = '6f3459c63bd2e369bbeede44b2fbd6b7' WHERE id='8238' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8238' WHERE id='9143' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582911' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582911' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158358931" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158358931", "https://gelendzhik.cian.ru/rent/flat/158358931/", "cian.ru", "1500582911", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "13" update proxy_list set use_time = "1500582912", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE indexed_ad SET `status`='3' WHERE id ='9144' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9144' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Южная улица" and coordinates = "38.055815 44.550556" LIMIT 1 select id from number where city = "59" and `api-name` = "Южная улица, 32" and coordinates = "38.057271 44.551648" LIMIT 1 select id from street where `api-name` = "Южная улица, 32" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3005", "0", "Южная улица, 32", "Южная улица, 32", "iuzhnaya-ulitca-32", "38.057271 44.551648") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.057271','44.551648','0','0','0','3005','6190','Южная улица, 32','["микрорайон Толстый Мыс"]','59','1','4','4500','1','1','2','11','42','20','15','2','2','Код объекта: 9892. Однокомнатная квартира сдается посуточно, все новое. 4 спальных места.До моря 15 минут ходьбы. Парковка, детская площадка во дворе.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8239", "46748a3daa5117d212e1d74bd7ce7395", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582912", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-iuzhnaya-ulitca" where `id` = "8239" limit 1 UPDATE object SET status='1', ad_code = '46748a3daa5117d212e1d74bd7ce7395' WHERE id='8239' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8239' WHERE id='9144' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582912' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582912' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157606243" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157606243", "https://gelendzhik.cian.ru/rent/flat/157606243/", "cian.ru", "1500582912", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "11" update proxy_list set use_time = "1500582912", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE indexed_ad SET `status`='3' WHERE id ='9145' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9145' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Маячная улица" and coordinates = "38.07415 44.576585" LIMIT 1 select id from number where city = "59" and `api-name` = "Маячная улица, 1" and coordinates = "38.070862 44.574613" LIMIT 1 INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.070862','44.574613','0','0','0','2549','6182','Маячная улица, 1','[]','59','1','4','5500','1','2','2','6','75','40','10','2','2','Код объекта: 13951. Элитная квартира со всеми удобствами. Евроремонт. Идеальный вариант для семейного отдыха. Есть телевизор, интернет, постельное белье, полотенца, столовые приборы. До моря - 10 минут. Рядом супермаркеты, зоны отдыха. Цена в июнне - 5500 рублей в сутки, в июле, августе - 6500 рублей.При бронировании более 10 дней скидки.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8240", "149c7ebff0b7548992a8ab0f721d65b2", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582913", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-mayachnaya-ulitca" where `id` = "8240" limit 1 UPDATE object SET status='1', ad_code = '149c7ebff0b7548992a8ab0f721d65b2' WHERE id='8240' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8240' WHERE id='9145' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582913' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582913' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157612501" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157612501", "https://gelendzhik.cian.ru/rent/flat/157612501/", "cian.ru", "1500582913", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "15" update proxy_list set use_time = "1500582913", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "15" UPDATE indexed_ad SET `status`='3' WHERE id ='9146' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9146' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "Маячная улица" and coordinates = "38.07415 44.576585" LIMIT 1 select id from number where city = "59" and `api-name` = "Маячная улица, 1" and coordinates = "38.070862 44.574613" LIMIT 1 INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.070862','44.574613','0','0','0','2549','6182','Маячная улица, 1','[]','59','1','4','5500','1','2','5','5','75','40','15','2','2','Код объекта: 13954. Сдается квартира в уютном районе Геленджика. Новый ремонт. Отличный вариант для семейного отдыха.Квартира полностью укомплектована. Есть мебель, техника, постельное белье, столовые приборы. Отличный вариант для семейного отдыха. Цена в июне - 5500 рублей, в июле, августе - 6500 рублей. При бронировании от 7 дней скидки.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8241", "7b056310c9fdad3de4caca292de8196a", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582913", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-mayachnaya-ulitca" where `id` = "8241" limit 1 UPDATE object SET status='1', ad_code = '7b056310c9fdad3de4caca292de8196a' WHERE id='8241' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8241' WHERE id='9146' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582914' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582914' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359104" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158359104", "https://gelendzhik.cian.ru/rent/flat/158359104/", "cian.ru", "1500582914", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "14" update proxy_list set use_time = "1500582914", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "14" UPDATE indexed_ad SET `status`='3' WHERE id ='9147' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9147' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "село Кабардинка" or `api-name` = "село Кабардинка") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "65" ORDER BY `id-location` ASC select id from street where city = "65" and `api-name` = "улица Мира" and coordinates = "37.926575 44.641237" LIMIT 1 select id from number where city = "65" and `api-name` = "улица Мира, 15Б" and coordinates = "37.936438 44.649721" LIMIT 1 select id from street where `api-name` = "улица Мира, 15Б" and `city` = "65" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "65", "0", "0", "2877", "0", "улица Мира, 15Б", "улица Мира, 15Б", "ulitca-mira-15b", "37.936438 44.649721") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`passenger_elevator`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','37.936438','44.649721','0','0','0','2877','6191','улица Мира, 15Б','["городской округ Геленджик"]','65','1','4','6000','1','1','10','11','40.4','14.4','13.2','2','2','1','Код объекта: 6617. Общая площадь около 40,4 кв.м., и лоджия 10,7 кв.м.. Высота потолков 3 метра. Весь ремонт произведен из экологически чистых материалов. Дизайн выполнен в светлых тонах. Натяжные потолки, два санузла, оба в кафеле. Душ, стиральная машина. Кухонный гарнитур имеет увеличенную площадь фасадов, закрывает газовый котел, включает в себя встроенный холодильник, духовой шкаф, электропанель, посудомоечную машину, фильтр для воды, вытяжку. Предусмотрена удобная диван-кровать на два полноценных спальных места. На полу кафельная плитка с теплыми полами. В жилой комнате дорогие обои, на полу португальское пробковое покрытие, собрана и установлена дорогая мебель, люстра, 2 настенных бра. На лоджии уложена плитка по всем стандартам ремонтно-строительных работ. В планировке квартиры продумано много места для хранения. Установлены дорогая входная дверь с 4 классом взломостойкости, инверторная сплит система зима-лето.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8242", "51040d151b8ebadca903e9456dda60a7", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582914", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "14" UPDATE object SET photo_name = "selo-kabardinka-snyat-kvartiru-posutochno-ulitca-mira-2876" where `id` = "8242" limit 1 UPDATE object SET status='1', ad_code = '51040d151b8ebadca903e9456dda60a7' WHERE id='8242' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8242' WHERE id='9147' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582915' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582915' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "153678924" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("153678924", "https://gelendzhik.cian.ru/rent/flat/153678924/", "cian.ru", "1500582915", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "12" update proxy_list set use_time = "1500582915", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE indexed_ad SET `status`='3' WHERE id ='9148' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9148' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Некрасова" and coordinates = "38.074545 44.574748" LIMIT 1 select id from street where `api-name` = "улица Некрасова" and `city` = "59" limit 1 INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "улица Некрасова", "улица Некрасова","ulitca-nekrasova","38.074545 44.574748") select id from number where city = "59" and `api-name` = "улица Некрасова, 15" and coordinates = "38.074563 44.574511" LIMIT 1 select id from street where `api-name` = "улица Некрасова, 15" and `city` = "59" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "3015", "0", "улица Некрасова, 15", "улица Некрасова, 15", "ulitca-nekrasova-15", "38.074563 44.574511") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`passenger_elevator`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.074563','44.574511','0','0','0','3015','6192','улица Некрасова, 15','[]','59','1','4','6500','1','2','6','14','64','30','12','2','2','1','Код объекта: 11313. Двухкомнатная квартира в новом комплексе ЖК Азимут. Расположенна на 6 этаже 14 этажного дома.Общая площадь - 64 квадратных метров , жилая 30 кв.м. кухня 15 и 2 балкона. Дизайнерский ремонт, стильная мебель, вся бытовая техника. Великолепный вид на море изо всех окон.Цена:июнь-5500 р.июль-6500 р.август-6500 р.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8243", "80025d32e5b579c81ab44d0a8da092fd", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582915", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-posutochno-ulitca-nekrasova" where `id` = "8243" limit 1 UPDATE object SET status='1', ad_code = '80025d32e5b579c81ab44d0a8da092fd' WHERE id='8243' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8243' WHERE id='9148' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582915' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582915' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "157427664" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("157427664", "https://gelendzhik.cian.ru/rent/flat/157427664/", "cian.ru", "1500582915", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "13" update proxy_list set use_time = "1500582916", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE indexed_ad SET `status`='3' WHERE id ='9149' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9149' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Маяковского" and coordinates = "38.10189 44.554153" LIMIT 1 select id from street where `api-name` = "улица Маяковского" and `city` = "59" limit 1 INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "59", "0", "0", "улица Маяковского", "улица Маяковского","ulitca-mayakovskogo","38.10189 44.554153") INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`rent_rate_q`,`payment_rate_q`,`commission_type`,`value_commission`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.10189','44.554153','0','0','0','3016','0','улица Маяковского','["микрорайон Южный"]','59','1','4','35000','1','2','3','8','63','1','1','4','50','Просьба агентам не звонить. По какой-то причине этот агент не готов сотрудничать с другими агентами. Код объекта: 2297. Сдается 2-к квартира 63 кв. м. на 3 этаже 8-этажного монолитного дома.Сдается на длительный период времени новая просторная квартира с новым ремонтом. Автономное отопление, в квартире теплый пол, новая сантехника и вся бытовая техника. Район с хорошей инфраструктурой, рядом продуктовые магазины, магнит, химчистка, кафе, школа.Цена указана за летние месяцы, в зимний период стоимость 13 тысяч рублей. Коммунальные платежи оплачиваются отдельно.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8244", "f771a856c7489c7e91872f3870508072", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582916", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-na-dlitelnyj-srok-ulitca-mayakovskogo" where `id` = "8244" limit 1 UPDATE object SET status='1', ad_code = 'f771a856c7489c7e91872f3870508072' WHERE id='8244' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8244' WHERE id='9149' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582916' WHERE id = '57' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '57' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500582916' WHERE id = '57' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158359796" and (status = "1" or status = "0") and source_name="cian.ru" LIMIT 1 INSERT IGNORE INTO indexed_ad (`source_id`, `url`, `source_name`, `time`, `status`) VALUES ("158359796", "https://gelendzhik.cian.ru/rent/flat/158359796/", "cian.ru", "1500582916", "1") select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "11" update proxy_list set use_time = "1500582916", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE indexed_ad SET `status`='3' WHERE id ='9150' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9150' LIMIT 1 SELECT login_id FROM users WHERE phone="78612123551" LIMIT 1 SELECT id FROM phone WHERE phone="78612123551" LIMIT 1 SELECT id, type_search FROM region WHERE (name = "Краснодарский край" or `api-name` = "Краснодарский край") LIMIT 1 SELECT id FROM locality WHERE (name = "Геленджик" or `api-name` = "Геленджик") and region = "4" LIMIT 1 SELECT * FROM sub_location WHERE type = 2 and target = "59" ORDER BY `id-location` ASC select id from street where city = "59" and `api-name` = "улица Гринченко" and coordinates = "38.070368 44.551821" LIMIT 1 select id from number where city = "59" and `api-name` = "улица Гринченко, 30" and coordinates = "38.070242 44.550106" LIMIT 1 INSERT INTO object (`type`,`type_rent_q`,`user`,`date_added`,`longitude`,`latitude`,`county`,`district`,`dependent`,`street`,`number`,`address_string`,`api_search_p`,`city`,`country`,`region`,`price`,`currency`,`room`,`floor`,`max_floor`,`all_area`,`living_area`,`kitchen_area`,`rent_rate_q`,`payment_rate_q`,`commission_type`,`value_commission`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6078','1500582600','38.070242','44.550106','0','0','0','2914','6180','улица Гринченко, 30','[]','59','1','4','70000','1','3','5','5','68','35','8','1','1','4','50','Просьба агентам не звонить. По какой-то причине этот агент не готов сотрудничать с другими агентами. Код объекта: 8260. В 400 м. от моря, предлагается к сдаче 3-ком. квартира общей площадью - 68 кв. м., на 5 этаже 5-этажного кирпичного дома, расположенная по адресу Геленджик, ул. Гринченко. Квартира в хорошем состоянии, с отличной звукоизоляцией, тихие соседи. Материал-кирпич, планировка-изолированная, полы-ламинат, газ-есть, балкон и лоджия застеклены (раздвижной алюминий). В квартире: два встроенных шкафа-купе, две сплит-системы, окна металлопластиковые, кухонный гарнитур со встроенной бытовой техникой, новая отопительная система, металлическая входная дверь. Тихий, спальный район. Квартира не угловая. Рядом два детских сада, школа, спортивная школа ДЮСШ, круглосуточные магазины, рынок На Полевой, аптеки, остановка общ. транспорта. С балкона вид на море . Квартира полностью готова к проживанию, не требует вложений.','0','1','1500582600') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8245", "4d3197ab4ed8c1f6e501ffac607c6ba5", "1", "8396") select id, proxy, auth, date_day from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time DESC limit 1 update proxy_list set use_time = "1500582917", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE object SET photo_name = "gelendzhik-snyat-kvartiru-na-dlitelnyj-srok-ulitca-grinchenko-2913" where `id` = "8245" limit 1 UPDATE object SET status='1', ad_code = '4d3197ab4ed8c1f6e501ffac607c6ba5' WHERE id='8245' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8245' WHERE id='9150' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500582917' WHERE id = '57' LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 select count(id) from proxy_list where status = "1" and `key` = "cian.ru" select id from proxy_list where `status` = "1" and `key` = "cian.ru" order by use_time ASC select id, proxy, auth, date_day, error_count from proxy_list where id = "15" update proxy_list set use_time = "1500582917", error_count = error_count + 1, requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "15" select id, proxy, auth, date_day, error_count from proxy_list where id = "14" update proxy_list set use_time = "1500582917", error_count = error_count + 1, requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "14" select id, proxy, auth, date_day, error_count from proxy_list where id = "12" update proxy_list set use_time = "1500582917", error_count = error_count + 1, requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" select id, proxy, auth, date_day, error_count from proxy_list where id = "13" update proxy_list set use_time = "1500582917", error_count = error_count + 1, requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" select id, proxy, auth, date_day, error_count from proxy_list where id = "11" update proxy_list set use_time = "1500582917", error_count = error_count + 1, requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE indexation_control SET action = '2', last_action_ad = '1500582917', type_pause = '1' WHERE id = '57' and status='1' and action <> 1 LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1 SELECT action FROM indexation_control WHERE id = "57" and status="1" LIMIT 1