GET https://app.vizualeez.com/cron/sendPlanificationInProposal

Query Metrics

1 Database Queries
1 Different statements
17.23 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 17.23 ms
SELECT p0_.id AS id_0, p0_.social_media_platform AS social_media_platform_1, p0_.recommandation_posting_time AS recommandation_posting_time_2, p0_.content_recommendation AS content_recommendation_3, p0_.scheduled_post_date AS scheduled_post_date_4, p0_.status AS status_5, p0_.context AS context_6, p0_.validated_at AS validated_at_7, p0_.created_at AS created_at_8, p0_.status_context AS status_context_9, p1_.id AS id_10, p1_.status AS status_11, p1_.created_at AS created_at_12, p1_.created_by AS created_by_13, p1_.proposal_feedback AS proposal_feedback_14, p1_.refused_at AS refused_at_15, p1_.modify_at AS modify_at_16, p1_.details_creation_visual AS details_creation_visual_17, p1_.prompt_midjourney_inspiration AS prompt_midjourney_inspiration_18, p1_.font_inspiration AS font_inspiration_19, p1_.key_elements AS key_elements_20, p1_.color_inspiration AS color_inspiration_21, p1_.font_size_inspiration AS font_size_inspiration_22, p1_.graphical_elements AS graphical_elements_23, p1_.central_element AS central_element_24, p1_.central_text AS central_text_25, p1_.media_midjourney AS media_midjourney_26, p0_.establishment_id AS establishment_id_27, p1_.planification_id AS planification_id_28 FROM planification p0_ LEFT JOIN publication p1_ ON p0_.id = p1_.planification_id WHERE p0_.status = ? AND p0_.scheduled_post_date <= ? AND p0_.scheduled_post_date > CURRENT_TIMESTAMP ORDER BY p1_.id ASC
Parameters:
[
  "proposal"
  "2025-07-22 09:30:09"
]

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\Planification
  • The mappings App\Entity\Planification#publications and App\Entity\Publication#planification are inconsistent with each other.
App\Entity\Publication
  • The association App\Entity\Publication#planification refers to the inverse side field App\Entity\Planification#Publication which does not exist.
App\Entity\Establishment
  • The association App\Entity\Establishment#massMessages refers to the owning side field App\Entity\MassMessage#establishment which does not exist.
  • The association App\Entity\Establishment#benchmarks refers to the owning side field App\Entity\Benchmark#establishment which does not exist.
  • The association App\Entity\Establishment#reviews refers to the owning side field App\Entity\Review#establishments which does not exist.
  • The association App\Entity\Establishment#privateMessages refers to the owning side field App\Entity\PrivateMessage#establishment which does not exist.