Query Metrics
262
Database Queries
115
Different statements
986.14 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.16 ms |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
2 | 0.54 ms |
SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.option_product_tax_rule AS option_product_tax_rule_25, t0.option_customer_activate AS option_customer_activate_26, t0.option_remember_me AS option_remember_me_27, t0.authentication_key AS authentication_key_28, t0.php_path AS php_path_29, t0.option_point AS option_point_30, t0.basic_point_rate AS basic_point_rate_31, t0.point_conversion_rate AS point_conversion_rate_32, t0.joolen_always_member_registration_point AS joolen_always_member_registration_point_33, t0.member_registration_point AS member_registration_point_34, t0.apply_datetime_start AS apply_datetime_start_35, t0.apply_datetime_end AS apply_datetime_end_36, t0.joolen_include_receiving_mail_magazine AS joolen_include_receiving_mail_magazine_37, t0.country_id AS country_id_38, t0.pref_id AS pref_id_39, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo')
Parameters:
[
1
]
|
3 | 0.24 ms |
SELECT t0.id AS id_1, t0.cancelable_day AS cancelable_day_2, t0.cancelable_time AS cancelable_time_3, t0.cancelable_type AS cancelable_type_4 FROM plg_cancel_plugin_config t0 WHERE t0.id = ?
Parameters:
[
1
]
|
4 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.code = ? AND t0.discriminator_type IN ('plugin') LIMIT 1
Parameters:
[
"MailMagazine4"
]
|
5 | 0.40 ms |
SELECT p0_.id AS id_0, p0_.insert_content_type AS insert_content_type_1, p0_.url_type AS url_type_2 FROM plg_apg_rich_category_config p0_ WHERE p0_.id = ?
Parameters:
[
1
]
|
6 | 0.23 ms |
SELECT d0_.plg_slug AS plg_slug_0 FROM dtb_category d0_ WHERE d0_.discriminator_type IN ('category')
Parameters:
[] |
7 | 0.23 ms |
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.hierarchy AS hierarchy_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.plg_content AS plg_content_7, t0.plg_meta_description AS plg_meta_description_8, t0.plg_file_name AS plg_file_name_9, t0.plg_slug AS plg_slug_10, t0.parent_category_id AS parent_category_id_11, t0.creator_id AS creator_id_12, t0.schedule_time_id AS schedule_time_id_13, t0.discriminator_type FROM dtb_category t0 WHERE t0.plg_slug = ? AND t0.discriminator_type IN ('category') LIMIT 1
Parameters:
[
"products/list"
]
|
8 | 0.11 ms |
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.hierarchy AS hierarchy_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.plg_content AS plg_content_7, t0.plg_meta_description AS plg_meta_description_8, t0.plg_file_name AS plg_file_name_9, t0.plg_slug AS plg_slug_10, t0.parent_category_id AS parent_category_id_11, t0.creator_id AS creator_id_12, t0.schedule_time_id AS schedule_time_id_13, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category') LIMIT 1
Parameters:
[
"9"
]
|
9 | 0.69 ms |
SELECT d0_.id AS id_0, d0_.page_name AS page_name_1, d0_.url AS url_2, d0_.file_name AS file_name_3, d0_.edit_type AS edit_type_4, d0_.author AS author_5, d0_.description AS description_6, d0_.keyword AS keyword_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.meta_robots AS meta_robots_10, d0_.meta_tags AS meta_tags_11, d1_.page_id AS page_id_12, d1_.layout_id AS layout_id_13, d1_.sort_no AS sort_no_14, d2_.id AS id_15, d2_.layout_name AS layout_name_16, d2_.create_date AS create_date_17, d2_.update_date AS update_date_18, d0_.discriminator_type AS discriminator_type_19, d0_.master_page_id AS master_page_id_20, d0_.schedule_time_id AS schedule_time_id_21, d1_.discriminator_type AS discriminator_type_22, d1_.page_id AS page_id_23, d1_.layout_id AS layout_id_24, d2_.discriminator_type AS discriminator_type_25, d2_.device_type_id AS device_type_id_26 FROM dtb_page d0_ LEFT JOIN dtb_page_layout d1_ ON d0_.id = d1_.page_id AND d1_.discriminator_type IN ('pagelayout') LEFT JOIN dtb_layout d2_ ON d1_.layout_id = d2_.id AND d2_.discriminator_type IN ('layout') WHERE (d0_.url = ?) AND d0_.discriminator_type IN ('page')
Parameters:
[
"product_list"
]
|
10 | 1.26 ms |
SELECT d0_.id AS id_0, d0_.layout_name AS layout_name_1, d0_.create_date AS create_date_2, d0_.update_date AS update_date_3, d1_.section AS section_4, d1_.block_id AS block_id_5, d1_.layout_id AS layout_id_6, d1_.block_row AS block_row_7, d2_.id AS id_8, d2_.block_name AS block_name_9, d2_.file_name AS file_name_10, d2_.use_controller AS use_controller_11, d2_.deletable AS deletable_12, d2_.create_date AS create_date_13, d2_.update_date AS update_date_14, d0_.discriminator_type AS discriminator_type_15, d0_.device_type_id AS device_type_id_16, d1_.discriminator_type AS discriminator_type_17, d1_.block_id AS block_id_18, d1_.layout_id AS layout_id_19, d2_.discriminator_type AS discriminator_type_20, d2_.device_type_id AS device_type_id_21, d2_.schedule_time_id AS schedule_time_id_22 FROM dtb_layout d0_ LEFT JOIN dtb_block_position d1_ ON d0_.id = d1_.layout_id AND d1_.discriminator_type IN ('blockposition') AND (d1_.block_id in (select id from dtb_block where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null)) or schedule_time_id is null )) LEFT JOIN dtb_block d2_ ON d1_.block_id = d2_.id AND d2_.discriminator_type IN ('block') AND ((d2_.schedule_time_id is null or (d2_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) ))) WHERE (d0_.id = ?) AND d0_.discriminator_type IN ('layout') ORDER BY d1_.block_row ASC
Parameters:
[
3
]
|
11 | 0.05 ms |
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
Parameters:
[] |
12 | 0.02 ms |
"START TRANSACTION"
Parameters:
[] |
13 | 0.16 ms |
SELECT t0.id AS id_1, t0.option_group_product_hidden AS option_group_product_hidden_2, t0.option_group_category_hidden AS option_group_category_hidden_3, t0.option1 AS option1_4, t0.rounding_type_id AS rounding_type_id_5, t0.discriminator_type FROM plg_customer_group_config t0 WHERE t0.id = ? AND t0.discriminator_type IN ('config')
Parameters:
[
1
]
|
14 | 0.13 ms |
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.hierarchy AS hierarchy_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.plg_content AS plg_content_7, t0.plg_meta_description AS plg_meta_description_8, t0.plg_file_name AS plg_file_name_9, t0.plg_slug AS plg_slug_10, t0.parent_category_id AS parent_category_id_11, t0.creator_id AS creator_id_12, t0.schedule_time_id AS schedule_time_id_13, t0.discriminator_type FROM dtb_category t0 WHERE t0.id = ? AND t0.discriminator_type IN ('category')
Parameters:
[
1
]
|
15 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.backend_name AS backend_name_3, t0.option_non_member_display AS option_non_member_display_4, t0.sort_no AS sort_no_5, t0.discount_rate AS discount_rate_6, t0.wholesale_rate AS wholesale_rate_7, t0.discriminator_type FROM plg_customer_group t0 INNER JOIN plg_customer_group_categories_groups ON t0.id = plg_customer_group_categories_groups.group_id WHERE plg_customer_group_categories_groups.category_id = ? AND t0.discriminator_type IN ('group')
Parameters:
[
1
]
|
16 | 3.61 ms |
SELECT d0_.id AS id_0, d0_.category_name AS category_name_1, d0_.hierarchy AS hierarchy_2, d0_.sort_no AS sort_no_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.plg_content AS plg_content_6, d0_.plg_meta_description AS plg_meta_description_7, d0_.plg_file_name AS plg_file_name_8, d0_.plg_slug AS plg_slug_9, d1_.id AS id_10, d1_.category_name AS category_name_11, d1_.hierarchy AS hierarchy_12, d1_.sort_no AS sort_no_13, d1_.create_date AS create_date_14, d1_.update_date AS update_date_15, d1_.plg_content AS plg_content_16, d1_.plg_meta_description AS plg_meta_description_17, d1_.plg_file_name AS plg_file_name_18, d1_.plg_slug AS plg_slug_19, d2_.id AS id_20, d2_.category_name AS category_name_21, d2_.hierarchy AS hierarchy_22, d2_.sort_no AS sort_no_23, d2_.create_date AS create_date_24, d2_.update_date AS update_date_25, d2_.plg_content AS plg_content_26, d2_.plg_meta_description AS plg_meta_description_27, d2_.plg_file_name AS plg_file_name_28, d2_.plg_slug AS plg_slug_29, d3_.id AS id_30, d3_.category_name AS category_name_31, d3_.hierarchy AS hierarchy_32, d3_.sort_no AS sort_no_33, d3_.create_date AS create_date_34, d3_.update_date AS update_date_35, d3_.plg_content AS plg_content_36, d3_.plg_meta_description AS plg_meta_description_37, d3_.plg_file_name AS plg_file_name_38, d3_.plg_slug AS plg_slug_39, d4_.id AS id_40, d4_.category_name AS category_name_41, d4_.hierarchy AS hierarchy_42, d4_.sort_no AS sort_no_43, d4_.create_date AS create_date_44, d4_.update_date AS update_date_45, d4_.plg_content AS plg_content_46, d4_.plg_meta_description AS plg_meta_description_47, d4_.plg_file_name AS plg_file_name_48, d4_.plg_slug AS plg_slug_49, d0_.discriminator_type AS discriminator_type_50, d0_.parent_category_id AS parent_category_id_51, d0_.creator_id AS creator_id_52, d0_.schedule_time_id AS schedule_time_id_53, d1_.discriminator_type AS discriminator_type_54, d1_.parent_category_id AS parent_category_id_55, d1_.creator_id AS creator_id_56, d1_.schedule_time_id AS schedule_time_id_57, d2_.discriminator_type AS discriminator_type_58, d2_.parent_category_id AS parent_category_id_59, d2_.creator_id AS creator_id_60, d2_.schedule_time_id AS schedule_time_id_61, d3_.discriminator_type AS discriminator_type_62, d3_.parent_category_id AS parent_category_id_63, d3_.creator_id AS creator_id_64, d3_.schedule_time_id AS schedule_time_id_65, d4_.discriminator_type AS discriminator_type_66, d4_.parent_category_id AS parent_category_id_67, d4_.creator_id AS creator_id_68, d4_.schedule_time_id AS schedule_time_id_69 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id AND d1_.discriminator_type IN ('category') AND ((d1_.schedule_time_id is null or (d1_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) ))) LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id AND d2_.discriminator_type IN ('category') AND ((d2_.schedule_time_id is null or (d2_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) ))) LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id AND d3_.discriminator_type IN ('category') AND ((d3_.schedule_time_id is null or (d3_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) ))) LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id AND d4_.discriminator_type IN ('category') AND ((d4_.schedule_time_id is null or (d4_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) ))) WHERE ((d0_.parent_category_id IS NULL) AND ((d0_.schedule_time_id is null or (d0_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) )))) AND d0_.discriminator_type IN ('category') ORDER BY d0_.sort_no DESC, d1_.sort_no ASC, d2_.sort_no ASC, d3_.sort_no ASC, d4_.sort_no ASC
Parameters:
[] |
17 | 0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.code = ? AND t0.enabled = ? AND t0.discriminator_type IN ('plugin') LIMIT 1
Parameters:
[ "ProductPlus" 1 ] |
18 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.input_type AS input_type_3, t0.is_required AS is_required_4, t0.search_flg AS search_flg_5, t0.keyword_flg AS keyword_flg_6, t0.sort_no AS sort_no_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM plg_productplus_dtb_product_item t0 WHERE t0.discriminator_type IN ('productitem')
Parameters:
[] |
19 | 0.20 ms |
SELECT p0_.id AS id_0, p0_.text AS text_1, p0_.sort_no AS sort_no_2, p0_.discriminator_type AS discriminator_type_3, p0_.product_item_id AS product_item_id_4 FROM plg_productplus_dtb_product_item_option p0_ WHERE (p0_.product_item_id = ?) AND p0_.discriminator_type IN ('productitemoption') ORDER BY p0_.sort_no DESC
Parameters:
[
2
]
|
20 | 0.39 ms |
SELECT t0.id AS id_1, t0.category_name AS category_name_2, t0.hierarchy AS hierarchy_3, t0.sort_no AS sort_no_4, t0.create_date AS create_date_5, t0.update_date AS update_date_6, t0.plg_content AS plg_content_7, t0.plg_meta_description AS plg_meta_description_8, t0.plg_file_name AS plg_file_name_9, t0.plg_slug AS plg_slug_10, t0.parent_category_id AS parent_category_id_11, t0.creator_id AS creator_id_12, t0.schedule_time_id AS schedule_time_id_13, t0.discriminator_type FROM dtb_category t0 WHERE t0.plg_slug = ? AND t0.discriminator_type IN ('category') AND (((t0.schedule_time_id is null or (t0.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) )))) LIMIT 1
Parameters:
[
"products/list"
]
|
21 | 0.19 ms |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.sort_no AS sort_no_2, d0_.show_product_list_flg AS show_product_list_flg_3, d0_.text_color AS text_color_4, d0_.background_color AS background_color_5, d0_.border_color AS border_color_6, d0_.discriminator_type AS discriminator_type_7 FROM dtb_tag d0_ WHERE d0_.discriminator_type IN ('tag') ORDER BY d0_.sort_no DESC
Parameters:
[] |
22 | 0.11 ms |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.sort_no AS sort_no_2, m0_.discriminator_type AS discriminator_type_3 FROM mtb_product_list_max m0_ WHERE m0_.discriminator_type IN ('productlistmax') ORDER BY m0_.sort_no ASC
Parameters:
[] |
23 | 0.09 ms |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.sort_no AS sort_no_2, m0_.discriminator_type AS discriminator_type_3 FROM mtb_product_list_order_by m0_ WHERE m0_.discriminator_type IN ('productlistorderby') ORDER BY m0_.sort_no ASC
Parameters:
[] |
24 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.code = ? AND t0.enabled = ? AND t0.discriminator_type IN ('plugin') LIMIT 1
Parameters:
[ "ProductPlus" 1 ] |
25 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.input_type AS input_type_3, t0.is_required AS is_required_4, t0.search_flg AS search_flg_5, t0.keyword_flg AS keyword_flg_6, t0.sort_no AS sort_no_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM plg_productplus_dtb_product_item t0 WHERE t0.discriminator_type IN ('productitem')
Parameters:
[] |
26 | 33.78 ms |
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.id AND d2_.discriminator_type IN ('category') LEFT JOIN plg_schedule_time p3_ ON d0_.schedule_time_id = p3_.schedule_time_id INNER JOIN dtb_product_class d4_ ON d0_.id = d4_.product_id AND d4_.discriminator_type IN ('productclass') WHERE (d0_.product_status_id = 1 AND d0_.priority_flag = 1 AND d1_.category_id IN (?) AND d0_.id NOT IN (SELECT DISTINCT (d5_.id) FROM dtb_product d5_ INNER JOIN plg_customer_group_products_groups p7_ ON d5_.id = p7_.product_id INNER JOIN plg_customer_group p6_ ON p6_.id = p7_.group_id AND p6_.discriminator_type IN ('group') WHERE d5_.discriminator_type IN ('product')) AND ((p3_.schedule_type IS NULL OR p3_.schedule_type = ? AND ((p3_.time_from <= ? AND p3_.time_to > ?) OR (p3_.time_from <= ? AND p3_.time_to IS NULL) OR (p3_.time_from IS NULL AND p3_.time_to > ?) OR (p3_.time_from IS NULL AND p3_.time_to IS NULL) OR (p3_.view_flg = 1))) OR (p3_.schedule_type IS NULL OR p3_.schedule_type = ? AND ((p3_.time_only_from <= ? AND p3_.time_only_to > ?) OR (p3_.time_only_from <= ? AND p3_.time_only_to IS NULL) OR (p3_.time_only_from IS NULL AND p3_.time_only_to > ?) OR (p3_.time_only_from IS NULL AND p3_.time_only_to IS NULL) OR (p3_.view_flg = 1)))) AND (d0_.id NOT IN (SELECT d8_.id FROM dtb_product_category d9_ INNER JOIN dtb_product d8_ ON d9_.product_id = d8_.id AND d8_.discriminator_type IN ('product') INNER JOIN dtb_category d10_ ON d9_.category_id = d10_.id AND d10_.discriminator_type IN ('category') INNER JOIN plg_schedule_time p11_ ON d10_.schedule_time_id = p11_.schedule_time_id WHERE (d8_.schedule_time_id IS NULL AND (p11_.time_from > ? OR p11_.time_to < ?)) AND d9_.discriminator_type IN ('productcategory'))) AND d4_.visible = 1) AND d0_.discriminator_type IN ('product')
Parameters:
[ [ 9 51 52 53 54 55 56 57 58 59 60 61 62 63 64 ] 1 "2024-10-05 11:41:59" "2024-10-05 11:41:59" "2024-10-05 11:41:59" "2024-10-05 11:41:59" 6 "2041" "2041" "2041" "2041" "2024-10-05 11:41:59" "2024-10-05 11:41:59" ] |
27 | 34.64 ms |
SELECT DISTINCT d0_.id AS id_0, d0_.create_date AS create_date_1, d0_.id AS id_2 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.id AND d2_.discriminator_type IN ('category') LEFT JOIN plg_schedule_time p3_ ON d0_.schedule_time_id = p3_.schedule_time_id INNER JOIN dtb_product_class d4_ ON d0_.id = d4_.product_id AND d4_.discriminator_type IN ('productclass') WHERE (d0_.product_status_id = 1 AND d0_.priority_flag = 1 AND d1_.category_id IN (?) AND d0_.id NOT IN (SELECT DISTINCT (d5_.id) FROM dtb_product d5_ INNER JOIN plg_customer_group_products_groups p7_ ON d5_.id = p7_.product_id INNER JOIN plg_customer_group p6_ ON p6_.id = p7_.group_id AND p6_.discriminator_type IN ('group') WHERE d5_.discriminator_type IN ('product')) AND ((p3_.schedule_type IS NULL OR p3_.schedule_type = ? AND ((p3_.time_from <= ? AND p3_.time_to > ?) OR (p3_.time_from <= ? AND p3_.time_to IS NULL) OR (p3_.time_from IS NULL AND p3_.time_to > ?) OR (p3_.time_from IS NULL AND p3_.time_to IS NULL) OR (p3_.view_flg = 1))) OR (p3_.schedule_type IS NULL OR p3_.schedule_type = ? AND ((p3_.time_only_from <= ? AND p3_.time_only_to > ?) OR (p3_.time_only_from <= ? AND p3_.time_only_to IS NULL) OR (p3_.time_only_from IS NULL AND p3_.time_only_to > ?) OR (p3_.time_only_from IS NULL AND p3_.time_only_to IS NULL) OR (p3_.view_flg = 1)))) AND (d0_.id NOT IN (SELECT d8_.id FROM dtb_product_category d9_ INNER JOIN dtb_product d8_ ON d9_.product_id = d8_.id AND d8_.discriminator_type IN ('product') INNER JOIN dtb_category d10_ ON d9_.category_id = d10_.id AND d10_.discriminator_type IN ('category') INNER JOIN plg_schedule_time p11_ ON d10_.schedule_time_id = p11_.schedule_time_id WHERE (d8_.schedule_time_id IS NULL AND (p11_.time_from > ? OR p11_.time_to < ?)) AND d9_.discriminator_type IN ('productcategory'))) AND d4_.visible = 1) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC, d0_.id DESC LIMIT 20 OFFSET 240
Parameters:
[ [ 9 51 52 53 54 55 56 57 58 59 60 61 62 63 64 ] 1 "2024-10-05 11:41:59" "2024-10-05 11:41:59" "2024-10-05 11:41:59" "2024-10-05 11:41:59" 6 "2041" "2041" "2041" "2041" "2024-10-05 11:41:59" "2024-10-05 11:41:59" ] |
28 | 2.35 ms |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.slug AS slug_9, d0_.grouping_code AS grouping_code_10, d0_.priority_flag AS priority_flag_11, d0_.shipping_name AS shipping_name_12, d0_.plg_pu_private AS plg_pu_private_13, d0_.plg_pu_private_key AS plg_pu_private_key_14, d0_.plg_pu_publish_date AS plg_pu_publish_date_15, d0_.free_description_about_quantity AS free_description_about_quantity_16, d0_.free_description_about_selling_price AS free_description_about_selling_price_17, d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_18, d0_.discriminator_type AS discriminator_type_19, d0_.creator_id AS creator_id_20, d0_.product_status_id AS product_status_id_21, d0_.schedule_time_id AS schedule_time_id_22 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.id AND d2_.discriminator_type IN ('category') LEFT JOIN plg_schedule_time p3_ ON d0_.schedule_time_id = p3_.schedule_time_id INNER JOIN dtb_product_class d4_ ON d0_.id = d4_.product_id AND d4_.discriminator_type IN ('productclass') WHERE (d0_.product_status_id = 1 AND d0_.priority_flag = 1 AND d1_.category_id IN (?) AND d0_.id NOT IN (SELECT DISTINCT (d5_.id) FROM dtb_product d5_ INNER JOIN plg_customer_group_products_groups p7_ ON d5_.id = p7_.product_id INNER JOIN plg_customer_group p6_ ON p6_.id = p7_.group_id AND p6_.discriminator_type IN ('group') WHERE d5_.discriminator_type IN ('product')) AND ((p3_.schedule_type IS NULL OR p3_.schedule_type = ? AND ((p3_.time_from <= ? AND p3_.time_to > ?) OR (p3_.time_from <= ? AND p3_.time_to IS NULL) OR (p3_.time_from IS NULL AND p3_.time_to > ?) OR (p3_.time_from IS NULL AND p3_.time_to IS NULL) OR (p3_.view_flg = 1))) OR (p3_.schedule_type IS NULL OR p3_.schedule_type = ? AND ((p3_.time_only_from <= ? AND p3_.time_only_to > ?) OR (p3_.time_only_from <= ? AND p3_.time_only_to IS NULL) OR (p3_.time_only_from IS NULL AND p3_.time_only_to > ?) OR (p3_.time_only_from IS NULL AND p3_.time_only_to IS NULL) OR (p3_.view_flg = 1)))) AND (d0_.id NOT IN (SELECT d8_.id FROM dtb_product_category d9_ INNER JOIN dtb_product d8_ ON d9_.product_id = d8_.id AND d8_.discriminator_type IN ('product') INNER JOIN dtb_category d10_ ON d9_.category_id = d10_.id AND d10_.discriminator_type IN ('category') INNER JOIN plg_schedule_time p11_ ON d10_.schedule_time_id = p11_.schedule_time_id WHERE (d8_.schedule_time_id IS NULL AND (p11_.time_from > ? OR p11_.time_to < ?)) AND d9_.discriminator_type IN ('productcategory'))) AND d4_.visible = 1 AND d0_.id IN (?)) AND d0_.discriminator_type IN ('product') ORDER BY d0_.create_date DESC, d0_.id DESC
Parameters:
[ [ 9 51 52 53 54 55 56 57 58 59 60 61 62 63 64 ] 1 "2024-10-05 11:41:59" "2024-10-05 11:41:59" "2024-10-05 11:41:59" "2024-10-05 11:41:59" 6 "2041" "2041" "2041" "2041" "2024-10-05 11:41:59" "2024-10-05 11:41:59" [ 8290 8284 8253 8249 8245 8241 8139 8137 8135 8133 8061 8060 8042 7626 7463 7462 7431 7426 7420 7410 ] ] |
29 | 3.24 ms |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.slug AS slug_9, d0_.grouping_code AS grouping_code_10, d0_.priority_flag AS priority_flag_11, d0_.shipping_name AS shipping_name_12, d0_.plg_pu_private AS plg_pu_private_13, d0_.plg_pu_private_key AS plg_pu_private_key_14, d0_.plg_pu_publish_date AS plg_pu_publish_date_15, d0_.free_description_about_quantity AS free_description_about_quantity_16, d0_.free_description_about_selling_price AS free_description_about_selling_price_17, d0_.free_description_of_payment_delivery AS free_description_of_payment_delivery_18, d1_.id AS id_19, d1_.product_code AS product_code_20, d1_.stock AS stock_21, d1_.stock_unlimited AS stock_unlimited_22, d1_.sale_limit AS sale_limit_23, d1_.price01 AS price01_24, d1_.price02 AS price02_25, d1_.delivery_fee AS delivery_fee_26, d1_.visible AS visible_27, d1_.create_date AS create_date_28, d1_.update_date AS update_date_29, d1_.currency_code AS currency_code_30, d1_.point_rate AS point_rate_31, d2_.id AS id_32, d2_.tax_rate AS tax_rate_33, d2_.tax_adjust AS tax_adjust_34, d2_.apply_date AS apply_date_35, d2_.create_date AS create_date_36, d2_.update_date AS update_date_37, d3_.id AS id_38, d3_.stock AS stock_39, d3_.create_date AS create_date_40, d3_.update_date AS update_date_41, d4_.id AS id_42, d4_.backend_name AS backend_name_43, d4_.name AS name_44, d4_.sort_no AS sort_no_45, d4_.visible AS visible_46, d4_.create_date AS create_date_47, d4_.update_date AS update_date_48, d5_.id AS id_49, d5_.backend_name AS backend_name_50, d5_.name AS name_51, d5_.sort_no AS sort_no_52, d5_.visible AS visible_53, d5_.create_date AS create_date_54, d5_.update_date AS update_date_55, d6_.id AS id_56, d6_.file_name AS file_name_57, d6_.sort_no AS sort_no_58, d6_.create_date AS create_date_59, d7_.id AS id_60, d7_.create_date AS create_date_61, d0_.discriminator_type AS discriminator_type_62, d0_.creator_id AS creator_id_63, d0_.product_status_id AS product_status_id_64, d0_.schedule_time_id AS schedule_time_id_65, d1_.discriminator_type AS discriminator_type_66, d1_.product_id AS product_id_67, d1_.sale_type_id AS sale_type_id_68, d1_.class_category_id1 AS class_category_id1_69, d1_.class_category_id2 AS class_category_id2_70, d1_.delivery_duration_id AS delivery_duration_id_71, d1_.creator_id AS creator_id_72, d1_.regular_discount_id AS regular_discount_id_73, d2_.discriminator_type AS discriminator_type_74, d2_.product_class_id AS product_class_id_75, d2_.creator_id AS creator_id_76, d2_.country_id AS country_id_77, d2_.pref_id AS pref_id_78, d2_.product_id AS product_id_79, d2_.rounding_type_id AS rounding_type_id_80, d3_.discriminator_type AS discriminator_type_81, d3_.product_class_id AS product_class_id_82, d3_.creator_id AS creator_id_83, d4_.discriminator_type AS discriminator_type_84, d4_.class_name_id AS class_name_id_85, d4_.creator_id AS creator_id_86, d5_.discriminator_type AS discriminator_type_87, d5_.class_name_id AS class_name_id_88, d5_.creator_id AS creator_id_89, d6_.discriminator_type AS discriminator_type_90, d6_.product_id AS product_id_91, d6_.creator_id AS creator_id_92, d7_.discriminator_type AS discriminator_type_93, d7_.product_id AS product_id_94, d7_.tag_id AS tag_id_95, d7_.creator_id AS creator_id_96 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') LEFT JOIN dtb_tax_rule d2_ ON d1_.id = d2_.product_class_id AND d2_.discriminator_type IN ('taxrule') INNER JOIN dtb_product_stock d3_ ON d1_.id = d3_.product_class_id AND d3_.discriminator_type IN ('productstock') LEFT JOIN dtb_class_category d4_ ON d1_.class_category_id1 = d4_.id AND d4_.discriminator_type IN ('classcategory') LEFT JOIN dtb_class_category d5_ ON d1_.class_category_id2 = d5_.id AND d5_.discriminator_type IN ('classcategory') LEFT JOIN dtb_product_image d6_ ON d0_.id = d6_.product_id AND d6_.discriminator_type IN ('productimage') LEFT JOIN dtb_product_tag d7_ ON d0_.id = d7_.product_id AND d7_.discriminator_type IN ('producttag') WHERE (d0_.id IN (8290, 8284, 8253, 8249, 8245, 8241, 8139, 8137, 8135, 8133, 8061, 8060, 8042, 7626, 7463, 7462, 7431, 7426, 7420, 7410) AND d1_.visible = ?) AND d0_.discriminator_type IN ('product') ORDER BY d4_.sort_no DESC, d5_.sort_no DESC, d6_.sort_no ASC
Parameters:
[
1
]
|
30 | 0.55 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-10-05 11:41:59"
]
|
31 | 0.46 ms |
SELECT t0.id AS id_1, t0.tid AS tid_2, t0.eec AS eec_3, t0.category AS category_4, t0.include_variant AS include_variant_5, t0.track_user_id AS track_user_id_6, t0.display_features AS display_features_7, t0.ga_gtag AS ga_gtag_8, t0.user_timings AS user_timings_9, t0.imp_track AS imp_track_10, t0.crossdomain_linker AS crossdomain_linker_11, t0.confirmation_as_purchase AS confirmation_as_purchase_12, t0.use_custom_referrer AS use_custom_referrer_13, t0.custom_referrers AS custom_referrers_14, t0.create_date AS create_date_15, t0.update_date AS update_date_16, t0.discriminator_type FROM plg_uagaeec_plugin t0 WHERE t0.id = ? AND t0.discriminator_type IN ('uagaeec')
Parameters:
[
1
]
|
32 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.show_product_list_flg AS show_product_list_flg_4, t0.text_color AS text_color_5, t0.background_color AS background_color_6, t0.border_color AS border_color_7, t0.discriminator_type FROM dtb_tag t0 WHERE t0.show_product_list_flg = ? AND t0.discriminator_type IN ('tag')
Parameters:
[
1
]
|
33 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.code = ? AND t0.enabled = ? AND t0.discriminator_type IN ('plugin') LIMIT 1
Parameters:
[ "ProductPlus" 1 ] |
34 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.input_type AS input_type_3, t0.is_required AS is_required_4, t0.search_flg AS search_flg_5, t0.keyword_flg AS keyword_flg_6, t0.sort_no AS sort_no_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM plg_productplus_dtb_product_item t0 WHERE t0.search_flg = ? AND t0.discriminator_type IN ('productitem') ORDER BY t0.sort_no DESC
Parameters:
[
1
]
|
35 | 0.51 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:
[] |
36 | 0.27 ms |
SELECT t0.id AS id_1, t0.disp_pc AS disp_pc_2, t0.disp_sp AS disp_sp_3 FROM plg_joolen_category_icon4_config t0 WHERE t0.id = ?
Parameters:
[
1
]
|
37 | 0.16 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.category_id AS category_id_5, t0.discriminator_type FROM plg_joolen_category_icon4_category_image t0 WHERE t0.discriminator_type IN ('categoryimage')
Parameters:
[] |
38 | 3.59 ms |
SELECT d0_.id AS id_0, d0_.category_name AS category_name_1, d0_.hierarchy AS hierarchy_2, d0_.sort_no AS sort_no_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.plg_content AS plg_content_6, d0_.plg_meta_description AS plg_meta_description_7, d0_.plg_file_name AS plg_file_name_8, d0_.plg_slug AS plg_slug_9, d1_.id AS id_10, d1_.category_name AS category_name_11, d1_.hierarchy AS hierarchy_12, d1_.sort_no AS sort_no_13, d1_.create_date AS create_date_14, d1_.update_date AS update_date_15, d1_.plg_content AS plg_content_16, d1_.plg_meta_description AS plg_meta_description_17, d1_.plg_file_name AS plg_file_name_18, d1_.plg_slug AS plg_slug_19, d2_.id AS id_20, d2_.category_name AS category_name_21, d2_.hierarchy AS hierarchy_22, d2_.sort_no AS sort_no_23, d2_.create_date AS create_date_24, d2_.update_date AS update_date_25, d2_.plg_content AS plg_content_26, d2_.plg_meta_description AS plg_meta_description_27, d2_.plg_file_name AS plg_file_name_28, d2_.plg_slug AS plg_slug_29, d3_.id AS id_30, d3_.category_name AS category_name_31, d3_.hierarchy AS hierarchy_32, d3_.sort_no AS sort_no_33, d3_.create_date AS create_date_34, d3_.update_date AS update_date_35, d3_.plg_content AS plg_content_36, d3_.plg_meta_description AS plg_meta_description_37, d3_.plg_file_name AS plg_file_name_38, d3_.plg_slug AS plg_slug_39, d4_.id AS id_40, d4_.category_name AS category_name_41, d4_.hierarchy AS hierarchy_42, d4_.sort_no AS sort_no_43, d4_.create_date AS create_date_44, d4_.update_date AS update_date_45, d4_.plg_content AS plg_content_46, d4_.plg_meta_description AS plg_meta_description_47, d4_.plg_file_name AS plg_file_name_48, d4_.plg_slug AS plg_slug_49, d0_.discriminator_type AS discriminator_type_50, d0_.parent_category_id AS parent_category_id_51, d0_.creator_id AS creator_id_52, d0_.schedule_time_id AS schedule_time_id_53, d1_.discriminator_type AS discriminator_type_54, d1_.parent_category_id AS parent_category_id_55, d1_.creator_id AS creator_id_56, d1_.schedule_time_id AS schedule_time_id_57, d2_.discriminator_type AS discriminator_type_58, d2_.parent_category_id AS parent_category_id_59, d2_.creator_id AS creator_id_60, d2_.schedule_time_id AS schedule_time_id_61, d3_.discriminator_type AS discriminator_type_62, d3_.parent_category_id AS parent_category_id_63, d3_.creator_id AS creator_id_64, d3_.schedule_time_id AS schedule_time_id_65, d4_.discriminator_type AS discriminator_type_66, d4_.parent_category_id AS parent_category_id_67, d4_.creator_id AS creator_id_68, d4_.schedule_time_id AS schedule_time_id_69 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id AND d1_.discriminator_type IN ('category') AND ((d1_.schedule_time_id is null or (d1_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) ))) LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id AND d2_.discriminator_type IN ('category') AND ((d2_.schedule_time_id is null or (d2_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) ))) LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id AND d3_.discriminator_type IN ('category') AND ((d3_.schedule_time_id is null or (d3_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) ))) LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id AND d4_.discriminator_type IN ('category') AND ((d4_.schedule_time_id is null or (d4_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) ))) WHERE ((d0_.parent_category_id IS NULL) AND ((d0_.schedule_time_id is null or (d0_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) )))) AND d0_.discriminator_type IN ('category') ORDER BY d0_.sort_no DESC, d1_.sort_no DESC, d2_.sort_no DESC, d3_.sort_no DESC, d4_.sort_no DESC
Parameters:
[] |
39 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.code = ? AND t0.enabled = ? AND t0.discriminator_type IN ('plugin') LIMIT 1
Parameters:
[ "ProductPlus" 1 ] |
40 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.input_type AS input_type_3, t0.is_required AS is_required_4, t0.search_flg AS search_flg_5, t0.keyword_flg AS keyword_flg_6, t0.sort_no AS sort_no_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM plg_productplus_dtb_product_item t0 WHERE t0.discriminator_type IN ('productitem')
Parameters:
[] |
41 | 0.18 ms |
SELECT p0_.id AS id_0, p0_.text AS text_1, p0_.sort_no AS sort_no_2, p0_.discriminator_type AS discriminator_type_3, p0_.product_item_id AS product_item_id_4 FROM plg_productplus_dtb_product_item_option p0_ WHERE (p0_.product_item_id = ?) AND p0_.discriminator_type IN ('productitemoption') ORDER BY p0_.sort_no DESC
Parameters:
[
2
]
|
42 | 0.45 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:
[] |
43 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.code = ? AND t0.enabled = ? AND t0.discriminator_type IN ('plugin') LIMIT 1
Parameters:
[ "ProductPlus" 1 ] |
44 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.input_type AS input_type_3, t0.is_required AS is_required_4, t0.search_flg AS search_flg_5, t0.keyword_flg AS keyword_flg_6, t0.sort_no AS sort_no_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM plg_productplus_dtb_product_item t0 WHERE t0.search_flg = ? AND t0.discriminator_type IN ('productitem') ORDER BY t0.sort_no DESC
Parameters:
[
1
]
|
45 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.code = ? AND t0.enabled = ? AND t0.discriminator_type IN ('plugin') LIMIT 1
Parameters:
[ "ProductPlus" 1 ] |
46 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.input_type AS input_type_3, t0.is_required AS is_required_4, t0.search_flg AS search_flg_5, t0.keyword_flg AS keyword_flg_6, t0.sort_no AS sort_no_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM plg_productplus_dtb_product_item t0 WHERE t0.discriminator_type IN ('productitem')
Parameters:
[] |
47 | 0.18 ms |
SELECT p0_.id AS id_0, p0_.text AS text_1, p0_.sort_no AS sort_no_2, p0_.discriminator_type AS discriminator_type_3, p0_.product_item_id AS product_item_id_4 FROM plg_productplus_dtb_product_item_option p0_ WHERE (p0_.product_item_id = ?) AND p0_.discriminator_type IN ('productitemoption') ORDER BY p0_.sort_no DESC
Parameters:
[
2
]
|
48 | 0.39 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:
[] |
49 | 1.66 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8290 ] |
50 | 0.15 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
93541
]
|
51 | 34.33 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"CHSC3"
]
|
52 | 0.32 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93539
]
|
53 | 0.15 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 93539 OR p0_.id = 93541) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
54 | 1.87 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 8290 OR p0_.product_id = 8290)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
55 | 0.16 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = 93540 AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
56 | 0.49 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
8290
]
|
57 | 1.55 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8284 ] |
58 | 0.12 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
93511
]
|
59 | 33.85 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"CH1001"
]
|
60 | 0.22 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93516
]
|
61 | 0.21 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93521
]
|
62 | 0.16 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 93511 OR p0_.id = 93516 OR p0_.id = 93521) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
63 | 0.40 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 8284 OR p0_.product_id = 8285 OR p0_.product_id = 8286)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
64 | 0.24 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 93510 OR p0_.product_data_id = 93515 OR p0_.product_data_id = 93520) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
65 | 0.49 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
8284
]
|
66 | 1.58 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8253 ] |
67 | 0.24 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
93356
]
|
68 | 34.27 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AXL-RAC-PC"
]
|
69 | 0.33 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93361
]
|
70 | 0.08 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93366
]
|
71 | 0.16 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 93361 OR p0_.id = 93366 OR p0_.id = 93356) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
72 | 0.25 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 8253 OR p0_.product_id = 8254 OR p0_.product_id = 8255)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
73 | 0.16 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 93355 OR p0_.product_data_id = 93360 OR p0_.product_data_id = 93365) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
74 | 0.47 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
8253
]
|
75 | 1.55 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8249 ] |
76 | 0.15 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
93336
]
|
77 | 34.26 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AXL-RAC-DR"
]
|
78 | 0.16 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93346
]
|
79 | 0.08 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93351
]
|
80 | 0.07 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93341
]
|
81 | 0.17 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 93346 OR p0_.id = 93351 OR p0_.id = 93341 OR p0_.id = 93336) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
82 | 0.28 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 8249 OR p0_.product_id = 8250 OR p0_.product_id = 8251 OR p0_.product_id = 8252)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
83 | 0.16 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 93335 OR p0_.product_data_id = 93340 OR p0_.product_data_id = 93345 OR p0_.product_data_id = 93350) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
84 | 0.42 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
8249
]
|
85 | 1.66 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8245 ] |
86 | 0.12 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
93316
]
|
87 | 34.17 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AXL-BA-650"
]
|
88 | 0.11 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93321
]
|
89 | 0.07 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93326
]
|
90 | 0.07 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93331
]
|
91 | 0.12 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 93321 OR p0_.id = 93326 OR p0_.id = 93331 OR p0_.id = 93316) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
92 | 0.25 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 8245 OR p0_.product_id = 8246 OR p0_.product_id = 8247 OR p0_.product_id = 8248)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
93 | 0.15 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 93315 OR p0_.product_data_id = 93320 OR p0_.product_data_id = 93325 OR p0_.product_data_id = 93330) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
94 | 0.37 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
8245
]
|
95 | 1.52 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8241 ] |
96 | 0.13 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
93296
]
|
97 | 34.07 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AXL-BA-350"
]
|
98 | 0.12 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93301
]
|
99 | 0.07 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93306
]
|
100 | 0.07 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
93311
]
|
101 | 0.12 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 93301 OR p0_.id = 93306 OR p0_.id = 93311 OR p0_.id = 93296) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
102 | 0.24 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 8241 OR p0_.product_id = 8242 OR p0_.product_id = 8243 OR p0_.product_id = 8244)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
103 | 0.15 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 93295 OR p0_.product_data_id = 93300 OR p0_.product_data_id = 93305 OR p0_.product_data_id = 93310) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
104 | 0.37 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
8241
]
|
105 | 1.51 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8139 ] |
106 | 0.12 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
92786
]
|
107 | 34.59 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AT27771-ATX00000533-WOLF"
]
|
108 | 0.11 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
92791
]
|
109 | 0.10 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 92786 OR p0_.id = 92791) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
110 | 0.18 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 8139 OR p0_.product_id = 8140)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
111 | 0.13 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 92785 OR p0_.product_data_id = 92790) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
112 | 0.38 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
8139
]
|
113 | 1.53 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8137 ] |
114 | 0.16 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
92776
]
|
115 | 34.23 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AT27771-ATX00000533-RG"
]
|
116 | 0.19 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
92781
]
|
117 | 0.16 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 92781 OR p0_.id = 92776) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
118 | 0.23 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 8137 OR p0_.product_id = 8138)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
119 | 0.18 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 92775 OR p0_.product_data_id = 92780) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
120 | 0.45 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
8137
]
|
121 | 1.55 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8135 ] |
122 | 0.15 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
92766
]
|
123 | 34.65 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AT27771-ATX00000533-CROCO"
]
|
124 | 0.15 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
92771
]
|
125 | 0.15 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 92766 OR p0_.id = 92771) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
126 | 0.22 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 8135 OR p0_.product_id = 8136)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
127 | 0.17 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 92765 OR p0_.product_data_id = 92770) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
128 | 0.43 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
8135
]
|
129 | 1.56 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8133 ] |
130 | 0.15 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
92756
]
|
131 | 34.67 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AT27771-ATX00000528-BLK"
]
|
132 | 0.32 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
92761
]
|
133 | 0.19 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 92761 OR p0_.id = 92756) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
134 | 0.26 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 8133 OR p0_.product_id = 8134)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
135 | 0.19 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 92755 OR p0_.product_data_id = 92760) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
136 | 0.51 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
8133
]
|
137 | 1.56 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8061 ] |
138 | 0.15 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
92396
]
|
139 | 34.00 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AT24873-ATX00000495-CROCO"
]
|
140 | 0.33 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 92396) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
141 | 1.65 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = 8061) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
142 | 0.18 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = 92395 AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
143 | 0.49 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
8061
]
|
144 | 1.54 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8060 ] |
145 | 0.15 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
92391
]
|
146 | 34.44 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AT24873-ATX00000495-BLK"
]
|
147 | 0.24 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 92391) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
148 | 1.65 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = 8060) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
149 | 0.17 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = 92390 AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
150 | 0.50 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
8060
]
|
151 | 1.56 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8042 ] |
152 | 0.15 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
92301
]
|
153 | 34.10 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AT23848-ATX00000491"
]
|
154 | 0.14 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
92306
]
|
155 | 0.11 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
92311
]
|
156 | 0.14 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 92301 OR p0_.id = 92306 OR p0_.id = 92311) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
157 | 0.26 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 8042 OR p0_.product_id = 8043 OR p0_.product_id = 8044)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
158 | 0.17 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 92300 OR p0_.product_data_id = 92305 OR p0_.product_data_id = 92310) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
159 | 0.41 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
8042
]
|
160 | 1.69 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 7626 ] |
161 | 0.31 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
90221
]
|
162 | 34.05 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AT15996-ATX00000488"
]
|
163 | 0.33 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
90231
]
|
164 | 0.11 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
90236
]
|
165 | 0.12 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
90226
]
|
166 | 0.21 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 90221 OR p0_.id = 90231 OR p0_.id = 90236 OR p0_.id = 90226) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
167 | 0.32 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 7626 OR p0_.product_id = 7627 OR p0_.product_id = 7628 OR p0_.product_id = 7629)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
168 | 0.21 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 90220 OR p0_.product_data_id = 90225 OR p0_.product_data_id = 90230 OR p0_.product_data_id = 90235) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
169 | 0.49 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
7626
]
|
170 | 1.56 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 7463 ] |
171 | 0.15 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
89406
]
|
172 | 35.51 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AT13454-ATX00000522-CROCO"
]
|
173 | 0.21 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 89406) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
174 | 1.57 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = 7463) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
175 | 0.16 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = 89405 AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
176 | 0.49 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
7463
]
|
177 | 1.55 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 7462 ] |
178 | 0.14 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
89401
]
|
179 | 34.18 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AT13454-ATX00000522-BLK"
]
|
180 | 0.33 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 89401) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
181 | 1.67 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = 7462) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
182 | 0.18 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = 89400 AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
183 | 0.49 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
7462
]
|
184 | 1.55 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 7431 ] |
185 | 0.16 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
89246
]
|
186 | 40.47 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AT11783-ATX00000464-MCAM"
]
|
187 | 0.34 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89261
]
|
188 | 0.12 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89251
]
|
189 | 0.11 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89256
]
|
190 | 0.12 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89266
]
|
191 | 0.20 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 89261 OR p0_.id = 89246 OR p0_.id = 89251 OR p0_.id = 89256 OR p0_.id = 89266) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
192 | 0.36 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 7431 OR p0_.product_id = 7432 OR p0_.product_id = 7433 OR p0_.product_id = 7434 OR p0_.product_id = 7435)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
193 | 0.22 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 89245 OR p0_.product_data_id = 89250 OR p0_.product_data_id = 89255 OR p0_.product_data_id = 89260 OR p0_.product_data_id = 89265) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
194 | 0.55 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
7431
]
|
195 | 1.54 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 7426 ] |
196 | 0.36 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
89221
]
|
197 | 34.41 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AT11783-ATX00000464-CYT"
]
|
198 | 0.35 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89226
]
|
199 | 0.12 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89231
]
|
200 | 0.11 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89236
]
|
201 | 0.11 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89241
]
|
202 | 0.20 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 89226 OR p0_.id = 89231 OR p0_.id = 89236 OR p0_.id = 89241 OR p0_.id = 89221) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
203 | 0.34 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 7426 OR p0_.product_id = 7427 OR p0_.product_id = 7428 OR p0_.product_id = 7429 OR p0_.product_id = 7430)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
204 | 0.22 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 89220 OR p0_.product_data_id = 89225 OR p0_.product_data_id = 89230 OR p0_.product_data_id = 89235 OR p0_.product_data_id = 89240) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
205 | 0.56 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
7426
]
|
206 | 2.13 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 7420 ] |
207 | 0.16 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
89191
]
|
208 | 43.94 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AT11783-ATX00000464-BLK"
]
|
209 | 0.31 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89216
]
|
210 | 0.10 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89201
]
|
211 | 0.08 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89206
]
|
212 | 0.07 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89211
]
|
213 | 0.07 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89196
]
|
214 | 0.17 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 89216 OR p0_.id = 89201 OR p0_.id = 89206 OR p0_.id = 89211 OR p0_.id = 89191 OR p0_.id = 89196) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
215 | 0.33 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 7420 OR p0_.product_id = 7421 OR p0_.product_id = 7422 OR p0_.product_id = 7423 OR p0_.product_id = 7424 OR p0_.product_id = 7425)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
216 | 0.19 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 89190 OR p0_.product_data_id = 89195 OR p0_.product_data_id = 89200 OR p0_.product_data_id = 89205 OR p0_.product_data_id = 89210 OR p0_.product_data_id = 89215) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
217 | 0.47 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
7420
]
|
218 | 1.56 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 7410 ] |
219 | 0.12 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
89141
]
|
220 | 35.70 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"AOSE-SP"
]
|
221 | 0.30 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89146
]
|
222 | 0.08 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
89151
]
|
223 | 0.19 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 89146 OR p0_.id = 89151 OR p0_.id = 89141) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
224 | 0.25 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 7410 OR p0_.product_id = 7411 OR p0_.product_id = 7412)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
225 | 0.17 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 89140 OR p0_.product_data_id = 89145 OR p0_.product_data_id = 89150) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
226 | 0.53 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') AND (((t0.category_id in (select id from dtb_category where schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:41:59' and time_to > '2024-10-05 11:41:59') or (time_from < '2024-10-05 11:41:59' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:41:59') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:41:59' or time_to < '2024-10-05 11:41:59' ) or chain_schedule_time_id is null) ) or schedule_time_id is null ))))
Parameters:
[
7410
]
|
227 | 0.25 ms |
SELECT p0_.recommend_id AS recommend_id_0, p0_.comment AS comment_1, p0_.sort_no AS sort_no_2, p0_.visible AS visible_3, p0_.create_date AS create_date_4, p0_.update_date AS update_date_5, p0_.discriminator_type AS discriminator_type_6, p0_.product_id AS product_id_7 FROM plg_recommend_product p0_ INNER JOIN dtb_product d1_ ON (d1_.id = p0_.product_id) AND d1_.discriminator_type IN ('product') WHERE (d1_.product_status_id = ? AND p0_.visible = 1) AND p0_.discriminator_type IN ('recommendproduct') ORDER BY p0_.sort_no DESC
Parameters:
[
1
]
|
228 | 0.16 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.slug AS slug_10, t0.grouping_code AS grouping_code_11, t0.priority_flag AS priority_flag_12, t0.shipping_name AS shipping_name_13, t0.plg_pu_private AS plg_pu_private_14, t0.plg_pu_private_key AS plg_pu_private_key_15, t0.plg_pu_publish_date AS plg_pu_publish_date_16, t0.free_description_about_quantity AS free_description_about_quantity_17, t0.free_description_about_selling_price AS free_description_about_selling_price_18, t0.free_description_of_payment_delivery AS free_description_of_payment_delivery_19, t0.creator_id AS creator_id_20, t0.product_status_id AS product_status_id_21, t0.schedule_time_id AS schedule_time_id_22, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = ? AND t0.discriminator_type IN ('product')
Parameters:
[
5807
]
|
229 | 1.54 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 5807 ] |
230 | 0.12 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
81126
]
|
231 | 34.61 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"10733"
]
|
232 | 0.33 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
81116
]
|
233 | 0.08 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
81121
]
|
234 | 0.07 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
81111
]
|
235 | 0.16 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 81116 OR p0_.id = 81121 OR p0_.id = 81126 OR p0_.id = 81111) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
236 | 0.27 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 5804 OR p0_.product_id = 5805 OR p0_.product_id = 5806 OR p0_.product_id = 5807)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
237 | 0.17 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 81110 OR p0_.product_data_id = 81115 OR p0_.product_data_id = 81120 OR p0_.product_data_id = 81125) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
238 | 0.12 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
5807
]
|
239 | 0.10 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
81124
]
|
240 | 0.25 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:
[
5807
]
|
241 | 0.18 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.regular_discount_id AS regular_discount_id_20, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productclass')
Parameters:
[
5807
]
|
242 | 0.11 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:
[
5815
]
|
243 | 0.11 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:
[
5815
]
|
244 | 0.16 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.slug AS slug_10, t0.grouping_code AS grouping_code_11, t0.priority_flag AS priority_flag_12, t0.shipping_name AS shipping_name_13, t0.plg_pu_private AS plg_pu_private_14, t0.plg_pu_private_key AS plg_pu_private_key_15, t0.plg_pu_publish_date AS plg_pu_publish_date_16, t0.free_description_about_quantity AS free_description_about_quantity_17, t0.free_description_about_selling_price AS free_description_about_selling_price_18, t0.free_description_of_payment_delivery AS free_description_of_payment_delivery_19, t0.creator_id AS creator_id_20, t0.product_status_id AS product_status_id_21, t0.schedule_time_id AS schedule_time_id_22, t0.discriminator_type FROM dtb_product t0 WHERE t0.id = ? AND t0.discriminator_type IN ('product')
Parameters:
[
8470
]
|
245 | 1.54 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND p0_.product_id = ?) AND p0_.discriminator_type IN ('productdata')
Parameters:
[ 1 8470 ] |
246 | 0.12 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.product_data_id = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
94441
]
|
247 | 34.94 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE (p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"FB204"
]
|
248 | 0.32 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
94456
]
|
249 | 0.08 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
94446
]
|
250 | 0.07 ms |
SELECT t0.id AS id_1, t0.create_date AS create_date_2, t0.product_item_id AS product_item_id_3, t0.product_id AS product_id_4, t0.discriminator_type FROM plg_productplus_dtb_product_data t0 WHERE t0.id = ? AND t0.discriminator_type IN ('productdata')
Parameters:
[
94451
]
|
251 | 0.19 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.id = 94456 OR p0_.id = 94446 OR p0_.id = 94451 OR p0_.id = 94441) AND p0_.discriminator_type IN ('productdata')
Parameters:
[] |
252 | 0.29 ms |
SELECT p0_.id AS id_0, p0_.create_date AS create_date_1, p0_.discriminator_type AS discriminator_type_2, p0_.product_item_id AS product_item_id_3, p0_.product_id AS product_id_4 FROM plg_productplus_dtb_product_data p0_ WHERE (p0_.product_item_id = ? AND (p0_.product_id = 8470 OR p0_.product_id = 8471 OR p0_.product_id = 8472 OR p0_.product_id = 8473)) AND p0_.discriminator_type IN ('productdata')
Parameters:
[
2
]
|
253 | 0.17 ms |
SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.num_value AS num_value_2, p0_.date_value AS date_value_3, p0_.sort_no AS sort_no_4, p0_.discriminator_type AS discriminator_type_5, p0_.product_data_id AS product_data_id_6 FROM plg_productplus_dtb_product_data_detail p0_ WHERE ((p0_.product_data_id = 94440 OR p0_.product_data_id = 94445 OR p0_.product_data_id = 94450 OR p0_.product_data_id = 94455) AND p0_.value = ?) AND p0_.discriminator_type IN ('productdatadetail')
Parameters:
[
"優先表示する"
]
|
254 | 0.23 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:
[
8470
]
|
255 | 0.20 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.regular_discount_id AS regular_discount_id_20, t0.discriminator_type FROM dtb_product_class t0 WHERE t0.product_id = ? AND t0.discriminator_type IN ('productclass')
Parameters:
[
8470
]
|
256 | 0.13 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:
[
8478
]
|
257 | 0.11 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:
[
8478
]
|
258 | 37.95 ms |
SELECT d0_.id AS id_0, d0_.category_name AS category_name_1, d0_.hierarchy AS hierarchy_2, d0_.sort_no AS sort_no_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.plg_content AS plg_content_6, d0_.plg_meta_description AS plg_meta_description_7, d0_.plg_file_name AS plg_file_name_8, d0_.plg_slug AS plg_slug_9, d1_.id AS id_10, d1_.category_name AS category_name_11, d1_.hierarchy AS hierarchy_12, d1_.sort_no AS sort_no_13, d1_.create_date AS create_date_14, d1_.update_date AS update_date_15, d1_.plg_content AS plg_content_16, d1_.plg_meta_description AS plg_meta_description_17, d1_.plg_file_name AS plg_file_name_18, d1_.plg_slug AS plg_slug_19, d2_.id AS id_20, d2_.category_name AS category_name_21, d2_.hierarchy AS hierarchy_22, d2_.sort_no AS sort_no_23, d2_.create_date AS create_date_24, d2_.update_date AS update_date_25, d2_.plg_content AS plg_content_26, d2_.plg_meta_description AS plg_meta_description_27, d2_.plg_file_name AS plg_file_name_28, d2_.plg_slug AS plg_slug_29, d3_.id AS id_30, d3_.category_name AS category_name_31, d3_.hierarchy AS hierarchy_32, d3_.sort_no AS sort_no_33, d3_.create_date AS create_date_34, d3_.update_date AS update_date_35, d3_.plg_content AS plg_content_36, d3_.plg_meta_description AS plg_meta_description_37, d3_.plg_file_name AS plg_file_name_38, d3_.plg_slug AS plg_slug_39, d4_.id AS id_40, d4_.category_name AS category_name_41, d4_.hierarchy AS hierarchy_42, d4_.sort_no AS sort_no_43, d4_.create_date AS create_date_44, d4_.update_date AS update_date_45, d4_.plg_content AS plg_content_46, d4_.plg_meta_description AS plg_meta_description_47, d4_.plg_file_name AS plg_file_name_48, d4_.plg_slug AS plg_slug_49, d0_.discriminator_type AS discriminator_type_50, d0_.parent_category_id AS parent_category_id_51, d0_.creator_id AS creator_id_52, d0_.schedule_time_id AS schedule_time_id_53, d1_.discriminator_type AS discriminator_type_54, d1_.parent_category_id AS parent_category_id_55, d1_.creator_id AS creator_id_56, d1_.schedule_time_id AS schedule_time_id_57, d2_.discriminator_type AS discriminator_type_58, d2_.parent_category_id AS parent_category_id_59, d2_.creator_id AS creator_id_60, d2_.schedule_time_id AS schedule_time_id_61, d3_.discriminator_type AS discriminator_type_62, d3_.parent_category_id AS parent_category_id_63, d3_.creator_id AS creator_id_64, d3_.schedule_time_id AS schedule_time_id_65, d4_.discriminator_type AS discriminator_type_66, d4_.parent_category_id AS parent_category_id_67, d4_.creator_id AS creator_id_68, d4_.schedule_time_id AS schedule_time_id_69 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id AND d1_.discriminator_type IN ('category') AND ((d1_.schedule_time_id is null or (d1_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:42:00' and time_to > '2024-10-05 11:42:00') or (time_from < '2024-10-05 11:42:00' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:42:00') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:42:00' or time_to < '2024-10-05 11:42:00' ) or chain_schedule_time_id is null) ) ))) LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id AND d2_.discriminator_type IN ('category') AND ((d2_.schedule_time_id is null or (d2_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:42:00' and time_to > '2024-10-05 11:42:00') or (time_from < '2024-10-05 11:42:00' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:42:00') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:42:00' or time_to < '2024-10-05 11:42:00' ) or chain_schedule_time_id is null) ) ))) LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id AND d3_.discriminator_type IN ('category') AND ((d3_.schedule_time_id is null or (d3_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:42:00' and time_to > '2024-10-05 11:42:00') or (time_from < '2024-10-05 11:42:00' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:42:00') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:42:00' or time_to < '2024-10-05 11:42:00' ) or chain_schedule_time_id is null) ) ))) LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id AND d4_.discriminator_type IN ('category') AND ((d4_.schedule_time_id is null or (d4_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:42:00' and time_to > '2024-10-05 11:42:00') or (time_from < '2024-10-05 11:42:00' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:42:00') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:42:00' or time_to < '2024-10-05 11:42:00' ) or chain_schedule_time_id is null) ) ))) WHERE ((d0_.parent_category_id IS NULL) AND ((d0_.schedule_time_id is null or (d0_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:42:00' and time_to > '2024-10-05 11:42:00') or (time_from < '2024-10-05 11:42:00' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:42:00') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:42:00' or time_to < '2024-10-05 11:42:00' ) or chain_schedule_time_id is null) ) )))) AND d0_.discriminator_type IN ('category') ORDER BY d0_.sort_no DESC, d1_.sort_no ASC, d2_.sort_no ASC, d3_.sort_no ASC, d4_.sort_no ASC
Parameters:
[] |
259 | 3.45 ms |
SELECT d0_.id AS id_0, d0_.category_name AS category_name_1, d0_.hierarchy AS hierarchy_2, d0_.sort_no AS sort_no_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.plg_content AS plg_content_6, d0_.plg_meta_description AS plg_meta_description_7, d0_.plg_file_name AS plg_file_name_8, d0_.plg_slug AS plg_slug_9, d1_.id AS id_10, d1_.category_name AS category_name_11, d1_.hierarchy AS hierarchy_12, d1_.sort_no AS sort_no_13, d1_.create_date AS create_date_14, d1_.update_date AS update_date_15, d1_.plg_content AS plg_content_16, d1_.plg_meta_description AS plg_meta_description_17, d1_.plg_file_name AS plg_file_name_18, d1_.plg_slug AS plg_slug_19, d2_.id AS id_20, d2_.category_name AS category_name_21, d2_.hierarchy AS hierarchy_22, d2_.sort_no AS sort_no_23, d2_.create_date AS create_date_24, d2_.update_date AS update_date_25, d2_.plg_content AS plg_content_26, d2_.plg_meta_description AS plg_meta_description_27, d2_.plg_file_name AS plg_file_name_28, d2_.plg_slug AS plg_slug_29, d3_.id AS id_30, d3_.category_name AS category_name_31, d3_.hierarchy AS hierarchy_32, d3_.sort_no AS sort_no_33, d3_.create_date AS create_date_34, d3_.update_date AS update_date_35, d3_.plg_content AS plg_content_36, d3_.plg_meta_description AS plg_meta_description_37, d3_.plg_file_name AS plg_file_name_38, d3_.plg_slug AS plg_slug_39, d4_.id AS id_40, d4_.category_name AS category_name_41, d4_.hierarchy AS hierarchy_42, d4_.sort_no AS sort_no_43, d4_.create_date AS create_date_44, d4_.update_date AS update_date_45, d4_.plg_content AS plg_content_46, d4_.plg_meta_description AS plg_meta_description_47, d4_.plg_file_name AS plg_file_name_48, d4_.plg_slug AS plg_slug_49, d0_.discriminator_type AS discriminator_type_50, d0_.parent_category_id AS parent_category_id_51, d0_.creator_id AS creator_id_52, d0_.schedule_time_id AS schedule_time_id_53, d1_.discriminator_type AS discriminator_type_54, d1_.parent_category_id AS parent_category_id_55, d1_.creator_id AS creator_id_56, d1_.schedule_time_id AS schedule_time_id_57, d2_.discriminator_type AS discriminator_type_58, d2_.parent_category_id AS parent_category_id_59, d2_.creator_id AS creator_id_60, d2_.schedule_time_id AS schedule_time_id_61, d3_.discriminator_type AS discriminator_type_62, d3_.parent_category_id AS parent_category_id_63, d3_.creator_id AS creator_id_64, d3_.schedule_time_id AS schedule_time_id_65, d4_.discriminator_type AS discriminator_type_66, d4_.parent_category_id AS parent_category_id_67, d4_.creator_id AS creator_id_68, d4_.schedule_time_id AS schedule_time_id_69 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id AND d1_.discriminator_type IN ('category') AND ((d1_.schedule_time_id is null or (d1_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:42:00' and time_to > '2024-10-05 11:42:00') or (time_from < '2024-10-05 11:42:00' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:42:00') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:42:00' or time_to < '2024-10-05 11:42:00' ) or chain_schedule_time_id is null) ) ))) LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id AND d2_.discriminator_type IN ('category') AND ((d2_.schedule_time_id is null or (d2_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:42:00' and time_to > '2024-10-05 11:42:00') or (time_from < '2024-10-05 11:42:00' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:42:00') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:42:00' or time_to < '2024-10-05 11:42:00' ) or chain_schedule_time_id is null) ) ))) LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id AND d3_.discriminator_type IN ('category') AND ((d3_.schedule_time_id is null or (d3_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:42:00' and time_to > '2024-10-05 11:42:00') or (time_from < '2024-10-05 11:42:00' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:42:00') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:42:00' or time_to < '2024-10-05 11:42:00' ) or chain_schedule_time_id is null) ) ))) LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id AND d4_.discriminator_type IN ('category') AND ((d4_.schedule_time_id is null or (d4_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:42:00' and time_to > '2024-10-05 11:42:00') or (time_from < '2024-10-05 11:42:00' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:42:00') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:42:00' or time_to < '2024-10-05 11:42:00' ) or chain_schedule_time_id is null) ) ))) WHERE ((d0_.parent_category_id IS NULL) AND ((d0_.schedule_time_id is null or (d0_.schedule_time_id in ( select schedule_time_id from plg_schedule_time where ( (time_from < '2024-10-05 11:42:00' and time_to > '2024-10-05 11:42:00') or (time_from < '2024-10-05 11:42:00' and time_to is null) or (time_from is null and time_to > '2024-10-05 11:42:00') or (time_from is null and time_to is null)) and (chain_schedule_time_id not in ( select schedule_time_id from plg_schedule_time where time_from > '2024-10-05 11:42:00' or time_to < '2024-10-05 11:42:00' ) or chain_schedule_time_id is null) ) )))) AND d0_.discriminator_type IN ('category') ORDER BY d0_.sort_no DESC, d1_.sort_no DESC, d2_.sort_no DESC, d3_.sort_no DESC, d4_.sort_no DESC
Parameters:
[] |
260 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.enabled AS enabled_4, t0.version AS version_5, t0.source AS source_6, t0.initialized AS initialized_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM dtb_plugin t0 WHERE t0.code = ? AND t0.enabled = ? AND t0.discriminator_type IN ('plugin') LIMIT 1
Parameters:
[ "ProductPlus" 1 ] |
261 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.input_type AS input_type_3, t0.is_required AS is_required_4, t0.search_flg AS search_flg_5, t0.keyword_flg AS keyword_flg_6, t0.sort_no AS sort_no_7, t0.create_date AS create_date_8, t0.update_date AS update_date_9, t0.discriminator_type FROM plg_productplus_dtb_product_item t0 WHERE t0.discriminator_type IN ('productitem')
Parameters:
[] |
262 | 0.17 ms |
SELECT p0_.id AS id_0, p0_.text AS text_1, p0_.sort_no AS sort_no_2, p0_.discriminator_type AS discriminator_type_3, p0_.product_item_id AS product_item_id_4 FROM plg_productplus_dtb_product_item_option p0_ WHERE (p0_.product_item_id = ?) AND p0_.discriminator_type IN ('productitemoption') ORDER BY p0_.sort_no DESC
Parameters:
[
2
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
Eccube\Entity\AbstractEntity | No errors. |
Eccube\Entity\Category | No errors. |
Plugin\CustomerGroup\Entity\Config | No errors. |
Eccube\Entity\Product |
|
Eccube\Entity\ProductCategory | No errors. |
Plugin\Schedule\Entity\ScheduleTime | No errors. |
Plugin\SearchPlus\Entity\SearchPlusConfig | No errors. |
Plugin\ApgSimpleCalendar\Entity\Config | No errors. |
Plugin\ApgSimpleCalendar\Entity\Holiday | No errors. |
Plugin\CancelPlugin\Entity\Config | No errors. |
Eccube\Entity\MailTemplate | No errors. |
Eccube\Entity\MailHistory | No errors. |
Eccube\Entity\BaseInfo | No errors. |
Eccube\Entity\Master\AbstractMasterEntity | No errors. |
Eccube\Entity\Master\Country | No errors. |
Eccube\Entity\Master\Pref | No errors. |
Plugin\CustomerGroupPrice\Entity\GroupPrice | No errors. |
Eccube\Entity\Master\OrderStatus | No errors. |
Eccube\Entity\ProductStock | No errors. |
Eccube\Entity\Plugin | No errors. |
Eccube\Entity\Page | No errors. |
Plugin\ProductPlus\Entity\ProductData | No errors. |
Plugin\ProductPlus\Entity\ProductDataDetail | No errors. |
Plugin\ApgRichCategory\Entity\Config | No errors. |
Eccube\Entity\Member | No errors. |
Plugin\CustomerGroup\Entity\Group | No errors. |
Eccube\Entity\PageLayout | No errors. |
Eccube\Entity\Block | No errors. |
Eccube\Entity\BlockPosition | No errors. |
Eccube\Entity\Master\DeviceType | No errors. |
Eccube\Entity\AuthorityRole | No errors. |
Eccube\Entity\Layout | No errors. |
Eccube\Entity\ClassCategory | No errors. |
Plugin\ProductReserve4\Entity\ProductClassExtra | No errors. |
Plugin\ProductReserve4\Entity\Config | No errors. |
Plugin\ProductReserve4\Entity\ProductExtra | No errors. |
Eccube\Entity\OrderItem | No errors. |
Eccube\Entity\Order | No errors. |
Eccube\Entity\Shipping | No errors. |
Plugin\ProductReserve4\Entity\ReserveOrder | No errors. |
Eccube\Entity\Customer | No errors. |
Eccube\Entity\Master\RoundingType | No errors. |
Eccube\Entity\Delivery | No errors. |
Eccube\Entity\CustomerFavoriteProduct | No errors. |
Eccube\Entity\Master\ProductListMax | No errors. |
Plugin\ProductPlus\Entity\ProductItem | No errors. |
Plugin\EccubePaymentLite4\Entity\Config | No errors. |
Plugin\ProductPlus\Entity\ProductItemOption | No errors. |
Eccube\Entity\Master\ProductListOrderBy | No errors. |
Eccube\Entity\Tag | No errors. |
Eccube\Entity\ProductTag | No errors. |
Plugin\Collection\Entity\Collection | No errors. |
Plugin\MailMagazine4\Entity\MailMagazineSendHistory | No errors. |
Eccube\Entity\ProductClass |
|
Eccube\Entity\Master\ProductStatus | No errors. |
Eccube\Entity\ProductImage | No errors. |
Plugin\Collection\Entity\CollectionProduct | No errors. |
Plugin\RelatedProduct4\Entity\RelatedProduct | No errors. |
Eccube\Entity\TaxRule | No errors. |
Eccube\Entity\Master\SaleType | No errors. |
Eccube\Entity\DeliveryDuration | No errors. |
Plugin\EccubePaymentLite4\Entity\RegularDiscount | No errors. |
Eccube\Entity\ClassName | No errors. |
Plugin\EccubePaymentLite4\Entity\ProductClassRegularCycle | No errors. |
Eccube\Entity\CartItem | No errors. |
Plugin\UaGaEEc4\Entity\UaGaEEc | No errors. |
Eccube\Entity\Cart | No errors. |
Eccube\Entity\News | No errors. |
Plugin\Api\Entity\WebHook | No errors. |
Plugin\SimpleMaintenance\Entity\SimpleMConfig | No errors. |
Eccube\Entity\Master\Work | No errors. |
Eccube\Entity\Master\Authority | No errors. |
Eccube\Entity\Master\TaxType | No errors. |
Eccube\Entity\Master\TaxDisplayType | No errors. |
Eccube\Entity\Master\OrderItemType | 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. |
Plugin\EccubePaymentLite4\Entity\PaymentStatus | No errors. |
Plugin\EccubePaymentLite4\Entity\RegularOrder | No errors. |
Eccube\Entity\CustomerAddress | No errors. |
Eccube\Entity\Master\CustomerStatus | No errors. |
Eccube\Entity\PaymentOption | No errors. |
Eccube\Entity\DeliveryFee | No errors. |
Eccube\Entity\DeliveryTime | No errors. |
Plugin\EccubePaymentLite4\Entity\DeliveryCompany | No errors. |
Plugin\EccubePaymentLite4\Entity\GmoEpsilonPayment | No errors. |
Plugin\EccubePaymentLite4\Entity\ConvenienceStore | No errors. |
Plugin\EccubePaymentLite4\Entity\IpBlackList | No errors. |
Plugin\EccubePaymentLite4\Entity\MyPageRegularSetting | No errors. |
Plugin\EccubePaymentLite4\Entity\RegularCycle |
|
Plugin\JoolenCategoryIcon4\Entity\Config | No errors. |
Plugin\JoolenCategoryIcon4\Entity\CategoryImage | No errors. |
Plugin\EccubePaymentLite4\Entity\RegularOrderItem | No errors. |
Plugin\EccubePaymentLite4\Entity\RegularShipping | No errors. |
Plugin\EccubePaymentLite4\Entity\RegularStatus | No errors. |
Plugin\EccubePaymentLite4\Entity\RegularCycleType | No errors. |
Plugin\Recommend4\Entity\RecommendProduct | No errors. |