АСКУГ

Система управления приборами учета газа с передачей данных по беспроводным каналам GasCloud

Система предназначена для просмотра состояния и управления приборами учёта газа, предусматривающими возможность передачи данных и управления по технологиям GSM/GPRS/3G/LTE, LTE Cat-M1/NB-IoT, LoRaWAN.

Структура ПО АСКУГ «GasCloud»

Сервер приема данных
  • обработка подключения приборов учета
  • получение данных и передача команд управления
  • взаимодействие с СУБД
Система управления базами данных (СУБД) PostgresSQL
  • хранение данных приборов учета
  • хранение команд управления
  • ведение служебных справочников
Сервер НТТП Apache+PHP
  • организация интерфейса с операторами системы
  • информационное взаимодействие со смежными информационными системами (биллинга, служба безопасности, режимы газоснабжения, статистика и т.п.)

Основные функции

Система обеспечивает выполнение следующих функций:
  • просмотр текущих показаний и функционально технического состояния приборов учёта газа
  • управление приборами учёта: управление клапаном подачи газа, установка периода передачи данных
  • ведение архивов показаний приборов учёта и истории управления клапаном подачи газа
  • экспорт текущих показаний приборов учёта в формате CSV
  • ведение справочника абонентов системы (добавление, редактирование реквизитов и удаление абонентов)
  • привязка приборов учёта к абонентам услуги потребления газа
  • ведение электронного счёта абонента: операция автоматического списания средств со счёта абонента за израсходованный объем газа в соответствии с выбранным тарифом, операции начисления денежных средств на счёт и корректировки состояния счёта
  • ведение справочника тарифов за потребления газа абонентами (добавление, редактирование и удаление тарифа)
  • ведение истории операций по счёту абонента: начисления и списания средств
  • ведение справочника операторов системы (добавление, редактирование прав доступа и реквизитов, удаление оператора)
  • информационное взаимодействие с системой САУПГ ГУП МО Мособлгаз
  • функционирование рабочего места сотрудника службы безопасности филиала газоснабжающей организации
  • отправка уведомлений операторам СБ о необходимости подтверждения команд управления
  • ведение электронного протокола действий операторов системы
Система не содержит явных ограничений на количество обрабатываемых приборов учёта и абонентов. Работа системы тестировалась на 3 млн. приборов учёта и абонентов.

Варианты исполнения

Вернуться на главную
Наш сайт использует cookies, чтобы улучшить ваш пользовательский опыт. Подробнее
Подробнее
************************** DEBUG MODE **********************************
Потребление памяти: 1618,46875 KB
SQL запросов: 107
Array
(
    [0] => Array
        (
            [query] => select * from `setting`
            [bindings] => Array
                (
                )

            [time] => 1,55
        )

    [1] => Array
        (
            [query] => select * from `customfield`
            [bindings] => Array
                (
                )

            [time] => 1,29
        )

    [2] => Array
        (
            [query] => select * from `redirect` where `from` = ? limit 1
            [bindings] => Array
                (
                    [0] => /askue
                )

            [time] => 1,28
        )

    [3] => Array
        (
            [query] => select * from `carts` where `token` = ?
            [bindings] => Array
                (
                    [0] => d8d1fb976c8bba08dbfc0c59e36feddd
                )

            [time] => 0,79
        )

    [4] => Array
        (
            [query] => select `price_brand`.* from `price` inner join `price_brand` on `price_brand`.`id` = `price`.`brand_id` where `price`.`status` = ? and `price`.`id` in (?, ?, ?, ?, ?, ?)
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 83
                    [2] => 84
                    [3] => 85
                    [4] => 86
                    [5] => 88
                    [6] => 89
                )

            [time] => 1,26
        )

    [5] => Array
        (
            [query] => select * from `menu` where `status` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                )

            [time] => 1,4
        )

    [6] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 1
                )

            [time] => 0,48
        )

    [7] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 26
                )

            [time] => 0,21
        )

    [8] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 26
                )

            [time] => 0,18
        )

    [9] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 29
                )

            [time] => 0,18
        )

    [10] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 29
                )

            [time] => 0,26
        )

    [11] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 30
                )

            [time] => 0,25
        )

    [12] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 30
                )

            [time] => 0,19
        )

    [13] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 10
                )

            [time] => 0,23
        )

    [14] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 10
                )

            [time] => 0,23
        )

    [15] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 9
                )

            [time] => 0,19
        )

    [16] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 9
                )

            [time] => 0,18
        )

    [17] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 36
                )

            [time] => 0,18
        )

    [18] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 36
                )

            [time] => 41,15
        )

    [19] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 31
                )

            [time] => 0,48
        )

    [20] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 31
                )

            [time] => 0,45
        )

    [21] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 7
                )

            [time] => 0,41
        )

    [22] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 7
                )

            [time] => 0,41
        )

    [23] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 41
                )

            [time] => 0,38
        )

    [24] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 41
                )

            [time] => 0,35
        )

    [25] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 1
                )

            [time] => 0,67
        )

    [26] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 26
                )

            [time] => 1,04
        )

    [27] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 26
                )

            [time] => 0,37
        )

    [28] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 29
                )

            [time] => 0,31
        )

    [29] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 29
                )

            [time] => 0,33
        )

    [30] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 30
                )

            [time] => 0,33
        )

    [31] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 30
                )

            [time] => 0,29
        )

    [32] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 10
                )

            [time] => 0,36
        )

    [33] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 10
                )

            [time] => 0,37
        )

    [34] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 9
                )

            [time] => 0,3
        )

    [35] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 9
                )

            [time] => 0,34
        )

    [36] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 36
                )

            [time] => 0,3
        )

    [37] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 36
                )

            [time] => 0,31
        )

    [38] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 31
                )

            [time] => 0,23
        )

    [39] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 31
                )

            [time] => 0,22
        )

    [40] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 7
                )

            [time] => 0,21
        )

    [41] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 7
                )

            [time] => 0,16
        )

    [42] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 41
                )

            [time] => 0,15
        )

    [43] => Array
        (
            [query] => select `price_katalog`.*, `price_katalog`.`url_katalog` as `url` from `price_katalog` where `status` = ? and `id_parent` = ? order by `position` asc
            [bindings] => Array
                (
                    [0] => 3
                    [1] => 41
                )

            [time] => 0,15
        )

)
Array
(
    [0] => Array
        (
            [sql] => 
            SELECT *
            FROM `location_address_image`
            ORDER BY `position` ASC 
        
            [placeholders] => Array
                (
                )

        )

    [1] => Array
        (
            [sql] => 
            SELECT *
            FROM `location_address_contact`
            ORDER BY position ASC;
        
            [placeholders] => Array
                (
                )

        )

    [2] => Array
        (
            [sql] => 
            SELECT *
            FROM `location_address`
            WHERE `default` = 1
            LIMIT 1
        
            [placeholders] => Array
                (
                )

        )

    [3] => Array
        (
            [sql] => 
            SELECT *
            FROM `location_address_type`
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 1
                )

        )

    [4] => Array
        (
            [sql] => 
            SELECT *
            FROM `location`
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 99
                )

        )

    [5] => Array
        (
            [sql] => 
            SELECT id as page_id, katalog_url as pattern
            FROM katalog
            WHERE status_id = 3
        
            [placeholders] => Array
                (
                )

        )

    [6] => Array
        (
            [sql] => 
            SELECT *
            FROM katalog_route
        
            [placeholders] => Array
                (
                )

        )

    [7] => Array
        (
            [sql] => 
            SELECT 
            k.id, katalog_url as url, k.file_name, k.title, k.meta, t.top_name, t.bottom_name,
            k.name, k.title, k.meta as description, k.keywords, k.view_breadcrumbs
            FROM katalog k 
            LEFT JOIN template t ON k.template_id = t.id 
            WHERE k.id = :id AND status_id = 3
        
            [placeholders] => Array
                (
                    [:id] => 118
                )

        )

    [8] => Array
        (
            [sql] => 
            SELECT *
            FROM product_item_template
            ORDER BY id ASC;
        
            [placeholders] => Array
                (
                )

        )

    [9] => Array
        (
            [sql] => 
            SELECT *
            FROM order_status
            ORDER BY id ASC;
        
            [placeholders] => Array
                (
                )

        )

    [10] => Array
        (
            [sql] => 
            SELECT *
            FROM public
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 23
                )

        )

    [11] => Array
        (
            [sql] => 
            SELECT * 
            FROM public_razdel
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 5
                )

        )

    [12] => Array
        (
            [sql] => 
            SELECT c.*, public_category.public_id
            FROM public_category
            INNER JOIN public_razdel c ON c.id = public_category.category_id
            WHERE public_category.public_id = :public_id;
        
            [placeholders] => Array
                (
                    [:public_id] => 23
                )

        )

    [13] => Array
        (
            [sql] => 
            SELECT * 
            FROM public_razdel
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 6
                )

        )

    [14] => Array
        (
            [sql] => 
            SELECT *
            FROM public
            WHERE public_razdel_id = :id AND status_id = 3
            ORDER BY `position` DESC
        
            [placeholders] => Array
                (
                    [:id] => 6
                )

        )

    [15] => Array
        (
            [sql] => 
            SELECT * 
            FROM public_razdel
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 6
                )

        )

    [16] => Array
        (
            [sql] => 
            SELECT c.*, public_category.public_id
            FROM public_category
            INNER JOIN public_razdel c ON c.id = public_category.category_id
            WHERE public_category.public_id = :public_id;
        
            [placeholders] => Array
                (
                    [:public_id] => 24
                )

        )

    [17] => Array
        (
            [sql] => 
            SELECT * 
            FROM public_razdel
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 6
                )

        )

    [18] => Array
        (
            [sql] => 
            SELECT c.*, public_category.public_id
            FROM public_category
            INNER JOIN public_razdel c ON c.id = public_category.category_id
            WHERE public_category.public_id = :public_id;
        
            [placeholders] => Array
                (
                    [:public_id] => 25
                )

        )

    [19] => Array
        (
            [sql] => 
            SELECT * 
            FROM public_razdel
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 6
                )

        )

    [20] => Array
        (
            [sql] => 
            SELECT c.*, public_category.public_id
            FROM public_category
            INNER JOIN public_razdel c ON c.id = public_category.category_id
            WHERE public_category.public_id = :public_id;
        
            [placeholders] => Array
                (
                    [:public_id] => 26
                )

        )

    [21] => Array
        (
            [sql] => 
            SELECT * 
            FROM public_razdel
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 7
                )

        )

    [22] => Array
        (
            [sql] => 
            SELECT *
            FROM public
            WHERE public_razdel_id = :id AND status_id = 3
            ORDER BY `position` DESC
        
            [placeholders] => Array
                (
                    [:id] => 7
                )

        )

    [23] => Array
        (
            [sql] => 
            SELECT * 
            FROM public_razdel
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 7
                )

        )

    [24] => Array
        (
            [sql] => 
            SELECT c.*, public_category.public_id
            FROM public_category
            INNER JOIN public_razdel c ON c.id = public_category.category_id
            WHERE public_category.public_id = :public_id;
        
            [placeholders] => Array
                (
                    [:public_id] => 27
                )

        )

    [25] => Array
        (
            [sql] => 
            SELECT * 
            FROM public_razdel
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 7
                )

        )

    [26] => Array
        (
            [sql] => 
            SELECT c.*, public_category.public_id
            FROM public_category
            INNER JOIN public_razdel c ON c.id = public_category.category_id
            WHERE public_category.public_id = :public_id;
        
            [placeholders] => Array
                (
                    [:public_id] => 28
                )

        )

    [27] => Array
        (
            [sql] => 
            SELECT * 
            FROM public_razdel
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 7
                )

        )

    [28] => Array
        (
            [sql] => 
            SELECT c.*, public_category.public_id
            FROM public_category
            INNER JOIN public_razdel c ON c.id = public_category.category_id
            WHERE public_category.public_id = :public_id;
        
            [placeholders] => Array
                (
                    [:public_id] => 29
                )

        )

    [29] => Array
        (
            [sql] => 
            SELECT * 
            FROM public_razdel
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 7
                )

        )

    [30] => Array
        (
            [sql] => 
            SELECT c.*, public_category.public_id
            FROM public_category
            INNER JOIN public_razdel c ON c.id = public_category.category_id
            WHERE public_category.public_id = :public_id;
        
            [placeholders] => Array
                (
                    [:public_id] => 30
                )

        )

    [31] => Array
        (
            [sql] => 
            SELECT * 
            FROM public_razdel
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 7
                )

        )

    [32] => Array
        (
            [sql] => 
            SELECT c.*, public_category.public_id
            FROM public_category
            INNER JOIN public_razdel c ON c.id = public_category.category_id
            WHERE public_category.public_id = :public_id;
        
            [placeholders] => Array
                (
                    [:public_id] => 31
                )

        )

    [33] => Array
        (
            [sql] => 
            SELECT * 
            FROM public_razdel
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 7
                )

        )

    [34] => Array
        (
            [sql] => 
            SELECT c.*, public_category.public_id
            FROM public_category
            INNER JOIN public_razdel c ON c.id = public_category.category_id
            WHERE public_category.public_id = :public_id;
        
            [placeholders] => Array
                (
                    [:public_id] => 32
                )

        )

    [35] => Array
        (
            [sql] => 
            SELECT *
            FROM public
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 22
                )

        )

    [36] => Array
        (
            [sql] => 
            SELECT * 
            FROM public_razdel
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 5
                )

        )

    [37] => Array
        (
            [sql] => 
            SELECT c.*, public_category.public_id
            FROM public_category
            INNER JOIN public_razdel c ON c.id = public_category.category_id
            WHERE public_category.public_id = :public_id;
        
            [placeholders] => Array
                (
                    [:public_id] => 22
                )

        )

    [38] => Array
        (
            [sql] => select SQL_CALC_FOUND_ROWS * from price  where status='3' AND price.id IN (
                SELECT price_id 
                FROM price_and_tag
                WHERE tag_id IN (2)
            ) order by price.position DESC limit 0, 15
            [placeholders] => Array
                (
                )

        )

    [39] => Array
        (
            [sql] => select found_rows() as total
            [placeholders] => Array
                (
                )

        )

    [40] => Array
        (
            [sql] => 
            SELECT price_tag.*, price_and_tag.price_id
            FROM price_tag
            INNER JOIN price_and_tag ON price_and_tag.tag_id = price_tag.id
            WHERE (price_and_tag.price_id=83 OR price_and_tag.price_id=84 OR price_and_tag.price_id=85 OR price_and_tag.price_id=86 OR price_and_tag.price_id=88 OR price_and_tag.price_id=89)
            ORDER BY price_tag.id ASC
        
            [placeholders] => Array
                (
                )

        )

    [41] => Array
        (
            [sql] => 
            SELECT price_katalog.*, price_katalog.url_katalog as url
            FROM price_katalog
            WHERE (id=36)
        
            [placeholders] => Array
                (
                )

        )

    [42] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE entity_id = :id
        
            [placeholders] => Array
                (
                    [:id] => 36
                )

        )

    [43] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE entity_id = :id
        
            [placeholders] => Array
                (
                    [:id] => 36
                )

        )

    [44] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE entity_id = :id
        
            [placeholders] => Array
                (
                    [:id] => 36
                )

        )

    [45] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE entity_id = :id
        
            [placeholders] => Array
                (
                    [:id] => 36
                )

        )

    [46] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE entity_id = :id
        
            [placeholders] => Array
                (
                    [:id] => 36
                )

        )

    [47] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE entity_id = :id
        
            [placeholders] => Array
                (
                    [:id] => 36
                )

        )

    [48] => Array
        (
            [sql] => 
            SELECT id, id_parent
            FROM price_katalog
            WHERE id = 0
        
            [placeholders] => Array
                (
                )

        )

    [49] => Array
        (
            [sql] => 
            SELECT *
            FROM `news_razdel`
            ORDER BY position ASC;
        
            [placeholders] => Array
                (
                )

        )

    [50] => Array
        (
            [sql] => SELECT price.* FROM price WHERE url_product= :url AND status = 3 
            [placeholders] => Array
                (
                    [:url] => 
                )

        )

    [51] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE (entity_id=2 OR entity_id=3 OR entity_id=4 OR entity_id=8 OR entity_id=5 OR entity_id=35 OR entity_id=40)
        
            [placeholders] => Array
                (
                )

        )

    [52] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog`
            WHERE (id_parent=2 OR id_parent=3 OR id_parent=4 OR id_parent=8 OR id_parent=5 OR id_parent=35 OR id_parent=40) AND status = 3
            ORDER BY `position` ASC
        
            [placeholders] => Array
                (
                )

        )

    [53] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE (entity_id=10 OR entity_id=9 OR entity_id=7 OR entity_id=26 OR entity_id=29 OR entity_id=30 OR entity_id=36 OR entity_id=31 OR entity_id=41)
        
            [placeholders] => Array
                (
                )

        )

    [54] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE (entity_id=37 OR entity_id=38 OR entity_id=39)
        
            [placeholders] => Array
                (
                )

        )

    [55] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE (entity_id=37 OR entity_id=38 OR entity_id=39)
        
            [placeholders] => Array
                (
                )

        )

    [56] => Array
        (
            [sql] => 
            SELECT *
            FROM `callback_razdel`
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 1
                )

        )

    [57] => Array
        (
            [sql] => 
            SELECT *
            FROM `callback_razdel`
            WHERE id = :id
        
            [placeholders] => Array
                (
                    [:id] => 1
                )

        )

    [58] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE (entity_id=2 OR entity_id=3 OR entity_id=4 OR entity_id=8 OR entity_id=5 OR entity_id=35 OR entity_id=40)
        
            [placeholders] => Array
                (
                )

        )

    [59] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog`
            WHERE (id_parent=2 OR id_parent=3 OR id_parent=4 OR id_parent=8 OR id_parent=5 OR id_parent=35 OR id_parent=40) AND status = 3
            ORDER BY `position` ASC
        
            [placeholders] => Array
                (
                )

        )

    [60] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE (entity_id=10 OR entity_id=9 OR entity_id=7 OR entity_id=26 OR entity_id=29 OR entity_id=30 OR entity_id=36 OR entity_id=31 OR entity_id=41)
        
            [placeholders] => Array
                (
                )

        )

    [61] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE (entity_id=37 OR entity_id=38 OR entity_id=39)
        
            [placeholders] => Array
                (
                )

        )

    [62] => Array
        (
            [sql] => 
            SELECT *
            FROM `price_katalog_field`
            WHERE (entity_id=37 OR entity_id=38 OR entity_id=39)
        
            [placeholders] => Array
                (
                )

        )

)
*************************************************************************