Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3752.79 ms Query time

23 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3751.45 ms
(99.96%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.sku AS sku_3, t0.price AS price_4, t0.images AS images_5, t0.msrp AS msrp_6, t0.discount AS discount_7, t0.total_units AS total_units_8, t0.package_units AS package_units_9, t0.package_format AS package_format_10, t0.is_cp AS is_cp_11, t0.manifest AS manifest_12, t0.weight AS weight_13, t0.description AS description_14, t0.sale_price AS sale_price_15, t0.cost_price AS cost_price_16, t0.calculated_price AS calculated_price_17, t0.quantity_on_hand AS quantity_on_hand_18, t0.quantity_pending AS quantity_pending_19, t0.quantity_available AS quantity_available_20, t0.track_inventory AS track_inventory_21, t0.sort_order AS sort_order_22, t0.is_visible AS is_visible_23, t0.is_allow_purchase AS is_allow_purchase_24, t0.product_availability AS product_availability_25, t0.minimum_purchase_quantity AS minimum_purchase_quantity_26, t0.maximum_purchase_quantity AS maximum_purchase_quantity_27, t0.has_free_shipping AS has_free_shipping_28, t0.fixed_shipping_price AS fixed_shipping_price_29, t0.width AS width_30, t0.height AS height_31, t0.depth AS depth_32, t0.brand AS brand_33, t0.warranty AS warranty_34, t0.show_product_condition AS show_product_condition_35, t0.code AS code_36, t0.tax_group AS tax_group_37, t0.tax_provider_code AS tax_provider_code_38, t0.search_keywords AS search_keywords_39, t0.page_title AS page_title_40, t0.meta_keywords AS meta_keywords_41, t0.meta_description AS meta_description_42, t0.slug AS slug_43, t0.cost_per_unit AS cost_per_unit_44, t0.is_overstock_lot AS is_overstock_lot_45, t0.is_add_on_lot AS is_add_on_lot_46, t0.is_price_drop AS is_price_drop_47, t0.price_dropped_at AS price_dropped_at_48, t0.published_at AS published_at_49, t0.note AS note_50, t0.is_listing_done AS is_listing_done_51, t0.package_sizes AS package_sizes_52, t0.is_truckload AS is_truckload_53, t0.search_terms AS search_terms_54, t0.created_at AS created_at_55, t0.updated_at AS updated_at_56, t0.supplier_id AS supplier_id_57, t0.warehouse_id AS warehouse_id_58, t0.product_condition_id AS product_condition_id_59, t0.category_id AS category_id_60, t61.id AS id_62, t61.msrp AS msrp_63, t61.price AS price_64, t61.nb_pallets AS nb_pallets_65, t61.nb_gaylords AS nb_gaylords_66, t61.nb_boxes AS nb_boxes_67, t61.number AS number_68, t61.manifest AS manifest_69, t61.manifest_html AS manifest_html_70, t61.is_listing_done AS is_listing_done_71, t61.is_deleted AS is_deleted_72, t61.created_by_id AS created_by_id_73, t61.related_front_product_id AS related_front_product_id_74, t75.id AS id_76, t75.is_basic_step_done AS is_basic_step_done_77, t75.is_image_step_done AS is_image_step_done_78, t75.is_shipping_step_done AS is_shipping_step_done_79, t75.is_marketing_step_done AS is_marketing_step_done_80, t75.front_product_id AS front_product_id_81, t0.created_by_id AS created_by_id_82, t0.published_by_id AS published_by_id_83, t0.created_by_customer_id AS created_by_customer_id_84, t0.original_lot_id AS original_lot_id_85 FROM front_product t0 LEFT JOIN truckload t61 ON t61.related_front_product_id = t0.id LEFT JOIN front_product_listing_progress t75 ON t75.front_product_id = t0.id WHERE t0.sku = ? ORDER BY t0.id DESC LIMIT 1

Parameters:

[
  "102-LK658608"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sku AS sku_3,
  t0.price AS price_4,
  t0.images AS images_5,
  t0.msrp AS msrp_6,
  t0.discount AS discount_7,
  t0.total_units AS total_units_8,
  t0.package_units AS package_units_9,
  t0.package_format AS package_format_10,
  t0.is_cp AS is_cp_11,
  t0.manifest AS manifest_12,
  t0.weight AS weight_13,
  t0.description AS description_14,
  t0.sale_price AS sale_price_15,
  t0.cost_price AS cost_price_16,
  t0.calculated_price AS calculated_price_17,
  t0.quantity_on_hand AS quantity_on_hand_18,
  t0.quantity_pending AS quantity_pending_19,
  t0.quantity_available AS quantity_available_20,
  t0.track_inventory AS track_inventory_21,
  t0.sort_order AS sort_order_22,
  t0.is_visible AS is_visible_23,
  t0.is_allow_purchase AS is_allow_purchase_24,
  t0.product_availability AS product_availability_25,
  t0.minimum_purchase_quantity AS minimum_purchase_quantity_26,
  t0.maximum_purchase_quantity AS maximum_purchase_quantity_27,
  t0.has_free_shipping AS has_free_shipping_28,
  t0.fixed_shipping_price AS fixed_shipping_price_29,
  t0.width AS width_30,
  t0.height AS height_31,
  t0.depth AS depth_32,
  t0.brand AS brand_33,
  t0.warranty AS warranty_34,
  t0.show_product_condition AS show_product_condition_35,
  t0.code AS code_36,
  t0.tax_group AS tax_group_37,
  t0.tax_provider_code AS tax_provider_code_38,
  t0.search_keywords AS search_keywords_39,
  t0.page_title AS page_title_40,
  t0.meta_keywords AS meta_keywords_41,
  t0.meta_description AS meta_description_42,
  t0.slug AS slug_43,
  t0.cost_per_unit AS cost_per_unit_44,
  t0.is_overstock_lot AS is_overstock_lot_45,
  t0.is_add_on_lot AS is_add_on_lot_46,
  t0.is_price_drop AS is_price_drop_47,
  t0.price_dropped_at AS price_dropped_at_48,
  t0.published_at AS published_at_49,
  t0.note AS note_50,
  t0.is_listing_done AS is_listing_done_51,
  t0.package_sizes AS package_sizes_52,
  t0.is_truckload AS is_truckload_53,
  t0.search_terms AS search_terms_54,
  t0.created_at AS created_at_55,
  t0.updated_at AS updated_at_56,
  t0.supplier_id AS supplier_id_57,
  t0.warehouse_id AS warehouse_id_58,
  t0.product_condition_id AS product_condition_id_59,
  t0.category_id AS category_id_60,
  t61.id AS id_62,
  t61.msrp AS msrp_63,
  t61.price AS price_64,
  t61.nb_pallets AS nb_pallets_65,
  t61.nb_gaylords AS nb_gaylords_66,
  t61.nb_boxes AS nb_boxes_67,
  t61.number AS number_68,
  t61.manifest AS manifest_69,
  t61.manifest_html AS manifest_html_70,
  t61.is_listing_done AS is_listing_done_71,
  t61.is_deleted AS is_deleted_72,
  t61.created_by_id AS created_by_id_73,
  t61.related_front_product_id AS related_front_product_id_74,
  t75.id AS id_76,
  t75.is_basic_step_done AS is_basic_step_done_77,
  t75.is_image_step_done AS is_image_step_done_78,
  t75.is_shipping_step_done AS is_shipping_step_done_79,
  t75.is_marketing_step_done AS is_marketing_step_done_80,
  t75.front_product_id AS front_product_id_81,
  t0.created_by_id AS created_by_id_82,
  t0.published_by_id AS published_by_id_83,
  t0.created_by_customer_id AS created_by_customer_id_84,
  t0.original_lot_id AS original_lot_id_85
FROM
  front_product t0
  LEFT JOIN truckload t61 ON t61.related_front_product_id = t0.id
  LEFT JOIN front_product_listing_progress t75 ON t75.front_product_id = t0.id
WHERE
  t0.sku = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.sku AS sku_3, t0.price AS price_4, t0.images AS images_5, t0.msrp AS msrp_6, t0.discount AS discount_7, t0.total_units AS total_units_8, t0.package_units AS package_units_9, t0.package_format AS package_format_10, t0.is_cp AS is_cp_11, t0.manifest AS manifest_12, t0.weight AS weight_13, t0.description AS description_14, t0.sale_price AS sale_price_15, t0.cost_price AS cost_price_16, t0.calculated_price AS calculated_price_17, t0.quantity_on_hand AS quantity_on_hand_18, t0.quantity_pending AS quantity_pending_19, t0.quantity_available AS quantity_available_20, t0.track_inventory AS track_inventory_21, t0.sort_order AS sort_order_22, t0.is_visible AS is_visible_23, t0.is_allow_purchase AS is_allow_purchase_24, t0.product_availability AS product_availability_25, t0.minimum_purchase_quantity AS minimum_purchase_quantity_26, t0.maximum_purchase_quantity AS maximum_purchase_quantity_27, t0.has_free_shipping AS has_free_shipping_28, t0.fixed_shipping_price AS fixed_shipping_price_29, t0.width AS width_30, t0.height AS height_31, t0.depth AS depth_32, t0.brand AS brand_33, t0.warranty AS warranty_34, t0.show_product_condition AS show_product_condition_35, t0.code AS code_36, t0.tax_group AS tax_group_37, t0.tax_provider_code AS tax_provider_code_38, t0.search_keywords AS search_keywords_39, t0.page_title AS page_title_40, t0.meta_keywords AS meta_keywords_41, t0.meta_description AS meta_description_42, t0.slug AS slug_43, t0.cost_per_unit AS cost_per_unit_44, t0.is_overstock_lot AS is_overstock_lot_45, t0.is_add_on_lot AS is_add_on_lot_46, t0.is_price_drop AS is_price_drop_47, t0.price_dropped_at AS price_dropped_at_48, t0.published_at AS published_at_49, t0.note AS note_50, t0.is_listing_done AS is_listing_done_51, t0.package_sizes AS package_sizes_52, t0.is_truckload AS is_truckload_53, t0.search_terms AS search_terms_54, t0.created_at AS created_at_55, t0.updated_at AS updated_at_56, t0.supplier_id AS supplier_id_57, t0.warehouse_id AS warehouse_id_58, t0.product_condition_id AS product_condition_id_59, t0.category_id AS category_id_60, t61.id AS id_62, t61.msrp AS msrp_63, t61.price AS price_64, t61.nb_pallets AS nb_pallets_65, t61.nb_gaylords AS nb_gaylords_66, t61.nb_boxes AS nb_boxes_67, t61.number AS number_68, t61.manifest AS manifest_69, t61.manifest_html AS manifest_html_70, t61.is_listing_done AS is_listing_done_71, t61.is_deleted AS is_deleted_72, t61.created_by_id AS created_by_id_73, t61.related_front_product_id AS related_front_product_id_74, t75.id AS id_76, t75.is_basic_step_done AS is_basic_step_done_77, t75.is_image_step_done AS is_image_step_done_78, t75.is_shipping_step_done AS is_shipping_step_done_79, t75.is_marketing_step_done AS is_marketing_step_done_80, t75.front_product_id AS front_product_id_81, t0.created_by_id AS created_by_id_82, t0.published_by_id AS published_by_id_83, t0.created_by_customer_id AS created_by_customer_id_84, t0.original_lot_id AS original_lot_id_85 FROM front_product t0 LEFT JOIN truckload t61 ON t61.related_front_product_id = t0.id LEFT JOIN front_product_listing_progress t75 ON t75.front_product_id = t0.id WHERE t0.sku = '102-LK658608' ORDER BY t0.id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 187)
4	App\Controller\Front\MainController->paramConverter (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

1.06 ms
(0.03%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_main AS is_main_2, c0_.generic_value AS generic_value_3, c0_.high_value_threshold AS high_value_threshold_4, c0_.is_updated AS is_updated_5, c0_.is_active AS is_active_6, c0_.can_have_cp AS can_have_cp_7, c0_.slug AS slug_8, c0_.is_public AS is_public_9, c0_.generic_high_value AS generic_high_value_10, c0_.newsletter_default_footer_image AS newsletter_default_footer_image_11, c0_.newsletter_default_footer_image_price_drop AS newsletter_default_footer_image_price_drop_12, c0_.has_oversize AS has_oversize_13, c0_.google_id AS google_id_14, c0_.max_quantity_same_lot_item AS max_quantity_same_lot_item_15, c0_.parent_id AS parent_id_16, c0_.scan_category_group_id AS scan_category_group_id_17 FROM category c0_ INNER JOIN category_lang c1_ ON c0_.id = c1_.category_id AND (c1_.language_id = ?) WHERE c1_.slug = ? AND c0_.parent_id IS NULL AND c0_.is_active = 1 AND c0_.is_public = 1

Parameters:

[
  2
  "102-LK658608"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.is_main AS is_main_2,
  c0_.generic_value AS generic_value_3,
  c0_.high_value_threshold AS high_value_threshold_4,
  c0_.is_updated AS is_updated_5,
  c0_.is_active AS is_active_6,
  c0_.can_have_cp AS can_have_cp_7,
  c0_.slug AS slug_8,
  c0_.is_public AS is_public_9,
  c0_.generic_high_value AS generic_high_value_10,
  c0_.newsletter_default_footer_image AS newsletter_default_footer_image_11,
  c0_.newsletter_default_footer_image_price_drop AS newsletter_default_footer_image_price_drop_12,
  c0_.has_oversize AS has_oversize_13,
  c0_.google_id AS google_id_14,
  c0_.max_quantity_same_lot_item AS max_quantity_same_lot_item_15,
  c0_.parent_id AS parent_id_16,
  c0_.scan_category_group_id AS scan_category_group_id_17
FROM
  category c0_
  INNER JOIN category_lang c1_ ON c0_.id = c1_.category_id
  AND (c1_.language_id = ?)
WHERE
  c1_.slug = ?
  AND c0_.parent_id IS NULL
  AND c0_.is_active = 1
  AND c0_.is_public = 1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_main AS is_main_2, c0_.generic_value AS generic_value_3, c0_.high_value_threshold AS high_value_threshold_4, c0_.is_updated AS is_updated_5, c0_.is_active AS is_active_6, c0_.can_have_cp AS can_have_cp_7, c0_.slug AS slug_8, c0_.is_public AS is_public_9, c0_.generic_high_value AS generic_high_value_10, c0_.newsletter_default_footer_image AS newsletter_default_footer_image_11, c0_.newsletter_default_footer_image_price_drop AS newsletter_default_footer_image_price_drop_12, c0_.has_oversize AS has_oversize_13, c0_.google_id AS google_id_14, c0_.max_quantity_same_lot_item AS max_quantity_same_lot_item_15, c0_.parent_id AS parent_id_16, c0_.scan_category_group_id AS scan_category_group_id_17 FROM category c0_ INNER JOIN category_lang c1_ ON c0_.id = c1_.category_id AND (c1_.language_id = 2) WHERE c1_.slug = '102-LK658608' AND c0_.parent_id IS NULL AND c0_.is_active = 1 AND c0_.is_public = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 92)
7	App\Repository\CategoryRepository->findMainCategoryByName (line 175)
8	App\Controller\Front\MainController->paramConverter (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.28 ms
(0.01%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.display_name AS display_name_4, t0.is_active AS is_active_5 FROM language t0 WHERE t0.id = ?

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso_code AS iso_code_3,
  t0.display_name AS display_name_4,
  t0.is_active AS is_active_5
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.display_name AS display_name_4, t0.is_active AS is_active_5 FROM language t0 WHERE t0.id = '2';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 42)
6	App\Services\Front\ContextService->getLanguage (line 172)
7	App\Controller\Front\MainController->paramConverter (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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\Language	No errors.
App\Entity\Front\CountryLang	No errors.
App\Entity\Front\Cart	No errors.
App\Entity\Front\Order	The mappings App\Entity\Front\Order#billingAddress and App\Entity\Front\Address#orders are inconsistent with each other.
App\Entity\Information\ProductConditionLang	No errors.
App\Entity\Front\Customer	The association App\Entity\Front\Customer#orderHistories refers to the owning side field App\Entity\Front\OrderHistory#customer which does not exist.
App\Entity\CategoryLang	No errors.
App\Entity\SupplierLang	No errors.
App\Entity\Front\WebsitePageLang	No errors.
App\Entity\Front\HomepageAlertLang	No errors.
App\Entity\Category	The field 'App\Entity\Category#isUpdated' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Category#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The association App\Entity\Category#mappingCategories refers to the owning side field App\Entity\MappingCategory#mainCategory which does not exist. The mappings App\Entity\Category#lots and App\Entity\Lot#category are inconsistent with each other.
App\Entity\ScanCategoryGroup	The association App\Entity\ScanCategoryGroup#reportPerformanceEntryGroups refers to the owning side field App\Entity\ReportPerformanceEntryGroup#ScanCategoryGroup which does not exist.
App\Entity\Front\FrontProduct	No errors.
App\Entity\Supplier	The field 'App\Entity\Supplier#hasActions' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Supplier#hasValidation' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Supplier#hasHighValue' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Supplier#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Supplier#isDeleted' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Warehouse	The mappings App\Entity\Warehouse#users and App\Entity\User#warehouse are inconsistent with each other.
App\Entity\Information\ProductCondition	The field 'App\Entity\Information\ProductCondition#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Truckload	No errors.
App\Entity\Front\FrontProductListingProgress	No errors.
App\Entity\User	The mappings App\Entity\User#assignedScanManifests and App\Entity\ScanManifestUser#user are inconsistent with each other. The association App\Entity\User#analysedProducts refers to the owning side field App\Entity\Product#analysedBy which does not exist. The association App\Entity\User#analyzedManifestItems refers to the owning side field App\Entity\ManifestItem#analysedBy which does not exist. The association App\Entity\User#warehouse refers to the inverse side field App\Entity\Warehouse#userss which does not exist. The mappings App\Entity\User#userMainTableSettings and App\Entity\UserMainTableSetting#user are inconsistent with each other.
App\Entity\Lot	The field 'App\Entity\Lot#isHighValue' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Lot#isCp' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The association App\Entity\Lot#po refers to the inverse side field App\Entity\Po#numbers which does not exist. The association App\Entity\Lot#category refers to the inverse side field App\Entity\Category#isHighValue which does not exist. The field App\Entity\Lot#triageScans is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TriageScan#lot does not contain the required 'inversedBy="triageScans"' attribute.
App\Entity\Front\CartProduct	No errors.
App\Entity\Front\FrontProductImage	No errors.
App\Entity\Front\OrderFrontProduct	No errors.
App\Entity\Front\WhishListItem	No errors.
App\Entity\TruckloadFrontProduct	No errors.
App\Entity\StockUpdate	No errors.
App\Entity\StockLocation	No errors.
App\Entity\TruckloadIncludedFrontProduct	No errors.
App\Entity\StockLocationUpdate	No errors.
App\Entity\Front\Country	No errors.
App\Entity\Front\ShippingMode	The association App\Entity\Front\ShippingMode#taxRuleGroup refers to the inverse side field App\Entity\Front\TaxRuleGroup#shippingModes which does not exist.
App\Entity\Front\Address	The field App\Entity\Front\Address#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Front\Order#shippingAddress does not contain the required 'inversedBy="orders"' attribute.
App\Entity\Front\State	No errors.
App\Entity\Front\CartShippingMode	No errors.
App\Entity\Front\CartDiscount	No errors.
App\Entity\Front\OrderShippingTax	No errors.
App\Entity\Front\OrderStatus	The field 'App\Entity\Front\OrderStatus#invoice' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Front\OrderStatus#sendEmail' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Front\OrderStatus#isLogable' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Front\OrderStatus#isDeleted' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Front\OrderHistory	No errors.
App\Entity\Front\OrderPaymentIntent	No errors.
App\Entity\Front\OrderPayment	No errors.
App\Entity\Front\OrderDiscount	No errors.
App\Entity\Front\OrderDiscountTax	No errors.
App\Entity\Front\TaxRuleGroup	The field 'App\Entity\Front\TaxRuleGroup#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\Front\TaxRuleGroup#isDeleted' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Front\OrderFrontProductTax	No errors.
App\Entity\Front\OrderRefund	No errors.
App\Entity\Front\OrderCategoryDiscount	No errors.
App\Entity\Front\CustomerGroup	No errors.
App\Entity\Front\WebsitePage	No errors.
App\Entity\Front\HomepageAlert	No errors.
App\Entity\Product	The mappings App\Entity\Product#analyzedBy and App\Entity\User#analysedProducts are inconsistent with each other.
App\Entity\ProductConditionDiscount	No errors.
App\Entity\MappingCategory	The field 'App\Entity\MappingCategory#isUnmapped' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\CategoryAction	No errors.
App\Entity\SupplierProductConditionDiscount	No errors.
App\Entity\SupplierCategoryValue	No errors.
App\Entity\Newsletter	No errors.
App\Entity\ReportStockRotationEntry	No errors.
App\Entity\TriageScan	No errors.
App\Entity\ScanSession	No errors.
App\Entity\ReportScanGroup	No errors.
App\Entity\ReportPerformanceEntryGroup	The mappings App\Entity\ReportPerformanceEntryGroup#scanCategoryGroup and App\Entity\ScanCategoryGroup#reportPerformanceEntryGroups are inconsistent with each other.
App\Entity\Po	The mappings App\Entity\Po#lots and App\Entity\Lot#po are inconsistent with each other. The mappings App\Entity\Po#manifestItems and App\Entity\ManifestItem#po are inconsistent with each other.
App\Entity\MerchantSku	No errors.
App\Entity\ProductAction	No errors.
App\Entity\SpecialMerchantSku	No errors.
App\Entity\SpecialMsrp	No errors.
App\Entity\InvoiceCustomsData	No errors.
App\Entity\SpecialUpc	No errors.
App\Entity\SpecialName	No errors.
App\Entity\ReportPerformance	No errors.
App\Entity\DataImport	No errors.
App\Entity\UserGroup	No errors.
App\Entity\Front\WarehouseShippingMode	No errors.
App\Entity\Location	No errors.
App\Entity\PreparationLot	The field 'App\Entity\PreparationLot#isEmpty' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type. The field 'App\Entity\PreparationLot#isAction' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Module	No errors.
App\Entity\ScanManifestUser	The association App\Entity\ScanManifestUser#user refers to the inverse side field App\Entity\User#scanManifestUsers which does not exist.
App\Entity\ManifestItem	The association App\Entity\ManifestItem#po refers to the inverse side field App\Entity\Po#ManifestItems which does not exist. The mappings App\Entity\ManifestItem#analyzedBy and App\Entity\User#analyzedManifestItems are inconsistent with each other.
App\Entity\TriageUser	The field 'App\Entity\TriageUser#active' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\ProductUpdateLog	No errors.
App\Entity\UserMainTableSetting	The association App\Entity\UserMainTableSetting#user refers to the inverse side field App\Entity\User#userDashboardSettings which does not exist.
App\Entity\LotItem	No errors.
App\Entity\TruckloadLot	The field 'App\Entity\TruckloadLot#isCp' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\LotPhoto	No errors.
App\Entity\CombinedManifestLot	No errors.
App\Entity\UploadedPhoto	No errors.

Symfony Profiler

GET https://www.rsystprojectwebsite.com/102-LK658608/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping