Query Metrics
19
Database Queries
7
Different statements
5.38 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.44 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.31 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.25 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.is_active = 1 AND p0_.is_public = 1
Parameters:
[] |
| 4 | 0.24 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.19 ms |
SELECT COUNT(c0_.id) AS sclr_0 FROM cart c0_ WHERE c0_.session_id = ?
Parameters:
[ "" ] |
| 6 | 0.27 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.38 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.23 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.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:
[
22
]
|
| 10 | 0.27 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.35 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.39 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.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:
[
24
]
|
| 14 | 0.28 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.28 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.27 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.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:
[
29
]
|
| 18 | 0.20 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.33 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
| Class | Mapping errors |
|---|---|
| App\Entity\CartWebhosting | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ProductWebhosting | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Addon | No errors. |
| App\Entity\SubscriptionPlanPrice | No errors. |
| App\Entity\SubscriptionPlan | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\ServiceState | No errors. |
| App\Entity\Setting | No errors. |