GET http://planta.doc2sail.com/plants

Query Metrics

31 Database Queries
4 Different statements
15.37 ms Query time
0 Invalid entities
21 Managed entities

Queries

Group similar statements

# Time Info
1 2.83 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.species AS species_3, t0.location AS location_4, t0.environment AS environment_5, t0.notes AS notes_6, t0.current_pot_diameter AS current_pot_diameter_7, t0.current_pot_height AS current_pot_height_8, t0.acquired_at AS acquired_at_9, t0.last_repotting_at AS last_repotting_at_10, t0.next_repotting_at AS next_repotting_at_11, t0.is_archived AS is_archived_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM plant t0 WHERE t0.is_archived = ? ORDER BY t0.updated_at DESC
Parameters:
[
  0
]
2 1.22 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.original_filename AS original_filename_3, t0.caption AS caption_4, t0.taken_at AS taken_at_5, t0.is_cover AS is_cover_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM plant_photo t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  2
]
3 0.44 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.original_filename AS original_filename_3, t0.caption AS caption_4, t0.taken_at AS taken_at_5, t0.is_cover AS is_cover_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM plant_photo t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  3
]
4 0.35 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.original_filename AS original_filename_3, t0.caption AS caption_4, t0.taken_at AS taken_at_5, t0.is_cover AS is_cover_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM plant_photo t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  4
]
5 0.32 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.original_filename AS original_filename_3, t0.caption AS caption_4, t0.taken_at AS taken_at_5, t0.is_cover AS is_cover_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM plant_photo t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  5
]
6 0.33 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.original_filename AS original_filename_3, t0.caption AS caption_4, t0.taken_at AS taken_at_5, t0.is_cover AS is_cover_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM plant_photo t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  6
]
7 0.33 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.original_filename AS original_filename_3, t0.caption AS caption_4, t0.taken_at AS taken_at_5, t0.is_cover AS is_cover_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM plant_photo t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  1
]
8 0.31 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.original_filename AS original_filename_3, t0.caption AS caption_4, t0.taken_at AS taken_at_5, t0.is_cover AS is_cover_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM plant_photo t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  8
]
9 0.30 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.original_filename AS original_filename_3, t0.caption AS caption_4, t0.taken_at AS taken_at_5, t0.is_cover AS is_cover_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM plant_photo t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  9
]
10 0.30 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.original_filename AS original_filename_3, t0.caption AS caption_4, t0.taken_at AS taken_at_5, t0.is_cover AS is_cover_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM plant_photo t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  10
]
11 0.30 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.original_filename AS original_filename_3, t0.caption AS caption_4, t0.taken_at AS taken_at_5, t0.is_cover AS is_cover_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM plant_photo t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  7
]
12 1.28 ms
SELECT t0.id AS id_1, t0.repotted_at AS repotted_at_2, t0.previous_pot_diameter AS previous_pot_diameter_3, t0.previous_pot_height AS previous_pot_height_4, t0.new_pot_diameter AS new_pot_diameter_5, t0.new_pot_height AS new_pot_height_6, t0.substrate AS substrate_7, t0.notes AS notes_8, t0.created_at AS created_at_9, t0.plant_id AS plant_id_10 FROM repotting t0 WHERE t0.plant_id = ? ORDER BY t0.repotted_at DESC
Parameters:
[
  2
]
13 0.43 ms
SELECT t0.id AS id_1, t0.repotted_at AS repotted_at_2, t0.previous_pot_diameter AS previous_pot_diameter_3, t0.previous_pot_height AS previous_pot_height_4, t0.new_pot_diameter AS new_pot_diameter_5, t0.new_pot_height AS new_pot_height_6, t0.substrate AS substrate_7, t0.notes AS notes_8, t0.created_at AS created_at_9, t0.plant_id AS plant_id_10 FROM repotting t0 WHERE t0.plant_id = ? ORDER BY t0.repotted_at DESC
Parameters:
[
  3
]
14 0.37 ms
SELECT t0.id AS id_1, t0.repotted_at AS repotted_at_2, t0.previous_pot_diameter AS previous_pot_diameter_3, t0.previous_pot_height AS previous_pot_height_4, t0.new_pot_diameter AS new_pot_diameter_5, t0.new_pot_height AS new_pot_height_6, t0.substrate AS substrate_7, t0.notes AS notes_8, t0.created_at AS created_at_9, t0.plant_id AS plant_id_10 FROM repotting t0 WHERE t0.plant_id = ? ORDER BY t0.repotted_at DESC
Parameters:
[
  4
]
15 0.35 ms
SELECT t0.id AS id_1, t0.repotted_at AS repotted_at_2, t0.previous_pot_diameter AS previous_pot_diameter_3, t0.previous_pot_height AS previous_pot_height_4, t0.new_pot_diameter AS new_pot_diameter_5, t0.new_pot_height AS new_pot_height_6, t0.substrate AS substrate_7, t0.notes AS notes_8, t0.created_at AS created_at_9, t0.plant_id AS plant_id_10 FROM repotting t0 WHERE t0.plant_id = ? ORDER BY t0.repotted_at DESC
Parameters:
[
  5
]
16 0.34 ms
SELECT t0.id AS id_1, t0.repotted_at AS repotted_at_2, t0.previous_pot_diameter AS previous_pot_diameter_3, t0.previous_pot_height AS previous_pot_height_4, t0.new_pot_diameter AS new_pot_diameter_5, t0.new_pot_height AS new_pot_height_6, t0.substrate AS substrate_7, t0.notes AS notes_8, t0.created_at AS created_at_9, t0.plant_id AS plant_id_10 FROM repotting t0 WHERE t0.plant_id = ? ORDER BY t0.repotted_at DESC
Parameters:
[
  6
]
17 0.33 ms
SELECT t0.id AS id_1, t0.repotted_at AS repotted_at_2, t0.previous_pot_diameter AS previous_pot_diameter_3, t0.previous_pot_height AS previous_pot_height_4, t0.new_pot_diameter AS new_pot_diameter_5, t0.new_pot_height AS new_pot_height_6, t0.substrate AS substrate_7, t0.notes AS notes_8, t0.created_at AS created_at_9, t0.plant_id AS plant_id_10 FROM repotting t0 WHERE t0.plant_id = ? ORDER BY t0.repotted_at DESC
Parameters:
[
  1
]
18 0.33 ms
SELECT t0.id AS id_1, t0.repotted_at AS repotted_at_2, t0.previous_pot_diameter AS previous_pot_diameter_3, t0.previous_pot_height AS previous_pot_height_4, t0.new_pot_diameter AS new_pot_diameter_5, t0.new_pot_height AS new_pot_height_6, t0.substrate AS substrate_7, t0.notes AS notes_8, t0.created_at AS created_at_9, t0.plant_id AS plant_id_10 FROM repotting t0 WHERE t0.plant_id = ? ORDER BY t0.repotted_at DESC
Parameters:
[
  8
]
19 0.34 ms
SELECT t0.id AS id_1, t0.repotted_at AS repotted_at_2, t0.previous_pot_diameter AS previous_pot_diameter_3, t0.previous_pot_height AS previous_pot_height_4, t0.new_pot_diameter AS new_pot_diameter_5, t0.new_pot_height AS new_pot_height_6, t0.substrate AS substrate_7, t0.notes AS notes_8, t0.created_at AS created_at_9, t0.plant_id AS plant_id_10 FROM repotting t0 WHERE t0.plant_id = ? ORDER BY t0.repotted_at DESC
Parameters:
[
  9
]
20 0.33 ms
SELECT t0.id AS id_1, t0.repotted_at AS repotted_at_2, t0.previous_pot_diameter AS previous_pot_diameter_3, t0.previous_pot_height AS previous_pot_height_4, t0.new_pot_diameter AS new_pot_diameter_5, t0.new_pot_height AS new_pot_height_6, t0.substrate AS substrate_7, t0.notes AS notes_8, t0.created_at AS created_at_9, t0.plant_id AS plant_id_10 FROM repotting t0 WHERE t0.plant_id = ? ORDER BY t0.repotted_at DESC
Parameters:
[
  10
]
21 0.37 ms
SELECT t0.id AS id_1, t0.repotted_at AS repotted_at_2, t0.previous_pot_diameter AS previous_pot_diameter_3, t0.previous_pot_height AS previous_pot_height_4, t0.new_pot_diameter AS new_pot_diameter_5, t0.new_pot_height AS new_pot_height_6, t0.substrate AS substrate_7, t0.notes AS notes_8, t0.created_at AS created_at_9, t0.plant_id AS plant_id_10 FROM repotting t0 WHERE t0.plant_id = ? ORDER BY t0.repotted_at DESC
Parameters:
[
  7
]
22 0.83 ms
SELECT t0.id AS id_1, t0.photo_path AS photo_path_2, t0.original_filename AS original_filename_3, t0.diameter AS diameter_4, t0.height AS height_5, t0.notes AS notes_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM cache_pot t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  2
]
23 0.33 ms
SELECT t0.id AS id_1, t0.photo_path AS photo_path_2, t0.original_filename AS original_filename_3, t0.diameter AS diameter_4, t0.height AS height_5, t0.notes AS notes_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM cache_pot t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  3
]
24 0.32 ms
SELECT t0.id AS id_1, t0.photo_path AS photo_path_2, t0.original_filename AS original_filename_3, t0.diameter AS diameter_4, t0.height AS height_5, t0.notes AS notes_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM cache_pot t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  4
]
25 0.30 ms
SELECT t0.id AS id_1, t0.photo_path AS photo_path_2, t0.original_filename AS original_filename_3, t0.diameter AS diameter_4, t0.height AS height_5, t0.notes AS notes_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM cache_pot t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  5
]
26 0.29 ms
SELECT t0.id AS id_1, t0.photo_path AS photo_path_2, t0.original_filename AS original_filename_3, t0.diameter AS diameter_4, t0.height AS height_5, t0.notes AS notes_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM cache_pot t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  6
]
27 0.29 ms
SELECT t0.id AS id_1, t0.photo_path AS photo_path_2, t0.original_filename AS original_filename_3, t0.diameter AS diameter_4, t0.height AS height_5, t0.notes AS notes_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM cache_pot t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  1
]
28 0.54 ms
SELECT t0.id AS id_1, t0.photo_path AS photo_path_2, t0.original_filename AS original_filename_3, t0.diameter AS diameter_4, t0.height AS height_5, t0.notes AS notes_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM cache_pot t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  8
]
29 0.36 ms
SELECT t0.id AS id_1, t0.photo_path AS photo_path_2, t0.original_filename AS original_filename_3, t0.diameter AS diameter_4, t0.height AS height_5, t0.notes AS notes_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM cache_pot t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  9
]
30 0.31 ms
SELECT t0.id AS id_1, t0.photo_path AS photo_path_2, t0.original_filename AS original_filename_3, t0.diameter AS diameter_4, t0.height AS height_5, t0.notes AS notes_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM cache_pot t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  10
]
31 0.30 ms
SELECT t0.id AS id_1, t0.photo_path AS photo_path_2, t0.original_filename AS original_filename_3, t0.diameter AS diameter_4, t0.height AS height_5, t0.notes AS notes_6, t0.created_at AS created_at_7, t0.plant_id AS plant_id_8 FROM cache_pot t0 WHERE t0.plant_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  7
]

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\Plant 10
App\Entity\Repotting 10
App\Entity\PlantPhoto 1

Entities Mapping

Class Mapping errors
App\Entity\Plant No errors.
App\Entity\Repotting No errors.
App\Entity\PlantPhoto No errors.
App\Entity\CachePot No errors.