Query Metrics
3
Database Queries
3
Different statements
68.07 ms
Query time
1
Invalid entities
1010
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.41 ms |
SELECT t0.process_class AS process_class_1, t0.actor_id AS actor_id_2, t0.id AS id_3, t0.started_at AS started_at_4, t0.finished_at AS finished_at_5, t0.result AS result_6, t0.reason AS reason_7 FROM extracted.process_logs t0 WHERE t0.id = ?
Parameters:
[
"1f0b882b-7666-6d60-bae9-f1ee1c3e4c5e"
]
|
||||||||||||||||||||||
| 2 | 1.01 ms |
SELECT t0.transport_class AS transport_class_1, t0.extractor_class AS extractor_class_2, t0.actor_id AS actor_id_3, t0.id AS id_4, t0.started_at AS started_at_5, t0.finished_at AS finished_at_6, t0.result AS result_7, t0.reason AS reason_8, t0.process_id AS process_id_9 FROM extracted.extractor_logs t0 WHERE t0.process_id = ? LIMIT 1
Parameters:
[
"1f0b882b-7666-6d60-bae9-f1ee1c3e4c5e"
]
|
||||||||||||||||||||||
| 3 | 65.66 ms |
SELECT t0.name AS name_1, t0.product_size AS product_size_2, t0.measurement_unit_coeff AS measurement_unit_coeff_3, t0.pack_size AS pack_size_4, t0.product_weight AS product_weight_5, t0.product_features AS product_features_6, t0.source_data AS source_data_7, t0.is_ready_to_load AS is_ready_to_load_8, t0.id AS id_9, t0.source_id AS source_id_10, t0.product_id AS product_id_11, t0.main_measurement_id AS main_measurement_id_12, t0.additional_measurement_id AS additional_measurement_id_13, t0.extraction_attempt_id AS extraction_attempt_id_14 FROM extracted.offers t0 WHERE t0.extraction_attempt_id = ?
Parameters:
[
"1f0b882b-770e-61c8-aac2-f1ee1c3e4c5e"
]
|
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\Offer\Entity\ExtractedOffer | 1000 |
| App\Offer\Entity\Product | 7 |
| App\Infrastructure\Entity\ProcessLogEntry | 1 |
| App\Infrastructure\Entity\ExtractorLogEntry | 1 |
| App\Measurement\Entity\MeasurementUnit | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Infrastructure\Entity\ProcessLogEntry | No errors. |
| App\Infrastructure\Entity\ExtractorLogEntry | No errors. |
| App\Offer\Entity\ExtractedOffer | No errors. |
| App\Offer\Entity\Product | No errors. |
| App\Measurement\Entity\MeasurementUnit |
|