Queries
SELECT `key`, `value` FROM custom_variables WHERE `language` = ? AND `type` = ? AND `serialized` = ? Parameters: [ cs, global, 0 ] |
|---|
SELECT `key`, `value` FROM custom_variables WHERE `language` = ? AND `type` = ? AND `serialized` = ? Parameters: [ cs, global, 1 ] |
SELECT p.revision_id FROM pages AS p WHERE p.id = ? AND p.status = ? AND p.language = ? LIMIT 1 Parameters: [ 1, active, cs ] |
SELECT p.id, p.parent_id, p.revision_id, p.template_id, p.title, p.navigation_title, p.navigation_title_overwrite, p.data, p.hidden, m.title AS meta_title, m.title_overwrite AS meta_title_overwrite, m.keywords AS meta_keywords, m.keywords_overwrite AS meta_keywords_overwrite, m.description AS meta_description, m.description_overwrite AS meta_description_overwrite, m.custom AS meta_custom, m.url, m.url_overwrite, m.data AS meta_data, m.seo_follow AS meta_seo_follow, m.seo_index AS meta_seo_index, t.path AS template_path, t.data AS template_data FROM pages AS p INNER JOIN meta AS m ON p.meta_id = m.id INNER JOIN themes_templates AS t ON p.template_id = t.id WHERE p.revision_id = ? AND p.language = ? LIMIT 1 Parameters: [ 12, cs ] |
SELECT pe.id AS extra_id, pb.html, pb.position, pb.extra_type AS content_type, pe.module AS extra_module, pe.type AS extra_type, pe.action AS extra_action, pe.data AS extra_data FROM pages_blocks AS pb INNER JOIN pages AS p ON p.revision_id = pb.revision_id LEFT OUTER JOIN modules_extras AS pe ON pb.extra_id = pe.id AND pe.hidden = ? WHERE pb.revision_id = ? AND p.status = ? AND pb.visible = ? ORDER BY pb.position, pb.sequence Parameters: [ , 12, active, 1 ] |
SELECT `key`, `value` FROM custom_variables WHERE `language` = ? AND `type` = ? AND `serialized` = ? Parameters: [ cs, content, 0 ] |
SELECT m.name FROM modules AS m Parameters: [ ] |