Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.collab_dates AS collab_dates_3,
  t0.accompanying_message AS accompanying_message_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.campaign_uuid AS campaign_uuid_8,
  t0.account_id AS account_id_9
FROM
  collaborations t0
WHERE
  t0.campaign_uuid = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.collab_dates AS collab_dates_3, t0.accompanying_message AS accompanying_message_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.campaign_uuid AS campaign_uuid_8, t0.account_id AS account_id_9 FROM collaborations t0 WHERE t0.campaign_uuid = '2229dbe8-6e6f-497d-889c-287073d4c7b4';

SELECT
  c0_.id AS id_0
FROM
  collaborations c0_
  INNER JOIN accounts a1_ ON c0_.account_id = a1_.id
  INNER JOIN campaigns c2_ ON c0_.campaign_uuid = c2_.uuid
  INNER JOIN locations l3_ ON c2_.location_id = l3_.id
  INNER JOIN businesses b4_ ON l3_.business_id = b4_.id
  INNER JOIN business_representatives b5_ ON b4_.id = b5_.business_id
WHERE
  c0_.deleted_at IS NULL
  AND (
    a1_.verification_status = ?
    OR c0_.status <> ?
  )
  AND b5_.user_id = ?

SELECT c0_.id AS id_0 FROM collaborations c0_ INNER JOIN accounts a1_ ON c0_.account_id = a1_.id INNER JOIN campaigns c2_ ON c0_.campaign_uuid = c2_.uuid INNER JOIN locations l3_ ON c2_.location_id = l3_.id INNER JOIN businesses b4_ ON l3_.business_id = b4_.id INNER JOIN business_representatives b5_ ON b4_.id = b5_.business_id WHERE c0_.deleted_at IS NULL AND (a1_.verification_status = 2 OR c0_.status <> 1) AND b5_.user_id = '158';

SELECT
  t0.uuid AS uuid_1,
  t0.audience AS audience_2,
  t0.status AS status_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.description AS description_6,
  t0.properties AS properties_7,
  t0.change_source AS change_source_8,
  t0.deleted_at AS deleted_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.creator_id AS creator_id_12,
  t0.location_id AS location_id_13
FROM
  campaigns t0
WHERE
  t0.location_id = ?

SELECT t0.uuid AS uuid_1, t0.audience AS audience_2, t0.status AS status_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.description AS description_6, t0.properties AS properties_7, t0.change_source AS change_source_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.creator_id AS creator_id_12, t0.location_id AS location_id_13 FROM campaigns t0 WHERE t0.location_id = 303;

SELECT
  c0_.uuid AS uuid_0,
  c0_.status AS status_1,
  c1_.id AS id_2,
  c1_.status AS status_3,
  count(DISTINCT c2_.id) AS sclr_4,
  count(DISTINCT c3_.id) AS sclr_5,
  count(DISTINCT c4_.id) AS sclr_6
FROM
  campaigns c0_
  INNER JOIN collaborations c1_ ON c0_.uuid = c1_.campaign_uuid
  LEFT JOIN collaboration_views c2_ ON c1_.id = c2_.collaboration_id
  AND (c2_.user_id = ?)
  LEFT JOIN collaboration_messages c3_ ON c1_.id = c3_.collaboration_id
  AND (
    c3_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
  LEFT JOIN collaboration_posts c4_ ON c1_.id = c4_.collaboration_id
  AND (c4_.deleted_at IS NULL)
WHERE
  c0_.deleted_at IS NULL
  AND c1_.deleted_at IS NULL
  AND c1_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
GROUP BY
  c1_.id,
  c0_.uuid
HAVING
  COUNT(DISTINCT c3_.id) > 0
  OR COUNT(DISTINCT c2_.id) = 0

SELECT c0_.uuid AS uuid_0, c0_.status AS status_1, c1_.id AS id_2, c1_.status AS status_3, count(DISTINCT c2_.id) AS sclr_4, count(DISTINCT c3_.id) AS sclr_5, count(DISTINCT c4_.id) AS sclr_6 FROM campaigns c0_ INNER JOIN collaborations c1_ ON c0_.uuid = c1_.campaign_uuid LEFT JOIN collaboration_views c2_ ON c1_.id = c2_.collaboration_id AND (c2_.user_id = '158') LEFT JOIN collaboration_messages c3_ ON c1_.id = c3_.collaboration_id AND (c3_.id IN (4865, 4866, 4867, 4868, 4869, 4870, 4871, 4873, 4887, 4901, 4971, 4985, 4999)) LEFT JOIN collaboration_posts c4_ ON c1_.id = c4_.collaboration_id AND (c4_.deleted_at IS NULL) WHERE c0_.deleted_at IS NULL AND c1_.deleted_at IS NULL AND c1_.id IN (156, 199, 78, 86, 80, 79, 83, 77, 305, 248, 263, 322, 337, 343, 336, 331, 344, 309, 207, 102, 208, 158, 221, 219, 217, 222, 324, 312, 197, 321, 220) GROUP BY c1_.id, c0_.uuid HAVING COUNT(DISTINCT c3_.id) > 0 OR COUNT(DISTINCT c2_.id) = 0;

SELECT
  DISTINCT c0_.id AS id_0
FROM
  collaboration_messages c0_
  LEFT JOIN message_views m1_ ON c0_.id = m1_.collaboration_message_id
  AND (
    m1_.author_id IN (?, ?, ?)
  )
WHERE
  c0_.collaboration_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND c0_.available_for IN (?, ?)
  AND (
    c0_.author_id IS NULL
    OR c0_.author_id NOT IN (?, ?, ?)
  )
  AND (
    c0_.initiator IS NULL
    OR c0_.initiator NOT IN (?, ?)
  )
  AND (
    c0_.initiator IS NULL
    OR c0_.initiator <> ?
    OR c0_.system_message_template_id NOT IN (?, ?, ?)
  )
  AND c0_.deleted_at IS NULL
GROUP BY
  c0_.id
HAVING
  COUNT(DISTINCT m1_.id) = 0

SELECT DISTINCT c0_.id AS id_0 FROM collaboration_messages c0_ LEFT JOIN message_views m1_ ON c0_.id = m1_.collaboration_message_id AND (m1_.author_id IN ('158', '604', '636')) WHERE c0_.collaboration_id IN (156, 199, 78, 86, 80, 79, 83, 77, 305, 248, 263, 322, 337, 343, 336, 331, 344, 309, 207, 102, 208, 158, 221, 219, 217, 222, 324, 312, 197, 321, 220) AND c0_.available_for IN (1, 3) AND (c0_.author_id IS NULL OR c0_.author_id NOT IN ('158', '604', '636')) AND (c0_.initiator IS NULL OR c0_.initiator NOT IN (4, 2)) AND (c0_.initiator IS NULL OR c0_.initiator <> 3 OR c0_.system_message_template_id NOT IN ('Business has been deactivated', 'Business has been activated', 'Business has been deleted')) AND c0_.deleted_at IS NULL GROUP BY c0_.id HAVING COUNT(DISTINCT m1_.id) = 0;

SELECT
  s0_.id AS id_0,
  s0_.value AS value_1
FROM
  settings s0_
WHERE
  s0_.id = ?

SELECT s0_.id AS id_0, s0_.value AS value_1 FROM settings s0_ WHERE s0_.id = 'free_collabs';

SELECT
  u0_.id AS id_0,
  u0_.is_active AS is_active_1,
  u0_.is_blocked AS is_blocked_2,
  u0_.email AS email_3,
  u0_.full_name AS full_name_4,
  u0_.phone AS phone_5,
  u0_.description AS description_6,
  u0_.query_params AS query_params_7,
  u0_.messengers AS messengers_8,
  u0_.preferred_locale AS preferred_locale_9,
  u0_.stripe_customer_id AS stripe_customer_id_10,
  u0_.firebase_uid AS firebase_uid_11,
  u0_.user_uuid_for_create_notification_contact AS user_uuid_for_create_notification_contact_12,
  u0_.notification_settings AS notification_settings_13,
  u0_.created_at AS created_at_14,
  u0_.updated_at AS updated_at_15,
  u0_.deleted_at AS deleted_at_16,
  u0_.accounts AS accounts_17,
  u0_.role AS role_18
FROM
  users u0_
WHERE
  (
    LOWER(u0_.email) = ?
    AND u0_.deleted_at IS NULL
  )
  AND u0_.role IN (1, 2)

SELECT u0_.id AS id_0, u0_.is_active AS is_active_1, u0_.is_blocked AS is_blocked_2, u0_.email AS email_3, u0_.full_name AS full_name_4, u0_.phone AS phone_5, u0_.description AS description_6, u0_.query_params AS query_params_7, u0_.messengers AS messengers_8, u0_.preferred_locale AS preferred_locale_9, u0_.stripe_customer_id AS stripe_customer_id_10, u0_.firebase_uid AS firebase_uid_11, u0_.user_uuid_for_create_notification_contact AS user_uuid_for_create_notification_contact_12, u0_.notification_settings AS notification_settings_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.deleted_at AS deleted_at_16, u0_.accounts AS accounts_17, u0_.role AS role_18 FROM users u0_ WHERE (LOWER(u0_.email) = 'dk@redstart.pro' AND u0_.deleted_at IS NULL) AND u0_.role IN (1, 2);

SELECT
  t0.id AS id_1,
  t0.stripe_id AS stripe_id_2,
  t0.stripe_status AS stripe_status_3,
  t0.stripe_trial_end AS stripe_trial_end_4,
  t0.stripe_current_period_end AS stripe_current_period_end_5,
  t0.stripe_currency AS stripe_currency_6,
  t0.stripe_amount AS stripe_amount_7,
  t0.stripe_interval AS stripe_interval_8,
  t0.stripe_interval_count AS stripe_interval_count_9,
  t0.stripe_product_name AS stripe_product_name_10,
  t0.stripe_price_nickname AS stripe_price_nickname_11,
  t0.stripe_amount_total AS stripe_amount_total_12,
  t0.stripe_coupon_id AS stripe_coupon_id_13,
  t0.stripe_promotion_code_id AS stripe_promotion_code_id_14,
  t0.changed_at AS changed_at_15,
  t0.stripe_billing_date AS stripe_billing_date_16,
  t0.collabs AS collabs_17,
  t0.campaigns AS campaigns_18,
  t0.locations AS locations_19,
  t0.active_collabs AS active_collabs_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.deleted_at AS deleted_at_23,
  t0.user_id AS user_id_24,
  t0.business_id AS business_id_25
FROM
  user_subscription t0
WHERE
  t0.business_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.stripe_id AS stripe_id_2, t0.stripe_status AS stripe_status_3, t0.stripe_trial_end AS stripe_trial_end_4, t0.stripe_current_period_end AS stripe_current_period_end_5, t0.stripe_currency AS stripe_currency_6, t0.stripe_amount AS stripe_amount_7, t0.stripe_interval AS stripe_interval_8, t0.stripe_interval_count AS stripe_interval_count_9, t0.stripe_product_name AS stripe_product_name_10, t0.stripe_price_nickname AS stripe_price_nickname_11, t0.stripe_amount_total AS stripe_amount_total_12, t0.stripe_coupon_id AS stripe_coupon_id_13, t0.stripe_promotion_code_id AS stripe_promotion_code_id_14, t0.changed_at AS changed_at_15, t0.stripe_billing_date AS stripe_billing_date_16, t0.collabs AS collabs_17, t0.campaigns AS campaigns_18, t0.locations AS locations_19, t0.active_collabs AS active_collabs_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.deleted_at AS deleted_at_23, t0.user_id AS user_id_24, t0.business_id AS business_id_25 FROM user_subscription t0 WHERE t0.business_id = 93 ORDER BY t0.created_at ASC;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  collaborations c0_
  INNER JOIN campaigns c1_ ON c0_.campaign_uuid = c1_.uuid
  INNER JOIN locations l2_ ON c1_.location_id = l2_.id
  INNER JOIN accounts a3_ ON c0_.account_id = a3_.id
WHERE
  l2_.business_id = ?
  AND c0_.deleted_at IS NULL
  AND (
    (
      c0_.status = ?
      AND a3_.verification_status = ?
      AND a3_.deleted_at IS NULL
    )
    OR (
      c0_.status <> ?
      AND a3_.deleted_at IS NULL
    )
  )

SELECT COUNT(c0_.id) AS sclr_0 FROM collaborations c0_ INNER JOIN campaigns c1_ ON c0_.campaign_uuid = c1_.uuid INNER JOIN locations l2_ ON c1_.location_id = l2_.id INNER JOIN accounts a3_ ON c0_.account_id = a3_.id WHERE l2_.business_id = '93' AND c0_.deleted_at IS NULL AND ((c0_.status = 1 AND a3_.verification_status = 2 AND a3_.deleted_at IS NULL) OR (c0_.status <> 1 AND a3_.deleted_at IS NULL));

SELECT
  u0_.id AS id_0,
  u0_.is_campaign_created AS is_campaign_created_1,
  u0_.is_location_created AS is_location_created_2,
  u0_.is_collaboration_viewed AS is_collaboration_viewed_3,
  u0_.is_collaboration_message_viewed AS is_collaboration_message_viewed_4,
  u0_.is_message_created AS is_message_created_5,
  u0_.is_collaboration_created AS is_collaboration_created_6,
  u0_.created_at AS created_at_7,
  u0_.updated_at AS updated_at_8,
  u0_.user_id AS user_id_9
FROM
  user_sessions u0_
WHERE
  u0_.id = ?

SELECT u0_.id AS id_0, u0_.is_campaign_created AS is_campaign_created_1, u0_.is_location_created AS is_location_created_2, u0_.is_collaboration_viewed AS is_collaboration_viewed_3, u0_.is_collaboration_message_viewed AS is_collaboration_message_viewed_4, u0_.is_message_created AS is_message_created_5, u0_.is_collaboration_created AS is_collaboration_created_6, u0_.created_at AS created_at_7, u0_.updated_at AS updated_at_8, u0_.user_id AS user_id_9 FROM user_sessions u0_ WHERE u0_.id = 'cadacf23-3576-4601-ba4c-156629acafb5';

SELECT
  t0.id AS id_1,
  t0.business_role AS business_role_2,
  t0.business_id AS business_id_3,
  t0.user_id AS user_id_4
FROM
  business_representatives t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.business_role AS business_role_2, t0.business_id AS business_id_3, t0.user_id AS user_id_4 FROM business_representatives t0 WHERE t0.user_id = 158;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.is_active AS is_active_3,
  t0.billing_country_code AS billing_country_code_4,
  t0.is_campaign_creatable AS is_campaign_creatable_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.registrator_id AS registrator_id_8
FROM
  businesses t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.billing_country_code AS billing_country_code_4, t0.is_campaign_creatable AS is_campaign_creatable_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.registrator_id AS registrator_id_8 FROM businesses t0 WHERE t0.id = '93';

SELECT
  n0_.id AS id_0,
  n0_.service_contact_id AS service_contact_id_1,
  n0_.is_active AS is_active_2,
  n0_.interval AS interval_3,
  n0_.created_at AS created_at_4,
  n0_.updated_at AS updated_at_5,
  n0_.deleted_at AS deleted_at_6,
  n0_.service_id AS service_id_7,
  n0_.user_id AS user_id_8
FROM
  notification_contact n0_
WHERE
  n0_.user_id = ?
  AND n0_.deleted_at IS NULL
  AND n0_.is_active = ?
ORDER BY
  n0_.created_at DESC

SELECT n0_.id AS id_0, n0_.service_contact_id AS service_contact_id_1, n0_.is_active AS is_active_2, n0_.interval AS interval_3, n0_.created_at AS created_at_4, n0_.updated_at AS updated_at_5, n0_.deleted_at AS deleted_at_6, n0_.service_id AS service_id_7, n0_.user_id AS user_id_8 FROM notification_contact n0_ WHERE n0_.user_id = '158' AND n0_.deleted_at IS NULL AND n0_.is_active = 1 ORDER BY n0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.title AS title_3,
  t0.address AS address_4,
  t0.instagram_username AS instagram_username_5,
  t0.map_link AS map_link_6,
  t0.web_link AS web_link_7,
  t0.description AS description_8,
  t0.archived_at AS archived_at_9,
  t0.ai_description AS ai_description_10,
  t0.deleted_at AS deleted_at_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.business_id AS business_id_14,
  t0.location_type_id AS location_type_id_15,
  t0.city_id AS city_id_16,
  t0.cover_image_id AS cover_image_id_17
FROM
  locations t0
WHERE
  t0.business_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.title AS title_3, t0.address AS address_4, t0.instagram_username AS instagram_username_5, t0.map_link AS map_link_6, t0.web_link AS web_link_7, t0.description AS description_8, t0.archived_at AS archived_at_9, t0.ai_description AS ai_description_10, t0.deleted_at AS deleted_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.business_id AS business_id_14, t0.location_type_id AS location_type_id_15, t0.city_id AS city_id_16, t0.cover_image_id AS cover_image_id_17 FROM locations t0 WHERE t0.business_id = 93;

SELECT
  t0.id AS id_1,
  t0.max_active_locations AS max_active_locations_2,
  t0.deleted_at AS deleted_at_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.admin_id AS admin_id_6,
  t0.business_id AS business_id_7
FROM
  personal_max_active_locations t0
WHERE
  t0.business_id = ?

SELECT t0.id AS id_1, t0.max_active_locations AS max_active_locations_2, t0.deleted_at AS deleted_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.admin_id AS admin_id_6, t0.business_id AS business_id_7 FROM personal_max_active_locations t0 WHERE t0.business_id = 93;

SELECT
  t0.id AS id_1,
  t0.business_role AS business_role_2,
  t0.business_id AS business_id_3,
  t0.user_id AS user_id_4
FROM
  business_representatives t0
WHERE
  t0.business_id = ?

SELECT t0.id AS id_1, t0.business_role AS business_role_2, t0.business_id AS business_id_3, t0.user_id AS user_id_4 FROM business_representatives t0 WHERE t0.business_id = 93;