Query Metrics
1
Database Queries
1
Different statements
2.81 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.81 ms (100.00%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25, p1_.id AS id_26, p1_.price_ht AS price_ht_27, p1_.price_ttc AS price_ttc_28, p2_.id AS id_29, p3_.level AS level_30, c4_.id AS id_31, c4_.name AS name_32, c4_.displayed_order AS displayed_order_33, c4_.is_in_footer AS is_in_footer_34, c4_.slug AS slug_35, p5_.id AS id_36, p5_.price_ht AS price_ht_37, p5_.price_ttc AS price_ttc_38, p5_.discount AS discount_39, p6_.id AS id_40, p6_.min AS min_41, p6_.max AS max_42, p6_.codelot AS codelot_43, c7_.id AS id_44, c7_.name AS name_45, c7_.name_display AS name_display_46, c7_.is_visible_btob AS is_visible_btob_47, c7_.is_referencement AS is_referencement_48, p1_.price_id AS price_id_49, p1_.product_id AS product_id_50, p3_.product_id AS product_id_51, p3_.category_id AS category_id_52, c4_.category_parent_id AS category_parent_id_53, p5_.product_id AS product_id_54, p6_.customer_catalog_id AS customer_catalog_id_55, p6_.product_id AS product_id_56 FROM product p0_ LEFT JOIN product_price p1_ ON p0_.id = p1_.product_id LEFT JOIN price p2_ ON p1_.price_id = p2_.id LEFT JOIN product_category p3_ ON p0_.id = p3_.product_id LEFT JOIN category c4_ ON p3_.category_id = c4_.id LEFT JOIN promotion p5_ ON p0_.id = p5_.product_id LEFT JOIN product_catalog p6_ ON p0_.id = p6_.product_id LEFT JOIN customer_catalog c7_ ON p6_.customer_catalog_id = c7_.id WHERE p0_.id = ?
Parameters:
[
423747
]
|
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\Product\Product | No errors. |
App\Entity\Product\ProductPrice | No errors. |
App\Entity\Pricing\Price | No errors. |
App\Entity\Product\ProductCategory | No errors. |
App\Entity\Product\Category | No errors. |
App\Entity\Pricing\Promotion | No errors. |
App\Entity\Catalog\ProductCatalog | No errors. |
App\Entity\Catalog\CustomerCatalog | No errors. |
App\Entity\PromotionalOperations\Operations | No errors. |
App\Entity\Product\ProductMarket | No errors. |
App\Entity\Product\Characteristic | No errors. |
App\Entity\Shop\ShopProduct | No errors. |
App\Entity\Personalization\ColorInkModel | No errors. |
App\Entity\Personalization\ColorCustom | No errors. |
App\Entity\Personalization\PoliceModelCustom | No errors. |
App\Entity\Personalization\GlobalPersonnalization | No errors. |
App\Entity\Personalization\ModelCustom | No errors. |
App\Entity\RubberStamp\RubberStampCustom | No errors. |
App\Entity\Customer\Customer | No errors. |
App\Entity\Internal\Counter | No errors. |
App\Entity\Order\CustomerOrder | No errors. |