Query Metrics
57
Database Queries
12
Different statements
85.71 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.20 ms |
SELECT d0_.id AS id_0, d0_.enabled AS enabled_1, d0_.sarrera_agortuta AS sarrera_agortuta_2, d0_.sarrera_mota AS sarrera_mota_3, d0_.taldea AS taldea_4, d0_.url AS url_5, d0_.eguna AS eguna_6, d0_.ordua_hasiera AS ordua_hasiera_7, d0_.ordua_amaiera AS ordua_amaiera_8, d0_.bideo_id AS bideo_id_9, d0_.bideo_url AS bideo_url_10, d0_.created AS created_11, d0_.changed AS changed_12, d0_.mota_id AS mota_id_13, d0_.gunea_id AS gunea_id_14, d0_.antolatzailea_id AS antolatzailea_id_15, d0_.irudia_id AS irudia_id_16, d0_.irudia2_id AS irudia2_id_17, d0_.idUsersCreator AS idUsersCreator_18, d0_.idUsersChanger AS idUsersChanger_19 FROM da_egitaraua d0_ LEFT JOIN da_egitaraua_translations d1_ ON d0_.id = d1_.egitaraua_id WHERE d0_.bideo_id > ? AND d0_.enabled = 1 ORDER BY d0_.eguna DESC, d0_.ordua_hasiera DESC, d0_.ordua_amaiera DESC
Parameters:
[
0
]
|
| 2 | 1.14 ms |
SELECT d0_.id AS id_0, d0_.enabled AS enabled_1, d0_.bideo_id AS bideo_id_2, d0_.eguna AS eguna_3, d0_.created AS created_4, d0_.changed AS changed_5, d0_.idUsersCreator AS idUsersCreator_6, d0_.idUsersChanger AS idUsersChanger_7 FROM da_bideoak d0_ LEFT JOIN da_bideoak_translations d1_ ON d0_.id = d1_.bideoa_id WHERE d0_.bideo_id > ? AND d0_.enabled = 1 ORDER BY d0_.eguna DESC, d0_.id ASC
Parameters:
[
0
]
|
| 3 | 0.68 ms |
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
"default_live"
]
|
| 4 | 0.47 ms |
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[] |
| 5 | 0.74 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
Parameters:
[] |
| 6 | 0.71 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
Parameters:
[] |
| 7 | 60.29 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:eu-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:eu-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:eu-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/da/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"
]
|
| 8 | 1.14 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 = :workspace AND (path = :path0 OR path = :path1 OR path = :path2 OR path = :path3 OR path = :path4) ORDER BY sort_order ASC
Parameters:
[ "workspace" => "default_live" "path0" => "/cmf/da/contents/azoka2" "path1" => "/cmf/da/contents/ikasle-goiza-1" "path2" => "/cmf/da/contents/sormen-beka" "path3" => "/cmf/da/contents/albisteak" "path4" => "/cmf/da/contents/dapro-1" ] |
| 9 | 2.17 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
[
"/cmf/da/contents/azoka2"
"/cmf/da/contents/ikasle-goiza-1"
"/cmf/da/contents/sormen-beka"
"/cmf/da/contents/albisteak"
"/cmf/da/contents/dapro-1"
]
"default_live"
]
|
| 10 | 0.65 ms |
SELECT * FROM phpcr_nodes WHERE path = :path AND workspace_name = :workspace ORDER BY depth, sort_order ASC
Parameters:
[ "path" => "/cmf/da/contents" "pathd" => "/cmf/da/contents/%" "workspace" => "default_live" ] |
| 11 | 0.70 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
[
"/cmf/da/contents"
]
"default_live"
]
|
| 12 | 0.60 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
100
]
|
| 13 | 0.27 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
101
]
|
| 14 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
102
]
|
| 15 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
103
]
|
| 16 | 0.26 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
104
]
|
| 17 | 0.27 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
105
]
|
| 18 | 0.26 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
106
]
|
| 19 | 0.26 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
107
]
|
| 20 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
108
]
|
| 21 | 0.26 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
109
]
|
| 22 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
92
]
|
| 23 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
93
]
|
| 24 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
94
]
|
| 25 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
95
]
|
| 26 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
96
]
|
| 27 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
97
]
|
| 28 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
98
]
|
| 29 | 0.26 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
99
]
|
| 30 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
111
]
|
| 31 | 0.31 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
83
]
|
| 32 | 0.27 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
84
]
|
| 33 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
85
]
|
| 34 | 0.29 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
86
]
|
| 35 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
87
]
|
| 36 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
88
]
|
| 37 | 0.27 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
90
]
|
| 38 | 0.28 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
91
]
|
| 39 | 0.30 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
112
]
|
| 40 | 0.26 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
75
]
|
| 41 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
76
]
|
| 42 | 0.26 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
77
]
|
| 43 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
78
]
|
| 44 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
79
]
|
| 45 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
80
]
|
| 46 | 0.26 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
81
]
|
| 47 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
82
]
|
| 48 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.locale AS locale_3, t0.created AS created_4, t0.changed AS changed_5, t0.bideoa_id AS bideoa_id_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM da_bideoak_translations t0 WHERE t0.bideoa_id = ?
Parameters:
[
110
]
|
| 49 | 0.42 ms |
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters:
[ "0a44832f-67ab-45a6-9ec3-4485f63d0b00" "default_live" ] |
| 50 | 0.55 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
[
"/cmf/da/contents/lege-oharra"
]
"default_live"
]
|
| 51 | 0.99 ms |
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters:
[ "b505338e-d25c-4161-b2dd-fad465063f25" "default_live" ] |
| 52 | 0.81 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
[
"/cmf/da/contents/datu-pertsonalak"
]
"default_live"
]
|
| 53 | 0.78 ms |
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters:
[ "eedc8df5-31cf-4598-a699-70363a663605" "default_live" ] |
| 54 | 0.66 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
[
"/cmf/da/contents/politica-de-privacidad"
]
"default_live"
]
|
| 55 | 0.47 ms |
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters:
[ "e54c4af4-276b-4cfc-8a1e-5e6d097351f7" "default_live" ] |
| 56 | 0.43 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
[
"/cmf/da/contents/cookien-erabilera"
]
"default_live"
]
|
| 57 | 0.73 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:
[ "da.wdemo.net/{language}" "dev" "da" ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| Sulu\Bundle\MediaBundle\Entity\Collection | No errors. |
| Sulu\Bundle\ContactBundle\Entity\ContactTitle | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\Group | No errors. |
| App\Entity\Egitaraua\Egitaraua | No errors. |
| App\Entity\Bideoa\Bideoa | No errors. |
| App\Entity\Gunea | No errors. |
| App\Entity\Egitaraua\Mota | No errors. |
| App\Entity\Egitaraua\EgitarauaTranslation | No errors. |
| App\Entity\Egitaraua\Antolatzailea | No errors. |
| Sulu\Bundle\MediaBundle\Entity\Media | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\User | No errors. |
| App\Entity\Bideoa\BideoaTranslation | No errors. |
| Sulu\Bundle\WebsiteBundle\Entity\Analytics | No errors. |
| Sulu\Bundle\WebsiteBundle\Entity\Domain | No errors. |