GET https://swiftcrm.com/all/templates/tag/lease_contract_

Query Metrics

2 Database Queries
2 Different statements
2.85 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
2.44 ms
(85.54%)
1
SELECT t0_.id AS id_0, t0_.drive_all_id AS drive_all_id_1, t0_.type AS type_2, t0_.sub_type AS sub_type_3, t0_.name AS name_4, t0_.file_url AS file_url_5, t0_.slug AS slug_6, t0_.is_template AS is_template_7, t0_.meta_json AS meta_json_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.user_id AS user_id_11 FROM 300_user_drive t0_ WHERE t0_.meta_json LIKE ? AND t0_.is_template = ?
Parameters:
[
  "%lease_contract_%"
  1
]
0.41 ms
(14.46%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.personal_username AS personal_username_4, t0.roles AS roles_5, t0.companies AS companies_6, t0.active_company AS active_company_7, t0.password AS password_8, t0.database_name AS database_name_9, t0.last_logged_in AS last_logged_in_10, t0.stripe_subscription_id AS stripe_subscription_id_11, t0.stripe_subscription_status AS stripe_subscription_status_12, t0.stripe_subscription_updated_at AS stripe_subscription_updated_at_13, t0.scid AS scid_14, t0.preferences AS preferences_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t18.id AS id_19, t18.token AS token_20, t18.expires_at AS expires_at_21, t18.generated_at AS generated_at_22, t18.user_id AS user_id_23, t24.id AS id_25, t24.last_value_date AS last_value_date_26, t24.total_value_count AS total_value_count_27, t24.value_types_json AS value_types_json_28, t24.user_id AS user_id_29 FROM 001_login t0 LEFT JOIN 010_user_password_reset t18 ON t18.user_id = t0.id LEFT JOIN 950_meaus t24 ON t24.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  68
]

Database Connections

Name Service
default doctrine.dbal.default_connection
dynamic_conn doctrine.dbal.dynamic_conn_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
dynamic_conn doctrine.orm.dynamic_conn_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Main\UserDrive No errors.
App\Entity\Main\User No errors.
App\Entity\Main\UserPasswordReset No errors.
App\Entity\Main\Meaus No errors.

dynamic_conn entity manager

No loaded entities.