http://poooshe.com/

Query Metrics

8 Database Queries
7 Different statements
93.42 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
18.53 ms
(19.84%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.stock AS stock_9, t0.name AS name_10, t0.description AS description_11, t0.price AS price_12, t0.image_url AS image_url_13, t0.sub_name AS sub_name_14, t0.is_selling AS is_selling_15, t0.shop_id AS shop_id_16 FROM product t0
Parameters:
[]
18.37 ms
(19.66%)
2
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.name AS name_9, t0.price_per_unit AS price_per_unit_10, t0.unit AS unit_11, t0.price_per_extra_unit AS price_per_extra_unit_12, t0.value_type AS value_type_13, t0.feature_key AS feature_key_14, t0.details AS details_15 FROM feature t0 WHERE t0.active = ? AND t0.value_type = ?
Parameters:
[
  1
  "activable"
]
18.15 ms
(19.43%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.name AS name_9, t0.subdomain AS subdomain_10, t0.shop_balance AS shop_balance_11, t0.theme AS theme_12, t0.analytics_data AS analytics_data_13, t0.expired_at AS expired_at_14, t0.traffic_usage AS traffic_usage_15, t0.plan_started_at AS plan_started_at_16, t0.owner_id AS owner_id_17, t0.current_plan_id AS current_plan_id_18 FROM shop t0
Parameters:
[]
9.78 ms
(10.47%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.value AS value_9, t0.price_of_this_unit AS price_of_this_unit_10, t0.plan_id AS plan_id_11, t0.feature_id AS feature_id_12 FROM plan_feature t0 WHERE t0.plan_id = ?
Parameters:
[
  "1f060c7a-658f-60be-a93e-07673e88171a"
]
9.74 ms
(10.43%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.title AS title_9, t0.days AS days_10, t0.is_systematic AS is_systematic_11, t0.is_trial AS is_trial_12, t0.price AS price_13, t0.free_ir_domain AS free_ir_domain_14 FROM plan t0 WHERE t0.active = ? AND t0.is_trial = ? AND t0.is_systematic = ? ORDER BY t0.price ASC LIMIT 1
Parameters:
[
  1
  0
  1
]
9.68 ms
(10.36%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.name AS name_9, t0.price_per_unit AS price_per_unit_10, t0.unit AS unit_11, t0.price_per_extra_unit AS price_per_extra_unit_12, t0.value_type AS value_type_13, t0.feature_key AS feature_key_14, t0.details AS details_15 FROM feature t0 WHERE t0.active = ?
Parameters:
[
  1
]
9.16 ms
(9.81%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.url_slug AS url_slug_5, t0.og_description AS og_description_6, t0.active AS active_7, t0.id AS id_8, t0.is_connected AS is_connected_9, t0.address AS address_10, t0.ns1 AS ns1_11, t0.ns2 AS ns2_12, t0.valid_until AS valid_until_13, t0.shop_id AS shop_id_14 FROM domain t0 WHERE t0.address = ? LIMIT 1
Parameters:
[
  "poooshe.com"
]

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\BaseEntity No errors.
App\Entity\BaseSite\Plan\Plan No errors.
App\Entity\Shop\Shop\Shop No errors.
App\Entity\BaseSite\Plan\PlanFeature No errors.
App\Entity\BaseSite\Plan\AddOn No errors.
App\Entity\BaseSite\Domain No errors.
App\Entity\Shop\Setting No errors.
App\Entity\BaseSite\Plan\Feature No errors.
App\Entity\Generic\User
  • The field 'App\Entity\Generic\User#wallet' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Generic\Customer\Customer No errors.
App\Entity\Shop\Product\Product No errors.
App\Entity\Shop\Product\ProductAttribute No errors.
App\Entity\Shop\Product\ProductAttributeValue No errors.
App\Entity\Shop\Order\Discount No errors.
App\Entity\Shop\Cart\Cart No errors.
App\Entity\Shop\Cart\CartItem No errors.
App\Entity\Shop\Cart\CartItemAttribute No errors.
App\Entity\Shop\Order\Coupon No errors.
App\Entity\Shop\Order\Order No errors.
App\Entity\Shop\Order\ShippingMethod No errors.
App\Entity\Shop\Product\ProductCategory No errors.
App\Entity\Shop\PostType\PostType No errors.
App\Entity\Shop\Menu\Menu No errors.
App\Entity\Shop\Page\Page No errors.
App\Entity\Shop\Blog\Article No errors.
App\Entity\Shop\Blog\Category No errors.
App\Entity\Shop\Blog\Tag No errors.
App\Entity\Shop\Ticket\Ticket No errors.
App\Entity\Shop\Accounting\Transaction No errors.
App\Entity\Shop\Product\ProductPrice No errors.
App\Entity\Shop\Product\ProductImage No errors.
App\Entity\Shop\Order\OrderItem No errors.
App\Entity\Shop\Shop\Review No errors.
App\Entity\Shop\Product\ProductTag No errors.
App\Entity\Shop\Product\ProductReview No errors.