GET https://www.arcanes-labo.btov-dev.fr/api/products/847/pricing-rules?quantity=1&shopId=2

Query Metrics

3 Database Queries
3 Different statements
3.82 ms Query time
1 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.price AS price_6, t0.is_gift_card AS is_gift_card_7, t0.is_only_for_seo AS is_only_for_seo_8, t0.visible AS visible_9, t0.new AS new_10, t0.featured AS featured_11, t0.sku AS sku_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.meta_robots AS meta_robots_15, t0.url_path AS url_path_16, t0.buying_price AS buying_price_17, t0.vat_rate AS vat_rate_18, t0.weight AS weight_19, t0.width AS width_20, t0.height AS height_21, t0.additional_shipping_costs AS additional_shipping_costs_22, t0.inventory AS inventory_23, t0.data AS data_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM product t0 WHERE t0.id = ?
Parameters:
[
  847
]
2 1.02 ms
SELECT t0.id AS id_1, t0.rule_type AS rule_type_2, t0.price_or_discount AS price_or_discount_3, t0.discount_type AS discount_type_4, t0.quantity_min AS quantity_min_5, t0.quantity_max AS quantity_max_6, t0.date_start AS date_start_7, t0.date_end AS date_end_8, t0.customer_group AS customer_group_9, t0.priority AS priority_10, t0.active AS active_11, t0.product_id AS product_id_12, t0.product_variant_id AS product_variant_id_13, t0.shop_id AS shop_id_14 FROM product_pricing_rule t0 WHERE t0.product_id = ?
Parameters:
[
  847
]
3 2.22 ms
SELECT p0_.id AS id_0, p0_.rule_type AS rule_type_1, p0_.price_or_discount AS price_or_discount_2, p0_.discount_type AS discount_type_3, p0_.quantity_min AS quantity_min_4, p0_.quantity_max AS quantity_max_5, p0_.date_start AS date_start_6, p0_.date_end AS date_end_7, p0_.customer_group AS customer_group_8, p0_.priority AS priority_9, p0_.active AS active_10, p0_.product_id AS product_id_11, p0_.product_variant_id AS product_variant_id_12, p0_.shop_id AS shop_id_13 FROM product_pricing_rule p0_ LEFT JOIN shop s1_ ON p0_.shop_id = s1_.id WHERE p0_.active = 1 AND (p0_.product_id = ? OR p0_.product_id IS NULL) AND p0_.product_variant_id IS NULL AND (p0_.shop_id IS NULL OR s1_.id = ?) AND (p0_.date_start IS NULL OR p0_.date_start <= ?) AND (p0_.date_end IS NULL OR p0_.date_end >= ?) ORDER BY p0_.quantity_min ASC
Parameters:
[
  847
  2
  "2026-03-21 12:19:36"
  "2026-03-21 12:19:36"
]

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\Product 1

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\Shop No errors.
App\Entity\ProductVisibility No errors.
App\Entity\ProductAttribute No errors.
App\Entity\ProductVariant
  • The field 'App\Entity\ProductVariant#additionalShippingCosts' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ProductOption No errors.
App\Entity\ProductPricingRule No errors.
App\Entity\ProductMedia No errors.