SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id) AND (c.version=a.version) LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id) AND (c.version=g.contentclass_version) LEFT JOINezcontentclass_attribute_mlmlON (a.id=ml.contentclass_attribute_id) AND (a.version=ml.version) WHERE (c.identifier=:identifier) AND (c.version=:version) ORDER BYa.placementASC
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id)
AND (c.version=a.version)
LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id)
AND (
c.version=g.contentclass_version
)
LEFT JOINezcontentclass_attribute_mlmlON (
a.id=ml.contentclass_attribute_id
)
AND (a.version=ml.version)
WHERE
(c.identifier=:identifier)
AND (c.version=:version)
ORDER BYa.placementASC
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id) AND (c.version=a.version) LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id) AND (c.version=g.contentclass_version) LEFT JOINezcontentclass_attribute_mlmlON (a.id=ml.contentclass_attribute_id) AND (a.version=ml.version) WHERE (c.identifier='file') AND (c.version=0) ORDER BYa.placementASC;
3
2.47 ms
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id) AND (c.version=a.version) LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id) AND (c.version=g.contentclass_version) LEFT JOINezcontentclass_attribute_mlmlON (a.id=ml.contentclass_attribute_id) AND (a.version=ml.version) WHERE (c.identifier=:identifier) AND (c.version=:version) ORDER BYa.placementASC
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id)
AND (c.version=a.version)
LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id)
AND (
c.version=g.contentclass_version
)
LEFT JOINezcontentclass_attribute_mlmlON (
a.id=ml.contentclass_attribute_id
)
AND (a.version=ml.version)
WHERE
(c.identifier=:identifier)
AND (c.version=:version)
ORDER BYa.placementASC
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id) AND (c.version=a.version) LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id) AND (c.version=g.contentclass_version) LEFT JOINezcontentclass_attribute_mlmlON (a.id=ml.contentclass_attribute_id) AND (a.version=ml.version) WHERE (c.identifier='image') AND (c.version=0) ORDER BYa.placementASC;
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id) AND (c.version=a.version) LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id) AND (c.version=g.contentclass_version) LEFT JOINezcontentclass_attribute_mlmlON (a.id=ml.contentclass_attribute_id) AND (a.version=ml.version) WHERE (g.group_id=:gid) AND (c.version=:version) ORDER BYa.placementASC,c.identifierASC
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id)
AND (c.version=a.version)
LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id)
AND (
c.version=g.contentclass_version
)
LEFT JOINezcontentclass_attribute_mlmlON (
a.id=ml.contentclass_attribute_id
)
AND (a.version=ml.version)
WHERE
(g.group_id=:gid)
AND (c.version=:version)
ORDER BYa.placementASC,c.identifierASC
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id) AND (c.version=a.version) LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id) AND (c.version=g.contentclass_version) LEFT JOINezcontentclass_attribute_mlmlON (a.id=ml.contentclass_attribute_id) AND (a.version=ml.version) WHERE (g.group_id=1) AND (c.version=0) ORDER BYa.placementASC,c.identifierASC;
6
2.32 ms
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id) AND (c.version=a.version) LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id) AND (c.version=g.contentclass_version) LEFT JOINezcontentclass_attribute_mlmlON (a.id=ml.contentclass_attribute_id) AND (a.version=ml.version) WHERE (g.group_id=:gid) AND (c.version=:version) ORDER BYa.placementASC,c.identifierASC
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id)
AND (c.version=a.version)
LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id)
AND (
c.version=g.contentclass_version
)
LEFT JOINezcontentclass_attribute_mlmlON (
a.id=ml.contentclass_attribute_id
)
AND (a.version=ml.version)
WHERE
(g.group_id=:gid)
AND (c.version=:version)
ORDER BYa.placementASC,c.identifierASC
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id) AND (c.version=a.version) LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id) AND (c.version=g.contentclass_version) LEFT JOINezcontentclass_attribute_mlmlON (a.id=ml.contentclass_attribute_id) AND (a.version=ml.version) WHERE (g.group_id=2) AND (c.version=0) ORDER BYa.placementASC,c.identifierASC;
7
3.43 ms
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id) AND (c.version=a.version) LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id) AND (c.version=g.contentclass_version) LEFT JOINezcontentclass_attribute_mlmlON (a.id=ml.contentclass_attribute_id) AND (a.version=ml.version) WHERE (g.group_id=:gid) AND (c.version=:version) ORDER BYa.placementASC,c.identifierASC
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id)
AND (c.version=a.version)
LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id)
AND (
c.version=g.contentclass_version
)
LEFT JOINezcontentclass_attribute_mlmlON (
a.id=ml.contentclass_attribute_id
)
AND (a.version=ml.version)
WHERE
(g.group_id=:gid)
AND (c.version=:version)
ORDER BYa.placementASC,c.identifierASC
SELECTc.idASezcontentclass_id,c.versionASezcontentclass_version,c.serialized_name_listASezcontentclass_serialized_name_list,c.serialized_description_listASezcontentclass_serialized_description_list,c.identifierASezcontentclass_identifier,c.createdASezcontentclass_created,c.modifiedASezcontentclass_modified,c.modifier_idASezcontentclass_modifier_id,c.creator_idASezcontentclass_creator_id,c.remote_idASezcontentclass_remote_id,c.url_alias_nameASezcontentclass_url_alias_name,c.contentobject_nameASezcontentclass_contentobject_name,c.is_containerASezcontentclass_is_container,c.initial_language_idASezcontentclass_initial_language_id,c.always_availableASezcontentclass_always_available,c.sort_fieldASezcontentclass_sort_field,c.sort_orderASezcontentclass_sort_order,c.language_maskASezcontentclass_language_mask,a.idASezcontentclass_attribute_id,a.serialized_name_listASezcontentclass_attribute_serialized_name_list,a.serialized_description_listASezcontentclass_attribute_serialized_description_list,a.identifierASezcontentclass_attribute_identifier,a.categoryASezcontentclass_attribute_category,a.data_type_stringASezcontentclass_attribute_data_type_string,a.can_translateASezcontentclass_attribute_can_translate,a.is_requiredASezcontentclass_attribute_is_required,a.is_information_collectorASezcontentclass_attribute_is_information_collector,a.is_searchableASezcontentclass_attribute_is_searchable,a.is_thumbnailASezcontentclass_attribute_is_thumbnail,a.placementASezcontentclass_attribute_placement,a.data_float1ASezcontentclass_attribute_data_float1,a.data_float2ASezcontentclass_attribute_data_float2,a.data_float3ASezcontentclass_attribute_data_float3,a.data_float4ASezcontentclass_attribute_data_float4,a.data_int1ASezcontentclass_attribute_data_int1,a.data_int2ASezcontentclass_attribute_data_int2,a.data_int3ASezcontentclass_attribute_data_int3,a.data_int4ASezcontentclass_attribute_data_int4,a.data_text1ASezcontentclass_attribute_data_text1,a.data_text2ASezcontentclass_attribute_data_text2,a.data_text3ASezcontentclass_attribute_data_text3,a.data_text4ASezcontentclass_attribute_data_text4,a.data_text5ASezcontentclass_attribute_data_text5,a.serialized_data_textASezcontentclass_attribute_serialized_data_text,g.group_idASezcontentclass_classgroup_group_id,ml.nameASezcontentclass_attribute_multilingual_name,ml.descriptionASezcontentclass_attribute_multilingual_description,ml.language_idASezcontentclass_attribute_multilingual_language_id,ml.data_textASezcontentclass_attribute_multilingual_data_text,ml.data_jsonASezcontentclass_attribute_multilingual_data_jsonFROMezcontentclasscLEFT JOINezcontentclass_attributeaON (c.id=a.contentclass_id) AND (c.version=a.version) LEFT JOINezcontentclass_classgroupgON (c.id=g.contentclass_id) AND (c.version=g.contentclass_version) LEFT JOINezcontentclass_attribute_mlmlON (a.id=ml.contentclass_attribute_id) AND (a.version=ml.version) WHERE (g.group_id=3) AND (c.version=0) ORDER BYa.placementASC,c.identifierASC;
8
5.00 ms
SELECTid,name,user_id,valueFROMezpreferencesWHERE (user_id=:userId) AND (name=:name)