Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1109.56 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1084.35 ms
(97.73%)

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_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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_

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_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 204)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 458)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 232)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 47)
21	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

18.57 ms
(1.67%)

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.external_url AS external_url_2, l0_.source AS source_3, l0_.type AS type_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.category AS category_7, l0_.state AS state_8, l0_.expiry_date AS expiry_date_9, l0_.extraction_date AS extraction_date_10, l0_.thca_percentage AS thca_percentage_11, l0_.total_thc_percentage AS total_thc_percentage_12, l0_.delta_nine_percentage AS delta_nine_percentage_13, l0_.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_14, l0_.comments AS comments_15, l0_.internal_url AS internal_url_16, l0_.markdown_content AS markdown_content_17, l0_.debug_data AS debug_data_18, l0_.json_content AS json_content_19, l0_.lab_name AS lab_name_20, l0_.sample_name AS sample_name_21, l0_.sample_matrix AS sample_matrix_22, l0_.internal_path AS internal_path_23, l0_.product_type AS product_type_24, l0_.project_id AS project_id_25, l0_.lab_report_source_id AS lab_report_source_id_26 FROM lab_report l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.external_url AS external_url_2,
  l0_.source AS source_3,
  l0_.type AS type_4,
  l0_.created_at AS created_at_5,
  l0_.updated_at AS updated_at_6,
  l0_.category AS category_7,
  l0_.state AS state_8,
  l0_.expiry_date AS expiry_date_9,
  l0_.extraction_date AS extraction_date_10,
  l0_.thca_percentage AS thca_percentage_11,
  l0_.total_thc_percentage AS total_thc_percentage_12,
  l0_.delta_nine_percentage AS delta_nine_percentage_13,
  l0_.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_14,
  l0_.comments AS comments_15,
  l0_.internal_url AS internal_url_16,
  l0_.markdown_content AS markdown_content_17,
  l0_.debug_data AS debug_data_18,
  l0_.json_content AS json_content_19,
  l0_.lab_name AS lab_name_20,
  l0_.sample_name AS sample_name_21,
  l0_.sample_matrix AS sample_matrix_22,
  l0_.internal_path AS internal_path_23,
  l0_.product_type AS product_type_24,
  l0_.project_id AS project_id_25,
  l0_.lab_report_source_id AS lab_report_source_id_26
FROM
  lab_report l0_

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.external_url AS external_url_2, l0_.source AS source_3, l0_.type AS type_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6, l0_.category AS category_7, l0_.state AS state_8, l0_.expiry_date AS expiry_date_9, l0_.extraction_date AS extraction_date_10, l0_.thca_percentage AS thca_percentage_11, l0_.total_thc_percentage AS total_thc_percentage_12, l0_.delta_nine_percentage AS delta_nine_percentage_13, l0_.delta_nine_with_thca_combined AS delta_nine_with_thca_combined_14, l0_.comments AS comments_15, l0_.internal_url AS internal_url_16, l0_.markdown_content AS markdown_content_17, l0_.debug_data AS debug_data_18, l0_.json_content AS json_content_19, l0_.lab_name AS lab_name_20, l0_.sample_name AS sample_name_21, l0_.sample_matrix AS sample_matrix_22, l0_.internal_path AS internal_path_23, l0_.product_type AS product_type_24, l0_.project_id AS project_id_25, l0_.lab_report_source_id AS lab_report_source_id_26 FROM lab_report l0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 204)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 458)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 232)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 47)
21	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

4.63 ms
(0.42%)

SELECT t0.id AS id_1, t0.request_content AS request_content_2, t0.response_content AS response_content_3, t0.model AS model_4, t0.provider AS provider_5, t0.action AS action_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.response_output_type AS response_output_type_9, t0.project_id AS project_id_10, t0.lab_report_id AS lab_report_id_11, t0.product_url_id AS product_url_id_12 FROM ailog t0 WHERE t0.id = ?

Parameters:

[
  "2130"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.request_content AS request_content_2,
  t0.response_content AS response_content_3,
  t0.model AS model_4,
  t0.provider AS provider_5,
  t0.action AS action_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.response_output_type AS response_output_type_9,
  t0.project_id AS project_id_10,
  t0.lab_report_id AS lab_report_id_11,
  t0.product_url_id AS product_url_id_12
FROM
  ailog t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.request_content AS request_content_2, t0.response_content AS response_content_3, t0.model AS model_4, t0.provider AS provider_5, t0.action AS action_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.response_output_type AS response_output_type_9, t0.project_id AS project_id_10, t0.lab_report_id AS lab_report_id_11, t0.product_url_id AS product_url_id_12 FROM ailog t0 WHERE t0.id = '2130';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 146)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->getEntityInstance (line 111)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 70)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 252)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 65)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 120)
12	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequest (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

2.00 ms
(0.18%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.url AS url_2, p0_.prompt AS prompt_3, p0_.chat_json AS chat_json_4, p0_.external_lab_reports_url AS external_lab_reports_url_5, p0_.product_matching_url AS product_matching_url_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.spider_source_matching_urls AS spider_source_matching_urls_9, p0_.state AS state_10, p0_.website_framework AS website_framework_11, p0_.debug_data AS debug_data_12, p0_.product_exclude_paths AS product_exclude_paths_13, p0_.user_id AS user_id_14 FROM project p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.url AS url_2,
  p0_.prompt AS prompt_3,
  p0_.chat_json AS chat_json_4,
  p0_.external_lab_reports_url AS external_lab_reports_url_5,
  p0_.product_matching_url AS product_matching_url_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8,
  p0_.spider_source_matching_urls AS spider_source_matching_urls_9,
  p0_.state AS state_10,
  p0_.website_framework AS website_framework_11,
  p0_.debug_data AS debug_data_12,
  p0_.product_exclude_paths AS product_exclude_paths_13,
  p0_.user_id AS user_id_14
FROM
  project p0_

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.url AS url_2, p0_.prompt AS prompt_3, p0_.chat_json AS chat_json_4, p0_.external_lab_reports_url AS external_lab_reports_url_5, p0_.product_matching_url AS product_matching_url_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.spider_source_matching_urls AS spider_source_matching_urls_9, p0_.state AS state_10, p0_.website_framework AS website_framework_11, p0_.debug_data AS debug_data_12, p0_.product_exclude_paths AS product_exclude_paths_13, p0_.user_id AS user_id_14 FROM project p0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 204)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 458)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 232)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 47)
21	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

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

Symfony Profiler

GET https://cbdextract.nw.agency/admin?crudAction=edit&crudControllerFqcn=App%5CController%5CAdmin%5CAILogCrudController&entityId=2130

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping