Symfony Profiler

SELECT 
  1 
FROM 
  phpcr_workspaces 
WHERE 
  name = ?

SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';

SELECT 
  prefix, 
  uri 
FROM 
  phpcr_namespaces

SELECT prefix, uri FROM phpcr_namespaces;

SELECT 
  * 
FROM 
  phpcr_nodes 
WHERE 
  path = : path 
  AND workspace_name = : workspace 
ORDER BY 
  depth, 
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/guidejournal/routes/en'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

SELECT 
  path, 
  parent 
FROM 
  phpcr_nodes 
WHERE 
  parent IN (?) 
  AND workspace_name = ? 
ORDER BY 
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/guidejournal/routes/en') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT 
  phpcr_type_nodes.name AS node_name, 
  phpcr_type_nodes.is_abstract AS node_abstract, 
  phpcr_type_nodes.is_mixin AS node_mixin, 
  phpcr_type_nodes.queryable AS node_queryable, 
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes, 
  phpcr_type_nodes.primary_item AS node_primary_item_name, 
  phpcr_type_nodes.supertypes AS declared_super_type_names, 
  phpcr_type_props.name AS property_name, 
  phpcr_type_props.auto_created AS property_auto_created, 
  phpcr_type_props.mandatory AS property_mandatory, 
  phpcr_type_props.protected AS property_protected, 
  phpcr_type_props.on_parent_version AS property_on_parent_version, 
  phpcr_type_props.required_type AS property_required_type, 
  phpcr_type_props.multiple AS property_multiple, 
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable, 
  phpcr_type_props.query_orderable AS property_query_orderable, 
  phpcr_type_props.default_value as property_default_value, 
  phpcr_type_childs.name AS child_name, 
  phpcr_type_childs.auto_created AS child_auto_created, 
  phpcr_type_childs.mandatory AS child_mandatory, 
  phpcr_type_childs.protected AS child_protected, 
  phpcr_type_childs.on_parent_version AS child_on_parent_version, 
  phpcr_type_childs.default_type AS child_default_type, 
  phpcr_type_childs.primary_types AS child_primary_types 
FROM 
  phpcr_type_nodes 
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id 
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;

SELECT 
  id, 
  path, 
  parent, 
  local_name, 
  namespace, 
  workspace_name, 
  identifier, 
  type, 
  props, 
  depth, 
  sort_order 
FROM 
  phpcr_nodes 
WHERE 
  workspace_name = ? 
  AND identifier IN (?)

SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = 'default_live' AND identifier IN ('5abb0ed7-840d-4cc7-813c-98df9d7ef2bd');

SELECT 
  path, 
  parent 
FROM 
  phpcr_nodes 
WHERE 
  parent IN (?) 
  AND workspace_name = ? 
ORDER BY 
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/guidejournal/contents') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT 
  * 
FROM 
  phpcr_nodes 
WHERE 
  identifier = ? 
  AND workspace_name = ?

SELECT * FROM phpcr_nodes WHERE identifier = '7f935766-1454-4969-821e-6a85ce74491e' AND workspace_name = 'default_live';

SELECT 
  path, 
  parent 
FROM 
  phpcr_nodes 
WHERE 
  parent IN (?) 
  AND workspace_name = ? 
ORDER BY 
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/guidejournal/contents/articles') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT 
  phpcr_type_nodes.name AS node_name, 
  phpcr_type_nodes.is_abstract AS node_abstract, 
  phpcr_type_nodes.is_mixin AS node_mixin, 
  phpcr_type_nodes.queryable AS node_queryable, 
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes, 
  phpcr_type_nodes.primary_item AS node_primary_item_name, 
  phpcr_type_nodes.supertypes AS declared_super_type_names, 
  phpcr_type_props.name AS property_name, 
  phpcr_type_props.auto_created AS property_auto_created, 
  phpcr_type_props.mandatory AS property_mandatory, 
  phpcr_type_props.protected AS property_protected, 
  phpcr_type_props.on_parent_version AS property_on_parent_version, 
  phpcr_type_props.required_type AS property_required_type, 
  phpcr_type_props.multiple AS property_multiple, 
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable, 
  phpcr_type_props.query_orderable AS property_query_orderable, 
  phpcr_type_props.default_value as property_default_value, 
  phpcr_type_childs.name AS child_name, 
  phpcr_type_childs.auto_created AS child_auto_created, 
  phpcr_type_childs.mandatory AS child_mandatory, 
  phpcr_type_childs.protected AS child_protected, 
  phpcr_type_childs.on_parent_version AS child_on_parent_version, 
  phpcr_type_childs.default_type AS child_default_type, 
  phpcr_type_childs.primary_types AS child_primary_types 
FROM 
  phpcr_type_nodes 
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id 
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;

SELECT 
  phpcr_type_nodes.name AS node_name, 
  phpcr_type_nodes.is_abstract AS node_abstract, 
  phpcr_type_nodes.is_mixin AS node_mixin, 
  phpcr_type_nodes.queryable AS node_queryable, 
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes, 
  phpcr_type_nodes.primary_item AS node_primary_item_name, 
  phpcr_type_nodes.supertypes AS declared_super_type_names, 
  phpcr_type_props.name AS property_name, 
  phpcr_type_props.auto_created AS property_auto_created, 
  phpcr_type_props.mandatory AS property_mandatory, 
  phpcr_type_props.protected AS property_protected, 
  phpcr_type_props.on_parent_version AS property_on_parent_version, 
  phpcr_type_props.required_type AS property_required_type, 
  phpcr_type_props.multiple AS property_multiple, 
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable, 
  phpcr_type_props.query_orderable AS property_query_orderable, 
  phpcr_type_props.default_value as property_default_value, 
  phpcr_type_childs.name AS child_name, 
  phpcr_type_childs.auto_created AS child_auto_created, 
  phpcr_type_childs.mandatory AS child_mandatory, 
  phpcr_type_childs.protected AS child_protected, 
  phpcr_type_childs.on_parent_version AS child_on_parent_version, 
  phpcr_type_childs.default_type AS child_default_type, 
  phpcr_type_childs.primary_types AS child_primary_types 
FROM 
  phpcr_type_nodes 
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id 
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;

SELECT 
  n0.path AS n0_path, 
  n0.identifier AS n0_identifier, 
  n0.props AS n0_props 
FROM 
  phpcr_nodes n0 
WHERE 
  n0.workspace_name = ? 
  AND n0.type IN ('nt:unstructured', 'rep:root') 
  AND (
    (
      EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0'
      ) 
      OR EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0'
      )
    ) 
    AND (
      (
        (
          0 != FIND_IN_SET(
            '2', 
            REPLACE(
              EXTRACTVALUE(
                n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'
              ), 
              ' ', 
              ','
            )
          ) 
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]'
          ) = '1'
        ) 
        AND n0.path LIKE '/cmf/guidejournal/contents/articles/%'
      ) 
      AND NOT (
        n0.identifier = '5abb0ed7-840d-4cc7-813c-98df9d7ef2bd'
      )
    )
  ) 
ORDER BY 
  CAST(
    EXTRACTVALUE(
      n0.numerical_props, '//sv:property[@sv:name="i18n:en-published"]/sv:value[1]'
    ) AS DECIMAL
  ) DESC, 
  EXTRACTVALUE(
    n0.props, '//sv:property[@sv:name="i18n:en-published"]/sv:value[1]'
  ) DESC 
LIMIT 
  7

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND n0.path LIKE '/cmf/guidejournal/contents/articles/%') AND NOT (n0.identifier = '5abb0ed7-840d-4cc7-813c-98df9d7ef2bd'))) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="i18n:en-published"]/sv:value[1]') AS DECIMAL) DESC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-published"]/sv:value[1]') DESC LIMIT 7;

SELECT 
  path AS arraykey, 
  id, 
  path, 
  parent, 
  local_name, 
  namespace, 
  workspace_name, 
  identifier, 
  type, 
  props, 
  depth, 
  sort_order 
FROM 
  phpcr_nodes 
WHERE 
  workspace_name = : workspace 
  AND (
    path = : path0 
    OR path = : path1 
    OR path = : path2 
    OR path = : path3 
    OR path = : path4 
    OR path = : path5 
    OR path = : path6
  ) 
ORDER BY 
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/guidejournal/contents/articles/the-profound-benefits-of-scientific-research-shaping-our-world-for-a-better-future' OR path = '/cmf/guidejournal/contents/articles/a-complete-guide-on-thesis-statement-writing-for-research-papers' OR path = '/cmf/guidejournal/contents/articles/the-complete-guide-to-writing-a-research-paper-abstract-with-examples' OR path = '/cmf/guidejournal/contents/articles/research-methodology-a-comprehensive-guide-to-conducting-effective-research' OR path = '/cmf/guidejournal/contents/articles/understanding-the-importance-of-sampling-techniques-in-research' OR path = '/cmf/guidejournal/contents/articles/analyzing-the-process-of-data-collection-in-qualitative-research' OR path = '/cmf/guidejournal/contents/articles/how-to-verify-indexed-journals-in-scopus-and-web-of-science') ORDER BY sort_order ASC;

SELECT 
  path, 
  parent 
FROM 
  phpcr_nodes 
WHERE 
  parent IN (?) 
  AND workspace_name = ? 
ORDER BY 
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/guidejournal/contents/articles/how-to-verify-indexed-journals-in-scopus-and-web-of-science', '/cmf/guidejournal/contents/articles/analyzing-the-process-of-data-collection-in-qualitative-research', '/cmf/guidejournal/contents/articles/understanding-the-importance-of-sampling-techniques-in-research', '/cmf/guidejournal/contents/articles/research-methodology-a-comprehensive-guide-to-conducting-effective-research', '/cmf/guidejournal/contents/articles/the-complete-guide-to-writing-a-research-paper-abstract-with-examples', '/cmf/guidejournal/contents/articles/a-complete-guide-on-thesis-statement-writing-for-research-papers', '/cmf/guidejournal/contents/articles/the-profound-benefits-of-scientific-research-shaping-our-world-for-a-better-future') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT 
  m0_.id AS id_0, 
  m0_.created AS created_1, 
  m0_.changed AS changed_2, 
  m1_.name AS name_3, 
  m1_.description AS description_4, 
  m1_.id AS id_5, 
  m2_.style AS style_6, 
  m2_.lft AS lft_7, 
  m2_.rgt AS rgt_8, 
  m2_.depth AS depth_9, 
  m2_.collection_key AS collection_key_10, 
  m2_.id AS id_11, 
  m2_.created AS created_12, 
  m2_.changed AS changed_13, 
  m3_.version AS version_14, 
  m3_.id AS id_15, 
  m3_.created AS created_16, 
  m3_.changed AS changed_17, 
  m4_.name AS name_18, 
  m4_.version AS version_19, 
  m4_.subVersion AS subVersion_20, 
  m4_.size AS size_21, 
  m4_.downloadCounter AS downloadCounter_22, 
  m4_.storageOptions AS storageOptions_23, 
  m4_.mimeType AS mimeType_24, 
  m4_.properties AS properties_25, 
  m4_.focusPointX AS focusPointX_26, 
  m4_.focusPointY AS focusPointY_27, 
  m4_.id AS id_28, 
  m4_.created AS created_29, 
  m4_.changed AS changed_30, 
  t5_.name AS name_31, 
  t5_.id AS id_32, 
  t5_.created AS created_33, 
  t5_.changed AS changed_34, 
  m6_.crop_x AS crop_x_35, 
  m6_.crop_y AS crop_y_36, 
  m6_.crop_width AS crop_width_37, 
  m6_.crop_height AS crop_height_38, 
  m6_.format_key AS format_key_39, 
  m7_.title AS title_40, 
  m7_.description AS description_41, 
  m7_.copyright AS copyright_42, 
  m7_.credits AS credits_43, 
  m7_.locale AS locale_44, 
  m7_.id AS id_45, 
  m8_.title AS title_46, 
  m8_.description AS description_47, 
  m8_.copyright AS copyright_48, 
  m8_.credits AS credits_49, 
  m8_.locale AS locale_50, 
  m8_.id AS id_51, 
  m9_.locale AS locale_52, 
  m9_.id AS id_53, 
  m10_.locale AS locale_54, 
  m10_.id AS id_55, 
  s11_.username AS username_56, 
  s11_.password AS password_57, 
  s11_.locale AS locale_58, 
  s11_.salt AS salt_59, 
  s11_.locked AS locked_60, 
  s11_.enabled AS enabled_61, 
  s11_.lastLogin AS lastLogin_62, 
  s11_.confirmationKey AS confirmationKey_63, 
  s11_.passwordResetToken AS passwordResetToken_64, 
  s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, 
  s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, 
  s11_.privateKey AS privateKey_67, 
  s11_.apiKey AS apiKey_68, 
  s11_.email AS email_69, 
  s11_.id AS id_70, 
  s11_.full_name AS full_name_71, 
  s11_.country AS country_72, 
  s11_.institution AS institution_73, 
  s11_.departement AS departement_74, 
  s11_.speciality AS speciality_75, 
  s11_.verification_code AS verification_code_76, 
  s11_.facebook AS facebook_77, 
  s11_.twitter AS twitter_78, 
  s11_.linked_in AS linked_in_79, 
  s11_.instagram AS instagram_80, 
  s11_.youtube AS youtube_81, 
  s11_.created_at AS created_at_82, 
  s11_.birthday AS birthday_83, 
  s11_.gender AS gender_84, 
  s11_.is_deleted AS is_deleted_85, 
  s11_.deleted_at AS deleted_at_86, 
  s11_.deactivation_reason AS deactivation_reason_87, 
  s11_.google_id AS google_id_88, 
  s11_.facebook_id AS facebook_id_89, 
  s11_.linkedin_id AS linkedin_id_90, 
  s11_.picture_social AS picture_social_91, 
  c12_.firstName AS firstName_92, 
  c12_.middleName AS middleName_93, 
  c12_.lastName AS lastName_94, 
  c12_.birthday AS birthday_95, 
  c12_.salutation AS salutation_96, 
  c12_.formOfAddress AS formOfAddress_97, 
  c12_.newsletter AS newsletter_98, 
  c12_.gender AS gender_99, 
  c12_.note AS note_100, 
  c12_.mainEmail AS mainEmail_101, 
  c12_.mainPhone AS mainPhone_102, 
  c12_.mainFax AS mainFax_103, 
  c12_.mainUrl AS mainUrl_104, 
  c12_.id AS id_105, 
  c12_.created AS created_106, 
  c12_.changed AS changed_107, 
  s13_.username AS username_108, 
  s13_.password AS password_109, 
  s13_.locale AS locale_110, 
  s13_.salt AS salt_111, 
  s13_.locked AS locked_112, 
  s13_.enabled AS enabled_113, 
  s13_.lastLogin AS lastLogin_114, 
  s13_.confirmationKey AS confirmationKey_115, 
  s13_.passwordResetToken AS passwordResetToken_116, 
  s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_117, 
  s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_118, 
  s13_.privateKey AS privateKey_119, 
  s13_.apiKey AS apiKey_120, 
  s13_.email AS email_121, 
  s13_.id AS id_122, 
  s13_.full_name AS full_name_123, 
  s13_.country AS country_124, 
  s13_.institution AS institution_125, 
  s13_.departement AS departement_126, 
  s13_.speciality AS speciality_127, 
  s13_.verification_code AS verification_code_128, 
  s13_.facebook AS facebook_129, 
  s13_.twitter AS twitter_130, 
  s13_.linked_in AS linked_in_131, 
  s13_.instagram AS instagram_132, 
  s13_.youtube AS youtube_133, 
  s13_.created_at AS created_at_134, 
  s13_.birthday AS birthday_135, 
  s13_.gender AS gender_136, 
  s13_.is_deleted AS is_deleted_137, 
  s13_.deleted_at AS deleted_at_138, 
  s13_.deactivation_reason AS deactivation_reason_139, 
  s13_.google_id AS google_id_140, 
  s13_.facebook_id AS facebook_id_141, 
  s13_.linkedin_id AS linkedin_id_142, 
  s13_.picture_social AS picture_social_143, 
  c14_.firstName AS firstName_144, 
  c14_.middleName AS middleName_145, 
  c14_.lastName AS lastName_146, 
  c14_.birthday AS birthday_147, 
  c14_.salutation AS salutation_148, 
  c14_.formOfAddress AS formOfAddress_149, 
  c14_.newsletter AS newsletter_150, 
  c14_.gender AS gender_151, 
  c14_.note AS note_152, 
  c14_.mainEmail AS mainEmail_153, 
  c14_.mainPhone AS mainPhone_154, 
  c14_.mainFax AS mainFax_155, 
  c14_.mainUrl AS mainUrl_156, 
  c14_.id AS id_157, 
  c14_.created AS created_158, 
  c14_.changed AS changed_159, 
  m15_.id AS id_160, 
  m15_.created AS created_161, 
  m15_.changed AS changed_162, 
  m0_.idMediaTypes AS idMediaTypes_163, 
  m0_.idPreviewImage AS idPreviewImage_164, 
  m0_.idCollections AS idCollections_165, 
  m0_.idUsersCreator AS idUsersCreator_166, 
  m0_.idUsersChanger AS idUsersChanger_167, 
  m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_168, 
  m2_.idCollectionTypes AS idCollectionTypes_169, 
  m2_.idCollectionsParent AS idCollectionsParent_170, 
  m2_.idUsersCreator AS idUsersCreator_171, 
  m2_.idUsersChanger AS idUsersChanger_172, 
  m3_.idMedia AS idMedia_173, 
  m3_.idUsersCreator AS idUsersCreator_174, 
  m3_.idUsersChanger AS idUsersChanger_175, 
  m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_176, 
  m4_.idFiles AS idFiles_177, 
  m4_.idUsersCreator AS idUsersCreator_178, 
  m4_.idUsersChanger AS idUsersChanger_179, 
  t5_.idUsersCreator AS idUsersCreator_180, 
  t5_.idUsersChanger AS idUsersChanger_181, 
  m6_.fileVersion AS fileVersion_182, 
  m7_.idFileVersions AS idFileVersions_183, 
  m8_.idFileVersions AS idFileVersions_184, 
  m9_.idFileVersions AS idFileVersions_185, 
  m10_.idFileVersions AS idFileVersions_186, 
  s11_.idContacts AS idContacts_187, 
  c12_.idTitles AS idTitles_188, 
  c12_.avatar AS avatar_189, 
  c12_.idUsersCreator AS idUsersCreator_190, 
  c12_.idUsersChanger AS idUsersChanger_191, 
  s13_.idContacts AS idContacts_192, 
  c14_.idTitles AS idTitles_193, 
  c14_.avatar AS avatar_194, 
  c14_.idUsersCreator AS idUsersCreator_195, 
  c14_.idUsersChanger AS idUsersChanger_196, 
  m15_.idMediaTypes AS idMediaTypes_197, 
  m15_.idPreviewImage AS idPreviewImage_198, 
  m15_.idCollections AS idCollections_199, 
  m15_.idUsersCreator AS idUsersCreator_200, 
  m15_.idUsersChanger AS idUsersChanger_201 
FROM 
  me_media m0_ 
  LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id 
  LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id 
  LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia 
  LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles 
  LEFT JOIN me_file_version_tags m16_ ON m4_.id = m16_.idFileVersions 
  LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags 
  LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions 
  LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories 
  LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion 
  LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions 
  LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id 
  LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions 
  LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions 
  LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id 
  LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id 
  LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id 
  LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id 
  LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id 
WHERE 
  m0_.id = ?

SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.full_name AS full_name_71, s11_.country AS country_72, s11_.institution AS institution_73, s11_.departement AS departement_74, s11_.speciality AS speciality_75, s11_.verification_code AS verification_code_76, s11_.facebook AS facebook_77, s11_.twitter AS twitter_78, s11_.linked_in AS linked_in_79, s11_.instagram AS instagram_80, s11_.youtube AS youtube_81, s11_.created_at AS created_at_82, s11_.birthday AS birthday_83, s11_.gender AS gender_84, s11_.is_deleted AS is_deleted_85, s11_.deleted_at AS deleted_at_86, s11_.deactivation_reason AS deactivation_reason_87, s11_.google_id AS google_id_88, s11_.facebook_id AS facebook_id_89, s11_.linkedin_id AS linkedin_id_90, s11_.picture_social AS picture_social_91, c12_.firstName AS firstName_92, c12_.middleName AS middleName_93, c12_.lastName AS lastName_94, c12_.birthday AS birthday_95, c12_.salutation AS salutation_96, c12_.formOfAddress AS formOfAddress_97, c12_.newsletter AS newsletter_98, c12_.gender AS gender_99, c12_.note AS note_100, c12_.mainEmail AS mainEmail_101, c12_.mainPhone AS mainPhone_102, c12_.mainFax AS mainFax_103, c12_.mainUrl AS mainUrl_104, c12_.id AS id_105, c12_.created AS created_106, c12_.changed AS changed_107, s13_.username AS username_108, s13_.password AS password_109, s13_.locale AS locale_110, s13_.salt AS salt_111, s13_.locked AS locked_112, s13_.enabled AS enabled_113, s13_.lastLogin AS lastLogin_114, s13_.confirmationKey AS confirmationKey_115, s13_.passwordResetToken AS passwordResetToken_116, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_117, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_118, s13_.privateKey AS privateKey_119, s13_.apiKey AS apiKey_120, s13_.email AS email_121, s13_.id AS id_122, s13_.full_name AS full_name_123, s13_.country AS country_124, s13_.institution AS institution_125, s13_.departement AS departement_126, s13_.speciality AS speciality_127, s13_.verification_code AS verification_code_128, s13_.facebook AS facebook_129, s13_.twitter AS twitter_130, s13_.linked_in AS linked_in_131, s13_.instagram AS instagram_132, s13_.youtube AS youtube_133, s13_.created_at AS created_at_134, s13_.birthday AS birthday_135, s13_.gender AS gender_136, s13_.is_deleted AS is_deleted_137, s13_.deleted_at AS deleted_at_138, s13_.deactivation_reason AS deactivation_reason_139, s13_.google_id AS google_id_140, s13_.facebook_id AS facebook_id_141, s13_.linkedin_id AS linkedin_id_142, s13_.picture_social AS picture_social_143, c14_.firstName AS firstName_144, c14_.middleName AS middleName_145, c14_.lastName AS lastName_146, c14_.birthday AS birthday_147, c14_.salutation AS salutation_148, c14_.formOfAddress AS formOfAddress_149, c14_.newsletter AS newsletter_150, c14_.gender AS gender_151, c14_.note AS note_152, c14_.mainEmail AS mainEmail_153, c14_.mainPhone AS mainPhone_154, c14_.mainFax AS mainFax_155, c14_.mainUrl AS mainUrl_156, c14_.id AS id_157, c14_.created AS created_158, c14_.changed AS changed_159, m15_.id AS id_160, m15_.created AS created_161, m15_.changed AS changed_162, m0_.idMediaTypes AS idMediaTypes_163, m0_.idPreviewImage AS idPreviewImage_164, m0_.idCollections AS idCollections_165, m0_.idUsersCreator AS idUsersCreator_166, m0_.idUsersChanger AS idUsersChanger_167, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_168, m2_.idCollectionTypes AS idCollectionTypes_169, m2_.idCollectionsParent AS idCollectionsParent_170, m2_.idUsersCreator AS idUsersCreator_171, m2_.idUsersChanger AS idUsersChanger_172, m3_.idMedia AS idMedia_173, m3_.idUsersCreator AS idUsersCreator_174, m3_.idUsersChanger AS idUsersChanger_175, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_176, m4_.idFiles AS idFiles_177, m4_.idUsersCreator AS idUsersCreator_178, m4_.idUsersChanger AS idUsersChanger_179, t5_.idUsersCreator AS idUsersCreator_180, t5_.idUsersChanger AS idUsersChanger_181, m6_.fileVersion AS fileVersion_182, m7_.idFileVersions AS idFileVersions_183, m8_.idFileVersions AS idFileVersions_184, m9_.idFileVersions AS idFileVersions_185, m10_.idFileVersions AS idFileVersions_186, s11_.idContacts AS idContacts_187, c12_.idTitles AS idTitles_188, c12_.avatar AS avatar_189, c12_.idUsersCreator AS idUsersCreator_190, c12_.idUsersChanger AS idUsersChanger_191, s13_.idContacts AS idContacts_192, c14_.idTitles AS idTitles_193, c14_.avatar AS avatar_194, c14_.idUsersCreator AS idUsersCreator_195, c14_.idUsersChanger AS idUsersChanger_196, m15_.idMediaTypes AS idMediaTypes_197, m15_.idPreviewImage AS idPreviewImage_198, m15_.idCollections AS idCollections_199, m15_.idUsersCreator AS idUsersCreator_200, m15_.idUsersChanger AS idUsersChanger_201 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = 15;