GET https://ezmynt.com/api/homes

Query Metrics

3 Database Queries
3 Different statements
5.56 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.70 ms
SELECT count(DISTINCT h0_.id) AS sclr_0 FROM home h0_ LEFT JOIN blockchain b1_ ON h0_.id = b1_.home_id LEFT JOIN image i2_ ON b1_.image_id = i2_.id LEFT JOIN faq f3_ ON h0_.id = f3_.home_id LEFT JOIN how_it_work h4_ ON h0_.id = h4_.home_id
Parameters:
[]
2 0.91 ms
SELECT DISTINCT h0_.id AS id_0, h0_.id AS id_1 FROM home h0_ LEFT JOIN blockchain b1_ ON h0_.id = b1_.home_id LEFT JOIN image i2_ ON b1_.image_id = i2_.id LEFT JOIN faq f3_ ON h0_.id = f3_.home_id LEFT JOIN how_it_work h4_ ON h0_.id = h4_.home_id ORDER BY h0_.id ASC LIMIT 30
Parameters:
[]
3 0.95 ms
SELECT h0_.id AS id_0, h0_.hero_title AS hero_title_1, h0_.hero_subtitle AS hero_subtitle_2, h0_.hero_text AS hero_text_3, h0_.link_text AS link_text_4, h0_.blockchain_title AS blockchain_title_5, h0_.hoe_it_works_title AS hoe_it_works_title_6, h0_.faq_title AS faq_title_7, b1_.id AS id_8, b1_.name AS name_9, b1_.content AS content_10, i2_.id AS id_11, i2_.name AS name_12, i2_.filename AS filename_13, i2_.updated_at AS updated_at_14, f3_.id AS id_15, f3_.title AS title_16, f3_.content AS content_17, h4_.id AS id_18, h4_.title AS title_19, h4_.content AS content_20, b1_.image_id AS image_id_21, b1_.home_id AS home_id_22, f3_.home_id AS home_id_23, h4_.home_id AS home_id_24 FROM home h0_ LEFT JOIN blockchain b1_ ON h0_.id = b1_.home_id LEFT JOIN image i2_ ON b1_.image_id = i2_.id LEFT JOIN faq f3_ ON h0_.id = f3_.home_id LEFT JOIN how_it_work h4_ ON h0_.id = h4_.home_id WHERE h0_.id IN (?) ORDER BY h0_.id ASC
Parameters:
[
  1
]

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\Home No errors.
App\Entity\Blockchain No errors.
App\Entity\Image No errors.
App\Entity\Faq No errors.
App\Entity\HowItWork No errors.