czheng/referencelink — Issue #8: Fatal DB error SQL issue with NULL values in Symphony 2.2.3 and 2.2.4
Author: bzerangue
Created: 2011-10-25 18:46:21+00:00
State: open

Craig,

After upgrading to Symphony 2.2.3 and 2.2.4, I ran into the following issue. Anytime I tried to create an entry and left the reference link field empty (NULL value)... I got the following SQL error...

Symphony Fatal Database Error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4

An error occurred while attempting to execute the following query

SELECT SQL_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 ()

Backtrace:
[/home/public/symphony/lib/toolkit/class.mysql.php:463] MySQL->__error();
[/home/public/symphony/lib/toolkit/class.mysql.php:609] MySQL->query();
[/home/public/extensions/selectbox_link_field/fields/field.selectbox_link.php:233] MySQL->fetch();
[/home/public/extensions/selectbox_link_field/fields/field.selectbox_link.php:474] fieldSelectBox_Link->findRelatedValues();
[/home/public/extensions/reflectionfield/extension.driver.php:102] fieldSelectBox_Link->appendFormattedElement();
[/home/public/extensions/reflectionfield/fields/field.reflection.php:263] Extension_ReflectionField->getXPath();
[/home/public/extensions/reflectionfield/extension.driver.php:131] FieldReflection->compile();
[/home/public/symphony/lib/toolkit/class.extensionmanager.php:559] Extension_ReflectionField->compileBackendFields();
[/home/public/symphony/content/content.publish.php:897] ExtensionManager->notifyMembers();
[/home/public/symphony/content/content.publish.php:40] contentPublish->__actionEdit();
[/home/public/symphony/content/content.publish.php:26] contentPublish->__switchboard();
[/home/public/symphony/lib/toolkit/class.administrationpage.php:242] contentPublish->action();
[/home/public/symphony/lib/core/class.administration.php:230] AdministrationPage->build();
[/home/public/symphony/lib/core/class.administration.php:383] Administration->__buildPage();
[/home/public/index.php:25] Administration->display();

Database Query Log:
SET character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'; [0.0001]
SET CHARACTER SET 'utf8'; [0.0001]
SELECT SQL_CACHE `session_data` FROM `sym_sessions` WHERE `session` = 'p5odq1hnm5icn084kabukuqdl2' LIMIT 1; [0.0001]
SELECT SQL_CACHE `name` FROM `sym_extensions` WHERE `status` = 'enabled'; [0.0002]
SELECT SQL_CACHE `id` FROM `sym_authors` WHERE `username` = 'webmaster' AND `password` = 'e9c738498865cdc094eae67e2ce7d5d7675335bd' LIMIT 1; [0.0001]
UPDATE sym_authors SET `last_seen` = '2011-10-25 12:01:36' WHERE `id` = '1'; [0.0010]
SELECT SQL_CACHE * FROM `sym_authors` WHERE `id` IN (1) ORDER BY id ASC; [0.0003]
SELECT SQL_CACHE * FROM `sym_extensions`; [0.0002]
SELECT SQL_CACHE * FROM `sym_authors` WHERE `username` = 'webmaster' LIMIT 1; [0.0003]
SELECT SQL_CACHE * FROM `sym_sections` ORDER BY `sortorder` ASC; [0.0003]
SELECT SQL_CACHE * FROM `sym_authors` WHERE `username` = 'webmaster' LIMIT 1; [0.0001]
SELECT SQL_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.0003]
SELECT SQL_CACHE `id` FROM `sym_sections` WHERE `handle` = 'events' LIMIT 1; [0.0001]
SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` WHERE `s`.`id` = '13'; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '13' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE `s`.* FROM `sym_sections` AS `s` ORDER BY `s`.`name` ASC; [0.0003]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '20' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '6' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '15' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '43' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '26' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '7' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '19' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '18' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '9' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '40' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '12' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '39' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '13' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '22' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '21' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '10' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '28' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '32' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '31' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '33' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '38' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '44' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '11' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '14' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '37' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '17' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '27' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '24' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '25' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '16' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '29' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '46' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '45' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '47' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '50' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '49' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '48' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '51' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '23' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '41' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '35' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '30' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '34' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '36' ORDER BY `sortorder` ASC; [0.0001]
SELECT SQL_CACHE `id` FROM `sym_sections` WHERE `handle` = 'events' LIMIT 1; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '13' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE `id` FROM `sym_sections` WHERE `handle` = 'events' LIMIT 1; [0.0001]
SELECT SQL_CACHE `field_id`, `section_id` FROM sym_autocompleter_fields	WHERE `section_id` = 13; [0.0001]
SELECT SQL_CACHE `section_id` FROM `sym_entries` WHERE `id` = '6955' LIMIT 1; [0.0001]
SELECT SQL_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 ('6955') AND `e`.`section_id` = '13'; [0.0001]
SELECT SQL_CACHE `id` FROM `sym_fields` WHERE `parent_section` = 13; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_66` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_67` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_68` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_69` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_70` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_72` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_73` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_76` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_77` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_78` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_81` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_82` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_83` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_84` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_85` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_86` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_87` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_88` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_89` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_93` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_94` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_95` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_114` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_115` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_120` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_121` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_122` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_157` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_156` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_133` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_137` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_138` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_139` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_278` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_208` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_158` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_167` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_168` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_207` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_232` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_248` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_249` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_258` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_265` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_271` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_272` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_346` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_347` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_348` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_458` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE * FROM `sym_entries_data_466` WHERE `entry_id` IN (6955) ORDER BY `id` ASC; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '13' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '66' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '66' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '466' LIMIT 1; [0.0004]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '466' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '346' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '346' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '76' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_select` WHERE `field_id` = '76' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '347' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_referencelink` WHERE `field_id` = '347' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '67' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '67' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '69' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '69' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '70' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '70' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '156' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '156' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '158' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '158' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '114' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '114' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '168' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '168' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '73' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` = '73' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '72' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` = '72' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '77' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '77' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '78' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '78' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '248' LIMIT 1; [0.0003]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '248' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '167' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '167' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '87' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '87' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '88' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '88' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '89' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '89' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '122' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '122' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '81' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '81' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '137' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '137' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '138' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '138' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '139' LIMIT 1; [0.0003]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '139' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '458' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '458' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '85' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '85' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '82' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '82' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '86' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '86' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '93' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '93' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '83' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '83' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '94' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '94' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '348' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` = '348' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '84' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '84' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '95' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '95' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '249' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_textarea` WHERE `field_id` = '249' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '68' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '68' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '232' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '232' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '115' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '115' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '121' LIMIT 1; [0.0003]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '121' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '157' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '157' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '120' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '120' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '133' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '133' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '207' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_subsectionmanager` WHERE `field_id` = '207' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '258' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_checkbox` WHERE `field_id` = '258' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '271' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '271' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '272' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_date` WHERE `field_id` = '272' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '208' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_subsectionmanager` WHERE `field_id` = '208' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '278' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '278' LIMIT 1; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '265' LIMIT 1; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_reflection` WHERE `field_id` = '265' LIMIT 1; [0.0001]
SELECT SQL_CACHE `id`, `element_name`, `type`, `location` FROM `sym_fields` WHERE `parent_section` = '13' ORDER BY `sortorder` ASC; [0.0002]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`parent_section` = '13' ORDER BY t1.`sortorder` ASC; [0.0003]
DELETE FROM sym_entries_data_66 WHERE `entry_id` = '6955'; [0.0010]
INSERT INTO `sym_entries_data_66` (`entry_id`, `value`, `handle`) VALUES ('6955', 'test', 'test'); [0.0002]
DELETE FROM sym_entries_data_68 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_68` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', '2011-10-25T11:23:00-05:00', '1319559780', '1319559780'); [0.0001]
DELETE FROM sym_entries_data_69 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_69` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', '2011-10-25T11:23:00-05:00', '1319559780', '1319559780'); [0.0001]
DELETE FROM sym_entries_data_70 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_70` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', '2011-10-25T11:23:00-05:00', '1319559780', '1319559780'); [0.0001]
DELETE FROM sym_entries_data_72 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_72` (`entry_id`, `value`, `value_formatted`) VALUES ('6955', '

test

\r\n', '

test

\r\n'); [0.0001]
DELETE FROM sym_entries_data_73 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_73` (`entry_id`, `value`, `value_formatted`) VALUES ('6955', '

test

\r\n', '

test

\r\n'); [0.0002]
DELETE FROM sym_entries_data_76 WHERE `entry_id` = '6955'; [0.0003]
INSERT INTO `sym_entries_data_76` (`entry_id`, `value`, `handle`) VALUES ('6955', NULL, NULL); [0.0002]
DELETE FROM sym_entries_data_83 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_83` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', NULL, NULL, NULL); [0.0002]
DELETE FROM sym_entries_data_84 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_84` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', NULL, NULL, NULL); [0.0002]
DELETE FROM sym_entries_data_85 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_85` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_86 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_86` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', NULL, NULL, NULL); [0.0002]
DELETE FROM sym_entries_data_93 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_93` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_94 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_94` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_95 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_95` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_114 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_114` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_115 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_115` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0002]
DELETE FROM sym_entries_data_120 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_120` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0002]
DELETE FROM sym_entries_data_122 WHERE `entry_id` = '6955'; [0.0005]
INSERT INTO `sym_entries_data_122` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0002]
DELETE FROM sym_entries_data_156 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_156` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_133 WHERE `entry_id` = '6955'; [0.0120]
INSERT INTO `sym_entries_data_133` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0002]
DELETE FROM sym_entries_data_137 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_137` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_138 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_138` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_139 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_139` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_158 WHERE `entry_id` = '6955'; [0.0007]
INSERT INTO `sym_entries_data_158` (`entry_id`, `value`) VALUES ('6955', 'yes'); [0.0001]
DELETE FROM sym_entries_data_167 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_167` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0002]
DELETE FROM sym_entries_data_232 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_232` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_248 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_248` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_249 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_249` (`entry_id`, `value`, `value_formatted`) VALUES ('6955', NULL, NULL); [0.0001]
DELETE FROM sym_entries_data_258 WHERE `entry_id` = '6955'; [0.0006]
INSERT INTO `sym_entries_data_258` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0002]
DELETE FROM sym_entries_data_265 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_265` (`entry_id`, `handle`, `value`, `value_formatted`) VALUES ('6955', NULL, NULL, NULL); [0.0001]
DELETE FROM sym_entries_data_271 WHERE `entry_id` = '6955'; [0.0003]
INSERT INTO `sym_entries_data_271` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', NULL, NULL, NULL); [0.0002]
DELETE FROM sym_entries_data_272 WHERE `entry_id` = '6955'; [0.0003]
INSERT INTO `sym_entries_data_272` (`entry_id`, `value`, `local`, `gmt`) VALUES ('6955', NULL, NULL, NULL); [0.0002]
DELETE FROM sym_entries_data_346 WHERE `entry_id` = '6955'; [0.0004]
INSERT INTO `sym_entries_data_346` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_347 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_347` (`entry_id`, `relation_id`) VALUES ('6955', NULL); [0.0001]
DELETE FROM sym_entries_data_348 WHERE `entry_id` = '6955'; [0.0003]
INSERT INTO `sym_entries_data_348` (`entry_id`, `value`, `value_formatted`) VALUES ('6955', NULL, NULL); [0.0001]
DELETE FROM sym_entries_data_458 WHERE `entry_id` = '6955'; [0.0002]
INSERT INTO `sym_entries_data_458` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_466 WHERE `entry_id` = '6955'; [0.0003]
INSERT INTO `sym_entries_data_466` (`entry_id`, `value`) VALUES ('6955', 'no'); [0.0001]
DELETE FROM sym_entries_data_67 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_168 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_77 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_78 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_87 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_88 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_89 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_81 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_82 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_121 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_157 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_207 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_208 WHERE `entry_id` = '6955'; [0.0001]
DELETE FROM sym_entries_data_278 WHERE `entry_id` = '6955'; [0.0001]
SELECT SQL_CACHE * FROM `sym_sections_association` AS `sa`, `sym_sections` AS `s` WHERE `sa`.`parent_section_id` = 13 AND `s`.`id` = `sa`.`child_section_id` ORDER BY `s`.`sortorder` ASC; [0.0001]
SELECT SQL_CACHE count(*) AS `count` FROM `sym_entries_data_207` WHERE `entry_id` = '6955'; [0.0001]
SELECT SQL_CACHE count(*) AS `count` FROM `sym_entries_data_208` WHERE `entry_id` = '6955'; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '262' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_referencelink` WHERE `field_id` = '262' LIMIT 1; [0.0001]
SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_262` WHERE `relation_id` = 6955; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '260' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_referencelink` WHERE `field_id` = '260' LIMIT 1; [0.0001]
SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_260` WHERE `relation_id` = 6955; [0.0001]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND t1.`id` = '263' LIMIT 1; [0.0001]
SELECT SQL_CACHE * FROM `sym_fields_referencelink` WHERE `field_id` = '263' LIMIT 1; [0.0001]
SELECT SQL_CACHE COUNT(*) as `count` FROM `sym_entries_data_263` WHERE `relation_id` = 6955; [0.0001]
SELECT SQL_CACHE s.handle FROM `sym_sections` AS s WHERE s.id = '10' LIMIT 1; [0.0003]
SELECT SQL_CACHE s.handle FROM `sym_sections` AS s WHERE s.id = '22' LIMIT 1; [0.0002]
SELECT SQL_CACHE s.handle FROM `sym_sections` AS s WHERE s.id = '30' LIMIT 1; [0.0002]
SELECT SQL_CACHE t1.* FROM sym_fields as t1 WHERE 1 AND id IN (341) ORDER BY t1.`sortorder` ASC; [0.0002]
SELECT SQL_CACHE * FROM `sym_fields_input` WHERE `field_id` = '341' LIMIT 1; [0.0001]
SELECT SQL_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 (); [0.0000]