Query Metrics

7 Database Queries
7 Different statements
59.91 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 13.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.latitude AS latitude_3, t0.longitude AS longitude_4, t0.date_of_consctruct AS date_of_consctruct_5, t0.style AS style_6, t0.surface AS surface_7, t0.height AS height_8, t0.is_women AS is_women_9, t0.is_english AS is_english_10, t0.imam AS imam_11, t0.side_pic AS side_pic_12, t0.name_plate_pic AS name_plate_pic_13, t0.entry_pic AS entry_pic_14, t0.main_pic AS main_pic_15, t0.num AS num_16, t0.community_name AS community_name_17, t0.is_jumah AS is_jumah_18, t0.slug AS slug_19, t0.community_id AS community_id_20, t21.id AS id_22, t21.main_pic AS main_pic_23, t21.updated_at AS updated_at_24, t21.slug AS slug_25, t21.emirate_id AS emirate_id_26 FROM masjid t0 INNER JOIN community t21 ON t0.community_id = t21.id WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "suhaila-old"
]
2 21.15 ms
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.latitude AS latitude_2, m0_.longitude AS longitude_3, m0_.date_of_consctruct AS date_of_consctruct_4, m0_.style AS style_5, m0_.surface AS surface_6, m0_.height AS height_7, m0_.is_women AS is_women_8, m0_.is_english AS is_english_9, m0_.imam AS imam_10, m0_.side_pic AS side_pic_11, m0_.name_plate_pic AS name_plate_pic_12, m0_.entry_pic AS entry_pic_13, m0_.main_pic AS main_pic_14, m0_.num AS num_15, m0_.community_name AS community_name_16, m0_.is_jumah AS is_jumah_17, m0_.slug AS slug_18, m0_.community_id AS community_id_19 FROM masjid m0_ WHERE m0_.id < ? ORDER BY m0_.id DESC LIMIT 1
Parameters:
[
  287
]
3 0.61 ms
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.latitude AS latitude_2, m0_.longitude AS longitude_3, m0_.date_of_consctruct AS date_of_consctruct_4, m0_.style AS style_5, m0_.surface AS surface_6, m0_.height AS height_7, m0_.is_women AS is_women_8, m0_.is_english AS is_english_9, m0_.imam AS imam_10, m0_.side_pic AS side_pic_11, m0_.name_plate_pic AS name_plate_pic_12, m0_.entry_pic AS entry_pic_13, m0_.main_pic AS main_pic_14, m0_.num AS num_15, m0_.community_name AS community_name_16, m0_.is_jumah AS is_jumah_17, m0_.slug AS slug_18, m0_.community_id AS community_id_19 FROM masjid m0_ WHERE m0_.id > ? ORDER BY m0_.id ASC LIMIT 1
Parameters:
[
  287
]
4 1.22 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.content AS content_3, t0.is_enabled AS is_enabled_4, t0.masjid_id AS masjid_id_5, t0.author_id AS author_id_6 FROM comment t0 WHERE t0.masjid_id = ? AND t0.is_enabled = ?
Parameters:
[
  287
  1
]
5 19.84 ms
SELECT COUNT(p0_.id) AS sclr_0, m1_.id AS id_1, m1_.name AS name_2, m1_.latitude AS latitude_3, m1_.longitude AS longitude_4, m1_.date_of_consctruct AS date_of_consctruct_5, m1_.style AS style_6, m1_.surface AS surface_7, m1_.height AS height_8, m1_.is_women AS is_women_9, m1_.is_english AS is_english_10, m1_.imam AS imam_11, m1_.side_pic AS side_pic_12, m1_.name_plate_pic AS name_plate_pic_13, m1_.entry_pic AS entry_pic_14, m1_.main_pic AS main_pic_15, m1_.num AS num_16, m1_.community_name AS community_name_17, m1_.is_jumah AS is_jumah_18, m1_.slug AS slug_19, m1_.community_id AS community_id_20 FROM masjid m1_ LEFT JOIN picture p0_ ON m1_.id = p0_.masjid_id GROUP BY m1_.id, m1_.name, m1_.latitude, m1_.longitude, m1_.date_of_consctruct, m1_.style, m1_.surface, m1_.height, m1_.is_women, m1_.is_english, m1_.imam, m1_.side_pic, m1_.name_plate_pic, m1_.entry_pic, m1_.main_pic, m1_.num, m1_.community_name, m1_.is_jumah, m1_.slug, m1_.community_id HAVING count(m1_.id) > 1 ORDER BY RAND() ASC LIMIT 2
Parameters:
[]
6 1.85 ms
SELECT t0.id AS id_1, t0.main_pic AS main_pic_2, t0.updated_at AS updated_at_3, t0.slug AS slug_4, t0.emirate_id AS emirate_id_5 FROM community t0 WHERE t0.id IN (?)
Parameters:
[
  [
    10
    1
  ]
]
7 2.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM masjid_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  287
]

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\Masjid No errors.
App\Entity\Community No errors.
App\Entity\Emirate No errors.
App\Entity\Comment No errors.
App\Entity\Picture No errors.
App\Entity\MasjidTranslation No errors.
App\Entity\CommunityTranslation No errors.
App\Entity\User No errors.