http://default.poooshe.com/product/slug-68b88e7b5955d72057353

Query Metrics

129 Database Queries
18 Different statements
1966.14 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
703.06 ms
(35.76%)
52
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 website t0 WHERE t0.subdomain = ? LIMIT 1
Parameters:
[
  "default"
]
513.77 ms
(26.13%)
38
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.value AS value_10, t0.website_id AS website_id_11 FROM `shop_setting` t0 WHERE t0.name = ? AND t0.website_id = ? LIMIT 1
Parameters:
[
  "seo_general_siteName"
  "1f08677f-ceae-6d44-99f4-1f13608c82a4"
]
228.74 ms
(11.63%)
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.image_url AS image_url_9, t0.product_id AS product_id_10 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
  "1f088f72-c846-66e4-a1be-8322abf83007"
]
214.24 ms
(10.90%)
16
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.label AS label_9, t0.url AS url_10, t0.menu_item_order AS menu_item_order_11, t0.type AS type_12, t0.target AS target_13, t0.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
  "1f088f72-cbda-6fa8-93d7-8322abf83007"
]
68.40 ms
(3.48%)
5
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.position AS position_9, t0.title AS title_10, t0.website_id AS website_id_11 FROM menu t0 WHERE t0.position = ? AND t0.active = ? AND t0.website_id = ? LIMIT 1
Parameters:
[
  "headerMenu"
  1
  "1f08677f-ceae-6d44-99f4-1f13608c82a4"
]
58.13 ms
(2.96%)
4
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.label AS label_9, t0.url AS url_10, t0.menu_item_order AS menu_item_order_11, t0.type AS type_12, t0.target AS target_13, t0.menu_id AS menu_id_14, t0.parent_id AS parent_id_15 FROM menu_item t0 WHERE t0.menu_id = ?
Parameters:
[
  "1f088f72-cbda-697c-9a56-8322abf83007"
]
26.53 ms
(1.35%)
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.code AS code_10 FROM order_status t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "cart"
]
14.89 ms
(0.76%)
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.description AS description_10, t0.image_url AS image_url_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.meta_keywords AS meta_keywords_14, t0.canonical_url AS canonical_url_15, t0.robots AS robots_16, t0.og_title AS og_title_17, t0.og_image_path AS og_image_path_18, t0.twitter_card_type AS twitter_card_type_19, t0.extra_seo_data AS extra_seo_data_20, t0.website_id AS website_id_21, t0.parent_id AS parent_id_22 FROM product_category t0 INNER JOIN product_category_product ON t0.id = product_category_product.product_category_id WHERE product_category_product.product_id = ?
Parameters:
[
  "1f088f72-c846-66e4-a1be-8322abf83007"
]
14.81 ms
(0.75%)
1
SELECT p0_.created_at AS created_at_0, p0_.updated_at AS updated_at_1, p0_.deleted_at AS deleted_at_2, p0_.uuid AS uuid_3, p0_.url_slug AS url_slug_4, p0_.og_description AS og_description_5, p0_.active AS active_6, p0_.id AS id_7, p0_.name AS name_8, p0_.description AS description_9, p0_.image_url AS image_url_10, p0_.meta_title AS meta_title_11, p0_.meta_description AS meta_description_12, p0_.meta_keywords AS meta_keywords_13, p0_.canonical_url AS canonical_url_14, p0_.robots AS robots_15, p0_.og_title AS og_title_16, p0_.og_image_path AS og_image_path_17, p0_.twitter_card_type AS twitter_card_type_18, p0_.extra_seo_data AS extra_seo_data_19, p0_.website_id AS website_id_20 FROM product_tag p0_ LEFT JOIN website w1_ ON p0_.website_id = w1_.id LEFT JOIN product_tag_product p3_ ON p0_.id = p3_.product_tag_id LEFT JOIN product p2_ ON p2_.id = p3_.product_id WHERE w1_.id = ? AND p2_.id = ? AND p0_.active = 1
Parameters:
[
  "1f08677f-ceae-6d44-99f4-1f13608c82a4"
  "1f088f72-c846-66e4-a1be-8322abf83007"
]
14.41 ms
(0.73%)
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.product_id AS product_id_10, t0.website_id AS website_id_11 FROM product_attribute t0 WHERE t0.product_id = ?
Parameters:
[
  "1f088f72-c846-66e4-a1be-8322abf83007"
]
14.17 ms
(0.72%)
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.publish_status AS publish_status_16, t0.sku AS sku_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.canonical_url AS canonical_url_21, t0.robots AS robots_22, t0.og_title AS og_title_23, t0.og_image_path AS og_image_path_24, t0.twitter_card_type AS twitter_card_type_25, t0.extra_seo_data AS extra_seo_data_26, t0.website_id AS website_id_27 FROM product t0 WHERE t0.url_slug = ? LIMIT 1
Parameters:
[
  "slug-68b88e7b5955d72057353"
]
13.80 ms
(0.70%)
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.in_stock AS in_stock_9, t0.price AS price_10, t0.product_id AS product_id_11 FROM product_price t0 WHERE t0.product_id = ?
Parameters:
[
  "1f088f72-c846-66e4-a1be-8322abf83007"
]
13.77 ms
(0.70%)
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.in_stock AS in_stock_9, t0.price AS price_10, t0.product_id AS product_id_11 FROM product_price t0 WHERE t0.product_id = ? ORDER BY t0.price ASC LIMIT 1
Parameters:
[
  "1f088f72-c846-66e4-a1be-8322abf83007"
]
13.71 ms
(0.70%)
1
SELECT p0_.created_at AS created_at_0, p0_.updated_at AS updated_at_1, p0_.deleted_at AS deleted_at_2, p0_.uuid AS uuid_3, p0_.url_slug AS url_slug_4, p0_.og_description AS og_description_5, p0_.active AS active_6, p0_.id AS id_7, p0_.stock AS stock_8, p0_.name AS name_9, p0_.description AS description_10, p0_.price AS price_11, p0_.image_url AS image_url_12, p0_.sub_name AS sub_name_13, p0_.is_selling AS is_selling_14, p0_.publish_status AS publish_status_15, p0_.sku AS sku_16, p0_.meta_title AS meta_title_17, p0_.meta_description AS meta_description_18, p0_.meta_keywords AS meta_keywords_19, p0_.canonical_url AS canonical_url_20, p0_.robots AS robots_21, p0_.og_title AS og_title_22, p0_.og_image_path AS og_image_path_23, p0_.twitter_card_type AS twitter_card_type_24, p0_.extra_seo_data AS extra_seo_data_25, p0_.website_id AS website_id_26 FROM product p0_ INNER JOIN product_tag_product p2_ ON p0_.id = p2_.product_id INNER JOIN product_tag p1_ ON p1_.id = p2_.product_tag_id WHERE p1_.id IN (NULL) AND p0_.active = 1 AND p0_.deleted_at IS NULL AND p0_.id <> ?
Parameters:
[
  "1f088f72-c846-66e4-a1be-8322abf83007"
]
13.67 ms
(0.70%)
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.shipping_cost AS shipping_cost_9, t0.tax_amount AS tax_amount_10, t0.total_price AS total_price_11, t0.tracking_code AS tracking_code_12, t0.payment_gateway AS payment_gateway_13, t0.note AS note_14, t0.paid_at AS paid_at_15, t0.is_paid AS is_paid_16, t0.customer_id AS customer_id_17, t0.status_id AS status_id_18, t0.shipping_method_id AS shipping_method_id_19, t0.website_id AS website_id_20, t0.coupon_id AS coupon_id_21, t0.address_id AS address_id_22 FROM `order` t0 WHERE t0.customer_id IS NULL AND t0.active = ? AND t0.deleted_at IS NULL AND t0.status_id = ? LIMIT 1
Parameters:
[
  1
  "1f080ffa-370c-67e8-bb49-774dac25365e"
]
13.61 ms
(0.69%)
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.content AS content_9, t0.pros AS pros_10, t0.cons AS cons_11, t0.rating AS rating_12, t0.recommend AS recommend_13, t0.approved AS approved_14, t0.product_id AS product_id_15, t0.author_id AS author_id_16 FROM product_review t0 WHERE t0.product_id = ? AND t0.approved = ? ORDER BY t0.created_at DESC
Parameters:
[
  "1f088f72-c846-66e4-a1be-8322abf83007"
  1
]
13.54 ms
(0.69%)
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.shipping_cost AS shipping_cost_9, t0.tax_amount AS tax_amount_10, t0.total_price AS total_price_11, t0.tracking_code AS tracking_code_12, t0.payment_gateway AS payment_gateway_13, t0.note AS note_14, t0.paid_at AS paid_at_15, t0.is_paid AS is_paid_16, t0.customer_id AS customer_id_17, t0.status_id AS status_id_18, t0.shipping_method_id AS shipping_method_id_19, t0.website_id AS website_id_20, t0.coupon_id AS coupon_id_21, t0.address_id AS address_id_22 FROM `order` t0 WHERE t0.customer_id IS NULL AND t0.status_id = ? AND t0.active = ? AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[
  "1f080ffa-370c-67e8-bb49-774dac25365e"
  1
]
12.87 ms
(0.65%)
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.in_stock AS in_stock_9, t0.price AS price_10, t0.product_id AS product_id_11 FROM product_price t0 WHERE t0.active = ? AND t0.product_id = ?
Parameters:
[
  1
  "1f088f72-c846-66e4-a1be-8322abf83007"
]

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\Website\Website\Website No errors.
App\Entity\Generic\User No errors.
App\Entity\BaseSite\Plan\Plan No errors.
App\Entity\Generic\Customer\Customer No errors.
App\Entity\Website\Product\Product No errors.
App\Entity\Website\Product\ProductAttribute No errors.
App\Entity\Website\Product\ProductAttributeValue No errors.
App\Entity\Website\Order\Discount No errors.
App\Entity\Website\Cart\Cart No errors.
App\Entity\Website\Cart\CartItem No errors.
App\Entity\Website\Cart\CartItemAttribute No errors.
App\Entity\Website\Order\Coupon No errors.
App\Entity\Website\Order\Order No errors.
App\Entity\Website\Order\ShippingMethod No errors.
App\Entity\Website\Product\ProductCategory No errors.
App\Entity\Website\PostType\PostType No errors.
App\Entity\Website\Menu\Menu No errors.
App\Entity\Website\Setting No errors.
App\Entity\Website\Page\Page No errors.
App\Entity\Website\Blog\Article No errors.
App\Entity\Website\Blog\Category No errors.
App\Entity\Website\Blog\Tag No errors.
App\Entity\Website\Ticket\Ticket No errors.
App\Entity\Website\Accounting\Transaction No errors.
App\Entity\BaseSite\Domain No errors.
App\Entity\BaseSite\Plan\AddOn No errors.
App\Entity\MarketingPanel\SmsTemplate No errors.
App\Entity\Website\Product\ProductPrice No errors.
App\Entity\Website\Product\ProductImage No errors.
App\Entity\Website\Order\OrderItem No errors.
App\Entity\Website\Website\Review No errors.
App\Entity\Website\Product\ProductTag No errors.
App\Entity\Website\Product\ProductReview No errors.
App\Entity\Website\Order\OrderStatus No errors.
App\Entity\Generic\Customer\Address No errors.
App\Entity\Website\Menu\MenuItem No errors.