Symfony Profiler

SELECT
  COUNT(DISTINCT c0_.content_id) AS sclr_0
FROM
  content c0_
  LEFT JOIN content_to_send_method c1_ ON c0_.content_id = c1_.content_id
  LEFT JOIN send_method s2_ ON c1_.send_method_id = s2_.send_method_id
WHERE
  s2_.send_method_shortname = ?
  AND c0_.content_state = 2
  AND c0_.content_receiver_filter = 0
  AND c0_.content_availability > ?
  AND c0_.content_type IN (?, ?)
ORDER BY
  c0_.content_send_date DESC,
  c0_.content_id DESC

SELECT COUNT(DISTINCT c0_.content_id) AS sclr_0 FROM content c0_ LEFT JOIN content_to_send_method c1_ ON c0_.content_id = c1_.content_id LEFT JOIN send_method s2_ ON c1_.send_method_id = s2_.send_method_id WHERE s2_.send_method_shortname = 'app' AND c0_.content_state = 2 AND c0_.content_receiver_filter = 0 AND c0_.content_availability > 1785211975 AND c0_.content_type IN ('news', 'event') ORDER BY c0_.content_send_date DESC, c0_.content_id DESC;

SELECT
  t0.content_message_id AS content_message_id_1,
  t0.content_message_sms AS content_message_sms_2,
  t0.content_message_long AS content_message_long_3,
  t0.content_message_title AS content_message_title_4,
  t0.content_message_http_link AS content_message_http_link_5,
  t0.content_message_gps_long AS content_message_gps_long_6,
  t0.content_message_gps_lat AS content_message_gps_lat_7,
  t0.content_message_map_title AS content_message_map_title_8,
  t0.content_message_map_zoom AS content_message_map_zoom_9,
  t0.content_id AS content_id_10
FROM
  content_message t0
WHERE
  t0.content_id = ?

SELECT t0.content_message_id AS content_message_id_1, t0.content_message_sms AS content_message_sms_2, t0.content_message_long AS content_message_long_3, t0.content_message_title AS content_message_title_4, t0.content_message_http_link AS content_message_http_link_5, t0.content_message_gps_long AS content_message_gps_long_6, t0.content_message_gps_lat AS content_message_gps_lat_7, t0.content_message_map_title AS content_message_map_title_8, t0.content_message_map_zoom AS content_message_map_zoom_9, t0.content_id AS content_id_10 FROM content_message t0 WHERE t0.content_id = 210;

SELECT
  te.file_id AS file_id,
  te.fid AS fid,
  te.file_type AS file_type,
  te.file_name AS file_name,
  te.file_label AS file_label,
  te.file_desc AS file_desc,
  te.file_size AS file_size,
  te.file_ext AS file_ext,
  te.file_link AS file_link,
  te.file_created_at AS file_created_at,
  te.file_tmp_status AS file_tmp_status,
  te.file_width AS file_width,
  te.file_height AS file_height,
  te.file_blurhash AS file_blurhash,
  te.file_mime_type AS file_mime_type,
  te.file_original_name AS file_original_name
FROM
  file te
  JOIN content_to_file t ON t.file_id = te.file_id
WHERE
  t.content_id = ?
  AND te.file_type = ?

SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN content_to_file t ON t.file_id = te.file_id WHERE t.content_id = 210 AND te.file_type = 'mainphoto';

SELECT
  te.category_id AS category_id,
  te.category_name AS category_name,
  te.category_desc AS category_desc,
  te.category_type AS category_type,
  te.category_theme AS category_theme,
  te.category_priority AS category_priority,
  te.category_option AS category_option,
  te.created_at AS created_at,
  te.updated_at AS updated_at,
  te.category_email_notification AS category_email_notification,
  te.created_by AS created_by,
  te.outside_system_created_by_id AS outside_system_created_by_id
FROM
  category te
  JOIN content_to_category t ON t.category_id = te.category_id
WHERE
  t.content_id = ?
  AND te.category_type <> ?

SELECT te.category_id AS category_id, te.category_name AS category_name, te.category_desc AS category_desc, te.category_type AS category_type, te.category_theme AS category_theme, te.category_priority AS category_priority, te.category_option AS category_option, te.created_at AS created_at, te.updated_at AS updated_at, te.category_email_notification AS category_email_notification, te.created_by AS created_by, te.outside_system_created_by_id AS outside_system_created_by_id FROM category te JOIN content_to_category t ON t.category_id = te.category_id WHERE t.content_id = 210 AND te.category_type <> 'teryt';

SELECT
  t0.content_filter_id AS content_filter_id_1,
  t0.content_filter_firstname AS content_filter_firstname_2,
  t0.content_filter_woj AS content_filter_woj_3,
  t0.content_filter_pow AS content_filter_pow_4,
  t0.content_filter_gmi AS content_filter_gmi_5,
  t0.content_filter_city AS content_filter_city_6,
  t0.content_filter_ulic AS content_filter_ulic_7,
  t0.content_filter_postalcode AS content_filter_postalcode_8,
  t0.content_filter_age AS content_filter_age_9,
  t0.content_filter_outside_id AS content_filter_outside_id_10,
  t0.content_filter_gender AS content_filter_gender_11,
  t0.content_filter_personal_id_type AS content_filter_personal_id_type_12,
  t0.content_filter_personal_id AS content_filter_personal_id_13,
  t0.content_filter_personal_id_hash AS content_filter_personal_id_hash_14,
  t0.content_filter_birthdate_from AS content_filter_birthdate_from_15,
  t0.content_filter_birthdate_to AS content_filter_birthdate_to_16,
  t0.content_id AS content_id_17
FROM
  content_filter t0
WHERE
  t0.content_id = ?

SELECT t0.content_filter_id AS content_filter_id_1, t0.content_filter_firstname AS content_filter_firstname_2, t0.content_filter_woj AS content_filter_woj_3, t0.content_filter_pow AS content_filter_pow_4, t0.content_filter_gmi AS content_filter_gmi_5, t0.content_filter_city AS content_filter_city_6, t0.content_filter_ulic AS content_filter_ulic_7, t0.content_filter_postalcode AS content_filter_postalcode_8, t0.content_filter_age AS content_filter_age_9, t0.content_filter_outside_id AS content_filter_outside_id_10, t0.content_filter_gender AS content_filter_gender_11, t0.content_filter_personal_id_type AS content_filter_personal_id_type_12, t0.content_filter_personal_id AS content_filter_personal_id_13, t0.content_filter_personal_id_hash AS content_filter_personal_id_hash_14, t0.content_filter_birthdate_from AS content_filter_birthdate_from_15, t0.content_filter_birthdate_to AS content_filter_birthdate_to_16, t0.content_id AS content_id_17 FROM content_filter t0 WHERE t0.content_id = 210;

SELECT
  te.file_id AS file_id,
  te.fid AS fid,
  te.file_type AS file_type,
  te.file_name AS file_name,
  te.file_label AS file_label,
  te.file_desc AS file_desc,
  te.file_size AS file_size,
  te.file_ext AS file_ext,
  te.file_link AS file_link,
  te.file_created_at AS file_created_at,
  te.file_tmp_status AS file_tmp_status,
  te.file_width AS file_width,
  te.file_height AS file_height,
  te.file_blurhash AS file_blurhash,
  te.file_mime_type AS file_mime_type,
  te.file_original_name AS file_original_name
FROM
  file te
  JOIN category_to_file t ON t.file_id = te.file_id
WHERE
  t.category_id = ?
  AND te.file_type = ?

SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = 1 AND te.file_type = 'mainphoto';

SELECT
  t0.category_id AS category_id_1,
  t0.category_name AS category_name_2,
  t0.category_desc AS category_desc_3,
  t0.category_type AS category_type_4,
  t0.category_theme AS category_theme_5,
  t0.category_priority AS category_priority_6,
  t0.category_option AS category_option_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.category_email_notification AS category_email_notification_10,
  t0.created_by AS created_by_11,
  t0.outside_system_created_by_id AS outside_system_created_by_id_12
FROM
  category t0
  INNER JOIN content_to_category ON t0.category_id = content_to_category.category_id
WHERE
  content_to_category.content_id = ?

SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_desc AS category_desc_3, t0.category_type AS category_type_4, t0.category_theme AS category_theme_5, t0.category_priority AS category_priority_6, t0.category_option AS category_option_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_email_notification AS category_email_notification_10, t0.created_by AS created_by_11, t0.outside_system_created_by_id AS outside_system_created_by_id_12 FROM category t0 INNER JOIN content_to_category ON t0.category_id = content_to_category.category_id WHERE content_to_category.content_id = 210;

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.end_date AS end_date_3,
  t0.event_date_title AS event_date_title_4,
  t0.event_date_short_desc AS event_date_short_desc_5,
  t0.event_date_localization AS event_date_localization_6,
  t0.event_date_all_day AS event_date_all_day_7,
  t0.content_id AS content_id_8
FROM
  content_event_date t0
WHERE
  t0.content_id = ?

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.event_date_title AS event_date_title_4, t0.event_date_short_desc AS event_date_short_desc_5, t0.event_date_localization AS event_date_localization_6, t0.event_date_all_day AS event_date_all_day_7, t0.content_id AS content_id_8 FROM content_event_date t0 WHERE t0.content_id = 210;

SELECT
  te.file_id AS file_id,
  te.fid AS fid,
  te.file_type AS file_type,
  te.file_name AS file_name,
  te.file_label AS file_label,
  te.file_desc AS file_desc,
  te.file_size AS file_size,
  te.file_ext AS file_ext,
  te.file_link AS file_link,
  te.file_created_at AS file_created_at,
  te.file_tmp_status AS file_tmp_status,
  te.file_width AS file_width,
  te.file_height AS file_height,
  te.file_blurhash AS file_blurhash,
  te.file_mime_type AS file_mime_type,
  te.file_original_name AS file_original_name
FROM
  file te
  JOIN content_to_file t ON t.file_id = te.file_id
WHERE
  t.content_id = ?
  AND te.file_type = ?
LIMIT
  1

SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN content_to_file t ON t.file_id = te.file_id WHERE t.content_id = 210 AND te.file_type = 'photo' LIMIT 1;

SELECT
  DISTINCT c0_.content_id AS content_id_0,
  c0_.content_type AS content_type_1,
  c0_.content_send_date_type AS content_send_date_type_2,
  c0_.content_receiver_filter AS content_receiver_filter_3,
  c0_.content_availability AS content_availability_4,
  c0_.content_created_at AS content_created_at_5,
  c0_.content_updated_at AS content_updated_at_6,
  c0_.content_state AS content_state_7,
  c0_.content_send_date AS content_send_date_8,
  c0_.content_created_by AS content_created_by_9,
  c0_.content_deleted_at AS content_deleted_at_10,
  c0_.content_filter AS content_filter_11,
  c0_.content_hits AS content_hits_12,
  c0_.content_outside_id AS content_outside_id_13,
  c0_.important AS important_14,
  c0_.important_to AS important_to_15,
  c0_.likes AS likes_16,
  c0_.status AS status_17,
  c0_.content_user_group_id AS content_user_group_id_18,
  c0_.created_by_outside_service_id AS created_by_outside_service_id_19
FROM
  content c0_
  LEFT JOIN content_to_send_method c1_ ON c0_.content_id = c1_.content_id
  LEFT JOIN send_method s2_ ON c1_.send_method_id = s2_.send_method_id
WHERE
  s2_.send_method_shortname = ?
  AND c0_.content_state = 2
  AND c0_.content_receiver_filter = 0
  AND c0_.content_availability > ?
  AND c0_.content_type IN (?, ?)
ORDER BY
  c0_.important DESC,
  c0_.content_send_date DESC,
  c0_.content_id DESC
LIMIT
  150

SELECT DISTINCT c0_.content_id AS content_id_0, c0_.content_type AS content_type_1, c0_.content_send_date_type AS content_send_date_type_2, c0_.content_receiver_filter AS content_receiver_filter_3, c0_.content_availability AS content_availability_4, c0_.content_created_at AS content_created_at_5, c0_.content_updated_at AS content_updated_at_6, c0_.content_state AS content_state_7, c0_.content_send_date AS content_send_date_8, c0_.content_created_by AS content_created_by_9, c0_.content_deleted_at AS content_deleted_at_10, c0_.content_filter AS content_filter_11, c0_.content_hits AS content_hits_12, c0_.content_outside_id AS content_outside_id_13, c0_.important AS important_14, c0_.important_to AS important_to_15, c0_.likes AS likes_16, c0_.status AS status_17, c0_.content_user_group_id AS content_user_group_id_18, c0_.created_by_outside_service_id AS created_by_outside_service_id_19 FROM content c0_ LEFT JOIN content_to_send_method c1_ ON c0_.content_id = c1_.content_id LEFT JOIN send_method s2_ ON c1_.send_method_id = s2_.send_method_id WHERE s2_.send_method_shortname = 'app' AND c0_.content_state = 2 AND c0_.content_receiver_filter = 0 AND c0_.content_availability > 1785211975 AND c0_.content_type IN ('news', 'event') ORDER BY c0_.important DESC, c0_.content_send_date DESC, c0_.content_id DESC LIMIT 150;

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.name_hash AS name_hash_2,
  o0_.user_name AS user_name_3,
  o0_.user_name_hash AS user_name_hash_4,
  o0_.password AS password_5,
  o0_.token AS token_6,
  o0_.api_type AS api_type_7,
  o0_.base_url AS base_url_8,
  o0_.api_key AS api_key_9,
  o0_.status AS status_10,
  o0_.channel AS channel_11,
  o0_.short_name AS short_name_12
FROM
  outside_system o0_
WHERE
  o0_.user_name_hash = ?

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.name_hash AS name_hash_2, o0_.user_name AS user_name_3, o0_.user_name_hash AS user_name_hash_4, o0_.password AS password_5, o0_.token AS token_6, o0_.api_type AS api_type_7, o0_.base_url AS base_url_8, o0_.api_key AS api_key_9, o0_.status AS status_10, o0_.channel AS channel_11, o0_.short_name AS short_name_12 FROM outside_system o0_ WHERE o0_.user_name_hash = '0df29046a9d59c5039e39d69a53a3ae3daafba896e13724d6edeaf842ab88d095f5d9bfc9b3d77252e7934637e374c83710e15766f3512703f1531685471cd95';

SELECT
  u0_.user_mob_device_id AS user_mob_device_id_0,
  u0_.user_mob_device_uuid AS user_mob_device_uuid_1,
  u0_.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_2,
  u0_.user_mob_device_created_at AS user_mob_device_created_at_3,
  u0_.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_4,
  u0_.user_mob_device_default_lang AS user_mob_device_default_lang_5,
  u0_.user_mob_device_sec_token AS user_mob_device_sec_token_6,
  u0_.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_7,
  u0_.user_mob_device_app_version AS user_mob_device_app_version_8,
  u0_.user_mob_device_app_code AS user_mob_device_app_code_9,
  u0_.user_mob_device_app_build AS user_mob_device_app_build_10,
  u0_.user_mob_device_model AS user_mob_device_model_11,
  u0_.user_mob_device_os AS user_mob_device_os_12,
  u0_.user_mob_device_ip AS user_mob_device_ip_13,
  u0_.user_mob_device_session_counter AS user_mob_device_session_counter_14,
  u0_.user_mob_device_help_token AS user_mob_device_help_token_15,
  u0_.is_emulated AS is_emulated_16,
  u0_.user_mob_device_user_id AS user_mob_device_user_id_17
FROM
  user_mob_device u0_
WHERE
  u0_.user_mob_device_uuid = ?
  AND (
    u0_.user_mob_device_sec_token_hash = ?
    OR 1 = 0
  )

SELECT u0_.user_mob_device_id AS user_mob_device_id_0, u0_.user_mob_device_uuid AS user_mob_device_uuid_1, u0_.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_2, u0_.user_mob_device_created_at AS user_mob_device_created_at_3, u0_.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_4, u0_.user_mob_device_default_lang AS user_mob_device_default_lang_5, u0_.user_mob_device_sec_token AS user_mob_device_sec_token_6, u0_.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_7, u0_.user_mob_device_app_version AS user_mob_device_app_version_8, u0_.user_mob_device_app_code AS user_mob_device_app_code_9, u0_.user_mob_device_app_build AS user_mob_device_app_build_10, u0_.user_mob_device_model AS user_mob_device_model_11, u0_.user_mob_device_os AS user_mob_device_os_12, u0_.user_mob_device_ip AS user_mob_device_ip_13, u0_.user_mob_device_session_counter AS user_mob_device_session_counter_14, u0_.user_mob_device_help_token AS user_mob_device_help_token_15, u0_.is_emulated AS is_emulated_16, u0_.user_mob_device_user_id AS user_mob_device_user_id_17 FROM user_mob_device u0_ WHERE u0_.user_mob_device_uuid = 'e59d2f42159214ec' AND (u0_.user_mob_device_sec_token_hash = '9cc6e4603bfebd60f56705b6c818e9579238709baf62a28d8331f265f4e6eee410cd8a1df3ec6775a58dbaa4d64103a99155c726c7c9fec36f0c987b97b50f6d' OR 1 = 0);

SELECT
  t0.id AS id_1,
  t0.user_details_values_id AS user_details_values_id_2,
  t0.file_id AS file_id_3
FROM
  user_details_values_to_file t0
WHERE
  t0.file_id = ?

SELECT t0.id AS id_1, t0.user_details_values_id AS user_details_values_id_2, t0.file_id AS file_id_3 FROM user_details_values_to_file t0 WHERE t0.file_id = 35;

SELECT
  c0_.content_send_date AS content_send_date_0
FROM
  content c0_
  LEFT JOIN content_to_category c2_ ON c0_.content_id = c2_.content_id
  LEFT JOIN category c1_ ON c1_.category_id = c2_.category_id
WHERE
  c0_.content_type IN (?, ?)
  AND c0_.content_state = 2
  AND c1_.category_id IN (NULL)
ORDER BY
  c0_.content_send_date DESC
LIMIT
  1

SELECT c0_.content_send_date AS content_send_date_0 FROM content c0_ LEFT JOIN content_to_category c2_ ON c0_.content_id = c2_.content_id LEFT JOIN category c1_ ON c1_.category_id = c2_.category_id WHERE c0_.content_type IN ('news', 'event') AND c0_.content_state = 2 AND c1_.category_id IN (NULL) ORDER BY c0_.content_send_date DESC LIMIT 1;