GET https://interviewbuddy.portfolio.kumardeepak.com/

Query Metrics

12 Database Queries
10 Different statements
2.57 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 0.62 ms
SELECT t0._id AS _id_1, t0.cost_inr AS cost_inr_2, t0.cost_usd AS cost_usd_3 FROM async_price t0 LIMIT 1
Parameters:
[]
2 0.22 ms
SELECT t0._id AS _id_1, t0.title AS title_2, t0.link AS link_3, t0.active AS active_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6 FROM offer t0 LIMIT 1
Parameters:
[]
3 0.21 ms
SELECT t0._id AS _id_1, t0.title AS title_2, t0.subhead AS subhead_3, t0.points AS points_4, t0.placement AS placement_5, t0.createdOn AS createdOn_6, t0.updatedOn AS updatedOn_7 FROM banner t0 WHERE t0.placement = ? LIMIT 1
Parameters:
[
  "home"
]
4 0.21 ms
SELECT t0._id AS _id_1, t0.name AS name_2, t0.type AS type_3, t0.country AS country_4, t0.date AS date_5, t0.feedback AS feedback_6, t0.dp AS dp_7, t0.placement AS placement_8, t0.ratings AS ratings_9, t0.createdOn AS createdOn_10, t0.updatedOn AS updatedOn_11 FROM testimonial t0 WHERE t0.placement = ? ORDER BY t0.createdOn DESC
Parameters:
[
  "home"
]
5 0.15 ms
SELECT t0._id AS _id_1, t0.quote AS quote_2, t0.domain_title AS domain_title_3, t0.domain_description AS domain_description_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6 FROM other t0 LIMIT 1
Parameters:
[]
6 0.15 ms
SELECT t0._id AS _id_1, t0.image AS image_2, t0.title AS title_3, t0.createdOn AS createdOn_4, t0.updatedOn AS updatedOn_5 FROM domain t0 ORDER BY t0.createdOn DESC
Parameters:
[]
7 0.19 ms
SELECT t0._id AS _id_1, t0.image AS image_2, t0.page AS page_3, t0.placement AS placement_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6 FROM brand t0 WHERE t0.page = ? AND t0.placement = ? ORDER BY t0.createdOn DESC
Parameters:
[
  "home"
  "universities"
]
8 0.17 ms
SELECT t0._id AS _id_1, t0.image AS image_2, t0.page AS page_3, t0.placement AS placement_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6 FROM brand t0 WHERE t0.page = ? AND t0.placement = ? ORDER BY t0.createdOn DESC
Parameters:
[
  "home"
  "companies"
]
9 0.12 ms
SELECT t0._id AS _id_1, t0.image AS image_2, t0.page AS page_3, t0.placement AS placement_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6 FROM brand t0 WHERE t0.page = ? AND t0.placement = ? ORDER BY t0.createdOn DESC
Parameters:
[
  "home"
  "press"
]
10 0.17 ms
SELECT t0._id AS _id_1, t0.experience AS experience_2, t0.duration AS duration_3, t0.cost_inr AS cost_inr_4, t0.cost_usd AS cost_usd_5 FROM price t0 WHERE t0.duration = ?
Parameters:
[
  30
]
11 0.16 ms
SELECT t0._id AS _id_1, t0.name AS name_2, t0.dp AS dp_3, t0.bio AS bio_4, t0.placement AS placement_5, t0.createdOn AS createdOn_6, t0.updatedOn AS updatedOn_7 FROM expert t0 WHERE t0.placement = ? ORDER BY t0.createdOn DESC
Parameters:
[
  "home"
]
12 0.20 ms
SELECT t0._id AS _id_1, t0.title AS title_2, t0.description AS description_3, t0.active AS active_4, t0.createdOn AS createdOn_5, t0.updatedOn AS updatedOn_6, t0.coupon_id AS coupon_id_7 FROM subscribe_popup t0 WHERE t0.active = ? LIMIT 1
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\Price 4
App\Entity\AsyncPrice 1
App\Entity\Offer 1
App\Entity\Banner 1
App\Entity\Testimonial 1
App\Entity\Other 1

Entities Mapping

Class Mapping errors
App\Entity\AsyncPrice No errors.
App\Entity\Offer No errors.
App\Entity\Banner No errors.
App\Entity\Testimonial No errors.
App\Entity\Other No errors.
App\Entity\Domain No errors.
App\Entity\Brand No errors.
App\Entity\Price No errors.
App\Entity\Expert No errors.
App\Entity\SubscribePopup No errors.
App\Entity\Coupon No errors.