Symfony Profiler

SELECT
  t0.user_id AS user_id_1,
  t0.user_outside_id AS user_outside_id_2,
  t0.user_type AS user_type_3,
  t0.user_api_type AS user_api_type_4,
  t0.user_login AS user_login_5,
  t0.user_password AS user_password_6,
  t0.user_checksum AS user_checksum_7,
  t0.user_status AS user_status_8,
  t0.user_token AS user_token_9,
  t0.user_token_exp AS user_token_exp_10,
  t0.user_last_login AS user_last_login_11,
  t0.user_created_at AS user_created_at_12,
  t0.user_updated_at AS user_updated_at_13,
  t0.user_deleted_at AS user_deleted_at_14,
  t0.user_public_approved AS user_public_approved_15,
  t0.user_public_blocked AS user_public_blocked_16,
  t0.user_public_app_code AS user_public_app_code_17,
  t0.user_public_app_code_sended_at AS user_public_app_code_sended_at_18,
  t0.user_public_app_code_registered_at AS user_public_app_code_registered_at_19,
  t0.user_option AS user_option_20,
  t0.user_public_app_code_hash AS user_public_app_code_hash_21,
  t0.user_api_setting_sms AS user_api_setting_sms_22,
  t0.user_api_setting_email AS user_api_setting_email_23,
  t0.user_api_setting_mobile AS user_api_setting_mobile_24,
  t0.user_special AS user_special_25,
  t0.google_authenticator_secret AS google_authenticator_secret_26,
  t27.user_detail_id AS user_detail_id_28,
  t27.user_detail_name AS user_detail_name_29,
  t27.user_detail_surname AS user_detail_surname_30,
  t27.user_detail_sex AS user_detail_sex_31,
  t27.user_detail_personal_id_type AS user_detail_personal_id_type_32,
  t27.user_detail_personal_id AS user_detail_personal_id_33,
  t27.user_detail_birthday AS user_detail_birthday_34,
  t27.user_detail_email AS user_detail_email_35,
  t27.user_detail_phone AS user_detail_phone_36,
  t27.user_detail_street AS user_detail_street_37,
  t27.user_detail_street_no AS user_detail_street_no_38,
  t27.user_detail_post_code AS user_detail_post_code_39,
  t27.user_detail_state AS user_detail_state_40,
  t27.user_detail_province AS user_detail_province_41,
  t27.user_detail_comunity AS user_detail_comunity_42,
  t27.user_detail_city AS user_detail_city_43,
  t27.user_detail_personal_id_hash AS user_detail_personal_id_hash_44,
  t27.user_detail_surname_hash AS user_detail_surname_hash_45,
  t27.user_id AS user_id_46
FROM
  user t0
  LEFT JOIN user_detail t27 ON t27.user_id = t0.user_id
WHERE
  t0.user_login = ?
LIMIT
  1

SELECT t0.user_id AS user_id_1, t0.user_outside_id AS user_outside_id_2, t0.user_type AS user_type_3, t0.user_api_type AS user_api_type_4, t0.user_login AS user_login_5, t0.user_password AS user_password_6, t0.user_checksum AS user_checksum_7, t0.user_status AS user_status_8, t0.user_token AS user_token_9, t0.user_token_exp AS user_token_exp_10, t0.user_last_login AS user_last_login_11, t0.user_created_at AS user_created_at_12, t0.user_updated_at AS user_updated_at_13, t0.user_deleted_at AS user_deleted_at_14, t0.user_public_approved AS user_public_approved_15, t0.user_public_blocked AS user_public_blocked_16, t0.user_public_app_code AS user_public_app_code_17, t0.user_public_app_code_sended_at AS user_public_app_code_sended_at_18, t0.user_public_app_code_registered_at AS user_public_app_code_registered_at_19, t0.user_option AS user_option_20, t0.user_public_app_code_hash AS user_public_app_code_hash_21, t0.user_api_setting_sms AS user_api_setting_sms_22, t0.user_api_setting_email AS user_api_setting_email_23, t0.user_api_setting_mobile AS user_api_setting_mobile_24, t0.user_special AS user_special_25, t0.google_authenticator_secret AS google_authenticator_secret_26, t27.user_detail_id AS user_detail_id_28, t27.user_detail_name AS user_detail_name_29, t27.user_detail_surname AS user_detail_surname_30, t27.user_detail_sex AS user_detail_sex_31, t27.user_detail_personal_id_type AS user_detail_personal_id_type_32, t27.user_detail_personal_id AS user_detail_personal_id_33, t27.user_detail_birthday AS user_detail_birthday_34, t27.user_detail_email AS user_detail_email_35, t27.user_detail_phone AS user_detail_phone_36, t27.user_detail_street AS user_detail_street_37, t27.user_detail_street_no AS user_detail_street_no_38, t27.user_detail_post_code AS user_detail_post_code_39, t27.user_detail_state AS user_detail_state_40, t27.user_detail_province AS user_detail_province_41, t27.user_detail_comunity AS user_detail_comunity_42, t27.user_detail_city AS user_detail_city_43, t27.user_detail_personal_id_hash AS user_detail_personal_id_hash_44, t27.user_detail_surname_hash AS user_detail_surname_hash_45, t27.user_id AS user_id_46 FROM user t0 LEFT JOIN user_detail t27 ON t27.user_id = t0.user_id WHERE t0.user_login = 'contento' LIMIT 1;

SELECT
  t0.user_to_role_id AS user_to_role_id_1,
  t0.read_perm AS read_perm_2,
  t0.write_perm AS write_perm_3,
  t0.user_to_role_created_at AS user_to_role_created_at_4,
  t0.user_to_role_updated_at AS user_to_role_updated_at_5,
  t0.user_id AS user_id_6,
  t0.user_role_id AS user_role_id_7
FROM
  user_to_role t0
WHERE
  t0.user_id = ?

SELECT t0.user_to_role_id AS user_to_role_id_1, t0.read_perm AS read_perm_2, t0.write_perm AS write_perm_3, t0.user_to_role_created_at AS user_to_role_created_at_4, t0.user_to_role_updated_at AS user_to_role_updated_at_5, t0.user_id AS user_id_6, t0.user_role_id AS user_role_id_7 FROM user_to_role t0 WHERE t0.user_id = 2;

SELECT
  t0.user_mob_device_id AS user_mob_device_id_1,
  t0.user_mob_device_uuid AS user_mob_device_uuid_2,
  t0.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_3,
  t0.user_mob_device_created_at AS user_mob_device_created_at_4,
  t0.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_5,
  t0.user_mob_device_default_lang AS user_mob_device_default_lang_6,
  t0.user_mob_device_sec_token AS user_mob_device_sec_token_7,
  t0.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_8,
  t0.user_mob_device_app_version AS user_mob_device_app_version_9,
  t0.user_mob_device_model AS user_mob_device_model_10,
  t0.user_mob_device_os AS user_mob_device_os_11,
  t0.user_mob_device_user_id AS user_mob_device_user_id_12
FROM
  user_mob_device t0
WHERE
  t0.user_mob_device_uuid = ?
  AND t0.user_mob_device_sec_token = ?
LIMIT
  1

SELECT t0.user_mob_device_id AS user_mob_device_id_1, t0.user_mob_device_uuid AS user_mob_device_uuid_2, t0.user_mob_device_push_notif_id AS user_mob_device_push_notif_id_3, t0.user_mob_device_created_at AS user_mob_device_created_at_4, t0.user_mob_device_refreshed_at AS user_mob_device_refreshed_at_5, t0.user_mob_device_default_lang AS user_mob_device_default_lang_6, t0.user_mob_device_sec_token AS user_mob_device_sec_token_7, t0.user_mob_device_sec_token_hash AS user_mob_device_sec_token_hash_8, t0.user_mob_device_app_version AS user_mob_device_app_version_9, t0.user_mob_device_model AS user_mob_device_model_10, t0.user_mob_device_os AS user_mob_device_os_11, t0.user_mob_device_user_id AS user_mob_device_user_id_12 FROM user_mob_device t0 WHERE t0.user_mob_device_uuid = 'B77DFBB6-91D0-4279-A743-758702F67B63' AND t0.user_mob_device_sec_token = 'ddfbcc6f-c8ae-42fb-b8db-5be8e298ec9d-34132613dad844f7e85745aa74744ebb530d762c-916edb70-209b-4b73-ac29-8d3d383de348' LIMIT 1;

SELECT
  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_.content_user_group_id AS content_user_group_id_17
FROM
  content c0_
WHERE
  c0_.content_type IN (?, ?)
  AND c0_.content_id = ?

SELECT 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_.content_user_group_id AS content_user_group_id_17 FROM content c0_ WHERE c0_.content_type IN ('news', 'event') AND c0_.content_id = 61;

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

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

SELECT
  te.file_id AS file_id,
  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.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 = 61 AND te.file_type = 'mainphoto';

SELECT
  te.file_id AS file_id,
  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.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 = 61 AND te.file_type = 'photo' LIMIT 1;

SELECT
  te.file_id AS file_id,
  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.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 = 61 AND te.file_type = 'photo' LIMIT 1;

SELECT
  te.file_id AS file_id,
  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.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 = 61 AND te.file_type = 'photo';

SELECT
  te.file_id AS file_id,
  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.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 = 61 AND te.file_type = 'attch';

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
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 FROM category t0 INNER JOIN content_to_category ON t0.category_id = content_to_category.category_id WHERE content_to_category.content_id = 61;

SELECT
  t0.id AS id_1,
  t0.latitude AS latitude_2,
  t0.longitude AS longitude_3,
  t0.point_name AS point_name_4,
  t0.point_to_map AS point_to_map_5,
  t0.content_id AS content_id_6
FROM
  content_gps_coordinates t0
WHERE
  t0.content_id = ?

SELECT t0.id AS id_1, t0.latitude AS latitude_2, t0.longitude AS longitude_3, t0.point_name AS point_name_4, t0.point_to_map AS point_to_map_5, t0.content_id AS content_id_6 FROM content_gps_coordinates t0 WHERE t0.content_id = 61;

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

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  content
SET
  content_hits = ?
WHERE
  content_id = ?

UPDATE content SET content_hits = 123 WHERE content_id = 61;

"COMMIT"

"COMMIT";