Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

32.42 ms Query time

2 Invalid entities

18 Managed entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
25.92 ms (79.94%)	1	SELECT t0.id AS id_1, t0.distributor_name AS distributor_name_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.website AS website_6, t0.about AS about_7, t0.operating_hours AS operating_hours_8, t0.refund_policy AS refund_policy_9, t0.sales_tax_policy AS sales_tax_policy_10, t0.is_manufaturer AS is_manufaturer_11, t0.theme_id AS theme_id_12, t0.modified AS modified_13, t0.created AS created_14, t0.po_number_prefix AS po_number_prefix_15, t0.address_street AS address_street_16, t0.address_city AS address_city_17, t0.address_postal_code AS address_postal_code_18, t0.address_state AS address_state_19, t0.shipping_policy AS shipping_policy_20, t0.iso_code AS iso_code_21, t0.intl_code AS intl_code_22, t0.hashed_email AS hashed_email_23, t0.domain_name AS domain_name_24, t0.is_approved AS is_approved_25, t0.manager_first_name AS manager_first_name_26, t0.manager_last_name AS manager_last_name_27, t0.trade_license AS trade_license_28, t0.trade_license_no AS trade_license_no_29, t0.trade_license_exp_date AS trade_license_exp_date_30, t0.manager_id_no AS manager_id_no_31, t0.manager_id_exp_date AS manager_id_exp_date_32, t0.address_country_id AS address_country_id_33, t34.id AS id_35, t34.client_id AS client_id_36, t34.client_secret AS client_secret_37, t34.modified AS modified_38, t34.created AS created_39, t34.organization_id AS organization_id_40, t34.distributor_id AS distributor_id_41, t34.api_id AS api_id_42, t0.tracking_id AS tracking_id_43, t44.id AS id_45, t44.username AS username_46, t44.password AS password_47, t44.login_url AS login_url_48, t44.domain AS domain_49, t44.requires_authentication AS requires_authentication_50, t44.modified AS modified_51, t44.created AS created_52, t44.command AS command_53, t44.create_products AS create_products_54, t44.get_images AS get_images_55, t44.distributor_id AS distributor_id_56 FROM distributors t0 LEFT JOIN api_details t34 ON t34.distributor_id = t0.id LEFT JOIN scraper_aunthentication t44 ON t44.distributor_id = t0.id WHERE t0.is_approved = ? Parameters: [`true`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.distributor_name AS distributor_name_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.website AS website_6, t0.about AS about_7, t0.operating_hours AS operating_hours_8, t0.refund_policy AS refund_policy_9, t0.sales_tax_policy AS sales_tax_policy_10, t0.is_manufaturer AS is_manufaturer_11, t0.theme_id AS theme_id_12, t0.modified AS modified_13, t0.created AS created_14, t0.po_number_prefix AS po_number_prefix_15, t0.address_street AS address_street_16, t0.address_city AS address_city_17, t0.address_postal_code AS address_postal_code_18, t0.address_state AS address_state_19, t0.shipping_policy AS shipping_policy_20, t0.iso_code AS iso_code_21, t0.intl_code AS intl_code_22, t0.hashed_email AS hashed_email_23, t0.domain_name AS domain_name_24, t0.is_approved AS is_approved_25, t0.manager_first_name AS manager_first_name_26, t0.manager_last_name AS manager_last_name_27, t0.trade_license AS trade_license_28, t0.trade_license_no AS trade_license_no_29, t0.trade_license_exp_date AS trade_license_exp_date_30, t0.manager_id_no AS manager_id_no_31, t0.manager_id_exp_date AS manager_id_exp_date_32, t0.address_country_id AS address_country_id_33, t34.id AS id_35, t34.client_id AS client_id_36, t34.client_secret AS client_secret_37, t34.modified AS modified_38, t34.created AS created_39, t34.organization_id AS organization_id_40, t34.distributor_id AS distributor_id_41, t34.api_id AS api_id_42, t0.tracking_id AS tracking_id_43, t44.id AS id_45, t44.username AS username_46, t44.password AS password_47, t44.login_url AS login_url_48, t44.domain AS domain_49, t44.requires_authentication AS requires_authentication_50, t44.modified AS modified_51, t44.created AS created_52, t44.command AS command_53, t44.create_products AS create_products_54, t44.get_images AS get_images_55, t44.distributor_id AS distributor_id_56 FROM distributors t0 LEFT JOIN api_details t34 ON t34.distributor_id = t0.id LEFT JOIN scraper_aunthentication t44 ON t44.distributor_id = t0.id WHERE t0.is_approved = ? SELECT t0.id AS id_1, t0.distributor_name AS distributor_name_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.website AS website_6, t0.about AS about_7, t0.operating_hours AS operating_hours_8, t0.refund_policy AS refund_policy_9, t0.sales_tax_policy AS sales_tax_policy_10, t0.is_manufaturer AS is_manufaturer_11, t0.theme_id AS theme_id_12, t0.modified AS modified_13, t0.created AS created_14, t0.po_number_prefix AS po_number_prefix_15, t0.address_street AS address_street_16, t0.address_city AS address_city_17, t0.address_postal_code AS address_postal_code_18, t0.address_state AS address_state_19, t0.shipping_policy AS shipping_policy_20, t0.iso_code AS iso_code_21, t0.intl_code AS intl_code_22, t0.hashed_email AS hashed_email_23, t0.domain_name AS domain_name_24, t0.is_approved AS is_approved_25, t0.manager_first_name AS manager_first_name_26, t0.manager_last_name AS manager_last_name_27, t0.trade_license AS trade_license_28, t0.trade_license_no AS trade_license_no_29, t0.trade_license_exp_date AS trade_license_exp_date_30, t0.manager_id_no AS manager_id_no_31, t0.manager_id_exp_date AS manager_id_exp_date_32, t0.address_country_id AS address_country_id_33, t34.id AS id_35, t34.client_id AS client_id_36, t34.client_secret AS client_secret_37, t34.modified AS modified_38, t34.created AS created_39, t34.organization_id AS organization_id_40, t34.distributor_id AS distributor_id_41, t34.api_id AS api_id_42, t0.tracking_id AS tracking_id_43, t44.id AS id_45, t44.username AS username_46, t44.password AS password_47, t44.login_url AS login_url_48, t44.domain AS domain_49, t44.requires_authentication AS requires_authentication_50, t44.modified AS modified_51, t44.created AS created_52, t44.command AS command_53, t44.create_products AS create_products_54, t44.get_images AS get_images_55, t44.distributor_id AS distributor_id_56 FROM distributors t0 LEFT JOIN api_details t34 ON t34.distributor_id = t0.id LEFT JOIN scraper_aunthentication t44 ON t44.distributor_id = t0.id WHERE t0.is_approved = 1;
6.50 ms (20.06%)	1	SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0 WHERE t0.id = ? Parameters: [`237`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0 WHERE t0.id = 237;

Time▼

Count

Info

25.92 ms
(79.94%)

SELECT t0.id AS id_1, t0.distributor_name AS distributor_name_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.website AS website_6, t0.about AS about_7, t0.operating_hours AS operating_hours_8, t0.refund_policy AS refund_policy_9, t0.sales_tax_policy AS sales_tax_policy_10, t0.is_manufaturer AS is_manufaturer_11, t0.theme_id AS theme_id_12, t0.modified AS modified_13, t0.created AS created_14, t0.po_number_prefix AS po_number_prefix_15, t0.address_street AS address_street_16, t0.address_city AS address_city_17, t0.address_postal_code AS address_postal_code_18, t0.address_state AS address_state_19, t0.shipping_policy AS shipping_policy_20, t0.iso_code AS iso_code_21, t0.intl_code AS intl_code_22, t0.hashed_email AS hashed_email_23, t0.domain_name AS domain_name_24, t0.is_approved AS is_approved_25, t0.manager_first_name AS manager_first_name_26, t0.manager_last_name AS manager_last_name_27, t0.trade_license AS trade_license_28, t0.trade_license_no AS trade_license_no_29, t0.trade_license_exp_date AS trade_license_exp_date_30, t0.manager_id_no AS manager_id_no_31, t0.manager_id_exp_date AS manager_id_exp_date_32, t0.address_country_id AS address_country_id_33, t34.id AS id_35, t34.client_id AS client_id_36, t34.client_secret AS client_secret_37, t34.modified AS modified_38, t34.created AS created_39, t34.organization_id AS organization_id_40, t34.distributor_id AS distributor_id_41, t34.api_id AS api_id_42, t0.tracking_id AS tracking_id_43, t44.id AS id_45, t44.username AS username_46, t44.password AS password_47, t44.login_url AS login_url_48, t44.domain AS domain_49, t44.requires_authentication AS requires_authentication_50, t44.modified AS modified_51, t44.created AS created_52, t44.command AS command_53, t44.create_products AS create_products_54, t44.get_images AS get_images_55, t44.distributor_id AS distributor_id_56 FROM distributors t0 LEFT JOIN api_details t34 ON t34.distributor_id = t0.id LEFT JOIN scraper_aunthentication t44 ON t44.distributor_id = t0.id WHERE t0.is_approved = ?

Parameters:

[
  true
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.distributor_name AS distributor_name_2,
  t0.logo AS logo_3,
  t0.telephone AS telephone_4,
  t0.email AS email_5,
  t0.website AS website_6,
  t0.about AS about_7,
  t0.operating_hours AS operating_hours_8,
  t0.refund_policy AS refund_policy_9,
  t0.sales_tax_policy AS sales_tax_policy_10,
  t0.is_manufaturer AS is_manufaturer_11,
  t0.theme_id AS theme_id_12,
  t0.modified AS modified_13,
  t0.created AS created_14,
  t0.po_number_prefix AS po_number_prefix_15,
  t0.address_street AS address_street_16,
  t0.address_city AS address_city_17,
  t0.address_postal_code AS address_postal_code_18,
  t0.address_state AS address_state_19,
  t0.shipping_policy AS shipping_policy_20,
  t0.iso_code AS iso_code_21,
  t0.intl_code AS intl_code_22,
  t0.hashed_email AS hashed_email_23,
  t0.domain_name AS domain_name_24,
  t0.is_approved AS is_approved_25,
  t0.manager_first_name AS manager_first_name_26,
  t0.manager_last_name AS manager_last_name_27,
  t0.trade_license AS trade_license_28,
  t0.trade_license_no AS trade_license_no_29,
  t0.trade_license_exp_date AS trade_license_exp_date_30,
  t0.manager_id_no AS manager_id_no_31,
  t0.manager_id_exp_date AS manager_id_exp_date_32,
  t0.address_country_id AS address_country_id_33,
  t34.id AS id_35,
  t34.client_id AS client_id_36,
  t34.client_secret AS client_secret_37,
  t34.modified AS modified_38,
  t34.created AS created_39,
  t34.organization_id AS organization_id_40,
  t34.distributor_id AS distributor_id_41,
  t34.api_id AS api_id_42,
  t0.tracking_id AS tracking_id_43,
  t44.id AS id_45,
  t44.username AS username_46,
  t44.password AS password_47,
  t44.login_url AS login_url_48,
  t44.domain AS domain_49,
  t44.requires_authentication AS requires_authentication_50,
  t44.modified AS modified_51,
  t44.created AS created_52,
  t44.command AS command_53,
  t44.create_products AS create_products_54,
  t44.get_images AS get_images_55,
  t44.distributor_id AS distributor_id_56
FROM
  distributors t0
  LEFT JOIN api_details t34 ON t34.distributor_id = t0.id
  LEFT JOIN scraper_aunthentication t44 ON t44.distributor_id = t0.id
WHERE
  t0.is_approved = ?

SELECT t0.id AS id_1, t0.distributor_name AS distributor_name_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.website AS website_6, t0.about AS about_7, t0.operating_hours AS operating_hours_8, t0.refund_policy AS refund_policy_9, t0.sales_tax_policy AS sales_tax_policy_10, t0.is_manufaturer AS is_manufaturer_11, t0.theme_id AS theme_id_12, t0.modified AS modified_13, t0.created AS created_14, t0.po_number_prefix AS po_number_prefix_15, t0.address_street AS address_street_16, t0.address_city AS address_city_17, t0.address_postal_code AS address_postal_code_18, t0.address_state AS address_state_19, t0.shipping_policy AS shipping_policy_20, t0.iso_code AS iso_code_21, t0.intl_code AS intl_code_22, t0.hashed_email AS hashed_email_23, t0.domain_name AS domain_name_24, t0.is_approved AS is_approved_25, t0.manager_first_name AS manager_first_name_26, t0.manager_last_name AS manager_last_name_27, t0.trade_license AS trade_license_28, t0.trade_license_no AS trade_license_no_29, t0.trade_license_exp_date AS trade_license_exp_date_30, t0.manager_id_no AS manager_id_no_31, t0.manager_id_exp_date AS manager_id_exp_date_32, t0.address_country_id AS address_country_id_33, t34.id AS id_35, t34.client_id AS client_id_36, t34.client_secret AS client_secret_37, t34.modified AS modified_38, t34.created AS created_39, t34.organization_id AS organization_id_40, t34.distributor_id AS distributor_id_41, t34.api_id AS api_id_42, t0.tracking_id AS tracking_id_43, t44.id AS id_45, t44.username AS username_46, t44.password AS password_47, t44.login_url AS login_url_48, t44.domain AS domain_49, t44.requires_authentication AS requires_authentication_50, t44.modified AS modified_51, t44.created AS created_52, t44.command AS command_53, t44.create_products AS create_products_54, t44.get_images AS get_images_55, t44.distributor_id AS distributor_id_56 FROM distributors t0 LEFT JOIN api_details t34 ON t34.distributor_id = t0.id LEFT JOIN scraper_aunthentication t44 ON t44.distributor_id = t0.id WHERE t0.is_approved = 1;

6.50 ms
(20.06%)

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0 WHERE t0.id = ?

Parameters:

[
  237
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.phone AS phone_2,
  t0.code AS code_3,
  t0.name AS name_4,
  t0.modified AS modified_5,
  t0.created AS created_6,
  t0.is_active AS is_active_7,
  t0.currency AS currency_8
FROM
  countries t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.phone AS phone_2, t0.code AS code_3, t0.name AS name_4, t0.modified AS modified_5, t0.created AS created_6, t0.is_active AS is_active_7, t0.currency AS currency_8 FROM countries t0 WHERE t0.id = 237;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
remote	doctrine.dbal.remote_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
remote	doctrine.orm.remote_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Distributors	5
App\Entity\ApiDetails	5
App\Entity\ScraperAunthentication	5
App\Entity\Countries	1
App\Entity\Tracking	1
App\Entity\Api	1

remote entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Distributors	No errors.
App\Entity\Countries	No errors.
App\Entity\ApiDetails	No errors.
App\Entity\Api	No errors.
App\Entity\Tracking	No errors.
App\Entity\ScraperAunthentication	No errors.
App\Entity\DistributorClinicPrices	No errors.
App\Entity\DistributorProducts	No errors.
App\Entity\DistributorUsers	No errors.
App\Entity\EventLog	No errors.
App\Entity\OrderItems	No errors.
App\Entity\ListItems	No errors.
App\Entity\BasketItems	No errors.
App\Entity\ClinicProducts	No errors.
App\Entity\AvailabilityTracker	No errors.
App\Entity\ChatParticipants	No errors.
App\Entity\ChatMessages	No errors.
App\Entity\Notifications	No errors.
App\Entity\OrderStatus	No errors.
App\Entity\DistributorUserPermissions	No errors.
App\Entity\DistributorClinics	No errors.
App\Entity\ControlledDrugFiles	No errors.
App\Entity\CustomPriceLists	No errors.
App\Entity\ScraperUrls	No errors.
App\Entity\ClinicDistributorContacts	No errors.
App\Entity\ScraperLog	No errors.
App\Entity\ScraperProducts	No errors.
App\Entity\AiDistributorProducts	No errors.
App\Entity\AiListItems	No errors.
App\Entity\AiBasketItems	No errors.
App\Entity\AiOrderItems	No errors.
App\Entity\AiClinicProducts	No errors.
App\Entity\AiCustomPriceLists	No errors.
App\Entity\AiControlledDrugFiles	No errors.
App\Entity\AiOrderStatus	No errors.
App\Entity\RefreshTokens	No errors.
App\Entity\Clinics	The association App\Entity\Clinics#retailUsers refers to the owning side field App\Entity\RetailUsers#clinic which does not exist.
App\Entity\RetailUsers	The association App\Entity\RetailUsers#addresses refers to the owning side field App\Entity\Addresses#retail which does not exist. The association App\Entity\RetailUsers#baskets refers to the owning side field App\Entity\Baskets#retailUser which does not exist. The association App\Entity\RetailUsers#orders refers to the owning side field App\Entity\Orders#retail which does not exist.

remote entity manager

No loaded entities.

Symfony Profiler

GET https://dev.fluid.vet/sellers

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

remote entity manager

Entities Mapping

default entity manager

remote entity manager