[1331] Шоу формейшн смешанные группы СД

(1924-2021 г.р.)
Результаты
Статус: Завершен
Request history8.3.14PHP Version372msRequest Duration26MBMemory UsageGET events/{eventId}/groups/{groupNum}/reg-list/{regn?}Route
  • warninglog[04:30:12] LOG.warning: Creation of dynamic property Illuminate\Database\Eloquent\Builder::$columns ...
  • warninglog[04:30:12] LOG.warning: Creation of dynamic property Illuminate\Database\Eloquent\Builder::$columns ...
  • warninglog[04:30:12] LOG.warning: explode(): Passing null to parameter #2 ($string) of type string is deprecat...
  • Booting (7.86ms)time
  • Application (364ms)time
  • 1 x Application (97.89%)
    364ms
    1 x Booting (2.11%)
    7.86ms
    20 templates were rendered
    • contest.contest-reg-listcontest-reg-list.blade.php#?blade
    • contest.partial.soundtrack-upload-modalsoundtrack-upload-modal.blade.php#?blade
    • contest.partial.soundtrack-listen-modalsoundtrack-listen-modal.blade.php#?blade
    • contest.partial.soundtrack-delete-modalsoundtrack-delete-modal.blade.php#?blade
    • contest.partial.copy-to-another-group-modalcopy-to-another-group-modal.blade.php#?blade
    • contest.partial.edit-registration-notes-modaledit-registration-notes-modal.blade.php#?blade
    • contest.registration-table.change-reg-num-modalchange-reg-num-modal.blade.php#?blade
    • contest.registration-table.change-packet-modalchange-packet-modal.blade.php#?blade
    • contest.contest-reg-list-contentcontest-reg-list-content.blade.php#?blade
    • layouts.partial.common-modalcommon-modal.blade.php#?blade
    • contest.registration-table.registration-tableregistration-table.blade.php#?blade
    • contest.registration-table.see-details-modalsee-details-modal.blade.php#?blade
    • layouts.basicbasic.blade.php#?blade
    • contest.partial.login-modallogin-modal.blade.php#?blade
    • layouts.partial.navigationnavigation.blade.php#?blade
    • layouts.partial.headerheader.blade.php#?blade
    • layouts.partial.header-desktopheader-desktop.blade.php#?blade
    • layouts.partial.select-logoselect-logo.blade.php#?blade
    • layouts.partial.nav-login-blocknav-login-block.blade.php#?blade
    • layouts.basic-cleanbasic-clean.blade.php#?blade
    uri
    GET events/{eventId}/groups/{groupNum}/reg-list/{regn?}
    middleware
    web
    controller
    App\Http\Controllers\ContestController@contestRegList
    namespace
    App\Http\Controllers
    prefix
    where
    as
    contest-reg-list
    file
    app/Http/Controllers/ContestController.php:36-103
    18 statements were executed199ms
    • EventService.php#104as7.2dConnection Established
      Backtrace
      • app/Services/EventService.php:104
      • app/Services/EventService.php:63
      • app/Http/Controllers/ContestController.php:39
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • MyModel.php#31as7.2d21.54msselect trim(rdb$field_name) as "name" from rdb$relation_fields where rdb$relation_name = 'EVENTS'
      Backtrace
      • app/Http/Model/MyModel.php:31
      • app/Http/Model/MyModel.php:62
      • app/Services/EventService.php:106
      • app/Services/EventService.php:63
      • app/Http/Controllers/ContestController.php:39
    • EventService.php#108as7.2d11.21msselect 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" = 140
      Bindings
      • 0: 140
      Backtrace
      • app/Services/EventService.php:108
      • app/Services/EventService.php:63
      • app/Http/Controllers/ContestController.php:39
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • EventService.php#108as7.2d2.9msselect * from "EVENT_TAGS" where (coalesce(EVENT_TAGS.CONTEST_ID,0)=0) and "EVENT_TAGS"."EVENT_ID" in (140) order by "TAG_NAME" asc
      Backtrace
      • app/Services/EventService.php:108
      • app/Services/EventService.php:63
      • app/Http/Controllers/ContestController.php:39
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • EventService.php#227as7.2d1.43msselect * from "EV_EXTRA" where "EVENT_ID" = 140 order by "IND" asc
      Bindings
      • 0: 140
      Backtrace
      • app/Services/EventService.php:227
      • app/Services/EventService.php:112
      • app/Services/EventService.php:63
      • app/Http/Controllers/ContestController.php:39
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • MyModel.php#31as7.2d1.12msselect trim(rdb$field_name) as "name" from rdb$relation_fields where rdb$relation_name = 'CONTESTS'
      Backtrace
      • app/Http/Model/MyModel.php:31
      • app/Http/Model/MyModel.php:62
      • app/Services/EventService.php:1233
      • app/Http/Controllers/ContestController.php:41
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • EventService.php#1243as7.2d27.6msselect "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" = 140
      Bindings
      • 0: 140
      Backtrace
      • app/Services/EventService.php:1243
      • app/Http/Controllers/ContestController.php:41
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • EventService.php#1243as7.2d12.87msselect * from "EVENT_TAGS" where "EVENT_TAGS"."CONTEST_ID" in (55949, 55950, 55951, 55952, 55953, 55954, 55955, 55956, 55957, 55958, 55959, 55960, 55961, 55962, 55963, 55964, 55965, 55966, 55967, 55968, 55969, 55970, 55971, 55972, 55973, 55974, 55975, 55976, 55977, 55978, 55979, 55980, 55981, 55982, 55983, 55984, 55985, 55986, 55987, 55988, 55989, 55990, 55991, 55992, 55993, 55994, 55995, 55996, 55997, 55998, 55999, 56000, 56001, 56002, 56003, 56004, 56005, 56006, 56007, 56008, 56009, 56010, 56011, 56012, 56013, 56014, 56015, 56016, 56017, 56018, 56019, 56020, 56021, 56022, 56023, 56024, 56025, 56026, 56027, 56028, 56029, 56030, 56031, 56032, 56033, 56034, 56035, 56036, 56037, 56038, 56039, 56040, 56041, 56042, 56043, 56044, 56045, 56046, 56047, 56048, 56049, 56050, 56051, 56052, 56053, 56054, 56055, 56056, 56057, 56058, 56059, 56060, 56061, 56062, 56063, 56064, 56065, 56066, 56067, 56068, 56069, 56070, 56071, 56072, 56073, 56074, 56075, 56076, 56077, 56078, 56079, 56080, 56081, 56082, 56083, 56084, 56085, 56086, 56087, 56088, 56089, 56090, 56091, 56092, 56093, 56094, 56095, 56096, 56097, 56098, 56099, 56100, 56101, 56102, 56103, 56104, 56105, 56106, 56107, 56108, 56109, 56110, 56111, 56112, 56113, 56114, 56115, 56116, 56117, 56118, 56119, 56120, 56121, 56122, 56123, 56124, 56125, 56126, 56127, 56128, 56129, 56130, 56131, 56132, 56133, 56134, 56135, 56136, 56137, 56138, 56139, 56140, 56141, 56142, 56143, 56144, 56145, 56146, 56147, 56148, 56149, 56150, 56151, 56152, 56153, 56154, 56155, 56156, 56157, 56158, 56159, 56160, 56161, 56162, 56163, 56164, 56165, 56166, 56167, 56168, 56169, 56170, 56171, 56172, 56173, 56174, 56175, 56176, 56177, 56178, 56179, 56180, 56181, 56182, 56183, 56184, 56185, 56186, 56187, 56188, 56189, 56190, 56191, 56192, 56193, 56194, 56195, 56196, 56197, 56198, 56199, 56200, 56201, 56202, 56203, 56204, 56205, 56206, 56207, 56208, 56209, 56210, 56211, 56212, 56213, 56214, 56215, 56216, 56217, 56218, 56219, 56220, 56221, 56222, 56223, 56224, 56225, 56226, 56227, 56228, 56229, 56230, 56231, 56232, 56233, 56234, 56235, 56236, 56237, 56238, 56239, 56240, 56241, 56242, 56243, 56244, 56245, 56246, 56247, 56248, 56249, 56250, 56251, 56252, 56253, 56254, 56255, 56256, 56257, 56258, 56259, 56260, 56261, 56262, 56263, 56264, 56265, 56266, 56267, 56268, 56269, 56270, 56271, 56272, 56273, 56274, 56275, 56276, 56277, 56278, 56279, 56280, 56281, 56282, 56283, 56284, 56285, 56286, 56287, 56288, 56289, 56290, 56291, 56292, 56293, 56294, 56295, 56296, 56297, 56298, 56299, 56300, 56301, 56302, 56303, 56304, 56305, 56306, 56307, 56308, 56309, 56310, 56311, 56312, 56313, 56314, 56315, 56316, 56317, 56318, 56319, 56320, 56321, 56322, 56323, 56324, 56325, 56326, 56327, 56328, 56329, 56330, 56331, 56332, 56333, 56334, 56335, 56336, 56337, 56338, 56339, 56340, 56341, 56342, 56343, 56344, 56345, 56346, 56347, 56348, 56349, 56350, 56351, 56352, 56353, 56354, 56355, 56356, 56357, 56358, 56359, 56360, 56361, 56362, 56363, 56364, 56365, 56366, 56367, 56368, 56369, 56370, 56371, 56372, 56373, 56374, 56375, 56376, 56377, 56378, 56379, 56380, 56381, 56382, 56383, 56384, 56385, 56386, 56387, 56388, 56389, 56390, 56391, 56392, 56393, 56394, 56395, 56396, 56397, 56398, 56399, 56400, 56401, 56402, 56403, 56404, 56405, 56406, 56407, 56408, 56409, 56410, 56411, 56412, 56413, 56414, 56415, 56416, 56417, 56418, 56419, 56420, 56421, 56422, 56423, 56424, 56425, 56426, 56427, 56428, 56429, 56430, 56431, 56432, 56433, 56434, 56435, 56436, 56437, 56438, 56439, 56440, 56441, 56442, 56443, 56444, 56445, 56446, 56447, 56448, 56449, 56450, 56451, 56452, 56453, 56454, 56455, 56456, 56457, 56458, 56459, 56460, 56461, 56462, 56463, 56464, 56465, 56466, 56467, 56468, 56469, 56470, 56471, 56472, 56473, 56474, 56475, 56476, 56477, 56478, 56479, 56480, 56481, 56482, 56483, 56484, 56485, 56486, 56487, 56488, 56489, 56490, 56491, 56492, 56493, 56494, 56495, 56496, 56497, 56498, 56499, 56500, 56501, 56502, 56503, 56504, 56505, 56506, 56507, 56508, 56509, 56510, 56511, 56512, 56513, 56514, 56515, 56516, 56517, 56518, 56519, 56520, 56521, 56522, 56523, 56524, 56525, 56526, 56527, 56528, 56529, 56530, 56531, 56532, 56533, 56534, 56535, 56536, 56537, 56538, 56539, 56540, 56541, 56542, 56543, 56544, 56545, 56546, 56547, 56548, 56549, 56550, 56551, 56552, 56553, 56554, 56555, 56556, 56557, 56558, 56559, 56560, 56561, 56562, 56563, 56564, 56565, 56566, 56567, 56568, 56569, 56570, 56571, 56572, 56573, 56574, 56575, 56576, 56577, 56578, 56579, 56580, 56581, 56582, 56583, 56584, 56585, 56586, 56587, 56588, 56589, 56590, 56591, 56592, 56593, 56594, 56595, 56596, 56597, 56598, 56599, 56600, 56601, 56602, 56603, 56604, 56605, 56606, 56607, 56608, 56609, 56610, 56611, 56612, 56613, 56614, 56615, 56616, 56617, 56618, 56619, 56620, 56621, 56622, 56623, 56624, 56625, 56626, 56627, 56628, 56629, 56630, 56631, 56632, 56633, 56634, 56635, 56636, 56637, 56638, 56639, 56640, 56641, 56642, 56643, 56644, 56645, 56646, 56647, 56648, 56649, 56650, 56651, 56652, 56653, 56654, 56655, 56656, 56657, 56658, 56659, 56660, 56661, 56662, 56663, 56664, 56665, 56666, 56667, 56668, 56669, 56670, 56671, 56672, 56673, 56674, 56675, 56676, 56677, 56678, 56679, 56680, 56681, 56682, 56683, 56684, 56685, 56686, 56687, 56688, 56689, 56690, 56691, 56692, 56693, 56694, 56695, 56696, 56697, 56698, 56699, 56700, 56701, 56702, 56703, 56704, 56705, 56706, 56707, 56708, 56709, 56710, 56711, 56712, 56713, 56714, 56715, 56716, 56717, 56718, 56719, 56720, 56721, 56722, 56723, 56724, 56725, 56726, 56727, 56728, 56729, 56730, 56731, 56732, 56733, 56734, 56735, 56736, 56737, 56738, 56739, 56740, 56741, 56742, 56743, 56744, 56745, 56746, 56747, 56748, 56749, 56750, 56751, 56752, 56753, 56754, 56755, 56756, 56757, 56758, 56759, 56760, 56761, 56762, 56763, 56764, 56765, 56766, 56767, 56768, 56769, 56770, 56771, 56772, 56773, 56774, 56775, 56776, 56777, 56778, 56779, 56780, 56781, 56782, 56783, 56784, 56785, 56786, 56787, 56788, 56789, 56790, 56791, 56792, 56793, 56794, 56795, 56796, 56797, 56798, 56799, 56800, 56801, 56802, 56803, 56804, 56805, 56806, 56807, 56808, 56809, 56810, 56811, 56812, 56813, 56814, 56815, 56816, 56817, 56818, 56819, 56820, 56821, 56822, 56823, 56824, 56825, 56826, 56827, 56828, 56829, 56830, 56831, 56832, 56833, 56834, 56835, 56836, 56837, 56838, 56839, 56840, 56841, 56842, 56843, 56844, 56845, 56846, 56847, 56848, 56849, 56850, 56851, 56852, 56853, 56854, 56855, 56856, 56857, 56858, 56859, 56860, 56861, 56862, 56863, 56864, 56865, 56866, 56867, 56868, 56869, 56870, 56871, 56872, 56873, 56874, 56875, 56876, 56877, 56878, 56879, 56880, 56881, 56882, 56883, 56884, 56885, 56886, 56887, 56888, 56889, 56890, 56891, 56892, 56893, 56894, 56895, 56896, 56897, 56898, 56899, 56900, 56901, 56902, 56903, 56904, 56905, 56906, 56907, 56908, 56909, 56910, 56911, 56912, 56913, 56914, 56915, 56916, 56917, 56918, 56919, 56920, 56921, 56922, 56923, 56924, 56925, 56926, 56927, 56928, 56929, 56930, 56931, 56932, 56933, 56934, 56935, 56936, 56937, 56938, 56939, 56940, 56941, 56942, 56943, 56944, 56945, 56946, 56947, 56948, 56949, 56950, 56951, 56952, 56953, 56954, 56955, 56956, 56957, 56958, 56959, 56960, 56961, 56962, 56963, 56964, 56965, 56966, 56967, 56968, 56969, 56970, 56971, 56972, 56973, 56974, 56975, 56976, 56977, 56978, 56979, 56980, 56981, 56982, 56983, 56984, 56985, 56986, 56987, 56988, 56989, 56990, 56991, 56992, 56993, 56994, 56995, 56996, 56997, 56998, 56999, 57000, 57001, 57002, 57003, 57004, 57005, 57006, 57007, 57008, 57009, 57010, 57011, 57012, 57013, 57014, 57015, 57016, 57017, 57018, 57019, 57020, 57021, 57022, 57023, 57024, 57025, 57026, 57027, 57028, 57029, 57030, 57031, 57032, 57033, 57034, 57035, 57036, 57037, 57038, 57039, 57040, 57041, 57042, 57043, 57044, 57045, 57046, 57047, 57048, 57049, 57050, 57051, 57052, 57053, 57054, 57055, 57056, 57057, 57058, 57059, 57060, 57061, 57062, 57063, 57064, 57065, 57066, 57067, 57068, 57069, 57071, 57072, 57073, 57074, 57075, 57076, 57077, 57078, 57079, 57080, 57081, 57082, 57083, 57084, 57085, 57086, 57087, 57088, 57089, 57090, 57091, 57092, 57093, 57094, 57095, 57096, 57097, 57098, 57099, 57100, 57101, 57102, 57103, 57104, 57105, 57106, 57107, 57108, 57109, 57110, 57111, 57112, 57113, 57114, 57115, 57116, 57117, 57118, 57119, 57120, 57121, 57122, 57123, 57124, 57125, 57126, 57127, 57128, 57129, 57130, 57131, 57132, 57133, 57134, 57135, 57136, 57137, 57138, 57139, 57140, 57141, 57142, 57143, 57144, 57145, 57146, 57147, 57148, 57149, 57150, 57151, 57152, 57153, 57154, 57155, 57156, 57157, 57158, 57159, 57160, 57161, 57162, 57163, 57164, 57165, 57166, 57167, 57168, 57169, 57170, 57171, 57172, 57173, 57174, 57175, 57176, 57177, 57178, 57179, 57180, 57181, 57182, 57183, 57184, 57185, 57186, 57187, 57188, 57189, 57190, 57191, 57192, 57193, 57194, 57195, 57196, 57197, 57198, 57199, 57200, 57201, 57202, 57203, 57204, 57205, 57206, 57207, 57208, 57209, 57210, 57211, 57212, 57213, 57214, 57215, 57216, 57217, 57218, 57219, 57220, 57221, 57222, 57223, 57224, 57225, 57226, 57227, 57228, 57229, 57230, 57231, 57232, 57233, 57234, 57235, 57236, 57237, 57238, 57239, 57240, 57241, 57242, 57243, 57244, 57245, 57246, 57247, 57248, 57249, 57250, 57251, 57252, 57253, 57254, 57255, 57256, 57257, 57258, 57259, 57356, 62294, 62295, 62296, 62297, 62298, 62299, 62300, 62301, 62302, 62312, 62313, 62314, 62315, 62319, 62320, 62321, 62322, 62323, 62324, 63852, 63853, 63854, 63855, 63856, 63857, 63858, 63859, 63864, 63865, 63871, 63875, 65378, 65379, 65380, 65381) order by "TAG_NAME" asc
      Backtrace
      • app/Services/EventService.php:1243
      • app/Http/Controllers/ContestController.php:41
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • MyModel.php#31as7.2d1.28msselect trim(rdb$field_name) as "name" from rdb$relation_fields where rdb$relation_name = 'REGISTRATION'
      Backtrace
      • app/Http/Model/MyModel.php:31
      • app/Http/Model/MyModel.php:62
      • app/Http/Model/MyModel.php:47
      • app/Http/Model/Registration.php:51
      • app/Services/EventService.php:1375
    • EventService.php#1377as7.2d102msselect "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=140) order by "REGISTRATION"."REG_N" asc
      Backtrace
      • app/Services/EventService.php:1377
      • app/Http/Controllers/ContestController.php:42
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • ContestService.php#168as7.2d3.69msselect 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" = 140 and "GROUP_NUM" = 1331
      Bindings
      • 0: 140
      • 1: 1331
      Backtrace
      • app/Services/ContestService.php:168
      • app/Services/ContestService.php:85
      • app/Http/Controllers/ContestController.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • TariffService.php#39as7.2d2.53msselect 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
      • eventId: 140
      Backtrace
      • app/Services/TariffService.php:39
      • app/Services/EventService.php:95
      • app/Http/Controllers/ContestController.php:45
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • ContestService.php#1264as7.2d2.87msselect "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" = 140 and "CONTESTS"."MIN_AGE" <= 3 and "CONTESTS"."MAX_AGE" >= 100 and "CONTESTS"."MIN_COUNT" <= 3 and "CONTESTS"."MAX_COUNT" >= 20
      Bindings
      • 0: 140
      • 1: 3
      • 2: 100
      • 3: 3
      • 4: 20
      Backtrace
      • app/Services/ContestService.php:1264
      • app/Http/Controllers/ContestController.php:62
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • ContestService.php#1264as7.2d850μsselect * from "EVENT_TAGS" where "EVENT_TAGS"."CONTEST_ID" in (62322, 62323, 63853, 65378) order by "TAG_NAME" asc
      Backtrace
      • app/Services/ContestService.php:1264
      • app/Http/Controllers/ContestController.php:62
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • ContestController.php#67as7.2d1.49msselect * from "REGISTRATION" where "REGISTRATION"."CONTEST_ID" = 63853 and "REGISTRATION"."CONTEST_ID" is not null order by "REG_N" asc
      Bindings
      • 0: 63853
      Backtrace
      • app/Http/Controllers/ContestController.php:67
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • ContestController.php#67as7.2d2.15msselect * from "REG_DANCERS" where "REG_DANCERS"."REG_GUID" in ('4BD741C6-BF75-4083-BA88-A0392DEA1EAA')
      Bindings
      • 0: 4BD741C6-BF75-4083-BA88-A0392DEA1EAA
      Backtrace
      • app/Http/Controllers/ContestController.php:67
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • ContestController.php#67as7.2d1.16msselect * from "PAYMENTS" where "PAYMENTS"."REG_GUID" in ('4BD741C6-BF75-4083-BA88-A0392DEA1EAA')
      Bindings
      • 0: 4BD741C6-BF75-4083-BA88-A0392DEA1EAA
      Backtrace
      • app/Http/Controllers/ContestController.php:67
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • Registration.php#101as7.2d1.42msselect * from "PAYMENTS" where "PAYMENTS"."REG_GUID" = '1F45B664-86F5-491D-9225-1330BCC5C3CA' and "PAYMENTS"."REG_GUID" is not null
      Bindings
      • 0: 1F45B664-86F5-491D-9225-1330BCC5C3CA
      Backtrace
      • app/Http/Model/Registration.php:101
      • app/Http/Controllers/ContestController.php:75
      • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
    • Contest.php#153as7.2d1.16msselect * from "EVENT_TAGS" where "EVENT_TAGS"."CONTEST_ID" = 63853 and "EVENT_TAGS"."CONTEST_ID" is not null order by "TAG_NAME" asc
      Bindings
      • 0: 63853
      Backtrace
      • app/Http/Model/Contest.php:153
      • app/Http/Model/Contest.php:294
      • view::contest.partial.edit-registration-notes-modal:22
      • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    App\Http\Model\Contest
    1351Contest.php#?
    App\Http\Model\EventTag
    832EventTag.php#?
    App\Http\Model\Registration
    403Registration.php#?
    App\Http\Model\Payment
    34Payment.php#?
    App\Http\Model\RegDancer
    16RegDancer.php#?
    App\Http\Model\EvExtra
    3EvExtra.php#?
    App\Http\Model\Event
    1Event.php#?
        _token
        HeWkl9OQ67HicU1EJpvh92y3Z8leapMSsJcWCPDu
        event
        App\Http\Model\Event {#1811 +"ACCESS_KEY": "2121215" +"ADM_EMAIL": "ulyanamarsur@mail.ru" +"CI...
        ds
        social
        _previous
        array:1 [ "url" => "http://66.danceoffice.online/events/140/groups/1331/reg-list?ds=social" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /events/140/groups/1331/reg-list
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:1 [ "ds" => "social" ]
        request_request
        []
        
        request_headers
        0 of 0
        array: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" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array: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:30:12 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImY5V01UbWJNWGkxR0hhbVJxS1BNNUE9PSIsInZhbHVlIjoiRTR1VEJwNExtdkNwMUdSSFN4SUllZkVUU09hdDEyclhLYU9DV2VtMlVGb1dpN2xBVFFPbXo3UktOU2N6OXpja3ZITkhyZCswZVlrbDJ0R2xyWnBWa3JKanYvdDdtdFBmaHZHODVRM2loWjkzLzV2MVV3dUI4b2xCOEhZblpJME4iLCJtYWMiOiI0NjM2ZjI1YTZlOWRmZTIzN2FiMjQ3NjY4ZGY0MjM2ZDg4MjQyMzUwNGM5ZGRhYTE4NzNkN2NlZDJkYmUyZjEzIiwidGFnIjoiIn0%3D; expires=Mon, 30 Dec 2024 03:30:12 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6ImY5V01UbWJNWGkxR0hhbVJxS1BNNUE9PSIsInZhbHVlIjoiRTR1VEJwNExtdkNwMUdSSFN4SUllZkVUU09hdDEyclhLYU9DV2VtMlVGb1dpN2xBVFFPbXo3UktOU2N6OXpja3ZITkhyZ" 1 => "danceofficeonline_session=eyJpdiI6IkdEYjNkQ3FIUE1SdFpRbUdmdUYrK0E9PSIsInZhbHVlIjoibkF6SEcydWZ6VzZld2RnTThWVGJkM2NUTDhDcWpPSUs5VEpFZ0RGcmo5clZyNVlUVldPM213T2J6Z2dWQUFmaXBrRGZ3dmhnMlErM1p0aWllck83eEFEaHNEdEI5b2xieEdpRmVaSTRBems2TCtqRHZybUtzWHp3a1BiQjFYNlIiLCJtYWMiOiIyYThkNDBhZTBhODI4MjQ5Yjc0NmNmOTZiMDIxMWEzOTc1ZjdhNzJmZGViZjM5M2VlMzNhYTBkNzM1OWY0M2ZmIiwidGFnIjoiIn0%3D; expires=Mon, 30 Dec 2024 03:30:12 GMT; Max-Age=7200; path=/; httponlydanceofficeonline_session=eyJpdiI6IkdEYjNkQ3FIUE1SdFpRbUdmdUYrK0E9PSIsInZhbHVlIjoibkF6SEcydWZ6VzZld2RnTThWVGJkM2NUTDhDcWpPSUs5VEpFZ0RGcmo5clZyNVlUVldPM213T2J6Z2" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImY5V01UbWJNWGkxR0hhbVJxS1BNNUE9PSIsInZhbHVlIjoiRTR1VEJwNExtdkNwMUdSSFN4SUllZkVUU09hdDEyclhLYU9DV2VtMlVGb1dpN2xBVFFPbXo3UktOU2N6OXpja3ZITkhyZCswZVlrbDJ0R2xyWnBWa3JKanYvdDdtdFBmaHZHODVRM2loWjkzLzV2MVV3dUI4b2xCOEhZblpJME4iLCJtYWMiOiI0NjM2ZjI1YTZlOWRmZTIzN2FiMjQ3NjY4ZGY0MjM2ZDg4MjQyMzUwNGM5ZGRhYTE4NzNkN2NlZDJkYmUyZjEzIiwidGFnIjoiIn0%3D; expires=Mon, 30-Dec-2024 03:30:12 GMT; path=/XSRF-TOKEN=eyJpdiI6ImY5V01UbWJNWGkxR0hhbVJxS1BNNUE9PSIsInZhbHVlIjoiRTR1VEJwNExtdkNwMUdSSFN4SUllZkVUU09hdDEyclhLYU9DV2VtMlVGb1dpN2xBVFFPbXo3UktOU2N6OXpja3ZITkhyZ" 1 => "danceofficeonline_session=eyJpdiI6IkdEYjNkQ3FIUE1SdFpRbUdmdUYrK0E9PSIsInZhbHVlIjoibkF6SEcydWZ6VzZld2RnTThWVGJkM2NUTDhDcWpPSUs5VEpFZ0RGcmo5clZyNVlUVldPM213T2J6Z2dWQUFmaXBrRGZ3dmhnMlErM1p0aWllck83eEFEaHNEdEI5b2xieEdpRmVaSTRBems2TCtqRHZybUtzWHp3a1BiQjFYNlIiLCJtYWMiOiIyYThkNDBhZTBhODI4MjQ5Yjc0NmNmOTZiMDIxMWEzOTc1ZjdhNzJmZGViZjM5M2VlMzNhYTBkNzM1OWY0M2ZmIiwidGFnIjoiIn0%3D; expires=Mon, 30-Dec-2024 03:30:12 GMT; path=/; httponlydanceofficeonline_session=eyJpdiI6IkdEYjNkQ3FIUE1SdFpRbUdmdUYrK0E9PSIsInZhbHVlIjoibkF6SEcydWZ6VzZld2RnTThWVGJkM2NUTDhDcWpPSUs5VEpFZ0RGcmo5clZyNVlUVldPM213T2J6Z2" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "HeWkl9OQ67HicU1EJpvh92y3Z8leapMSsJcWCPDu" "event" => App\Http\Model\Event {#1811 +"ACCESS_KEY": "2121215" +"ADM_EMAIL": "ulyanamarsur@mail.ru" +"CITY": "Ульяновск" +"CLUB_ID": null +"CLUB_REG_ID": null +"COUNTRY": "Россия" +"DATE_BEGIN": "2024-11-23" +"DATE_END": "2024-11-24" +"EVENT_ID": 140 +"EVENT_NAME": "V Всероссийский фестиваль по восточным танцам и танцам народов мира AMAR-SURAGE" +"FEDERATION_REG_ID": 96 +"FILE_NAME": "Положение-Ульяновск-23-24-Ноября-2024v.1-_1_ (1).pdf" +"GUID": "60B144A9-A1A8-4831-B17F-1960270FA841" +"INTERNAL": 1 +"INVITATION_UPDATED_AT": "2024-10-15 20:54:53" +"KIND": null +"NOTES": """ ВАЖНО!!!\r\n ИНСТРУКЦИЯ ПО ЗАГРУЗКЕ МУЗЫКИ:\r\n https://danceoffice.online/instructions/soundtrack-upload?ds=social\r\n \r\n РЕКВИЗИТЫ ВНЕСЕНИЯ ОРГАНИЗАЦИОННЫХ ВЗНОСОВ:\r\n Для внесения организационных взносов сканируйте QR-код :\r\n [img "https://danceoffice.online/storage/events/140/attachments/77580E73-6181-4809-8EEF-2E3610CB3F30/QR-CODE.png"]\r\n После оплаты взноса необходимо отправить на почту фестиваля ulyanamarsur@mail.ru\r\n фотографию или скриншот чека. """ +"ONE_REG_NUM": 1 +"ORGANIZER": "Amar Surage" +"ORG_FEDERATION": null +"ORG_STRING": "" +"PASS": null +"PLACE": "г. Ульяновск ДК «РУСЛАН», ул. 40-летия Победы, дом 15" +"PLACE_PERCENTAGE": null +"REG_NOTES": null +"SEAT_COUNT": null +"TEAM_ID": 2 +"WEBSITE": "https://vk.com/club180536969" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: array:1 [ "tags" => Illuminate\Database\Eloquent\Collection {#1885 #items: array:13 [ 0 => App\Http\Model\EventTag {#1887 +"CONTEST_ID": null +"EVENT_ID": 140 +"GUID": "F69052A2-B639-44BD-AAE3-49896F642E54" +"TAG_GROUP": null +"TAG_NAME": "AUDIO-FORMATS" +"TAG_VALUE": "audio/*" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 1 => App\Http\Model\EventTag {#1916 +"CONTEST_ID": null +"EVENT_ID": 140 +"GUID": "A8CDFBE3-4360-4220-A06C-279F410AA11C" +"TAG_GROUP": null +"TAG_NAME": "BELLY-DANCE" +"TAG_VALUE": "" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 2 => App\Http\Model\EventTag {#1915 +"CONTEST_ID": null +"EVENT_ID": 140 +"GUID": "73C055A5-1FDE-4B51-99F6-9FB36671D26D" +"TAG_GROUP": null +"TAG_NAME": "BIRTHDATE" +"TAG_VALUE": "EXACT" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 3 => App\Http\Model\EventTag {#1914 +"CONTEST_ID": null +"EVENT_ID": 140 +"GUID": "24419031-AD3F-4A50-84ED-C521EA5658B5" +"TAG_GROUP": null +"TAG_NAME": "DO-REG" +"TAG_VALUE": "" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 4 => App\Http\Model\EventTag {#1913 +"CONTEST_ID": null +"EVENT_ID": 140 +"GUID": "1CE96461-5238-4C85-88B0-3ED1C7068E78" +"TAG_GROUP": null +"TAG_NAME": "EMAIL-SHOW-PRICES" +"TAG_VALUE": "" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 5 => App\Http\Model\EventTag {#1912 +"CONTEST_ID": null +"EVENT_ID": 140 +"GUID": "79609F26-5364-45D1-A9A1-908F0E434B5E" +"TAG_GROUP": null +"TAG_NAME": "FIO-IN-CARDS" +"TAG_VALUE": "" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 6 => App\Http\Model\EventTag {#1911 +"CONTEST_ID": null +"EVENT_ID": 140 +"GUID": "FCFE69F1-1133-48DC-85ED-8EA16F89724E" +"TAG_GROUP": null +"TAG_NAME": "JUDGES" +"TAG_VALUE": "" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 7 => App\Http\Model\EventTag {#1910 +"CONTEST_ID": null +"EVENT_ID": 140 +"GUID": "CF393BCA-A006-4955-A103-40FF5B3AB87A" +"TAG_GROUP": null +"TAG_NAME": "NO-FIOS-GROUPS" +"TAG_VALUE": "" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 8 => App\Http\Model\EventTag {#1909 +"CONTEST_ID": null +"EVENT_ID": 140 +"GUID": "9F742643-FDE5-4373-86B9-19A0890DDEFA" +"TAG_GROUP": null +"TAG_NAME": "PACKETS" +"TAG_VALUE": "" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 9 => App\Http\Model\EventTag {#1908 +"CONTEST_ID": null +"EVENT_ID": 140 +"GUID": "8E70EE33-F491-4CC3-9AB6-3C36E7F61F27" +"TAG_GROUP": null +"TAG_NAME": "PAY-GROUP" +"TAG_VALUE": "2000" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 10 => App\Http\Model\EventTag {#1907 +"CONTEST_ID": null +"EVENT_ID": 140 +"GUID": "FF8C8C9F-6C55-4CF5-9477-63370D037442" +"TAG_GROUP": null +"TAG_NAME": "SHOW-JUDGES" +"TAG_VALUE": "0" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 11 => App\Http\Model\EventTag {#1906 +"CONTEST_ID": null +"EVENT_ID": 140 +"GUID": "029BEF8D-98DC-4D2B-A063-A6270990E384" +"TAG_GROUP": null +"TAG_NAME": "SOCIAL" +"TAG_VALUE": "" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } 12 => App\Http\Model\EventTag {#1905 +"CONTEST_ID": null +"EVENT_ID": 140 +"GUID": "23DB2BEF-A5BE-4141-96BC-E370E481054B" +"TAG_GROUP": null +"TAG_NAME": "TABLO" +"TAG_VALUE": "0" isDirty(): false +exists: true +wasRecentlyCreated: false #relations: [] …29 } ] #escapeWhenCastingToString: false } ] …40 } "ds" => "social" "_previous" => array:1 [ "url" => "http://66.danceoffice.online/events/140/groups/1331/reg-list?ds=social" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12024-12-30 04:30:12GET/events/140/groups/1331/reg-list?ds=social320182640