Query Metrics
2
Database Queries
2
Different statements
15.35 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.38 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:
[
39
]
|
| 2 | 14.97 ms |
SELECT DISTINCT n0_.id AS id_0, n0_.content AS content_1, n0_.created_at AS created_at_2, n0_.content_id AS content_id_3, i1_.model AS model_4, i2_.model AS model_5, m3_.name AS name_6, m4_.name AS name_7, i1_.registration_number AS registration_number_8, i2_.registration_number AS registration_number_9, n0_.is_read AS is_read_10, n0_.entity_type AS entity_type_11, n0_.entity_id AS entity_id_12 FROM notification n0_ LEFT JOIN inquiry i1_ ON (n0_.entity_type = ? AND n0_.entity_id = i1_.id) LEFT JOIN offer o5_ ON (n0_.entity_type = ? AND n0_.entity_id = o5_.id) LEFT JOIN inquiry i2_ ON (n0_.entity_type = ? AND o5_.inquiry_id = i2_.id) LEFT JOIN make m3_ ON (i1_.make_id = m3_.id) LEFT JOIN make m4_ ON (i2_.make_id = m4_.id) WHERE n0_.recipient_id = 39 AND n0_.active = ? ORDER BY n0_.id DESC
Parameters:
[ "inquiry" "offer" "offer" 1 ] |
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. |