GET http://asiatradedirectory.com/

Query Metrics

19 Database Queries
6 Different statements
9.11 ms Query time
1 Invalid entities
68 Managed entities

Queries

Group similar statements

# Time Info
1 1.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 ORDER BY t0.created_on DESC LIMIT 6
Parameters:
[]
2 1.95 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_ INNER JOIN product_photo p1_ ON p0_.id = p1_.product_id GROUP BY p0_.id ORDER BY p0_.guid DESC LIMIT 8
Parameters:
[]
3 0.95 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.keywords AS keywords_3, c0_.is_default AS is_default_4, c0_.homepage AS homepage_5, c0_.slug AS slug_6, c0_.faicon AS faicon_7, c0_.parent_id AS parent_id_8 FROM category c0_ WHERE c0_.parent_id IS NOT NULL AND c0_.homepage = 1 LIMIT 20
Parameters:
[]
4 1.22 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:
[
  37
]
5 0.26 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:
[
  4015
]
6 0.25 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:
[
  2
]
7 0.29 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
]
8 0.32 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:
[
  5003
]
9 0.28 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
]
10 0.18 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:
[
  5070
]
11 0.24 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
]
12 0.15 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:
[
  5072
]
13 0.20 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:
[
  30
]
14 0.16 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:
[
  3188
]
15 0.19 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:
[
  29
]
16 0.15 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
]
17 0.20 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
]
18 0.21 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:
[
  28
]
19 0.19 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
]

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\Category 32
App\Entity\Business 8
App\Entity\Product 8
App\Entity\ProductPhoto 8
App\Entity\User 7
App\Entity\Country 5

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\ProductPhoto No errors.
App\Entity\Category 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.