Symfony Profiler

Query Metrics

49 Database Queries

28 Different statements

28.40 ms Query time

0 Invalid entities

73 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 t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.release_status AS release_status_4, t0.admin_toggleable AS admin_toggleable_5, t0.addon_price AS addon_price_6, t0.addon_period AS addon_period_7, t0.id AS id_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM modules t0
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.release_status AS release_status_4, t0.admin_toggleable AS admin_toggleable_5, t0.addon_price AS addon_price_6, t0.addon_period AS addon_period_7, t0.id AS id_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.module_id AS module_id_12 FROM module_features t0
SELECT m0_.slug AS slug_0, m1_.slug AS slug_1 FROM module_feature_requirements m2_ INNER JOIN module_features m0_ ON m2_.feature_id = m0_.id INNER JOIN module_features m1_ ON m2_.required_feature_id = m1_.id WHERE m2_.active = ? AND m0_.active = ? AND m1_.active = ?
SELECT t0.domain AS domain_1, t0.name AS name_2, t0.logo AS logo_3, t0.notification_email AS notification_email_4, t0.support_email AS support_email_5, t0.facebook_url AS facebook_url_6, t0.instagram_url AS instagram_url_7, t0.pinterest_url AS pinterest_url_8, t0.timezone AS timezone_9, t0.min_cancellation_notice_minutes AS min_cancellation_notice_minutes_10, t0.appointments_allow_online_payment AS appointments_allow_online_payment_11, t0.appointments_max_advance_days AS appointments_max_advance_days_12, t0.currency_mode AS currency_mode_13, t0.appointments_allow_pay_at_business AS appointments_allow_pay_at_business_14, t0.maintenance_mode AS maintenance_mode_15, t0.maintenance_message AS maintenance_message_16, t0.chat_enabled AS chat_enabled_17, t0.reviews_require_approval AS reviews_require_approval_18, t0.review_request_enabled AS review_request_enabled_19, t0.review_request_delay_days AS review_request_delay_days_20, t0.home_products_strategy AS home_products_strategy_21, t0.appointments_music_enabled AS appointments_music_enabled_22, t0.appointments_points_enabled AS appointments_points_enabled_23, t0.membership_points_enabled AS membership_points_enabled_24, t0.membership_points_per_checkin AS membership_points_per_checkin_25, t0.membership_points_per_class AS membership_points_per_class_26, t0.test_domain AS test_domain_27, t0.home_sections AS home_sections_28, t0.id AS id_29, t0.active AS active_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.tenant_id AS tenant_id_33 FROM domains t0 WHERE t0.test_domain = ? AND t0.active = ?
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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_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 = ? 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 = ? AND m1_.slug = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.public_price AS public_price_3, p0_.stock AS stock_4, MIN(i1_.image) AS sclr_5, c2_.code AS code_6, p0_.rating_average AS rating_average_7, p0_.rating_count AS rating_count_8, p0_.featured_rank AS featured_rank_9 FROM products p0_ INNER JOIN domains d3_ ON p0_.domain_id = d3_.id LEFT JOIN currencies c2_ ON p0_.currency_id = c2_.id LEFT JOIN images_products i1_ ON p0_.id = i1_.product_id AND (i1_.active = ?) WHERE d3_.id = ? AND p0_.active = ? AND (p0_.stock IS NULL OR p0_.stock > 0) AND p0_.visibility = ? AND p0_.featured_rank IS NOT NULL GROUP BY p0_.id, p0_.name, p0_.description, p0_.public_price, p0_.stock, c2_.code, p0_.rating_average, p0_.rating_count, p0_.featured_rank, p0_.created_at ORDER BY p0_.featured_rank ASC, p0_.name ASC LIMIT 24
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.public_price AS public_price_3, p0_.stock AS stock_4, MIN(i1_.image) AS sclr_5, c2_.code AS code_6, p0_.rating_average AS rating_average_7, p0_.rating_count AS rating_count_8, p0_.featured_rank AS featured_rank_9 FROM products p0_ INNER JOIN domains d3_ ON p0_.domain_id = d3_.id LEFT JOIN currencies c2_ ON p0_.currency_id = c2_.id LEFT JOIN images_products i1_ ON p0_.id = i1_.product_id AND (i1_.active = ?) WHERE d3_.id = ? AND p0_.active = ? AND (p0_.stock IS NULL OR p0_.stock > 0) AND p0_.visibility = ? AND p0_.featured_rank IS NULL GROUP BY p0_.id, p0_.name, p0_.description, p0_.public_price, p0_.stock, c2_.code, p0_.rating_average, p0_.rating_count, p0_.featured_rank, p0_.created_at ORDER BY p0_.created_at DESC LIMIT 24
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.public_price AS public_price_3, p0_.stock AS stock_4, MIN(i1_.image) AS sclr_5, c2_.code AS code_6, p0_.rating_average AS rating_average_7, p0_.rating_count AS rating_count_8, p0_.featured_rank AS featured_rank_9 FROM products p0_ INNER JOIN domains d3_ ON p0_.domain_id = d3_.id LEFT JOIN currencies c2_ ON p0_.currency_id = c2_.id LEFT JOIN images_products i1_ ON p0_.id = i1_.product_id AND (i1_.active = ?) WHERE d3_.id = ? AND p0_.active = ? AND (p0_.stock IS NULL OR p0_.stock > 0) AND p0_.visibility = ? GROUP BY p0_.id, p0_.name, p0_.description, p0_.public_price, p0_.stock, c2_.code, p0_.rating_average, p0_.rating_count, p0_.featured_rank, p0_.created_at ORDER BY p0_.created_at DESC LIMIT 60
SELECT p0_.id AS id_0, p0_.rating AS rating_1, p0_.title AS title_2, p0_.comment AS comment_3, p0_.created_at AS created_at_4, p0_.verified_purchase AS verified_purchase_5, u1_.name AS name_6, p2_.id AS id_7, p2_.name AS name_8 FROM product_reviews p0_ INNER JOIN users u1_ ON p0_.user_id = u1_.id INNER JOIN products p2_ ON p0_.product_id = p2_.id WHERE p2_.domain_id = ? AND p2_.active = 1 AND p2_.visibility = ? AND p0_.status = ? AND p0_.active = 1 AND p0_.rating >= 4 AND p0_.comment IS NOT NULL ORDER BY p0_.helpful_count DESC, p0_.created_at DESC LIMIT 6
SELECT COUNT(p0_.id) AS sclr_0, AVG(p0_.rating) AS sclr_1 FROM product_reviews p0_ INNER JOIN products p1_ ON p0_.product_id = p1_.id WHERE p1_.domain_id = ? AND p1_.active = 1 AND p0_.status = ? AND p0_.active = 1
SELECT MIN(s0_.free_over) AS sclr_0 FROM shipping_rates s0_ INNER JOIN shipping_methods s1_ ON s0_.method_id = s1_.id WHERE s1_.domain_id = ? AND s1_.active = 1 AND s1_.type = ? AND s0_.active = 1 AND s0_.free_over IS NOT NULL
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 c0_.name AS name_0, c0_.description AS description_1, c0_.id AS id_2, c0_.active AS active_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.domain_id AS domain_id_6 FROM catalogs c0_ INNER JOIN domains d1_ ON c0_.domain_id = d1_.id WHERE d1_.id = ? AND c0_.active = ?
SELECT c0_.id AS id_0 FROM countries_catalogs c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.catalogs_id = ? AND c1_.active = ?
SELECT r0_.id AS id_0 FROM regions_catalogs r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.catalogs_id = ? AND r1_.active = ?
SELECT c0_.id AS id_0 FROM cities_catalogs c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.catalogs_id = ? AND c1_.active = ?
SELECT c0_.id AS id_0 FROM countries_catalogs c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.catalogs_id = ? AND c1_.active = ?
SELECT r0_.id AS id_0 FROM regions_catalogs r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.catalogs_id = ? AND r1_.active = ?
SELECT c0_.id AS id_0 FROM cities_catalogs c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.catalogs_id = ? AND c1_.active = ?
SELECT p0_.id AS id_0 FROM catalogs_products c1_ INNER JOIN catalogs c2_ ON c1_.catalog_id = c2_.id INNER JOIN products p0_ ON c1_.product_id = p0_.id WHERE c2_.id = ? AND c1_.active = ? AND p0_.active = ?
SELECT p0_.id AS id_0 FROM catalogs_products c1_ INNER JOIN catalogs c2_ ON c1_.catalog_id = c2_.id INNER JOIN products p0_ ON c1_.product_id = p0_.id WHERE c2_.id = ? AND c1_.active = ? AND p0_.active = ?
SELECT p0_.id AS id_0, p1_.price AS price_1 FROM products_countries_prices p1_ INNER JOIN products p0_ ON p1_.product_id = p0_.id WHERE p1_.country_id = ? AND p1_.active = 1 AND p0_.active = 1 AND p0_.domain_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 = ?
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 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 p0_.name AS name_0, p0_.description AS description_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.discount_rate AS discount_rate_4, p0_.value_type AS value_type_5, p0_.currency_code AS currency_code_6, p0_.applies_to AS applies_to_7, p0_.priority AS priority_8, p0_.id AS id_9, p0_.active AS active_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.domain_id AS domain_id_13, p0_.discount_type_id AS discount_type_id_14 FROM promotions p0_ WHERE p0_.domain_id = ? AND p0_.active = ? AND p0_.start_date <= ? AND p0_.end_date >= ?
SELECT p0_.product_id AS sclr_0, p0_.name AS name_1, p0_.description AS description_2, p0_.short_description AS short_description_3, p0_.highlights AS highlights_4 FROM product_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.product_id IN (?, ?, ?) AND l1_.code = ? AND p0_.active = ? AND p0_.status = ?
SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.discount_rate AS discount_rate_4, p0_.value_type AS value_type_5, p0_.currency_code AS currency_code_6, p0_.applies_to AS applies_to_7, p0_.priority AS priority_8, p0_.id AS id_9, p0_.active AS active_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.domain_id AS domain_id_13, p0_.discount_type_id AS discount_type_id_14 FROM promotions p0_ WHERE p0_.domain_id = ? AND p0_.active = ? AND p0_.start_date <= ? AND p0_.end_date >= ?
SELECT p0_.product_id AS sclr_0, p0_.name AS name_1, p0_.description AS description_2, p0_.short_description AS short_description_3, p0_.highlights AS highlights_4 FROM product_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.product_id IN (?, ?, ?) AND l1_.code = ? AND p0_.active = ? AND p0_.status = ?
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 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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_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 = ? AND m1_.slug = ?
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 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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_id = m1_.id WHERE d0_.domain_id = ? AND m1_.slug = ?
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.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 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 = ? AND m1_.slug = ?
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.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	0.61 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	0.75 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.57 ms	SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.release_status AS release_status_4, t0.admin_toggleable AS admin_toggleable_5, t0.addon_price AS addon_price_6, t0.addon_period AS addon_period_7, t0.id AS id_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM modules t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.release_status AS release_status_4, t0.admin_toggleable AS admin_toggleable_5, t0.addon_price AS addon_price_6, t0.addon_period AS addon_period_7, t0.id AS id_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM modules t0 SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.release_status AS release_status_4, t0.admin_toggleable AS admin_toggleable_5, t0.addon_price AS addon_price_6, t0.addon_period AS addon_period_7, t0.id AS id_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM modules t0;
4	0.80 ms	SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.release_status AS release_status_4, t0.admin_toggleable AS admin_toggleable_5, t0.addon_price AS addon_price_6, t0.addon_period AS addon_period_7, t0.id AS id_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.module_id AS module_id_12 FROM module_features t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.release_status AS release_status_4, t0.admin_toggleable AS admin_toggleable_5, t0.addon_price AS addon_price_6, t0.addon_period AS addon_period_7, t0.id AS id_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.module_id AS module_id_12 FROM module_features t0 SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.release_status AS release_status_4, t0.admin_toggleable AS admin_toggleable_5, t0.addon_price AS addon_price_6, t0.addon_period AS addon_period_7, t0.id AS id_8, t0.active AS active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.module_id AS module_id_12 FROM module_features t0;
5	0.71 ms	SELECT m0_.slug AS slug_0, m1_.slug AS slug_1 FROM module_feature_requirements m2_ INNER JOIN module_features m0_ ON m2_.feature_id = m0_.id INNER JOIN module_features m1_ ON m2_.required_feature_id = m1_.id WHERE m2_.active = ? AND m0_.active = ? AND m1_.active = ? Parameters: [`1 1 1`] View formatted query View runnable query Explain query SELECT m0_.slug AS slug_0, m1_.slug AS slug_1 FROM module_feature_requirements m2_ INNER JOIN module_features m0_ ON m2_.feature_id = m0_.id INNER JOIN module_features m1_ ON m2_.required_feature_id = m1_.id WHERE m2_.active = ? AND m0_.active = ? AND m1_.active = ? SELECT m0_.slug AS slug_0, m1_.slug AS slug_1 FROM module_feature_requirements m2_ INNER JOIN module_features m0_ ON m2_.feature_id = m0_.id INNER JOIN module_features m1_ ON m2_.required_feature_id = m1_.id WHERE m2_.active = 1 AND m0_.active = 1 AND m1_.active = 1;
6	0.59 ms	SELECT t0.domain AS domain_1, t0.name AS name_2, t0.logo AS logo_3, t0.notification_email AS notification_email_4, t0.support_email AS support_email_5, t0.facebook_url AS facebook_url_6, t0.instagram_url AS instagram_url_7, t0.pinterest_url AS pinterest_url_8, t0.timezone AS timezone_9, t0.min_cancellation_notice_minutes AS min_cancellation_notice_minutes_10, t0.appointments_allow_online_payment AS appointments_allow_online_payment_11, t0.appointments_max_advance_days AS appointments_max_advance_days_12, t0.currency_mode AS currency_mode_13, t0.appointments_allow_pay_at_business AS appointments_allow_pay_at_business_14, t0.maintenance_mode AS maintenance_mode_15, t0.maintenance_message AS maintenance_message_16, t0.chat_enabled AS chat_enabled_17, t0.reviews_require_approval AS reviews_require_approval_18, t0.review_request_enabled AS review_request_enabled_19, t0.review_request_delay_days AS review_request_delay_days_20, t0.home_products_strategy AS home_products_strategy_21, t0.appointments_music_enabled AS appointments_music_enabled_22, t0.appointments_points_enabled AS appointments_points_enabled_23, t0.membership_points_enabled AS membership_points_enabled_24, t0.membership_points_per_checkin AS membership_points_per_checkin_25, t0.membership_points_per_class AS membership_points_per_class_26, t0.test_domain AS test_domain_27, t0.home_sections AS home_sections_28, t0.id AS id_29, t0.active AS active_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.tenant_id AS tenant_id_33 FROM domains t0 WHERE t0.test_domain = ? AND t0.active = ? Parameters: [`1 1`] View formatted query View runnable query Explain query SELECT t0.domain AS domain_1, t0.name AS name_2, t0.logo AS logo_3, t0.notification_email AS notification_email_4, t0.support_email AS support_email_5, t0.facebook_url AS facebook_url_6, t0.instagram_url AS instagram_url_7, t0.pinterest_url AS pinterest_url_8, t0.timezone AS timezone_9, t0.min_cancellation_notice_minutes AS min_cancellation_notice_minutes_10, t0.appointments_allow_online_payment AS appointments_allow_online_payment_11, t0.appointments_max_advance_days AS appointments_max_advance_days_12, t0.currency_mode AS currency_mode_13, t0.appointments_allow_pay_at_business AS appointments_allow_pay_at_business_14, t0.maintenance_mode AS maintenance_mode_15, t0.maintenance_message AS maintenance_message_16, t0.chat_enabled AS chat_enabled_17, t0.reviews_require_approval AS reviews_require_approval_18, t0.review_request_enabled AS review_request_enabled_19, t0.review_request_delay_days AS review_request_delay_days_20, t0.home_products_strategy AS home_products_strategy_21, t0.appointments_music_enabled AS appointments_music_enabled_22, t0.appointments_points_enabled AS appointments_points_enabled_23, t0.membership_points_enabled AS membership_points_enabled_24, t0.membership_points_per_checkin AS membership_points_per_checkin_25, t0.membership_points_per_class AS membership_points_per_class_26, t0.test_domain AS test_domain_27, t0.home_sections AS home_sections_28, t0.id AS id_29, t0.active AS active_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.tenant_id AS tenant_id_33 FROM domains t0 WHERE t0.test_domain = ? AND t0.active = ? SELECT t0.domain AS domain_1, t0.name AS name_2, t0.logo AS logo_3, t0.notification_email AS notification_email_4, t0.support_email AS support_email_5, t0.facebook_url AS facebook_url_6, t0.instagram_url AS instagram_url_7, t0.pinterest_url AS pinterest_url_8, t0.timezone AS timezone_9, t0.min_cancellation_notice_minutes AS min_cancellation_notice_minutes_10, t0.appointments_allow_online_payment AS appointments_allow_online_payment_11, t0.appointments_max_advance_days AS appointments_max_advance_days_12, t0.currency_mode AS currency_mode_13, t0.appointments_allow_pay_at_business AS appointments_allow_pay_at_business_14, t0.maintenance_mode AS maintenance_mode_15, t0.maintenance_message AS maintenance_message_16, t0.chat_enabled AS chat_enabled_17, t0.reviews_require_approval AS reviews_require_approval_18, t0.review_request_enabled AS review_request_enabled_19, t0.review_request_delay_days AS review_request_delay_days_20, t0.home_products_strategy AS home_products_strategy_21, t0.appointments_music_enabled AS appointments_music_enabled_22, t0.appointments_points_enabled AS appointments_points_enabled_23, t0.membership_points_enabled AS membership_points_enabled_24, t0.membership_points_per_checkin AS membership_points_per_checkin_25, t0.membership_points_per_class AS membership_points_per_class_26, t0.test_domain AS test_domain_27, t0.home_sections AS home_sections_28, t0.id AS id_29, t0.active AS active_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.tenant_id AS tenant_id_33 FROM domains t0 WHERE t0.test_domain = 1 AND t0.active = 1;
7	0.53 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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_id = m1_.id WHERE d0_.domain_id = ? AND m1_.slug = ? Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" "products"`] 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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_id = m1_.id WHERE d0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND m1_.slug = 'products';
8	0.40 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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_id = m1_.id WHERE d0_.domain_id = ? AND m1_.slug = ? Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" "appointments"`] 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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_id = m1_.id WHERE d0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND m1_.slug = 'appointments';
9	0.65 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Á" "products_reviews"`] 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 = 'products_reviews';
10	0.41 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Á" "products_stock_display"`] 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 = 'products_stock_display';
11	1.71 ms	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.public_price AS public_price_3, p0_.stock AS stock_4, MIN(i1_.image) AS sclr_5, c2_.code AS code_6, p0_.rating_average AS rating_average_7, p0_.rating_count AS rating_count_8, p0_.featured_rank AS featured_rank_9 FROM products p0_ INNER JOIN domains d3_ ON p0_.domain_id = d3_.id LEFT JOIN currencies c2_ ON p0_.currency_id = c2_.id LEFT JOIN images_products i1_ ON p0_.id = i1_.product_id AND (i1_.active = ?) WHERE d3_.id = ? AND p0_.active = ? AND (p0_.stock IS NULL OR p0_.stock > 0) AND p0_.visibility = ? AND p0_.featured_rank IS NOT NULL GROUP BY p0_.id, p0_.name, p0_.description, p0_.public_price, p0_.stock, c2_.code, p0_.rating_average, p0_.rating_count, p0_.featured_rank, p0_.created_at ORDER BY p0_.featured_rank ASC, p0_.name ASC LIMIT 24 Parameters: [`1 b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1 "public"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.public_price AS public_price_3, p0_.stock AS stock_4, MIN(i1_.image) AS sclr_5, c2_.code AS code_6, p0_.rating_average AS rating_average_7, p0_.rating_count AS rating_count_8, p0_.featured_rank AS featured_rank_9 FROM products p0_ INNER JOIN domains d3_ ON p0_.domain_id = d3_.id LEFT JOIN currencies c2_ ON p0_.currency_id = c2_.id LEFT JOIN images_products i1_ ON p0_.id = i1_.product_id AND (i1_.active = ?) WHERE d3_.id = ? AND p0_.active = ? AND ( p0_.stock IS NULL OR p0_.stock > 0 ) AND p0_.visibility = ? AND p0_.featured_rank IS NOT NULL GROUP BY p0_.id, p0_.name, p0_.description, p0_.public_price, p0_.stock, c2_.code, p0_.rating_average, p0_.rating_count, p0_.featured_rank, p0_.created_at ORDER BY p0_.featured_rank ASC, p0_.name ASC LIMIT 24 SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.public_price AS public_price_3, p0_.stock AS stock_4, MIN(i1_.image) AS sclr_5, c2_.code AS code_6, p0_.rating_average AS rating_average_7, p0_.rating_count AS rating_count_8, p0_.featured_rank AS featured_rank_9 FROM products p0_ INNER JOIN domains d3_ ON p0_.domain_id = d3_.id LEFT JOIN currencies c2_ ON p0_.currency_id = c2_.id LEFT JOIN images_products i1_ ON p0_.id = i1_.product_id AND (i1_.active = 1) WHERE d3_.id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND p0_.active = 1 AND (p0_.stock IS NULL OR p0_.stock > 0) AND p0_.visibility = 'public' AND p0_.featured_rank IS NOT NULL GROUP BY p0_.id, p0_.name, p0_.description, p0_.public_price, p0_.stock, c2_.code, p0_.rating_average, p0_.rating_count, p0_.featured_rank, p0_.created_at ORDER BY p0_.featured_rank ASC, p0_.name ASC LIMIT 24;
12	1.45 ms	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.public_price AS public_price_3, p0_.stock AS stock_4, MIN(i1_.image) AS sclr_5, c2_.code AS code_6, p0_.rating_average AS rating_average_7, p0_.rating_count AS rating_count_8, p0_.featured_rank AS featured_rank_9 FROM products p0_ INNER JOIN domains d3_ ON p0_.domain_id = d3_.id LEFT JOIN currencies c2_ ON p0_.currency_id = c2_.id LEFT JOIN images_products i1_ ON p0_.id = i1_.product_id AND (i1_.active = ?) WHERE d3_.id = ? AND p0_.active = ? AND (p0_.stock IS NULL OR p0_.stock > 0) AND p0_.visibility = ? AND p0_.featured_rank IS NULL GROUP BY p0_.id, p0_.name, p0_.description, p0_.public_price, p0_.stock, c2_.code, p0_.rating_average, p0_.rating_count, p0_.featured_rank, p0_.created_at ORDER BY p0_.created_at DESC LIMIT 24 Parameters: [`1 b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1 "public"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.public_price AS public_price_3, p0_.stock AS stock_4, MIN(i1_.image) AS sclr_5, c2_.code AS code_6, p0_.rating_average AS rating_average_7, p0_.rating_count AS rating_count_8, p0_.featured_rank AS featured_rank_9 FROM products p0_ INNER JOIN domains d3_ ON p0_.domain_id = d3_.id LEFT JOIN currencies c2_ ON p0_.currency_id = c2_.id LEFT JOIN images_products i1_ ON p0_.id = i1_.product_id AND (i1_.active = ?) WHERE d3_.id = ? AND p0_.active = ? AND ( p0_.stock IS NULL OR p0_.stock > 0 ) AND p0_.visibility = ? AND p0_.featured_rank IS NULL GROUP BY p0_.id, p0_.name, p0_.description, p0_.public_price, p0_.stock, c2_.code, p0_.rating_average, p0_.rating_count, p0_.featured_rank, p0_.created_at ORDER BY p0_.created_at DESC LIMIT 24 SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.public_price AS public_price_3, p0_.stock AS stock_4, MIN(i1_.image) AS sclr_5, c2_.code AS code_6, p0_.rating_average AS rating_average_7, p0_.rating_count AS rating_count_8, p0_.featured_rank AS featured_rank_9 FROM products p0_ INNER JOIN domains d3_ ON p0_.domain_id = d3_.id LEFT JOIN currencies c2_ ON p0_.currency_id = c2_.id LEFT JOIN images_products i1_ ON p0_.id = i1_.product_id AND (i1_.active = 1) WHERE d3_.id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND p0_.active = 1 AND (p0_.stock IS NULL OR p0_.stock > 0) AND p0_.visibility = 'public' AND p0_.featured_rank IS NULL GROUP BY p0_.id, p0_.name, p0_.description, p0_.public_price, p0_.stock, c2_.code, p0_.rating_average, p0_.rating_count, p0_.featured_rank, p0_.created_at ORDER BY p0_.created_at DESC LIMIT 24;
13	1.14 ms	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.public_price AS public_price_3, p0_.stock AS stock_4, MIN(i1_.image) AS sclr_5, c2_.code AS code_6, p0_.rating_average AS rating_average_7, p0_.rating_count AS rating_count_8, p0_.featured_rank AS featured_rank_9 FROM products p0_ INNER JOIN domains d3_ ON p0_.domain_id = d3_.id LEFT JOIN currencies c2_ ON p0_.currency_id = c2_.id LEFT JOIN images_products i1_ ON p0_.id = i1_.product_id AND (i1_.active = ?) WHERE d3_.id = ? AND p0_.active = ? AND (p0_.stock IS NULL OR p0_.stock > 0) AND p0_.visibility = ? GROUP BY p0_.id, p0_.name, p0_.description, p0_.public_price, p0_.stock, c2_.code, p0_.rating_average, p0_.rating_count, p0_.featured_rank, p0_.created_at ORDER BY p0_.created_at DESC LIMIT 60 Parameters: [`1 b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1 "public"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.public_price AS public_price_3, p0_.stock AS stock_4, MIN(i1_.image) AS sclr_5, c2_.code AS code_6, p0_.rating_average AS rating_average_7, p0_.rating_count AS rating_count_8, p0_.featured_rank AS featured_rank_9 FROM products p0_ INNER JOIN domains d3_ ON p0_.domain_id = d3_.id LEFT JOIN currencies c2_ ON p0_.currency_id = c2_.id LEFT JOIN images_products i1_ ON p0_.id = i1_.product_id AND (i1_.active = ?) WHERE d3_.id = ? AND p0_.active = ? AND ( p0_.stock IS NULL OR p0_.stock > 0 ) AND p0_.visibility = ? GROUP BY p0_.id, p0_.name, p0_.description, p0_.public_price, p0_.stock, c2_.code, p0_.rating_average, p0_.rating_count, p0_.featured_rank, p0_.created_at ORDER BY p0_.created_at DESC LIMIT 60 SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.public_price AS public_price_3, p0_.stock AS stock_4, MIN(i1_.image) AS sclr_5, c2_.code AS code_6, p0_.rating_average AS rating_average_7, p0_.rating_count AS rating_count_8, p0_.featured_rank AS featured_rank_9 FROM products p0_ INNER JOIN domains d3_ ON p0_.domain_id = d3_.id LEFT JOIN currencies c2_ ON p0_.currency_id = c2_.id LEFT JOIN images_products i1_ ON p0_.id = i1_.product_id AND (i1_.active = 1) WHERE d3_.id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND p0_.active = 1 AND (p0_.stock IS NULL OR p0_.stock > 0) AND p0_.visibility = 'public' GROUP BY p0_.id, p0_.name, p0_.description, p0_.public_price, p0_.stock, c2_.code, p0_.rating_average, p0_.rating_count, p0_.featured_rank, p0_.created_at ORDER BY p0_.created_at DESC LIMIT 60;
14	0.73 ms	SELECT p0_.id AS id_0, p0_.rating AS rating_1, p0_.title AS title_2, p0_.comment AS comment_3, p0_.created_at AS created_at_4, p0_.verified_purchase AS verified_purchase_5, u1_.name AS name_6, p2_.id AS id_7, p2_.name AS name_8 FROM product_reviews p0_ INNER JOIN users u1_ ON p0_.user_id = u1_.id INNER JOIN products p2_ ON p0_.product_id = p2_.id WHERE p2_.domain_id = ? AND p2_.active = 1 AND p2_.visibility = ? AND p0_.status = ? AND p0_.active = 1 AND p0_.rating >= 4 AND p0_.comment IS NOT NULL ORDER BY p0_.helpful_count DESC, p0_.created_at DESC LIMIT 6 Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" "public" "approved"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.rating AS rating_1, p0_.title AS title_2, p0_.comment AS comment_3, p0_.created_at AS created_at_4, p0_.verified_purchase AS verified_purchase_5, u1_.name AS name_6, p2_.id AS id_7, p2_.name AS name_8 FROM product_reviews p0_ INNER JOIN users u1_ ON p0_.user_id = u1_.id INNER JOIN products p2_ ON p0_.product_id = p2_.id WHERE p2_.domain_id = ? AND p2_.active = 1 AND p2_.visibility = ? AND p0_.status = ? AND p0_.active = 1 AND p0_.rating >= 4 AND p0_.comment IS NOT NULL ORDER BY p0_.helpful_count DESC, p0_.created_at DESC LIMIT 6 SELECT p0_.id AS id_0, p0_.rating AS rating_1, p0_.title AS title_2, p0_.comment AS comment_3, p0_.created_at AS created_at_4, p0_.verified_purchase AS verified_purchase_5, u1_.name AS name_6, p2_.id AS id_7, p2_.name AS name_8 FROM product_reviews p0_ INNER JOIN users u1_ ON p0_.user_id = u1_.id INNER JOIN products p2_ ON p0_.product_id = p2_.id WHERE p2_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND p2_.active = 1 AND p2_.visibility = 'public' AND p0_.status = 'approved' AND p0_.active = 1 AND p0_.rating >= 4 AND p0_.comment IS NOT NULL ORDER BY p0_.helpful_count DESC, p0_.created_at DESC LIMIT 6;
15	0.41 ms	SELECT COUNT(p0_.id) AS sclr_0, AVG(p0_.rating) AS sclr_1 FROM product_reviews p0_ INNER JOIN products p1_ ON p0_.product_id = p1_.id WHERE p1_.domain_id = ? AND p1_.active = 1 AND p0_.status = ? AND p0_.active = 1 Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" "approved"`] View formatted query View runnable query Explain query SELECT COUNT(p0_.id) AS sclr_0, AVG(p0_.rating) AS sclr_1 FROM product_reviews p0_ INNER JOIN products p1_ ON p0_.product_id = p1_.id WHERE p1_.domain_id = ? AND p1_.active = 1 AND p0_.status = ? AND p0_.active = 1 SELECT COUNT(p0_.id) AS sclr_0, AVG(p0_.rating) AS sclr_1 FROM product_reviews p0_ INNER JOIN products p1_ ON p0_.product_id = p1_.id WHERE p1_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND p1_.active = 1 AND p0_.status = 'approved' AND p0_.active = 1;
16	0.63 ms	SELECT MIN(s0_.free_over) AS sclr_0 FROM shipping_rates s0_ INNER JOIN shipping_methods s1_ ON s0_.method_id = s1_.id WHERE s1_.domain_id = ? AND s1_.active = 1 AND s1_.type = ? AND s0_.active = 1 AND s0_.free_over IS NOT NULL Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" "delivery"`] View formatted query View runnable query Explain query SELECT MIN(s0_.free_over) AS sclr_0 FROM shipping_rates s0_ INNER JOIN shipping_methods s1_ ON s0_.method_id = s1_.id WHERE s1_.domain_id = ? AND s1_.active = 1 AND s1_.type = ? AND s0_.active = 1 AND s0_.free_over IS NOT NULL SELECT MIN(s0_.free_over) AS sclr_0 FROM shipping_rates s0_ INNER JOIN shipping_methods s1_ ON s0_.method_id = s1_.id WHERE s1_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND s1_.active = 1 AND s1_.type = 'delivery' AND s0_.active = 1 AND s0_.free_over IS NOT NULL;
17	0.42 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Á" "products_catalogs"`] 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 = 'products_catalogs';
18	0.53 ms	SELECT c0_.name AS name_0, c0_.description AS description_1, c0_.id AS id_2, c0_.active AS active_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.domain_id AS domain_id_6 FROM catalogs c0_ INNER JOIN domains d1_ ON c0_.domain_id = d1_.id WHERE d1_.id = ? AND c0_.active = ? Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1`] View formatted query View runnable query Explain query SELECT c0_.name AS name_0, c0_.description AS description_1, c0_.id AS id_2, c0_.active AS active_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.domain_id AS domain_id_6 FROM catalogs c0_ INNER JOIN domains d1_ ON c0_.domain_id = d1_.id WHERE d1_.id = ? AND c0_.active = ? SELECT c0_.name AS name_0, c0_.description AS description_1, c0_.id AS id_2, c0_.active AS active_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.domain_id AS domain_id_6 FROM catalogs c0_ INNER JOIN domains d1_ ON c0_.domain_id = d1_.id WHERE d1_.id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND c0_.active = 1;
19	0.48 ms	SELECT c0_.id AS id_0 FROM countries_catalogs c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.catalogs_id = ? AND c1_.active = ? Parameters: [`b"\x01¡±Ç\x13Rps»©wæ\x15çï" 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM countries_catalogs c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.catalogs_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM countries_catalogs c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.catalogs_id = 0x01A1B1C713527073BBA977E615E7ADEF AND c1_.active = 1;
20	0.45 ms	SELECT r0_.id AS id_0 FROM regions_catalogs r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.catalogs_id = ? AND r1_.active = ? Parameters: [`b"\x01¡±Ç\x13Rps»©wæ\x15çï" 1`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0 FROM regions_catalogs r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.catalogs_id = ? AND r1_.active = ? SELECT r0_.id AS id_0 FROM regions_catalogs r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.catalogs_id = 0x01A1B1C713527073BBA977E615E7ADEF AND r1_.active = 1;
21	0.61 ms	SELECT c0_.id AS id_0 FROM cities_catalogs c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.catalogs_id = ? AND c1_.active = ? Parameters: [`b"\x01¡±Ç\x13Rps»©wæ\x15çï" 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM cities_catalogs c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.catalogs_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM cities_catalogs c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.catalogs_id = 0x01A1B1C713527073BBA977E615E7ADEF AND c1_.active = 1;
22	0.48 ms	SELECT c0_.id AS id_0 FROM countries_catalogs c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.catalogs_id = ? AND c1_.active = ? Parameters: [b"\x01¡±Ç\x13Rq\x0F»©wæ\x160ó`" 1] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM countries_catalogs c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.catalogs_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM countries_catalogs c1_ INNER JOIN countries c0_ ON c1_.country_id = c0_.id WHERE c1_.catalogs_id = 0x01A1B1C71352710FBBA977E61630F360 AND c1_.active = 1;
23	0.44 ms	SELECT r0_.id AS id_0 FROM regions_catalogs r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.catalogs_id = ? AND r1_.active = ? Parameters: [b"\x01¡±Ç\x13Rq\x0F»©wæ\x160ó`" 1] View formatted query View runnable query Explain query SELECT r0_.id AS id_0 FROM regions_catalogs r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.catalogs_id = ? AND r1_.active = ? SELECT r0_.id AS id_0 FROM regions_catalogs r1_ INNER JOIN regions r0_ ON r1_.region_id = r0_.id WHERE r1_.catalogs_id = 0x01A1B1C71352710FBBA977E61630F360 AND r1_.active = 1;
24	0.27 ms	SELECT c0_.id AS id_0 FROM cities_catalogs c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.catalogs_id = ? AND c1_.active = ? Parameters: [b"\x01¡±Ç\x13Rq\x0F»©wæ\x160ó`" 1] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM cities_catalogs c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.catalogs_id = ? AND c1_.active = ? SELECT c0_.id AS id_0 FROM cities_catalogs c1_ INNER JOIN cities c0_ ON c1_.city_id = c0_.id WHERE c1_.catalogs_id = 0x01A1B1C71352710FBBA977E61630F360 AND c1_.active = 1;
25	0.58 ms	SELECT p0_.id AS id_0 FROM catalogs_products c1_ INNER JOIN catalogs c2_ ON c1_.catalog_id = c2_.id INNER JOIN products p0_ ON c1_.product_id = p0_.id WHERE c2_.id = ? AND c1_.active = ? AND p0_.active = ? Parameters: [`b"\x01¡±Ç\x13Rps»©wæ\x15çï" 1 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0 FROM catalogs_products c1_ INNER JOIN catalogs c2_ ON c1_.catalog_id = c2_.id INNER JOIN products p0_ ON c1_.product_id = p0_.id WHERE c2_.id = ? AND c1_.active = ? AND p0_.active = ? SELECT p0_.id AS id_0 FROM catalogs_products c1_ INNER JOIN catalogs c2_ ON c1_.catalog_id = c2_.id INNER JOIN products p0_ ON c1_.product_id = p0_.id WHERE c2_.id = 0x01A1B1C713527073BBA977E615E7ADEF AND c1_.active = 1 AND p0_.active = 1;
26	0.28 ms	SELECT p0_.id AS id_0 FROM catalogs_products c1_ INNER JOIN catalogs c2_ ON c1_.catalog_id = c2_.id INNER JOIN products p0_ ON c1_.product_id = p0_.id WHERE c2_.id = ? AND c1_.active = ? AND p0_.active = ? Parameters: [b"\x01¡±Ç\x13Rq\x0F»©wæ\x160ó`" 1 1] View formatted query View runnable query Explain query SELECT p0_.id AS id_0 FROM catalogs_products c1_ INNER JOIN catalogs c2_ ON c1_.catalog_id = c2_.id INNER JOIN products p0_ ON c1_.product_id = p0_.id WHERE c2_.id = ? AND c1_.active = ? AND p0_.active = ? SELECT p0_.id AS id_0 FROM catalogs_products c1_ INNER JOIN catalogs c2_ ON c1_.catalog_id = c2_.id INNER JOIN products p0_ ON c1_.product_id = p0_.id WHERE c2_.id = 0x01A1B1C71352710FBBA977E61630F360 AND c1_.active = 1 AND p0_.active = 1;
27	0.53 ms	SELECT p0_.id AS id_0, p1_.price AS price_1 FROM products_countries_prices p1_ INNER JOIN products p0_ ON p1_.product_id = p0_.id WHERE p1_.country_id = ? AND p1_.active = 1 AND p0_.active = 1 AND p0_.domain_id = ? Parameters: [`b"\x01¡²\x06ùfuh\OqÐðM}" b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p1_.price AS price_1 FROM products_countries_prices p1_ INNER JOIN products p0_ ON p1_.product_id = p0_.id WHERE p1_.country_id = ? AND p1_.active = 1 AND p0_.active = 1 AND p0_.domain_id = ? SELECT p0_.id AS id_0, p1_.price AS price_1 FROM products_countries_prices p1_ INNER JOIN products p0_ ON p1_.product_id = p0_.id WHERE p1_.country_id = 0x01A1B206F9667568905C4F71D0F04D7D AND p1_.active = 1 AND p0_.active = 1 AND p0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1;
28	0.32 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;
29	0.62 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;
30	0.30 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;
31	0.39 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Á" "products_promotions"`] 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 = 'products_promotions';
32	0.51 ms	SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.discount_rate AS discount_rate_4, p0_.value_type AS value_type_5, p0_.currency_code AS currency_code_6, p0_.applies_to AS applies_to_7, p0_.priority AS priority_8, p0_.id AS id_9, p0_.active AS active_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.domain_id AS domain_id_13, p0_.discount_type_id AS discount_type_id_14 FROM promotions p0_ WHERE p0_.domain_id = ? AND p0_.active = ? AND p0_.start_date <= ? AND p0_.end_date >= ? Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1 "2026-11-13 03:17:12" "2026-11-13 00:00:00"`] View formatted query View runnable query Explain query SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.discount_rate AS discount_rate_4, p0_.value_type AS value_type_5, p0_.currency_code AS currency_code_6, p0_.applies_to AS applies_to_7, p0_.priority AS priority_8, p0_.id AS id_9, p0_.active AS active_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.domain_id AS domain_id_13, p0_.discount_type_id AS discount_type_id_14 FROM promotions p0_ WHERE p0_.domain_id = ? AND p0_.active = ? AND p0_.start_date <= ? AND p0_.end_date >= ? SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.discount_rate AS discount_rate_4, p0_.value_type AS value_type_5, p0_.currency_code AS currency_code_6, p0_.applies_to AS applies_to_7, p0_.priority AS priority_8, p0_.id AS id_9, p0_.active AS active_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.domain_id AS domain_id_13, p0_.discount_type_id AS discount_type_id_14 FROM promotions p0_ WHERE p0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND p0_.active = 1 AND p0_.start_date <= '2026-11-13 03:17:12' AND p0_.end_date >= '2026-11-13 00:00:00';
33	0.64 ms	SELECT p0_.product_id AS sclr_0, p0_.name AS name_1, p0_.description AS description_2, p0_.short_description AS short_description_3, p0_.highlights AS highlights_4 FROM product_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.product_id IN (?, ?, ?) AND l1_.code = ? AND p0_.active = ? AND p0_.status = ? Parameters: [`b"\x01¡±Ç\x13QxØ¯/ÕrÈäeD" b"\x01¡±Ç\x13Qy¬¯/ÕrÉ•\x0F\x07" b"\x01¡±Ç\x13Qz\x1C¯/ÕrÉÊß˜" "en" 1 "ready"`] View formatted query View runnable query Explain query SELECT p0_.product_id AS sclr_0, p0_.name AS name_1, p0_.description AS description_2, p0_.short_description AS short_description_3, p0_.highlights AS highlights_4 FROM product_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.product_id IN (?, ?, ?) AND l1_.code = ? AND p0_.active = ? AND p0_.status = ? SELECT p0_.product_id AS sclr_0, p0_.name AS name_1, p0_.description AS description_2, p0_.short_description AS short_description_3, p0_.highlights AS highlights_4 FROM product_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.product_id IN (0x01A1B1C7135178D8AF2FD572C8E46544, 0x01A1B1C7135179ACAF2FD572C9950F07, 0x01A1B1C713517A1CAF2FD572C9CADF98) AND l1_.code = 'en' AND p0_.active = 1 AND p0_.status = 'ready';
34	0.37 ms	SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.discount_rate AS discount_rate_4, p0_.value_type AS value_type_5, p0_.currency_code AS currency_code_6, p0_.applies_to AS applies_to_7, p0_.priority AS priority_8, p0_.id AS id_9, p0_.active AS active_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.domain_id AS domain_id_13, p0_.discount_type_id AS discount_type_id_14 FROM promotions p0_ WHERE p0_.domain_id = ? AND p0_.active = ? AND p0_.start_date <= ? AND p0_.end_date >= ? Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" 1 "2026-11-13 03:17:12" "2026-11-13 00:00:00"`] View formatted query View runnable query Explain query SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.discount_rate AS discount_rate_4, p0_.value_type AS value_type_5, p0_.currency_code AS currency_code_6, p0_.applies_to AS applies_to_7, p0_.priority AS priority_8, p0_.id AS id_9, p0_.active AS active_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.domain_id AS domain_id_13, p0_.discount_type_id AS discount_type_id_14 FROM promotions p0_ WHERE p0_.domain_id = ? AND p0_.active = ? AND p0_.start_date <= ? AND p0_.end_date >= ? SELECT p0_.name AS name_0, p0_.description AS description_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.discount_rate AS discount_rate_4, p0_.value_type AS value_type_5, p0_.currency_code AS currency_code_6, p0_.applies_to AS applies_to_7, p0_.priority AS priority_8, p0_.id AS id_9, p0_.active AS active_10, p0_.created_at AS created_at_11, p0_.updated_at AS updated_at_12, p0_.domain_id AS domain_id_13, p0_.discount_type_id AS discount_type_id_14 FROM promotions p0_ WHERE p0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND p0_.active = 1 AND p0_.start_date <= '2026-11-13 03:17:12' AND p0_.end_date >= '2026-11-13 00:00:00';
35	0.41 ms	SELECT p0_.product_id AS sclr_0, p0_.name AS name_1, p0_.description AS description_2, p0_.short_description AS short_description_3, p0_.highlights AS highlights_4 FROM product_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.product_id IN (?, ?, ?) AND l1_.code = ? AND p0_.active = ? AND p0_.status = ? Parameters: [`b"\x01¡±Ç\x13QxØ¯/ÕrÈäeD" b"\x01¡±Ç\x13Qy¬¯/ÕrÉ•\x0F\x07" b"\x01¡±Ç\x13Qz\x1C¯/ÕrÉÊß˜" "en" 1 "ready"`] View formatted query View runnable query Explain query SELECT p0_.product_id AS sclr_0, p0_.name AS name_1, p0_.description AS description_2, p0_.short_description AS short_description_3, p0_.highlights AS highlights_4 FROM product_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.product_id IN (?, ?, ?) AND l1_.code = ? AND p0_.active = ? AND p0_.status = ? SELECT p0_.product_id AS sclr_0, p0_.name AS name_1, p0_.description AS description_2, p0_.short_description AS short_description_3, p0_.highlights AS highlights_4 FROM product_translations p0_ INNER JOIN languages l1_ ON p0_.language_id = l1_.id WHERE p0_.product_id IN (0x01A1B1C7135178D8AF2FD572C8E46544, 0x01A1B1C7135179ACAF2FD572C9950F07, 0x01A1B1C713517A1CAF2FD572C9CADF98) AND l1_.code = 'en' AND p0_.active = 1 AND p0_.status = 'ready';
36	1.33 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;
37	0.85 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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_id = m1_.id WHERE d0_.domain_id = ? AND m1_.slug = ? Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" "loyalty"`] 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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_id = m1_.id WHERE d0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND m1_.slug = 'loyalty';
38	0.56 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Á" "loyalty_points"`] 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 = 'loyalty_points';
39	0.78 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;
40	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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_id = m1_.id WHERE d0_.domain_id = ? AND m1_.slug = ? Parameters: [`b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" "memberships"`] 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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_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_id AS module_id_5 FROM domain_modules d0_ INNER JOIN modules m1_ ON d0_.module_id = m1_.id WHERE d0_.domain_id = 0x01A1B1C70B23751EBCC349711D8F14C1 AND m1_.slug = 'memberships';
41	0.61 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;
42	0.32 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;
43	0.38 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;
44	0.24 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;
45	0.44 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;
46	0.44 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Á" "membership_plans"`] 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 = 'membership_plans';
47	0.39 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Á" "membership_tools"`] 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 = 'membership_tools';
48	0.41 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;
49	0.48 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\Tenants\Modules\ModuleFeatures	41
App\Entity\Tenants\Modules\Modules	8
App\Entity\Tenants\Modules\DomainModuleFeatures	7
App\Entity\Tenants\Modules\DomainModules	4
App\Entity\Tenants\Currencies\Currencies	2
App\Entity\Tenants\Domains\Domains	2
App\Entity\Tenants\Tenants	2
App\Entity\Products\Catalogs\Catalogs	2
App\Entity\Appointments\Services\Services	2
App\Entity\Appointments\Services\ServiceImages	2
App\Entity\Configurations\Globals\Countries	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\Modules\Modules	No errors.
App\Entity\Tenants\Modules\ModulesTenants	No errors.
App\Entity\Tenants\Modules\ModuleFeatures	No errors.
App\Entity\Tenants\Modules\ModuleFeatureRequirements	No errors.
App\Entity\Tenants\Modules\DomainModules	No errors.
App\Entity\Tenants\Modules\DomainModuleFeatures	No errors.
App\Entity\Products\Products	No errors.
App\Entity\Products\Others\ImagesProducts	No errors.
App\Entity\Products\Others\ProductReviews	No errors.
App\Entity\Users\Users	No errors.
App\Entity\Shipping\ShippingRates	No errors.
App\Entity\Shipping\ShippingMethods	No errors.
App\Entity\Products\Catalogs\Catalogs	No errors.
App\Entity\Configurations\Countries\CountriesCatalogs	No errors.
App\Entity\Configurations\Regions\RegionsCatalogs	No errors.
App\Entity\Configurations\Cities\CitiesCatalogs	No errors.
App\Entity\Configurations\Globals\Cities	No errors.
App\Entity\Products\Catalogs\CatalogsProducts	No errors.
App\Entity\Products\Prices\ProductsCountriesPrices	No errors.
App\Entity\Tenants\Currencies\DomainAllowedCurrencies	No errors.
App\Entity\Products\Promotions\Promotions	No errors.
App\Entity\Tenants\Domains\DiscountTypes	No errors.
App\Entity\Products\ProductTranslations	No errors.
App\Entity\Tenants\Languages\Languages	No errors.
App\Entity\Appointments\Services\Services	No errors.
App\Entity\Appointments\Services\ServiceImages	No errors.
App\Entity\Tenants\Domains\PointConditions	No errors.

GET https://thorha.com/en

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping