An error occurred in /home/whiskyma/public_html/workspace/data-sources/data.whisky_by_handle.php
around line 117
$xml = $result;
}
$dom = new DOMDocument();
$dom->strictErrorChecking = false;
$dom->loadXML($xml);
if (!empty($this->dsParamParametrisator['xslt'])) {
$XSLTfilename = UTILITIES . '/'. preg_replace(array('%/+%', '%(^|/)../%'), '/', $this->dsParamParametrisator['xslt']);
if (file_exists($XSLTfilename)) {
[:0] GenericErrorHandler::handler();
[/home/whiskyma/public_html/workspace/data-sources/data.whisky_by_handle.php:117] DOMDocument->loadXML();
[/home/whiskyma/public_html/symphony/lib/toolkit/class.frontendpage.php:828] datasourcewhisky_by_handle->grab();
[/home/whiskyma/public_html/symphony/lib/toolkit/class.frontendpage.php:413] FrontendPage->processDatasources();
[/home/whiskyma/public_html/symphony/lib/toolkit/class.frontendpage.php:202] FrontendPage->__buildPage();
[/home/whiskyma/public_html/symphony/lib/core/class.frontend.php:111] FrontendPage->generate();
[/home/whiskyma/public_html/index.php:25] Frontend->display();
SET character_set_connection = 'utf8';
[0.0001]SET CHARACTER SET 'utf8';
[0.0001]SELECT SQL_NO_CACHE `session_data` FROM `sym_sessions` WHERE `session` = 'tjrotnn2g6nbce37t1m3msi683' LIMIT 1;
[0.0002]DELETE FROM `sym_sessions` WHERE `session_expires` <= '1724541000';
[0.0002]SELECT SQL_NO_CACHE `name` FROM `sym_extensions` WHERE `status` = 'enabled';
[0.0003]SELECT SQL_NO_CACHE t1.name, t2.page, t2.delegate, t2.callback
FROM `sym_extensions` as t1 INNER JOIN `sym_extensions_delegates` as t2 ON t1.id = t2.extension_id
WHERE t1.status = 'enabled';
[0.0004]SELECT SQL_NO_CACHE * FROM `sym_pages` WHERE `path` = 'whiskey' AND `handle` = 'green-spot-leoville-barton-bordeaux-finish-irish-whiskey' LIMIT 1;
[0.0003]SELECT SQL_NO_CACHE * FROM `sym_pages` WHERE `path` IS NULL AND `handle` = 'whiskey' LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE `type` FROM `sym_pages_types` WHERE `page_id` = '121';
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_pages` WHERE `path` = 'whiskey' AND `handle` = 'green-spot-leoville-barton-bordeaux-finish-irish-whiskey' LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_pages` WHERE `path` IS NULL AND `handle` = 'whiskey' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE `type` FROM `sym_pages_types` WHERE `page_id` = '121';
[0.0001]SELECT SQL_NO_CACHE url FROM sym_pingdom_url_check WHERE status=1 ORDER BY sortorder ASC LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE `s`.*
FROM `sym_sections` AS `s`
WHERE `s`.`id` = '20';
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '144' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_uniqueinput` WHERE `field_id` = '144' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE `e`.id,
`e`.section_id, e.`author_id`,
UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`
FROM `sym_entries` AS `e`
LEFT JOIN `sym_entries_data_144` AS `t144` ON (`e`.`id` = `t144`.entry_id)
WHERE 1
AND `e`.`section_id` = '20'
AND (`t144`.value IN ('green-spot-leoville-barton-bordeaux-finish-irish-whiskey') OR `t144`.handle IN ('green-spot-leoville-barton-bordeaux-finish-irish-whiskey'))
ORDER BY `e`.`id`DESC
LIMIT 0, 1;
[0.0004]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 20 AND `element_name` IN ('classification');
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_146` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '146' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_selectbox_link` WHERE `field_id` = '146' LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE `s`.*
FROM `sym_sections` AS `s`
WHERE `s`.`id` = '25';
[0.0002]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '207' LIMIT 1;
[0.0003]SELECT SQL_NO_CACHE * FROM `sym_fields_pages` WHERE `field_id` = '207' LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE `e`.id,
`e`.section_id, e.`author_id`,
UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`
FROM `sym_entries` AS `e`
LEFT JOIN `sym_entries_data_207` AS `t207` ON (`e`.`id` = `t207`.entry_id)
WHERE 1
AND `e`.`section_id` = '25'
AND (`t207`.page_id IN ('Whisky') OR `t207`.handle IN ('Whisky') OR `t207`.title IN ('Whisky'))
ORDER BY `e`.`id`DESC
LIMIT 0, 1;
[0.0004]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 25 AND `element_name` IN ('meta-title', 'meta-description', 'page-heading', 'header-text');
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_211` WHERE `entry_id` IN (10465) ORDER BY `id` ASC;
[0.0003]SELECT SQL_NO_CACHE * FROM `sym_entries_data_210` WHERE `entry_id` IN (10465) ORDER BY `id` ASC;
[0.0003]SELECT SQL_NO_CACHE * FROM `sym_entries_data_209` WHERE `entry_id` IN (10465) ORDER BY `id` ASC;
[0.0007]SELECT SQL_NO_CACHE * FROM `sym_entries_data_218` WHERE `entry_id` IN (10465) ORDER BY `id` ASC;
[0.0003]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '211' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_multilingual` WHERE `field_id` = '211' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '210' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_multilingual` WHERE `field_id` = '210' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '209' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_multilingual` WHERE `field_id` = '209' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '218' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_multilingual` WHERE `field_id` = '218' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = '894de80e905bd7a5e355a5a836291b94' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1;
[0.0003]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = 'c906e9c2f0355b016d347afddc317a4e' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = 'bf3d2a5ccc90255bdc0e2e4c9a362e82' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE `s`.*
FROM `sym_sections` AS `s`
WHERE `s`.`id` = '45';
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '509' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_select` WHERE `field_id` = '509' LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE `id`
FROM `sym_fields`
WHERE `element_name` = 'date' AND `parent_section` = 45
LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '512' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_date` WHERE `field_id` = '512' LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE `e`.id,
`e`.section_id, e.`author_id`,
UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`
FROM `sym_entries` AS `e`
LEFT JOIN
`sym_entries_data_509` AS t509_1
ON (e.id = t509_1.entry_id)
WHERE 1
AND `e`.`section_id` = '45'
AND (
t509_1.value IN ('Event')
OR t509_1.handle IN ('Event')
)
ORDER BY (
SELECT `ed`.value
FROM sym_entries_data_512 AS `ed`
WHERE entry_id = e.id
) ASC
LIMIT 0, 20;
[0.0004]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 45 AND `element_name` IN ('category', 'uk', 'us', 'au', 'be', 'ca', 'fr', 'de', 'hk', 'jp', 'kr', 'nl', 'nz', 'sg', 'za', 'es', 'se', 'tw');
[0.0004]SELECT SQL_NO_CACHE * FROM `sym_entries_data_489` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_490` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_491` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_511` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_493` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_501` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_492` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_494` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_495` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_496` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_497` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_498` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_502` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_499` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_503` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_487` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_488` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_500` WHERE `entry_id` IN (27213,27209,27215,27217,27211,27207,27205) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '489' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '489' LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '490' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '490' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '491' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '491' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '511' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_selectbox_link` WHERE `field_id` = '511' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND id IN (139) ORDER BY t1.`sortorder` ASC;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '139' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE e.id, e.section_id, s.name, s.handle
FROM `sym_entries` AS `e`
LEFT JOIN `sym_sections` AS `s` ON (s.id = e.section_id)
WHERE e.id IN (1976);
[0.0001]SELECT SQL_NO_CACHE `s`.*
FROM `sym_sections` AS `s`
WHERE `s`.`id` = '18';
[0.0001]SELECT SQL_NO_CACHE `e`.id,
`e`.section_id, e.`author_id`,
UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`
FROM `sym_entries` AS `e`
WHERE 1
AND `e`.`id` IN ('1976')
AND `e`.`section_id` = '18'
ORDER BY (
SELECT `ed`.value
FROM sym_entries_data_139 AS `ed`
WHERE entry_id = e.id
) asc;
[0.0002]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 18 AND `element_name` IN ('name');
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_139` WHERE `entry_id` IN (1976) ORDER BY `id` ASC;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '493' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '493' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '501' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '501' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '492' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '492' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '494' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '494' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '495' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '495' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '496' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '496' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '497' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '497' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '498' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '498' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '502' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '502' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '499' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '499' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '503' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '503' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '487' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '487' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '488' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '488' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '500' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '500' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE e.id, e.section_id, s.name, s.handle
FROM `sym_entries` AS `e`
LEFT JOIN `sym_sections` AS `s` ON (s.id = e.section_id)
WHERE e.id IN (1978);
[0.0001]SELECT SQL_NO_CACHE `e`.id,
`e`.section_id, e.`author_id`,
UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`
FROM `sym_entries` AS `e`
WHERE 1
AND `e`.`id` IN ('1978')
AND `e`.`section_id` = '18'
ORDER BY (
SELECT `ed`.value
FROM sym_entries_data_139 AS `ed`
WHERE entry_id = e.id
) asc;
[0.0001]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 18 AND `element_name` IN ('name');
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_139` WHERE `entry_id` IN (1978) ORDER BY `id` ASC;
[0.0001]SELECT SQL_NO_CACHE e.id, e.section_id, s.name, s.handle
FROM `sym_entries` AS `e`
LEFT JOIN `sym_sections` AS `s` ON (s.id = e.section_id)
WHERE e.id IN (1981);
[0.0001]SELECT SQL_NO_CACHE `e`.id,
`e`.section_id, e.`author_id`,
UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`
FROM `sym_entries` AS `e`
WHERE 1
AND `e`.`id` IN ('1981')
AND `e`.`section_id` = '18'
ORDER BY (
SELECT `ed`.value
FROM sym_entries_data_139 AS `ed`
WHERE entry_id = e.id
) asc;
[0.0001]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 18 AND `element_name` IN ('name');
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_139` WHERE `entry_id` IN (1981) ORDER BY `id` ASC;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = '6f9aaea626ba5104cf7560f5de1955d8' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = '656e485576554f3f176fdfd4a6285d25' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = '1a0691e6e5edb1b48b557be8aa494de9' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = '27595ba8788acda7a3ba4bd8537a8c92' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = '0006e5ddfcf7bfb44a7b0af6ce8dc4f8' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = '82a3c5afe5092ca6b6a8c815044c84ed' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE `e`.id,
`e`.section_id, e.`author_id`,
UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`
FROM `sym_entries` AS `e`
LEFT JOIN `sym_entries_data_144` AS `t144` ON (`e`.`id` = `t144`.entry_id)
WHERE 1
AND `e`.`section_id` = '20'
AND (`t144`.value IN ('green-spot-leoville-barton-bordeaux-finish-irish-whiskey') OR `t144`.handle IN ('green-spot-leoville-barton-bordeaux-finish-irish-whiskey'))
ORDER BY `e`.`id`DESC
LIMIT 0, 1;
[0.0003]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 20 AND `element_name` IN ('abv');
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_151` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '151' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_number` WHERE `field_id` = '151' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE `e`.id,
`e`.section_id, e.`author_id`,
UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`
FROM `sym_entries` AS `e`
LEFT JOIN `sym_entries_data_144` AS `t144` ON (`e`.`id` = `t144`.entry_id)
WHERE 1
AND `e`.`section_id` = '20'
AND (`t144`.value IN ('green-spot-leoville-barton-bordeaux-finish-irish-whiskey') OR `t144`.handle IN ('green-spot-leoville-barton-bordeaux-finish-irish-whiskey'))
ORDER BY `e`.`id`DESC
LIMIT 0, 1;
[0.0003]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 20 AND `element_name` IN ('age');
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_153` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '153' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_number` WHERE `field_id` = '153' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '173' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_select` WHERE `field_id` = '173' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE `e`.id,
`e`.section_id, e.`author_id`,
UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`
FROM `sym_entries` AS `e`
LEFT JOIN `sym_entries_data_144` AS `t144` ON (`e`.`id` = `t144`.entry_id)
LEFT JOIN
`sym_entries_data_173` AS t173_1
ON (e.id = t173_1.entry_id)
WHERE 1
AND `e`.`section_id` = '20'
AND (`t144`.value IN ('green-spot-leoville-barton-bordeaux-finish-irish-whiskey') OR `t144`.handle IN ('green-spot-leoville-barton-bordeaux-finish-irish-whiskey'))
AND (
t173_1.value IN ('whiskey')
OR t173_1.handle IN ('whiskey')
)
ORDER BY `e`.`id`DESC
LIMIT 0, 1;
[0.0004]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 20 AND `element_name` IN ('name', 'brand', 'bottler', 'category', 'style', 'classification', 'region', 'abv', 'size', 'age', 'vintage', 'bottled', 'ob', 'family', 'image', 'description');
[0.0004]SELECT SQL_NO_CACHE * FROM `sym_entries_data_151` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_153` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_155` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_159` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_145` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_147` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_146` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_373` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0003]SELECT SQL_NO_CACHE * FROM `sym_entries_data_173` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_143` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_165` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_150` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_152` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_171` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_154` WHERE `entry_id` IN (27200) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '155' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_number` WHERE `field_id` = '155' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '159' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_selectbox_link` WHERE `field_id` = '159' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '145' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_selectbox_link` WHERE `field_id` = '145' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND id IN (136) ORDER BY t1.`sortorder` ASC;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '136' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE e.id, e.section_id, s.name, s.handle
FROM `sym_entries` AS `e`
LEFT JOIN `sym_sections` AS `s` ON (s.id = e.section_id)
WHERE e.id IN (2465);
[0.0001]SELECT SQL_NO_CACHE `s`.*
FROM `sym_sections` AS `s`
WHERE `s`.`id` = '17';
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '441' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_number` WHERE `field_id` = '441' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE `e`.id,
`e`.section_id, e.`author_id`,
UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`
FROM `sym_entries` AS `e`
LEFT OUTER JOIN `sym_entries_data_441` AS `ed` ON (`e`.`id` = `ed`.`entry_id`)
WHERE 1
AND `e`.`id` IN ('2465')
AND `e`.`section_id` = '17'
ORDER BY `ed`.`value` asc;
[0.0002]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 17 AND `element_name` IN ('name');
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_136` WHERE `entry_id` IN (2465) ORDER BY `id` ASC;
[0.0002]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '147' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_selectbox_link` WHERE `field_id` = '147' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND id IN (141) ORDER BY t1.`sortorder` ASC;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '141' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE e.id, e.section_id, s.name, s.handle
FROM `sym_entries` AS `e`
LEFT JOIN `sym_sections` AS `s` ON (s.id = e.section_id)
WHERE e.id IN (2014);
[0.0001]SELECT SQL_NO_CACHE `s`.*
FROM `sym_sections` AS `s`
WHERE `s`.`id` = '19';
[0.0001]SELECT SQL_NO_CACHE `e`.id,
`e`.section_id, e.`author_id`,
UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`
FROM `sym_entries` AS `e`
WHERE 1
AND `e`.`id` IN ('2014')
AND `e`.`section_id` = '19'
ORDER BY (
SELECT `ed`.value
FROM sym_entries_data_141 AS `ed`
WHERE entry_id = e.id
) asc;
[0.0002]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 19 AND `element_name` IN ('name');
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_141` WHERE `entry_id` IN (2014) ORDER BY `id` ASC;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '373' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_multilingual` WHERE `field_id` = '373' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '143' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '143' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '165' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '165' LIMIT 1;
[0.0002]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '150' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_selectbox_link` WHERE `field_id` = '150' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '152' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_number` WHERE `field_id` = '152' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '171' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_selectbox_link` WHERE `field_id` = '171' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND id IN (167) ORDER BY t1.`sortorder` ASC;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '167' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE e.id, e.section_id, s.name, s.handle
FROM `sym_entries` AS `e`
LEFT JOIN `sym_sections` AS `s` ON (s.id = e.section_id)
WHERE e.id IN (1990);
[0.0001]SELECT SQL_NO_CACHE `s`.*
FROM `sym_sections` AS `s`
WHERE `s`.`id` = '23';
[0.0001]SELECT SQL_NO_CACHE `e`.id,
`e`.section_id, e.`author_id`,
UNIX_TIMESTAMP(e.`creation_date`) AS `creation_date`
FROM `sym_entries` AS `e`
WHERE 1
AND `e`.`id` IN ('1990')
AND `e`.`section_id` = '23'
ORDER BY (
SELECT `ed`.value
FROM sym_entries_data_167 AS `ed`
WHERE entry_id = e.id
) asc;
[0.0002]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 23 AND `element_name` IN ('name');
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_167` WHERE `entry_id` IN (1990) ORDER BY `id` ASC;
[0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '154' LIMIT 1;
[0.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_number` WHERE `field_id` = '154' LIMIT 1;
[0.0001]