Query Metrics

15 Database Queries
5 Different statements
2.57 ms Query time
0 Invalid entities
24 Managed entities

Queries

Group similar statements

# 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