Query Metrics
2
Database Queries
2
Different statements
7.96 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
5.16 ms (64.84%) |
1 |
SELECT g0_.id AS id_0, g0_.type AS type_1, g0_.status AS status_2, g0_.title AS title_3, g0_.number AS number_4, g0_.content_html AS content_html_5, g0_.content_text AS content_text_6, g0_.file_path AS file_path_7, g0_.mime_type AS mime_type_8, g0_.generated_at AS generated_at_9, g0_.approved_at AS approved_at_10, g0_.created_at AS created_at_11, g0_.updated_at AS updated_at_12, c1_.id AS id_13, c1_.public_id AS public_id_14, c1_.number AS number_15, c1_.status AS status_16, c1_.check_type AS check_type_17, c1_.procedure_type AS procedure_type_18, c1_.period_from AS period_from_19, c1_.period_to AS period_to_20, c1_.started_at AS started_at_21, c1_.finished_at AS finished_at_22, c1_.approved_at AS approved_at_23, c1_.failed_at AS failed_at_24, c1_.risk_level AS risk_level_25, c1_.violations_count AS violations_count_26, c1_.auto_detected_count AS auto_detected_count_27, c1_.manual_detected_count AS manual_detected_count_28, c1_.summary AS summary_29, c1_.notes AS notes_30, c1_.created_by_user_identifier AS created_by_user_identifier_31, c1_.updated_by_user_identifier AS updated_by_user_identifier_32, c1_.created_at AS created_at_33, c1_.updated_at AS updated_at_34, g0_.check_id AS check_id_35, g0_.document_template_id AS document_template_id_36, c1_.arbitration_manager_id AS arbitration_manager_id_37, c1_.bankruptcy_case_id AS bankruptcy_case_id_38, c1_.debtor_id AS debtor_id_39, c1_.inspection_scenario_id AS inspection_scenario_id_40 FROM delo.generated_document g0_ LEFT JOIN delo.checks c1_ ON g0_.check_id = c1_.id ORDER BY g0_.generated_at DESC, g0_.id DESC LIMIT 8
Parameters:
[]
|
||||||||||||||||||||||||||
|
2.80 ms (35.16%) |
1 |
SELECT d0_.id AS id_0, d0_.code AS code_1, d0_.name AS name_2, d0_.type AS type_3, d0_.engine AS engine_4, d0_.content AS content_5, d0_.variables AS variables_6, d0_.is_active AS is_active_7, d0_.version AS version_8, d0_.created_at AS created_at_9, d0_.updated_at AS updated_at_10 FROM delo.document_template d0_ ORDER BY d0_.type ASC, d0_.name ASC
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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| Redbox\DeloBundle\Entity\DocumentTemplate | No errors. |
| Redbox\DeloBundle\Entity\GeneratedDocument | No 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. |