Symfony Profiler

Query Metrics

64 Database Queries
7 Different statements
47.72 ms Query time
4 Invalid entities
32 Managed entities
Queries


SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.surname AS surname_6, t0.company_name AS company_name_7, t0.city AS city_8, t0.postcode AS postcode_9, t0.province AS province_10, t0.address AS address_11, t0.address2 AS address2_12, t0.lat AS lat_13, t0.lng AS lng_14, t0.phone AS phone_15, t0.nif AS nif_16, t0.about AS about_17, t0.languages AS languages_18, t0.slogan AS slogan_19, t0.professional_self_employed AS professional_self_employed_20, t0.professional_representative_company AS professional_representative_company_21, t0.years_experience AS years_experience_22, t0.amount_from AS amount_from_23, t0.jobs_count AS jobs_count_24, t0.rating AS rating_25, t0.badge AS badge_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.google_id AS google_id_29, t0.apple_id AS apple_id_30, t0.preferred_locale AS preferred_locale_31, t0.is_active AS is_active_32, t0.activation_code AS activation_code_33, t0.can_login AS can_login_34, t0.admin_validation AS admin_validation_35, t0.full_access AS full_access_36, t0.connected_account_verified AS connected_account_verified_37, t0.has_active_subscription AS has_active_subscription_38, t0.invoice_sequence AS invoice_sequence_39, t0.fcm_token AS fcm_token_40, t41.id AS id_42, t41.created_at AS created_at_43, t41.user_id AS user_id_44, t45.id AS id_46, t45.customer_id AS customer_id_47, t45.connected_account_id AS connected_account_id_48, t45.created_at AS created_at_49, t45.updated_at AS updated_at_50, t45.professional_id AS professional_id_51 FROM "users" t0 LEFT JOIN "chats_online_users" t41 ON t41.user_id = t0.id LEFT JOIN "professionals_payments_data" t45 ON t45.professional_id = t0.id WHERE t0.id = ?
SELECT DISTINCT u0_.id AS id_0, u0_.created_at AS created_at_1, u0_.rating AS rating_2, u0_.name AS name_3 FROM "users" u0_ WHERE u0_.roles::jsonb @> '["ROLE_PROFESSIONAL"]' = true ORDER BY u0_.created_at DESC, u0_.rating DESC, u0_.name ASC LIMIT 20
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.surname AS surname_5, u0_.company_name AS company_name_6, u0_.city AS city_7, u0_.postcode AS postcode_8, u0_.province AS province_9, u0_.address AS address_10, u0_.address2 AS address2_11, u0_.lat AS lat_12, u0_.lng AS lng_13, u0_.phone AS phone_14, u0_.nif AS nif_15, u0_.about AS about_16, u0_.languages AS languages_17, u0_.slogan AS slogan_18, u0_.professional_self_employed AS professional_self_employed_19, u0_.professional_representative_company AS professional_representative_company_20, u0_.years_experience AS years_experience_21, u0_.amount_from AS amount_from_22, u0_.jobs_count AS jobs_count_23, u0_.rating AS rating_24, u0_.badge AS badge_25, u0_.created_at AS created_at_26, u0_.updated_at AS updated_at_27, u0_.google_id AS google_id_28, u0_.apple_id AS apple_id_29, u0_.preferred_locale AS preferred_locale_30, u0_.is_active AS is_active_31, u0_.activation_code AS activation_code_32, u0_.can_login AS can_login_33, u0_.admin_validation AS admin_validation_34, u0_.full_access AS full_access_35, u0_.connected_account_verified AS connected_account_verified_36, u0_.has_active_subscription AS has_active_subscription_37, u0_.invoice_sequence AS invoice_sequence_38, u0_.fcm_token AS fcm_token_39 FROM "users" u0_ WHERE u0_.roles::jsonb @> '["ROLE_PROFESSIONAL"]' = true AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.created_at DESC, u0_.rating DESC, u0_.name ASC
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3 FROM "chats_online_users" t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.connected_account_id AS connected_account_id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.professional_id AS professional_id_6, t7.id AS id_8, t7.subscription_id AS subscription_id_9, t7.status AS status_10, t7.billing_ends_at AS billing_ends_at_11, t7.card_brand AS card_brand_12, t7.card_last_four_digits AS card_last_four_digits_13, t7.created_at AS created_at_14, t7.updated_at AS updated_at_15, t7.trial_ends_at AS trial_ends_at_16, t7.payment_link AS payment_link_17, t7.payment_link_id AS payment_link_id_18, t7.plan_id AS plan_id_19, t7.professional_payment_data_id AS professional_payment_data_id_20, t21.id AS id_22, t21.featured_id AS featured_id_23, t21.status AS status_24, t21.billing_ends_at AS billing_ends_at_25, t21.card_brand AS card_brand_26, t21.card_last_four_digits AS card_last_four_digits_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.trial_ends_at AS trial_ends_at_30, t21.advertising_id AS advertising_id_31, t21.professional_payment_data_id AS professional_payment_data_id_32, t21.province_id AS province_id_33, t21.skill_id AS skill_id_34, t21.user_id AS user_id_35 FROM "professionals_payments_data" t0 LEFT JOIN "subscriptions" t7 ON t7.professional_payment_data_id = t0.id LEFT JOIN "featured" t21 ON t21.professional_payment_data_id = t0.id WHERE t0.professional_id = ?
SELECT count(*) AS sclr_0 FROM "users" u0_ WHERE u0_.roles::jsonb @> '["ROLE_PROFESSIONAL"]' = true
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
SELECT t0.id AS id_1, t0.job_status AS job_status_2, t0.start_datetime AS start_datetime_3, t0.end_datetime AS end_datetime_4, t0.net_amount AS net_amount_5, t0.vat_percent AS vat_percent_6, t0.vat_amount AS vat_amount_7, t0.subtotal_amount AS subtotal_amount_8, t0.platform_fee_percent AS platform_fee_percent_9, t0.platform_fee_amount AS platform_fee_amount_10, t0.total_amount AS total_amount_11, t0.name AS name_12, t0.address AS address_13, t0.address2 AS address2_14, t0.review_rate AS review_rate_15, t0.review_comment AS review_comment_16, t0.customer_rate AS customer_rate_17, t0.customer_comment AS customer_comment_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.payment_link AS payment_link_21, t0.payment_link_id AS payment_link_id_22, t0.payment_id AS payment_id_23, t0.changed_status_at AS changed_status_at_24, t0.invoice_id AS invoice_id_25, t0.refund_id AS refund_id_26, t0.customer_id AS customer_id_27, t0.professional_id AS professional_id_28 FROM "jobs" t0 WHERE t0.professional_id = ? ORDER BY t0.end_datetime DESC
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

Second Level Cache is not enabled.
Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	21
App\Entity\ProfessionalPaymentData	11
Entities Mapping

Class	Mapping errors
App\Entity\User	The association App\Entity\User#userFeatured refers to the owning side field App\Entity\Featured#featured which does not exist.
App\Entity\ChatOnlineUser	No errors.
App\Entity\ProfessionalPaymentData	No errors.
App\Entity\Media	No errors.
App\Entity\Skills	The association App\Entity\Skills#skillsFeatured refers to the owning side field App\Entity\Featured#featured which does not exist.
App\Entity\Province	The association App\Entity\Province#provincesFeatured refers to the owning side field App\Entity\Featured#featured which does not exist.
App\Entity\Job	No errors.
App\Entity\Chat	No errors.
App\Entity\Notification	No errors.
App\Entity\Complaint	No errors.
App\Entity\SupportRequest	No errors.
App\Entity\Featured	The mappings App\Entity\Featured#province and App\Entity\Province#provincesFeatured are inconsistent with each other. The mappings App\Entity\Featured#skill and App\Entity\Skills#skillsFeatured are inconsistent with each other. The mappings App\Entity\Featured#user and App\Entity\User#userFeatured are inconsistent with each other.
App\Entity\Subscription	No errors.
App\Entity\Plan	No errors.
App\Entity\Advertising	No errors.
Symfony Profiler

GET https://api.curritos.es/admin?crudAction=index&crudControllerFqcn=App%5CController%5CBackoffice%5CUsers%5CProfessionalCrudController&entityFqcn=App%5CEntity%5CU…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
