GET http://www.asiatradedirectory.com/public/b/bk-commodities

Query Metrics

7 Database Queries
4 Different statements
3.53 ms Query time
1 Invalid entities
14 Managed entities

Queries

Group similar statements

# Time Info
1 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.registration_type AS registration_type_3, t0.number_of_employee AS number_of_employee_4, t0.establishment_date AS establishment_date_5, t0.annual_turnover AS annual_turnover_6, t0.working_days AS working_days_7, t0.about AS about_8, t0.email AS email_9, t0.mobile AS mobile_10, t0.address2 AS address2_11, t0.city AS city_12, t0.state AS state_13, t0.pincode AS pincode_14, t0.website AS website_15, t0.guid AS guid_16, t0.is_website_verified AS is_website_verified_17, t0.is_email_verified AS is_email_verified_18, t0.address1 AS address1_19, t0.txt_record AS txt_record_20, t0.created_on AS created_on_21, t0.slug AS slug_22, t0.views AS views_23, t0.user_id AS user_id_24, t0.country_id AS country_id_25 FROM business t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "bk-commodities"
]
2 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.type AS type_4, t0.guid AS guid_5, t0.slug AS slug_6, t0.elastic_updated AS elastic_updated_7, t0.keywords AS keywords_8, t0.meta_keywords AS meta_keywords_9, t0.meta_description AS meta_description_10, t0.business_id AS business_id_11, t0.user_id AS user_id_12, t0.category_id AS category_id_13 FROM product t0 WHERE t0.business_id = ?
Parameters:
[
  30
]
3 0.77 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso2 AS iso2_3, t0.region AS region_4, t0.sub_region AS sub_region_5, t0.cc AS cc_6 FROM country t0 WHERE t0.id = ?
Parameters:
[
  67
]
4 0.55 ms
SELECT t0.id AS id_1, t0.guid AS guid_2, t0.image_data AS image_data_3, t0.mime_type AS mime_type_4, t0.file_size AS file_size_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.product_id AS product_id_9 FROM product_photo t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  32
]
5 0.31 ms
SELECT t0.id AS id_1, t0.guid AS guid_2, t0.image_data AS image_data_3, t0.mime_type AS mime_type_4, t0.file_size AS file_size_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.product_id AS product_id_9 FROM product_photo t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  33
]
6 0.30 ms
SELECT t0.id AS id_1, t0.guid AS guid_2, t0.image_data AS image_data_3, t0.mime_type AS mime_type_4, t0.file_size AS file_size_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.product_id AS product_id_9 FROM product_photo t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  34
]
7 0.18 ms
SELECT t0.id AS id_1, t0.guid AS guid_2, t0.image_data AS image_data_3, t0.mime_type AS mime_type_4, t0.file_size AS file_size_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.product_id AS product_id_9 FROM product_photo t0 WHERE t0.product_id = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  35
]

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\Product 4
App\Entity\Category 4
App\Entity\ProductPhoto 3
App\Entity\Business 1
App\Entity\User 1
App\Entity\Country 1

Entities Mapping

Class Mapping errors
App\Entity\Business No errors.
App\Entity\User No errors.
App\Entity\Country No errors.
App\Entity\Product No errors.
App\Entity\ViewsRecorder No errors.
App\Entity\Category No errors.
App\Entity\ProductPhoto No errors.
App\Entity\Enquiry
  • The mappings App\Entity\Enquiry#receiver and App\Entity\User#enquiries are inconsistent with each other.
App\Entity\News No errors.