https://shop.kaorime.co.jp/admin_kaorime/order

Method
GET
HTTP Status
200
IP
60.62.213.247
Profiled on
Token
8e90b2

Query Metrics

45 Database Queries
19 Different statements
19.54 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.16 ms 
SET SESSION time_zone = '+00:00'
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.10 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.department AS department_3, t0.login_id AS login_id_4, t0.password AS password_5, t0.salt AS salt_6, t0.sort_no AS sort_no_7, t0.two_factor_auth_key AS two_factor_auth_key_8, t0.two_factor_auth_enabled AS two_factor_auth_enabled_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.login_date AS login_date_12, t0.work_id AS work_id_13, t0.authority_id AS authority_id_14, t0.creator_id AS creator_id_15, t0.discriminator_type FROM dtb_member t0 WHERE t0.login_id = ? AND t0.work_id = ? AND t0.discriminator_type IN ('member') LIMIT 1
Parameters: 
[
  "motto"
  1
]
View formatted query    View runnable query    Explain query
3 0.16 ms 
SELECT t0.id AS id_1, t0.deny_url AS deny_url_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.authority_id AS authority_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_authority_role t0 WHERE t0.authority_id = ? AND t0.discriminator_type IN ('authorityrole')
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
4 0.16 ms 
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.invoice_registration_number AS invoice_registration_number_25, t0.option_product_tax_rule AS option_product_tax_rule_26, t0.option_customer_activate AS option_customer_activate_27, t0.option_remember_me AS option_remember_me_28, t0.option_mail_notifier AS option_mail_notifier_29, t0.authentication_key AS authentication_key_30, t0.php_path AS php_path_31, t0.option_point AS option_point_32, t0.basic_point_rate AS basic_point_rate_33, t0.point_conversion_rate AS point_conversion_rate_34, t0.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
5 0.09 ms 
SELECT t0.id AS id_1, t0.deny_url AS deny_url_2, t0.create_date AS create_date_3, t0.update_date AS update_date_4, t0.authority_id AS authority_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_authority_role t0 WHERE t0.authority_id = ? AND t0.discriminator_type IN ('authorityrole')
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
6 0.16 ms 
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 0.11 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
8 0.43 ms 
SELECT m0_.display_order_count AS display_order_count_0, m0_.id AS id_1, m0_.name AS name_2, m0_.sort_no AS sort_no_3, m0_.discriminator_type AS discriminator_type_4 FROM mtb_order_status m0_ WHERE m0_.discriminator_type IN ('orderstatus') ORDER BY m0_.sort_no ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
9 0.16 ms 
SELECT d0_.id AS id_0, d0_.payment_method AS payment_method_1, d0_.charge AS charge_2, d0_.rule_max AS rule_max_3, d0_.sort_no AS sort_no_4, d0_.fixed AS fixed_5, d0_.payment_image AS payment_image_6, d0_.rule_min AS rule_min_7, d0_.method_class AS method_class_8, d0_.visible AS visible_9, d0_.create_date AS create_date_10, d0_.update_date AS update_date_11, d0_.discriminator_type AS discriminator_type_12, d0_.creator_id AS creator_id_13 FROM dtb_payment d0_ WHERE d0_.discriminator_type IN ('payment') ORDER BY d0_.sort_no DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
10 0.16 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_page_max t0 WHERE t0.discriminator_type IN ('pagemax')
Parameters: 
[]
View formatted query    View runnable query    Explain query
11 2.04 ms 
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_order d0_ LEFT JOIN dtb_order_item d1_ ON d0_.id = d1_.order_id AND d1_.discriminator_type IN ('orderitem') LEFT JOIN mtb_pref m2_ ON d0_.pref_id = m2_.id AND m2_.discriminator_type IN ('pref') INNER JOIN dtb_shipping d3_ ON d0_.id = d3_.order_id AND d3_.discriminator_type IN ('shipping') WHERE (d0_.order_status_id NOT IN (?, ?)) AND d0_.discriminator_type IN ('order')
Parameters: 
[
  8
  7
]
View formatted query    View runnable query    Explain query
12 4.04 ms 
SELECT DISTINCT d0_.id AS id_0, d0_.update_date AS update_date_1, d0_.id AS id_2 FROM dtb_order d0_ LEFT JOIN dtb_order_item d1_ ON d0_.id = d1_.order_id AND d1_.discriminator_type IN ('orderitem') LEFT JOIN mtb_pref m2_ ON d0_.pref_id = m2_.id AND m2_.discriminator_type IN ('pref') INNER JOIN dtb_shipping d3_ ON d0_.id = d3_.order_id AND d3_.discriminator_type IN ('shipping') WHERE (d0_.order_status_id NOT IN (?, ?)) AND d0_.discriminator_type IN ('order') ORDER BY d0_.update_date DESC, d0_.id DESC LIMIT 50
Parameters: 
[
  8
  7
]
View formatted query    View runnable query    Explain query
13 6.87 ms 
SELECT d0_.id AS id_0, d0_.pre_order_id AS pre_order_id_1, d0_.order_no AS order_no_2, d0_.message AS message_3, d0_.name01 AS name01_4, d0_.name02 AS name02_5, d0_.kana01 AS kana01_6, d0_.kana02 AS kana02_7, d0_.company_name AS company_name_8, d0_.email AS email_9, d0_.phone_number AS phone_number_10, d0_.postal_code AS postal_code_11, d0_.addr01 AS addr01_12, d0_.addr02 AS addr02_13, d0_.birth AS birth_14, d0_.subtotal AS subtotal_15, d0_.discount AS discount_16, d0_.delivery_fee_total AS delivery_fee_total_17, d0_.charge AS charge_18, d0_.tax AS tax_19, d0_.total AS total_20, d0_.payment_total AS payment_total_21, d0_.payment_method AS payment_method_22, d0_.note AS note_23, d0_.create_date AS create_date_24, d0_.update_date AS update_date_25, d0_.order_date AS order_date_26, d0_.payment_date AS payment_date_27, d0_.currency_code AS currency_code_28, d0_.complete_message AS complete_message_29, d0_.complete_mail_message AS complete_mail_message_30, d0_.add_point AS add_point_31, d0_.use_point AS use_point_32, d1_.id AS id_33, d1_.product_name AS product_name_34, d1_.product_code AS product_code_35, d1_.class_name1 AS class_name1_36, d1_.class_name2 AS class_name2_37, d1_.class_category_name1 AS class_category_name1_38, d1_.class_category_name2 AS class_category_name2_39, d1_.price AS price_40, d1_.quantity AS quantity_41, d1_.tax AS tax_42, d1_.tax_rate AS tax_rate_43, d1_.tax_adjust AS tax_adjust_44, d1_.tax_rule_id AS tax_rule_id_45, d1_.currency_code AS currency_code_46, d1_.processor_name AS processor_name_47, d1_.point_rate AS point_rate_48, m2_.id AS id_49, m2_.name AS name_50, m2_.sort_no AS sort_no_51, d3_.id AS id_52, d3_.name01 AS name01_53, d3_.name02 AS name02_54, d3_.kana01 AS kana01_55, d3_.kana02 AS kana02_56, d3_.company_name AS company_name_57, d3_.phone_number AS phone_number_58, d3_.postal_code AS postal_code_59, d3_.addr01 AS addr01_60, d3_.addr02 AS addr02_61, d3_.delivery_name AS delivery_name_62, d3_.time_id AS time_id_63, d3_.delivery_time AS delivery_time_64, d3_.delivery_date AS delivery_date_65, d3_.shipping_date AS shipping_date_66, d3_.tracking_number AS tracking_number_67, d3_.note AS note_68, d3_.sort_no AS sort_no_69, d3_.create_date AS create_date_70, d3_.update_date AS update_date_71, d3_.mail_send_date AS mail_send_date_72, d0_.discriminator_type AS discriminator_type_73, d0_.customer_id AS customer_id_74, d0_.country_id AS country_id_75, d0_.pref_id AS pref_id_76, d0_.sex_id AS sex_id_77, d0_.job_id AS job_id_78, d0_.payment_id AS payment_id_79, d0_.device_type_id AS device_type_id_80, d0_.order_status_id AS order_status_id_81, d0_.order_status_id AS order_status_id_82, d0_.order_status_id AS order_status_id_83, d1_.discriminator_type AS discriminator_type_84, d1_.order_id AS order_id_85, d1_.product_id AS product_id_86, d1_.product_class_id AS product_class_id_87, d1_.shipping_id AS shipping_id_88, d1_.rounding_type_id AS rounding_type_id_89, d1_.tax_type_id AS tax_type_id_90, d1_.tax_display_type_id AS tax_display_type_id_91, d1_.order_item_type_id AS order_item_type_id_92, m2_.discriminator_type AS discriminator_type_93, d3_.discriminator_type AS discriminator_type_94, d3_.order_id AS order_id_95, d3_.country_id AS country_id_96, d3_.pref_id AS pref_id_97, d3_.delivery_id AS delivery_id_98, d3_.creator_id AS creator_id_99 FROM dtb_order d0_ LEFT JOIN dtb_order_item d1_ ON d0_.id = d1_.order_id AND d1_.discriminator_type IN ('orderitem') LEFT JOIN mtb_pref m2_ ON d0_.pref_id = m2_.id AND m2_.discriminator_type IN ('pref') INNER JOIN dtb_shipping d3_ ON d0_.id = d3_.order_id AND d3_.discriminator_type IN ('shipping') WHERE (d0_.order_status_id NOT IN (?, ?) AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND d0_.discriminator_type IN ('order') ORDER BY d0_.update_date DESC, d0_.id DESC
Parameters: 
[
  8
  7
  244
  245
  242
  243
  241
  236
  235
  234
  233
  232
  231
  227
  228
  226
  224
  223
  222
  221
  219
  216
  213
  214
  212
  211
  209
  205
  204
  161
  160
  156
  143
  35
  142
  141
  140
  138
  139
  135
  137
  127
  128
  130
  134
  125
  124
  109
  122
  119
  118
  117
]
View formatted query    View runnable query    Explain query
14 0.57 ms 
SELECT COALESCE(COUNT(d0_.id), 0) AS sclr_0 FROM dtb_order d0_ WHERE (d0_.order_status_id = ?) AND d0_.discriminator_type IN ('order')
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
15 0.21 ms 
SELECT COALESCE(COUNT(d0_.id), 0) AS sclr_0 FROM dtb_order d0_ WHERE (d0_.order_status_id = ?) AND d0_.discriminator_type IN ('order')
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
16 0.21 ms 
SELECT COALESCE(COUNT(d0_.id), 0) AS sclr_0 FROM dtb_order d0_ WHERE (d0_.order_status_id = ?) AND d0_.discriminator_type IN ('order')
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
17 0.13 ms 
SELECT t0.display_order_count AS display_order_count_1, t0.id AS id_2, t0.name AS name_3, t0.sort_no AS sort_no_4, t0.discriminator_type FROM mtb_order_status t0 WHERE t0.discriminator_type IN ('orderstatus') ORDER BY t0.sort_no ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
18 0.12 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "sagawa_delivtype_super"
]
View formatted query    View runnable query    Explain query
19 0.11 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "sagawa_delivtype_express"
]
View formatted query    View runnable query    Explain query
20 0.11 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "sagawa_delivtype_air"
]
View formatted query    View runnable query    Explain query
21 0.13 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "sagawa_delivtype_just"
]
View formatted query    View runnable query    Explain query
22 0.13 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "sagawa_delivtype_normal"
]
View formatted query    View runnable query    Explain query
23 0.13 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "b2_delivtype_dm"
]
View formatted query    View runnable query    Explain query
24 0.09 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "b2_delivtype_timeservice"
]
View formatted query    View runnable query    Explain query
25 0.08 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "b2_delivtype_express"
]
View formatted query    View runnable query    Explain query
26 0.07 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "b2_delivtype_necopos"
]
View formatted query    View runnable query    Explain query
27 0.06 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "b2_delivtype_compact"
]
View formatted query    View runnable query    Explain query
28 0.06 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "b2_delivtype_normal"
]
View formatted query    View runnable query    Explain query
29 0.06 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "sagawa_delivtype_mail"
]
View formatted query    View runnable query    Explain query
30 0.09 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "yuprir_delivtype_yupack"
]
View formatted query    View runnable query    Explain query
31 0.09 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "yuprir_delivtype_mail"
]
View formatted query    View runnable query    Explain query
32 0.08 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "yuprir_delivtype_normal"
]
View formatted query    View runnable query    Explain query
33 0.07 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "yuprir_delivtype_normal2"
]
View formatted query    View runnable query    Explain query
34 0.08 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "yuprir_delivtype_pospacket"
]
View formatted query    View runnable query    Explain query
35 0.14 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "yuprir_delivtype_label"
]
View formatted query    View runnable query    Explain query
36 0.11 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "yuprir_delivtype_yupacket"
]
View formatted query    View runnable query    Explain query
37 0.08 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivery_id AS delivery_id_3, t0.discriminator_type FROM plg_expresslink_dtb_delivtype t0 WHERE t0.name = ? AND t0.discriminator_type IN ('delivtype')
Parameters: 
[
  "km2_delivtype_normal"
]
View formatted query    View runnable query    Explain query
38 0.08 ms 
SELECT t0.name AS name_1, t0.value AS value_2, t0.discriminator_type FROM plg_expresslink_dtb_config t0 WHERE t0.name = ? AND t0.discriminator_type IN ('expresslinkconfig') LIMIT 1
Parameters: 
[
  "ehiden2_use"
]
View formatted query    View runnable query    Explain query
39 0.08 ms 
SELECT t0.name AS name_1, t0.value AS value_2, t0.discriminator_type FROM plg_expresslink_dtb_config t0 WHERE t0.name = ? AND t0.discriminator_type IN ('expresslinkconfig') LIMIT 1
Parameters: 
[
  "ehiden3_use"
]
View formatted query    View runnable query    Explain query
40 0.07 ms 
SELECT t0.name AS name_1, t0.value AS value_2, t0.discriminator_type FROM plg_expresslink_dtb_config t0 WHERE t0.name = ? AND t0.discriminator_type IN ('expresslinkconfig') LIMIT 1
Parameters: 
[
  "ehidenpro_use"
]
View formatted query    View runnable query    Explain query
41 0.08 ms 
SELECT t0.name AS name_1, t0.value AS value_2, t0.discriminator_type FROM plg_expresslink_dtb_config t0 WHERE t0.name = ? AND t0.discriminator_type IN ('expresslinkconfig') LIMIT 1
Parameters: 
[
  "depo_use"
]
View formatted query    View runnable query    Explain query
42 1.01 ms 
SELECT d0_.id AS id_0, d1_.id AS id_1, p2_.memo04 AS memo04_2 FROM dtb_shipping d0_ LEFT JOIN plg_vt4g_order_payment p2_ ON (p2_.order_id = d0_.order_id) INNER JOIN dtb_order d1_ ON (d1_.id = d0_.order_id) AND d1_.discriminator_type IN ('order') WHERE (d0_.id IN (246, 247, 244, 245, 243, 238, 237, 236, 235, 234, 233, 229, 230, 228, 226, 225, 224, 222, 220, 217, 214, 215, 213, 212, 210, 206, 205, 162, 161, 157, 144, 35, 143, 142, 141, 139, 140, 136, 138, 128, 129, 131, 135, 126, 125, 110, 123, 120, 119, 118)) AND d0_.discriminator_type IN ('shipping')
Parameters: 
[]
View formatted query    View runnable query    Explain query
43 0.20 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_order_status_color t0 WHERE t0.id = ? AND t0.discriminator_type IN ('orderstatuscolor')
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
44 0.10 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_order_status_color t0 WHERE t0.id = ? AND t0.discriminator_type IN ('orderstatuscolor')
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
45 0.31 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_pref t0 WHERE t0.id = ? AND t0.discriminator_type IN ('pref')
Parameters: 
[
  37
]
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\Product No errors.
Eccube\Entity\BaseInfo 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\AbstractMasterEntity No errors.
Eccube\Entity\Master\DeviceType No errors.
Eccube\Entity\AuthorityRole No errors.
Eccube\Entity\Layout No errors.
Eccube\Entity\Member No errors.
Eccube\Entity\Master\Work No errors.
Eccube\Entity\Master\Authority No errors.
Eccube\Entity\Master\Country No errors.
Eccube\Entity\Master\Pref No errors.
Eccube\Entity\ProductClass No errors.
Plugin\Coupon42\Entity\Coupon No errors.
Plugin\Coupon42\Entity\CouponOrder No errors.
Eccube\Entity\Category No errors.
Eccube\Entity\Master\TaxType No errors.
Eccube\Entity\Master\TaxDisplayType No errors.
Eccube\Entity\Master\OrderItemType No errors.
Eccube\Entity\OrderItem No errors.
Eccube\Entity\Order No errors.
Eccube\Entity\Master\OrderStatus No errors.
Eccube\Entity\Delivery No errors.
Eccube\Entity\Payment No errors.
Eccube\Entity\Csv No errors.
Eccube\Entity\Master\CsvType No errors.
Eccube\Entity\Shipping No errors.
Eccube\Entity\Customer No errors.
Eccube\Entity\Master\Sex No errors.
Eccube\Entity\Master\PageMax No errors.
Eccube\Entity\Master\ProductStatus No errors.
Eccube\Entity\ProductStock No errors.
Eccube\Entity\OrderPdf No errors.
Eccube\Entity\MailTemplate No errors.
Eccube\Entity\MailHistory No errors.
Eccube\Entity\PaymentOption No errors.
Eccube\Entity\Master\Job No errors.
Eccube\Entity\Master\CustomerOrderStatus No errors.
Eccube\Entity\Master\OrderStatusColor No errors.
Eccube\Entity\Master\RoundingType No errors.
Plugin\ExpressLink42\Entity\ExpressLinkConfig No errors.
Plugin\ExpressLink42\Entity\Cod No errors.
Plugin\ExpressLink42\Entity\Delivtype No errors.
Plugin\VeriTrans4G2\Entity\Vt4gOrderPayment No errors.