GET http://back-office.dev-project-server.com/product/goldstreet---klondike-circle-l-mine-930H

Query Metrics

13 Database Queries
7 Different statements
1.61 ms Query time
8 Invalid entities
15 Managed entities

Queries

Group similar statements

# Time Info
1 0.41 ms
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"
]
2 0.13 ms
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:
[
  "payple"
]
3 0.23 ms
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.short_description AS short_description_6, t0.regular_price AS regular_price_7, t0.sale_price AS sale_price_8, t0.status AS status_9, t0.role AS role_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.product_url AS product_url_14, t0.stripe_product_id AS stripe_product_id_15, t0.paypal_product_id AS paypal_product_id_16, t0.trials_day AS trials_day_17, t0.has_trials AS has_trials_18, t0.wordpress_product_id AS wordpress_product_id_19, t0.eldorado_product_id AS eldorado_product_id_20, t0.migrate_data AS migrate_data_21, t0.mapping_product_id AS mapping_product_id_22, t0.images AS images_23, t0.display_product_name AS display_product_name_24, t0.category_id AS category_id_25 FROM products t0 WHERE t0.sku = ? LIMIT 1
Parameters:
[
  "goldstreet---klondike-circle-l-mine-930H"
]
4 0.29 ms
SELECT t0.id AS id_1, t0.duration_month AS duration_month_2, t0.discount AS discount_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.note AS note_7, t0.stripe_price_id AS stripe_price_id_8, t0.paypal_price_id AS paypal_price_id_9, t0.wordpress_variation_id AS wordpress_variation_id_10, t0.migrate_data AS migrate_data_11, t0.product_id_id AS product_id_id_12 FROM subscription_duration t0 WHERE t0.product_id_id = ? AND t0.deleted_at IS NULL
Parameters:
[
  139
]
5 0.06 ms
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
Parameters:
[]
6 0.07 ms
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:
[]
7 0.06 ms
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:
[]
8 0.05 ms
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:
[]
9 0.05 ms
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:
[]
10 0.05 ms
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:
[]
11 0.05 ms
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.id = ?
Parameters:
[
  2
]
12 0.08 ms
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:
[]
13 0.06 ms
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\MenuSetting 10
App\Entity\PaymentSetting 2
App\Entity\Products 1
App\Entity\Category 1
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.