Symfony Profiler

SELECT
  t0.email AS email_1,
  t0.is_verified AS is_verified_2,
  t0.onboarding_completed AS onboarding_completed_3,
  t0.roles AS roles_4,
  t0.status AS status_5,
  t0.terms AS terms_6,
  t0.password AS password_7,
  t0.oauth_provider AS oauth_provider_8,
  t0.oauth_id AS oauth_id_9,
  t0.email_opt_in AS email_opt_in_10,
  t0.unsubscribed_at AS unsubscribed_at_11,
  t0.id AS id_12,
  t0.slug AS slug_13,
  t0.phone AS phone_14,
  t15.website AS website_16,
  t15.last_login AS last_login_17,
  t15.sex AS sex_18,
  t15.nickname AS nickname_19,
  t15.birthday AS birthday_20,
  t15.bio AS bio_21,
  t15.firstname AS firstname_22,
  t15.lastname AS lastname_23,
  t15.aliases AS aliases_24,
  t15.nationality AS nationality_25,
  t15.place_of_birth AS place_of_birth_26,
  t15.id AS id_27,
  t15.created_at AS created_at_28,
  t15.updated_at AS updated_at_29,
  t15.loc_country AS loc_country_30,
  t15.loc_state AS loc_state_31,
  t15.loc_city AS loc_city_32,
  t15.loc_address AS loc_address_33,
  t15.loc_post AS loc_post_34,
  t15.loc_ip AS loc_ip_35,
  t15.user_id AS user_id_36,
  t37.character_class AS character_class_38,
  t37.last_class_change_level AS last_class_change_level_39,
  t37.level AS level_40,
  t37.xp AS xp_41,
  t37.strength AS strength_42,
  t37.dexterity AS dexterity_43,
  t37.constitution AS constitution_44,
  t37.intelligence AS intelligence_45,
  t37.wisdom AS wisdom_46,
  t37.charisma AS charisma_47,
  t37.stat_points AS stat_points_48,
  t37.skill_points AS skill_points_49,
  t37.hp AS hp_50,
  t37.hp_last_regen_at AS hp_last_regen_at_51,
  t37.defensive_bonus AS defensive_bonus_52,
  t37.ap AS ap_53,
  t37.ap_last_regen_at AS ap_last_regen_at_54,
  t37.energy AS energy_55,
  t37.energy_last_regen_at AS energy_last_regen_at_56,
  t37.gather_available AS gather_available_57,
  t37.id AS id_58,
  t37.created_at AS created_at_59,
  t37.updated_at AS updated_at_60,
  t37.user_id AS user_id_61,
  t37.region_id AS region_id_62,
  t37.squad_id AS squad_id_63,
  t64.cash_balance AS cash_balance_65,
  t64.id AS id_66,
  t64.user_id AS user_id_67,
  t68.relationship AS relationship_69,
  t68.height AS height_70,
  t68.weight AS weight_71,
  t68.body AS body_72,
  t68.sex_pref AS sex_pref_73,
  t68.activity_level AS activity_level_74,
  t68.hobbies AS hobbies_75,
  t68.turnons AS turnons_76,
  t68.turnoffs AS turnoffs_77,
  t68.ethnicity AS ethnicity_78,
  t68.hair AS hair_79,
  t68.eye AS eye_80,
  t68.chest AS chest_81,
  t68.waist AS waist_82,
  t68.hip AS hip_83,
  t68.tattoos AS tattoos_84,
  t68.piercings AS piercings_85,
  t68.bra AS bra_86,
  t68.born AS born_87,
  t68.cover_focal_x AS cover_focal_x_88,
  t68.cover_focal_y AS cover_focal_y_89,
  t68.avatar_focal_x AS avatar_focal_x_90,
  t68.avatar_focal_y AS avatar_focal_y_91,
  t68.id AS id_92,
  t68.user_id AS user_id_93,
  t94.units AS units_95,
  t94.color AS color_96,
  t94.privacy AS privacy_97,
  t94.widgets AS widgets_98,
  t94.dashboard AS dashboard_99,
  t94.pinned_apps AS pinned_apps_100,
  t94.id AS id_101,
  t94.nsfw AS nsfw_102,
  t94.user_id AS user_id_103,
  t104.completed AS completed_105,
  t104.lvl AS lvl_106,
  t104.last AS last_107,
  t104.puzzle AS puzzle_108,
  t104.letter_map AS letter_map_109,
  t104.hints AS hints_110,
  t104.lives AS lives_111,
  t104.coins AS coins_112,
  t104.preferences AS preferences_113,
  t104.id AS id_114,
  t104.user_id AS user_id_115,
  t104.quote_id AS quote_id_116,
  t117.is_active AS is_active_118,
  t117.is_public AS is_public_119,
  t117.is_searchable AS is_searchable_120,
  t117.is_blog AS is_blog_121,
  t117.is_bucket_list AS is_bucket_list_122,
  t117.is_resume AS is_resume_123,
  t117.social_links AS social_links_124,
  t117.custom_links AS custom_links_125,
  t117.color_theme AS color_theme_126,
  t117.bg_accent AS bg_accent_127,
  t117.cover_photo AS cover_photo_128,
  t117.link_layout AS link_layout_129,
  t117.updated_at AS updated_at_130,
  t117.id AS id_131,
  t117.nsfw AS nsfw_132,
  t117.user_id AS user_id_133,
  t134.headline AS headline_135,
  t134.summary AS summary_136,
  t134.is_active AS is_active_137,
  t134.is_public AS is_public_138,
  t134.is_searchable AS is_searchable_139,
  t134.show_contact_info AS show_contact_info_140,
  t134.id AS id_141,
  t134.user_id AS user_id_142
FROM
  core_user t0
  LEFT JOIN core_profile t15 ON t15.user_id = t0.id
  LEFT JOIN breach_character t37 ON t37.user_id = t0.id
  LEFT JOIN comm_profile t64 ON t64.user_id = t0.id
  LEFT JOIN miso_app_profile t68 ON t68.user_id = t0.id
  LEFT JOIN core_preferences t94 ON t94.user_id = t0.id
  LEFT JOIN miso_app_jorble_player t104 ON t104.user_id = t0.id
  LEFT JOIN miso_app_mi_page t117 ON t117.user_id = t0.id
  LEFT JOIN miso_app_resume_pro t134 ON t134.user_id = t0.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.email AS email_1, t0.is_verified AS is_verified_2, t0.onboarding_completed AS onboarding_completed_3, t0.roles AS roles_4, t0.status AS status_5, t0.terms AS terms_6, t0.password AS password_7, t0.oauth_provider AS oauth_provider_8, t0.oauth_id AS oauth_id_9, t0.email_opt_in AS email_opt_in_10, t0.unsubscribed_at AS unsubscribed_at_11, t0.id AS id_12, t0.slug AS slug_13, t0.phone AS phone_14, t15.website AS website_16, t15.last_login AS last_login_17, t15.sex AS sex_18, t15.nickname AS nickname_19, t15.birthday AS birthday_20, t15.bio AS bio_21, t15.firstname AS firstname_22, t15.lastname AS lastname_23, t15.aliases AS aliases_24, t15.nationality AS nationality_25, t15.place_of_birth AS place_of_birth_26, t15.id AS id_27, t15.created_at AS created_at_28, t15.updated_at AS updated_at_29, t15.loc_country AS loc_country_30, t15.loc_state AS loc_state_31, t15.loc_city AS loc_city_32, t15.loc_address AS loc_address_33, t15.loc_post AS loc_post_34, t15.loc_ip AS loc_ip_35, t15.user_id AS user_id_36, t37.character_class AS character_class_38, t37.last_class_change_level AS last_class_change_level_39, t37.level AS level_40, t37.xp AS xp_41, t37.strength AS strength_42, t37.dexterity AS dexterity_43, t37.constitution AS constitution_44, t37.intelligence AS intelligence_45, t37.wisdom AS wisdom_46, t37.charisma AS charisma_47, t37.stat_points AS stat_points_48, t37.skill_points AS skill_points_49, t37.hp AS hp_50, t37.hp_last_regen_at AS hp_last_regen_at_51, t37.defensive_bonus AS defensive_bonus_52, t37.ap AS ap_53, t37.ap_last_regen_at AS ap_last_regen_at_54, t37.energy AS energy_55, t37.energy_last_regen_at AS energy_last_regen_at_56, t37.gather_available AS gather_available_57, t37.id AS id_58, t37.created_at AS created_at_59, t37.updated_at AS updated_at_60, t37.user_id AS user_id_61, t37.region_id AS region_id_62, t37.squad_id AS squad_id_63, t64.cash_balance AS cash_balance_65, t64.id AS id_66, t64.user_id AS user_id_67, t68.relationship AS relationship_69, t68.height AS height_70, t68.weight AS weight_71, t68.body AS body_72, t68.sex_pref AS sex_pref_73, t68.activity_level AS activity_level_74, t68.hobbies AS hobbies_75, t68.turnons AS turnons_76, t68.turnoffs AS turnoffs_77, t68.ethnicity AS ethnicity_78, t68.hair AS hair_79, t68.eye AS eye_80, t68.chest AS chest_81, t68.waist AS waist_82, t68.hip AS hip_83, t68.tattoos AS tattoos_84, t68.piercings AS piercings_85, t68.bra AS bra_86, t68.born AS born_87, t68.cover_focal_x AS cover_focal_x_88, t68.cover_focal_y AS cover_focal_y_89, t68.avatar_focal_x AS avatar_focal_x_90, t68.avatar_focal_y AS avatar_focal_y_91, t68.id AS id_92, t68.user_id AS user_id_93, t94.units AS units_95, t94.color AS color_96, t94.privacy AS privacy_97, t94.widgets AS widgets_98, t94.dashboard AS dashboard_99, t94.pinned_apps AS pinned_apps_100, t94.id AS id_101, t94.nsfw AS nsfw_102, t94.user_id AS user_id_103, t104.completed AS completed_105, t104.lvl AS lvl_106, t104.last AS last_107, t104.puzzle AS puzzle_108, t104.letter_map AS letter_map_109, t104.hints AS hints_110, t104.lives AS lives_111, t104.coins AS coins_112, t104.preferences AS preferences_113, t104.id AS id_114, t104.user_id AS user_id_115, t104.quote_id AS quote_id_116, t117.is_active AS is_active_118, t117.is_public AS is_public_119, t117.is_searchable AS is_searchable_120, t117.is_blog AS is_blog_121, t117.is_bucket_list AS is_bucket_list_122, t117.is_resume AS is_resume_123, t117.social_links AS social_links_124, t117.custom_links AS custom_links_125, t117.color_theme AS color_theme_126, t117.bg_accent AS bg_accent_127, t117.cover_photo AS cover_photo_128, t117.link_layout AS link_layout_129, t117.updated_at AS updated_at_130, t117.id AS id_131, t117.nsfw AS nsfw_132, t117.user_id AS user_id_133, t134.headline AS headline_135, t134.summary AS summary_136, t134.is_active AS is_active_137, t134.is_public AS is_public_138, t134.is_searchable AS is_searchable_139, t134.show_contact_info AS show_contact_info_140, t134.id AS id_141, t134.user_id AS user_id_142 FROM core_user t0 LEFT JOIN core_profile t15 ON t15.user_id = t0.id LEFT JOIN breach_character t37 ON t37.user_id = t0.id LEFT JOIN comm_profile t64 ON t64.user_id = t0.id LEFT JOIN miso_app_profile t68 ON t68.user_id = t0.id LEFT JOIN core_preferences t94 ON t94.user_id = t0.id LEFT JOIN miso_app_jorble_player t104 ON t104.user_id = t0.id LEFT JOIN miso_app_mi_page t117 ON t117.user_id = t0.id LEFT JOIN miso_app_resume_pro t134 ON t134.user_id = t0.id WHERE t0.slug = 'holly-dolly' LIMIT 1;

SELECT
  count(m0_.id) AS sclr_0
FROM
  miso_app_post m0_
WHERE
  m0_.user_id = ?
  AND m0_.mi_page = 1

SELECT count(m0_.id) AS sclr_0 FROM miso_app_post m0_ WHERE m0_.user_id = 207 AND m0_.mi_page = 1;

SELECT
  COUNT(*)
FROM
  miso_app_mi_page_post t0
WHERE
  t0.user_id = ?

SELECT COUNT(*) FROM miso_app_mi_page_post t0 WHERE t0.user_id = 207;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_13
    FROM
      (
        SELECT
          m0_.content AS content_0,
          m0_.type AS type_1,
          m0_.url AS url_2,
          m0_.url_data AS url_data_3,
          m0_.commenting AS commenting_4,
          m0_.rating_enabled AS rating_enabled_5,
          m0_.rating_total AS rating_total_6,
          m0_.rating_count AS rating_count_7,
          m0_.ups AS ups_8,
          m0_.dns AS dns_9,
          m0_.mi_page AS mi_page_10,
          m0_.auto AS auto_11,
          m0_.sticky AS sticky_12,
          m0_.id AS id_13,
          m0_.created_at AS created_at_14,
          m0_.updated_at AS updated_at_15,
          m0_.nsfw AS nsfw_16,
          m0_.privacy AS privacy_17,
          m0_.tags AS tags_18
        FROM
          miso_app_post m0_
        WHERE
          m0_.user_id = ?
          AND m0_.nsfw IN (?, ?)
          AND m0_.mi_page = 1
        ORDER BY
          m0_.updated_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_13 FROM (SELECT m0_.content AS content_0, m0_.type AS type_1, m0_.url AS url_2, m0_.url_data AS url_data_3, m0_.commenting AS commenting_4, m0_.rating_enabled AS rating_enabled_5, m0_.rating_total AS rating_total_6, m0_.rating_count AS rating_count_7, m0_.ups AS ups_8, m0_.dns AS dns_9, m0_.mi_page AS mi_page_10, m0_.auto AS auto_11, m0_.sticky AS sticky_12, m0_.id AS id_13, m0_.created_at AS created_at_14, m0_.updated_at AS updated_at_15, m0_.nsfw AS nsfw_16, m0_.privacy AS privacy_17, m0_.tags AS tags_18 FROM miso_app_post m0_ WHERE m0_.user_id = 207 AND m0_.nsfw IN (0, 0) AND m0_.mi_page = 1 ORDER BY m0_.updated_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_13
FROM
  (
    SELECT
      DISTINCT id_13,
      updated_at_15
    FROM
      (
        SELECT
          m0_.content AS content_0,
          m0_.type AS type_1,
          m0_.url AS url_2,
          m0_.url_data AS url_data_3,
          m0_.commenting AS commenting_4,
          m0_.rating_enabled AS rating_enabled_5,
          m0_.rating_total AS rating_total_6,
          m0_.rating_count AS rating_count_7,
          m0_.ups AS ups_8,
          m0_.dns AS dns_9,
          m0_.mi_page AS mi_page_10,
          m0_.auto AS auto_11,
          m0_.sticky AS sticky_12,
          m0_.id AS id_13,
          m0_.created_at AS created_at_14,
          m0_.updated_at AS updated_at_15,
          m0_.nsfw AS nsfw_16,
          m0_.privacy AS privacy_17,
          m0_.tags AS tags_18
        FROM
          miso_app_post m0_
        WHERE
          m0_.user_id = ?
          AND m0_.nsfw IN (?, ?)
          AND m0_.mi_page = 1
      ) dctrn_result_inner
    ORDER BY
      updated_at_15 DESC
  ) dctrn_result
LIMIT
  6

SELECT DISTINCT id_13 FROM (SELECT DISTINCT id_13, updated_at_15 FROM (SELECT m0_.content AS content_0, m0_.type AS type_1, m0_.url AS url_2, m0_.url_data AS url_data_3, m0_.commenting AS commenting_4, m0_.rating_enabled AS rating_enabled_5, m0_.rating_total AS rating_total_6, m0_.rating_count AS rating_count_7, m0_.ups AS ups_8, m0_.dns AS dns_9, m0_.mi_page AS mi_page_10, m0_.auto AS auto_11, m0_.sticky AS sticky_12, m0_.id AS id_13, m0_.created_at AS created_at_14, m0_.updated_at AS updated_at_15, m0_.nsfw AS nsfw_16, m0_.privacy AS privacy_17, m0_.tags AS tags_18 FROM miso_app_post m0_ WHERE m0_.user_id = 207 AND m0_.nsfw IN (0, 0) AND m0_.mi_page = 1) dctrn_result_inner ORDER BY updated_at_15 DESC) dctrn_result LIMIT 6;

SELECT
  m0_.content AS content_0,
  m0_.type AS type_1,
  m0_.url AS url_2,
  m0_.url_data AS url_data_3,
  m0_.commenting AS commenting_4,
  m0_.rating_enabled AS rating_enabled_5,
  m0_.rating_total AS rating_total_6,
  m0_.rating_count AS rating_count_7,
  m0_.ups AS ups_8,
  m0_.dns AS dns_9,
  m0_.mi_page AS mi_page_10,
  m0_.auto AS auto_11,
  m0_.sticky AS sticky_12,
  m0_.id AS id_13,
  m0_.created_at AS created_at_14,
  m0_.updated_at AS updated_at_15,
  m0_.nsfw AS nsfw_16,
  m0_.privacy AS privacy_17,
  m0_.tags AS tags_18,
  m0_.user_id AS user_id_19,
  m0_.group_id AS group_id_20
FROM
  miso_app_post m0_
WHERE
  m0_.user_id = ?
  AND m0_.nsfw IN (?, ?)
  AND m0_.mi_page = 1
  AND m0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  m0_.updated_at DESC

SELECT m0_.content AS content_0, m0_.type AS type_1, m0_.url AS url_2, m0_.url_data AS url_data_3, m0_.commenting AS commenting_4, m0_.rating_enabled AS rating_enabled_5, m0_.rating_total AS rating_total_6, m0_.rating_count AS rating_count_7, m0_.ups AS ups_8, m0_.dns AS dns_9, m0_.mi_page AS mi_page_10, m0_.auto AS auto_11, m0_.sticky AS sticky_12, m0_.id AS id_13, m0_.created_at AS created_at_14, m0_.updated_at AS updated_at_15, m0_.nsfw AS nsfw_16, m0_.privacy AS privacy_17, m0_.tags AS tags_18, m0_.user_id AS user_id_19, m0_.group_id AS group_id_20 FROM miso_app_post m0_ WHERE m0_.user_id = 207 AND m0_.nsfw IN (0, 0) AND m0_.mi_page = 1 AND m0_.id IN (49645, 49481, 49683, 49578, 49531, 49502) ORDER BY m0_.updated_at DESC;

SELECT
  t0.filename AS filename_1,
  t0.mime AS mime_2,
  t0.size AS size_3,
  t0.height AS height_4,
  t0.width AS width_5,
  t0.id AS id_6,
  t0.post_id AS post_id_7
FROM
  miso_app_post_media t0
WHERE
  t0.post_id = ?

SELECT t0.filename AS filename_1, t0.mime AS mime_2, t0.size AS size_3, t0.height AS height_4, t0.width AS width_5, t0.id AS id_6, t0.post_id AS post_id_7 FROM miso_app_post_media t0 WHERE t0.post_id = 49645;

SELECT
  t0.filename AS filename_1,
  t0.mime AS mime_2,
  t0.size AS size_3,
  t0.height AS height_4,
  t0.width AS width_5,
  t0.id AS id_6,
  t0.post_id AS post_id_7
FROM
  miso_app_post_media t0
WHERE
  t0.post_id = ?

SELECT t0.filename AS filename_1, t0.mime AS mime_2, t0.size AS size_3, t0.height AS height_4, t0.width AS width_5, t0.id AS id_6, t0.post_id AS post_id_7 FROM miso_app_post_media t0 WHERE t0.post_id = 49481;

SELECT
  t0.filename AS filename_1,
  t0.mime AS mime_2,
  t0.size AS size_3,
  t0.height AS height_4,
  t0.width AS width_5,
  t0.id AS id_6,
  t0.post_id AS post_id_7
FROM
  miso_app_post_media t0
WHERE
  t0.post_id = ?

SELECT t0.filename AS filename_1, t0.mime AS mime_2, t0.size AS size_3, t0.height AS height_4, t0.width AS width_5, t0.id AS id_6, t0.post_id AS post_id_7 FROM miso_app_post_media t0 WHERE t0.post_id = 49683;

SELECT
  t0.filename AS filename_1,
  t0.mime AS mime_2,
  t0.size AS size_3,
  t0.height AS height_4,
  t0.width AS width_5,
  t0.id AS id_6,
  t0.post_id AS post_id_7
FROM
  miso_app_post_media t0
WHERE
  t0.post_id = ?

SELECT t0.filename AS filename_1, t0.mime AS mime_2, t0.size AS size_3, t0.height AS height_4, t0.width AS width_5, t0.id AS id_6, t0.post_id AS post_id_7 FROM miso_app_post_media t0 WHERE t0.post_id = 49578;

SELECT
  t0.filename AS filename_1,
  t0.mime AS mime_2,
  t0.size AS size_3,
  t0.height AS height_4,
  t0.width AS width_5,
  t0.id AS id_6,
  t0.post_id AS post_id_7
FROM
  miso_app_post_media t0
WHERE
  t0.post_id = ?

SELECT t0.filename AS filename_1, t0.mime AS mime_2, t0.size AS size_3, t0.height AS height_4, t0.width AS width_5, t0.id AS id_6, t0.post_id AS post_id_7 FROM miso_app_post_media t0 WHERE t0.post_id = 49531;

SELECT
  t0.filename AS filename_1,
  t0.mime AS mime_2,
  t0.size AS size_3,
  t0.height AS height_4,
  t0.width AS width_5,
  t0.id AS id_6,
  t0.post_id AS post_id_7
FROM
  miso_app_post_media t0
WHERE
  t0.post_id = ?

SELECT t0.filename AS filename_1, t0.mime AS mime_2, t0.size AS size_3, t0.height AS height_4, t0.width AS width_5, t0.id AS id_6, t0.post_id AS post_id_7 FROM miso_app_post_media t0 WHERE t0.post_id = 49502;