https://smaapi.app.ku.edu/api/v4/webtour

Query Metrics

39 Database Queries
5 Different statements
55.49 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.38 ms
SELECT w0_.tourID AS tourID_0, w0_.title AS title_1, w0_.description AS description_2, w0_.formattedDescription AS formattedDescription_3, w0_.formattedDescriptionUpdated AS formattedDescriptionUpdated_4, w0_.id AS id_5, w0_.priority AS priority_6, w0_.createdAt AS createdAt_7, w0_.updatedAt AS updatedAt_8 FROM WebTour w0_
Parameters:
[]
2 8.88 ms
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.tour AS tour_5, t0.artObject AS artObject_6 FROM WebTourLink t0 WHERE t0.tour = ?
Parameters:
[
  1
]
3 6.76 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  378
]
4 6.88 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  378
]
5 1.13 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  609
]
6 0.78 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  609
]
7 2.55 ms
SELECT t0.id AS id_1, t0.linkId AS linkId_2, t0.name AS name_3, t0.path AS path_4, t0.ext AS ext_5, t0.typeDesc AS typeDesc_6, t0.description AS description_7, t0.objectID AS objectID_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.exhibition_id AS exhibition_id_11 FROM WebTourMedia t0 WHERE t0.exhibition_id = ? ORDER BY t0.name ASC, t0.id DESC
Parameters:
[
  1
]
8 0.39 ms
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.tour AS tour_5, t0.artObject AS artObject_6 FROM WebTourLink t0 WHERE t0.tour = ?
Parameters:
[
  2
]
9 0.86 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  115
]
10 6.16 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  115
]
11 2.42 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  235
]
12 1.43 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  235
]
13 1.52 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  10
]
14 1.61 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  10
]
15 0.69 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  292
]
16 0.25 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  292
]
17 0.23 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  386
]
18 0.25 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  386
]
19 0.66 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  439
]
20 0.26 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  439
]
21 0.80 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  333
]
22 0.30 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  333
]
23 0.40 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  364
]
24 0.37 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  364
]
25 0.38 ms
SELECT t0.id AS id_1, t0.linkId AS linkId_2, t0.name AS name_3, t0.path AS path_4, t0.ext AS ext_5, t0.typeDesc AS typeDesc_6, t0.description AS description_7, t0.objectID AS objectID_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.exhibition_id AS exhibition_id_11 FROM WebTourMedia t0 WHERE t0.exhibition_id = ? ORDER BY t0.name ASC, t0.id DESC
Parameters:
[
  2
]
26 0.20 ms
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.tour AS tour_5, t0.artObject AS artObject_6 FROM WebTourLink t0 WHERE t0.tour = ?
Parameters:
[
  3
]
27 0.98 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  415
]
28 0.28 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  415
]
29 0.29 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  441
]
30 1.01 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  441
]
31 0.23 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  585
]
32 0.22 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  585
]
33 0.16 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  586
]
34 0.24 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  586
]
35 0.23 ms
SELECT t0.id AS id_1, t0.linkId AS linkId_2, t0.name AS name_3, t0.path AS path_4, t0.ext AS ext_5, t0.typeDesc AS typeDesc_6, t0.description AS description_7, t0.objectID AS objectID_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.exhibition_id AS exhibition_id_11 FROM WebTourMedia t0 WHERE t0.exhibition_id = ? ORDER BY t0.name ASC, t0.id DESC
Parameters:
[
  3
]
36 0.15 ms
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.createdAt AS createdAt_3, t0.updatedAt AS updatedAt_4, t0.tour AS tour_5, t0.artObject AS artObject_6 FROM WebTourLink t0 WHERE t0.tour = ?
Parameters:
[
  4
]
37 0.58 ms
SELECT t0.id AS id_1, t0.objectId AS objectId_2, t0.title AS title_3, t0.accessionNumber AS accessionNumber_4, t0.geoAssoc AS geoAssoc_5, t0.currLoc AS currLoc_6, t0.objectDate AS objectDate_7, t0.material AS material_8, t0.creditLine AS creditLine_9, t0.description AS description_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12 FROM ArtObject t0 WHERE t0.id = ?
Parameters:
[
  42
]
38 0.30 ms
SELECT t0.id AS id_1, t0.collectionType AS collectionType_2, t0.description AS description_3, t0.formattedDescription AS formattedDescription_4, t0.formattedDescriptionUpdated AS formattedDescriptionUpdated_5, t0.descriptionId AS descriptionId_6, t0.collectionId AS collectionId_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.artObject_id AS artObject_id_10 FROM ArtObjectDescription t0 WHERE t0.artObject_id = ?
Parameters:
[
  42
]
39 0.29 ms
SELECT t0.id AS id_1, t0.linkId AS linkId_2, t0.name AS name_3, t0.path AS path_4, t0.ext AS ext_5, t0.typeDesc AS typeDesc_6, t0.description AS description_7, t0.objectID AS objectID_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.exhibition_id AS exhibition_id_11 FROM WebTourMedia t0 WHERE t0.exhibition_id = ? ORDER BY t0.name ASC, t0.id DESC
Parameters:
[
  4
]

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\AppSetting No errors.
App\Entity\WebTour No errors.
App\Entity\WebTourLink No errors.
App\Entity\BaseMedia No errors.
App\Entity\WebTourMedia No errors.
App\Entity\ArtObject No errors.
App\Entity\Artist No errors.
App\Entity\ArtObjectDescription No errors.
App\Entity\ArtObjectDimension No errors.
App\Entity\ArtObjectLink No errors.
App\Entity\ArtObjectMedia No errors.
App\Entity\ExhibitionLink No errors.
App\Entity\TourLink No errors.
App\Entity\AssignmentLink No errors.