GET https://platinum.vortice.dev/

Query Metrics

13 Database Queries
4 Different statements
6.18 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 3.20 ms
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM erp_product e0_
Parameters:
[]
2 0.09 ms
SELECT DISTINCT e0_.id AS id_0 FROM erp_product e0_ LIMIT 10
Parameters:
[]
3 0.16 ms
SELECT e0_.id AS id_0, e0_.description AS description_1, e0_.brand_dingo AS brand_dingo_2, e0_.created_at AS created_at_3, e0_.updated_at AS updated_at_4, e0_.synchronized_at AS synchronized_at_5 FROM erp_product e0_ WHERE e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  3
  4
  5
  6
  7
  8
  9
  10
]
4 2.44 ms
SELECT t0.id AS id_1, t0.identification AS identification_2, t0.unit_volume AS unit_volume_3, t0.gross_weight AS gross_weight_4, t0.inventory AS inventory_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.synchronized_at AS synchronized_at_8, t0.to_be_synced AS to_be_synced_9, t0.product_id AS product_id_10 FROM erp_variant t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
5 0.03 ms
SELECT t0.id AS id_1, t0.identification AS identification_2, t0.unit_volume AS unit_volume_3, t0.gross_weight AS gross_weight_4, t0.inventory AS inventory_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.synchronized_at AS synchronized_at_8, t0.to_be_synced AS to_be_synced_9, t0.product_id AS product_id_10 FROM erp_variant t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
6 0.03 ms
SELECT t0.id AS id_1, t0.identification AS identification_2, t0.unit_volume AS unit_volume_3, t0.gross_weight AS gross_weight_4, t0.inventory AS inventory_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.synchronized_at AS synchronized_at_8, t0.to_be_synced AS to_be_synced_9, t0.product_id AS product_id_10 FROM erp_variant t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
7 0.03 ms
SELECT t0.id AS id_1, t0.identification AS identification_2, t0.unit_volume AS unit_volume_3, t0.gross_weight AS gross_weight_4, t0.inventory AS inventory_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.synchronized_at AS synchronized_at_8, t0.to_be_synced AS to_be_synced_9, t0.product_id AS product_id_10 FROM erp_variant t0 WHERE t0.product_id = ?
Parameters:
[
  4
]
8 0.03 ms
SELECT t0.id AS id_1, t0.identification AS identification_2, t0.unit_volume AS unit_volume_3, t0.gross_weight AS gross_weight_4, t0.inventory AS inventory_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.synchronized_at AS synchronized_at_8, t0.to_be_synced AS to_be_synced_9, t0.product_id AS product_id_10 FROM erp_variant t0 WHERE t0.product_id = ?
Parameters:
[
  5
]
9 0.03 ms
SELECT t0.id AS id_1, t0.identification AS identification_2, t0.unit_volume AS unit_volume_3, t0.gross_weight AS gross_weight_4, t0.inventory AS inventory_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.synchronized_at AS synchronized_at_8, t0.to_be_synced AS to_be_synced_9, t0.product_id AS product_id_10 FROM erp_variant t0 WHERE t0.product_id = ?
Parameters:
[
  6
]
10 0.03 ms
SELECT t0.id AS id_1, t0.identification AS identification_2, t0.unit_volume AS unit_volume_3, t0.gross_weight AS gross_weight_4, t0.inventory AS inventory_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.synchronized_at AS synchronized_at_8, t0.to_be_synced AS to_be_synced_9, t0.product_id AS product_id_10 FROM erp_variant t0 WHERE t0.product_id = ?
Parameters:
[
  7
]
11 0.03 ms
SELECT t0.id AS id_1, t0.identification AS identification_2, t0.unit_volume AS unit_volume_3, t0.gross_weight AS gross_weight_4, t0.inventory AS inventory_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.synchronized_at AS synchronized_at_8, t0.to_be_synced AS to_be_synced_9, t0.product_id AS product_id_10 FROM erp_variant t0 WHERE t0.product_id = ?
Parameters:
[
  8
]
12 0.03 ms
SELECT t0.id AS id_1, t0.identification AS identification_2, t0.unit_volume AS unit_volume_3, t0.gross_weight AS gross_weight_4, t0.inventory AS inventory_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.synchronized_at AS synchronized_at_8, t0.to_be_synced AS to_be_synced_9, t0.product_id AS product_id_10 FROM erp_variant t0 WHERE t0.product_id = ?
Parameters:
[
  9
]
13 0.03 ms
SELECT t0.id AS id_1, t0.identification AS identification_2, t0.unit_volume AS unit_volume_3, t0.gross_weight AS gross_weight_4, t0.inventory AS inventory_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.synchronized_at AS synchronized_at_8, t0.to_be_synced AS to_be_synced_9, t0.product_id AS product_id_10 FROM erp_variant t0 WHERE t0.product_id = ?
Parameters:
[
  10
]

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\ErpProduct
  • The mappings App\Entity\ErpProduct#variants and App\Entity\ErpVariant#product are inconsistent with each other.
App\Entity\ErpVariant
  • The association App\Entity\ErpVariant#product refers to the inverse side field App\Entity\ErpProduct#erpVariants which does not exist.
App\Entity\ErpSellPrice No errors.