GET https://druktechproject.online/

Query Metrics

39 Database Queries
9 Different statements
7.47 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.37 ms
SELECT t0_.id AS id_0, t0_.price AS price_1, t0_.tour_overview AS tour_overview_2, t0_.tour_title AS tour_title_3, t0_.tour_title_slug AS tour_title_slug_4, t0_.tour_category_id AS tour_category_id_5 FROM tour_package t0_ LIMIT 4
Parameters:
[]
2 0.22 ms
SELECT t0.id AS id_1, t0.destination_title AS destination_title_2, t0.description AS description_3, t0.slug AS slug_4, t0.image_id AS image_id_5 FROM top_destination t0
Parameters:
[]
3 0.19 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.tour_overview AS tour_overview_3, t0.tour_title AS tour_title_4, t0.tour_title_slug AS tour_title_slug_5, t0.tour_category_id AS tour_category_id_6 FROM tour_package t0
Parameters:
[]
4 0.15 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.slug AS slug_3, t0.sub_category_id AS sub_category_id_4 FROM tour_category t0
Parameters:
[]
5 0.34 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.tour_overview AS tour_overview_3, t0.tour_title AS tour_title_4, t0.tour_title_slug AS tour_title_slug_5, t0.tour_category_id AS tour_category_id_6 FROM tour_package t0 WHERE t0.tour_category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29
  30
]
6 0.17 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.slug AS slug_3, t0.sub_category_id AS sub_category_id_4 FROM tour_category t0 WHERE t0.sub_category_id = ?
Parameters:
[
  14
]
7 0.18 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.tour_package_id = ?
Parameters:
[
  1
]
8 0.15 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.tour_package_id = ?
Parameters:
[
  9
]
9 0.14 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.tour_package_id = ?
Parameters:
[
  15
]
10 0.15 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.tour_package_id = ?
Parameters:
[
  3
]
11 0.15 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.tour_package_id = ?
Parameters:
[
  16
]
12 0.14 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.slug AS slug_3, t0.sub_category_id AS sub_category_id_4 FROM tour_category t0 WHERE t0.sub_category_id = ?
Parameters:
[
  17
]
13 0.14 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.slug AS slug_3, t0.sub_category_id AS sub_category_id_4 FROM tour_category t0 WHERE t0.sub_category_id = ?
Parameters:
[
  20
]
14 0.14 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.tour_package_id = ?
Parameters:
[
  4
]
15 0.15 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.tour_package_id = ?
Parameters:
[
  8
]
16 0.14 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.slug AS slug_3, t0.sub_category_id AS sub_category_id_4 FROM tour_category t0 WHERE t0.sub_category_id = ?
Parameters:
[
  21
]
17 0.14 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.tour_package_id = ?
Parameters:
[
  7
]
18 0.14 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.tour_package_id = ?
Parameters:
[
  10
]
19 0.14 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.slug AS slug_3, t0.sub_category_id AS sub_category_id_4 FROM tour_category t0 WHERE t0.sub_category_id = ?
Parameters:
[
  26
]
20 0.14 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.tour_package_id = ?
Parameters:
[
  11
]
21 0.13 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.tour_package_id = ?
Parameters:
[
  14
]
22 0.12 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.slug AS slug_3, t0.sub_category_id AS sub_category_id_4 FROM tour_category t0 WHERE t0.sub_category_id = ?
Parameters:
[
  28
]
23 0.13 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.slug AS slug_3, t0.sub_category_id AS sub_category_id_4 FROM tour_category t0 WHERE t0.sub_category_id = ?
Parameters:
[
  29
]
24 0.29 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.tour_package_id = ?
Parameters:
[
  12
]
25 0.22 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.slug AS slug_3, t0.sub_category_id AS sub_category_id_4 FROM tour_category t0
Parameters:
[]
26 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.itinerary_description AS itinerary_description_3, t0.tour_package_id AS tour_package_id_4 FROM itinerary t0 WHERE t0.tour_package_id = ?
Parameters:
[
  1
]
27 0.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.itinerary_description AS itinerary_description_3, t0.tour_package_id AS tour_package_id_4 FROM itinerary t0 WHERE t0.tour_package_id = ?
Parameters:
[
  3
]
28 0.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.itinerary_description AS itinerary_description_3, t0.tour_package_id AS tour_package_id_4 FROM itinerary t0 WHERE t0.tour_package_id = ?
Parameters:
[
  4
]
29 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.itinerary_description AS itinerary_description_3, t0.tour_package_id AS tour_package_id_4 FROM itinerary t0 WHERE t0.tour_package_id = ?
Parameters:
[
  7
]
30 0.14 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.id = ?
Parameters:
[
  73
]
31 0.13 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.id = ?
Parameters:
[
  74
]
32 0.13 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.id = ?
Parameters:
[
  75
]
33 0.13 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.id = ?
Parameters:
[
  76
]
34 0.13 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.id = ?
Parameters:
[
  86
]
35 0.13 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.id = ?
Parameters:
[
  85
]
36 0.12 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.id = ?
Parameters:
[
  84
]
37 0.13 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.id = ?
Parameters:
[
  83
]
38 0.13 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.id = ?
Parameters:
[
  82
]
39 0.12 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.tour_package_id AS tour_package_id_3, t0.hotels_in_bhutan_id AS hotels_in_bhutan_id_4, t0.top_destination_id AS top_destination_id_5 FROM images t0 WHERE t0.id = ?
Parameters:
[
  119
]

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\TourPackage No errors.
App\Entity\TourCategory
  • The association App\Entity\TourCategory#sub_category refers to the inverse side field App\Entity\TourCategory#tourCategories which does not exist.
  • The mappings App\Entity\TourCategory#tour_categories and App\Entity\TourCategory#sub_category are inconsistent with each other.
App\Entity\Images
  • The field App\Entity\Images#topDestination is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\TopDestination#image does not contain the required 'mappedBy="topDestination"' attribute.
  • If association App\Entity\Images#topDestination is many-to-one, then the inversed side App\Entity\TopDestination#image has to be one-to-many.
App\Entity\Itinerary No errors.
App\Entity\TopDestination No errors.
App\Entity\HotelsInBhutan No errors.