http://claim-demo.brokerweb.biz/export/data

Method
GET
HTTP Status
200
IP
192.168.99.152
Profiled on
Token
2d2fde

Query Metrics

45 Database Queries
2 Different statements
8.50 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.38 ms 
SELECT c0_.id AS id_0, c0_.claim_type AS claim_type_1, c0_.name AS name_2, c0_.email AS email_3, c0_.cc_email AS cc_email_4, c0_.department AS department_5, c0_.mf_type AS mf_type_6, c0_.mf_model AS mf_model_7, c0_.mf_plate AS mf_plate_8, c0_.claim_date AS claim_date_9, c0_.claim_city AS claim_city_10, c0_.claim_description AS claim_description_11, c0_.responsible AS responsible_12, c0_.claim_damage_cause AS claim_damage_cause_13, c0_.claim_damage AS claim_damage_14, c0_.damage_costs AS damage_costs_15, c0_.foreign_deductible AS foreign_deductible_16, c0_.foreign_damage_costs AS foreign_damage_costs_17, c0_.involved_person AS involved_person_18, c0_.driver AS driver_19, c0_.driver_birthdate AS driver_birthdate_20, c0_.mf_license AS mf_license_21, c0_.police_report AS police_report_22, c0_.police_report_date AS police_report_date_23, c0_.sach_owner AS sach_owner_24, c0_.damage_by AS damage_by_25, c0_.injured_person AS injured_person_26, c0_.damaged_item AS damaged_item_27, c0_.remark AS remark_28, c0_.items AS items_29, c0_.persons AS persons_30, c0_.ack_at AS ack_at_31, c0_.created_at AS created_at_32, c0_.updated_at AS updated_at_33, c0_.deleted_at AS deleted_at_34 FROM claim c0_ WHERE c0_.deleted_at IS NULL AND c0_.ack_at IS NULL ORDER BY c0_.created_at ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.26 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
3 0.20 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query
4 0.20 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
5 0.22 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query
6 0.19 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query
7 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query
8 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query
9 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  18
]
View formatted query    View runnable query    Explain query
10 0.16 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query
11 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  20
]
View formatted query    View runnable query    Explain query
12 0.23 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query
13 0.21 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  23
]
View formatted query    View runnable query    Explain query
14 0.20 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  24
]
View formatted query    View runnable query    Explain query
15 0.20 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  25
]
View formatted query    View runnable query    Explain query
16 0.18 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  27
]
View formatted query    View runnable query    Explain query
17 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query
18 0.19 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query
19 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  30
]
View formatted query    View runnable query    Explain query
20 0.19 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  31
]
View formatted query    View runnable query    Explain query
21 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  32
]
View formatted query    View runnable query    Explain query
22 0.14 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  34
]
View formatted query    View runnable query    Explain query
23 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  42
]
View formatted query    View runnable query    Explain query
24 0.19 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  43
]
View formatted query    View runnable query    Explain query
25 0.19 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query
26 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  45
]
View formatted query    View runnable query    Explain query
27 0.18 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  49
]
View formatted query    View runnable query    Explain query
28 0.18 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  51
]
View formatted query    View runnable query    Explain query
29 0.18 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  52
]
View formatted query    View runnable query    Explain query
30 0.19 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  53
]
View formatted query    View runnable query    Explain query
31 0.18 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  55
]
View formatted query    View runnable query    Explain query
32 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  57
]
View formatted query    View runnable query    Explain query
33 0.19 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  59
]
View formatted query    View runnable query    Explain query
34 0.18 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  61
]
View formatted query    View runnable query    Explain query
35 0.19 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  62
]
View formatted query    View runnable query    Explain query
36 0.15 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query
37 0.18 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  65
]
View formatted query    View runnable query    Explain query
38 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  66
]
View formatted query    View runnable query    Explain query
39 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  67
]
View formatted query    View runnable query    Explain query
40 0.19 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  68
]
View formatted query    View runnable query    Explain query
41 0.19 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  69
]
View formatted query    View runnable query    Explain query
42 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  70
]
View formatted query    View runnable query    Explain query
43 0.17 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  71
]
View formatted query    View runnable query    Explain query
44 0.23 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  72
]
View formatted query    View runnable query    Explain query
45 0.18 ms 
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.uniqid AS uniqid_3, t0.ext AS ext_4, t0.size AS size_5, t0.path AS path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.claim_id AS claim_id_10 FROM claim_file t0 WHERE t0.claim_id = ?
Parameters: 
[
  86
]
View formatted query    View runnable query    Explain query

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.

Entities Mapping

Class Mapping errors
App\Entity\Claim No errors.
App\Entity\ClaimFile No errors.