| 2026-10-15 09:54:33.806 · INFO · cbg-trade · test |
| [user_trade_query.go:1192] [UserTradeQuery] data query ok source=clickhouse tables=weapon_7 returned=20 elapsed=212.777296ms › |
| 2026-10-15 09:54:33.593 · INFO · cbg-trade · test |
| [user_trade_query.go:1183] [UserTradeQuery] count ok source=clickhouse tables=weapon_7 total=500 raw_total=500 max_rows=1000 elapsed=105.744714ms › |
| 2026-10-15 09:54:33.593 · INFO · cbg-trade · test |
| [user_trade_query.go:1185] [UserTradeQuery] data sql source=clickhouse tables=weapon_7 sql="SELECT * FROM (SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_7' AS weapon_type, '双剑' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_7 WHERE status IN (?,?,?) AND has(splitByChar('|', special_effect), ?) AND level >= ? AND total_damage >= ?) ORDER BY sold_time DESC LIMIT 20 OFFSET 0" args=[4 5 6 永不磨损 140 800] › |
| 2026-10-15 09:54:33.487 · INFO · cbg-trade · test |
| [user_trade_query.go:1172] [UserTradeQuery] count sql source=clickhouse tables=weapon_7 sql="SELECT count() AS total FROM (SELECT * FROM (SELECT 1 AS matched FROM cbg_item.weapon_7 WHERE status IN (?,?,?) AND has(splitByChar('|', special_effect), ?) AND level >= ? AND total_damage >= ?) LIMIT 1000)" args=[4 5 6 永不磨损 140 800] › |
| 2026-10-15 09:54:33.487 · INFO · cbg-trade · test |
| [user_trade_query.go:497] [UserTradeQuery] start type=weapon source=clickhouse user_id=7 ip=60.28.105.10 raw_query="page=1&page_size=20&status=4,5,6&sort_field=sold_time&sort_order=desc&kind_id=7&level_min=140&effect=%E6%B0%B8%E4%B8%8D%E7%A3%A8%E6%8D%9F&total_damage_min=800&blessing_match_mode=all" filter={table="" server_id=0 server_age="" page=1 page_size=20 eid="" name="" status=- statuses=[4 5 6] selling_time_start=- selling_time_end=- sort_field="sold_time" sort_order="desc" equip_type="" kind_id=7 skill_count=-1 ranges=level:140..-,total_damage:800..- equals=- contains_all=special_effect:"永不磨损" contains_any=- excludes_any=-} › |
| 2026-10-15 09:54:32.914 · INFO · cbg-trade · test |
| [producer.go:173] [value-stats] producer buffer=0 sent=806 dropped=51 › |
| 2026-10-15 09:54:31.350 · INFO · cbg-trade · test |
| [user_trade_query.go:560] [UserTradeQuery] done type=weapon source=clickhouse user_id=7 ip=60.28.105.10 tables=weapon_7 total=500 returned=20 page=1 page_size=20 cost_score=40 free_score_used=0 score_before=84630 score_after=84590 free_score_before=0 free_score_after=0 hash=2c46ce8f4d8fbed2f07a251aa08f5d3e7b97d638 elapsed=898.999889ms filter={table="" server_id=0 server_age="" page=1 page_size=20 eid="" name="" status=- statuses=[4 5 6] selling_time_start=- selling_time_end=- sort_field="price" sort_order="asc" equip_type="" kind_id=7 skill_count=-1 ranges=level:140..-,total_damage:800..- equals=- contains_all=special_effect:"永不磨损" contains_any=- excludes_any=-} › |
| 2026-10-15 09:54:31.038 · INFO · cbg-trade · test |
| [user_trade_query.go:1192] [UserTradeQuery] data query ok source=clickhouse tables=weapon_7 returned=20 elapsed=449.361808ms › |
| 2026-10-15 09:54:30.589 · INFO · cbg-trade · test |
| [user_trade_query.go:1183] [UserTradeQuery] count ok source=clickhouse tables=weapon_7 total=500 raw_total=500 max_rows=1000 elapsed=109.502488ms › |
| 2026-10-15 09:54:30.589 · INFO · cbg-trade · test |
| [user_trade_query.go:1185] [UserTradeQuery] data sql source=clickhouse tables=weapon_7 sql="SELECT * FROM (SELECT\n\t\t\tid, eid, server_id, kind_id, name, price, selling_time, level,\n\t\t\tdurability, fail, gem_upgrade, gem_type, open_count,\n\t\t\tstrength, agility, magic, body, stamina,\n\t\t\tspecial_skill, special_effect, suit_skill,\n\t\t\t0 AS defense, 0 AS mp, 0 AS blood, 0 AS spirit,\n\t\t\thit, damage, total_damage, total_init_damage,\n\t\t\t0 AS attack, 0 AS speed, 0 AS magic_attack, 0 AS magic_defense,\n\t\t\t0 AS potential, 0 AS is_baby, 0 AS bianyi_type,\n\t\t\t0 AS attack_quality, 0 AS defense_quality, 0 AS body_quality, 0 AS magic_quality,\n\t\t\t0 AS speed_quality, 0 AS hide_quality, 0 AS history_spirit, 0 AS life, 0 AS growth,\n\t\t\t0 AS skill_count, 0 AS skill_score,\n\t\t\t'' AS inner_dan, '' AS feature, '' AS blessing, '' AS skills, '' AS equip_skill,\n\t\t\t'' AS equip_type, '' AS equip_type_label, 'weapon_7' AS weapon_type, '双剑' AS weapon_type_label,\n\t\t\tstatus, status_update_time, status_error_code,\n\t\t\tspecial_skill_grade, special_effect_grade, suit_grade,\n\t\t\tcreated_at, sold_time,\n\t\t\t'' AS tag, 0 AS is_four_blessing, '' AS equip_gem_level, '' AS inner_dan_level,\n\t\t\telimate_price, elimate_rate, effect160, effect160_value\n\t\tFROM cbg_item.weapon_7 WHERE status IN (?,?,?) AND has(splitByChar('|', special_effect), ?) AND level >= ? AND total_damage >= ?) ORDER BY price ASC LIMIT 20 OFFSET 0" args=[4 5 6 永不磨损 140 800] › |
| 2026-10-15 09:54:30.479 · INFO · cbg-trade · test |
| [user_trade_query.go:1172] [UserTradeQuery] count sql source=clickhouse tables=weapon_7 sql="SELECT count() AS total FROM (SELECT * FROM (SELECT 1 AS matched FROM cbg_item.weapon_7 WHERE status IN (?,?,?) AND has(splitByChar('|', special_effect), ?) AND level >= ? AND total_damage >= ?) LIMIT 1000)" args=[4 5 6 永不磨损 140 800] › |
| 2026-10-15 09:54:30.479 · INFO · cbg-trade · test |
| [user_trade_query.go:497] [UserTradeQuery] start type=weapon source=clickhouse user_id=7 ip=60.28.105.10 raw_query="page=1&page_size=20&status=4,5,6&sort_field=price&sort_order=asc&save_history=1&kind_id=7&level_min=140&effect=%E6%B0%B8%E4%B8%8D%E7%A3%A8%E6%8D%9F&total_damage_min=800&blessing_match_mode=all" filter={table="" server_id=0 server_age="" page=1 page_size=20 eid="" name="" status=- statuses=[4 5 6] selling_time_start=- selling_time_end=- sort_field="price" sort_order="asc" equip_type="" kind_id=7 skill_count=-1 ranges=level:140..-,total_damage:800..- equals=- contains_all=special_effect:"永不磨损" contains_any=- excludes_any=-} › |
| 2026-10-15 09:54:19.795 · INFO · cbg-trade · test |
| [eidtype.go:91] [eid_type] upstream lookup succeeded, eid=202610150800113-821-X51UK0PQ17GD server_id=821 reason=value status=1 status_code=OK kind_id=30 equip_type=3740 listing_status=2 › |
| 2026-10-15 09:54:16.386 · INFO · cbg-trade · test |
| [eidtype.go:91] [eid_type] upstream lookup succeeded, eid=202610150900113-352-DVH3UZBF4EYM server_id=352 reason=value status=1 status_code=OK kind_id=35 equip_type=3745 listing_status=2 › |
| 2026-10-15 09:54:16.092 · INFO · cbg-trade · test |
| [random_push_review.go:194] role get random push review, token: DTHF-NURN-3826-3772 › |
| 2026-10-15 09:54:13.142 · INFO · cbg-trade · test |
| [update.go:187] update success › |
| 2026-10-15 09:54:13.142 · ERROR · cbg-trade · test |
| [update.go:129] [47/52] worker 1 failed to get item detail, eid: 202610122200113-212-PWRT5QWXSI1D, server_id: 212, err: [itemdetail getEquipDetailInternal] failed to get equip detail, item 202610122200113-212-PWRT5QWXSI1D › |
| 2026-10-15 09:54:13.142 · INFO · cbg-trade · test |
| [main.go:59] Server exit, [0.15 minutes] elapsed › |
| 2026-10-15 09:54:13.142 · INFO · cbg-trade · test |
| [update.go:172] updated 46/52 random push reviews › |
| 2026-10-15 09:54:13.137 · ERROR · cbg-trade · test |
| [update.go:129] [46/52] worker 2 failed to get item detail, eid: 202610150800113-527-FJVXO6HGZBY7, server_id: 527, err: [itemdetail getEquipDetailInternal] failed to get equip detail, item 202610150800113-527-FJVXO6HGZBY7 › |