GET https://stiexpressbd.com/blog/1/how-do-i-enquire-about-a-our-delivery

Query Metrics

6 Database Queries
6 Different statements
18.75 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 4.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.mobile_no AS mobile_no_4, t0.email AS email_5, t0.fsc AS fsc_6, t0.weight_perkg AS weight_perkg_7, t0.covid_charge_applicable AS covid_charge_applicable_8, t0.weight_perkg_rate AS weight_perkg_rate_9, t0.first_url AS first_url_10, t0.last_url AS last_url_11, t0.logo AS logo_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.rate_type AS rate_type_15, t0.expedite AS expedite_16, t0.sro AS sro_17, t0.sro_charge AS sro_charge_18, t0.created_by_id AS created_by_id_19, t0.modified_by_id AS modified_by_id_20, t0.user_company_id AS user_company_id_21, t0.account_name_id AS account_name_id_22, t0.expense_account_name_id AS expense_account_name_id_23 FROM courier t0
Parameters:
[]
2 3.69 ms
SELECT count(s0_.id) AS sclr_0 FROM shipment s0_ LEFT JOIN user u1_ ON s0_.created_by_id = u1_.id WHERE s0_.accepted = 0
Parameters:
[]
3 1.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.step AS step_3 FROM tracking_status t0
Parameters:
[]
4 2.63 ms
SELECT t0.id AS id_1, t0.publish_date AS publish_date_2, t0.title AS title_3, t0.list_image AS list_image_4, t0.created_at AS created_at_5, t0.modified_at AS modified_at_6, t0.slug AS slug_7, t0.created_by_id AS created_by_id_8, t0.modified_by_id AS modified_by_id_9 FROM blog t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
5 0.75 ms
SELECT t0.id AS id_1, t0.publish_date AS publish_date_2, t0.title AS title_3, t0.list_image AS list_image_4, t0.created_at AS created_at_5, t0.modified_at AS modified_at_6, t0.slug AS slug_7, t0.created_by_id AS created_by_id_8, t0.modified_by_id AS modified_by_id_9 FROM blog t0 ORDER BY t0.id DESC LIMIT 8
Parameters:
[]
6 6.15 ms
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.content AS content_3, t0.blog_id AS blog_id_4 FROM blog_details t0 WHERE t0.blog_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.

Entities Mapping

Class Mapping errors
App\Entity\Courier No errors.
App\Entity\User No errors.
App\Entity\UserCompany No errors.
App\Entity\AccountName No errors.
App\Entity\CourierWiseZone No errors.
App\Entity\ZoneWiseMasterRate No errors.
App\Entity\CountryWiseMasterRate No errors.
App\Entity\ZoneWiseSalesRate No errors.
App\Entity\CountryWiseSalesRate No errors.
App\Entity\ZoneWiseCovidCharge No errors.
App\Entity\CountryWiseCovidCharge No errors.
App\Entity\SalesInvoiceDetails No errors.
App\Entity\ZoneWiseCommonSalesRate No errors.
App\Entity\CountryWiseCommonSalesRate No errors.
App\Entity\Packaging No errors.
App\Entity\Shipment No errors.
App\Entity\SalesOffer
  • The association App\Entity\SalesOffer#userCompany refers to the inverse side field App\Entity\UserCompany#salesOffers which does not exist.
App\Entity\CandfShipment No errors.
App\Entity\SettingsInfo No errors.
App\Entity\TrackingStatus No errors.
App\Entity\TrackingUpdate No errors.
App\Entity\Blog No errors.
App\Entity\BlogDetails No errors.