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

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

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

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

controller::results/startgrid/2024/11/24/las-vegas-grand-prix (7Q - total module time: 0.00775290s)

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 = ?

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.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.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.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 = ?

/* 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 0 rows (2Q - total module time: 0.00075698s)

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 0 rows (3Q - total module time: 0.00039697s)

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 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 = ?

/* 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 0 rows (4Q - total module time: 0.01606297s)

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

module:Circuit (1Q - total module time: 0.00310493s)

SELECT r0_.RaceTrackId AS RaceTrackId_0, r0_.Name AS Name_1, r0_.RewriteUrl AS RewriteUrl_2, r0_.FoundingDate AS FoundingDate_3, r0_.Website AS Website_4, r0_.Description AS Description_5, c1_.CityId AS CityId_6, c1_.Latitude AS Latitude_7, c1_.Longitude AS Longitude_8, c1_.TimeOffsetFromUtc AS TimeOffsetFromUtc_9, c2_.CityTranslationId AS CityTranslationId_10, c2_.LanguageCode AS LanguageCode_11, c2_.Name AS Name_12, d3_.iso AS iso_13, d3_.iso3 AS iso3_14, d3_.numcode AS numcode_15, d4_.cntnlang AS cntnlang_16, d4_.printable_name AS printable_name_17, r0_.CityId AS CityId_18, c1_.Country AS Country_19, c2_.CityId AS CityId_20, d4_.ISO AS ISO_21 FROM RaceTracks r0_ INNER JOIN Cities c1_ ON r0_.CityId = c1_.CityId INNER JOIN CityTranslations c2_ ON c1_.CityId = c2_.CityId AND (c2_.LanguageCode = 'en') INNER JOIN db_countries d3_ ON c1_.Country = d3_.iso INNER JOIN db_countries_trnsl d4_ ON d3_.iso = d4_.ISO WHERE r0_.RewriteUrl = ? AND d4_.cntnlang = ?

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