http://pricedemo.romapps.com/

Query Metrics

6 Database Queries
6 Different statements
7.47 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.