• Pos
    Constructor
    AUT
    AUT
    HUN
    GBR
    GBR
    ESP
    BEL
    ITA
    ITA
    RUS
    GER
    PRT
    ITA
    TUR
    BHR
    BHR
    ARE
    Total
  • 1
    37
    43
    41
    25
    34
    41
    43
    17
    44
    41
    25
    44
    44
    25
    29
    7
    33
    573
  • 2
    -
    27
    28
    23
    35
    22
    23
    -
    15
    19
    19
    15
    -
    14
    34
    8
    37
    319
  • 3
    8
    14
    18
    2
    14
    22
    3
    16
    10
    12
    16
    6
    8
    20
    -
    40
    1
    195*
  • 4
    26
    13
    2
    10
    2
    9
    6
    30
    8
    -
    10
    8
    10
    15
    22
    13
    18
    202
  • 5
    4
    4
    4
    20
    4
    -
    23
    12
    12
    16
    15
    6
    15
    1
    8
    28
    9
    181
  • 6
    19
    -
    8
    16
    12
    6
    -
    -
    5
    8
    6
    13
    10
    27
    1
    -
    -
    131
  • 7
    6
    1
    -
    6
    1
    2
    4
    27
    6
    6
    8
    10
    12
    -
    8
    6
    4
    107
  • 8
    2
    -
    -
    -
    -
    -
    -
    -
    2
    -
    1
    -
    3
    -
    -
    -
    -
    8
  • 9
    -
    -
    1
    -
    -
    -
    -
    -
    -
    -
    2
    -
    -
    -
    -
    -
    -
    3
  • 10
    -
    -
    -
    -
    -
    -
    -
    -
    -
    -
    -
    -
    -
    -
    -
    -
    -
    -

* Door een straf van Racing Point, voor het gebruiken van illegale brake ducts, kreeg het team 2x 200.000 dollar boete en 15 punten in mindering als team.


Total queries: 45
Total time: 0.28962993621826
timesincestartcallerannotatebtdesc
0.000475
instantiate query log (0Q - total module time: 0.00063181s)
""
0.001115
boot (0Q - total module time: 0.00011206s)
""
0.001230
translation-init (1Q - total module time: 0.00095010s)
""
0.000258210.001912/var/www/dev-priyantha.gptoday.net/public_html/index.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:189(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Redirect.php:105(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Entities/Redirect.php:112(findByOrigin)
/var/www/dev-priyantha.gptoday.net/public_html/app/Services/Redirects.php:108(getRedirectOrFalse)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:115(checkForDBRedirects)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT redirects.id, redirects.origin, redirects.referer FROM redirects WHERE redirects.origin = :origin ORDER BY id
{"origin":"\/en\/season\/standings\/f1\/races\/2020"}
0.002184
controller::season/standings/f1/races/2020 (4Q - total module time: 0.02765512s)
""
0.000066040.002439/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceSeasons.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:913(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceSeasons.php:157(getArrayResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:46(getYears)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.Year AS Year_0 FROM RaceCalendar r1_ INNER JOIN RaceSeasons r0_ ON r1_.RaceSeasonId = r0_.RaceSeasonId AND (r0_.SiteId IN ('1')) INNER JOIN RacingSeries r2_ ON r0_.RacingSerieId = r2_.RacingSerieId AND (r2_.SiteId IN ('1')) WHERE r2_.SiteId IN (?) AND r1_.RaceCalendarId IS NOT NULL GROUP BY r0_.Year ORDER BY r0_.Year DESC
[["1"]]
0.000232220.002643/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceSeasons.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:953(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceSeasons.php:138(getOneOrNullResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:51(findSpecificSeason)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceSeasonId AS RaceSeasonId_0, r0_.Year AS Year_1, r1_.RacingSerieId AS RacingSerieId_2, r1_.RewriteUrl AS RewriteUrl_3, r1_.IsDefault AS IsDefault_4, r0_.SiteId AS SiteId_5, r0_.RacingSerieId AS RacingSerieId_6, r1_.SiteId AS SiteId_7, r1_.CountryIso AS CountryIso_8 FROM RaceSeasons r0_ INNER JOIN RacingSeries r1_ ON r0_.RacingSerieId = r1_.RacingSerieId AND (r1_.SiteId IN ('1')) WHERE (r1_.RewriteUrl = ? AND r0_.Year = ? AND r1_.SiteId IN (?)) AND (r0_.SiteId IN ('1')) ORDER BY r0_.Year DESC LIMIT 1
["f1","2020",["1"]]
0.000051020.003186/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RacingEventTypes.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:953(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RacingEventTypes.php:42(getOneOrNullResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:55(findByUrl)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RacingEventTypeId AS RacingEventTypeId_0, r0_.Name AS Name_1, r0_.RewriteUrl AS RewriteUrl_2 FROM RacingEventTypes r0_ WHERE r0_.RewriteUrl = ?
["races"]
0.025915860.003385/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1000(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:319(fetchAll)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:480(findResultsByCriteria)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:102(getStanding)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
/* findByCriteria01 */ SELECT CASE WHEN res.`LapTime` <= 0.0 THEN 1 ELSE -1 END AS `SortOne`, CASE WHEN res.`LapCount` <= 0 THEN 1 ELSE -1 END AS `SortTwo`, CASE WHEN res.`Position` <= 0 THEN 9999 ELSE res.`Position` END AS `SortThree`, res.`RaceResultId`, res.`RaceParticipantId`, res.`LapTime`, res.`LapCount`, res.`Position`, res.`Result`, res.`DidNotFinish`, res.`DidNotStart`, res.`Points`, res.`Pitted`, res.`MaxSpeed`, res.`AverageSpeed`, perc.`PersonCareerId` AS `PersonCareerId`, perc.`StartDate` AS `CareerStartDate`, perc.`EndDate` AS `CareerEndDate`, perc.`ProfilePhoto` AS `CareerPhoto`, perc.`StartNumber` AS `CareerStartNumber`, perc.`PersonId` AS `PersonId`, orgh.`PrimaryOrganisationId` AS `OrganisationId`, rs.`RaceSessionId` AS `RaceSessionId`, rst.`ResultType` AS `SessionTypeResultType`, rc.`Name` AS `RacingClassName`, rt.`Name` AS `TireName`, rt.`Colour` AS `TireColour`, eng.`Name` AS `EngineName`, eng.`ReleaseDate` AS `EngineReleaseDate`, eng.`CylinderCount` AS `EngineCylinderCount`, eng.`EngineType` AS `EngineType`, eng.`Volume` AS `EngineVolume`, eman.`Name` AS `EngineManufacturerName`, chas.`Name` AS `ChassisName`, chas.`ReleaseDate` AS `ChassisReleaseDate` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `PersonCareer` perc ON perc.`PersonCareerId` = par.`PersonCareerId` JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId JOIN `RaceSessions` rs ON par.`RaceSessionId` = rs.`RaceSessionId` JOIN `RacingSessionTypes` rst ON rst.`RacingSessionTypeId` = rs.`RacingSessionTypeId` JOIN `RaceCalendar` cal ON cal.`RaceCalendarId` = rs.`RaceCalendarId` JOIN `RacingClasses` rc ON par.`RacingClassId` = rc.`RacingClassId` JOIN `Engines` eng ON eng.`EngineId` = par.`EngineId` JOIN `Chassis` chas ON par.`ChassisId` = chas.`ChassisId` JOIN `OrganisationHistory` eman ON eng.`ManufacturerOrganisationHistoryId` = eman.`OrganisationHistoryId` JOIN `OrganisationHistory` cman ON chas.`ManufacturerOrganisationHistoryId` = cman.`OrganisationHistoryId` JOIN `RacingTires` rt ON par.`RacingTireId` = rt.`RacingTireId` WHERE 1 = 1 AND RaceSeasonId = :param1 AND (rst.ResultType = :param2 OR rst.ResultType = :param3 OR rst.ResultType = :param4 OR rst.ResultType = :param5) ORDER BY rs.StartTime
{":param1":42,":param2":"race",":param3":"startgrid",":param4":"sprint",":param5":"sprintstartgrid"}
0.029845
query01 returned 520 rows (5Q - total module time: 0.06747293s)
""
0.016112090.029856/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1000(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:385(fetchAll)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:480(findResultsByCriteria)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:102(getStanding)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
/* findByCriteria02 */ SELECT res.`RaceResultId`, perc.`PersonCareerId` AS `PersonCareerId`, perc.`StartDate` AS `CareerStartDate`, perc.`EndDate` AS `CareerEndDate`, perc.`ProfilePhoto` AS `CareerPhoto`, perc.`StartNumber` AS `CareerStartNumber`, prt.`Name` AS `CareerRoleName`, per.`PersonId` AS `PersonId`, per.`Nationality` AS `PersonNationality`, per.`LastName` AS `PersonLastName`, per.`FirstName` AS `PersonFirstName`, per.`BirthDate` AS `PersonBirthDate`, per.`DateOfDeath` AS `PersonDateOfDeath`, per.`Residence` AS `PersonResidence`, per.`ProfilePhoto` AS `PersonPhoto`, per.`Height` AS `PersonHeight`, per.`Website` AS `PersonWebsite`, per.`Weight` AS `PersonWeight`, per.`BirthCity` AS `PersonBirthCity`, orgh.`OrganisationHistoryId` AS `OrganisationHistoryId`, orgh.`Name` AS `OrghName`, orgh.`StartDate` AS `OrghStartDate`, orgh.`EndDate` AS `OrghEndDate`, orgh.`Photo` AS `OrghPhoto`, orgh.`City` AS `OrghCity`, orgh.Website AS `OrghWebsite`, orgh.`SmallLogo` AS `OrghSmallLogo`, org.`OrganisationId`, org.`Nationality` AS `OrgNationality`, org.`Name` AS `OrgName`, org.`FoundingDate` AS `OrgFoundingDate`, org.`Photo` AS `OrgPhoto`, kw1.`Keyword` AS `OrgKeyword`, kw1.`RewriteUrl` AS `OrgRewriteUrl`, kw2.`Keyword` AS `PersonKeyword`, kw2.`RewriteUrl` AS `PersonRewriteUrl` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `PersonCareer` perc ON perc.`PersonCareerId` = par.`PersonCareerId` JOIN `PersonRoles` pr ON perc.`PersonRoleId` = pr.`PersonRoleId` JOIN `PersonRolesTranslations` prt ON pr.`PersonRoleId` = prt.`PersonRoleId` AND prt.`LanguageCode` = 'en' JOIN `Persons` per ON per.PersonId = perc.PersonId JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId JOIN `Organisations` org ON org.OrganisationId = orgh.PrimaryOrganisationId JOIN `db_countries` co1 ON co1.`iso` = org.`Nationality` JOIN `db_countries` co2 ON co2.`iso` = per.`Nationality` JOIN `Keywords` kw1 ON org.`KeywordId` = kw1.`KeywordId` JOIN `Keywords` kw2 ON per.`KeywordId` = kw2.`KeywordId` WHERE res.`RaceParticipantId` IN (24307,24301,24293,24316,24297,24319,24298,24314,24305,24324,24289,24320,24290,24303,24315,24306,24322,24308,24327,24292,24291,24321,24313,24317,24318,24325,24309,24310,24323,24326,24328,24312,24311,24296,24299,24294,24304,24300,24295,24302,24433,24437,24456,24459,24438,24454,24445,24464,24429,24460,24430,24455,24443,24462,24446,24467,24448,24432,24431,24461,24453,24457,24458,24465,24449,24450,24463,24466,24468,24452,24451,24436,24439,24434,24444,24440,24435,24442,24447,24441,24588,24607,24572,24601,24571,24593,24597,24598,24605,24589,24590,24603,24606,24608,24592,24591,24576,24579,24574,24584,24580,24575,24582,24587,24581,24573,24577,24578,24585,24596,24569,24599,24570,24594,24583,24604,24600,24595,24586,24602,24735,24734,24777,24719,24722,24717,24727,24723,24718,24730,24724,24716,24720,24739,24721,24742,24728,24712,24737,24713,24747,24726,24729,24731,24743,24715,24738,24714,24750,24776,24744,24736,24740,24741,24748,24732,24733,24746,24749,24751,25632,24873,24876,24871,24881,24877,24872,24884,24878,24870,24874,24893,24875,24896,24882,24891,24866,24901,24867,24880,24883,24885,24897,24869,24892,24868,24904,25631,24898,24890,24894,24895,24902,24886,24887,24900,24903,24905,24889,24888,25045,25029,25028,25033,25036,25031,25041,25037,25032,25039,25044,25038,25030,25034,25035,25042,25026,25027,25040,25043,25164,25158,25150,25154,25155,25173,25176,25162,25171,25146,25181,25177,25147,25172,25160,25179,25163,25184,25165,25178,25149,25170,25148,25174,25175,25182,25166,25167,25180,25183,25185,25169,25168,25153,25156,25151,25161,25157,25152,25159,25313,25316,25311,25321,25317,25312,25319,25324,25318,25310,25314,25315,25322,25306,25307,25320,25323,25325,25309,25308,25428,25450,25454,25455,25462,25446,25447,25460,25463,25465,25449,25448,25433,25436,25431,25441,25437,25432,25439,25444,25438,25430,25434,25435,25442,25453,25426,25456,25427,25451,25440,25461,25457,25452,25443,25459,25445,25464,25429,25458,25603,25605,25589,25588,25593,25596,25591,25601,25597,25592,25599,25604,25598,25590,25594,25595,25602,25586,25587,25600,25743,25746,25741,25751,25747,25742,25749,25754,25740,25744,25745,25752,25736,25737,25750,25753,25755,25739,25738,25748,25885,25892,25876,25877,25890,25893,25895,25879,25878,25883,25886,25881,25891,25887,25882,25889,25894,25888,25880,25884,25983,25986,25981,25991,25987,25982,25989,25994,25988,25980,25984,25985,25992,25976,25977,25990,25993,25995,25979,25978,26105,26126,26112,26121,26096,26131,26127,26097,26122,26110,26129,26113,26134,26115,26099,26098,26128,26120,26124,26125,26132,26116,26117,26130,26133,26135,26119,26118,26103,26106,26101,26111,26107,26102,26109,26114,26108,26100,26104,26123,26262,26269,26274,26268,26260,26264,26265,26272,26256,26257,26270,26273,26275,26259,26258,26263,26266,26261,26271,26267,26403,26413,26409,26404,26408,26411,26405,26410,26402,26406,26407,26414,26398,26399,26412,26415,26417,26401,26400,26416,26542,26520,26546,26547,26554,26538,26539,26552,26555,26557,26541,26540,26528,26523,26533,26529,26524,26531,26536,26525,26530,26522,26526,26548,26527,26543,26534,26553,26518,26549,26519,26544,26551,26532,26556,26535,26545,26537,26550,26521)
{":param1":42,":param2":"race",":param3":"startgrid",":param4":"sprint",":param5":"sprintstartgrid"}
0.005280970.046475/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1000(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:432(fetchAll)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:480(findResultsByCriteria)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:102(getStanding)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
/* findByCriteria03 */ SELECT res.`RaceParticipantId`, res.`RaceResultId`, rs.`RaceSessionId` AS `RaceSessionId`, rs.`StartTime` AS `SessionStartTime`, rs.`EndTime` AS `SessionEndTime`, rs.`TrackTemperature` AS `TrackTemperature`, rs.`AirTemperature` AS `AirTemperature`, rs.`TrackFlag` AS `TrackFlag`, cal.`RaceCalendarId` AS `RaceCalendarId`, cal.`RaceSeasonId` AS `RaceSeasonId`, cal.`GridPosition` AS `GridPosition`, rs.`PhotoAlbumId` AS `SessionPhotoAlbumId`, rst.`RewriteUrl` AS `SessionTypeRewriteUrl`, rst.`ResultType` AS `SessionTypeResultType`, re.`RewriteUrl` AS `RaceEventRewriteUrl`, re.`CountryIso` AS `RaceEventIso`, ret.`Name` AS `RaceEventName`, rt.`Name` AS `TireName`, rt.`Colour` AS `TireColour`, rse.`RewriteUrl` AS `RacingSerieRewriteUrl`, rset.`ShortName` AS `RacingSerieShortName`, rset.`LongName` AS `RacingSeriesLongName` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `RaceSessions` rs ON par.`RaceSessionId` = rs.`RaceSessionId` JOIN `RacingSessionTypes` rst ON rst.`RacingSessionTypeId` = rs.`RacingSessionTypeId` JOIN `RacingSessionTypesTranslations` rstt ON rst.`RacingSessionTypeId` = rstt.`RacingSessionTypeId` AND rstt.`LanguageCode` = 'en' JOIN `RaceCalendar` cal ON cal.`RaceCalendarId` = rs.`RaceCalendarId` JOIN `RacingEvents` re ON re.`RacingEventId` = cal.`RacingEventId` JOIN `RacingEventsTranslations` ret ON re.`RacingEventId` = ret.`RacingEventId` AND ret.`LanguageCode` = 'en' JOIN `RacingTires` rt ON par.`RacingTireId` = rt.`RacingTireId` JOIN `RacingClasses` rc ON par.`RacingClassId` = rc.`RacingClassId` JOIN `RacingSeries` rse ON rc.`RacingSerieId` = rse.`RacingSerieId` JOIN `RacingSeriesTranslations` rset ON rse.`RacingSerieId` = rset.`RacingSerieId` AND rset.`LanguageCode` = 'en' WHERE res.`RaceParticipantId` IN (24307,24301,24293,24316,24297,24319,24298,24314,24305,24324,24289,24320,24290,24303,24315,24306,24322,24308,24327,24292,24291,24321,24313,24317,24318,24325,24309,24310,24323,24326,24328,24312,24311,24296,24299,24294,24304,24300,24295,24302,24433,24437,24456,24459,24438,24454,24445,24464,24429,24460,24430,24455,24443,24462,24446,24467,24448,24432,24431,24461,24453,24457,24458,24465,24449,24450,24463,24466,24468,24452,24451,24436,24439,24434,24444,24440,24435,24442,24447,24441,24588,24607,24572,24601,24571,24593,24597,24598,24605,24589,24590,24603,24606,24608,24592,24591,24576,24579,24574,24584,24580,24575,24582,24587,24581,24573,24577,24578,24585,24596,24569,24599,24570,24594,24583,24604,24600,24595,24586,24602,24735,24734,24777,24719,24722,24717,24727,24723,24718,24730,24724,24716,24720,24739,24721,24742,24728,24712,24737,24713,24747,24726,24729,24731,24743,24715,24738,24714,24750,24776,24744,24736,24740,24741,24748,24732,24733,24746,24749,24751,25632,24873,24876,24871,24881,24877,24872,24884,24878,24870,24874,24893,24875,24896,24882,24891,24866,24901,24867,24880,24883,24885,24897,24869,24892,24868,24904,25631,24898,24890,24894,24895,24902,24886,24887,24900,24903,24905,24889,24888,25045,25029,25028,25033,25036,25031,25041,25037,25032,25039,25044,25038,25030,25034,25035,25042,25026,25027,25040,25043,25164,25158,25150,25154,25155,25173,25176,25162,25171,25146,25181,25177,25147,25172,25160,25179,25163,25184,25165,25178,25149,25170,25148,25174,25175,25182,25166,25167,25180,25183,25185,25169,25168,25153,25156,25151,25161,25157,25152,25159,25313,25316,25311,25321,25317,25312,25319,25324,25318,25310,25314,25315,25322,25306,25307,25320,25323,25325,25309,25308,25428,25450,25454,25455,25462,25446,25447,25460,25463,25465,25449,25448,25433,25436,25431,25441,25437,25432,25439,25444,25438,25430,25434,25435,25442,25453,25426,25456,25427,25451,25440,25461,25457,25452,25443,25459,25445,25464,25429,25458,25603,25605,25589,25588,25593,25596,25591,25601,25597,25592,25599,25604,25598,25590,25594,25595,25602,25586,25587,25600,25743,25746,25741,25751,25747,25742,25749,25754,25740,25744,25745,25752,25736,25737,25750,25753,25755,25739,25738,25748,25885,25892,25876,25877,25890,25893,25895,25879,25878,25883,25886,25881,25891,25887,25882,25889,25894,25888,25880,25884,25983,25986,25981,25991,25987,25982,25989,25994,25988,25980,25984,25985,25992,25976,25977,25990,25993,25995,25979,25978,26105,26126,26112,26121,26096,26131,26127,26097,26122,26110,26129,26113,26134,26115,26099,26098,26128,26120,26124,26125,26132,26116,26117,26130,26133,26135,26119,26118,26103,26106,26101,26111,26107,26102,26109,26114,26108,26100,26104,26123,26262,26269,26274,26268,26260,26264,26265,26272,26256,26257,26270,26273,26275,26259,26258,26263,26266,26261,26271,26267,26403,26413,26409,26404,26408,26411,26405,26410,26402,26406,26407,26414,26398,26399,26412,26415,26417,26401,26400,26416,26542,26520,26546,26547,26554,26538,26539,26552,26555,26557,26541,26540,26528,26523,26533,26529,26524,26531,26536,26525,26530,26522,26526,26548,26527,26543,26534,26553,26518,26549,26519,26544,26551,26532,26556,26535,26545,26537,26550,26521)
{":param1":42,":param2":"race",":param3":"startgrid",":param4":"sprint",":param5":"sprintstartgrid"}
0.014736890.052289/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceSessionIncident.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceSessionIncident.php:54(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:439(findByParticipants)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:480(findResultsByCriteria)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:102(getStanding)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceSessionIncidentId AS RaceSessionIncidentId_0, r0_.StartTime AS StartTime_1, r0_.EndTime AS EndTime_2, r0_.LapNumber AS LapNumber_3, r1_.RacingIncidentId AS RacingIncidentId_4, r1_.IncidentType AS IncidentType_5, r1_.PenaltyPoints AS PenaltyPoints_6, r1_.PenaltyPositions AS PenaltyPositions_7, r2_.RacingIncidentsTranslationId AS RacingIncidentsTranslationId_8, r2_.LanguageCode AS LanguageCode_9, r2_.Description AS Description_10, r3_.RaceParticipantId AS RaceParticipantId_11, p4_.PersonCareerId AS PersonCareerId_12, p4_.StartDate AS StartDate_13, p4_.EndDate AS EndDate_14, p4_.ProfilePhoto AS ProfilePhoto_15, p4_.StartNumber AS StartNumber_16, p5_.PersonId AS PersonId_17, p5_.LastName AS LastName_18, p5_.FirstName AS FirstName_19, p5_.Birthdate AS Birthdate_20, p5_.DateOfDeath AS DateOfDeath_21, p5_.Residence AS Residence_22, p5_.BirthCity AS BirthCity_23, p5_.ProfilePhoto AS ProfilePhoto_24, p5_.Height AS Height_25, p5_.Website AS Website_26, p5_.Weight AS Weight_27, p5_.InternalNotes AS InternalNotes_28, p5_.InHeaderList AS InHeaderList_29, p5_.InFooterList AS InFooterList_30, d6_.iso AS iso_31, d6_.iso3 AS iso3_32, d6_.numcode AS numcode_33, d7_.cntnlang AS cntnlang_34, d7_.printable_name AS printable_name_35, r0_.RacingIncidentId AS RacingIncidentId_36, r0_.RaceParticipantId AS RaceParticipantId_37, r0_.RacingIncidentLocationId AS RacingIncidentLocationId_38, r2_.RacingIncidentId AS RacingIncidentId_39, r3_.RaceSessionId AS RaceSessionId_40, r3_.PersonCareerId AS PersonCareerId_41, r3_.RacingClassId AS RacingClassId_42, r3_.EngineId AS EngineId_43, r3_.RacingTireId AS RacingTireId_44, r3_.ChassisId AS ChassisId_45, p4_.PersonRoleId AS PersonRoleId_46, p4_.OrganisationHistoryId AS OrganisationHistoryId_47, p4_.PersonId AS PersonId_48, p5_.Nationality AS Nationality_49, p5_.KeywordId AS KeywordId_50, p5_.PrimaryCareerId AS PrimaryCareerId_51, p5_.SiteId AS SiteId_52, d7_.ISO AS ISO_53 FROM RaceSessionIncidents r0_ INNER JOIN RacingIncidents r1_ ON r0_.RacingIncidentId = r1_.RacingIncidentId INNER JOIN RacingIncidentsTranslations r2_ ON r1_.RacingIncidentId = r2_.RacingIncidentId AND (r2_.LanguageCode = 'en') INNER JOIN RaceParticipants r3_ ON r0_.RaceParticipantId = r3_.RaceParticipantId INNER JOIN PersonCareer p4_ ON r3_.PersonCareerId = p4_.PersonCareerId INNER JOIN Persons p5_ ON p4_.PersonId = p5_.PersonId INNER JOIN db_countries d6_ ON p5_.Nationality = d6_.iso INNER JOIN db_countries_trnsl d7_ ON d6_.iso = d7_.ISO WHERE r0_.RaceParticipantId IN (?)
[{"24307":"24307","24301":"24301","24293":"24293","24316":"24316","24297":"24297","24319":"24319","24298":"24298","24314":"24314","24305":"24305","24324":"24324","24289":"24289","24320":"24320","24290":"24290","24303":"24303","24315":"24315","24306":"24306","24322":"24322","24308":"24308","24327":"24327","24292":"24292","24291":"24291","24321":"24321","24313":"24313","24317":"24317","24318":"24318","24325":"24325","24309":"24309","24310":"24310","24323":"24323","24326":"24326","24328":"24328","24312":"24312","24311":"24311","24296":"24296","24299":"24299","24294":"24294","24304":"24304","24300":"24300","24295":"24295","24302":"24302","24433":"24433","24437":"24437","24456":"24456","24459":"24459","24438":"24438","24454":"24454","24445":"24445","24464":"24464","24429":"24429","24460":"24460","24430":"24430","24455":"24455","24443":"24443","24462":"24462","24446":"24446","24467":"24467","24448":"24448","24432":"24432","24431":"24431","24461":"24461","24453":"24453","24457":"24457","24458":"24458","24465":"24465","24449":"24449","24450":"24450","24463":"24463","24466":"24466","24468":"24468","24452":"24452","24451":"24451","24436":"24436","24439":"24439","24434":"24434","24444":"24444","24440":"24440","24435":"24435","24442":"24442","24447":"24447","24441":"24441","24588":"24588","24607":"24607","24572":"24572","24601":"24601","24571":"24571","24593":"24593","24597":"24597","24598":"24598","24605":"24605","24589":"24589","24590":"24590","24603":"24603","24606":"24606","24608":"24608","24592":"24592","24591":"24591","24576":"24576","24579":"24579","24574":"24574","24584":"24584","24580":"24580","24575":"24575","24582":"24582","24587":"24587","24581":"24581","24573":"24573","24577":"24577","24578":"24578","24585":"24585","24596":"24596","24569":"24569","24599":"24599","24570":"24570","24594":"24594","24583":"24583","24604":"24604","24600":"24600","24595":"24595","24586":"24586","24602":"24602","24735":"24735","24734":"24734","24777":"24777","24719":"24719","24722":"24722","24717":"24717","24727":"24727","24723":"24723","24718":"24718","24730":"24730","24724":"24724","24716":"24716","24720":"24720","24739":"24739","24721":"24721","24742":"24742","24728":"24728","24712":"24712","24737":"24737","24713":"24713","24747":"24747","24726":"24726","24729":"24729","24731":"24731","24743":"24743","24715":"24715","24738":"24738","24714":"24714","24750":"24750","24776":"24776","24744":"24744","24736":"24736","24740":"24740","24741":"24741","24748":"24748","24732":"24732","24733":"24733","24746":"24746","24749":"24749","24751":"24751","25632":"25632","24873":"24873","24876":"24876","24871":"24871","24881":"24881","24877":"24877","24872":"24872","24884":"24884","24878":"24878","24870":"24870","24874":"24874","24893":"24893","24875":"24875","24896":"24896","24882":"24882","24891":"24891","24866":"24866","24901":"24901","24867":"24867","24880":"24880","24883":"24883","24885":"24885","24897":"24897","24869":"24869","24892":"24892","24868":"24868","24904":"24904","25631":"25631","24898":"24898","24890":"24890","24894":"24894","24895":"24895","24902":"24902","24886":"24886","24887":"24887","24900":"24900","24903":"24903","24905":"24905","24889":"24889","24888":"24888","25045":"25045","25029":"25029","25028":"25028","25033":"25033","25036":"25036","25031":"25031","25041":"25041","25037":"25037","25032":"25032","25039":"25039","25044":"25044","25038":"25038","25030":"25030","25034":"25034","25035":"25035","25042":"25042","25026":"25026","25027":"25027","25040":"25040","25043":"25043","25164":"25164","25158":"25158","25150":"25150","25154":"25154","25155":"25155","25173":"25173","25176":"25176","25162":"25162","25171":"25171","25146":"25146","25181":"25181","25177":"25177","25147":"25147","25172":"25172","25160":"25160","25179":"25179","25163":"25163","25184":"25184","25165":"25165","25178":"25178","25149":"25149","25170":"25170","25148":"25148","25174":"25174","25175":"25175","25182":"25182","25166":"25166","25167":"25167","25180":"25180","25183":"25183","25185":"25185","25169":"25169","25168":"25168","25153":"25153","25156":"25156","25151":"25151","25161":"25161","25157":"25157","25152":"25152","25159":"25159","25313":"25313","25316":"25316","25311":"25311","25321":"25321","25317":"25317","25312":"25312","25319":"25319","25324":"25324","25318":"25318","25310":"25310","25314":"25314","25315":"25315","25322":"25322","25306":"25306","25307":"25307","25320":"25320","25323":"25323","25325":"25325","25309":"25309","25308":"25308","25428":"25428","25450":"25450","25454":"25454","25455":"25455","25462":"25462","25446":"25446","25447":"25447","25460":"25460","25463":"25463","25465":"25465","25449":"25449","25448":"25448","25433":"25433","25436":"25436","25431":"25431","25441":"25441","25437":"25437","25432":"25432","25439":"25439","25444":"25444","25438":"25438","25430":"25430","25434":"25434","25435":"25435","25442":"25442","25453":"25453","25426":"25426","25456":"25456","25427":"25427","25451":"25451","25440":"25440","25461":"25461","25457":"25457","25452":"25452","25443":"25443","25459":"25459","25445":"25445","25464":"25464","25429":"25429","25458":"25458","25603":"25603","25605":"25605","25589":"25589","25588":"25588","25593":"25593","25596":"25596","25591":"25591","25601":"25601","25597":"25597","25592":"25592","25599":"25599","25604":"25604","25598":"25598","25590":"25590","25594":"25594","25595":"25595","25602":"25602","25586":"25586","25587":"25587","25600":"25600","25743":"25743","25746":"25746","25741":"25741","25751":"25751","25747":"25747","25742":"25742","25749":"25749","25754":"25754","25740":"25740","25744":"25744","25745":"25745","25752":"25752","25736":"25736","25737":"25737","25750":"25750","25753":"25753","25755":"25755","25739":"25739","25738":"25738","25748":"25748","25885":"25885","25892":"25892","25876":"25876","25877":"25877","25890":"25890","25893":"25893","25895":"25895","25879":"25879","25878":"25878","25883":"25883","25886":"25886","25881":"25881","25891":"25891","25887":"25887","25882":"25882","25889":"25889","25894":"25894","25888":"25888","25880":"25880","25884":"25884","25983":"25983","25986":"25986","25981":"25981","25991":"25991","25987":"25987","25982":"25982","25989":"25989","25994":"25994","25988":"25988","25980":"25980","25984":"25984","25985":"25985","25992":"25992","25976":"25976","25977":"25977","25990":"25990","25993":"25993","25995":"25995","25979":"25979","25978":"25978","26105":"26105","26126":"26126","26112":"26112","26121":"26121","26096":"26096","26131":"26131","26127":"26127","26097":"26097","26122":"26122","26110":"26110","26129":"26129","26113":"26113","26134":"26134","26115":"26115","26099":"26099","26098":"26098","26128":"26128","26120":"26120","26124":"26124","26125":"26125","26132":"26132","26116":"26116","26117":"26117","26130":"26130","26133":"26133","26135":"26135","26119":"26119","26118":"26118","26103":"26103","26106":"26106","26101":"26101","26111":"26111","26107":"26107","26102":"26102","26109":"26109","26114":"26114","26108":"26108","26100":"26100","26104":"26104","26123":"26123","26262":"26262","26269":"26269","26274":"26274","26268":"26268","26260":"26260","26264":"26264","26265":"26265","26272":"26272","26256":"26256","26257":"26257","26270":"26270","26273":"26273","26275":"26275","26259":"26259","26258":"26258","26263":"26263","26266":"26266","26261":"26261","26271":"26271","26267":"26267","26403":"26403","26413":"26413","26409":"26409","26404":"26404","26408":"26408","26411":"26411","26405":"26405","26410":"26410","26402":"26402","26406":"26406","26407":"26407","26414":"26414","26398":"26398","26399":"26399","26412":"26412","26415":"26415","26417":"26417","26401":"26401","26400":"26400","26416":"26416","26542":"26542","26520":"26520","26546":"26546","26547":"26547","26554":"26554","26538":"26538","26539":"26539","26552":"26552","26555":"26555","26557":"26557","26541":"26541","26540":"26540","26528":"26528","26523":"26523","26533":"26533","26529":"26529","26524":"26524","26531":"26531","26536":"26536","26525":"26525","26530":"26530","26522":"26522","26526":"26526","26548":"26548","26527":"26527","26543":"26543","26534":"26534","26553":"26553","26518":"26518","26549":"26549","26519":"26519","26544":"26544","26551":"26551","26532":"26532","26556":"26556","26535":"26535","26545":"26545","26537":"26537","26550":"26550","26521":"26521"}]
0.004706140.073511/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:60(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:103(getSeasonCalendar)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RacingEventsTranslationId AS RacingEventsTranslationId_11, r3_.LanguageCode AS LanguageCode_12, r3_.Name AS Name_13, r4_.RacingSessionTypeId AS RacingSessionTypeId_14, r4_.RewriteUrl AS RewriteUrl_15, r4_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_16, r4_.SortingOrder AS SortingOrder_17, r4_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_18, r4_.MainEventAtBeginning AS MainEventAtBeginning_19, r4_.DefaultDuration AS DefaultDuration_20, r4_.ResultType AS ResultType_21, r4_.DefaultAdd AS DefaultAdd_22, r5_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_23, r5_.LanguageCode AS LanguageCode_24, r5_.Name AS Name_25, r6_.RaceTrackHistoryId AS RaceTrackHistoryId_26, r6_.LapLength AS LapLength_27, r6_.LapCount AS LapCount_28, r6_.Map AS Map_29, r6_.Impression AS Impression_30, r6_.StartDate AS StartDate_31, r6_.EndDate AS EndDate_32, r7_.RaceTrackId AS RaceTrackId_33, r7_.Name AS Name_34, r7_.RewriteUrl AS RewriteUrl_35, r7_.FoundingDate AS FoundingDate_36, r7_.Website AS Website_37, r7_.Description AS Description_38, c8_.CityId AS CityId_39, c8_.Latitude AS Latitude_40, c8_.Longitude AS Longitude_41, c8_.TimeOffsetFromUtc AS TimeOffsetFromUtc_42, c9_.CityTranslationId AS CityTranslationId_43, c9_.LanguageCode AS LanguageCode_44, c9_.Name AS Name_45, d10_.iso AS iso_46, d10_.iso3 AS iso3_47, d10_.numcode AS numcode_48, d11_.cntnlang AS cntnlang_49, d11_.printable_name AS printable_name_50, r0_.RaceSeasonId AS RaceSeasonId_51, r0_.RacingEventId AS RacingEventId_52, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_53, r1_.RacingSessionTypeId AS RacingSessionTypeId_54, r1_.RaceCalendarId AS RaceCalendarId_55, r1_.WeatherTypeId AS WeatherTypeId_56, r1_.PhotoAlbumId AS PhotoAlbumId_57, r2_.CircuitId AS CircuitId_58, r2_.WinnerId AS WinnerId_59, r2_.RacingSerieId AS RacingSerieId_60, r2_.RacingEventTypeId AS RacingEventTypeId_61, r2_.CountryIso AS CountryIso_62, r3_.RacingEventId AS RacingEventId_63, r4_.RacingSerieId AS RacingSerieId_64, r4_.RacingEventTypeId AS RacingEventTypeId_65, r5_.RacingSessionTypeId AS RacingSessionTypeId_66, r6_.RaceTrackId AS RaceTrackId_67, r7_.CityId AS CityId_68, c8_.Country AS Country_69, c9_.CityId AS CityId_70, d11_.ISO AS ISO_71 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RacingEventsTranslations r3_ ON r2_.RacingEventId = r3_.RacingEventId AND (r3_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r4_ ON r1_.RacingSessionTypeId = r4_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r5_ ON r4_.RacingSessionTypeId = r5_.RacingSessionTypeId AND (r5_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r6_ ON r0_.RaceTrackHistoryId = r6_.RaceTrackHistoryId INNER JOIN RaceTracks r7_ ON r6_.RaceTrackId = r7_.RaceTrackId INNER JOIN Cities c8_ ON r7_.CityId = c8_.CityId INNER JOIN CityTranslations c9_ ON c8_.CityId = c9_.CityId AND (c9_.LanguageCode = 'en') INNER JOIN db_countries d10_ ON c8_.Country = d10_.iso INNER JOIN db_countries_trnsl d11_ ON d10_.iso = d11_.ISO WHERE r0_.RaceSeasonId = ? AND d11_.cntnlang = ? AND c9_.LanguageCode = ? AND r2_.RacingEventTypeId = ? ORDER BY r1_.StartTime ASC, r4_.SortingOrder ASC
[42,"en","en",1]
0.007821080.089458/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1000(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:319(fetchAll)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(findResultsByCriteria)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
/* findByCriteria01 */ SELECT CASE WHEN res.`LapTime` <= 0.0 THEN 1 ELSE -1 END AS `SortOne`, CASE WHEN res.`LapCount` <= 0 THEN 1 ELSE -1 END AS `SortTwo`, CASE WHEN res.`Position` <= 0 THEN 9999 ELSE res.`Position` END AS `SortThree`, res.`RaceResultId`, res.`RaceParticipantId`, res.`LapTime`, res.`LapCount`, res.`Position`, res.`Result`, res.`DidNotFinish`, res.`DidNotStart`, res.`Points`, res.`Pitted`, res.`MaxSpeed`, res.`AverageSpeed`, perc.`PersonCareerId` AS `PersonCareerId`, perc.`StartDate` AS `CareerStartDate`, perc.`EndDate` AS `CareerEndDate`, perc.`ProfilePhoto` AS `CareerPhoto`, perc.`StartNumber` AS `CareerStartNumber`, perc.`PersonId` AS `PersonId`, orgh.`PrimaryOrganisationId` AS `OrganisationId`, rs.`RaceSessionId` AS `RaceSessionId`, rst.`ResultType` AS `SessionTypeResultType`, rc.`Name` AS `RacingClassName`, rt.`Name` AS `TireName`, rt.`Colour` AS `TireColour`, eng.`Name` AS `EngineName`, eng.`ReleaseDate` AS `EngineReleaseDate`, eng.`CylinderCount` AS `EngineCylinderCount`, eng.`EngineType` AS `EngineType`, eng.`Volume` AS `EngineVolume`, eman.`Name` AS `EngineManufacturerName`, chas.`Name` AS `ChassisName`, chas.`ReleaseDate` AS `ChassisReleaseDate` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `PersonCareer` perc ON perc.`PersonCareerId` = par.`PersonCareerId` JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId JOIN `RaceSessions` rs ON par.`RaceSessionId` = rs.`RaceSessionId` JOIN `RacingSessionTypes` rst ON rst.`RacingSessionTypeId` = rs.`RacingSessionTypeId` JOIN `RaceCalendar` cal ON cal.`RaceCalendarId` = rs.`RaceCalendarId` JOIN `RacingClasses` rc ON par.`RacingClassId` = rc.`RacingClassId` JOIN `Engines` eng ON eng.`EngineId` = par.`EngineId` JOIN `Chassis` chas ON par.`ChassisId` = chas.`ChassisId` JOIN `OrganisationHistory` eman ON eng.`ManufacturerOrganisationHistoryId` = eman.`OrganisationHistoryId` JOIN `OrganisationHistory` cman ON chas.`ManufacturerOrganisationHistoryId` = cman.`OrganisationHistoryId` JOIN `RacingTires` rt ON par.`RacingTireId` = rt.`RacingTireId` WHERE 1 = 1 AND (RaceSeasonId = :param1) AND rst.ResultType = :param2 AND res.Position = :param3 ORDER BY rs.StartTime
{":param1":42,":param2":"race",":param3":1}
0.097323
query01 returned 17 rows (21Q - total module time: 0.08583117s)
""
0.002206090.097327/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1000(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:385(fetchAll)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(findResultsByCriteria)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
/* findByCriteria02 */ SELECT res.`RaceResultId`, perc.`PersonCareerId` AS `PersonCareerId`, perc.`StartDate` AS `CareerStartDate`, perc.`EndDate` AS `CareerEndDate`, perc.`ProfilePhoto` AS `CareerPhoto`, perc.`StartNumber` AS `CareerStartNumber`, prt.`Name` AS `CareerRoleName`, per.`PersonId` AS `PersonId`, per.`Nationality` AS `PersonNationality`, per.`LastName` AS `PersonLastName`, per.`FirstName` AS `PersonFirstName`, per.`BirthDate` AS `PersonBirthDate`, per.`DateOfDeath` AS `PersonDateOfDeath`, per.`Residence` AS `PersonResidence`, per.`ProfilePhoto` AS `PersonPhoto`, per.`Height` AS `PersonHeight`, per.`Website` AS `PersonWebsite`, per.`Weight` AS `PersonWeight`, per.`BirthCity` AS `PersonBirthCity`, orgh.`OrganisationHistoryId` AS `OrganisationHistoryId`, orgh.`Name` AS `OrghName`, orgh.`StartDate` AS `OrghStartDate`, orgh.`EndDate` AS `OrghEndDate`, orgh.`Photo` AS `OrghPhoto`, orgh.`City` AS `OrghCity`, orgh.Website AS `OrghWebsite`, orgh.`SmallLogo` AS `OrghSmallLogo`, org.`OrganisationId`, org.`Nationality` AS `OrgNationality`, org.`Name` AS `OrgName`, org.`FoundingDate` AS `OrgFoundingDate`, org.`Photo` AS `OrgPhoto`, kw1.`Keyword` AS `OrgKeyword`, kw1.`RewriteUrl` AS `OrgRewriteUrl`, kw2.`Keyword` AS `PersonKeyword`, kw2.`RewriteUrl` AS `PersonRewriteUrl` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `PersonCareer` perc ON perc.`PersonCareerId` = par.`PersonCareerId` JOIN `PersonRoles` pr ON perc.`PersonRoleId` = pr.`PersonRoleId` JOIN `PersonRolesTranslations` prt ON pr.`PersonRoleId` = prt.`PersonRoleId` AND prt.`LanguageCode` = 'en' JOIN `Persons` per ON per.PersonId = perc.PersonId JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId JOIN `Organisations` org ON org.OrganisationId = orgh.PrimaryOrganisationId JOIN `db_countries` co1 ON co1.`iso` = org.`Nationality` JOIN `db_countries` co2 ON co2.`iso` = per.`Nationality` JOIN `Keywords` kw1 ON org.`KeywordId` = kw1.`KeywordId` JOIN `Keywords` kw2 ON per.`KeywordId` = kw2.`KeywordId` WHERE res.`RaceParticipantId` IN (24320,24459,24599,24742,24901,25036,25176,25309,25456,25597,25746,25886,25986,26126,26266,26411,26553)
{":param1":42,":param2":"race",":param3":1}
0.001451020.099575/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1000(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:432(fetchAll)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(findResultsByCriteria)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
/* findByCriteria03 */ SELECT res.`RaceParticipantId`, res.`RaceResultId`, rs.`RaceSessionId` AS `RaceSessionId`, rs.`StartTime` AS `SessionStartTime`, rs.`EndTime` AS `SessionEndTime`, rs.`TrackTemperature` AS `TrackTemperature`, rs.`AirTemperature` AS `AirTemperature`, rs.`TrackFlag` AS `TrackFlag`, cal.`RaceCalendarId` AS `RaceCalendarId`, cal.`RaceSeasonId` AS `RaceSeasonId`, cal.`GridPosition` AS `GridPosition`, rs.`PhotoAlbumId` AS `SessionPhotoAlbumId`, rst.`RewriteUrl` AS `SessionTypeRewriteUrl`, rst.`ResultType` AS `SessionTypeResultType`, re.`RewriteUrl` AS `RaceEventRewriteUrl`, re.`CountryIso` AS `RaceEventIso`, ret.`Name` AS `RaceEventName`, rt.`Name` AS `TireName`, rt.`Colour` AS `TireColour`, rse.`RewriteUrl` AS `RacingSerieRewriteUrl`, rset.`ShortName` AS `RacingSerieShortName`, rset.`LongName` AS `RacingSeriesLongName` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `RaceSessions` rs ON par.`RaceSessionId` = rs.`RaceSessionId` JOIN `RacingSessionTypes` rst ON rst.`RacingSessionTypeId` = rs.`RacingSessionTypeId` JOIN `RacingSessionTypesTranslations` rstt ON rst.`RacingSessionTypeId` = rstt.`RacingSessionTypeId` AND rstt.`LanguageCode` = 'en' JOIN `RaceCalendar` cal ON cal.`RaceCalendarId` = rs.`RaceCalendarId` JOIN `RacingEvents` re ON re.`RacingEventId` = cal.`RacingEventId` JOIN `RacingEventsTranslations` ret ON re.`RacingEventId` = ret.`RacingEventId` AND ret.`LanguageCode` = 'en' JOIN `RacingTires` rt ON par.`RacingTireId` = rt.`RacingTireId` JOIN `RacingClasses` rc ON par.`RacingClassId` = rc.`RacingClassId` JOIN `RacingSeries` rse ON rc.`RacingSerieId` = rse.`RacingSerieId` JOIN `RacingSeriesTranslations` rset ON rse.`RacingSerieId` = rset.`RacingSerieId` AND rset.`LanguageCode` = 'en' WHERE res.`RaceParticipantId` IN (24320,24459,24599,24742,24901,25036,25176,25309,25456,25597,25746,25886,25986,26126,26266,26411,26553)
{":param1":42,":param2":"race",":param3":1}
0.001034020.101126/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceSessionIncident.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceSessionIncident.php:54(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:439(findByParticipants)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(findResultsByCriteria)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceSessionIncidentId AS RaceSessionIncidentId_0, r0_.StartTime AS StartTime_1, r0_.EndTime AS EndTime_2, r0_.LapNumber AS LapNumber_3, r1_.RacingIncidentId AS RacingIncidentId_4, r1_.IncidentType AS IncidentType_5, r1_.PenaltyPoints AS PenaltyPoints_6, r1_.PenaltyPositions AS PenaltyPositions_7, r2_.RacingIncidentsTranslationId AS RacingIncidentsTranslationId_8, r2_.LanguageCode AS LanguageCode_9, r2_.Description AS Description_10, r3_.RaceParticipantId AS RaceParticipantId_11, p4_.PersonCareerId AS PersonCareerId_12, p4_.StartDate AS StartDate_13, p4_.EndDate AS EndDate_14, p4_.ProfilePhoto AS ProfilePhoto_15, p4_.StartNumber AS StartNumber_16, p5_.PersonId AS PersonId_17, p5_.LastName AS LastName_18, p5_.FirstName AS FirstName_19, p5_.Birthdate AS Birthdate_20, p5_.DateOfDeath AS DateOfDeath_21, p5_.Residence AS Residence_22, p5_.BirthCity AS BirthCity_23, p5_.ProfilePhoto AS ProfilePhoto_24, p5_.Height AS Height_25, p5_.Website AS Website_26, p5_.Weight AS Weight_27, p5_.InternalNotes AS InternalNotes_28, p5_.InHeaderList AS InHeaderList_29, p5_.InFooterList AS InFooterList_30, d6_.iso AS iso_31, d6_.iso3 AS iso3_32, d6_.numcode AS numcode_33, d7_.cntnlang AS cntnlang_34, d7_.printable_name AS printable_name_35, r0_.RacingIncidentId AS RacingIncidentId_36, r0_.RaceParticipantId AS RaceParticipantId_37, r0_.RacingIncidentLocationId AS RacingIncidentLocationId_38, r2_.RacingIncidentId AS RacingIncidentId_39, r3_.RaceSessionId AS RaceSessionId_40, r3_.PersonCareerId AS PersonCareerId_41, r3_.RacingClassId AS RacingClassId_42, r3_.EngineId AS EngineId_43, r3_.RacingTireId AS RacingTireId_44, r3_.ChassisId AS ChassisId_45, p4_.PersonRoleId AS PersonRoleId_46, p4_.OrganisationHistoryId AS OrganisationHistoryId_47, p4_.PersonId AS PersonId_48, p5_.Nationality AS Nationality_49, p5_.KeywordId AS KeywordId_50, p5_.PrimaryCareerId AS PrimaryCareerId_51, p5_.SiteId AS SiteId_52, d7_.ISO AS ISO_53 FROM RaceSessionIncidents r0_ INNER JOIN RacingIncidents r1_ ON r0_.RacingIncidentId = r1_.RacingIncidentId INNER JOIN RacingIncidentsTranslations r2_ ON r1_.RacingIncidentId = r2_.RacingIncidentId AND (r2_.LanguageCode = 'en') INNER JOIN RaceParticipants r3_ ON r0_.RaceParticipantId = r3_.RaceParticipantId INNER JOIN PersonCareer p4_ ON r3_.PersonCareerId = p4_.PersonCareerId INNER JOIN Persons p5_ ON p4_.PersonId = p5_.PersonId INNER JOIN db_countries d6_ ON p5_.Nationality = d6_.iso INNER JOIN db_countries_trnsl d7_ ON d6_.iso = d7_.ISO WHERE r0_.RaceParticipantId IN (?)
[{"24320":"24320","24459":"24459","24599":"24599","24742":"24742","24901":"24901","25036":"25036","25176":"25176","25309":"25309","25456":"25456","25597":"25597","25746":"25746","25886":"25886","25986":"25986","26126":"26126","26266":"26266","26411":"26411","26553":"26553"}]
0.020217900.102379/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["241"]]
0.000597950.123111/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["242"]]
0.006618020.124117/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["243"]]
0.003457070.131232/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["244"]]
0.002630230.135224/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["245"]]
0.000815150.146160/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["246"]]
0.000695940.149364/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["247"]]
0.007686850.150495/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["248"]]
0.003767970.158689/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["249"]]
0.003540990.162938/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["250"]]
0.000943900.166945/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["251"]]
0.002070190.168311/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["252"]]
0.000800850.170808/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["253"]]
0.000596050.171955/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["254"]]
0.002531050.172943/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["256"]]
0.000758890.175944/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["257"]]
0.001135110.177147/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:104(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["258"]]
0.004474880.178652/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1000(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:319(fetchAll)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(findResultsByCriteria)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:105(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
/* findByCriteria01 */ SELECT CASE WHEN res.`LapTime` <= 0.0 THEN 1 ELSE -1 END AS `SortOne`, CASE WHEN res.`LapCount` <= 0 THEN 1 ELSE -1 END AS `SortTwo`, CASE WHEN res.`Position` <= 0 THEN 9999 ELSE res.`Position` END AS `SortThree`, res.`RaceResultId`, res.`RaceParticipantId`, res.`LapTime`, res.`LapCount`, res.`Position`, res.`Result`, res.`DidNotFinish`, res.`DidNotStart`, res.`Points`, res.`Pitted`, res.`MaxSpeed`, res.`AverageSpeed`, perc.`PersonCareerId` AS `PersonCareerId`, perc.`StartDate` AS `CareerStartDate`, perc.`EndDate` AS `CareerEndDate`, perc.`ProfilePhoto` AS `CareerPhoto`, perc.`StartNumber` AS `CareerStartNumber`, perc.`PersonId` AS `PersonId`, orgh.`PrimaryOrganisationId` AS `OrganisationId`, rs.`RaceSessionId` AS `RaceSessionId`, rst.`ResultType` AS `SessionTypeResultType`, rc.`Name` AS `RacingClassName`, rt.`Name` AS `TireName`, rt.`Colour` AS `TireColour`, eng.`Name` AS `EngineName`, eng.`ReleaseDate` AS `EngineReleaseDate`, eng.`CylinderCount` AS `EngineCylinderCount`, eng.`EngineType` AS `EngineType`, eng.`Volume` AS `EngineVolume`, eman.`Name` AS `EngineManufacturerName`, chas.`Name` AS `ChassisName`, chas.`ReleaseDate` AS `ChassisReleaseDate` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `PersonCareer` perc ON perc.`PersonCareerId` = par.`PersonCareerId` JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId JOIN `RaceSessions` rs ON par.`RaceSessionId` = rs.`RaceSessionId` JOIN `RacingSessionTypes` rst ON rst.`RacingSessionTypeId` = rs.`RacingSessionTypeId` JOIN `RaceCalendar` cal ON cal.`RaceCalendarId` = rs.`RaceCalendarId` JOIN `RacingClasses` rc ON par.`RacingClassId` = rc.`RacingClassId` JOIN `Engines` eng ON eng.`EngineId` = par.`EngineId` JOIN `Chassis` chas ON par.`ChassisId` = chas.`ChassisId` JOIN `OrganisationHistory` eman ON eng.`ManufacturerOrganisationHistoryId` = eman.`OrganisationHistoryId` JOIN `OrganisationHistory` cman ON chas.`ManufacturerOrganisationHistoryId` = cman.`OrganisationHistoryId` JOIN `RacingTires` rt ON par.`RacingTireId` = rt.`RacingTireId` WHERE 1 = 1 AND (RaceSeasonId = :param1) AND rst.ResultType = :param2 AND res.Position = :param3 ORDER BY rs.StartTime
{":param1":42,":param2":"startgrid",":param3":1}
0.183158
query01 returned 9 rows (14Q - total module time: 0.09438801s)
""
0.006340030.183162/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1000(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:385(fetchAll)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(findResultsByCriteria)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:105(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
/* findByCriteria02 */ SELECT res.`RaceResultId`, perc.`PersonCareerId` AS `PersonCareerId`, perc.`StartDate` AS `CareerStartDate`, perc.`EndDate` AS `CareerEndDate`, perc.`ProfilePhoto` AS `CareerPhoto`, perc.`StartNumber` AS `CareerStartNumber`, prt.`Name` AS `CareerRoleName`, per.`PersonId` AS `PersonId`, per.`Nationality` AS `PersonNationality`, per.`LastName` AS `PersonLastName`, per.`FirstName` AS `PersonFirstName`, per.`BirthDate` AS `PersonBirthDate`, per.`DateOfDeath` AS `PersonDateOfDeath`, per.`Residence` AS `PersonResidence`, per.`ProfilePhoto` AS `PersonPhoto`, per.`Height` AS `PersonHeight`, per.`Website` AS `PersonWebsite`, per.`Weight` AS `PersonWeight`, per.`BirthCity` AS `PersonBirthCity`, orgh.`OrganisationHistoryId` AS `OrganisationHistoryId`, orgh.`Name` AS `OrghName`, orgh.`StartDate` AS `OrghStartDate`, orgh.`EndDate` AS `OrghEndDate`, orgh.`Photo` AS `OrghPhoto`, orgh.`City` AS `OrghCity`, orgh.Website AS `OrghWebsite`, orgh.`SmallLogo` AS `OrghSmallLogo`, org.`OrganisationId`, org.`Nationality` AS `OrgNationality`, org.`Name` AS `OrgName`, org.`FoundingDate` AS `OrgFoundingDate`, org.`Photo` AS `OrgPhoto`, kw1.`Keyword` AS `OrgKeyword`, kw1.`RewriteUrl` AS `OrgRewriteUrl`, kw2.`Keyword` AS `PersonKeyword`, kw2.`RewriteUrl` AS `PersonRewriteUrl` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `PersonCareer` perc ON perc.`PersonCareerId` = par.`PersonCareerId` JOIN `PersonRoles` pr ON perc.`PersonRoleId` = pr.`PersonRoleId` JOIN `PersonRolesTranslations` prt ON pr.`PersonRoleId` = prt.`PersonRoleId` AND prt.`LanguageCode` = 'en' JOIN `Persons` per ON per.PersonId = perc.PersonId JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId JOIN `Organisations` org ON org.OrganisationId = orgh.PrimaryOrganisationId JOIN `db_countries` co1 ON co1.`iso` = org.`Nationality` JOIN `db_countries` co2 ON co2.`iso` = per.`Nationality` JOIN `Keywords` kw1 ON org.`KeywordId` = kw1.`KeywordId` JOIN `Keywords` kw2 ON per.`KeywordId` = kw2.`KeywordId` WHERE res.`RaceParticipantId` IN (24300,24439,24579,24722,24877,25156,25436,26108,26533)
{":param1":42,":param2":"startgrid",":param3":1}
0.003495930.189537/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1000(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:432(fetchAll)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(findResultsByCriteria)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:105(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
/* findByCriteria03 */ SELECT res.`RaceParticipantId`, res.`RaceResultId`, rs.`RaceSessionId` AS `RaceSessionId`, rs.`StartTime` AS `SessionStartTime`, rs.`EndTime` AS `SessionEndTime`, rs.`TrackTemperature` AS `TrackTemperature`, rs.`AirTemperature` AS `AirTemperature`, rs.`TrackFlag` AS `TrackFlag`, cal.`RaceCalendarId` AS `RaceCalendarId`, cal.`RaceSeasonId` AS `RaceSeasonId`, cal.`GridPosition` AS `GridPosition`, rs.`PhotoAlbumId` AS `SessionPhotoAlbumId`, rst.`RewriteUrl` AS `SessionTypeRewriteUrl`, rst.`ResultType` AS `SessionTypeResultType`, re.`RewriteUrl` AS `RaceEventRewriteUrl`, re.`CountryIso` AS `RaceEventIso`, ret.`Name` AS `RaceEventName`, rt.`Name` AS `TireName`, rt.`Colour` AS `TireColour`, rse.`RewriteUrl` AS `RacingSerieRewriteUrl`, rset.`ShortName` AS `RacingSerieShortName`, rset.`LongName` AS `RacingSeriesLongName` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `RaceSessions` rs ON par.`RaceSessionId` = rs.`RaceSessionId` JOIN `RacingSessionTypes` rst ON rst.`RacingSessionTypeId` = rs.`RacingSessionTypeId` JOIN `RacingSessionTypesTranslations` rstt ON rst.`RacingSessionTypeId` = rstt.`RacingSessionTypeId` AND rstt.`LanguageCode` = 'en' JOIN `RaceCalendar` cal ON cal.`RaceCalendarId` = rs.`RaceCalendarId` JOIN `RacingEvents` re ON re.`RacingEventId` = cal.`RacingEventId` JOIN `RacingEventsTranslations` ret ON re.`RacingEventId` = ret.`RacingEventId` AND ret.`LanguageCode` = 'en' JOIN `RacingTires` rt ON par.`RacingTireId` = rt.`RacingTireId` JOIN `RacingClasses` rc ON par.`RacingClassId` = rc.`RacingClassId` JOIN `RacingSeries` rse ON rc.`RacingSerieId` = rse.`RacingSerieId` JOIN `RacingSeriesTranslations` rset ON rse.`RacingSerieId` = rset.`RacingSerieId` AND rset.`LanguageCode` = 'en' WHERE res.`RaceParticipantId` IN (24300,24439,24579,24722,24877,25156,25436,26108,26533)
{":param1":42,":param2":"startgrid",":param3":1}
0.001297000.193136/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceSessionIncident.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceSessionIncident.php:54(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:439(findByParticipants)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(findResultsByCriteria)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:105(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceSessionIncidentId AS RaceSessionIncidentId_0, r0_.StartTime AS StartTime_1, r0_.EndTime AS EndTime_2, r0_.LapNumber AS LapNumber_3, r1_.RacingIncidentId AS RacingIncidentId_4, r1_.IncidentType AS IncidentType_5, r1_.PenaltyPoints AS PenaltyPoints_6, r1_.PenaltyPositions AS PenaltyPositions_7, r2_.RacingIncidentsTranslationId AS RacingIncidentsTranslationId_8, r2_.LanguageCode AS LanguageCode_9, r2_.Description AS Description_10, r3_.RaceParticipantId AS RaceParticipantId_11, p4_.PersonCareerId AS PersonCareerId_12, p4_.StartDate AS StartDate_13, p4_.EndDate AS EndDate_14, p4_.ProfilePhoto AS ProfilePhoto_15, p4_.StartNumber AS StartNumber_16, p5_.PersonId AS PersonId_17, p5_.LastName AS LastName_18, p5_.FirstName AS FirstName_19, p5_.Birthdate AS Birthdate_20, p5_.DateOfDeath AS DateOfDeath_21, p5_.Residence AS Residence_22, p5_.BirthCity AS BirthCity_23, p5_.ProfilePhoto AS ProfilePhoto_24, p5_.Height AS Height_25, p5_.Website AS Website_26, p5_.Weight AS Weight_27, p5_.InternalNotes AS InternalNotes_28, p5_.InHeaderList AS InHeaderList_29, p5_.InFooterList AS InFooterList_30, d6_.iso AS iso_31, d6_.iso3 AS iso3_32, d6_.numcode AS numcode_33, d7_.cntnlang AS cntnlang_34, d7_.printable_name AS printable_name_35, r0_.RacingIncidentId AS RacingIncidentId_36, r0_.RaceParticipantId AS RaceParticipantId_37, r0_.RacingIncidentLocationId AS RacingIncidentLocationId_38, r2_.RacingIncidentId AS RacingIncidentId_39, r3_.RaceSessionId AS RaceSessionId_40, r3_.PersonCareerId AS PersonCareerId_41, r3_.RacingClassId AS RacingClassId_42, r3_.EngineId AS EngineId_43, r3_.RacingTireId AS RacingTireId_44, r3_.ChassisId AS ChassisId_45, p4_.PersonRoleId AS PersonRoleId_46, p4_.OrganisationHistoryId AS OrganisationHistoryId_47, p4_.PersonId AS PersonId_48, p5_.Nationality AS Nationality_49, p5_.KeywordId AS KeywordId_50, p5_.PrimaryCareerId AS PrimaryCareerId_51, p5_.SiteId AS SiteId_52, d7_.ISO AS ISO_53 FROM RaceSessionIncidents r0_ INNER JOIN RacingIncidents r1_ ON r0_.RacingIncidentId = r1_.RacingIncidentId INNER JOIN RacingIncidentsTranslations r2_ ON r1_.RacingIncidentId = r2_.RacingIncidentId AND (r2_.LanguageCode = 'en') INNER JOIN RaceParticipants r3_ ON r0_.RaceParticipantId = r3_.RaceParticipantId INNER JOIN PersonCareer p4_ ON r3_.PersonCareerId = p4_.PersonCareerId INNER JOIN Persons p5_ ON p4_.PersonId = p5_.PersonId INNER JOIN db_countries d6_ ON p5_.Nationality = d6_.iso INNER JOIN db_countries_trnsl d7_ ON d6_.iso = d7_.ISO WHERE r0_.RaceParticipantId IN (?)
[{"24300":"24300","24439":"24439","24579":"24579","24722":"24722","24877":"24877","25156":"25156","25436":"25436","26108":"26108","26533":"26533"}]
0.000442030.194610/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:105(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["241"]]
0.000880960.195524/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:105(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["242"]]
0.003182890.199615/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:105(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["243"]]
0.004040000.203251/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:105(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["244"]]
0.000192880.207761/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:105(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["245"]]
0.000206950.208354/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:105(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["247"]]
0.000283000.208946/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:105(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["249"]]
0.000471120.209617/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:105(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["254"]]
0.001233100.210507/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceCalendar.php:120(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:139(findByIdList)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/RaceResults.php:561(splitResultsPerEvent)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:105(findFirstPlaceFromSeasonAndResultType)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC
["en","en",["258"]]
0.000931980.212166/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Article.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:937(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Article.php:124(getScalarResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Article.php:704(commonCriteria)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:115(findRaceReport)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT c0_.ContentLanguage AS ContentLanguage_0 FROM ContentLanguageMapping c0_ WHERE (c0_.ContentType = ? AND c0_.ContentSubType IN (?) AND c0_.SiteLanguage = ?) AND (c0_.SiteId IN ('1'))
["Articles",["Nieuws","LiveRaceReport","Liveblog"],"en"]
0.000802990.213364/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Article.php/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1323(stopQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31(executeQuery)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325(execute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212(_doExecute)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166(executeIgnoreQueryCache)
/var/www/dev-priyantha.gptoday.net/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901(execute)
/var/www/dev-priyantha.gptoday.net/public_html/app/Repository/Article.php:710(getResult)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:115(findRaceReport)
/var/www/dev-priyantha.gptoday.net/public_html/app/Controllers/Season.php:68(action_results)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:269(dispatch)
/var/www/dev-priyantha.gptoday.net/public_html/app/Router.php:195(_load)
/var/www/dev-priyantha.gptoday.net/public_html/app/website.php:260(execute)
/var/www/dev-priyantha.gptoday.net/public_html/index.php:11(require_once)
SELECT a0_.ArticleId AS ArticleId_0, a0_.RewriteUrl AS RewriteUrl_1, a0_.Title AS Title_2, a0_.SeoDescription AS SeoDescription_3, a0_.SeoTitle AS SeoTitle_4, a0_.coAuthor AS coAuthor_5, a0_.Icon AS Icon_6, a0_.Category AS Category_7, a0_.Content AS Content_8, a0_.PublishDate AS PublishDate_9, a0_.CreateDate AS CreateDate_10, a0_.CreateTime AS CreateTime_11, a0_.CommentType AS CommentType_12, a0_.AllowNewComments AS AllowNewComments_13, a0_.cntnlang AS cntnlang_14, a0_.LastUpdateDate AS LastUpdateDate_15, a0_.ArticleType AS ArticleType_16, a0_.CommentCount AS CommentCount_17, a0_.Activated AS Activated_18, a0_.StickyUntil AS StickyUntil_19, a0_.ViewCount AS ViewCount_20, a0_.PushEnabled AS PushEnabled_21, a0_.PushTitle AS PushTitle_22, a0_.PushMessage AS PushMessage_23, a0_.breaking AS breaking_24, a0_.breaking_title AS breaking_title_25, a0_.TestMode AS TestMode_26, r1_.RacingSerieId AS RacingSerieId_27, r1_.RewriteUrl AS RewriteUrl_28, r1_.IsDefault AS IsDefault_29, r2_.RacingSeriesTranslationId AS RacingSeriesTranslationId_30, r2_.LanguageCode AS LanguageCode_31, r2_.ShortName AS ShortName_32, r2_.LongName AS LongName_33, a0_.SiteId AS SiteId_34, a0_.RaceTrackHistoryId AS RaceTrackHistoryId_35, a0_.RacingSerieId AS RacingSerieId_36, a0_.PhotoAlbumId AS PhotoAlbumId_37, a0_.CmsAccountId AS CmsAccountId_38, a0_.PollId AS PollId_39, a0_.RaceSessionId AS RaceSessionId_40, r1_.SiteId AS SiteId_41, r1_.CountryIso AS CountryIso_42, r2_.RacingSerieId AS RacingSerieId_43 FROM Articles a0_ INNER JOIN RacingSeries r1_ ON a0_.RacingSerieId = r1_.RacingSerieId AND (r1_.SiteId IN ('1')) INNER JOIN RacingSeriesTranslations r2_ ON r1_.RacingSerieId = r2_.RacingSerieId AND (r2_.LanguageCode = 'en') WHERE ((((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.Category = ?) AND a0_.RaceSessionId IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 100
[["en"],["1"],true,{"date":"2025-12-11 02:40:00.000000","timezone_type":3,"timezone":"Europe\/Amsterdam"},["Nieuws","LiveRaceReport","Liveblog"],9,[1450,1457,1464,1471,1478,1485,1492,1499,1506,1513,1520,1527,1534,1541,1555,1562,1569]]
0.277551 cacheAble: yes
module:Layout\Footer (0Q - total module time: 0.00020599s)
""
0.278797 cacheAble: yes
module:News\Breaking (0Q - total module time: 0.01082516s)
""
0.289628
done
""