Query Metrics
68
Database Queries
13
Different statements
75.15 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.64 ms |
SELECT d0_.id AS id_0, d0_.enabled AS enabled_1, d0_.ordena AS ordena_2, d0_.created AS created_3, d0_.changed AS changed_4, d0_.mota_id AS mota_id_5, d0_.idUsersCreator AS idUsersCreator_6, d0_.idUsersChanger AS idUsersChanger_7 FROM da_faq d0_ LEFT JOIN da_faq_mota d1_ ON d0_.mota_id = d1_.id LEFT JOIN da_faq_translations d2_ ON d0_.id = d2_.faq_id WHERE d1_.id = ? ORDER BY d0_.ordena ASC, d0_.id ASC
Parameters:
[
1
]
|
| 2 | 1.28 ms |
SELECT DISTINCT d0_.id AS id_0, d0_.izena_eu AS izena_eu_1 FROM da_faq d1_ LEFT JOIN da_faq_mota d2_ ON d1_.mota_id = d2_.id LEFT JOIN da_faq_faqs_etiketak d3_ ON d1_.id = d3_.faq_id LEFT JOIN da_faq_etiketa d0_ ON d0_.id = d3_.etiketa_id WHERE d2_.id = ? AND d0_.id IS NOT NULL ORDER BY d0_.izena_eu ASC
Parameters:
[
1
]
|
| 3 | 0.37 ms |
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
"default_live"
]
|
| 4 | 0.23 ms |
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[] |
| 5 | 0.51 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.53 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 | 48.98 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 | 0.86 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.06 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.59 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.76 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.91 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
1
]
|
| 13 | 0.64 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
1
]
|
| 14 | 0.48 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
2
]
|
| 15 | 0.44 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
2
]
|
| 16 | 0.30 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
3
]
|
| 17 | 0.42 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
3
]
|
| 18 | 0.32 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
4
]
|
| 19 | 0.36 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
4
]
|
| 20 | 0.29 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
5
]
|
| 21 | 0.46 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
5
]
|
| 22 | 0.31 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
6
]
|
| 23 | 0.43 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
6
]
|
| 24 | 0.32 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
7
]
|
| 25 | 0.35 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
7
]
|
| 26 | 0.33 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
8
]
|
| 27 | 0.33 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
8
]
|
| 28 | 0.39 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
9
]
|
| 29 | 0.36 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
9
]
|
| 30 | 0.26 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
10
]
|
| 31 | 0.27 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
10
]
|
| 32 | 0.24 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
11
]
|
| 33 | 0.26 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
11
]
|
| 34 | 0.23 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
12
]
|
| 35 | 0.28 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
12
]
|
| 36 | 0.33 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
15
]
|
| 37 | 0.36 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
15
]
|
| 38 | 0.32 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
16
]
|
| 39 | 0.29 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
16
]
|
| 40 | 0.24 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
17
]
|
| 41 | 0.28 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
17
]
|
| 42 | 0.26 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
18
]
|
| 43 | 0.28 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
18
]
|
| 44 | 0.23 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
19
]
|
| 45 | 0.27 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
19
]
|
| 46 | 0.24 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
20
]
|
| 47 | 0.28 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
20
]
|
| 48 | 0.24 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
21
]
|
| 49 | 0.26 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
21
]
|
| 50 | 0.27 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
22
]
|
| 51 | 0.26 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
22
]
|
| 52 | 0.25 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
23
]
|
| 53 | 0.26 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
23
]
|
| 54 | 0.24 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
24
]
|
| 55 | 0.24 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
24
]
|
| 56 | 0.24 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
25
]
|
| 57 | 0.27 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
25
]
|
| 58 | 0.23 ms |
SELECT t0.id AS id_1, t0.izenburua AS izenburua_2, t0.deskribapena AS deskribapena_3, t0.locale AS locale_4, t0.created AS created_5, t0.changed AS changed_6, t0.faq_id AS faq_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM da_faq_translations t0 WHERE t0.faq_id = ?
Parameters:
[
26
]
|
| 59 | 0.27 ms |
SELECT t0.id AS id_1, t0.izena_eu AS izena_eu_2, t0.izena_es AS izena_es_3, t0.mota_id AS mota_id_4 FROM da_faq_etiketa t0 INNER JOIN da_faq_faqs_etiketak ON t0.id = da_faq_faqs_etiketak.etiketa_id WHERE da_faq_faqs_etiketak.faq_id = ?
Parameters:
[
26
]
|
| 60 | 0.32 ms |
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters:
[ "0a44832f-67ab-45a6-9ec3-4485f63d0b00" "default_live" ] |
| 61 | 0.30 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"
]
|
| 62 | 0.41 ms |
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters:
[ "b505338e-d25c-4161-b2dd-fad465063f25" "default_live" ] |
| 63 | 0.35 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"
]
|
| 64 | 0.31 ms |
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters:
[ "eedc8df5-31cf-4598-a699-70363a663605" "default_live" ] |
| 65 | 0.29 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"
]
|
| 66 | 0.28 ms |
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters:
[ "e54c4af4-276b-4cfc-8a1e-5e6d097351f7" "default_live" ] |
| 67 | 0.33 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"
]
|
| 68 | 0.36 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\Faq\Faq | No errors. |
| App\Entity\Faq\Mota | No errors. |
| App\Entity\Faq\FaqTranslation | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\User | No errors. |
| App\Entity\Faq\Etiketa | No errors. |
| Sulu\Bundle\WebsiteBundle\Entity\Analytics | No errors. |
| Sulu\Bundle\WebsiteBundle\Entity\Domain | No errors. |