set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.000238s ]
select version() [ RunTime:0.000357s ]
SELECT count(*) as c FROM `dr_1_store` WHERE (`dr_1_store`.`catid` = 21 OR (`dr_1_store`.`catids` <>'' AND JSON_CONTAINS (`dr_1_store`.`catids`->'$[*]', '"21"', '$'))) AND is_sale=1 ORDER BY NULL [ RunTime:0.000832s ]
SELECT * FROM `dr_1_store` WHERE (`dr_1_store`.`catid` = 21 OR (`dr_1_store`.`catids` <>'' AND JSON_CONTAINS (`dr_1_store`.`catids`->'$[*]', '"21"', '$'))) AND is_sale=1 ORDER BY `dr_1_store`.`updatetime` DESC LIMIT 0,20 [ RunTime:0.000944s ]
