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` = 'muuk5tltus6thnm9d0t1ph4a71' LIMIT 1; [0.0004]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.0005]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.0002]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.0001]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.0001]SELECT SQL_NO_CACHE * FROM `sym_fields_uniqueinput` WHERE `field_id` = '144' 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.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.0002]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.0004]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.0002]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` = '6d11015d988c8c85778b33683f48d9b1' 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` = '27121e118f637257bc8acab40fbb61eb' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1; [0.0003]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.0002]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.0003]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.0005]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.0005]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.0003]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.0004]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.0004]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.0005]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.0003]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.0003]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.0006]SELECT SQL_NO_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '489' LIMIT 1; [0.0002]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.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.0002]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.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.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.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.0002]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` = '1266951b4d30b8f7c9de5218bde511a7' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1; [0.0003]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.0005]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` = 'd59833152ad7aac2fe03aff80132cd6e' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = 'e5ab56081ba0fee4e5258e6dbb6697a3' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = '85afafc42bf2afff88c31cda9d7b39e5' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1; [0.0002]SELECT SQL_NO_CACHE * FROM `sym_cache` WHERE `hash` = 'd888fc27f0ff79f1d4a05278c8084df4' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1; [0.0002]DELETE FROM `sym_cache` WHERE `hash` = 'd888fc27f0ff79f1d4a05278c8084df4' LIMIT 1; [0.0006]INSERT INTO `sym_cache` (`hash`, `creation`, `expiry`, `data`) VALUES ('d888fc27f0ff79f1d4a05278c8084df4', '1748014606', NULL, 'eJzNXd122zYSvm6fAkcXuzdVYsuKnZx13GMnTZo0P9787ranpweiYAkWRXBJUKr9Rn2N3RfbwQ8pigLIgUyfk5sYgIiZbwbAzGAAMqc//rmMyYplORfJ08Hhg4MBYUkkpjyZPR18/vRi+Hjw49n3pzKjSR5TCU/lZ98TcsoSmd0QPn06GJ2Mjp4Mzr7/7rvvThfshsxpMo3Z00EMf4HKcFLcDBOxHpw1Gk4fwtOm24rGBSNLMYVuiciWNB6Qtcimw0gUiQRYg7NfRMqS04f6SdXp9KFG4MDy2IEloStgmyX5MOGzuRyu5zxf3AzO3O0ByI4GZxeqP3lHo7kkX21/BMwTD8xonvFcLmm+BbLZGqg8GF+5xmM7bhlOIecsG4ooomrK5JthbfwQpsTzZMoyRvKURZzGjEzpDDXch09cekwzMS0iCbNsmLEVZ2uAudsWokPg8lNGbvl1Ak8tAQFjMZkxlhCgy64SIbnkLCcrITLy28WH83fPf39AfhFLMuFJwpKFyCSRLCtm5pEZm2QFX8C4ZCxiSa770oT8dvnh/fPPzz79DquQUKMUi5wlD1AKOXBNLDHkki3zYQyziE2HE1jOU5hZruYAtTwanL1UOtBEjGBTLsmSZQsM1gMn1iv6nyGdiEKWKKHhD93wRyi+8eDsCwzUjIF08ZSRVaamFRFg78pBwsB87DJvgEpDC1uJL87/ieE4chmxnNEsmg9jQdV6G5xt18NwvKFTmE8PUKM08pkqWAeFMU+qFAbgHV2heLtMkeJohDfcTTmM/6+CLVAW5mD0yANhDobAAFClMPYfJc1kSmc8oSgMYw8GbdSZdRK2Eobka9kJgeKoDUUdxD4YcBBGvrkoMjsYqhTG/i1jGYr5oYc5jeMh0IynW5potgaAGhlQZA32P56a7n/PURid5t+iiWgCtoImOzAbPwT67jhmS0pj8kxRYTkj6FDj4NBlWktUFBwJj0pUrIa3+cuegM8VmQWF0DYIsy/CVMiuaUoT0MGOihs/7In4taIShtZnvRUoDlHlfFe9W817In0FsU0QTp+lV4DySMhovqPTreY9cX6M5kKGIfU5BPZnGoPxMYveoNxqCkP4nNnlr7Zn4KsSnLs69LmKEopdO9v4bGOYifqicZWrCAXO50FKHHqVbEPTTXsBe216ImD5vEqJgcM4mIh5t3EvaLA6TF8EOJ/XyRmrub2yFgbngi349QIidpwHPPR5F7sSIbzOLZxNQ2BkytiV5NdT3Gw/8PkPyz9jM7NL3W0Lg/VBdcK54AOff7D8c3kTN9RkmgJDSNhuSaSWfD7A7NnTzbDVGsImkt3Am5AWqSefxa/Zz1C7qYJJbTRRAHyGvAyHbO7F1sJglMEQCojPZpdxjnV5thYGpBbkoLD4THQZwBgsZS0Miw1fUDh8NlkHJwaELoYh0GEJir/X7OolW1++getWBxzdEI6fPHYt23wu1kMwFrBgq2JYYPGGUkmWXC1YcssxFgSguNaq5m88UFXcBwoLAeJas5GIY5qqqVmWAockLjjKlAJ/11KFiEBHB+ZvGO/3KUNFdsDatSIkzaXKviZCshzILlVycnDmbA4FpvJ4OrOEwOZaLdsgrniiF66rNTCJZvsgYLnilW0AqsaaqHRj4ByC3cQCg+nEFbJss09EvgNJtQWm2FiBMjMnrnjlSgDXbKiz03K4BWVw1vJjYNSwkAWDnRhRYbHIZZHMcpVLv8WtiBOXgTQbuWHC1vlwzVWyIE0ZzQZnnh/CLJZJVSWcFeu8SKdUqsQ9+JRozq9hHZM5Zxkiq3pw7PUvKzFd2N2ZLgZGP6ZLJ/+RN4thQsA8Becqt6JC27RXXDjNaILJtx4ejpxrVqEAU2GjQlUKg6HSvQSdRwMUJ77hiXmysGrRxQAcB4OHrTydATGE4sMbmKZDUUsvOhrDjkV+O3/50+/kmtKMiGKKzn4okC4HqPCkIi1igGQ2E82WsFV2qXvCBtsCIzF+V3h48NiZS8rVKRVNIVYxhUDzXnbq5H78yHteorIG9fCx1rDXcWmZu1rqpAIKm2/PVY6VPmKz83u7LWzBbUYQD27smlpFrj2NPcWt18JU9sF00qesm9NXFCxnbMNlDGM3F2mqfF/G8iJW5tLdHqa7j7Y3Mb0pJjQFnEcunNZVyzVjcuO5TTUMlYrVISoin2xfBCDn8a5BkNJMJsqp8HpEsdUaOOFMV2K7dqMbOU91DY5ET7ZaJQzLOx0ekL/RZfoP8tlECShI7T65nv6ut+zlkbEWH1D57JkjK79vRn5U7ouDgPmN2TSCoLQyY6YWZvAvq14IIL5E0iQWM3vLCEphAC50j07m42OXFuzUjUR6k6mbTdVkrlpCwMC0/O9f5Ld//3T+4Xd7x4m8pWDWZRrTiJF3bGry2bm68yLS8pn3CYRI7AH5CMYMgvy3NJbgs9QM+YFcxAwm4rSqm/Miexr9Q3XQZSlBZK3SBN2R9aMDl9GxVyV4ciWGo+rmhKmGKOJQXXjRvoOI5JaBI6HgTyJABjHUFY9BwzkRS5LC1khd6QFzuVKJloSsqSQFuYUwVHYLMT5xJeFUwAdTWv8JW1plnNfN+NhlFJVJLePeTTlwdUM/Yvt1gmiZ0WnGI53RSKROdDibQ2LhkT1pY9mMzdhK3+ji17fqVlNCpgwGWQ3axhObS2AwqDyikrMrNTUXhTqdI2vox2cseUBespgDLaIiazZROtNxh7qCpDa6KfgpaMoonaYxU1eSaLyCWDDJSbEmFLZKahHRK/2QUPPnAbEroQRnUURxkSsQF5++EnFlqIs0l3SRk6Ua9Vuh83zwA/RS94Rytc9WBD+vyURfjIpVqLEAeEKoaQ2PzyFWgjbNA9AQvkxFJhVRzCW08bErjrMDZTfhZryq4dtqDZtY1kBYvSDAuaIkvabUZsouL1UMs9ZqiXUzf+Ra1zm/VRlU+DcwlZ3MUWv6kS+TnjFJecwy6yeraujJWNWtC8nYFd9sX5zZ88JMde6DjB7GY2dQA7N87rp24mwPjAmFqtdvnGBvXo3HLnvYuLqx75WNkT0SCUDjCnZ2rr3sf91lVB0TYa9Tj50bx4kJMKoN93Y98Jh8K1hBAHKvcxUFDYG+rEDttoXtancjKwQ4b4JNXWm1hf6vtY6dbwnoc83p9n3OTT1slF5uojHttDHuwHnXXW+wrq4qy2jKgQFPeZUdFvuEM+V6UXh8Wwm6plmZmDHlvfzkue3alSB2TeCoyCBGiWB1l6XAe5aFujefzBnv9lrOKzl0xnRmcb8bJR6e5ohfspnIIGRXTc1jhsptGRy1Y8dooXzfcMKl1JOl2XL60DxrusciovEwAT/SPlTPLBVyUVLZ9DSUNA0/jF0CZdea4M0DiermaEPKGU9gafFkD1nUiT9LIBDOOkTY8OgGOjoau4Hag5Mv5gRkH7D28KQV6jaXLriHT46PPLMnK5YQPBXLPaDag4QGsg3BTlSPj6tTyAYqCtxmCY0GZ+e2tJ8qN71btelih0HvmauRMMSeif2Rl3071tw2o+55UJ2QNxW+E22e25ZNSLaPEdm526wItY8FAglCTt/QNO+eP7MNVZS3l6lsXjlvH7VODN3y+RbOTgT82jbcSb7mfe9W8bohIMTzWKvGduOVqt5tgtYuiHdOzXbuCKlO3FJt7z2/qtqdhsvsQSsSrTK18UZIdOyWqJGTN3uCO8lkSaBmYDt3h1SqsRl+ne7e1XUoYFwGiDTmNN8gSNlNzqdMB+C6dPpQP+HWln2meZRR9iWd+jPcEa76Do49FGV3DFW9FLKtvFiszTX3N6bQpjr7bBOT7fltKC4MY/eiq3bO22rjeUyVVVJ/2lSmn2uC0b2+DXXh8SFUdehVlZpgr/Ku+WWedKH5VmZXCEKEwsZOhc35bG5U9rMttSmtfLoJquz7bSguFCVCeUdO5UV0mU5YLMU6UbFeVWlTYa1PE1+NwrehyP2wet3wrs81yZGY5jm/0uddLl88Ojn0RY20yGWmNLEJuc+rpv2jErc2cMy6nePJyBPix1SuFHWdrXhjKmS/zIjHX3kZYFD7IndpdKKJvjKVXlH7GWBQ++LYNZuqmF8T/WgqvaL2M8CgfuRBDfutDVFT6Re1lwEGtSdxtmZxSfKrKvaK2E0cg/bIjfZKZZ4txRe63CteH3kM4pF/TyY3o2Zr/c6LFhYY5F3JKU22Sgf1ibyNBQa5L2vNAIAl+lKXe0XtI4/Js3tsx7SQ5bx7roq94nUTx6D12AyWzOJqvv1kKr0i9jNAHBE88diOBb2li3kuwW6W71n8smki+x4duCXAMcNI47ErpeO1xEvX268U7Uww6D22xUxJS9ZMyn6R+xlgUHvsyhVPtAO2ZF+Yas/I25kg0D/2RLBVAtxSrvLf/eLvYoORwLejKN2FJV05jH4l6GKDkcCTc7YBRjm2JsToef60sMAgb8kty9q8rMKMftF3scFI4PGxWQE72c2ofjDVnvG3M8Gg9/jccntoCZcbxH7RtzPBoPf43lTEtUG91LWesbexwCD3+NkyFLF0y2CkX+ztTDDoPX623OiWq8ludXtes61MMOg9/jZh6+EtozpdaIm/Y2vyq2nqWQocM8Th3Mhn+3nMU64+QaruarywNdLnLZA2FhjkntWrLryDVdBEX+lyr6h95DGIu/aummjlwPtE3cYCgfzQE6WlLCtWlTouba1X5G0sMMg983vJ/tzo462p9IrbzwCB+sCDOpfDFU/UtwwqjXyU5EvV1KsEOGbd0hw/8URpMuMJn9LNevq0aehVkm5GGCk8sU4KW4YlbJOrKVrV+10HHWwwEniihiUtMr4Z5Ldltd/10MoEgd63z5rQ65LohSr2itpNHIPWM1smLFsW04qmrfWLuYUFBrlnlkQiLpaTagCfldVesbczwaD3RGdgzOIiqhmyB+SNrvdtMtu4IPD7zienYgkmq3Ioz8tqr/DbmWDQ+/bj7Caaq8/n5FYxVb1f9XewwUjgWbe1I1sTQm3Oa3uN0zrYYCTwrN85rZnfn2n/Ft7PAIPat6uC+ZfRWVHSfVfVe8XexQYhwbFn5a5Ywm4L9QFWQ/pLVe9Vgi42CAkeeaL8Fc9mPBnaW0SGum4i9gpRr3KgmGGk8cTQMLAZn7DKxZTVfv1YKxMMek9ecEkzWbfRb6t6z9FaOxuMBB5LGhWTSi2q2K/encQxaD3ZhFlxY26qa5ovba1XzG0sMMg99j4tWCbFsLbtv9Qt5EPvswXDCiOJJz9yDRudDenXttarBG0sOpE/PvZlNBORqD20VN8Y27xA9A5av5hWcod3lzyeLIAlRjKPX95lcW8SYVghJPHFpmnGcsmBfvmm1KVtIHu/mzVyEGl9G6EbA0ZA71Uv/X7vMCpWbMPBvvVLnhWr//11B1mPvKTa378IAYUR3uNt/hQV8X+9v9OI1rq3SubmiBHB44JWuUgrkl8+vr+8kxhbBNrfH/XyxQjj8UqrvEbyjoJgxXBx7DzoOR779rLmQwizjKowdft1L/uRg5fqN3LXN888e9w92XefbB36Ulb2cxQNZuWXJu5HzDCmCOE8i6t6E7FkuPNGYsmy5zvg4YwRQnoWXcWr/hGPHX71L3Tcl7DBABBCe2KvBTxURIubocqg6P8zcyKKbCJqbw3/Yh8hH+0j5MI80vt07gcMQhm+9KfR+wT2oSze5W01f6F/vjcl3A1Et/AHnvxFfdK5LaaecvdqrwOZI4T1pJvSIlPfM5Yw0/ju/5t1Cb+SSyFhksGv9yTyXSB0bxN9t9VKO2o8Y+Mlo9KWGtd413eN211WOACE0JhgpPnSbT0auB+R92WPELgjGKl9h2pHx7VvTN3XGIeyRwjsCVC2Pwa2w+x+xcQxRQjne99k56Nizelzj2O5H3OHsPbTAM2XD08fbv1f5P8HnKj34w=='); [0.0003]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.0007]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.0003]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.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 (9632) 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 ('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.0005]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.0005]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.0003]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.0004]SELECT SQL_NO_CACHE * FROM `sym_entries_data_173` WHERE `entry_id` IN (9632) ORDER BY `id` ASC; [0.0002]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.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 (2462); [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 ('2462')
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 (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.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 (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.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 (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.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` = '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]