Query Metrics
179
Database Queries
17
Different statements
49.80 ms
Query time
0
Invalid entities
284
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
21.93 ms (44.03%) |
91 |
SELECT t0.id AS id_1, t0.expected_label AS expected_label_2, t0.aliases AS aliases_3, t0.config AS config_4, t0.setup_version_id AS setup_version_id_5, t0.product_feature_binding_id AS product_feature_binding_id_6, t0.feature_item_id AS feature_item_id_7 FROM setup_feature_item_ui_binding t0 WHERE t0.setup_version_id = ? AND t0.product_feature_binding_id = ? AND t0.feature_item_id = ? LIMIT 1
Parameters:
[ 62 582 45 ]
|
||||||||||||||||||||||||||||
|
6.02 ms (12.09%) |
22 |
SELECT t0.id AS id_1, t0.action_key AS action_key_2, t0.sort_order AS sort_order_3, t0.interaction_type AS interaction_type_4, t0.value_source_type AS value_source_type_5, t0.value_source_key AS value_source_key_6, t0.config AS config_7, t0.workflow_step_id AS workflow_step_id_8, t0.screen_reference_id AS screen_reference_id_9, t0.target_element_id AS target_element_id_10, t0.container_element_id AS container_element_id_11, t0.verification_element_id AS verification_element_id_12 FROM setup_product_workflow_ui_action t0 WHERE t0.workflow_step_id = ? ORDER BY t0.sort_order ASC, t0.id ASC
Parameters:
[
387
]
|
||||||||||||||||||||||||||||
|
3.63 ms (7.30%) |
14 |
SELECT t0.id AS id_1, t0.element_key AS element_key_2, t0.name AS name_3, t0.element_type AS element_type_4, t0.locator AS locator_5, t0.expected_label AS expected_label_6, t0.aliases AS aliases_7, t0.required AS required_8, t0.stable_anchor AS stable_anchor_9, t0.text_input_mode AS text_input_mode_10, t0.metadata AS metadata_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.screen_reference_id AS screen_reference_id_14 FROM setup_screen_element t0 WHERE t0.id = ?
Parameters:
[
1693
]
|
||||||||||||||||||||||||||||
|
3.44 ms (6.90%) |
12 |
SELECT t0.id AS id_1, t0.action_key AS action_key_2, t0.sort_order AS sort_order_3, t0.interaction_type AS interaction_type_4, t0.value_source_type AS value_source_type_5, t0.value_source_key AS value_source_key_6, t0.config AS config_7, t0.product_feature_binding_id AS product_feature_binding_id_8, t0.workflow_step_id AS workflow_step_id_9, t0.screen_reference_id AS screen_reference_id_10, t0.target_element_id AS target_element_id_11, t0.container_element_id AS container_element_id_12, t0.verification_element_id AS verification_element_id_13 FROM setup_product_feature_ui_action t0 WHERE t0.product_feature_binding_id = ? ORDER BY t0.sort_order ASC, t0.id ASC
Parameters:
[
582
]
|
||||||||||||||||||||||||||||
|
3.42 ms (6.87%) |
12 |
SELECT t0.id AS id_1, t0.expected_label AS expected_label_2, t0.aliases AS aliases_3, t0.config AS config_4, t0.setup_version_id AS setup_version_id_5, t0.product_feature_id AS product_feature_id_6, t0.screen_reference_id AS screen_reference_id_7 FROM setup_product_feature_ui_binding t0 WHERE t0.setup_version_id = ? AND t0.product_feature_id = ? LIMIT 1
Parameters:
[ 62 14 ]
|
||||||||||||||||||||||||||||
|
2.93 ms (5.89%) |
11 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.system_name AS system_name_3, t0.by_attach_file AS by_attach_file_4, t0.feature_item_type AS feature_item_type_5, t0.related_source_key AS related_source_key_6, t0.scene_position AS scene_position_7, t0.scene_row_style AS scene_row_style_8, t0.vin_id AS vin_id_9, t0.product_feature_id AS product_feature_id_10 FROM feature_item t0 WHERE t0.product_feature_id = ?
Parameters:
[
14
]
|
||||||||||||||||||||||||||||
|
1.46 ms (2.94%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.verification_token AS verification_token_6, t0.reset_token AS reset_token_7, t0.reset_token_expires_at AS reset_token_expires_at_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.verify_code AS verify_code_11, t0.verify_code_created_at AS verify_code_created_at_12, t0.jwt_token AS jwt_token_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM "user" t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"admin@admin.com"
]
|
||||||||||||||||||||||||||||
|
1.08 ms (2.16%) |
3 |
SELECT t0.id AS id_1, t0.scope_key AS scope_key_2, t0.step_key AS step_key_3, t0.sort_order AS sort_order_4, t0.step_type AS step_type_5, t0.config AS config_6, t0.setup_version_id AS setup_version_id_7, t0.product_id AS product_id_8, t0.product_feature_id AS product_feature_id_9 FROM setup_product_workflow_step t0 WHERE t0.setup_version_id = ? AND t0.product_id = ? ORDER BY t0.id ASC
Parameters:
[ 62 15 ]
|
||||||||||||||||||||||||||||
|
1.06 ms (2.13%) |
3 |
SELECT t0.id AS id_1, t0.completion_mode AS completion_mode_2, t0.expected_label AS expected_label_3, t0.aliases AS aliases_4, t0.config AS config_5, t0.setup_version_id AS setup_version_id_6, t0.product_id AS product_id_7, t0.screen_reference_id AS screen_reference_id_8, t0.tab_element_id AS tab_element_id_9, t0.completion_element_id AS completion_element_id_10, t0.completion_screen_reference_id AS completion_screen_reference_id_11 FROM setup_product_ui_binding t0 WHERE t0.setup_version_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ 62 15 ]
|
||||||||||||||||||||||||||||
|
0.82 ms (1.64%) |
1 |
SELECT t0.id AS id_1, t0.version_number AS version_number_2, t0.status AS status_3, t0.notes AS notes_4, t0.validation_passed_at AS validation_passed_at_5, t0.activated_at AS activated_at_6, t0.archived_at AS archived_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.agent_profile_id AS agent_profile_id_10 FROM agent_profile_setup_version t0 WHERE t0.agent_profile_id = ? ORDER BY t0.version_number DESC, t0.id DESC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.81 ms (1.64%) |
3 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.system_name AS system_name_3, t0.feature_index AS feature_index_4, t0.product_id AS product_id_5 FROM product_feature t0 WHERE t0.product_id = ?
Parameters:
[
15
]
|
||||||||||||||||||||||||||||
|
0.72 ms (1.44%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.system_name AS system_name_3, t0.token_hash AS token_hash_4, t0.status AS status_5, t0.last_seen_at AS last_seen_at_6, t0.connected_at AS connected_at_7, t0.disconnected_at AS disconnected_at_8, t0.disconnect_alerted_at AS disconnect_alerted_at_9, t0.handler_disconnected_at AS handler_disconnected_at_10, t0.handler_disconnect_alerted_at AS handler_disconnect_alerted_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.desired_state AS desired_state_14, t0.connection_state AS connection_state_15, t0.setup_state AS setup_state_16, t0.handler_state AS handler_state_17, t0.observer_state AS observer_state_18, t0.profile_state AS profile_state_19, t0.auth_mode AS auth_mode_20, t0.auth_state AS auth_state_21, t0.ready_for_tasks AS ready_for_tasks_22, t0.readiness_blockers AS readiness_blockers_23, t0.runtime_config_selected_mode AS runtime_config_selected_mode_24, t0.runtime_config_active_mode AS runtime_config_active_mode_25, t0.current_order_id AS current_order_id_26, t0.agent_profile_id AS agent_profile_id_27, t0.runtime_config_selected_id AS runtime_config_selected_id_28, t0.runtime_config_active_id AS runtime_config_active_id_29 FROM agent t0 WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||
|
0.58 ms (1.16%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.profile_key AS profile_key_3, t0.description AS description_4, t0.target_program AS target_program_5, t0.target_mode AS target_mode_6, t0.handler_mode AS handler_mode_7, t0.handler_protocol_version AS handler_protocol_version_8, t0.command_set_key AS command_set_key_9, t0.command_set_version AS command_set_version_10, t0.observer_mode AS observer_mode_11, t0.active AS active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM agent_profile t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.53 ms (1.07%) |
1 |
SELECT t0.id AS id_1, t0.status AS status_2, t0.started_at AS started_at_3, t0.finished_at AS finished_at_4, t0.summary AS summary_5, t0.error AS error_6, t0.created_at AS created_at_7, t0.setup_version_id AS setup_version_id_8, t0.agent_id AS agent_id_9 FROM setup_validation_run t0 WHERE t0.setup_version_id = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
62
]
|
||||||||||||||||||||||||||||
|
0.49 ms (0.98%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.system_name AS system_name_3, t0.token_hash AS token_hash_4, t0.status AS status_5, t0.last_seen_at AS last_seen_at_6, t0.connected_at AS connected_at_7, t0.disconnected_at AS disconnected_at_8, t0.disconnect_alerted_at AS disconnect_alerted_at_9, t0.handler_disconnected_at AS handler_disconnected_at_10, t0.handler_disconnect_alerted_at AS handler_disconnect_alerted_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.desired_state AS desired_state_14, t0.connection_state AS connection_state_15, t0.setup_state AS setup_state_16, t0.handler_state AS handler_state_17, t0.observer_state AS observer_state_18, t0.profile_state AS profile_state_19, t0.auth_mode AS auth_mode_20, t0.auth_state AS auth_state_21, t0.ready_for_tasks AS ready_for_tasks_22, t0.readiness_blockers AS readiness_blockers_23, t0.runtime_config_selected_mode AS runtime_config_selected_mode_24, t0.runtime_config_active_mode AS runtime_config_active_mode_25, t0.current_order_id AS current_order_id_26, t0.agent_profile_id AS agent_profile_id_27, t0.runtime_config_selected_id AS runtime_config_selected_id_28, t0.runtime_config_active_id AS runtime_config_active_id_29 FROM agent t0 WHERE t0.agent_profile_id = ? ORDER BY t0.name ASC, t0.id ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.45 ms (0.90%) |
1 |
SELECT t0.id AS id_1, t0.screen_key AS screen_key_2, t0.name AS name_3, t0.role AS role_4, t0.auth_state AS auth_state_5, t0.recognition_config AS recognition_config_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.setup_version_id AS setup_version_id_9 FROM setup_screen_reference t0 WHERE t0.setup_version_id = ?
Parameters:
[
62
]
|
||||||||||||||||||||||||||||
|
0.43 ms (0.86%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.system_name AS system_name_3, t0.is_active AS is_active_4, t0.type AS type_5, t0.agent_profile_id AS agent_profile_id_6 FROM product t0 WHERE t0.agent_profile_id = ?
Parameters:
[
1
]
|
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\FeatureItem | 91 |
| App\Entity\FeatureItemUiBinding | 91 |
| App\Entity\SetupProductWorkflowStep | 22 |
| App\Entity\ScreenElement | 17 |
| App\Entity\ProductFeature | 12 |
| App\Entity\ProductFeatureUiBinding | 12 |
| App\Entity\ProductFeatureUiAction | 12 |
| App\Entity\ScreenReference | 8 |
| App\Entity\SetupProductWorkflowUiAction | 6 |
| App\Entity\Product | 3 |
| App\Entity\ProductUiBinding | 3 |
| App\Entity\AgentRuntimeConfiguration | 2 |
| App\Entity\User | 1 |
| App\Entity\AgentProfile | 1 |
| App\Entity\AgentProfileSetupVersion | 1 |
| App\Entity\SetupValidationRun | 1 |
| App\Entity\Agent | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken | No errors. |
| App\Entity\RefreshToken | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Vin | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\AgentProfile | No errors. |
| App\Entity\Agent | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\AgentProfileSetupVersion | No errors. |
| App\Entity\ScreenReference | No errors. |
| App\Entity\ProductFeature | No errors. |
| App\Entity\ProductPaymentMethod | No errors. |
| App\Entity\ProductUiBinding | No errors. |
| App\Entity\ScreenElement | No errors. |
| App\Entity\FeatureItem | No errors. |
| App\Entity\ProductFeatureUiBinding | No errors. |
| App\Entity\ProductFeatureUiAction | No errors. |
| App\Entity\SetupProductWorkflowStep | No errors. |
| App\Entity\FeatureItemUiBinding | No errors. |
| App\Entity\SetupProductWorkflowUiAction | No errors. |
| App\Entity\SetupValidationRun | No errors. |
| App\Entity\AgentRuntimeConfiguration | No errors. |
| App\Entity\AgentOrderTask | No errors. |
| App\Entity\AgentEvent | No errors. |