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
216.73.216.221
Profiled on
Token
5c6a54

Query Metrics

48 Database Queries
23 Different statements
56.52 ms Query time
2 Invalid entities
97 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
4.90 ms
(8.67%) 		8 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/www/contents/faqs"
  "www_live"
]
View formatted query    View runnable query    Explain query
4.61 ms
(8.15%) 		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
4.48 ms
(7.92%) 		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.28 ms
(7.58%) 		6 
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters: 
[
  "/cmf/www/routes/en/windscreen-faqs/4"
  "www_live"
]
View formatted query    View runnable query    Explain query
3.67 ms
(6.49%) 		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.60 ms
(6.38%) 		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.57 ms
(6.32%) 		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
3.34 ms
(5.91%) 		3 
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/windscreen-repair"
  "/cmf/www/contents/make-a-payment"
  "/cmf/www/contents/insurance-details"
  "/cmf/www/contents/contact-us"
]
View formatted query    View runnable query    Explain query
3.09 ms
(5.48%) 		5 
SELECT t0.path AS path_1, t0.locale AS locale_2, t0.entity_class AS entity_class_3, t0.entity_id AS entity_id_4, t0.history AS history_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.target AS target_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ro_routes t0 WHERE t0.id = ?
Parameters: 
[
  12
]
View formatted query    View runnable query    Explain query
2.90 ms
(5.13%) 		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.68 ms
(4.74%) 		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
2.37 ms
(4.19%) 		3 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/www/contents/windscreen-repair"
  "/cmf/www/contents/make-a-payment"
  "/cmf/www/contents/insurance-details"
  "/cmf/www/contents/contact-us"
  "www_live"
]
View formatted query    View runnable query    Explain query
2.21 ms
(3.91%) 		2 
SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.question AS question_2, f0_.answer AS answer_3, f0_.answerRaw AS answerRaw_4, f0_.answerFormat AS answerFormat_5, f0_.sortPosition AS sortPosition_6, f0_.category_id AS category_id_7 FROM faq__faq f0_ INNER JOIN faq__category f1_ ON f0_.category_id = f1_.id WHERE f0_.active = ? AND f1_.active = ? AND f1_.id = ? ORDER BY f0_.sortPosition ASC, f0_.question ASC, f1_.sortPosition ASC, f1_.title ASC
Parameters: 
[
  1
  1
  4
]
View formatted query    View runnable query    Explain query
2.04 ms
(3.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
1.74 ms
(3.07%) 		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"
  "1e483faf-34ca-4fe4-977e-2ec9e8ba42c9"
]
View formatted query    View runnable query    Explain query
1.66 ms
(2.94%) 		2 
SELECT f0_.id AS id_0, f0_.active AS active_1, f0_.title AS title_2, f0_.sortPosition AS sortPosition_3, f0_.route AS route_4 FROM faq__category f0_ INNER JOIN faq__faq f1_ ON f0_.id = f1_.category_id WHERE f0_.active = ? AND f1_.active = ? GROUP BY f0_.id HAVING count(f1_.id) > 0 ORDER BY f0_.sortPosition ASC, f0_.title ASC
Parameters: 
[
  1
  1
]
View formatted query    View runnable query    Explain query
0.90 ms
(1.59%) 		1 
SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r1_.path AS path_8, r1_.locale AS locale_9, r1_.entity_class AS entity_class_10, r1_.entity_id AS entity_id_11, r1_.history AS history_12, r1_.id AS id_13, r1_.created AS created_14, r1_.changed AS changed_15, r0_.target AS target_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target AS target_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target = r1_.id WHERE r0_.path = ? AND r0_.locale = ?
Parameters: 
[
  "/windscreen-faqs/4"
  "en"
]
View formatted query    View runnable query    Explain query
0.85 ms
(1.51%) 		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.81 ms
(1.43%) 		1 
SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.sortPosition AS sortPosition_4, t0.route AS route_5 FROM faq__category t0 WHERE t0.id = ?
Parameters: 
[
  "4"
]
View formatted query    View runnable query    Explain query
0.76 ms
(1.35%) 		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 = ? OR path = ?) ORDER BY sort_order ASC
Parameters: 
[
  "www_live"
  "/cmf/www/contents/franchise"
  "/cmf/www/contents/warranty"
]
View formatted query    View runnable query    Explain query
0.73 ms
(1.30%) 		1 
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters: 
[
  "www_live"
]
View formatted query    View runnable query    Explain query
0.71 ms
(1.25%) 		1 
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/warranty"
  "www_live"
]
View formatted query    View runnable query    Explain query
0.61 ms
(1.08%) 		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
Sulu\Bundle\RouteBundle\Entity\Route 6
App\Entity\Faq\Category 6
App\Entity\Faq\Faq 4

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\RouteBundle\Entity\Route No errors.
Sulu\Bundle\SecurityBundle\Entity\User No errors.
App\Entity\Faq\Category No errors.
App\Entity\Faq\Faq No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItemTranslation 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.
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.