Query Metrics
9
Database Queries
7
Different statements
7.62 ms
Query time
0
Invalid entities
43
Managed entities
Queries
| #▲ | 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
| Class | Mapping errors |
|---|---|
| App\Entity\SystemConfig | No errors. |
| App\Entity\UserTicketBan | No errors. |
| App\Entity\News | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Tarif | No errors. |
| App\Entity\TarifCategory | No errors. |
| App\Entity\TarifTag | No errors. |
| Panel\Server\Entity\TarifOption | No errors. |
| App\Entity\MetaData | No errors. |
| App\Entity\SiteLogo | No errors. |
| App\Entity\ServiceType | No errors. |
| App\Entity\GroupPayPeriod | No errors. |
| Panel\Antiddos\Entity\AntiddosGroup | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\PayPeriod | No errors. |