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.0000]SELECT SQL_NO_CACHE `session_data` FROM `sym_sessions` WHERE `session` = '4hjfrtvjb2lfqilj2fqgp947q1' LIMIT 1; [0.0002]SELECT SQL_NO_CACHE `name` FROM `sym_extensions` WHERE `status` = 'enabled'; [0.0002]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` = 'whisky' AND `handle` = 'whyte-mackay-13-year-old-blended-scotch' LIMIT 1; [0.0003]SELECT SQL_NO_CACHE * FROM `sym_pages` WHERE `path` IS NULL AND `handle` = 'whisky' LIMIT 1; [0.0002]SELECT SQL_NO_CACHE `type` FROM `sym_pages_types` WHERE `page_id` = '114'; [0.0001]SELECT SQL_NO_CACHE * FROM `sym_pages` WHERE `path` = 'whisky' AND `handle` = 'whyte-mackay-13-year-old-blended-scotch' LIMIT 1; [0.0003]SELECT SQL_NO_CACHE * FROM `sym_pages` WHERE `path` IS NULL AND `handle` = 'whisky' LIMIT 1; [0.0002]SELECT SQL_NO_CACHE `type` FROM `sym_pages_types` WHERE `page_id` = '114'; [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.0002]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 ('whyte-mackay-13-year-old-blended-scotch') OR `t144`.handle IN ('whyte-mackay-13-year-old-blended-scotch'))
ORDER BY `e`.`id`DESC
LIMIT 0, 1; [0.0006]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 20 AND `element_name` IN ('classification'); [0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_146` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0001]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.0001]SELECT SQL_NO_CACHE `s`.*
FROM `sym_sections` AS `s`
WHERE `s`.`id` = '25'; [0.0001]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '207' LIMIT 1; [0.0001]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.0003]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.0003]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` = '520e2634fb2aa40bd85f363edab854ae' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1; [0.0002]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` = 'f3719fbf242fa09fb6732c363da63cde' 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.0001]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.0001]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.0004]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '491' LIMIT 1; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '491' LIMIT 1; [0.0002]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '511' LIMIT 1; [0.0002]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.0002]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.0002]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.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_139` WHERE `entry_id` IN (1976) ORDER BY `id` ASC; [0.0002]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '493' LIMIT 1; [0.0002]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.0003]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '501' LIMIT 1; [0.0013]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '492' LIMIT 1; [0.0004]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '492' LIMIT 1; [0.0002]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.0002]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.0002]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.0015]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '500' LIMIT 1; [0.0013]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '500' LIMIT 1; [0.0003]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.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`
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.0002]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 18 AND `element_name` IN ('name'); [0.0002]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` = '69db4f81d3b5f696dff4596a78c0040d' 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 ('whyte-mackay-13-year-old-blended-scotch') OR `t144`.handle IN ('whyte-mackay-13-year-old-blended-scotch'))
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 ('region'); [0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_150` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [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 * 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` = '5d2a66f96922963f4961bb73e72084af' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = '25ba2bd56061a1af9f598d1e3852ce47' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = 'd9ee56d74dc30c9390bf07311014558c' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = 'e526b74b965ee6ffebc9ec0cd98fb9b2' 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 ('whyte-mackay-13-year-old-blended-scotch') OR `t144`.handle IN ('whyte-mackay-13-year-old-blended-scotch'))
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.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_151` WHERE `entry_id` IN (9632) 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 ('whyte-mackay-13-year-old-blended-scotch') OR `t144`.handle IN ('whyte-mackay-13-year-old-blended-scotch'))
ORDER BY `e`.`id`DESC
LIMIT 0, 1; [0.0002]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 (9632) ORDER BY `id` ASC; [0.0001]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 ('whyte-mackay-13-year-old-blended-scotch') OR `t144`.handle IN ('whyte-mackay-13-year-old-blended-scotch'))
AND (
t173_1.value IN ('whisky')
OR t173_1.handle IN ('whisky')
)
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 (9632) ORDER BY `id` ASC; [0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_153` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_155` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_159` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_145` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_147` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_146` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_373` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0003]SELECT SQL_NO_CACHE * FROM `sym_entries_data_173` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_143` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_165` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_150` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0001]SELECT SQL_NO_CACHE * FROM `sym_entries_data_152` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_171` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_154` WHERE `entry_id` IN (9632) 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.0003]SELECT SQL_NO_CACHE * FROM `sym_fields_input` WHERE `field_id` = '136' LIMIT 1; [0.0002]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 (2462); [0.0002]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.0002]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 ('2462')
AND `e`.`section_id` = '17'
ORDER BY `ed`.`value` asc; [0.0004]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 17 AND `element_name` IN ('name'); [0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_136` WHERE `entry_id` IN (2462) 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.0002]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 (1983); [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 ('1983')
AND `e`.`section_id` = '19'
ORDER BY (
SELECT `ed`.value
FROM sym_entries_data_141 AS `ed`
WHERE entry_id = e.id
) asc; [0.0003]SELECT SQL_NO_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 19 AND `element_name` IN ('name'); [0.0002]SELECT SQL_NO_CACHE * FROM `sym_entries_data_141` WHERE `entry_id` IN (1983) 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.0020]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '143' LIMIT 1; [0.0003]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` = '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.0002]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]