Query Metrics
7
Database Queries
7
Different statements
17.49 ms
Query time
1
Invalid entities
Grouped Statements
| 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 |
|