Query Metrics

64 Database Queries
12 Different statements
36.71 ms Query time
1 Invalid entities
99 Managed entities

Queries

Group similar statements

# Time Info
1 2.14 ms
SELECT count(*) AS sclr_0 FROM transactions t0_ WHERE t0_.payment_status = ? AND t0_.type IN (?, ?, ?) AND t0_.is_hidden = ?
Parameters:
[
  "succeeded"
  "yoomoney"
  "income"
  "consumption"
  "false"
]
2 1.09 ms
SELECT t0_.id AS id_0, t0_.for_everyone AS for_everyone_1, t0_.created_at AS created_at_2, t0_.updated_at AS updated_at_3, t0_.payment_method_id AS payment_method_id_4, t0_.source AS source_5, t0_.type AS type_6, t0_.status AS status_7, t0_.period AS period_8, t0_.sum AS sum_9, t0_.from_full_name AS from_full_name_10, t0_.email AS email_11, t0_.comment AS comment_12, t0_.payment_data_json AS payment_data_json_13, t0_.payment_id AS payment_id_14, t0_.payment_status AS payment_status_15, t0_.is_hidden AS is_hidden_16, t0_.is_return AS is_return_17, t0_.hide_from_statistics AS hide_from_statistics_18, t0_.commission_percent AS commission_percent_19, t0_.commission_text AS commission_text_20, t0_.parent_id AS parent_id_21, t0_.from_user_id AS from_user_id_22, t0_.help_person_id AS help_person_id_23, t0_.from_help_person_id AS from_help_person_id_24, t0_.help_program_id AS help_program_id_25, t0_.transaction_every_period_id AS transaction_every_period_id_26 FROM transactions t0_ WHERE t0_.payment_status = ? AND t0_.type IN (?, ?, ?) AND t0_.is_hidden = ? ORDER BY t0_.id DESC LIMIT 15
Parameters:
[
  "succeeded"
  "yoomoney"
  "income"
  "consumption"
  "false"
]
3 0.70 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1523
]
4 0.92 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.status AS status_3, t0.sum_necessary AS sum_necessary_4, t0.sum_collected AS sum_collected_5, t0.sum_transmitted AS sum_transmitted_6, t0.start_at AS start_at_7, t0.end_at AS end_at_8, t0.active AS active_9, t0.finished AS finished_10, t0.active_photo_block AS active_photo_block_11, t0.active_home_page AS active_home_page_12, t0.title AS title_13, t0.slug AS slug_14, t0.age AS age_15, t0.sub_title AS sub_title_16, t0.person_count AS person_count_17, t0.target AS target_18, t0.description_short AS description_short_19, t0.description_short_payment AS description_short_payment_20, t0.description AS description_21, t0.result_description AS result_description_22, t0.video AS video_23, t0.ekzeget_view_count AS ekzeget_view_count_24, t0.meta_title AS meta_title_25, t0.meta_description AS meta_description_26, t0.meta_keywords AS meta_keywords_27, t0.trustee_id AS trustee_id_28, t0.help_program_id AS help_program_id_29, t0.image_id AS image_id_30 FROM help_person t0 WHERE t0.id = ?
Parameters:
[
  60
]
5 0.85 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.sum_collected AS sum_collected_3, t0.sum_transmitted AS sum_transmitted_4, t0.active AS active_5, t0.active_home_page AS active_home_page_6, t0.title AS title_7, t0.slug AS slug_8, t0.target AS target_9, t0.start_at AS start_at_10, t0.description AS description_11, t0.description_short AS description_short_12, t0.description_short_payment AS description_short_payment_13, t0.result_description AS result_description_14, t0.video AS video_15, t0.sort_order AS sort_order_16, t0.ekzeget_view_count AS ekzeget_view_count_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.image_id AS image_id_21 FROM help_program t0 WHERE t0.id = ?
Parameters:
[
  31
]
6 5.55 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_images ON t0.id = help_program_images.image_id WHERE help_program_images.help_program_id = ?
Parameters:
[
  31
]
7 0.82 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_files ON t0.id = help_program_files.file_id WHERE help_program_files.help_program_id = ?
Parameters:
[
  31
]
8 0.69 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_report_images ON t0.id = help_program_report_images.image_id WHERE help_program_report_images.help_program_id = ?
Parameters:
[
  31
]
9 0.63 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_images ON t0.id = help_person_images.image_id WHERE help_person_images.help_person_id = ?
Parameters:
[
  60
]
10 0.59 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_files ON t0.id = help_person_files.file_id WHERE help_person_files.help_person_id = ?
Parameters:
[
  60
]
11 0.60 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_report_images ON t0.id = help_person_report_images.image_id WHERE help_person_report_images.help_person_id = ?
Parameters:
[
  60
]
12 0.63 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1523
]
13 0.32 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1519
]
14 0.56 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.sum_collected AS sum_collected_3, t0.sum_transmitted AS sum_transmitted_4, t0.active AS active_5, t0.active_home_page AS active_home_page_6, t0.title AS title_7, t0.slug AS slug_8, t0.target AS target_9, t0.start_at AS start_at_10, t0.description AS description_11, t0.description_short AS description_short_12, t0.description_short_payment AS description_short_payment_13, t0.result_description AS result_description_14, t0.video AS video_15, t0.sort_order AS sort_order_16, t0.ekzeget_view_count AS ekzeget_view_count_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.image_id AS image_id_21 FROM help_program t0 WHERE t0.id = ?
Parameters:
[
  28
]
15 0.58 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_images ON t0.id = help_program_images.image_id WHERE help_program_images.help_program_id = ?
Parameters:
[
  28
]
16 0.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_files ON t0.id = help_program_files.file_id WHERE help_program_files.help_program_id = ?
Parameters:
[
  28
]
17 0.41 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_report_images ON t0.id = help_program_report_images.image_id WHERE help_program_report_images.help_program_id = ?
Parameters:
[
  28
]
18 0.46 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1519
]
19 0.38 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1518
]
20 1.67 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1518
]
21 0.37 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1517
]
22 0.33 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.sum_collected AS sum_collected_3, t0.sum_transmitted AS sum_transmitted_4, t0.active AS active_5, t0.active_home_page AS active_home_page_6, t0.title AS title_7, t0.slug AS slug_8, t0.target AS target_9, t0.start_at AS start_at_10, t0.description AS description_11, t0.description_short AS description_short_12, t0.description_short_payment AS description_short_payment_13, t0.result_description AS result_description_14, t0.video AS video_15, t0.sort_order AS sort_order_16, t0.ekzeget_view_count AS ekzeget_view_count_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.image_id AS image_id_21 FROM help_program t0 WHERE t0.id = ?
Parameters:
[
  24
]
23 0.40 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_images ON t0.id = help_program_images.image_id WHERE help_program_images.help_program_id = ?
Parameters:
[
  24
]
24 0.34 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_files ON t0.id = help_program_files.file_id WHERE help_program_files.help_program_id = ?
Parameters:
[
  24
]
25 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_report_images ON t0.id = help_program_report_images.image_id WHERE help_program_report_images.help_program_id = ?
Parameters:
[
  24
]
26 0.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1517
]
27 0.31 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1516
]
28 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1516
]
29 0.44 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1514
]
30 0.36 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.status AS status_3, t0.sum_necessary AS sum_necessary_4, t0.sum_collected AS sum_collected_5, t0.sum_transmitted AS sum_transmitted_6, t0.start_at AS start_at_7, t0.end_at AS end_at_8, t0.active AS active_9, t0.finished AS finished_10, t0.active_photo_block AS active_photo_block_11, t0.active_home_page AS active_home_page_12, t0.title AS title_13, t0.slug AS slug_14, t0.age AS age_15, t0.sub_title AS sub_title_16, t0.person_count AS person_count_17, t0.target AS target_18, t0.description_short AS description_short_19, t0.description_short_payment AS description_short_payment_20, t0.description AS description_21, t0.result_description AS result_description_22, t0.video AS video_23, t0.ekzeget_view_count AS ekzeget_view_count_24, t0.meta_title AS meta_title_25, t0.meta_description AS meta_description_26, t0.meta_keywords AS meta_keywords_27, t0.trustee_id AS trustee_id_28, t0.help_program_id AS help_program_id_29, t0.image_id AS image_id_30 FROM help_person t0 WHERE t0.id = ?
Parameters:
[
  65
]
31 0.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_images ON t0.id = help_person_images.image_id WHERE help_person_images.help_person_id = ?
Parameters:
[
  65
]
32 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_files ON t0.id = help_person_files.file_id WHERE help_person_files.help_person_id = ?
Parameters:
[
  65
]
33 0.47 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_report_images ON t0.id = help_person_report_images.image_id WHERE help_person_report_images.help_person_id = ?
Parameters:
[
  65
]
34 0.54 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1514
]
35 0.40 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1513
]
36 0.52 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1513
]
37 0.41 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1512
]
38 0.51 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1512
]
39 0.30 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1510
]
40 0.51 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1510
]
41 0.27 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1509
]
42 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1509
]
43 0.41 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1508
]
44 0.49 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1508
]
45 0.32 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1507
]
46 0.46 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1507
]
47 0.27 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1506
]
48 0.49 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1506
]
49 0.26 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1504
]
50 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1504
]
51 0.21 ms
SELECT t0.id AS id_1, t0.sum AS sum_2, t0.transaction_id AS transaction_id_3, t0.help_person_id AS help_person_id_4 FROM sub_transaction t0 WHERE t0.transaction_id = ?
Parameters:
[
  1502
]
52 0.49 ms
SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.status AS status_3, t0.sum_necessary AS sum_necessary_4, t0.sum_collected AS sum_collected_5, t0.sum_transmitted AS sum_transmitted_6, t0.start_at AS start_at_7, t0.end_at AS end_at_8, t0.active AS active_9, t0.finished AS finished_10, t0.active_photo_block AS active_photo_block_11, t0.active_home_page AS active_home_page_12, t0.title AS title_13, t0.slug AS slug_14, t0.age AS age_15, t0.sub_title AS sub_title_16, t0.person_count AS person_count_17, t0.target AS target_18, t0.description_short AS description_short_19, t0.description_short_payment AS description_short_payment_20, t0.description AS description_21, t0.result_description AS result_description_22, t0.video AS video_23, t0.ekzeget_view_count AS ekzeget_view_count_24, t0.meta_title AS meta_title_25, t0.meta_description AS meta_description_26, t0.meta_keywords AS meta_keywords_27, t0.trustee_id AS trustee_id_28, t0.help_program_id AS help_program_id_29, t0.image_id AS image_id_30 FROM help_person t0 WHERE t0.id = ?
Parameters:
[
  59
]
53 0.38 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.sum_collected AS sum_collected_3, t0.sum_transmitted AS sum_transmitted_4, t0.active AS active_5, t0.active_home_page AS active_home_page_6, t0.title AS title_7, t0.slug AS slug_8, t0.target AS target_9, t0.start_at AS start_at_10, t0.description AS description_11, t0.description_short AS description_short_12, t0.description_short_payment AS description_short_payment_13, t0.result_description AS result_description_14, t0.video AS video_15, t0.sort_order AS sort_order_16, t0.ekzeget_view_count AS ekzeget_view_count_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.image_id AS image_id_21 FROM help_program t0 WHERE t0.id = ?
Parameters:
[
  26
]
54 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_images ON t0.id = help_program_images.image_id WHERE help_program_images.help_program_id = ?
Parameters:
[
  26
]
55 0.50 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_files ON t0.id = help_program_files.file_id WHERE help_program_files.help_program_id = ?
Parameters:
[
  26
]
56 0.35 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_report_images ON t0.id = help_program_report_images.image_id WHERE help_program_report_images.help_program_id = ?
Parameters:
[
  26
]
57 0.41 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_images ON t0.id = help_person_images.image_id WHERE help_person_images.help_person_id = ?
Parameters:
[
  59
]
58 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_files ON t0.id = help_person_files.file_id WHERE help_person_files.help_person_id = ?
Parameters:
[
  59
]
59 0.39 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_person_report_images ON t0.id = help_person_report_images.image_id WHERE help_person_report_images.help_person_id = ?
Parameters:
[
  59
]
60 0.29 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.sum_collected AS sum_collected_3, t0.sum_transmitted AS sum_transmitted_4, t0.active AS active_5, t0.active_home_page AS active_home_page_6, t0.title AS title_7, t0.slug AS slug_8, t0.target AS target_9, t0.start_at AS start_at_10, t0.description AS description_11, t0.description_short AS description_short_12, t0.description_short_payment AS description_short_payment_13, t0.result_description AS result_description_14, t0.video AS video_15, t0.sort_order AS sort_order_16, t0.ekzeget_view_count AS ekzeget_view_count_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.image_id AS image_id_21 FROM help_program t0 WHERE t0.id = ?
Parameters:
[
  27
]
61 0.32 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_images ON t0.id = help_program_images.image_id WHERE help_program_images.help_program_id = ?
Parameters:
[
  27
]
62 0.33 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_files ON t0.id = help_program_files.file_id WHERE help_program_files.help_program_id = ?
Parameters:
[
  27
]
63 0.29 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN help_program_report_images ON t0.id = help_program_report_images.image_id WHERE help_program_report_images.help_program_id = ?
Parameters:
[
  27
]
64 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.private AS private_3, t0.sort AS sort_4, t0.file_path AS file_path_5 FROM media t0 INNER JOIN transaction_files ON t0.id = transaction_files.file_id WHERE transaction_files.transaction_id = ?
Parameters:
[
  1502
]

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\Media 57
App\Entity\Transaction 15
App\Entity\SubTransaction 12
App\Entity\User 5
App\Entity\HelpProgram 5
App\Entity\HelpPerson 3
App\Entity\Trustee 2

Entities Mapping

Class Mapping errors
App\Entity\Transaction No errors.
App\Entity\SubTransaction No errors.
App\Entity\HelpPerson No errors.
App\Entity\Trustee No errors.
App\Entity\Media No errors.
App\Entity\HelpProgram No errors.
App\Entity\User
  • The field App\Entity\User#transactions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Transaction#fromUser does not contain the required 'inversedBy="transactions"' attribute.
App\Entity\TransactionEveryPeriod No errors.