https://www.czescidlaserwisu.pl/privatemessage/get_messages/68871

Query Metrics

9 Database Queries
7 Different statements
153.31 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
150.92 ms
(98.44%)
1
SELECT t0.id AS id_1, t0.content AS content_2, t0.entity_type AS entity_type_3, t0.entity_id AS entity_id_4, t0.content_id AS content_id_5, t0.is_read AS is_read_6, t0.read_at AS read_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.active AS active_10, t0.author_id AS author_id_11, t0.recipient_id AS recipient_id_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14 FROM notification t0 WHERE t0.entity_type = ? AND t0.entity_id = ? AND t0.content_id IN (?, ?)
Parameters:
[
  "offer"
  "68871"
  105374
  105259
]
0.71 ms
(0.46%)
2
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.nip AS nip_3, t0.username AS username_4, t0.password AS password_5, t0.phone_number AS phone_number_6, t0.last_inquiry_date AS last_inquiry_date_7, t0.last_offer_date AS last_offer_date_8, t0.is_recipient AS is_recipient_9, t0.is_supplier AS is_supplier_10, t0.roles AS roles_11, t0.salt AS salt_12, t0.register_key AS register_key_13, t0.reset_password_key AS reset_password_key_14, t0.zip_code AS zip_code_15, t0.city AS city_16, t0.street AS street_17, t0.property_number AS property_number_18, t0.apartment_number AS apartment_number_19, t0.show_other_offers AS show_other_offers_20, t0.dont_show_company_name_other_offers AS dont_show_company_name_other_offers_21, t0.igp AS igp_22, t0.can_choose_suppliers AS can_choose_suppliers_23, t0.can_see_supplier_data AS can_see_supplier_data_24, t0.show_other_offers_before_purchase AS show_other_offers_before_purchase_25, t0.show_only_retail_price_and_delivery_date AS show_only_retail_price_and_delivery_date_26, t0.notifications_offer_notification AS notifications_offer_notification_27, t0.notifications_offer_mail AS notifications_offer_mail_28, t0.notifications_inquiry_notification AS notifications_inquiry_notification_29, t0.notifications_inquiry_mail AS notifications_inquiry_mail_30, t0.notifications_invoice_notification AS notifications_invoice_notification_31, t0.notifications_invoice_mail AS notifications_invoice_mail_32, t0.can_delete_private_messages AS can_delete_private_messages_33, t0.can_see_other_suppliers_of_his_makes AS can_see_other_suppliers_of_his_makes_34, t0.can_get_notifications_about_better_offer AS can_get_notifications_about_better_offer_35, t0.delivery_for_whole_country AS delivery_for_whole_country_36, t0.show_message_for_customer AS show_message_for_customer_37, t0.message_for_customer AS message_for_customer_38, t0.warn_suppliers_about_this_customer_payments AS warn_suppliers_about_this_customer_payments_39, t0.avoid_user_for_create_new_inquiries AS avoid_user_for_create_new_inquiries_40, t0.show_stats_for_supplier AS show_stats_for_supplier_41, t0.supplier_card AS supplier_card_42, t0.supplier_card_short AS supplier_card_short_43, t0.supplier_card_active AS supplier_card_active_44, t0.show_won_offers_total_value AS show_won_offers_total_value_45, t0.show_ordered_parts_stats AS show_ordered_parts_stats_46, t0.regulations_accepted AS regulations_accepted_47, t0.created_at AS created_at_48, t0.updated_at AS updated_at_49, t0.active AS active_50, t0.created_by_id AS created_by_id_51, t0.updated_by_id AS updated_by_id_52 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  34
]
0.46 ms
(0.30%)
1
SELECT t0.id AS id_1, t0.retail_price AS retail_price_2, t0.discount AS discount_3, t0.delivery_price AS delivery_price_4, t0.total_price AS total_price_5, t0.status AS status_6, t0.chosen AS chosen_7, t0.price_after_discount AS price_after_discount_8, t0.notices AS notices_9, t0.comment AS comment_10, t0.is_rejected AS is_rejected_11, t0.state AS state_12, t0.payment_method AS payment_method_13, t0.choose_date AS choose_date_14, t0.delivery_time AS delivery_time_15, t0.parts_ordered AS parts_ordered_16, t0.file_upload_id AS file_upload_id_17, t0.ordered_date AS ordered_date_18, t0.request_invoice AS request_invoice_19, t0.send_date AS send_date_20, t0.parts_sended AS parts_sended_21, t0.order_mode AS order_mode_22, t0.seen_by_recipient AS seen_by_recipient_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.active AS active_26, t0.supplier_id AS supplier_id_27, t0.inquiry_id AS inquiry_id_28, t0.invoice_file_id AS invoice_file_id_29, t0.contact_person_id AS contact_person_id_30, t0.created_by_id AS created_by_id_31, t0.updated_by_id AS updated_by_id_32 FROM offer t0 WHERE t0.id = ?
Parameters:
[
  "68871"
]
0.40 ms
(0.26%)
2
SELECT t0.id AS id_1, t0.original_file_name AS original_file_name_2, t0.file_path AS file_path_3, t0.file_type AS file_type_4, t0.mime_type AS mime_type_5, t0.width AS width_6, t0.height AS height_7, t0.url AS url_8, t0.url_validity_date AS url_validity_date_9, t0.sent_to_google_storage AS sent_to_google_storage_10, t0.private_message_id AS private_message_id_11 FROM private_message_attachment t0 WHERE t0.private_message_id = ?
Parameters:
[
  105374
]
0.34 ms
(0.22%)
1
SELECT t0.id AS id_1, t0.expiration_date AS expiration_date_2, t0.status AS status_3, t0.vin AS vin_4, t0.model AS model_5, t0.registration_number AS registration_number_6, t0.notices AS notices_7, t0.archived AS archived_8, t0.file_upload_id AS file_upload_id_9, t0.notices_fv AS notices_fv_10, t0.parts_received_date AS parts_received_date_11, t0.parts_issued_date AS parts_issued_date_12, t0.is_parts_received AS is_parts_received_13, t0.is_parts_issued AS is_parts_issued_14, t0.buyer_status AS buyer_status_15, t0.seller_status AS seller_status_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.active AS active_19, t0.recipient_id AS recipient_id_20, t0.invoice_address_id AS invoice_address_id_21, t0.vin_photo_id AS vin_photo_id_22, t0.estimate_file_id AS estimate_file_id_23, t0.make_id AS make_id_24, t0.customer_address_id AS customer_address_id_25, t0.contact_person_id AS contact_person_id_26, t0.created_by_id AS created_by_id_27, t0.updated_by_id AS updated_by_id_28 FROM inquiry t0 WHERE t0.id = ?
Parameters:
[
  47413
]
0.27 ms
(0.17%)
1
SELECT t0.id AS id_1, t0.content AS content_2, t0.read_at AS read_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.active AS active_6, t0.offer_id AS offer_id_7, t0.inquiry_id AS inquiry_id_8, t0.author_id AS author_id_9, t0.recipient_id AS recipient_id_10, t0.parent_id AS parent_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM private_message t0 WHERE t0.offer_id = ? ORDER BY t0.id DESC
Parameters:
[
  "68871"
]
0.22 ms
(0.14%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.active AS active_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7 FROM make t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\Customer
  • The mappings App\Entity\Customer#invoiceAddresses and App\Entity\CustomerInvoiceAddress#customer are inconsistent with each other.
App\Entity\User No errors.
App\Entity\Inquiry
  • The mappings App\Entity\Inquiry#invoiceAddress and App\Entity\CustomerInvoiceAddress#inquiries are inconsistent with each other.
App\Entity\Offer No errors.
App\Entity\Rating No errors.
App\Entity\PrivateMessage No errors.
App\Entity\Make No errors.
App\Entity\CustomerAddress No errors.
App\Entity\CustomerInvoiceAddress No errors.
App\Entity\ContactPerson No errors.
App\Entity\Notification No errors.
App\Entity\OfferFile No errors.
App\Entity\InquiryFile No errors.
App\Entity\InquiryDiscussionEntry No errors.
App\Entity\InquirySupplier No errors.
App\Entity\PrivateMessageAttachment No errors.