GET http://back-office.dev-project-server.com/shop/product

Query Metrics

11 Database Queries
5 Different statements
2.75 ms Query time
8 Invalid entities
38 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.67 ms
(60.84%)
1
SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.name AS name_2, p0_.slug AS slug_3, p0_.description AS description_4, p0_.short_description AS short_description_5, p0_.regular_price AS regular_price_6, p0_.sale_price AS sale_price_7, p0_.status AS status_8, p0_.role AS role_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.deleted_at AS deleted_at_12, p0_.product_url AS product_url_13, p0_.stripe_product_id AS stripe_product_id_14, p0_.paypal_product_id AS paypal_product_id_15, p0_.trials_day AS trials_day_16, p0_.has_trials AS has_trials_17, p0_.wordpress_product_id AS wordpress_product_id_18, p0_.eldorado_product_id AS eldorado_product_id_19, p0_.migrate_data AS migrate_data_20, p0_.mapping_product_id AS mapping_product_id_21, p0_.images AS images_22, p0_.display_product_name AS display_product_name_23, p0_.category_id AS category_id_24 FROM products p0_ WHERE p0_.status = ? AND p0_.deleted_at IS NULL
Parameters:
[
  1
]
0.51 ms
(18.68%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.wordpress_category_id AS wordpress_category_id_9, t0.migrate_date AS migrate_date_10 FROM category t0 WHERE t0.status = ? AND t0.deleted_at IS NULL
Parameters:
[
  1
]
0.25 ms
(9.09%)
2
SELECT t0.id AS id_1, t0.payment_type AS payment_type_2, t0.coins AS coins_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.test_public_key AS test_public_key_7, t0.test_secret_key AS test_secret_key_8, t0.live_public_key AS live_public_key_9, t0.live_sectret_key AS live_sectret_key_10, t0.merchant_key AS merchant_key_11, t0.ipn_key AS ipn_key_12, t0.status AS status_13, t0.payment_type_name AS payment_type_name_14, t0.payment_mode AS payment_mode_15, t0.payment_method AS payment_method_16, t0.test_client_id AS test_client_id_17, t0.live_client_id AS live_client_id_18 FROM payment_setting t0 WHERE t0.payment_type = ? LIMIT 1
Parameters:
[
  "stripe"
]
0.16 ms
(5.90%)
4
SELECT t0.id AS id_1, t0.site_logo AS site_logo_2, t0.re_captcha_site_key AS re_captcha_site_key_3, t0.re_captcha_site_secret AS re_captcha_site_secret_4, t0.re_captcha_lang AS re_captcha_lang_5, t0.re_captcha_faild_msg AS re_captcha_faild_msg_6, t0.eldorado_point AS eldorado_point_7, t0.eldorado_token AS eldorado_token_8, t0.eldorado_category AS eldorado_category_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM settings t0 LIMIT 1
Parameters:
[]
0.15 ms
(5.49%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.is_active AS is_active_4, t0.is_main_nav AS is_main_nav_5, t0.is_public_nav AS is_public_nav_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM menu_setting t0
Parameters:
[]

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\Products 23
App\Entity\MenuSetting 10
App\Entity\PaymentSetting 2
App\Entity\Category 2
App\Entity\Settings 1

Entities Mapping

Class Mapping errors
App\Entity\Users
  • The mappings App\Entity\Users#referral and App\Entity\UsersCustomers#referral are inconsistent with each other.
  • The association App\Entity\Users#customer refers to the owning side field App\Entity\UsersCustomers#customer_id which does not exist.
  • The association App\Entity\Users#userCustomerCommissions refers to the owning side field App\Entity\UserCommission#customer_id which does not exist.
  • The field App\Entity\Users#wallet is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Wallet#user does not contain the required 'inversedBy="wallet"' attribute.
App\Entity\PaymentSetting
  • The association App\Entity\PaymentSetting#walletSettings refers to the owning side field App\Entity\WalletSetting#wallet_payment_id which does not exist.
App\Entity\WalletSetting
  • The mappings App\Entity\WalletSetting#wallet_payment and App\Entity\PaymentSetting#walletSettings are inconsistent with each other.
App\Entity\Products
  • The mappings App\Entity\Products#category and App\Entity\Category#products are inconsistent with each other.
  • The association App\Entity\Products#userCommissions refers to the owning side field App\Entity\UserCommission#Product_id which does not exist.
  • The mappings App\Entity\Products#product and App\Entity\UsersCustomers#product are inconsistent with each other.
App\Entity\Category
  • The association App\Entity\Category#products refers to the owning side field App\Entity\Products#category_id which does not exist.
App\Entity\SubscriptionDuration No errors.
App\Entity\Orders
  • The mappings App\Entity\Orders#affiliateId and App\Entity\Users#orders are inconsistent with each other.
  • The field App\Entity\Orders#invoices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Invoice#invoiceOrder does not contain the required 'inversedBy="invoices"' attribute.
App\Entity\UserCommission
  • The mappings App\Entity\UserCommission#customer and App\Entity\Users#userCustomerCommissions are inconsistent with each other.
  • The mappings App\Entity\UserCommission#product and App\Entity\Products#userCommissions are inconsistent with each other.
App\Entity\UsersCustomers
  • The association App\Entity\UsersCustomers#referral refers to the inverse side field App\Entity\Users#userCustomers which does not exist.
  • The association App\Entity\UsersCustomers#product refers to the inverse side field App\Entity\Products#userCustomers which does not exist.
  • The association App\Entity\UsersCustomers#customer refers to the inverse side field App\Entity\Users#userCustomers which does not exist.
  • The association App\Entity\UsersCustomers#currency refers to the inverse side field App\Entity\Payments#userCustomers which does not exist.
App\Entity\Settings No errors.
App\Entity\MenuSetting No errors.