Query Metrics

5 Database Queries
5 Different statements
2.20 ms Query time
1 Invalid entities
11 Managed entities

Queries

Group similar statements

# Time Info
1 0.59 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.guid = ? LIMIT 1
Parameters:
[
  "01KQ9MQ0A2N1PZKZE7DH1NS1Q2"
]
2 0.50 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.type AS type_3, p0_.guid AS guid_4, p0_.slug AS slug_5, p0_.elastic_updated AS elastic_updated_6, p0_.keywords AS keywords_7, p0_.meta_keywords AS meta_keywords_8, p0_.meta_description AS meta_description_9, p0_.business_id AS business_id_10, p0_.user_id AS user_id_11, p0_.category_id AS category_id_12 FROM product p0_ WHERE p0_.business_id = ? AND p0_.id <> ?
Parameters:
[
  24
  27
]
3 0.45 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.id = ?
Parameters:
[
  24
]
4 0.44 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:
[
  27
]
5 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.is_default AS is_default_5, t0.homepage AS homepage_6, t0.slug AS slug_7, t0.faicon AS faicon_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.id = ?
Parameters:
[
  1246
]

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 5
App\Entity\Category 2
App\Entity\Business 1
App\Entity\User 1
App\Entity\Country 1
App\Entity\ProductPhoto 1

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\Business No errors.
App\Entity\User No errors.
App\Entity\Category No errors.
App\Entity\ViewsRecorder 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\Country No errors.
App\Entity\News No errors.