Query Metrics

11 Database Queries
11 Different statements
9.57 ms Query time
0 Invalid entities
15 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.20 ms
SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.name AS name_2, a0_.description AS description_3, a0_.slug AS slug_4, a1_.id AS id_5, s2_.id AS id_6, s2_.image AS image_7, s3_.id AS id_8, s3_.locale AS locale_9, s3_.name AS name_10, s3_.slug AS slug_11, a0_.activity_id AS activity_id_12, a1_.service_id AS service_id_13, s3_.service_id AS service_id_14 FROM activity_translation a0_ INNER JOIN activity a1_ ON a0_.activity_id = a1_.id INNER JOIN service s2_ ON a1_.service_id = s2_.id INNER JOIN service_translation s3_ ON s2_.id = s3_.service_id WHERE a0_.slug = ? AND a0_.locale = ? AND s3_.slug = ? AND s3_.locale = ?
Parameters:
[
  "تغطية-الأرضيات"
  "ar"
  "طلاء"
  "ar"
]
2 0.98 ms
SELECT a0_.id AS id_0, a0_.service_id AS service_id_1 FROM activity a0_ INNER JOIN activity_translation a1_ ON a0_.id = a1_.activity_id WHERE a1_.slug = ? AND a1_.locale = ?
Parameters:
[
  "تغطية-الأرضيات"
  "ar"
]
3 0.98 ms
SELECT s0_.id AS id_0, s0_.image AS image_1, s1_.id AS id_2, s1_.locale AS locale_3, s1_.name AS name_4, s1_.slug AS slug_5, s2_.id AS id_6, s2_.locale AS locale_7, s2_.name AS name_8, s2_.slug AS slug_9, s1_.service_id AS service_id_10, s2_.service_id AS service_id_11 FROM service s0_ INNER JOIN service_translation s1_ ON s0_.id = s1_.service_id LEFT JOIN service_translation s2_ ON s0_.id = s2_.service_id WHERE s1_.slug = ? AND s1_.locale = ?
Parameters:
[
  "طلاء"
  "ar"
]
4 0.86 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.slug AS slug_5, t0.activity_id AS activity_id_6 FROM activity_translation t0 WHERE t0.activity_id = ?
Parameters:
[
  1
]
5 0.63 ms
SELECT t0.id AS id_1, t0.image AS image_2 FROM service t0
Parameters:
[]
6 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.facebook AS facebook_4, t0.twitter AS twitter_5, t0.instagram AS instagram_6, t0.youtube AS youtube_7, t0.telephone AS telephone_8, t0.addr_fr AS addr_fr_9, t0.addr_en AS addr_en_10, t0.addr_ar AS addr_ar_11, t0.whatsapp AS whatsapp_12, t0.maps AS maps_13, t0.linkedin AS linkedin_14, t0.tiktok AS tiktok_15, t0.website AS website_16, t0.tax_number AS tax_number_17 FROM company_info t0 LIMIT 1
Parameters:
[]
7 0.98 ms
SELECT COUNT(a0_.id) AS sclr_0, s1_.id AS id_1, s1_.image AS image_2, s2_.id AS id_3, s2_.locale AS locale_4, s2_.name AS name_5, s2_.slug AS slug_6, s2_.service_id AS service_id_7 FROM service s1_ INNER JOIN service_translation s2_ ON s1_.id = s2_.service_id LEFT JOIN activity a0_ ON s1_.id = a0_.service_id WHERE s2_.locale = ? GROUP BY s1_.id, s2_.id ORDER BY s1_.id ASC
Parameters:
[
  "ar"
]
8 0.83 ms
SELECT a0_.id AS id_0, a1_.id AS id_1, a1_.locale AS locale_2, a1_.name AS name_3, a1_.description AS description_4, a1_.slug AS slug_5, a0_.service_id AS service_id_6, a1_.activity_id AS activity_id_7 FROM activity a0_ INNER JOIN service s2_ ON a0_.service_id = s2_.id INNER JOIN activity_translation a1_ ON a0_.id = a1_.activity_id WHERE a0_.service_id = ? AND a0_.id <> ? AND a1_.locale = ?
Parameters:
[
  1
  1
  "ar"
]
9 0.90 ms
SELECT s0_.id AS id_0, s0_.image AS image_1, c1_.id AS id_2, c1_.image AS image_3, c2_.id AS id_4, c2_.locale AS locale_5, c2_.name AS name_6, c2_.slug AS slug_7, c2_.description AS description_8, c2_.category_id AS category_id_9 FROM section s0_ LEFT JOIN section_category s3_ ON s0_.id = s3_.section_id LEFT JOIN category c1_ ON c1_.id = s3_.category_id LEFT JOIN category_translation c2_ ON c1_.id = c2_.category_id AND (c2_.locale = ?)
Parameters:
[
  "ar"
]
10 0.84 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.activity_id AS activity_id_3 FROM activity_image t0 WHERE t0.activity_id = ?
Parameters:
[
  1
]
11 0.66 ms
SELECT t0.id AS id_1, t0.service_id AS service_id_2 FROM activity t0 WHERE t0.service_id = ?
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\ActivityImage 6
App\Entity\ServiceTranslation 3
App\Entity\ActivityTranslation 3
App\Entity\Activity 1
App\Entity\Service 1
App\Entity\CompanyInfo 1

Entities Mapping