Array
(
    [chartSql] => select backend."id" as "backend_id", backend.id as "backend_abc", to_timestamp(to_char(backend."CreateDate"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "backend_CreateDate", to_timestamp(to_char(backend."UpdateDate"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "backend_UpdateDate", backend."ActionName" as "backend_ActionName", backend."Value" as "backend_Value", backend."ApplicationId" as "backend_ApplicationId", backend."ObjectId" as "backend_ObjectId", backend."BackendRead" as "backend_BackendRead", statuses."Name" as "backend_StatusName", statuses."FontColor" as "backend_StatusTextColor", statuses."BackgroundColor" as "backend_StatusBgColor", backend."paymentsystem" as "backend_paymentsystem", backend."paymentstatus" as "backend_paymentstatus", backend."fiscalstatus" as "backend_fiscalstatus", backend."SrcTemplate" as "backend_SrcTemplate", backend."SrcScreen" as "backend_SrcScreen", backend."SrcEvent" as "backend_SrcEvent", backend."SrcTrigger" as "backend_SrcTrigger", backend."SrcChannel" as "backend_SrcChannel", backend."MURead" as "backend_MURead", statuses."FontColor" as "statuses_FontColor", statuses."Name" as "statuses_Name", statuses."BackgroundColor" as "statuses_BackgroundColor", users."Name" as "users_Name", objects.id as "objects_id", objects.id as "abc", objects.id as "xyz", (SELECT MAX(case when "ColumnName" = 'new_colw' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_new_colw", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1_ad0dff7879' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1_ad0dff7879", screens."Name" as "screens_Name", objects."InviteStatus" as "objects_InviteStatus", objects."StartScreen" as "objects_StartScreen", objects."Enabled" as "objects_Enabled", objects."Transport" as "objects_Transport", to_timestamp(to_char(objects."LastLogin"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "objects_LastLogin", backend."StatusId" as "backend_StatusId", backend."Responsibleid" as "backend_Responsibleid", objects."Phone" as "objects_Phone", objects."Email" as "objects_Email", objects."Testval" as "objects_Testval", (SELECT MAX(case when "ColumnName" = 'Login_source' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_Login_source", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1_357624f4a4' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1_357624f4a4" from backend  left join objects on objects.id = backend."ObjectId"  left join statuses on statuses.id = backend."StatusId"  left join users on users.id = backend."Responsibleid"  left join screens on screens.id = backend."ScreenId" ) x where "backend_ApplicationId" = 672 and ("backend_НоваяКолонка1_ad0dff7879"='123' and "screens_Name"='Home' and "backend_UpdateDate"='24.05.2018 18:17:58' and "objects_Email"='nzulfigarov@gmail.com')
    [percentSql2] =>
    [percentSql1] => select count(backend_id) as "singleValue" from (select * from (select backend."id" as "backend_id", backend.id as "backend_abc", to_timestamp(to_char(backend."CreateDate"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "backend_CreateDate", to_timestamp(to_char(backend."UpdateDate"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "backend_UpdateDate", backend."ActionName" as "backend_ActionName", backend."Value" as "backend_Value", backend."ApplicationId" as "backend_ApplicationId", backend."ObjectId" as "backend_ObjectId", backend."BackendRead" as "backend_BackendRead", statuses."Name" as "backend_StatusName", statuses."FontColor" as "backend_StatusTextColor", statuses."BackgroundColor" as "backend_StatusBgColor", backend."paymentsystem" as "backend_paymentsystem", backend."paymentstatus" as "backend_paymentstatus", backend."fiscalstatus" as "backend_fiscalstatus", backend."SrcTemplate" as "backend_SrcTemplate", backend."SrcScreen" as "backend_SrcScreen", backend."SrcEvent" as "backend_SrcEvent", backend."SrcTrigger" as "backend_SrcTrigger", backend."SrcChannel" as "backend_SrcChannel", backend."MURead" as "backend_MURead", statuses."FontColor" as "statuses_FontColor", statuses."Name" as "statuses_Name", statuses."BackgroundColor" as "statuses_BackgroundColor", users."Name" as "users_Name", objects.id as "objects_id", objects.id as "abc", objects.id as "xyz", (SELECT MAX(case when "ColumnName" = 'new_colw' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_new_colw", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1_ad0dff7879' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1_ad0dff7879", screens."Name" as "screens_Name", objects."InviteStatus" as "objects_InviteStatus", objects."StartScreen" as "objects_StartScreen", objects."Enabled" as "objects_Enabled", objects."Transport" as "objects_Transport", to_timestamp(to_char(objects."LastLogin"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "objects_LastLogin", backend."StatusId" as "backend_StatusId", backend."Responsibleid" as "backend_Responsibleid", objects."Phone" as "objects_Phone", objects."Email" as "objects_Email", objects."Testval" as "objects_Testval", (SELECT MAX(case when "ColumnName" = 'Login_source' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_Login_source", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1_357624f4a4' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1_357624f4a4" from backend  left join objects on objects.id = backend."ObjectId"  left join statuses on statuses.id = backend."StatusId"  left join users on users.id = backend."Responsibleid"  left join screens on screens.id = backend."ScreenId" ) x where "backend_ApplicationId" = 672 and ("backend_НоваяКолонка1_ad0dff7879"='123' and "screens_Name"='Home' and "backend_UpdateDate"='24.05.2018 18:17:58' and "objects_Email"='nzulfigarov@gmail.com')) ol
    [widgetSql] => select count(backend_id) as "singleValue" from (select * from (select backend."id" as "backend_id", backend.id as "backend_abc", to_timestamp(to_char(backend."CreateDate"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "backend_CreateDate", to_timestamp(to_char(backend."UpdateDate"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "backend_UpdateDate", backend."ActionName" as "backend_ActionName", backend."Value" as "backend_Value", backend."ApplicationId" as "backend_ApplicationId", backend."ObjectId" as "backend_ObjectId", backend."BackendRead" as "backend_BackendRead", statuses."Name" as "backend_StatusName", statuses."FontColor" as "backend_StatusTextColor", statuses."BackgroundColor" as "backend_StatusBgColor", backend."paymentsystem" as "backend_paymentsystem", backend."paymentstatus" as "backend_paymentstatus", backend."fiscalstatus" as "backend_fiscalstatus", backend."SrcTemplate" as "backend_SrcTemplate", backend."SrcScreen" as "backend_SrcScreen", backend."SrcEvent" as "backend_SrcEvent", backend."SrcTrigger" as "backend_SrcTrigger", backend."SrcChannel" as "backend_SrcChannel", backend."MURead" as "backend_MURead", statuses."FontColor" as "statuses_FontColor", statuses."Name" as "statuses_Name", statuses."BackgroundColor" as "statuses_BackgroundColor", users."Name" as "users_Name", objects.id as "objects_id", objects.id as "abc", objects.id as "xyz", (SELECT MAX(case when "ColumnName" = 'new_colw' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_new_colw", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1_ad0dff7879' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1_ad0dff7879", screens."Name" as "screens_Name", objects."InviteStatus" as "objects_InviteStatus", objects."StartScreen" as "objects_StartScreen", objects."Enabled" as "objects_Enabled", objects."Transport" as "objects_Transport", to_timestamp(to_char(objects."LastLogin"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "objects_LastLogin", backend."StatusId" as "backend_StatusId", backend."Responsibleid" as "backend_Responsibleid", objects."Phone" as "objects_Phone", objects."Email" as "objects_Email", objects."Testval" as "objects_Testval", (SELECT MAX(case when "ColumnName" = 'Login_source' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_Login_source", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1_357624f4a4' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1_357624f4a4" from backend  left join objects on objects.id = backend."ObjectId"  left join statuses on statuses.id = backend."StatusId"  left join users on users.id = backend."Responsibleid"  left join screens on screens.id = backend."ScreenId" ) x where "backend_ApplicationId" = 672 and ("backend_НоваяКолонка1_ad0dff7879"='123' and "screens_Name"='Home' and "backend_UpdateDate"='24.05.2018 18:17:58' and "objects_Email"='nzulfigarov@gmail.com')) ol
    [counterSql] => select count(backend_id) as "singleValue" from (select * from (select backend."id" as "backend_id", backend.id as "backend_abc", to_timestamp(to_char(backend."CreateDate"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "backend_CreateDate", to_timestamp(to_char(backend."UpdateDate"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "backend_UpdateDate", backend."ActionName" as "backend_ActionName", backend."Value" as "backend_Value", backend."ApplicationId" as "backend_ApplicationId", backend."ObjectId" as "backend_ObjectId", backend."BackendRead" as "backend_BackendRead", statuses."Name" as "backend_StatusName", statuses."FontColor" as "backend_StatusTextColor", statuses."BackgroundColor" as "backend_StatusBgColor", backend."paymentsystem" as "backend_paymentsystem", backend."paymentstatus" as "backend_paymentstatus", backend."fiscalstatus" as "backend_fiscalstatus", backend."SrcTemplate" as "backend_SrcTemplate", backend."SrcScreen" as "backend_SrcScreen", backend."SrcEvent" as "backend_SrcEvent", backend."SrcTrigger" as "backend_SrcTrigger", backend."SrcChannel" as "backend_SrcChannel", backend."MURead" as "backend_MURead", statuses."FontColor" as "statuses_FontColor", statuses."Name" as "statuses_Name", statuses."BackgroundColor" as "statuses_BackgroundColor", users."Name" as "users_Name", objects.id as "objects_id", objects.id as "abc", objects.id as "xyz", (SELECT MAX(case when "ColumnName" = 'new_colw' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_new_colw", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1_ad0dff7879' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1_ad0dff7879", screens."Name" as "screens_Name", objects."InviteStatus" as "objects_InviteStatus", objects."StartScreen" as "objects_StartScreen", objects."Enabled" as "objects_Enabled", objects."Transport" as "objects_Transport", to_timestamp(to_char(objects."LastLogin"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "objects_LastLogin", backend."StatusId" as "backend_StatusId", backend."Responsibleid" as "backend_Responsibleid", objects."Phone" as "objects_Phone", objects."Email" as "objects_Email", objects."Testval" as "objects_Testval", (SELECT MAX(case when "ColumnName" = 'Login_source' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_Login_source", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1_357624f4a4' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1_357624f4a4" from backend  left join objects on objects.id = backend."ObjectId"  left join statuses on statuses.id = backend."StatusId"  left join users on users.id = backend."Responsibleid"  left join screens on screens.id = backend."ScreenId" ) x where "backend_ApplicationId" = 672 and ("backend_НоваяКолонка1_ad0dff7879"='123' and "screens_Name"='Home' and "backend_UpdateDate"='24.05.2018 18:17:58' and "objects_Email"='nzulfigarov@gmail.com')) ol
    [gridSql] => select * from (select backend."id" as "backend_id", backend.id as "backend_abc", to_timestamp(to_char(backend."CreateDate"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "backend_CreateDate", to_timestamp(to_char(backend."UpdateDate"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "backend_UpdateDate", backend."ActionName" as "backend_ActionName", backend."Value" as "backend_Value", backend."ApplicationId" as "backend_ApplicationId", backend."ObjectId" as "backend_ObjectId", backend."BackendRead" as "backend_BackendRead", statuses."Name" as "backend_StatusName", statuses."FontColor" as "backend_StatusTextColor", statuses."BackgroundColor" as "backend_StatusBgColor", backend."paymentsystem" as "backend_paymentsystem", backend."paymentstatus" as "backend_paymentstatus", backend."fiscalstatus" as "backend_fiscalstatus", backend."SrcTemplate" as "backend_SrcTemplate", backend."SrcScreen" as "backend_SrcScreen", backend."SrcEvent" as "backend_SrcEvent", backend."SrcTrigger" as "backend_SrcTrigger", backend."SrcChannel" as "backend_SrcChannel", backend."MURead" as "backend_MURead", statuses."FontColor" as "statuses_FontColor", statuses."Name" as "statuses_Name", statuses."BackgroundColor" as "statuses_BackgroundColor", users."Name" as "users_Name", objects.id as "objects_id", objects.id as "abc", objects.id as "xyz", (SELECT MAX(case when "ColumnName" = 'new_colw' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_new_colw", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1_ad0dff7879' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1_ad0dff7879", screens."Name" as "screens_Name", objects."InviteStatus" as "objects_InviteStatus", objects."StartScreen" as "objects_StartScreen", objects."Enabled" as "objects_Enabled", objects."Transport" as "objects_Transport", to_timestamp(to_char(objects."LastLogin"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "objects_LastLogin", backend."StatusId" as "backend_StatusId", backend."Responsibleid" as "backend_Responsibleid", objects."Phone" as "objects_Phone", objects."Email" as "objects_Email", objects."Testval" as "objects_Testval", (SELECT MAX(case when "ColumnName" = 'Login_source' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_Login_source", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1_357624f4a4' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1_357624f4a4" from backend  left join objects on objects.id = backend."ObjectId"  left join statuses on statuses.id = backend."StatusId"  left join users on users.id = backend."Responsibleid"  left join screens on screens.id = backend."ScreenId" ) x where "backend_ApplicationId" = 672 and ("backend_НоваяКолонка1_ad0dff7879"='123' and "screens_Name"='Home' and "backend_UpdateDate"='24.05.2018 18:17:58' and "objects_Email"='nzulfigarov@gmail.com')
    [triggerSql] => Array
        (
            [autoAll] =>
            [autoNew] =>
            [manualAll] =>
            [manualNew] =>
        )

    [emergencyGridSql] => select * from (select backend."id" as "backend_id", backend.id as "backend_abc", to_timestamp(to_char(backend."CreateDate"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "backend_CreateDate", to_timestamp(to_char(backend."UpdateDate"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "backend_UpdateDate", backend."ActionName" as "backend_ActionName", backend."Value" as "backend_Value", backend."ApplicationId" as "backend_ApplicationId", backend."ObjectId" as "backend_ObjectId", backend."BackendRead" as "backend_BackendRead", statuses."Name" as "backend_StatusName", statuses."FontColor" as "backend_StatusTextColor", statuses."BackgroundColor" as "backend_StatusBgColor", backend."paymentsystem" as "backend_paymentsystem", backend."paymentstatus" as "backend_paymentstatus", backend."fiscalstatus" as "backend_fiscalstatus", backend."SrcTemplate" as "backend_SrcTemplate", backend."SrcScreen" as "backend_SrcScreen", backend."SrcEvent" as "backend_SrcEvent", backend."SrcTrigger" as "backend_SrcTrigger", backend."SrcChannel" as "backend_SrcChannel", backend."MURead" as "backend_MURead", statuses."FontColor" as "statuses_FontColor", statuses."Name" as "statuses_Name", statuses."BackgroundColor" as "statuses_BackgroundColor", users."Name" as "users_Name", objects.id as "objects_id", objects.id as "abc", objects.id as "xyz", (SELECT MAX(case when "ColumnName" = 'new_colw' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_new_colw", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1_ad0dff7879' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1_ad0dff7879", screens."Name" as "screens_Name", objects."InviteStatus" as "objects_InviteStatus", objects."StartScreen" as "objects_StartScreen", objects."Enabled" as "objects_Enabled", objects."Transport" as "objects_Transport", to_timestamp(to_char(objects."LastLogin"::timestamp with time zone at time zone 'Asia/Yekaterinburg', 'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')::timestamp without time zone as "objects_LastLogin", backend."StatusId" as "backend_StatusId", backend."Responsibleid" as "backend_Responsibleid", objects."Phone" as "objects_Phone", objects."Email" as "objects_Email", objects."Testval" as "objects_Testval", (SELECT MAX(case when "ColumnName" = 'Login_source' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_Login_source", (SELECT MAX(case when "ColumnName" = 'НоваяКолонка1_357624f4a4' then "ColumnValue" else NULL end) FROM backendext where "BackendId" = backend.id GROUP BY "BackendId") as "backend_НоваяКолонка1_357624f4a4" from backend  left join objects on objects.id = backend."ObjectId"  left join statuses on statuses.id = backend."StatusId"  left join users on users.id = backend."Responsibleid"  left join screens on screens.id = backend."ScreenId" ) x where "backend_ApplicationId" = 672
    [smartSorts] => Array
        (
        )

    [mask] => 01
)
Array
(
    [conditions] => "backend_НоваяКолонка1_ad0dff7879"='123' and "screens_Name"='Home' and "backend_UpdateDate"='24.05.2018 18:17:58' and "objects_Email"='nzulfigarov@gmail.com'
    [sorts] =>
    [agregates] =>
    [periods] =>
    [periods2] =>
    [custom] =>
)