GET https://storm.ewm.dev/fr/property/entrepot-saint-quentin-fallavier-24-526-m2/381

Query Metrics

120 Database Queries
53 Different statements
42.01 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
20.58 ms
(49.00%)
44
SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, m5_.crop_x AS crop_x_31, m5_.crop_y AS crop_y_32, m5_.crop_width AS crop_width_33, m5_.crop_height AS crop_height_34, m5_.format_key AS format_key_35, m6_.title AS title_36, m6_.description AS description_37, m6_.copyright AS copyright_38, m6_.credits AS credits_39, m6_.locale AS locale_40, m6_.id AS id_41, m7_.title AS title_42, m7_.description AS description_43, m7_.copyright AS copyright_44, m7_.credits AS credits_45, m7_.locale AS locale_46, m7_.id AS id_47, m8_.locale AS locale_48, m8_.id AS id_49, m9_.locale AS locale_50, m9_.id AS id_51, s10_.username AS username_52, s10_.password AS password_53, s10_.locale AS locale_54, s10_.salt AS salt_55, s10_.locked AS locked_56, s10_.enabled AS enabled_57, s10_.lastLogin AS lastLogin_58, s10_.confirmationKey AS confirmationKey_59, s10_.passwordResetToken AS passwordResetToken_60, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_61, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_62, s10_.privateKey AS privateKey_63, s10_.apiKey AS apiKey_64, s10_.email AS email_65, s10_.id AS id_66, s10_.created AS created_67, s10_.changed AS changed_68, c11_.firstName AS firstName_69, c11_.middleName AS middleName_70, c11_.lastName AS lastName_71, c11_.birthday AS birthday_72, c11_.salutation AS salutation_73, c11_.formOfAddress AS formOfAddress_74, c11_.newsletter AS newsletter_75, c11_.gender AS gender_76, c11_.note AS note_77, c11_.mainEmail AS mainEmail_78, c11_.mainPhone AS mainPhone_79, c11_.mainFax AS mainFax_80, c11_.mainUrl AS mainUrl_81, c11_.id AS id_82, c11_.created AS created_83, c11_.changed AS changed_84, s12_.username AS username_85, s12_.password AS password_86, s12_.locale AS locale_87, s12_.salt AS salt_88, s12_.locked AS locked_89, s12_.enabled AS enabled_90, s12_.lastLogin AS lastLogin_91, s12_.confirmationKey AS confirmationKey_92, s12_.passwordResetToken AS passwordResetToken_93, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_94, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_95, s12_.privateKey AS privateKey_96, s12_.apiKey AS apiKey_97, s12_.email AS email_98, s12_.id AS id_99, s12_.created AS created_100, s12_.changed AS changed_101, c13_.firstName AS firstName_102, c13_.middleName AS middleName_103, c13_.lastName AS lastName_104, c13_.birthday AS birthday_105, c13_.salutation AS salutation_106, c13_.formOfAddress AS formOfAddress_107, c13_.newsletter AS newsletter_108, c13_.gender AS gender_109, c13_.note AS note_110, c13_.mainEmail AS mainEmail_111, c13_.mainPhone AS mainPhone_112, c13_.mainFax AS mainFax_113, c13_.mainUrl AS mainUrl_114, c13_.id AS id_115, c13_.created AS created_116, c13_.changed AS changed_117, m14_.id AS id_118, m14_.created AS created_119, m14_.changed AS changed_120, m0_.idMediaTypes AS idMediaTypes_121, m0_.idPreviewImage AS idPreviewImage_122, m0_.idCollections AS idCollections_123, m0_.idUsersCreator AS idUsersCreator_124, m0_.idUsersChanger AS idUsersChanger_125, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_126, m2_.idCollectionTypes AS idCollectionTypes_127, m2_.idCollectionsParent AS idCollectionsParent_128, m2_.idUsersCreator AS idUsersCreator_129, m2_.idUsersChanger AS idUsersChanger_130, m3_.idMedia AS idMedia_131, m3_.idUsersCreator AS idUsersCreator_132, m3_.idUsersChanger AS idUsersChanger_133, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_134, m4_.idFiles AS idFiles_135, m4_.idUsersCreator AS idUsersCreator_136, m4_.idUsersChanger AS idUsersChanger_137, m5_.fileVersion AS fileVersion_138, m6_.idFileVersions AS idFileVersions_139, m7_.idFileVersions AS idFileVersions_140, m8_.idFileVersions AS idFileVersions_141, m9_.idFileVersions AS idFileVersions_142, s10_.idContacts AS idContacts_143, s10_.idUsersCreator AS idUsersCreator_144, s10_.idUsersChanger AS idUsersChanger_145, c11_.idTitles AS idTitles_146, c11_.avatar AS avatar_147, c11_.idUsersCreator AS idUsersCreator_148, c11_.idUsersChanger AS idUsersChanger_149, s12_.idContacts AS idContacts_150, s12_.idUsersCreator AS idUsersCreator_151, s12_.idUsersChanger AS idUsersChanger_152, c13_.idTitles AS idTitles_153, c13_.avatar AS avatar_154, c13_.idUsersCreator AS idUsersCreator_155, c13_.idUsersChanger AS idUsersChanger_156, m14_.idMediaTypes AS idMediaTypes_157, m14_.idPreviewImage AS idPreviewImage_158, m14_.idCollections AS idCollections_159, m14_.idUsersCreator AS idUsersCreator_160, m14_.idUsersChanger AS idUsersChanger_161 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_format_options m5_ ON m4_.id = m5_.fileVersion LEFT JOIN me_file_version_meta m6_ ON m4_.id = m6_.idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_.idFileVersionsMetaDefault = m7_.id LEFT JOIN me_file_version_content_languages m8_ ON m4_.id = m8_.idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN se_users s10_ ON m0_.idUsersCreator = s10_.id LEFT JOIN co_contacts c11_ ON s10_.idContacts = c11_.id LEFT JOIN se_users s12_ ON m0_.idUsersChanger = s12_.id LEFT JOIN co_contacts c13_ ON s12_.idContacts = c13_.id LEFT JOIN me_media m14_ ON m0_.idPreviewImage = m14_.id WHERE m0_.id = ?
Parameters:
[
  21
]
1.52 ms
(3.61%)
1
SELECT t0.id AS id_1, t0.type_fr AS type_fr_2, t0.type_en AS type_en_3, t0.value AS value_4, t0.color AS color_5, t0.bien_id AS bien_id_6 FROM professional t0 WHERE t0.bien_id = ?
Parameters:
[
  87
]
1.28 ms
(3.05%)
1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.value AS value_4, t0.bien_id AS bien_id_5 FROM equipment t0 WHERE t0.bien_id = ?
Parameters:
[
  87
]
1.26 ms
(3.00%)
1
SELECT b0_.id AS id_0, b0_.reference AS reference_1, b0_.enabled AS enabled_2, b0_.approved AS approved_3, b0_.approval_pending AS approval_pending_4, b0_.latitude AS latitude_5, b0_.longitude AS longitude_6, b0_.price AS price_7, b0_.currency AS currency_8, b0_.zip AS zip_9, b0_.surface AS surface_10, b0_.divisible_surface AS divisible_surface_11, b0_.high AS high_12, b0_.availability AS availability_13, b0_.created_at AS created_at_14, b0_.updated_at AS updated_at_15, b0_.brochure AS brochure_16, b0_.visit_link AS visit_link_17, b0_.unemployment AS unemployment_18, b0_.area AS area_19, b0_.population AS population_20, b0_.geometry AS geometry_21, b0_.construction_year AS construction_year_22, b0_.offices_surface AS offices_surface_23, b0_.etat AS etat_24, b0_.transaction AS transaction_25, b0_.rent_price AS rent_price_26, b0_.price_on_demand AS price_on_demand_27, b0_.charge AS charge_28, b0_.tax AS tax_29, b0_.divisible AS divisible_30, b0_.created_by AS created_by_31, b0_.rent_price_on_demand AS rent_price_on_demand_32, b0_.contact_person_uuid AS contact_person_uuid_33, b0_.created_from AS created_from_34, b0_.included_charges AS included_charges_35, (6371 * ACOS(COS(RADIANS(?)) * COS(RADIANS(b0_.latitude)) * COS(RADIANS(b0_.longitude) - RADIANS(?)) + SIN(RADIANS(?)) * SIN(RADIANS(b0_.latitude)))) AS sclr_36, b0_.owner_id AS owner_id_37, b0_.owner_contact_id AS owner_contact_id_38, b0_.member_contact_id AS member_contact_id_39 FROM bien b0_ WHERE b0_.enabled = ? AND b0_.id <> ? AND (b0_.surface BETWEEN ? AND ?) AND b0_.transaction LIKE '%rent%' AND (b0_.rent_price BETWEEN -20 AND 20) HAVING sclr_36 <= ? ORDER BY sclr_36 ASC
Parameters:
[
  45.66432980171
  5.1100952832815
  45.66432980171
  1
  87
  4526.0
  44526.0
  30
]
1.16 ms
(2.77%)
1
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.enabled AS enabled_3, t0.approved AS approved_4, t0.approval_pending AS approval_pending_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.price AS price_8, t0.currency AS currency_9, t0.zip AS zip_10, t0.surface AS surface_11, t0.divisible_surface AS divisible_surface_12, t0.high AS high_13, t0.availability AS availability_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.brochure AS brochure_17, t0.visit_link AS visit_link_18, t0.unemployment AS unemployment_19, t0.area AS area_20, t0.population AS population_21, t0.geometry AS geometry_22, t0.construction_year AS construction_year_23, t0.offices_surface AS offices_surface_24, t0.etat AS etat_25, t0.transaction AS transaction_26, t0.rent_price AS rent_price_27, t0.price_on_demand AS price_on_demand_28, t0.charge AS charge_29, t0.tax AS tax_30, t0.divisible AS divisible_31, t0.created_by AS created_by_32, t0.rent_price_on_demand AS rent_price_on_demand_33, t0.contact_person_uuid AS contact_person_uuid_34, t0.created_from AS created_from_35, t0.included_charges AS included_charges_36, t0.owner_id AS owner_id_37, t38.id AS id_39, t38.unemployment AS unemployment_40, t38.population AS population_41, t38.capital AS capital_42, t38.professional AS professional_43, t38.industry AS industry_44, t38.bien_id AS bien_id_45, t0.owner_contact_id AS owner_contact_id_46, t0.member_contact_id AS member_contact_id_47 FROM bien t0 LEFT JOIN source t38 ON t38.bien_id = t0.id WHERE t0.reference = ? LIMIT 1
Parameters:
[
  "381"
]
0.93 ms
(2.22%)
9
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
  "/cmf/storm"
  "default_live"
]
0.93 ms
(2.22%)
2
SELECT b0_.title AS title_0 FROM bien b1_ INNER JOIN bien_translation b0_ ON b1_.id = b0_.bien_id WHERE b1_.reference = ? AND b0_.locale = ?
Parameters:
[
  "381"
  "fr"
]
0.72 ms
(1.72%)
5
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters:
[
  "/cmf/storm"
  "default_live"
]
0.72 ms
(1.72%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.locale AS locale_4, t0.bien_id AS bien_id_5 FROM detail t0 WHERE t0.bien_id = ?
Parameters:
[
  87
]
0.72 ms
(1.71%)
1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.address AS address_4, t0.description AS description_5, t0.country AS country_6, t0.city AS city_7, t0.district AS district_8, t0.activity_zone AS activity_zone_9, t0.access AS access_10, t0.created AS created_11, t0.changed AS changed_12, t0.bien_id AS bien_id_13, t0.idUsersCreator AS idUsersCreator_14, t0.idUsersChanger AS idUsersChanger_15 FROM bien_translation t0 WHERE t0.bien_id = ?
Parameters:
[
  87
]
0.70 ms
(1.67%)
1
SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = ?
Parameters:
[
  25532
]
0.70 ms
(1.66%)
1
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.gender AS gender_6, t0.role AS role_7, t0.active AS active_8, t0.password AS password_9, t0.reset_token AS reset_token_10, t0.reset_token_expires_at AS reset_token_expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.owner_id AS owner_id_14 FROM `member` t0 WHERE t0.id = ?
Parameters:
[
  9
]
0.63 ms
(1.50%)
1
SELECT t0.id AS id_1, t0.file AS file_2, t0.bien_id AS bien_id_3 FROM file t0 WHERE t0.bien_id = ?
Parameters:
[
  87
]
0.61 ms
(1.45%)
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:
[]
0.58 ms
(1.38%)
1
SELECT t0.id AS id_1, t0.year AS year_2, t0.value AS value_3, t0.bien_id AS bien_id_4 FROM population t0 WHERE t0.bien_id = ?
Parameters:
[
  87
]
0.52 ms
(1.25%)
1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.number AS number_3, t0.description AS description_4, t0.regime AS regime_5, t0.weight AS weight_6, t0.bien_id AS bien_id_7, t0.icpe_id AS icpe_id_8 FROM category t0 WHERE t0.bien_id = ?
Parameters:
[
  87
]
0.49 ms
(1.17%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.bien_id AS bien_id_3 FROM gallery t0 WHERE t0.bien_id = ?
Parameters:
[
  87
]
0.47 ms
(1.11%)
3
SELECT m0_.id AS id_0, m1_.version AS version_1, m1_.name AS name_2, m2_.title AS title_3, m3_.title AS title_4 FROM me_media m0_ LEFT JOIN me_files m4_ ON m0_.id = m4_.idMedia LEFT JOIN me_file_versions m1_ ON m4_.id = m1_.idFiles AND (m1_.version = m4_.version) LEFT JOIN me_file_version_meta m3_ ON m1_.idFileVersionsMetaDefault = m3_.id LEFT JOIN me_file_version_meta m2_ ON m1_.id = m2_.idFileVersions AND (m2_.locale = ?) WHERE m0_.id IN (?)
Parameters:
[
  "fr"
  36333
]
0.46 ms
(1.10%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.bien_id AS bien_id_4 FROM capital t0 WHERE t0.bien_id = ?
Parameters:
[
  87
]
0.42 ms
(1.01%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.bien_id AS bien_id_3 FROM certification t0 WHERE t0.bien_id = ?
Parameters:
[
  87
]
0.37 ms
(0.88%)
2
SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = ?
Parameters:
[
  1
]
0.37 ms
(0.87%)
2
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 n0.parent = '/cmf/storm/contents/rent' LIMIT 1
Parameters:
[
  "default_live"
]
0.35 ms
(0.83%)
1
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
  "default_live"
]
0.34 ms
(0.82%)
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:
[
  "default_live"
  "1cdb0013-402c-4250-8176-456df8eccce8"
]
0.33 ms
(0.78%)
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 (n0.identifier = '5460bb2a-fdeb-4718-b05e-7a4700c027ae' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-state"]/sv:value'), ' ', ','))) 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"
]
0.30 ms
(0.72%)
1
SELECT t0.id AS id_1, t0.type_fr AS type_fr_2, t0.type_en AS type_en_3, t0.value AS value_4, t0.color AS color_5, t0.bien_id AS bien_id_6 FROM industry t0 WHERE t0.bien_id = ?
Parameters:
[
  87
]
0.28 ms
(0.67%)
1
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[]
0.27 ms
(0.64%)
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 = ?) ORDER BY sort_order ASC
Parameters:
[
  "default_live"
  "/cmf/storm/contents/rent"
  "/cmf/storm/contents/buy-1"
]
0.25 ms
(0.60%)
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:fr-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
0.25 ms
(0.59%)
2
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
  "/cmf/storm/contents/rent"
  "/cmf/storm/contents/buy-1"
  "default_live"
]
0.23 ms
(0.54%)
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 = ? OR path = ?) ORDER BY sort_order ASC
Parameters:
[
  "default_live"
  "/cmf/storm/contents/about-us"
  "/cmf/storm/contents/news"
  "/cmf/storm/contents/contact-us"
]
0.22 ms
(0.53%)
2
SELECT t0.id AS id_1, t0.number AS number_2, t0.specificity AS specificity_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5 FROM icpe t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.22 ms
(0.52%)
2
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 (n0.identifier = '7e797d2e-78cd-44b8-b673-e3c26761deaf' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-state"]/sv:value'), ' ', ','))) 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"
]
0.21 ms
(0.51%)
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:fr-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-navContexts"]/sv:value[text()="footer_menu_4"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
0.19 ms
(0.45%)
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:fr-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-navContexts"]/sv:value[text()="footer_menu_1"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
0.18 ms
(0.43%)
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 (n0.identifier = '08b7eb09-c860-4b58-8250-d2d2a5562c2c' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-state"]/sv:value'), ' ', ','))) 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"
]
0.17 ms
(0.40%)
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:fr-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-navContexts"]/sv:value[text()="footer_menu_3"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
0.16 ms
(0.39%)
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:fr-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-navContexts"]/sv:value[text()="footer_menu_2"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
0.16 ms
(0.37%)
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:fr-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-navContexts"]/sv:value[text()="burger_menu"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
0.15 ms
(0.36%)
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 (n0.identifier = 'fe2c557b-08ba-49d8-bb7c-156b6abd9e0c' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-state"]/sv:value'), ' ', ','))) 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"
]
0.15 ms
(0.35%)
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:fr-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-navContexts"]/sv:value[text()="service_menu"]) > 0')) AND n0.path LIKE '/cmf/storm/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"
]
0.14 ms
(0.34%)
1
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters:
[
  "41ed80a0-7eae-4d10-82bc-50872067f930"
  "default_live"
]
0.13 ms
(0.32%)
1
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.phone AS phone_4, t0.email AS email_5, t0.password AS password_6, t0.gender AS gender_7, t0.company AS company_8, t0.role AS role_9, t0.active AS active_10, t0.confirmed AS confirmed_11, t0.address AS address_12, t0.zip_code AS zip_code_13, t0.person_in_charge AS person_in_charge_14, t0.reset_token AS reset_token_15, t0.reset_token_expires_at AS reset_token_expires_at_16, t0.offer_max_properties AS offer_max_properties_17, t0.offer_expires_at AS offer_expires_at_18, t0.offer_published_properties AS offer_published_properties_19, t0.nb_of_generation AS nb_of_generation_20, t0.last_generation_update_at AS last_generation_update_at_21, t0.city AS city_22, t0.image_id AS image_id_23 FROM owner t0 WHERE t0.id = ?
Parameters:
[
  29
]
0.13 ms
(0.32%)
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
Parameters:
[
  "storm.ewm.dev/{localization}"
  "dev"
  "storm"
]
0.13 ms
(0.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 (n0.identifier = '35e8121f-c8e9-4cc7-8ff5-9cd381abbf42' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-state"]/sv:value'), ' ', ','))) 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"
]
0.13 ms
(0.31%)
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 n0.parent = '/cmf/storm/contents/privacy-policy' LIMIT 1
Parameters:
[
  "default_live"
]
0.12 ms
(0.29%)
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 n0.parent = '/cmf/storm/contents/buy-1' LIMIT 1
Parameters:
[
  "default_live"
]
0.12 ms
(0.28%)
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 n0.parent = '/cmf/storm/contents/login' LIMIT 1
Parameters:
[
  "default_live"
]
0.12 ms
(0.28%)
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:
[
  "default_live"
  "/cmf/storm/contents/buy"
]
0.11 ms
(0.26%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = ?
Parameters:
[
  25532
]
0.10 ms
(0.25%)
1
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[
  "/cmf/storm/contents/about-us"
  "/cmf/storm/contents/news"
  "/cmf/storm/contents/contact-us"
  "default_live"
]
0.10 ms
(0.23%)
1
SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = ?
Parameters:
[
  25532
]
0.09 ms
(0.22%)
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 n0.parent = '/cmf/storm/contents/profile-settings' LIMIT 1
Parameters:
[
  "default_live"
]

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\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.
App\Entity\Bien No errors.
App\Entity\Owner No errors.
App\Entity\Source No errors.
App\Entity\Member No errors.
App\Entity\BienTranslation No errors.
App\Entity\Gallery No errors.
App\Entity\File No errors.
App\Entity\Category No errors.
App\Entity\Detail No errors.
App\Entity\Population No errors.
App\Entity\Capital No errors.
App\Entity\Professional No errors.
App\Entity\Industry No errors.
App\Entity\Equipment No errors.
App\Entity\Certification No errors.
App\Entity\Broker No errors.
App\Entity\PropertyPublished No errors.
App\Entity\HistoricPublishedProperty No errors.
App\Entity\Statistic No errors.
Sulu\Bundle\MediaBundle\Entity\Media No errors.
Sulu\Bundle\MediaBundle\Entity\MediaType No errors.
Sulu\Bundle\MediaBundle\Entity\File No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersion No errors.
Sulu\Bundle\MediaBundle\Entity\FormatOptions No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionContentLanguage No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionPublishLanguage No errors.
Sulu\Bundle\SecurityBundle\Entity\User No errors.
Sulu\Bundle\ContactBundle\Entity\Contact No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionMeta No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionType No errors.
Sulu\Bundle\TagBundle\Entity\Tag No errors.
Sulu\Bundle\CategoryBundle\Entity\Category No errors.
Sulu\Bundle\SecurityBundle\Entity\UserTwoFactor No errors.
Sulu\Bundle\SecurityBundle\Entity\UserRole No errors.
Sulu\Bundle\SecurityBundle\Entity\UserGroup No errors.
Sulu\Bundle\SecurityBundle\Entity\UserSetting No errors.
Sulu\Bundle\ContactBundle\Entity\ContactLocale No errors.
Sulu\Bundle\ContactBundle\Entity\ContactAddress No errors.
Sulu\Bundle\ContactBundle\Entity\AccountContact No errors.
Sulu\Bundle\ContactBundle\Entity\Url No errors.
Sulu\Bundle\ContactBundle\Entity\Note No errors.
Sulu\Bundle\ContactBundle\Entity\Email No errors.
Sulu\Bundle\ContactBundle\Entity\Phone No errors.
Sulu\Bundle\ContactBundle\Entity\Fax No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfile No errors.
Sulu\Bundle\ContactBundle\Entity\BankAccount No errors.
App\Entity\Icpe No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain No errors.