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

Query Metrics

74 Database Queries
9 Different statements
23.37 ms Query time
8 Invalid entities
362 Managed entities

Queries

Group similar statements

# Time Info
1 0.38 ms
SELECT t0.id_lang AS id_lang_1, t0.iso_code AS iso_code_2 FROM langs t0
Parameters:
[]
2 0.36 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:
[
  834
]
3 0.47 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:
[
  834
]
4 0.74 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:
[
  834
]
5 0.34 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:
[
  21038
]
6 0.24 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.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:
[
  6
]
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:
[
  6
]
10 0.48 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:
[
  21039
]
11 0.26 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:
[
  226
]
12 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:
[
  226
]
13 0.39 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:
[
  21040
]
14 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:
[
  21
]
15 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:
[
  21
]
16 0.42 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:
[
  21041
]
17 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:
[
  5
]
18 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:
[
  5
]
19 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:
[
  21042
]
20 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:
[
  58
]
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:
[
  58
]
22 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:
[
  21043
]
23 0.35 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:
[
  21044
]
24 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:
[
  21045
]
25 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:
[
  21046
]
26 0.42 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.33 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.34 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:
[
  21047
]
29 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:
[
  21048
]
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:
[
  21049
]
31 0.54 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:
[
  21050
]
32 0.24 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.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:
[
  60
]
34 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:
[
  21051
]
35 0.45 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:
[
  21052
]
36 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:
[
  21053
]
37 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:
[
  21054
]
38 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
]
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.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:
[
  21055
]
41 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:
[
  21056
]
42 0.34 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:
[
  21057
]
43 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:
[
  21058
]
44 0.27 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 1.07 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.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:
[
  21059
]
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:
[
  21060
]
48 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:
[
  21061
]
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:
[
  21062
]
50 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:
[
  65
]
51 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:
[
  65
]
52 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:
[
  21063
]
53 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:
[
  21064
]
54 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:
[
  21065
]
55 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:
[
  21066
]
56 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:
[
  66
]
57 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:
[
  66
]
58 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:
[
  21067
]
59 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:
[
  21068
]
60 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:
[
  21069
]
61 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:
[
  21070
]
62 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:
[
  228
]
63 0.33 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:
[
  228
]
64 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:
[
  21071
]
65 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:
[
  21072
]
66 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:
[
  21073
]
67 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:
[
  21074
]
68 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:
[
  21078
]
69 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:
[
  442
]
70 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:
[
  442
]
71 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:
[
  21079
]
72 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:
[
  21080
]
73 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:
[
  21081
]
74 0.34 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:
[
  21082
]

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 210
App\Entity\Variant 42
App\Entity\SizeLang 40
App\Entity\ColorLang 30
App\Entity\ProductSize 8
App\Entity\Size 8
App\Entity\ProductColor 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.