Notice: eZMySQLiDB::query(1 rows, 0.588 ms) query number per page:0 May 10 2009 19:51:48
SELECT data, user_id, user_hash, expiration_time FROM ezsession WHERE session_key='495b58aa3421b18bcf00ec4e719c976e'
Notice: eZMySQLiDB::query(1 rows, 0.090 ms) query number per page:1 May 10 2009 19:51:48
SELECT id, name, locale, disabled
FROM ezcontent_language
ORDER BY name ASC
Notice: eZMySQLiDB::query(0 rows, 0.122 ms) query number per page:2 May 10 2009 19:51:48
SELECT e0.id AS e0_id, e0.link AS e0_link, e0.text AS e0_text, e0.text_md5 AS e0_text_md5, e0.is_alias AS e0_is_alias, e0.alias_redirects AS e0_alias_redirects, e1.id AS e1_id, e1.link AS e1_link, e1.text AS e1_text, e1.text_md5 AS e1_text_md5, e1.is_alias AS e1_is_alias, e1.alias_redirects AS e1_alias_redirects, e2.id AS e2_id, e2.link AS e2_link, e2.text AS e2_text, e2.text_md5 AS e2_text_md5, e2.is_alias AS e2_is_alias, e2.alias_redirects AS e2_alias_redirects, e3.id AS e3_id, e3.link AS e3_link, e3.text AS e3_text, e3.text_md5 AS e3_text_md5, e3.is_alias AS e3_is_alias, e3.alias_redirects AS e3_alias_redirects, e4.id AS e4_id, e4.link AS e4_link, e4.text AS e4_text, e4.text_md5 AS e4_text_md5, e4.is_alias AS e4_is_alias, e4.action AS e4_action, e4.alias_redirects AS e4_alias_redirects
FROM ezurlalias_ml e0, ezurlalias_ml e1, ezurlalias_ml e2, ezurlalias_ml e3, ezurlalias_ml e4
WHERE e0.parent = 0 AND (e0.lang_mask & 3 > 0) AND e0.text_md5 = MD5( 'content' )
AND e1.parent = e0.link AND (e1.lang_mask & 3 > 0) AND e1.text_md5 = MD5( 'edit' )
AND e2.parent = e1.link AND (e2.lang_mask & 3 > 0) AND e2.text_md5 = MD5( '13106' )
AND e3.parent = e2.link AND (e3.lang_mask & 3 > 0) AND e3.text_md5 = MD5( '6' )
AND e4.parent = e3.link AND (e4.lang_mask & 3 > 0) AND e4.text_md5 = MD5( 'ger-de' )
LIMIT 0, 1
Timing: May 10 2009 19:51:48
Module start 'content'
Notice: eZMySQLiDB::query(1 rows, 0.116 ms) query number per page:3 May 10 2009 19:51:48
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='13106' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0
Notice: eZMySQLiDB::query(1 rows, 0.091 ms) query number per page:4 May 10 2009 19:51:48
SELECT id, version, serialized_name_list, identifier, contentobject_name, url_alias_name, creator_id,
modifier_id, created, remote_id, modified, is_container, always_available, language_mask,
initial_language_id, sort_field, sort_order
FROM ezcontentclass
WHERE id='1' AND version='0'
ORDER BY version ASC
LIMIT 0, 2
Notice: eZMySQLiDB::query(1 rows, 0.085 ms) query number per page:5 May 10 2009 19:51:48
SELECT id, contentobject_id, creator_id, version, status, created, modified,
workflow_event_pos, user_id, language_mask, initial_language_id
FROM ezcontentobject_version
WHERE version='6' AND contentobject_id='13106'
ORDER BY version ASC
Notice: eZMySQLiDB::query(1 rows, 0.080 ms) query number per page:6 May 10 2009 19:51:48
SELECT id, contentobject_id, creator_id, version, status, created, modified,
workflow_event_pos, user_id, language_mask, initial_language_id
FROM ezcontentobject_version
WHERE version='6' AND contentobject_id='13106'
ORDER BY version ASC
Notice: eZMySQLiDB::query(2 rows, 0.070 ms) query number per page:7 May 10 2009 19:51:48
SELECT contentobject_state_id, group_id FROM ezcobj_state_link, ezcobj_state
WHERE ezcobj_state.id=ezcobj_state_link.contentobject_state_id AND
contentobject_id=13106
Notice: eZMySQLiDB::query(7 rows, 0.110 ms) query number per page:8 May 10 2009 19:51:48
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as classattribute_identifier,
ezcontentclass_attribute.can_translate, ezcontentclass_attribute.serialized_name_list as attribute_serialized_name_list
FROM ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_attribute.version = '6' AND
ezcontentobject_attribute.contentobject_id = '13106' AND
ezcontentobject_version.contentobject_id = '13106' AND
ezcontentobject_version.version = '6' AND ezcontentobject_attribute.language_code = 'ger-DE' ORDER by
ezcontentclass_attribute.placement ASC
Notice: eZMySQLiDB::query(1 rows, 0.101 ms) query number per page:9 May 10 2009 19:51:48
SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id, op_code
FROM eznode_assignment
WHERE contentobject_id='13106' AND contentobject_version='6'
Notice: eZMySQLiDB::query(1 rows, 0.119 ms) query number per page:10 May 10 2009 19:51:48
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE contentobject_id=13106 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
ORDER BY path_string
Notice: eZMySQLiDB::query(1 rows, 0.111 ms) query number per page:11 May 10 2009 19:51:48
SELECT id, serialized_name_list, version, contentclass_id, identifier, placement, is_searchable,
is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3,
data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2,
data_text3, data_text4, data_text5
FROM ezcontentclass_attribute
WHERE id='4' AND version='0'
Notice: eZMySQLiDB::query(1 rows, 0.169 ms) query number per page:12 May 10 2009 19:51:48
SELECT id, serialized_name_list, version, contentclass_id, identifier, placement, is_searchable,
is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3,
data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2,
data_text3, data_text4, data_text5
FROM ezcontentclass_attribute
WHERE id='266' AND version='0'
Notice: eZMySQLiDB::query(1 rows, 0.106 ms) query number per page:13 May 10 2009 19:51:48
SELECT id, serialized_name_list, version, contentclass_id, identifier, placement, is_searchable,
is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3,
data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2,
data_text3, data_text4, data_text5
FROM ezcontentclass_attribute
WHERE id='119' AND version='0'
Notice: eZMySQLiDB::query(1 rows, 0.099 ms) query number per page:14 May 10 2009 19:51:48
SELECT id, serialized_name_list, version, contentclass_id, identifier, placement, is_searchable,
is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3,
data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2,
data_text3, data_text4, data_text5
FROM ezcontentclass_attribute
WHERE id='210' AND version='0'
Notice: eZMySQLiDB::query(1 rows, 0.093 ms) query number per page:15 May 10 2009 19:51:48
SELECT id, serialized_name_list, version, contentclass_id, identifier, placement, is_searchable,
is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3,
data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2,
data_text3, data_text4, data_text5
FROM ezcontentclass_attribute
WHERE id='211' AND version='0'
Notice: eZMySQLiDB::query(1 rows, 0.091 ms) query number per page:16 May 10 2009 19:51:48
SELECT id, serialized_name_list, version, contentclass_id, identifier, placement, is_searchable,
is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3,
data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2,
data_text3, data_text4, data_text5
FROM ezcontentclass_attribute
WHERE id='248' AND version='0'
Notice: eZMySQLiDB::query(1 rows, 0.092 ms) query number per page:17 May 10 2009 19:51:48
SELECT id, serialized_name_list, version, contentclass_id, identifier, placement, is_searchable,
is_required, can_translate, is_information_collector, data_type_string, data_int1, data_int2, data_int3,
data_int4, data_float1, data_float2, data_float3, data_float4, data_text1, data_text2,
data_text3, data_text4, data_text5
FROM ezcontentclass_attribute
WHERE id='491' AND version='0'
Notice: eZMySQLiDB::query(0 rows, 0.107 ms) query number per page:18 May 10 2009 19:51:48
SELECT
ezcontentclass.serialized_name_list AS class_serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container,
ezcontentobject.* , ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentclass,
ezcontentobject,
ezcontentobject_link
, ezcontentobject_name
WHERE
ezcontentclass.id=ezcontentobject.contentclass_id AND
ezcontentclass.version=0 AND
ezcontentobject.status=1 AND
ezcontentobject_link.op_code='0'
AND ( relation_type & 2 ) <> 0
AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
ezcontentobject_link.from_contentobject_id='13106' AND
ezcontentobject_link.from_contentobject_version='6'
AND ezcontentobject.id = ezcontentobject_name.contentobject_id AND
ezcontentobject.current_version = ezcontentobject_name.content_version AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
Notice: eZMySQLiDB::query(0 rows, 0.104 ms) query number per page:19 May 10 2009 19:51:48
SELECT
ezcontentclass.serialized_name_list AS class_serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container,
ezcontentobject.* , ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentclass,
ezcontentobject,
ezcontentobject_link
, ezcontentobject_name
WHERE
ezcontentclass.id=ezcontentobject.contentclass_id AND
ezcontentclass.version=0 AND
ezcontentobject.status=1 AND
ezcontentobject_link.op_code='0'
AND ( relation_type & 4 ) <> 0
AND ezcontentobject.id=ezcontentobject_link.to_contentobject_id AND
ezcontentobject_link.from_contentobject_id='13106' AND
ezcontentobject_link.from_contentobject_version='6'
AND ezcontentobject.id = ezcontentobject_name.contentobject_id AND
ezcontentobject.current_version = ezcontentobject_name.content_version AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
Notice: eZMySQLiDB::query(7 rows, 1.295 ms) query number per page:20 May 10 2009 19:51:48
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_version.contentobject_id = '13106' AND
ezcontentobject_version.version = '4' AND
ezcontentobject_attribute.contentobject_id = '13106' AND
ezcontentobject_attribute.version = '4' AND
ezcontentobject_attribute.language_code = 'ger-DE'
ORDER BY
ezcontentclass_attribute.placement ASC,
ezcontentobject_attribute.language_code ASC
Notice: on master : eZMySQLiDB::query(0 rows, 0.076 ms) query number per page:21 May 10 2009 19:51:48
BEGIN WORK
Notice: on master : eZMySQLiDB::query(1 rows, 0.197 ms) query number per page:22 May 10 2009 19:51:48
SELECT id
FROM ezcontentobject_version
WHERE id='101743'
Notice: on master : eZMySQLiDB::query(1 rows, 2.080 ms) query number per page:23 May 10 2009 19:51:48
UPDATE ezcontentobject_version
SET contentobject_id=13106, creator_id=14, version=6, status=0,
created=1241977578, modified=1241977906, workflow_event_pos=0, user_id=0,
language_mask=3, initial_language_id=2
WHERE id='101743'
Notice: on master : eZMySQLiDB::query(1 rows, 0.396 ms) query number per page:24 May 10 2009 19:51:48
SELECT id, contentobject_id, version, language_code
FROM ezcontentobject_attribute
WHERE id='193250' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(0 rows, 0.518 ms) query number per page:25 May 10 2009 19:51:48
UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=4,
attribute_original_id=0, sort_key_int=0, sort_key_string='große kaufhäuser',
data_type_string='ezstring', data_text='Große Kaufhäuser', data_int=0, data_float=0.000000
WHERE id='193250' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(1 rows, 0.149 ms) query number per page:26 May 10 2009 19:51:48
SELECT id, contentobject_id, version, language_code
FROM ezcontentobject_attribute
WHERE id='193251' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(0 rows, 0.216 ms) query number per page:27 May 10 2009 19:51:48
UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=266,
attribute_original_id=0, sort_key_int=0, sort_key_string='', data_type_string='ezstring',
data_text='', data_int=0, data_float=0.000000
WHERE id='193251' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(1 rows, 0.150 ms) query number per page:28 May 10 2009 19:51:48
SELECT id, contentobject_id, version, language_code
FROM ezcontentobject_attribute
WHERE id='193252' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(0 rows, 0.249 ms) query number per page:29 May 10 2009 19:51:48
UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=119,
attribute_original_id=0, sort_key_int=0, sort_key_string='', data_type_string='ezxmltext',
data_text='\nGroße Kauf- und Versandhäuser, die Produkte aus vielen verschiedenen Kategorien anbieten.\n', data_int=1045487555, data_float=0.000000
WHERE id='193252' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(1 rows, 0.153 ms) query number per page:30 May 10 2009 19:51:48
SELECT id, contentobject_id, version, language_code
FROM ezcontentobject_attribute
WHERE id='193253' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(0 rows, 0.263 ms) query number per page:31 May 10 2009 19:51:48
UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=210,
attribute_original_id=0, sort_key_int=0, sort_key_string='', data_type_string='ezimage',
data_text='\n\n', data_int=0, data_float=0.000000
WHERE id='193253' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(1 rows, 0.146 ms) query number per page:32 May 10 2009 19:51:48
SELECT id, contentobject_id, version, language_code
FROM ezcontentobject_attribute
WHERE id='193253' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(0 rows, 0.290 ms) query number per page:33 May 10 2009 19:51:48
UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=210,
attribute_original_id=0, sort_key_int=0, sort_key_string='', data_type_string='ezimage',
data_text='\n\n', data_int=0, data_float=0.000000
WHERE id='193253' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(1 rows, 0.169 ms) query number per page:34 May 10 2009 19:51:48
SELECT id, contentobject_id, version, language_code
FROM ezcontentobject_attribute
WHERE id='193254' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(0 rows, 0.215 ms) query number per page:35 May 10 2009 19:51:48
UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=211,
attribute_original_id=0, sort_key_int=0, sort_key_string='', data_type_string='ezboolean',
data_text='', data_int=0, data_float=0.000000
WHERE id='193254' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(1 rows, 0.101 ms) query number per page:36 May 10 2009 19:51:48
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='13106' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0
Notice: on master : eZMySQLiDB::query(1 rows, 0.217 ms) query number per page:37 May 10 2009 19:51:48
SELECT DISTINCT language_code
FROM ezcontentobject_attribute
WHERE contentobject_id='13106' AND version='6'
ORDER BY language_code
Notice: on master : eZMySQLiDB::query(0 rows, 0.140 ms) query number per page:38 May 10 2009 19:51:48
DELETE FROM ezcontentobject_link
WHERE from_contentobject_id=13106 AND
from_contentobject_version=6 AND contentclassattribute_id=248 AND
op_code='0'
Notice: on master : eZMySQLiDB::query(1 rows, 0.150 ms) query number per page:39 May 10 2009 19:51:48
SELECT id, contentobject_id, version, language_code
FROM ezcontentobject_attribute
WHERE id='193255' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(0 rows, 0.219 ms) query number per page:40 May 10 2009 19:51:48
UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=248,
attribute_original_id=0, sort_key_int=0, sort_key_string='',
data_type_string='ezobjectrelation', data_text='', data_int=0, data_float=0.000000
WHERE id='193255' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(1 rows, 0.093 ms) query number per page:41 May 10 2009 19:51:48
SELECT ezcontentobject.*,
ezcontentclass.serialized_name_list as serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container
FROM
ezcontentobject,
ezcontentclass
WHERE
ezcontentobject.id='13106' AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentclass.version=0
Notice: on master : eZMySQLiDB::query(10 rows, 0.086 ms) query number per page:42 May 10 2009 19:51:48
SELECT * FROM ezkeyword WHERE keyword IN ( 'Katalog','Marken','Mode','Online Shop','Shop','Technik','Versand','Versandhaus','Versandhäuser','Wäsche' ) AND class_id='1'
Notice: on master : eZMySQLiDB::query(10 rows, 0.107 ms) query number per page:43 May 10 2009 19:51:48
SELECT ezkeyword.id, ezkeyword.keyword FROM ezkeyword, ezkeyword_attribute_link
WHERE ezkeyword.id=ezkeyword_attribute_link.keyword_id
AND ezkeyword_attribute_link.objectattribute_id='618797'
Notice: on master : eZMySQLiDB::query(0 rows, 0.056 ms) query number per page:44 May 10 2009 19:51:48
SELECT ezkeyword.id FROM ezkeyword LEFT JOIN ezkeyword_attribute_link ON ezkeyword.id=ezkeyword_attribute_link.keyword_id WHERE ezkeyword_attribute_link.keyword_id IS NULL
Notice: on master : eZMySQLiDB::query(1 rows, 0.295 ms) query number per page:45 May 10 2009 19:51:48
SELECT id, contentobject_id, version, language_code
FROM ezcontentobject_attribute
WHERE id='618797' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(0 rows, 0.418 ms) query number per page:46 May 10 2009 19:51:48
UPDATE ezcontentobject_attribute
SET language_id=2, contentclassattribute_id=491,
attribute_original_id=0, sort_key_int=0, sort_key_string='', data_type_string='ezkeyword',
data_text='', data_int=NULL, data_float=0.000000
WHERE id='618797' AND contentobject_id='13106' AND version='6' AND language_code='ger-DE'
Notice: on master : eZMySQLiDB::query(0 rows, 363.169 ms) query number per page:47 May 10 2009 19:51:48
COMMIT
Notice: on master : eZMySQLiDB::query(0 rows, 0.131 ms) query number per page:48 May 10 2009 19:51:48
BEGIN WORK
Notice: on master : eZMySQLiDB::query(1 rows, 0.798 ms) query number per page:49 May 10 2009 19:51:48
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier
FROM ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = 0 AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_version.contentobject_id = 13106 AND
ezcontentobject_version.version = 6 AND
ezcontentobject_attribute.contentobject_id = 13106
AND
ezcontentobject_attribute.language_code IN ( 'ger-DE' )
AND
ezcontentobject_attribute.version = '6'
AND
identifier IN ( 'name' )
Notice: on master : eZMySQLiDB::query(1 rows, 0.174 ms) query number per page:50 May 10 2009 19:51:48
SELECT COUNT(*) AS count FROM ezcontentobject_name WHERE contentobject_id = '13106'
AND content_version = '6' AND content_translation ='ger-DE'
Notice: on master : eZMySQLiDB::query(0 rows, 0.180 ms) query number per page:51 May 10 2009 19:51:48
UPDATE ezcontentobject_name SET name='Große Kaufhäuser'
WHERE
contentobject_id = '13106' AND
content_version = '6' AND
content_translation ='ger-DE'
Notice: on master : eZMySQLiDB::query(0 rows, 0.064 ms) query number per page:52 May 10 2009 19:51:48
COMMIT
Notice: eZMySQLiDB::query(1 rows, 0.084 ms) query number per page:53 May 10 2009 19:51:48
SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id, op_code
FROM eznode_assignment
WHERE contentobject_id='13106' AND contentobject_version='6'
Notice: on master : eZMySQLiDB::query(0 rows, 0.057 ms) query number per page:54 May 10 2009 19:51:48
BEGIN WORK
Notice: on master : eZMySQLiDB::query(1 rows, 0.135 ms) query number per page:55 May 10 2009 19:51:48
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 13369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
Notice: on master : eZMySQLiDB::query(0 rows, 0.059 ms) query number per page:56 May 10 2009 19:51:48
COMMIT
Notice: eZMySQLiDB::query(1 rows, 0.402 ms) query number per page:57 May 10 2009 19:51:48
SELECT id, contentobject_id, creator_id, version, status, created, modified,
workflow_event_pos, user_id, language_mask, initial_language_id
FROM ezcontentobject_version
WHERE contentobject_id='13106' AND status IN ( '1', '3' ) AND initial_language_id='2'
ORDER BY version ASC
Notice: eZMySQLiDB::query(1 rows, 0.074 ms) query number per page:58 May 10 2009 19:51:48
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '13106'
AND content_version = '4'
AND ( content_translation = 'ger-DE' OR language_id = '2' )
Notice: on master : eZMySQLiDB::query(0 rows, 0.057 ms) query number per page:59 May 10 2009 19:51:48
BEGIN WORK
Notice: on master : eZMySQLiDB::query(0 rows, 0.076 ms) query number per page:60 May 10 2009 19:51:48
SELECT id, main, memento_key, main_key, memento_data
FROM ezoperation_memento
WHERE memento_key='b4fcbeb96b8d42a363c93a336bdce543' AND main='1'
Notice: on master : eZMySQLiDB::query(0 rows, 0.071 ms) query number per page:61 May 10 2009 19:51:48
SELECT id, main, memento_key, main_key, memento_data
FROM ezoperation_memento
WHERE memento_key='b4fcbeb96b8d42a363c93a336bdce543' AND main='0'
Notice: on master : eZMySQLiDB::query(1 rows, 0.147 ms) query number per page:62 May 10 2009 19:51:48
SELECT id
FROM ezcontentobject_version
WHERE id='101743'
Notice: on master : eZMySQLiDB::query(1 rows, 0.224 ms) query number per page:63 May 10 2009 19:51:48
UPDATE ezcontentobject_version
SET contentobject_id=13106, creator_id=14, version=6, status=2,
created=1241977578, modified=1241977906, workflow_event_pos=0, user_id=0,
language_mask=3, initial_language_id=2
WHERE id='101743'
Notice: on master : eZMySQLiDB::query(1 rows, 0.085 ms) query number per page:64 May 10 2009 19:51:48
SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id, op_code
FROM eznode_assignment
WHERE contentobject_id='13106' AND contentobject_version='6' AND is_main='1'
Notice: on master : eZMySQLiDB::query(1 rows, 0.304 ms) query number per page:65 May 10 2009 19:51:48
SELECT id, contentobject_id, creator_id, version, status, created, modified,
workflow_event_pos, user_id, language_mask, initial_language_id
FROM ezcontentobject_version
WHERE version='4' AND contentobject_id='13106'
ORDER BY version ASC
Notice: on master : eZMySQLiDB::query(1 rows, 0.116 ms) query number per page:66 May 10 2009 19:51:48
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=13106 AND
ezcontentobject_tree.main_node_id = ezcontentobject_tree.node_id AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
Notice: on master : eZMySQLiDB::query(1 rows, 0.078 ms) query number per page:67 May 10 2009 19:51:48
SELECT id, module_name, function_name, connect_type, workflow_id, name
FROM eztrigger
WHERE name='pre_publish' AND module_name='content' AND function_name='publish'
Notice: on master : eZMySQLiDB::query(1 rows, 0.082 ms) query number per page:68 May 10 2009 19:51:48
SELECT id, version, is_enabled, workflow_type_string, name, creator_id, modifier_id,
created, modified
FROM ezworkflow
WHERE id='3' AND version='0'
Notice: on master : eZMySQLiDB::query(0 rows, 0.350 ms) query number per page:69 May 10 2009 19:51:48
SELECT id, process_key, workflow_id, user_id, content_id, content_version, session_key,
node_id, event_id, event_position, event_state, last_event_id, last_event_position, last_event_status,
event_status, created, modified, activation_date, status, parameters, memento_key
FROM ezworkflow_process
WHERE process_key='124239baa08c59f6af9ad2332b6a8b36'
ORDER BY user_id ASC
Notice: on master : eZMySQLiDB::query(1 rows, 0.264 ms) query number per page:70 May 10 2009 19:51:48
INSERT INTO ezworkflow_process (process_key, workflow_id, user_id, content_id, content_version, session_key, node_id, event_id, event_position, event_state, last_event_id, last_event_position, last_event_status, event_status, created, modified, activation_date, status, parameters, memento_key) VALUES('124239baa08c59f6af9ad2332b6a8b36', 3, 14, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 1241977907, 1241977907, 0, 0, 'a:4:{s:9:\"object_id\";s:5:\"13106\";s:7:\"version\";s:1:\"6\";s:11:\"workflow_id\";s:1:\"3\";s:7:\"user_id\";s:2:\"14\";}', '')
Notice: on master : eZMySQLiDB::query(1 rows, 0.079 ms) query number per page:71 May 10 2009 19:51:48
SELECT id, version, is_enabled, workflow_type_string, name, creator_id, modifier_id,
created, modified
FROM ezworkflow
WHERE id='3' AND version='0'
Notice: on master : eZMySQLiDB::query(0 rows, 0.091 ms) query number per page:72 May 10 2009 19:51:48
SELECT id, version, workflow_id, workflow_type_string, description, data_int1, data_int2,
data_int3, data_int4, data_text1, data_text2, data_text3, data_text4, data_text5,
placement
FROM ezworkflow_event
WHERE id='0' AND version='0'
Notice: on master : eZMySQLiDB::query(1 rows, 0.074 ms) query number per page:73 May 10 2009 19:51:48
SELECT id, placement
FROM ezworkflow_event
WHERE workflow_id='3' AND version='0'
ORDER BY placement ASC
LIMIT 0, 1
Notice: on master : eZMySQLiDB::query(1 rows, 0.088 ms) query number per page:74 May 10 2009 19:51:48
SELECT id, version, workflow_id, workflow_type_string, description, data_int1, data_int2,
data_int3, data_int4, data_text1, data_text2, data_text3, data_text4, data_text5,
placement
FROM ezworkflow_event
WHERE id='3' AND version='0'
Notice: on master : eZMySQLiDB::query(7 rows, 1.162 ms) query number per page:75 May 10 2009 19:51:48
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as classattribute_identifier,
ezcontentclass_attribute.can_translate, ezcontentclass_attribute.serialized_name_list as attribute_serialized_name_list
FROM ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_attribute.version = '6' AND
ezcontentobject_attribute.contentobject_id = '13106' AND
ezcontentobject_version.contentobject_id = '13106' AND
ezcontentobject_version.version = '6' AND ezcontentobject_attribute.language_code = 'ger-DE' ORDER by
ezcontentclass_attribute.placement ASC
Notice: on master : eZMySQLiDB::query(3 rows, 0.081 ms) query number per page:76 May 10 2009 19:51:48
SELECT id, workflow_event_id, workflow_event_version, contentclass_id, contentclass_attribute_id
FROM ezwaituntildatevalue
WHERE workflow_event_id='3' AND workflow_event_version='0'
ORDER BY id ASC
Notice: on master : eZMySQLiDB::query(0 rows, 0.075 ms) query number per page:77 May 10 2009 19:51:48
SELECT id, placement
FROM ezworkflow_event
WHERE workflow_id='3' AND version='0'
ORDER BY placement ASC
LIMIT 1, 1
Notice: on master : eZMySQLiDB::query(1 rows, 0.123 ms) query number per page:78 May 10 2009 19:51:48
SELECT id
FROM ezworkflow_process
WHERE id='1096'
Notice: on master : eZMySQLiDB::query(1 rows, 0.182 ms) query number per page:79 May 10 2009 19:51:48
UPDATE ezworkflow_process
SET process_key='124239baa08c59f6af9ad2332b6a8b36', workflow_id=3,
user_id=14, content_id=0, content_version=0, session_key='0', node_id=0,
event_id=0, event_position=0, event_state=0, last_event_id=3,
last_event_position=1, last_event_status=0, event_status=1, created=1241977907,
modified=1241977907, activation_date=0, status=2,
parameters='a:4:{s:9:\"object_id\";s:5:\"13106\";s:7:\"version\";s:1:\"6\";s:11:\"workflow_id\";s:1:\"3\";s:7:\"user_id\";s:2:\"14\";}', memento_key=''
WHERE id='1096'
Notice: on master : eZMySQLiDB::query(1 rows, 0.123 ms) query number per page:80 May 10 2009 19:51:48
DELETE FROM ezworkflow_process
WHERE id='1096'
Notice: on master : eZMySQLiDB::query(1 rows, 0.276 ms) query number per page:81 May 10 2009 19:51:48
SELECT id, contentobject_id, creator_id, version, status, created, modified,
workflow_event_pos, user_id, language_mask, initial_language_id
FROM ezcontentobject_version
WHERE version='4' AND contentobject_id='13106'
ORDER BY version ASC
Notice: on master : eZMySQLiDB::query(1 rows, 0.212 ms) query number per page:82 May 10 2009 19:51:48
SELECT DISTINCT language_code
FROM ezcontentobject_attribute
WHERE contentobject_id='13106' AND version='4'
ORDER BY language_code
Notice: on master : eZMySQLiDB::query(1 rows, 0.072 ms) query number per page:83 May 10 2009 19:51:48
SELECT DISTINCT language_code
FROM ezcontentobject_attribute
WHERE contentobject_id='13106' AND version='6'
ORDER BY language_code
Notice: on master : eZMySQLiDB::query(1 rows, 0.069 ms) query number per page:84 May 10 2009 19:51:48
SELECT DISTINCT language_code
FROM ezcontentobject_attribute
WHERE contentobject_id='13106' AND version='6'
ORDER BY language_code
Notice: on master : eZMySQLiDB::query(1 rows, 0.121 ms) query number per page:85 May 10 2009 19:51:48
SELECT id
FROM ezcontentobject_version
WHERE id='101743'
Notice: on master : eZMySQLiDB::query(0 rows, 0.122 ms) query number per page:86 May 10 2009 19:51:48
UPDATE ezcontentobject_version
SET contentobject_id=13106, creator_id=14, version=6, status=2,
created=1241977578, modified=1241977906, workflow_event_pos=0, user_id=0,
language_mask=3, initial_language_id=2
WHERE id='101743'
Notice: on master : eZMySQLiDB::query(1 rows, 0.112 ms) query number per page:87 May 10 2009 19:51:48
SELECT id
FROM ezcontentobject_version
WHERE id='50148'
Notice: on master : eZMySQLiDB::query(1 rows, 0.653 ms) query number per page:88 May 10 2009 19:51:48
UPDATE ezcontentobject_version
SET contentobject_id=13106, creator_id=14, version=4, status=3,
created=1117711589, modified=1117711589, workflow_event_pos=0, user_id=0,
language_mask=2, initial_language_id=2
WHERE id='50148'
Notice: on master : eZMySQLiDB::query(1 rows, 0.084 ms) query number per page:89 May 10 2009 19:51:48
SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id, op_code
FROM eznode_assignment
WHERE contentobject_id='13106' AND contentobject_version='6'
Notice: on master : eZMySQLiDB::query(1 rows, 0.463 ms) query number per page:90 May 10 2009 19:51:48
SELECT id, remote_id, contentobject_id, contentobject_version, parent_node, sort_field, sort_order,
is_main, from_node_id, parent_remote_id, op_code
FROM eznode_assignment
WHERE contentobject_id='13106' AND contentobject_version='6' AND parent_node='13369'
Notice: on master : eZMySQLiDB::query(1 rows, 0.138 ms) query number per page:91 May 10 2009 19:51:48
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 13369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
Notice: on master : eZMySQLiDB::query(1 rows, 0.574 ms) query number per page:92 May 10 2009 19:51:48
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE parent_node_id = 13369 AND
contentobject_id = 13106 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
Notice: on master : eZMySQLiDB::query(1 rows, 0.117 ms) query number per page:93 May 10 2009 19:51:48
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=13106 AND
ezcontentobject_tree.main_node_id = ezcontentobject_tree.node_id AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
Notice: on master : eZMySQLiDB::query(1 rows, 0.131 ms) query number per page:94 May 10 2009 19:51:48
SELECT id
FROM ezcontentobject_version
WHERE id='101743'
Notice: on master : eZMySQLiDB::query(1 rows, 0.162 ms) query number per page:95 May 10 2009 19:51:48
UPDATE ezcontentobject_version
SET contentobject_id=13106, creator_id=14, version=6, status=1,
created=1241977578, modified=1241977906, workflow_event_pos=0, user_id=0,
language_mask=3, initial_language_id=2
WHERE id='101743'
Notice: on master : eZMySQLiDB::query(0 rows, 0.082 ms) query number per page:96 May 10 2009 19:51:48
SELECT to_contentobject_id, relation_type FROM ezcontentobject_link
WHERE contentclassattribute_id='0'
AND from_contentobject_id='13106'
AND from_contentobject_version='4'
AND op_code='0'
Notice: on master : eZMySQLiDB::query(0 rows, 0.073 ms) query number per page:97 May 10 2009 19:51:48
SELECT to_contentobject_id, op_code, relation_type FROM ezcontentobject_link
WHERE contentclassattribute_id='0'
AND from_contentobject_id='13106'
AND from_contentobject_version='6'
AND op_code!='0'
ORDER BY id ASC
Notice: on master : eZMySQLiDB::query(0 rows, 0.121 ms) query number per page:98 May 10 2009 19:51:48
DELETE FROM ezcontentobject_link
WHERE contentclassattribute_id='0'
AND from_contentobject_id='13106'
AND from_contentobject_version='6'
Notice: on master : eZMySQLiDB::query(1 rows, 0.072 ms) query number per page:99 May 10 2009 19:51:48
SELECT DISTINCT language_code
FROM ezcontentobject_attribute
WHERE contentobject_id='13106' AND version='6'
ORDER BY language_code
Notice: on master : eZMySQLiDB::query(1 rows, 0.470 ms) query number per page:100 May 10 2009 19:51:48
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier
FROM ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = 0 AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_version.contentobject_id = 13106 AND
ezcontentobject_version.version = 6 AND
ezcontentobject_attribute.contentobject_id = 13106
AND
( ezcontentobject_attribute.language_id & ezcontentobject_version.language_mask > 0 AND
( ( ezcontentobject_version.language_mask - ( ezcontentobject_version.language_mask & ezcontentobject_attribute.language_id ) ) & 1 )
+ ( ( ( ezcontentobject_version.language_mask - ( ezcontentobject_version.language_mask & ezcontentobject_attribute.language_id ) ) & 2 ) )
<
( ezcontentobject_attribute.language_id & 1 )
+ ( ( ezcontentobject_attribute.language_id & 2 ) )
)
AND
ezcontentobject_attribute.version = '6'
AND
identifier IN ( 'name' )
Notice: on master : eZMySQLiDB::query(1 rows, 0.071 ms) query number per page:101 May 10 2009 19:51:48
SELECT COUNT(*) AS count FROM ezcontentobject_name WHERE contentobject_id = '13106'
AND content_version = '6' AND content_translation ='ger-DE'
Notice: on master : eZMySQLiDB::query(0 rows, 0.184 ms) query number per page:102 May 10 2009 19:51:48
UPDATE ezcontentobject_name SET name='Große Kaufhäuser'
WHERE
contentobject_id = '13106' AND
content_version = '6' AND
content_translation ='ger-DE'
Notice: on master : eZMySQLiDB::query(1 rows, 0.083 ms) query number per page:103 May 10 2009 19:51:48
SELECT DISTINCT language_code
FROM ezcontentobject_attribute
WHERE contentobject_id='13106' AND version='6'
ORDER BY language_code
Notice: on master : eZMySQLiDB::query(1 rows, 0.435 ms) query number per page:104 May 10 2009 19:51:48
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier
FROM ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = 0 AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_version.contentobject_id = 13106 AND
ezcontentobject_version.version = 6 AND
ezcontentobject_attribute.contentobject_id = 13106
AND
ezcontentobject_attribute.language_code IN ( 'ger-DE' )
AND
ezcontentobject_attribute.version = '6'
AND
identifier IN ( 'name' )
Notice: on master : eZMySQLiDB::query(1 rows, 0.142 ms) query number per page:105 May 10 2009 19:51:48
SELECT COUNT(*) AS count FROM ezcontentobject_name WHERE contentobject_id = '13106'
AND content_version = '6' AND content_translation ='ger-DE'
Notice: on master : eZMySQLiDB::query(0 rows, 0.150 ms) query number per page:106 May 10 2009 19:51:48
UPDATE ezcontentobject_name SET name='Große Kaufhäuser'
WHERE
contentobject_id = '13106' AND
content_version = '6' AND
content_translation ='ger-DE'
Notice: on master : eZMySQLiDB::query(1 rows, 0.131 ms) query number per page:107 May 10 2009 19:51:48
SELECT id
FROM ezcontentobject_version
WHERE id='101743'
Notice: on master : eZMySQLiDB::query(0 rows, 0.130 ms) query number per page:108 May 10 2009 19:51:48
UPDATE ezcontentobject_version
SET contentobject_id=13106, creator_id=14, version=6, status=1,
created=1241977578, modified=1241977906, workflow_event_pos=0, user_id=0,
language_mask=3, initial_language_id=2
WHERE id='101743'
Notice: on master : eZMySQLiDB::query(1 rows, 0.371 ms) query number per page:109 May 10 2009 19:51:48
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE contentobject_id=13106 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
ORDER BY path_string
Notice: on master : eZMySQLiDB::query(6 rows, 2.481 ms) query number per page:110 May 10 2009 19:51:48
UPDATE ezcontentobject_tree SET modified_subnode=1241977907 WHERE node_id='1' OR node_id='2' OR node_id='13200' OR node_id='13185' OR node_id='13369' OR node_id='13375'
Notice: on master : eZMySQLiDB::query(1 rows, 0.376 ms) query number per page:111 May 10 2009 19:51:48
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '13106'
AND content_version = '6'
AND ( content_translation = 'ger-DE' OR language_id = '2' )
Notice: on master : eZMySQLiDB::query(1 rows, 0.154 ms) query number per page:112 May 10 2009 19:51:48
SELECT id
FROM ezcontentobject
WHERE id='13106'
Notice: on master : eZMySQLiDB::query(1 rows, 0.242 ms) query number per page:113 May 10 2009 19:51:48
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '13106'
AND content_version = '6'
AND ( content_translation = 'ger-DE' OR language_id = '2' )
Notice: on master : eZMySQLiDB::query(1 rows, 1.991 ms) query number per page:114 May 10 2009 19:51:48
UPDATE ezcontentobject
SET section_id=47, owner_id=14, contentclass_id=1,
name='Große Kaufhäuser', is_published=0, published=1071633798, modified=1241977907,
current_version=6, status=1, remote_id='kuh_link_category_142', language_mask=2,
initial_language_id=2
WHERE id='13106'
Notice: on master : eZMySQLiDB::query(1 rows, 0.145 ms) query number per page:115 May 10 2009 19:51:48
UPDATE ezcontentobject_tree SET contentobject_version='6' WHERE contentobject_id='13106'
Notice: on master : eZMySQLiDB::query(1 rows, 0.412 ms) query number per page:116 May 10 2009 19:51:48
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE contentobject_id=13106 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
ORDER BY path_string
Notice: on master : eZMySQLiDB::query(1 rows, 0.197 ms) query number per page:117 May 10 2009 19:51:48
SELECT name, content_translation
FROM ezcontentobject_name
WHERE contentobject_id = '13106'
AND content_version = '6'
AND ( content_translation = 'ger-DE' OR language_id = '2' )
Notice: on master : eZMySQLiDB::query(1 rows, 0.484 ms) query number per page:118 May 10 2009 19:51:48
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier
FROM ezcontentobject_attribute, ezcontentclass_attribute, ezcontentobject_version
WHERE
ezcontentclass_attribute.version = 0 AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
ezcontentobject_version.contentobject_id = 13106 AND
ezcontentobject_version.version = 6 AND
ezcontentobject_attribute.contentobject_id = 13106
AND
ezcontentobject_attribute.language_code IN ( 'ger-DE' )
AND
ezcontentobject_attribute.version = '6'
AND
identifier IN ( 'name' )
Notice: on master : eZMySQLiDB::query(1 rows, 0.630 ms) query number per page:119 May 10 2009 19:51:48
SELECT * FROM ezurlalias_ml WHERE action = 'eznode:13375' AND is_original = 1 AND is_alias = 0
Notice: on master : eZMySQLiDB::query(0 rows, 0.223 ms) query number per page:120 May 10 2009 19:51:48
SELECT * FROM ezurlalias_ml WHERE parent = 79 AND action != 'eznode:13375' AND text_md5 = MD5( 'grosse-kaufhaeuser' ) AND is_original = 1
Notice: on master : eZMySQLiDB::query(1 rows, 0.131 ms) query number per page:121 May 10 2009 19:51:48
SELECT * FROM ezurlalias_ml WHERE action = 'eznode:13375' AND is_original = 1 AND is_alias = 0
Notice: on master : eZMySQLiDB::query(1 rows, 0.686 ms) query number per page:122 May 10 2009 19:51:48
SELECT * FROM ezurlalias_ml WHERE action = 'eznode:13369' AND is_original = 1 AND is_alias = 0
Notice: on master : eZMySQLiDB::query(1 rows, 0.570 ms) query number per page:123 May 10 2009 19:51:48
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.serialized_name_list as class_serialized_name_list,
ezcontentclass.identifier as class_identifier,
ezcontentclass.is_container as is_container
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
, ezcontentobject_name
WHERE node_id = 13369 AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
AND
ezcontentobject.language_mask & 3 > 0
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
Notice: on master : eZMySQLiDB::query(1 rows, 0.157 ms) query number per page:124 May 10 2009 19:51:48
SELECT text, parent FROM ezurlalias_ml WHERE id = 79
Notice: on master : eZMySQLiDB::query(1 rows, 0.227 ms) query number per page:125 May 10 2009 19:51:48
SELECT * FROM ezurlalias_ml WHERE parent = 79 AND text_md5 = MD5( 'grosse-kaufhaeuser' )
Notice: on master : eZMySQLiDB::query(1 rows, 1.604 ms) query number per page:126 May 10 2009 19:51:48
SELECT * FROM ezurlalias_ml
WHERE parent = 79 AND action = 'eznode:13375' AND is_original = 1 AND is_alias = 0
Notice: on master : eZMySQLiDB::query(0 rows, 0.909 ms) query number per page:127 May 10 2009 19:51:48
UPDATE ezurlalias_ml SET link = id, lang_mask = cast( cast(lang_mask & -2 AS SIGNED ) | 2 AS SIGNED ) , text = 'Grosse-Kaufhaeuser', action = 'eznode:13375', action_type = 'eznode', is_alias = 0, is_original = 1
WHERE parent = 79 AND text_md5 = MD5( 'grosse-kaufhaeuser' )
Notice: on master : eZMySQLiDB::query(0 rows, 0.604 ms) query number per page:128 May 10 2009 19:51:48
SELECT * FROM ezurlalias_ml
WHERE action = 'eznode:13375' AND (cast(lang_mask & 2 AS SIGNED ) > 0) AND is_original = 1 AND is_alias = 0 AND (parent != 79 OR text_md5 != MD5( 'grosse-kaufhaeuser' ) )
Notice: on master : eZMySQLiDB::query(0 rows, 0.573 ms) query number per page:129 May 10 2009 19:51:48
SELECT * FROM ezurlalias_ml
WHERE action = 'eznode:13375' AND (cast(lang_mask & 2 AS SIGNED ) > 0) AND is_original = 0 AND (parent != 79 OR text_md5 != MD5( 'grosse-kaufhaeuser' ) )
Notice: on master : eZMySQLiDB::query(0 rows, 0.077 ms) query number per page:130 May 10 2009 19:51:48
SELECT * FROM ezurlalias_ml
WHERE action = 'eznode:13375' AND (cast(lang_mask & 2 AS SIGNED ) > 0) AND is_original = 0 AND (parent != 79 OR text_md5 != MD5( 'grosse-kaufhaeuser' ) )
Notice: on master : eZMySQLiDB::query(0 rows, 1.055 ms) query number per page:131 May 10 2009 19:51:48
UPDATE ezurlalias_ml SET link = 10061, is_alias = 0, is_original = 0
WHERE action = 'eznode:13375' AND is_original = 0 AND is_alias = 0 AND (cast(lang_mask & 2 AS SIGNED ) > 0) AND (parent != 79 OR text_md5 != MD5( 'grosse-kaufhaeuser' ) )
Notice: on master : eZMySQLiDB::query(2 rows, 0.543 ms) query number per page:132 May 10 2009 19:51:48
SELECT id FROM ezurlalias_ml
WHERE action = 'eznode:13375' AND is_alias = 0 AND (parent != 79 OR text_md5 != MD5( 'grosse-kaufhaeuser' ) )
Notice: on master : eZMySQLiDB::query(-1 rows, 0.617 ms) query number per page:133 May 10 2009 19:51:48
UPDATE ezurlalias_ml SET parent = 10061
WHERE parent = 85 AND (cast(lang_mask & 2 AS SIGNED ) > 0)
Error: eZMySQLiDB May 10 2009 19:51:48
Query error: Duplicate entry '10061-26d1967ddb61a27df9e4b614821be419' for key 1. Query: UPDATE ezurlalias_ml SET parent = 10061
WHERE parent = 85 AND (cast(lang_mask & 2 AS SIGNED ) > 0)
Notice: on master : eZMySQLiDB::query(0 rows, 0.056 ms) query number per page:134 May 10 2009 19:51:48
UNLOCK TABLES
Error: eZDBInterface::commit TRANSID-75a5eb3abb2796f876db3677e5eda0a9 May 10 2009 19:51:48
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-75a5eb3abb2796f876db3677e5eda0a9.
Notice: on master : eZMySQLiDB::query(0 rows, 582.101 ms) query number per page:135 May 10 2009 19:51:48
ROLLBACK