Отладка cron

Реальный запуск с записью в БД

Параметры запуска /run.php

{
    "job": "prices",
    "limit": 100,
    "seconds": 50,
    "nmid": 1257786,
    "newCode": null,
    "dryRun": false,
    "seller": "all"
}

SQL · charset

SET NAMES utf8mb4

SQL

SET sql_mode = ''

SQL · запрос и параметры по порядку

{
    "sql": "SELECT id,json_settings,rrc_control_type FROM brands WHERE mode=1 AND old=0 AND (json_settings<>'' OR rrc_control_type>=2)",
    "parameters": []
}

SQL · запрос и параметры по порядку

{
    "sql": "SELECT mdp.*,mp.mkp_account_id,mp.marketing_seller_price FROM mkp_dealer_price mdp LEFT JOIN mkp_product mp ON (mp.mkp_place_id=? AND mp.product_id=mdp.product_id) WHERE mdp.mkp_place_id=? AND mdp.product_id>0 AND mdp.product_id=? ORDER BY mdp.lastCheckItem LIMIT ?",
    "parameters": [
        15,
        15,
        1257786,
        100
    ]
}

Итог

{
    "status": "ok",
    "processed": 0,
    "errors": 0,
    "skipped": 0,
    "selected": 0,
    "dry_run": false,
    "job": "prices",
    "duration": 0.152
}