GET http://api-dev.tripncity.com/page/privacy-policy

Query Metrics

4 Database Queries
4 Different statements
6.89 ms Query time
0 Invalid entities
182 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.84 ms
(41.29%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.flag AS flag_6, t0.status AS status_7, t0.order_number AS order_number_8, t0.iso_code AS iso_code_9, t0.media_id AS media_id_10 FROM country t0 WHERE t0.status = ? ORDER BY t0.order_number ASC
Parameters:
[
  1
]
1.45 ms
(21.01%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.status AS status_6, t0.group_name AS group_name_7 FROM place_category t0
Parameters:
[]
1.41 ms
(20.50%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.content AS content_4 FROM legal_pages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "privacy-policy"
]
1.18 ms
(17.19%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.status AS status_6, t0.description AS description_7 FROM trip_category t0
Parameters:
[]

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\PlaceCategory 166
App\Entity\TripCategory 7
App\Entity\Country 5
App\Entity\Media 3
App\Entity\LegalPages 1

Entities Mapping

Class Mapping errors
App\Entity\BaseEntity No errors.
App\Entity\Country No errors.
App\Entity\Media No errors.
App\Entity\City No errors.
App\Entity\TripCategory No errors.
App\Entity\Offer No errors.
App\Entity\Trip No errors.
App\Entity\FeedBack No errors.
App\Entity\Place No errors.
App\Entity\PlaceCategory No errors.
App\Entity\LegalPages No errors.