Settings

Query Metrics

85 Database Queries

21 Different statements

62.69 ms Query time

0 Invalid entities

Queries


SET SESSION time_zone = '+00:00'
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.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
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')
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
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
"START TRANSACTION"
SELECT t0.id AS id_1, t0.amazon_account_mode AS amazon_account_mode_2, t0.env AS env_3, t0.seller_id AS seller_id_4, t0.client_id AS client_id_5, t0.test_client_id AS test_client_id_6, t0.prod_key AS prod_key_7, t0.public_key_id AS public_key_id_8, t0.private_key_path AS private_key_path_9, t0.sale AS sale_10, t0.use_confirm_page AS use_confirm_page_11, t0.auto_login AS auto_login_12, t0.login_required AS login_required_13, t0.order_correct AS order_correct_14, t0.mail_notices AS mail_notices_15, t0.use_cart_button AS use_cart_button_16, t0.cart_button_color AS cart_button_color_17, t0.cart_button_place AS cart_button_place_18, t0.use_mypage_login_button AS use_mypage_login_button_19, t0.mypage_login_button_color AS mypage_login_button_color_20, t0.mypage_login_button_place AS mypage_login_button_place_21, t0.use_amazon_banner_on_top AS use_amazon_banner_on_top_22, t0.use_amazon_banner_on_cart AS use_amazon_banner_on_cart_23, t0.amazon_banner_id_on_top AS amazon_banner_id_on_top_24, t0.amazon_banner_id_on_cart AS amazon_banner_id_on_cart_25, t0.amazon_banner_place_on_top AS amazon_banner_place_on_top_26, t0.amazon_banner_place_on_cart AS amazon_banner_place_on_cart_27 FROM plg_amazon_pay_v2_config t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.plan_type AS plan_type_2, t0.plan_id AS plan_id_3, t0.domain AS domain_4, t0.match_pattern AS match_pattern_5, t0.user_tag_option AS user_tag_option_6, t0.conburn_john_option AS conburn_john_option_7, t0.cart_tag_option AS cart_tag_option_8, t0.identify_tag AS identify_tag_9, t0.attribute_tag AS attribute_tag_10 FROM plg_karte_config t0 WHERE t0.id = ?
SELECT p0_.id AS id_0, p0_.image_insert_type AS image_insert_type_1, p0_.image_list_type AS image_list_type_2, p0_.image_max_size AS image_max_size_3, p0_.image_type AS image_type_4 FROM plg_apg_product_class_image_config p0_ WHERE p0_.id = ?
SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.url AS url_3, t0.file_name AS file_name_4, t0.edit_type AS edit_type_5, t0.author AS author_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.create_date AS create_date_9, t0.update_date AS update_date_10, t0.meta_robots AS meta_robots_11, t0.meta_tags AS meta_tags_12, t0.master_page_id AS master_page_id_13, t0.discriminator_type FROM dtb_page t0 WHERE t0.url = ? AND t0.discriminator_type IN ('page') LIMIT 1
SELECT t0.name AS name_1, t0.value AS value_2, t0.discriminator_type FROM plg_deliverydate_dtb_config t0 WHERE t0.name = ? AND t0.discriminator_type IN ('deliverydateconfig') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'eccube_db' */ ORDER BY k.ORDINAL_POSITION
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS TYPE,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS COMMENT,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS COLLATION
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
SELECT DATABASE()
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()
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')
SELECT t0.id AS id_1, t0.rich_snippet_flg AS rich_snippet_flg_2, t0.sns_flg AS sns_flg_3, t0.sitemap_flg AS sitemap_flg_4, t0.pagination_flg AS pagination_flg_5, t0.breadcrumb_flg AS breadcrumb_flg_6, t0.facebook_flg AS facebook_flg_7, t0.twitter_flg AS twitter_flg_8, t0.line_flg AS line_flg_9, t0.shop_name_top_flg AS shop_name_top_flg_10, t0.shop_name_product_flg AS shop_name_product_flg_11, t0.global_id_flg AS global_id_flg_12, t0.global_id_type AS global_id_type_13, t0.valid_price_flg AS valid_price_flg_14, t0.valid_price_month AS valid_price_month_15, t0.canonical_flg AS canonical_flg_16 FROM plg_seoallone_config t0 LIMIT 1

#▲	Time	Info
1	0.62 ms	SET SESSION time_zone = '+00:00' Parameters: [] View formatted query View runnable query Explain query SET SESSION time_zone = '+00:00' SET SESSION time_zone = '+00:00';
2	0.75 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.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo') Parameters: [`1`] View formatted query View runnable query Explain query 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.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo') 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.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = 1 AND t0.discriminator_type IN ('baseinfo');
3	0.99 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: [`"mypage_login"`] View formatted query View runnable query Explain query 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') 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 = 'mypage_login') AND d0_.discriminator_type IN ('page');
4	1.00 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`] View formatted query View runnable query Explain query 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 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 = 2) AND d0_.discriminator_type IN ('layout') ORDER BY d1_.block_row ASC;
5	0.46 ms	SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED Parameters: [] View formatted query View runnable query Explain query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
6	0.38 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
7	0.79 ms	SELECT t0.id AS id_1, t0.amazon_account_mode AS amazon_account_mode_2, t0.env AS env_3, t0.seller_id AS seller_id_4, t0.client_id AS client_id_5, t0.test_client_id AS test_client_id_6, t0.prod_key AS prod_key_7, t0.public_key_id AS public_key_id_8, t0.private_key_path AS private_key_path_9, t0.sale AS sale_10, t0.use_confirm_page AS use_confirm_page_11, t0.auto_login AS auto_login_12, t0.login_required AS login_required_13, t0.order_correct AS order_correct_14, t0.mail_notices AS mail_notices_15, t0.use_cart_button AS use_cart_button_16, t0.cart_button_color AS cart_button_color_17, t0.cart_button_place AS cart_button_place_18, t0.use_mypage_login_button AS use_mypage_login_button_19, t0.mypage_login_button_color AS mypage_login_button_color_20, t0.mypage_login_button_place AS mypage_login_button_place_21, t0.use_amazon_banner_on_top AS use_amazon_banner_on_top_22, t0.use_amazon_banner_on_cart AS use_amazon_banner_on_cart_23, t0.amazon_banner_id_on_top AS amazon_banner_id_on_top_24, t0.amazon_banner_id_on_cart AS amazon_banner_id_on_cart_25, t0.amazon_banner_place_on_top AS amazon_banner_place_on_top_26, t0.amazon_banner_place_on_cart AS amazon_banner_place_on_cart_27 FROM plg_amazon_pay_v2_config t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.amazon_account_mode AS amazon_account_mode_2, t0.env AS env_3, t0.seller_id AS seller_id_4, t0.client_id AS client_id_5, t0.test_client_id AS test_client_id_6, t0.prod_key AS prod_key_7, t0.public_key_id AS public_key_id_8, t0.private_key_path AS private_key_path_9, t0.sale AS sale_10, t0.use_confirm_page AS use_confirm_page_11, t0.auto_login AS auto_login_12, t0.login_required AS login_required_13, t0.order_correct AS order_correct_14, t0.mail_notices AS mail_notices_15, t0.use_cart_button AS use_cart_button_16, t0.cart_button_color AS cart_button_color_17, t0.cart_button_place AS cart_button_place_18, t0.use_mypage_login_button AS use_mypage_login_button_19, t0.mypage_login_button_color AS mypage_login_button_color_20, t0.mypage_login_button_place AS mypage_login_button_place_21, t0.use_amazon_banner_on_top AS use_amazon_banner_on_top_22, t0.use_amazon_banner_on_cart AS use_amazon_banner_on_cart_23, t0.amazon_banner_id_on_top AS amazon_banner_id_on_top_24, t0.amazon_banner_id_on_cart AS amazon_banner_id_on_cart_25, t0.amazon_banner_place_on_top AS amazon_banner_place_on_top_26, t0.amazon_banner_place_on_cart AS amazon_banner_place_on_cart_27 FROM plg_amazon_pay_v2_config t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.amazon_account_mode AS amazon_account_mode_2, t0.env AS env_3, t0.seller_id AS seller_id_4, t0.client_id AS client_id_5, t0.test_client_id AS test_client_id_6, t0.prod_key AS prod_key_7, t0.public_key_id AS public_key_id_8, t0.private_key_path AS private_key_path_9, t0.sale AS sale_10, t0.use_confirm_page AS use_confirm_page_11, t0.auto_login AS auto_login_12, t0.login_required AS login_required_13, t0.order_correct AS order_correct_14, t0.mail_notices AS mail_notices_15, t0.use_cart_button AS use_cart_button_16, t0.cart_button_color AS cart_button_color_17, t0.cart_button_place AS cart_button_place_18, t0.use_mypage_login_button AS use_mypage_login_button_19, t0.mypage_login_button_color AS mypage_login_button_color_20, t0.mypage_login_button_place AS mypage_login_button_place_21, t0.use_amazon_banner_on_top AS use_amazon_banner_on_top_22, t0.use_amazon_banner_on_cart AS use_amazon_banner_on_cart_23, t0.amazon_banner_id_on_top AS amazon_banner_id_on_top_24, t0.amazon_banner_id_on_cart AS amazon_banner_id_on_cart_25, t0.amazon_banner_place_on_top AS amazon_banner_place_on_top_26, t0.amazon_banner_place_on_cart AS amazon_banner_place_on_cart_27 FROM plg_amazon_pay_v2_config t0 WHERE t0.id = 1;
8	0.66 ms	SELECT t0.id AS id_1, t0.plan_type AS plan_type_2, t0.plan_id AS plan_id_3, t0.domain AS domain_4, t0.match_pattern AS match_pattern_5, t0.user_tag_option AS user_tag_option_6, t0.conburn_john_option AS conburn_john_option_7, t0.cart_tag_option AS cart_tag_option_8, t0.identify_tag AS identify_tag_9, t0.attribute_tag AS attribute_tag_10 FROM plg_karte_config t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.plan_type AS plan_type_2, t0.plan_id AS plan_id_3, t0.domain AS domain_4, t0.match_pattern AS match_pattern_5, t0.user_tag_option AS user_tag_option_6, t0.conburn_john_option AS conburn_john_option_7, t0.cart_tag_option AS cart_tag_option_8, t0.identify_tag AS identify_tag_9, t0.attribute_tag AS attribute_tag_10 FROM plg_karte_config t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.plan_type AS plan_type_2, t0.plan_id AS plan_id_3, t0.domain AS domain_4, t0.match_pattern AS match_pattern_5, t0.user_tag_option AS user_tag_option_6, t0.conburn_john_option AS conburn_john_option_7, t0.cart_tag_option AS cart_tag_option_8, t0.identify_tag AS identify_tag_9, t0.attribute_tag AS attribute_tag_10 FROM plg_karte_config t0 WHERE t0.id = 1;
9	0.57 ms	SELECT p0_.id AS id_0, p0_.image_insert_type AS image_insert_type_1, p0_.image_list_type AS image_list_type_2, p0_.image_max_size AS image_max_size_3, p0_.image_type AS image_type_4 FROM plg_apg_product_class_image_config p0_ WHERE p0_.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.image_insert_type AS image_insert_type_1, p0_.image_list_type AS image_list_type_2, p0_.image_max_size AS image_max_size_3, p0_.image_type AS image_type_4 FROM plg_apg_product_class_image_config p0_ WHERE p0_.id = ? SELECT p0_.id AS id_0, p0_.image_insert_type AS image_insert_type_1, p0_.image_list_type AS image_list_type_2, p0_.image_max_size AS image_max_size_3, p0_.image_type AS image_type_4 FROM plg_apg_product_class_image_config p0_ WHERE p0_.id = 1;
10	0.67 ms	SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.url AS url_3, t0.file_name AS file_name_4, t0.edit_type AS edit_type_5, t0.author AS author_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.create_date AS create_date_9, t0.update_date AS update_date_10, t0.meta_robots AS meta_robots_11, t0.meta_tags AS meta_tags_12, t0.master_page_id AS master_page_id_13, t0.discriminator_type FROM dtb_page t0 WHERE t0.url = ? AND t0.discriminator_type IN ('page') LIMIT 1 Parameters: [`"mypage_login"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.url AS url_3, t0.file_name AS file_name_4, t0.edit_type AS edit_type_5, t0.author AS author_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.create_date AS create_date_9, t0.update_date AS update_date_10, t0.meta_robots AS meta_robots_11, t0.meta_tags AS meta_tags_12, t0.master_page_id AS master_page_id_13, t0.discriminator_type FROM dtb_page t0 WHERE t0.url = ? AND t0.discriminator_type IN ('page') LIMIT 1 SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.url AS url_3, t0.file_name AS file_name_4, t0.edit_type AS edit_type_5, t0.author AS author_6, t0.description AS description_7, t0.keyword AS keyword_8, t0.create_date AS create_date_9, t0.update_date AS update_date_10, t0.meta_robots AS meta_robots_11, t0.meta_tags AS meta_tags_12, t0.master_page_id AS master_page_id_13, t0.discriminator_type FROM dtb_page t0 WHERE t0.url = 'mypage_login' AND t0.discriminator_type IN ('page') LIMIT 1;
11	0.66 ms	SELECT t0.name AS name_1, t0.value AS value_2, t0.discriminator_type FROM plg_deliverydate_dtb_config t0 WHERE t0.name = ? AND t0.discriminator_type IN ('deliverydateconfig') LIMIT 1 Parameters: [`"calendar_month"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.value AS value_2, t0.discriminator_type FROM plg_deliverydate_dtb_config t0 WHERE t0.name = ? AND t0.discriminator_type IN ('deliverydateconfig') LIMIT 1 SELECT t0.name AS name_1, t0.value AS value_2, t0.discriminator_type FROM plg_deliverydate_dtb_config t0 WHERE t0.name = 'calendar_month' AND t0.discriminator_type IN ('deliverydateconfig') LIMIT 1;
12	0.76 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-01 00:00:00+09:00" "2026-02-01 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-01 00:00:00+09:00' AND p0_.date < '2026-02-01 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
13	0.66 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-02 00:00:00+09:00" "2026-02-02 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-02 00:00:00+09:00' AND p0_.date < '2026-02-02 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
14	0.67 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-03 00:00:00+09:00" "2026-02-03 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-03 00:00:00+09:00' AND p0_.date < '2026-02-03 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
15	0.65 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-04 00:00:00+09:00" "2026-02-04 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-04 00:00:00+09:00' AND p0_.date < '2026-02-04 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
16	0.66 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-05 00:00:00+09:00" "2026-02-05 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-05 00:00:00+09:00' AND p0_.date < '2026-02-05 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
17	0.64 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-06 00:00:00+09:00" "2026-02-06 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-06 00:00:00+09:00' AND p0_.date < '2026-02-06 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
18	0.61 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-07 00:00:00+09:00" "2026-02-07 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-07 00:00:00+09:00' AND p0_.date < '2026-02-07 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
19	0.62 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-08 00:00:00+09:00" "2026-02-08 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-08 00:00:00+09:00' AND p0_.date < '2026-02-08 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
20	0.64 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-09 00:00:00+09:00" "2026-02-09 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-09 00:00:00+09:00' AND p0_.date < '2026-02-09 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
21	0.63 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-10 00:00:00+09:00" "2026-02-10 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-10 00:00:00+09:00' AND p0_.date < '2026-02-10 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
22	0.58 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-11 00:00:00+09:00" "2026-02-11 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-11 00:00:00+09:00' AND p0_.date < '2026-02-11 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
23	0.64 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-12 00:00:00+09:00" "2026-02-12 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-12 00:00:00+09:00' AND p0_.date < '2026-02-12 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
24	0.60 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-13 00:00:00+09:00" "2026-02-13 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-13 00:00:00+09:00' AND p0_.date < '2026-02-13 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
25	0.66 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-14 00:00:00+09:00" "2026-02-14 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-14 00:00:00+09:00' AND p0_.date < '2026-02-14 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
26	0.67 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-15 00:00:00+09:00" "2026-02-15 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-15 00:00:00+09:00' AND p0_.date < '2026-02-15 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
27	0.65 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-16 00:00:00+09:00" "2026-02-16 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-16 00:00:00+09:00' AND p0_.date < '2026-02-16 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
28	0.64 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-17 00:00:00+09:00" "2026-02-17 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-17 00:00:00+09:00' AND p0_.date < '2026-02-17 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
29	0.60 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-18 00:00:00+09:00" "2026-02-18 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-18 00:00:00+09:00' AND p0_.date < '2026-02-18 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
30	0.65 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-19 00:00:00+09:00" "2026-02-19 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-19 00:00:00+09:00' AND p0_.date < '2026-02-19 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
31	0.69 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-20 00:00:00+09:00" "2026-02-20 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-20 00:00:00+09:00' AND p0_.date < '2026-02-20 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
32	0.62 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-21 00:00:00+09:00" "2026-02-21 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-21 00:00:00+09:00' AND p0_.date < '2026-02-21 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
33	0.64 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-22 00:00:00+09:00" "2026-02-22 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-22 00:00:00+09:00' AND p0_.date < '2026-02-22 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
34	0.65 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-23 00:00:00+09:00" "2026-02-23 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-23 00:00:00+09:00' AND p0_.date < '2026-02-23 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
35	0.68 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-24 00:00:00+09:00" "2026-02-24 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-24 00:00:00+09:00' AND p0_.date < '2026-02-24 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
36	0.68 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-25 00:00:00+09:00" "2026-02-25 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-25 00:00:00+09:00' AND p0_.date < '2026-02-25 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
37	0.65 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-26 00:00:00+09:00" "2026-02-26 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-26 00:00:00+09:00' AND p0_.date < '2026-02-26 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
38	0.72 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-27 00:00:00+09:00" "2026-02-27 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-27 00:00:00+09:00' AND p0_.date < '2026-02-27 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
39	0.60 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-02-28 00:00:00+09:00" "2026-02-28 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-02-28 00:00:00+09:00' AND p0_.date < '2026-02-28 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
40	0.61 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-01 00:00:00+09:00" "2026-03-01 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-01 00:00:00+09:00' AND p0_.date < '2026-03-01 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
41	0.63 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-02 00:00:00+09:00" "2026-03-02 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-02 00:00:00+09:00' AND p0_.date < '2026-03-02 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
42	0.62 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-03 00:00:00+09:00" "2026-03-03 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-03 00:00:00+09:00' AND p0_.date < '2026-03-03 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
43	0.80 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-04 00:00:00+09:00" "2026-03-04 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-04 00:00:00+09:00' AND p0_.date < '2026-03-04 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
44	0.68 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-05 00:00:00+09:00" "2026-03-05 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-05 00:00:00+09:00' AND p0_.date < '2026-03-05 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
45	0.75 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-06 00:00:00+09:00" "2026-03-06 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-06 00:00:00+09:00' AND p0_.date < '2026-03-06 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
46	0.63 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-07 00:00:00+09:00" "2026-03-07 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-07 00:00:00+09:00' AND p0_.date < '2026-03-07 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
47	0.77 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-08 00:00:00+09:00" "2026-03-08 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-08 00:00:00+09:00' AND p0_.date < '2026-03-08 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
48	0.77 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-09 00:00:00+09:00" "2026-03-09 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-09 00:00:00+09:00' AND p0_.date < '2026-03-09 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
49	0.73 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-10 00:00:00+09:00" "2026-03-10 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-10 00:00:00+09:00' AND p0_.date < '2026-03-10 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
50	0.71 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-11 00:00:00+09:00" "2026-03-11 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-11 00:00:00+09:00' AND p0_.date < '2026-03-11 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
51	0.69 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-12 00:00:00+09:00" "2026-03-12 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-12 00:00:00+09:00' AND p0_.date < '2026-03-12 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
52	0.67 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-13 00:00:00+09:00" "2026-03-13 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-13 00:00:00+09:00' AND p0_.date < '2026-03-13 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
53	0.63 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-14 00:00:00+09:00" "2026-03-14 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-14 00:00:00+09:00' AND p0_.date < '2026-03-14 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
54	0.66 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-15 00:00:00+09:00" "2026-03-15 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-15 00:00:00+09:00' AND p0_.date < '2026-03-15 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
55	0.69 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-16 00:00:00+09:00" "2026-03-16 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-16 00:00:00+09:00' AND p0_.date < '2026-03-16 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
56	0.70 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-17 00:00:00+09:00" "2026-03-17 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-17 00:00:00+09:00' AND p0_.date < '2026-03-17 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
57	0.69 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-18 00:00:00+09:00" "2026-03-18 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-18 00:00:00+09:00' AND p0_.date < '2026-03-18 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
58	0.65 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-19 00:00:00+09:00" "2026-03-19 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-19 00:00:00+09:00' AND p0_.date < '2026-03-19 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
59	0.63 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-20 00:00:00+09:00" "2026-03-20 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-20 00:00:00+09:00' AND p0_.date < '2026-03-20 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
60	0.71 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-21 00:00:00+09:00" "2026-03-21 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-21 00:00:00+09:00' AND p0_.date < '2026-03-21 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
61	0.65 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-22 00:00:00+09:00" "2026-03-22 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-22 00:00:00+09:00' AND p0_.date < '2026-03-22 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
62	0.69 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-23 00:00:00+09:00" "2026-03-23 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-23 00:00:00+09:00' AND p0_.date < '2026-03-23 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
63	0.65 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-24 00:00:00+09:00" "2026-03-24 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-24 00:00:00+09:00' AND p0_.date < '2026-03-24 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
64	0.64 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-25 00:00:00+09:00" "2026-03-25 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-25 00:00:00+09:00' AND p0_.date < '2026-03-25 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
65	0.76 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-26 00:00:00+09:00" "2026-03-26 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-26 00:00:00+09:00' AND p0_.date < '2026-03-26 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
66	0.67 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-27 00:00:00+09:00" "2026-03-27 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-27 00:00:00+09:00' AND p0_.date < '2026-03-27 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
67	0.75 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-28 00:00:00+09:00" "2026-03-28 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-28 00:00:00+09:00' AND p0_.date < '2026-03-28 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
68	0.69 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-29 00:00:00+09:00" "2026-03-29 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-29 00:00:00+09:00' AND p0_.date < '2026-03-29 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
69	0.69 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-30 00:00:00+09:00" "2026-03-30 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-30 00:00:00+09:00' AND p0_.date < '2026-03-30 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
70	0.64 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= ? AND p0_.date < ?) AND p0_.discriminator_type IN ('holiday') LIMIT 1 Parameters: [`"2026-03-31 00:00:00+09:00" "2026-03-31 23:59:59+09:00"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE ( p0_.date >= ? AND p0_.date < ? ) AND p0_.discriminator_type IN ('holiday') LIMIT 1 SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.date AS date_2, p0_.discriminator_type AS discriminator_type_3 FROM plg_deliverydate_dtb_holiday p0_ WHERE (p0_.date >= '2026-03-31 00:00:00+09:00' AND p0_.date < '2026-03-31 23:59:59+09:00') AND p0_.discriminator_type IN ('holiday') LIMIT 1;
71	0.66 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
72	2.16 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"eccube_db"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'eccube_db' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
73	0.55 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
74	1.92 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"eccube_db"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'eccube_db' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
75	0.55 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
76	1.28 ms	SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"eccube_db" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'eccube_db' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
77	0.49 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
78	1.72 ms	SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'eccube_db' / ORDER BY k.ORDINAL_POSITION Parameters: [`"eccube_db" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'eccube_db' / ORDER BY k.ORDINAL_POSITION SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = 'eccube_db' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'eccube_db' / ORDER BY k.ORDINAL_POSITION;
79	1.87 ms	SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS TYPE, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS COMMENT, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS COLLATION FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION Parameters: [`"eccube_db" "eccube_db" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS TYPE, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS COMMENT, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS COLLATION FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS TYPE, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS COMMENT, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS COLLATION FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'eccube_db' AND t.TABLE_SCHEMA = 'eccube_db' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
80	0.53 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
81	1.60 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX Parameters: [`"eccube_db" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'eccube_db' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
82	0.60 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
83	0.52 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
84	0.66 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: [] View formatted query View runnable query Explain query 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') 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');
85	0.60 ms	SELECT t0.id AS id_1, t0.rich_snippet_flg AS rich_snippet_flg_2, t0.sns_flg AS sns_flg_3, t0.sitemap_flg AS sitemap_flg_4, t0.pagination_flg AS pagination_flg_5, t0.breadcrumb_flg AS breadcrumb_flg_6, t0.facebook_flg AS facebook_flg_7, t0.twitter_flg AS twitter_flg_8, t0.line_flg AS line_flg_9, t0.shop_name_top_flg AS shop_name_top_flg_10, t0.shop_name_product_flg AS shop_name_product_flg_11, t0.global_id_flg AS global_id_flg_12, t0.global_id_type AS global_id_type_13, t0.valid_price_flg AS valid_price_flg_14, t0.valid_price_month AS valid_price_month_15, t0.canonical_flg AS canonical_flg_16 FROM plg_seoallone_config t0 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.rich_snippet_flg AS rich_snippet_flg_2, t0.sns_flg AS sns_flg_3, t0.sitemap_flg AS sitemap_flg_4, t0.pagination_flg AS pagination_flg_5, t0.breadcrumb_flg AS breadcrumb_flg_6, t0.facebook_flg AS facebook_flg_7, t0.twitter_flg AS twitter_flg_8, t0.line_flg AS line_flg_9, t0.shop_name_top_flg AS shop_name_top_flg_10, t0.shop_name_product_flg AS shop_name_product_flg_11, t0.global_id_flg AS global_id_flg_12, t0.global_id_type AS global_id_type_13, t0.valid_price_flg AS valid_price_flg_14, t0.valid_price_month AS valid_price_month_15, t0.canonical_flg AS canonical_flg_16 FROM plg_seoallone_config t0 LIMIT 1 SELECT t0.id AS id_1, t0.rich_snippet_flg AS rich_snippet_flg_2, t0.sns_flg AS sns_flg_3, t0.sitemap_flg AS sitemap_flg_4, t0.pagination_flg AS pagination_flg_5, t0.breadcrumb_flg AS breadcrumb_flg_6, t0.facebook_flg AS facebook_flg_7, t0.twitter_flg AS twitter_flg_8, t0.line_flg AS line_flg_9, t0.shop_name_top_flg AS shop_name_top_flg_10, t0.shop_name_product_flg AS shop_name_product_flg_11, t0.global_id_flg AS global_id_flg_12, t0.global_id_type AS global_id_type_13, t0.valid_price_flg AS valid_price_flg_14, t0.valid_price_month AS valid_price_month_15, t0.canonical_flg AS canonical_flg_16 FROM plg_seoallone_config t0 LIMIT 1;

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.
Plugin\AmazonPayV2_42\Entity\Config	No errors.
Plugin\Karte\Entity\KarteConfig	No errors.
Plugin\ApgProductClassImage42\Entity\Config	No errors.
Plugin\DeliveryDate42\Entity\DeliveryDateConfig	No errors.
Plugin\DeliveryDate42\Entity\Holiday	No errors.
Eccube\Entity\Plugin	No errors.
Plugin\SEOAllOne42\Entity\Config	No errors.

Symfony Profiler

https://renewal.pamouna-shop.com/mypage/login

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

https://renewal.pamouna-shop.com/mypage/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping