Query Metrics
9
Database Queries
7
Different statements
153.31 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.41 ms |
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
]
|
| 2 | 0.46 ms |
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"
]
|
| 3 | 0.34 ms |
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
]
|
| 4 | 0.27 ms |
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"
]
|
| 5 | 150.92 ms |
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 ] |
| 6 | 0.22 ms |
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
]
|
| 7 | 0.21 ms |
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
]
|
| 8 | 0.29 ms |
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:
[
86
]
|
| 9 | 0.20 ms |
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:
[
105259
]
|
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 |
|
| App\Entity\User | No errors. |
| App\Entity\Inquiry |
|
| 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. |