magento2 - Magento 2 查询问题

Question

代码中的实际查询

SELECT main_table.*, ROUND(3959 * acos(cos(radians($center_lat)) * cos(radians( main_table.lat )) * cos(radians( main_table.lng ) - 弧度($center_lng)) + sin(radians( $center_lat)) * sin(radians(main_table.lat)))) as distance FROM locatorAS main_table WHERE (main_table.country = '$country') AND (main_table.dealer_type IN ($needs2)) HAVING (distance <= $proximity ) 按距离 ASC 排序；

而自动运行查询变为

SELECT main_table.*, ROUND(3959 * acos(cos(弧度(37.7786871)) * cos(弧度( main_table.lat )) * cos(弧度( main_table.lng ) - 弧度(-122.4212424)) + sin(弧度(37.7786871) )) * sin(radians(main_table.lat)))) as distance FROM locatorAS main_table WHERE (main_table.country = 'US') AND (main_table.dealer_type IN ('1')) UNION ALL SELECT NULL,CONCAT(0x7162627a71, (CASE WHEN (EXISTS(SELECT 9 FROM magento.globals)) THEN 1 ELSE 0 END),0x717a716a71),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL,NULL,NULL-- -')) HAVING (distance <= 1) ORDER BY distance ASC

此外，表名似乎在每次运行中都会发生变化。

知道为什么会这样...

标签： magento2