Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

206 Database Queries

30 Different statements

71.14 ms Query time

0 Invalid entities

Queries

Group similar statements


SET SESSION time_zone = '+00:00'
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
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')
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.country_id AS country_id_34, t0.pref_id AS pref_id_35, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
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')
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
"START TRANSACTION"
SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.description_list AS description_list_4, t0.description_detail AS description_detail_5, t0.search_word AS search_word_6, t0.free_area AS free_area_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.brand AS brand_10, t0.number AS number_11, t0.size AS size_12, t0.material AS material_13, t0.notification_email AS notification_email_14, t0.invalidity_period AS invalidity_period_15, t0.creator_id AS creator_id_16, t0.product_status_id AS product_status_id_17, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = ? AND t0.discriminator_type IN ('product')
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.product_id AS product_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC
INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?)
DELETE FROM dtb_product_image WHERE id = ?
SELECT t0.product_id AS product_id_1, t0.category_id AS category_id_2, t0.product_id AS product_id_3, t0.category_id AS category_id_4, t0.discriminator_type FROM dtb_product_category t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productcategory')
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category')
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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category')
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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category')
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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category')
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_id AS product_id_3, t0.tag_id AS tag_id_4, t0.creator_id AS creator_id_5, t0.discriminator_type FROM dtb_product_tag t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('producttag')
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.product_id AS product_id_14, t0.sale_type_id AS sale_type_id_15, t0.class_category_id1 AS class_category_id1_16, t0.class_category_id2 AS class_category_id2_17, t0.delivery_duration_id AS delivery_duration_id_18, t0.creator_id AS creator_id_19, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productclass')
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')
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')
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')
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
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')
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')
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')
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')
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')
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')
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')
INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_image WHERE id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_image WHERE id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_image WHERE id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_image WHERE id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.description_list AS description_list_4, t0.description_detail AS description_detail_5, t0.search_word AS search_word_6, t0.free_area AS free_area_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.brand AS brand_10, t0.number AS number_11, t0.size AS size_12, t0.material AS material_13, t0.notification_email AS notification_email_14, t0.invalidity_period AS invalidity_period_15, t0.creator_id AS creator_id_16, t0.product_status_id AS product_status_id_17, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = ? AND t0.discriminator_type IN ('product')
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.product_id AS product_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC
INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_image WHERE id = ?
SELECT t0.product_id AS product_id_1, t0.category_id AS category_id_2, t0.product_id AS product_id_3, t0.category_id AS category_id_4, t0.discriminator_type FROM dtb_product_category t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productcategory')
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_id AS product_id_3, t0.tag_id AS tag_id_4, t0.creator_id AS creator_id_5, t0.discriminator_type FROM dtb_product_tag t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('producttag')
SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.product_id AS product_id_14, t0.sale_type_id AS sale_type_id_15, t0.class_category_id1 AS class_category_id1_16, t0.class_category_id2 AS class_category_id2_17, t0.delivery_duration_id AS delivery_duration_id_18, t0.creator_id AS creator_id_19, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productclass')
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')
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')
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')
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')
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')
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')
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')
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')
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')
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')
INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_image WHERE id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_image WHERE id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_image WHERE id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_image WHERE id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ?
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?)
UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
DELETE FROM dtb_product_tag WHERE id = ?
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'xs355060_props' */ ORDER BY k.ORDINAL_POSITION
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE        AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
SELECT DATABASE()
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.discriminator_type IN ('plugin')

#▲	Time	Info
1	0.13 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	3.47 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: [`"ec_admin" 1`] View formatted query View runnable query Explain query 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 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 = 'ec_admin' AND t0.work_id = 1 AND t0.discriminator_type IN ('member') LIMIT 1;
3	4.50 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 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') 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 = 0 AND t0.discriminator_type IN ('authorityrole');
4	1.92 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.country_id AS country_id_34, t0.pref_id AS pref_id_35, 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.country_id AS country_id_34, t0.pref_id AS pref_id_35, 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.country_id AS country_id_34, t0.pref_id AS pref_id_35, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = 1 AND t0.discriminator_type IN ('baseinfo');
5	0.10 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 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') 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 = 0 AND t0.discriminator_type IN ('authorityrole');
6	0.14 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;
7	0.07 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
8	0.55 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.description_list AS description_list_4, t0.description_detail AS description_detail_5, t0.search_word AS search_word_6, t0.free_area AS free_area_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.brand AS brand_10, t0.number AS number_11, t0.size AS size_12, t0.material AS material_13, t0.notification_email AS notification_email_14, t0.invalidity_period AS invalidity_period_15, t0.creator_id AS creator_id_16, t0.product_status_id AS product_status_id_17, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = ? AND t0.discriminator_type IN ('product') Parameters: [`"3849"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.description_list AS description_list_4, t0.description_detail AS description_detail_5, t0.search_word AS search_word_6, t0.free_area AS free_area_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.brand AS brand_10, t0.number AS number_11, t0.size AS size_12, t0.material AS material_13, t0.notification_email AS notification_email_14, t0.invalidity_period AS invalidity_period_15, t0.creator_id AS creator_id_16, t0.product_status_id AS product_status_id_17, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = ? AND t0.discriminator_type IN ('product') SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.description_list AS description_list_4, t0.description_detail AS description_detail_5, t0.search_word AS search_word_6, t0.free_area AS free_area_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.brand AS brand_10, t0.number AS number_11, t0.size AS size_12, t0.material AS material_13, t0.notification_email AS notification_email_14, t0.invalidity_period AS invalidity_period_15, t0.creator_id AS creator_id_16, t0.product_status_id AS product_status_id_17, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = '3849' AND t0.discriminator_type IN ('product');
9	2.39 ms	SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.product_id AS product_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC Parameters: [`3849`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.product_id AS product_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.product_id AS product_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.product_id = 3849 AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC;
10	10.27 ms	INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?) Parameters: [`"an1778.jpg" 1 "2024-11-22 09:55:19" 3849 1 "productimage"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_image ( file_name, sort_no, create_date, product_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?, ?) INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES ('an1778.jpg', 1, '2024-11-22 09:55:19', 3849, 1, 'productimage');
11	0.22 ms	DELETE FROM dtb_product_image WHERE id = ? Parameters: [`1939580`] View formatted query View runnable query Explain query DELETE FROM dtb_product_image WHERE id = ? DELETE FROM dtb_product_image WHERE id = 1939580;
12	0.33 ms	SELECT t0.product_id AS product_id_1, t0.category_id AS category_id_2, t0.product_id AS product_id_3, t0.category_id AS category_id_4, t0.discriminator_type FROM dtb_product_category t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productcategory') Parameters: [`3849`] View formatted query View runnable query Explain query SELECT t0.product_id AS product_id_1, t0.category_id AS category_id_2, t0.product_id AS product_id_3, t0.category_id AS category_id_4, t0.discriminator_type FROM dtb_product_category t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productcategory') SELECT t0.product_id AS product_id_1, t0.category_id AS category_id_2, t0.product_id AS product_id_3, t0.category_id AS category_id_4, t0.discriminator_type FROM dtb_product_category t0 WHERE t0.product_id = 3849 AND t0.discriminator_type IN ('productcategory');
13	7.91 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 19`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 19;
14	0.28 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 57`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 57;
15	0.20 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 59`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 59;
16	0.18 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 131`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 131;
17	0.09 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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category') Parameters: [`19`] View formatted query View runnable query Explain query 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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category') 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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = 19 AND t0.discriminator_type IN ('category');
18	0.07 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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category') Parameters: [`131`] View formatted query View runnable query Explain query 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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category') 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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = 131 AND t0.discriminator_type IN ('category');
19	0.07 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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category') Parameters: [`57`] View formatted query View runnable query Explain query 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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category') 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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = 57 AND t0.discriminator_type IN ('category');
20	0.07 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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category') Parameters: [`59`] View formatted query View runnable query Explain query 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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category') 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.parent_category_id AS parent_category_id_7, t0.creator_id AS creator_id_8, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = 59 AND t0.discriminator_type IN ('category');
21	0.29 ms	SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_id AS product_id_3, t0.tag_id AS tag_id_4, t0.creator_id AS creator_id_5, t0.discriminator_type FROM dtb_product_tag t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('producttag') Parameters: [`3849`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_id AS product_id_3, t0.tag_id AS tag_id_4, t0.creator_id AS creator_id_5, t0.discriminator_type FROM dtb_product_tag t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('producttag') SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_id AS product_id_3, t0.tag_id AS tag_id_4, t0.creator_id AS creator_id_5, t0.discriminator_type FROM dtb_product_tag t0 WHERE t0.product_id = 3849 AND t0.discriminator_type IN ('producttag');
22	2.15 ms	SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.product_id AS product_id_14, t0.sale_type_id AS sale_type_id_15, t0.class_category_id1 AS class_category_id1_16, t0.class_category_id2 AS class_category_id2_17, t0.delivery_duration_id AS delivery_duration_id_18, t0.creator_id AS creator_id_19, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productclass') Parameters: [`3849`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.product_id AS product_id_14, t0.sale_type_id AS sale_type_id_15, t0.class_category_id1 AS class_category_id1_16, t0.class_category_id2 AS class_category_id2_17, t0.delivery_duration_id AS delivery_duration_id_18, t0.creator_id AS creator_id_19, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productclass') SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.product_id AS product_id_14, t0.sale_type_id AS sale_type_id_15, t0.class_category_id1 AS class_category_id1_16, t0.class_category_id2 AS class_category_id2_17, t0.delivery_duration_id AS delivery_duration_id_18, t0.creator_id AS creator_id_19, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = 3849 AND t0.discriminator_type IN ('productclass');
23	0.12 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: [`12815`] View formatted query View runnable query Explain query 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') 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 = 12815 AND t0.discriminator_type IN ('productstock');
24	0.09 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: [`12815`] View formatted query View runnable query Explain query 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') 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 = 12815 AND t0.discriminator_type IN ('taxrule');
25	0.08 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: [`12816`] View formatted query View runnable query Explain query 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') 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 = 12816 AND t0.discriminator_type IN ('productstock');
26	0.38 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-11-22 09:55:20"`] View formatted query View runnable query Explain query 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 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 < '2024-11-22 09:55:20' 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;
27	2.62 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: [`12816`] View formatted query View runnable query Explain query 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') 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 = 12816 AND t0.discriminator_type IN ('taxrule');
28	0.10 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: [`13881`] View formatted query View runnable query Explain query 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') 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 = 13881 AND t0.discriminator_type IN ('productstock');
29	0.10 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: [`13881`] View formatted query View runnable query Explain query 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') 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 = 13881 AND t0.discriminator_type IN ('taxrule');
30	0.09 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: [`13964`] View formatted query View runnable query Explain query 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') 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 = 13964 AND t0.discriminator_type IN ('productstock');
31	0.07 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: [`13964`] View formatted query View runnable query Explain query 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') 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 = 13964 AND t0.discriminator_type IN ('taxrule');
32	0.07 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: [`14047`] View formatted query View runnable query Explain query 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') 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 = 14047 AND t0.discriminator_type IN ('productstock');
33	0.07 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: [`14047`] View formatted query View runnable query Explain query 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') 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 = 14047 AND t0.discriminator_type IN ('taxrule');
34	0.22 ms	INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?) Parameters: [`"an1778.jpg" 1 "2024-11-22 09:55:20" 3849 1 "productimage"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_image ( file_name, sort_no, create_date, product_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?, ?) INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES ('an1778.jpg', 1, '2024-11-22 09:55:20', 3849, 1, 'productimage');
35	4.94 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 3849 83 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 3849, 83, 1, 'producttag');
36	0.18 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 3849 36 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 3849, 36, 1, 'producttag');
37	0.14 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 131 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 131, 'productcategory');
38	0.11 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 19 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 19, 'productcategory');
39	0.10 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 57 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 57, 'productcategory');
40	0.09 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 59 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 59, 'productcategory');
41	4.07 ms	UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? Parameters: [`"3000" "3000" "2024-11-22 09:55:20" 12815`] View formatted query View runnable query Explain query UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? UPDATE dtb_product_class SET price01 = '3000', price02 = '3000', update_date = '2024-11-22 09:55:20' WHERE id = 12815;
42	0.18 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4546991`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4546991;
43	0.11 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4546992`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4546992;
44	0.13 ms	DELETE FROM dtb_product_image WHERE id = ? Parameters: [`1942370`] View formatted query View runnable query Explain query DELETE FROM dtb_product_image WHERE id = ? DELETE FROM dtb_product_image WHERE id = 1942370;
45	0.21 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 131`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 131;
46	0.19 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 19`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 19;
47	0.18 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 57`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 57;
48	0.18 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 59`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 59;
49	0.15 ms	INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?) Parameters: [`"an1778.jpg" 1 "2024-11-22 09:55:20" 3849 1 "productimage"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_image ( file_name, sort_no, create_date, product_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?, ?) INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES ('an1778.jpg', 1, '2024-11-22 09:55:20', 3849, 1, 'productimage');
50	0.14 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 3849 83 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 3849, 83, 1, 'producttag');
51	0.12 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 3849 36 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 3849, 36, 1, 'producttag');
52	0.12 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 131 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 131, 'productcategory');
53	0.11 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 19 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 19, 'productcategory');
54	0.11 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 57 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 57, 'productcategory');
55	0.11 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 59 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 59, 'productcategory');
56	0.16 ms	UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? Parameters: [`"3000" "3000" "2024-11-22 09:55:20" 12816`] View formatted query View runnable query Explain query UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? UPDATE dtb_product_class SET price01 = '3000', price02 = '3000', update_date = '2024-11-22 09:55:20' WHERE id = 12816;
57	0.13 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553585`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553585;
58	0.12 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553586`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553586;
59	0.12 ms	DELETE FROM dtb_product_image WHERE id = ? Parameters: [`1942371`] View formatted query View runnable query Explain query DELETE FROM dtb_product_image WHERE id = ? DELETE FROM dtb_product_image WHERE id = 1942371;
60	0.19 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 131`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 131;
61	0.18 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 19`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 19;
62	0.17 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 57`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 57;
63	0.17 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 59`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 59;
64	0.14 ms	INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?) Parameters: [`"an1778.jpg" 1 "2024-11-22 09:55:20" 3849 1 "productimage"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_image ( file_name, sort_no, create_date, product_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?, ?) INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES ('an1778.jpg', 1, '2024-11-22 09:55:20', 3849, 1, 'productimage');
65	0.13 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 3849 83 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 3849, 83, 1, 'producttag');
66	0.11 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 3849 36 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 3849, 36, 1, 'producttag');
67	0.12 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 131 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 131, 'productcategory');
68	0.10 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 19 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 19, 'productcategory');
69	0.12 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 57 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 57, 'productcategory');
70	0.11 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 59 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 59, 'productcategory');
71	0.16 ms	UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? Parameters: [`"2700" "2700" "2024-11-22 09:55:20" 13881`] View formatted query View runnable query Explain query UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? UPDATE dtb_product_class SET price01 = '2700', price02 = '2700', update_date = '2024-11-22 09:55:20' WHERE id = 13881;
72	0.12 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553587`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553587;
73	0.12 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553588`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553588;
74	0.11 ms	DELETE FROM dtb_product_image WHERE id = ? Parameters: [`1942372`] View formatted query View runnable query Explain query DELETE FROM dtb_product_image WHERE id = ? DELETE FROM dtb_product_image WHERE id = 1942372;
75	0.20 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 131`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 131;
76	0.19 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 19`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 19;
77	0.16 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 57`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 57;
78	0.15 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 59`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 59;
79	0.13 ms	INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?) Parameters: [`"an1778.jpg" 1 "2024-11-22 09:55:20" 3849 1 "productimage"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_image ( file_name, sort_no, create_date, product_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?, ?) INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES ('an1778.jpg', 1, '2024-11-22 09:55:20', 3849, 1, 'productimage');
80	0.12 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 3849 83 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 3849, 83, 1, 'producttag');
81	0.11 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 3849 36 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 3849, 36, 1, 'producttag');
82	0.11 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 131 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 131, 'productcategory');
83	0.10 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 19 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 19, 'productcategory');
84	0.10 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 57 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 57, 'productcategory');
85	0.09 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 59 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 59, 'productcategory');
86	0.14 ms	UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? Parameters: [`"1500" "1500" "2024-11-22 09:55:20" 13964`] View formatted query View runnable query Explain query UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? UPDATE dtb_product_class SET price01 = '1500', price02 = '1500', update_date = '2024-11-22 09:55:20' WHERE id = 13964;
87	0.14 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553589`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553589;
88	0.11 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553590`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553590;
89	0.10 ms	DELETE FROM dtb_product_image WHERE id = ? Parameters: [`1942373`] View formatted query View runnable query Explain query DELETE FROM dtb_product_image WHERE id = ? DELETE FROM dtb_product_image WHERE id = 1942373;
90	0.15 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 131`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 131;
91	0.14 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 19`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 19;
92	0.14 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 57`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 57;
93	0.14 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`3849 59`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 3849 AND category_id = 59;
94	0.22 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.description_list AS description_list_4, t0.description_detail AS description_detail_5, t0.search_word AS search_word_6, t0.free_area AS free_area_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.brand AS brand_10, t0.number AS number_11, t0.size AS size_12, t0.material AS material_13, t0.notification_email AS notification_email_14, t0.invalidity_period AS invalidity_period_15, t0.creator_id AS creator_id_16, t0.product_status_id AS product_status_id_17, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = ? AND t0.discriminator_type IN ('product') Parameters: [`"5067"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.description_list AS description_list_4, t0.description_detail AS description_detail_5, t0.search_word AS search_word_6, t0.free_area AS free_area_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.brand AS brand_10, t0.number AS number_11, t0.size AS size_12, t0.material AS material_13, t0.notification_email AS notification_email_14, t0.invalidity_period AS invalidity_period_15, t0.creator_id AS creator_id_16, t0.product_status_id AS product_status_id_17, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = ? AND t0.discriminator_type IN ('product') SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.description_list AS description_list_4, t0.description_detail AS description_detail_5, t0.search_word AS search_word_6, t0.free_area AS free_area_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.brand AS brand_10, t0.number AS number_11, t0.size AS size_12, t0.material AS material_13, t0.notification_email AS notification_email_14, t0.invalidity_period AS invalidity_period_15, t0.creator_id AS creator_id_16, t0.product_status_id AS product_status_id_17, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = '5067' AND t0.discriminator_type IN ('product');
95	0.21 ms	SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.product_id AS product_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC Parameters: [`5067`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.product_id AS product_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.product_id AS product_id_5, t0.creator_id AS creator_id_6, t0.discriminator_type FROM dtb_product_image t0 WHERE t0.product_id = 5067 AND t0.discriminator_type IN ('productimage') ORDER BY t0.sort_no ASC;
96	0.12 ms	INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?) Parameters: [`"an1778.jpg" 1 "2024-11-22 09:55:20" 5067 1 "productimage"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_image ( file_name, sort_no, create_date, product_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?, ?) INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES ('an1778.jpg', 1, '2024-11-22 09:55:20', 5067, 1, 'productimage');
97	0.10 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 3849 83 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 3849, 83, 1, 'producttag');
98	0.10 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 3849 36 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 3849, 36, 1, 'producttag');
99	0.09 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 131 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 131, 'productcategory');
100	0.09 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 19 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 19, 'productcategory');
101	0.09 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 57 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 57, 'productcategory');
102	0.11 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`3849 59 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (3849, 59, 'productcategory');
103	0.11 ms	UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? Parameters: [`"1500" "1500" "2024-11-22 09:55:20" 14047`] View formatted query View runnable query Explain query UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? UPDATE dtb_product_class SET price01 = '1500', price02 = '1500', update_date = '2024-11-22 09:55:20' WHERE id = 14047;
104	0.09 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553591`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553591;
105	0.08 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553592`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553592;
106	0.08 ms	DELETE FROM dtb_product_image WHERE id = ? Parameters: [`1939550`] View formatted query View runnable query Explain query DELETE FROM dtb_product_image WHERE id = ? DELETE FROM dtb_product_image WHERE id = 1939550;
107	0.17 ms	SELECT t0.product_id AS product_id_1, t0.category_id AS category_id_2, t0.product_id AS product_id_3, t0.category_id AS category_id_4, t0.discriminator_type FROM dtb_product_category t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productcategory') Parameters: [`5067`] View formatted query View runnable query Explain query SELECT t0.product_id AS product_id_1, t0.category_id AS category_id_2, t0.product_id AS product_id_3, t0.category_id AS category_id_4, t0.discriminator_type FROM dtb_product_category t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productcategory') SELECT t0.product_id AS product_id_1, t0.category_id AS category_id_2, t0.product_id AS product_id_3, t0.category_id AS category_id_4, t0.discriminator_type FROM dtb_product_category t0 WHERE t0.product_id = 5067 AND t0.discriminator_type IN ('productcategory');
108	0.13 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 19`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 19;
109	0.12 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 57`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 57;
110	0.12 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 59`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 59;
111	0.12 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 131`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 131;
112	0.16 ms	SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_id AS product_id_3, t0.tag_id AS tag_id_4, t0.creator_id AS creator_id_5, t0.discriminator_type FROM dtb_product_tag t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('producttag') Parameters: [`5067`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_id AS product_id_3, t0.tag_id AS tag_id_4, t0.creator_id AS creator_id_5, t0.discriminator_type FROM dtb_product_tag t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('producttag') SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_id AS product_id_3, t0.tag_id AS tag_id_4, t0.creator_id AS creator_id_5, t0.discriminator_type FROM dtb_product_tag t0 WHERE t0.product_id = 5067 AND t0.discriminator_type IN ('producttag');
113	0.22 ms	SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.product_id AS product_id_14, t0.sale_type_id AS sale_type_id_15, t0.class_category_id1 AS class_category_id1_16, t0.class_category_id2 AS class_category_id2_17, t0.delivery_duration_id AS delivery_duration_id_18, t0.creator_id AS creator_id_19, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productclass') Parameters: [`5067`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.product_id AS product_id_14, t0.sale_type_id AS sale_type_id_15, t0.class_category_id1 AS class_category_id1_16, t0.class_category_id2 AS class_category_id2_17, t0.delivery_duration_id AS delivery_duration_id_18, t0.creator_id AS creator_id_19, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productclass') SELECT t0.id AS id_1, t0.product_code AS product_code_2, t0.stock AS stock_3, t0.stock_unlimited AS stock_unlimited_4, t0.sale_limit AS sale_limit_5, t0.price01 AS price01_6, t0.price02 AS price02_7, t0.delivery_fee AS delivery_fee_8, t0.visible AS visible_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.currency_code AS currency_code_12, t0.point_rate AS point_rate_13, t0.product_id AS product_id_14, t0.sale_type_id AS sale_type_id_15, t0.class_category_id1 AS class_category_id1_16, t0.class_category_id2 AS class_category_id2_17, t0.delivery_duration_id AS delivery_duration_id_18, t0.creator_id AS creator_id_19, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = 5067 AND t0.discriminator_type IN ('productclass');
114	0.07 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: [`20772`] View formatted query View runnable query Explain query 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') 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 = 20772 AND t0.discriminator_type IN ('productstock');
115	0.07 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: [`20772`] View formatted query View runnable query Explain query 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') 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 = 20772 AND t0.discriminator_type IN ('taxrule');
116	0.06 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: [`20818`] View formatted query View runnable query Explain query 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') 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 = 20818 AND t0.discriminator_type IN ('productstock');
117	0.07 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: [`20818`] View formatted query View runnable query Explain query 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') 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 = 20818 AND t0.discriminator_type IN ('taxrule');
118	0.06 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: [`20819`] View formatted query View runnable query Explain query 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') 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 = 20819 AND t0.discriminator_type IN ('productstock');
119	0.07 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: [`20819`] View formatted query View runnable query Explain query 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') 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 = 20819 AND t0.discriminator_type IN ('taxrule');
120	0.07 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: [`20820`] View formatted query View runnable query Explain query 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') 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 = 20820 AND t0.discriminator_type IN ('productstock');
121	0.06 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: [`20820`] View formatted query View runnable query Explain query 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') 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 = 20820 AND t0.discriminator_type IN ('taxrule');
122	0.06 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: [`20821`] View formatted query View runnable query Explain query 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') 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 = 20821 AND t0.discriminator_type IN ('productstock');
123	0.06 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: [`20821`] View formatted query View runnable query Explain query 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') 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 = 20821 AND t0.discriminator_type IN ('taxrule');
124	0.11 ms	INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?) Parameters: [`"an1778.jpg" 1 "2024-11-22 09:55:20" 5067 1 "productimage"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_image ( file_name, sort_no, create_date, product_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?, ?) INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES ('an1778.jpg', 1, '2024-11-22 09:55:20', 5067, 1, 'productimage');
125	0.09 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 5067 83 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 5067, 83, 1, 'producttag');
126	0.08 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 5067 36 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 5067, 36, 1, 'producttag');
127	0.08 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 131 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 131, 'productcategory');
128	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 19 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 19, 'productcategory');
129	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 57 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 57, 'productcategory');
130	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 59 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 59, 'productcategory');
131	0.11 ms	UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? Parameters: [`"3000" "3000" "2024-11-22 09:55:20" 20772`] View formatted query View runnable query Explain query UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? UPDATE dtb_product_class SET price01 = '3000', price02 = '3000', update_date = '2024-11-22 09:55:20' WHERE id = 20772;
132	0.09 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4546921`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4546921;
133	0.08 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4546922`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4546922;
134	0.08 ms	DELETE FROM dtb_product_image WHERE id = ? Parameters: [`1942375`] View formatted query View runnable query Explain query DELETE FROM dtb_product_image WHERE id = ? DELETE FROM dtb_product_image WHERE id = 1942375;
135	0.16 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 131`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 131;
136	0.13 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 19`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 19;
137	0.13 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 57`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 57;
138	0.12 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 59`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 59;
139	0.10 ms	INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?) Parameters: [`"an1778.jpg" 1 "2024-11-22 09:55:20" 5067 1 "productimage"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_image ( file_name, sort_no, create_date, product_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?, ?) INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES ('an1778.jpg', 1, '2024-11-22 09:55:20', 5067, 1, 'productimage');
140	0.09 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 5067 83 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 5067, 83, 1, 'producttag');
141	0.08 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 5067 36 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 5067, 36, 1, 'producttag');
142	0.08 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 131 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 131, 'productcategory');
143	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 19 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 19, 'productcategory');
144	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 57 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 57, 'productcategory');
145	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 59 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 59, 'productcategory');
146	0.11 ms	UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? Parameters: [`"3000" "3000" "2024-11-22 09:55:20" 20818`] View formatted query View runnable query Explain query UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? UPDATE dtb_product_class SET price01 = '3000', price02 = '3000', update_date = '2024-11-22 09:55:20' WHERE id = 20818;
147	0.09 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553595`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553595;
148	0.08 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553596`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553596;
149	0.08 ms	DELETE FROM dtb_product_image WHERE id = ? Parameters: [`1942376`] View formatted query View runnable query Explain query DELETE FROM dtb_product_image WHERE id = ? DELETE FROM dtb_product_image WHERE id = 1942376;
150	0.13 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 131`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 131;
151	0.12 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 19`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 19;
152	0.12 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 57`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 57;
153	0.14 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 59`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 59;
154	0.11 ms	INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?) Parameters: [`"an1778.jpg" 1 "2024-11-22 09:55:20" 5067 1 "productimage"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_image ( file_name, sort_no, create_date, product_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?, ?) INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES ('an1778.jpg', 1, '2024-11-22 09:55:20', 5067, 1, 'productimage');
155	0.09 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 5067 83 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 5067, 83, 1, 'producttag');
156	0.08 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 5067 36 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 5067, 36, 1, 'producttag');
157	0.08 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 131 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 131, 'productcategory');
158	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 19 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 19, 'productcategory');
159	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 57 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 57, 'productcategory');
160	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 59 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 59, 'productcategory');
161	0.10 ms	UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? Parameters: [`"2700" "2700" "2024-11-22 09:55:20" 20819`] View formatted query View runnable query Explain query UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? UPDATE dtb_product_class SET price01 = '2700', price02 = '2700', update_date = '2024-11-22 09:55:20' WHERE id = 20819;
162	0.09 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553597`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553597;
163	0.08 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553598`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553598;
164	0.08 ms	DELETE FROM dtb_product_image WHERE id = ? Parameters: [`1942377`] View formatted query View runnable query Explain query DELETE FROM dtb_product_image WHERE id = ? DELETE FROM dtb_product_image WHERE id = 1942377;
165	0.12 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 131`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 131;
166	0.12 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 19`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 19;
167	0.11 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 57`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 57;
168	0.11 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 59`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 59;
169	0.10 ms	INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?) Parameters: [`"an1778.jpg" 1 "2024-11-22 09:55:20" 5067 1 "productimage"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_image ( file_name, sort_no, create_date, product_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?, ?) INSERT INTO dtb_product_image (file_name, sort_no, create_date, product_id, creator_id, discriminator_type) VALUES ('an1778.jpg', 1, '2024-11-22 09:55:20', 5067, 1, 'productimage');
170	0.08 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 5067 83 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 5067, 83, 1, 'producttag');
171	0.08 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 5067 36 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 5067, 36, 1, 'producttag');
172	0.08 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 131 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 131, 'productcategory');
173	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 19 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 19, 'productcategory');
174	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 57 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 57, 'productcategory');
175	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 59 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 59, 'productcategory');
176	0.14 ms	UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? Parameters: [`"1500" "1500" "2024-11-22 09:55:20" 20820`] View formatted query View runnable query Explain query UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? UPDATE dtb_product_class SET price01 = '1500', price02 = '1500', update_date = '2024-11-22 09:55:20' WHERE id = 20820;
177	0.11 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553599`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553599;
178	0.09 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553600`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553600;
179	0.09 ms	DELETE FROM dtb_product_image WHERE id = ? Parameters: [`1942378`] View formatted query View runnable query Explain query DELETE FROM dtb_product_image WHERE id = ? DELETE FROM dtb_product_image WHERE id = 1942378;
180	0.16 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 131`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 131;
181	0.12 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 19`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 19;
182	0.12 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 57`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 57;
183	0.12 ms	DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? Parameters: [`5067 59`] View formatted query View runnable query Explain query DELETE FROM dtb_product_category WHERE product_id = ? AND category_id = ? DELETE FROM dtb_product_category WHERE product_id = 5067 AND category_id = 59;
184	0.10 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 5067 83 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 5067, 83, 1, 'producttag');
185	0.09 ms	INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES (?, ?, ?, ?, ?) Parameters: [`"2024-11-22 09:55:20" 5067 36 1 "producttag"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_tag ( create_date, product_id, tag_id, creator_id, discriminator_type ) VALUES (?, ?, ?, ?, ?) INSERT INTO dtb_product_tag (create_date, product_id, tag_id, creator_id, discriminator_type) VALUES ('2024-11-22 09:55:20', 5067, 36, 1, 'producttag');
186	0.08 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 131 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 131, 'productcategory');
187	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 19 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 19, 'productcategory');
188	0.07 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 57 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 57, 'productcategory');
189	0.09 ms	INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (?, ?, ?) Parameters: [`5067 59 "productcategory"`] View formatted query View runnable query Explain query INSERT INTO dtb_product_category ( product_id, category_id, discriminator_type ) VALUES (?, ?, ?) INSERT INTO dtb_product_category (product_id, category_id, discriminator_type) VALUES (5067, 59, 'productcategory');
190	0.11 ms	UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? Parameters: [`"1500" "1500" "2024-11-22 09:55:20" 20821`] View formatted query View runnable query Explain query UPDATE dtb_product_class SET price01 = ?, price02 = ?, update_date = ? WHERE id = ? UPDATE dtb_product_class SET price01 = '1500', price02 = '1500', update_date = '2024-11-22 09:55:20' WHERE id = 20821;
191	0.09 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553601`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553601;
192	0.08 ms	DELETE FROM dtb_product_tag WHERE id = ? Parameters: [`4553602`] View formatted query View runnable query Explain query DELETE FROM dtb_product_tag WHERE id = ? DELETE FROM dtb_product_tag WHERE id = 4553602;
193	0.11 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
194	1.07 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"xs355060_props"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'xs355060_props' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
195	0.08 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
196	0.65 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"xs355060_props"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'xs355060_props' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
197	0.07 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
198	0.47 ms	SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"xs355060_props" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'xs355060_props' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
199	0.06 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
200	1.07 ms	SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'xs355060_props' / ORDER BY k.ORDINAL_POSITION Parameters: [`"xs355060_props" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'xs355060_props' / ORDER BY k.ORDINAL_POSITION SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = 'xs355060_props' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'xs355060_props' / ORDER BY k.ORDINAL_POSITION;
201	1.18 ms	SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION Parameters: [`"xs355060_props" "xs355060_props" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'xs355060_props' AND t.TABLE_SCHEMA = 'xs355060_props' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
202	0.07 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
203	0.17 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX Parameters: [`"xs355060_props" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'xs355060_props' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
204	0.07 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
205	0.07 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
206	0.07 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.discriminator_type IN ('plugin') Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.discriminator_type IN ('plugin') SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.discriminator_type IN ('plugin');

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\ProductClass	No errors.
Eccube\Entity\Cart	No errors.
Eccube\Entity\Order	No errors.
Eccube\Entity\Product	No errors.
Eccube\Entity\CustomerFavoriteProduct	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\DeliveryDuration	No errors.
Eccube\Entity\Master\SaleType	No errors.
Eccube\Entity\Tag	No errors.
Eccube\Entity\Category	No errors.
Eccube\Entity\ClassCategory	No errors.
Eccube\Entity\ProductImage	No errors.
Eccube\Entity\Master\ProductStatus	No errors.
Eccube\Entity\ProductCategory	No errors.
Eccube\Entity\ProductTag	No errors.
Eccube\Entity\ProductStock	No errors.
Eccube\Entity\TaxRule	No errors.
Eccube\Entity\Master\RoundingType	No errors.
Eccube\Entity\ClassName	No errors.
Eccube\Entity\Customer	No errors.
Eccube\Entity\CartItem	No errors.
Eccube\Entity\OrderItem	No errors.
Eccube\Entity\Shipping	No errors.
Eccube\Entity\MailHistory	No errors.
Eccube\Entity\Master\Sex	No errors.
Eccube\Entity\Master\Job	No errors.
Eccube\Entity\Payment	No errors.
Eccube\Entity\Master\CustomerOrderStatus	No errors.
Eccube\Entity\Master\OrderStatusColor	No errors.
Eccube\Entity\Master\OrderStatus	No errors.
Eccube\Entity\Plugin	No errors.

Symfony Profiler

https://props.ppplot.com/ecadmin/product/csv_split_import Return to referer URL

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping