GET https://xb515285.xbiz.jp/reviews

Query Metrics

16 Database Queries
13 Different statements
14.50 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.27 ms
SET SESSION time_zone = '+00:00'
Parameters:
[]
2 1.02 ms
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.invoice_registration_number AS invoice_registration_number_25, t0.option_product_tax_rule AS option_product_tax_rule_26, t0.option_customer_activate AS option_customer_activate_27, t0.option_remember_me AS option_remember_me_28, t0.option_mail_notifier AS option_mail_notifier_29, t0.authentication_key AS authentication_key_30, t0.php_path AS php_path_31, t0.option_point AS option_point_32, t0.basic_point_rate AS basic_point_rate_33, t0.point_conversion_rate AS point_conversion_rate_34, t0.ga_id AS ga_id_35, t0.phone_number_2 AS phone_number_2_36, t0.phone_number_3 AS phone_number_3_37, t0.fax_number AS fax_number_38, t0.corporate_site_url AS corporate_site_url_39, t0.instagram_url AS instagram_url_40, t0.youtube_url AS youtube_url_41, t0.country_id AS country_id_42, t0.pref_id AS pref_id_43, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters:
[
  1
]
3 1.07 ms
SELECT d0_.id AS id_0, d0_.page_name AS page_name_1, d0_.url AS url_2, d0_.file_name AS file_name_3, d0_.edit_type AS edit_type_4, d0_.author AS author_5, d0_.description AS description_6, d0_.keyword AS keyword_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.meta_robots AS meta_robots_10, d0_.meta_tags AS meta_tags_11, d1_.page_id AS page_id_12, d1_.layout_id AS layout_id_13, d1_.sort_no AS sort_no_14, d2_.id AS id_15, d2_.layout_name AS layout_name_16, d2_.create_date AS create_date_17, d2_.update_date AS update_date_18, d0_.discriminator_type AS discriminator_type_19, d0_.master_page_id AS master_page_id_20, d1_.discriminator_type AS discriminator_type_21, d1_.page_id AS page_id_22, d1_.layout_id AS layout_id_23, d2_.discriminator_type AS discriminator_type_24, d2_.device_type_id AS device_type_id_25 FROM dtb_page d0_ LEFT JOIN dtb_page_layout d1_ ON d0_.id = d1_.page_id AND d1_.discriminator_type IN ('pagelayout') LEFT JOIN dtb_layout d2_ ON d1_.layout_id = d2_.id AND d2_.discriminator_type IN ('layout') WHERE (d0_.url = ?) AND d0_.discriminator_type IN ('page')
Parameters:
[
  "reviews"
]
4 1.34 ms
SELECT d0_.id AS id_0, d0_.layout_name AS layout_name_1, d0_.create_date AS create_date_2, d0_.update_date AS update_date_3, d1_.section AS section_4, d1_.block_id AS block_id_5, d1_.layout_id AS layout_id_6, d1_.block_row AS block_row_7, d2_.id AS id_8, d2_.block_name AS block_name_9, d2_.file_name AS file_name_10, d2_.use_controller AS use_controller_11, d2_.deletable AS deletable_12, d2_.create_date AS create_date_13, d2_.update_date AS update_date_14, d0_.discriminator_type AS discriminator_type_15, d0_.device_type_id AS device_type_id_16, d1_.discriminator_type AS discriminator_type_17, d1_.block_id AS block_id_18, d1_.layout_id AS layout_id_19, d2_.discriminator_type AS discriminator_type_20, d2_.device_type_id AS device_type_id_21 FROM dtb_layout d0_ LEFT JOIN dtb_block_position d1_ ON d0_.id = d1_.layout_id AND d1_.discriminator_type IN ('blockposition') LEFT JOIN dtb_block d2_ ON d1_.block_id = d2_.id AND d2_.discriminator_type IN ('block') WHERE (d0_.id = ?) AND d0_.discriminator_type IN ('layout') ORDER BY d1_.block_row ASC
Parameters:
[
  2
]
5 2.63 ms
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[]
6 0.26 ms
"START TRANSACTION"
Parameters:
[]
7 0.92 ms
SELECT d0_.id AS id_0, d0_.status AS status_1, d0_.sort_no AS sort_no_2, d0_.rating AS rating_3, d0_.customer_name AS customer_name_4, d0_.use_purpose AS use_purpose_5, d0_.support AS support_6, d0_.about_product AS about_product_7, d0_.about_naming AS about_naming_8, d0_.other_message AS other_message_9, d0_.how_knew_us AS how_knew_us_10, d0_.how_knew_us_detail AS how_knew_us_detail_11, d0_.will_use_again AS will_use_again_12, d0_.name_public AS name_public_13, d0_.voice_date AS voice_date_14, d0_.create_date AS create_date_15, d0_.update_date AS update_date_16, d1_.id AS id_17, d1_.name AS name_18, d1_.note AS note_19, d1_.description_list AS description_list_20, d1_.description_detail AS description_detail_21, d1_.search_word AS search_word_22, d1_.free_area AS free_area_23, d1_.create_date AS create_date_24, d1_.update_date AS update_date_25, d1_.carton_qty AS carton_qty_26, d1_.min_qty AS min_qty_27, d1_.step_qty AS step_qty_28, d1_.unit AS unit_29, d1_.size AS size_30, d1_.weight AS weight_31, d1_.capacity AS capacity_32, d1_.package AS package_33, d1_.package_size AS package_size_34, d1_.material AS material_35, d1_.carton_size AS carton_size_36, d1_.carton_weight AS carton_weight_37, d1_.product_area AS product_area_38, d1_.japan AS japan_39, d1_.expiration_date AS expiration_date_40, d1_.detail_1 AS detail_1_41, d1_.detail_2 AS detail_2_42, d1_.detail_3 AS detail_3_43, d1_.catalog AS catalog_44, d1_.lot AS lot_45, d1_.shipping_free AS shipping_free_46, d1_.naire AS naire_47, d1_.legacy_product_id AS legacy_product_id_48, d1_.get_date AS get_date_49, d0_.discriminator_type AS discriminator_type_50, d0_.order_id AS order_id_51, d0_.product_id AS product_id_52, d1_.discriminator_type AS discriminator_type_53, d1_.creator_id AS creator_id_54, d1_.product_status_id AS product_status_id_55, d1_.maker_id AS maker_id_56 FROM dtb_customer_voice d0_ LEFT JOIN dtb_product d1_ ON d0_.product_id = d1_.id AND d1_.discriminator_type IN ('product') WHERE (d0_.status = ?) AND d0_.discriminator_type IN ('customervoice') ORDER BY d0_.sort_no ASC, d0_.id ASC
Parameters:
[
  1
]
8 0.51 ms
SELECT d0_.id AS id_0, d0_.status AS status_1, d0_.sort_no AS sort_no_2, d0_.title AS title_3, d0_.body AS body_4, d0_.display_start_date AS display_start_date_5, d0_.display_end_date AS display_end_date_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.discriminator_type AS discriminator_type_9 FROM dtb_custom_news d0_ WHERE (d0_.status = ? AND ((d0_.display_start_date IS NULL OR d0_.display_start_date <= ?) AND (d0_.display_end_date IS NULL OR d0_.display_end_date >= ?))) AND d0_.discriminator_type IN ('customnews') ORDER BY d0_.sort_no ASC, d0_.id ASC
Parameters:
[
  1
  "2026-03-06 15:00:00"
  "2026-03-06 15:00:00"
]
9 2.49 ms
SELECT d0_.id AS id_0, d0_.category_name AS category_name_1, d0_.hierarchy AS hierarchy_2, d0_.sort_no AS sort_no_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d1_.id AS id_6, d1_.category_name AS category_name_7, d1_.hierarchy AS hierarchy_8, d1_.sort_no AS sort_no_9, d1_.create_date AS create_date_10, d1_.update_date AS update_date_11, d2_.id AS id_12, d2_.category_name AS category_name_13, d2_.hierarchy AS hierarchy_14, d2_.sort_no AS sort_no_15, d2_.create_date AS create_date_16, d2_.update_date AS update_date_17, d3_.id AS id_18, d3_.category_name AS category_name_19, d3_.hierarchy AS hierarchy_20, d3_.sort_no AS sort_no_21, d3_.create_date AS create_date_22, d3_.update_date AS update_date_23, d4_.id AS id_24, d4_.category_name AS category_name_25, d4_.hierarchy AS hierarchy_26, d4_.sort_no AS sort_no_27, d4_.create_date AS create_date_28, d4_.update_date AS update_date_29, d0_.discriminator_type AS discriminator_type_30, d0_.parent_category_id AS parent_category_id_31, d0_.creator_id AS creator_id_32, d1_.discriminator_type AS discriminator_type_33, d1_.parent_category_id AS parent_category_id_34, d1_.creator_id AS creator_id_35, d2_.discriminator_type AS discriminator_type_36, d2_.parent_category_id AS parent_category_id_37, d2_.creator_id AS creator_id_38, d3_.discriminator_type AS discriminator_type_39, d3_.parent_category_id AS parent_category_id_40, d3_.creator_id AS creator_id_41, d4_.discriminator_type AS discriminator_type_42, d4_.parent_category_id AS parent_category_id_43, d4_.creator_id AS creator_id_44 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id AND d1_.discriminator_type IN ('category') LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id AND d2_.discriminator_type IN ('category') LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id AND d3_.discriminator_type IN ('category') LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id AND d4_.discriminator_type IN ('category') WHERE (d0_.parent_category_id IS NULL) AND d0_.discriminator_type IN ('category') ORDER BY d0_.sort_no DESC, d1_.sort_no DESC, d2_.sort_no DESC, d3_.sort_no DESC, d4_.sort_no DESC
Parameters:
[]
10 0.48 ms
SELECT DATABASE()
Parameters:
[]
11 1.56 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "xb515285_ec2"
]
12 0.20 ms
SELECT DATABASE()
Parameters:
[]
13 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.discriminator_type IN ('plugin')
Parameters:
[]
14 0.39 ms
SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.holiday AS holiday_2, d0_.create_date AS create_date_3, d0_.update_date AS update_date_4, d0_.discriminator_type AS discriminator_type_5 FROM dtb_calendar d0_ WHERE (d0_.holiday >= ? AND d0_.holiday <= ?) AND d0_.discriminator_type IN ('calendar') ORDER BY d0_.holiday ASC
Parameters:
[
  "2026-02-28 15:00:00"
  "2026-04-30 14:59:59"
]
15 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.discriminator_type IN ('plugin')
Parameters:
[]
16 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.discriminator_type IN ('plugin')
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.

Entities Mapping

Class Mapping errors
Eccube\Entity\AbstractEntity No errors.
Eccube\Entity\BaseInfo No errors.
Eccube\Entity\Master\AbstractMasterEntity No errors.
Eccube\Entity\Master\Country No errors.
Eccube\Entity\Master\Pref No errors.
Eccube\Entity\Page No errors.
Eccube\Entity\PageLayout No errors.
Eccube\Entity\Layout No errors.
Eccube\Entity\Master\DeviceType No errors.
Eccube\Entity\BlockPosition No errors.
Eccube\Entity\Block No errors.
Customize\Entity\CustomerVoice No errors.
Eccube\Entity\Product
  • The field Eccube\Entity\Product#ProductNameprintMethods is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\ProductNameprintMethod#Product does not contain the required 'inversedBy="ProductNameprintMethods"' attribute.
  • The field Eccube\Entity\Product#ProductOptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\ProductOption#Product does not contain the required 'inversedBy="ProductOptions"' attribute.
  • The field Eccube\Entity\Product#ProductSpecialWorks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\ProductSpecialWork#Product does not contain the required 'inversedBy="ProductSpecialWorks"' attribute.
Eccube\Entity\Order
  • The field Eccube\Entity\Order#OrderFees is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Customize\Entity\OrderFee#Order does not contain the required 'inversedBy="OrderFees"' attribute.
Eccube\Entity\Member No errors.
Eccube\Entity\Master\ProductStatus No errors.
Customize\Entity\Maker No errors.
Customize\Entity\CustomNews No errors.
Eccube\Entity\Category No errors.
Eccube\Entity\ProductCategory No errors.
Eccube\Entity\ProductClass No errors.
Eccube\Entity\ProductImage No errors.
Eccube\Entity\ProductTag No errors.
Eccube\Entity\CustomerFavoriteProduct No errors.
Plugin\RelatedProduct42\Entity\RelatedProduct No errors.
Customize\Entity\ProductNoticeTemplate No errors.
Customize\Entity\ProductNameprintMethod No errors.
Customize\Entity\ProductOption No errors.
Customize\Entity\ProductSpecialWork No errors.
Eccube\Entity\OrderItem No errors.
Eccube\Entity\Shipping No errors.
Eccube\Entity\MailHistory No errors.
Eccube\Entity\Customer No errors.
Eccube\Entity\Master\Sex No errors.
Eccube\Entity\Master\Job No errors.
Eccube\Entity\Payment No errors.
Eccube\Entity\Master\CustomerOrderStatus No errors.
Eccube\Entity\Master\OrderStatusColor No errors.
Eccube\Entity\Master\OrderStatus No errors.
Customize\Entity\OrderFee No errors.
Eccube\Entity\Master\Work No errors.
Eccube\Entity\Master\Authority No errors.
Customize\Entity\MakerWebPage No errors.
Customize\Entity\MakerNoticeTemplate No errors.
Eccube\Entity\Plugin No errors.
Eccube\Entity\Calendar No errors.
Eccube\Entity\ProductStock No errors.
Eccube\Entity\TaxRule No errors.
Eccube\Entity\Master\SaleType No errors.
Eccube\Entity\ClassCategory No errors.
Eccube\Entity\DeliveryDuration No errors.
Eccube\Entity\Tag No errors.
Customize\Entity\NoticeTemplate No errors.
Customize\Entity\NameprintMethod No errors.
Customize\Entity\Option No errors.
Customize\Entity\SpecialWork No errors.
Eccube\Entity\Master\RoundingType No errors.
Eccube\Entity\Master\TaxType No errors.
Eccube\Entity\Master\TaxDisplayType No errors.
Eccube\Entity\Master\OrderItemType No errors.
Customize\Entity\OrderItemOption No errors.
Eccube\Entity\Delivery No errors.
Eccube\Entity\MailTemplate No errors.
Eccube\Entity\CustomerAddress No errors.
Eccube\Entity\Master\CustomerStatus No errors.
Eccube\Entity\PaymentOption No errors.
Eccube\Entity\ClassName No errors.
Customize\Entity\NameprintPrice No errors.
Eccube\Entity\DeliveryFee No errors.
Eccube\Entity\DeliveryTime No errors.