LUMISOL GmbH

CITRIN

Fuß:
mundgeblasenes Glas, rund
handgeschliffene Oberfläche.
Farbe: Gold

Lampenschirm:
handgefertigt, rund, Ø 200mm;
Material: Bastgeflecht fein;
Farbe: Hellblau oder auf Anfrage

Metallteile:
Eisen oxidiert

Verkabelung:
Textilkabel, gedreht, mit Stecker und Schalter, schwarz,
1x E14, max. 40W, 230Volt

Compile Time: 0.611879s (0.011s/2% querytime, 16 queries)
Memory Usage: 34.12 MB (35781040 Bytes)

Query #1 (0.00023s):
SET NAMES 'utf8'

Query #2 (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.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 NodeTextDe.uri = 'citrin'

Query #3 (0.00056s, 1 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 = 122
ORDER BY ImageModel.position ASC

Query #4 (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.id = 69

Query #5 (0.00057s, 10 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 = 69
ORDER BY ImageModel.position ASC

Query #6 (0.00053s, 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 = 6

Query #7 (0.0005s, 6 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 = 6
ORDER BY ImageModel.position ASC

Query #8 (0.00049s, 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 = 'Products'

Query #9 (0.00051s, 6 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 = 6
ORDER BY ImageModel.position ASC

Query #10 (0.00054s, 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 = 'Products'

Query #11 (0.0005s, 6 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 = 6
ORDER BY ImageModel.position ASC

Query #12 (0.00117s, 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.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 > 65 AND Node.rgt < 158
GROUP BY Node.lft
ORDER BY Node.lft

Query #13 (0.00049s, 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.00047s):
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.002s, 78 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 < 169
GROUP BY Node.lft
ORDER BY Node.lft

Query #16 (0.00032s, 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

LUMISOL GmbH - CITRIN

CITRIN