GET https://api-console.kissmada.com/store/variants/9315

Query Metrics

23 Database Queries
19 Different statements
7.09 ms Query time
11 Invalid entities
78 Managed entities

Queries

Group similar statements

# Time Info
1 0.40 ms
SELECT t0.id_store_variant AS id_store_variant_1, t0.id_store_product AS id_store_product_2, t0.id_variant_product_technique AS id_variant_product_technique_3, t0.id_store_product_color AS id_store_product_color_4, t0.id_store_product_size AS id_store_product_size_5 FROM store_variants t0 WHERE t0.id_store_variant = ?
Parameters:
[
  9315
]
2 0.29 ms
SELECT t0.id_store_product AS id_store_product_1, t0.id_store_design AS id_store_design_2, t0.id_product_technique AS id_product_technique_3 FROM store_products t0 WHERE t0.id_store_product = ?
Parameters:
[
  150
]
3 0.29 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.id_variant AS id_variant_3, t0.id_product_technique AS id_product_technique_4 FROM variants_products_techniques t0 WHERE t0.id = ?
Parameters:
[
  18512
]
4 0.24 ms
SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.id_technique AS id_technique_3, t0.id_product AS id_product_4 FROM products_techniques t0 WHERE t0.id = ?
Parameters:
[
  626
]
5 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.conflicting AS conflicting_3, t0.price AS price_4, t0.id_product_technique AS id_product_technique_5 FROM products_techniques_placements t0 WHERE t0.id_product_technique = ?
Parameters:
[
  626
]
6 0.25 ms
SELECT t0.id_variant AS id_variant_1, t0.image_url AS image_url_2, t0.id_product AS id_product_3, t0.id_product_color AS id_product_color_4, t0.id_product_size AS id_product_size_5, t0.id_size AS id_size_6, t0.id_color AS id_color_7 FROM variants t0 WHERE t0.id_variant = ?
Parameters:
[
  34377
]
7 0.37 ms
SELECT t0.id AS id_1, t0.placement AS placement_2, t0.orientation AS orientation_3, t0.width AS width_4, t0.height AS height_5, t0.id_variant AS id_variant_6 FROM variants_dimensions t0 WHERE t0.id_variant = ?
Parameters:
[
  34377
]
8 0.43 ms
SELECT t0.id AS id_1, t0.image_url AS image_url_2, t0.background_url AS background_url_3, t0.background_color AS background_color_4, t0.template_width AS template_width_5, t0.template_height AS template_height_6, t0.print_area_width AS print_area_width_7, t0.print_area_height AS print_area_height_8, t0.print_area_top AS print_area_top_9, t0.print_area_left AS print_area_left_10, t0.template_positioning AS template_positioning_11, t0.orientation AS orientation_12, t0.template_type AS template_type_13, t0.role AS role_14, t0.id_product_technique_placement AS id_product_technique_placement_15 FROM products_techniques_placements_mockup_templates t0 INNER JOIN variants_mockup_templates ON t0.id = variants_mockup_templates.id_product_technique_placement_mockup_template WHERE variants_mockup_templates.id_variant = ?
Parameters:
[
  34377
]
9 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.conflicting AS conflicting_3, t0.price AS price_4, t0.id_product_technique AS id_product_technique_5 FROM products_techniques_placements t0 WHERE t0.id = ?
Parameters:
[
  2090
]
10 0.23 ms
SELECT t0.id AS id_1, t0.is_default AS is_default_2, t0.id_technique AS id_technique_3, t0.id_product AS id_product_4 FROM products_techniques t0 WHERE t0.id = ?
Parameters:
[
  625
]
11 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.conflicting AS conflicting_3, t0.price AS price_4, t0.id_product_technique AS id_product_technique_5 FROM products_techniques_placements t0 WHERE t0.id = ?
Parameters:
[
  2091
]
12 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.conflicting AS conflicting_3, t0.price AS price_4, t0.id_product_technique AS id_product_technique_5 FROM products_techniques_placements t0 WHERE t0.id = ?
Parameters:
[
  2092
]
13 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.conflicting AS conflicting_3, t0.price AS price_4, t0.id_product_technique AS id_product_technique_5 FROM products_techniques_placements t0 WHERE t0.id = ?
Parameters:
[
  2093
]
14 0.24 ms
SELECT t0.id_store_design AS id_store_design_1 FROM store_designs t0 WHERE t0.id_store_design = ?
Parameters:
[
  1
]
15 0.32 ms
SELECT t0.id AS id_1, t0.id_lang AS id_lang_2, t0.name AS name_3, t0.short_description AS short_description_4, t0.id_store_design AS id_store_design_5 FROM store_designs_langs t0 WHERE t0.id_store_design = ?
Parameters:
[
  1
]
16 0.29 ms
SELECT t0.id_product AS id_product_1, t0.product_type AS product_type_2, t0.main_category_id AS main_category_id_3, t0.brand AS brand_4, t0.image_url AS image_url_5, t0.is_discontinued AS is_discontinued_6, t0.id_model AS id_model_7 FROM products t0 WHERE t0.id_product = ?
Parameters:
[
  975
]
17 0.32 ms
SELECT t0.id AS id_1, t0.id_lang AS id_lang_2, t0.name AS name_3, t0.id_store_product AS id_store_product_4 FROM store_products_langs t0 WHERE t0.id_store_product = ?
Parameters:
[
  150
]
18 0.25 ms
SELECT t0.id_technique AS id_technique_1, t0.key_technique AS key_technique_2 FROM techniques t0 WHERE t0.id_technique = ?
Parameters:
[
  4
]
19 0.34 ms
SELECT t0.id AS id_1, t0.id_lang AS id_lang_2, t0.name AS name_3, t0.id_technique AS id_technique_4 FROM techniques_langs t0 WHERE t0.id_technique = ?
Parameters:
[
  4
]
20 0.81 ms
SELECT t0.id AS id_1, t0.id_lang AS id_lang_2, t0.name AS name_3, t0.id_variant AS id_variant_4 FROM variants_langs t0 WHERE t0.id_variant = ?
Parameters:
[
  34377
]
21 0.23 ms
SELECT t0.id_size AS id_size_1, t0.size_key AS size_key_2 FROM sizes t0 WHERE t0.id_size = ?
Parameters:
[
  62
]
22 0.24 ms
SELECT t0.id_color AS id_color_1, t0.color_key AS color_key_2, t0.rgb AS rgb_3, t0.rgb2 AS rgb2_4 FROM colors t0 WHERE t0.id_color = ?
Parameters:
[
  518
]
23 0.28 ms
SELECT t0.id AS id_1, t0.id_lang AS id_lang_2, t0.name AS name_3, t0.id_color AS id_color_4 FROM colors_langs t0 WHERE t0.id_color = ?
Parameters:
[
  518
]

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\ProductTechniquePlacementMockupTemplate 15
App\Entity\VariantDimension 11
App\Entity\ProductTechniquePlacement 10
App\Entity\Store\StoreDesignLang 5
App\Entity\Store\StoreProductLang 5
App\Entity\TechniqueLang 5
App\Entity\VariantLang 5
App\Entity\ColorLang 5
App\Entity\ProductTechnique 2
App\Entity\Technique 2
App\Entity\Store\StoreVariant 1
App\Entity\Store\StoreProduct 1
App\Entity\VariantProductTechnique 1
App\Entity\Store\StoreProductColor 1
App\Entity\Store\StoreProductSize 1
App\Entity\Store\StoreDesign 1
App\Entity\Variant 1
App\Entity\Product 1
App\Entity\ProductColor 1
App\Entity\ProductSize 1
App\Entity\Size 1
App\Entity\Color 1
App\Entity\Model 1

Entities Mapping

Class Mapping errors
App\Entity\Store\StoreVariant
  • The mappings App\Entity\Store\StoreVariant#storeProductSize and App\Entity\Store\StoreProductSize#storeVariants are inconsistent with each other.
App\Entity\Store\StoreProduct No errors.
App\Entity\VariantProductTechnique No errors.
App\Entity\Store\StoreProductColor
  • The mappings App\Entity\Store\StoreProductColor#productColor and App\Entity\ProductColor#storeProductColors are inconsistent with each other.
App\Entity\Store\StoreProductSize
  • The mappings App\Entity\Store\StoreProductSize#productSize and App\Entity\ProductSize#storeProductSizes are inconsistent with each other.
App\Entity\Store\StoreDesign No errors.
App\Entity\ProductTechnique No errors.
App\Entity\Store\StoreProductLang No errors.
App\Entity\Variant
  • The mappings App\Entity\Variant#productColor and App\Entity\ProductColor#productVariants are inconsistent with each other.
  • The mappings App\Entity\Variant#productSize and App\Entity\ProductSize#productVariants are inconsistent with each other.
App\Entity\SellingRegionVariantStockAvailability No errors.
App\Entity\Technique No errors.
App\Entity\Product
  • The mappings App\Entity\Product#sizeTables and App\Entity\SizeTable#product are inconsistent with each other.
App\Entity\ProductTechniquePrintFile No errors.
App\Entity\ProductTechniquePlacement No errors.
App\Entity\ProductTechniqueOption No errors.
App\Entity\ProductTechniqueTemplate No errors.
App\Entity\ProductTemplate No errors.
App\Entity\ProductTechniquePlacementOption No errors.
App\Entity\ProductTechniquePlacementMockupStyle No errors.
App\Entity\ProductTechniquePlacementMockupTemplate No errors.
App\Entity\ProductColor
  • The association App\Entity\ProductColor#storeProductColors refers to the owning side field App\Entity\Store\StoreProductColor#product which does not exist.
App\Entity\ProductSize
  • The association App\Entity\ProductSize#measurementValues refers to the owning side field App\Entity\MeasurementValue#product which does not exist.
  • The association App\Entity\ProductSize#storeProductSizes refers to the owning side field App\Entity\Store\StoreProductSize#product which does not exist.
App\Entity\Size
  • The mappings App\Entity\Size#sizeLangs and App\Entity\SizeLang#size are inconsistent with each other.
App\Entity\Color No errors.
App\Entity\Resource\Image No errors.
App\Entity\Resource\CatalogImage No errors.
App\Entity\VariantLang No errors.
App\Entity\VariantDimension No errors.
App\Entity\Store\StoreDesignLang No errors.
App\Entity\Model No errors.
App\Entity\ProductLang No errors.
App\Entity\Category No errors.
App\Entity\SizeTable
  • The association App\Entity\SizeTable#product refers to the inverse side field App\Entity\Product#productSizeTables which does not exist.
  • The mappings App\Entity\SizeTable#measurements and App\Entity\Measurement#sizeTable are inconsistent with each other.
App\Entity\ShippingCountry
  • The mappings App\Entity\ShippingCountry#country and App\Entity\Country#shippingCountries are inconsistent with each other.
App\Entity\TechniqueLang No errors.
App\Entity\SizeLang
  • The association App\Entity\SizeLang#size refers to the inverse side field App\Entity\Size#size which does not exist.
App\Entity\ColorLang No errors.