GET https://preprod.abeillesolidaire.club/projects/?category=163

Query Metrics

4 Database Queries
4 Different statements
2.64 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.89 ms
(33.74%)
1
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM project p0_ WHERE p0_.category_id = ?
Parameters:
[
  "163"
]
0.63 ms
(23.99%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.goal AS goal_3, p0_.pledged AS pledged_4, p0_.image AS image_5, p0_.start_date AS start_date_6, p0_.end_date AS end_date_7, p0_.completed_at AS completed_at_8, p0_.slug AS slug_9, p0_.is_active AS is_active_10, p0_.status AS status_11, p0_.created_at AS created_at_12, p0_.updated_at AS updated_at_13, p0_.category_id AS category_id_14, p0_.creator_id AS creator_id_15, p0_.owner_id AS owner_id_16 FROM project p0_ WHERE p0_.category_id = ? AND p0_.id IN (?) ORDER BY p0_.id DESC
Parameters:
[
  "163"
  9
]
0.59 ms
(22.33%)
1
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:
[
  163
]
0.53 ms
(19.94%)
1
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM project p0_ WHERE p0_.category_id = ? ORDER BY p0_.id DESC LIMIT 9
Parameters:
[
  "163"
]

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.