Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

66 Database Queries

8 Different statements

11.60 ms Query time

1 Invalid entities

Queries

Group similar statements


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.authentication_key AS authentication_key_29, t0.php_path AS php_path_30, t0.option_point AS option_point_31, t0.basic_point_rate AS basic_point_rate_32, t0.point_conversion_rate AS point_conversion_rate_33, t0.email_bcc AS email_bcc_34, t0.site_kit_site_id AS site_kit_site_id_35, t0.site_kit_site_secret AS site_kit_site_secret_36, t0.country_id AS country_id_37, t0.pref_id AS pref_id_38, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
SELECT t0.id AS id_1, t0.point AS point_2, t0.first_order_point AS first_order_point_3, t0.start_time AS start_time_4 FROM plg_entry_point t0
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')
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
"START TRANSACTION"
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

#▲	Time	Info
1	0.16 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.12 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.authentication_key AS authentication_key_29, t0.php_path AS php_path_30, t0.option_point AS option_point_31, t0.basic_point_rate AS basic_point_rate_32, t0.point_conversion_rate AS point_conversion_rate_33, t0.email_bcc AS email_bcc_34, t0.site_kit_site_id AS site_kit_site_id_35, t0.site_kit_site_secret AS site_kit_site_secret_36, t0.country_id AS country_id_37, t0.pref_id AS pref_id_38, 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.authentication_key AS authentication_key_29, t0.php_path AS php_path_30, t0.option_point AS option_point_31, t0.basic_point_rate AS basic_point_rate_32, t0.point_conversion_rate AS point_conversion_rate_33, t0.email_bcc AS email_bcc_34, t0.site_kit_site_id AS site_kit_site_id_35, t0.site_kit_site_secret AS site_kit_site_secret_36, t0.country_id AS country_id_37, t0.pref_id AS pref_id_38, 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.authentication_key AS authentication_key_29, t0.php_path AS php_path_30, t0.option_point AS option_point_31, t0.basic_point_rate AS basic_point_rate_32, t0.point_conversion_rate AS point_conversion_rate_33, t0.email_bcc AS email_bcc_34, t0.site_kit_site_id AS site_kit_site_id_35, t0.site_kit_site_secret AS site_kit_site_secret_36, t0.country_id AS country_id_37, t0.pref_id AS pref_id_38, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = 1 AND t0.discriminator_type IN ('baseinfo');
3	0.07 ms	SELECT t0.id AS id_1, t0.point AS point_2, t0.first_order_point AS first_order_point_3, t0.start_time AS start_time_4 FROM plg_entry_point t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.point AS point_2, t0.first_order_point AS first_order_point_3, t0.start_time AS start_time_4 FROM plg_entry_point t0 SELECT t0.id AS id_1, t0.point AS point_2, t0.first_order_point AS first_order_point_3, t0.start_time AS start_time_4 FROM plg_entry_point t0;
4	0.62 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: [`"block_businessday_calendar"`] 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 = 'block_businessday_calendar') AND d0_.discriminator_type IN ('page');
5	0.09 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.07 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
7	0.10 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;
8	0.32 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;
9	0.19 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;
10	0.18 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;
11	0.18 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;
12	0.18 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;
13	0.18 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;
14	0.20 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;
15	0.18 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;
16	0.18 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;
17	0.17 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;
18	0.17 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;
19	0.17 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;
20	0.17 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;
21	0.17 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;
22	0.17 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;
23	0.17 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;
24	0.17 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;
25	0.17 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;
26	0.17 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;
27	0.17 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;
28	0.17 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;
29	0.17 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;
30	0.17 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;
31	0.19 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;
32	0.17 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;
33	0.17 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;
34	0.17 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;
35	0.17 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;
36	0.17 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;
37	0.17 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;
38	0.17 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;
39	0.17 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;
40	0.17 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;
41	0.17 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;
42	0.17 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;
43	0.18 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;
44	0.17 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;
45	0.17 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;
46	0.17 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;
47	0.17 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;
48	0.17 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;
49	0.17 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;
50	0.17 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;
51	0.17 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;
52	0.17 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;
53	0.20 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;
54	0.17 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;
55	0.17 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;
56	0.17 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;
57	0.17 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;
58	0.19 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;
59	0.17 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;
60	0.17 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;
61	0.17 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;
62	0.17 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;
63	0.17 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;
64	0.17 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;
65	0.17 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;
66	0.19 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;

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\Product	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.
Plugin\PointExDx\Entity\EntryPoint	No errors.
Eccube\Entity\Page	No errors.
Eccube\Entity\PageLayout	No errors.
Eccube\Entity\Block	No errors.
Eccube\Entity\BlockPosition	No errors.
Eccube\Entity\Master\DeviceType	No errors.
Eccube\Entity\AuthorityRole	No errors.
Eccube\Entity\Layout	No errors.
Eccube\Entity\Order	The field Eccube\Entity\Order#orderPointExDx is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Plugin\PointExDx\Entity\OrderPointExDx#Order does not contain the required 'inversedBy="orderPointExDx"' attribute. The mappings Eccube\Entity\Order#AmazonPayV2AmazonTradings and Plugin\AmazonPayV2_42\Entity\AmazonTrading#Order are inconsistent with each other.
Eccube\Entity\Customer	No errors.
Plugin\DeliveryDate42\Entity\DeliveryDateConfig	No errors.
Plugin\DeliveryDate42\Entity\Holiday	No errors.

Symfony Profiler

https://hieiyuba.xyz/block/businessday_calendar

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping