Query Metrics
6
Database Queries
4
Different statements
1.08 ms
Query time
0
Invalid entities
15
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.20 ms |
SELECT t0.short_name AS short_name_1, t0.long_name AS long_name_2, t0.img AS img_3, t0.description AS description_4, t0.id AS id_5 FROM service t0
Parameters:
[]
|
||||||||||||||||||||||
| 2 | 0.10 ms |
SELECT t0.name AS name_1, t0.title AS title_2, t0.img AS img_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.id AS id_6 FROM testimonial t0
Parameters:
[]
|
||||||||||||||||||||||
| 3 | 0.25 ms |
SELECT t0.website AS website_1, t0.last_login AS last_login_2, t0.sex AS sex_3, t0.nickname AS nickname_4, t0.birthday AS birthday_5, t0.bio AS bio_6, t0.experience AS experience_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.skills AS skills_10, t0.is_active AS is_active_11, t0.is_public AS is_public_12, t0.is_searchable AS is_searchable_13, t0.is_team AS is_team_14, t0.team_title AS team_title_15, t0.social_links AS social_links_16, t0.id AS id_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.loc_country AS loc_country_20, t0.loc_state AS loc_state_21, t0.loc_city AS loc_city_22, t0.loc_address AS loc_address_23, t0.loc_post AS loc_post_24, t0.user_id AS user_id_25 FROM core_user_profile t0 WHERE t0.is_team = ?
Parameters:
[
1
]
|
||||||||||||||||||||||
| 4 | 0.20 ms |
SELECT t0.email AS email_1, t0.is_verified AS is_verified_2, t0.roles AS roles_3, t0.status AS status_4, t0.terms AS terms_5, t0.password AS password_6, t0.id AS id_7, t0.slug AS slug_8, t0.phone AS phone_9, t10.website AS website_11, t10.last_login AS last_login_12, t10.sex AS sex_13, t10.nickname AS nickname_14, t10.birthday AS birthday_15, t10.bio AS bio_16, t10.experience AS experience_17, t10.firstname AS firstname_18, t10.lastname AS lastname_19, t10.skills AS skills_20, t10.is_active AS is_active_21, t10.is_public AS is_public_22, t10.is_searchable AS is_searchable_23, t10.is_team AS is_team_24, t10.team_title AS team_title_25, t10.social_links AS social_links_26, t10.id AS id_27, t10.created_at AS created_at_28, t10.updated_at AS updated_at_29, t10.loc_country AS loc_country_30, t10.loc_state AS loc_state_31, t10.loc_city AS loc_city_32, t10.loc_address AS loc_address_33, t10.loc_post AS loc_post_34, t10.user_id AS user_id_35, t36.privacy AS privacy_37, t36.id AS id_38, t36.user_id AS user_id_39 FROM core_user t0 LEFT JOIN core_user_profile t10 ON t10.user_id = t0.id LEFT JOIN core_user_prefs t36 ON t36.user_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||
| 5 | 0.17 ms |
SELECT t0.email AS email_1, t0.is_verified AS is_verified_2, t0.roles AS roles_3, t0.status AS status_4, t0.terms AS terms_5, t0.password AS password_6, t0.id AS id_7, t0.slug AS slug_8, t0.phone AS phone_9, t10.website AS website_11, t10.last_login AS last_login_12, t10.sex AS sex_13, t10.nickname AS nickname_14, t10.birthday AS birthday_15, t10.bio AS bio_16, t10.experience AS experience_17, t10.firstname AS firstname_18, t10.lastname AS lastname_19, t10.skills AS skills_20, t10.is_active AS is_active_21, t10.is_public AS is_public_22, t10.is_searchable AS is_searchable_23, t10.is_team AS is_team_24, t10.team_title AS team_title_25, t10.social_links AS social_links_26, t10.id AS id_27, t10.created_at AS created_at_28, t10.updated_at AS updated_at_29, t10.loc_country AS loc_country_30, t10.loc_state AS loc_state_31, t10.loc_city AS loc_city_32, t10.loc_address AS loc_address_33, t10.loc_post AS loc_post_34, t10.user_id AS user_id_35, t36.privacy AS privacy_37, t36.id AS id_38, t36.user_id AS user_id_39 FROM core_user t0 LEFT JOIN core_user_profile t10 ON t10.user_id = t0.id LEFT JOIN core_user_prefs t36 ON t36.user_id = t0.id WHERE t0.id = ?
Parameters:
[
294
]
|
||||||||||||||||||||||
| 6 | 0.16 ms |
SELECT t0.email AS email_1, t0.is_verified AS is_verified_2, t0.roles AS roles_3, t0.status AS status_4, t0.terms AS terms_5, t0.password AS password_6, t0.id AS id_7, t0.slug AS slug_8, t0.phone AS phone_9, t10.website AS website_11, t10.last_login AS last_login_12, t10.sex AS sex_13, t10.nickname AS nickname_14, t10.birthday AS birthday_15, t10.bio AS bio_16, t10.experience AS experience_17, t10.firstname AS firstname_18, t10.lastname AS lastname_19, t10.skills AS skills_20, t10.is_active AS is_active_21, t10.is_public AS is_public_22, t10.is_searchable AS is_searchable_23, t10.is_team AS is_team_24, t10.team_title AS team_title_25, t10.social_links AS social_links_26, t10.id AS id_27, t10.created_at AS created_at_28, t10.updated_at AS updated_at_29, t10.loc_country AS loc_country_30, t10.loc_state AS loc_state_31, t10.loc_city AS loc_city_32, t10.loc_address AS loc_address_33, t10.loc_post AS loc_post_34, t10.user_id AS user_id_35, t36.privacy AS privacy_37, t36.id AS id_38, t36.user_id AS user_id_39 FROM core_user t0 LEFT JOIN core_user_profile t10 ON t10.user_id = t0.id LEFT JOIN core_user_prefs t36 ON t36.user_id = t0.id WHERE t0.id = ?
Parameters:
[
434
]
|
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\Addon\Entity\Service | 4 |
| App\Addon\Entity\UserProfile | 3 |
| App\Entity\User | 3 |
| App\Addon\Entity\UserPreferences | 3 |
| App\Addon\Entity\Testimonial | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Addon\Entity\Service | No errors. |
| App\Addon\Entity\Testimonial | No errors. |
| App\Addon\Entity\UserProfile | No errors. |
| App\Entity\User | No errors. |
| App\Addon\Entity\UserPreferences | No errors. |
| App\Addon\Entity\Credit | No errors. |