LUMISOL GmbH - DALLMAYR - Café, Munich

• Projects
  • Retail
  • Residential
  • Corporate
  • Hospitality/Spa
• Products
• About us
• Contact

DALLMAYR - Café, Munich

Client: Alois Dallmayr KG
End Date: 2006
Partner: Albert Weinzierl
Project Manager: Marc-Ludolf von Schmarsow
Team: Oliver Damberger
Photo: Stefan Randlkofer

• Prev Image 
• Next Image 

• 
• 
• 

LUMISOL GmbH

–

Barer Straße 3

–

D-80333 München

–

Tel: +49 (0) 89 545 04 14 0

–

contact@lumisol.com

• De
• En

• Imprint –
• Site by NoMoreSleep™

Compile Time: 0.713848s (0.186s/26% querytime, 12 queries)

Memory Usage: 11.72 MB (12290308 Bytes)



Query #1 (0.00026s):

SET NAMES 'utf8'



Query #2 (0.00339s, 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.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 NodeTextEn.uri = 'dallmayr-cafe-munich'



Query #3 (0.00203s, 3 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.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 = 41 

ORDER BY ImageModel.position ASC



Query #4 (0.0021s, 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.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 #5 (0.00184s):

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.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 #6 (0.05899s, 24 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.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 < 60  

GROUP BY Node.lft

ORDER BY Node.lft



Query #7 (0.00175s, 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.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 #8 (0.00178s):

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.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 #9 (0.10922s, 45 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.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 < 103  

GROUP BY Node.lft

ORDER BY Node.lft



Query #10 (0.00129s, 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



Query #11 (0.00182s, 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.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 = 12



Query #12 (0.00121s):

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

ORDER BY ImageModel.position ASC