Query Metrics

10 Database Queries
5 Different statements
29.81 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.48 ms
SELECT DISTINCT a0_.id AS id_0 FROM ailog a0_ LIMIT 20 OFFSET 40
Parameters:
[]
2 22.71 ms
SELECT a0_.id AS id_0, a0_.request_content AS request_content_1, a0_.response_content AS response_content_2, a0_.model AS model_3, a0_.provider AS provider_4, a0_.action AS action_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.response_output_type AS response_output_type_8, a0_.project_id AS project_id_9, a0_.lab_report_id AS lab_report_id_10, a0_.product_url_id AS product_url_id_11 FROM ailog a0_ WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  2269
  2271
  2273
  2275
  2277
  2289
  2308
  2315
  2362
  2373
  2381
  2383
  2385
  2387
  2211
  2241
  2243
  2245
  2246
  2247
]
3 0.79 ms
SELECT count(*) AS sclr_0 FROM ailog a0_
Parameters:
[]
4 1.07 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.state AS state_6, t0.source AS source_7, t0.debug_data AS debug_data_8, t0.product_type AS product_type_9, t0.product_page_data AS product_page_data_10, t0.spider_source_url_id AS spider_source_url_id_11, t0.project_id AS project_id_12 FROM product_url t0 WHERE t0.id = ?
Parameters:
[
  4919
]
5 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.prompt AS prompt_4, t0.chat_json AS chat_json_5, t0.external_lab_reports_url AS external_lab_reports_url_6, t0.product_matching_url AS product_matching_url_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.spider_source_matching_urls AS spider_source_matching_urls_10, t0.state AS state_11, t0.website_framework AS website_framework_12, t0.debug_data AS debug_data_13, t0.product_exclude_paths AS product_exclude_paths_14, t0.user_id AS user_id_15 FROM project t0 WHERE t0.id = ?
Parameters:
[
  3
]
6 0.36 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.state AS state_6, t0.source AS source_7, t0.debug_data AS debug_data_8, t0.product_type AS product_type_9, t0.product_page_data AS product_page_data_10, t0.spider_source_url_id AS spider_source_url_id_11, t0.project_id AS project_id_12 FROM product_url t0 WHERE t0.id = ?
Parameters:
[
  4654
]
7 0.93 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.state AS state_6, t0.source AS source_7, t0.debug_data AS debug_data_8, t0.product_type AS product_type_9, t0.product_page_data AS product_page_data_10, t0.spider_source_url_id AS spider_source_url_id_11, t0.project_id AS project_id_12 FROM product_url t0 WHERE t0.id = ?
Parameters:
[
  4495
]
8 1.36 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.state AS state_6, t0.source AS source_7, t0.debug_data AS debug_data_8, t0.product_type AS product_type_9, t0.product_page_data AS product_page_data_10, t0.spider_source_url_id AS spider_source_url_id_11, t0.project_id AS project_id_12 FROM product_url t0 WHERE t0.id = ?
Parameters:
[
  4200
]
9 0.84 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.state AS state_6, t0.source AS source_7, t0.debug_data AS debug_data_8, t0.product_type AS product_type_9, t0.product_page_data AS product_page_data_10, t0.spider_source_url_id AS spider_source_url_id_11, t0.project_id AS project_id_12 FROM product_url t0 WHERE t0.id = ?
Parameters:
[
  4265
]
10 0.85 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.state AS state_6, t0.source AS source_7, t0.debug_data AS debug_data_8, t0.product_type AS product_type_9, t0.product_page_data AS product_page_data_10, t0.spider_source_url_id AS spider_source_url_id_11, t0.project_id AS project_id_12 FROM product_url t0 WHERE t0.id = ?
Parameters:
[
  4284
]

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\AILog No errors.
App\Entity\Project No errors.
App\Entity\LabReport No errors.
App\Entity\ProductUrl No errors.
App\Entity\SpiderSourceUrl No errors.
App\Entity\Product No errors.
App\Entity\User No errors.
App\Entity\LabReportSource No errors.
App\Entity\ProductPage No errors.
App\Entity\LabReportFail No errors.
App\Entity\AIBatchJob No errors.