Symfony Profiler

[
  "route" => "api.private.me"
  "route_parameters" => [
    "_route" => "api.private.me"
    "_controller" => "App\System\Action\Api\Private\User\Personal\MeAction"
  ]
  "request_uri" => "https://admin.dev.rippla.com/api/private/me"
  "method" => "GET"
]

[
  "firewall_name" => "api"
  "authenticators" => 1
]

[
  "firewall_name" => "api"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "database"
    "port" => 5432
    "user" => "user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "rpl_database"
    "serverVersion" => "17"
    "charset" => "utf8"
  ]
]

[
  "sql" => "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)"
  "params" => [
    1 => "dk@redstart.pro"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 158
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "93"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserProviderListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "App\System\Security\EventListener\UserCheckerListener::preCheckCredentials"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CsrfProtectionListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::preCheckCredentials"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "App\System\Security\EventListener\CheckCredentialsListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "App\System\Security\EventListener\CheckCredentialsListener::checkPassport"
]

[
  "event" => "Symfony\Component\Security\Http\Event\CheckPassportEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\CheckCredentialsListener::checkPassport"
]

[
  "event" => "security.authentication.success"
  "listener" => "Symfony\Component\Security\Http\EventListener\UserCheckerListener::postCheckCredentials"
]

[
  "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\Token\JWTPostAuthenticationToken {#359
    -user: App\Domain\User\Entity\BusinessRepresentativeUser {#213 …}
    -roleNames: [
      "ROLE_BUSINESS_REPRESENTATIVE"
    ]
    -attributes: []
    -firewallName: "api"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NzY3NjUwNzUsImV4cCI6MTc4NDU0MTA3NSwicm9sZXMiOlsiUk9MRV9CVVNJTkVTU19SRVBSRVNFTlRBVElWRSJdLCJ1c2VybmFtZSI6ImRrQHJlZHN0YXJ0LnBybyJ9.Kc4CzrWnckyGyah4M4MORpi1pJgi7mnR-ZYpauSFTUMt8rWJNb9M_X9vglmXyTs-xOskX8eifYCnRl8U8Aj8zuPiYuti7je7Rei5K5T7nJO-vsjbiGcQi1JIWk_P4Y5dywJUre48jNPziktJJLrXDIA8SHzgSuCRCmcd40B75-vJm_qZlCKq9teB8dQXihlkzFV3Wep30jBFdZKRl5zINZZX0CgfkB-eRoQQAvvFf_L_aov6Jwb66XqsaD566C40_B_aNft2LEvYXGymRe246hnaDO7OjovQ1n-bkMvKMXV4wIGZkQSI48Cz98hxqLrGDxH6_TLgSQsq0jCCISVCSw"
  }
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "event" => "Symfony\Component\Security\Http\Event\LoginSuccessEvent"
  "listener" => "Symfony\Component\Security\Http\EventListener\PasswordMigratingListener::onLoginSuccess"
]

[
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\System\Locale\LocaleSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerL7FCU1K\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "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"
  "params" => [
    1 => 93
  ]
  "types" => [
    1 => 2
  ]
]

[
  "class" => "App\UseCase\Stripe\Job\UserSubscriptionUpdateJob"
  "alias" => "user_subscription_update"
  "sender" => "Symfony\Component\Messenger\Bridge\Amqp\Transport\AmqpTransport"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "cadacf23-3576-4601-ba4c-156629acafb5"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 93
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 2
    2 => 1
    3 => "158"
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "158"
    2 => "604"
    3 => "636"
    4 => 156
    5 => 199
    6 => 78
    7 => 86
    8 => 80
    9 => 79
    10 => 83
    11 => 77
    12 => 305
    13 => 248
    14 => 263
    15 => 322
    16 => 337
    17 => 343
    18 => 336
    19 => 331
    20 => 344
    21 => 309
    22 => 207
    23 => 102
    24 => 208
    25 => 158
    26 => 221
    27 => 219
    28 => 217
    29 => 222
    30 => 324
    31 => 312
    32 => 197
    33 => 321
    34 => 220
    35 => 1
    36 => 3
    37 => "158"
    38 => "604"
    39 => "636"
    40 => 4
    41 => 2
    42 => 3
    43 => "Business has been deactivated"
    44 => "Business has been activated"
    45 => "Business has been deleted"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 1
    26 => 1
    27 => 1
    28 => 1
    29 => 1
    30 => 1
    31 => 1
    32 => 1
    33 => 1
    34 => 1
    35 => 1
    36 => 1
    37 => 2
    38 => 2
    39 => 2
    40 => 1
    41 => 1
    42 => 1
    43 => 2
    44 => 2
    45 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "158"
    2 => 4865
    3 => 4866
    4 => 4867
    5 => 4868
    6 => 4869
    7 => 4870
    8 => 4871
    9 => 4873
    10 => 4887
    11 => 4901
    12 => 4971
    13 => 4985
    14 => 4999
    15 => 156
    16 => 199
    17 => 78
    18 => 86
    19 => 80
    20 => 79
    21 => 83
    22 => 77
    23 => 305
    24 => 248
    25 => 263
    26 => 322
    27 => 337
    28 => 343
    29 => 336
    30 => 331
    31 => 344
    32 => 309
    33 => 207
    34 => 102
    35 => 208
    36 => 158
    37 => 221
    38 => 219
    39 => 217
    40 => 222
    41 => 324
    42 => 312
    43 => 197
    44 => 321
    45 => 220
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 1
    26 => 1
    27 => 1
    28 => 1
    29 => 1
    30 => 1
    31 => 1
    32 => 1
    33 => 1
    34 => 1
    35 => 1
    36 => 1
    37 => 1
    38 => 1
    39 => 1
    40 => 1
    41 => 1
    42 => 1
    43 => 1
    44 => 1
    45 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.value AS value_1 FROM settings s0_ WHERE s0_.id = ?"
  "params" => [
    1 => "free_collabs"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.value AS value_1 FROM settings s0_ WHERE s0_.id = ?"
  "params" => [
    1 => "max_active_campaigns"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.value AS value_1 FROM settings s0_ WHERE s0_.id = ?"
  "params" => [
    1 => "subscription_post_period_cancel_days"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 93
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 303
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 227
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 206
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 192
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 121
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 335
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 490
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 551
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 567
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 270
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 561
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "2229dbe8-6e6f-497d-889c-287073d4c7b4"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "aeeb5d45-41ad-4a4e-bcaa-de17abd09729"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "059d194f-e02d-4196-80a2-268625e6b0f9"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "fcac0ba3-9f66-4690-8a1b-d21596f4b9b2"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "121226b9-ce0f-4a14-b8ce-1431672b5a63"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "0377a851-9e1c-4ea2-9973-1b5dbd5c768e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "8a8a88dc-5eb4-4158-a3df-1c33d22c67a7"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "7249ada5-beb6-416c-b950-c82605976717"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "fcbcdd5a-b269-4ba1-984b-067255da0988"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "38d56402-e7e1-443f-b474-ddf7b96932bb"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "2bd825ac-e4a0-419d-a031-f2a3533c1685"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "744b8513-7a32-4e95-9c9d-d91fa0417c7f"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "b0d5fa33-b542-4ff0-99ea-e7304d786db8"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "2131c69b-04c8-48b2-97c6-4aaed787049c"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "2038f1cb-906c-433b-87ee-5315b3b8d8f7"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "a955dffc-8ee7-41cb-9699-ce56f1dca72a"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "bd5bcef8-9df4-46a2-8d3f-b98141f54f6c"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "ea99c912-f14a-4caf-a380-c0992c5cc920"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "3b49bc07-ba0d-4350-a542-3d6fd8082202"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "44443b7c-c13f-425a-a3b5-d29ffea08d0c"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "fac0fa41-7c15-4c67-ac78-1b7abbc213b2"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "33390549-5855-4c68-ae06-490bcbcb3d27"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "50dfeda4-644a-49fe-baf6-b9d786f1629f"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "d4dacf95-38f9-44e7-a095-f2b5cb941abb"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "4329e99d-f875-4a7c-a4d6-326ee93c79fd"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "4248da39-a0ad-4f6f-a1c8-4e8e263666d8"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "448d7704-1463-46a1-b001-6b4d9c49f119"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "a4624898-d421-49ac-8706-40e9224cb526"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "01dfdadc-8f7d-4170-8fd7-bc8937fa73f7"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "115d8b52-9958-40ee-a2ea-806896a473b5"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "35a470da-c367-4508-9b6e-3ab783ca0aaa"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "edeeb0de-0674-4ca3-8b99-3fa2e4e47297"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "19f2afe7-eccf-41c3-be61-28b76958fa97"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "84a05af9-59d9-4b93-bdd2-12bed3623004"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "49043a84-15bb-4296-9a72-39ccb0145163"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "ca55a631-84c1-4393-8d26-0b1d754d6881"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "10a3b230-674c-4a9a-ba74-0e4685066c81"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "e3381ba1-f380-4965-bb9a-b6f1fd246313"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "f08b3379-fb2d-4950-bdba-1db9ee3ea8b0"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "4d68b82f-2f0c-4ba8-aa4f-22bc217e3dc8"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "afd7ef97-4726-4582-8ebd-9ec482a62e8a"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "54f1576c-96b4-43d3-ba18-5a67b6317281"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "0ab98392-2720-4b97-a4b6-961fddd14bd5"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "4bcf6165-a4f3-4978-83ce-060181bb6f72"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "fa65e875-84e7-4ea3-850d-3254bdfeabef"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "7661ce55-104f-4aa3-a7ac-ee9c217a57da"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.value AS value_1 FROM settings s0_ WHERE s0_.id = ?"
  "params" => [
    1 => "free_active_collabs"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => "93"
    2 => 1
    3 => 2
    4 => 1
  ]
  "types" => [
    1 => 2
    2 => 1
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.value AS value_1 FROM settings s0_ WHERE s0_.id = ?"
  "params" => [
    1 => "subscription_post_period_cancel_days"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "158"
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 93
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.value AS value_1 FROM settings s0_ WHERE s0_.id = ?"
  "params" => [
    1 => "max_active_locations"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.value AS value_1 FROM settings s0_ WHERE s0_.id = ?"
  "params" => [
    1 => "subscription_post_period_cancel_days"
  ]
  "types" => [
    1 => 2
  ]
]