GET https://delo.arbbit.dns.rdbx.dev/violations

Response
200 OK
IP
216.73.216.197
Profiled on
Token
018f02

Query Metrics

2 Database Queries
2 Different statements
12.10 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 9.51 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.title AS title_2, v0_.description AS description_3, v0_.norm_reference AS norm_reference_4, v0_.risk_level AS risk_level_5, v0_.status AS status_6, v0_.detected_at AS detected_at_7, v0_.confirmed_at AS confirmed_at_8, v0_.closed_at AS closed_at_9, v0_.source_type AS source_type_10, v0_.evidence_text AS evidence_text_11, v0_.legal_consequence AS legal_consequence_12, v0_.created_at AS created_at_13, v0_.updated_at AS updated_at_14, c1_.id AS id_15, c1_.public_id AS public_id_16, c1_.number AS number_17, c1_.status AS status_18, c1_.check_type AS check_type_19, c1_.procedure_type AS procedure_type_20, c1_.period_from AS period_from_21, c1_.period_to AS period_to_22, c1_.started_at AS started_at_23, c1_.finished_at AS finished_at_24, c1_.approved_at AS approved_at_25, c1_.failed_at AS failed_at_26, c1_.risk_level AS risk_level_27, c1_.violations_count AS violations_count_28, c1_.auto_detected_count AS auto_detected_count_29, c1_.manual_detected_count AS manual_detected_count_30, c1_.summary AS summary_31, c1_.notes AS notes_32, c1_.created_by_user_identifier AS created_by_user_identifier_33, c1_.updated_by_user_identifier AS updated_by_user_identifier_34, c1_.created_at AS created_at_35, c1_.updated_at AS updated_at_36, a2_.id AS id_37, a2_.full_name AS full_name_38, a2_.last_name AS last_name_39, a2_.first_name AS first_name_40, a2_.middle_name AS middle_name_41, a2_.registration_number AS registration_number_42, a2_.inn AS inn_43, a2_.snils AS snils_44, a2_.email AS email_45, a2_.phone AS phone_46, a2_.sro_name AS sro_name_47, a2_.sro_registration_number AS sro_registration_number_48, a2_.status AS status_49, a2_.created_at AS created_at_50, a2_.updated_at AS updated_at_51, b3_.id AS id_52, b3_.case_number AS case_number_53, b3_.court_name AS court_name_54, b3_.court_region AS court_region_55, b3_.procedure_type AS procedure_type_56, b3_.started_at AS started_at_57, b3_.ended_at AS ended_at_58, b3_.status AS status_59, b3_.judge_name AS judge_name_60, b3_.external_reference AS external_reference_61, b3_.created_at AS created_at_62, b3_.updated_at AS updated_at_63, r4_.id AS id_64, r4_.code AS code_65, r4_.name AS name_66, r4_.description AS description_67, r4_.category AS category_68, r4_.razdel AS razdel_69, r4_.procedure_type AS procedure_type_70, r4_.norm_reference AS norm_reference_71, r4_.severity AS severity_72, r4_.is_active AS is_active_73, r4_.config AS config_74, r4_.python_script AS python_script_75, r4_.created_at AS created_at_76, r4_.updated_at AS updated_at_77 FROM delo.violation v0_ LEFT JOIN delo.checks c1_ ON v0_.check_id = c1_.id LEFT JOIN delo.arbitration_manager a2_ ON v0_.arbitration_manager_id = a2_.id LEFT JOIN delo.bankruptcy_case b3_ ON v0_.bankruptcy_case_id = b3_.id LEFT JOIN delo.requirement r4_ ON v0_.requirement_id = r4_.id ORDER BY v0_.detected_at DESC, v0_.id DESC) dctrn_result) dctrn_table
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 2.59 ms 
SELECT DISTINCT id_0, MIN(sclr_78) AS dctrn_minrownum FROM (SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.title AS title_2, v0_.description AS description_3, v0_.norm_reference AS norm_reference_4, v0_.risk_level AS risk_level_5, v0_.status AS status_6, v0_.detected_at AS detected_at_7, v0_.confirmed_at AS confirmed_at_8, v0_.closed_at AS closed_at_9, v0_.source_type AS source_type_10, v0_.evidence_text AS evidence_text_11, v0_.legal_consequence AS legal_consequence_12, v0_.created_at AS created_at_13, v0_.updated_at AS updated_at_14, c1_.id AS id_15, c1_.public_id AS public_id_16, c1_.number AS number_17, c1_.status AS status_18, c1_.check_type AS check_type_19, c1_.procedure_type AS procedure_type_20, c1_.period_from AS period_from_21, c1_.period_to AS period_to_22, c1_.started_at AS started_at_23, c1_.finished_at AS finished_at_24, c1_.approved_at AS approved_at_25, c1_.failed_at AS failed_at_26, c1_.risk_level AS risk_level_27, c1_.violations_count AS violations_count_28, c1_.auto_detected_count AS auto_detected_count_29, c1_.manual_detected_count AS manual_detected_count_30, c1_.summary AS summary_31, c1_.notes AS notes_32, c1_.created_by_user_identifier AS created_by_user_identifier_33, c1_.updated_by_user_identifier AS updated_by_user_identifier_34, c1_.created_at AS created_at_35, c1_.updated_at AS updated_at_36, a2_.id AS id_37, a2_.full_name AS full_name_38, a2_.last_name AS last_name_39, a2_.first_name AS first_name_40, a2_.middle_name AS middle_name_41, a2_.registration_number AS registration_number_42, a2_.inn AS inn_43, a2_.snils AS snils_44, a2_.email AS email_45, a2_.phone AS phone_46, a2_.sro_name AS sro_name_47, a2_.sro_registration_number AS sro_registration_number_48, a2_.status AS status_49, a2_.created_at AS created_at_50, a2_.updated_at AS updated_at_51, b3_.id AS id_52, b3_.case_number AS case_number_53, b3_.court_name AS court_name_54, b3_.court_region AS court_region_55, b3_.procedure_type AS procedure_type_56, b3_.started_at AS started_at_57, b3_.ended_at AS ended_at_58, b3_.status AS status_59, b3_.judge_name AS judge_name_60, b3_.external_reference AS external_reference_61, b3_.created_at AS created_at_62, b3_.updated_at AS updated_at_63, r4_.id AS id_64, r4_.code AS code_65, r4_.name AS name_66, r4_.description AS description_67, r4_.category AS category_68, r4_.razdel AS razdel_69, r4_.procedure_type AS procedure_type_70, r4_.norm_reference AS norm_reference_71, r4_.severity AS severity_72, r4_.is_active AS is_active_73, r4_.config AS config_74, r4_.python_script AS python_script_75, r4_.created_at AS created_at_76, r4_.updated_at AS updated_at_77, ROW_NUMBER() OVER(ORDER BY v0_.detected_at DESC, v0_.id DESC) AS sclr_78 FROM delo.violation v0_ LEFT JOIN delo.checks c1_ ON v0_.check_id = c1_.id LEFT JOIN delo.arbitration_manager a2_ ON v0_.arbitration_manager_id = a2_.id LEFT JOIN delo.bankruptcy_case b3_ ON v0_.bankruptcy_case_id = b3_.id LEFT JOIN delo.requirement r4_ ON v0_.requirement_id = r4_.id) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 18
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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

Entities Mapping

Class Mapping errors
Redbox\DeloBundle\Entity\Violation No errors.
Redbox\DeloBundle\Entity\Check No errors.
Redbox\DeloBundle\Entity\ArbitrationManager No errors.
Redbox\DeloBundle\Entity\BankruptcyCase No errors.
Redbox\DeloBundle\Entity\Requirement No errors.