Symfony Profiler

SELECT
  u.contentobject_id,
  u.login,
  u.email,
  u.password_hash,
  u.password_hash_type,
  u.password_updated_at,
  s.is_enabled,
  s.max_login
FROM
  ibexa_user u
  LEFT JOIN ibexa_user_setting s ON s.user_id = u.contentobject_id
WHERE
  LOWER(u.login) = ?

SELECT u.contentobject_id, u.login, u.email, u.password_hash, u.password_hash_type, u.password_updated_at, s.is_enabled, s.max_login FROM ibexa_user u LEFT JOIN ibexa_user_setting s ON s.user_id = u.contentobject_id WHERE LOWER(u.login) = 'admin';

SELECT
  c.*,
  t.main_node_id AS content_tree_main_node_id
FROM
  ibexa_content c
  LEFT JOIN ibexa_content_tree t ON (c.id = t.contentobject_id)
  AND (t.node_id = t.main_node_id)
WHERE
  c.id = ?

SELECT c.*, t.main_node_id AS content_tree_main_node_id FROM ibexa_content c LEFT JOIN ibexa_content_tree t ON (c.id = t.contentobject_id) AND (t.node_id = t.main_node_id) WHERE c.id = 14;

SELECT
  id,
  locale,
  name,
  disabled
FROM
  ibexa_content_language
WHERE
  id IN (?)

SELECT id, locale, name, disabled FROM ibexa_content_language WHERE id IN (2);

SELECT
  *
FROM
  ibexa_content_tree t
WHERE
  t.contentobject_id = ?

SELECT * FROM ibexa_content_tree t WHERE t.contentobject_id = 14;

SELECT
  c.id AS content_id,
  c.content_type_id AS content_content_type_id,
  c.section_id AS content_section_id,
  c.owner_id AS content_owner_id,
  c.remote_id AS content_remote_id,
  c.current_version AS content_current_version,
  c.initial_language_id AS content_initial_language_id,
  c.modified AS content_modified,
  c.published AS content_published,
  c.status AS content_status,
  c.name AS content_name,
  c.language_mask AS content_language_mask,
  c.is_hidden AS content_is_hidden,
  v.id AS content_version_id,
  v.version AS content_version_version,
  v.modified AS content_version_modified,
  v.creator_id AS content_version_creator_id,
  v.created AS content_version_created,
  v.status AS content_version_status,
  v.language_mask AS content_version_language_mask,
  v.initial_language_id AS content_version_initial_language_id,
  a.id AS content_field_id,
  a.content_type_field_definition_id AS content_field_content_type_field_definition_id,
  a.data_type_string AS content_field_data_type_string,
  a.language_code AS content_field_language_code,
  a.language_id AS content_field_language_id,
  a.data_float AS content_field_data_float,
  a.data_int AS content_field_data_int,
  a.data_text AS content_field_data_text,
  a.sort_key_int AS content_field_sort_key_int,
  a.sort_key_string AS content_field_sort_key_string,
  t.main_node_id AS content_tree_main_node_id
FROM
  ibexa_content c
  INNER JOIN ibexa_content_version v ON (c.id = v.contentobject_id)
  AND (v.version = c.current_version)
  LEFT JOIN ibexa_content_tree t ON (c.id = t.contentobject_id)
  AND (t.node_id = t.main_node_id)
  INNER JOIN ibexa_content_field a ON (
    v.contentobject_id = a.contentobject_id
  )
  AND (v.version = a.version)
WHERE
  (
    c.id IN (?)
  )
  AND (
    a.language_code IN (?)
  )

SELECT c.id AS content_id, c.content_type_id AS content_content_type_id, c.section_id AS content_section_id, c.owner_id AS content_owner_id, c.remote_id AS content_remote_id, c.current_version AS content_current_version, c.initial_language_id AS content_initial_language_id, c.modified AS content_modified, c.published AS content_published, c.status AS content_status, c.name AS content_name, c.language_mask AS content_language_mask, c.is_hidden AS content_is_hidden, v.id AS content_version_id, v.version AS content_version_version, v.modified AS content_version_modified, v.creator_id AS content_version_creator_id, v.created AS content_version_created, v.status AS content_version_status, v.language_mask AS content_version_language_mask, v.initial_language_id AS content_version_initial_language_id, a.id AS content_field_id, a.content_type_field_definition_id AS content_field_content_type_field_definition_id, a.data_type_string AS content_field_data_type_string, a.language_code AS content_field_language_code, a.language_id AS content_field_language_id, a.data_float AS content_field_data_float, a.data_int AS content_field_data_int, a.data_text AS content_field_data_text, a.sort_key_int AS content_field_sort_key_int, a.sort_key_string AS content_field_sort_key_string, t.main_node_id AS content_tree_main_node_id FROM ibexa_content c INNER JOIN ibexa_content_version v ON (c.id = v.contentobject_id) AND (v.version = c.current_version) LEFT JOIN ibexa_content_tree t ON (c.id = t.contentobject_id) AND (t.node_id = t.main_node_id) INNER JOIN ibexa_content_field a ON (v.contentobject_id = a.contentobject_id) AND (v.version = a.version) WHERE (c.id IN (14)) AND (a.language_code IN ('eng-GB'));

SELECT
  contentobject_id AS content_name_contentobject_id,
  content_version AS content_name_content_version,
  name AS content_name_name,
  content_translation AS content_name_content_translation
FROM
  ibexa_content_name
WHERE
  (contentobject_id = ?)
  AND (content_version = ?)

SELECT contentobject_id AS content_name_contentobject_id, content_version AS content_name_content_version, name AS content_name_name, content_translation AS content_name_content_translation FROM ibexa_content_name WHERE (contentobject_id = 14) AND (content_version = 4);

SELECT
  id,
  locale,
  name,
  disabled
FROM
  ibexa_content_language

SELECT id, locale, name, disabled FROM ibexa_content_language;

SELECT
  c.id AS content_type_id,
  c.status AS content_type_status,
  c.serialized_name_list AS content_type_serialized_name_list,
  c.serialized_description_list AS content_type_serialized_description_list,
  c.identifier AS content_type_identifier,
  c.created AS content_type_created,
  c.modified AS content_type_modified,
  c.modifier_id AS content_type_modifier_id,
  c.creator_id AS content_type_creator_id,
  c.remote_id AS content_type_remote_id,
  c.url_alias_name AS content_type_url_alias_name,
  c.contentobject_name AS content_type_contentobject_name,
  c.is_container AS content_type_is_container,
  c.initial_language_id AS content_type_initial_language_id,
  c.always_available AS content_type_always_available,
  c.sort_field AS content_type_sort_field,
  c.sort_order AS content_type_sort_order,
  c.language_mask AS content_type_language_mask,
  a.id AS content_type_field_definition_id,
  a.serialized_name_list AS content_type_field_definition_serialized_name_list,
  a.serialized_description_list AS content_type_field_definition_serialized_description_list,
  a.identifier AS content_type_field_definition_identifier,
  a.category AS content_type_field_definition_category,
  a.data_type_string AS content_type_field_definition_data_type_string,
  a.can_translate AS content_type_field_definition_can_translate,
  a.is_required AS content_type_field_definition_is_required,
  a.is_information_collector AS content_type_field_definition_is_information_collector,
  a.is_searchable AS content_type_field_definition_is_searchable,
  a.is_thumbnail AS content_type_field_definition_is_thumbnail,
  a.placement AS content_type_field_definition_placement,
  a.data_float1 AS content_type_field_definition_data_float1,
  a.data_float2 AS content_type_field_definition_data_float2,
  a.data_float3 AS content_type_field_definition_data_float3,
  a.data_float4 AS content_type_field_definition_data_float4,
  a.data_int1 AS content_type_field_definition_data_int1,
  a.data_int2 AS content_type_field_definition_data_int2,
  a.data_int3 AS content_type_field_definition_data_int3,
  a.data_int4 AS content_type_field_definition_data_int4,
  a.data_text1 AS content_type_field_definition_data_text1,
  a.data_text2 AS content_type_field_definition_data_text2,
  a.data_text3 AS content_type_field_definition_data_text3,
  a.data_text4 AS content_type_field_definition_data_text4,
  a.data_text5 AS content_type_field_definition_data_text5,
  a.serialized_data_text AS content_type_field_definition_serialized_data_text,
  g.group_id AS content_type_group_assignment_group_id,
  ml.name AS content_type_field_definition_multilingual_name,
  ml.description AS content_type_field_definition_multilingual_description,
  ml.language_id AS content_type_field_definition_multilingual_language_id,
  ml.data_text AS content_type_field_definition_multilingual_data_text,
  ml.data_json AS content_type_field_definition_multilingual_data_json
FROM
  ibexa_content_type c
  LEFT JOIN ibexa_content_type_field_definition a ON (c.id = a.content_type_id)
  AND (c.status = a.status)
  LEFT JOIN ibexa_content_type_group_assignment g ON (c.id = g.content_type_id)
  AND (c.status = g.content_type_status)
  LEFT JOIN ibexa_content_type_field_definition_ml ml ON (
    a.id = ml.content_type_field_definition_id
  )
  AND (a.status = ml.status)
WHERE
  (c.id = ?)
  AND (c.status = ?)
ORDER BY
  a.placement ASC

SELECT c.id AS content_type_id, c.status AS content_type_status, c.serialized_name_list AS content_type_serialized_name_list, c.serialized_description_list AS content_type_serialized_description_list, c.identifier AS content_type_identifier, c.created AS content_type_created, c.modified AS content_type_modified, c.modifier_id AS content_type_modifier_id, c.creator_id AS content_type_creator_id, c.remote_id AS content_type_remote_id, c.url_alias_name AS content_type_url_alias_name, c.contentobject_name AS content_type_contentobject_name, c.is_container AS content_type_is_container, c.initial_language_id AS content_type_initial_language_id, c.always_available AS content_type_always_available, c.sort_field AS content_type_sort_field, c.sort_order AS content_type_sort_order, c.language_mask AS content_type_language_mask, a.id AS content_type_field_definition_id, a.serialized_name_list AS content_type_field_definition_serialized_name_list, a.serialized_description_list AS content_type_field_definition_serialized_description_list, a.identifier AS content_type_field_definition_identifier, a.category AS content_type_field_definition_category, a.data_type_string AS content_type_field_definition_data_type_string, a.can_translate AS content_type_field_definition_can_translate, a.is_required AS content_type_field_definition_is_required, a.is_information_collector AS content_type_field_definition_is_information_collector, a.is_searchable AS content_type_field_definition_is_searchable, a.is_thumbnail AS content_type_field_definition_is_thumbnail, a.placement AS content_type_field_definition_placement, a.data_float1 AS content_type_field_definition_data_float1, a.data_float2 AS content_type_field_definition_data_float2, a.data_float3 AS content_type_field_definition_data_float3, a.data_float4 AS content_type_field_definition_data_float4, a.data_int1 AS content_type_field_definition_data_int1, a.data_int2 AS content_type_field_definition_data_int2, a.data_int3 AS content_type_field_definition_data_int3, a.data_int4 AS content_type_field_definition_data_int4, a.data_text1 AS content_type_field_definition_data_text1, a.data_text2 AS content_type_field_definition_data_text2, a.data_text3 AS content_type_field_definition_data_text3, a.data_text4 AS content_type_field_definition_data_text4, a.data_text5 AS content_type_field_definition_data_text5, a.serialized_data_text AS content_type_field_definition_serialized_data_text, g.group_id AS content_type_group_assignment_group_id, ml.name AS content_type_field_definition_multilingual_name, ml.description AS content_type_field_definition_multilingual_description, ml.language_id AS content_type_field_definition_multilingual_language_id, ml.data_text AS content_type_field_definition_multilingual_data_text, ml.data_json AS content_type_field_definition_multilingual_data_json FROM ibexa_content_type c LEFT JOIN ibexa_content_type_field_definition a ON (c.id = a.content_type_id) AND (c.status = a.status) LEFT JOIN ibexa_content_type_group_assignment g ON (c.id = g.content_type_id) AND (c.status = g.content_type_status) LEFT JOIN ibexa_content_type_field_definition_ml ml ON (a.id = ml.content_type_field_definition_id) AND (a.status = ml.status) WHERE (c.id = 4) AND (c.status = 0) ORDER BY a.placement ASC;

SELECT
  `contentobject_id`
FROM
  `ibexa_content_field`
WHERE
  `id` = ?

SELECT `contentobject_id` FROM `ibexa_content_field` WHERE `id` = 30;

SELECT
  `usr`.`contentobject_id`,
  `usr`.`login`,
  `usr`.`email`,
  `usr`.`password_hash`,
  `usr`.`password_hash_type`,
  `usr`.`password_updated_at`
FROM
  `ibexa_user` usr
WHERE
  `usr`.`contentobject_id` = ?

SELECT `usr`.`contentobject_id`, `usr`.`login`, `usr`.`email`, `usr`.`password_hash`, `usr`.`password_hash_type`, `usr`.`password_updated_at` FROM `ibexa_user` usr WHERE `usr`.`contentobject_id` = 14;

SELECT
  `s`.`is_enabled`,
  `s`.`max_login`
FROM
  `ibexa_user_setting` s
WHERE
  `s`.`user_id` = ?

SELECT `s`.`is_enabled`, `s`.`max_login` FROM `ibexa_user_setting` s WHERE `s`.`user_id` = 14;

SELECT
  *
FROM
  ibexa_content_tree t
WHERE
  t.contentobject_id = ?

SELECT * FROM ibexa_content_tree t WHERE t.contentobject_id = 14;