GET https://staging.optic-kleer.co.uk/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255COperatorController%253A%253AselectAction

Response
200 OK
IP
113.180.152.38
Profiled on
Token
e79e21

Query Metrics

34 Database Queries
18 Different statements
47.03 ms Query time
2 Invalid entities
81 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
5.18 ms
(11.02%) 		1 
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()="primary_mobile"]) > 0')) AND n0.path LIKE '/cmf/www/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: 
[
  "www_live"
]
View formatted query    View runnable query    Explain query
5.08 ms
(10.80%) 		1 
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()="primary_desktop"]) > 0')) AND n0.path LIKE '/cmf/www/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: 
[
  "www_live"
]
View formatted query    View runnable query    Explain query
4.45 ms
(9.47%) 		7 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/www/routes/en/windscreen-repairs"
  "www_live"
]
View formatted query    View runnable query    Explain query
4.36 ms
(9.27%) 		1 
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()="footer_info"]) > 0')) AND n0.path LIKE '/cmf/www/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: 
[
  "www_live"
]
View formatted query    View runnable query    Explain query
3.40 ms
(7.23%) 		1 
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()="footer_legal"]) > 0')) AND n0.path LIKE '/cmf/www/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: 
[
  "www_live"
]
View formatted query    View runnable query    Explain query
3.31 ms
(7.05%) 		3 
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: 
[]
View formatted query    View runnable query    Explain query
3.11 ms
(6.62%) 		1 
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()="footer_explore"]) > 0')) AND n0.path LIKE '/cmf/www/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: 
[
  "www_live"
]
View formatted query    View runnable query    Explain query
2.79 ms
(5.93%) 		4 
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters: 
[
  "/cmf/www/routes/en/windscreen-repairs"
  "www_live"
]
View formatted query    View runnable query    Explain query
2.76 ms
(5.87%) 		1 
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()="pre_header"]) > 0')) AND n0.path LIKE '/cmf/www/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: 
[
  "www_live"
]
View formatted query    View runnable query    Explain query
2.17 ms
(4.61%) 		1 
SELECT o0_.id AS id_0, o0_.active AS active_1, o0_.pod AS pod_2, o0_.slug AS slug_3, o0_.code AS code_4, o0_.firstName AS firstName_5, o0_.image AS image_6, o0_.banner AS banner_7, o0_.introText AS introText_8, o0_.introTextRaw AS introTextRaw_9, o0_.introTextFormat AS introTextFormat_10, o0_.jobTitle AS jobTitle_11, o0_.lastName AS lastName_12, o0_.areaName AS areaName_13, o0_.metaTitle AS metaTitle_14, o0_.seoTitle AS seoTitle_15, o0_.seoDescription AS seoDescription_16, o0_.telephone AS telephone_17, o0_.uuid AS uuid_18, o0_.redirectTo AS redirectTo_19, o0_.imageMediaId AS imageMediaId_20, o0_.bannerMediaId AS bannerMediaId_21 FROM operator__operator o0_ WHERE o0_.active = ? ORDER BY o0_.areaName ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
2.13 ms
(4.53%) 		2 
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 = ?) ORDER BY sort_order ASC
Parameters: 
[
  "www_live"
  "/cmf/www/contents/privacy-policy"
  "/cmf/www/contents/terms-of-use"
  "/cmf/www/contents/cookie-policy"
  "/cmf/www/contents/repair-terms-conditions"
]
View formatted query    View runnable query    Explain query
1.99 ms
(4.23%) 		2 
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 = ?) ORDER BY sort_order ASC
Parameters: 
[
  "www_live"
  "/cmf/www/contents/franchise"
  "/cmf/www/contents/faqs"
  "/cmf/www/contents/warranty"
]
View formatted query    View runnable query    Explain query
1.52 ms
(3.24%) 		2 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/www/contents/privacy-policy"
  "/cmf/www/contents/terms-of-use"
  "/cmf/www/contents/cookie-policy"
  "/cmf/www/contents/repair-terms-conditions"
  "www_live"
]
View formatted query    View runnable query    Explain query
1.35 ms
(2.87%) 		2 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/www/contents/franchise"
  "/cmf/www/contents/faqs"
  "/cmf/www/contents/warranty"
  "www_live"
]
View formatted query    View runnable query    Explain query
1.27 ms
(2.70%) 		2 
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: 
[
  "www_live"
  "38be4f71-eac5-4ec1-82f2-c7bd780d4d92"
]
View formatted query    View runnable query    Explain query
0.84 ms
(1.78%) 		1 
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 = ?) ORDER BY sort_order ASC
Parameters: 
[
  "www_live"
  "/cmf/www/contents/tell-us-your-insurer"
]
View formatted query    View runnable query    Explain query
0.71 ms
(1.52%) 		1 
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters: 
[
  "www_live"
]
View formatted query    View runnable query    Explain query
0.59 ms
(1.26%) 		1 
SELECT prefix, uri FROM phpcr_namespaces
Parameters: 
[]
View formatted query    View runnable query    Explain query

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Operator\Operator 41
Sulu\Bundle\MediaBundle\Entity\Media 40

Entities Mapping

Class Mapping errors
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.
Sulu\Bundle\SecurityBundle\Entity\Group No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItemTranslation No errors.
Sulu\Bundle\SecurityBundle\Entity\User No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionMeta No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionType No errors.
Sulu\Bundle\MediaBundle\Entity\Media No errors.
Sulu\Bundle\SecurityBundle\Entity\UserGroup No errors.
Sulu\Bundle\SecurityBundle\Entity\Role No errors.
Sulu\Bundle\SecurityBundle\Entity\UserTwoFactor No errors.
Sulu\Bundle\SecurityBundle\Entity\UserRole No errors.
Sulu\Bundle\SecurityBundle\Entity\UserSetting No errors.
Sulu\Bundle\ContactBundle\Entity\Contact No errors.
Sulu\Bundle\MediaBundle\Entity\File No errors.
Sulu\Bundle\MediaBundle\Entity\MediaType No errors.
Sulu\Bundle\SecurityBundle\Entity\Permission No errors.
Sulu\Bundle\SecurityBundle\Entity\RoleSetting No errors.
Sulu\Bundle\SecurityBundle\Entity\SecurityType No errors.
App\Entity\Operator\Operator No errors.
App\Entity\Operator\OperatorStore No errors.
App\Entity\Location\Address No errors.
App\Entity\Location\Coords
  • The field 'App\Entity\Location\Coords#latitude' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
  • The field 'App\Entity\Location\Coords#longitude' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
App\Entity\Location\Location
  • The field 'App\Entity\Location\Location#coords.latitude' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
  • The field 'App\Entity\Location\Location#coords.longitude' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.