GET https://api-console.kissmada.com/explorer-catalog/542

Query Metrics

63 Database Queries
9 Different statements
17.78 ms Query time
8 Invalid entities
306 Managed entities

Queries

Group similar statements

# Time Info
1 0.36 ms
SELECT t0.id_lang AS id_lang_1, t0.iso_code AS iso_code_2 FROM langs t0
Parameters:
[]
2 0.31 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:
[
  542
]
3 0.41 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_product = ?
Parameters:
[
  542
]
4 0.45 ms
SELECT t0.id AS id_1, t0.id_lang AS id_lang_2, t0.name AS name_3, t0.model AS model_4, t0.description AS description_5, t0.id_product AS id_product_6 FROM products_langs t0 WHERE t0.id_product = ?
Parameters:
[
  542
]
5 0.89 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:
[
  13657
]
6 0.25 ms
SELECT t0.id_size AS id_size_1, t0.size_key AS size_key_2 FROM sizes t0 WHERE t0.id_size = ?
Parameters:
[
  57
]
7 0.28 ms
SELECT t0.id AS id_1, t0.id_lang AS id_lang_2, t0.name AS name_3, t0.id_size AS id_size_4 FROM sizes_langs t0 WHERE t0.id_size = ?
Parameters:
[
  57
]
8 0.22 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:
[
  271
]
9 0.31 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:
[
  271
]
10 0.27 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:
[
  13658
]
11 0.22 ms
SELECT t0.id_size AS id_size_1, t0.size_key AS size_key_2 FROM sizes t0 WHERE t0.id_size = ?
Parameters:
[
  58
]
12 0.25 ms
SELECT t0.id AS id_1, t0.id_lang AS id_lang_2, t0.name AS name_3, t0.id_size AS id_size_4 FROM sizes_langs t0 WHERE t0.id_size = ?
Parameters:
[
  58
]
13 0.29 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:
[
  13659
]
14 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:
[
  59
]
15 0.25 ms
SELECT t0.id AS id_1, t0.id_lang AS id_lang_2, t0.name AS name_3, t0.id_size AS id_size_4 FROM sizes_langs t0 WHERE t0.id_size = ?
Parameters:
[
  59
]
16 0.27 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:
[
  13660
]
17 0.21 ms
SELECT t0.id_size AS id_size_1, t0.size_key AS size_key_2 FROM sizes t0 WHERE t0.id_size = ?
Parameters:
[
  60
]
18 0.24 ms
SELECT t0.id AS id_1, t0.id_lang AS id_lang_2, t0.name AS name_3, t0.id_size AS id_size_4 FROM sizes_langs t0 WHERE t0.id_size = ?
Parameters:
[
  60
]
19 0.30 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:
[
  13661
]
20 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:
[
  61
]
21 0.26 ms
SELECT t0.id AS id_1, t0.id_lang AS id_lang_2, t0.name AS name_3, t0.id_size AS id_size_4 FROM sizes_langs t0 WHERE t0.id_size = ?
Parameters:
[
  61
]
22 0.37 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:
[
  13662
]
23 0.28 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
]
24 0.31 ms
SELECT t0.id AS id_1, t0.id_lang AS id_lang_2, t0.name AS name_3, t0.id_size AS id_size_4 FROM sizes_langs t0 WHERE t0.id_size = ?
Parameters:
[
  62
]
25 0.25 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:
[
  13663
]
26 0.22 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:
[
  272
]
27 0.27 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:
[
  272
]
28 0.26 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:
[
  13664
]
29 0.33 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:
[
  13665
]
30 0.27 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:
[
  13666
]
31 0.26 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:
[
  13667
]
32 0.26 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:
[
  13668
]
33 0.25 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:
[
  13669
]
34 0.22 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:
[
  273
]
35 0.24 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:
[
  273
]
36 0.28 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:
[
  13670
]
37 0.27 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:
[
  13671
]
38 0.31 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:
[
  13672
]
39 0.26 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:
[
  13673
]
40 0.29 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:
[
  13675
]
41 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:
[
  274
]
42 0.26 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:
[
  274
]
43 0.28 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:
[
  13676
]
44 0.29 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:
[
  13677
]
45 0.24 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:
[
  13678
]
46 0.27 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:
[
  13679
]
47 0.73 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:
[
  13680
]
48 0.25 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:
[
  13681
]
49 0.19 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:
[
  275
]
50 0.21 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:
[
  275
]
51 0.20 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:
[
  13682
]
52 0.20 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:
[
  13683
]
53 0.56 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:
[
  13684
]
54 0.28 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:
[
  13685
]
55 0.24 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:
[
  13686
]
56 0.21 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:
[
  13687
]
57 0.21 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:
[
  276
]
58 0.22 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:
[
  276
]
59 0.20 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:
[
  13688
]
60 0.20 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:
[
  13689
]
61 0.18 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:
[
  13690
]
62 0.21 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:
[
  13691
]
63 0.23 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:
[
  13692
]

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\VariantLang 175
App\Entity\Variant 35
App\Entity\SizeLang 30
App\Entity\ColorLang 30
App\Entity\ProductColor 6
App\Entity\ProductSize 6
App\Entity\Size 6
App\Entity\Color 6
App\Entity\Lang 5
App\Entity\ProductLang 5
App\Entity\Product 1
App\Entity\Model 1

Entities Mapping

Class Mapping errors
App\Entity\Lang No errors.
App\Entity\Product
  • The mappings App\Entity\Product#sizeTables and App\Entity\SizeTable#product are inconsistent with each other.
App\Entity\Model No errors.
App\Entity\ProductLang No errors.
App\Entity\Category No errors.
App\Entity\ProductTechnique 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\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\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\Size
  • The mappings App\Entity\Size#sizeLangs and App\Entity\SizeLang#size are inconsistent with each other.
App\Entity\Color No errors.
App\Entity\ProductTechniquePlacementMockupTemplate No errors.
App\Entity\Resource\Image No errors.
App\Entity\Resource\CatalogImage No errors.
App\Entity\VariantLang No errors.
App\Entity\VariantProductTechnique No errors.
App\Entity\VariantDimension 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.