CAN BIAL, Mallorca

End Date: 2002
Design: Marc-Ludolf von Schmarsow 

Compile Time: 0.44749s (0.01s/2% querytime, 16 queries)

Memory Usage: 28.66 MB (30050176 Bytes)




Query #1 (0.00022s):

SET NAMES 'utf8'



Query #2 (0.001s, 1 result/s):

SELECT

Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'

FROM

nodes Node

LEFT JOIN node_texts NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id 

LEFT JOIN node_texts NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id 

LEFT JOIN users User ON Node.user_id = User.id 

WHERE 

Node.status & 1  AND Node.id = 43



Query #3 (0.00101s, 13 result/s):

SELECT

ImageModel.id as 'ImageModel.id', ImageModel.node_id as 'ImageModel.node_id', ImageModel.user_id as 'ImageModel.user_id', ImageModel.use_model as 'ImageModel.use_model', ImageModel.flags as 'ImageModel.flags', ImageModel.filename as 'ImageModel.filename', ImageModel.name as 'ImageModel.name', ImageModel.text as 'ImageModel.text', ImageModel.url as 'ImageModel.url', ImageModel.position as 'ImageModel.position', ImageModel.created as 'ImageModel.created', ImageModel.updated as 'ImageModel.updated', TextDe.id as 'TextDe.id', TextDe.media_id as 'TextDe.media_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.name as 'TextDe.name', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', TextEn.id as 'TextEn.id', TextEn.media_id as 'TextEn.media_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.name as 'TextEn.name', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.updated', Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'

FROM

medias ImageModel

LEFT JOIN media_texts TextDe ON TextDe.language_id = 1 AND ImageModel.id = TextDe.media_id 

LEFT JOIN media_texts TextEn ON TextEn.language_id = 2 AND ImageModel.id = TextEn.media_id 

LEFT JOIN nodes Node ON ImageModel.node_id = Node.id 

LEFT JOIN users User ON ImageModel.user_id = User.id 

WHERE 

ImageModel.node_id = 43 

ORDER BY ImageModel.position ASC



Query #4 (0.00055s, 1 result/s):

SELECT

Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'

FROM

nodes Node

LEFT JOIN node_texts NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id 

LEFT JOIN node_texts NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id 

LEFT JOIN users User ON Node.user_id = User.id 

WHERE 

Node.status & 1  AND Node.id = 10



Query #5 (0.00045s):

SELECT

ImageModel.id as 'ImageModel.id', ImageModel.node_id as 'ImageModel.node_id', ImageModel.user_id as 'ImageModel.user_id', ImageModel.use_model as 'ImageModel.use_model', ImageModel.flags as 'ImageModel.flags', ImageModel.filename as 'ImageModel.filename', ImageModel.name as 'ImageModel.name', ImageModel.text as 'ImageModel.text', ImageModel.url as 'ImageModel.url', ImageModel.position as 'ImageModel.position', ImageModel.created as 'ImageModel.created', ImageModel.updated as 'ImageModel.updated', TextDe.id as 'TextDe.id', TextDe.media_id as 'TextDe.media_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.name as 'TextDe.name', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', TextEn.id as 'TextEn.id', TextEn.media_id as 'TextEn.media_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.name as 'TextEn.name', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.updated', Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'

FROM

medias ImageModel

LEFT JOIN media_texts TextDe ON TextDe.language_id = 1 AND ImageModel.id = TextDe.media_id 

LEFT JOIN media_texts TextEn ON TextEn.language_id = 2 AND ImageModel.id = TextEn.media_id 

LEFT JOIN nodes Node ON ImageModel.node_id = Node.id 

LEFT JOIN users User ON ImageModel.user_id = User.id 

WHERE 

ImageModel.node_id = 10 

ORDER BY ImageModel.position ASC



Query #6 (0.00062s, 1 result/s):

SELECT

Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'

FROM

nodes Node

LEFT JOIN node_texts NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id 

LEFT JOIN node_texts NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id 

LEFT JOIN users User ON Node.user_id = User.id 

WHERE 

Node.status & 1  AND Node.id = 7



Query #7 (0.00046s):

SELECT

ImageModel.id as 'ImageModel.id', ImageModel.node_id as 'ImageModel.node_id', ImageModel.user_id as 'ImageModel.user_id', ImageModel.use_model as 'ImageModel.use_model', ImageModel.flags as 'ImageModel.flags', ImageModel.filename as 'ImageModel.filename', ImageModel.name as 'ImageModel.name', ImageModel.text as 'ImageModel.text', ImageModel.url as 'ImageModel.url', ImageModel.position as 'ImageModel.position', ImageModel.created as 'ImageModel.created', ImageModel.updated as 'ImageModel.updated', TextDe.id as 'TextDe.id', TextDe.media_id as 'TextDe.media_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.name as 'TextDe.name', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', TextEn.id as 'TextEn.id', TextEn.media_id as 'TextEn.media_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.name as 'TextEn.name', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.updated', Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'

FROM

medias ImageModel

LEFT JOIN media_texts TextDe ON TextDe.language_id = 1 AND ImageModel.id = TextDe.media_id 

LEFT JOIN media_texts TextEn ON TextEn.language_id = 2 AND ImageModel.id = TextEn.media_id 

LEFT JOIN nodes Node ON ImageModel.node_id = Node.id 

LEFT JOIN users User ON ImageModel.user_id = User.id 

WHERE 

ImageModel.node_id = 7 

ORDER BY ImageModel.position ASC



Query #8 (0.00072s, 1 result/s):

SELECT

Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'

FROM

nodes Node

LEFT JOIN node_texts NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id 

LEFT JOIN node_texts NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id 

LEFT JOIN users User ON Node.user_id = User.id 

WHERE 

Node.status & 1  AND Node.name = 'Projects'



Query #9 (0.00042s):

SELECT

ImageModel.id as 'ImageModel.id', ImageModel.node_id as 'ImageModel.node_id', ImageModel.user_id as 'ImageModel.user_id', ImageModel.use_model as 'ImageModel.use_model', ImageModel.flags as 'ImageModel.flags', ImageModel.filename as 'ImageModel.filename', ImageModel.name as 'ImageModel.name', ImageModel.text as 'ImageModel.text', ImageModel.url as 'ImageModel.url', ImageModel.position as 'ImageModel.position', ImageModel.created as 'ImageModel.created', ImageModel.updated as 'ImageModel.updated', TextDe.id as 'TextDe.id', TextDe.media_id as 'TextDe.media_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.name as 'TextDe.name', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', TextEn.id as 'TextEn.id', TextEn.media_id as 'TextEn.media_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.name as 'TextEn.name', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.updated', Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'

FROM

medias ImageModel

LEFT JOIN media_texts TextDe ON TextDe.language_id = 1 AND ImageModel.id = TextDe.media_id 

LEFT JOIN media_texts TextEn ON TextEn.language_id = 2 AND ImageModel.id = TextEn.media_id 

LEFT JOIN nodes Node ON ImageModel.node_id = Node.id 

LEFT JOIN users User ON ImageModel.user_id = User.id 

WHERE 

ImageModel.node_id = 7 

ORDER BY ImageModel.position ASC



Query #10 (0.00043s, 1 result/s):

SELECT

Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'

FROM

nodes Node

LEFT JOIN node_texts NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id 

LEFT JOIN node_texts NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id 

LEFT JOIN users User ON Node.user_id = User.id 

WHERE 

Node.status & 1  AND Node.name = 'Projects'



Query #11 (0.00051s):

SELECT

ImageModel.id as 'ImageModel.id', ImageModel.node_id as 'ImageModel.node_id', ImageModel.user_id as 'ImageModel.user_id', ImageModel.use_model as 'ImageModel.use_model', ImageModel.flags as 'ImageModel.flags', ImageModel.filename as 'ImageModel.filename', ImageModel.name as 'ImageModel.name', ImageModel.text as 'ImageModel.text', ImageModel.url as 'ImageModel.url', ImageModel.position as 'ImageModel.position', ImageModel.created as 'ImageModel.created', ImageModel.updated as 'ImageModel.updated', TextDe.id as 'TextDe.id', TextDe.media_id as 'TextDe.media_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.name as 'TextDe.name', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', TextEn.id as 'TextEn.id', TextEn.media_id as 'TextEn.media_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.name as 'TextEn.name', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.updated', Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'

FROM

medias ImageModel

LEFT JOIN media_texts TextDe ON TextDe.language_id = 1 AND ImageModel.id = TextDe.media_id 

LEFT JOIN media_texts TextEn ON TextEn.language_id = 2 AND ImageModel.id = TextEn.media_id 

LEFT JOIN nodes Node ON ImageModel.node_id = Node.id 

LEFT JOIN users User ON ImageModel.user_id = User.id 

WHERE 

ImageModel.node_id = 7 

ORDER BY ImageModel.position ASC



Query #12 (0.00068s, 25 result/s):

SELECT

/* Node->NestedSetBehavior->depth(depth: 1, depthModel: 0) */

Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', COUNT(p.id)-1 AS level

FROM

(nodes Node, nodes p)

LEFT JOIN node_texts NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id 

LEFT JOIN node_texts NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id 

LEFT JOIN users User ON Node.user_id = User.id 

WHERE 

Node.status & 1  AND Node.lft BETWEEN p.lft AND p.rgt  AND Node.lft > 11  AND Node.rgt < 62  

GROUP BY Node.lft

ORDER BY Node.lft



Query #13 (0.00048s, 1 result/s):

SELECT

Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'

FROM

nodes Node

LEFT JOIN node_texts NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id 

LEFT JOIN node_texts NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id 

LEFT JOIN users User ON Node.user_id = User.id 

WHERE 

Node.status & 1  AND Node.name = 'mainMenu'



Query #14 (0.00044s):

SELECT

ImageModel.id as 'ImageModel.id', ImageModel.node_id as 'ImageModel.node_id', ImageModel.user_id as 'ImageModel.user_id', ImageModel.use_model as 'ImageModel.use_model', ImageModel.flags as 'ImageModel.flags', ImageModel.filename as 'ImageModel.filename', ImageModel.name as 'ImageModel.name', ImageModel.text as 'ImageModel.text', ImageModel.url as 'ImageModel.url', ImageModel.position as 'ImageModel.position', ImageModel.created as 'ImageModel.created', ImageModel.updated as 'ImageModel.updated', TextDe.id as 'TextDe.id', TextDe.media_id as 'TextDe.media_id', TextDe.user_id as 'TextDe.user_id', TextDe.language_id as 'TextDe.language_id', TextDe.revision as 'TextDe.revision', TextDe.name as 'TextDe.name', TextDe.text as 'TextDe.text', TextDe.created as 'TextDe.created', TextDe.updated as 'TextDe.updated', TextEn.id as 'TextEn.id', TextEn.media_id as 'TextEn.media_id', TextEn.user_id as 'TextEn.user_id', TextEn.language_id as 'TextEn.language_id', TextEn.revision as 'TextEn.revision', TextEn.name as 'TextEn.name', TextEn.text as 'TextEn.text', TextEn.created as 'TextEn.created', TextEn.updated as 'TextEn.updated', Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count'

FROM

medias ImageModel

LEFT JOIN media_texts TextDe ON TextDe.language_id = 1 AND ImageModel.id = TextDe.media_id 

LEFT JOIN media_texts TextEn ON TextEn.language_id = 2 AND ImageModel.id = TextEn.media_id 

LEFT JOIN nodes Node ON ImageModel.node_id = Node.id 

LEFT JOIN users User ON ImageModel.user_id = User.id 

WHERE 

ImageModel.node_id = 3 

ORDER BY ImageModel.position ASC



Query #15 (0.00121s, 77 result/s):

SELECT

/* Node->NestedSetBehavior->depth(depth: 1, depthModel: 0) */

Node.id as 'Node.id', Node.parent_id as 'Node.parent_id', Node.lft as 'Node.lft', Node.rgt as 'Node.rgt', Node.flags as 'Node.flags', Node.status as 'Node.status', Node.user_id as 'Node.user_id', Node.name as 'Node.name', Node.template as 'Node.template', Node.published as 'Node.published', Node.positionStart as 'Node.positionStart', Node.created as 'Node.created', Node.updated as 'Node.updated', NodeTextDe.id as 'NodeTextDe.id', NodeTextDe.node_id as 'NodeTextDe.node_id', NodeTextDe.language_id as 'NodeTextDe.language_id', NodeTextDe.revision as 'NodeTextDe.revision', NodeTextDe.user_id as 'NodeTextDe.user_id', NodeTextDe.uri as 'NodeTextDe.uri', NodeTextDe.headline as 'NodeTextDe.headline', NodeTextDe.pagetitle as 'NodeTextDe.pagetitle', NodeTextDe.subline as 'NodeTextDe.subline', NodeTextDe.text as 'NodeTextDe.text', NodeTextDe.excerpt as 'NodeTextDe.excerpt', NodeTextDe.keywords as 'NodeTextDe.keywords', NodeTextDe.created as 'NodeTextDe.created', NodeTextDe.updated as 'NodeTextDe.updated', NodeTextEn.id as 'NodeTextEn.id', NodeTextEn.node_id as 'NodeTextEn.node_id', NodeTextEn.language_id as 'NodeTextEn.language_id', NodeTextEn.revision as 'NodeTextEn.revision', NodeTextEn.user_id as 'NodeTextEn.user_id', NodeTextEn.uri as 'NodeTextEn.uri', NodeTextEn.headline as 'NodeTextEn.headline', NodeTextEn.pagetitle as 'NodeTextEn.pagetitle', NodeTextEn.subline as 'NodeTextEn.subline', NodeTextEn.text as 'NodeTextEn.text', NodeTextEn.excerpt as 'NodeTextEn.excerpt', NodeTextEn.keywords as 'NodeTextEn.keywords', NodeTextEn.created as 'NodeTextEn.created', NodeTextEn.updated as 'NodeTextEn.updated', User.id as 'User.id', User.flags as 'User.flags', User.name as 'User.name', User.email as 'User.email', User.password as 'User.password', User.ip as 'User.ip', User.permanent_key as 'User.permanent_key', User.created as 'User.created', User.updated as 'User.updated', User.lastlogin as 'User.lastlogin', User.login_failed_start as 'User.login_failed_start', User.login_failed_count as 'User.login_failed_count', COUNT(p.id)-1 AS level

FROM

(nodes Node, nodes p)

LEFT JOIN node_texts NodeTextDe ON NodeTextDe.language_id = 1 AND Node.id = NodeTextDe.node_id 

LEFT JOIN node_texts NodeTextEn ON NodeTextEn.language_id = 2 AND Node.id = NodeTextEn.node_id 

LEFT JOIN users User ON Node.user_id = User.id 

WHERE 

Node.status & 1  AND Node.lft BETWEEN p.lft AND p.rgt  AND Node.lft > 10  AND Node.rgt < 167  

GROUP BY Node.lft

ORDER BY Node.lft



Query #16 (0.00037s, 2 result/s):

SELECT

Language.id as 'Language.id', Language.code as 'Language.code', Language.flags as 'Language.flags', Language.name as 'Language.name'

FROM

languages Language