F1 Test calendar 2024

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

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

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

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

controller::season/calendar/f1/tests (8Q - total module time: 0.06674004s)

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

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, r2_.RacingSeriesTranslationId AS RacingSeriesTranslationId_5, r2_.LanguageCode AS LanguageCode_6, r2_.ShortName AS ShortName_7, r2_.LongName AS LongName_8, r0_.SiteId AS SiteId_9, r0_.RacingSerieId AS RacingSerieId_10, r1_.SiteId AS SiteId_11, r1_.CountryIso AS CountryIso_12, r2_.RacingSerieId AS RacingSerieId_13 FROM RaceSeasons r0_ INNER JOIN RacingSeries r1_ ON r0_.RacingSerieId = r1_.RacingSerieId AND (r1_.SiteId IN ('1')) INNER JOIN RacingSeriesTranslations r2_ ON r1_.RacingSerieId = r2_.RacingSerieId AND (r2_.LanguageCode = 'en') WHERE (r1_.RewriteUrl = ? AND r1_.SiteId IN (?)) AND (r0_.SiteId IN ('1')) ORDER BY r0_.Year DESC LIMIT 1

SELECT r0_.RacingEventTypeId AS RacingEventTypeId_0, r0_.Name AS Name_1, r0_.RewriteUrl AS RewriteUrl_2 FROM RacingEventTypes r0_ WHERE r0_.RewriteUrl = ?

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

SELECT r0_.RacingSessionTypeId AS RacingSessionTypeId_0, r0_.RewriteUrl AS RewriteUrl_1, r0_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_2, r0_.SortingOrder AS SortingOrder_3, r0_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_4, r0_.MainEventAtBeginning AS MainEventAtBeginning_5, r0_.DefaultDuration AS DefaultDuration_6, r0_.ResultType AS ResultType_7, r0_.DefaultAdd AS DefaultAdd_8, r0_.RacingSerieId AS RacingSerieId_9, r0_.RacingEventTypeId AS RacingEventTypeId_10 FROM RacingSessionTypes r0_ WHERE r0_.RacingSerieId = ? AND r0_.RacingEventTypeId = ?

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_.RaceSessionId IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 100

/* 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

query01 returned 0 rows (1Q - total module time: 0.06058908s)

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

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

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