Query Metrics
6
Database Queries
6
Different statements
7.47 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.80 ms |
SELECT MAX(p0_.id) AS sclr_0 FROM price_scraped p0_
Parameters:
[] |
2 | 1.37 ms |
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.competitor_id AS competitor_id_3, t0.price AS price_4, t0.date AS date_5, t0.analyzed AS analyzed_6, t0.stock_status AS stock_status_7, t0.request_status AS request_status_8, t0.message AS message_9, t0.process AS process_10 FROM price_scraped t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"158"
]
|
3 | 0.97 ms |
SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.competitor_id AS competitor_id_2, p0_.price AS price_3, p0_.date AS date_4, p0_.analyzed AS analyzed_5, p0_.stock_status AS stock_status_6, p0_.request_status AS request_status_7, p0_.message AS message_8, p0_.process AS process_9 FROM price_scraped p0_ WHERE p0_.date >= ? AND p0_.request_status <> 200 GROUP BY p0_.sku, p0_.competitor_id
Parameters:
[
"2025-04-14 23:49:33"
]
|
4 | 1.51 ms |
SELECT c0_.sku AS sku_0, c0_.competitor_id AS competitor_id_1, c0_.product_url AS product_url_2, c0_.scrap_frequency AS scrap_frequency_3, c0_.status AS status_4 FROM competitor_product c0_ WHERE c0_.status = ? GROUP BY c0_.sku
Parameters:
[
"active"
]
|
5 | 0.67 ms |
SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.competitor_id AS competitor_id_2, p0_.price AS price_3, p0_.date AS date_4, p0_.analyzed AS analyzed_5, p0_.stock_status AS stock_status_6, p0_.request_status AS request_status_7, p0_.message AS message_8, p0_.process AS process_9 FROM price_scraped p0_ WHERE p0_.date >= ? AND p0_.request_status = 200
Parameters:
[
"2025-04-14 23:49:34"
]
|
6 | 1.15 ms |
SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.competitor_id AS competitor_id_2, p0_.price AS price_3, p0_.date AS date_4, p0_.analyzed AS analyzed_5, p0_.stock_status AS stock_status_6, p0_.request_status AS request_status_7, p0_.message AS message_8, p0_.process AS process_9 FROM price_scraped p0_ WHERE p0_.date >= ? AND p0_.request_status = 200 GROUP BY p0_.competitor_id
Parameters:
[
"2025-04-14 23:49:34"
]
|
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\PriceScraped | No errors. |
App\Entity\CompetitorProduct | No errors. |