Query Metrics
5
Database Queries
5
Different statements
178.34 ms
Query time
0
Invalid entities
369
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.85 ms (99.73%) |
1 |
SELECT p0_.id AS id_0, p0_.pay_date AS pay_date_1, p0_.check_no AS check_no_2, p0_.pmnt_no AS pmnt_no_3, p0_.gross AS gross_4, p0_.fed_tax AS fed_tax_5, p0_.ss_tax AS ss_tax_6, p0_.ss_tax2 AS ss_tax2_7, p0_.medi_tax AS medi_tax_8, p0_.futa_tax AS futa_tax_9, p0_.ss_inc_tax AS ss_inc_tax_10, p0_.ss_unem_tax AS ss_unem_tax_11, p0_.oth_tax AS oth_tax_12, p0_.hins AS hins_13, p0_.tins AS tins_14, p0_.oins AS oins_15, p0_.other1 AS other1_16, p0_.other2 AS other2_17, p0_.draws AS draws_18, p0_.reimb AS reimb_19, p0_.net_paid AS net_paid_20, p0_.ded_tot AS ded_tot_21, p0_.escrow AS escrow_22, p0_.per_diem AS per_diem_23, p0_.runtime_settings AS runtime_settings_24, p0_.box12a_code AS box12a_code_25, p0_.box12a_amount AS box12a_amount_26, p0_.box12b_code AS box12b_code_27, p0_.box12b_amount AS box12b_amount_28, p0_.box12c_code AS box12c_code_29, p0_.box12c_amount AS box12c_amount_30, p0_.box12d_code AS box12d_code_31, p0_.box12d_amount AS box12d_amount_32, p0_.accounts_id AS accounts_id_33, p0_.drivers_id AS drivers_id_34, p0_.accounts_id AS accounts_id_35, p0_.drivers_id AS drivers_id_36 FROM payroll_paid p0_ WHERE p0_.accounts_id = ? AND p0_.drivers_id = ?
Parameters:
[ 2980 23204 ]
|
||||||||||||||||||||||||||||
|
0.15 ms (0.08%) |
1 |
SELECT t0.id AS id_1, t0.accounts_id AS accounts_id_2, t0.address_id AS address_id_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.driver_code AS driver_code_6, t0.options AS options_7, t0.fast_id AS fast_id_8, t0.middle_name AS middle_name_9, t0.suffix AS suffix_10, t0.email_address AS email_address_11, t0.memo AS memo_12, t0.date_hired AS date_hired_13, t0.date_terminated AS date_terminated_14, t0.date_of_birth AS date_of_birth_15, t0.license_expiry AS license_expiry_16, t0.medical_exam_due AS medical_exam_due_17, t0.updated AS updated_18, t0.license_state AS license_state_19, t0.sms_carrier AS sms_carrier_20, t0.vacation_days_due AS vacation_days_due_21, t0.vacation_days_taken AS vacation_days_taken_22, t0.is_active AS is_active_23, t0.is_deleted AS is_deleted_24 FROM drivers t0 WHERE t0.id = ? AND t0.accounts_id = ? LIMIT 1
Parameters:
[ 23204 2980 ]
|
||||||||||||||||||||||||||||
|
0.12 ms (0.07%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.salt AS salt_4, t0.email AS email_5, t0.email_validated AS email_validated_6, t0.is_active AS is_active_7, t0.is_deleted AS is_deleted_8, t0.timestamp AS timestamp_9, t0.login_count AS login_count_10, t0.last_login AS last_login_11, t0.user_session_id AS user_session_id_12, t0.last_login_ua_hash AS last_login_ua_hash_13, t0.permission_level AS permission_level_14, t0.type AS type_15, t0.is_driver AS is_driver_16, t0.security_question AS security_question_17, t0.security_answer AS security_answer_18, t0.company_name AS company_name_19, t0.setup_status AS setup_status_20, t0.user_permissions AS user_permissions_21, t0.tutor_list AS tutor_list_22, t0.subscription_id AS subscription_id_23, t0.billing_cycle AS billing_cycle_24, t0.failedAttempts AS failedAttempts_25, t0.lockoutUntil AS lockoutUntil_26, t0.resetToken AS resetToken_27, t0.tokenRequestedAt AS tokenRequestedAt_28, t0.forcePasswordChange AS forcePasswordChange_29, t0.account AS account_30, t0.user_preferences_id AS user_preferences_id_31 FROM users t0 WHERE t0.id = ?
Parameters:
[
3765
]
|
||||||||||||||||||||||||||||
|
0.12 ms (0.07%) |
1 |
SELECT p0_.id AS id_0, p0_.pay_date AS pay_date_1, p0_.check_no AS check_no_2, p0_.pmnt_no AS pmnt_no_3, p0_.gross AS gross_4, p0_.fed_tax AS fed_tax_5, p0_.ss_tax AS ss_tax_6, p0_.ss_tax2 AS ss_tax2_7, p0_.medi_tax AS medi_tax_8, p0_.futa_tax AS futa_tax_9, p0_.ss_inc_tax AS ss_inc_tax_10, p0_.ss_unem_tax AS ss_unem_tax_11, p0_.oth_tax AS oth_tax_12, p0_.hins AS hins_13, p0_.tins AS tins_14, p0_.oins AS oins_15, p0_.other1 AS other1_16, p0_.other2 AS other2_17, p0_.draws AS draws_18, p0_.reimb AS reimb_19, p0_.net_paid AS net_paid_20, p0_.ded_tot AS ded_tot_21, p0_.escrow AS escrow_22, p0_.per_diem AS per_diem_23, p0_.runtime_settings AS runtime_settings_24, p0_.box12a_code AS box12a_code_25, p0_.box12a_amount AS box12a_amount_26, p0_.box12b_code AS box12b_code_27, p0_.box12b_amount AS box12b_amount_28, p0_.box12c_code AS box12c_code_29, p0_.box12c_amount AS box12c_amount_30, p0_.box12d_code AS box12d_code_31, p0_.box12d_amount AS box12d_amount_32, p0_.accounts_id AS accounts_id_33, p0_.drivers_id AS drivers_id_34, p0_.accounts_id AS accounts_id_35, p0_.drivers_id AS drivers_id_36 FROM payroll_paid p0_ WHERE p0_.accounts_id = ? AND p0_.drivers_id = ? AND p0_.pmnt_no = ? ORDER BY p0_.id DESC LIMIT 1
Parameters:
[ 2980 23204 "WARTCR01071126" ]
|
||||||||||||||||||||||||||||
|
0.10 ms (0.05%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.id_federal AS id_federal_3, t0.id_mc AS id_mc_4, t0.id_dot AS id_dot_5, t0.id_ifta AS id_ifta_6, t0.is_active AS is_active_7, t0.is_deleted AS is_deleted_8, t0.subscription_state AS subscription_state_9, t0.secondary_address AS secondary_address_10, t0.secondary_suite AS secondary_suite_11, t0.secondary_city AS secondary_city_12, t0.secondary_state AS secondary_state_13, t0.secondary_zip AS secondary_zip_14, t0.id_federal_essence AS id_federal_essence_15, t0.state_id_number AS state_id_number_16, t0.user_count AS user_count_17, t0.secondary_phone AS secondary_phone_18, t0.secondary_fax AS secondary_fax_19, t0.address_accounts AS address_accounts_20 FROM accounts t0 WHERE t0.id = ?
Parameters:
[
2980
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| sessions | doctrine.dbal.sessions_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| sessions | doctrine.orm.sessions_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\PayrollPaid | 364 |
| App\Entity\Users | 1 |
| App\Entity\Accounts | 1 |
| App\Entity\UserPreferences | 1 |
| App\Entity\Addresses | 1 |
| App\Entity\Drivers | 1 |
sessions entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Users | No errors. |
| App\Entity\Accounts | No errors. |
| App\Entity\UserPreferences | No errors. |
| App\Entity\Addresses | No errors. |
| App\Entity\Drivers | No errors. |
| App\Entity\PayrollPaid | No errors. |
sessions entity manager
No loaded entities.