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

Query Metrics

80 Database Queries
9 Different statements
33.11 ms Query time
8 Invalid entities
398 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.37 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:
[
  412
]
3 0.52 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:
[
  412
]
4 0.38 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:
[
  412
]
5 0.77 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:
[
  11265
]
6 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:
[
  63
]
7 0.29 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:
[
  63
]
8 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:
[
  6
]
9 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:
[
  6
]
10 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:
[
  11266
]
11 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:
[
  57
]
12 0.22 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
]
13 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:
[
  11267
]
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:
[
  58
]
15 0.22 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
]
16 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:
[
  11268
]
17 0.19 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
]
18 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
]
19 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:
[
  11269
]
20 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
]
21 0.21 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
]
22 0.22 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:
[
  11270
]
23 0.17 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
]
24 0.21 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
]
25 0.22 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:
[
  11271
]
26 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:
[
  5
]
27 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:
[
  5
]
28 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:
[
  11272
]
29 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:
[
  11273
]
30 0.22 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:
[
  11274
]
31 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:
[
  11275
]
32 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:
[
  11276
]
33 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:
[
  11277
]
34 0.18 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:
[
  185
]
35 1.02 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:
[
  185
]
36 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:
[
  11278
]
37 0.79 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:
[
  11279
]
38 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:
[
  11280
]
39 0.71 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:
[
  11281
]
40 1.08 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:
[
  11282
]
41 0.50 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:
[
  11283
]
42 0.35 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:
[
  186
]
43 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:
[
  186
]
44 0.43 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:
[
  11284
]
45 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:
[
  11285
]
46 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:
[
  11286
]
47 0.43 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:
[
  11287
]
48 0.38 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:
[
  11288
]
49 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:
[
  13833
]
50 0.40 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:
[
  188
]
51 0.49 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:
[
  188
]
52 0.38 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:
[
  13834
]
53 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:
[
  13835
]
54 1.76 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:
[
  13836
]
55 0.71 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:
[
  13837
]
56 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:
[
  13838
]
57 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:
[
  13839
]
58 0.67 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:
[
  87
]
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:
[
  87
]
60 0.53 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:
[
  13840
]
61 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:
[
  13841
]
62 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:
[
  13842
]
63 0.65 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:
[
  13843
]
64 1.95 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:
[
  13844
]
65 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:
[
  13845
]
66 0.28 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:
[
  45
]
67 0.59 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:
[
  45
]
68 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:
[
  13846
]
69 0.36 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:
[
  13847
]
70 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:
[
  13848
]
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:
[
  13849
]
72 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:
[
  13850
]
73 1.16 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:
[
  13851
]
74 0.27 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:
[
  187
]
75 1.87 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:
[
  187
]
76 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:
[
  13852
]
77 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:
[
  13853
]
78 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:
[
  13854
]
79 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:
[
  13855
]
80 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:
[
  13856
]

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 240
App\Entity\Variant 48
App\Entity\ColorLang 40
App\Entity\SizeLang 30
App\Entity\ProductColor 8
App\Entity\Color 8
App\Entity\ProductSize 6
App\Entity\Size 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.