情熱価格

ドンペン画像

■デバッグ
Array
(
    [mysql] => Array
        (
            [0] => select SQL_CALC_FOUND_ROWS
`dtb_products`.`dtb_products_id`,`dtb_products`.`show_flg`,`dtb_products`.`item_id`,`dtb_products`.`item_name_ja`,`dtb_products`.`item_description`,`dtb_products`.`item_price`,`dtb_products`.`item_price_flag`,`dtb_products`.`item_material`,`dtb_products`.`item_nutrition`,`dtb_products`.`item_jan`,`dtb_products`.`item_jan_id`,`dtb_products`.`item_tag`,`dtb_products`.`item_start`,`dtb_products`.`osusume_comment`,`ms_products_category`.`ms_products_category_id`,`ms_products_category`.`cat_name_en`,`ms_products_category`.`order_num` as cat_order,`ms_products_jan`.`ms_products_jan_id`,`ms_products_jan`.`code`,`ms_products_tag`.`text` as tag_text
from (dtb_products
left join ms_products_category on dtb_products.ms_products_category_id = ms_products_category.ms_products_category_id)
left join ms_products_tag on  FIND_IN_SET(ms_products_tag.name,dtb_products.item_tag) and `ms_products_tag`.`show_start` < NOW() and (`ms_products_tag`.`show_end`='0000-00-00 00:00:00' OR NOW() < `ms_products_tag`.`show_end`)  and `ms_products_tag`.`show_flg` = 1 and `ms_products_tag`.`del_flg`=0
left join ms_products_jan on  FIND_IN_SET(ms_products_jan.ms_products_jan_id,dtb_products.item_jan_id)

where dtb_products_id='3978' and (
	(`dtb_products`.`show_start`< '2024-03-28 18:10:24' OR `dtb_products`.`show_start` is NULL) AND
	(`dtb_products`.`show_end` > '2024-03-28 18:10:24' OR `dtb_products`.`show_end` is NULL 
	OR `dtb_products`.`show_end`='')
) and `dtb_products`.`ms_products_id`=1 and `dtb_products`.`del_flg`=0 and `dtb_products`.`show_flg`=1



 limit 0,1

            [1] => select SQL_CALC_FOUND_ROWS
*
from (dtb_banner
left join dtb_banner_view on dtb_banner.dtb_banner_id = dtb_banner_view.dtb_banner_id)

where dtb_banner_view.ms_banner_view_id=1 and dtb_banner_view.view=1 and dtb_banner.del_flg=0 and dtb_banner.show_flg=1 and '2024-03-28 18:10:24' > dtb_banner.show_start and ('2024-03-28 18:10:24' < dtb_banner.show_end  OR dtb_banner.show_end IS NULL )


 order by order_num asc


            [2] => select SQL_CALC_FOUND_ROWS
*
from ms_products_category
where `ms_products_category`.`ms_products_id`=1 and `ms_products_category`.`del_flg`=0 and `ms_products_category`.`show_flg`=1


 order by parent_cat_id asc,order_num asc,ms_products_category_id asc


        )

)