https://maketou-ht.com/cart

Query Metrics

13 Database Queries
3 Different statements
3.97 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.95 ms
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.total_amount AS total_amount_3, t0.item_count AS item_count_4, t0.last_activity AS last_activity_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM `cart` t0 WHERE t0.session_id = ? AND t0.is_active = ? AND t0.user_id IS NULL LIMIT 1
Parameters:
[
  ""
  1
]
2 0.60 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.unit_price AS unit_price_3, t0.total_price AS total_price_4, t0.added_at AS added_at_5, t0.cart_id AS cart_id_6, t0.product_id AS product_id_7 FROM `cart_item` t0 WHERE t0.cart_id = ?
Parameters:
[
  6
]
3 0.27 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.sku AS sku_3, t0.barcode AS barcode_4, t0.description AS description_5, t0.images AS images_6, t0.videos AS videos_7, t0.documents AS documents_8, t0.price AS price_9, t0.compare_at_price AS compare_at_price_10, t0.stock AS stock_11, t0.min_stock_alert AS min_stock_alert_12, t0.manage_stock AS manage_stock_13, t0.allow_backorders AS allow_backorders_14, t0.stock_status AS stock_status_15, t0.weight AS weight_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.is_digital AS is_digital_20, t0.digital_file AS digital_file_21, t0.attributes AS attributes_22, t0.variations AS variations_23, t0.is_active AS is_active_24, t0.is_featured AS is_featured_25, t0.published_at AS published_at_26, t0.available_from AS available_from_27, t0.available_to AS available_to_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30, t0.meta_keywords AS meta_keywords_31, t0.view_count AS view_count_32, t0.sales_count AS sales_count_33, t0.average_rating AS average_rating_34, t0.review_count AS review_count_35, t0.tier_prices AS tier_prices_36, t0.has_tier_pricing AS has_tier_pricing_37, t0.name AS name_38, t0.shop_id AS shop_id_39, t0.category_id AS category_id_40, t0.brand_id AS brand_id_41, t0.condition_id AS condition_id_42 FROM product t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.25 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.sku AS sku_3, t0.barcode AS barcode_4, t0.description AS description_5, t0.images AS images_6, t0.videos AS videos_7, t0.documents AS documents_8, t0.price AS price_9, t0.compare_at_price AS compare_at_price_10, t0.stock AS stock_11, t0.min_stock_alert AS min_stock_alert_12, t0.manage_stock AS manage_stock_13, t0.allow_backorders AS allow_backorders_14, t0.stock_status AS stock_status_15, t0.weight AS weight_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.is_digital AS is_digital_20, t0.digital_file AS digital_file_21, t0.attributes AS attributes_22, t0.variations AS variations_23, t0.is_active AS is_active_24, t0.is_featured AS is_featured_25, t0.published_at AS published_at_26, t0.available_from AS available_from_27, t0.available_to AS available_to_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30, t0.meta_keywords AS meta_keywords_31, t0.view_count AS view_count_32, t0.sales_count AS sales_count_33, t0.average_rating AS average_rating_34, t0.review_count AS review_count_35, t0.tier_prices AS tier_prices_36, t0.has_tier_pricing AS has_tier_pricing_37, t0.name AS name_38, t0.shop_id AS shop_id_39, t0.category_id AS category_id_40, t0.brand_id AS brand_id_41, t0.condition_id AS condition_id_42 FROM product t0 WHERE t0.id = ?
Parameters:
[
  6
]
5 0.24 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.sku AS sku_3, t0.barcode AS barcode_4, t0.description AS description_5, t0.images AS images_6, t0.videos AS videos_7, t0.documents AS documents_8, t0.price AS price_9, t0.compare_at_price AS compare_at_price_10, t0.stock AS stock_11, t0.min_stock_alert AS min_stock_alert_12, t0.manage_stock AS manage_stock_13, t0.allow_backorders AS allow_backorders_14, t0.stock_status AS stock_status_15, t0.weight AS weight_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.is_digital AS is_digital_20, t0.digital_file AS digital_file_21, t0.attributes AS attributes_22, t0.variations AS variations_23, t0.is_active AS is_active_24, t0.is_featured AS is_featured_25, t0.published_at AS published_at_26, t0.available_from AS available_from_27, t0.available_to AS available_to_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30, t0.meta_keywords AS meta_keywords_31, t0.view_count AS view_count_32, t0.sales_count AS sales_count_33, t0.average_rating AS average_rating_34, t0.review_count AS review_count_35, t0.tier_prices AS tier_prices_36, t0.has_tier_pricing AS has_tier_pricing_37, t0.name AS name_38, t0.shop_id AS shop_id_39, t0.category_id AS category_id_40, t0.brand_id AS brand_id_41, t0.condition_id AS condition_id_42 FROM product t0 WHERE t0.id = ?
Parameters:
[
  5
]
6 0.22 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.sku AS sku_3, t0.barcode AS barcode_4, t0.description AS description_5, t0.images AS images_6, t0.videos AS videos_7, t0.documents AS documents_8, t0.price AS price_9, t0.compare_at_price AS compare_at_price_10, t0.stock AS stock_11, t0.min_stock_alert AS min_stock_alert_12, t0.manage_stock AS manage_stock_13, t0.allow_backorders AS allow_backorders_14, t0.stock_status AS stock_status_15, t0.weight AS weight_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.is_digital AS is_digital_20, t0.digital_file AS digital_file_21, t0.attributes AS attributes_22, t0.variations AS variations_23, t0.is_active AS is_active_24, t0.is_featured AS is_featured_25, t0.published_at AS published_at_26, t0.available_from AS available_from_27, t0.available_to AS available_to_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30, t0.meta_keywords AS meta_keywords_31, t0.view_count AS view_count_32, t0.sales_count AS sales_count_33, t0.average_rating AS average_rating_34, t0.review_count AS review_count_35, t0.tier_prices AS tier_prices_36, t0.has_tier_pricing AS has_tier_pricing_37, t0.name AS name_38, t0.shop_id AS shop_id_39, t0.category_id AS category_id_40, t0.brand_id AS brand_id_41, t0.condition_id AS condition_id_42 FROM product t0 WHERE t0.id = ?
Parameters:
[
  28
]
7 0.20 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.sku AS sku_3, t0.barcode AS barcode_4, t0.description AS description_5, t0.images AS images_6, t0.videos AS videos_7, t0.documents AS documents_8, t0.price AS price_9, t0.compare_at_price AS compare_at_price_10, t0.stock AS stock_11, t0.min_stock_alert AS min_stock_alert_12, t0.manage_stock AS manage_stock_13, t0.allow_backorders AS allow_backorders_14, t0.stock_status AS stock_status_15, t0.weight AS weight_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.is_digital AS is_digital_20, t0.digital_file AS digital_file_21, t0.attributes AS attributes_22, t0.variations AS variations_23, t0.is_active AS is_active_24, t0.is_featured AS is_featured_25, t0.published_at AS published_at_26, t0.available_from AS available_from_27, t0.available_to AS available_to_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30, t0.meta_keywords AS meta_keywords_31, t0.view_count AS view_count_32, t0.sales_count AS sales_count_33, t0.average_rating AS average_rating_34, t0.review_count AS review_count_35, t0.tier_prices AS tier_prices_36, t0.has_tier_pricing AS has_tier_pricing_37, t0.name AS name_38, t0.shop_id AS shop_id_39, t0.category_id AS category_id_40, t0.brand_id AS brand_id_41, t0.condition_id AS condition_id_42 FROM product t0 WHERE t0.id = ?
Parameters:
[
  13
]
8 0.21 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.sku AS sku_3, t0.barcode AS barcode_4, t0.description AS description_5, t0.images AS images_6, t0.videos AS videos_7, t0.documents AS documents_8, t0.price AS price_9, t0.compare_at_price AS compare_at_price_10, t0.stock AS stock_11, t0.min_stock_alert AS min_stock_alert_12, t0.manage_stock AS manage_stock_13, t0.allow_backorders AS allow_backorders_14, t0.stock_status AS stock_status_15, t0.weight AS weight_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.is_digital AS is_digital_20, t0.digital_file AS digital_file_21, t0.attributes AS attributes_22, t0.variations AS variations_23, t0.is_active AS is_active_24, t0.is_featured AS is_featured_25, t0.published_at AS published_at_26, t0.available_from AS available_from_27, t0.available_to AS available_to_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30, t0.meta_keywords AS meta_keywords_31, t0.view_count AS view_count_32, t0.sales_count AS sales_count_33, t0.average_rating AS average_rating_34, t0.review_count AS review_count_35, t0.tier_prices AS tier_prices_36, t0.has_tier_pricing AS has_tier_pricing_37, t0.name AS name_38, t0.shop_id AS shop_id_39, t0.category_id AS category_id_40, t0.brand_id AS brand_id_41, t0.condition_id AS condition_id_42 FROM product t0 WHERE t0.id = ?
Parameters:
[
  23
]
9 0.20 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.sku AS sku_3, t0.barcode AS barcode_4, t0.description AS description_5, t0.images AS images_6, t0.videos AS videos_7, t0.documents AS documents_8, t0.price AS price_9, t0.compare_at_price AS compare_at_price_10, t0.stock AS stock_11, t0.min_stock_alert AS min_stock_alert_12, t0.manage_stock AS manage_stock_13, t0.allow_backorders AS allow_backorders_14, t0.stock_status AS stock_status_15, t0.weight AS weight_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.is_digital AS is_digital_20, t0.digital_file AS digital_file_21, t0.attributes AS attributes_22, t0.variations AS variations_23, t0.is_active AS is_active_24, t0.is_featured AS is_featured_25, t0.published_at AS published_at_26, t0.available_from AS available_from_27, t0.available_to AS available_to_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30, t0.meta_keywords AS meta_keywords_31, t0.view_count AS view_count_32, t0.sales_count AS sales_count_33, t0.average_rating AS average_rating_34, t0.review_count AS review_count_35, t0.tier_prices AS tier_prices_36, t0.has_tier_pricing AS has_tier_pricing_37, t0.name AS name_38, t0.shop_id AS shop_id_39, t0.category_id AS category_id_40, t0.brand_id AS brand_id_41, t0.condition_id AS condition_id_42 FROM product t0 WHERE t0.id = ?
Parameters:
[
  39
]
10 0.22 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.sku AS sku_3, t0.barcode AS barcode_4, t0.description AS description_5, t0.images AS images_6, t0.videos AS videos_7, t0.documents AS documents_8, t0.price AS price_9, t0.compare_at_price AS compare_at_price_10, t0.stock AS stock_11, t0.min_stock_alert AS min_stock_alert_12, t0.manage_stock AS manage_stock_13, t0.allow_backorders AS allow_backorders_14, t0.stock_status AS stock_status_15, t0.weight AS weight_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.is_digital AS is_digital_20, t0.digital_file AS digital_file_21, t0.attributes AS attributes_22, t0.variations AS variations_23, t0.is_active AS is_active_24, t0.is_featured AS is_featured_25, t0.published_at AS published_at_26, t0.available_from AS available_from_27, t0.available_to AS available_to_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30, t0.meta_keywords AS meta_keywords_31, t0.view_count AS view_count_32, t0.sales_count AS sales_count_33, t0.average_rating AS average_rating_34, t0.review_count AS review_count_35, t0.tier_prices AS tier_prices_36, t0.has_tier_pricing AS has_tier_pricing_37, t0.name AS name_38, t0.shop_id AS shop_id_39, t0.category_id AS category_id_40, t0.brand_id AS brand_id_41, t0.condition_id AS condition_id_42 FROM product t0 WHERE t0.id = ?
Parameters:
[
  71
]
11 0.20 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.sku AS sku_3, t0.barcode AS barcode_4, t0.description AS description_5, t0.images AS images_6, t0.videos AS videos_7, t0.documents AS documents_8, t0.price AS price_9, t0.compare_at_price AS compare_at_price_10, t0.stock AS stock_11, t0.min_stock_alert AS min_stock_alert_12, t0.manage_stock AS manage_stock_13, t0.allow_backorders AS allow_backorders_14, t0.stock_status AS stock_status_15, t0.weight AS weight_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.is_digital AS is_digital_20, t0.digital_file AS digital_file_21, t0.attributes AS attributes_22, t0.variations AS variations_23, t0.is_active AS is_active_24, t0.is_featured AS is_featured_25, t0.published_at AS published_at_26, t0.available_from AS available_from_27, t0.available_to AS available_to_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30, t0.meta_keywords AS meta_keywords_31, t0.view_count AS view_count_32, t0.sales_count AS sales_count_33, t0.average_rating AS average_rating_34, t0.review_count AS review_count_35, t0.tier_prices AS tier_prices_36, t0.has_tier_pricing AS has_tier_pricing_37, t0.name AS name_38, t0.shop_id AS shop_id_39, t0.category_id AS category_id_40, t0.brand_id AS brand_id_41, t0.condition_id AS condition_id_42 FROM product t0 WHERE t0.id = ?
Parameters:
[
  40
]
12 0.20 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.sku AS sku_3, t0.barcode AS barcode_4, t0.description AS description_5, t0.images AS images_6, t0.videos AS videos_7, t0.documents AS documents_8, t0.price AS price_9, t0.compare_at_price AS compare_at_price_10, t0.stock AS stock_11, t0.min_stock_alert AS min_stock_alert_12, t0.manage_stock AS manage_stock_13, t0.allow_backorders AS allow_backorders_14, t0.stock_status AS stock_status_15, t0.weight AS weight_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.is_digital AS is_digital_20, t0.digital_file AS digital_file_21, t0.attributes AS attributes_22, t0.variations AS variations_23, t0.is_active AS is_active_24, t0.is_featured AS is_featured_25, t0.published_at AS published_at_26, t0.available_from AS available_from_27, t0.available_to AS available_to_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30, t0.meta_keywords AS meta_keywords_31, t0.view_count AS view_count_32, t0.sales_count AS sales_count_33, t0.average_rating AS average_rating_34, t0.review_count AS review_count_35, t0.tier_prices AS tier_prices_36, t0.has_tier_pricing AS has_tier_pricing_37, t0.name AS name_38, t0.shop_id AS shop_id_39, t0.category_id AS category_id_40, t0.brand_id AS brand_id_41, t0.condition_id AS condition_id_42 FROM product t0 WHERE t0.id = ?
Parameters:
[
  26
]
13 0.21 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.sku AS sku_3, t0.barcode AS barcode_4, t0.description AS description_5, t0.images AS images_6, t0.videos AS videos_7, t0.documents AS documents_8, t0.price AS price_9, t0.compare_at_price AS compare_at_price_10, t0.stock AS stock_11, t0.min_stock_alert AS min_stock_alert_12, t0.manage_stock AS manage_stock_13, t0.allow_backorders AS allow_backorders_14, t0.stock_status AS stock_status_15, t0.weight AS weight_16, t0.length AS length_17, t0.width AS width_18, t0.height AS height_19, t0.is_digital AS is_digital_20, t0.digital_file AS digital_file_21, t0.attributes AS attributes_22, t0.variations AS variations_23, t0.is_active AS is_active_24, t0.is_featured AS is_featured_25, t0.published_at AS published_at_26, t0.available_from AS available_from_27, t0.available_to AS available_to_28, t0.meta_title AS meta_title_29, t0.meta_description AS meta_description_30, t0.meta_keywords AS meta_keywords_31, t0.view_count AS view_count_32, t0.sales_count AS sales_count_33, t0.average_rating AS average_rating_34, t0.review_count AS review_count_35, t0.tier_prices AS tier_prices_36, t0.has_tier_pricing AS has_tier_pricing_37, t0.name AS name_38, t0.shop_id AS shop_id_39, t0.category_id AS category_id_40, t0.brand_id AS brand_id_41, t0.condition_id AS condition_id_42 FROM product t0 WHERE t0.id = ?
Parameters:
[
  60
]

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\Cart
  • The association App\Entity\Cart#user refers to the inverse side field App\Entity\User#carts which does not exist.
App\Entity\User No errors.
App\Entity\CartItem No errors.
App\Entity\Product No errors.
App\Entity\Shop No errors.
App\Entity\Category No errors.
App\Entity\Brand No errors.
App\Entity\ProductCondition No errors.
App\Entity\ProductRanking No errors.
App\Entity\ProductVariant No errors.
App\Entity\ProductDetail No errors.