Query Metrics
4
Database Queries
4
Different statements
2.83 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.26 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.hidden AS hidden_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.mail_action_hash AS mail_action_hash_10, t0.mail_action_mode AS mail_action_mode_11, t0.locale AS locale_12, t0.last_password_change AS last_password_change_13, t0.sys_user AS sys_user_14, t0.mail_cc AS mail_cc_15, t0.auto_fill_orderer_details_in_new_order AS auto_fill_orderer_details_in_new_order_16, t0.fcm_tokens AS fcm_tokens_17, t0.telegram_id AS telegram_id_18, t0.shared_key AS shared_key_19, t0.enable_time_tracking AS enable_time_tracking_20, t0.short_code AS short_code_21, t0.dashboards AS dashboards_22, t0.be_created AS be_created_23, t0.be_edited AS be_edited_24, t0.be_deleted AS be_deleted_25, t0.be_comment AS be_comment_26, t0.customer_id AS customer_id_27, t0.current_substitute_user_id AS current_substitute_user_id_28, t0.member_id AS member_id_29, t0.profile_image_id AS profile_image_id_30, t0.home_address_id AS home_address_id_31, t0.be_owner AS be_owner_32 FROM users t0 WHERE t0.id = ? AND ((t0.be_deleted = 0))
Parameters:
[
5
]
|
2 | 0.54 ms |
SELECT t0.id AS id_1, t0.platform AS platform_2, t0.token_type AS token_type_3, t0.token AS token_4, t0.first_seen AS first_seen_5, t0.last_seen AS last_seen_6, t0.be_created AS be_created_7, t0.be_edited AS be_edited_8, t0.be_deleted AS be_deleted_9, t0.be_comment AS be_comment_10, t0.user_id AS user_id_11, t0.be_owner AS be_owner_12 FROM user_device_tokens t0 WHERE t0.user_id IN (?) AND ((t0.be_deleted = 0))
Parameters:
[
5
]
|
3 | 0.65 ms |
SELECT t0.id AS id_1, t0.document_type AS document_type_2, t0.document_number AS document_number_3, t0.document_date AS document_date_4, t0.receiver_address AS receiver_address_5, t0.status AS status_6, t0.total_net AS total_net_7, t0.accounting_month AS accounting_month_8, t0.accounting_year AS accounting_year_9, t0.sent_to_receiver AS sent_to_receiver_10, t0.header_text AS header_text_11, t0.footer_text AS footer_text_12, t0.reminder_sent_to_receiver AS reminder_sent_to_receiver_13, t0.monition1sent_to_receiver AS monition1sent_to_receiver_14, t0.monition2sent_to_receiver AS monition2sent_to_receiver_15, t0.extra_calculation_items AS extra_calculation_items_16, t0.stand_by_dispo_data AS stand_by_dispo_data_17, t0.be_created AS be_created_18, t0.be_edited AS be_edited_19, t0.be_deleted AS be_deleted_20, t0.be_comment AS be_comment_21, t0.customer_id AS customer_id_22, t0.member_id AS member_id_23, t0.pdf_file_id AS pdf_file_id_24, t25.id AS id_26, t25.file_name AS file_name_27, t25.physical_file_name AS physical_file_name_28, t25.path AS path_29, t25.type AS type_30, t25.file_size AS file_size_31, t25.be_created AS be_created_32, t25.be_edited AS be_edited_33, t25.be_deleted AS be_deleted_34, t25.be_comment AS be_comment_35, t25.be_owner AS be_owner_36, t0.billing_id AS billing_id_37, t0.treated_by_id AS treated_by_id_38, t0.reminder_pdf_id AS reminder_pdf_id_39, t40.id AS id_41, t40.file_name AS file_name_42, t40.physical_file_name AS physical_file_name_43, t40.path AS path_44, t40.type AS type_45, t40.file_size AS file_size_46, t40.be_created AS be_created_47, t40.be_edited AS be_edited_48, t40.be_deleted AS be_deleted_49, t40.be_comment AS be_comment_50, t40.be_owner AS be_owner_51, t0.monition1pdf_id AS monition1pdf_id_52, t53.id AS id_54, t53.file_name AS file_name_55, t53.physical_file_name AS physical_file_name_56, t53.path AS path_57, t53.type AS type_58, t53.file_size AS file_size_59, t53.be_created AS be_created_60, t53.be_edited AS be_edited_61, t53.be_deleted AS be_deleted_62, t53.be_comment AS be_comment_63, t53.be_owner AS be_owner_64, t0.monition2pdf_id AS monition2pdf_id_65, t66.id AS id_67, t66.file_name AS file_name_68, t66.physical_file_name AS physical_file_name_69, t66.path AS path_70, t66.type AS type_71, t66.file_size AS file_size_72, t66.be_created AS be_created_73, t66.be_edited AS be_edited_74, t66.be_deleted AS be_deleted_75, t66.be_comment AS be_comment_76, t66.be_owner AS be_owner_77, t0.extra_pdf_id AS extra_pdf_id_78, t79.id AS id_80, t79.file_name AS file_name_81, t79.physical_file_name AS physical_file_name_82, t79.path AS path_83, t79.type AS type_84, t79.file_size AS file_size_85, t79.be_created AS be_created_86, t79.be_edited AS be_edited_87, t79.be_deleted AS be_deleted_88, t79.be_comment AS be_comment_89, t79.be_owner AS be_owner_90, t0.be_owner AS be_owner_91 FROM acc_documents t0 LEFT JOIN files t25 ON t0.pdf_file_id = t25.id AND ((t25.be_deleted = 0)) LEFT JOIN files t40 ON t0.reminder_pdf_id = t40.id AND ((t40.be_deleted = 0)) LEFT JOIN files t53 ON t0.monition1pdf_id = t53.id AND ((t53.be_deleted = 0)) LEFT JOIN files t66 ON t0.monition2pdf_id = t66.id AND ((t66.be_deleted = 0)) LEFT JOIN files t79 ON t0.extra_pdf_id = t79.id AND ((t79.be_deleted = 0)) WHERE t0.id = ? AND ((t0.be_deleted = 0)) LIMIT 1
Parameters:
[
"303"
]
|
4 | 0.38 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.physical_file_name AS physical_file_name_3, t0.path AS path_4, t0.type AS type_5, t0.file_size AS file_size_6, t0.be_created AS be_created_7, t0.be_edited AS be_edited_8, t0.be_deleted AS be_deleted_9, t0.be_comment AS be_comment_10, t0.be_owner AS be_owner_11 FROM files t0 WHERE t0.id = ? AND ((t0.be_deleted = 0)) LIMIT 1
Parameters:
[
311
]
|
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 |
---|---|
Diplix\KMGBundle\Entity\User | No errors. |
Diplix\KMGBundle\Entity\Customer | No errors. |
Diplix\KMGBundle\Entity\Accounting\CoopMember | No errors. |
Diplix\KMGBundle\Entity\File | No errors. |
Diplix\KMGBundle\Entity\Address | No errors. |
Diplix\KMGBundle\Entity\Role | No errors. |
Diplix\KMGBundle\Entity\DeviceToken | No errors. |
Diplix\KMGBundle\Entity\Accounting\Document | No errors. |
Diplix\KMGBundle\Entity\Accounting\Billing | No errors. |