Symfony Profiler

Query Metrics

30 Database Queries
17 Different statements
23.83 ms Query time
0 Invalid entities
127 Managed entities
Queries


SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.trial_ends_at AS trial_ends_at_5, t0.provisioned_at AS provisioned_at_6, t0.provisioning_log AS provisioning_log_7, t0.last_activity_at AS last_activity_at_8, t0.suspended_reason AS suspended_reason_9, t0.previous_slugs AS previous_slugs_10, t0.vat_number AS vat_number_11, t0.currency AS currency_12, t0.tax_code AS tax_code_13, t0.address AS address_14, t0.zip AS zip_15, t0.city AS city_16, t0.province AS province_17, t0.country AS country_18, t0.email AS email_19, t0.phone AS phone_20, t0.website AS website_21, t0.pec AS pec_22, t0.sdi_code AS sdi_code_23, t0.settings AS settings_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.saas_customer_id AS saas_customer_id_27, t0.plan_id AS plan_id_28 FROM company t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.password_hash AS password_hash_4, t0.status AS status_5, t0.last_login_at AS last_login_at_6, t0.locale AS locale_7, t0.totp_secret AS totp_secret_8, t0.totp_enabled_at AS totp_enabled_at_9, t0.totp_last_slot AS totp_last_slot_10, t0.recovery_codes AS recovery_codes_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_id AS company_id_14, t0.group_id AS group_id_15 FROM app_user t0 WHERE t0.email = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_admin AS is_admin_4, t0.permissions AS permissions_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.company_id AS company_id_8 FROM user_group t0 WHERE t0.id = ?
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sales_order s0_ LEFT JOIN customer c1_ ON s0_.customer_id = c1_.id LEFT JOIN price_list p2_ ON c1_.price_list_id = p2_.id LEFT JOIN connector c3_ ON s0_.connector_id = c3_.id LEFT JOIN warehouse w4_ ON c3_.warehouse_id = w4_.id LEFT JOIN price_list p5_ ON c3_.price_list_id = p5_.id LEFT JOIN price_list p6_ ON s0_.price_list_id = p6_.id LEFT JOIN vat_rate v7_ ON s0_.shipping_vat_id = v7_.id LEFT JOIN warehouse w8_ ON s0_.warehouse_id = w8_.id LEFT JOIN order_line o9_ ON s0_.id = o9_.order_id LEFT JOIN order_coupon o10_ ON s0_.id = o10_.order_id LEFT JOIN order_event o11_ ON s0_.id = o11_.order_id WHERE s0_.company_id = ? AND s0_.status IN (?, ?)
SELECT DISTINCT s0_.id AS id_0, s0_.placed_at AS placed_at_1 FROM sales_order s0_ LEFT JOIN customer c1_ ON s0_.customer_id = c1_.id LEFT JOIN price_list p2_ ON c1_.price_list_id = p2_.id LEFT JOIN connector c3_ ON s0_.connector_id = c3_.id LEFT JOIN warehouse w4_ ON c3_.warehouse_id = w4_.id LEFT JOIN price_list p5_ ON c3_.price_list_id = p5_.id LEFT JOIN price_list p6_ ON s0_.price_list_id = p6_.id LEFT JOIN vat_rate v7_ ON s0_.shipping_vat_id = v7_.id LEFT JOIN warehouse w8_ ON s0_.warehouse_id = w8_.id LEFT JOIN order_line o9_ ON s0_.id = o9_.order_id LEFT JOIN order_coupon o10_ ON s0_.id = o10_.order_id LEFT JOIN order_event o11_ ON s0_.id = o11_.order_id WHERE s0_.company_id = ? AND s0_.status IN (?, ?) ORDER BY s0_.placed_at DESC LIMIT 1
SELECT s0_.id AS id_0, s0_.number AS number_1, s0_.external_number AS external_number_2, s0_.status AS status_3, s0_.source AS source_4, s0_.external_id AS external_id_5, s0_.external_status AS external_status_6, s0_.currency AS currency_7, s0_.billing AS billing_8, s0_.shipping AS shipping_9, s0_.customer_note AS customer_note_10, s0_.internal_note AS internal_note_11, s0_.payment_method AS payment_method_12, s0_.payment_ref AS payment_ref_13, s0_.paid_at AS paid_at_14, s0_.shipping_method AS shipping_method_15, s0_.shipping_cost AS shipping_cost_16, s0_.tracking_number AS tracking_number_17, s0_.tracking_url AS tracking_url_18, s0_.carrier AS carrier_19, s0_.shipped_at AS shipped_at_20, s0_.delivered_at AS delivered_at_21, s0_.subtotal AS subtotal_22, s0_.discount_total AS discount_total_23, s0_.shipping_total AS shipping_total_24, s0_.vat_total AS vat_total_25, s0_.total AS total_26, s0_.stock_deducted AS stock_deducted_27, s0_.raw AS raw_28, s0_.placed_at AS placed_at_29, s0_.billing_status AS billing_status_30, s0_.invoiced_at AS invoiced_at_31, s0_.created_at AS created_at_32, s0_.updated_at AS updated_at_33, c1_.id AS id_34, c1_.code AS code_35, c1_.type AS type_36, c1_.first_name AS first_name_37, c1_.last_name AS last_name_38, c1_.company_name AS company_name_39, c1_.email AS email_40, c1_.phone AS phone_41, c1_.vat_number AS vat_number_42, c1_.tax_code AS tax_code_43, c1_.pec AS pec_44, c1_.sdi_code AS sdi_code_45, c1_.notes AS notes_46, c1_.status AS status_47, c1_.external_refs AS external_refs_48, c1_.created_at AS created_at_49, c1_.updated_at AS updated_at_50, p2_.id AS id_51, p2_.code AS code_52, p2_.name AS name_53, p2_.description AS description_54, p2_.currency AS currency_55, p2_.prices_include_vat AS prices_include_vat_56, p2_.is_default AS is_default_57, p2_.position AS position_58, p2_.status AS status_59, p2_.created_at AS created_at_60, p2_.updated_at AS updated_at_61, c3_.id AS id_62, c3_.type AS type_63, c3_.name AS name_64, c3_.status AS status_65, c3_.config AS config_66, c3_.credentials_cipher AS credentials_cipher_67, c3_.sync_stock AS sync_stock_68, c3_.sync_prices AS sync_prices_69, c3_.stock_reserve AS stock_reserve_70, c3_.stock_cap AS stock_cap_71, c3_.last_price_push_at AS last_price_push_at_72, c3_.last_sync_at AS last_sync_at_73, c3_.last_error AS last_error_74, c3_.last_import_at AS last_import_at_75, c3_.last_stock_push_at AS last_stock_push_at_76, c3_.created_at AS created_at_77, c3_.updated_at AS updated_at_78, w4_.id AS id_79, w4_.code AS code_80, w4_.name AS name_81, w4_.address AS address_82, w4_.is_default AS is_default_83, w4_.created_at AS created_at_84, w4_.updated_at AS updated_at_85, p5_.id AS id_86, p5_.code AS code_87, p5_.name AS name_88, p5_.description AS description_89, p5_.currency AS currency_90, p5_.prices_include_vat AS prices_include_vat_91, p5_.is_default AS is_default_92, p5_.position AS position_93, p5_.status AS status_94, p5_.created_at AS created_at_95, p5_.updated_at AS updated_at_96, p6_.id AS id_97, p6_.code AS code_98, p6_.name AS name_99, p6_.description AS description_100, p6_.currency AS currency_101, p6_.prices_include_vat AS prices_include_vat_102, p6_.is_default AS is_default_103, p6_.position AS position_104, p6_.status AS status_105, p6_.created_at AS created_at_106, p6_.updated_at AS updated_at_107, v7_.id AS id_108, v7_.code AS code_109, v7_.name AS name_110, v7_.rate AS rate_111, v7_.nature AS nature_112, v7_.reference AS reference_113, v7_.is_default AS is_default_114, v7_.status AS status_115, v7_.position AS position_116, v7_.created_at AS created_at_117, v7_.updated_at AS updated_at_118, w8_.id AS id_119, w8_.code AS code_120, w8_.name AS name_121, w8_.address AS address_122, w8_.is_default AS is_default_123, w8_.created_at AS created_at_124, w8_.updated_at AS updated_at_125, o9_.id AS id_126, o9_.sku AS sku_127, o9_.name AS name_128, o9_.variant_label AS variant_label_129, o9_.quantity AS quantity_130, o9_.unit_price AS unit_price_131, o9_.vat_rate AS vat_rate_132, o9_.discount AS discount_133, o9_.line_total AS line_total_134, o9_.vat_amount AS vat_amount_135, o9_.unmatched AS unmatched_136, o9_.position AS position_137, o10_.id AS id_138, o10_.code AS code_139, o10_.description AS description_140, o10_.amount AS amount_141, o10_.position AS position_142, o11_.id AS id_143, o11_.type AS type_144, o11_.from_status AS from_status_145, o11_.to_status AS to_status_146, o11_.message AS message_147, o11_.actor AS actor_148, o11_.created_at AS created_at_149, s0_.company_id AS company_id_150, s0_.customer_id AS customer_id_151, s0_.connector_id AS connector_id_152, s0_.price_list_id AS price_list_id_153, s0_.shipping_vat_id AS shipping_vat_id_154, s0_.warehouse_id AS warehouse_id_155, c1_.company_id AS company_id_156, c1_.price_list_id AS price_list_id_157, p2_.company_id AS company_id_158, c3_.company_id AS company_id_159, c3_.warehouse_id AS warehouse_id_160, c3_.price_list_id AS price_list_id_161, w4_.company_id AS company_id_162, p5_.company_id AS company_id_163, p6_.company_id AS company_id_164, v7_.company_id AS company_id_165, w8_.company_id AS company_id_166, o9_.order_id AS order_id_167, o9_.product_id AS product_id_168, o9_.vat_id AS vat_id_169, o10_.order_id AS order_id_170, o10_.coupon_id AS coupon_id_171, o11_.order_id AS order_id_172 FROM sales_order s0_ LEFT JOIN customer c1_ ON s0_.customer_id = c1_.id LEFT JOIN price_list p2_ ON c1_.price_list_id = p2_.id LEFT JOIN connector c3_ ON s0_.connector_id = c3_.id LEFT JOIN warehouse w4_ ON c3_.warehouse_id = w4_.id LEFT JOIN price_list p5_ ON c3_.price_list_id = p5_.id LEFT JOIN price_list p6_ ON s0_.price_list_id = p6_.id LEFT JOIN vat_rate v7_ ON s0_.shipping_vat_id = v7_.id LEFT JOIN warehouse w8_ ON s0_.warehouse_id = w8_.id LEFT JOIN order_line o9_ ON s0_.id = o9_.order_id LEFT JOIN order_coupon o10_ ON s0_.id = o10_.order_id LEFT JOIN order_event o11_ ON s0_.id = o11_.order_id WHERE s0_.company_id = ? AND s0_.status IN (?, ?) AND s0_.id IN (?) ORDER BY s0_.placed_at DESC, o9_.position ASC, o10_.position ASC, o11_.created_at DESC
SELECT COUNT(*) AS n, COALESCE(SUM(total), 0) AS spent, MAX(placed_at) AS last FROM sales_order WHERE customer_id = ? AND status NOT IN ('cancelled', 'refunded')
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.ean AS ean_5, t0.supplier_sku AS supplier_sku_6, t0.variant_label AS variant_label_7, t0.unit AS unit_8, t0.price AS price_9, t0.cost AS cost_10, t0.track_stock AS track_stock_11, t0.stock_quantity AS stock_quantity_12, t0.min_stock AS min_stock_13, t0.weight_grams AS weight_grams_14, t0.status AS status_15, t0.attributes AS attributes_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19, t0.brand_id AS brand_id_20, t0.category_id AS category_id_21, t0.supplier_id AS supplier_id_22, t0.parent_id AS parent_id_23, t0.vat_id AS vat_id_24 FROM product t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.description AS description_4, t0.currency AS currency_5, t0.prices_include_vat AS prices_include_vat_6, t0.is_default AS is_default_7, t0.position AS position_8, t0.status AS status_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.company_id AS company_id_12 FROM price_list t0 WHERE t0.company_id = ? AND t0.status = ? ORDER BY t0.is_default DESC, t0.position ASC, t0.code ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.company_id AS company_id_5 FROM brand t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.company_id AS company_id_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.vat_number AS vat_number_4, t0.tax_code AS tax_code_5, t0.email AS email_6, t0.phone AS phone_7, t0.address AS address_8, t0.zip AS zip_9, t0.city AS city_10, t0.province AS province_11, t0.country AS country_12, t0.website AS website_13, t0.payment_terms AS payment_terms_14, t0.notes AS notes_15, t0.status AS status_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19 FROM supplier t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.ean AS ean_5, t0.supplier_sku AS supplier_sku_6, t0.variant_label AS variant_label_7, t0.unit AS unit_8, t0.price AS price_9, t0.cost AS cost_10, t0.track_stock AS track_stock_11, t0.stock_quantity AS stock_quantity_12, t0.min_stock AS min_stock_13, t0.weight_grams AS weight_grams_14, t0.status AS status_15, t0.attributes AS attributes_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19, t0.brand_id AS brand_id_20, t0.category_id AS category_id_21, t0.supplier_id AS supplier_id_22, t0.parent_id AS parent_id_23, t0.vat_id AS vat_id_24 FROM product t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.rate AS rate_4, t0.nature AS nature_5, t0.reference AS reference_6, t0.is_default AS is_default_7, t0.status AS status_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.company_id AS company_id_12 FROM vat_rate t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.ean AS ean_5, t0.supplier_sku AS supplier_sku_6, t0.variant_label AS variant_label_7, t0.unit AS unit_8, t0.price AS price_9, t0.cost AS cost_10, t0.track_stock AS track_stock_11, t0.stock_quantity AS stock_quantity_12, t0.min_stock AS min_stock_13, t0.weight_grams AS weight_grams_14, t0.status AS status_15, t0.attributes AS attributes_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19, t0.brand_id AS brand_id_20, t0.category_id AS category_id_21, t0.supplier_id AS supplier_id_22, t0.parent_id AS parent_id_23, t0.vat_id AS vat_id_24 FROM product t0 WHERE t0.vat_id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.product_id AS product_id_3, t0.price_list_id AS price_list_id_4 FROM product_price t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.product_id AS product_id_3, t0.price_list_id AS price_list_id_4 FROM product_price t0 WHERE t0.price_list_id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.product_id AS product_id_3, t0.price_list_id AS price_list_id_4 FROM product_price t0 WHERE t0.price_list_id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.product_id AS product_id_3, t0.price_list_id AS price_list_id_4 FROM product_price t0 WHERE t0.price_list_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.company_id AS company_id_5 FROM brand t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.company_id AS company_id_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.vat_number AS vat_number_4, t0.tax_code AS tax_code_5, t0.email AS email_6, t0.phone AS phone_7, t0.address AS address_8, t0.zip AS zip_9, t0.city AS city_10, t0.province AS province_11, t0.country AS country_12, t0.website AS website_13, t0.payment_terms AS payment_terms_14, t0.notes AS notes_15, t0.status AS status_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19 FROM supplier t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.ean AS ean_5, t0.supplier_sku AS supplier_sku_6, t0.variant_label AS variant_label_7, t0.unit AS unit_8, t0.price AS price_9, t0.cost AS cost_10, t0.track_stock AS track_stock_11, t0.stock_quantity AS stock_quantity_12, t0.min_stock AS min_stock_13, t0.weight_grams AS weight_grams_14, t0.status AS status_15, t0.attributes AS attributes_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19, t0.brand_id AS brand_id_20, t0.category_id AS category_id_21, t0.supplier_id AS supplier_id_22, t0.parent_id AS parent_id_23, t0.vat_id AS vat_id_24 FROM product t0 WHERE t0.supplier_id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.product_id AS product_id_3, t0.price_list_id AS price_list_id_4 FROM product_price t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.rate AS rate_4, t0.nature AS nature_5, t0.reference AS reference_6, t0.is_default AS is_default_7, t0.status AS status_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.company_id AS company_id_12 FROM vat_rate t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.ean AS ean_5, t0.supplier_sku AS supplier_sku_6, t0.variant_label AS variant_label_7, t0.unit AS unit_8, t0.price AS price_9, t0.cost AS cost_10, t0.track_stock AS track_stock_11, t0.stock_quantity AS stock_quantity_12, t0.min_stock AS min_stock_13, t0.weight_grams AS weight_grams_14, t0.status AS status_15, t0.attributes AS attributes_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.company_id AS company_id_19, t0.brand_id AS brand_id_20, t0.category_id AS category_id_21, t0.supplier_id AS supplier_id_22, t0.parent_id AS parent_id_23, t0.vat_id AS vat_id_24 FROM product t0 WHERE t0.vat_id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.product_id AS product_id_3, t0.price_list_id AS price_list_id_4 FROM product_price t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.company_id AS company_id_5 FROM brand t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.company_id AS company_id_6, t0.parent_id AS parent_id_7 FROM category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.price AS price_2, t0.product_id AS product_id_3, t0.price_list_id AS price_list_id_4 FROM product_price t0 WHERE t0.product_id = ?
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.
Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\ProductPrice	52
App\Entity\Product	32
App\Entity\Category	14
App\Entity\Brand	6
App\Entity\OrderLine	4
App\Entity\OrderEvent	3
App\Entity\Supplier	3
App\Entity\PriceList	3
App\Entity\VatRate	2
App\Entity\Company	1
App\Entity\SaasCustomer	1
App\Entity\Plan	1
App\Entity\User	1
App\Entity\UserGroup	1
App\Entity\Order	1
App\Entity\Customer	1
App\Entity\Warehouse	1
Entities Mapping

Class	Mapping errors
App\Entity\Company	No errors.
App\Entity\SaasCustomer	No errors.
App\Entity\Plan	No errors.
App\Entity\User	No errors.
App\Entity\UserGroup	No errors.
App\Entity\Order	No errors.
App\Entity\Customer	No errors.
App\Entity\PriceList	No errors.
App\Entity\Connector	No errors.
App\Entity\Warehouse	No errors.
App\Entity\VatRate	No errors.
App\Entity\OrderLine	No errors.
App\Entity\OrderCoupon	No errors.
App\Entity\OrderEvent	No errors.
App\Entity\Product	No errors.
App\Entity\Coupon	No errors.
App\Entity\CustomerAddress	No errors.
App\Entity\Brand	No errors.
App\Entity\Category	No errors.
App\Entity\Supplier	No errors.
App\Entity\ProductPrice	No errors.
App\Entity\StockLevel	No errors.
Symfony Profiler

GET https://essenza.fulcro.opentag.hr/api/orders?itemsPerPage=1&status%5B0%5D=paid&status%5B1%5D=processing

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
