2026-10-21 07:26:25.162 UTC [46982] LOG:  duration: 392.945 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 07:26:25.162 UTC [46982] DETAIL:  Parameters: $1 = '%韩小圈%', $2 = '%韩小圈%', $3 = '%韩小圈%', $4 = '%韩小圈%', $5 = '韩小圈', $6 = '韩小圈', $7 = '韩小圈', $8 = '韩小圈'
2026-10-21 07:38:42.426 UTC [46982] LOG:  duration: 789.238 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 07:38:42.426 UTC [46982] DETAIL:  Parameters: $1 = '%植物大战僵尸%', $2 = '%植物大战僵尸%', $3 = '%植物大战僵尸%', $4 = '%植物大战僵尸%', $5 = '植物大战僵尸', $6 = '植物大战僵尸', $7 = '植物大战僵尸', $8 = '植物大战僵尸'
2026-10-21 07:55:58.115 UTC [46982] LOG:  duration: 1091.642 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 07:55:58.115 UTC [46982] DETAIL:  Parameters: $1 = '%8484公交%', $2 = '%8484公交%', $3 = '%8484公交%', $4 = '%8484公交%', $5 = '8484公交', $6 = '8484公交', $7 = '8484公交', $8 = '8484公交'
2026-10-21 07:55:58.457 UTC [46982] LOG:  duration: 329.126 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 07:55:58.457 UTC [46982] DETAIL:  Parameters: $1 = '%植物大战僵尸%', $2 = '%植物大战僵尸%', $3 = '%植物大战僵尸%', $4 = '%植物大战僵尸%', $5 = '植物大战僵尸', $6 = '植物大战僵尸', $7 = '植物大战僵尸', $8 = '植物大战僵尸'
2026-10-21 07:56:21.923 UTC [46982] LOG:  duration: 353.589 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 07:56:21.923 UTC [46982] DETAIL:  Parameters: $1 = '%8484公交%', $2 = '%8484公交%', $3 = '%8484公交%', $4 = '%8484公交%', $5 = '8484公交', $6 = '8484公交', $7 = '8484公交', $8 = '8484公交'
2026-10-21 07:56:22.268 UTC [46982] LOG:  duration: 330.606 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 07:56:22.268 UTC [46982] DETAIL:  Parameters: $1 = '%电信营业厅%', $2 = '%电信营业厅%', $3 = '%电信营业厅%', $4 = '%电信营业厅%', $5 = '电信营业厅', $6 = '电信营业厅', $7 = '电信营业厅', $8 = '电信营业厅'
2026-10-21 07:56:36.615 UTC [46982] LOG:  duration: 539.059 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 07:56:36.615 UTC [46982] DETAIL:  Parameters: $1 = '%电信营业厅%', $2 = '%电信营业厅%', $3 = '%电信营业厅%', $4 = '%电信营业厅%', $5 = '电信营业厅', $6 = '电信营业厅', $7 = '电信营业厅', $8 = '电信营业厅'
2026-10-21 07:56:37.056 UTC [46982] LOG:  duration: 431.339 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 07:56:37.056 UTC [46982] DETAIL:  Parameters: $1 = '%中国电信%', $2 = '%中国电信%', $3 = '%中国电信%', $4 = '%中国电信%', $5 = '中国电信', $6 = '中国电信', $7 = '中国电信', $8 = '中国电信'
2026-10-21 08:01:36.890 UTC [46982] LOG:  duration: 321.631 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:01:36.890 UTC [46982] DETAIL:  Parameters: $1 = '%春雨%', $2 = '%春雨%', $3 = '%春雨%', $4 = '%春雨%', $5 = '春雨', $6 = '春雨', $7 = '春雨', $8 = '春雨'
2026-10-21 08:01:50.302 UTC [46982] LOG:  duration: 376.493 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:01:50.302 UTC [46982] DETAIL:  Parameters: $1 = '%春雨%', $2 = '%春雨%', $3 = '%春雨%', $4 = '%春雨%', $5 = '春雨', $6 = '春雨', $7 = '春雨', $8 = '春雨'
2026-10-21 08:01:50.612 UTC [46982] LOG:  duration: 300.666 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:01:50.612 UTC [46982] DETAIL:  Parameters: $1 = '%掌上药店%', $2 = '%掌上药店%', $3 = '%掌上药店%', $4 = '%掌上药店%', $5 = '掌上药店', $6 = '掌上药店', $7 = '掌上药店', $8 = '掌上药店'
2026-10-21 08:02:37.142 UTC [46982] LOG:  duration: 565.909 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:02:37.142 UTC [46982] DETAIL:  Parameters: $1 = '%掌上药店%', $2 = '%掌上药店%', $3 = '%掌上药店%', $4 = '%掌上药店%', $5 = '掌上药店', $6 = '掌上药店', $7 = '掌上药店', $8 = '掌上药店'
2026-10-21 08:02:37.501 UTC [46982] LOG:  duration: 332.646 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:02:37.501 UTC [46982] DETAIL:  Parameters: $1 = '%安全支付%', $2 = '%安全支付%', $3 = '%安全支付%', $4 = '%安全支付%', $5 = '安全支付', $6 = '安全支付', $7 = '安全支付', $8 = '安全支付'
2026-10-21 08:02:56.141 UTC [46982] LOG:  duration: 467.960 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:02:56.141 UTC [46982] DETAIL:  Parameters: $1 = '%安全支付%', $2 = '%安全支付%', $3 = '%安全支付%', $4 = '%安全支付%', $5 = '安全支付', $6 = '安全支付', $7 = '安全支付', $8 = '安全支付'
2026-10-21 08:02:56.606 UTC [46982] LOG:  duration: 441.895 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:02:56.606 UTC [46982] DETAIL:  Parameters: $1 = '%好看视频%', $2 = '%好看视频%', $3 = '%好看视频%', $4 = '%好看视频%', $5 = '好看视频', $6 = '好看视频', $7 = '好看视频', $8 = '好看视频'
2026-10-21 08:03:13.111 UTC [46982] LOG:  duration: 565.467 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:03:13.111 UTC [46982] DETAIL:  Parameters: $1 = '%好看视频%', $2 = '%好看视频%', $3 = '%好看视频%', $4 = '%好看视频%', $5 = '好看视频', $6 = '好看视频', $7 = '好看视频', $8 = '好看视频'
2026-10-21 08:03:13.483 UTC [46982] LOG:  duration: 360.988 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:03:13.483 UTC [46982] DETAIL:  Parameters: $1 = '%捕鱼达人%', $2 = '%捕鱼达人%', $3 = '%捕鱼达人%', $4 = '%捕鱼达人%', $5 = '捕鱼达人', $6 = '捕鱼达人', $7 = '捕鱼达人', $8 = '捕鱼达人'
2026-10-21 08:03:24.903 UTC [46982] LOG:  duration: 413.422 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:03:24.903 UTC [46982] DETAIL:  Parameters: $1 = '%捕鱼达人%', $2 = '%捕鱼达人%', $3 = '%捕鱼达人%', $4 = '%捕鱼达人%', $5 = '捕鱼达人', $6 = '捕鱼达人', $7 = '捕鱼达人', $8 = '捕鱼达人'
2026-10-21 08:03:25.505 UTC [46982] LOG:  duration: 592.372 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:03:25.505 UTC [46982] DETAIL:  Parameters: $1 = '%遥控器%', $2 = '%遥控器%', $3 = '%遥控器%', $4 = '%遥控器%', $5 = '遥控器', $6 = '遥控器', $7 = '遥控器', $8 = '遥控器'
2026-10-21 08:04:01.805 UTC [46982] LOG:  duration: 527.474 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:04:01.805 UTC [46982] DETAIL:  Parameters: $1 = '%遥控器%', $2 = '%遥控器%', $3 = '%遥控器%', $4 = '%遥控器%', $5 = '遥控器', $6 = '遥控器', $7 = '遥控器', $8 = '遥控器'
2026-10-21 08:04:02.300 UTC [46982] LOG:  duration: 478.270 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:04:02.300 UTC [46982] DETAIL:  Parameters: $1 = '%保卫萝卜%', $2 = '%保卫萝卜%', $3 = '%保卫萝卜%', $4 = '%保卫萝卜%', $5 = '保卫萝卜', $6 = '保卫萝卜', $7 = '保卫萝卜', $8 = '保卫萝卜'
2026-10-21 08:04:15.734 UTC [46982] LOG:  duration: 382.916 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:04:15.734 UTC [46982] DETAIL:  Parameters: $1 = '%保卫萝卜%', $2 = '%保卫萝卜%', $3 = '%保卫萝卜%', $4 = '%保卫萝卜%', $5 = '保卫萝卜', $6 = '保卫萝卜', $7 = '保卫萝卜', $8 = '保卫萝卜'
2026-10-21 08:04:16.138 UTC [46982] LOG:  duration: 393.777 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:04:16.138 UTC [46982] DETAIL:  Parameters: $1 = '%神庙逃亡%', $2 = '%神庙逃亡%', $3 = '%神庙逃亡%', $4 = '%神庙逃亡%', $5 = '神庙逃亡', $6 = '神庙逃亡', $7 = '神庙逃亡', $8 = '神庙逃亡'
2026-10-21 08:11:25.582 UTC [46982] LOG:  duration: 682.542 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:11:25.582 UTC [46982] DETAIL:  Parameters: $1 = '%小象超市%', $2 = '%小象超市%', $3 = '%小象超市%', $4 = '%小象超市%', $5 = '小象超市', $6 = '小象超市', $7 = '小象超市', $8 = '小象超市'
2026-10-21 08:11:26.113 UTC [46982] LOG:  duration: 508.442 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:11:26.113 UTC [46982] DETAIL:  Parameters: $1 = '%神庙逃亡%', $2 = '%神庙逃亡%', $3 = '%神庙逃亡%', $4 = '%神庙逃亡%', $5 = '神庙逃亡', $6 = '神庙逃亡', $7 = '神庙逃亡', $8 = '神庙逃亡'
2026-10-21 08:11:27.800 UTC [46982] LOG:  duration: 332.625 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:11:27.800 UTC [46982] DETAIL:  Parameters: $1 = '%小象超市%', $2 = '%小象超市%', $3 = '%小象超市%', $4 = '%小象超市%', $5 = '小象超市', $6 = '小象超市', $7 = '小象超市', $8 = '小象超市'
2026-10-21 08:12:03.790 UTC [46982] LOG:  duration: 797.356 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:12:03.790 UTC [46982] DETAIL:  Parameters: $1 = '%小象超市%', $2 = '%小象超市%', $3 = '%小象超市%', $4 = '%小象超市%', $5 = '小象超市', $6 = '小象超市', $7 = '小象超市', $8 = '小象超市'
2026-10-21 08:14:13.476 UTC [46982] LOG:  duration: 756.747 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:14:13.476 UTC [46982] DETAIL:  Parameters: $1 = '%小象超市%', $2 = '%小象超市%', $3 = '%小象超市%', $4 = '%小象超市%', $5 = '小象超市', $6 = '小象超市', $7 = '小象超市', $8 = '小象超市'
2026-10-21 08:21:18.182 UTC [46982] LOG:  duration: 638.349 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:21:18.182 UTC [46982] DETAIL:  Parameters: $1 = '%千问%', $2 = '%千问%', $3 = '%千问%', $4 = '%千问%', $5 = '千问', $6 = '千问', $7 = '千问', $8 = '千问'
2026-10-21 08:22:12.027 UTC [46982] LOG:  duration: 390.558 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:22:12.027 UTC [46982] DETAIL:  Parameters: $1 = '%千问%', $2 = '%千问%', $3 = '%千问%', $4 = '%千问%', $5 = '千问', $6 = '千问', $7 = '千问', $8 = '千问'
2026-10-21 08:22:12.337 UTC [46982] LOG:  duration: 297.241 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:22:12.337 UTC [46982] DETAIL:  Parameters: $1 = '%天眼查%', $2 = '%天眼查%', $3 = '%天眼查%', $4 = '%天眼查%', $5 = '天眼查', $6 = '天眼查', $7 = '天眼查', $8 = '天眼查'
2026-10-21 08:22:27.620 UTC [46982] LOG:  duration: 307.387 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:22:27.620 UTC [46982] DETAIL:  Parameters: $1 = '%天眼查%', $2 = '%天眼查%', $3 = '%天眼查%', $4 = '%天眼查%', $5 = '天眼查', $6 = '天眼查', $7 = '天眼查', $8 = '天眼查'
2026-10-21 08:29:25.545 UTC [46982] LOG:  duration: 121.414 ms  execute <unnamed>: SELECT COUNT("app_infos"."id") AS "aggregate" FROM "app_infos"
2026-10-21 08:31:41.040 UTC [46982] LOG:  duration: 145.706 ms  execute <unnamed>: SELECT COUNT("app_infos"."id") AS "aggregate" FROM "app_infos"
2026-10-21 08:53:25.619 UTC [46982] LOG:  duration: 205.208 ms  execute <unnamed>: SELECT COUNT("app_infos"."id") AS "aggregate" FROM "app_infos"
2026-10-21 08:55:15.077 UTC [46982] LOG:  duration: 1125.366 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:55:15.077 UTC [46982] DETAIL:  Parameters: $1 = '%航空%', $2 = '%航空%', $3 = '%航空%', $4 = '%航空%', $5 = '航空', $6 = '航空', $7 = '航空', $8 = '航空'
2026-10-21 08:56:40.943 UTC [46982] LOG:  duration: 385.152 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:56:40.943 UTC [46982] DETAIL:  Parameters: $1 = '%航空%', $2 = '%航空%', $3 = '%航空%', $4 = '%航空%', $5 = '航空', $6 = '航空', $7 = '航空', $8 = '航空'
2026-10-21 08:56:41.315 UTC [46982] LOG:  duration: 361.519 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:56:41.315 UTC [46982] DETAIL:  Parameters: $1 = '%t3%', $2 = '%t3%', $3 = '%t3%', $4 = '%t3%', $5 = 't3', $6 = 't3', $7 = 't3', $8 = 't3'
2026-10-21 08:57:13.860 UTC [46982] LOG:  duration: 402.279 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:57:13.860 UTC [46982] DETAIL:  Parameters: $1 = '%t3%', $2 = '%t3%', $3 = '%t3%', $4 = '%t3%', $5 = 't3', $6 = 't3', $7 = 't3', $8 = 't3'
2026-10-21 08:57:14.329 UTC [46982] LOG:  duration: 460.104 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:57:14.329 UTC [46982] DETAIL:  Parameters: $1 = '%东方%', $2 = '%东方%', $3 = '%东方%', $4 = '%东方%', $5 = '东方', $6 = '东方', $7 = '东方', $8 = '东方'
2026-10-21 08:59:09.273 UTC [46982] LOG:  duration: 930.130 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:59:09.273 UTC [46982] DETAIL:  Parameters: $1 = '%东方%', $2 = '%东方%', $3 = '%东方%', $4 = '%东方%', $5 = '东方', $6 = '东方', $7 = '东方', $8 = '东方'
2026-10-21 08:59:09.933 UTC [46982] LOG:  duration: 639.659 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:59:09.933 UTC [46982] DETAIL:  Parameters: $1 = '%南方%', $2 = '%南方%', $3 = '%南方%', $4 = '%南方%', $5 = '南方', $6 = '南方', $7 = '南方', $8 = '南方'
2026-10-21 08:59:47.263 UTC [46982] LOG:  duration: 429.683 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:59:47.263 UTC [46982] DETAIL:  Parameters: $1 = '%南方%', $2 = '%南方%', $3 = '%南方%', $4 = '%南方%', $5 = '南方', $6 = '南方', $7 = '南方', $8 = '南方'
2026-10-21 08:59:47.830 UTC [46982] LOG:  duration: 558.065 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-21 08:59:47.830 UTC [46982] DETAIL:  Parameters: $1 = '%四川%', $2 = '%四川%', $3 = '%四川%', $4 = '%四川%', $5 = '四川', $6 = '四川', $7 = '四川', $8 = '四川'
2026-10-21 10:18:32.058 UTC [46982] LOG:  duration: 421.530 ms  execute <unnamed>: SELECT COUNT("app_infos"."id") AS "aggregate" FROM "app_infos"
2026-10-22 03:50:31.786 UTC [46982] LOG:  duration: 335.285 ms  execute <unnamed>: SELECT COUNT("app_infos"."id") AS "aggregate" FROM "app_infos"
2026-10-26 00:12:38.268 UTC [46982] LOG:  duration: 343.574 ms  execute <unnamed>: SELECT COUNT("app_infos"."id") AS "aggregate" FROM "app_infos"
2026-10-28 07:08:49.583 UTC [46982] LOG:  duration: 290.471 ms  execute <unnamed>: SELECT COUNT("app_infos"."id") AS "aggregate" FROM "app_infos"
2026-10-28 07:08:58.194 UTC [46982] LOG:  duration: 494.918 ms  execute <unnamed>: SELECT "app_infos"."id" AS "app_info_id", COUNT(*) OVER() AS "total_count" FROM "app_infos" LEFT JOIN "app_localized_names" ON "app_localized_names"."app_info_id" = "app_infos"."id" WHERE "app_infos"."default_name" ILIKE $1 OR "app_infos"."package_name" ILIKE $2 OR "app_infos"."main_activity" ILIKE $3 OR "app_localized_names"."name" ILIKE $4 GROUP BY "app_infos"."id" ORDER BY MAX(GREATEST(COALESCE(similarity("app_infos"."default_name", $5), 0), COALESCE(similarity("app_infos"."package_name", $6), 0), COALESCE(similarity("app_infos"."main_activity", $7), 0), COALESCE(similarity("app_localized_names"."name", $8), 0))) DESC, "app_infos"."count" DESC LIMIT 25 OFFSET 0
2026-10-28 07:08:58.194 UTC [46982] DETAIL:  Parameters: $1 = '%bubblegum%', $2 = '%bubblegum%', $3 = '%bubblegum%', $4 = '%bubblegum%', $5 = 'bubblegum', $6 = 'bubblegum', $7 = 'bubblegum', $8 = 'bubblegum'
2026-11-01 01:03:32.138 UTC [46982] LOG:  duration: 273.945 ms  execute <unnamed>: SELECT COUNT("app_infos"."id") AS "aggregate" FROM "app_infos"
2026-11-01 18:15:07.284 UTC [1] LOG:  received fast shutdown request
2026-11-01 18:15:07.307 UTC [1] LOG:  aborting any active transactions
2026-11-01 18:15:07.418 UTC [46982] FATAL:  terminating connection due to administrator command
2026-11-01 18:15:07.993 UTC [1] LOG:  background worker "logical replication launcher" (PID 29) exited with exit code 1
2026-11-01 18:15:08.000 UTC [24] LOG:  shutting down
2026-11-01 18:15:08.026 UTC [24] LOG:  checkpoint starting: shutdown immediate
2026-11-01 18:15:08.256 UTC [24] LOG:  checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.191 s, sync=0.002 s, total=0.254 s; sync files=2, longest=0.002 s, average=0.001 s; distance=0 kB, estimate=2090 kB; lsn=0/1F38CD10, redo lsn=0/1F38CD10
2026-11-01 18:15:08.441 UTC [1] LOG:  database system is shut down