Query Metrics
4
Database Queries
4
Different statements
39.12 ms
Query time
0
Invalid entities
463
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
33.21 ms (84.88%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.product_id_external AS product_id_external_2, p0_.ean AS ean_3, p0_.original_price AS original_price_4, p0_.sale_price AS sale_price_5, p0_.ai_score AS ai_score_6, p0_.status AS status_7, p0_.market_since AS market_since_8, p0_.image_path AS image_path_9, p0_.condition_key AS condition_key_10, p0_.package_size_key AS package_size_key_11, p0_.warranty_months AS warranty_months_12, p0_.additional_statuses AS additional_statuses_13, p0_.specification_values AS specification_values_14, p0_.quality_note AS quality_note_15, p0_.catalog_description AS catalog_description_16, p0_.defect_note AS defect_note_17, p0_.ai_input_fingerprint AS ai_input_fingerprint_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, c1_.id AS id_21, c1_.name AS name_22, c1_.slug AS slug_23, c1_.active AS active_24, s2_.id AS id_25, s2_.email AS email_26, s2_.roles AS roles_27, s2_.password AS password_28, s2_.company_name AS company_name_29, s2_.company_code AS company_code_30, s2_.individual_activity_certificate_number AS individual_activity_certificate_number_31, s2_.city AS city_32, s2_.address AS address_33, s2_.zip AS zip_34, s2_.iban AS iban_35, s2_.comment AS comment_36, s2_.phone AS phone_37, s2_.contact_name AS contact_name_38, s2_.contact_email AS contact_email_39, s2_.contact_phone AS contact_phone_40, s2_.fee_percent AS fee_percent_41, s2_.shop_title AS shop_title_42, s2_.vat_code AS vat_code_43, s2_.oss_registered AS oss_registered_44, s2_.office_address AS office_address_45, s2_.customer_phone AS customer_phone_46, s2_.customer_email AS customer_email_47, s2_.bank_name AS bank_name_48, s2_.swift AS swift_49, s2_.invoice_email AS invoice_email_50, s2_.return_country AS return_country_51, s2_.return_city AS return_city_52, s2_.return_address AS return_address_53, s2_.return_post_code AS return_post_code_54, s2_.return_phone AS return_phone_55, s2_.return_email AS return_email_56, s2_.pickup_workdays AS pickup_workdays_57, s2_.pickup_hours_from AS pickup_hours_from_58, s2_.pickup_hours_to AS pickup_hours_to_59, s2_.delivery_hours AS delivery_hours_60, s2_.delivery_apply_all AS delivery_apply_all_61, s2_.delivery_methods AS delivery_methods_62, s2_.ai_pricing_strategy AS ai_pricing_strategy_63, s2_.auto_price_reduction_enabled AS auto_price_reduction_enabled_64, s2_.auto_price_reduction_days AS auto_price_reduction_days_65, s2_.auto_price_reduction_percent AS auto_price_reduction_percent_66, s2_.notify_product_sold AS notify_product_sold_67, s2_.notify_new_message AS notify_new_message_68, s2_.notify_ai_price_change AS notify_ai_price_change_69, s2_.notify_return_request AS notify_return_request_70, s2_.notify_weekly_report AS notify_weekly_report_71, s2_.notify_low_inventory AS notify_low_inventory_72, s2_.holiday_mode AS holiday_mode_73, p0_.category_id AS category_id_74, p0_.seller_id AS seller_id_75, p0_.linked_product_id AS linked_product_id_76, c1_.parent_category_id AS parent_category_id_77 FROM product_draft p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id LEFT JOIN seller s2_ ON p0_.seller_id = s2_.id WHERE p0_.seller_id = ? ORDER BY p0_.updated_at DESC
Parameters:
[
2
]
|
||||||||||||||||||||||||||||
|
2.65 ms (6.78%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.company_name AS company_name_5, t0.company_code AS company_code_6, t0.individual_activity_certificate_number AS individual_activity_certificate_number_7, t0.city AS city_8, t0.address AS address_9, t0.zip AS zip_10, t0.iban AS iban_11, t0.comment AS comment_12, t0.phone AS phone_13, t0.contact_name AS contact_name_14, t0.contact_email AS contact_email_15, t0.contact_phone AS contact_phone_16, t0.fee_percent AS fee_percent_17, t0.shop_title AS shop_title_18, t0.vat_code AS vat_code_19, t0.oss_registered AS oss_registered_20, t0.office_address AS office_address_21, t0.customer_phone AS customer_phone_22, t0.customer_email AS customer_email_23, t0.bank_name AS bank_name_24, t0.swift AS swift_25, t0.invoice_email AS invoice_email_26, t0.return_country AS return_country_27, t0.return_city AS return_city_28, t0.return_address AS return_address_29, t0.return_post_code AS return_post_code_30, t0.return_phone AS return_phone_31, t0.return_email AS return_email_32, t0.pickup_workdays AS pickup_workdays_33, t0.pickup_hours_from AS pickup_hours_from_34, t0.pickup_hours_to AS pickup_hours_to_35, t0.delivery_hours AS delivery_hours_36, t0.delivery_apply_all AS delivery_apply_all_37, t0.delivery_methods AS delivery_methods_38, t0.ai_pricing_strategy AS ai_pricing_strategy_39, t0.auto_price_reduction_enabled AS auto_price_reduction_enabled_40, t0.auto_price_reduction_days AS auto_price_reduction_days_41, t0.auto_price_reduction_percent AS auto_price_reduction_percent_42, t0.notify_product_sold AS notify_product_sold_43, t0.notify_new_message AS notify_new_message_44, t0.notify_ai_price_change AS notify_ai_price_change_45, t0.notify_return_request AS notify_return_request_46, t0.notify_weekly_report AS notify_weekly_report_47, t0.notify_low_inventory AS notify_low_inventory_48, t0.holiday_mode AS holiday_mode_49 FROM seller t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"dominykas409@gmail.com"
]
|
||||||||||||||||||||||||||||
|
1.84 ms (4.70%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM admin t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"dominykas409@gmail.com"
]
|
||||||||||||||||||||||||||||
|
1.42 ms (3.64%) |
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.product_id_external AS product_id_external_2, p0_.ean AS ean_3, p0_.original_price AS original_price_4, p0_.sale_price AS sale_price_5, p0_.ai_score AS ai_score_6, p0_.status AS status_7, p0_.market_since AS market_since_8, p0_.auto_price_reduction_count AS auto_price_reduction_count_9, p0_.image_path AS image_path_10, p0_.condition_key AS condition_key_11, p0_.package_size_key AS package_size_key_12, p0_.warranty_months AS warranty_months_13, p0_.additional_statuses AS additional_statuses_14, p0_.specification_values AS specification_values_15, p0_.quality_note AS quality_note_16, p0_.catalog_description AS catalog_description_17, p0_.ai_description_fingerprint AS ai_description_fingerprint_18, p0_.defect_note AS defect_note_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, p0_.sold_at AS sold_at_22, c1_.id AS id_23, c1_.name AS name_24, c1_.slug AS slug_25, c1_.active AS active_26, s2_.id AS id_27, s2_.email AS email_28, s2_.roles AS roles_29, s2_.password AS password_30, s2_.company_name AS company_name_31, s2_.company_code AS company_code_32, s2_.individual_activity_certificate_number AS individual_activity_certificate_number_33, s2_.city AS city_34, s2_.address AS address_35, s2_.zip AS zip_36, s2_.iban AS iban_37, s2_.comment AS comment_38, s2_.phone AS phone_39, s2_.contact_name AS contact_name_40, s2_.contact_email AS contact_email_41, s2_.contact_phone AS contact_phone_42, s2_.fee_percent AS fee_percent_43, s2_.shop_title AS shop_title_44, s2_.vat_code AS vat_code_45, s2_.oss_registered AS oss_registered_46, s2_.office_address AS office_address_47, s2_.customer_phone AS customer_phone_48, s2_.customer_email AS customer_email_49, s2_.bank_name AS bank_name_50, s2_.swift AS swift_51, s2_.invoice_email AS invoice_email_52, s2_.return_country AS return_country_53, s2_.return_city AS return_city_54, s2_.return_address AS return_address_55, s2_.return_post_code AS return_post_code_56, s2_.return_phone AS return_phone_57, s2_.return_email AS return_email_58, s2_.pickup_workdays AS pickup_workdays_59, s2_.pickup_hours_from AS pickup_hours_from_60, s2_.pickup_hours_to AS pickup_hours_to_61, s2_.delivery_hours AS delivery_hours_62, s2_.delivery_apply_all AS delivery_apply_all_63, s2_.delivery_methods AS delivery_methods_64, s2_.ai_pricing_strategy AS ai_pricing_strategy_65, s2_.auto_price_reduction_enabled AS auto_price_reduction_enabled_66, s2_.auto_price_reduction_days AS auto_price_reduction_days_67, s2_.auto_price_reduction_percent AS auto_price_reduction_percent_68, s2_.notify_product_sold AS notify_product_sold_69, s2_.notify_new_message AS notify_new_message_70, s2_.notify_ai_price_change AS notify_ai_price_change_71, s2_.notify_return_request AS notify_return_request_72, s2_.notify_weekly_report AS notify_weekly_report_73, s2_.notify_low_inventory AS notify_low_inventory_74, s2_.holiday_mode AS holiday_mode_75, p0_.category_id AS category_id_76, p0_.seller_id AS seller_id_77, c1_.parent_category_id AS parent_category_id_78 FROM product p0_ LEFT JOIN category c1_ ON p0_.category_id = c1_.id LEFT JOIN seller s2_ ON p0_.seller_id = s2_.id WHERE p0_.seller_id = ? ORDER BY p0_.updated_at DESC
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\ProductDraft | 394 |
| App\Entity\Category | 68 |
| App\Entity\Seller | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Admin | No errors. |
| App\Entity\Seller | No errors. |
| App\Entity\ProductDraft | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\ProductDraftImage | No errors. |
| App\Entity\CategorySpecificationField | No errors. |