GET https://www.imagohealthsystems.com/fr/news/la-vue-est-retablie-apres-l-operation

Response
200 OK
IP
216.73.216.79
Profiled on
Token
8e7bc0

Query Metrics

72 Database Queries
30 Different statements
125.54 ms Query time
0 Invalid entities
73 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.64 ms 
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters: 
[
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.82 ms 
SELECT prefix, uri FROM phpcr_namespaces
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.79 ms 
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters: 
[
  "/cmf/website/routes/fr/news/la-vue-est-retablie-apres-l-operation"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 1.63 ms 
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_id AS target_id_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target_id AS target_id_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target_id = r1_.id WHERE r0_.path = ? AND r0_.locale = ?
Parameters: 
[
  "/news/la-vue-est-retablie-apres-l-operation"
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.83 ms 
SELECT t0.id AS id_1, t0.images AS images_2, t0.type AS type_3, t4.id AS id_5, t4.hide_in_sitemap AS hide_in_sitemap_6, t4.no_follow AS no_follow_7, t4.no_index AS no_index_8, t4.news_id AS news_id_9, t10.id AS id_11, t10.news_id AS news_id_12 FROM app_news t0 LEFT JOIN app_news_seo t4 ON t4.news_id = t0.id LEFT JOIN app_news_excerpt t10 ON t10.news_id = t0.id WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
6 1.12 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 1.13 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 1.30 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.96 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 1.18 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.70 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 1.04 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.canonical_url AS canonical_url_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.news_seo_id AS news_seo_id_7 FROM app_news_seo_translation t0 WHERE t0.news_seo_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
13 1.02 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.more AS more_4, t0.description AS description_5, t0.news_excerpt_id AS news_excerpt_id_6 FROM app_news_excerpt_translation t0 WHERE t0.news_excerpt_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
14 1.50 ms 
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, r0_.target_id AS target_id_8, r0_.idUsersCreator AS idUsersCreator_9, r0_.idUsersChanger AS idUsersChanger_10 FROM ro_routes r0_ WHERE r0_.entity_class = ? AND r0_.entity_id = ?
Parameters: 
[
  "Manuxi\SuluNewsBundle\Entity\News"
  "3"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 2.39 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 2.22 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 1.46 ms 
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters: 
[
  "/cmf/website"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.97 ms 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/website"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 1.41 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
20 1.45 ms 
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"
  "df893960-7119-45a4-b5ec-f8adbd03f689"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.86 ms 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/snippets/settings/websitesettings"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 1.09 ms 
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters: 
[
  "/cmf/snippets/settings"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.54 ms 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/snippets/settings"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 4.99 ms 
SELECT c0_.lft AS lft_0, c0_.rgt AS rgt_1, c0_.depth AS depth_2, c0_.name AS name_3, c0_.externalId AS externalId_4, c0_.number AS number_5, c0_.corporation AS corporation_6, c0_.note AS note_7, c0_.uid AS uid_8, c0_.registerNumber AS registerNumber_9, c0_.placeOfJurisdiction AS placeOfJurisdiction_10, c0_.mainEmail AS mainEmail_11, c0_.mainPhone AS mainPhone_12, c0_.mainFax AS mainFax_13, c0_.mainUrl AS mainUrl_14, c0_.id AS id_15, c0_.created AS created_16, c0_.changed AS changed_17, c1_.category_key AS category_key_18, c1_.default_locale AS default_locale_19, c1_.lft AS lft_20, c1_.rgt AS rgt_21, c1_.depth AS depth_22, c1_.id AS id_23, c1_.created AS created_24, c1_.changed AS changed_25, c2_.translation AS translation_26, c2_.locale AS locale_27, c2_.description AS description_28, c2_.id AS id_29, c2_.created AS created_30, c2_.changed AS changed_31, c3_.main AS main_32, c3_.id AS id_33, c4_.title AS title_34, c4_.primaryAddress AS primaryAddress_35, c4_.deliveryAddress AS deliveryAddress_36, c4_.billingAddress AS billingAddress_37, c4_.street AS street_38, c4_.number AS number_39, c4_.addition AS addition_40, c4_.zip AS zip_41, c4_.city AS city_42, c4_.state AS state_43, c4_.countryCode AS countryCode_44, c4_.postboxNumber AS postboxNumber_45, c4_.postboxPostcode AS postboxPostcode_46, c4_.postboxCity AS postboxCity_47, c4_.latitude AS latitude_48, c4_.longitude AS longitude_49, c4_.note AS note_50, c4_.id AS id_51, c5_.name AS name_52, c5_.id AS id_53, c6_.lft AS lft_54, c6_.rgt AS rgt_55, c6_.depth AS depth_56, c6_.name AS name_57, c6_.externalId AS externalId_58, c6_.number AS number_59, c6_.corporation AS corporation_60, c6_.note AS note_61, c6_.uid AS uid_62, c6_.registerNumber AS registerNumber_63, c6_.placeOfJurisdiction AS placeOfJurisdiction_64, c6_.mainEmail AS mainEmail_65, c6_.mainPhone AS mainPhone_66, c6_.mainFax AS mainFax_67, c6_.mainUrl AS mainUrl_68, c6_.id AS id_69, c6_.created AS created_70, c6_.changed AS changed_71, c7_.url AS url_72, c7_.id AS id_73, c8_.name AS name_74, c8_.id AS id_75, c9_.phone AS phone_76, c9_.id AS id_77, c10_.name AS name_78, c10_.id AS id_79, c11_.email AS email_80, c11_.id AS id_81, c12_.name AS name_82, c12_.id AS id_83, c13_.value AS value_84, c13_.id AS id_85, c14_.fax AS fax_86, c14_.id AS id_87, c15_.name AS name_88, c15_.id AS id_89, c16_.bankName AS bankName_90, c16_.bic AS bic_91, c16_.iban AS iban_92, c16_.public AS public_93, c16_.id AS id_94, t17_.name AS name_95, t17_.id AS id_96, c18_.firstName AS firstName_97, c18_.middleName AS middleName_98, c18_.lastName AS lastName_99, c18_.birthday AS birthday_100, c18_.salutation AS salutation_101, c18_.formOfAddress AS formOfAddress_102, c18_.newsletter AS newsletter_103, c18_.gender AS gender_104, c18_.note AS note_105, c18_.mainEmail AS mainEmail_106, c18_.mainPhone AS mainPhone_107, c18_.mainFax AS mainFax_108, c18_.mainUrl AS mainUrl_109, c18_.id AS id_110, c18_.created AS created_111, c18_.changed AS changed_112, m19_.id AS id_113, m19_.created AS created_114, m19_.changed AS changed_115, c0_.idContactsMain AS idContactsMain_116, c0_.idAccountsParent AS idAccountsParent_117, c0_.logo AS logo_118, c0_.idUsersCreator AS idUsersCreator_119, c0_.idUsersChanger AS idUsersChanger_120, c1_.idCategoriesParent AS idCategoriesParent_121, c1_.idUsersCreator AS idUsersCreator_122, c1_.idUsersChanger AS idUsersChanger_123, c2_.idCategories AS idCategories_124, c2_.idUsersCreator AS idUsersCreator_125, c2_.idUsersChanger AS idUsersChanger_126, c3_.idAddresses AS idAddresses_127, c3_.idAccounts AS idAccounts_128, c4_.idAdressTypes AS idAdressTypes_129, c6_.idContactsMain AS idContactsMain_130, c6_.idAccountsParent AS idAccountsParent_131, c6_.logo AS logo_132, c6_.idUsersCreator AS idUsersCreator_133, c6_.idUsersChanger AS idUsersChanger_134, c7_.idUrlTypes AS idUrlTypes_135, c9_.idPhoneTypes AS idPhoneTypes_136, c11_.idEmailTypes AS idEmailTypes_137, c14_.idFaxTypes AS idFaxTypes_138, t17_.idUsersCreator AS idUsersCreator_139, t17_.idUsersChanger AS idUsersChanger_140, c18_.idTitles AS idTitles_141, c18_.avatar AS avatar_142, c18_.idUsersCreator AS idUsersCreator_143, c18_.idUsersChanger AS idUsersChanger_144, m19_.idMediaTypes AS idMediaTypes_145, m19_.idPreviewImage AS idPreviewImage_146, m19_.idCollections AS idCollections_147, m19_.idUsersCreator AS idUsersCreator_148, m19_.idUsersChanger AS idUsersChanger_149 FROM co_accounts c0_ LEFT JOIN co_account_categories c20_ ON c0_.id = c20_.idAccounts LEFT JOIN ca_categories c1_ ON c1_.id = c20_.idCategories LEFT JOIN ca_category_translations c2_ ON c1_.id = c2_.idCategories LEFT JOIN co_account_addresses c3_ ON c0_.id = c3_.idAccounts LEFT JOIN co_addresses c4_ ON c3_.idAddresses = c4_.id LEFT JOIN co_address_types c5_ ON c4_.idAdressTypes = c5_.id LEFT JOIN co_accounts c6_ ON c0_.idAccountsParent = c6_.id LEFT JOIN co_account_urls c21_ ON c0_.id = c21_.idAccounts LEFT JOIN co_urls c7_ ON c7_.id = c21_.idUrls LEFT JOIN co_url_types c8_ ON c7_.idUrlTypes = c8_.id LEFT JOIN co_account_phones c22_ ON c0_.id = c22_.idAccounts LEFT JOIN co_phones c9_ ON c9_.id = c22_.idPhones LEFT JOIN co_phone_types c10_ ON c9_.idPhoneTypes = c10_.id LEFT JOIN co_account_emails c23_ ON c0_.id = c23_.idAccounts LEFT JOIN co_emails c11_ ON c11_.id = c23_.idEmails LEFT JOIN co_email_types c12_ ON c11_.idEmailTypes = c12_.id LEFT JOIN co_account_notes c24_ ON c0_.id = c24_.idAccounts LEFT JOIN co_notes c13_ ON c13_.id = c24_.idNotes LEFT JOIN co_account_faxes c25_ ON c0_.id = c25_.idAccounts LEFT JOIN co_faxes c14_ ON c14_.id = c25_.idFaxes LEFT JOIN co_fax_types c15_ ON c14_.idFaxTypes = c15_.id LEFT JOIN co_account_social_media_profiles c27_ ON c0_.id = c27_.idAccounts LEFT JOIN co_social_media_profiles c26_ ON c26_.id = c27_.idSocialMediaProfiles LEFT JOIN co_social_media_profile_types c28_ ON c26_.idSocialMediaTypes = c28_.id LEFT JOIN co_account_bank_accounts c29_ ON c0_.id = c29_.idAccounts LEFT JOIN co_bank_account c16_ ON c16_.id = c29_.idBankAccounts LEFT JOIN co_account_tags c30_ ON c0_.id = c30_.idAccounts LEFT JOIN ta_tags t17_ ON t17_.id = c30_.idTags LEFT JOIN co_contacts c18_ ON c0_.idContactsMain = c18_.id LEFT JOIN co_account_medias c31_ ON c0_.id = c31_.idAccounts LEFT JOIN me_media m19_ ON m19_.id = c31_.idMedias WHERE c0_.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
25 2.67 ms 
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: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
26 1.38 ms 
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
]
View formatted query    View runnable query    Explain query    View query backtrace
27 4.22 ms 
SELECT f0_.defaultLocale AS defaultLocale_0, f0_.id AS id_1, f1_.title AS title_2, f1_.subject AS subject_3, f1_.fromEmail AS fromEmail_4, f1_.fromName AS fromName_5, f1_.toEmail AS toEmail_6, f1_.toName AS toName_7, f1_.mailText AS mailText_8, f1_.submitLabel AS submitLabel_9, f1_.successText AS successText_10, f1_.sendAttachments AS sendAttachments_11, f1_.deactivateAttachmentSave AS deactivateAttachmentSave_12, f1_.deactivateNotifyMails AS deactivateNotifyMails_13, f1_.deactivateCustomerMails AS deactivateCustomerMails_14, f1_.replyTo AS replyTo_15, f1_.locale AS locale_16, f1_.id AS id_17, f1_.created AS created_18, f1_.changed AS changed_19, f2_.keyName AS keyName_20, f2_.orderNumber AS orderNumber_21, f2_.type AS type_22, f2_.width AS width_23, f2_.required AS required_24, f2_.defaultLocale AS defaultLocale_25, f2_.id AS id_26, f3_.title AS title_27, f3_.placeholder AS placeholder_28, f3_.defaultValue AS defaultValue_29, f3_.shortTitle AS shortTitle_30, f3_.locale AS locale_31, f3_.options AS options_32, f3_.id AS id_33, f4_.type AS type_34, f4_.email AS email_35, f4_.name AS name_36, f4_.id AS id_37, f1_.idForms AS idForms_38, f1_.idUsersCreator AS idUsersCreator_39, f1_.idUsersChanger AS idUsersChanger_40, f2_.idForms AS idForms_41, f3_.idFormFields AS idFormFields_42, f4_.idFormTranslations AS idFormTranslations_43 FROM fo_forms f0_ LEFT JOIN fo_form_translations f1_ ON f0_.id = f1_.idForms LEFT JOIN fo_form_fields f2_ ON f0_.id = f2_.idForms LEFT JOIN fo_form_field_translations f3_ ON f2_.id = f3_.idFormFields LEFT JOIN fo_form_translation_receivers f4_ ON f1_.id = f4_.idFormTranslations WHERE f0_.id = ? ORDER BY f2_.orderNumber ASC
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
28 3.26 ms 
SELECT f0_.defaultLocale AS defaultLocale_0, f0_.id AS id_1, f1_.title AS title_2, f1_.subject AS subject_3, f1_.fromEmail AS fromEmail_4, f1_.fromName AS fromName_5, f1_.toEmail AS toEmail_6, f1_.toName AS toName_7, f1_.mailText AS mailText_8, f1_.submitLabel AS submitLabel_9, f1_.successText AS successText_10, f1_.sendAttachments AS sendAttachments_11, f1_.deactivateAttachmentSave AS deactivateAttachmentSave_12, f1_.deactivateNotifyMails AS deactivateNotifyMails_13, f1_.deactivateCustomerMails AS deactivateCustomerMails_14, f1_.replyTo AS replyTo_15, f1_.locale AS locale_16, f1_.id AS id_17, f1_.created AS created_18, f1_.changed AS changed_19, f2_.keyName AS keyName_20, f2_.orderNumber AS orderNumber_21, f2_.type AS type_22, f2_.width AS width_23, f2_.required AS required_24, f2_.defaultLocale AS defaultLocale_25, f2_.id AS id_26, f3_.title AS title_27, f3_.placeholder AS placeholder_28, f3_.defaultValue AS defaultValue_29, f3_.shortTitle AS shortTitle_30, f3_.locale AS locale_31, f3_.options AS options_32, f3_.id AS id_33, f4_.type AS type_34, f4_.email AS email_35, f4_.name AS name_36, f4_.id AS id_37, f1_.idForms AS idForms_38, f1_.idUsersCreator AS idUsersCreator_39, f1_.idUsersChanger AS idUsersChanger_40, f2_.idForms AS idForms_41, f3_.idFormFields AS idFormFields_42, f4_.idFormTranslations AS idFormTranslations_43 FROM fo_forms f0_ LEFT JOIN fo_form_translations f1_ ON f0_.id = f1_.idForms LEFT JOIN fo_form_fields f2_ ON f0_.id = f2_.idForms LEFT JOIN fo_form_field_translations f3_ ON f2_.id = f3_.idFormFields LEFT JOIN fo_form_translation_receivers f4_ ON f1_.id = f4_.idFormTranslations WHERE f0_.id = ? ORDER BY f2_.orderNumber ASC
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
29 2.10 ms 
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: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
30 2.09 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
31 2.21 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
32 17.34 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: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/website/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"
]
View formatted query    View runnable query    Explain query    View query backtrace
33 2.18 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 = ? AND (path = ? OR path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC
Parameters: 
[
  "default_live"
  "/cmf/website/contents/home"
  "/cmf/website/contents/our-experts"
  "/cmf/website/contents/appointment"
  "/cmf/website/contents/contact-us"
]
View formatted query    View runnable query    Explain query    View query backtrace
34 2.07 ms 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/website/contents/home"
  "/cmf/website/contents/our-experts"
  "/cmf/website/contents/appointment"
  "/cmf/website/contents/contact-us"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
35 3.31 ms 
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters: 
[
  "/cmf/website/contents"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
36 1.26 ms 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/website/contents"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
37 1.45 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
38 2.62 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.87 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.55 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.57 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.62 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.51 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
44 1.13 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.57 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
46 1.65 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.47 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.59 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.45 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.51 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
51 1.50 ms 
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: 
[
  45
]
View formatted query    View runnable query    Explain query    View query backtrace
52 1.06 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
53 1.42 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.81 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
55 1.28 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.67 ms 
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.48 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
Parameters: 
[
  3
  "fr"
]
View formatted query    View runnable query    Explain query    View query backtrace
58 1.86 ms 
SELECT DISTINCT a0_.id AS id_0, a0_.images AS images_1, a0_.type AS type_2 FROM app_news a0_ LEFT JOIN app_news_translation a1_ ON a0_.id = a1_.news_id WHERE a1_.locale = ? AND a1_.published = ? AND a0_.type <> ? AND a0_.id <> ? ORDER BY a1_.authored DESC LIMIT 5
Parameters: 
[
  "fr"
  1
  "announcement"
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.63 ms 
SELECT t0.id AS id_1, t0.hide_in_sitemap AS hide_in_sitemap_2, t0.no_follow AS no_follow_3, t0.no_index AS no_index_4, t0.news_id AS news_id_5 FROM app_news_seo t0 WHERE t0.news_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.37 ms 
SELECT t0.id AS id_1, t0.news_id AS news_id_2 FROM app_news_excerpt t0 WHERE t0.news_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.35 ms 
SELECT t0.id AS id_1, t0.hide_in_sitemap AS hide_in_sitemap_2, t0.no_follow AS no_follow_3, t0.no_index AS no_index_4, t0.news_id AS news_id_5 FROM app_news_seo t0 WHERE t0.news_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.40 ms 
SELECT t0.id AS id_1, t0.news_id AS news_id_2 FROM app_news_excerpt t0 WHERE t0.news_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
63 1.09 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.87 ms 
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
65 2.56 ms 
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: 
[
  17
]
View formatted query    View runnable query    Explain query    View query backtrace
66 6.42 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: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"]) > 0')) AND n0.path LIKE '/cmf/website/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"
]
View formatted query    View runnable query    Explain query    View query backtrace
67 1.30 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 = ? AND (path = ?) ORDER BY sort_order ASC
Parameters: 
[
  "default_live"
  "/cmf/website/contents/staff-login"
]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.70 ms 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/website/contents/staff-login"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
69 6.88 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: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_right"]) > 0')) AND n0.path LIKE '/cmf/website/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"
]
View formatted query    View runnable query    Explain query    View query backtrace
70 1.49 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 = ? AND (path = ? OR path = ?) ORDER BY sort_order ASC
Parameters: 
[
  "default_live"
  "/cmf/website/contents/privacy-policy"
  "/cmf/website/contents/terms-and-conditions"
]
View formatted query    View runnable query    Explain query    View query backtrace
71 1.13 ms 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/website/contents/privacy-policy"
  "/cmf/website/contents/terms-and-conditions"
  "default_live"
]
View formatted query    View runnable query    Explain query    View query backtrace
72 1.59 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: 
[
  "www.imagohealthsystems.com/{localization}"
  "dev"
  "website"
]
View formatted query    View runnable query    Explain query    View query backtrace

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
Sulu\Bundle\FormBundle\Entity\FormFieldTranslation 10
Manuxi\SuluNewsBundle\Entity\NewsTranslation 7
Sulu\Bundle\MediaBundle\Entity\Media 5
Sulu\Bundle\RouteBundle\Entity\Route 4
Sulu\Bundle\FormBundle\Entity\FormField 4
Manuxi\SuluNewsBundle\Entity\News 3
Manuxi\SuluNewsBundle\Entity\NewsSeo 3
Manuxi\SuluNewsBundle\Entity\NewsExcerpt 3
Manuxi\SuluNewsBundle\Entity\NewsSeoTranslation 3
Sulu\Bundle\MediaBundle\Entity\Collection 3
Sulu\Bundle\MediaBundle\Entity\File 3
Sulu\Bundle\MediaBundle\Entity\FileVersion 3
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta 3
Sulu\Bundle\FormBundle\Entity\FormTranslation 3
Sulu\Bundle\MediaBundle\Entity\CollectionMeta 2
Sulu\Bundle\MediaBundle\Entity\CollectionType 2
Sulu\Bundle\SecurityBundle\Entity\User 1
Sulu\Bundle\ContactBundle\Entity\Contact 1
Sulu\Bundle\ContactBundle\Entity\Account 1
Sulu\Bundle\ContactBundle\Entity\AccountAddress 1
Sulu\Bundle\ContactBundle\Entity\Address 1
Sulu\Bundle\ContactBundle\Entity\AddressType 1
Sulu\Bundle\ContactBundle\Entity\Phone 1
Sulu\Bundle\ContactBundle\Entity\PhoneType 1
Sulu\Bundle\ContactBundle\Entity\Email 1
Sulu\Bundle\ContactBundle\Entity\EmailType 1
Sulu\Bundle\MediaBundle\Entity\MediaType 1
Sulu\Bundle\FormBundle\Entity\Form 1

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.
Manuxi\SuluNewsBundle\Entity\News No errors.
Manuxi\SuluNewsBundle\Entity\NewsSeo No errors.
Manuxi\SuluNewsBundle\Entity\NewsExcerpt No errors.
Manuxi\SuluNewsBundle\Entity\NewsTranslation No errors.
Manuxi\SuluNewsBundle\Entity\NewsSeoTranslation No errors.
Manuxi\SuluNewsBundle\Entity\NewsExcerptTranslation No errors.
Sulu\Bundle\ContactBundle\Entity\Contact No errors.
Sulu\Bundle\MediaBundle\Entity\Media No errors.
Sulu\Bundle\FormBundle\Entity\Form No errors.
Sulu\Bundle\ContactBundle\Entity\Account No errors.
Sulu\Bundle\CategoryBundle\Entity\Category No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation No errors.
Sulu\Bundle\ContactBundle\Entity\AccountAddress No errors.
Sulu\Bundle\ContactBundle\Entity\Address No errors.
Sulu\Bundle\ContactBundle\Entity\AddressType No errors.
Sulu\Bundle\ContactBundle\Entity\Url No errors.
Sulu\Bundle\ContactBundle\Entity\UrlType No errors.
Sulu\Bundle\ContactBundle\Entity\Phone No errors.
Sulu\Bundle\ContactBundle\Entity\PhoneType No errors.
Sulu\Bundle\ContactBundle\Entity\Email No errors.
Sulu\Bundle\ContactBundle\Entity\EmailType No errors.
Sulu\Bundle\ContactBundle\Entity\Note No errors.
Sulu\Bundle\ContactBundle\Entity\Fax No errors.
Sulu\Bundle\ContactBundle\Entity\FaxType No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfile No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfileType No errors.
Sulu\Bundle\ContactBundle\Entity\BankAccount No errors.
Sulu\Bundle\TagBundle\Entity\Tag No errors.
Sulu\Bundle\MediaBundle\Entity\MediaType No errors.
Sulu\Bundle\ContactBundle\Entity\AccountContact No errors.
Sulu\Bundle\ContactBundle\Entity\ContactAddress 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\MediaBundle\Entity\CollectionMeta No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionType 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\FormBundle\Entity\FormTranslation No errors.
Sulu\Bundle\FormBundle\Entity\FormField No errors.
Sulu\Bundle\FormBundle\Entity\FormFieldTranslation No errors.
Sulu\Bundle\FormBundle\Entity\FormTranslationReceiver No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItemTranslation No errors.
Sulu\Bundle\SecurityBundle\Entity\Role No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryMeta No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslationMedia No errors.
Sulu\Bundle\CategoryBundle\Entity\Keyword No errors.
Sulu\Bundle\ContactBundle\Entity\Position No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain No errors.