Окончание функции для получения api провайдера
Querying SQL: select * from apikeys where id = :apikeyid
Querying SQL: select * from apiprovidermethods where id = :id
Querying SQL: select * from smartfilters where "ApplicationId" = :appid
Querying SQL: select "FilterId" from smartfiltersext where "FilterId" in (select id from smartfilters where "ApplicationId" = :appid) and ("Value1" like '%#%' or "Value2" like '%#%')
Querying SQL: select * from applications where id = :appid
Categories.find()
Loading "promo_db" application component
Opening DB connection
Querying SQL: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
        pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
        AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
                AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='categories', :schema='promo_ru'
Querying SQL: SELECT conname, consrc, contype, indkey FROM (
        SELECT
                conname,
                CASE WHEN contype='f' THEN
                        pg_catalog.pg_get_constraintdef(oid)
                ELSE
                        'CHECK (' || consrc || ')'
                END AS consrc,
                contype,
                conrelid AS relid,
                NULL AS indkey
        FROM
                pg_catalog.pg_constraint
        WHERE
                contype IN ('f', 'c')
        UNION ALL
        SELECT
                pc.relname,
                NULL,
                CASE WHEN indisprimary THEN
                                'p'
                ELSE
                                'u'
                END,
                pi.indrelid,
                indkey
        FROM
                pg_catalog.pg_class pc,
                pg_catalog.pg_index pi
        WHERE
                pc.oid=pi.indexrelid
                AND EXISTS (
                        SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
                        ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
                        WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
        )
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
        AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
        WHERE nspname=:schema)). Bound with :table='categories', :schema='promo_ru'
Querying SQL: SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
        attrelid=(
                SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
                        SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
                )
        )
        AND attnum IN (1). Bound with :table='categories', :schema='promo_ru'
Querying SQL: SELECT * FROM "promo_ru"."categories" "t" WHERE id = :id LIMIT 1. Bound with :id=0
PApplications.find()
Querying SQL: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
        pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
        AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
                AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='papplications', :schema='promo_ru'
Querying SQL: SELECT conname, consrc, contype, indkey FROM (
        SELECT
                conname,
                CASE WHEN contype='f' THEN
                        pg_catalog.pg_get_constraintdef(oid)
                ELSE
                        'CHECK (' || consrc || ')'
                END AS consrc,
                contype,
                conrelid AS relid,
                NULL AS indkey
        FROM
                pg_catalog.pg_constraint
        WHERE
                contype IN ('f', 'c')
        UNION ALL
        SELECT
                pc.relname,
                NULL,
                CASE WHEN indisprimary THEN
                                'p'
                ELSE
                                'u'
                END,
                pi.indrelid,
                indkey
        FROM
                pg_catalog.pg_class pc,
                pg_catalog.pg_index pi
        WHERE
                pc.oid=pi.indexrelid
                AND EXISTS (
                        SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
                        ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
                        WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
        )
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
        AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
        WHERE nspname=:schema)). Bound with :table='papplications', :schema='promo_ru'
Querying SQL: SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
        attrelid=(
                SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
                        SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
                )
        )
        AND attnum IN (1). Bound with :table='papplications', :schema='promo_ru'
Querying SQL: SELECT * FROM "promo_ru"."papplications" "t" WHERE "TenantName" = :tname and "TenantAppId" = :appid LIMIT 1. Bound with :tname='arierra', :appid=672
Querying SQL: select
                (select count(id) from senderpool where "ApplicationId" = :appid and "SendType" = 'Email') as sentemail,
                (select COALESCE(sum("SMSPartCount"::integer), 0) from senderpool where "ApplicationId" = :appid and "SendType" = 'SMS') as sentsms,
                (select count(id) from senderpool where "ApplicationId" = :appid and "SendType" = 'Push') as sentpush
Objects.find()
Querying SQL: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
        pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
        AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
                AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum
Querying SQL: SELECT conname, consrc, contype, indkey FROM (
        SELECT
                conname,
                CASE WHEN contype='f' THEN
                        pg_catalog.pg_get_constraintdef(oid)
                ELSE
                        'CHECK (' || consrc || ')'
                END AS consrc,
                contype,
                conrelid AS relid,
                NULL AS indkey
        FROM
                pg_catalog.pg_constraint
        WHERE
                contype IN ('f', 'c')
        UNION ALL
        SELECT
                pc.relname,
                NULL,
                CASE WHEN indisprimary THEN
                                'p'
                ELSE
                                'u'
                END,
                pi.indrelid,
                indkey
        FROM
                pg_catalog.pg_class pc,
                pg_catalog.pg_index pi
        WHERE
                pc.oid=pi.indexrelid
                AND EXISTS (
                        SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
                        ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
                        WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
        )
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
        AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
        WHERE nspname=:schema))
Querying SQL: SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
        attrelid=(
                SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
                        SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
                )
        )
        AND attnum IN (1)
Querying SQL: SELECT * FROM "mobsted_ru"."objects" "t" WHERE id = :id LIMIT 1
Querying SQL: select t."id", t."AppId", t."ColumnName", t."ColumnType",
                    t."Protected", t."SystemColumn",
                    t."SMVisible", t."Depends", t."AutoRegistration", t."RestAuthType",
                    t."RestUrl", t."RestRequestType", t."RestResponseType", t."RestKey", t."RestValue",

                    t."RestLimit", t."DbHost", t."DbName", t."DbUser",
                    t."DbPassword", t."DbSql", t."DbKey", t."DbValue",
                    t."RestConnectionName", t."DbConnectionName", t."UseRestOrDb", t."UseState",
                    t."RestTemplate", t."DbTemplate", t."RestUser", t."RestPassword",
                    t."UseAsName", t."InShortViewSM", t."LastModified", t."DefaultValue", t."SortOrder", t."Visible" from objectcolumns t where t."AppId" = :appid order by t."SortOrder"
Querying SQL: SELECT "ColumnName" FROM objectcolumns WHERE "AppId" = :appid AND "UseState" = 1
Tenants.find()
Querying SQL: SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef,
        pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
        AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
                AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='tenants', :schema='tenantlist_ru'
Querying SQL: SELECT conname, consrc, contype, indkey FROM (
        SELECT
                conname,
                CASE WHEN contype='f' THEN
                        pg_catalog.pg_get_constraintdef(oid)
                ELSE
                        'CHECK (' || consrc || ')'
                END AS consrc,
                contype,
                conrelid AS relid,
                NULL AS indkey
        FROM
                pg_catalog.pg_constraint
        WHERE
                contype IN ('f', 'c')
        UNION ALL
        SELECT
                pc.relname,
                NULL,
                CASE WHEN indisprimary THEN
                                'p'
                ELSE
                                'u'
                END,
                pi.indrelid,
                indkey
        FROM
                pg_catalog.pg_class pc,
                pg_catalog.pg_index pi
        WHERE
                pc.oid=pi.indexrelid
                AND EXISTS (
                        SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
                        ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
                        WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
        )
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
        AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
        WHERE nspname=:schema)). Bound with :table='tenants', :schema='tenantlist_ru'
Querying SQL: SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
        attrelid=(
                SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
                        SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
                )
        )
        AND attnum IN (1). Bound with :table='tenants', :schema='tenantlist_ru'