https://shop.winitux.de/de/unsere-produkte

Query Metrics

19 Database Queries
7 Different statements
5.39 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.45 ms
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.monthly_price AS monthly_price_3, t0.reg_datetime AS reg_datetime_4, t0.client_id AS client_id_5, t0.product_webhosting_id AS product_webhosting_id_6 FROM cart_webhosting t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
  ""
]
2 0.35 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.product_description_short AS product_description_short_3, t0.product_description_long AS product_description_long_4, t0.product_image AS product_image_5, t0.is_public AS is_public_6, t0.is_active AS is_active_7, t0.reg_by AS reg_by_8, t0.reg_datetime AS reg_datetime_9 FROM product t0 WHERE t0.is_active = ? AND t0.is_public = ? ORDER BY t0.id ASC
Parameters:
[
  1
  1
]
3 0.35 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.is_active = 1 AND p0_.is_public = 1
Parameters:
[]
4 0.31 ms
SELECT s0_.id AS id_0, s0_.time_zone AS time_zone_1, s0_.company_name AS company_name_2, s0_.vat AS vat_3, s0_.company_email AS company_email_4, s0_.company_phone AS company_phone_5, s0_.app_tenant_id AS app_tenant_id_6, s0_.app_client_id AS app_client_id_7, s0_.app_client_secret AS app_client_secret_8, s0_.invoice_discount AS invoice_discount_9, s0_.technical_costs_month_client AS technical_costs_month_client_10, s0_.robot_user AS robot_user_11, s0_.robot_pwd AS robot_pwd_12, s0_.first_invoice_number AS first_invoice_number_13, s0_.first_void_number AS first_void_number_14 FROM setting s0_ ORDER BY s0_.id DESC
Parameters:
[]
5 0.28 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM cart c0_ WHERE c0_.session_id = ?
Parameters:
[
  ""
]
6 0.40 ms
SELECT t0.id AS id_1, t0.single_price_month_user AS single_price_month_user_2, t0.single_price_month_extra_lic AS single_price_month_extra_lic_3, t0.min_user AS min_user_4, t0.max_user AS max_user_5, t0.product_id AS product_id_6, t0.subscription_plan_id AS subscription_plan_id_7 FROM subscription_plan_price t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
7 0.44 ms
SELECT t0.id AS id_1, t0.subscription_plan_name AS subscription_plan_name_2, t0.is_active AS is_active_3, t0.reg_by AS reg_by_4, t0.reg_datetime AS reg_datetime_5 FROM subscription_plan t0 INNER JOIN product_subscription_plan ON t0.id = product_subscription_plan.subscription_plan_id WHERE product_subscription_plan.product_id = ?
Parameters:
[
  1
]
8 0.24 ms
SELECT t0.id AS id_1, t0.single_price_month_user AS single_price_month_user_2, t0.single_price_month_extra_lic AS single_price_month_extra_lic_3, t0.min_user AS min_user_4, t0.max_user AS max_user_5, t0.product_id AS product_id_6, t0.subscription_plan_id AS subscription_plan_id_7 FROM subscription_plan_price t0 WHERE t0.product_id = ?
Parameters:
[
  22
]
9 0.25 ms
SELECT t0.id AS id_1, t0.subscription_plan_name AS subscription_plan_name_2, t0.is_active AS is_active_3, t0.reg_by AS reg_by_4, t0.reg_datetime AS reg_datetime_5 FROM subscription_plan t0 INNER JOIN product_subscription_plan ON t0.id = product_subscription_plan.subscription_plan_id WHERE product_subscription_plan.product_id = ?
Parameters:
[
  22
]
10 0.22 ms
SELECT t0.id AS id_1, t0.single_price_month_user AS single_price_month_user_2, t0.single_price_month_extra_lic AS single_price_month_extra_lic_3, t0.min_user AS min_user_4, t0.max_user AS max_user_5, t0.product_id AS product_id_6, t0.subscription_plan_id AS subscription_plan_id_7 FROM subscription_plan_price t0 WHERE t0.product_id = ?
Parameters:
[
  23
]
11 0.26 ms
SELECT t0.id AS id_1, t0.subscription_plan_name AS subscription_plan_name_2, t0.is_active AS is_active_3, t0.reg_by AS reg_by_4, t0.reg_datetime AS reg_datetime_5 FROM subscription_plan t0 INNER JOIN product_subscription_plan ON t0.id = product_subscription_plan.subscription_plan_id WHERE product_subscription_plan.product_id = ?
Parameters:
[
  23
]
12 0.21 ms
SELECT t0.id AS id_1, t0.single_price_month_user AS single_price_month_user_2, t0.single_price_month_extra_lic AS single_price_month_extra_lic_3, t0.min_user AS min_user_4, t0.max_user AS max_user_5, t0.product_id AS product_id_6, t0.subscription_plan_id AS subscription_plan_id_7 FROM subscription_plan_price t0 WHERE t0.product_id = ?
Parameters:
[
  24
]
13 0.23 ms
SELECT t0.id AS id_1, t0.subscription_plan_name AS subscription_plan_name_2, t0.is_active AS is_active_3, t0.reg_by AS reg_by_4, t0.reg_datetime AS reg_datetime_5 FROM subscription_plan t0 INNER JOIN product_subscription_plan ON t0.id = product_subscription_plan.subscription_plan_id WHERE product_subscription_plan.product_id = ?
Parameters:
[
  24
]
14 0.22 ms
SELECT t0.id AS id_1, t0.single_price_month_user AS single_price_month_user_2, t0.single_price_month_extra_lic AS single_price_month_extra_lic_3, t0.min_user AS min_user_4, t0.max_user AS max_user_5, t0.product_id AS product_id_6, t0.subscription_plan_id AS subscription_plan_id_7 FROM subscription_plan_price t0 WHERE t0.product_id = ?
Parameters:
[
  27
]
15 0.22 ms
SELECT t0.id AS id_1, t0.subscription_plan_name AS subscription_plan_name_2, t0.is_active AS is_active_3, t0.reg_by AS reg_by_4, t0.reg_datetime AS reg_datetime_5 FROM subscription_plan t0 INNER JOIN product_subscription_plan ON t0.id = product_subscription_plan.subscription_plan_id WHERE product_subscription_plan.product_id = ?
Parameters:
[
  27
]
16 0.22 ms
SELECT t0.id AS id_1, t0.single_price_month_user AS single_price_month_user_2, t0.single_price_month_extra_lic AS single_price_month_extra_lic_3, t0.min_user AS min_user_4, t0.max_user AS max_user_5, t0.product_id AS product_id_6, t0.subscription_plan_id AS subscription_plan_id_7 FROM subscription_plan_price t0 WHERE t0.product_id = ?
Parameters:
[
  29
]
17 0.27 ms
SELECT t0.id AS id_1, t0.subscription_plan_name AS subscription_plan_name_2, t0.is_active AS is_active_3, t0.reg_by AS reg_by_4, t0.reg_datetime AS reg_datetime_5 FROM subscription_plan t0 INNER JOIN product_subscription_plan ON t0.id = product_subscription_plan.subscription_plan_id WHERE product_subscription_plan.product_id = ?
Parameters:
[
  29
]
18 0.22 ms
SELECT t0.id AS id_1, t0.single_price_month_user AS single_price_month_user_2, t0.single_price_month_extra_lic AS single_price_month_extra_lic_3, t0.min_user AS min_user_4, t0.max_user AS max_user_5, t0.product_id AS product_id_6, t0.subscription_plan_id AS subscription_plan_id_7 FROM subscription_plan_price t0 WHERE t0.product_id = ?
Parameters:
[
  31
]
19 0.24 ms
SELECT t0.id AS id_1, t0.subscription_plan_name AS subscription_plan_name_2, t0.is_active AS is_active_3, t0.reg_by AS reg_by_4, t0.reg_datetime AS reg_datetime_5 FROM subscription_plan t0 INNER JOIN product_subscription_plan ON t0.id = product_subscription_plan.subscription_plan_id WHERE product_subscription_plan.product_id = ?
Parameters:
[
  31
]

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.

Entities Mapping