GET https://delo.arbbit.dns.rdbx.dev/checks?page=4

Response
200 OK
IP
216.73.216.197
Profiled on
Token
7d4c15

Query Metrics

4 Database Queries
4 Different statements
21.16 ms Query time
0 Invalid entities
41 Managed entities

Queries

Group similar statements

#▲ Time Info
1 8.15 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.number AS number_2, c0_.status AS status_3, c0_.check_type AS check_type_4, c0_.procedure_type AS procedure_type_5, c0_.period_from AS period_from_6, c0_.period_to AS period_to_7, c0_.started_at AS started_at_8, c0_.finished_at AS finished_at_9, c0_.approved_at AS approved_at_10, c0_.failed_at AS failed_at_11, c0_.risk_level AS risk_level_12, c0_.violations_count AS violations_count_13, c0_.auto_detected_count AS auto_detected_count_14, c0_.manual_detected_count AS manual_detected_count_15, c0_.summary AS summary_16, c0_.notes AS notes_17, c0_.created_by_user_identifier AS created_by_user_identifier_18, c0_.updated_by_user_identifier AS updated_by_user_identifier_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, a1_.id AS id_22, a1_.full_name AS full_name_23, a1_.last_name AS last_name_24, a1_.first_name AS first_name_25, a1_.middle_name AS middle_name_26, a1_.registration_number AS registration_number_27, a1_.inn AS inn_28, a1_.snils AS snils_29, a1_.email AS email_30, a1_.phone AS phone_31, a1_.sro_name AS sro_name_32, a1_.sro_registration_number AS sro_registration_number_33, a1_.status AS status_34, a1_.created_at AS created_at_35, a1_.updated_at AS updated_at_36, b2_.id AS id_37, b2_.case_number AS case_number_38, b2_.court_name AS court_name_39, b2_.court_region AS court_region_40, b2_.procedure_type AS procedure_type_41, b2_.started_at AS started_at_42, b2_.ended_at AS ended_at_43, b2_.status AS status_44, b2_.judge_name AS judge_name_45, b2_.external_reference AS external_reference_46, b2_.created_at AS created_at_47, b2_.updated_at AS updated_at_48, d3_.id AS id_49, d3_.type AS type_50, d3_.full_name AS full_name_51, d3_.short_name AS short_name_52, d3_.inn AS inn_53, d3_.ogrn AS ogrn_54, d3_.ogrnip AS ogrnip_55, d3_.address AS address_56, d3_.created_at AS created_at_57, d3_.updated_at AS updated_at_58 FROM delo.checks c0_ LEFT JOIN delo.arbitration_manager a1_ ON c0_.arbitration_manager_id = a1_.id LEFT JOIN delo.bankruptcy_case b2_ ON c0_.bankruptcy_case_id = b2_.id LEFT JOIN delo.debtor d3_ ON c0_.debtor_id = d3_.id ORDER BY c0_.created_at DESC, c0_.id DESC) dctrn_result) dctrn_table
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 2.78 ms 
SELECT DISTINCT id_0, MIN(sclr_59) AS dctrn_minrownum FROM (SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.number AS number_2, c0_.status AS status_3, c0_.check_type AS check_type_4, c0_.procedure_type AS procedure_type_5, c0_.period_from AS period_from_6, c0_.period_to AS period_to_7, c0_.started_at AS started_at_8, c0_.finished_at AS finished_at_9, c0_.approved_at AS approved_at_10, c0_.failed_at AS failed_at_11, c0_.risk_level AS risk_level_12, c0_.violations_count AS violations_count_13, c0_.auto_detected_count AS auto_detected_count_14, c0_.manual_detected_count AS manual_detected_count_15, c0_.summary AS summary_16, c0_.notes AS notes_17, c0_.created_by_user_identifier AS created_by_user_identifier_18, c0_.updated_by_user_identifier AS updated_by_user_identifier_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, a1_.id AS id_22, a1_.full_name AS full_name_23, a1_.last_name AS last_name_24, a1_.first_name AS first_name_25, a1_.middle_name AS middle_name_26, a1_.registration_number AS registration_number_27, a1_.inn AS inn_28, a1_.snils AS snils_29, a1_.email AS email_30, a1_.phone AS phone_31, a1_.sro_name AS sro_name_32, a1_.sro_registration_number AS sro_registration_number_33, a1_.status AS status_34, a1_.created_at AS created_at_35, a1_.updated_at AS updated_at_36, b2_.id AS id_37, b2_.case_number AS case_number_38, b2_.court_name AS court_name_39, b2_.court_region AS court_region_40, b2_.procedure_type AS procedure_type_41, b2_.started_at AS started_at_42, b2_.ended_at AS ended_at_43, b2_.status AS status_44, b2_.judge_name AS judge_name_45, b2_.external_reference AS external_reference_46, b2_.created_at AS created_at_47, b2_.updated_at AS updated_at_48, d3_.id AS id_49, d3_.type AS type_50, d3_.full_name AS full_name_51, d3_.short_name AS short_name_52, d3_.inn AS inn_53, d3_.ogrn AS ogrn_54, d3_.ogrnip AS ogrnip_55, d3_.address AS address_56, d3_.created_at AS created_at_57, d3_.updated_at AS updated_at_58, ROW_NUMBER() OVER(ORDER BY c0_.created_at DESC, c0_.id DESC) AS sclr_59 FROM delo.checks c0_ LEFT JOIN delo.arbitration_manager a1_ ON c0_.arbitration_manager_id = a1_.id LEFT JOIN delo.bankruptcy_case b2_ ON c0_.bankruptcy_case_id = b2_.id LEFT JOIN delo.debtor d3_ ON c0_.debtor_id = d3_.id) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 15 OFFSET 45
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 2.85 ms 
SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.number AS number_2, c0_.status AS status_3, c0_.check_type AS check_type_4, c0_.procedure_type AS procedure_type_5, c0_.period_from AS period_from_6, c0_.period_to AS period_to_7, c0_.started_at AS started_at_8, c0_.finished_at AS finished_at_9, c0_.approved_at AS approved_at_10, c0_.failed_at AS failed_at_11, c0_.risk_level AS risk_level_12, c0_.violations_count AS violations_count_13, c0_.auto_detected_count AS auto_detected_count_14, c0_.manual_detected_count AS manual_detected_count_15, c0_.summary AS summary_16, c0_.notes AS notes_17, c0_.created_by_user_identifier AS created_by_user_identifier_18, c0_.updated_by_user_identifier AS updated_by_user_identifier_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, a1_.id AS id_22, a1_.full_name AS full_name_23, a1_.last_name AS last_name_24, a1_.first_name AS first_name_25, a1_.middle_name AS middle_name_26, a1_.registration_number AS registration_number_27, a1_.inn AS inn_28, a1_.snils AS snils_29, a1_.email AS email_30, a1_.phone AS phone_31, a1_.sro_name AS sro_name_32, a1_.sro_registration_number AS sro_registration_number_33, a1_.status AS status_34, a1_.created_at AS created_at_35, a1_.updated_at AS updated_at_36, b2_.id AS id_37, b2_.case_number AS case_number_38, b2_.court_name AS court_name_39, b2_.court_region AS court_region_40, b2_.procedure_type AS procedure_type_41, b2_.started_at AS started_at_42, b2_.ended_at AS ended_at_43, b2_.status AS status_44, b2_.judge_name AS judge_name_45, b2_.external_reference AS external_reference_46, b2_.created_at AS created_at_47, b2_.updated_at AS updated_at_48, d3_.id AS id_49, d3_.type AS type_50, d3_.full_name AS full_name_51, d3_.short_name AS short_name_52, d3_.inn AS inn_53, d3_.ogrn AS ogrn_54, d3_.ogrnip AS ogrnip_55, d3_.address AS address_56, d3_.created_at AS created_at_57, d3_.updated_at AS updated_at_58, c0_.arbitration_manager_id AS arbitration_manager_id_59, c0_.bankruptcy_case_id AS bankruptcy_case_id_60, c0_.debtor_id AS debtor_id_61, c0_.inspection_scenario_id AS inspection_scenario_id_62, b2_.debtor_id AS debtor_id_63, b2_.current_arbitration_manager_id AS current_arbitration_manager_id_64 FROM delo.checks c0_ LEFT JOIN delo.arbitration_manager a1_ ON c0_.arbitration_manager_id = a1_.id LEFT JOIN delo.bankruptcy_case b2_ ON c0_.bankruptcy_case_id = b2_.id LEFT JOIN delo.debtor d3_ ON c0_.debtor_id = d3_.id WHERE c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.created_at DESC, c0_.id DESC
Parameters: 
[
  49
  48
  47
  46
  45
  44
  43
  42
  41
  40
  39
  38
  37
  36
  35
]
View formatted query    View runnable query    Explain query    View query backtrace
4 7.38 ms 
SELECT
    checks.public_id                                      AS public_id,
    d.start_check_at                                      AS start_check_at,
    d.end_check_at                                        AS end_check_at,
    EXTRACT(EPOCH FROM (d.end_check_at - d.start_check_at)) AS duration_seconds,
    to_char(
        d.end_check_at - d.start_check_at,
        'DD" дн. "HH24:MI:SS'
    ) AS duration_human
FROM delo.checks
INNER JOIN (
    SELECT
        check_id,
        MIN(checks.created_at)                     AS start_check_at,
        MAX(check_requirement_result.updated_at)  AS end_check_at
    FROM delo.check_requirement_result
    INNER JOIN delo.checks ON checks.id = check_requirement_result.check_id
    GROUP BY check_id
) AS d ON d.check_id = checks.id
WHERE checks.public_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "2bae2003-22b5-488e-be0f-afcfb86efbaf"
  "f61622b0-d700-4432-aff7-0291e123c3f7"
  "6a6d0e8b-3cfb-4a71-8254-412e21a8eacf"
  "09c798c9-a880-4367-9ad0-1e1401524ed0"
  "c9e38177-699f-4c7e-aed9-0d536e9343ee"
  "81cfe8c8-11e3-4d08-abaa-da4d497ef851"
  "8a8b376d-f6de-419f-a62c-4f762d57acbe"
  "5a14b3ac-3788-4e55-aeb3-e6c80dc1f5d8"
  "c3f50779-418b-4c83-a4d7-d1a6d0f878a7"
  "e952788f-07ff-4669-b62b-b0f890c07a5d"
  "7578ca28-9d6a-4472-a750-af63e4270590"
  "cb898987-2c0d-448b-ac89-c4f2e00fe99c"
  "f2c92b27-0a76-4cac-b7c1-5dd0957c2b4e"
  "1e650f47-158f-4c0e-9220-9274dace1f35"
  "a09fe39a-af81-49bf-83a0-8aabeb8747fa"
]
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
Redbox\DeloBundle\Entity\Check 15
Redbox\DeloBundle\Entity\Debtor 14
Redbox\DeloBundle\Entity\BankruptcyCase 10
Redbox\DeloBundle\Entity\ArbitrationManager 2

Entities Mapping

Class Mapping errors
Redbox\DeloBundle\Entity\Check No errors.
Redbox\DeloBundle\Entity\ArbitrationManager No errors.
Redbox\DeloBundle\Entity\BankruptcyCase No errors.
Redbox\DeloBundle\Entity\Debtor No errors.
Redbox\DeloBundle\Entity\InspectionScenario No errors.
Redbox\DeloBundle\Entity\CheckDocument No errors.
Redbox\DeloBundle\Entity\CheckRequirementResult No errors.
Redbox\DeloBundle\Entity\Violation No errors.
Redbox\DeloBundle\Entity\AgentRun No errors.
Redbox\DeloBundle\Entity\GeneratedDocument No errors.
Redbox\DeloBundle\Entity\CheckComment No errors.