Query Metrics
4
Database Queries
4
Different statements
5.41 ms
Query time
0
Invalid entities
14
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.77 ms |
SELECT count(DISTINCT w0_.id) AS sclr_0 FROM wish w0_ LEFT JOIN voucher v1_ ON w0_.voucher_id = v1_.id LEFT JOIN voucher_vendor v2_ ON v1_.voucher_vendor_id = v2_.id LEFT JOIN `user` u3_ ON w0_.user_id = u3_.id
Parameters:
[] |
||||||||||||||||||||||
| 2 | 1.28 ms |
SELECT DISTINCT w0_.id AS id_0, w0_.created_at AS created_at_1 FROM wish w0_ LEFT JOIN voucher v1_ ON w0_.voucher_id = v1_.id LEFT JOIN voucher_vendor v2_ ON v1_.voucher_vendor_id = v2_.id LEFT JOIN `user` u3_ ON w0_.user_id = u3_.id ORDER BY w0_.created_at ASC LIMIT 9 OFFSET 9
Parameters:
[] |
||||||||||||||||||||||
| 3 | 1.53 ms |
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.description AS description_2, w0_.created_at AS created_at_3, w0_.funded_amount AS funded_amount_4, w0_.status AS status_5, w0_.found_start AS found_start_6, w0_.found_end AS found_end_7, w0_.queue_position AS queue_position_8, w0_.approved_at AS approved_at_9, w0_.rejected_at AS rejected_at_10, w0_.rejection_reason AS rejection_reason_11, v1_.id AS id_12, v1_.importo AS importo_13, v2_.id AS id_14, v2_.nome AS nome_15, v2_.immagine AS immagine_16, u3_.id AS id_17, u3_.email AS email_18, u3_.roles AS roles_19, u3_.password AS password_20, u3_.first_name AS first_name_21, u3_.last_name AS last_name_22, u3_.phone AS phone_23, u3_.google_id AS google_id_24, u3_.facebook_id AS facebook_id_25, u3_.needs_completion AS needs_completion_26, u3_.is_email_verified AS is_email_verified_27, u3_.is_phone_verified AS is_phone_verified_28, u3_.is_active AS is_active_29, u3_.newsletter_consent AS newsletter_consent_30, u3_.marketing_consent AS marketing_consent_31, u3_.my_referral_code AS my_referral_code_32, u3_.used_referral_code AS used_referral_code_33, u3_.referral_points AS referral_points_34, u3_.email_verified_at AS email_verified_at_35, u3_.phone_verified_at AS phone_verified_at_36, u3_.last_login_at AS last_login_at_37, u3_.created_at AS created_at_38, u3_.updated_at AS updated_at_39, u3_.email_verification_token AS email_verification_token_40, u3_.phone_verification_code AS phone_verification_code_41, u3_.phone_verification_code_expires_at AS phone_verification_code_expires_at_42, u3_.password_reset_token AS password_reset_token_43, u3_.password_reset_token_expires_at AS password_reset_token_expires_at_44, u3_.last_phone_code_sent_at AS last_phone_code_sent_at_45, u3_.phone_code_attempts AS phone_code_attempts_46, w0_.user_id AS user_id_47, w0_.voucher_id AS voucher_id_48, w0_.approved_by_id AS approved_by_id_49, w0_.rejected_by_id AS rejected_by_id_50, v1_.voucher_vendor_id AS voucher_vendor_id_51, v1_.assigned_voucher_code_id AS assigned_voucher_code_id_52 FROM wish w0_ LEFT JOIN voucher v1_ ON w0_.voucher_id = v1_.id LEFT JOIN voucher_vendor v2_ ON v1_.voucher_vendor_id = v2_.id LEFT JOIN `user` u3_ ON w0_.user_id = u3_.id WHERE w0_.id IN (?, ?, ?) ORDER BY w0_.created_at ASC
Parameters:
[ 34 39 48 ] |
||||||||||||||||||||||
| 4 | 0.82 ms |
SELECT t0.id AS id_1, t0.nome AS nome_2, t0.immagine AS immagine_3 FROM voucher_vendor t0 ORDER BY t0.nome ASC
Parameters:
[]
|
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\Entity\VoucherVendor | 6 |
| App\Entity\Wish | 3 |
| App\Entity\Voucher | 3 |
| App\Entity\User | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Wish | No errors. |
| App\Entity\Voucher | No errors. |
| App\Entity\VoucherVendor | No errors. |
| App\Entity\User | No errors. |
| App\Entity\VoucherCode | No errors. |