Symfony Profiler

Query Metrics

52 Database Queries

29 Different statements

29.46 ms Query time

0 Invalid entities

41 Managed entities

Queries


SELECT t0.name AS name_1, t0.description AS description_2, t0.iso_code AS iso_code_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.currency_id AS currency_id_8 FROM countries t0 WHERE t0.iso_code = ? AND t0.active = ? LIMIT 1
SELECT d0_.domain AS domain_0, d0_.name AS name_1, d0_.logo AS logo_2, d0_.notification_email AS notification_email_3, d0_.support_email AS support_email_4, d0_.facebook_url AS facebook_url_5, d0_.instagram_url AS instagram_url_6, d0_.pinterest_url AS pinterest_url_7, d0_.timezone AS timezone_8, d0_.min_cancellation_notice_minutes AS min_cancellation_notice_minutes_9, d0_.appointments_allow_online_payment AS appointments_allow_online_payment_10, d0_.appointments_max_advance_days AS appointments_max_advance_days_11, d0_.currency_mode AS currency_mode_12, d0_.appointments_allow_pay_at_business AS appointments_allow_pay_at_business_13, d0_.maintenance_mode AS maintenance_mode_14, d0_.maintenance_message AS maintenance_message_15, d0_.chat_enabled AS chat_enabled_16, d0_.reviews_require_approval AS reviews_require_approval_17, d0_.review_request_enabled AS review_request_enabled_18, d0_.review_request_delay_days AS review_request_delay_days_19, d0_.home_products_strategy AS home_products_strategy_20, d0_.appointments_music_enabled AS appointments_music_enabled_21, d0_.appointments_points_enabled AS appointments_points_enabled_22, d0_.membership_points_enabled AS membership_points_enabled_23, d0_.membership_points_per_checkin AS membership_points_per_checkin_24, d0_.membership_points_per_class AS membership_points_per_class_25, d0_.test_domain AS test_domain_26, d0_.home_sections AS home_sections_27, d0_.id AS id_28, d0_.active AS active_29, d0_.created_at AS created_at_30, d0_.updated_at AS updated_at_31, d0_.tenant_id AS tenant_id_32 FROM domains d0_ INNER JOIN tenants t1_ ON d0_.tenant_id = t1_.id WHERE d0_.domain IN (?, ?, ?, ?, ?, ?) AND d0_.active = 1 AND t1_.active = 1
SELECT s0_.page_url AS page_url_0, s0_.id AS id_1, s0_.active AS active_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.page_type AS page_type_5, s0_.meta_title AS meta_title_6, s0_.meta_description AS meta_description_7, s0_.meta_keywords AS meta_keywords_8, s0_.canonical_url AS canonical_url_9, s0_.robots_directive AS robots_directive_10, s0_.og_title AS og_title_11, s0_.og_description AS og_description_12, s0_.og_image AS og_image_13, s0_.scope AS scope_14, s0_.domain_id AS domain_id_15 FROM seo s0_ WHERE (s0_.domain_id = ? AND s0_.page_url = ? AND s0_.active = ?) AND s0_.scope IN ('page') LIMIT 1
SELECT d0_.domain AS domain_0, d0_.name AS name_1, d0_.logo AS logo_2, d0_.notification_email AS notification_email_3, d0_.support_email AS support_email_4, d0_.facebook_url AS facebook_url_5, d0_.instagram_url AS instagram_url_6, d0_.pinterest_url AS pinterest_url_7, d0_.timezone AS timezone_8, d0_.min_cancellation_notice_minutes AS min_cancellation_notice_minutes_9, d0_.appointments_allow_online_payment AS appointments_allow_online_payment_10, d0_.appointments_max_advance_days AS appointments_max_advance_days_11, d0_.currency_mode AS currency_mode_12, d0_.appointments_allow_pay_at_business AS appointments_allow_pay_at_business_13, d0_.maintenance_mode AS maintenance_mode_14, d0_.maintenance_message AS maintenance_message_15, d0_.chat_enabled AS chat_enabled_16, d0_.reviews_require_approval AS reviews_require_approval_17, d0_.review_request_enabled AS review_request_enabled_18, d0_.review_request_delay_days AS review_request_delay_days_19, d0_.home_products_strategy AS home_products_strategy_20, d0_.appointments_music_enabled AS appointments_music_enabled_21, d0_.appointments_points_enabled AS appointments_points_enabled_22, d0_.membership_points_enabled AS membership_points_enabled_23, d0_.membership_points_per_checkin AS membership_points_per_checkin_24, d0_.membership_points_per_class AS membership_points_per_class_25, d0_.test_domain AS test_domain_26, d0_.home_sections AS home_sections_27, d0_.id AS id_28, d0_.active AS active_29, d0_.created_at AS created_at_30, d0_.updated_at AS updated_at_31, d0_.tenant_id AS tenant_id_32 FROM domains d0_ INNER JOIN tenants t1_ ON d0_.tenant_id = t1_.id WHERE d0_.domain IN (?, ?, ?, ?, ?, ?) AND d0_.active = 1 AND t1_.active = 1
SELECT l0_.name AS name_0, l0_.address AS address_1, l0_.phone AS phone_2, l0_.neighborhood AS neighborhood_3, l0_.google_maps_url AS google_maps_url_4, l0_.workstations_capacity AS workstations_capacity_5, l0_.id AS id_6, l0_.active AS active_7, l0_.created_at AS created_at_8, l0_.updated_at AS updated_at_9, l1_.image_path AS image_path_10, l1_.image_url AS image_url_11, l1_.alt_text AS alt_text_12, l1_.sort_order AS sort_order_13, l1_.id AS id_14, l1_.active AS active_15, l1_.created_at AS created_at_16, l1_.updated_at AS updated_at_17, l0_.domain_id AS domain_id_18, l0_.country_id AS country_id_19, l0_.region_id AS region_id_20, l0_.city_id AS city_id_21, l1_.location_id AS location_id_22 FROM locations l0_ LEFT JOIN location_images l1_ ON l0_.id = l1_.location_id AND (l1_.active = ?) WHERE l0_.domain_id = ? AND l0_.active = ? ORDER BY l0_.name ASC, l1_.sort_order ASC
SELECT a0_.day_of_week AS day_of_week_0, a0_.start_time AS start_time_1, a0_.end_time AS end_time_2, a0_.id AS id_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.domain_id AS domain_id_7, a0_.location_id AS location_id_8, a0_.professional_id AS professional_id_9 FROM availability_rules a0_ WHERE a0_.location_id = ? AND a0_.professional_id IS NULL AND a0_.active = ? ORDER BY a0_.day_of_week ASC, a0_.start_time ASC
SELECT a0_.day_of_week AS day_of_week_0, a0_.start_time AS start_time_1, a0_.end_time AS end_time_2, a0_.id AS id_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.domain_id AS domain_id_7, a0_.location_id AS location_id_8, a0_.professional_id AS professional_id_9 FROM availability_rules a0_ WHERE a0_.location_id = ? AND a0_.professional_id IS NULL AND a0_.active = ? ORDER BY a0_.day_of_week ASC, a0_.start_time ASC
SELECT a0_.day_of_week AS day_of_week_0, a0_.start_time AS start_time_1, a0_.end_time AS end_time_2, a0_.id AS id_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.domain_id AS domain_id_7, a0_.location_id AS location_id_8, a0_.professional_id AS professional_id_9 FROM availability_rules a0_ WHERE a0_.location_id = ? AND a0_.professional_id IS NOT NULL AND a0_.active = ? ORDER BY a0_.day_of_week ASC, a0_.start_time ASC
SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.id = ?
SELECT c0_.code AS code_0 FROM domain_allowed_currencies d1_ INNER JOIN currencies c0_ ON d1_.currency_id = c0_.id WHERE d1_.domain_id = ? AND d1_.active = 1 AND c0_.active = 1 ORDER BY c0_.code ASC
SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1
SELECT s0_.name AS name_0, s0_.description AS description_1, s0_.duration_minutes AS duration_minutes_2, s0_.price AS price_3, s0_.requires_workstation AS requires_workstation_4, s0_.id AS id_5, s0_.active AS active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s1_.image_path AS image_path_9, s1_.image_url AS image_url_10, s1_.alt_text AS alt_text_11, s1_.sort_order AS sort_order_12, s1_.id AS id_13, s1_.active AS active_14, s1_.created_at AS created_at_15, s1_.updated_at AS updated_at_16, s0_.domain_id AS domain_id_17, s0_.currency_id AS currency_id_18, s1_.service_id AS service_id_19 FROM services s0_ LEFT JOIN service_images s1_ ON s0_.id = s1_.service_id AND (s1_.active = ?) WHERE s0_.domain_id = ? AND s0_.active = ? ORDER BY s0_.name ASC, s1_.sort_order ASC
SELECT p0_.name AS name_0, p0_.instructions AS instructions_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.domain_id AS domain_id_6, p0_.payment_gateway_id AS payment_gateway_id_7, p0_.type_id AS type_id_8 FROM payment_methods p0_ LEFT JOIN payment_method_types p1_ ON p0_.type_id = p1_.id WHERE p0_.domain_id = ? AND p0_.active = ? AND (p1_.id IS NULL OR (p1_.active = ? AND p1_.usable_in_appointments = ?))
SELECT c0_.id AS id_0 FROM countries_payment_method_types c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ?
SELECT r0_.id AS id_0 FROM regions_payment_method_types r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_method_type_id = ? AND r1_.active = ?
SELECT c0_.id AS id_0 FROM cities_payment_method_types c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ?
SELECT c0_.id AS id_0 FROM countries_payment_methods c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ?
SELECT r0_.id AS id_0 FROM regions_payment_methods r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_methods_id = ? AND r1_.active = ?
SELECT c0_.id AS id_0 FROM cities_payment_methods c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ?
SELECT c0_.id AS id_0 FROM countries_payment_method_types c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ?
SELECT r0_.id AS id_0 FROM regions_payment_method_types r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_method_type_id = ? AND r1_.active = ?
SELECT c0_.id AS id_0 FROM cities_payment_method_types c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ?
SELECT c0_.id AS id_0 FROM countries_payment_methods c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ?
SELECT r0_.id AS id_0 FROM regions_payment_methods r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_methods_id = ? AND r1_.active = ?
SELECT c0_.id AS id_0 FROM cities_payment_methods c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ?
SELECT c0_.id AS id_0 FROM countries_payment_method_types c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ?
SELECT r0_.id AS id_0 FROM regions_payment_method_types r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_method_type_id = ? AND r1_.active = ?
SELECT c0_.id AS id_0 FROM cities_payment_method_types c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ?
SELECT c0_.id AS id_0 FROM countries_payment_methods c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ?
SELECT r0_.id AS id_0 FROM regions_payment_methods r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_methods_id = ? AND r1_.active = ?
SELECT c0_.id AS id_0 FROM cities_payment_methods c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ?
SELECT p0_.name AS name_0, p0_.instructions AS instructions_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.domain_id AS domain_id_6, p0_.payment_gateway_id AS payment_gateway_id_7, p0_.type_id AS type_id_8 FROM payment_methods p0_ LEFT JOIN payment_method_types p1_ ON p0_.type_id = p1_.id WHERE p0_.domain_id = ? AND p0_.active = ? AND (p1_.id IS NULL OR (p1_.active = ? AND p1_.usable_in_appointments = ?))
SELECT t0.code AS code_1, t0.kind AS kind_2, t0.usable_in_products AS usable_in_products_3, t0.usable_in_appointments AS usable_in_appointments_4, t0.id AS id_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_method_types t0 WHERE t0.id = ?
SELECT t0.code AS code_1, t0.kind AS kind_2, t0.usable_in_products AS usable_in_products_3, t0.usable_in_appointments AS usable_in_appointments_4, t0.id AS id_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_method_types t0 WHERE t0.id = ?
SELECT t0.code AS code_1, t0.kind AS kind_2, t0.usable_in_products AS usable_in_products_3, t0.usable_in_appointments AS usable_in_appointments_4, t0.id AS id_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_method_types t0 WHERE t0.id = ?
SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, l1_.code AS code_6, l1_.name AS name_7, l1_.flag AS flag_8, l1_.is_default AS is_default_9, l1_.position AS position_10, l1_.id AS id_11, l1_.active AS active_12, l1_.created_at AS created_at_13, l1_.updated_at AS updated_at_14, p0_.payment_method_type_id AS payment_method_type_id_15, p0_.language_id AS language_id_16 FROM payment_method_type_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.payment_method_type_id IN (?, ?) AND p0_.active = ? AND l1_.active = ?
SELECT l0_.code AS code_0, l0_.name AS name_1, l0_.flag AS flag_2, l0_.is_default AS is_default_3, l0_.position AS position_4, l0_.id AS id_5, l0_.active AS active_6, l0_.created_at AS created_at_7, l0_.updated_at AS updated_at_8 FROM languages l0_ WHERE l0_.active = ? ORDER BY l0_.position ASC, l0_.name ASC
SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, l1_.code AS code_6, l1_.name AS name_7, l1_.flag AS flag_8, l1_.is_default AS is_default_9, l1_.position AS position_10, l1_.id AS id_11, l1_.active AS active_12, l1_.created_at AS created_at_13, l1_.updated_at AS updated_at_14, p0_.payment_method_type_id AS payment_method_type_id_15, p0_.language_id AS language_id_16 FROM payment_method_type_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.payment_method_type_id IN (?, ?) AND p0_.active = ? AND l1_.active = ?
SELECT l0_.code AS code_0, l0_.name AS name_1, l0_.flag AS flag_2, l0_.is_default AS is_default_3, l0_.position AS position_4, l0_.id AS id_5, l0_.active AS active_6, l0_.created_at AS created_at_7, l0_.updated_at AS updated_at_8 FROM languages l0_ WHERE l0_.active = ? ORDER BY l0_.position ASC, l0_.name ASC
SELECT p0_.name AS name_0, p0_.bio AS bio_1, p0_.photo_url AS photo_url_2, p0_.id AS id_3, p0_.active AS active_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p1_.image_path AS image_path_7, p1_.image_url AS image_url_8, p1_.alt_text AS alt_text_9, p1_.sort_order AS sort_order_10, p1_.id AS id_11, p1_.active AS active_12, p1_.created_at AS created_at_13, p1_.updated_at AS updated_at_14, p0_.domain_id AS domain_id_15, p0_.user_id AS user_id_16, p0_.location_id AS location_id_17, p1_.professional_id AS professional_id_18 FROM professionals p0_ LEFT JOIN professional_images p1_ ON p0_.id = p1_.professional_id AND (p1_.active = ?) WHERE p0_.domain_id = ? AND p0_.active = ? ORDER BY p0_.name ASC, p1_.sort_order ASC
SELECT p0_.id AS id_0, l1_.id AS id_1 FROM professionals p0_ INNER JOIN locations l1_ ON p0_.location_id = l1_.id WHERE p0_.domain_id = ? AND p0_.active = ?
SELECT s0_.id AS id_0, p1_.id AS id_1 FROM professionals_services p2_ INNER JOIN professionals p1_ ON p2_.professional_id = p1_.id INNER JOIN services s0_ ON p2_.service_id = s0_.id WHERE p1_.domain_id = ? AND p2_.active = ? AND p1_.active = ?
SELECT t0.name AS name_1, t0.description AS description_2, t0.iso_code AS iso_code_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.currency_id AS currency_id_8 FROM countries t0 WHERE t0.id = ?
SELECT d0_.id AS id_0, d0_.active AS active_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3, d0_.domain_id AS domain_id_4, d0_.module_feature_id AS module_feature_id_5 FROM domain_module_features d0_ INNER JOIN module_features m1_ ON d0_.module_feature_id = m1_.id WHERE d0_.domain_id = ? AND m1_.slug = ?
SELECT m0_.name AS name_0, m0_.sort_order AS sort_order_1, m0_.id AS id_2, m0_.active AS active_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.domain_id AS domain_id_6 FROM music_genres m0_ WHERE m0_.domain_id = ? AND m0_.active = ? ORDER BY m0_.sort_order ASC, m0_.name ASC
SELECT t0.money_per_point AS money_per_point_1, t0.point_value AS point_value_2, t0.min_points_to_redeem AS min_points_to_redeem_3, t0.max_redeem_percent AS max_redeem_percent_4, t0.expiration_days AS expiration_days_5, t0.id AS id_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.domain_id AS domain_id_10 FROM point_conditions t0 WHERE t0.domain_id = ? AND t0.active = ? ORDER BY t0.created_at ASC
SELECT c0_.code AS code_0 FROM domain_allowed_currencies d1_ INNER JOIN currencies c0_ ON d1_.currency_id = c0_.id WHERE d1_.domain_id = ? AND d1_.active = 1 AND c0_.active = 1 ORDER BY c0_.code ASC
SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.active = ? ORDER BY t0.code ASC
SELECT c0_.code AS code_0 FROM domain_allowed_currencies d1_ INNER JOIN currencies c0_ ON d1_.currency_id = c0_.id WHERE d1_.domain_id = ? AND d1_.active = 1 AND c0_.active = 1 ORDER BY c0_.code ASC
SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1
SELECT t0.names AS names_1, t0.description AS description_2, t0.name AS name_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ?
SELECT t0.money_per_point AS money_per_point_1, t0.point_value AS point_value_2, t0.min_points_to_redeem AS min_points_to_redeem_3, t0.max_redeem_percent AS max_redeem_percent_4, t0.expiration_days AS expiration_days_5, t0.id AS id_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.domain_id AS domain_id_10 FROM point_conditions t0 WHERE t0.domain_id = ? AND t0.active = ? ORDER BY t0.created_at ASC

#▲	Time	Info
1	1.17 ms	SELECT t0.name AS name_1, t0.description AS description_2, t0.iso_code AS iso_code_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.currency_id AS currency_id_8 FROM countries t0 WHERE t0.iso_code = ? AND t0.active = ? LIMIT 1 Parameters: [`"US" 1`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.description AS description_2, t0.iso_code AS iso_code_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.currency_id AS currency_id_8 FROM countries t0 WHERE t0.iso_code = ? AND t0.active = ? LIMIT 1 SELECT t0.name AS name_1, t0.description AS description_2, t0.iso_code AS iso_code_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.currency_id AS currency_id_8 FROM countries t0 WHERE t0.iso_code = 'US' AND t0.active = 1 LIMIT 1;
2	1.13 ms	SELECT d0_.domain AS domain_0, d0_.name AS name_1, d0_.logo AS logo_2, d0_.notification_email AS notification_email_3, d0_.support_email AS support_email_4, d0_.facebook_url AS facebook_url_5, d0_.instagram_url AS instagram_url_6, d0_.pinterest_url AS pinterest_url_7, d0_.timezone AS timezone_8, d0_.min_cancellation_notice_minutes AS min_cancellation_notice_minutes_9, d0_.appointments_allow_online_payment AS appointments_allow_online_payment_10, d0_.appointments_max_advance_days AS appointments_max_advance_days_11, d0_.currency_mode AS currency_mode_12, d0_.appointments_allow_pay_at_business AS appointments_allow_pay_at_business_13, d0_.maintenance_mode AS maintenance_mode_14, d0_.maintenance_message AS maintenance_message_15, d0_.chat_enabled AS chat_enabled_16, d0_.reviews_require_approval AS reviews_require_approval_17, d0_.review_request_enabled AS review_request_enabled_18, d0_.review_request_delay_days AS review_request_delay_days_19, d0_.home_products_strategy AS home_products_strategy_20, d0_.appointments_music_enabled AS appointments_music_enabled_21, d0_.appointments_points_enabled AS appointments_points_enabled_22, d0_.membership_points_enabled AS membership_points_enabled_23, d0_.membership_points_per_checkin AS membership_points_per_checkin_24, d0_.membership_points_per_class AS membership_points_per_class_25, d0_.test_domain AS test_domain_26, d0_.home_sections AS home_sections_27, d0_.id AS id_28, d0_.active AS active_29, d0_.created_at AS created_at_30, d0_.updated_at AS updated_at_31, d0_.tenant_id AS tenant_id_32 FROM domains d0_ INNER JOIN tenants t1_ ON d0_.tenant_id = t1_.id WHERE d0_.domain IN (?, ?, ?, ?, ?, ?) AND d0_.active = 1 AND t1_.active = 1 Parameters: [`"http://thorha.com" "https://thorha.com" "thorha.com" "http://thorha.com/" "https://thorha.com/" "thorha.com/"`] View formatted query View runnable query Explain query SELECT d0_.domain AS domain_0, d0_.name AS name_1, d0_.logo AS logo_2, d0_.notification_email AS notification_email_3, d0_.support_email AS support_email_4, d0_.facebook_url AS facebook_url_5, d0_.instagram_url AS instagram_url_6, d0_.pinterest_url AS pinterest_url_7, d0_.timezone AS timezone_8, d0_.min_cancellation_notice_minutes AS min_cancellation_notice_minutes_9, d0_.appointments_allow_online_payment AS appointments_allow_online_payment_10, d0_.appointments_max_advance_days AS appointments_max_advance_days_11, d0_.currency_mode AS currency_mode_12, d0_.appointments_allow_pay_at_business AS appointments_allow_pay_at_business_13, d0_.maintenance_mode AS maintenance_mode_14, d0_.maintenance_message AS maintenance_message_15, d0_.chat_enabled AS chat_enabled_16, d0_.reviews_require_approval AS reviews_require_approval_17, d0_.review_request_enabled AS review_request_enabled_18, d0_.review_request_delay_days AS review_request_delay_days_19, d0_.home_products_strategy AS home_products_strategy_20, d0_.appointments_music_enabled AS appointments_music_enabled_21, d0_.appointments_points_enabled AS appointments_points_enabled_22, d0_.membership_points_enabled AS membership_points_enabled_23, d0_.membership_points_per_checkin AS membership_points_per_checkin_24, d0_.membership_points_per_class AS membership_points_per_class_25, d0_.test_domain AS test_domain_26, d0_.home_sections AS home_sections_27, d0_.id AS id_28, d0_.active AS active_29, d0_.created_at AS created_at_30, d0_.updated_at AS updated_at_31, d0_.tenant_id AS tenant_id_32 FROM domains d0_ INNER JOIN tenants t1_ ON d0_.tenant_id = t1_.id WHERE d0_.domain IN (?, ?, ?, ?, ?, ?) AND d0_.active = 1 AND t1_.active = 1 SELECT d0_.domain AS domain_0, d0_.name AS name_1, d0_.logo AS logo_2, d0_.notification_email AS notification_email_3, d0_.support_email AS support_email_4, d0_.facebook_url AS facebook_url_5, d0_.instagram_url AS instagram_url_6, d0_.pinterest_url AS pinterest_url_7, d0_.timezone AS timezone_8, d0_.min_cancellation_notice_minutes AS min_cancellation_notice_minutes_9, d0_.appointments_allow_online_payment AS appointments_allow_online_payment_10, d0_.appointments_max_advance_days AS appointments_max_advance_days_11, d0_.currency_mode AS currency_mode_12, d0_.appointments_allow_pay_at_business AS appointments_allow_pay_at_business_13, d0_.maintenance_mode AS maintenance_mode_14, d0_.maintenance_message AS maintenance_message_15, d0_.chat_enabled AS chat_enabled_16, d0_.reviews_require_approval AS reviews_require_approval_17, d0_.review_request_enabled AS review_request_enabled_18, d0_.review_request_delay_days AS review_request_delay_days_19, d0_.home_products_strategy AS home_products_strategy_20, d0_.appointments_music_enabled AS appointments_music_enabled_21, d0_.appointments_points_enabled AS appointments_points_enabled_22, d0_.membership_points_enabled AS membership_points_enabled_23, d0_.membership_points_per_checkin AS membership_points_per_checkin_24, d0_.membership_points_per_class AS membership_points_per_class_25, d0_.test_domain AS test_domain_26, d0_.home_sections AS home_sections_27, d0_.id AS id_28, d0_.active AS active_29, d0_.created_at AS created_at_30, d0_.updated_at AS updated_at_31, d0_.tenant_id AS tenant_id_32 FROM domains d0_ INNER JOIN tenants t1_ ON d0_.tenant_id = t1_.id WHERE d0_.domain IN ('http://thorha.com', 'https://thorha.com', 'thorha.com', 'http://thorha.com/', 'https://thorha.com/', 'thorha.com/') AND d0_.active = 1 AND t1_.active = 1;
3	0.56 ms	SELECT s0_.page_url AS page_url_0, s0_.id AS id_1, s0_.active AS active_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.page_type AS page_type_5, s0_.meta_title AS meta_title_6, s0_.meta_description AS meta_description_7, s0_.meta_keywords AS meta_keywords_8, s0_.canonical_url AS canonical_url_9, s0_.robots_directive AS robots_directive_10, s0_.og_title AS og_title_11, s0_.og_description AS og_description_12, s0_.og_image AS og_image_13, s0_.scope AS scope_14, s0_.domain_id AS domain_id_15 FROM seo s0_ WHERE (s0_.domain_id = ? AND s0_.page_url = ? AND s0_.active = ?) AND s0_.scope IN ('page') LIMIT 1 Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" "/es/appointments" 1`] View formatted query View runnable query Explain query SELECT s0_.page_url AS page_url_0, s0_.id AS id_1, s0_.active AS active_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.page_type AS page_type_5, s0_.meta_title AS meta_title_6, s0_.meta_description AS meta_description_7, s0_.meta_keywords AS meta_keywords_8, s0_.canonical_url AS canonical_url_9, s0_.robots_directive AS robots_directive_10, s0_.og_title AS og_title_11, s0_.og_description AS og_description_12, s0_.og_image AS og_image_13, s0_.scope AS scope_14, s0_.domain_id AS domain_id_15 FROM seo s0_ WHERE ( s0_.domain_id = ? AND s0_.page_url = ? AND s0_.active = ? ) AND s0_.scope IN ('page') LIMIT 1 SELECT s0_.page_url AS page_url_0, s0_.id AS id_1, s0_.active AS active_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.page_type AS page_type_5, s0_.meta_title AS meta_title_6, s0_.meta_description AS meta_description_7, s0_.meta_keywords AS meta_keywords_8, s0_.canonical_url AS canonical_url_9, s0_.robots_directive AS robots_directive_10, s0_.og_title AS og_title_11, s0_.og_description AS og_description_12, s0_.og_image AS og_image_13, s0_.scope AS scope_14, s0_.domain_id AS domain_id_15 FROM seo s0_ WHERE (s0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND s0_.page_url = '/es/appointments' AND s0_.active = 1) AND s0_.scope IN ('page') LIMIT 1;
4	1.30 ms	SELECT d0_.domain AS domain_0, d0_.name AS name_1, d0_.logo AS logo_2, d0_.notification_email AS notification_email_3, d0_.support_email AS support_email_4, d0_.facebook_url AS facebook_url_5, d0_.instagram_url AS instagram_url_6, d0_.pinterest_url AS pinterest_url_7, d0_.timezone AS timezone_8, d0_.min_cancellation_notice_minutes AS min_cancellation_notice_minutes_9, d0_.appointments_allow_online_payment AS appointments_allow_online_payment_10, d0_.appointments_max_advance_days AS appointments_max_advance_days_11, d0_.currency_mode AS currency_mode_12, d0_.appointments_allow_pay_at_business AS appointments_allow_pay_at_business_13, d0_.maintenance_mode AS maintenance_mode_14, d0_.maintenance_message AS maintenance_message_15, d0_.chat_enabled AS chat_enabled_16, d0_.reviews_require_approval AS reviews_require_approval_17, d0_.review_request_enabled AS review_request_enabled_18, d0_.review_request_delay_days AS review_request_delay_days_19, d0_.home_products_strategy AS home_products_strategy_20, d0_.appointments_music_enabled AS appointments_music_enabled_21, d0_.appointments_points_enabled AS appointments_points_enabled_22, d0_.membership_points_enabled AS membership_points_enabled_23, d0_.membership_points_per_checkin AS membership_points_per_checkin_24, d0_.membership_points_per_class AS membership_points_per_class_25, d0_.test_domain AS test_domain_26, d0_.home_sections AS home_sections_27, d0_.id AS id_28, d0_.active AS active_29, d0_.created_at AS created_at_30, d0_.updated_at AS updated_at_31, d0_.tenant_id AS tenant_id_32 FROM domains d0_ INNER JOIN tenants t1_ ON d0_.tenant_id = t1_.id WHERE d0_.domain IN (?, ?, ?, ?, ?, ?) AND d0_.active = 1 AND t1_.active = 1 Parameters: [`"http://thorha.com" "https://thorha.com" "thorha.com" "http://thorha.com/" "https://thorha.com/" "thorha.com/"`] View formatted query View runnable query Explain query SELECT d0_.domain AS domain_0, d0_.name AS name_1, d0_.logo AS logo_2, d0_.notification_email AS notification_email_3, d0_.support_email AS support_email_4, d0_.facebook_url AS facebook_url_5, d0_.instagram_url AS instagram_url_6, d0_.pinterest_url AS pinterest_url_7, d0_.timezone AS timezone_8, d0_.min_cancellation_notice_minutes AS min_cancellation_notice_minutes_9, d0_.appointments_allow_online_payment AS appointments_allow_online_payment_10, d0_.appointments_max_advance_days AS appointments_max_advance_days_11, d0_.currency_mode AS currency_mode_12, d0_.appointments_allow_pay_at_business AS appointments_allow_pay_at_business_13, d0_.maintenance_mode AS maintenance_mode_14, d0_.maintenance_message AS maintenance_message_15, d0_.chat_enabled AS chat_enabled_16, d0_.reviews_require_approval AS reviews_require_approval_17, d0_.review_request_enabled AS review_request_enabled_18, d0_.review_request_delay_days AS review_request_delay_days_19, d0_.home_products_strategy AS home_products_strategy_20, d0_.appointments_music_enabled AS appointments_music_enabled_21, d0_.appointments_points_enabled AS appointments_points_enabled_22, d0_.membership_points_enabled AS membership_points_enabled_23, d0_.membership_points_per_checkin AS membership_points_per_checkin_24, d0_.membership_points_per_class AS membership_points_per_class_25, d0_.test_domain AS test_domain_26, d0_.home_sections AS home_sections_27, d0_.id AS id_28, d0_.active AS active_29, d0_.created_at AS created_at_30, d0_.updated_at AS updated_at_31, d0_.tenant_id AS tenant_id_32 FROM domains d0_ INNER JOIN tenants t1_ ON d0_.tenant_id = t1_.id WHERE d0_.domain IN (?, ?, ?, ?, ?, ?) AND d0_.active = 1 AND t1_.active = 1 SELECT d0_.domain AS domain_0, d0_.name AS name_1, d0_.logo AS logo_2, d0_.notification_email AS notification_email_3, d0_.support_email AS support_email_4, d0_.facebook_url AS facebook_url_5, d0_.instagram_url AS instagram_url_6, d0_.pinterest_url AS pinterest_url_7, d0_.timezone AS timezone_8, d0_.min_cancellation_notice_minutes AS min_cancellation_notice_minutes_9, d0_.appointments_allow_online_payment AS appointments_allow_online_payment_10, d0_.appointments_max_advance_days AS appointments_max_advance_days_11, d0_.currency_mode AS currency_mode_12, d0_.appointments_allow_pay_at_business AS appointments_allow_pay_at_business_13, d0_.maintenance_mode AS maintenance_mode_14, d0_.maintenance_message AS maintenance_message_15, d0_.chat_enabled AS chat_enabled_16, d0_.reviews_require_approval AS reviews_require_approval_17, d0_.review_request_enabled AS review_request_enabled_18, d0_.review_request_delay_days AS review_request_delay_days_19, d0_.home_products_strategy AS home_products_strategy_20, d0_.appointments_music_enabled AS appointments_music_enabled_21, d0_.appointments_points_enabled AS appointments_points_enabled_22, d0_.membership_points_enabled AS membership_points_enabled_23, d0_.membership_points_per_checkin AS membership_points_per_checkin_24, d0_.membership_points_per_class AS membership_points_per_class_25, d0_.test_domain AS test_domain_26, d0_.home_sections AS home_sections_27, d0_.id AS id_28, d0_.active AS active_29, d0_.created_at AS created_at_30, d0_.updated_at AS updated_at_31, d0_.tenant_id AS tenant_id_32 FROM domains d0_ INNER JOIN tenants t1_ ON d0_.tenant_id = t1_.id WHERE d0_.domain IN ('http://thorha.com', 'https://thorha.com', 'thorha.com', 'http://thorha.com/', 'https://thorha.com/', 'thorha.com/') AND d0_.active = 1 AND t1_.active = 1;
5	1.44 ms	SELECT l0_.name AS name_0, l0_.address AS address_1, l0_.phone AS phone_2, l0_.neighborhood AS neighborhood_3, l0_.google_maps_url AS google_maps_url_4, l0_.workstations_capacity AS workstations_capacity_5, l0_.id AS id_6, l0_.active AS active_7, l0_.created_at AS created_at_8, l0_.updated_at AS updated_at_9, l1_.image_path AS image_path_10, l1_.image_url AS image_url_11, l1_.alt_text AS alt_text_12, l1_.sort_order AS sort_order_13, l1_.id AS id_14, l1_.active AS active_15, l1_.created_at AS created_at_16, l1_.updated_at AS updated_at_17, l0_.domain_id AS domain_id_18, l0_.country_id AS country_id_19, l0_.region_id AS region_id_20, l0_.city_id AS city_id_21, l1_.location_id AS location_id_22 FROM locations l0_ LEFT JOIN location_images l1_ ON l0_.id = l1_.location_id AND (l1_.active = ?) WHERE l0_.domain_id = ? AND l0_.active = ? ORDER BY l0_.name ASC, l1_.sort_order ASC Parameters: [`1 b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1`] View formatted query View runnable query Explain query SELECT l0_.name AS name_0, l0_.address AS address_1, l0_.phone AS phone_2, l0_.neighborhood AS neighborhood_3, l0_.google_maps_url AS google_maps_url_4, l0_.workstations_capacity AS workstations_capacity_5, l0_.id AS id_6, l0_.active AS active_7, l0_.created_at AS created_at_8, l0_.updated_at AS updated_at_9, l1_.image_path AS image_path_10, l1_.image_url AS image_url_11, l1_.alt_text AS alt_text_12, l1_.sort_order AS sort_order_13, l1_.id AS id_14, l1_.active AS active_15, l1_.created_at AS created_at_16, l1_.updated_at AS updated_at_17, l0_.domain_id AS domain_id_18, l0_.country_id AS country_id_19, l0_.region_id AS region_id_20, l0_.city_id AS city_id_21, l1_.location_id AS location_id_22 FROM locations l0_ LEFT JOIN location_images l1_ ON l0_.id = l1_.location_id AND (l1_.active = ?) WHERE l0_.domain_id = ? AND l0_.active = ? ORDER BY l0_.name ASC, l1_.sort_order ASC SELECT l0_.name AS name_0, l0_.address AS address_1, l0_.phone AS phone_2, l0_.neighborhood AS neighborhood_3, l0_.google_maps_url AS google_maps_url_4, l0_.workstations_capacity AS workstations_capacity_5, l0_.id AS id_6, l0_.active AS active_7, l0_.created_at AS created_at_8, l0_.updated_at AS updated_at_9, l1_.image_path AS image_path_10, l1_.image_url AS image_url_11, l1_.alt_text AS alt_text_12, l1_.sort_order AS sort_order_13, l1_.id AS id_14, l1_.active AS active_15, l1_.created_at AS created_at_16, l1_.updated_at AS updated_at_17, l0_.domain_id AS domain_id_18, l0_.country_id AS country_id_19, l0_.region_id AS region_id_20, l0_.city_id AS city_id_21, l1_.location_id AS location_id_22 FROM locations l0_ LEFT JOIN location_images l1_ ON l0_.id = l1_.location_id AND (l1_.active = 1) WHERE l0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND l0_.active = 1 ORDER BY l0_.name ASC, l1_.sort_order ASC;
6	0.75 ms	SELECT a0_.day_of_week AS day_of_week_0, a0_.start_time AS start_time_1, a0_.end_time AS end_time_2, a0_.id AS id_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.domain_id AS domain_id_7, a0_.location_id AS location_id_8, a0_.professional_id AS professional_id_9 FROM availability_rules a0_ WHERE a0_.location_id = ? AND a0_.professional_id IS NULL AND a0_.active = ? ORDER BY a0_.day_of_week ASC, a0_.start_time ASC Parameters: [`b"\x01¡±Ç\x17ox\x1C•\x16»ã˜\x0E[‘" 1`] View formatted query View runnable query Explain query SELECT a0_.day_of_week AS day_of_week_0, a0_.start_time AS start_time_1, a0_.end_time AS end_time_2, a0_.id AS id_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.domain_id AS domain_id_7, a0_.location_id AS location_id_8, a0_.professional_id AS professional_id_9 FROM availability_rules a0_ WHERE a0_.location_id = ? AND a0_.professional_id IS NULL AND a0_.active = ? ORDER BY a0_.day_of_week ASC, a0_.start_time ASC SELECT a0_.day_of_week AS day_of_week_0, a0_.start_time AS start_time_1, a0_.end_time AS end_time_2, a0_.id AS id_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.domain_id AS domain_id_7, a0_.location_id AS location_id_8, a0_.professional_id AS professional_id_9 FROM availability_rules a0_ WHERE a0_.location_id = 0x01A1B1C7176F781C9516BBE3980E5B91 AND a0_.professional_id IS NULL AND a0_.active = 1 ORDER BY a0_.day_of_week ASC, a0_.start_time ASC;
7	0.38 ms	SELECT a0_.day_of_week AS day_of_week_0, a0_.start_time AS start_time_1, a0_.end_time AS end_time_2, a0_.id AS id_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.domain_id AS domain_id_7, a0_.location_id AS location_id_8, a0_.professional_id AS professional_id_9 FROM availability_rules a0_ WHERE a0_.location_id = ? AND a0_.professional_id IS NULL AND a0_.active = ? ORDER BY a0_.day_of_week ASC, a0_.start_time ASC Parameters: [`b"\x01¡±Ç\x17oxØ•\x16»ã˜ßÃ÷" 1`] View formatted query View runnable query Explain query SELECT a0_.day_of_week AS day_of_week_0, a0_.start_time AS start_time_1, a0_.end_time AS end_time_2, a0_.id AS id_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.domain_id AS domain_id_7, a0_.location_id AS location_id_8, a0_.professional_id AS professional_id_9 FROM availability_rules a0_ WHERE a0_.location_id = ? AND a0_.professional_id IS NULL AND a0_.active = ? ORDER BY a0_.day_of_week ASC, a0_.start_time ASC SELECT a0_.day_of_week AS day_of_week_0, a0_.start_time AS start_time_1, a0_.end_time AS end_time_2, a0_.id AS id_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.domain_id AS domain_id_7, a0_.location_id AS location_id_8, a0_.professional_id AS professional_id_9 FROM availability_rules a0_ WHERE a0_.location_id = 0x01A1B1C7176F78D89516BBE398DFC3F7 AND a0_.professional_id IS NULL AND a0_.active = 1 ORDER BY a0_.day_of_week ASC, a0_.start_time ASC;
8	0.39 ms	SELECT a0_.day_of_week AS day_of_week_0, a0_.start_time AS start_time_1, a0_.end_time AS end_time_2, a0_.id AS id_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.domain_id AS domain_id_7, a0_.location_id AS location_id_8, a0_.professional_id AS professional_id_9 FROM availability_rules a0_ WHERE a0_.location_id = ? AND a0_.professional_id IS NOT NULL AND a0_.active = ? ORDER BY a0_.day_of_week ASC, a0_.start_time ASC Parameters: [`b"\x01¡±Ç\x17oxØ•\x16»ã˜ßÃ÷" 1`] View formatted query View runnable query Explain query SELECT a0_.day_of_week AS day_of_week_0, a0_.start_time AS start_time_1, a0_.end_time AS end_time_2, a0_.id AS id_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.domain_id AS domain_id_7, a0_.location_id AS location_id_8, a0_.professional_id AS professional_id_9 FROM availability_rules a0_ WHERE a0_.location_id = ? AND a0_.professional_id IS NOT NULL AND a0_.active = ? ORDER BY a0_.day_of_week ASC, a0_.start_time ASC SELECT a0_.day_of_week AS day_of_week_0, a0_.start_time AS start_time_1, a0_.end_time AS end_time_2, a0_.id AS id_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.domain_id AS domain_id_7, a0_.location_id AS location_id_8, a0_.professional_id AS professional_id_9 FROM availability_rules a0_ WHERE a0_.location_id = 0x01A1B1C7176F78D89516BBE398DFC3F7 AND a0_.professional_id IS NOT NULL AND a0_.active = 1 ORDER BY a0_.day_of_week ASC, a0_.start_time ASC;
9	0.29 ms	SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.id = ? Parameters: [`b"\x01¡±Ç\x15²~¶»\r_ô\x02 N²"`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.id = ? SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.id = 0x01A1B1C715B27EB6BB0D5FF402A04EB2;
10	0.43 ms	SELECT c0_.code AS code_0 FROM domain_allowed_currencies d1_ INNER JOIN currencies c0_ ON d1_.currency_id = c0_.id WHERE d1_.domain_id = ? AND d1_.active = 1 AND c0_.active = 1 ORDER BY c0_.code ASC Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á"`] View formatted query View runnable query Explain query SELECT c0_.code AS code_0 FROM domain_allowed_currencies d1_ INNER JOIN currencies c0_ ON d1_.currency_id = c0_.id WHERE d1_.domain_id = ? AND d1_.active = 1 AND c0_.active = 1 ORDER BY c0_.code ASC SELECT c0_.code AS code_0 FROM domain_allowed_currencies d1_ INNER JOIN currencies c0_ ON d1_.currency_id = c0_.id WHERE d1_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND d1_.active = 1 AND c0_.active = 1 ORDER BY c0_.code ASC;
11	0.42 ms	SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1 Parameters: [`"USD" 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1 SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.code = 'USD' AND t0.active = 1 LIMIT 1;
12	1.49 ms	SELECT s0_.name AS name_0, s0_.description AS description_1, s0_.duration_minutes AS duration_minutes_2, s0_.price AS price_3, s0_.requires_workstation AS requires_workstation_4, s0_.id AS id_5, s0_.active AS active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s1_.image_path AS image_path_9, s1_.image_url AS image_url_10, s1_.alt_text AS alt_text_11, s1_.sort_order AS sort_order_12, s1_.id AS id_13, s1_.active AS active_14, s1_.created_at AS created_at_15, s1_.updated_at AS updated_at_16, s0_.domain_id AS domain_id_17, s0_.currency_id AS currency_id_18, s1_.service_id AS service_id_19 FROM services s0_ LEFT JOIN service_images s1_ ON s0_.id = s1_.service_id AND (s1_.active = ?) WHERE s0_.domain_id = ? AND s0_.active = ? ORDER BY s0_.name ASC, s1_.sort_order ASC Parameters: [`1 b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1`] View formatted query View runnable query Explain query SELECT s0_.name AS name_0, s0_.description AS description_1, s0_.duration_minutes AS duration_minutes_2, s0_.price AS price_3, s0_.requires_workstation AS requires_workstation_4, s0_.id AS id_5, s0_.active AS active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s1_.image_path AS image_path_9, s1_.image_url AS image_url_10, s1_.alt_text AS alt_text_11, s1_.sort_order AS sort_order_12, s1_.id AS id_13, s1_.active AS active_14, s1_.created_at AS created_at_15, s1_.updated_at AS updated_at_16, s0_.domain_id AS domain_id_17, s0_.currency_id AS currency_id_18, s1_.service_id AS service_id_19 FROM services s0_ LEFT JOIN service_images s1_ ON s0_.id = s1_.service_id AND (s1_.active = ?) WHERE s0_.domain_id = ? AND s0_.active = ? ORDER BY s0_.name ASC, s1_.sort_order ASC SELECT s0_.name AS name_0, s0_.description AS description_1, s0_.duration_minutes AS duration_minutes_2, s0_.price AS price_3, s0_.requires_workstation AS requires_workstation_4, s0_.id AS id_5, s0_.active AS active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s1_.image_path AS image_path_9, s1_.image_url AS image_url_10, s1_.alt_text AS alt_text_11, s1_.sort_order AS sort_order_12, s1_.id AS id_13, s1_.active AS active_14, s1_.created_at AS created_at_15, s1_.updated_at AS updated_at_16, s0_.domain_id AS domain_id_17, s0_.currency_id AS currency_id_18, s1_.service_id AS service_id_19 FROM services s0_ LEFT JOIN service_images s1_ ON s0_.id = s1_.service_id AND (s1_.active = 1) WHERE s0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND s0_.active = 1 ORDER BY s0_.name ASC, s1_.sort_order ASC;
13	1.05 ms	SELECT p0_.name AS name_0, p0_.instructions AS instructions_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.domain_id AS domain_id_6, p0_.payment_gateway_id AS payment_gateway_id_7, p0_.type_id AS type_id_8 FROM payment_methods p0_ LEFT JOIN payment_method_types p1_ ON p0_.type_id = p1_.id WHERE p0_.domain_id = ? AND p0_.active = ? AND (p1_.id IS NULL OR (p1_.active = ? AND p1_.usable_in_appointments = ?)) Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1 1 1`] View formatted query View runnable query Explain query SELECT p0_.name AS name_0, p0_.instructions AS instructions_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.domain_id AS domain_id_6, p0_.payment_gateway_id AS payment_gateway_id_7, p0_.type_id AS type_id_8 FROM payment_methods p0_ LEFT JOIN payment_method_types p1_ ON p0_.type_id = p1_.id WHERE p0_.domain_id = ? AND p0_.active = ? AND ( p1_.id IS NULL OR ( p1_.active = ? AND p1_.usable_in_appointments = ? ) ) SELECT p0_.name AS name_0, p0_.instructions AS instructions_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.domain_id AS domain_id_6, p0_.payment_gateway_id AS payment_gateway_id_7, p0_.type_id AS type_id_8 FROM payment_methods p0_ LEFT JOIN payment_method_types p1_ ON p0_.type_id = p1_.id WHERE p0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND p0_.active = 1 AND (p1_.id IS NULL OR (p1_.active = 1 AND p1_.usable_in_appointments = 1));
14	0.71 ms	SELECT c0_.id AS id_0 FROM countries_payment_method_types c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ? Parameters: [`b"\x01¡±Ç\x13PpÈ˜+)ì\t.ã" 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM countries_payment_method_types c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM countries_payment_method_types c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_method_type_id = 0x01A1B1C7135070C8982B29EC092E81E3 AND c1_.active = 1;
15	0.65 ms	SELECT r0_.id AS id_0 FROM regions_payment_method_types r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_method_type_id = ? AND r1_.active = ? Parameters: [`b"\x01¡±Ç\x13PpÈ˜+)ì\t.ã" 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0 FROM regions_payment_method_types r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_method_type_id = ? AND r1_.active = ? SELECT r0_.id AS id_0 FROM regions_payment_method_types r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_method_type_id = 0x01A1B1C7135070C8982B29EC092E81E3 AND r1_.active = 1;
16	0.76 ms	SELECT c0_.id AS id_0 FROM cities_payment_method_types c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ? Parameters: [`b"\x01¡±Ç\x13PpÈ˜+)ì\t.ã" 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM cities_payment_method_types c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM cities_payment_method_types c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_method_type_id = 0x01A1B1C7135070C8982B29EC092E81E3 AND c1_.active = 1;
17	0.73 ms	SELECT c0_.id AS id_0 FROM countries_payment_methods c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ? Parameters: [`b"\x01¡±Ç\x13Pzô˜+)ì\tó\x1Eò" 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM countries_payment_methods c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM countries_payment_methods c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_methods_id = 0x01A1B1C713507AF4982B29EC09F31EF2 AND c1_.active = 1;
18	0.72 ms	SELECT r0_.id AS id_0 FROM regions_payment_methods r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_methods_id = ? AND r1_.active = ? Parameters: [`b"\x01¡±Ç\x13Pzô˜+)ì\tó\x1Eò" 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0 FROM regions_payment_methods r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_methods_id = ? AND r1_.active = ? SELECT r0_.id AS id_0 FROM regions_payment_methods r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_methods_id = 0x01A1B1C713507AF4982B29EC09F31EF2 AND r1_.active = 1;
19	0.70 ms	SELECT c0_.id AS id_0 FROM cities_payment_methods c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ? Parameters: [`b"\x01¡±Ç\x13Pzô˜+)ì\tó\x1Eò" 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM cities_payment_methods c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM cities_payment_methods c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_methods_id = 0x01A1B1C713507AF4982B29EC09F31EF2 AND c1_.active = 1;
20	0.39 ms	SELECT c0_.id AS id_0 FROM countries_payment_method_types c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ? Parameters: [`b"\x01¡±Ç\x13O\x7FŽ»©ï\v„åTò" 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM countries_payment_method_types c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM countries_payment_method_types c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_method_type_id = 0x01A1B1C7134F7F8EBBA9EF0B84E554F2 AND c1_.active = 1;
21	0.39 ms	SELECT r0_.id AS id_0 FROM regions_payment_method_types r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_method_type_id = ? AND r1_.active = ? Parameters: [`b"\x01¡±Ç\x13O\x7FŽ»©ï\v„åTò" 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0 FROM regions_payment_method_types r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_method_type_id = ? AND r1_.active = ? SELECT r0_.id AS id_0 FROM regions_payment_method_types r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_method_type_id = 0x01A1B1C7134F7F8EBBA9EF0B84E554F2 AND r1_.active = 1;
22	0.30 ms	SELECT c0_.id AS id_0 FROM cities_payment_method_types c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ? Parameters: [`b"\x01¡±Ç\x13O\x7FŽ»©ï\v„åTò" 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM cities_payment_method_types c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM cities_payment_method_types c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_method_type_id = 0x01A1B1C7134F7F8EBBA9EF0B84E554F2 AND c1_.active = 1;
23	0.28 ms	SELECT c0_.id AS id_0 FROM countries_payment_methods c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ? Parameters: [`b""" \x01¡±Ç\x13P{¬˜+)ì\n _«î """ 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM countries_payment_methods c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM countries_payment_methods c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_methods_id = 0x01A1B1C713507BAC982B29EC0A5FABEE AND c1_.active = 1;
24	0.38 ms	SELECT r0_.id AS id_0 FROM regions_payment_methods r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_methods_id = ? AND r1_.active = ? Parameters: [`b""" \x01¡±Ç\x13P{¬˜+)ì\n _«î """ 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0 FROM regions_payment_methods r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_methods_id = ? AND r1_.active = ? SELECT r0_.id AS id_0 FROM regions_payment_methods r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_methods_id = 0x01A1B1C713507BAC982B29EC0A5FABEE AND r1_.active = 1;
25	0.34 ms	SELECT c0_.id AS id_0 FROM cities_payment_methods c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ? Parameters: [`b""" \x01¡±Ç\x13P{¬˜+)ì\n _«î """ 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM cities_payment_methods c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM cities_payment_methods c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_methods_id = 0x01A1B1C713507BAC982B29EC0A5FABEE AND c1_.active = 1;
26	0.34 ms	SELECT c0_.id AS id_0 FROM countries_payment_method_types c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ? Parameters: [`b"\x01¡±Ç\x13PpT˜+)ì\x08?®I" 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM countries_payment_method_types c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM countries_payment_method_types c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_method_type_id = 0x01A1B1C713507054982B29EC083FAE49 AND c1_.active = 1;
27	0.32 ms	SELECT r0_.id AS id_0 FROM regions_payment_method_types r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_method_type_id = ? AND r1_.active = ? Parameters: [`b"\x01¡±Ç\x13PpT˜+)ì\x08?®I" 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0 FROM regions_payment_method_types r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_method_type_id = ? AND r1_.active = ? SELECT r0_.id AS id_0 FROM regions_payment_method_types r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_method_type_id = 0x01A1B1C713507054982B29EC083FAE49 AND r1_.active = 1;
28	0.37 ms	SELECT c0_.id AS id_0 FROM cities_payment_method_types c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ? Parameters: [`b"\x01¡±Ç\x13PpT˜+)ì\x08?®I" 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM cities_payment_method_types c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_method_type_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM cities_payment_method_types c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_method_type_id = 0x01A1B1C713507054982B29EC083FAE49 AND c1_.active = 1;
29	0.33 ms	SELECT c0_.id AS id_0 FROM countries_payment_methods c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ? Parameters: [`b"\x01¡±Ç\x13P{ð˜+)ì\v:7G" 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM countries_payment_methods c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM countries_payment_methods c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.payment_methods_id = 0x01A1B1C713507BF0982B29EC0B3A3747 AND c1_.active = 1;
30	0.25 ms	SELECT r0_.id AS id_0 FROM regions_payment_methods r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_methods_id = ? AND r1_.active = ? Parameters: [`b"\x01¡±Ç\x13P{ð˜+)ì\v:7G" 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0 FROM regions_payment_methods r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_methods_id = ? AND r1_.active = ? SELECT r0_.id AS id_0 FROM regions_payment_methods r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.payment_methods_id = 0x01A1B1C713507BF0982B29EC0B3A3747 AND r1_.active = 1;
31	0.27 ms	SELECT c0_.id AS id_0 FROM cities_payment_methods c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ? Parameters: [`b"\x01¡±Ç\x13P{ð˜+)ì\v:7G" 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM cities_payment_methods c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_methods_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM cities_payment_methods c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.payment_methods_id = 0x01A1B1C713507BF0982B29EC0B3A3747 AND c1_.active = 1;
32	0.49 ms	SELECT p0_.name AS name_0, p0_.instructions AS instructions_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.domain_id AS domain_id_6, p0_.payment_gateway_id AS payment_gateway_id_7, p0_.type_id AS type_id_8 FROM payment_methods p0_ LEFT JOIN payment_method_types p1_ ON p0_.type_id = p1_.id WHERE p0_.domain_id = ? AND p0_.active = ? AND (p1_.id IS NULL OR (p1_.active = ? AND p1_.usable_in_appointments = ?)) Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1 1 1`] View formatted query View runnable query Explain query SELECT p0_.name AS name_0, p0_.instructions AS instructions_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.domain_id AS domain_id_6, p0_.payment_gateway_id AS payment_gateway_id_7, p0_.type_id AS type_id_8 FROM payment_methods p0_ LEFT JOIN payment_method_types p1_ ON p0_.type_id = p1_.id WHERE p0_.domain_id = ? AND p0_.active = ? AND ( p1_.id IS NULL OR ( p1_.active = ? AND p1_.usable_in_appointments = ? ) ) SELECT p0_.name AS name_0, p0_.instructions AS instructions_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.domain_id AS domain_id_6, p0_.payment_gateway_id AS payment_gateway_id_7, p0_.type_id AS type_id_8 FROM payment_methods p0_ LEFT JOIN payment_method_types p1_ ON p0_.type_id = p1_.id WHERE p0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND p0_.active = 1 AND (p1_.id IS NULL OR (p1_.active = 1 AND p1_.usable_in_appointments = 1));
33	0.28 ms	SELECT t0.code AS code_1, t0.kind AS kind_2, t0.usable_in_products AS usable_in_products_3, t0.usable_in_appointments AS usable_in_appointments_4, t0.id AS id_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_method_types t0 WHERE t0.id = ? Parameters: [`b"\x01¡±Ç\x13PpÈ˜+)ì\t.ã"`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.kind AS kind_2, t0.usable_in_products AS usable_in_products_3, t0.usable_in_appointments AS usable_in_appointments_4, t0.id AS id_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_method_types t0 WHERE t0.id = ? SELECT t0.code AS code_1, t0.kind AS kind_2, t0.usable_in_products AS usable_in_products_3, t0.usable_in_appointments AS usable_in_appointments_4, t0.id AS id_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_method_types t0 WHERE t0.id = 0x01A1B1C7135070C8982B29EC092E81E3;
34	0.18 ms	SELECT t0.code AS code_1, t0.kind AS kind_2, t0.usable_in_products AS usable_in_products_3, t0.usable_in_appointments AS usable_in_appointments_4, t0.id AS id_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_method_types t0 WHERE t0.id = ? Parameters: [`b"\x01¡±Ç\x13O\x7FŽ»©ï\v„åTò"`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.kind AS kind_2, t0.usable_in_products AS usable_in_products_3, t0.usable_in_appointments AS usable_in_appointments_4, t0.id AS id_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_method_types t0 WHERE t0.id = ? SELECT t0.code AS code_1, t0.kind AS kind_2, t0.usable_in_products AS usable_in_products_3, t0.usable_in_appointments AS usable_in_appointments_4, t0.id AS id_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_method_types t0 WHERE t0.id = 0x01A1B1C7134F7F8EBBA9EF0B84E554F2;
35	0.16 ms	SELECT t0.code AS code_1, t0.kind AS kind_2, t0.usable_in_products AS usable_in_products_3, t0.usable_in_appointments AS usable_in_appointments_4, t0.id AS id_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_method_types t0 WHERE t0.id = ? Parameters: [`b"\x01¡±Ç\x13PpT˜+)ì\x08?®I"`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.kind AS kind_2, t0.usable_in_products AS usable_in_products_3, t0.usable_in_appointments AS usable_in_appointments_4, t0.id AS id_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_method_types t0 WHERE t0.id = ? SELECT t0.code AS code_1, t0.kind AS kind_2, t0.usable_in_products AS usable_in_products_3, t0.usable_in_appointments AS usable_in_appointments_4, t0.id AS id_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM payment_method_types t0 WHERE t0.id = 0x01A1B1C713507054982B29EC083FAE49;
36	0.81 ms	SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, l1_.code AS code_6, l1_.name AS name_7, l1_.flag AS flag_8, l1_.is_default AS is_default_9, l1_.position AS position_10, l1_.id AS id_11, l1_.active AS active_12, l1_.created_at AS created_at_13, l1_.updated_at AS updated_at_14, p0_.payment_method_type_id AS payment_method_type_id_15, p0_.language_id AS language_id_16 FROM payment_method_type_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.payment_method_type_id IN (?, ?) AND p0_.active = ? AND l1_.active = ? Parameters: [`b"\x01¡±Ç\x13O\x7FŽ»©ï\v„åTò" b"\x01¡±Ç\x13PpT˜+)ì\x08?®I" 1 1`] View formatted query View runnable query Explain query SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, l1_.code AS code_6, l1_.name AS name_7, l1_.flag AS flag_8, l1_.is_default AS is_default_9, l1_.position AS position_10, l1_.id AS id_11, l1_.active AS active_12, l1_.created_at AS created_at_13, l1_.updated_at AS updated_at_14, p0_.payment_method_type_id AS payment_method_type_id_15, p0_.language_id AS language_id_16 FROM payment_method_type_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.payment_method_type_id IN (?, ?) AND p0_.active = ? AND l1_.active = ? SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, l1_.code AS code_6, l1_.name AS name_7, l1_.flag AS flag_8, l1_.is_default AS is_default_9, l1_.position AS position_10, l1_.id AS id_11, l1_.active AS active_12, l1_.created_at AS created_at_13, l1_.updated_at AS updated_at_14, p0_.payment_method_type_id AS payment_method_type_id_15, p0_.language_id AS language_id_16 FROM payment_method_type_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.payment_method_type_id IN (0x01A1B1C7134F7F8EBBA9EF0B84E554F2, 0x01A1B1C713507054982B29EC083FAE49) AND p0_.active = 1 AND l1_.active = 1;
37	0.34 ms	SELECT l0_.code AS code_0, l0_.name AS name_1, l0_.flag AS flag_2, l0_.is_default AS is_default_3, l0_.position AS position_4, l0_.id AS id_5, l0_.active AS active_6, l0_.created_at AS created_at_7, l0_.updated_at AS updated_at_8 FROM languages l0_ WHERE l0_.active = ? ORDER BY l0_.position ASC, l0_.name ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT l0_.code AS code_0, l0_.name AS name_1, l0_.flag AS flag_2, l0_.is_default AS is_default_3, l0_.position AS position_4, l0_.id AS id_5, l0_.active AS active_6, l0_.created_at AS created_at_7, l0_.updated_at AS updated_at_8 FROM languages l0_ WHERE l0_.active = ? ORDER BY l0_.position ASC, l0_.name ASC SELECT l0_.code AS code_0, l0_.name AS name_1, l0_.flag AS flag_2, l0_.is_default AS is_default_3, l0_.position AS position_4, l0_.id AS id_5, l0_.active AS active_6, l0_.created_at AS created_at_7, l0_.updated_at AS updated_at_8 FROM languages l0_ WHERE l0_.active = 1 ORDER BY l0_.position ASC, l0_.name ASC;
38	0.32 ms	SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, l1_.code AS code_6, l1_.name AS name_7, l1_.flag AS flag_8, l1_.is_default AS is_default_9, l1_.position AS position_10, l1_.id AS id_11, l1_.active AS active_12, l1_.created_at AS created_at_13, l1_.updated_at AS updated_at_14, p0_.payment_method_type_id AS payment_method_type_id_15, p0_.language_id AS language_id_16 FROM payment_method_type_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.payment_method_type_id IN (?, ?) AND p0_.active = ? AND l1_.active = ? Parameters: [`b"\x01¡±Ç\x13O\x7FŽ»©ï\v„åTò" b"\x01¡±Ç\x13PpT˜+)ì\x08?®I" 1 1`] View formatted query View runnable query Explain query SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, l1_.code AS code_6, l1_.name AS name_7, l1_.flag AS flag_8, l1_.is_default AS is_default_9, l1_.position AS position_10, l1_.id AS id_11, l1_.active AS active_12, l1_.created_at AS created_at_13, l1_.updated_at AS updated_at_14, p0_.payment_method_type_id AS payment_method_type_id_15, p0_.language_id AS language_id_16 FROM payment_method_type_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.payment_method_type_id IN (?, ?) AND p0_.active = ? AND l1_.active = ? SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.id AS id_2, p0_.active AS active_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, l1_.code AS code_6, l1_.name AS name_7, l1_.flag AS flag_8, l1_.is_default AS is_default_9, l1_.position AS position_10, l1_.id AS id_11, l1_.active AS active_12, l1_.created_at AS created_at_13, l1_.updated_at AS updated_at_14, p0_.payment_method_type_id AS payment_method_type_id_15, p0_.language_id AS language_id_16 FROM payment_method_type_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.payment_method_type_id IN (0x01A1B1C7134F7F8EBBA9EF0B84E554F2, 0x01A1B1C713507054982B29EC083FAE49) AND p0_.active = 1 AND l1_.active = 1;
39	0.28 ms	SELECT l0_.code AS code_0, l0_.name AS name_1, l0_.flag AS flag_2, l0_.is_default AS is_default_3, l0_.position AS position_4, l0_.id AS id_5, l0_.active AS active_6, l0_.created_at AS created_at_7, l0_.updated_at AS updated_at_8 FROM languages l0_ WHERE l0_.active = ? ORDER BY l0_.position ASC, l0_.name ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT l0_.code AS code_0, l0_.name AS name_1, l0_.flag AS flag_2, l0_.is_default AS is_default_3, l0_.position AS position_4, l0_.id AS id_5, l0_.active AS active_6, l0_.created_at AS created_at_7, l0_.updated_at AS updated_at_8 FROM languages l0_ WHERE l0_.active = ? ORDER BY l0_.position ASC, l0_.name ASC SELECT l0_.code AS code_0, l0_.name AS name_1, l0_.flag AS flag_2, l0_.is_default AS is_default_3, l0_.position AS position_4, l0_.id AS id_5, l0_.active AS active_6, l0_.created_at AS created_at_7, l0_.updated_at AS updated_at_8 FROM languages l0_ WHERE l0_.active = 1 ORDER BY l0_.position ASC, l0_.name ASC;
40	1.57 ms	SELECT p0_.name AS name_0, p0_.bio AS bio_1, p0_.photo_url AS photo_url_2, p0_.id AS id_3, p0_.active AS active_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p1_.image_path AS image_path_7, p1_.image_url AS image_url_8, p1_.alt_text AS alt_text_9, p1_.sort_order AS sort_order_10, p1_.id AS id_11, p1_.active AS active_12, p1_.created_at AS created_at_13, p1_.updated_at AS updated_at_14, p0_.domain_id AS domain_id_15, p0_.user_id AS user_id_16, p0_.location_id AS location_id_17, p1_.professional_id AS professional_id_18 FROM professionals p0_ LEFT JOIN professional_images p1_ ON p0_.id = p1_.professional_id AND (p1_.active = ?) WHERE p0_.domain_id = ? AND p0_.active = ? ORDER BY p0_.name ASC, p1_.sort_order ASC Parameters: [`1 b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1`] View formatted query View runnable query Explain query SELECT p0_.name AS name_0, p0_.bio AS bio_1, p0_.photo_url AS photo_url_2, p0_.id AS id_3, p0_.active AS active_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p1_.image_path AS image_path_7, p1_.image_url AS image_url_8, p1_.alt_text AS alt_text_9, p1_.sort_order AS sort_order_10, p1_.id AS id_11, p1_.active AS active_12, p1_.created_at AS created_at_13, p1_.updated_at AS updated_at_14, p0_.domain_id AS domain_id_15, p0_.user_id AS user_id_16, p0_.location_id AS location_id_17, p1_.professional_id AS professional_id_18 FROM professionals p0_ LEFT JOIN professional_images p1_ ON p0_.id = p1_.professional_id AND (p1_.active = ?) WHERE p0_.domain_id = ? AND p0_.active = ? ORDER BY p0_.name ASC, p1_.sort_order ASC SELECT p0_.name AS name_0, p0_.bio AS bio_1, p0_.photo_url AS photo_url_2, p0_.id AS id_3, p0_.active AS active_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p1_.image_path AS image_path_7, p1_.image_url AS image_url_8, p1_.alt_text AS alt_text_9, p1_.sort_order AS sort_order_10, p1_.id AS id_11, p1_.active AS active_12, p1_.created_at AS created_at_13, p1_.updated_at AS updated_at_14, p0_.domain_id AS domain_id_15, p0_.user_id AS user_id_16, p0_.location_id AS location_id_17, p1_.professional_id AS professional_id_18 FROM professionals p0_ LEFT JOIN professional_images p1_ ON p0_.id = p1_.professional_id AND (p1_.active = 1) WHERE p0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND p0_.active = 1 ORDER BY p0_.name ASC, p1_.sort_order ASC;
41	0.59 ms	SELECT p0_.id AS id_0, l1_.id AS id_1 FROM professionals p0_ INNER JOIN locations l1_ ON p0_.location_id = l1_.id WHERE p0_.domain_id = ? AND p0_.active = ? Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, l1_.id AS id_1 FROM professionals p0_ INNER JOIN locations l1_ ON p0_.location_id = l1_.id WHERE p0_.domain_id = ? AND p0_.active = ? SELECT p0_.id AS id_0, l1_.id AS id_1 FROM professionals p0_ INNER JOIN locations l1_ ON p0_.location_id = l1_.id WHERE p0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND p0_.active = 1;
42	0.70 ms	SELECT s0_.id AS id_0, p1_.id AS id_1 FROM professionals_services p2_ INNER JOIN professionals p1_ ON p2_.professional_id = p1_.id INNER JOIN services s0_ ON p2_.service_id = s0_.id WHERE p1_.domain_id = ? AND p2_.active = ? AND p1_.active = ? Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1 1`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, p1_.id AS id_1 FROM professionals_services p2_ INNER JOIN professionals p1_ ON p2_.professional_id = p1_.id INNER JOIN services s0_ ON p2_.service_id = s0_.id WHERE p1_.domain_id = ? AND p2_.active = ? AND p1_.active = ? SELECT s0_.id AS id_0, p1_.id AS id_1 FROM professionals_services p2_ INNER JOIN professionals p1_ ON p2_.professional_id = p1_.id INNER JOIN services s0_ ON p2_.service_id = s0_.id WHERE p1_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND p2_.active = 1 AND p1_.active = 1;
43	0.48 ms	SELECT t0.name AS name_1, t0.description AS description_2, t0.iso_code AS iso_code_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.currency_id AS currency_id_8 FROM countries t0 WHERE t0.id = ? Parameters: [`b"\x01¡±Ç\v$q?ž\x01\e;)í?Ç"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.description AS description_2, t0.iso_code AS iso_code_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.currency_id AS currency_id_8 FROM countries t0 WHERE t0.id = ? SELECT t0.name AS name_1, t0.description AS description_2, t0.iso_code AS iso_code_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.currency_id AS currency_id_8 FROM countries t0 WHERE t0.id = 0x01A1B1C70B24713F9E011B3B29ED3FC7;
44	0.46 ms	SELECT d0_.id AS id_0, d0_.active AS active_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3, d0_.domain_id AS domain_id_4, d0_.module_feature_id AS module_feature_id_5 FROM domain_module_features d0_ INNER JOIN module_features m1_ ON d0_.module_feature_id = m1_.id WHERE d0_.domain_id = ? AND m1_.slug = ? Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" "appointments_music_genres"`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.active AS active_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3, d0_.domain_id AS domain_id_4, d0_.module_feature_id AS module_feature_id_5 FROM domain_module_features d0_ INNER JOIN module_features m1_ ON d0_.module_feature_id = m1_.id WHERE d0_.domain_id = ? AND m1_.slug = ? SELECT d0_.id AS id_0, d0_.active AS active_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3, d0_.domain_id AS domain_id_4, d0_.module_feature_id AS module_feature_id_5 FROM domain_module_features d0_ INNER JOIN module_features m1_ ON d0_.module_feature_id = m1_.id WHERE d0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND m1_.slug = 'appointments_music_genres';
45	0.65 ms	SELECT m0_.name AS name_0, m0_.sort_order AS sort_order_1, m0_.id AS id_2, m0_.active AS active_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.domain_id AS domain_id_6 FROM music_genres m0_ WHERE m0_.domain_id = ? AND m0_.active = ? ORDER BY m0_.sort_order ASC, m0_.name ASC Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1`] View formatted query View runnable query Explain query SELECT m0_.name AS name_0, m0_.sort_order AS sort_order_1, m0_.id AS id_2, m0_.active AS active_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.domain_id AS domain_id_6 FROM music_genres m0_ WHERE m0_.domain_id = ? AND m0_.active = ? ORDER BY m0_.sort_order ASC, m0_.name ASC SELECT m0_.name AS name_0, m0_.sort_order AS sort_order_1, m0_.id AS id_2, m0_.active AS active_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.domain_id AS domain_id_6 FROM music_genres m0_ WHERE m0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND m0_.active = 1 ORDER BY m0_.sort_order ASC, m0_.name ASC;
46	0.62 ms	SELECT t0.money_per_point AS money_per_point_1, t0.point_value AS point_value_2, t0.min_points_to_redeem AS min_points_to_redeem_3, t0.max_redeem_percent AS max_redeem_percent_4, t0.expiration_days AS expiration_days_5, t0.id AS id_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.domain_id AS domain_id_10 FROM point_conditions t0 WHERE t0.domain_id = ? AND t0.active = ? ORDER BY t0.created_at ASC Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1`] View formatted query View runnable query Explain query SELECT t0.money_per_point AS money_per_point_1, t0.point_value AS point_value_2, t0.min_points_to_redeem AS min_points_to_redeem_3, t0.max_redeem_percent AS max_redeem_percent_4, t0.expiration_days AS expiration_days_5, t0.id AS id_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.domain_id AS domain_id_10 FROM point_conditions t0 WHERE t0.domain_id = ? AND t0.active = ? ORDER BY t0.created_at ASC SELECT t0.money_per_point AS money_per_point_1, t0.point_value AS point_value_2, t0.min_points_to_redeem AS min_points_to_redeem_3, t0.max_redeem_percent AS max_redeem_percent_4, t0.expiration_days AS expiration_days_5, t0.id AS id_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.domain_id AS domain_id_10 FROM point_conditions t0 WHERE t0.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND t0.active = 1 ORDER BY t0.created_at ASC;
47	0.48 ms	SELECT c0_.code AS code_0 FROM domain_allowed_currencies d1_ INNER JOIN currencies c0_ ON d1_.currency_id = c0_.id WHERE d1_.domain_id = ? AND d1_.active = 1 AND c0_.active = 1 ORDER BY c0_.code ASC Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á"`] View formatted query View runnable query Explain query SELECT c0_.code AS code_0 FROM domain_allowed_currencies d1_ INNER JOIN currencies c0_ ON d1_.currency_id = c0_.id WHERE d1_.domain_id = ? AND d1_.active = 1 AND c0_.active = 1 ORDER BY c0_.code ASC SELECT c0_.code AS code_0 FROM domain_allowed_currencies d1_ INNER JOIN currencies c0_ ON d1_.currency_id = c0_.id WHERE d1_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND d1_.active = 1 AND c0_.active = 1 ORDER BY c0_.code ASC;
48	0.31 ms	SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.active = ? ORDER BY t0.code ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.active = ? ORDER BY t0.code ASC SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.active = 1 ORDER BY t0.code ASC;
49	0.34 ms	SELECT c0_.code AS code_0 FROM domain_allowed_currencies d1_ INNER JOIN currencies c0_ ON d1_.currency_id = c0_.id WHERE d1_.domain_id = ? AND d1_.active = 1 AND c0_.active = 1 ORDER BY c0_.code ASC Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á"`] View formatted query View runnable query Explain query SELECT c0_.code AS code_0 FROM domain_allowed_currencies d1_ INNER JOIN currencies c0_ ON d1_.currency_id = c0_.id WHERE d1_.domain_id = ? AND d1_.active = 1 AND c0_.active = 1 ORDER BY c0_.code ASC SELECT c0_.code AS code_0 FROM domain_allowed_currencies d1_ INNER JOIN currencies c0_ ON d1_.currency_id = c0_.id WHERE d1_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND d1_.active = 1 AND c0_.active = 1 ORDER BY c0_.code ASC;
50	0.29 ms	SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1 Parameters: [`"USD" 1`] View formatted query View runnable query Explain query SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.code = ? AND t0.active = ? LIMIT 1 SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.decimal_places AS decimal_places_4, t0.thousands_separator AS thousands_separator_5, t0.decimal_separator AS decimal_separator_6, t0.id AS id_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM currencies t0 WHERE t0.code = 'USD' AND t0.active = 1 LIMIT 1;
51	0.65 ms	SELECT t0.names AS names_1, t0.description AS description_2, t0.name AS name_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? Parameters: [`b"\x01¡±Ç\v%q±¦\x11%Ù'†«Ÿ"`] View formatted query View runnable query Explain query SELECT t0.names AS names_1, t0.description AS description_2, t0.name AS name_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = ? SELECT t0.names AS names_1, t0.description AS description_2, t0.name AS name_3, t0.id AS id_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.region_id AS region_id_8 FROM cities t0 WHERE t0.id = 0x01A1B1C70B2571B1A61125D92786AB9F;
52	0.45 ms	SELECT t0.money_per_point AS money_per_point_1, t0.point_value AS point_value_2, t0.min_points_to_redeem AS min_points_to_redeem_3, t0.max_redeem_percent AS max_redeem_percent_4, t0.expiration_days AS expiration_days_5, t0.id AS id_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.domain_id AS domain_id_10 FROM point_conditions t0 WHERE t0.domain_id = ? AND t0.active = ? ORDER BY t0.created_at ASC Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1`] View formatted query View runnable query Explain query SELECT t0.money_per_point AS money_per_point_1, t0.point_value AS point_value_2, t0.min_points_to_redeem AS min_points_to_redeem_3, t0.max_redeem_percent AS max_redeem_percent_4, t0.expiration_days AS expiration_days_5, t0.id AS id_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.domain_id AS domain_id_10 FROM point_conditions t0 WHERE t0.domain_id = ? AND t0.active = ? ORDER BY t0.created_at ASC SELECT t0.money_per_point AS money_per_point_1, t0.point_value AS point_value_2, t0.min_points_to_redeem AS min_points_to_redeem_3, t0.max_redeem_percent AS max_redeem_percent_4, t0.expiration_days AS expiration_days_5, t0.id AS id_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.domain_id AS domain_id_10 FROM point_conditions t0 WHERE t0.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND t0.active = 1 ORDER BY t0.created_at ASC;

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\Appointments\Availability\AvailabilityRules	6
App\Entity\Tenants\Domains\PaymentMethodTypeTranslations	4
App\Entity\Tenants\Domains\PaymentMethods	3
App\Entity\Tenants\Domains\PaymentMethodTypes	3
App\Entity\Tenants\Languages\Languages	3
App\Entity\Configurations\Globals\Countries	2
App\Entity\Tenants\Currencies\Currencies	2
App\Entity\Appointments\Locations\Locations	2
App\Entity\Appointments\Services\Services	2
App\Entity\Appointments\Services\ServiceImages	2
App\Entity\Appointments\Professionals\Professionals	2
App\Entity\Appointments\Music\MusicGenres	2
App\Entity\Tenants\Domains\Domains	1
App\Entity\Tenants\Tenants	1
App\Entity\Configurations\Globals\Regions	1
App\Entity\Configurations\Globals\Cities	1
App\Entity\Appointments\Locations\LocationImages	1
App\Entity\Appointments\Professionals\ProfessionalImages	1
App\Entity\Tenants\Modules\DomainModuleFeatures	1
App\Entity\Tenants\Modules\ModuleFeatures	1

Entities Mapping

Class	Mapping errors
App\Entity\Configurations\Globals\Countries	No errors.
App\Entity\Tenants\Currencies\Currencies	No errors.
App\Entity\Tenants\Modules\ModuleConditions	No errors.
App\Entity\Configurations\Globals\Regions	No errors.
App\Entity\Tenants\Domains\Domains	No errors.
App\Entity\Tenants\Tenants	No errors.
App\Entity\Tenants\Others\Seo	No errors.
App\Entity\Tenants\Others\SeoPage	No errors.
App\Entity\Appointments\Locations\Locations	No errors.
App\Entity\Appointments\Locations\LocationImages	No errors.
App\Entity\Configurations\Globals\Cities	No errors.
App\Entity\Appointments\Availability\AvailabilityRules	No errors.
App\Entity\Appointments\Professionals\Professionals	No errors.
App\Entity\Tenants\Currencies\DomainAllowedCurrencies	No errors.
App\Entity\Appointments\Services\Services	No errors.
App\Entity\Appointments\Services\ServiceImages	No errors.
App\Entity\Tenants\Domains\PaymentMethods	No errors.
App\Entity\Tenants\Domains\PaymentMethodTypes	No errors.
App\Entity\Tenants\Domains\PaymentGateways	No errors.
App\Entity\Configurations\Countries\CountriesPaymentMethodTypes	No errors.
App\Entity\Configurations\Regions\RegionsPaymentMethodTypes	No errors.
App\Entity\Configurations\Cities\CitiesPaymentMethodTypes	No errors.
App\Entity\Configurations\Countries\CountriesPaymentMethods	No errors.
App\Entity\Configurations\Regions\RegionsPaymentMethods	No errors.
App\Entity\Configurations\Cities\CitiesPaymentMethods	No errors.
App\Entity\Tenants\Domains\PaymentMethodTypeTranslations	No errors.
App\Entity\Tenants\Languages\Languages	No errors.
App\Entity\Appointments\Professionals\ProfessionalImages	No errors.
App\Entity\Users\Users	No errors.
App\Entity\Appointments\Services\ProfessionalsServices	No errors.
App\Entity\Tenants\Modules\DomainModuleFeatures	No errors.
App\Entity\Tenants\Modules\ModuleFeatures	No errors.
App\Entity\Appointments\Music\MusicGenres	No errors.
App\Entity\Tenants\Domains\PointConditions	No errors.

GET https://thorha.com/es/appointments

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping