Query Metrics
24
Database Queries
5
Different statements
9.53 ms
Query time
3
Invalid entities
33
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
3.34 ms (35.03%) |
8 |
SELECT t0.uuid AS uuid_1, t0.processed_count AS processed_count_2, t0.total_count AS total_count_3, t0.time_started AS time_started_4, t0.time_ended AS time_ended_5, t0.request AS request_6, t0.response AS response_7, t0.error AS error_8, t0.queue_transaction_state AS queue_transaction_state_9, t0.notified AS notified_10, t0.title AS title_11, t0.initiated_by AS initiated_by_12, t0.parent_id AS parent_id_13, t0.discr, t0.product_id AS product_id_14, t0.customer_id AS customer_id_15, t0.order_id AS order_id_16 FROM queue_transaction t0 WHERE t0.uuid = ? AND t0.discr IN ('product', 'pohoda_sync', 'customer', 'order', 'error', 'mserver_status')
Parameters:
[
b"\x01˜A\x1C°Št¥ù\x03š³’Ò "
]
|
|
2.37 ms (24.88%) |
7 |
SELECT t0.uuid AS uuid_1, t0.original_url AS original_url_2, t0.medium_url AS medium_url_3, t0.small_url AS small_url_4, t0.pdf_url AS pdf_url_5, t0.width AS width_6, t0.height AS height_7, t0.size AS size_8, t0.mime AS mime_9, t0.position AS position_10, t0.product_id AS product_id_11, t0.discr FROM image t0 WHERE t0.product_id = ? AND t0.discr IN ('product')
Parameters:
[
b"\x01•ìj\x11\x1Dr\x04†ïK˜Q*—="
]
|
|
1.70 ms (17.89%) |
7 |
SELECT t0.uuid AS uuid_1, t0.position AS position_2, t0.category_id AS category_id_3, t0.product_id AS product_id_4 FROM category_product t0 WHERE t0.product_id = ?
Parameters:
[
b"\x01•ìj\x11\x1Dr\x04†ïK˜Q*—="
]
|
|
1.20 ms (12.57%) |
1 |
SELECT p0_.uuid AS uuid_0, p0_.pohoda_id AS pohoda_id_1, p0_.name AS name_2, p0_.legal_name AS legal_name_3, p0_.description AS description_4, p0_.composition AS composition_5, p0_.other_info AS other_info_6, p0_.storage_conditions AS storage_conditions_7, p0_.allergen_free AS allergen_free_8, p0_.vat_alcohol AS vat_alcohol_9, p0_.mdt AS mdt_10, p0_.min_order_quantity AS min_order_quantity_11, p0_.published AS published_12, p0_.published_by_last_edit AS published_by_last_edit_13, p0_.checked AS checked_14, p0_.checked_by_last_edit AS checked_by_last_edit_15, p0_.archived AS archived_16, p0_.archived_at AS archived_at_17, p0_.stock_serial_number AS stock_serial_number_18, p0_.nutrition_energy AS nutrition_energy_19, p0_.nutrition_energy_cal AS nutrition_energy_cal_20, p0_.nutrition_fat AS nutrition_fat_21, p0_.nutrition_fatty_acid AS nutrition_fatty_acid_22, p0_.nutrition_carbohydrate AS nutrition_carbohydrate_23, p0_.nutrition_sugar AS nutrition_sugar_24, p0_.nutrition_fiber AS nutrition_fiber_25, p0_.nutrition_proteins AS nutrition_proteins_26, p0_.nutrition_salt AS nutrition_salt_27, p0_.nutrition_allergens AS nutrition_allergens_28, p0_.pricing_purchase_price AS pricing_purchase_price_29, p0_.pricing_weight_purchase_price AS pricing_weight_purchase_price_30, p0_.pricing_selling_price AS pricing_selling_price_31, p0_.pricing_purchase_price_eur AS pricing_purchase_price_eur_32, p0_.pricing_discount_price AS pricing_discount_price_33, p0_.pricing_discount_selling_price AS pricing_discount_selling_price_34, p0_.pricing_manufacturing_distribution_price AS pricing_manufacturing_distribution_price_35, p0_.pricing_recommended_retail_price AS pricing_recommended_retail_price_36, p0_.pricing_action_price_from AS pricing_action_price_from_37, p0_.pricing_action_price_to AS pricing_action_price_to_38, p0_.pricing_notified_price_from AS pricing_notified_price_from_39, p0_.pricing_notified_price AS pricing_notified_price_40, p0_.pricing_euro_exchange_price AS pricing_euro_exchange_price_41, p0_.measurements_weight_netto AS measurements_weight_netto_42, p0_.measurements_weight_brutto AS measurements_weight_brutto_43, p0_.measurements_stock_unit AS measurements_stock_unit_44, p0_.measurements_quantity_per_carton AS measurements_quantity_per_carton_45, p0_.measurements_package_per_carton AS measurements_package_per_carton_46, p0_.measurements_width AS measurements_width_47, p0_.measurements_height AS measurements_height_48, p0_.measurements_depth AS measurements_depth_49, p0_.measurements_quantity_per_pallet AS measurements_quantity_per_pallet_50, p0_.measurements_quantity_per_layer AS measurements_quantity_per_layer_51, p0_.measurements_width_display AS measurements_width_display_52, p0_.measurements_height_display AS measurements_height_display_53, p0_.measurements_depth_display AS measurements_depth_display_54, p0_.measurements_width_carton AS measurements_width_carton_55, p0_.measurements_height_carton AS measurements_height_carton_56, p0_.measurements_depth_carton AS measurements_depth_carton_57, p0_.measurements_pallet_height AS measurements_pallet_height_58, p0_.measurements_drained_weight AS measurements_drained_weight_59, p0_.identifiers_order_code AS identifiers_order_code_60, p0_.identifiers_product_ean AS identifiers_product_ean_61, p0_.identifiers_package_ean AS identifiers_package_ean_62, p0_.identifiers_master_ean AS identifiers_master_ean_63, p0_.identifiers_hs_code AS identifiers_hs_code_64, p0_.stock_available AS stock_available_65, p0_.stock_reserved AS stock_reserved_66, p0_.stock_ordered AS stock_ordered_67, p0_.country_origin_uuid AS country_origin_uuid_68, p0_.vat_rate_uuid AS vat_rate_uuid_69, p0_.published_by_user_uuid AS published_by_user_uuid_70, p0_.checked_by_user_uuid AS checked_by_user_uuid_71, p0_.latest_transaction_id AS latest_transaction_id_72, p0_.brand_id AS brand_id_73, p0_.supplier_id AS supplier_id_74 FROM product p0_ LEFT JOIN image i1_ ON (i1_.product_id = p0_.uuid AND i1_.position = 0) AND i1_.discr IN ('product') INNER JOIN tag_product t2_ ON p0_.uuid = t2_.product_id INNER JOIN tag t3_ ON t2_.tag_id = t3_.uuid WHERE p0_.archived = 0 AND p0_.published = 1 AND p0_.pricing_selling_price > 0 AND t3_.top_seller = 1
Parameters:
[] |
|
0.92 ms (9.64%) |
1 |
SELECT p0_.uuid AS uuid_0, p0_.pohoda_id AS pohoda_id_1, p0_.name AS name_2, p0_.legal_name AS legal_name_3, p0_.description AS description_4, p0_.composition AS composition_5, p0_.other_info AS other_info_6, p0_.storage_conditions AS storage_conditions_7, p0_.allergen_free AS allergen_free_8, p0_.vat_alcohol AS vat_alcohol_9, p0_.mdt AS mdt_10, p0_.min_order_quantity AS min_order_quantity_11, p0_.published AS published_12, p0_.published_by_last_edit AS published_by_last_edit_13, p0_.checked AS checked_14, p0_.checked_by_last_edit AS checked_by_last_edit_15, p0_.archived AS archived_16, p0_.archived_at AS archived_at_17, p0_.stock_serial_number AS stock_serial_number_18, p0_.nutrition_energy AS nutrition_energy_19, p0_.nutrition_energy_cal AS nutrition_energy_cal_20, p0_.nutrition_fat AS nutrition_fat_21, p0_.nutrition_fatty_acid AS nutrition_fatty_acid_22, p0_.nutrition_carbohydrate AS nutrition_carbohydrate_23, p0_.nutrition_sugar AS nutrition_sugar_24, p0_.nutrition_fiber AS nutrition_fiber_25, p0_.nutrition_proteins AS nutrition_proteins_26, p0_.nutrition_salt AS nutrition_salt_27, p0_.nutrition_allergens AS nutrition_allergens_28, p0_.pricing_purchase_price AS pricing_purchase_price_29, p0_.pricing_weight_purchase_price AS pricing_weight_purchase_price_30, p0_.pricing_selling_price AS pricing_selling_price_31, p0_.pricing_purchase_price_eur AS pricing_purchase_price_eur_32, p0_.pricing_discount_price AS pricing_discount_price_33, p0_.pricing_discount_selling_price AS pricing_discount_selling_price_34, p0_.pricing_manufacturing_distribution_price AS pricing_manufacturing_distribution_price_35, p0_.pricing_recommended_retail_price AS pricing_recommended_retail_price_36, p0_.pricing_action_price_from AS pricing_action_price_from_37, p0_.pricing_action_price_to AS pricing_action_price_to_38, p0_.pricing_notified_price_from AS pricing_notified_price_from_39, p0_.pricing_notified_price AS pricing_notified_price_40, p0_.pricing_euro_exchange_price AS pricing_euro_exchange_price_41, p0_.measurements_weight_netto AS measurements_weight_netto_42, p0_.measurements_weight_brutto AS measurements_weight_brutto_43, p0_.measurements_stock_unit AS measurements_stock_unit_44, p0_.measurements_quantity_per_carton AS measurements_quantity_per_carton_45, p0_.measurements_package_per_carton AS measurements_package_per_carton_46, p0_.measurements_width AS measurements_width_47, p0_.measurements_height AS measurements_height_48, p0_.measurements_depth AS measurements_depth_49, p0_.measurements_quantity_per_pallet AS measurements_quantity_per_pallet_50, p0_.measurements_quantity_per_layer AS measurements_quantity_per_layer_51, p0_.measurements_width_display AS measurements_width_display_52, p0_.measurements_height_display AS measurements_height_display_53, p0_.measurements_depth_display AS measurements_depth_display_54, p0_.measurements_width_carton AS measurements_width_carton_55, p0_.measurements_height_carton AS measurements_height_carton_56, p0_.measurements_depth_carton AS measurements_depth_carton_57, p0_.measurements_pallet_height AS measurements_pallet_height_58, p0_.measurements_drained_weight AS measurements_drained_weight_59, p0_.identifiers_order_code AS identifiers_order_code_60, p0_.identifiers_product_ean AS identifiers_product_ean_61, p0_.identifiers_package_ean AS identifiers_package_ean_62, p0_.identifiers_master_ean AS identifiers_master_ean_63, p0_.identifiers_hs_code AS identifiers_hs_code_64, p0_.stock_available AS stock_available_65, p0_.stock_reserved AS stock_reserved_66, p0_.stock_ordered AS stock_ordered_67, p0_.country_origin_uuid AS country_origin_uuid_68, p0_.vat_rate_uuid AS vat_rate_uuid_69, p0_.published_by_user_uuid AS published_by_user_uuid_70, p0_.checked_by_user_uuid AS checked_by_user_uuid_71, p0_.latest_transaction_id AS latest_transaction_id_72, p0_.brand_id AS brand_id_73, p0_.supplier_id AS supplier_id_74 FROM product p0_ LEFT JOIN image i1_ ON (i1_.product_id = p0_.uuid AND i1_.position = 0) AND i1_.discr IN ('product') INNER JOIN tag_product t2_ ON p0_.uuid = t2_.product_id INNER JOIN tag t3_ ON t2_.tag_id = t3_.uuid WHERE p0_.archived = 0 AND p0_.published = 1 AND p0_.pricing_selling_price > 0 AND t3_.news = 1
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| stock | doctrine.dbal.stock_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\Infrastructure\Transaction\QueueTransaction | 8 |
| App\Domain\Product\Entity\Product | 7 |
| App\Domain\Image\Entity\Image | 7 |
| App\Domain\Category\Entity\CategoryProduct | 5 |
| App\Domain\Product\Entity\VatRate | 2 |
| App\Domain\Category\Entity\Category | 2 |
| App\Domain\User\Entity\User | 1 |
| App\Domain\Brand\Entity\Brand | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Domain\Brand\Entity\Brand |
|
| App\Domain\Image\Entity\Image | No errors. |
| App\Domain\Product\Entity\ProductImage | No errors. |
| App\Domain\Brand\Entity\BrandImage | No errors. |
| App\Domain\Listing\Entity\ListingCardImage | No errors. |
| App\Domain\Product\Entity\NutritionFacts | No errors. |
| App\Domain\Product\Entity\Pricing | No errors. |
| App\Domain\Product\Entity\Measurements | No errors. |
| App\Domain\Product\Entity\Identifiers | No errors. |
| App\Domain\Product\Entity\Stock | No errors. |
| App\Domain\Product\Entity\Product |
|
| App\Domain\Listing\Entity\ListingCard | No errors. |
| App\Domain\Product\Entity\Country | No errors. |
| App\Domain\Product\Entity\VatRate | No errors. |
| App\Domain\User\Entity\User | No errors. |
| App\Infrastructure\Transaction\QueueTransaction | No errors. |
| App\Domain\Category\Entity\CategoryProduct | No errors. |
| App\Domain\Listing\Entity\Supplier | No errors. |
| App\Domain\Tag\Entity\TagProduct | No errors. |
| App\Domain\Customer\Entity\CustomerProduct | No errors. |
| App\Infrastructure\Transaction\QueueTransactionError | No errors. |
| App\Domain\Category\Entity\Category | No errors. |
| App\Domain\Listing\Entity\SupplierUser | No errors. |
| App\Domain\Tag\Entity\Tag | No errors. |
| App\Domain\Customer\Entity\Customer | No errors. |
| App\Domain\Customer\Entity\CustomerTransaction | No errors. |
| App\Domain\Product\Entity\ProductTransaction |
|
| App\Domain\Admin\Entity\PohodaSyncTransaction | No errors. |
| App\Domain\Order\Entity\OrderTransaction | No errors. |
| App\Domain\Order\Entity\Order | No errors. |
| App\Infrastructure\Transaction\ErrorTransaction | No errors. |
| App\Domain\Monitoring\Entity\MserverStatusTransaction | No errors. |
| App\Domain\Account\Entity\Account | No errors. |