Query Metrics
15
Database Queries
5
Different statements
2.57 ms
Query time
0
Invalid entities
24
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.21 ms |
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
]
|
| 2 | 0.26 ms |
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"
]
|
| 3 | 0.29 ms |
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"
]
|
| 4 | 0.20 ms |
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"
]
|
| 5 | 0.19 ms |
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"
]
|
| 6 | 0.14 ms |
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:
[
"27dbc6a7-1ade-423f-971f-2f51500f7c3e"
]
|
| 7 | 0.13 ms |
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:
[
"27dbc6a7-1ade-423f-971f-2f51500f7c3e"
]
|
| 8 | 0.13 ms |
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:
[
"509ad156-cfa7-4d87-a0c9-23b2be7abb82"
]
|
| 9 | 0.14 ms |
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:
[
"509ad156-cfa7-4d87-a0c9-23b2be7abb82"
]
|
| 10 | 0.23 ms |
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:
[
"ecb155f0-6fe1-4ead-9018-edbdf04b1650"
]
|
| 11 | 0.16 ms |
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:
[
"ecb155f0-6fe1-4ead-9018-edbdf04b1650"
]
|
| 12 | 0.12 ms |
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:
[
"dd5c76d8-6485-4845-a8d6-d6c5fa03bac9"
]
|
| 13 | 0.14 ms |
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:
[
"dd5c76d8-6485-4845-a8d6-d6c5fa03bac9"
]
|
| 14 | 0.12 ms |
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:
[
"f2ee7c75-d4d6-4e54-aba4-c6bfa59ded84"
]
|
| 15 | 0.12 ms |
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:
[
"f2ee7c75-d4d6-4e54-aba4-c6bfa59ded84"
]
|
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. |