GET https://dev-nd.skalex.net/

Query Metrics

9 Database Queries
7 Different statements
7.62 ms Query time
0 Invalid entities
43 Managed entities

Queries

Group similar statements

# Time Info
1 0.67 ms
SELECT t0.id AS id_1, t0.`key` AS key_2, t0.title AS title_3, t0.value AS value_4, t0.regex AS regex_5, t0.other_data AS other_data_6 FROM system_config t0
Parameters:
[]
2 0.56 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.status AS status_5, t0.is_deleted AS is_deleted_6, t0.title AS title_7, t0.content AS content_8, t0.author_id AS author_id_9 FROM news t0 WHERE t0.is_deleted = ? AND t0.status = ? ORDER BY t0.created_at DESC LIMIT 3
Parameters:
[
  0
  1
]
3 1.04 ms
SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.name AS name_2, t0_.active AS active_3, t0_.enabled AS enabled_4, t0_.other_data AS other_data_5, t0_.remote_id AS remote_id_6, t0_.service_key AS service_key_7, t0_.search_key AS search_key_8, t0_.comment AS comment_9, t0_.proc_name AS proc_name_10, t0_.ram_name AS ram_name_11, t0_.disk_name AS disk_name_12, t0_.cost AS cost_13, t0_.cost_install AS cost_install_14, t0_.empty_text AS empty_text_15, t0_.ip_block AS ip_block_16, t0_.not_deleted AS not_deleted_17, t0_.min_days AS min_days_18, t0_.maximum_min_servers AS maximum_min_servers_19, t0_.pos AS pos_20, t0_.ram_count AS ram_count_21, t0_.disk_count AS disk_count_22, t0_.proc_comment AS proc_comment_23, t0_.processor_icon AS processor_icon_24, t0_.hide_is_unactive AS hide_is_unactive_25, t0_.active_count AS active_count_26, t0_.passmark AS passmark_27, t0_.unixbench AS unixbench_28, t0_.myarena_id AS myarena_id_29, t0_.category_id AS category_id_30 FROM tarif t0_ WHERE t0_.type = ? AND t0_.enabled = 1 AND t0_.not_deleted = 1 AND t0_.active = 1 ORDER BY t0_.pos ASC, t0_.id ASC
Parameters:
[
  0
]
4 1.77 ms
SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.name AS name_2, t0_.active AS active_3, t0_.enabled AS enabled_4, t0_.other_data AS other_data_5, t0_.remote_id AS remote_id_6, t0_.service_key AS service_key_7, t0_.search_key AS search_key_8, t0_.comment AS comment_9, t0_.proc_name AS proc_name_10, t0_.ram_name AS ram_name_11, t0_.disk_name AS disk_name_12, t0_.cost AS cost_13, t0_.cost_install AS cost_install_14, t0_.empty_text AS empty_text_15, t0_.ip_block AS ip_block_16, t0_.not_deleted AS not_deleted_17, t0_.min_days AS min_days_18, t0_.maximum_min_servers AS maximum_min_servers_19, t0_.pos AS pos_20, t0_.ram_count AS ram_count_21, t0_.disk_count AS disk_count_22, t0_.proc_comment AS proc_comment_23, t0_.processor_icon AS processor_icon_24, t0_.hide_is_unactive AS hide_is_unactive_25, t0_.active_count AS active_count_26, t0_.passmark AS passmark_27, t0_.unixbench AS unixbench_28, t0_.myarena_id AS myarena_id_29, t1_.id AS id_30, t1_.name AS name_31, t1_.pos AS pos_32, t1_.type AS type_33, t1_.comment AS comment_34, t2_.id AS id_35, t2_.tag AS tag_36, t2_.pos AS pos_37, t2_.label_tag AS label_tag_38, t2_.comment AS comment_39, t2_.icon AS icon_40, t2_.show_in_filter AS show_in_filter_41, t0_.category_id AS category_id_42 FROM tarif t0_ INNER JOIN tarif_category t1_ ON t0_.category_id = t1_.id LEFT JOIN tarif_tarif_tag t3_ ON t0_.id = t3_.tarif_id LEFT JOIN tarif_tag t2_ ON t2_.id = t3_.tarif_tag_id WHERE t0_.type = ? AND t0_.enabled = 1 AND t0_.not_deleted = 1 AND (t0_.active = 1 OR t0_.hide_is_unactive = 0) ORDER BY t1_.pos ASC, t1_.id ASC, t0_.pos ASC, t0_.id ASC, t2_.pos ASC, t2_.id ASC
Parameters:
[
  1
]
5 0.85 ms
SELECT m0_.id AS id_0, m0_.path AS path_1, m0_.title AS title_2, m0_.description AS description_3, m0_.keywords AS keywords_4 FROM meta_data m0_ ORDER BY m0_.path DESC
Parameters:
[]
6 0.54 ms
SELECT s0_.id AS id_0, s0_.web_logo AS web_logo_1, s0_.cp_logo AS cp_logo_2, s0_.white_logo AS white_logo_3, s0_.email_logo AS email_logo_4, s0_.cp_mini_logo AS cp_mini_logo_5, s0_.cp_mini_dark_logo AS cp_mini_dark_logo_6, s0_.favicon_logo AS favicon_logo_7 FROM site_logo s0_ WHERE s0_.id = 1
Parameters:
[]
7 0.66 ms
SELECT s0_.id AS id_0, s0_.web_logo AS web_logo_1, s0_.cp_logo AS cp_logo_2, s0_.white_logo AS white_logo_3, s0_.email_logo AS email_logo_4, s0_.cp_mini_logo AS cp_mini_logo_5, s0_.cp_mini_dark_logo AS cp_mini_dark_logo_6, s0_.favicon_logo AS favicon_logo_7 FROM site_logo s0_ WHERE s0_.id = 1
Parameters:
[]
8 0.74 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.minimal_days AS minimal_days_2, s0_.handler AS handler_3, s0_.maximum_services AS maximum_services_4, s0_.not_deleted AS not_deleted_5, s0_.allow_create AS allow_create_6, s0_.enable AS enable_7, s0_.add_class AS add_class_8, s0_.allow_options AS allow_options_9, g1_.id AS id_10, g1_.name AS name_11, s0_.group_pay_period_id AS group_pay_period_id_12, s0_.antiddos_group_id AS antiddos_group_id_13 FROM service_type s0_ LEFT JOIN group_pay_period g1_ ON s0_.group_pay_period_id = g1_.id WHERE s0_.handler IS NOT NULL AND s0_.not_deleted = 1 ORDER BY s0_.id ASC
Parameters:
[]
9 0.79 ms
SELECT s0_.id AS id_0, s0_.web_logo AS web_logo_1, s0_.cp_logo AS cp_logo_2, s0_.white_logo AS white_logo_3, s0_.email_logo AS email_logo_4, s0_.cp_mini_logo AS cp_mini_logo_5, s0_.cp_mini_dark_logo AS cp_mini_dark_logo_6, s0_.favicon_logo AS favicon_logo_7 FROM site_logo s0_ WHERE s0_.id = 1
Parameters:
[]

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\SystemConfig 21
App\Entity\ServiceType 10
App\Entity\Tarif 6
App\Entity\TarifTag 3
App\Entity\TarifCategory 2
App\Entity\GroupPayPeriod 1

Entities Mapping