http://demoshop.to2facil.com/api/v1/product/product_168_202502080032

Query Metrics

7 Database Queries
7 Different statements
17.49 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.47 ms
(31.30%)
1
SELECT t0.id AS id_1, t0.cost AS cost_2, t0.delivery AS delivery_3, t0.qty AS qty_4, t0.product_id AS product_id_5, t6.id AS id_7, t6.name AS name_8, t6.name_en AS name_en_9, t6.description AS description_10, t6.description_en AS description_en_11, t6.type AS type_12, t6.price AS price_13, t6.real_price AS real_price_14, t6.promoted AS promoted_15, t6.discount AS discount_16, t6.tax AS tax_17, t6.tax_type AS tax_type_18, t6.slug AS slug_19, t6.keyword AS keyword_20, t6.image AS image_21, t6.query_search AS query_search_22, t6.conditions AS conditions_23, t6.suffix AS suffix_24, t6.deleted AS deleted_25, t6.active AS active_26, t6.created_at AS created_at_27, t6.updated_at AS updated_at_28, t6.provider_id AS provider_id_29, t0.municipality_id AS municipality_id_30, t31.id AS id_32, t31.name AS name_33, t31.province_id AS province_id_34 FROM r_product_shipping t0 LEFT JOIN d_product t6 ON t0.product_id = t6.id INNER JOIN d_municipality t31 ON t0.municipality_id = t31.id WHERE t0.product_id = ?
Parameters:
[
  168
]
4.26 ms
(24.36%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.description AS description_4, t0.image AS image_5, t0.picture AS picture_6, t0.keyword AS keyword_7, t0.is_promoted AS is_promoted_8, t0.slug AS slug_9, t0.color AS color_10, t0.color1 AS color1_11, t0.color2 AS color2_12, t0.is_active AS is_active_13, t0.category_id AS category_id_14 FROM d_category t0 INNER JOIN r_category_product ON t0.id = r_category_product.category_id WHERE r_category_product.product_id = ?
Parameters:
[
  168
]
3.00 ms
(17.18%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.description AS description_4, t0.description_en AS description_en_5, t0.type AS type_6, t0.price AS price_7, t0.real_price AS real_price_8, t0.promoted AS promoted_9, t0.discount AS discount_10, t0.tax AS tax_11, t0.tax_type AS tax_type_12, t0.slug AS slug_13, t0.keyword AS keyword_14, t0.image AS image_15, t0.query_search AS query_search_16, t0.conditions AS conditions_17, t0.suffix AS suffix_18, t0.deleted AS deleted_19, t0.active AS active_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.provider_id AS provider_id_23 FROM d_product t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "product_168_202502080032"
]
1.57 ms
(8.98%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.description AS description_4, t0.image AS image_5, t0.feature AS feature_6, t0.slug AS slug_7, t0.keyword AS keyword_8, t0.user_id AS user_id_9 FROM d_provider t0 WHERE t0.id = ?
Parameters:
[
  5
]
1.49 ms
(8.53%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.unit AS unit_4, t0.unit_en AS unit_en_5, t0.qty AS qty_6, t0.product_id AS product_id_7 FROM d_sub_product t0 WHERE t0.product_id = ?
Parameters:
[
  168
]
1.35 ms
(7.71%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.unit AS unit_4, t0.unit_en AS unit_en_5, t0.qty AS qty_6, t0.product_id AS product_id_7 FROM d_product_offer t0 WHERE t0.product_id = ?
Parameters:
[
  168
]
0.34 ms
(1.94%)
1
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3, t0.type AS type_4 FROM s_setting t0
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
App\Entity\Setting No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\Product No errors.
App\Entity\Provider No errors.
App\Entity\Category No errors.
App\Entity\ApiProduct No errors.
App\Entity\SubProduct No errors.
App\Entity\ProductOffer No errors.
App\Entity\ProductShipping No errors.
App\Entity\Coupon No errors.
App\Entity\Municipality No errors.
App\Entity\Province No errors.
App\Entity\Beneficiary No errors.
App\Entity\User
  • The mappings App\Entity\User#paymentErrors and App\Entity\PaymentError#user are inconsistent with each other.