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

Query Metrics

64 Database Queries
9 Different statements
21.51 ms Query time
8 Invalid entities
312 Managed entities

Queries

Group similar statements

# Time Info
1 0.45 ms
SELECT t0.id_lang AS id_lang_1, t0.iso_code AS iso_code_2 FROM langs t0
Parameters:
[]
2 0.64 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:
[
  880
]
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:
[
  880
]
4 0.39 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:
[
  880
]
5 0.32 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:
[
  22734
]
6 0.30 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.30 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.25 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:
[
  67
]
9 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:
[
  67
]
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:
[
  22735
]
11 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:
[
  359
]
12 0.29 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:
[
  359
]
13 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:
[
  22736
]
14 0.25 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:
[
  471
]
15 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:
[
  471
]
16 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:
[
  22737
]
17 0.23 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:
[
  472
]
18 0.25 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:
[
  472
]
19 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:
[
  22740
]
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:
[
  58
]
21 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:
[
  58
]
22 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:
[
  22741
]
23 0.32 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:
[
  22742
]
24 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:
[
  22743
]
25 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:
[
  22746
]
26 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:
[
  59
]
27 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
]
28 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:
[
  22747
]
29 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:
[
  22748
]
30 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:
[
  22749
]
31 0.32 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:
[
  22752
]
32 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:
[
  60
]
33 0.27 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
]
34 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:
[
  22753
]
35 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:
[
  22754
]
36 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:
[
  22755
]
37 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:
[
  22758
]
38 0.26 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
]
39 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
]
40 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:
[
  22759
]
41 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:
[
  22760
]
42 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:
[
  22761
]
43 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:
[
  22764
]
44 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:
[
  62
]
45 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:
[
  62
]
46 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:
[
  22765
]
47 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:
[
  22766
]
48 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:
[
  22767
]
49 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:
[
  22770
]
50 0.23 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:
[
  473
]
51 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:
[
  473
]
52 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:
[
  22771
]
53 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:
[
  22772
]
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:
[
  22773
]
55 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:
[
  22774
]
56 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:
[
  22775
]
57 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:
[
  22776
]
58 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:
[
  474
]
59 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:
[
  474
]
60 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:
[
  22777
]
61 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:
[
  22778
]
62 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:
[
  22779
]
63 0.86 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:
[
  22780
]
64 3.06 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:
[
  22781
]

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 180
App\Entity\Variant 36
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.