1
0.98 ms
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters :
[
"default_live "
]
SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live' ; Copy
2
0.70 ms
SELECT prefix , uri FROM phpcr_namespaces
SELECT prefix , uri FROM phpcr_namespaces ; Copy
3
0.82 ms
SELECT * FROM phpcr_nodes
WHERE path = ?
AND workspace_name = ?
ORDER BY depth , sort_order ASC
Parameters :
[
"/cmf/pgcdoe/routes/en/ms4-watershed-activities "
"default_live "
]
SELECT * FROM phpcr_nodes
WHERE path = '/cmf/pgcdoe/routes/en/ms4-watershed-activities'
AND workspace_name = 'default_live'
ORDER BY depth , sort_order ASC ; Copy
4
0.81 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/pgcdoe/routes/en/ms4-watershed-activities "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/pgcdoe/routes/en/ms4-watershed-activities' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
5
1.30 ms
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
; Copy
6
0.86 ms
SELECT id , path , parent , local_name , namespace , workspace_name , identifier , type , props , depth , sort_order
FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (? )
Parameters :
[
"default_live "
"a2d68dbe-ec51-49be-88e5-322cf9053c25 "
]
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 ('a2d68dbe-ec51-49be-88e5-322cf9053c25' ); Copy
7
0.94 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/pgcdoe/contents/ms4-watershed-activities "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/pgcdoe/contents/ms4-watershed-activities' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
8
1.24 ms
SELECT * FROM phpcr_nodes
WHERE path = ?
AND workspace_name = ?
ORDER BY depth , sort_order ASC
Parameters :
[
"/cmf/pgcdoe/contents "
"default_live "
]
SELECT * FROM phpcr_nodes
WHERE path = '/cmf/pgcdoe/contents'
AND workspace_name = 'default_live'
ORDER BY depth , sort_order ASC ; Copy
9
1.00 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/pgcdoe/contents "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/pgcdoe/contents' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
10
1.44 ms
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
; Copy
11
1.33 ms
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
; Copy
12
1.93 ms
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 (n0 . identifier = '198ba57c-a5b7-41a6-b810-868a12963c85' OR n0 . identifier = 'fca02e3d-0ff0-4e83-9c62-054515e0d0a0' ) ORDER BY CAST (EXTRACTVALUE (n0 . numerical_props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC , EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC
Parameters :
[
"default_live "
]
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 (n0 . identifier = '198ba57c-a5b7-41a6-b810-868a12963c85' OR n0 . identifier = 'fca02e3d-0ff0-4e83-9c62-054515e0d0a0' ) ORDER BY CAST (EXTRACTVALUE (n0 . numerical_props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC , EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC ; Copy
13
1.35 ms
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 n0 . parent = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management' LIMIT 1
Parameters :
[
"default_live "
]
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 n0 . parent = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management' LIMIT 1 ; Copy
14
1.09 ms
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 n0 . parent = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring' LIMIT 1
Parameters :
[
"default_live "
]
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 n0 . parent = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring' LIMIT 1 ; Copy
15
0.99 ms
SELECT * FROM phpcr_nodes
WHERE path = ?
AND workspace_name = ?
ORDER BY depth , sort_order ASC
Parameters :
[
"/cmf/pgcdoe "
"default_live "
]
SELECT * FROM phpcr_nodes
WHERE path = '/cmf/pgcdoe'
AND workspace_name = 'default_live'
ORDER BY depth , sort_order ASC ; Copy
16
1.04 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/pgcdoe "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/pgcdoe' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
17
0.84 ms
SELECT id , path , parent , local_name , namespace , workspace_name , identifier , type , props , depth , sort_order
FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (? )
Parameters :
[
"default_live "
"615a5589-cad8-4397-970c-936abb4aacf2 "
]
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 ('615a5589-cad8-4397-970c-936abb4aacf2' ); Copy
18
1.08 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/snippets/navigation/navigation "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/navigation/navigation' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
19
0.82 ms
SELECT * FROM phpcr_nodes
WHERE path = ?
AND workspace_name = ?
ORDER BY depth , sort_order ASC
Parameters :
[
"/cmf/snippets/navigation "
"default_live "
]
SELECT * FROM phpcr_nodes
WHERE path = '/cmf/snippets/navigation'
AND workspace_name = 'default_live'
ORDER BY depth , sort_order ASC ; Copy
20
0.84 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/snippets/navigation "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/navigation' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
21
2.86 ms
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_ . title AS title_35 , m6_ . description AS description_36 , m6_ . copyright AS copyright_37 , m6_ . credits AS credits_38 , m6_ . locale AS locale_39 , m6_ . id AS id_40 , m7_ . title AS title_41 , m7_ . description AS description_42 , m7_ . copyright AS copyright_43 , m7_ . credits AS credits_44 , m7_ . locale AS locale_45 , m7_ . id AS id_46 , m8_ . locale AS locale_47 , m8_ . id AS id_48 , m9_ . locale AS locale_49 , m9_ . id AS id_50 , s10_ . username AS username_51 , s10_ . password AS password_52 , s10_ . locale AS locale_53 , s10_ . salt AS salt_54 , s10_ . locked AS locked_55 , s10_ . enabled AS enabled_56 , s10_ . lastLogin AS lastLogin_57 , s10_ . confirmationKey AS confirmationKey_58 , s10_ . passwordResetToken AS passwordResetToken_59 , s10_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60 , s10_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61 , s10_ . privateKey AS privateKey_62 , s10_ . apiKey AS apiKey_63 , s10_ . email AS email_64 , s10_ . id AS id_65 , s10_ . created AS created_66 , s10_ . changed AS changed_67 , c11_ . firstName AS firstName_68 , c11_ . middleName AS middleName_69 , c11_ . lastName AS lastName_70 , c11_ . birthday AS birthday_71 , c11_ . salutation AS salutation_72 , c11_ . formOfAddress AS formOfAddress_73 , c11_ . newsletter AS newsletter_74 , c11_ . gender AS gender_75 , c11_ . note AS note_76 , c11_ . mainEmail AS mainEmail_77 , c11_ . mainPhone AS mainPhone_78 , c11_ . mainFax AS mainFax_79 , c11_ . mainUrl AS mainUrl_80 , c11_ . id AS id_81 , c11_ . created AS created_82 , c11_ . changed AS changed_83 , s12_ . username AS username_84 , s12_ . password AS password_85 , s12_ . locale AS locale_86 , s12_ . salt AS salt_87 , s12_ . locked AS locked_88 , s12_ . enabled AS enabled_89 , s12_ . lastLogin AS lastLogin_90 , s12_ . confirmationKey AS confirmationKey_91 , s12_ . passwordResetToken AS passwordResetToken_92 , s12_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93 , s12_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94 , s12_ . privateKey AS privateKey_95 , s12_ . apiKey AS apiKey_96 , s12_ . email AS email_97 , s12_ . id AS id_98 , s12_ . created AS created_99 , s12_ . changed AS changed_100 , c13_ . firstName AS firstName_101 , c13_ . middleName AS middleName_102 , c13_ . lastName AS lastName_103 , c13_ . birthday AS birthday_104 , c13_ . salutation AS salutation_105 , c13_ . formOfAddress AS formOfAddress_106 , c13_ . newsletter AS newsletter_107 , c13_ . gender AS gender_108 , c13_ . note AS note_109 , c13_ . mainEmail AS mainEmail_110 , c13_ . mainPhone AS mainPhone_111 , c13_ . mainFax AS mainFax_112 , c13_ . mainUrl AS mainUrl_113 , c13_ . id AS id_114 , c13_ . created AS created_115 , c13_ . changed AS changed_116 , m0_ . idMediaTypes AS idMediaTypes_117 , m0_ . idPreviewImage AS idPreviewImage_118 , m0_ . idCollections AS idCollections_119 , m0_ . idUsersCreator AS idUsersCreator_120 , m0_ . idUsersChanger AS idUsersChanger_121 , m2_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_122 , m2_ . idCollectionTypes AS idCollectionTypes_123 , m2_ . idCollectionsParent AS idCollectionsParent_124 , m2_ . idUsersCreator AS idUsersCreator_125 , m2_ . idUsersChanger AS idUsersChanger_126 , m3_ . idMedia AS idMedia_127 , m3_ . idUsersCreator AS idUsersCreator_128 , m3_ . idUsersChanger AS idUsersChanger_129 , m4_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130 , m4_ . idFiles AS idFiles_131 , m4_ . idUsersCreator AS idUsersCreator_132 , m4_ . idUsersChanger AS idUsersChanger_133 , t5_ . idUsersCreator AS idUsersCreator_134 , t5_ . idUsersChanger AS idUsersChanger_135 , m6_ . idFileVersions AS idFileVersions_136 , m7_ . idFileVersions AS idFileVersions_137 , m8_ . idFileVersions AS idFileVersions_138 , m9_ . idFileVersions AS idFileVersions_139 , s10_ . idContacts AS idContacts_140 , s10_ . idUsersCreator AS idUsersCreator_141 , s10_ . idUsersChanger AS idUsersChanger_142 , c11_ . idTitles AS idTitles_143 , c11_ . avatar AS avatar_144 , c11_ . idUsersCreator AS idUsersCreator_145 , c11_ . idUsersChanger AS idUsersChanger_146 , s12_ . idContacts AS idContacts_147 , s12_ . idUsersCreator AS idUsersCreator_148 , s12_ . idUsersChanger AS idUsersChanger_149 , c13_ . idTitles AS idTitles_150 , c13_ . avatar AS avatar_151 , c13_ . idUsersCreator AS idUsersCreator_152 , c13_ . idUsersChanger AS idUsersChanger_153 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 INNER JOIN me_files m3_ ON m0_ . id = m3_ . idMedia INNER JOIN me_file_versions m4_ ON m3_ . id = m4_ . idFiles AND (m4_ . version = m3_ . version ) LEFT JOIN me_file_version_tags m14_ ON m4_ . id = m14_ . idFileVersions LEFT JOIN ta_tags t5_ ON t5_ . id = m14_ . idTags LEFT JOIN me_file_version_meta m6_ ON m4_ . id = m6_ . idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_ . idFileVersionsMetaDefault = m7_ . id LEFT JOIN me_file_version_content_languages m8_ ON m4_ . id = m8_ . idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_ . id = m9_ . idFileVersions LEFT JOIN se_users s10_ ON m0_ . idUsersCreator = s10_ . id LEFT JOIN co_contacts c11_ ON s10_ . idContacts = c11_ . id LEFT JOIN se_users s12_ ON m0_ . idUsersChanger = s12_ . id LEFT JOIN co_contacts c13_ ON s12_ . idContacts = c13_ . id WHERE m0_ . id IN (? ) ORDER BY m0_ . id 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_ . title AS title_35 ,
m6_ . description AS description_36 ,
m6_ . copyright AS copyright_37 ,
m6_ . credits AS credits_38 ,
m6_ . locale AS locale_39 ,
m6_ . id AS id_40 ,
m7_ . title AS title_41 ,
m7_ . description AS description_42 ,
m7_ . copyright AS copyright_43 ,
m7_ . credits AS credits_44 ,
m7_ . locale AS locale_45 ,
m7_ . id AS id_46 ,
m8_ . locale AS locale_47 ,
m8_ . id AS id_48 ,
m9_ . locale AS locale_49 ,
m9_ . id AS id_50 ,
s10_ . username AS username_51 ,
s10_ . password AS password_52 ,
s10_ . locale AS locale_53 ,
s10_ . salt AS salt_54 ,
s10_ . locked AS locked_55 ,
s10_ . enabled AS enabled_56 ,
s10_ . lastLogin AS lastLogin_57 ,
s10_ . confirmationKey AS confirmationKey_58 ,
s10_ . passwordResetToken AS passwordResetToken_59 ,
s10_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60 ,
s10_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61 ,
s10_ . privateKey AS privateKey_62 ,
s10_ . apiKey AS apiKey_63 ,
s10_ . email AS email_64 ,
s10_ . id AS id_65 ,
s10_ . created AS created_66 ,
s10_ . changed AS changed_67 ,
c11_ . firstName AS firstName_68 ,
c11_ . middleName AS middleName_69 ,
c11_ . lastName AS lastName_70 ,
c11_ . birthday AS birthday_71 ,
c11_ . salutation AS salutation_72 ,
c11_ . formOfAddress AS formOfAddress_73 ,
c11_ . newsletter AS newsletter_74 ,
c11_ . gender AS gender_75 ,
c11_ . note AS note_76 ,
c11_ . mainEmail AS mainEmail_77 ,
c11_ . mainPhone AS mainPhone_78 ,
c11_ . mainFax AS mainFax_79 ,
c11_ . mainUrl AS mainUrl_80 ,
c11_ . id AS id_81 ,
c11_ . created AS created_82 ,
c11_ . changed AS changed_83 ,
s12_ . username AS username_84 ,
s12_ . password AS password_85 ,
s12_ . locale AS locale_86 ,
s12_ . salt AS salt_87 ,
s12_ . locked AS locked_88 ,
s12_ . enabled AS enabled_89 ,
s12_ . lastLogin AS lastLogin_90 ,
s12_ . confirmationKey AS confirmationKey_91 ,
s12_ . passwordResetToken AS passwordResetToken_92 ,
s12_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93 ,
s12_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94 ,
s12_ . privateKey AS privateKey_95 ,
s12_ . apiKey AS apiKey_96 ,
s12_ . email AS email_97 ,
s12_ . id AS id_98 ,
s12_ . created AS created_99 ,
s12_ . changed AS changed_100 ,
c13_ . firstName AS firstName_101 ,
c13_ . middleName AS middleName_102 ,
c13_ . lastName AS lastName_103 ,
c13_ . birthday AS birthday_104 ,
c13_ . salutation AS salutation_105 ,
c13_ . formOfAddress AS formOfAddress_106 ,
c13_ . newsletter AS newsletter_107 ,
c13_ . gender AS gender_108 ,
c13_ . note AS note_109 ,
c13_ . mainEmail AS mainEmail_110 ,
c13_ . mainPhone AS mainPhone_111 ,
c13_ . mainFax AS mainFax_112 ,
c13_ . mainUrl AS mainUrl_113 ,
c13_ . id AS id_114 ,
c13_ . created AS created_115 ,
c13_ . changed AS changed_116 ,
m0_ . idMediaTypes AS idMediaTypes_117 ,
m0_ . idPreviewImage AS idPreviewImage_118 ,
m0_ . idCollections AS idCollections_119 ,
m0_ . idUsersCreator AS idUsersCreator_120 ,
m0_ . idUsersChanger AS idUsersChanger_121 ,
m2_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_122 ,
m2_ . idCollectionTypes AS idCollectionTypes_123 ,
m2_ . idCollectionsParent AS idCollectionsParent_124 ,
m2_ . idUsersCreator AS idUsersCreator_125 ,
m2_ . idUsersChanger AS idUsersChanger_126 ,
m3_ . idMedia AS idMedia_127 ,
m3_ . idUsersCreator AS idUsersCreator_128 ,
m3_ . idUsersChanger AS idUsersChanger_129 ,
m4_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130 ,
m4_ . idFiles AS idFiles_131 ,
m4_ . idUsersCreator AS idUsersCreator_132 ,
m4_ . idUsersChanger AS idUsersChanger_133 ,
t5_ . idUsersCreator AS idUsersCreator_134 ,
t5_ . idUsersChanger AS idUsersChanger_135 ,
m6_ . idFileVersions AS idFileVersions_136 ,
m7_ . idFileVersions AS idFileVersions_137 ,
m8_ . idFileVersions AS idFileVersions_138 ,
m9_ . idFileVersions AS idFileVersions_139 ,
s10_ . idContacts AS idContacts_140 ,
s10_ . idUsersCreator AS idUsersCreator_141 ,
s10_ . idUsersChanger AS idUsersChanger_142 ,
c11_ . idTitles AS idTitles_143 ,
c11_ . avatar AS avatar_144 ,
c11_ . idUsersCreator AS idUsersCreator_145 ,
c11_ . idUsersChanger AS idUsersChanger_146 ,
s12_ . idContacts AS idContacts_147 ,
s12_ . idUsersCreator AS idUsersCreator_148 ,
s12_ . idUsersChanger AS idUsersChanger_149 ,
c13_ . idTitles AS idTitles_150 ,
c13_ . avatar AS avatar_151 ,
c13_ . idUsersCreator AS idUsersCreator_152 ,
c13_ . idUsersChanger AS idUsersChanger_153
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
INNER JOIN me_files m3_ ON m0_ . id = m3_ . idMedia
INNER JOIN me_file_versions m4_ ON m3_ . id = m4_ . idFiles
AND (m4_ . version = m3_ . version )
LEFT JOIN me_file_version_tags m14_ ON m4_ . id = m14_ . idFileVersions
LEFT JOIN ta_tags t5_ ON t5_ . id = m14_ . idTags
LEFT JOIN me_file_version_meta m6_ ON m4_ . id = m6_ . idFileVersions
LEFT JOIN me_file_version_meta m7_ ON m4_ . idFileVersionsMetaDefault = m7_ . id
LEFT JOIN me_file_version_content_languages m8_ ON m4_ . id = m8_ . idFileVersions
LEFT JOIN me_file_version_publish_languages m9_ ON m4_ . id = m9_ . idFileVersions
LEFT JOIN se_users s10_ ON m0_ . idUsersCreator = s10_ . id
LEFT JOIN co_contacts c11_ ON s10_ . idContacts = c11_ . id
LEFT JOIN se_users s12_ ON m0_ . idUsersChanger = s12_ . id
LEFT JOIN co_contacts c13_ ON s12_ . idContacts = c13_ . id
WHERE
m0_ . id IN (? )
ORDER BY
m0_ . id ASC Copy
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_ . title AS title_35 , m6_ . description AS description_36 , m6_ . copyright AS copyright_37 , m6_ . credits AS credits_38 , m6_ . locale AS locale_39 , m6_ . id AS id_40 , m7_ . title AS title_41 , m7_ . description AS description_42 , m7_ . copyright AS copyright_43 , m7_ . credits AS credits_44 , m7_ . locale AS locale_45 , m7_ . id AS id_46 , m8_ . locale AS locale_47 , m8_ . id AS id_48 , m9_ . locale AS locale_49 , m9_ . id AS id_50 , s10_ . username AS username_51 , s10_ . password AS password_52 , s10_ . locale AS locale_53 , s10_ . salt AS salt_54 , s10_ . locked AS locked_55 , s10_ . enabled AS enabled_56 , s10_ . lastLogin AS lastLogin_57 , s10_ . confirmationKey AS confirmationKey_58 , s10_ . passwordResetToken AS passwordResetToken_59 , s10_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60 , s10_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61 , s10_ . privateKey AS privateKey_62 , s10_ . apiKey AS apiKey_63 , s10_ . email AS email_64 , s10_ . id AS id_65 , s10_ . created AS created_66 , s10_ . changed AS changed_67 , c11_ . firstName AS firstName_68 , c11_ . middleName AS middleName_69 , c11_ . lastName AS lastName_70 , c11_ . birthday AS birthday_71 , c11_ . salutation AS salutation_72 , c11_ . formOfAddress AS formOfAddress_73 , c11_ . newsletter AS newsletter_74 , c11_ . gender AS gender_75 , c11_ . note AS note_76 , c11_ . mainEmail AS mainEmail_77 , c11_ . mainPhone AS mainPhone_78 , c11_ . mainFax AS mainFax_79 , c11_ . mainUrl AS mainUrl_80 , c11_ . id AS id_81 , c11_ . created AS created_82 , c11_ . changed AS changed_83 , s12_ . username AS username_84 , s12_ . password AS password_85 , s12_ . locale AS locale_86 , s12_ . salt AS salt_87 , s12_ . locked AS locked_88 , s12_ . enabled AS enabled_89 , s12_ . lastLogin AS lastLogin_90 , s12_ . confirmationKey AS confirmationKey_91 , s12_ . passwordResetToken AS passwordResetToken_92 , s12_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93 , s12_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94 , s12_ . privateKey AS privateKey_95 , s12_ . apiKey AS apiKey_96 , s12_ . email AS email_97 , s12_ . id AS id_98 , s12_ . created AS created_99 , s12_ . changed AS changed_100 , c13_ . firstName AS firstName_101 , c13_ . middleName AS middleName_102 , c13_ . lastName AS lastName_103 , c13_ . birthday AS birthday_104 , c13_ . salutation AS salutation_105 , c13_ . formOfAddress AS formOfAddress_106 , c13_ . newsletter AS newsletter_107 , c13_ . gender AS gender_108 , c13_ . note AS note_109 , c13_ . mainEmail AS mainEmail_110 , c13_ . mainPhone AS mainPhone_111 , c13_ . mainFax AS mainFax_112 , c13_ . mainUrl AS mainUrl_113 , c13_ . id AS id_114 , c13_ . created AS created_115 , c13_ . changed AS changed_116 , m0_ . idMediaTypes AS idMediaTypes_117 , m0_ . idPreviewImage AS idPreviewImage_118 , m0_ . idCollections AS idCollections_119 , m0_ . idUsersCreator AS idUsersCreator_120 , m0_ . idUsersChanger AS idUsersChanger_121 , m2_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_122 , m2_ . idCollectionTypes AS idCollectionTypes_123 , m2_ . idCollectionsParent AS idCollectionsParent_124 , m2_ . idUsersCreator AS idUsersCreator_125 , m2_ . idUsersChanger AS idUsersChanger_126 , m3_ . idMedia AS idMedia_127 , m3_ . idUsersCreator AS idUsersCreator_128 , m3_ . idUsersChanger AS idUsersChanger_129 , m4_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130 , m4_ . idFiles AS idFiles_131 , m4_ . idUsersCreator AS idUsersCreator_132 , m4_ . idUsersChanger AS idUsersChanger_133 , t5_ . idUsersCreator AS idUsersCreator_134 , t5_ . idUsersChanger AS idUsersChanger_135 , m6_ . idFileVersions AS idFileVersions_136 , m7_ . idFileVersions AS idFileVersions_137 , m8_ . idFileVersions AS idFileVersions_138 , m9_ . idFileVersions AS idFileVersions_139 , s10_ . idContacts AS idContacts_140 , s10_ . idUsersCreator AS idUsersCreator_141 , s10_ . idUsersChanger AS idUsersChanger_142 , c11_ . idTitles AS idTitles_143 , c11_ . avatar AS avatar_144 , c11_ . idUsersCreator AS idUsersCreator_145 , c11_ . idUsersChanger AS idUsersChanger_146 , s12_ . idContacts AS idContacts_147 , s12_ . idUsersCreator AS idUsersCreator_148 , s12_ . idUsersChanger AS idUsersChanger_149 , c13_ . idTitles AS idTitles_150 , c13_ . avatar AS avatar_151 , c13_ . idUsersCreator AS idUsersCreator_152 , c13_ . idUsersChanger AS idUsersChanger_153 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 INNER JOIN me_files m3_ ON m0_ . id = m3_ . idMedia INNER JOIN me_file_versions m4_ ON m3_ . id = m4_ . idFiles AND (m4_ . version = m3_ . version ) LEFT JOIN me_file_version_tags m14_ ON m4_ . id = m14_ . idFileVersions LEFT JOIN ta_tags t5_ ON t5_ . id = m14_ . idTags LEFT JOIN me_file_version_meta m6_ ON m4_ . id = m6_ . idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_ . idFileVersionsMetaDefault = m7_ . id LEFT JOIN me_file_version_content_languages m8_ ON m4_ . id = m8_ . idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_ . id = m9_ . idFileVersions LEFT JOIN se_users s10_ ON m0_ . idUsersCreator = s10_ . id LEFT JOIN co_contacts c11_ ON s10_ . idContacts = c11_ . id LEFT JOIN se_users s12_ ON m0_ . idUsersChanger = s12_ . id LEFT JOIN co_contacts c13_ ON s12_ . idContacts = c13_ . id WHERE m0_ . id IN (81 ) ORDER BY m0_ . id ASC ; Copy
22
16.01 ms
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 EXTRACTVALUE (n0 . props , 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="main"]) > 0' )) AND n0 . path LIKE '/cmf/pgcdoe/contents/%' )) ORDER BY CAST (EXTRACTVALUE (n0 . numerical_props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC , EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC
Parameters :
[
"default_live "
]
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 EXTRACTVALUE (n0 . props , 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="main"]) > 0' )) AND n0 . path LIKE '/cmf/pgcdoe/contents/%' )) ORDER BY CAST (EXTRACTVALUE (n0 . numerical_props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC , EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC ; Copy
23
2.82 ms
SELECT path AS arraykey , id , path , parent , local_name , namespace , workspace_name , identifier , type , props , depth , sort_order
FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? ) ORDER BY sort_order ASC
Parameters :
[
"default_live "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/watersheds-and-total-maximum-daily-load-tmdl-within-prince-george-s-county "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/nutrients-and-sediment "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/watershed-implementation-plans-and-assessments "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/other-pollutants "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/community-public-engagement "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/biological-monitoring "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/npdes-ms4-permit-and-progress "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/stream-channel-monitoring "
]
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/pgcdoe/contents/ms4-watershed-activities/watershed-management/watersheds-and-total-maximum-daily-load-tmdl-within-prince-george-s-county' OR path = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/nutrients-and-sediment' OR path = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/watershed-implementation-plans-and-assessments' OR path = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/other-pollutants' OR path = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management' OR path = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/community-public-engagement' OR path = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring' OR path = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/biological-monitoring' OR path = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/npdes-ms4-permit-and-progress' OR path = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/stream-channel-monitoring' ) ORDER BY sort_order ASC ; Copy
24
1.72 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/watersheds-and-total-maximum-daily-load-tmdl-within-prince-george-s-county "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/nutrients-and-sediment "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/watershed-implementation-plans-and-assessments "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/other-pollutants "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/community-public-engagement "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/biological-monitoring "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/npdes-ms4-permit-and-progress "
"/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/stream-channel-monitoring "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management' , '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring' , '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/watersheds-and-total-maximum-daily-load-tmdl-within-prince-george-s-county' , '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/nutrients-and-sediment' , '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/watershed-implementation-plans-and-assessments' , '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/other-pollutants' , '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/community-public-engagement' , '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/biological-monitoring' , '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management/npdes-ms4-permit-and-progress' , '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring/stream-channel-monitoring' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
25
1.37 ms
SELECT id , path , parent , local_name , namespace , workspace_name , identifier , type , props , depth , sort_order
FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (? )
Parameters :
[
"default_live "
"70653cc1-b186-4b69-8a14-bd50d30cbb88 "
]
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 ('70653cc1-b186-4b69-8a14-bd50d30cbb88' ); Copy
26
1.35 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/snippets/footer/footer "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/footer/footer' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
27
1.02 ms
SELECT * FROM phpcr_nodes
WHERE path = ?
AND workspace_name = ?
ORDER BY depth , sort_order ASC
Parameters :
[
"/cmf/snippets/footer "
"default_live "
]
SELECT * FROM phpcr_nodes
WHERE path = '/cmf/snippets/footer'
AND workspace_name = 'default_live'
ORDER BY depth , sort_order ASC ; Copy
28
1.11 ms
SELECT path , parent FROM phpcr_nodes WHERE parent IN (? ) AND workspace_name = ? ORDER BY sort_order ASC
Parameters :
[
"/cmf/snippets/footer "
"default_live "
]
SELECT path , parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/footer' ) AND workspace_name = 'default_live' ORDER BY sort_order ASC ; Copy
29
3.88 ms
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_ . title AS title_35 , m6_ . description AS description_36 , m6_ . copyright AS copyright_37 , m6_ . credits AS credits_38 , m6_ . locale AS locale_39 , m6_ . id AS id_40 , m7_ . title AS title_41 , m7_ . description AS description_42 , m7_ . copyright AS copyright_43 , m7_ . credits AS credits_44 , m7_ . locale AS locale_45 , m7_ . id AS id_46 , m8_ . locale AS locale_47 , m8_ . id AS id_48 , m9_ . locale AS locale_49 , m9_ . id AS id_50 , s10_ . username AS username_51 , s10_ . password AS password_52 , s10_ . locale AS locale_53 , s10_ . salt AS salt_54 , s10_ . locked AS locked_55 , s10_ . enabled AS enabled_56 , s10_ . lastLogin AS lastLogin_57 , s10_ . confirmationKey AS confirmationKey_58 , s10_ . passwordResetToken AS passwordResetToken_59 , s10_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60 , s10_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61 , s10_ . privateKey AS privateKey_62 , s10_ . apiKey AS apiKey_63 , s10_ . email AS email_64 , s10_ . id AS id_65 , s10_ . created AS created_66 , s10_ . changed AS changed_67 , c11_ . firstName AS firstName_68 , c11_ . middleName AS middleName_69 , c11_ . lastName AS lastName_70 , c11_ . birthday AS birthday_71 , c11_ . salutation AS salutation_72 , c11_ . formOfAddress AS formOfAddress_73 , c11_ . newsletter AS newsletter_74 , c11_ . gender AS gender_75 , c11_ . note AS note_76 , c11_ . mainEmail AS mainEmail_77 , c11_ . mainPhone AS mainPhone_78 , c11_ . mainFax AS mainFax_79 , c11_ . mainUrl AS mainUrl_80 , c11_ . id AS id_81 , c11_ . created AS created_82 , c11_ . changed AS changed_83 , s12_ . username AS username_84 , s12_ . password AS password_85 , s12_ . locale AS locale_86 , s12_ . salt AS salt_87 , s12_ . locked AS locked_88 , s12_ . enabled AS enabled_89 , s12_ . lastLogin AS lastLogin_90 , s12_ . confirmationKey AS confirmationKey_91 , s12_ . passwordResetToken AS passwordResetToken_92 , s12_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93 , s12_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94 , s12_ . privateKey AS privateKey_95 , s12_ . apiKey AS apiKey_96 , s12_ . email AS email_97 , s12_ . id AS id_98 , s12_ . created AS created_99 , s12_ . changed AS changed_100 , c13_ . firstName AS firstName_101 , c13_ . middleName AS middleName_102 , c13_ . lastName AS lastName_103 , c13_ . birthday AS birthday_104 , c13_ . salutation AS salutation_105 , c13_ . formOfAddress AS formOfAddress_106 , c13_ . newsletter AS newsletter_107 , c13_ . gender AS gender_108 , c13_ . note AS note_109 , c13_ . mainEmail AS mainEmail_110 , c13_ . mainPhone AS mainPhone_111 , c13_ . mainFax AS mainFax_112 , c13_ . mainUrl AS mainUrl_113 , c13_ . id AS id_114 , c13_ . created AS created_115 , c13_ . changed AS changed_116 , m0_ . idMediaTypes AS idMediaTypes_117 , m0_ . idPreviewImage AS idPreviewImage_118 , m0_ . idCollections AS idCollections_119 , m0_ . idUsersCreator AS idUsersCreator_120 , m0_ . idUsersChanger AS idUsersChanger_121 , m2_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_122 , m2_ . idCollectionTypes AS idCollectionTypes_123 , m2_ . idCollectionsParent AS idCollectionsParent_124 , m2_ . idUsersCreator AS idUsersCreator_125 , m2_ . idUsersChanger AS idUsersChanger_126 , m3_ . idMedia AS idMedia_127 , m3_ . idUsersCreator AS idUsersCreator_128 , m3_ . idUsersChanger AS idUsersChanger_129 , m4_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130 , m4_ . idFiles AS idFiles_131 , m4_ . idUsersCreator AS idUsersCreator_132 , m4_ . idUsersChanger AS idUsersChanger_133 , t5_ . idUsersCreator AS idUsersCreator_134 , t5_ . idUsersChanger AS idUsersChanger_135 , m6_ . idFileVersions AS idFileVersions_136 , m7_ . idFileVersions AS idFileVersions_137 , m8_ . idFileVersions AS idFileVersions_138 , m9_ . idFileVersions AS idFileVersions_139 , s10_ . idContacts AS idContacts_140 , s10_ . idUsersCreator AS idUsersCreator_141 , s10_ . idUsersChanger AS idUsersChanger_142 , c11_ . idTitles AS idTitles_143 , c11_ . avatar AS avatar_144 , c11_ . idUsersCreator AS idUsersCreator_145 , c11_ . idUsersChanger AS idUsersChanger_146 , s12_ . idContacts AS idContacts_147 , s12_ . idUsersCreator AS idUsersCreator_148 , s12_ . idUsersChanger AS idUsersChanger_149 , c13_ . idTitles AS idTitles_150 , c13_ . avatar AS avatar_151 , c13_ . idUsersCreator AS idUsersCreator_152 , c13_ . idUsersChanger AS idUsersChanger_153 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 INNER JOIN me_files m3_ ON m0_ . id = m3_ . idMedia INNER JOIN me_file_versions m4_ ON m3_ . id = m4_ . idFiles AND (m4_ . version = m3_ . version ) LEFT JOIN me_file_version_tags m14_ ON m4_ . id = m14_ . idFileVersions LEFT JOIN ta_tags t5_ ON t5_ . id = m14_ . idTags LEFT JOIN me_file_version_meta m6_ ON m4_ . id = m6_ . idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_ . idFileVersionsMetaDefault = m7_ . id LEFT JOIN me_file_version_content_languages m8_ ON m4_ . id = m8_ . idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_ . id = m9_ . idFileVersions LEFT JOIN se_users s10_ ON m0_ . idUsersCreator = s10_ . id LEFT JOIN co_contacts c11_ ON s10_ . idContacts = c11_ . id LEFT JOIN se_users s12_ ON m0_ . idUsersChanger = s12_ . id LEFT JOIN co_contacts c13_ ON s12_ . idContacts = c13_ . id WHERE m0_ . id IN (? ) ORDER BY m0_ . id 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_ . title AS title_35 ,
m6_ . description AS description_36 ,
m6_ . copyright AS copyright_37 ,
m6_ . credits AS credits_38 ,
m6_ . locale AS locale_39 ,
m6_ . id AS id_40 ,
m7_ . title AS title_41 ,
m7_ . description AS description_42 ,
m7_ . copyright AS copyright_43 ,
m7_ . credits AS credits_44 ,
m7_ . locale AS locale_45 ,
m7_ . id AS id_46 ,
m8_ . locale AS locale_47 ,
m8_ . id AS id_48 ,
m9_ . locale AS locale_49 ,
m9_ . id AS id_50 ,
s10_ . username AS username_51 ,
s10_ . password AS password_52 ,
s10_ . locale AS locale_53 ,
s10_ . salt AS salt_54 ,
s10_ . locked AS locked_55 ,
s10_ . enabled AS enabled_56 ,
s10_ . lastLogin AS lastLogin_57 ,
s10_ . confirmationKey AS confirmationKey_58 ,
s10_ . passwordResetToken AS passwordResetToken_59 ,
s10_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60 ,
s10_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61 ,
s10_ . privateKey AS privateKey_62 ,
s10_ . apiKey AS apiKey_63 ,
s10_ . email AS email_64 ,
s10_ . id AS id_65 ,
s10_ . created AS created_66 ,
s10_ . changed AS changed_67 ,
c11_ . firstName AS firstName_68 ,
c11_ . middleName AS middleName_69 ,
c11_ . lastName AS lastName_70 ,
c11_ . birthday AS birthday_71 ,
c11_ . salutation AS salutation_72 ,
c11_ . formOfAddress AS formOfAddress_73 ,
c11_ . newsletter AS newsletter_74 ,
c11_ . gender AS gender_75 ,
c11_ . note AS note_76 ,
c11_ . mainEmail AS mainEmail_77 ,
c11_ . mainPhone AS mainPhone_78 ,
c11_ . mainFax AS mainFax_79 ,
c11_ . mainUrl AS mainUrl_80 ,
c11_ . id AS id_81 ,
c11_ . created AS created_82 ,
c11_ . changed AS changed_83 ,
s12_ . username AS username_84 ,
s12_ . password AS password_85 ,
s12_ . locale AS locale_86 ,
s12_ . salt AS salt_87 ,
s12_ . locked AS locked_88 ,
s12_ . enabled AS enabled_89 ,
s12_ . lastLogin AS lastLogin_90 ,
s12_ . confirmationKey AS confirmationKey_91 ,
s12_ . passwordResetToken AS passwordResetToken_92 ,
s12_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93 ,
s12_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94 ,
s12_ . privateKey AS privateKey_95 ,
s12_ . apiKey AS apiKey_96 ,
s12_ . email AS email_97 ,
s12_ . id AS id_98 ,
s12_ . created AS created_99 ,
s12_ . changed AS changed_100 ,
c13_ . firstName AS firstName_101 ,
c13_ . middleName AS middleName_102 ,
c13_ . lastName AS lastName_103 ,
c13_ . birthday AS birthday_104 ,
c13_ . salutation AS salutation_105 ,
c13_ . formOfAddress AS formOfAddress_106 ,
c13_ . newsletter AS newsletter_107 ,
c13_ . gender AS gender_108 ,
c13_ . note AS note_109 ,
c13_ . mainEmail AS mainEmail_110 ,
c13_ . mainPhone AS mainPhone_111 ,
c13_ . mainFax AS mainFax_112 ,
c13_ . mainUrl AS mainUrl_113 ,
c13_ . id AS id_114 ,
c13_ . created AS created_115 ,
c13_ . changed AS changed_116 ,
m0_ . idMediaTypes AS idMediaTypes_117 ,
m0_ . idPreviewImage AS idPreviewImage_118 ,
m0_ . idCollections AS idCollections_119 ,
m0_ . idUsersCreator AS idUsersCreator_120 ,
m0_ . idUsersChanger AS idUsersChanger_121 ,
m2_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_122 ,
m2_ . idCollectionTypes AS idCollectionTypes_123 ,
m2_ . idCollectionsParent AS idCollectionsParent_124 ,
m2_ . idUsersCreator AS idUsersCreator_125 ,
m2_ . idUsersChanger AS idUsersChanger_126 ,
m3_ . idMedia AS idMedia_127 ,
m3_ . idUsersCreator AS idUsersCreator_128 ,
m3_ . idUsersChanger AS idUsersChanger_129 ,
m4_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130 ,
m4_ . idFiles AS idFiles_131 ,
m4_ . idUsersCreator AS idUsersCreator_132 ,
m4_ . idUsersChanger AS idUsersChanger_133 ,
t5_ . idUsersCreator AS idUsersCreator_134 ,
t5_ . idUsersChanger AS idUsersChanger_135 ,
m6_ . idFileVersions AS idFileVersions_136 ,
m7_ . idFileVersions AS idFileVersions_137 ,
m8_ . idFileVersions AS idFileVersions_138 ,
m9_ . idFileVersions AS idFileVersions_139 ,
s10_ . idContacts AS idContacts_140 ,
s10_ . idUsersCreator AS idUsersCreator_141 ,
s10_ . idUsersChanger AS idUsersChanger_142 ,
c11_ . idTitles AS idTitles_143 ,
c11_ . avatar AS avatar_144 ,
c11_ . idUsersCreator AS idUsersCreator_145 ,
c11_ . idUsersChanger AS idUsersChanger_146 ,
s12_ . idContacts AS idContacts_147 ,
s12_ . idUsersCreator AS idUsersCreator_148 ,
s12_ . idUsersChanger AS idUsersChanger_149 ,
c13_ . idTitles AS idTitles_150 ,
c13_ . avatar AS avatar_151 ,
c13_ . idUsersCreator AS idUsersCreator_152 ,
c13_ . idUsersChanger AS idUsersChanger_153
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
INNER JOIN me_files m3_ ON m0_ . id = m3_ . idMedia
INNER JOIN me_file_versions m4_ ON m3_ . id = m4_ . idFiles
AND (m4_ . version = m3_ . version )
LEFT JOIN me_file_version_tags m14_ ON m4_ . id = m14_ . idFileVersions
LEFT JOIN ta_tags t5_ ON t5_ . id = m14_ . idTags
LEFT JOIN me_file_version_meta m6_ ON m4_ . id = m6_ . idFileVersions
LEFT JOIN me_file_version_meta m7_ ON m4_ . idFileVersionsMetaDefault = m7_ . id
LEFT JOIN me_file_version_content_languages m8_ ON m4_ . id = m8_ . idFileVersions
LEFT JOIN me_file_version_publish_languages m9_ ON m4_ . id = m9_ . idFileVersions
LEFT JOIN se_users s10_ ON m0_ . idUsersCreator = s10_ . id
LEFT JOIN co_contacts c11_ ON s10_ . idContacts = c11_ . id
LEFT JOIN se_users s12_ ON m0_ . idUsersChanger = s12_ . id
LEFT JOIN co_contacts c13_ ON s12_ . idContacts = c13_ . id
WHERE
m0_ . id IN (? )
ORDER BY
m0_ . id ASC Copy
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_ . title AS title_35 , m6_ . description AS description_36 , m6_ . copyright AS copyright_37 , m6_ . credits AS credits_38 , m6_ . locale AS locale_39 , m6_ . id AS id_40 , m7_ . title AS title_41 , m7_ . description AS description_42 , m7_ . copyright AS copyright_43 , m7_ . credits AS credits_44 , m7_ . locale AS locale_45 , m7_ . id AS id_46 , m8_ . locale AS locale_47 , m8_ . id AS id_48 , m9_ . locale AS locale_49 , m9_ . id AS id_50 , s10_ . username AS username_51 , s10_ . password AS password_52 , s10_ . locale AS locale_53 , s10_ . salt AS salt_54 , s10_ . locked AS locked_55 , s10_ . enabled AS enabled_56 , s10_ . lastLogin AS lastLogin_57 , s10_ . confirmationKey AS confirmationKey_58 , s10_ . passwordResetToken AS passwordResetToken_59 , s10_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60 , s10_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61 , s10_ . privateKey AS privateKey_62 , s10_ . apiKey AS apiKey_63 , s10_ . email AS email_64 , s10_ . id AS id_65 , s10_ . created AS created_66 , s10_ . changed AS changed_67 , c11_ . firstName AS firstName_68 , c11_ . middleName AS middleName_69 , c11_ . lastName AS lastName_70 , c11_ . birthday AS birthday_71 , c11_ . salutation AS salutation_72 , c11_ . formOfAddress AS formOfAddress_73 , c11_ . newsletter AS newsletter_74 , c11_ . gender AS gender_75 , c11_ . note AS note_76 , c11_ . mainEmail AS mainEmail_77 , c11_ . mainPhone AS mainPhone_78 , c11_ . mainFax AS mainFax_79 , c11_ . mainUrl AS mainUrl_80 , c11_ . id AS id_81 , c11_ . created AS created_82 , c11_ . changed AS changed_83 , s12_ . username AS username_84 , s12_ . password AS password_85 , s12_ . locale AS locale_86 , s12_ . salt AS salt_87 , s12_ . locked AS locked_88 , s12_ . enabled AS enabled_89 , s12_ . lastLogin AS lastLogin_90 , s12_ . confirmationKey AS confirmationKey_91 , s12_ . passwordResetToken AS passwordResetToken_92 , s12_ . passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93 , s12_ . passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94 , s12_ . privateKey AS privateKey_95 , s12_ . apiKey AS apiKey_96 , s12_ . email AS email_97 , s12_ . id AS id_98 , s12_ . created AS created_99 , s12_ . changed AS changed_100 , c13_ . firstName AS firstName_101 , c13_ . middleName AS middleName_102 , c13_ . lastName AS lastName_103 , c13_ . birthday AS birthday_104 , c13_ . salutation AS salutation_105 , c13_ . formOfAddress AS formOfAddress_106 , c13_ . newsletter AS newsletter_107 , c13_ . gender AS gender_108 , c13_ . note AS note_109 , c13_ . mainEmail AS mainEmail_110 , c13_ . mainPhone AS mainPhone_111 , c13_ . mainFax AS mainFax_112 , c13_ . mainUrl AS mainUrl_113 , c13_ . id AS id_114 , c13_ . created AS created_115 , c13_ . changed AS changed_116 , m0_ . idMediaTypes AS idMediaTypes_117 , m0_ . idPreviewImage AS idPreviewImage_118 , m0_ . idCollections AS idCollections_119 , m0_ . idUsersCreator AS idUsersCreator_120 , m0_ . idUsersChanger AS idUsersChanger_121 , m2_ . idCollectionsMetaDefault AS idCollectionsMetaDefault_122 , m2_ . idCollectionTypes AS idCollectionTypes_123 , m2_ . idCollectionsParent AS idCollectionsParent_124 , m2_ . idUsersCreator AS idUsersCreator_125 , m2_ . idUsersChanger AS idUsersChanger_126 , m3_ . idMedia AS idMedia_127 , m3_ . idUsersCreator AS idUsersCreator_128 , m3_ . idUsersChanger AS idUsersChanger_129 , m4_ . idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130 , m4_ . idFiles AS idFiles_131 , m4_ . idUsersCreator AS idUsersCreator_132 , m4_ . idUsersChanger AS idUsersChanger_133 , t5_ . idUsersCreator AS idUsersCreator_134 , t5_ . idUsersChanger AS idUsersChanger_135 , m6_ . idFileVersions AS idFileVersions_136 , m7_ . idFileVersions AS idFileVersions_137 , m8_ . idFileVersions AS idFileVersions_138 , m9_ . idFileVersions AS idFileVersions_139 , s10_ . idContacts AS idContacts_140 , s10_ . idUsersCreator AS idUsersCreator_141 , s10_ . idUsersChanger AS idUsersChanger_142 , c11_ . idTitles AS idTitles_143 , c11_ . avatar AS avatar_144 , c11_ . idUsersCreator AS idUsersCreator_145 , c11_ . idUsersChanger AS idUsersChanger_146 , s12_ . idContacts AS idContacts_147 , s12_ . idUsersCreator AS idUsersCreator_148 , s12_ . idUsersChanger AS idUsersChanger_149 , c13_ . idTitles AS idTitles_150 , c13_ . avatar AS avatar_151 , c13_ . idUsersCreator AS idUsersCreator_152 , c13_ . idUsersChanger AS idUsersChanger_153 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 INNER JOIN me_files m3_ ON m0_ . id = m3_ . idMedia INNER JOIN me_file_versions m4_ ON m3_ . id = m4_ . idFiles AND (m4_ . version = m3_ . version ) LEFT JOIN me_file_version_tags m14_ ON m4_ . id = m14_ . idFileVersions LEFT JOIN ta_tags t5_ ON t5_ . id = m14_ . idTags LEFT JOIN me_file_version_meta m6_ ON m4_ . id = m6_ . idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_ . idFileVersionsMetaDefault = m7_ . id LEFT JOIN me_file_version_content_languages m8_ ON m4_ . id = m8_ . idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_ . id = m9_ . idFileVersions LEFT JOIN se_users s10_ ON m0_ . idUsersCreator = s10_ . id LEFT JOIN co_contacts c11_ ON s10_ . idContacts = c11_ . id LEFT JOIN se_users s12_ ON m0_ . idUsersChanger = s12_ . id LEFT JOIN co_contacts c13_ ON s12_ . idContacts = c13_ . id WHERE m0_ . id IN (66 ) ORDER BY m0_ . id ASC ; Copy
30
1.20 ms
SELECT w0_ . title AS title_0 , w0_ . webspace_key AS webspace_key_1 , w0_ . all_domains AS all_domains_2 , w0_ . content AS content_3 , w0_ . type AS type_4 , w0_ . id AS id_5 , w1_ . url AS url_6 , w1_ . environment AS environment_7 , w1_ . id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_ . id = w2_ . analytics LEFT JOIN we_domains w1_ ON w1_ . id = w2_ . domain WHERE (w0_ . all_domains = 1 OR (w1_ . url = ? AND w1_ . environment = ? )) AND w0_ . webspace_key = ? ORDER BY w0_ . id ASC
Parameters :
[
"dev.pgcdoe.net "
"dev "
"pgcdoe "
]
SELECT w0_ . title AS title_0 , w0_ . webspace_key AS webspace_key_1 , w0_ . all_domains AS all_domains_2 , w0_ . content AS content_3 , w0_ . type AS type_4 , w0_ . id AS id_5 , w1_ . url AS url_6 , w1_ . environment AS environment_7 , w1_ . id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_ . id = w2_ . analytics LEFT JOIN we_domains w1_ ON w1_ . id = w2_ . domain WHERE (w0_ . all_domains = 1 OR (w1_ . url = 'dev.pgcdoe.net' AND w1_ . environment = 'dev' )) AND w0_ . webspace_key = 'pgcdoe' ORDER BY w0_ . id ASC ; Copy
31
2.96 ms
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 ((n0 . identifier = '198ba57c-a5b7-41a6-b810-868a12963c85' OR n0 . identifier = 'fca02e3d-0ff0-4e83-9c62-054515e0d0a0' ) AND 0 ! = FIND_IN_SET ('2' , REPLACE (EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="i18n:en-state"]/sv:value' ), ' ' , ',' ))) ORDER BY CAST (EXTRACTVALUE (n0 . numerical_props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC , EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC
Parameters :
[
"default_live "
]
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 ((n0 . identifier = '198ba57c-a5b7-41a6-b810-868a12963c85' OR n0 . identifier = 'fca02e3d-0ff0-4e83-9c62-054515e0d0a0' ) AND 0 ! = FIND_IN_SET ('2' , REPLACE (EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="i18n:en-state"]/sv:value' ), ' ' , ',' ))) ORDER BY CAST (EXTRACTVALUE (n0 . numerical_props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC , EXTRACTVALUE (n0 . props , '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC ; Copy
32
2.25 ms
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 n0 . parent = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management' LIMIT 1
Parameters :
[
"default_live "
]
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 n0 . parent = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-management' LIMIT 1 ; Copy
33
1.19 ms
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 n0 . parent = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring' LIMIT 1
Parameters :
[
"default_live "
]
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 n0 . parent = '/cmf/pgcdoe/contents/ms4-watershed-activities/watershed-monitoring' LIMIT 1 ; Copy