GET https://swiftcrm.com/all/templates/tag/Wedding_Photography_Agreement?s=Sports

Query Metrics

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

Queries

Group similar statements

default connection

# Time Info
1 2.17 ms
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:
[
  "%Wedding_Photography_Agreement%"
  1
]
2 0.64 ms
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.last_shuttle_at AS last_shuttle_at_15, t0.preferences AS preferences_16, t0.business_name AS business_name_17, t0.human_name AS human_name_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t21.id AS id_22, t21.token AS token_23, t21.expires_at AS expires_at_24, t21.generated_at AS generated_at_25, t21.user_id AS user_id_26, t27.id AS id_28, t27.last_value_date AS last_value_date_29, t27.total_value_count AS total_value_count_30, t27.value_types_json AS value_types_json_31, t27.user_id AS user_id_32, t33.id AS id_34, t33.last_shuttle_at AS last_shuttle_at_35, t33.last_email_sent_at AS last_email_sent_at_36, t33.last_email_received_at AS last_email_received_at_37, t33.last_form_submit_at AS last_form_submit_at_38, t33.last_esign_at AS last_esign_at_39, t33.last_login_at AS last_login_at_40, t33.last_page_view_at AS last_page_view_at_41, t33.total_emails_sent AS total_emails_sent_42, t33.total_forms_received AS total_forms_received_43, t33.total_esigns AS total_esigns_44, t33.total_shuttles AS total_shuttles_45, t33.signup_at AS signup_at_46, t33.pulse_score AS pulse_score_47, t33.extended_json AS extended_json_48, t33.updated_at AS updated_at_49, t33.user_id AS user_id_50 FROM 001_login t0 LEFT JOIN 010_user_password_reset t21 ON t21.user_id = t0.id LEFT JOIN 950_meaus t27 ON t27.user_id = t0.id LEFT JOIN 951_account_pulse t33 ON t33.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.
App\Entity\Main\AccountPulse No errors.

dynamic_conn entity manager

No loaded entities.