Query Metrics
10
Database Queries
7
Different statements
6.89 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.50 ms (21.80%) |
1 |
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, w1_.id ASC
Parameters:
[ "pqna.preprod.seven-group.com/{localization}" "dev" "pqna" ] |
1.45 ms (21.09%) |
3 |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/pqna/routes/fr/pqn-a/reseau-et-prestataires" "default_live" ] |
1.12 ms (16.31%) |
1 |
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
"default_live"
]
|
1.09 ms (15.80%) |
2 |
SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC
Parameters:
[ "/cmf/pqna/routes/fr/pqn-a/reseau-et-prestataires" "default_live" ] |
0.85 ms (12.30%) |
1 |
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:
[] |
0.51 ms (7.40%) |
1 |
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" "7639b9de-b77e-4230-b427-caab161a61fa" ] |
0.37 ms (5.30%) |
1 |
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[] |
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\FormBundle\Entity\Form | No errors. |
Sulu\Bundle\MediaBundle\Entity\Collection | No errors. |
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem | No errors. |
Sulu\Bundle\FormBundle\Entity\Dynamic | No errors. |
Sulu\Bundle\ContactBundle\Entity\ContactTitle | No errors. |
Sulu\Bundle\SecurityBundle\Entity\Group | No errors. |
Sulu\Bundle\WebsiteBundle\Entity\Analytics | No errors. |
Sulu\Bundle\WebsiteBundle\Entity\Domain | No errors. |