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", "1500583404", "0", "0", "1500583404", "4") SELECT action FROM indexation_control WHERE id = "59" 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 = "11" update proxy_list set use_time = "1500583404", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '59' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500583404' WHERE id = '59' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "153591547" 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 ("153591547", "https://krasnodar.cian.ru/rent/flat/153591547/", "cian.ru", "1500583404", "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 = "1500583405", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE indexed_ad SET `status`='3' WHERE id ='9151' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9151' LIMIT 1 SELECT login_id FROM users WHERE phone="79189696254" LIMIT 1 INSERT INTO users (phone, status, salt) VALUES ("79189696254", "0", "foxmn17jqb") INSERT INTO sms_queuing (phone, time_add) VALUES ("79189696254", "1500583405") SELECT id FROM phone WHERE phone="79189696254" LIMIT 1 INSERT INTO phone (phone, status, time, user) VALUES (79189696254, 0, 1500583405, 6079) 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 = "3" ORDER BY `id-location` ASC SELECT id FROM county WHERE city = "3" and `api-name` = "Центральный округ" and coordinates = "38.989102 45.025049" LIMIT 1 SELECT id FROM district WHERE city = "3" and `api-name` = "Центральный микрорайон" and coordinates = "38.974684 45.027272" LIMIT 1 select id from street where city = "3" and `api-name` = "улица Чапаева" and coordinates = "38.97357 45.029642" LIMIT 1 select id from number where city = "3" and `api-name` = "улица Чапаева, 92" and coordinates = "38.973454 45.029527" LIMIT 1 select id from street where `api-name` = "улица Чапаева, 92" and `city` = "3" limit 1 INSERT IGNORE INTO number (`country`, `region`, `city`, `county`, `district`, `street`, `dependent`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "3", "14", "107", "1093", "0", "улица Чапаева, 92", "улица Чапаева, 92", "ulitca-chapaeva-92", "38.973454 45.029527") 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`,`rent_rate_q`,`payment_rate_q`,`windows_yard`,`balcony`,`repairs`,`tv`,`furniture_kitchen`,`furniture_rooms`,`fridge`,`animals`,`children`,`washer`,`internet`,`conditioning`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6079','1500583200','38.973454','45.029527','14','107','0','1093','6193','улица Чапаева, 92','["Центральный микрорайон","Центральный округ"]','3','1','4','1700','1','1','2','5','42','18','2','2','1','1','5','1','1','1','1','1','1','1','1','1','Вашему вниманию представляем удивительную квартиру в сердце нашего города - в Старом центре! Квартира выполнена в уютных пастельных тонах, не раздражающих глаз. Высокие потолки создают впечатление большого пространства, но в самом доме уютно и тепло. Элитная мебель, отличная бытовая техника. Рядом пешеходная зона улицы Красной, и развлечения на любой вкус парки, музеи, ресторанчики, приезжайте к нам и ощутите всю прелесть нашего города! Мы можем разместить до трех человек, в квартире есть шикарная двуспальная кровать и кресло-кровать. Посуда, постельные принадлежности и средства гигиены так же у нас имеются только для вас.Расчетный час 12.00Квартира НЕ сдается для проведения вечеринок, девичников, любовных свиданий и др.Отчетные документы предоставляем.паспорт обязательно','0','1','1500583200') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8246", "23996d52e8c73c8efe60bb32501db368", "1", "8397") 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 = "1500583405", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "12" UPDATE object SET photo_name = "krasnodar-snyat-kvartiru-posutochno-ulitca-chapaeva" where `id` = "8246" limit 1 UPDATE object SET status='1', ad_code = '23996d52e8c73c8efe60bb32501db368' WHERE id='8246' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8246' WHERE id='9151' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500583406' WHERE id = '59' LIMIT 1 UPDATE indexation_control SET ad_check = (ad_check + 1) WHERE id = '59' LIMIT 1 UPDATE indexation_control SET last_action_ad = '1500583406' WHERE id = '59' LIMIT 1 SELECT id, source_id, time, status FROM indexed_ad WHERE source_id = "158327236" 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 ("158327236", "https://sochi.cian.ru/rent/flat/158327236/", "cian.ru", "1500583406", "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 = "1500583406", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE indexed_ad SET `status`='3' WHERE id ='9152' LIMIT 1 UPDATE indexed_ad SET `status`='3' WHERE id ='9152' LIMIT 1 SELECT login_id FROM users WHERE phone="79284486199" LIMIT 1 INSERT INTO users (phone, status, salt) VALUES ("79284486199", "0", "u9u7d59jjw") INSERT INTO sms_queuing (phone, time_add) VALUES ("79284486199", "1500583406") SELECT id FROM phone WHERE phone="79284486199" LIMIT 1 INSERT INTO phone (phone, status, time, user) VALUES (79284486199, 0, 1500583406, 6080) 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 = "54" ORDER BY `id-location` ASC select id from street where city = "54" and `api-name` = "улица Надежды" and coordinates = "39.904279 43.463945" LIMIT 1 select id from street where `api-name` = "улица Надежды" and `city` = "54" limit 1 INSERT IGNORE INTO street (`country`, `region`, `city`, `county`, `district`, `name`, `api-name`, `code`, `coordinates`) VALUES ("1", "4", "54", "0", "0", "улица Надежды", "улица Надежды","ulitca-nadezhdy","39.904279 43.463945") 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`,`building_type`,`build_year`,`ceiling_height`,`parking`,`windows_yard`,`balcony`,`repairs`,`tv`,`furniture_kitchen`,`furniture_rooms`,`fridge`,`children`,`washer`,`internet`,`conditioning`,`txt_info`,`status`,`priority`,`points`) VALUES ('rent','1','6080','1500583200','39.904279','43.463945','0','0','0','3017','0','улица Надежды','["микрорайон Адлер","Адлерский район"]','54','1','4','1500','1','1','5','5','26','15','6','2','2','2','2015','2,70','1','1','1','4','1','1','1','1','1','1','1','1','Квартира расположена в Курортном городке ( район санатория Известия) Квартира оборудована всем необходимым для комфортного проживания до 4 человек, все продумано до мелочей, вам остается только наслаждаться отдыхом. А для отдыха к Вашим услугам три пляжа, Аквапарк, Океанариум, дельфинарий, Бювет с бесплатной минеральной водой. Многочисленные кафе, рестораны, столовые, магазины добавят комфорта. Приезжайте из своих холодных городов, у нас Лето! Стоимость на июль, август по запросу','0','1','1500583200') INSERT INTO contacts (ad_id, ad_code, type, id_contact) VALUES ("8247", "bfe60b4effd34f2d0a0b34eaac57e2e8", "1", "8398") 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 = "1500583406", requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE object SET photo_name = "sochi-snyat-kvartiru-posutochno-ulitca-nadezhdy" where `id` = "8247" limit 1 UPDATE object SET status='1', ad_code = 'bfe60b4effd34f2d0a0b34eaac57e2e8' WHERE id='8247' LIMIT 1 UPDATE indexed_ad SET status='1', db_id='8247' WHERE id='9152' LIMIT 1 UPDATE indexation_control SET ad_object = (ad_object + 1), last_action_ad = '1500583407' WHERE id = '59' LIMIT 1 SELECT action FROM indexation_control WHERE id = "59" 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 = "1500583407", 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 = "15" update proxy_list set use_time = "1500583407", 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 = "11" update proxy_list set use_time = "1500583407", error_count = error_count + 1, requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "11" select id, proxy, auth, date_day, error_count from proxy_list where id = "12" update proxy_list set use_time = "1500583407", 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 = "1500583407", error_count = error_count + 1, requests_day = requests_day + 1, requests_all = requests_all + 1 where id = "13" UPDATE indexation_control SET action = '2', last_action_ad = '1500583407', type_pause = '1' WHERE id = '59' and status='1' and action <> 1 LIMIT 1 SELECT action FROM indexation_control WHERE id = "59" and status="1" LIMIT 1 SELECT action FROM indexation_control WHERE id = "59" and status="1" LIMIT 1 UPDATE indexation_control SET count_cycles = count_cycles + 1 WHERE id = '59' LIMIT 1 UPDATE indexation_control SET status = '0', last_action_ad = '1500583437' WHERE id = '59' and status='1' LIMIT 1