药品筛选
上海运佳黄浦制药有限公司
×
  • 效期
    OTC
    会员可见
    开塞露(上海运佳)
    上海运佳黄浦制药有限公司
    规格：10ml F
    效期：2021-06-01 件装量：600
    库存：充裕 中包装：1
    加入购物车
    -
    +
  • 效期
    OTC
    会员可见
    复方土槿皮酊(运佳黄浦)
    上海运佳黄浦制药有限公司
    规格：15ml F
    效期：2022-01-31 件装量：240
    库存：充裕 中包装：1
    加入购物车
    -
    +
  • 效期
    OTC
    会员可见
    开塞露(上海运佳)
    上海运佳黄浦制药有限公司
    规格：20ml
    效期：2021-06-01 件装量：600
    库存：充裕 中包装：1
    加入购物车
    -
    +
  • 效期
    OTC
    会员可见
    解痉镇痛酊(运佳)
    上海运佳黄浦制药有限公司
    规格：30ml F
    效期：2021-06-01 件装量：160
    库存：充裕 中包装：1
    加入购物车
    -
    +
  • 效期
    OTC
    会员可见
    碘酊(运佳)
    上海运佳黄浦制药有限公司
    规格：20ml F
    效期：2021-07-30 件装量：240
    库存：充裕 中包装：1
    加入购物车
    -
    +
  • 效期
    OTC
    会员可见
    炉甘石洗剂(运佳)
    上海运佳黄浦制药有限公司
    规格：100ml F
    效期：2021-05-31 件装量：100
    库存：充裕 中包装：1
    加入购物车
    -
    +
  • 效期
    OTC
    会员可见
    硼酸洗液
    上海运佳黄浦制药有限公司
    规格：250ml 1
    效期：2021-06-30 件装量：60
    库存：充裕 中包装：1
    加入购物车
    -
    +
  • 效期
    Rx
    会员可见
    氧化锌软膏(运佳)
    上海运佳黄浦制药有限公司
    规格：20g
    效期：2021-10-30 件装量：240
    库存：充裕 中包装：1
    加入购物车
    -
    +
  • 效期
    OTC
    会员可见
    尿素维E乳膏(运佳黄浦)
    上海运佳黄浦制药有限公司
    规格：20g
    效期：2021-06-30 件装量：400
    库存：充裕 中包装：1
    加入购物车
    -
    +
0

消息
0
MessagesTimelineExceptionsViews23RouteQueries46MailsSessionRequest
443.07msRequest Duration4MBMemory UsageGET puyaoRoute
    • Booting (171.73ms)
    • Application (303.35ms)
      23 templates were rendered
      • yaoyigou.goods.index (resources/views_new/yaoyigou/goods/index.blade.php)9blade
        Params
        0
        result
        1
        jx
        2
        sccj
        3
        ypgg
        4
        cxGoods
        5
        category
        6
        navName
        7
        title
        8
        dh_check
      • yaoyigou.layouts.header (resources/views_new/yaoyigou/layouts/header.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
      • yaoyigou.ads.top-ad (resources/views_new/yaoyigou/ads/top-ad.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
        16
        ad
      • yaoyigou.layouts.search (resources/views_new/yaoyigou/layouts/search.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
      • yaoyigou.layouts.logo (resources/views_new/yaoyigou/layouts/logo.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
      • yaoyigou.ads.hot-search (resources/views_new/yaoyigou/ads/hot-search.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
        16
        ads
      • yaoyigou.layouts.nav (resources/views_new/yaoyigou/layouts/nav.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
      • layouts.nav_top (resources/views_new/layouts/nav_top.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
      • yaoyigou.goods.shaixuan (resources/views_new/yaoyigou/goods/shaixuan.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
      • yaoyigou.goods.datu (resources/views_new/yaoyigou/goods/datu.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
      • yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
        16
        v
        17
        k
      • yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
        16
        v
        17
        k
      • yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
        16
        v
        17
        k
      • yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
        16
        v
        17
        k
      • yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
        16
        v
        17
        k
      • yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
        16
        v
        17
        k
      • yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
        16
        v
        17
        k
      • yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
        16
        v
        17
        k
      • yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
        16
        v
        17
        k
      • yaoyigou.vendor.pagination.default (resources/views_new/yaoyigou/vendor/pagination/default.blade.php)2blade
        Params
        0
        paginator
        1
        elements
      • yaoyigou.layouts.footer (resources/views_new/yaoyigou/layouts/footer.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
      • yaoyigou.layouts.youce (resources/views_new/yaoyigou/layouts/youce.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
      • yaoyigou.layouts.app (resources/views_new/yaoyigou/layouts/app.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        ad152
        4
        rand_num
        5
        errors
        6
        result
        7
        jx
        8
        sccj
        9
        ypgg
        10
        cxGoods
        11
        category
        12
        navName
        13
        title
        14
        dh_check
        15
        goodsPresenter
      uri
      GET puyao
      as
      puyao
      controller
      App\Http\Controllers\Yaoyigou\GoodsController@puyao
      namespace
      App\Http\Controllers
      prefix
      null
      where
      file
      app/Http/Controllers/Yaoyigou/GoodsController.php:67-87
      46 statements were executed, 20 of which were duplicated, 26 unique167.1ms
      ys_test
      • select id from ecs_sensitive_words where '' like concat('%', keywords, '%')8.93msys_test
        Metadata
      • select count(*) as aggregate from `ecs_goods` inner join `ecs_goods_statistics` on `ecs_goods`.`goods_id` = `ecs_goods_statistics`.`goods_id` and `is_mtx` = '0' where `ecs_goods`.`is_delete` = '0' and `online` = '1' and `off_sale_ranks` != '1,2,5,7,8,9' and (`ecs_goods`.`goods_name` like '%%' or `ecs_goods`.`goods_name1` like '%%' or `ecs_goods_statistics`.`brand_name` like '%%' or `ecs_goods_statistics`.`cate_name` like '%%') and `ecs_goods`.`product_name` = '上海运佳黄浦制药有限公司'9.85msys_test
        Metadata
        Bindings
        • 0. 0
        • 1. 0
        • 2. 1
        • 3. 1,2,5,7,8,9
        • 4. %%
        • 5. %%
        • 6. %%
        • 7. %%
        • 8. 上海运佳黄浦制药有限公司
        Hints
        • The != operator is not standard. Use the <> operator to test for inequality instead.
      • select `ecs_goods`.`goods_id`, `ecs_goods`.`goods_name`, `ecs_goods`.`shop_price`, `ecs_goods`.`qyhy_price`, `ecs_goods`.`is_kxpz`, `ecs_goods`.`is_promote`, `ecs_goods`.`promote_price`, `ecs_goods`.`promote_start_date`, `ecs_goods`.`promote_end_date`, `ecs_goods`.`is_xkh_tj`, `ecs_goods`.`xg_type`, `ecs_goods`.`xg_start_date`, `ecs_goods`.`xg_end_date`, `ecs_goods`.`xrtj_xg_num`, `ecs_goods`.`ls_ggg`, `ecs_goods`.`cat_ids`, `ecs_goods`.`show_area`, `ecs_goods`.`mtx_show_area`, `ecs_goods`.`ERPID`, `ecs_goods`.`xq`, `ecs_goods`.`ckid`, `ecs_goods`.`goods_number`, `ecs_goods`.`ls_gg`, `ecs_goods`.`goods_img`, `ecs_goods`.`goods_thumb`, `ecs_goods`.`zyzk`, `ecs_goods`.`tsbz`, `ecs_goods`.`is_show`, `ecs_goods`.`is_zbz`, `ecs_goods`.`g_ranks`, `ecs_goods`.`is_otc`, case when is_promote = 1 and promote_end_date > UNIX_TIMESTAMP() then 1 else 0 end as is_promote_tag, `ecs_goods`.`ls_min_count` from `ecs_goods` inner join `ecs_goods_statistics` on `ecs_goods`.`goods_id` = `ecs_goods_statistics`.`goods_id` and `is_mtx` = '0' where `ecs_goods`.`is_delete` = '0' and `online` = '1' and `off_sale_ranks` != '1,2,5,7,8,9' and (`ecs_goods`.`goods_name` like '%%' or `ecs_goods`.`goods_name1` like '%%' or `ecs_goods_statistics`.`brand_name` like '%%' or `ecs_goods_statistics`.`cate_name` like '%%') and `ecs_goods`.`product_name` = '上海运佳黄浦制药有限公司' order by `ecs_goods_statistics`.`score` desc, `ecs_goods`.`sort_order` asc, `ecs_goods`.`goods_id` asc limit 40 offset 017.43msys_test
        Metadata
        Bindings
        • 0. 0
        • 1. 0
        • 2. 1
        • 3. 1,2,5,7,8,9
        • 4. %%
        • 5. %%
        • 6. %%
        • 7. %%
        • 8. 上海运佳黄浦制药有限公司
        Hints
        • The != operator is not standard. Use the <> operator to test for inequality instead.
      • select `goods_id`, `attr_id`, `attr_value` from `ecs_goods_attr` where `ecs_goods_attr`.`goods_id` in ('221', '7399', '220', '254', '365', '7174', '8107', '9483', '9611')2.69msys_test
        Metadata
        Bindings
        • 0. 221
        • 1. 7399
        • 2. 220
        • 3. 254
        • 4. 365
        • 5. 7174
        • 6. 8107
        • 7. 9483
        • 8. 9611
      • select * from `ecs_goods_attribute` where `ecs_goods_attribute`.`goods_id` in ('221', '7399', '220', '254', '365', '7174', '8107', '9483', '9611')2.16msys_test
        Metadata
        Bindings
        • 0. 221
        • 1. 7399
        • 2. 220
        • 3. 254
        • 4. 365
        • 5. 7174
        • 6. 8107
        • 7. 9483
        • 8. 9611
        Hints
        • Use SELECT * only if you need all columns from table
      • select `goods_id`, `user_price`, `kx_price`, `aba_price` from `ecs_member_price` where `user_rank` = '1' and `ecs_member_price`.`goods_id` in ('221', '7399', '220', '254', '365', '7174', '8107', '9483', '9611')2.17msys_test
        Metadata
        Bindings
        • 0. 1
        • 1. 221
        • 2. 7399
        • 3. 220
        • 4. 254
        • 5. 365
        • 6. 7174
        • 7. 8107
        • 8. 9483
        • 9. 9611
      • select `ecs_zp_goods`.`goods_id`, `ecs_zp_goods`.`goods_name`, `ecs_zp_goods`.`shop_price`, `ecs_zp_goods`.`qyhy_price`, `ecs_zp_goods`.`is_kxpz`, `ecs_zp_goods`.`product_name`, `ecs_zp_goods`.`is_promote`, `ecs_zp_goods`.`promote_price`, `ecs_zp_goods`.`promote_start_date`, `ecs_zp_goods`.`promote_end_date`, `ecs_zp_goods`.`is_xkh_tj`, `ecs_zp_goods`.`xg_type`, `ecs_zp_goods`.`xg_start_date`, `ecs_zp_goods`.`xg_end_date`, `ecs_zp_goods`.`xrtj_xg_num`, `ecs_zp_goods`.`ls_ggg`, `ecs_zp_goods`.`is_on_sale`, `ecs_zp_goods`.`cat_ids`, `ecs_zp_goods`.`show_area`, `ecs_zp_goods`.`ERPID`, `ecs_zp_goods`.`xq`, `ecs_zp_goods`.`ckid`, `ecs_zp_goods`.`goods_number`, `ecs_zp_goods`.`ls_gg`, `ecs_zp_goods`.`goods_img`, `ecs_zp_goods`.`goods_thumb`, `ecs_zp_goods`.`zyzk`, `ecs_zp_goods`.`tsbz`, `ecs_zp_goods`.`erp_shangplx`, `ecs_zp_goods`.`is_alone_sale`, `ecs_zp_goods`.`is_delete`, `ecs_zp_goods`.`ls_buy_user_id`, `ecs_zp_goods`.`ls_regions`, `ecs_zp_goods`.`zs_regions`, `ecs_zp_goods`.`yy_regions`, `ecs_zp_goods`.`zs_user_ids`, `ecs_zp_goods`.`yy_user_ids`, `ecs_zp_goods`.`ls_ranks`, `ecs_zp_goods`.`ls_user_ids`, `ecs_goods_zp`.`goods_id` as `pivot_goods_id`, `ecs_goods_zp`.`zp_id` as `pivot_zp_id`, `ecs_goods_zp`.`goods_number` as `pivot_goods_number`, `ecs_goods_zp`.`zp_number` as `pivot_zp_number`, `ecs_goods_zp`.`message` as `pivot_message`, `ecs_goods_zp`.`type` as `pivot_type`, `ecs_goods_zp`.`is_erp` as `pivot_is_erp`, `ecs_goods_zp`.`is_goods` as `pivot_is_goods`, `ecs_goods_zp`.`is_give` as `pivot_is_give` from `ecs_zp_goods` inner join `ecs_goods_zp` on `ecs_zp_goods`.`goods_id` = `ecs_goods_zp`.`zp_id` where `ecs_goods_zp`.`start` <= '1750714763' and `ecs_goods_zp`.`end` > '1750714763' and `ecs_goods_zp`.`is_goods` = '0' and `ecs_goods_zp`.`zp_number` <= ecs_zp_goods.goods_number and `ecs_goods_zp`.`enabled` = '1' and `ecs_goods_zp`.`is_delete` = '0' and `ecs_zp_goods`.`goods_number` > '0' and `ecs_goods_zp`.`goods_id` in ('221', '7399', '220', '254', '365', '7174', '8107', '9483', '9611') order by `ecs_goods_zp`.`goods_number` desc2.57msys_test
        Metadata
        Bindings
        • 0. 1750714763
        • 1. 1750714763
        • 2. 0
        • 3. 1
        • 4. 0
        • 5. 0
        • 6. 221
        • 7. 7399
        • 8. 220
        • 9. 254
        • 10. 365
        • 11. 7174
        • 12. 8107
        • 13. 9483
        • 14. 9611
      • select `ecs_goods`.`goods_sn`, `ecs_goods`.`goods_id`, `ecs_goods`.`goods_name`, `ecs_goods`.`shop_price`, `ecs_goods`.`qyhy_price`, `ecs_goods`.`is_kxpz`, `ecs_goods`.`is_promote`, `ecs_goods`.`promote_price`, `ecs_goods`.`promote_start_date`, `ecs_goods`.`promote_end_date`, `ecs_goods`.`is_xkh_tj`, `ecs_goods`.`xg_type`, `ecs_goods`.`xg_start_date`, `ecs_goods`.`xg_end_date`, `ecs_goods`.`xrtj_xg_num`, `ecs_goods`.`ls_ggg`, `ecs_goods`.`cat_ids`, `ecs_goods`.`show_area`, `ecs_goods`.`mtx_show_area`, `ecs_goods`.`ERPID`, `ecs_goods`.`xq`, `ecs_goods`.`ckid`, `ecs_goods`.`goods_number`, `ecs_goods`.`ls_gg`, `ecs_goods`.`goods_img`, `ecs_goods`.`goods_thumb`, `ecs_goods`.`zyzk`, `ecs_goods`.`tsbz`, `ecs_goods`.`erp_shangplx`, `ecs_goods`.`is_delete`, `ecs_goods`.`ls_buy_user_id`, `ecs_goods`.`ls_regions`, `ecs_goods`.`zs_regions`, `ecs_goods`.`yy_regions`, `ecs_goods`.`zs_user_ids`, `ecs_goods`.`yy_user_ids`, `ecs_goods`.`ls_ranks`, `ecs_goods`.`ls_user_ids`, `ecs_goods_zp`.`goods_id` as `pivot_goods_id`, `ecs_goods_zp`.`zp_id` as `pivot_zp_id`, `ecs_goods_zp`.`goods_number` as `pivot_goods_number`, `ecs_goods_zp`.`zp_number` as `pivot_zp_number`, `ecs_goods_zp`.`message` as `pivot_message`, `ecs_goods_zp`.`type` as `pivot_type`, `ecs_goods_zp`.`is_erp` as `pivot_is_erp`, `ecs_goods_zp`.`is_goods` as `pivot_is_goods`, `ecs_goods_zp`.`is_give` as `pivot_is_give` from `ecs_goods` inner join `ecs_goods_zp` on `ecs_goods`.`goods_id` = `ecs_goods_zp`.`zp_id` where `ecs_goods_zp`.`start` <= '1750714763' and `ecs_goods_zp`.`end` > '1750714763' and `ecs_goods_zp`.`is_goods` = '1' and `ecs_goods_zp`.`enabled` = '1' and `ecs_goods_zp`.`is_delete` = '0' and `ecs_goods_zp`.`goods_id` in ('221', '7399', '220', '254', '365', '7174', '8107', '9483', '9611') order by `ecs_goods_zp`.`goods_number` desc2.41msys_test
        Metadata
        Bindings
        • 0. 1750714763
        • 1. 1750714763
        • 2. 1
        • 3. 1
        • 4. 0
        • 5. 221
        • 6. 7399
        • 7. 220
        • 8. 254
        • 9. 365
        • 10. 7174
        • 11. 8107
        • 12. 9483
        • 13. 9611
      • select `ERPID`, `ckid`, `goods_number`, `goods_price`, `xq` from `ecs_spkc_tj` where `is_on_sale` = '1' and `goods_number` > '0' and `goods_price` > '0' and `ecs_spkc_tj`.`ERPID` in ('7BB0CE706F532512E053752512ACAA06', '7BB0CE70624C2512E053752512ACAA06', '7BB0CE706F512512E053752512ACAA06', '7BB0CE7067362512E053752512ACAA06', '7BB0CE70578B2512E053752512ACAA06', '7BB0CE7061D72512E053752512ACAA06', '7BB0CE70865B2512E053752512ACAA06', '7BB0CE70E0042512E053752512ACAA06', '7BB0CE70E5D92512E053752512ACAA06')2.18msys_test
        Metadata
        Bindings
        • 0. 1
        • 1. 0
        • 2. 0
        • 3. 7BB0CE706F532512E053752512ACAA06
        • 4. 7BB0CE70624C2512E053752512ACAA06
        • 5. 7BB0CE706F512512E053752512ACAA06
        • 6. 7BB0CE7067362512E053752512ACAA06
        • 7. 7BB0CE70578B2512E053752512ACAA06
        • 8. 7BB0CE7061D72512E053752512ACAA06
        • 9. 7BB0CE70865B2512E053752512ACAA06
        • 10. 7BB0CE70E0042512E053752512ACAA06
        • 11. 7BB0CE70E5D92512E053752512ACAA06
      • select * from `ecs_goods_zp_region` where `region_id` = '8'2.2msys_test
        Metadata
        Bindings
        • 0. 8
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `ecs_goods_zp` where `ecs_goods_zp`.`goods_id` in ('221', '7399', '220', '254', '365', '7174', '8107', '9483', '9611') and `enabled` = '1' and `start` < '1750714763' and `end` > '1750714763' and `is_delete` = '0' and `id` in ('1', '2', '3', '4', '5', '6', '7', '8', '9', '11', '12', '13', '14', '15', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '50', '51', '53', '54', '55', '58', '59', '62', '60', '61', '69', '72', '73', '75', '77', '76', '79', '80', '86', '85', '87')2.48msys_test
        Metadata
        Bindings
        • 0. 221
        • 1. 7399
        • 2. 220
        • 3. 254
        • 4. 365
        • 5. 7174
        • 6. 8107
        • 7. 9483
        • 8. 9611
        • 9. 1
        • 10. 1750714763
        • 11. 1750714763
        • 12. 0
        • 13. 1
        • 14. 2
        • 15. 3
        • 16. 4
        • 17. 5
        • 18. 6
        • 19. 7
        • 20. 8
        • 21. 9
        • 22. 11
        • 23. 12
        • 24. 13
        • 25. 14
        • 26. 15
        • 27. 17
        • 28. 18
        • 29. 19
        • 30. 20
        • 31. 21
        • 32. 22
        • 33. 23
        • 34. 24
        • 35. 25
        • 36. 26
        • 37. 27
        • 38. 28
        • 39. 29
        • 40. 30
        • 41. 31
        • 42. 32
        • 43. 33
        • 44. 34
        • 45. 35
        • 46. 36
        • 47. 37
        • 48. 38
        • 49. 39
        • 50. 40
        • 51. 41
        • 52. 42
        • 53. 43
        • 54. 44
        • 55. 45
        • 56. 46
        • 57. 47
        • 58. 48
        • 59. 49
        • 60. 50
        • 61. 51
        • 62. 53
        • 63. 54
        • 64. 55
        • 65. 58
        • 66. 59
        • 67. 62
        • 68. 60
        • 69. 61
        • 70. 69
        • 71. 72
        • 72. 73
        • 73. 75
        • 74. 77
        • 75. 76
        • 76. 79
        • 77. 80
        • 78. 86
        • 79. 85
        • 80. 87
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `ecs_miaosha_group_region` where `region_id` = '8'2.01msys_test
        Metadata
        Bindings
        • 0. 8
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `ecs_miaosha_group` where `start_time` <= '2025-06-24 05:39:23' and `end_time` > '2025-06-24 05:39:23' and `is_enabled` = '1' and isnull(delete_time) and `id` in ('2', '39', '1', '3', '4', '5', '7', '12', '15', '16', '17', '21', '24', '25', '33', '35', '40', '42', '43', '44', '45', '41', '48', '50', '54') limit 12.4msys_test
        Metadata
        Bindings
        • 0. 2025-06-24 05:39:23
        • 1. 2025-06-24 05:39:23
        • 2. 1
        • 3. 2
        • 4. 39
        • 5. 1
        • 6. 3
        • 7. 4
        • 8. 5
        • 9. 7
        • 10. 12
        • 11. 15
        • 12. 16
        • 13. 17
        • 14. 21
        • 15. 24
        • 16. 25
        • 17. 33
        • 18. 35
        • 19. 40
        • 20. 42
        • 21. 43
        • 22. 44
        • 23. 45
        • 24. 41
        • 25. 48
        • 26. 50
        • 27. 54
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select `ypgg` from `ecs_goods` inner join `ecs_goods_statistics` on `ecs_goods`.`goods_id` = `ecs_goods_statistics`.`goods_id` and `is_mtx` = '0' where `ecs_goods`.`is_delete` = '0' and `online` = '1' and `off_sale_ranks` != '1,2,5,7,8,9' and (`ecs_goods`.`goods_name` like '%%' or `ecs_goods`.`goods_name1` like '%%' or `ecs_goods_statistics`.`brand_name` like '%%' or `ecs_goods_statistics`.`cate_name` like '%%') and `ecs_goods`.`product_name` = '上海运佳黄浦制药有限公司' and `ypgg` != '' group by `ypgg` order by `ecs_goods_statistics`.`score` desc, `ecs_goods`.`sort_order` asc, `ecs_goods`.`goods_id` asc9.9msys_test
        Metadata
        Bindings
        • 0. 0
        • 1. 0
        • 2. 1
        • 3. 1,2,5,7,8,9
        • 4. %%
        • 5. %%
        • 6. %%
        • 7. %%
        • 8. 上海运佳黄浦制药有限公司
        • 9. 
        Hints
        • The != operator is not standard. Use the <> operator to test for inequality instead.
      • select * from `ecs_ad` where `position_id` = '152' and `enabled` > '0' and `end_time` > '1750714763' order by `sort_order` desc, `ad_id` desc2.21msys_test
        Metadata
        Bindings
        • 0. 152
        • 1. 0
        • 2. 1750714763
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `ecs_ad` where `position_id` = '159' and `enabled` > '0' and `end_time` > '1750714763' order by `sort_order` desc, `ad_id` desc2.26msys_test
        Metadata
        Bindings
        • 0. 159
        • 1. 0
        • 2. 1750714763
        Hints
        • Use SELECT * only if you need all columns from table
      • select `name`, `url`, `opennew`, `id` from `ecs_nav` where `ifshow` = '1' and `type` = 'middle' and 1 = 1 order by `type` asc, `vieworder` asc2.65msys_test
        Metadata
        Bindings
        • 0. 1
        • 1. middle
      • select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '221' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750714763' and `end_time` >= '1750714763' limit 13.22msys_test
        Metadata
        Bindings
        • 0. 221
        • 1. 1
        • 2. 1750714763
        • 3. 1750714763
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_miaosha_group_region` where `region_id` = '8'2.16msys_test
        Metadata
        Bindings
        • 0. 8
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `ecs_miaosha_group` where `start_time` <= '2025-06-24 05:39:23' and `end_time` > '2025-06-24 05:39:23' and `is_enabled` = '1' and isnull(delete_time) and `id` in ('2', '39', '1', '3', '4', '5', '7', '12', '15', '16', '17', '21', '24', '25', '33', '35', '40', '42', '43', '44', '45', '41', '48', '50', '54') limit 12.44msys_test
        Metadata
        Bindings
        • 0. 2025-06-24 05:39:23
        • 1. 2025-06-24 05:39:23
        • 2. 1
        • 3. 2
        • 4. 39
        • 5. 1
        • 6. 3
        • 7. 4
        • 8. 5
        • 9. 7
        • 10. 12
        • 11. 15
        • 12. 16
        • 13. 17
        • 14. 21
        • 15. 24
        • 16. 25
        • 17. 33
        • 18. 35
        • 19. 40
        • 20. 42
        • 21. 43
        • 22. 44
        • 23. 45
        • 24. 41
        • 25. 48
        • 26. 50
        • 27. 54
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '7399' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750714763' and `end_time` >= '1750714763' limit 12.06msys_test
        Metadata
        Bindings
        • 0. 7399
        • 1. 1
        • 2. 1750714763
        • 3. 1750714763
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_miaosha_group_region` where `region_id` = '8'2.11msys_test
        Metadata
        Bindings
        • 0. 8
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `ecs_miaosha_group` where `start_time` <= '2025-06-24 05:39:23' and `end_time` > '2025-06-24 05:39:23' and `is_enabled` = '1' and isnull(delete_time) and `id` in ('2', '39', '1', '3', '4', '5', '7', '12', '15', '16', '17', '21', '24', '25', '33', '35', '40', '42', '43', '44', '45', '41', '48', '50', '54') limit 12.67msys_test
        Metadata
        Bindings
        • 0. 2025-06-24 05:39:23
        • 1. 2025-06-24 05:39:23
        • 2. 1
        • 3. 2
        • 4. 39
        • 5. 1
        • 6. 3
        • 7. 4
        • 8. 5
        • 9. 7
        • 10. 12
        • 11. 15
        • 12. 16
        • 13. 17
        • 14. 21
        • 15. 24
        • 16. 25
        • 17. 33
        • 18. 35
        • 19. 40
        • 20. 42
        • 21. 43
        • 22. 44
        • 23. 45
        • 24. 41
        • 25. 48
        • 26. 50
        • 27. 54
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '220' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750714763' and `end_time` >= '1750714763' limit 12.03msys_test
        Metadata
        Bindings
        • 0. 220
        • 1. 1
        • 2. 1750714763
        • 3. 1750714763
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_miaosha_group_region` where `region_id` = '8'2.58msys_test
        Metadata
        Bindings
        • 0. 8
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `ecs_miaosha_group` where `start_time` <= '2025-06-24 05:39:23' and `end_time` > '2025-06-24 05:39:23' and `is_enabled` = '1' and isnull(delete_time) and `id` in ('2', '39', '1', '3', '4', '5', '7', '12', '15', '16', '17', '21', '24', '25', '33', '35', '40', '42', '43', '44', '45', '41', '48', '50', '54') limit 12.34msys_test
        Metadata
        Bindings
        • 0. 2025-06-24 05:39:23
        • 1. 2025-06-24 05:39:23
        • 2. 1
        • 3. 2
        • 4. 39
        • 5. 1
        • 6. 3
        • 7. 4
        • 8. 5
        • 9. 7
        • 10. 12
        • 11. 15
        • 12. 16
        • 13. 17
        • 14. 21
        • 15. 24
        • 16. 25
        • 17. 33
        • 18. 35
        • 19. 40
        • 20. 42
        • 21. 43
        • 22. 44
        • 23. 45
        • 24. 41
        • 25. 48
        • 26. 50
        • 27. 54
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '254' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750714763' and `end_time` >= '1750714763' limit 18.41msys_test
        Metadata
        Bindings
        • 0. 254
        • 1. 1
        • 2. 1750714763
        • 3. 1750714763
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_miaosha_group_region` where `region_id` = '8'2.56msys_test
        Metadata
        Bindings
        • 0. 8
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `ecs_miaosha_group` where `start_time` <= '2025-06-24 05:39:23' and `end_time` > '2025-06-24 05:39:23' and `is_enabled` = '1' and isnull(delete_time) and `id` in ('2', '39', '1', '3', '4', '5', '7', '12', '15', '16', '17', '21', '24', '25', '33', '35', '40', '42', '43', '44', '45', '41', '48', '50', '54') limit 15.07msys_test
        Metadata
        Bindings
        • 0. 2025-06-24 05:39:23
        • 1. 2025-06-24 05:39:23
        • 2. 1
        • 3. 2
        • 4. 39
        • 5. 1
        • 6. 3
        • 7. 4
        • 8. 5
        • 9. 7
        • 10. 12
        • 11. 15
        • 12. 16
        • 13. 17
        • 14. 21
        • 15. 24
        • 16. 25
        • 17. 33
        • 18. 35
        • 19. 40
        • 20. 42
        • 21. 43
        • 22. 44
        • 23. 45
        • 24. 41
        • 25. 48
        • 26. 50
        • 27. 54
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '365' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750714763' and `end_time` >= '1750714763' limit 12.11msys_test
        Metadata
        Bindings
        • 0. 365
        • 1. 1
        • 2. 1750714763
        • 3. 1750714763
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_miaosha_group_region` where `region_id` = '8'2.07msys_test
        Metadata
        Bindings
        • 0. 8
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `ecs_miaosha_group` where `start_time` <= '2025-06-24 05:39:23' and `end_time` > '2025-06-24 05:39:23' and `is_enabled` = '1' and isnull(delete_time) and `id` in ('2', '39', '1', '3', '4', '5', '7', '12', '15', '16', '17', '21', '24', '25', '33', '35', '40', '42', '43', '44', '45', '41', '48', '50', '54') limit 12.53msys_test
        Metadata
        Bindings
        • 0. 2025-06-24 05:39:23
        • 1. 2025-06-24 05:39:23
        • 2. 1
        • 3. 2
        • 4. 39
        • 5. 1
        • 6. 3
        • 7. 4
        • 8. 5
        • 9. 7
        • 10. 12
        • 11. 15
        • 12. 16
        • 13. 17
        • 14. 21
        • 15. 24
        • 16. 25
        • 17. 33
        • 18. 35
        • 19. 40
        • 20. 42
        • 21. 43
        • 22. 44
        • 23. 45
        • 24. 41
        • 25. 48
        • 26. 50
        • 27. 54
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '7174' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750714763' and `end_time` >= '1750714763' limit 12.88msys_test
        Metadata
        Bindings
        • 0. 7174
        • 1. 1
        • 2. 1750714763
        • 3. 1750714763
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_miaosha_group_region` where `region_id` = '8'2.14msys_test
        Metadata
        Bindings
        • 0. 8
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `ecs_miaosha_group` where `start_time` <= '2025-06-24 05:39:23' and `end_time` > '2025-06-24 05:39:23' and `is_enabled` = '1' and isnull(delete_time) and `id` in ('2', '39', '1', '3', '4', '5', '7', '12', '15', '16', '17', '21', '24', '25', '33', '35', '40', '42', '43', '44', '45', '41', '48', '50', '54') limit 13.42msys_test
        Metadata
        Bindings
        • 0. 2025-06-24 05:39:23
        • 1. 2025-06-24 05:39:23
        • 2. 1
        • 3. 2
        • 4. 39
        • 5. 1
        • 6. 3
        • 7. 4
        • 8. 5
        • 9. 7
        • 10. 12
        • 11. 15
        • 12. 16
        • 13. 17
        • 14. 21
        • 15. 24
        • 16. 25
        • 17. 33
        • 18. 35
        • 19. 40
        • 20. 42
        • 21. 43
        • 22. 44
        • 23. 45
        • 24. 41
        • 25. 48
        • 26. 50
        • 27. 54
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '8107' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750714763' and `end_time` >= '1750714763' limit 15.27msys_test
        Metadata
        Bindings
        • 0. 8107
        • 1. 1
        • 2. 1750714763
        • 3. 1750714763
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_miaosha_group_region` where `region_id` = '8'2.05msys_test
        Metadata
        Bindings
        • 0. 8
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `ecs_miaosha_group` where `start_time` <= '2025-06-24 05:39:23' and `end_time` > '2025-06-24 05:39:23' and `is_enabled` = '1' and isnull(delete_time) and `id` in ('2', '39', '1', '3', '4', '5', '7', '12', '15', '16', '17', '21', '24', '25', '33', '35', '40', '42', '43', '44', '45', '41', '48', '50', '54') limit 14.63msys_test
        Metadata
        Bindings
        • 0. 2025-06-24 05:39:23
        • 1. 2025-06-24 05:39:23
        • 2. 1
        • 3. 2
        • 4. 39
        • 5. 1
        • 6. 3
        • 7. 4
        • 8. 5
        • 9. 7
        • 10. 12
        • 11. 15
        • 12. 16
        • 13. 17
        • 14. 21
        • 15. 24
        • 16. 25
        • 17. 33
        • 18. 35
        • 19. 40
        • 20. 42
        • 21. 43
        • 22. 44
        • 23. 45
        • 24. 41
        • 25. 48
        • 26. 50
        • 27. 54
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '9483' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750714763' and `end_time` >= '1750714763' limit 12.07msys_test
        Metadata
        Bindings
        • 0. 9483
        • 1. 1
        • 2. 1750714763
        • 3. 1750714763
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_miaosha_group_region` where `region_id` = '8'2.99msys_test
        Metadata
        Bindings
        • 0. 8
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `ecs_miaosha_group` where `start_time` <= '2025-06-24 05:39:23' and `end_time` > '2025-06-24 05:39:23' and `is_enabled` = '1' and isnull(delete_time) and `id` in ('2', '39', '1', '3', '4', '5', '7', '12', '15', '16', '17', '21', '24', '25', '33', '35', '40', '42', '43', '44', '45', '41', '48', '50', '54') limit 13.34msys_test
        Metadata
        Bindings
        • 0. 2025-06-24 05:39:23
        • 1. 2025-06-24 05:39:23
        • 2. 1
        • 3. 2
        • 4. 39
        • 5. 1
        • 6. 3
        • 7. 4
        • 8. 5
        • 9. 7
        • 10. 12
        • 11. 15
        • 12. 16
        • 13. 17
        • 14. 21
        • 15. 24
        • 16. 25
        • 17. 33
        • 18. 35
        • 19. 40
        • 20. 42
        • 21. 43
        • 22. 44
        • 23. 45
        • 24. 41
        • 25. 48
        • 26. 50
        • 27. 54
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '9611' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750714763' and `end_time` >= '1750714763' limit 12.22msys_test
        Metadata
        Bindings
        • 0. 9611
        • 1. 1
        • 2. 1750714763
        • 3. 1750714763
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select * from `ecs_miaosha_group_region` where `region_id` = '8'5.31msys_test
        Metadata
        Bindings
        • 0. 8
        Hints
        • Use SELECT * only if you need all columns from table
      • select * from `ecs_miaosha_group` where `start_time` <= '2025-06-24 05:39:23' and `end_time` > '2025-06-24 05:39:23' and `is_enabled` = '1' and isnull(delete_time) and `id` in ('2', '39', '1', '3', '4', '5', '7', '12', '15', '16', '17', '21', '24', '25', '33', '35', '40', '42', '43', '44', '45', '41', '48', '50', '54') limit 15.37msys_test
        Metadata
        Bindings
        • 0. 2025-06-24 05:39:23
        • 1. 2025-06-24 05:39:23
        • 2. 1
        • 3. 2
        • 4. 39
        • 5. 1
        • 6. 3
        • 7. 4
        • 8. 5
        • 9. 7
        • 10. 12
        • 11. 15
        • 12. 16
        • 13. 17
        • 14. 21
        • 15. 24
        • 16. 25
        • 17. 33
        • 18. 35
        • 19. 40
        • 20. 42
        • 21. 43
        • 22. 44
        • 23. 45
        • 24. 41
        • 25. 48
        • 26. 50
        • 27. 54
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select `cat_id`, `cat_name`, `sort_order` from `ecs_article_cat` where `cat_id` = '5' limit 12.3msys_test
        Metadata
        Bindings
        • 0. 5
        Hints
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      • select `cat_id`, `title`, `article_id`, `file_url`, `open_type`, `add_time`, `keywords` from `ecs_article` where `ecs_article`.`cat_id` in ('5') and `is_open` = '1' order by `article_type` desc, `article_id` desc limit 62.25msys_test
        Metadata
        Bindings
        • 0. 5
        • 1. 1
        _token
        2UyKUM4tqksZI4RhInt08XDqvLiJ3f7BWAVA2Nfc
        PHPDEBUGBAR_STACK_DATA
        []
        _previous
        array:1 [ "url" => "http://pc-test.bdyyw.com.cn/puyao?cat_id=1124&product_name=%E6%B5%99%E6%B1%9F%...
        flash
        array:2 [ "old" => [] "new" => [] ]
        format
        html
        content_type
        text/html; charset=UTF-8
        status_text
        OK
        status_code
        200
        request_query
        array:2 [ "product_name" => "上海运佳黄浦制药有限公司" "style" => "g" ]
        request_request
        array:2 [ "product_name" => "上海运佳黄浦制药有限公司" "style" => "g" ]
        request_headers
        array:13 [ "connection" => array:1 [ 0 => "keep-alive" ] "cache-control" => array:1 [ ...
        request_server
        array:38 [ "USER" => "apache" "HOME" => "/usr/share/httpd" "HTTP_CONNECTION" => "keep-alive" ...
        request_cookies
        array:2 [ "XSRF-TOKEN" => "2UyKUM4tqksZI4RhInt08XDqvLiJ3f7BWAVA2Nfc" "laravel_session_17" => "ae...
        response_headers
        array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "date" => array:1 [ 0 => "Mon...
        path_info
        /puyao
        session_attributes
        array:4 [ "_token" => "2UyKUM4tqksZI4RhInt08XDqvLiJ3f7BWAVA2Nfc" "PHPDEBUGBAR_STACK_DATA" => [] ...