Query Metrics
17
Database Queries
8
Different statements
14.68 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
5.00 ms (0.00%) |
1 |
"COMMIT"
Parameters:
[] |
3.88 ms (0.00%) |
4 |
SELECT s0_.id AS id_0, s0_.customer_id AS customer_id_1, s0_.entity AS entity_2, s0_.type AS type_3, s0_.name AS name_4, s0_.content AS content_5, s0_.tab_id AS tab_id_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.created_by AS created_by_9, s0_.updated_by AS updated_by_10, s0_.deleted_at AS deleted_at_11 FROM saved_request s0_ INNER JOIN saved_request_section s1_ ON s0_.id = s1_.saved_request_id WHERE (s0_.customer_id = ? AND s1_.section_id = ?) AND (s0_.customer_id = '0662705af65c48908b017d8fb0724bac') AND (s0_.deleted_at IS NULL)
Parameters:
[ "0662705af65c48908b017d8fb0724bac" "50c091cc7a284cc0be77eb0e419f69e4" ] |
1.60 ms (0.00%) |
3 |
SELECT t0.id AS id_1, t0.section_id AS section_id_2, t0.saved_request_id AS saved_request_id_3 FROM saved_request_section t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"70dd0da750624103ad979c383b066ca8"
]
|
1.40 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.customer_id AS customer_id_2, t0.entity AS entity_3, t0.type AS type_4, t0.name AS name_5, t0.content AS content_6, t0.tab_id AS tab_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.deleted_at AS deleted_at_12 FROM saved_request t0 WHERE t0.customer_id = ? AND t0.type = ? AND ((t0.customer_id = '0662705af65c48908b017d8fb0724bac') AND (t0.deleted_at IS NULL))
Parameters:
[ "0662705af65c48908b017d8fb0724bac" "section_filter" ] |
0.89 ms (0.00%) |
3 |
DELETE FROM saved_request_section WHERE id = ?
Parameters:
[
"714bd454b3cc46c981654bdbc47f138c"
]
|
0.83 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.section_id AS section_id_2, t0.saved_request_id AS saved_request_id_3 FROM saved_request_section t0 WHERE t0.section_id = ?
Parameters:
[
"50c091cc7a284cc0be77eb0e419f69e4"
]
|
0.54 ms (0.00%) |
3 |
INSERT INTO saved_request_section (id, section_id, saved_request_id) VALUES (?, ?, ?)
Parameters:
[ 1 => "70dd0da750624103ad979c383b066ca8" 2 => "50c091cc7a284cc0be77eb0e419f69e4" 3 => "64fa1391b80c4755908da254473cb542" ] |
0.52 ms (0.00%) |
1 |
"START TRANSACTION"
Parameters:
[] |
legacy connection
No database queries were performed.
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
legacy | doctrine.dbal.legacy_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
legacy | doctrine.orm.legacy_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
App\V4\Entity\SavedRequest | No errors. |
App\V4\Entity\SavedRequestSection | No errors. |
App\V4\Webhook\Entity\WebhookLog | No errors. |
App\V4\Entity\CustomAction | No errors. |
legacy entity manager
No loaded entities.