Query Metrics
1
Database Queries
1
Different statements
13.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
13.20 ms (100.00%) |
1 |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.date AS date_4, t0.email AS email_5, t0.signature AS signature_6, t0.npa AS npa_7, t0.address AS address_8, t0.address2 AS address2_9, t0.locality AS locality_10, t0.updated_at AS updated_at_11, t0.anonymous AS anonymous_12, t0.company AS company_13, t0.validated_at AS validated_at_14, t0.hash AS hash_15, t0.text AS text_16, t0.note AS note_17, t0.invoiced_at AS invoiced_at_18, t0.printed_at AS printed_at_19, t0.reminder_at AS reminder_at_20, t0.reference AS reference_21, t0.reminder_printed_at AS reminder_printed_at_22, t0.completed_by_donor AS completed_by_donor_23, t0.ip_address AS ip_address_24, t0.phone_number AS phone_number_25, t0.demand_sent_at AS demand_sent_at_26, t0.use_twint_jm AS use_twint_jm_27, t0.created_by_id AS created_by_id_28, t29.id AS id_30, t29.username AS username_31, t29.roles AS roles_32, t29.password AS password_33, t29.hash AS hash_34, t29.email AS email_35, t29.firstname AS firstname_36, t29.lastname AS lastname_37, t29.no_carnet AS no_carnet_38, t29.phone AS phone_39, t29.identification_hash AS identification_hash_40, t29.active AS active_41, t29.show_notification AS show_notification_42, t29.locale AS locale_43, t29.domain_id AS domain_id_44, t0.updated_by_id AS updated_by_id_45, t0.payment_mode_id AS payment_mode_id_46, t47.id AS id_48, t47.name AS name_49, t47.description AS description_50, t0.printed_by_id AS printed_by_id_51, t0.reminder_printed_by_id AS reminder_printed_by_id_52, t53.id AS id_54, t53.token AS token_55, t53.pairing_uuid AS pairing_uuid_56, t53.order_uuid AS order_uuid_57, t53.timestamp AS timestamp_58, t53.paid AS paid_59, t53.merchant_transaction_reference AS merchant_transaction_reference_60, t53.order_pending AS order_pending_61, t53.annonceur_id AS annonceur_id_62, t63.values AS values_64, t63.annonceur_id AS annonceur_id_65 FROM annonceur t0 INNER JOIN fosuser t29 ON t0.created_by_id = t29.id INNER JOIN payment_mode t47 ON t0.payment_mode_id = t47.id LEFT JOIN twint_payment t53 ON t53.annonceur_id = t0.id LEFT JOIN annonceur_extra_value t63 ON t63.annonceur_id = t0.id WHERE t0.hash = ? LIMIT 1
Parameters:
[
"06886630-96b2-42fc-9c79-4a0e816a110d"
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Annonceur | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Domain | No errors. |
| App\Entity\PaymentMode | No errors. |
| App\Entity\TwintPayment | No errors. |
| App\Entity\AnnonceurExtraValue | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\AnnonceurItemPurchase | No errors. |
| App\Entity\EmailLog | No errors. |
| App\Entity\PaymentGroup | No errors. |
| App\Entity\Task | No errors. |
| App\Entity\Template | No errors. |
| App\Entity\Item | No errors. |
| App\Entity\JMPaymentDomain | No errors. |