https://stage.neue-zeile.com/restock_mail/send

Method
GET
HTTP Status
200
IP
183.90.231.105
Profiled on
Token
8a3662

Query Metrics

38 Database Queries
20 Different statements
27.97 ms Query time
2 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.52 ms 
SET SESSION time_zone = '+00:00'
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 2.52 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.option_product_tax_rule AS option_product_tax_rule_25, t0.option_customer_activate AS option_customer_activate_26, t0.option_remember_me AS option_remember_me_27, t0.authentication_key AS authentication_key_28, t0.php_path AS php_path_29, t0.option_point AS option_point_30, t0.basic_point_rate AS basic_point_rate_31, t0.point_conversion_rate AS point_conversion_rate_32, t0.joolen_always_member_registration_point AS joolen_always_member_registration_point_33, t0.member_registration_point AS member_registration_point_34, t0.apply_datetime_start AS apply_datetime_start_35, t0.apply_datetime_end AS apply_datetime_end_36, t0.joolen_include_receiving_mail_magazine AS joolen_include_receiving_mail_magazine_37, t0.country_id AS country_id_38, t0.pref_id AS pref_id_39, 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
3 0.50 ms 
SELECT t0.id AS id_1, t0.cancelable_day AS cancelable_day_2, t0.cancelable_time AS cancelable_time_3, t0.cancelable_type AS cancelable_type_4 FROM plg_cancel_plugin_config t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
4 0.54 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.code = ? AND t0.discriminator_type IN ('plugin') LIMIT 1
Parameters: 
[
  "MailMagazine4"
]
View formatted query    View runnable query    Explain query
5 0.52 ms 
SELECT p0_.id AS id_0, p0_.insert_content_type AS insert_content_type_1, p0_.url_type AS url_type_2 FROM plg_apg_rich_category_config p0_ WHERE p0_.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
6 0.82 ms 
SELECT d0_.plg_slug AS plg_slug_0 FROM dtb_category d0_ WHERE d0_.discriminator_type IN ('category')
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 0.73 ms 
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.hierarchy AS hierarchy_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.plg_content AS plg_content_7, t0.plg_meta_description AS plg_meta_description_8, t0.plg_file_name AS plg_file_name_9, t0.plg_slug AS plg_slug_10, t0.parent_category_id AS parent_category_id_11, t0.creator_id AS creator_id_12, t0.schedule_time_id AS schedule_time_id_13, t0.discriminator_type FROM dtb_category t0 WHERE t0.plg_slug = ? AND t0.discriminator_type IN ('category') LIMIT 1
Parameters: 
[
  "restock_mail/send"
]
View formatted query    View runnable query    Explain query
8 0.77 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, d0_.schedule_time_id AS schedule_time_id_21, d1_.discriminator_type AS discriminator_type_22, d1_.page_id AS page_id_23, d1_.layout_id AS layout_id_24, d2_.discriminator_type AS discriminator_type_25, d2_.device_type_id AS device_type_id_26 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: 
[
  "restock_mail_send"
]
View formatted query    View runnable query    Explain query
9 0.13 ms 
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters: 
[]
View formatted query    View runnable query    Explain query
10 0.03 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
11 0.64 ms 
SELECT t0.id AS id_1, t0.subject AS subject_2, t0.code AS code_3, t0.create_date AS create_date_4, t0.update_date AS update_date_5 FROM plg_restock_mail_config t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
12 3.67 ms 
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM plg_restock_mail p0_ INNER JOIN dtb_product d1_ ON p0_.product_id = d1_.id AND d1_.discriminator_type IN ('product') INNER JOIN dtb_product_class d2_ ON d1_.id = d2_.product_id AND d2_.discriminator_type IN ('productclass') INNER JOIN dtb_customer d3_ ON p0_.customer_id = d3_.id AND d3_.discriminator_type IN ('customer') WHERE p0_.status_id IN (?)
Parameters: 
[
  [
    2
  ]
]
View formatted query    View runnable query    Explain query
13 0.97 ms 
SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM plg_restock_mail p0_ INNER JOIN dtb_product d1_ ON p0_.product_id = d1_.id AND d1_.discriminator_type IN ('product') INNER JOIN dtb_product_class d2_ ON d1_.id = d2_.product_id AND d2_.discriminator_type IN ('productclass') INNER JOIN dtb_customer d3_ ON p0_.customer_id = d3_.id AND d3_.discriminator_type IN ('customer') WHERE p0_.status_id IN (?) ORDER BY p0_.id DESC LIMIT 150
Parameters: 
[
  [
    2
  ]
]
View formatted query    View runnable query    Explain query
14 1.82 ms 
SELECT p0_.id AS id_0, p0_.product_code AS product_code_1, p0_.product_class_id AS product_class_id_2, p0_.create_date AS create_date_3, p0_.update_date AS update_date_4, p0_.send_date AS send_date_5, d1_.id AS id_6, d1_.name AS name_7, d1_.note AS note_8, d1_.description_list AS description_list_9, d1_.description_detail AS description_detail_10, d1_.search_word AS search_word_11, d1_.free_area AS free_area_12, d1_.create_date AS create_date_13, d1_.update_date AS update_date_14, d1_.slug AS slug_15, d1_.grouping_code AS grouping_code_16, d1_.priority_flag AS priority_flag_17, d1_.shipping_name AS shipping_name_18, d1_.plg_pu_private AS plg_pu_private_19, d1_.plg_pu_private_key AS plg_pu_private_key_20, d1_.plg_pu_publish_date AS plg_pu_publish_date_21, d1_.free_description_about_quantity AS free_description_about_quantity_22, d1_.free_description_about_selling_price AS free_description_about_selling_price_23, d1_.free_description_of_payment_delivery AS free_description_of_payment_delivery_24, d2_.id AS id_25, d2_.product_code AS product_code_26, d2_.stock AS stock_27, d2_.stock_unlimited AS stock_unlimited_28, d2_.sale_limit AS sale_limit_29, d2_.price01 AS price01_30, d2_.price02 AS price02_31, d2_.delivery_fee AS delivery_fee_32, d2_.visible AS visible_33, d2_.create_date AS create_date_34, d2_.update_date AS update_date_35, d2_.currency_code AS currency_code_36, d2_.point_rate AS point_rate_37, d3_.id AS id_38, d3_.name01 AS name01_39, d3_.name02 AS name02_40, d3_.kana01 AS kana01_41, d3_.kana02 AS kana02_42, d3_.company_name AS company_name_43, d3_.postal_code AS postal_code_44, d3_.addr01 AS addr01_45, d3_.addr02 AS addr02_46, d3_.email AS email_47, d3_.phone_number AS phone_number_48, d3_.birth AS birth_49, d3_.password AS password_50, d3_.salt AS salt_51, d3_.secret_key AS secret_key_52, d3_.first_buy_date AS first_buy_date_53, d3_.last_buy_date AS last_buy_date_54, d3_.buy_times AS buy_times_55, d3_.buy_total AS buy_total_56, d3_.note AS note_57, d3_.reset_key AS reset_key_58, d3_.reset_expire AS reset_expire_59, d3_.point AS point_60, d3_.create_date AS create_date_61, d3_.update_date AS update_date_62, d3_.memo AS memo_63, d3_.gmo_epsilon_credit_card_expiration_date AS gmo_epsilon_credit_card_expiration_date_64, d3_.card_change_request_mail_send_date AS card_change_request_mail_send_date_65, d3_.plg_mailmagazine_flg AS plg_mailmagazine_flg_66, p0_.product_id AS product_id_67, p0_.customer_id AS customer_id_68, p0_.status_id AS status_id_69, d1_.discriminator_type AS discriminator_type_70, d1_.creator_id AS creator_id_71, d1_.product_status_id AS product_status_id_72, d1_.schedule_time_id AS schedule_time_id_73, d2_.discriminator_type AS discriminator_type_74, d2_.product_id AS product_id_75, d2_.sale_type_id AS sale_type_id_76, d2_.class_category_id1 AS class_category_id1_77, d2_.class_category_id2 AS class_category_id2_78, d2_.delivery_duration_id AS delivery_duration_id_79, d2_.creator_id AS creator_id_80, d2_.regular_discount_id AS regular_discount_id_81, d3_.discriminator_type AS discriminator_type_82, d3_.customer_status_id AS customer_status_id_83, d3_.sex_id AS sex_id_84, d3_.job_id AS job_id_85, d3_.country_id AS country_id_86, d3_.pref_id AS pref_id_87 FROM plg_restock_mail p0_ INNER JOIN dtb_product d1_ ON p0_.product_id = d1_.id AND d1_.discriminator_type IN ('product') INNER JOIN dtb_product_class d2_ ON d1_.id = d2_.product_id AND d2_.discriminator_type IN ('productclass') INNER JOIN dtb_customer d3_ ON p0_.customer_id = d3_.id AND d3_.discriminator_type IN ('customer') WHERE p0_.status_id IN (?) AND p0_.id IN (?) ORDER BY p0_.id DESC
Parameters: 
[
  [
    2
  ]
  [
    23
    21
    20
    17
    14
    9
    4
  ]
]
View formatted query    View runnable query    Explain query
15 0.71 ms 
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.product_class_id AS product_class_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
[
  10944
]
View formatted query    View runnable query    Explain query
16 0.36 ms 
SELECT t0.id AS id_1, t0.tax_rate AS tax_rate_2, t0.tax_adjust AS tax_adjust_3, t0.apply_date AS apply_date_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.product_class_id AS product_class_id_7, t0.creator_id AS creator_id_8, t0.country_id AS country_id_9, t0.pref_id AS pref_id_10, t0.product_id AS product_id_11, t0.rounding_type_id AS rounding_type_id_12, t0.discriminator_type FROM dtb_tax_rule t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('taxrule')
Parameters: 
[
  10944
]
View formatted query    View runnable query    Explain query
17 0.32 ms 
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.product_class_id AS product_class_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
[
  5979
]
View formatted query    View runnable query    Explain query
18 0.87 ms 
SELECT d0_.id AS id_0, d0_.tax_rate AS tax_rate_1, d0_.tax_adjust AS tax_adjust_2, d0_.apply_date AS apply_date_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.discriminator_type AS discriminator_type_6, d0_.product_class_id AS product_class_id_7, d0_.creator_id AS creator_id_8, d0_.country_id AS country_id_9, d0_.pref_id AS pref_id_10, d0_.product_id AS product_id_11, d0_.rounding_type_id AS rounding_type_id_12 FROM dtb_tax_rule d0_ WHERE (d0_.apply_date < ? AND d0_.pref_id IS NULL AND d0_.country_id IS NULL AND d0_.product_id IS NULL AND d0_.product_class_id IS NULL) AND d0_.discriminator_type IN ('taxrule') ORDER BY d0_.apply_date DESC
Parameters: 
[
  "2024-07-03 22:00:04"
]
View formatted query    View runnable query    Explain query
19 6.47 ms 
SELECT t0.id AS id_1, t0.tax_rate AS tax_rate_2, t0.tax_adjust AS tax_adjust_3, t0.apply_date AS apply_date_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.product_class_id AS product_class_id_7, t0.creator_id AS creator_id_8, t0.country_id AS country_id_9, t0.pref_id AS pref_id_10, t0.product_id AS product_id_11, t0.rounding_type_id AS rounding_type_id_12, t0.discriminator_type FROM dtb_tax_rule t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('taxrule')
Parameters: 
[
  5979
]
View formatted query    View runnable query    Explain query
20 0.31 ms 
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.product_class_id AS product_class_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
[
  9922
]
View formatted query    View runnable query    Explain query
21 0.22 ms 
SELECT t0.id AS id_1, t0.tax_rate AS tax_rate_2, t0.tax_adjust AS tax_adjust_3, t0.apply_date AS apply_date_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.product_class_id AS product_class_id_7, t0.creator_id AS creator_id_8, t0.country_id AS country_id_9, t0.pref_id AS pref_id_10, t0.product_id AS product_id_11, t0.rounding_type_id AS rounding_type_id_12, t0.discriminator_type FROM dtb_tax_rule t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('taxrule')
Parameters: 
[
  9922
]
View formatted query    View runnable query    Explain query
22 0.23 ms 
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.product_class_id AS product_class_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
[
  8539
]
View formatted query    View runnable query    Explain query
23 0.22 ms 
SELECT t0.id AS id_1, t0.tax_rate AS tax_rate_2, t0.tax_adjust AS tax_adjust_3, t0.apply_date AS apply_date_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.product_class_id AS product_class_id_7, t0.creator_id AS creator_id_8, t0.country_id AS country_id_9, t0.pref_id AS pref_id_10, t0.product_id AS product_id_11, t0.rounding_type_id AS rounding_type_id_12, t0.discriminator_type FROM dtb_tax_rule t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('taxrule')
Parameters: 
[
  8539
]
View formatted query    View runnable query    Explain query
24 0.22 ms 
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.product_class_id AS product_class_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
[
  11900
]
View formatted query    View runnable query    Explain query
25 0.23 ms 
SELECT t0.id AS id_1, t0.tax_rate AS tax_rate_2, t0.tax_adjust AS tax_adjust_3, t0.apply_date AS apply_date_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.product_class_id AS product_class_id_7, t0.creator_id AS creator_id_8, t0.country_id AS country_id_9, t0.pref_id AS pref_id_10, t0.product_id AS product_id_11, t0.rounding_type_id AS rounding_type_id_12, t0.discriminator_type FROM dtb_tax_rule t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('taxrule')
Parameters: 
[
  11900
]
View formatted query    View runnable query    Explain query
26 0.22 ms 
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.product_class_id AS product_class_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
[
  5103
]
View formatted query    View runnable query    Explain query
27 0.22 ms 
SELECT t0.id AS id_1, t0.tax_rate AS tax_rate_2, t0.tax_adjust AS tax_adjust_3, t0.apply_date AS apply_date_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.product_class_id AS product_class_id_7, t0.creator_id AS creator_id_8, t0.country_id AS country_id_9, t0.pref_id AS pref_id_10, t0.product_id AS product_id_11, t0.rounding_type_id AS rounding_type_id_12, t0.discriminator_type FROM dtb_tax_rule t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('taxrule')
Parameters: 
[
  5103
]
View formatted query    View runnable query    Explain query
28 0.21 ms 
SELECT t0.id AS id_1, t0.stock AS stock_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.product_class_id AS product_class_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_stock t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('productstock')
Parameters: 
[
  2449
]
View formatted query    View runnable query    Explain query
29 0.21 ms 
SELECT t0.id AS id_1, t0.tax_rate AS tax_rate_2, t0.tax_adjust AS tax_adjust_3, t0.apply_date AS apply_date_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.product_class_id AS product_class_id_7, t0.creator_id AS creator_id_8, t0.country_id AS country_id_9, t0.pref_id AS pref_id_10, t0.product_id AS product_id_11, t0.rounding_type_id AS rounding_type_id_12, t0.discriminator_type FROM dtb_tax_rule t0 WHERE t0.product_class_id = ? AND t0.discriminator_type IN ('taxrule')
Parameters: 
[
  2449
]
View formatted query    View runnable query    Explain query
30 0.57 ms 
SELECT d0_.id AS id_0, d0_.product_code AS product_code_1, d0_.stock AS stock_2, d0_.stock_unlimited AS stock_unlimited_3, d0_.sale_limit AS sale_limit_4, d0_.price01 AS price01_5, d0_.price02 AS price02_6, d0_.delivery_fee AS delivery_fee_7, d0_.visible AS visible_8, d0_.create_date AS create_date_9, d0_.update_date AS update_date_10, d0_.currency_code AS currency_code_11, d0_.point_rate AS point_rate_12, d0_.discriminator_type AS discriminator_type_13, d0_.product_id AS product_id_14, d0_.sale_type_id AS sale_type_id_15, d0_.class_category_id1 AS class_category_id1_16, d0_.class_category_id2 AS class_category_id2_17, d0_.delivery_duration_id AS delivery_duration_id_18, d0_.creator_id AS creator_id_19, d0_.regular_discount_id AS regular_discount_id_20 FROM dtb_product_class d0_ WHERE (d0_.id = ?) AND d0_.discriminator_type IN ('productclass')
Parameters: 
[
  10944
]
View formatted query    View runnable query    Explain query
31 0.18 ms 
SELECT d0_.id AS id_0, d0_.product_code AS product_code_1, d0_.stock AS stock_2, d0_.stock_unlimited AS stock_unlimited_3, d0_.sale_limit AS sale_limit_4, d0_.price01 AS price01_5, d0_.price02 AS price02_6, d0_.delivery_fee AS delivery_fee_7, d0_.visible AS visible_8, d0_.create_date AS create_date_9, d0_.update_date AS update_date_10, d0_.currency_code AS currency_code_11, d0_.point_rate AS point_rate_12, d0_.discriminator_type AS discriminator_type_13, d0_.product_id AS product_id_14, d0_.sale_type_id AS sale_type_id_15, d0_.class_category_id1 AS class_category_id1_16, d0_.class_category_id2 AS class_category_id2_17, d0_.delivery_duration_id AS delivery_duration_id_18, d0_.creator_id AS creator_id_19, d0_.regular_discount_id AS regular_discount_id_20 FROM dtb_product_class d0_ WHERE (d0_.id = ?) AND d0_.discriminator_type IN ('productclass')
Parameters: 
[
  5979
]
View formatted query    View runnable query    Explain query
32 0.18 ms 
SELECT d0_.id AS id_0, d0_.product_code AS product_code_1, d0_.stock AS stock_2, d0_.stock_unlimited AS stock_unlimited_3, d0_.sale_limit AS sale_limit_4, d0_.price01 AS price01_5, d0_.price02 AS price02_6, d0_.delivery_fee AS delivery_fee_7, d0_.visible AS visible_8, d0_.create_date AS create_date_9, d0_.update_date AS update_date_10, d0_.currency_code AS currency_code_11, d0_.point_rate AS point_rate_12, d0_.discriminator_type AS discriminator_type_13, d0_.product_id AS product_id_14, d0_.sale_type_id AS sale_type_id_15, d0_.class_category_id1 AS class_category_id1_16, d0_.class_category_id2 AS class_category_id2_17, d0_.delivery_duration_id AS delivery_duration_id_18, d0_.creator_id AS creator_id_19, d0_.regular_discount_id AS regular_discount_id_20 FROM dtb_product_class d0_ WHERE (d0_.id = ?) AND d0_.discriminator_type IN ('productclass')
Parameters: 
[
  9922
]
View formatted query    View runnable query    Explain query
33 0.17 ms 
SELECT d0_.id AS id_0, d0_.product_code AS product_code_1, d0_.stock AS stock_2, d0_.stock_unlimited AS stock_unlimited_3, d0_.sale_limit AS sale_limit_4, d0_.price01 AS price01_5, d0_.price02 AS price02_6, d0_.delivery_fee AS delivery_fee_7, d0_.visible AS visible_8, d0_.create_date AS create_date_9, d0_.update_date AS update_date_10, d0_.currency_code AS currency_code_11, d0_.point_rate AS point_rate_12, d0_.discriminator_type AS discriminator_type_13, d0_.product_id AS product_id_14, d0_.sale_type_id AS sale_type_id_15, d0_.class_category_id1 AS class_category_id1_16, d0_.class_category_id2 AS class_category_id2_17, d0_.delivery_duration_id AS delivery_duration_id_18, d0_.creator_id AS creator_id_19, d0_.regular_discount_id AS regular_discount_id_20 FROM dtb_product_class d0_ WHERE (d0_.id = ?) AND d0_.discriminator_type IN ('productclass')
Parameters: 
[
  8539
]
View formatted query    View runnable query    Explain query
34 0.21 ms 
SELECT d0_.id AS id_0, d0_.product_code AS product_code_1, d0_.stock AS stock_2, d0_.stock_unlimited AS stock_unlimited_3, d0_.sale_limit AS sale_limit_4, d0_.price01 AS price01_5, d0_.price02 AS price02_6, d0_.delivery_fee AS delivery_fee_7, d0_.visible AS visible_8, d0_.create_date AS create_date_9, d0_.update_date AS update_date_10, d0_.currency_code AS currency_code_11, d0_.point_rate AS point_rate_12, d0_.discriminator_type AS discriminator_type_13, d0_.product_id AS product_id_14, d0_.sale_type_id AS sale_type_id_15, d0_.class_category_id1 AS class_category_id1_16, d0_.class_category_id2 AS class_category_id2_17, d0_.delivery_duration_id AS delivery_duration_id_18, d0_.creator_id AS creator_id_19, d0_.regular_discount_id AS regular_discount_id_20 FROM dtb_product_class d0_ WHERE (d0_.id = ?) AND d0_.discriminator_type IN ('productclass')
Parameters: 
[
  11900
]
View formatted query    View runnable query    Explain query
35 0.18 ms 
SELECT d0_.id AS id_0, d0_.product_code AS product_code_1, d0_.stock AS stock_2, d0_.stock_unlimited AS stock_unlimited_3, d0_.sale_limit AS sale_limit_4, d0_.price01 AS price01_5, d0_.price02 AS price02_6, d0_.delivery_fee AS delivery_fee_7, d0_.visible AS visible_8, d0_.create_date AS create_date_9, d0_.update_date AS update_date_10, d0_.currency_code AS currency_code_11, d0_.point_rate AS point_rate_12, d0_.discriminator_type AS discriminator_type_13, d0_.product_id AS product_id_14, d0_.sale_type_id AS sale_type_id_15, d0_.class_category_id1 AS class_category_id1_16, d0_.class_category_id2 AS class_category_id2_17, d0_.delivery_duration_id AS delivery_duration_id_18, d0_.creator_id AS creator_id_19, d0_.regular_discount_id AS regular_discount_id_20 FROM dtb_product_class d0_ WHERE (d0_.id = ?) AND d0_.discriminator_type IN ('productclass')
Parameters: 
[
  5103
]
View formatted query    View runnable query    Explain query
36 0.17 ms 
SELECT d0_.id AS id_0, d0_.product_code AS product_code_1, d0_.stock AS stock_2, d0_.stock_unlimited AS stock_unlimited_3, d0_.sale_limit AS sale_limit_4, d0_.price01 AS price01_5, d0_.price02 AS price02_6, d0_.delivery_fee AS delivery_fee_7, d0_.visible AS visible_8, d0_.create_date AS create_date_9, d0_.update_date AS update_date_10, d0_.currency_code AS currency_code_11, d0_.point_rate AS point_rate_12, d0_.discriminator_type AS discriminator_type_13, d0_.product_id AS product_id_14, d0_.sale_type_id AS sale_type_id_15, d0_.class_category_id1 AS class_category_id1_16, d0_.class_category_id2 AS class_category_id2_17, d0_.delivery_duration_id AS delivery_duration_id_18, d0_.creator_id AS creator_id_19, d0_.regular_discount_id AS regular_discount_id_20 FROM dtb_product_class d0_ WHERE (d0_.id = ?) AND d0_.discriminator_type IN ('productclass')
Parameters: 
[
  2449
]
View formatted query    View runnable query    Explain query
37 0.58 ms 
SELECT t0.id AS id_1, t0.mente_mode AS mente_mode_2, t0.admin_close_flg AS admin_close_flg_3, t0.page_html AS page_html_4 FROM plg_simple_maintenance_config t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
38 0.52 ms 
SELECT t0.id AS id_1, t0.option_group_product_hidden AS option_group_product_hidden_2, t0.option_group_category_hidden AS option_group_category_hidden_3, t0.option1 AS option1_4, t0.rounding_type_id AS rounding_type_id_5, t0.discriminator_type FROM plg_customer_group_config t0 WHERE t0.id = ? AND t0.discriminator_type IN ('config')
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query

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\Category No errors.
Plugin\CustomerGroup\Entity\Config No errors.
Eccube\Entity\Product
  • The field Eccube\Entity\Product#CollectionProducts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Plugin\Collection\Entity\CollectionProduct#Product does not contain the required 'inversedBy="CollectionProducts"' attribute.
Eccube\Entity\ProductCategory No errors.
Plugin\Schedule\Entity\ScheduleTime No errors.
Plugin\SearchPlus\Entity\SearchPlusConfig No errors.
Plugin\ApgSimpleCalendar\Entity\Config No errors.
Plugin\ApgSimpleCalendar\Entity\Holiday No errors.
Plugin\CancelPlugin\Entity\Config No errors.
Eccube\Entity\MailTemplate No errors.
Eccube\Entity\MailHistory 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\CustomerGroupPrice\Entity\GroupPrice No errors.
Eccube\Entity\Master\OrderStatus No errors.
Eccube\Entity\ProductStock No errors.
Eccube\Entity\Plugin No errors.
Eccube\Entity\Page No errors.
Plugin\ProductPlus\Entity\ProductData No errors.
Plugin\ProductPlus\Entity\ProductDataDetail No errors.
Plugin\ApgRichCategory\Entity\Config No errors.
Eccube\Entity\Member 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\ClassCategory No errors.
Plugin\ProductReserve4\Entity\ProductClassExtra No errors.
Plugin\ProductReserve4\Entity\Config No errors.
Plugin\ProductReserve4\Entity\ProductExtra No errors.
Eccube\Entity\OrderItem No errors.
Eccube\Entity\Order No errors.
Eccube\Entity\Shipping No errors.
Plugin\ProductReserve4\Entity\ReserveOrder No errors.
Eccube\Entity\Customer No errors.
Plugin\RestockMail\Entity\RestockMailStatus No errors.
Plugin\RestockMail\Entity\RestockMail No errors.
Eccube\Entity\ProductClass
  • The field Eccube\Entity\ProductClass#ProductClassRegularCycle is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Plugin\EccubePaymentLite4\Entity\ProductClassRegularCycle#ProductClass does not contain the required 'inversedBy="ProductClassRegularCycle"' attribute.
Plugin\RestockMail\Entity\RestockMailConfig No errors.
Plugin\EccubePaymentLite4\Entity\Config No errors.
Plugin\MailMagazine4\Entity\MailMagazineSendHistory No errors.
Eccube\Entity\Master\ProductStatus No errors.
Eccube\Entity\Master\SaleType No errors.
Eccube\Entity\DeliveryDuration No errors.
Plugin\EccubePaymentLite4\Entity\RegularDiscount No errors.
Eccube\Entity\Master\CustomerStatus No errors.
Eccube\Entity\Master\Sex No errors.
Eccube\Entity\Master\Job No errors.
Eccube\Entity\ProductImage No errors.
Eccube\Entity\ProductTag No errors.
Eccube\Entity\CustomerFavoriteProduct No errors.
Plugin\Collection\Entity\CollectionProduct No errors.
Plugin\RelatedProduct4\Entity\RelatedProduct No errors.
Plugin\CustomerGroup\Entity\Group No errors.
Eccube\Entity\TaxRule No errors.
Eccube\Entity\Master\RoundingType No errors.
Plugin\EccubePaymentLite4\Entity\ProductClassRegularCycle No errors.
Eccube\Entity\CustomerAddress No errors.
Eccube\Entity\News No errors.
Plugin\Api\Entity\WebHook No errors.
Plugin\SimpleMaintenance\Entity\SimpleMConfig No errors.