https://dev.app.pol-crm.com/api/V4/sections/50c091cc7a284cc0be77eb0e419f69e4 Return to referer URL

Query Metrics

17 Database Queries
8 Different statements
14.68 ms Query time
0 Invalid entities

Queries

Group similar statements

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.