Query Metrics
204
Database Queries
5
Different statements
322.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
197.15 ms (61.20%) |
1 |
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM product_url p0_ ORDER BY p0_.id DESC LIMIT 200 OFFSET 7200
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
101.42 ms (31.48%) |
200 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lab_report_url AS lab_report_url_3, t0.results AS results_4, t0.product_page_url AS product_page_url_5, t0.additional_data AS additional_data_6, t0.state AS state_7, t0.expiry_date AS expiry_date_8, t0.extraction_date AS extraction_date_9, t0.thca_percentage AS thca_percentage_10, t0.total_thc_percentage AS total_thc_percentage_11, t0.delta_nine_percentage AS delta_nine_percentage_12, t0.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_13, t0.comments AS comments_14, t0.debug_data AS debug_data_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.product_page_id AS product_page_id_18, t0.project_id AS project_id_19, t0.product_url_id AS product_url_id_20 FROM product t0 WHERE t0.product_url_id = ?
Parameters:
[
4719
]
|
||||||||||||||||||||||||||||||||
|
20.93 ms (6.50%) |
1 |
SELECT p0_.id AS id_0, p0_.url AS url_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3, p0_.title AS title_4, p0_.state AS state_5, p0_.source AS source_6, p0_.debug_data AS debug_data_7, p0_.product_type AS product_type_8, p0_.product_page_data AS product_page_data_9, p0_.spider_source_url_id AS spider_source_url_id_10, p0_.project_id AS project_id_11 FROM product_url p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.id DESC
Parameters:
[ 4719 4718 4717 4716 4715 4714 4713 4712 4711 4710 4709 4708 4707 4706 4705 4704 4703 4702 4701 4700 4699 4698 4697 4696 4695 4694 4693 4692 4691 4690 4689 4688 4687 4686 4685 4684 4683 4682 4681 4680 4679 4678 4677 4676 4675 4674 4673 4672 4671 4670 4669 4668 4667 4666 4665 4664 4663 4662 4661 4660 4659 4658 4657 4656 4655 4654 4653 4652 4651 4650 4649 4648 4647 4646 4645 4644 4643 4642 4641 4640 4639 4638 4637 4636 4635 4634 4633 4632 4631 4630 4629 4628 4627 4626 4625 4624 4623 4622 4621 4620 4619 4618 4617 4616 4615 4614 4613 4612 4611 4610 4609 4608 4607 4606 4605 4604 4603 4602 4601 4600 4599 4598 4597 4596 4595 4594 4593 4592 4591 4590 4589 4588 4587 4586 4585 4584 4583 4582 4581 4580 4579 4578 4577 4576 4575 4574 4573 4572 4571 4570 4569 4568 4567 4566 4565 4564 4563 4562 4561 4560 4559 4558 4557 4556 4555 4554 4553 4552 4551 4550 4549 4548 4547 4546 4545 4544 4543 4542 4541 4540 4539 4538 4537 4536 4535 4534 4533 4532 4531 4530 4529 4528 4527 4526 4525 4524 4523 4522 4521 4520 ]
|
||||||||||||||||||||||||||||||||
|
1.99 ms (0.62%) |
1 |
SELECT count(*) AS sclr_0 FROM product_url p0_
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
0.68 ms (0.21%) |
1 |
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
]
|
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\ProductUrl | No errors. |
| App\Entity\SpiderSourceUrl | No errors. |
| App\Entity\Project | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\AILog | No errors. |
| App\Entity\User | No errors. |
| App\Entity\LabReportSource | No errors. |
| App\Entity\LabReport | No errors. |
| App\Entity\ProductPage | No errors. |
| App\Entity\LabReportFail | No errors. |
| App\Entity\AIBatchJob | No errors. |