Symfony Profiler

SELECT
  c.id AS ezcontentclass_id,
  c.version AS ezcontentclass_version,
  c.serialized_name_list AS ezcontentclass_serialized_name_list,
  c.serialized_description_list AS ezcontentclass_serialized_description_list,
  c.identifier AS ezcontentclass_identifier,
  c.created AS ezcontentclass_created,
  c.modified AS ezcontentclass_modified,
  c.modifier_id AS ezcontentclass_modifier_id,
  c.creator_id AS ezcontentclass_creator_id,
  c.remote_id AS ezcontentclass_remote_id,
  c.url_alias_name AS ezcontentclass_url_alias_name,
  c.contentobject_name AS ezcontentclass_contentobject_name,
  c.is_container AS ezcontentclass_is_container,
  c.initial_language_id AS ezcontentclass_initial_language_id,
  c.always_available AS ezcontentclass_always_available,
  c.sort_field AS ezcontentclass_sort_field,
  c.sort_order AS ezcontentclass_sort_order,
  c.language_mask AS ezcontentclass_language_mask,
  a.id AS ezcontentclass_attribute_id,
  a.serialized_name_list AS ezcontentclass_attribute_serialized_name_list,
  a.serialized_description_list AS ezcontentclass_attribute_serialized_description_list,
  a.identifier AS ezcontentclass_attribute_identifier,
  a.category AS ezcontentclass_attribute_category,
  a.data_type_string AS ezcontentclass_attribute_data_type_string,
  a.can_translate AS ezcontentclass_attribute_can_translate,
  a.is_required AS ezcontentclass_attribute_is_required,
  a.is_information_collector AS ezcontentclass_attribute_is_information_collector,
  a.is_searchable AS ezcontentclass_attribute_is_searchable,
  a.is_thumbnail AS ezcontentclass_attribute_is_thumbnail,
  a.placement AS ezcontentclass_attribute_placement,
  a.data_float1 AS ezcontentclass_attribute_data_float1,
  a.data_float2 AS ezcontentclass_attribute_data_float2,
  a.data_float3 AS ezcontentclass_attribute_data_float3,
  a.data_float4 AS ezcontentclass_attribute_data_float4,
  a.data_int1 AS ezcontentclass_attribute_data_int1,
  a.data_int2 AS ezcontentclass_attribute_data_int2,
  a.data_int3 AS ezcontentclass_attribute_data_int3,
  a.data_int4 AS ezcontentclass_attribute_data_int4,
  a.data_text1 AS ezcontentclass_attribute_data_text1,
  a.data_text2 AS ezcontentclass_attribute_data_text2,
  a.data_text3 AS ezcontentclass_attribute_data_text3,
  a.data_text4 AS ezcontentclass_attribute_data_text4,
  a.data_text5 AS ezcontentclass_attribute_data_text5,
  a.serialized_data_text AS ezcontentclass_attribute_serialized_data_text,
  g.group_id AS ezcontentclass_classgroup_group_id,
  ml.name AS ezcontentclass_attribute_multilingual_name,
  ml.description AS ezcontentclass_attribute_multilingual_description,
  ml.language_id AS ezcontentclass_attribute_multilingual_language_id,
  ml.data_text AS ezcontentclass_attribute_multilingual_data_text,
  ml.data_json AS ezcontentclass_attribute_multilingual_data_json
FROM
  ezcontentclass c
  LEFT JOIN ezcontentclass_attribute a ON (c.id = a.contentclass_id)
  AND (c.version = a.version)
  LEFT JOIN ezcontentclass_classgroup g ON (c.id = g.contentclass_id)
  AND (
    c.version = g.contentclass_version
  )
  LEFT JOIN ezcontentclass_attribute_ml ml ON (
    a.id = ml.contentclass_attribute_id
  )
  AND (a.version = ml.version)
WHERE
  (c.identifier = :identifier)
  AND (c.version = :version)
ORDER BY
  a.placement ASC

SELECT c.id AS ezcontentclass_id, c.version AS ezcontentclass_version, c.serialized_name_list AS ezcontentclass_serialized_name_list, c.serialized_description_list AS ezcontentclass_serialized_description_list, c.identifier AS ezcontentclass_identifier, c.created AS ezcontentclass_created, c.modified AS ezcontentclass_modified, c.modifier_id AS ezcontentclass_modifier_id, c.creator_id AS ezcontentclass_creator_id, c.remote_id AS ezcontentclass_remote_id, c.url_alias_name AS ezcontentclass_url_alias_name, c.contentobject_name AS ezcontentclass_contentobject_name, c.is_container AS ezcontentclass_is_container, c.initial_language_id AS ezcontentclass_initial_language_id, c.always_available AS ezcontentclass_always_available, c.sort_field AS ezcontentclass_sort_field, c.sort_order AS ezcontentclass_sort_order, c.language_mask AS ezcontentclass_language_mask, a.id AS ezcontentclass_attribute_id, a.serialized_name_list AS ezcontentclass_attribute_serialized_name_list, a.serialized_description_list AS ezcontentclass_attribute_serialized_description_list, a.identifier AS ezcontentclass_attribute_identifier, a.category AS ezcontentclass_attribute_category, a.data_type_string AS ezcontentclass_attribute_data_type_string, a.can_translate AS ezcontentclass_attribute_can_translate, a.is_required AS ezcontentclass_attribute_is_required, a.is_information_collector AS ezcontentclass_attribute_is_information_collector, a.is_searchable AS ezcontentclass_attribute_is_searchable, a.is_thumbnail AS ezcontentclass_attribute_is_thumbnail, a.placement AS ezcontentclass_attribute_placement, a.data_float1 AS ezcontentclass_attribute_data_float1, a.data_float2 AS ezcontentclass_attribute_data_float2, a.data_float3 AS ezcontentclass_attribute_data_float3, a.data_float4 AS ezcontentclass_attribute_data_float4, a.data_int1 AS ezcontentclass_attribute_data_int1, a.data_int2 AS ezcontentclass_attribute_data_int2, a.data_int3 AS ezcontentclass_attribute_data_int3, a.data_int4 AS ezcontentclass_attribute_data_int4, a.data_text1 AS ezcontentclass_attribute_data_text1, a.data_text2 AS ezcontentclass_attribute_data_text2, a.data_text3 AS ezcontentclass_attribute_data_text3, a.data_text4 AS ezcontentclass_attribute_data_text4, a.data_text5 AS ezcontentclass_attribute_data_text5, a.serialized_data_text AS ezcontentclass_attribute_serialized_data_text, g.group_id AS ezcontentclass_classgroup_group_id, ml.name AS ezcontentclass_attribute_multilingual_name, ml.description AS ezcontentclass_attribute_multilingual_description, ml.language_id AS ezcontentclass_attribute_multilingual_language_id, ml.data_text AS ezcontentclass_attribute_multilingual_data_text, ml.data_json AS ezcontentclass_attribute_multilingual_data_json FROM ezcontentclass c LEFT JOIN ezcontentclass_attribute a ON (c.id = a.contentclass_id) AND (c.version = a.version) LEFT JOIN ezcontentclass_classgroup g ON (c.id = g.contentclass_id) AND (c.version = g.contentclass_version) LEFT JOIN ezcontentclass_attribute_ml ml ON (a.id = ml.contentclass_attribute_id) AND (a.version = ml.version) WHERE (c.identifier = 'file') AND (c.version = 0) ORDER BY a.placement ASC;

SELECT
  id,
  name,
  user_id,
  value
FROM
  ezpreferences
WHERE
  (user_id = :userId)
  AND (name = :name)

SELECT id, name, user_id, value FROM ezpreferences WHERE (user_id = :userId) AND (name = :name);

SELECT
  c.id AS ezcontentclass_id,
  c.version AS ezcontentclass_version,
  c.serialized_name_list AS ezcontentclass_serialized_name_list,
  c.serialized_description_list AS ezcontentclass_serialized_description_list,
  c.identifier AS ezcontentclass_identifier,
  c.created AS ezcontentclass_created,
  c.modified AS ezcontentclass_modified,
  c.modifier_id AS ezcontentclass_modifier_id,
  c.creator_id AS ezcontentclass_creator_id,
  c.remote_id AS ezcontentclass_remote_id,
  c.url_alias_name AS ezcontentclass_url_alias_name,
  c.contentobject_name AS ezcontentclass_contentobject_name,
  c.is_container AS ezcontentclass_is_container,
  c.initial_language_id AS ezcontentclass_initial_language_id,
  c.always_available AS ezcontentclass_always_available,
  c.sort_field AS ezcontentclass_sort_field,
  c.sort_order AS ezcontentclass_sort_order,
  c.language_mask AS ezcontentclass_language_mask,
  a.id AS ezcontentclass_attribute_id,
  a.serialized_name_list AS ezcontentclass_attribute_serialized_name_list,
  a.serialized_description_list AS ezcontentclass_attribute_serialized_description_list,
  a.identifier AS ezcontentclass_attribute_identifier,
  a.category AS ezcontentclass_attribute_category,
  a.data_type_string AS ezcontentclass_attribute_data_type_string,
  a.can_translate AS ezcontentclass_attribute_can_translate,
  a.is_required AS ezcontentclass_attribute_is_required,
  a.is_information_collector AS ezcontentclass_attribute_is_information_collector,
  a.is_searchable AS ezcontentclass_attribute_is_searchable,
  a.is_thumbnail AS ezcontentclass_attribute_is_thumbnail,
  a.placement AS ezcontentclass_attribute_placement,
  a.data_float1 AS ezcontentclass_attribute_data_float1,
  a.data_float2 AS ezcontentclass_attribute_data_float2,
  a.data_float3 AS ezcontentclass_attribute_data_float3,
  a.data_float4 AS ezcontentclass_attribute_data_float4,
  a.data_int1 AS ezcontentclass_attribute_data_int1,
  a.data_int2 AS ezcontentclass_attribute_data_int2,
  a.data_int3 AS ezcontentclass_attribute_data_int3,
  a.data_int4 AS ezcontentclass_attribute_data_int4,
  a.data_text1 AS ezcontentclass_attribute_data_text1,
  a.data_text2 AS ezcontentclass_attribute_data_text2,
  a.data_text3 AS ezcontentclass_attribute_data_text3,
  a.data_text4 AS ezcontentclass_attribute_data_text4,
  a.data_text5 AS ezcontentclass_attribute_data_text5,
  a.serialized_data_text AS ezcontentclass_attribute_serialized_data_text,
  g.group_id AS ezcontentclass_classgroup_group_id,
  ml.name AS ezcontentclass_attribute_multilingual_name,
  ml.description AS ezcontentclass_attribute_multilingual_description,
  ml.language_id AS ezcontentclass_attribute_multilingual_language_id,
  ml.data_text AS ezcontentclass_attribute_multilingual_data_text,
  ml.data_json AS ezcontentclass_attribute_multilingual_data_json
FROM
  ezcontentclass c
  LEFT JOIN ezcontentclass_attribute a ON (c.id = a.contentclass_id)
  AND (c.version = a.version)
  LEFT JOIN ezcontentclass_classgroup g ON (c.id = g.contentclass_id)
  AND (
    c.version = g.contentclass_version
  )
  LEFT JOIN ezcontentclass_attribute_ml ml ON (
    a.id = ml.contentclass_attribute_id
  )
  AND (a.version = ml.version)
WHERE
  (g.group_id = :gid)
  AND (c.version = :version)
ORDER BY
  a.placement ASC,
  c.identifier ASC

SELECT c.id AS ezcontentclass_id, c.version AS ezcontentclass_version, c.serialized_name_list AS ezcontentclass_serialized_name_list, c.serialized_description_list AS ezcontentclass_serialized_description_list, c.identifier AS ezcontentclass_identifier, c.created AS ezcontentclass_created, c.modified AS ezcontentclass_modified, c.modifier_id AS ezcontentclass_modifier_id, c.creator_id AS ezcontentclass_creator_id, c.remote_id AS ezcontentclass_remote_id, c.url_alias_name AS ezcontentclass_url_alias_name, c.contentobject_name AS ezcontentclass_contentobject_name, c.is_container AS ezcontentclass_is_container, c.initial_language_id AS ezcontentclass_initial_language_id, c.always_available AS ezcontentclass_always_available, c.sort_field AS ezcontentclass_sort_field, c.sort_order AS ezcontentclass_sort_order, c.language_mask AS ezcontentclass_language_mask, a.id AS ezcontentclass_attribute_id, a.serialized_name_list AS ezcontentclass_attribute_serialized_name_list, a.serialized_description_list AS ezcontentclass_attribute_serialized_description_list, a.identifier AS ezcontentclass_attribute_identifier, a.category AS ezcontentclass_attribute_category, a.data_type_string AS ezcontentclass_attribute_data_type_string, a.can_translate AS ezcontentclass_attribute_can_translate, a.is_required AS ezcontentclass_attribute_is_required, a.is_information_collector AS ezcontentclass_attribute_is_information_collector, a.is_searchable AS ezcontentclass_attribute_is_searchable, a.is_thumbnail AS ezcontentclass_attribute_is_thumbnail, a.placement AS ezcontentclass_attribute_placement, a.data_float1 AS ezcontentclass_attribute_data_float1, a.data_float2 AS ezcontentclass_attribute_data_float2, a.data_float3 AS ezcontentclass_attribute_data_float3, a.data_float4 AS ezcontentclass_attribute_data_float4, a.data_int1 AS ezcontentclass_attribute_data_int1, a.data_int2 AS ezcontentclass_attribute_data_int2, a.data_int3 AS ezcontentclass_attribute_data_int3, a.data_int4 AS ezcontentclass_attribute_data_int4, a.data_text1 AS ezcontentclass_attribute_data_text1, a.data_text2 AS ezcontentclass_attribute_data_text2, a.data_text3 AS ezcontentclass_attribute_data_text3, a.data_text4 AS ezcontentclass_attribute_data_text4, a.data_text5 AS ezcontentclass_attribute_data_text5, a.serialized_data_text AS ezcontentclass_attribute_serialized_data_text, g.group_id AS ezcontentclass_classgroup_group_id, ml.name AS ezcontentclass_attribute_multilingual_name, ml.description AS ezcontentclass_attribute_multilingual_description, ml.language_id AS ezcontentclass_attribute_multilingual_language_id, ml.data_text AS ezcontentclass_attribute_multilingual_data_text, ml.data_json AS ezcontentclass_attribute_multilingual_data_json FROM ezcontentclass c LEFT JOIN ezcontentclass_attribute a ON (c.id = a.contentclass_id) AND (c.version = a.version) LEFT JOIN ezcontentclass_classgroup g ON (c.id = g.contentclass_id) AND (c.version = g.contentclass_version) LEFT JOIN ezcontentclass_attribute_ml ml ON (a.id = ml.contentclass_attribute_id) AND (a.version = ml.version) WHERE (g.group_id = 1) AND (c.version = 0) ORDER BY a.placement ASC, c.identifier ASC;

SELECT
  created,
  creator_id,
  id,
  modified,
  modifier_id,
  name,
  is_system
FROM
  ezcontentclassgroup
WHERE
  is_system = ?

SELECT created, creator_id, id, modified, modifier_id, name, is_system FROM ezcontentclassgroup WHERE is_system = 0;

SELECT
  id,
  locale,
  name,
  disabled
FROM
  ezcontent_language

SELECT id, locale, name, disabled FROM ezcontent_language;

SELECT
  id,
  identifier,
  name
FROM
  ezsection

SELECT id, identifier, name FROM ezsection;