Rol van data-analyse en ict in Formule 1 steeds groter

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

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

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

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

controller::nieuws/f1/229800/rol-van-data-analyse-en-ict-in-formule-1-steeds-groter (8Q - total module time: 0.18349791s)

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, p3_.id AS id_34, p3_.year AS year_35, p3_.uservisible AS uservisible_36, p3_.PhotoCount AS PhotoCount_37, p4_.photoalbumNameID AS photoalbumNameID_38, p4_.name AS name_39, p4_.event AS event_40, p4_.cntnlang AS cntnlang_41, c5_.CmsAccountId AS CmsAccountId_42, c5_.CreateDate AS CreateDate_43, c5_.AccountName AS AccountName_44, c5_.Password AS Password_45, c5_.LastName AS LastName_46, c5_.FirstName AS FirstName_47, c5_.PrivateMail AS PrivateMail_48, c5_.F1TodayMail AS F1TodayMail_49, c5_.PhoneNumber AS PhoneNumber_50, c5_.Address AS Address_51, c5_.PostalCode AS PostalCode_52, c5_.City AS City_53, c5_.BirthDate AS BirthDate_54, c5_.JobTitle AS JobTitle_55, c5_.FavouriteDriver AS FavouriteDriver_56, c5_.FavouriteTeam AS FavouriteTeam_57, c5_.Interests AS Interests_58, c5_.WorkStartDate AS WorkStartDate_59, c5_.WorkingHours AS WorkingHours_60, c5_.Disabled AS Disabled_61, c5_.LastOnline AS LastOnline_62, c5_.RetrievalId AS RetrievalId_63, c5_.Notes AS Notes_64, a0_.SiteId AS SiteId_65, a0_.RaceTrackHistoryId AS RaceTrackHistoryId_66, a0_.RacingSerieId AS RacingSerieId_67, a0_.PhotoAlbumId AS PhotoAlbumId_68, a0_.CmsAccountId AS CmsAccountId_69, a0_.PollId AS PollId_70, a0_.RaceSessionId AS RaceSessionId_71, r1_.SiteId AS SiteId_72, r1_.CountryIso AS CountryIso_73, r2_.RacingSerieId AS RacingSerieId_74, p3_.SiteId AS SiteId_75, p4_.photoalbumID AS photoalbumID_76 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 = 'nl') LEFT JOIN photoalbums p3_ ON a0_.PhotoAlbumId = p3_.id AND (p3_.SiteId IN ('1')) LEFT JOIN photoalbum_names p4_ ON p3_.id = p4_.photoalbumID AND (p4_.cntnlang IN (?)) INNER JOIN CmsAccounts c5_ ON a0_.CmsAccountId = c5_.CmsAccountId WHERE (((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.ArticleId = ?) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 1

SELECT k0_.KeywordId AS KeywordId_0, k0_.Keyword AS Keyword_1, k0_.RewriteUrl AS RewriteUrl_2, k0_.Category AS Category_3, k0_.CommentCount AS CommentCount_4, k0_.ParentId AS ParentId_5 FROM Keywords k0_ INNER JOIN keyword_combinations k1_ ON (k1_.keywordID = k0_.KeywordId) WHERE k1_.nieuwsID = ?

SELECT Articles.ArticleId AS ArticleId, Articles.RewriteUrl AS RewriteUrl, Articles.ArticleType as ArticleType, Articles.Category as Category, Articles.cntnlang AS cntnlang, RacingSeries.RewriteUrl AS RacingSeriesRewriteUrl FROM Articles INNER JOIN RacingSeries ON Articles.RacingSerieId = RacingSeries.RacingSerieId WHERE Articles.cntnlang = :siteLang AND Articles.SiteId = :siteId AND Articles.Activated = 1 AND Articles.PublishDate < :publishDate AND Articles.ArticleType IN (:param0, :param1, :param2) AND Articles.ArticleId > :articleId ORDER BY Articles.ArticleId ASC LIMIT 1

SELECT Articles.ArticleId AS ArticleId, Articles.RewriteUrl AS RewriteUrl, Articles.ArticleType as ArticleType, Articles.Category as Category, Articles.cntnlang AS cntnlang, RacingSeries.RewriteUrl AS RacingSeriesRewriteUrl FROM Articles INNER JOIN RacingSeries ON Articles.RacingSerieId = RacingSeries.RacingSerieId WHERE Articles.cntnlang = :siteLang AND Articles.SiteId = :siteId AND Articles.Activated = 1 AND Articles.PublishDate < :publishDate AND Articles.ArticleType IN (:param0, :param1, :param2) AND Articles.ArticleId < :articleId ORDER BY Articles.ArticleId DESC LIMIT 1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.UploadDate AS UploadDate_2, p0_.title AS title_3, p0_.fotoDatum AS fotoDatum_4, p0_.FileSize AS FileSize_5, p0_.Height AS Height_6, p0_.Width AS Width_7, p0_.ImageFormat AS ImageFormat_8, p0_.album_id AS album_id_9 FROM photos p0_ WHERE p0_.name = ?

SELECT p0_.PersonId AS PersonId_0, p0_.LastName AS LastName_1, p0_.FirstName AS FirstName_2, p0_.Birthdate AS Birthdate_3, p0_.DateOfDeath AS DateOfDeath_4, p0_.Residence AS Residence_5, p0_.BirthCity AS BirthCity_6, p0_.ProfilePhoto AS ProfilePhoto_7, p0_.Height AS Height_8, p0_.Website AS Website_9, p0_.Weight AS Weight_10, p0_.InternalNotes AS InternalNotes_11, p0_.InHeaderList AS InHeaderList_12, p0_.InFooterList AS InFooterList_13, k1_.keyword_combinationID AS keyword_combinationID_14, p2_.PersonCareerId AS PersonCareerId_15, p2_.StartDate AS StartDate_16, p2_.EndDate AS EndDate_17, p2_.ProfilePhoto AS ProfilePhoto_18, p2_.StartNumber AS StartNumber_19, d3_.iso AS iso_20, d3_.iso3 AS iso3_21, d3_.numcode AS numcode_22, o4_.OrganisationHistoryId AS OrganisationHistoryId_23, o4_.Name AS Name_24, o4_.StartDate AS StartDate_25, o4_.EndDate AS EndDate_26, o4_.Photo AS Photo_27, o4_.SmallLogo AS SmallLogo_28, o4_.City AS City_29, o4_.Website AS Website_30, p5_.PersonRoleId AS PersonRoleId_31, p6_.PersonRolesTranslationId AS PersonRolesTranslationId_32, p6_.LanguageCode AS LanguageCode_33, p6_.Name AS Name_34, r7_.RacingSerieId AS RacingSerieId_35, r7_.RewriteUrl AS RewriteUrl_36, r7_.IsDefault AS IsDefault_37, r8_.RacingSeriesTranslationId AS RacingSeriesTranslationId_38, r8_.LanguageCode AS LanguageCode_39, r8_.ShortName AS ShortName_40, r8_.LongName AS LongName_41, p0_.Nationality AS Nationality_42, p0_.KeywordId AS KeywordId_43, p0_.PrimaryCareerId AS PrimaryCareerId_44, p0_.SiteId AS SiteId_45, k1_.keywordID AS keywordID_46, k1_.nieuwsID AS nieuwsID_47, p2_.PersonRoleId AS PersonRoleId_48, p2_.OrganisationHistoryId AS OrganisationHistoryId_49, p2_.PersonId AS PersonId_50, o4_.OrganisationRoleId AS OrganisationRoleId_51, o4_.PrimaryOrganisationId AS PrimaryOrganisationId_52, o4_.RacingSerieId AS RacingSerieId_53, p6_.PersonRoleId AS PersonRoleId_54, r7_.SiteId AS SiteId_55, r7_.CountryIso AS CountryIso_56, r8_.RacingSerieId AS RacingSerieId_57 FROM Persons p0_ INNER JOIN keyword_combinations k1_ ON (k1_.keywordID = p0_.KeywordId) LEFT JOIN PersonCareer p2_ ON p0_.PrimaryCareerId = p2_.PersonCareerId INNER JOIN db_countries d3_ ON p0_.Nationality = d3_.iso INNER JOIN db_countries_trnsl d9_ ON d3_.iso = d9_.ISO LEFT JOIN OrganisationHistory o4_ ON p2_.OrganisationHistoryId = o4_.OrganisationHistoryId LEFT JOIN PersonRoles p5_ ON p2_.PersonRoleId = p5_.PersonRoleId LEFT JOIN PersonRolesTranslations p6_ ON p5_.PersonRoleId = p6_.PersonRoleId AND (p6_.LanguageCode = 'nl') LEFT JOIN RacingSeries r7_ ON o4_.RacingSerieId = r7_.RacingSerieId AND (r7_.SiteId IN ('1')) LEFT JOIN RacingSeriesTranslations r8_ ON r7_.RacingSerieId = r8_.RacingSerieId AND (r8_.LanguageCode = 'nl') WHERE k1_.nieuwsID = ? AND d9_.cntnlang = ?

SELECT o0_.OrganisationId AS OrganisationId_0, o0_.Name AS Name_1, o0_.FoundingDate AS FoundingDate_2, o0_.Photo AS Photo_3, k1_.KeywordId AS KeywordId_4, k1_.Keyword AS Keyword_5, k1_.RewriteUrl AS RewriteUrl_6, k1_.Category AS Category_7, k1_.CommentCount AS CommentCount_8, o2_.OrganisationHistoryId AS OrganisationHistoryId_9, o2_.Name AS Name_10, o2_.StartDate AS StartDate_11, o2_.EndDate AS EndDate_12, o2_.Photo AS Photo_13, o2_.SmallLogo AS SmallLogo_14, o2_.City AS City_15, o2_.Website AS Website_16, d3_.iso AS iso_17, d3_.iso3 AS iso3_18, d3_.numcode AS numcode_19, d4_.cntnlang AS cntnlang_20, d4_.printable_name AS printable_name_21, o0_.KeywordId AS KeywordId_22, o0_.Nationality AS Nationality_23, k1_.ParentId AS ParentId_24, o2_.OrganisationRoleId AS OrganisationRoleId_25, o2_.PrimaryOrganisationId AS PrimaryOrganisationId_26, o2_.RacingSerieId AS RacingSerieId_27, d4_.ISO AS ISO_28 FROM Organisations o0_ INNER JOIN keyword_combinations k5_ ON (k5_.keywordID = o0_.KeywordId) INNER JOIN Keywords k1_ ON o0_.KeywordId = k1_.KeywordId INNER JOIN OrganisationOrganisationHistory o6_ ON o0_.OrganisationId = o6_.OrganisationId INNER JOIN OrganisationHistory o2_ ON o2_.OrganisationHistoryId = o6_.OrganisationHistoryId INNER JOIN db_countries d3_ ON o0_.Nationality = d3_.iso INNER JOIN db_countries_trnsl d4_ ON d3_.iso = d4_.ISO WHERE k5_.nieuwsID = ? AND d4_.cntnlang = ? ORDER BY o2_.EndDate DESC

module:News\Result (0Q - total module time: 0.00026608s)

module:News\Trending (0Q - total module time: 0.00018001s)

module:News\Reply (2Q - total module time: 0.14891911s)

SELECT r.`CommentId` AS `CommentId`, SUM(`Vote`) + 0 AS CommentScore FROM `Comments` AS r JOIN `CommentVotes` cv ON cv.`CommentId` = r.`CommentId` WHERE `ArticleId` = :articleId GROUP BY r.`CommentId`

SELECT c0_.CommentId AS CommentId_0, c1_.Vote AS Vote_1 FROM Comments c0_ INNER JOIN CommentVotes c1_ ON (c1_.CommentId = c0_.CommentId) WHERE c0_.ArticleId = ? AND c1_.VoteIp = ?

module:RelatedNews (5Q - total module time: 0.00366402s)

SELECT k0_.KeywordId AS KeywordId_0, k0_.Keyword AS Keyword_1, k0_.RewriteUrl AS RewriteUrl_2, k0_.Category AS Category_3, k0_.CommentCount AS CommentCount_4, k0_.ParentId AS ParentId_5 FROM Keywords k0_ INNER JOIN keyword_combinations k1_ ON (k1_.keywordID = k0_.KeywordId) WHERE k1_.nieuwsID = ?

SELECT k0_.KeywordId AS KeywordId_0, k0_.Keyword AS Keyword_1, k0_.RewriteUrl AS RewriteUrl_2, k0_.Category AS Category_3, k0_.CommentCount AS CommentCount_4, k0_.ParentId AS ParentId_5 FROM Keywords k0_ WHERE k0_.KeywordId IN (?)

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 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.RewriteUrl = ? AND t0.SiteId IN (?) AND ((t0.SiteId IN ('1'))) LIMIT 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 = 'nl') INNER JOIN keyword_combinations k3_ ON (k3_.nieuwsID = a0_.ArticleId) WHERE ((((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.RacingSerieId = ?) AND k3_.keywordID IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 15

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