1 x Application (93.89%) | 338ms |
1 x Booting (6.11%) | 21.97ms |
Backtrace |
|
select trim(rdb$field_name) as "name" from rdb$relation_fields where rdb$relation_name = 'EVENTS'
Backtrace |
|
select first 1 "EVENTS"."INVITATION_UPDATED_AT", "EVENTS"."EVENT_ID", "EVENTS"."DATE_BEGIN", "EVENTS"."DATE_END", "EVENTS"."CLUB_ID", "EVENTS"."CLUB_REG_ID", "EVENTS"."SEAT_COUNT", "EVENTS"."FEDERATION_REG_ID", "EVENTS"."TEAM_ID", "EVENTS"."WEBSITE", "EVENTS"."ADM_EMAIL", "EVENTS"."EVENT_NAME", "EVENTS"."CITY", "EVENTS"."COUNTRY", "EVENTS"."ORGANIZER", "EVENTS"."PLACE", "EVENTS"."ORG_FEDERATION", "EVENTS"."INTERNAL", "EVENTS"."FILE_NAME", "EVENTS"."PASS", "EVENTS"."ONE_REG_NUM", "EVENTS"."ORG_STRING", "EVENTS"."KIND", "EVENTS"."ACCESS_KEY", "EVENTS"."GUID", "EVENTS"."NOTES", "EVENTS"."REG_NOTES", "EVENTS"."PLACE_PERCENTAGE" from "EVENTS" where "EVENTS"."EVENT_ID" = 83
Bindings |
|
Backtrace |
|
select * from "EVENT_TAGS" where (coalesce(EVENT_TAGS.CONTEST_ID,0)=0) and "EVENT_TAGS"."EVENT_ID" in (83) order by "TAG_NAME" asc
Backtrace |
|
select * from "EV_EXTRA" where "EVENT_ID" = 83 order by "IND" asc
Bindings |
|
Backtrace |
|
select trim(rdb$field_name) as "name" from rdb$relation_fields where rdb$relation_name = 'CONTESTS'
Backtrace |
|
select "CONTESTS"."CREATED_AT", "CONTESTS"."UPDATED_AT", "CONTESTS"."DELETED_AT", "CONTESTS"."EVENT_ID", "CONTESTS"."CONTEST_ID", "CONTESTS"."DATE_BEGIN", "CONTESTS"."OFFICIAL_STATUS", "CONTESTS"."JUDGES_COUNT", "CONTESTS"."REG_NUM_START", "CONTESTS"."ROUNDS", "CONTESTS"."CREDANCE", "CONTESTS"."PRICE", "CONTESTS"."SINGLE_PRICE", "CONTESTS"."AGE_GROUP", "CONTESTS"."GROUP_NUM", "CONTESTS"."CNT_KIND", "CONTESTS"."MAX_MARK", "CONTESTS"."MIN_COUNT", "CONTESTS"."MAX_COUNT", "CONTESTS"."PROAM", "CONTESTS"."MAX_REG_COUNT", "CONTESTS"."MIN_AGE", "CONTESTS"."MAX_AGE", "CONTESTS"."TARIFF_GROUP", "CONTESTS"."PROGRAM", "CONTESTS"."STATUS", "CONTESTS"."GROUP_NAME", "CONTESTS"."CONTEST_NAME", "CONTESTS"."RATING_STATUS", "CONTESTS"."HAS_REDANCE", "CONTESTS"."OPEN_CLASS", "CONTESTS"."EXTRA_DANCES", "CONTESTS"."USE_INTERNATIONAL", "CONTESTS"."SOLO", "CONTESTS"."J_N_J", "CONTESTS"."PLUS_ONE_POINT", "CONTESTS"."COMMAND", "CONTESTS"."GUID", "CONTESTS"."COMMENT", "CONTESTS"."EXPERIENCE", "CONTESTS"."COVER_GUID" from "CONTESTS" where "EVENT_ID" = 83
Bindings |
|
Backtrace |
|
select * from "EVENT_TAGS" where "EVENT_TAGS"."CONTEST_ID" in (27609, 27610, 27611, 27612, 27613, 27614, 27615, 27616, 27617, 27618, 27619, 27620, 27621, 27622, 27623, 27624, 27625, 27626, 27627, 27628, 27629, 27630, 27631, 27632, 27633, 27634, 27635, 27636, 27637, 27638, 27639, 27640, 27641, 27642, 27643, 27644, 27645, 27646, 27647, 27648, 27649, 27650, 27651, 27652, 27653, 27654, 27655, 27656, 27657, 27658, 27659, 27660, 27661, 27662, 27663, 27664, 27665, 27666, 27667, 27668, 27669, 27670, 27671, 27672, 27673, 27674, 27675, 27676, 27677, 27678, 27679, 27680, 27681, 27682, 27683, 27684, 27685, 28064, 28065, 28172, 28173, 28366, 28375, 28376, 28377, 28378, 28380, 28381, 28388, 28389, 28390, 28391, 28392, 28404, 28405, 28406, 28407) order by "TAG_NAME" asc
Backtrace |
|
select trim(rdb$field_name) as "name" from rdb$relation_fields where rdb$relation_name = 'REGISTRATION'
Backtrace |
|
select "REGISTRATION"."CREATED_AT", "REGISTRATION"."UPDATED_AT", "REGISTRATION"."DELETED_AT", "REGISTRATION"."CONTEST_ID", "REGISTRATION"."CLUB_ID", "REGISTRATION"."START_IN_ROUND", "REGISTRATION"."COACH_ID", "REGISTRATION"."COACH2_ID", "REGISTRATION"."REG_N", "REGISTRATION"."CLUB_REG_ID", "REGISTRATION"."CLASS_ID", "REGISTRATION"."COACH_REG_ID", "REGISTRATION"."COACH2_REG_ID", "REGISTRATION"."NAME", "REGISTRATION"."EMAIL", "REGISTRATION"."PHONE", "REGISTRATION"."EDIT_CODE", "REGISTRATION"."CITY", "REGISTRATION"."CLUB", "REGISTRATION"."SKIP_REDANCE", "REGISTRATION"."PREDV_REG", "REGISTRATION"."COACH", "REGISTRATION"."GUID", "REGISTRATION"."NOTES", "REGISTRATION"."PACKET_GUID", (coalesce((SELECT SUM(cast(P.AMOUNT as numeric(8,2))) FROM PAYMENTS P where p.REG_GUID = REGISTRATION.GUID), 0)) as SUM_OF_PAYMENTS, (coalesce((SELECT COUNT(P.AMOUNT) FROM PAYMENTS P where p.REG_GUID = REGISTRATION.GUID), 0)) as COUNT_OF_PAYMENTS from "REGISTRATION" where REGISTRATION.CONTEST_ID in (SELECT CONTEST_ID FROM CONTESTS WHERE EVENT_ID=83) order by "REGISTRATION"."REG_N" asc
Backtrace |
|
select first 1 "CONTESTS"."CREATED_AT", "CONTESTS"."UPDATED_AT", "CONTESTS"."DELETED_AT", "CONTESTS"."EVENT_ID", "CONTESTS"."CONTEST_ID", "CONTESTS"."DATE_BEGIN", "CONTESTS"."OFFICIAL_STATUS", "CONTESTS"."JUDGES_COUNT", "CONTESTS"."REG_NUM_START", "CONTESTS"."ROUNDS", "CONTESTS"."CREDANCE", "CONTESTS"."PRICE", "CONTESTS"."SINGLE_PRICE", "CONTESTS"."AGE_GROUP", "CONTESTS"."GROUP_NUM", "CONTESTS"."CNT_KIND", "CONTESTS"."MAX_MARK", "CONTESTS"."MIN_COUNT", "CONTESTS"."MAX_COUNT", "CONTESTS"."PROAM", "CONTESTS"."MAX_REG_COUNT", "CONTESTS"."MIN_AGE", "CONTESTS"."MAX_AGE", "CONTESTS"."TARIFF_GROUP", "CONTESTS"."PROGRAM", "CONTESTS"."STATUS", "CONTESTS"."GROUP_NAME", "CONTESTS"."CONTEST_NAME", "CONTESTS"."RATING_STATUS", "CONTESTS"."HAS_REDANCE", "CONTESTS"."OPEN_CLASS", "CONTESTS"."EXTRA_DANCES", "CONTESTS"."USE_INTERNATIONAL", "CONTESTS"."SOLO", "CONTESTS"."J_N_J", "CONTESTS"."PLUS_ONE_POINT", "CONTESTS"."COMMAND", "CONTESTS"."GUID", "CONTESTS"."COMMENT", "CONTESTS"."EXPERIENCE", "CONTESTS"."COVER_GUID" from "CONTESTS" where "EVENT_ID" = 83 and "GROUP_NUM" = 27
Bindings |
|
Backtrace |
|
select
tg.ID, tg.EVENT_ID, tg.TARIFF_GROUP_NAME,
td.DATE_BEGIN, td.PRICE
from TARIFF_GROUPS tg
left join TARIFF_DATES td on td.TARIFF_ID = tg.ID
where tg.EVENT_ID = :eventId
order by tg.TARIFF_GROUP_NAME, td.DATE_BEGIN
Bindings |
|
Backtrace |
|
select "CONTESTS"."GROUP_NUM", "CONTESTS"."CONTEST_ID", "CONTESTS"."GROUP_NAME", "CONTESTS"."GUID", "CONTESTS"."MIN_AGE", "CONTESTS"."MAX_AGE", "CONTESTS"."MIN_COUNT", "CONTESTS"."MAX_COUNT", "CONTESTS"."STATUS" from "CONTESTS" where "CONTESTS"."EVENT_ID" = 83 and "CONTESTS"."MIN_AGE" <= 12 and "CONTESTS"."MAX_AGE" >= 14 and "CONTESTS"."MIN_COUNT" <= 2 and "CONTESTS"."MAX_COUNT" >= 2
Bindings |
|
Backtrace |
|
select * from "EVENT_TAGS" where "EVENT_TAGS"."CONTEST_ID" in (27618, 27619, 27624, 27633, 27634, 27635, 27650, 27679) order by "TAG_NAME" asc
Backtrace |
|
select * from "REGISTRATION" where "REGISTRATION"."CONTEST_ID" = 27635 and "REGISTRATION"."CONTEST_ID" is not null order by "REG_N" asc
Bindings |
|
Backtrace |
|
select * from "REG_DANCERS" where "REG_DANCERS"."REG_GUID" in ('5EBEB105-9995-441F-944E-7501169F568D')
Bindings |
|
Backtrace |
|
select * from "PAYMENTS" where "PAYMENTS"."REG_GUID" in ('5EBEB105-9995-441F-944E-7501169F568D')
Bindings |
|
Backtrace |
|
select * from "PAYMENTS" where "PAYMENTS"."REG_GUID" = '58ABBFE0-FBC3-449B-AE19-D210FAF859E0' and "PAYMENTS"."REG_GUID" is not null
Bindings |
|
Backtrace |
|
select * from "EVENT_TAGS" where "EVENT_TAGS"."CONTEST_ID" = 27635 and "EVENT_TAGS"."CONTEST_ID" is not null order by "TAG_NAME" asc
Bindings |
|
Backtrace |
|
200
0 of 0array:1 [▼ "ds" => "social" ]
[]
0 of 0array:8 [▼ "host" => array:1 [▶ 0 => "66.danceoffice.online" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate" ] ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Mon, 30 Dec 2024 01:47:48 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjUzQ2VOVk5wcHV4ZlhKVWIvUmxxbVE9PSIsInZhbHVlIjoiNHdWYmRCSzd1VVNvL3Y1U2NwZHVDdXBoZ2RoWHhkWEhuSzVqV1lFZGRGSERVeUNTU2l3NDhlaUx4bm82ZmU1VHptNkdUTEJyRWFVTW16ZFY2cmlUQnc2eG9WY0svWUFWWCtKeFRhZWJhMmZyTFd2OE1NcmsySGt1U0RsKzFmNmwiLCJtYWMiOiI4YWU3OWQxNDM0ZTMxOTI4OTQ1OTBhNDU3ZjVkYzZhZDBhZmU0OTIzOTNiNmVkMDVhNjU0YWYwNDE2MmE3NTAyIiwidGFnIjoiIn0%3D; expires=Mon, 30 Dec 2024 03:47:48 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjUzQ2VOVk5wcHV4ZlhKVWIvUmxxbVE9PSIsInZhbHVlIjoiNHdWYmRCSzd1VVNvL3Y1U2NwZHVDdXBoZ2RoWHhkWEhuSzVqV1lFZGRGSERVeUNTU2l3NDhlaUx4bm82ZmU1VHptNkdUT ▶" 1 => "danceofficeonline_session=eyJpdiI6InUvWUhGSUpvS1NCd0VBSUorcDJyTnc9PSIsInZhbHVlIjoiSmY4UjVIMmhlRU5xQjdndVdyRVNXSjVadzBOdEpEVVR4cjNuRU9rL0dWWkxiRXo0SHVpVnlpVW9BWVZlMGEvSnZIMm9XQ1N5bEJ1VnVERDV5clNmSTM0NzJHcThWMkMrd2RQdXhDUEhqeTRsNS9LTkJJRExEU3F6bnYzVkhzZEgiLCJtYWMiOiIwMjk2OWUyMmYzYjI4NTg1MGI1OTM4YmFkMTE3OTJjMzQyOWQxYTU4YzEwMmRhOGM0NDY5N2UzOGFjOGRhNjdjIiwidGFnIjoiIn0%3D; expires=Mon, 30 Dec 2024 03:47:48 GMT; Max-Age=7200; path=/; httponly ◀danceofficeonline_session=eyJpdiI6InUvWUhGSUpvS1NCd0VBSUorcDJyTnc9PSIsInZhbHVlIjoiSmY4UjVIMmhlRU5xQjdndVdyRVNXSjVadzBOdEpEVVR4cjNuRU9rL0dWWkxiRXo0SHVpVnlpVW9BWV ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjUzQ2VOVk5wcHV4ZlhKVWIvUmxxbVE9PSIsInZhbHVlIjoiNHdWYmRCSzd1VVNvL3Y1U2NwZHVDdXBoZ2RoWHhkWEhuSzVqV1lFZGRGSERVeUNTU2l3NDhlaUx4bm82ZmU1VHptNkdUTEJyRWFVTW16ZFY2cmlUQnc2eG9WY0svWUFWWCtKeFRhZWJhMmZyTFd2OE1NcmsySGt1U0RsKzFmNmwiLCJtYWMiOiI4YWU3OWQxNDM0ZTMxOTI4OTQ1OTBhNDU3ZjVkYzZhZDBhZmU0OTIzOTNiNmVkMDVhNjU0YWYwNDE2MmE3NTAyIiwidGFnIjoiIn0%3D; expires=Mon, 30-Dec-2024 03:47:48 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjUzQ2VOVk5wcHV4ZlhKVWIvUmxxbVE9PSIsInZhbHVlIjoiNHdWYmRCSzd1VVNvL3Y1U2NwZHVDdXBoZ2RoWHhkWEhuSzVqV1lFZGRGSERVeUNTU2l3NDhlaUx4bm82ZmU1VHptNkdUT ▶" 1 => "danceofficeonline_session=eyJpdiI6InUvWUhGSUpvS1NCd0VBSUorcDJyTnc9PSIsInZhbHVlIjoiSmY4UjVIMmhlRU5xQjdndVdyRVNXSjVadzBOdEpEVVR4cjNuRU9rL0dWWkxiRXo0SHVpVnlpVW9BWVZlMGEvSnZIMm9XQ1N5bEJ1VnVERDV5clNmSTM0NzJHcThWMkMrd2RQdXhDUEhqeTRsNS9LTkJJRExEU3F6bnYzVkhzZEgiLCJtYWMiOiIwMjk2OWUyMmYzYjI4NTg1MGI1OTM4YmFkMTE3OTJjMzQyOWQxYTU4YzEwMmRhOGM0NDY5N2UzOGFjOGRhNjdjIiwidGFnIjoiIn0%3D; expires=Mon, 30-Dec-2024 03:47:48 GMT; path=/; httponly ◀danceofficeonline_session=eyJpdiI6InUvWUhGSUpvS1NCd0VBSUorcDJyTnc9PSIsInZhbHVlIjoiSmY4UjVIMmhlRU5xQjdndVdyRVNXSjVadzBOdEpEVVR4cjNuRU9rL0dWWkxiRXo0SHVpVnlpVW9BWV ▶" ] ]
0 of 0array:5 [▼ "_token" => "qliWNEzX9JdbOiTJQwqOhAued86oZYzA6niTgyA9" "event" => App\Http\Model\Event {#1811 ▶ +"ACCESS_KEY": "811047" +"ADM_EMAIL": "kubokrussia@ya.ru;El.lisunov@ya.ru" +"CITY": "Екатеринбург" +"CLUB_ID": null +"CLUB_REG_ID": null +"COUNTRY": "Россия" +"DATE_BEGIN": "2023-05-06" +"DATE_END": "2023-05-06" +"EVENT_ID": 83 +"EVENT_NAME": "Кубок России. День 1" +"FEDERATION_REG_ID": 96 +"FILE_NAME": "Polozhenie_KR_6_maya_2022__4.pdf" +"GUID": "63414BB9-436E-424B-82D3-7FBF956030F5" +"INTERNAL": 1 +"INVITATION_UPDATED_AT": null +"KIND": null +"NOTES": null +"ONE_REG_NUM": 1 +"ORGANIZER": "2Dance" +"ORG_FEDERATION": null +"ORG_STRING": "" +"PASS": "" +"PLACE": "ЦК «Урал», Студенческая, 3" +"PLACE_PERCENTAGE": null +"REG_NOTES": null +"SEAT_COUNT": 0 +"TEAM_ID": 3 +"WEBSITE": "" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: array:1 [▶ "tags" => Illuminate\Database\Eloquent\Collection {#1880 ▶ #items: array:6 [▶ 0 => App\Http\Model\EventTag {#1852 ▶ +"CONTEST_ID": 0 +"EVENT_ID": 83 +"GUID": "06DD5055-187E-4FA8-B6B1-7749684D7B85" +"TAG_GROUP": null +"TAG_NAME": "DO-REG" +"TAG_VALUE": null isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 1 => App\Http\Model\EventTag {#1909 ▶ +"CONTEST_ID": 0 +"EVENT_ID": 83 +"GUID": "5670E5BF-EEAA-4CE4-BD7F-811483A2A01F" +"TAG_GROUP": null +"TAG_NAME": "JUDGES" +"TAG_VALUE": null isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 2 => App\Http\Model\EventTag {#1908 ▶ +"CONTEST_ID": 0 +"EVENT_ID": 83 +"GUID": "3A3BC3FE-5F19-429D-A3BD-0683F15754F4" +"TAG_GROUP": null +"TAG_NAME": "PAY-GROUP" +"TAG_VALUE": "2000" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 3 => App\Http\Model\EventTag {#1907 ▶ +"CONTEST_ID": 0 +"EVENT_ID": 83 +"GUID": "2231E3E7-A623-44D4-A90D-B57352B9711F" +"TAG_GROUP": null +"TAG_NAME": "PAY-LINK" +"TAG_VALUE": null isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 4 => App\Http\Model\EventTag {#1906 ▶ +"CONTEST_ID": 0 +"EVENT_ID": 83 +"GUID": "65F5EF13-EB5E-474D-AC51-EC99D9165C55" +"TAG_GROUP": null +"TAG_NAME": "SOCIAL" +"TAG_VALUE": null isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 5 => App\Http\Model\EventTag {#1905 ▶ +"CONTEST_ID": 0 +"EVENT_ID": 83 +"GUID": "0D9181A3-4184-429C-93C9-EEA3B89B2E60" +"TAG_GROUP": null +"TAG_NAME": "TABLO" +"TAG_VALUE": "1" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } ] #escapeWhenCastingToString: false } ] …40 } "ds" => "social" "_previous" => array:1 [▶ "url" => "http://66.danceoffice.online/events/83/groups/27/reg-list?ds=social" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]