http://pricedemo.romapps.com/

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1.71 ms
(0.00%)
1
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"
]
1.25 ms
(0.00%)
1
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"
]
1.10 ms
(0.00%)
1
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-15 05:22:52"
]
1.10 ms
(0.00%)
1
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-15 05:22:52"
]
0.99 ms
(0.00%)
1
SELECT MAX(p0_.id) AS sclr_0 FROM price_scraped p0_
Parameters:
[]
0.56 ms
(0.00%)
1
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-15 05:22:52"
]

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.