GET https://app.casaq.ch/cron/emails/scheduled

Query Metrics

1 Database Queries
1 Different statements
0.77 ms Query time
1 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.77 ms
SELECT a0_.id AS id_0, a0_.from_email AS from_email_1, a0_.from_name AS from_name_2, a0_.to_recipients AS to_recipients_3, a0_.cc_recipients AS cc_recipients_4, a0_.bcc_recipients AS bcc_recipients_5, a0_.subject AS subject_6, a0_.html_body AS html_body_7, a0_.text_body AS text_body_8, a0_.status AS status_9, a0_.mailgun_message_id AS mailgun_message_id_10, a0_.error_message AS error_message_11, a0_.sent_at AS sent_at_12, a0_.created_at AS created_at_13, a0_.attachments AS attachments_14, a0_.scheduled_at AS scheduled_at_15, a1_.id AS id_16, a1_.nom AS nom_17, a1_.ville AS ville_18, a1_.telephone AS telephone_19, a1_.email AS email_20, a1_.adresse AS adresse_21, a1_.npa AS npa_22, a1_.actif AS actif_23, a1_.afficher_listing AS afficher_listing_24, a1_.created_at AS created_at_25, a1_.updated_at AS updated_at_26, a1_.addresses AS addresses_27, a1_.website AS website_28, u2_.id AS id_29, u2_.email AS email_30, u2_.prenom AS prenom_31, u2_.nom AS nom_32, u2_.roles AS roles_33, u2_.password AS password_34, u2_.actif AS actif_35, u2_.created_at AS created_at_36, u2_.updated_at AS updated_at_37, u2_.agence_role AS agence_role_38, u2_.active_session_token AS active_session_token_39, u2_.telephone AS telephone_40, u2_.profile_image AS profile_image_41, a3_.id AS id_42, a3_.email AS email_43, a3_.from_name AS from_name_44, a3_.is_default_for_agence AS is_default_for_agence_45, a3_.active AS active_46, a3_.created_at AS created_at_47, a0_.agence_id AS agence_id_48, a0_.user_id AS user_id_49, a0_.sender_identity_id AS sender_identity_id_50, a0_.bien_id AS bien_id_51, a0_.contact_id AS contact_id_52, a1_.subscription_plan_id AS subscription_plan_id_53, u2_.agence_id AS agence_id_54, u2_.filiale_id AS filiale_id_55, a3_.agence_id AS agence_id_56, a3_.domain_id AS domain_id_57, a3_.user_id AS user_id_58 FROM agence_mail_message a0_ LEFT JOIN agence a1_ ON a0_.agence_id = a1_.id LEFT JOIN user u2_ ON a0_.user_id = u2_.id LEFT JOIN agence_mail_identity a3_ ON a0_.sender_identity_id = a3_.id WHERE a0_.status = ? AND a0_.scheduled_at IS NOT NULL AND a0_.scheduled_at <= ? ORDER BY a0_.scheduled_at ASC LIMIT 25
Parameters:
[
  "scheduled"
  "2026-07-02 13:04:03"
]

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

Entities Mapping

Class Mapping errors
App\Entity\AgenceMailMessage No errors.
App\Entity\Agence
  • The field App\Entity\Agence#pdfSettings is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AgencePdfSettings#agence does not contain the required 'inversedBy: "pdfSettings"' attribute.
App\Entity\User No errors.
App\Entity\AgenceMailIdentity No errors.
App\Entity\Bien No errors.
App\Entity\Contact No errors.
App\Entity\SubscriptionPlan No errors.
App\Entity\AgenceFiliale No errors.
App\Entity\AgenceMailDomain No errors.