Query Metrics
17
Database Queries
8
Different statements
14.68 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.84 ms |
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" ] |
2 | 0.21 ms |
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" ] |
3 | 1.57 ms |
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" ] |
4 | 1.26 ms |
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" "edef9b56d050471e9eb9982d44048bfb" ] |
5 | 1.40 ms |
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" ] |
6 | 0.83 ms |
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"
]
|
7 | 1.09 ms |
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"
]
|
8 | 0.33 ms |
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:
[
"a62751dd02734376b67cce6bafbf4df5"
]
|
9 | 0.18 ms |
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:
[
"4c15f87a861c41bcb4238538112875c7"
]
|
10 | 0.52 ms |
"START TRANSACTION"
Parameters:
[] |
11 | 0.33 ms |
INSERT INTO saved_request_section (id, section_id, saved_request_id) VALUES (?, ?, ?)
Parameters:
[ 1 => "70dd0da750624103ad979c383b066ca8" 2 => "50c091cc7a284cc0be77eb0e419f69e4" 3 => "64fa1391b80c4755908da254473cb542" ] |
12 | 0.12 ms |
INSERT INTO saved_request_section (id, section_id, saved_request_id) VALUES (?, ?, ?)
Parameters:
[ 1 => "a62751dd02734376b67cce6bafbf4df5" 2 => "50c091cc7a284cc0be77eb0e419f69e4" 3 => "7a4c932b6feb47f3b9c87d2d577db9d8" ] |
13 | 0.09 ms |
INSERT INTO saved_request_section (id, section_id, saved_request_id) VALUES (?, ?, ?)
Parameters:
[ 1 => "4c15f87a861c41bcb4238538112875c7" 2 => "50c091cc7a284cc0be77eb0e419f69e4" 3 => "9bf6047891a5410b83667c73e5c993cf" ] |
14 | 0.22 ms |
DELETE FROM saved_request_section WHERE id = ?
Parameters:
[
"714bd454b3cc46c981654bdbc47f138c"
]
|
15 | 0.14 ms |
DELETE FROM saved_request_section WHERE id = ?
Parameters:
[
"7c635542aa62445eb81c963d9de63b7b"
]
|
16 | 0.53 ms |
DELETE FROM saved_request_section WHERE id = ?
Parameters:
[
"e8b6fcdef78c48d0b9df59d237939787"
]
|
17 | 5.00 ms |
"COMMIT"
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.