Query Metrics
17
Database Queries
4
Different statements
5.96 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.43 ms |
SELECT t0.identifier AS identifier_1, t0.expiry AS expiry_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.revoked AS revoked_5, t0.client AS client_6 FROM oauth2_access_token t0 WHERE t0.identifier = ?
Parameters:
[
"2a25bd67a924ae578d801697ded1fd827aba490bab0dc291505aaf5543b723d8aeed6560cc6f2b14"
]
|
| 2 | 0.28 ms |
SELECT t0.id AS id_1, t0.commission_rate AS commission_rate_2, t0.commission_rate_monthly AS commission_rate_monthly_3, t0.commission_rate_manager AS commission_rate_manager_4, t0.commission_rate_monthly_manager AS commission_rate_monthly_manager_5, t0.coefs AS coefs_6, t0.algo_conditions AS algo_conditions_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM setting t0 WHERE ((t0.deleted_at IS NULL))
Parameters:
[] |
| 3 | 1.85 ms |
SELECT f0_.id AS id_0, f0_.label AS label_1, f0_.filter_order AS filter_order_2, f0_.keywords AS keywords_3, f0_.created_at AS created_at_4, f0_.updated_at AS updated_at_5, f0_.deleted_at AS deleted_at_6, f1_.id AS id_7, f1_.label AS label_8, f1_.filter_order AS filter_order_9, f1_.keywords AS keywords_10, f1_.created_at AS created_at_11, f1_.updated_at AS updated_at_12, f1_.deleted_at AS deleted_at_13, f0_.filter_group_id AS filter_group_id_14, f1_.filter_group_id AS filter_group_id_15 FROM filter f0_ LEFT JOIN filter_group f2_ ON f0_.filter_group_id = f2_.id AND (f2_.deleted_at IS NULL) LEFT JOIN filter_filter f3_ ON f0_.id = f3_.filter_target LEFT JOIN filter f1_ ON f1_.id = f3_.filter_source AND (f1_.deleted_at IS NULL) WHERE (f0_.id IN (SELECT f4_.id FROM filter f4_ LEFT JOIN filter_group f5_ ON f4_.filter_group_id = f5_.id AND (f5_.deleted_at IS NULL) WHERE (f5_.value = ?) AND (f4_.deleted_at IS NULL))) AND (f0_.deleted_at IS NULL) ORDER BY f0_.filter_order ASC
Parameters:
[
"FUNCTION"
]
|
| 4 | 0.47 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"5e87194c-b08f-41b8-b9df-cf893cea9553"
]
|
| 5 | 0.26 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"fbc15216-f458-465a-ad1e-f9bcfbae44eb"
]
|
| 6 | 0.27 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"8e9e7b3e-a8f6-4f83-b0ac-9cbc8a4ae7f2"
]
|
| 7 | 0.24 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"784b0f55-03eb-4063-98ef-1db2e482647f"
]
|
| 8 | 0.23 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"cb29fba1-25be-4ce6-897d-7dae4dcaea30"
]
|
| 9 | 0.15 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"370260a6-5aca-4fc3-8004-a34325da1022"
]
|
| 10 | 0.12 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"ccb021fe-4b2f-4bbd-9035-5fbe19f3876a"
]
|
| 11 | 0.25 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"bb63ea62-09f6-4300-aa9d-31642d4e4a19"
]
|
| 12 | 0.28 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"3395b0ad-1115-4561-8cba-8b69ddf7a480"
]
|
| 13 | 0.19 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"336caa8a-0f88-4a55-a525-5e182d57976e"
]
|
| 14 | 0.28 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"e34e2e09-ceda-4be7-bfb3-1564df7863b6"
]
|
| 15 | 0.25 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"f005de80-0737-4202-9bd2-ff51139e5d51"
]
|
| 16 | 0.24 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"5a301a6b-54c8-4d0a-9832-c449bcb079a7"
]
|
| 17 | 0.19 ms |
SELECT t0.id AS id_1, t0.label AS label_2, t0.filter_order AS filter_order_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.filter_group_id AS filter_group_id_8 FROM filter t0 INNER JOIN filter_filter ON t0.id = filter_filter.filter_source WHERE filter_filter.filter_target = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"21a482db-8262-40ff-ab8a-cf1a6074206d"
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Filter | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\AccessToken | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\AbstractClient | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\Client | No errors. |
| App\Entity\FilterGroup | No errors. |
| App\Entity\Setting | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\User | No errors. |
| App\Entity\UserCompany | No errors. |
| App\Entity\UserManager | No errors. |
| App\Entity\UserManagerSkill | No errors. |
| App\Entity\ManagerDiploma | No errors. |
| App\Entity\MissionCompany | No errors. |
| App\Entity\SearchManager | No errors. |
| App\Entity\UserManagerExperience | No errors. |
| App\Entity\MissionCompanyUserManager | No errors. |