Export large data

how to export large record around 10M from multi table with join and expression

You can get your hands on the actual query / PDO layer and even export data into file “INTO FILE”: https://dev.mysql.com/doc/refman/8.0/en/select-into.html

$dsql = $model->action(‘select’);

And check out documentation for DSQL (https://dsql.readthedocs.io/en/develop/queries.html#Query::$template_select)