Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.file AS file_4,
  t0.published AS published_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.category AS category_8
FROM
  app_guide t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.file AS file_4, t0.published AS published_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.category AS category_8 FROM app_guide t0 WHERE t0.id = '2';

SELECT
  m0_.type AS type_0,
  m0_.id AS id_1,
  m0_.created AS created_2,
  m0_.changed AS changed_3,
  m1_.style AS style_4,
  m1_.lft AS lft_5,
  m1_.rgt AS rgt_6,
  m1_.depth AS depth_7,
  m1_.collection_key AS collection_key_8,
  m1_.id AS id_9,
  m1_.created AS created_10,
  m1_.changed AS changed_11,
  m2_.version AS version_12,
  m2_.id AS id_13,
  m2_.created AS created_14,
  m2_.changed AS changed_15,
  m3_.name AS name_16,
  m3_.version AS version_17,
  m3_.subVersion AS subVersion_18,
  m3_.size AS size_19,
  m3_.downloadCounter AS downloadCounter_20,
  m3_.storageOptions AS storageOptions_21,
  m3_.mimeType AS mimeType_22,
  m3_.properties AS properties_23,
  m3_.focusPointX AS focusPointX_24,
  m3_.focusPointY AS focusPointY_25,
  m3_.id AS id_26,
  m3_.created AS created_27,
  m3_.changed AS changed_28,
  m4_.crop_x AS crop_x_29,
  m4_.crop_y AS crop_y_30,
  m4_.crop_width AS crop_width_31,
  m4_.crop_height AS crop_height_32,
  m4_.format_key AS format_key_33,
  m5_.title AS title_34,
  m5_.description AS description_35,
  m5_.copyright AS copyright_36,
  m5_.credits AS credits_37,
  m5_.locale AS locale_38,
  m5_.id AS id_39,
  m6_.title AS title_40,
  m6_.description AS description_41,
  m6_.copyright AS copyright_42,
  m6_.credits AS credits_43,
  m6_.locale AS locale_44,
  m6_.id AS id_45,
  s7_.username AS username_46,
  s7_.password AS password_47,
  s7_.locale AS locale_48,
  s7_.salt AS salt_49,
  s7_.locked AS locked_50,
  s7_.enabled AS enabled_51,
  s7_.lastLogin AS lastLogin_52,
  s7_.confirmationKey AS confirmationKey_53,
  s7_.passwordResetToken AS passwordResetToken_54,
  s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_55,
  s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_56,
  s7_.privateKey AS privateKey_57,
  s7_.apiKey AS apiKey_58,
  s7_.email AS email_59,
  s7_.id AS id_60,
  s7_.created AS created_61,
  s7_.changed AS changed_62,
  c8_.firstName AS firstName_63,
  c8_.middleName AS middleName_64,
  c8_.lastName AS lastName_65,
  c8_.birthday AS birthday_66,
  c8_.salutation AS salutation_67,
  c8_.formOfAddress AS formOfAddress_68,
  c8_.newsletter AS newsletter_69,
  c8_.gender AS gender_70,
  c8_.note AS note_71,
  c8_.mainEmail AS mainEmail_72,
  c8_.mainPhone AS mainPhone_73,
  c8_.mainFax AS mainFax_74,
  c8_.mainUrl AS mainUrl_75,
  c8_.id AS id_76,
  c8_.created AS created_77,
  c8_.changed AS changed_78,
  s9_.username AS username_79,
  s9_.password AS password_80,
  s9_.locale AS locale_81,
  s9_.salt AS salt_82,
  s9_.locked AS locked_83,
  s9_.enabled AS enabled_84,
  s9_.lastLogin AS lastLogin_85,
  s9_.confirmationKey AS confirmationKey_86,
  s9_.passwordResetToken AS passwordResetToken_87,
  s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_88,
  s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_89,
  s9_.privateKey AS privateKey_90,
  s9_.apiKey AS apiKey_91,
  s9_.email AS email_92,
  s9_.id AS id_93,
  s9_.created AS created_94,
  s9_.changed AS changed_95,
  c10_.firstName AS firstName_96,
  c10_.middleName AS middleName_97,
  c10_.lastName AS lastName_98,
  c10_.birthday AS birthday_99,
  c10_.salutation AS salutation_100,
  c10_.formOfAddress AS formOfAddress_101,
  c10_.newsletter AS newsletter_102,
  c10_.gender AS gender_103,
  c10_.note AS note_104,
  c10_.mainEmail AS mainEmail_105,
  c10_.mainPhone AS mainPhone_106,
  c10_.mainFax AS mainFax_107,
  c10_.mainUrl AS mainUrl_108,
  c10_.id AS id_109,
  c10_.created AS created_110,
  c10_.changed AS changed_111,
  m11_.type AS type_112,
  m11_.id AS id_113,
  m11_.created AS created_114,
  m11_.changed AS changed_115,
  m0_.idPreviewImage AS idPreviewImage_116,
  m0_.idCollections AS idCollections_117,
  m0_.idUsersCreator AS idUsersCreator_118,
  m0_.idUsersChanger AS idUsersChanger_119,
  m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_120,
  m1_.idCollectionTypes AS idCollectionTypes_121,
  m1_.idCollectionsParent AS idCollectionsParent_122,
  m1_.idUsersCreator AS idUsersCreator_123,
  m1_.idUsersChanger AS idUsersChanger_124,
  m2_.idMedia AS idMedia_125,
  m2_.idUsersCreator AS idUsersCreator_126,
  m2_.idUsersChanger AS idUsersChanger_127,
  m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_128,
  m3_.idFiles AS idFiles_129,
  m3_.idUsersCreator AS idUsersCreator_130,
  m3_.idUsersChanger AS idUsersChanger_131,
  m4_.fileVersion AS fileVersion_132,
  m5_.idFileVersions AS idFileVersions_133,
  m6_.idFileVersions AS idFileVersions_134,
  s7_.idContacts AS idContacts_135,
  s7_.idUsersCreator AS idUsersCreator_136,
  s7_.idUsersChanger AS idUsersChanger_137,
  c8_.idTitles AS idTitles_138,
  c8_.avatar AS avatar_139,
  c8_.idUsersCreator AS idUsersCreator_140,
  c8_.idUsersChanger AS idUsersChanger_141,
  s9_.idContacts AS idContacts_142,
  s9_.idUsersCreator AS idUsersCreator_143,
  s9_.idUsersChanger AS idUsersChanger_144,
  c10_.idTitles AS idTitles_145,
  c10_.avatar AS avatar_146,
  c10_.idUsersCreator AS idUsersCreator_147,
  c10_.idUsersChanger AS idUsersChanger_148,
  m11_.idPreviewImage AS idPreviewImage_149,
  m11_.idCollections AS idCollections_150,
  m11_.idUsersCreator AS idUsersCreator_151,
  m11_.idUsersChanger AS idUsersChanger_152
FROM
  me_media m0_
  LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id
  LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia
  LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles
  LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion
  LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions
  LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id
  LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id
  LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id
  LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id
  LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id
  LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id
WHERE
  m0_.id = ?

SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.id AS id_26, m3_.created AS created_27, m3_.changed AS changed_28, m4_.crop_x AS crop_x_29, m4_.crop_y AS crop_y_30, m4_.crop_width AS crop_width_31, m4_.crop_height AS crop_height_32, m4_.format_key AS format_key_33, m5_.title AS title_34, m5_.description AS description_35, m5_.copyright AS copyright_36, m5_.credits AS credits_37, m5_.locale AS locale_38, m5_.id AS id_39, m6_.title AS title_40, m6_.description AS description_41, m6_.copyright AS copyright_42, m6_.credits AS credits_43, m6_.locale AS locale_44, m6_.id AS id_45, s7_.username AS username_46, s7_.password AS password_47, s7_.locale AS locale_48, s7_.salt AS salt_49, s7_.locked AS locked_50, s7_.enabled AS enabled_51, s7_.lastLogin AS lastLogin_52, s7_.confirmationKey AS confirmationKey_53, s7_.passwordResetToken AS passwordResetToken_54, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_55, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_56, s7_.privateKey AS privateKey_57, s7_.apiKey AS apiKey_58, s7_.email AS email_59, s7_.id AS id_60, s7_.created AS created_61, s7_.changed AS changed_62, c8_.firstName AS firstName_63, c8_.middleName AS middleName_64, c8_.lastName AS lastName_65, c8_.birthday AS birthday_66, c8_.salutation AS salutation_67, c8_.formOfAddress AS formOfAddress_68, c8_.newsletter AS newsletter_69, c8_.gender AS gender_70, c8_.note AS note_71, c8_.mainEmail AS mainEmail_72, c8_.mainPhone AS mainPhone_73, c8_.mainFax AS mainFax_74, c8_.mainUrl AS mainUrl_75, c8_.id AS id_76, c8_.created AS created_77, c8_.changed AS changed_78, s9_.username AS username_79, s9_.password AS password_80, s9_.locale AS locale_81, s9_.salt AS salt_82, s9_.locked AS locked_83, s9_.enabled AS enabled_84, s9_.lastLogin AS lastLogin_85, s9_.confirmationKey AS confirmationKey_86, s9_.passwordResetToken AS passwordResetToken_87, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_88, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_89, s9_.privateKey AS privateKey_90, s9_.apiKey AS apiKey_91, s9_.email AS email_92, s9_.id AS id_93, s9_.created AS created_94, s9_.changed AS changed_95, c10_.firstName AS firstName_96, c10_.middleName AS middleName_97, c10_.lastName AS lastName_98, c10_.birthday AS birthday_99, c10_.salutation AS salutation_100, c10_.formOfAddress AS formOfAddress_101, c10_.newsletter AS newsletter_102, c10_.gender AS gender_103, c10_.note AS note_104, c10_.mainEmail AS mainEmail_105, c10_.mainPhone AS mainPhone_106, c10_.mainFax AS mainFax_107, c10_.mainUrl AS mainUrl_108, c10_.id AS id_109, c10_.created AS created_110, c10_.changed AS changed_111, m11_.type AS type_112, m11_.id AS id_113, m11_.created AS created_114, m11_.changed AS changed_115, m0_.idPreviewImage AS idPreviewImage_116, m0_.idCollections AS idCollections_117, m0_.idUsersCreator AS idUsersCreator_118, m0_.idUsersChanger AS idUsersChanger_119, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_120, m1_.idCollectionTypes AS idCollectionTypes_121, m1_.idCollectionsParent AS idCollectionsParent_122, m1_.idUsersCreator AS idUsersCreator_123, m1_.idUsersChanger AS idUsersChanger_124, m2_.idMedia AS idMedia_125, m2_.idUsersCreator AS idUsersCreator_126, m2_.idUsersChanger AS idUsersChanger_127, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_128, m3_.idFiles AS idFiles_129, m3_.idUsersCreator AS idUsersCreator_130, m3_.idUsersChanger AS idUsersChanger_131, m4_.fileVersion AS fileVersion_132, m5_.idFileVersions AS idFileVersions_133, m6_.idFileVersions AS idFileVersions_134, s7_.idContacts AS idContacts_135, s7_.idUsersCreator AS idUsersCreator_136, s7_.idUsersChanger AS idUsersChanger_137, c8_.idTitles AS idTitles_138, c8_.avatar AS avatar_139, c8_.idUsersCreator AS idUsersCreator_140, c8_.idUsersChanger AS idUsersChanger_141, s9_.idContacts AS idContacts_142, s9_.idUsersCreator AS idUsersCreator_143, s9_.idUsersChanger AS idUsersChanger_144, c10_.idTitles AS idTitles_145, c10_.avatar AS avatar_146, c10_.idUsersCreator AS idUsersCreator_147, c10_.idUsersChanger AS idUsersChanger_148, m11_.idPreviewImage AS idPreviewImage_149, m11_.idCollections AS idCollections_150, m11_.idUsersCreator AS idUsersCreator_151, m11_.idUsersChanger AS idUsersChanger_152 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = 32;

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 = ?

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 = 2;

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

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 = 'i.actions-croisees08.fr' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'action_croisee' ORDER BY w0_.id ASC;