delete from ot_exrate where isnull(exrate) [ runtime:0.002216s ]
select exrate from ot_exrate where create_time='2023-05-04' limit 1 [ runtime:0.000504s ]
show columns from `ot_shopsys` [ runtime:0.001278s ]
select `sps_newsinformation` from `ot_shopsys` where ( sps_id=1 ) limit 1 [ runtime:0.000571s ]
show columns from `ot_cart` [ runtime:0.000703s ]
show columns from `ot_goods` [ runtime:0.001016s ]
show columns from `ot_products` [ runtime:0.000810s ]
delete from ot_exrate where isnull(exrate) [ runtime:0.002130s ]
select exrate from ot_exrate where create_time='2023-05-04' limit 1 [ runtime:0.000421s ]
select `sps_newsinformation` from `ot_shopsys` where ( sps_id=1 ) limit 1 [ runtime:0.000384s ]
select `sps_newsinformation` from `ot_shopsys` where ( sps_id=1 ) limit 1 [ runtime:0.000352s ]
select count(*) as tp_count from `ot_goods` where `gd_status` = 1 and `gd_type` = 'direct' and `gd_pre_sale` = 0 limit 1 [ runtime:0.000722s ]
select `gd_id`,`gd_theme`,`gd_price`,`gd_price_inte`,`gd_number`,`gd_webimg`,`gd_stock`,`gd_weight`,`gd_japan_theme`,`gd_type`,`gd_stock`,`gd_buy_alone`,`gd_delivery_place`,`gd_pre_sale` from `ot_goods` where `gd_status` = 1 and `gd_type` = 'direct' and `gd_pre_sale` = 0 order by gd_rank desc,gd_id desc limit 80,20 [ runtime:0.000833s ]
delete from ot_exrate where isnull(exrate) [ runtime:0.002848s ]
select exrate from ot_exrate where create_time='2023-05-04' limit 1 [ runtime:0.000372s ]
select `sps_newsinformation` from `ot_shopsys` where ( sps_id=1 ) limit 1 [ runtime:0.000331s ]
select `sps_newsinformation` from `ot_shopsys` where ( sps_id=1 ) limit 1 [ runtime:0.000473s ]
select gd_theme as value from `ot_goods` where `gd_status` = 1 and `gd_type` = 'direct' and `gd_buy_alone` = 0 [ runtime:0.000626s ]