Query Metrics
29
Database Queries
18
Different statements
12.74 ms
Query time
0
Invalid entities
9
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.96 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 ] |
| 2 | 0.49 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.country_id AS country_id_8 FROM regions t0 WHERE t0.iso_code = ? AND t0.active = ? LIMIT 1
Parameters:
[ "IL" 1 ] |
| 3 | 0.42 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.name = ? AND t0.active = ? LIMIT 1
Parameters:
[ 4887398 1 ] |
| 4 | 0.71 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/" ] |
| 5 | 0.49 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 ] |
| 6 | 0.54 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 ] |
| 7 | 0.40 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 ] |
| 8 | 0.45 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 ] |
| 9 | 0.31 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 ] |
| 10 | 0.27 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 ] |
| 11 | 0.22 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 ] |
| 12 | 0.58 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Á" ] |
| 13 | 0.54 ms |
SELECT p0_.id AS id_0, p1_.price AS price_1 FROM products_regions_prices p1_ INNER JOIN products p0_ ON p1_.product_id = p0_.id WHERE p1_.region_id = ? AND p1_.active = 1 AND p0_.active = 1 AND p0_.domain_id = ?
Parameters:
[ b"\x01¡³™\x17#|ð¹£þÕĵ\x02\x0E" b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" ] |
| 14 | 0.60 ms |
SELECT p0_.id AS id_0, p1_.price AS price_1 FROM products_cities_prices p1_ INNER JOIN products p0_ ON p1_.product_id = p0_.id WHERE p1_.city_id = ? AND p1_.active = 1 AND p0_.active = 1 AND p0_.domain_id = ?
Parameters:
[ b"\x01¡³™\x17)x¡†=Ý3mu0" b"\x01¡±Ç\v#u\x1E¼ÃIq\x1D\x14Á" ] |
| 15 | 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.id = ?
Parameters:
[
b"\x01¡±Ç\x15²~¶»\r_ô\x02 N²"
]
|
| 16 | 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Á"
]
|
| 17 | 0.35 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 ] |
| 18 | 0.40 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 01:21:54" "2026-11-13 00:00:00" ] |
| 19 | 0.43 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" ] |
| 20 | 0.29 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 01:21:54" "2026-11-13 00:00:00" ] |
| 21 | 0.26 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" ] |
| 22 | 0.50 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 ] |
| 23 | 0.47 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Á"
]
|
| 24 | 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.active = ? ORDER BY t0.code ASC
Parameters:
[
1
]
|
| 25 | 0.28 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Á"
]
|
| 26 | 0.21 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 ] |
| 27 | 0.50 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 ] |
| 28 | 0.48 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 ] |
| 29 | 0.40 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 ] |
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\Currencies\Currencies | 2 |
| App\Entity\Products\Catalogs\Catalogs | 2 |
| App\Entity\Configurations\Globals\Countries | 1 |
| App\Entity\Configurations\Globals\Regions | 1 |
| App\Entity\Configurations\Globals\Cities | 1 |
| App\Entity\Tenants\Domains\Domains | 1 |
| App\Entity\Tenants\Tenants | 1 |