GET https://preprod.abeillesolidaire.club/projects/titre-accrocheur-1

Query Metrics

6 Database Queries
6 Different statements
10.16 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 2.58 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.goal AS goal_4, t0.pledged AS pledged_5, t0.image AS image_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.completed_at AS completed_at_9, t0.slug AS slug_10, t0.is_active AS is_active_11, t0.status AS status_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.category_id AS category_id_15, t0.creator_id AS creator_id_16, t0.owner_id AS owner_id_17 FROM project t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "titre-accrocheur-1"
]
2 1.53 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.goal AS goal_4, t0.pledged AS pledged_5, t0.image AS image_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.completed_at AS completed_at_9, t0.slug AS slug_10, t0.is_active AS is_active_11, t0.status AS status_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.category_id AS category_id_15, t0.creator_id AS creator_id_16, t0.owner_id AS owner_id_17 FROM project t0 WHERE t0.category_id = ? ORDER BY t0.created_at DESC LIMIT 3
Parameters:
[
  158
]
3 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.project_count AS project_count_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM project_category t0 WHERE t0.id = ?
Parameters:
[
  158
]
4 1.23 ms
SELECT t0.id AS id_1, t0.comment AS comment_2, t0.rating AS rating_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.project_id AS project_id_6, t0.author_id AS author_id_7 FROM project_review t0 WHERE t0.project_id = ?
Parameters:
[
  8
]
5 2.66 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6, t0.avatar AS avatar_7, t0.username AS username_8, t0.phone AS phone_9, t0.country AS country_10, t0.account_type AS account_type_11, t0.organization_name AS organization_name_12, t0.organization_number AS organization_number_13, t0.waiting_since AS waiting_since_14, t0.is_kyc_verified AS is_kyc_verified_15, t0.kyc_verified_at AS kyc_verified_at_16, t0.stripe_customer_id AS stripe_customer_id_17, t0.default_payment_method_id AS default_payment_method_id_18, t0.is_active AS is_active_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t22.id AS id_23, t22.title AS title_24, t22.description AS description_25, t22.goal AS goal_26, t22.pledged AS pledged_27, t22.image AS image_28, t22.start_date AS start_date_29, t22.end_date AS end_date_30, t22.completed_at AS completed_at_31, t22.slug AS slug_32, t22.is_active AS is_active_33, t22.status AS status_34, t22.created_at AS created_at_35, t22.updated_at AS updated_at_36, t22.category_id AS category_id_37, t22.creator_id AS creator_id_38, t22.owner_id AS owner_id_39 FROM "user" t0 LEFT JOIN project t22 ON t22.creator_id = t0.id WHERE t0.id = ?
Parameters:
[
  517
]
6 1.55 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.image_name AS image_name_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.project_id AS project_id_7 FROM project_update t0 WHERE t0.project_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  8
]

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\Membership No errors.
App\Entity\User No errors.
App\Entity\Flower
  • The field 'App\Entity\Flower#donationAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\PaymentMethod No errors.
App\Entity\EventDetails No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\Earning No errors.
App\Entity\Event No errors.
App\Entity\KycVerification No errors.
App\Entity\NewsCategory No errors.
App\Entity\ProjectCategory No errors.
App\Entity\Service No errors.
App\Entity\EventCategory No errors.
App\Entity\Comment No errors.
App\Entity\FAQ No errors.
App\Entity\Cause
  • The field 'App\Entity\Cause#pledged' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\EventContent No errors.
App\Entity\NewsArticle No errors.
App\Entity\ProjectFAQ No errors.
App\Entity\Donation
  • The field 'App\Entity\Donation#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ProjectReview No errors.
App\Entity\Testimonial No errors.
App\Entity\Withdrawal
  • The field 'App\Entity\Withdrawal#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Withdrawal#feeAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Withdrawal#cryptoAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\MainSlider No errors.
App\Entity\SystemConfiguration No errors.
App\Entity\ProjectUpdate No errors.
App\Entity\PonctualDonation No errors.
App\Entity\Project
  • The field 'App\Entity\Project#goal' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Project#pledged' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
Vich\UploaderBundle\Entity\File No errors.