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

Query Metrics

30 Database Queries
9 Different statements
17.73 ms Query time
8 Invalid entities
122 Managed entities

Queries

Group similar statements

# Time Info
1 0.33 ms
SELECT t0.id_lang AS id_lang_1, t0.iso_code AS iso_code_2 FROM langs t0
Parameters:
[]
2 0.74 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:
[
  781
]
3 3.88 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:
[
  781
]
4 0.81 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:
[
  781
]
5 0.68 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:
[
  21030
]
6 0.71 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 1.58 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.34 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:
[
  408
]
9 0.63 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:
[
  408
]
10 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:
[
  21032
]
11 0.29 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
]
12 1.60 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
]
13 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:
[
  21033
]
14 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
]
15 0.86 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
]
16 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:
[
  21034
]
17 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:
[
  64
]
18 0.23 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:
[
  64
]
19 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:
[
  21035
]
20 0.20 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.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:
[
  58
]
22 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:
[
  21036
]
23 0.20 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
]
24 0.23 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
]
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:
[
  21037
]
26 0.20 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
]
27 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
]
28 0.80 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:
[
  21169
]
29 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
]
30 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
]

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 40
App\Entity\SizeLang 40
App\Entity\Variant 8
App\Entity\ProductSize 8
App\Entity\Size 8
App\Entity\Lang 5
App\Entity\ProductLang 5
App\Entity\ColorLang 5
App\Entity\Product 1
App\Entity\ProductColor 1
App\Entity\Color 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.