F1 Race results of 19 March 2023 on Jeddah Street Circuit

instantiate query log (0Q - total module time: 0.00064683s)

boot (0Q - total module time: 0.00011110s)

translation-init (1Q - total module time: 0.00097704s)

SELECT redirects.id, redirects.origin, redirects.referer FROM redirects WHERE redirects.origin = :origin ORDER BY id

controller::results/race/2023/03/19/saudi-arabian-grand-prix (2Q - total module time: 0.05822396s)

SELECT r0_.RaceSessionId AS RaceSessionId_0, r0_.StartTime AS StartTime_1, r0_.EndTime AS EndTime_2, r0_.TrackTemperature AS TrackTemperature_3, r0_.AirTemperature AS AirTemperature_4, r0_.TrackFlag AS TrackFlag_5, r1_.RaceCalendarId AS RaceCalendarId_6, r1_.GridPosition AS GridPosition_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RacingSessionTypeId AS RacingSessionTypeId_11, r3_.RewriteUrl AS RewriteUrl_12, r3_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_13, r3_.SortingOrder AS SortingOrder_14, r3_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_15, r3_.MainEventAtBeginning AS MainEventAtBeginning_16, r3_.DefaultDuration AS DefaultDuration_17, r3_.ResultType AS ResultType_18, r3_.DefaultAdd AS DefaultAdd_19, r4_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_20, r4_.LanguageCode AS LanguageCode_21, r4_.Name AS Name_22, r5_.RaceSeasonId AS RaceSeasonId_23, r5_.Year AS Year_24, r6_.RaceTrackHistoryId AS RaceTrackHistoryId_25, r6_.LapLength AS LapLength_26, r6_.LapCount AS LapCount_27, r6_.Map AS Map_28, r6_.Impression AS Impression_29, r6_.StartDate AS StartDate_30, r6_.EndDate AS EndDate_31, r7_.RaceTrackId AS RaceTrackId_32, r7_.Name AS Name_33, r7_.RewriteUrl AS RewriteUrl_34, r7_.FoundingDate AS FoundingDate_35, r7_.Website AS Website_36, r7_.Description AS Description_37, c8_.CityId AS CityId_38, c8_.Latitude AS Latitude_39, c8_.Longitude AS Longitude_40, c8_.TimeOffsetFromUtc AS TimeOffsetFromUtc_41, c9_.CityTranslationId AS CityTranslationId_42, c9_.LanguageCode AS LanguageCode_43, c9_.Name AS Name_44, d10_.iso AS iso_45, d10_.iso3 AS iso3_46, d10_.numcode AS numcode_47, d11_.cntnlang AS cntnlang_48, d11_.printable_name AS printable_name_49, r12_.RacingEventsTranslationId AS RacingEventsTranslationId_50, r12_.LanguageCode AS LanguageCode_51, r12_.Name AS Name_52, r0_.RacingSessionTypeId AS RacingSessionTypeId_53, r0_.RaceCalendarId AS RaceCalendarId_54, r0_.WeatherTypeId AS WeatherTypeId_55, r0_.PhotoAlbumId AS PhotoAlbumId_56, r1_.RaceSeasonId AS RaceSeasonId_57, r1_.RacingEventId AS RacingEventId_58, r1_.RaceTrackHistoryId AS RaceTrackHistoryId_59, r2_.CircuitId AS CircuitId_60, r2_.WinnerId AS WinnerId_61, r2_.RacingSerieId AS RacingSerieId_62, r2_.RacingEventTypeId AS RacingEventTypeId_63, r2_.CountryIso AS CountryIso_64, r3_.RacingSerieId AS RacingSerieId_65, r3_.RacingEventTypeId AS RacingEventTypeId_66, r4_.RacingSessionTypeId AS RacingSessionTypeId_67, r5_.SiteId AS SiteId_68, r5_.RacingSerieId AS RacingSerieId_69, r6_.RaceTrackId AS RaceTrackId_70, r7_.CityId AS CityId_71, c8_.Country AS Country_72, c9_.CityId AS CityId_73, d11_.ISO AS ISO_74, r12_.RacingEventId AS RacingEventId_75 FROM RaceSessions r0_ INNER JOIN RaceCalendar r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r1_.RacingEventId = r2_.RacingEventId INNER JOIN RacingSessionTypes r3_ ON r0_.RacingSessionTypeId = r3_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r4_ ON r3_.RacingSessionTypeId = r4_.RacingSessionTypeId AND (r4_.LanguageCode = 'en') INNER JOIN RaceSeasons r5_ ON r1_.RaceSeasonId = r5_.RaceSeasonId AND (r5_.SiteId IN ('1')) INNER JOIN RaceTrackHistory r6_ ON r1_.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 INNER JOIN RacingEventsTranslations r12_ ON r2_.RacingEventId = r12_.RacingEventId AND (r12_.LanguageCode = 'en') WHERE DATE(r0_.StartTime) = ? AND r3_.RewriteUrl = ? AND c9_.LanguageCode = ? AND d11_.cntnlang = ?

/* 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 rs.RaceSessionId = :param1 ORDER BY `SortThree` ASC, `SortTwo` ASC, `res`.`LapCount` DESC

query01 returned 20 rows (4Q - total module time: 0.00329304s)

/* 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 (33923,33922,33912,33920,33921,33914,33915,33910,33911,33916,33909,33917,33906,33908,33919,33925,33918,33907,33924,33913)

/* 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 (33923,33922,33912,33920,33921,33914,33915,33910,33911,33916,33909,33917,33906,33908,33919,33925,33918,33907,33924,33913)

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 (?)

/* 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 rs.RaceSessionId = :param1 ORDER BY `SortThree` ASC, `SortTwo` ASC, `res`.`LapCount` DESC

query01 returned 20 rows (21Q - total module time: 0.04250813s)

/* 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 (33923,33922,33912,33920,33921,33914,33915,33910,33911,33916,33909,33917,33906,33908,33919,33925,33918,33907,33924,33913)

/* 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 (33923,33922,33912,33920,33921,33914,33915,33910,33911,33916,33909,33917,33906,33908,33919,33925,33918,33907,33924,33913)

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 (?)

SELECT 1 AS `SortOne`, 1 AS `SortTwo`, 9999 AS `SortThree`, CONCAT(per.FirstName, ' ', per.LastName) AS `FullDriverName`, per.`PersonId` AS `PersonId`, per.`LastName` AS `DriverLastName`, per.`Nationality` AS `DriverNationality`, orgh.`Name` AS `TeamName`, orgh.`SmallLogo` AS `SmallTeamLogo`, par.`RaceParticipantId`, par.`PersonCareerId`, par.`ChassisId`, par.`EngineId`, par.`RacingClassId`, par.`RacingTireId`, orgh.`OrganisationHistoryId`, 0 AS `LapTime`, 0 AS `LapCount`, 0 AS `RacePosition`, 0 AS `RacePoints`, '' AS `RaceResult`, FALSE AS `DidNotFinish`, FALSE AS `DidNotStart`, FALSE AS `Pitted`, 0 AS `MaxSpeed`, 0 AS `AverageSpeed`, NULL AS `RacingIncident`, 1 AS `HasResults`, chasmanorgh.`SmallLogo` AS `ChassisManufacturerLogo`, ch.`Name` AS `ChassisName` FROM `RaceParticipants` par JOIN `PersonCareer` perc ON perc.PersonCareerId = par.PersonCareerId JOIN `Persons` per ON per.PersonId = perc.PersonId JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId JOIN `OrganisationOrganisationHistory` orglnk ON orglnk.`OrganisationHistoryId` = orgh.`OrganisationHistoryId` LEFT JOIN `Chassis` ch ON ch.`ChassisId` = par.`ChassisId` LEFT JOIN `OrganisationHistory` chasmanorgh ON chasmanorgh.`OrganisationHistoryId` = perc.`OrganisationHistoryId` WHERE par.`RaceSessionId` = :raceSessionId UNION 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`, CONCAT(per.`FirstName`, ' ', per.`LastName`) AS `FullDriverName`, per.`PersonId` AS `PersonId`, per.`LastName` AS `DriverLastName`, per.`Nationality` AS `DriverNationality`, orgh.`Name` AS `TeamName`, orgh.`SmallLogo` AS `SmallTeamLogo`, par.`RaceParticipantId`, par.`PersonCareerId`, par.`ChassisId`, par.`EngineId`, par.`RacingClassId`, par.`RacingTireId`, orgh.`OrganisationHistoryId`, 0 + `LapTime` AS `LapTime`, 0 + `LapCount` AS `LapCount`, 0 + `Position` AS `RacePosition`, 0 + `Points` AS `RacePoints`, `Result` AS `RaceResult`, `DidNotFinish` AS `DidNotFinish`, `DidNotStart` AS `DidNotStart`, `Pitted` AS `Pitted`, 0 + `MaxSpeed` AS `MaxSpeed`, 0 + `AverageSpeed` AS `AverageSpeed`, `RacingIncidentId` AS `RacingIncident`, 2 AS `HasResults`, chasmanorgh.`SmallLogo` AS `ChassisManufacturerLogo`, ch.`Name` AS `ChassisName` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `PersonCareer` perc ON perc.`PersonCareerId` = par.`PersonCareerId` JOIN `Persons` per ON per.PersonId = perc.PersonId JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId JOIN `OrganisationOrganisationHistory` orglnk ON orglnk.`OrganisationHistoryId` = orgh.`OrganisationHistoryId` LEFT JOIN `Chassis` ch ON ch.`ChassisId` = par.`ChassisId` LEFT JOIN `OrganisationHistory` chasmanorgh ON chasmanorgh.`OrganisationHistoryId` = perc.`OrganisationHistoryId` WHERE `RaceSessionId` = :raceSessionId ORDER BY `HasResults` DESC, SortThree ASC, SortTwo ASC, LapCount DESC,`OrganisationHistoryId`, `PersonCareerId`

SELECT c0_.ContentLanguage AS ContentLanguage_0 FROM ContentLanguageMapping c0_ WHERE (c0_.ContentType = ? AND c0_.ContentSubType IN (?) AND c0_.SiteLanguage = ?) AND (c0_.SiteId IN ('1'))

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

SELECT t0.RacingSerieId AS RacingSerieId_1, t0.RewriteUrl AS RewriteUrl_2, t0.IsDefault AS IsDefault_3, t0.SiteId AS SiteId_4, t0.CountryIso AS CountryIso_5 FROM RacingSeries t0 WHERE t0.RacingSerieId = ? AND ((t0.SiteId IN ('1')))

SELECT t0.RacingSeriesTranslationId AS RacingSeriesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.ShortName AS ShortName_3, t0.LongName AS LongName_4, t0.RacingSerieId AS RacingSerieId_5 FROM RacingSeriesTranslations t0 WHERE t0.RacingSerieId = ? AND ((t0.LanguageCode = 'en'))

SELECT t0.RaceSessionId AS RaceSessionId_1, t0.StartTime AS StartTime_2, t0.EndTime AS EndTime_3, t0.TrackTemperature AS TrackTemperature_4, t0.AirTemperature AS AirTemperature_5, t0.TrackFlag AS TrackFlag_6, t0.RacingSessionTypeId AS RacingSessionTypeId_7, t0.RaceCalendarId AS RaceCalendarId_8, t0.WeatherTypeId AS WeatherTypeId_9, t0.PhotoAlbumId AS PhotoAlbumId_10 FROM RaceSessions t0 WHERE t0.RaceCalendarId = ?

SELECT t0.RacingSessionTypeId AS RacingSessionTypeId_1, t0.RewriteUrl AS RewriteUrl_2, t0.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_3, t0.SortingOrder AS SortingOrder_4, t0.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_5, t0.MainEventAtBeginning AS MainEventAtBeginning_6, t0.DefaultDuration AS DefaultDuration_7, t0.ResultType AS ResultType_8, t0.DefaultAdd AS DefaultAdd_9, t0.RacingSerieId AS RacingSerieId_10, t0.RacingEventTypeId AS RacingEventTypeId_11 FROM RacingSessionTypes t0 WHERE t0.RacingSessionTypeId = ?

SELECT t0.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.Name AS Name_3, t0.RacingSessionTypeId AS RacingSessionTypeId_4 FROM RacingSessionTypesTranslations t0 WHERE t0.RacingSessionTypeId = ? AND ((t0.LanguageCode = 'en'))

SELECT t0.RacingSessionTypeId AS RacingSessionTypeId_1, t0.RewriteUrl AS RewriteUrl_2, t0.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_3, t0.SortingOrder AS SortingOrder_4, t0.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_5, t0.MainEventAtBeginning AS MainEventAtBeginning_6, t0.DefaultDuration AS DefaultDuration_7, t0.ResultType AS ResultType_8, t0.DefaultAdd AS DefaultAdd_9, t0.RacingSerieId AS RacingSerieId_10, t0.RacingEventTypeId AS RacingEventTypeId_11 FROM RacingSessionTypes t0 WHERE t0.RacingSessionTypeId = ?

SELECT t0.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.Name AS Name_3, t0.RacingSessionTypeId AS RacingSessionTypeId_4 FROM RacingSessionTypesTranslations t0 WHERE t0.RacingSessionTypeId = ? AND ((t0.LanguageCode = 'en'))

SELECT t0.RacingSessionTypeId AS RacingSessionTypeId_1, t0.RewriteUrl AS RewriteUrl_2, t0.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_3, t0.SortingOrder AS SortingOrder_4, t0.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_5, t0.MainEventAtBeginning AS MainEventAtBeginning_6, t0.DefaultDuration AS DefaultDuration_7, t0.ResultType AS ResultType_8, t0.DefaultAdd AS DefaultAdd_9, t0.RacingSerieId AS RacingSerieId_10, t0.RacingEventTypeId AS RacingEventTypeId_11 FROM RacingSessionTypes t0 WHERE t0.RacingSessionTypeId = ?

SELECT t0.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.Name AS Name_3, t0.RacingSessionTypeId AS RacingSessionTypeId_4 FROM RacingSessionTypesTranslations t0 WHERE t0.RacingSessionTypeId = ? AND ((t0.LanguageCode = 'en'))

SELECT t0.RacingSessionTypeId AS RacingSessionTypeId_1, t0.RewriteUrl AS RewriteUrl_2, t0.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_3, t0.SortingOrder AS SortingOrder_4, t0.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_5, t0.MainEventAtBeginning AS MainEventAtBeginning_6, t0.DefaultDuration AS DefaultDuration_7, t0.ResultType AS ResultType_8, t0.DefaultAdd AS DefaultAdd_9, t0.RacingSerieId AS RacingSerieId_10, t0.RacingEventTypeId AS RacingEventTypeId_11 FROM RacingSessionTypes t0 WHERE t0.RacingSessionTypeId = ?

SELECT t0.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.Name AS Name_3, t0.RacingSessionTypeId AS RacingSessionTypeId_4 FROM RacingSessionTypesTranslations t0 WHERE t0.RacingSessionTypeId = ? AND ((t0.LanguageCode = 'en'))

SELECT t0.RacingSessionTypeId AS RacingSessionTypeId_1, t0.RewriteUrl AS RewriteUrl_2, t0.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_3, t0.SortingOrder AS SortingOrder_4, t0.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_5, t0.MainEventAtBeginning AS MainEventAtBeginning_6, t0.DefaultDuration AS DefaultDuration_7, t0.ResultType AS ResultType_8, t0.DefaultAdd AS DefaultAdd_9, t0.RacingSerieId AS RacingSerieId_10, t0.RacingEventTypeId AS RacingEventTypeId_11 FROM RacingSessionTypes t0 WHERE t0.RacingSessionTypeId = ?

SELECT t0.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.Name AS Name_3, t0.RacingSessionTypeId AS RacingSessionTypeId_4 FROM RacingSessionTypesTranslations t0 WHERE t0.RacingSessionTypeId = ? AND ((t0.LanguageCode = 'en'))

SELECT t0.RacingSessionTypeId AS RacingSessionTypeId_1, t0.RewriteUrl AS RewriteUrl_2, t0.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_3, t0.SortingOrder AS SortingOrder_4, t0.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_5, t0.MainEventAtBeginning AS MainEventAtBeginning_6, t0.DefaultDuration AS DefaultDuration_7, t0.ResultType AS ResultType_8, t0.DefaultAdd AS DefaultAdd_9, t0.RacingSerieId AS RacingSerieId_10, t0.RacingEventTypeId AS RacingEventTypeId_11 FROM RacingSessionTypes t0 WHERE t0.RacingSessionTypeId = ?

SELECT t0.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.Name AS Name_3, t0.RacingSessionTypeId AS RacingSessionTypeId_4 FROM RacingSessionTypesTranslations t0 WHERE t0.RacingSessionTypeId = ? AND ((t0.LanguageCode = 'en'))

module:Circuit (0Q - total module time: 0.00342989s)

module:Sidebar (0Q - total module time: 0.00035000s)

sidebar:sidebar-resultgridpage::ads (0Q - total module time: 0.00001001s)

sidebar:sidebar-resultgridpage::ads (0Q - total module time: 0.00000191s)

sidebar:sidebar-resultgridpage::gpsidebarnavigation (0Q - total module time: 0.00000191s)

module:GpSidebarNavigation (0Q - total module time: 0.00041008s)

sidebar:sidebar-resultgridpage::gpschedule (0Q - total module time: 0.00000501s)

module:GpSchedule (0Q - total module time: 0.00014591s)

sidebar:sidebar-resultgridpage::testcalendar (0Q - total module time: 0.00000286s)

module:TestCalendar (0Q - total module time: 0.00011897s)

sidebar:sidebar-resultgridpage::gpcalendar (0Q - total module time: 0.00000501s)

module:GpCalendar (0Q - total module time: 0.00038099s)

module:Layout\Footer (0Q - total module time: 0.00009489s)

module:News\Breaking (0Q - total module time: 0.00036287s)