Query Metrics
15
Database Queries
5
Different statements
2.57 ms
Query time
0
Invalid entities
24
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.93 ms (36.20%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.system_name AS system_name_3, t0.`desc` AS desc_4, t0.min AS min_5, t0.max AS max_6, t0.allow_multiple_selection AS allow_multiple_selection_7, t0.internal_notes AS internal_notes_8, t0.sku AS sku_9 FROM connector_groups t0 WHERE t0.id = ?
Parameters:
[
"279f5399-9794-4fb8-a06a-054c8731d081"
]
|
|
0.89 ms (34.45%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.system_name AS system_name_3, t0.`desc` AS desc_4, t0.price AS price_5, t0.discount_price AS discount_price_6, t0.is_option AS is_option_7, t0.internal_notes AS internal_notes_8, t0.sku AS sku_9, t0.ean AS ean_10, t0.pos_product_ext_id AS pos_product_ext_id_11, t0.option_order AS option_order_12, t0.cod_impuesto AS cod_impuesto_13, t0.images AS images_14, t0.connector_group_id AS connector_group_id_15 FROM connector_group_options t0 WHERE t0.connector_group_id = ? ORDER BY t0.option_order ASC
Parameters:
[
"279f5399-9794-4fb8-a06a-054c8731d081"
]
|
|
0.29 ms (11.08%) |
1 |
SELECT t0.id AS id_1, t0.group_order AS group_order_2, t0.product_id AS product_id_3, t0.connector_group_id AS connector_group_id_4 FROM connector_product_groups t0 WHERE t0.product_id = ? ORDER BY t0.group_order ASC
Parameters:
[
"7b2a69ef-79b9-4872-943e-8d983e08fb15"
]
|
|
0.26 ms (9.98%) |
1 |
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.system_name AS system_name_4, t0.`desc` AS desc_5, t0.price AS price_6, t0.is_option AS is_option_7, t0.internal_notes AS internal_notes_8, t0.ean AS ean_9, t0.pos_product AS pos_product_10, t0.channels_fine_tuning AS channels_fine_tuning_11, t0.images AS images_12, t0.cod_impuesto AS cod_impuesto_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM connector_products t0 WHERE t0.id = ?
Parameters:
[
"7b2a69ef-79b9-4872-943e-8d983e08fb15"
]
|
|
0.21 ms (8.28%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.codvendedor AS codvendedor_6, t0.is_enabled AS is_enabled_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
145
]
|
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\ConnectorGroupOption | 10 |
| App\Entity\ConnectorProductGroup | 6 |
| App\Entity\ConnectorGroup | 6 |
| App\Entity\User | 1 |
| App\Entity\ConnectorProduct | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Cabecera | No errors. |
| App\Entity\Domicilios | No errors. |
| App\Entity\ConnectorProduct | No errors. |
| App\Entity\ConnectorCatalogProduct | No errors. |
| App\Entity\ConnectorProductGroup | No errors. |
| App\Entity\ConnectorGroup | No errors. |
| App\Entity\ConnectorGroupOption | No errors. |