Het volledige schema voor de Gamma Racing Days 2017

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

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

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

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

controller::nieuws/f1/229862/het-volledige-schema-voor-de-gamma-racing-days-2017 (3Q - total module time: 0.14337301s)

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 c0_.CommentId AS CommentId_0, c0_.Date AS Date_1, c0_.Content AS Content_2, c0_.BlockReason AS BlockReason_3, c0_.cntnlang AS cntnlang_4, c0_.PosterIp AS PosterIp_5, u1_.UserId AS UserId_6, u1_.RegistrationDate AS RegistrationDate_7, u1_.Username AS Username_8, u1_.RewriteUrl AS RewriteUrl_9, u1_.EmailAddress AS EmailAddress_10, u1_.FirstName AS FirstName_11, u1_.LastName AS LastName_12, u1_.Birthdate AS Birthdate_13, u1_.Gender AS Gender_14, u1_.Website AS Website_15, u1_.Twitter AS Twitter_16, u1_.CurrentCar AS CurrentCar_17, u1_.DreamCar AS DreamCar_18, u1_.Facebook AS Facebook_19, u1_.Occupation AS Occupation_20, u1_.Interests AS Interests_21, u1_.Activated AS Activated_22, u1_.Banned AS Banned_23, u1_.Subscribed AS Subscribed_24, u1_.RegistrationIp AS RegistrationIp_25, u1_.LastUpdated AS LastUpdated_26, u1_.AllowCommentModeration AS AllowCommentModeration_27, u1_.CommentsCount AS CommentsCount_28, u1_.NotificationCount AS NotificationCount_29, u1_.TotalCommentVoteSum AS TotalCommentVoteSum_30, u1_.Residence AS Residence_31, u1_.Icon AS Icon_32, u1_.ModerateAllComments AS ModerateAllComments_33, u1_.PremiumUser AS PremiumUser_34, u1_.CrewNotes AS CrewNotes_35, u1_.PwdHash AS PwdHash_36, u1_.ActivationId AS ActivationId_37, u1_.RetrievalId AS RetrievalId_38, u1_.ProfileLastUpdated AS ProfileLastUpdated_39, u1_.LastOnline AS LastOnline_40, d2_.iso AS iso_41, d2_.iso3 AS iso3_42, d2_.numcode AS numcode_43, c0_.SiteId AS SiteId_44, c0_.ArticleId AS ArticleId_45, c0_.ParentId AS ParentId_46, c0_.UserId AS UserId_47, u1_.RegisteringSiteId AS RegisteringSiteId_48, u1_.FavouriteDriverId AS FavouriteDriverId_49, u1_.FavouriteTeamId AS FavouriteTeamId_50, u1_.Country AS Country_51 FROM Comments c0_ INNER JOIN Users u1_ ON c0_.UserId = u1_.UserId INNER JOIN db_countries d2_ ON u1_.Country = d2_.iso WHERE c0_.ArticleId = ? AND c0_.BlockReason = ? ORDER BY c0_.Date ASC LIMIT 100

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

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

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

SELECT c0_.CommentId AS CommentId_0, c0_.Date AS Date_1, c0_.Content AS Content_2, c0_.BlockReason AS BlockReason_3, c0_.cntnlang AS cntnlang_4, c0_.PosterIp AS PosterIp_5, u1_.UserId AS UserId_6, u1_.RegistrationDate AS RegistrationDate_7, u1_.Username AS Username_8, u1_.RewriteUrl AS RewriteUrl_9, u1_.EmailAddress AS EmailAddress_10, u1_.FirstName AS FirstName_11, u1_.LastName AS LastName_12, u1_.Birthdate AS Birthdate_13, u1_.Gender AS Gender_14, u1_.Website AS Website_15, u1_.Twitter AS Twitter_16, u1_.CurrentCar AS CurrentCar_17, u1_.DreamCar AS DreamCar_18, u1_.Facebook AS Facebook_19, u1_.Occupation AS Occupation_20, u1_.Interests AS Interests_21, u1_.Activated AS Activated_22, u1_.Banned AS Banned_23, u1_.Subscribed AS Subscribed_24, u1_.RegistrationIp AS RegistrationIp_25, u1_.LastUpdated AS LastUpdated_26, u1_.AllowCommentModeration AS AllowCommentModeration_27, u1_.CommentsCount AS CommentsCount_28, u1_.NotificationCount AS NotificationCount_29, u1_.TotalCommentVoteSum AS TotalCommentVoteSum_30, u1_.Residence AS Residence_31, u1_.Icon AS Icon_32, u1_.ModerateAllComments AS ModerateAllComments_33, u1_.PremiumUser AS PremiumUser_34, u1_.CrewNotes AS CrewNotes_35, u1_.PwdHash AS PwdHash_36, u1_.ActivationId AS ActivationId_37, u1_.RetrievalId AS RetrievalId_38, u1_.ProfileLastUpdated AS ProfileLastUpdated_39, u1_.LastOnline AS LastOnline_40, d2_.iso AS iso_41, d2_.iso3 AS iso3_42, d2_.numcode AS numcode_43, c0_.SiteId AS SiteId_44, c0_.ArticleId AS ArticleId_45, c0_.ParentId AS ParentId_46, c0_.UserId AS UserId_47, u1_.RegisteringSiteId AS RegisteringSiteId_48, u1_.FavouriteDriverId AS FavouriteDriverId_49, u1_.FavouriteTeamId AS FavouriteTeamId_50, u1_.Country AS Country_51 FROM Comments c0_ INNER JOIN Users u1_ ON c0_.UserId = u1_.UserId INNER JOIN db_countries d2_ ON u1_.Country = d2_.iso WHERE c0_.ArticleId = ? AND c0_.BlockReason = ? ORDER BY c0_.Date ASC

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 (9Q - total module time: 0.02161908s)

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

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.00030398s)