set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.012355s ]
select version() [ RunTime:0.000609s ]
show COLUMNS FROM dr_1_store_category_data [ RunTime:0.001951s ]
SELECT count(*) as c FROM `dr_1_store` LEFT JOIN dr_1_store_category_data ON `dr_1_store_category_data`.`id`=`dr_1_store`.`id` WHERE (`dr_1_store`.`catid` = 21 OR (`dr_1_store`.`catids` <>'' AND JSON_CONTAINS (`dr_1_store`.`catids`->'$[*]', '"21"', '$'))) ORDER BY NULL [ RunTime:0.002205s ]
SELECT `dr_1_store`.* FROM `dr_1_store` LEFT JOIN dr_1_store_category_data ON `dr_1_store_category_data`.`id`=`dr_1_store`.`id` WHERE (`dr_1_store`.`catid` = 21 OR (`dr_1_store`.`catids` <>'' AND JSON_CONTAINS (`dr_1_store`.`catids`->'$[*]', '"21"', '$'))) ORDER BY `dr_1_store`.`displayorder` DESC LIMIT 0,20 [ RunTime:0.002524s ]
